names

19 rows where place_id = 588524

✎ 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
3594809 1866005 1866005 defendant Sandwyche John barker 588524 588524 Sandwyche, John, of Ersham, Norf, barker 0
3622972 1874713 1874713 defendant Sandewyche John barker 588524 588524 Sandewyche, John, of Ersham, Norf, barker 2
3664895 1914966 1914966 defendant Frenche Robert husbandman 588524 588524 Frenche, Robert, of Ersham, Norf, husbandman 0
3747833 1941245 1941245 defendant Martyn Henry miller 588524 588524 Martyn, Henry, of Ersham, Norf, miller 0
3773452 1949409 1949409 defendant Martyn Henry miller 588524 588524 Martyn, Henry, of Ersham, Norf, miller 0
3775920 1950219 1950219 defendant Smyth John husbandman 588524 588524 Smyth, John, of Ersham, Norf, husbandman 2
3775921 1950219 1950219 defendant Clarke Thomas   588524 588524 Clarke, Thomas, of Ersham, Norf, twill weaver 3
3833978 1968569 1968569 defendant Sayer John yeoman 588524 588524 Sayer, John, of Ersham, Norf, yeoman 0
3979183 2017304 2017304 defendant Jaye John tanner 588524 588524 Jaye, John, of Ersham, Norf, tanner 3
4308543 2133141 2133141 defendant Wolmer Robert yeoman 588524 588524 Wolmer, Robert, of Ersham, Norf, yeoman 1
4337600 2142896 2142896 defendant Story Richard yeoman 588524 588524 Story, Richard, of Ersham, Norf, yeoman 0
4864786 2315960 2315960 defendant Puwyn Henry husbandman 588524 588524 Puwyn, Henry, of Ersham, Norf, husbandman 1
4953110 2342894 2342894 defendant Fraunceys William laborer 588524 588524 Fraunceys, William, of Ersham, Norf, laborer 2
5035588 2367269 2367269 defendant Hache William miller 588524 588524 Hache, William, of Ersham, Norf, miller 2
5233290 2425323 2425323 defendant Bextere Richard yeoman 588524 588524 Bextere, Richard, of Ersham, Norf, yeoman 0
5475167 2497558 2497558 defendant Perkyn Robert husbandman 588524 588524 Perkyn, Robert, of Ersham, Norf, husbandman 0
5476329 2497924 2497924 defendant Worlyche Robert   588524 588524 Worlyche, Robert, of Ersham, Norf 0
5507957 2507384 2507384 defendant Wolrych Robert yeoman 588524 588524 Wolrych, Robert, of Ersham, Norf, yeoman 2
5607412 2537212 2537212 defendant Daldy Robert husbandman 588524 588524 (Daldy, Robert, of Ersham, Norf, husbandman 3

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);