names

98 rows where place_id = 637822

✎ 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
3838804 1970064 1970064 defendant Holford Alexander laborer 637822 637822 Holford, Alexander, of Tysherst, laborer 0
3971008 2014417 2014417 defendant Yonge Simon   637822 637822 Yonge, Simon, of Tysherst, "rypyar" or fishmonger 1
4168031 2084304 2084304 defendant Webbe Thomas husbandman 637822 637822 Webbe, Thomas, of Tysherst, husbandman 8
4168032 2084304 2084304 defendant Maunser Thomas yeoman 637822 637822 Maunser, Thomas, of Tysherst, yeoman 9
4168033 2084304 2084304 defendant Sennock William husbandman 637822 637822 Sennock, William, of Tysherst, husbandman 10
4168034 2084304 2084304 defendant Bottom John husbandman 637822 637822 Bottom, John, of Tysherst, husbandman 11
4168035 2084304 2084304 defendant Smyth Francis husbandman 637822 637822 Smyth, Francis, of Tysherst, husbandman 12
4189100 2091679 2091679 defendant Maunser Robert   637822 637822 Maunser, Robert, of Tysherst, yeoman, son of Thomas 0
4189103 2091680 2091680 defendant Maunser Thomas yeoman 637822 637822 Maunser, Thomas, of Tysherst, yeoman 0
4222394 2103324 2103324 defendant Blacke John saddler 637822 637822 Blacke, John, of Tysherst, saddler 0
4229076 2105652 2105652 defendant Kyne John yeoman 637822 637822 Kyne, John, of Tysherst, yeoman 1
4230795 2106270 2106270 defendant Basset Thomas yeoman 637822 637822 Basset, Thomas, of Tysherst, yeoman 0
4258736 2115887 2115887 defendant Jyne John yeoman 637822 637822 Jyne, John, of Tysherst, yeoman 1
4269868 2119513 2119513 defendant Kyne John yeoman 637822 637822 Kyne, John, of Tysherst, yeoman 0
4314461 2135170 2135170 defendant Holland John, junior husbandman 637822 637822 Holland, John, junior, of Tysherst, husbandman 0
4321353 2137561 2137561 defendant Cogger William   637822 637822 Cogger, William, of Tysherst, yeoman, ash burner 0
4321354 2137561 2137561 defendant Balden alias Pylcher Richard carpenter 637822 637822 Balden alias Pylcher, Richard, of Tysherst, yeoman, carpenter 1
4321355 2137561 2137561 defendant Prockter William merchant 637822 637822 Prockter, William, of Tysherst, merchant 2
4326177 2139124 2139124 defendant Fen or Ven Richard sawyer 637822 637822 Fen or Ven, Richard, of Tysherst, sawyer 1
4361779 2151371 2151371 defendant Nashe Anthony butcher 637822 637822 Nashe, Anthony, of Tysherst, butcher 0
4361780 2151371 2151371 defendant Hollande Gregory yeoman 637822 637822 Hollande, Gregory, of Tysherst, yeoman 1
4365068 2152562 2152562 defendant Tayler Nicholas yeoman 637822 637822 Tayler, Nicholas, of Tysherst, yeoman 0
4365070 2152562 2152562 defendant Webbe Thomas yeoman 637822 637822 Webbe, Thomas, of Tysherst, yeoman 2
4368928 2153946 2153946 defendant Nashe Anthony butcher 637822 637822 Nashe, Anthony, of Tysherst, butcher 0
4376453 2156648 2156648 defendant Tapham John tailor 637822 637822 Tapham, John, of Tysherst, tailor 1
4383956 2159340 2159340 defendant Kyne William husbandman 637822 637822 Kyne, William, of Tysherst, husbandman 1
4472284 2192003 2192003 defendant Kechenham John   637822 637822 Kechenham, John, of Tysherst 0
4472285 2192003 2192003 defendant William John   637822 637822 William, John, of Tysherst 1
4531600 2210151 2210151 defendant Bakere William   637822 637822 Bakere, William, of Tysherst 0
4531601 2210151 2210151 defendant Coliere John   637822 637822 Coliere, John, of Tysherst 1
4542917 2213678 2213678 defendant Bourdon Richard   637822 637822 Bourdon, Richard, of Tysherst 1
4560837 2219347 2219347 defendant Bakere William   637822 637822 Bakere, William, of Tysherst 0
4574023 2223398 2223398 plaintiff Beche Stephen   637822 637822 Beche, Stephen, of Tysherst 0
4574024 2223398 2223398 defendant atte Doune Peter   637822 637822 atte Doune, Peter, of Tysherst 0
4643058 2244078 2244078 defendant William John   637822 637822 William, John, of Tysherst 0
4667424 2255532 2255532 defendant Keneward Thomas husbandman 637822 637822 Keneward, Thomas, of Tysherst, husbandman 0
4667428 2255533 2255533 defendant Keneward Thomas husbandman 637822 637822 Keneward, Thomas, of Tysherst, husbandman 0
4673102 2257230 2257230 defendant Bereworth John thatcher 637822 637822 Bereworth, John, of Tysherst, thatcher 1
4687261 2261623 2261623 plaintiff Stelde Thomas   637822 637822 Stelde, Thomas, of Tysherst 0
4703238 2266392 2266392 defendant Latter John husbandman 637822 637822 Latter, John, of Tysherst, husbandman 0
4703239 2266392 2266392 defendant Martyn Stephen sheer man 637822 637822 Martyn, Stephen, of tysherst, sheer man 1
4718409 2271096 2271096 plaintiff Bakere Robert   637822 637822 Bakere, Robert, of Tysherst 0
4718410 2271096 2271096 defendant Stefne Roger draper 637822 637822 Stefne, Roger, of Tysherst, draper 0
4723669 2272709 2272709 defendant Steven Roger draper 637822 637822 Steven, Roger, of Tysherst, draper 0
4723670 2272709 2272709 defendant Baseden Thomas carpenter 637822 637822 Baseden, Thomas, of Tysherst, carpenter 1
4727747 2273922 2273922 defendant Sprynget John laborer 637822 637822 Sprynget, John, of Tysherst, laborer 2
4750608 2280664 2280664 defendant Ketel Thomas butcher 637822 637822 Ketel, Thomas, of Tysherst, butcher 0
4766723 2285582 2285582 defendant Shoyswell William gent 637822 637822 Shoyswell, William, of Tysherst, gent 0
4772702 2287434 2287434 defendant Sprynget John, sen husbandman 637822 637822 Sprynget, John, sen, of Tysherst, husbandman 0
4772703 2287434 2287434 defendant Turmory Richard laborer 637822 637822 Turmory, Richard, of Tysherst, laborer 1
4772704 2287434 2287434 defendant Martyn Stephen sheerman 637822 637822 Martyn, Stephen, of Tysherst, sheerman 2
4785675 2291549 2291549 defendant William John husbandman 637822 637822 William, John, of Tysherst, husbandman 1
4789072 2292639 2292639 plaintiff Holmane John, senior   637822 637822 Holmane, John, senior, of Tysherst 0
4790103 2292981 2292981 defendant Twyt William glover 637822 637822 Twyt, William, of Tysherst, glover 0
4795573 2294767 2294767 defendant Latter alias Holman John husbandman 637822 637822 Latter alias Holman, John, of Tysherst, husbandman 0
4798016 2295565 2295565 defendant Turmory Richard laborer 637822 637822 Turmory, Richard, of Tysherst, laborer 0
4798017 2295565 2295565 defendant Martyn Stephen sherman 637822 637822 Martyn, Stephen, of Tysherst, sherman 1
4812127 2299903 2299903 defendant Brenestede Richard   637822 637822 Brenestede, Richard, of Tysherst, linen weaver 0
4817884 2301677 2301677 defendant atte Wode Robert husbandman 637822 637822 atte Wode, Robert, of Tysherst, husbandman 0
4817885 2301677 2301677 defendant Harlesey John yeoman 637822 637822 Harlesey, John, of Tysherst, yeoman 1
4817887 2301677 2301677 defendant Haremere John husbandman 637822 637822 Haremere, John, of Tysherst, husbandman 3
4817888 2301677 2301677 defendant Holman John   637822 637822 Holman, John, of Tysherst, latte maker or lathe maker 4
4829059 2305128 2305128 defendant Harlesay John husbandman 637822 637822 Harlesay, John, of Tysherst, husbandman 0
4840141 2308466 2308466 defendant Bereword John tanner 637822 637822 Bereword, John, of Tysherst, tanner 0
4955829 2343712 2343712 defendant Baret William laborer 637822 637822 Baret, William, of Tysherst, laborer 0
4987227 2353127 2353127 defendant Foule William husbandman 637822 637822 Foule, William, of Tysherst, husbandman 1
5003467 2357909 2357909 defendant Wodeland John husbandman 637822 637822 Wodeland, John, of Tysherst, husbandman 0
5003471 2357911 2357911 defendant Wodeland John husbandman 637822 637822 Wodeland, John, of Tysherst, husbandman 0
5005254 2358434 2358434 defendant Ward Thomas husbandman 637822 637822 Ward, Thomas, of Tysherst, husbandman 0
5005256 2358435 2358435 defendant Ward Thomas husbandman 637822 637822 Ward, Thomas, of Tysherst, husbandman 0
5007362 2359047 2359047 defendant Chaloner Thomas smith 637822 637822 Chaloner, Thomas, of Tysherst, smith 0
5011708 2360273 2360273 defendant Bereworth Gabriel husbandman 637822 637822 Bereworth, Gabriel, of Tysherst, husbandman 0
5011709 2360273 2360273 defendant Bereworth John husbandman 637822 637822 Bereworth, John, of Tysherst, husbandman 1
5067952 2376914 2376914 defendant Berworth John tanner 637822 637822 Berworth, John, of Tysherst, tanner 0
5111915 2389873 2389873 defendant Playstede John gent 637822 637822 Playstede, John, of Tysherst, gent 1
5111916 2389873 2389873 defendant Waterman Richard yeoman 637822 637822 Waterman, Richard, of Tysherst, yeoman 2
5111917 2389873 2389873 defendant Hamond William yeoman 637822 637822 Hamond, William, of Tysherst, yeoman 3
5225541 2423144 2423144 defendant Burkham Richard (legal representative) 637822 637822 Burkham, Richard, of Tysherst, husbandman, executors of 0
5225543 2423144 2423144 defendant Burkham Robert husbandman 637822 637822 Burkham, Robert, of Tysherst, husbandman 2
5246562 2429157 2429157 defendant Burkham Roger husbandman 637822 637822 (Burkham, Roger, of Tysherst, husbandman 1
5246564 2429157 2429157 defendant Couper Robert husbandman 637822 637822 Couper, Robert, of Tysherst, husbandman 3
5264326 2434598 2434598 defendant Burkham Richard (legal representative) 637822 637822 Burkham, Richard, of Tysherst, husbandman, executors of 0
5266723 2435345 2435345 defendant Merser Robert   637822 637822 Merser, Robert, of Tysherst, "ripyer" 0
5266724 2435345 2435345 defendant atte Wode Richard laborer 637822 637822 atte Wode, Richard, of Tysherst, laborer 1
5303203 2445951 2445951 defendant Mercer Robert   637822 637822 Mercer, Robert, of Tysherst, inland fish seller 0
5336735 2456054 2456054 defendant Skynner Adam husbandman 637822 637822 Skynner, Adam, of Tysherst, husbandman 1
5336741 2456056 2456056 defendant Partryche Gabriel husbandman 637822 637822 Partryche, Gabriel, of Tysherst, husbandman 0
5351373 2460528 2460528 defendant Nasshe Thomas   637822 637822 Nasshe, Thomas, of Tysherst, "repyer" 0
5354457 2461464 2461464 defendant Partryche Gabriel husbandman 637822 637822 Partryche, Gabriel, of Tysherst, husbandman 0
5449321 2489687 2489687 defendant Sexten William laborer 637822 637822 Sexten, William, of Tysherst, laborer 0
5449322 2489687 2489687 defendant Sexten John laborer 637822 637822 Sexten, John, of Tysherst, laborer 1
5449553 2489754 2489754 defendant Hamond Richard fuyster or forester 637822 637822 Hamond, Richard, of Tysherst, fuyster or forester 0
5461407 2493363 2493363 defendant Sexten John laborer 637822 637822 Sexten, John, of tysherst, laborer 1
5461707 2493440 2493440 defendant Hamond Richard fuyster or forester 637822 637822 Hamond, Richard, of Tysherst, fuyster or forester 0
5582064 2529457 2529457 defendant Stapley Richard yeoman 637822 637822 Stapley, Richard, of Tysherst, yeoman 0
5582066 2529458 2529458 defendant Stapley Richard yeoman 637822 637822 Stapley, Richard, of Tysherst, yeoman 0
5611670 2547384 2547384 defendant Lymyndenne William   637822 637822 Lymyndenne, William, of Tysherst 0
5631888 2553993 2553993 defendant Swyft Thomas weaver 637822 637822 Swyft, Thomas, of Tysherst, weaver 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);