names

13 rows where case_id = 2359651

✎ 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
5009475 2359651 2359651 plaintiff Trewyk Ralph     Trewyk, Ralph 0
5009476 2359651 2359651 plaintiff Trewyk Alice     Alice, his wife 1
5009477 2359651 2359651 defendant Whyte Nicholas husbandman 587287 587287 Whyte, Nicholas, of Launceston, husbandman 0
5009478 2359651 2359651 defendant Pye John husbandman 834519 834519 Pye, John, of Little Penhole, husbandman 1
5009479 2359651 2359651 defendant Rogger Stephen laborer 597538 597538 Rogger, Stephen, of North Pyderwyn, laborer 2
5009480 2359651 2359651 defendant Trystres John husbandman 834520 834520 Trystres, John, of Attebarn, husbandman 3
5009481 2359651 2359651 defendant Pyke Thomas butcher 796829 796829 Pyke, Thomas, of Fursdon, butcher 4
5009482 2359651 2359651 defendant Sandercok William husbandman 587287 587287 together with Sandercok, William, of Launceston, husbandman 5
5009483 2359651 2359651 defendant Vonwell Nicholas husbandman 587287 587287 Vonwell, Nicholas, of Launceston, husbandman 6
5009484 2359651 2359651 defendant Denkell John husbandman 834521 834521 Denkell, John, of Kyncote, husbandman 7
5009485 2359651 2359651 defendant Yoncote John husbandman 834522 834522 Yoncote, John, of North Whetelay, husbandman 8
5009486 2359651 2359651 defendant Barne Johnof Tyllycote husbandman   Barne, Johnof Tyllycote, husbandman 9
5009487 2359651 2359651 defendant Wynecote Walter husbandman 834518 834518 Wynecote, Walter, of Treslethen, husbandman 10

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