Php extract data sql script jobs

...my WhatsApp automation. Specifically, I'm unable to send messages. The automation is running on Windows and the script is written in Node.js. Key requirements: - Diagnose and fix the issue: The core problem lies in the inability to send messages. As such, the ideal candidate should have a strong understanding of OpenCV and related concepts, as well as experience with automation on WhatsApp. They should be able to quickly pinpoint the issue and implement the appropriate solution. - Windows proficiency: The automation is running on a Windows platform. The ideal candidate should be familiar with the quirks and intricacies of automation on this OS. - Node.js expertise: The script is written in Node.js. The freelancer should have comprehensive experience with this lang...

Please develop a Python script to retrieve restaurant data from Google Maps using the Maps/Places API. The script should specifically target restaurants that have a phone number but *without* a website. The inputs I need to enter are: - Location (latitude and longitude) - Search Radius (meters) - Restaurant Type (including catch all types in the "Food and Drink" category) Key Data to Retrieve, output in a .CSV: - Name - Address - Phone Number - Google Maps URL Ideal skillset: - Proficient in Python - Strong experience with Google Maps/Places API - Ability to deliver results promptly and efficiently - Attention to detail to ensure accurate data retrieval

I am seeking a PHP developer to bring my interactive website vision to life. Key Project Requirements: - The website will require interactive features, enhancing user engagement and experience. - The project demands a high level of proficiency in PHP, as this language will be the backbone of the site. - Skills in HTML, CSS, and potentially JavaScript will also be required to ensure a seamless and visually appealing interface. Ideal Candidate: - Proven experience in developing interactive websites using PHP. - Strong knowledge of front-end technologies to ensure a responsive and visually appealing design. - Excellent communication skills and the ability to understand and translate my vision into a functional website.

...proficient in Angular and PHP, with previous experience in integrating new features. This is for a project that involves: - Frontend Development: Enhancements and integration of Angular components into an existing website/application. - Backend Development: Implementation of necessary PHP functionalities to support the new features and ensure smooth operation of the site/application. - Database Integration: Synchronization of the updated features with the database, and ensuring consistent data flow and storage. The primary goal is to integrate CMS features into the existing system. Your role will include planning, execution, and testing to ensure that the new features are successfully integrated. Ideal candidates should have: - Strong knowledge and experience in...

I am looking for a skilled freelancer to help me compile personalized information from a list of 400 LinkedIn prospects. The list includes their LinkedIn profile URL, email, phone, name, current employer, current title, industry, location, and company size. Project Requirements: 1) Review each LinkedIn profile. 2) Extract three pieces of personal information about the prospect that a friend might know. This could include: - Interests or hobbies - Recent achievements or career milestones - Personal anecdotes or notable mentions in bio or recommendation Deliverables: - A completed spreadsheet with the extracted information for all 400 prospects. - The information should be concise, relevant, and suitable for use in a personalized outreach message. *Opportunity for ongoing work. ...

I'm looking for a talented 2D animator who can create 3 engaging and entertaining videos, each lasting between 45-60 seconds. The primary goal of these videos is to captivate and entertain the audience. Key Responsibilities: - Develop 3 separate videos in a minimalist animation style - Ensure the videos are engaging and entertaining throughout - Incorporate the ready-made script seamlessly Ideal Freelancer: - Proven experience in 2D animation and motion graphics - Capable of creating entertaining and engaging content - Proficient in working with ready-made scripts - Prior experience with minimalist animation is a plus Brief Documents for 3 Video's Below: Video 1 - Annuity Payout Options: Video

I need a PHP expert to help me fix a translation bug in my system. - The issue specifically affects the English language version of my website, disrupting various interface labels. - It's essential the freelancer is proficient in identifying and rectifying translation bugs in PHP. Your expertise will be invaluable in ensuring my platform is user-friendly and accessible to all English speakers.

I'm in need of a PHP page that helps our agents to send an order. This page should be intuitive and user-friendly while ensuring all necessary information is captured. The platform should be interactive and user-friendly, ensuring a smooth order submission process for our agents. Ideal Skills: - Proficient in PHP - Strong experience in web development - Knowledge in creating secure web forms - Experience in agent-based systems would be a plus Please bid for this project if you believe you have the skills and experience needed to deliver a high-quality, efficient, and secure PHP page for our agents. Our customer sells products (not online, but in shop). He wants to receive orders from agents. I have an excel file containing the products that he wants to sell....

