names

156 rows where place_id = 589865

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599051 1867338 1867338 defendant Beke John barber 589865 589865 Beke, John, of Newark, barber 0
3603667 1868815 1868815 defendant Hart Thomas scrivener and court holder 589865 589865 Hart, Thomas, of Newark, scrivener and court holder 1
3611705 1871323 1871323 defendant Barbour Thomas yeoman 589865 589865 Barbour, Thomas, of Newark, yeoman 0
3619660 1873718 1873718 plaintiff Jakson John fishmonger 589865 589865 Jakson, John, of Newark, fishmonger 0
3620841 1874081 1874081 defendant Gelston Richard yeoman 589865 589865 Gelston, Richard, of Newark, yeoman 0
3625564 1875531 1875531 defendant Devias Thomas gent 589865 589865 Devias, Thomas, of Newark, or of York, gent 0
3642837 1908208 1908208 defendant Hall John chapman 589865 589865 Hall, John,of Newark, chapman 0
3705351 1927963 1927963 defendant Semson John (legal representative) 589865 589865 Semson, John, of Newark, draper, executors of 1
3712157 1930120 1930120 defendant Sympson John chaplain 589865 589865 Sympson, John, of Newark, chaplain 2
3719417 1932349 1932349 defendant Baty John smith 589865 589865 Baty, John, of Newark, smith 1
3719439 1932353 1932353 defendant Sympson John (legal representative) 589865 589865 Sympson, John, of Newark, draper, executors of 3
3719441 1932353 1932353 defendant Jakson Robert draper 589865 589865 Jakson, Robert, of Newark, draper 5
3719442 1932353 1932353 defendant Baty John smith 589865 589865 Baty, John, of Newark, smith 6
3748017 1941299 1941299 plaintiff Mereson John   589865 589865 Mereson, John, of Newark 3
3759900 1945087 1945087 defendant Jakson Robert yeoman 589865 589865 Jakson, Robert, of Newark, yeoman 0
3768484 1947793 1947793 plaintiff Penythorn William   589865 589865 Penythorn, William, of Newark 0
3769056 1947973 1947973 defendant Nutte Bartholomew tiler 589865 589865 Nutte, Bartholomew, of Newark, tiler 0
3769057 1947973 1947973 defendant Taillour Robert tiler 589865 589865 Taillour, Robert, of Newark, tiler 1
3769058 1947973 1947973 defendant Walker Robert baker 589865 589865 Walker, Robert, of Newark, baker 2
3775039 1949925 1949925 defendant Spaynyng John yeoman 589865 589865 Spaynyng, John, of Newark, yeoman 3
3775045 1949927 1949927 plaintiff Dennes William hardwareman 589865 589865 Dennes, William, of Newark, hardwareman 1
3789394 1954506 1954506 defendant Cole Thomas butcher 589865 589865 Cole, Thomas, of Newark, butcher 0
3789934 1954677 1954677 defendant Atkynson Ralph butcher 589865 589865 Atkynson, Ralph, of Newark, butcher 0
3800485 1958073 1958073 defendant Barley Arthur gent 589865 589865 Barley, Arthur, of Newark, gent 0
3800849 1958174 1958174 defendant Watkyns John weaver 589865 589865 Watkyns, John, of Newark, weaver 0
3800850 1958174 1958174 defendant Kechyn Richard glover 589865 589865 Kechyn, Richard, of Newark, glover 1
3800851 1958174 1958174 defendant Shawe William mercer 589865 589865 Shawe, William, of Newark, mercer 2
3806682 1959988 1959988 defendant Watson Lambert draper 589865 589865 Watson, Lambert, of Newark, draper 2
3807285 1960176 1960176 defendant Clerk Thomas mercer 589865 589865 Clerk, Thomas, of Newark, mercer 1
3814271 1962372 1962372 plaintiff Freisbye Thomas   589865 589865 Freisbye, Thomas, of Newark, yeoman, administrators of 0
3814275 1962373 1962373 plaintiff Freisbye Thomas   589865 589865 Freisbye, Thomas, of Newark, yeoman, administrators of 0
3839150 1970169 1970169 plaintiff Watson Lambert (legal representative) 589865 589865 Watson, Lambert, of Newark, draper, executors of 0
3839153 1970170 1970170 plaintiff Watson Lambert (legal representative) 589865 589865 Watson, Lambert, of Newark, draper, executors of 0
3839156 1970171 1970171 plaintiff Watson Lambert (legal representative) 589865 589865 Watson, Lambert, of Newark, draper, executors of 0
3845723 1972209 1972209 plaintiff Forster Anthony   589865 589865 Forster, Anthony, of Newark 0
3845724 1972209 1972209 defendant Cook Ralph baker 589865 589865 Cook, Ralph, of Newark, baker 0
3862697 1977718 1977718 defendant Jakson Andrew fishmonger 589865 589865 Jakson, Andrew, of Newark, fishmonger 0
3862698 1977718 1977718 defendant Pye Roland baker 589865 589865 Pye, Roland, of Newark, baker 1
3868792 1979803 1979803 defendant Ingole Henry shoemaker 589865 589865 Ingole, Henry, of Newark, shoemaker 2
3870940 1980531 1980531 defendant Brynkley Stephen merchant 589865 589865 Brynkley, Stephen, of Newark, merchant 0
3875738 1982135 1982135 defendant Harpam Thomas blacksmith 589865 589865 Harpam, Thomas, of Newark, blacksmith 0
3877413 1982692 1982692 plaintiff Hopkynson Henry yeoman 589865 589865 Hopkynson, Henry, of Newark, yeoman 0
3886355 1985692 1985692 defendant Golland George shoemaker 589865 589865 Golland, George, of Newark, shoemaker 0
3905084 1991964 1991964 defendant Fullwood John grazier 589865 589865 Fullwood, John, of Newark, grazier 0
3905085 1991964 1991964 defendant Anderson William   589865 589865 Anderson, William, of Newark, freemason 1
3916526 1995903 1995903 plaintiff Forster Anthony gent 589865 589865 Forster, Anthony, of Newark, gent 0
3919117 1996717 1996717 plaintiff Kelstern Hugh draper 589865 589865 Kelstern, Hugh, of Newark, draper 0
3935314 2002125 2002125 plaintiff Kelstern Hugh draper 589865 589865 Kelstern, Hugh, of Newark, draper 0
3937604 2002908 2002908 defendant Hytte Edmund laborer 589865 589865 Hytte, Edmund, of Newark, laborer 5
4028619 2034881 2034881 defendant Oldesworth Tacea widow 589865 589865 Oldesworth, Tacea, of Newark, widow 1
4044812 2040597 2040597 plaintiff Robynson William yeoman 589865 589865 Robynson, William, of Newark, yeoman 0
4044816 2040598 2040598 plaintiff Robynson William yeoman 589865 589865 Robynson, William, of Newark, yeoman 0
4133023 2072139 2072139 defendant Newcombe Augustine yeoman 589865 589865 Newcombe, Augustine, of Newark, yeoman 2
4226498 2104740 2104740 defendant Wilson James mercer 589865 589865 Wilson, James, of Newark, mercer 0
4418563 2170685 2170685 defendant Tukkesford William de   589865 589865 Tukkesford, William de, of Newark, son of Stephen 0
4451244 2185348 2185348 defendant Lilye William   589865 589865 Lilye, William, of Newark 0
4469688 2191187 2191187 defendant del More John   589865 589865 del More, John, of Newark 0
4492062 2198208 2198208 defendant Byldesthorop John de   589865 589865 Byldesthorop, John de, of Newark 1
4518331 2206107 2206107 defendant Cleyton Thomas de   589865 589865 Cleyton, Thomas de, of Newark 0
4520392 2206721 2206721 defendant Bakester John   589865 589865 Bakester, John, of Newark, son of John 0
4520524 2206768 2206768 defendant Bakestere John   589865 589865 Bakestere, John, of Newark, son of Elye 0
4530294 2209764 2209764 defendant Bower John   589865 589865 Bower, John, of Newark, son of Robert 0
4544905 2214324 2214324 defendant Wakeman John   589865 589865 Wakeman, John, of Newark 2
4563373 2220117 2220117 defendant Jonesson William   589865 589865 Jonesson, William, of Newark 1
4574861 2223665 2223665 plaintiff Blethe William   589865 589865 Blethe, William, of Newark 0
4628876 2239959 2239959 defendant Criche alias Maut Nicholas   589865 589865 Criche alias Maut, Nicholas, of Newark, son of Henry 0
4639419 2243043 2243043 defendant Kelm Robert   589865 589865 Kelm, Robert, of Newark 0
4661482 2249419 2249419 defendant Danneton John, junior draper 589865 589865 Danneton, John, junior, of Newark, draper 1
4674970 2257780 2257780 defendant Warde Nicholas husbandman 589865 589865 Warde, Nicholas, of Newark, husbandman 1
4698001 2264865 2264865 plaintiff Cotyngham William mercer 589865 589865 Cotyngham, William, of Newark, mercer 0
4698004 2264866 2264866 plaintiff Cotyngham William mercer 589865 589865 Cotyngham, William, of Newark, mercer 0
4710684 2268699 2268699 defendant Padley John husbandman 589865 589865 Padley, John, of Newark, husbandman 3
4719159 2271340 2271340 defendant Mussh_ John   589865 589865 Mussh_, John, of Newark, bow maker 2
4732653 2275390 2275390 defendant Lake Margaret widow 589865 589865 Lake, Margaret, of Newark, widow 0
4757237 2282636 2282636 defendant Goldsmyth William   589865 589865 Goldsmyth, William, of Newark, gold smith 0
4760743 2283701 2283701 plaintiff Danette John   589865 589865 Danette, John, of Newark 0
4775354 2288286 2288286 defendant Rasyn William   589865 589865 Rasyn, William, of Newark 2
4788125 2292359 2292359 plaintiff Haukeley Henry, junior   589865 589865 Haukeley, Henry, junior, of Newark 0
4815945 2301078 2301078 defendant Brandon John merchant 589865 589865 Brandon, John, of Newark, merchant 1
4843098 2309370 2309370 defendant Staley Richard yeoman 589865 589865 Staley, Richard, of Newark, yeoman 0
4843099 2309370 2309370 defendant Drury Richard butcher 589865 589865 Drury, Richard, of Newark, butcher 1
4843101 2309370 2309370 defendant Cowepar William butcher 589865 589865 Cowepar, William, of Newark, butcher 3
4876385 2319575 2319575 defendant Sherman Robert butcher 589865 589865 Sherman, Robert, of Newark, butcher 0
4973652 2349071 2349071 defendant More Richard skinner 589865 589865 More, Richard, of Newark, skinner 1
4979465 2350814 2350814 defendant Penythorn William merchant 589865 589865 Penythorn, William, of Newark, merchant 0
5027304 2364861 2364861 defendant Storbull John miller 589865 589865 Storbull, John, of Newark, miller 0
5027305 2364861 2364861 defendant Walker William draper 589865 589865 Walker, William, of Newark, draper 1
5027306 2364861 2364861 defendant Scurse John laborer 589865 589865 Scurse, John, of Newark, laborer 2
5055013 2373063 2373063 defendant Walsh Richard butcher 589865 589865 Walsh, Richard, of Newark, butcher 0
5056136 2373411 2373411 defendant Clerke John glover 589865 589865 Clerke, John, of Newark, glover 0
5065814 2376296 2376296 defendant Brigge Richard sherman 589865 589865 Brigge, Richard, of Newark, sherman 1
5082836 2381372 2381372 defendant Beynbryngge Thomas chaplain 589865 589865 Beynbryngge, Thomas, of Newark, chaplain 2
5082837 2381372 2381372 defendant Mytton William chaplain 589865 589865 Mytton, William, of Newark, chaplain 3
5194214 2414038 2414038 defendant Deconson John chapman 589865 589865 Deconson, John, of Newark, chapman 0
5194215 2414038 2414038 defendant Mathewe William shoemaker 589865 589865 Mathewe, William, of Newark, shoemaker 1
5225331 2423080 2423080 defendant Rynghely John chapman or cook 589865 589865 Rynghely, John, of Newark, chapman or cook 0
5231610 2424828 2424828 defendant Devias John gent 589865 589865 Devias, John, of Newark, gent 0
5236918 2426379 2426379 defendant Hanworth William yeoman 589865 589865 Hanworth, William, of Newark, yeoman 0
5242039 2427877 2427877 defendant Penythorn John (legal representative) 589865 589865 Penythorn, John, of Newark, executor of 0
5242103 2427890 2427890 defendant Benet John chapman 589865 589865 Benet, John, of Newark, chapman 2

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