names

259 rows where place_id = 589594

✎ 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
3598101 1867034 1867034 defendant Jakson Robert husbandman 589594 589594 Jakson, Robert, of Quadryng, husbandman 4
3610734 1871022 1871022 defendant Toplasshe Richard husbandman 589594 589594 Toplasshe, Richard, of Quadryng, husbandman 0
3641427 1907774 1907774 defendant Lenman John husbandman 589594 589594 Lenman, John, of Quadryng, husbandman 0
3641432 1907776 1907776 defendant Chele Richard husbandman 589594 589594 Chele, Richard, of Quadryng, husbandman 1
3657545 1912621 1912621 defendant Alege John husbandman 589594 589594 Alege, John, of Quadryng, husbandman 0
3664305 1914788 1914788 defendant Alege John husbandman 589594 589594 Alege, John, of Quadryng, husbandman 0
3664306 1914788 1914788 defendant Lathe John husbandman 589594 589594 Lathe, John, of Quadryng, husbandman 1
3691860 1923615 1923615 defendant Aylward Henry husbandman 589594 589594 Aylward, Henry, of Quadryng, husbandman 0
3695180 1924714 1924714 defendant Denyson Robert husbandman 589594 589594 Denyson, Robert, of Quadryng, husbandman 0
3695181 1924714 1924714 defendant Snell Robert, junior husbandman 589594 589594 Snell, Robert, junior, of Quadryng, husbandman 1
3698795 1925840 1925840 defendant Howell Thomas tailor 589594 589594 Howell, Thomas, of Quadryng, tailor 0
3714712 1930901 1930901 defendant Adam Robert, junior   589594 589594 Adam, Robert, junior, of Quadryng, salt weller 0
3714714 1930902 1930902 defendant Alom Robert, junior   589594 589594 Alom, Robert, junior, of Quadryng, salt weller 0
3714718 1930903 1930903 defendant Vassell Thomas, senior husbandman 589594 589594 Vassell, Thomas, senior, of Quadryng, husbandman 0
3720228 1932602 1932602 defendant Elwarde Henry husbandman 589594 589594 Elwarde, Henry, of Quadryng, husbandman 0
3725272 1934194 1934194 defendant Domysday John husbandman 589594 589594 Domysday, John, of Quadryng, husbandman 0
3758404 1944622 1944622 defendant Wode Giles chaplain 589594 589594 Wode, Giles, of Quadryng, chaplain 0
3776284 1950329 1950329 defendant Adam Robert yeoman 589594 589594 Adam, Robert, of Quadryng, yeoman 0
3777180 1950615 1950615 defendant Smyth Simon husbandman 589594 589594 Smyth, Simon, of Quadryng, husbandman 0
3780039 1951482 1951482 defendant Smyth Simon husbandman 589594 589594 Smyth, Simon, of Quadryng, husbandman 0
3782725 1952341 1952341 defendant Pavy Lambert husbandman 589594 589594 Pavy, Lambert, of Quadryng, husbandman 1
3782730 1952342 1952342 defendant Pavy Lambert husbandman 589594 589594 Pavy, Lambert, of Quadryng, husbandman 1
3783210 1952500 1952500 defendant Wood Giles clerk 589594 589594 (Wood, Giles, of Quadryng, clerk 1
3783256 1952516 1952516 defendant Aylward Henry   589594 589594 Aylward, Henry, of Quadryng, salt weller 0
3783258 1952516 1952516 defendant Wode Giles clerk 589594 589594 Wode, Giles, of Quadryng, clerk 2
3783259 1952516 1952516 defendant Holton Simon clerk 589594 589594 Holton, Simon, of Quadryng, clerk 3
3790157 1954740 1954740 defendant Smyth Simon husbandman 589594 589594 Smyth, Simon, of Quadryng, husbandman 0
3834040 1968586 1968586 defendant Sherforth Lambert saltweller 589594 589594 Sherforth, Lambert, of Quadryng, saltweller 0
3850787 1973841 1973841 defendant Pevy Lambert husbandman 589594 589594 Pevy, Lambert, of Quadryng, husbandman 0
3850788 1973841 1973841 defendant Ormeshede Thomas husbandman 589594 589594 Ormeshede, Thomas, of Quadryng, husbandman 1
3863688 1978041 1978041 defendant Adam John laborer 589594 589594 Adam, John, of Quadryng, laborer 1
3872463 1981015 1981015 defendant Pevy Lambert husbandman 589594 589594 Pevy, Lambert, of Quadryng, husbandman 0
3875448 1982033 1982033 defendant Elward Thomas, junior husbandman 589594 589594 Elward, Thomas, junior, of Quadryng, husbandman 0
3875449 1982033 1982033 defendant Ormeshed Thomas husbandman 589594 589594 Ormeshed, Thomas, of Quadryng, husbandman 1
3879623 1983438 1983438 defendant Denyson Thomas husbandman 589594 589594 Denyson, Thomas, of Quadryng, husbandman 0
3889488 1986716 1986716 defendant Vassyll Thomas husbandman 589594 589594 Vassyll, Thomas, of Quadryng, husbandman 0
3890808 1987193 1987193 defendant Adam Robert saltweller 589594 589594 Adam, Robert, of Quadryng, saltweller 0
3890810 1987193 1987193 defendant Aylwald Henry saltweller 589594 589594 Aylwald, Henry, of Quadryng, saltweller 2
3890811 1987193 1987193 defendant Remy Nicholas saltweller 589594 589594 Remy, Nicholas, of Quadryng, saltweller 3
3890812 1987193 1987193 defendant Preston Isabel widow 589594 589594 Preston, Isabel, of Quadryng, widow 4
3890814 1987194 1987194 defendant Jerman Thomas laborer 589594 589594 Jerman, Thomas, of Quadryng, laborer 0
3890815 1987194 1987194 defendant Adam Robert saltweller 589594 589594 Adam, Robert, of Quadryng, saltweller 1
3902970 1991222 1991222 defendant Nessefeld Thomas gent 589594 589594 Nessefeld, Thomas, of Quadryng, gent 1
3902972 1991222 1991222 defendant Kent John laborer 589594 589594 Kent, John, of Quadryng, laborer 3
3905039 1991949 1991949 defendant Remy Nicholas saltweller 589594 589594 Remy, Nicholas, of Quadryng, saltweller 1
3905040 1991949 1991949 defendant Welpedale Edmund saltweller 589594 589594 Welpedale, Edmund, of Quadryng, saltweller 2
3905044 1991950 1991950 defendant Adam John, senior carter 589594 589594 Adam, John, senior, of Quadryng, carter 0
3905048 1991950 1991950 defendant Mylward Henry   589594 589594 Mylward, Henry, of Quadryng, salt weller 4
3907907 1992934 1992934 defendant Ormeshed Thomas husbandman 589594 589594 Ormeshed, Thomas, of Quadryng, husbandman 0
3911182 1994068 1994068 defendant Ormeshed Thomas husbandman 589594 589594 Ormeshed, Thomas, of Quadryng, husbandman 0
3911183 1994068 1994068 defendant Elward Robert husbandman 589594 589594 Elward, Robert, of Quadryng, husbandman 1
3911186 1994069 1994069 defendant Ormeshed Thomas husbandman 589594 589594 Ormeshed, Thomas, of Quadryng, husbandman 0
3911187 1994069 1994069 defendant Elwarde Robert husbandman 589594 589594 Elwarde, Robert, of Quadryng, husbandman 1
3924675 1998567 1998567 defendant Dalby John husbandman 589594 589594 Dalby, John, of Quadryng, husbandman 1
3970815 2014379 2014379 defendant Jackson Nicholas husbandman 589594 589594 Jackson, Nicholas, of Quadryng, husbandman 9
3970839 2014381 2014381 defendant Jackson Nicholas husbandman 589594 589594 Jackson, Nicholas, of Quadryng, husbandman 9
3987812 2020386 2020386 defendant Ingram William clerk 589594 589594 Ingram, William, of Quadryng, clerk 0
3987813 2020386 2020386 defendant Danson John yeoman 589594 589594 Danson, John, of Quadryng, yeoman 1
3990961 2021529 2021529 defendant Lyndsey John husbandman 589594 589594 Lyndsey, John, of Quadryng, husbandman 2
4016685 2030676 2030676 defendant Harryman Gilbert yeoman 589594 589594 Harryman, Gilbert, of Quadryng, yeoman 0
4448305 2184392 2184392 defendant Freston John   589594 589594 Freston, John, of Quadryng 0
4456613 2187090 2187090 defendant Collull Hugh   589594 589594 Collull, Hugh, of Quadryng 0
4459793 2188114 2188114 defendant Walpole Robert de   589594 589594 Walpole, Robert de, of quadryng 0
4459795 2188115 2188115 defendant Walpole Robert de   589594 589594 Walpole, Robert de, of Quadryng 0
4461483 2188671 2188671 defendant Morwod Robert de   589594 589594 Morwod, Robert de, of Quadryng, parson 0
4461544 2188691 2188691 plaintiff Stevenson John (legal representative) 589594 589594 Stevenson, John, of Quadryng, executors of 0
4461545 2188691 2188691 plaintiff Stevenson Margaret   589594 589594 (Stevenson, Margaret, of Quadryng, formerly wife of John 1
4461553 2188692 2188692 plaintiff Stevenson John (legal representative) 589594 589594 Stevenson, John, of Quadryng, executors of 0
4461554 2188692 2188692 plaintiff Stevenson Margaret   589594 589594 (Stevenson, Margaret, of Quadryng, formerly wife of John 1
4463069 2189151 2189151 defendant Besyng Randolf   589594 589594 Besyng, Randolf, of Quadryng 0
4467659 2190563 2190563 plaintiff Bailly Ralph   589594 589594 Bailly, Ralph, of Quadryng 0
4469106 2191005 2191005 defendant Milner John   589594 589594 Milner, John, of Quadryng 0
4469107 2191005 2191005 defendant Lombson Robert   589594 589594 Lombson, Robert, of Quadryng 1
4469108 2191005 2191005 defendant Moone John   589594 589594 Moone, John, of Quadryng 2
4470742 2191502 2191502 defendant Pynne Robert   589594 589594 Pynne, Robert, of Quadryng 0
4494399 2198944 2198944 defendant Stevenson William   589594 589594 Stevenson, William, of Quadryng 0
4497006 2199725 2199725 defendant Broun John   589594 589594 Broun, John, of Quadryng 0
4509160 2203341 2203341 defendant Dankynson John   589594 589594 Dankynson, John, of Quadryng, bailiff 0
4525506 2208306 2208306 defendant Pauk Roger   589594 589594 Pauk, Roger, of Quadryng 0
4525507 2208306 2208306 defendant Bothe John   589594 589594 Bothe, John, of Quadryng 1
4525508 2208306 2208306 defendant Pyn Richard   589594 589594 Pyn, Richard, of Quadryng 2
4539765 2212696 2212696 defendant Fyncham John   589594 589594 Fyncham, John, of Quadryng 1
4551443 2216388 2216388 defendant Mynwode John   589594 589594 Mynwode, John, of Quadryng 1
4551444 2216388 2216388 defendant Bailly William   589594 589594 Bailly, William, of Quadryng 2
4552968 2216873 2216873 defendant Philipp Robert   589594 589594 Philipp, Robert, of Quadryng 3
4552981 2216877 2216877 defendant Phelyppe Robert   589594 589594 Phelyppe, Robert, of Quadryng 2
4563479 2220149 2220149 defendant Beche John   589594 589594 Beche, John, of Quadryng 0
4581922 2225794 2225794 defendant Rede Thomas   589594 589594 Rede, Thomas, of Quadryng 0
4586813 2227272 2227272 defendant Bury Thomas   589594 589594 Bury, Thomas, of Quadryng 0
4610740 2234424 2234424 defendant Durbag John   589594 589594 Durbag, John, of Quadryng 1
4656271 2247855 2247855 plaintiff Campas Thomas   589594 589594 Campas, Thomas, of Quadryng 0
4671991 2256884 2256884 defendant Smyth Richard husbandman 589594 589594 Smyth, Richard, of Quadryng, husbandman 0
4673555 2257360 2257360 defendant Hugbody William husbandman 589594 589594 Hugbody, William, of Quadryng, husbandman 0
4676030 2258114 2258114 defendant Wrangell Thomas   589594 589594 Wrangell, Thomas, of Quadryng, salt weller 0
4682377 2260108 2260108 defendant Walpole Thomas husbandman 589594 589594 Walpole, Thomas, of Quadryng, husbandman 0
4688430 2261948 2261948 defendant Durbagg John husbandman 589594 589594 Durbagg, John, of Quadryng, husbandman 1
4688431 2261948 2261948 defendant durbagg Richard husbandman 589594 589594 durbagg, Richard, of Quadryng, husbandman 2
4695482 2264068 2264068 defendant Elrych Thomas theker or thatcher 589594 589594 Elrych, Thomas, of Quadryng, theker or thatcher 1
4710431 2268618 2268618 defendant Broune William husbandman 589594 589594 Broune, William, of Quadryng, husbandman 0
4720416 2271720 2271720 defendant Elrych Thomas thatcher 589594 589594 Elrych, Thomas, of Quadryng, thatcher 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);