names

508 rows where place_id = 588926

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591717 1865029 1865029 plaintiff Everard Simon   588926 588926 Everard, Simon, of North Elmham, exsecutors of 0
3596018 1866382 1866382 defendant Stamford John butcher 588926 588926 Stamford, John, of North Elmham, butcher 0
3596019 1866382 1866382 defendant Tytyng Robert husbandman 588926 588926 Tytyng, Robert, of North Elmham, husbandman 1
3596020 1866382 1866382 defendant Warner Thomas husbandman 588926 588926 Warner, Thomas, of North Elmham, husbandman 2
3596022 1866382 1866382 defendant Helley Walter husbandman 588926 588926 Helley, Walter, of North Elmham, husbandman 4
3597883 1866960 1866960 defendant Staunford John butcher 588926 588926 Staunford, John, of North Elmham, butcher 1
3598208 1867071 1867071 defendant Chamberleyn Roger yeoman 588926 588926 Chamberleyn, Roger, of North Elmham, yeoman 0
3598209 1867071 1867071 defendant Trendyll Thomas yeoman 588926 588926 Trendyll, Thomas, of North Elmham, yeoman 1
3598214 1867073 1867073 plaintiff Smyth Henry   588926 588926 Smyth, Henry, of North Elmham 0
3603438 1868740 1868740 defendant Grene Agnes (legal representative) 588926 588926 Grene, Agnes, of North Elmham, administrator of 7
3603439 1868740 1868740 defendant Larwode Thomas husbandman 588926 588926 Larwode, Thomas, of North Elmham, husbandman 8
3608335 1870265 1870265 defendant Roys Edmund husbandman 588926 588926 Roys, Edmund, of North Elmham, husbandman 0
3614219 1872114 1872114 defendant Larwode Thomas husbandman 588926 588926 Larwode, Thomas, of North Elmham, husbandman 1
3614567 1872206 1872206 plaintiff Soham John   588926 588926 (Soham, John, of North Elmham 1
3619810 1873769 1873769 defendant Taverner Nicholas yeoman 588926 588926 Taverner, Nicholas, of North Elmham, yeoman 2
3621898 1874392 1874392 defendant Trendell Richard husbandman 588926 588926 Trendell, Richard, of North Elmham, husbandman 0
3621899 1874392 1874392 defendant Trendell Henry husbandman 588926 588926 Trendell, Henry, of North Elmham, husbandman 1
3622103 1874449 1874449 defendant Larwod Thomas husbandman 588926 588926 Larwod, Thomas, of North Elmham, husbandman 2
3622552 1874589 1874589 defendant Heyward John, junior laborer 588926 588926 Heyward, John, junior, of North Elmham, laborer 1
3624800 1875291 1875291 defendant Gele William husbandman 588926 588926 Gele, William, of North Elmham, husbandman 0
3626294 1903080 1903080 defendant Dyte John husbandman 588926 588926 Dyte, John, of North Elmham, husbandman 0
3626297 1903081 1903081 defendant Taverner John butcher 588926 588926 Taverner, John, of North Elmham, butcher 0
3627107 1903340 1903340 defendant Dyman Robert husbandman 588926 588926 Dyman, Robert, of North Elmham, husbandman 0
3635375 1905859 1905859 defendant Trendyll Richard yeoman 588926 588926 Trendyll, Richard, of North Elmham, yeoman 0
3635376 1905859 1905859 defendant Trendyll Henry yeoman 588926 588926 Trendyll, Henry, of North Elmham, yeoman 1
3637139 1906414 1906414 defendant Browne John husbandman 588926 588926 Browne, John, of North Elmham, husbandman 2
3638549 1906874 1906874 defendant Peers Richard husbandman 588926 588926 Peers, Richard, of North Elmham, husbandman 1
3651029 1910687 1910687 defendant Dyman Robert husbandman 588926 588926 Dyman, Robert, of North Elmham, husbandman 1
3675750 1918450 1918450 defendant Dyman Robert husbandman 588926 588926 Dyman, Robert, of North Elmham, husbandman 0
3676408 1918666 1918666 defendant Taverner John husbandman 588926 588926 Taverner, John, of North Elmham, husbandman 3
3679423 1919629 1919629 defendant Rous William, junior husbandman 588926 588926 Rous, William, junior, of North Elmham, husbandman 0
3680123 1919852 1919852 defendant Taverner John yeoman 588926 588926 Taverner, John, of North Elmham, yeoman 1
3708675 1929012 1929012 defendant Swenyngton Henry husbandman 588926 588926 Swenyngton, Henry, of North Elmham, husbandman 3
3734570 1937058 1937058 defendant Brette William   588926 588926 Brette, William, of North Elmham, tile burner 0
3747295 1941075 1941075 plaintiff Dyksonson John   588926 588926 Dyksonson, John, of North Elmham 0
3759873 1945076 1945076 defendant Wodecok John husbandman 588926 588926 Wodecok, John, of North Elmham, husbandman 1
3775963 1950228 1950228 defendant Blakborn Thomas husbandman 588926 588926 Blakborn, Thomas, of North Elmham, husbandman 0
3787419 1953858 1953858 defendant Tylney William painter 588926 588926 Tylney, William, of North Elmham, painter 4
3793691 1955891 1955891 defendant Tylney William stainer 588926 588926 Tylney, William, of North Elmham, stainer 2
3802250 1958597 1958597 defendant Tavener John yeoman 588926 588926 Tavener, John, of North Elmham, yeoman 0
3835283 1968976 1968976 plaintiff Pers Richard yeoman 588926 588926 Pers, Richard, of North Elmham, yeoman 0
3835285 1968977 1968977 plaintiff Pers Richard yeoman 588926 588926 Pers, Richard, of North Elmham, yeoman 0
3837265 1969562 1969562 defendant Woodecok John husbandman 588926 588926 Woodecok, John, of North Elmham, husbandman 1
3876997 1982547 1982547 defendant Dyghtte Nicholas husbandman 588926 588926 Dyghtte, Nicholas, of North Elmham, husbandman 2
3877182 1982609 1982609 plaintiff Heyward Richard yeoman 588926 588926 Heyward, Richard, of North Elmham, yeoman 0
3902405 1991034 1991034 defendant Fletcher Edward dyer 588926 588926 Fletcher, Edward, of North Elmham, dyer 0
3902406 1991034 1991034 defendant Dyxe William husbandman 588926 588926 Dyxe, William, of North Elmham, husbandman 1
3912809 1994616 1994616 defendant Fletcher Edward dyer 588926 588926 Fletcher, Edward, of North Elmham, dyer 2
3921394 1997497 1997497 plaintiff Peers Richard   588926 588926 Peers, Richard, of North Elmham 0
3921489 1997529 1997529 plaintiff Pers Richard yeoman 588926 588926 Pers, Richard, of North Elmham, yeoman 0
3944773 2005271 2005271 defendant Lackfor Richard butcher 588926 588926 Lackfor, Richard, of North Elmham, butcher 0
3946843 2005964 2005964 defendant Heyward John husbandman 588926 588926 Heyward, John, of North Elmham, husbandman 2
3948788 2006643 2006643 defendant Hamond John husbandman 588926 588926 Hamond, John, of North Elmham, husbandman 0
3950207 2007157 2007157 defendant Heyward Henry gent 588926 588926 Heyward, Henry, of North Elmham, gent 0
3950208 2007157 2007157 defendant Butler Nicholas tailor 588926 588926 together with Butler, Nicholas, of North Elmham, tailor 1
3952444 2007924 2007924 plaintiff Heyward Henry gent 588926 588926 Heyward, Henry, of North Elmham, gent 0
3952470 2007932 2007932 plaintiff Heyward Henry gent 588926 588926 Heyward, Henry, of North Elmham, gent 0
3956214 2009241 2009241 defendant Stone Elizabeth widow 588926 588926 Stone, Elizabeth, of North Elmham, widow 13
3956387 2009296 2009296 defendant Wakefeld Thomas blacksmith 588926 588926 Wakefeld, Thomas, of North Elmham, blacksmith 0
3956388 2009296 2009296 defendant Handforth Thomas husbandman 588926 588926 Handforth, Thomas, of North Elmham, husbandman 1
3965410 2012514 2012514 defendant Lackford Richard butcher 588926 588926 Lackford, Richard, of North Elmham, butcher 0
3971121 2014455 2014455 defendant More John (legal representative) 588926 588926 More, John, of North Elmham, miller, executors of 0
3971888 2014729 2014729 plaintiff Fletcher John dyer 588926 588926 Fletcher, John, of North Elmham, dyer 0
3975599 2016030 2016030 defendant Hanforde Thomas husbandman 588926 588926 Hanforde, Thomas, of North Elmham, husbandman 1
3979942 2017587 2017587 defendant Pers Richard yeoman 588926 588926 Pers, Richard, of North Elmham, yeoman 0
3979944 2017588 2017588 defendant Pyers Richard yeoman 588926 588926 Pyers, Richard, of North Elmham, yeoman 0
3981147 2018015 2018015 plaintiff Purdye Stephen husbandman 588926 588926 Purdye, Stephen, of North Elmham, husbandman 0
3981149 2018016 2018016 plaintiff Purdye Stephen husbandman 588926 588926 Purdye, Stephen, of North Elmham, husbandman 0
3985657 2019634 2019634 defendant Hanforth Thomas husbandman 588926 588926 Hanforth, Thomas, of North Elmham, husbandman 0
3986958 2020080 2020080 defendant Pyerse Robert yeoman 588926 588926 Pyerse, Robert, of North Elmham, yeoman 0
3990281 2021279 2021279 defendant Rye Thomas butcher 588926 588926 Rye, Thomas, of North Elmham, butcher 0
3992021 2021912 2021912 defendant Cocke Sampson husbandman 588926 588926 Cocke, Sampson, of North Elmham, husbandman 1
3992023 2021912 2021912 defendant Rudde William butcher 588926 588926 Rudde, William, of North Elmham, butcher 3
3996396 2023466 2023466 defendant Batch William yeoman 588926 588926 Batch, William, of North Elmham, yeoman 0
3999101 2024439 2024439 defendant Heyward Thomas yeoman 588926 588926 Heyward, Thomas, of North Elmham, yeoman 0
4002644 2025717 2025717 plaintiff Heyward Alice (legal representative) 588926 588926 Heyward, Alice, of North Elmham, widow, executor of 0
4002646 2025717 2025717 defendant Wakefeld Thomas blacksmith 588926 588926 Wakefeld, Thomas, of North Elmham, blacksmith 0
4002660 2025721 2025721 defendant Francklyn Richard butcher 588926 588926 Francklyn, Richard, of North Elmham, butcher 0
4002661 2025721 2025721 defendant Francklyn William yeoman 588926 588926 Francklyn, William, of North Elmham, yeoman 1
4002662 2025721 2025721 defendant Love John husbandman 588926 588926 Love, John, of North Elmham, husbandman 2
4002663 2025721 2025721 defendant Blower William cordwainer 588926 588926 Blower, William, of North Elmham, cordwainer 3
4002664 2025721 2025721 defendant Pomfrett Clement laborer 588926 588926 Pomfrett, Clement, of North Elmham, laborer 4
4002665 2025721 2025721 defendant Pytcher Gregory tailor 588926 588926 Pytcher, Gregory, of North Elmham, tailor 5
4002666 2025721 2025721 defendant Dunham John laborer 588926 588926 Dunham, John, of North Elmham, laborer 6
4002667 2025721 2025721 defendant Fyssher William laborer 588926 588926 Fyssher, William, of North Elmham, laborer 7
4002668 2025721 2025721 defendant Love Avice spinster 588926 588926 Love, Avice, of North Elmham, spinster 8
4002669 2025721 2025721 defendant Peers Thomas laborer 588926 588926 together with Peers, Thomas, of North Elmham, laborer 9
4011078 2028735 2028735 defendant Hanforth Thomas husbandman 588926 588926 Hanforth, Thomas, of North Elmham, husbandman 0
4011079 2028735 2028735 defendant Hanforthe Edward laborer 588926 588926 Hanforthe, Edward, of North Elmham, laborer 1
4011080 2028735 2028735 defendant Fletcher John dyer 588926 588926 Fletcher, John, of North Elmham, dyer 2
4012716 2029271 2029271 defendant Hanforthe Thomas yeoman 588926 588926 Hanforthe, Thomas, of North Elmham, yeoman 0
4013287 2029485 2029485 defendant Handford Thomas husbandman 588926 588926 Handford, Thomas, of North Elmham, husbandman 0
4013573 2029590 2029590 defendant Harrys William miller 588926 588926 Harrys, William, of North Elmham, miller 0
4013574 2029590 2029590 defendant Hanforth Thomas husbandman 588926 588926 Hanforth, Thomas, of North Elmham, husbandman 1
4018324 2031281 2031281 defendant Clement Robert yeoman 588926 588926 Clement, Robert, of North Elmham, yeoman 0
4018334 2031284 2031284 defendant Clement Robert yeoman 588926 588926 Clement, Robert, of North Elmham, yeoman 0
4019153 2031587 2031587 defendant Wakfelde Henry joiner 588926 588926 Wakfelde, Henry, of North Elmham, joiner 2
4031829 2036046 2036046 defendant Heyward Thomas yeoman 588926 588926 Heyward, Thomas, of North Elmham, yeoman 0
4038488 2038407 2038407 plaintiff Lawson Silvester   588926 588926 Lawson, Silvester, of North Elmham 0
4038490 2038408 2038408 plaintiff Lawson Silvester   588926 588926 Lawson, Silvester, of North Elmham 0

Next page

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