names

14 rows where case_id = 1963628

✎ 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
3818280 1963628 1963628 plaintiff Manners Thomas Earl of Rutland   Manners, Thomas, Earl of Rutland 0
3818281 1963628 1963628 defendant Crawe William fisher 634334 634334 Crawe, William, of Honytoft, fisher 0
3818282 1963628 1963628 defendant Rumforth Roger fisher 634335 634335 Rumforth, Roger, of Freeston, fisher 1
3818283 1963628 1963628 defendant Gybson John fisher 634337 634337 Gybson, John, of Fysshetofte, fisher 2
3818284 1963628 1963628 defendant Bustard Thomas fisher 634337 634337 Bustard, Thomas, of Fysshetofte, fisher 3
3818285 1963628 1963628 defendant Benne John fisher 634336 634336 Benne, John, of Kyndam, fisher 4
3818286 1963628 1963628 defendant Crosseley William husbandman 634335 634335 Crosseley, William, of Freeston, husbandman 5
3818287 1963628 1963628 defendant Harryson Thomas fisher 634335 634335 Harryson, Thomas, of Freeston, fisher 6
3818288 1963628 1963628 defendant Gylson Thomas fisher 634335 634335 Gylson, Thomas, of Freeston, fisher 7
3818289 1963628 1963628 defendant Pakhernes William, senior fisher 634335 634335 Pakhernes, William, senior, of Freeston, fisher 8
3818290 1963628 1963628 defendant Cley Richard husbandman 634335 634335 Cley, Richard, of Freeston, husbandman 9
3818291 1963628 1963628 defendant Wade John husbandman 634335 634335 Wade, John, of Freeston, husbandman 10
3818292 1963628 1963628 defendant Bysshop Thomas weaver 634335 634335 Bysshop, Thomas, of Freeston, weaver 11
3818293 1963628 1963628 defendant Pakhernes William, junior fisher 634335 634335 Pakhernes, William, junior, of Freeston, fisher 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);