names

64 rows where place_id = 626360

✎ 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
3769647 1948164 1948164 defendant Erle Humphrey tucker 626360 626360 Erle, Humphrey, of Bradnynche, tucker 0
3783697 1952665 1952665 defendant Kent William tailor 626360 626360 Kent, William, of Bradnynche, tailor 0
3829128 1966992 1966992 defendant Twygge John yeoman 626360 626360 Twygge, John, of Bradnynche, yeoman 0
3829896 1967241 1967241 defendant Chattey Robert, junior husbandman 626360 626360 Chattey, Robert, junior, of Bradnynche, husbandman 1
3832466 1968075 1968075 defendant Dorwyke Humphrey tucker 626360 626360 Dorwyke, Humphrey, of Bradnynche, tucker 0
3832469 1968076 1968076 defendant Dorwyke Humphrey tucker 626360 626360 Dorwyke, Humphrey, of Bradnynche, tucker 0
3838140 1969845 1969845 defendant Torre John husbandman 626360 626360 Torre, John, of Bradnynche, husbandman 0
3838340 1969910 1969910 defendant Hyllersdon John gent 626360 626360 Hyllersdon, John, of Bradnynche, gent 0
3844820 1971923 1971923 defendant Erle Humphrey tucker 626360 626360 Erle, Humphrey, of Bradnynche, tucker 0
3844821 1971923 1971923 defendant Evelegh Nicholas husbandman 626360 626360 Evelegh, Nicholas, of Bradnynche, husbandman 1
3868645 1979753 1979753 defendant Torre Thomas yeoman 626360 626360 Torre, Thomas, of Bradnynche, yeoman 0
3868647 1979754 1979754 defendant Kent William tailor 626360 626360 Kent, William, of Bradnynche, tailor 0
3868648 1979754 1979754 defendant Torre Thomas husbandman 626360 626360 Torre, Thomas, of Bradnynche, husbandman 1
3873085 1981216 1981216 defendant Hyllersdon John gent 626360 626360 Hyllersdon, John, of Bradnynche, gent 0
3882688 1984476 1984476 defendant Hyllarsdon John gent 626360 626360 Hyllarsdon, John, of Bradnynche, gent 0
3883863 1984873 1984873 defendant Twigge John husbandman 626360 626360 Twigge, John, of Bradnynche, husbandman 1
3888899 1986534 1986534 defendant Erle Humphrey tucker 626360 626360 Erle, Humphrey, of Bradnynche, tucker 0
3888900 1986534 1986534 defendant Erle William tucker 626360 626360 Erle, William, of Bradnynche, tucker 1
3889455 1986703 1986703 defendant Machent John yeoman 626360 626360 Machent, John, of Bradnynche, yeoman 1
3896492 1989033 1989033 defendant Parkyn alias Peter William husbandman 626360 626360 Parkyn alias Peter, William, of Bradnynche, husbandman 0
3896493 1989033 1989033 defendant Chatte Thomas, junior husbandman 626360 626360 Chatte, Thomas, junior, of Bradnynche, husbandman 1
3896495 1989034 1989034 defendant Torre Thomas husbandman 626360 626360 Torre, Thomas, of Bradnynche, husbandman 0
3896496 1989034 1989034 defendant Kent William tailor 626360 626360 Kent, William, of Bradnynche, tailor 1
3896497 1989034 1989034 defendant More John smith 626360 626360 More, John, of Bradnynche, smith 2
3921271 1997468 1997468 defendant Chathay Robert weaver 626360 626360 Chathay, Robert, of Bradnynche, weaver 0
3947929 2006340 2006340 defendant Twygg William husbandman 626360 626360 Twygg, William, of Bradnynche, husbandman 0
3947930 2006340 2006340 defendant Seward William husbandman 626360 626360 Seward, William, of Bradnynche, husbandman 1
3950270 2007180 2007180 defendant Twygge Oliver husbandman 626360 626360 Twygge, Oliver, of Bradnynche, husbandman 0
3959169 2010293 2010293 defendant Twygge Thomas butcher 626360 626360 Twygge, Thomas, of Bradnynche, butcher 0
3968028 2013447 2013447 defendant Wek Joan spinster 626360 626360 Wek, Joan, of Bradnynche, spinster 0
3969406 2013903 2013903 defendant Twygg William husbandman 626360 626360 Twygg, William, of Bradnynche, husbandman 0
3969407 2013903 2013903 defendant Seward William husbandman 626360 626360 Seward, William, of Bradnynche, husbandman 1
3969429 2013914 2013914 defendant Twygge Oliver weaver 626360 626360 Twygge, Oliver, of Bradnynche, weaver 0
3969526 2013951 2013951 defendant Payne William husbandman 626360 626360 Payne, William, of Bradnynche, husbandman 1
3972013 2014770 2014770 defendant Seiwarde William husbandman 626360 626360 Seiwarde, William, of Bradnynche, husbandman 0
3973533 2015312 2015312 plaintiff Gybbe John tanner 626360 626360 Gybbe, John, of Bradnynche, tanner 0
3973535 2015312 2015312 defendant Dunsford Elizabeth widow 626360 626360 Dunsford, Elizabeth, of Bradnynche, widow 1
3976885 2016488 2016488 plaintiff Lake William   626360 626360 Lake, William, of Bradnynche 0
3985873 2019712 2019712 defendant Twygge Oliver weaver 626360 626360 Twygge, Oliver, of Bradnynche, weaver 0
3988705 2020703 2020703 defendant Twigge Oliver yeoman 626360 626360 Twigge, Oliver, of Bradnynche, yeoman 0
3988707 2020704 2020704 defendant Twygge John yeoman 626360 626360 Twygge, John, of Bradnynche, yeoman 0
3992990 2022242 2022242 defendant Twygge Oliver yeoman 626360 626360 Twygge, Oliver, of Bradnynche, yeoman 6
3992991 2022242 2022242 defendant Twygge John yeoman 626360 626360 Twygge, John, of Bradnynche, yeoman 7
3995741 2023222 2023222 defendant Mortymer John yeoman 626360 626360 Mortymer, John, of Bradnynche, yeoman 0
3998888 2024361 2024361 defendant Twygge Oliver weaver 626360 626360 Twygge, Oliver, of Bradnynche, weaver 0
3998889 2024361 2024361 defendant Twygge John yeoman 626360 626360 Twygge, John, of Bradnynche, yeoman 1
4011592 2028896 2028896 defendant Twiggy or Twigg Oliver yeoman 626360 626360 Twiggy or Twigg, Oliver, of Bradnynche, yeoman 3
4019429 2031681 2031681 defendant Sewarde William husbandman 626360 626360 Sewarde, William, of Bradnynche, husbandman 0
4026599 2034162 2034162 defendant Twigge Oliver husbandman 626360 626360 Twigge, Oliver, of Bradnynche, husbandman 2
4039438 2038731 2038731 defendant Combe Thomas baker 626360 626360 Combe, Thomas, of Bradnynche, baker 0
4048349 2041857 2041857 plaintiff Tayler William husbandman 626360 626360 Tayler, William, of Bradnynche, husbandman 0
4048780 2042011 2042011 defendant Twigge John weaver 626360 626360 Twigge, John, of Bradnynche, weaver 2
4048784 2042012 2042012 defendant Twigge John weaver 626360 626360 Twigge, John, of Bradnynche, weaver 2
4137444 2073740 2073740 defendant Crosse Thomas weaver 626360 626360 Crosse, Thomas, of Bradnynche, weaver 1
4147365 2077217 2077217 defendant Courtney Edward gent 626360 626360 Courtney, Edward, of Bradnynche, gent 0
4184068 2089925 2089925 defendant Prescott John husbandman 626360 626360 Prescott, John, of Bradnynche, husbandman 0
4257485 2115476 2115476 defendant Erle Wilmot widow 626360 626360 Erle, Wilmot, of Bradnynche, widow 0
4725495 2273265 2273265 defendant Baker Richard butcher 626360 626360 Baker, Richard, of Bradnynche, butcher 0
5106368 2388301 2388301 defendant Tuygge William tucker 626360 626360 Tuygge, William, of Bradnynche, tucker 0
5182806 2410722 2410722 defendant Yerl John hosier 626360 626360 Yerl, John, of Bradnynche, hosier 3
5203598 2416805 2416805 defendant Yerle John hosier 626360 626360 Yerle, John, of Bradnynche, hosier 3
5378775 2468949 2468949 defendant Levyngton John, junior husbandman 626360 626360 Levyngton, John, junior, of Bradnynche, husbandman 0
5540147 2517043 2517043 defendant Twygge Richard husbandman 626360 626360 Twygge, Richard, of Bradnynche, husbandman 0
5543348 2518039 2518039 defendant Northbroke Henry mercer 626360 626360 Northbroke, Henry, of Bradnynche, mercer 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);