names

190 rows where place_id = 590698

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3602027 1868295 1868295 plaintiff Bounce Nicholas   590698 590698 Bounce, Nicholas, of Thame 0
3627594 1903489 1903489 defendant Pede John miller 590698 590698 Pede, John, of Thame, miller 1
3635441 1905880 1905880 defendant Launce Thomas butcher 590698 590698 Launce, Thomas, of Thame, butcher 3
3635442 1905880 1905880 defendant Kenner Thomas laborer 590698 590698 Kenner, Thomas, of Thame, laborer 4
3684565 1921306 1921306 plaintiff Yong William, junior baker 590698 590698 Yong, William, junior, of Thame, baker 0
3686214 1921852 1921852 plaintiff Bounse Thomas   590698 590698 Bounse, Thomas, of Thame 0
3693016 1924019 1924019 defendant Bray William yeoman 590698 590698 Bray, William, of Thame, yeoman 0
3699736 1926146 1926146 plaintiff Yong William yeoman 590698 590698 Yong, William, of Thame, yeoman 0
3708749 1929033 1929033 defendant Bisshop Alice   590698 590698 Bisshop, Alice, of Thame 1
3708751 1929034 1929034 defendant Bysshop John (legal representative) 590698 590698 Bysshop, John, of Thame, yeoman, executrix of 0
3713268 1930460 1930460 plaintiff Yong William baker 590698 590698 Yong, William, of Thame, baker 0
3726172 1934451 1934451 defendant Wodbrige William shoemaker 590698 590698 Wodbrige, William, of Thame, shoemaker 0
3743424 1939818 1939818 plaintiff Wodbrigge William   590698 590698 Wodbrigge, William, of Thame 0
3770930 1948593 1948593 defendant Elly John tailor 590698 590698 Elly, John, of Thame, tailor 0
3809312 1960793 1960793 defendant Batton Henry butcher 590698 590698 Batton, Henry, of Thame, butcher 0
3832127 1967957 1967957 defendant Harrys Thomas butcher 590698 590698 Harrys, Thomas, of Thame, butcher 0
3832128 1967957 1967957 defendant Fountayn Geoffrey smith 590698 590698 Fountayn, Geoffrey, of Thame, smith 1
3832129 1967957 1967957 defendant Handefyld Thomas mercer 590698 590698 Handefyld, Thomas, of Thame, mercer 2
3857240 1975897 1975897 defendant Owen David sherman 590698 590698 Owen, David, of Thame, sherman 0
3859327 1976611 1976611 defendant Steven Edward husbandman 590698 590698 Steven, Edward, of Thame, husbandman 1
3859330 1976612 1976612 defendant Steven Edward husbandman 590698 590698 Steven, Edward, of Thame, husbandman 1
3860318 1976952 1976952 defendant Bredon John   590698 590698 Bredon, John, of Thame, ash burner 0
3868238 1979612 1979612 defendant Whyte John miller 590698 590698 Whyte, John, of Thame, miller 0
3886929 1985891 1985891 defendant Wey William capper 590698 590698 Wey, William, of Thame, capper 0
3896297 1988972 1988972 defendant Wey William innholder 590698 590698 Wey, William, of Thame, innholder 0
3912036 1994350 1994350 defendant Ponde Richard   590698 590698 Ponde, Richard, of Thame, tallow chandler 0
3925660 1998896 1998896 plaintiff Wryghtson Nicholas   590698 590698 Wryghtson, Nicholas, of Thame 0
3925661 1998896 1998896 defendant Longe Henry carpenter 590698 590698 Longe, Henry, of Thame, carpenter 0
3925662 1998896 1998896 defendant Hawle Henry cooper 590698 590698 Hawle, Henry, of Thame, cooper 1
3925663 1998896 1998896 defendant Wyrgge Nicholas wheeler 590698 590698 Wyrgge, Nicholas, of Thame, wheeler 2
3943358 2004795 2004795 plaintiff Bedford John chandler 590698 590698 Bedford, John, of Thame, chandler 1
3946320 2005788 2005788 defendant Williams John (legal representative) 590698 590698 Williams, John, of Thame, knight, executors of 0
4129194 2070742 2070742 defendant Myncharde William tanner 590698 590698 Myncharde, William, of Thame, tanner 0
4129195 2070742 2070742 defendant Myncharde Simon chandler 590698 590698 Myncharde, Simon, of Thame, chandler 1
4211658 2099629 2099629 defendant Vicars John yeoman 590698 590698 Vicars, John, of Thame, yeoman 0
4301767 2130742 2130742 defendant Bowrye John yeoman 590698 590698 Bowrye, John, of Thame, yeoman 0
4336326 2142442 2142442 defendant Hellyar Thomas glover 590698 590698 Hellyar, Thomas, of Thame, glover 0
4357868 2149993 2149993 defendant Cowles Thomas baker 590698 590698 Cowles, Thomas, of Thame, baker 0
4422455 2171880 2171880 plaintiff Elys John   590698 590698 Elys, John, of Thame 0
4434712 2175620 2175620 plaintiff Lorymer Henry clerk 590698 590698 Lorymer, Henry, of Thame, clerk 0
4434936 2175688 2175688 plaintiff Martyn Robert   590698 590698 Martyn, Robert, of Thame 0
4434938 2175688 2175688 defendant Aylesbury Robert de   590698 590698 Aylesbury, Robert de, of Thame 0
4436932 2176291 2176291 plaintiff (not given) Philip prior of Thame 590698 590698 Thame, Philip, of Thame, prior of the hospital of St John of Jerusalem, in England 0
4451738 2185517 2185517 plaintiff Horneby Richard de   590698 590698 Horneby, Richard de, of Thame 0
4451853 2185558 2185558 defendant Aylesbury Robert de   590698 590698 Aylesbury, Robert de, of Thame 0
4454552 2186440 2186440 plaintiff Crok William   590698 590698 Crok, William, of Thame 1
4468006 2190665 2190665 defendant Sherman John   590698 590698 Sherman, John, of Thame 3
4468367 2190772 2190772 plaintiff Bate William   590698 590698 Bate, William, of Thame, on his own account 0
4476798 2193406 2193406 defendant Sherman John   590698 590698 Sherman, John, of Thame 1
4484018 2195692 2195692 defendant del More Richard   590698 590698 del More, Richard, of Thame 0
4484544 2195859 2195859 defendant Hayward John   590698 590698 Hayward, John, of Thame 0
4492815 2198458 2198458 defendant Harewell William   590698 590698 Harewell, William, of Thame 0
4492817 2198459 2198459 defendant Hornere John   590698 590698 Hornere, John, of Thame 0
4510735 2203814 2203814 plaintiff Bate William   590698 590698 Bate, William, of Thame 0
4535081 2211251 2211251 plaintiff Sherman John   590698 590698 Sherman, John, of Thame 0
4535083 2211252 2211252 plaintiff Sherman John   590698 590698 Sherman, John, of Thame 0
4536774 2211772 2211772 defendant Bocher Hugh   590698 590698 Bocher, Hugh, of Thame 1
4537695 2212064 2212064 plaintiff Tanner John   590698 590698 Tanner, John, of Thame 0
4549441 2215771 2215771 defendant Harwell William   590698 590698 Harwell, William, of Thame 1
4549444 2215772 2215772 defendant Harwell William   590698 590698 Harwell, William, of Thame 1
4552335 2216683 2216683 defendant Jaket John   590698 590698 Jaket, John, of Thame 0
4552336 2216683 2216683 defendant Palmer Adam   590698 590698 Palmer, Adam, of Thame 1
4552341 2216684 2216684 defendant Stoke John   590698 590698 Stoke, John, of Thame 0
4552342 2216684 2216684 defendant Bate William   590698 590698 Bate, William, of Thame 1
4552343 2216684 2216684 defendant Palmer Adam   590698 590698 Palmer, Adam, of Thame 2
4552492 2216736 2216736 defendant Glover John   590698 590698 Glover, John, of Thame 2
4553549 2217040 2217040 defendant Hert William   590698 590698 Hert, William, of Thame 0
4567483 2221390 2221390 defendant Scrop Agnes   590698 590698 Scrop, Agnes, of Thame 2
4567888 2221530 2221530 plaintiff Touresheye Nicholas   590698 590698 Touresheye, Nicholas, of Thame 0
4567889 2221530 2221530 defendant Bonde John   590698 590698 Bonde, John, of Thame 0
4571502 2222666 2222666 defendant Hert William   590698 590698 Hert, William, of Thame 1
4577932 2224602 2224602 defendant Bate William   590698 590698 Bate, William, of Thame 0
4583832 2226359 2226359 defendant Stokes John   590698 590698 Stokes, John, of Thame 0
4603586 2232308 2232308 defendant Bate William   590698 590698 Bate, William, of Thame 0
4618770 2236872 2236872 defendant Grene John   590698 590698 Grene, John, of Thame 3
4618778 2236874 2236874 defendant Nasshe Richard   590698 590698 Nasshe, Richard, of Thame 1
4618783 2236874 2236874 defendant Grene John   590698 590698 Grene, John, of Thame 6
4644548 2244497 2244497 defendant Cook John   590698 590698 Cook, John, of Thame 0
4645561 2244770 2244770 defendant Bonde John   590698 590698 Bonde, John, of Thame 0
4645562 2244770 2244770 defendant Bron John   590698 590698 Bron, John, of Thame 1
4646572 2245061 2245061 defendant Jaket John   590698 590698 Jaket, John, of Thame 1
4651945 2246545 2246545 defendant Palmere William hosteler 590698 590698 Palmere, William, of Thame, hosteler 2
4657004 2248081 2248081 defendant Jaket John husbandman 590698 590698 Jaket, John, of Thame, husbandman 1
4657005 2248081 2248081 defendant Sperce John husbandman 590698 590698 Sperce, John, of Thame, husbandman 2
4657006 2248081 2248081 defendant Bron John husbandman 590698 590698 Bron, John, of Thame, husbandman 3
4666136 2250876 2250876 defendant Acton Thomas tanner 590698 590698 Acton, Thomas, of Thame, tanner 0
4666137 2250876 2250876 defendant Paternoster John husbandman 590698 590698 Paternoster, John, of Thame, husbandman 1
4672085 2256917 2256917 defendant Elys John tanner 590698 590698 Elys, John, of Thame, tanner 2
4672086 2256917 2256917 defendant Jaket John husbandman 590698 590698 Jaket, John, of Thame, husbandman 3
4672091 2256918 2256918 defendant Elys John tanner 590698 590698 Elys, John, of Thame, , tanner 2
4672092 2256918 2256918 defendant Jaket John husbandman 590698 590698 Jaket, John, of Thame, husbandman 3
4680576 2259535 2259535 defendant atte Nasshe William husbandman 590698 590698 atte Nasshe, William, of Thame, husbandman 0
4680578 2259535 2259535 defendant Cook John husbandman 590698 590698 Cook, John, of Thame, husbandman 2
4688452 2261956 2261956 defendant Middelwode John husbandman 590698 590698 Middelwode, John, of Thame, husbandman 0
4688454 2261957 2261957 defendant Middelwode John   590698 590698 Middelwode, John, of Thame, franklin 0
4691993 2263030 2263030 defendant Atkyn Richard   590698 590698 Atkyn, Richard, of Thame, spice man 2
4696887 2264508 2264508 defendant Bolour John, sen husbandman 590698 590698 Bolour, John, sen, of Thame, husbandman 1
4696888 2264508 2264508 defendant Haket John husbandman 590698 590698 Haket, John, of Thame, husbandman 2
4696889 2264508 2264508 defendant Bonde John husbandman 590698 590698 Bonde, John, of Thame, husbandman 3
4696890 2264508 2264508 defendant Harewell William husbandman 590698 590698 Harewell, William, of Thame, husbandman 4

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