names

38 rows where place_id = 636167

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3829293 1967045 1967045 defendant Baker John yeoman 636167 636167 Baker, John, of Magna Cowarne, yeoman 2
3834009 1968578 1968578 defendant Lewys Thomas husbandman 636167 636167 Lewys, Thomas, of Magna Cowarne, husbandman 1
3874427 1981675 1981675 defendant Baker John yeoman 636167 636167 Baker, John, of Magna Cowarne, yeoman 2
3886630 1985780 1985780 defendant Sowth Thomas husbandman 636167 636167 Sowth, Thomas, of Magna Cowarne, husbandman 0
3895116 1988578 1988578 plaintiff Skull Richard gent 636167 636167 Skull, Richard, of Magna Cowarne, gent 0
3945027 2005355 2005355 defendant Pauncefote John esq 636167 636167 Pauncefote, John, of Magna Cowarne, esq 0
3965959 2012712 2012712 defendant Joldyn John husbandman 636167 636167 Joldyn, John, of Magna Cowarne, husbandman 1
3973940 2015456 2015456 defendant Pauncefote John esq 636167 636167 Pauncefote, John, of Magna Cowarne, esq 0
3975699 2016059 2016059 defendant Bundye John husbandman 636167 636167 Bundye, John, of Magna Cowarne, husbandman 0
3983467 2018863 2018863 plaintiff Soull Richard gent 636167 636167 Soull, Richard, of Magna Cowarne, gent 0
3983821 2018986 2018986 defendant Wigmore Hugh husbandman 636167 636167 Wigmore, Hugh, of Magna Cowarne, husbandman 1
4039229 2038657 2038657 defendant Jauncye Thomas yeoman 636167 636167 Jauncye, Thomas, of Magna Cowarne, yeoman 0
4039230 2038657 2038657 defendant Barnett John husbandman 636167 636167 Barnett, John, of Magna Cowarne, husbandman 1
4039231 2038657 2038657 defendant Partryche Henry husbandman 636167 636167 Partryche, Henry, of Magna Cowarne, husbandman 2
4039232 2038657 2038657 defendant Gotman Roger husbandman 636167 636167 Gotman, Roger, of Magna Cowarne, husbandman 3
4050624 2042653 2042653 defendant Bondye John yeoman 636167 636167 Bondye, John, of Magna Cowarne, yeoman 0
4105017 2062067 2062067 defendant Howles Thomas husbandman 636167 636167 Howles, Thomas, of Magna Cowarne, husbandman 0
4108825 2063408 2063408 defendant Howles Thomas husbandman 636167 636167 Howles, Thomas, of Magna Cowarne, husbandman 0
4108972 2063465 2063465 defendant Howles Thomas husbandman 636167 636167 Howles, Thomas, of Magna Cowarne, husbandman 0
4108973 2063465 2063465 defendant Gwynne William husbandman 636167 636167 Gwynne, William, of Magna Cowarne, husbandman 1
4108974 2063465 2063465 defendant Gwynne John husbandman 636167 636167 Gwynne, John, of Magna Cowarne, husbandman 2
4108975 2063465 2063465 defendant Bondy Thomas yeoman 636167 636167 Bondy, Thomas, of Magna Cowarne, yeoman 3
4146082 2076780 2076780 defendant Benett Edward gent 636167 636167 Benett, Edward, of Magna Cowarne, gent 2
4162061 2082288 2082288 defendant Boundy Thomas husbandman 636167 636167 Boundy, Thomas, of Magna Cowarne, husbandman 0
4162062 2082288 2082288 defendant Strettell alias Bruer John yeoman 636167 636167 Strettell alias Bruer, John, of Magna Cowarne, yeoman 1
4189392 2091790 2091790 defendant Baddam John tailor 636167 636167 Baddam, John, of Magna Cowarne, tailor 0
4214262 2100506 2100506 defendant Scull William gent 636167 636167 Scull, William, of Magna Cowarne, gent 0
4234068 2107440 2107440 defendant Bennett George yeoman 636167 636167 Bennett, George, of Magna Cowarne, yeoman 0
4234070 2107441 2107441 defendant Bennett George yeoman 636167 636167 Bennett, George, of Magna Cowarne, yeoman 0
4300434 2130255 2130255 defendant Jauncy Thomas gent 636167 636167 Jauncy, Thomas, of Magna Cowarne, gent 1
4387372 2160422 2160422 defendant Bundye Richard husbandman 636167 636167 Bundye, Richard, of Magna Cowarne, husbandman 1
5102542 2387147 2387147 defendant Home John husbandman 636167 636167 Home, John, of Magna Cowarne, husbandman 0
5335751 2455756 2455756 defendant Maytheneld Thomas husbandman 636167 636167 Maytheneld, Thomas, of Magna Cowarne, husbandman 4
5558283 2522374 2522374 defendant Baker Roger husbandman 636167 636167 Baker, Roger, of Magna Cowarne, husbandman 0
5558284 2522374 2522374 defendant Baker John husbandman 636167 636167 Baker, John, of Magna Cowarne, husbandman 1
5558309 2522379 2522379 defendant Ceste John husbandman 636167 636167 Ceste, John, of Magna Cowarne, husbandman 2
5558310 2522379 2522379 defendant Geoldyn William husbandman 636167 636167 Geoldyn, William, of Magna Cowarne, husbandman 3
5577326 2527966 2527966 defendant Jeldewyn William husbandman 636167 636167 Jeldewyn, William, of Magna Cowarne, husbandman 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);