names

62 rows where place_id = 596518

✎ 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
3625106 1875387 1875387 defendant Tachell John husbandman 596518 596518 Tachell, John, of Baryngton, husbandman 0
3690503 1923196 1923196 defendant Hychecok Henry husbandman 596518 596518 Hychecok, Henry, of Baryngton, husbandman 2
3751722 1942454 1942454 defendant Robynson Robert clerk 596518 596518 Robynson, Robert, of Baryngton, clerk 0
3751724 1942455 1942455 defendant Calcotte Robert husbandman 596518 596518 Calcotte, Robert, of Baryngton, husbandman 0
3751725 1942455 1942455 defendant Tayler alias Eyer John husbandman 596518 596518 Tayler alias Eyer, John, of Baryngton, husbandman 1
3759092 1944829 1944829 defendant Calcote Thomas husbandman 596518 596518 Calcote, Thomas, of Baryngton, husbandman 1
3858873 1976455 1976455 defendant Hawkyns John husbandman 596518 596518 Hawkyns, John, of Baryngton, husbandman 0
3858874 1976455 1976455 defendant Jomell Richard husbandman 596518 596518 Jomell, Richard, of Baryngton, husbandman 1
3909913 1993623 1993623 defendant Bray Richard husbandman 596518 596518 Bray, Richard, of Baryngton, husbandman 0
3909914 1993623 1993623 defendant Caldecott John husbandman 596518 596518 Caldecott, John, of Baryngton, husbandman 1
3924385 1998466 1998466 defendant Colyn Margaret widow 596518 596518 Colyn, Margaret, of Baryngton, widow 1
3924386 1998466 1998466 defendant Colyn William husbandman 596518 596518 Colyn, William, of Baryngton, husbandman 2
3968665 2013681 2013681 plaintiff Clifton John   596518 596518 Clifton, John, of Baryngton, esq, his son 1
4442307 2182529 2182529 defendant Ihote or Ibote Thomas chaplain 596518 596518 Ihote or Ibote, Thomas, of Baryngton, chaplain 0
4449319 2184736 2184736 defendant Ibote or Ihote Thomas chaplain 596518 596518 Ibote or Ihote, Thomas, of Baryngton, chaplain 0
4507456 2202796 2202796 defendant Caunnell Thomas   596518 596518 Caunnell, Thomas, of Baryngton 4
4575506 2223846 2223846 defendant Neweton Thomas chaplain 596518 596518 Neweton, Thomas, of Baryngton, chaplain 5
4622644 2238059 2238059 defendant Welweton John, sen   596518 596518 Welweton, John, sen, of Baryngton 0
4670394 2256432 2256432 defendant Wodehey John gent 596518 596518 Wodehey, John, of Baryngton, gent 0
4670895 2256575 2256575 defendant Welweton John husbandman 596518 596518 Welweton, John, of Baryngton, husbandman 0
4670896 2256575 2256575 defendant Welweton Thomas yeoman 596518 596518 Welweton, Thomas, of Baryngton, yeoman 1
4695611 2264110 2264110 defendant Wodehay John gent 596518 596518 Wodehay, John, of Baryngton, gent 0
4695950 2264219 2264219 defendant Welweton John husbandman 596518 596518 Welweton, John, of Baryngton, husbandman 0
4695951 2264219 2264219 defendant Wolweton Thomas yeoman 596518 596518 Wolweton, Thomas, of Baryngton, yeoman 1
4726113 2273455 2273455 defendant Welweton John husbandman 596518 596518 Welweton, John, of Baryngton, husbandman 1
4730060 2274602 2274602 defendant Bouley Philip husbandman 596518 596518 Bouley, Philip, of Baryngton, husbandman 2
4735020 2276101 2276101 defendant Boweleygh Philip husbandman 596518 596518 Boweleygh, Philip, of Baryngton, husbandman 0
4735021 2276101 2276101 defendant Webbe Robert husbandman 596518 596518 Webbe, Robert, of Baryngton, husbandman 1
4749838 2280427 2280427 defendant Best John ploughman 596518 596518 Best, John, of Baryngton, ploughman 0
4763400 2284541 2284541 defendant Somere John husbandman 596518 596518 Somere, John, of Baryngton, husbandman 1
4763553 2284585 2284585 defendant Welweton John husbandman 596518 596518 Welweton, John, of Baryngton, husbandman 0
4787098 2292026 2292026 defendant Semere John husbandman 596518 596518 Semere, John, of Baryngton, husbandman 1
4787239 2292077 2292077 defendant Welweton John husbandman 596518 596518 Welweton, John, of Baryngton, husbandman 0
4801110 2296537 2296537 defendant Bette Thomas, senior husbandman 596518 596518 Bette, Thomas, senior, of Baryngton, husbandman 0
4825032 2303869 2303869 defendant Best Thomas clerk 596518 596518 Best, Thomas, of Baryngton, clerk 0
4912365 2330367 2330367 defendant Everard Geoffrey butcher 596518 596518 Everard, Geoffrey, of Baryngton, butcher 4
4935430 2337477 2337477 defendant Malkyn John chandler 596518 596518 Malkyn, John, of Baryngton, chandler 2
5013359 2360745 2360745 defendant Mason Thomas husbandman 596518 596518 Mason, Thomas, of Baryngton, husbandman 1
5052475 2372334 2372334 defendant Bendyssh Edmund gent 596518 596518 Bendyssh, Edmund, of Baryngton, gent 0
5078822 2380154 2380154 defendant Doubeney William esq 596518 596518 Doubeney, William, of Baryngton, esq 1
5086837 2382546 2382546 defendant Welweton John gent 596518 596518 Welweton, John, of Baryngton, gent 0
5101342 2386805 2386805 defendant Mason Thomas   596518 596518 Mason, Thomas, of Baryngton, mason 0
5258482 2432768 2432768 defendant Couper William husbandman 596518 596518 Couper, William, of Baryngton, husbandman 3
5275186 2437817 2437817 defendant Semer Thomas husbandman 596518 596518 Semer, Thomas, of Baryngton, husbandman 1
5277113 2438394 2438394 defendant Couper John husbandman 596518 596518 Couper, John, of Baryngton, husbandman 3
5286724 2441125 2441125 defendant Hulcote Thomas husbandman 596518 596518 Hulcote, Thomas, of Baryngton, husbandman 3
5308653 2447622 2447622 defendant Semar Thomas husbandman 596518 596518 Semar, Thomas, of Baryngton, husbandman 0
5384344 2470610 2470610 defendant Rebener William husbandman 596518 596518 Rebener, William, of Baryngton, husbandman 1
5396145 2473983 2473983 defendant Rekentre William husbandman 596518 596518 Rekentre, William, of Baryngton, husbandman 1
5479389 2498852 2498852 defendant Parker John yeoman 596518 596518 Parker, John, of Baryngton, yeoman 0
5479391 2498852 2498852 defendant Gybons Thomas yeoman 596518 596518 Gybons, Thomas, of Baryngton, yeoman 2
5504082 2506192 2506192 defendant Rumbalde Henry husbandman 596518 596518 Rumbalde, Henry, of Baryngton, husbandman 3
5504083 2506192 2506192 defendant Mason Thomas husbandman 596518 596518 Mason, Thomas, of Baryngton, husbandman 4
5504084 2506192 2506192 defendant Scalys John husbandman 596518 596518 Scalys, John, of Baryngton, husbandman 5
5506918 2507079 2507079 defendant Holmys Henry smith 596518 596518 Holmys, Henry, of Baryngton, smith 1
5509319 2507766 2507766 defendant Pryour William husbandman 596518 596518 Pryour, William, of Baryngton, husbandman 1
5509320 2507766 2507766 defendant Venteman John miller 596518 596518 Venteman, John, of Baryngton, miller 2
5544841 2518493 2518493 defendant Rumbold Henry husbandman 596518 596518 Rumbold, Henry, of Baryngton, husbandman 3
5548650 2519647 2519647 defendant Lokeer John, senior butcher 596518 596518 Lokeer, John, senior, of Baryngton, butcher 3
5548651 2519647 2519647 defendant Lokeer John, junior laborer 596518 596518 Lokeer, John, junior, of Baryngton, laborer 4
5581446 2529266 2529266 defendant Phyppe William husbandman 596518 596518 Phyppe, William, of Baryngton, husbandman 1
5625393 2551881 2551881 defendant Welweton John, senior   596518 596518 Welweton, John, senior, of Baryngton 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);