Conservation Areas - Rochdale Borough Council
Rochdale Borough Council
@ukgov.conservation_areas_rochdale_borough_council
Table 2
@ukgov.conservation_areas_rochdale_borough_council.table_2
- 11.74 KB
- 29 rows
- 10 columns
referenceReference | nameName | conservation_areaConservation Area | documentation_urlDocumentation-url | document_urlDocument-url | n__document_typeDocument-type | start_dateStart-date | designation_dateDesignation-date | end_dateEnd-date | entry_dateEntry-date |
|---|---|---|---|---|---|---|---|---|---|
| CA1 | Rochdale Town Centre Conservation Area | CA1 | https://www.rochdale.gov.uk/downloads/download/191/list-of-conservation-areas-maps-and-appraisals#Rochdale Town Centre | https://www.rochdale.gov.uk/downloads/file/496/rochdale-town-centre-conservation-area-appraisal | area-appraisal | Wed Sep 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Sep 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Sep 07 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| CA2 | Ogden Conservation Area | CA2 | https://www.rochdale.gov.uk/downloads/download/191/list-of-conservation-areas-maps-and-appraisals#Ogden | https://www.rochdale.gov.uk/downloads/file/491/ogden-1974-conservation-area-map | area-map | Sun Sep 01 1974 00:00:00 GMT+0000 (Coordinated Universal Time) | Sun Sep 01 1974 00:00:00 GMT+0000 (Coordinated Universal Time) | Sun Sep 01 1974 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| CA3 | Wardle Conservation Area | CA3 | https://www.rochdale.gov.uk/downloads/download/191/list-of-conservation-areas-maps-and-appraisals#Wardle | https://www.rochdale.gov.uk/downloads/file/504/wardle-littleborough-1977-conservation-area-map | area-map | Sun Dec 01 1974 00:00:00 GMT+0000 (Coordinated Universal Time) | Sun Dec 01 1974 00:00:00 GMT+0000 (Coordinated Universal Time) | Sun Dec 01 1974 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| CA4 | Ashworth Fold Conservation Area | CA4 | https://www.rochdale.gov.uk/downloads/download/191/list-of-conservation-areas-maps-and-appraisals#Ashworth Fold | https://www.rochdale.gov.uk/downloads/file/472/ashworth-fold-1975-conservation-area-map | area-map | Fri Jan 03 1975 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Jan 03 1975 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Jan 03 1975 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| CA5 | Clegg Village Conservation Area | CA5 | https://www.rochdale.gov.uk/downloads/download/191/list-of-conservation-areas-maps-and-appraisals#Clegg Village | https://www.rochdale.gov.uk/downloads/file/483/clegg-village-1977-conservation-area-map | area-map | Wed Nov 23 1977 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Nov 23 1977 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Nov 23 1977 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| CA6 | Littleborough Town Centre Conservation Area | CA6 | https://www.rochdale.gov.uk/downloads/download/191/list-of-conservation-areas-maps-and-appraisals#Littleborough Town Centre | https://www.rochdale.gov.uk/downloads/file/486/littleborough-town-centre-1977-extended-2011-conservation-area-map | area-map | Fri Mar 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Mar 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | Fri Mar 18 2011 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| CA7 | Toad Lane Conservation Area | CA7 | https://www.rochdale.gov.uk/downloads/download/191/list-of-conservation-areas-maps-and-appraisals#Toad Lane | https://www.rochdale.gov.uk/downloads/file/501/toad-lane-rochdale-1977-conservation-area-map | area-map | Wed Nov 23 1977 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Nov 23 1977 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Nov 23 1977 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| CA8 | Rakewood Conservation Area | CA8 | https://www.rochdale.gov.uk/downloads/download/191/list-of-conservation-areas-maps-and-appraisals#Rakewood | https://www.rochdale.gov.uk/downloads/file/494/rakewood-1982-conservation-area-map | area-map | Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| CA9 | Hollingworth Fold Conservation Area | CA9 | https://www.rochdale.gov.uk/downloads/download/191/list-of-conservation-areas-maps-and-appraisals#Hollwingworth Fold | https://www.rochdale.gov.uk/downloads/file/485/hollingworth-fold-1982-conservation-area-map | area-map | Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time) | |
| CA10 | Whittaker Conservation Area | CA10 | https://www.rochdale.gov.uk/downloads/download/191/list-of-conservation-areas-maps-and-appraisals#Whittaker | https://www.rochdale.gov.uk/downloads/file/505/whittaker-hollingworth-lake-1982-conservation-area-map | area-map | Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time) | Wed Mar 31 1982 00:00:00 GMT+0000 (Coordinated Universal Time) |
CREATE TABLE table_2 (
"reference" VARCHAR,
"name" VARCHAR,
"conservation_area" VARCHAR,
"documentation_url" VARCHAR,
"document_url" VARCHAR,
"n__document_type" VARCHAR,
"start_date" TIMESTAMP,
"designation_date" TIMESTAMP,
"end_date" VARCHAR,
"entry_date" TIMESTAMP
);