Sussex Online Parish Clerks (OPC) home page

Saltdean, (East Sussex)

OPC for Saltdean is : Nobody yet! Why don't you volunteer?

Email: Nobody yet! Why don't you volunteer?.

Formerly open, uninhabited farmland belonging to the village of Rottingdean, Saltdean was developed following a sell off of the land for development in the 1920s. Some of this was promoted by Charles W. Neville, who also masterminded development at nearby Peacehaven. It has a mainly shingle beach, fronted by a promenade, the Undercliff Walk, which can be reached by steps from the clifftop. Saltdean is now a prosperous village suburb of the city of Brighton and Hove, though its eastern fringe is administratively part of the neighbouring Lewes District Council.

SELECT COUNT(*) AS NumRows FROM postcard AS A INNER JOIN person AS D ON A.FKContributorId=D.PKPersonId INNER JOIN postcardpublisher AS E ON A.FKPostcardPublisherId=E.PKPostcardPublisherId INNER JOIN postcardseries AS F ON A.FKPostcardSeriesId=F.PKPostcardSeriesId INNER JOIN postcardtype AS G ON A.FKPostcardTypeId=G.PKPostcardTypeId INNER JOIN postcardset AS H ON A.FKPostcardSetId=H.PKPostcardSetId INNER JOIN county AS I ON A.FKCountyId=I.PKCountyId LEFT JOIN viewcount AS C ON C.ItemPK=A.PKPostcardId AND C.FKBatchTableID=14 WHERE A.PKPostcardId = 8321

The buildings nearest the coastline are architecturally varied, and include some influenced by international trends of the inter-war years, e.g. Bauhaus and Cubism, and there are some which are Spanish-influenced. The most famous building is the Lido or swimming-pool, whose architect was R.W.H. Jones, and the former Ocean Hotel, based on the appearance of mid-20th century ocean liners, is also noteworthy.

SELECT PKParishId, ParishName FROM parish WHERE SubParish=1303 ORDER BY ParishName

SELECT ParishName FROM parish WHERE PKParishId='449'

Ancient parish:

Saltdean was created from the parish of .

Places of worship:

Church details, together with baptism, marriage, monumental inscription & burial records can be accessed by clicking on the church name.

SELECT * FROM fielddef WHERE TableName='church' ORDER BY FieldDefsOrder ASC

SELECT PKCountyId FROM county WHERE CountyABR='SSX'

SELECT COUNT(*) AS NumRows FROM church AS A WHERE A.FKParishId = '1303'

SELECT * FROM fielddef WHERE TableName='parishlink' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '1303' AND A.FKLinkCategoryId = '2'

Census returns:

SELECT * FROM fielddef WHERE TableName='censusreturn' ORDER BY FieldDefsOrder ASC

SELECT FKCensusYearId, CensusYear, count(*) AS Number FROM censusreturn, censusyear WHERE FKParishId = 1303 AND PKCensusYearId = FKCensusYearId GROUP BY FKCensusYearId

The OPC Database has no census returns for people residing in this parish yet.

SELECT FKBirthParishId, FKCensusYearId, CensusYear, count(*) AS Number FROM censusreturn, censusyear WHERE FKBirthParishId = 1303 AND PKCensusYearId = FKCensusYearId AND FKParishId != 1303 GROUP BY FKCensusYearId

SELECT * FROM fielddef WHERE TableName='parishlink' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '1303' AND A.FKLinkCategoryId = '5'

Maps:

Grid reference: 538301, 102477 ~ View on: Google Maps, Open Street Map, Streetmap, National Library of Scotland Map or Oldmaps.

SELECT * FROM fielddef WHERE TableName='parishlink' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '1303' AND A.FKLinkCategoryId = '9'

SELECT * FROM fielddef WHERE TableName='parishlink' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '1303' AND A.FKLinkCategoryId = '8'

