names

14 rows where place_id = 689106

✎ 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
4078843 2052731 2052731 defendant Aide John chapman 689106 689106 Aide, John, of Burnham, Norf, chapman 0
4380170 2158011 2158011 defendant Almer Thomas merchant 689106 689106 Almer, Thomas, of Burnham, Norf, merchant 0
4390017 2161283 2161283 defendant Almer Thomas merchant 689106 689106 Almer, Thomas, of Burnham, Norf, merchant 0
4780794 2289992 2289992 defendant Inglose Henry   689106 689106 Inglose, Henry, of Burnham, Norf, knight 0
4789480 2292777 2292777 defendant Inglanse Henry   689106 689106 Inglanse, Henry, of Burnham, Norf, knight 2
4789485 2292778 2292778 defendant Inglanse or Inglause Henry   689106 689106 Inglanse or Inglause, Henry, of Burnham, Norf, knight 2
4793958 2294240 2294240 defendant Inglose Henry   689106 689106 Inglose, Henry, of Burnham, Norf, knight 0
4798942 2295841 2295841 defendant Inglose Henry   689106 689106 Inglose, Henry, of Burnham, Norf, knight 1
4902706 2327465 2327465 defendant Lexham William gent 689106 689106 Lexham, William, of Burnham, Norf, gent 0
5019246 2362521 2362521 defendant Warener John husbandman 689106 689106 Warener, John, of Burnham, Norf, husbandman 0
5103900 2387567 2387567 defendant Mondon William yeoman 689106 689106 Mondon, William, of Burnham, Norf, yeoman 1
5109187 2389111 2389111 defendant Monden William yeoman 689106 689106 Monden, William, of Burnham, Norf, yeoman 1
5134304 2396529 2396529 defendant Munden William yeoman 689106 689106 Munden, William, of Burnham, Norf, yeoman 3
5154219 2402390 2402390 defendant Munden William yeoman 689106 689106 Munden, William, of Burnham, Norf, yeoman 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);