home / nhsadmin

nhsadmin

Custom SQL query returning 101 rows

This data as .json

rowidOrganisation CodeNameNational GroupingHigh Level Health GeographyAddress Line 1Address Line 2Address Line 3Address Line 4Address Line 5PostcodeOpen DateClose DateLocal AuthorityContact Telephone NumberAmended Record IndicatorCurrent Care OrganisationType of Establishment
1 EE100000 SIR JOHN CASS'S FOUNDATION PRIMARY SCHOOL Y56 Q71 ST JAMES'S PASSAGE DUKE'S PLACE   LONDON   EC3A 5DE 1900-01-01 00:00:00   714 2072831147.0 0 07T 2
2 EE100001 CITY OF LONDON SCHOOL FOR GIRLS Y56 Q71 ST GILES' TERRACE BARBICAN   LONDON   EC2Y 8BB 1920-01-01 00:00:00   714 2078475500.0 0 07T 11
3 EE100002 ST PAUL'S CATHEDRAL SCHOOL Y56 Q71 2 NEW CHANGE     LONDON   EC4M 9AD 1939-01-01 00:00:00   714 2072485156.0 0 07T 11
4 EE100003 CITY OF LONDON SCHOOL Y56 Q71 QUEEN VICTORIA STREET     LONDON   EC4V 3AL 1919-01-01 00:00:00   714 2074890291.0 0 07T 11
5 EE100005 THOMAS CORAM CENTRE Y56 Q71 49 MECKLENBURGH SQUARE     LONDON   WC1N 2NY 1900-01-01 00:00:00   702 2075200385.0 0 07R 15
6 EE100006 CCFL KEY STAGE 4 PRU Y56 Q71 AGINCOURT ROAD     LONDON   NW3 2NY 1999-09-01 00:00:00   702 2079748906.0 0 07R 14
7 EE100007 CAMDEN PRIMARY PUPIL REFERRAL UNIT Y56 Q71 ROBSON HOUSE, 74 STANHOPE STREET   LONDON   NW1 3EX 1900-01-01 00:00:00   702 2037720370.0 0 07R 14
8 EE100008 ARGYLE PRIMARY SCHOOL Y56 Q71 TONBRIDGE STREET     LONDON   WC1H 9EG 1900-01-01 00:00:00   702 2078374590.0 0 07R 1
9 EE100009 BECKFORD PRIMARY SCHOOL Y56 Q71 DORNFELL STREET WEST HAMPSTEAD   LONDON   NW6 1QL 1900-01-01 00:00:00   702 2074358646.0 0 07R 1
10 EE100010 BRECKNOCK PRIMARY SCHOOL Y56 Q71 CLIFF VILLAS     LONDON   NW1 9AL 1900-01-01 00:00:00   702 2074856334.0 0 07R 1
11 EE100011 BROOKFIELD PRIMARY SCHOOL Y56 Q71 CHESTER ROAD     LONDON   N19 5DH 1900-01-01 00:00:00   702 2072729627.0 0 07R 1
12 EE100012 CARLTON PRIMARY SCHOOL Y56 Q71 GRAFTON ROAD     LONDON   NW5 4AX 1900-01-01 00:00:00   702 2074851947.0 0 07R 1
13 EE100013 EDITH NEVILLE PRIMARY SCHOOL Y56 Q71 174 OSSULSTON STREET     LONDON   NW1 1DN 1900-01-01 00:00:00   702 2073877158.0 0 07R 1
14 EE100014 FLEET PRIMARY SCHOOL Y56 Q71 FLEET ROAD     LONDON   NW3 2QT 1900-01-01 00:00:00   702 2074852028.0 0 07R 1
15 EE100015 HAWLEY PRIMARY SCHOOL Y56 Q71 HAWLEY ROAD     LONDON   NW1 8RP 1900-01-01 00:00:00   702 2074855020.0 0 07R 1
16 EE100018 NETLEY PRIMARY SCHOOL & CENTRE FOR AUTISM Y56 Q71 74 STANHOPE STREET     LONDON   NW1 3EX 1900-01-01 00:00:00   702 2037720350.0 0 07R 1
17 EE100019 NEW END PRIMARY SCHOOL Y56 Q71 STREATLEY PLACE HAMPSTEAD   LONDON   NW3 1HU 1900-01-01 00:00:00   702 2074310961.0 0 07R 1
18 EE100020 PRIMROSE HILL SCHOOL Y56 Q71 PRINCESS ROAD     LONDON   NW1 8JL 1900-01-01 00:00:00   702 2077228500.0 0 07R 1
19 EE100021 RHYL PRIMARY SCHOOL Y56 Q71 RHYL STREET     LONDON   NW5 3HB 1900-01-01 00:00:00   702 2074854899.0 0 07R 1
20 EE100022 RICHARD COBDEN PRIMARY SCHOOL Y56 Q71 CAMDEN STREET     LONDON   NW1 0LL 1900-01-01 00:00:00   702 2073875909.0 0 07R 1
21 EE100023 TORRIANO PRIMARY SCHOOL Y56 Q71 TORRIANO AVENUE KENTISH TOWN   LONDON   NW5 2SJ 1900-01-01 00:00:00   702 2074240202.0 0 07R 1
22 EE100024 TORRIANO INFANT SCHOOL Y56 Q71 TORRIANO AVENUE     LONDON   NW5 2SJ 1900-01-01 00:00:00 2015-09-11 00:00:00 702 2074854325.0 0 07R 1
23 EE100025 GOSPEL OAK PRIMARY SCHOOL Y56 Q71 MANSFIELD ROAD     LONDON   NW3 2JB 1900-01-01 00:00:00   702 2074857435.0 0 07R 1
24 EE100026 FITZJOHN'S PRIMARY SCHOOL Y56 Q71 86A FITZJOHN'S AVENUE     LONDON   NW3 6NP 1900-01-01 00:00:00   702 2074359797.0 0 07R 1
25 EE100027 ELEANOR PALMER PRIMARY SCHOOL Y56 Q71 LUPTON STREET     LONDON   NW5 2JA 1900-01-01 00:00:00   702 2074852155.0 0 07R 1
26 EE100028 CHRIST CHURCH PRIMARY SCHOOL, HAMPSTEAD Y56 Q71 CHRIST CHURCH HILL     LONDON   NW3 1JH 1900-01-01 00:00:00   702 2074351361.0 0 07R 2
27 EE100029 CHRIST CHURCH SCHOOL Y56 Q71 REDHILL STREET CAMDEN   LONDON   NW1 4BD 1900-01-01 00:00:00   702 2073877881.0 0 07R 2
28 EE100030 EMMANUEL CHURCH OF ENGLAND PRIMARY SCHOOL Y56 Q71 152-158 MILL LANE WEST HAMPSTEAD   LONDON   NW6 1TF 1900-01-01 00:00:00   702 2074317984.0 0 07R 2
29 EE100031 HAMPSTEAD PAROCHIAL CHURCH OF ENGLAND PRIMARY SCHOOL Y56 Q71 HOLLY BUSH VALE     LONDON   NW3 6TX 1900-01-01 00:00:00   702 2074354135.0 0 07R 2
30 EE100032 HOLY TRINITY COFE PRIMARY SCHOOL, NW3 Y56 Q71 TRINITY WALK MARESFIELD GARDENS   LONDON   NW3 5SQ 1900-01-01 00:00:00   702 2074359089.0 0 07R 2
31 EE100033 HOLY TRINITY AND SAINT SILAS COFE PRIMARY SCHOOL, NW1 Y56 Q71 HARTLAND ROAD     LONDON   NW1 8DE 1900-01-01 00:00:00   702 2072670771.0 0 07R 2
32 EE100034 KENTISH TOWN CHURCH OF ENGLAND PRIMARY SCHOOL Y56 Q71 ISLIP STREET     LONDON   NW5 2TU 1900-01-01 00:00:00   702 2074851279.0 0 07R 2
33 EE100035 ROSARY ROMAN CATHOLIC PRIMARY SCHOOL Y56 Q71 238 HAVERSTOCK HILL HAMPSTEAD   LONDON   NW3 2AE 1900-01-01 00:00:00   702 2077946292.0 0 07R 2
34 EE100036 ST ALBAN'S CHURCH OF ENGLAND PRIMARY SCHOOL Y56 Q71 BALDWINS GARDENS HOLBORN   LONDON   EC1N 7SD 1900-01-01 00:00:00   702 2072428585.0 0 07R 2
35 EE100037 ST ALOYSIUS CATHOLIC PRIMARY SCHOOL Y56 Q71 ALDENHAM STREET     LONDON   NW1 1PS 1900-01-01 00:00:00   702 2073873551.0 1 07R 2
36 EE100038 ST ALOYSIUS ROMAN CATHOLIC INFANT SCHOOL Y56 Q71 28 PHOENIX ROAD     LONDON   NW1 1TA 1900-01-01 00:00:00 2016-12-31 00:00:00 702 2073873551.0 0 07R 2
37 EE100039 ST DOMINIC'S CATHOLIC PRIMARY SCHOOL Y56 Q71 SOUTHAMPTON ROAD     LONDON   NW5 4JS 1900-01-01 00:00:00   702 2074855918.0 0 07R 2
38 EE100040 ST GEORGE THE MARTYR CHURCH OF ENGLAND PRIMARY SCHOOL Y56 Q71 JOHN'S MEWS     LONDON   WC1N 2NX 1900-01-01 00:00:00   702 2074055640.0 0 07R 2
39 EE100041 ST JOSEPHS CATHOLIC PRIMARY SCHOOL Y56 Q71 MACKLIN STREET COVENT GARDEN   LONDON   WC2B 5NA 1900-01-01 00:00:00   702 2072427712.0 1 07R 2
40 EE100042 ST MARY'S KILBURN CHURCH OF ENGLAND PRIMARY SCHOOL Y56 Q71 QUEX ROAD KILBURN   LONDON   NW6 4PG 1900-01-01 00:00:00   702 2073726565.0 0 07R 2
41 EE100043 ST MARY AND ST PANCRAS CHURCH OF ENGLAND PRIMARY SCHOOL Y56 Q71 81 WERRINGTON STREET     LONDON   NW1 1QP 1900-01-01 00:00:00   702 2073876117.0 0 07R 2
42 EE100044 ST MICHAEL'S CHURCH OF ENGLAND PRIMARY SCHOOL Y56 Q71 88 CAMDEN STREET     LONDON   NW1 0JA 1900-01-01 00:00:00   702 2074858965.0 0 07R 2
43 EE100045 ST PATRICK'S CATHOLIC PRIMARY SCHOOL Y56 Q71 HOLMES ROAD     LONDON   NW5 3AH 1900-01-01 00:00:00   702 2072671200.0 0 07R 2
44 EE100046 ST PAUL'S CHURCH OF ENGLAND PRIMARY SCHOOL Y56 Q71 ELSWORTHY ROAD PRIMROSE HILL   LONDON   NW3 3DS 1900-01-01 00:00:00   702 2077227381.0 0 07R 2
45 EE100047 ST EUGENE DE MAZENOD ROMAN CATHOLIC PRIMARY SCHOOL Y56 Q71 MAZENOD AVENUE     LONDON   NW6 4LS 1900-01-01 00:00:00   702 2076244837.0 0 07R 2
46 EE100048 OUR LADY ROMAN CATHOLIC PRIMARY SCHOOL Y56 Q71 PRATT STREET CAMDEN   LONDON   NW1 0DP 1900-01-01 00:00:00   702 2074857997.0 0 07R 2
47 EE100049 HAVERSTOCK SCHOOL Y56 Q71 24 HAVERSTOCK HILL CHALK FARM   LONDON   NW3 2BQ 1900-01-01 00:00:00   702 2072670975.0 0 07R 1
48 EE100050 PARLIAMENT HILL SCHOOL Y56 Q71 HIGHGATE ROAD     LONDON   NW5 1RL 1900-01-01 00:00:00   702 2074857077.0 0 07R 1
49 EE100051 REGENT HIGH SCHOOL Y56 Q71 CHALTON STREET CAMDEN   LONDON   NW1 1RX 1900-01-01 00:00:00   702 2073870126.0 0 07R 1
50 EE100052 HAMPSTEAD SCHOOL Y56 Q71 WESTBERE ROAD HAMPSTEAD   LONDON   NW2 3RT 1900-01-01 00:00:00   702 2077948133.0 0 07R 1
51 EE100053 ACLAND BURGHLEY SCHOOL Y56 Q71 BURGHLEY ROAD     LONDON   NW5 1UJ 1900-01-01 00:00:00   702 2074858515.0 0 07R 1
52 EE100054 THE CAMDEN SCHOOL FOR GIRLS Y56 Q71 SANDALL ROAD     LONDON   NW5 2DB 1900-01-01 00:00:00   702 2074853414.0 0 07R 2
53 EE100055 MARIA FIDELIS ROMAN CATHOLIC CONVENT SCHOOL FCJ Y56 Q71 34 PHOENIX ROAD     LONDON   NW1 1TA 1900-01-01 00:00:00   702 2073873856.0 0 07R 2
54 EE100056 WILLIAM ELLIS SCHOOL Y56 Q71 HIGHGATE ROAD     LONDON   NW5 1RN 1900-01-01 00:00:00   702 2072679346.0 0 07R 2
55 EE100059 LA SAINTE UNION CATHOLIC SECONDARY SCHOOL Y56 Q71 HIGHGATE ROAD     LONDON   NW5 1RP 1900-01-01 00:00:00   702 2074284600.0 0 07R 2
56 EE100060 CHILDREN'S HOSPITAL SCHOOL AT GT ORMOND STREET AND UCH Y56 Q71 GREAT ORMOND STREET CAMDEN   LONDON   WC1N 3JH 1900-01-01 00:00:00   702 2078138269.0 0 07R 12
57 EE100061 ST CHRISTOPHER'S SCHOOL Y56 Q71 32 BELSIZE LANE     LONDON   NW3 5AE 1924-01-01 00:00:00   702 2074351521.0 0 07R 11
58 EE100062 ST MARGARET'S SCHOOL Y56 Q71 18 KIDDERPORE GARDENS     LONDON   NW3 7SR 1920-01-01 00:00:00   702 2074352439.0 0 07R 11
59 EE100063 SARUM HALL SCHOOL Y56 Q71 15 ETON AVENUE     LONDON   NW3 3EL 1934-01-01 00:00:00   702 2077942261.0 0 07R 11
60 EE100064 THE HALL SCHOOL Y56 Q71 23 CROSSFIELD ROAD HAMPSTEAD   LONDON   NW3 4NU 1919-01-01 00:00:00   702 2077221700.0 0 07R 11
61 EE100065 UNIVERSITY COLLEGE SCHOOL Y56 Q71 FROGNAL HAMPSTEAD   LONDON   NW3 6XH 1907-01-01 00:00:00   702 2074352215.0 0 07R 11
62 EE100066 THE CAVENDISH SCHOOL Y56 Q71 31 INVERNESS STREET     LONDON   NW1 7HB 1950-01-01 00:00:00   702 2074851958.0 0 07R 11
63 EE100067 ST MARY'S SCHOOL Y56 Q71 47 FITZJOHN'S AVENUE HAMPSTEAD   LONDON   NW3 6PG 1951-01-01 00:00:00   702 2074351868.0 0 07R 11
64 EE100068 NORTH BRIDGE HOUSE PRE-PREP SCHOOL Y56 Q71 8 NETHERHALL GARDENS     LONDON   NW3 5RR 1957-11-18 00:00:00   702 2072676266.0 0 07R 11
65 EE100069 HEREWARD HOUSE SCHOOL Y56 Q71 14 STRATHRAY GARDENS     LONDON   NW3 4NY 1957-10-15 00:00:00   702 2077944820.0 0 07R 11
66 EE100070 ST ANTHONY'S PREPARATORY SCHOOL Y56 Q71 90 FITZJOHN'S AVENUE HAMPSTEAD   LONDON   NW3 6NP 1956-01-01 00:00:00   702 2074353597.0 0 07R 11
67 EE100071 NORTH BRIDGE NURSERY SCHOOL Y56 Q71 33 FITZJOHN'S AVENUE HAMPSTEAD   LONDON   NW3 5JY 1958-06-18 00:00:00   702 2072676266.0 0 07R 11
68 EE100072 LYNDHURST HOUSE PREPARATORY SCHOOL Y56 Q71 24 LYNDHURST GARDENS HAMPSTEAD   LONDON   NW3 5NW 1957-01-01 00:00:00   702 2074354936.0 0 07R 11
69 EE100073 HAMPSTEAD HILL SCHOOL Y56 Q71 ST STEPHENS HALL POND STREET HAMPSTEAD LONDON   NW3 2PP 1970-10-23 00:00:00   702 2074356262.0 0 07R 11
70 EE100074 NORTH BRIDGE HOUSE SENIOR SCHOOL Y56 Q71 65 ROSSLYN HILL     LONDON   NW3 5UD 1972-03-03 00:00:00   702 2072676266.0 0 07R 11
71 EE100075 TREVOR-ROBERTS SCHOOL Y56 Q71 55-57 ETON AVENUE     LONDON   NW3 3ET 1977-12-20 00:00:00   702 2075861444.0 0 07R 11
72 EE100076 SOUTH HAMPSTEAD HIGH SCHOOL Y56 Q71 3 MARESFIELD GARDENS     LONDON   NW3 5SS 1980-09-30 00:00:00   702 2074352899.0 0 07R 11
73 EE100077 THE VILLAGE SCHOOL Y56 Q71 2 PARKHILL ROAD BELSIZE PARK   LONDON   NW3 2YN 1985-10-02 00:00:00   702 2074854673.0 0 07R 11
74 EE100078 HEATHSIDE PREPARATORY SCHOOL Y56 Q71 16 NEW END HAMPSTEAD   LONDON   NW3 1JA 1986-09-19 00:00:00   702 2030584011.0 0 07R 11
75 EE100080 DEVONSHIRE HOUSE PREPARATORY SCHOOL Y56 Q71 2 ARKWRIGHT ROAD HAMPSTEAD   LONDON   NW3 6AE 1989-09-25 00:00:00   702 2074351916.0 0 07R 11
76 EE100081 BROADHURST SCHOOL Y56 Q71 19 GREENCROFT GARDENS     LONDON   NW6 3LP 1991-03-04 00:00:00   702 2073284280.0 0 07R 11
77 EE100082 COLLEGE FRANCAIS BILINGUE DE LONDRES Y56 Q71 87 HOLMES ROAD   KENTISH TOWN LONDON   NW5 3AX 1992-02-18 00:00:00   702 2079937400.0 0 07R 11
78 EE100083 ROYAL SCHOOL HAMPSTEAD Y56 Q71 65 ROSSLYN HILL HAMPSTEAD   LONDON   NW3 5UD 1986-01-28 00:00:00 2013-04-24 00:00:00 702 2077947708.0 0 07R 11
79 EE100084 FINE ARTS COLLEGE Y56 Q71 CENTRE STUDIOS 41-43 ENGLANDS LANE BELSIZE PARK LONDON   NW3 4YD 1992-06-10 00:00:00   702 2075860312.0 0 07R 11
80 EE100086 RAINBOW MONTESSORI SCHOOL Y56 Q71 13 WOODCHURCH ROAD     LONDON   NW6 3PL 1993-02-19 00:00:00   702 2073288986.0 0 07R 11
81 EE100087 THE MULBERRY HOUSE SCHOOL Y56 Q71 68 SHOOT UP HILL     LONDON   NW2 3XL 1994-06-09 00:00:00   702 2084527340.0 0 07R 11
82 EE100088 UCS PRE-PREP Y56 Q71 36 COLLEGE CRESCENT     LONDON   NW3 5LF 1994-09-12 00:00:00   702 2077224433.0 0 07R 11
83 EE100090 SOUTHBANK INTERNATIONAL SCHOOL Y56 Q71 16 NETHERHALL GARDENS     LONDON   NW3 5TH 1995-10-06 00:00:00   702 2074311200.0 0 07R 11
84 EE100091 FRANK BARNES SCHOOL FOR DEAF CHILDREN Y56 Q71 4 WOLLSTONECRAFT STREET     LONDON   N1C 4BT 1900-01-01 00:00:00   702 2073917040.0 0 07R 7
85 EE100092 CAMDEN CENTRE FOR LEARNING (CCFL) SPECIAL SCHOOL Y56 Q71 HARMOOD STREET CAMDEN   LONDON   NW1 8DP 1900-01-01 00:00:00   702 2079743953.0 0 07R 7
86 EE100093 JACK TAYLOR SCHOOL Y53 Q36 AINSWORTH WAY     LONDON   NW8 0SR 1900-01-01 00:00:00 2012-02-01 00:00:00 702 2073286731.0 0 5K7 7
87 EE100094 ROYAL FREE HOSPITAL CHILDREN'S SCHOOL Y56 Q71 FLOOR 6 - 6 WEST B POND STREET   LONDON   NW3 2QG 1900-01-01 00:00:00   702 2074726298.0 0 07R 7
88 EE100096 SWISS COTTAGE SCHOOL - DEVELOPMENT & RESEARCH CENTRE Y56 Q71 80 AVENUE ROAD     LONDON   NW8 6HX 1900-01-01 00:00:00   702 2076818080.0 0 07R 7
89 EE100097 RACHEL MCMILLAN NURSERY SCHOOL AND CHILDREN'S CENTRE Y56 Q71 MCMILLAN STREET DEPTFORD   LONDON   SE8 3EH 1900-01-01 00:00:00   703 2086924041.0 0 08A 15
90 EE100098 POUND PARK NURSERY SCHOOL Y56 Q71 POUND PARK ROAD CHARLTON   LONDON   SE7 8AF 1900-01-01 00:00:00   703 2088581791.0 0 08A 15
91 EE100099 ABBEY WOOD NURSERY SCHOOL Y56 Q71 DAHLIA ROAD   ABBEY WOOD LONDON   SE2 0SX 1900-01-01 00:00:00   703 2083110619.0 0 08A 15
92 EE100100 WOOLWICH COMMON NURSERY SCHOOL Y45 Q07 WOOLWICH COMMON     LONDON   SE18 4DJ 1900-01-01 00:00:00 2004-03-31 00:00:00 703 2088543695.0 0 5A8 15
93 EE100101 CYRIL HENRY NURSERY SCHOOL Y45 Q07 57 ST MARY STREET WOOLWICH   LONDON   SE18 5AP 1900-01-01 00:00:00 2004-04-01 00:00:00 703 2088540178.0 0 5A8 15
94 EE100102 ROBERT OWEN NURSERY SCHOOL Y56 Q71 43 COMMERELL STREET GREENWICH   LONDON   SE10 0EA 1900-01-01 00:00:00   703 2088580529.0 0 08A 15
95 EE100103 NEWHAVEN PUPIL REFERRAL UNIT Y56 Q71 NEWHAVEN GARDENS ELTHAM GREENWICH LONDON   SE9 6HR 1900-01-01 00:00:00   703 2088593114.0 0 08A 14
96 EE100111 MILLENNIUM PRIMARY SCHOOL Y56 Q71 50 JOHN HARRISON WAY GREENWICH   LONDON   SE10 0BG 1900-01-01 00:00:00 2016-08-31 00:00:00 703 2088580394.0 0 08A 1
97 EE100112 ALDERWOOD PRIMARY SCHOOL Y56 Q71 RAINHAM CLOSE ELTHAM   LONDON   SE9 2JH 1900-01-01 00:00:00   703 2088506841.0 0 08A 1
98 EE100113 BANNOCKBURN PRIMARY SCHOOL Y56 Q71 PLUMSTEAD HIGH STREET     LONDON   SE18 1HE 1900-01-01 00:00:00   703 2088542169.0 0 08A 1
99 EE100114 MORDEN MOUNT PRIMARY SCHOOL Y56 Q71 LEWISHAM ROAD     LONDON   SE13 7QP 1900-01-01 00:00:00   703 2086922920.0 0 08A 1
100 EE100115 CHERRY ORCHARD PRIMARY SCHOOL Y56 Q71 RECTORY FIELD CRESCENT MARLBOROUGH LANE   LONDON   SE7 7DG 1900-01-01 00:00:00   703 2088566766.0 0 08A 1
101 EE100120 EALDHAM PRIMARY SCHOOL Y56 Q71 EALDHAM SQUARE ELTHAM   LONDON   SE9 6BP 1900-01-01 00:00:00   703 2088505484.0 0 08A 1
Powered by Datasette · Query took 15.607ms · Data source: OUseful Databeat