names

139 rows where place_id = 586212

✎ 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
3588175 1863955 1863955 defendant Aldeforde Thomas (legal representative) 586212 586212 Aldeforde, Thomas, of Huntyngton, husbandman, executors of 0
3588176 1863955 1863955 defendant Aldeford Agnes widow 586212 586212 (Aldeford, Agnes, of Huntyngton, widow 1
3604337 1869021 1869021 defendant Rolf Thomas butcher 586212 586212 Rolf, Thomas, of Huntyngton, butcher 2
3610009 1870801 1870801 defendant Swettenham William innholder 586212 586212 Swettenham, William, of Huntyngton, innholder 0
3615230 1872411 1872411 defendant Reve John laborer 586212 586212 Reve, John, of Huntyngton, laborer 0
3628387 1903744 1903744 defendant Alford John husbandman 586212 586212 Alford, John, of Huntyngton, husbandman 0
3642367 1908060 1908060 defendant Alford John husbandman 586212 586212 Alford, John, of Huntyngton, husbandman 0
3679854 1919763 1919763 defendant Cowper William chapman 586212 586212 Cowper, William, of Huntyngton, chapman 3
3687198 1922173 1922173 defendant Holme Wilfred esq 586212 586212 Holme, Wilfred, of Huntyngton, esq 0
3690256 1923112 1923112 defendant Holme Wilfred gent 586212 586212 Holme, Wilfred, of Huntyngton, gent 0
3702286 1926971 1926971 defendant Holme Wilfram esq 586212 586212 Holme, Wilfram, of Huntyngton, esq 0
3715950 1931276 1931276 defendant Holme Wilfred esq 586212 586212 Holme, Wilfred, of Huntyngton, esq 0
3736660 1937719 1937719 defendant Ryche William yeoman 586212 586212 Ryche, William, of Huntyngton, yeoman 0
3736661 1937719 1937719 defendant Gebon Thomas carpenter 586212 586212 Gebon, Thomas, of Huntyngton, carpenter 1
3768760 1947879 1947879 defendant Thong William tailor 586212 586212 Thong, William, of Huntyngton, tailor 0
3770074 1948303 1948303 defendant Holme Wilfred gent 586212 586212 Holme, Wilfred, of Huntyngton, gent 0
3770225 1948355 1948355 defendant Holme Wilfred gent 586212 586212 Holme, Wilfred, of Huntyngton, gent 0
3770228 1948356 1948356 defendant Holme Wilfred gent 586212 586212 Holme, Wilfred, of Huntyngton, gent 0
3804656 1959396 1959396 defendant Broun Thomas husbandman 586212 586212 Broun, Thomas, of Huntyngton, husbandman 0
3805074 1959528 1959528 defendant Harford Robert gent 586212 586212 Harford, Robert, of Huntyngton, gent 0
3807894 1960356 1960356 defendant Hartford Robert brewer 586212 586212 Hartford, Robert, of Huntyngton, brewer 0
3821352 1964569 1964569 defendant Watson Richard pewterer 586212 586212 Watson, Richard, of Huntyngton, pewterer 1
3828543 1966802 1966802 defendant Newell Robert chaplain 586212 586212 Newell, Robert, of Huntyngton, chaplain 1
3828544 1966802 1966802 defendant Bayes William shoemaker 586212 586212 Bayes, William, of Huntyngton, shoemaker 2
3839213 1970192 1970192 plaintiff Webbe John (legal representative) 586212 586212 Webbe, John, of Huntyngton, executors of 0
3839216 1970192 1970192 defendant Blakamore Walter husbandman 586212 586212 Blakamore, Walter, of Huntyngton, husbandman 0
3868837 1979818 1979818 defendant Clugh Richard yeoman 586212 586212 Clugh, Richard, of Huntyngton, yeoman 3
3882726 1984486 1984486 defendant ap Thomas John husbandman 586212 586212 ap Thomas, John, of Huntyngton, husbandman 1
3885375 1985364 1985364 defendant Moryce Walter chaplain 586212 586212 Moryce, Walter, of Huntyngton, chaplain 3
3901553 1990743 1990743 defendant Creswall George husbandman 586212 586212 Creswall, George, of Huntyngton, husbandman 0
3911516 1994169 1994169 defendant ap Rees David   586212 586212 ap Rees, David, of Huntyngton 1
3923994 1998336 1998336 defendant Blynkern Robert innkeeper 586212 586212 Blynkern, Robert, of Huntyngton, innkeeper 0
3924000 1998337 1998337 defendant Blynkern Robert innkeeper 586212 586212 Blynkern, Robert, of Huntyngton, innkeeper 0
3950056 2007104 2007104 defendant Blakewey Roger husbandman 586212 586212 Blakewey, Roger, of Huntyngton, husbandman 0
3950057 2007104 2007104 defendant Yorke Robert laborer 586212 586212 Yorke, Robert, of Huntyngton, laborer 1
3950058 2007104 2007104 defendant Yorke Richard laborer 586212 586212 Yorke, Richard, of Huntyngton, laborer 2
3950059 2007104 2007104 defendant Churche Hugh laborer 586212 586212 Churche, Hugh, of Huntyngton, laborer 3
3956340 2009283 2009283 defendant Holme Seth esq 586212 586212 Holme, Seth, of Huntyngton, esq 1
3956962 2009500 2009500 defendant Maholon John yeoman 586212 586212 Maholon, John, of Huntyngton, yeoman 3
3961516 2011128 2011128 plaintiff Turryn John gent 586212 586212 Turryn, John, of Huntyngton, gent 0
3961517 2011128 2011128 plaintiff Rygg Charles yeoman 586212 586212 Rygg, Charles, of Huntyngton, yeoman 1
3988230 2020538 2020538 defendant Holle John, junior yeoman 586212 586212 Holle, John, junior, of Huntyngton, yeoman 0
4020913 2032207 2032207 defendant Sympcott William gent 586212 586212 Sympcott, William, of Huntyngton, gent 1
4028035 2034679 2034679 plaintiff Colly Richard husbandman 586212 586212 Colly, Richard, of Huntyngton, husbandman 0
4028038 2034679 2034679 defendant Chimall or Chunall Isabel widow 586212 586212 Chimall or Chunall, Isabel, of Huntyngton, widow 2
4036174 2037622 2037622 defendant Wryght Thomas yeoman 586212 586212 Wryght, Thomas, of Huntyngton, yeoman 1
4036244 2037645 2037645 defendant Hergest Roger yeoman 586212 586212 Hergest, Roger, of Huntyngton, yeoman 3
4038973 2038560 2038560 defendant Jones William gent 586212 586212 Jones, William, of Huntyngton, gent 0
4038974 2038560 2038560 defendant Meredith David husbandman 586212 586212 Meredith, David, of Huntyngton, husbandman 1
4038975 2038560 2038560 defendant ap John Watkin yeoman 586212 586212 ap John, Watkin, of Huntyngton, yeoman 2
4040327 2039045 2039045 defendant Lluwellen Rice gent 586212 586212 Lluwellen, Rice, of Huntyngton, gent 1
4053023 2043512 2043512 defendant Jaye Robert   586212 586212 Jaye, Robert, of Huntyngton, tallow chandler 1
4068110 2048901 2048901 defendant Gytto John yeoman 586212 586212 Gytto, John, of Huntyngton, yeoman 0
4068111 2048901 2048901 defendant ap Watkyn Rice yeoman 586212 586212 ap Watkyn, Rice, of Huntyngton, yeoman 1
4071059 2049950 2049950 defendant Gwynne Evan ap Jevan yeoman 586212 586212 Gwynne, Evan ap Jevan, of Huntyngton, yeoman 0
4078468 2052597 2052597 defendant ap Watkyn Rice yeoman 586212 586212 ap Watkyn, Rice, of Huntyngton, yeoman 0
4079900 2053112 2053112 defendant Thomas William John gent 586212 586212 Thomas, William John, of Huntyngton, gent, son of John Thomas, of Huntington, Herefs, gent 0
4085373 2055047 2055047 defendant ap Watkyn Rice gent 586212 586212 ap Watkyn, Rice, of Huntyngton, gent 1
4085379 2055048 2055048 defendant ap Watkyn Rice gent 586212 586212 ap Watkyn, Rice, of Huntyngton, gent 1
4087416 2055793 2055793 defendant Collye Richard husbandman 586212 586212 Collye, Richard, of Huntyngton, husbandman 0
4101238 2060750 2060750 defendant Hergest Roger husbandman 586212 586212 Hergest, Roger, of Huntyngton, husbandman 0
4101242 2060751 2060751 defendant Hergest Roger husbandman 586212 586212 Hergest, Roger, of Huntyngton, husbandman 0
4142635 2075591 2075591 defendant Gwyn Lewis gent 586212 586212 Gwyn, Lewis, of Huntyngton, gent 0
4143413 2075859 2075859 defendant Bowen Henry gent 586212 586212 Bowen, Henry, of Huntyngton, or of Llanyhangell Brynpabyan, Brecon, gent 0
4143414 2075859 2075859 defendant Griffith Lewis gent 586212 586212 Griffith, Lewis, of Huntyngton, or of Llanvarreth, Radnor, gent 1
4143419 2075860 2075860 defendant Gwynne John gent 586212 586212 Gwynne, John, of Huntyngton, or of Llanelwethe, Radnor, gent 0
4152541 2079003 2079003 defendant Eston Silvester yeoman 586212 586212 Eston, Silvester, of Huntyngton, yeoman 1
4218039 2101806 2101806 defendant Holme Seth esq 586212 586212 Holme, Seth, of Huntyngton, esq 0
4250447 2113134 2113134 defendant Holmes Seth esq 586212 586212 Holmes, Seth, of Huntyngton, esq 0
4257842 2115598 2115598 defendant Holme Seth gent 586212 586212 Holme, Seth, of Huntyngton, gent 0
4258039 2115659 2115659 defendant Holmes Seth (legal representative) 586212 586212 Holmes, Seth, of Huntyngton, esq, executor of 0
4258040 2115659 2115659 defendant Holmes Seth esq 586212 586212 Holmes, Seth, of Huntyngton, esq 1
4311845 2134279 2134279 defendant Bradford Richard yeoman 586212 586212 Bradford, Richard, of Huntyngton, yeoman 1
4594378 2229499 2229499 defendant Hurleton Robert   586212 586212 Hurleton, Robert, of Huntyngton 0
4594380 2229500 2229500 defendant Hurleton Robert   586212 586212 Hurleton, Robert, of Huntyngton 0
4672380 2257013 2257013 plaintiff Cod Thomas   586212 586212 Cod, Thomas, of Huntyngton 0
4892044 2324248 2324248 defendant Knappe Philip husbandman 586212 586212 Knappe, Philip, of Huntyngton, husbandman 2
4908813 2329306 2329306 defendant Parker Robert butcher 586212 586212 Parker, Robert, of Huntyngton, butcher 1
4969559 2347845 2347845 plaintiff Grocer John   586212 586212 Grocer, John, of Huntyngton 0
4976082 2349807 2349807 defendant Carpenter William carpenter 586212 586212 Carpenter, William, of Huntyngton, carpenter 3
5001592 2357358 2357358 defendant Salt Thomas husbandman 586212 586212 Salt, Thomas, of Huntyngton, husbandman 2
5080428 2380634 2380634 defendant Baldewine John husbndman 586212 586212 Baldewine, John, of Huntyngton, husbndman 1
5080429 2380634 2380634 defendant Joose John husbndman 586212 586212 Joose, John, of Huntyngton, husbndman 2
5084496 2381877 2381877 defendant Baldewyn John husbandman 586212 586212 Baldewyn, John, of Huntyngton, husbandman 0
5084497 2381877 2381877 defendant Botiller William husbandman 586212 586212 Botiller, William, of Huntyngton, husbandman 1
5084499 2381877 2381877 defendant Botiller John husbandman 586212 586212 Botiller, John, of Huntyngton, husbandman 3
5087680 2382784 2382784 defendant Baldewyn John husbandman 586212 586212 Baldewyn, John, of Huntyngton, husbandman 0
5087681 2382784 2382784 defendant Botiller William husbandman 586212 586212 Botiller, William, of Huntyngton, husbandman 1
5087683 2382784 2382784 defendant Botiller John husbandman 586212 586212 Botiller, John, of Huntyngton, husbandman 3
5092735 2384256 2384256 defendant Cartwryght Thomas husbandman 586212 586212 Cartwryght, Thomas, of Huntyngton, husbandman 0
5116695 2391316 2391316 defendant Coppyng Robert husbandman 586212 586212 Coppyng, Robert, of Huntyngton, husbandman 0
5147728 2400475 2400475 defendant Baldewyn John yeoman 586212 586212 Baldewyn, John, of Huntyngton, yeoman 0
5150167 2401190 2401190 defendant Gate Laurence husbandman 586212 586212 Gate, Laurence, of Huntyngton, husbandman 0
5150760 2401366 2401366 defendant Gate Lawrence husbandman 586212 586212 Gate, Lawrence, of Huntyngton, husbandman 0
5196125 2414612 2414612 defendant Fenton Robert laborer 586212 586212 Fenton, Robert, of Huntyngton, laborer 0
5196126 2414612 2414612 defendant Kirkeby John laborer 586212 586212 Kirkeby, John, of Huntyngton, laborer 1
5196127 2414612 2414612 defendant Clerk William husbandman 586212 586212 Clerk, William, of Huntyngton, husbandman 2
5196128 2414612 2414612 defendant Clerk John yeoman 586212 586212 Clerk, John, of Huntyngton, yeoman 3
5203522 2416781 2416781 defendant Baldewyn John yeoman 586212 586212 Baldewyn, John, of Huntyngton, yeoman 0
5236353 2426223 2426223 defendant atte Wyke John husbandman 586212 586212 atte Wyke, John, of Huntyngton, husbandman 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);