names

15 rows where place_id = 617328

✎ 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
3718918 1932196 1932196 defendant Smart Thomas husbandman 617328 617328 Smart, Thomas, of North Pederwyn, husbandman 0
3758700 1944715 1944715 defendant Wylsam John chaplain 617328 617328 Wylsam, John, of North Pederwyn, chaplain 0
3758701 1944715 1944715 defendant Seccam Nicholas husbandman 617328 617328 Seccam, Nicholas, of North Pederwyn, husbandman 1
3758702 1944715 1944715 defendant Seccam John chaplain 617328 617328 Seccam, John, of North Pederwyn, chaplain 2
3768575 1947817 1947817 defendant Talcaron John gent 617328 617328 Talcaron, John, of North Pederwyn, gent 0
3786372 1953523 1953523 defendant Talcaron John gent 617328 617328 Talcaron, John, of North Pederwyn, gent 0
3882498 1984410 1984410 defendant Pope John husbandman 617328 617328 Pope, John, of North Pederwyn, husbandman 0
4736977 2276693 2276693 defendant Tomme alias Skot John husbandman 617328 617328 Tomme alias Skot, John, of North Pederwyn, husbandman 2
4828658 2305005 2305005 defendant Clay Richard gent 617328 617328 Clay, Richard, of North Pederwyn, gent 0
4834149 2306689 2306689 defendant Clay Richard yeoman 617328 617328 Clay, Richard, of North Pederwyn, yeoman 0
4838271 2307888 2307888 defendant Page Robert husbandman 617328 617328 Page, Robert, of North Pederwyn, husbandman 0
4871355 2318009 2318009 defendant Lovea or Lonea John tailor 617328 617328 Lovea or Lonea, John, of North Pederwyn, tailor 0
4965088 2346483 2346483 defendant Clay Richard gent 617328 617328 Clay, Richard, of North Pederwyn, gent 0
5559177 2522647 2522647 defendant Myll Nicholas husbandman 617328 617328 Myll, Nicholas, of North Pederwyn, husbandman 0
5607098 2537108 2537108 defendant Foggeler John husbandman 617328 617328 Foggeler, John, of North Pederwyn, 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);