names

13 rows where case_id = 2485340

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5434772 2485340 2485340 plaintiff Pawe Andrew     Pawe, Andrew, on his own account 0
5434773 2485340 2485340 defendant Crosse John husbandman 870292 870292 Crosse, John, of Shirdam, husbandman 0
5434774 2485340 2485340 defendant Maynard Robert husbandman 590405 590405 Maynard, Robert, of Martham, husbandman 1
5434775 2485340 2485340 defendant Hert Thomas husbandman 591888 591888 Hert, Thomas, of Couteshale, husbandman 2
5434776 2485340 2485340 defendant Pekeryng Thomas husbandman 589043 589043 Pekeryng, Thomas, of North Byrlyngham, husbandman 3
5434777 2485340 2485340 defendant Drake Nicholas husbandman 589927 589927 Drake, Nicholas, of Paston, husbandman 4
5434778 2485340 2485340 defendant Pratte Thomas husbandman 887166 887166 Pratte, Thomas, of Mounesle, husbandman 5
5434779 2485340 2485340 defendant Heydon William husbandman 586471 586471 Heydon, William,of Aylesham, husbandman 6
5434780 2485340 2485340 defendant Blofeld Robert husbandman 590257 590257 Blofeld, Robert, of Hemmysby, husbandman 7
5434781 2485340 2485340 defendant Watlyng John   878766 878766 Watlyng, John, of Norwich, coryour 8
5434782 2485340 2485340 defendant Shipdham John husbandman 590106 590106 Shipdham, John, of South Walsham, husbandman 9
5434783 2485340 2485340 defendant Goldspynk John husbandman 592300 592300 Goldspynk, John, of Hetherset, husbandman 10
5434784 2485340 2485340 defendant Glover Robert husbandman 593924 593924 Glover, Robert, of Calthorp, husbandman 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);