names

289 rows where place_id = 587327

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3591090 1864838 1864838 defendant Mylward Robert yeoman 587327 587327 Mylward, Robert, of Eton, yeoman 16
3600055 1867670 1867670 defendant Styllyerd Thomas yeoman 587327 587327 Styllyerd, Thomas, of Eton, yeoman 1
3600132 1867693 1867693 defendant Nyxson Richard butcher 587327 587327 Nyxson, Richard, of Eton, butcher 1
3600310 1867743 1867743 defendant Love or Lone Thomas husbandman 587327 587327 Love or Lone, Thomas, of Eton, husbandman 2
3610042 1870811 1870811 defendant Rede Robert husbandman 587327 587327 Rede, Robert, of Eton, husbandman 7
3610043 1870811 1870811 defendant Herdson Miles yeoman 587327 587327 Herdson, Miles, of Eton, yeoman 8
3625977 1902982 1902982 defendant Scott Thomas yeoman 587327 587327 Scott, Thomas, of Eton, yeoman 0
3625978 1902982 1902982 defendant Bolno Thomas shoemaker 587327 587327 Bolno, Thomas, of Eton, shoemaker 1
3627664 1903513 1903513 defendant Barleman Thomas roper 587327 587327 Barleman, Thomas, of Eton, roper 0
3630933 1904494 1904494 defendant Rowde Thomas, senior butcher 587327 587327 Rowde, Thomas, senior, of Eton, butcher 1
3650874 1910640 1910640 defendant Grenelef James husbandman 587327 587327 Grenelef, James, of Eton, husbandman 0
3670330 1916673 1916673 defendant Fokett John husbandman 587327 587327 Fokett, John, of Eton, husbandman 0
3685552 1921631 1921631 defendant Fokett John husbandman 587327 587327 Fokett, John, of Eton, husbandman 0
3689953 1923017 1923017 defendant Rowde Thomas butcher 587327 587327 Rowde, Thomas, of Eton, butcher 2
3696820 1925229 1925229 defendant Ronde Thomas butcher 587327 587327 Ronde, Thomas, of Eton, butcher 1
3703638 1927418 1927418 defendant Fraunceys John husbandman 587327 587327 Fraunceys, John, of Eton, husbandman 0
3719892 1932492 1932492 defendant Bampton John husbandman 587327 587327 Bampton, John, of Eton, husbandman 0
3721280 1932961 1932961 defendant Grene William, senior husbandman 587327 587327 Grene, William, senior, of Eton, husbandman 0
3721915 1933118 1933118 defendant Knyght John yeoman 587327 587327 Knyght, John,of Eton, yeoman 0
3721916 1933118 1933118 defendant Freere Richard laborer 587327 587327 Freere, Richard, of Eton, laborer 1
3729238 1935395 1935395 defendant Ketell William yeoman 587327 587327 Ketell, William, of Eton, yeoman 1
3747078 1941003 1941003 defendant Wiggearn William husbandman 587327 587327 Wiggearn, William, of Eton juxta Leomynster, husbandman 0
3747393 1941099 1941099 defendant Caldwall Giles husbandman 587327 587327 Caldwall, Giles, of Eton juxta Leomynster, husbandman 1
3750374 1942037 1942037 defendant Baxter John butcher 587327 587327 Baxter, John, of Eton, butcher 0
3760642 1945329 1945329 defendant Akett Thomas husbandman 587327 587327 Akett, Thomas, of Eton, husbandman 0
3760929 1945423 1945423 defendant Myles John yeoman 587327 587327 Myles, John, of Eton juxta Leompster, yeoman 0
3760930 1945423 1945423 defendant Mores Henry husbandman 587327 587327 Mores, Henry, of Eton juxta Leompster, husbandman 1
3770480 1948449 1948449 defendant Carter Robert beer brewer 587327 587327 Carter, Robert, of Eton, or of Uxbygge, Middx, beer brewer 0
3770481 1948450 1948450 plaintiff Smyth Henry gent 587327 587327 Smyth, Henry, of Eton, gent 0
3770482 1948450 1948450 defendant Carter Robert beer brewer 587327 587327 Carter, Robert, of Eton, beer brewer 0
3770656 1948507 1948507 defendant Knyght William yeoman 587327 587327 Knyght, William, of Eton, yeoman 0
3770657 1948507 1948507 defendant Knyght Thomas yeoman 587327 587327 Knyght, Thomas, of Eton, yeoman 1
3770661 1948508 1948508 defendant Byrde William yeoman 587327 587327 Byrde, William, of Eton, yeoman 1
3770662 1948508 1948508 defendant Skevyngton William yeoman 587327 587327 Skevyngton, William, of Eton, yeoman 2
3770908 1948587 1948587 defendant Temson Thomas husbandman 587327 587327 Temson, Thomas, of Eton, husbandman 0
3772077 1948958 1948958 defendant Elyot Thomas warrener 587327 587327 Elyot, Thomas, of Eton, warrener 1
3772078 1948958 1948958 defendant Lylly Richard warrener 587327 587327 Lylly, Richard, of Eton, warrener 2
3772079 1948958 1948958 defendant Spurre John husbandman 587327 587327 Spurre, John, of Eton, husbandman 3
3778676 1951045 1951045 defendant Alet Thomas warrener 587327 587327 Alet, Thomas, of Eton, warrener 0
3787095 1953759 1953759 defendant Akyrs Robert   587327 587327 Akyrs, Robert, of Eton, worsted weaver 0
3787097 1953759 1953759 defendant Burton John husbandman 587327 587327 Burton, John, of Eton, husbandman 2
3793685 1955890 1955890 defendant Akers Robert   587327 587327 Akers, Robert, of Eton, worsted weaver 2
3799504 1957764 1957764 defendant Gent Edward laborer 587327 587327 Gent, Edward, of Eton, laborer 2
3802030 1958533 1958533 defendant Fuller Richard smith 587327 587327 Fuller, Richard, of Eton, smith 0
3803372 1958955 1958955 defendant Akrys Robert   587327 587327 Akrys, Robert, of Eton, worsted weaver 0
3807724 1960303 1960303 defendant Baxster John butcher 587327 587327 Baxster, John, of Eton, butcher 2
3808665 1960591 1960591 defendant Austen Robert husbandman 587327 587327 Austen, Robert, of Eton, husbandman 0
3809900 1960981 1960981 defendant Alyet Thomas husbandman 587327 587327 Alyet, Thomas, of Eton, husbandman 0
3814255 1962365 1962365 defendant Mowysdale Robert husbandman 587327 587327 Mowysdale, Robert, of Eton, husbandman 0
3815421 1962740 1962740 defendant Newton William yeoman 587327 587327 Newton, William, of Eton, yeoman 0
3820765 1964385 1964385 defendant Aylett Thomas husbandman 587327 587327 Aylett, Thomas, of Eton, husbandman 0
3820795 1964394 1964394 defendant Wilton William husbandman 587327 587327 Wilton, William, of Eton, husbandman 0
3820796 1964394 1964394 defendant Burton John husbandman 587327 587327 Burton, John, of Eton, husbandman 1
3828587 1966818 1966818 defendant Parker Thomas husbandman 587327 587327 Parker, Thomas, of Eton, husbandman 1
3829774 1967206 1967206 defendant Velowe John   587327 587327 Velowe, John, of Eton, yeoman, bailiff of Bycoleswade Hundred 0
3839795 1970374 1970374 defendant Lodyngton John yeoman 587327 587327 Lodyngton, John, of Eton, yeoman 3
3849974 1973580 1973580 defendant Ayre Robert husbandman 587327 587327 Ayre, Robert, of Eton, husbandman 0
3849975 1973580 1973580 defendant Dixcy John butcher 587327 587327 Dixcy, John, of Eton, butcher 1
3853485 1974715 1974715 defendant Benyngton Jerome haberdasher 587327 587327 Benyngton, Jerome, of Eton, haberdasher 1
3853488 1974716 1974716 defendant Benyngton Jerome haberdasher 587327 587327 Benyngton, Jerome, of Eton, haberdasher 1
3879289 1983326 1983326 plaintiff Milward Robert   587327 587327 Milward, Robert, of Eton 0
3895522 1988707 1988707 defendant Andrewe Robert tailor 587327 587327 Andrewe, Robert, of Eton, tailor 0
3895523 1988707 1988707 defendant Ade William carpenter 587327 587327 Ade, William, of Eton, carpenter 1
3925201 1998739 1998739 defendant Myles John husbandman 587327 587327 Myles, John, of Eton juxta Leomynster, husbandman 1
3932678 2001226 2001226 defendant Kynes John carrier 587327 587327 Kynes, John, of Eton, carrier 0
3935342 2002134 2002134 defendant ap John Gough Lewis yeoman 587327 587327 ap John Gough, Lewis, of Eton, yeoman 0
3935517 2002187 2002187 defendant Bechampe Thomas husbandman 587327 587327 Bechampe, Thomas, of Eton, husbandman 0
3956192 2009238 2009238 defendant Mylward Margery spinster 587327 587327 Mylward, Margery, of Eton, spinster 0
3956193 2009238 2009238 defendant Mylward Edith spinster 587327 587327 Mylward, Edith, of Eton, spinster 1
3956194 2009238 2009238 defendant Wylde John laborer 587327 587327 Wylde, John, of Eton, laborer 2
3956195 2009238 2009238 defendant Crosse John laborer 587327 587327 Crosse, John, of Eton, laborer 3
3990656 2021410 2021410 plaintiff Blayston Christopher yeoman 587327 587327 Blayston, Christopher, of Eton, yeoman 0
4105645 2062307 2062307 defendant Kippis Thomas husbandman 587327 587327 Kippis, Thomas, of Eton, husbandman 0
4416677 2170081 2170081 defendant Wayde John le   587327 587327 Wayde, John le, of Eton 0
4423338 2172152 2172152 plaintiff Golde John   587327 587327 Golde, John, of Eton 0
4423339 2172152 2172152 defendant Chapeleyn John, senior   587327 587327 Chapeleyn, John, senior, of Eton 0
4423345 2172152 2172152 defendant Waryn William   587327 587327 Waryn, William, of Eton 6
4423458 2172191 2172191 defendant Chapeleyn John, senior   587327 587327 Chapeleyn, John, senior, of Eton 0
4423464 2172191 2172191 defendant Waryn William   587327 587327 Waryn, William, of Eton 6
4425901 2172904 2172904 defendant Fulham John de   587327 587327 Fulham, John de, of Eton by Leominster 0
4455519 2186732 2186732 plaintiff Covesgrave John   587327 587327 Covesgrave, John, of Eton 1
4455867 2186850 2186850 plaintiff Covesgrave John   587327 587327 Covesgrave, John, of Eton 1
4499269 2200421 2200421 plaintiff Hakeluyt Hugh   587327 587327 Hakeluyt, Hugh, of Eton 0
4519860 2206562 2206562 defendant Helgeye John   587327 587327 Helgeye, John, of Eton 1
4522816 2207474 2207474 defendant Taillour William   587327 587327 Taillour, William, of Eton, son of John 0
4527078 2208750 2208750 defendant Strete Thomas   587327 587327 Strete, Thomas, of Eton 0
4537401 2211966 2211966 defendant Fyschore John   587327 587327 Fyschore, John, of Eton 0
4554648 2217381 2217381 plaintiff Hakeluyt Hugh   587327 587327 Hakeluyt, Hugh, of Eton 0
4560212 2219143 2219143 defendant Hamond Walter   587327 587327 Hamond, Walter, of Eton 0
4560748 2219313 2219313 defendant Rede John   587327 587327 Rede, John, of Eton 0
4591949 2228836 2228836 plaintiff Daventre John chaplain 587327 587327 Daventre, John, of Eton, chaplain 1
4591952 2228837 2228837 plaintiff Daventre John chaplain 587327 587327 Daventre, John, of Eton, chaplain 1
4596390 2230121 2230121 defendant Pelyng Walter   587327 587327 Pelyng, Walter, of Eton 0
4610080 2234240 2234240 plaintiff Calton Nicholas   587327 587327 Calton, Nicholas, of Eton, prebendary of the prebend 0
4610082 2234240 2234240 defendant (not given) John vicar of Porter 587327 587327 Porter, John, of Eton, vicar of the parish church 0
4619042 2236949 2236949 defendant Norman John   587327 587327 Norman, John, of Eton 0
4622303 2237955 2237955 defendant Turnour Richard   587327 587327 Turnour, Richard, of Eton 0
4625850 2239037 2239037 plaintiff Pete Thomas   587327 587327 Pete, Thomas, of Eton 0
4632816 2241142 2241142 defendant Lord John, sen   587327 587327 Lord, John, sen, of Eton 0
4655769 2247688 2247688 plaintiff Bullok John   587327 587327 Bullok, John, of Eton 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);