names

15 rows where case_id = 2397888

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5138944 2397888 2397888 plaintiff Saynton John     Saynton, John, on his own account 0
5138945 2397888 2397888 defendant Days William   774156 774156 Days, William, of Great Catworth, wool man 0
5138946 2397888 2397888 defendant Gray Simon husbandman 597023 597023 Gray, Simon, of Catworth, husbandman 1
5138947 2397888 2397888 defendant Jay John husbandman 597023 597023 Jay, John, of Catworth, husbandman 2
5138948 2397888 2397888 defendant Calcote Robert gent   Calcote, Robert, gent 3
5138949 2397888 2397888 defendant Moresby Richard gent 585869 585869 Moresby, Richard, of London, gent 4
5138950 2397888 2397888 defendant Hathe alias Kent Robert dyer 585869 585869 Hathe alias Kent, Robert, of London, dyer 5
5138951 2397888 2397888 defendant Patenson David     Patenson, David 6
5138952 2397888 2397888 defendant Tame John butcher 585869 585869 Tame, John, of London, butcher 7
5138953 2397888 2397888 defendant Clayton William esq 622892 622892 Clayton, William, of Torkesey, LIncs, esq 8
5138954 2397888 2397888 defendant Nort--- Robert yeoman 753445 753445 Nort---, Robert, of Nottinghamshire, yeoman 9
5138955 2397888 2397888 defendant Skenyngton Hugh gent 758829 758829 Skenyngton, Hugh, of Cossall, gent 10
5138956 2397888 2397888 defendant Bradshawe (illegible)   593956 593956 Bradshawe, ----, of Barneby, franklin 11
5138957 2397888 2397888 defendant Chapeleyn Thomas chaplain 851805 851805 Chapeleyn, Thomas, of Suffenhale, Shrops, chaplain 12
5138958 2397888 2397888 defendant Orton Richard chapman 587948 587948 Orton, Richard, of Newerk, chapman 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);