names

163 rows where place_id = 591688

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3605247 1869309 1869309 defendant Russell John yeoman 591688 591688 Russell, John, of Parshore, yeoman 0
3608387 1870282 1870282 defendant Leton Richard butcher 591688 591688 Leton, Richard, of Parshore, butcher 0
3622861 1874677 1874677 defendant Banham John yeoman 591688 591688 Banham, John, of Parshore, yeoman 0
3627619 1903500 1903500 defendant Bannam John yeoman 591688 591688 Bannam, John, of Parshore, yeoman 0
3635480 1905893 1905893 defendant Rudyng Roger yeoman 591688 591688 Rudyng, Roger, of Parshore, yeoman 0
3636248 1906128 1906128 defendant Rudyng Roger gent 591688 591688 Rudyng, Roger, of Parshore, gent 0
3636249 1906128 1906128 defendant Storre Robert yeoman 591688 591688 Storre, Robert, of Parshore, yeoman 1
3636250 1906128 1906128 defendant Symond Robert yeoman 591688 591688 Symond, Robert, of Parshore, yeoman 2
3636251 1906128 1906128 defendant Hall Nicholas yeoman 591688 591688 Hall, Nicholas, of Parshore, yeoman 3
3636252 1906128 1906128 defendant Aylleworth Henry laborer 591688 591688 Aylleworth, Henry, of Parshore, laborer 4
3656976 1912440 1912440 plaintiff Compton William   591688 591688 Compton, William, of Parshore, abbot of the monastery of St Mary & St Edburga 0
3664466 1914832 1914832 defendant Russell William butcher 591688 591688 Russell, William, of Parshore, butcher 2
3681933 1920453 1920453 defendant Fytchet John yeoman 591688 591688 Fytchet, John, of Parshore, yeoman 0
3684556 1921302 1921302 defendant Bavyn Sybil widow 591688 591688 Bavyn, Sybil, of Parshore, widow 1
3687727 1922329 1922329 defendant Turbotte Thomas mercer 591688 591688 Turbotte, Thomas, of Parshore, mercer 1
3689805 1922967 1922967 defendant Goodale John laborer 591688 591688 Goodale, John, of Parshore, laborer 3
3701681 1926769 1926769 plaintiff Browne John   591688 591688 Browne, John, of Parshore 0
3702816 1927153 1927153 defendant Perys Robert butcher 591688 591688 Perys, Robert, of Parshore, butcher 1
3702912 1927182 1927182 defendant Smyth Thomas butcher 591688 591688 Smyth, Thomas, of Parshore, butcher 3
3702913 1927182 1927182 defendant Yong John yeoman 591688 591688 Yong, John, of Parshore, yeoman 4
3702914 1927182 1927182 defendant Wootys William butcher 591688 591688 Wootys, William, of Parshore, butcher 5
3705518 1928012 1928012 defendant Cosnet William yeoman 591688 591688 Cosnet, William, of Parshore, yeoman 1
3705519 1928012 1928012 defendant Smythe Simon yeoman 591688 591688 Smythe, Simon, of Parshore, yeoman 2
3705520 1928012 1928012 defendant Lemster John yeoman 591688 591688 Lemster, John, of Parshore, yeoman 3
3705521 1928012 1928012 defendant Ledebery Thomas yeoman 591688 591688 Ledebery, Thomas, of Parshore, yeoman 4
3705522 1928012 1928012 defendant Shropshire Thomas yeoman 591688 591688 Shropshire, Thomas, of Parshore, yeoman 5
3705526 1928013 1928013 defendant Cosnet William yeoman 591688 591688 Cosnet, William, of Parshore, yeoman 1
3705527 1928013 1928013 defendant Smythe Simon yeoman 591688 591688 Smythe, Simon, of Parshore, yeoman 2
3705528 1928013 1928013 defendant Lemster John yeoman 591688 591688 Lemster, John, of Parshore, yeoman 3
3705529 1928013 1928013 defendant Ledebery Thomas yeoman 591688 591688 Ledebery, Thomas, of Parshore, yeoman 4
3705530 1928013 1928013 defendant Shropshire Thomas yeoman 591688 591688 Shropshire, Thomas, of Parshore, yeoman 5
3709720 1929351 1929351 plaintiff Reve William   591688 591688 Reve, William, of Parshore 0
3709721 1929351 1929351 defendant Chaundeler John   591688 591688 Chaundeler, John, of Parshore 0
3711193 1929805 1929805 defendant Smyth Thomas cordwainer 591688 591688 Smyth, Thomas, of Parshore, cordwainer 3
3711369 1929861 1929861 defendant Faukes Robert husbandman 591688 591688 Faukes, Robert, of Parshore, husbandman 1
3711370 1929861 1929861 defendant Sadler William saddler 591688 591688 Sadler, William, of Parshore, saddler 2
3711372 1929861 1929861 defendant Lambe John butcher 591688 591688 Lambe, John, of Parshore, butcher 4
3716566 1931479 1931479 defendant Smyth Simon hosier 591688 591688 Smyth, Simon, of Parshore, hosier 0
3716567 1931479 1931479 defendant Payne William baker 591688 591688 Payne, William, of Parshore, baker 1
3716674 1931508 1931508 defendant Tailler John yeoman 591688 591688 Tailler, John, of Parshore, yeoman 7
3717488 1931756 1931756 defendant Tayler John yeoman 591688 591688 Tayler, John, of Parshore, yeoman 0
3718474 1932057 1932057 defendant Fawkys Edward carpenter 591688 591688 Fawkys, Edward, of Parshore, carpenter 1
3723512 1933624 1933624 defendant Turbutt homas mercer 591688 591688 Turbutt, homas, of Parshore, mercer 0
3723513 1933624 1933624 defendant Mylton Henry husbandman 591688 591688 Mylton, Henry, of Parshore, husbandman 1
3728135 1935059 1935059 defendant Chanler John husbandman 591688 591688 Chanler, John, of Parshore, husbandman 0
3732147 1936290 1936290 defendant Smyth Thomas butcher 591688 591688 Smyth, Thomas, of Parshore, butcher 2
3751799 1942483 1942483 defendant Reve William yeoman 591688 591688 Reve, William, of Parshore, yeoman 0
3751802 1942484 1942484 defendant Banham John yeoman 591688 591688 Banham, John, of Parshore, yeoman 1
3761776 1945695 1945695 defendant Payne Reginald husbandman 591688 591688 Payne, Reginald, of Parshore, husbandman 0
3761777 1945695 1945695 defendant Cleve Roger laborer 591688 591688 Cleve, Roger, of Parshore, laborer 1
3761778 1945695 1945695 defendant Wheler John laborer 591688 591688 Wheler, John, of Parshore, laborer 2
3761779 1945695 1945695 defendant Charlott William laborer 591688 591688 Charlott, William, of Parshore, laborer 3
3768229 1947702 1947702 defendant Creysser William husbandman 591688 591688 Creysser, William, of Parshore, husbandman 0
3771239 1948692 1948692 defendant Reve William yeoman 591688 591688 Reve, William, of Parshore, yeoman 1
3771242 1948693 1948693 defendant Reve William yeoman 591688 591688 Reve, William, of Parshore, yeoman 0
3771244 1948694 1948694 defendant Reve William yeoman 591688 591688 Reve, William, of Parshore, yeoman 0
3771246 1948695 1948695 defendant Reve William yeoman 591688 591688 Reve, William, of Parshore, yeoman 0
3771248 1948696 1948696 defendant Reve William yeoman 591688 591688 Reve, William, of Parshore, yeoman 0
3771250 1948697 1948697 defendant Turvy George yeoman 591688 591688 Turvy, George, of Parshore, yeoman 0
3771253 1948698 1948698 defendant Westerdale Christopher gent 591688 591688 Westerdale, Christopher, of Parshore, gent 0
3771255 1948699 1948699 defendant Westerdale Christopher gent 591688 591688 Westerdale, Christopher, of Parshore, gent 0
3771256 1948699 1948699 defendant Turvy George yeoman 591688 591688 Turvy, George, of Parshore, yeoman 1
3778071 1950856 1950856 defendant Lorde Robert miller 591688 591688 Lorde, Robert, of Parshore, miller 0
3778072 1950856 1950856 defendant Jakys Humphrey barber 591688 591688 Jakys, Humphrey, of Parshore, barber 1
3778073 1950856 1950856 defendant Hosyer Simon tailor 591688 591688 Hosyer, Simon, of Parshore, tailor 2
3780143 1951512 1951512 defendant Plumer William weaver 591688 591688 Plumer, William, of Parshore, weaver 0
3780144 1951512 1951512 defendant Toft John innholder 591688 591688 Toft, John, of Parshore, innholder 1
3780145 1951512 1951512 defendant Payne William baker 591688 591688 Payne, William, of Parshore, baker 2
3780146 1951512 1951512 defendant Bocher Margaret spinster 591688 591688 Bocher, Margaret, of Parshore, spinster 3
3788856 1954320 1954320 defendant Reve William yeoman 591688 591688 Reve, William, of Parshore, yeoman 0
3788861 1954322 1954322 defendant Reve William yeoman 591688 591688 Reve, William, of Parshore, yeoman 1
3788871 1954325 1954325 defendant Creyser William husbandman 591688 591688 Creyser, William, of Parshore, husbandman 0
3788875 1954327 1954327 defendant Farre alias Smyth Richard smith 591688 591688 Farre alias Smyth, Richard, of Parshore, smith 0
3788877 1954328 1954328 defendant Farre Richard smith 591688 591688 Farre, Richard, of Parshore, smith 0
3788883 1954331 1954331 defendant Reve William yeoman 591688 591688 Reve, William, of Parshore, yeoman 0
3788885 1954332 1954332 defendant Reve William yeoman 591688 591688 Reve, William, of Parshore, yeoman 0
3788887 1954333 1954333 defendant Reve William yeoman 591688 591688 Reve, William, of Parshore, yeoman 0
3791872 1955303 1955303 defendant Moreton John husbandman 591688 591688 Moreton, John, of Parshore, husbandman 2
3793754 1955911 1955911 defendant Geffreys Edmund laborer 591688 591688 Geffreys, Edmund, of Parshore, laborer 2
3798473 1957424 1957424 defendant Wyke John chapman 591688 591688 Wyke, John, of Parshore, chapman 3
3801695 1958426 1958426 defendant Smyth Thomas cordwainer 591688 591688 Smyth, Thomas, of Parshore, cordwainer 1
3805126 1959545 1959545 defendant Walton Roger yeoman 591688 591688 Walton, Roger, of Parshore, yeoman 0
3808400 1960502 1960502 defendant Moreton John husbandman 591688 591688 Moreton, John, of Parshore, husbandman 1
3809282 1960782 1960782 defendant Jakys Humphrey barber 591688 591688 Jakys, Humphrey, of Parshore, barber 10
3810543 1961195 1961195 plaintiff Browne John   591688 591688 Browne, John, of Parshore 0
3812255 1961734 1961734 defendant Turbutt Thomas mercer 591688 591688 Turbutt, Thomas, of Parshore, mercer 4
3812257 1961734 1961734 defendant Chaundeler John husbandman 591688 591688 Chaundeler, John, of Parshore, husbandman 6
3812679 1961856 1961856 defendant Smyth Thomas butcher 591688 591688 Smyth, Thomas, of Parshore, butcher 1
3820940 1964443 1964443 defendant Wyllys John husbandman 591688 591688 Wyllys, John, of Parshore, husbandman 3
3822538 1964952 1964952 defendant Smyth Thomas butcher 591688 591688 Smyth, Thomas, of Parshore, butcher 0
3825479 1965818 1965818 defendant Smyth Thomas butcher 591688 591688 Smyth, Thomas, of Parshore, butcher 0
3825482 1965818 1965818 defendant Fyssher Thomas husbandman 591688 591688 Fyssher, Thomas, of Parshore, husbandman 3
3827767 1966552 1966552 defendant Ledbury Henry weaver 591688 591688 Ledbury, Henry, of Parshore, weaver 0
3830152 1967329 1967329 defendant Norres Thomas fisher 591688 591688 Norres, Thomas, of Parshore, fisher 0
3839868 1970403 1970403 defendant Chalner John husbandman 591688 591688 Chalner, John, of Parshore, husbandman 1
3861153 1977208 1977208 defendant Norres Thomas fisher 591688 591688 Norres, Thomas, of Parshore, fisher 0
3871283 1980646 1980646 defendant Moreley Robert tailor 591688 591688 Moreley, Robert, of Parshore, tailor 1
3875291 1981977 1981977 defendant Norres Thomas fisher 591688 591688 Norres, Thomas, of Parshore, fisher 0
3882964 1984564 1984564 defendant Larans Thomas weaver 591688 591688 Larans, Thomas, of Parshore, weaver 0
3886280 1985666 1985666 defendant Tuften Thomas husbandman 591688 591688 Tuften, Thomas, of Parshore, husbandman 1

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