names

11 rows where place_id = 725185

✎ 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
4259898 2116281 2116281 defendant Dyneley Henry gent 725185 725185 Dyneley, Henry, of Hanley Castle, gent 0
4360904 2151071 2151071 defendant Hudson Peter woodman 725185 725185 Hudson, Peter, of Hanley Castle, woodman 0
4369306 2154085 2154085 defendant Jeffres Henry (legal representative) 725185 725185 Jeffres, Henry, of Hanley Castle, gent, executor of 0
4372848 2155368 2155368 defendant Frewen Francis yeoman 725185 725185 Frewen, Francis, of Hanley Castle, yeoman 0
4384807 2159606 2159606 defendant Teale Thomas yeoman 725185 725185 Teale, Thomas, of Hanley Castle, yeoman 0
4400997 2164923 2164923 defendant Frewen Francis yeoman 725185 725185 Frewen, Francis, of Hanley Castle, yeoman 0
4400999 2164924 2164924 defendant Lawghton Roger yeoman 725185 725185 Lawghton, Roger, of Hanley Castle, yeoman 0
4401001 2164925 2164925 defendant Gubbyns Elizabeth widow 725185 725185 Gubbyns, Elizabeth, of Hanley Castle, widow 0
4401003 2164926 2164926 defendant Kenrick Anthony yeoman 725185 725185 Kenrick, Anthony, of Hanley Castle, yeoman 0
4401005 2164927 2164927 defendant Barnes Richard yeoman 725185 725185 Barnes, Richard, of Hanley Castle, yeoman 0
4409624 2167816 2167816 defendant Madockes Margaret widow 725185 725185 Madockes, Margaret, of Hanley Castle, widow 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);