names

27 rows where place_id = 844033

✎ 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
3721866 1933108 1933108 defendant Parker William gent 844033 844033 Parker, William, of Drakelowe, Derbs, gent 0
3830364 1967390 1967390 defendant Ardern Nicholas farmer of Scropton 844033 844033 Ardern, Nicholas, of Drakelowe, Derbs, gent, farmer of Scropton 0
4302045 2130837 2130837 defendant Greisley Thomas esq 844033 844033 Greisley, Thomas, of Drakelowe, Derbs, esq 0
4820794 2302584 2302584 defendant Gresley Geoffrey esq 844033 844033 Gresley, Geoffrey, of Drakelowe, Derbs, esq 0
5061493 2375029 2375029 defendant Gresley John esq 844033 844033 Gresley, John, of Drakelowe, Derbs, esq 0
5065685 2376261 2376261 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs 0
5077602 2379797 2379797 defendant Gresley John esq or knight 844033 844033 Gresley, John, of Drakelowe, Derbs, esq or knight 0
5080415 2380631 2380631 defendant Grysseley John   844033 844033 Grysseley, John, of Drakelowe, Derbs, knight 0
5090272 2383529 2383529 defendant Gresley John esq 844033 844033 Gresley, John, of Drakelowe, Derbs, esq 0
5090273 2383530 2383530 defendant Gresley John esq 844033 844033 Gresley, John, of Drakelowe, Derbs, esq 0
5094931 2384929 2384929 defendant Gresley Geoffrey esq 844033 844033 Gresley, Geoffrey, of Drakelowe, Derbs, esq 0
5101731 2386929 2386929 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 0
5101735 2386930 2386930 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 0
5102390 2387103 2387103 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 0
5102394 2387104 2387104 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 0
5107621 2388661 2388661 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 0
5107625 2388662 2388662 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 0
5116111 2391138 2391138 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 3
5122930 2393136 2393136 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 2
5140002 2398178 2398178 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 0
5161013 2404325 2404325 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 0
5196916 2414849 2414849 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 0
5196920 2414850 2414850 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 0
5196924 2414851 2414851 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 0
5349860 2460091 2460091 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 0
5349863 2460092 2460092 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 0
5396305 2474033 2474033 defendant Gresley John   844033 844033 Gresley, John, of Drakelowe, Derbs, knight 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);