names

88 rows where place_id = 612917

✎ 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
3695589 1924849 1924849 defendant Waltham Thomas husbandman 612917 612917 Waltham, Thomas, of Hethe, husbandman 1
3773532 1949433 1949433 defendant Wyatt Henry husbandman 612917 612917 Wyatt, Henry, of Hethe, husbandman 0
3781334 1951904 1951904 defendant Pavyer Stephen tailor 612917 612917 Pavyer, Stephen, of Hethe, tailor 4
3813484 1962132 1962132 plaintiff Edeson Thomas   612917 612917 Edeson, Thomas, of Hethe 0
3815215 1962676 1962676 plaintiff Gybson alias Tayllour John yeoman 612917 612917 Gybson alias Tayllour, John, of Hethe, yeoman 0
3815390 1962730 1962730 defendant Waltham Thomas fisher 612917 612917 Waltham, Thomas, of Hethe, fisher 1
4025364 2033732 2033732 defendant Dalmyngton William   612917 612917 Dalmyngton, William, of Hethe, yeoman, jurat 0
4025366 2033732 2033732 defendant Brydgeman John tailor 612917 612917 Brydgeman, John, of Hethe, tailor 2
4025367 2033732 2033732 defendant Tuwe or Tulke Nicholas yeoman 612917 612917 Tuwe or Tulke, Nicholas, of Hethe, yeoman 3
4025369 2033733 2033733 defendant Dalmyngton William yeoman 612917 612917 Dalmyngton, William, of Hethe, yeoman 0
4025370 2033733 2033733 defendant Hokar Thomas butcher 612917 612917 Hokar, Thomas, of Hethe, butcher 1
4025371 2033733 2033733 defendant Bridgeman John tailor 612917 612917 Bridgeman, John, of Hethe, tailor 2
4025372 2033733 2033733 defendant Tulle Nicholas   612917 612917 Tulle, Nicholas, of Hethe, yeoman, jurat 3
4325314 2138847 2138847 defendant Procter Andrew customer of Hethe 612917 612917 Procter, Andrew, of Hethe, gent, customer of Hethe 0
4336029 2142338 2142338 defendant Spycer Michael yeoman 612917 612917 Spycer, Michael, of Hethe, yeoman 0
4336030 2142338 2142338 defendant Spycer Thomas yeoman 612917 612917 Spycer, Thomas, of Hethe, yeoman 1
4457693 2187415 2187415 defendant Noweman John   612917 612917 Noweman, John, of Hethe 0
4476498 2193317 2193317 plaintiff Fyssher Walter (legal representative) 612917 612917 Fyssher, Walter, of Hethe, executors of 0
4486154 2196369 2196369 defendant Steer John   612917 612917 Steer, John, of Hethe 4
4498523 2200181 2200181 defendant Sherwynd Alexander   612917 612917 Sherwynd, Alexander, of Hethe 0
4565203 2220690 2220690 defendant Webbe William   612917 612917 Webbe, William, of Hethe 0
4565204 2220690 2220690 defendant Kokke John   612917 612917 Kokke, John, of Hethe 1
4587000 2227336 2227336 defendant Merssh Stephen   612917 612917 Merssh, Stephen, of Hethe 0
4614564 2235562 2235562 plaintiff Dyn John   612917 612917 Dyn, John, of Hethe 0
4634956 2241779 2241779 defendant Frankisse John   612917 612917 Frankisse, John, of Hethe 0
4652201 2246630 2246630 plaintiff atte Stone William   612917 612917 atte Stone, William, of Hethe 0
4656943 2248065 2248065 defendant Meller John husbandman 612917 612917 Meller, John, of Hethe, husbandman 2
4656944 2248065 2248065 defendant Meller Robert husbandman 612917 612917 Meller, Robert, of Hethe, husbandman 3
4656947 2248065 2248065 defendant atte Wode John spicer 612917 612917 atte Wode, John, of Hethe, spicer 6
4656948 2248065 2248065 defendant Yve Thomas shoemaker 612917 612917 Yve, Thomas, of Hethe, shoemaker 7
4656949 2248065 2248065 defendant atte Vyne Thomas tailor 612917 612917 atte Vyne, Thomas, of Hethe, tailor 8
4656950 2248065 2248065 defendant Shobery John weaver 612917 612917 Shobery, John, of Hethe, weaver 9
4656951 2248065 2248065 defendant Potman Lawrence spicer 612917 612917 Potman, Lawrence, of Hethe, spicer 10
4659796 2248913 2248913 defendant Tyler John husbandman 612917 612917 Tyler, John, of Hethe, husbandman 1
4671261 2256664 2256664 defendant Meller John husbandman 612917 612917 Meller, John, of Hethe, husbandman 2
4671262 2256664 2256664 defendant Meller Robert husbandman 612917 612917 Meller, Robert, of Hethe, husbandman 3
4671263 2256664 2256664 defendant Shobery John weaver 612917 612917 Shobery, John, of Hethe, weaver 4
4675740 2258019 2258019 defendant Marchaunt Thomas husbandman 612917 612917 Marchaunt, Thomas, of Hethe, husbandman 1
4680959 2259671 2259671 defendant Nonywode John butcher 612917 612917 Nonywode, John, of Hethe, butcher 0
4683813 2260547 2260547 plaintiff Philpot Henry   612917 612917 Philpot, Henry, of Hethe, on his own account 0
4684629 2260791 2260791 defendant Barker William husbandman 612917 612917 Barker, William, of Hethe, husbandman 0
4731748 2275118 2275118 defendant Skynner John brewer 612917 612917 Skynner, John, of Hethe, brewer 20
4741093 2277900 2277900 defendant Marchaunt John laborer 612917 612917 Marchaunt, John, of Hethe, laborer 3
4783241 2290776 2290776 defendant Bann or Baun Stephen repier or fishmonger 612917 612917 Bann or Baun, Stephen, of Hethe, repier or fishmonger 0
4785208 2291391 2291391 defendant atte Wode John spicer 612917 612917 atte Wode, John, of Hethe, spicer 0
4805033 2297779 2297779 defendant Mylde Richard husbandman 612917 612917 Mylde, Richard, of Hethe, husbandman 2
4807082 2298413 2298413 defendant Alby Stephen merchant 612917 612917 Alby, Stephen, of Hethe, merchant 4
4811763 2299790 2299790 defendant Torold John laborer 612917 612917 Torold, John, of Hethe, laborer 1
4818690 2301931 2301931 plaintiff Over--avene John, senior   612917 612917 Over--avene, John, senior, of Hethe 0
4821206 2302712 2302712 defendant Coker Richard shipman 612917 612917 Coker, Richard, of Hethe, shipman 0
4832433 2306179 2306179 defendant Gyllyng William draper 612917 612917 Gyllyng, William, of Hethe, draper 0
4860121 2314534 2314534 defendant Gyllyng William draper 612917 612917 Gyllyng, William, of Hethe, draper 0
4871031 2317915 2317915 defendant Boureman Thomas laborer 612917 612917 Boureman, Thomas, of Hethe, laborer 0
4871033 2317915 2317915 defendant Robbeiolle John repier or fishmonger 612917 612917 Robbeiolle, John, of Hethe, repier or fishmonger 2
4889158 2323397 2323397 defendant Yokeles or Zokeles Thomas chapman 612917 612917 Yokeles or Zokeles, Thomas, of Hethe, chapman 1
4894507 2324955 2324955 defendant Tropham Agnes widow 612917 612917 Tropham, Agnes, of Hethe, widow 3
4897039 2325727 2325727 defendant Lowys William butcher 612917 612917 Lowys, William, of Hethe, butcher 0
4916757 2331743 2331743 defendant Chestre John husbandman 612917 612917 Chestre, John, of Hethe, husbandman 1
4941155 2339257 2339257 defendant Wyllyam Geoffrey barber 612917 612917 Wyllyam, Geoffrey, of Hethe, barber 0
4972108 2348596 2348596 defendant Taillour John repyer or fishmonger 612917 612917 Taillour, John, of Hethe, repyer or fishmonger 0
4972110 2348596 2348596 defendant Atte Doune Robert husbandman 612917 612917 Atte Doune, Robert, of Hethe, husbandman 2
4987121 2353096 2353096 defendant Tanner Simon husbandman 612917 612917 Tanner, Simon, of Hethe, husbandman 0
4987125 2353098 2353098 defendant Tanner Simon husbandman 612917 612917 Tanner, Simon, of Hethe, husbandman 0
5020295 2362824 2362824 plaintiff Ryddon Robert   612917 612917 Ryddon, Robert, of Hethe 2
5023013 2363639 2363639 defendant Russell Thomas husbandman 612917 612917 Russell, Thomas, of Hethe, husbandman 0
5056085 2373393 2373393 defendant Pote Richard husbandman 612917 612917 Pote, Richard, of Hethe, husbandman 1
5146836 2400214 2400214 defendant Tyler Roger husbandman 612917 612917 Tyler, Roger, of Hethe, husbandman 3
5236808 2426350 2426350 defendant Smalwode Richard yeoman 612917 612917 Smalwode, Richard, of Hethe, yeoman 0
5272844 2437132 2437132 defendant Wright William   612917 612917 Wright, William, of Hethe, parish clerk 2
5278089 2438683 2438683 defendant Tyler Richard tiler 612917 612917 Tyler, Richard, of Hethe, tiler 2
5279328 2439046 2439046 defendant Clobber Richard husbandman 612917 612917 Clobber, Richard, of Hethe, husbandman 0
5308434 2447558 2447558 defendant Cole Walter butcher 612917 612917 Cole, Walter, of Hethe, butcher 0
5308435 2447558 2447558 defendant Shape Robert yeoman 612917 612917 Shape, Robert, of Hethe, yeoman 1
5308450 2447563 2447563 defendant Cole Walter butcher 612917 612917 Cole, Walter, of Hethe, butcher 0
5308451 2447563 2447563 defendant Shape Robert yeoman 612917 612917 Shape, Robert, of Hethe, yeoman 1
5308453 2447564 2447564 defendant Cole Walter butcher 612917 612917 Cole, Walter, of Hethe, butcher 0
5308454 2447564 2447564 defendant Shape Robert yeoman 612917 612917 Shape, Robert, of Hethe, yeoman 1
5312268 2448706 2448706 defendant Mychell Thomas   612917 612917 together with Mychell, Thomas, of Hethe, parish clerk 1
5312271 2448707 2448707 defendant Mychell Thomas   612917 612917 Mychell, Thomas, of Hethe, parish clerk 0
5316754 2450096 2450096 defendant Tyler Richard husbandman 612917 612917 Tyler, Richard, of Hethe, husbandman 3
5337616 2456320 2456320 plaintiff Hykke John   612917 612917 Hykke, John, of Hethe 0
5368791 2465830 2465830 defendant Stace Richard   612917 612917 Stace, Richard, of Hethe 0
5368795 2465831 2465831 defendant Stach Richard   612917 612917 Stach, Richard, of Hethe 0
5482425 2499683 2499683 defendant Malmayn John yeoman 612917 612917 Malmayn, John, of Hethe, yeoman 2
5549141 2519792 2519792 defendant Smolte Randolph laborer 612917 612917 Smolte, Randolph, of Hethe, laborer 1
5611861 2547446 2547446 defendant Combe John   612917 612917 Combe, John, of Hethe 0
5621292 2550549 2550549 plaintiff Staunford Andrew de   612917 612917 Staunford, Andrew de, of Hethe, formerly parson of the church 0
5625466 2551910 2551910 defendant Honywode John butcher 612917 612917 Honywode, John, of Hethe, butcher 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);