names

7 rows where place_id = 681414

✎ 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
4044764 2040576 2040576 plaintiff Robinson John yeoman 681414 681414 Robinson, John, of Brom, yeoman 0
4630697 2240501 2240501 defendant Franceys John   681414 681414 Franceys, John, of Brom 4
4644214 2244404 2244404 defendant Bosard William   681414 681414 Bosard, William, of Brom 0
4730163 2274632 2274632 defendant Stubcroft Robert yeoman 681414 681414 Stubcroft, Robert, of Brom, yeoman 1
4798315 2295661 2295661 defendant Breton Robert yeoman 681414 681414 Breton, Robert, of Brom, yeoman 0
4981406 2351356 2351356 defendant Cuppere William clerk 681414 681414 Cuppere, William, of Brom, clerk 0
5073583 2378582 2378582 defendant Whitelok Walter husbandman 681414 681414 Whitelok, Walter, of Brom, or of Ipswich, Suff, husbandman 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);