names

18 rows where place_id = 662619

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3965598 2012582 2012582 defendant Serles John yeoman 662619 662619 Serles, John, of Ittringham, yeoman 1
4069175 2049268 2049268 defendant Payne John gent 662619 662619 Payne, John, of Ittringham, gent 1
4154608 2079707 2079707 defendant Serles John yeoman 662619 662619 Serles, John, of Ittringham, yeoman 0
4170216 2085080 2085080 defendant Wryght Walter husbandman 662619 662619 Wryght, Walter, of Ittringham, husbandman 1
4170220 2085081 2085081 defendant Mortofte John gent 662619 662619 Mortofte, John, of Ittringham, gent 0
4172800 2085943 2085943 defendant Serles John yeoman 662619 662619 Serles, John, of Ittringham, yeoman 1
4180886 2088793 2088793 defendant Wright Walter husbandman 662619 662619 Wright, Walter, of Ittringham, husbandman 2
4184121 2089944 2089944 defendant Serles John yeoman 662619 662619 Serles, John, of Ittringham, yeoman 1
4184124 2089945 2089945 defendant Serles John husbandman 662619 662619 Serles, John, of Ittringham, husbandman 0
4184127 2089946 2089946 defendant Serles John yeoman 662619 662619 Serles, John, of Ittringham, yeoman 0
4184128 2089946 2089946 defendant Larwood William husbandman 662619 662619 Larwood, William, of Ittringham, husbandman 1
4193554 2093313 2093313 defendant Mortoft John gent 662619 662619 Mortoft, John, of Ittringham, gent 0
4243359 2110770 2110770 defendant Sargetson Lawrence clerk 662619 662619 Sargetson, Lawrence, of Ittringham, clerk 3
4251744 2113573 2113573 defendant Langdon Edmund gent 662619 662619 Langdon, Edmund, of Ittringham, gent 2
4254507 2114496 2114496 defendant Sponer John blacksmith 662619 662619 Sponer, John, of Ittringham, blacksmith 1
4272728 2120448 2120448 defendant Botyfaunte William yeoman 662619 662619 Botyfaunte, William, of Ittringham, yeoman 0
4286234 2125131 2125131 defendant Langdon Edmund gent 662619 662619 Langdon, Edmund, of Ittringham, gent 2
4312488 2134503 2134503 defendant Same Thomas butcher 662619 662619 Same, Thomas, of Ittringham, butcher 2

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