names

27 rows where place_id = 620095

✎ 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
3733596 1936753 1936753 defendant Tayler Thomas husbandman 620095 620095 Tayler, Thomas, of Otterton, husbandman 0
3733597 1936753 1936753 defendant Tayler John yeoman 620095 620095 Tayler, John, of Otterton, yeoman 1
3733598 1936753 1936753 defendant Tayler Richard yeoman 620095 620095 Tayler, Richard, of Otterton, yeoman 2
3733599 1936753 1936753 defendant Gwyn or Ewyn Morris laborer 620095 620095 Gwyn or Ewyn, Morris, of Otterton, laborer 3
3934213 2001736 2001736 defendant Bellamy Richard dyer 620095 620095 Bellamy, Richard, of Otterton, dyer 0
3934216 2001737 2001737 defendant Belmaye Richard dyer 620095 620095 Belmaye, Richard, of Otterton, dyer 0
3986690 2019980 2019980 defendant Lane John husbandman 620095 620095 Lane, John, of Otterton, husbandman 0
3986692 2019981 2019981 defendant Lane John husbandman 620095 620095 Lane, John, of Otterton, husbandman 0
4037427 2038046 2038046 defendant Drake Thomas husbandman 620095 620095 Drake, Thomas, of Otterton, husbandman 0
4039225 2038655 2038655 defendant Wescot Thomas husbandman 620095 620095 Wescot, Thomas, of Otterton, husbandman 0
4039814 2038854 2038854 defendant Sprynte Gregory gent 620095 620095 Sprynte, Gregory, of Otterton, gent 1
4050886 2042758 2042758 defendant Wescote Thomas husbandman 620095 620095 Wescote, Thomas, of Otterton, husbandman 0
4054369 2043953 2043953 defendant Collyns John yeoman 620095 620095 Collyns, John, of Otterton, yeoman 0
4081061 2053538 2053538 defendant Wescote Thomas husbandman 620095 620095 Wescote, Thomas, of Otterton, husbandman 0
4129087 2070705 2070705 defendant Clarke Thomas husbandman 620095 620095 Clarke, Thomas, of Otterton, husbandman 0
4152534 2079000 2079000 defendant Clarke Thomas husbandman 620095 620095 Clarke, Thomas, of Otterton, husbandman 0
4283891 2124276 2124276 defendant Parson John husbandman 620095 620095 Parson, John, of Otterton, husbandman 1
4308825 2133235 2133235 defendant Lane Lawrence tailor 620095 620095 Lane, Lawrence, of Otterton, or of Blanford, Dorset, tailor 1
4372076 2155077 2155077 defendant Witchalse Thomas gent 620095 620095 Witchalse, Thomas, of otterton, gent 0
4381098 2158355 2158355 defendant Midwinter William yeoman 620095 620095 Midwinter, William, of Otterton, yeoman 0
4381133 2158369 2158369 defendant Midwinter William yeoman 620095 620095 Midwinter, William, of Otterton, yeoman 0
4385979 2160000 2160000 defendant Parsons Robert husbandman 620095 620095 (Parsons, Robert, of Otterton, husbandman 2
4389630 2161162 2161162 defendant (not given) Roger rector of Alley 620095 620095 Alley, Roger, of Otterton, clerk, rector of Pyworthye 0
4413092 2168968 2168968 plaintiff atte Crucche Stephen   620095 620095 atte Crucche, Stephen, of Otterton 0
4413093 2168968 2168968 defendant atte Crucche Michael   620095 620095 atte Crucche, Michael, of Otterton 0
5376314 2468187 2468187 defendant Scorch John husbandman 620095 620095 Scorch, John, of Otterton, husbandman 0
5561325 2523291 2523291 defendant Doun William tucker 620095 620095 Doun, William, of Otterton, tucker 3

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