I'm in need of a skilled and experienced developer that can assist me in automating several tasks, organizing files and data on Google Drive using Google App Script and Java programming language. Key Tasks: - Create scripts to automate Folders and files - Improve file organization and management on Google Drive - Develop custom solutions using Java Ideal Skills: - Proficient in Google App Script and Java - Strong background in automating tasks - Proven experience in organizing and managing files - Prior experience with Google Drive is a plus Your expertise and knowledge in these areas are crucial for the success of this project. Looking forward to collaborating with a proactive and skilled developer.

Please Sign Up or Login to see details.

...specific table from a website for me (Website: ). The table contains WNBA player statistics, The goal is to extract all columns of this table, which is approximately 7 columns and write it to a CSV file (in the same column format). I'm a beginner level coder, and noticed that the table was created with that looks like a Shiny App in R. (I'm not even sure if extracting the table is possible). If it was only possible to use R, then I could potentially work with that. Website: I would like the data to go from the year 2020 to current. Regular Season data. Key Requirements: - Scraping Tables on websites If you're confident in your web scraping abilities, have good experience with Python, and can ensure

I need a VRBO scraper to extract property details, pricing, and availability. - The scraper should be built with Python and the output should be in CSV format. - The data points I need include property title, description, amenities, pricing, and availability. - The scraper should be able to handle multiple URLs at once. - The code should be well-structured and commented for easy maintenance. Ideal skills: - Proficiency in Python - Experience in web scraping - Understanding of VRBO website structure - Ability to handle and store data in CSV format

I need a web scraping professional to create a script to extract specific data from , a popular online marketplace for trading cards, please check attachement to get the idea. Key Requirements: - Scrapping: The primary task is to scrape the following information from the platform: - Card properties 1. Hero score for last 7 days 2. Hero rank for last 7 days 3. Stars 4. Rarity 5. Name 6. Quantity listed to purchase 7. Inflation data 8. Minted count - Buy prices List Price Last Price Order book (price and quantity see picture attached) - Bidding details bids book (bid and quantity see picture attached) - Twitter activity per card View Views+ Likes Likes+ Retweets Retweets+ Replies Replies+ Quotes Quotes+ Bookmarks Bookmarks+

I'm seeking a Python developer experienced with web scraping. This job involves setting up a Python script that can scrape a popular review site. Key details to extract: - Review text - Star rating - Date of review - Reviewer name - Star-ratings for sub-categories - Review ID - Reviewed person - Reviewed product name The site does not use captchas, so it should be reasonably straightforward. All reviews for a given provider should be scraped. It would be good to have an option to start with the newest and stop at a certain date. The specific review site can be seen in the sample URL in the attached PDF. I can send further details in a private message including screenshots. Preferred frameworks would be Beautifoulsoup 4 / Scrapy if sufficient and Selenium otherwise....

I'm looking for a skilled developer who can create a custom trading script in Pinescript on the TradingView platform. This script will be based on identifying and monitoring market trends. Key Project Details: - The script should be able to accurately identify a trend based on the definition of "higher highs and higher lows". - When a trend is identified, the script should take no immediate action but continue to monitor the market conditions. Ideal Skills and Experience: - Proficiency in Pine Script and experience with TradingView platform. - Strong understanding of technical analysis, particularly in the context of identifying trends. - Previous experience in developing trading scripts or bots is highly advantageous. - A background in ...

Create a tradingview script that: Show a candle from green >red>green and vice versa but the condition that second candele cannot close lower or higher than prior third candele cannot close under previous open.

I'm looking for a skilled developer who can create a custom trading script in Pinescript on the TradingView platform. This script will be based on identifying and monitoring market trends. Key Project Details: - The script should be able to accurately identify a trend based on the definition of "higher highs and higher lows". - When a trend is identified, the script should take no immediate action but continue to monitor the market conditions. Ideal Skills and Experience: - Proficiency in Pine Script and experience with TradingView platform. - Strong understanding of technical analysis, particularly in the context of identifying trends. - Previous experience in developing trading scripts or bots is highly advantageous. - A background in ...

