names

25 rows where place_id = 615514

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3644370 1908657 1908657 defendant Richardys John (legal representative) 615514 615514 Richardys, John, of Bodnam, mercer, executrix of 0
3709294 1929204 1929204 defendant Newton Richard yeoman 615514 615514 Newton, Richard, of Bodnam, yeoman 0
3709295 1929204 1929204 defendant Newton Morgan yeoman 615514 615514 Newton, Morgan, of Bodnam, yeoman 1
3927241 1999447 1999447 defendant Taylour William yeoman 615514 615514 Taylour, William, of Bodnam, yeoman 1
3983019 2018704 2018704 plaintiff Slade John husbandman 615514 615514 Slade, John, of Bodnam, husbandman 0
3983025 2018707 2018707 plaintiff Slade William   615514 615514 Slade, William, of Bodnam 0
4060557 2046177 2046177 defendant Ball John   615514 615514 Ball, John, of Bodnam, husbandman, "his son of the same" 0
4060559 2046178 2046178 defendant Ball John, senior yeoman 615514 615514 Ball, John, senior, of Bodnam, yeoman 0
4158914 2081186 2081186 defendant Auncell Thomas husbandman 615514 615514 Auncell, Thomas, of Bodnam, husbandman 0
4207805 2098289 2098289 defendant Grene William chapman 615514 615514 Grene, William, of Bodnam, chapman 2
4207806 2098289 2098289 defendant Greme Helen spinster 615514 615514 Greme, Helen, of Bodnam, spinster 3
4214248 2100501 2100501 defendant Sheriffe John yeoman 615514 615514 Sheriffe, John, of Bodnam, or of Marshe Maunde, yeoman 0
4225343 2104331 2104331 defendant Wynton John yeoman 615514 615514 Wynton, John, of Bodnam, yeoman 0
4225345 2104332 2104332 defendant Wotton Richard yeoman 615514 615514 Wotton, Richard, of Bodnam, yeoman 0
4231943 2106672 2106672 defendant Sheriffe John yeoman 615514 615514 Sheriffe, John, of Bodnam, or of Marshe Maunde, yeoman 0
4240800 2109905 2109905 defendant Sheriffe John yeoman 615514 615514 Sheriffe, John, of Bodnam, or of Marshe Maunde, yeoman 0
4265511 2118102 2118102 defendant Hill Roger   615514 615514 Hill, Roger, of Bodnam, Herefs yeoman 2
4315301 2135463 2135463 defendant Hill Roger yeoman 615514 615514 Hill, Roger, of Bodnam, yeoman 0
4331914 2140969 2140969 defendant Ball John, junior husbandman 615514 615514 Ball, John, junior, of Bodnam, husbandman 0
4331915 2140969 2140969 defendant Hill Roger husbandman 615514 615514 Hill, Roger, of Bodnam, husbandman 1
4399757 2164506 2164506 defendant Richardes Henry weaver 615514 615514 Richardes, Henry, of Bodnam , weaver 0
5389150 2471948 2471948 defendant Cheser John husbandman 615514 615514 Cheser, John, of Bodnam, husbandman 2
5389168 2471951 2471951 defendant Aylemon Richard yeoman 615514 615514 Aylemon, Richard, of Bodnam, yeoman 0
5521458 2511529 2511529 defendant Sewarde Richard husbandman 615514 615514 Sewarde, Richard, of Bodnam, husbandman 0
5580689 2529041 2529041 defendant Franke Lewis yeoman 615514 615514 Franke, Lewis, of Bodnam, yeoman 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);