names

15 rows where place_id = 763156

✎ 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
4494694 2199035 2199035 defendant Gobyon William   763156 763156 Gobyon, William, of Langedon 0
4494697 2199036 2199036 defendant Gobyoun William   763156 763156 Gobyoun, William, of Langedon 1
4502839 2201463 2201463 defendant Stabler John   763156 763156 Stabler, John, of Langedon 1
4522741 2207449 2207449 plaintiff Gylle Richard   763156 763156 Gylle, Richard, of Langedon 0
4578310 2224710 2224710 plaintiff Clay Richard   763156 763156 Clay, Richard, of Langedon 0
4578311 2224710 2224710 plaintiff Clay Alice   763156 763156 Clay, Alice, of Langedon 1
4578312 2224710 2224710 plaintiff Clay Lucy   763156 763156 Clay, Lucy, of Langedon 2
4642871 2244025 2244025 defendant Gille Stephen   763156 763156 Gille, Stephen, of Langedon 1
4696284 2264321 2264321 plaintiff Elys John   763156 763156 Elys, John, of Langedon 1
4822540 2303125 2303125 plaintiff Smyth Walliam (legal representative) 763156 763156 Smyth, Walliam, of Langedon, parson, executors of 0
4962724 2345757 2345757 defendant Russyn Thomas laborer 763156 763156 Russyn, Thomas, of Langedon, laborer 0
4962730 2345760 2345760 defendant Wilkok Walter laborer 763156 763156 Wilkok, Walter, of Langedon, laborer 0
4962732 2345761 2345761 defendant Wilkok Walter laborer 763156 763156 Wilkok, Walter, of Langedon, laborer 0
5025193 2364263 2364263 defendant Stele John yeoman 763156 763156 Stele, John, of Langedon, yeoman 1
5407518 2477222 2477222 plaintiff Waynflett or Wanflete Robert   763156 763156 Waynflett or Wanflete, Robert, of Langedon, abbot of the monastery 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);