names

47 rows where place_id = 593080

✎ 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
3610355 1870896 1870896 defendant Elyot Bernard tanner 593080 593080 Elyot, Bernard, of Barstaple, tanner 0
3611160 1871166 1871166 defendant Halpeney William yeoman 593080 593080 Halpeney, William, of Barstaple, yeoman 3
3611642 1871310 1871310 defendant Halpeney William yeoman 593080 593080 Halpeney, William, of Barstaple, yeoman 3
3611648 1871311 1871311 defendant Halpeney William yeoman 593080 593080 Halpeney, William, of Barstaple, yeoman 3
3616603 1872824 1872824 defendant Upcote John tucker 593080 593080 Upcote, John, of Barstaple, tucker 1
3682419 1920603 1920603 defendant Draper Robert tanner 593080 593080 Draper, Robert, of Barstaple, tanner 0
3695407 1924786 1924786 defendant Horlok John tailor 593080 593080 Horlok, John, of Barstaple, tailor 0
3702946 1927191 1927191 defendant Androwe Simon merchant 593080 593080 Androwe, Simon, of Barstaple, merchant 0
3711599 1929937 1929937 plaintiff Tirre Thomas   593080 593080 Tirre, Thomas, of Barstaple 0
3711601 1929938 1929938 plaintiff Tirre Thomas   593080 593080 Tirre, Thomas, of Barstaple 0
3884400 1985052 1985052 defendant Holwaye John merchant 593080 593080 (Holwaye, John, of Barstaple, merchant 1
3942700 2004564 2004564 defendant Salysbury John merchant 593080 593080 Salysbury, John, of Barstaple, merchant 0
3942704 2004565 2004565 defendant Wyott Richard, junior laborer 593080 593080 Wyott, Richard, junior, of Barstaple, laborer 1
3962403 2011440 2011440 plaintiff Welshe John merchant 593080 593080 Welshe, John, of Barstaple, merchant 0
3985728 2019656 2019656 plaintiff Walshe John merchant 593080 593080 Walshe, John, of Barstaple, merchant 0
3989953 2021163 2021163 plaintiff Beaple James merchant 593080 593080 Beaple, James, of Barstaple, merchant 0
4046080 2041037 2041037 defendant Peard Henry yeoman 593080 593080 Peard, Henry, of Barstaple, yeoman 0
4050829 2042734 2042734 plaintiff Welshe John merchant 593080 593080 Welshe, John, of Barstaple, merchant 0
4231374 2106475 2106475 defendant Sparrowe James Devon, chapman 593080 593080 Sparrowe James, of Barstaple, Devon, chapman 0
4478711 2194006 2194006 defendant Taillour Geoffrey   593080 593080 Taillour, Geoffrey, of Barstaple 0
4502909 2201485 2201485 defendant Grey William   593080 593080 Grey, William, of Barstaple 1
4532797 2210529 2210529 defendant Simon Ralph   593080 593080 Simon, Ralph, of Barstaple 2
4577223 2224393 2224393 defendant Waltere John   593080 593080 Waltere, John, of Barstaple 0
4585307 2226826 2226826 defendant Wyse William   593080 593080 Wyse, William, of Barstaple 0
4597450 2230445 2230445 defendant Waryn Henry   593080 593080 Waryn, Henry, of Barstaple 0
4600527 2231386 2231386 defendant Shethe John   593080 593080 Shethe, John, of Barstaple 3
4614535 2235553 2235553 defendant Louche William braseyeter 593080 593080 Louche, William, of Barstaple, braseyeter 1
4664369 2250337 2250337 defendant Parkeman John yeoman 593080 593080 Parkeman, John, of Barstaple, yeoman 0
4710587 2268668 2268668 defendant Crokker William husbandman 593080 593080 Crokker, William, of Barstaple, husbandman 1
4728623 2274190 2274190 defendant Pytman John husbandman 593080 593080 Pytman, John, of Barstaple, husbandman 0
4784805 2291255 2291255 defendant Mair John husbandman 593080 593080 Mair, John, of Barstaple, husbandman 0
4792751 2293820 2293820 plaintiff Morley John brasier 593080 593080 Morley, John, of Barstaple, brasier 0
4872229 2318275 2318275 defendant Holme William dyer 593080 593080 Holme, William, of Barstaple, dyer 2
4902974 2327547 2327547 defendant Beare John baker 593080 593080 Beare, John, of Barstaple, baker 1
5031924 2366209 2366209 defendant Mathow John (legal representative) 593080 593080 Mathow, John, of Barstaple, merchant, executors of 0
5043897 2369804 2369804 defendant Gunston Robert yeoman 593080 593080 Gunston, Robert, of Barstaple, yeoman 0
5100672 2386621 2386621 defendant Holme William dyer 593080 593080 Holme, William, of Barstaple, dyer 1
5114008 2390486 2390486 defendant Pokelegh John yeoman 593080 593080 Pokelegh, John, of Barstaple, yeoman 2
5253564 2431223 2431223 defendant Pedeler John husbandman 593080 593080 Pedeler, John, of Barstaple, husbandman 3
5482532 2499717 2499717 defendant Wylke John weaver 593080 593080 Wylke, John, of Barstaple, weaver 0
5490036 2501904 2501904 defendant Trote Thomas merchant 593080 593080 Trote, Thomas, of Barstaple, merchant 0
5490040 2501904 2501904 defendant Yemmere John merchant 593080 593080 Yemmere, John, of Barstaple, merchant 4
5515310 2509634 2509634 defendant ap Howell Mathew tailor 593080 593080 ap Howell, Mathew, of Barstaple, tailor 2
5537644 2516264 2516264 defendant Symon Robert merchant 593080 593080 Symon, Robert, of Barstaple, merchant 0
5567714 2525130 2525130 defendant Marten Walter fuller 593080 593080 Marten, Walter, of Barstaple, fuller 0
5589000 2531570 2531570 defendant Thorne Roger merchant 593080 593080 Thorne, Roger, of Barstaple, merchant 1
5606300 2536865 2536865 defendant Eye or Eye William mercer 593080 593080 Eye or Eye, William, of Barstaple, mercer 1

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