names

33 rows where place_id = 601471

✎ 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
3645521 1908996 1908996 defendant Shorter John yeoman 601471 601471 Shorter, John,of Chedyngfold, yeoman 2
3660434 1913523 1913523 defendant Gamlyn Stephen husbandman 601471 601471 Gamlyn, Stephen, of Chedyngfold, husbandman 0
3704690 1927754 1927754 defendant Slade Thomas yeoman 601471 601471 Slade, Thomas, of Chedyngfold, yeoman 0
3710509 1929609 1929609 defendant A Borough Thomas yeoman 601471 601471 A Borough, Thomas, of Chedyngfold, yeoman 0
3710512 1929610 1929610 defendant A Borough Thomas yeoman 601471 601471 A Borough, Thomas, of Chedyngfold, yeoman 0
3718686 1932125 1932125 defendant Slade Thomas yeoman 601471 601471 Slade, Thomas, of Chedyngfold, yeoman 0
3718692 1932126 1932126 defendant Slade Thomas yeoman 601471 601471 Slade, Thomas, of Chedyngfold, yeoman 0
3778360 1950945 1950945 defendant Holwey Barnard husbandman 601471 601471 Holwey, Barnard, of Chedyngfold, husbandman 0
3838731 1970042 1970042 defendant Ropley John husbandman 601471 601471 Ropley, John, of Chedyngfold, husbandman 4
3845914 1972279 1972279 defendant Wellys John yeoman 601471 601471 Wellys, John, of Chedyngfold, yeoman 0
3849407 1973412 1973412 defendant Shorter John, junior   601471 601471 Shorter, John, junior, of Chedyngfold, glass carrier 0
3869262 1979962 1979962 defendant Repley John husbandman 601471 601471 Repley, John, of Chedyngfold, husbandman 1
3875407 1982021 1982021 defendant Anteknap Thomas   601471 601471 Anteknap, Thomas, of Chedyngfold 0
3875413 1982022 1982022 defendant Anteknapp Thomas   601471 601471 Anteknapp, Thomas, of Chedyngfold 0
3876755 1982468 1982468 defendant Paytowe Thomas yeoman 601471 601471 Paytowe, Thomas, of Chedyngfold, yeoman 0
3876756 1982468 1982468 defendant Welles John yeoman 601471 601471 Welles, John, of Chedyngfold, yeoman 1
3913848 1994978 1994978 defendant Ropley John yeoman 601471 601471 Ropley, John, of Chedyngfold, yeoman 0
3914665 1995249 1995249 defendant Cok Thomas shoemaker 601471 601471 Cok, Thomas, of Chedyngfold, shoemaker 0
3916158 1995789 1995789 defendant Ropley John husbandman 601471 601471 Ropley, John, of Chedyngfold, husbandman 0
3916160 1995790 1995790 defendant Ropley John husbandman 601471 601471 Ropley, John, of Chedyngfold, husbandman 0
4024158 2033344 2033344 defendant Wynter John yeoman 601471 601471 Wynter, John, of Chedyngfold, yeoman 1
4176291 2087185 2087185 defendant Cowrtneshe John yeoman 601471 601471 Cowrtneshe, John, of Chedyngfold, yeoman 0
4819353 2302127 2302127 defendant Hoper John, junior   601471 601471 Hoper, John, junior, of Chedyngfold, white leather maker 2
4819356 2302127 2302127 defendant Gobayer Robeort laborer 601471 601471 Gobayer, Robeort, of Chedyngfold, laborer 5
4904877 2328126 2328126 defendant Cosewell John husbandman 601471 601471 Cosewell, John, of Chedyngfold, husbandman 0
4926122 2334597 2334597 defendant Hasburre Richard husbandman 601471 601471 Hasburre, Richard, of Chedyngfold, husbandman 0
5217002 2420713 2420713 defendant Reynold John gent 601471 601471 Reynold, John, of Chedyngfold, gent 0
5217003 2420713 2420713 defendant Sherter John carpenter 601471 601471 Sherter, John, of Chedyngfold, carpenter 1
5269131 2436075 2436075 defendant Bocher William butcher 601471 601471 Bocher, William, of Chedyngfold, butcher 0
5328654 2453650 2453650 defendant Benyfold Thomas husbandman 601471 601471 Benyfold, Thomas, of Chedyngfold, husbandman 1
5448391 2489414 2489414 defendant Gapson Robert husbandman 601471 601471 Gapson, Robert, of Chedyngfold, husbandman 0
5448393 2489414 2489414 defendant Ropley William tanner 601471 601471 Ropley, William, of Chedyngfold, tanner 2
5601023 2535205 2535205 defendant Quynell Peter yeoman 601471 601471 (Quynell, Peter, of Chedyngfold, yeoman 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);