names

125 rows where place_id = 596230

✎ 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
3623761 1874966 1874966 defendant Case Mary widow 596230 596230 Case, Mary, of South Pederton, widow 0
3674895 1918178 1918178 defendant Isam Roger yeoman 596230 596230 Isam, Roger, of South Pederton, yeoman 2
3675929 1918508 1918508 defendant Loveryng Thomas husbandman 596230 596230 Loveryng, Thomas, of South Pederton, husbandman 3
3693796 1924257 1924257 defendant Mocke Thomas yeoman 596230 596230 Mocke, Thomas, of South Pederton, yeoman 2
3701693 1926772 1926772 defendant Golde John gent 596230 596230 Golde, John, of South Pederton, gent 0
3710821 1929701 1929701 defendant Isham Roger yeoman 596230 596230 Isham, Roger, of South Pederton, yeoman 0
3710823 1929702 1929702 defendant Isham Roger yeoman 596230 596230 Isham, Roger, of South Pederton, yeoman 0
3710825 1929703 1929703 defendant Isham Roger yeoman 596230 596230 Isham, Roger, of South Pederton, yeoman 0
3735953 1937482 1937482 defendant Denman John smith 596230 596230 Denman, John, of South Pederton, smith 0
3756797 1944098 1944098 defendant Mocke Thomas fisher 596230 596230 Mocke, Thomas, of South Pederton, fisher 0
3756839 1944113 1944113 defendant Lovell Geoffrey husbandman 596230 596230 Lovell, Geoffrey, of South Pederton, husbandman 0
3756840 1944113 1944113 defendant Barrett Christopher fisher 596230 596230 Barrett, Christopher, of South Pederton, fisher 1
3756841 1944113 1944113 defendant Reche Peter fisher 596230 596230 Reche, Peter, of South Pederton, fisher 2
3779569 1951339 1951339 defendant Wyly Richard husbandman 596230 596230 Wyly, Richard, of South Pederton, husbandman 0
3805240 1959585 1959585 defendant Mok Thomas yeoman 596230 596230 Mok, Thomas, of South Pederton, yeoman 0
3843436 1971483 1971483 defendant Steven John laborer 596230 596230 Steven, John, of South Pederton, laborer 3
3858877 1976456 1976456 defendant Kaye Thomas yeoman 596230 596230 Kaye, Thomas, of South Pederton, yeoman 1
3870708 1980447 1980447 defendant Forest Stephen clerk 596230 596230 Forest, Stephen, of South Pederton, clerk 0
3870709 1980447 1980447 defendant Mocke Thomas fisher 596230 596230 Mocke, Thomas, of South Pederton, fisher 1
4436039 2176005 2176005 defendant Jurdan Roger   596230 596230 Jurdan, Roger, of South Pederton 0
4436040 2176005 2176005 defendant Wille William   596230 596230 Wille, William, of South Pederton 1
4439987 2181792 2181792 defendant Reed Andrew   596230 596230 Reed, Andrew, of South Pederton 0
4439991 2181794 2181794 defendant Smyth Thomas   596230 596230 Smyth, Thomas, of South Pederton 0
4442407 2182567 2182567 defendant Hopere William   596230 596230 Hopere, William, of South Pederton 1
4487866 2196921 2196921 plaintiff Splite Robert (legal representative) 596230 596230 Splite, Robert, of South Pederton, executors of 0
4529831 2209615 2209615 defendant Dore Nicholas   596230 596230 Dore, Nicholas, of South Pederton 3
4530692 2209892 2209892 defendant Dyere Robert   596230 596230 Dyere, Robert, of South Pederton 1
4560667 2219283 2219283 defendant Smyth William   596230 596230 (Smyth, William, of South Pederton 1
4573813 2223327 2223327 defendant Cryche William   596230 596230 Cryche, William, of South Pederton 0
4578835 2224861 2224861 defendant Norton John   596230 596230 Norton, John, of South Pederton 0
4611678 2234714 2234714 defendant Norton John   596230 596230 Norton, John, of South Pederton 0
4633687 2241383 2241383 defendant Moure John dyer 596230 596230 Moure, John, of South Pederton, dyer 0
4643849 2244299 2244299 defendant Biggegode John   596230 596230 Biggegode, John, of South Pederton 0
4657658 2248284 2248284 defendant Norton John   596230 596230 Norton, John, of South Pederton, notary 8
4661782 2249526 2249526 defendant More John dyer 596230 596230 More, John, of South Pederton, dyer 0
4676508 2258268 2258268 defendant Caddok John tanner 596230 596230 Caddok, John, of South Pederton, tanner 0
4691080 2262733 2262733 defendant Seger John husbandman 596230 596230 Seger, John, of South Pederton, husbandman 0
4701921 2266006 2266006 defendant Caddok John tanner 596230 596230 Caddok, John, of South Pederton, tanner 0
4702056 2266053 2266053 defendant Mariet William husbandman 596230 596230 Mariet, William, of South Pederton, husbandman 1
4702057 2266053 2266053 defendant Kyngman William weaver 596230 596230 Kyngman, William, of South Pederton, weaver 2
4702058 2266053 2266053 defendant Huwet Edward butcher 596230 596230 Huwet, Edward, of South Pederton, butcher 3
4739432 2277417 2277417 defendant Braden Philip yeoman 596230 596230 Braden, Philip, of South Pederton, yeoman 1
4743799 2278716 2278716 defendant Davy John gent 596230 596230 Davy, John, of South Pederton, gent 0
4743800 2278716 2278716 defendant Caas Nicholas gent 596230 596230 Caas, Nicholas, of South Pederton, gent 1
4745808 2279280 2279280 defendant Splyte William fuller 596230 596230 Splyte, William, of South Pederton, fuller 1
4766793 2285608 2285608 defendant Tallbot John skinner 596230 596230 Tallbot, John, of South Pederton, skinner 1
4767708 2285881 2285881 defendant Willams Thomas   596230 596230 Willams, Thomas, of South Pederton, groom 0
4769750 2286509 2286509 defendant More John dyer 596230 596230 More, John, of South Pederton, dyer 0
4783303 2290799 2290799 defendant Davy John husbandman 596230 596230 Davy, John, of South Pederton, husbandman 0
4787311 2292101 2292101 defendant Dyere John dyer 596230 596230 Dyere, John, of South Pederton, dyer 1
4787312 2292101 2292101 defendant Clerk John husbandman 596230 596230 Clerk, John, of South Pederton, husbandman 2
4792109 2293632 2293632 defendant Willams Thomas   596230 596230 Willams, Thomas, of South Pederton, groom 0
4829452 2305253 2305253 defendant Benet alias Cokke John chapman 596230 596230 Benet alias Cokke, John, of South Pederton, chapman 3
4848357 2310957 2310957 defendant Saly John clerk 596230 596230 Saly, John, of South Pederton, clerk 0
4856671 2313462 2313462 defendant Davy Nicholas   596230 596230 Davy, Nicholas, of South Pederton, attorney 0
4859501 2314343 2314343 defendant Shete Walter husbandman 596230 596230 (Shete, Walter, of South Pederton, husbandman 5
4869598 2317452 2317452 defendant Trote Henry husbandman 596230 596230 Trote, Henry, of South Pederton, husbandman 0
4869599 2317452 2317452 defendant Marche John   596230 596230 Marche, John, of South Pederton, millward 1
4870298 2317683 2317683 defendant Payne William chapman 596230 596230 Payne, William, of South Pederton, chapman 2
4874355 2318922 2318922 defendant Taillour William tailor 596230 596230 Taillour, William, of South Pederton, tailor 3
4876855 2319731 2319731 defendant Macy John husbandman 596230 596230 Macy, John, of South Pederton, husbandman 2
4876856 2319731 2319731 defendant More John dyer 596230 596230 More, John, of South Pederton, dyer 3
4880551 2320828 2320828 defendant Davy Nicholas   596230 596230 Davy, Nicholas, of South Pederton, attorney 0
4887979 2323048 2323048 defendant Davy Isabel widow 596230 596230 Davy, Isabel, of South Pederton, widow 0
4887980 2323048 2323048 defendant Clerk Thomas   596230 596230 Clerk, Thomas, of South Pederton, groom 1
4887982 2323048 2323048 defendant Walker John   596230 596230 Walker, John, of South Pederton, groom 3
4887983 2323048 2323048 defendant Pynter William   596230 596230 Pynter, William, of South Pederton, groom 4
4887984 2323048 2323048 defendant Bryan Richard   596230 596230 Bryan, Richard, of South Pederton, groom 5
4887986 2323048 2323048 defendant Caas Robert yeoman 596230 596230 Caas, Robert, of South Pederton, yeoman 7
4887987 2323048 2323048 defendant Waley John husbandman 596230 596230 Waley, John, of South Pederton, husbandman 8
4887988 2323048 2323048 defendant North Richard husbandman 596230 596230 North, Richard, of South Pederton, husbandman 9
4887989 2323048 2323048 defendant Walsham Nicholas husbandman 596230 596230 Walsham, Nicholas, of South Pederton, husbandman 10
4889260 2323427 2323427 defendant Davy Nicholas yeoman 596230 596230 Davy, Nicholas, of South Pederton, yeoman 0
4897744 2325961 2325961 defendant Moleyns William yeoman 596230 596230 Moleyns, William, of South Pederton, yeoman 1
4922764 2333533 2333533 defendant Reynold William mercer 596230 596230 Reynold, William, of South Pederton, mercer 1
4940169 2338957 2338957 defendant Lowys William clerk 596230 596230 Lowys, William, of South Pederton, clerk 1
4940170 2338957 2338957 defendant Caas Nicholas gent 596230 596230 Caas, Nicholas, of South Pederton, gent 2
4940173 2338958 2338958 defendant Lowys William clerk 596230 596230 Lowys, William, of South Pederton, clerk 1
4940174 2338958 2338958 defendant Caas Nicholas gent 596230 596230 Caas, Nicholas, of South Pederton, gent 2
5019388 2362552 2362552 defendant Clerk Thomas husbandman 596230 596230 Clerk, Thomas, of South Pederton, husbandman 0
5019389 2362552 2362552 defendant Welle Philip weaver 596230 596230 Welle, Philip, of South Pederton, weaver 1
5022937 2363618 2363618 defendant Cukkowe alias Benet John   596230 596230 Cukkowe alias Benet, John, of South Pederton, pan beater 1
5079112 2380239 2380239 defendant Caas John, senior gent 596230 596230 Caas, John, senior, of South Pederton, gent 0
5079113 2380239 2380239 defendant Caas John, junior gent 596230 596230 together with Caas, John, junior, of South Pederton, gent 1
5129544 2395128 2395128 defendant Case John gent 596230 596230 Case, John, of South Pederton, gent 0
5129546 2395129 2395129 defendant Caas John, junior gent 596230 596230 Caas, John, junior, of South Pederton, gent 0
5129547 2395129 2395129 defendant Knappe (illegible) yeoman 596230 596230 Knappe, ---, of South Pederton, yeoman 1
5180896 2410155 2410155 defendant Pay John yeoman 596230 596230 Pay, John, of South Pederton, yeoman 0
5180897 2410155 2410155 defendant Smyth John husbandman 596230 596230 Smyth, John, of South Pederton, husbandman 1
5180898 2410155 2410155 defendant More Thomas husbandman 596230 596230 More, Thomas, of South Pederton, husbandman 2
5280848 2439470 2439470 defendant Fynyan Roger   596230 596230 Fynyan, Roger, of South Pederton, holy water clerk 0
5280852 2439471 2439471 defendant Fynyan Roger   596230 596230 Fynyan, Roger, of South Pederton, holy water clerk 0
5283494 2440225 2440225 defendant Pecche William cordwainer 596230 596230 Pecche, William, of South Pederton, cordwainer 0
5289653 2441977 2441977 defendant Taillour Nicholas tailor 596230 596230 Taillour, Nicholas, of South Pederton, tailor 0
5289654 2441977 2441977 defendant Gatpathe William cordwainer 596230 596230 Gatpathe, William, of South Pederton, cordwainer 1
5289655 2441977 2441977 defendant Turner John turner 596230 596230 Turner, John, of South Pederton, turner 2
5289656 2441977 2441977 defendant Broke John fisher 596230 596230 Broke, John, of South Pederton, fisher 3
5289657 2441977 2441977 defendant Balle William   596230 596230 Balle, William, of South Pederton, court holder 4
5289658 2441977 2441977 defendant Blythe Thomas goldsmith 596230 596230 Blythe, Thomas, of South Pederton, goldsmith 5
5289659 2441977 2441977 defendant Fulbreke Richard gent 596230 596230 Fulbreke, Richard, of South Pederton, gent 6

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