names

37 rows where place_id = 650539

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3912655 1994567 1994567 defendant Hughs Maurice yeoman 650539 650539 Hughs, Maurice, of Uske, Monmouth, yeoman 0
3968032 2013449 2013449 defendant Morys William yeoman 650539 650539 Morys, William, of Uske, Monmouth, yeoman 0
3975134 2015867 2015867 defendant Williams Nicholas shoemaker 650539 650539 Williams, Nicholas, of Uske, Monmouth, shoemaker 0
3988387 2020593 2020593 defendant William Reginald yeoman 650539 650539 William, Reginald, of Uske, Monmouth, yeoman 0
4003732 2026101 2026101 defendant Thomas William yeoman 650539 650539 Thomas, William, of Uske, Monmouth, yeoman 3
4015730 2030319 2030319 defendant Wylliams Robert gent 650539 650539 Wylliams, Robert, of Uske, Monmouth, gent 2
4045455 2040825 2040825 defendant Adam John Harry yeoman 650539 650539 Adam, John Harry, of Uske, Monmouth, yeoman 0
4045631 2040890 2040890 defendant Adam John Harry yeoman 650539 650539 Adam, John Harry, of Uske, Monmouth, yeoman 0
4049256 2042180 2042180 defendant Powell Elizabeth widow 650539 650539 Powell, Elizabeth, of Uske, Monmouth, widow 0
4067715 2048765 2048765 defendant Wyllym Edmund John baker 650539 650539 Wyllym, Edmund John, of Uske, Monmouth, baker 1
4078763 2052701 2052701 plaintiff Thomas Joan spinster 650539 650539 Joan his wife, formerly Joan verch Howell, of Uske, Monmouth, spinster 1
4081457 2053677 2053677 defendant Parry Simon gent 650539 650539 Parry, Simon, of Uske, Monmouth, gent 6
4110861 2064140 2064140 defendant Parker William gent 650539 650539 Parker, William, of Uske, Monmouth, gent 0
4117122 2066429 2066429 defendant Parry Simon gent 650539 650539 Parry, Simon, of Uske, Monmouth, gent 2
4117358 2066507 2066507 defendant Morrys alias Tanner Giles tanner 650539 650539 Morrys alias Tanner, Giles, of Uske, Monmouth, tanner 1
4128448 2070466 2070466 defendant Prychsrd Philip Edward Jeyn yeoman 650539 650539 Prychsrd, Philip Edward Jeyn, of Uske, Monmouth, yeoman 3
4128450 2070467 2070467 defendant Prychard John Edward Jeyne yeoman 650539 650539 Prychard, John Edward Jeyne, of Uske, Monmouth, yeoman 0
4133184 2072193 2072193 defendant Richard Philip Edward yeoman 650539 650539 Richard, Philip Edward, of Uske, Monmouth, yeoman 0
4138964 2074306 2074306 defendant Morgan Reginald smith 650539 650539 Morgan, Reginald, of Uske, Monmouth, smith 0
4157098 2080563 2080563 defendant Richard Philip Edward yeoman 650539 650539 Richard, Philip Edward, of Uske, Monmouth, yeoman 0
4157403 2080660 2080660 defendant Morgan alias Wolfe Walter gent 650539 650539 Morgan alias Wolfe, Walter, of Uske, Monmouth, gent 0
4159438 2081367 2081367 defendant Hughe John ap William yeoman 650539 650539 Hughe, John ap William, of Uske, Monmouth, yeoman 0
4160864 2081873 2081873 defendant Hughes Walter yeoman 650539 650539 Hughes, Walter, of Uske, Monmouth, yeoman 0
4161314 2082037 2082037 defendant ap Oarrye Simon gent 650539 650539 ap Oarrye, Simon, of Uske, Monmouth, gent 2
4162858 2082542 2082542 defendant Morrys James   650539 650539 Morrys, James, of Uske, Monmouth 44
4163674 2082815 2082815 defendant Morgan Reginald smith 650539 650539 Morgan, Reginald, of Uske, Monmouth, smith 0
4165930 2083584 2083584 defendant Nycholas William gent 650539 650539 Nycholas, William, of Uske, Monmouth, gent 0
4167867 2084247 2084247 defendant Powell Hugh gent 650539 650539 Powell, Hugh, of Uske, Monmouth, gent 1
4173051 2086030 2086030 defendant Thomas Reginald William yeoman 650539 650539 Thomas, Reginald William, of Uske, Monmouth, yeoman 1
4185590 2090465 2090465 defendant Jones William gent 650539 650539 Jones, William, of Uske, Monmouth, gent 0
4199848 2095498 2095498 defendant John Morgan yeoman 650539 650539 John, Morgan, of Uske, Monmouth, yeoman 0
4220005 2102499 2102499 defendant Jones Walter gent 650539 650539 Jones, Walter, of Uske, Monmouth, gent 0
4229115 2105665 2105665 defendant Jones Walter gent 650539 650539 Jones, Walter, of Uske, Monmouth, gent 0
4288379 2125895 2125895 defendant Wyllyams Robert vintner 650539 650539 Wyllyams, Robert, of Uske, Monmouth, vintner 0
4298112 2129430 2129430 defendant Jones Walter gent 650539 650539 Jones, Walter, of Uske, Monmouth, gent 0
4306565 2132433 2132433 defendant Jones Walter gent 650539 650539 Jones, Walter, of Uske, Monmouth, gent 0
4341430 2144280 2144280 defendant Wolf Walter Morgan gent 650539 650539 Wolf, Walter Morgan, of Uske, Monmouth, gent 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);