names

25 rows where place_id = 590841

✎ 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
3602473 1868434 1868434 defendant Pottere Robert (legal representative) 590841 590841 Pottere, Robert, of Stoke Clare, yeoman, executrix of 0
3602474 1868434 1868434 defendant Potter Beatrice widow 590841 590841 Potter, Beatrice, of Stoke Clare, widow 1
3602476 1868435 1868435 defendant Pottere Robert (legal representative) 590841 590841 Pottere, Robert, of Stoke Clare, yeoman, executrix of 0
3602477 1868435 1868435 defendant Pottere Beatrice widow 590841 590841 Pottere, Beatrice, of Stoke Clare, widow 1
3658119 1912796 1912796 defendant Brewster Thomas, junior husbandman 590841 590841 Brewster, Thomas, junior, of Stoke Clare, husbandman 3
3658120 1912796 1912796 defendant Regewell Thomas husbandman 590841 590841 Regewell, Thomas, of Stoke Clare, husbandman 4
3668184 1915995 1915995 defendant Brewster Thomas husbandman 590841 590841 Brewster, Thomas, of Stoke Clare, husbandman 0
3670727 1916805 1916805 defendant Brewster Thomas husbandman 590841 590841 Brewster, Thomas, of Stoke Clare, husbandman 0
3788810 1954303 1954303 defendant Grene John sherman 590841 590841 Grene, John, of Stoke Clare, sherman 0
3790520 1954858 1954858 defendant Brewster of Alby Thomas yeoman 590841 590841 Brewster of Alby, Thomas, of Stoke Clare, yeoman 0
3843548 1971520 1971520 defendant Freer Joan widow 590841 590841 Freer, Joan, of Stoke Clare, widow 0
3843549 1971520 1971520 defendant Freer William yeoman 590841 590841 Freer, William, of Stoke Clare, yeoman 1
3843552 1971521 1971521 defendant Freer William yeoman 590841 590841 Freer, William, of Stoke Clare, yeoman 0
3843554 1971521 1971521 defendant Freer Joan widow 590841 590841 Freer, Joan, of Stoke Clare, widow 2
3897554 1989394 1989394 defendant Motton alias Salle John chaplain 590841 590841 Motton alias Salle, John, of Stoke Clare, chaplain 3
3902707 1991137 1991137 defendant Tomlynson Robert chapman 590841 590841 Tomlynson, Robert, of Stoke Clare, chapman 1
3907766 1992881 1992881 plaintiff Perle John merchant 590841 590841 Perle, John, of Stoke Clare, merchant 0
3907767 1992881 1992881 defendant Flower John merchant 590841 590841 Flower, John, of Stoke Clare, merchant 0
4284252 2124419 2124419 defendant Deck John yeoman 590841 590841 Deck, John, of Stoke Clare, yeoman 1
4671787 2256822 2256822 defendant Gaste Gilbert husbandman 590841 590841 Gaste, Gilbert, of Stoke Clare, husbandman 2
4711498 2268926 2268926 defendant Boyys alias Boys William yeoman 590841 590841 Boyys alias Boys, William, of Stoke Clare, yeoman 0
4833273 2306417 2306417 defendant bochere William tailor 590841 590841 bochere, William, of Stoke Clare, tailor 0
5271224 2436676 2436676 defendant Grey John butcher 590841 590841 Grey, John, of Stoke Clare, butcher 3
5271641 2436801 2436801 defendant Holden William smith 590841 590841 Holden, William, of Stoke Clare, smith 1
5566497 2524794 2524794 defendant Argent William   590841 590841 Argent, William, of Stoke Clare, "sayer" 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);