names

22 rows where place_id = 608126

✎ 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
3672277 1917329 1917329 plaintiff Crossewell Thomas   608126 608126 Crossewell, Thomas, of Upton Snoddesbury 0
3703159 1927260 1927260 defendant Lyde John husbandman 608126 608126 Lyde, John, of Upton Snoddesbury, husbandman 0
3705051 1927869 1927869 defendant Grene Philip yeoman 608126 608126 Grene, Philip, of Upton Snoddesbury, yeoman 0
3746825 1940927 1940927 defendant Chamber William husbandman 608126 608126 Chamber, William, of Upton Snoddesbury, husbandman 0
3746828 1940928 1940928 defendant Horwell John husbandman 608126 608126 Horwell, John, of Upton Snoddesbury, husbandman 0
3746829 1940928 1940928 defendant Bagott John laborer 608126 608126 Bagott, John, of Upton Snoddesbury, laborer 1
3760271 1945216 1945216 defendant Chamber William husbandman 608126 608126 Chamber, William, of Upton Snoddesbury, husbandman 0
3829007 1966957 1966957 defendant Payne John husbandman 608126 608126 Payne, John, of Upton Snoddesbury, husbandman 0
3829012 1966957 1966957 defendant Croswell Richard husbandman 608126 608126 Croswell, Richard, of Upton Snoddesbury, husbandman 5
3829297 1967046 1967046 defendant Grene Philip yeoman 608126 608126 Grene, Philip, of Upton Snoddesbury, yeoman 0
3829298 1967046 1967046 defendant Grene Armigil yeoman 608126 608126 Grene, Armigil, of Upton Snoddesbury, yeoman 1
3829739 1967193 1967193 defendant Grene Philip husbandman 608126 608126 Grene, Philip, of Upton Snoddesbury, husbandman 0
3829740 1967193 1967193 defendant Grene Armel husbandman 608126 608126 Grene, Armel, of Upton Snoddesbury, husbandman 1
3844799 1971918 1971918 defendant Grene Armelus or Armely   608126 608126 Grene, Armelus or Armely, of Upton Snoddesbury, husbandman, son of Grene, Philip 0
3844801 1971919 1971919 defendant Grene Philip husbandman 608126 608126 Grene, Philip, of Upton Snoddesbury, husbandman 0
4285840 2124987 2124987 defendant Burbedge Robert gent 608126 608126 Burbedge, Robert, of Upton Snoddesbury, gent 0
4285842 2124988 2124988 defendant Burbedge Robert gent 608126 608126 Burbedge, Robert, of Upton Snoddesbury, gent 0
5526446 2512837 2512837 defendant Cleydon Joan widow 608126 608126 Cleydon, Joan, of Upton Snoddesbury, widow 2
5572858 2526614 2526614 defendant Gonderton or Gouderton Richard husbandman 608126 608126 Gonderton or Gouderton, Richard, of Upton Snoddesbury, husbandman 0
5572859 2526614 2526614 defendant Broke Thomas husbandman 608126 608126 Broke, Thomas, of Upton Snoddesbury, husbandman 1
5572860 2526614 2526614 defendant Payn John husbandman 608126 608126 Payn, John, of Upton Snoddesbury, husbandman 2
5572861 2526614 2526614 defendant Broke William husbandman 608126 608126 Broke, William, of Upton Snoddesbury, husbandman 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);