names

15 rows where place_id = 612489

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3693535 1924182 1924182 defendant Walton Robert draper 612489 612489 Walton, Robert, of Pountfret, Yorks, draper 1
3814065 1962301 1962301 defendant Chyld Gilbert yeoman 612489 612489 Chyld, Gilbert, of Pountfret, Yorks, yeoman 2
3814076 1962303 1962303 defendant Atkynson John yeoman 612489 612489 Atkynson, John, of Pountfret, Yorks, yeoman 1
3830394 1967395 1967395 defendant Gregson Robert merchant 612489 612489 Gregson, Robert, of Pountfret, Yorks, merchant 1
3837698 1969703 1969703 defendant Wakefeld Peter chapman 612489 612489 Wakefeld, Peter, of Pountfret, Yorks, chapman 1
4745373 2279156 2279156 defendant Castellayn William dyer 612489 612489 Castellayn, William, of Pountfret, Yorks, dyer 0
4889989 2323653 2323653 defendant Ryssheworth John gent 612489 612489 Ryssheworth, John, of Pountfret, Yorks, gent 4
4894306 2324903 2324903 defendant Rysshworth John gent 612489 612489 Rysshworth, John, of Pountfret, Yorks, gent 1
4906992 2328762 2328762 defendant Rysshworth John gent 612489 612489 Rysshworth, John, of Pountfret, Yorks, gent 4
4907315 2328853 2328853 defendant Bubbewith John gent 612489 612489 Bubbewith, John, of Pountfret, Yorks, gent 1
4949201 2341738 2341738 defendant Still John husbandman 612489 612489 Still, John, of Pountfret, Yorks, husbandman 0
4949207 2341739 2341739 defendant Stoke John husbandman 612489 612489 Stoke, John, of Pountfret, Yorks, husbandman 0
4978757 2350596 2350596 defendant Huchonson Roger chapman 612489 612489 Huchonson, Roger, of Pountfret, Yorks, chapman 0
5507240 2507165 2507165 defendant Jacson Richard yeoman 612489 612489 Jacson, Richard, of Pountfret, Yorks, yeoman 11
5538557 2516538 2516538 defendant Whyte Richard chapman 612489 612489 Whyte, Richard, of Pountfret, Yorks, chapman 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);