names

35 rows where place_id = 671385

✎ 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
4001381 2025272 2025272 defendant Croche alias Hackford Thomas yeoman 671385 671385 Croche alias Hackford, Thomas, of Hackford, yeoman 0
4005434 2026722 2026722 defendant Adams Robert husbandman 671385 671385 Adams, Robert, of Hackford, husbandman 3
4014986 2030071 2030071 defendant Adams Robert husbandman 671385 671385 Adams, Robert, of Hackford, husbandman 12
4031166 2035817 2035817 defendant More Robert husbandman 671385 671385 More, Robert, of Hackford, husbandman 1
4037110 2037935 2037935 defendant Shemyng John clerk 671385 671385 Shemyng, John, of Hackford, clerk 2
4037115 2037936 2037936 defendant Shennyng John clerk 671385 671385 Shennyng, John, of Hackford, clerk 2
4087290 2055745 2055745 defendant Dewen Martin butcher 671385 671385 Dewen, Martin, of Hackford, butcher 1
4091006 2057074 2057074 plaintiff Crotche Thomas   671385 671385 Crotche, Thomas, of Hackford 0
4167248 2084048 2084048 defendant Underwood Thomas miller 671385 671385 Underwood, Thomas, of Hackford, or of Depham, miller 0
4167251 2084049 2084049 defendant Underwood Thomas miller 671385 671385 Underwood, Thomas, of Hackford, or of Derham, miller 0
4229556 2105825 2105825 defendant Cook Felix laborer 671385 671385 Cook, Felix, of Hackford, laborer 1
4229559 2105825 2105825 defendant Cowper John laborer 671385 671385 Cowper, John, of Hackford, laborer 4
4271673 2120107 2120107 defendant Dacke Henry yeoman 671385 671385 Dacke, Henry, of Hackford, yeoman 2
4274666 2121083 2121083 defendant Read Robert weaver 671385 671385 Read, Robert, of Hackford, weaver 0
4274668 2121083 2121083 defendant Griffyn Henry tailor 671385 671385 Griffyn, Henry, of Hackford, tailor 2
4284948 2124664 2124664 defendant Earytche or Garytche John   671385 671385 Earytche or Garytche, John, of Hackford, paten maker 0
4287018 2125409 2125409 defendant Freman Ralph miller 671385 671385 Freman, Ralph, of Hackford, miller 0
4287655 2125637 2125637 defendant Freman Ralph miller 671385 671385 Freman, Ralph, of Hackford, miller 1
4287871 2125710 2125710 defendant Dawes John yeoman 671385 671385 Dawes, John, of Hackford, yeoman 0
4340396 2143905 2143905 defendant Roos John clerk 671385 671385 Roos, John, of Hackford, clerk 0
4340397 2143905 2143905 defendant Dawes John yeoman 671385 671385 Dawes, John, of Hackford, yeoman 1
4347376 2146337 2146337 defendant Roos John clerk 671385 671385 Roos, John, of Hackford, clerk 0
4348826 2146850 2146850 defendant Roos John clerk 671385 671385 Roos, John, of Hackford, clerk 0
4348828 2146850 2146850 defendant Dawes John yeoman 671385 671385 Dawes, John, of Hackford, yeoman 2
4373585 2155621 2155621 defendant Hudson Richard beer brewer 671385 671385 Hudson, Richard, of Hackford, beer brewer 0
4376622 2156708 2156708 defendant Roose John clerk 671385 671385 Roose, John, of Hackford, clerk 0
4390234 2161356 2161356 defendant Sheppard Robert husbandman 671385 671385 Sheppard, Robert, of Hackford, husbandman 0
4395815 2163182 2163182 defendant Rosse John clerk 671385 671385 Rosse, John, of Hackford, clerk 1
4399455 2164405 2164405 defendant Dawes John husbandman 671385 671385 Dawes, John, of Hackford, husbandman 2
4399935 2164567 2164567 defendant Springolde Richard yeoman 671385 671385 Springolde, Richard, of Hackford, yeoman 0
4406713 2166813 2166813 defendant Cogman John gent 671385 671385 Cogman, John, of Hackford, gent 1
4407364 2167025 2167025 defendant Springold Richard yeoman 671385 671385 Springold, Richard, of Hackford, yeoman 0
4410685 2168166 2168166 defendant Dawes John yeoman 671385 671385 Dawes, John, of Hackford, yeoman 0
4410687 2168166 2168166 defendant Barneham William husbandman 671385 671385 Barneham, William, of Hackford, husbandman 2
4412612 2168807 2168807 defendant Edward John clerk 671385 671385 Edward, John, of Hackford, clerk 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);