names

14 rows where place_id = 587254

✎ 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
3590917 1864786 1864786 defendant Romond William yeoman 587254 587254 Romond, William, of Exmouth, Devon, yeoman 4
3992821 2022186 2022186 defendant Browne William husbandman 587254 587254 Browne, William, of Exmouth, Devon, husbandman 2
4299710 2129983 2129983 defendant Spycer Michael chapman 587254 587254 Spycer, Michael, of Exmouth, Devon, chapman 1
4301380 2130600 2130600 defendant Rawleigh George esq 587254 587254 Rawleigh, George, of Exmouth, Devon, esq 0
4810790 2299498 2299498 defendant Galawey Thomas chapman 587254 587254 Galawey, Thomas, of Exmouth, Devon, chapman 1
4831706 2305945 2305945 defendant Lyndefen Richard mariner 587254 587254 Lyndefen, Richard, of Exmouth, Devon, mariner 0
4875059 2319150 2319150 defendant Filber William butcher 587254 587254 Filber, William, of Exmouth, Devon, butcher 2
4879038 2320373 2320373 defendant Boterewys John esq 587254 587254 Boterewys, John, of Exmouth, Devon, esq 0
4910881 2329914 2329914 defendant Hampton Henry shipman 587254 587254 Hampton, Henry, of Exmouth, Devon, shipman 0
4960379 2345071 2345071 defendant Lyndese Richard mariner 587254 587254 Lyndese, Richard, of Exmouth, Devon, mariner 4
5034332 2366900 2366900 defendant Galwey John chapman 587254 587254 Galwey, John, of Exmouth, Devon, chapman 4
5034338 2366901 2366901 defendant Galwey John chapman 587254 587254 Galwey, John, of Exmouth, Devon, chapman 4
5117317 2391498 2391498 defendant Pawe Hugh fisher 587254 587254 Pawe, Hugh, of Exmouth, Devon, fisher 0
5276588 2438229 2438229 defendant Andrewe William mariner 587254 587254 Andrewe, William, of Exmouth, Devon, mariner 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);