names

88 rows where place_id = 586235

✎ 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
3588228 1863972 1863972 defendant Cherson Richard butcher 586235 586235 Cherson, Richard, of Ealdyng, butcher 1
3588231 1863973 1863973 defendant Cherson Richard butcher 586235 586235 Cherson, Richard, of Ealdyng, butcher 1
3588852 1864163 1864163 defendant Colt William butcher 586235 586235 Colt, William, of Ealdyng, butcher 0
3589486 1864347 1864347 defendant Jope John husbandman 586235 586235 Jope, John, of Ealdyng, husbandman 0
3590564 1864689 1864689 defendant Sherstede Thomas butcher 586235 586235 Sherstede, Thomas, of Ealdyng, butcher 1
3592086 1865140 1865140 defendant Jope John husbandman 586235 586235 Jope, John, of Ealdyng, husbandman 0
3592950 1865417 1865417 defendant Salmon William laborer 586235 586235 Salmon, William, of Ealdyng, laborer 0
3595743 1866299 1866299 defendant Asshedoun James laborer 586235 586235 Asshedoun, James, of Ealdyng, laborer 0
3597950 1866982 1866982 defendant Wolsy John yeoman 586235 586235 Wolsy, John, of Ealdyng, yeoman 3
3599551 1867497 1867497 defendant Colt William butcher 586235 586235 Colt, William, of Ealdyng, butcher 0
3639791 1907256 1907256 defendant Webbe John yeoman 586235 586235 Webbe, John, of Ealdyng, yeoman 0
3639792 1907256 1907256 defendant Colt William alias John (legal representative) 586235 586235 Colt, William alias John, of Ealdyng, yeoman, executor of 1
3639793 1907256 1907256 defendant Colt George yeoman 586235 586235 Colt, George, of Ealdyng, yeoman 2
3687802 1922349 1922349 defendant Bereworth William (legal representative) 586235 586235 Bereworth, William, of Ealdyng, yeoman, executors of 0
3713300 1930470 1930470 plaintiff A Down William   586235 586235 A Down, William, of Ealdyng 0
3745279 1940431 1940431 defendant Water John painter 586235 586235 Water, John, of Ealdyng, painter 2
3772196 1948990 1948990 defendant Edmede Lawrence husbandman 586235 586235 Edmede, Lawrence, of Ealdyng, husbandman 0
3772197 1948990 1948990 defendant Edmede Henry turner 586235 586235 Edmede, Henry, of Ealdyng, turner 1
4413423 2169077 2169077 defendant Beneyt John   586235 586235 Beneyt, John, of Ealdyng, son of Richard 0
4508179 2203035 2203035 plaintiff Younge John   586235 586235 Younge, John, of Ealdyng 0
4542312 2213486 2213486 plaintiff Yonge John   586235 586235 Yonge, John, of Ealdyng 0
4548896 2215588 2215588 defendant Goodwyne William   586235 586235 Goodwyne, William, of Ealdyng 0
4548898 2215589 2215589 defendant Goodwyne William   586235 586235 Goodwyne, William, of Ealdyng 0
4553028 2216888 2216888 plaintiff Fromond Nicholas (legal representative) 586235 586235 Fromond, Nicholas, of Ealdyng, executors of 0
4553030 2216888 2216888 plaintiff Blaksnode John   586235 586235 Blaksnode, John, of Ealdyng 2
4563917 2220286 2220286 plaintiff Ruggemere Richard   586235 586235 Ruggemere, Richard, of Ealdyng 0
4563918 2220286 2220286 defendant Smyth Thomas   586235 586235 Smyth, Thomas, of Ealdyng 0
4576213 2224062 2224062 plaintiff Broke John   586235 586235 Broke, John, of Ealdyng 0
4585410 2226859 2226859 defendant Sandherst Thomas   586235 586235 Sandherst, Thomas, of Ealdyng 0
4610409 2234332 2234332 defendant Smyth John   586235 586235 Smyth, John, of Ealdyng 0
4629195 2240062 2240062 plaintiff Smyth John   586235 586235 Smyth, John, of Ealdyng 0
4636071 2242111 2242111 defendant Broke John   586235 586235 Broke, John, of Ealdyng 0
4649518 2245898 2245898 defendant Honge John   586235 586235 Honge, John, of Ealdyng 1
4667514 2255560 2255560 defendant Broke John carpenter 586235 586235 Broke, John, of Ealdyng, carpenter 0
4667516 2255560 2255560 defendant Genecok John husbandman 586235 586235 Genecok, John, of Ealdyng, husbandman 2
4686647 2261435 2261435 plaintiff Snell William   586235 586235 Snell, William, of Ealdyng 0
4718093 2271000 2271000 defendant Cumbe John yeoman 586235 586235 Cumbe, John, of Ealdyng, yeoman 0
4719145 2271337 2271337 plaintiff Benyt Thomas   586235 586235 Benyt, Thomas, of Ealdyng 0
4721791 2272148 2272148 defendant Sandherst Thomas husbandman 586235 586235 Sandherst, Thomas, of Ealdyng, husbandman 0
4722449 2272340 2272340 defendant Boutan Richard turner 586235 586235 Boutan, Richard, of Ealdyng, turner 1
4727895 2273967 2273967 plaintiff Jolyf Robert   586235 586235 Jolyf, Robert, of Ealdyng 2
4727896 2273967 2273967 defendant Ruggemere William husbandman 586235 586235 Ruggemere, William, of Ealdyng, husbandman 0
4727898 2273968 2273968 defendant Boutan Richard husbandman 586235 586235 Boutan, Richard, of Ealdyng, husbandman 0
4736847 2276653 2276653 defendant Sandherst Thomas husbandman 586235 586235 Sandherst, Thomas, of Ealdyng, husbandman 0
4741747 2278080 2278080 defendant Suchefeld John husbandman 586235 586235 Suchefeld, John, of Ealdyng, husbandman 0
4743723 2278694 2278694 defendant Swychefeld John   586235 586235 Swychefeld, John, of Ealdyng, bailiff 1
4744584 2278938 2278938 defendant Broke John carpneter 586235 586235 Broke, John, of Ealdyng, carpneter 0
4744586 2278938 2278938 defendant Dane Nicholas husbandman 586235 586235 Dane, Nicholas, of Ealdyng, husbandman 2
4747148 2279671 2279671 defendant Wotton Robert husbandman 586235 586235 Wotton, Robert, of Ealdyng, husbandman 0
4750594 2280659 2280659 defendant Ruggemere John   586235 586235 Ruggemere, John, of Ealdyng, bow maker 2
4808584 2298851 2298851 plaintiff Curch Thomas   586235 586235 Curch, Thomas, of Ealdyng, on his own account 0
4808585 2298851 2298851 defendant Tannere John tanner 586235 586235 Tannere, John, of Ealdyng, tanner 0
4814777 2300736 2300736 defendant Goldesmyth Simon husbandman 586235 586235 Goldesmyth, Simon, of Ealdyng, husbandman 0
4912427 2330391 2330391 defendant Goldsmyth Simon husbandman 586235 586235 Goldsmyth, Simon, of Ealdyng, husbandman 0
5124582 2393655 2393655 defendant Kene Richard smith 586235 586235 Kene, Richard, of Ealdyng, smith 0
5125172 2393840 2393840 defendant Kene Robert smith 586235 586235 Kene, Robert, of Ealdyng, smith 0
5131643 2395736 2395736 defendant Pyx Richard yeoman 586235 586235 Pyx, Richard, of Ealdyng, yeoman 1
5131644 2395736 2395736 defendant Walker William husbandman 586235 586235 Walker, William, of Ealdyng, husbandman 2
5136044 2397053 2397053 defendant Bery Simon husbandman 586235 586235 Bery, Simon, of Ealdyng, husbandman 0
5136575 2397215 2397215 plaintiff Orgar Thomas   586235 586235 Orgar, Thomas, of Ealdyng 0
5136935 2397320 2397320 plaintiff Pax Richard   586235 586235 Pax, Richard, of Ealdyng 0
5151124 2401470 2401470 defendant Pyx Richard husbandman 586235 586235 Pyx, Richard, of Ealdyng, yeoman, Walker, William, of Ealdyng or Yalding, husbandman 1
5151140 2401474 2401474 defendant Colt John butcher 586235 586235 Colt, John, of Ealdyng, butcher 1
5177977 2409265 2409265 defendant Chersounde John husbandman 586235 586235 Chersounde, John, of Ealdyng, husbandman 0
5178580 2409449 2409449 defendant Pyx Richard husbandman 586235 586235 Pyx, Richard, of Ealdyng, husbandman 1
5193014 2413684 2413684 defendant Kene Robert smith 586235 586235 Kene, Robert, of Ealdyng, smith 0
5193016 2413684 2413684 defendant Benet Thomas weaver 586235 586235 Benet, Thomas, of Ealdyng, weaver 2
5216155 2420454 2420454 defendant Mey Richard husbandman 586235 586235 Mey, Richard, of Ealdyng, husbandman 0
5219607 2421469 2421469 defendant Colt John yeoman 586235 586235 Colt, John, of Ealdyng, yeoman 1
5219608 2421469 2421469 defendant Ryng Robert yeoman 586235 586235 Ryng, Robert, of Ealdyng, yeoman 2
5219609 2421469 2421469 defendant Curche Stephen yeoman 586235 586235 Curche, Stephen, of Ealdyng, yeoman 3
5220558 2421710 2421710 defendant Sevyn or Sevyng William yeoman 586235 586235 Sevyn or Sevyng, William, of Ealdyng, yeoman 1
5225304 2423072 2423072 plaintiff Ryng Robert yeoman 586235 586235 Ryng, Robert, of Ealdyng, yeoman 0
5226406 2423388 2423388 defendant Bery Richard pulter 586235 586235 (Bery, Richard, of Ealdyng, pulter 1
5226416 2423389 2423389 defendant Warbilton William yeoman 586235 586235 Warbilton, William, of Ealdyng, yeoman 3
5268155 2435810 2435810 defendant Cherleswonde John husbandman 586235 586235 Cherleswonde, John, of Ealdyng, husbandman 0
5272528 2437039 2437039 defendant Cherleswound John husbandman 586235 586235 Cherleswound, John, of Ealdyng, husbandman 1
5298799 2444626 2444626 defendant Ippyngbery Thomas husbandman 586235 586235 Ippyngbery, Thomas, of Ealdyng, husbandman 1
5298800 2444626 2444626 defendant Studfold Roger husbandman 586235 586235 Studfold, Roger, of Ealdyng, husbandman 2
5305380 2446619 2446619 defendant Goldesmith Thomas yeoman 586235 586235 Goldesmith, Thomas, of Ealdyng, yeoman 1
5369788 2466141 2466141 defendant Hale Thomas husbandman 586235 586235 Hale, Thomas, of Ealdyng, husbandman 0
5414395 2479244 2479244 defendant Jope John yeoman 586235 586235 Jope, John, of Ealdyng, yeoman 0
5426308 2482822 2482822 defendant Wolcy John husbandman 586235 586235 Wolcy, John, of Ealdyng, husbandman 2
5430204 2483972 2483972 defendant Jope John yeoman 586235 586235 Jope, John, of Ealdyng, yeoman 0
5454288 2491193 2491193 defendant Gybbys Martin husbandman 586235 586235 Gybbys, Martin, of Ealdyng, husbandman 1
5461174 2493290 2493290 defendant Dowener John butcher 586235 586235 Dowener, John, of Ealdyng, butcher 1
5564123 2524122 2524122 defendant Colt George husbandman 586235 586235 Colt, George, of Ealdyng, husbandman 5
5574364 2527067 2527067 defendant Colt Robert miller 586235 586235 Colt, Robert, of Ealdyng, miller 0

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