jdd10 / biographical_directory_usc

Congressional Biographical Directory

Contributors jdd10

Last run failed with status code 1.

Console output of last run

Injecting configuration and compiling... Injecting scraper and running... /app/vendor/bundle/ruby/1.9.1/gems/sqlite3-1.3.9/lib/sqlite3/database.rb:91:in `initialize': near ")": syntax error (SQLite3::SQLException) from /app/vendor/bundle/ruby/1.9.1/gems/sqlite3-1.3.9/lib/sqlite3/database.rb:91:in `new' from /app/vendor/bundle/ruby/1.9.1/gems/sqlite3-1.3.9/lib/sqlite3/database.rb:91:in `prepare' from /app/vendor/bundle/ruby/1.9.1/gems/sqlite3-1.3.9/lib/sqlite3/database.rb:134:in `execute' from /app/vendor/bundle/ruby/1.9.1/gems/sqlite_magic-0.0.3/lib/sqlite_magic.rb:38:in `create_table' from /app/vendor/bundle/ruby/1.9.1/gems/sqlite_magic-0.0.3/lib/sqlite_magic.rb:99:in `rescue in save_data' from /app/vendor/bundle/ruby/1.9.1/gems/sqlite_magic-0.0.3/lib/sqlite_magic.rb:87:in `save_data' from /app/vendor/bundle/ruby/1.9.1/bundler/gems/scraperwiki-ruby-fc5017681250/lib/scraperwiki.rb:89:in `save_sqlite' from scraper.rb:70:in `scrape' from scraper.rb:87:in `action' from scraper.rb:91:in `<main>'

Data

Downloaded 1 time by jdd10

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (17.5 MB) Use the API

rows 10 / 106624

FIRST_NAME LAST_NAME CONGRESS P_URL DOC STATE DEATH BIRTH PARTY POSITION C_YR
Andrew
ADAMS
0
http://bioguide.congress.gov/scripts/biodisplay.pl?index=A000029
2012-01-04T02:12:01
CT
1797
1736
NA
ContCong
John
ADAMS
0
http://bioguide.congress.gov/scripts/biodisplay.pl?index=A000039
2012-01-04T02:12:01
MA
1826
1735
NA
ContCong
John
ADAMS
0
2012-01-04T02:12:01
US
1826
1735
 
Vice President
John
ADAMS
0
2012-01-04T02:12:01
US
1826
1735
Federalist
President
John Quincy
ADAMS
0
http://bioguide.congress.gov/scripts/biodisplay.pl?index=A000041
2012-01-04T02:12:01
US
1848
1767
 
President
Samuel
ADAMS
0
http://bioguide.congress.gov/scripts/biodisplay.pl?index=A000045
2012-01-04T02:12:01
MA
1803
1722
NA
ContCong
Thomas
ADAMS
0
http://bioguide.congress.gov/scripts/biodisplay.pl?index=A000049
2012-01-04T02:12:01
VA
1788
1730
NA
ContCong
Spiro Theodore
AGNEW
0
http://bioguide.congress.gov/scripts/biodisplay.pl?index=A000059
2012-01-04T02:12:01
US
1996
1918
Republican
Vice President
Robert
ALEXANDER
0
http://bioguide.congress.gov/scripts/biodisplay.pl?index=A000101
2012-01-04T02:12:01
MD
1805
1740
NA
ContCong
Andrew
ALLEN
0
http://bioguide.congress.gov/scripts/biodisplay.pl?index=A000113
2012-01-04T02:12:01
PA
1825
1740
NA
ContCong

Statistics

Total run time: half a minute

Total cpu time used: less than 10 seconds

Total disk space used: 17.6 MB

History

  • Manually ran revision dedd5840 and failed .
    nothing changed in the database
  • Manually ran revision dedd5840 and failed .
    nothing changed in the database
  • Created on morph.io