home / nhsadmin

Current and historical records of membership of CCGs, Primary Care Trusts, Primary Care Groups by General Medical Practice

Data source: OUseful Databeat

45,684 rows sorted by Join Parent Date

View and edit SQL

This data as .json

Suggested facets: Amended Record Indicator

Link rowid Organisation Code Parent Organisation Code Parent Organisation Type Join Parent Date ▼ Left Parent Date Amended Record Indicator
1 A81001 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
4 A81002 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
7 A81003 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
10 A81004 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
13 A81005 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
17 A81006 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
20 A81007 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
23 A81008 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
27 A81009 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
30 A81010 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
32 A81011 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
35 A81012 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
38 A81013 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
42 A81014 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
45 A81015 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
49 A81016 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
52 A81017 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
55 A81018 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
59 A81019 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
62 A81020 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
65 A81021 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
69 A81022 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
73 A81023 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
76 A81025 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
79 A81026 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
82 A81027 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
85 A81029 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
88 A81030 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
91 A81031 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
94 A81032 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
98 A81033 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
101 A81034 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
104 A81035 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
107 A81036 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
110 A81037 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
113 A81038 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
116 A81039 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
119 A81040 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
122 A81041 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
125 A81042 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
129 A81043 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
133 A81044 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
136 A81045 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
140 A81046 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
143 A81047 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
147 A81048 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
151 A81049 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
154 A81051 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
157 A81052 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
161 A81053 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
165 A81054 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
169 A81055 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
172 A81056 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
175 A81057 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
178 A81058 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
181 A81060 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
184 A81061 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
186 A81063 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
189 A81064 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
192 A81065 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
196 A81066 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
199 A81067 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
202 A81068 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
204 A81069 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
208 A81070 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
213 A81602 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
216 A81605 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 1
220 A81606 4QP36 W 1999-04-01 00:00:00 2000-02-29 00:00:00 0
221 A81608 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
224 A81609 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
227 A81610 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
230 A81611 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
233 A81612 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
236 A81613 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
239 A81618 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
243 A81620 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
245 A81621 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
248 A81622 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
251 A81623 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
254 A81625 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
256 A81627 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
258 A81629 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
272 A82001 4KC44 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
275 A82003 4DQ30 W 1999-04-01 00:00:00 2001-03-31 00:00:00 1
280 A82004 4JY13 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
284 A82005 4DQ30 W 1999-04-01 00:00:00 2001-03-31 00:00:00 1
289 A82006 4JY13 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
293 A82007 4KC44 W 1999-04-01 00:00:00 2001-03-31 00:00:00 1
298 A82008 4KC44 W 1999-04-01 00:00:00 2001-03-31 00:00:00 1
303 A82009 4KC44 W 1999-04-01 00:00:00 2001-03-31 00:00:00 1
308 A82010 4KC44 W 1999-04-01 00:00:00 2001-03-31 00:00:00 1
313 A82011 4KC44 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
317 A82012 4JY13 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
321 A82013 4JY13 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
325 A82014 4NA24 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
329 A82015 4NA24 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
333 A82016 4NA24 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
337 A82017 4NA24 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
341 A82018 4NA24 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
345 A82019 4NA24 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0

Next page

CREATE TABLE "epcmem" (
"Organisation Code" TEXT,
  "Parent Organisation Code" TEXT,
  "Parent Organisation Type" TEXT,
  "Join Parent Date" TIMESTAMP,
  "Left Parent Date" TIMESTAMP,
  "Amended Record Indicator" INTEGER
)
Powered by Datasette · Query took 143.644ms · Data source: OUseful Databeat