CharlotteMaher / TESTPYTHONTROLLEY

Chapter 14 of book


Contributors CharlotteMaher

Last run failed with status code 1.

Console output of last run

Injecting configuration and compiling... Injecting scraper and running... Click on the ...more link to see the whole page [<Element td at 0x7fc819894730>, <Element td at 0x7fc819894788>, <Element td at 0x7fc8198947e0>, <Element td at 0x7fc819894838>, <Element td at 0x7fc819894890>, <Element td at 0x7fc8198948e8>, <Element td at 0x7fc819894940>, <Element td at 0x7fc819894998>, <Element td at 0x7fc8198949f0>, <Element td at 0x7fc819894a48>, <Element td at 0x7fc819894aa0>, <Element td at 0x7fc819894af8>, <Element td at 0x7fc819894b50>, <Element td at 0x7fc819894ba8>, <Element td at 0x7fc819894c00>, <Element td at 0x7fc819894c58>, <Element td at 0x7fc819894cb0>, <Element td at 0x7fc819894d08>, <Element td at 0x7fc819894d60>, <Element td at 0x7fc819894db8>, <Element td at 0x7fc819894e10>, <Element td at 0x7fc819894e68>, <Element td at 0x7fc819894ec0>, <Element td at 0x7fc819894f18>, <Element td at 0x7fc819894f70>, <Element td at 0x7fc819894fc8>, <Element td at 0x7fc81981a050>, <Element td at 0x7fc81981a0a8>, <Element td at 0x7fc81981a100>, <Element td at 0x7fc81981a158>, <Element td at 0x7fc81981a1b0>, <Element td at 0x7fc81981a208>, <Element td at 0x7fc81981a260>, <Element td at 0x7fc81981a2b8>, <Element td at 0x7fc81981a310>, <Element td at 0x7fc81981a368>, <Element td at 0x7fc81981a3c0>, <Element td at 0x7fc81981a418>, <Element td at 0x7fc81981a470>, <Element td at 0x7fc81981a4c8>, <Element td at 0x7fc81981a520>, <Element td at 0x7fc81981a578>, <Element td at 0x7fc81981a5d0>, <Element td at 0x7fc81981a628>, <Element td at 0x7fc81981a680>, <Element td at 0x7fc81981a6d8>, <Element td at 0x7fc81981a730>, <Element td at 0x7fc81981a788>, <Element td at 0x7fc81981a7e0>, <Element td at 0x7fc81981a838>, <Element td at 0x7fc81981a890>, <Element td at 0x7fc81981a8e8>, <Element td at 0x7fc81981a940>, <Element td at 0x7fc81981a998>, <Element td at 0x7fc81981a9f0>, <Element td at 0x7fc81981aa48>, <Element td at 0x7fc81981aaa0>, <Element td at 0x7fc81981aaf8>, <Element td at 0x7fc81981ab50>, <Element td at 0x7fc81981aba8>, <Element td at 0x7fc81981ac00>, <Element td at 0x7fc81981ac58>, <Element td at 0x7fc81981acb0>, <Element td at 0x7fc81981ad08>, <Element td at 0x7fc81981ad60>, <Element td at 0x7fc81981adb8>, <Element td at 0x7fc81981ae10>, <Element td at 0x7fc81981ae68>, <Element td at 0x7fc81981aec0>, <Element td at 0x7fc81981af18>, <Element td at 0x7fc81981af70>, <Element td at 0x7fc81981afc8>, <Element td at 0x7fc81981b050>, <Element td at 0x7fc81981b0a8>, <Element td at 0x7fc81981b100>, <Element td at 0x7fc81981b158>, <Element td at 0x7fc81981b1b0>, <Element td at 0x7fc81981b208>, <Element td at 0x7fc81981b260>, <Element td at 0x7fc81981b2b8>, <Element td at 0x7fc81981b310>, <Element td at 0x7fc81981b368>, <Element td at 0x7fc81981b3c0>, <Element td at 0x7fc81981b418>, <Element td at 0x7fc81981b470>, <Element td at 0x7fc81981b4c8>, <Element td at 0x7fc81981b520>, <Element td at 0x7fc81981b578>, <Element td at 0x7fc81981b5d0>, <Element td at 0x7fc81981b628>, <Element td at 0x7fc81981b680>, <Element td at 0x7fc81981b6d8>, <Element td at 0x7fc81981b730>, <Element td at 0x7fc81981b788>, <Element td at 0x7fc81981b7e0>, <Element td at 0x7fc81981b838>, <Element td at 0x7fc81981b890>, <Element td at 0x7fc81981b8e8>, <Element td at 0x7fc81981b940>, <Element td at 0x7fc81981b998>, <Element td at 0x7fc81981b9f0>, <Element td at 0x7fc81981ba48>, <Element td at 0x7fc81981baa0>, <Element td at 0x7fc81981baf8>, <Element td at 0x7fc81981bb50>, <Element td at 0x7fc81981bba8>, <Element td at 0x7fc81981bc00>, <Element td at 0x7fc81981bc58>, <Element td at 0x7fc81981bcb0>, <Element td at 0x7fc81981bd08>, <Element td at 0x7fc81981bd60>, <Element td at 0x7fc81981bdb8>, <Element td at 0x7fc81981be10>, <Element td at 0x7fc81981be68>, <Element td at 0x7fc81981bec0>, <Element td at 0x7fc81981bf18>, <Element td at 0x7fc81981bf70>, <Element td at 0x7fc81981bfc8>, <Element td at 0x7fc81981c050>, <Element td at 0x7fc81981c0a8>, <Element td at 0x7fc81981c100>, <Element td at 0x7fc81981c158>, <Element td at 0x7fc81981c1b0>, <Element td at 0x7fc81981c208>, <Element td at 0x7fc81981c260>, <Element td at 0x7fc81981c2b8>, <Element td at 0x7fc81981c310>, <Element td at 0x7fc81981c368>, <Element td at 0x7fc81981c3c0>, <Element td at 0x7fc81981c418>, <Element td at 0x7fc81981c470>, <Element td at 0x7fc81981c4c8>, <Element td at 0x7fc81981c520>, <Element td at 0x7fc81981c578>, <Element td at 0x7fc81981c5d0>, <Element td at 0x7fc81981c628>, <Element td at 0x7fc81981c680>, <Element td at 0x7fc81981c6d8>, <Element td at 0x7fc81981c730>, <Element td at 0x7fc81981c788>, <Element td at 0x7fc81981c7e0>, <Element td at 0x7fc81981c838>, <Element td at 0x7fc81981c890>, <Element td at 0x7fc81981c8e8>, <Element td at 0x7fc81981c940>, <Element td at 0x7fc81981c998>, <Element td at 0x7fc81981c9f0>, <Element td at 0x7fc81981ca48>, <Element td at 0x7fc81981caa0>, <Element td at 0x7fc81981caf8>, <Element td at 0x7fc81981cb50>, <Element td at 0x7fc81981cba8>, <Element td at 0x7fc81981cc00>, <Element td at 0x7fc81981cc58>, <Element td at 0x7fc81981ccb0>, <Element td at 0x7fc81981cd08>, <Element td at 0x7fc81981cd60>, <Element td at 0x7fc81981cdb8>, <Element td at 0x7fc81981ce10>, <Element td at 0x7fc81981ce68>, <Element td at 0x7fc81981cec0>, <Element td at 0x7fc81981cf18>, <Element td at 0x7fc81981cf70>, <Element td at 0x7fc81981cfc8>, <Element td at 0x7fc81981d050>, <Element td at 0x7fc81981d0a8>, <Element td at 0x7fc81981d100>, <Element td at 0x7fc81981d158>, <Element td at 0x7fc81981d1b0>, <Element td at 0x7fc81981d208>, <Element td at 0x7fc81981d260>, <Element td at 0x7fc81981d2b8>, <Element td at 0x7fc81981d310>, <Element td at 0x7fc81981d368>, <Element td at 0x7fc81981d3c0>, <Element td at 0x7fc81981d418>, <Element td at 0x7fc81981d470>, <Element td at 0x7fc81981d4c8>, <Element td at 0x7fc81981d520>, <Element td at 0x7fc81981d578>, <Element td at 0x7fc81981d5d0>, <Element td at 0x7fc81981d628>, <Element td at 0x7fc81981d680>, <Element td at 0x7fc81981d6d8>, <Element td at 0x7fc81981d730>, <Element td at 0x7fc81981d788>, <Element td at 0x7fc81981d7e0>, <Element td at 0x7fc81981d838>, <Element td at 0x7fc81981d890>, <Element td at 0x7fc81981d8e8>, <Element td at 0x7fc81981d940>, <Element td at 0x7fc81981d998>, <Element td at 0x7fc81981d9f0>, <Element td at 0x7fc81981da48>, <Element td at 0x7fc81981daa0>, <Element td at 0x7fc81981daf8>, <Element td at 0x7fc81981db50>, <Element td at 0x7fc81981dba8>, <Element td at 0x7fc81981dc00>, <Element td at 0x7fc81981dc58>, <Element td at 0x7fc81981dcb0>, <Element td at 0x7fc81981dd08>, <Element td at 0x7fc81981dd60>, <Element td at 0x7fc81981ddb8>, <Element td at 0x7fc81981de10>, <Element td at 0x7fc81981de68>, <Element td at 0x7fc81981dec0>, <Element td at 0x7fc81981df18>, <Element td at 0x7fc81981df70>, <Element td at 0x7fc81981dfc8>, <Element td at 0x7fc81981e050>, <Element td at 0x7fc81981e0a8>, <Element td at 0x7fc81981e100>, <Element td at 0x7fc81981e158>, <Element td at 0x7fc81981e1b0>, <Element td at 0x7fc81981e208>] <td>Date</td> Date <td>Hospital</td> Hospital <td>Region</td> Region <td class="Number">Trolley Total</td> Trolley Total <td class="Number">Ward Total</td> Ward Total <td class="Number">Total</td> Total <td>02/07/2019</td> 02/07/2019 <td>Beaumont Hospital</td> Beaumont Hospital <td>Eastern</td> Eastern <td class="Number">7</td> 7 <td class="Number">7</td> 7 <td class="Number">14</td> 14 <td>02/07/2019</td> 02/07/2019 <td>Children's University Hospital, Temple Street</td> Children's University Hospital, Temple Street <td>Eastern</td> Eastern <td class="Number">0</td> 0 <td class="Number">0</td> 0 <td class="Number">0</td> 0 <td>02/07/2019</td> 02/07/2019 <td>Connolly Hospital, Blanchardstown</td> Connolly Hospital, Blanchardstown <td>Eastern</td> Eastern <td class="Number">5</td> 5 <td class="Number">6</td> 6 <td class="Number">11</td> 11 <td>02/07/2019</td> 02/07/2019 <td>Mater Misericordiae University Hospital</td> Mater Misericordiae University Hospital <td>Eastern</td> Eastern <td class="Number">31</td> 31 <td class="Number">0</td> 0 <td class="Number">31</td> 31 <td>02/07/2019</td> 02/07/2019 <td>Naas General Hospital</td> Naas General Hospital <td>Eastern</td> Eastern <td class="Number">4</td> 4 <td class="Number">3</td> 3 <td class="Number">7</td> 7 <td>02/07/2019</td> 02/07/2019 <td>National Children's Hospital, Tallaght</td> National Children's Hospital, Tallaght <td>Eastern</td> Eastern <td class="Number">0</td> 0 <td class="Number">0</td> 0 <td class="Number">0</td> 0 <td>02/07/2019</td> 02/07/2019 <td>Our Lady's Children's Hospital, Crumlin</td> Our Lady's Children's Hospital, Crumlin <td>Eastern</td> Eastern <td class="Number">1</td> 1 <td class="Number">0</td> 0 <td class="Number">1</td> 1 <td>02/07/2019</td> 02/07/2019 <td>St James' Hospital</td> St James' Hospital <td>Eastern</td> Eastern <td class="Number">1</td> 1 <td class="Number">0</td> 0 <td class="Number">1</td> 1 <td>02/07/2019</td> 02/07/2019 <td>St Vincent's University Hospital</td> St Vincent's University Hospital <td>Eastern</td> Eastern <td class="Number">25</td> 25 <td class="Number">0</td> 0 <td class="Number">25</td> 25 <td>02/07/2019</td> 02/07/2019 <td>Tallaght University Hospital</td> Tallaght University Hospital <td>Eastern</td> Eastern <td class="Number">21</td> 21 <td class="Number">7</td> 7 <td class="Number">28</td> 28 <td>02/07/2019</td> 02/07/2019 <td>Bantry General Hospital</td> Bantry General Hospital <td>Country</td> Country <td class="Number">0</td> 0 <td class="Number">7</td> 7 <td class="Number">7</td> 7 <td>02/07/2019</td> 02/07/2019 <td>Cavan General Hospital</td> Cavan General Hospital <td>Country</td> Country <td class="Number">1</td> 1 <td class="Number">5</td> 5 <td class="Number">6</td> 6 <td>02/07/2019</td> 02/07/2019 <td>Cork University Hospital</td> Cork University Hospital <td>Country</td> Country <td class="Number">34</td> 34 <td class="Number">12</td> 12 <td class="Number">46</td> 46 <td>02/07/2019</td> 02/07/2019 <td>Letterkenny University Hospital</td> Letterkenny University Hospital <td>Country</td> Country <td class="Number">3</td> 3 <td class="Number">4</td> 4 <td class="Number">7</td> 7 <td>02/07/2019</td> 02/07/2019 <td>Mayo University Hospital</td> Mayo University Hospital <td>Country</td> Country <td class="Number">5</td> 5 <td class="Number">8</td> 8 <td class="Number">13</td> 13 <td>02/07/2019</td> 02/07/2019 <td>Mercy University Hospital, Cork</td> Mercy University Hospital, Cork <td>Country</td> Country <td class="Number">8</td> 8 <td class="Number">0</td> 0 <td class="Number">8</td> 8 <td>02/07/2019</td> 02/07/2019 <td>Mid Western Regional Hospital, Ennis</td> Mid Western Regional Hospital, Ennis <td>Country</td> Country <td class="Number">0</td> 0 <td class="Number">0</td> 0 <td class="Number">0</td> 0 <td>02/07/2019</td> 02/07/2019 <td>Midland Regional Hospital, Mullingar</td> Midland Regional Hospital, Mullingar <td>Country</td> Country <td class="Number">4</td> 4 <td class="Number">0</td> 0 <td class="Number">4</td> 4 <td>02/07/2019</td> 02/07/2019 <td>Midland Regional Hospital, Portlaoise</td> Midland Regional Hospital, Portlaoise <td>Country</td> Country <td class="Number">5</td> 5 <td class="Number">0</td> 0 <td class="Number">5</td> 5 <td>02/07/2019</td> 02/07/2019 <td>Midland Regional Hospital, Tullamore</td> Midland Regional Hospital, Tullamore <td>Country</td> Country <td class="Number">11</td> 11 <td class="Number">0</td> 0 <td class="Number">11</td> 11 <td>02/07/2019</td> 02/07/2019 <td>Nenagh General Hospital</td> Nenagh General Hospital <td>Country</td> Country <td class="Number">0</td> 0 <td class="Number">0</td> 0 <td class="Number">0</td> 0 <td>02/07/2019</td> 02/07/2019 <td>Our Lady of Lourdes Hospital, Drogheda</td> Our Lady of Lourdes Hospital, Drogheda <td>Country</td> Country <td class="Number">11</td> 11 <td class="Number">0</td> 0 <td class="Number">11</td> 11 <td>02/07/2019</td> 02/07/2019 <td>Our Lady's Hospital, Navan</td> Our Lady's Hospital, Navan <td>Country</td> Country <td class="Number">2</td> 2 <td class="Number">0</td> 0 <td class="Number">2</td> 2 <td>02/07/2019</td> 02/07/2019 <td>Portiuncula University Hospital</td> Portiuncula University Hospital <td>Country</td> Country <td class="Number">0</td> 0 <td class="Number">0</td> 0 <td class="Number">0</td> 0 <td>02/07/2019</td> 02/07/2019 <td>Sligo University Hospital</td> Sligo University Hospital <td>Country</td> Country <td class="Number">7</td> 7 <td class="Number">6</td> 6 <td class="Number">13</td> 13 <td>02/07/2019</td> 02/07/2019 <td>South Tipperary General Hospital</td> South Tipperary General Hospital <td>Country</td> Country <td class="Number">10</td> 10 <td class="Number">6</td> 6 <td class="Number">16</td> 16 <td>02/07/2019</td> 02/07/2019 <td>St Lukes Hospital, Kilkenny</td> St Lukes Hospital, Kilkenny <td>Country</td> Country <td class="Number">0</td> 0 <td class="Number">0</td> 0 <td class="Number">0</td> 0 <td>02/07/2019</td> 02/07/2019 <td>University College Hospital Galway</td> University College Hospital Galway <td>Country</td> Country <td class="Number">22</td> 22 <td class="Number">5</td> 5 <td class="Number">27</td> 27 <td>02/07/2019</td> 02/07/2019 <td>University Hospital Kerry</td> University Hospital Kerry <td>Country</td> Country <td class="Number">25</td> 25 <td class="Number">0</td> 0 <td class="Number">25</td> 25 <td>02/07/2019</td> 02/07/2019 <td>University Hospital Waterford</td> University Hospital Waterford <td>Country</td> Country <td class="Number">22</td> 22 <td class="Number">7</td> 7 <td class="Number">29</td> 29 <td>02/07/2019</td> 02/07/2019 <td>University Hospital, Limerick</td> University Hospital, Limerick <td>Country</td> Country <td class="Number">24</td> 24 <td class="Number">23</td> 23 <td class="Number">47</td> 47 <td>02/07/2019</td> 02/07/2019 <td>Wexford General Hospital</td> Wexford General Hospital <td>Country</td> Country <td class="Number">1</td> 1 <td class="Number">2</td> 2 <td class="Number">3</td> 3 <td></td> None <td></td> None <td></td> None <td style="width:75px;"></td> None <td style="width:75px;"></td> None <td style="width:75px;"></td> None <td style="font-weight:bold;border-bottom:0px solid #979797; text-align:right; padding-right:15px;" colspan="3">Eastern</td> Eastern <td class="Number" style="font-weight:bold;text-align:right;border:1px solid #979797;background-color:#031f5e; color:#FFF; padding-right:10px;">95</td> 95 <td class="Number" style="font-weight:bold;text-align:right;border:1px solid #979797;background-color:#8b54a8; color:#FFF; padding-right:10px;">23</td> 23 <td class="Number" style="font-weight:bold;text-align:right;border:1px solid #979797;background-color:#979797; color:#FFF; padding-right:10px;">118</td> 118 <td style="font-weight:bold;border-bottom:0px solid #979797; text-align:right; padding-right:15px;" colspan="3">Country</td> Country <td class="Number" style="font-weight:bold;text-align:right;border:1px solid #979797;background-color:#e79301; color:#FFF; padding-right:10px;">195</td> 195 <td class="Number" style="font-weight:bold;text-align:right;border:1px solid #979797;background-color:#83a82f; color:#FFF; padding-right:10px;">85</td> 85 <td class="Number" style="font-weight:bold;text-align:right;border:1px solid #979797;background-color:#979797; color:#FFF; padding-right:10px;">280</td> 280 <td style="font-weight:bold; border-bottom:0px solid #979797; text-align:right; padding-right:15px;" colspan="3">Total</td> Total <td class="Number" style="font-weight:bold;text-align:right;border:1px solid #979797;background-color:#979797; color:#FFF; padding-right:10px;">290</td> 290 <td class="Number" style="font-weight:bold;text-align:right;border:1px solid #979797;background-color:#979797; color:#FFF; padding-right:10px;">108</td> 108 <td class="Number" style="font-weight:bold;text-align:right;border:1px solid #979797;background-color:#979797; color:#FFF; padding-right:10px;">398</td> 398 Traceback (most recent call last): File "scraper.py", line 33, in <module> scraperwiki.sqlite.save(["td"], record) # save the records one by one File "/app/.heroku/src/scraperwiki/scraperwiki/sqlite.py", line 31, in save dt.create_table(data, table_name = table_name, error_if_exists = False) File "/app/.heroku/python/lib/python2.7/site-packages/dumptruck/dumptruck.py", line 204, in create_table raise ValueError(u'You passed no sample values, or all the values you passed were null.') ValueError: You passed no sample values, or all the values you passed were null.

Data

Downloaded 1 time by CharlotteMaher

To download data sign in with GitHub

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

rows 10 / 68

td
Date
Hospital
Region
Trolley Total
Ward Total
Total
Beaumont Hospital
14
Children's University Hospital, Temple Street
Connolly Hospital, Blanchardstown

Statistics

Total run time: half a minute

Total cpu time used: less than 5 seconds

Total disk space used: 42.1 KB

History

  • Manually ran revision 083b0bee and failed .
    68 records added, 68 records removed in the database
  • Manually ran revision 6838c74d and failed .
    nothing changed in the database
  • Manually ran revision 6838c74d and failed .
    nothing changed in the database
  • Manually ran revision e9759906 and failed .
    nothing changed in the database
  • Manually ran revision 381fad65 and failed .
    68 records added, 68 records removed in the database
  • ...
  • Created on morph.io

Show complete history

Scraper code

TESTPYTHONTROLLEY