names

22 rows where place_id = 630905

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3797347 1957060 1957060 defendant Woddeshawe Thomas gent 630905 630905 Woddeshawe, Thomas, of Downton, gent 0
3797352 1957060 1957060 defendant Wyse Richard barber 630905 630905 Wyse, Richard, of Downton, barber 5
3855052 1975207 1975207 defendant Meryke Alan chaplain 630905 630905 Meryke, Alan, of Downton, chaplain 0
4004069 2026228 2026228 defendant Heynes Ralph tailor 630905 630905 Heynes, Ralph, of Downton, tailor 5
4057700 2045137 2045137 defendant Haynes Ralph yeoman 630905 630905 Haynes, Ralph, of Downton, yeoman 0
4062136 2046744 2046744 defendant Stockman John gent 630905 630905 Stockman, John, of Downton, gent 0
4066564 2048335 2048335 plaintiff Hopton Edward gent 630905 630905 Hopton, Edward, of Downton, gent 0
4112829 2064854 2064854 defendant Mathewe Tristram gent 630905 630905 Mathewe, Tristram, of Downton, gent 0
4138249 2074047 2074047 defendant Mathew Edmund gent 630905 630905 Mathew, Edmund, of Downton, gent 0
4149830 2078068 2078068 defendant Hopton William (legal representative) 630905 630905 Hopton, William, of Downton, esq, executors of 0
4155979 2080166 2080166 defendant Heyne Ralph yeoman 630905 630905 Heyne, Ralph, of Downton, yeoman 0
4185252 2090351 2090351 defendant Champyon William husbandman 630905 630905 Champyon, William, of Downton, husbandman 0
4185253 2090351 2090351 defendant Randoll John husbandman 630905 630905 Randoll, John, of Downton, husbandman 1
4239477 2109432 2109432 defendant Norwick alias Garensey Thomas shoemaker 630905 630905 Norwick alias Garensey, Thomas, of Downton, shoemaker 0
4297520 2129213 2129213 defendant Evans Nicholas yeoman 630905 630905 Evans, Nicholas, of Downton, yeoman 2
4360575 2150951 2150951 defendant Eastman Walter yeoman 630905 630905 Eastman, Walter, of Downton, yeoman 0
4361454 2151258 2151258 defendant Hickson William yeoman 630905 630905 Hickson, William, of Downton, yeoman 0
4366575 2153094 2153094 defendant Deane Clement yeoman 630905 630905 Deane, Clement, of Downton, yeoman 0
4378491 2157378 2157378 defendant Gawntlett Simon yeoman 630905 630905 Gawntlett, Simon, of Downton, yeoman 0
5071726 2378034 2378034 defendant Bolyn William painter 630905 630905 Bolyn, William, of Downton, painter 0
5356441 2462082 2462082 defendant Willyams John husbandman 630905 630905 Willyams, John, of Downton, husbandman 0
5602914 2535799 2535799 defendant Richardys Thomas yeoman 630905 630905 Richardys, Thomas, of Downton, 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);