names

143 rows where place_id = 600051

✎ 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
3592702 1865332 1865332 plaintiff Graunger John, senior (legal representative) 600051 600051 Graunger, John, senior, of Castre, executors of 0
3639467 1907149 1907149 defendant Grene Robert laborer 600051 600051 Grene, Robert, of Castre, laborer 0
3639468 1907149 1907149 defendant Ulceby Robert laborer 600051 600051 Ulceby, Robert, of Castre, laborer 1
3668273 1916022 1916022 defendant Mynskyp Edward gent 600051 600051 Mynskyp, Edward, of Castre, gent 0
3669534 1916409 1916409 defendant Truesdale John gent 600051 600051 (Truesdale, John, of Castre, gent 1
3670331 1916673 1916673 defendant Rede John husbandman 600051 600051 Rede, John, of Castre, husbandman 1
3670563 1916756 1916756 defendant Grene Robert yeoman 600051 600051 Grene, Robert, of Castre, yeoman 1
3682566 1920652 1920652 defendant Richemond Richard husbandman 600051 600051 Richemond, Richard, of Castre, husbandman 3
3691739 1923575 1923575 defendant Coke John husbandman 600051 600051 Coke, John, of Castre, husbandman 0
3793687 1955890 1955890 defendant Underwode John husbandman 600051 600051 Underwode, John, of Castre, husbandman 4
3899583 1990080 1990080 defendant Rynger Robert chaplain 600051 600051 Rynger, Robert, of Castre, chaplain 0
4415267 2169667 2169667 defendant Belour Thomas   600051 600051 Belour, Thomas, of Castre 1
4422244 2171825 2171825 plaintiff Edenestowe Henry de   600051 600051 Edenestowe, Henry de, of Castre, formerly parson 0
4441997 2182428 2182428 defendant Cartwryght Robert   600051 600051 Cartwryght, Robert, of Castre 0
4447840 2184254 2184254 defendant Cather William   600051 600051 Cather, William, of Castre or Caister 1
4452996 2185947 2185947 plaintiff Lake William   600051 600051 Lake, William, of Castre 0
4474689 2192748 2192748 defendant Bury John de   600051 600051 Bury, John de, of Castre 0
4481125 2194776 2194776 plaintiff Ligun Thomas   600051 600051 Ligun, Thomas, of Castre 0
4491312 2197970 2197970 defendant Bery John   600051 600051 Bery, John, of Castre 4
4500144 2200685 2200685 plaintiff Houton Alice de   600051 600051 Houton, Alice de, of Castre 0
4537579 2212027 2212027 defendant Taillour Adam   600051 600051 Taillour, Adam, of Castre 1
4540814 2213033 2213033 defendant Bury John de   600051 600051 Bury, John de, of Castre 3
4562677 2219884 2219884 defendant Eryll Thomas   600051 600051 Eryll, Thomas, of Castre 2
4571452 2222655 2222655 defendant Smyth Thomas   600051 600051 Smyth, Thomas, of Castre 0
4571455 2222655 2222655 defendant Clerk John   600051 600051 Clerk, John, of Castre, son of Alexander 3
4571456 2222655 2222655 defendant Hert John   600051 600051 Hert, John, of Castre 4
4584110 2226451 2226451 defendant Lay John   600051 600051 Lay, John, of Castre 0
4584111 2226451 2226451 defendant Cordell Geoffrey   600051 600051 Cordell, Geoffrey, of Castre 1
4592563 2229026 2229026 defendant atte Halle William   600051 600051 atte Halle, William, of Castre 0
4593974 2229388 2229388 defendant Wryght William   600051 600051 Wryght, William, of Castre 0
4595726 2229917 2229917 defendant Felyngham Thomas weaver 600051 600051 Felyngham, Thomas, of Castre, weaver 3
4611383 2234619 2234619 defendant Snel John   600051 600051 Snel, John, of Castre 4
4611390 2234620 2234620 defendant Snel John   600051 600051 Snel, John, of Castre 4
4623141 2238213 2238213 defendant Hall William miller 600051 600051 Hall, William, of Castre, miller 0
4623838 2238431 2238431 defendant Ive Roger   600051 600051 Ive, Roger, of Castre 0
4631471 2240734 2240734 plaintiff Thomelynson William   600051 600051 Thomelynson, William, of Castre 0
4631539 2240757 2240757 plaintiff Thorp John de   600051 600051 Thorp, John de, of Castre 0
4631540 2240757 2240757 defendant Essheton William   600051 600051 Essheton, William, of Castre 0
4634324 2241579 2241579 defendant Proketour John   600051 600051 Proketour, John, of Castre 1
4640225 2243255 2243255 defendant Tyndale John   600051 600051 Tyndale, John, of Castre 0
4643869 2244307 2244307 defendant Wykes Thomas   600051 600051 Wykes, Thomas, of Castre 0
4643870 2244307 2244307 defendant Gauge John   600051 600051 Gauge, John, of Castre 1
4643871 2244307 2244307 defendant Raulyn Thomas   600051 600051 Raulyn, Thomas, of Castre 2
4643872 2244307 2244307 defendant Everton John   600051 600051 Everton, John, of Castre 3
4643873 2244307 2244307 defendant Martyn John   600051 600051 Martyn, John, of Castre 4
4669102 2256044 2256044 plaintiff Bliklyng Robert   600051 600051 Bliklyng, Robert, of Castre, on his own account 0
4681063 2259704 2259704 defendant Dowme Robert husbandman 600051 600051 Dowme, Robert, of Castre, husbandman 0
4681064 2259704 2259704 defendant Rachedale Thomas laborer 600051 600051 Rachedale, Thomas, of Castre, laborer 1
4683772 2260531 2260531 defendant Wykes Thomas gent 600051 600051 Wykes, Thomas, of Castre, gent 0
4708433 2268003 2268003 defendant Scryvyn (illegible) chapman 600051 600051 Scryvyn, _, of Castre, chapman 1
4709601 2268364 2268364 defendant Wykes Thomas gent 600051 600051 Wykes, Thomas, of Castre, gent 0
4710660 2268691 2268691 defendant Midelton John chapman 600051 600051 Midelton, John, of Castre, chapman 0
4712399 2269194 2269194 defendant Vewtrer William husbandman 600051 600051 Vewtrer, William, of Castre, husbandman 0
4732780 2275427 2275427 defendant Wykes Thomas gent 600051 600051 Wykes, Thomas, of Castre, gent 0
4749286 2280270 2280270 defendant Lyon William husbandman 600051 600051 Lyon, William, of Castre, husbandman 4
4757479 2282717 2282717 defendant Eston Nicholas gent 600051 600051 Eston, Nicholas, of Castre or Castor, gent 0
4757480 2282717 2282717 defendant Rolleston Robert yeoman 600051 600051 Rolleston, Robert, of Castre, yeoman 1
4761317 2283884 2283884 defendant Wykes Gervase gent 600051 600051 Wykes, Gervase, of Castre, gent 0
4764894 2285000 2285000 defendant Oxon John chaplain 600051 600051 Oxon, John, of Castre, chaplain 0
4774787 2288107 2288107 defendant Hunt William yeoman 600051 600051 Hunt, William, of Castre, yeoman 0
4774788 2288107 2288107 defendant Hunt Robert laborer 600051 600051 Hunt, Robert, of Castre, laborer 1
4778251 2289181 2289181 defendant Stone Thomas chapman 600051 600051 Stone, Thomas, of Castre, chapman 0
4783068 2290723 2290723 defendant Heynys Edmund yeoman 600051 600051 Heynys, Edmund, of Castre, yeoman 0
4783072 2290724 2290724 defendant Heynys Edmund yeoman 600051 600051 Heynys, Edmund, of Castre, yeoman 0
4793275 2293992 2293992 defendant Dam Robert husbandman 600051 600051 Dam, Robert, of Castre, husbandman 1
4799385 2295986 2295986 defendant Kelsey Robert husbandman 600051 600051 Kelsey, Robert, of Castre, husbandman 1
4800536 2296349 2296349 defendant Hunt William yeoman 600051 600051 Hunt, William, of Castre, yeoman 0
4800537 2296349 2296349 defendant Hunt Robert laborer 600051 600051 Hunt, Robert, of Castre, laborer 1
4800538 2296349 2296349 defendant Hunt John laborer 600051 600051 Hunt, John, of Castre, laborer 2
4801682 2296708 2296708 defendant Rothenale Elizabeth   600051 600051 Rothenale, Elizabeth, of Castre, widow of Rothenale, John, knight 0
4817356 2301514 2301514 defendant Wryght John laborer 600051 600051 Wryght, John, of Castre, laborer 1
4821086 2302674 2302674 defendant Smyth John husbandman 600051 600051 Smyth, John, of Castre, husbandman 0
4822666 2303165 2303165 defendant Norton John husbandman 600051 600051 Norton, John, of Castre, husbandman 0
4826017 2304173 2304173 defendant Werkeman Ralph laborer 600051 600051 Werkeman, Ralph, of Castre, laborer 0
4830284 2305510 2305510 defendant Meller William husbandman 600051 600051 Meller, William, of Castre, husbandman 0
4838687 2308024 2308024 defendant Kelsey Robert merchant 600051 600051 Kelsey, Robert, of Castre, merchant 1
4904214 2327929 2327929 defendant Dunstan William husbandman 600051 600051 Dunstan, William, of Castre, husbandman 0
4941542 2339372 2339372 defendant Larton John weaver 600051 600051 Larton, John, of Castre, weaver 0
4977054 2350091 2350091 defendant Skampton Thomas husbandman 600051 600051 Skampton, Thomas, of Castre, husbandman 1
4991392 2354309 2354309 defendant Dalby William   600051 600051 Dalby, William, of Castre, glove maker 0
5020754 2362968 2362968 defendant Hunt Thomas husbandman 600051 600051 Hunt, Thomas, of Castre, husbandman 2
5020755 2362968 2362968 defendant Prioour William husbandman 600051 600051 Prioour, William, of Castre, husbandman 3
5027278 2364851 2364851 defendant Grene William husbandman 600051 600051 Grene, William, of Castre, husbandman 0
5037191 2367743 2367743 defendant Scampton ot Stampton Thomas husbandman 600051 600051 Scampton ot Stampton, Thomas, of Castre, husbandman 0
5047520 2370878 2370878 defendant (not given) John vicar of Reve 600051 600051 Reve, John, of Castre or Caister, vicar of Holy Trinity 0
5047522 2370878 2370878 defendant Gunneld John husbandman 600051 600051 Gunneld, John, of Castre, husbandman 2
5055011 2373062 2373062 defendant Est William gent 600051 600051 Est, William, of Castre, gent 0
5056449 2373507 2373507 defendant Chapman John chapman 600051 600051 Chapman, John, of Castre, chapman 0
5067598 2376806 2376806 plaintiff Ousteby John   600051 600051 Ousteby, John, of Castre 0
5068315 2377026 2377026 defendant Edons Thomas husbandman 600051 600051 Edons, Thomas, of Castre, husbandman 3
5085276 2382091 2382091 defendant Eston John gent 600051 600051 Eston, John, of Castre, gent 0
5087047 2382592 2382592 defendant Bokyngham Richard chapman 600051 600051 Bokyngham, Richard, of Castre, chapman 0
5099745 2386361 2386361 defendant Eston John gent 600051 600051 Eston, John, of Castre, gent 0
5102902 2387269 2387269 defendant Athton John husbandman 600051 600051 Athton, John, of Castre, husbandman 1
5119786 2392225 2392225 defendant Chapman John chapman 600051 600051 Chapman, John, of Castre, chapman 2
5149800 2401078 2401078 defendant Edous John husbandman 600051 600051 Edous, John, of Castre, husbandman 0
5173218 2407881 2407881 plaintiff Owesteby John   600051 600051 Owesteby, John, of Castre 0
5193115 2413717 2413717 plaintiff Owesteby John   600051 600051 Owesteby, John, of Castre 0
5193121 2413718 2413718 plaintiff Owesteby John   600051 600051 Owesteby, John, of Castre 0
5198537 2415327 2415327 defendant Halton John, sen   600051 600051 Halton, John, sen, of Castre, glove maker 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);