names

536 rows where place_id = 587166

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590642 1864715 1864715 defendant Gedge Philip husbandman 587166 587166 Gedge, Philip, of Salle, husbandman 1
3597512 1866845 1866845 plaintiff Ryghtwyse Thomas (legal representative) 587166 587166 Ryghtwyse, Thomas, of Salle, executors of 0
3597518 1866846 1866846 plaintiff Ryghtwyse Thomas (legal representative) 587166 587166 Ryghtwyse, Thomas, of Salle, executors of 0
3603207 1868670 1868670 defendant Laverok John yeoman 587166 587166 Laverok, John, of Salle, yeoman 0
3603419 1868739 1868739 defendant Laverok John yeoman 587166 587166 Laverok, John, of Salle, yeoman 8
3603655 1868812 1868812 defendant Laverok John chapman 587166 587166 Laverok, John, of Salle, chapman 0
3605412 1869359 1869359 defendant Founteyn John husbandman 587166 587166 Founteyn, John, of Salle, husbandman 0
3605886 1869506 1869506 defendant Cady Geoffrey yeoman 587166 587166 Cady, Geoffrey, of Salle, yeoman 0
3609360 1870587 1870587 defendant Laverok John yeoman 587166 587166 Laverok, John, of Salle, yeoman 0
3614904 1872315 1872315 defendant Laverok John yeoman 587166 587166 Laverok, John, of Salle, yeoman 0
3614906 1872315 1872315 defendant Gedde Philip husbandman 587166 587166 Gedde, Philip, of Salle, husbandman 2
3617835 1873202 1873202 defendant Grewe John husbandman 587166 587166 Grewe, John, of Salle, husbandman 0
3619106 1873578 1873578 defendant Davy Edmund yeoman 587166 587166 Davy, Edmund, of Salle, yeoman 0
3619108 1873578 1873578 defendant Brygge George gent 587166 587166 Brygge, George, of Salle, gent 2
3645508 1908995 1908995 defendant Coleys Robert yeoman 587166 587166 Coleys, Robert, of Salle, yeoman 4
3650252 1910451 1910451 defendant Orlowe John yeoman 587166 587166 Orlowe, John, of Salle, yeoman 0
3650254 1910452 1910452 defendant Funteyn John yeoman 587166 587166 Funteyn, John, of Salle, yeoman 0
3656427 1912254 1912254 defendant Wodehowse Jeremy yeoman 587166 587166 Wodehowse, Jeremy, of Salle, yeoman 0
3656428 1912254 1912254 defendant Bowre Robert husbandman 587166 587166 Bowre, Robert, of Salle, husbandman 1
3656429 1912254 1912254 defendant Warde John husbandman 587166 587166 Warde, John, of Salle, husbandman 2
3715260 1931058 1931058 defendant Crome James   587166 587166 Crome, James, of Salle, worsted weaver 0
3744493 1940179 1940179 defendant Bonde Henry husbandman 587166 587166 Bonde, Henry, of Salle, husbandman 2
3776296 1950332 1950332 defendant Crome James   587166 587166 Crome, James, of Salle, worsted weaver 0
3780429 1951613 1951613 defendant Bowre Richard husbandman 587166 587166 Bowre, Richard, of Salle, husbandman 2
3796712 1956859 1956859 defendant Stone Richard   587166 587166 Stone, Richard, of Salle, notary 0
3830306 1967372 1967372 defendant Stone Richard gent 587166 587166 Stone, Richard, of Salle, gent 0
3863744 1978052 1978052 defendant Funteyn John mercer 587166 587166 Funteyn, John, of Salle, mercer 0
3863753 1978053 1978053 defendant Funteyn John mercer 587166 587166 Funteyn, John, of Salle, mercer 0
3877021 1982556 1982556 plaintiff Hemblyng Richard   587166 587166 Hemblyng, Richard, of Salle, worsted weaver 0
3877023 1982556 1982556 defendant Suffeld William   587166 587166 Suffeld, William, of Salle, worsted weaver 1
3880689 1983806 1983806 defendant Harpour Robert husbandman 587166 587166 Harpour, Robert, of Salle, husbandman 0
3881837 1984178 1984178 defendant Morsse Thomas laborer 587166 587166 Morsse, Thomas, of Salle, laborer 0
3893760 1988131 1988131 defendant Bevys Richard laborer 587166 587166 Bevys, Richard, of Salle, laborer 2
3898500 1989712 1989712 defendant Smyth Thomas gent 587166 587166 Smyth, Thomas, of Salle, gent 0
3898501 1989712 1989712 defendant Marsham Edward   587166 587166 Marsham, Edward, of Salle, worsted weaver 1
3898508 1989714 1989714 defendant Marsham Edward   587166 587166 Marsham, Edward, of Salle, worsted weaver 1
3906618 1992507 1992507 defendant Brygges John gent 587166 587166 Brygges, John, of Salle, gent 1
3908230 1993051 1993051 defendant Funteyn Christopher husbandman 587166 587166 Funteyn, Christopher, of Salle, husbandman 1
3917510 1996213 1996213 defendant Ryx John husbandman 587166 587166 Ryx, John, of Salle, husbandman 2
3922082 1997715 1997715 defendant Chapman Robert   587166 587166 Chapman, Robert, of Salle, worsted weaver 1
3927668 1999591 1999591 defendant Dey James yeoman 587166 587166 Dey, James, of Salle, yeoman 0
3967931 2013412 2013412 defendant Hill Thomas husbandman 587166 587166 Hill, Thomas, of Salle, husbandman 0
4009359 2028113 2028113 defendant Payne William tanner 587166 587166 Payne, William, of Salle, tanner 0
4033127 2036496 2036496 defendant Sendall Robert yeoman 587166 587166 Sendall, Robert, of Salle, yeoman 0
4069365 2049327 2049327 defendant Stanhawe Edward gent 587166 587166 Stanhawe, Edward, of Salle, or of Alderford, gent 0
4070938 2049904 2049904 defendant Tyller John cooper 587166 587166 Tyller, John, of Salle, cooper 1
4114524 2065483 2065483 defendant Fyske Francis laborer 587166 587166 Fyske, Francis, of Salle, laborer 0
4114525 2065483 2065483 defendant Belton Thomas husbandman 587166 587166 Belton, Thomas, of Salle, husbandman 1
4114527 2065483 2065483 defendant Alleyns Robert husbandman 587166 587166 Alleyns, Robert, of Salle, husbandman 3
4224317 2103990 2103990 defendant Beccles Robert husbandman 587166 587166 Beccles, Robert, of Salle, husbandman 0
4285734 2124949 2124949 defendant Babthorp John laborer 587166 587166 Babthorp, John, of Salle, laborer 0
4324584 2138613 2138613 defendant Beales Robert yeoman 587166 587166 Beales, Robert, of Salle, yeoman 2
4326151 2139115 2139115 defendant Freman Robert laborer 587166 587166 Freman, Robert, of Salle, laborer 3
4388968 2160942 2160942 defendant Briggs George husbandman 587166 587166 Briggs, George, of Salle, husbandman 0
4389436 2161093 2161093 defendant Briggs George husbandman 587166 587166 Briggs, George, of Salle, husbandman 0
4391026 2161617 2161617 defendant Sendall Robert yeoman 587166 587166 Sendall, Robert, of Salle, yeoman 2
4411458 2168421 2168421 defendant Moore Samuel cordwainer 587166 587166 Moore, Samuel, of Salle, cordwainer 3
4414993 2169584 2169584 defendant atte Brigge Roger chaplain 587166 587166 atte Brigge, Roger, of Salle, chaplain 1
4414996 2169585 2169585 defendant atte Brigge Roger chaplain 587166 587166 atte Brigge, Roger, of Salle, chaplain 1
4422974 2172042 2172042 defendant atte Brigge Roger chaplain 587166 587166 atte Brigge, Roger, of Salle, chaplain 1
4444552 2183271 2183271 defendant Dullyng John de   587166 587166 Dullyng, John de, of Salle 0
4445365 2183499 2183499 plaintiff Crakesloth Giles   587166 587166 Crakesloth, Giles, of Salle 0
4445705 2183610 2183610 defendant Garr John   587166 587166 Garr, John, of Salle 12
4451583 2185466 2185466 plaintiff Bolyn Thomas   587166 587166 Bolyn, Thomas, of Salle 2
4452320 2185714 2185714 defendant atte Brigge John   587166 587166 atte Brigge, John, of Salle, senior 0
4452321 2185714 2185714 defendant atte Brigge John   587166 587166 atte Brigge, John, of Salle, servant of John atte Brigge 1
4454017 2186268 2186268 defendant Whaplode Thomas   587166 587166 Whaplode, Thomas, of Salle 14
4454363 2186381 2186381 defendant atte Kychyn Robert   587166 587166 atte Kychyn, Robert, of Salle 2
4463548 2189293 2189293 plaintiff Umfrey Adam   587166 587166 Umfrey, Adam, of Salle 0
4463852 2189371 2189371 plaintiff Vyby Adam   587166 587166 Vyby, Adam, of Salle 0
4464996 2189711 2189711 defendant Kyng John   587166 587166 Kyng, John, of Salle, son of Richard 23
4494878 2199084 2199084 plaintiff Brond William   587166 587166 Brond, William, of Salle, on his own account 0
4504502 2201965 2201965 defendant Boleyn Thomas   587166 587166 Boleyn, Thomas, of Salle 2
4540341 2212877 2212877 plaintiff Bisshop Giles   587166 587166 Bisshop, Giles, of Salle 2
4540811 2213033 2213033 defendant Smyth Thomas   587166 587166 Smyth, Thomas, of Salle 0
4543330 2213799 2213799 defendant Alwyngham Richard   587166 587166 Alwyngham, Richard, of Salle 1
4547123 2215034 2215034 defendant Ulfe John carpenter 587166 587166 Ulfe, John, of Salle, carpenter 0
4547719 2215225 2215225 plaintiff Careweye Richard   587166 587166 Careweye, Richard, of Salle 0
4555967 2217807 2217807 plaintiff Holewey John (legal representative) 587166 587166 Holewey, John, of Salle, parson, executors of 0
4555972 2217808 2217808 plaintiff Holeweye John (legal representative) 587166 587166 Holeweye, John, of Salle, parson, executors of 0
4559179 2218823 2218823 defendant Rook Adam   587166 587166 Rook, Adam, of Salle 3
4565456 2220767 2220767 plaintiff Smyth Richard   587166 587166 Smyth, Richard, of Salle 0
4567282 2221324 2221324 defendant Hoddys Walter   587166 587166 Hoddys, Walter, of Salle 0
4567593 2221430 2221430 defendant Fendy John   587166 587166 Fendy, John, of Salle 0
4618036 2236651 2236651 defendant Kittysson John   587166 587166 Kittysson, John, of Salle 0
4618037 2236651 2236651 defendant Clerke William   587166 587166 Clerke, William, of Salle 1
4619617 2237126 2237126 plaintiff Holweye John (legal representative) 587166 587166 Holweye, John, of Salle, formerly parson, executors of 0
4619627 2237127 2237127 plaintiff Holweye John (legal representative) 587166 587166 Holweye, John, of Salle, parson, executors of 0
4619634 2237128 2237128 plaintiff Holweye John (legal representative) 587166 587166 Holweye, John, of Salle, parson, executors of 0
4623239 2238242 2238242 defendant Grond William   587166 587166 Grond, William, of Salle 0
4624773 2238728 2238728 defendant Rok William chapman 587166 587166 Rok, William, of Salle, chapman 0
4630701 2240501 2240501 defendant Cullyng William   587166 587166 Cullyng, William, of Salle 8
4633218 2241258 2241258 defendant Rook William   587166 587166 Rook, William, of Salle 5
4639757 2243135 2243135 defendant Boure John   587166 587166 Boure, John, of Salle, corsour 0
4639983 2243198 2243198 defendant Noble Robert   587166 587166 Noble, Robert, of Salle 3
4647992 2245480 2245480 defendant Boure John   587166 587166 Boure, John, of Salle 0
4649756 2245952 2245952 defendant Brigge John   587166 587166 Brigge, John, of Salle 0
4649757 2245952 2245952 defendant Rook Thomas   587166 587166 Rook, Thomas, of Salle 1
4653647 2247068 2247068 plaintiff Benhale John   587166 587166 Benhale, John, of Salle 0
4654962 2247435 2247435 defendant Dallyng Thomas husbandman 587166 587166 Dallyng, Thomas, of Salle, 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);