names

63 rows where place_id = 621153

✎ 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
3739863 1938683 1938683 defendant Peverell Richard clothmaker 621153 621153 Peverell, Richard, of Est Bargholt, clothmaker 0
3743830 1939956 1939956 defendant Markys Robert clothmaker 621153 621153 Markys, Robert, of Est Bargholt, clothmaker 0
3743831 1939956 1939956 defendant Dey John clothmaker 621153 621153 Dey, John, of Est Bargholt, clothmaker 1
3752643 1942758 1942758 plaintiff Reynold George   621153 621153 Reynold, George, of Est Bargholt 0
3769035 1947966 1947966 defendant Peverell Richard clothmaker 621153 621153 Peverell, Richard, of Est Bargholt, clothmaker 1
3769454 1948107 1948107 plaintiff Reynold George   621153 621153 Reynold, George, of Est Bargholt 0
3853457 1974706 1974706 defendant Reynold George clothmaker 621153 621153 Reynold, George, of Est Bargholt, clothmaker 0
3919078 1996704 1996704 defendant Bretton Philip butcher 621153 621153 Bretton, Philip, of Est Bargholt, butcher 0
3927569 1999561 1999561 defendant Markys William clothier 621153 621153 Markys, William, of Est Bargholt, clothier 5
3943054 2004689 2004689 defendant Raynold Philip gent 621153 621153 Raynold, Philip, of Est Bargholt, gent 0
3991381 2021672 2021672 defendant Marten John husbandman 621153 621153 Marten, John, of Est Bargholt, husbandman 1
3991382 2021672 2021672 defendant Marten Richard husbandman 621153 621153 Marten, Richard, of Est Bargholt, husbandman 2
4003956 2026185 2026185 defendant Warwyke John clothier 621153 621153 Warwyke, John, of Est Bargholt, clothier 0
4003957 2026185 2026185 defendant Cooke Robert butcher 621153 621153 Cooke, Robert, of Est Bargholt, butcher 1
4003958 2026185 2026185 defendant Bretten William butcher 621153 621153 Bretten, William, of Est Bargholt, butcher 2
4055685 2044423 2044423 defendant Cooke Robert butcher 621153 621153 Cooke, Robert, of Est Bargholt, butcher 0
4058972 2045604 2045604 defendant Whetlye James   621153 621153 Whetlye, James, of Est Bargholt, "wrynger" 0
4121057 2067819 2067819 defendant Lyncolne Stephen clothier 621153 621153 Lyncolne, Stephen, of Est Bargholt, clothier 0
4123704 2068780 2068780 defendant Lyncolne Stephen clothier 621153 621153 Lyncolne, Stephen, of Est Bargholt, clothier 0
4123955 2068866 2068866 defendant Richardson John weaver 621153 621153 Richardson, John, of East Bargholt, weaver 1
4123956 2068866 2068866 defendant Baker Thomas broker 621153 621153 Baker, Thomas, of East Bargholt, currier, broker 2
4124993 2069228 2069228 defendant Martyn John husbandman 621153 621153 Martyn, John, of Est Bargholt, husbandman 0
4124994 2069228 2069228 defendant Russhebroke John weaver 621153 621153 Russhebroke, John, of Est Bargholt, weaver 1
4124995 2069228 2069228 defendant Ely Edmund clothier 621153 621153 Ely, Edmund, of Est Bargholt, clothier 2
4124996 2069228 2069228 defendant Turner Thomas weaver 621153 621153 Turner, Thomas, of Est Bargholt, weaver 3
4126411 2069733 2069733 defendant Bekwyth Thomas shoemaker 621153 621153 Bekwyth, Thomas, of East Bargholt, shoemaker 3
4132400 2071905 2071905 defendant Richardson John weaver 621153 621153 Richardson, John, of Est Bargholt, weaver 0
4132401 2071905 2071905 defendant Ely Edmund weaver 621153 621153 Ely, Edmund, of Est Bargholt, weaver 1
4132402 2071905 2071905 defendant Brampston Christopher clothier 621153 621153 Brampston, Christopher, of Est Bargholt, clothier 2
4138993 2074317 2074317 defendant Steven Simon shoemaker or cordwainer 621153 621153 Steven, Simon, of Est Bargholt, shoemaker or cordwainer 2
4140454 2074830 2074830 defendant Lyncolne Stephen clothier 621153 621153 Lyncolne, Stephen, of Est Bargholt, clothier 0
4148290 2077532 2077532 defendant Lewis Christopher clothier 621153 621153 Lewis, Christopher, of Est Bargholt, clothier 0
4188572 2091480 2091480 defendant Pod Augustine husbandman 621153 621153 Pod, Augustine, of Est Bargholt, or of Aulton, husbandman 0
4196384 2094279 2094279 defendant Newton Edmund weaver 621153 621153 Newton, Edmund, of Est Bargholt, weaver 0
4196385 2094279 2094279 defendant Mark Edward clothier 621153 621153 Mark, Edward, of Est Bargholt, clothier 1
4196386 2094279 2094279 defendant Turner Thomas weaver 621153 621153 Turner, Thomas, of Est bargholt, weaver 2
4203786 2096881 2096881 defendant Podd Edward husbandman 621153 621153 Podd, Edward, of Est Bargholt, husbandman 1
4203788 2096881 2096881 defendant Kynge Henry husbandman 621153 621153 Kynge, Henry, of Est Bargholt, husbandman 3
4241324 2110084 2110084 defendant Cockerell George clothier 621153 621153 Cockerell, George, of Est Bargholt, clothier 0
4241325 2110084 2110084 defendant Bowes Thomas gent 621153 621153 Bowes, Thomas, of Est Bargholt, gent 1
4241326 2110084 2110084 defendant Smith Edward laborer 621153 621153 Smith, Edward, of Est Bargholt, laborer 2
4353015 2148283 2148283 defendant Beckett William clothier 621153 621153 Beckett, William, of Est Bargholt, clothier 1
4353016 2148283 2148283 defendant Heigh Richard clothier 621153 621153 Heigh, Richard, of East Bargholt, clothier 2
4385878 2159970 2159970 defendant Denham Robert clothier 621153 621153 Denham, Robert, of Est Bargholt, clothier 0
4388294 2160715 2160715 defendant Cockerell George clother 621153 621153 Cockerell, George, of Est Bargholt, clother 1
4388295 2160715 2160715 defendant Cardynall John (legal representative) 621153 621153 Cardynall, John, of East Bargholt, merchant, administrator of 2
4400745 2164838 2164838 defendant Woodwarde Thomas sherman 621153 621153 Woodwarde, Thomas, of East Bargholt, sherman 0
4400746 2164838 2164838 defendant Trenham Richard clothworker 621153 621153 Trenham, Richard, of East Bargholt, clothworker 1
4400747 2164838 2164838 defendant Lawford John clothworker 621153 621153 Lawford, John, of East Bargholt, clothworker 2
4400748 2164838 2164838 defendant Elmar Robert clothworker 621153 621153 Elmar, Robert, of East Bargholt, clothworker 3
4400750 2164839 2164839 defendant Branston John clothier 621153 621153 Branston, John, of East Bargholt, clothier 0
4400751 2164839 2164839 defendant Dowe Michael clothier 621153 621153 Dowe, Michael, of East Bargholt, clothier 1
4400752 2164839 2164839 defendant Manser Anthony clothier 621153 621153 Manser, Anthony, of East Bargholt, clothier 2
4400753 2164839 2164839 defendant Johnson Weston clothier 621153 621153 Johnson, Weston, of East Bargholt, clothier 3
4404430 2166048 2166048 defendant Holman Thomas clothier 621153 621153 Holman, Thomas, of East Bargholt, clothier 0
4405208 2166320 2166320 defendant Nelson Robert carrier 621153 621153 Nelson, Robert, of Est Bargholt, carrier 0
4406194 2166637 2166637 defendant Lewes Thomas clothier 621153 621153 Lewes, Thomas, of Est Bargholt, clothier 1
4406227 2166647 2166647 defendant Lewes Thomas clothier 621153 621153 Lewes, Thomas, of Est Bargholt, clothier 2
4411051 2168282 2168282 defendant Lewes Edward clothier 621153 621153 Lewes, Edward, of East Bargholt, clothier 0
4411052 2168282 2168282 defendant Manser Christopher clothier 621153 621153 Manser, Christopher, of East Bargholt, clothier 1
4411053 2168282 2168282 defendant Dawson Stephen clothier 621153 621153 Dawson, Stephen, of East Bargholt, clothier 2
5133799 2396377 2396377 defendant Peverell Richard   621153 621153 Peverell, Richard, of East Bargholt 0
5338288 2456547 2456547 defendant Boorse John smith 621153 621153 Boorse, John, of Est Bargholt, smith 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);