Fields |
| Number of fields |
17 |
| |
|
| 1 |
| Field name: |
Record-Type |
| Data type: |
Fixed Length String (length 1) |
| Original description: |
|
| Further descriptive information: |
Record type: always 'N' for No-Crime records (cf. the Rec-Type field in the main Offence record) |
| Missing value(s): |
One or more spaces |
| Attributes: |
|
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 2 |
| Field name: |
Date-Reported-YY |
| Data type: |
Integer (length 2) |
| Original description: |
|
| Further descriptive information: |
The year of the No-Crime report |
| Missing value(s): |
One or more spaces |
| Attributes: |
|
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 3 |
| Field name: |
Date-Reported-MM |
| Data type: |
Integer (length 2) |
| Original description: |
|
| Further descriptive information: |
The month of the No-Crime report |
| Missing value(s): |
One or more spaces |
| Attributes: |
|
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 4 |
| Field name: |
Date-Reported-DD |
| Data type: |
Integer (length 2) |
| Original description: |
|
| Further descriptive information: |
The date of the No-Crime report |
| Missing value(s): |
One or more spaces |
| Attributes: |
|
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 5 |
| Field name: |
Date-Input-YY |
| Data type: |
Integer (length 2) |
| Original description: |
|
| Further descriptive information: |
The year that the No-Crime details were input to the system |
| Missing value(s): |
One or more spaces |
| Attributes: |
|
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 6 |
| Field name: |
Date-Input-MM |
| Data type: |
Integer (length 2) |
| Original description: |
|
| Further descriptive information: |
The month that the No-Crime details were input to the system |
| Missing value(s): |
One or more spaces |
| Attributes: |
|
| Constraints: |
This field may take any value appropriate to its datatype. |
| Encoding: |
[No encoding used] |
| |
| 7 |
| Field name: |
Subdivision-Code |
| Data type: |
Fixed Length String (length 2) |
| Original description: |
The identifying code for an MPD-SUBDIVISION |
| Further descriptive information: |
The identifying code for the Met Police Subdivision (station) where the allegation was made. Station codes of 2 alpha characters; also 'C1' & 'C6' for CO Branches (see Division-Code) The Subdivision is equivalent to an individual police station within a Division (except for the codes C1 and C6 which represent New Scotland Yard branches). The interpretation of the codes for values in this field is based on the codes for Metropolitan Police Stations given in the
Police and Constabulary Almanac 1993: Official Register (Henley-on-Thames: R. Hazell and Company, 1993), pp. 33-36, and on the List of Station Codes (CRDA/1/DD/3/3 and CRDA/1/DD/3/4) and the Specification of Borough Tables (CRDA/1/DD/3/5) supplied by the Metropolitan Police (see the Dataset Documentation Catalogue).
|
| Missing value(s): |
One or more spaces |
| Attributes: |
|
| Constraints: |
[As specified by Encoding] |
| Encoding: |
This field may only take one of the 167 pre-defined values listed |
| Codes |
Values |
| ZD | Croydon |
| CR | CR: Undocumented code |
| KL | Colier Row |
| LM | Clapham |
| VC | Cobham |
| GD | City Road |
| TC | Chiswick |
| QD | Chigwell |
| PC | Chislehurst |
| JC | Chingford |
| JD | Chigwell |
| YC | Cheshunt |
| BC | Chelsea |
| JH | Chadwell Heath |
| MS | Carter Street |
| PD | Catford |
| MC | Camberwell |
| NC | Caledonian Road |
| C6 | C.O. Branch (C6: Undocumented code) |
| SU | Bushey |
| C1 | C.O. Branch (C1: Undocumented code) |
| PK | Brockley |
| PR | Bromley |
| TB | Brentford |
| LD | Brixton |
| CB | Bow Street |
| PH | Biggin Hill |
| SD | Borehamwood |
| RY | Bexleyheath |
| HB | Bethnal Green |
| WA | Battersea |
| SA | Barnet |
| RB | Belvedere |
| ZB | Banstead |
| JB | Barkingside |
| HW | Bow Road |
| KB | Barking |
| ED | Albany Street |
| ZA | Addington |
| XA | Acton |
| RH | RH: Undocumented code |
| KM | Rainham |
| WP | Putney |
| SP | Potters Bar |
| YP | Ponders End |
| RP | Plumstead |
| RA | Plumstead |
| KO | Plaistow |
| PG | Penge |
| QP | Pinner |
| MM | Peckham |
| DD | Paddington Green |
| PN | Orpington |
| XN | Northwood |
| BH | Notting Hill |
| KN | North Woolwich |
| VN | New Malden |
| YM | Muswell Hill |
| SH | Mill Hill |
| DM | Marylebone |
| JO | Loughton |
| HH | Limehouse |
| JS | Leytonstone |
| JL | Leyton |
| PL | Lewisham |
| HD | Leman Street |
| PE | Lee Road |
| VK | Kingston |
| ND | King's Cross Road |
| QK | Kilburn |
| BD | Kensington |
| LK | Kennington |
| EK | Kentish Town |
| ZK | Kenley |
| NI | Islington |
| HI | Isle of Dogs |
| JI | Ilford |
| AH | Hyde Park |
| YR | Hornsey |
| TD | Hounslow |
| KC | Hornchurch |
| NH | Holloway |
| EO | Holborn |
| YH | Highgate |
| NV | Highbury Vale |
| SN | Hendon |
| ID | Heathrow Airport |
| DR | Harrow Road |
| XY | Hayes |
| QA | Harrow |
| KA | Harold Hill |
| QH | Harlesden |
| EH | Hampstead |
| FH | Hammersmith |
| FD | Hammersmith |
| GH | Hackney |
| XG | Greenford |
| RG | Greenwich |
| SG | Golders Green |
| AL | Gerald Road |
| FF | Fulham |
| KF | Forest Gate |
| SF | Finchley |
| TF | Feltham |
| VH | Esher |
| ZP | Epsom |
| RE | Erith |
| YF | Enfield |
| RD | Eltham |
| RM | Eltham |
| YE | Edmonton |
| VE | East Molesey |
| KE | East Ham |
| ME | East Dulwich |
| WF | Earlsfield |
| XD | Ealing |
| PP | Deptford |
| GA | Dalston |
| KG | Dagenham |
| XS | Southall |
| ZN | South Norwood |
| UP | Shepperton [River Police] |
| FS | Shepherds Bush |
| XR | Ruislip |
| MR | Rotherhithe |
| AR | Rochester Row |
| TR | Richmond |
| KD | Romford |
| Not applicable |
| RW | Woolwich |
| YD | Wood Green |
| YW | Winchmore Hill |
| JF | Woodford |
| VW | Wimbledon |
| ST | Whetstone |
| QL | Willesden Green |
| KW | West Ham |
| SV | West Hendon |
| EW | West Hampstead |
| CD | West End Central |
| RK | Westcombe Park |
| XE | West Drayton |
| QW | Wealdstone |
| JN | Wanstead |
| WW | Wandsworth |
| UD | Wapping [River Police] |
| JA | Waltharn Abbey |
| ZW | Wallington |
| VM | VM: Undocumented code |
| CV | Vine Street |
| XU | Uxbridge |
| TW | Twickenham |
| KU | Upminster |
| YT | Tottenham |
| RT | Thamesmead |
| PS | Sydenham |
| WD | Tooting |
| ZT | Sutton |
| VS | Surbiton |
| TY | Sunbury |
| LS | Streatham |
| TG | Staines |
| GN | Stoke Newington |
| DS | St. John's Wood |
| YA | St. Ann's Road |
| MD | Southwark |
| YS | Southgate |
|
| |
| 8 |
| Field name: |
Division-Code |
| Data type: |
Fixed Length String (length 2) |
| Original description: |
The identifying code for an MPD-DIVISION |
| Further descriptive information: |
Met Police Division where the allegation was made Metropolitan Police Areas are divided into Divisions. Each Division is named after its Divisional Station (the administrative centre of the Division). The code for the Division is identical to the code for the Divisional Station. The interpretation of the codes for values in this field is based on the codes for Metropolitan Police Stations given in the
Police and Constabulary Almanac 1993: Official Register (Henley-on-Thames: R. Hazell and Company, 1993), pp. 33-36, and on the List of Station Codes (CRDA/1/DD/3/3 and CRDA/1/DD/3/4) and the Specification of Borough Tables (CRDA/1/DD/3/5) supplied by the Metropolitan Police (see the Dataset Documentation Catalogue).
|
| Missing value(s): |
One or more spaces |
| Attributes: |
|
| Constraints: |
[As specified by Encoding] |
| Encoding: |
This field may only take one of the 75 pre-defined values listed |
| Codes |
Values |
| QD | Chigwell |
| JC | Chingford |
| BC | Chelsea |
| PD | Catford |
| MS | Carter Street |
| CX | Charing Cross |
| CO | C.O. Branch |
| TA | Bushey |
| PR | Bromley |
| RY | Bexleyheath |
| LD | Brixton |
| HB | Bethnal Green |
| AB | Belgravia |
| WA | Battersea |
| SA | Barnet |
| JB | Barkingside |
| KG | Dagenham |
| ZD | Croydon |
| LM | Clapham |
| TC | Chiswick |
| XD | Ealing |
| YE | Edmonton |
| YF | Enfield |
| ZP | Epsom |
| FF | Fulham |
| SG | Golders Green |
| RG | Greenwich |
| GH | Hackney |
| FD | Hammersmith |
| FH | Hammersmith |
| EH | Hampstead |
| DR | Harrow Road |
| QA | Harrow |
| XY | Hayes |
| ID | Heathrow Airport |
| EO | Holborn |
| NH | Holloway |
| YR | Hornsey |
| TD | Hounslow |
| JI | Ilford |
| LK | Kennington |
| BD | Kensington |
| EK | Kentish Town |
| QK | Kilburn |
| ND | King's Cross Road |
| VK | Kingston |
| HD | Leman Street |
| PL | Lewisham |
| JL | Leyton |
| HH | Limehouse |
| DM | Marylebone |
| BH | Notting Hill |
| PN | Orpington |
| DD | Paddington Green |
| MM | Peckham |
| KO | Plaistow |
| RA | Plumstead |
| KD | Romford |
| ZN | South Norwood |
| XS | Southall |
| MD | Southwark |
| TG | Staines |
| GN | Stoke Newington |
| LS | Streatham |
| WD | Tooting |
| YT | Tottenham |
| TW | Twickenham |
| XU | Uxbridge |
| WW | Wandsworth |
| CD | West End Central |
| KW | West Ham |
| SV | West Hendon |
| VW | Wimbledon |
| RW | Woolwich |
| Not applicable |
|
| |
| 9 |
| Field name: |
Area-Code |
| Data type: |
Fixed Length String (length 1) |
| Original description: |
The identifying code for an MPD-AREA |
| Further descriptive information: |
Met Police Area where the allegation was made In 1993 the Metropolitan Police District was divided into the following numbered Areas:
- 1 Area- North: the London Boroughs of Waltham Forest, Redbridge, Islington, Haringey, Enfield; the area of the former Urban District of Chigwell and the parish of Waltham Holy Cross (Essex); the area of the former Urban District of Cheshunt and the parish of Northaw (Hertfordshire).
- 2 Area- East: the London Boroughs of Hackney, Tower Hamlets, Havering, Barking and Dagenham, Newham.
- 3 Area- South East: the London Boroughs of Southwark, Lewisham, Bromley, Greenwich and Bexley.
- 4 Area- South: the London Boroughs of Lambeth, Merton, Croydon and Sutton; the District of Epsom and Ewell (Surrey); and the area of the former Urban District of Banstead (Surrey).
- 5 Area- South West: the London boroughs of Richmond upon Thames, Hounslow, Wandsworth, the Royal Borough of Kingston upon Thames, the District of Spelthorne and the area of the former Urban District of Esher (Surrey).
- 6 Area- West: the Royal Borough of Kensington and Chelsea, the London Boroughs of Hammersmith and Fulham, Ealing and Hillingdon, and Heathrow Airport.
- 7 Area- North West: the London boroughs of Camden, Brent, Harrow and Barnet, and the District of Hertsmere.
- 8 Area- Westminster: the City of Westminster.
Source: R. Hazell and Company, Police and Constabulary Almanac 1993: Official Register (Henley-on-Thames: R. Hazell and Company, 1993), pp. 36 et seq.
|
| Missing value(s): |
One or more spaces |
| Attributes: |
|
| Constraints: |
[As specified by Encoding] |
| Encoding: |
This field may only take one of the 9 pre-defined values listed |
| Codes |
Values |
| 1 | 1 Area |
| 2 | 2 Area |
| 3 | 3 Area |
| 4 | 4 Area |
| 5 | 5 Area |
| 6 | 6 Area |
| 7 | 7 Area |
| 8 | 8 Area |
| C | HQ (Not Area Based) |
|
| |
| 10 |
| Field name: |
Offence-Local-Authority-Code |
| Data type: |
Integer (length 2) |
| Original description: |
|
| Further descriptive information: |
Code indicating the London borough or local authority where the allegation was made The interpretation of the codes for values in this field is based on the document 'Specification of Borough Tables' dated 29/11/94, supplied by the Metropolitan Police. This correlates the Local Authorities to the Police divisions. See the dataset documentation catalogue (reference CRDA/1/DD/3/5) for a copy of this document. |
| Missing value(s): |
00 |
| Attributes: |
|
| Constraints: |
[As specified by Encoding] |
| Encoding: |
This field may only take one of the 45 pre-defined values listed |
| Codes |
Values |
| 16 | Barking and Dagenham |
| 30 | Barnet |
| 18 | Bexley |
| 28 | Brent |
| 19 | Bromley & Orpington ** |
| 35 | Broxbourne (part of borough within MPD) |
| 2 | Camden |
| 20 | Croydon |
| 27 | Ealing |
| 39 | Elmbridge |
| 32 | Enfield |
| 36 | Epping Forest (part of borough within MPD) |
| 38 | Epsom & Ewell |
| 6 | Greenwich |
| 4 | Hackney |
| 11 | Hammersmith & Fulham |
| 31 | Haringey |
| 29 | Harrow |
| 15 | Havering |
| 50 | Heathrow Airport |
| 33 | Hertsmere (part of borough within MPD) |
| 26 | Hillingdon (excluding Heathrow Airport) |
| 25 | Hounslow (excluding Heathrow Airport) |
| 3 | Islington |
| 12 | Kensington & Chelsea |
| 23 | Kingston upon Thames |
| 9 | Lambeth |
| 7 | Lewisham |
| 22 | Merton |
| 17 | Newham |
| 14 | Redbridge |
| 37 | Reigate & Banstead (part of borough within MPD) |
| 24 | Richmond upon Thames |
| 8 | Southwark |
| 40 | Spelthorne |
| 21 | Sutton |
| 5 | Tower Hamlets |
| 13 | Waltham Forest |
| 10 | Wandsworth |
| 34 | Welwyn & Hatfield (part of borough within MPD) |
| 1 | Westminster |
| 88 | No Fixed Abode |
| 99 | Outside M P D |
| 51 | 51: Undocumented code |
| 52 | 52: Undocumented code |
|
| |
| |
|