names

383 rows where place_id = 591362

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604181 1868973 1868973 defendant Wayte John fuller 591362 591362 Wayte, John, of Neylond, fuller 3
3607305 1869946 1869946 defendant Foweler John fowler 591362 591362 Foweler, John, of Neylond, fowler 0
3608661 1870369 1870369 defendant Smyth John painter 591362 591362 Smyth, John, of Neylond, painter 2
3608945 1870454 1870454 defendant Reynham John, senior clothmaker 591362 591362 Reynham, John, senior, of Neylond, clothmaker 0
3608946 1870454 1870454 defendant Archer John, senior clothmaker 591362 591362 Archer, John, senior, of Neylond, clothmaker 1
3608947 1870454 1870454 defendant Whyte John clothmaker 591362 591362 Whyte, John, of Neylond, clothmaker 2
3613310 1871813 1871813 defendant Werburton Thomas clothmaker 591362 591362 Werburton, Thomas, of Neylond, clothmaker 0
3613311 1871813 1871813 defendant Austyn Thomas clothmaker 591362 591362 Austyn, Thomas, of Neylond, clothmaker 1
3614120 1872082 1872082 defendant Samond Richard clothmaker 591362 591362 Samond, Richard, of Neylond, clothmaker 0
3620393 1873963 1873963 defendant Smyth James yeoman 591362 591362 Smyth, James, of Neylond, yeoman 0
3622233 1874488 1874488 defendant Austyn Thomas clothmaker 591362 591362 Austyn, Thomas, of Neylond, clothmaker 0
3623141 1874759 1874759 defendant Austen Thomas husbandman 591362 591362 Austen, Thomas, of Neylond, husbandman 3
3624356 1875152 1875152 defendant Payn Richard husbandman 591362 591362 Payn, Richard, of Neylond, husbandman 0
3651255 1910758 1910758 defendant Baker alias Castylden John sherman 591362 591362 Baker alias Castylden, John, of Neylond, sherman 0
3658114 1912795 1912795 defendant Page John   591362 591362 Page, John, of Neylond, cloth maker 0
3660395 1913508 1913508 defendant Desley William husbandman 591362 591362 Desley, William, of Neylond, husbandman 1
3660421 1913518 1913518 defendant Cooke Robert weaver 591362 591362 Cooke, Robert, of Neylond, weaver 0
3667926 1915909 1915909 defendant Otton Thomas sherman 591362 591362 Otton, Thomas, of Neylond, sherman 3
3667932 1915910 1915910 defendant Otton Thomas sherman 591362 591362 Otton, Thomas, of Neylond, sherman 3
3669086 1916264 1916264 defendant Arnold Thomas sherman 591362 591362 Arnold, Thomas, of Neylond, sherman 2
3669087 1916264 1916264 defendant Greneleffe William weaver 591362 591362 Greneleffe, William, of Neylond, weaver 3
3676064 1918549 1918549 defendant Peren John laborer 591362 591362 Peren, John, of Neylond, laborer 1
3676601 1918719 1918719 defendant Byrde Robert sherman 591362 591362 Byrde, Robert, of Neylond, sherman 0
3676911 1918817 1918817 defendant Poppys Richard husbandman 591362 591362 Poppys, Richard, of Neylond, husbandman 2
3681508 1920307 1920307 defendant Birde John husbandman 591362 591362 Birde, John, of Neylond, husbandman 2
3681985 1920472 1920472 plaintiff Stannysby Roger weaver 591362 591362 Stannysby, Roger, of Neylond, weaver 0
3681986 1920472 1920472 defendant Cooke John weaver 591362 591362 Cooke, John, of Neylond, weaver 0
3681987 1920472 1920472 defendant Pyke Thomas fuller 591362 591362 Pyke, Thomas, of Neylond, fuller 1
3681988 1920472 1920472 defendant Lully William weaver 591362 591362 Lully, William, of Neylond, weaver 2
3681989 1920472 1920472 defendant Smyth Robert, junior weaver 591362 591362 Smyth, Robert, junior, of Neylond, weaver 3
3681990 1920472 1920472 defendant Gent William weaver 591362 591362 Gent, William, of Neylond, weaver 4
3684619 1921322 1921322 plaintiff Abell Richard yeoman 591362 591362 Abell, Richard, of Neylond, yeoman 0
3684621 1921322 1921322 defendant Downe Nicholas   591362 591362 Downe, Nicholas, of Neylond, card maker 1
3684835 1921393 1921393 defendant Staunysby Roger clothman 591362 591362 Staunysby, Roger, of Neylond, clothman 0
3685595 1921648 1921648 defendant Rutter Christopher fuller 591362 591362 Rutter, Christopher, of Neylond, fuller 0
3685596 1921648 1921648 defendant Brewse Thomas carpenter 591362 591362 Brewse, Thomas, of Neylond, carpenter 1
3685597 1921648 1921648 defendant Knevett Thomas carver 591362 591362 Knevett, Thomas, of Neylond, carver 2
3687195 1922172 1922172 defendant Selesden William butcher 591362 591362 Selesden, William, of Neylond, butcher 0
3687950 1922390 1922390 defendant Cooke John weaver 591362 591362 Cooke, John, of Neylond, weaver 1
3697180 1925339 1925339 defendant Knopwede Thomas weaver 591362 591362 Knopwede, Thomas, of Neylond, weaver 0
3697181 1925339 1925339 defendant Lulby William weaver 591362 591362 Lulby, William, of Neylond, weaver 1
3698489 1925747 1925747 defendant Polley William husbandman 591362 591362 Polley, William, of Neylond, husbandman 0
3699823 1926169 1926169 plaintiff Abbys James clothier 591362 591362 Abbys, James, of Neylond, clothier 0
3699825 1926170 1926170 plaintiff Abbys James clothier 591362 591362 Abbys, James, of Neylond, clothier 0
3700601 1926434 1926434 defendant Knevet Thomas carver 591362 591362 Knevet, Thomas, of Neylond, carver 0
3703058 1927231 1927231 defendant Page John innholder 591362 591362 Page, John, of Neylond, innholder 0
3705861 1928116 1928116 defendant Munson John weaver 591362 591362 Munson, John, of Neylond, weaver 0
3707604 1928676 1928676 defendant Wotton Thomas sherman 591362 591362 Wotton, Thomas, of Neylond, sherman 0
3709548 1929294 1929294 defendant Gedge John butcher 591362 591362 Gedge, John, of Neylond, butcher 0
3709552 1929295 1929295 defendant Gege John butcher 591362 591362 Gege, John, of Neylond, butcher 0
3713315 1930476 1930476 defendant Malle John clothmaker 591362 591362 Malle, John, of Neylond, clothmaker 0
3713321 1930479 1930479 plaintiff Abell John merchant 591362 591362 Abell, John, of Neylond, merchant 0
3713325 1930480 1930480 defendant Page John innholder 591362 591362 Page, John, of Neylond, innholder 0
3713328 1930481 1930481 defendant Page John innholder 591362 591362 Page, John, of Neylond, innholder 0
3727100 1934742 1934742 defendant Knevett Thomas carver 591362 591362 Knevett, Thomas, of Neylond, carver 1
3743964 1940001 1940001 defendant Fryth Richard weaver 591362 591362 Fryth, Richard, of Neylond, weaver 0
3745621 1940537 1940537 defendant Taylour John yeoman 591362 591362 Taylour, John, of Neylond, yeoman 0
3755984 1943826 1943826 defendant Awsten John clothmaker 591362 591362 Awsten, John, of Neylond, clothmaker 1
3755985 1943826 1943826 defendant Turnor John butcher 591362 591362 Turnor, John, of Neylond, butcher 2
3755986 1943826 1943826 defendant Wyerdrawer Richard   591362 591362 Wyerdrawer, Richard, of Neylond, wire drawer 3
3773969 1949574 1949574 plaintiff Abbys James clothmaker 591362 591362 Abbys, James, of Neylond, clothmaker 0
3776708 1950463 1950463 plaintiff Byrde John clothmaker 591362 591362 Byrde, John, of Neylond, clothmaker 0
3787206 1953790 1953790 defendant Taylour John yeoman 591362 591362 Taylour, John, of Neylond, yeoman 0
3803486 1958994 1958994 defendant Taylour John yeoman 591362 591362 Taylour, John, of Neylond, yeoman 0
3818100 1963574 1963574 defendant Austeyn John clothmaker 591362 591362 Austeyn, John, of Neylond, clothmaker 0
3844186 1971732 1971732 defendant Gegge John butcher 591362 591362 Gegge, John, of Neylond, butcher 0
3844666 1971875 1971875 defendant Abbis James clothier 591362 591362 Abbis, James, of Neylond, clothier 1
3844667 1971875 1971875 defendant Pygott Anthony clothier 591362 591362 Pygott, Anthony, of Neylond, clothier 2
3844668 1971875 1971875 defendant Tompson John clothier 591362 591362 Tompson, John, of Neylond, clothier 3
3844669 1971875 1971875 defendant Malle John clothier 591362 591362 Malle, John, of Neylond, clothier 4
3844670 1971875 1971875 defendant Roos Edward clothier 591362 591362 Roos, Edward, of Neylond, clothier 5
3844671 1971875 1971875 defendant Rutter Christopher clothier 591362 591362 Rutter, Christopher, of Neylond, clothier 6
3844672 1971875 1971875 defendant Austen John clothier 591362 591362 Austen, John, of Neylond, clothier 7
3847547 1972799 1972799 defendant Benett Thomas smith 591362 591362 Benett, Thomas, of Neylond, smith 2
3852472 1974381 1974381 plaintiff Reyneham Stephen clothmaker 591362 591362 Reyneham, Stephen, of Neylond, clothmaker 0
3852473 1974381 1974381 defendant Scranton Robert carpenter 591362 591362 Scranton, Robert, of Neylond, carpenter 0
3859952 1976832 1976832 defendant Rutter Christopher clothmaker 591362 591362 Rutter, Christopher, of Neylond, clothmaker 0
3869925 1980184 1980184 defendant Tomson Richard clothier 591362 591362 Tomson, Richard, of Neylond, clothier 3
3881146 1983963 1983963 plaintiff Rutter Christopher   591362 591362 Rutter, Christopher, of Neylond 0
3898096 1989572 1989572 defendant Reddys William sherman 591362 591362 Reddys, William, of Neylond, sherman 1
3898097 1989572 1989572 defendant Swallowe Thomas sherman 591362 591362 Swallowe, Thomas, of Neylond, sherman 2
3898098 1989572 1989572 defendant Crowe Robert sherman 591362 591362 Crowe, Robert, of Neylond, sherman 3
3898106 1989574 1989574 defendant Rychemond Edward husbandman 591362 591362 Rychemond, Edward, of Neylond, husbandman 1
3929215 2000114 2000114 defendant Brett Henry husbandman 591362 591362 Brett, Henry, of Neylond, husbandman 0
3929217 2000114 2000114 defendant Wood Henry laborer 591362 591362 Wood, Henry, of Neylond, laborer 2
3929218 2000114 2000114 defendant Squyer John laborer 591362 591362 Squyer, John, of Neylond, laborer 3
3965164 2012426 2012426 plaintiff Barker Richard (legal representative) 591362 591362 Barker, Richard, of Neylond, executor of 0
3987859 2020404 2020404 defendant Preston George draper 591362 591362 Preston, George, of Neylond, draper 0
4436898 2176280 2176280 defendant Plante Thomas   591362 591362 Plante, Thomas, of Neylond, son of Roger 2
4463720 2189341 2189341 defendant Bernard John dyer 591362 591362 Bernard, John, of Neylond, dyer 4
4463729 2189342 2189342 defendant Bernard John dyer 591362 591362 Bernard, John, of Neylond, dyer 4
4467061 2190368 2190368 defendant Rysnges James   591362 591362 Rysnges, James, of Neylond 0
4467063 2190368 2190368 defendant Frere John   591362 591362 Frere, John, of Neylond 2
4490651 2197775 2197775 defendant Bal John   591362 591362 Bal, John, of Neylond 0
4490652 2197775 2197775 defendant Baketon John smith 591362 591362 Baketon, John, of Neylond, smith 1
4490653 2197775 2197775 defendant Gegg Miles   591362 591362 Gegg, Miles, of Neylond 2
4490655 2197775 2197775 defendant Smyth Thomas   591362 591362 Smyth, Thomas, of Neylond 4
4490656 2197775 2197775 defendant Waryn Walter dyer 591362 591362 Waryn, Walter, of Neylond, dyer 5
4526603 2208598 2208598 plaintiff Lane Robert   591362 591362 Lane, Robert, of Neylond 0
4531886 2210237 2210237 defendant Noble Agnes   591362 591362 Noble, Agnes, of Neylond 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);