names

19 rows where place_id = 617982

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3722188 1933198 1933198 defendant Mason William chapman 617982 617982 Mason, William, of Resham, chapman 2
3747435 1941112 1941112 defendant Burre George pedder 617982 617982 Burre, George, of Resham, pedder 0
3747716 1941206 1941206 defendant Brady John chaplain 617982 617982 Brady, John, of Resham, chaplain 0
3883050 1984597 1984597 defendant Harvy Nicholas husbandman 617982 617982 Harvy, Nicholas, of Resham, husbandman 3
3912194 1994406 1994406 defendant Seman Thomas yeoman 617982 617982 Seman, Thomas, of Resham, yeoman 0
4488171 2197016 2197016 defendant Hannay William   617982 617982 Hannay, William, of Resham 0
4524649 2208045 2208045 defendant Hannay John   617982 617982 Hannay, John, of Resham 1
4671138 2256638 2256638 defendant Smyth Godfrey husbandman 617982 617982 Smyth, Godfrey, of Resham, husbandman 0
4919829 2332708 2332708 defendant Burre John, senior pedder 617982 617982 Burre, John, senior, of Resham, pedder 2
4923639 2333829 2333829 defendant Burre John pedder 617982 617982 Burre, John, of Resham, pedder 2
5249626 2430009 2430009 defendant Twytney John (legal representative) 617982 617982 Twytney, John, of Resham, mason, administratrix of 2
5249627 2430009 2430009 defendant Twytney Margaret widow 617982 617982 Twytney, Margaret, of Resham, widow 3
5518750 2510700 2510700 defendant Grene William carpenter 617982 617982 Grene, William, of Resham, carpenter 1
5553754 2521134 2521134 defendant Fyssher John husbandman 617982 617982 Fyssher, John, of Resham, husbandman 0
5553756 2521134 2521134 defendant Taillour William husbandman 617982 617982 Taillour, William, of Resham, husbandman 2
5553757 2521134 2521134 defendant Goodsonne Henry husbandman 617982 617982 Goodsonne, Henry, of Resham, husbandman 3
5559042 2522604 2522604 defendant Carter Robert turner 617982 617982 Carter, Robert, of Resham, turner 0
5560960 2523175 2523175 defendant Sougate John husbandman 617982 617982 Sougate, John, of Resham, husbandman 0
5622351 2550911 2550911 plaintiff Usflet Robert de   617982 617982 Usflet, Robert de, of Resham, parson 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);