SELECT * FROM fielddef WHERE TableName='parishlink' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '1303' AND A.FKLinkCategoryId = '20'

Poll Registers:

SELECT * FROM fielddef WHERE TableName='pollregister' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM pollregister AS A WHERE A.FKParishId = '1303'

The OPC database contains no poll register entries for people entitled to vote in this parish.

SELECT * FROM fielddef WHERE TableName='parishlink' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '1303' AND A.FKLinkCategoryId = '29'

1641 Protestation Returns:

SELECT * FROM fielddef WHERE TableName='protestationparish' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM protestationparish AS A WHERE A.FKParishId = '1303'

There are no protestation returns for this parish in the OPC database.

Gazettes:

SELECT * FROM fielddef WHERE TableName='gazette' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM gazette AS A WHERE A.FKParishId = '1303'

The OPC database contains no entries for people mentioned in Gazzetes associated with this parish.

Photographs:

SELECT * FROM fielddef WHERE TableName='postcardparish' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM postcardparish AS A WHERE A.FKParishId = '1303'

There are no images depicting this parish in the OPC database. If you have one, please contribute a scan!

Postal directories:

SELECT * FROM fielddef WHERE TableName='directoryentry' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM directoryentry AS A WHERE A.FKParishId = '1303'

The OPC database contains no postal directory entries for this parish.

SELECT PostalDirectoryName, PostalDirectoryYear, count(*) AS Number FROM directoryentry, directorysection, postaldirectory WHERE PKPostalDirectoryId = FKPostalDirectoryId AND FKParishId = 1303 AND FKDirectorySectionId = PKDirectorySectionId GROUP BY PostalDirectoryYear

SELECT * FROM fielddef WHERE TableName='directorysectionparish' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM directorysectionparish AS A WHERE A.FKParishId = '1303'

SELECT * FROM fielddef WHERE TableName='parishlink' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '1303' AND A.FKLinkCategoryId = '7'

Publications:

SELECT * FROM fielddef WHERE TableName='bookparish' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM bookparish AS A WHERE A.FKParishId = '1303'

There are no books about this parish in the Sussex OPC Bibliography.

SELECT * FROM fielddef WHERE TableName='sacparish' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM sacparish AS A WHERE A.FKParishId = '1303'

There are no articles about this parish in the OPC Sussex Archeaological Collections Index.

SELECT * FROM fielddef WHERE TableName='sasmember' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM sasmember AS A WHERE A.FKParishId = '1303'

There are no people from this parish in the OPC Sussex Archeaological Society Members Index.

Wills:

SELECT * FROM fielddef WHERE TableName='will' ORDER BY FieldDefsOrder ASC

SELECT * FROM fielddef WHERE TableName='batchtable' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM batchtable AS A WHERE A.BatchTableTable = 'will'
Error - getBatchTableId() - no data loaded
SELECT COUNT(*) AS NumRows FROM will AS A LEFT JOIN viewcount AS C ON C.ItemPK=A. AND C.FKBatchTableID= WHERE A.FKParishId = '1303'

The OPC database contains no wills of people who lived in this parish.

SELECT * FROM fielddef WHERE TableName='willsecondaryparish' ORDER BY FieldDefsOrder ASC

SELECT COUNT(*) AS NumRows FROM willsecondaryparish AS A WHERE A.FKParishId = '1303'

The OPC database contains no wills that mention this parish.

Interest in this parish:

No registered users have badged this parish yet. To share your interest with others, why not register as a frequent user of this site?

Please contact the OPC co-ordinator if you have information or links you would like to contribute.

Remember that OPCs are volunteers and are unlikely to have information not listed on this page.

Please be courteous and patient - they, like you, have busy lives and will try and respond as quickly as they can.

The advertisements below are served by Google; the very small revenue generated when people click on them sometimes covers the cost of hosting the Sussex OPC website.

Online Parish Clerks

for the English counties of East and West Sussex