names

94 rows where place_id = 588011

✎ 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
3593094 1865467 1865467 defendant Gode Thomas yeoman 588011 588011 Gode, Thomas, of Rosse, Herefs, yeoman 2
3604908 1869202 1869202 plaintiff Henbarowe Richard (legal representative) 588011 588011 Henbarowe, Richard, of Rosse, Herefs, executors of 0
3609060 1870492 1870492 defendant Ap Howell Philip chapman 588011 588011 Ap Howell, Philip, of Rosse, Herefs, chapman 0
3609102 1870504 1870504 defendant Ap Howell Philip chapman 588011 588011 Ap Howell, Philip, of Rosse, Herefs, chapman 0
3722028 1933152 1933152 defendant Nycolles Henry yeoman 588011 588011 Nycolles, Henry, of Rosse, Herefs, yeoman 0
3722031 1933153 1933153 defendant Nycolles Henry yeoman 588011 588011 Nycolles, Henry, of Rosse, Herefs, yeoman 0
3722034 1933154 1933154 defendant Nycolles Henry yeoman 588011 588011 Nycolles, Henry, of Rosse, Herefs, yeoman 0
3893670 1988108 1988108 defendant Browne Roger mercer 588011 588011 Browne, Roger, of Rosse, Herefs, mercer 1
3954189 2008539 2008539 defendant Hayle Thomas mercer 588011 588011 Hayle, Thomas, of Rosse, herefs, mercer 0
3955158 2008865 2008865 defendant Nicoll Richard yeoman 588011 588011 Nicoll, Richard, of Rosse, Herefs, yeoman 0
3963521 2011849 2011849 defendant Cave Robert yeoman 588011 588011 Cave, Robert, of Rosse, Herefs, yeoman 0
3966925 2013065 2013065 plaintiff Brooke Edward tailor 588011 588011 Brooke, Edward, of Rosse, Herefs, tailor 0
3966930 2013066 2013066 plaintiff Brooke Edward tailor 588011 588011 Brooke, Edward, of Rosse, Herefs, tailor 0
3970859 2014384 2014384 defendant Griffith Thomas mercer 588011 588011 Griffith, Thomas, of Rosse, Herefs, mercer 1
3976732 2016428 2016428 defendant Syngleton alias Nycoll Elizabeth widow 588011 588011 Syngleton alias Nycoll, Elizabeth, of Rosse, Herefs, widow 0
3980464 2017782 2017782 defendant Madocke John chapman 588011 588011 Madocke, John, of Rosse, Herefs, chapman 0
3986215 2019832 2019832 defendant Abrahall James gent 588011 588011 Abrahall, James, of Rosse, Herefs, gent 1
4002455 2025648 2025648 plaintiff Herbert John gent 588011 588011 Herbert, John, of Rosse, Herefs, gent 0
4011000 2028711 2028711 defendant Woodward Thomas chapman or mercer 588011 588011 Woodward, Thomas, of Rosse, Herefs, chapman or mercer 0
4021423 2032388 2032388 defendant Wylse Richard draper 588011 588011 Wylse, Richard, of Rosse, Herefs, draper 1
4034410 2036978 2036978 defendant Will Richard chapman 588011 588011 Will, Richard, of Rosse, Herefs, chapman 0
4044763 2040575 2040575 defendant Gamon William butcher 588011 588011 Gamon, William, of Rosse, Herefs, butcher 2
4059915 2045943 2045943 defendant Dewe Robert chapman 588011 588011 Dewe, Robert, of Rosse, Herefs, chapman 0
4061930 2046665 2046665 defendant Warren Richard yeoman 588011 588011 Warren, Richard, of Rosse, Herefs, yeoman 0
4096726 2059159 2059159 defendant Tomkyns Thomas yeoman 588011 588011 Tomkyns, Thomas, of Rosse, Herefs, yeoman 2
4099474 2060141 2060141 defendant Nicholl Thomas gent 588011 588011 Nicholl, Thomas, of Rosse, Herefs, gent 0
4099476 2060142 2060142 defendant Nicholl Thomas gent 588011 588011 Nicholl, Thomas, of Rosse, Herefs, gent 0
4102483 2061183 2061183 defendant Nyccoll Thomas yeoman 588011 588011 Nyccoll, Thomas, of Rosse, Herefs, yeoman 0
4110169 2063899 2063899 defendant Dewe John chapman 588011 588011 Dewe, John, of Rosse, Herefs, chapman 0
4114622 2065518 2065518 defendant Stowell Robert tailor 588011 588011 Stowell, Robert, of Rosse, Herefs, yeoman, tailor 0
4114771 2065570 2065570 defendant Lewes David cordwainer 588011 588011 Lewes, David, of Rosse, Herefs, cordwainer 0
4133565 2072337 2072337 defendant Abrahall James chapman 588011 588011 Abrahall, James, of Rosse, Herefs, chapman 2
4136279 2073320 2073320 defendant Cater William capper 588011 588011 Cater, William, of Rosse, Herefs, capper 3
4136291 2073323 2073323 defendant Abrahall James chapman 588011 588011 Abrahall, James, of Rosse, Herefs, chapman 1
4167862 2084246 2084246 defendant Nycolls Thomas gent 588011 588011 Nycolls, Thomas, of Rosse, Herefs, gent 1
4172549 2085859 2085859 defendant Abrall James chapman 588011 588011 Abrall, James, of Rosse, Herefs, chapman 0
4172551 2085860 2085860 defendant Abrall James chapman 588011 588011 Abrall, James, of Rosse, Herefs, chapman 0
4181664 2089073 2089073 defendant Bromwiche Roger gent 588011 588011 Bromwiche, Roger, of Rosse, Herefs, gent 0
4181808 2089119 2089119 defendant Bromwich Roger gent 588011 588011 Bromwich, Roger, of Rosse, Herefs, gent 0
4182828 2089474 2089474 defendant Bromwiche Roger gent 588011 588011 Bromwiche, Roger, of Rosse, herefs, gent 0
4186551 2090778 2090778 defendant Reade Walter gent 588011 588011 Reade, Walter, of Rosse, Herefs, gent 1
4188850 2091577 2091577 defendant Bellamye Thomas yeoman 588011 588011 Bellamye, Thomas, of Rosse, Herefs, yeoman 0
4197852 2094799 2094799 defendant Nocolles Thomas chapman 588011 588011 Nocolles, Thomas, of Rosse, Herefs, chapman 2
4201890 2096204 2096204 defendant Jones Thomas chapman 588011 588011 Jones, Thomas, of Rosse, Herefs, chapman 0
4204311 2097053 2097053 defendant Jones Thomas chapman 588011 588011 Jones, Thomas, of Rosse, Herefs, chapman 3
4211601 2099607 2099607 defendant Bromwiche Roger mercer 588011 588011 Bromwiche, Roger, of Rosse, Herefs, gent, or of London, mercer 0
4238164 2108960 2108960 defendant Hyde John dyer 588011 588011 Hyde, John, of Rosse, Herefs, dyer 1
4238169 2108961 2108961 defendant Hyde John dyer 588011 588011 Hyde, John, of Rosse, Herefs, dyer 1
4238173 2108962 2108962 defendant Taylor William mercer 588011 588011 Taylor, William, of Rosse, Herefs, mercer 0
4238178 2108963 2108963 defendant Taylor William mercer 588011 588011 Taylor, William, of Rosse, Herefs, mercer 0
4243162 2110706 2110706 defendant Pryce Richard tailor 588011 588011 Pryce, Richard, of Rosse, Herefs, tailor 0
4243163 2110706 2110706 defendant Adams Thomas yeoman 588011 588011 Adams, Thomas, of Rosse, Herefs, yeoman 1
4296338 2128788 2128788 defendant Chynne Thomas yeoman 588011 588011 Chynne, Thomas, of Rosse, Herefs, yeoman 2
4296339 2128788 2128788 defendant Ball William yeoman 588011 588011 Ball, William, of Rosse, Herefs, yeoman 3
4304524 2131719 2131719 defendant Smythe Henry (legal representative) 588011 588011 Smythe, Henry, of Rosse, Herefs, yeoman, administrator during minority of Thomas Brandred, executor of John 1
4304916 2131858 2131858 defendant Taylor Thomas husbandman 588011 588011 Taylor, Thomas, of Rosse, Herefs, husbandman 0
4330107 2140369 2140369 defendant Bromwiche Roger gent 588011 588011 Bromwiche, Roger, of Rosse, Herefs, gent 0
4358293 2150135 2150135 defendant Jones Thomas haberdasher 588011 588011 Jones, Thomas, of Rosse, Herefs, yeoman, haberdasher 0
4364225 2152264 2152264 defendant Kyrle Anthony gent 588011 588011 Kyrle, Anthony, of Rosse, Herefs, gent 0
4382657 2158907 2158907 defendant Stephens Richard husbandman 588011 588011 Stephens, Richard, of Rosse, Herefs, husbandman 0
4383670 2159248 2159248 defendant Abrahall John esq 588011 588011 Abrahall, John, of Rosse, Herefs, esq 0
4410434 2168092 2168092 defendant Bennett William chapman 588011 588011 Bennett, William, of Rosse, Herefs, chapman 0
4410476 2168101 2168101 defendant Tomes William chapman 588011 588011 Tomes, William, of Rosse, Herefs, chapman 1
4572975 2223086 2223086 defendant Cooke David   588011 588011 Cooke, David, of Rosse, Herefs 0
4661744 2249515 2249515 defendant Gerveys John chapman 588011 588011 Gerveys, John, of Rosse, Herefs, chapman 0
4745740 2279265 2279265 defendant Skydmore Thomas gent 588011 588011 Skydmore, Thomas, of Rosse, Herefs, gent 2
4745750 2279266 2279266 defendant Skydmore Thomas gent 588011 588011 Skydmore, Thomas, of Rosse, Herefs, gent 2
4767929 2285942 2285942 defendant Gerveys John mercer 588011 588011 Gerveys, John, of Rosse, Herefs, mercer 1
4792342 2293691 2293691 defendant Gerveys John mercer 588011 588011 Gerveys, John, of Rosse, Herefs, mercer 1
4915152 2331247 2331247 defendant Bedyn John, senior mercer 588011 588011 Bedyn, John, senior, of Rosse, Herefs, mercer 1
4915157 2331248 2331248 defendant Bedyn John, senior mercer 588011 588011 Bedyn, John, senior, of Rosse, Herefs, mercer 1
4922736 2333525 2333525 defendant Whyte Thomas baker 588011 588011 Whyte, Thomas, of Rosse, Herefs, baker 0
4987654 2353269 2353269 defendant Brugge John yeoman 588011 588011 Brugge, John, of Rosse, Herefs, yeoman 0
5006674 2358849 2358849 defendant Worcester John carrier 588011 588011 Worcester, John, of Rosse, Herefs, carrier 1
5054528 2372927 2372927 defendant Fyssher John tanner 588011 588011 Fyssher, John, of Rosse, Herefs, tanner 2
5123685 2393386 2393386 defendant Cop Richard chapman 588011 588011 Cop, Richard, of Rosse, Herefs, chapman 0
5123690 2393387 2393387 defendant Oop Richard chaplain 588011 588011 Oop, Richard, of Rosse, Herefs, chaplain 0
5249999 2430112 2430112 defendant Temmes John clerk 588011 588011 Temmes, John, of Rosse, Herefs, clerk 1
5258861 2432892 2432892 defendant Lewys Thomas yeoman 588011 588011 Lewys, Thomas, of Rosse, Herefs, yeoman 1
5265244 2434888 2434888 defendant Balle Thomas yeoman 588011 588011 Balle, Thomas, of Rosse, Herefs, yeoman 0
5276394 2438164 2438164 defendant Balle Thomas chapman 588011 588011 Balle, Thomas, of Rosse, Herefs, chapman 2
5285978 2440911 2440911 defendant Lewes Thomas yeoman 588011 588011 Lewes, Thomas, of Rosse, Herefs, yeoman 1
5296423 2443944 2443944 defendant Worsettur William tanner 588011 588011 Worsettur, William, of Rosse, Herefs, tanner 0
5305667 2446701 2446701 defendant Bagge John yeoman 588011 588011 Bagge, John, of Rosse, Herefs, yeoman 3
5465520 2494594 2494594 defendant Smartte Thomas shoemaker 588011 588011 Smartte, Thomas, of Rosse, Herefs, shoemaker 2
5465521 2494594 2494594 defendant Yonge Henry shoemaker 588011 588011 Yonge, Henry, of Rosse, Herefs, shoemaker 3
5476977 2498119 2498119 defendant Smartte Thomas shoemaker 588011 588011 Smartte, Thomas, of Rosse, Herefs, shoemaker 2
5477030 2498136 2498136 defendant Smartte Thomas shoemaker 588011 588011 Smartte, Thomas, of Rosse, Herefs, shoemaker 0
5492026 2502522 2502522 defendant Packer Richard mercer 588011 588011 Packer, Richard, of Rosse, Herefs, mercer 2
5493462 2502956 2502956 defendant ap Howell Richard   588011 588011 ap Howell, Richard, of Rosse, Herefs, tailot 4
5510661 2508172 2508172 defendant Strete William baker 588011 588011 Strete, William, of Rosse, Herefs, baker 0
5572237 2526432 2526432 defendant Davyes Nicholas weaver 588011 588011 Davyes, Nicholas, of Rosse, Herefs, weaver 0
5591751 2532405 2532405 defendant ap Madoke John yeoman 588011 588011 ap Madoke, John, of Rosse, Herefs, yeoman 2
5591757 2532406 2532406 defendant ap Madoke John yeoman 588011 588011 ap Madoke, John, of Rosse, Herefs, yeoman 2

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