cim_substations

6,070 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source, licence, type

Link rowid ▼ substation_id substation_name source licence type location
1 1 786c1d45-3680-410e-85f3-988f7d864cc0 portland sse southern primary portland
2 2 ffa61348-2e44-4452-a1ef-05a8234c4821 eynsham sse southern primary eynsham
3 3 928ddae1-b895-4d8b-af65-7fa9b01fc7c5 west hendford sse southern primary west hendford
4 4 d20cefa7-2e9e-4c3c-a43a-3efc824d080c salisbury sse southern bsp salisbury
5 5 78c8d680-7c8b-4c79-ad5d-9f637f408cdf axminster sse southern gsp axminster
6 6 c3bbaaa3-2a91-438d-9c79-8b598757aa44 romsey sse southern primary romsey
7 7 b60383a5-adf4-4bd1-99c8-71563962a3b9 mayr sse southern primary mayr
8 8 5e6f3de0-1f11-414d-9edb-23e09322e507 west grafton village sse southern primary west grafton village
9 9 53342728-d162-47a6-8e3e-7c77af7369f1 fawley sse southern gsp fawley
10 10 b6381347-e043-4738-b4c2-b43cae8dd090 whiteley sse southern primary whiteley
11 11 92e8a8f3-4d57-4574-bfb7-8331baf09fcc trowbridge sse southern 0 trowbridge
12 12 53361c29-1d7f-4b56-9a57-1a8d568c7161 middle wallop sse southern primary middle wallop
13 13 c3f6ff32-1346-4157-abc1-d306e2e2dfc2 woodmill lane sse southern primary woodmill lane
14 14 cdf4988d-bae7-4e8a-bc92-e6e259beba5b rissington sse southern primary rissington
15 15 b21680dc-f04a-4538-a7ca-caff66fd7987 easterton sse southern primary easterton
16 16 79832e8a-5e65-494f-84ea-2cd6b9585e0d bemerton sse southern primary bemerton
17 17 797619f6-41e4-453f-ad44-55342873798f whiteley wood sse southern primary whiteley wood
18 18 c42c1369-cb6a-4a44-8bda-799d240351df fawley south sse southern primary fawley south
19 19 a88b48e1-4a24-4693-8b85-58440eee4260 little marlow sse southern primary little marlow
20 20 c456e7f4-6996-449f-9611-996ac17de71d camberley sse southern primary camberley
21 21 9355751c-2d00-45bc-8378-947d130e3986 swindon sse southern primary swindon wind
22 22 b26c031a-4b76-48b3-b1f9-c546607833d4 heathrow north (hean-c) sse southern bsp heathrow north hean c
23 23 5f983869-f501-4394-885a-437dd06d9b72 hawkeridge sse southern primary hawkeridge
24 24 5483da3c-2121-4629-92d8-dcf218957bc8 sunninghill sse southern primary sunninghill
25 25 a4bebf04-02f3-4071-986d-617d1d63f2cd petersfield avenue sse southern primary petersfield avenue
26 26 cebce61e-9c2f-412c-9ae5-1f43f3f29e8e jays close sse southern primary jays close
27 27 5f824d45-9c7a-4ea9-bd90-c930d1b1ebc1 crookham (church) sse southern primary crookham church
28 28 5fd9ebe0-218a-4e51-ab5a-f24eabbe5187 arborfield sse southern primary arborfield
29 29 a4ff327a-f51c-441a-9dba-b2c373cf2063 lechlade sse southern primary lechlade
30 30 5fe350cd-4c34-4eed-869e-a97da40147ee farnborough sse southern primary farnborough
31 31 552c7993-487b-4e3d-9522-28bb29b96794 easthampstead sse southern primary easthampstead
32 32 b32e1a9b-ab34-4187-b24b-22fcff6d5976 plaistow sse southern primary plaistow
33 33 7ad7d5b5-8032-4984-9ca3-7ea6da9e6d79 wilson road sse southern primary wilson road
34 34 609f116c-fb62-4385-bfb5-f2c0de1e62d3 mannington sse southern gsp mannington
35 35 60746358-98aa-418c-b43a-0157a072a54f plessey swindon sse southern primary plessey swindon wind
36 36 b376f8bf-8fce-4a70-86dd-48a9c44c0f51 langley sse southern primary langley
37 37 94911642-9e5d-446c-9014-5598a9b8a59c sutton lane sse southern primary sutton lane
38 38 60c3f25d-3b2c-477e-a640-3fe8de9dc5fc marlborough south sse southern primary marlborough south
39 39 8415c7e3-e453-4292-9217-6b97261c8edd chisledon sse southern primary chisledon
40 40 7b537a61-d9a9-4e05-b714-9343f5598fbe high wycombe sse southern primary high wycombe
41 41 7b801857-aefe-4d46-9ed5-eeb43fa32eb3 goldsmiths sse southern primary goldsmiths
42 42 611370e6-fccb-4766-9fc0-3eecdbaa744a chipping norton sse southern primary chipping norton
43 43 7be967a0-23e2-46d1-9da9-57fef149b113 kingsbook sse southern primary kingsbook
44 44 55bec2ac-8399-4c3d-bdb7-e0f3a8c76be7 lakedale road sse southern primary lakedale road
45 45 b4115a06-eae0-477a-a9f5-e15ef855e984 springfield road sse southern primary springfield road
46 46 613e65e3-9db8-4a98-847f-72e7aa204bb4 poyle sse southern primary poyle
47 47 563dda06-01e2-4942-a224-94e39669aff0 university parks sse southern primary university parks
48 48 a5eaa6d0-f9fe-40d0-91ae-53ef94bec1dd new street ringwood sse southern primary new street ringwood
49 49 84ab7f86-c3ff-45ff-b0ad-4b227a8d67b0 love lane sse southern primary love lane
50 50 84972333-a041-4fe1-84fb-5c6d1a529632 chickerell sse southern gsp chickerell
51 51 5634cfbb-e699-4ab6-906e-42b8ba156234 fwid sse southern bsp fwid
52 52 a62338b3-6b4e-45bd-bab7-1f6e7999d4f8 farnborough airfield sse southern primary farnborough airfield
53 53 956759b2-aa26-42e6-b61f-054c8121d70c st johns sse southern primary johns
54 54 95bf6770-2ed0-468c-a344-b2e51dccc9cd sungard sse southern primary sungard
55 55 b4fc5a4d-5397-4805-8581-19c20b187aa6 andover sse southern primary andover
56 56 a6a9de79-b859-465a-90c5-f5ee8b06c7d5 ratfyn sse southern primary ratfyn
57 57 62387a90-bee3-4466-b6d2-d4a1be8c242e chichester sse southern primary chichester
58 58 d082f148-af0e-4fb0-8b9f-921e9a1ae05d north fareham sse southern primary north fareham
59 59 6237c864-cddc-483a-9f7b-6c0ba85a2343 harwell sse southern primary harwell
60 60 46493fe5-3869-4971-a94d-a36e37690333 tham sse southern primary tham
61 61 b5096505-c455-4be7-babc-76a59fc24beb stratton sse southern primary stratton
62 62 6244b76f-d304-43d3-bca4-162c0b9929d6 winterbourne kingston sse southern primary winterbourne kingston
63 63 462e4ff2-0eb5-4cac-92c2-59afe09e7239 drakes way sse southern primary drakes way
64 64 56ee9f59-c2f3-44d5-bd35-0fd30a5e588f basingstoke sse southern primary basingstoke
65 65 56ddd748-94c0-47b6-9586-ad4d1168701c alresford sse southern primary alresford
66 66 a706cbd8-69e3-4d1a-aea2-89b3c6a9ed74 knowl hill sse southern primary knowl hill
67 67 56df72aa-7b4b-4766-baec-8808ca0b966e kidmore end sse southern primary kidmore end
68 68 7d3f9eb3-45d3-4b16-b70d-4739686c6af0 petersfinger sse southern primary petersfinger
69 69 8870e290-7838-48dd-8df0-92b1bf4d0d4d langley court sse southern primary langley court
70 70 7d702817-c573-43f8-b7da-281ebeecc528 codford sse southern primary codford
71 71 573c35c5-af35-41ef-953e-830fb15a3551 boscombe down sse southern primary boscombe down
72 72 88f6e271-8caa-4bf7-b249-5b6f5ec18596 enford sse southern primary enford
73 73 88edb7e2-e3fd-47ad-97cf-01112563a2ac egham sse southern primary egham
74 74 85a99d51-9b4a-4c50-af4b-1f8f36fca73d shanklin sse southern primary shanklin
75 75 86259977-d757-449f-9b67-83e6a70ceee0 repv sse southern primary repv pv
76 76 a7946883-0faa-43e3-863d-10a366589e2d cowley local sse southern primary cowley
77 77 a78a7bbb-eb2c-440c-9680-3b087ba24974 pulham sse southern primary pulham
78 78 8647297b-9ccd-4346-88b2-faca4a4f60d8 fulscot sse southern primary fulscot
79 79 d182e1f1-063b-4a70-818d-844d9b7a4462 union street sse southern primary union street
80 80 d14a0e40-dfab-4820-afc0-b54df82ec5b9 denham sse southern primary denham
81 81 d18bbbe4-5994-4be0-b514-41f75533d496 northleach sse southern primary northleach
82 82 57c024cd-0577-4154-ae0b-e9a71ae3d419 reading town sse southern primary reading town
83 83 7e0f4737-b6dc-4cc8-b1fb-1d44d61d4227 padworth sse southern primary padworth
84 84 8675c28f-1cf0-43f8-9acd-ab765bba42a3 hillingdon sse southern primary hillingdon
85 85 57d0c82d-22e9-4e60-9aa6-0a03e2f44d61 laburnam road sse southern primary laburnam road
86 86 8964845b-748b-459f-aae1-1cf30c7f4b79 lynes common sse southern primary lynes common
87 87 7e3ef840-ca69-431f-851a-84c649f62c54 cerne abbas sse southern primary cerne abbas
88 88 a8438116-1bcf-465d-adc5-246c33d4866a regents park sse southern primary regents park
89 89 7e5d7399-960d-45c4-b679-cc20115ec25d flee-brle sse southern gsp flee brle
90 90 a83b291b-f674-4e6b-8024-6242509eeb5c mel marchwood sse southern primary mel marchwood
91 91 8734918c-c80f-4728-b0a4-94c7ef20998e southfield road sse southern primary southfield road
92 92 e52884c4-60af-47b6-8a2e-4ec02c8bf4cd iver 66kv sse southern gsp iver
93 93 e50f5e28-10fd-4a7a-85ad-32333f3048fc down grange sse southern primary down grange
94 94 a8690816-89e8-4318-bcd6-578329680a2b east howe sse southern primary east howe
95 95 8a36683f-993a-4acf-961a-74f88f9d713b toothill sse southern primary toothill
96 96 e536f9cc-c8e7-4e94-b557-76fbebd830ff chalvey sse southern primary chalvey
97 97 8a6aab05-a571-4339-83ef-7d85e6ce6cd8 grassingham road sse southern primary grassingham road
98 98 4842234a-7f21-4137-9385-d9b35a15a233 manchester road sse southern primary manchester road
99 99 4837cdac-4604-4ae1-9a50-76f636d1d0eb hedge end sse southern primary hedge end
100 100 486c47ac-5e7e-450c-98a6-3db07bee6632 haslingbourne sse southern primary haslingbourne

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "cim_substations" (
"substation_id" TEXT,
  "substation_name" TEXT,
  "source" TEXT,
  "licence" TEXT,
  "type" TEXT,
  "location" TEXT
);