names

56 rows where place_id = 607394

✎ 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
3669063 1916256 1916256 defendant Lete John smith 607394 607394 Lete, John, of Barnewell, smith 0
3673882 1917864 1917864 defendant Lete John smith 607394 607394 Lete, John, of Barnewell, smith 2
3680373 1919942 1919942 defendant Lete John smith 607394 607394 Lete, John, of Barnewell, smith 0
3774831 1949856 1949856 defendant Lane John clerk 607394 607394 Lane, John, of Barnewell, clerk 0
3781162 1951845 1951845 defendant Bardall John husbandman 607394 607394 Bardall, John, of Barnewell, husbandman 0
3797165 1956997 1956997 defendant Jakson John husbandman 607394 607394 Jakson, John, of Barnewell, husbandman 0
3805687 1959722 1959722 defendant Richardson William husbandman 607394 607394 Richardson, William, of Barnewell, husbandman 0
3805688 1959722 1959722 defendant Richardson Thomas husbandman 607394 607394 Richardson, Thomas, of Barnewell, husbandman 1
3821919 1964747 1964747 defendant Rychardson William husbandman 607394 607394 Rychardson, William, of Barnewell, husbandman 0
3840174 1970498 1970498 defendant Brande Edward husbandman 607394 607394 Brande, Edward, of Barnewell, husbandman 0
3840175 1970498 1970498 defendant Bowyer Michael   607394 607394 Bowyer, Michael, of Barnewell, wheelwright 1
3840178 1970498 1970498 defendant Hall William husbandman 607394 607394 Hall, William, of Barnewell, husbandman 4
3840181 1970499 1970499 defendant Brande Edward husbandman 607394 607394 Brande, Edward, of Barnewell, husbandman 0
3840182 1970499 1970499 defendant Bowyer Michael   607394 607394 Bowyer, Michael, of Barnewell, wheelwright 1
3840183 1970499 1970499 defendant Pyngleton John fisher 607394 607394 Pyngleton, John, of Barnewell, fisher 2
3840186 1970499 1970499 defendant Hall William husbandman 607394 607394 Hall, William, of Barnewell, husbandman 5
3840187 1970499 1970499 defendant Jackeson John husbandman 607394 607394 Jackeson, John, of Barnewell, husbandman 6
3840192 1970500 1970500 defendant Brande Edward husbandman 607394 607394 Brande, Edward, of Barnewell, husbandman 0
3840193 1970500 1970500 defendant Bowyer Michael   607394 607394 Bowyer, Michael, of Barnewell,wheelwright 1
3840196 1970500 1970500 defendant Hall William husbandman 607394 607394 Hall, William, of Barnewell, husbandman 4
3861126 1977200 1977200 defendant Luatte Thomas husbandman 607394 607394 Luatte, Thomas, of Barnewell, husbandman 0
3883121 1984616 1984616 defendant Lambe John husbandman 607394 607394 Lambe, John, of Barnewell, husbandman 0
3883122 1984616 1984616 defendant Lambe Andrew husbandman 607394 607394 Lambe, Andrew, of Barnewell, husbandman 1
3883124 1984617 1984617 defendant Lambe alias Lame John husbandman 607394 607394 Lambe alias Lame, John, of Barnewell, husbandman 0
3883125 1984617 1984617 defendant Lame Andrew   607394 607394 Lame, Andrew, of Barnewell, husbandman, his son 1
3889803 1986830 1986830 defendant Messenger John husbandman 607394 607394 Messenger, John, of Barnewell, husbandman 0
3892256 1987663 1987663 defendant Lacy John yeoman 607394 607394 Lacy, John, of Barnewell, yeoman 0
3943406 2004809 2004809 defendant Eston John husbandman 607394 607394 Eston, John, of Barnewell, husbandman 0
4063475 2047227 2047227 defendant Ruste Nicholas gent 607394 607394 Ruste, Nicholas, of Barnewell, gent 2
4069887 2049513 2049513 defendant Ruste Nicholas yeoman 607394 607394 Ruste, Nicholas, of Barnewell, yeoman 1
4083495 2054370 2054370 defendant Spyttey Richard husbandman 607394 607394 Spyttey, Richard, of Barnewell, or of Highe Roding, Essex, husbandman 0
4117623 2066599 2066599 defendant Longworth Thomas yeoman 607394 607394 Longworth, Thomas, of Barnewell, yeoman 0
4122248 2068261 2068261 defendant Langhorne Robert tailor 607394 607394 Langhorne, Robert, of Barnewell, tailor 2
4170728 2085254 2085254 defendant Musgrave John yeoman 607394 607394 Musgrave, John, of Barnewell, yeoman 2
4198785 2095136 2095136 defendant Rust Nicholas yeoman 607394 607394 Rust, Nicholas, of Barnewell, yeoman 1
4216603 2101299 2101299 defendant Clement William yeoman 607394 607394 Clement, William, of Barnewell, yeoman 1
4224814 2104146 2104146 defendant Clement William yeoman 607394 607394 Clement, William, of Barnewell, yeoman 0
4236639 2108388 2108388 defendant Clement William yeoman 607394 607394 Clement, William, of Barnewell, yeoman 2
4257149 2115368 2115368 defendant Clement William yeoman 607394 607394 Clement, William, of Barnewell, yeoman 2
4313453 2134813 2134813 defendant Clement William yeoman 607394 607394 Clement, William, of Barnewell, yeoman 0
4334957 2141955 2141955 defendant Musgrave John husbandman 607394 607394 Musgrave, John, of Barnewell, husbandman 0
4720869 2271861 2271861 defendant Carter John carter 607394 607394 Carter, John, of Barnewell, carter 0
4937123 2337983 2337983 defendant Fyldyng Reginald husbandman 607394 607394 Fyldyng, Reginald, of Barnewell, husbandman 0
5126264 2394165 2394165 defendant Wittilsey Richard husbandman 607394 607394 Wittilsey, Richard, of Barnewell, husbandman 1
5334549 2455404 2455404 defendant Lilford Thomas husbandman 607394 607394 Lilford, Thomas, of Barnewell, husbandman 1
5349133 2459858 2459858 defendant Haldenby Thomas esq 607394 607394 Haldenby, Thomas, of Barnewell, esq 0
5386429 2471190 2471190 defendant (not given) John prior of Tybote 607394 607394 Tybote, John, of Barnewell, prior of the monastery of St Giles 0
5386435 2471193 2471193 defendant (not given) John prior of Tybote 607394 607394 Tybote, John, of Barnewell, prior of the monastery of St Giles 0
5398736 2474703 2474703 defendant (not given) John prior of Tybote 607394 607394 Tybote, John, of Barnewell, prior of the Monastery of St Giles 0
5426333 2482829 2482829 defendant (not given) John prior of Tybote 607394 607394 Tybote, John, of Barnewell, prior of the monastery of St Giles 0
5443684 2488032 2488032 defendant Odam William yeoman 607394 607394 Odam, William, of Barnewell, yeoman 1
5446723 2488917 2488917 defendant Vaus Thomas   607394 607394 Vaus, Thomas, of Barnewell 0
5483306 2499954 2499954 defendant Haldenby Thomas gent 607394 607394 Haldenby, Thomas, of Barnewell, gent 1
5512091 2508643 2508643 defendant Bullok Robert harper 607394 607394 Bullok, Robert, of Barnewell, harper 0
5512092 2508643 2508643 defendant Daweson Richard laborer 607394 607394 Daweson, Richard, of Barnewell, laborer 1
5621515 2550627 2550627 defendant Smyth John   607394 607394 Smyth, John, of Barnewell 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);