home

nhsadmin

Data source: OUseful Databeat

Custom SQL query

eabeydispgp

Organisation Code, Name, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5, Postcode, Open Date...

1,631 rows

ecare

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

406 rows

ecarehomehq

Organisation Code, Name, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5, Postcode, Open Date...

12,216 rows

ecarehomesite

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

31,086 rows

ecarehomesucc

Organisation Code, Successor Organisation Code, Successor Reason Code, Succession Effective Date, Succession Indicator

7,867 rows

eccg

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

226 rows

eccgsite

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

1,860 rows

edispensary

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

16,865 rows

egdpprac

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

10,410 rows

egparc

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

7,610 rows

egpcur

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

83,108 rows

ehospice

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

283 rows

ejustice

Organisation Code, Justice Estate Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

624 rows

enonnhs

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

13,909 rows

enurse

Nurse PIN, Nurse Type, Parent Organisation Code, Open Date, Close Date, Title, Initials, Surname, Address1...

46,394 rows

epcdp

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

6,479 rows

epcmem

Organisation Code, Parent Organisation Code, Parent Organisation Type, Join Parent Date, Left Parent Date, Amended Record Indicator

45,684 rows

epharmacyhq

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

5,954 rows

ephp

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

1,321 rows

ephpsite

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

10,644 rows

epracarc

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

4,071 rows

epraccur

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

13,469 rows

epracmem

Practitioner Code, Parent Organisation Code, Parent Organisation Type, Join Parent Date, Left Parent Date, Amended Record Indicator

123,680 rows

eprison

Organisation Code, Name, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5, Postcode, Open Date...

161 rows

eschools

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

35,596 rows

etrust

Organisation Code, Name, National Grouping, High Level Health Geography, Address Line 1, Address Line 2, Address Line 3, Address Line 4, Address Line 5...

28,865 rows

Download SQLite DB: nhsadmin.db

Powered by Datasette · Query took 0.089ms · Data source: OUseful Databeat