names

30 rows where place_id = 602161

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3648718 1909986 1909986 defendant Dey John clerk 602161 602161 Dey, John, of Chipenham, clerk 0
3648719 1909986 1909986 defendant Browne Nicholas yeoman 602161 602161 Browne, Nicholas, of Chipenham, yeoman 1
3680286 1919909 1919909 defendant Dyxe John husbandman 602161 602161 Dyxe, John, of Chipenham, husbandman 1
4001783 2025414 2025414 defendant Russe Thomas butcher 602161 602161 Russe, Thomas, of Chipenham, butcher 1
4023779 2033207 2033207 plaintiff Baynton Edward esq 602161 602161 Baynton, Edward, of Chipenham, esq 0
4197848 2094798 2094798 defendant Snell or Suell John esq 602161 602161 (Snell or Suell, John, of Chipenham, esq 4
4234433 2107583 2107583 defendant Cogeswell Thomas husbandman 602161 602161 Cogeswell, Thomas, of Chipenham, husbandman 2
4234439 2107584 2107584 defendant Cogeswell Thomas husbandman 602161 602161 Cogeswell, Thomas, of Chipenham, husbandman 2
4359481 2150549 2150549 defendant Bawlden Eleanor widow 602161 602161 Bawlden, Eleanor, of Chipenham, widow 1
4824859 2303811 2303811 defendant Warner John yeoman 602161 602161 Warner, John, of Chipenham, yeoman 2
4868535 2317133 2317133 defendant Taillour David tailor 602161 602161 Taillour, David, of Chipenham, tailor 3
4965196 2346517 2346517 defendant Poperyke John   602161 602161 Poperyke, John, of Chipenham, holy water clerk 0
4965197 2346517 2346517 defendant Lak John laborer 602161 602161 Lak, John, of Chipenham, laborer 1
4965199 2346517 2346517 defendant Hervy Thomas husbandman 602161 602161 Hervy, Thomas, of Chipenham, husbandman 3
4965200 2346517 2346517 defendant Hervy John husbandman 602161 602161 Hervy, John, of Chipenham, husbandman 4
4965201 2346517 2346517 defendant Norman William husbandman 602161 602161 Norman, William, of Chipenham, husbandman 5
4965202 2346517 2346517 defendant Baker John husbandman 602161 602161 Baker, John, of Chipenham, husbandman 6
4965203 2346517 2346517 defendant Berford John husbandman 602161 602161 Berford, John, of Chipenham, husbandman 7
4965204 2346517 2346517 defendant Cate John husbandman 602161 602161 Cate, John, of Chipenham, husbandman 8
4965205 2346517 2346517 defendant Pygot Thomas husbandman 602161 602161 Pygot, Thomas, of Chipenham, husbandman 9
4965206 2346517 2346517 defendant Asshele John husbandman 602161 602161 Asshele, John, of Chipenham, husbandman 10
4965207 2346517 2346517 defendant Blaker John husbandman 602161 602161 Blaker, John, of Chipenham, husbandman 11
4965208 2346517 2346517 defendant Hakka John husbandman 602161 602161 Hakka, John, of Chipenham, husbandman 12
4965209 2346517 2346517 defendant Busshell Robert husbandman 602161 602161 Busshell, Robert, of Chipenham, husbandman 13
4965210 2346517 2346517 defendant Smyth Adam husbandman 602161 602161 Smyth, Adam, of Chipenham, husbandman 14
4965211 2346517 2346517 defendant Lak John husbandman 602161 602161 Lak, John, of Chipenham, husbandman 15
5260430 2433393 2433393 defendant Harryes John husbandman 602161 602161 Harryes, John, of Chipenham, husbandman 0
5286187 2440970 2440970 defendant Harrys William gent 602161 602161 Harrys, William, of Chipenham, gent 1
5319237 2450847 2450847 defendant Fenne John husbandman 602161 602161 Fenne, John, of Chipenham, husbandman 1
5345500 2458765 2458765 defendant Harryes William yeoman 602161 602161 Harryes, William, of Chipenham, yeoman 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);