names

15 rows where place_id = 782093

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4673469 2257340 2257340 defendant Moot Thomas   782093 782093 Moot, Thomas, of Coventre, Warws, wire drawer 0
4675817 2258046 2258046 defendant Lukenore John butcher 782093 782093 Lukenore, John, of Coventre, Warws, butcher 0
4676930 2258402 2258402 defendant Motleymaker John draper 782093 782093 Motleymaker, John, of Coventre, Warws, draper 1
4680599 2259541 2259541 defendant Joykyn William chapman 782093 782093 Joykyn, William, of Coventre, Warws, chapman 0
4681279 2259770 2259770 defendant Leukenore John butcher 782093 782093 Leukenore, John, of Coventre, Warws, butcher 1
4683153 2260347 2260347 defendant Payn David skinner 782093 782093 Payn, David, of Coventre, Warws, skinner 0
4683179 2260355 2260355 defendant Essex John dyer 782093 782093 Essex, John, of Coventre, Warws, dyer 2
4683961 2260596 2260596 defendant Sturdy John   782093 782093 Sturdy, John, of Coventre, Warws, apothecary 0
4684236 2260674 2260674 defendant Egremond William chapman & of Stowe St Edward 782093 782093 Egremond, William, of Coventre, Warws, chapman & of Stowe St Edward 0
4686509 2261388 2261388 defendant Brewester Richard brewer 782093 782093 Brewester, Richard, of Coventre, Warws, brewer 1
4687535 2261691 2261691 defendant Porttour Alice widow 782093 782093 (Porttour, Alice, of Coventre, Warws, widow 4
4687542 2261692 2261692 defendant Proctour Alice widow 782093 782093 (Proctour, Alice, of Coventre, Warws, widow 4
4689513 2262277 2262277 defendant Shepley John gent & son of Robert Shepley 782093 782093 Shepley, John, of Coventre, Warws, gent & son of Robert Shepley 0
4690860 2262673 2262673 defendant Glym William clerk 782093 782093 Glym, William, of Coventre, Warws, clerk 0
4746787 2279560 2279560 defendant Routon John doubber or repairer of old clothes or binder of manuscripts or books 782093 782093 Routon, John, of Coventre, Warws, doubber or repairer of old clothes or binder of manuscripts or books 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);