names

89 rows where place_id = 590134

✎ 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
3600037 1867665 1867665 defendant Gaskyn Nicholas butcher 590134 590134 Gaskyn, Nicholas, of Redburn, butcher 1
3605277 1869316 1869316 defendant Pyndon William tailor 590134 590134 Pyndon, William, of Redburn, tailor 1
3614814 1872287 1872287 defendant Wystowe William gent 590134 590134 Wystowe, William, of Redburn, gent 1
3614816 1872287 1872287 defendant Watson Robert laborer 590134 590134 Watson, Robert, of Redburn, laborer 3
3614817 1872287 1872287 defendant Symond Richard laborer 590134 590134 Symond, Richard, of Redburn, laborer 4
3614818 1872287 1872287 defendant Tatnall John yeoman 590134 590134 Tatnall, John, of Redburn, yeoman 5
3614827 1872289 1872289 defendant Watson Robert laborer 590134 590134 Watson, Robert, of Redburn, laborer 1
3614828 1872289 1872289 defendant Symond Richard laborer 590134 590134 Symond, Richard, of Redburn, laborer 2
3614829 1872289 1872289 defendant Tatnall John laborer 590134 590134 Tatnall, John, of Redburn, laborer 3
3618747 1873483 1873483 defendant Wystowe William gent 590134 590134 Wystowe, William, of Redburn, gent 1
3618749 1873483 1873483 defendant Watson Robert laborer 590134 590134 Watson, Robert, of Redburn, laborer 3
3618750 1873483 1873483 defendant Symond Richard laborer 590134 590134 Symond, Richard, of Redburn, laborer 4
3618751 1873483 1873483 defendant Tatnall John yeoman 590134 590134 Tatnall, John, of Redburn, yeoman 5
3618761 1873485 1873485 defendant Watson Robert laborer 590134 590134 Watson, Robert, of Redburn, laborer 1
3618762 1873485 1873485 defendant Symond Richard laborer 590134 590134 Symond, Richard, of Redburn, laborer 2
3618763 1873485 1873485 defendant Tatnall John yeoman 590134 590134 Tatnall, John, of Redburn, yeoman 3
3618765 1873485 1873485 defendant Wystowe William gent 590134 590134 Wystowe, William, of Redburn, gent 5
3629380 1904044 1904044 defendant Catelyn John husbandman 590134 590134 Catelyn, John, of Redburn, husbandman 0
3696974 1925280 1925280 defendant Durrant Thomas yeoman 590134 590134 Durrant, Thomas, of Redburn, yeoman 0
3696975 1925280 1925280 defendant Durrant William yeoman 590134 590134 Durrant, William, of Redburn, yeoman 1
3699676 1926125 1926125 defendant lee Hugh yeoman 590134 590134 lee, Hugh, of Redburn, yeoman 3
3741720 1939274 1939274 defendant Arrowsmyth Robert laborer 590134 590134 Arrowsmyth, Robert, of Redburn, laborer 0
3750988 1942237 1942237 plaintiff Mille Thomas yeoman 590134 590134 Mille, Thomas, of Redburn, yeoman 0
4458669 2187755 2187755 defendant Batelesden John   590134 590134 Batelesden, John, of Redburn 0
4533893 2210871 2210871 defendant Smyth John   590134 590134 Smyth, John, of Redburn 4
4537725 2212077 2212077 defendant Hirn John de la   590134 590134 Hirn, John de la, of Redburn 1
4538254 2212254 2212254 defendant Smyth John   590134 590134 Smyth, John, of Redburn 0
4565730 2220842 2220842 defendant Wryght John   590134 590134 Wryght, John, of Redburn 5
4575369 2223810 2223810 plaintiff Boteler Thomas   590134 590134 Boteler, Thomas, of Redburn 0
4598248 2230689 2230689 defendant Newebryde John weaver 590134 590134 Newebryde, John, of Redburn, weaver 0
4618613 2236831 2236831 defendant Smyth John   590134 590134 Smyth, John, of Redburn 0
4629458 2240142 2240142 plaintiff Thirnesto Richard   590134 590134 Thirnesto, Richard, of Redburn, vicar 3
4629463 2240143 2240143 plaintiff Thirnesto Richard   590134 590134 Thirnesto, Richard, of Redburn, vicar 3
4630262 2240375 2240375 defendant Taillour John   590134 590134 Taillour, John, of Redburn 0
4639154 2242968 2242968 plaintiff Cobbe Robert   590134 590134 Cobbe, Robert, of Redburn 0
4639155 2242968 2242968 defendant Lorymer John   590134 590134 Lorymer, John, of Redburn 0
4640137 2243230 2243230 defendant Lorymer John   590134 590134 Lorymer, John, of Redburn 8
4650978 2246305 2246305 defendant Pynder John yeoman 590134 590134 Pynder, John, of Redburn, yeoman 0
4652507 2246735 2246735 defendant Pynder John yeoman 590134 590134 Pynder, John, of Redburn, yeoman 0
4661088 2249292 2249292 defendant Smyth John smith 590134 590134 Smyth, John, of Redburn, smith 0
4672118 2256926 2256926 defendant Waard John husbandman 590134 590134 Waard, John, of Redburn, husbandman 0
4729805 2274524 2274524 defendant Kegworth Joan de   590134 590134 Kegworth, Joan de, of Redburn, widow, formerly wife of Roger 1
4741364 2277972 2277972 defendant Sumpter William yeoman 590134 590134 Sumpter, William, of Redburn, yeoman 0
4799985 2296177 2296177 defendant Fyssh Walter smith 590134 590134 Fyssh, Walter, of Redburn, smith 1
4812156 2299914 2299914 defendant Palmer John husbandman 590134 590134 Palmer, John, of Redburn, husbandman 1
4821850 2302908 2302908 defendant Screven John husbandman 590134 590134 Screven, John, of Redburn, husbandman 1
4840073 2308446 2308446 defendant Palmer John husbandman 590134 590134 Palmer, John, of Redburn, husbandman 0
4840074 2308446 2308446 defendant Palmer Lawrence husbandman 590134 590134 Palmer, Lawrence, of Redburn, husbandman 1
4840099 2308452 2308452 defendant Palmer John husbandman 590134 590134 Palmer, John, of Redburn, husbandman 0
4840100 2308452 2308452 defendant Palmer Lawrence husbandman 590134 590134 Palmer, Lawrence, of Redburn, husbandman 1
4856039 2313260 2313260 defendant Palmer John husbandman 590134 590134 Palmer, John, of Redburn, husbandman 2
4860566 2314662 2314662 defendant Palmer John husbandman 590134 590134 Palmer, John, of Redburn, husbandman 0
4860567 2314662 2314662 defendant Sumpter William husbandman 590134 590134 Sumpter, William, of Redburn, husbandman 1
4865039 2316042 2316042 defendant Palmer Lawrence husbandman 590134 590134 Palmer, Lawrence, of Redburn, husbandman 0
4867318 2316742 2316742 defendant Palmer John husbandman 590134 590134 Palmer, John, of Redburn, husbandman 0
4867321 2316743 2316743 defendant Couper John husbandman 590134 590134 Couper, John, of Redburn, husbandman 0
4882333 2321385 2321385 defendant Pynder John husbandman 590134 590134 Pynder, John, of Redburn, husbandman 2
4898409 2326157 2326157 defendant Palmer Lawrence farmer 590134 590134 Palmer, Lawrence, of Redburn, farmer 2
4904155 2327911 2327911 defendant Palmer Lawrence farmer 590134 590134 Palmer, Lawrence, of Redburn, farmer 2
4977498 2350234 2350234 defendant Northern Richard (legal representative) 590134 590134 Northern, Richard, of Redburn, executors of 4
5012650 2360538 2360538 defendant Sumpter William husbandman 590134 590134 Sumpter, William, of Redburn, husbandman 0
5015332 2361367 2361367 defendant Boteler William yeoman 590134 590134 Boteler, William, of Redburn, yeoman 3
5052885 2372453 2372453 defendant Noddys Thomas husbandman 590134 590134 Noddys, Thomas, of Redburn, husbandman 1
5078922 2380182 2380182 defendant Bocher Robert butcher 590134 590134 Bocher, Robert, of Redburn, butcher 0
5093519 2384503 2384503 defendant Nodde Thomas husbandman 590134 590134 Nodde, Thomas, of Redburn, husbandman 2
5099413 2386258 2386258 defendant Boteler William miller 590134 590134 Boteler, William, of Redburn, miller 0
5106239 2388263 2388263 defendant Gyle John laborer 590134 590134 Gyle, John, of Redburn, laborer 0
5106240 2388263 2388263 defendant Baron John yeoman 590134 590134 Baron, John, of Redburn, yeoman 1
5106241 2388263 2388263 defendant Dawe Edmund laborer 590134 590134 Dawe, Edmund, of Redburn, laborer 2
5106248 2388265 2388265 defendant Terry Thomas (legal representative) 590134 590134 Terry, Thomas, of Redburn, executors of 0
5117064 2391417 2391417 defendant at Hill Nicholas husbandman 590134 590134 at Hill, Nicholas, of Redburn, husbandman 0
5179468 2409730 2409730 defendant Ketilby John yeoman 590134 590134 Ketilby, John, of Redburn, yeoman 0
5199768 2415679 2415679 defendant Burton John smith 590134 590134 Burton, John, of Redburn, smith 2
5309120 2447765 2447765 defendant Holford Thomas husbandman 590134 590134 Holford, Thomas, of Redburn, husbandman 0
5331167 2454396 2454396 defendant Geskyng Nicholas butcher 590134 590134 Geskyng, Nicholas, of Redburn, butcher 0
5341693 2457596 2457596 defendant Sothell Robert gent 590134 590134 Sothell, Robert, of Redburn, gent 0
5363000 2464074 2464074 defendant Gaston Thomas yeoman 590134 590134 Gaston, Thomas, of Redburn, yeoman 1
5449795 2489828 2489828 defendant Bonyon Roger husbandman 590134 590134 Bonyon, Roger, of Redburn, husbandman 0
5457428 2492123 2492123 defendant Lovell Edmund husbandman 590134 590134 Lovell, Edmund, of Redburn, husbandman 0
5457429 2492123 2492123 defendant Yonge Henry laborer 590134 590134 Yonge, Henry, of Redburn, laborer 1
5469254 2495735 2495735 defendant Lovell Edmund husbandman 590134 590134 Lovell, Edmund, of Redburn, husbandman 0
5469255 2495735 2495735 defendant Yynge Henry laborer 590134 590134 Yynge, Henry, of Redburn, laborer 1
5473471 2497027 2497027 defendant Lane Nicholas husbandman 590134 590134 Lane, Nicholas, of Redburn, husbandman 0
5473473 2497028 2497028 defendant Welles William miller 590134 590134 Welles, William, of Redburn, miller 0
5484913 2500410 2500410 defendant Welles Alice widow 590134 590134 Welles, Alice, of Redburn, widow 3
5488407 2501427 2501427 defendant Gaskyn Nicholas butcher 590134 590134 Gaskyn, Nicholas, of Redburn, butcher 0
5558992 2522584 2522584 defendant Nodde William husbandman 590134 590134 Nodde, William, of Redburn, husbandman 0
5558993 2522584 2522584 defendant Kentysshe John husbandman 590134 590134 Kentysshe, John, of Redburn, husbandman 1
5566876 2524908 2524908 defendant Nele William yeoman 590134 590134 Nele, William, of Redburn, yeoman 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);