names

101 rows where place_id = 600139

✎ 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
3639845 1907276 1907276 plaintiff Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 2
3673378 1917692 1917692 defendant Brewster Robert yeoman 600139 600139 Brewster, Robert, of Toft Monks, yeoman 0
3686557 1921945 1921945 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 1
3688879 1922680 1922680 defendant Smyth Benedict husbandman 600139 600139 Smyth, Benedict, of Toft Monks, husbandman 0
3696772 1925215 1925215 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 1
3706306 1928260 1928260 defendant Dake William   600139 600139 Dake, William, of Toft Monks, organ player 0
3709877 1929403 1929403 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 1
3710492 1929603 1929603 defendant Keen Thomas yeoman 600139 600139 Keen, Thomas, of Toft Monks, yeoman 0
3710493 1929603 1929603 defendant Davy William husbandman 600139 600139 Davy, William, of Toft Monks, husbandman 1
3725125 1934148 1934148 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 0
3725127 1934149 1934149 defendant Smyth Benedict husbandman 600139 600139 Smyth, Benedict, of Toft Monks, husbandman 0
3740234 1938802 1938802 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 1
3741031 1939057 1939057 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 0
3741032 1939057 1939057 defendant Davy William husbandman 600139 600139 Davy, William, of Toft Monks, husbandman 1
3742285 1939458 1939458 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 2
3743631 1939884 1939884 defendant Davy John husbandman 600139 600139 Davy, John, of Toft Monks, husbandman 1
3758432 1944633 1944633 defendant Bayspole Thomas husbandman 600139 600139 Bayspole, Thomas, of Toft Monks, husbandman 0
3765726 1946945 1946945 defendant Kene Thomas husbandman 600139 600139 Kene, Thomas, of Toft Monks, husbandman 2
3768074 1947652 1947652 defendant Kene Thomas husbandman 600139 600139 Kene, Thomas, of Toft Monks, husbandman 1
3769398 1948085 1948085 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 1
3773516 1949428 1949428 defendant Bayspole Thomas husbandman 600139 600139 Bayspole, Thomas, of Toft Monks, husbandman 1
3779478 1951303 1951303 defendant Davy William yeoman 600139 600139 Davy, William, of Toft Monks, yeoman 2
3788175 1954097 1954097 defendant Davy William husbandman 600139 600139 Davy, William, of Toft Monks, husbandman 0
3789304 1954474 1954474 defendant Davy William carpenter 600139 600139 Davy, William, of Toft Monks, carpenter 2
3800092 1957954 1957954 defendant Mylam Robert yeoman 600139 600139 Mylam, Robert, of Toft Monks, yeoman 0
3803545 1959016 1959016 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 1
3816818 1963166 1963166 defendant Rede Robert   600139 600139 Rede, Robert, of Toft Monks, brick maker 0
3816819 1963166 1963166 defendant Grey William   600139 600139 Grey, William, of Toft Monks, brick maker 1
3821826 1964716 1964716 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 1
3821830 1964717 1964717 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 1
3826775 1966227 1966227 defendant Mylam Robert gusbandman 600139 600139 Mylam, Robert, of Toft Monks, gusbandman 1
3834729 1968797 1968797 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 0
3841278 1970854 1970854 defendant Hall Christopher husbandman 600139 600139 Hall, Christopher, of Toft Monks, husbandman 1
3847636 1972830 1972830 defendant Broke Thomas husbandman 600139 600139 Broke, Thomas, of Toft Monks, husbandman 0
3862253 1977560 1977560 defendant Kene Thomas husbandman 600139 600139 Kene, Thomas, of Toft Monks, husbandman 1
3863847 1978084 1978084 defendant Davy William   600139 600139 Davy, William, of Toft Monks, organ player 0
3870326 1980326 1980326 defendant Davy William   600139 600139 Davy, William, of Toft Monks, organ player 1
3876548 1982402 1982402 defendant Kene Thomas husbandman 600139 600139 Kene, Thomas, of Toft Monks, husbandman 0
3877166 1982603 1982603 defendant Broke Thomas husbandman 600139 600139 Broke, Thomas, of Toft Monks, husbandman 0
3877167 1982603 1982603 defendant Myleham Robert yeoman 600139 600139 Myleham, Robert, of Toft Monks, yeoman 1
3883414 1984721 1984721 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 1
3883415 1984721 1984721 defendant Davy John yeoman 600139 600139 Davy, John, of Toft Monks, yeoman 2
3883416 1984721 1984721 defendant Davy William yeoman or organ player 600139 600139 Davy, William, of Toft Monks, yeoman or organ player 3
3885386 1985366 1985366 defendant Davy William   600139 600139 Davy, William, of Toft Monks, organ player 0
3888470 1986405 1986405 defendant Myleham Robert husbandman 600139 600139 Myleham, Robert, of Toft Monks, husbandman 1
3888472 1986405 1986405 defendant Harryse William husbandman 600139 600139 Harryse, William, of Toft Monks, husbandman 3
3889020 1986566 1986566 defendant Davy William organplpayer 600139 600139 Davy, William, of Toft Monks, organplpayer 4
3902267 1990993 1990993 defendant Davy Nicholas, junior husbandman 600139 600139 Davy, Nicholas, junior, of Toft Monks, husbandman 3
3903470 1991385 1991385 defendant Davy John husbandman 600139 600139 Davy, John, of Toft Monks, husbandman 0
3913258 1994764 1994764 plaintiff Baspole Thomas, junior   600139 600139 Baspole, Thomas, junior, of Toft Monks 0
3916678 1995948 1995948 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 1
3922624 1997882 1997882 defendant Kene Thomas yeoman 600139 600139 Kene, Thomas, of Toft Monks, yeoman 2
3938969 2003366 2003366 defendant Davye Nicholas husbandman 600139 600139 Davye, Nicholas, of Toft Monks, husbandman 1
3959443 2010389 2010389 defendant Davy Nicholas, junior yeoman 600139 600139 Davy, Nicholas, junior, of Toft Monks, yeoman 0
3965894 2012689 2012689 defendant Davy John, junior husbandman 600139 600139 Davy, John, junior, of Toft Monks, husbandman 0
4030096 2035411 2035411 defendant Bennett Edward gent 600139 600139 Bennett, Edward, of Toft Monks, or of Sutton, gent 2
4034007 2036818 2036818 defendant Barpole Richard husbandman 600139 600139 Barpole, Richard, of Toft Monks, husbandman 0
4062765 2046983 2046983 defendant Mannyng Robert weaver 600139 600139 Mannyng, Robert, of Toft Monks, weaver 1
4068105 2048899 2048899 defendant Gaye alias Maye William husbandman 600139 600139 Gaye alias Maye, William, of Toft Monks, husbandman 1
4069312 2049308 2049308 defendant Seman Augustine   600139 600139 Seman, Augustine, of Toft Monks, brick maker 1
4086723 2055540 2055540 defendant Pulham Thomas, senior yeoman 600139 600139 Pulham, Thomas, senior, of Toft Monks, yeoman 0
4168499 2084468 2084468 defendant Bayspoole William yeoman 600139 600139 Bayspoole, William, of Toft Monks, yeoman 0
4275365 2121320 2121320 defendant Howlett Edmund yeoman 600139 600139 Howlett, Edmund, of Toft Monks, yeoman 0
4275417 2121337 2121337 defendant Baspoole William   600139 600139 Baspoole, William, of Toft Monks gent 1
4276454 2121708 2121708 defendant Bayspole William gent 600139 600139 Bayspole, William, of Toft Monks, gent 0
4285116 2124727 2124727 defendant Kedgell Miles yeoman 600139 600139 Kedgell, Miles, of Toft Monks, or of Great Yarmouth, yeoman 1
4351697 2147836 2147836 defendant Davye John yeoman 600139 600139 Davye, John, of Toft Monks, yeoman 2
4383451 2159175 2159175 defendant Baspoole William yeoman 600139 600139 Baspoole, William, of Toft Monks, or of Uggeshall, Suff, yeoman 0
4384905 2159642 2159642 defendant Howes William yeoman 600139 600139 Howes, William, of Toft Monks, yeoman 0
4458159 2187587 2187587 plaintiff Purchas Geoffrey   600139 600139 Purchas, Geoffrey, of Toft Monks, parson 0
4458163 2187588 2187588 plaintiff Purchas Geoffrey   600139 600139 Purchas, Geoffrey, of Toft Monks, parson 0
4891860 2324189 2324189 defendant Oldhawe John carpenter 600139 600139 Oldhawe, John, of Toft Monks, carpenter 3
4900108 2326663 2326663 defendant Suker Thomas yeoman 600139 600139 Suker, Thomas, of Toft Monks, yeoman 0
4906355 2328576 2328576 defendant Reston Thomas husbandman 600139 600139 Reston, Thomas, of Toft Monks, husbandman 0
4916691 2331727 2331727 defendant Badle James   600139 600139 Badle, James, of Toft Monks 1
4916696 2331727 2331727 defendant Reston Thomas   600139 600139 Reston, Thomas, of Toft Monks 6
4944785 2340355 2340355 defendant Senker alias Welles Thomas carpenter 600139 600139 Senker alias Welles, Thomas, of Toft Monks, carpenter 0
5017773 2362076 2362076 defendant Ryston Thomas husbandman 600139 600139 Ryston, Thomas, of Toft Monks, husbandman 1
5044824 2370087 2370087 defendant Athawe Geoffrey, junior husbandman 600139 600139 Athawe, Geoffrey, junior, of Toft Monks, husbandman 3
5053211 2372561 2372561 defendant Senker Thomas husbandman 600139 600139 Senker, Thomas, of Toft Monks, husbandman 1
5142846 2399036 2399036 defendant ryston Geoffrey husbandman 600139 600139 ryston, Geoffrey, of Toft Monks, husbandman 3
5163565 2405076 2405076 defendant Odams John yeoman 600139 600139 Odams, John, of Toft Monks, yeoman 2
5164202 2405269 2405269 defendant Ryston Geoffrey husbandman 600139 600139 Ryston, Geoffrey, of Toft Monks, husbandman 3
5164209 2405270 2405270 defendant Ryston Geoffrey husbandman 600139 600139 Ryston, Geoffrey, of Toft Monks, husbandman 3
5165439 2405636 2405636 defendant Badle James yeoman 600139 600139 Badle, James, of Toft Monks, yeoman 2
5199952 2415739 2415739 defendant Odams John yeoman 600139 600139 Odams, John, of Toft Monks, yeoman 2
5223742 2422627 2422627 defendant Joos Richard yeoman 600139 600139 Joos, Richard, of Toft Monks, yeoman 0
5223743 2422627 2422627 defendant Canteley Peter clerk 600139 600139 Canteley, Peter, of Toft Monks, clerk 1
5223745 2422628 2422628 defendant Joos Richard yeoman 600139 600139 Joos, Richard, of Toft Monks, yeoman 0
5223746 2422628 2422628 defendant Canteley Peter clerk 600139 600139 Canteley, Peter, of Toft Monks, clerk 1
5252248 2430812 2430812 defendant Reydon William yeoman 600139 600139 Reydon, William, of Toft Monks, yeoman 0
5261683 2433765 2433765 defendant Reydon William yeoman 600139 600139 Reydon, William, of Toft Monks, yeoman 1
5281456 2439645 2439645 defendant Stronde James yeoman 600139 600139 Stronde, James, of Toft Monks, yeoman 5
5288769 2441728 2441728 defendant Whitesyde Christopher   600139 600139 Whitesyde, Christopher, of Toft Monks 2
5291309 2442462 2442462 defendant Stronde James husbandman 600139 600139 Stronde, James, of Toft Monks, husbandman 0
5314584 2449394 2449394 defendant Reydon William husbandman 600139 600139 Reydon, William, of Toft Monks, husbandman 0
5323517 2452115 2452115 defendant Reydon William husbandman 600139 600139 Reydon, William, of Toft Monks, husbandman 0
5327959 2453431 2453431 defendant Reydon William husbandman 600139 600139 Reydon, William, of Toft Monks, husbandman 1
5371814 2466773 2466773 defendant Reydon William yeoman 600139 600139 Reydon, William, of Toft Monks, yeoman 2
5442139 2487566 2487566 defendant Oldhawe John husbandman 600139 600139 Oldhawe, John, of Toft Monks, husbandman 0

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