names

40 rows where place_id = 661755

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3962190 2011359 2011359 defendant William Margaret widow 661755 661755 (William, Margaret, of Pantege, widow 1
3962191 2011359 2011359 defendant Thomas William yeoman 661755 661755 Thomas, William, of Pantege, yeoman 2
3962192 2011359 2011359 defendant Thomas Morgan yeoman 661755 661755 Thomas, Morgan, of Pantege, yeoman 3
3976017 2016176 2016176 defendant Griffith Treheron ap Jevan husbandman 661755 661755 Griffith, Treheron ap Jevan, of Pantege, husbandman 4
3982001 2018325 2018325 defendant Parson Jenkin yeoman 661755 661755 Parson, Jenkin, of Pantege, yeoman 3
3982002 2018325 2018325 defendant John William yeoman 661755 661755 John, William, of Pantege, yeoman 4
3982004 2018326 2018326 defendant Rosser Rothergh yeoman 661755 661755 Rosser, Rothergh, of Pantege, yeoman 0
3982005 2018326 2018326 defendant Rothergh Rosser yeoman 661755 661755 Rothergh, Rosser, of Pantege, yeoman 1
3982008 2018326 2018326 defendant Thomas William yeoman 661755 661755 Thomas, William, of Pantege, yeoman 4
3982010 2018326 2018326 defendant Thomas Jenkin yeoman 661755 661755 Thomas, Jenkin, of Pantege, yeoman 6
4053560 2043648 2043648 plaintiff ap Price Morgan yeoman 661755 661755 ap Price, Morgan, of Pantege, yeoman 0
4068202 2048929 2048929 defendant Harry Roger yeoman 661755 661755 Harry, Roger, of Pantege, yeoman 5
4071234 2050017 2050017 defendant Probert Thomas gent 661755 661755 Probert, Thomas, of Pantege, gent 0
4071235 2050017 2050017 defendant Thomas William yeoman 661755 661755 Thomas, William, of Pantege, yeoman 1
4097201 2059320 2059320 defendant Lewys William Thomas yeoman 661755 661755 Lewys, William Thomas, of Pantege, yeoman 0
4097202 2059320 2059320 defendant Morgan Morgan Thomas yeoman 661755 661755 Morgan, Morgan Thomas, of Pantege, yeoman 1
4097204 2059321 2059321 defendant Morgan Philip yeoman 661755 661755 Morgan, Philip, of Pantege, yeoman 0
4129136 2070725 2070725 defendant Keryck Thomas John yeoman 661755 661755 Keryck, Thomas John, of Pantege, yeoman 0
4130540 2071234 2071234 defendant Rosser Retherghe yeoman 661755 661755 Rosser, Retherghe, of Pantege, yeoman 0
4130541 2071234 2071234 defendant Retherghe John yeoman 661755 661755 Retherghe, John, of Pantege, yeoman 1
4130542 2071234 2071234 defendant Laborer William yeoman 661755 661755 Laborer, William, of Pantege, yeoman 2
4133210 2072201 2072201 defendant Thomas Morgan yeoman 661755 661755 Thomas, Morgan, of Pantege, yeoman 0
4133212 2072201 2072201 defendant William John yeoman 661755 661755 William, John, of Pantege, yeoman 2
4155472 2080001 2080001 defendant Philip Gowell yeoman 661755 661755 Philip, Gowell, of Pantege, yeoman 0
4163647 2082805 2082805 defendant Philip Howell yeoman 661755 661755 Philip, Howell, of Pantege, yeoman 0
4274242 2120934 2120934 defendant Janken Roger yeoman 661755 661755 Janken, Roger, of Pantege, yeoman 1
4278010 2122240 2122240 defendant Thomas Thomas William gent 661755 661755 Thomas, Thomas William, of Pantege, gent 2
4280801 2123189 2123189 defendant Morgan William Thomas gent 661755 661755 Morgan, William Thomas, of Pantege, gent 0
4281426 2123409 2123409 defendant Jevan Morgan John yeoman 661755 661755 Jevan, Morgan John, of Pantege, yeoman 1
4282133 2123654 2123654 defendant Jenkyn Philip Lawrence yeoman 661755 661755 Jenkyn, Philip Lawrence, of Pantege, yeoman 0
4282134 2123654 2123654 defendant Griffith Roger yeoman 661755 661755 Griffith, Roger, of Pantege, yeoman 1
4369217 2154054 2154054 defendant ap Jenkyn Thomas laborer 661755 661755 ap Jenkyn, Thomas, of Pantege, laborer 0
4375413 2156261 2156261 defendant Lewis William yeoman 661755 661755 Lewis, William, of Pantege, yeoman 1
4375414 2156261 2156261 defendant Thomas Jevan yeoman 661755 661755 Thomas, Jevan, of Pantege, yeoman 2
4375415 2156261 2156261 defendant John Philip Morgan yeoman 661755 661755 John, Philip Morgan, of Pantege, yeoman 3
4376610 2156705 2156705 defendant Lewis William yeoman 661755 661755 Lewis, William, of Pantege, yeoman 1
4378224 2157279 2157279 defendant ap John John Jenkyn yeoman 661755 661755 ap John, John Jenkyn, of Pantege, yeoman 0
4378225 2157279 2157279 defendant William Philip yeoman 661755 661755 William, Philip, of Pantege, yeoman 1
4378227 2157279 2157279 defendant Pavid Peter (legal representative) 661755 661755 Pavid, Peter, of Pantege, yeoman, executor of 3
4378228 2157279 2157279 defendant David Morgan Peter yeoman 661755 661755 David, Morgan Peter, of Pantege, yeoman 4

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