names

29 rows where place_id = 665131

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3975640 2016038 2016038 defendant Babyngton Walter gent 665131 665131 Babyngton, Walter, of Ottery St Mary, Devon, gent 0
4013882 2029694 2029694 defendant Courteney John esq 665131 665131 Courteney, John, of Ottery St Mary, Devon, esq 1
4030157 2035431 2035431 defendant Axe Thomas draper 665131 665131 Axe, Thomas, of Ottery St Mary, Devon, draper 0
4042133 2039673 2039673 defendant Courtney John gent 665131 665131 Courtney, John, of Ottery St Mary, Devon, gent 0
4059902 2045939 2045939 defendant Courtney Roger gent 665131 665131 Courtney, Roger, of Ottery St Mary, Devon, gent 0
4104796 2061992 2061992 defendant Babington Thomas gent 665131 665131 Babington, Thomas, of Ottery St Mary, Devon, gent 0
4110406 2063984 2063984 defendant Mydwynter Robert merchant 665131 665131 Mydwynter, Robert, of Ottery St Mary, Devon, merchant 0
4176948 2087411 2087411 defendant Babington Thomas gent 665131 665131 Babington, Thomas, of Ottery St Mary, Devon, gent 1
4235136 2107847 2107847 defendant Sherman Richard gent 665131 665131 Sherman, Richard, of Ottery St Mary, Devon, gent 0
4325956 2139055 2139055 defendant Evelighe George gent 665131 665131 Evelighe, George, of Ottery St Mary, Devon, gent 1
4359143 2150433 2150433 defendant Babington Humphrey gent 665131 665131 Babington, Humphrey, of Ottery St Mary, Devon, gent 0
4374737 2156020 2156020 defendant Courtney Roger gent 665131 665131 Courtney, Roger, of Ottery St Mary, Devon, gent 0
4397440 2163724 2163724 defendant Corham William gent 665131 665131 Corham, William, of Ottery St Mary, Devon, gent 0
4688825 2262061 2262061 defendant Malerbe William gent 665131 665131 Malerbe, William, of Ottery St Mary, Devon, gent 1
4699083 2265182 2265182 defendant Blackmore Henry clerk 665131 665131 Blackmore, Henry, of Ottery St Mary, Devon, clerk 0
4716730 2270553 2270553 defendant Bytellesgate Thomas   665131 665131 Bytellesgate, Thomas, of Ottery St Mary, Devon 0
4719388 2271408 2271408 defendant Bytellysgate Thomas gent 665131 665131 Bytellysgate, Thomas, of Ottery St Mary, Devon, gent 0
4747429 2279749 2279749 defendant Bittelesgate Thomas esq 665131 665131 Bittelesgate, Thomas, of Ottery St Mary, Devon, esq 3
4763835 2284682 2284682 defendant Bydesgate Thomas esq 665131 665131 Bydesgate, Thomas, of Ottery St Mary, Devon, esq 0
4822325 2303063 2303063 defendant Heyes John husbandman 665131 665131 Heyes, John, of Ottery St Mary, Devon, husbandman 1
4999716 2356794 2356794 defendant Tayllour William chapman 665131 665131 Tayllour, William, of Ottery St Mary, Devon, chapman 0
5000566 2357036 2357036 defendant Bancombe John clerk 665131 665131 Bancombe, John, of Ottery St Mary, Devon, clerk 0
5005364 2358471 2358471 defendant Baker Henry dyer 665131 665131 (Baker, Henry, of Ottery St Mary, Devon, dyer 1
5196116 2414609 2414609 defendant Hughe Roger clerk 665131 665131 Hughe, Roger, of Ottery St Mary, Devon, clerk 0
5400638 2475244 2475244 defendant Trent Morris yeoman 665131 665131 Trent, Morris, of Ottery St Mary, Devon, yeoman 0
5424418 2482269 2482269 defendant Ware William chapman 665131 665131 Ware, William, of Ottery St Mary, Devon, chapman 4
5425069 2482461 2482461 defendant Frensche Walter dyer 665131 665131 Frensche, Walter, of Ottery St Mary, Devon, dyer 0
5428903 2483560 2483560 defendant Trent Morris yeoman 665131 665131 Trent, Morris, of Ottery St Mary, Devon, yeoman 0
5443252 2487897 2487897 defendant Ware William clerk 665131 665131 Ware, William, of Ottery St Mary, Devon, clerk 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);