names

14 rows where place_id = 764976

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4511861 2204157 2204157 defendant Watters William   764976 764976 Watters, William, of Russhebury 1
4585779 2226973 2226973 defendant Stretton James de   764976 764976 Stretton, James de, of Russhebury 0
4602944 2232137 2232137 defendant (not given) William prior of Waters 764976 764976 Waters, William, of Russhebury, bailiff of the prior of Wenlok of Burton 0
4668753 2255939 2255939 defendant Brome John husbandman 764976 764976 Brome, John, of Russhebury, husbandman 3
4706131 2267294 2267294 defendant Paramour Richard summoner 764976 764976 Paramour, Richard, of Russhebury, summoner 1
4787975 2292306 2292306 defendant Warde William husbandman 764976 764976 Warde, William, of Russhebury, husbandman 1
4787977 2292306 2292306 defendant Paramour Richard yeoman 764976 764976 Paramour, Richard, of Russhebury, yeoman 3
4804799 2297700 2297700 defendant Cheket Thomas husbandman 764976 764976 Cheket, Thomas, of Russhebury, husbandman 2
4841425 2308850 2308850 defendant Brome William yeoman 764976 764976 Brome, William, of Russhebury, yeoman 1
4868950 2317261 2317261 defendant Brome William yeoman 764976 764976 Brome, William, of Russhebury, yeoman 1
4872894 2318475 2318475 defendant Tyler Hugh tiler 764976 764976 Tyler, Hugh, of Russhebury, tiler 1
4925821 2334506 2334506 defendant Hayles William husbandman 764976 764976 Hayles, William, of Russhebury, husbandman 3
4981778 2351468 2351468 plaintiff Taillour Alice (legal representative) 764976 764976 Taillour, Alice, of Russhebury, executor of 0
4981780 2351468 2351468 defendant Brome Joan widow 764976 764976 Brome, Joan, of Russhebury, 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);