names

16 rows where place_id = 596106

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3623155 1874764 1874764 defendant Nowers Edmund gent 596106 596106 Nowers, Edmund, of Takley, gent 0
3626321 1903090 1903090 defendant Hall Thomas husbandman 596106 596106 Hall, Thomas, of Takley, husbandman 0
3682621 1920671 1920671 defendant Fryday John yeoman 596106 596106 Fryday, John, of Takley, yeoman 0
4965887 2346728 2346728 defendant Megere Richard husbandman 596106 596106 Megere, Richard, of Takley, husbandman 0
5076363 2379432 2379432 defendant Nowers John esq 596106 596106 Nowers, John, of Takley, esq 0
5127235 2394443 2394443 defendant Nowers John esq 596106 596106 Nowers, John, of Takley, esq 0
5220958 2421827 2421827 defendant Meger Richard husbandman 596106 596106 Meger, Richard, of Takley, husbandman 0
5251950 2430713 2430713 defendant Dicar John carpenter 596106 596106 Dicar, John, of Takley, carpenter 0
5347451 2459366 2459366 defendant Repynghale Robert husbandman 596106 596106 Repynghale, Robert, of Takley, husbandman 0
5351188 2460469 2460469 defendant Eynesham John husbandman 596106 596106 Eynesham, John, of Takley, husbandman 2
5357812 2462514 2462514 defendant Repynghale Robert husbandman 596106 596106 Repynghale, Robert, of Takley, husbandman 0
5367176 2465382 2465382 defendant Nowers John esq 596106 596106 Nowers, John, of Takley, esq 0
5413687 2479017 2479017 defendant Ludbroke John husbandman 596106 596106 Ludbroke, John, of Takley, husbandman 0
5460302 2493018 2493018 defendant Coorte William clerk & rector 596106 596106 Coorte, William, of Takley, clerk & rector 0
5471920 2496556 2496556 defendant Coorte William clerk & rector 596106 596106 Coorte, William, of Takley, clerk & rector 0
5471923 2496557 2496557 defendant Coorte William clerk & rector 596106 596106 Coorte, William, of Takley, clerk & rector 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);