names

81 rows where place_id = 592296

✎ 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
3607248 1869932 1869932 plaintiff Reder Richard (legal representative) 592296 592296 Reder, Richard, of Petresfeld, executors of 0
3607249 1869932 1869932 plaintiff Reder Richard   592296 592296 (Reder, Richard, of Petresfeld 1
3612735 1871630 1871630 defendant Martyn John, junior capper 592296 592296 Martyn, John, junior, of Petresfeld, capper 0
3612737 1871631 1871631 defendant Martyn John capper 592296 592296 Martyn, John, of Petresfeld, capper 0
3678774 1919429 1919429 defendant Chalwyn Ralph miller 592296 592296 Chalwyn, Ralph, of Petresfeld, miller 0
3702937 1927188 1927188 defendant Parson Richard miller 592296 592296 Parson, Richard, of Petresfeld, miller 0
3722756 1933383 1933383 defendant Pagelsham Alice widow 592296 592296 Pagelsham, Alice, of Petresfeld, widow 5
3723239 1933539 1933539 defendant Paglesham Margaret widow 592296 592296 Paglesham, Margaret, of Petresfeld, widow 1
3739671 1938620 1938620 defendant Selwod John butcher 592296 592296 Selwod, John, of Petresfeld, butcher 0
3739672 1938620 1938620 defendant att Wodde Richard husbandman 592296 592296 att Wodde, Richard, of Petresfeld, husbandman 1
3762185 1945817 1945817 defendant Felder William yeoman 592296 592296 Felder, William, of Petresfeld, yeoman 0
3762187 1945818 1945818 defendant Machyn Robert yeoman 592296 592296 Machyn, Robert, of Petresfeld, yeoman 0
3762188 1945818 1945818 defendant Selwode Henry barber 592296 592296 Selwode, Henry, of Petresfeld, barber 1
3762189 1945818 1945818 defendant Gylden John baker 592296 592296 Gylden, John, of Petresfeld, baker 2
3762190 1945818 1945818 defendant Shorter Henry tailor 592296 592296 Shorter, Henry, of Petresfeld, tailor 3
3762191 1945818 1945818 defendant Selwode John butcher 592296 592296 Selwode, John, of Petresfeld, butcher 4
3773321 1949367 1949367 defendant Andrewes John husbandman 592296 592296 Andrewes, John, of Petresfeld, husbandman 0
3777073 1950578 1950578 defendant Swetewyche John miller 592296 592296 Swetewyche, John, of Petresfeld, miller 0
3777985 1950826 1950826 defendant Stedman Thomas sawyer 592296 592296 Stedman, Thomas, of Petresfeld, sawyer 1
3804392 1959310 1959310 defendant Bold William yeoman 592296 592296 Bold, William, of Petresfeld, yeoman 0
3804393 1959310 1959310 defendant Hurst Richard smith 592296 592296 Hurst, Richard, of Petresfeld, smith 1
3814376 1962410 1962410 defendant Selwood John butcher 592296 592296 Selwood, John, of Petresfeld, butcher 0
3818053 1963558 1963558 defendant Hawsted Richard yeoman 592296 592296 Hawsted, Richard, of Petresfeld, yeoman 0
4427037 2173275 2173275 defendant atte Felde Walter merchant 592296 592296 atte Felde, Walter, of Petresfeld, merchant 0
4486947 2196635 2196635 defendant Solvyll John   592296 592296 Solvyll, John, of Petresfeld 2
4552125 2216613 2216613 defendant Cully Thomas   592296 592296 Cully, Thomas, of Petresfeld 0
4659981 2248972 2248972 defendant Bans William   592296 592296 Bans, William, of Petresfeld, "tapyner" 3
4674417 2257611 2257611 defendant Clere Thomas tanner 592296 592296 Clere, Thomas, of Petresfeld, tanner 0
4675786 2258035 2258035 defendant Lane Thomas husbandman 592296 592296 Lane, Thomas, of Petresfeld, husbandman 0
4689418 2262249 2262249 defendant Sydenhale William yeoman & formerly bailiff of the Hundred of Fynchesden 592296 592296 Sydenhale, William, of Petresfeld, yeoman & formerly bailiff of the Hundred of Fynchesden 2
4710754 2268717 2268717 defendant Setenale William husbandman 592296 592296 Setenale, William, of Petresfeld, husbandman 0
4787393 2292125 2292125 defendant Cotys John tanner 592296 592296 Cotys, John, of Petresfeld, tanner 0
4787394 2292125 2292125 defendant Hende Thomas tanner 592296 592296 Hende, Thomas, of Petresfeld, tanner 1
4859903 2314467 2314467 defendant Hendy Thomas   592296 592296 Hendy, Thomas, of Petresfeld, millward 3
4900162 2326676 2326676 defendant Brewere Roger (legal representative) 592296 592296 Brewere, Roger, of Petresfeld, executors of 1
4900163 2326676 2326676 defendant Alphous Oliver husbandman 592296 592296 (Alphous, Oliver, of Petresfeld, husbandman 2
4963826 2346091 2346091 defendant Gribby John butcher 592296 592296 Gribby, John, of Petresfeld, butcher 2
5038752 2368236 2368236 defendant atte Hylle Peter laborer 592296 592296 atte Hylle, Peter, of Petresfeld, laborer 1
5052923 2372465 2372465 defendant Holewey John fuller 592296 592296 Holewey, John, of Petresfeld, fuller 0
5096031 2385268 2385268 defendant Laurence Richard merchant 592296 592296 Laurence, Richard, of Petresfeld, merchant 0
5099019 2386144 2386144 defendant Kaysm William tanner 592296 592296 Kaysm William, of Petresfeld, tanner 2
5099020 2386144 2386144 defendant Hykkes Stephen   592296 592296 Hykkes, Stephen, of Petresfeld, millward 3
5099033 2386148 2386148 defendant Bele Richard yeoman 592296 592296 Bele, Richard, of Petresfeld, yeoman 0
5099034 2386148 2386148 defendant Marner John tailor 592296 592296 Marner, John, of Petresfeld, tailor 1
5099035 2386148 2386148 defendant Stoner John yeoman 592296 592296 Stoner, John, of Petresfeld, yeoman 2
5101202 2386760 2386760 defendant Stynte Thomas husbandman 592296 592296 Stynte, Thomas, of Petresfeld, husbandman 0
5101203 2386760 2386760 defendant Bele Richard butcher 592296 592296 Bele, Richard, of Petresfeld, butcher 1
5109724 2389270 2389270 defendant Felder Thomas weaver 592296 592296 Felder, Thomas, of Petresfeld, weaver 0
5132198 2395909 2395909 defendant Patryk John husbandman 592296 592296 Patryk, John, of Petresfeld, husbandman 1
5139316 2397988 2397988 defendant Ryder Richard chapman 592296 592296 Ryder, Richard, of Petresfeld, chapman 1
5139317 2397988 2397988 defendant atte More Thomas husbandman 592296 592296 atte More, Thomas, of Petresfeld, husbandman 2
5151761 2401675 2401675 defendant Patryk John husbandman 592296 592296 Patryk, John, of Petresfeld, husbandman 1
5178394 2409389 2409389 defendant Berkeherst John   592296 592296 Berkeherst, John, of Petresfeld 0
5178395 2409389 2409389 defendant Stynte Thomas husbandman 592296 592296 Stynte, Thomas, of Petresfeld, husbandman 1
5178396 2409389 2409389 defendant Bele Margery widow 592296 592296 Bele, Margery, of Petresfeld, widow 2
5208918 2418334 2418334 defendant Audeknep John weaver 592296 592296 Audeknep, John, of Petresfeld, weaver 0
5312748 2448848 2448848 defendant Turgys Thomas saddler 592296 592296 Turgys, Thomas, of Petresfeld, saddler 3
5324632 2452444 2452444 defendant Grene Nicholas butcher 592296 592296 Grene, Nicholas, of Petresfeld, butcher 0
5329311 2453851 2453851 plaintiff Arnold William (legal representative) 592296 592296 Arnold, William, of Petresfeld, executors of 0
5330429 2454180 2454180 defendant Knyght Robert glover 592296 592296 Knyght, Robert, of Petresfeld, glover 0
5330430 2454180 2454180 defendant Randolf Richard husbandman 592296 592296 Randolf, Richard, of Petresfeld, husbandman 1
5349245 2459894 2459894 defendant Hall Henry yeoman 592296 592296 Hall, Henry, of Petresfeld, yeoman 0
5366279 2465110 2465110 defendant Knyght Robert glover 592296 592296 Knyght, Robert, of Petresfeld, glover 0
5396939 2474209 2474209 defendant Knyght Robert glover 592296 592296 Knyght, Robert, of Petresfeld, glover 0
5410235 2478013 2478013 defendant Knyght Robert glover 592296 592296 Knyght, Robert, of Petresfeld, glover 0
5410236 2478013 2478013 defendant Poynet John butcher 592296 592296 Poynet, John, of Petresfeld, butcher 1
5412496 2478684 2478684 defendant Morer Thomas miller 592296 592296 Morer, Thomas, of Petresfeld, miller 0
5422116 2481557 2481557 defendant Frenssh John weaver 592296 592296 Frenssh, John, of Petresfeld, weaver 0
5423956 2482119 2482119 defendant Knyght Robert glover 592296 592296 Knyght, Robert, of Petresfeld, glover 0
5423957 2482119 2482119 defendant Poynet John butcher 592296 592296 Poynet, John, of Petresfeld, butcher 1
5427302 2483110 2483110 defendant Morer Thomas miller 592296 592296 Morer, Thomas, of Petresfeld, miller 0
5436019 2485713 2485713 defendant Bygnole Richard mercer 592296 592296 Bygnole, Richard, of Petresfeld, mercer 0
5442823 2487766 2487766 defendant Randolf Richard husbandman 592296 592296 Randolf, Richard, of Petresfeld, husbandman 5
5446526 2488848 2488848 defendant Poynat John butcher 592296 592296 Poynat, John, of Petresfeld, butcher 0
5454079 2491115 2491115 defendant Bygnall Richard   592296 592296 Bygnall, Richard, of Petresfeld 0
5458150 2492346 2492346 defendant Denys John weaver 592296 592296 Denys, John, of Petresfeld, weaver 0
5458587 2492461 2492461 defendant Frenshe John weaver 592296 592296 Frenshe, John, of Petresfeld, weaver 0
5462991 2493841 2493841 defendant Rede Richard esq 592296 592296 Rede, Richard, of Petresfeld, esq 0
5462992 2493841 2493841 defendant Webbe Richard yeoman 592296 592296 Webbe, Richard, of Petresfeld, yeoman 1
5486133 2500739 2500739 defendant Webbe William yeoman 592296 592296 Webbe, William, of Petresfeld, yeoman 2
5501723 2505471 2505471 defendant Parker Thomas barber 592296 592296 Parker, Thomas, of Petresfeld, barber 0

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