names

14 rows where place_id = 796418

✎ 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
4750992 2280771 2280771 defendant Talbot Robert yeoman 796418 796418 Talbot, Robert, of Monks Illey, yeoman 2
4932589 2336584 2336584 defendant Talbot Robert husbandman 796418 796418 Talbot, Robert, of Monks Illey, husbandman 0
4984085 2352172 2352172 defendant Reyner Robert fuller 796418 796418 Reyner, Robert, of Monks Illey, fuller 1
5001881 2357450 2357450 defendant Bythe Northen Andrew chapman 796418 796418 Bythe Northen, Andrew, of Monks Illey, chapman 0
5032012 2366236 2366236 defendant Hoberd Richard husbandman 796418 796418 Hoberd, Richard, of Monks Illey, husbandman 1
5032015 2366236 2366236 defendant Berton Robert husbandman 796418 796418 Berton, Robert, of Monks Illey, husbandman 4
5053611 2372681 2372681 defendant Chapeleyn John weaver 796418 796418 Chapeleyn, John, of Monks Illey, weaver 1
5058810 2374199 2374199 defendant Hobert John yeoman 796418 796418 Hobert, John, of Monks Illey, yeoman 2
5064382 2375892 2375892 defendant Shoppe Andrew, senior yeoman 796418 796418 Shoppe, Andrew, senior, of Monks Illey, yeoman 11
5099963 2386425 2386425 defendant Shoppe William fuller 796418 796418 Shoppe, William, of Monks Illey, fuller 0
5202925 2416619 2416619 defendant Astlee William, sen weaver 796418 796418 Astlee, William, sen, of Monks Illey, weaver 0
5280782 2439453 2439453 defendant Bretoun John yeoman 796418 796418 Bretoun, John, of Monks Illey, yeoman 2
5288133 2441548 2441548 defendant Benorth Andrew yeoman 796418 796418 Benorth, Andrew, of Monks Illey, yeoman 1
5342546 2457869 2457869 defendant Groundshawe Thomas husbandman 796418 796418 Groundshawe, Thomas, of Monks Illey, husbandman 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);