names

20 rows where place_id = 585921

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587505 1863739 1863739 defendant Burdet Richard esq 585921 585921 Burdet, Richard, of Arrowe, Warks, esq 1
3796998 1956940 1956940 defendant Conwey Edward esq 585921 585921 Conwey, Edward, of Arrowe, Warks, esq 2
3924746 1998593 1998593 defendant Conwey John gent 585921 585921 Conwey, John, of Arrowe, Warks, gent 0
3964831 2012309 2012309 defendant Conwaye John   585921 585921 Conwaye, John, of Arrowe, Warks, knight 0
3998280 2024130 2024130 defendant Conwaye John   585921 585921 Conwaye, John, of Arrowe, Warks, knight 0
3998334 2024143 2024143 defendant Coneway John   585921 585921 Coneway, John, of Arrowe, Warks, knight 0
4000946 2025108 2025108 defendant Conwey John   585921 585921 Conwey, John, of Arrowe, Warks, knight, son of John Conwey, of London, knight or gent 0
4033552 2036652 2036652 defendant Conwaye John   585921 585921 Conwaye, John, of Arrowe, Warks, knight 0
4033554 2036653 2036653 defendant Conwaye John   585921 585921 Conwaye, John, of Arrowe, Warks, knight 0
4121977 2068161 2068161 defendant Conwaye John   585921 585921 Conwaye, John, of Arrowe, Warks, knight 0
4130983 2071394 2071394 defendant Conway John   585921 585921 Conway, John, of Arrowe, Warks, knight 0
4162853 2082542 2082542 defendant Conway Denis gent 585921 585921 Conway, Denis, of Arrowe, Warks, gent 39
4168674 2084531 2084531 defendant Conwey John   585921 585921 Conwey, John, of Arrowe, Warks, knight 0
4227032 2104928 2104928 defendant Conwaye Edward esq 585921 585921 Conwaye, Edward, of Arrowe, Warks, esq 0
4368526 2153789 2153789 defendant Ossebaston Edmund gent 585921 585921 Ossebaston, Edmund, of Arrowe, Warks, gent 0
5353698 2461222 2461222 defendant Burdet Margaret widow 585921 585921 Burdet, Margaret, of Arrowe, Warks, widow 0
5361395 2463584 2463584 defendant Burdet Margaret widow 585921 585921 Burdet, Margaret, of Arrowe, Warks, widow 0
5361617 2463656 2463656 defendant Burdet Richard gent 585921 585921 Burdet, Richard, of Arrowe, Warks, gent 0
5537254 2516136 2516136 defendant Mason Richard miller 585921 585921 Mason, Richard, of Arrowe, Warks, miller 0
5551240 2520395 2520395 defendant Conwey Edward gent 585921 585921 Conwey, Edward, of Arrowe, Warks, gent 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);