names

68 rows where place_id = 600826

✎ 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
3642715 1908166 1908166 defendant Barby John butcher 600826 600826 Barby, John, of Sheryngton, butcher 0
3676869 1918804 1918804 defendant Felde Robert husbandman 600826 600826 Felde, Robert, of Sheryngton, husbandman 2
3690027 1923040 1923040 plaintiff Fuller John yeoman 600826 600826 Fuller, John, of Sheryngton, yeoman 0
3718110 1931953 1931953 defendant Cobyll Robert husbandman 600826 600826 Cobyll, Robert, of Sheryngton, husbandman 0
3745558 1940516 1940516 plaintiff Burgeys Thomas yeoman 600826 600826 Burgeys, Thomas, of Sheryngton, yeoman 0
3745899 1940623 1940623 defendant Dawbeney Henry gent 600826 600826 Dawbeney, Henry, of Sheryngton, gent 0
3752853 1942815 1942815 defendant Grendon Richard yeoman 600826 600826 Grendon, Richard, of Sheryngton, yeoman 1
3752854 1942815 1942815 defendant Chubnall Thomas husbandman 600826 600826 Chubnall, Thomas, of Sheryngton, husbandman 2
3756316 1943939 1943939 defendant Sampson John husbandman 600826 600826 Sampson, John, of Sheryngton, husbandman 0
3769736 1948188 1948188 defendant Grendon Richard yeoman 600826 600826 Grendon, Richard, of Sheryngton, yeoman 0
3769744 1948190 1948190 defendant Chubnall Thomas husbandman 600826 600826 Chubnall, Thomas, of Sheryngton, husbandman 0
3777595 1950744 1950744 defendant Harryson Thomas husbandman 600826 600826 Harryson, Thomas, of Sheryngton, husbandman 2
3778660 1951038 1951038 defendant Swan Edmund husbandman 600826 600826 Swan, Edmund, of Sheryngton, husbandman 1
3787531 1953890 1953890 defendant Chubnall Thomas husbandman 600826 600826 Chubnall, Thomas, of Sheryngton, husbandman 0
3787534 1953891 1953891 defendant Grendon Richard yeoman 600826 600826 Grendon, Richard, of Sheryngton, yeoman 0
3794993 1956298 1956298 defendant Heryson Thomas miller 600826 600826 Heryson, Thomas, of Sheryngton, miller 0
3797639 1957158 1957158 plaintiff Grendon Richard   600826 600826 Grendon, Richard, of Sheryngton 0
3809459 1960840 1960840 defendant Swan Edmund husbandman 600826 600826 Swan, Edmund, of Sheryngton, husbandman 4
3826717 1966206 1966206 defendant Pechet John mercer 600826 600826 Pechet, John, of Sheryngton, mercer 0
3838491 1969962 1969962 defendant Ryngold Nicholas husbandman 600826 600826 Ryngold, Nicholas, of Sheryngton, husbandman 0
3856161 1975550 1975550 defendant Overyend Robert husbandman 600826 600826 Overyend, Robert, of Sheryngton, husbandman 0
3856660 1975710 1975710 defendant Overyend Robert husbandman 600826 600826 Overyend, Robert, of Sheryngton, husbandman 0
3890152 1986944 1986944 defendant Chybnall Richard laborer 600826 600826 Chybnall, Richard, of Sheryngton, laborer 0
3890169 1986951 1986951 defendant Dawbeney Henry gent 600826 600826 Dawbeney, Henry, of Sheryngton, gent 3
3895816 1988807 1988807 defendant Sturgeys Robert gent 600826 600826 Sturgeys, Robert, of Sheryngton, gent 0
3909235 1993383 1993383 defendant Swanne Edward husbandman 600826 600826 Swanne, Edward, of Sheryngton, husbandman 0
3980501 2017793 2017793 defendant Rokesby Nicholas clerk 600826 600826 Rokesby, Nicholas, of Sheryngton, clerk 3
4082788 2054146 2054146 defendant Cooke William husbandman 600826 600826 Cooke, William, of Sheryngton, husbandman 3
4103315 2061467 2061467 defendant Bossard Robert husbandman 600826 600826 Bossard, Robert, of Sheryngton, husbandman 0
4545772 2214605 2214605 defendant Clyfford John   600826 600826 Clyfford, John, of Sheryngton 0
4662270 2249673 2249673 defendant Smart William husbandman 600826 600826 Smart, William, of Sheryngton, husbandman 0
4709674 2268390 2268390 defendant Clerk Roger (legal representative) 600826 600826 Clerk, Roger, of Sheryngton, executors of 0
4809477 2299137 2299137 defendant Kenell Nicholas smith 600826 600826 Kenell, Nicholas, of Sheryngton, smith 3
4810727 2299477 2299477 plaintiff fitz John John   600826 600826 fitz John, John, of Sheryngton, on his own account 0
5070153 2377568 2377568 defendant Coyte John husbandman 600826 600826 Coyte, John, of Sheryngton, husbandman 0
5070154 2377568 2377568 defendant Coyte William laborer 600826 600826 Coyte, William, of Sheryngton, laborer 1
5070155 2377568 2377568 defendant Olyver Thomas husbandman 600826 600826 Olyver, Thomas, of Sheryngton, husbandman 2
5070157 2377569 2377569 defendant Coyte William laborer 600826 600826 Coyte, William, of Sheryngton, laborer 0
5070158 2377569 2377569 defendant Olyver Thomas husbandman 600826 600826 Olyver, Thomas, of Sheryngton, husbandman 1
5070159 2377569 2377569 defendant Coyte John husbandman 600826 600826 Coyte, John, of Sheryngton, husbandman 2
5110758 2389546 2389546 defendant Adam John husbandman 600826 600826 Adam, John, of Sheryngton, husbandman 2
5110759 2389546 2389546 defendant Crosse John husbandman 600826 600826 Crosse, John, of Sheryngton, husbandman 3
5110760 2389546 2389546 defendant Adam John yeoman 600826 600826 Adam,John, of Sheryngton, yeoman 4
5151807 2401687 2401687 defendant Adam John husbandman 600826 600826 Adam, John, of Sheryngton, husbandman 2
5151808 2401687 2401687 defendant Crosse John husbandman 600826 600826 Crosse, John, of Sheryngton, husbandman 3
5151809 2401687 2401687 defendant Adam John yeoman 600826 600826 Adam, John, of Sheryngton, yeoman 4
5151922 2401699 2401699 defendant Adam John husbandman 600826 600826 Adam, John, of Sheryngton, husbandman 2
5151923 2401699 2401699 defendant Crosse John husbandman 600826 600826 Crosse, John, of Sheryngton, husbandman 3
5151924 2401699 2401699 defendant Adam John yeoman 600826 600826 Adam, John, of Sheryngton, yeoman 4
5169880 2406927 2406927 defendant Adam John husbandman 600826 600826 Adam, John, of Sheryngton, husbandman 2
5169881 2406927 2406927 defendant Crosse John husbandman 600826 600826 Crosse, John, of Sheryngton, husbandman 3
5169882 2406927 2406927 defendant Adam John yeoman 600826 600826 Adam, John, of Sheryngton, yeoman 4
5187074 2411949 2411949 defendant Adam John husbandman 600826 600826 Adam, John, of Sheryngton, husbandman 0
5187075 2411949 2411949 defendant Crosse John husbandman 600826 600826 Crosse, John, of Sheryngton, husbandman 1
5187076 2411949 2411949 defendant Adam John yeoman 600826 600826 Adam, John, of Sheryngton, yeoman 2
5212226 2419315 2419315 defendant Sheryngton John gent 600826 600826 Sheryngton, John, of Sheryngton, gent 2
5227353 2423627 2423627 defendant Pessham Richard husbandman 600826 600826 Pessham, Richard, of Sheryngton, husbandman 0
5227354 2423627 2423627 defendant Pessham John chaplain 600826 600826 Pessham, John, of Sheryngton, chaplain 1
5239813 2427222 2427222 defendant Berwyk Henry smith 600826 600826 Berwyk, Henry, of Sheryngton, smith 2
5239826 2427224 2427224 defendant Berwyk Thomas smith 600826 600826 Berwyk, Thomas, of Sheryngton, smith 2
5258318 2432718 2432718 defendant Alfurth William yeoman 600826 600826 Alfurth, William, of Sheryngton, yeoman 1
5259494 2433092 2433092 defendant Coyte John husbandman 600826 600826 Coyte, John, of Sheryngton, husbandman 0
5267574 2435619 2435619 plaintiff Wyllys William   600826 600826 Wyllys, William, of Sheryngton 0
5338144 2456497 2456497 defendant Dawebeney William gent 600826 600826 Dawebeney, William, of Sheryngton, gent 4
5455657 2491595 2491595 defendant Mony Edmund husbandman 600826 600826 Mony, Edmund, of Sheryngton, husbandman 3
5515437 2509675 2509675 defendant Faldyate Richard husbandman 600826 600826 Faldyate, Richard, of Sheryngton, husbandman 0
5522755 2511943 2511943 defendant Berwyk William husbandman 600826 600826 Berwyk, William, of Sheryngton, husbandman 1
5576200 2527617 2527617 defendant Hawekyns William husbandman 600826 600826 Hawekyns, William, of Sheryngton, husbandman 4

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