names

33 rows where place_id = 649453

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3906769 1992556 1992556 defendant ap Howell Thomas yeoman 649453 649453 ap Howell, Thomas, of Magor, yeoman 2
3906803 1992566 1992566 defendant ap Howell William yeoman 649453 649453 ap Howell, William, of Magor, yeoman 2
3953696 2008367 2008367 defendant ap Rees David yeoman 649453 649453 ap Rees, David, of Magor, yeoman 8
3953828 2008411 2008411 defendant ap Rees David yeoman 649453 649453 ap Rees, David, of Magor, yeoman 8
3953839 2008412 2008412 defendant ap Rees David yeoman 649453 649453 ap Rees, David, of Magor, yeoman 8
3978875 2017196 2017196 defendant Reynold Jenkin gent 649453 649453 Reynold, Jenkin, of Magor, gent 0
3978876 2017196 2017196 defendant Apowell Thomas gent 649453 649453 Apowell, Thomas, of Magor, gent 1
4001728 2025394 2025394 defendant Williams Thomas yeoman 649453 649453 Williams, Thomas, of Magor, yeoman 0
4001731 2025395 2025395 defendant Williams Thomas yeoman 649453 649453 Williams, Thomas, of Magor, yeoman 0
4001734 2025396 2025396 defendant Williams Thomas yeoman 649453 649453 Williams, Thomas, of Magor, yeoman 0
4011862 2028973 2028973 defendant Tanner Watkin husbandman 649453 649453 Tanner, Watkin, of Magor, husbandman 2
4011869 2028974 2028974 defendant Tanner Watkin husbandman 649453 649453 Tanner, Watkin, of Magor, husbandman 2
4015749 2030322 2030322 defendant William Thomas yeoman 649453 649453 William, Thomas, of Magor, yeoman 4
4015755 2030323 2030323 defendant William Thomas yeoman 649453 649453 William, Thomas, of Magor, yeoman 4
4058931 2045588 2045588 defendant Kerver Henry joiner 649453 649453 Kerver, Henry, of Magor, joiner 1
4076918 2052032 2052032 defendant Tanner Watkin husbandman 649453 649453 Tanner, Watkin, of Magor, husbandman 2
4076919 2052032 2052032 defendant William alias Tanner Mathew husbandman 649453 649453 William alias Tanner, Mathew, of Magor, husbandman 3
4099064 2059993 2059993 defendant Morgan William gent 649453 649453 Morgan, William, of Magor, gent 4
4152558 2079009 2079009 defendant Morgan William gent 649453 649453 Morgan, William, of Magor, gent 0
4196328 2094258 2094258 defendant Mathew William yeoman 649453 649453 Mathew, William, of Magor, yeoman 1
4201990 2096241 2096241 defendant Meredyth Edward Thomas yeoman 649453 649453 Meredyth, Edward Thomas, of Magor, yeoman 0
4220409 2102642 2102642 defendant Powell Walter gent 649453 649453 Powell, Walter, of Magor, gent 1
4220929 2102815 2102815 defendant Lennard Walter yeoman 649453 649453 Lennard, Walter, of Magor, yeoman 1
4220992 2102837 2102837 defendant Powell Walter gent 649453 649453 Powell, Walter, of Magor, gent 0
4274070 2120874 2120874 defendant Powell Walter gent 649453 649453 Powell, Walter, of Magor, gent 1
4281432 2123411 2123411 defendant Powell Walter gent 649453 649453 Powell, Walter, of Magor, gent 1
4282522 2123789 2123789 defendant Leonard Walter yeoman 649453 649453 Leonard, Walter, of Magor, yeoman 1
4283338 2124079 2124079 defendant Powell Walter gent 649453 649453 Powell, Walter, of Magor, gent 0
4364991 2152531 2152531 defendant Atkyns William miller 649453 649453 Atkyns, William, of Magor, miller 3
4373091 2155443 2155443 defendant Harry Walter husbandman 649453 649453 Harry, Walter, of Magor, husbandman 0
4373093 2155443 2155443 defendant Foord Edward smith 649453 649453 Foord, Edward, of Magor, smith 2
4373094 2155443 2155443 defendant Keene William cordwainer 649453 649453 Keene, William, of Magor, cordwainer 3
4375192 2156179 2156179 defendant Watkyn William Thomas husbandman 649453 649453 Watkyn, William Thomas, of Magor, husbandman 0

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