names

17 rows where place_id = 650741

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3913708 1994925 1994925 defendant Benett Richard husbandman 650741 650741 Benett, Richard, of Sotherton, husbandman 1
4039017 2038576 2038576 defendant Dethe alias Shrymplyng John husbandman 650741 650741 Dethe alias Shrymplyng, John, of Sotherton, husbandman 0
4039019 2038577 2038577 defendant Dethe alias Shrymplynge John husbandman 650741 650741 Dethe alias Shrymplynge, John, of Sotherton, husbandman 0
4074106 2051034 2051034 defendant Browne Robert butcher 650741 650741 Browne, Robert, of Sotherton, butcher 1
4303545 2131366 2131366 defendant Denny Edmund husbandman 650741 650741 Denny, Edmund, of Sotherton, husbandman 0
4400604 2164793 2164793 defendant Thurston Anthony husbandman 650741 650741 Thurston, Anthony, of Sotherton, husbandman 1
4400605 2164793 2164793 defendant Snellinge Anthony husbandman 650741 650741 Snellinge, Anthony, of Sotherton, husbandman 2
4444204 2183168 2183168 defendant Balby Simon   650741 650741 Balby, Simon, of Sotherton 0
4476593 2193340 2193340 plaintiff Gant William   650741 650741 Gant, William, of Sotherton 0
4517738 2205938 2205938 plaintiff Dalymond Hugh   650741 650741 Dalymond, Hugh, of Sotherton, parson, on his own account 0
4660322 2249058 2249058 defendant Bosy John yeoman 650741 650741 Bosy, John, of Sotherton, yeoman 0
4900697 2326858 2326858 defendant Pyche John husbandman 650741 650741 Pyche, John, of Sotherton, husbandman 0
5390542 2472358 2472358 defendant Lese Nicholas husbandman 650741 650741 Lese, Nicholas, of Sotherton, husbandman 0
5433220 2484901 2484901 defendant Lese Nicholas husbandman 650741 650741 Lese, Nicholas, of Sotherton, husbandman 0
5433222 2484902 2484902 defendant Lese Nicholas husbandman 650741 650741 Lese, Nicholas, of Sotherton, husbandman 0
5529381 2513704 2513704 defendant Chapman William husbandman 650741 650741 Chapman, William, of Sotherton, husbandman 0
5572820 2526600 2526600 defendant Hardy Robert clerk 650741 650741 Hardy, Robert, of Sotherton, clerk 0

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