names

20 rows where place_id = 650639

✎ 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
3913243 1994760 1994760 defendant Phelip John husbandman 650639 650639 Phelip, John, of Turneston, husbandman 1
3965366 2012501 2012501 defendant Tyler Richard yeoman 650639 650639 Tyler, Richard, of Turneston, yeoman 5
3980547 2017807 2017807 plaintiff Phelipp John husbandman 650639 650639 Phelipp, John, of Turneston, husbandman 0
4075915 2051689 2051689 plaintiff Scudamore Henry yeoman 650639 650639 Scudamore, Henry, of Turneston, yeoman 0
4182952 2089517 2089517 defendant Ball Thomas yeoman 650639 650639 Ball, Thomas, of Turneston, yeoman 0
4189442 2091802 2091802 defendant Ball Thomas yeoman 650639 650639 Ball, Thomas, of Turneston, yeoman 2
4223033 2103547 2103547 defendant Powell Abraham gent 650639 650639 Powell, Abraham, of Turneston, gent 0
4248355 2112442 2112442 defendant Powell Abraham   650639 650639 Powell, Abraham, of Turneston gent 0
4319027 2136771 2136771 defendant Scudamore Henry yeoman 650639 650639 Scudamore, Henry, of Turneston, yeoman 0
4319028 2136771 2136771 defendant Scudamore Abraham yeoman 650639 650639 Scudamore, Abraham, of Turneston, yeoman 1
4409240 2167690 2167690 defendant Powell Abraham gent 650639 650639 Powell, Abraham, of Turneston, gent 0
4417650 2170403 2170403 plaintiff Patesty John   650639 650639 Patesty, John, of Turneston 2
4448445 2184447 2184447 plaintiff Foxton Thomas de   650639 650639 Foxton, Thomas de, of Turneston, parson 0
4448448 2184448 2184448 plaintiff Foxton Thomas de   650639 650639 Foxton, Thomas de, of Turneston, parson 0
4574534 2223566 2223566 plaintiff Bernere John   650639 650639 Bernere, John, of Turneston, parson 0
4574537 2223567 2223567 plaintiff Bernere John   650639 650639 Bernere, John, of Turneston, parson 0
4584740 2226653 2226653 plaintiff Gough John   650639 650639 Gough, John, of Turneston, parson 0
4837058 2307548 2307548 defendant Seybon John clerk 650639 650639 Seybon, John, of Turneston, clerk 1
4926423 2334685 2334685 defendant Deo William husbandman 650639 650639 Deo, William, of Turneston, husbandman 4
4926424 2334685 2334685 defendant Boton William husbandman 650639 650639 Boton, William, of Turneston, husbandman 5

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