names

58 rows where place_id = 588031

✎ 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
3593143 1865482 1865482 defendant Norwode Thomas tanner 588031 588031 Norwode, Thomas, of Brasted, tanner 1
3596832 1866645 1866645 defendant Couper John yeoman 588031 588031 Couper, John, of Brasted, yeoman 0
3608864 1870428 1870428 defendant Reyner John tailor 588031 588031 Reyner, John, of Brasted, tailor 2
3632686 1905040 1905040 defendant Newman John tanner 588031 588031 Newman, John, of Brasted, tanner 0
3680554 1919999 1919999 defendant Welles John butcher 588031 588031 Welles, John, of Brasted, butcher 1
3695555 1924837 1924837 defendant Jurden John yeoman 588031 588031 Jurden, John, of Brasted, yeoman 0
3714446 1930812 1930812 defendant Sughue William   588031 588031 Sughue, William, of Brasted, wheelwright 2
3729779 1935570 1935570 defendant Sughue William   588031 588031 Sughue, William, of Brasted, wheelwright 2
3746838 1940932 1940932 plaintiff Crowe John yeoman 588031 588031 Crowe, John, of Brasted, yeoman 0
3751191 1942298 1942298 defendant Sugger John wheeler 588031 588031 Sugger, John, of Brasted, wheeler 3
3757845 1944432 1944432 defendant Sone John tanner 588031 588031 Sone, John, of Brasted, tanner 0
3757846 1944432 1944432 defendant Wyllyams John tanner 588031 588031 Wyllyams, John, of Brasted, tanner 1
3779319 1951254 1951254 defendant Soone John, senior tanner 588031 588031 Soone, John, senior, of Brasted, tanner 0
3838826 1970069 1970069 defendant Deane Henry (legal representative) 588031 588031 Deane, Henry, of Brasted, tanner, executors of 0
3838827 1970069 1970069 defendant Deane Elizabeth widow 588031 588031 (Deane, Elizabeth, of Brasted, widow 1
3838828 1970069 1970069 defendant Deane William tanner 588031 588031 Deane, William, of Brasted, tanner 2
3853061 1974578 1974578 plaintiff Selyard Thomas (legal representative) 588031 588031 Selyard, Thomas, of Brasted, executor of 0
3853067 1974578 1974578 defendant Jurden John, junior butcher 588031 588031 Jurden, John, junior, of Brasted, butcher 4
3853068 1974579 1974579 plaintiff Selyard Thomas (legal representative) 588031 588031 Selyard, Thomas, of Brasted, executor of 0
3853075 1974579 1974579 defendant Jurden John, junior butcher 588031 588031 Jurden, John, junior, of Brasted, butcher 5
3871893 1980835 1980835 defendant George alias Jurden John butcher 588031 588031 George alias Jurden, John, of Brasted, butcher 0
3875575 1982070 1982070 defendant George alias Jurden John butcher 588031 588031 George alias Jurden, John, of Brasted, butcher 0
3913101 1994713 1994713 defendant Morcoke Morris yeoman 588031 588031 Morcoke, Morris, of Brasted, yeoman 0
3913102 1994713 1994713 defendant Morcoke George tailor 588031 588031 Morcoke, George, of Brasted, tailor 1
3940918 2003969 2003969 defendant Morcoke Morris yeoman 588031 588031 Morcoke, Morris, of Brasted, yeoman 0
4028732 2034925 2034925 defendant Halley William clothier 588031 588031 Halley, William, of Brasted, clothier 1
4050015 2042437 2042437 defendant Domerycke Stephen brasier 588031 588031 Domerycke, Stephen, of Brasted, brasier 0
4170779 2085272 2085272 defendant Amyas or Amys John gent 588031 588031 Amyas or Amys, John, of Brasted, or of Asherst, gent 0
4170784 2085273 2085273 defendant Amyas or Amys John gent 588031 588031 Amyas or Amys, John, of Brasted, or of Asherst, Kent, gent 0
4210647 2099281 2099281 defendant Swayneslande Nicholas shoemaker 588031 588031 Swayneslande, Nicholas, of Brasted, shoemaker 0
4235690 2108050 2108050 defendant Swane Simon husbandman 588031 588031 Swane, Simon, of Brasted, husbandman 0
4235691 2108050 2108050 defendant Deane William tanner 588031 588031 Deane, William, of Brasted, tanner 1
4372402 2155196 2155196 defendant Jurden John   588031 588031 Jurden, John, of Brasted, "tawser" 0
4396622 2163435 2163435 defendant Hamond John sherman 588031 588031 Hamond, John, of Brasted, sherman 2
4583483 2226257 2226257 defendant Brasier John   588031 588031 Brasier, John, of Brasted 0
4720319 2271696 2271696 defendant Morcok John husbandman 588031 588031 together with Morcok, John, of Brasted, husbandman 4
4741481 2278005 2278005 defendant Shepperd John whyler or wheeler 588031 588031 Shepperd, John, of Brasted, whyler or wheeler 0
4848814 2311092 2311092 defendant atte Bregge John husbandman 588031 588031 atte Bregge, John, of Brasted, husbandman 2
4907172 2328808 2328808 defendant Gylmyn John husbandman 588031 588031 Gylmyn, John, of Brasted, husbandman 0
4907173 2328808 2328808 defendant Morecok Thomas laborer 588031 588031 Morecok, Thomas, of Brasted, laborer 1
5041940 2369188 2369188 defendant Swan John butcher 588031 588031 Swan, John, of Brasted, butcher 0
5087704 2382790 2382790 defendant Peny John weaver 588031 588031 Peny, John, of Brasted, weaver 3
5087829 2382820 2382820 defendant Peny John weaver 588031 588031 Peny, John, of Brasted, weaver 4
5119778 2392223 2392223 defendant Peny John weaver 588031 588031 Peny, John, of Brasted, weaver 1
5137075 2397360 2397360 defendant Birde John draper 588031 588031 Birde, John, of Brasted, draper 0
5330741 2454266 2454266 defendant Bronche John husbandman 588031 588031 Bronche, John, of Brasted, husbandman 0
5339391 2456890 2456890 defendant Mey John husbandman 588031 588031 (Mey, John, of Brasted, husbandman 1
5421262 2481290 2481290 defendant Rouland Rouland tanner 588031 588031 Rouland, Rouland, of Brasted, tanner 0
5440184 2486964 2486964 defendant Rouland John tanner 588031 588031 Rouland, John, of Brasted, tanner 0
5440497 2487060 2487060 defendant Rouland John   588031 588031 Rouland, John, of Brasted 0
5460008 2492925 2492925 defendant Couper John smith 588031 588031 Couper, John, of Brasted, smith 0
5460009 2492925 2492925 defendant Outrede Thomas laborer 588031 588031 Outrede, Thomas, of Brasted, laborer 1
5491769 2502438 2502438 defendant Fysshewyk John butcher 588031 588031 Fysshewyk, John, of Brasted, butcher 1
5520671 2511288 2511288 defendant Rowland John tanner 588031 588031 Rowland, John, of Brasted, tanner 0
5552605 2520816 2520816 defendant Chapman Thomas yeoman 588031 588031 Chapman, Thomas, of Brasted, yeoman 1
5597494 2534118 2534118 defendant Jurden John husbandman 588031 588031 Jurden, John, of Brasted, husbandman 0
5597496 2534119 2534119 defendant Jurdon John husbandman 588031 588031 Jurdon, John, of Brasted, husbandman 0
5605924 2536744 2536744 defendant Coper John smith 588031 588031 Coper, John, of Brasted, smith 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);