names

144 rows where place_id = 587156

✎ 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
3590620 1864708 1864708 defendant Drake John husbandman 587156 587156 Drake, John, of Lamerton, husbandman 0
3590621 1864708 1864708 defendant Fursman Peter husbandman 587156 587156 Fursman, Peter, of Lamerton, husbandman 1
3632912 1905110 1905110 defendant Parre John yeoman 587156 587156 Parre, John, of Lamerton, yeoman 0
3639721 1907231 1907231 defendant Par John husbandman 587156 587156 Par, John, of Lamerton, husbandman 1
3640154 1907366 1907366 defendant Parre John yeoman 587156 587156 Parre, John, of Lamerton, yeoman 5
3649339 1910185 1910185 defendant Glubbe William husbandman 587156 587156 Glubbe, William, of Lamerton, husbandman 0
3669661 1916450 1916450 defendant Par John yeoman 587156 587156 Par, John, of Lamerton, yeoman 1
3671982 1917238 1917238 defendant Hill Thomas husbandman 587156 587156 Hill, Thomas, of Lamerton, husbandman 0
3671983 1917238 1917238 defendant Hill John husbandman 587156 587156 Hill, John, of Lamerton, husbandman 1
3671984 1917238 1917238 defendant Hill William husbandman 587156 587156 Hill, William, of Lamerton, husbandman 2
3672905 1917539 1917539 defendant Furseman Peter husbandman 587156 587156 Furseman, Peter, of Lamerton, husbandman 0
3673910 1917875 1917875 defendant Parre John yeoman 587156 587156 Parre, John, of Lamerton, yeoman 0
3680811 1920080 1920080 defendant Hyll Thomas husbandman 587156 587156 Hyll, Thomas, of Lamerton, husbandman 0
3680812 1920080 1920080 defendant Hyll John husbandman 587156 587156 Hyll, John, of Lamerton, husbandman 1
3680813 1920080 1920080 defendant Hyll William   587156 587156 Hyll, William, of Lamerton, groom 2
3684545 1921299 1921299 defendant Parre John yeoman 587156 587156 Parre, John, of Lamerton, yeoman 0
3689854 1922985 1922985 defendant Denmer Thomas husbandman 587156 587156 Denmer, Thomas, of Lamerton, husbandman 3
3689855 1922985 1922985 defendant Roger Thomas husbandman 587156 587156 Roger, Thomas, of Lamerton, husbandman 4
3689856 1922985 1922985 defendant Yowell Thomas husbandman 587156 587156 Yowell, Thomas, of Lamerton, husbandman 5
3704323 1927653 1927653 defendant Denmer Thomas husbandman 587156 587156 Denmer, Thomas, of Lamerton, husbandman 3
3704324 1927653 1927653 defendant Roger Thomas husbandman 587156 587156 Roger, Thomas, of Lamerton, husbandman 4
3704325 1927653 1927653 defendant Yowell Thomas husbandman 587156 587156 Yowell, Thomas, of Lamerton, husbandman 5
3709930 1929420 1929420 defendant Kyngdon Walter clerk 587156 587156 Kyngdon, Walter, of Lamerton, clerk 0
3709932 1929420 1929420 defendant Dowe Walter laborer 587156 587156 Dowe, Walter, of Lamerton, laborer 2
3719640 1932411 1932411 defendant Burneford John husbandman 587156 587156 Burneford, John, of Lamerton, husbandman 0
3723943 1933768 1933768 defendant Parre John yeoman 587156 587156 Parre, John, of Lamerton, yeoman 0
3728775 1935244 1935244 defendant Burneford John husbandman 587156 587156 Burneford, John, of Lamerton, husbandman 0
3734234 1936948 1936948 defendant Parre John yeoman 587156 587156 Parre, John, of Lamerton, yeoman 0
3735415 1937314 1937314 defendant Burneford John husbandman 587156 587156 Burneford, John, of Lamerton, husbandman 0
3739786 1938657 1938657 defendant Parre John yeoman 587156 587156 Parre, John, of Lamerton, yeoman 0
3741884 1939326 1939326 defendant Sprye Robert chaplain 587156 587156 Sprye, Robert, of Lamerton, chaplain 0
3745669 1940553 1940553 defendant Parre John yeoman 587156 587156 Parre, John, of Lamerton, yeoman 1
3748025 1941302 1941302 defendant Parre John yeoman 587156 587156 Parre, John, of Lamerton, yeoman 0
3761839 1945711 1945711 defendant Hyll William husbandman 587156 587156 Hyll, William, of Lamerton, husbandman 0
3791108 1955054 1955054 defendant Tolle John husbandman 587156 587156 Tolle, John, of Lamerton, husbandman 0
3835445 1969024 1969024 defendant Sachefeld William, senior yeoman 587156 587156 Sachefeld, William, senior, of Lamerton, yeoman 0
3862605 1977688 1977688 defendant Knapman William husbandman 587156 587156 Knapman, William, of Lamerton, husbandman 0
3862606 1977688 1977688 defendant Furssheman Nicholas husbandman 587156 587156 Furssheman, Nicholas, of Lamerton, husbandman 1
3862607 1977688 1977688 defendant Furssheman John husbandman 587156 587156 Furssheman, John, of Lamerton, husbandman 2
3862609 1977688 1977688 defendant Guscott John husbandman 587156 587156 Guscott, John, of Lamerton, husbandman 4
3862610 1977688 1977688 defendant Lowley John husbandman 587156 587156 Lowley, John, of Lamerton, husbandman 5
3876855 1982500 1982500 defendant Guscott John husbandman 587156 587156 Guscott, John, of Lamerton, husbandman 1
3876856 1982500 1982500 defendant Knapman William husbandman 587156 587156 Knapman, William, of Lamerton, husbandman 2
3876857 1982500 1982500 defendant Furssheman Nicholas husbandman 587156 587156 Furssheman, Nicholas, of Lamerton, husbandman 3
3876858 1982500 1982500 defendant Furssheman John husbandman 587156 587156 Furssheman, John, of Lamerton, husbandman 4
3876859 1982500 1982500 defendant Lowley John husbandman 587156 587156 Lowley, John, of Lamerton, husbandman 5
3879320 1983335 1983335 defendant Drake Nicholas husbandman 587156 587156 Drake, Nicholas, of Lamerton, husbandman 1
3884348 1985033 1985033 defendant Tolle Thomas husbandman 587156 587156 Tolle, Thomas, of Lamerton, husbandman 0
3884350 1985034 1985034 defendant Tolle Thomas husbandman 587156 587156 Tolle, Thomas, of Lamerton, husbandman 0
3914136 1995074 1995074 defendant Hawkyns Henry clerk 587156 587156 Hawkyns, Henry, of Lamerton, clerk 0
3938590 2003250 2003250 defendant Randall Thomas husbandman 587156 587156 Randall, Thomas, of Lamerton, husbandman 0
4041663 2039509 2039509 defendant Drake Henry yeoman 587156 587156 Drake, Henry, of Lamerton, yeoman 5
4056111 2044574 2044574 defendant Sachefeld Thomas yeoman 587156 587156 Sachefeld, Thomas, of Lamerton, yeoman 0
4056112 2044574 2044574 defendant Baselye John miller 587156 587156 Baselye, John, of Lamerton, miller 1
4056113 2044574 2044574 defendant Rundeck Philip husbandman 587156 587156 Rundeck, Philip, of Lamerton, husbandman 2
4109181 2063537 2063537 defendant Palmer John yeoman 587156 587156 Palmer, John, of Lamerton, yeoman 0
4109183 2063538 2063538 defendant Palmer John yeoman 587156 587156 Palmer, John, of Lamerton, yeoman 0
4109203 2063548 2063548 defendant Palmer John yeoman 587156 587156 Palmer, John, of Lamerton, yeoman 0
4303907 2131499 2131499 defendant Englett Giles gent 587156 587156 Englett, Giles, of Lamerton, gent 0
4308967 2133290 2133290 defendant Englett Giles gent 587156 587156 Englett, Giles, of Lamerton, gent 0
4313973 2134993 2134993 defendant Palmer John   587156 587156 Palmer, John, of Lamerton yeoman 0
4313974 2134993 2134993 defendant Charde alias Toll John husbandman 587156 587156 Charde alias Toll, John, of Lamerton, husbandman 1
4352416 2148084 2148084 defendant Beallye Roger husbandman 587156 587156 Beallye, Roger, of Lamerton, husbandman 0
4352418 2148085 2148085 defendant Beallye Roger husbandman 587156 587156 Beallye, Roger, of Lamerton, husbandman 0
4481487 2194905 2194905 plaintiff Lychefeld William   587156 587156 Lychefeld, William, of Lamerton, vicar 0
4481489 2194906 2194906 plaintiff Lychefeld William   587156 587156 Lychefeld, William, of Lamerton, vicar 0
4481492 2194907 2194907 plaintiff Lychefeld William   587156 587156 Lychefeld, William, of Lamerton, vicar 0
4590909 2228509 2228509 defendant Peper Mark   587156 587156 Peper, Mark, of Lamerton 0
4698854 2265123 2265123 defendant Milemete John laborer 587156 587156 Milemete, John, of Lamerton, laborer 1
4710408 2268609 2268609 defendant Drake William husbandman 587156 587156 Drake, William, of Lamerton, husbandman 0
4710409 2268609 2268609 defendant Roube John husbandman 587156 587156 Roube, John, of Lamerton, husbandman 1
4710410 2268609 2268609 defendant Drake Reginald laborer 587156 587156 Drake, Reginald, of Lamerton, laborer 2
4854070 2312682 2312682 defendant Harry John gent 587156 587156 Harry, John, of Lamerton, gent 0
4897656 2325932 2325932 plaintiff Harry John   587156 587156 Harry, John, of Lamerton 1
4897657 2325932 2325932 defendant Pipere Richard husbandman 587156 587156 Pipere, Richard, of Lamerton, husbandman 0
4897747 2325963 2325963 plaintiff Tolle John   587156 587156 Tolle, John, of Lamerton 0
4920687 2332984 2332984 defendant Maynard Walter husbandman 587156 587156 Maynard, Walter, of Lamerton, husbandman 4
4978315 2350463 2350463 defendant Chubbe William laborer 587156 587156 Chubbe, William, of Lamerton, laborer 0
4991406 2354315 2354315 defendant Harry John esq 587156 587156 Harry, John, of Lamerton, esq 0
5009124 2359551 2359551 plaintiff Tolle John, sen   587156 587156 Tolle, John, sen, of Lamerton 0
5086078 2382320 2382320 defendant Ruby John husbandman 587156 587156 Ruby, John, of Lamerton, husbandman 0
5086079 2382320 2382320 defendant Ruby Robert   587156 587156 Ruby, Robert, of Lamerton, groom 1
5111822 2389848 2389848 defendant Ruby John husbandman 587156 587156 Ruby, John, of Lamerton, husbandman 4
5111823 2389848 2389848 defendant Chepman John husbandman 587156 587156 Chepman, John, of Lamerton, husbandman 5
5111824 2389848 2389848 defendant Lake John yeoman 587156 587156 Lake, John, of Lamerton, yeoman 6
5111825 2389848 2389848 defendant Colyn Richard yeoman 587156 587156 Colyn, Richard, of Lamerton, yeoman 7
5111826 2389848 2389848 defendant Cole Jordan   587156 587156 Cole, Jordan, of Lamerton, mason 8
5121989 2392848 2392848 defendant Penteny John yeoman 587156 587156 Penteny, John, of Lamerton, yeoman 1
5121990 2392848 2392848 defendant Maynard William yeoman 587156 587156 Maynard, William, of Lamerton, yeoman;Maynard, Richard, of Lamerton, yeoman 2
5121991 2392848 2392848 defendant Tolle Bartholomew yeoman 587156 587156 Tolle, Bartholomew, of Lamerton, yeoman 3
5121992 2392848 2392848 defendant Tolle John yeoman 587156 587156 Tolle, John, of Lamerton, yeoman 4
5121993 2392848 2392848 defendant Roby John, senior yeoman 587156 587156 Roby, John, senior, of Lamerton, yeoman 5
5121994 2392848 2392848 defendant Roby Robert yeoman 587156 587156 Roby, Robert, of Lamerton, yeoman 6
5121995 2392848 2392848 defendant Roby Nicholas yeoman 587156 587156 Roby, Nicholas, of Lamerton, yeoman 7
5121996 2392848 2392848 defendant Roby John, junior yeoman 587156 587156 Roby, John, junior, of Lamerton, yeoman 8
5121997 2392848 2392848 defendant Marke William yeoman 587156 587156 Marke, William,of Lamerton, yeoman 9
5121998 2392848 2392848 defendant Maneton John yeoman 587156 587156 Maneton, John, of Lamerton, yeoman 10
5121999 2392848 2392848 defendant Swetngham Robert yeoman 587156 587156 Swetngham, Robert, of Lamerton, yeoman 11
5122000 2392848 2392848 defendant Trehous Martin yeoman 587156 587156 Trehous, Martin, of Lamerton, yeoman 12
5139278 2397977 2397977 defendant Dollynge John husbandman 587156 587156 Dollynge, John, of Lamerton, husbandman 2

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