names

48 rows where place_id = 598478

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3632673 1905034 1905034 defendant Mawnder Thomas yeoman 598478 598478 Mawnder, Thomas, of Halberton, Devon, yeoman 1
3691878 1923620 1923620 plaintiff Hoper John gent 598478 598478 Hoper, John, of Halberton, Devon, gent 0
3884839 1985202 1985202 defendant Pasmer John gent 598478 598478 Pasmer, John, of Halberton, Devon, gent 1
3914278 1995119 1995119 defendant Bydwell Francis gent 598478 598478 Bydwell, Francis, of Halberton, Devon, gent 2
3914283 1995121 1995121 defendant Sanford alias Sampford Christopher gent 598478 598478 Sanford alias Sampford, Christopher, of Halberton, Devon, gent 0
3914285 1995122 1995122 defendant Sanford Christopher gent 598478 598478 Sanford, Christopher, of Halberton, Devon, gent 0
3936551 2002548 2002548 defendant Losemore John husbandman 598478 598478 Losemore, John, of Halberton, Devon, husbandman 4
4009968 2028330 2028330 defendant Bury Richard yeoman 598478 598478 Bury, Richard, of Halberton, Devon, yeoman 0
4009970 2028331 2028331 defendant Bury Richard   598478 598478 Bury, Richard, of Halberton, Devon, yeoman, constable 0
4024132 2033335 2033335 plaintiff Berye Richard yeoman 598478 598478 Berye, Richard, of Halberton, Devon, yeoman 0
4056122 2044578 2044578 defendant Passemore Denis gent 598478 598478 Passemore, Denis, of Halberton, Devon, gent 0
4056127 2044580 2044580 defendant Passemore George gent 598478 598478 Passemore, George, of Halberton, Devon, gent 0
4091201 2057142 2057142 defendant Berye Richard yeoman 598478 598478 Berye, Richard, of Halberton, Devon, yeoman 0
4094743 2058453 2058453 defendant Passemere George gent 598478 598478 Passemere, George, of Halberton, Devon, gent 0
4099330 2060084 2060084 defendant Kyllington William yeoman 598478 598478 Kyllington, William, of Halberton, Devon, yeoman 5
4103373 2061488 2061488 defendant Berrye Richard gent 598478 598478 Berrye, Richard, of Halberton, Devon, gent 0
4117574 2066580 2066580 defendant Bery Richard gent 598478 598478 Bery, Richard, of Halberton, Devon, gent 1
4133300 2072234 2072234 defendant Thompson Thomas gent 598478 598478 Thompson, Thomas, of Halberton, Devon, gent 0
4141131 2075058 2075058 defendant Tompson Thomas gent 598478 598478 Tompson, Thomas, of Halberton, Devon, gent 2
4141412 2075153 2075153 defendant Owen Richard yeoman 598478 598478 Owen, Richard, of Halberton, Devon, yeoman 0
4161147 2081975 2081975 defendant Pasmere Peter gent 598478 598478 Pasmere, Peter, of Halberton, Devon, or of Chester, gent 0
4178662 2088015 2088015 defendant Thompson Thomas gent 598478 598478 Thompson, Thomas, of Halberton, Devon, gent 0
4186066 2090614 2090614 defendant Hopwood Edmund clothier 598478 598478 Hopwood, Edmund, of Halberton, Devon, clothier 2
4191420 2092569 2092569 defendant Foxwell James husbandman 598478 598478 Foxwell, James, of Halberton, Devon, husbandman 0
4194427 2093602 2093602 defendant Mannyng William miller 598478 598478 Mannyng, William, of Halberton, Devon, miller 1
4194816 2093747 2093747 defendant Foxwell James husbandman 598478 598478 Foxwell, James, of Halberton, Devon, husbandman 0
4194818 2093748 2093748 defendant Masters Edward husbandman 598478 598478 Masters, Edward, of Halberton, Devon, husbandman 0
4205964 2097630 2097630 defendant Pasmere Denis gent 598478 598478 Pasmere, Denis, of Halberton, Devon, gent 0
4209851 2099006 2099006 defendant Hopwood Edmund clothier 598478 598478 Hopwood, Edmund, of Halberton, Devon, clothier 2
4211223 2099478 2099478 defendant Bagbeare Robert yeoman 598478 598478 Bagbeare, Robert, of Halberton, Devon, yeoman 3
4239585 2109472 2109472 plaintiff Turner Nicholas merchant 598478 598478 Turner, Nicholas, of Halberton, Devon, merchant 0
4239586 2109473 2109473 plaintiff Turner Nicholas merchant 598478 598478 Turner, Nicholas, of Halberton, Devon, merchant 0
4241680 2110203 2110203 defendant Cole alias Swayne Robert husbandman 598478 598478 Cole alias Swayne, Robert, of Halberton, Devon, husbandman 0
4241681 2110203 2110203 defendant Browse Nicholas husbandman 598478 598478 Browse, Nicholas, of Halberton, Devon, husbandman 1
4271495 2120047 2120047 defendant Saunder John husbandman 598478 598478 Saunder, John, of Halberton, Devon, husbandman 0
4273245 2120612 2120612 defendant Turner Nicholas merchant 598478 598478 Turner, Nicholas, of Halberton, Devon, merchant 0
4273248 2120613 2120613 defendant Turner Nicholas merchant 598478 598478 Turner, Nicholas, of Halberton, Devon, merchant 0
4282234 2123684 2123684 defendant Dyble John, senior husbandman 598478 598478 Dyble, John, senior, of Halberton, Devon, husbandman 0
4292045 2127228 2127228 defendant Thompson Thomas   598478 598478 Thompson, Thomas, of Halberton, Devon, gent, attorney 0
4312227 2134413 2134413 defendant Tompson Thomas gent 598478 598478 Tompson, Thomas, of Halberton, Devon, gent 0
4363649 2152071 2152071 defendant Bery Richard yeoman 598478 598478 Bery, Richard, of Halberton, Devon, yeoman 0
4651574 2246491 2246491 defendant Gambon John gent 598478 598478 Gambon, John, of Halberton, Devon, gent 1
4685492 2261057 2261057 defendant Manelegh John husbandman 598478 598478 Manelegh, John, of Halberton, Devon, husbandman 0
4712697 2269284 2269284 defendant Philberd Roger drover 598478 598478 Philberd, Roger, of Halberton, Devon, drover 0
4766933 2285646 2285646 defendant Style William husbandman 598478 598478 Style, William, of Halberton, Devon, husbandman 3
4992988 2354787 2354787 defendant Wheler Richard yeoman 598478 598478 Wheler, Richard, of Halberton, Devon, yeoman 0
5096670 2385461 2385461 defendant Hilleresdon Andrew esq 598478 598478 Hilleresdon, Andrew, of Halberton, Devon, esq 3
5515812 2509792 2509792 defendant Seman Thomas gent 598478 598478 Seman, Thomas, of Halberton, Devon, gent 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);