names

22 rows where place_id = 614008

✎ 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
3701425 1926691 1926691 defendant Bettys William chaplain 614008 614008 Bettys, William, of Snoryng Magna, chaplain 4
3702162 1926934 1926934 plaintiff Carsey William   614008 614008 Carsey, William, of Snoryng Magna 0
3702165 1926935 1926935 plaintiff Carsey William   614008 614008 Carsey, William, of Snoryng Magna 0
3750754 1942157 1942157 defendant Hylake Thomas husbandman 614008 614008 Hylake, Thomas, of Snoryng Magna, husbandman 1
3762994 1946056 1946056 defendant Coo William husbandman 614008 614008 Coo, William, of Snoryng Magna, husbandman 0
3764262 1946481 1946481 defendant Somptour Roger husbandman 614008 614008 Somptour, Roger, of Snoryng Magna, husbandman 1
3788420 1954178 1954178 plaintiff Somor John   614008 614008 Somor, John, of Snoryng Magna 0
3819587 1964002 1964002 defendant Coo William yeoman 614008 614008 Coo, William, of Snoryng Magna, yeoman 1
3924981 1998671 1998671 defendant Heyllok Richard husbandman 614008 614008 Heyllok, Richard, of Snoryng Magna, husbandman 0
3924982 1998671 1998671 defendant Marton John laborer 614008 614008 Marton, John, of Snoryng Magna, laborer 1
3924983 1998671 1998671 defendant Crispe Walter   614008 614008 Crispe, Walter, of Snoryng Magna, shepherd 2
4041165 2039331 2039331 defendant Lyghtfot Thomas husbandman 614008 614008 Lyghtfot, Thomas, of Snoryng Magna, husbandman 0
4041166 2039331 2039331 defendant Hubberd Robert yeoman 614008 614008 Hubberd, Robert, of Snoryng Magna, yeoman 1
4076124 2051748 2051748 defendant Lyghtfote Thomas yeoman 614008 614008 Lyghtfote, Thomas, of Snoryng Magna, yeoman 0
4076128 2051749 2051749 defendant Hobert Robert yeoman 614008 614008 Hobert, Robert, of Snoryng Magna, yeoman 0
4076132 2051750 2051750 defendant Hobert Robert yeoman 614008 614008 Hobert, Robert, of Snoryng Magna, yeoman 0
4076136 2051751 2051751 defendant Lyghtfote Thomas yeoman 614008 614008 Lyghtfote, Thomas, of Snoryng Magna, yeoman 0
4088286 2056104 2056104 defendant Adams Thomas husbandman 614008 614008 Adams, Thomas, of Snoryng Magna, husbandman 0
4387389 2160427 2160427 defendant Warnes Simon yeoman 614008 614008 Warnes, Simon, of Snoryng Magna, yeoman 0
4387390 2160427 2160427 defendant Newton Simon yeoman 614008 614008 Newton, Simon, of Snoryng Magna, yeoman 1
4387391 2160427 2160427 defendant Webb Thomas yeoman 614008 614008 Webb, Thomas, of Snoryng Magna, yeoman 2
4412737 2168853 2168853 defendant Sowthowes John gent 614008 614008 Sowthowes, John, of Snoryng Magna, 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);