names

23 rows where place_id = 850332

✎ 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
5130773 2395489 2395489 defendant Hogeson Miles yeoman 850332 850332 Hogeson, Miles, of Markynfeld, yeoman 0
5130774 2395489 2395489 defendant Hogeson Mathew, junior yeoman 850332 850332 Hogeson, Mathew, junior, of Markynfeld, yeoman 1
5130775 2395489 2395489 defendant Phelip Thomas yeoman 850332 850332 Phelip, Thomas, of Markynfeld, yeoman 2
5130776 2395489 2395489 defendant Falbere John yeoman 850332 850332 Falbere, John, of Markynfeld, yeoman 3
5130777 2395489 2395489 defendant Raskyll John   850332 850332 Raskyll, John, of Markynfeld, groom 4
5130784 2395489 2395489 defendant Markynfeld John esq 850332 850332 with Markynfeld, John, of Markynfeld, esq 11
5130786 2395490 2395490 defendant Hogeson Miles yeoman 850332 850332 Hogeson, Miles, of Markynfeld, yeoman 0
5130787 2395490 2395490 defendant Hogeson Mathew, junior yeoman 850332 850332 Hogeson, Mathew, junior, of Markynfeld, yeoman 1
5130788 2395490 2395490 defendant Phelip Thomas yeoman 850332 850332 Phelip, Thomas, of Markynfeld, yeoman 2
5130789 2395490 2395490 defendant Falbere John yeoman 850332 850332 Falbere, John, of Markynfeld, yeoman 3
5130790 2395490 2395490 defendant Raskyll John   850332 850332 Raskyll, John, of Markynfeld, groom 4
5130797 2395490 2395490 defendant Markynfeld John esq 850332 850332 with Markynfeld, John, of Markynfeld, esq 11
5150195 2401197 2401197 defendant Hogeson Miles yeoman 850332 850332 Hogeson, Miles, of Markynfeld, yeoman 0
5150197 2401197 2401197 defendant Phelip Thomas yeoman 850332 850332 Phelip, Thomas, of Markynfeld, yeoman 2
5150198 2401197 2401197 defendant Falbere John yeoman 850332 850332 Falbere, John, of Markynfeld, yeoman 3
5150199 2401197 2401197 defendant Raskyll John   850332 850332 Raskyll, John, of Markynfeld, groom 4
5150206 2401197 2401197 defendant Markynfeld John esq 850332 850332 together with Markynfeld, John, of Markynfeld, esq 11
5150208 2401198 2401198 defendant Hogeson Miles yeoman 850332 850332 Hogeson, Miles, of Markynfeld, yeoman 0
5150210 2401198 2401198 defendant Phelyp Thomas yeoman 850332 850332 Phelyp, Thomas, of Markynfeld, yeoman 2
5150211 2401198 2401198 defendant Falbere John yeoman 850332 850332 Falbere, John, of Markynfeld, yeoman 3
5150212 2401198 2401198 defendant Raskyll John   850332 850332 Raskyll, John, of Markynfeld, groom 4
5150219 2401198 2401198 defendant Markynfeld John esq 850332 850332 together with Markynfeld, John, of Markynfeld, esq 11
5492921 2502792 2502792 defendant Benson Thomas, junior yeoman 850332 850332 Benson, Thomas, junior, of Markynfeld, 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);