names

21 rows where place_id = 635804

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3630134 1904273 1904273 defendant Hanworth John (legal representative) 635804 635804 Hanworth, John, of Bokenham Castell, yeoman, executors of 0
3630137 1904273 1904273 defendant Buntyng Robert, senior (legal representative) 635804 635804 Buntyng, Robert, senior, of Bokenham Castell, yeoman, executrix of 3
3712036 1930084 1930084 defendant Harvey Edmund   635804 635804 Harvey, Edmund, of Bokenham Castell, Norf shoemaker 1
3827455 1966454 1966454 defendant Tebold Augustine smith 635804 635804 Tebold, Augustine, of Bokenham Castell, smith 1
3905455 1992094 1992094 plaintiff Knyvett Edward   635804 635804 Knyvett, Edward, of Bokenham Castell, knight 0
3984296 2019146 2019146 defendant Knevett Edmund gent 635804 635804 Knevett, Edmund, of Bokenham Castell, gent 1
4799884 2296146 2296146 defendant Poteys John yeoman 635804 635804 Poteys, John, of Bokenham Castell, yeoman 2
4814617 2300683 2300683 defendant Sturmy John yeoman 635804 635804 Sturmy, John, of Bokenham Castell, yeoman 0
4860607 2314676 2314676 plaintiff Clyfton John   635804 635804 Clyfton, John, of Bokenham Castell, knight 0
4878402 2320190 2320190 defendant Grene Andrew yeoman 635804 635804 Grene, Andrew, of Bokenham Castell, yeoman 3
4941192 2339269 2339269 defendant Clyfton John   635804 635804 Clyfton, John, of Bokenham Castell, knight 0
4982204 2351598 2351598 defendant Clerk Robert husbandman 635804 635804 Clerk, Robert, of Bokenham Castell, husbandman 5
4982205 2351598 2351598 defendant Thoby Thomas gent 635804 635804 Thoby, Thomas, of Bokenham Castell, gent 6
5037383 2367804 2367804 defendant Clyfton Joan widow 635804 635804 (Clyfton, Joan, of Bokenham Castell, widow 1
5037387 2367804 2367804 defendant Sheryngton John yeoman 635804 635804 Sheryngton, John, of Bokenham Castell, yeoman 5
5085026 2382031 2382031 defendant Hardy Robert yeoman 635804 635804 Hardy, Robert, of Bokenham Castell, yeoman 0
5092300 2384127 2384127 defendant Dabeneye John skinner 635804 635804 Dabeneye, John, of Bokenham Castell, skinner 0
5212762 2419480 2419480 defendant Fadyr John gent 635804 635804 Fadyr, John, of Bokenham Castell, gent 0
5218512 2421146 2421146 defendant Fadyr John esq 635804 635804 Fadyr, John, of Bokenham Castell, esq 0
5246526 2429145 2429145 defendant Fader John esq 635804 635804 Fader, John, of Bokenham Castell, esq 0
5509467 2507810 2507810 defendant Wrythok Robert   635804 635804 Wrythok, Robert, of Bokenham Castell, coverlet weaver 3

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);