names

51 rows where place_id = 659033

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3950768 2007341 2007341 defendant Guillam Howell David husbandman 659033 659033 Guillam, Howell David, of Kenchurche, husbandman 0
3950769 2007341 2007341 defendant ap Powell Hugh husbandman 659033 659033 ap Powell, Hugh, of Kenchurche, husbandman 1
3950770 2007341 2007341 defendant ap Powell Richard laborer 659033 659033 ap Powell, Richard, of Kenchurche, laborer 2
3950771 2007341 2007341 defendant Morrys John alias Thomas laborer 659033 659033 Morrys, John alias Thomas, of Kenchurche, laborer 3
4000986 2025124 2025124 plaintiff Gylbarte Simon (legal representative) 659033 659033 Gylbarte, Simon, of Kenchurche, clerk, executor of 0
4007196 2027352 2027352 defendant Jenkyn John yeoman 659033 659033 Jenkyn, John, of Kenchurche, yeoman 0
4020417 2032025 2032025 defendant Hales David yeoman 659033 659033 Hales, David, of Kenchurche, yeoman 0
4020463 2032042 2032042 plaintiff Williams Walter   659033 659033 Williams, Walter, of Kenchurche 0
4053509 2043630 2043630 defendant Gillam Howell David yeoman 659033 659033 Gillam, Howell David, of Kenchurche, yeoman 0
4053510 2043630 2043630 defendant ap Howell Lewis husbandman 659033 659033 ap Howell, Lewis, of Kenchurche, husbandman 1
4061791 2046616 2046616 defendant Jenkyn Henry yeoman 659033 659033 Jenkyn, Henry, of Kenchurche, yeoman 1
4072677 2050527 2050527 defendant William Hugh yeoman 659033 659033 William, Hugh, of Kenchurche, yeoman 2
4084802 2054839 2054839 defendant Jenkyn Thomas Harry husbandman 659033 659033 Jenkyn, Thomas Harry, of Kenchurche, husbandman 0
4101220 2060745 2060745 defendant Tompson Simon yeoman 659033 659033 Tompson, Simon, of Kenchurche, yeoman 1
4101224 2060746 2060746 defendant Tompson Simon gent 659033 659033 Tompson, Simon, of Kenchurche, yeoman, Delahaye, Richard, of Peterchurche, gent 1
4116136 2066065 2066065 defendant Harry Henry John yeoman 659033 659033 Harry, Henry John, of Kenchurche, yeoman 0
4116137 2066065 2066065 defendant Harry William John yeoman 659033 659033 Harry, William John, of Kenchurche, yeoman 1
4116139 2066065 2066065 defendant Bengreghe John yeoman 659033 659033 Bengreghe, John, of Kenchurche, yeoman 3
4140259 2074760 2074760 defendant Rockleye Thomas yeoman 659033 659033 Rockleye, Thomas, of Kenchurche, yeoman 0
4154819 2079780 2079780 defendant Tompson Simon yeoman 659033 659033 Tompson, Simon, of Kenchurche, yeoman 3
4154824 2079781 2079781 defendant Tompson Simon yeoman 659033 659033 Tompson, Simon, of Kenchurche, yeoman 3
4155536 2080022 2080022 defendant Tompson Simon yeoman 659033 659033 Tompson, Simon, of Kenchurche, yeoman 0
4160580 2081778 2081778 defendant Moris John butcher 659033 659033 Moris, John, of Kenchurche, butcher 0
4160585 2081779 2081779 defendant Morrys John butcher 659033 659033 Morrys, John, of Kenchurche, butcher 0
4160596 2081782 2081782 defendant Morrys John butcher 659033 659033 Morrys, John, of Kenchurche, butcher 0
4187213 2091019 2091019 defendant Watkins Lewis gent 659033 659033 Watkins, Lewis, of Kenchurche, gent 0
4190051 2092021 2092021 defendant Hales David yeoman 659033 659033 Hales, David, of Kenchurche, yeoman 0
4208220 2098425 2098425 defendant Watkyn Lewis gent 659033 659033 Watkyn, Lewis, of Kenchurche, gent 1
4218399 2101935 2101935 defendant Wathan Nicholas yeoman 659033 659033 Wathan, Nicholas, of Kenchurche, yeoman 0
4230125 2106026 2106026 defendant Scudamore John esq 659033 659033 Scudamore, John, of Kenchurche, esq 0
4230126 2106026 2106026 defendant Scudamor Thomas gent 659033 659033 Scudamor, Thomas, of Kenchurche, gent 1
4230127 2106026 2106026 defendant Millward John yeoman 659033 659033 Millward, John, of Kenchurche, yeoman 2
4230128 2106026 2106026 defendant Harry William husbandman 659033 659033 Harry, William, of Kenchurche, husbandman 3
4230129 2106026 2106026 defendant Thomas John   659033 659033 Thomas, John, of Kenchurche, mason 4
4230130 2106026 2106026 defendant ap Morgan Morgan husbandman 659033 659033 ap Morgan, Morgan, of Kenchurche, husbandman 5
4230133 2106026 2106026 defendant Lewis Rice yeoman 659033 659033 Lewis, Rice, of Kenchurche, yeoman 8
4230134 2106026 2106026 defendant Hughe Henry yeoman 659033 659033 Hughe, Henry, of Kenchurche, yeoman 9
4230135 2106026 2106026 defendant Phelip Roger yeoman 659033 659033 Phelip, Roger, of Kenchurche, yeoman 10
4230136 2106026 2106026 defendant Hughe Henry ap Harry laborer 659033 659033 Hughe, Henry ap Harry, of Kenchurche, laborer 11
4236657 2108394 2108394 defendant Wathen John yeoman 659033 659033 Wathen, John, of Kenchurche, yeoman 1
4242489 2110486 2110486 defendant Watham James yeoman 659033 659033 Watham, James, of Kenchurche, yeoman 2
4246997 2111971 2111971 defendant Wathan John yeoman 659033 659033 Wathan, John, of Kenchurche, yeoman 0
4246998 2111971 2111971 defendant Jenkyn John yeoman 659033 659033 Jenkyn, John, of Kenchurche, yeoman 1
4319224 2136835 2136835 defendant Scudamore or Skidmore Thomas   659033 659033 Scudamore or Skidmore, Thomas, of Kenchurche, Herefs gent 2
4379731 2157845 2157845 defendant ap John William Thomas yeoman 659033 659033 ap John, William Thomas, of Kenchurche, yeoman 0
4400647 2164806 2164806 defendant Howell Thomas yeoman 659033 659033 Howell, Thomas, of Kenchurche, yeoman 2
4406879 2166867 2166867 defendant Waythen James yeoman 659033 659033 Waythen, James, of Kenchurche, yeoman 0
4406880 2166867 2166867 defendant Charles Richard yeoman 659033 659033 Charles Richard, of Kenchurche, yeoman 1
4406884 2166868 2166868 defendant Waythen James yeoman 659033 659033 Waythen, James, of Kenchurche, yeoman 0
4409771 2167871 2167871 defendant Charles Richard yeoman 659033 659033 Charles, Richard, of Kenchurche, yeoman 0
4409772 2167871 2167871 defendant Wathan or Waythan Nicholas yeoman 659033 659033 Wathan or Waythan, Nicholas, of Kenchurche, 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);