names

12 rows where place_id = 788427

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4421976 2171751 2171751 defendant Blount John le   788427 788427 Blount, John le, of Arnyngton, bailiff 0
4707817 2267814 2267814 plaintiff Morell John   788427 788427 Morell, John, of Arnyngton 0
4796725 2295129 2295129 defendant Terry Roger laborer 788427 788427 Terry, Roger, of Arnyngton, laborer 0
4837329 2307617 2307617 defendant Thormundby John   788427 788427 Thormundby, John, of Arnyngton 1
4866811 2316583 2316583 defendant Fuller Walter husbandman 788427 788427 Fuller, Walter, of Arnyngton, husbandman 2
4921187 2333143 2333143 defendant Colynge William husbandman 788427 788427 Colynge, William, of Arnyngton, husbandman 1
4954224 2343235 2343235 defendant Semer John husbandman 788427 788427 Semer, John, of Arnyngton, husbandman 3
5253735 2431282 2431282 defendant Morell William gent 788427 788427 Morell, William, of Arnyngton, gent 0
5346820 2459163 2459163 defendant Mares Robert clerk 788427 788427 Mares, Robert, of Arnyngton, clerk 1
5422275 2481611 2481611 defendant Gosselyn Henry yeoman 788427 788427 Gosselyn, Henry, of Arnyngton, yeoman 1
5441886 2487502 2487502 defendant Gosselyn Henry yeoman 788427 788427 Gosselyn, Henry, of Arnyngton, yeoman 1
5441893 2487504 2487504 defendant Gosselyn Henry yeoman 788427 788427 Gosselyn, Henry, of Arnyngton, yeoman 1

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);