names

29 rows where place_id = 659032

✎ 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
3950766 2007340 2007340 defendant ap Richard Thomas John husbandman 659032 659032 ap Richard, Thomas John, of Cledock, husbandman 1
3951531 2007591 2007591 defendant Phelipp Thomas Gwatkyn husbandman 659032 659032 Phelipp, Thomas Gwatkyn, of Cledock, husbandman 0
3951532 2007591 2007591 defendant Gwatkyn John Thomas husbandman 659032 659032 Gwatkyn, John Thomas, of Cledock, husbandman 1
3951533 2007591 2007591 defendant ap Gwatkyn Gwenlliana vergh Thomas spinster 659032 659032 ap Gwatkyn, Gwenlliana vergh Thomas, of Cledock, spinster 2
3951534 2007591 2007591 defendant Pryce Rice William husbandman 659032 659032 Pryce, Rice William, of Cledock, husbandman 3
3951535 2007591 2007591 defendant Jenkyn Walter husbandman 659032 659032 Jenkyn, Walter, of Cledock, husbandman 4
3964179 2012079 2012079 defendant Richard Henry yeoman 659032 659032 Richard, Henry, of Cledock, yeoman 0
3964210 2012089 2012089 defendant Harry Watkin ap Jevan yeoman 659032 659032 Harry, Watkin ap Jevan, of Cledock, yeoman 0
3964211 2012089 2012089 defendant Ewyn Jevan Watkyn yeoman 659032 659032 Ewyn, Jevan Watkyn, of Cledock, yeoman 1
3972802 2015060 2015060 defendant Scudamore John Richard husbandman 659032 659032 Scudamore, John Richard, of Cledock, husbandman 0
3973498 2015301 2015301 defendant Gwyn Thomas Philip John Holl yeoman 659032 659032 Gwyn, Thomas Philip John Holl, of Cledock, yeoman 0
3973499 2015301 2015301 defendant Powell Henry John William husbandman 659032 659032 Powell, Henry John William, of Cledock, husbandman 1
3977451 2016683 2016683 defendant Harry Griffin yeoman 659032 659032 Harry, Griffin,of Cledock, yeoman 0
3977457 2016685 2016685 defendant John Richard Thomas ap Richard yeoman 659032 659032 John, Richard Thomas ap Richard, of Cledock, yeoman 0
3977458 2016685 2016685 defendant ap rosser Henry Philip Appowell yeoman 659032 659032 ap rosser, Henry Philip Appowell, of Cledock, yeoman 1
3979587 2017458 2017458 defendant Harry Lewis John weaver 659032 659032 Harry, Lewis John, of Cledock, weaver 0
3980053 2017628 2017628 defendant ap Richard Watkin Harry Thomas yeoman 659032 659032 ap Richard, Watkin Harry Thomas, of Cledock, yeoman 0
3981713 2018217 2018217 defendant Harry Watkin ap Jevan yeoman 659032 659032 Harry, Watkin ap Jevan, of Cledock, yeoman 0
3981715 2018218 2018218 defendant John John David yeoman 659032 659032 John, John David, of Cledock, yeoman 0
3984709 2019288 2019288 defendant Harry Griffin yeoman 659032 659032 Harry, Griffin, of Cledock, yeoman 0
3996339 2023442 2023442 defendant James Thomas yeoman 659032 659032 James, Thomas, of Cledock, yeoman 0
4022293 2032695 2032695 defendant Lewes Lewis John yeoman 659032 659032 Lewes, Lewis John, of Cledock, or of Longtowne, yeoman 0
4022442 2032752 2032752 plaintiff Apowell Cecily   659032 659032 Cecily his wife, alias Sisslia vergh Stephen, of Cledock 1
4022444 2032752 2032752 defendant John David Thomas Philip yeoman 659032 659032 John, David Thomas Philip, of Cledock, yeoman 1
4022446 2032752 2032752 defendant Myle Philip yeoman 659032 659032 (Myle, Philip, of Cledock, yeoman 3
4043589 2040169 2040169 defendant ap Jevan Thomas yeoman 659032 659032 ap Jevan, Thomas, of Cledock, or of Bryne, yeoman 0
4052535 2043329 2043329 defendant Thomas William William yeoman 659032 659032 Thomas, William William, of Cledock, yeoman 0
4052536 2043329 2043329 defendant Thomas Jeneta widow 659032 659032 Thomas, Jeneta, of Cledock,widow 1
4052537 2043329 2043329 defendant Harry John Griffith yeoman 659032 659032 Harry, John Griffith, of Cledock, yeoman 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);