names

18 rows where place_id = 657435

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3939694 2003580 2003580 defendant Meredithe William   657435 657435 Meredithe, William, of Presteyne, Radnor, shoe maker 3
3944329 2005114 2005114 defendant Vaughan John gent 657435 657435 Vaughan, John, of Presteyne, Radnor, gent 1
3945999 2005677 2005677 defendant Wheler Richard yeoman 657435 657435 Wheler, Richard, of Presteyne, Radnor, yeoman 0
3974098 2015511 2015511 defendant Vaughan John gent 657435 657435 Vaughan, John, of Presteyne, Radnor, gent 0
3998099 2024078 2024078 defendant Gore John ap Lloid yeoman 657435 657435 Gore, John ap Lloid, of Presteyne, Radnor, yeoman 0
3999729 2024663 2024663 defendant Gommey or Gounney John gent 657435 657435 Gommey or Gounney, John, of Presteyne, Radnor, gent 1
4004077 2026230 2026230 defendant Wackrell James sherman 657435 657435 Wackrell, James, of Presteyne, Radnor, yeoman, sherman 0
4032415 2036250 2036250 defendant Lyde Thomas yeoman 657435 657435 Lyde, Thomas, of Presteyne, Radnor, yeoman 3
4032421 2036251 2036251 defendant Lyde Thomas yeoman 657435 657435 Lyde, Thomas, of Presteyne, Radnor, yeoman 3
4036486 2037735 2037735 defendant Brett Hugh yeoman 657435 657435 Brett, Hugh, of Presteyne, Radnor, yeoman 2
4036490 2037736 2037736 defendant Bratt Hugh yeoman 657435 657435 Bratt, Hugh, of Presteyne, Radnor, yeoman 2
4042460 2039781 2039781 defendant Leyd Hugh yeoman 657435 657435 Leyd, Hugh, of Presteyne, Radnor, yeoman 11
4092543 2057641 2057641 defendant Heathe Roger walker 657435 657435 (Heathe, Roger, of Presteyne, Radnor, walker 2
4092556 2057644 2057644 defendant Heath Roger walker 657435 657435 (Heath, Roger, of Presteyne, Radnor, walker 2
4151406 2078616 2078616 defendant (not given) Richard rector of Weaver 657435 657435 Weaver, Richard, of Presteyne, Radnor, clerk, rector of Knyll, Herefs 0
4263205 2117358 2117358 defendant Gonney or Gomey Richard chapman 657435 657435 Gonney or Gomey, Richard, of Presteyne, Radnor, chapman 0
4264498 2117767 2117767 defendant Lewys Hugh gent 657435 657435 Lewys, Hugh, of Presteyne, Radnor, gent 0
4298122 2129432 2129432 defendant Kyng William gent 657435 657435 Kyng, William, of Presteyne, Radnor, gent 3

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