U.S. Regulations (RIN) Data Collection 11-2013

Project Description:

I need data on United States federal agency rules scraped from the [url removed, login to view] website. I would provide a list of Regulatory Information Numbers (RIN). This requires a search of the [url removed, login to view] website for each RIN ([url removed, login to view]). There are about 569 unique RIN numbers for which I need data. Some of the searches for RINs will not produce results because the database is only for rules produced after 1995.

Each search will produce a number of records for each RIN. I need data from each record. So, each RIN will produce a number of rows of data equal to the number of records produced by the search (see, for example, what is produced by a search for RIN # 2060-AM06). This can vary from 1 to as many as 20 rows of data for each RIN.

The columns would be data scraped from the “View all RIN Data” page for each search (see, for example, what this looks like for RIN #2060-AM06).

**The website includes a link to RIN data in XML. It may be easier to simply put all of this XML data into a spreadsheet.

At minimum, the specific data I need from the web pages are:

1. RIN [1 column]

2. Publication ID [1 column]

3. Publication year [1 column]: From the Publication ID

4. Publication season [1 column]: From the Publication ID. This should be either Fall or Spring.

5. Title [1 column]

6. Agency [1 column]

7. Priority [1 column]

8. RIN Status [1 column]

9. Agenda Stage of Rulemaking [1 column]

10. Major [1 column]

11. Unfunded Mandates [1 column]

12. CFR Citation [1 column]

13. Legal Authority [1 column]

14. Legal Deadline [Many columns]: In some cases this will say “None”. However, in some cases it will include data on an action, source, description and date. There may also be cases where there is more than one entry here. I need the entries for action, source, description, and date for each deadline included in the table included after “Legal Deadline” (if there is one). So, in a case where there are two entries for legal deadline, there should be 8 columns of data filled (action, source, description, date; action, source, description, date). In cases where there are no deadlines, these columns would be blank.

15. Timetable [Many columns]: This portion of the page often includes multiple entries (i.e., multiple rows of data. It includes entries for Action, Date, and FR Cite. In most cases there is more than one entry here. I need all of this data. So, in a case where there are four entries for timetable, there should be 12 columns of data filled (action, date, fr cite; action, date, fr cite, etc.).

16. Deadline [1 column]: The way the agency indicates that they are setting a deadline is that the day within a date is set at 00. So, for example, a date of 06/00/2005 (mm/dd/yyyy) is a deadline because there is no specific day listed. I would like a column that is coded with a 1 if any of the dates in the timetable have this format (indicating a deadline).

17. Regulatory Flexibility Analysis [1 column]

18. Government Levels Affected [1 column]

19. Federalism [1 column]

20. Included in the Regulatory Plan [1 column]

21. Related RINs [1 column]

22. Agency Contact: [8 columns; I need one column for Name, Title, Agency, Sub-agency, Address 1, Address 2, Address 3, Phone, Email]

This data should be collected for each record for each RIN and placed in the columns.

Habilidades: Processamento de Dados, Excel, Captura de dados na web, XML

Veja mais: what is date entry, government project for data entry, government Data, data stage 8.1, data government, data analysis for excel, 14 cfr, year 2013, data entry rules, xml data entry, www data entry gov, rin, government data entry, Database collection, Data Entry for Government, Data analysis in excel , collection view, authority records, analysis excel spreadsheet, excel timetable, xml excel format, data collection excel spreadsheet, government entry project, data collection spreadsheet, government project data

Acerca do Empregador:
( 9 comentários ) Nashville, United States

ID do Projeto: #5142480

Concedido a:


Hello David, I am an expert in data collection. I have done many similar jobs. I can complete this in 2 or 3 days. Thanks, Alex

$250 USD em 2 dias
(106 Comentários)

36 freelancers are bidding on average $380 for this job


Hello, We are professional team of data entry operators having vast knowledge of all type of data entry work with research skills. We provide high quality and time committed service with full of accuracy as my all Mais

$515 USD in 5 dias
(299 Comentários)

Hi, We are once-again very happy to place our bid. we already worked for you in first 2 projects. I have gone through the project requirement and example. we can get you all the data according to your specification. Mais

$555 USD in 7 dias
(141 Comentários)

Hi. I read project description carefully and also understood the example given. Getting all records for 569 RIN numbers with mentioned pieces of information into excel will be done within 7 days with 100% accuracy. We Mais

$750 USD in 7 dias
(125 Comentários)

Hi David, As you remember, we've worked together before on a very similar project; you know I can handle this one as well. I have checked the site and it shouldn't take longer than 2-3 days. I'm available to get to Mais

$265 USD in 3 dias
(161 Comentários)

Hi David,I am Joshua.I would like to do this project as per your requirements. I have excellent Web Extraction & Data Entry Skills.I have 8 [url removed, login to view]'re a professional team. We've done many similar [url removed, login to view] tha Mais

$600 USD in 7 dias
(182 Comentários)

Dear "DavidLewisVU" Hope you are doing well. I have reviewed the project details and would like to offer our services. We have completed many Research/Data collection/Product add/Data mining assignments on freelance Mais

$600 USD in 6 dias
(58 Comentários)

Dear sir, I'm so interested in your project. Already i find RIN #2060-AM06 ang get result Title: ●Control of Emissions From New Locomotives and New Marine Diesel Engines Less Than 30 Liters per Cylinder Additiona Mais

$309 USD in 3 dias
(157 Comentários)

Hello Sir, We are a well built set up with excellent skilled operator with lot of experience in this segment/skill, We have complete more than 300 similar job, i have gone through your project description, its reall Mais

$250 USD in 2 dias
(100 Comentários)

I will provide example data with RIN 2060-AM06 if you agree. let me know Thanks, Kimi ----------- Hi sir, Can we discuss more details? ---------------- Hi sir, I am scraping expert, I have did Mais

$315 USD in 3 dias
(101 Comentários)

Hi.. Expert web scraper/Data Minor here. Interested in your project. I assure you 100% accurate and good quality work. I have too too scraping experience. let me know if you want sample before awarding. lets start. Reg Mais

$421 USD in 3 dias
(76 Comentários)

Hello; your 5-star data scraping expert is ready to help you...kindly check my profile to have some idea about the quality of my work. I had many similar scraping tasks, all achieved with 5/5 rating...I read your proje Mais

$250 USD in 5 dias
(61 Comentários)

Sir, I am well versed in this kind of jobs and can do your project as per requirement. Refer my online work portfolio at [url removed, login to view] Looking for further discussions in this matter. with than Mais

$263 USD in 7 dias
(72 Comentários)

Hi, I went through the project description and RIN data as well and I would like to submit my offer on your project. I have created a sample file by using the RIN code you provided in project description. Please do Mais

$250 USD in 4 dias
(39 Comentários)

Hi, thanks for your consideration. I am expert in web scraping with good feedback, I have visited the site and sure I can get what you want, hope can work for you, thanks.

$277 USD in 3 dias
(42 Comentários)

I have seen your requirements and read all the details. You can see my profile that i deliver as promised so i will take care of your project and will provide you 100% results on this project. Thanks, Ahmed

$335 USD in 5 dias
(101 Comentários)

Hi, After reading your project description. I am willing to do this job for you and ready to work immediately, following your instructions. Kind Regards, Noushin Jahan

$300 USD in 2 dias
(45 Comentários)

Hello, Sir I am from vSol CORP. We are 19 people team, worked on more than 500 completed projects. We provide round the clock service. I have checked your project requirement. We are professional web scrapper. We Mais

$298 USD in 4 dias
(49 Comentários)

Hi sir I'm professional web data extractor, I can provide the data you need, wait for your reply, thanks. Regards Nathan

$277 USD in 3 dias
(35 Comentários)

Hi David, If you still need help I can do it with full accuracy in less than 5 days. Best wishes Sorin

$444 USD in 5 dias
(42 Comentários)

Dear sir, I can do this work according to your requirements. i am able to handle this with my best care and creativity. I have done this type of data entry project previously. I assure you that i can complete you Mais

$555 USD in 3 dias
(67 Comentários)