names

107 rows where place_id = 590853

✎ 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
3602510 1868444 1868444 plaintiff Cage Robert   590853 590853 Cage, Robert, of Ratlesden 0
3602512 1868445 1868445 plaintiff Cage Robert   590853 590853 Cage, Robert, of Ratlesden 0
3610870 1871071 1871071 defendant Rydenale Peter yeoman 590853 590853 Rydenale, Peter, of Ratlesden, yeoman 0
3614886 1872310 1872310 plaintiff Cage Robert   590853 590853 Cage, Robert, of Ratlesden 0
3617742 1873174 1873174 plaintiff Gage Robert   590853 590853 Gage, Robert, of Ratlesden 0
3635475 1905891 1905891 plaintiff Parker William laborer 590853 590853 Parker, William, of Ratlesden, laborer 0
3635478 1905892 1905892 defendant Russhbroke John weaver 590853 590853 Russhbroke, John, of Ratlesden, weaver 0
3644093 1908583 1908583 defendant Cage Henry husbandman 590853 590853 Cage, Henry, of Ratlesden, husbandman 0
3644094 1908583 1908583 defendant Cage William husbandman 590853 590853 Cage, William, of Ratlesden, husbandman 1
3673526 1917747 1917747 defendant Clarke John cooper 590853 590853 Clarke, John, of Ratlesden, cooper 1
3858260 1976240 1976240 defendant Turnar John tailor 590853 590853 Turnar, John, of Ratlesden, tailor 0
4015300 2030166 2030166 defendant Parkynson Edward husbandman 590853 590853 Parkynson, Edward, of Ratlesden, husbandman 0
4165637 2083481 2083481 defendant Taylor Thomas husbandman 590853 590853 Taylor, Thomas, of Ratlesden, husbandman 1
4198138 2094894 2094894 defendant Kempe Richard tailor 590853 590853 Kempe, Richard, of Ratlesden, tailor 2
4413260 2169021 2169021 plaintiff Bacoun John   590853 590853 Bacoun, John, of Ratlesden 0
4433326 2175178 2175178 defendant Hardheved John, junior   590853 590853 Hardheved, John, junior, of Ratlesden 2
4433820 2175338 2175338 plaintiff Hardhevedw John   590853 590853 Hardhevedw, John, of Ratlesden 0
4433821 2175338 2175338 defendant atte Wode Thomas   590853 590853 atte Wode, Thomas, of Ratlesden 0
4439336 2181572 2181572 plaintiff (not given) Robert de prior of Aylesham 590853 590853 Aylesham, Robert de, of Ratlesden, formerly parson, and prior of Holy Trinity, Norwich, executors of 0
4439340 2181572 2181572 defendant Tubby Thomas   590853 590853 Tubby, Thomas, of Ratlesden 0
4439341 2181573 2181573 plaintiff (not given) Robert de prior of Aylesham 590853 590853 Aylesham, Robert de, of Ratlesden, parson & prior of Holy Trinity church, in Norwich, executors of 0
4439345 2181573 2181573 defendant Tubby Thomas   590853 590853 Tubby, Thomas, of Ratlesden 0
4458009 2187531 2187531 defendant Wetherdene Peter   590853 590853 Wetherdene, Peter, of Ratlesden 0
4518827 2206254 2206254 defendant Wederdene John   590853 590853 Wederdene, John, of Ratlesden 0
4519815 2206553 2206553 defendant Debon John   590853 590853 Debon, John, of Ratlesden, wool man 0
4522883 2207492 2207492 defendant Colete Thomas chaplain 590853 590853 Colete, Thomas, of Ratlesden, chaplain 0
4538034 2212178 2212178 defendant Stubbard Robert   590853 590853 Stubbard, Robert, of Ratlesden 0
4542700 2213604 2213604 plaintiff Aldewyk Peter   590853 590853 Aldewyk, Peter, of Ratlesden 0
4560209 2219142 2219142 plaintiff Mundegom John   590853 590853 Mundegom, John, of Ratlesden 0
4567556 2221412 2221412 defendant Stubbard Robert   590853 590853 Stubbard, Robert, of Ratlesden, wool man 0
4569271 2221977 2221977 plaintiff Wedirdene John   590853 590853 Wedirdene, John, of Ratlesden 0
4577665 2224520 2224520 defendant Wode Richard   590853 590853 Wode, Richard, of Ratlesden 0
4604956 2232712 2232712 plaintiff Aldewykele Robert   590853 590853 Aldewykele, Robert, of Ratlesden 0
4608715 2233831 2233831 defendant Wetherden William   590853 590853 Wetherden, William, of Ratlesden 1
4608716 2233831 2233831 defendant Martham John   590853 590853 Martham, John, of Ratlesden 2
4609373 2234031 2234031 defendant Barkere Alan   590853 590853 Barkere, Alan, of Ratlesden 2
4610523 2234359 2234359 defendant del Wode Richard   590853 590853 del Wode, Richard, of Ratlesden 9
4618355 2236751 2236751 defendant Wederden William   590853 590853 Wederden, William, of Ratlesden 0
4620753 2237473 2237473 defendant Auncelm Roger   590853 590853 Auncelm, Roger, of Ratlesden 1
4666263 2250918 2250918 defendant Wode John scalder 590853 590853 Wode, John, of Ratlesden, scalder 4
4714833 2269972 2269972 defendant Qwepsted Nicholas husbandman 590853 590853 Qwepsted, Nicholas, of Ratlesden, husbandman 0
4741256 2277940 2277940 defendant Wade William yeoman 590853 590853 Wade, William, of Ratlesden, yeoman 0
4758939 2283150 2283150 defendant Whippestede Nicholas   590853 590853 Whippestede, Nicholas, of Ratlesden, wool man 1
4770119 2286622 2286622 defendant Cokerell John yeoman 590853 590853 Cokerell, John, of Ratlesden, yeoman 1
4784179 2291050 2291050 defendant Sexstayn Agnes widow 590853 590853 Sexstayn, Agnes, of Ratlesden, widow 4
4792564 2293765 2293765 defendant Coide John yeoman 590853 590853 Coide, John, of Ratlesden, yeoman 0
4792565 2293765 2293765 defendant Smyth Henry yeoman 590853 590853 Smyth, Henry, of Ratlesden, yeoman 1
4816554 2301270 2301270 plaintiff Man John   590853 590853 Man, John, of Ratlesden 0
4850188 2311521 2311521 defendant Jolyf John husbandman 590853 590853 Jolyf, John, of Ratlesden, husbandman 3
4851744 2311983 2311983 defendant Turnour William   590853 590853 Turnour, William, of Ratlesden, clerk, formerly parson of Langham church, Essex 0
4874673 2319021 2319021 defendant Pecche Thomas yeoman 590853 590853 Pecche, Thomas, of Ratlesden, yeoman 4
4919710 2332670 2332670 defendant Curteys Robert miller 590853 590853 Curteys, Robert, of Ratlesden, miller 2
4919721 2332671 2332671 defendant Haliday John husbandman 590853 590853 Haliday, John, of Ratlesden, husbandman 5
4919725 2332672 2332672 defendant Hony John, senior husbandman 590853 590853 Hony, John, senior, of Ratlesden, husbandman 0
4924608 2334132 2334132 defendant Whepsted Nicholas husbandman 590853 590853 Whepsted, Nicholas, of Ratlesden, husbandman 0
4978679 2350573 2350573 defendant Turnour William clerk 590853 590853 Turnour, William, of Ratlesden, clerk 1
4978680 2350573 2350573 defendant Cage Thomas husbandman 590853 590853 Cage, Thomas, of Ratlesden, husbandman 2
5032939 2366522 2366522 defendant Legat Robert husbandman 590853 590853 Legat, Robert, of Ratlesden, husbandman 0
5032940 2366522 2366522 defendant Turnour William clerk 590853 590853 Turnour, William, of Ratlesden, clerk 1
5032944 2366523 2366523 defendant Legat Robert husbandman 590853 590853 Legat, Robert, of Ratlesden, husbandman 0
5032945 2366523 2366523 defendant Turnour William clerk 590853 590853 Turnour, William, of Ratlesden, clerk 1
5066590 2376531 2376531 defendant Aydy Thomas husbandman 590853 590853 Aydy, Thomas, of Ratlesden, husbandman 0
5086029 2382305 2382305 plaintiff Hardhed Walter woolman 590853 590853 Hardhed, Walter, of Ratlesden, woolman 0
5090080 2383470 2383470 plaintiff Man William   590853 590853 Man, William, of Ratlesden 0
5090084 2383470 2383470 defendant Dowe John butcher 590853 590853 Dowe, John, of Ratlesden, butcher 2
5090085 2383470 2383470 defendant Webbe Thomas husbandman 590853 590853 Webbe, Thomas, of Ratlesden, husbandman 3
5135193 2396790 2396790 defendant Webbe Thomas husbandman 590853 590853 Webbe, Thomas, of Ratlesden, husbandman 6
5135200 2396793 2396793 defendant Smyth John laborer 590853 590853 Smyth, John, of Ratlesden, laborer 0
5147091 2400287 2400287 defendant Bumstead John butcher 590853 590853 Bumstead, John, of Ratlesden, butcher 0
5147094 2400288 2400288 defendant Bumstead John butcher 590853 590853 Bumstead, John, of Ratlesden, butcher 0
5155298 2402700 2402700 defendant Smyth John laborer 590853 590853 Smyth, John, of Ratlesden, laborer 0
5158603 2403637 2403637 defendant Wode John dyer 590853 590853 Wode, John, of Ratlesden, dyer 1
5159516 2403900 2403900 defendant Caudeler of Candeler William husbandman 590853 590853 Caudeler of Candeler, William, of Ratlesden, husbandman 0
5171988 2407522 2407522 defendant Smyth John laborer 590853 590853 Smyth, John, of Ratlesden, laborer 0
5195361 2414396 2414396 defendant Caudeler William husbandman 590853 590853 Caudeler, William, of Ratlesden, husbandman 0
5209251 2418437 2418437 defendant Caudeler or Candeler William husbandman 590853 590853 Caudeler or Candeler, William, of Ratlesden, husbandman 0
5225265 2423062 2423062 defendant Candeler William husbandman 590853 590853 Candeler, William, of Ratlesden, husbandman 4
5253832 2431314 2431314 defendant Redenhall William tailor 590853 590853 Redenhall, William, of Ratlesden, tailor 1
5287916 2441481 2441481 defendant Sefoule Robert husbandman 590853 590853 Sefoule, Robert, of Ratlesden, husbandman 1
5294342 2443319 2443319 defendant Comageyn Thomas   590853 590853 Comageyn, Thomas, of Ratlesden, basket maker 0
5294343 2443319 2443319 defendant Kyng Nicholas laborer 590853 590853 Kyng, Nicholas, of Ratlesden, laborer 1
5294345 2443320 2443320 defendant Comageyn Thomas   590853 590853 Comageyn, Thomas, of Ratlesden, basket maker 0
5294346 2443320 2443320 defendant Kyng Nicholas laborer 590853 590853 Kyng, Nicholas, of Ratlesden, laborer 1
5321828 2451602 2451602 plaintiff Cage Robert   590853 590853 Cage, Robert, of Ratlesden 3
5349329 2459922 2459922 plaintiff Cage Robert   590853 590853 Cage, Robert, of Ratlesden 0
5366927 2465308 2465308 plaintiff Cage Robert   590853 590853 Cage, Robert, of Ratlesden 0
5385469 2470915 2470915 defendant Rounton Thomas husbandman 590853 590853 Rounton, Thomas, of Ratlesden, husbandman 4
5386584 2471229 2471229 defendant Caudeler John butcher 590853 590853 Caudeler, John, of Ratlesden, butcher 7
5411974 2478535 2478535 defendant Caudeler John butcher 590853 590853 Caudeler, John, of Ratlesden, butcher 7
5411975 2478535 2478535 defendant Sesull John husbandman 590853 590853 Sesull, John, of Ratlesden, husbandman 8
5426523 2482879 2482879 defendant Umfrey George yeoman 590853 590853 Umfrey, George, of Ratlesden, yeoman 6
5426524 2482879 2482879 defendant Caudeler John butcher 590853 590853 Caudeler, John, of Ratlesden, butcher 7
5426525 2482879 2482879 defendant Sesull John smith 590853 590853 Sesull, John, of Ratlesden, smith 8
5568875 2525447 2525447 defendant Waren Robert butcher 590853 590853 Waren, Robert, of Ratlesden, butcher 0
5569060 2525500 2525500 defendant Pateman William husbandman 590853 590853 Pateman, William, of Ratlesden, husbandman 0
5569061 2525500 2525500 defendant Rooshebroke Thomas husbandman 590853 590853 Rooshebroke, Thomas, of Ratlesden, husbandman 1
5569062 2525500 2525500 defendant Cage Henry husbandman 590853 590853 Cage, Henry, of Ratlesden, husbandman 2
5569063 2525500 2525500 defendant Boweden John husbandman 590853 590853 Boweden, John, of Ratlesden, husbandman 3
5569064 2525500 2525500 defendant Bolle John husbandman 590853 590853 Bolle, John, of Ratlesden, husbandman 4
5569065 2525500 2525500 defendant Abell John husbandman 590853 590853 Abell, John, of Ratlesden, husbandman 5

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