names

43 rows where place_id = 587501

✎ 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
3591583 1864992 1864992 defendant Bayly Thomas husbandman 587501 587501 Bayly, Thomas, of Lyme, husbandman 3
3627102 1903338 1903338 defendant Play John merchant 587501 587501 Play, John, of Lyme, merchant 1
3643618 1908433 1908433 defendant Trelyn John husbandman 587501 587501 Trelyn, John, of Lyme, husbandman 4
3643633 1908437 1908437 defendant de Laperes John merchant 587501 587501 de Laperes, John, of Lyme, merchant 0
3661209 1913780 1913780 defendant Roper Nicholas merchant 587501 587501 Roper, Nicholas, of Lyme, merchant 0
3752403 1942673 1942673 defendant Chapleyn Robert   587501 587501 Chapleyn, Robert, of Lyme, merchant, administrators of 1
3782138 1952165 1952165 plaintiff Holcombe William   587501 587501 Holcombe, William, of Lyme 0
3802797 1958772 1958772 defendant Pley John merchant 587501 587501 Pley, John, of Lyme, merchant 0
3814107 1962314 1962314 defendant Burrowe Thomas yeoman 587501 587501 Burrowe, Thomas, of Lyme, yeoman 0
3832581 1968111 1968111 defendant Holcombe William (legal representative) 587501 587501 Holcombe, William, of Lyme, executors of 0
3832584 1968112 1968112 defendant Holcombe William (legal representative) 587501 587501 Holcombe, William, of Lyme, executors of 0
3893489 1988049 1988049 plaintiff Perrott Nicholas   587501 587501 Perrott, Nicholas, of Lyme 0
3907775 1992885 1992885 plaintiff Perrot Nicholas   587501 587501 Perrot Nicholas, of Lyme 0
3971298 2014519 2014519 plaintiff Edger John   587501 587501 Edger, John, of Lyme, customs collector 0
3989584 2021021 2021021 plaintiff Barrett Richard   587501 587501 Barrett, Richard, of Lyme merchant 0
4118674 2066973 2066973 defendant Hoper George merchant 587501 587501 Hoper, George, of Lyme, merchant 0
4206996 2097991 2097991 defendant Hill or Hylles George gent 587501 587501 Hill or Hylles, George, of Lyme, gent 0
4307438 2132739 2132739 defendant Cowlye John   587501 587501 Cowlye, John, of Lyme Regis, sailor 1
4314634 2135232 2135232 defendant Asheton Thomas yeoman 587501 587501 Asheton, Thomas, of Lyme, yeoman 1
4514431 2204931 2204931 defendant Crogge Roger   587501 587501 Crogge, Roger, of Lyme 0
4514436 2204931 2204931 defendant Broun John   587501 587501 Broun, John, of Lyme 5
4518877 2206269 2206269 defendant Croner John   587501 587501 Croner, John, of Lyme 0
4534046 2210916 2210916 defendant Stykelane Thomas   587501 587501 Stykelane, Thomas, of Lyme 3
4560167 2219125 2219125 defendant Crogge Roger   587501 587501 Crogge, Roger, of Lyme 0
4565977 2220912 2220912 defendant Grogge Roger   587501 587501 Grogge, Roger, of Lyme 0
4586593 2227216 2227216 defendant Crover Ralpyh   587501 587501 Crover, Ralpyh, of Lyme 0
4614258 2235471 2235471 defendant Crownere John (legal representative) 587501 587501 Crownere, John, of Lyme, executors of 3
4662976 2249884 2249884 defendant Travell John husbandman 587501 587501 Travell, John, of Lyme, husbandman 0
4662977 2249884 2249884 defendant Grovere Ralph husbandman 587501 587501 Grovere, Ralph, of Lyme, husbandman 1
4662978 2249884 2249884 defendant Ferrour or Smith Thomas husbandman 587501 587501 Ferrour or Smith, Thomas, of Lyme, husbandman 2
4662979 2249884 2249884 defendant Rycheman Thomas husbandman 587501 587501 Rycheman, Thomas, of Lyme, husbandman 3
4764563 2284903 2284903 defendant Baker John yeoman 587501 587501 Baker, John, of Lyme, yeoman 2
4848086 2310869 2310869 defendant Taylour John tailor 587501 587501 Taylour, John, of Lyme, tailor 1
4848087 2310869 2310869 defendant Dorset John clerk 587501 587501 Dorset, John, of Lyme, clerk 2
5126417 2394202 2394202 plaintiff Borowgh Robert merchant 587501 587501 Borowgh, Robert, of Lyme, merchant 0
5253346 2431148 2431148 defendant Kene John merchant 587501 587501 Kene, John, of Lyme, merchant 1
5274280 2437558 2437558 defendant Fryssheney Robert gent 587501 587501 Fryssheney, Robert, of Lyme, gent 1
5306023 2446787 2446787 defendant Bare John merchant 587501 587501 Bare, John, of Lyme, merchant 0
5454740 2491341 2491341 plaintiff Baker John   587501 587501 Baker, John, of Lyme 0
5466581 2494944 2494944 plaintiff Baker John   587501 587501 Baker, John, of Lyme 0
5542122 2517668 2517668 defendant Dale John merchant 587501 587501 Dale, John, of Lyme, merchant 0
5570549 2525957 2525957 defendant Straynsham John clerk 587501 587501 Straynsham, John, of Lyme, clerk 0
5584634 2530264 2530264 defendant Dare William merchant 587501 587501 Dare, William, of Lyme, merchant 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);