names

39 rows where place_id = 606998

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3667265 1915698 1915698 defendant Payne John smith 606998 606998 Payne, John, of East Peckham, smith 0
3910792 1993930 1993930 defendant Taillor Peter husbandman 606998 606998 Taillor, Peter, of Est Peckham, husbandman 0
4030513 2035569 2035569 defendant Darell Henry gent 606998 606998 Darell, Henry, of Est Peckham, or of Grays Inn, Middx, gent 1
4119657 2067317 2067317 defendant Barton Henry yeoman 606998 606998 Barton, Henry, of Est Peckham, yeoman 0
4131946 2071738 2071738 defendant Buck Richard husbandman 606998 606998 Buck, Richard, of Est Peckham, husbandman 0
4138092 2073989 2073989 defendant Butler John yeoman 606998 606998 Butler, John, of Est Peckham, yeoman 0
4142716 2075622 2075622 defendant Barton Henry yeoman 606998 606998 Barton, Henry, of Est Peckham, yeoman 0
4155744 2080092 2080092 defendant Duck Richard husbandman 606998 606998 Duck, Richard, of Est Peckham, husbandman 0
4155746 2080093 2080093 defendant Stanford Stephen yeoman 606998 606998 Stanford, Stephen, of Est Peckham, yeoman 0
4219246 2102225 2102225 defendant Lorkyn George husbandman 606998 606998 Lorkyn, George, of East Peckham, husbandman 0
4219247 2102225 2102225 defendant Lorkyn William yeoman 606998 606998 Lorkyn, William, of East Peckham, yeoman 1
4226302 2104671 2104671 defendant Brooke William tanner 606998 606998 Brooke, William, of Est Peckham, tanner 1
4243314 2110753 2110753 defendant Brooke William tanner 606998 606998 Brooke, William, of Est Peckham, tanner 1
4321059 2137462 2137462 defendant Baker William husbandman 606998 606998 Baker, William, of Est Peckham, husbandman 0
4322850 2138060 2138060 defendant Ducke George yeoman 606998 606998 Ducke, George, of Est Peckham, yeoman 1
4341611 2144342 2144342 defendant Cotton John carpenter 606998 606998 Cotton, John, of Est Peckham, carpenter 0
4341615 2144344 2144344 defendant Cotton John carpenter 606998 606998 Cotton, John, of East Peckham, carpenter 0
4361165 2151156 2151156 defendant Ducke Thomas yeoman 606998 606998 Ducke, Thomas, of East Peckham, yeoman 0
4361166 2151156 2151156 defendant Lorkyn Stephen huabandman 606998 606998 Lorkyn, Stephen, of East Peckham, huabandman 1
4361167 2151156 2151156 defendant Ongley John yeoman 606998 606998 Ongley, John, of East Peckham, yeoman 2
4361714 2151346 2151346 defendant Beechfild Nicholas husbandman 606998 606998 Beechfild, Nicholas, of East Peckham, husbandman 0
4365277 2152643 2152643 defendant Burgis John yeoman 606998 606998 Burgis, John, of East Peckham, yeoman 0
4386812 2160257 2160257 defendant Ongley John yeoman 606998 606998 Ongley, John, of East Peckham, yeoman 2
4386813 2160257 2160257 defendant Cotton John carpenter 606998 606998 Cotton, John, of East Peckham, carpenter 3
4391550 2161786 2161786 defendant Pattenden George yeoman 606998 606998 Pattenden, George, of East Peckham, yeoman 0
4391551 2161786 2161786 defendant Burgys John husbandman 606998 606998 Burgys, John, of East Peckham, husbandman 1
4402479 2165414 2165414 defendant Davies Henry yeoman 606998 606998 Davies, Henry, of Est Peckham, yeoman 0
4406029 2166584 2166584 defendant Parson Richard yeoman 606998 606998 Parson, Richard, of East Peckham, yeoman 0
4841279 2308811 2308811 defendant Wyke Thomas husbandman 606998 606998 Wyke, Thomas, of East Peckham, husbandman 0
5157927 2403441 2403441 defendant Messenger Thomas yeoman 606998 606998 Messenger, Thomas, of East Peckham, yeoman 0
5173683 2407997 2407997 defendant Messenger Thomas   606998 606998 Messenger, Thomas, of East Peckham 0
5176344 2408770 2408770 defendant Erkebold Richard husbandman 606998 606998 Erkebold, Richard, of East Peckham, husbandman 0
5191471 2413245 2413245 defendant Messenger Thomas husbandman 606998 606998 Messenger, Thomas, of East Peckham, husbandman 0
5198363 2415272 2415272 defendant Erkebold Richard husbandman 606998 606998 Erkebold, Richard, of East Peckham, husbandman 0
5198364 2415272 2415272 defendant atte Wode William husbandman 606998 606998 atte Wode, William, of East Peckham, husbandman 1
5207350 2417891 2417891 defendant Messanger Thomas husbandman 606998 606998 Messanger, Thomas, of East Peckham, husbandman 0
5385565 2470941 2470941 defendant Godyng William husbandman 606998 606998 Godyng, William, of East Peckham, husbandman 1
5403172 2475991 2475991 defendant Renkyn or Reukyn John tanner 606998 606998 Renkyn or Reukyn, John, of East Peckham, tanner 0
5416188 2479772 2479772 defendant Renkyn John tanner 606998 606998 Renkyn, John, of East Peckham, tanner 0

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE names (
    id INTEGER PRIMARY KEY AUTOINCREMENT,
    case_id INTEGER NOT NULL REFERENCES cases(id) ON DELETE CASCADE,
    role TEXT NOT NULL CHECK (role IN ('plaintiff', 'defendant')),
    surname TEXT NOT NULL,
    forename TEXT,
    occupation TEXT,
    place_id INTEGER REFERENCES places(id),
    raw_segment TEXT NOT NULL,
    seq INTEGER NOT NULL DEFAULT 0
);
CREATE INDEX idx_names_case_id ON names(case_id);
CREATE INDEX idx_names_surname ON names(surname);
CREATE INDEX idx_names_place_id ON names(place_id);
CREATE INDEX idx_names_role_surname ON names(role, surname);