names

70 rows where place_id = 610996

✎ 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
3686204 1921847 1921847 defendant Beyspole Thomas yeoman 610996 610996 Beyspole, Thomas, of Alby, yeoman 0
3686676 1921988 1921988 defendant Matersay John husbandman 610996 610996 Matersay, John, of Alby, husbandman 0
3686677 1921988 1921988 defendant Banburgh Robert laborer 610996 610996 Banburgh, Robert, of Alby, laborer 1
3689188 1922783 1922783 defendant Baxter Michael husbamdman 610996 610996 Baxter, Michael, of Alby, husbamdman 0
3705042 1927865 1927865 defendant Purry John thatcher 610996 610996 Purry, John, of Alby, thatcher 4
3705903 1928129 1928129 defendant Bayspole Thomas yeoman 610996 610996 Bayspole, Thomas, of Alby, yeoman 0
3717762 1931856 1931856 defendant Baxster Michael (legal representative) 610996 610996 Baxster, Michael, of Alby, husbandman, executors of 2
3717763 1931856 1931856 defendant Lownd John husbandman 610996 610996 (Lownd, John, of Alby, husbandman 3
3724052 1933807 1933807 defendant Broun John husbandman 610996 610996 Broun, John, of Alby, husbandman 0
3724202 1933856 1933856 defendant Pery John thatcher 610996 610996 Pery, John, of Alby, thatcher 1
3729636 1935519 1935519 plaintiff Baxster Michael (legal representative) 610996 610996 Baxster, Michael, of Alby, executors of 0
3742390 1939491 1939491 defendant Tompson Edmund husbandman 610996 610996 Tompson, Edmund, of Alby, husbandman 2
3742641 1939568 1939568 defendant Broun William husbandman 610996 610996 Broun, William, of Alby, husbandman 0
3763638 1946267 1946267 defendant Purrey John yeoman 610996 610996 Purrey, John, of Alby, yeoman 0
3767537 1947484 1947484 defendant Tompston Edward yeoman 610996 610996 Tompston, Edward, of Alby, yeoman 1
3768291 1947724 1947724 plaintiff Carte Robert   610996 610996 Carte, Robert, of Alby 2
3768822 1947896 1947896 defendant Walle Ralph yeoman 610996 610996 Walle, Ralph, of Alby, yeoman 2
3772559 1949108 1949108 plaintiff Walle John (legal representative) 610996 610996 Walle, John, of Alby, executors of 0
3776226 1950310 1950310 defendant Purry John yeoman 610996 610996 Purry, John, of Alby, yeoman 0
3786633 1953614 1953614 defendant Walle Ralph yeoman 610996 610996 Walle, Ralph, of Alby, yeoman 1
3827688 1966522 1966522 defendant Algare Henry   610996 610996 Algare, Henry, of Alby, wheelwright 0
3827725 1966538 1966538 plaintiff Brown John   610996 610996 Brown, John, of Alby 0
3827727 1966538 1966538 defendant Algar Henry   610996 610996 Algar, Henry, of Alby, wheelwright 0
3840730 1970667 1970667 defendant Evotson William husbandman 610996 610996 Evotson, William, of Alby, husbandman 3
3842426 1971166 1971166 plaintiff Broun John butcher 610996 610996 Broun, John, of Alby, butcher 0
3842427 1971166 1971166 defendant Lynd Thomas husbandman 610996 610996 Lynd, Thomas, of Alby, husbandman 0
3853283 1974647 1974647 defendant Tolle John husbandman 610996 610996 Tolle, John, of Alby, husbandman 1
3867039 1979216 1979216 defendant Alger Henry   610996 610996 Alger, Henry, of Alby, wheelwright 0
3867040 1979216 1979216 defendant Lyne Thomas husbandman 610996 610996 Lyne, Thomas, of Alby, husbandman 1
3897907 1989507 1989507 defendant Hawe Richard yeoman 610996 610996 Hawe, Richard, of Alby, yeoman 0
3912569 1994535 1994535 defendant Lynde Thomas husbandman 610996 610996 Lynde, Thomas, of Alby, husbandman 1
4026801 2034232 2034232 defendant Toll George husbandman 610996 610996 Toll, George, of Alby, husbandman 1
4026804 2034233 2034233 defendant Toll George husbandman 610996 610996 Toll, George, of Alby, husbandman 1
4152048 2078827 2078827 defendant Carr Vincent yeoman 610996 610996 Carr, Vincent, of Alby, yeoman 1
4166932 2083933 2083933 defendant Andrewes Ralph yeoman 610996 610996 Andrewes, Ralph, of Alby, yeoman 0
4207200 2098066 2098066 defendant Mannocke John yeoman 610996 610996 Mannocke, John, of Alby, yeoman Hast, Charles, of Blycklyng, yeoman 1
4209594 2098906 2098906 defendant Mannock John, junior yeoman 610996 610996 Mannock, John, junior, of Alby, yeoman 2
4229499 2105804 2105804 defendant Beamont Richard cordwainer 610996 610996 Beamont, Richard, of Alby, cordwainer 0
4242677 2110541 2110541 defendant Toll George yeoman 610996 610996 Toll, George, of Alby, yeoman 0
4272675 2120430 2120430 defendant Beamont Richard cordwainer 610996 610996 Beamont, Richard, of Alby, cordwainer 0
4333342 2141433 2141433 defendant Mannock John yeoman 610996 610996 Mannock, John, of Alby, yeoman 1
4335934 2142300 2142300 defendant Baispoole John gent 610996 610996 Baispoole, John, of Alby, gent 0
4353955 2148611 2148611 defendant Well or Wells John singleman 610996 610996 Well or Wells, John, of Alby, or of Beccles, Suff, husbandman, singleman 0
4487667 2196859 2196859 defendant Spencer Robert clerk 610996 610996 Spencer, Robert, of Alby, clerk 0
4487670 2196860 2196860 defendant Spencer Robert clerk 610996 610996 Spencer, Robert, of Alby, clerk 0
4547577 2215178 2215178 defendant Fyssh John   610996 610996 Fyssh, John, of Alby 0
4563332 2220105 2220105 defendant Tasburgh John   610996 610996 Tasburgh, John, of Alby 0
4753012 2281330 2281330 defendant Dennys John weaver 610996 610996 Dennys, John, of Alby, weaver 0
4902439 2327376 2327376 plaintiff Deynes Robert   610996 610996 Deynes, Robert, of Alby 0
4931518 2336240 2336240 defendant Snoryng John singleman & shipman 610996 610996 Snoryng, John, of Alby, singleman & shipman 1
4933974 2337007 2337007 plaintiff Amys William   610996 610996 Amys, William, of Alby 0
4933975 2337007 2337007 defendant Burman William husbandman 610996 610996 Burman, William, of Alby, husbandman 0
4994128 2355117 2355117 defendant Byrche John yeoman 610996 610996 Byrche, John, of Alby, yeoman 1
5002864 2357741 2357741 plaintiff Traton John   610996 610996 Traton, John, of Alby 1
5047330 2370819 2370819 plaintiff Traton John   610996 610996 Traton, John, of Alby 1
5337724 2456356 2456356 plaintiff Itryngham Robert   610996 610996 Itryngham, Robert, of Alby 0
5377241 2468468 2468468 defendant Walters John yeoman 610996 610996 Walters, John, of Alby, yeoman 2
5393078 2473090 2473090 defendant Walters Thomas yeoman 610996 610996 Walters, Thomas, of Alby, yeoman 2
5394385 2473460 2473460 defendant Walteris Thomas yeoman 610996 610996 Walteris, Thomas, of Alby, yeoman 4
5420844 2481162 2481162 defendant Walters Thomas yeoman 610996 610996 Walters, Thomas, of Alby, yeoman 0
5437691 2486208 2486208 defendant Walter Thomas yeoman 610996 610996 Walter, Thomas, of Alby, yeoman 0
5439860 2486863 2486863 defendant Walters Thomas yeoman 610996 610996 Walters, Thomas, of Alby, yeoman 0
5452404 2490592 2490592 defendant Walters Thomas laborer 610996 610996 Walters, Thomas, of Alby, laborer 0
5453465 2490927 2490927 defendant Walters Thomas yeoman 610996 610996 Walters, Thomas, of Alby, yeoman 0
5463872 2494108 2494108 defendant Walter Thomas yeoman 610996 610996 Walter, Thomas, of Alby, yeoman 0
5465379 2494553 2494553 defendant Walters Thomas yeoman 610996 610996 Walters, Thomas, of Alby, yeoman 0
5475463 2497660 2497660 defendant Walters Thomas yeoman 610996 610996 Walters, Thomas, of Alby, yeoman 0
5486480 2500848 2500848 defendant Walters Thomas yeoman 610996 610996 Walters, Thomas, of Alby, yeoman 0
5573159 2526700 2526700 defendant Smethurst John   610996 610996 Smethurst, John, of Alby, gent, administrators of 5
5588134 2531297 2531297 defendant Smetherst John   610996 610996 Smetherst, John, of Alby, gent, administrators of 4

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