names

19 rows where place_id = 591081

✎ 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
3590389 1864635 1864635 defendant Talbot Gilbert   591081 591081 Talbot, Gilbert, of Blakemere, knight 0
3603273 1868696 1868696 defendant Wynston Thomas gent 591081 591081 Wynston, Thomas, of Blakemere, gent 0
3907585 1992826 1992826 defendant Brown John chaplain 591081 591081 Brown, John, of Blakemere, chaplain 4
4007012 2027282 2027282 defendant Colcombe John yeoman 591081 591081 Colcombe, John, of Blakemere, yeoman 0
4174432 2086525 2086525 defendant Colcombe James weaver 591081 591081 Colcombe, James, of Blakemere, weaver 0
4180090 2088514 2088514 defendant Coode John yeoman 591081 591081 Coode, John, of Blakemere, yeoman 2
4199822 2095490 2095490 defendant Wynston William gent 591081 591081 Wynston, William, of Blakemere, gent 1
4659769 2248905 2248905 defendant Bonde Hugh husbandman 591081 591081 Bonde, Hugh, of Blakemere, husbandman 0
4791983 2293598 2293598 defendant Bole John husbandman 591081 591081 Bole, John, of Blakemere, husbandman 1
4886989 2322780 2322780 defendant Brugge John chaplain 591081 591081 Brugge, John, of Blakemere, chaplain 3
4886990 2322780 2322780 defendant Broun John husbandman 591081 591081 Broun, John, of Blakemere, husbandman 4
4886991 2322780 2322780 defendant Rolles Hugh husbandman 591081 591081 Rolles, Hugh, of Blakemere, husbandman 5
4954179 2343223 2343223 defendant Broun William husbandman 591081 591081 Broun, William, of Blakemere, husbandman 0
5075632 2379212 2379212 defendant ap John Thomas gent 591081 591081 ap John, Thomas, of Blakemere, gent 0
5094288 2384735 2384735 defendant Wynston Hugh husbandman 591081 591081 Wynston, Hugh, of Blakemere, husbandman 0
5370371 2466320 2466320 defendant Botman Richard husbandman 591081 591081 Botman, Richard, of Blakemere, husbandman 1
5492437 2502654 2502654 defendant Talbot Gilbert   591081 591081 Talbot, Gilbert, of Blakemere, knight 0
5507291 2507177 2507177 defendant Talbot Gilbert   591081 591081 Talbot, Gilbert, of Blakemere, knight 0
5528560 2513443 2513443 defendant Wynston Thomas gent 591081 591081 Wynston, Thomas, of Blakemere, gent 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);