names

96 rows where place_id = 588991

✎ 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
3596209 1866443 1866443 defendant Stabull John husbandman 588991 588991 Stabull, John, of Magna Waltham, husbandman 0
3596353 1866492 1866492 defendant Stabull John husbandman 588991 588991 Stabull, John, of Magna Waltham, husbandman 0
3615751 1872566 1872566 defendant Wedham William husbandman 588991 588991 Wedham, William, of Magna Waltham, husbandman 4
3627705 1903526 1903526 defendant Cornyssh John husbandman 588991 588991 Cornyssh, John, of Magna Waltham, husbandman 0
3632264 1904910 1904910 defendant Deynyssh Simon miller 588991 588991 Deynyssh, Simon, of Magna Waltham, miller 0
3643175 1908304 1908304 defendant Brewer Guy laborer 588991 588991 Brewer, Guy, of Magna Waltham, laborer 0
3643176 1908304 1908304 defendant Colett Thomas laborer 588991 588991 Colett, Thomas, of Magna Waltham, laborer 1
3643177 1908304 1908304 defendant Devenysshe James laborer 588991 588991 Devenysshe, James, of Magna Waltham, laborer 2
3643178 1908304 1908304 defendant Devenysshe John laborer 588991 588991 Devenysshe, John, of Magna Waltham, laborer 3
3643180 1908305 1908305 defendant Gose Thomas laborer 588991 588991 Gose, Thomas, of Magna Waltham, laborer 0
3643181 1908305 1908305 defendant Ferror John laborer 588991 588991 Ferror, John, of Magna Waltham, laborer 1
3643182 1908305 1908305 defendant Rawlyn John laborer 588991 588991 Rawlyn, John, of Magna Waltham, laborer 2
3643183 1908305 1908305 defendant Ultyng John husbandman 588991 588991 Ultyng, John, of Magna Waltham, husbandman 3
3643186 1908306 1908306 defendant Knyghtbryge Thomas smith 588991 588991 Knyghtbryge, Thomas, of Magna Waltham, smith 1
3643187 1908306 1908306 defendant Knyghtbryge John cordwainer 588991 588991 Knyghtbryge, John, of Magna Waltham, cordwainer 2
3643188 1908306 1908306 defendant Colett John husbandman 588991 588991 Colett, John, of Magna Waltham, husbandman 3
3643191 1908307 1908307 defendant Knyghtbryge Thomas smith 588991 588991 Knyghtbryge, Thomas, of Magna Waltham, smith 1
3643192 1908307 1908307 defendant Knyghtbryge John cordwainer 588991 588991 Knyghtbryge, John, of Magna Waltham, cordwainer 2
3643193 1908307 1908307 defendant Colett John laborer 588991 588991 Colett, John, of Magna Waltham, laborer 3
3643199 1908309 1908309 plaintiff Cornysshe John   588991 588991 Cornysshe, John, of Magna Waltham, son of Cornysshe, John, son of Cornysshe, Thomas 0
3651321 1910778 1910778 defendant Everard Thomas   588991 588991 Everard, Thomas, of Magna Waltham 0
3704860 1927813 1927813 defendant Polley Robert capper 588991 588991 Polley, Robert, of Magna Waltham, capper 4
3747515 1941138 1941138 defendant Pulley Robert haberdasher 588991 588991 Pulley, Robert, of Magna Waltham, haberdasher 2
3750174 1941971 1941971 defendant Polle Robert chapman 588991 588991 Polle, Robert, of Magna Waltham, chapman 0
3769974 1948265 1948265 defendant Poley Richard haberdasher 588991 588991 Poley, Richard, of Magna Waltham, haberdasher 0
3786814 1953672 1953672 defendant Haukyng John gent 588991 588991 Haukyng, John, of Magna Waltham, gent 0
3793788 1955921 1955921 defendant Wade William carpenter 588991 588991 Wade, William, of Magna Waltham, carpenter 3
3804694 1959411 1959411 plaintiff Sorell Robert (legal representative) 588991 588991 Sorell, Robert, of Magna Waltham, executors of 0
3807999 1960392 1960392 defendant Lyttell Andrew husbandman 588991 588991 Lyttell, Andrew, of Magna Waltham, husbandman 1
3810607 1961215 1961215 defendant Coke Thomas husbandman 588991 588991 Coke, Thomas, of Magna Waltham, husbandman 0
3810614 1961216 1961216 defendant Wade William haberdasher 588991 588991 Wade, William, of Magna Waltham, haberdasher 0
3813969 1962278 1962278 defendant Everard Richard yeoman 588991 588991 (Everard, Richard, of Magna Waltham, yeoman 4
3813970 1962278 1962278 defendant Everard Thomas yeoman 588991 588991 Everard, Thomas, of Magna Waltham, yeoman 5
3822146 1964823 1964823 plaintiff Sorell Robert (legal representative) 588991 588991 Sorell, Robert, of Magna Waltham, executors of 0
3860579 1977031 1977031 defendant Cornysshe John husbandman 588991 588991 Cornysshe, John, of Magna Waltham, husbandman 4
3883234 1984655 1984655 defendant Stourdyvalle Thomas laborer 588991 588991 Stourdyvalle, Thomas, of Magna Waltham, laborer 0
3883235 1984655 1984655 defendant Stourdyvalle John laborer 588991 588991 Stourdyvalle, John, of Magna Waltham, laborer 1
4000476 2024939 2024939 plaintiff Greggelles or Gregg Thomas yeoman 588991 588991 Greggelles or Gregg, Thomas, of Magna Waltham, yeoman 0
4092382 2057578 2057578 defendant Bowsy Francis yeoman 588991 588991 Bowsy, Francis, of Magna Waltham, yeoman 0
4092384 2057579 2057579 defendant Bowsy Francis yeoman 588991 588991 Bowsy, Francis, of Magna Waltham, yeoman 0
4121678 2068050 2068050 defendant Barnard Richard yeoman 588991 588991 Barnard, Richard, of Magna Waltham, yeoman 1
4184832 2090204 2090204 defendant Wyseman Dorothy widow 588991 588991 Wyseman, Dorothy, of Magna Waltham, widow 1
4236230 2108242 2108242 defendant Everard Mathew gent 588991 588991 Everard, Mathew, of Magna Waltham, gent 0
4236231 2108242 2108242 defendant Everard John tailor 588991 588991 Everard, John, of Magna Waltham, tailor 1
4238887 2109224 2109224 defendant Otley Richard yeoman 588991 588991 Otley, Richard, of Magna Waltham, yeoman 0
4238888 2109224 2109224 defendant Howell John husbandman 588991 588991 Howell, John, of Magna Waltham, husbandman 1
4333320 2141426 2141426 defendant Cosen John husbandman 588991 588991 Cosen, John, of Magna Waltham, husbandman 0
4341603 2144338 2144338 defendant Sache Nicholas husbandman 588991 588991 Sache, Nicholas, of Magna Waltham, husbandman 0
4377218 2156925 2156925 defendant Otley Elizabeth widow 588991 588991 Otley, Elizabeth, of Magna Waltham, widow 3
4405370 2166375 2166375 defendant Ellys John yeoman 588991 588991 Ellys, John, of Magna Waltham, yeoman 0
4652127 2246605 2246605 plaintiff atte Hyd Thomas   588991 588991 atte Hyd, Thomas, of Magna Waltham 0
4652128 2246605 2246605 plaintiff Wolston John   588991 588991 Wolston, John, of Magna Waltham 1
4661203 2249329 2249329 defendant atte Helle Stephen draper 588991 588991 atte Helle, Stephen, of Magna Waltham, draper 2
4781999 2290373 2290373 defendant Smyth John husbandman 588991 588991 Smyth, John, of Magna Waltham, husbandman 0
4789166 2292666 2292666 defendant Barbour Thomas barber 588991 588991 Barbour, Thomas, of Magna Waltham, barber 1
4793913 2294222 2294222 defendant Waltham John tanner 588991 588991 Waltham, John, of Magna Waltham, tanner 2
4801469 2296641 2296641 plaintiff Wolston John miller 588991 588991 Wolston, John, of Magna Waltham, miller 0
4871208 2317974 2317974 defendant Spencer Thomas fuller 588991 588991 Spencer, Thomas, of Magna Waltham, fuller 0
4876529 2319625 2319625 plaintiff Smyth John (legal representative) 588991 588991 Smyth, John, of Magna Waltham, executors of 0
4878942 2320347 2320347 defendant Flete John clerk 588991 588991 Flete, John, of Magna Waltham, clerk 0
4885538 2322357 2322357 defendant Tanner Humphrey tanner 588991 588991 Tanner, Humphrey, of Magna Waltham, tanner 4
4893519 2324674 2324674 defendant Blecche Robert husbandman 588991 588991 Blecche, Robert, of Magna Waltham, husbandman 0
4893528 2324677 2324677 defendant Swetyng John husbandman 588991 588991 Swetyng, John, of Magna Waltham, husbandman 0
4905199 2328221 2328221 defendant Tanner Humphrey tanner 588991 588991 Tanner, Humphrey, of Magna Waltham, tanner 4
4906263 2328549 2328549 defendant Barbour John chapman 588991 588991 Barbour, John, of Magna Waltham, chapman 0
4906264 2328549 2328549 defendant Doryvall Thomas tailor 588991 588991 Doryvall, Thomas, of Magna Waltham, tailor 1
4906265 2328549 2328549 defendant atte Wode John husbandman 588991 588991 atte Wode, John, of Magna Waltham, husbandman 2
4906266 2328549 2328549 defendant Doryvale William tailor 588991 588991 Doryvale, William, of Magna Waltham, tailor 3
4938192 2338322 2338322 defendant Golop John, junior laborer 588991 588991 Golop, John, junior, of Magna Waltham, laborer 1
5073820 2378657 2378657 defendant Pepyr Henry mercer 588991 588991 Pepyr, Henry, of Magna Waltham, mercer 0
5078858 2380165 2380165 defendant Warenger John, senior husbandman 588991 588991 Warenger, John, senior, of Magna Waltham, husbandman 0
5078859 2380165 2380165 defendant Warenger John, junior husbandman 588991 588991 Warenger, John, junior, of Magna Waltham, husbandman 1
5079011 2380206 2380206 defendant Smyth Agnes widow 588991 588991 Smyth, Agnes, of Magna Waltham, widow 1
5092449 2384168 2384168 defendant Glascok John yeoman 588991 588991 Glascok, John, of Magna Waltham, yeoman 6
5101155 2386751 2386751 defendant Warener John esq 588991 588991 Warener, John, of Magna Waltham, esq 0
5114533 2390652 2390652 defendant Cusace Robert clerk 588991 588991 Cusace, Robert, of Magna Waltham, clerk 0
5214459 2419962 2419962 defendant Wodeham Thomas yeoman 588991 588991 Wodeham, Thomas, of Magna Waltham, yeoman 0
5257087 2432349 2432349 defendant Barnabe alias Vaus or Vans Thomas butcher 588991 588991 Barnabe alias Vaus or Vans, Thomas, of Magna Waltham, butcher 0
5257665 2432519 2432519 defendant Barnebye Thomas butcher 588991 588991 Barnebye, Thomas, of Magna Waltham, butcher 0
5257668 2432519 2432519 defendant Pynchon Robert drover 588991 588991 Pynchon, Robert, of Magna Waltham, drover 3
5289146 2441831 2441831 defendant Brigge Richard husbandman 588991 588991 Brigge, Richard, of Magna Waltham, husbandman 1
5289182 2441837 2441837 defendant Brygge Richard husbandman 588991 588991 Brygge, Richard, of Magna Waltham, husbandman 2
5312109 2448653 2448653 plaintiff Artour John maltman 588991 588991 Artour, John, of Magna Waltham, maltman 0
5328850 2453706 2453706 plaintiff Everard William husbandman 588991 588991 Everard, William, of Magna Waltham, husbandman 3
5329320 2453852 2453852 defendant Stabull John yeoman 588991 588991 Stabull, John, of Magna Waltham, yeoman 4
5339962 2457069 2457069 defendant Arthur John maltman 588991 588991 Arthur, John, of Magna Waltham, maltman 0
5353023 2461034 2461034 defendant Pynchon Robert butcher 588991 588991 Pynchon, Robert, of Magna Waltham, butcher 0
5353025 2461034 2461034 defendant Herd Edmund husbandman 588991 588991 Herd, Edmund, of Magna Waltham, husbandman 2
5480025 2499018 2499018 plaintiff Glascok William yeoman 588991 588991 Glascok, William, of Magna Waltham, yeoman 1
5503281 2505935 2505935 defendant Wodeham Thomas husbandman 588991 588991 Wodeham, Thomas, of Magna Waltham, husbandman 0
5503283 2505936 2505936 defendant Wodeham Thomas husbandman 588991 588991 Wodeham, Thomas, of Magna Waltham, husbandman 0
5543658 2518124 2518124 defendant Bysshop John maltman 588991 588991 Bysshop, John, of Magna Waltham, maltman 0
5544497 2518389 2518389 defendant Wodeham Thomas yeoman 588991 588991 Wodeham, Thomas, of Magna Waltham, yeoman 0
5544831 2518492 2518492 defendant Courtman Richard husbandman 588991 588991 Courtman, Richard, of Magna Waltham, husbandman 0
5559980 2522874 2522874 defendant Everard John, senior yeoman 588991 588991 Everard, John, senior, of Magna Waltham, yeoman 3
5564977 2524343 2524343 defendant Knappyng John husbandman 588991 588991 Knappyng, John, of Magna Waltham, husbandman 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);