names

79 rows where place_id = 657168

✎ 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
3943306 2004780 2004780 defendant Fodfrey Thomas yeoman 657168 657168 Fodfrey, Thomas, of Burwashe, yeoman 0
3943307 2004780 2004780 defendant Weston William butcher 657168 657168 Weston, William, of Burwashe, butcher 1
4065585 2047982 2047982 plaintiff Hebden John yeoman 657168 657168 Hebden, John, of Burwashe, yeoman 0
4097160 2059307 2059307 defendant Tompset Hugh husbandman 657168 657168 Tompset, Hugh, of Burwashe, husbandman 1
4117770 2066647 2066647 defendant Goodsall Agnes widow 657168 657168 Goodsall, Agnes, of Burwashe, widow 1
4133437 2072284 2072284 defendant Fyllen alias Fennell Nicholas collier 657168 657168 Fyllen alias Fennell, Nicholas, of Burwashe, collier 2
4149984 2078128 2078128 defendant Snepp Michael husbandman 657168 657168 Snepp, Michael, of Burwashe, husbandman 0
4149985 2078128 2078128 defendant Dennett Henry husbandman 657168 657168 Dennett, Henry, of Burwashe, husbandman 1
4165059 2083285 2083285 defendant Awcocke John husbandman 657168 657168 Awcocke, John, of Burwashe, husbandman 1
4165060 2083285 2083285 defendant Foster Lawrence husbandman 657168 657168 Foster, Lawrence, of Burwashe, husbandman 2
4166912 2083925 2083925 defendant Hodelye Robert husbandman 657168 657168 Hodelye, Robert, of Burwashe, husbandman 0
4182577 2089384 2089384 defendant Ellys Thomas yeoman 657168 657168 Ellys, Thomas, of Burwashe, yeoman 0
4223495 2103708 2103708 defendant Roper John yeoman 657168 657168 Roper, John, of Burwashe, yeoman 1
4225180 2104277 2104277 defendant Hodge John yeoman 657168 657168 (Hodge, John, of Burwashe, yeoman 1
4225428 2104357 2104357 defendant Mackley Richard glasier 657168 657168 Mackley, Richard, of Burwashe, glasier 3
4225803 2104489 2104489 defendant Braban Edward yeoman 657168 657168 Braban, Edward, of Burwashe, yeoman 0
4229075 2105652 2105652 defendant Blachenden Roger yeoman 657168 657168 Blachenden, Roger, of Burwashe, or of Tysherst, yeoman 0
4233067 2107073 2107073 defendant Bryant Richard husbandman 657168 657168 Bryant, Richard, of Burwashe, husbandman 2
4234650 2107665 2107665 defendant Hollande John turner 657168 657168 Hollande, John, of Burwashe, turner 2
4237245 2108613 2108613 defendant Hollandes Thomas turner 657168 657168 Hollandes, Thomas, of Burwashe, turner 1
4239302 2109366 2109366 defendant Horley Robert yeoman 657168 657168 Horley, Robert, of Burwashe, yeoman 1
4239303 2109366 2109366 defendant Tuttey William collier 657168 657168 Tuttey, William, of Burwashe, collier 2
4243105 2110685 2110685 defendant Goodsall Stephen yeoman 657168 657168 Goodsall, Stephen, of Burwashe, yeoman 0
4243106 2110685 2110685 defendant Tayler Samuel yeoman 657168 657168 Tayler, Samuel, of Burwashe, yeoman 1
4244793 2111246 2111246 defendant Buckhurste William clothier 657168 657168 Buckhurste, William, of Burwashe, clothier 0
4258735 2115887 2115887 defendant Blachenden Roger yeoman 657168 657168 Blachenden, Roger, of Burwashe, or of Tysherst, yeoman 0
4263453 2117440 2117440 defendant Roper John yeoman 657168 657168 Roper, John, of Burwashe, yeoman 1
4272486 2120372 2120372 defendant Tuttye William collier 657168 657168 Tuttye, William, of Burwashe, collier 1
4285447 2124842 2124842 defendant Blachenden Roger yeoman 657168 657168 Blachenden, Roger, of Burwashe, yeoman 0
4310237 2133736 2133736 defendant Downer John yeoman 657168 657168 Downer, John, of Burwashe, yeoman 0
4311439 2134144 2134144 defendant Barnes Anthony husbandman 657168 657168 Barnes, Anthony, of Burwashe, husbandman 0
4312730 2134584 2134584 defendant Reede Abraham collier 657168 657168 Reede, Abraham, of Burwashe, collier 0
4312771 2134597 2134597 defendant Weekes Thomas sawyer 657168 657168 Weekes, Thomas, of Burwashe, sawyer 2
4313325 2134768 2134768 defendant Tompsett Hugh yeoman 657168 657168 Tompsett, Hugh, of Burwashe, yeoman 0
4313549 2134848 2134848 defendant Rooper Richard butcher 657168 657168 Rooper, Richard, of Burwashe, butcher 0
4314327 2135120 2135120 defendant Batcheller Henry yeoman 657168 657168 Batcheller, Henry, of Burwashe, yeoman 0
4314328 2135120 2135120 defendant Rooper John butcher 657168 657168 Rooper, John, of Burwashe, butcher 1
4317697 2136303 2136303 defendant Wooddey John tailor 657168 657168 Wooddey, John, of Burwashe, tailor 0
4319315 2136865 2136865 defendant Rooper John butcher 657168 657168 Rooper, John, of Burwashe, butcher 1
4324842 2138695 2138695 defendant Bowman Thomas   657168 657168 Bowman, Thomas, of Burwashe, hemp dresser 3
4326178 2139124 2139124 defendant Weekes Thomas sawyer 657168 657168 Weekes, Thomas, of Burwashe, sawyer 2
4326179 2139124 2139124 defendant Gardner John husbandman 657168 657168 Gardner, John, of Burwashe, husbandman 3
4328448 2139828 2139828 defendant Ellys Thomas yeoman 657168 657168 Ellys, Thomas, of Burwashe, or of Heathfeld, yeoman 2
4330642 2140541 2140541 defendant Woddey John tailor 657168 657168 Woddey, John, of Burwashe, tailor 0
4333007 2141324 2141324 defendant Ven Thomas sawyer 657168 657168 Ven, Thomas, of Burwashe, sawyer 0
4333008 2141324 2141324 defendant Ellys Arthur husbandman 657168 657168 Ellys, Arthur, of Burwashe, husbandman 1
4358355 2150154 2150154 defendant Cruttenden John, junior yeoman 657168 657168 Cruttenden, John, junior, of Burwashe, yeoman 1
4359215 2150454 2150454 defendant Waterer John husbandman 657168 657168 Waterer, John, of Burwashe, husbandman 0
4359369 2150511 2150511 defendant Cruttenden Goddard butcher 657168 657168 Cruttenden, Goddard, of Burwashe, butcher 0
4361756 2151363 2151363 defendant Stephens Edward yeoman 657168 657168 Stephens, Edward, of Burwashe, yeoman 0
4365043 2152552 2152552 defendant Blachenden Roger yeoman 657168 657168 Blachenden, Roger, of Burwashe, yeoman 0
4365071 2152562 2152562 defendant Goodsold or Goodsolle Stephen yeoman 657168 657168 Goodsold or Goodsolle, Stephen, of Burwashe, yeoman 3
4365090 2152568 2152568 defendant Awcocke John   657168 657168 Awcocke, John, of Burwashe, wheelwright 1
4365091 2152568 2152568 defendant Mackley Richard glasier 657168 657168 Mackley, Richard, of Burwashe, glasier 2
4365092 2152568 2152568 defendant Foster Lawrence husbandman 657168 657168 Foster, Lawrence, of Burwashe, husbandman 3
4368436 2153755 2153755 defendant Smart Roger husbandman 657168 657168 Smart, Roger, of Burwashe, husbandman 0
4374377 2155902 2155902 defendant Collen Edward yeoman 657168 657168 Collen, Edward, of Burwashe, yeoman 2
4376406 2156632 2156632 defendant Butler John smith 657168 657168 Butler, John, of Burwashe, smith 0
4376407 2156632 2156632 defendant Reede Abraham husbandman 657168 657168 Reede, Abraham, of Burwashe, husbandman 1
4376412 2156634 2156634 defendant Cruttenden John yeoman 657168 657168 Cruttenden, John, of Burwashe, yeoman 0
4376414 2156634 2156634 defendant Cruttenden Godderd butcher 657168 657168 Cruttenden, Godderd, of Burwashe, butcher 2
4376419 2156635 2156635 defendant Weekes Thomas sawyer 657168 657168 Weekes, Thomas, of Burwashe, sawyer 2
4376420 2156635 2156635 defendant Tuttey William collier 657168 657168 Tuttey, William, of Burwashe, collier 3
4377854 2157149 2157149 defendant Goodsole Stephen yeoman 657168 657168 Goodsole, Stephen, of Burwashe, yeoman 0
4377856 2157149 2157149 defendant Horley Robert yeoman 657168 657168 Horley, Robert, of Burwashe, yeoman 2
4379974 2157939 2157939 defendant Cunnye Simon   657168 657168 Cunnye, Simon, of Burwashe, "ashyealer" 1
4379977 2157940 2157940 defendant Cunnye Simon   657168 657168 Cunnye, Simon, of Burwashe, "ashyealer" 1
4399071 2164271 2164271 defendant Entsall or Gutsall Thomas yeoman 657168 657168 Entsall or Gutsall, Thomas, of Burwashe, yeoman 1
4403207 2165643 2165643 defendant Cruttenden Goddard butcher 657168 657168 Cruttenden, Goddard, of Burwashe, butcher 0
4405551 2166430 2166430 defendant Goodsold or Goodsole Stephen yeoman 657168 657168 Goodsold or Goodsole, Stephen, of Burwashe, yeoman 0
4405552 2166430 2166430 defendant Cruttenden John yeoman 657168 657168 Cruttenden, John, of Burwashe, yeoman 1
4405553 2166430 2166430 defendant Cruttenden Godderd butcher 657168 657168 Cruttenden, Godderd, of Burwashe, butcher 2
4405564 2166433 2166433 defendant Weekes Thomas sawyer 657168 657168 Weekes, Thomas, of Burwashe, sawyer 2
4405565 2166433 2166433 defendant Tuttey William collier 657168 657168 Tuttey, William, of Burwashe, collier 3
4407206 2166973 2166973 defendant Cruttenden Henry tailor 657168 657168 Cruttenden, Henry, of Burwashe, tailor 2
4407209 2166973 2166973 defendant Horne alias Hornesbye Thomas laborer 657168 657168 Horne alias Hornesbye, Thomas, of Burwashe, laborer 5
4411191 2168330 2168330 defendant Batcheller Henry yeoman 657168 657168 Batcheller, Henry, of Burwashe, yeoman 0
4411192 2168330 2168330 defendant Helbye Edmund yeoman 657168 657168 Helbye, Edmund, of Burwashe, yeoman 1
5550794 2520263 2520263 defendant Fuller William yeoman 657168 657168 Fuller, William, of Burwashe, yeoman 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);