names

28 rows where place_id = 598095

✎ 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
3631118 1904553 1904553 defendant Stoperfeld Nicholas husbandman 598095 598095 Stoperfeld, Nicholas, of Hadloo, husbandman 0
3631119 1904553 1904553 defendant Asschedown John husbandman 598095 598095 Asschedown, John, of Hadloo, husbandman 1
3631120 1904553 1904553 defendant Myllis Richard carpenter 598095 598095 Myllis, Richard, of Hadloo, carpenter 2
3672243 1917317 1917317 defendant Broke John butcher 598095 598095 Broke, John, of Hadloo, butcher 0
3685902 1921749 1921749 plaintiff Berworth Thomas   598095 598095 Berworth, Thomas, of Hadloo 0
3689446 1922857 1922857 defendant Pyrry John yeoman 598095 598095 Pyrry, John, of Hadloo, yeoman 3
3689447 1922857 1922857 defendant Horn Richard husbandman 598095 598095 Horn, Richard, of Hadloo, husbandman 4
3700947 1926544 1926544 plaintiff Bereworth Thomas   598095 598095 Bereworth, Thomas, of Hadloo 0
3717535 1931773 1931773 defendant Chaundler Walter miller 598095 598095 Chaundler, Walter, of Hadloo, miller 0
3724560 1933966 1933966 defendant Style Walter husbandman 598095 598095 Style, Walter, of Hadloo, husbandman 3
3727737 1934945 1934945 defendant Stile John yeoman 598095 598095 Stile, John, of Hadloo, yeoman 1
3727738 1934945 1934945 defendant Stile Walter yeoman 598095 598095 Stile, Walter, of Hadloo, yeoman 2
3861176 1977215 1977215 defendant Coper William husbandman 598095 598095 Coper, William, of Hadloo, husbandman 0
4521072 2206929 2206929 plaintiff Fromund Thomas   598095 598095 Fromund, Thomas, of Hadloo 0
4521074 2206929 2206929 defendant Hardyng Thomas   598095 598095 Hardyng, Thomas, of Hadloo 0
4896905 2325684 2325684 defendant Daunce John yeoman 598095 598095 Daunce, John, of Hadloo, yeoman 3
4906826 2328719 2328719 defendant Gambon John carpenter 598095 598095 Gambon, John, of Hadloo, carpenter 0
4938751 2338508 2338508 defendant Caylthe or Caylche John husbandman 598095 598095 Caylthe or Caylche, John, of Hadloo, husbandman 1
5214642 2420012 2420012 defendant Mayn John fuller 598095 598095 Mayn, John, of Hadloo, fuller 0
5249036 2429842 2429842 defendant Mayn John fuller 598095 598095 Mayn, John, of Hadloo, fuller 0
5300166 2445012 2445012 defendant Walsho John laborer 598095 598095 Walsho, John, of Hadloo, laborer 0
5486055 2500714 2500714 defendant Neweman John   598095 598095 Neweman, John, of Hadloo, "polenter" 0
5486084 2500721 2500721 defendant Neweman John   598095 598095 Neweman, John, of Hadloo, "polenter" 0
5588392 2531372 2531372 defendant Burgeys Thomas thatcher or husbandman 598095 598095 Burgeys, Thomas, of Hadloo, thatcher or husbandman 0
5596066 2533684 2533684 defendant Forman Thomas tanner 598095 598095 Forman, Thomas, of Hadloo, tanner 0
5596067 2533684 2533684 defendant Thomas Edward chapman 598095 598095 Thomas, Edward, of Hadloo, chapman 1
5596068 2533684 2533684 defendant Broke John butcher 598095 598095 Broke, John, of Hadloo, butcher 2
5606729 2536985 2536985 defendant Carpenter Walter husbandman 598095 598095 Carpenter, Walter, of Hadloo, husbandman 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);