names

74 rows where place_id = 627103

✎ 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
3774216 1949652 1949652 defendant Clarke Thomas laborer 627103 627103 Clarke, Thomas, of Barrowe, laborer 0
3778172 1950879 1950879 defendant Tayllour Robert husbandman 627103 627103 Tayllour, Robert, of Barrowe, husbandman 2
3778344 1950939 1950939 defendant Wakefeld John husbandman 627103 627103 Wakefeld, John, of Barrowe, husbandman 0
3781597 1951982 1951982 plaintiff Harryson Nicholas clerk 627103 627103 Harryson, Nicholas, of Barrowe, clerk 0
3919811 1996962 1996962 defendant Plesaunce George husbandman 627103 627103 Plesaunce, George, of Barrowe, husbandman 1
3934363 2001786 2001786 defendant Baldwyn William yeoman 627103 627103 Baldwyn, William, of Barrowe, yeoman 0
3944574 2005201 2005201 defendant Baylley John husbandman 627103 627103 Baylley, John, of Barrowe on Humber, husbandman 0
3960646 2010825 2010825 plaintiff Symond William yeoman 627103 627103 Symond, William, of Barrowe, yeoman 0
3962855 2011600 2011600 defendant Bawdwyn William yeoman 627103 627103 Bawdwyn, William, of Barrowe, yeoman 1
3967729 2013347 2013347 defendant Whytehand alias Pratt Edward yeoman 627103 627103 Whytehand alias Pratt, Edward, of Barrowe, yeoman 0
3970949 2014397 2014397 defendant Rase Thomas husbandman 627103 627103 Rase, Thomas, of Barrowe, or of Norton Subcors, husbandman 0
3975022 2015826 2015826 defendant Brodrepp John yeoman 627103 627103 Brodrepp, John, of Barrowe, yeoman 0
3976072 2016199 2016199 defendant Hygham Clement   627103 627103 Hygham, Clement, of Barrowe, knight 4
3981571 2018165 2018165 defendant Crayke John husbandman 627103 627103 Crayke, John, of Barrowe, husbandman 3
3983133 2018741 2018741 defendant Whytehande alias Pratte Edward yeoman 627103 627103 Whytehande alias Pratte, Edward, of Barrowe, yeoman 0
3983262 2018786 2018786 defendant Whytelande alias Pratte Edward yeoman 627103 627103 Whytelande alias Pratte, Edward, of Barrowe, yeoman 0
3985304 2019501 2019501 defendant Randolffe Nicholas husbandman 627103 627103 Randolffe, Nicholas, of Barrowe, husbandman 0
3986820 2020027 2020027 defendant Bawdyng William yeoman 627103 627103 Bawdyng, William, of Barrowe, yeoman 1
4005413 2026717 2026717 plaintiff Knyght John yeoman 627103 627103 Knyght, John, of Barrowe, yeoman 0
4006321 2027039 2027039 defendant Symond William yeoman 627103 627103 Symond, William, of Barrowe, yeoman 1
4012857 2029322 2029322 defendant Baydwyne William   627103 627103 Baydwyne, William, of Barrowe, Lincs yeoman, son of William Baudewyn 2
4020103 2031912 2031912 defendant Whytehand alias Pratt Edward yeoman 627103 627103 Whytehand alias Pratt, Edward, of Barrowe, yeoman 0
4032859 2036407 2036407 defendant Whithand alias Pratt Edward yeoman 627103 627103 Whithand alias Pratt, Edward, of Barrowe, yeoman 0
4034019 2036823 2036823 defendant Adams Richard, senior yeoman 627103 627103 Adams, Richard, senior, of Barrowe, yeoman 1
4034020 2036823 2036823 defendant Adams Richard, junior yeoman 627103 627103 Adams, Richard, junior, of Barrowe, yeoman 2
4035458 2037353 2037353 defendant Dodd John husbandman 627103 627103 Dodd, John, of Barrowe, husbandman 0
4073487 2050803 2050803 plaintiff Plesaunce Thomas yeoman 627103 627103 Plesaunce, Thomas, of Barrowe, yeoman 0
4077438 2052219 2052219 defendant Turner Richard yeoman 627103 627103 Turner, Richard, of Barrowe, yeoman 1
4077442 2052220 2052220 defendant Turner Richard yeoman 627103 627103 Turner, Richard, of Barrowe, yeoman 0
4077636 2052289 2052289 defendant Doughtye Thomas husbandman 627103 627103 Doughtye, Thomas, of Barrowe, husbandman 0
4094635 2058420 2058420 defendant Tawbett John husbandman 627103 627103 Tawbett, John, of Barrowe, husbandman 0
4096986 2059250 2059250 defendant Dodd John yeoman 627103 627103 Dodd, John, of Barrowe, yeoman 0
4115776 2065925 2065925 defendant Savell Henry (legal representative) 627103 627103 Savell, Henry, of Barrowe, esq, executor of 0
4122159 2068230 2068230 defendant Hyldersham Edward gent 627103 627103 Hyldersham, Edward, of Barrowe, gent 0
4129355 2070802 2070802 defendant Robert John husbandman 627103 627103 Robert, John, of Barrowe, husbandman 1
4140591 2074875 2074875 defendant Poole John gent 627103 627103 Poole, John, of Barrowe, gent 0
4145393 2076547 2076547 defendant Lockwood Thomas yeoman 627103 627103 Lockwood, Thomas, of Barrowe, yeoman 1
4162335 2082386 2082386 defendant Kynge William husbandman 627103 627103 Kynge, William, of Barrowe, husbandman 2
4162346 2082388 2082388 defendant Sergyant Ralph husbandman 627103 627103 Sergyant, Ralph, of Barrowe, husbandman 2
4166077 2083641 2083641 defendant Crake John husbandman 627103 627103 Crake, John, of Barrowe, husbandman 0
4171431 2085471 2085471 defendant Dodde John, senior yeoman 627103 627103 Dodde, John, senior, of Barrowe, yeoman 0
4181164 2088890 2088890 defendant Hobbes John yeoman 627103 627103 Hobbes, John, of Barrowe, yeoman 0
4189494 2091824 2091824 defendant Sergeant Ralph husbandman 627103 627103 Sergeant, Ralph, of Barrowe, husbandman 0
4189497 2091825 2091825 defendant Sergeaunt Ralph husbandman 627103 627103 Sergeaunt, Ralph, of Barrowe, husbandman 0
4189603 2091864 2091864 defendant Stevenson John yeoman 627103 627103 Stevenson, John, of Barrowe, yeoman 0
4194563 2093653 2093653 defendant Dodde John, senior yeoman 627103 627103 Dodde, John, senior, of Barrowe, yeoman 0
4212455 2099904 2099904 defendant Michells William   627103 627103 Michells, William, of Barrowe husbandman 1
4214402 2100543 2100543 defendant Beane William carpenter 627103 627103 Beane, William, of Barrowe, carpenter 2
4218325 2101906 2101906 defendant Nobbes Peter blacksmith 627103 627103 Nobbes, Peter, of Barrowe, blacksmith 1
4218793 2102071 2102071 defendant Kyne Robert yeoman 627103 627103 Kyne, Robert, of Barrowe, yeoman 1
4224464 2104037 2104037 defendant M- Thomas   627103 627103 M-, Thomas, of Barrowe yeoman 3
4232644 2106920 2106920 defendant Mighell Thomas yeoman 627103 627103 Mighell, Thomas, of Barrowe, yeoman 3
4236126 2108206 2108206 defendant Wakefeild William yeoman 627103 627103 Wakefeild, William, of Barrowe, yeoman 0
4240056 2109647 2109647 defendant Warner Edward   627103 627103 Warner, Edward, of Barrowe gent 0
4243812 2110911 2110911 defendant Warner Edward gent 627103 627103 Warner, Edward, of Barrowe, gent 0
4245369 2111425 2111425 defendant Fowler Robert yeoman 627103 627103 Fowler, Robert, of Barrowe, yeoman 0
4245886 2111604 2111604 defendant Nicolls Thomas yeoman 627103 627103 Nicolls, Thomas, of Barrowe, yeoman 0
4256603 2115178 2115178 defendant Burryshe Robert yeoman 627103 627103 Burryshe, Robert, of Barrowe, yeoman 3
4257297 2115417 2115417 defendant Fowler Robert yeoman 627103 627103 Fowler, Robert, of Barrowe, yeoman 0
4263447 2117438 2117438 defendant Bray Robert yeoman 627103 627103 Bray, Robert, of Barrowe, yeoman 3
4284280 2124428 2124428 defendant Kene Robert yeoman 627103 627103 Kene, Robert, of Barrowe, yeoman 1
4309014 2133307 2133307 defendant Fowler Robert husbandman 627103 627103 Fowler, Robert, of Barrowe, husbandman 0
4320868 2137391 2137391 defendant Bussell William husbandman 627103 627103 Bussell, William, of Barrowe, husbandman 0
4345374 2145657 2145657 defendant Tincker Thomas husbandman 627103 627103 Tincker, Thomas, of Barrowe, husbandman 1
4350523 2147446 2147446 defendant Wade Ralph yeoman 627103 627103 Wade, Ralph, of Barrowe, yeoman 0
4359268 2150476 2150476 defendant Birkell Robert butcher 627103 627103 Birkell, Robert, of Barrowe, butcher 0
4360094 2150774 2150774 defendant Welcome William   627103 627103 together with Welcome, William, of Barrowe gent 1
4360096 2150775 2150775 defendant Welcome William gent 627103 627103 Welcome, William, of Barrowe, gent 0
4362825 2151764 2151764 defendant Braye Robert   627103 627103 Braye, Robert, of Barrowe yeoman 1
4367653 2153484 2153484 defendant Wayde Ralph gent 627103 627103 Wayde, Ralph, of Barrowe, gent 1
4367654 2153484 2153484 defendant Hollome Lawrence yeoman 627103 627103 Hollome, Lawrence, of Barrowe ,yeoman 2
4368869 2153921 2153921 defendant Fowler Robert yeoman 627103 627103 Fowler, Robert, of Barrowe, yeoman 0
4396105 2163271 2163271 defendant Baxter Thomas husbandman 627103 627103 Baxter, Thomas, of Barrowe, husbandman 1
4401330 2165042 2165042 defendant Turner Richard yeoman 627103 627103 Turner, Richard, of Barrowe, yeoman 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);