I require a one-time data scraping project completed on multiple websites. - TASK: The task involves scraping text content from: Google searches: Commercial Real estate agency Saudi Arabia Commercial Real estate agency UAE Commercial Real estate agency Qatar Commercial Real estate agency Kuwait Commercial Real estate agency Bahrain I have made a start to the spreadsheet with a template for each of the regions which can be continued to be filled in. In the Google searches, just take the first 3 pages with the main agent listings and see what agent names/ email addresses you can find. - DATA REQUIRED: The primary data needed is text content. - TIMELINE: This is a one-time task, with no ongoing scraping requirements. Skills/Experience: - Proficiency

I need a developer who send me the php code to contruct a php proyy to embed a m3u8 file with CORS restriction. I can provide you some url examples with m3u8 file which initially you can't embed in other domains, but i've seen that some website with some php code avoid this restriction. Send "I HAVE READ IT" in you bid. I only will pay if you send me the code and it works fine. Note: I need the code in php

There are 89 simple phrases and the recording would take about 15 mins. the speakers need to be: - Native Italian speakers from Italy. - Age from 18-55. - Both professional voiceover or amateur Budget: $8 per speaker. We reserve the right to reject any recordings that do not meet our quality standards. (the pronunciation) Feel free to contact me if you are interested in this project. Best Regards Libby

I am in need of a skilled professional who can develop a Rhino Grasshopper script for a pipe network. This script. Check attachment for specs. Ideal skills and experience for this project include: - Proficiency in Rhino and Grasshopper - Strong background in architecture and structural engineering - Experience in developing similar scripts. Please note that the specifics of the script are outlined in the document that will be provided upon engagement. I am looking for a professional who can deliver high quality work within the specified requirements.

I need an expert in Optical Character Recognition (OCR) technology to convert text from high-resolution, clear photographs to editable text. Key Project Details: - **Purpose**: The primary objective of this task is to extract data from various documents. - **Image Type**: The text extraction will specifically be from photographs of text. - **Image Quality**: All photographs are high resolution and clear. Ideal Skills and Experience: - Proficient in Optical Character Recognition (OCR) technology - Prior experience in extracting data from images - Excellent attention to detail to ensure accurate transcription - Ability to work efficiently with high-resolution images

I have this proyect and I am looking for a developer that has time available to work on the proyect. It is a long term proyect. I need someone with experience in PHP, Laravel, HTML I need to create a copy of a product page. Here is the info needed on the page;

...business-centric, data-oriented, and analytical mindset. Comprehensive knowledge of data science concepts and disciplines. Knowledge of enterprise information management processes and methodologies. Skills in database design, data security, and data lifecycle management (i.e., gathering, cleansing, publishing, archiving, back-up and recovery, and purging) for large enterprise systems. Familiarity with master data, metadata, reference data, data warehousing, database structure, business intelligence principles and processes, and technical architecture. Knowledge of database management systems, metadata management tools, cloud storage, and associated security considerations. . Combinations of experience and education will be considered on a...

I'm looking for an expert in Microsoft Power Apps to develop...the gathering and insertion of information into a database. Requirements: - Incorporate text inputs, dropdown menus, and date fields for gathering information. - The preferred database language is Microsoft SQL Server but SharePoint can be used as an alternative. Additional Information: - You don't need to worry about any additional features or functionalities. The main goal is to develop a basic, yet effective form for data collection. Ideal candidates should have experience in: - Microsoft Power Apps development. - Integrating Power Apps with databases, specifically Microsoft SQL Server. You should be comfortable working independently and be able to deliver a high-quality, functional sol...

I'm looking to test database scraping on a website to extract names and potentially contact emails (if available). The data doesn't necessarily need to be organized or cleaned post-extraction. Ideal Skills: - Proficiency in web scraping tools - Understanding of database structures - Familiarity with handling contact information The data should be organized in an excel and csv based on the desired layout.

Help me with existing project to optimize the performance of core functionality and add some basic new functionalities. If you're genuine bidder then please write "php&python" in starting of your bid. This is kind of urgent and need to do it in around 1-2 weeks.

