names

55 rows where place_id = 589123

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3596611 1866574 1866574 defendant Wodesworthy William baker 589123 589123 Wodesworthy, William, of Sampford Peverell, baker 1
3628401 1903748 1903748 defendant Roper John merchant 589123 589123 Roper, John, of Sampford Peverell, merchant 0
3628402 1903748 1903748 defendant Jogger Thomas husbandman 589123 589123 Jogger, Thomas, of Sampford Peverell, husbandman 1
3656502 1912283 1912283 defendant Chave Robert smith 589123 589123 Chave, Robert, of Sampford Peverell, smith 0
3665749 1915235 1915235 defendant Hyllyng John fuller 589123 589123 Hyllyng, John, of Sampford Peverell, fuller 0
3677814 1919113 1919113 defendant Manley Richard husbandman 589123 589123 Manley, Richard, of Sampford Peverell, husbandman 0
3677815 1919113 1919113 defendant Manley William husbandman 589123 589123 Manley, William, of Sampford Peverell, husbandman 1
3686861 1922052 1922052 defendant Vyncente William yeoman 589123 589123 Vyncente, William, of Sampford Peverell, yeoman 1
3692679 1923899 1923899 defendant Roper John yeoman 589123 589123 Roper, John, of Sampford Peverell, yeoman 1
3699247 1925977 1925977 defendant Manlegh Richard husbandman 589123 589123 Manlegh, Richard, of Sampford Peverell, husbandman 0
3801355 1958351 1958351 defendant Dey Henry husbandman 589123 589123 Dey, Henry, of Sampford Peverell, husbandman 0
3801356 1958351 1958351 defendant Dart Hugh husbandman 589123 589123 Dart, Hugh, of Sampford Peverell, husbandman 1
3801357 1958351 1958351 defendant Venman John husbandman 589123 589123 Venman, John, of Sampford Peverell, husbandman 2
3801358 1958351 1958351 defendant Cake Alexander husbandman 589123 589123 Cake, Alexander, of Sampford Peverell, husbandman 3
3801359 1958351 1958351 defendant Bowdon Robert husbandman 589123 589123 Bowdon, Robert, of Sampford Peverell, husbandman 4
3801360 1958351 1958351 defendant Mayne Richard husbandman 589123 589123 Mayne, Richard, of Sampford Peverell, husbandman 5
3834277 1968666 1968666 defendant Dey Henry carpenter 589123 589123 Dey, Henry, of Sampford Peverell, carpenter 0
3834278 1968666 1968666 defendant Dert Hugh butcher 589123 589123 Dert, Hugh, of Sampford Peverell, butcher 1
3834279 1968666 1968666 defendant Vennan John baker 589123 589123 Vennan, John, of Sampford Peverell, baker 2
3866058 1978881 1978881 defendant Grenam Thomas miller 589123 589123 Grenam, Thomas, of Sampford Peverell, miller 0
3866059 1978881 1978881 defendant Chave Richard, senior husbandman 589123 589123 Chave, Richard, senior, of Sampford Peverell, husbandman 1
3866060 1978881 1978881 defendant Chave Richard, junior smith 589123 589123 Chave, Richard, junior, of Sampford Peverell, smith 2
3866061 1978881 1978881 defendant Nicoll Christopher husbandman 589123 589123 Nicoll, Christopher, of Sampford Peverell, husbandman 3
3867349 1979312 1979312 defendant Combe Richard cordwainer 589123 589123 Combe, Richard, of Sampford Peverell, cordwainer 2
3884838 1985202 1985202 defendant Hyll William (legal representative) 589123 589123 Hyll, William, of Sampford Peverell, dyer, executor of 0
3897872 1989494 1989494 defendant Hokeway John husbandman 589123 589123 Hokeway, John, of Sampford Peverell, husbandman 0
3906058 1992316 1992316 defendant Hokewey John yeoman 589123 589123 Hokewey, John, of Sampford Peverell, yeoman 0
3906059 1992316 1992316 defendant Crankelond Richard husbandman 589123 589123 Crankelond, Richard, of Sampford Peverell, husbandman 1
3914273 1995118 1995118 defendant Blakmore Henry gent 589123 589123 Blakmore, Henry, of Sampford Peverell, husbandman, Sanford alias Sampford, Christopher, of Halberton, gent 0
3914707 1995264 1995264 defendant Chave William smith 589123 589123 Chave, William, of Sampford Peverell, smith 0
3914708 1995264 1995264 defendant Prewe John husbandman 589123 589123 Prewe, John, of Sampford Peverell, husbandman 1
3921276 1997468 1997468 defendant West Robert clerk 589123 589123 West, Robert, of Sampford Peverell, clerk 5
3926777 1999289 1999289 defendant Blakmore Henry husbandman 589123 589123 Blakmore, Henry, of Sampford Peverell, husbandman 0
3971667 2014654 2014654 defendant Blackealler Vincent shoemaker 589123 589123 Blackealler, Vincent, of Sampford Peverell, shoemaker 0
4590042 2228243 2228243 defendant Houndalre John   589123 589123 Houndalre, John, of Sampford Peverell 6
4605031 2232732 2232732 defendant Smyth Robert   589123 589123 Smyth, Robert, of Sampford Peverell 0
4934441 2337164 2337164 defendant Douneys Thomas tailor 589123 589123 Douneys, Thomas, of Sampford Peverell, tailor 2
5016054 2361578 2361578 defendant Donneyes Thomas   589123 589123 Donneyes, Thomas, of Sampford Peverell, bailiff 0
5038262 2368079 2368079 defendant Roper William yeoman 589123 589123 Roper, William, of Sampford Peverell, yeoman 4
5098585 2386019 2386019 defendant Hillynge John husbandman 589123 589123 Hillynge, John, of Sampford Peverell, husbandman 0
5113613 2390372 2390372 defendant Hillyng John yeoman 589123 589123 Hillyng, John, of Sampford Peverell, yeoman 2
5226371 2423383 2423383 defendant Hyllyng John husbandman 589123 589123 Hyllyng, John, of Sampford Peverell, husbandman 3
5244885 2428677 2428677 defendant Stafford John   589123 589123 Stafford, John, of Sampford Peverell, bailiff 0
5266502 2435272 2435272 defendant Draydon John yeoman 589123 589123 Draydon, John, of Sampford Peverell, yeoman 0
5272986 2437171 2437171 defendant Goldwyre Simon harper 589123 589123 Goldwyre, Simon, of Sampford Peverell, harper 2
5332162 2454695 2454695 defendant Stafford John yeoman 589123 589123 Stafford, John, of Sampford Peverell, yeoman 1
5332166 2454696 2454696 defendant Stafford John yeoman 589123 589123 Stafford, John, of Sampford Peverell, yeoman 1
5334150 2455280 2455280 defendant Roper John husbandman 589123 589123 Roper, John, of Sampford Peverell, husbandman 0
5352052 2460748 2460748 defendant Roper John husbandman 589123 589123 Roper, John, of Sampford Peverell, husbandman 0
5436142 2485747 2485747 defendant Harrys Thomas husbandman 589123 589123 Harrys, Thomas, of Sampford Peverell, husbandman 2
5436143 2485747 2485747 defendant Roper John   589123 589123 Roper, John, of Sampford Peverell, mason 3
5436147 2485748 2485748 defendant Harrys Thomas husbandman 589123 589123 Harrys, Thomas, of Sampford Peverell, husbandman 2
5436148 2485748 2485748 defendant Roper John   589123 589123 Roper, John, of Sampford Peverell, mason 3
5496410 2503833 2503833 defendant Burlegh Richard yeoman 589123 589123 Burlegh, Richard, of Sampford Peverell, yeoman 3
5542339 2517726 2517726 defendant Prewe Henry husbandman 589123 589123 Prewe, Henry, of Sampford Peverell, husbandman 4

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