names

80 rows where place_id = 601795

✎ 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
3647062 1909475 1909475 defendant Smyth Thomas yeoman 601795 601795 Smyth, Thomas, of New Sleford, yeoman 0
3647063 1909475 1909475 defendant Geffrey William yeoman 601795 601795 Geffrey, William, of New Sleford, yeoman 1
3647257 1909528 1909528 defendant Smyth Thomas yeoman 601795 601795 Smyth, Thomas, of New Sleford, yeoman 0
3647258 1909528 1909528 defendant Geffrey William yeoman 601795 601795 Geffrey, William, of New Sleford, yeoman 1
3647259 1909528 1909528 defendant Chapman John yeoman 601795 601795 Chapman, John, of New Sleford, yeoman 2
3656342 1912229 1912229 plaintiff Carre George gent 601795 601795 Carre, George, of New Sleford, gent 0
3656346 1912230 1912230 plaintiff Carre George gent 601795 601795 Carre, George, of New Sleford, gent 0
3671015 1916907 1916907 plaintiff Carre George (legal representative) 601795 601795 Carre, George, of New Sleford, gent, executors of 0
3671021 1916908 1916908 plaintiff Carre George (legal representative) 601795 601795 Carre, George, of New Sleford, gent, executors of 0
3671027 1916909 1916909 plaintiff Carre George (legal representative) 601795 601795 Carre, George, of New Sleford, gent, executors of 0
3671033 1916910 1916910 plaintiff Carre George (legal representative) 601795 601795 Carre, George, of New Sleford, gent, executors of 0
3671039 1916911 1916911 plaintiff Carre George (legal representative) 601795 601795 Carre, George, of New Sleford, gent, executors of 0
3671045 1916912 1916912 plaintiff Carre George (legal representative) 601795 601795 Carre, George, of New Sleford, gent, executors of 0
3687076 1922131 1922131 plaintiff Carre George (legal representative) 601795 601795 Carre, George, of New Sleford, gent, executors of 0
3687080 1922132 1922132 plaintiff Carre George (legal representative) 601795 601795 Carre, George, of New Sleford, gent, executors of 0
3687087 1922133 1922133 plaintiff Carre George (legal representative) 601795 601795 Carre, George, of New Sleford, gent, executors of 0
3691702 1923564 1923564 defendant Gybbe Robert (legal representative) 601795 601795 Gybbe, Robert, of New Sleford, mercer, executrix of 3
3691703 1923564 1923564 defendant Gybbe Agnes widow 601795 601795 Gybbe, Agnes, of New Sleford, widow 4
3722733 1933377 1933377 defendant Pynder Robert tanner 601795 601795 Pynder, Robert, of New Sleford, tanner 0
3722734 1933377 1933377 defendant Gregg John corewainer 601795 601795 Gregg, John,of New Sleford, corewainer 1
3731374 1936035 1936035 plaintiff Carre Anne (legal representative) 601795 601795 Carre, Anne, of New Sleford, widow, executors of 0
3731378 1936036 1936036 plaintiff Carre Anne (legal representative) 601795 601795 Carre, Anne, of New Sleford, widow, executors of 0
3731389 1936039 1936039 plaintiff Carre Ralph   601795 601795 Carre, Ralph, of New Sleford 0
3731391 1936040 1936040 plaintiff Carre Ralph   601795 601795 Carre, Ralph, of New Sleford 0
3752450 1942689 1942689 plaintiff Rande John mercer 601795 601795 Rande, John, of New Sleford, mercer 0
3769160 1948011 1948011 plaintiff Rande John mercer 601795 601795 Rande, John, of New Sleford, mercer 0
3890891 1987218 1987218 defendant Trewell Thomas yeoman 601795 601795 Trewell, Thomas, of New Sleford, yeoman 1
3890895 1987219 1987219 defendant Trewell Thomas yeoman 601795 601795 Trewell, Thomas, of New Sleford, yeoman 1
3891826 1987517 1987517 defendant Trewell Thomas yeoman 601795 601795 Trewell, Thomas, of New Sleford, yeoman 1
3895185 1988597 1988597 defendant Adam John, senior tanner 601795 601795 Adam, John, senior, of New Sleford, tanner 0
3906560 1992488 1992488 defendant Musterluff William glover 601795 601795 Musterluff, William, of New Sleford, glover 1
3914206 1995096 1995096 defendant Trowell Thomas baker 601795 601795 Trowell, Thomas, of New Sleford, baker 0
3915246 1995462 1995462 defendant Trewell Thomas baker 601795 601795 Trewell, Thomas, of New Sleford, baker 0
3919558 1996873 1996873 defendant Wryght Thomas baker 601795 601795 Wryght, Thomas, of New Sleford, baker 0
3922836 1997939 1997939 defendant Welles Thomas yeoman 601795 601795 Welles, Thomas, of New Sleford, yeoman 0
3922837 1997939 1997939 defendant Broune Richard yeoman 601795 601795 Broune, Richard, of New Sleford, yeoman 1
3922959 1997986 1997986 defendant Baynbrygge Edmund yeoman 601795 601795 Baynbrygge, Edmund, of New Sleford, yeoman 0
3932387 2001125 2001125 defendant Braune Richard   601795 601795 Braune, Richard, of New Sleford, inn holder 1
3942548 2004517 2004517 defendant Palfreman Arthur mercer 601795 601795 Palfreman, Arthur, of New Sleford, mercer 1
3942549 2004517 2004517 defendant Nayler Ralph   601795 601795 Nayler, Ralph, of New Sleford, shoe maker 2
3996796 2023619 2023619 plaintiff Dobledaye William draper 601795 601795 Dobledaye, William, of New Sleford, draper 0
4137620 2073807 2073807 defendant Huggyn Clement butcher 601795 601795 Huggyn, Clement, of New Sleford, butcher 0
4137622 2073808 2073808 defendant Turner Robert   601795 601795 Turner, Robert, of New Sleford, linen draper 0
4216750 2101352 2101352 defendant Carr Henry tanner 601795 601795 Carr, Henry, of New Sleford, tanner 1
4216753 2101353 2101353 defendant Carr Henry tanner 601795 601795 Carr, Henry, of New Sleford, tanner 1
4235804 2108093 2108093 defendant Carre Edward esq 601795 601795 Carre, Edward, of New Sleford, esq 0
4244443 2111121 2111121 defendant Carre Edward esq 601795 601795 Carre, Edward, of New Sleford, esq 0
4656669 2247981 2247981 defendant Kyng William husbandman 601795 601795 Kyng, William, of New Sleford, husbandman 1
4782957 2290690 2290690 defendant Wodecok Robert husbandman 601795 601795 Wodecok, Robert, of New Sleford, husbandman 3
4782958 2290690 2290690 defendant Angulsey William husbandman 601795 601795 Angulsey, William, of New Sleford, husbandman 4
4786854 2291947 2291947 defendant Barker John Michell husbandman 601795 601795 Barker, John Michell, of New Sleford, husbandman 0
4813529 2300340 2300340 defendant Sanderson John   601795 601795 Sanderson, John, of New Sleford, wright 1
4814493 2300641 2300641 defendant Quyncy John butcher 601795 601795 Quyncy, John, of New Sleford, butcher 0
4819069 2302048 2302048 defendant Coksele John husbandman 601795 601795 Coksele, John, of New Sleford, husbandman 0
4822491 2303107 2303107 defendant Quyncy John butcher 601795 601795 Quyncy, John, of New Sleford, butcher 0
4835835 2307198 2307198 defendant Chapeleyn John yeoman 601795 601795 Chapeleyn, John, of New Sleford, yeoman 0
4878969 2320354 2320354 defendant Bollond Peter husbandman 601795 601795 Bollond, Peter, of New Sleford, husbandman 0
4887359 2322881 2322881 defendant Chapeleyn John yeoman 601795 601795 Chapeleyn, John, of New Sleford, yeoman 0
4887959 2323041 2323041 defendant Bysshop William yeoman 601795 601795 Bysshop, William, of New Sleford, yeoman 4
4887960 2323041 2323041 defendant Sesse Robert currier 601795 601795 Sesse, Robert, of New Sleford, currier 5
4887961 2323041 2323041 defendant Payntour John yeoman 601795 601795 Payntour, John, of New Sleford, yeoman 6
4909953 2329638 2329638 defendant Howsewryght John milner 601795 601795 Howsewryght, John, of New Sleford, milner 0
4930395 2335906 2335906 defendant Chapeleyn John yeoman 601795 601795 Chapeleyn, John, of New Sleford, yeoman 0
4955833 2343714 2343714 defendant Chapeleyn John yeoman 601795 601795 Chapeleyn, John, of New Sleford, yeoman 0
4967904 2347345 2347345 defendant Broun John laborer 601795 601795 Broun, John, of New Sleford, laborer 3
5060194 2374621 2374621 defendant Bartylmewe Thomas fisher 601795 601795 Bartylmewe, Thomas, of New Sleford, fisher 0
5060509 2374722 2374722 defendant Norwode William yeoman 601795 601795 Norwode, William, of New Sleford, yeoman 0
5113762 2390419 2390419 defendant Cokfeld Robert barker 601795 601795 Cokfeld, Robert, of New Sleford, barker 1
5208933 2418341 2418341 defendant Stoneham John yeoman 601795 601795 Stoneham, John, of New Sleford, yeoman 0
5257357 2432424 2432424 defendant Joyse John chapman 601795 601795 Joyse, John, of New Sleford, chapman 1
5278396 2438788 2438788 defendant Coumses or Connises John weaver 601795 601795 Coumses or Connises, John, of New Sleford, weaver 0
5343293 2458097 2458097 defendant Symond John butcher 601795 601795 Symond, John, of New Sleford, butcher 0
5367045 2465341 2465341 defendant Couper John cooper 601795 601795 Couper, John, of New Sleford, cooper 0
5367047 2465341 2465341 defendant Webster William butcher 601795 601795 Webster, William, of New Sleford, butcher 2
5371618 2466710 2466710 defendant Gell Robert husbandman 601795 601795 Gell, Robert, of New Sleford, husbandman 2
5432396 2484660 2484660 defendant Appulby Robert yeoman 601795 601795 Appulby, Robert, of New Sleford, yeoman 0
5525064 2512429 2512429 defendant Theleby Robert walker 601795 601795 Theleby, Robert, of New Sleford, walker 0
5555209 2521528 2521528 defendant Goldysburgh Robert barker 601795 601795 Goldysburgh, Robert, of New Sleford, barker 0
5560339 2522986 2522986 defendant Smyth Joan widow 601795 601795 Smyth, Joan, of New Sleford, widow 1
5590873 2532118 2532118 defendant Fyssher John yeoman 601795 601795 Fyssher, John, of New Sleford, 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);