names

10 rows where place_id = 623201

✎ 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
3751134 1942279 1942279 defendant Neell Henry blacksmith 623201 623201 Neell, Henry, of brymyngham, blacksmith 0
3751135 1942279 1942279 defendant Maylard William capper 623201 623201 Maylard, William, of Brymyngham, capper 1
3897940 1989518 1989518 defendant Colchester Humphrey tanner 623201 623201 Colchester, Humphrey, of Brymyngham, tanner 1
3897941 1989518 1989518 defendant Mychell Edward butcher 623201 623201 Mychell, Edward, of Brymyngham, butcher 2
3897942 1989518 1989518 defendant Cortrell Robert fletcher 623201 623201 Cortrell, Robert, of Brymyngham, fletcher 3
4573130 2223130 2223130 defendant Prat John   623201 623201 Prat, John, of Brymyngham 2
4573135 2223131 2223131 defendant Prat John   623201 623201 Prat, John, of Brymyngham 2
4848875 2311114 2311114 defendant Rous Edmund husbandman 623201 623201 Rous, Edmund, of Brymyngham, husbandman 1
4926344 2334665 2334665 defendant Rowes Edmund merchant 623201 623201 Rowes, Edmund, of Brymyngham, merchant 0
5305282 2446584 2446584 defendant Warner Robert butcher 623201 623201 Warner, Robert, of Brymyngham, 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);