...account creator then a mass uploader, but will be preferred if it could be a single program * This should be fully automated, it means that I will only provide the video & description and the keywords then the program will do the rest *The program should upload the videos from a folder in a filepath and use the description from the textfile in that folder. So if you created 2 separate program then I will just load the time delay, file path, the accounts and the proxies. Then it will upload all the video in the 1st folder on that filepath and it will also use the text file in that folder and paste it in the description. Then after that the output will be the URL the accounts profile....
Hello, We are looking for a talented and experienced design freelancer to create a template and logo for our online ERP system, under the name "SOLTETI". The template will be based on the existing layout of the following website: [Link to website: ] Project description: Goal: Develop a template and logo for our online ERP system, maintaining the visual identity and functionalities of the website layout provided above. Layout Details: The website layout provided will be made available to the selected freelancer for reference and inspiration. Technical requirements: The template must be compatible with our ERP system and easily integrated. It must follow best design and usability practices. Be responsive, ensuring a consistent experience across different
I'm seeking a detail-oriented freelancer to assist with a comprehensive data entry task. This task involves inputting text, numerical information, and images into Microsoft Excel. Here's a more in-depth look at the project: 1. DATA TYPES: - Text Data - Numerical Data - Image Data 2. VOLUME: The project will involve entering more than 500 entries. Due to the significant volume, high efficiency and accuracy are paramount to complete this task successfully. 3. SOFTWARE REQUIREMENT: All data must be entered into Microsoft Excel. Therefore, expertise in utilizing Excel for large scale data entry tasks will be ideal. SKILLS REQUIRED: - Proficiency in Microsoft Excel - Strong attention to detail - Abili...
...need a proficient Excel professional to efficiently manage data entry and cleaning tasks. The responsibilities of the chosen freelancer will include: - Entry of both numerical and textual data into Excel from various sources. - Pre-entry cleaning and categorization of the provided data, ensuring it's thoroughly structured and void of errors for optimum usage. Ideal Skills and Experience: - Proven experience in Excel data entry and data cleaning. - Highly detailed oriented and organized. - Excellent communication skills to report progress and any issues encountered. - Ability to work within strict deadlines. This role requires a keen eye for detail, a high level of organization, and the ability to handle numerical a...
I'm in need of a skilled professional who can assist me in entering cabinet estimates in Xactimate. I'm looking for someone with the following skills and experience: - Proficiency in Xactimate: It's crucial that you are well-versed in utilizing Xactimate software to create accurate estimates. - Understanding of Cabinet Costs: While I'm looking for a basic overview with general pricing, a clear understanding of cabinet costs is essential to ensure the estimate is accurate. - Strong Communication Skills: As we'll be working together via Zoom, I require someone who is comfortable with video and audio communication. During our session, you'll be responsible for guiding me through the process of entering cabinet estimates on Xactimate. Your expertise will be inva...
Got it! Here's a draft for your job description: **Job Title: Custom Avatar Creation and Video Animation Freelancer** **Description:** We are seeking a skilled freelance animator who can bring our vision to life by creating a custom-made avatar resembling a famous individual. Additionally, we require expertise in animating elements within a provided video clip, specifically animating a banner falling down from a building. **Responsibilities:** 1. Create a custom avatar resembling a well-known individual, capable of walking and talking convincingly. 2. Animate the avatar to mimic the movements and speech patterns of the referenced individual. 3. Integrate the avatar seamlessly into provided video footage, ensuring realistic interaction with the environmen...
... Key Requirements: - Data Entry: The project involves a substantial amount of data that needs to be accurately typed into Excel. This part of the project requires a detail-oriented and precise freelancer. - Trend Analysis: Once the data entry is complete, I need you to analyze the data for trends. This requires a good level of understanding and experience in trend analysis. - Statistical Analysis: The project also involves performing a range of statistical analysis on the data, including: * Descriptive Statistics: This will involve summarizing the main aspects of the data set, such as mean, median, mode, standard deviation etc. * Hypothesis Testing: This will involve determining whether there is a significant difference bet...
I need an entry-level appointment setter to help with my financial services. The main tasks will be: - Interacting through Linkedin - Targeting clients within the financial services industry I require an individual that is: - Able to communicate effectively - Proficient in email and online chat via LinkedIn - Detail-oriented and able to maintain proper documentation - Enthusiastic and eager to learn Please provide examples of work in this field and success
We are looking for a person, whether a person or a company, to help us conceptualize, organize and develop a web platform that contributes to the growth and income generation of our company and, if possible, to the community. We are at an early stage where we are exploring different approaches and possibilities for our project. We value the creativity, experience and technical capacity that an external team can contribute to turn our visions into reality. We are open to anyone who can contribute fresh ideas and innovative solutions. In short: We don't have any ideas for a web platform that helps the company earn income.
Confirmis () is a Singapore-based business information provider specializing in connecting businesses with global capabilities; comprised of industry veterans, Confirmis business model is designed to overcome perennial lack of data (let alone quality data) to support effective decision making, particularly in developing economies. As a Site Verifier, you will be responsible for verifying a company’s existence through visual data by conducting a site visit to ensure that we provide reliable and accurate information to our client. JOB DESCRIPTION: • Conduct basic verification with the subject company’s authorized representative, such as line of business, key executives' name, etc. • Take pictures of the subject company and its...
I am in need of a proficient administrator to offer a hand in various tasks, namely data entry, email management, and document organization. As all these tasks will be performed remotely, a high level of trust, organized work ethic, and excellent communication skills are essential. I am very comfortable with the use of software tools that ensure high efficiency and accuracy in task management. - Data entry: Must have attention-to-detail and ability to interpret data correctly. - Email management: Experience with a broad spectrum of email platforms and management tools. - Document organization: Skills in file management software and cloud services are essential. The ideal candidate should have sufficient experience in administrative jobs performed remo...
Project Title: Experienced Translator Needed: Translate Italian Company Balance Sheet to English Project Description: I am seeking an experienced translator to translate the balance sheet of my company from Italian to English. The balance sheet contains important financial information that needs to be accurately translated for business purposes. Project Details: Document Length: The balance sheet consists of 38 pages. Deadline: The translation must be completed by next week, asap. Expertise Required: I prefer a translator who has experience in financial or business translation, particularly with balance sheets. Technical Terminology: The balance sheet may contain technical financial terminology, so familiarity with such terminology is essential. Requirements: Experience: Pleas...
I'm seeking an expert researcher to build a comprehensive list of 3300 Chair of Gov...Governors acceptable. Site to help The budget is $100 no more - please send a sample of 10 to 20 Governors Key requirements include: - The list should be organized alphabetically by county/area - I need contact details to include email addresses and phone numbers. Your experience with web research, data mining and data entry will be crucial to successfully carry out this task. Knowledge of educational institutions and contact compilation is key. Please ensure that the details gathered adhere strictly to public schools only. I expect high levels of accuracy, so skills in precision and attention to detail are crucial.
I need a proficient Gujarati speaker who is also adept at data entry. This task involves posting content on a website, specifically lyrics. The timeframe for completion is flexible. The ideal candidate should have: - Strong command over the Gujarati language - Experience in data entry tasks - Interest in music and lyrics would be a plus - Excellent attention to detail and accuracy The key deliverables for this project are: - Accurate transposition of lyrics into the website - Ensuring all Gujarati language nuances are respected - Regular updates on the task progress and completion
I need assistance in a data entry project. The task involves inputting numerical and textual data from digital documents into an Excel sheet. Skills and Experience: - Proficient in Excel - Must have accurate and fast typing skills - Prior experience in data entry jobs This job requires the utmost precision and accuracy, as the entered data will be used for important business processes. A keen eye for detail and a high degree of data accuracy are important for this role. The successful candidate should have the ability to read, understand, and input data efficiently.
I am seeking assistance with submitting my Job applications on LinkedIn. I am interested in a full-time position in the technology field, specifically as a Marketing Technology/Data Analyst/Digital Analytics Ideal Skills and Experience: • Familiarity with data analysis field, job requirements and responsibilities. • Proficient in following the Standard Operating Procedure for applying jobs. • Experience in job application procedures on LinkedIn within the Tech industry will be highly favored. Your role will involve; 1. tailoring my resume as per job description (access to ChatGPT 4 Premium will be provided). 2. Able to submit around 50 job applications per day × 6 days a week that I will be shorlisting (takes...
Project Description: We are seeking a highly skilled High-Performance Computing (HPC) Engineer with expertise in shell scripting and workflow automation to assist in the evaluation and enhancement of the Parallel Works platform. The successful candidate will need to execute various tasks involving cloud cluster management, running pre-installed workflows, and handling both basic and advanced system integrations. Experience with MPI (Message Passing Interface), Singularity containers, and batch scripting is crucial.
...also value employee well-being because our employees are our most valuable assets. If you're someone who enjoys playing games, you shouldn't be a manager. If you simply want to make your work better, then go ahead and take a break. Our work day schedule: According to Sayloran (Kerja sambil Sayloran, Santai, malas tapi cerdas) Irandra Florist currently holds a job with the following position: • Web coder • Graphic designer Job Description: Web developer • Create websites and mobile applications • Maintain websites and mobile applications • Understanding and capable of utilizing efficient and effective APIs, as well as integrating third-party services such as Google Analytics, Facebook Pixel, Google Tag Manager, Intercom, and Google...
I'm in search of an HR assistant, with a primary focus on recruitment tasks. Here's what the role would encompass: - Remote work for India based Freelancer. - Hire entry level Hospitality staff like Chefs, F&B Guest Relations executives etc through partnership with Hotel Management schools and their placement cells across Karnataka India as well as Skill India Hospitality Diplomas - Also screen through various blue collor hiring sites to speak to potential staff. I anticipate needing assistance with 5-10 recruitment positions per month. The ideal candidate for this role will have previous experience in HR, with a strong background in recruitment. Outstanding organizational skills and an eye for detail are crucial, as you will be managing high volumes of application...
I need some help with ...need some help with a data model I created in Power Pivot. I have 2 data sets: one is Sales and the other is Stock. I have added both data sets to my data model and am now trying to create a pivot which pulls data from both tables. My Sales table pulls the data perfectly but the Stock table does not. Some context... When I pulled the data into the data model I added a column which I called DataModelLink. This created a 1 (Sales) to many (Stock) relationship between the two tables. As an example, I tried to pull the data of one particular style which had one line in the Sales table but 2 lines in the Stock table. For this reason, my Pivot is only reading one of two of the ...
I have an Excel sheet full of text data that I need typed up. The data is currently in a PDF file, so you'll have to extract it from there. Once the data is in the Excel sheet, it needs to be organized into tables. Key Requirements: - Data entry of text from a PDF into Excel - Organizing text data into tables in Excel Ideal Skills: - Proficiency in Excel - Fast and accurate typing - Attention to detail - Experience with data formatting in Excel Looking for someone who can complete this task in a timely and error-free manner.
I'm looking for a freelancer with expertise in data entry to assist with tasks in Excel. Tasks: - You'll be working to enter data into an Excel sheet. Nature of Data: - The data to be entered will be a mixture of numerical and textual. Size of Project: - You'll be handling an Excel sheet containing between 100-500 rows and columns. Required Skills: - Proficient in Microsoft Excel - Fast typing skills with a strong attention to detail. - Strong numerical and textual data entry skills.
I'm looking for a design expert who can transform the facade of my property to cre...other materials will be used for enhancing the curb appeal The ideal freelancer for this job will have a great design sense, practical knowledge of materials, and a knack for modern minimalist design. Proficiency in architectural software like AutoCAD or Revit is a plus, but not a necessity. Relevant experience in facades renovation or restoration with a focus on modern minimalist aesthetics will be highly preferred. PLEASE NOTE: I want to keep my existing shape of roof. I have no garage - at the moment - please don't factor into design Here is my house image: @-33.8328115,150.9749173,3a,39.4y,89.53h,84.54t/data=!3m6!1e1!3m4!1s52gfI0WoklYN3w86G4jn8Q!2e0!7i16384!8i8192?entry...
I'm currently looking for a ...help me apply for mid-level full-time technology opportunities. Key Responsibilities: - Assist in tailoring my job applications to the specific requirements of the positions I'm interested in. - Provide guidance on how to optimize my CV and cover letter for these specific roles. - Offer general advice or techniques which could increase my chances of success. Ideal Skills and Experience: - A solid understanding of the technology industry and the skills typically sought after in mid-level roles. - Excellent English language skills, particularly in writing, to help polish my applications. - Previous experience in recruitment or HR would be a bonus. Please note that this is not a job-search role. It's specifically about optimizing...
description I want a basic demo using OpenAI assistants API and its retrieval function. Will provide OPENAI ID and assistants id 2.1 a web UI to chat with 2.2 a specific file which is provided as knowledge file(will provide it below) 2.3 Use Simplied Chinese to chat Prototype: Screen shot attached. Beijing Time April 20st 21:00 pm As a demo, could deploy to Azure or your server. But needs full source code. knowledge file the PDF file will be provided.
...alert system: I want to be alerted with all PNL data for every trade executed in real time after trade has completed. - Risk management tools: It should help manage potential losses and enhance profit chances. - Stop-loss orders and take-profit mechanisms: Essential features to control and protect my investment and keep overall drawdown below 5% - Advanced Algorithmic Trading: The bot should trade using complex algorithms and machine learning trading techniques The bot should be specifically designed to work with the trading platform. The innovative trading bot should possess advanced capabilities to identify new coins and snipe within milliseconds and utilize unique trading algorithms and strategies to ensure multiple profitable entry and exit points and take advantage...
I am seeking a detail-oriented freelancer who can expertly transfer text data from PDF files into a database. The ideal candidate should possess the following skills and experience: - Proficiency in working with PDF files - Expertise in data entry tasks - Experience in formatting and structuring databases - Excellent attention to detail Suitable candidates need to handle copious amounts of text data, accurately convert the text-containing PDF files into a structured and organized database. This includes careful validation to ensure no data is lost or misrepresented during the data entry process.
As a client, I'm currently experiencing an unspecified "controller not found" bug in my Laravel application. Unfortunately, I haven't been able to determine any exact error messages, affected pages/routes, or recent application changes that could be related to the issue. I'm looking for an experienced Laravel developer with the following skills: - Debugging and troubleshooting Laravel applications - Comprehensive understanding of Laravel controller structures My main goal is to have the current bug fixed efficiently and professionally. Don't hesitate to ask if you have any questions. Please include any similar Laravel bug fixing experiences in your proposal. Your ability to describe the possible problems based on the lack of specific error info...
I'm looking for a detail-oriented freelancer to help me with an Excel data entry project. The task primarily involves typing text from scanned documents into my Excel sheet. **Key Requirements:** - Accurate typing of text from scanned documents into Excel - Organizing the data into tables and lists **Skills Needed:** - Proficient in Microsoft Excel - Attention to detail to ensure accuracy - Experience in data entry, ideally with scanned documents - Ability to organize data into tables and lists The ideal candidate should be comfortable working with scanned documents, have a knack for accuracy and attention to detail in typing, and be able to organize the data effectively into tables and lists in Excel.
...alert system: I want to be alerted with all PNL data for every trade executed in real time after trade has completed. - Risk management tools: It should help manage potential losses and enhance profit chances. - Stop-loss orders and take-profit mechanisms: Essential features to control and protect my investment and keep overall drawdown below 5% - Advanced Algorithmic Trading: The bot should trade using complex algorithms and machine learning trading techniques The bot should be specifically designed to work with the trading platform. The innovative trading bot should possess advanced capabilities to identify new coins and snipe within milliseconds and utilize unique trading algorithms and strategies to ensure multiple profitable entry and exit points and take advantage...
Mail server is getting attacked, I need to create a windows service constantly checking a .txt log file for preset keywords like "Failed SMTP login" or "Relay attempt" to auto block IP's. This service should auto add/delete a new entry to a existing "inbound windows firewall rule" with the hacker's IP for a specific period of time. A good example or a similar concept could be found here: Some of the settings that I need to control: – Duration to ban ip address (min) – Number of failed login attempts before ban – Whitelist of comma separated ip addresses to never ban – Blacklist of comma separated ip addresses to always ban – Custom keywords, XPath and Regex to parse logs for failed login attempts &nda...
I'm searching for a detail-oriented freelancer with extensive experience working with Excel. - This task involves typing text data into an Excel spreadsheet. - The data entered will be a mixture of both structured and random entries. Thus, a keen eye for detail and the ability to maintain organization amidst complexity is key. - As a crucial aspect of this project, I require error checking to ensure the highest quality of work. The ideal candidate should have experience and knowledge in Excel data validation. - For successful completion of this project, accuracy and attention to detail are paramount. Candidates with previous background in similar tasks will be highly regarded.
>>Read first<< this is not a project this is a full-time job you will join our team of 14 devs don't bid blindly you will be ignored if you don't reply and start your text with >>Full Time Job << your bid will be ignored bid your monthly salary ask This is a full-time job 40h/w if you are not free don't apply --------------------------------------------- We are seeking a seasoned freelancer with strong experience in both Wordpress and Laravel platforms. this is not per project we have a lot of projects already. Key Requirements: 1. Proven expertise in both Wordpress and Laravel 2. Ability to cater to a diverse range of web development requirements 3. Quick turnaround on tasks and feedback 4. Active participation and contributio...
I require some help from 2 people to move some furniture items from Nunawading to Ringwood in Melbourne. I have a van I can get from the storage place I'm moving to but another one wouldn't hurt if you ...place I'm moving to but another one wouldn't hurt if you have one. The items to move are: 1. 1 Queen size bed with mattress 2. 2 kid single beds with mattresses 3. A heavy drawer 4. Some side tables 5. A couple of boxes 6. A washer and a dryer. 7. Maybe 1 or 2 other smaller things. Ideal Skills and Experience: The perfect candidate for this job is someone who has is strong and lives in the Melbourne metro and who has another strong mate. The job should take no longer than 2 hours and needs to happen on Tuesday the 23rd of April (next Tuesday) and sta...
I'm in need of a talented copywriter with deep experience in crafting engaging product descriptions. Key Requirements: - Copywriting expertise: Your ability to craft persuasive, creative and succinct product descriptions ...informative and enticing. - SEO knowledge: Knowledge of SEO writing is a bonus, as it can help to improve the visibility of our products online. Your primary task will be creating product descriptions that are not only compelling and descriptive, but also optimized for search engines. In addition, you need to be able to adapt your writing style to fit various types of products, ensuring that each description is unique and tailored to the target audience. If you have a knack for crafting engaging product descriptions and a passion for writing, I'd lo...
I'm seeking a skilled programmer to work on a project involving a TNC-G22 2-Axes Motion Controller. The system will be responsible for controlling a total of 10 motors in a sequence, which includes stepper motors. Key Requirements: - Expertise in TNC-G22 Programming: In-depth knowledge of the TNC-G22 system is crucial for this role. - Experience with Multi-Motor Control: The ability to program and control 10 motors in a synchronized manner is a must.
I'm seeking a diligent and detail-oriented individual to assist me with data entry tasks. As a fresher, I expect you to bring a fresh perspective and dedication to the role. Key Requirements: - Experience in data entry is not necessary, but a plus - Proficiency in handling image and scan-based data - Excellent attention to detail and accuracy The data will be provided as images or scans. The ideal candidate will be able to convert this visual data into digital format with high accuracy.
About Us: We are the premier direct importer of pool heat pumps, offering unparalleled pricing directly to end customers. Through bulk purchasing and cutting out intermediaries, we provide the most competitive prices in the market. Our unique business model ensures that we stand alone in offering unbeatable value to pool owners across the country. Job Description: As an Exclusive Pool Heat Pump Sales Representative, you will play a pivotal role in conveying our distinctive value proposition to pool owners. Your mission will be to educate potential customers about the benefits of purchasing directly from us as the sole importer, leveraging our competitive pricing and unmatched quality. Responsibilities: • Educate potential customers about the advantages of buying direc...
I require a meticulous individual who is adept at data entry into Excel, with precision and accuracy being top priorities. - The task involves entering various types of data, including numeric, text, and alphanumeric, ensuring it is correctly and appropriately categorized. - The Excel sheet will consist of two columns which will require careful management for data uniformity and consistency. - The entered data should be organized based on the input order, therefore, attention to chronological details is paramount. The successful bidder should have proficient data entry skills and a keen eye for detail for successful completion of this project. Prior experience in similar projects would be an advantage.
I'm looking for a detail-oriented professional who can help me with data entry from online databases. The data includes both text and numbers. Requirements: - Accurate data entry from online databases - Handling both text and numerical data - No data cleaning is required, so the task is straightforward and mainly requires meticulous attention to detail Ideal Skills and Experience: - Proven experience in data entry - Familiarity with handling both text and numerical data - Proficient in using online databases - Meticulous attention to detail and accuracy Please note, I need a quick turnaround time on this project, so prompt and timely completion is a key requirement. WATCH THIS LOOM FOR OUTLINE OF TASK:
I need a freelancer to collect data from online. It is simple job of data search and collection from crowdsourcing website. Would provide spreadsheet with details, all you need to fill the details. We are into venture financing. Job Description: Name LinkedIn profile. contacts (if possible) Attached spreadsheet for your reference. Regards, R
I need assistance with typing a series of literary texts in Hindi. The project entails taking sc...texts in Hindi. The project entails taking scanned documents and retyping them in Hindi. For the project, a basic level of proficiency in Hindi is required. Key Requirements: - Hindi Typing: You need to have a good typing speed and accuracy in Hindi. - Basic Hindi Proficiency: The job involves typing literary works, so a basic understanding of the language is necessary. - Attention to Detail: Precise typing is essential to ensure the integrity of the original documents is maintained. Prior experience in data entry, Hindi typing, or similar projects would be advantageous. The project is quite straightforward, and the ideal freelancer should be able to complete it within...
I am searching for a proficient and attentive freelancer to assist with data entry tasks, specifically within Microsoft Excel. The role will require the successful candidate to be highly tech-savvy, with a strong background in Excel and an eye for detail. Key Responsibilities: - Handle diverse data entry tasks within Microsoft Excel - Ensure accuracy and consistency throughout the Excel spreadsheets - Offer quick turnaround times for tasks, while maintaining quality Ideal Skills: - Excellent knowledge and proficiency in Microsoft Excel - Previous experience in data entry roles - Strong attention to detail and accuracy - Ability to work quickly and efficiently under minimal supervision.
Project Description: We are seeking a talented freelancer with expertise in graphic design and illustration to refine our marisco seafood restaurant logo concept. The current logo concept, attached for your review, features seafood elements arranged in an outer circle and a beach palm view in the center of an inner circle. However, we feel that the seafood elements appear too cartoonish and could benefit from a more realistic or less animated approach. Specifically, we envision the seafood elements to be depicted in a more authentic and refined manner, capturing the essence of quality and freshness. Additionally, the inner circle concept requires enhancement, with "MARISCOS" curving around the top section and "LA PLAYITA" curving around the bottom section. The...
I'm seeking a skilled editor for a long-term position for multiple projects with my content agency, primarily serving health and fitness coaches & my own personal brand. I run a short-format content agency that edits videos for coaches. Videos will be primarily talking head videos. The videos are up-to 60 seconds long and I expect you to edit subtitles, b-roll, stock footage, dynamic motion/graphics and make the video in general: entertaining and highly engaging. I am looking for a person that can be my full time editor for the next 6-12 months with the possibility of consistent pay-raises when the agency experiences growth. You will be paid 8USD for every video-edit. Paid on a per video basis (not hourly) The process is super streamlined! All videos are tailored b...
Title: Product information collection for vehicle <Overview> Please collect product information on vehicles that have or will have the technologies described in the “Technology Description” section below. <Technology Description> This technology is a technique that uses light to draw on the road surface in the direction the car is moving. The light changes direction and color based on the direction the car is moving. For example, the light drawing appears white behind the car when the car is in reverse, and orange on the left rear side of the car when it is making a left turn. <<NOTICE>> The target car brands in this search are limited to Japan, US, and Chinese brands. <Requirements for Payment> ・Submit documentary evidence that ...
Title: Collecting product information of the automatic braking of the vehicle <Overview> Please collect product information on vehicles that have or will have the technologies described in the “Technology Description” section below. <Technology Description> This system is about automatic braking of the vehicles. This system can detect obstacles in front of the car and automatically stop the car in case of a potential collision. The system measures the distance and relative speed to obstacles and automatically adjusts the car's braking power accordingly. When the braking force reaches a predetermined value from its upper limit, the braking force is weakened. The upper limit of braking force is set to increase over time after a predetermined amo...
<Overview> Please collect product information on a vehicle control device that have or will have the technologies described in the “Technology Description” section below. <Technology Description> This technology arbitrates between control commands acquired from driving support applications that respectively implements driving support functions, outputs instructions based on a control command after arbitration to a processor that is able to control at least one of a brake actuator or a drive actuator. This technology also acquires a steering angle and a yaw rate as the control commands from the driving support applications. Please search for this technology in this contest. <<NOTICE>> The target car brands in this search are limited to US...
