names

13 rows where place_id = 802776

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4791110 2293318 2293318 plaintiff Longevyll John esq 802776 802776 Longevyll, John, of Parva Billyng, esq 0
4957296 2344144 2344144 defendant Longevyle George esq 802776 802776 Longevyle, George, of Parva Billyng, esq 0
4957298 2344145 2344145 defendant Longevyle George esq 802776 802776 Longevyle, George, of Parva Billyng, esq 0
4957300 2344146 2344146 defendant Longevyle George esq 802776 802776 Longevyle, George, of Parva Billyng, esq 0
4983657 2352038 2352038 defendant Longevyle George esq 802776 802776 Longevyle, George, of Parva Billyng, esq 0
4983659 2352039 2352039 defendant Longevyle George esq 802776 802776 Longevyle, George, of Parva Billyng, esq 0
4983661 2352040 2352040 defendant Longevyle George esq 802776 802776 Longevyle, George, of Parva Billyng, esq 0
5075276 2379098 2379098 defendant Longvile George esq 802776 802776 Longvile, George, of Parva Billyng, esq 0
5075278 2379099 2379099 defendant Longvile George esq 802776 802776 Longvile, George, of Parva Billyng, esq 0
5098403 2385959 2385959 defendant Longvile George esq 802776 802776 Longvile, George, of Parva Billyng, esq 0
5296041 2443833 2443833 defendant Smyth Richard husbandman 802776 802776 Smyth, Richard, of Parva Billyng, husbandman 0
5571797 2526290 2526290 defendant Fyssher John husbandman 802776 802776 Fyssher, John, of Parva Billyng, husbandman 0
5571798 2526290 2526290 defendant Wellys Richard husbandman 802776 802776 Wellys, Richard, of Parva Billyng, husbandman 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);