names

160 rows where place_id = 587821

✎ 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
3592531 1865280 1865280 defendant Smyth John butcher 587821 587821 Smyth, John, of South Elmham, butcher 0
3592569 1865292 1865292 defendant Cowper John yeoman 587821 587821 Cowper, John, of South Elmham, yeoman 0
3602463 1868430 1868430 defendant Froste Margaret widow 587821 587821 Froste, Margaret, of South Elmham, widow 0
3619809 1873769 1873769 defendant Toly Thomas yeoman 587821 587821 Toly, Thomas, of South Elmham, yeoman 1
3623288 1874811 1874811 plaintiff Scarff William engraver 587821 587821 Scarff, William, of South Elmham, engraver 0
3623289 1874811 1874811 defendant Toly Robert carpenter 587821 587821 Toly, Robert, of South Elmham, carpenter 0
3623290 1874811 1874811 defendant Toly Richard chaplain 587821 587821 Toly, Richard, of South Elmham, chaplain 1
3698078 1925626 1925626 defendant Mapys William laborer 587821 587821 Mapys, William, of South Elmham, laborer 1
3703271 1927295 1927295 defendant Taseborowe John yeoman 587821 587821 Taseborowe, John, of South Elmham St Peter, yeoman 0
3710032 1929448 1929448 defendant Raynebald Joan widow 587821 587821 Raynebald, Joan, of South Elmham, widow 0
3710033 1929448 1929448 defendant Wolnawe Margaret widow 587821 587821 Wolnawe, Margaret, of South Elmham, widow 1
3724596 1933974 1933974 defendant Dade Nicholas chaplain 587821 587821 Dade, Nicholas, of South Elmham St Peter, chaplain 1
3739157 1938458 1938458 defendant Colman Thomas yeoman 587821 587821 Colman, Thomas, of South Elmham, yeoman 0
3740496 1938885 1938885 defendant Dade Nicholas chaplain 587821 587821 Dade, Nicholas, of South Elmham St Peter, chaplain 0
3740500 1938886 1938886 defendant Dade Nicholas chaplain 587821 587821 Dade, Nicholas, of South Elmham St Peter, chaplain 0
3742607 1939556 1939556 defendant Pegyn William husbandman 587821 587821 Pegyn, William, of South Elmham, husbandman 0
3742608 1939556 1939556 defendant Cuttyng John husbandman 587821 587821 Cuttyng, John, of South Elmham, husbandman 1
3742665 1939576 1939576 defendant Russhemer Robert husbandman or minstrel 587821 587821 Russhemer, Robert, of South Elmham, husbandman or minstrel 0
3781434 1951929 1951929 plaintiff Harcok John husbandeman 587821 587821 Harcok, John, of South Elmham St Peter, husbandeman 0
3785687 1953315 1953315 defendant Harcock John husbandman 587821 587821 Harcock, John, of South Elmham St peter, husbandman 0
3790343 1954796 1954796 defendant Gates John carver 587821 587821 Gates, John, of South Elmham, carver 1
3825048 1965708 1965708 defendant Legat Stephen yeoman 587821 587821 Legat, Stephen, of South Elmham, yeoman 1
3836652 1969366 1969366 defendant Bylyngford James clerk 587821 587821 Bylyngford, James, of South Elmham, clerk 1
3840250 1970519 1970519 defendant Cuttyng John butcher 587821 587821 Cuttyng, John, of South Elmham, butcher 1
3852723 1974460 1974460 defendant Belyngford James clerk 587821 587821 Belyngford, James, of South Elmham, clerk 1
3852726 1974460 1974460 defendant Mapys William husbandman 587821 587821 Mapys, William, of South Elmham, husbandman 4
4024511 2033442 2033442 defendant Mylles Nicholas yeoman 587821 587821 Mylles, Nicholas, of South Elmham, yeoman 0
4025445 2033760 2033760 defendant Harcock John yeoman 587821 587821 Harcock, John, of South Elmham, yeoman 0
4025447 2033761 2033761 defendant Harcock John yeoman 587821 587821 Harcock, John, of South Elmham, yeoman 0
4060305 2046085 2046085 defendant Ryck William husbandman 587821 587821 Ryck, William, of South Elmham St Peter, husbandman 0
4060306 2046085 2046085 defendant Edward John laborer 587821 587821 Edward, John, of South Elmham St Peter, laborer 1
4075945 2051697 2051697 defendant Hayward Henry gent 587821 587821 Hayward, Henry, of South Elmham, gent 2
4446197 2183721 2183721 defendant Neweman William   587821 587821 Neweman, William, of South Elmham 0
4473750 2192434 2192434 defendant Cok Robert   587821 587821 Cok, Robert, of South Elmham 0
4510526 2203759 2203759 plaintiff Baroun Walter   587821 587821 Baroun, Walter, of South Elmham 0
4514383 2204919 2204919 plaintiff Cabald John   587821 587821 Cabald, John, of South Elmham 0
4514386 2204919 2204919 defendant Andrewe John   587821 587821 Andrewe, John, of South Elmham 2
4516101 2205449 2205449 defendant Haverkake John   587821 587821 Haverkake, John, of South Elmham, pedlar 1
4544912 2214326 2214326 defendant Baron Walter   587821 587821 Baron, Walter, of South Elmham 3
4554697 2217394 2217394 defendant Baron Walter   587821 587821 Baron, Walter, of South Elmham 1
4571845 2222778 2222778 defendant Bateman Robert esq 587821 587821 Bateman, Robert, of South Elmham, esq 0
4581267 2225608 2225608 plaintiff Drolle William   587821 587821 Drolle, William, of South Elmham 0
4589226 2228011 2228011 defendant Andymer Thomas   587821 587821 Andymer, Thomas, of South Elmham, parson of St James' church 3
4593935 2229379 2229379 defendant Drolle William   587821 587821 Drolle, William, of South Elmham 2
4631813 2240832 2240832 defendant Parker John   587821 587821 Parker, John, of South Elmham 0
4660861 2249223 2249223 defendant Ourys Thomas yeoman 587821 587821 Ourys, Thomas, of South Elmham, yeoman 0
4672397 2257019 2257019 defendant Bateman Robert esq 587821 587821 Bateman, Robert, of South Elmham, esq 0
4672398 2257019 2257019 defendant Drolle William husbandman 587821 587821 Drolle, William, of South Elmham, husbandman 1
4688067 2261837 2261837 defendant Bysshop Richard husbandman 587821 587821 Bysshop, Richard, of South Elmham, husbandman 0
4722290 2272295 2272295 defendant Bateman Robert esq 587821 587821 Bateman, Robert, of South Elmham, esq 0
4732534 2275349 2275349 defendant Rapere John   587821 587821 Rapere, John, of South Elmham, rope maker 0
4739937 2277569 2277569 defendant Tolle John   587821 587821 Tolle, John, of South Elmham 4
4739946 2277571 2277571 defendant Tolle John   587821 587821 Tolle, John, of South Elmham 1
4746424 2279448 2279448 plaintiff Hemly John   587821 587821 Hemly, John, of South Elmham, on his own account 0
4752018 2281084 2281084 defendant Cambrige John clerk 587821 587821 Cambrige, John, of South Elmham, clerk 6
4785106 2291354 2291354 plaintiff Elmy Thomas   587821 587821 Elmy, Thomas, of South Elmham 0
4805110 2297799 2297799 defendant Baron Thomas yeoman & son of Walter Baron 587821 587821 Baron, Thomas, of South Elmham, yeoman & son of Walter Baron 0
4805502 2297932 2297932 defendant Baron Thomas yeoman & son of Walter Baron 587821 587821 Baron, Thomas, of south elmham, yeoman & son of Walter Baron 0
4805524 2297940 2297940 defendant Buntyng Roger yeoman 587821 587821 Buntyng, Roger, of South Elmham, yeoman 0
4814060 2300502 2300502 defendant Wygge Stephen husbandman 587821 587821 Wygge, Stephen, of South Elmham, husbandman 1
4814061 2300502 2300502 defendant atte Medwe Thomas husbandman 587821 587821 atte Medwe, Thomas, of South Elmham, husbandman 2
4837243 2307593 2307593 defendant Acy John gent 587821 587821 Acy, John, of South Elmham, gent 0
4842606 2309224 2309224 defendant Parker John yeoman 587821 587821 Parker, John, of South Elmham, yeoman 1
4842829 2309296 2309296 defendant Poleyn Alice   587821 587821 Poleyn, Alice, of South Elmham, servant 0
4853604 2312543 2312543 defendant Ourys William yeoman 587821 587821 Ourys, William, of South Elmham, yeoman 1
4853605 2312543 2312543 defendant Bertilmewe John yeoman 587821 587821 Bertilmewe, John, of South Elmham, yeoman 2
4861901 2315100 2315100 plaintiff Damyon John   587821 587821 Damyon, John, of South Elmham 0
4861904 2315100 2315100 defendant Fuller John tailor 587821 587821 Fuller, John, of South Elmham, tailor 2
4864215 2315784 2315784 defendant Acy John gent 587821 587821 Acy, John, of South Elmham, gent 0
4899549 2326498 2326498 defendant Frenssh John yeoman 587821 587821 Frenssh, John, of South Elmham, yeoman 2
4923910 2333918 2333918 defendant Bateman Alice widow 587821 587821 Bateman, Alice, of South Elmham, widow 0
4955882 2343727 2343727 plaintiff Tolle John   587821 587821 Tolle, John, of South Elmham 0
4967465 2347212 2347212 defendant Ditton William husbandman 587821 587821 Ditton, William, of South Elmham, husbandman 0
4980249 2351036 2351036 defendant Wyner or Wyver Walter gent 587821 587821 Wyner or Wyver, Walter, of South Elmham, gent 0
5001365 2357283 2357283 defendant Wymer Walter gent 587821 587821 Wymer, Walter, of South Elmham, gent 0
5007290 2359025 2359025 defendant Orlowe Robert engraver 587821 587821 Orlowe, Robert, of South Elmham, engraver 1
5038298 2368096 2368096 defendant Wymere Walter gent 587821 587821 Wymere, Walter, of South Elmham, gent 0
5055761 2373294 2373294 defendant Edryche James butcher 587821 587821 Edryche, James, of South Elmham, butcher 0
5055765 2373295 2373295 defendant Edryche James butcher 587821 587821 Edryche, James, of South Elmham, butcher 1
5057549 2373827 2373827 defendant Dyghton William yeoman 587821 587821 Dyghton, William, of South Elmham, yeoman 0
5063025 2375474 2375474 defendant Elmy Richard husbandman 587821 587821 Elmy, Richard, of South Elmham, husbandman 0
5063649 2375661 2375661 defendant Smyth Thomas butcher 587821 587821 Smyth, Thomas, of South Elmham St Peter, butcher 2
5098079 2385870 2385870 defendant Couper John husbandman 587821 587821 Couper, John, of South Elmham, husbandman 0
5098080 2385870 2385870 defendant Baron Henry laborer 587821 587821 Baron, Henry, of South Elmham, laborer 1
5103365 2387413 2387413 defendant Wyot Robert husbandman 587821 587821 Wyot, Robert, of South Elmham, husbandman 1
5121277 2392657 2392657 plaintiff Tasburgh John   587821 587821 Tasburgh, John, of South Elmham 0
5124249 2393542 2393542 defendant Smethes Robert yeoman 587821 587821 Smethes, Robert, of South Elmham, yeoman 7
5126167 2394134 2394134 defendant Dyton William husbandman 587821 587821 Dyton, William, of South Elmham, husbandman 0
5140619 2398366 2398366 plaintiff Tasburgh John   587821 587821 Tasburgh, John, of South Elmham 0
5156488 2403054 2403054 defendant Benge Henry yeoman 587821 587821 Benge, Henry, of South Elmham, yeoman 0
5156966 2403178 2403178 defendant Bange or Bauge Henry yeoman 587821 587821 Bange or Bauge, Henry, of South Elmham, yeoman 0
5161752 2404542 2404542 plaintiff Tasburgh John   587821 587821 Tasburgh, John, of South Elmham 0
5173025 2407822 2407822 defendant Bauge Henry yeoman 587821 587821 Bauge, Henry, of South Elmham, yeoman 0
5176043 2408677 2408677 plaintiff Tasburgh John   587821 587821 Tasburgh, John, of South Elmham 0
5185168 2411408 2411408 defendant Hode John laborer 587821 587821 Hode, John, of South Elmham, laborer 0
5185169 2411408 2411408 defendant Groom John weaver 587821 587821 Groom, John, of South Elmham, weaver 1
5192852 2413631 2413631 defendant Bange or Bauge Henry yeoman 587821 587821 Bange or Bauge, Henry, of South Elmham, yeoman 0
5194327 2414073 2414073 plaintiff Puttok Thomas   587821 587821 Puttok, Thomas, of South Elmham, son of Robert 0
5197879 2415117 2415117 plaintiff Tasburgh John   587821 587821 Tasburgh, John, of South Elmham 0
5204671 2417111 2417111 defendant Hode John laborer 587821 587821 together with Hode, John, of South Elmham, laborer 1

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