names

14 rows where place_id = 801461

✎ 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
4777620 2288997 2288997 defendant Germayn John   801461 801461 Germayn, John, of Metefeld, Suff, knight 0
4780621 2289936 2289936 defendant Brityeve Robert carpenter 801461 801461 Brityeve, Robert, of Metefeld, Suff, carpenter 0
4785364 2291438 2291438 defendant Germyn John   801461 801461 Germyn, John, of Metefeld, Suff, knight 0
4785367 2291439 2291439 defendant Germyn John   801461 801461 Germyn, John, of Metefeld, Suff, knight 0
4796796 2295148 2295148 defendant Yonge John yeoman 801461 801461 Yonge, John, of Metefeld, Suff, yeoman 2
4883519 2321761 2321761 defendant Jermyn John (legal representative) 801461 801461 Jermyn, John, of Metefeld, Suff, knight, executors of 2
4883521 2321761 2321761 defendant Jermyn John esq 801461 801461 Jermyn, John, of Metefeld, Suff, esq 4
4888897 2323312 2323312 defendant Jermyn John (legal representative) 801461 801461 Jermyn, John, of Metefeld, Suff, knight, executors of 0
5042700 2369424 2369424 defendant Norton Thomas butcher 801461 801461 Norton, Thomas, of Metefeld, Suff, butcher 0
5075189 2379074 2379074 defendant Spynke John husbandman 801461 801461 Spynke, John, of Metefeld, Suff, husbandman 7
5075201 2379075 2379075 defendant Spynke John husbandman 801461 801461 Spynke, John, of Metefeld, Suff, husbandman 8
5100354 2386545 2386545 defendant Baret Robert husbandman 801461 801461 Baret, Robert, of Metefeld, Suff, husbandman 11
5551057 2520334 2520334 defendant Kynge William husbandman 801461 801461 Kynge, William, of Metefeld, Suff, husbandman 1
5553186 2520972 2520972 defendant Orlowe John yeoman 801461 801461 Orlowe, John, of Metefeld, Suff, yeoman 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);