names

16 rows where place_id = 601265

✎ 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
3644538 1908709 1908709 defendant Bedyngfeld Philip gent 601265 601265 Bedyngfeld, Philip, of Herstmonceux, Sussex, gent 0
3644542 1908711 1908711 defendant Germyn John gent 601265 601265 Germyn, John, of Herstmonceux, Sussex, gent 0
3658583 1912935 1912935 defendant Germyn John gent 601265 601265 Germyn, John, of Herstmonceux, Sussex, gent 0
4724577 2272984 2272984 defendant Fyenles Roger   601265 601265 Fyenles, Roger, of Herstmonceux, Sussex, knight 0
4724579 2272985 2272985 defendant Fyenles Roger   601265 601265 Fyenles, Roger, of Herstmonceux, Sussex, knight 0
4724582 2272986 2272986 defendant Fyenles Roger   601265 601265 Fyenles, Roger, of Herstmonceux, Sussex, knight 0
4724585 2272987 2272987 defendant Fyenles Roger   601265 601265 Fyenles, Roger, of Herstmonceux, Sussex, knight 0
4779800 2289677 2289677 defendant Fenes Roger   601265 601265 Fenes, Roger, of Herstmonceux, Sussex, knight 0
4801393 2296623 2296623 defendant atte Bergh Thomas gent 601265 601265 atte Bergh, Thomas, of Herstmonceux, Sussex, gent 1
4801411 2296625 2296625 defendant atte Bergh Thomas gent 601265 601265 atte Bergh, Thomas, of Herstmonceux, Sussex, gent 1
4901799 2327168 2327168 defendant atte Berghe Thomas gent 601265 601265 atte Berghe, Thomas, of Herstmonceux, Sussex, gent 0
4905935 2328460 2328460 defendant Peece John husbandman 601265 601265 Peece, John, of Herstmonceux, Sussex, husbandman 1
5137323 2397428 2397428 defendant Tracy William clerk 601265 601265 Tracy, William, of Herstmonceux, Sussex, clerk 0
5157958 2403450 2403450 defendant Tracy William clerk 601265 601265 Tracy, William, of Herstmonceux, Sussex, clerk 0
5157960 2403451 2403451 defendant Tracy William clerk 601265 601265 Tracy, William, of Herstmonceux, Sussex, clerk 0
5173701 2408003 2408003 defendant Tracy William clerk 601265 601265 Tracy, William, of Herstmonceux, Sussex, clerk 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);