Bodiam, (East Sussex)
Bodiam is the location of perhaps one of the most famous castles in England. It looks exactly like a castle should - round towers on the corners and square ones midway along each side. It is surrounded by a moat. It was built in 1385 as comfortable home and with considerable defences. The exterior is virtually complete, although the interior has been largely destroyed. It was the home of the Dalyngrigge family and the centre of the manor of Bodiam.
Although much of the interior has been destroyed, there is enough remaining to visualise how it must once have been. This view is of the inside of one of the corner towers - notice the fireplaces still in the walls. The castle's survival is thanks to John Fuller, who purchased in 1829 and put an end to the quarrying of stone from the ruins.
The north side of the castle contains the gatehouse, which still has the original wooden portcullis. There was once a barbican between the Octagon (an island in the moat) and the main gatehouse, of which only a fragment of the west wall remains.
Places of worship:
Church details, together with baptism, marriage, monumental inscription & burial records can be accessed by clicking on the church name.
SELECT COUNT(*) AS NumRows FROM church AS A INNER JOIN parish AS D ON A.FKParishId=D.PKParishId INNER JOIN denomination AS E ON A.FKDenomId=E.PKDenomId INNER JOIN churchuse AS F ON A.FKChurchUseId=F.PKChurchUseId WHERE A.FKParishId = '176' AND ((D.FKCountyId=1)
OR (D.FKCountyId=2))
SELECT * FROM fielddef WHERE TableName='parishlink' ORDER BY FieldDefsOrder ASC
SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '176' 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 = 176 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 = 176 AND PKCensusYearId = FKCensusYearId AND FKParishId != 176 GROUP BY FKCensusYearId
SELECT * FROM fielddef WHERE TableName='parishlink' ORDER BY FieldDefsOrder ASC
SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '176' AND A.FKLinkCategoryId = '5'
Maps:
Grid reference: 578026, 126006 ~ 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 = '176' 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 = '176' 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 = '176' 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 = '176'
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 = '176' 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 = '176'
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 = '176'
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 = '176' 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 = '176' 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 = '176'
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 = '176'
SELECT * FROM fielddef WHERE TableName='parishlink' ORDER BY FieldDefsOrder ASC
SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '176' 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 = '176'
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 = 176 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 = '176'
SELECT * FROM fielddef WHERE TableName='parishlink' ORDER BY FieldDefsOrder ASC
SELECT COUNT(*) AS NumRows FROM parishlink AS A WHERE A.FKParishId = '176' 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 = '176'
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 = '176'
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 = '176'
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 = '176' 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 = '176' 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 = '176'
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 = '176'
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 = '176' 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 = '176'
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.