names

155 rows where place_id = 587201

✎ 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
3590737 1864743 1864743 defendant Pykard William husbandman 587201 587201 Pykard, William, of Sharyngton, husbandman 1
3606541 1869717 1869717 defendant Brecham John barker 587201 587201 Brecham, John, of Sharyngton, barker 2
3614899 1872314 1872314 defendant Daubeney Thomas esq 587201 587201 Daubeney, Thomas, of Sharyngton, esq 2
3616658 1872840 1872840 defendant Berewyk William husbandman 587201 587201 Berewyk, William, of Sharyngton, husbandman 1
3616662 1872841 1872841 defendant Berewyk William husbandman 587201 587201 Berewyk, William, of Sharyngton, husbandman 0
3617089 1872969 1872969 defendant Barewyke William husbandman 587201 587201 Barewyke, William, of Sharyngton, husbandman 1
3635225 1905808 1905808 defendant Garnett Nicholas yeoman 587201 587201 Garnett, Nicholas, of Sharyngton, yeoman 2
3672484 1917395 1917395 defendant Dawebeney Henry gent 587201 587201 Dawebeney, Henry, of Sharyngton, gent 0
3672487 1917396 1917396 defendant Dawebeney John gent 587201 587201 Dawebeney, John, of Sharyngton, gent 0
3684313 1921229 1921229 defendant Daubeney Henry gent 587201 587201 Daubeney, Henry, of Sharyngton, gent 0
3684694 1921345 1921345 defendant Dawbeney Thomas gent 587201 587201 Dawbeney, Thomas, of Sharyngton, gent 0
3684695 1921345 1921345 defendant Dawbeney Henry gent 587201 587201 Dawbeney, Henry, of Sharyngton, gent 1
3689562 1922891 1922891 defendant Fuller John yeoman 587201 587201 Fuller, John, of Sharyngton, yeoman 0
3689575 1922896 1922896 defendant Fuller John yeoman 587201 587201 Fuller, John, of Sharyngton, yeoman 3
3690025 1923039 1923039 plaintiff Fuller John   587201 587201 Fuller, John, of Sharyngton 0
3691182 1923403 1923403 defendant Dawbendy Henry gent 587201 587201 Dawbendy, Henry, of Sharyngton, gent 0
3691187 1923404 1923404 defendant Dawbeney Henry gent 587201 587201 Dawbeney, Henry, of Sharyngton, gent 0
3705112 1927888 1927888 defendant Fuller John (legal representative) 587201 587201 Fuller, John, of Sharyngton, executor of 2
3733806 1936826 1936826 defendant Lomnor Thomas gent 587201 587201 Lomnor, Thomas, of Sharyngton, gent 2
3734944 1937164 1937164 defendant Lomnere Thomas gent 587201 587201 (Lomnere, Thomas, of Sharyngton, gent 5
3741157 1939095 1939095 defendant Daubeney Henry gent 587201 587201 Daubeney, Henry, of Sharyngton, gent 0
3741933 1939342 1939342 defendant Dawbeney Henry gent 587201 587201 Dawbeney, Henry, of Sharyngton, gent 0
3747296 1941075 1941075 defendant Dawbeney Henry gent 587201 587201 Dawbeney, Henry, of Sharyngton, gent 0
3778655 1951037 1951037 defendant Lomnore Thomas gent 587201 587201 Lomnore, Thomas, of Sharyngton, gent 0
3778656 1951037 1951037 defendant Lomnore John gent 587201 587201 Lomnore, John, of Sharyngton, gent 1
3778657 1951037 1951037 defendant Swan Edmund husbandman 587201 587201 Swan, Edmund, of Sharyngton, husbandman 2
3778662 1951039 1951039 defendant Lumnour Thomas gent 587201 587201 Lumnour, Thomas, of Sharyngton, gent 0
3778663 1951039 1951039 defendant Swan Edmund husbandman 587201 587201 Swan, Edmund, of Sharyngton, husbandman 1
3779259 1951236 1951236 defendant Dawbeney Henry gent 587201 587201 Dawbeney, Henry, of Sharyngton, gent 1
3800410 1958049 1958049 plaintiff Lose Agnes (legal representative) 587201 587201 Lose, Agnes, of Sharyngton, executrix of 0
3815680 1962822 1962822 defendant Dawbeney Henry gent 587201 587201 Dawbeney, Henry, of Sharyngton, gent 0
3817954 1963535 1963535 plaintiff Lose Agnes (legal representative) 587201 587201 Lose, Agnes, of Sharyngton, executrix of 0
3828072 1966648 1966648 defendant Dawbeney Henry gent 587201 587201 Dawbeney, Henry, of Sharyngton, gent 0
3840040 1970452 1970452 defendant Dawbeney Henry gent 587201 587201 Dawbeney, Henry, of Sharyngton, gent 0
3871434 1980692 1980692 defendant Ditton alias Wright John husbandman 587201 587201 Ditton alias Wright, John, of Sharyngton, husbandman 2
3876033 1982238 1982238 defendant Dawbeney John clerk 587201 587201 Dawbeney, John, of Sharyngton, clerk 1
3876034 1982238 1982238 defendant Lomnour Thomas gent 587201 587201 Lomnour, Thomas, of Sharyngton, gent 2
3895393 1988669 1988669 defendant Swanne John, junior yeoman 587201 587201 Swanne, John, junior, of Sharyngton, yeoman 0
3895394 1988669 1988669 defendant Swanne Edward husbandman 587201 587201 Swanne, Edward, of Sharyngton, husbandman 1
3905916 1992263 1992263 defendant Dawbeney Henry gent 587201 587201 Dawbeney, Henry, of Sharyngton, gent 0
3905925 1992265 1992265 defendant Dawbeney Henry gent 587201 587201 Dawbeney, Henry, of Sharyngton, gent 0
3915606 1995587 1995587 defendant Hunte Thomas clerk 587201 587201 Hunte, Thomas, of Sharyngton, clerk 0
3918638 1996559 1996559 plaintiff Hunt Thomas clerk 587201 587201 Hunt, Thomas, of Sharyngton, clerk 0
3921395 1997497 1997497 defendant Dawbeney Henry gent 587201 587201 Dawbeney, Henry, of Sharyngton, gent 0
3996461 2023493 2023493 plaintiff Dawbeney Christopher esq 587201 587201 Dawbeney, Christopher, of Sharyngton, esq 0
4028677 2034906 2034906 plaintiff Courchyvour William yeoman 587201 587201 Courchyvour, William, of Sharyngton, yeoman 0
4070100 2049595 2049595 defendant Rokesby Nicholas clerk 587201 587201 Rokesby, Nicholas, of Sharyngton, clerk 0
4107536 2062982 2062982 defendant Ruksbye Nicholas clerk 587201 587201 Ruksbye, Nicholas, of Sharyngton, clerk 0
4162507 2082448 2082448 defendant Rolesby alias Rokesbye Nicholas clerk 587201 587201 Rolesby alias Rokesbye, Nicholas, of Sharyngton, clerk 0
4231402 2106485 2106485 defendant Ryngold Nicholas yeoman 587201 587201 Ryngold, Nicholas, of Sharyngton, yeoman 0
4396630 2163437 2163437 defendant Norwiche Daniel yeoman 587201 587201 Norwiche, Daniel, of Sharyngton, yeoman 3
4396635 2163438 2163438 defendant Norwich Daniel yeoman 587201 587201 Norwich, Daniel, of Sharyngton, yeoman 3
4467578 2190540 2190540 defendant Charlys John   587201 587201 Charlys, John, of Sharyngton 1
4502951 2201493 2201493 defendant Wythe William   587201 587201 Wythe, William, of Sharyngton 1
4543329 2213799 2213799 defendant Baldewen Henry   587201 587201 Baldewen, Henry, of Sharyngton 0
4555477 2217647 2217647 defendant Kenel William   587201 587201 Kenel, William, of Sharyngton 4
4724696 2273021 2273021 defendant Herryes John husbandman 587201 587201 Herryes, John, of Sharyngton, husbandman 0
4744872 2279017 2279017 defendant Clerk Alan husbandman 587201 587201 Clerk, Alan, of Sharyngton, husbandman 0
4744873 2279017 2279017 defendant Milys Thomas   587201 587201 Milys, Thomas, of Sharyngton, bailiff 1
4744874 2279017 2279017 defendant Milys John, junior husbandman 587201 587201 Milys, John, junior, of Sharyngton, husbandman 2
4761360 2283896 2283896 defendant Daubeney Robert gent 587201 587201 Daubeney, Robert, of Sharyngton, gent 2
4845864 2310216 2310216 defendant Herys John yeoman 587201 587201 together with Herys, John, of Sharyngton, yeoman 1
4876088 2319481 2319481 plaintiff Sharyngton Henry   587201 587201 Sharyngton, Henry, of Sharyngton 0
4947887 2341321 2341321 defendant Dawbeneye William esq 587201 587201 Dawbeneye, William, of Sharyngton, esq 0
4958222 2344428 2344428 defendant Dobbys William husbandman 587201 587201 Dobbys, William, of Sharyngton, husbandman 1
4977454 2350221 2350221 defendant Dawebeney William esq 587201 587201 Dawebeney, William, of Sharyngton, esq 0
4981273 2351320 2351320 defendant Dobbys William husbandman 587201 587201 Dobbys, William, of Sharyngton, husbandman 2
5012047 2360371 2360371 defendant Kenell John yeoman 587201 587201 Kenell, John, of Sharyngton, yeoman 8
5022408 2363453 2363453 defendant Dobbes William husbandman 587201 587201 Dobbes, William, of Sharyngton, husbandman 2
5029176 2365412 2365412 defendant Dobbes William husbandman 587201 587201 Dobbes, William, of Sharyngton, husbandman 1
5050642 2371820 2371820 defendant Wrigth Robert carpenter 587201 587201 Wrigth, Robert, of Sharyngton, carpenter 1
5053108 2372524 2372524 defendant Smyth Robert chaplain 587201 587201 Smyth, Robert, of Sharyngton, chaplain 3
5088071 2382887 2382887 defendant Berewyk William husbandman 587201 587201 Berewyk, William, of Sharyngton, husbandman 1
5098596 2386022 2386022 defendant Dawebeney William gent 587201 587201 Dawebeney, William, of Sharyngton, gent 0
5100587 2386600 2386600 defendant Stamp John husbandman 587201 587201 Stamp, John, of Sharyngton, husbandman 1
5112187 2389947 2389947 defendant Dawebeney William gent 587201 587201 Dawebeney, William, of Sharyngton, gent 0
5114641 2390697 2390697 defendant Dobbys William husbandman 587201 587201 Dobbys, William, of Sharyngton, husbandman 0
5133085 2396162 2396162 defendant Wyllys Nicholas yeoman 587201 587201 Wyllys, Nicholas, of Sharyngton, yeoman 1
5152341 2401816 2401816 defendant Wyllys Nicholas yeoman 587201 587201 Wyllys, Nicholas, of Sharyngton, yeoman 1
5170163 2407003 2407003 defendant Wyllys Nicholas yeoman 587201 587201 Wyllys, Nicholas, of Sharyngton, yeoman 1
5177373 2409076 2409076 plaintiff Worstede John   587201 587201 Worstede, John, of Sharyngton 0
5187618 2412094 2412094 defendant Willys Nicholas yeoman 587201 587201 Willys, Nicholas, of Sharyngton, yeoman 1
5224205 2422749 2422749 defendant Sharyngton John gent 587201 587201 Sharyngton, John, of Sharyngton, gent 1
5241813 2427806 2427806 defendant Sharyngton John yeoman 587201 587201 Sharyngton, John, of Sharyngton, yeoman 0
5252839 2431000 2431000 defendant Worstede John husbandman 587201 587201 Worstede, John, of Sharyngton, husbandman 3
5261676 2433763 2433763 defendant Houghson John yeoman 587201 587201 Houghson, John, of Sharyngton, yeoman 1
5261677 2433763 2433763 defendant Byrcham John yeoman 587201 587201 Byrcham, John, of Sharyngton, yeoman 2
5267572 2435618 2435618 plaintiff Wyllys William   587201 587201 Wyllys, William, of Sharyngton 0
5268479 2435900 2435900 defendant Falyate Richard   587201 587201 Falyate, Richard, of Sharyngton 6
5277490 2438496 2438496 defendant Pykard William shoemaker 587201 587201 Pykard, William, of Sharyngton, husbandman, or of Brynton, shoemaker 0
5277492 2438497 2438497 defendant Pylmot William shoemaker 587201 587201 Pylmot, William, of Sharyngton, husbandman, or of Brynton, shoemaker 0
5277493 2438497 2438497 defendant Joly Thomas husbandman 587201 587201 Joly, Thomas, of Sharyngton, husbandman 1
5277494 2438497 2438497 defendant Joly Robert husbandman 587201 587201 Joly, Robert, of Sharyngton, husbandman 2
5280459 2439357 2439357 defendant Barwyk William husbandman 587201 587201 Barwyk, William, of Sharyngton, husbandman 1
5289953 2442066 2442066 defendant Byrcham John yeoman 587201 587201 Byrcham, John, of Sharyngton, yeoman 0
5289954 2442066 2442066 defendant Sagge William yeoman 587201 587201 Sagge, William, of Sharyngton, yeoman 1
5297721 2444339 2444339 defendant Joly Thomas husbandman 587201 587201 Joly, Thomas, of Sharyngton, husbandman 0
5297722 2444339 2444339 defendant Joly Robert husbandman 587201 587201 Joly, Robert, of Sharyngton, husbandman 1
5299099 2444717 2444717 defendant Pykard William shoemaker 587201 587201 Pykard, William, of Sharyngton, shoemaker 5
5302086 2445580 2445580 defendant Dobbys Robert pedder 587201 587201 Dobbys, Robert, of Sharyngton, pedder 3

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