names

19 rows where place_id = 647780

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3898153 1989592 1989592 defendant Richardson William husbandman 647780 647780 Richardson, William, of Lynstoke, husbandman 0
3898154 1989592 1989592 defendant Grame Thomas husbandman 647780 647780 Grame, Thomas, of Lynstoke, husbandman 1
3898155 1989592 1989592 defendant Nycolson John husbandman 647780 647780 Nycolson, John, of Lynstoke, husbandman 2
3898156 1989592 1989592 defendant Nycolson Alice spinster 647780 647780 Nycolson, Alice, of Lynstoke, spinster 3
3898157 1989592 1989592 defendant Grame John husbandman 647780 647780 Grame, John, of Lynstoke, husbandman 4
3898158 1989592 1989592 defendant Blakloke Thomas husbandman 647780 647780 Blakloke, Thomas, of Lynstoke, husbandman 5
3898159 1989592 1989592 defendant Nicolson Robert husbandman 647780 647780 Nicolson, Robert, of Lynstoke, husbandman 6
3898160 1989592 1989592 defendant Richardson Christopher husbandman 647780 647780 Richardson, Christopher, of Lynstoke, husbandman 7
3898161 1989592 1989592 defendant Clerke Edward husbandman 647780 647780 Clerke, Edward, of Lynstoke, husbandman 8
3898162 1989592 1989592 defendant Thomson James husbandman 647780 647780 Thomson, James, of Lynstoke, husbandman 9
3898163 1989592 1989592 defendant Nycolson Robert husbandman 647780 647780 Nycolson, Robert, of Lynstoke, husbandman 10
3898164 1989592 1989592 defendant Dowersten Roland husbandman 647780 647780 Dowersten, Roland, of Lynstoke, husbandman 11
3898165 1989592 1989592 defendant Nicolson Christopher husbandman 647780 647780 Nicolson, Christopher, of Lynstoke, husbandman 12
3898166 1989592 1989592 defendant Nicolson Isabel Edward, husbandman 647780 647780 Isabel his wife: Richardson, Edward, of Lynstoke, husbandman 13
3898167 1989592 1989592 defendant Blakeloke Richard husbandman 647780 647780 Blakeloke, Richard, of Lynstoke, husbandman 14
4688684 2262025 2262025 defendant Nicolson John yeoman 647780 647780 Nicolson, John, of Lynstoke, yeoman 2
4774287 2287939 2287939 defendant Gr_ Thomas esq 647780 647780 Gr_, Thomas, of Lynstoke, esq 2
4799204 2295932 2295932 defendant Grame or Graine Thomas esq 647780 647780 Grame or Graine, Thomas, of Lynstoke, esq 1
4862574 2315280 2315280 defendant Grame Thomas, senior gent 647780 647780 Grame, Thomas, senior, of Lynstoke, Cumber, 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);