Project Detail

Description

Project Description:

The 4 web links below contain data on approximately 4,700 different laws that were offered in the US Senate in the 109th Congress. For each law, the linked webpage displays information on “Number” “Title”, “Sponsor” “Committees” “Date Introduced” “Latest Major Action” and sometimes also has information under the headings “Cosponsors” and/or “Notes.” [Be aware that the data on “date introduced” appears in the same line as the data on “Sponsor” and so does not enjoy a its own separate bold typeface heading.]

I need these 6-8 fields of data on each of these 4,700 laws entered into excel -- one row for each law.
LINKS

http://thomas.loc.gov/cgi-bin/bdquery/d?d109:0:./list/bss/d109SN.lst:|TOM:/bss/109search.html|
http://thomas.loc.gov/cgi-bin/bdquery/d?d109:0:./list/bss/d109SJ.lst:|TOM:/bss/109search.html|
http://thomas.loc.gov/cgi-bin/bdquery/d?d109:0:./list/bss/d109SE.lst:|TOM:/bss/109search.html|
http://thomas.loc.gov/cgi-bin/bdquery/d?d109:0:./list/bss/d109SC.lst:|TOM:/bss/109search.html|

EACH LINK POINTS TO ONLY THE FIRST PAGE OF MANY PAGES OF DATA SO DO NOT FORGET TO CLICK ON “NEXT PAGE” (top left of the webpage) UNTIL YOU HAVE COVERED THE ENTIRE SET OF DATA UNDER EACH OF THE 4 LINKS.

The end product should be 4 different excel files (1 for each of the 4 corresponding weblinks) for a total of approximately 4,700 rows of data. Each row represents a law and consists of from 6 to 8 individual cells with data on the law’s “date”, “sponsor” etc.

Bid Requirements:
• Bid price must be visible, not hidden
• Bid must specify the time needed to complete the task after winning the project which should not exceed 4 days.

• Include "hi dan" in your bid to confirm understanding/agreement with these terms.

Thanks!