names

26 rows where place_id = 643405

✎ 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
3783228 1952507 1952507 defendant Axe John   643405 643405 Axe, John, of North Petherton, Soms, yeoman, son of Axe, Thomas 0
3873457 1981339 1981339 defendant Worth John gent 643405 643405 Worth, John, of North Petherton, Soms, gent 0
3919607 1996890 1996890 defendant Popham Alexander gent 643405 643405 Popham, Alexander, of North Petherton, Soms, gent 0
3919610 1996891 1996891 defendant Popham Alexander gent 643405 643405 Popham, Alexander, of North Petherton, Soms, gent 1
3919613 1996892 1996892 defendant Popham Alexander gent 643405 643405 Popham, Alexander, of North Petherton, Soms, gent 1
3921938 1997681 1997681 defendant Popham Alexander gent 643405 643405 Popham, Alexander, of North Petherton, Soms, gent 1
3921941 1997682 1997682 defendant Popham Alexander gent 643405 643405 Popham, Alexander, of North Petherton, Soms, gent 1
3966388 2012875 2012875 plaintiff Bovye John miller 643405 643405 Bovye, John, of North Petherton, Soms, miller 0
4004922 2026543 2026543 defendant Popham Alexander (legal representative) 643405 643405 Popham, Alexander, of North Petherton, Soms, gent, executors of 0
4059930 2045947 2045947 defendant Bisgood or Bidgegood Richard gent 643405 643405 Bisgood or Bidgegood, Richard, of North Petherton, Soms, gent 3
4096158 2058955 2058955 defendant Saye John husbandman 643405 643405 Saye, John, of North Petherton, Soms, husbandman 0
4109707 2063728 2063728 defendant Englishe John yeoman 643405 643405 Englishe, John, of North Petherton, Soms, yeoman 1
4122482 2068350 2068350 defendant Came or Caine Henry yeoman 643405 643405 Came or Caine, Henry, of North Petherton, Soms, yeoman 0
4122484 2068351 2068351 defendant Englishe Simon husbandman 643405 643405 Englishe, Simon, of North Petherton, Soms, husbandman 0
4132447 2071921 2071921 defendant Vilde John chapman 643405 643405 Vilde, John, of North Petherton, Soms, chapman 1
4133086 2072163 2072163 defendant Hill Hugh yeoman 643405 643405 Hill, Hugh, of North Petherton, Soms, yeoman 0
4160657 2081801 2081801 defendant Beryfeld Simon yeoman 643405 643405 Beryfeld, Simon, of North Petherton, Soms, yeoman 0
4162864 2082542 2082542 defendant Vymcomb Simon gent 643405 643405 Vymcomb, Simon, of North Petherton, Soms, gent 50
4192534 2092952 2092952 defendant Blancheflower Thomas husbandman 643405 643405 Blancheflower, Thomas, of North Petherton, Soms, husbandman 0
4202593 2096451 2096451 defendant Jeffreys Alexander tanner 643405 643405 Jeffreys, Alexander, of North Petherton, Soms, tanner 0
4236946 2108500 2108500 defendant Fitzjames Francis gent 643405 643405 Fitzjames, Francis, of North Petherton, Soms, gent 0
4257651 2115533 2115533 defendant Fitzjames Francis gent 643405 643405 Fitzjames, Francis, of North petherton, Soms, gent 0
4378618 2157424 2157424 defendant Burdge Thomas husbandman 643405 643405 Burdge, Thomas, of North Petherton, Soms, husbandman 2
4380643 2158185 2158185 defendant Hayes Thomas husbandman 643405 643405 Hayes, Thomas, of North Petherton, Soms, husbandman 1
5079829 2380446 2380446 defendant Mauncell John, senior gent 643405 643405 Mauncell, John, senior, of North Petherton, Soms, gent 0
5079840 2380446 2380446 defendant Claveshay or Claneshay John   643405 643405 Claveshay or Claneshay, John, of North Petherton, Soms, franklin 11

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