names

85 rows where place_id = 597970

✎ 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
3630584 1904395 1904395 defendant Kays John, senior laborer 597970 597970 Kays, John, senior, of Feryng, laborer 0
3630585 1904395 1904395 defendant Kays John, junior laborer 597970 597970 Kays, John, junior, of Feryng, laborer 1
3653156 1911321 1911321 defendant Kenhome William clerk 597970 597970 Kenhome, William, of Feryng, clerk 1
3674181 1917962 1917962 plaintiff Wode Richard   597970 597970 (Wode, Richard, of Feryng 1
3684057 1921148 1921148 plaintiff Wode Richard   597970 597970 Wode, Richard, of Feryng 0
3772118 1948972 1948972 defendant Keys John husbandman 597970 597970 Keys, John, of Feryng, husbandman 0
3783984 1952772 1952772 defendant Pygott Katherine widow 597970 597970 Pygott, Katherine, of Feryng, widow 1
3783985 1952772 1952772 defendant Pygott John laborer 597970 597970 Pygott, John, of Feryng, laborer 2
3836920 1969450 1969450 defendant Copshede Richard husbandman 597970 597970 Copshede, Richard, of Feryng, husbandman 1
3870984 1980547 1980547 defendant Keys John yeoman 597970 597970 Keys, John, of Feryng, yeoman 2
3884538 1985103 1985103 defendant Hopton John husbandman 597970 597970 Hopton, John, of Feryng, husbandman 0
3898241 1989619 1989619 defendant Hopton John husbandman 597970 597970 Hopton, John, of Feryng, husbandman 0
3925521 1998846 1998846 plaintiff Wode Richard, senior (legal representative) 597970 597970 Wode, Richard, senior, of Feryng, yeoman, administrator of 0
3925523 1998846 1998846 defendant Heygate Reginald yeoman 597970 597970 Heygate, Reginald, of Feryng, yeoman 0
3961813 2011232 2011232 defendant Lanman John drover 597970 597970 Lanman, John, of Feryng, drover 1
3969317 2013871 2013871 defendant Bullocke John husbandman 597970 597970 Bullocke, John, of Feryng, husbandman 0
3969318 2013871 2013871 defendant Alton Richard laborer 597970 597970 Alton, Richard, of Feryng, laborer 1
3969319 2013871 2013871 defendant Garlyng William   597970 597970 Garlyng, William, of Feryng, wheelwright 2
4464209 2189478 2189478 defendant Goldhangre John butcher 597970 597970 Goldhangre, John, of Feryng, butcher 0
4490948 2197862 2197862 defendant Moys Walter   597970 597970 Moys, Walter, of Feryng 3
4544858 2214313 2214313 plaintiff Belewe John (legal representative) 597970 597970 Belewe, John, of Feryng, executors of 0
4544859 2214313 2214313 plaintiff Couper John   597970 597970 (Couper, John, of Feryng, vicar 1
4567069 2221256 2221256 plaintiff Symond John   597970 597970 Symond, John, of Feryng 0
4567070 2221256 2221256 defendant Aungere William   597970 597970 Aungere, William, of Feryng 0
4636635 2242285 2242285 defendant Mytche Robert   597970 597970 Mytche, Robert, of Feryng 0
4637460 2242510 2242510 defendant Fullere John   597970 597970 Fullere, John, of Feryng 0
4677830 2258682 2258682 defendant Bulbek John fuller 597970 597970 Bulbek, John, of Feryng, fuller 0
4762718 2284319 2284319 defendant Cook John husbandman 597970 597970 Cook, John, of Feryng, husbandman 0
4782173 2290424 2290424 plaintiff Coke John   597970 597970 Coke, John, of Feryng 0
4786361 2291779 2291779 defendant Cook John husbandman 597970 597970 Cook, John, of Feryng, husbandman 0
4833758 2306569 2306569 plaintiff Cokerell Simon   597970 597970 Cokerell, Simon, of Feryng 0
4844343 2309739 2309739 defendant Clerk John hostiller 597970 597970 Clerk, John, of Feryng, hostiller 0
4877692 2319984 2319984 defendant Cook John husbandman 597970 597970 Cook, John, of Feryng, husbandman 2
4895551 2325277 2325277 defendant Clerk John hosteler 597970 597970 Clerk, John, of Feryng, hosteler 0
4916383 2331625 2331625 plaintiff Ewell John esq 597970 597970 Ewell, John, of Feryng, esq 0
4916386 2331625 2331625 defendant Grene John laborer 597970 597970 Grene, John, of Feryng, laborer 2
4964218 2346200 2346200 defendant Bocher Robert butcher 597970 597970 Bocher, Robert, of Feryng, butcher 1
4965031 2346460 2346460 defendant Clerk John hosteler 597970 597970 Clerk, John, of Feryng, hosteler 0
4970589 2348144 2348144 defendant Cook Thomas butcher 597970 597970 Cook, Thomas, of Feryng, butcher 1
5009663 2359705 2359705 defendant Waryn John   597970 597970 Waryn, John, of Feryng, single man 3
5009664 2359705 2359705 defendant Snapys Alice widow 597970 597970 Snapys, Alice, of Feryng, widow 4
5013888 2360912 2360912 defendant Totriche Simon laborer 597970 597970 Totriche, Simon, of Feryng, laborer 2
5067393 2376756 2376756 plaintiff Oldhalle William draper 597970 597970 Oldhalle, William, of Feryng, draper 0
5067399 2376757 2376757 plaintiff Oldhalle William draper 597970 597970 Oldhalle, William, of Feryng, draper 0
5067405 2376758 2376758 plaintiff Oldhalle William draper 597970 597970 Oldhalle, William, of Feryng, draper 0
5092039 2384049 2384049 plaintiff Oldehall William draper 597970 597970 Oldehall, William, of Feryng, draper 0
5092041 2384050 2384050 plaintiff Oldehalle William draper 597970 597970 Oldehalle, William, of Feryng, draper 0
5092058 2384054 2384054 plaintiff Oldhalle William draper 597970 597970 Oldhalle, William, of Feryng, draper 0
5092064 2384055 2384055 plaintiff Oldhalle William draper 597970 597970 Oldhalle, William, of Feryng, draper 0
5092068 2384055 2384055 defendant Crakebon John smith 597970 597970 Crakebon, John, of Feryng, smith 3
5092070 2384056 2384056 plaintiff Oldlhalle William draper 597970 597970 Oldlhalle, William, of Feryng, draper 0
5116274 2391191 2391191 plaintiff Oldhall William draper 597970 597970 Oldhall, William, of Feryng, draper 0
5116280 2391192 2391192 plaintiff Oldhall William draper 597970 597970 Oldhall, William, of Feryng, draper 0
5116288 2391194 2391194 plaintiff Oldhalle William draper 597970 597970 Oldhalle, William, of Feryng, or of Coggeshale, Essex, draper 0
5129998 2395260 2395260 defendant Huntyngfeld John miller 597970 597970 Huntyngfeld, John, of Feryng, miller 3
5133927 2396420 2396420 defendant Oldehall William draper 597970 597970 Oldehall, William, of Feryng, draper 0
5136541 2397203 2397203 plaintiff Oldhall William draper 597970 597970 Oldhall, William, of Feryng, draper 0
5136546 2397204 2397204 plaintiff Oldhall William draper 597970 597970 Oldhall, William, of Feryng, draper 0
5146390 2400074 2400074 defendant Hunyngfeld John miller 597970 597970 Hunyngfeld, John, of Feryng, miller 3
5149287 2400921 2400921 defendant Huntyngfeld John miller 597970 597970 Huntyngfeld, John, of Feryng, miller 3
5168257 2406428 2406428 defendant Huntyngfeld John miller 597970 597970 Huntyngfeld, John, of Feryng, miller 4
5233938 2425516 2425516 defendant Weston Richard gent 597970 597970 Weston, Richard, of Feryng, gent 0
5242176 2427911 2427911 defendant Doukeslee William husbandman 597970 597970 Doukeslee, William, of Feryng, husbandman 1
5243623 2428328 2428328 plaintiff Oldhalle William merchant 597970 597970 Oldhalle, William, of Feryng, draper, alias of Coggeshale, merchant 0
5254845 2431629 2431629 defendant Wheler Gilbert wheeler 597970 597970 Wheler, Gilbert, of Feryng, wheeler 2
5320844 2451322 2451322 defendant Pery Thomas husbandman 597970 597970 Pery, Thomas, of Feryng, husbandman 0
5338248 2456531 2456531 defendant Pery Thomas husbandman 597970 597970 Pery, Thomas, of Feryng, husbandman 0
5353620 2461204 2461204 defendant Burman John husbandman 597970 597970 Burman, John, of Feryng, husbandman 1
5356783 2462186 2462186 defendant Stampe Thomas pedder 597970 597970 Stampe, Thomas, of Feryng, pedder 0
5362706 2463984 2463984 defendant Wode James husbandman 597970 597970 Wode, James, of Feryng, husbandman 2
5399562 2474956 2474956 defendant Wybourgh John, senior weaver 597970 597970 Wybourgh, John, senior, of Feryng, weaver 0
5399563 2474956 2474956 defendant Wybourgh John, junior weaver 597970 597970 Wybourgh, John, junior, of Feryng, weaver 1
5399564 2474956 2474956 defendant Wybourgh Richard weaver 597970 597970 Wybourgh, Richard, of Feryng, weaver 2
5399565 2474956 2474956 defendant Bret Richard   597970 597970 Bret, Richard, of Feryng, rope maker 3
5399566 2474956 2474956 defendant Skylman John carpenter 597970 597970 Skylman, John, of Feryng, carpenter 4
5399567 2474956 2474956 defendant Godweyn William carpenter 597970 597970 Godweyn, William, of Feryng, carpenter 5
5404157 2476267 2476267 defendant Wulvyn Richard husbandman 597970 597970 Wulvyn, Richard, of Feryng, husbandman 1
5429104 2483630 2483630 defendant Cokerton Richard husbandman 597970 597970 Cokerton, Richard, of Feryng, husbandman 0
5475423 2497646 2497646 defendant atte Wode James husbandman 597970 597970 atte Wode, James, of Feryng, husbandman 4
5486975 2501000 2501000 defendant atte Wode James husbandman 597970 597970 atte Wode, James, of Feryng, husbandman 2
5504651 2506373 2506373 plaintiff Bakon William carpenter 597970 597970 Bakon, William, of Feryng, carpenter 0
5506748 2507030 2507030 defendant Wode John husbandman 597970 597970 Wode, John, of Feryng, husbandman 1
5513994 2509225 2509225 defendant Attewode John husbandman 597970 597970 Attewode, John, of Feryng, husbandman 0
5597989 2534272 2534272 defendant Wode Richard husbandman 597970 597970 Wode, Richard, of Feryng, husbandman 0
5597994 2534273 2534273 defendant Wode Richard husbandman 597970 597970 Wode, Richard, of Feryng, husbandman 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);