names

362 rows where place_id = 598030

✎ 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
3630811 1904458 1904458 defendant Wilmyns John sherman 598030 598030 Wilmyns, John, of Ludlowe, sherman 2
3645232 1908916 1908916 plaintiff Gittons Lewis   598030 598030 Gittons, Lewis, of Ludlowe, yeoman, servant of Pole, Owen 0
3645610 1909024 1909024 plaintiff Gyttons Lewis yeoman 598030 598030 Gyttons, Lewis, of Ludlowe, yeoman 0
3647160 1909502 1909502 defendant Alexander Philip chapman 598030 598030 Alexander, Philip, of Ludlowe, chapman 3
3657178 1912510 1912510 defendant Belamy Thomas skinner 598030 598030 Belamy, Thomas, of Ludlowe, skinner 3
3676813 1918785 1918785 defendant Lane Richard merchant 598030 598030 Lane, Richard, of Ludlowe, merchant 0
3677007 1918846 1918846 defendant Rogers Walter mercer 598030 598030 Rogers, Walter, of Ludlowe, mercer 0
3677074 1918869 1918869 plaintiff Lane John (legal representative) 598030 598030 Lane, John, of Ludlowe, clothier, executors of 0
3677381 1918975 1918975 defendant Cressett Thomas esq 598030 598030 Cressett, Thomas, of Ludlowe, esq 0
3680523 1919989 1919989 defendant Hatton Richard gent 598030 598030 Hatton, Richard, of Ludlowe, gent 1
3681035 1920144 1920144 defendant Marche John yeoman 598030 598030 Marche, John, of Ludlowe, yeoman 0
3681037 1920144 1920144 defendant Perys Richard butcher 598030 598030 Perys, Richard, of Ludlowe, butcher 2
3693924 1924304 1924304 defendant Fysher Joyce widow 598030 598030 Fysher, Joyce, of Ludlowe, widow 0
3705919 1928136 1928136 defendant Fox William gent 598030 598030 Fox, William, of Ludlowe, gent 0
3715003 1930988 1930988 defendant Evans John   598030 598030 Evans, John, of Ludlowe, mercer, adminsitrators of 0
3747805 1941234 1941234 defendant Lane Richard (legal representative) 598030 598030 Lane, Richard, of Ludlowe, merchant, executrix of 5
3747806 1941234 1941234 defendant Lane Margaret widow 598030 598030 Lane, Margaret, of Ludlowe, , widow 6
3757345 1944276 1944276 defendant Phelyppys Thomas yeoman 598030 598030 Phelyppys, Thomas, of Ludlowe, yeoman 0
3757494 1944317 1944317 defendant Hybbyn Thomas yeoman 598030 598030 Hybbyn, Thomas, of Ludlowe, yeoman 0
3762122 1945795 1945795 defendant Clee Henry smith 598030 598030 Clee, Henry, of Ludlowe, smith 0
3813228 1962047 1962047 defendant Selman Richard gent 598030 598030 Selman, Richard, of Ludlowe, gent 0
3819854 1964091 1964091 defendant Pykeryng Henry capper 598030 598030 Pykeryng, Henry, of Ludlowe, capper 0
3823718 1965314 1965314 defendant Forde Peter yeoman 598030 598030 Forde, Peter, of Ludlowe, yeoman 3
3827416 1966439 1966439 plaintiff Bradshawe Roger   598030 598030 Bradshawe, Roger, of Ludlowe 0
3846940 1972583 1972583 plaintiff Dyer Margaret widow 598030 598030 Dyer, Margaret, of Ludlowe, widow 2
3846942 1972583 1972583 defendant Huncte or Hunt or Hunter John weaver 598030 598030 Huncte or Hunt or Hunter, John, of Ludlowe, weaver 1
3849388 1973406 1973406 defendant Dod William gent 598030 598030 Dod, William, of Ludlowe, gent 0
3858532 1976333 1976333 defendant Hucke John weaver 598030 598030 Hucke, John, of Ludlowe, weaver 1
3863524 1977996 1977996 defendant Yetton Richard butcher 598030 598030 Yetton, Richard, of Ludlowe, butcher 1
3866953 1979186 1979186 plaintiff Roberte John gent 598030 598030 Roberte, John, of Ludlowe, gent 0
3893440 1988034 1988034 defendant Cawfyld Humphrey gent 598030 598030 Cawfyld, Humphrey, of Ludlowe, gent 0
3893441 1988034 1988034 defendant Rycharde Richard courser or corvyser 598030 598030 Rycharde, Richard, of Ludlowe, courser or corvyser 1
3893590 1988081 1988081 plaintiff Phillips William weaver 598030 598030 Phillips, William, of Ludlowe, weaver 0
3893591 1988081 1988081 defendant Jurden William gent 598030 598030 Jurden, William, of Ludlowe, gent 0
3893592 1988082 1988082 plaintiff Phillips William weaver 598030 598030 Phillips, William, of Ludlowe, weaver 0
3893593 1988082 1988082 defendant Jurden William gent 598030 598030 Jurden, William, of Ludlowe, gent 0
3901479 1990717 1990717 defendant Lewys alias Draper John mercer 598030 598030 Lewys alias Draper, John, of Ludlowe, mercer 0
3905184 1991998 1991998 defendant Griffith William weaver 598030 598030 Griffith, William, of Ludlowe, weaver 0
3929433 2000187 2000187 defendant Phyllyppes Lewis capper 598030 598030 Phyllyppes, Lewis, of Ludlowe, capper 0
3948910 2006684 2006684 defendant Coxs John gent 598030 598030 Coxs, John, of Ludlowe, gent 0
3974974 2015808 2015808 defendant Becke Lawrence chapman 598030 598030 Becke, Lawrence, of Ludlowe, chapman 3
3980590 2017821 2017821 defendant Rawlyns John saddler 598030 598030 Rawlyns, John, of Ludlowe, saddler 0
3980659 2017847 2017847 defendant Chelmycke William butcher 598030 598030 Chelmycke, William, of Ludlowe, butcher 0
3982507 2018520 2018520 defendant Walker John mercer 598030 598030 Walker, John, of Ludlowe, mercer 1
3984724 2019294 2019294 defendant ap Howell Hugh cordwainer 598030 598030 ap Howell, Hugh, of Ludlowe, cordwainer 0
3984725 2019294 2019294 defendant ap Madock Richard ap David cordwainer 598030 598030 ap Madock, Richard ap David, of Ludlowe, cordwainer 1
3984727 2019294 2019294 defendant ap Hoell Eleanor spinster 598030 598030 ap Hoell, Eleanor, of Ludlowe, spinster 3
3984950 2019376 2019376 defendant ap Howell Hugh cordwainer 598030 598030 ap Howell, Hugh, of Ludlowe, cordwainer 0
3984951 2019376 2019376 defendant ap Madock Richard ap David cordwainer 598030 598030 ap Madock, Richard ap David, of Ludlowe, cordwainer 1
3984953 2019376 2019376 defendant ap Hoell Eleanor spinster 598030 598030 ap Hoell, Eleanor, of Ludlowe, spinster 3
3989996 2021175 2021175 plaintiff Becke Lawrence mercer 598030 598030 Becke, Lawrence, of Ludlowe, mercer 0
4005941 2026898 2026898 plaintiff Langford Thomas mercer 598030 598030 Langford, Thomas, of Ludlowe, mercer 0
4005948 2026900 2026900 plaintiff Pynner William mercer 598030 598030 Pynner, William, of Ludlowe, mercer 1
4017835 2031091 2031091 plaintiff Towneshend Henry esq 598030 598030 Towneshend, Henry, of Ludlowe, esq 1
4029147 2035067 2035067 defendant Madeley Edmund yeoman 598030 598030 Madeley, Edmund, of Ludlowe, yeoman 1
4029148 2035067 2035067 defendant Martyn Richard yeoman 598030 598030 Martyn, Richard, of Ludlowe, yeoman 2
4030285 2035485 2035485 defendant Holland Christopher butcher 598030 598030 Holland, Christopher, of Ludlowe, butcher 0
4030287 2035486 2035486 defendant Holland Christopher butcher 598030 598030 Holland, Christopher, of Ludlowe, butcher 0
4031781 2036027 2036027 defendant Bedowe Robert weaver 598030 598030 Bedowe, Robert, of Ludlowe, weaver 0
4031784 2036028 2036028 defendant Bedowe Robert weaver 598030 598030 Bedowe, Robert, of Ludlowe, weaver 0
4043875 2040259 2040259 defendant Swanson alias Kerver Richard yeoman 598030 598030 Swanson alias Kerver, Richard, of Ludlowe, yeoman 0
4043877 2040260 2040260 defendant Swanson alias Kerver Richard yeoman 598030 598030 Swanson alias Kerver, Richard, of Ludlowe, yeoman 0
4046911 2041349 2041349 plaintiff Sotherne George   598030 598030 Sotherne, George, of Ludlowe 0
4050416 2042579 2042579 defendant Harryes William walker 598030 598030 Harryes, William, of Ludlowe, walker 1
4053065 2043525 2043525 plaintiff Alsopp William gent 598030 598030 Alsopp, William, of Ludlowe, gent 0
4057928 2045218 2045218 plaintiff Canland Thomas mercer 598030 598030 Canland, Thomas, of Ludlowe, mercer 0
4059217 2045695 2045695 plaintiff Collyns Charles   598030 598030 Collyns, Charles, of Ludlowe 0
4059705 2045864 2045864 defendant Sotherne George baker 598030 598030 Sotherne, George, of Ludlowe, baker 2
4061833 2046629 2046629 defendant Bedwey Robert tailor 598030 598030 Bedwey, Robert, of Ludlowe, tailor 1
4062148 2046750 2046750 plaintiff Farre Richard mercer 598030 598030 Farre, Richard, of Ludlowe, mercer 0
4064297 2047508 2047508 plaintiff Grove Richard cutler 598030 598030 Grove, Richard, of Ludlowe, cutler 0
4064775 2047686 2047686 defendant Bubbe Robert tanner 598030 598030 Bubbe, Robert, of Ludlowe, tanner 0
4064776 2047686 2047686 defendant Edwyns William, senior smith 598030 598030 Edwyns, William, senior, of Ludlowe, smith 1
4064798 2047694 2047694 defendant Bubbe Robert tanner 598030 598030 Bubbe, Robert, of Ludlowe, tanner 0
4064799 2047694 2047694 defendant Edwyns William, senior smith 598030 598030 Edwyns, William, senior, of Ludlowe, smith 1
4065102 2047805 2047805 defendant Buffeton John husbandman 598030 598030 Buffeton, John, of Ludlowe, husbandman 1
4065885 2048092 2048092 defendant Pearne John   598030 598030 Pearne, John, of Ludlowe, felt maker 2
4068837 2049145 2049145 plaintiff Lane John   598030 598030 Lane, John, of Ludlowe 0
4073262 2050730 2050730 plaintiff Phelippes Maurice innholder 598030 598030 Phelippes, Maurice, of Ludlowe, innholder 0
4073294 2050738 2050738 plaintiff Phelyppes Maurice   598030 598030 Phelyppes, Maurice, of Ludlowe 0
4076931 2052036 2052036 defendant Canter Henry husbandman 598030 598030 Canter, Henry, of Ludlowe, husbandman 2
4077313 2052170 2052170 defendant Brewer John brewer 598030 598030 Brewer, John, of Ludlowe, brewer 0
4077338 2052177 2052177 defendant Brewer John brewer 598030 598030 Brewer, John, of Ludlowe, brewer 1
4078648 2052660 2052660 defendant Readynge Thomas   598030 598030 Readynge, Thomas, of Ludlowe, cook 3
4086886 2055601 2055601 defendant Nawlle or Nall Griffin clothier 598030 598030 Nawlle or Nall, Griffin, of Ludlowe, clothier 0
4086888 2055602 2055602 defendant Nawlle Griffin clothier 598030 598030 Nawlle, Griffin, of Ludlowe, clothier 0
4090836 2057011 2057011 defendant Alsop Thomas yeoman 598030 598030 Alsop, Thomas, of Ludlowe, yeoman 0
4090837 2057011 2057011 defendant Wygley Charles weaver 598030 598030 Wygley, Charles, of Ludlowe, weaver 1
4090839 2057011 2057011 defendant Browne George tailor 598030 598030 Browne, George, of Ludlowe, tailor 3
4090841 2057012 2057012 defendant Blowe John saddler 598030 598030 Blowe John, of Ludlowe, saddler 0
4090843 2057013 2057013 defendant Bold James weaver 598030 598030 Bold, James, of Ludlowe, weaver 0
4090845 2057014 2057014 defendant Prise John weaver 598030 598030 Prise, John, of Ludlowe, weaver 0
4090847 2057015 2057015 defendant Pryse John weaver 598030 598030 Pryse, John, of Ludlowe, weaver 0
4100184 2060398 2060398 defendant Butler Thomas gent 598030 598030 Butler, Thomas, of Ludlowe, gent 0
4105182 2062127 2062127 defendant Tayler Walter tanner 598030 598030 Tayler, Walter, of Ludlowe, tanner 0
4105183 2062127 2062127 defendant Roo Thomas hatter 598030 598030 Roo, Thomas, of Ludlowe, hatter 1
4118951 2067059 2067059 defendant Sonybanck Andrew goldsmith 598030 598030 Sonybanck, Andrew, of Ludlowe, goldsmith 0
4148970 2077760 2077760 defendant Farr Richard mercer 598030 598030 Farr, Richard, of Ludlowe, mercer 0
4149417 2077924 2077924 defendant Haughton Thomas yeoman 598030 598030 Haughton, Thomas, of Ludlowe, yeoman 0
4149820 2078066 2078066 defendant Crewe John yeoman 598030 598030 Crewe, John, of Ludlowe, yeoman 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);