names

25 rows where place_id = 612041

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3691277 1923429 1923429 defendant Raynold John clerk 612041 612041 Raynold, John, of Teverton, clerk 0
3696446 1925114 1925114 defendant Bury Robert husbandman 612041 612041 Bury, Robert, of Teverton, husbandman 0
3696447 1925114 1925114 defendant Bury Thomas laborer 612041 612041 Bury, Thomas, of Teverton, laborer 1
3778232 1950900 1950900 plaintiff Craston Lawrence   612041 612041 Craston, Lawrence, of Teverton, 0
3786406 1953535 1953535 defendant Baker John   612041 612041 Baker, John, of Teverton, court holder 0
3830995 1967577 1967577 defendant Prous John husbandman 612041 612041 Prous, John, of Teverton, husbandman 0
3868228 1979608 1979608 defendant Rewe Nicholas yeoman 612041 612041 Rewe, Nicholas, of Teverton, yeoman 1
3892018 1987582 1987582 defendant Bery William   612041 612041 Bery, William, of Teverton, clothman, administrators of 0
3892020 1987582 1987582 defendant Dun John yeoman 612041 612041 Dun, John, of Teverton, yeoman 2
3892021 1987582 1987582 defendant Trott Martin yeoman 612041 612041 Trott, Martin, of Teverton, yeoman 3
3892026 1987583 1987583 defendant Dun John yeoman 612041 612041 Dun, John, of Teverton, yeoman 1
3892027 1987583 1987583 defendant Bery William (legal representative) 612041 612041 Bery, William, of Teverton, clothman, administrator of 2
3892028 1987583 1987583 defendant Trott Martin yeoman 612041 612041 Trott, Martin, of Teverton, yeoman 3
3892341 1987689 1987689 defendant Bery William   612041 612041 Bery, William, of Teverton, clothman, administrators of 0
3892343 1987689 1987689 defendant Dun John yeoman 612041 612041 Dun, John, of Teverton, yeoman 2
3892344 1987689 1987689 defendant Trott Martin yeoman 612041 612041 Trott, Martin, of Teverton, yeoman 3
3906298 1992394 1992394 defendant Guy John clerk 612041 612041 (Guy, John, of Teverton, clerk 1
3906299 1992394 1992394 defendant Dun John yeoman 612041 612041 Dun, John, of Teverton, yeoman 2
3906300 1992394 1992394 defendant Trott Martin yeoman 612041 612041 Trott, Martin, of Teverton, yeoman 3
3957707 2009754 2009754 plaintiff Prouse John clothier 612041 612041 Prouse, John, of Teverton, clothier 0
4923203 2333679 2333679 defendant Benet Thomas skinner 612041 612041 Benet, Thomas, of Teverton, skinner 1
4923588 2333812 2333812 defendant Hode William skinner 612041 612041 Hode, William, of Teverton, skinner 1
4955991 2343758 2343758 defendant Herte Thomas tailor 612041 612041 Herte, Thomas, of Teverton, tailor 1
5164910 2405472 2405472 defendant Wightman Robert husbandman 612041 612041 Wightman, Robert, of Teverton, husbandman 0
5219420 2421405 2421405 defendant Holwell John yeoman 612041 612041 Holwell, John, of Teverton, yeoman 2

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