names

419 rows where place_id = 586349

✎ 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
3588502 1864049 1864049 defendant Trowbrigge Richard yeoman 586349 586349 Trowbrigge, Richard, of Bradford, yeoman 2
3603608 1868797 1868797 defendant Stephyns John dyer 586349 586349 Stephyns, John, of Bradford, dyer 1
3603609 1868797 1868797 defendant Harden John yeoman 586349 586349 Harden, John, of Bradford, yeoman 2
3603766 1868848 1868848 defendant Hewet Roger yeoman 586349 586349 Hewet, Roger, of Bradford, yeoman 0
3610413 1870916 1870916 defendant Mantell John clerk 586349 586349 Mantell, John, of Bradford, clerk 0
3615560 1872506 1872506 defendant Lutcombe Nicholas clothier 586349 586349 Lutcombe, Nicholas, of Bradford, clothier 0
3616879 1872912 1872912 defendant Everard Thomas husbandman 586349 586349 Everard, Thomas, of Bradford, husbandman 0
3624993 1875350 1875350 defendant Davy John weaver 586349 586349 Davy, John, of Bradford, weaver 0
3627538 1903473 1903473 defendant Jamys Thomas fisher 586349 586349 Jamys, Thomas, of Bradford, fisher 0
3636345 1906161 1906161 defendant Wylkynson Leonard yeoman 586349 586349 Wylkynson, Leonard, of Bradford, yeoman 0
3636346 1906161 1906161 defendant Halstede Percival sherman 586349 586349 Halstede, Percival, of Bradford, sherman 1
3636347 1906161 1906161 defendant Ellys Robert sherman 586349 586349 Ellys, Robert, of Bradford, sherman 2
3636348 1906161 1906161 defendant Thornton William sherman 586349 586349 Thornton, William, of Bradford, sherman 3
3636349 1906161 1906161 defendant Kyrby William sherman 586349 586349 Kyrby, William, of Bradford, sherman 4
3636350 1906161 1906161 defendant Mortymer Thomas husbandman 586349 586349 Mortymer, Thomas, of Bradford, husbandman 5
3639603 1907197 1907197 defendant Weysdale William yeoman 586349 586349 Weysdale, William, of Bradford, yeoman 0
3644862 1908803 1908803 defendant Aysshe Christopher husbandman 586349 586349 Aysshe, Christopher, of Bradford, husbandman 0
3654020 1911519 1911519 defendant Wottes William clothman 586349 586349 Wottes, William, of Bradford, clothman 3
3664234 1914761 1914761 defendant Legeard Christopher yeoman 586349 586349 Legeard, Christopher, of Bradford, yeoman 0
3674859 1918164 1918164 defendant Tompson Walter carpenter 586349 586349 Tompson, Walter, of Bradford, carpenter 0
3675129 1918249 1918249 defendant Rowsewell Richard husbandman 586349 586349 Rowsewell, Richard, of Bradford, husbandman 0
3676136 1918576 1918576 defendant Hall William gent 586349 586349 Hall, William, of Bradford, gent 1
3681442 1920284 1920284 defendant Mere Thomas fisher 586349 586349 Mere, Thomas, of Bradford, fisher 0
3681443 1920284 1920284 defendant Mondy Michael fisher 586349 586349 Mondy, Michael, of Bradford, fisher 1
3681444 1920284 1920284 defendant Brendon John husbandman 586349 586349 Brendon, John, of Bradford, husbandman 2
3681445 1920284 1920284 defendant Harman John husbandman 586349 586349 Harman, John, of Bradford, husbandman 3
3687095 1922134 1922134 defendant Dawson Nicholas tanner 586349 586349 Dawson, Nicholas, of Bradford, tanner 1
3695931 1924967 1924967 defendant Rowsewell John husbandman 586349 586349 Rowsewell, John, of Bradford, husbandman 0
3696398 1925098 1925098 defendant Haldworth John weaver 586349 586349 Haldworth, John, of Bradford, weaver 0
3712726 1930295 1930295 defendant Rede George yeoman 586349 586349 Rede, George, of Bradford, yeoman 4
3713619 1930570 1930570 defendant Beause John husbandman 586349 586349 Beause, John, of Bradford, husbandman 2
3714894 1930954 1930954 defendant Bole Richard smith 586349 586349 Bole, Richard, of Bradford, smith 2
3719271 1932313 1932313 defendant Pykeryng William husbandman 586349 586349 Pykeryng, William, of Bradford, husbandman 0
3721553 1933046 1933046 defendant Pekeryng William husbandman 586349 586349 Pekeryng, William, of Bradford, husbandman 0
3731875 1936201 1936201 defendant Dawson Nicholas tanner 586349 586349 Dawson, Nicholas, of Bradford, tanner 0
3731876 1936201 1936201 defendant Gelles Thomas yeoman 586349 586349 Gelles, Thomas, of Bradford, yeoman 1
3731905 1936210 1936210 defendant Dawson Nicholas tanner 586349 586349 Dawson, Nicholas, of Bradford, tanner 0
3731906 1936210 1936210 defendant Gelles Thomas yeoman 586349 586349 Gelles, Thomas, of Bradford, yeoman 1
3735193 1937240 1937240 defendant Sydnam Thomas grasier 586349 586349 Sydnam, Thomas, of Bradford, grasier 2
3735194 1937240 1937240 defendant Rossewell Robert husbandman 586349 586349 Rossewell, Robert, of Bradford, husbandman 3
3740451 1938871 1938871 defendant Rowsewell John husbandman 586349 586349 Rowsewell, John, of Bradford, husbandman 0
3740455 1938871 1938871 defendant Rowsewell Robert husbandman 586349 586349 Rowsewell, Robert, of Bradford, husbandman 4
3740460 1938873 1938873 defendant Rowsewell Robert husbandman 586349 586349 Rowsewell, Robert, of Bradford, husbandman 1
3740461 1938873 1938873 defendant Dene Robert husbandman 586349 586349 Dene, Robert, of Bradford, husbandman 2
3744619 1940212 1940212 defendant Drynkwater John husbandman 586349 586349 Drynkwater, John, of Bradford, husbandman 2
3752871 1942821 1942821 defendant Rowsewell Robert husbandman 586349 586349 Rowsewell, Robert, of Bradford, husbandman 1
3753935 1943179 1943179 defendant Mere Thomas husbandman 586349 586349 Mere, Thomas, of Bradford, husbandman 0
3753936 1943179 1943179 defendant Dene Robert husbandman 586349 586349 Dene, Robert, of Bradford, husbandman 1
3777585 1950741 1950741 defendant Bayly William clothman 586349 586349 Bayly, William, of Bradford, clothman 3
3783240 1952511 1952511 defendant Gelles Thomas   586349 586349 Gelles, Thomas, of Bradford 0
3783346 1952543 1952543 defendant Somerstales John yeoman 586349 586349 Somerstales, John, of Bradford, yeoman 0
3783575 1952620 1952620 defendant Jefferey Edmund ropemaker 586349 586349 Jefferey, Edmund, of Bradford, ropemaker 0
3783902 1952739 1952739 defendant Kent John clothman 586349 586349 Kent, John, of Bradford, clothman 0
3796624 1956820 1956820 defendant Phillyp Thomas (legal representative) 586349 586349 Phillyp, Thomas, of Bradford, executor of 0
3796627 1956821 1956821 defendant Phillyp Thomas (legal representative) 586349 586349 Phillyp, Thomas, of Bradford, executor of 0
3805023 1959514 1959514 defendant Baynebrigge William yeoman 586349 586349 Baynebrigge, William, of Bradford, yeoman 3
3805046 1959521 1959521 defendant Showte William husbandman 586349 586349 Showte, William, of Bradford, husbandman 0
3809000 1960696 1960696 defendant Heryson Richard husbandman 586349 586349 Heryson, Richard, of Bradford, husbandman 0
3817300 1963322 1963322 defendant Ventley Arthur yeoman 586349 586349 Ventley, Arthur, of Bradford, yeoman 1
3834838 1968835 1968835 defendant Paryn William husbandman 586349 586349 Paryn, William, of Bradford, husbandman 0
3836091 1969201 1969201 defendant Bowe Edward yeoman 586349 586349 Bowe, Edward, of Bradford, yeoman 2
3837743 1969719 1969719 defendant Dean Robert husbandman 586349 586349 Dean, Robert, of Bradford, husbandman 2
3838264 1969885 1969885 defendant Raynoldys Thomas yeoman 586349 586349 Raynoldys, Thomas, of Bradford, yeoman 1
3847094 1972643 1972643 defendant Albert Edmund husbandman 586349 586349 Albert, Edmund, of Bradford, husbandman 0
3848899 1973246 1973246 defendant Bayle Christopher tanner 586349 586349 Bayle, Christopher, of Bradford, tanner 0
3848900 1973246 1973246 defendant Longstale John tanner 586349 586349 Longstale, John, of Bradford, tanner 1
3848902 1973247 1973247 defendant Bentley Arthur yeoman 586349 586349 Bentley, Arthur, of Bradford, yeoman 0
3870075 1980233 1980233 defendant Lounge Richard husbandman 586349 586349 Lounge, Richard, of Bradford, husbandman 1
3870602 1980409 1980409 defendant Rowsewell John husbandman 586349 586349 Rowsewell, John, of Bradford, husbandman 0
3880646 1983792 1983792 defendant Rawlon Robert dyer 586349 586349 Rawlon, Robert, of Bradford, dyer 0
3881137 1983960 1983960 defendant Dene Robert husbandman 586349 586349 Dene, Robert, of Bradford, husbandman 3
3883207 1984645 1984645 defendant Rowsewyll Robert husbandman 586349 586349 Rowsewyll, Robert, of Bradford, husbandman 0
3886940 1985896 1985896 defendant Rowyswell John husbandman 586349 586349 Rowyswell, John, of Bradford, husbandman 0
3902379 1991027 1991027 defendant Rowswyll John drover 586349 586349 Rowswyll, John, of Bradford, yeoman, drover 0
3904963 1991921 1991921 defendant Rowswyll John husbandman 586349 586349 Rowswyll, John, of Bradford, husbandman 2
3905953 1992276 1992276 defendant Bogytt John husbandman 586349 586349 Bogytt, John, of Bradford, husbandman 2
3908090 1993003 1993003 defendant Gerryn William husbandman 586349 586349 Gerryn, William, of Bradford, husbandman 1
3909920 1993625 1993625 defendant Norman William husbandman 586349 586349 Norman, William, of Bradford, husbandman 2
3909981 1993645 1993645 defendant Danyell alias Cooke William husbandman 586349 586349 Danyell alias Cooke, William, of Bradford, husbandman 2
3920445 1997183 1997183 defendant Webbe William husbandman 586349 586349 Webbe, William, of Bradford, husbandman 1
3920789 1997299 1997299 defendant Bawman James husbandman 586349 586349 Bawman, James, of Bradford, husbandman 0
3921927 1997679 1997679 defendant Jamys Thomas husbandman 586349 586349 Jamys, Thomas, of Bradford, husbandman 0
3924995 1998675 1998675 defendant Everatt Roger husbandman 586349 586349 Everatt, Roger, of Bradford, husbandman 0
3929636 2000261 2000261 defendant Thornton John yeoman 586349 586349 Thornton, John, of Bradford, yeoman 1
3936667 2002590 2002590 defendant Collwyll John, senior husbandman 586349 586349 Collwyll, John, senior, of Bradford, husbandman 0
3936668 2002590 2002590 defendant Collwyll John, junior laborer 586349 586349 Collwyll, John, junior, of Bradford, laborer 1
3941361 2004118 2004118 defendant Stephyns William butcher 586349 586349 Stephyns, William, of Bradford, butcher 0
3950626 2007290 2007290 defendant Dawson Robert clothier 586349 586349 Dawson, Robert, of Bradford, clothier 0
3967634 2013316 2013316 plaintiff Byrley Henry (legal representative) 586349 586349 Byrley, Henry, of Bradford, executor of 0
3985861 2019707 2019707 defendant Tymewell Edmund   586349 586349 Tymewell, Edmund, of Bradford 0
4017948 2031134 2031134 plaintiff Trote William clothier 586349 586349 Trote, William, of Bradford, clothier 0
4026874 2034262 2034262 defendant Cavell William clerk 586349 586349 Cavell, William, of Bradford, clerk 0
4026924 2034279 2034279 plaintiff Catterall Robert gent 586349 586349 Catterall, Robert, of Bradford, gent 0
4044376 2040442 2040442 defendant Rideowte Edward tanner 586349 586349 Rideowte, Edward, of Bradford, tanner 0
4046853 2041327 2041327 defendant Reynold George yeoman 586349 586349 Reynold, George, of Bradford, yeoman 0
4049174 2042151 2042151 plaintiff Trote William clothier 586349 586349 Trote, William, of Bradford, clothier 0
4049987 2042426 2042426 plaintiff Walker William clothier 586349 586349 Walker, William, of Bradford, clothier 0
4049989 2042427 2042427 plaintiff Walker William clothier 586349 586349 Walker, William, of Bradford, clothier 0
4073544 2050825 2050825 defendant Dennyng alias Toker William husbandman 586349 586349 Dennyng alias Toker, William, of Bradford, husbandman 0
4074534 2051194 2051194 plaintiff Rawson Robert tanner 586349 586349 Rawson, Robert, of Bradford, tanner 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);