names

15 rows where place_id = 644084

✎ 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
3877656 1982769 1982769 defendant Mason Richard husbandman 644084 644084 Mason, Richard, of Metheryngham, husbandman 0
4118843 2067023 2067023 defendant Goldynge Ralph laborer 644084 644084 Goldynge, Ralph, of Metheryngham, laborer 0
4136057 2073237 2073237 defendant Tyndall Henry yeoman 644084 644084 Tyndall, Henry, of Metheryngham, yeoman 0
4173803 2086292 2086292 defendant Wymbyshe James gent 644084 644084 Wymbyshe, James, of Metheryngham, gent 3
4421292 2171556 2171556 plaintiff Cochour Henry   644084 644084 Cochour, Henry, of Metheryngham 0
4421293 2171556 2171556 defendant atte Kirke Robert   644084 644084 atte Kirke, Robert, of Metheryngham, son of William 0
4494715 2199042 2199042 plaintiff Bret John   644084 644084 Bret, John, of Metheryngham 0
4494717 2199042 2199042 defendant Dobbe Henry   644084 644084 Dobbe, Henry, of Metheryngham 1
4494719 2199043 2199043 plaintiff Bret John   644084 644084 Bret, John, of Metheryngham 0
4494720 2199043 2199043 defendant Mason John   644084 644084 Mason, John, of Metheryngham 0
4510694 2203802 2203802 defendant Bret John   644084 644084 Bret, John, of Metheryngham 0
4544434 2214170 2214170 defendant Wright John   644084 644084 Wright, John, of Metheryngham 0
4544438 2214172 2214172 defendant Wryght John   644084 644084 Wryght, John, of Metheryngham 0
4769639 2286481 2286481 defendant Rydoute Nicholas husbandman 644084 644084 Rydoute, Nicholas, of Metheryngham, husbandman 0
5614384 2548291 2548291 defendant Machon Henry de   644084 644084 Machon, Henry de, of Metheryngham 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);