names

9 rows where place_id = 782987

✎ 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
4680100 2259386 2259386 defendant Everard John husbandman 782987 782987 Everard, John, of Honton, husbandman 3
4680101 2259386 2259386 defendant Frankyssh John husbandman 782987 782987 Frankyssh, John, of Honton, husbandman 4
4798465 2295703 2295703 defendant Clenche Edmund   782987 782987 Clenche, Edmund, of Honton 0
4926432 2334685 2334685 defendant ap Yerward David husbandman 782987 782987 ap Yerward, David, of Honton, husbandman 13
5103815 2387540 2387540 defendant Riche William laborer 782987 782987 Riche, William, of Honton, laborer 0
5225318 2423077 2423077 defendant Carpenter William husbandman 782987 782987 Carpenter, William, of Honton, husbandman 0
5392049 2472804 2472804 defendant Johnson Robert   782987 782987 Johnson, Robert, of Honton husbandman 1
5636030 2555226 2555226 defendant Bromman John laborer 782987 782987 Bromman, John, of Honton, laborer 0
5636631 2555400 2555400 defendant Bromman John laborer 782987 782987 Bromman, John, of Honton, laborer 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);