names

38 rows where place_id = 597884

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3630232 1904304 1904304 defendant Kent John maltman 597884 597884 Kent, John, of Bennyngton, maltman 0
3901632 1990773 1990773 defendant Bedell Richard husbandman 597884 597884 Bedell, Richard, of Bennyngton, husbandman 3
3927102 1999401 1999401 defendant Abraham Alexander husbandman 597884 597884 Abraham, Alexander, of Bennyngton, husbandman 0
3941170 2004050 2004050 defendant Marston Elizabeth widow 597884 597884 Marston, Elizabeth, of Bennyngton, widow 1
3964350 2012135 2012135 defendant Coo John yeoman 597884 597884 Coo, John, of Bennyngton, yeoman 0
4011413 2028860 2028860 defendant Hill John maltman 597884 597884 Hill, John, of Bennyngton, maltman 2
4048804 2042020 2042020 defendant Hoye William maltman 597884 597884 Hoye, William, of Bennyngton, maltman 0
4195614 2094016 2094016 defendant Derby William esq 597884 597884 Derby, William, of Bennyngton, esq 0
4202921 2096567 2096567 defendant Pigott John, junior maltman 597884 597884 Pigott, John, junior, of Bennyngton, maltman 0
4220248 2102587 2102587 defendant Massime or Massune Haukin yeoman 597884 597884 Massime or Massune, Haukin, of Bennyngton, yeoman 0
4220252 2102588 2102588 defendant Massune Haukin yeoman 597884 597884 Massune, Haukin, of Bennyngton, yeoman 0
4220256 2102589 2102589 defendant Piggott John, senior maltman 597884 597884 Piggott, John, senior, of Bennyngton, maltman 0
4220259 2102590 2102590 defendant Piggott John, senior maltman 597884 597884 Piggott, John, senior, of Bennyngton, maltman 0
4277763 2122147 2122147 defendant Foster Edward   597884 597884 Foster, Edward, of Bennyngton, malt carrier 0
4277764 2122147 2122147 defendant Marston William   597884 597884 Marston, William, of Bennyngton, malt carrier 1
4279107 2122623 2122623 defendant Marston William maltman 597884 597884 Marston, William, of Bennyngton, maltman 0
4279109 2122623 2122623 defendant Chapman John maltman 597884 597884 Chapman, John, of Bennyngton, maltman 2
4279396 2122716 2122716 defendant Coe Christopher yeoman 597884 597884 Coe, Christopher, of Bennyngton, yeoman 1
4279404 2122718 2122718 defendant Kente William yeoman 597884 597884 Kente, William, of Bennyngton, yeoman 0
4279405 2122718 2122718 defendant Cowper Richard yeoman 597884 597884 Cowper, Richard, of Bennyngton, yeoman 1
4279406 2122718 2122718 defendant Walker William yeoman 597884 597884 Walker, William, of Bennyngton, yeoman 2
4279653 2122801 2122801 defendant Marston William   597884 597884 Marston, William, of Bennyngton, malt carrier 0
4282780 2123882 2123882 defendant Marson or Marston Henry yeoman 597884 597884 Marson or Marston, Henry, of Bennyngton, yeoman 0
4286802 2125334 2125334 defendant Smyth William yeoman 597884 597884 Smyth, William, of Bennyngton, yeoman 0
4288109 2125796 2125796 defendant Brotherton Geoffrey (legal representative) 597884 597884 Brotherton, Geoffrey, of Bennyngton, yeoman, administratrix of 1
4288110 2125796 2125796 defendant Brotherton Leticia widow 597884 597884 Brotherton, Leticia, of Bennyngton, widow 2
4293819 2127857 2127857 defendant Kent John yeoman 597884 597884 Kent, John, of Bennyngton, yeoman 0
4293944 2127908 2127908 defendant Kent John yeoman 597884 597884 Kent, John, of Bennyngton, yeoman 0
4314099 2135040 2135040 defendant Pyckett or Pygett John maltman 597884 597884 Pyckett or Pygett, John, of Bennyngton, maltman 0
4314100 2135040 2135040 defendant Pyckett or Pygett Robert maltman 597884 597884 Pyckett or Pygett, Robert, of Bennyngton, maltman 1
4314101 2135040 2135040 defendant Merson Henry yeoman 597884 597884 Merson, Henry, of Bennyngton, yeoman 2
4347370 2146335 2146335 defendant Marson John yeoman 597884 597884 Marson, John, of Bennyngton, yeoman 1
4394155 2162644 2162644 defendant Walker William maltman 597884 597884 Walker, William, of Bennyngton, maltman 1
4400922 2164900 2164900 defendant Walker Edward yeoman 597884 597884 Walker, Edward, of Bennyngton, yeoman 0
4400923 2164900 2164900 defendant Sue Thomas yeoman 597884 597884 Sue, Thomas, of Bennyngton, yeoman 1
4403025 2165599 2165599 defendant Odye alias Hoye Edward mercer 597884 597884 Odye alias Hoye, Edward, of Bennyngton, mercer 0
4404770 2166160 2166160 defendant Shepparde John maltman 597884 597884 Shepparde, John, of Bennyngton, maltman 2
4411229 2168342 2168342 defendant Coo Christopher gent 597884 597884 Coo, Christopher, of Bennyngton, gent 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);