names

319 rows where place_id = 587604

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591910 1865083 1865083 defendant Mountes John miller 587604 587604 Mountes, John, of Warham, miller 0
3597353 1866792 1866792 plaintiff Rokewode Alice widow 587604 587604 Rokewode, Alice, of Warham, widow 0
3603209 1868671 1868671 defendant Stede Thomas gent 587604 587604 Stede, Thomas, of Warham, gent 0
3603812 1868863 1868863 defendant Stede Thomas yeoman 587604 587604 Stede, Thomas, of Warham, yeoman 0
3603851 1868877 1868877 defendant Stede Thomas gent 587604 587604 Stede, Thomas, of Warham, gent 0
3605147 1869273 1869273 defendant Stede Thomas gent 587604 587604 Stede, Thomas, of Warham, gent 1
3610338 1870888 1870888 defendant Porter John husbandman 587604 587604 Porter, John, of Warham, husbandman 0
3625163 1875406 1875406 defendant Dynne Nicholas yeoman 587604 587604 Dynne, Nicholas, of Warham, yeoman 0
3625165 1875407 1875407 defendant Dey Thomas yeoman 587604 587604 Dey, Thomas, of Warham, yeoman 0
3643639 1908439 1908439 defendant Hasler John chapman 587604 587604 Hasler, John, of Warham, chapman 0
3646732 1909379 1909379 defendant Mower John husbandman 587604 587604 Mower, John, of Warham, husbandman 0
3669712 1916470 1916470 defendant Stede John gent 587604 587604 Stede, John, of Warham, gent 0
3676830 1918793 1918793 defendant Stede John gent 587604 587604 Stede, John, of Warham, gent 0
3689621 1922914 1922914 defendant Willyamson John yeoman 587604 587604 Willyamson, John, of Warham, yeoman 2
3689625 1922915 1922915 defendant Wyllamson John yeoman 587604 587604 Wyllamson, John, of Warham, yeoman 2
3720013 1932531 1932531 defendant Stede John gent 587604 587604 Stede, John, of Warham, gent 0
3725679 1934318 1934318 plaintiff Stede John gent 587604 587604 Stede, John, of Warham, gent 0
3725681 1934319 1934319 plaintiff Stede John yeoman 587604 587604 Stede, John, of Warham, yeoman 0
3727134 1934757 1934757 defendant Norwych Robert husbandman 587604 587604 Norwych, Robert, of Warham, husbandman 3
3734873 1937147 1937147 defendant Norwyche Robert husbandman 587604 587604 Norwyche, Robert, of Warham, husbandman 6
3742891 1939632 1939632 defendant Norwiche Robert husbandman 587604 587604 Norwiche, Robert, of Warham, husbandman 3
3750992 1942238 1942238 defendant Stede John gent 587604 587604 Stede, John, of Warham, gent 1
3771049 1948633 1948633 plaintiff Stede John gent 587604 587604 Stede, John, of Warham, gent 1
3784217 1952851 1952851 defendant Bysshop Robert husbandman 587604 587604 Bysshop, Robert, of Warham, husbandman 0
3784230 1952856 1952856 defendant Nuby Richard husbandman 587604 587604 Nuby, Richard, of Warham, husbandman 1
3787806 1953974 1953974 defendant Norwiche Robert husbandman 587604 587604 Norwiche, Robert, of Warham, husbandman 1
3803335 1958941 1958941 defendant Pope John butcher 587604 587604 Pope, John, of Warham, butcher 0
3804999 1959508 1959508 plaintiff Stede John gent 587604 587604 Stede, John, of Warham, gent 0
3821287 1964549 1964549 defendant Mason William clerk 587604 587604 Mason, William, of Warham, clerk 0
3853910 1974860 1974860 defendant Nuby Richard husbandman 587604 587604 Nuby, Richard, of Warham, husbandman 0
3868216 1979604 1979604 plaintiff Stede John gent 587604 587604 Stede, John, of Warham, gent 0
3878165 1982942 1982942 defendant Mason William clerk 587604 587604 Mason, William, of Warham, clerk 8
3879643 1983445 1983445 defendant Rumney Robert husbandman 587604 587604 Rumney, Robert, of Warham, husbandman 0
3880657 1983797 1983797 defendant Howyllys Thomas chapman 587604 587604 Howyllys, Thomas, of Warham, chapman 0
3881878 1984192 1984192 defendant Cheseman John husbandman 587604 587604 Cheseman, John, of Warham, husbandman 0
3881880 1984193 1984193 defendant Rumney Robert husbandman 587604 587604 Rumney, Robert, of Warham, husbandman 0
3882385 1984372 1984372 defendant Bysshop Robert husbandman 587604 587604 Bysshop, Robert, of Warham, husbandman 0
3889238 1986638 1986638 defendant Rumney Robert miller 587604 587604 Rumney, Robert, of Warham, miller 1
3890197 1986963 1986963 plaintiff Heller Thomas clerk 587604 587604 Heller, Thomas, of Warham, clerk 0
3904372 1991709 1991709 plaintiff Hecker Thomas clerk 587604 587604 Hecker, Thomas, of Warham, clerk 0
3950177 2007144 2007144 defendant Woulby John clerk 587604 587604 Woulby, John, of Warham, clerk 0
3953574 2008324 2008324 plaintiff Jarye Robert yeoman 587604 587604 Jarye, Robert, of Warham, yeoman 0
3956231 2009243 2009243 defendant Palmer Robert yeoman 587604 587604 Palmer, Robert, of Warham, yeoman 6
3975297 2015928 2015928 defendant Collyns Thomas yeoman 587604 587604 Collyns, Thomas, of Warham, yeoman 0
3975967 2016159 2016159 plaintiff Jarey Robert yeoman 587604 587604 Jarey, Robert, of Warham, yeoman 0
3975973 2016161 2016161 plaintiff Jarye Robert mercer 587604 587604 Jarye, Robert, of Warham, mercer 0
3981981 2018318 2018318 defendant Pope Thomas yeoman 587604 587604 Pope, Thomas, of Warham, yeoman 0
3984278 2019141 2019141 defendant Browne John miller 587604 587604 Browne, John, of Warham, miller 0
4006501 2027105 2027105 defendant Rumeye Edward glover 587604 587604 Rumeye, Edward, of Warham, glover 2
4026731 2034206 2034206 defendant Parkyns Thomas yeoman 587604 587604 Parkyns, Thomas, of Warham, yeoman 0
4026747 2034213 2034213 defendant Parkyns Thomas yeoman 587604 587604 Parkyns, Thomas, of Warham, yeoman 0
4034372 2036965 2036965 defendant Feke Robert merchant 587604 587604 Feke, Robert, of Warham, merchant 0
4036960 2037894 2037894 plaintiff Jarye Robert yeoman 587604 587604 Jarye, Robert, of Warham, or of Well next the Sea, yeoman 0
4127206 2070022 2070022 defendant Assheborne John yeoman 587604 587604 Assheborne, John, of Warham, yeoman 0
4156856 2080477 2080477 defendant Dey Thomas yeoman 587604 587604 Dey, Thomas, of Warham, yeoman 1
4178974 2088125 2088125 defendant Bullocke Richard, senior yeoman 587604 587604 Bullocke, Richard, senior, of Warham, or of Breynton, yeoman 1
4223722 2103781 2103781 defendant Turbervyle Henry gent 587604 587604 Turbervyle, Henry, of Warham, gent 3
4249093 2112681 2112681 defendant Edwardes Richard yeoman 587604 587604 Edwardes, Richard, of Warham, yeoman 0
4251760 2113579 2113579 defendant Todd William yeoman 587604 587604 Todd, William, of Warham, yeoman 0
4261143 2116695 2116695 defendant Turbervile Henry gent 587604 587604 Turbervile, Henry, of Warham, gent 0
4261145 2116696 2116696 defendant Turbervyle Henry gent 587604 587604 Turbervyle, Henry, of Warham, gent 0
4263193 2117355 2117355 defendant Cleves Augustine chapman 587604 587604 Cleves, Augustine, of Warham, chapman 1
4290524 2126671 2126671 defendant Neubie Edmund miller 587604 587604 Neubie, Edmund, of Warham, miller 2
4302556 2131012 2131012 defendant Turbervyle Henry gent 587604 587604 Turbervyle, Henry, of Warham, gent 0
4305780 2132159 2132159 defendant Smythe Elias tucker 587604 587604 Smythe, Elias, of Warham, tucker 0
4305781 2132159 2132159 defendant Payne George draper 587604 587604 Payne, George, of Warham, draper 1
4324697 2138652 2138652 defendant Hunte William yeoman 587604 587604 Hunte, William, of Warham, or of Salisbury, yeoman 0
4333635 2141532 2141532 defendant Dowe Edmund yeoman 587604 587604 Dowe, Edmund, of Warham, or of Lymyngton, Hants, yeoman 0
4333636 2141532 2141532 defendant Turbervyle Henry gent 587604 587604 Turbervyle, Henry, of Warham, gent 1
4333637 2141532 2141532 defendant Uvedale John gent 587604 587604 Uvedale, John, of Warham, or of Corffe Castell, Isle of Purbeck, gent 2
4343826 2145121 2145121 defendant Dey Thomas husbandman 587604 587604 Dey, Thomas, of Warham, husbandman 0
4347752 2146462 2146462 defendant Nubie Edmund miller 587604 587604 Nubie, Edmund, of Warham, miller 1
4350949 2147587 2147587 defendant Nuby or Newby Edmund miller 587604 587604 Nuby or Newby, Edmund, of Warham, miller 1
4397162 2163624 2163624 defendant Brewtaye John husbandman 587604 587604 Brewtaye, John, of Warham, husbandman 0
4399434 2164398 2164398 defendant Beake John yeoman 587604 587604 Beake, John, of Warham, yeoman 0
4410638 2168149 2168149 defendant Shepster John vintner 587604 587604 Shepster, John, of Warham, vintner 0
4421108 2171494 2171494 plaintiff Chyke Edward   587604 587604 Chyke, Edward, of Warham 0
4447266 2184051 2184051 plaintiff Dygon John   587604 587604 Dygon, John, of Warham 0
4451678 2185496 2185496 plaintiff Byle Walter   587604 587604 Byle, Walter, of Warham, burgess 2
4451679 2185496 2185496 plaintiff Denys Adam   587604 587604 Denys, Adam, of Warham, burgess 3
4454933 2186556 2186556 defendant Parmenter Roger   587604 587604 Parmenter, Roger, of Warham 0
4455070 2186588 2186588 defendant Syward John   587604 587604 Syward, John, of Warham 3
4467867 2190631 2190631 defendant Gunholf Hugh   587604 587604 Gunholf, Hugh, of Warham 0
4469800 2191228 2191228 plaintiff Bowyere Richard   587604 587604 Bowyere, Richard, of Warham 0
4471017 2191590 2191590 defendant Iweyn Thomas   587604 587604 Iweyn, Thomas, of Warham 0
4477237 2193549 2193549 defendant Fullere John   587604 587604 Fullere, John, of Warham 0
4477242 2193550 2193550 defendant Fullere John   587604 587604 Fullere, John, of Warham 0
4498122 2200067 2200067 defendant Ekerdon William   587604 587604 Ekerdon, William, of Warham 0
4498529 2200184 2200184 defendant Skynner John   587604 587604 Skynner, John, of Warham 0
4498534 2200184 2200184 defendant Roper Ralph   587604 587604 Roper, Ralph, of Warham 5
4504192 2201864 2201864 defendant Coo Edmund   587604 587604 Coo, Edmund, of Warham 0
4504193 2201864 2201864 defendant Coo Thomas   587604 587604 Coo, Thomas, of Warham 1
4504194 2201864 2201864 defendant Broun John   587604 587604 Broun, John, of Warham 2
4504195 2201864 2201864 defendant Roberdes William   587604 587604 Roberdes, William, of Warham 3
4507121 2202696 2202696 plaintiff Walbron Thomas   587604 587604 Walbron, Thomas, of Warham 1
4507662 2202859 2202859 plaintiff Barbour Thomas   587604 587604 Barbour, Thomas, of Warham 1
4509718 2203521 2203521 defendant Boucher Geoffrey   587604 587604 Boucher, Geoffrey, of Warham 2
4510217 2203679 2203679 plaintiff Barbour Thomas   587604 587604 Barbour, Thomas, of Warham 0
4514868 2205065 2205065 defendant Hay Thomas   587604 587604 Hay, Thomas, of Warham 1
4515750 2205354 2205354 defendant Chapman John   587604 587604 Chapman, John, of Warham 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);