names

17 rows where place_id = 605819

✎ 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
3662976 1914332 1914332 defendant Faunt Henry laborer 605819 605819 Faunt, Henry, of Preston by Faversham, laborer 0
4687783 2261751 2261751 plaintiff Sturcy John   605819 605819 Sturcy, John, of Preston by Faversham, vicar 0
4687784 2261751 2261751 defendant Parys John husbandman 605819 605819 Parys, John, of Preston by Faversham, husbandman 0
4687785 2261752 2261752 plaintiff Sturey John   605819 605819 Sturey, John, of Preston by Faversham, vicar 0
4713460 2269533 2269533 plaintiff Sturey John   605819 605819 Sturey, John, of Preston by Faversham, vicar 0
4735924 2276387 2276387 plaintiff Sturey John   605819 605819 Sturey, John, of Preston by Faversham, vicar 0
4754671 2281844 2281844 defendant Paris John hosier 605819 605819 Paris, John, of Preston by Faversham, hosier 1
4816791 2301351 2301351 defendant Baret Valentine esq 605819 605819 Baret, Valentine, of Preston by Faversham, esq 0
4835099 2306978 2306978 defendant Marys William esq 605819 605819 (Marys, William, of Preston by Faversham, esq 1
4990680 2354122 2354122 defendant Spore John husbandman 605819 605819 Spore, John, of Preston by Faversham, husbandman 1
5375282 2467854 2467854 defendant Borwayssh Henry yeoman 605819 605819 Borwayssh, Henry, of Preston by Faversham, yeoman 1
5409490 2477803 2477803 defendant Boterford John chapman 605819 605819 Boterford, John, of Preston by Faversham, chapman 0
5422621 2481718 2481718 defendant Boterford John chapman 605819 605819 Boterford, John, of Preston by Faversham, chapman 0
5422623 2481719 2481719 defendant Boterford John chapman 605819 605819 Boterford, John, of Preston by Faversham, chapman 0
5423051 2481847 2481847 defendant Boterford John chapman 605819 605819 Boterford, John, of Preston by Faversham, chapman 0
5456261 2491787 2491787 defendant Burghways Henry husbandman 605819 605819 Burghways, Henry, of Preston by Faversham, husbandman 0
5470914 2496233 2496233 defendant Burrey Richard husbandman 605819 605819 Burrey, Richard, of Preston by Faversham, husbandman 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);