names

28 rows where place_id = 594141

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3614720 1872251 1872251 defendant Baron John husbandman 594141 594141 Baron, John, of North Cadbury, husbandman 1
3636190 1906107 1906107 defendant Turnepeny John husbandman 594141 594141 Turnepeny, John, of North Cadbury, husbandman 0
3799249 1957678 1957678 defendant Clothyer John husbandman 594141 594141 Clothyer, John, of North Cadbury, husbandman 1
3813111 1962011 1962011 defendant Clothyer John husbandman 594141 594141 Clothyer, John, of North Cadbury, husbandman 0
3894228 1988288 1988288 defendant Chessocke John husbandman 594141 594141 Chessocke, John, of North Cadbury, husbandman 0
3894229 1988288 1988288 defendant Petman John husbandman 594141 594141 Petman, John, of North Cadbury, husbandman 1
3993893 2022566 2022566 defendant Jacob Valentine husbandman 594141 594141 Jacob, Valentine, of North Cadbury, husbandman 0
4200594 2095768 2095768 defendant Pyrry Richard, senior husbandman 594141 594141 Pyrry, Richard, senior, of North Cadbury, husbandman 3
4385352 2159791 2159791 defendant Hodges Nicholas tailor 594141 594141 Hodges, Nicholas, of North Cadbury, tailor 2
4620390 2237357 2237357 defendant Poule John fuller 594141 594141 Poule, John, of North Cadbury, fuller 0
4648042 2245492 2245492 defendant Grene John   594141 594141 Grene, John, of North Cadbury 0
4660964 2249253 2249253 defendant Joce Stephen husbandman 594141 594141 Joce, Stephen, of North Cadbury, husbandman 0
4767570 2285837 2285837 defendant Mancome Richard clerk 594141 594141 Mancome, Richard, of North Cadbury, clerk 0
4799374 2295982 2295982 defendant Luffyn Thomas clerk 594141 594141 (Luffyn, Thomas, of North Cadbury, clerk 1
4799375 2295982 2295982 defendant Golde John husbandman 594141 594141 Golde, John, of North Cadbury, husbandman 2
5010191 2359845 2359845 defendant Wyche Richard clerk 594141 594141 Wyche, Richard, of North Cadbury, clerk 0
5139302 2397984 2397984 defendant Byrdo John, senior husbandman 594141 594141 Byrdo, John, senior, of North Cadbury, husbandman 4
5215132 2420148 2420148 defendant Dyrdo John yeoman 594141 594141 Dyrdo, John, of North Cadbury, yeoman 2
5216966 2420703 2420703 defendant Nicholas John husbandman 594141 594141 Nicholas, John, of North Cadbury, husbandman 1
5263408 2434302 2434302 defendant Pitman John husbandman 594141 594141 Pitman, John, of North Cadbury, husbandman 0
5280126 2439260 2439260 defendant Deryde John yeoman 594141 594141 Deryde, John, of North Cadbury, yeoman 0
5372577 2467022 2467022 defendant Lavy or Lany John husbandman 594141 594141 Lavy or Lany, John, of North Cadbury, husbandman 1
5409016 2477659 2477659 defendant Cosyn Thomas husbandman 594141 594141 Cosyn, Thomas, of North Cadbury, husbandman 0
5466590 2494948 2494948 defendant Cosyn Thomas husbandman 594141 594141 Cosyn, Thomas, of North Cadbury, husbandman 0
5484012 2500155 2500155 defendant Lany John yeoman 594141 594141 Lany, John, of North Cadbury, yeoman 0
5504612 2506363 2506363 defendant Cosyn Thomas husbandman 594141 594141 Cosyn, Thomas, of North Cadbury, husbandman 0
5519760 2511016 2511016 defendant Harte Nicholas laborer 594141 594141 Harte, Nicholas, of North Cadbury, laborer 0
5626621 2552300 2552300 defendant Joys Stephen   594141 594141 Joys, Stephen, of North Cadbury, Soms, styward 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);