names

407 rows where place_id = 587151

✎ 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
3590602 1864704 1864704 defendant Baldware Roger husbandman 587151 587151 Baldware, Roger, of Flete, husbandman 1
3590603 1864704 1864704 defendant Chawreney John husbandman 587151 587151 Chawreney, John, of Flete, husbandman 2
3591193 1864868 1864868 defendant Honyn or Hovyn John yeoman 587151 587151 Honyn or Hovyn, John, of Flete, yeoman 1
3591194 1864868 1864868 defendant Clerke John yeoman 587151 587151 Clerke, John, of Flete, yeoman 2
3626584 1903168 1903168 defendant Dawson William yeoman 587151 587151 Dawson, William, of Flete, yeoman 0
3628684 1903845 1903845 defendant Richardson John husbandman 587151 587151 Richardson, John, of Flete, husbandman 3
3633002 1905141 1905141 defendant Clerk John husbandman 587151 587151 Clerk, John, of Flete, husbandman 1
3671519 1917075 1917075 defendant Richardson John husbandman 587151 587151 Richardson, John, of Flete, husbandman 1
3676562 1918710 1918710 defendant Oldeher John husbandman 587151 587151 Oldeher, John, of Flete, husbandman 3
3707736 1928715 1928715 defendant Thornyngton John yeoman 587151 587151 Thornyngton, John, of Flete, yeoman 0
3717030 1931611 1931611 defendant Albrowgh Thomas smith 587151 587151 Albrowgh, Thomas, of Flete, smith 0
3768244 1947708 1947708 defendant Alburgh Thomas smith 587151 587151 Alburgh, Thomas, of Flete, smith 0
3768247 1947708 1947708 defendant Richardson John husbandman 587151 587151 Richardson, John, of Flete, husbandman 3
3776816 1950490 1950490 defendant Morley Thomas husbandman 587151 587151 Morley, Thomas, of Flete, husbandman 0
3843349 1971454 1971454 defendant White John yeoman 587151 587151 White, John, of Flete, yeoman 0
3866951 1979185 1979185 defendant Treesse alias Wyllyamson William husbandman 587151 587151 Treesse alias Wyllyamson, William, of Flete, husbandman 0
3888807 1986509 1986509 defendant West Robert husbandman 587151 587151 West, Robert, of Flete, husbandman 0
3888808 1986509 1986509 defendant Hotoft William husbandman 587151 587151 Hotoft, William, of Flete, husbandman 1
3900523 1990405 1990405 defendant Lawes Richard husbandman 587151 587151 Lawes, Richard, of Flete, husbandman 0
3900524 1990405 1990405 defendant Elman Anthony husbandman 587151 587151 Elman, Anthony, of Flete, husbandman 1
3924057 1998356 1998356 defendant Hepes John yeoman 587151 587151 Hepes, John, of Flete, yeoman 0
3947103 2006053 2006053 defendant Cure John yeoman 587151 587151 Cure, John, of Flete, yeoman 0
3951673 2007638 2007638 defendant Wallesgrove Thomas clothier 587151 587151 Wallesgrove, Thomas, of Flete, clothier 2
3958275 2009970 2009970 defendant Wynsley William carpenter 587151 587151 Wynsley, William, of Flete, carpenter 0
4004521 2026391 2026391 defendant Pynchebek Thomas husbandman 587151 587151 Pynchebek, Thomas, of Flete, husbandman 0
4136331 2073339 2073339 defendant Sampole Brian gent 587151 587151 Sampole, Brian, of Flete, gent 0
4139418 2074459 2074459 defendant Leves John tailor 587151 587151 Leves, John, of Flete, tailor 2
4160634 2081793 2081793 defendant Ewyn Richard yeoman 587151 587151 Ewyn, Richard, of Flete, yeoman 0
4160636 2081794 2081794 defendant Kerby John butcher 587151 587151 Kerby, John, of Flete, butcher 0
4283497 2124131 2124131 defendant Beslaby Anthony tailor 587151 587151 Beslaby, Anthony, of Flete, tailor 0
4422332 2171853 2171853 plaintiff Elme Hulma   587151 587151 Elme, Hulma, of Flete, formerly wife of Geoffrey 0
4422334 2171854 2171854 plaintiff Elme Hulma   587151 587151 Elme, Hulma, of Flete, formerly wife of Geoffrey 0
4422335 2171854 2171854 defendant Tener John   587151 587151 Tener, John, of Flete, junior 0
4424075 2172383 2172383 plaintiff Hode William   587151 587151 Hode, William, of Flete 0
4424078 2172383 2172383 defendant Nele John   587151 587151 Nele, John, of Flete, son of Robert 2
4425705 2172852 2172852 plaintiff Michel Richard   587151 587151 Michel, Richard, of Flete 0
4425707 2172853 2172853 plaintiff Michel Richard   587151 587151 Michel, Richard, of Flete 0
4433269 2175159 2175159 plaintiff Forester John le   587151 587151 Forester, John le, of Flete 0
4434061 2175412 2175412 plaintiff Hode John   587151 587151 Hode, John, of Flete 0
4436034 2176003 2176003 plaintiff Ray Thomas   587151 587151 Ray, Thomas, of Flete 0
4436036 2176004 2176004 plaintiff Ray Thomas   587151 587151 Ray, Thomas, of Flete 0
4445115 2183444 2183444 plaintiff Cotte Robert   587151 587151 Cotte, Robert, of Flete 0
4445118 2183445 2183445 plaintiff Cotte Robert   587151 587151 Cotte, Robert, of Flete 0
4445120 2183446 2183446 plaintiff Cotte William   587151 587151 Cotte, William, of Flete 0
4445121 2183446 2183446 defendant Crisp Roger   587151 587151 Crisp, Roger, of Flete 0
4446954 2183963 2183963 defendant Frere Richard   587151 587151 Frere, Richard, of Flete 0
4449995 2184955 2184955 defendant Walsshe John   587151 587151 Walsshe, John, of Flete 0
4451211 2185338 2185338 defendant Colleson John   587151 587151 Colleson, John, of Flete 0
4451413 2185415 2185415 defendant Crisp Roger   587151 587151 Crisp, Roger, of Flete 0
4451414 2185415 2185415 defendant Athelard John   587151 587151 Athelard, John, of Flete 1
4458936 2187841 2187841 defendant Reveson Roger   587151 587151 Reveson, Roger, of Flete 7
4475905 2193138 2193138 defendant Flete Fulco   587151 587151 Flete, Fulco, of Flete, son of Roger 1
4475906 2193138 2193138 defendant Sporoun Thomas   587151 587151 Sporoun, Thomas, of Flete 2
4475912 2193140 2193140 plaintiff Gedenay John de   587151 587151 Gedenay, John de, of Flete 3
4477358 2193582 2193582 plaintiff Grene John de   587151 587151 Grene, John de, of Flete 0
4478723 2194012 2194012 plaintiff Hode Thomas   587151 587151 Hode, Thomas, of Flete 0
4485348 2196118 2196118 defendant Warde Richard   587151 587151 Warde, Richard, of Flete 0
4487257 2196731 2196731 defendant Love Roger de   587151 587151 (Love, Roger de, of Flete 1
4488849 2197229 2197229 defendant Hogekynson Fulco   587151 587151 Hogekynson, Fulco, of Flete 1
4495387 2199239 2199239 defendant Roper John   587151 587151 Roper, John, of Flete 0
4498788 2200254 2200254 plaintiff Gedney John   587151 587151 Gedney, John, of Flete 0
4498791 2200254 2200254 defendant Love Roger   587151 587151 Love, Roger, of Flete 2
4501985 2201218 2201218 defendant Caudelyr Robert   587151 587151 Caudelyr, Robert, of Flete 3
4509278 2203379 2203379 defendant Wissebich John (legal representative) 587151 587151 Wissebich, John, of Flete, executors of 2
4511478 2204036 2204036 defendant atte Grene John   587151 587151 atte Grene, John, of Flete, son of Hugh, jun 0
4512873 2204457 2204457 defendant Roper John   587151 587151 Roper, John, of Flete 0
4516243 2205489 2205489 plaintiff Coke John   587151 587151 Coke, John, of Flete 0
4516244 2205489 2205489 defendant Tyryngton John   587151 587151 Tyryngton, John, of Flete 0
4521580 2207084 2207084 plaintiff Gedenay John   587151 587151 Gedenay, John, of Flete 0
4522422 2207353 2207353 plaintiff Grene John de   587151 587151 Grene, John de, of Flete 0
4522435 2207356 2207356 plaintiff Grene John   587151 587151 Grene, John, of Flete 0
4522438 2207356 2207356 defendant Storme John   587151 587151 Storme, John, of Flete 2
4531643 2210157 2210157 defendant Baudry John   587151 587151 Baudry, John, of Flete 2
4535728 2211455 2211455 defendant Tyryngton Robert   587151 587151 Tyryngton, Robert, of Flete 1
4538912 2212441 2212441 plaintiff Tyryngton Robert   587151 587151 Tyryngton, Robert, of Flete 0
4538913 2212441 2212441 defendant Roberd Roger   587151 587151 Roberd, Roger, of Flete 0
4542169 2213442 2213442 defendant Coke William   587151 587151 Coke, William, of Flete 0
4542457 2213528 2213528 defendant Elys William   587151 587151 Elys, William, of Flete 5
4542458 2213528 2213528 defendant Grene William   587151 587151 Grene, William, of Flete 6
4542459 2213528 2213528 defendant Thakker Richard   587151 587151 Thakker, Richard, of Flete 7
4542461 2213528 2213528 defendant Kyng Lawrence   587151 587151 Kyng, Lawrence, of Flete 9
4542462 2213528 2213528 defendant Dygill Richard   587151 587151 Dygill, Richard, of Flete 10
4542792 2213633 2213633 defendant Roper John   587151 587151 Roper, John, of Flete 1
4549706 2215841 2215841 defendant Cok William   587151 587151 Cok, William, of Flete 0
4553447 2217006 2217006 plaintiff Gedeney William   587151 587151 Gedeney, William, of Flete 0
4553449 2217007 2217007 plaintiff Gedeney William   587151 587151 Gedeney, William, of Flete, son of William 0
4553452 2217008 2217008 plaintiff Gednay John   587151 587151 Gednay, John, of Flete 0
4554319 2217280 2217280 plaintiff Grene John   587151 587151 Grene, John, of Flete 0
4554356 2217291 2217291 plaintiff Grene William   587151 587151 Grene, William, of Flete 0
4555070 2217515 2217515 defendant Feld Reginald   587151 587151 Feld, Reginald, of Flete 0
4555558 2217668 2217668 defendant Welynote Richard   587151 587151 Welynote, Richard, of Flete 0
4564411 2220438 2220438 defendant Watteson William   587151 587151 Watteson, William, of Flete 2
4570774 2222432 2222432 plaintiff Wyllymot Richard   587151 587151 Wyllymot, Richard, of Flete 0
4570775 2222432 2222432 defendant Jangill Robert   587151 587151 Jangill, Robert, of Flete 0
4584049 2226430 2226430 plaintiff Gedeney William   587151 587151 Gedeney, William, of Flete 0
4584050 2226430 2226430 defendant Storme Richard   587151 587151 Storme, Richard, of Flete 0
4584893 2226707 2226707 plaintiff Grene John   587151 587151 Grene, John, of Flete 0
4584897 2226708 2226708 plaintiff Grene John   587151 587151 Grene, John, of Flete 0
4584898 2226708 2226708 defendant Hood Thomas   587151 587151 Hood, Thomas, of Flete 0
4586166 2227096 2227096 defendant Grene John   587151 587151 Grene, John, of Flete 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);