names

72 rows where place_id = 588535

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594855 1866020 1866020 defendant Dorkyng William husbandman 588535 588535 Dorkyng, William, of Fletchyng, husbandman 0
3658525 1912920 1912920 defendant Rowland John yeoman 588535 588535 Rowland, John, of Fletchyng, yeoman 0
3658526 1912920 1912920 defendant Hawkyns John laborer 588535 588535 Hawkyns, John, of Fletchyng, laborer 1
3658527 1912920 1912920 defendant Balcombe John laborer 588535 588535 Balcombe, John, of Fletchyng, laborer 2
3658528 1912920 1912920 defendant Benge Richard laborer 588535 588535 Benge, Richard, of Fletchyng, laborer 3
3658529 1912920 1912920 defendant Gater John laborer 588535 588535 Gater, John, of Fletchyng, laborer 4
3664401 1914816 1914816 defendant Balcombe John laborer 588535 588535 Balcombe, John, of Fletchyng, laborer 2
3664402 1914816 1914816 defendant Benge Richard laborer 588535 588535 Benge, Richard, of Fletchyng, laborer 3
3664403 1914816 1914816 defendant Gater John laborer 588535 588535 Gater, John, of Fletchyng, laborer 4
3698599 1925778 1925778 defendant Stonestrete Richard laborer 588535 588535 Stonestrete, Richard, of Fletchyng, laborer 3
3703743 1927450 1927450 defendant Lokk John yeoman 588535 588535 Lokk, John, of Fletchyng, yeoman 0
3708964 1929096 1929096 defendant Verall Thomas yeoman 588535 588535 Verall, Thomas, of Fletchyng, yeoman 0
3712183 1930127 1930127 defendant Stonestrete Richard laborer 588535 588535 Stonestrete, Richard, of Fletchyng, laborer 3
3712195 1930130 1930130 defendant Wynter Thomas laborer 588535 588535 Wynter, Thomas, of Fletchyng, laborer 0
3712201 1930131 1930131 defendant Wynter Thomas laborer 588535 588535 Wynter, Thomas, of Fletchyng, laborer 0
3789009 1954374 1954374 defendant Lawnder George husbandman 588535 588535 Lawnder, George, of Fletchyng, husbandman 0
3805118 1959543 1959543 defendant Afforde William yeoman 588535 588535 Afforde, William, of Fletchyng, yeoman 0
3816635 1963104 1963104 defendant Tye John laborer 588535 588535 Tye, John, of Fletchyng, laborer 2
3816637 1963105 1963105 defendant Skynner John laborer 588535 588535 Skynner, John, of Fletchyng, laborer 0
3818480 1963679 1963679 defendant Cowper Nicholas   588535 588535 Cowper, Nicholas, of Fletchyng, wheel wright 0
3830672 1967476 1967476 defendant Burton John butcher 588535 588535 Burton, John, of Fletchyng, butcher 0
3864511 1978330 1978330 defendant Harte William   588535 588535 Harte, William, of Fletchyng, red lead maker 0
3871182 1980615 1980615 defendant Wykersham Robert husbandman 588535 588535 Wykersham, Robert, of Fletchyng, husbandman 0
3871183 1980615 1980615 defendant Awocke William husbandman 588535 588535 Awocke, William, of Fletchyng, husbandman 1
3879151 1983280 1983280 defendant Aforde William glover 588535 588535 Aforde, William, of Fletchyng, glover 1
3885992 1985566 1985566 defendant Byrde John husbandman 588535 588535 Byrde, John, of Fletchyng, husbandman 4
3895720 1988775 1988775 defendant Staple Thomas husbandman 588535 588535 Staple, Thomas, of Fletchyng, husbandman 1
3895723 1988776 1988776 defendant Staple Thomas husbandman 588535 588535 Staple, Thomas, of Fletchyng, husbandman 1
3903144 1991279 1991279 defendant Lokke Thomas butcher 588535 588535 Lokke, Thomas, of Fletchyng, butcher 0
3908134 1993018 1993018 defendant Stydolff John yeoman 588535 588535 Stydolff, John, of Fletchyng, yeoman 0
3908135 1993018 1993018 defendant Turke William yeoman 588535 588535 Turke, William, of Fletchyng, yeoman 1
3910404 1993797 1993797 defendant Gavell Thomas mercer 588535 588535 Gavell, Thomas, of Fletchyng, mercer 0
3916367 1995856 1995856 defendant Hother Thomas laborer 588535 588535 Hother, Thomas, of Fletchyng, laborer 0
3943896 2004974 2004974 defendant Yeman Richard yeoman 588535 588535 Yeman, Richard, of Fletchyng, yeoman 0
3949657 2006955 2006955 defendant Uncle Peter collier 588535 588535 Uncle, Peter, of Fletchyng, collier 0
3949658 2006955 2006955 defendant Mare Clement collier 588535 588535 Mare, Clement, of Fletchyng, collier 1
3949659 2006955 2006955 defendant Crowte John collier 588535 588535 Crowte, John, of Fletchyng, collier 2
3950317 2007194 2007194 defendant Cowstock Thomas yeoman 588535 588535 Cowstock, Thomas, of Fletchyng, yeoman 3
3983373 2018827 2018827 defendant Wyllard Thomas yeoman 588535 588535 Wyllard, Thomas, of Fletchyng, yeoman 0
4071407 2050072 2050072 defendant Duplacke Gilbert yeoman 588535 588535 Duplacke, Gilbert, of Fletchyng, yeoman 0
4071408 2050072 2050072 defendant Dobson John mercer 588535 588535 Dobson, John, of Fletchyng, mercer 1
4077560 2052265 2052265 defendant Hawles John husbandman 588535 588535 Hawles, John, of Fletchyng, husbandman 1
4077561 2052265 2052265 defendant Streter Nicholas yeoman 588535 588535 Streter, Nicholas, of Fletchyng, yeoman 2
4082375 2054004 2054004 defendant Alcock James husbandman 588535 588535 Alcock, James, of Fletchyng, husbandman 1
4082376 2054004 2054004 defendant Vyrald John husbandman 588535 588535 Vyrald, John, of Fletchyng, husbandman 2
4082377 2054004 2054004 defendant Carr John husbandman 588535 588535 Carr, John, of Fletchyng, husbandman 3
4093176 2057877 2057877 defendant Rowland alias Mocomber William yeoman 588535 588535 Rowland alias Mocomber, William, of Fletchyng, yeoman 0
4097616 2059474 2059474 defendant Slowman Amos yeoman 588535 588535 Slowman, Amos, of Fletchyng, yeoman 0
4097617 2059474 2059474 defendant Awcock William yeoman 588535 588535 Awcock, William, of Fletchyng, yeoman 1
4097618 2059474 2059474 defendant Bryckenden William husbandman 588535 588535 Bryckenden, William, of Fletchyng, husbandman 2
4108337 2063239 2063239 defendant Slowman Amory weaver 588535 588535 Slowman, Amory, of Fletchyng, weaver 2
4135592 2073055 2073055 defendant Dyer Richard tailor 588535 588535 Dyer, Richard, of Fletchyng, tailor 0
4135593 2073055 2073055 defendant Harman John carpenter 588535 588535 Harman, John, of Fletchyng, carpenter 1
4140299 2074774 2074774 defendant Hawkes alias Oxley John collier 588535 588535 Hawkes alias Oxley, John, of Fletchyng, collier 0
4152422 2078956 2078956 defendant Hunte Roger husbandman 588535 588535 Hunte, Roger, of Fletchyng, husbandman 2
4153116 2079188 2079188 defendant Rickson Thomas husbandman 588535 588535 Rickson, Thomas, of Fletchyng, husbandman 2
4153119 2079189 2079189 defendant Stydolf Edward husbandman 588535 588535 Stydolf, Edward, of Fletchyng, husbandman 0
4182484 2089351 2089351 defendant Verall John husbandman 588535 588535 Verall, John, of Fletchyng, husbandman 0
4186025 2090600 2090600 defendant Castlyn John yeoman 588535 588535 Castlyn, John, of Fletchyng, yeoman 1
4186026 2090600 2090600 defendant Kenyon George yeoman 588535 588535 Kenyon, George, of Fletchyng, yeoman 2
4187647 2091182 2091182 defendant Baynbrooke Henry clerk 588535 588535 Baynbrooke, Henry, of Fletchyng, clerk 0
4187648 2091182 2091182 defendant Hunt George husbandman 588535 588535 Hunt, George, of Fletchyng, husbandman 1
4187649 2091182 2091182 defendant Rychardson Richard butcher 588535 588535 Rychardson, Richard, of Fletchyng, butcher 2
4187650 2091182 2091182 defendant Grenfeld Joan widow 588535 588535 Grenfeld, Joan, of Fletchyng, widow 3
4374625 2155985 2155985 defendant Kenyon George yeoman 588535 588535 Kenyon, George, of Fletchyng, yeoman 0
4767566 2285835 2285835 defendant Taillour John butcher 588535 588535 Taillour, John, of Fletchyng, butcher 0
4807891 2298652 2298652 defendant Gardyner John   588535 588535 Gardyner, John, of Fletchyng, bailiff 0
4825548 2304032 2304032 defendant Pynne Thomas baker 588535 588535 Pynne, Thomas, of Fletchyng, baker 0
4917388 2331953 2331953 defendant Budde John husbandman 588535 588535 Budde, John, of Fletchyng, husbandman 0
4917389 2331953 2331953 defendant Couper Nicholas butcher 588535 588535 Couper, Nicholas, of Fletchyng, butcher 1
5130531 2395412 2395412 defendant Durkyn Richard carpenter 588535 588535 Durkyn, Richard, of Fletchyng, carpenter 0
5516390 2509960 2509960 defendant Canell or Cavell Thomas husbandman 588535 588535 Canell or Cavell, Thomas, of Fletchyng, 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);