names

10 rows where place_id = 621489

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3741743 1939280 1939280 defendant Tonell or Touell William clerk 621489 621489 Tonell or Touell, William, of Ralegh, clerk 0
3749957 1941905 1941905 defendant Keyle John husbandman 621489 621489 Keyle, John, of Ralegh, husbandman 0
3771694 1948847 1948847 defendant Saer Philip smith 621489 621489 Saer, Philip, of Ralegh, smith 1
3960548 2010791 2010791 defendant Body John gent 621489 621489 Body, John, of Ralegh, gent 0
3969293 2013863 2013863 defendant (not given) Thomas vicar of Ruste 621489 621489 Ruste, Thomas, of Ralegh, vicar of Rolsted 10
4700345 2265523 2265523 defendant Evyas William laborer 621489 621489 Evyas, William, of Ralegh, laborer 1
4700346 2265523 2265523 defendant Vikary Thomas yeoman 621489 621489 Vikary, Thomas, of Ralegh, yeoman 2
4702280 2266122 2266122 defendant Guyas William laborer 621489 621489 Guyas, William, of Ralegh, laborer 1
4702281 2266122 2266122 defendant Wykary Thomas yeoman 621489 621489 Wykary, Thomas, of Ralegh, yeoman 2
4726962 2273700 2273700 defendant Chechestre John esq 621489 621489 Chechestre, John, of Ralegh, esq 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);