names

134 rows where place_id = 591957

✎ 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
3588978 1864203 1864203 defendant Jooce William (legal representative) 591957 591957 Jooce, William, of Helmyngham, esq, executors of 1
3606122 1869582 1869582 defendant Playford John clerk 591957 591957 Playford, John, of Helmyngham, clerk 0
3606125 1869583 1869583 defendant Playford John clerk 591957 591957 Playford, John, of Helmyngham, clerk 0
3607274 1869937 1869937 defendant Savage John husbandman 591957 591957 Savage, John, of Helmyngham, husbandman 6
3655412 1911953 1911953 defendant (illegible) Henry husbandman 591957 591957 --, Henry, of Helmyngham, husbandman 0
3655443 1911962 1911962 defendant Butt Henry husbandman 591957 591957 Butt, Henry, of Helmyngham, husbandman 0
3659449 1913214 1913214 defendant Hoxson John smith 591957 591957 Hoxson, John, of Helmyngham, smith 3
3751446 1942369 1942369 defendant Crosse John clerk 591957 591957 Crosse, John, of Helmyngham, clerk 1
3761937 1945738 1945738 defendant Heryng Edmund husbandman 591957 591957 Heryng, Edmund, of Helmyngham, husbandman 2
3827165 1966358 1966358 defendant Withe John yeoman 591957 591957 Withe, John, of Helmyngham, yeoman 0
3827169 1966360 1966360 defendant Wythe John yeoman 591957 591957 Wythe, John, of Helmyngham, yeoman 0
3890257 1986986 1986986 defendant Sparlyng John tailor 591957 591957 Sparlyng, John, of Helmyngham, tailor 0
3897968 1989527 1989527 defendant Foldyck William husbandman 591957 591957 Foldyck, William, of Helmyngham, husbandman 1
3925905 1998979 1998979 defendant Herryng Edmund husbandman 591957 591957 Herryng, Edmund, of Helmyngham, husbandman 0
3940960 2003985 2003985 plaintiff Talmache Lionel (legal representative) 591957 591957 Talmache, Lionel, of Helmyngham, executor of 0
3940963 2003986 2003986 plaintiff Talmache Lionel (legal representative) 591957 591957 Talmache, Lionel, of Helmyngham, executor of 0
3940967 2003987 2003987 plaintiff Talmache Lionel (legal representative) 591957 591957 Talmache, Lionel, of Helmyngham, senior, esq, executor of 0
3977961 2016865 2016865 plaintiff Mallyng Robert husbandman 591957 591957 Mallyng, Robert, of Helmyngham, husbandman 0
4071297 2050038 2050038 plaintiff Morriffe or Morrisse Ralph gent 591957 591957 Morriffe or Morrisse, Ralph, of Helmyngham, or of Stow Markett, gent 0
4119971 2067430 2067430 defendant Bacon William husbandman 591957 591957 Bacon, William, of Helmyngham, husbandman 0
4166706 2083853 2083853 defendant Wilkenson Thomas clerk 591957 591957 Wilkenson, Thomas, of Helmyngham, clerk 0
4256133 2115032 2115032 defendant Paymonde or Pamont Thomas husbandman 591957 591957 Paymonde or Pamont, Thomas, of Helmyngham, husbandman 2
4496555 2199598 2199598 defendant Bernard Robert   591957 591957 Bernard, Robert, of Helmyngham 3
4551434 2216386 2216386 defendant Wodeward John   591957 591957 Wodeward, John, of Helmyngham 0
4613601 2235269 2235269 defendant Julyan William, sen   591957 591957 Julyan, William, sen, of Helmyngham 0
4693236 2263385 2263385 defendant Bowebrook Waltler yeoman 591957 591957 Bowebrook, Waltler, of Helmyngham, yeoman 0
4693442 2263449 2263449 defendant Warde Roger yeoman 591957 591957 Warde, Roger, of Helmyngham, yeoman 0
4754080 2281655 2281655 defendant Boubrok Walter yeoman 591957 591957 Boubrok, Walter, of Helmyngham, yeoman 2
4761439 2283921 2283921 defendant Walden John clerk 591957 591957 Walden, John, of Helmyngham, clerk 0
4835800 2307192 2307192 defendant Wodeward John   591957 591957 Wodeward, John, of Helmyngham, franklin 1
4963354 2345947 2345947 defendant Joce James esq 591957 591957 Joce, James, of Helmyngham, esq 0
4978895 2350644 2350644 defendant Savage Richard husbandman 591957 591957 Savage, Richard, of Helmyngham, husbandman 1
5022070 2363348 2363348 defendant Joce James esq 591957 591957 Joce, James, of Helmyngham, esq 0
5024359 2364040 2364040 plaintiff Holm John   591957 591957 Holm, John, of Helmyngham 4
5024365 2364040 2364040 defendant Savage Richard husbandman 591957 591957 Savage, Richard, of Helmyngham, husbandman 5
5024368 2364040 2364040 defendant Martyn John yeoman 591957 591957 Martyn, John, of Helmyngham, yeoman 8
5024377 2364040 2364040 defendant Bougbrook Walter yeoman 591957 591957 (Bougbrook, Walter, of Helmyngham, yeoman 17
5045859 2370396 2370396 defendant Coupere Helen widow 591957 591957 Coupere, Helen, of Helmyngham, widow 0
5064226 2375844 2375844 defendant Kenrede Thomas yeoman 591957 591957 Kenrede, Thomas, of Helmyngham, yeoman 0
5064227 2375844 2375844 defendant Kenrede John yeoman 591957 591957 Kenrede, John, of Helmyngham, yeoman 1
5072614 2378297 2378297 defendant Hobbys Edmund   591957 591957 Hobbys, Edmund, of Helmyngham, shepherd 1
5087045 2382591 2382591 defendant Wylde John yeoman 591957 591957 Wylde, John, of Helmyngham, yeoman 0
5087876 2382834 2382834 plaintiff Joce William   591957 591957 Joce, William, of Helmyngham 0
5087959 2382857 2382857 plaintiff Joos William gent 591957 591957 Joos, William, of Helmyngham, gent 0
5092376 2384147 2384147 defendant Smyth Thomas yeoman 591957 591957 Smyth, Thomas, of Helmyngham, yeoman 0
5092377 2384147 2384147 defendant Cook Agnes   591957 591957 Cook, Agnes, of Helmyngham, servant 1
5106524 2388336 2388336 defendant Joce William esq 591957 591957 Joce, William, of Helmyngham, esq 0
5106525 2388336 2388336 defendant Sanston or Sauston William   591957 591957 Sanston or Sauston, William, of Helmyngham, servant 1
5106526 2388336 2388336 defendant Bedyngfeld Thomas yeoman 591957 591957 Bedyngfeld, Thomas, of Helmyngham, yeoman 2
5106527 2388336 2388336 defendant Hewys John   591957 591957 Hewys, John, of Helmyngham, servant 3
5106528 2388336 2388336 defendant Keke William   591957 591957 Keke, William, of Helmyngham, servant 4
5112734 2390114 2390114 defendant Jelyon John carpenter 591957 591957 Jelyon, John, of Helmyngham, carpenter 0
5112735 2390114 2390114 defendant Jelyen Robert laborer 591957 591957 Jelyen, Robert, of Helmyngham, laborer 1
5136294 2397133 2397133 defendant Rygdon William husbandman 591957 591957 Rygdon, William, of Helmyngham, husbandman 2
5143453 2399218 2399218 defendant Semere John clerk 591957 591957 Semere, John, of Helmyngham, clerk 0
5143458 2399219 2399219 defendant Semere John clerk 591957 591957 Semere, John, of Helmyngham, clerk 0
5146711 2400176 2400176 defendant Semere John clerk 591957 591957 Semere, John, of Helmyngham, clerk 0
5146713 2400177 2400177 defendant Semere John clerk 591957 591957 Semere, John, of Helmyngham, clerk 0
5156642 2403097 2403097 defendant Rygon William husbandman 591957 591957 Rygon, William, of Helmyngham, husbandman 2
5159923 2403999 2403999 defendant Heryng John husbandman 591957 591957 Heryng, John, of Helmyngham, husbandman 0
5174883 2408349 2408349 defendant Heryng John husbandman 591957 591957 Heryng, John, of Helmyngham, husbandman 0
5183518 2410914 2410914 defendant Bette Thomas tailor 591957 591957 Bette, Thomas, of Helmyngham, tailor 1
5186742 2411871 2411871 defendant Martyn John carpenter 591957 591957 (Martyn, John, of Helmyngham, carpenter 1
5186743 2411871 2411871 defendant Martyn Andrew laborer 591957 591957 Martyn, Andrew, of Helmyngham, laborer 2
5186749 2411872 2411872 defendant Martyn Andrew laborer 591957 591957 Martyn, Andrew, of Helmyngham, laborer 2
5186751 2411872 2411872 defendant Gybon William husbandman 591957 591957 Gybon, William, of Helmyngham, husbandman 4
5186755 2411873 2411873 defendant Martyn Andrew laborer 591957 591957 Martyn, Andrew, of Helmyngham, laborer 2
5186757 2411873 2411873 defendant Gybon William husbandman 591957 591957 Gybon, William, of Helmyngham, husbandman 4
5188973 2412510 2412510 defendant Alfeythe Richard husbandman 591957 591957 Alfeythe, Richard, of Helmyngham, husbandman 0
5188974 2412510 2412510 defendant Davy Robert laborer 591957 591957 Davy, Robert, of Helmyngham, laborer 1
5188975 2412510 2412510 defendant Bette William yeoman 591957 591957 Bette, William, of Helmyngham, yeoman 2
5192575 2413561 2413561 defendant Alcok John husbandman 591957 591957 Alcok, John, of Helmyngham, husbandman 0
5195750 2414501 2414501 defendant Heryng John husbandman 591957 591957 Heryng, John, of Helmyngham, husbandman 0
5203902 2416892 2416892 defendant Julyon Robert yeoman 591957 591957 Julyon, Robert, of Helmyngham, yeoman 0
5203903 2416892 2416892 defendant Bette Thomas tailor 591957 591957 Bette, Thomas, of Helmyngham, tailor 1
5205349 2417319 2417319 defendant Martyn William (legal representative) 591957 591957 Martyn, William, of Helmyngham, laborer, executors of 0
5205351 2417319 2417319 defendant Martyn Andrew laborer 591957 591957 Martyn, Andrew, of Helmyngham, laborer 2
5205353 2417319 2417319 defendant Gybon William husbandman 591957 591957 Gybon, William, of Helmyngham, husbandman 4
5206317 2417585 2417585 defendant Alferythe Richard husbandman 591957 591957 Alferythe, Richard, of Helmyngham, husbandman 0
5206318 2417585 2417585 defendant Davy Robert laborer 591957 591957 Davy, Robert, of Helmyngham, laborer 1
5206319 2417585 2417585 defendant Bette William yeoman 591957 591957 Bette, William, of Helmyngham, yeoman 2
5207773 2418014 2418014 defendant Alcok John husbandman 591957 591957 Alcok, John, of Helmyngham, husbandman 0
5214056 2419842 2419842 defendant Holdernesse John husbandman 591957 591957 Holdernesse, John, of Helmyngham, husbandman 0
5219964 2421550 2421550 defendant Joos William esq 591957 591957 Joos, William, of Helmyngham, esq 0
5226851 2423517 2423517 defendant Heryng John yeoman 591957 591957 Heryng, John, of Helmyngham, yeoman 0
5240325 2427383 2427383 defendant Jelyon Robert husbandman 591957 591957 Jelyon, Robert, of Helmyngham, husbandman 0
5244376 2428537 2428537 defendant Martyn Thomas husbandman 591957 591957 Martyn, Thomas, of Helmyngham, husbandman 1
5256386 2432121 2432121 defendant Savage John yeoman 591957 591957 Savage, John, of Helmyngham, yeoman 0
5256388 2432122 2432122 defendant Savage John yeoman 591957 591957 Savage, John, of Helmyngham, yeoman 0
5257523 2432472 2432472 defendant Joce William esq 591957 591957 Joce, William, of Helmyngham, esq 0
5257912 2432597 2432597 defendant Gelion Robert yeoman 591957 591957 Gelion, Robert, of Helmyngham, yeoman 0
5259912 2433223 2433223 plaintiff Joce William   591957 591957 Joce, William, of Helmyngham 0
5262188 2433922 2433922 defendant Western Thomas barker 591957 591957 Western, Thomas, of Helmyngham, barker 0
5282053 2439824 2439824 defendant Savage Richard husbandman 591957 591957 Savage, Richard, of Helmyngham, husbandman 0
5282054 2439824 2439824 defendant Dregges Stephen husbandman 591957 591957 Dregges, Stephen, of Helmyngham, husbandman 1
5282055 2439824 2439824 defendant Warde John husbandman 591957 591957 Warde, John, of Helmyngham, husbandman 2
5282056 2439824 2439824 defendant Julyon Robert husbandman 591957 591957 Julyon, Robert, of Helmyngham, husbandman 3
5284580 2440500 2440500 defendant Wyth John husbandman 591957 591957 Wyth, John, of Helmyngham, husbandman 1
5304820 2446446 2446446 defendant Gebon John carpenter 591957 591957 Gebon, John, of Helmyngham, carpenter 1
5304822 2446446 2446446 defendant Couper Robert laborer 591957 591957 Couper, Robert, of Helmyngham, laborer 3

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