names

280 rows where place_id = 587990

✎ 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
3593045 1865452 1865452 defendant Sherman Richard merchant 587990 587990 Sherman, Richard, of Ludlowe, Salop, merchant 3
3602479 1868436 1868436 defendant Tewe John draper 587990 587990 Tewe, John, of Ludlowe, Salop, draper 0
3603128 1868643 1868643 defendant Hanley Roger (legal representative) 587990 587990 Hanley, Roger, of Ludlowe, Salop, clerk, administrator of 0
3614334 1872138 1872138 defendant Persons William grocer 587990 587990 Persons, William, of Ludlowe, Salop, grocer 0
3630810 1904458 1904458 defendant Lane Richard mercer 587990 587990 Lane, Richard, of Ludlowe, Salop, mercer 1
3669916 1916536 1916536 defendant Fyssher Thomas yeoman 587990 587990 Fyssher, Thomas, of Ludlowe, Salop, yeoman 0
3676650 1918735 1918735 plaintiff Jonys William   587990 587990 Jonys, William, of Ludlowe, Salop 0
3689455 1922861 1922861 defendant Hybyn Thomas mercer 587990 587990 Hybyn, Thomas, of Ludlowe, Salop, mercer 0
3694730 1924556 1924556 defendant Penson Philip yeoman of the crown 587990 587990 Penson, Philip, of Ludlowe, Salop, yeoman of the crown 2
3694735 1924557 1924557 defendant Penson Philip yeoman of the crown 587990 587990 Penson, Philip, of Ludlowe, Salop, yeoman of the crown 2
3708952 1929092 1929092 defendant More William gent 587990 587990 More, William, of Ludlowe, Salop, gent 0
3708955 1929093 1929093 defendant More William gent 587990 587990 More, William, of Ludlowe, Salop, gent 0
3713435 1930515 1930515 defendant A Boothe George gent 587990 587990 A Boothe, George, of Ludlowe, Salop, gent 5
3715004 1930988 1930988 defendant Whithall Richard yeoman 587990 587990 (Whithall, Richard, of Ludlowe, Salop, yeoman 1
3720614 1932730 1932730 defendant Calfehill Humphrey gent 587990 587990 Calfehill, Humphrey, of Ludlowe, Salop, gent 0
3747803 1941234 1941234 defendant Bradshaa John mercer 587990 587990 Bradshaa, John, of Ludlowe, Salop, mercer 3
3778338 1950937 1950937 defendant Roger Walter chapman 587990 587990 Roger, Walter, of Ludlowe, Salop, chapman 4
3779302 1951250 1951250 defendant Porter Edward innholder 587990 587990 Porter, Edward, of Ludlowe, Salop, yeoman, alias of London, innholder 0
3780809 1951733 1951733 defendant Cheyne William gent 587990 587990 Cheyne, William, of Ludlowe, Salop, gent 0
3790070 1954710 1954710 defendant Davys Richard innholder 587990 587990 Davys, Richard, of Ludlowe, Salop, innholder 2
3823717 1965314 1965314 defendant Wode Humphrey yeoman 587990 587990 Wode, Humphrey, of Ludlowe, Salop, yeoman 2
3845904 1972276 1972276 defendant Thomlyns John chapman 587990 587990 Thomlyns, John, of Ludlowe, Salop, chapman 0
3846941 1972583 1972583 defendant Traunter John weaver 587990 587990 Traunter, John, of Ludlowe, Salop, weaver 0
3858531 1976333 1976333 defendant Traunter John weaver 587990 587990 Traunter, John, of Ludlowe, Salop, weaver 0
3883115 1984613 1984613 defendant Trantor John weaver 587990 587990 Trantor, John, of Ludlowe, Salop, weaver 0
3886001 1985569 1985569 defendant Lakyn William clothier 587990 587990 Lakyn, William, of Ludlowe, Salop, clothier 3
3889186 1986620 1986620 defendant Langford William mercer 587990 587990 Langford, William, of Ludlowe, Salop, mercer 1
3890913 1987223 1987223 defendant Poughuell William yeoman 587990 587990 Poughuell, William, of Ludlowe, Salop, yeoman 1
3890916 1987224 1987224 defendant Poughnell William yeoman 587990 587990 Poughnell, William, of Ludlowe, Salop, yeoman 1
3898019 1989544 1989544 defendant Laken William gent 587990 587990 Laken, William, of Ludlowe, Salop, gent 0
3898022 1989545 1989545 defendant Laken William gent 587990 587990 Laken, William, of Ludlowe, Salop, gent 0
3908651 1993188 1993188 defendant Lakyn William mercer 587990 587990 Lakyn, William, of Ludlowe, Salop, mercer 1
3914106 1995063 1995063 defendant Harbart Richard gent 587990 587990 Harbart, Richard, of Ludlowe, Salop, gent 0
3916629 1995935 1995935 defendant Hayteley Richard husbandman 587990 587990 Hayteley, Richard, of Ludlowe, Salop, husbandman 1
3918800 1996613 1996613 defendant Leckyn William chapman 587990 587990 Leckyn, William, of Ludlowe, Salop, chapman 0
3921358 1997486 1997486 defendant Alsop John yeoman 587990 587990 (Alsop, John, of Ludlowe, Salop, yeoman 2
3962451 2011457 2011457 defendant Atkynson Anthony   587990 587990 Atkynson, Anthony, of Ludlowe, Salop, card maker 0
3971124 2014456 2014456 defendant Coxe John gent 587990 587990 Coxe, John, of Ludlowe, Salop, gent 0
3974973 2015808 2015808 defendant Farre Richard chapman 587990 587990 Farre, Richard, of Ludlowe, Salop, chapman 2
3982504 2018519 2018519 defendant Walker John mercer 587990 587990 Walker, John, of Ludlowe, Salop, mercer 2
3982506 2018520 2018520 defendant Pynnar William vintner 587990 587990 Pynnar, William, of Ludlowe, Salop, vintner 0
3984941 2019372 2019372 defendant Becke Lawrence mercer 587990 587990 Becke, Lawrence, of Ludlowe, Salop, mercer 0
3990505 2021356 2021356 defendant Bouthe Charles gent 587990 587990 Bouthe, Charles, of Ludlowe, Salop, gent 0
3996143 2023375 2023375 plaintiff Damport John gent 587990 587990 Damport, John, of Ludlowe, Salop, gent 0
4002709 2025733 2025733 defendant Tomlyns Margery widow 587990 587990 Tomlyns, Margery, of Ludlowe, Salop, widow 4
4005947 2026900 2026900 plaintiff Langforde Thomas tanner 587990 587990 Langforde, Thomas, of Ludlowe, Salop, tanner 0
4006861 2027231 2027231 defendant Plont James yeoman 587990 587990 Plont, James, of Ludlowe, Salop, or of Congleton, Cheshire, yeoman 0
4008910 2027950 2027950 defendant Holland George chapman 587990 587990 Holland, George, of Ludlowe, Salop, chapman 0
4010613 2028567 2028567 defendant Vaughan Richard   587990 587990 Vaughan, Richard, of Ludlowe, Salop, gent, Queen's Solicitor, council in the march of Wales 0
4015742 2030321 2030321 defendant Asbache Thomas chapman 587990 587990 Asbache, Thomas, of Ludlowe, Salop, chapman 2
4017834 2031091 2031091 plaintiff Towneshend Robert esq 587990 587990 Towneshend, Robert, of Ludlowe, Salop, esq 0
4029146 2035067 2035067 defendant Clare Francis gent 587990 587990 Clare, Francis, of Ludlowe, Salop, gent 0
4029408 2035155 2035155 plaintiff Damport John gent 587990 587990 Damport, John, of Ludlowe, Salop, gent 0
4035851 2037492 2037492 defendant Bower Thomas capper 587990 587990 Bower, Thomas, of Ludlowe, Salop, capper 3
4035856 2037493 2037493 defendant Boower Thomas capper 587990 587990 Boower, Thomas, of Ludlowe, Salop, capper 3
4036663 2037795 2037795 defendant Mason Robert gent 587990 587990 Mason, Robert, of Ludlowe, Salop, gent 0
4036665 2037796 2037796 defendant Mason Robert gent 587990 587990 Mason, Robert, of Ludlowe, Salop, gent 0
4043015 2039976 2039976 defendant Gryffyth John yeoman 587990 587990 Gryffyth, John, of Ludlowe, Salop, yeoman 0
4058121 2045284 2045284 defendant Alsoppe William gent 587990 587990 Alsoppe, William, of Ludlowe, Salop, gent 0
4060138 2046028 2046028 plaintiff Crowther John mercer 587990 587990 Crowther, John, of Ludlowe, Salop, mercer 0
4063077 2047095 2047095 defendant Crowther Edward mercer 587990 587990 Crowther, Edward, of Ludlowe, Salop, mercer 1
4065409 2047918 2047918 defendant Wheler Humphrey gent 587990 587990 Wheler, Humphrey, of Ludlowe, Salop, gent, son of Thomas Wheler, of Ludlowe, gent 1
4068841 2049146 2049146 plaintiff Lane John mercer 587990 587990 Lane, John, of Ludlowe, Salop, mercer 0
4069640 2049426 2049426 plaintiff Lovett John mercer 587990 587990 Lovett, John, of Ludlowe, Salop, mercer 0
4074304 2051109 2051109 defendant Gwynne Richard gent 587990 587990 Gwynne, Richard, of Ludlowe, Salop, gent 0
4075553 2051557 2051557 defendant Browne Richard chapman 587990 587990 Browne, Richard, of Ludlowe, Salop, chapman 0
4076929 2052036 2052036 defendant Rawlyns John saddler 587990 587990 Rawlyns, John, of Ludlowe, Salop, saddler 0
4076930 2052036 2052036 defendant Barrett Thomas husbandman 587990 587990 Barrett, Thomas, of Ludlowe, Salop, husbandman 1
4080790 2053443 2053443 defendant Gwynne Richard gent 587990 587990 Gwynne, Richard, of Ludlowe, Salop, gent 0
4083804 2054481 2054481 defendant Coxe Richard yeoman 587990 587990 Coxe, Richard, of Ludlowe, Salop, yeoman 3
4100872 2060629 2060629 defendant Gwynne Richard gent 587990 587990 Gwynne, Richard, of Ludlowe, Salop, gent 0
4101262 2060756 2060756 defendant Passy John gent 587990 587990 Passy, John, of Ludlowe, Salop, gent 2
4101266 2060757 2060757 defendant Passye John gent 587990 587990 Passye, John, of Ludlowe, Salop, gent 2
4105580 2062276 2062276 defendant Badger John tanner 587990 587990 Badger, John, of Ludlowe, Salop, tanner 1
4107240 2062883 2062883 defendant Sakeforde Thomas gent 587990 587990 Sakeforde, Thomas, of Ludlowe, Salop, gent 1
4108108 2063173 2063173 defendant Lovett John mercer 587990 587990 Lovett, John, of Ludlowe, Salop, mercer 0
4116553 2066208 2066208 defendant Badger John tanner 587990 587990 Badger, John, of Ludlowe, Salop, tanner 0
4134213 2072560 2072560 defendant Beste John mercer 587990 587990 Beste, John, of Ludlowe, Salop, mercer 0
4135511 2073023 2073023 defendant Crowther John chapman 587990 587990 Crowther, John, of Ludlowe, Salop, chapman 0
4143626 2075927 2075927 defendant Boothe John gent 587990 587990 Boothe, John, of Ludlowe, Salop, gent 2
4147498 2077267 2077267 defendant Beck John clothier 587990 587990 Beck, John, of Ludlowe, Salop, clothier 1
4153255 2079236 2079236 defendant Crowther Edward chapman 587990 587990 Crowther, Edward, of Ludlowe, Salop, chapman 0
4153257 2079237 2079237 defendant Crowther Edward chapman 587990 587990 Crowther, Edward, of Ludlowe, Salop, chapman 0
4159095 2081250 2081250 defendant Crowther John chapman 587990 587990 Crowther, John, of Ludlowe, Salop, chapman 0
4159097 2081251 2081251 defendant Morton Henry chapman 587990 587990 Morton, Henry, of Ludlowe, Salop, chapman 0
4159099 2081252 2081252 defendant Crowther Edward chapman 587990 587990 Crowther, Edward, of Ludlowe, Salop, chapman 0
4177305 2087534 2087534 defendant Cootes Thomas yeoman 587990 587990 Cootes, Thomas, of Ludlowe, Salop, yeoman 2
4177309 2087535 2087535 defendant Cootes Thomas yeoman 587990 587990 Cootes, Thomas, of Ludlowe, Salop, yeoman 2
4181110 2088868 2088868 defendant Browne William gent 587990 587990 Browne, William, of Ludlowe, Salop, gent 1
4181237 2088916 2088916 defendant Browne William gent 587990 587990 Browne, William, of Ludlowe, Salop, gent 1
4191493 2092590 2092590 defendant Lovett John mercer 587990 587990 Lovett, John, of Ludlowe, Salop, mercer 4
4193926 2093438 2093438 defendant Dedycott Walter capper 587990 587990 Dedycott, Walter, of Ludlowe, Salop, capper 0
4193934 2093439 2093439 defendant Thomas Richard   587990 587990 Thomas, Richard, of Ludlowe, Salop, felt maker 3
4202676 2096478 2096478 defendant Coxe Richard yeoman 587990 587990 Coxe, Richard, of Ludlowe, Salop, yeoman 2
4202683 2096480 2096480 defendant Thorneton Simon gent 587990 587990 Thorneton, Simon, of Ludlowe, Salop, gent 0
4212311 2099852 2099852 defendant Sherman Walter butcher 587990 587990 Sherman, Walter, of Ludlowe, Salop, or of Worcester, butcher 0
4212313 2099853 2099853 defendant Sherman Walter butcher 587990 587990 Sherman, Walter, of Ludlowe, Salop, or of Worcester, butcher 0
4213249 2100150 2100150 defendant Crowther John mercer 587990 587990 Crowther, John, of Ludlowe, Salop, mercer 0
4215541 2100933 2100933 defendant Nawle Griffin clothier 587990 587990 Nawle, Griffin, of Ludlowe, Salop, clothier 0
4218114 2101833 2101833 defendant Hooke alias Watters Richard yeoman 587990 587990 Hooke alias Watters, Richard, of Ludlowe, Salop, yeoman 2

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