In Progress

U.S. Federal Regulations (RIN) -- Data Collection by XML or Web Scraping

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. There are about 569 unique RIN numbers for which I need data. Each RIN number would be a row. The columns would be data scraped from the “View Rule” page for each RIN (see, for example, [url removed, login to view]).

**The website includes a link to RIN data for all RIN numbers in XML. It may be easier to simply put all of this XML data into a spreadsheet. I would be willing to pay for this also, even the RIN numbers I have not specifically asked for.

If the XML data cannot be easily converted to spreadsheet from, the specific data I need from the web pages are:

1. RIN [1 column]

2. Publication ID [1 column]

3. Title [1 column]

4. Abstract [1 column]

5. Agency[1 column]

6. Priority [1 column]

7. RIN Status [1 column]

8. Agenda Stage of Rulemaking [1 column]

9. Major [1 column]

10. Unfunded Mandates [1 column]

11. CFR Citation [1 column]

12. Legal Authority [1 column]

13. Legal Deadline: [4 columns. In most cases this will say “None”. However, in some cases it will include data on a source, description and date. There may also be cases where there is more than one entry here. I need the number of entries (i.e., the number of rows) and data from the entry (source, description, and date). If there is more than one entry, use the data from the last entry.

14. Timetable: [3 columns; This portion of the page often includes multiple entries (i.e., multiple rows of data). I do not need all of it. I need the number of entries (i.e., the number of rows) and data from entries called “Final Action.” Specifically, I need Date and FR Cite for “Final Action” entries.]

15. Regulatory Flexibility Analysis [1 column]

16. Government Levels Affected [1 column]

17. Federalism [1 column]

18. Included in the Regulatory Plan [1 column]

19. RIN Data Printed in the FR [1 column]

20. 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 RIN and placed in the columns.

Skills: Data Entry, Excel, Web Scraping

See more: web scraping legal, government entry, government Data, data stage 8.1, data government, 14 cfr, is web scraping legal, data entry rules, xml excel, xml data entry, www data entry gov, web scraping excel, Web Scraping email, rin, government data entry, federal, data entry web scraping excel, Data Entry for Government, data collection and data entry, Data analysis in excel , collection view, analysis data excel, analysis excel spreadsheet, excel timetable, website analysis scraping

About the Employer:
( 9 reviews ) Nashville, United States

Project ID: #4407886

Awarded to:

lafor

Shouldn't take longer than 1-2 days.

$300 USD in 2 days
(116 Reviews)
6.6

11 freelancers are bidding on average $365 for this job

mantislin

Hi sir, please check PM, thx Kimi.

$550 USD in 6 days
(79 Reviews)
6.2
jitendraparmar07

Automation expert here. I can easily write such a bot/scraper.Please check your PMB.

$300 USD in 3 days
(16 Reviews)
4.7
iit2009013

Hi, I have seen the website and after analyzing the webpage I can write a python script for this task to automatically scrape the data and output them in an excel sheet. The webpage of each rule also contains the RIN n More

$275 USD in 3 days
(11 Reviews)
4.1
seaanddream

Hi, your top-rated freelancer is ready to help your project. regards,

$250 USD in 7 days
(16 Reviews)
3.8
baki1

Hello! After reading your project description I feel that I am a good candidate for the job. Please check private message inbox for details.

$500 USD in 7 days
(7 Reviews)
3.8
EvanKos

Hi, i can help you with that.

$544 USD in 7 days
(3 Reviews)
3.8
afua23

I can get this done for you. I have gone to the site and seen how the whole thing is. I have the ability to do web scrapping on the site or i can download the xml version and put it into excel for you.

$250 USD in 3 days
(14 Reviews)
3.5
MaTeMaTiKci

Hi there, I have done pretty similar job before on FL. Please check my reviews to get convinced. Please also check my PMB. Thanks!

$550 USD in 0 days
(3 Reviews)
3.3
AlejandroCuba

Hello, I'd love to work in this project, i can start right now. Best Regards

$250 USD in 2 days
(1 Review)
1.4
jacobpostman

Hi David, I can put together this data for you pretty quickly. Please see PM for more details.

$250 USD in 1 day
(1 Review)
1.0
BgEKIVYHTKqV

Hello, We are freelance software developers. If you contact us, we can give a quote for your project and we can discuss the details. w w w . so l v er . i o

$500 USD in 3 days
(0 Reviews)
0.0