names

11 rows where place_id = 759682

✎ 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
4463406 2189246 2189246 defendant Balsham John   759682 759682 Balsham, John, of Thrillowe 0
4559379 2218883 2218883 defendant Page William   759682 759682 Page, William, of Thrillowe 4
4581964 2225804 2225804 defendant Meyner John   759682 759682 Meyner, John, of Thrillowe 5
4581975 2225805 2225805 defendant Meyner John   759682 759682 Meyner, John, of Thrillowe 5
4584462 2226555 2226555 defendant Randolf Simon   759682 759682 Randolf, Simon, of Thrillowe 2
4662764 2249812 2249812 defendant Kent Thomas husbandman 759682 759682 Kent, Thomas, of Thrillowe, husbandman 0
4662765 2249812 2249812 defendant Mortymer John chandler 759682 759682 Mortymer, John, of Thrillowe, chandler 1
4670435 2256438 2256438 defendant Wysman Edmund mercer 759682 759682 Wysman, Edmund, of thrillowe, mercer 1
4753044 2281341 2281341 defendant Boyton John yeoman 759682 759682 Boyton, John, of Thrillowe, yeoman 0
4774265 2287934 2287934 defendant Boyton John yeoman 759682 759682 Boyton, John, of Thrillowe, yeoman 0
4798085 2295589 2295589 defendant Maistyr Peter   759682 759682 Maistyr, Peter, of Thrillowe, Parva husbandman 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);