I r...scraping professional with experience in extracting text and images from multiple websites. Your task will involve the following: - Scrape data from Sephora, Cult Beauty, Space nk - Extract specifically the Text, Images, Titles, Descriptions, and Prices A strong background in web scraping, data extraction, and working proficiently across different websites is critical for this project. Knowledge in web parsing methods and ability to bypass potential anti-scraping tools or blocks set up on these websites will be highly advantageous. Your goal is to accurately scrape the necessary information without causing disruption to the target websites, and ensure the data is comprehensible and ready for further use. I would like to see an example of 1 page done ...

As a diligent user of Google Drive, I'm seeking a proficient developer who can create a program using Google App Script to arrange my Google Drive files in a hierarchical manner. Let's make searching and organization efficient and automated! the specific features I am looking for well be explained in private The ideal freelancer for this project would have extensive experience with Google App Script and an understanding of how Google Drive works. You should have created similar file management tools previously, and have a knack for creating user-friendly interfaces. Efficiency is key, as is the ability to work on a tight timeline. I look forward to working with a problem-solver who can make my file management efficient and hassle-free.

I have a small LinkedIn network of less than 1100 connections and 1500 followers. I'm looking for someone who can help me consolidate their details into a neat spreadsheet with their emails. Key Requirements: - Extracting email addresses: You'll need to be able to extract the email addresses of my connections and followers. - Data presentation: Organize the data in a clear, logical manner which makes the spreadsheet easy to navigate. - Timeliness: I'm aiming for a quick turnaround on this project, ideally within 24-48 hours. Since I have explicit permission from my contacts to collect their emails, this project is ethical and should proceed smoothly. I'm looking forward to seeing how you can help me in this task.

I have a PHP site hosted, but it's unfortunately not going live as intended. I need a skilled PHP developer to troubleshoot the site, identify the issue, and implement the necessary fixes to ensure it functions correctly. Key Deliverables: - Diagnose the issue causing the site to not go live - Implement the necessary fixes to ensure the site functions as intended - Provide me with the corrected file for future installation I'm experiencing error messages when I attempt to access the site. So it's crucial to not only fix the issue but also ensure it doesn't reoccur, making the site deployment-ready. Ideal Freelancer: - Experienced PHP developer with a proven track record of troubleshooting and fixing website issues - Strong problem-solving skill...

I urgently need someone to extract shareholder information from the Madagascar business registry. The work needs to be done as soon as possible. Key Requirements: - Retrieve shareholder data from the Madagascar business registry - The data should be presented in a clear, easily understandable format

I need a Python Selenium application that can scrape blog posts from Site A and post them on Site B. Key Requirements: - The Python app should be built using Selenium for web scraping and automation. - It should be able to extract blog posts from Site A, specifically. - The extracted data must be posted on an existing blog section of Site B. Ideal Skills & Experience: - Proficient in Python, with experience in building web scrapers. - Strong knowledge of Selenium for web automation. - Previous experience with data extraction and manipulation. - Understanding of web protocols and site structures. - Familiarity with blog post formatting and publishing is a plus.

I'm looking for a Python expert to help me create a new Python script for data analysis purposes. The primary goal of the script will be to analyze a dataset that I already possess. The script should be able to handle large amounts of data efficiently, allowing for insightful analysis and visualization. The key requirements include: - Writing new code from scratch - Prior experience in data analysis using Python - Proficiency in Python libraries such as Pandas, NumPy, and Matplotlib If you have a solid background in data analysis and Python, and are able to create efficient, clean, and well-documented code, I'd like to hear from you. Here are details- I have to create a simulation that will find the optimal solution to go ...

Hello All, We are an established IT services provider with 13 years of experience and a team of 25 in-house developers. Currently, we are looking to hire some freelancers because we are at full capacity and do not have sufficient resources to handle some of our work. We are seeking a long-term partnership and are willing to provide 20-30 hours of work per week. We welcome both experienced freelancers and those new to this platform who have significant prior experience, such as working in a company before starting their freelance career. This job post is open to all qualified candidates. Now, let's discuss the job requirements, which are urgently needed: We require an expert Laravel Developer who is well-versed in third-party APIs. The candidate must have experience working on inco...

