names

54 rows where place_id = 698653

✎ 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
3737298 1937901 1937901 defendant Becker John butcher 698653 698653 Becker, John, of Hoveton, butcher 3
4093987 2058177 2058177 defendant Gyles Robert husbandman 698653 698653 Gyles, Robert, of Hoveton, husbandman 0
4093989 2058178 2058178 defendant Gyles Robert husbandman 698653 698653 Gyles, Robert, of Hoveton, husbandman 0
4125182 2069294 2069294 defendant Love John husbandman 698653 698653 Love, John, of Hoveton St Peter, husbandman 0
4161997 2082267 2082267 defendant Boyse William gent 698653 698653 Boyse, William, of Hoveton St Peter, gent 0
4175019 2086731 2086731 defendant Allysander Edmund tailor 698653 698653 Allysander, Edmund, of Hoveton St Peter, tailor 0
4175023 2086732 2086732 defendant Allysaunder Edmund tailor 698653 698653 Allysaunder, Edmund, of Hoveton St Peter, tailor 0
4178793 2088061 2088061 defendant Boyse William gent 698653 698653 Boyse, William, of Hoveton St Peter, gent 0
4178800 2088062 2088062 defendant Alizander Edward husbandman 698653 698653 Alizander, Edward, of Hoveton St Peter, husbandman 2
4183085 2089568 2089568 defendant Alizander Edmund husbandman 698653 698653 Alizander, Edmund, of Hoveton St Peter, or of Belawe, husbandman 0
4183086 2089568 2089568 defendant Alizander Edward husbandman 698653 698653 Alizander, Edward, of Hoveton St Peter, husbandman 1
4183087 2089568 2089568 defendant Brownynge John husbandman 698653 698653 Brownynge, John, of Hoveton St Peter, husbandman 2
4185358 2090390 2090390 defendant Boyse William gent 698653 698653 Boyse, William, of Hoveton St Peter, gent 0
4200026 2095560 2095560 defendant Gamble John   698653 698653 Gamble, John, of Hoveton St Peter husbandman 1
4208973 2098690 2098690 defendant Wynter Erasmus gent 698653 698653 Wynter, Erasmus, of Hoveton, gent 1
4209096 2098732 2098732 defendant Alexander Edward husbandman 698653 698653 Alexander, Edward, of Hoveton St Peter, husbandman 0
4209097 2098732 2098732 defendant Boyse William gent 698653 698653 Boyse, William, of Hoveton St Peter, gent 1
4209100 2098733 2098733 defendant Boyse William gent 698653 698653 Boyse, William, of Hoveton St Peter, gent 0
4223910 2103849 2103849 defendant Boyce William gent 698653 698653 Boyce, William, of Hoveton St Peter, gent 0
4241833 2110258 2110258 defendant Crosse George   698653 698653 Crosse, George, of Hoveton St Peter, brick maker 1
4464958 2189710 2189710 defendant atte Herre Robert   698653 698653 atte Herre, Robert, of Hoveton 3
4675226 2257865 2257865 defendant Millere John yeoman 698653 698653 Millere, John, of Hoveton St Peter, yeoman 0
4735301 2276188 2276188 defendant Emmes Robert (legal representative) 698653 698653 Emmes, Robert, of Hoveton St Peter, yeoman, executors of 1
4735303 2276188 2276188 defendant Balle William yeoman 698653 698653 Balle, William, of Hoveton, yeoman 3
4823071 2303300 2303300 defendant Miller John husbandman 698653 698653 Miller, John, of Hoveton St Peter, husbandman 0
4830184 2305484 2305484 defendant Millere John yeoman 698653 698653 Millere, John, of Hoveton St Peter, yeoman 0
4839724 2308339 2308339 defendant Bayhard Nicholas laborer 698653 698653 Bayhard, Nicholas, of Hoveton St Peter, laborer 2
4855606 2313118 2313118 defendant atte William laborer 698653 698653 atte, William, of Hoveton St Peter, laborer 1
4940817 2339156 2339156 defendant Emmys Nicholas yeoman 698653 698653 Emmys, Nicholas, of Hoveton St Peter, yeoman 0
4945707 2340639 2340639 defendant Meller John husbandman 698653 698653 Meller, John, of Hoveton St Peter, husbandman 0
4948778 2341601 2341601 defendant Gyrdyng Geoffrey husbandman 698653 698653 Gyrdyng, Geoffrey, of Hoveton St Peter, husbandman 0
4980559 2351126 2351126 defendant Kydbald Thomas yeoman 698653 698653 Kydbald, Thomas, of Hoveton St Peter, yeoman 0
5010369 2359901 2359901 plaintiff Walpole Henry esq 698653 698653 Walpole, Henry, of Hoveton, esq 0
5063225 2375532 2375532 defendant Plomer Beatrice widow 698653 698653 Plomer, Beatrice, of Hoveton St Peter, widow 0
5064096 2375799 2375799 defendant Kitbald Thomas yeoman 698653 698653 Kitbald, Thomas, of Hoveton St Peter, yeoman 0
5064097 2375799 2375799 defendant Kitbaldm Katherine servant 698653 698653 Kitbaldm Katherine, of Hoveton St Peter, servant 1
5130112 2395294 2395294 defendant Cumys John yeoman 698653 698653 Cumys, John, of Hoveton St Peter, yeoman 3
5149427 2400965 2400965 defendant Emmys John yeoman 698653 698653 Emmys, John, of Hoveton St Peter, yeoman 2
5240014 2427279 2427279 defendant Emmes John yeoman 698653 698653 Emmes, John, of Hoveton St Peter, yeoman 0
5260039 2433260 2433260 defendant Emmes of Gunnes John yeoman 698653 698653 Emmes of Gunnes, John, of Hoveton St Peter, yeoman 2
5260278 2433342 2433342 defendant att Chyrche John yeoman 698653 698653 att Chyrche, John, of Hoveton St Peter, yeoman 0
5299747 2444895 2444895 defendant Emmes John yeoman 698653 698653 Emmes, John, of Hoveton St Peter, yeoman 3
5299955 2444951 2444951 defendant Emmes John yeoman 698653 698653 Emmes, John, of Hoveton St Peter, yeoman 0
5299959 2444952 2444952 defendant Emmes John yeoman 698653 698653 Emmes, John, of Hoveton St Peter, yeoman 0
5301128 2445293 2445293 defendant Emmes John husbandman 698653 698653 Emmes, John, of Hoveton St Peter, husbandman 1
5304586 2446369 2446369 defendant (illegible) John husbandman 698653 698653 _, John, of Hoveton St Peter, husbandman 0
5304587 2446369 2446369 defendant Broun John husbandman 698653 698653 Broun, John, of Hoveton St Peter, husbandman 1
5314702 2449432 2449432 defendant Emmes or Gunnes John husbandman 698653 698653 Emmes or Gunnes, John, of Hoveton St Peter, husbandman 2
5323459 2452096 2452096 defendant Emmys or Gunnys John husbandman 698653 698653 Emmys or Gunnys, John, of Hoveton St Peter, husbandman 0
5370276 2466292 2466292 defendant Puttok John husbandman 698653 698653 Puttok, John, of Hoveton St Peter, husbandman 0
5409247 2477731 2477731 defendant Batheman Robert husbandman 698653 698653 Batheman, Robert, of Hoveton, husbandman 0
5450729 2490104 2490104 defendant Botheman Robert   698653 698653 Botheman, Robert, of Hoveton 1
5507881 2507367 2507367 defendant Baker William clerk 698653 698653 Baker, William, of Hoveton St Peter, clerk 1
5541712 2517519 2517519 defendant Puttok John   698653 698653 Puttok, John, of Hoveton St Peter 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);