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 Left 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
3 A81001 00K W 2013-04-01 00:00:00   0
6 A81002 00K W 2013-04-01 00:00:00   0
9 A81003 00K W 2013-04-01 00:00:00   0
12 A81004 00M W 2013-04-01 00:00:00   0
16 A81005 00M W 2013-04-01 00:00:00   0
19 A81006 00K W 2013-04-01 00:00:00   0
22 A81007 00K W 2013-04-01 00:00:00   0
26 A81008 00M W 2013-04-01 00:00:00   0
29 A81009 00M W 2013-04-01 00:00:00   0
34 A81011 00K W 2013-04-01 00:00:00   0
37 A81012 00M W 2013-04-01 00:00:00   0
41 A81013 00M W 2013-04-01 00:00:00   0
44 A81014 00K W 2013-04-01 00:00:00   0
48 A81015 00M W 2013-04-01 00:00:00   0
51 A81016 00M W 2013-04-01 00:00:00   0
54 A81017 00K W 2013-04-01 00:00:00   0
58 A81018 00M W 2013-04-01 00:00:00   0
61 A81019 00M W 2013-04-01 00:00:00   0
64 A81020 00M W 2013-04-01 00:00:00   0
68 A81021 00M W 2013-04-01 00:00:00   0
72 A81022 00M W 2013-04-01 00:00:00   0
75 A81023 00M W 2013-04-01 00:00:00   0
78 A81025 00K W 2013-04-01 00:00:00   0
81 A81026 00M W 2013-04-01 00:00:00   0
84 A81027 00K W 2013-04-01 00:00:00   0
87 A81029 00M W 2013-04-01 00:00:00   0
90 A81030 00M W 2013-04-01 00:00:00   0
93 A81031 00K W 2013-04-01 00:00:00   0
97 A81032 00M W 2013-04-01 00:00:00   0
100 A81033 00M W 2013-04-01 00:00:00   0
103 A81034 00K W 2013-04-01 00:00:00   0
106 A81035 00M W 2013-04-01 00:00:00   0
109 A81036 00K W 2013-04-01 00:00:00   0
112 A81037 00M W 2013-04-01 00:00:00   0
115 A81038 00M W 2013-04-01 00:00:00   0
118 A81039 00K W 2013-04-01 00:00:00   0
121 A81040 00K W 2013-04-01 00:00:00   0
124 A81041 00K W 2013-04-01 00:00:00   0
128 A81042 00M W 2013-04-01 00:00:00   0
132 A81043 00M W 2013-04-01 00:00:00   0
135 A81044 00K W 2013-04-01 00:00:00   0
139 A81045 00M W 2013-04-01 00:00:00   0
142 A81046 00K W 2013-04-01 00:00:00   0
146 A81047 00M W 2013-04-01 00:00:00   0
150 A81048 00M W 2013-04-01 00:00:00   0
153 A81049 00M W 2013-04-01 00:00:00   0
156 A81051 00M W 2013-04-01 00:00:00   0
160 A81052 00M W 2013-04-01 00:00:00   0
164 A81053 00M W 2013-04-01 00:00:00   0
168 A81054 00M W 2013-04-01 00:00:00   0
174 A81056 00K W 2013-04-01 00:00:00   0
177 A81057 00K W 2013-04-01 00:00:00   0
180 A81058 00M W 2013-04-01 00:00:00   0
183 A81060 00K W 2013-04-01 00:00:00   0
188 A81063 00K W 2013-04-01 00:00:00   0
191 A81064 00M W 2013-04-01 00:00:00   0
195 A81065 00M W 2013-04-01 00:00:00   0
198 A81066 00K W 2013-04-01 00:00:00   0
201 A81067 00K W 2013-04-01 00:00:00   0
210 A81070 00K W 2013-04-01 00:00:00   0
215 A81602 00K W 2013-04-01 00:00:00   0
223 A81608 00K W 2013-04-01 00:00:00   0
226 A81609 00K W 2013-04-01 00:00:00   0
229 A81610 00K W 2013-04-01 00:00:00   0
232 A81611 00M W 2013-04-01 00:00:00   0
235 A81612 00K W 2013-04-01 00:00:00   0
238 A81613 00K W 2013-04-01 00:00:00   0
242 A81618 00M W 2013-04-01 00:00:00   0
247 A81621 00M W 2013-04-01 00:00:00   0
250 A81622 00K W 2013-04-01 00:00:00   0
253 A81623 00K W 2013-04-01 00:00:00   0
260 A81629 00K W 2013-04-01 00:00:00   0
263 A81630 00M W 2013-04-01 00:00:00   0
265 A81631 00K W 2013-04-01 00:00:00   0
267 A81632 00K W 2013-04-01 00:00:00   0
269 A81633 00M W 2013-04-01 00:00:00   0
271 A81634 00K W 2013-04-01 00:00:00   0
279 A82003 01K W 2017-04-01 00:00:00   1
283 A82004 01H W 2013-04-01 00:00:00   0
288 A82005 01K W 2017-04-01 00:00:00   1
292 A82006 01H W 2013-04-01 00:00:00   0
297 A82007 01K W 2017-04-01 00:00:00   1
302 A82008 01K W 2017-04-01 00:00:00   1
307 A82009 01K W 2017-04-01 00:00:00   1
312 A82010 01K W 2017-04-01 00:00:00   1
320 A82012 01H W 2013-04-01 00:00:00   0
324 A82013 01H W 2013-04-01 00:00:00   0
328 A82014 01H W 2013-04-01 00:00:00   0
332 A82015 01H W 2013-04-01 00:00:00   0
336 A82016 01H W 2013-04-01 00:00:00   0
340 A82017 01H W 2013-04-01 00:00:00   0
344 A82018 01H W 2013-04-01 00:00:00   0
348 A82019 01H W 2013-04-01 00:00:00   0
352 A82020 01H W 2013-04-01 00:00:00   0
356 A82021 01H W 2013-04-01 00:00:00   0
360 A82022 01H W 2013-04-01 00:00:00   0
364 A82023 01H W 2013-04-01 00:00:00   0
368 A82024 01H W 2013-04-01 00:00:00   0
373 A82025 01K W 2017-04-01 00:00:00   1
378 A82026 01K W 2017-04-01 00:00:00   1

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 120.245ms · Data source: OUseful Databeat