names

12 rows where place_id = 760522

✎ 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
4470924 2191557 2191557 defendant Wryghtson John   760522 760522 Wryghtson, John, of Merkyngton 0
4616181 2236063 2236063 defendant Whipp John   760522 760522 Whipp, John, of Merkyngton 2
4836161 2307291 2307291 defendant Brereton John husbandman 760522 760522 Brereton, John, of Merkyngton, husbandman 0
4887651 2322968 2322968 defendant del Hermystede William yeoman 760522 760522 del Hermystede, William, of Merkyngton, yeoman 0
4887652 2322968 2322968 defendant Lemyng William husbandman 760522 760522 Lemyng, William, of Merkyngton, husbandman 1
5042032 2369220 2369220 defendant Tummell Richard husbandman 760522 760522 Tummell, Richard, of Merkyngton, husbandman 2
5118032 2391703 2391703 defendant Kendale John   760522 760522 Kendale, John, of Merkyngton, franklin 0
5189250 2412590 2412590 defendant Buk Henry smith 760522 760522 Buk, Henry, of Merkyngton, smith 0
5189251 2412590 2412590 defendant Wightston John tanner 760522 760522 Wightston, John, of Merkyngton, tanner 1
5189252 2412590 2412590 defendant Herste Robert laborer 760522 760522 Herste, Robert, of Merkyngton, laborer 2
5200089 2415776 2415776 defendant Kendale John   760522 760522 Kendale, John, of Merkyngton, franklin 0
5331596 2454530 2454530 defendant Buk Henry smith 760522 760522 Buk, Henry, of Merkyngton, smith 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);