names

15 rows where case_id = 1975419

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3855692 1975419 1975419 plaintiff Welsche John knight   Welsche, John, knight 0
3855693 1975419 1975419 defendant Arture Thomas esq 614926 614926 Arture, Thomas, of Clopton, Soms, esq 0
3855694 1975419 1975419 defendant Poyntz Giles gent 627147 627147 Poyntz, Giles, of Iron Acton, gent 1
3855695 1975419 1975419 defendant Goodryche John gent 627147 627147 Goodryche, John, of Iron Acton, gent 2
3855696 1975419 1975419 defendant Lathbury William yeoman 627147 627147 Lathbury, William, of Iron Acton, yeoman 3
3855697 1975419 1975419 defendant Ardeyne Robert yeoman 640496 640496 Ardeyne, Robert, of Mangasfyld, yeoman 4
3855698 1975419 1975419 defendant Conwey John yeoman 640496 640496 Conwey, John, of Mangasfyld, yeoman 5
3855699 1975419 1975419 defendant Wall Richard yeoman 627147 627147 Wall, Richard, of Iron Acton, yeoman 6
3855700 1975419 1975419 defendant Hunt Thomas yeoman 627147 627147 Hunt, Thomas, of Iron Acton, yeoman 7
3855701 1975419 1975419 defendant Hunt Ambrose yeoman 627147 627147 Hunt, Ambrose, of Iron Acton, yeoman 8
3855702 1975419 1975419 defendant Harvy Thomas yeoman 627147 627147 Harvy, Thomas, of Iron Acton, yeoman 9
3855703 1975419 1975419 defendant Hunt Robert weaver 609258 609258 Hunt, Robert, of Chepyng Sudbury, weaver 10
3855704 1975419 1975419 defendant Browne William yeoman 627147 627147 Browne, William, of Iron Acton, yeoman 11
3855705 1975419 1975419 defendant Feylond Robert gent 640497 640497 Feylond, Robert, of Backwell, Soms, gent 12
3855706 1975419 1975419 defendant Pole of Tokyngton yeoman   Pole, of Tokyngton, yeoman 13

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