names

190 rows where place_id = 587210

✎ 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
3590766 1864751 1864751 defendant Stokeman Thomas husbandman 587210 587210 Stokeman, Thomas, of Merston, husbandman 1
3604194 1868977 1868977 defendant Harewode Thomas chaplain 587210 587210 Harewode, Thomas, of Merston Butler, chaplain 0
3616701 1872853 1872853 defendant Quarles John husbandman 587210 587210 Quarles, John, of Merston, husbandman 3
3627078 1903330 1903330 defendant Sale William husbandman 587210 587210 Sale, William, of Merston, husbandman 0
3636659 1906257 1906257 defendant Wetton Ellen widow 587210 587210 Wetton, Ellen, of Merston, widow 0
3636660 1906257 1906257 defendant Presse John laborer 587210 587210 Presse, John, of Merston, laborer 1
3638588 1906884 1906884 defendant Dey Thomas husbandman 587210 587210 Dey, Thomas, of Merston, husbandman 2
3639249 1907086 1907086 defendant Bryan William husbandman 587210 587210 Bryan, William, of Merston, husbandman 1
3639253 1907087 1907087 defendant Bryan William husbandman 587210 587210 Bryan, William, of Merston, husbandman 1
3645113 1908878 1908878 defendant Oxton John weaver 587210 587210 Oxton, John, of Merston, weaver 1
3645114 1908878 1908878 defendant Holrede William weaver 587210 587210 Holrede, William, of Merston, weaver 2
3697682 1925496 1925496 defendant Fysshe John husbandman 587210 587210 Fysshe, John, of Merston, husbandman 2
3705048 1927868 1927868 plaintiff Corbyt William   587210 587210 Corbyt, William, of Merston 1
3722715 1933372 1933372 plaintiff Mundys Stephen   587210 587210 Mundys, Stephen, of Merston 0
3724015 1933795 1933795 defendant Porte Andrew laborer 587210 587210 Porte, Andrew, of Merston, laborer 0
3745588 1940525 1940525 defendant Selmon John husbandman 587210 587210 Selmon, John, of Merston, husbandman 2
3776205 1950302 1950302 defendant Halle Henry yeoman 587210 587210 Halle, Henry, of Merston, yeoman 2
3829291 1967045 1967045 defendant Crosewell Otto yeoman 587210 587210 Crosewell, Otto, of Merston, yeoman 0
3836716 1969384 1969384 defendant Barbour Richard tailor 587210 587210 Barbour, Richard, of Merston, tailor 2
3874047 1981543 1981543 plaintiff Collumbell John (legal representative) 587210 587210 Collumbell, John, of Merston under Tutbury, executors of 0
3874425 1981675 1981675 defendant Cresewell Otto yeoman 587210 587210 Cresewell, Otto, of Merston, yeoman 0
3892011 1987580 1987580 plaintiff Makyn Robert husbandman 587210 587210 Makyn, Robert, of Merston, husbandman 0
3911602 1994201 1994201 plaintiff Weston Richard yeoman 587210 587210 Weston, Richard, of Merston, yeoman 0
3943767 2004933 2004933 defendant Parkyns Thomas yeoman 587210 587210 Parkyns, Thomas, of Merston, yeoman 1
4078488 2052604 2052604 defendant Ware Walter weaver 587210 587210 Ware, Walter, of Merston, weaver 1
4227514 2105107 2105107 defendant Pusshell Thomas esq 587210 587210 Pusshell, Thomas, of Merston, esq 0
4278105 2122276 2122276 defendant Bennett John, senior butcher 587210 587210 Bennett, John, senior, of Merston, or of Chichester, Sussex, butcher 0
4370055 2154347 2154347 defendant Barton Edward husbandman 587210 587210 Barton, Edward, of Merston, husbandman 1
4383312 2159132 2159132 defendant Etheridge Leonard yeoman 587210 587210 Etheridge, Leonard, of Merston, yeoman 2
4417496 2170357 2170357 defendant Coliere Alan   587210 587210 Coliere, Alan, of Merston 0
4424624 2172540 2172540 defendant Grayn Henry   587210 587210 Grayn, Henry, of Merston Botyler 2
4429087 2173904 2173904 plaintiff Trussel Lawrence   587210 587210 Trussel, Lawrence, of Merston, parson 0
4433516 2175243 2175243 defendant fitz Wauter John le   587210 587210 fitz Wauter, John le, of Merston 0
4450184 2185015 2185015 plaintiff Hall Robert de la   587210 587210 Hall, Robert de la, of Merston 0
4452313 2185711 2185711 defendant atte Halle Nicholas   587210 587210 atte Halle, Nicholas, of Merston 0
4463020 2189137 2189137 plaintiff Torald Richard   587210 587210 Torald, Richard, of Merston 0
4463025 2189137 2189137 defendant Walker Nicholas   587210 587210 Walker, Nicholas, of Merston 4
4478190 2193851 2193851 defendant Mongton Henry de   587210 587210 Mongton, Henry de, of Merston 0
4482830 2195334 2195334 defendant Thwayt William de   587210 587210 Thwayt, William de, of Merston 0
4485507 2196174 2196174 defendant Thorald Richard   587210 587210 Thorald, Richard, of Merston 0
4487393 2196766 2196766 defendant Bartesmore James   587210 587210 Bartesmore, James, of Merston 3
4493408 2198645 2198645 defendant Veel William, junior   587210 587210 Veel, William, junior, of Merston 5
4493409 2198645 2198645 defendant Adam John   587210 587210 Adam, John, of Merston 6
4494101 2198844 2198844 plaintiff Beton Guy   587210 587210 Beton, Guy, of Merston 0
4495855 2199383 2199383 defendant Adam John   587210 587210 Adam, John, of Merston 7
4496335 2199527 2199527 defendant Hert John   587210 587210 Hert, John, of Merston 0
4504701 2202013 2202013 defendant Woodecok John   587210 587210 Woodecok, John, of Merston 0
4507376 2202770 2202770 defendant Bernard Thomas   587210 587210 Bernard, Thomas, of Merston 0
4510198 2203673 2203673 defendant Adam John   587210 587210 Adam, John, of Merston 7
4515373 2205221 2205221 defendant _am John   587210 587210 _am, John, of Merston 6
4519313 2206399 2206399 plaintiff Eduyn William   587210 587210 Eduyn, William, of Merston 0
4519314 2206399 2206399 plaintiff Hamyll John chaplain 587210 587210 Hamyll, John, of Merston, chaplain 1
4522445 2207359 2207359 defendant Thwayt William   587210 587210 Thwayt, William, of Merston 1
4523548 2207688 2207688 defendant Thorald Richard   587210 587210 Thorald, Richard, of Merston 0
4531860 2210227 2210227 defendant Reynes Richard   587210 587210 Reynes, Richard, of Merston 0
4534431 2211042 2211042 defendant Wodecok John   587210 587210 Wodecok, John, of Merston 0
4534433 2211043 2211043 defendant Wodecok John   587210 587210 Wodecok, John, of Merston 0
4535298 2211308 2211308 defendant Troyes Nicholas   587210 587210 Troyes, Nicholas, of Merston 2
4546423 2214813 2214813 plaintiff Breton Guy   587210 587210 Breton, Guy, of Merston 0
4546424 2214813 2214813 defendant Hert John   587210 587210 Hert, John, of Merston 0
4552035 2216588 2216588 defendant Page John   587210 587210 Page, John, of Merston 1
4555514 2217655 2217655 defendant Balard (illegible)   587210 587210 Balard, _, of Merston 0
4580358 2225338 2225338 defendant Hulle Richard de   587210 587210 Hulle, Richard de, of Merston 0
4605274 2232816 2232816 defendant Alcok Thomas   587210 587210 Alcok, Thomas, of Merston Boteler 0
4605277 2232816 2232816 defendant Dryvere Philip   587210 587210 Dryvere, Philip, of Merston Botler 3
4605872 2232950 2232950 plaintiff atte Halle Robert   587210 587210 atte Halle, Robert, of Merston 0
4605873 2232950 2232950 defendant Taillour Giles   587210 587210 Taillour, Giles, of Merston 0
4607610 2233489 2233489 defendant Gilotson Roger   587210 587210 Gilotson, Roger, of Merston 0
4611190 2234563 2234563 defendant Bastard Edith   587210 587210 Bastard, Edith, of Merston, formerly wife of John 0
4623443 2238306 2238306 defendant atte Halle Thomas   587210 587210 atte Halle, Thomas, of Merston 0
4623444 2238306 2238306 defendant Ballard William   587210 587210 Ballard, William, of Merston 1
4634868 2241758 2241758 defendant Bocher John   587210 587210 Bocher, John, of Merston 0
4635539 2241972 2241972 defendant Reynold John   587210 587210 Reynold, John, of Merston 0
4645873 2244861 2244861 defendant Barker John   587210 587210 Barker, John, of Merston 0
4657510 2248242 2248242 defendant Norys John husbandman 587210 587210 Norys, John, of Merston, husbandman 0
4658200 2248444 2248444 defendant Hore Philip husbandman 587210 587210 Hore, Philip, of Merston, husbandman 0
4666011 2250843 2250843 defendant Parker Thomas husbandman 587210 587210 Parker, Thomas, of Merston, husbandman 4
4666012 2250843 2250843 defendant Norman William husbandman 587210 587210 Norman, William, of Merston, husbandman 5
4666013 2250843 2250843 defendant Mundten Thomas husbandman 587210 587210 Mundten, Thomas, of Merston, husbandman 6
4667975 2255690 2255690 defendant Noreys Thomas husbandman 587210 587210 Noreys, Thomas, of Merston, husbandman 0
4669331 2256114 2256114 defendant Barell Thomas ploughman 587210 587210 Barell, Thomas, of Merston, ploughman 1
4674222 2257546 2257546 defendant Hye John husbandman 587210 587210 Hye, John, of Merston, husbandman 2
4687341 2261643 2261643 defendant Hoper William butcher 587210 587210 Hoper, William, of Merston, butcher 3
4700826 2265657 2265657 defendant Ratele William farmer 587210 587210 Ratele, William, of Merston, farmer 0
4703389 2266440 2266440 defendant Wyot William husbandman 587210 587210 Wyot, William, of Merston Prior, husbandman 4
4705645 2267140 2267140 defendant Wattes Hugh chapman 587210 587210 Wattes, Hugh, of Merston Prior, chapman 0
4705647 2267141 2267141 defendant Wattes Hugh chapman 587210 587210 Wattes, Hugh, of Merston Prior, chapman 0
4712574 2269251 2269251 defendant Bosevyle William husbandman 587210 587210 Bosevyle, William, of Merston, husbandman 0
4713456 2269531 2269531 plaintiff Stukle Richard esq 587210 587210 Stukle, Richard, of Merston, esq 0
4720790 2271834 2271834 defendant Bosewyle William drover 587210 587210 Bosewyle, William, of Merston, drover 0
4722847 2272460 2272460 defendant Blyssworth Richard butcher 587210 587210 Blyssworth, Richard, of Merston, butcher 0
4722848 2272460 2272460 defendant Manger George husbandman 587210 587210 Manger, George, of Merston, husbandman 1
4747222 2279692 2279692 defendant Fox William husbandman 587210 587210 Fox, William, of Merston, husbandman 0
4747223 2279692 2279692 defendant Bardemore William husbandman 587210 587210 Bardemore, William, of Merston, husbandman 1
4747224 2279692 2279692 defendant Hille John husbandman 587210 587210 Hille, John, of Merston, husbandman 2
4747225 2279692 2279692 defendant Goode John husbandman 587210 587210 Goode, John, of Merston, husbandman 3
4754374 2281748 2281748 defendant Hardyng John chaplain 587210 587210 Hardyng, John, of Merston, chaplain 0
4756861 2282512 2282512 defendant Barker William husbandman 587210 587210 Barker, William, of Merston, formerly of Nuneton, Warws, husbandman 1
4758257 2282958 2282958 defendant Couper Stephen yeoman 587210 587210 Couper, Stephen, of Merston, yeoman 0
4767888 2285932 2285932 plaintiff Merston Robert gent 587210 587210 Merston, Robert, of Merston, gent 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);