names

11 rows where place_id = 629548

✎ 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
3788923 1954346 1954346 defendant Hogeson Richard yeoman 629548 629548 Hogeson, Richard, of Whorleton, yeoman 1
4157201 2080587 2080587 defendant Strangwayes Henry gent 629548 629548 Strangwayes, Henry, of Whorleton, gent 1
4560290 2219162 2219162 defendant Hoggalon Roger   629548 629548 Hoggalon, Roger, of Whorleton 16
4560291 2219162 2219162 defendant Coke William   629548 629548 Coke, William, of Whorleton 17
4560292 2219162 2219162 defendant Thomson John   629548 629548 Thomson, John, of Whorleton 18
4561432 2219515 2219515 defendant Hoggeson Robert   629548 629548 Hoggeson, Robert, of Whorleton 30
4561433 2219515 2219515 defendant Cole William   629548 629548 Cole, William, of Whorleton 31
4561434 2219515 2219515 defendant Thomson John   629548 629548 Thomson, John, of Whorleton 32
4691171 2262759 2262759 defendant Gower Thomas gent 629548 629548 Gower, Thomas, of Whorleton, gent 2
4797757 2295478 2295478 defendant Girlyngton John husbandman 629548 629548 Girlyngton, John, of Whorleton, husbandman 0
4910944 2329935 2329935 defendant Fyssher Simon husbandman 629548 629548 Fyssher, Simon, of Whorleton, husbandman 3

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);