names

246 rows where place_id = 586539

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588991 1864207 1864207 plaintiff Breche Richard   586539 586539 Breche, Richard, of Suthwell 0
3599095 1867353 1867353 defendant Elyngton William butcher 586539 586539 Elyngton, William, of Suthwell, butcher 1
3607564 1870024 1870024 plaintiff Samysbury Richard gent 586539 586539 Samysbury, Richard, of Suthwell, gent 0
3607621 1870040 1870040 plaintiff Saunsbury Richard gent 586539 586539 Saunsbury, Richard, of Suthwell, gent 0
3607624 1870041 1870041 plaintiff Saunsbury Richard gent 586539 586539 Saunsbury, Richard, of Suthwell, gent 0
3612252 1871467 1871467 defendant Boteler Richard yeoman 586539 586539 Boteler, Richard, of Suthwell, yeoman 0
3624344 1875148 1875148 plaintiff Tempull William   586539 586539 Tempull, William, of Suthwell 0
3636341 1906159 1906159 defendant Sandford Christopher gent 586539 586539 Sandford, Christopher, of Suthwell, gent 0
3756825 1944107 1944107 defendant Chambers Robert laborer 586539 586539 Chambers, Robert, of Suthwell, laborer 2
3756826 1944107 1944107 defendant Rolston Richard husbandman 586539 586539 Rolston, Richard, of Suthwell, husbandman 3
3765768 1946959 1946959 defendant Bend Thomas butcher 586539 586539 Bend, Thomas, of Suthwell, butcher 0
3765769 1946959 1946959 defendant Aumbre Robert butcher 586539 586539 Aumbre, Robert, of Suthwell, butcher 1
3793360 1955785 1955785 plaintiff Box James clerk 586539 586539 Box, James, of Suthwell, clerk 0
3810182 1961076 1961076 plaintiff Box James clerk 586539 586539 Box, James, of Suthwell, clerk 0
3819740 1964055 1964055 defendant Flodgen James carpenter 586539 586539 Flodgen, James, of Suthwell, carpenter 0
3819741 1964055 1964055 defendant Humfrey John chaplain 586539 586539 Humfrey, John, of Suthwell, chaplain 1
3849091 1973313 1973313 defendant Awmery Thomas butcher 586539 586539 Awmery, Thomas, of Suthwell, butcher 0
3849092 1973313 1973313 defendant Humphray John clerk 586539 586539 Humphray, John, of Suthwell, clerk 1
3856626 1975697 1975697 defendant Awmbry Robert butcher 586539 586539 Awmbry, Robert, of Suthwell, butcher 0
4339687 2143653 2143653 defendant Albon Thomas yeoman 586539 586539 Albon, Thomas, of Suthwell, or of Stanforde, Beds, yeoman 0
4420611 2171349 2171349 defendant Alvy or Alny Henry   586539 586539 Alvy or Alny, Henry, of Suthwell 0
4439772 2181715 2181715 plaintiff (not given) Robert de vicar of Barneby 586539 586539 Barneby, Robert de, of Suthwell, vicar of St Mary's church, vicar choral 0
4462224 2188881 2188881 defendant Bedwyn Thomas   586539 586539 Bedwyn, Thomas, of Suthwell 0
4496723 2199643 2199643 defendant Emyngton John   586539 586539 Emyngton, John, of Suthwell 0
4498621 2200212 2200212 plaintiff Fyssher John, junior (legal representative) 586539 586539 Fyssher, John, junior, of Suthwell, executors of 0
4498622 2200212 2200212 plaintiff Andrewe Richard   586539 586539 (Andrewe, Richard, of Suthwell, perpetual vicar 1
4498623 2200212 2200212 plaintiff Ulsby Hugh de   586539 586539 Ulsby, Hugh de, of Suthwell, vicar choral 2
4498625 2200212 2200212 plaintiff Smyth John, senior   586539 586539 Smyth, John, senior, of Suthwell 4
4498635 2200215 2200215 plaintiff Fyssher John (legal representative) 586539 586539 Fyssher, John, of Suthwell, executor of 0
4506642 2202556 2202556 defendant Rychemound John   586539 586539 Rychemound, John, of Suthwell 4
4520356 2206713 2206713 plaintiff Andrewe Richard   586539 586539 (Andrewe, Richard, of Suthwell, vicar 1
4520357 2206713 2206713 plaintiff Ulseby Hugh de   586539 586539 Ulseby, Hugh de, of Suthwell, vicar choral 2
4520359 2206713 2206713 plaintiff Smyth John, sen   586539 586539 Smyth, John, sen, of Suthwell 4
4531608 2210153 2210153 defendant Skyrlyngton John de   586539 586539 Skyrlyngton, John de, of Suthwell 2
4531619 2210154 2210154 defendant Skyrlyngton John de   586539 586539 Skyrlyngton, John de, of Suthwell 0
4533476 2210739 2210739 plaintiff Robert John clerk 586539 586539 Robert, John, of Suthwell, clerk 0
4533479 2210739 2210739 defendant Archer William   586539 586539 Archer, William, of Suthwell 0
4534339 2211006 2211006 plaintiff Sampson Robert   586539 586539 Sampson, Robert, of Suthwell 0
4550144 2215985 2215985 defendant Smyth John   586539 586539 Smyth, John, of Suthwell 1
4555849 2217772 2217772 plaintiff Hode William   586539 586539 Hode, William, of Suthwell 0
4561742 2219608 2219608 defendant Skyrlyngton John   586539 586539 Skyrlyngton, John, of Suthwell 0
4561743 2219608 2219608 defendant Leidenham John de   586539 586539 Leidenham, John de, of Suthwell 1
4564262 2220393 2220393 defendant Plansworth John   586539 586539 Plansworth, John, of Suthwell 0
4569239 2221966 2221966 plaintiff Rokeston Thomas de   586539 586539 Rokeston, Thomas de, of Suthwell, vicar choral in the church 1
4580070 2225254 2225254 defendant Enyngton Alice   586539 586539 Enyngton, Alice, of Suthwell 0
4591315 2228640 2228640 defendant Blathworth Robert tailor 586539 586539 Blathworth, Robert, of Suthwell, tailor 0
4591339 2228647 2228647 defendant Blethworth Robert tailor 586539 586539 Blethworth, Robert, of Suthwell, tailor 4
4607829 2233563 2233563 defendant Rolston Thomas chaplain 586539 586539 (Rolston, Thomas, of Suthwell, chaplain 1
4620149 2237283 2237283 defendant Bigg Thomas   586539 586539 Bigg, Thomas, of Suthwell 0
4621290 2237646 2237646 defendant Lombe William   586539 586539 Lombe, William, of Suthwell 0
4629787 2240237 2240237 defendant Chaumberleyn John   586539 586539 Chaumberleyn, John, of Suthwell 0
4630562 2240472 2240472 defendant Leddenham John de   586539 586539 Leddenham, John de, of Suthwell 0
4633774 2241415 2241415 defendant atte Crosse James   586539 586539 atte Crosse, James, of Suthwell 0
4639422 2243043 2243043 defendant Kyrkby Henry de   586539 586539 Kyrkby, Henry de, of Suthwell 3
4643555 2244217 2244217 defendant Weston James chaplain 586539 586539 Weston, James, of Suthwell, chaplain 2
4643556 2244217 2244217 defendant Shelton Thomas   586539 586539 Shelton, Thomas, of Suthwell 3
4658562 2248555 2248555 defendant Waynflete Alesia daughter of John Waynflete 586539 586539 Waynflete, Alesia, of Suthwell, gentlewoman, daughter of John Waynflete 0
4660349 2249067 2249067 defendant Hudde William butcher 586539 586539 Hudde, William, of Suthwell, butcher 0
4660351 2249068 2249068 defendant Chace John butcher 586539 586539 Chace, John, of Suthwell, butcher 0
4668057 2255716 2255716 defendant Boyll Walter draper 586539 586539 Boyll, Walter, of Suthwell, draper 0
4670991 2256597 2256597 defendant Sutton John husbandman 586539 586539 Sutton, John, of Suthwell, husbandman 0
4672884 2257160 2257160 defendant Bule Walter draper 586539 586539 Bule, Walter, of Suthwell, draper 0
4673023 2257207 2257207 defendant Russell John chaplain 586539 586539 Russell, John, of Suthwell, chaplain 2
4675803 2258040 2258040 plaintiff Frere Robert   586539 586539 Frere, Robert, of Suthwell 0
4675805 2258041 2258041 plaintiff Frere Robert   586539 586539 Frere, Robert, of Suthwell 0
4676354 2258216 2258216 defendant Boille Walter draper 586539 586539 Boille, Walter, of Suthwell, draper 0
4677713 2258645 2258645 defendant Hudde William butcher 586539 586539 Hudde, William, of Suthwell, butcher 0
4677717 2258647 2258647 defendant Overton William husbandman 586539 586539 Overton, William, of Suthwell, husbandman 0
4677861 2258689 2258689 defendant Sampson Margaret widow 586539 586539 Sampson, Margaret, of Suthwell, widow 0
4679213 2259106 2259106 defendant Snowe William tailor 586539 586539 Snowe, William, of Suthwell, tailor 3
4679415 2259178 2259178 defendant Boyle Walter draper 586539 586539 Boyle, Walter, of Suthwell, draper 0
4681902 2259956 2259956 plaintiff More John   586539 586539 More, John, of Suthwell 0
4681904 2259957 2259957 plaintiff More John   586539 586539 More, John, of Suthwell 0
4685019 2260911 2260911 defendant Hode William butcher 586539 586539 Hode, William, of Suthwell, butcher 0
4685693 2261116 2261116 plaintiff Sampson Margaret   586539 586539 Sampson, Margaret, of Suthwell, formerly wife of Robert Suthwell 0
4685697 2261116 2261116 defendant Weston James chaplain 586539 586539 Weston, James, of Suthwell, chaplain 2
4685698 2261116 2261116 defendant Hudde William butcher 586539 586539 Hudde, William, of Suthwell, butcher 3
4685699 2261116 2261116 defendant Chace John butcher 586539 586539 Chace, John, of Suthwell, butcher 4
4685700 2261116 2261116 defendant Bremes Robert husbandman 586539 586539 Bremes, Robert, of Suthwell, husbandman 5
4688602 2261997 2261997 defendant Halum Robert gent 586539 586539 Halum, Robert, of Suthwell, gent 0
4689064 2262140 2262140 plaintiff Trowelufe Richard (legal representative) 586539 586539 Trowelufe, Richard, of Suthwell, executrix of 0
4689066 2262140 2262140 defendant Chace John butcher 586539 586539 Chace, John, of Suthwell, butcher 0
4701239 2265788 2265788 defendant Draper Walter chapman 586539 586539 Draper, Walter, of Suthwell, chapman 0
4703156 2266366 2266366 defendant Overton William butcher 586539 586539 Overton, William, of Suthwell, butcher 0
4703158 2266367 2266367 defendant Hudde William butcher 586539 586539 Hudde, William, of Suthwell, butcher 0
4703284 2266405 2266405 defendant Sampson Margaret widow 586539 586539 Sampson, Margaret, of Suthwell, widow 0
4703742 2266551 2266551 defendant Preston Robert barber 586539 586539 Preston, Robert, of Suthwell, barber 0
4703744 2266551 2266551 defendant Bolt John husbandman 586539 586539 Bolt, John, of Suthwell, husbandman 2
4703745 2266551 2266551 defendant Overton William gent 586539 586539 Overton, William, of Suthwell, gent 3
4703746 2266552 2266552 plaintiff Hode William   586539 586539 Hode, William, of Suthwell 0
4711444 2268908 2268908 defendant Overton William husbandman 586539 586539 Overton, William, of Suthwell, husbandman 1
4711640 2268967 2268967 defendant Weston James chaplain 586539 586539 Weston, James, of Suthwell, chaplain 2
4711641 2268967 2268967 defendant Hudde William butcher 586539 586539 Hudde, William, of Suthwell, butcher 3
4711642 2268967 2268967 defendant Chace John butcher 586539 586539 Chace, John, of Suthwell, butcher 4
4711643 2268967 2268967 defendant Bremes Robert husbandman 586539 586539 Bremes, Robert, of Suthwell, husbandman 5
4713568 2269563 2269563 defendant Sewalson Robert husbandman 586539 586539 Sewalson, Robert, of Suthwell, husbandman 3
4719165 2271341 2271341 defendant Smert Robert ironmonger 586539 586539 Smert, Robert, of Suthwell, ironmonger 2
4720000 2271601 2271601 defendant Wylcok Walter   586539 586539 Wylcok, Walter, of Suthwell, wright 0
4727283 2273786 2273786 defendant Sampson Margaret widow 586539 586539 Sampson, Margaret, of Suthwell, widow 0
4731688 2275106 2275106 defendant Mouse John chaplain 586539 586539 Mouse, John, of Suthwell, chaplain 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);