names

26 rows where place_id = 614524

✎ 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
3704111 1927575 1927575 defendant Palmer John gent 614524 614524 Palmer, John, of Lemyngton, Glos, gent 0
3708681 1929014 1929014 plaintiff Palmer John   614524 614524 Palmer, John, of Lemyngton, Glos 0
3725593 1934296 1934296 defendant Palmer John gent 614524 614524 Palmer, John, of Lemyngton, Glos, gent 0
3758068 1944508 1944508 defendant Palmer John esq 614524 614524 Palmer, John, of Lemyngton, Glos, esq 3
3758518 1944660 1944660 defendant Palmer John gent 614524 614524 Palmer, John, of Lemyngton, Glos, gent 0
3776099 1950268 1950268 plaintiff Palmer John esq 614524 614524 Palmer, John, of Lemyngton, Glos, esq 2
3811681 1961549 1961549 defendant Palmer John gent 614524 614524 Palmer, John, of Lemyngton, Glos, gent 0
3816959 1963210 1963210 defendant Palmer John esq 614524 614524 Palmer, John, of Lemyngton, Glos, esq 0
3817882 1963509 1963509 defendant Palmer John esq 614524 614524 Palmer, John, of Lemyngton, Glos, esq 0
3837387 1969603 1969603 defendant Dey Richard husbandman 614524 614524 Dey, Richard, of Lemyngton, Glos, husbandman 3
3839051 1970139 1970139 defendant Norwoode Thomas gent 614524 614524 Norwoode, Thomas, of Lemyngton, Glos, gent 1
3853621 1974760 1974760 defendant Palmer John esq 614524 614524 Palmer, John, of Lemyngton, Glos, esq 0
3855769 1975436 1975436 defendant Palmer John gent 614524 614524 Palmer, John, of Lemyngton, Glos, gent 0
3869796 1980141 1980141 defendant Palmer John gent 614524 614524 Palmer, John, of Lemyngton, Glos, gent 0
3873684 1981414 1981414 defendant Palmer John gent 614524 614524 Palmer, John, of Lemyngton, Glos, gent 0
3873686 1981415 1981415 defendant Palmer John gent 614524 614524 Palmer, John, of Lemyngton, Glos, gent 0
3889029 1986570 1986570 defendant Palmer John esq 614524 614524 Palmer, John, of Lemyngton, Glos, esq 0
3904627 1991801 1991801 defendant Palmer John esq 614524 614524 Palmer, John, of Lemyngton, Glos, esq 0
3921114 1997413 1997413 defendant Palmer William esq 614524 614524 Palmer, William, of Lemyngton, Glos, esq 0
3921117 1997414 1997414 defendant Palmer William gent 614524 614524 Palmer, William, of Lemyngton, Glos, gent 0
3921439 1997513 1997513 defendant Dey Thomas husbandman 614524 614524 Dey, Thomas, of Lemyngton, Glos, husbandman 1
4002881 2025799 2025799 defendant Palmer William esq 614524 614524 Palmer, William, of Lemyngton, Glos, esq 0
4026021 2033952 2033952 defendant Palmer William esq 614524 614524 Palmer, William, of Lemyngton, Glos, esq 0
4026080 2033975 2033975 defendant Palmer William esq 614524 614524 Palmer, William, of Lemyngton, Glos, esq 0
4160410 2081716 2081716 defendant Palmer John gent 614524 614524 Palmer, John, of Lemyngton, Glos, gent 1
4779802 2289678 2289678 defendant Bygge William husbandman 614524 614524 Bygge, William, of Lemyngton, Glos, husbandman 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);