names

230 rows where place_id = 587398

✎ 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
3591297 1864905 1864905 defendant Ippyng John gent 587398 587398 Ippyng, John, of Luton, Beds, gent 0
3605209 1869296 1869296 defendant Mannyngham Thomas tailor 587398 587398 Mannyngham, Thomas, of Luton, Beds, tailor 0
3607987 1870150 1870150 plaintiff Smyth Thomas   587398 587398 Smyth, Thomas, of Luton, Beds, collar maker 0
3616553 1872813 1872813 defendant Norres Valentine husbandman 587398 587398 Norres, Valentine, of Luton, Beds, husbandman 0
3627312 1903391 1903391 defendant Parker William gent 587398 587398 Parker, William, of Luton, Beds, gent 0
3638786 1906950 1906950 defendant Parker William gent 587398 587398 Parker, William, of Luton, Beds, gent 0
3652924 1911241 1911241 defendant Harenkok alias Arencoke William chapman 587398 587398 Harenkok alias Arencoke, William, of Luton, Beds, chapman 0
3656952 1912432 1912432 defendant Peratt Thomas yeoman 587398 587398 Peratt, Thomas, of Luton, Beds, yeoman 0
3657947 1912736 1912736 defendant Blakhed Thomas chapman 587398 587398 Blakhed, Thomas, of Luton, Beds, chapman 2
3661792 1913969 1913969 defendant Blakehede alias Oveat Richard mercer 587398 587398 Blakehede alias Oveat, Richard, of Luton, Beds, mercer 0
3661794 1913970 1913970 defendant Blakehede Richard mercer 587398 587398 Blakehede, Richard, of Luton, Beds, mercer 0
3663391 1914474 1914474 defendant Parker William gent 587398 587398 Parker, William, of Luton, Beds, gent 1
3688229 1922469 1922469 defendant Smyth Robert yeoman 587398 587398 Smyth, Robert, of Luton, Beds, yeoman 0
3700488 1926392 1926392 defendant Spayne Barnard yeoman 587398 587398 Spayne, Barnard, of Luton, Beds, yeoman 0
3702781 1927143 1927143 defendant Parker William gent 587398 587398 Parker, William, of Luton, Beds, gent 0
3703094 1927242 1927242 defendant Smyth Robert yeoman 587398 587398 Smyth, Robert, of Luton, Beds, yeoman 0
3715387 1931098 1931098 plaintiff Bukmaster John (legal representative) 587398 587398 Bukmaster, John, of Luton, Beds, executors of 0
3716550 1931472 1931472 defendant Parker William gent 587398 587398 Parker, William, of Luton, Beds, gent 0
3720879 1932826 1932826 defendant Felde William husbandman 587398 587398 Felde, William, of Luton, Beds, husbandman 1
3720882 1932827 1932827 defendant Felde William husbandman 587398 587398 Felde, William, of Luton, Beds, husbandman 1
3721234 1932942 1932942 defendant Tyler John butcher 587398 587398 Tyler, John, of Luton, Beds, butcher 4
3723381 1933582 1933582 plaintiff Parrott John   587398 587398 Parrott, John, of Luton, Beds 0
3723386 1933583 1933583 plaintiff Parrott John   587398 587398 Parrott, John, of Luton, Beds 0
3732128 1936283 1936283 defendant Parker William gent 587398 587398 Parker, William, of Luton, Beds, gent 0
3750969 1942228 1942228 defendant Daldern Robert yeoman 587398 587398 Daldern, Robert, of Luton, Beds, yeoman 0
3766669 1947237 1947237 defendant Ordwey John maltman 587398 587398 Ordwey, John, of Luton, Beds, maltman 0
3768312 1947731 1947731 defendant Parker William gent 587398 587398 Parker, William, of Luton, Beds, gent 1
3768498 1947800 1947800 plaintiff Perott John   587398 587398 Perott, John, of Luton, Beds 0
3771021 1948624 1948624 defendant Perott John maltman 587398 587398 Perott, John, of Luton, Beds, maltman 0
3772821 1949191 1949191 defendant Ordewey Thomas maltman 587398 587398 Ordewey, Thomas, of Luton, Beds, maltman 3
3773289 1949355 1949355 defendant Berbour Roger yeoman 587398 587398 Berbour, Roger, of Luton, Beds, yeoman 0
3774184 1949639 1949639 defendant Wellys Edward maltman 587398 587398 Wellys, Edward, of Luton, Beds, maltman 0
3777689 1950770 1950770 defendant Parker William gent 587398 587398 Parker, William, of Luton, Beds, gent 0
3791093 1955048 1955048 defendant Barbour Roger yeoman 587398 587398 Barbour, Roger, of Luton, Beds, yeoman 0
3793155 1955718 1955718 defendant Parker William gent 587398 587398 Parker, William, of Luton, Beds, gent 1
3798548 1957450 1957450 defendant Chester John glover 587398 587398 Chester, John, of Luton, Beds, glover 1
3798551 1957451 1957451 defendant Chester John glover 587398 587398 Chester, John, of Luton, Beds, glover 1
3802691 1958736 1958736 defendant Rotherham George gent 587398 587398 Rotherham, George, of Luton, Beds, gent 0
3803564 1959022 1959022 defendant Parkar William gent 587398 587398 Parkar, William, of Luton, Beds, gent 1
3812021 1961668 1961668 defendant Parker William gent 587398 587398 Parker, William, of Luton, Beds, gent 0
3819036 1963845 1963845 defendant Chester John glover 587398 587398 Chester, John, of Luton, Beds, glover 1
3821303 1964554 1964554 defendant Chamfeld John maltman 587398 587398 Chamfeld, John, of Luton, Beds, maltman 0
3822497 1964934 1964934 defendant Parker William gent 587398 587398 Parker, William, of Luton, Beds, gent 0
3822799 1965036 1965036 defendant Wye Edward maltman 587398 587398 Wye, Edward, of Luton, Beds, maltman 1
3824985 1965687 1965687 defendant Munde William cordwainer 587398 587398 Munde, William, of Luton, Beds, cordwainer 0
3840056 1970459 1970459 defendant Hancokys William (legal representative) 587398 587398 Hancokys, William, of Luton, Beds, yeoman, administratrix of 0
3853596 1974751 1974751 defendant Hawtre John gent 587398 587398 Hawtre, John, of Luton, Beds, gent 0
3853598 1974752 1974752 defendant Hawtre John gent 587398 587398 Hawtre, John, of Luton, Beds, gent 0
3859212 1976574 1976574 defendant Lawrens John maltman 587398 587398 Lawrens, John, of Luton, Beds, maltman 0
3869732 1980115 1980115 defendant Parett John husbandman 587398 587398 Parett, John, of Luton, Beds, husbandman 0
3879819 1983507 1983507 defendant Gylle John tailor 587398 587398 Gylle, John, of Luton, Beds, tailor 0
3885203 1985303 1985303 plaintiff Barbor Roger maltman 587398 587398 Barbor, Roger, of Luton, Beds, maltman 0
3885215 1985307 1985307 plaintiff Barbour Roger maltman 587398 587398 Barbour, Roger, of Luton, Beds, maltman 0
3898644 1989754 1989754 defendant Sibley John husbandman 587398 587398 Sibley, John, of Luton, Beds, husbandman 0
3898763 1989789 1989789 defendant Barbar Roger tanner 587398 587398 Barbar, Roger, of Luton, Beds, tanner 4
3898950 1989853 1989853 plaintiff Barbor Roger, junior maltman 587398 587398 Barbor, Roger, junior, of Luton, Beds, maltman 0
3900231 1990304 1990304 defendant Gifford Henry husbandman 587398 587398 Gifford, Henry, of Luton, Beds, husbandman 0
3900780 1990489 1990489 plaintiff Cawnfeld John miller 587398 587398 Cawnfeld, John, of Luton, beds, miller 0
3906533 1992478 1992478 defendant Gyll Margery widow 587398 587398 Gyll, Margery, of Luton, Beds, widow 1
3913076 1994703 1994703 plaintiff Barbor Roger, junior maltman 587398 587398 Barbor, Roger, junior, of Luton, Beds, maltman 0
3916658 1995945 1995945 defendant Manyngham Thomas draper 587398 587398 Manyngham, Thomas, of Luton, Beds, draper 0
3921748 1997618 1997618 plaintiff Deremere Joan   587398 587398 Deremere, Joan, of Luton, Beds 2
3921752 1997619 1997619 plaintiff Deremere Joan   587398 587398 Deremere, Joan, of Luton, Beds 2
3949880 2007033 2007033 defendant Thrale Michael gent 587398 587398 Thrale, Michael, of Luton, Beds, gent 0
3950503 2007254 2007254 defendant Cawmfeld John yeoman 587398 587398 Cawmfeld, John, of Luton, Beds, yeoman 0
3965156 2012422 2012422 defendant Smyth Robert yeoman 587398 587398 Smyth, Robert, of Luton, Beds, yeoman 0
3981007 2017966 2017966 plaintiff Preston William maltman 587398 587398 Preston, William, of Luton, Beds, maltman 0
4001558 2025337 2025337 defendant Steppinge Robert chapman 587398 587398 Steppinge, Robert, of Luton, Beds, chapman 0
4007520 2027473 2027473 defendant Thrale Richard husbandman 587398 587398 Thrale, Richard, of Luton, Beds, husbandman 0
4010776 2028632 2028632 defendant Spane Valentine yeoman 587398 587398 Spane, Valentine, of Luton, Beds, yeoman 2
4011420 2028862 2028862 defendant Shercok John barber 587398 587398 Shercok, John, of Luton, Beds, barber 2
4013226 2029463 2029463 plaintiff Robyns Thomas maltman 587398 587398 Robyns, Thomas, of Luton, Beds, maltman 0
4039075 2038601 2038601 defendant Bigges William yeoman 587398 587398 Bigges, William, of Luton, Beds, yeoman 0
4039079 2038602 2038602 defendant Bigges William yeoman 587398 587398 Bigges, William, of Luton, Beds, yeoman 0
4043745 2040216 2040216 plaintiff Preston William maltman 587398 587398 Preston, William, of Luton, Beds, maltman 0
4046773 2041301 2041301 plaintiff Smythe Robert yeoman 587398 587398 Smythe, Robert, of Luton, Beds, yeoman 0
4046775 2041302 2041302 plaintiff Smythe Robert yeoman 587398 587398 Smythe, Robert, of Luton, Beds, yeoman 0
4068281 2048956 2048956 defendant Todd Thomas smith 587398 587398 Todd, Thomas, of Luton, Beds, smith 1
4080240 2053243 2053243 defendant Monke Richard yeoman 587398 587398 Monke, Richard, of Luton, beds, yeoman 0
4111106 2064226 2064226 defendant Camfeld Thomas maltman 587398 587398 Camfeld, Thomas, of Luton, Beds, maltman 0
4123121 2068566 2068566 defendant Steppinge Humphrey draper 587398 587398 Steppinge, Humphrey, of Luton, Beds, draper 0
4179185 2088194 2088194 defendant Styllynge Humphrey chapman 587398 587398 Styllynge, Humphrey, of Luton, Beds, chapman 2
4205876 2097599 2097599 defendant Steppinge Humphrey chapman 587398 587398 Steppinge, Humphrey, of Luton, Beds, chapman 1
4213823 2100352 2100352 defendant Stepynge Humphrey yeoman 587398 587398 Stepynge, Humphrey, of Luton, Beds, yeoman 0
4231380 2106476 2106476 defendant Palmer James (legal representative) 587398 587398 Palmer, James, of Luton, Beds, chapman, administrator of 3
4263202 2117357 2117357 defendant Palmer James (legal representative) 587398 587398 Palmer, James, of Luton, Beds, chapman, administrator of 3
4266900 2118572 2118572 defendant Everet Richard yeoman 587398 587398 Everet, Richard, of Luton, Beds, yeoman 1
4349325 2147026 2147026 defendant Atwood Thomas yeoman 587398 587398 Atwood, Thomas, of Luton, Beds, yeoman 1
4351854 2147889 2147889 defendant Hawkyns John yeoman 587398 587398 Hawkyns, John, of Luton, Beds, yeoman 0
4521010 2206906 2206906 defendant atte Welle Ellis   587398 587398 atte Welle, Ellis, of Luton, Beds 0
4521014 2206907 2206907 defendant atte Welle Ellis   587398 587398 atte Welle, Ellis, of Luton, Beds 0
4666749 2255329 2255329 defendant Broyere William maltman 587398 587398 Broyere, William, of Luton, Beds, maltman 1
4672084 2256917 2256917 defendant Lammare William, junior husbandman 587398 587398 Lammare, William, junior, of Luton, Beds, husbandman 1
4672090 2256918 2256918 defendant Lammare William, junior husbandman 587398 587398 Lammare, William, junior, of Luton, Beds, husbandman 1
4686148 2261262 2261262 defendant Stoppesley Alexander gent 587398 587398 Stoppesley, Alexander, of Luton, Beds, gent 0
4690493 2262585 2262585 defendant Bedel John fisher 587398 587398 Bedel, John, of Luton, Beds, fisher 4
4690499 2262586 2262586 defendant Bodel John fisher 587398 587398 Bodel, John, of Luton, Beds, fisher 4
4690501 2262587 2262587 defendant Jurdan John tailor 587398 587398 Jurdan, John, of Luton, Beds, tailor 0
4690507 2262588 2262588 defendant Jurdan John tailor 587398 587398 Jurdan, John, of Luton, Beds, tailor 0
4766721 2285581 2285581 defendant Vale John yeoman 587398 587398 Vale, John, of Luton, Beds, yeoman 0

Next page

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);