names

14 rows where case_id = 2521865

✎ 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
5556466 2521865 2521865 plaintiff Lovell Thomas knight   Lovell, Thomas, knight 0
5556467 2521865 2521865 defendant Strykeland Walter   603072 603072 Strykeland, Walter, of Yorks, knight 0
5556468 2521865 2521865 defendant Midilton Thomas   603072 603072 Midilton, Thomas, of Yorks, knight 1
5556469 2521865 2521865 defendant Greston John mercer 585869 585869 Greston, John, of London, mercer 2
5556470 2521865 2521865 defendant Worle Henry goldsmith 585869 585869 Worle, Henry, of London, goldsmith 3
5556471 2521865 2521865 defendant Hawkyns Reginald salter 585869 585869 Hawkyns, Reginald, of London, salter 4
5556472 2521865 2521865 defendant Midelton Geoffrey esq 899744 899744 Midelton, Geoffrey, of Midelton, Londestale, Westmor, esq 5
5556473 2521865 2521865 defendant Savile John   585869 585869 Savile, John, of London, knight 6
5556474 2521865 2521865 defendant Hartlyngton Robert gent 899745 899745 Hartlyngton, Robert, of Hunysworth, Yorks, gent 7
5556475 2521865 2521865 defendant Stanshall Humphrey gent 585869 585869 Stanshall, Humphrey, of London, gent 8
5556476 2521865 2521865 defendant Gardyner Robert fuller 585869 585869 Gardyner, Robert, of London, fuller 9
5556477 2521865 2521865 defendant Gyles Jerome sherman 585869 585869 Gyles, Jerome, of London, sherman 10
5556478 2521865 2521865 defendant Stucle Robert gent 586079 586079 Stucle, Robert, of Bedford, gent 11
5556479 2521865 2521865 defendant Paten William   724231 724231 Paten, William, of Bromeham, Beds 12

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