names

22 rows where place_id = 604979

✎ 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
3659938 1913365 1913365 defendant Wellys John husbandman 604979 604979 Wellys, John, of Dyngley, husbandman 0
3660773 1913633 1913633 defendant Penne Robert yeoman 604979 604979 Penne, Robert, of Dyngley, yeoman 0
3665315 1915107 1915107 defendant Wellys John husbandman 604979 604979 Wellys, John, of Dyngley, husbandman 0
3671156 1916948 1916948 defendant Horsham John yeoman 604979 604979 Horsham, John, of Dyngley, yeoman 0
3671157 1916948 1916948 defendant Mitton John husbandman 604979 604979 Mitton, John, of Dyngley, husbandman 1
3683533 1920982 1920982 defendant Pen Robert yeoman 604979 604979 Pen, Robert, of Dyngley, yeoman 1
3701866 1926836 1926836 defendant Churche Edmund yeoman 604979 604979 Churche, Edmund, of Dyngley, yeoman 0
3711018 1929756 1929756 defendant Churche Edmund yeoman 604979 604979 Churche, Edmund, of Dyngley, yeoman 0
3711019 1929756 1929756 defendant German John yeoman 604979 604979 German, John, of Dyngley, yeoman 1
3720297 1932627 1932627 defendant Bekett Nicholas husbandman 604979 604979 Bekett, Nicholas, of Dyngley, husbandman 0
3720298 1932627 1932627 defendant Bekett Richard husbandman 604979 604979 Bekett, Richard, of Dyngley, husbandman 1
4041176 2039334 2039334 plaintiff Gryffyn Edward   604979 604979 Gryffyn, Edward, of Dyngley, esq, Saunders, William, esq, of Harryngton, Nhants 2
4172657 2085896 2085896 defendant Gryffyn Edward   604979 604979 Gryffyn, Edward, of Dyngley, esq, sheriff 0
4195842 2094100 2094100 defendant Gryffyn Edward esq 604979 604979 Gryffyn, Edward, of Dyngley, esq 0
4357771 2149956 2149956 defendant Wylbye Nicholas yeoman 604979 604979 Wylbye, Nicholas, of Dyngley, yeoman 0
4585578 2226912 2226912 plaintiff Hampton Thomas   604979 604979 Hampton, Thomas, of Dyngley 0
4765224 2285106 2285106 defendant Clere Thomas husbandman 604979 604979 Clere, Thomas, of Dyngley,husbandman 0
4900213 2326693 2326693 defendant Brook Arthur gent 604979 604979 Brook, Arthur, of Dyngley, gent 0
5250057 2430125 2430125 defendant Carlile Richard gent 604979 604979 Carlile, Richard, of Dyngley, gent 0
5273320 2437268 2437268 defendant Martyn John husbandman 604979 604979 Martyn, John, of Dyngley, husbandman 1
5416438 2479836 2479836 defendant Cost Thomas gent 604979 604979 Cost, Thomas, of Dyngley, gent 1
5491275 2502278 2502278 defendant Burdon Richard yeoman 604979 604979 Burdon, Richard, of Dyngley, yeoman 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);