names

23 rows where place_id = 781138

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4671361 2256692 2256692 defendant Broune John yeoman 781138 781138 Broune, John, of Bochardby, yeoman 3
4679055 2259056 2259056 defendant Fynglaue Roger yeoman 781138 781138 Fynglaue, Roger, of Bochardby, yeoman 2
4704841 2266892 2266892 defendant Broun John yeoman 781138 781138 Broun, John, of Bochardby, yeoman 0
4704843 2266893 2266893 defendant Broun John yeoman 781138 781138 Broun, John, of Bochardby, yeoman 0
4842778 2309280 2309280 defendant Tounesend John yeoman 781138 781138 Tounesend, John, of Bochardby, yeoman 0
4842780 2309280 2309280 defendant Swan Robert yeoman 781138 781138 Swan, Robert, of Bochardby, yeoman 2
4842787 2309283 2309283 defendant Tounesden John yeoman 781138 781138 Tounesden, John, of Bochardby, yeoman 0
4842788 2309283 2309283 defendant Swan Robert yeoman 781138 781138 Swan, Robert, of Bochardby, yeoman 1
4860751 2314724 2314724 defendant Tounhend John yeoman 781138 781138 Tounhend, John, of Bochardby, yeoman 0
4860752 2314724 2314724 defendant Andreweson Richard husbandman 781138 781138 Andreweson, Richard, of Bochardby, husbandman 1
4860753 2314724 2314724 defendant Jonson William   781138 781138 Jonson, William, of Bochardby, servant 2
4881155 2321014 2321014 defendant Newelandes Thomas yeoman 781138 781138 Newelandes, Thomas, of Bochardby, yeoman 1
4886737 2322708 2322708 defendant Stanwykes John yeoman 781138 781138 Stanwykes, John, of Bochardby, yeoman 3
4993005 2354792 2354792 defendant Colyer Thomas yeoman 781138 781138 Colyer, Thomas, of Bochardby, yeoman 5
5158901 2403726 2403726 defendant Sewell William yeoman 781138 781138 Sewell, William, of Bochardby, yeoman 12
5158902 2403726 2403726 defendant Woldehane Henry yeoman 781138 781138 Woldehane, Henry, of Bochardby, yeoman 13
5158903 2403726 2403726 defendant Holme John yeoman 781138 781138 Holme, John, of Bochardby, yeoman 14
5158904 2403726 2403726 defendant Holme Robert yeoman 781138 781138 Holme, Robert, of Bochardby, yeoman 15
5158905 2403726 2403726 defendant Holme Henry yeoman 781138 781138 Holme, Henry, of Bochardby, yeoman 16
5158906 2403726 2403726 defendant Rayleston Henry yeoman 781138 781138 Rayleston, Henry, of Bochardby, yeoman 17
5158907 2403726 2403726 defendant Rayleton William yeoman 781138 781138 Rayleton, William, of Bochardby, yeoman 18
5624771 2551680 2551680 defendant Fynglane or Fynglave Roger yeoman 781138 781138 Fynglane or Fynglave, Roger, of Bochardby, yeoman 1
5631267 2553783 2553783 defendant Page Richard yeoman 781138 781138 Page, Richard, of Bochardby, yeoman 6

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