names

18 rows where place_id = 600179

✎ 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
3640087 1907345 1907345 defendant Anger Clement husbandman 600179 600179 Anger, Clement, of Hilberworth, husbandman 2
3795503 1956474 1956474 defendant Snellyng William husbandman 600179 600179 Snellyng, William, of Hilberworth, husbandman 0
4064272 2047497 2047497 defendant Gayson John husbandman 600179 600179 Gayson, John, of Hilberworth, husbandman 0
4072249 2050375 2050375 defendant Pynner John husbandman 600179 600179 Pynner, John, of Hilberworth, husbandman 2
4547933 2215289 2215289 plaintiff Cavell or Canell William   600179 600179 Cavell or Canell, William, of Hilberworth 0
4833044 2306354 2306354 defendant Stede John yeoman 600179 600179 Stede, John, of Hilberworth, yeoman 0
4922150 2333340 2333340 defendant Stede Thomas husbandman 600179 600179 Stede, Thomas, of Hilberworth, husbandman 1
4939323 2338679 2338679 defendant Puttok Richard baker 600179 600179 Puttok, Richard, of Hilberworth, baker 2
5028139 2365102 2365102 plaintiff Michyll Henry yeoman 600179 600179 Michyll, Henry, of Hilberworth, yeoman 0
5028140 2365102 2365102 plaintiff Taylour Richard yeoman 600179 600179 Taylour, Richard, of Hilberworth, yeoman 1
5028141 2365102 2365102 plaintiff Frekenham John husbandman 600179 600179 Frekenham, John, of Hilberworth, husbandman 2
5096019 2385265 2385265 defendant Sharpyng John husbandman 600179 600179 Sharpyng, John, of Hilberworth, husbandman 1
5160761 2404244 2404244 defendant Turnour John husbandman 600179 600179 Turnour, John, of Hilberworth, husbandman 3
5175455 2408511 2408511 defendant Turnour John husbandman 600179 600179 Turnour, John, of Hilberworth, husbandman 3
5196664 2414777 2414777 defendant Turnour John husbandman 600179 600179 Turnour, John, of Hilberworth, husbandman 3
5196705 2414785 2414785 defendant Turnour John husbandman 600179 600179 Turnour, John, of Hilberworth, husbandman 3
5227525 2423675 2423675 defendant Mychell Henry husbandman 600179 600179 Mychell, Henry, of Hilberworth, husbandman 0
5292902 2442915 2442915 plaintiff Sechehith Richard (legal representative) 600179 600179 Sechehith, Richard, of Hilberworth, clerk, executor of 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);