names

47 rows where place_id = 663301

✎ 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
3968317 2013550 2013550 plaintiff Chase William yeoman 663301 663301 Chase, William, of Buckenham, yeoman 0
3984285 2019144 2019144 defendant Brecke Thomas gent 663301 663301 Brecke, Thomas, of Buckenham, gent 0
4004761 2026480 2026480 plaintiff Johnson William yeoman 663301 663301 Johnson, William, of Buckenham, yeoman 0
4004995 2026568 2026568 defendant Verdon William yeoman 663301 663301 Verdon, William, of Buckenham, yeoman 2
4010373 2028478 2028478 defendant Rame or Raine John yeoman 663301 663301 Rame or Raine, John, of Buckenham, yeoman 0
4021790 2032522 2032522 defendant Chase William yeoman 663301 663301 Chase, William, of Buckenham, yeoman 3
4064096 2047436 2047436 defendant Tyndall alias Kendall William yeoman 663301 663301 Tyndall alias Kendall, William, of Buckenham, yeoman 0
4073207 2050708 2050708 defendant Shalles William butcher 663301 663301 Shalles, William, of Buckenham, butcher 0
4073209 2050708 2050708 defendant Guldard William butcher 663301 663301 Guldard, William, of Buckenham, butcher 2
4076670 2051943 2051943 defendant Chace William husbandman 663301 663301 Chace, William, of Buckenham, husbandman 13
4085517 2055096 2055096 defendant Browne Hugh tanner 663301 663301 Browne, Hugh, of Buckenham, tanner 3
4088915 2056339 2056339 defendant Langdon Clement tailor 663301 663301 Langdon, Clement, of Buckenham, tailor 3
4108887 2063432 2063432 defendant Godsalve Thomas esq 663301 663301 Godsalve, Thomas, of Buckenham, esq 0
4112210 2064623 2064623 defendant Flowerdewe Thomas yeoman 663301 663301 Flowerdewe, Thomas, of Buckenham, yeoman 2
4142198 2075448 2075448 defendant Wharton Thomas yeoman 663301 663301 Wharton, Thomas, of Buckenham, yeoman 0
4174480 2086541 2086541 defendant Margerys Francis hatter 663301 663301 Margerys, Francis, of Buckenham, or of Thevelton, Norf, hatter 0
4194362 2093578 2093578 defendant Wharton Thomas yeoman 663301 663301 Wharton, Thomas, of Buckenham, yeoman 2
4201333 2096022 2096022 defendant Grigges Thomas husbandman 663301 663301 Grigges, Thomas, of Buckenham, husbandman 0
4201334 2096022 2096022 defendant Eldred Thomas butcher 663301 663301 Eldred, Thomas, of Buckenham, butcher 1
4201335 2096022 2096022 defendant Cullander John clerk 663301 663301 Cullander, John, of Buckenham, clerk 2
4241879 2110276 2110276 defendant Underwood Peter yeoman 663301 663301 Underwood, Peter, of Buckenham, yeoman 1
4241912 2110286 2110286 defendant Underwood Peter yeoman 663301 663301 Underwood, Peter, of Buckenham, yeoman 1
4256482 2115135 2115135 defendant Mason John chapman 663301 663301 Mason, John, of Buckenham, chapman 3
4271771 2120135 2120135 defendant Atkyns Henry tanner 663301 663301 Atkyns, Henry, of Buckenham, tanner 1
4290640 2126710 2126710 defendant Fyssher Thomas   663301 663301 Fyssher, Thomas, of Buckenham, "backer" or baker 0
4290837 2126779 2126779 defendant Johnson Thomas yeoman 663301 663301 Johnson, Thomas, of Buckenham, yeoman 1
4291598 2127073 2127073 defendant Kendall Henry (legal representative) 663301 663301 Kendall, Henry, of Buckenham, yeoman, executor of 0
4305371 2132021 2132021 defendant Woodcock Francis yeoman 663301 663301 Woodcock, Francis, of Buckenham, yeoman 1
4323141 2138155 2138155 defendant Powle Richard husbandman 663301 663301 Powle, Richard, of Buckenham, husbandman 0
4323142 2138155 2138155 defendant Barnes John husbandman 663301 663301 Barnes, John, of Buckenham, husbandman 1
4332027 2141008 2141008 defendant Fenne William (legal representative) 663301 663301 Fenne, William, of Buckenham, yeoman, administrator of 1
4332204 2141066 2141066 defendant Scott John butcher 663301 663301 Scott, John, of Buckenham, butcher 0
4332940 2141301 2141301 defendant Norforth John yeoman 663301 663301 Norforth, John, of Buckenham, yeoman 2
4340858 2144075 2144075 defendant Jackson Nicholas glover 663301 663301 Jackson, Nicholas, of Buckenham, glover 2
4349274 2147007 2147007 defendant Hill Thomas yeoman 663301 663301 Hill, Thomas, of Buckenham, yeoman 0
4370559 2154521 2154521 defendant Cullender Mary widow 663301 663301 Cullender, Mary, of Buckenham, widow 1
4391556 2161787 2161787 defendant Darbye Henry yeoman 663301 663301 Darbye, Henry, of Buckenham, yeoman 3
4393815 2162534 2162534 defendant Cowper John cooper 663301 663301 Cowper, John, of Buckenham, cooper 0
4393816 2162534 2162534 defendant Norman Abraham beer brewer 663301 663301 Norman, Abraham, of Buckenham, beer brewer 1
4393817 2162534 2162534 defendant Jubye John butcher 663301 663301 Jubye, John, of Buckenham, butcher 2
4393818 2162534 2162534 defendant Bood Francis glover 663301 663301 Bood, Francis, of Buckenham, glover 3
4398323 2164020 2164020 defendant Cullender Mary widow 663301 663301 Cullender, Mary, of Buckenham, widow 1
4401322 2165038 2165038 defendant Shypley John yeoman 663301 663301 Shypley, John, of Buckenham, yeoman 0
4411109 2168302 2168302 defendant Bull Richard joiner 663301 663301 Bull, Richard, of Buckenham, joiner 0
4411986 2168604 2168604 defendant Garlonde Thomas yeoman 663301 663301 Garlonde, Thomas, of Buckenham, yeoman 0
4411988 2168604 2168604 defendant Levycke Robert yeoman 663301 663301 Levycke, Robert, of Buckenham, yeoman 2
4557550 2218297 2218297 defendant Hille John   663301 663301 Hille, John, of Buckenham 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);