names

17 rows where place_id = 617231

✎ 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
3718478 1932058 1932058 defendant Newell William husbandman 617231 617231 Newell, William, of Plasshe, husbandman 0
3833415 1968378 1968378 plaintiff Leighton William (legal representative) 617231 617231 Leighton, William, of Plasshe, esq, executors of 0
3905753 1992201 1992201 defendant Walwyn Richard esq 617231 617231 (Walwyn, Richard, of Plasshe, esq 1
4105244 2062153 2062153 defendant Cocke Francis yeoman 617231 617231 Cocke, Francis, of Plasshe, yeoman 0
4471160 2191639 2191639 defendant Spaldyng William chapman 617231 617231 Spaldyng, William, of Plasshe, chapman 0
4481261 2194824 2194824 defendant del Pultrys William   617231 617231 del Pultrys, William, of Plasshe 0
4584329 2226508 2226508 defendant Tassell William   617231 617231 Tassell, William, of Plasshe 1
4632922 2241168 2241168 defendant Saycok John   617231 617231 Saycok, John, of Plasshe 1
4639038 2242933 2242933 defendant Blach Robert   617231 617231 Blach, Robert, of Plasshe 1
4865536 2316183 2316183 defendant Squyer William laborer 617231 617231 Squyer, William, of Plasshe, laborer 4
4881166 2321017 2321017 defendant Rednaill Thomas chapman 617231 617231 Rednaill, Thomas, of Plasshe, chapman 3
4881167 2321017 2321017 defendant Bataill John husbandman 617231 617231 Bataill, John, of Plasshe, husbandman 4
5399521 2474943 2474943 defendant Prowe John husbandman 617231 617231 Prowe, John, of Plasshe, husbandman 0
5427351 2483125 2483125 defendant Prowe John husbandman 617231 617231 Prowe, John, of Plasshe, husbandman 0
5573683 2526866 2526866 defendant Leyghton William esq 617231 617231 Leyghton, William, of Plasshe, esq 0
5575519 2527435 2527435 defendant Leighton William gent 617231 617231 Leighton, William, of Plasshe, gent 5
5575532 2527437 2527437 defendant Leighton William gent 617231 617231 Leighton, William, of Plasshe, gent 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);