names

11 rows where place_id = 730219

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4099131 2060016 2060016 defendant Walsyngham Thomas   730219 730219 Walsyngham, Thomas, of Shipdeham, hoop maker 0
4287218 2125486 2125486 defendant Farrowe George butcher 730219 730219 Farrowe, George, of Shipdeham, butcher 1
4290099 2126525 2126525 defendant Harryson John coiner or comer 730219 730219 Harryson, John, of Shipdeham, coiner or comer 0
4303298 2131282 2131282 defendant Murrell Stephen gent 730219 730219 Murrell, Stephen, of Shipdeham, gent 0
4334176 2141708 2141708 defendant Bett John yeoman 730219 730219 Bett, John, of Shipdeham, yeoman 0
4379958 2157934 2157934 defendant Hamonde Eichard yeoman 730219 730219 Hamonde, Eichard, of Shipdeham, yeoman 0
4401193 2164994 2164994 defendant Mordewe William yeoman 730219 730219 Mordewe, William, of Shipdeham, yeoman 2
4407083 2166929 2166929 defendant Mordewe William yeoman 730219 730219 Mordewe, William, of Shipdeham, yeoman 0
4410018 2167956 2167956 defendant Platfoote Thomas yeoman 730219 730219 Platfoote, Thomas, of Shipdeham, yeoman 3
4444235 2183180 2183180 defendant Camplyoun Simon   730219 730219 Camplyoun, Simon, of Shipdeham 2
4602561 2232022 2232022 defendant Godeyene John   730219 730219 Godeyene, John, of Shipdeham 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);