names

57 rows where place_id = 593376

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3611545 1871280 1871280 defendant Doget Henry tailor 593376 593376 Doget, Henry, of Wendover, Bucks, tailor 0
3628970 1903936 1903936 defendant Wykcokk Thomas yeoman 593376 593376 Wykcokk, Thomas, of Wendover, Bucks, yeoman 0
3660503 1913547 1913547 defendant Bradshaw William yeoman 593376 593376 Bradshaw, William, of Wendover, Bucks, yeoman 0
3745920 1940630 1940630 defendant Kyngeston Ralph yeoman 593376 593376 Kyngeston, Ralph, of Wendover, Bucks, yeoman 1
3831663 1967800 1967800 defendant Hare Robert yeoman 593376 593376 Hare, Robert, of Wendover, Bucks, yeoman 0
3831666 1967801 1967801 defendant Hare Robert yeoman 593376 593376 Hare, Robert, of Wendover, Bucks, yeoman 0
3846307 1972400 1972400 defendant Hare Robert yeoman 593376 593376 Hare, Robert, of Wendover, Bucks, yeoman 0
3859439 1976646 1976646 defendant Hare Robert husbandman 593376 593376 Hare, Robert, of Wendover, Bucks, husbandman 2
3859444 1976647 1976647 defendant Hare Robert husbandman 593376 593376 Hare, Robert, of Wendover, Bucks, husbandman 2
3914695 1995259 1995259 defendant Hare Robert innholder 593376 593376 Hare, Robert, of Wendover, Bucks, innholder 0
3914697 1995260 1995260 defendant Hare Robert innholder 593376 593376 Hare, Robert, of Wendover, Bucks, innholder 0
4007516 2027471 2027471 defendant Prystman John shoemaker 593376 593376 Prystman, John, of Wendover, Bucks, shoemaker 3
4021579 2032445 2032445 defendant Burwell Alexander innholder 593376 593376 Burwell, Alexander, of Wendover, Bucks, innholder 2
4028989 2035011 2035011 defendant Okebanke William yeoman 593376 593376 Okebanke, William, of Wendover, Bucks, yeoman 0
4029004 2035017 2035017 defendant Okebanke William yeoman 593376 593376 Okebanke, William, of Wendover, Bucks, yeoman 0
4034153 2036877 2036877 defendant Frye Henry yeoman 593376 593376 Frye, Henry, of Wendover, Bucks, yeoman 0
4086490 2055452 2055452 defendant Rutte Thomas clothier 593376 593376 Rutte, Thomas, of Wendover, Bucks, clothier 0
4093712 2058076 2058076 defendant Rutte Thomas clothier 593376 593376 Rutte, Thomas, of Wendover, Bucks, clothier 0
4096767 2059174 2059174 defendant Frye Henry yeoman 593376 593376 Frye, Henry, of Wendover, Bucks, yeoman 1
4099711 2060222 2060222 defendant Ockebank Edmund yeoman 593376 593376 Ockebank, Edmund, of Wendover, Bucks, yeoman 0
4110959 2064169 2064169 defendant Frye Henry yeoman 593376 593376 Frye, Henry, of Wendover, Bucks, yeoman 0
4123591 2068739 2068739 defendant Wright George gent 593376 593376 Wright, George, of Wendover, Bucks, gent 0
4128494 2070482 2070482 defendant Free Henry yeoman 593376 593376 Free, Henry, of Wendover, Bucks, yeoman 0
4141269 2075107 2075107 defendant Borowe Edward chapman 593376 593376 Borowe, Edward, of Wendover, Bucks, chapman 0
4149936 2078108 2078108 defendant Borewell alias Borowe Alexander innholder 593376 593376 Borewell alias Borowe, Alexander, of Wendover, Bucks, yeoman, innholder 0
4177283 2087525 2087525 defendant Free Henry yeoman 593376 593376 Free, Henry, of Wendover, Bucks, yeoman 0
4188176 2091368 2091368 defendant Wryght George gent 593376 593376 Wryght, George, of Wendover, Bucks, gent 0
4191227 2092495 2092495 defendant Hill Nicholas chapman 593376 593376 Hill, Nicholas, of Wendover, Bucks, chapman 0
4201784 2096171 2096171 defendant Ledgingham Michael gent 593376 593376 Ledgingham, Michael, of Wendover, Bucks, gent 1
4203389 2096735 2096735 defendant Grace John innholder 593376 593376 Grace, John, of Wendover, Bucks, innholder 0
4211814 2099682 2099682 defendant Free Henry yeoman 593376 593376 Free, Henry, of Wendover, Bucks, yeoman 3
4303349 2131298 2131298 defendant Moore Richard   593376 593376 Moore, Richard, of Wendover, Bucks, collar maker 1
4314874 2135316 2135316 defendant Free Thomas yeoman 593376 593376 Free, Thomas, of Wendover, Bucks, yeoman 2
4320721 2137342 2137342 defendant Hill Robert woolman 593376 593376 Hill, Robert, of Wendover, Bucks, woolman 2
4343318 2144935 2144935 defendant Gibson Christopher yeoman 593376 593376 Gibson, Christopher, of Wendover, Bucks, yeoman 0
4349448 2147071 2147071 defendant Lamburne Edward gent 593376 593376 Lamburne, Edward, of Wendover, Bucks, gent 0
4349450 2147072 2147072 defendant Lamburne Edward gent 593376 593376 Lamburne, Edward, of Wendover, Bucks, gent 0
4354230 2148709 2148709 defendant Ellinge Richard chandler 593376 593376 Ellinge, Richard, of Wendover, Bucks, chandler 0
4367035 2153265 2153265 defendant Gibson Christopher yeoman 593376 593376 Gibson, Christopher, of Wendover, Bucks, yeoman 0
4392098 2161983 2161983 defendant Higgons Edmund blacksmith 593376 593376 Higgons, Edmund, of Wendover, Bucks, blacksmith 2
4392721 2162184 2162184 defendant Hill Barnard yeoman 593376 593376 Hill, Barnard, of Wendover, Bucks, yeoman 0
4392723 2162185 2162185 defendant Hill Ralph yeoman 593376 593376 Hill, Ralph, of Wendover, Bucks, yeoman 0
4449895 2184922 2184922 defendant Wamburgh John   593376 593376 Wamburgh, John, of Wendover, Bucks, vicar 0
4701033 2265727 2265727 defendant Adekyn Richard husbandman 593376 593376 Adekyn, Richard, of Wendover, Bucks, husbandman 0
4719781 2271533 2271533 defendant atte Felde Thomas husbandman 593376 593376 atte Felde, Thomas, of Wendover, Bucks, husbandman 0
4767037 2285679 2285679 defendant Bedford Agnes widow 593376 593376 Bedford, Agnes, of Wendover, Bucks, widow 0
4844073 2309657 2309657 defendant Cokke John tanner 593376 593376 Cokke, John, of Wendover, Bucks, tanner 0
5166891 2406046 2406046 defendant Halle William tailor 593376 593376 Halle, William, of Wendover, Bucks, tailor 3
5244322 2428523 2428523 defendant Boston John draper 593376 593376 Boston, John, of Wendover, Bucks, draper 3
5269990 2436329 2436329 defendant Spycer Robert chapman 593376 593376 Spycer, Robert, of Wendover, Bucks, chapman 0
5271827 2436856 2436856 defendant Dalk-- Richard butcher 593376 593376 Dalk--, Richard, of Wendover, Bucks, butcher 4
5441401 2487347 2487347 defendant Lechyngham Robert esq 593376 593376 Lechyngham, Robert, of Wendover, Bucks, esq 1
5456898 2491968 2491968 defendant Lechyngham Robert esq 593376 593376 Lechyngham, Robert, of Wendover, Bucks, esq 1
5515558 2509707 2509707 defendant Bocher Nicholas butcher 593376 593376 Bocher, Nicholas, of Wendover, Bucks, butcher 3
5556242 2521822 2521822 defendant Legyngham Robert esq 593376 593376 Legyngham, Robert, of Wendover, Bucks, esq 0
5581378 2529245 2529245 defendant Wilcokkys Thomas yeoman 593376 593376 Wilcokkys, Thomas, of Wendover, Bucks, yeoman 1
5584736 2530300 2530300 defendant Bradshawe William yeoman 593376 593376 Bradshawe, William, of Wendover, Bucks, yeoman 1

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