names

302 rows where place_id = 587052

✎ 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
3589286 1864290 1864290 defendant Metham Thomas   587052 587052 Metham, Thomas, of Beverley, Yorks, knight 0
3590340 1864620 1864620 defendant Sprotley Richard clerk 587052 587052 Sprotley, Richard, of Beverley, Yorks, clerk 0
3594186 1865824 1865824 defendant Ledys John gent 587052 587052 Ledys, John, of Beverley, Yorks, gent 1
3604813 1869172 1869172 defendant Johnson John chapman 587052 587052 Johnson, John, of Beverley, Yorks, chapman 2
3604817 1869173 1869173 defendant Johnson John chapman 587052 587052 Johnson, John, of Beverley, Yorks, chapman 2
3605472 1869377 1869377 defendant Johnson John merchant 587052 587052 Johnson, John, of Beverley, Yorks, merchant 0
3615752 1872567 1872567 plaintiff Copyndale Stephen (legal representative) 587052 587052 Copyndale, Stephen, of Beverley, Yorks, gent, son of Coppyndale, John, of Beverley, executors of 0
3619432 1873652 1873652 defendant Keby William yeoman 587052 587052 Keby, William, of Beverley, Yorks, yeoman 5
3620887 1874096 1874096 defendant Berton John mercer 587052 587052 Berton, John, of Beverley, Yorks, or of London, mercer 1
3682982 1920790 1920790 defendant Blakborne William chapman 587052 587052 Blakborne, William, of Beverley, Yorks, chapman 2
3712476 1930219 1930219 defendant Hunter William yeoman 587052 587052 Hunter, William, of Beverley, Yorks, yeoman 0
3719443 1932353 1932353 defendant Wellemet John chapman 587052 587052 Wellemet, John, of Beverley, Yorks, chapman 7
3753224 1942950 1942950 defendant Rassells Robert pewterer 587052 587052 Rassells, Robert, of Beverley, Yorks, pewterer 0
3763231 1946137 1946137 defendant Wellymot John chapman 587052 587052 Wellymot, John, of Beverley, Yorks, chapman 0
3763272 1946146 1946146 defendant Wellemott John chapman 587052 587052 Wellemott, John, of Beverley, Yorks, chapman 0
3772277 1949017 1949017 defendant Eldergare Ralph   587052 587052 Eldergare, Ralph, of Beverley, Yorks, knight 3
3778736 1951065 1951065 defendant Wode Richard ironmonger 587052 587052 Wode, Richard, of Beverley, Yorks, merchant, alias of London, ironmonger 0
3786075 1953436 1953436 defendant Wood Richard ironmonger 587052 587052 Wood, Richard, of Beverley, Yorks, merchant, alias of London, ironmonger 0
3789197 1954436 1954436 defendant Wood Richard ironmonger 587052 587052 Wood, Richard, of Beverley, Yorks, merchant, alias of London, ironmonger 0
3809196 1960757 1960757 defendant Grenne George chapman 587052 587052 Grenne, George, of Beverley, Yorks, chapman 2
3826602 1966168 1966168 defendant Markek Robert innholder 587052 587052 Markek, Robert, of Beverley, Yorks, innholder 4
3836685 1969373 1969373 defendant Fetherston Robert draper 587052 587052 Fetherston, Robert, of Beverley, Yorks, draper 0
3850280 1973674 1973674 defendant Whyte John merchant of the staple 587052 587052 Whyte, John, of Beverley, Yorks, merchant of the staple 4
3852700 1974452 1974452 defendant Fetherston Robert draper 587052 587052 Fetherston, Robert, of Beverley, Yorks, draper 0
3857419 1975955 1975955 defendant Crawe John draper 587052 587052 Crawe, John, of Beverley, Yorks, draper 0
3857422 1975956 1975956 defendant Crawe John draper 587052 587052 Crawe, John, of Beverley, Yorks, draper 0
3857428 1975958 1975958 defendant Cownrowe Ralph yeoman 587052 587052 Cownrowe, Ralph, of Beverley, Yorks, yeoman 0
3871140 1980599 1980599 defendant Cownrowe Ralph yeoman 587052 587052 Cownrowe, Ralph, of Beverley, Yorks, yeoman 0
3875152 1981926 1981926 defendant Creyke Robert esq 587052 587052 Creyke, Robert, of Beverley, Yorks, esq 1
3875171 1981934 1981934 defendant Creke Robert esq 587052 587052 Creke, Robert, of Beverley, Yorks, esq 1
3876524 1982394 1982394 defendant Grene George chapman 587052 587052 Grene, George, of Beverley, Yorks, chapman 1
3878621 1983096 1983096 defendant Haryson Roger draper 587052 587052 Haryson, Roger, of Beverley, Yorks, draper 3
3878680 1983117 1983117 defendant Grene George chapman 587052 587052 Grene, George, of Beverley, Yorks, chapman 4
3891490 1987419 1987419 defendant Smetheley Edward gent 587052 587052 Smetheley, Edward, of Beverley, Yorks, gent 0
3897253 1989298 1989298 defendant Barton Thomas gent 587052 587052 Barton, Thomas, of Beverley, Yorks, gent 0
3900325 1990342 1990342 defendant Nawton Matthew clerk 587052 587052 Nawton, Matthew, of Beverley, Yorks, clerk 0
3918791 1996611 1996611 defendant Farrar Christopher chapman 587052 587052 Farrar, Christopher, of Beverley, Yorks, chapman 1
3923596 1998201 1998201 defendant Browne Richard chapman 587052 587052 Browne, Richard, of Beverley, Yorks, chapman 0
3925413 1998814 1998814 defendant Browne Richard merchant 587052 587052 Browne, Richard, of Beverley, Yorks, merchant 0
3927763 1999624 1999624 defendant Fewell Richard chapman 587052 587052 Fewell, Richard, of Beverley, Yorks, chapman 0
3934519 2001838 2001838 defendant Lemyre Nicholas yeoman 587052 587052 Lemyre, Nicholas, of Beverley, Yorks, yeoman 1
3935164 2002070 2002070 defendant Fayreclyff Richard gent 587052 587052 Fayreclyff, Richard, of Beverley, Yorks, gent 1
3935167 2002071 2002071 defendant Fayreclyff Richard gent 587052 587052 Fayreclyff, Richard, of Beverley, Yorks, gent 1
3943239 2004758 2004758 defendant Musgrave Edmund esq 587052 587052 Musgrave, Edmund, of Beverley, Yorks, esq 1
3945044 2005363 2005363 defendant Davy John merchant 587052 587052 Davy, John, of Beverley, Yorks, merchant 0
3945076 2005371 2005371 defendant Davy John merchant 587052 587052 Davy, John, of Beverley, Yorks, merchant 0
3945595 2005535 2005535 defendant Fewle Richard merchant 587052 587052 Fewle, Richard, of Beverley, Yorks, merchant 0
3945835 2005618 2005618 defendant Fayreclyff Richard (legal representative) 587052 587052 Fayreclyff, Richard, of Beverley, Yorks, gent, executors of 0
3951703 2007652 2007652 defendant Ardyngton Nicholas chapman 587052 587052 Ardyngton, Nicholas, of Beverley, Yorks, chapman 0
3952848 2008072 2008072 defendant Mayne Christopher gent 587052 587052 Mayne, Christopher, of Beverley, Yorks, gent 0
3953950 2008452 2008452 defendant Denton Hugh yeoman or chapman 587052 587052 Denton, Hugh, of Beverley, Yorks, yeoman or chapman 0
3954360 2008596 2008596 defendant Musgrave Simon gent 587052 587052 Musgrave, Simon, of Beverley, Yorks, gent 0
3955094 2008845 2008845 defendant Davye John merchant 587052 587052 Davye, John, of Beverley, Yorks, merchant 0
3957115 2009556 2009556 defendant Musgrave Simon esq 587052 587052 Musgrave, Simon, of Beverley, Yorks, esq 0
3959030 2010240 2010240 defendant Mayne Christopher gent 587052 587052 Mayne, Christopher, of Beverley, Yorks, gent 0
3962560 2011496 2011496 defendant Lowthare Thomas tailor 587052 587052 Lowthare, Thomas, of Beverley, Yorks, tailor 1
3964622 2012232 2012232 defendant Davye John merchant 587052 587052 Davye, John, of Beverley, Yorks, merchant 0
3971910 2014735 2014735 defendant Willoughfelde Richard yeoman 587052 587052 Willoughfelde, Richard, of Beverley, Yorks, yeoman 0
3973605 2015339 2015339 plaintiff Gylbye Edmund yeoman 587052 587052 Gylbye, Edmund, of Beverley, Yorks, yeoman 0
3973607 2015340 2015340 plaintiff Gylbye Edmund yeoman 587052 587052 Gylbye, Edmund, of Beverley, Yorks, yeoman 0
3990569 2021378 2021378 defendant Reade Richard gent 587052 587052 Reade, Richard, of Beverley, Yorks, gent 0
3990729 2021438 2021438 defendant Reade Richard gent 587052 587052 Reade, Richard, of Beverley, Yorks, gent 0
3990743 2021444 2021444 defendant Storye Henry chapman 587052 587052 Storye, Henry, of Beverley, Yorks, chapman 0
3991761 2021808 2021808 defendant Reade Richard gent 587052 587052 Reade, Richard, of Beverley, Yorks, gent 0
4003965 2026188 2026188 defendant Dawson George yeoman 587052 587052 Dawson, George, of Beverley, Yorks, yeoman 0
4007806 2027575 2027575 plaintiff Mathewe Thomas tanner 587052 587052 Mathewe, Thomas, of Beverley, Yorks, tanner 0
4012378 2029148 2029148 defendant Wylbreforce Thomas chapman 587052 587052 Wylbreforce, Thomas, of Beverley, Yorks, chapman 0
4012382 2029149 2029149 defendant Wylbreforse Thomas chapman 587052 587052 Wylbreforse, Thomas, of Beverley, Yorks, chapman 0
4015853 2030356 2030356 plaintiff Spaldynge Christopher cordwainer 587052 587052 Spaldynge, Christopher, of Beverley, Yorks, cordwainer 0
4022057 2032619 2032619 defendant Harryson Robert mariner 587052 587052 Harryson, Robert, of Beverley, Yorks, mariner 2
4022062 2032620 2032620 defendant Herryson Robert mariner 587052 587052 Herryson, Robert, of Beverley, Yorks, mariner 2
4024552 2033456 2033456 defendant Webster Richard draper 587052 587052 Webster, Richard, of Beverley, Yorks, draper 0
4024564 2033462 2033462 defendant Webster Richard draper 587052 587052 Webster, Richard, of Beverley, Yorks, draper 0
4043517 2040141 2040141 defendant Robson George chapman 587052 587052 Robson, George, of Beverley, Yorks, chapman 1
4044464 2040475 2040475 plaintiff Rede Richard gent 587052 587052 Rede, Richard, of Beverley, Yorks, gent 0
4044467 2040476 2040476 plaintiff Rede Richard gent 587052 587052 Rede, Richard, of Beverley, Yorks, gent 0
4044470 2040477 2040477 plaintiff Rede Richard gent 587052 587052 Rede, Richard, of Beverley, Yorks, gent 0
4044473 2040478 2040478 plaintiff Rede Richard gent 587052 587052 Rede, Richard, of Beverley, Yorks, gent 0
4056917 2044857 2044857 defendant Peresye Robert gent 587052 587052 Peresye, Robert, of Beverley, Yorks, gent 0
4060348 2046102 2046102 defendant Mayney Christopher gent 587052 587052 Mayney, Christopher, of Beverley, Yorks, gent 0
4062357 2046825 2046825 defendant Wedofeld Richard mercer 587052 587052 Wedofeld, Richard, of Beverley, Yorks, mercer 0
4062418 2046847 2046847 defendant Spencer Roger chapman 587052 587052 Spencer, Roger, of Beverley, Yorks, chapman 0
4070780 2049846 2049846 defendant Wydefeld Richard chapman 587052 587052 Wydefeld, Richard, of Beverley, Yorks, chapman 0
4090570 2056909 2056909 defendant Wood William chapman 587052 587052 Wood, William, of Beverley, Yorks, chapman 3
4094395 2058336 2058336 defendant Came or Caine Stephen baker 587052 587052 Came or Caine, Stephen, of Beverley, Yorks, baker 0
4098974 2059957 2059957 defendant Burdex Henry gent 587052 587052 Burdex, Henry, of Beverley, Yorks, gent 1
4099427 2060124 2060124 defendant Wydefelde Richard chapman 587052 587052 Wydefelde, Richard, of Beverley, Yorks, chapman 2
4099436 2060126 2060126 defendant Wrighte Richard chapman 587052 587052 Wrighte, Richard, of Beverley, Yorks, chapman 2
4114073 2065315 2065315 defendant Grene Jenetta spinster 587052 587052 Grene, Jenetta, of Beverley, Yorks, spinster 0
4122219 2068251 2068251 defendant Clarke Robert yeoman 587052 587052 Clarke, Robert, of Beverley, Yorks, yeoman 0
4122221 2068252 2068252 defendant Clarke Robert yeoman 587052 587052 Clarke, Robert, of Beverley, Yorks, yeoman 0
4137415 2073732 2073732 defendant Browne Thomas saddler 587052 587052 Browne, Thomas, of Beverley, Yorks, saddler 0
4138394 2074098 2074098 defendant Wade or Wayde Philip saddler 587052 587052 Wade or Wayde, Philip, of Beverley, Yorks, saddler 0
4155260 2079933 2079933 defendant Johnson William chapman 587052 587052 Johnson, William, of Beverley, Yorks, chapman 0
4161406 2082068 2082068 defendant Hylltard William esq 587052 587052 Hylltard, William, of Beverley, Yorks, esq 0
4165323 2083378 2083378 defendant Davye Alan yeoman 587052 587052 Davye, Alan, of Beverley, Yorks, yeoman 0
4165325 2083379 2083379 defendant Davye Alan yeoman 587052 587052 Davye, Alan, of Beverley, Yorks, yeoman 0
4172118 2085709 2085709 defendant Fletcher Simon tanner 587052 587052 Fletcher, Simon, of Beverley, Yorks, tanner 0
4172882 2085969 2085969 defendant Hardye Francis haberdasher 587052 587052 Hardye, Francis, of Beverley, Yorks, haberdasher 0
4172886 2085970 2085970 defendant Hardye Francis haberdasher 587052 587052 Hardye, Francis, of Beverley, Yorks, haberdasher 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);