names

23 rows where place_id = 647570

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3896974 1989205 1989205 defendant Waters Thomas   647570 647570 Waters, Thomas, of Haye, Brecon 0
3925198 1998738 1998738 defendant ap John Henry yeoman 647570 647570 ap John, Henry, of Haye, Brecon, yeoman 1
4022241 2032681 2032681 defendant Thomas John yeoman 647570 647570 Thomas, John, of Haye, Brecon, yeoman 1
4042453 2039781 2039781 defendant Myle Jevan John yeoman 647570 647570 Myle, Jevan John, of Haye, Brecon, yeoman 4
4042467 2039782 2039782 defendant Myle Evan yeoman 647570 647570 Myle, Evan, of Haye, Brecon, yeoman 4
4049579 2042290 2042290 defendant Whytney William gent 647570 647570 Whytney, William, of Haye, Brecon, gent 1
4049585 2042291 2042291 defendant Whitney William gent 647570 647570 Whitney, William, of Haye, Brecon, gent 1
4050438 2042583 2042583 defendant ap Jevan John Lewis yeoman 647570 647570 ap Jevan, John Lewis, of Haye, Brecon, yeoman 1
4050441 2042584 2042584 defendant ap Jevan John Lewis yeoman 647570 647570 ap Jevan, John Lewis, of Haye, Brecon, yeoman 1
4054195 2043887 2043887 defendant Baker John baker 647570 647570 Baker, John, of Haye, Brecon, baker 0
4066573 2048338 2048338 defendant Whitney William gent 647570 647570 Whitney, William, of Haye, Brecon, gent 0
4073806 2050923 2050923 defendant ap Jevan William butcher 647570 647570 ap Jevan, William, of Haye, Brecon, butcher 1
4153320 2079260 2079260 defendant Thomas John yeoman 647570 647570 Thomas, John, of Haye, Brecon, yeoman 0
4159556 2081410 2081410 defendant William Thomas ap Howell yeoman 647570 647570 William, Thomas ap Howell, of Haye, Brecon, yeoman 0
4180783 2088758 2088758 defendant Watkyn William yeoman 647570 647570 Watkyn, William, of Haye, Brecon, yeoman 0
4210768 2099324 2099324 defendant Thomas John yeoman 647570 647570 Thomas, John, of Haye, Brecon, yeoman 0
4256918 2115286 2115286 defendant Watkyns William gent 647570 647570 Watkyns, William, of Haye, Brecon, gent 0
4300726 2130356 2130356 defendant Meredith Jenkin baker 647570 647570 Meredith, Jenkin, of Haye, Brecon, baker 0
4308721 2133202 2133202 defendant Jenkyn Watkin yeoman 647570 647570 Jenkyn, Watkin, of Haye, Brecon, yeoman 0
4308899 2133263 2133263 defendant Meredith Jenkin baker 647570 647570 Meredith, Jenkin, of Haye, Brecon, baker 0
4318493 2136579 2136579 defendant Haie James smith 647570 647570 Haie, James, of Haye, Brecon, smith 1
4370279 2154429 2154429 defendant Watkyn William gent 647570 647570 Watkyn, William, of Haye, Brecon, gent 1
4387733 2160532 2160532 defendant Floyd or Lloyd Jevan gent 647570 647570 Floyd or Lloyd, Jevan, of Haye, Brecon, gent 2

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