names

15 rows where place_id = 779783

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4663972 2250217 2250217 defendant Dam John gent 779783 779783 Dam, John, of Lympenowe, gent 0
4664031 2250237 2250237 defendant Mons or Mous Richard yeoman 779783 779783 Mons or Mous, Richard, of Lympenowe, yeoman 0
4675153 2257842 2257842 defendant Dam John gent 779783 779783 Dam, John, of Lympenowe, gent 0
4682623 2260181 2260181 defendant Davy John   779783 779783 Davy, John, of Lympenowe, franklin 3
4682659 2260191 2260191 defendant Holdernesse Thomas husbandman 779783 779783 Holdernesse, Thomas, of Lympenowe, husbandman 0
4687810 2261758 2261758 defendant Hacon Walter yeoman 779783 779783 Hacon, Walter, of Lympenowe, yeoman 5
4700510 2265574 2265574 defendant Dam John gent 779783 779783 Dam, John, of Lympenowe, gent 0
4768694 2286186 2286186 defendant atte Lee Robert yeoman 779783 779783 atte Lee, Robert, of Lympenowe, yeoman 3
4901181 2326980 2326980 defendant atte Lee William husbandman 779783 779783 atte Lee, William, of Lympenowe, husbandman 10
4928970 2335487 2335487 defendant Lee Robert husbandman 779783 779783 Lee, Robert, of Lympenowe, husbandman 0
4952791 2342792 2342792 plaintiff Rysyng Edmund   779783 779783 Rysyng, Edmund, of Lympenowe 0
4955465 2343598 2343598 defendant Hoberd William smith 779783 779783 Hoberd, William, of Lympenowe, smith 0
5046532 2370602 2370602 defendant Doraunt Robert husbandman 779783 779783 Doraunt, Robert, of Lympenowe, husbandman 2
5268125 2435800 2435800 defendant Chirche William husbandman 779783 779783 Chirche, William, of Lympenowe, husbandman 1
5281718 2439723 2439723 defendant Moore John yeoman 779783 779783 Moore, John, of Lympenowe, yeoman 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);