names

221 rows where place_id = 586157

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3588048 1863914 1863914 defendant Dey Thomas laborer 586157 586157 Dey, Thomas, of Mateshale, laborer 1
3588616 1864084 1864084 defendant Amys John laborer 586157 586157 Amys, John, of Mateshale, laborer 0
3590772 1864753 1864753 defendant Snellyng Thomas butcher 586157 586157 Snellyng, Thomas, of Mateshale, butcher 0
3590773 1864753 1864753 defendant Snellyng William butcher 586157 586157 Snellyng, William, of Mateshale, butcher 1
3591206 1864873 1864873 defendant Snellyng William butcher 586157 586157 Snellyng, William, of Mateshale, butcher 0
3591208 1864874 1864874 defendant Snellyng William butcher 586157 586157 Snellyng, William, of Mateshale, butcher 0
3604014 1868922 1868922 plaintiff Foster Robert   586157 586157 Foster, Robert, of Mateshale, wool chapman 0
3607129 1869897 1869897 defendant Snellyng Thomas butcher 586157 586157 Snellyng, Thomas, of Mateshale, butcher 0
3614600 1872215 1872215 defendant Smyth William yeoman 586157 586157 Smyth, William, of Mateshale, yeoman 1
3616378 1872759 1872759 defendant Smyth William yeoman 586157 586157 Smyth, William, of Mateshale, yeoman 8
3617136 1872984 1872984 defendant Talfas Robert   586157 586157 Talfas, Robert, of Mateshale, coverlet weaver 2
3618885 1873517 1873517 defendant Outlawe John husbandman 586157 586157 Outlawe, John, of Mateshale, husbandman 1
3650809 1910617 1910617 defendant Brentley Henry woolman 586157 586157 Brentley, Henry, of Mateshale, woolman 0
3650810 1910617 1910617 defendant Pecher Richard husbandman 586157 586157 Pecher, Richard, of Mateshale, husbandman 1
3651632 1910870 1910870 plaintiff Talface Robert   586157 586157 Talface, Robert, of Mateshale 0
3651633 1910870 1910870 defendant Brentley Henry husbandman 586157 586157 Brentley, Henry, of Mateshale, husbandman 0
3654094 1911543 1911543 defendant Goldysburgh William butcher 586157 586157 Goldysburgh, William, of Mateshale, butcher 0
3654859 1911778 1911778 defendant Ayleffe Thomas yeoman 586157 586157 Ayleffe, Thomas, of Mateshale, yeoman 0
3657479 1912601 1912601 defendant Lawis Gustavus yeoman 586157 586157 Lawis, Gustavus, of Mateshale, yeoman 0
3658500 1912910 1912910 defendant Lans or Laus Eustace husbandman 586157 586157 Lans or Laus, Eustace, of Mateshale, husbandman 0
3668351 1916049 1916049 defendant Goldesburghe William butcher 586157 586157 Goldesburghe, William, of Mateshale, butcher 0
3678046 1919177 1919177 defendant Aleyn Thomas husbandman 586157 586157 Aleyn, Thomas, of Mateshale, husbandman 1
3681132 1920180 1920180 defendant Harleston Robert husbandman 586157 586157 Harleston, Robert, of Mateshale, husbandman 0
3681133 1920180 1920180 defendant Lawes Eustace husbandman 586157 586157 Lawes, Eustace, of Mateshale, husbandman 1
3683207 1920866 1920866 defendant Bylney William husbandman 586157 586157 Bylney, William, of Mateshale, husbandman 0
3691974 1923653 1923653 defendant Baxster Simon innholder 586157 586157 Baxster, Simon, of Mateshale, innholder 0
3692278 1923754 1923754 defendant Adams Thomas smith 586157 586157 Adams, Thomas, of Mateshale, smith 1
3700669 1926456 1926456 defendant Adams Thomas smith 586157 586157 Adams, Thomas, of Mateshale, smith 0
3700671 1926456 1926456 defendant Goldyng Robert fuller 586157 586157 Goldyng, Robert, of Mateshale, fuller 2
3706253 1928243 1928243 defendant Baxster Simon innholder 586157 586157 Baxster, Simon, of Mateshale, innholder 0
3707127 1928515 1928515 defendant Rytupe Robert husbandman 586157 586157 Rytupe, Robert, of Mateshale, husbandman 4
3712313 1930168 1930168 defendant Wylson Mathew tailor 586157 586157 Wylson, Mathew, of Mateshale, tailor 2
3743550 1939858 1939858 defendant Savage Robert, junior husbandman 586157 586157 Savage, Robert, junior, of Mateshale, husbandman 1
3751204 1942301 1942301 defendant Wattys John   586157 586157 Wattys, John, of Mateshale, wool chapman 0
3754959 1943500 1943500 defendant Harleston Robert woolman 586157 586157 Harleston, Robert, of Mateshale, woolman 1
3767310 1947419 1947419 defendant Wattys John husbandman 586157 586157 Wattys, John, of Mateshale, husbandman 0
3768705 1947859 1947859 defendant Savage Robert husbandman 586157 586157 Savage, Robert, of Mateshale, husbandman 1
3780947 1951776 1951776 defendant Adams Thomas smith 586157 586157 Adams, Thomas, of Mateshale, smith 1
3780955 1951778 1951778 defendant Wattys John   586157 586157 Wattys, John, of Mateshale, wool chapman 0
3789700 1954608 1954608 defendant Rumpe Robert clerk 586157 586157 Rumpe, Robert, of Mateshale, clerk 2
3795549 1956489 1956489 defendant Martyn Alexander yeoman 586157 586157 Martyn, Alexander, of Mateshale, yeoman 3
3812136 1961708 1961708 defendant Walter John   586157 586157 Walter, John, of Mateshale, wool chapman 1
3823158 1965155 1965155 defendant Ayliff Thomas yeoman 586157 586157 Ayliff, Thomas, of Mateshale, yeoman 0
3888778 1986497 1986497 defendant Harlston Robert husbandman 586157 586157 Harlston, Robert, of Mateshale, husbandman 0
3934154 2001715 2001715 plaintiff Hawe Wallter   586157 586157 Hawe, Wallter, of Mateshale, 0
3939974 2003667 2003667 defendant Goodwyn Thomas yeoman 586157 586157 Goodwyn, Thomas, of Mateshale, yeoman 5
4502886 2201477 2201477 defendant Gerard John   586157 586157 Gerard, John, of Mateshale, vicar 0
4551639 2216457 2216457 defendant Bukes John   586157 586157 Bukes, John, of Mateshale 1
4555481 2217647 2217647 defendant Smyth Simon   586157 586157 Smyth, Simon, of Mateshale 8
4567517 2221398 2221398 defendant atte Mere William   586157 586157 atte Mere, William, of Mateshale 0
4571706 2222729 2222729 defendant Jaune Hugh   586157 586157 Jaune, Hugh, of Mateshale 0
4579210 2224980 2224980 defendant atte Style Roger   586157 586157 atte Style, Roger, of Mateshale 0
4585647 2226937 2226937 defendant Duke William Norfolk 586157 586157 Duke William, of Mateshale, Norfolk 0
4594056 2229402 2229402 defendant Jaunes Hugh   586157 586157 Jaunes, Hugh, of Mateshale 0
4595450 2229832 2229832 defendant Jaunes Hugh   586157 586157 Jaunes, Hugh, of Mateshale 2
4608521 2233772 2233772 defendant Caston Hugh de   586157 586157 Caston, Hugh de, of Mateshale 3
4614844 2235648 2235648 defendant Caudeler John   586157 586157 Caudeler, John, of Mateshale, son of William 0
4637320 2242468 2242468 defendant Caston Hugh de   586157 586157 Caston, Hugh de, of Mateshale 2
4653447 2247009 2247009 defendant Caston Hugh yeoman 586157 586157 Caston, Hugh, of Mateshale, yeoman 3
4661934 2249579 2249579 defendant atte Stile Roger husbandman 586157 586157 atte Stile, Roger, of Mateshale, husbandman 0
4676513 2258271 2258271 plaintiff Godewyn John   586157 586157 Godewyn, John, of Mateshale 0
4698850 2265122 2265122 plaintiff Den Geoffrey   586157 586157 Den, Geoffrey, of Mateshale 0
4747903 2279894 2279894 plaintiff Leveryngton Andrew   586157 586157 Leveryngton, Andrew, of Mateshale, vicar 0
4756950 2282541 2282541 defendant Soutere Arnold   586157 586157 Soutere, Arnold, of Mateshale, shoe maker 3
4766580 2285540 2285540 plaintiff Leveryngton Andrew clerk 586157 586157 Leveryngton, Andrew, of Mateshale, clerk 0
4778864 2289364 2289364 defendant Soutere Arnald shoemaker 586157 586157 Soutere, Arnald, of Mateshale, shoemaker 3
4786161 2291710 2291710 plaintiff Smyth John chaplain 586157 586157 Smyth, John, of Mateshale, chaplain 1
4786167 2291711 2291711 plaintiff Smyth John chaplain 586157 586157 Smyth, John, of Mateshale, chaplain 1
4801294 2296593 2296593 defendant Alcok William husbandman 586157 586157 Alcok, William, of Mateshale, husbandman 2
4811146 2299595 2299595 defendant Wacy William weaver 586157 586157 Wacy, William, of Mateshale, weaver 0
4813786 2300422 2300422 defendant Caston Robert yeoman 586157 586157 Caston, Robert, of Mateshale, yeoman 1
4819127 2302059 2302059 defendant Bolour Stephen husbandman 586157 586157 Bolour, Stephen, of Mateshale, husbandman 1
4823811 2303530 2303530 defendant Wystan Alan or Aldous laborer 586157 586157 Wystan, Alan or Aldous, of Mateshale, laborer 0
4829924 2305402 2305402 defendant Joweler John husbandman 586157 586157 Joweler, John, of Mateshale, husbandman 6
4829925 2305402 2305402 defendant Plomm_ Simon yeoman 586157 586157 Plomm_, Simon, of Mateshale, yeoman 7
4842965 2309342 2309342 defendant Harleston Richard weaver 586157 586157 Harleston, Richard, of Mateshale, weaver 1
4845758 2310184 2310184 defendant Wystan Alan husbandman 586157 586157 Wystan, Alan, of Mateshale, husbandman 1
4845761 2310184 2310184 defendant Harleston Richard husbandman 586157 586157 Harleston, Richard, of Mateshale, husbandman 4
4885099 2322232 2322232 defendant Tunnok Thomas ostler 586157 586157 Tunnok, Thomas, of Mateshale, ostler 2
4887203 2322840 2322840 defendant Tunnok Thomas yeoman 586157 586157 Tunnok, Thomas, of Mateshale, yeoman 3
4892961 2324525 2324525 defendant Mabeley Geoffrey laborer 586157 586157 Mabeley, Geoffrey, of Mateshale, laborer 2
4892962 2324525 2324525 defendant Buske Richard laborer 586157 586157 Buske, Richard, of Mateshale, laborer 3
4897766 2325968 2325968 defendant Tunnok Thomas yeoman 586157 586157 Tunnok, Thomas, of Mateshale, yeoman 3
4905187 2328220 2328220 defendant Tunnok Thomas yeoman 586157 586157 Tunnok, Thomas, of Mateshale, yeoman 2
4937063 2337964 2337964 defendant Crowe Thomas draper 586157 586157 Crowe, Thomas, of Mateshale, draper 5
4941471 2339351 2339351 defendant Leveryngton Andrew clerk 586157 586157 Leveryngton, Andrew, of Mateshale, clerk 2
4950314 2342064 2342064 defendant Lovegold William butcher 586157 586157 Lovegold, William, of Mateshale, butcher 0
4955008 2343454 2343454 defendant Jewaler John laborer 586157 586157 Jewaler, John, of Mateshale, laborer 0
4955011 2343454 2343454 defendant Mably Geoffrey laborer 586157 586157 Mably, Geoffrey, of Mateshale, laborer 3
4955025 2343456 2343456 defendant Snellyn Thomas butcher 586157 586157 Snellyn, Thomas, of Mateshale, butcher 1
4955028 2343456 2343456 defendant Mabele Geoffrey laborer 586157 586157 Mabele, Geoffrey, of Mateshale, laborer 4
4970562 2348137 2348137 defendant Caston Hugh husbandman 586157 586157 Caston, Hugh, of Mateshale, husbandman 3
4971445 2348385 2348385 defendant Leveryngton Andrew clerk 586157 586157 Leveryngton, Andrew, of Mateshale, clerk 0
4979524 2350833 2350833 defendant Snellyng Thomas butcher 586157 586157 Snellyng, Thomas, of Mateshale, butcher 2
4982842 2351782 2351782 defendant Snellyng Thomas butcher 586157 586157 Snellyng, Thomas, of Mateshale, butcher 0
4982845 2351782 2351782 defendant Wulny Richard thatcher 586157 586157 Wulny, Richard, of Mateshale, thatcher 3
5003875 2358024 2358024 defendant atte Hyrne Thomas husbandman 586157 586157 atte Hyrne, Thomas, of Mateshale, husbandman 0
5008109 2359256 2359256 defendant Broun Peter   586157 586157 Broun, Peter, of Mateshale, wright 1
5008157 2359269 2359269 defendant Leveryngton Andrew clerk 586157 586157 Leveryngton, Andrew, of Mateshale, clerk 0
5008160 2359269 2359269 defendant Makeley Geoffrey laborer 586157 586157 Makeley, Geoffrey, of Mateshale, laborer 3

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