names

69 rows where place_id = 595176

✎ 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
3619244 1873621 1873621 defendant Lyffe William husbandman 595176 595176 Lyffe, William, of Hunstanton, husbandman 0
3619259 1873626 1873626 defendant Lyffe William husbandman 595176 595176 Lyffe, William, of Hunstanton, husbandman 0
3668889 1916201 1916201 defendant Corbett William yeoman 595176 595176 Corbett, William, of Hunstanton, yeoman 0
3680691 1920041 1920041 defendant Spencer Edward yeoman 595176 595176 Spencer, Edward, of Hunstanton, yeoman 0
3680692 1920041 1920041 defendant Rede Robert husbandman 595176 595176 Rede, Robert, of Hunstanton, husbandman 1
3692391 1923796 1923796 plaintiff John David yeoman 595176 595176 John, David, of Hunstanton, yeoman 0
3692955 1923997 1923997 plaintiff Lestrange Thomas esq 595176 595176 Lestrange, Thomas, of Hunstanton, esq 0
3729926 1935615 1935615 defendant Spencer Edward husbandman 595176 595176 Spencer, Edward, of Hunstanton, husbandman 0
3766925 1947320 1947320 defendant Spencer Edward husbandman 595176 595176 Spencer, Edward, of Hunstanton, husbandman 0
3890983 1987247 1987247 plaintiff Johns David (legal representative) 595176 595176 Johns, David, of Hunstanton, executrix of 0
3890987 1987248 1987248 plaintiff Johns David (legal representative) 595176 595176 Johns, David, of Hunstanton, executrix of 0
3918971 1996667 1996667 plaintiff Johans David (legal representative) 595176 595176 Johans, David, of Hunstanton, executrix of 0
3918975 1996668 1996668 plaintiff Johans Thomas gent 595176 595176 Johans, Thomas, of Hunstanton, gent 0
3967318 2013199 2013199 defendant Lestraunge Nicholas   595176 595176 Lestraunge, Nicholas, of Hunstanton, or of Hechin, Norf, knight 0
3977356 2016650 2016650 plaintiff Lestraunge Robert gent 595176 595176 Lestraunge, Robert, of Hunstanton, gent 0
4003752 2026109 2026109 defendant Holdenby Thomas yeoman 595176 595176 Holdenby, Thomas, of Hunstanton, yeoman 0
4021321 2032350 2032350 defendant Holdenbye Thomas yeoman 595176 595176 Holdenbye, Thomas, of Hunstanton, yeoman 0
4032506 2036272 2036272 defendant Lestraunge Nicholas   595176 595176 Lestraunge, Nicholas, of Hunstanton, knight 0
4032508 2036273 2036273 defendant Lestraunge Nicholas   595176 595176 Lestraunge, Nicholas, of Hunstanton, knight 0
4063895 2047369 2047369 defendant Skey Reginald husbandman 595176 595176 Skey, Reginald, of Hunstanton, husbandman 0
4070528 2049753 2049753 plaintiff Mason Thomas yeoman 595176 595176 Mason, Thomas, of Hunstanton, yeoman 0
4190206 2092081 2092081 defendant Holdenbye Thomas yeoman 595176 595176 Holdenbye, Thomas, of Hunstanton, yeoman 0
4190404 2092182 2092182 defendant Holdenay Thomas yeoman 595176 595176 Holdenay, Thomas, of Hunstanton, yeoman 0
4243931 2110950 2110950 defendant Grey Firmun yeoman 595176 595176 Grey, Firmun, of Hunstanton, yeoman 1
4243934 2110951 2110951 defendant Grey Firmun yeoman 595176 595176 Grey, Firmun, of Hunstanton, yeoman 1
4247593 2112179 2112179 defendant Gray Firmun gent 595176 595176 Gray, Firmun, of Hunstanton, gent 1
4248739 2112564 2112564 defendant Holdenby Thomas yeoman 595176 595176 Holdenby, Thomas, of Hunstanton, yeoman 1
4248744 2112565 2112565 defendant Holdenby Thomas yeoman 595176 595176 Holdenby, Thomas, of Hunstanton, yeoman 1
4286910 2125371 2125371 defendant Holdenbye John yeoman 595176 595176 Holdenbye, John, of Hunstanton, yeoman 3
4291319 2126968 2126968 defendant Lestrange Nicholas (legal representative) 595176 595176 Lestrange, Nicholas, of Hunstanton, knight, executors of 0
4291322 2126968 2126968 defendant Spelman Henry gent 595176 595176 Spelman, Henry, of Hunstanton, gent 3
4337986 2143028 2143028 defendant Spryngold John weaver 595176 595176 Spryngold, John, of Hunstanton, weaver 0
4340492 2143940 2143940 defendant Spelman Henry gent 595176 595176 Spelman, Henry, of Hunstanton, gent 3
4575879 2223943 2223943 defendant Robinsson Thomas   595176 595176 Robinsson, Thomas, of Hunstanton 2
4575883 2223944 2223944 defendant Robinesson Thomas   595176 595176 Robinesson, Thomas, of Hunstanton 0
4605783 2232923 2232923 defendant Dru Walter   595176 595176 Dru, Walter, of Hunstanton 2
4655654 2247651 2247651 defendant Peddere William fisher 595176 595176 Peddere, William, of Hunstanton, fisher 3
4676717 2258338 2258338 defendant Jake Margaret spinster 595176 595176 Jake, Margaret, of Hunstanton, spinster 0
4676718 2258338 2258338 defendant Crane John yeoman 595176 595176 Crane, John, of Hunstanton, yeoman 1
4733624 2275695 2275695 defendant Crampe John yeoman 595176 595176 Crampe, John, of Hunstanton, yeoman 0
4764995 2285026 2285026 defendant Ferrour John yeoman 595176 595176 Ferrour, John, of Hunstanton, yeoman 4
4789097 2292645 2292645 defendant Ferrour or Smith John yeoman 595176 595176 Ferrour or Smith, John, of Hunstanton, yeoman 4
4809746 2299211 2299211 defendant Asterby William husbandman 595176 595176 Asterby, William, of hUnstanton, husbandman 0
4831226 2305795 2305795 defendant Peddere William yeoman 595176 595176 Peddere, William, of Hunstanton, yeoman 0
4956294 2343844 2343844 defendant Spencer Edward husbandman 595176 595176 Spencer, Edward, of Hunstanton, husbandman 0
5230436 2424518 2424518 defendant Pedder John husbandman 595176 595176 Pedder, John, of Hunstanton, husbandman 0
5230440 2424519 2424519 defendant Inglond John yeoman 595176 595176 Inglond, John, of Hunstanton, yeoman 2
5295382 2443639 2443639 defendant Broun John husbandman 595176 595176 Broun, John, of Hunstanton, husbandman 0
5315382 2449659 2449659 defendant Grave Thomas gent 595176 595176 Grave, Thomas, of Hunstanton, gent 0
5320516 2451222 2451222 defendant Tompson Robert yeoman 595176 595176 Tompson, Robert, of Hunstanton, yeoman 0
5330986 2454332 2454332 defendant Grave Thomas yeoman 595176 595176 Grave, Thomas, of Hunstanton, yeoman 0
5330988 2454333 2454333 defendant Grave Thomas yeoman 595176 595176 Grave, Thomas, of Hunstanton, yeoman 0
5345331 2458713 2458713 plaintiff Werbes William   595176 595176 Werbes, William, of Hunstanton 0
5377989 2468695 2468695 defendant Grave or Grane Thomas yeoman 595176 595176 Grave or Grane, Thomas, of Hunstanton, yeoman 0
5394198 2473402 2473402 defendant Grave Thomas yeoman 595176 595176 Grave, Thomas, of Hunstanton, yeoman 0
5399844 2475047 2475047 defendant Grave Thomas yeoman 595176 595176 Grave, Thomas, of Hunstanton, yeoman 0
5401945 2475614 2475614 defendant Spencer Edward (legal representative) 595176 595176 Spencer, Edward, of Hunstanton, yeoman, executor of 13
5401946 2475614 2475614 defendant Spencer John husbandman 595176 595176 Spencer, John, of Hunstanton, husbandman 14
5412885 2478803 2478803 defendant Barker Robert yeoman 595176 595176 Barker, Robert, of Hunstanton, yeoman 0
5414860 2479374 2479374 defendant Spencer Edward (legal representative) 595176 595176 Spencer, Edward, of Hunstanton, yeoman, executor of 13
5414861 2479374 2479374 defendant Spencer John   595176 595176 Spencer, John, of Hunstanton 14
5442136 2487565 2487565 defendant Spencer Edward (legal representative) 595176 595176 Spencer, Edward, of Hunstanton, yeoman, executor of 3
5452656 2490678 2490678 defendant Brane Thomas yeoman 595176 595176 Brane, Thomas, of Hunstanton, yeoman 1
5454877 2491377 2491377 defendant Spencer John yeoman 595176 595176 Spencer, John, of Hunstanton, yeoman 4
5464599 2494330 2494330 defendant Grane Thomas yeoman 595176 595176 Grane, Thomas, of Hunstanton, yeoman 0
5496083 2503722 2503722 defendant Grave John husbandman 595176 595176 Grave, John, of Hunstanton, husbandman 0
5496084 2503722 2503722 defendant Warboys William mariner 595176 595176 Warboys, William, of Hunstanton, mariner 1
5504898 2506448 2506448 defendant Grave John husbandman 595176 595176 Grave, John, of Hunstanton, husbandman 0
5587623 2531148 2531148 plaintiff Neell William (legal representative) 595176 595176 Neell, William, of Hunstanton, gent, executors of 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);