names

33 rows where place_id = 587598

✎ 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
3591878 1865076 1865076 defendant Chaffman or Chassman John, junior gent 587598 587598 Chaffman or Chassman, John, junior, of Mayden Bradley, Wilts, gent 13
3651049 1910694 1910694 defendant Bolle William yeoman 587598 587598 Bolle, William, of Mayden Bradley, Wilts, yeoman 0
3678222 1919242 1919242 defendant Ryder John butcher 587598 587598 (Ryder, John, of Mayden Bradley, Wilts, butcher 3
3720694 1932764 1932764 defendant Mompesson Richard gent 587598 587598 Mompesson, Richard, of Mayden Bradley, Wilts, gent 0
3750144 1941959 1941959 defendant Bugden John fuller 587598 587598 Bugden, John, of Mayden Bradley, Wilts, fuller 0
3750157 1941965 1941965 defendant Bugden John tucker 587598 587598 Bugden, John, of Mayden Bradley, Wilts, tucker 0
3756119 1943871 1943871 defendant Bugden John fuller 587598 587598 Bugden, John, of Mayden Bradley, Wilts, fuller 0
3756123 1943872 1943872 defendant Bugden John fuller 587598 587598 Bugden, John, of Mayden Bradley, Wilts, fuller 0
3765094 1946748 1946748 defendant Monnpesson Richard gent 587598 587598 Monnpesson, Richard, of Mayden Bradley, Wilts, gent 0
3780568 1951652 1951652 defendant Momporson Richard gent 587598 587598 Momporson, Richard, of Mayden Bradley, Wilts, gent 0
3852425 1974363 1974363 defendant Felteham alias Ryder John butcher 587598 587598 Felteham alias Ryder, John, of Mayden Bradley, Wilts, butcher 0
3902235 1990983 1990983 defendant Momparson William gent 587598 587598 Momparson, William, of Mayden Bradley, Wilts, gent 1
3920431 1997178 1997178 defendant Mumpesson Richard gent 587598 587598 Mumpesson, Richard, of Mayden Bradley, Wilts, gent 0
3981518 2018150 2018150 defendant Baylye John, junior husbandman 587598 587598 Baylye, John, junior, of Mayden Bradley, Wilts, husbandman 0
4042840 2039914 2039914 defendant Mompesson Vincent gent 587598 587598 Mompesson, Vincent, of Mayden Bradley, Wilts, gent 0
4093218 2057891 2057891 defendant Baylye Ralph yeoman 587598 587598 Baylye, Ralph, of Mayden Bradley, Wilts, yeoman 0
4093498 2057990 2057990 defendant Bayly Ralph yeoman 587598 587598 Bayly, Ralph, of Mayden Bradley, Wilts, yeoman 0
4786256 2291744 2291744 defendant Hoper John chapman 587598 587598 Hoper, John, of Mayden Bradley, Wilts, chapman 0
4807364 2298500 2298500 defendant Dabbe Thomas shoemaker 587598 587598 Dabbe, Thomas, of Mayden Bradley, Wilts, shoemaker 0
4895601 2325294 2325294 defendant Broun John butcher 587598 587598 Broun, John, of Mayden Bradley, Wilts, butcher 0
4951859 2342529 2342529 defendant Broune John butcher 587598 587598 Broune, John, of Mayden Bradley, Wilts, butcher 0
5046636 2370620 2370620 defendant Battys Thomas gent 587598 587598 Battys, Thomas, of Mayden Bradley, Wilts, gent 4
5061077 2374889 2374889 defendant atte Mere John butcher 587598 587598 atte Mere, John, of Mayden Bradley, Wilts, butcher 0
5101972 2386999 2386999 defendant Kokkys Henry fisher 587598 587598 Kokkys, Henry, of Mayden Bradley, Wilts, fisher 4
5131481 2395692 2395692 defendant atte Mere John butcher 587598 587598 atte Mere, John, of Mayden Bradley, Wilts, butcher 1
5246208 2429051 2429051 defendant Browene John butcher 587598 587598 Browene, John, of Mayden Bradley, Wilts, butcher 1
5397822 2474447 2474447 defendant (not given) William prior of Westbury 587598 587598 Westbury, William, of Mayden Bradley, Wilts, prior of the Priory of BM 0
5397824 2474448 2474448 defendant (not given) William prior of Westbury 587598 587598 Westbury, William, of Mayden Bradley, Wilts, prior of the House or Priory of BM 0
5410988 2478238 2478238 defendant (not given) William prior of Westbury 587598 587598 Westbury, William, of Mayden Bradley, Wilts, prior of the house & priory of the BM 0
5410990 2478239 2478239 defendant (not given) William prior of Westbury 587598 587598 Westbury, William, of Mayden Bradley, Wilts, prior of the house & priory of the BM 0
5442153 2487570 2487570 defendant Phelip John chapman 587598 587598 Phelip, John, of Mayden Bradley, Wilts, chapman 1
5478122 2498483 2498483 defendant Phelip John chapman 587598 587598 Phelip, John, of Mayden Bradley, Wilts, chapman 1
5496417 2503835 2503835 defendant Grenelam John yeoman 587598 587598 Grenelam, John, of Mayden Bradley, Wilts, yeoman 2

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