names

15 rows where place_id = 616809

✎ 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
3716261 1931379 1931379 defendant Jenneson William yoeman 616809 616809 Jenneson, William, of Yokflete, yoeman 1
4579871 2225191 2225191 plaintiff Crose William   616809 616809 Crose, William, of Yokflete 0
4767656 2285866 2285866 defendant Best Thomas yeoman 616809 616809 Best, Thomas, of Yokflete, yeoman 10
4792038 2293612 2293612 defendant Best Thomas yeoman 616809 616809 Best, Thomas, of Yokflete, yeoman 12
4883204 2321675 2321675 defendant Sponer John fisher 616809 616809 Sponer, John, of Yokflete, fisher 0
4900489 2326795 2326795 defendant Jakson John husbandman 616809 616809 Jakson, John, of Yokflete, husbandman 1
5115085 2390832 2390832 defendant Gilson John husbandman 616809 616809 Gilson, John, of Yokflete, husbandman 0
5115099 2390836 2390836 defendant Henryson Robert husbandman 616809 616809 Henryson, Robert, of Yokflete, husbandman 0
5132625 2396037 2396037 defendant Jakson Richard husbandman 616809 616809 Jakson, Richard, of Yokflete, husbandman 0
5152458 2401852 2401852 defendant Jakson Richard husbandman 616809 616809 Jakson, Richard, of Yokflete, husbandman 1
5242178 2427912 2427912 defendant Janynson Thomas yeoman 616809 616809 Janynson, Thomas, of Yokflete, yeoman 0
5299413 2444802 2444802 defendant Fransley William husbandman 616809 616809 Fransley, William, of Yokflete, husbandman 2
5428907 2483562 2483562 defendant Jakson Robert husbandman 616809 616809 Jakson, Robert, of Yokflete, husbandman 0
5446110 2488725 2488725 defendant (illegible) Robert husbandman 616809 616809 _, Robert, of Yokflete, husbandman 0
5591093 2532194 2532194 defendant Pilkyngton Edward esq 616809 616809 Pilkyngton, Edward, of Yokflete, esq 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);