names

11 rows where place_id = 599025

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634907 1905718 1905718 defendant Bowman Richard yeoman 599025 599025 Bowman, Richard, of South Hanyngfeld, yeoman 0
3634914 1905721 1905721 defendant Bowman Richard yeoman 599025 599025 Bowman, Richard, of South Hanyngfeld, yeoman 0
3713969 1930667 1930667 defendant Foster Ivon sawyer 599025 599025 Foster, Ivon, of South Hanyngfeld, sawyer 2
3843566 1971525 1971525 defendant Bowman Richard yeoman 599025 599025 Bowman, Richard, of South Hanyngfeld, yeoman 0
4248046 2112330 2112330 defendant Paschall John gent 599025 599025 Paschall, John, of South Hanyngfeld, gent 0
4498858 2200278 2200278 plaintiff Giffard John (legal representative) 599025 599025 Giffard, John, of South Hanyngfeld, executors of 0
4747473 2279765 2279765 defendant Wyse Richard yeoman 599025 599025 Wyse, Richard, of South Hanyngfeld, yeoman 0
5227965 2423790 2423790 defendant Frebarne William yeoman 599025 599025 Frebarne, William, of South Hanyngfeld, yeoman 3
5356168 2462006 2462006 defendant Shalford William drover 599025 599025 Shalford, William, of South Hanyngfeld, drover 0
5420347 2481009 2481009 defendant Boudok William yeoman 599025 599025 Boudok, William, of South Hanyngfeld, yeoman 1
5450321 2489981 2489981 plaintiff Ponde William   599025 599025 Ponde, William, of South Hanyngfeld 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);