I'm looking for an Android developer to enhance my app to support zip and rar files. The functionality should include: - Support for both zip and rar files - Support for both password-protected and standard files - Ability for users to extract files - Ability for users to view file contents The ideal candidate should have experience in Android app development, specifically dealing with file handling and storage. Knowledge of third-party libraries for handling zip and rar files is a plus. The developer should also be comfortable with implementing password protection mechanisms. Please note that the app is already built, so the task would primarily involve adding the requested functionality.

...captivating content. - Audience: The channel is specifically targeted at young adults aged 18-34. I'd love to see how you've previously delivered appealing content to this age group. Ideal Skills: - Video Editing: Skilled in video editing software like Adobe Premiere Pro or Final Cut Pro. Enhancing visual aesthetics and ensuring smooth transitions will be key. - Creative Writing: The ability to script engaging content that appeals to a young demographic. - Social Media Management: Hands-on experience in managing YouTube channels, understanding algorithms and analytics. If you have previous experience in vlogging or lifestyle content creation, that’s a big plus. But ultimately, creativity and an understanding of what makes engaging content for young adults...

I'm looking to integrate Optical Character Recognition (OCR) into my web application. The primary goal is to automate data entry processes. The current application contains manual data entry. I am attaching a screenshot of how it is entered manually and a picture of the paper from which it is typed. OCR should be done automatically. We can take pictures with a mobile phone in a few seconds so that everything is finished. The application is in spring boot and angular. The database is mysql. Functionality for Taking Photos Using HTML5 and JavaScript, you can use an input element with the type file and the attribute accept="image/*" to allow users to take pictures of documents directly from the browser on a mobile device. Uploading the Image to the Server When...

I'm seeking a professional with experience in text annotation to help me enhance readability and extract key information from Arabic comments on both Facebook and Instagram. This project involves identifying key trends and patterns within these comments. Key Job Requirements: - Fluent in Arabic and English - Excellent understanding of social media platforms, specifically Facebook and Instagram - Strong background in text annotation - Ability to identify patterns and trends in text - Detail-oriented, with a focus on accuracy and consistency Your task will involve reviewing and interpreting comments, then accurately annotifying the content to extract the necessary data. This is a task requiring high levels of concentration and linguistic comprehension. Applying ...

I am engrossed in studying a company's customer, product, and trucks data for my PhD research. Contemporary businesses encounter a significant challenge wherein their delivery trucks often travel from one region to another with insufficient loads (Half of the trucks are empty), resulting in inefficient use of resources. My research aims to minimize the number of empty or partially filled trucks traveling to those areas, particularly in the last-mile delivery process. Below is a list of stores. I kindly request you to extract the dataset from one of the listed companies. The list of stores is prioritized in order. 1- IKEA (IKEA store that located in Saudi Arabia) 2- Home Centre 3- Home Box

...generating data visualizations. The selected expert will be expected to work with data from both Excel spreadsheets and SQL databases, so experience with these sources is crucial. I will be looking for an advanced level of expertise, as the job will involve complex data modeling and designing sophisticated, interactive visual reports. A strong understanding of data analysis and visualization techniques is essential. Key responsibilities and qualifications include: - Creating interactive dashboards - Generating data visualizations - Working with data from Excel spreadsheets and SQL databases - Demonstrable advanced level of Power BI experience - Advanced knowledge of data modeling - Proficient in designing sophisticated, i...

...Statutory Registers Key Requirements: A. Auditor Appointment & Filing of Form ADT - 01 (Auditor Appointment). B. Preparation & Filing of Form INC - 20A (Declaration of Commencement of Business). C. Assistance & Documents Preparation for Company's Current Bank Account. D. Preparation & Filing of Balance Sheet, P & L Accounts, Audit Report, and Director's Report. E. Preparation & Filing of Extract of Annual Returns & Financial Statements (Unlimited Transactions). F. Preparation & Filing of Annual Returns Form AOC - 04 (Financials Related Annual Return). G. Preparation & Filing of Annual Returns Form MGT - 07/07A (Management Related Annual Return). H. Preparation & Filing of Minutes of 04 Board Meeting & Minutes of AGM. ...

