names

13 rows where case_id = 2471899

✎ 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
5388953 2471899 2471899 plaintiff Hert William gent 585869 585869 Hert, William, of London, gent, on his own account 0
5388954 2471899 2471899 defendant Barnes Richard gent 881787 881787 Barnes, Richard, of Alforby, Leics, gent 0
5388955 2471899 2471899 defendant Wylde John yeoman 866645 866645 Wylde, John, of Clapham, Surr, yeoman 1
5388956 2471899 2471899 defendant Haydok John gent 585869 585869 Haydok, John, of London, gent 2
5388957 2471899 2471899 defendant Sakevyle Humphrey esq 850339 850339 Sakevyle, Humphrey, of Wythyam, Sussex, esq 3
5388958 2471899 2471899 defendant Chyld Philip husbandman 592718 592718 Chyld, Philip, of South Mymmes, Middx, husbandman 4
5388959 2471899 2471899 defendant Webbe Nicholas plumber 586033 586033 Webbe, Nicholas, of Westminster, plumber 5
5388960 2471899 2471899 defendant Croweford William   881788 881788 Croweford, William, of St Mary's in the Strand, parish clerk 6
5388961 2471899 2471899 defendant Newebery John gent 586034 586034 Newebery, John, of St Albans, Herts, gent 7
5388962 2471899 2471899 defendant Newebery Alice     Alice, his wife 8
5388963 2471899 2471899 defendant Loveden Thomas (legal representative) 595762 595762 Loveden, Thomas, of Crandon, Bucks, gent, executors of 9
5388964 2471899 2471899 defendant Loveden Margaret widow 595762 595762 (Loveden, Margaret, of Crandon, Bucks, widow 10
5388965 2471899 2471899 defendant Loveden William gent 590271 590271 Loveden, William, of Crendon, gent 11

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