names

16 rows where case_id = 2220490

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4564603 2220490 2220490 plaintiff Scruton John clerk   Scruton, John, clerk 0
4564604 2220490 2220490 defendant Mirvell Robert chaplain 757883 757883 Mirvell, Robert, of Allerstan, chaplain 0
4564605 2220490 2220490 defendant _ngle Richard chaplain   _ngle, Richard, chaplain 1
4564606 2220490 2220490 defendant Lorymer Robert chaplain   Lorymer, Robert, chaplain 2
4564607 2220490 2220490 defendant Osteler Adam   769609 769609 Osteler, Adam, of Marton by Grafton 3
4564608 2220490 2220490 defendant (not given) Thomas his son   Thomas, his son 4
4564609 2220490 2220490 defendant A_arton Simon     A_arton, Simon 5
4564610 2220490 2220490 defendant Plomere William   769609 769609 Plomere, William, of Marton by Grafton 6
4564611 2220490 2220490 defendant Wryghtson Thomas   769609 769609 Wryghtson, Thomas, of Marton by Grafton 7
4564612 2220490 2220490 defendant Brytall Thomas   589133 589133 Brytall, Thomas, of Marton 8
4564613 2220490 2220490 defendant Clerk John John, of Marton   Clerk, John, John, of Marton 9
4564614 2220490 2220490 defendant Pokethorp Robert   589133 589133 Pokethorp, Robert, of Marton 10
4564615 2220490 2220490 defendant Wilton Thomas   770092 770092 Wilton, Thomas, of Populton 11
4564616 2220490 2220490 defendant Leget Thomas   770092 770092 Leget, Thomas, of Populton 12
4564617 2220490 2220490 defendant (not given) Robert his brother   Robert, his brother 13
4564618 2220490 2220490 defendant Milner William   770093 770093 Milner, William, of Tanford 14

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);