names

31 rows where place_id = 664727

✎ 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
3973975 2015468 2015468 defendant vergh Howell Joan widow 664727 664727 vergh Howell, Joan, of Mamhilad, widow 0
3973976 2015468 2015468 defendant ap John Lewis yeoman 664727 664727 ap John, Lewis, of Mamhilad, yeoman 1
3973977 2015468 2015468 defendant Eghanm John Philip Jevan yeoman 664727 664727 Eghanm, John Philip Jevan, of Mamhilad, yeoman 2
4053624 2043669 2043669 defendant Morgan Philip yeoman 664727 664727 Morgan, Philip, of Mamhilad, yeoman 2
4073313 2050744 2050744 plaintiff Phillipp Richard yeoman 664727 664727 Phillipp, Richard, of Mamhilad, yeoman 0
4220176 2102561 2102561 defendant Philip George yeoman 664727 664727 Philip, George, of Mamhilad, yeoman 0
4220177 2102561 2102561 defendant Rosser Watkin yeoman 664727 664727 Rosser, Watkin, of Mamhilad, yeoman 1
4274225 2120927 2120927 defendant John Watkin Rosser husbandman 664727 664727 John, Watkin Rosser, of Mamhilad, husbandman 0
4280567 2123110 2123110 defendant Rosser Richard Watkin yeoman 664727 664727 Rosser, Richard Watkin, of Mamhilad, yeoman 0
4280569 2123110 2123110 defendant Phillipp Watkin John yeoman 664727 664727 Phillipp, Watkin John, of Mamhilad, yeoman 2
4280574 2123111 2123111 defendant vergh John Aloce widow 664727 664727 vergh John, Aloce, of Mamhilad, widow 2
4280864 2123210 2123210 defendant Howell Watkin yeoman 664727 664727 Howell, Watkin, of Mamhilad, yeoman 2
4283291 2124063 2124063 defendant Phillip George yeoman 664727 664727 Phillip, George, of Mamhilad, yeoman 0
4283292 2124063 2124063 defendant Watkyn Thomas yeoman 664727 664727 Watkyn, Thomas, of Mamhilad, yeoman 1
4358602 2150249 2150249 defendant Rees Henry yeoman 664727 664727 Rees, Henry, of Mamhilad, yeoman 0
4358603 2150249 2150249 defendant Thomas Richard laborer 664727 664727 Thomas, Richard, of Mamhilad, laborer 1
4360758 2151020 2151020 defendant Philip Watkin John yeoman 664727 664727 Philip, Watkin John, of Mamhilad, yeoman 0
4361890 2151412 2151412 defendant Watkyn Richard yeoman 664727 664727 Watkyn, Richard, of Mamhilad, yeoman 0
4361891 2151412 2151412 defendant Watkyn John ap John yeoman 664727 664727 Watkyn, John ap John, of Mamhilad, yeoman 1
4363983 2152175 2152175 defendant John Walter yeoman 664727 664727 John, Walter, of Mamhilad, yeoman 2
4367990 2153602 2153602 defendant Watkyn Richard yeoman 664727 664727 Watkyn, Richard, of Mamhilad, yeoman 2
4370012 2154331 2154331 defendant Rosser Richard Watkin yeoman 664727 664727 Rosser, Richard Watkin, of Mamhilad, yeoman 0
4370046 2154344 2154344 defendant Rosser Richard Watkyn yeoman 664727 664727 Rosser, Richard Watkyn, of Mamhilad, yeoman 0
4373036 2155424 2155424 defendant Watkyn Watkin John yeoman 664727 664727 Watkyn, Watkin John, of Mamhilad, yeoman 0
4373037 2155424 2155424 defendant Watkkyn Morgan Thomas yeoman 664727 664727 Watkkyn, Morgan Thomas, of Mamhilad, yeoman 1
4373100 2155445 2155445 defendant Watkyn Watkin John yeoman 664727 664727 Watkyn, Watkin John, of Mamhilad, yeoman 1
4373101 2155445 2155445 defendant Rosser Richard Watkin yeoman 664727 664727 Rosser, Richard Watkin, of Mamhilad, yeoman 2
4375899 2156442 2156442 defendant Watkyn Watkin John yeoman 664727 664727 Watkyn, Watkin John, of Mamhilad, yeoman 0
4378220 2157278 2157278 defendant Watkyn Watkin John yeoman 664727 664727 Watkyn, Watkin John, of Mamhilad, yeoman 1
4378221 2157278 2157278 defendant Rosser John Watkin yeoman 664727 664727 Rosser, John Watkin, of Mamhilad, yeoman 2
4380713 2158213 2158213 defendant Watkyn John ap John husbandman 664727 664727 Watkyn, John ap John, of Mamhilad, husbandman 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);