names

165 rows where place_id = 594912

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3613032 1871728 1871728 plaintiff Archer William (legal representative) 594912 594912 Archer, William, of Aldenham, maltman, administratrix of 0
3618092 1873281 1873281 defendant Draper Richard husbandman 594912 594912 Draper, Richard, of Aldenham, husbandman 1
3629987 1904230 1904230 defendant Lane Roger husbandman 594912 594912 Lane, Roger, of Aldenham, husbandman 1
3629989 1904231 1904231 defendant Symonde Richard laborer 594912 594912 Symonde, Richard, of Aldenham, laborer 0
3629990 1904231 1904231 defendant Lane Roger husbandman 594912 594912 Lane, Roger, of Aldenham, husbandman 1
3639033 1907029 1907029 defendant Fuyster George butcher 594912 594912 Fuyster, George, of Aldenham, butcher 2
3666557 1915479 1915479 plaintiff Udale John yeoman 594912 594912 Udale, John, of Aldenham, yeoman 0
3681768 1920396 1920396 defendant Chamberleyn William yeroman 594912 594912 Chamberleyn, William, of Aldenham, yeroman 3
3760513 1945293 1945293 defendant Warner William maltman 594912 594912 Warner, William, of Aldenham, maltman 3
3761845 1945714 1945714 defendant Warner William maltman 594912 594912 Warner, William, of Aldenham, maltman 0
3766854 1947297 1947297 defendant Wrenche Robert yeoman 594912 594912 Wrenche, Robert, of Aldenham, yeoman 1
3772104 1948967 1948967 plaintiff Turnour John   594912 594912 Turnour, John, of Aldenham 0
3772818 1949191 1949191 defendant Gryffyth Richard husbandman 594912 594912 Gryffyth, Richard, of Aldenham, husbandman 0
3772819 1949191 1949191 defendant Plate Robert husbandman 594912 594912 Plate, Robert, of Aldenham, husbandman 1
3772820 1949191 1949191 defendant Thurowghgood John husbandman 594912 594912 Thurowghgood, John, of Aldenham, husbandman 2
3803058 1958858 1958858 defendant Turnour John yeoman 594912 594912 Turnour, John, of Aldenham, yeoman 0
3806623 1959972 1959972 defendant Catlyn William, junior yeoman 594912 594912 Catlyn, William, junior, of Aldenham, yeoman 0
3806624 1959972 1959972 defendant Kytter John laborer 594912 594912 Kytter, John, of Aldenham, laborer 1
3806625 1959972 1959972 defendant Man alias Doughty John laborer 594912 594912 Man alias Doughty, John, of Aldenham, laborer 2
3809806 1960955 1960955 defendant Archer Thomas maltman 594912 594912 Archer, Thomas, of Aldenham, maltman 1
3819261 1963914 1963914 defendant Auncell William maltman 594912 594912 Auncell, William, of Aldenham, maltman 0
3846040 1972322 1972322 defendant Wrenche Robert maltman 594912 594912 Wrenche, Robert, of Aldenham, maltman 0
3858996 1976503 1976503 plaintiff Burraston Thomas yeoman 594912 594912 Burraston, Thomas, of Aldenham, yeoman 0
3885206 1985303 1985303 defendant Kytter John maltman 594912 594912 Kytter, John, of Aldenham, maltman 2
3885207 1985303 1985303 defendant Jurden William maltman 594912 594912 Jurden, William, of Aldenham, maltman 3
3885218 1985307 1985307 defendant Kytter John maltman 594912 594912 Kytter, John, of Aldenham, maltman 2
3885219 1985307 1985307 defendant Jurden William maltman 594912 594912 Jurden, William, of Aldenham, maltman 3
3906799 1992565 1992565 defendant Goodyere Richard gent 594912 594912 Goodyere, Richard, of Aldenham, gent 0
3910743 1993912 1993912 defendant Rogers Robert maltman 594912 594912 Rogers, Robert, of Aldenham, maltman 0
3910744 1993912 1993912 defendant Jurden George maltman 594912 594912 Jurden, George, of Aldenham, maltman 1
3910745 1993912 1993912 defendant Rogers William maltman 594912 594912 Rogers, William, of Aldenham, maltman 2
3916789 1995981 1995981 defendant Platt Henry maltman 594912 594912 Platt, Henry, of Aldenham, maltman 0
3928156 1999752 1999752 defendant Sheperde John husbandman 594912 594912 Sheperde, John, of Aldenham, husbandman 0
3953054 2008132 2008132 defendant Platt Nicholas yeoman 594912 594912 Platt, Nicholas, of Aldenham, yeoman 0
3959285 2010325 2010325 defendant Redwood John yeoman 594912 594912 Redwood, John, of Aldenham, yeoman 0
3959287 2010326 2010326 defendant Redwood John yeoman 594912 594912 Redwood, John, of Aldenham, yeoman 0
3981006 2017965 2017965 defendant Rogers Richard husbandman 594912 594912 Rogers, Richard, of Aldenham, husbandman 1
4071649 2050155 2050155 defendant Acton William (legal representative) 594912 594912 Acton, William, of Aldenham, esq, executor of 0
4095127 2058587 2058587 defendant Wythe Richard yeoman 594912 594912 Wythe, Richard, of Aldenham, yeoman 0
4159373 2081347 2081347 defendant Jenk Henry gent 594912 594912 Jenk, Henry, of Aldenham, gent 2
4215190 2100807 2100807 defendant Heydon Thomas yeoman 594912 594912 Heydon, Thomas, of Aldenham, yeoman 0
4215192 2100808 2100808 defendant Huddell Edward yeoman 594912 594912 Huddell, Edward, of Aldenham, yeoman 0
4219933 2102473 2102473 defendant Burnell John, junior yeoman 594912 594912 Burnell, John, junior, of Aldenham, yeoman 0
4237375 2108662 2108662 defendant Burnell John, junior yeoman 594912 594912 Burnell, John, junior, of Aldenham, yeoman 0
4239055 2109281 2109281 defendant Harwood John yeoman 594912 594912 Harwood, John, of Aldenham, yeoman 1
4280014 2122922 2122922 defendant Acton Robert   594912 594912 Acton, Robert, of Aldenham esq 0
4293499 2127737 2127737 defendant Kinge John yeoman 594912 594912 Kinge, John, of Aldenham, yeoman 1
4293752 2127833 2127833 defendant Platt William   594912 594912 Platt, William, of Aldenham, yeoman, his son 1
4382571 2158878 2158878 defendant Aylwyn John yeoman 594912 594912 Aylwyn, John, of Aldenham, yeoman 1
4383842 2159300 2159300 defendant Oxton alias Foxe Thomas yeoman 594912 594912 Oxton alias Foxe, Thomas, of Aldenham, yeoman 0
4392734 2162188 2162188 defendant Winkefeyld Morgan yeoman 594912 594912 Winkefeyld, Morgan, of Aldenham, yeoman 1
4392735 2162188 2162188 defendant Winkefeyld John yeoman 594912 594912 Winkefeyld, John, of Aldenham, yeoman 2
4392736 2162188 2162188 defendant Lorchyn Thomas yeoman 594912 594912 Lorchyn, Thomas, of Aldenham, yeoman 3
4394634 2162793 2162793 defendant Clarke John yeoman 594912 594912 Clarke, John, of Aldenham, yeoman 2
4410831 2168212 2168212 defendant Sheperd John yeoman 594912 594912 Sheperd, John, of Aldenham, yeoman 0
4418038 2170521 2170521 defendant Porter John   594912 594912 Porter, John, of Aldenham 0
4494123 2198853 2198853 plaintiff (not given) John vicar of Billyng 594912 594912 Billyng, John, of Aldenham, vicar of the church of Tiryngton, on his own account 0
4557030 2218124 2218124 defendant Scheperd John   594912 594912 Scheperd, John, of Aldenham 1
4576340 2224108 2224108 plaintiff Brook John   594912 594912 Brook, John, of Aldenham 0
4602325 2231943 2231943 defendant atte Broke Edmund   594912 594912 atte Broke, Edmund, of Aldenham 0
4711567 2268942 2268942 defendant Broun Richard husbandman 594912 594912 Broun, Richard, of Aldenham, husbandman 4
4762721 2284320 2284320 plaintiff Fulller William   594912 594912 Fulller, William, of Aldenham 0
4762722 2284320 2284320 defendant Cressehale William husbandman 594912 594912 Cressehale, William, of Aldenham, husbandman 0
4783307 2290800 2290800 defendant Dey John husbandman 594912 594912 Dey, John, of Aldenham, husbandman 2
4790776 2293201 2293201 defendant Porter Thomas husbandman 594912 594912 Porter, Thomas, of Aldenham, husbandman 0
4804644 2297647 2297647 defendant Stibbyng John husbandman 594912 594912 Stibbyng, John, of Aldenham, husbandman 0
4804645 2297647 2297647 defendant atte More Hugh maltman 594912 594912 atte More, Hugh, of Aldenham, maltman 1
4813266 2300263 2300263 defendant Bereford John husbandman 594912 594912 Bereford, John, of Aldenham, husbandman 2
4825721 2304087 2304087 defendant Nele Joan widow & formerly wife of John Nele 594912 594912 Nele, Joan, of Aldenham, widow & formerly wife of John Nele 1
4829065 2305130 2305130 defendant Dose John clerk 594912 594912 Dose, John, of Aldenham, clerk 0
4829069 2305132 2305132 defendant Dose John clerk 594912 594912 Dose, John, of Aldenham, clerk 0
4829071 2305133 2305133 defendant Dose John clerk 594912 594912 Dose, John, of Aldenham, clerk 0
4836891 2307496 2307496 defendant Dose John clerk 594912 594912 Dose, John, of Aldenham, clerk 0
4836893 2307497 2307497 defendant Dose John clerk 594912 594912 Dose, John, of Aldenham, clerk 0
4840081 2308447 2308447 defendant Bitwey Thomas butcher 594912 594912 Bitwey, Thomas, of Aldenham, butcher 2
4847898 2310824 2310824 defendant Sandrych Robert   594912 594912 Sandrych, Robert, of Aldenham 12
4847899 2310824 2310824 defendant Brewer Thomas   594912 594912 Brewer, Thomas, of Aldenham 13
4855685 2313149 2313149 defendant Rolf Walter husbandman 594912 594912 Rolf, Walter, of Aldenham, husbandman 0
4855826 2313193 2313193 defendant Dose John clerk 594912 594912 Dose, John, of Aldenham, clerk 0
4875844 2319408 2319408 defendant Dose John clerk 594912 594912 Dose, John, of Aldenham, clerk 0
4875846 2319409 2319409 defendant Dose John clerk 594912 594912 Dose, John, of Aldenham, clerk 0
4885246 2322273 2322273 defendant Stybbyng John, junior maltman 594912 594912 Stybbyng, John, junior, of Aldenham, maltman 0
4893432 2324646 2324646 defendant Colyer Adam wheeler 594912 594912 Colyer, Adam, of Aldenham, wheeler 4
4897985 2326038 2326038 defendant Bugge John maltman 594912 594912 Bugge, John, of Aldenham, maltman 0
4897987 2326039 2326039 defendant Stybbyng Richard maltman 594912 594912 Stybbyng, Richard, of Aldenham, maltman 0
4914032 2330898 2330898 defendant Plotte John, junior husbandman 594912 594912 Plotte, John, junior, of Aldenham, husbandman 0
4919407 2332580 2332580 defendant Aylesworth John loader 594912 594912 Aylesworth, John, of Aldenham, loader 0
4955056 2343464 2343464 plaintiff Stybbyng Richard, junior   594912 594912 Stybbyng, Richard, junior, of Aldenham 0
4955059 2343465 2343465 plaintiff Stybbyng Richard, junior   594912 594912 Stybbyng, Richard, junior, of Aldenham 0
5093520 2384503 2384503 defendant Tomkyn John husbandman 594912 594912 Tomkyn, John, of Aldenham, husbandman 3
5093521 2384503 2384503 defendant Halle John husbandman 594912 594912 Halle, John, of Aldenham, husbandman 4
5101585 2386883 2386883 defendant Halle John husbandman 594912 594912 Halle, John, of Aldenham, husbandman 0
5101586 2386883 2386883 defendant Halle Simon tilemaker 594912 594912 Halle, Simon, of Aldenham, tilemaker 1
5102599 2387167 2387167 defendant Sabbe John smith 594912 594912 Sabbe, John, of Aldenham, smith 2
5131044 2395566 2395566 defendant Gygge John   594912 594912 Gygge, John, of Aldenham, shoe maker 0
5175503 2408518 2408518 defendant Turnour John husbandman 594912 594912 Turnour, John, of Aldenham, husbandman 21
5175506 2408518 2408518 defendant Neel Thomas laborer 594912 594912 Neel, Thomas, of Aldenham, laborer 24
5194409 2414094 2414094 defendant Halle John husbandman 594912 594912 Halle, John, of Aldenham, husbandman 0
5194410 2414094 2414094 defendant Hayne John husbandman 594912 594912 Hayne, John, of Aldenham, husbandman 1
5194411 2414094 2414094 defendant Halle Richard husbandman 594912 594912 Halle, Richard, of Aldenham, husbandman 2

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