MichaelPhilippone / MP_craigslist_flagger

Craigslist_Flagger

Last run failed with status code 1.

Console output of last run

Traceback (most recent call last): File "/repo/scraper.py", line 87, in <module> scrapes = scraperwiki.sqlite.select("* from 'swdata'") File "/usr/local/lib/python2.7/dist-packages/scraperwiki-0.3.7-py2.7.egg/scraperwiki/sqlite.py", line 41, in select result = dt.execute(sqlquery, data, commit = False) File "/usr/local/lib/python2.7/dist-packages/dumptruck-0.1.5-py2.7.egg/dumptruck/dumptruck.py", line 136, in execute self.cursor.execute(sql, *args) sqlite3 . OperationalError : no such table: swdata

Data

Downloaded 0 times

To download data sign in with GitHub

Download table (as CSV) Download SQLite database (123 KB) Use the API

rows 10 / 368

date_scraped title link location flag_url id
2013-02-14T05:28:37.955339
Studio Rosslyn,River Place East
http://washingtondc.craigslist.org/doc/apa/3575630121.html
Rosslyn Metro,Arlington
http://washingtondc.craigslist.org/flag/?flagcode=15&postingID=3575630121
3575630121
2013-02-14T05:28:37.955339
Nearby to Sligo Creek Parkway, a short distance to Silver Spring Metro
http://washingtondc.craigslist.org/doc/apa/3616011393.html
Silver Spring
http://washingtondc.craigslist.org/flag/?flagcode=15&postingID=3616011393
3616011393
2013-02-14T05:28:37.955339
Beautiful Single House
http://washingtondc.craigslist.org/doc/apa/3615942530.html
Silver Spring MD 20904White Oak area
http://washingtondc.craigslist.org/flag/?flagcode=15&postingID=3615942530
3615942530
2013-02-14T05:28:37.955339
1 BR APT 10 MIN FROM COURTHOUSE METRO FREE STAY AND FURNITURE!!!
http://washingtondc.craigslist.org/doc/apa/3615900124.html
ARLINGTON
http://washingtondc.craigslist.org/flag/?flagcode=15&postingID=3615900124
3615900124
2013-02-14T05:28:37.955339
Professional moving service call 571 501 4773 ...
http://washingtondc.craigslist.org/doc/apa/3591224546.html
VA, DC, MD
http://washingtondc.craigslist.org/flag/?flagcode=15&postingID=3591224546
3591224546
2013-02-14T05:28:37.955339
Professional moving service call 571 501 4773 ...
http://washingtondc.craigslist.org/doc/apa/3596540890.html
MARYLAND,DC,VA
http://washingtondc.craigslist.org/flag/?flagcode=15&postingID=3596540890
3596540890
2013-02-14T05:28:37.955339
Basement Room -Utilities inclu
http://washingtondc.craigslist.org/doc/apa/3615849690.html
McLean VA
http://washingtondc.craigslist.org/flag/?flagcode=15&postingID=3615849690
3615849690
2013-02-20T12:11:01.351174
2 Bed inside noma area with upgrades
http://washingtondc.craigslist.org/doc/apa/3606349772.html
DC, NOMA
http://washingtondc.craigslist.org/flag/?flagcode=15&postingID=3606349772
3606349772
2013-02-20T12:11:01.351174
1 Bedroom Apartment
http://washingtondc.craigslist.org/doc/apa/3630103111.html
Bethesda, MD
http://washingtondc.craigslist.org/flag/?flagcode=15&postingID=3630103111
3630103111
2013-02-20T12:11:01.351174
This Apartment Outshines Them All!
http://washingtondc.craigslist.org/doc/apa/3629953726.html
Atlas, NoMa, Gallaudet
http://washingtondc.craigslist.org/flag/?flagcode=15&postingID=3629953726
3629953726

Statistics

Total run time: less than 5 seconds

Total cpu time used: less than 5 seconds

Total disk space used: 145 KB

History

  • Manually ran revision 2114e85c and failed .
  • Created on morph.io