names

19 rows where place_id = 628252

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3781336 1951905 1951905 defendant Calverley Robert gent 628252 628252 Calverley, Robert, of Otlay, gent 0
4160413 2081717 2081717 defendant Parker Henry yeoman 628252 628252 Parker, Henry, of Otlay, yeoman 1
4410748 2168185 2168185 defendant Parker Richard chapman 628252 628252 Parker, Richard, of Otlay, chapman 3
4450571 2185140 2185140 defendant Adamson John   628252 628252 Adamson, John, of Otlay 0
4564500 2220461 2220461 defendant Bysshop Thomas   628252 628252 Bysshop, Thomas, of Otlay 2
4588095 2227675 2227675 defendant Beeston Thomas de   628252 628252 Beeston, Thomas de, of Otlay 0
4688208 2261879 2261879 defendant Pycard John yeoman 628252 628252 Pycard, John, of Otlay, yeoman 0
4887589 2322959 2322959 defendant Gren Richard ostler 628252 628252 Gren, Richard, of Otlay, ostler 0
4887590 2322959 2322959 defendant Gren John husbandman 628252 628252 Gren, John, of Otlay, husbandman 1
4887591 2322959 2322959 defendant Gren Walter yeoman 628252 628252 Gren, Walter, of Otlay, yeoman 2
4887592 2322959 2322959 defendant Gren Robert chaplain 628252 628252 Gren, Robert, of Otlay, chaplain 3
4887593 2322959 2322959 defendant Gren William   628252 628252 Gren, William, of Otlay, servant 4
4887594 2322959 2322959 defendant Gren Thomas laborer 628252 628252 Gren, Thomas, of Otlay, laborer 5
4887595 2322959 2322959 defendant Chapman James clerk 628252 628252 Chapman, James, of Otlay, clerk 6
4887596 2322959 2322959 defendant Hogeson William laborer 628252 628252 Hogeson, William, of Otlay, laborer 7
4887597 2322959 2322959 defendant Tercar John weaver 628252 628252 Tercar, John, of Otlay, weaver 8
4887598 2322959 2322959 defendant Yercar Thomas, junior weaver 628252 628252 Yercar, Thomas, junior, of Otlay, weaver 9
4973746 2349102 2349102 defendant Pakok Richard chaplain 628252 628252 Pakok, Richard, of Otlay, chaplain 0
5123731 2393401 2393401 defendant Banke John yeoman 628252 628252 Banke, John, of Otlay, 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);