names

94 rows where place_id = 599702

✎ 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
3637828 1906649 1906649 defendant Love Simon husbandman 599702 599702 Love, Simon, of South Reppes, husbandman 1
3756098 1943864 1943864 defendant Benyngton Robert husbandman 599702 599702 Benyngton, Robert, of South Reppes, husbandman 1
3756102 1943865 1943865 defendant Goodes Robert clerk 599702 599702 Goodes, Robert, of South Reppes, clerk 0
3762579 1945943 1945943 defendant Flyte Thomas   599702 599702 Flyte, Thomas, of South Reppes, worsted weaver 0
3779913 1951446 1951446 defendant Aleyn John butcher 599702 599702 Aleyn, John, of South Reppes, butcher 0
3809245 1960772 1960772 defendant Warnes Henry butcher 599702 599702 Warnes, Henry, of South Reppes, butcher 0
3831189 1967644 1967644 defendant Purdy John smith 599702 599702 Purdy, John, of South Reppes, smith 2
3840671 1970645 1970645 defendant Warnys Henry butcher 599702 599702 Warnys, Henry, of South Reppes, butcher 2
3852797 1974481 1974481 defendant Aleyn John butcher 599702 599702 Aleyn, John, of South Reppes, butcher 1
3852798 1974481 1974481 defendant Duglas Richard husbandman 599702 599702 Duglas, Richard, of South Reppes, husbandman 2
3862768 1977739 1977739 defendant Warnes Henry butcher 599702 599702 Warnes, Henry, of South Reppes, butcher 1
3862770 1977740 1977740 defendant Warnes Henry butcher 599702 599702 Warnes, Henry, of South Reppes, butcher 0
3879512 1983401 1983401 defendant Aleyn John yeoman 599702 599702 Aleyn, John, of South Reppes, yeoman 0
3879513 1983401 1983401 defendant Andrewes Richard husbandman 599702 599702 Andrewes, Richard, of South Reppes, husbandman 1
3880452 1983718 1983718 defendant Aleyn John, senior yeoman 599702 599702 Aleyn, John, senior, of South Reppes, yeoman 1
3984965 2019380 2019380 defendant Waller Peter yeoman 599702 599702 Waller, Peter, of South Reppes, yeoman 0
3984967 2019381 2019381 defendant Waller Peter yeoman 599702 599702 Waller, Peter, of South Reppes, yeoman 0
3987906 2020420 2020420 defendant Cawson John husbandman 599702 599702 Cawson, John, of South Reppes, husbandman 1
3992695 2022137 2022137 defendant Warnes John   599702 599702 Warnes, John, of South Reppes, tallow chandler 2
3999900 2024734 2024734 plaintiff Gaynte John   599702 599702 Gaynte, John, of South Reppes 0
4028653 2034896 2034896 defendant Nuttall Thomas tailor 599702 599702 Nuttall, Thomas, of South Reppes, tailor 0
4040355 2039055 2039055 defendant Warnes John (legal representative) 599702 599702 Warnes, John, of South Reppes, tallow chandler, executrix of 1
4040356 2039055 2039055 defendant Warnes Agnes   599702 599702 Warnes, Agnes, of South Reppes, widowe 2
4056394 2044670 2044670 defendant Hartstong James gent 599702 599702 Hartstong, James, of South Reppes, gent 0
4079797 2053074 2053074 defendant Cotterell Robert gent 599702 599702 Cotterell, Robert, of South Reppes, gent 0
4084873 2054868 2054868 defendant Wace Thomas husbandman 599702 599702 Wace, Thomas, of South Reppes, husbandman 0
4095921 2058873 2058873 defendant Cubytt Robert husbandman 599702 599702 Cubytt, Robert, of South Reppes, husbandman 0
4111999 2064542 2064542 defendant Skott John yeoman 599702 599702 Skott, John, of South Reppes, yeoman 1
4112000 2064542 2064542 defendant Purgall Crispin cordwainer 599702 599702 Purgall, Crispin, of South Reppes, cordwainer 2
4127482 2070123 2070123 defendant Croppe William gent 599702 599702 Croppe, William, of South Reppes, gent 0
4143987 2076060 2076060 defendant Howes Robert yeoman 599702 599702 Howes, Robert, of South Reppes, yeoman 0
4144552 2076255 2076255 defendant Ayde Edward yeoman 599702 599702 Ayde, Edward, of South Reppes, yeoman 1
4144735 2076320 2076320 defendant Howse Robert yeoman 599702 599702 Howse, Robert, of South Reppes, yeoman 0
4147292 2077192 2077192 defendant Dennys James husbandman 599702 599702 Dennys, James, of South Reppes, husbandman 0
4147293 2077192 2077192 defendant Harstonge James gent 599702 599702 together with Harstonge, James, of South reppes, gent 1
4148149 2077485 2077485 defendant Hartstonge James gent 599702 599702 Hartstonge, James, of South Reppes, gent 0
4149390 2077914 2077914 defendant Howse Robert yeoman 599702 599702 Howse, Robert, of South Reppes, yeoman 0
4150746 2078401 2078401 defendant Bateman Robert yeoman 599702 599702 Bateman, Robert, of South Reppes, yeoman 2
4152245 2078895 2078895 defendant Olyver Thomas husbandman 599702 599702 Olyver, Thomas, of South Reppes, husbandman 3
4162301 2082375 2082375 defendant Hartstonge James gent 599702 599702 Hartstonge, James, of South Reppes, gent 0
4172663 2085898 2085898 defendant Hartstonge James gent 599702 599702 Hartstonge, James, of South Reppes, or of Lincolns Inn, Middx, gent 0
4172665 2085899 2085899 defendant Hartstonge James gent 599702 599702 Hartstonge, James, of South Reppes, or of Lincolns Inn, Middx, gent 0
4172668 2085900 2085900 defendant Hartstronge James gent 599702 599702 Hartstronge, James, of South Reppes, or of Lincolns Inn, Middx, gent 0
4172670 2085901 2085901 defendant Hartstronge James gent 599702 599702 Hartstronge, James, of South Reppes, or of Lincolns Inn, Middx, gent 0
4178407 2087923 2087923 defendant Atwood Robert gent 599702 599702 Atwood, Robert, of South Reppes, gent 0
4183463 2089695 2089695 defendant Baker John   599702 599702 Baker, John, of South Reppes, oatmeal maker 0
4187223 2091023 2091023 defendant Ayde Edward yeoman 599702 599702 Ayde, Edward, of South Reppes, yeoman 0
4195931 2094130 2094130 defendant Hobbes John thatcher 599702 599702 Hobbes, John, of South Reppes, thatcher 2
4209477 2098862 2098862 defendant Coplande Nicholas husbandman 599702 599702 Coplande, Nicholas, of South Reppes, husbandman 3
4222155 2103239 2103239 defendant Mundes William yeoman 599702 599702 Mundes, William, of South Reppes, yeoman 1
4248888 2112613 2112613 defendant Purgold Crispian shoemaker 599702 599702 Purgold, Crispian, of South Reppes, shoemaker 3
4323828 2138382 2138382 defendant Bateman Robert, junior yeoman 599702 599702 Bateman, Robert, junior, of South Reppes, yeoman 0
4325755 2138989 2138989 defendant Bradfyld Richard, junior blacksmith 599702 599702 Bradfyld, Richard, junior, of South Reppes, blacksmith 0
4325757 2138990 2138990 defendant Bradfyld Richard, junior blacksmith 599702 599702 Bradfyld, Richard, junior, of South Reppes, blacksmith 0
4325758 2138990 2138990 defendant Bennyngton Thomas husbandman 599702 599702 Bennyngton, Thomas, of South Reppes, husbandman 1
4336300 2142430 2142430 defendant Love John butcher 599702 599702 Love, John, of South Reppes, butcher 2
4352631 2148154 2148154 defendant Gryme Thomas gent 599702 599702 Gryme, Thomas, of South Reppes, gent 0
4386982 2160301 2160301 defendant Gryme Thomas yeoman 599702 599702 Gryme, Thomas, of South Reppes, yeoman 2
4406487 2166733 2166733 defendant Cotterell Robert gent 599702 599702 Cotterell, Robert, of South Reppes, gent 0
4543495 2213855 2213855 plaintiff atte Lound John   599702 599702 atte Lound, John, of South Reppes 0
4551638 2216457 2216457 defendant Taylour Clement   599702 599702 Taylour, Clement, of South Reppes 0
4583544 2226276 2226276 plaintiff Frere William   599702 599702 Frere, William, of South Reppes, parson 0
4605934 2232970 2232970 plaintiff atte Lound William   599702 599702 atte Lound, William, of South Reppes 0
4634272 2241560 2241560 plaintiff Williamesson Thomas   599702 599702 Williamesson, Thomas, of South Reppes 0
4650391 2246138 2246138 plaintiff Willyamesson Thomas   599702 599702 Willyamesson, Thomas, of South Reppes 1
4685366 2261018 2261018 defendant Fraunceys Roger husbandman 599702 599702 Fraunceys, Roger, of South Reppes, husbandman 0
4694467 2263763 2263763 defendant Kydlomb John husbandman 599702 599702 Kydlomb, John, of South Reppes, husbandman 0
4694470 2263764 2263764 defendant Hokere Roger yeoman 599702 599702 Hokere, Roger, of South Reppes, yeoman 0
4718167 2271020 2271020 defendant Fayrecok Richard yeoman 599702 599702 Fayrecok, Richard, of South Reppes, yeoman 0
4728567 2274173 2274173 defendant Colgard Thomas shoemaker 599702 599702 Colgard, Thomas, of South Reppes, shoemaker 0
4733513 2275657 2275657 defendant atte Lound William (legal representative) 599702 599702 atte Lound, William, of South Reppes, executors of 0
4733514 2275657 2275657 defendant Willyamson Adam yeoman 599702 599702 (Willyamson, Adam, of South Reppes, yeoman 1
4733516 2275657 2275657 defendant Fayecok Adam yeoman 599702 599702 Fayecok, Adam, of South Reppes, yeoman 3
4774127 2287894 2287894 defendant Mayson Clement husbandman 599702 599702 Mayson, Clement, of South Reppes, husbandman 0
4848782 2311079 2311079 defendant Clerke John husbandman 599702 599702 Clerke, John, of South Reppes, husbandman 1
4873016 2318519 2318519 defendant Kydelham John yeoman 599702 599702 Kydelham, John, of South Reppes, yeoman 2
4909793 2329585 2329585 defendant Kydlam John yeoman 599702 599702 (Kydlam, John, of South Reppes, yeoman 2
4913501 2330719 2330719 defendant Douglas Robert husbandman 599702 599702 Douglas, Robert, of South Reppes, husbandman 0
4996110 2355693 2355693 defendant Clerk Adam yeoman 599702 599702 Clerk, Adam, of South Reppes, yeoman 2
4996111 2355693 2355693 defendant Hanworth John   599702 599702 Hanworth, John, of South Reppes, cartwright 3
5075186 2379074 2379074 defendant Clerk Adam husbandman 599702 599702 Clerk, Adam, of South Reppes, husbandman 4
5075198 2379075 2379075 defendant Clerk Adam husbandman 599702 599702 Clerk, Adam, of South Reppes, husbandman 5
5116033 2391118 2391118 defendant Kedilham Thomas yeoman 599702 599702 Kedilham, Thomas, of South Reppes, yeoman 0
5139282 2397978 2397978 defendant Lownde Thomas   599702 599702 Lownde, Thomas, of South Reppes 0
5214509 2419973 2419973 defendant Barker John husbandman 599702 599702 Barker, John, of South Reppes, husbandman 1
5258293 2432713 2432713 defendant Love or Lone George shoemaker 599702 599702 Love or Lone, George, of South Reppes, shoemaker 1
5258294 2432713 2432713 defendant Love or Lone Robert shoemaker 599702 599702 Love or Lone, Robert, of South Reppes, shoemaker 2
5366114 2465064 2465064 defendant Clerk Adam   599702 599702 Clerk, Adam, of South Reppes, yeoman, administrators of 2
5366115 2465064 2465064 defendant Clerk John husbandman 599702 599702 (Clerk, John, of South Reppes, husbandman 3
5383156 2470256 2470256 defendant Howys alias Athough John (legal representative) 599702 599702 Howys alias Athough, John, of South Reppes, yeoman, executrix of 0
5383157 2470256 2470256 defendant Howys Margaret widow 599702 599702 Howys, Margaret, of South Reppes, widow 1
5471638 2496467 2496467 defendant Laxton William yeoman 599702 599702 Laxton, William, of South Reppes, yeoman 0
5575309 2527368 2527368 defendant Harward John gent 599702 599702 Harward, John, of South Reppes, gent 1
5634820 2554887 2554887 defendant Pykeston Richard husbandman 599702 599702 Pykeston, Richard, of South Reppes, husbandman 2

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