names

72 rows where place_id = 599941

✎ 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
3638966 1907009 1907009 defendant Alee John gent 599941 599941 Alee, John, of Kegworth, gent 0
3639766 1907246 1907246 defendant Sutton William husbandman 599941 599941 Sutton, William, of Kegworth, husbandman 0
3648966 1910063 1910063 defendant Parys William husbandman 599941 599941 Parys, William, of Kegworth, husbandman 0
3648968 1910064 1910064 defendant Sutton Robert husbandman 599941 599941 Sutton, Robert, of Kegworth, husbandman 0
3670823 1916840 1916840 defendant Parysse William yeoman 599941 599941 Parysse, William, of Kegworth, yeoman 0
3670824 1916840 1916840 defendant Federston Thomas yeoman 599941 599941 Federston, Thomas, of Kegworth, yeoman 1
3696951 1925269 1925269 defendant Shepparte John gent 599941 599941 Shepparte, John, of Kegworth, gent 0
3721337 1932981 1932981 defendant Hancok William husbandman 599941 599941 Hancok, William, of Kegworth, husbandman 1
3721338 1932981 1932981 defendant Lambard Richard husbandman 599941 599941 Lambard, Richard, of Kegworth, husbandman 2
3726826 1934660 1934660 defendant Shepard Elizabeth widow 599941 599941 Shepard, Elizabeth, of Kegworth, widow 0
3726827 1934660 1934660 defendant Shepard Thomas yeoman 599941 599941 Shepard, Thomas, of Kegworth, yeoman 1
3763716 1946297 1946297 defendant Leell Thomas husbandman 599941 599941 Leell, Thomas, of Kegworth, husbandman 1
3763717 1946297 1946297 defendant Hancokes William husbandman 599941 599941 Hancokes, William, of Kegworth, husbandman 2
3773013 1949262 1949262 defendant Sutton Robert husbandman 599941 599941 Sutton, Robert, of Kegworth, husbandman 0
3773014 1949262 1949262 defendant Dod Thomas husbandman 599941 599941 Dod, Thomas, of Kegworth, husbandman 1
3773015 1949262 1949262 defendant Sutton John husbandman 599941 599941 Sutton, John, of Kegworth, husbandman 2
3773016 1949262 1949262 defendant Wodhowse John husbandman 599941 599941 Wodhowse, John, of Kegworth, husbandman 3
3798496 1957431 1957431 defendant Spencer John husbandman 599941 599941 Spencer, John, of Kegworth, husbandman 0
3798498 1957431 1957431 defendant Wodehowse John yeoman 599941 599941 Wodehowse, John, of Kegworth, yeoman 2
3798499 1957431 1957431 defendant Parys Thomas (legal representative) 599941 599941 Parys, Thomas, of Kegworth, executrix of 3
3798500 1957431 1957431 defendant Pares Joyce widow 599941 599941 Pares, Joyce, of Kegworth, widow 4
3823240 1965183 1965183 defendant Wodhouse John yeoman 599941 599941 Wodhouse, John, of Kegworth, yeoman 0
3823242 1965184 1965184 defendant Wodhouse John yeoman 599941 599941 Wodhouse, John, of Kegworth, yeoman 0
3845161 1972047 1972047 defendant Lee John yeoman 599941 599941 Lee, John, of Kegworth, yeoman 0
3845162 1972047 1972047 defendant Lee Martin gent 599941 599941 Lee, Martin, of Kegworth, gent 1
3845164 1972048 1972048 defendant Lee John yeoman 599941 599941 Lee, John, of Kegworth, yeoman 0
3845165 1972048 1972048 defendant Lee Martin gent 599941 599941 Lee, Martin, of Kegworth, gent 1
3849286 1973369 1973369 defendant Elton John gent 599941 599941 Elton, John, of Kegworth, gent 0
3849288 1973370 1973370 defendant Helton John gent 599941 599941 Helton, John, of Kegworth, gent 0
3864391 1978288 1978288 defendant Helton John gent 599941 599941 Helton, John, of Kegworth, gent 0
3922631 1997885 1997885 defendant Lee Bartholomew yeoman 599941 599941 Lee, Bartholomew, of Kegworth, yeoman 1
3922632 1997885 1997885 defendant Hyll William husbandman 599941 599941 Hyll, William, of Kegworth, husbandman 2
3922633 1997885 1997885 defendant Sutton John husbandman 599941 599941 Sutton, John, of Kegworth, husbandman 3
4047725 2041633 2041633 defendant Ramkyn alias Rampton John clerk 599941 599941 Ramkyn alias Rampton, John, of Kegworth, clerk 0
4047726 2041633 2041633 defendant Olrenshawe Thomas husbandman 599941 599941 Olrenshawe, Thomas, of Kegworth, husbandman 1
4047727 2041633 2041633 defendant Burton John husbandman 599941 599941 Burton, John, of Kegworth, husbandman 2
4047983 2041724 2041724 defendant Oldeshawe Thomas husbandman 599941 599941 Oldeshawe, Thomas, of Kegworth, husbandman 1
4299829 2130029 2130029 defendant Stone John husbandman 599941 599941 Stone, John, of Kegworth, husbandman 0
4608253 2233690 2233690 defendant Sutton William de   599941 599941 Sutton, William de, of Kegworth, son of William, senior 1
4669411 2256141 2256141 defendant Walker John husbandman 599941 599941 Walker, John, of Kegworth, husbandman 1
4687974 2261807 2261807 plaintiff Sutton William   599941 599941 Sutton, William, of Kegworth 0
4694640 2263820 2263820 defendant Walker John   599941 599941 Walker, John, of Kegworth 2
4696785 2264473 2264473 plaintiff Chauntre Thomas   599941 599941 Chauntre, Thomas, of Kegworth 0
4696787 2264474 2264474 plaintiff Chauntre Thomas   599941 599941 Chauntre, Thomas, of Kegworth, parson 0
4702702 2266246 2266246 defendant Walker John husbandman 599941 599941 Walker, John, of Kegworth, husbandman 0
4730770 2274825 2274825 plaintiff Wymondham Thomas   599941 599941 Wymondham, Thomas, of Kegworth, parson 1
4744524 2278924 2278924 defendant Walker John husbandman 599941 599941 Walker, John, of Kegworth, husbandman 1
4775873 2288455 2288455 defendant Sutton William gent 599941 599941 Sutton, William, of Kegworth, gent 1
4777804 2289047 2289047 defendant Bakewell John husbandman 599941 599941 Bakewell, John, of Kegworth, husbandman 2
4801814 2296749 2296749 defendant Sutton William gent 599941 599941 Sutton, William, of Kegworth, gent 1
4853937 2312643 2312643 plaintiff Wymondham Thomas   599941 599941 Wymondham, Thomas, of Kegworth, parson 0
4853943 2312644 2312644 plaintiff Wymondham Thomas   599941 599941 Wymondham, Thomas, of Kegworth, parson 0
4853949 2312645 2312645 plaintiff Wymondham Thomas   599941 599941 Wymondham, Thomas, of Kegworth, parson 0
4853955 2312646 2312646 plaintiff Wymundham Thomas   599941 599941 Wymundham, Thomas, of Kegworth, parson 0
4987727 2353293 2353293 defendant Ellerton John   599941 599941 Ellerton, John, of Kegworth, Leics yeoman 1
5003406 2357893 2357893 defendant Brigge Thomas yeoman 599941 599941 Brigge, Thomas, of Kegworth, yeoman 0
5003407 2357893 2357893 defendant Brigge Thomas laborer 599941 599941 Brigge, Thomas, of Kegworth, laborer 1
5061432 2375009 2375009 defendant Parlebien Richard husbandman 599941 599941 Parlebien, Richard, of Kegworth, husbandman 0
5061434 2375009 2375009 defendant Wale William weaver 599941 599941 Wale, William, of Kegworth, weaver 2
5127911 2394641 2394641 defendant Bekyswyth Randolf yeoman 599941 599941 Bekyswyth, Randolf, of Kegworth, yeoman 0
5137473 2397471 2397471 defendant Stot John yeoman 599941 599941 Stot, John, of Kegworth, yeoman 1
5137477 2397472 2397472 defendant (illegible) John yeoman 599941 599941 ----, John, of kegworth, yeoman 1
5216671 2420611 2420611 defendant Smyth John yeoman 599941 599941 Smyth, John, of Kegworth, yeoman 0
5335757 2455759 2455759 defendant Rampyn William husbandman 599941 599941 Rampyn, William, of Kegworth, husbandman 0
5459426 2492732 2492732 defendant Stokes Thomas esq 599941 599941 Stokes, Thomas, of Kegworth, esq 0
5471152 2496307 2496307 defendant Stokes Thomas esq 599941 599941 Stokes, Thomas, of Kegworth, esq 0
5474318 2497297 2497297 defendant Sutton Thomas yeoman 599941 599941 Sutton, Thomas, of Kegworth, yeoman 0
5575644 2527470 2527470 defendant Grene William yeoman 599941 599941 Grene, William, of Kegworth, yeoman 1
5607127 2537118 2537118 defendant Nicholas Alvared sherman 599941 599941 Nicholas, Alvared, of Kegworth, sherman 0
5607350 2537191 2537191 defendant Nycholas Alvered sherman 599941 599941 Nycholas, Alvered, of Kegworth, sherman 0
5632233 2554107 2554107 defendant Sutton William gent 599941 599941 Sutton, William, of Kegworth, gent 0
5637051 2555538 2555538 defendant Walker John walker 599941 599941 Walker, John, of Kegworth, walker 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);