spen_distribution_substations

1,198 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: date_published, licence, type

Link rowid ▼ name date_published source licence retain_edits latitude longitude type location substation_id
1 1 ayr 17/06/2024 spen scottish 0 55.457328257927834 -4.588381212429046 bsp ayr spen_scottish_bsp_ayr
2 2 wem 30/05/2024 spen southern 0 52.85742736419944 -2.7384256901316206 primary wem spen_southern_primary_wem
3 3 ykk 30/05/2024 spen southern 0 53.31064166170123 -2.6575678790742194 primary ykk spen_southern_primary_ykk
4 4 rtz 30/05/2024 spen southern 0 53.36109957706429 -2.7744514702450234 primary rtz spen_southern_primary_rtz
5 5 ince 30/05/2024 spen southern 0 53.27706643543043 -2.81309528275764 bsp ince spen_southern_bsp_ince
6 6 duns 17/06/2024 spen scottish 0 55.776947148605814 -2.3316810871668388 primary duns spen_scottish_primary_duns
7 7 mbna 30/05/2024 spen southern 0 53.15989872062274 -2.894922119993866 primary mbna spen_southern_primary_mbna
8 8 usac 30/05/2024 spen southern 0 53.36710545354615 -2.7115086291429784 primary usac spen_southern_primary_usac
9 9 mere 30/05/2024 spen southern 0 53.329256141483185 -2.4089117064380887 primary mere spen_southern_primary_mere
10 10 mona 30/05/2024 spen southern 0 53.25098566366285 -4.371946112898453 primary mona spen_southern_primary_mona
11 11 over 30/05/2024 spen southern 0 53.19128221238841 -2.53735067573302 primary over spen_southern_primary_over
12 12 bala 30/05/2024 spen southern 0 52.92020337239161 -3.586523905413076 primary bala spen_southern_primary_bala
13 13 irby 30/05/2024 spen southern 0 53.35224026648969 -3.1173104356222527 primary irby spen_southern_primary_irby
14 14 bold 30/05/2024 spen southern 0 53.43386042863474 -2.6938193619510167 bsp bold spen_southern_bsp_bold
15 15 ince 30/05/2024 spen southern 0 53.27767078648215 -2.811562798672341 gsp ince spen_southern_gsp_ince
16 16 llay 30/05/2024 spen southern 0 53.10004941124803 -3.0065297515710867 primary llay spen_southern_primary_llay
17 17 lymm 30/05/2024 spen southern 0 53.38033765119692 -2.4925878958515164 primary lymm spen_southern_primary_lymm
18 18 rhyl 30/05/2024 spen southern 0 53.30971678286146 -3.484944737489202 bsp rhyl spen_southern_bsp_rhyl
19 19 ford 30/05/2024 spen southern 0 53.386161033198135 -3.0847463320503308 primary ford spen_southern_primary_ford
20 20 annan 17/06/2024 spen scottish 0 54.9942149448268 -3.2528154187781526 primary annan spen_scottish_primary_annan
21 21 troon 17/06/2024 spen scottish 0 55.547757982742425 -4.647330516936993 primary troon spen_scottish_primary_troon
22 22 tywyn 30/05/2024 spen southern 0 52.58756399266039 -4.080256444893464 primary tywyn spen_southern_primary_tywyn
23 23 edern 30/05/2024 spen southern 0 52.920672666280005 -4.560214066427661 primary edern spen_southern_primary_edern
24 24 leven 17/06/2024 spen scottish 0 56.19766268951904 -3.0386875834450717 primary leven spen_scottish_primary_leven
25 25 prees 30/05/2024 spen southern 0 52.89746656084515 -2.6738885948236226 primary prees spen_southern_primary_prees
26 26 leven 17/06/2024 spen scottish 0 56.19863271273714 -3.0395633522750014 bsp leven spen_scottish_bsp_leven
27 27 speke 30/05/2024 spen southern 0 53.35305319970272 -2.848639021709814 bsp speke spen_southern_bsp_speke
28 28 kelco 30/05/2024 spen southern 0 53.46468110063253 -2.859040673019658 primary kelco spen_southern_primary_kelco
29 29 govan 17/06/2024 spen scottish 0 55.85467516971533 -4.315442011902493 bsp govan spen_scottish_bsp_govan
30 30 kodak 30/05/2024 spen southern 0 53.48433921300886 -2.8489862849242846 primary kodak spen_southern_primary_kodak
31 31 caldy 30/05/2024 spen southern 0 53.357864993900456 -3.1631556427290692 primary caldy spen_southern_primary_caldy
32 32 tulip 30/05/2024 spen southern 0 53.335967336324565 -2.9624348496105575 primary tulip spen_southern_primary_tulip
33 33 acton 30/05/2024 spen southern 0 53.07692847968798 -2.5525271103629295 primary acton spen_southern_primary_acton
34 34 wylfa 30/05/2024 spen southern 0 53.41361433715462 -4.482176196212917 gsp wylfa spen_southern_gsp_wylfa
35 35 lache 30/05/2024 spen southern 0 53.16927193792324 -2.9251137128370566 primary lache spen_southern_primary_lache
36 36 cupar 17/06/2024 spen scottish 0 56.31397046938332 -3.036182604237234 bsp cupar spen_scottish_bsp_cupar
37 37 conwy 30/05/2024 spen southern 0 53.28383335910783 -3.8383836038741226 primary conwy spen_southern_primary_conwy
38 38 forth 17/06/2024 spen scottish 0 55.76312701449095 -3.7049029441675194 primary forth spen_scottish_primary_forth
39 39 pandy 30/05/2024 spen southern 0 53.07369969679359 -2.9909753238914325 primary pandy spen_southern_primary_pandy
40 40 conix 30/05/2024 spen southern 0 53.35025102910953 -2.8417711830534587 primary conix spen_southern_primary_conix
41 41 ayton 17/06/2024 spen scottish 0 55.838344376061656 -2.12830969340173 primary ayton spen_scottish_primary_ayton
42 42 palco 30/05/2024 spen southern 0 53.46246851790726 -2.870989076653031 primary palco spen_southern_primary_palco
43 43 omega 30/05/2024 spen southern 0 53.40875459117517 -2.6450406752424476 primary omega spen_southern_primary_omega
44 44 crewe 30/05/2024 spen southern 0 53.10344833920535 -2.484795208423832 gsp crewe spen_southern_gsp_crewe
45 45 morda 30/05/2024 spen southern 0 52.847873783210346 -3.0546649613466 primary morda spen_southern_primary_morda
46 46 kelty 17/06/2024 spen scottish 0 56.13795306108347 -3.3621142641911854 primary kelty spen_scottish_primary_kelty
47 47 raith 17/06/2024 spen scottish 0 56.1034354314203 -3.160891804429212 primary raith spen_scottish_primary_raith
48 48 moore 30/05/2024 spen southern 0 53.344065890511445 -2.6655980007371176 bsp moore spen_southern_bsp_moore
49 49 cupar 17/06/2024 spen scottish 0 56.31395917152902 -3.034899752218677 primary cupar spen_scottish_primary_cupar
50 50 crewe 30/05/2024 spen southern 0 53.10344833920535 -2.484795208423832 bsp crewe spen_southern_bsp_crewe
51 51 upton 30/05/2024 spen southern 0 53.38447641600384 -3.0985992668839186 primary upton spen_southern_primary_upton
52 52 deans 17/06/2024 spen scottish 0 55.90337993344813 -3.5719610036867184 primary deans spen_scottish_primary_deans
53 53 b r d 30/05/2024 spen southern 0 52.51673221607967 -3.2981169585817525 primary b r d spen_southern_primary_brd
54 54 largs 17/06/2024 spen scottish 0 55.79878398267906 -4.8560499586042924 primary largs spen_scottish_primary_largs
55 55 flint 30/05/2024 spen southern 0 53.25224135180582 -3.142028941991487 primary flint spen_southern_primary_flint
56 56 oxton 30/05/2024 spen southern 0 53.38235749970853 -3.052941955914349 primary oxton spen_southern_primary_oxton
57 57 manod 30/05/2024 spen southern 0 52.968984328932066 -3.9303281328453306 primary manod spen_southern_primary_manod
58 58 elton 30/05/2024 spen southern 0 53.27304647686608 -2.812687257058121 primary elton spen_southern_primary_elton
59 59 meols 30/05/2024 spen southern 0 53.39882712942903 -3.1553751399520578 primary meols spen_southern_primary_meols
60 60 kaimes 17/06/2024 spen scottish 0 55.89186668065378 -3.1632915102558203 bsp kaimes spen_scottish_bsp_kaimes
61 61 alpoco 30/05/2024 spen southern 0 53.29411580506211 -4.596197938500489 primary alpoco spen_southern_primary_alpoco
62 62 forgan 17/06/2024 spen scottish 0 56.41220667958264 -2.9148164481238976 primary forgan spen_scottish_primary_forgan
63 63 biggar 17/06/2024 spen scottish 0 55.6220121980282 -3.524225442971981 primary biggar spen_scottish_primary_biggar
64 64 audlem 30/05/2024 spen southern 0 52.995926665325726 -2.488867305156926 primary audlem spen_southern_primary_audlem
65 65 dutton 30/05/2024 spen southern 0 53.311684547825095 -2.6647472021497123 bsp dutton spen_southern_bsp_dutton
66 66 sorbie 17/06/2024 spen scottish 0 54.781884082298156 -4.459736400562703 primary sorbie spen_scottish_primary_sorbie
67 67 orford 30/05/2024 spen southern 0 53.411151491716986 -2.573308853456878 primary orford spen_southern_primary_orford
68 68 duddon 30/05/2024 spen southern 0 53.18054566576525 -2.7233772932457345 primary duddon spen_southern_primary_duddon
69 69 shotts 17/06/2024 spen scottish 0 55.82162660062597 -3.7900130247631565 primary shotts spen_scottish_primary_shotts
70 70 ditton 30/05/2024 spen southern 0 53.37139937864823 -2.7564448192689426 primary ditton spen_southern_primary_ditton
71 71 dingle 30/05/2024 spen southern 0 53.38434811882617 -2.957751747030431 primary dingle spen_southern_primary_dingle
72 72 neston main 30/05/2024 spen southern 0 53.28757197974981 -3.0550842420851954 primary neston spen_southern_primary_neston
73 73 darvel 17/06/2024 spen scottish 0 55.61117728865924 -4.270260854104357 primary darvel spen_scottish_primary_darvel
74 74 amlwch 30/05/2024 spen southern 0 53.41088364940866 -4.336888561322224 bsp amlwch spen_southern_bsp_amlwch
75 75 granby 30/05/2024 spen southern 0 53.394984310763114 -2.9681809485261317 primary granby spen_southern_primary_granby
76 76 tarvin 30/05/2024 spen southern 0 53.19990825922652 -2.7618432740970578 primary tarvin spen_southern_primary_tarvin
77 77 kirkby 30/05/2024 spen southern 0 53.4693755190748 -2.849499248131633 gsp kirkby spen_southern_gsp_kirkby
78 78 fodens 30/05/2024 spen southern 0 53.145399273913625 -2.3912821358752248 primary fodens spen_southern_primary_fodens
79 79 pentir 30/05/2024 spen southern 0 53.186891345597644 -4.159556798511669 gsp pentir spen_southern_gsp_pentir
80 80 widnes 30/05/2024 spen southern 0 53.360618468455534 -2.739156686981453 bsp widnes spen_southern_bsp_widnes
81 81 rivals 30/05/2024 spen southern 0 52.9838474407591 -4.4089010181383115 primary rivals spen_southern_primary_rivals
82 82 castle 17/06/2024 spen scottish 0 55.776715370523604 -4.30634512255554 primary castle spen_scottish_primary_castle
83 83 carmel 30/05/2024 spen southern 0 53.075695500899585 -4.249547654408851 primary carmel spen_southern_primary_carmel
84 84 lanark 17/06/2024 spen scottish 0 55.6699682718226 -3.7588724124398505 primary lanark spen_scottish_primary_lanark
85 85 foxbar 17/06/2024 spen scottish 0 55.82638482260717 -4.460800462079585 primary foxbar spen_scottish_primary_foxbar
86 86 hunter 17/06/2024 spen scottish 0 55.77047229337794 -4.148718542274194 primary hunter spen_scottish_primary_hunter
87 87 bangor 30/05/2024 spen southern 0 53.20950661691218 -4.180753392778038 bsp bangor spen_southern_bsp_bangor
88 88 irvine 17/06/2024 spen scottish 0 55.60599340500473 -4.667003199149166 primary irvine spen_scottish_primary_irvine
89 89 currie 17/06/2024 spen scottish 0 55.90150443050044 -3.3084947778402767 bsp currie spen_scottish_bsp_currie
90 90 east mains 17/06/2024 spen scottish 0 55.93691615162071 -3.4502794038654807 primary east s spen_scottish_primary_easts
91 91 bewsey 30/05/2024 spen southern 0 53.39690749870157 -2.6135964784360275 primary bewsey spen_southern_primary_bewsey
92 92 legacy 30/05/2024 spen southern 0 53.02753899799306 -3.053390048478287 gsp legacy spen_southern_gsp_legacy
93 93 spital 30/05/2024 spen southern 0 53.34122612550317 -3.007039480926014 primary spital spen_southern_primary_spital
94 94 wervin 30/05/2024 spen southern 0 53.230533445939244 -2.8667777713026994 primary wervin spen_southern_primary_wervin
95 95 amlwch 30/05/2024 spen southern 0 53.410926797127125 -4.337666657334883 primary amlwch spen_southern_primary_amlwch
96 96 carfin 17/06/2024 spen scottish 0 55.80366733657182 -3.959508107870995 primary carfin spen_scottish_primary_carfin
97 97 lugton 17/06/2024 spen scottish 0 55.89621279940717 -3.0719636968829036 primary lugton spen_scottish_primary_lugton
98 98 airbus 30/05/2024 spen southern 0 53.171888071871344 -2.9722361445561303 primary airbus spen_southern_primary_airbus
99 99 huyton 30/05/2024 spen southern 0 53.423312380674524 -2.8604242807762144 bsp huyton spen_southern_bsp_huyton
100 100 bootle 30/05/2024 spen southern 0 53.45628909069473 -2.9857123060679074 primary bootle spen_southern_primary_bootle

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "spen_distribution_substations" (
"name" TEXT,
  "date_published" TEXT,
  "source" TEXT,
  "licence" TEXT,
  "retain_edits" INTEGER,
  "latitude" REAL,
  "longitude" REAL,
  "type" TEXT,
  "location" TEXT,
  "substation_id" TEXT
);