names

48 rows where place_id = 594135

✎ 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
3614692 1872248 1872248 defendant Thymelby Richard esq 594135 594135 Thymelby, Richard, of Tydde St Mary, esq 0
3625190 1875413 1875413 defendant Odam John, senior husbandman 594135 594135 Odam, John, senior, of Tydde St Mary, husbandman 1
3625191 1875413 1875413 defendant Wilkyn Thomas husbandman 594135 594135 Wilkyn, Thomas, of Tydde St Mary, husbandman 2
3625192 1875413 1875413 defendant Monde Nicholas husbandman 594135 594135 Monde, Nicholas, of Tydde St Mary, husbandman 3
3625193 1875413 1875413 defendant Barton Richard husbandman 594135 594135 Barton, Richard, of Tydde St Mary, husbandman 4
3625194 1875413 1875413 defendant Edmundes Simon husbandman 594135 594135 Edmundes, Simon, of Tydde St Mary, husbandman 5
3854904 1975179 1975179 plaintiff Tydde Thomas (legal representative) 594135 594135 Tydde, Thomas, of Tydde St Mary, yeoman, executors of 0
3880583 1983766 1983766 defendant Gybson Richard yeoman 594135 594135 Gybson, Richard, of Tydde St Mary, yeoman 0
3942439 2004482 2004482 defendant Cotton William husbandman 594135 594135 Cotton, William, of Tydde st Mary, husbandman 3
4052450 2043296 2043296 defendant Wake Christopher clerk 594135 594135 Wake, Christopher, of Tydde St Mary, clerk 1
4094234 2058273 2058273 defendant Akers or Acres Robert yeoman 594135 594135 Akers or Acres, Robert, of Tydde St Mary, yeoman 1
4567761 2221482 2221482 defendant Elme John   594135 594135 Elme, John, of Tydde St Mary 0
4663808 2250164 2250164 defendant Fysshe Richard husbandman 594135 594135 Fysshe, Richard, of Tydde St Mary, husbandman 2
4698521 2265011 2265011 defendant Derby John chaplain 594135 594135 Derby, John, of Tydde St Mary, chaplain 3
4791000 2293276 2293276 defendant Wyseberd Richard husbandman 594135 594135 Wyseberd, Richard, of Tydde St Mary, husbandman 1
4795955 2294881 2294881 defendant Arnold Richard husbandman 594135 594135 Arnold, Richard, of Tydde St Mary, husbandman 0
4840351 2308527 2308527 defendant Battesson Thomas husbandman 594135 594135 Battesson, Thomas, of Tydde St Mary, husbandman 1
4863778 2315645 2315645 defendant Cokke Thomas husbandman 594135 594135 Cokke, Thomas, of Tydde St Mary, husbandman 0
4863779 2315645 2315645 defendant Whiteratte Richard husbandman 594135 594135 Whiteratte, Richard, of Tydde St Mary, husbandman 1
4875108 2319168 2319168 defendant Rethyrwyk Thomas husbandman 594135 594135 Rethyrwyk, Thomas, of Tydde St Mary, husbandman 1
4907972 2329050 2329050 defendant Arnald John husbandman 594135 594135 Arnald, John, of Tydde St mary, husbandman 4
4954052 2343176 2343176 defendant Deyres Thomas laborer 594135 594135 Deyres, Thomas, of Tydde St Mary, laborer 0
4982854 2351784 2351784 defendant atte Hall William husbandman 594135 594135 atte Hall, William, of Tydde St Mary, husbandman 1
4982855 2351784 2351784 defendant Bateson Thomas husbandman 594135 594135 Bateson, Thomas, of Tydde St Mary, husbandman 2
4982857 2351784 2351784 defendant Hunston John husbandman 594135 594135 Hunston, John, of Tydde St Mary, husbandman 4
5093211 2384407 2384407 defendant Fyn William husbandman 594135 594135 Fyn, William, of Tydde St Mary, husbandman 0
5093212 2384407 2384407 defendant Odam John husbandman 594135 594135 Odam, John, of Tydde St Mary, husbandman 1
5093626 2384532 2384532 defendant Theker Lawrence husbandman 594135 594135 Theker, Lawrence, of Tydde St Mary, husbandman 2
5093632 2384533 2384533 defendant Theker Lawrence husbandman 594135 594135 Theker, Lawrence, of Tydde St Mary, husbandman 2
5105086 2387922 2387922 defendant Thakker Lawrence husbandman 594135 594135 Thakker, Lawrence, of Tydde St Mary, husbandman 0
5186438 2411788 2411788 defendant Odam Nicholas panyer man 594135 594135 Odam, Nicholas, of Tydde St Mary, panyer man 0
5188572 2412379 2412379 defendant Veysy William carpenter 594135 594135 Veysy, William, of Tydde St Mary, carpenter 0
5188573 2412379 2412379 defendant Fynne John husbandman 594135 594135 Fynne, John, of Tydde St Mary, husbandman 1
5198050 2415172 2415172 defendant Hunston Richard husbandman 594135 594135 Hunston, Richard, of Tydde St Mary, husbandman 2
5205191 2417278 2417278 defendant Odam Nicholas yeoman 594135 594135 Odam, Nicholas, of Tydde St Mary, yeoman 0
5206220 2417553 2417553 defendant Veysy William carpenter 594135 594135 Veysy, William, of Tydde St Mary, carpenter 0
5215616 2420289 2420289 defendant Hunston John yeoman 594135 594135 (Hunston, John, of Tydde St Mary, yeoman 2
5215617 2420289 2420289 defendant Hunston Richard yeoman 594135 594135 Hunston, Richard, of Tydde St Mary, yeoman 3
5233586 2425416 2425416 defendant Yonge John chaplain 594135 594135 Yonge, John, of Tydde St Mary, chaplain 2
5255847 2431949 2431949 defendant Hunston John, junior husbandman 594135 594135 Hunston, John, junior, of Tydde St Mary, or of Sutton in Holand, husbandman 0
5339035 2456781 2456781 defendant Hunston Thomas gent 594135 594135 Hunston, Thomas, of Tydde St Mary, gent 0
5344190 2458360 2458360 plaintiff Themolby William (legal representative) 594135 594135 Themolby, William, of Tydde St Mary, administratrix of 0
5344192 2458360 2458360 defendant Whitratte John (legal representative) 594135 594135 Whitratte, John, of Tydde St Mary, administrator of 0
5345583 2458779 2458779 defendant Fyssher John   594135 594135 Fyssher, John, of Tydde St Mary, yeoman, administrators of 2
5345586 2458779 2458779 defendant Fyssher Richard husbandman 594135 594135 Fyssher, Richard, of Tydde St Mary, husbandman 5
5497465 2504183 2504183 defendant Hounston John, senior (legal representative) 594135 594135 Hounston, John, senior, of Tydde St Mary, yeoman, executor of 0
5537023 2516064 2516064 defendant Gowke Simon husbandman 594135 594135 Gowke, Simon, of Tydde St Mary, husbandman 3
5606320 2536872 2536872 defendant Akers John chapman 594135 594135 Akers, John, of Tydde St Mary, chapman 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);