names

15 rows where place_id = 597468

✎ 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
3628703 1903852 1903852 defendant Parker Richard grasier 597468 597468 Parker, Richard, of Shordiche, Middx, grasier 1
3757810 1944420 1944420 defendant A Vales John yeoman 597468 597468 A Vales, John, of Shordiche, Middx, yeoman 5
3801518 1958386 1958386 defendant Goddarde William gent 597468 597468 Goddarde, William, of Shordiche, Middx, gent 1
3833698 1968468 1968468 defendant Snowe John butcher 597468 597468 Snowe, John, of Shordiche, Middx, butcher 1
3956029 2009177 2009177 defendant Phillipps John butcher 597468 597468 Phillipps, John, of Shordiche, Middx, butcher 2
3981493 2018142 2018142 defendant Lyster Richard innholder 597468 597468 Lyster, Richard, of Shordiche, Middx, innholder 1
4009043 2028000 2028000 defendant Lister Richard innholder 597468 597468 Lister, Richard, of Shordiche, Middx, innholder 0
4016451 2030589 2030589 plaintiff Stoughton Robert butcher 597468 597468 Stoughton, Robert, of Shordiche, Middx, butcher 0
4019767 2031802 2031802 plaintiff Welsted Henry tailor 597468 597468 Welsted, Henry, of Shordiche, Middx, tailor 0
4060076 2046002 2046002 defendant Jolyff Thomas (legal representative) 597468 597468 Jolyff, Thomas, of Shordiche, Middx, yeoman, executors of 0
4211006 2099406 2099406 defendant Namer Meredithy   597468 597468 Namer, Meredithy, of Shordiche, Middx, professor of theology 2
4263871 2117576 2117576 defendant Geree or Gery John founder 597468 597468 Geree or Gery, John, of Shordiche, Middx, founder 0
4328935 2139990 2139990 defendant Havard William chapman 597468 597468 Havard, William, of Shordiche, Middx, chapman 2
4331566 2140853 2140853 defendant Tucker Henry yeoman 597468 597468 Tucker, Henry, of Shordiche, Middx, yeoman 3
4883616 2321791 2321791 defendant Purdon Richard   597468 597468 Purdon, Richard, of Shordiche, Middx, "coygner" or coiner 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);