names

27 rows where place_id = 592267

✎ 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
3607144 1869900 1869900 defendant Stenelake John husbandman 592267 592267 Stenelake, John, of Blaketoryton, husbandman 0
3607145 1869900 1869900 defendant Stenelake William husbandman 592267 592267 Stenelake, William, of Blaketoryton, husbandman 1
3607146 1869900 1869900 defendant Vell John husbandman 592267 592267 Vell, John, of Blaketoryton, husbandman 2
3610999 1871118 1871118 defendant Smale John husbandman 592267 592267 Smale, John, of Blaketoryton, husbandman 0
3611710 1871325 1871325 defendant Stenelake John husbandman 592267 592267 Stenelake, John, of Blaketoryton, husbandman 0
3611711 1871325 1871325 defendant Stenelake William husbandman 592267 592267 Stenelake, William, of Blaketoryton, husbandman 1
3611712 1871325 1871325 defendant Vell John husbandman 592267 592267 Vell, John, of Blaketoryton, husbandman 2
3628404 1903749 1903749 defendant Frye John husbandman 592267 592267 Frye, John, of Blaketoryton, husbandman 0
3725694 1934323 1934323 defendant Stephen Robert husbandman 592267 592267 Stephen, Robert, of Blaketoryton, husbandman 0
3725697 1934324 1934324 defendant Stephen Robert husbandman 592267 592267 Stephen, Robert, of Blaketoryton, husbandman 0
3809241 1960770 1960770 defendant Stephyn Agnes widow 592267 592267 Stephyn, Agnes, of Blaketoryton, widow 1
3810788 1961277 1961277 plaintiff Burdon Nicholas husbandman 592267 592267 Burdon, Nicholas, of Blaketoryton, husbandman 0
3906847 1992580 1992580 defendant Whytcroft John husbandman 592267 592267 Whytcroft, John, of Blaketoryton, husbandman 1
4660989 2249262 2249262 defendant Nicoll John tailor 592267 592267 Nicoll, John, of Blaketoryton, tailor 0
4665508 2250684 2250684 defendant atte Brygge Robert   592267 592267 atte Brygge, Robert, of Blaketoryton, millward 0
4940777 2339144 2339144 defendant Brond Thomas husbandman 592267 592267 Brond, Thomas, of Blaketoryton, husbandman 0
4940778 2339144 2339144 defendant Brond Robert husbandman 592267 592267 Brond, Robert, of Blaketoryton, husbandman 1
4949365 2341787 2341787 defendant Coham John husbandman 592267 592267 Coham, John, of Blaketoryton, husbandman 3
4957798 2344304 2344304 defendant Squyer Walter laborer 592267 592267 Squyer, Walter, of Blaketoryton, laborer 0
4967874 2347335 2347335 defendant Bordon John husbandman 592267 592267 Bordon, John, of Blaketoryton, husbandman 2
4984205 2352210 2352210 defendant Squyer Walter laborer 592267 592267 Squyer, Walter, of Blaketoryton, laborer 0
5020219 2362803 2362803 defendant Pedeler John drover 592267 592267 Pedeler, John, of Blaketoryton, drover 0
5020220 2362803 2362803 defendant Goreford John husbandman 592267 592267 Goreford, John, of Blaketoryton, husbandman 1
5089091 2383186 2383186 defendant Brond Robert husbandman 592267 592267 Brond, Robert, of Blaketoryton, husbandman 0
5231904 2424904 2424904 defendant Bronde Robert merchant 592267 592267 Bronde, Robert, of Blaketoryton, merchant 0
5342642 2457901 2457901 defendant Braddeston Walter husbandman 592267 592267 Braddeston, Walter, of Blaketoryton, or of Est Kymbeare, husbandman 0
5520574 2511260 2511260 defendant White Thomas yeoman 592267 592267 White, Thomas, of Blaketoryton, 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);