names

27 rows where place_id = 610699

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3684767 1921372 1921372 defendant Deke Thomas, senior chapman 610699 610699 Deke, Thomas, senior, of Stoke juxta Clare, Suff, chapman 1
3766167 1947071 1947071 defendant Alby alias Brewster Thomas yeoman 610699 610699 Alby alias Brewster, Thomas, of Stoke juxta Clare, Suff, yeoman 0
3806148 1959851 1959851 defendant Dodde Richard yeoman 610699 610699 Dodde, Richard, of Stoke juxta Clare, Suff, yeoman 0
3876030 1982237 1982237 defendant Reynard Richard yeoman 610699 610699 Reynard, Richard, of Stoke juxta Clare, Suff, yeoman 2
3907960 1992954 1992954 plaintiff Porter William   610699 610699 Porter, William, of Stoke juxta Clare, Suff 0
3916351 1995853 1995853 defendant Danyell George gent 610699 610699 Danyell, George, of Stoke juxta Clare, Suff, gent 0
3948604 2006572 2006572 defendant Brewster William butcher 610699 610699 Brewster, William, of Stoke juxta Clare, Suff, butcher 3
4242155 2110369 2110369 defendant Danyell John gent 610699 610699 Danyell, John, of Stoke juxta Clare, Suff, gent 0
4251834 2113603 2113603 defendant Danyell John gent 610699 610699 Danyell, John, of Stoke juxta Clare, Suff, gent 0
4277344 2122000 2122000 defendant Turner Ralph gent 610699 610699 Turner, Ralph, of Stoke juxta Clare, Suff, gent 1
4291269 2126947 2126947 defendant Porter Henry yeoman 610699 610699 Porter, Henry, of Stoke juxta Clare, Suff, yeoman 1
4296004 2128670 2128670 defendant Dyke John yeoman 610699 610699 Dyke, John, of Stoke juxta Clare, Suff, yeoman 0
4296193 2128737 2128737 defendant Towlker John gent 610699 610699 Towlker, John, of Stoke juxta Clare, Suff, gent 0
4328205 2139749 2139749 defendant Payne Benjamin yeoman 610699 610699 Payne, Benjamin, of Stoke juxta Clare, Suff, yeoman 1
4333444 2141464 2141464 defendant Payne Benjamin yeoman 610699 610699 Payne, Benjamin, of Stoke juxta Clare, Suff, yeoman 2
4663253 2249975 2249975 defendant Parker John smith 610699 610699 Parker, John, of Stoke juxta Clare, Suff, smith 0
4663258 2249976 2249976 defendant Parker John smith 610699 610699 Parker, John, of Stoke juxta Clare, Suff, smith 0
4786871 2291954 2291954 defendant Glovere alias Dreycote John yeoman 610699 610699 Glovere alias Dreycote, John, of Stoke juxta Clare, Suff, yeoman 2
4786878 2291956 2291956 defendant Glovere alias Draycote John yeoman 610699 610699 Glovere alias Draycote, John, of Stoke juxta Clare, Suff, yeoman 2
4860196 2314548 2314548 defendant Fox John weaver 610699 610699 Fox, John, of Stoke juxta Clare, Suff, weaver 2
4868452 2317106 2317106 plaintiff Carleton Thomas   610699 610699 Carleton, Thomas, of Stoke juxta Clare, Suff 1
4868456 2317107 2317107 plaintiff Carleton Thomas   610699 610699 Carleton, Thomas, of Stoke juxta Clare, Suff 1
5033407 2366652 2366652 defendant Grymston John yeoman 610699 610699 Grymston, John, of Stoke juxta Clare, Suff, yeoman 0
5235772 2426038 2426038 defendant Brydon Thomas yeoman 610699 610699 Brydon, Thomas, of Stoke juxta Clare, Suff, yeoman 0
5235789 2426044 2426044 defendant Brydon Thomas yeoman 610699 610699 Brydon, Thomas, of Stoke juxta Clare, Suff, yeoman 0
5243925 2428414 2428414 defendant Cope Robert fuller 610699 610699 Cope, Robert, of Stoke juxta Clare, Suff, fuller 4
5264920 2434787 2434787 defendant Walflete William clerk 610699 610699 (Walflete, William, of Stoke juxta Clare, Suff, clerk 1

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