names

23 rows where place_id = 672610

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4006307 2027035 2027035 defendant Broke Richard yeoman 672610 672610 Broke, Richard, of Heaton, yeoman 0
4099840 2060267 2060267 defendant Horner William yeoman 672610 672610 Horner, William, of Heaton, yeoman 0
4099845 2060268 2060268 defendant Horner William yeoman 672610 672610 Horner, William, of Heaton, yeoman 0
4129841 2070982 2070982 defendant Sampson Richard laborer 672610 672610 Sampson, Richard, of Heaton, laborer 1
4130476 2071214 2071214 defendant Hirste Thomas, senior clothier 672610 672610 Hirste, Thomas, senior, of Heaton, clothier 0
4130477 2071214 2071214 defendant Hyrste Thomas, junior clothier 672610 672610 Hyrste, Thomas, junior, of Heaton, clothier 1
4130478 2071214 2071214 defendant Hirste James clothier 672610 672610 Hirste, James, of Heaton, clothier 2
4131576 2071611 2071611 defendant Blackburne William clothier 672610 672610 Blackburne, William, of Heaton, clothier 1
4179727 2088381 2088381 defendant Secker Thomas clothier 672610 672610 Secker, Thomas, of Heaton, clothier 2
4186780 2090865 2090865 defendant Dickson Christopher smith 672610 672610 Dickson, Christopher, of Heaton, smith 1
4196090 2094182 2094182 defendant Turnocke William husbandman 672610 672610 Turnocke, William, of Heaton, husbandman 2
4233510 2107238 2107238 defendant Pecke John yeoman 672610 672610 Pecke, John, of Heaton, yeoman 0
4251751 2113576 2113576 defendant Pecke John yeoman 672610 672610 Pecke, John, of Heaton, yeoman 0
4309656 2133535 2133535 defendant Nickson James yeoman 672610 672610 Nickson, James, of Heaton, yeoman 3
4318065 2136426 2136426 defendant Higgenbotham John husbandman 672610 672610 Higgenbotham, John, of Heaton, husbandman 0
4318066 2136426 2136426 defendant Warele or Wardle James husbandman 672610 672610 Warele or Wardle, James, of Heaton, husbandman 1
4319951 2137084 2137084 defendant Higgenbotham John husbandman 672610 672610 Higgenbotham, John, of Heaton, husbandman 2
4333563 2141505 2141505 defendant Nabb Lawrence husbandman 672610 672610 Nabb, Lawrence, of Heaton, husbandman 2
4354685 2148868 2148868 defendant Trafford Philip gent 672610 672610 Trafford, Philip, of Heaton, gent 0
4355709 2149218 2149218 defendant Higgenbotham Thomas husbandman 672610 672610 Higgenbotham, Thomas, of Heaton, or of Parva Leeke, husbandman 0
4364322 2152302 2152302 defendant Cappes Isabel widow 672610 672610 Cappes, Isabel, of Heaton, widow 0
4364325 2152302 2152302 defendant Roades John yeoman 672610 672610 Roades, John, of Heaton, yeoman 3
4404502 2166073 2166073 defendant Padley John yeoman 672610 672610 Padley, John, of Heaton, yeoman 2

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