names

38 rows where place_id = 598338

✎ 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
3632045 1904839 1904839 defendant Stowell William yeoman 598338 598338 Stowell, William, of Braynford, yeoman 1
3632316 1904927 1904927 defendant Stowell William yeoman 598338 598338 Stowell, William, of Braynford, yeoman 1
3667638 1915822 1915822 defendant Stoxsse John, senior husbandman 598338 598338 Stoxsse, John, senior, of Braynford, husbandman 2
3753066 1942897 1942897 defendant Anger Robert butcher 598338 598338 Anger, Robert, of Braynford, butcher 0
3770053 1948294 1948294 defendant Anger or Auger Robert butcher 598338 598338 Anger or Auger, Robert, of Braynford, butcher 0
3794757 1956239 1956239 defendant Walker Hugh baker 598338 598338 Walker, Hugh, of Braynford, baker 0
4511323 2203986 2203986 defendant Bedewen John   598338 598338 Bedewen, John, of Braynford 0
4511326 2203987 2203987 defendant Bedewyn John   598338 598338 Bedewyn, John, of Braynford 0
4511821 2204145 2204145 defendant Neuman Richard   598338 598338 Neuman, Richard, of Braynford 0
4519199 2206357 2206357 defendant Smyth William   598338 598338 Smyth, William, of Braynford 2
4519200 2206357 2206357 defendant Solas John   598338 598338 Solas, John, of Braynford 3
4526648 2208615 2208615 defendant Boye John   598338 598338 Boye, John, of Braynford 0
4530470 2209825 2209825 defendant Boys John   598338 598338 Boys, John, of Braynford 0
4640252 2243265 2243265 defendant Grymbyl Augustine   598338 598338 Grymbyl, Augustine, of Braynford 0
4656032 2247768 2247768 defendant Virly William husbandman 598338 598338 Virly, William, of Braynford, husbandman 0
4656034 2247769 2247769 defendant Virly William husbandman 598338 598338 Virly, William, of Braynford, husbandman 0
4701361 2265828 2265828 defendant Leylond John husbandman 598338 598338 Leylond, John, of Braynford, husbandman 0
4762924 2284387 2284387 defendant Hert John carpenter 598338 598338 Hert, John, of Braynford, carpenter 0
4763684 2284630 2284630 defendant Cony William   598338 598338 Cony, William, of Braynford, shoe maker 0
4768442 2286103 2286103 defendant Mason John yeoman 598338 598338 Mason, John, of Braynford, yeoman 1
4776717 2288710 2288710 plaintiff Archer John   598338 598338 Archer, John, of Braynford 0
4786647 2291876 2291876 defendant Hert John carpenter 598338 598338 Hert, John, of Braynford, carpenter 0
4813263 2300263 2300263 plaintiff Hert John   598338 598338 Hert, John, of Braynford, on his own account 0
4845937 2310236 2310236 defendant Symond William husbandman 598338 598338 Symond, William, of Braynford, husbandman 0
4904015 2327875 2327875 plaintiff North John   598338 598338 North, John, of Braynford 0
4908180 2329110 2329110 defendant Pynder Thomas yeoman 598338 598338 Pynder, Thomas, of Braynford, yeoman 0
4945449 2340556 2340556 defendant Emond Robert husbandman 598338 598338 Emond, Robert, of Braynford, husbandman 0
5007548 2359103 2359103 defendant Eddrop John shoemaker 598338 598338 Eddrop, John, of Braynford, shoemaker 2
5009912 2359773 2359773 defendant Symond William husbandman 598338 598338 Symond, William, of Braynford, husbandman 0
5033055 2366550 2366550 defendant Payn William skinner 598338 598338 Payn, William, of Braynford, skinner 0
5040073 2368627 2368627 defendant Raynold Thomas butcher 598338 598338 Raynold, Thomas, of Braynford, butcher 0
5114018 2390488 2390488 defendant Bokelond William gent 598338 598338 Bokelond, William, of Braynford, gent 0
5302892 2445852 2445852 defendant Dalamare Thomas baker 598338 598338 Dalamare, Thomas, of Braynford, baker 0
5326527 2453019 2453019 plaintiff Stowell Robert   598338 598338 Stowell, Robert, of Braynford 0
5326534 2453020 2453020 plaintiff Stowell Robert   598338 598338 Stowell, Robert, of Braynford 0
5495234 2503469 2503469 defendant Broun Richard   598338 598338 Broun, Richard, of Braynford, vestment maker 1
5562793 2523708 2523708 defendant Baker John weaver 598338 598338 Baker, John, of Braynford, weaver 0
5628299 2552811 2552811 defendant Boy John butcher 598338 598338 Boy, John, of Braynford, butcher 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);