names

48 rows where place_id = 591157

✎ 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
3603524 1868769 1868769 defendant Baxter William butcher 591157 591157 Baxter, William, of Newerke, butcher 0
3605233 1869305 1869305 plaintiff Hun Andrew   591157 591157 Hun, Andrew, of Newerke 0
3605237 1869305 1869305 defendant Tayllour Edmund mercer 591157 591157 Tayllour, Edmund, of Newerke, mercer 0
3697492 1925435 1925435 defendant Woode Elizabeth widow 591157 591157 Woode, Elizabeth, of Newerke, widow 1
3779657 1951369 1951369 defendant Fresby Thomas mercer 591157 591157 Fresby, Thomas, of Newerke, mercer 0
3794767 1956241 1956241 defendant Hogge John yeoman 591157 591157 Hogge, John, of Newerke, yeoman 1
3800486 1958074 1958074 plaintiff Lucas Richard gent 591157 591157 Lucas, Richard, of Newerke, gent 0
3800489 1958075 1958075 plaintiff Lucas Richard gent 591157 591157 Lucas, Richard, of Newerke, gent 0
3807278 1960173 1960173 defendant Clerke Thomas mercer 591157 591157 Clerke, Thomas, of Newerke, mercer 1
3824824 1965641 1965641 defendant Clerke Thomas mercer 591157 591157 Clerke, Thomas, of Newerke, mercer 0
4493131 2198554 2198554 defendant Tamworth Thomas fishmonger 591157 591157 Tamworth, Thomas, of Newerke, fishmonger 0
4493133 2198555 2198555 defendant Tamworth Thomas fishmonger 591157 591157 Tamworth, Thomas, of Newerke, fishmonger 0
4510745 2203817 2203817 defendant Preston Stephen de   591157 591157 Preston, Stephen de, of Newerke 0
4696167 2264283 2264283 defendant Mirfyn Thomas mercer 591157 591157 Mirfyn, Thomas, of Newerke, mercer 0
4707815 2267813 2267813 defendant Purion John   591157 591157 Purion, John, of Newerke, rope maker 0
4713973 2269699 2269699 plaintiff Taverner Thomas   591157 591157 Taverner, Thomas, of Newerke 0
4721662 2272109 2272109 defendant Westeby John yeoman 591157 591157 Westeby, John, of Newerke, yeoman 0
4835223 2307016 2307016 defendant Wylns John baker 591157 591157 Wylns, John, of Newerke, baker 0
4853268 2312439 2312439 defendant Padley John butcher 591157 591157 Padley, John, of Newerke, butcher 0
4853269 2312439 2312439 defendant (illegible) William butcher 591157 591157 _, William, of Newerke, butcher 1
4853270 2312439 2312439 defendant Rasyn William butcher 591157 591157 Rasyn, William, of Newerke, butcher 2
4853865 2312619 2312619 defendant Lake Margaret widow 591157 591157 Lake, Margaret, of Newerke, widow 0
4870558 2317765 2317765 defendant Cl- John glover 591157 591157 Cl-, John, of Newerke, glover 0
4870559 2317765 2317765 defendant Stalee Richard yeoman 591157 591157 Stalee, Richard, of Newerke, yeoman 1
4874467 2318958 2318958 defendant Marnham Walter   591157 591157 Marnham, Walter, of Newerke, skeppere or skipper 0
4927583 2335063 2335063 defendant Amysby William chapman 591157 591157 Amysby, William, of Newerke, chapman 0
5054742 2372996 2372996 defendant Bocher Roger butcher 591157 591157 Bocher, Roger, of Newerke, butcher 1
5061915 2375160 2375160 defendant Coke William husbandman 591157 591157 Coke, William, of Newerke, husbandman 0
5236675 2426310 2426310 defendant Kyrk John cardmaker 591157 591157 Kyrk, John, of Newerke, cardmaker 1
5252954 2431037 2431037 defendant Spilsbe John dyer 591157 591157 Spilsbe, John, of Newerke, dyer 0
5261182 2433611 2433611 defendant Baldok Richard yeoman 591157 591157 Baldok, Richard, of Newerke, yeoman 1
5435511 2485558 2485558 defendant Cornne William   591157 591157 Cornne, William, of Newerke, bow maker 0
5435513 2485559 2485559 defendant Corune or Corime William bowmaker 591157 591157 Corune or Corime, William, of Newerke, bowmaker 0
5442531 2487681 2487681 plaintiff Bevercotes Alexander gent 591157 591157 Bevercotes, Alexander, of Newerke, gent 0
5455233 2491486 2491486 plaintiff Bevercotes Alexander gent 591157 591157 Bevercotes, Alexander, of Newerke, gent 0
5501567 2505420 2505420 defendant Ingyll William carpenter 591157 591157 Ingyll, William, of Newerke, carpenter 5
5501568 2505420 2505420 defendant Ingyll William tailor 591157 591157 Ingyll, William, of Newerke, tailor 6
5501569 2505420 2505420 defendant Davill Thomas yeoman 591157 591157 Davill, Thomas, of Newerke, yeoman 7
5506315 2506889 2506889 plaintiff Calcroft John (legal representative) 591157 591157 Calcroft, John, of Newerke, merchant, executors of 0
5506318 2506889 2506889 defendant Skotte John tanner 591157 591157 Skotte, John, of Newerke, tanner 0
5506319 2506890 2506890 plaintiff Calcrofte John (legal representative) 591157 591157 Calcrofte, John, of Newerke, executors of 0
5509967 2507955 2507955 defendant Fowecher William baker 591157 591157 Fowecher, William, of Newerke, baker 0
5530847 2514163 2514163 defendant Toller Mathew carver 591157 591157 Toller, Mathew, of Newerke, carver 0
5530848 2514163 2514163 defendant Toller John carver 591157 591157 Toller, John, of Newerke, carver 1
5550536 2520180 2520180 defendant Cade William gent 591157 591157 Cade, William, of Newerke, gent 0
5557383 2522123 2522123 plaintiff Moysley Robert   591157 591157 Moysley, Robert, of Newerke, cape maker 0
5588281 2531337 2531337 defendant Swayne Thomas (legal representative) 591157 591157 Swayne, Thomas, of Newerke, butcher, executors of 0
5592943 2532790 2532790 defendant Button Thomas glover 591157 591157 Button, Thomas, of Newerke, glover 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);