I need a professional content creator skilled in human development to provide me with 30 video scripts and ideas for my business centered on getting rid of old block how nervous system control you, personal growth, overcoming fears, and building self-confidence. Each script should be educational and informative, while maintaining a concise length of 1-3 minutes. Key Requirements: - A solid understanding of human development, personal growth, and related topics - Proven experience in creating concise and engaging video scripts - Ability to convey complex information in an easy-to-understand manner - Strong writing skills with a focus on educational content - Previous experience with similar projects is highly preferred Your work will play a crucial role in helping individuals over...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design princi...

I'm looking for a Unix shell scripting expert to help me with my project. Here's what's required: - Automating file transfers: I need a script that can download specific file types from a directory on my server and then upload them to an SFTP server. - Handling specific file types: The script needs to be able to recognize and transfer only files of specific types, rather than all files in the directory. Ideal skills and experience: - Proficiency in Unix shell scripting - Experience with SFTP - Expertise in handling specific file types in scripts - Familiarity with file transfer automation - Good communication and problem-solving skills If you feel you have the required skills and experience, please reach out. Thank you!

...setup -> deploy our existing project to a new VPS using gitlab 2) Woocommerce -> continue long term development work on our existing custom plugin. Transfer the existing production woocommerce to this staging server. 3) ongoing long term development of our CRM app Other components of our stack which are a HUGE ADDED BENEFIT if you can work on them -> .NET ASP, WEB API + MS SQL DETAILS HERE -> PRIORITY IS TO HAVE A DEVELOPER ON OUR TEAM (LONG TERM) THAT CAN FOR NOW ALSO WORK WEEKENDS AS WE HAVE SEVERAL EMERGENCIES TO FINISH URGENTLY. Someone who can efficiently manage Linux VPS and efficiently use GITLAB is critical. Initially we need part of the hours to be worked in the first weeks from 8:00PM- 2:00am UTC -3 (Brazil Time) later you can work on

I'm looking for an experienced freelancer to develop a state-of-the-art desktop bot for ticket purchasing and availability checking on Ticketmaster and BookMyShow websites. The bot should be able to process simultaneous requests, manage queues, and extract links efficiently. Key Features: - Ticket Purchasing - Ticket Availability Checking - Handling Simultaneous Requests - Effective Queue Management - Link Extraction Ideal skills and experience: - Experience in bot programming and development - Familiarity with the desktop platform - Understanding of the ticket-booking domain - Prior exposure to applications for Ticketmaster or BookMyShow would be an asset. If you've done similar projects before or have innovative ideas on how to execute this, I'd love to hear ...

I'm in immediate need of a skilled web developer to tweak an existing custom-built script for my car rental website. The script that I am using is this: I am looking for a professional with a high level of expertise in web development to make these adjustments quickly and effectively. The priority is the rapid completion of this project, so it is critical that the selected freelancer has the bandwidth to dedicate to this task immediately. Experience with custom-built scripts is a must. Your portfolio should demonstrate your capability to work on existing structures and adapt them to new requirements.

...gitlab and code in ., .NET ASP, WEB API + MS SQL. We also have woocommerce and have developed and will continue to develop plugins, so PHP and understanding of woocommerce plugins is a plus but not a necessity. Prerequisites: For the long term project the *STARTING* wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) If awarded, accept and start work IMMEDIATELY 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 5) Be available to work on weekends. Our projects use: GITLAB so you need to be proficient and be able to use our existing pipelines and also create your own. Our stack: , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital pr...

...SPARK VISION. Data Collection: Extract detailed information from the competitors' websites, focusing on: Price Features Customer Support Compatibility Cost Type of Subscription What is included in each type of subscription 3D Modeling Costs: Gather information about the costs associated with 3D modeling for new products, including the data required for the modeling process. Requirements: Pricing Comparison: Compile accurate, up-to-date pricing details, including different subscription plans and any additional fees. Feature Analysis: Evaluate and compare the capabilities of each 3D planner, including customization options and integration capacities. Visual Representation: Create a comprehensive table and visually appealing graphics to clearly compare the dat...