names

12 rows where place_id = 773075

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4596464 2230141 2230141 defendant Mason John mercer 773075 773075 Mason, John, of Preston in Aundernesse, mercer 2
4617413 2236458 2236458 defendant Broun William   773075 773075 Broun, William, of Preston in Aundernesse 1
4871650 2318099 2318099 defendant Blundell Edward yeoman 773075 773075 Blundell, Edward, of Preston in Aundernesse, yeoman 2
4871651 2318099 2318099 defendant Cardemaker William, junior   773075 773075 Cardemaker, William, junior, of Preston in Aundernesse, card maker 3
4871652 2318099 2318099 defendant de Croke Roger laborer 773075 773075 de Croke, Roger, of Preston in Aundernesse, laborer 4
4871653 2318099 2318099 defendant de Croke William laborer 773075 773075 de Croke, William, of Preston in Aundernesse, laborer 5
4871654 2318099 2318099 defendant de Croke John laborer 773075 773075 de Croke, John, of Preston in Aundernesse, laborer 6
4871655 2318099 2318099 defendant de Horneby Robert yeoman 773075 773075 de Horneby, Robert, of Preston in Aundernesse, yeoman 7
4871660 2318099 2318099 defendant Taillour John husbandman 773075 773075 Taillour, John, of Preston in Aundernesse, husbandman 12
4871661 2318099 2318099 defendant Taillour Henry laborer 773075 773075 Taillour, Henry, of Preston in Aundernesse, laborer 13
4871662 2318099 2318099 defendant Woderofe John clerk 773075 773075 Woderofe, John, of Preston in Aundernesse, clerk 14
5618234 2549518 2549518 defendant Miles Nicholas   773075 773075 Miles, Nicholas, of Preston in Aundernesse 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);