names

155 rows where place_id = 586461

✎ 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
3588782 1864135 1864135 defendant Barard Andrew husbandman 586461 586461 Barard, Andrew, of Mepeham, husbandman 0
3589870 1864472 1864472 defendant Fuller Thomas fruiterer 586461 586461 Fuller, Thomas, of Mepeham, fruiterer 3
3589871 1864472 1864472 defendant Fuller Robert fruiterer 586461 586461 Fuller, Robert, of Mepeham, fruiterer 4
3596196 1866439 1866439 defendant Cost John husbandman 586461 586461 Cost, John, of Mepeham, husbandman 0
3596197 1866439 1866439 defendant Gilmyn Geoffrey husbandman 586461 586461 Gilmyn, Geoffrey, of Mepeham, husbandman 1
3605748 1869463 1869463 defendant Stokke John husbandman 586461 586461 Stokke, John, of Mepeham, husbandman 0
3605749 1869463 1869463 defendant Pyers Richard husbandman 586461 586461 Pyers, Richard, of Mepeham, husbandman 1
3608613 1870355 1870355 defendant Fuller Thomas husbandman 586461 586461 Fuller, Thomas, of Mepeham, husbandman 0
3608618 1870357 1870357 defendant Fuller Thomas husbandman 586461 586461 Fuller, Thomas, of Mepeham, husbandman 1
3608874 1870431 1870431 defendant Power Thomas husbandman 586461 586461 Power, Thomas, of Mepeham, husbandman 2
3612514 1871545 1871545 defendant Sprever Richard yeoman 586461 586461 Sprever, Richard, of Mepeham, yeoman 0
3614199 1872109 1872109 defendant Hugh Henry husbandman 586461 586461 Hugh, Henry, of Mepeham, husbandman 0
3614200 1872109 1872109 defendant Barard Andrew husbandman 586461 586461 Barard, Andrew, of Mepeham, husbandman 1
3615201 1872400 1872400 defendant Fynke William carpenter 586461 586461 Fynke, William, of Mepeham, carpenter 2
3618039 1873263 1873263 defendant Overey John husbandman 586461 586461 Overey, John, of Mepeham, husbandman 1
3620370 1873955 1873955 defendant Barard Andrew husbandman 586461 586461 Barard, Andrew, of Mepeham, husbandman 0
3632989 1905137 1905137 defendant Hewe Henry husbandman 586461 586461 Hewe, Henry, of Mepeham, husbandman 2
3634218 1905501 1905501 defendant Kete Richard husbandman 586461 586461 Kete, Richard, of Mepeham, husbandman 4
3644468 1908686 1908686 defendant Kydde Richard husbandman 586461 586461 Kydde, Richard, of Mepeham, husbandman 4
3655245 1911898 1911898 defendant Master Robert husbandman 586461 586461 Master, Robert, of Mepeham, husbandman 1
3665638 1915203 1915203 defendant Pers William husbandman 586461 586461 Pers, William, of Mepeham, husbandman 1
3674367 1918027 1918027 defendant Albery George laborer 586461 586461 Albery, George, of Mepeham, laborer 1
3677823 1919116 1919116 defendant Bryngton Richard laborer 586461 586461 Bryngton, Richard, of Mepeham, laborer 0
3678869 1919457 1919457 defendant Kede Richard husbandman 586461 586461 Kede, Richard, of Mepeham, husbandman 1
3681123 1920178 1920178 defendant Albery George laborer 586461 586461 Albery, George, of Mepeham, laborer 2
3682455 1920612 1920612 defendant Taylour Richard yeoman 586461 586461 Taylour, Richard, of Mepeham, yeoman 0
3696844 1925236 1925236 defendant Power Thomas husbandman 586461 586461 Power, Thomas, of Mepeham, husbandman 0
3711427 1929879 1929879 defendant Master Robert husbandman 586461 586461 Master, Robert, of Mepeham, husbandman 1
3720772 1932786 1932786 defendant Heyward Richard husbandman 586461 586461 Heyward, Richard, of Mepeham, husbandman 0
3722105 1933176 1933176 defendant Gylmyn John   586461 586461 Gylmyn, John, of Mepeham, cart maker 3
3732951 1936528 1936528 defendant Avery John husbandman 586461 586461 Avery, John, of Mepeham, husbandman 2
3737032 1937825 1937825 defendant Dene Richard gent 586461 586461 Dene, Richard, of Mepeham, gent 1
3737033 1937825 1937825 defendant Hasseley John husbandman 586461 586461 Hasseley, John, of Mepeham, husbandman 2
3737034 1937825 1937825 defendant Lawdys Thomas husbandman 586461 586461 Lawdys, Thomas, of Mepeham, husbandman 3
3737045 1937826 1937826 defendant Hasseley John yeoman 586461 586461 Hasseley, John, of Mepeham, yeoman 1
3737046 1937826 1937826 defendant Lawdys Thomas husbandman 586461 586461 Lawdys, Thomas, of Mepeham, husbandman 2
3737081 1937839 1937839 defendant Hewe Thomas husbandman 586461 586461 Hewe, Thomas, of Mepeham, husbandman 0
3737082 1937839 1937839 defendant Perse William husbandman 586461 586461 Perse, William, of Mepeham, husbandman 1
3755997 1943830 1943830 defendant Bulkeley Richard husbandman 586461 586461 Bulkeley, Richard, of Mepeham, husbandman 0
3759301 1944897 1944897 defendant Colyn Thomas butcher 586461 586461 Colyn, Thomas, of Mepeham, butcher 0
3773660 1949479 1949479 defendant Polle Thomas husbandman 586461 586461 Polle, Thomas, of Mepeham, husbandman 3
3776291 1950331 1950331 defendant Peerse William husbandman 586461 586461 Peerse, William, of Mepeham, husbandman 0
3780592 1951658 1951658 defendant A Dene Richard gent 586461 586461 A Dene, Richard, of Mepeham, gent 1
3780597 1951659 1951659 defendant A Dene Richard gent 586461 586461 A Dene, Richard, of Mepeham, gent 1
3785171 1953152 1953152 defendant Peers William husbandman 586461 586461 Peers, William, of Mepeham, husbandman 0
3786144 1953458 1953458 defendant Tayller Richard yeoman 586461 586461 Tayller, Richard, of Mepeham, yeoman 0
3796531 1956788 1956788 defendant Marshall William clerk 586461 586461 Marshall, William, of Mepeham, clerk 0
3802919 1958811 1958811 defendant Marshall William clerk 586461 586461 Marshall, William, of Mepeham, clerk 0
3816606 1963094 1963094 defendant Kydd John laborer 586461 586461 Kydd, John, of Mepeham, laborer 2
3822062 1964794 1964794 defendant Bukle Richard husbandman 586461 586461 Bukle, Richard, of Mepeham, husbandman 1
3845318 1972097 1972097 defendant Stephyn John weaver 586461 586461 Stephyn, John, of Mepeham, weaver 0
3857500 1975982 1975982 defendant Perse William husbandman 586461 586461 Perse, William, of Mepeham, husbandman 0
3857501 1975982 1975982 defendant Perse Robert husbandman 586461 586461 Perse, Robert, of Mepeham, husbandman 1
3857502 1975982 1975982 defendant Goodewyn William husbandman 586461 586461 Goodewyn, William, of Mepeham, husbandman 2
3857503 1975982 1975982 defendant Gilham William husbandman 586461 586461 Gilham, William, of Mepeham, husbandman 3
3857505 1975983 1975983 defendant Perse William husbandman 586461 586461 Perse, William, of Mepeham, husbandman 0
3857506 1975983 1975983 defendant Perse Robert husbandman 586461 586461 Perse, Robert, of Mepeham, husbandman 1
3857507 1975983 1975983 defendant Goodwyn William husbandman 586461 586461 Goodwyn, William, of Mepeham, husbandman 2
3857508 1975983 1975983 defendant Gylham William husbandman 586461 586461 Gylham, William, of Mepeham, husbandman 3
3863849 1978085 1978085 defendant Gylmyng John husbandman 586461 586461 Gylmyng, John, of Mepeham, husbandman 0
3888998 1986561 1986561 defendant Lane James husbandman 586461 586461 Lane, James, of Mepeham, husbandman 2
3920110 1997059 1997059 defendant Bocher William husbandman 586461 586461 Bocher, William, of Mepeham, husbandman 4
3922489 1997838 1997838 defendant Hastlyn Thomas husbandman 586461 586461 Hastlyn, Thomas, of Mepeham, husbandman 0
4508214 2203053 2203053 defendant Lotcote William   586461 586461 Lotcote, William, of Mepeham 0
4543436 2213837 2213837 plaintiff atte Hawe John   586461 586461 atte Hawe, John, of Mepeham 0
4600109 2231259 2231259 defendant Collynge Walter   586461 586461 Collynge, Walter, of Mepeham 2
4600114 2231260 2231260 defendant Collyngge Walter   586461 586461 Collyngge, Walter, of Mepeham 2
4637287 2242456 2242456 defendant Bocher Richard   586461 586461 Bocher, Richard, of Mepeham 0
4649487 2245895 2245895 defendant Smyth John   586461 586461 Smyth, John, of Mepeham 5
4788713 2292525 2292525 defendant Waldeke William fisher 586461 586461 Waldeke, William, of Mepeham, fisher 0
4791913 2293574 2293574 defendant Power John husbandman 586461 586461 Power, John, of Mepeham, husbandman 0
4861880 2315091 2315091 defendant Holwey Thomas husbandman 586461 586461 Holwey, Thomas, of Mepeham, husbandman 0
4864883 2315994 2315994 defendant Payn Thomas butcher 586461 586461 Payn, Thomas, of Mepeham, butcher 0
4865606 2316210 2316210 defendant Godfrey Richard laborer 586461 586461 Godfrey, Richard, of Mepeham, laborer 0
4865607 2316210 2316210 defendant Poure John husbandman 586461 586461 Poure, John, of Mepeham, husbandman 1
4867535 2316815 2316815 defendant Eldreth Walter laborer 586461 586461 Eldreth, Walter, of Mepeham, laborer 0
4867536 2316815 2316815 defendant Eldreth Richard laborer 586461 586461 Eldreth, Richard, of Mepeham, laborer 1
4867537 2316815 2316815 defendant Helays Walter shoemaker 586461 586461 Helays, Walter, of Mepeham, shoemaker 2
4887387 2322891 2322891 defendant Bere Robert husbandman 586461 586461 Bere, Robert, of Mepeham, husbandman 2
4897430 2325855 2325855 defendant Bere Robert farmer 586461 586461 Bere, Robert, of Mepeham, farmer 0
4897432 2325856 2325856 defendant Wikham Thomas laborer 586461 586461 Wikham, Thomas, of Mepeham, laborer 0
4906861 2328731 2328731 defendant Joskyn John husbandman 586461 586461 Joskyn, John, of Mepeham, husbandman 0
4924946 2334230 2334230 defendant London Thomas laborer 586461 586461 London, Thomas, of Mepeham, laborer 0
4948815 2341611 2341611 defendant Cossale William laborer 586461 586461 Cossale, William, of Mepeham, laborer 0
4948817 2341612 2341612 defendant Cossale William laborer 586461 586461 Cossale, William, of Mepeham, laborer 0
4957243 2344128 2344128 defendant Fuller John laborer 586461 586461 Fuller, John, of Mepeham, laborer 0
4978699 2350580 2350580 defendant Smyth John husbandman 586461 586461 Smyth, John, of Mepeham, husbandman 0
4978701 2350581 2350581 defendant Smyth John husbandman 586461 586461 Smyth, John, of Mepeham, husbandman 0
5018346 2362251 2362251 defendant Letecote Nicholas laborer 586461 586461 Letecote, Nicholas, of Mepeham, laborer 1
5069809 2377463 2377463 defendant Dene Richard husbandman 586461 586461 Dene, Richard, of Mepeham, husbandman 0
5076385 2379436 2379436 defendant Waryn John husbandman 586461 586461 Waryn, John, of Mepeham, husbandman 1
5080211 2380569 2380569 defendant Axston Reginald husbandman 586461 586461 Axston, Reginald, of Mepeham, husbandman 0
5102622 2387176 2387176 defendant London Thomas husbandman 586461 586461 London, Thomas, of Mepeham, husbandman 1
5102625 2387177 2387177 defendant London Thomas husbandman 586461 586461 London, Thomas, of Mepeham, husbandman 1
5102796 2387235 2387235 defendant Taylour Richard butcher 586461 586461 Taylour, Richard, of Mepeham, butcher 0
5102797 2387235 2387235 defendant Taylour John laborer 586461 586461 Taylour, John, of Mepeham, laborer 1
5102798 2387235 2387235 defendant Taylour William laborer 586461 586461 Taylour, William, of Mepeham, laborer 2
5110182 2389386 2389386 defendant Axston John husbandman 586461 586461 Axston, John, of Mepeham, husbandman 1
5110183 2389386 2389386 defendant Kyng Nicholas husbandman 586461 586461 Kyng, Nicholas, of Mepeham, husbandman 2
5110193 2389387 2389387 defendant Axston John husbandman 586461 586461 Axston, John, of Mepeham, 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);