names

10 rows where place_id = 593056

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610231 1870864 1870864 defendant Eyre Thomas gent 593056 593056 Eyre, Thomas, of Padley, gent 5
3782350 1952233 1952233 defendant Eyre Arthur esq 593056 593056 Eyre, Arthur, of Padley, esq 0
4218266 2101886 2101886 defendant Dakyn Richard yeoman 593056 593056 Dakyn, Richard, of Padley, yeoman 18
4317815 2136342 2136342 defendant Dakyn Richard yeoman 593056 593056 Dakyn, Richard, of Padley, yeoman 0
4404996 2166242 2166242 defendant Naylor John smelter 593056 593056 Naylor, John, of Padley, smelter 0
4777769 2289041 2289041 defendant Eyre Robert gent 593056 593056 Eyre, Robert, of Padley, gent 0
5131825 2395793 2395793 defendant Eyre Robert esq 593056 593056 Eyre, Robert, of Padley, Derbs, junior, esq 1
5131829 2395794 2395794 defendant Eyre Robert esq 593056 593056 Eyre, Robert, of Padley, Derbs, junior, esq 1
5579399 2528636 2528636 defendant Eyre Elizabeth widow 593056 593056 (Eyre, Elizabeth, of Padley, widow 1
5579400 2528636 2528636 defendant Eyre John gent 593056 593056 Eyre, John, of Padley, gent 2

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