names

58 rows where place_id = 757195

✎ 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
4444084 2183123 2183123 defendant Merssh John   757195 757195 Merssh, John, of Northamptonshire 0
4455939 2186874 2186874 defendant Parles Ralph esq 757195 757195 Parles, Ralph, of Northamptonshire, esq 0
4463868 2189376 2189376 defendant Helyere John   757195 757195 Helyere, John, of Northamptonshire 2
4465326 2189829 2189829 defendant Baldeswell William   757195 757195 Baldeswell, William, of Northamptonshire 0
4484864 2195968 2195968 defendant Corby John   757195 757195 Corby, John, of Northamptonshire, son of William 1
4489973 2197575 2197575 plaintiff Twyford Thomas   757195 757195 Twyford, Thomas, of Northamptonshire 0
4500489 2200774 2200774 defendant Welton John   757195 757195 Welton, John, of Northamptonshire 1
4510624 2203779 2203779 defendant Lymbergh Richard   757195 757195 Lymbergh, Richard, of Northamptonshire 5
4510631 2203780 2203780 defendant Lymbergh Richard   757195 757195 Lymbergh, Richard, of Northamptonshire 5
4516934 2205701 2205701 defendant Raulyn Richard   757195 757195 Raulyn, Richard, of Northamptonshire 2
4516938 2205702 2205702 defendant Raulyn Richard   757195 757195 Raulyn, Richard, of Northamptonshire 2
4523327 2207618 2207618 defendant Chambre John   757195 757195 Chambre, John, of Northamptonshire, knight 0
4523370 2207630 2207630 plaintiff Harwedon John   757195 757195 Harwedon, John, of Northamptonshire, fomerly sheriff 0
4545200 2214420 2214420 defendant souche John de la   757195 757195 souche, John de la, of Northamptonshire, knight 1
4549948 2215915 2215915 defendant Braunspath William esq 757195 757195 Braunspath, William, of Northamptonshire, esq 2
4556200 2217881 2217881 defendant Tame John   757195 757195 Tame, John, of Northamptonshire, knight 3
4556210 2217882 2217882 defendant Tame John de   757195 757195 Tame, John de, of Northamptonshire, knight 3
4557970 2218426 2218426 defendant Walles Agnes   757195 757195 Walles, Agnes, of Northamptonshire, formerly wife of William 0
4563725 2220225 2220225 defendant Burgeys Thomas dyer 757195 757195 Burgeys, Thomas, of Northamptonshire, dyer 0
4567261 2221318 2221318 defendant Marwode John   757195 757195 Marwode, John, of Northamptonshire 0
4575341 2223801 2223801 defendant Barker John   757195 757195 Barker, John, of Northamptonshire 0
4577905 2224594 2224594 defendant Henglys Thomas   757195 757195 Henglys, Thomas, of Northamptonshire 0
4577908 2224595 2224595 defendant Henglys Thomas   757195 757195 Henglys, Thomas, of Northamptonshire 0
4580453 2225372 2225372 defendant Norwiche Simon   757195 757195 Norwiche, Simon, of Northamptonshire 2
4582551 2225985 2225985 defendant Chambre Roger   757195 757195 Chambre, Roger, of Northamptonshire 1
4582552 2225985 2225985 defendant Chaumbre William esq 757195 757195 Chaumbre, William, of Northamptonshire, esq 2
4582556 2225986 2225986 defendant Chambre Roger   757195 757195 Chambre, Roger, of Northamptonshire 1
4582557 2225986 2225986 defendant Chaumbre William esq 757195 757195 Chaumbre, William, of Northamptonshire, esq 2
4582560 2225986 2225986 defendant Chaumbre Thomas esq 757195 757195 Chaumbre, Thomas, of Northamptonshire, esq 5
4591676 2228752 2228752 defendant Blondell Simon   757195 757195 Blondell, Simon, of Northamptonshire 2
4597299 2230396 2230396 defendant Belleman John   757195 757195 Belleman, John, of Northamptonshire 3
4597308 2230397 2230397 defendant Belleman John   757195 757195 Belleman, John, of Northamptonshire 3
4598066 2230647 2230647 defendant Elger Walter   757195 757195 Elger, Walter, of Northamptonshire 1
4601632 2231727 2231727 defendant Trussell John   757195 757195 Trussell, John, of Northamptonshire, knight 0
4607535 2233470 2233470 defendant atte Vyne John   757195 757195 atte Vyne, John, of Northamptonshire 0
4609575 2234094 2234094 defendant Wermyngton John   757195 757195 Wermyngton, John, of Northamptonshire 0
4626274 2239176 2239176 defendant Richeby Thomas   757195 757195 Richeby, Thomas, of Northamptonshire 0
4635278 2241873 2241873 defendant Bodvelyn Robert esq 757195 757195 Bodvelyn, Robert, of Northamptonshire, esq 0
4641959 2243752 2243752 defendant Brakley William   757195 757195 Brakley, William, of Northamptonshire 3
4642764 2243996 2243996 defendant Caudelan Thomas   757195 757195 Caudelan, Thomas, of Northamptonshire 5
4642805 2244008 2244008 defendant Hetheryngton Richard esq 757195 757195 Hetheryngton, Richard, of Northamptonshire, esq 1
4716011 2270316 2270316 plaintiff Welton John   757195 757195 Welton, John, of Northamptonshire 0
4745893 2279304 2279304 plaintiff Gryffon Nicholas   757195 757195 Gryffon, Nicholas, of Northamptonshire 0
4846297 2310347 2310347 plaintiff Stanforde John   757195 757195 Stanforde, John, of Northamptonshire 1
4909598 2329538 2329538 plaintiff Baverey or Banerey Thomas   757195 757195 Baverey or Banerey, Thomas, of Northamptonshire 0
5046023 2370438 2370438 defendant Sulby Robert   757195 757195 Sulby, Robert, of Northamptonshire, abbot of the abbey, in 0
5129596 2395144 2395144 defendant Bartolf Thomas   757195 757195 Bartolf, Thomas, of Northamptonshire, brass worker 0
5136180 2397096 2397096 defendant Kymbell Thomas yeoman 757195 757195 Kymbell, Thomas, of Northamptonshire, yeoman 0
5136194 2397102 2397102 plaintiff Newenham William esq 757195 757195 Newenham, William, of Northamptonshire, esq 0
5141376 2398600 2398600 defendant Olyffe William gent 757195 757195 Olyffe, William, of Northamptonshire, gent 0
5197928 2415135 2415135 plaintiff Tessyngton John master 757195 757195 Tessyngton, John, of Northamptonshire, master 0
5197930 2415136 2415136 plaintiff Tessyngton John master 757195 757195 Tessyngton, John, of Northamptonshire, master 0
5210345 2418757 2418757 plaintiff Tessyngton John master 757195 757195 Tessyngton, John, of Northamptonshire, master 0
5274831 2437718 2437718 plaintiff Newman Thomas yeoman 757195 757195 Newman, Thomas, of Northamptonshire, yeoman 1
5276649 2438252 2438252 plaintiff Wolston Guy esq & sheriff 757195 757195 Wolston, Guy, of Northamptonshire, esq & sheriff 0
5308073 2447438 2447438 plaintiff Bysshop John gent 757195 757195 Bysshop, John, of Northamptonshire, gent 1
5608266 2537487 2537487 defendant Brawens John   757195 757195 Brawens, John, of Northamptonshire 0
5612456 2547645 2547645 plaintiff Carvell John former sheriff 757195 757195 Carvell, John, of Northamptonshire, former sheriff 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);