names

14 rows where place_id = 753614

✎ 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
4414667 2169486 2169486 defendant Hereward Richard   753614 753614 Hereward, Richard, of Wylyngdon 0
4422465 2171883 2171883 defendant Hereward Richard   753614 753614 Hereward, Richard, of Wylyngdon 0
4561695 2219594 2219594 defendant atte Nore Thomas   753614 753614 atte Nore, Thomas, of Wylyngdon 0
4702559 2266212 2266212 defendant Rakkele Richard husbandman 753614 753614 Rakkele, Richard, of Wylyngdon, husbandman 0
4732951 2275484 2275484 defendant Cheseman William laborer 753614 753614 Cheseman, William, of Wylyngdon, laborer 0
4737761 2276915 2276915 defendant Grenhill John husbandman 753614 753614 Grenhill, John, of Wylyngdon, husbandman 0
4771558 2287081 2287081 defendant Ponte William husbandman 753614 753614 Ponte, William, of Wylyngdon, husbandman 0
4796621 2295093 2295093 defendant Ponte William husbandman 753614 753614 Ponte, William, of Wylyngdon, husbandman 0
4796684 2295114 2295114 defendant Venell Simon husbandman 753614 753614 Venell, Simon, of Wylyngdon, husbandman 0
4844466 2309784 2309784 defendant Prymyng John laborer 753614 753614 Prymyng, John, of Wylyngdon, laborer 0
4871332 2318001 2318001 defendant Fenel Simon husbandman 753614 753614 Fenel, Simon, of Wylyngdon, husbandman 0
4871333 2318001 2318001 defendant Fenel Robert husbandman 753614 753614 Fenel, Robert, of Wylyngdon, husbandman 1
5628506 2552886 2552886 plaintiff Piers Simon   753614 753614 Piers, Simon, of Wylyngdon 0
5628507 2552886 2552886 defendant Piers John   753614 753614 Piers, John, of Wylyngdon, shepherd 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);