Open Plaques In Trafford

Trafford Council

@ukgov.blue_plaques_in_trafford

Table List

1 table(22.29 KB)

Open Plaques In Trafford

@ukgov.blue_plaques_in_trafford.open_plaques_in_trafford

22.29 KB
37 rows
16 columns

id Id	title Title	inscription Inscription	erected Erected	number_of_subjects Number Of Subjects	lead_subject_name Lead Subject Name	lead_subject_born_in Lead Subject Born In	lead_subject_died_in Lead Subject Died In	lead_subject_type Lead Subject Type	lead_subject_wikipedia Lead Subject Wikipedia	main_photo Main Photo	address Address	area_name Area Name	area_code Area Code	long Long	lat Lat
1975	Chapel Street Altrincham blue plaque	Chapel Street Altrincham. From just 60 houses 161 men volunteered in the Great War 1914-18. 29 were killed. Recognised and praised by King George V.	NA	1	Chapel Street Altrincham	NA	NA	place	NA	https://farm4.staticflickr.com/3718/9453533702_fb7ef6b276_z.jpg	Chapel Street	Trafford	E08000009	-2.35239	53.38587999999999
33101	Helen Allingham blue plaque	Helen M. E. Allingham 1848-1926 watercolour artist. Her family lived in the area 1849-1862. She married Irish poet W. Allingham 1874. Elected first woman member Royal Watercolour Society 1875	1991	1	Helen Allingham	1848	1926	woman	https://en.wikipedia.org/wiki/Helen_Allingham	https://farm5.staticflickr.com/4415/36149946140_8165a6f853_z.jpg	16 Market Street	Trafford	E08000009	-2.35138	53.38829
33102	Ronald Gow and Wendy Hiller blue plaque	Ronald Gow dramatist lived here 1898-1910 pupil & master at Altrincham County High School For Boys. 1937, married actress Dame Wendy Hiller	NA	2	Ronald Gow	1897	1993	man	https://en.wikipedia.org/wiki/Ronald_Gow	https://farm5.staticflickr.com/4358/36500810526_1af933963e_z.jpg	Barclays Bank, 63 Stamford New Road	Trafford	E08000009	-2.35111	53.38540999999999
33103	Russell Newberry & Co. Ltd, Frederick Russell, and William Newberry white plaque	The Altrincham works of Russell Newberry & Co. Ltd occupied this site 1909-1949. Founded by Frederick Russell & William Newberry pioneer designers, manufacturers and patentees of innovative and proficient generator sets and marine diesel engines	2003	3	Russell Newberry & Co. Ltd	NA	NA	group	NA	NA	Travis Perkins	Trafford	E08000009	-2.34511	53.3859
33104	George Massey blue plaque	Near this site George Massey, proprietor, manufactured gas for the first time in Altrincham to illuminate the Unicorn Hotel 1844	1991	1	George Massey	NA	NA	man	NA	https://farm5.staticflickr.com/4414/36408513261_dca2e3e577_z.jpg	Old Market Place	Trafford	E08000009	-2.35043	53.38919
39404	Market, Altrincham and George Grey blue plaque	Renovated in 1990 as part of Altrincham Charter celebrations, the Market has been held on this site since the Earl of Stamford gave the land to the town in 1879. Prior to this the market had been held since the thirteenth century at the old market place in front of the Unicorn	NA	2	Market, Altrincham	NA	NA	place	NA	https://farm5.staticflickr.com/4363/36409599801_5e36331016_z.jpg	Market Street	Trafford	E08000009	-2.35215	53.38746999999999
39405	Culcheth Hall School blue plaque	Culcheth Hall School 1891-2011 Founded by the Lang sisters for the promotion of girls' education Suspiciens ut bellis	NA	1	Culcheth Hall School	1891	2011	place	NA	https://farm9.staticflickr.com/8826/17082237107_a5cdaa71f6_z.jpg	Ashley Road	Trafford	E08000009	-2.3527300000000007	53.38123
39406	Basil Morrison blue plaque	Basil Morrison 1915-2012 Historian Artist	NA	1	Basil Morrison	1915	2012	man	NA	https://farm5.staticflickr.com/4442/36546004345_505f55f2af_z.jpg	Lloyd Street	Trafford	E08000009	-2.3517600000000005	53.38437
40644	Ronald Gow film cell plaque	Ronald Gow / Altrincham Grammar	1996	1	Ronald Gow	1897	1993	man	https://en.wikipedia.org/wiki/Ronald_Gow	NA	Altrincham Grammar School For Boys, Marlborough Rd	Trafford	E08000009	-2.35123	53.37651
43667	Frank P Sargeant black plaque	This replica of Altrincham's historic Market Cross was dedicated by the Right Reverend Frank P. Sargeant, Bishop of Stockport, in the presence of The Worshipful the Mayor of Trafford, Councillor James R. Haydock, J.P., on the seventh day of October, Nineteen Hundred and Ninety, in the Seven Hundredt…	NA	1	Frank P Sargeant	NA	NA	man	NA	https://farm5.staticflickr.com/4361/36500273326_4925339b3d_z.jpg	Old Market Place	Trafford	E08000009	-2.350480000000001	53.38896


CREATE TABLE open_plaques_in_trafford (
  "id" BIGINT,
  "title" VARCHAR,
  "inscription" VARCHAR,
  "erected" VARCHAR,
  "number_of_subjects" BIGINT,
  "lead_subject_name" VARCHAR,
  "lead_subject_born_in" VARCHAR,
  "lead_subject_died_in" VARCHAR,
  "lead_subject_type" VARCHAR,
  "lead_subject_wikipedia" VARCHAR,
  "main_photo" VARCHAR,
  "address" VARCHAR,
  "area_name" VARCHAR,
  "area_code" VARCHAR,
  "long" DOUBLE,
  "lat" DOUBLE
);