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

Suggested facets: Amended Record Indicator

Link rowid Organisation Code Parent Organisation Code Parent Organisation Type Join Parent Date Left Parent Date Amended Record Indicator
101 A81034 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
102 A81034 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
103 A81034 00K W 2013-04-01 00:00:00   0
104 A81035 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
105 A81035 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
106 A81035 00M W 2013-04-01 00:00:00   0
107 A81036 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
108 A81036 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
109 A81036 00K W 2013-04-01 00:00:00   0
110 A81037 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
111 A81037 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
112 A81037 00M W 2013-04-01 00:00:00   0
113 A81038 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
114 A81038 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
115 A81038 00M W 2013-04-01 00:00:00   0
116 A81039 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
117 A81039 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
118 A81039 00K W 2013-04-01 00:00:00   0
119 A81040 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
120 A81040 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
121 A81040 00K W 2013-04-01 00:00:00   0
122 A81041 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
123 A81041 5D9 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
124 A81041 00K W 2013-04-01 00:00:00   0
125 A81042 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
126 A81042 5KM W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
127 A81042 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
128 A81042 00M W 2013-04-01 00:00:00   0
129 A81043 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
130 A81043 5KM W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
131 A81043 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
132 A81043 00M W 2013-04-01 00:00:00   0
133 A81044 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
134 A81044 5D9 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
135 A81044 00K W 2013-04-01 00:00:00   0
136 A81045 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
137 A81045 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
138 A81045 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
139 A81045 00M W 2013-04-01 00:00:00   0
140 A81046 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
141 A81046 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
142 A81046 00K W 2013-04-01 00:00:00   0
143 A81047 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
144 A81047 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
145 A81047 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
146 A81047 00M W 2013-04-01 00:00:00   0
147 A81048 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
148 A81048 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
149 A81048 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
150 A81048 00M W 2013-04-01 00:00:00   0
151 A81049 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
152 A81049 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
153 A81049 00M W 2013-04-01 00:00:00   0
154 A81051 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
155 A81051 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
156 A81051 00M W 2013-04-01 00:00:00   0
157 A81052 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
158 A81052 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
159 A81052 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
160 A81052 00M W 2013-04-01 00:00:00   0
161 A81053 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
162 A81053 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
163 A81053 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
164 A81053 00M W 2013-04-01 00:00:00   0
165 A81054 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
166 A81054 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
167 A81054 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
168 A81054 00M W 2013-04-01 00:00:00   0
169 A81055 4XA29 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
170 A81055 5KN W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
171 A81055 5QR W 2006-10-01 00:00:00 2012-09-30 00:00:00 0
172 A81056 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
173 A81056 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
174 A81056 00K W 2013-04-01 00:00:00   0
175 A81057 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
176 A81057 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
177 A81057 00K W 2013-04-01 00:00:00   0
178 A81058 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
179 A81058 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
180 A81058 00M W 2013-04-01 00:00:00   0
181 A81060 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
182 A81060 5D9 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
183 A81060 00K W 2013-04-01 00:00:00   0
184 A81061 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
185 A81061 5E1 W 2001-04-01 00:00:00 2012-09-30 00:00:00 0
186 A81063 4FC32 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
187 A81063 5D9 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
188 A81063 00K W 2013-04-01 00:00:00   0
189 A81064 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
190 A81064 5KM W 2002-04-01 00:00:00 2013-03-31 00:00:00 0
191 A81064 00M W 2013-04-01 00:00:00   0
192 A81065 4DD23 W 1999-04-01 00:00:00 2002-03-31 00:00:00 0
193 A81065 5KM W 2002-04-01 00:00:00 2006-09-30 00:00:00 0
194 A81065 5QR W 2006-10-01 00:00:00 2013-03-31 00:00:00 0
195 A81065 00M W 2013-04-01 00:00:00   0
196 A81066 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
197 A81066 5E1 W 2001-04-01 00:00:00 2013-03-31 00:00:00 0
198 A81066 00K W 2013-04-01 00:00:00   0
199 A81067 4QP36 W 1999-04-01 00:00:00 2001-03-31 00:00:00 0
200 A81067 5E1 W 2001-04-01 00:00:00 2013-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 107.464ms · Data source: OUseful Databeat