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

View and edit SQL

This data as .json

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
2 A81001 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
3 A81001 00K W 2013-04-01 00:00:00   0
4 A81002 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
5 A81002 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
6 A81002 00K W 2013-04-01 00:00:00   0
7 A81003 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
8 A81003 5D9 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
9 A81003 00K W 2013-04-01 00:00:00   0
10 A81004 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
11 A81004 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
12 A81004 00M W 2013-04-01 00:00:00   0
13 A81005 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
14 A81005 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
15 A81005 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
16 A81005 00M W 2013-04-01 00:00:00   0
17 A81006 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
18 A81006 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
19 A81006 00K W 2013-04-01 00:00:00   0
20 A81007 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
21 A81007 5D9 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
22 A81007 00K W 2013-04-01 00:00:00   0
23 A81008 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
24 A81008 5KM W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
25 A81008 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
26 A81008 00M W 2013-04-01 00:00:00   0
27 A81009 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
28 A81009 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
29 A81009 00M W 2013-04-01 00:00:00   0
30 A81010 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
31 A81010 5D9 W 2001-04-01 00:00:00 2012-09-30 00:00:00 0
32 A81011 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
33 A81011 5D9 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
34 A81011 00K W 2013-04-01 00:00:00   0
35 A81012 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
36 A81012 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
37 A81012 00M W 2013-04-01 00:00:00   0
38 A81013 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
39 A81013 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
40 A81013 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
41 A81013 00M W 2013-04-01 00:00:00   0
42 A81014 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
43 A81014 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
44 A81014 00K W 2013-04-01 00:00:00   0
45 A81015 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
46 A81015 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
47 A81015 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
48 A81015 00M W 2013-04-01 00:00:00   0
49 A81016 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
50 A81016 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
51 A81016 00M W 2013-04-01 00:00:00   0
52 A81017 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
53 A81017 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
54 A81017 00K W 2013-04-01 00:00:00   0
55 A81018 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
56 A81018 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
57 A81018 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
58 A81018 00M W 2013-04-01 00:00:00   0
59 A81019 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
60 A81019 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
61 A81019 00M W 2013-04-01 00:00:00   0
62 A81020 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
63 A81020 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
64 A81020 00M W 2013-04-01 00:00:00   0
65 A81021 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
66 A81021 5KM W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
67 A81021 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
68 A81021 00M W 2013-04-01 00:00:00   0
69 A81022 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
70 A81022 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
71 A81022 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
72 A81022 00M W 2013-04-01 00:00:00   0
73 A81023 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
74 A81023 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
75 A81023 00M W 2013-04-01 00:00:00   0
76 A81025 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
77 A81025 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
78 A81025 00K W 2013-04-01 00:00:00   0
79 A81026 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
80 A81026 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
81 A81026 00M W 2013-04-01 00:00:00   0
82 A81027 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
83 A81027 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
84 A81027 00K W 2013-04-01 00:00:00   0
85 A81029 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
86 A81029 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
87 A81029 00M W 2013-04-01 00:00:00   0
88 A81030 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
89 A81030 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
90 A81030 00M W 2013-04-01 00:00:00   0
91 A81031 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
92 A81031 5D9 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
93 A81031 00K W 2013-04-01 00:00:00   0
94 A81032 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
95 A81032 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
96 A81032 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
97 A81032 00M W 2013-04-01 00:00:00   0
98 A81033 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
99 A81033 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
100 A81033 00M W 2013-04-01 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 153.333ms · Data source: OUseful Databeat