names

11 rows where place_id = 769809

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4561796 2219624 2219624 plaintiff Pernell Roger   769809 769809 Pernell, Roger, of Resshemere 0
4640211 2243250 2243250 defendant Carter Robert   769809 769809 Carter, Robert, of Resshemere 2
4671430 2256714 2256714 defendant atte Noke Humphrey carrier 769809 769809 atte Noke, Humphrey, of Resshemere, carrier 0
4737652 2276884 2276884 defendant Judy or Indy Ralph butcher 769809 769809 Judy or Indy, Ralph, of Resshemere, butcher 3
4771639 2287108 2287108 plaintiff Sewhat Hugh   769809 769809 Sewhat, Hugh, of Resshemere, administrators of 0
4771645 2287108 2287108 defendant Bryd William yeoman 769809 769809 Bryd, William, of Resshemere, yeoman 3
4775190 2288233 2288233 defendant Blak John husbandman 769809 769809 Blak, John, of Resshemere, husbandman 2
5183519 2410914 2410914 defendant Blak Andrew yeoman 769809 769809 Blak, Andrew, of Resshemere, yeoman 2
5203904 2416892 2416892 defendant Blak Andrew yeoman 769809 769809 Blak, Andrew, of Resshemere, yeoman 2
5519756 2511014 2511014 defendant Dykeman gnes widow 769809 769809 Dykeman, gnes, of Resshemere, widow 1
5614464 2548316 2548316 defendant Warner John   769809 769809 Warner, John, of Resshemere 1

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