names

52 rows where place_id = 598670

✎ 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
3633502 1905292 1905292 defendant Coke Simon weaver 598670 598670 Coke, Simon, of Laneham, weaver 2
3633503 1905292 1905292 defendant Prycke Simon weaver 598670 598670 Prycke, Simon, of Laneham, weaver 3
3633504 1905292 1905292 defendant Godderd Augustine smith 598670 598670 Godderd, Augustine, of Laneham, smith 4
3637745 1906621 1906621 plaintiff Spryng Thomas clothmaker 598670 598670 Spryng, Thomas, of Laneham, clothmaker 0
3637747 1906622 1906622 plaintiff Spryng Thomas clothmaker 598670 598670 Spryng, Thomas, of Laneham, clothmaker 0
3695359 1924773 1924773 defendant Sharman Roger butcher 598670 598670 Sharman, Roger, of Laneham, butcher 0
3696586 1925165 1925165 defendant Lynche William clothmaker 598670 598670 Lynche, William, of Laneham, clothmaker 1
3710047 1929452 1929452 defendant Sharman Roger butcher 598670 598670 Sharman, Roger, of Laneham, butcher 2
3740170 1938784 1938784 defendant Sexten Robert clothmaker 598670 598670 Sexten, Robert, of Laneham, clothmaker 1
3752726 1942780 1942780 defendant Barker Anne widow 598670 598670 Barker, Anne, of Laneham, widow 0
3752729 1942781 1942781 defendant Barker William weaver 598670 598670 Barker, William, of Laneham, weaver 0
3762933 1946040 1946040 plaintiff Grome Robert clothmaker 598670 598670 Grome, Robert, of Laneham, clothmaker 0
3775959 1950227 1950227 defendant Clarke John carrier 598670 598670 Clarke, John, of Laneham, carrier 2
3787352 1953837 1953837 plaintiff Robson William (legal representative) 598670 598670 Robson, William, of Laneham, clothmaker, executors of 0
3787354 1953837 1953837 defendant Barker Amy widow 598670 598670 Barker, Amy, of Laneham, widow 0
3790405 1954818 1954818 plaintiff Waryn Robert smith 598670 598670 Waryn, Robert, of Laneham, smith 0
3796295 1956708 1956708 defendant Clark John carrier 598670 598670 Clark, John, of Laneham, carrier 2
3824542 1965548 1965548 defendant Rogels Thomas fuller 598670 598670 Rogels, Thomas, of Laneham, fuller 0
3843021 1971346 1971346 defendant Clerke John carrier 598670 598670 Clerke, John, of Laneham, carrier 0
3850007 1973590 1973590 plaintiff Marshall John   598670 598670 Marshall, John, of Laneham 0
3869930 1980185 1980185 defendant Sporne Thomas clothier 598670 598670 Sporne, Thomas, of Laneham, clothier 2
3933198 2001399 2001399 defendant Markham Nicholas gent 598670 598670 Markham, Nicholas, of Laneham, gent 0
3933199 2001399 2001399 defendant Slegh Edmund yeoman 598670 598670 Slegh, Edmund, of Laneham, yeoman 1
3933200 2001399 2001399 defendant Puttrell Edmund yeoman 598670 598670 Puttrell, Edmund, of Laneham, yeoman 2
3933202 2001399 2001399 defendant Carter Thomas laborer 598670 598670 Carter, Thomas, of Laneham, laborer 4
3936101 2002396 2002396 defendant Spryng Nicholas clothier 598670 598670 Spryng, Nicholas, of Laneham, clothier 0
3979304 2017347 2017347 plaintiff Bellamy Oliver yeoman 598670 598670 Bellamy, Oliver, of Laneham, yeoman 1
3979308 2017348 2017348 plaintiff Bellamy Olover yeoman 598670 598670 Bellamy, Olover, of Laneham, yeoman 2
4022051 2032617 2032617 defendant Markeham Elias esq 598670 598670 Markeham, Elias, of Laneham, esq 0
4048237 2041809 2041809 plaintiff Syngleton Thomas gent 598670 598670 Syngleton, Thomas, of Laneham , gent 0
4125677 2069466 2069466 defendant Crecoo Edward tailor 598670 598670 Crecoo, Edward, of Laneham, tailor 0
4197091 2094535 2094535 defendant Crecoo Edward tailor 598670 598670 Crecoo, Edward, of Laneham, tailor 0
4457126 2187238 2187238 defendant Vicary John   598670 598670 Vicary, John, of Laneham 0
4457165 2187251 2187251 defendant Vic-- John   598670 598670 Vic--, John, of Laneham 0
4457168 2187252 2187252 defendant Vycory John   598670 598670 Vycory, John, of Laneham 0
4486816 2196590 2196590 defendant Slote John   598670 598670 Slote, John, of Laneham, wright 0
4953002 2342863 2342863 defendant Kypp- Robert fuller 598670 598670 Kypp-, Robert, of Laneham, fuller 1
5278558 2438838 2438838 defendant Joly Robert weaver 598670 598670 Joly, Robert, of Laneham, weaver 1
5278559 2438838 2438838 defendant Pere Thomas baker 598670 598670 Pere, Thomas, of Laneham, baker 2
5300596 2445140 2445140 defendant Batty William tailor 598670 598670 Batty, William, of Laneham, tailor 0
5300597 2445140 2445140 defendant Quyntan Thomas laborer 598670 598670 Quyntan, Thomas, of Laneham, laborer 1
5501803 2505493 2505493 defendant Barker William clothman 598670 598670 Barker, William, of Laneham, clothman 3
5545577 2518690 2518690 plaintiff Spryng Thomas clothmaker 598670 598670 Spryng, Thomas, of Laneham, merchant, clothmaker 0
5545579 2518690 2518690 defendant Preston Adam goldsmith 598670 598670 Preston, Adam, of Laneham, goldsmith 1
5566936 2524926 2524926 plaintiff Crytott Robert   598670 598670 Crytott, Robert, of Laneham 0
5568915 2525460 2525460 defendant Barber John clothman 598670 598670 Barber, John, of Laneham, clothman 0
5575420 2527403 2527403 plaintiff Spryng Thomas clothmaker 598670 598670 Spryng, Thomas, of Laneham, clothmaker 0
5575422 2527404 2527404 plaintiff Spryng Thomas clothmaker 598670 598670 Spryng, Thomas, of Laneham, clothmaker 0
5578936 2528481 2528481 plaintiff Baron Richard   598670 598670 Baron, Richard, of Laneham, single man 0
5581916 2529426 2529426 plaintiff Crytott Robert   598670 598670 Crytott, Robert, of Laneham 0
5583364 2529870 2529870 defendant Rede Robert chaplain 598670 598670 Rede, Robert, of Laneham, chaplain 1
5589712 2531778 2531778 defendant Bettys Robert yeoman 598670 598670 Bettys, Robert, of Laneham, yeoman 2

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