ScraperWiki Classic is now read-only.

But don’t worry! You can transfer this scraper to Morph.io if you want to continue editing it.

Transfer to Morph.io

Current status

Idle – not scheduled to run

Last run

1 year, 2 months ago

Scraped 526 pages from www.marketnews.usda.gov

About this scraper

Scrapes commodities categorized under “Browse by Commodity” at this USDA Market News site: http://www.marketnews.usda.gov/portal/fv. Each day, the database stores category, commodity, lowPriceMin, highPriceMax, cityName, originName, itemSize, date and a pointer to the XML source. Currently it parses the XML source into the data store, but this is too slow (the connection frequently times out). I'd like to change it to parse the HTML table on the commodity page instead. (Feel free to do so!) Timeout errors create holes in the data.

This scraper is public

Anyone can see this scraper, and any registered user can edit it.

Users who have contributed to this scraper:

December 2012
Permalink Hide details Show details 1356960637.581243_ebb0df2e-0b61-47fd-9349-0ca5badf0313 15:29, 31 December 2012 1356763473.245869_894e44b1-0580-44fd-b083-3d08804c8dab 07:48, 29 December 2012
Run succeeded: - ran 2 times, most recently for 0 seconds (526 scraped pages, 11267 records) 15:29, 31 December 2012

Loading...


          
Permalink Hide details Show details 1356652987.323588_7013e959-38a2-4c55-ac8f-09d53d917126 00:23, 28 December 2012
Run failed: #<SqliteException: Query timeout: > - ran for 0 seconds (6 scraped pages, 1312 records) 00:23, 28 December 2012

Loading...


          
Permalink Hide details Show details 1356205265.937397_27e49834-233f-4e83-a904-dc042f6665f0 19:42, 22 December 2012
Run failed: #<HTTPClient::ReceiveTimeoutError: execution expired> - ran for 0 seconds (0 scraped pages, 0 records) 19:42, 22 December 2012

Loading...


          
Permalink Hide details Show details 1356106591.875028_86a63db5-848b-4234-b7b7-b709da3a427f 16:39, 21 December 2012 1356018210.510007_c692b608-6831-4327-9014-8baec6798984 16:16, 20 December 2012
Run failed: #<SqliteException: Query timeout: > - ran for 0 seconds (4 scraped pages, 831 records) 16:39, 21 December 2012

Loading...


          
Permalink Hide details Show details 1355931725.039983_2d54f077-b50b-4413-8879-4ed72bd49b6f 15:42, 19 December 2012
Run failed: #<SqliteException: dataproxy.process: database is locked> - ran for 0 seconds (2 scraped pages, 0 records) 15:42, 19 December 2012

Loading...


          
Permalink Hide details Show details 1355929474.598654_56eb2fd1-89d2-4fbc-b4be-6aa60d5e8ef3 15:41, 19 December 2012
Run failed: #<SqliteException: Query timeout: > - ran for 0 seconds (4 scraped pages, 487 records) 15:41, 19 December 2012

Loading...


          
Permalink Hide details Show details 1355837194.099115_df9925c6-9714-4f2c-8f5b-7fd7dfe533cb 13:26, 18 December 2012
Run failed: #<SqliteException: dataproxy.process: database is locked> - ran for 0 seconds (2 scraped pages, 0 records) 13:26, 18 December 2012

Loading...


          
Permalink Hide details Show details 1355837013.158917_5f2e4fa8-81a5-40a1-a298-f7676e64d35b 13:26, 18 December 2012
Run failed: #<SqliteException: Query timeout: > - ran for 0 seconds (4 scraped pages, 21 records) 13:26, 18 December 2012

Loading...


          
June 2011
Hide changes Show changes 9 04:07, 7 June 2011 8 8 04:05, 7 June 2011 7 7 04:00, 7 June 2011 6 6 03:58, 7 June 2011 5
Edited by Kevin Curry 4 times 04:07, 7 June 2011

Loading...

Difference between, revision and previous revision


            
Hide changes Show changes 5 03:55, 7 June 2011 4 4 03:53, 7 June 2011 3
Edited by Kevin Curry 2 times 03:55, 7 June 2011

Loading...

Difference between, revision and previous revision


            
Hide changes Show changes 3 03:50, 7 June 2011 2 2 03:35, 7 June 2011 1
Edited by Kevin Curry 2 times 03:50, 7 June 2011

Loading...

Difference between, revision and previous revision


            
Hide changes Show changes 1 03:10, 7 June 2011 0
Edited by Kevin Curry 03:10, 7 June 2011

Loading...

Difference between, revision and previous revision


            
May 2011
Hide first version Show first version 0 21:40, 18 May 2011
Edited by Kevin Curry 21:40, 18 May 2011

Loading...

Difference between, revision and previous revision