Lower Beeding, (West Sussex)

Places of worship:

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

Holy Trinity

St John the Evangelist, Coolhurst

Census returns:


SELECT FKCensusYearId, CensusYear, count(*) AS Number FROM censusreturn, censusyear WHERE FKParishId = 345 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 = 345 AND PKCensusYearId = FKCensusYearId AND FKParishId != 345 GROUP BY FKCensusYearId

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

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

Maps:

Grid reference: 522500, 127500 ~ 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 = '345' 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 = '345' 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 = '345' 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 = '345'

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

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

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

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


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

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

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

Postal directories:


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

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

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

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

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

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

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

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 = '345' 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 = '345' 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= WHERE A.FKParishId = '345'

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

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

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.