names

11 rows where place_id = 627946

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3779406 1951281 1951281 defendant Sydwey Thomas mercer 627946 627946 Sydwey, Thomas, of Asshebourne, Derbs, mercer 0
4526306 2208516 2208516 defendant Swynestowe Henry   627946 627946 Swynestowe, Henry, of Asshebourne, Derbs 0
4526320 2208519 2208519 defendant Swynestowe Henry   627946 627946 Swynestowe, Henry, of Asshebourne, Derbs 0
4576752 2224237 2224237 defendant Bretoner William   627946 627946 Bretoner, William, of Asshebourne, Derbs 6
4724399 2272927 2272927 defendant Strynger Richard yeoman 627946 627946 Strynger, Richard, of Asshebourne, Derbs, yeoman 1
4766001 2285358 2285358 defendant Cokayn John   627946 627946 Cokayn, John, of Asshebourne, Derbs, knight 2
5115963 2391097 2391097 defendant Vernon John esq 627946 627946 Vernon, John, of Asshebourne, Derbs, esq 0
5161492 2404460 2404460 defendant Vernon John esq 627946 627946 Vernon, John, of Asshebourne, Derbs, esq 0
5192897 2413646 2413646 defendant Vernon John esq 627946 627946 Vernon, John, of Asshebourne, Derbs, esq 0
5207914 2418046 2418046 defendant Vernon John esq 627946 627946 Vernon, John, of Asshebourne, Derbs, esq 0
5310676 2448230 2448230 defendant Parfay Robert yeoman 627946 627946 Parfay, Robert, of Asshebourne, Derbs, yeoman 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);