names

16 rows where place_id = 782756

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4679048 2259054 2259054 defendant Hall John de yeoman 782756 782756 Hall, John de, of Aykton, yeoman 6
4681979 2259980 2259980 defendant Bampton Robert clerk 782756 782756 Bampton, Robert, of Aykton, clerk 1
4704844 2266893 2266893 defendant Smyth John yeoman 782756 782756 together with Smyth, John, of Aykton, yeoman 1
4753529 2281479 2281479 defendant Bakhous Robert de yeoman 782756 782756 Bakhous, Robert de, of Aykton, yeoman 11
4753530 2281479 2281479 defendant Borugh John de yeoman 782756 782756 Borugh, John de, of Aykton, yeoman 12
4820991 2302653 2302653 defendant Aldcorne William, senior yeoman 782756 782756 Aldcorne, William, senior, of Aykton, yeoman 1
4820992 2302653 2302653 defendant Aldcorne William, junior yeoman 782756 782756 Aldcorne, William, junior, of Aykton, yeoman 2
4820993 2302653 2302653 defendant Wilson Richard yeoman 782756 782756 Wilson, Richard, of Aykton, yeoman 3
4820994 2302653 2302653 defendant Boweman John yeoman 782756 782756 Boweman, John, of Aykton, yeoman 4
4821015 2302655 2302655 defendant Wilkynson William yeoman 782756 782756 Wilkynson, William, of Aykton, yeoman 0
4821018 2302655 2302655 defendant Richardson William yeoman 782756 782756 Richardson, William, of Aykton, yeoman 3
4821019 2302655 2302655 defendant Broun Richard yeoman 782756 782756 Broun, Richard, of Aykton, yeoman 4
4821023 2302655 2302655 defendant Clementson John yeoman 782756 782756 Clementson, John, of Aykton, yeoman 8
4865090 2316055 2316055 defendant Watson William husbandman 782756 782756 Watson, William, of Aykton, husbandman 1
5543680 2518132 2518132 defendant Wryght John carpenter 782756 782756 Wryght, John, of Aykton, carpenter 3
5568654 2525383 2525383 defendant Boyn Mathew husbandman 782756 782756 Boyn, Mathew, of Aykton, 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);