names

71 rows where place_id = 587721

✎ 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
3592220 1865183 1865183 defendant Bell John yeoman 587721 587721 Bell, John, of Toynton, yeoman 0
3592221 1865183 1865183 defendant Burton William yeoman 587721 587721 Burton, William, of Toynton, yeoman 1
3592222 1865183 1865183 defendant Burton John yeoman 587721 587721 Burton, John, of Toynton, yeoman 2
3672055 1917261 1917261 defendant Eger Robert drover 587721 587721 Eger, Robert, of Toynton, drover 0
3672057 1917262 1917262 defendant Eger Robert drover 587721 587721 Eger, Robert, of Toynton, drover 0
3679433 1919633 1919633 defendant Rawson John husbandman 587721 587721 Rawson, John, of Toynton, husbandman 0
3679437 1919634 1919634 defendant Rawson John husbandman 587721 587721 Rawson, John, of Toynton, husbandman 1
3693680 1924216 1924216 defendant Rawson John drover or yeoman 587721 587721 Rawson, John, of Toynton, drover or yeoman 0
3733398 1936682 1936682 defendant Mylner James yeoman 587721 587721 Mylner, James, of Toynton, yeoman 0
3799565 1957784 1957784 defendant Sherp Henry glover 587721 587721 Sherp, Henry, of Toynton, glover 2
3825393 1965793 1965793 defendant Rose Martin chaplain 587721 587721 Rose, Martin, of Toynton, chaplain 0
3959907 2010560 2010560 defendant West Michael yeoman 587721 587721 West, Michael, of Toynton, clerk, or of Boston, yeoman 0
3970821 2014380 2014380 defendant Pyersall Henry yeoman 587721 587721 Pyersall, Henry, of Toynton, yeoman 3
3991066 2021568 2021568 defendant Curteys William gent 587721 587721 Curteys, William, of Toynton, gent 0
4025521 2033783 2033783 defendant Mallett Thomas gent 587721 587721 (Mallett, Thomas, of Toynton, gent 1
4025527 2033784 2033784 defendant Mallett Thomas gent 587721 587721 (Mallett, Thomas, of Toynton, gent 1
4037854 2038191 2038191 defendant Overey Thomas yeoman 587721 587721 Overey, Thomas, of Toynton, yeoman 0
4063419 2047205 2047205 defendant Egar Libeus yeoman 587721 587721 Egar, Libeus, of Toynton, yeoman 0
4063420 2047205 2047205 defendant Cave Richard yeoman 587721 587721 Cave, Richard, of Toynton, yeoman 1
4077101 2052092 2052092 defendant Persall Henry gent 587721 587721 Persall, Henry, of Toynton, gent 2
4081777 2053787 2053787 defendant Howson John clerk 587721 587721 Howson, John, of Toynton, clerk 0
4095176 2058598 2058598 defendant Cave Richard yeoman 587721 587721 Cave, Richard, of Toynton, yeoman 1
4095177 2058598 2058598 defendant Egar Libeus yeoman 587721 587721 Egar, Libeus, of Toynton, yeoman 2
4096141 2058948 2058948 defendant Cave Richard yeoman 587721 587721 Cave, Richard, of Toynton, yeoman 1
4096142 2058948 2058948 defendant Egar Libeus yeoman 587721 587721 Egar, Libeus, of Toynton, yeoman 2
4104156 2061760 2061760 defendant Overey Thomas yeoman 587721 587721 Overey, Thomas, of Toynton, yeoman 0
4105117 2062103 2062103 defendant Taylor alias Aveson John laborer 587721 587721 Taylor alias Aveson, John, of Toynton, laborer 0
4139070 2074343 2074343 defendant Curteys William gent 587721 587721 Curteys, William, of Toynton, gent 0
4141570 2075215 2075215 defendant Curteys William gent 587721 587721 Curteys, William, of Toynton, gent 0
4145317 2076523 2076523 defendant Pickeringe John yeoman 587721 587721 Pickeringe, John, of Toynton, yeoman 0
4163762 2082852 2082852 defendant Curteys William gent 587721 587721 Curteys, William, of Toynton, gent 0
4171295 2085421 2085421 defendant Curteys William gent 587721 587721 Curteys, William, of Toynton, gent 0
4182486 2089352 2089352 defendant Bucke William, junior yeoman 587721 587721 Bucke, William, junior, of Toynton, yeoman 0
4182487 2089352 2089352 defendant Wydall Charles yeoman 587721 587721 Wydall, Charles, of Toynton, yeoman 1
4189912 2091973 2091973 defendant Curteys William gent 587721 587721 Curteys, William, of Toynton, gent 0
4190330 2092135 2092135 defendant Becke John husbandman 587721 587721 Becke, John, of Toynton, husbandman 1
4194473 2093618 2093618 defendant Curteys William gent 587721 587721 Curteys, William, of Toynton, gent 0
4232265 2106788 2106788 defendant Curteys William gent 587721 587721 Curteys, William, of Toynton, gent 0
4275174 2121262 2121262 defendant West Michael yeoman 587721 587721 West, Michael, of Toynton, yeoman 2
4275175 2121262 2121262 defendant Hall Thomas yeoman 587721 587721 Hall, Thomas, of Toynton, yeoman 3
4275197 2121266 2121266 defendant Evun Edward yeoman 587721 587721 Evun, Edward, of Toynton, yeoman 3
4278923 2122562 2122562 defendant Warter John yeoman 587721 587721 Warter, John, of Toynton, yeoman 0
4338909 2143362 2143362 defendant Johnson William yeoman 587721 587721 Johnson, William, of Toynton, yeoman 2
4345747 2145781 2145781 defendant Bowes Mathew husbandman 587721 587721 Bowes, Mathew, of Toynton, husbandman 2
4543040 2213714 2213714 defendant Belle Robert   587721 587721 Belle, Robert, of Toynton 0
4671822 2256833 2256833 defendant Egre Joan widow 587721 587721 Egre, Joan, of Toynton, widow 4
4675563 2257966 2257966 defendant Bekes William husbandman 587721 587721 Bekes, William, of Toynton, husbandman 0
4704168 2266682 2266682 plaintiff Huberd Robert   587721 587721 Huberd, Robert, of Toynton 0
4810837 2299514 2299514 defendant Herryson John husbandman 587721 587721 Herryson, John, of Toynton, husbandman 0
4835720 2307169 2307169 defendant Jonson Richardson William husbandman 587721 587721 Jonson Richardson, William, of Toynton, husbandman 0
4837138 2307568 2307568 plaintiff Flee Joan   587721 587721 Flee, Joan, of Toynton 0
4839117 2308164 2308164 defendant Katrynson William potter 587721 587721 Katrynson, William, of Toynton, potter 0
4839118 2308164 2308164 defendant Katrynson John yeoman 587721 587721 Katrynson, John, of Toynton, yeoman 1
4856844 2313517 2313517 defendant Gelle John fisher 587721 587721 Gelle, John, of Toynton, fisher 1
4876756 2319703 2319703 defendant Rychardson William fisher 587721 587721 Rychardson, William, of Toynton, fisher 0
4884334 2322004 2322004 defendant Hykson John husbandman 587721 587721 Hykson, John, of Toynton, husbandman 7
4890392 2323763 2323763 defendant Jonson William husbandman 587721 587721 Jonson, William, of Toynton, husbandman 0
4926318 2334655 2334655 defendant Buttermouth Henry husbandman 587721 587721 Buttermouth, Henry, of Toynton, husbandman 2
4955311 2343544 2343544 defendant Watkynson John, junior fisher 587721 587721 Watkynson, John, junior, of Toynton, fisher 5
5072868 2378370 2378370 defendant Botyrmouth Henry husbandman 587721 587721 Botyrmouth, Henry, of Toynton, husbandman 0
5115250 2390886 2390886 defendant Watson Walter husbandman 587721 587721 Watson, Walter, of Toynton, husbandman 1
5137846 2397582 2397582 plaintiff Pynder John   587721 587721 Pynder, John, of Toynton 0
5158552 2403622 2403622 plaintiff Pynder John   587721 587721 Pynder, John, of Toynton 0
5194458 2414106 2414106 plaintiff Pynder John   587721 587721 Pynder, John, of Toynton 0
5231431 2424780 2424780 plaintiff Bocher William   587721 587721 Bocher, William, of Toynton 0
5264834 2434762 2434762 defendant Lound William fisher 587721 587721 Lound, William, of Toynton, fisher 1
5304704 2446402 2446402 defendant Taillour Richard husbandman 587721 587721 Taillour, Richard, of Toynton, husbandman 3
5487283 2501095 2501095 defendant Welby Thomas husbandman 587721 587721 Welby, Thomas, of Toynton, husbandman 0
5564983 2524345 2524345 defendant Wright John husbandman 587721 587721 Wright, John, of Toynton, husbandman 2
5574003 2526959 2526959 defendant Fulstowe Richard merchant of the staple 587721 587721 Fulstowe, Richard, of Toynton, merchant of the staple 0
5631461 2553847 2553847 defendant Goose Walter husbandman 587721 587721 Goose, Walter, of Toynton, husbandman 2

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);