names

61 rows where place_id = 594262

✎ 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
3615336 1872441 1872441 defendant Soper Humphrey husbandman 594262 594262 Soper, Humphrey, of Bovy Tracy, husbandman 0
3615337 1872441 1872441 defendant Frenshe Richard husbandman 594262 594262 Frenshe, Richard, of Bovy Tracy, husbandman 1
3615338 1872441 1872441 defendant Berne John husbandman 594262 594262 Berne, John, of Bovy Tracy, husbandman 2
3615339 1872441 1872441 defendant Veysy William husbandman 594262 594262 Veysy, William, of Bovy Tracy, husbandman 3
3666761 1915549 1915549 defendant Wreyford Edward husbandman 594262 594262 Wreyford, Edward, of Bovy Tracy, husbandman 5
3686302 1921872 1921872 defendant Pyncent William husbandman 594262 594262 Pyncent, William, of Bovy Tracy, husbandman 0
3690895 1923316 1923316 defendant Vyncent William husbandman 594262 594262 Vyncent, William, of Bovy Tracy, husbandman 0
3711841 1930018 1930018 defendant Payncent Thomas husbandman 594262 594262 Payncent, Thomas, of Bovy Tracy, husbandman 0
3711843 1930019 1930019 defendant Pyncent Thomas husbandman 594262 594262 Pyncent, Thomas, of Bovy Tracy, husbandman 0
3720051 1932545 1932545 defendant Payn Hugh weaver 594262 594262 Payn, Hugh, of Bovy Tracy, weaver 0
3720578 1932717 1932717 defendant Payn Hugh weaver 594262 594262 Payn, Hugh, of Bovy Tracy, weaver 0
3721307 1932970 1932970 defendant Bovygge John husbandman 594262 594262 Bovygge, John, of Bovy Tracy, husbandman 1
3722417 1933271 1933271 defendant Carpenter Christopher tinner 594262 594262 Carpenter, Christopher, of Bovy Tracy, tinner 0
3722493 1933294 1933294 defendant Fursland John gent 594262 594262 Fursland, John, of Bovy Tracy, gent 0
3726975 1934705 1934705 defendant Pyncent Thomas husbandman 594262 594262 Pyncent, Thomas, of Bovy Tracy, husbandman 0
3766883 1947308 1947308 defendant Furslande John gent 594262 594262 Furslande, John, of Bovy Tracy, gent 0
3770734 1948532 1948532 defendant Berne John husbandman 594262 594262 Berne, John, of Bovy Tracy, husbandman 0
3778387 1950956 1950956 defendant Furselond John gent 594262 594262 Furselond, John, of Bovy Tracy, gent 0
3815264 1962689 1962689 defendant Thronston alias Bradley John   594262 594262 Thronston alias Bradley, John, of Bovy Tracy, groom 0
3815265 1962689 1962689 defendant Stone John laborer 594262 594262 Stone, John, of Bovy Tracy, laborer 1
3825848 1965934 1965934 defendant Gylbert Geoffrey gent 594262 594262 Gylbert, Geoffrey, of Bovy Tracy, gent 0
3825849 1965934 1965934 defendant Hurst John butcher 594262 594262 Hurst, John, of Bovy Tracy, butcher 1
3825851 1965934 1965934 defendant Berne John husbandman 594262 594262 Berne, John, of Bovy Tracy, husbandman 3
3832256 1968003 1968003 defendant Hurst John butcher 594262 594262 Hurst, John, of Bovy Tracy, butcher 0
3850364 1973702 1973702 defendant Fursland John gent 594262 594262 Fursland, John, of Bovy Tracy, gent 0
3854099 1974917 1974917 defendant Bredford Richard yeoman 594262 594262 Bredford, Richard, of Bovy Tracy, yeoman 0
3857145 1975864 1975864 defendant Gylbert Geoffrey gent 594262 594262 Gylbert, Geoffrey, of Bovy Tracy, gent 0
3858514 1976326 1976326 plaintiff Brabon John, senior (legal representative) 594262 594262 Brabon, John, senior, of Bovy Tracy, executrix of 0
3873088 1981216 1981216 defendant Brabon Richard gent 594262 594262 Brabon, Richard, of Bovy Tracy, gent 3
3895436 1988683 1988683 plaintiff Southcote John   594262 594262 Southcote, John, of Bovy Tracy 0
3980883 2017925 2017925 defendant Pynson George weaver 594262 594262 Pynson, George, of Bovy Tracy, weaver 0
4570579 2222373 2222373 defendant Petypas John   594262 594262 Petypas, John, of Bovy Tracy 0
4656453 2247914 2247914 defendant Wrot William tucker 594262 594262 Wrot, William, of Bovy Tracy, tucker 2
4759574 2283336 2283336 defendant Wille John skinner 594262 594262 Wille, John, of Bovy Tracy, skinner 2
4908307 2329153 2329153 defendant Fursselond John husbandman 594262 594262 Fursselond, John, of Bovy Tracy, husbandman 0
4923059 2333631 2333631 plaintiff Mannynge John   594262 594262 Mannynge, John, of Bovy Tracy 0
5041099 2368963 2368963 defendant Corset Thomas, junior shoemaker 594262 594262 Corset, Thomas, junior, of Bovy Tracy, shoemaker 1
5077130 2379660 2379660 defendant Wylle John yeoman 594262 594262 Wylle, John, of Bovy Tracy, yeoman 0
5116324 2391206 2391206 defendant Colbeare William yeoman 594262 594262 Colbeare, William, of Bovy Tracy, yeoman 0
5123548 2393341 2393341 defendant Cove William smith 594262 594262 Cove, William, of Bovy Tracy, smith 0
5160097 2404054 2404054 defendant Corset Thomas   594262 594262 Corset, Thomas, of Bovy Tracy, shoe maker 1
5163675 2405112 2405112 defendant Cove William smith 594262 594262 Cove, William, of Bovy Tracy, smith 0
5184359 2411164 2411164 defendant Wrot William yeoman 594262 594262 Wrot, William, of Bovy Tracy, yeoman 0
5184363 2411164 2411164 defendant Mannyng John yeoman 594262 594262 Mannyng, John, of Bovy Tracy, yeoman 4
5204279 2417004 2417004 defendant Mannyng John yeoman 594262 594262 Mannyng, John, of Bovy Tracy, yeoman 2
5204281 2417004 2417004 defendant Wrot William yeoman 594262 594262 Wrot, William, of Bovy Tracy, yeoman 4
5226186 2423323 2423323 defendant Wratte William yeoman 594262 594262 Wratte, William, of Bovy Tracy, yeoman 8
5239305 2427081 2427081 defendant Cove John yeoman 594262 594262 Cove, John, of Bovy Tracy, yeoman 1
5261360 2433661 2433661 defendant Wrot William (legal representative) 594262 594262 Wrot, William, of Bovy Tracy,merchant, executors of 0
5261361 2433661 2433661 defendant Wyllyam John yeoman 594262 594262 (Wyllyam, John, of Bovy Tracy, yeoman 1
5281254 2439593 2439593 defendant Pethybrygge John butcher 594262 594262 Pethybrygge, John, of Bovy Tracy, butcher 2
5299202 2444745 2444745 defendant Hancok Walter   594262 594262 Hancok, Walter, of Bovy Tracy, vicar 0
5352515 2460879 2460879 defendant Salter John husbandman 594262 594262 Salter, John, of Bovy Tracy, husbandman 2
5412973 2478821 2478821 defendant More Simon husbandman 594262 594262 More, Simon, of Bovy Tracy, husbandman 4
5428026 2483335 2483335 defendant More Simon husbandman 594262 594262 More, Simon, of Bovy Tracy, husbandman 3
5480208 2499062 2499062 defendant More Simon brasier 594262 594262 More, Simon, of Bovy Tracy, brasier 4
5488143 2501346 2501346 defendant Wrat Richard yeoman 594262 594262 Wrat, Richard, of Bovy Tracy, yeoman 1
5488144 2501346 2501346 defendant Luscombe John husbandman 594262 594262 Luscombe, John, of Bovy Tracy, husbandman 2
5496872 2503995 2503995 defendant Balle William mercer 594262 594262 Balle, William, of Bovy Tracy, mercer 0
5543350 2518039 2518039 defendant Wetherton Philip husbandman 594262 594262 Wetherton, Philip, of Bovy Tracy, husbandman 2
5551622 2520514 2520514 defendant Phylyp Thomas laborer 594262 594262 Phylyp, Thomas, of Bovy Tracy, laborer 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);