names

18 rows where place_id = 767412

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4539104 2212498 2212498 defendant Fyssher John   767412 767412 Fyssher, John, of Sleddale 11
4539105 2212498 2212498 defendant Donethwayt William de   767412 767412 Donethwayt, William de, of Sleddale 12
4539106 2212498 2212498 defendant Benetson William   767412 767412 Benetson, William, of Sleddale 13
4674457 2257620 2257620 defendant Henryson John yeoman 767412 767412 Henryson, John, of Sleddale, yeoman 3
4687768 2261745 2261745 defendant Tomson John husbandman 767412 767412 Tomson, John, of Sleddale, husbandman 3
4763119 2284445 2284445 defendant Jonson Thomlynson Nicholas husbandman 767412 767412 Jonson Thomlynson, Nicholas, of Sleddale, husbandman 0
4784506 2291158 2291158 defendant Gibson Robert yeoman 767412 767412 Gibson, Robert, of Sleddale, yeoman 2
4857883 2313831 2313831 defendant Thomson Robert yeoman 767412 767412 Thomson, Robert, of Sleddale, yeoman 1
4993284 2354865 2354865 defendant Layburn Robert gent 767412 767412 (Layburn, Robert, of Sleddale, gent 2
4995158 2355403 2355403 defendant Tod William yeoman 767412 767412 Tod, William, of Sleddale, yeoman 3
4995159 2355403 2355403 defendant Told John yeoman 767412 767412 Told, John, of Sleddale, yeoman 4
5003280 2357858 2357858 defendant Todde Robert yeoman 767412 767412 Todde, Robert, of Sleddale, yeoman 0
5003284 2357858 2357858 defendant Benetson Roger yeoman 767412 767412 Benetson, Roger, of Sleddale, yeoman 4
5003285 2357858 2357858 defendant Lekkerra John yeoman 767412 767412 Lekkerra, John, of Sleddale, yeoman 5
5003287 2357859 2357859 defendant Todde Robert yeoman 767412 767412 Todde, Robert, of Sleddale, yeoman 0
5003291 2357859 2357859 defendant Benetson Roger yeoman 767412 767412 Benetson, Roger, of Sleddale, yeoman 4
5003292 2357859 2357859 defendant Lekkerra John yeoman 767412 767412 Lekkerra, John, of Sleddale, yeoman 5
5232400 2425046 2425046 defendant Gilpyn William gent 767412 767412 Gilpyn, William, of Sleddale, 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);