names

56 rows where place_id = 597086

✎ 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
3627250 1903368 1903368 defendant Peers Elizabeth widow 597086 597086 Peers, Elizabeth, of Mynhed, widow 4
3650522 1910532 1910532 defendant Bray John husbandman 597086 597086 Bray, John, of Mynhed, husbandman 0
3671087 1916924 1916924 defendant Russell William mariner 597086 597086 Russell, William, of Mynhed, mariner 5
3675942 1918511 1918511 defendant Burke Robert merchant 597086 597086 Burke, Robert, of Mynhed, merchant 0
3721941 1933126 1933126 defendant Dobyll Robert gent 597086 597086 Dobyll, Robert, of Mynhed, gent 0
3721942 1933126 1933126 defendant Dobyll Giles gent 597086 597086 Dobyll, Giles, of Mynhed, gent 1
3721944 1933127 1933127 defendant Dobyll Robert husbandman 597086 597086 Dobyll, Robert, of Mynhed, husbandman 0
3726823 1934659 1934659 defendant Sole Walter yeoman 597086 597086 Sole, Walter, of Mynhed, yeoman 0
3737734 1938023 1938023 defendant Dobull John yeoman 597086 597086 Dobull, John, of Mynhed, yeoman 0
3741463 1939198 1939198 defendant Querke Robert merchant 597086 597086 Querke, Robert, of Mynhed, merchant 2
3741464 1939198 1939198 defendant Calde Gibon merchant 597086 597086 Calde, Gibon, of Mynhed, merchant 3
3751619 1942422 1942422 defendant Dobyll Robert gent 597086 597086 Dobyll, Robert, of Mynhed, gent 0
3767986 1947624 1947624 defendant Dobyll Robert gent 597086 597086 Dobyll, Robert, of Mynhed, gent 0
3783107 1952472 1952472 plaintiff Kelley Gebon   597086 597086 Kelley, Gebon, of Mynhed 0
3791700 1955250 1955250 defendant Wrete Richard fisher 597086 597086 Wrete, Richard, of Mynhed, fisher 0
3791701 1955250 1955250 defendant Elys Christine spinster 597086 597086 Elys, Christine, of Mynhed, spinster 1
3804148 1959226 1959226 defendant Person John merchant 597086 597086 Person, John, of Mynhed, merchant 0
3890476 1987071 1987071 defendant Dowdyng John merchant 597086 597086 Dowdyng, John, of Mynhed, merchant 0
3891413 1987394 1987394 defendant Coke John gent 597086 597086 Coke, John, of Mynhed, gent 0
3906295 1992393 1992393 defendant Doble Giles gent 597086 597086 Doble, Giles, of Mynhed, gent 0
3963230 2011743 2011743 defendant Carrant William gent 597086 597086 Carrant, William, of Mynhed, gent 0
3993109 2022284 2022284 defendant Fugars James clothier 597086 597086 Fugars, James, of Mynhed, clothier 0
3993110 2022284 2022284 defendant Donnell William weaver 597086 597086 Donnell, William, of Mynhed, weaver 1
4007565 2027489 2027489 defendant Wythers Lambert tucker 597086 597086 Wythers, Lambert, of Mynhed, tucker 1
4104174 2061769 2061769 defendant Polyn John, senior smith 597086 597086 Polyn, John, senior, of Mynhed, smith 0
4155350 2079962 2079962 defendant Peard Agnes widow 597086 597086 Peard, Agnes, of Mynhed, widow 1
4155533 2080021 2080021 defendant Peard Oliver (legal representative) 597086 597086 Peard, Oliver, of Mynhed, merchant, executrix of 0
4155534 2080021 2080021 defendant Peard Agnes widow 597086 597086 Peard, Agnes, of Mynhed, widow 1
4514510 2204959 2204959 defendant Scot Matheu   597086 597086 Scot, Matheu, of Mynhed 0
4575921 2223958 2223958 defendant Milward Richard   597086 597086 Milward, Richard, of Mynhed 0
4675640 2257991 2257991 defendant Weycombe Isabel widow 597086 597086 Weycombe, Isabel, of Mynhed, widow 0
4771979 2287210 2287210 plaintiff (not given) Reginald vicar of Smyth 597086 597086 Smyth, Reginald, of Mynhed, vicar of the church 0
4944428 2340235 2340235 defendant Nete David mariner 597086 597086 Nete, David, of Mynhed, mariner 0
5016870 2361828 2361828 defendant Cammell Robert clerk 597086 597086 Cammell, Robert, of Mynhed, clerk 2
5114307 2390580 2390580 defendant Mey John tailor 597086 597086 Mey, John, of Mynhed, tailor 0
5152749 2401947 2401947 plaintiff Holbrok Thomas also John (legal representative) 597086 597086 Holbrok, Thomas also John, of Mynhed, executors of 0
5159292 2403833 2403833 defendant Craddok John mercer 597086 597086 Craddok, John, of Mynhed, mercer 0
5235246 2425887 2425887 defendant Lymbery Matthew yeoman 597086 597086 Lymbery, Matthew, of Mynhed, yeoman 0
5260895 2433529 2433529 defendant Bretcote William husbandman 597086 597086 Bretcote, William, of Mynhed, husbandman 0
5298665 2444584 2444584 defendant Brittecote William yeoman 597086 597086 Brittecote, William, of Mynhed, yeoman 1
5324933 2452535 2452535 defendant Bayssher Henry fisher 597086 597086 Bayssher, Henry, of Mynhed, fisher 0
5421853 2481472 2481472 defendant Hol_ Joh merchant 597086 597086 Hol_, Joh, of Mynhed, merchant 2
5428501 2483452 2483452 defendant Holme John, sen yeoman 597086 597086 Holme, John, sen, of Mynhed, yeoman 0
5475947 2497815 2497815 defendant Poulyn Henry butcher 597086 597086 Poulyn, Henry, of Mynhed, butcher 0
5539316 2516782 2516782 defendant Wattys John yeoman 597086 597086 Wattys, John, of Mynhed, yeoman 0
5548145 2519487 2519487 defendant Vular Gerard mariner 597086 597086 Vular, Gerard, of Mynhed, mariner 1
5548146 2519487 2519487 defendant Wryght Thomas mariner 597086 597086 Wryght, Thomas, of Mynhed, mariner 2
5557550 2522162 2522162 defendant Donell Thomas mariner 597086 597086 (Donell, Thomas, of Mynhed, mariner 3
5559369 2522707 2522707 defendant Whyte Simon mariner 597086 597086 Whyte, Simon, of Mynhed, mariner 1
5559371 2522707 2522707 defendant Dumnell Alice widow 597086 597086 Dumnell, Alice, of Mynhed, widow 3
5575961 2527556 2527556 defendant Pyers John merchant 597086 597086 Pyers, John, of Mynhed, merchant 0
5585529 2530542 2530542 defendant Phelippys John merchant 597086 597086 Phelippys, John, of Mynhed, merchant 0
5585530 2530542 2530542 defendant Quyrke Robert merchant 597086 597086 Quyrke, Robert, of Mynhed, merchant 1
5592954 2532792 2532792 defendant Pers Elizabeth widow 597086 597086 Pers, Elizabeth, of Mynhed, widow 4
5605938 2536748 2536748 defendant North Andrew merchant 597086 597086 North, Andrew, of Mynhed, merchant 0
5605941 2536749 2536749 defendant North Andrew merchant 597086 597086 North, Andrew, of Mynhed, 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);