names

98 rows where place_id = 610614

✎ 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
3684382 1921246 1921246 defendant Ranson John husbandman 610614 610614 Ranson, John, of Gosberkirk, husbandman 0
4427352 2173391 2173391 defendant Broun Alan   610614 610614 Broun, Alan, of Gosberkirk 0
4427353 2173392 2173392 plaintiff Ry Nicholas de   610614 610614 Ry, Nicholas de, of Gosberkirk, knight, son of Edmund 0
4427359 2173393 2173393 plaintiff Ry Nicholas de   610614 610614 Ry, Nicholas de, of Gosberkirk, knight, son of Edmund 0
4427617 2173474 2173474 defendant Berghwham William de   610614 610614 Berghwham, William de, of Gosberkirk 1
4437787 2181142 2181142 defendant Randolf Thomas   610614 610614 Randolf, Thomas, of Gosberkirk 0
4447374 2184088 2184088 plaintiff Edmond Thomas   610614 610614 Edmond, Thomas, of Gosberkirk 0
4458262 2187627 2187627 plaintiff Pynder Agnes   610614 610614 Pynder, Agnes, of Gosberkirk 0
4460789 2188433 2188433 plaintiff Smyth John   610614 610614 Smyth, John, of Gosberkirk 0
4470121 2191307 2191307 plaintiff Brayles Wiliam   610614 610614 Brayles, Wiliam, of Gosberkirk 0
4490276 2197656 2197656 defendant Upton Joan   610614 610614 Upton, Joan, of Gosberkirk, formerly wife of William 0
4514004 2204801 2204801 defendant Baker Thomas   610614 610614 Baker, Thomas, of Gosberkirk 0
4514006 2204802 2204802 defendant Dey John   610614 610614 Dey, John, of Gosberkirk 0
4514007 2204802 2204802 defendant Egefeld Thomas   610614 610614 Egefeld, Thomas, of Gosberkirk 1
4514010 2204803 2204803 defendant Egesfeld Thomas   610614 610614 Egesfeld, Thomas, of Gosberkirk 1
4514012 2204804 2204804 defendant Smyth Thomas   610614 610614 Smyth, Thomas, of Gosberkirk 0
4514013 2204804 2204804 defendant Baker Thmas   610614 610614 Baker, Thmas, of Gosberkirk 1
4514014 2204804 2204804 defendant Egefeld Thomas   610614 610614 Egefeld, Thomas, of Gosberkirk 2
4539217 2212522 2212522 defendant Crisp John   610614 610614 Crisp, John, of Gosberkirk 0
4551442 2216388 2216388 defendant Smyth Thomas   610614 610614 Smyth, Thomas, of Gosberkirk 0
4551635 2216456 2216456 defendant Blode Gilbert   610614 610614 Blode, Gilbert, of Gosberkirk 0
4551636 2216456 2216456 defendant Droby John   610614 610614 Droby, John, of Gosberkirk 1
4558083 2218463 2218463 defendant Alcok John   610614 610614 Alcok, John, of Gosberkirk 0
4563478 2220149 2220149 plaintiff Robert John   610614 610614 Robert, John, of Gosberkirk 0
4564788 2220551 2220551 defendant Culle John   610614 610614 Culle, John, of Gosberkirk 0
4568355 2221677 2221677 defendant Baskervyll John   610614 610614 Baskervyll, John, of Gosberkirk 0
4568429 2221699 2221699 plaintiff Varrell William   610614 610614 Varrell, William, of Gosberkirk 0
4568434 2221700 2221700 plaintiff Vassell William   610614 610614 Vassell, William, of Gosberkirk 0
4621699 2237767 2237767 plaintiff Launde Thomas de la   610614 610614 Launde, Thomas de la, of Gosberkirk 0
4660691 2249166 2249166 defendant Robert John husbandman 610614 610614 Robert, John, of Gosberkirk, husbandman 0
4665078 2250557 2250557 defendant Mony John husbandman 610614 610614 Mony, John, of Gosberkirk, husbandman 0
4666852 2255359 2255359 defendant Pevy Lambert   610614 610614 Pevy, Lambert, of Gosberkirk, salt weller 0
4676157 2258156 2258156 defendant Pevy or Peby Lambert husbandman 610614 610614 Pevy or Peby, Lambert, of Gosberkirk, husbandman 0
4688367 2261928 2261928 defendant Pevy Lambert husbandman 610614 610614 Pevy, Lambert, of Gosberkirk, husbandman 0
4703823 2266573 2266573 defendant Younwyn John husbandman 610614 610614 Younwyn, John, of Gosberkirk, husbandman 0
4741140 2277914 2277914 defendant Peny Lambert   610614 610614 Peny, Lambert, of Gosberkirk, salt weller 0
4834806 2306888 2306888 defendant Roberd John yeoman 610614 610614 Roberd, John, of Gosberkirk, yeoman 0
4834807 2306888 2306888 defendant Leper Simon husbandman 610614 610614 Leper, Simon, of Gosberkirk, husbandman 1
4843416 2309456 2309456 defendant Launde Richard esq 610614 610614 Launde, Richard, of Gosberkirk, esq 0
4843417 2309456 2309456 defendant Wyk_ John gent 610614 610614 Wyk_, John, of Gosberkirk, gent 1
4850011 2311473 2311473 defendant Styberd William husbandman 610614 610614 Styberd, William, of Gosberkirk, husbandman 0
4850012 2311473 2311473 defendant Alisaunder William husbandman 610614 610614 Alisaunder, William, of Gosberkirk, husbandman 1
4850014 2311473 2311473 defendant Virdon Thomas husbandman 610614 610614 Virdon, Thomas, of Gosberkirk, husbandman 3
4850015 2311473 2311473 defendant Spark Thomas husbandman 610614 610614 Spark, Thomas, of Gosberkirk, husbandman 4
4856443 2313393 2313393 defendant Alayn John shoemaker 610614 610614 Alayn, John, of Gosberkirk, shoemaker 0
4869215 2317343 2317343 defendant Dowode Thomas husbandman 610614 610614 Dowode, Thomas, of Gosberkirk, husbandman 4
4869219 2317343 2317343 defendant Roberd John yeoman 610614 610614 Roberd, John, of Gosberkirk, yeoman 8
4873100 2318540 2318540 defendant Crescy John oulter 610614 610614 Crescy, John, of Gosberkirk, oulter 4
4878988 2320357 2320357 defendant Swette William husbandman 610614 610614 Swette, William, of Gosberkirk, husbandman 3
4878995 2320358 2320358 defendant Swete William husbandman 610614 610614 Swete, William, of Gosberkirk, husbandman 3
4879671 2320562 2320562 plaintiff Verdon Thomas   610614 610614 Verdon, Thomas, of Gosberkirk 0
4882337 2321387 2321387 defendant Baysboll Gilbert husbandman 610614 610614 Baysboll, Gilbert, of Gosberkirk, husbandman 0
4882348 2321390 2321390 defendant Wrantyngham or Wrautyngham Richard husbandman 610614 610614 Wrantyngham or Wrautyngham, Richard, of Gosberkirk, husbandman 0
4888274 2323139 2323139 defendant Lawnd Richard esq 610614 610614 Lawnd, Richard, of Gosberkirk, esq 0
4888275 2323139 2323139 defendant Waryn Richard husbandman 610614 610614 Waryn, Richard, of Gosberkirk, husbandman 1
4892811 2324481 2324481 defendant Warde John husbandman 610614 610614 Warde, John, of Gosberkirk, husbandman 0
4892814 2324481 2324481 defendant Hoggeyok Richard weaver 610614 610614 Hoggeyok, Richard, of Gosberkirk, weaver 3
4895579 2325287 2325287 defendant Forman Richard husbandman 610614 610614 Forman, Richard, of Gosberkirk, husbandman 0
4895580 2325287 2325287 defendant Roberd Ivo husbandman 610614 610614 Roberd, Ivo, of Gosberkirk, husbandman 1
4905625 2328362 2328362 defendant Leper Simon butcher 610614 610614 Leper, Simon, of Gosberkirk, butcher 0
4923178 2333669 2333669 defendant Robert John husbandman 610614 610614 Robert, John, of Gosberkirk, husbandman 0
4931098 2336118 2336118 defendant Smyth John   610614 610614 Smyth, John, of Gosberkirk 1
4935288 2337439 2337439 defendant Burnswyn Robert husbandman 610614 610614 Burnswyn, Robert, of Gosberkirk, husbandman 0
4935757 2337575 2337575 defendant Pysshy Lambert husbandman 610614 610614 Pysshy, Lambert, of Gosberkirk, husbandman 0
4940686 2339116 2339116 defendant Sutton William husbandman 610614 610614 Sutton, William, of Gosberkirk, husbandman 5
4944339 2340204 2340204 defendant Sparke William yeoman 610614 610614 Sparke, William, of Gosberkirk, yeoman 1
4948065 2341370 2341370 defendant Waryn Richard husbandman 610614 610614 Waryn, Richard, of Gosberkirk, husbandman 0
4948068 2341370 2341370 defendant Flouter John yeoman 610614 610614 Flouter, John, of Gosberkirk, yeoman 3
4953246 2342931 2342931 defendant Robert John husbandman 610614 610614 Robert, John, of Gosberkirk, husbandman 0
4993551 2354944 2354944 defendant Spanby William husbandman 610614 610614 Spanby, William, of Gosberkirk, husbandman 1
5084525 2381884 2381884 defendant del Howe Robert saltweller 610614 610614 del Howe, Robert, of Gosberkirk, saltweller 0
5102792 2387234 2387234 plaintiff Boll John esq 610614 610614 Boll, John, of Gosberkirk, esq 0
5122364 2392969 2392969 defendant Honyngham Richard yeoman 610614 610614 Honyngham, Richard, of Gosberkirk, yeoman 0
5122373 2392970 2392970 defendant Honyngham Richard yeoman 610614 610614 Honyngham, Richard, of Gosberkirk, yeoman 0
5253937 2431347 2431347 defendant Hunningham Richard yeoman 610614 610614 Hunningham, Richard, of Gosberkirk, yeoman 0
5253938 2431347 2431347 defendant Sprot William husbandman 610614 610614 Sprot, William, of Gosberkirk, husbandman 1
5277918 2438630 2438630 defendant Boll John gent 610614 610614 Boll, John, of Gosberkirk, gent 0
5278831 2438918 2438918 defendant Archer Robert fisher 610614 610614 Archer, Robert, of Gosberkirk, fisher 0
5291678 2442573 2442573 defendant Hall William husbandman 610614 610614 Hall, William, of Gosberkirk, husbandman 0
5291681 2442574 2442574 defendant Hall William husbandman 610614 610614 Hall, William, of Gosberkirk, husbandman 0
5305987 2446778 2446778 defendant Dyconson John yeoman 610614 610614 Dyconson, John, of Gosberkirk, yeoman 0
5305989 2446779 2446779 defendant Dykenson John yeoman 610614 610614 Dykenson, John, of Gosberkirk, yeoman 0
5308789 2447668 2447668 defendant (illegible) William husbandman 610614 610614 _, William, of Gosberkirk, husbandman 1
5313353 2449032 2449032 defendant Bywell Thomas yeoman 610614 610614 Bywell, Thomas, of Gosberkirk, yeoman 0
5321996 2451647 2451647 defendant Honyngham Richard yeoman 610614 610614 Honyngham, Richard, of Gosberkirk, yeoman 0
5324330 2452368 2452368 defendant Thakker Robert husbandman 610614 610614 Thakker, Robert, of Gosberkirk, husbandman 0
5337503 2456291 2456291 defendant Thakker Robert husbandman 610614 610614 Thakker, Robert, of Gosberkirk, husbandman 2
5349758 2460063 2460063 plaintiff Cheyll William (legal representative) 610614 610614 Cheyll, William, of Gosberkirk, executors of 0
5349760 2460063 2460063 plaintiff Cheyll Thomas   610614 610614 Cheyll, Thomas, of Gosberkirk 2
5350146 2460171 2460171 defendant Yongewyn Robert husbandman 610614 610614 Yongewyn, Robert, of Gosberkirk, husbandman 2
5350147 2460171 2460171 defendant Bocher William butcher 610614 610614 Bocher, William, of Gosberkirk, butcher 3
5365733 2464941 2464941 plaintiff Bolles John   610614 610614 Bolles, John, of Gosberkirk 0
5410408 2478063 2478063 plaintiff Brunsweyn Thomas (legal representative) 610614 610614 Brunsweyn, Thomas, of Gosberkirk, executors of 0
5470895 2496224 2496224 defendant Foteman Adam fishmonger 610614 610614 Foteman, Adam, of Gosberkirk, fishmonger 0
5500498 2505088 2505088 defendant Clough John yeoman 610614 610614 Clough, John, of Gosberkirk, yeoman 0
5505399 2506603 2506603 plaintiff Bolles Thomas gent 610614 610614 Bolles, Thomas, of Gosberkirk, gent 0
5513767 2509162 2509162 defendant Bolles Thomas gent 610614 610614 Bolles, Thomas, of Gosberkirk, gent 0
5635174 2554978 2554978 defendant Pynder John tailor 610614 610614 Pynder, John, of Gosberkirk, tailor 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);