names

47 rows where place_id = 586434

✎ 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
3588716 1864113 1864113 defendant Coke William chapman 586434 586434 Coke, William, of Louth, Lincs, chapman 3
3590131 1864550 1864550 defendant Smyth John (legal representative) 586434 586434 Smyth, John, of Louth, Lincs, husbandman, executrix of 0
3641306 1907731 1907731 defendant Taillour Thomas draper 586434 586434 Taillour, Thomas, of Louth, Lincs, draper 0
3642050 1907964 1907964 defendant Burgh Robert tanner 586434 586434 Burgh, Robert, of Louth, Lincs, tanner 0
3691154 1923396 1923396 defendant Crathorn Bernard gent 586434 586434 Crathorn, Bernard, of Louth, Lincs, gent 0
3722003 1933144 1933144 defendant Tregold Robert yeoman 586434 586434 Tregold, Robert, of Louth, Lincs, yeoman 1
3749853 1941867 1941867 defendant Tregold James yeoman 586434 586434 Tregold, James, of Louth, Lincs, yeoman 1
3828989 1966950 1966950 defendant Worsley William goldsmith 586434 586434 Worsley, William, of Louth, Lincs, goldsmith 0
3867151 1979253 1979253 defendant Corbytt John yeoman 586434 586434 Corbytt, John, of Louth, Lincs, yeoman 0
3919735 1996940 1996940 defendant Kyng William yeoman 586434 586434 Kyng, William, of Louth, Lincs, yeoman 0
3933669 2001551 2001551 defendant Misty Thomas gent 586434 586434 Misty, Thomas, of Louth, Lincs, gent 0
3936526 2002541 2002541 defendant Worseley William yeoman 586434 586434 Worseley, William, of Louth, Lincs, yeoman 0
3936528 2002541 2002541 defendant Grene Thomas yeoman 586434 586434 Grene, Thomas, of Louth, Lincs, yeoman 2
3947349 2006144 2006144 defendant Evans William yeoman 586434 586434 Evans, William, of Louth, Lincs, yeoman 2
3968071 2013457 2013457 defendant Bradley John merchant of the staple 586434 586434 Bradley, John, of Louth, Lincs, merchant of the staple 1
3983051 2018714 2018714 defendant Byrkhede Robert draper 586434 586434 Byrkhede, Robert, of Louth, Lincs, draper 4
3985944 2019739 2019739 defendant Fyssher William mercer 586434 586434 Fyssher, William, of Louth, Lincs, mercer 0
4048161 2041779 2041779 plaintiff Symcott William gent 586434 586434 Symcott, William, of Louth, Lincs, gent 0
4097706 2059510 2059510 defendant Lowies John chapman 586434 586434 Lowies, John, of Louth, Lincs, chapman 1
4373979 2155765 2155765 defendant Gilby George esq 586434 586434 Gilby, George, of Louth, Lincs, esq 1
4704636 2266829 2266829 defendant Bothby Henry butcher 586434 586434 Bothby, Henry, of Louth, Lincs, butcher 0
4738052 2277002 2277002 defendant Moresby Gilbert master of the scholars 586434 586434 Moresby, Gilbert, of Louth, Lincs, master of the scholars 0
4750822 2280723 2280723 defendant Heuster Roger heuster 586434 586434 Heuster, Roger, of Louth, Lincs, heuster 0
4875985 2319450 2319450 defendant Beek John merchant 586434 586434 Beek, John, of Louth, Lincs, merchant 0
4875988 2319451 2319451 defendant Beek John merchant 586434 586434 Beek, John, of Louth, Lincs, merchant 0
4998030 2356270 2356270 defendant Fuester William merchant 586434 586434 Fuester, William, of Louth, Lincs, merchant 1
5001282 2357255 2357255 defendant Botyat alias Skinner Thomas mercer 586434 586434 Botyat alias Skinner, Thomas, of Louth, Lincs, mercer 0
5132570 2396021 2396021 defendant Sutbury John clerk 586434 586434 Sutbury, John, of Louth, Lincs, clerk 1
5153558 2402194 2402194 defendant Harpham Michael yeoman 586434 586434 Harpham, Michael, of Louth, Lincs, yeoman 1
5156889 2403163 2403163 defendant Kysyng John merchant 586434 586434 Kysyng, John, of Louth, Lincs, merchant 0
5156892 2403164 2403164 defendant Kysyng John merchant 586434 586434 Kysyng, John, of Louth, Lincs, merchant 0
5156905 2403167 2403167 defendant Kysyng John merchant 586434 586434 Kysyng, John, of Louth, Lincs, merchant 4
5170904 2407214 2407214 defendant Harpham Michael yeoman 586434 586434 Harpham, Michael, of Louth, Lincs, yeoman 1
5172934 2407806 2407806 defendant Kysyng John merchant 586434 586434 Kysyng, John, of Louth, Lincs, merchant 0
5172937 2407807 2407807 defendant Kysyng John merchant 586434 586434 Kysyng, John, of Louth, Lincs, merchant 0
5182642 2410678 2410678 defendant Sudbury John clerk 586434 586434 Sudbury, John, of Louth, Lincs, clerk 0
5182647 2410679 2410679 defendant Sudbury John clerk 586434 586434 Sudbury, John, of Louth, Lincs, clerk 0
5188996 2412513 2412513 defendant Harpham Micheal yeoman 586434 586434 Harpham, Micheal, of Louth, Lincs, yeoman 1
5203506 2416778 2416778 defendant Sudbury John clerk 586434 586434 Sudbury, John, of Louth, Lincs, clerk 0
5203511 2416779 2416779 defendant Sudbury John clerk 586434 586434 Sudbury, John, of Louth, Lincs, clerk 0
5327097 2453181 2453181 defendant Tettesfurth Robert yeman 586434 586434 Tettesfurth, Robert, of Louth, Lincs, yeman 0
5327103 2453182 2453182 defendant Tettesfurth Robert yeman 586434 586434 Tettesfurth, Robert, of Louth, Lincs, yeman 0
5338442 2456597 2456597 defendant Graa John saddler 586434 586434 Graa, John, of Louth, Lincs, saddler 0
5369846 2466160 2466160 defendant Neuton John gent 586434 586434 Neuton, John, of Louth, Lincs, gent 0
5369853 2466161 2466161 defendant Neuton John gent 586434 586434 Neuton, John, of Louth, Lincs, gent 0
5479553 2498895 2498895 defendant Tetford Robert yeoman 586434 586434 Tetford, Robert, of Louth, Lincs, yeoman 0
5565403 2524473 2524473 defendant Barbour John barber 586434 586434 Barbour, John, of Louth, Lincs, barber 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);