names

58 rows where place_id = 664919

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3974764 2015738 2015738 defendant Wylse Thomas butcher 664919 664919 Wylse, Thomas, of Dymocke, butcher 0
3980699 2017859 2017859 defendant Forster Humphrey esq 664919 664919 Forster, Humphrey, of Dymocke, esq 0
4021422 2032388 2032388 defendant Wylse John yeoman 664919 664919 Wylse, John, of Dymocke, yeoman 0
4023443 2033092 2033092 plaintiff Barston Florence gent 664919 664919 Barston, Florence, of Dymocke, gent 0
4023445 2033093 2033093 plaintiff Barston Florence gent 664919 664919 Barston, Florence, of Dymocke, gent 0
4067235 2048579 2048579 defendant Taylor John yeoman 664919 664919 Taylor, John, of Dymocke, yeoman 1
4092571 2057650 2057650 defendant Davys John yeoman 664919 664919 Davys, John, of Dymocke, yeoman 0
4098337 2059733 2059733 defendant Hill Guy husbandman 664919 664919 Hill, Guy, of Dymocke, husbandman 0
4100521 2060512 2060512 defendant Haukyns William yeoman 664919 664919 Haukyns, William, of Dymocke, yeoman 1
4100522 2060512 2060512 defendant Hyll William yeoman 664919 664919 Hyll, William, of Dymocke, yeoman 2
4109227 2063558 2063558 defendant Syblys John yeoman 664919 664919 Syblys, John, of Dymocke, yeoman 0
4123441 2068686 2068686 defendant Brodforde Thomas gent 664919 664919 Brodforde, Thomas, of Dymocke, gent 0
4146478 2076919 2076919 defendant Weale Thomas yeoman 664919 664919 Weale, Thomas, of Dymocke, yeoman 1
4157917 2080840 2080840 defendant Foster Humphrey esq 664919 664919 Foster, Humphrey, of Dymocke, esq 0
4170947 2085320 2085320 defendant Coulsey Walter clerk 664919 664919 Coulsey, Walter, of Dymocke, clerk 0
4170952 2085321 2085321 defendant Coulsey Walter clerk 664919 664919 Coulsey, Walter, of Dymocke, clerk 0
4181742 2089094 2089094 defendant Barston John gent 664919 664919 Barston, John, of Dymocke, gent 2
4181746 2089095 2089095 defendant Barston John gent 664919 664919 Barston, John, of Dymocke, gent 2
4181756 2089098 2089098 defendant Barston John gent 664919 664919 Barston, John, of Dymocke, gent 2
4181760 2089099 2089099 defendant Barston John gent 664919 664919 Barston, John, of Dymocke, gent 2
4186996 2090945 2090945 defendant Gundy Richard yeoman 664919 664919 Gundy, Richard, of Dymocke, yeoman 1
4186997 2090945 2090945 defendant Ryley Thomas yeoman 664919 664919 Ryley, Thomas, of Dymocke, yeoman 2
4187039 2090958 2090958 defendant Cowper John husbandman 664919 664919 Cowper, John, of Dymocke, husbandman 1
4189559 2091849 2091849 defendant Underwood William yeoman 664919 664919 Underwood, William, of Dymocke, yeoman 0
4189560 2091849 2091849 defendant Spaldynge John   664919 664919 Spaldynge, John, of Dymocke 1
4189561 2091849 2091849 defendant Drynckewater Robert yeoman 664919 664919 Drynckewater, Robert, of Dymocke, yeoman 2
4189562 2091849 2091849 defendant Marten Jerome yeoman 664919 664919 Marten, Jerome, of Dymocke, yeoman 3
4195642 2094029 2094029 defendant Addys Thomas husbandman 664919 664919 Addys, Thomas, of Dymocke, husbandman 1
4199558 2095395 2095395 defendant Clarke Richard yeoman 664919 664919 Clarke, Richard, of Dymocke, yeoman 0
4242376 2110450 2110450 defendant Davies John yeoman 664919 664919 Davies, John, of Dymocke, yeoman 0
4305331 2132004 2132004 defendant Davys John husbandman 664919 664919 Davys, John, of Dymocke, husbandman 0
4306369 2132371 2132371 defendant Wilse Thomas butcher 664919 664919 Wilse, Thomas, of Dymocke, butcher 0
4309082 2133332 2133332 defendant Gundy Richard husbandman 664919 664919 Gundy, Richard, of Dymocke, husbandman 0
4309083 2133332 2133332 defendant Gundy William   664919 664919 Gundy, William, of Dymocke, husbandman, his son 1
4309085 2133333 2133333 defendant Gundy Richard yeoman 664919 664919 Gundy, Richard, of Dymocke, yeoman 0
4309086 2133333 2133333 defendant Gundy William   664919 664919 Gundy, William, of Dymocke, yeoman, his son 1
4310186 2133718 2133718 defendant Clarke John yeoman 664919 664919 Clarke, John, of Dymocke, yeoman 2
4310187 2133718 2133718 defendant Good alias Bauldwyn Thomas yeoman 664919 664919 Good alias Bauldwyn, Thomas, of Dymocke, yeoman 3
4323189 2138170 2138170 defendant Wilse Thomas butcher 664919 664919 Wilse, Thomas, of Dymocke, butcher 2
4334093 2141683 2141683 defendant Morrell John yeoman 664919 664919 Morrell, John, of Dymocke, yeoman 1
4334094 2141683 2141683 defendant Parkins William   664919 664919 Parkins, William, of Dymocke, mason 2
4334095 2141683 2141683 defendant Skynner John yeoman 664919 664919 Skynner, John, of Dymocke, yeoman 3
4368609 2153823 2153823 defendant Searche John yeoman 664919 664919 Searche, John, of Dymocke, yeoman 0
4368610 2153823 2153823 defendant Bache Richard yeoman 664919 664919 Bache, Richard, of Dymocke, yeoman 1
4368611 2153823 2153823 defendant Wheler William yeoman 664919 664919 Wheler, William, of Dymocke, yeoman 2
4368612 2153823 2153823 defendant Cole Robert yeoman 664919 664919 togehter with Cole, Robert, of Dymocke, yeoman 3
4368669 2153844 2153844 defendant Wilse Thomas butcher 664919 664919 Wilse, Thomas, of Dymocke, butcher 0
4370237 2154416 2154416 defendant Gundy Richard yeoman 664919 664919 Gundy, Richard, of Dymocke, yeoman 0
4370238 2154416 2154416 defendant Gundy William   664919 664919 Gundy, William, of Dymocke, yeoman, his son 1
4373128 2155457 2155457 defendant Dynkwater Robert husbandman 664919 664919 Dynkwater, Robert, of Dymocke, husbandman 0
4381648 2158546 2158546 defendant Morrell Richard husbandman 664919 664919 Morrell, Richard, of Dymocke, husbandman 0
4384899 2159639 2159639 defendant Hill John yeoman 664919 664919 Hill, John, of Dymocke, yeoman 2
4392810 2162212 2162212 defendant Gundie or Gundye Richard yeoman 664919 664919 Gundie or Gundye, Richard, of Dymocke, yeoman 0
4392811 2162212 2162212 defendant Gundye William   664919 664919 Gundye, William, of Dymocke, yeoman, his son 1
4396302 2163338 2163338 defendant Davis John yeoman 664919 664919 Davis, John, of Dymocke, yeoman 1
4396313 2163341 2163341 defendant Davis John yeoman 664919 664919 Davis, John, of Dymocke, yeoman 2
4404179 2165968 2165968 defendant Serche John yeoman 664919 664919 Serche, John, of Dymocke, yeoman 0
4412055 2168623 2168623 defendant Donne Christopher clothier 664919 664919 Donne, Christopher, of Dymocke, yeoman, or of Newent, clothier 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);