names

23 rows where place_id = 614517

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3704076 1927561 1927561 defendant Com William husbandman 614517 614517 Com, William, of Clyst Hydon, husbandman 0
3704078 1927562 1927562 defendant Comb William husbandman 614517 614517 Comb, William, of Clyst Hydon, husbandman 0
3704233 1927622 1927622 defendant Taylour Thomas husbandman 614517 614517 Taylour, Thomas, of Clyst Hydon, husbandman 1
3704234 1927622 1927622 defendant Taylour John laborer 614517 614517 Taylour, John, of Clyst Hydon, laborer 2
3717999 1931925 1931925 defendant Comb William husbandman 614517 614517 Comb, William, of Clyst Hydon, husbandman 0
3845674 1972192 1972192 defendant Pratt Robert, junior husbandman 614517 614517 Pratt, Robert, junior, of Clyst Hydon, husbandman 2
3875274 1981971 1981971 defendant Farraunt William husbandman 614517 614517 Farraunt, William, of Clyst Hydon, husbandman 0
3875759 1982143 1982143 defendant Farrante William husbandman 614517 614517 Farrante, William, of Clyst Hydon, husbandman 0
3916808 1995987 1995987 defendant Farrante William husbandman 614517 614517 Farrante, William, of Clyst Hydon, husbandman 0
3992995 2022242 2022242 defendant Adams Humphrey yeoman 614517 614517 Adams, Humphrey, of Clyst Hydon, yeoman 11
4473848 2192471 2192471 defendant Cook John   614517 614517 Cook, John, of Clyst Hydon 0
4984175 2352198 2352198 defendant Traunter Robert clerk 614517 614517 Traunter, Robert, of Clyst Hydon, clerk 0
5228347 2423901 2423901 defendant Saundyr Richard husbandman 614517 614517 Saundyr, Richard, of Clyst Hydon, husbandman 0
5250139 2430154 2430154 defendant Saundyr Richard husbandman 614517 614517 Saundyr, Richard, of Clyst Hydon, husbandman 0
5482997 2499857 2499857 defendant Waryn William husbandman 614517 614517 Waryn, William, of Clyst Hydon, husbandman 0
5482998 2499857 2499857 defendant Borough William husbandman 614517 614517 Borough, William, of Clyst Hydon, husbandman 1
5482999 2499857 2499857 defendant Kerslake William, senior husbandman 614517 614517 Kerslake, William, senior, of Clyst Hydon, husbandman 2
5483000 2499857 2499857 defendant Kyrslake Henry, junior husbandman 614517 614517 Kyrslake, Henry, junior, of Clyst Hydon, husbandman 3
5483001 2499857 2499857 defendant Tailder John husbandman 614517 614517 Tailder, John, of Clyst Hydon, husbandman 4
5483002 2499857 2499857 defendant Ewescote Stephen husbandman 614517 614517 Ewescote, Stephen, of Clyst Hydon, husbandman 5
5483003 2499857 2499857 defendant Forde Roger husbandman 614517 614517 Forde, Roger, of Clyst Hydon, husbandman 6
5489735 2501811 2501811 defendant Harryes Robert husbandman 614517 614517 Harryes, Robert, of Clyst Hydon, husbandman 0
5491858 2502473 2502473 defendant Chowne Robert husbandman 614517 614517 Chowne, Robert, of Clyst Hydon, husbandman 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);