names

14 rows where case_id = 2275171

✎ 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
4731942 2275171 2275171 plaintiff (not given) John bishop of Norwich   Norwich, John, bishop of 0
4731943 2275171 2275171 defendant Baxster Peter husbandman 792834 792834 Baxster, Peter, of Little Fakenham, Suff, husbandman 0
4731944 2275171 2275171 defendant Scot John miller 792835 792835 Scot, John, of Sapston, Suff, miller 1
4731945 2275171 2275171 defendant Reve Geoffrey husbandman 597385 597385 Reve, Geoffrey, of Sapston, husbandman 2
4731946 2275171 2275171 defendant Wagard David husbandman 597385 597385 Wagard, David, of Sapston, husbandman 3
4731947 2275171 2275171 defendant Gent John   835490 835490 Gent, John, of Euston, Suff, shepherd 4
4731948 2275171 2275171 defendant Gent Walter   594925 594925 Gent, Walter, of Euston, shepherd 5
4731949 2275171 2275171 defendant Elyot John husbandman 594925 594925 Elyot, John, of Euston, husbandman 6
4731950 2275171 2275171 defendant Roberd John tailor 792838 792838 Roberd, John, of Melverston, tailor 7
4731951 2275171 2275171 defendant Meir John jun, of Kilverston, mason   Meir, John, jun, of Kilverston, mason 8
4731952 2275171 2275171 defendant Skepper Thomas laborer 591887 591887 Skepper, Thomas, of Hokham, laborer 9
4731953 2275171 2275171 defendant Baxster Thomas baker 643441 643441 Baxster, Thomas, of Hokham, Norf, baker 10
4731954 2275171 2275171 defendant Doweshed John husbandman 591887 591887 Doweshed, John, of Hokham, husbandman 11
4731955 2275171 2275171 defendant Harpour Thomas   591887 591887 Harpour, Thomas, of Hokham, minstrel 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);