csc-mio / food_safety_inspections_scraper_cornwall

Food safety inspections Cornwall

Last run failed with status code 1.

Console output of last run

/usr/local/rvm/gems/ruby-1.9.2-p320/gems/sqlite_magic-0.0.3/lib/sqlite_magic.rb:91:in `block in save_data' : Data has nil value for unique key. Unique keys are ["id"]. Offending data: {:id=>"669613", :councilid=>"CP13_000890", :date=>"2013-05-30", :name=>"@ Home", :link=>"http://ratings.food.gov.uk/business/en-GB/669613", :address=>"", :postcode=>nil, :rating=>"5", :type=>"Mobile caterer", :rss_date=>"Thursday, 30 May 2013 00:00:00 +00:00", :lat=>"", :lng=>""} (SqliteMagic::DatabaseError) from /usr/local/rvm/gems/ruby-1.9.2-p320/gems/sqlite_magic-0.0.3/lib/sqlite_magic.rb:88:in `each' from /usr/local/rvm/gems/ruby-1.9.2-p320/gems/sqlite_magic-0.0.3/lib/sqlite_magic.rb:88:in `save_data' from /usr/local/rvm/gems/ruby-1.9.2-p320/gems/scraperwiki-3.0.1/lib/scraperwiki.rb:89:in `save_sqlite' from /usr/local/rvm/gems/ruby-1.9.2-p320/gems/scraperwiki-3.0.1/lib/scraperwiki.rb:94:in `save' from /repo/scraper.rb:38:in `block in <main>' from /repo/scraper.rb:22:in `each' from /repo/scraper.rb:22:in `<main>'

Data

Downloaded 1 time by MikeRalphson

To download data sign in with GitHub

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

rows 10 / 3906

rating councilid name rss_date lat link postcode address date lng type id
5
E2_04_00262_MIXED
JB's Snack Bar
Wednesday, 02 May 2012 00:00:00 +00:00
http://ratings.food.gov.uk/business/en-GB/402506
PL13 2RG
Coombe House, The Coombes, Polperro, Looe, PL13 2RG
2012-05-02
Restaurant/Cafe/Canteen
402506
Exempt
E2_04_00303_MIXED
Sea Haze Guest House
Thursday, 29 Mar 2012 00:00:00 +00:00
-4.49275800000000
http://ratings.food.gov.uk/business/en-GB/402507
PL13 2JS
Polperro Road, West Looe, Looe, Cornwall, PL13 2JS
2012-03-29
50.35302800000000
Hotel/Guest House
402507
Exempt
CP11_000961
Bed And Breakfast
Monday, 23 Apr 2012 00:00:00 +00:00
-4.80306800000000
http://ratings.food.gov.uk/business/en-GB/402209
PL26 8XF
Rivendell, Ruddlemoor, St Austell, Cornwall, PL26 8XF
2012-04-23
50.36281400000000
Hotel/Guest House
402209
Exempt
CP12_000090
Bed And Breakfast
Monday, 23 Apr 2012 00:00:00 +00:00
-4.78023300000000
http://ratings.food.gov.uk/business/en-GB/402227
PL26 8TY
Tonkins Row, Carluddon, St Austell, Cornwall, PL26 8TY
2012-04-23
50.36813900000000
Hotel/Guest House
402227
5
CP12_000385
Got Game Ltd
Tuesday, 03 Jul 2012 00:00:00 +00:00
http://ratings.food.gov.uk/business/en-GB/415135
TR2 4NN
Skyber Noweth, New Mills, Ladock, Truro, TR2 4NN
2012-07-03
Mobile Food Unit
415135
4
W1_10_12134_COM
Halsetown Inn
Wednesday, 14 Mar 2012 00:00:00 +00:00
-5.49523258209228
http://ratings.food.gov.uk/business/en-GB/402679
TR26 3NA
Halsetown, St Ives, Cornwall, TR26 3NA
2012-03-14
50.19635772705080
Pub/Club
402679
Exempt
W1_10_10453_COM
Hotel St Eia
Tuesday, 17 Apr 2012 00:00:00 +00:00
-5.47622000000000
http://ratings.food.gov.uk/business/en-GB/402604
TR26 2AA
Trelyon Avenue, St Ives, Cornwall, TR26 2AA
2012-04-17
50.20703100000000
Hotel/Guest House
402604
Exempt
CP12_000311
Lowendra B&B
Friday, 16 Mar 2012 00:00:00 +00:00
-5.60738500000000
http://ratings.food.gov.uk/business/en-GB/402274
TR19 6DG
Downs Barn, St Buryan, Penzance, Cornwall, TR19 6DG
2012-03-16
50.06460300000000
Hotel/Guest House
402274
Exempt
CP12_000242
Oak Bee Bed And Breakfast
Tuesday, 27 Mar 2012 00:00:00 +00:00
-4.37809000000000
http://ratings.food.gov.uk/business/en-GB/402248
PL11 3JA
Brenton Road, Downderry, Torpoint, Cornwall, PL11 3JA
2012-03-27
50.36303200000000
Hotel/Guest House
402248
Exempt
E2_04_00167_MIXED
Pendower House
Thursday, 17 May 2012 00:00:00 +00:00
-4.45280400000000
http://ratings.food.gov.uk/business/en-GB/402503
PL13 2DE
Hannafore Road, West Looe, Looe, Cornwall, PL13 2DE
2012-05-17
50.35059500000000
Hotel/Guest House
402503

Statistics

Total run time: 2 minutes

Total cpu time used: less than 5 seconds

Total disk space used: 1.33 MB

History

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