names

142 rows where place_id = 594580

✎ 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
3597642 1866887 1866887 plaintiff Sariaunt John   594580 594580 Sariaunt, John, of Swafham Market, notary 0
3608389 1870283 1870283 plaintiff Taillour Walter (legal representative) 594580 594580 Taillour, Walter, of Swafham Market, executor of 0
3616671 1872844 1872844 defendant Meer Isabel widow 594580 594580 Meer, Isabel, of Swafham Market, widow 1
3616853 1872901 1872901 defendant Bateman John warrener 594580 594580 Bateman, John, of Swafham Market, warrener 0
3629216 1904006 1904006 plaintiff Cott Edmund   594580 594580 Cott, Edmund, of Swafham Market 0
3638053 1906721 1906721 plaintiff Stwyard Thomas (legal representative) 594580 594580 Stwyard, Thomas, of Swafham Market, gent, executors of 0
3638055 1906721 1906721 plaintiff Payn Walter   594580 594580 Payn, Walter, of Swafham Market 2
3676047 1918543 1918543 defendant Buck Robert   594580 594580 Buck, Robert, of Swafham Market, wool chapman 1
3685143 1921502 1921502 defendant Austyn Walter yeoman 594580 594580 Austyn, Walter, of Swafham Market, yeoman 0
3708910 1929078 1929078 defendant Cotys Joan widow 594580 594580 Cotys, Joan, of Swafham Market, widow 0
3709254 1929191 1929191 defendant Aman John   594580 594580 Aman, John, of Swafham Market, blade smith 0
3715761 1931219 1931219 defendant Bryell Theobald yeoman 594580 594580 Bryell, Theobald, of Swafham Market, yeoman 0
3715762 1931219 1931219 defendant Bukke Robert woolman 594580 594580 Bukke, Robert, of Swafham Market, woolman 1
3716201 1931360 1931360 defendant Mason Thomas (legal representative) 594580 594580 Mason, Thomas, of Swafham Market, merchant, executors of 0
3716203 1931360 1931360 defendant Bosom John capper 594580 594580 Bosom, John, of Swafham Market, capper 2
3721356 1932987 1932987 plaintiff Leman Thomas   594580 594580 Leman, Thomas, of Swafham Market 0
3729241 1935396 1935396 defendant Attmere John husbandman 594580 594580 Attmere, John, of Swafham Market, husbandman 0
3733769 1936814 1936814 defendant Michell William husbandman 594580 594580 Michell, William, of Swafham Market, husbandman 3
3736805 1937762 1937762 defendant at Mere John husbandman 594580 594580 at Mere, John, of Swafham Market, husbandman 0
3736807 1937763 1937763 defendant at Mere John husbandman 594580 594580 at Mere, John, of Swafham Market, husbandman 0
3737301 1937902 1937902 defendant Chapman Robert husbandman 594580 594580 Chapman, Robert, of Swafham Market, husbandman 0
3739376 1938522 1938522 defendant Bere Richard   594580 594580 Bere, Richard, of Swafham Market, shepherd 0
3740142 1938776 1938776 defendant Thurston Henry husbandman 594580 594580 Thurston, Henry, of Swafham Market, husbandman 0
3742241 1939442 1939442 defendant Ymage Simon husbandman 594580 594580 Ymage, Simon, of Swafham Market, husbandman 0
3742467 1939515 1939515 defendant Watton Walter tailor 594580 594580 Watton, Walter, of Swafham Market, tailor 0
3744294 1940113 1940113 defendant Bryan Robert   594580 594580 Bryan, Robert, of Swafham Market, shepherd 2
3744324 1940124 1940124 plaintiff Awdelay John   594580 594580 Awdelay, John, of Swafham Market, knight 0
3747824 1941241 1941241 defendant Levenowe Walter yeoman 594580 594580 Levenowe, Walter, of Swafham Market, yeoman 0
3750338 1942022 1942022 defendant Maunde Richard yeoman 594580 594580 Maunde, Richard, of Swafham Market, yeoman 0
3750540 1942084 1942084 defendant Atmere John husbandman 594580 594580 Atmere, John, of Swafham Market, husbandman 0
3756159 1943884 1943884 defendant Owold John beer brewer 594580 594580 Owold, John, of Swafham Market, beer brewer 0
3799622 1957805 1957805 defendant Bryall Robert barber 594580 594580 Bryall, Robert, of Swafham Market, barber 1
3800233 1957992 1957992 defendant Harpeley John husbandman 594580 594580 Harpeley, John, of Swafham Market, husbandman 0
3800234 1957992 1957992 defendant Watson Thomas haberdasher 594580 594580 Watson, Thomas, of Swafham Market, haberdasher 1
3817777 1963466 1963466 defendant Harpeley John husbandman 594580 594580 Harpeley, John, of Swafham Market, husbandman 0
3817778 1963466 1963466 defendant Watson Thomas haberdasher 594580 594580 Watson, Thomas, of Swafham Market, haberdasher 1
3817780 1963467 1963467 defendant Levenoo Walter husbandman 594580 594580 Levenoo, Walter, of Swafham Market, husbandman 0
3829555 1967134 1967134 defendant Lovelowe Walter yeoman 594580 594580 Lovelowe, Walter, of Swafham Market, yeoman 0
3831175 1967639 1967639 defendant Ede William baker 594580 594580 Ede, William, of Swafham Market, baker 0
3838855 1970079 1970079 plaintiff Waldon John   594580 594580 Waldon, John, of Swafham Market 0
3838859 1970080 1970080 plaintiff Waldon Thomas yeoman 594580 594580 Waldon, Thomas, of Swafham Market, yeoman 0
3841823 1971025 1971025 defendant Payne Thomas gent 594580 594580 Payne, Thomas, of Swafham Market, gent 1
3855237 1975271 1975271 defendant Harpeley John blacksmith 594580 594580 Harpeley, John, of Swafham Market, blacksmith 0
3860902 1977135 1977135 defendant Walter William husbandman 594580 594580 Walter, William, of Swafham Market, husbandman 1
3861792 1977410 1977410 defendant Bytson John husbandman 594580 594580 Bytson, John, of Swafham Market, husbandman 0
3864369 1978279 1978279 defendant Dune Robert husbandman 594580 594580 Dune, Robert, of Swafham Market, husbandman 1
3864961 1978485 1978485 defendant Halle John yeoman 594580 594580 Halle, John, of Swafham Market, yeoman 0
3866149 1978907 1978907 plaintiff Payn Walter (legal representative) 594580 594580 Payn, Walter, of Swafham Market, executor of 0
3867951 1979514 1979514 defendant Mey Thomas   594580 594580 Mey, Thomas, of Swafham Market, shepherd 5
3872555 1981042 1981042 defendant Morell John tanner 594580 594580 Morell, John, of Swafham Market, tanner 0
3895851 1988820 1988820 defendant Walter William warrener 594580 594580 Walter, William, of Swafham Market, warrener 0
3907542 1992819 1992819 defendant Colson Clement laborer 594580 594580 Colson, Clement, of Swafham Market, laborer 0
3907543 1992819 1992819 defendant Chapman Richard laborer 594580 594580 Chapman, Richard, of Swafham Market, laborer 1
3907544 1992819 1992819 defendant Warner alias Erles Thomas laborer 594580 594580 Warner alias Erles, Thomas, of Swafham Market, laborer 2
3907546 1992819 1992819 defendant Aylmer Robert laborer 594580 594580 Aylmer, Robert, of Swafham Market, laborer 4
3907547 1992819 1992819 defendant Anderson John laborer 594580 594580 Anderson, John, of Swafham Market, laborer 5
3907548 1992819 1992819 defendant Mumerye Henry laborer 594580 594580 Mumerye, Henry, of Swafham Market, laborer 6
3948846 2006663 2006663 defendant Myles William (legal representative) 594580 594580 Myles, William, of Swafham Market, sherman, executors of 0
3948848 2006663 2006663 defendant Morell Robert (legal representative) 594580 594580 Morell, Robert, of Swafham Market, tanner, executrix of 2
3948849 2006663 2006663 defendant Morell Elizabeth widow 594580 594580 Morell, Elizabeth, of Swafham Market, widow 3
3953552 2008314 2008314 plaintiff James John singleman 594580 594580 James, John, of Swafham Market, singleman 0
3961117 2010986 2010986 defendant Lewse Henry chapman 594580 594580 Lewse, Henry, of Swafham Market, chapman 0
3961119 2010986 2010986 defendant Walter Julia widow 594580 594580 Walter, Julia, of Swafham Market, widow 2
3961121 2010986 2010986 defendant Mere John laborer 594580 594580 Mere, John, of Swafham Market, laborer 4
3967898 2013400 2013400 plaintiff Canham Robert yeoman 594580 594580 Canham, Robert, of Swafham Market, yeoman 0
4008139 2027675 2027675 defendant Some Edmund merchant 594580 594580 Some, Edmund, of Swafham Market, merchant 1
4485473 2196163 2196163 defendant Pek Geoffrey   594580 594580 Pek, Geoffrey, of Swafham Market, wool man 0
4580257 2225310 2225310 defendant Clerk John   594580 594580 Clerk, John, of Swafham Market, vicar 5
4581138 2225583 2225583 plaintiff Drapere Robert   594580 594580 Drapere, Robert, of Swafham Market 0
4595809 2229944 2229944 plaintiff Robyn John   594580 594580 Robyn, John, of Swafham Market 0
4673362 2257309 2257309 defendant Tolyn John husbandman 594580 594580 Tolyn, John, of Swafham Market, husbandman 0
4717412 2270784 2270784 defendant Taverner John husbandman 594580 594580 Taverner, John, of Swafham Market, husbandman 0
4734019 2275825 2275825 defendant Gobbe alias Draper Richard yeoman 594580 594580 Gobbe alias Draper, Richard, of Swafham Market, yeoman 0
4736112 2276430 2276430 defendant Foyke William yeoman 594580 594580 Foyke, William, of Swafham Market, yeoman 8
4738366 2277095 2277095 defendant Baxster Henry yeoman 594580 594580 Baxster, Henry, of Swafham Market, yeoman 2
4745849 2279290 2279290 defendant Roo Nicholas husbandman 594580 594580 Roo, Nicholas, of Swafham Market, husbandman 0
4752242 2281126 2281126 defendant Lobbe Thomas yeoman 594580 594580 Lobbe, Thomas, of Swafham Market, yeoman 0
4833048 2306354 2306354 defendant Neweman Richard yeoman 594580 594580 Neweman, Richard, of Swafham Market, yeoman 4
4949970 2341960 2341960 defendant Lobbe William husbandman 594580 594580 Lobbe, William, of Swafham Market, husbandman 0
4954601 2343333 2343333 defendant Brunton Nicholas yeoman 594580 594580 Brunton, Nicholas, of Swafham Market, yeoman 3
4959123 2344698 2344698 defendant Brunton Nicholas yeoman 594580 594580 Brunton, Nicholas, of Swafham Market, yeoman 0
5003475 2357913 2357913 defendant Styward Thomas gent 594580 594580 Styward, Thomas, of Swafham market, gent 0
5019538 2362600 2362600 defendant Greswell Simon yeoman 594580 594580 Greswell, Simon, of Swafham Market, yeoman 0
5019539 2362600 2362600 defendant Langman John yeoman 594580 594580 Langman, John, of Swafham Market, yeoman 1
5019540 2362600 2362600 defendant Notyngham John yeoman 594580 594580 Notyngham, John, of Swafham Market, yeoman 2
5019542 2362601 2362601 defendant Gryswell Nicholas yeoman 594580 594580 Gryswell, Nicholas, of Swafham Market, yeoman 0
5019543 2362601 2362601 defendant Clerk Simon yeoman 594580 594580 Clerk, Simon, of Swafham Market, yeoman 1
5019544 2362601 2362601 defendant Langman John yeoman 594580 594580 Langman, John, of Swafham Market, yeoman 2
5130438 2395392 2395392 defendant Candeler Lawrence   594580 594580 Candeler, Lawrence, of Swafham market 2
5149804 2401079 2401079 defendant Caudeler Lawrence tailor 594580 594580 Caudeler, Lawrence, of Swafham Market, tailor 2
5160760 2404244 2404244 defendant Fyssher John husbandman 594580 594580 Fyssher, John, of Swafham Market, husbandman 2
5168607 2406539 2406539 defendant Caudeler Lawrence tailor 594580 594580 Caudeler, Lawrence, of Swafham Market, tailor 2
5175454 2408511 2408511 defendant Fyssher John husbandman 594580 594580 Fyssher, John, of Swafham Market, husbandman 2
5184614 2411247 2411247 defendant Caudeler Lawrence tailor 594580 594580 Caudeler, Lawrence, of Swafham Market, tailor 2
5196663 2414777 2414777 defendant Fissher John husbandman 594580 594580 Fissher, John, of Swafham Market, husbandman 2
5196704 2414785 2414785 defendant Fyssher John husbandman 594580 594580 Fyssher, John, of Swafham Market, husbandman 2
5253079 2431069 2431069 defendant Lytster Edmund sherman 594580 594580 Lytster, Edmund, of Swafham Market, sherman 2
5293497 2443068 2443068 defendant Blake Elizabeth widow 594580 594580 Blake, Elizabeth, of Swafham Market, widow 2
5314241 2449275 2449275 defendant Bryston John tanner 594580 594580 Bryston, John, of Swafham Market, tanner 0
5314628 2449409 2449409 defendant Bateman John husbandman 594580 594580 Bateman, John, of Swafham Market, husbandman 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);