names

569 rows where place_id = 587532

✎ 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
3591677 1865014 1865014 defendant Hunt Joan widow 587532 587532 Hunt, Joan, of Asshewell, widow 2
3608364 1870274 1870274 defendant Bery William husbandman 587532 587532 Bery, William, of Asshewell, husbandman 0
3612151 1871443 1871443 defendant Blakney Robert laborer 587532 587532 Blakney, Robert, of Asshewell, laborer 0
3614724 1872253 1872253 defendant Tadlowe John baker 587532 587532 Tadlowe, John, of Asshewell, baker 0
3616104 1872674 1872674 defendant Raulyn John yeoman 587532 587532 Raulyn, John, of Asshewell, yeoman 3
3617558 1873115 1873115 defendant Phelip John carpenter 587532 587532 Phelip, John, of Asshewell, carpenter 0
3617881 1873216 1873216 plaintiff Ascew alias Clerk John   587532 587532 Ascew alias Clerk, John, of Asshewell 2
3623294 1874813 1874813 plaintiff Schypman John, senior (legal representative) 587532 587532 Schypman, John, senior, of Asshewell, husbandman, executors of 0
3623298 1874814 1874814 plaintiff Schypman John, senior (legal representative) 587532 587532 Schypman, John, senior, of Asshewell, husbandman, executors of 0
3626438 1903124 1903124 defendant Grenehill Richard chapman 587532 587532 Grenehill, Richard, of Asshewell, chapman 0
3626439 1903124 1903124 defendant Phillip John carpenter 587532 587532 Phillip, John, of Asshewell, carpenter 1
3626441 1903124 1903124 defendant Sterlyng John husbandman 587532 587532 Sterlyng, John, of Asshewell, husbandman 3
3626773 1903221 1903221 plaintiff Barley William maltman 587532 587532 Barley, William, of Asshewell, maltman 0
3627527 1903468 1903468 defendant Sterlyng Robert tailor 587532 587532 Sterlyng, Robert, of Asshewell, tailor 0
3627528 1903468 1903468 defendant Sterlyng John husbandman 587532 587532 Sterlyng, John, of Asshewell, husbandman 1
3628176 1903668 1903668 defendant Sterlyng John yeoman 587532 587532 Sterlyng, John, of Asshewell, yeoman 2
3633490 1905288 1905288 defendant Rayner Thomas carpenter 587532 587532 Rayner, Thomas, of Asshewell, carpenter 0
3633642 1905332 1905332 defendant Cadwell Ralph baker 587532 587532 Cadwell, Ralph, of Asshewell, baker 1
3633643 1905332 1905332 defendant Sterlyng John   587532 587532 Sterlyng, John, of Asshewell, cook 2
3633644 1905332 1905332 defendant Bygrave John husbandman 587532 587532 Bygrave, John, of Asshewell, husbandman 3
3641997 1907947 1907947 defendant Archer Thomas husbandman 587532 587532 Archer, Thomas, of Asshewell, husbandman 0
3642156 1907995 1907995 defendant Bygrave John baker 587532 587532 Bygrave, John, of Asshewell, baker 1
3646492 1909300 1909300 defendant Cadwell Ralph baker 587532 587532 Cadwell, Ralph, of Asshewell, baker 2
3648309 1909872 1909872 defendant Tykell alias Ryder John yeoman 587532 587532 Tykell alias Ryder, John, of Asshewell, yeoman 0
3650589 1910552 1910552 defendant Palgrave John husbandman 587532 587532 Palgrave, John, of Asshewell, husbandman 0
3650591 1910552 1910552 defendant Reynerd Thomas carpenter 587532 587532 Reynerd, Thomas, of Asshewell, carpenter 2
3654815 1911765 1911765 defendant Palgrave John husbandman 587532 587532 Palgrave, John, of Asshewell, husbandman 0
3659143 1913116 1913116 defendant Jakson Robert yeoman 587532 587532 Jakson, Robert, of Asshewell, yeoman 1
3659144 1913116 1913116 defendant Langley John yeoman 587532 587532 Langley, John, of Asshewell, yeoman 2
3659940 1913366 1913366 defendant Palgrave John husbandman 587532 587532 Palgrave, John, of Asshewell, husbandman 0
3660930 1913688 1913688 defendant Gayler William husbandman 587532 587532 Gayler, William, of Asshewell, husbandman 0
3662915 1914314 1914314 defendant Cadwall Ralph baker 587532 587532 Cadwall, Ralph, of Asshewell, baker 1
3662916 1914314 1914314 defendant Vele Thomas husbandman 587532 587532 Vele, Thomas, of Asshewell, husbandman 2
3662918 1914314 1914314 defendant Wryght John husbandman 587532 587532 Wryght, John, of Asshewell, husbandman 4
3666571 1915481 1915481 defendant Philip John carpenter 587532 587532 Philip, John, of Asshewell, carpenter 3
3667776 1915863 1915863 plaintiff Wynne William yeoman 587532 587532 Wynne, William, of Asshewell, yeoman 0
3669745 1916485 1916485 defendant Smyth William butcher 587532 587532 Smyth, William, of Asshewell, butcher 0
3670743 1916810 1916810 defendant Reynerd Richard tiler 587532 587532 Reynerd, Richard, of Asshewell, tiler 0
3671284 1916993 1916993 defendant Byll John gent 587532 587532 Byll, John, of Asshewell, gent 0
3675372 1918335 1918335 defendant Feld John husbandman 587532 587532 Feld, John, of Asshewell, husbandman 1
3676926 1918821 1918821 defendant Cadwell Ralph tailor 587532 587532 Cadwell, Ralph, of Asshewell, tailor 0
3681620 1920345 1920345 defendant Bayly Richard husbandman 587532 587532 Bayly, Richard, of Asshewell, husbandman 0
3684387 1921247 1921247 defendant Smyth William butcher 587532 587532 Smyth, William, of Asshewell, butcher 3
3694413 1924456 1924456 defendant Blewet Henry, senior husbandman 587532 587532 Blewet, Henry, senior, of Asshewell, husbandman 2
3700047 1926247 1926247 defendant Glover James husbandman 587532 587532 Glover, James, of Asshewell, husbandman 1
3700568 1926421 1926421 defendant Sowster John gent 587532 587532 Sowster, John, of Asshewell, gent 0
3700569 1926421 1926421 defendant Ryken Thomas husbandman 587532 587532 Ryken, Thomas, of Asshewell, husbandman 1
3704510 1927705 1927705 defendant Annable John fuller 587532 587532 Annable, John, of Asshewell, fuller 0
3712126 1930110 1930110 defendant Bluett Henry, senior husbandman 587532 587532 Bluett, Henry, senior, of Asshewell, husbandman 1
3712128 1930110 1930110 defendant Bentley Thomas barber 587532 587532 Bentley, Thomas, of Asshewell, barber 3
3713049 1930406 1930406 defendant Ernest William husbandman 587532 587532 Ernest, William, of Asshewell, husbandman 0
3713050 1930406 1930406 defendant Thorpe alias Mason John husbandman 587532 587532 Thorpe alias Mason, John, of Asshewell, husbandman 1
3713051 1930406 1930406 defendant Redmeld alias Heward John husbandman 587532 587532 Redmeld alias Heward, John, of Asshewell, husbandman 2
3717493 1931758 1931758 defendant Annabyll John sherman 587532 587532 Annabyll, John, of Asshewell, sherman 1
3719539 1932375 1932375 defendant Lecheworth John butcher 587532 587532 Lecheworth, John, of Asshewell, butcher 1
3722960 1933446 1933446 defendant Fytchet John gent 587532 587532 Fytchet, John, of Asshewell, gent 0
3722961 1933446 1933446 defendant Blewett Henry husbandman 587532 587532 Blewett, Henry, of Asshewell, husbandman 1
3735893 1937465 1937465 defendant Smyth William butcher 587532 587532 Smyth, William, of Asshewell, butcher 0
3738830 1938350 1938350 defendant Bluet Henry husbandman 587532 587532 Bluet, Henry, of Asshewell, husbandman 2
3740838 1938992 1938992 defendant Barley John husbandman 587532 587532 Barley, John, of Asshewell, husbandman 0
3741148 1939093 1939093 defendant Byll John husbandman 587532 587532 Byll, John, of Asshewell, husbandman 2
3745497 1940498 1940498 defendant Redmyld John husbandman 587532 587532 Redmyld, John, of Asshewell, husbandman 0
3745498 1940498 1940498 defendant Redmyld Thomas husbandman 587532 587532 Redmyld, Thomas, of Asshewell, husbandman 1
3753069 1942898 1942898 defendant Barley John husbandman 587532 587532 Barley, John, of Asshewell, husbandman 0
3756932 1944145 1944145 defendant Waren lawrence poulter 587532 587532 Waren, lawrence, of Asshewell, poulter 1
3756937 1944146 1944146 defendant Waren Lawrence pulter 587532 587532 Waren, Lawrence, of Asshewell, pulter 0
3763318 1946159 1946159 defendant Kyng Thomas tailor 587532 587532 Kyng, Thomas, of Asshewell, tailor 3
3793026 1955678 1955678 defendant Bygrave Henry yeoman 587532 587532 Bygrave, Henry, of Asshewell, yeoman 0
3801860 1958478 1958478 defendant Smyth William butcher 587532 587532 Smyth, William, of Asshewell, butcher 1
3804994 1959505 1959505 defendant Waterson Walter tailor 587532 587532 Waterson, Walter, of Asshewell, tailor 3
3809092 1960727 1960727 defendant Anabull John fuller 587532 587532 Anabull, John, of Asshewell, fuller 1
3821645 1964655 1964655 defendant Kynge Thomas draper 587532 587532 Kynge, Thomas, of Asshewell, draper 0
3827676 1966517 1966517 defendant Bayes Nicholas husbandman 587532 587532 Bayes, Nicholas, of Asshewell, husbandman 0
3827678 1966518 1966518 defendant Bayes Nicholas husbandman 587532 587532 Bayes, Nicholas, of Asshewell, husbandman 0
3828624 1966832 1966832 plaintiff Clerke Richard   587532 587532 Clerke, Richard, of Asshewell 0
3828628 1966833 1966833 plaintiff Clerke Richard   587532 587532 Clerke, Richard, of Asshewell 0
3832059 1967927 1967927 defendant Bluett Henry husbandman 587532 587532 Bluett, Henry, of Asshewell, husbandman 1
3833177 1968307 1968307 defendant Walkotte alias Hall Thomas, junior husbandman 587532 587532 Walkotte alias Hall, Thomas, junior, of Asshewell, husbandman 0
3833186 1968311 1968311 defendant Walcotte alias Halle Thomas, junior husbandman 587532 587532 Walcotte alias Halle, Thomas, junior, of Asshewell, husbandman 0
3837047 1969500 1969500 defendant Smyth William butcher 587532 587532 Smyth, William, of Asshewell, butcher 0
3838994 1970124 1970124 plaintiff Warde John mercer 587532 587532 Warde, John, of Asshewell, mercer 0
3839966 1970428 1970428 defendant Bygrave John baker 587532 587532 Bygrave, John, of Asshewell, baker 3
3842644 1971230 1971230 defendant Redmell John husbandman 587532 587532 Redmell, John, of Asshewell, husbandman 0
3864100 1978176 1978176 defendant Bygrave Edward   587532 587532 Bygrave, Edward, of Asshewell, mason 1
3867572 1979390 1979390 plaintiff Sewster John, junior   587532 587532 Sewster, John, junior, of Asshewell 0
3869522 1980049 1980049 plaintiff Warde John mercer 587532 587532 Warde, John, of Asshewell, mercer 0
3869524 1980049 1980049 defendant Bluett Henry husbandman 587532 587532 Bluett, Henry, of Asshewell, husbandman 1
3878205 1982959 1982959 plaintiff Kyng Thomas tailor 587532 587532 Kyng, Thomas, of Asshewell, tailor 0
3878206 1982959 1982959 defendant Waller John husbandman 587532 587532 Waller, John, of Asshewell, husbandman 0
3881528 1984083 1984083 defendant Smyth William butcher 587532 587532 Smyth, William, of Asshewell, butcher 0
3885776 1985496 1985496 defendant Mede John husbandman 587532 587532 Mede, John, of Asshewell, husbandman 0
3886602 1985769 1985769 defendant Orwell James esq 587532 587532 Orwell, James, of Asshewell, esq 0
3886603 1985769 1985769 defendant Mede John husbandman 587532 587532 Mede, John, of Asshewell, husbandman 1
3886604 1985769 1985769 defendant Botylsham William husbandman 587532 587532 Botylsham, William, of Asshewell, husbandman 2
3890456 1987065 1987065 defendant Mede John husbandman 587532 587532 Mede, John, of Asshewell, husbandman 0
3891260 1987344 1987344 plaintiff Kyng Thomas tailor 587532 587532 Kyng, Thomas, of Asshewell, tailor 0
3891261 1987344 1987344 defendant Waller alias Waren John   587532 587532 Waller alias Waren, John, of Asshewell, horse courser 0
3891262 1987345 1987345 plaintiff Kyng Thomas tailor 587532 587532 Kyng, Thomas, of Asshewell, tailor 0
3891263 1987345 1987345 defendant Waller alias Waren John   587532 587532 Waller alias Waren, John, of Asshewell, horse courser 0
3891407 1987392 1987392 defendant Mede John husbandman 587532 587532 Mede, John, of Asshewell, husbandman 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);