names

69 rows where place_id = 597416

✎ 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
3628482 1903777 1903777 defendant Preston John smith 597416 597416 Preston, John, of Devises, smith 0
3643741 1908470 1908470 plaintiff Davyes alias Glynnebowe Thomas baker 597416 597416 Davyes alias Glynnebowe, Thomas, of Devises, baker 0
3649969 1910357 1910357 plaintiff Reynolde John   597416 597416 Reynolde, John, of Devises 0
3649973 1910357 1910357 defendant Letcombe Thomas mercer 597416 597416 Letcombe, Thomas, of Devises, mercer 3
3651343 1910785 1910785 defendant Barbour Richard yeoman 597416 597416 Barbour, Richard, of Devises, yeoman 0
3653018 1911274 1911274 defendant Broun Roger glover 597416 597416 Broun, Roger, of Devises, glover 0
3677391 1918979 1918979 defendant Alwyn Nicholas gent 597416 597416 Alwyn, Nicholas, of Devises, gent 0
3682252 1920546 1920546 defendant Lavender William tailor 597416 597416 Lavender, William, of Devises, tailor 0
3708655 1929007 1929007 plaintiff Page William gent 597416 597416 Page, William, of Devises, gent 0
3708656 1929007 1929007 defendant Milward William mercer 597416 597416 Milward, William, of Devises, mercer 0
3708657 1929007 1929007 defendant Preston John smith 597416 597416 Preston, John, of Devises, smith 1
3708658 1929007 1929007 defendant Basse alias Hopley George glover 597416 597416 Basse alias Hopley, George, of Devises, glover 2
3719659 1932415 1932415 defendant Davys John baker 597416 597416 Davys, John, of Devises, baker 2
3719660 1932415 1932415 defendant Walsheman John brewer 597416 597416 Walsheman, John, of Devises, brewer 3
3719661 1932415 1932415 defendant Tronslowe Robert hardwareman 597416 597416 Tronslowe, Robert, of Devises, hardwareman 4
3722789 1933393 1933393 defendant Kynnerston Roger gent 597416 597416 (Kynnerston, Roger, of Devises, gent 4
3728089 1935045 1935045 defendant Coggiswell John mercer 597416 597416 Coggiswell, John, of Devises, mercer 1
3738094 1938133 1938133 defendant Page William merchant 597416 597416 Page, William, of Devises, merchant 0
3786716 1953643 1953643 defendant Goswell John chapman 597416 597416 Goswell, John, of Devises, chapman 0
3803407 1958966 1958966 defendant Smyth William butcher 597416 597416 Smyth, William, of Devises, butcher 5
3803433 1958976 1958976 plaintiff Rede Thomas (legal representative) 597416 597416 Rede, Thomas, of Devises, executors of 0
3813200 1962038 1962038 defendant Russell John clothman 597416 597416 Russell, John, of Devises, clothman 3
3815247 1962684 1962684 defendant Bayly Robert weaver 597416 597416 Bayly, Robert, of Devises, weaver 1
3822780 1965029 1965029 defendant Lavyngton John clothier 597416 597416 Lavyngton, John, of Devises, clothier 0
3851186 1973964 1973964 plaintiff Page William   597416 597416 Page, William, of Devises 0
3919109 1996714 1996714 defendant Lovell Robert tyler 597416 597416 Lovell, Robert, of Devises, tyler 0
3951336 2007534 2007534 defendant Hull Thomas baker 597416 597416 Hull, Thomas, of Devises, baker 0
3953587 2008329 2008329 defendant Hadnot John tailor 597416 597416 Hadnot, John, of Devises, tailor 0
3970306 2014211 2014211 defendant Barkesdale Thomas yeoman or gent 597416 597416 Barkesdale, Thomas, of Devises, yeoman or gent 0
3976517 2016362 2016362 defendant Raynold John weaver 597416 597416 Raynold, John, of Devises, weaver 0
3978921 2017213 2017213 plaintiff Morses Robert draper 597416 597416 Morses, Robert, of Devises, draper 0
3987553 2020298 2020298 defendant Banford John clothier 597416 597416 Banford, John, of Devises, clothier 1
4003744 2026106 2026106 defendant Farre Roger yeoman 597416 597416 Farre, Roger, of Devises, yeoman 0
4010312 2028453 2028453 defendant Cley Phineas mercer 597416 597416 Cley, Phineas, of Devises, mercer 0
4083794 2054478 2054478 defendant Potter John shoemaker 597416 597416 Potter, John, of Devises, shoemaker 0
4165611 2083474 2083474 defendant Saxcy Tristram gent 597416 597416 Saxcy, Tristram, of Devises, or of Northflette, Kent, gent 0
4170503 2085178 2085178 defendant Purdewe William bellfounder 597416 597416 Purdewe, William, of Devises, or of Closeworth, Soms, bellfounder 0
4200435 2095710 2095710 defendant Whitacres John chapman 597416 597416 Whitacres, John, of Devises, chapman 2
4259854 2116267 2116267 defendant Lawrence Mathew gent 597416 597416 Lawrence, Mathew, of Devises, gent 0
4263100 2117325 2117325 defendant Bayllie Thomas gent 597416 597416 Bayllie, Thomas, of Devises, gent 1
4269205 2119293 2119293 defendant Morris Henry clothier 597416 597416 Morris, Henry, of Devises, clothier 3
4743735 2278697 2278697 defendant Skarlet Thomas husbandman 597416 597416 Skarlet, Thomas, of Devises, husbandman 2
4875677 2319349 2319349 plaintiff Saundrys John merchant 597416 597416 Saundrys, John, of Devises, merchant 0
4875678 2319349 2319349 plaintiff Smyth William merchant 597416 597416 Smyth, William, of Devises, merchant 1
4905840 2328429 2328429 defendant de Bean John tailor 597416 597416 de Bean, John, of Devises, tailor 0
4971682 2348458 2348458 defendant Ismayl Robert chapman 597416 597416 Ismayl, Robert, of Devises, chapman 0
4984215 2352212 2352212 defendant Baker John chaplain 597416 597416 Baker, John, of Devises, chaplain 1
5081181 2380877 2380877 plaintiff Coventre Thomas (legal representative) 597416 597416 Coventre, Thomas, of Devises, executors of 0
5213372 2419640 2419640 defendant Wondle John yeoman 597416 597416 Wondle, John, of Devises, yeoman 2
5245501 2428841 2428841 defendant Peret William weaver 597416 597416 Peret, William, of Devises, weaver 1
5250711 2430331 2430331 defendant Bowyer Peter weaver 597416 597416 Bowyer, Peter, of Devises, weaver 1
5250712 2430331 2430331 defendant Stan- Thomas weaver 597416 597416 Stan-, Thomas, of Devises, weaver 2
5277639 2438540 2438540 defendant Blodyng John butcher 597416 597416 Blodyng, John, of Devises, butcher 0
5285475 2440771 2440771 defendant Box Nicholas chaplain 597416 597416 Box, Nicholas, of Devises, chaplain 2
5350210 2460187 2460187 defendant Spycer William chapman 597416 597416 Spycer, William, of Devises, chapman 1
5405353 2476613 2476613 defendant Perott wiliam clothier 597416 597416 Perott, wiliam, of Devises, clothier 1
5519322 2510890 2510890 defendant Porter John weaver 597416 597416 Porter, John, of Devises, weaver 4
5550143 2520074 2520074 defendant Fischer John baker 597416 597416 Fischer, John, of Devises, baker 1
5552153 2520672 2520672 plaintiff Drue alias Trewe John clothmaker 597416 597416 Drue alias Trewe, John, of Devises, clothmaker 0
5560142 2522928 2522928 defendant Spicer William clothman 597416 597416 Spicer, William, of Devises, clothman 1
5560178 2522940 2522940 defendant Spicer William clothman 597416 597416 Spicer, William, of Devises, clothman 1
5588090 2531288 2531288 plaintiff Page William merchant 597416 597416 Page, William, of Devises, merchant 0
5602532 2535686 2535686 defendant Trapnell Thomas weaver 597416 597416 Trapnell, Thomas, of Devises, weaver 0
5605948 2536751 2536751 defendant Wyllons John laborer 597416 597416 Wyllons, John, of Devises, laborer 0
5605949 2536751 2536751 defendant Folffe or Folsse John weaver 597416 597416 Folffe or Folsse, John, of Devises, weaver 1
5605950 2536751 2536751 defendant Porter William weaver 597416 597416 Porter, William, of Devises, weaver 2
5605951 2536751 2536751 defendant Wever Ralph weaver 597416 597416 Wever, Ralph, of Devises, weaver 3
5605952 2536751 2536751 defendant Sysell John weaver 597416 597416 Sysell, John, of Devises, weaver 4
5605953 2536751 2536751 defendant Miller James laborer 597416 597416 Miller, James, of Devises, laborer 5

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