names

303 rows where place_id = 589426

✎ 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
3597618 1866880 1866880 defendant Miller Humphrey yeoman 589426 589426 Miller, Humphrey, of Abyndon, yeoman 1
3597620 1866880 1866880 defendant Lokear Robert yeoman 589426 589426 Lokear, Robert, of Abyndon, yeoman 3
3597621 1866880 1866880 defendant Dekyn or Degyn John weaver 589426 589426 Dekyn or Degyn, John, of Abyndon, weaver 4
3606863 1869813 1869813 plaintiff Penston John (legal representative) 589426 589426 Penston, John, of Abyndon, mercer, executors of 0
3606868 1869813 1869813 defendant Bocher Robert butcher 589426 589426 Bocher, Robert, of Abyndon, butcher 3
3607647 1870048 1870048 plaintiff Say Thomas gent 589426 589426 Say, Thomas, of Abyndon, gent 0
3607655 1870049 1870049 plaintiff Say Thomas gent 589426 589426 Say, Thomas, of Abyndon, gent 0
3608870 1870430 1870430 defendant Smyth John clerk 589426 589426 Smyth, John, of Abyndon, clerk 0
3621504 1874267 1874267 defendant Shomaker Lewis shoemaker 589426 589426 Shomaker, Lewis, of Abyndon, shoemaker 1
3625566 1875532 1875532 defendant Belyngham David gent 589426 589426 Belyngham, David, of Abyndon, gent 0
3625567 1875532 1875532 defendant Crowesha John yeoman 589426 589426 Crowesha, John, of Abyndon, yeoman 1
3625568 1875532 1875532 defendant Carter John yeoman 589426 589426 Carter, John, of Abyndon, yeoman 2
3625569 1875532 1875532 defendant Hayse John yeoman 589426 589426 Hayse, John, of Abyndon, yeoman 3
3625570 1875532 1875532 defendant Byseley William gent 589426 589426 Byseley, William, of Abyndon, gent 4
3625571 1875532 1875532 defendant Wytnam Richard   589426 589426 Wytnam, Richard, of Abyndon, parchment maker 5
3625573 1875533 1875533 defendant Byseley William gent 589426 589426 Byseley, William, of Abyndon, gent 0
3625575 1875533 1875533 defendant Crowesha John yeoman 589426 589426 Crowesha, John, of Abyndon, yeoman 2
3625576 1875533 1875533 defendant Carter John yeoman 589426 589426 Carter, John, of Abyndon, yeoman 3
3625577 1875533 1875533 defendant Hayse John yeoman 589426 589426 Hayse, John, of Abyndon, yeoman 4
3625578 1875533 1875533 defendant Wytnam Richard   589426 589426 Wytnam, Richard, of Abyndon, parchment maker 5
3625589 1875537 1875537 defendant Belyngham David gent 589426 589426 Belyngham, David, of Abyndon, gent 0
3625590 1875537 1875537 defendant Crowesha John yeoman 589426 589426 Crowesha, John, of Abyndon, yeoman 1
3625591 1875537 1875537 defendant Carter John yeoman 589426 589426 Carter, John, of Abyndon, yeoman 2
3625592 1875537 1875537 defendant Hayse John yeoman 589426 589426 Hayse, John, of Abyndon, yeoman 3
3625593 1875537 1875537 defendant Byseley William gent 589426 589426 Byseley, William, of Abyndon, gent 4
3625594 1875537 1875537 defendant Witnam Richard   589426 589426 Witnam, Richard, of Abyndon, parchment maker 5
3638119 1906739 1906739 defendant Gybbys Robert laborer 589426 589426 Gybbys, Robert, of Abyndon, laborer 0
3639400 1907133 1907133 plaintiff Wellysbourn Humphrey (legal representative) 589426 589426 Wellysbourn, Humphrey, of Abyndon, administrator of 0
3639401 1907133 1907133 plaintiff Wellesbourn Oliver   589426 589426 Wellesbourn, Oliver, of Abyndon 1
3639402 1907133 1907133 defendant Belyngeham David gent 589426 589426 Belyngeham, David, of Abyndon, gent 0
3689773 1922958 1922958 plaintiff Flynt John draper 589426 589426 Flynt, John, of Abyndon, draper 0
3693811 1924262 1924262 defendant Coper Richard glover 589426 589426 Coper, Richard, of Abyndon, glover 0
3695692 1924885 1924885 defendant Busshe Richard skinner 589426 589426 Busshe, Richard, of Abyndon, skinner 0
3695723 1924892 1924892 defendant Sellary John fuller 589426 589426 Sellary, John, of Abyndon, fuller 1
3695724 1924892 1924892 defendant Haryson William tailor 589426 589426 Haryson, William, of Abyndon, tailor 2
3695727 1924893 1924893 defendant Sellary John fuller 589426 589426 Sellary, John, of Abyndon, fuller 1
3695728 1924893 1924893 defendant Haryson William tailor 589426 589426 Haryson, William, of Abyndon, tailor 2
3700253 1926314 1926314 plaintiff Audelet John   589426 589426 Audelet, John, of Abyndon 0
3707350 1928589 1928589 defendant Watson Edward butcher or vintner 589426 589426 Watson, Edward, of Abyndon, butcher or vintner 0
3707354 1928590 1928590 defendant Watson Edward vintner 589426 589426 Watson, Edward, of Abyndon, vintner 1
3723753 1933705 1933705 plaintiff Phelippys David fishmonger 589426 589426 Phelippys, David, of Abyndon, fishmonger 0
3756569 1944035 1944035 plaintiff Audelett John esq 589426 589426 Audelett, John, of Abyndon, esq 0
3760949 1945431 1945431 defendant Pynfold William butcher 589426 589426 Pynfold, William, of Abyndon, butcher 0
3760951 1945431 1945431 defendant Payne John glover 589426 589426 Payne, John, of Abyndon, glover 2
3770147 1948329 1948329 defendant Ixon or Jaxon Thomas fisher 589426 589426 Ixon or Jaxon, Thomas, of Abyndon, fisher 0
3774451 1949735 1949735 defendant Bradburne John butcher 589426 589426 Bradburne, John, of Abyndon, butcher 0
3776746 1950472 1950472 defendant Comber Edward tailor 589426 589426 Comber, Edward, of Abyndon, tailor 0
3779017 1951161 1951161 defendant Pynfold William butcher 589426 589426 Pynfold, William, of Abyndon, butcher 0
3779113 1951191 1951191 defendant Colombere Edward tailor 589426 589426 Colombere, Edward, of Abyndon, tailor 1
3779118 1951192 1951192 defendant Asshton Christopher draper 589426 589426 Asshton, Christopher, of Abyndon, draper 0
3779119 1951192 1951192 defendant Wodward Lionel innholder 589426 589426 Wodward, Lionel, of Abyndon, innholder 1
3791100 1955050 1955050 defendant Spenser Roger laborer 589426 589426 Spenser, Roger, of Abyndon, laborer 0
3808791 1960629 1960629 plaintiff Awdelet John esq 589426 589426 Awdelet, John, of Abyndon, esq 0
3826274 1966065 1966065 plaintiff Asshton Christopher draper 589426 589426 Asshton, Christopher, of Abyndon, draper 0
3855059 1975210 1975210 defendant Woodward Thomas gent 589426 589426 Woodward, Thomas, of Abyndon, gent 0
3999061 2024423 2024423 defendant Wek Gilbert tailor 589426 589426 Wek, Gilbert, of Abyndon, tailor 0
4413204 2169001 2169001 defendant Maynard John   589426 589426 Maynard, John, of Abyndon 0
4413945 2169261 2169261 defendant Henxeye John   589426 589426 Henxeye, John, of Abyndon 0
4418185 2170567 2170567 plaintiff Wadeby Roger   589426 589426 Wadeby, Roger, of Abyndon, son of Richard 0
4418715 2170720 2170720 defendant Hakebourn Richard de   589426 589426 Hakebourn, Richard de, of Abyndon 0
4423375 2172158 2172158 defendant Boltere John le merchant 589426 589426 Boltere, John le, of Abyndon, merchant 0
4430631 2174335 2174335 defendant Hakebourn Richard de   589426 589426 Hakebourn, Richard de, of Abyndon 0
4430702 2174361 2174361 defendant Peper Richard (legal representative) 589426 589426 Peper, Richard, of Abyndon, executors of 0
4434717 2175621 2175621 defendant Goseye John   589426 589426 Goseye, John, of Abyndon 0
4434719 2175622 2175622 defendant Goseye John   589426 589426 Goseye, John, of Abyndon 0
4434722 2175623 2175623 defendant Goseye John   589426 589426 Goseye, John, of Abyndon 1
4434725 2175624 2175624 defendant Soseye John   589426 589426 Soseye, John, of Abyndon 1
4436410 2176126 2176126 defendant Geseye John de   589426 589426 Geseye, John de, of Abyndon 1
4436414 2176127 2176127 defendant Goseye John   589426 589426 Goseye, John, of Abyndon 1
4437956 2181191 2181191 defendant Culham John   589426 589426 Culham, John, of Abyndon 1
4437964 2181192 2181192 defendant Culham John   589426 589426 Culham, John, of Abyndon 1
4443666 2182985 2182985 defendant Parchementre John   589426 589426 Parchementre, John, of Abyndon 0
4443668 2182986 2182986 defendant Parchementre John   589426 589426 Parchementre, John, of Abyndon 0
4446727 2183893 2183893 plaintiff Diere Thomas   589426 589426 Diere, Thomas, of Abyndon 0
4449531 2184801 2184801 plaintiff Golafre William   589426 589426 Golafre, William, of Abyndon 0
4449532 2184801 2184801 defendant Hikkes William carpenter 589426 589426 Hikkes, William, of Abyndon, carpenter 0
4450411 2185090 2185090 defendant Boltere William   589426 589426 Boltere, William, of Abyndon 0
4450413 2185091 2185091 defendant Bolter William   589426 589426 Bolter, William, of Abyndon 0
4453986 2186263 2186263 plaintiff Lokynton Simon   589426 589426 Lokynton, Simon, of Abyndon 0
4453987 2186263 2186263 defendant Comenore John smith 589426 589426 Comenore, John, of Abyndon, smith 0
4453988 2186263 2186263 defendant Luke John   589426 589426 Luke, John, of Abyndon 1
4458212 2187608 2187608 defendant Harwold John   589426 589426 Harwold, John, of Abyndon 1
4461171 2188574 2188574 plaintiff Spycer William   589426 589426 Spycer, William, of Abyndon 0
4461687 2188715 2188715 defendant Bullok Henry   589426 589426 Bullok, Henry, of Abyndon 0
4462189 2188871 2188871 defendant Trilly John glover 589426 589426 Trilly, John, of Abyndon, glover 0
4472981 2192224 2192224 plaintiff Couper William   589426 589426 Couper, William, of Abyndon 0
4474264 2192605 2192605 plaintiff Derby Simon   589426 589426 Derby, Simon, of Abyndon 0
4488354 2197076 2197076 plaintiff Stevenes William   589426 589426 Stevenes, William, of Abyndon 0
4494641 2199016 2199016 defendant Gryn John spicer 589426 589426 Gryn, John, of Abyndon, spicer 0
4496453 2199567 2199567 defendant (illegible) Thomas   589426 589426 ----, Thomas, of Abyndon 3
4496467 2199571 2199571 defendant Turmepas Richard   589426 589426 Turmepas, Richard, of Abyndon 0
4497149 2199766 2199766 defendant Sprot Thomas   589426 589426 Sprot, Thomas, of Abyndon 2
4497181 2199773 2199773 defendant Sprot Thomas   589426 589426 Sprot, Thomas, of Abyndon 1
4497185 2199774 2199774 defendant Sprot Thomas   589426 589426 Sprot, Thomas, of Abyndon 2
4497188 2199775 2199775 defendant Sprot Thomas   589426 589426 Sprot, Thomas, of Abyndon 1
4497194 2199777 2199777 defendant Thuepas John   589426 589426 Thuepas, John, of Abyndon 1
4497202 2199779 2199779 defendant Tornepas John   589426 589426 Tornepas, John, of Abyndon 1
4499096 2200361 2200361 plaintiff Grene John   589426 589426 Grene, John, of Abyndon, on his own account 0
4508326 2203092 2203092 defendant Bagge Peter   589426 589426 Bagge, Peter, of Abyndon, servant of John Bagge 0
4508327 2203092 2203092 defendant Warwyk John shoemaker 589426 589426 Warwyk, John, of Abyndon, shoemaker 1

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