names

66 rows where place_id = 596256

✎ 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
3623902 1875004 1875004 defendant Walle John yeoman 596256 596256 Walle, John, of Droytwyche, yeoman 0
3655240 1911896 1911896 defendant Redyng Humphrey gent 596256 596256 Redyng, Humphrey, of Droytwyche, gent 0
3658332 1912859 1912859 defendant Newport Richard gent 596256 596256 Newport, Richard, of Droytwyche, gent 0
3722955 1933445 1933445 plaintiff Newport Richard gent 596256 596256 Newport, Richard, of Droytwyche, gent 0
3751411 1942356 1942356 plaintiff Newport Richard, senior gent 596256 596256 Newport, Richard, senior, of Droytwyche, gent 0
3765520 1946879 1946879 defendant Wyllyams John butcher 596256 596256 Wyllyams, John, of Droytwyche, butcher 0
3767696 1947532 1947532 defendant Newport William gent 596256 596256 Newport, William, of Droytwyche, gent 0
3783562 1952616 1952616 defendant Wyllyams John butcher 596256 596256 Wyllyams, John, of Droytwyche, butcher 0
3783563 1952616 1952616 defendant Hylle John husbandman 596256 596256 Hylle, John, of Droytwyche, husbandman 1
3798133 1957312 1957312 defendant Newport William gent 596256 596256 Newport, William, of Droytwyche, gent 0
3810455 1961163 1961163 defendant Newport William gent 596256 596256 Newport, William, of Droytwyche, gent 0
3810942 1961323 1961323 defendant Barnard John sherman 596256 596256 Barnard, John, of Droytwyche, sherman 2
3810944 1961324 1961324 plaintiff Butler John gent 596256 596256 Butler, John, of Droytwyche, gent 0
3810947 1961324 1961324 defendant Burnard John sherman 596256 596256 Burnard, John, of Droytwyche, sherman 2
3815522 1962770 1962770 defendant Newport William gent 596256 596256 Newport, William, of Droytwyche, gent 0
3817862 1963502 1963502 defendant Hyll Richard butcher 596256 596256 Hyll, Richard, of Droytwyche, butcher 0
3823209 1965172 1965172 defendant Towneclerke John mercer 596256 596256 Towneclerke, John, of Droytwyche, mercer 2
3825598 1965856 1965856 defendant Peter Roger butcher 596256 596256 Peter, Roger, of Droytwyche, butcher 3
3844020 1971673 1971673 defendant Croswell Simon husbandman 596256 596256 Croswell, Simon, of Droytwyche, husbandman 0
3850799 1973844 1973844 defendant Williams alias Hardyng John butcher 596256 596256 Williams alias Hardyng, John, of Droytwyche, butcher 0
3856132 1975539 1975539 defendant Colles Henry barber 596256 596256 Colles, Henry, of Droytwyche, barber 0
3874149 1981576 1981576 defendant Wynnys John tanner 596256 596256 Wynnys, John, of Droytwyche, tanner 0
3892670 1987798 1987798 plaintiff Newport Richard, senior (legal representative) 596256 596256 Newport, Richard, senior, of Droytwyche, gent, executor of 0
3892674 1987799 1987799 plaintiff Newport Richard, senior (legal representative) 596256 596256 Newport, Richard, senior, of Droytwyche, gent, executor of 0
3897268 1989303 1989303 defendant Bannard John yeoman 596256 596256 Bannard, John, of Droytwyche, yeoman 0
3897475 1989369 1989369 defendant Kynnett Hugh tailor 596256 596256 Kynnett, Hugh, of Droytwyche, tailor 0
3897972 1989528 1989528 defendant Kynnett Hugh tallowchandler 596256 596256 Kynnett, Hugh, of Droytwyche, tallowchandler 0
3907049 1992646 1992646 plaintiff Newport Richard (legal representative) 596256 596256 Newport, Richard, of Droytwyche, gent, executor of 0
3907052 1992647 1992647 plaintiff Newport Richard (legal representative) 596256 596256 Newport, Richard, of Droytwyche, gent, executor of 0
3907058 1992649 1992649 plaintiff Newport Richard, senior (legal representative) 596256 596256 Newport, Richard, senior, of Droytwyche, gent, executor of 0
3912451 1994494 1994494 defendant Brode William husbandman 596256 596256 Brode, William, of Droytwyche, husbandman 0
3912452 1994494 1994494 defendant Pratt Robert butcher 596256 596256 Pratt, Robert, of Droytwyche, butcher 1
3912836 1994624 1994624 defendant Butler John gent 596256 596256 Butler, John, of Droytwyche, gent 0
3912838 1994624 1994624 defendant Hyll Richard butcher 596256 596256 Hyll, Richard, of Droytwyche, butcher 2
3912839 1994624 1994624 defendant Harrys John husbandman 596256 596256 Harrys, John, of Droytwyche, husbandman 3
3917260 1996131 1996131 defendant Barrett Thomas carver 596256 596256 Barrett, Thomas, of Droytwyche, carver 0
3920829 1997312 1997312 defendant Hyll Walter yeoman 596256 596256 Hyll, Walter, of Droytwyche, yeoman 0
3920830 1997312 1997312 defendant Wolde Thomas   596256 596256 Wolde, Thomas, of Droytwyche, salt maker 1
3920831 1997312 1997312 defendant Tylson John   596256 596256 Tylson, John, of Droytwyche, salt maker 2
3921606 1997571 1997571 defendant Harrys Thomas husbandman 596256 596256 Harrys, Thomas, of Droytwyche, husbandman 1
3923096 1998028 1998028 defendant Wheler John (legal representative) 596256 596256 Wheler, John, of Droytwyche, gent, executor of 0
3925911 1998981 1998981 defendant Dethyk William gent 596256 596256 Dethyk, William, of Droytwyche, gent 0
3942933 2004642 2004642 defendant Peynter George smith 596256 596256 Peynter, George, of Droytwyche, smith 0
3942935 2004642 2004642 defendant Barnard Thomas laborer 596256 596256 Barnard, Thomas, of Droytwyche, laborer 2
3952491 2007939 2007939 defendant Alam or Alain John yeoman 596256 596256 Alam or Alain, John, of Droytwyche, yeoman 3
3971515 2014597 2014597 defendant Crassewall George salter 596256 596256 Crassewall, George, of Droytwyche, salter 0
3971914 2014736 2014736 defendant Dawkes Thomas yeoman 596256 596256 Dawkes, Thomas, of Droytwyche, yeoman 0
3971915 2014736 2014736 defendant Dawkes Richard weaver 596256 596256 Dawkes, Richard, of Droytwyche, weaver 1
3971916 2014736 2014736 defendant Beddell George dyer 596256 596256 Beddell, George, of Droytwyche, dyer 2
3972671 2015018 2015018 plaintiff Geffreys John yeoman 596256 596256 Geffreys, John, of Droytwyche, yeoman 0
3977335 2016644 2016644 defendant Woodward John yeoman 596256 596256 Woodward, John, of Droytwyche, yeoman 0
3991713 2021794 2021794 defendant Smyth Humphrey smith 596256 596256 Smyth, Humphrey, of Droytwyche, smith 0
3997735 2023946 2023946 defendant Butler William gent 596256 596256 Butler, William, of Droytwyche, gent 0
4009334 2028103 2028103 defendant Elexanders Thomas gent 596256 596256 Elexanders, Thomas, of Droytwyche, gent 0
4060567 2046182 2046182 defendant Langford alias Olyver William tanner 596256 596256 Langford alias Olyver, William, of Droytwyche, tanner 0
4060568 2046182 2046182 defendant Hadley John yeoman 596256 596256 Hadley, John, of Droytwyche, yeoman 1
4091641 2057304 2057304 defendant Iryshe Nicholas husbandman 596256 596256 Iryshe, Nicholas, of Droytwyche, or of Bradley, husbandman 0
4091644 2057305 2057305 defendant Pytman Richard cooper 596256 596256 Pytman, Richard, of Droytwyche, cooper 0
4136808 2073514 2073514 defendant Dawkes Richard laborer 596256 596256 Dawkes, Richard, of Droytwyche, laborer 2
4136809 2073514 2073514 defendant Bache Philip laborer 596256 596256 Bache, Philip, of Droytwyche, laborer 3
4233906 2107388 2107388 defendant Colles or Cole John yeoman 596256 596256 Colles or Cole, John, of Droytwyche, yeoman 0
4283641 2124185 2124185 defendant Wythe Thomas gent 596256 596256 Wythe, Thomas, of Droytwyche, gent 0
4330658 2140547 2140547 defendant Brace Philip gent 596256 596256 Brace, Philip, of Droytwyche, gent 1
4396257 2163321 2163321 defendant Howle John gent 596256 596256 Howle, John, of Droytwyche, gent 0
4402382 2165384 2165384 defendant Bourne John husbandman 596256 596256 Bourne, John, of Droytwyche, husbandman 0
4412065 2168626 2168626 defendant Bradhurste Thomas shoemaker 596256 596256 Bradhurste, Thomas, of Droytwyche, shoemaker 1

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