names

16 rows where place_id = 757751

✎ 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
4448425 2184438 2184438 defendant Shepherde Richard   757751 757751 Shepherde, Richard, of Hamptonet 0
4464131 2189451 2189451 defendant atte Hasele Robert   757751 757751 atte Hasele, Robert, of Hamptonet 4
4595153 2229738 2229738 defendant Pursere John   757751 757751 Pursere, John, of Hamptonet 1
4696328 2264333 2264333 defendant Lordyng Bertram laborer 757751 757751 Lordyng, Bertram, of Hamptonet, laborer 4
4761230 2283860 2283860 defendant Dalle Robert husbandman 757751 757751 Dalle, Robert, of Hamptonet, husbandman 2
4814194 2300545 2300545 defendant Tank Robert esq 757751 757751 Tank, Robert, of Hamptonet, esq 0
4851885 2312024 2312024 defendant Tank or Tauk Robert esq 757751 757751 Tank or Tauk, Robert, of Hamptonet, esq 0
4879911 2320631 2320631 defendant Tank or Tauk Robert esq 757751 757751 Tank or Tauk, Robert, of Hamptonet, esq 0
4891744 2324161 2324161 defendant Tanke or Tauke Robert esq 757751 757751 Tanke or Tauke, Robert, of Hamptonet, esq 0
4907162 2328803 2328803 defendant Purser William laborer 757751 757751 Purser, William, of Hamptonet, laborer 0
4927191 2334938 2334938 defendant atte Fanne Thomas, junior husbandman 757751 757751 atte Fanne, Thomas, junior, of Hamptonet, husbandman 0
4928406 2335306 2335306 plaintiff Smale Robert   757751 757751 Smale, Robert, of Hamptonet, vicar 0
4928954 2335481 2335481 defendant Taweke Robert gent 757751 757751 Taweke, Robert, of Hamptonet, gent 0
4992077 2354521 2354521 defendant Puryer Thomas husbandman 757751 757751 Puryer, Thomas, of Hamptonet, husbandman 1
5005557 2358525 2358525 defendant Rose Thomas, sen husbandman 757751 757751 Rose, Thomas, sen, of Hamptonet, husbandman 0
5060091 2374585 2374585 defendant Tanke or Tauke Edward gent 757751 757751 Tanke or Tauke, Edward, of Hamptonet, gent 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);