names

57 rows where place_id = 591578

✎ 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
3604882 1869192 1869192 defendant Norys Thomas cordwainer 591578 591578 Norys, Thomas, of Uttoxatur, cordwainer 0
3608758 1870403 1870403 defendant Grene Thomas roper 591578 591578 Grene, Thomas, of Uttoxatur, roper 0
3608760 1870404 1870404 defendant Grene Thomas roper 591578 591578 Grene, Thomas, of Uttoxatur, roper 0
3622682 1874624 1874624 defendant Walker Robert yeoman 591578 591578 Walker, Robert, of Uttoxatur, yeoman 1
3622873 1874682 1874682 defendant Walker Robert yeoman 591578 591578 Walker, Robert, of Uttoxatur, yeoman 1
3624956 1875339 1875339 defendant Grene Thomas yeoman 591578 591578 Grene, Thomas, of Uttoxatur, yeoman 0
3624957 1875339 1875339 defendant Wryght alias Shomaker Thomas yeoman 591578 591578 Wryght alias Shomaker, Thomas, of Uttoxatur, yeoman 1
3624959 1875339 1875339 defendant Holme Thomas sherman 591578 591578 Holme, Thomas, of Uttoxatur, sherman 3
3670361 1916683 1916683 plaintiff Broune William yeoman 591578 591578 Broune, William, of Uttoxatur, yeoman 0
3670362 1916683 1916683 defendant More John husbandman 591578 591578 More, John, of Uttoxatur, husbandman 0
3687183 1922167 1922167 defendant Bagot Joan widow 591578 591578 Bagot, Joan, of Uttoxatur, widow 1
3741959 1939352 1939352 defendant Walker John innholder 591578 591578 Walker, John, of Uttoxatur, innholder 0
3761900 1945728 1945728 defendant Fyncheley John, senior yeoman 591578 591578 Fyncheley, John, senior, of Uttoxatur, yeoman 0
3761901 1945728 1945728 defendant Fyncheley John, junior yeoman 591578 591578 Fyncheley, John, junior, of Uttoxatur, yeoman 1
3793815 1955930 1955930 defendant Taylor Richard yeoman 591578 591578 Taylor, Richard, of Uttoxatur, yeoman 0
3793816 1955930 1955930 defendant Butler John yeoman 591578 591578 Butler, John, of Uttoxatur, yeoman 1
3804297 1959278 1959278 defendant Tailer William yeoman 591578 591578 Tailer, William, of Uttoxatur, yeoman 0
3808053 1960408 1960408 defendant Tayllour Richard tanner 591578 591578 Tayllour, Richard, of Uttoxatur, tanner 0
3820359 1964247 1964247 defendant Teyllour Richard tanner 591578 591578 Teyllour, Richard, of Uttoxatur, tanner 0
3820360 1964247 1964247 defendant Yong Richard husbandman 591578 591578 Yong, Richard, of Uttoxatur, husbandman 1
3820362 1964247 1964247 defendant Teyllour Margaret widow 591578 591578 Teyllour, Margaret, of Uttoxatur, widow 3
3827680 1966519 1966519 defendant Dawson Richard yeoman 591578 591578 Dawson, Richard, of Uttoxatur, yeoman 0
3830419 1967398 1967398 defendant Taylour Richard tanner 591578 591578 Taylour, Richard, of Uttoxatur, tanner 2
3833767 1968495 1968495 defendant Fyncheley John, junior yeoman 591578 591578 Fyncheley, John, junior, of Uttoxatur, yeoman 0
3840337 1970544 1970544 defendant Tayler Richard barker 591578 591578 Tayler, Richard, of Uttoxatur, barker 1
3841625 1970964 1970964 defendant More John   591578 591578 More, John, of Uttoxatur, hat maker 1
3853342 1974668 1974668 defendant Duffeld Nicholas capper 591578 591578 Duffeld, Nicholas, of Uttoxatur, capper 0
3858013 1976155 1976155 defendant Stanley Richard mercer 591578 591578 Stanley, Richard, of Uttoxatur, mercer 0
3858236 1976232 1976232 defendant Clerke Christopher husbandman 591578 591578 Clerke, Christopher, of Uttoxatur, husbandman 0
3858238 1976232 1976232 defendant Hyll Robert laborer 591578 591578 Hyll, Robert, of Uttoxatur, laborer 2
3858241 1976233 1976233 defendant Taillor Richard butcher 591578 591578 Taillor, Richard, of Uttoxatur, butcher 0
3858759 1976414 1976414 defendant Assheton Thomas butcher 591578 591578 Assheton, Thomas, of Uttoxatur, butcher 0
3867896 1979495 1979495 defendant Duffeld Nicholas capper 591578 591578 Duffeld, Nicholas, of Uttoxatur, capper 0
3879844 1983516 1983516 defendant Beche William chaplain 591578 591578 Beche, William, of Uttoxatur, chaplain 3
3899805 1990147 1990147 defendant Taylour Thomas butcher 591578 591578 Taylour, Thomas, of Uttoxatur, butcher 0
3899806 1990147 1990147 defendant Alsop Robert shoemaker 591578 591578 Alsop, Robert, of Uttoxatur, shoemaker 1
3900831 1990507 1990507 defendant Smyth John smith 591578 591578 Smyth, John, of Uttoxatur, smith 3
3909852 1993601 1993601 defendant Rawlyn Henry laborer 591578 591578 Rawlyn, Henry, of Uttoxatur, laborer 0
3909853 1993601 1993601 defendant Kynnersley John tanner 591578 591578 Kynnersley, John, of Uttoxatur, tanner 1
3944048 2005029 2005029 plaintiff Bakewell Richard cordwainer 591578 591578 Bakewell, Richard, of Uttoxatur, cordwainer 0
4026230 2034030 2034030 defendant Startun Richard butcher 591578 591578 Startun, Richard, of Uttoxatur, butcher 0
4058652 2045485 2045485 defendant Heathcote Thomas shoemaker 591578 591578 Heathcote, Thomas, of Uttoxatur, shoemaker 0
4093932 2058154 2058154 defendant Sherwyn Humphrey miller 591578 591578 Sherwyn, Humphrey, of Uttoxatur, miller 1
4150834 2078424 2078424 defendant Startyn Richard butcher 591578 591578 Startyn, Richard, of Uttoxatur, butcher 0
5309711 2447941 2447941 defendant More William yeoman 591578 591578 More, William, of Uttoxatur, yeoman 0
5309712 2447941 2447941 defendant More Robert tailor 591578 591578 More, Robert, of Uttoxatur, tailor 1
5519694 2510995 2510995 defendant Bayly Henry smith 591578 591578 Bayly, Henry, of Uttoxatur, smith 0
5519695 2510995 2510995 defendant Eyton Richard laborer 591578 591578 Eyton, Richard, of Uttoxatur, laborer 1
5519696 2510995 2510995 defendant Egynton Thomas laborer 591578 591578 Egynton, Thomas, of Uttoxatur, laborer 2
5519697 2510995 2510995 defendant Cartewryght Richard laborer 591578 591578 Cartewryght, Richard, of Uttoxatur, laborer 3
5519698 2510995 2510995 defendant Wryght John dyer 591578 591578 Wryght, John, of Uttoxatur, dyer 4
5519699 2510995 2510995 defendant Wymme William laborer 591578 591578 Wymme, William, of Uttoxatur, laborer 5
5579435 2528647 2528647 defendant Sterteyn John yeoman 591578 591578 Sterteyn, John, of Uttoxatur, yeoman 0
5579437 2528647 2528647 defendant Adams Thomas husbandman 591578 591578 Adams, Thomas, of Uttoxatur, husbandman 2
5579439 2528647 2528647 defendant Harres Henry husbandman 591578 591578 Harres, Henry, of Uttoxatur, husbandman 4
5580015 2528830 2528830 plaintiff Brown Richard (legal representative) 591578 591578 Brown, Richard, of Uttoxatur, gent, executors of 0
5590957 2532149 2532149 defendant Mastyrgent John yeoman 591578 591578 Mastyrgent, John, of Uttoxatur, yeoman 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);