names

15 rows where place_id = 789177

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4712015 2269069 2269069 defendant Taillour William husbandman 789177 789177 Taillour, William, of Roclyf, husbandman 0
4758766 2283096 2283096 defendant Potonson William husbandman 789177 789177 Potonson, William, of Roclyf, husbandman 5
4777858 2289064 2289064 defendant Patonson William husbandman 789177 789177 Patonson, William, of Roclyf, husbandman 1
4827764 2304731 2304731 defendant Thurstan John   789177 789177 Thurstan, John, of Roclyf, wright 0
5242444 2428002 2428002 defendant Lightfote Thomas husbandman 789177 789177 Lightfote, Thomas, of Roclyf, husbandman 0
5242445 2428002 2428002 defendant Herrad Richard husbandman 789177 789177 Herrad, Richard, of Roclyf, husbandman 1
5242446 2428002 2428002 defendant Herrad Robert husbandman 789177 789177 Herrad, Robert, of Roclyf, husbandman 2
5242447 2428002 2428002 defendant Belton Robert husbandman 789177 789177 Belton, Robert, of Roclyf, husbandman 3
5242448 2428002 2428002 defendant Belton Richard husbandman 789177 789177 Belton, Richard, of Roclyf, husbandman 4
5242449 2428002 2428002 defendant Hemsam John husbandman 789177 789177 Hemsam, John, of Roclyf, husbandman 5
5242450 2428002 2428002 defendant Whitside John husbandman 789177 789177 Whitside, John, of Roclyf, husbandman 6
5242451 2428002 2428002 defendant Mangall Richard husbandman 789177 789177 Mangall, Richard, of Roclyf, husbandman 7
5242452 2428002 2428002 defendant Kyng William husbandman 789177 789177 Kyng, William, of Roclyf, husbandman 8
5242453 2428002 2428002 defendant Ancas Robert husbandman 789177 789177 Ancas, Robert, of Roclyf, husbandman 9
5242454 2428002 2428002 defendant Toyde Robert husbandman 789177 789177 Toyde, Robert, of Roclyf, husbandman 10

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