names

222 rows where place_id = 589310

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597180 1866742 1866742 defendant Wykeley John yeoman 589310 589310 Wykeley, John, of Ripon, yeoman 3
3597185 1866743 1866743 defendant Wykeley John yeoman 589310 589310 Wykeley, John, of Ripon, yeoman 3
3610756 1871030 1871030 defendant Stable William chaplain 589310 589310 Stable, William, of Ripon, chaplain 1
3610757 1871030 1871030 defendant Casse John yeoman 589310 589310 Casse, John, of Ripon, yeoman 2
3610758 1871030 1871030 defendant Kegyll John laborer 589310 589310 Kegyll, John, of Ripon, laborer 3
3634167 1905488 1905488 defendant Hawkyns John   589310 589310 Hawkyns, John, of Ripon, clerk, prebendary 0
3662272 1914114 1914114 defendant Condall Robert yeoman 589310 589310 Condall, Robert, of Ripon, yeoman 0
3662877 1914303 1914303 defendant Norton John esq 589310 589310 Norton, John, of Ripon, esq 0
3678107 1919203 1919203 plaintiff Maxwell William   589310 589310 Maxwell, William, of Ripon 0
3709053 1929130 1929130 defendant Tenant Robert gent 589310 589310 Tenant, Robert, of Ripon, gent 0
3722293 1933233 1933233 plaintiff Mawkeswell William   589310 589310 Mawkeswell, William, of Ripon 0
3759633 1945001 1945001 plaintiff Coke Ralph yeoman 589310 589310 Coke, Ralph, of Ripon, yeoman 0
3759634 1945001 1945001 defendant Bakhows Adam yeoman 589310 589310 Bakhows, Adam, of Ripon, yeoman 0
3759635 1945002 1945002 plaintiff Coke Ralph yeoman 589310 589310 Coke, Ralph, of Ripon, yeoman 0
3759636 1945002 1945002 defendant Sele John tailor 589310 589310 Sele, John, of Ripon, tailor 0
3774283 1949677 1949677 defendant Dixson John yeoman 589310 589310 Dixson, John, of Ripon, yeoman 0
3790323 1954790 1954790 defendant Hebden William clerk 589310 589310 Hebden, William, of Ripon, clerk 0
3802607 1958709 1958709 defendant Staveley Miles gent 589310 589310 Staveley, Miles, of Ripon, gent 1
3822346 1964896 1964896 plaintiff Staneley or Staveley Thomas gent 589310 589310 Staneley or Staveley, Thomas, of Ripon, gent 0
3939657 2003570 2003570 defendant Tomson William miller 589310 589310 Tomson, William, of Ripon, miller 0
3940617 2003871 2003871 plaintiff Staveley Thomas   589310 589310 Staveley, Thomas, of Ripon 0
4076899 2052025 2052025 plaintiff Smyth John vintner 589310 589310 Smyth, John, of Ripon, vintner 0
4098573 2059822 2059822 defendant Tomlinson Richard chapman 589310 589310 Tomlinson, Richard, of Ripon, chapman 0
4263228 2117368 2117368 defendant Yorke Edward   589310 589310 Yorke, Edward, of Ripon, knight 0
4420934 2171443 2171443 plaintiff Chapman John   589310 589310 Chapman, John, of Ripon 0
4420935 2171443 2171443 defendant Hubert Nicholas   589310 589310 Hubert, Nicholas, of Ripon, son of Nicholas 0
4421234 2171536 2171536 plaintiff Clotherom Roger de   589310 589310 Clotherom, Roger de, of Ripon 0
4421236 2171537 2171537 plaintiff Clotherom Roger de   589310 589310 Clotherom, Roger de, of Ripon 0
4450685 2185174 2185174 plaintiff Haukeswyk John de   589310 589310 Haukeswyk, John de, of Ripon 0
4450687 2185174 2185174 plaintiff Clynt John chaplain 589310 589310 Clynt, John, of Ripon, chaplain 2
4450689 2185175 2185175 plaintiff Haukeswyk John de   589310 589310 Haukeswyk, John de, of Ripon 0
4450691 2185175 2185175 plaintiff Clynt John chaplain 589310 589310 Clynt, John, of Ripon, chaplain 2
4455045 2186581 2186581 defendant Kydire Adam   589310 589310 Kydire, Adam, of Ripon 0
4462708 2189038 2189038 defendant Toppeclif John   589310 589310 Toppeclif, John, of Ripon 0
4524794 2208093 2208093 defendant Barton John smith 589310 589310 Barton, John, of Ripon, smith 1
4550290 2216036 2216036 plaintiff Cawode William master & canon of the collegiate church 589310 589310 (Cawode, William, of Ripon, master & canon of the collegiate church 1
4560988 2219388 2219388 defendant Gatsyde John   589310 589310 Gatsyde, John, of Ripon 5
4608147 2233660 2233660 defendant Raa Robert dyer 589310 589310 Raa, Robert, of Ripon, dyer 3
4633647 2241374 2241374 defendant Merott John   589310 589310 Merott, John, of Ripon 0
4635315 2241882 2241882 defendant Heton John tanner 589310 589310 Heton, John, of Ripon, tanner 0
4643142 2244101 2244101 defendant Lesam William chapman 589310 589310 Lesam, William, of Ripon, chapman 5
4646918 2245162 2245162 defendant Qwelewryght Richard   589310 589310 Qwelewryght, Richard, of Ripon 0
4646919 2245162 2245162 defendant Vaux John tailor 589310 589310 Vaux, John, of Ripon, tailor 1
4678035 2258741 2258741 defendant Rayner Agnes widow 589310 589310 (Rayner, Agnes, of Ripon, widow 6
4678036 2258741 2258741 defendant Wrampayn William, junior chapman 589310 589310 Wrampayn, William, junior, of Ripon, chapman 7
4688300 2261908 2261908 defendant Ely John chaplain 589310 589310 Ely, John, of Ripon, chaplain 0
4693323 2263414 2263414 defendant Tanfeld William husbandman 589310 589310 Tanfeld, William, of Ripon, husbandman 0
4694313 2263720 2263720 defendant Pycher John sawyer 589310 589310 Pycher, John, of Ripon, sawyer 0
4696651 2264430 2264430 plaintiff (not given) John rector of Chambre 589310 589310 Chambre, John, of Ripon, rector of the Grammar School 0
4696652 2264430 2264430 defendant Horseman Geoffrey chaplain 589310 589310 Horseman, Geoffrey, of Ripon, chaplain 0
4697734 2264784 2264784 defendant Proktour Robert yeoman 589310 589310 Proktour, Robert, of Ripon, yeoman 0
4698863 2265126 2265126 defendant Henryson Thomas hosier 589310 589310 Henryson, Thomas, of Ripon, hosier 0
4703904 2266597 2266597 defendant Lesham William chapman 589310 589310 Lesham, William, of Ripon, chapman 1
4703906 2266597 2266597 defendant Kendall William dyer 589310 589310 Kendall, William, of Ripon, dyer 3
4716048 2270326 2270326 plaintiff Wencelawe John   589310 589310 Wencelawe, John, of Ripon 0
4717157 2270694 2270694 plaintiff Wyrethorp Alan   589310 589310 Wyrethorp, Alan, of Ripon 0
4720270 2271682 2271682 plaintiff Britby John   589310 589310 Britby, John, of Ripon 0
4720271 2271682 2271682 defendant Plane William laborer 589310 589310 Plane, William, of Ripon, laborer 0
4721529 2272066 2272066 plaintiff (not given) John rector of Chambre 589310 589310 Chambre, John, of Ripon, rector of the grammar school scholars 0
4721530 2272066 2272066 defendant Horseman Geoffrey chaplain 589310 589310 Horseman, Geoffrey, of Ripon, chaplain 0
4723388 2272624 2272624 defendant Littester George dyer 589310 589310 Littester, George, of Ripon, dyer 2
4728725 2274223 2274223 defendant Wrampan William, sen chapman 589310 589310 Wrampan, William, sen, of Ripon, chapman 1
4731786 2275130 2275130 defendant Wrampan William   589310 589310 Wrampan, William, of Ripon 0
4732122 2275230 2275230 defendant Sele John dyer 589310 589310 Sele, John, of Ripon, dyer 0
4735589 2276283 2276283 defendant Brynmand John butcher 589310 589310 Brynmand, John, of Ripon, butcher 0
4735590 2276283 2276283 defendant Walker Thomas yeoman 589310 589310 Walker, Thomas, of Ripon, yeoman 1
4735591 2276283 2276283 defendant Tone or Tove William husbandman 589310 589310 Tone or Tove, William, of Ripon, husbandman 2
4735592 2276283 2276283 defendant Hoton William de butcher 589310 589310 Hoton, William de, of Ripon, butcher 3
4739613 2277463 2277463 defendant Wrampayn William yeoman 589310 589310 Wrampayn, William, of Ripon, yeoman 3
4743257 2278556 2278556 defendant Proktour Robert yeoman 589310 589310 Proktour, Robert, of Ripon, yeoman 1
4744927 2279030 2279030 plaintiff Flesshehewer Roger   589310 589310 Flesshehewer, Roger, of Ripon, on his own account 0
4751961 2281066 2281066 defendant Dunnyng John tanner 589310 589310 Dunnyng, John, of Ripon, tanner 4
4757090 2282588 2282588 defendant Lytster William dyer 589310 589310 Lytster, William, of Ripon, dyer 0
4768517 2286129 2286129 plaintiff Neuton John (legal representative) 589310 589310 Neuton, John, of Ripon, butcher, executrix of 0
4769205 2286346 2286346 defendant Clerk William yeoman 589310 589310 Clerk, William, of Ripon, yeoman 0
4771834 2287167 2287167 plaintiff Skirwyth William master of the hospital of St Mary Magdalene 589310 589310 Skirwyth, William, of Ripon, master of the hospital of St Mary Magdalene 0
4772389 2287330 2287330 plaintiff Sprote Thomas   589310 589310 Sprote, Thomas, of Ripon 0
4776151 2288538 2288538 defendant Spencer John yeoman 589310 589310 Spencer, John, of Ripon, yeoman 3
4790823 2293220 2293220 defendant Sprott Thomas merchant 589310 589310 Sprott, Thomas, of Ripon, merchant 0
4792778 2293830 2293830 defendant Wilson John yeoman 589310 589310 Wilson, John, of Ripon, yeoman 0
4801621 2296691 2296691 defendant Theker Thomas thatcher 589310 589310 Theker, Thomas, of Ripon, thatcher 0
4819566 2302195 2302195 defendant Wrampan William, senior merchant 589310 589310 Wrampan, William, senior, of Ripon, merchant 0
4819567 2302195 2302195 defendant Byrthby John   589310 589310 Byrthby, John, of Ripon, corn dealer 1
4826704 2304386 2304386 defendant Lame John (legal representative) 589310 589310 Lame, John, of Ripon, mercer, executors of 0
4826706 2304386 2304386 defendant Shirbourn John chaplain 589310 589310 Shirbourn, John, of Ripon, chaplain 2
4835639 2307139 2307139 plaintiff Donyng John   589310 589310 Donyng, John, of Ripon 0
4837426 2307642 2307642 defendant Thoone Richard tanner 589310 589310 Thoone, Richard, of Ripon, tanner 0
4837427 2307642 2307642 defendant Playne William husbandman 589310 589310 Playne, William, of Ripon, husbandman 1
4837428 2307642 2307642 defendant Pykerynge Robert weaver 589310 589310 Pykerynge, Robert, of Ripon, weaver 2
4837429 2307642 2307642 defendant Morpath John   589310 589310 Morpath, John, of Ripon, shoe maker 3
4837430 2307642 2307642 defendant Comyne William victualler 589310 589310 Comyne, William, of Ripon, victualler 4
4837433 2307643 2307643 defendant Skelton Thomas dyer 589310 589310 Skelton, Thomas, of Ripon, dyer 1
4837434 2307643 2307643 defendant Myneskippe William   589310 589310 Myneskippe, William, of Ripon, taunator or tanner 2
4846612 2310452 2310452 defendant Wollore William walker 589310 589310 Wollore, William, of Ripon, walker 2
4849076 2311182 2311182 defendant Bladesworth Richard merchant 589310 589310 Bladesworth, Richard, of Ripon, merchant 1
4849171 2311215 2311215 defendant Wethirby John mercer 589310 589310 Wethirby, John, of Ripon, mercer 0
4849175 2311216 2311216 defendant Wethirby John mercer 589310 589310 Wethirby, John, of Ripon, mercer 0
4849426 2311294 2311294 defendant Brandeby William   589310 589310 Brandeby, William, of Ripon, blade smith 1
4850761 2311689 2311689 defendant Skelton John yeoman 589310 589310 Skelton, John, of Ripon, yeoman 1
4853384 2312470 2312470 defendant Halton William de laborer 589310 589310 Halton, William de, of Ripon, laborer 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);