names

13 rows where place_id = 680932

✎ 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
3640208 1907377 1907377 defendant Halsall Henry   680932 680932 Halsall, Henry, of Halsall, Lancs, knight 0
3829536 1967126 1967126 defendant Halsall Thomas   680932 680932 Halsall, Thomas, of Halsall, Lancs, knight 0
3879410 1983366 1983366 defendant Halsall Thomas   680932 680932 Halsall, Thomas, of Halsall, Lancs, knight 0
3879414 1983367 1983367 defendant Halsall Thomas   680932 680932 Halsall, Thomas, of Halsall, Lancs, knight 0
4037169 2037954 2037954 defendant (not given) George vicar of hesketh 680932 680932 hesketh, George, of Halsall, Lancs, clerk, vicar of Burcestre 0
4037171 2037955 2037955 defendant (not given) George vicar of Hesketh 680932 680932 Hesketh, George, of Halsall, Lancs, clerk, vicar of Burcestre 0
4042754 2039882 2039882 defendant Halsall Edward gent 680932 680932 Halsall, Edward, of Halsall, Lancs, gent 3
4045655 2040898 2040898 defendant Hesketh George clerk 680932 680932 Hesketh, George, of Halsall, Lancs, or of Burcetter, Oxon, clerk 0
4305239 2131970 2131970 defendant Halsall Richard gent 680932 680932 Halsall, Richard, of Halsall, Lancs, clerk, or of Grays Inn, Middx, gent 0
4317430 2136212 2136212 defendant Mawdesley James husbandman 680932 680932 Mawdesley, James, of Halsall, Lancs, husbandman 0
4740673 2277791 2277791 defendant Halsall Henry clerk & archdeacon of Chester 680932 680932 Halsall, Henry, of Halsall, Lancs, clerk & archdeacon of Chester 0
4740678 2277792 2277792 defendant Halsall Henry clerk & archdeadon of Chester 680932 680932 Halsall, Henry, of Halsall, Lancs, clerk & archdeadon of Chester 0
4757323 2282662 2282662 defendant Halsall Robert esq 680932 680932 (Halsall, Robert, of Halsall, Lancs, esq 5

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