names

11 rows where place_id = 653782

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3929805 2000306 2000306 defendant Hyll Henry husbandman 653782 653782 Hyll, Henry, of Curry Rivel, husbandman 0
4549925 2215910 2215910 plaintiff Cras Thomas   653782 653782 Cras, Thomas, of Curry Rivel 0
4603856 2232390 2232390 defendant Pynynge John   653782 653782 Pynynge, John, of Curry Rivel 0
4697032 2264551 2264551 defendant Craas Thomas husbandman 653782 653782 Craas, Thomas, of Curry Rivel, husbandman 2
4726872 2273671 2273671 defendant Halberton William husbandman 653782 653782 Halberton, William, of Curry Rivel, husbandman 1
4763608 2284604 2284604 defendant Pyry Thomas husbandman 653782 653782 Pyry, Thomas, of Curry Rivel, husbandman 0
4766751 2285592 2285592 defendant Beke William smith 653782 653782 Beke, William, of Curry Rivel, smith 3
4832166 2306090 2306090 defendant Webbe William weaver 653782 653782 Webbe, William, of Curry Rivel, weaver 0
4928404 2335305 2335305 defendant Cote Robert butcher 653782 653782 Cote, Robert, of Curry Rivel, butcher 0
5407866 2477329 2477329 defendant Culmestowe William butcher 653782 653782 Culmestowe, William, of Curry Rivel, butcher 1
5440253 2486985 2486985 defendant Culmestoke William butcher 653782 653782 Culmestoke, William, of Curry Rivel, butcher 1

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