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

SELECT PKCountyId FROM county WHERE CountyABR='SSX'

SELECT COUNT(*) AS NumRows FROM parish AS A WHERE A. = 355

, ()


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

SELECT COUNT(*) AS NumRows FROM person AS A

SELECT PersonFirstName FROM person WHERE PKPersonId=''

SELECT PersonSurname FROM person WHERE PKPersonId=''

OPC for is :

Email: No email address available.


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

SELECT COUNT(*) AS NumRows FROM parishphoto AS A

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

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

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

SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '355' 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 = 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 = AND PKCensusYearId = FKCensusYearId AND FKParishId != GROUP BY FKCensusYearId

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

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

Maps:

Grid reference currently unknown.


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

SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '355' 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 = '355' 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 = '355' AND A.FKLinkCategoryId = '20'

Poll Registers:


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

SELECT COUNT(*) AS NumRows FROM pollregister AS A

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 = '355' 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

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

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


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

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

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

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

Photographs:


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

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

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


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

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

Postal directories:


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

SELECT COUNT(*) AS NumRows FROM directoryentry AS A

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 = AND FKDirectorySectionId = PKDirectorySectionId GROUP BY PostalDirectoryYear

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

SELECT COUNT(*) AS NumRows FROM directorysectionparish AS A

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

SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '355' 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 = '355'

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 = '355'

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 = '355'

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


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

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

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

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

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=

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

The OPC database contains no wills that mention this parish.


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

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

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

SELECT COUNT(*) AS NumRows FROM badge AS A WHERE A.BadgeTable = 'parish' AND A.BadgeKey = '355'

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.