names

18 rows where place_id = 658981

✎ 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
3950580 2007275 2007275 defendant ap Richard David Lloyd clerk 658981 658981 ap Richard, David Lloyd, of Longtown, clerk 11
3988304 2020564 2020564 defendant Lewys Lewis John yeoman 658981 658981 Lewys, Lewis John, of Longtown, yeoman 3
3988344 2020578 2020578 defendant Harry Griffin yeoman 658981 658981 Harry, Griffin, of Longtown, yeoman 0
3988345 2020578 2020578 defendant ap Prychard John Thomas yeoman 658981 658981 ap Prychard, John Thomas, of Longtown, yeoman 1
3988353 2020582 2020582 plaintiff ap Powell William husbandman 658981 658981 ap Powell, William, of Longtown, husbandman 0
3999732 2024663 2024663 defendant Morgan William husbandman 658981 658981 Morgan, William, of Longtown, husbandman 4
4022335 2032710 2032710 plaintiff ap Powell William husbandman 658981 658981 ap Powell, William, of Longtown, husbandman 0
4032412 2036250 2036250 defendant ap Harry Watkin yeoman 658981 658981 ap Harry, Watkin, of Longtown, yeoman 0
4032413 2036250 2036250 defendant ap Watkyn Lewis ap Richard yeoman 658981 658981 ap Watkyn, Lewis ap Richard, of Longtown, yeoman 1
4032414 2036250 2036250 defendant ap Gillam Howell ap Richard yeoman 658981 658981 ap Gillam, Howell ap Richard, of Longtown, yeoman 2
4032418 2036251 2036251 defendant Harry Watkin Jevan yeoman 658981 658981 Harry, Watkin Jevan, of Longtown, yeoman 0
4032419 2036251 2036251 defendant ap Watkyn Lewis ap Richard yeoman 658981 658981 ap Watkyn, Lewis ap Richard, of Longtown, yeoman 1
4032420 2036251 2036251 defendant ap Gillam Howell ap Richard yeoman 658981 658981 ap Gillam, Howell ap Richard, of Longtown, yeoman 2
4032443 2036253 2036253 defendant Morgan William yeoman 658981 658981 Morgan, William, of Longtown, yeoman 1
4052688 2043392 2043392 defendant John John Thomas yeoman 658981 658981 John, John Thomas, of Longtown, yeoman 2
4212973 2100062 2100062 defendant Lewys David Gwyllim yeoman 658981 658981 Lewys, David Gwyllim, of Longtown, yeoman 1
4379201 2157644 2157644 defendant Phillippe alias Smythe Howell smith 658981 658981 Phillippe alias Smythe, Howell, of Longtown, smith 0
4379202 2157644 2157644 defendant Apprice Philip John yeoman 658981 658981 Apprice, Philip John, of Longtown, yeoman 1

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