mking007 / mjk1

Rail stations


Contributors mking007

Last run failed with status code 1.

Console output of last run

Traceback (most recent call last): File "/repo/scraper.py", line 29, in <module> print scraperwiki.sqlite.select("TLC 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 1 time by MikeRalphson

To download data sign in with GitHub

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

rows 10 / 2654

date_scraped station_val station_code id station_var Exits Reduced Station Name Check Reason Exits Full Check Detail NUTS2 Spatial Unit Code Entries Reduced District or Unitary Authority London Travelcard Area Station Facility Owner NLC 0910 interchanges Government Office Region GOR Station Group NUTS2 Spatial Unit Entries Total 0910 Entries and Exits TLC Entries Season London Joint Station PTE Urban Area Station Exits Total County or Unitary Authority Exits Season 0809 Entries and Exits Entries Full Check
date_scraped
2011-04-02T17:18:24.746018
station_val
5 minutes (minimum)
station_code
WLY
id
119
station_var
Connection time
Exits Reduced
Station Name
Check Reason
Exits Full
Check Detail
NUTS2 Spatial Unit Code
Entries Reduced
District or Unitary Authority
London Travelcard Area
Station Facility Owner
NLC
0910 interchanges
Government Office Region GOR
Station Group
NUTS2 Spatial Unit
Entries Total
0910 Entries and Exits
TLC
Entries Season
London Joint Station
PTE Urban Area Station
Exits Total
County or Unitary Authority
Exits Season
0809 Entries and Exits
Entries Full
Check
date_scraped
2011-04-02T17:18:24.762346
station_val
YesStation Car Park - 5 spacesMonday-Friday 24 hoursSaturday 24 hoursSunday 24 hoursNorthern Rail (Operator)
station_code
WLY
id
120
station_var
Car park
Exits Reduced
Station Name
Check Reason
Exits Full
Check Detail
NUTS2 Spatial Unit Code
Entries Reduced
District or Unitary Authority
London Travelcard Area
Station Facility Owner
NLC
0910 interchanges
Government Office Region GOR
Station Group
NUTS2 Spatial Unit
Entries Total
0910 Entries and Exits
TLC
Entries Season
London Joint Station
PTE Urban Area Station
Exits Total
County or Unitary Authority
Exits Season
0809 Entries and Exits
Entries Full
Check
date_scraped
2011-04-02T17:18:24.768319
station_val
Nowww.traintaxi..co.uk
station_code
WLY
id
121
station_var
Taxi Rank
Exits Reduced
Station Name
Check Reason
Exits Full
Check Detail
NUTS2 Spatial Unit Code
Entries Reduced
District or Unitary Authority
London Travelcard Area
Station Facility Owner
NLC
0910 interchanges
Government Office Region GOR
Station Group
NUTS2 Spatial Unit
Entries Total
0910 Entries and Exits
TLC
Entries Season
London Joint Station
PTE Urban Area Station
Exits Total
County or Unitary Authority
Exits Season
0809 Entries and Exits
Entries Full
Check
date_scraped
2011-04-02T17:18:24.774916
station_val
YesLocated on Stockport Road for buses to Manchester, Hyde, Marple, Romiley and Stockport. Maximum distance 1000 yards/914m. Busline 0871 200 2233
station_code
WLY
id
122
station_var
Bus services
Exits Reduced
Station Name
Check Reason
Exits Full
Check Detail
NUTS2 Spatial Unit Code
Entries Reduced
District or Unitary Authority
London Travelcard Area
Station Facility Owner
NLC
0910 interchanges
Government Office Region GOR
Station Group
NUTS2 Spatial Unit
Entries Total
0910 Entries and Exits
TLC
Entries Season
London Joint Station
PTE Urban Area Station
Exits Total
County or Unitary Authority
Exits Season
0809 Entries and Exits
Entries Full
Check
date_scraped
2011-04-02T17:18:24.783225
station_val
Plan your journey to and from the station withTraveline
station_code
WLY
id
123
station_var
Onward travel
Exits Reduced
Station Name
Check Reason
Exits Full
Check Detail
NUTS2 Spatial Unit Code
Entries Reduced
District or Unitary Authority
London Travelcard Area
Station Facility Owner
NLC
0910 interchanges
Government Office Region GOR
Station Group
NUTS2 Spatial Unit
Entries Total
0910 Entries and Exits
TLC
Entries Season
London Joint Station
PTE Urban Area Station
Exits Total
County or Unitary Authority
Exits Season
0809 Entries and Exits
Entries Full
Check
date_scraped
2011-04-02T17:18:24.791872
station_val
Monday-Sunday ClosedMonday-Friday ClosedSaturday ClosedSunday Closed
station_code
WLY
id
124
station_var
Ticket office opening
Exits Reduced
Station Name
Check Reason
Exits Full
Check Detail
NUTS2 Spatial Unit Code
Entries Reduced
District or Unitary Authority
London Travelcard Area
Station Facility Owner
NLC
0910 interchanges
Government Office Region GOR
Station Group
NUTS2 Spatial Unit
Entries Total
0910 Entries and Exits
TLC
Entries Season
London Joint Station
PTE Urban Area Station
Exits Total
County or Unitary Authority
Exits Season
0809 Entries and Exits
Entries Full
Check
date_scraped
2011-04-02T17:18:24.801474
station_val
No
station_code
WLY
id
125
station_var
Self-service machines
Exits Reduced
Station Name
Check Reason
Exits Full
Check Detail
NUTS2 Spatial Unit Code
Entries Reduced
District or Unitary Authority
London Travelcard Area
Station Facility Owner
NLC
0910 interchanges
Government Office Region GOR
Station Group
NUTS2 Spatial Unit
Entries Total
0910 Entries and Exits
TLC
Entries Season
London Joint Station
PTE Urban Area Station
Exits Total
County or Unitary Authority
Exits Season
0809 Entries and Exits
Entries Full
Check
date_scraped
2011-04-02T17:18:24.810020
station_val
No
station_code
WLY
id
126
station_var
Oyster PAYG Issued
Exits Reduced
Station Name
Check Reason
Exits Full
Check Detail
NUTS2 Spatial Unit Code
Entries Reduced
District or Unitary Authority
London Travelcard Area
Station Facility Owner
NLC
0910 interchanges
Government Office Region GOR
Station Group
NUTS2 Spatial Unit
Entries Total
0910 Entries and Exits
TLC
Entries Season
London Joint Station
PTE Urban Area Station
Exits Total
County or Unitary Authority
Exits Season
0809 Entries and Exits
Entries Full
Check
date_scraped
2011-04-02T17:18:24.819038
station_val
No
station_code
WLY
id
127
station_var
Oyster PAYG top up
Exits Reduced
Station Name
Check Reason
Exits Full
Check Detail
NUTS2 Spatial Unit Code
Entries Reduced
District or Unitary Authority
London Travelcard Area
Station Facility Owner
NLC
0910 interchanges
Government Office Region GOR
Station Group
NUTS2 Spatial Unit
Entries Total
0910 Entries and Exits
TLC
Entries Season
London Joint Station
PTE Urban Area Station
Exits Total
County or Unitary Authority
Exits Season
0809 Entries and Exits
Entries Full
Check
date_scraped
2011-04-02T17:18:24.829286
station_val
No
station_code
WLY
id
128
station_var
Oyster PAYG validators
Exits Reduced
Station Name
Check Reason
Exits Full
Check Detail
NUTS2 Spatial Unit Code
Entries Reduced
District or Unitary Authority
London Travelcard Area
Station Facility Owner
NLC
0910 interchanges
Government Office Region GOR
Station Group
NUTS2 Spatial Unit
Entries Total
0910 Entries and Exits
TLC
Entries Season
London Joint Station
PTE Urban Area Station
Exits Total
County or Unitary Authority
Exits Season
0809 Entries and Exits
Entries Full
Check

Statistics

Total run time: less than 5 seconds

Total cpu time used: less than 5 seconds

Total disk space used: 558 KB

History

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

Scraper code

mjk1