names

280 rows where place_id = 589274

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597079 1866709 1866709 defendant Cofte Thomas gent 589274 589274 Cofte, Thomas, of Cotyngham, gent 0
3597081 1866710 1866710 defendant Coste or Cofte Thomas gent 589274 589274 Coste or Cofte, Thomas, of Cotyngham, gent 0
3628778 1903878 1903878 defendant Warde Roger yeoman 589274 589274 Warde, Roger, of Cotyngham, yeoman 0
3632591 1905012 1905012 defendant Norwod Richard husbandman 589274 589274 Norwod, Richard, of Cotyngham, husbandman 0
3632592 1905012 1905012 defendant Barbour John barber 589274 589274 Barbour, John, of Cotyngham, barber 1
3664232 1914760 1914760 defendant Smyth Thomas husbandman 589274 589274 Smyth, Thomas, of Cotyngham, husbandman 0
3689932 1923010 1923010 defendant Haldesworth Charles yeoman 589274 589274 Haldesworth, Charles, of Cotyngham, yeoman 0
3778630 1951027 1951027 defendant Isabell Richard yeoman 589274 589274 Isabell, Richard, of Cotyngham, yeoman 1
3781602 1951984 1951984 defendant Womersley Henry butcher 589274 589274 Womersley, Henry, of Cotyngham, butcher 0
3781603 1951984 1951984 defendant Endyk John, senior butcher 589274 589274 Endyk, John, senior, of Cotyngham, butcher 1
3840326 1970542 1970542 defendant Butler John chapman 589274 589274 Butler, John, of Cotyngham, chapman 2
3844658 1971872 1971872 defendant Wynteryngham William husbandman 589274 589274 Wynteryngham, William, of Cotyngham, husbandman 0
3879133 1983273 1983273 plaintiff Medcaulf Robert gent 589274 589274 Medcaulf, Robert, of Cotyngham, gent 0
3882601 1984445 1984445 defendant Dyxson John carrier 589274 589274 Dyxson, John, of Cotyngham, carrier 0
4417326 2170300 2170300 defendant Takel John   589274 589274 Takel, John, of Cotyngham 0
4418067 2170533 2170533 plaintiff Troys Theobald de   589274 589274 Troys, Theobald de, of Cotyngham 0
4418953 2170793 2170793 plaintiff Assheby John de (legal representative) 589274 589274 Assheby, John de, of Cotyngham, parson, executor of 0
4418954 2170793 2170793 plaintiff Haronden John de   589274 589274 Haronden, John de, of Cotyngham, parson 1
4421289 2171554 2171554 defendant Norman William   589274 589274 Norman, William, of Cotyngham 0
4421932 2171734 2171734 defendant Ker Celia le   589274 589274 Ker, Celia le, of Cotyngham, wife of Adam, who vouches to warrant William de Cotyngham, son & heir of Roger, son of Nicholas 0
4423751 2172271 2172271 plaintiff Harondon John   589274 589274 Harondon, John, of Cotyngham, parson 0
4427495 2173437 2173437 defendant Takel John   589274 589274 Takel, John, of Cotyngham 0
4428362 2173704 2173704 plaintiff Stotevill Robert de   589274 589274 Stotevill, Robert de, of Cotyngham 0
4441439 2182263 2182263 defendant Spayne John   589274 589274 Spayne, John, of Cotyngham 0
4462989 2189125 2189125 plaintiff Tomson John   589274 589274 Tomson, John, of Cotyngham 0
4473163 2192271 2192271 plaintiff Crauncewyk Andrew   589274 589274 Crauncewyk, Andrew, of Cotyngham 0
4478035 2193800 2193800 defendant Crammewyk Andrew   589274 589274 Crammewyk, Andrew, of Cotyngham 0
4484424 2195821 2195821 defendant Rafkhull John   589274 589274 Rafkhull, John, of Cotyngham 2
4497015 2199729 2199729 defendant Spaigne William de   589274 589274 Spaigne, William de, of Cotyngham 0
4508171 2203031 2203031 defendant atte Brigge John   589274 589274 atte Brigge, John, of Cotyngham 0
4523561 2207693 2207693 plaintiff Hawekyn Helen   589274 589274 Hawekyn, Helen, of Cotyngham 0
4530197 2209734 2209734 defendant Patryk Thomas   589274 589274 Patryk, Thomas, of Cotyngham 1
4530422 2209808 2209808 plaintiff Notyngham John   589274 589274 Notyngham, John, of Cotyngham, parson 0
4534123 2210940 2210940 defendant Baudenes William   589274 589274 Baudenes, William, of Cotyngham 0
4555154 2217546 2217546 plaintiff Hay Nicholas   589274 589274 Hay, Nicholas, of Cotyngham 0
4557021 2218122 2218122 defendant Forestere John   589274 589274 Forestere, John, of Cotyngham 0
4558344 2218554 2218554 defendant Forster John   589274 589274 Forster, John, of Cotyngham 0
4558345 2218554 2218554 defendant Cartwryght Thomas   589274 589274 Cartwryght, Thomas, of Cotyngham 1
4558346 2218554 2218554 defendant Pynder William   589274 589274 Pynder, William, of Cotyngham 2
4561471 2219522 2219522 plaintiff Pay John   589274 589274 Pay, John, of Cotyngham 0
4561474 2219522 2219522 defendant Flesshewer Richard   589274 589274 Flesshewer, Richard, of Cotyngham 2
4563796 2220245 2220245 plaintiff Rothewell John   589274 589274 Rothewell, John, of Cotyngham 0
4563983 2220310 2220310 plaintiff Ruston John de   589274 589274 Ruston, John de, of Cotyngham 0
4563988 2220310 2220310 defendant Grome Joan   589274 589274 Grome, Joan, of Cotyngham 4
4579223 2224983 2224983 plaintiff Cook Alice (legal representative) 589274 589274 Cook, Alice, of Cotyngham, executor of 0
4581004 2225537 2225537 defendant Milner Andrew   589274 589274 Milner, Andrew, of Cotyngham 2
4581933 2225798 2225798 defendant Milner Andrew   589274 589274 Milner, Andrew, of Cotyngham 2
4581934 2225798 2225798 defendant Wragby William   589274 589274 Wragby, William, of Cotyngham 3
4588479 2227766 2227766 defendant Russell Simon   589274 589274 Russell, Simon, of Cotyngham 0
4595735 2229920 2229920 plaintiff Holme William   589274 589274 Holme, William, of Cotyngham 1
4598397 2230738 2230738 defendant Haukyn Agnes   589274 589274 Haukyn, Agnes, of Cotyngham 0
4600574 2231402 2231402 plaintiff Tomson Robert   589274 589274 Tomson, Robert, of Cotyngham 0
4609312 2234013 2234013 defendant Russell Simon   589274 589274 Russell, Simon, of Cotyngham 0
4617029 2236335 2236335 defendant Marsshall Robert   589274 589274 Marsshall, Robert, of Cotyngham 2
4627763 2239612 2239612 defendant Ryton William   589274 589274 Ryton, William, of Cotyngham 2
4627940 2239668 2239668 plaintiff Ruston John   589274 589274 Ruston, John, of Cotyngham 0
4660081 2248995 2248995 defendant Robynson Thomas husbandman 589274 589274 Robynson, Thomas, of Cotyngham, husbandman 0
4662175 2249644 2249644 plaintiff Flesshewer Walter   589274 589274 Flesshewer, Walter, of Cotyngham 0
4662176 2249644 2249644 defendant Braban Simon yeoman 589274 589274 Braban, Simon, of Cotyngham, yeoman 0
4662177 2249644 2249644 defendant Braban John yeoman 589274 589274 Braban, John, of Cotyngham, yeoman 1
4664749 2250454 2250454 defendant Brygge John, junior chapman 589274 589274 Brygge, John, junior, of Cotyngham, chapman 0
4664750 2250454 2250454 defendant Ruston John chapman 589274 589274 Ruston, John, of Cotyngham, chapman 1
4669759 2256243 2256243 defendant Isabell Thomas yeoman 589274 589274 Isabell, Thomas, of Cotyngham, yeoman 0
4670266 2256406 2256406 defendant Brigge John husbandman 589274 589274 Brigge, John, of Cotyngham, husbandman 0
4670267 2256406 2256406 defendant Ruston John husbandman 589274 589274 Ruston, John, of Cotyngham, husbandman 1
4675286 2257881 2257881 defendant Middilton John   589274 589274 Middilton, John, of Cotyngham, cartwright 2
4678978 2259032 2259032 defendant atte Lane William laborer 589274 589274 atte Lane, William, of Cotyngham, laborer 5
4678979 2259032 2259032 defendant Luff Robert smith 589274 589274 Luff, Robert, of Cotyngham, smith 6
4679370 2259163 2259163 defendant Tomson John chapman 589274 589274 Tomson, John, of Cotyngham, chapman 0
4682709 2260208 2260208 plaintiff Notyngham John   589274 589274 Notyngham, John, of Cotyngham, parson 0
4682711 2260208 2260208 defendant Ruston John de husbandman 589274 589274 Ruston, John de, of Cotyngham, husbandman 1
4685029 2260916 2260916 plaintiff Robynson Thomas   589274 589274 Robynson, Thomas, of Cotyngham 0
4685450 2261047 2261047 plaintiff Ruston John   589274 589274 Ruston, John, of Cotyngham 0
4688626 2262005 2262005 defendant Palmer John husbandman 589274 589274 Palmer, John, of Cotyngham, husbandman 4
4690035 2262434 2262434 defendant Russell Simon   589274 589274 Russell, Simon, of Cotyngham 2
4690037 2262435 2262435 defendant Russell Simon gent 589274 589274 Russell, Simon, of Cotyngham, gent 0
4690741 2262648 2262648 defendant Flesshewer Walter butcher 589274 589274 Flesshewer, Walter, of Cotyngham, butcher 1
4690749 2262649 2262649 defendant Holme William husbandman 589274 589274 Holme, William, of Cotyngham, husbandman 0
4691978 2263026 2263026 plaintiff Angeland John   589274 589274 Angeland, John, of Cotyngham 0
4695537 2264088 2264088 defendant Watson Thomas husbandman 589274 589274 Watson, Thomas, of Cotyngham, husbandman 0
4700792 2265648 2265648 plaintiff Flesshewer Richard   589274 589274 Flesshewer, Richard, of Cotyngham 0
4703198 2266380 2266380 defendant Drigge John yeoman 589274 589274 Drigge, John, of Cotyngham, yeoman 0
4704469 2266773 2266773 plaintiff Ingeland John   589274 589274 Ingeland, John, of Cotyngham 0
4704513 2266786 2266786 defendant Marsshall John coser 589274 589274 Marsshall, John, of Cotyngham, coser 0
4704514 2266786 2266786 defendant Marsshall William coser or horse master 589274 589274 Marsshall, William, of Cotyngham, coser or horse master 1
4711398 2268896 2268896 plaintiff Ruston John   589274 589274 Ruston, John, of Cotyngham 0
4712454 2269210 2269210 defendant Dey John   589274 589274 Dey, John, of Cotyngham, coverlet weaver 1
4714238 2269783 2269783 defendant Palmer John husbandman 589274 589274 Palmer, John, of Cotyngham, husbandman 4
4720217 2271668 2271668 plaintiff Brigge John   589274 589274 Brigge, John, of Cotyngham 0
4720897 2271869 2271869 defendant Mildvale Robert clerk 589274 589274 Mildvale, Robert, of Cotyngham, clerk 2
4725029 2273124 2273124 plaintiff Forester Gillian   589274 589274 Forester, Gillian, of Cotyngham, formerly wife of John Forester 0
4733272 2275584 2275584 defendant Hawekyne Thomas   589274 589274 Hawekyne, Thomas, of Cotyngham, mason 0
4733933 2275798 2275798 defendant Marsshall John yeoman 589274 589274 Marsshall, John, of Cotyngham, yeoman 0
4735279 2276181 2276181 defendant Hode William   589274 589274 Hode, William, of Cotyngham 0
4736852 2276655 2276655 defendant Watson John butcher 589274 589274 Watson, John, of Cotyngham, butcher 0
4739451 2277422 2277422 defendant Marsshall John husbandman 589274 589274 Marsshall, John, of Cotyngham, husbandman 2
4740713 2277802 2277802 defendant Barbour Thomas barber 589274 589274 Barbour, Thomas, of Cotyngham, barber 1
4741778 2278088 2278088 defendant Dey Robert husbandman 589274 589274 Dey, Robert, of Cotyngham, husbandman 1
4741779 2278088 2278088 defendant Randolfes John husbandman 589274 589274 Randolfes, John, of Cotyngham, husbandman 2
4741780 2278088 2278088 defendant Geffreyson John husbandman 589274 589274 Geffreyson, John, of Cotyngham, husbandman 3

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