names

56 rows where place_id = 588803

✎ 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
3595640 1866262 1866262 defendant Plymmyswode John tucker 588803 588803 Plymmyswode, John, of Durseley, tucker 0
3595641 1866262 1866262 defendant Balle John tucker 588803 588803 Balle, John, of Durseley, tucker 1
3660316 1913487 1913487 defendant Burstowe John butcher 588803 588803 Burstowe, John, of Durseley, butcher 0
3674914 1918184 1918184 defendant Stynchecome John weaver 588803 588803 Stynchecome, John, of of Durseley, weaver 1
3674917 1918184 1918184 defendant Teysant John weaver 588803 588803 (Teysant, John, of Durseley, weaver 4
3681043 1920146 1920146 defendant Keynton John baker 588803 588803 Keynton, John, of Durseley, baker 1
3682569 1920653 1920653 defendant Deny Thomas weaver 588803 588803 Deny, Thomas, of Durseley, weaver 0
3810885 1961307 1961307 defendant Webbe Edmund clothier 588803 588803 Webbe, Edmund, of Durseley, clothier 0
3810888 1961308 1961308 defendant Hevyn Thomas clothier 588803 588803 Hevyn, Thomas, of Durseley, clothier 0
3810889 1961308 1961308 defendant Awod William clothier 588803 588803 Awod, William, of Durseley, clothier 1
3896173 1988922 1988922 defendant Heskyns John clothier 588803 588803 Heskyns, John, of Durseley, clothier 0
3897765 1989458 1989458 defendant Smalwood Thomas clothier 588803 588803 Smalwood, Thomas, of Durseley, clothier 0
3907273 1992724 1992724 defendant Brystowe James butcher 588803 588803 Brystowe, James, of Durseley, butcher 0
3916690 1995950 1995950 defendant Brystowe James butcher 588803 588803 Brystowe, James, of Durseley, butcher 2
3962309 2011400 2011400 plaintiff Webbe John clothier 588803 588803 Webbe, John, of Durseley, clothier 0
3984721 2019293 2019293 defendant Macy John glover 588803 588803 Macy, John, of Durseley, glover 0
4142945 2075705 2075705 defendant Gonn Richard yeoman 588803 588803 Gonn, Richard, of Durseley, yeoman 0
4188846 2091575 2091575 defendant Phillipps Thomas yeoman 588803 588803 Phillipps, Thomas, of Durseley, yeoman 3
4247846 2112264 2112264 defendant Thacham Richard yeoman 588803 588803 Thacham, Richard, of Durseley, yeoman 0
4330956 2140654 2140654 defendant Bowser George clothier 588803 588803 Bowser, George, of Durseley, clothier 1
4403661 2165800 2165800 defendant Flower John weaver 588803 588803 Flower, John, of Durseley, weaver 0
4686259 2261303 2261303 defendant Tessanut John dyer 588803 588803 Tessanut, John, of Durseley, dyer 0
4753913 2281604 2281604 defendant Elyot Nicholas   588803 588803 Elyot, Nicholas, of Durseley, holy water clerk 0
4753915 2281605 2281605 defendant Elyot Nicholas   588803 588803 Elyot, Nicholas, of Durseley, holy water clerk 0
4811844 2299817 2299817 defendant Tanner Thomas chapman 588803 588803 Tanner, Thomas, of Durseley, chapman 0
4837691 2307721 2307721 defendant Tanner Thomas husbandman 588803 588803 Tanner, Thomas, of Durseley, husbandman 0
4838313 2307899 2307899 defendant Tanner Thomas chapman 588803 588803 Tanner, Thomas, of Durseley, chapman 0
4838337 2307905 2307905 defendant Tanner Thomas chapman 588803 588803 Tanner, Thomas, of Durseley, chapman 0
4890157 2323694 2323694 defendant Gybons Walter weaver 588803 588803 Gybons, Walter, of Durseley, weaver 1
4890158 2323694 2323694 defendant Southern Thomas fuller 588803 588803 Southern, Thomas, of Durseley, fuller 2
4902834 2327501 2327501 defendant Elmer Walter yeoman 588803 588803 Elmer, Walter, of Durseley, yeoman 0
4935638 2337534 2337534 defendant Tanner Robert gent 588803 588803 Tanner, Robert, of Durseley, gent 0
4935639 2337534 2337534 defendant Tanner John skinner 588803 588803 Tanner, John, of Durseley, skinner 1
4935640 2337534 2337534 defendant Lylburn John laborer 588803 588803 Lylburn, John, of Durseley, laborer 2
4935641 2337534 2337534 defendant Taillour William fuller 588803 588803 Taillour, William, of Durseley, fuller 3
4950281 2342054 2342054 defendant Baker John tanner 588803 588803 Baker, John, of Durseley, tanner 3
5010820 2360016 2360016 defendant Plymmeswode Walter weaver 588803 588803 Plymmeswode, Walter, of Durseley, weaver 0
5010821 2360016 2360016 defendant Gybbes Nicholas weaver 588803 588803 Gybbes, Nicholas, of Durseley, weaver 1
5013701 2360848 2360848 defendant Levynthorp Thomas fuller 588803 588803 Levynthorp, Thomas, of Durseley, fuller 1
5076518 2379478 2379478 defendant Wykes Thomas gent 588803 588803 Wykes, Thomas, of Durseley, gent 0
5095040 2384963 2384963 defendant Wykes Thomas gent 588803 588803 Wykes, Thomas, of Durseley, gent 1
5196182 2414630 2414630 defendant Davy Thomas butcher 588803 588803 Davy, Thomas, of Durseley, butcher 0
5196185 2414631 2414631 defendant Davy Thomas butcher 588803 588803 Davy, Thomas, of Durseley, butcher 0
5205027 2417225 2417225 defendant Wykes Thomas gent 588803 588803 Wykes, Thomas, of Durseley, gent 1
5259594 2433120 2433120 defendant Wykes John gent 588803 588803 Wykes, John, of Durseley, gent 0
5379929 2469308 2469308 defendant Davies William merchant 588803 588803 Davies, William, of Durseley, merchant 0
5435332 2485504 2485504 defendant Parker William weaver 588803 588803 Parker, William, of Durseley, weaver 0
5435333 2485504 2485504 defendant Tanner Robert yeoman 588803 588803 Tanner, Robert, of Durseley, yeoman 1
5481746 2499473 2499473 defendant Abadam William tucker 588803 588803 Abadam, William, of Durseley, tucker 0
5532176 2514610 2514610 defendant Benet John, junior clothman 588803 588803 Benet, John, junior, of Durseley, clothman 0
5532182 2514612 2514612 defendant Parker William weaver 588803 588803 Parker, William, of Durseley, weaver 1
5532183 2514612 2514612 defendant Payne John baker 588803 588803 Payne, John, of Durseley, baker 2
5533943 2515158 2515158 defendant Sherman John clothier 588803 588803 Sherman, John, of Durseley, clothier 0
5533944 2515158 2515158 defendant Badam Alice widow 588803 588803 Badam, Alice, of Durseley, widow 1
5533945 2515158 2515158 defendant Hewys John clothier 588803 588803 Hewys, John, of Durseley, clothier 2
5608272 2537490 2537490 defendant Danys William merchant 588803 588803 Danys, William, of Durseley, merchant 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);