names

53 rows where place_id = 591435

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3604418 1869049 1869049 defendant Hasard John chapman 591435 591435 Hasard, John, of Warham, Dorset, chapman 1
3604421 1869050 1869050 defendant Hasard John chapman or carrier 591435 591435 Hasard, John, of Warham, Dorset, chapman or carrier 1
3868932 1979852 1979852 defendant Foster William pinner 591435 591435 Foster, William, of Warham, Dorset, pinner 1
3868937 1979853 1979853 defendant Foster William pinner 591435 591435 Foster, William, of Warham, Dorset, pinner 2
4260765 2116564 2116564 defendant Cleves Augustine merchant 591435 591435 Cleves, Augustine, of Warham, Dorset, merchant 0
4260819 2116583 2116583 defendant Cleves Augustine merchant 591435 591435 Cleves, Augustine, of Warham, Dorset, merchant 0
4309680 2133543 2133543 defendant Cole George merchant 591435 591435 Cole, George, of Warham, Dorset, merchant 3
4552665 2216787 2216787 defendant Shene John   591435 591435 Shene, John, of Warham, Dorset 0
4717532 2270818 2270818 defendant Barbour Agnes   591435 591435 Barbour, Agnes, of Warham, Dorset, widow, formerly wife of Thomas 1
4722901 2272480 2272480 defendant Cornyssh Henry tailor 591435 591435 Cornyssh, Henry, of Warham, Dorset, tailor 0
4724657 2273010 2273010 defendant Love or Lone William chapman 591435 591435 Love or Lone, William, of Warham, Dorset, chapman 0
4724660 2273011 2273011 defendant Love William chapman 591435 591435 Love, William, of Warham, Dorset, chapman 0
4794682 2294474 2294474 defendant Kyngeston Richard husbandman 591435 591435 Kyngeston, Richard, of Warham, Dorset, husbandman 0
4828107 2304834 2304834 defendant Frome William gent 591435 591435 Frome, William, of Warham, Dorset, gent 0
4837662 2307709 2307709 defendant Byle William gent 591435 591435 Byle, William, of Warham, Dorset, gent 0
4837664 2307710 2307710 defendant Byle William   591435 591435 Byle, William, of Warham, Dorset, attorney 0
4837666 2307711 2307711 defendant Byle William   591435 591435 Byle, William, of Warham, Dorset, attorney 0
4837668 2307712 2307712 defendant Byle William   591435 591435 Byle, William, of Warham, Dorset, attorney 0
4839094 2308157 2308157 defendant Dyere Robert dyer 591435 591435 Dyere, Robert, of Warham, Dorset, dyer 0
4839411 2308247 2308247 defendant Byle William gent 591435 591435 Byle, William, of Warham, Dorset, gent 0
4935259 2337430 2337430 defendant Kyngeston Richard yeoman 591435 591435 Kyngeston, Richard, of Warham, Dorset, yeoman 0
4946665 2340958 2340958 defendant Kyngesdon Richard husbandman 591435 591435 Kyngesdon, Richard, of Warham, Dorset, husbandman 0
4952993 2342859 2342859 defendant Reson Walter   591435 591435 Reson, Walter, of Warham, Dorset, franklin 0
4964071 2346165 2346165 defendant Benet Richard clerk 591435 591435 Benet, Richard, of Warham, Dorset, clerk 0
4968058 2347392 2347392 defendant Byle William gent 591435 591435 Byle, William, of Warham, Dorset, gent 0
4968065 2347394 2347394 defendant Byle William gent 591435 591435 Byle, William, of Warham, Dorset, gent 1
4975442 2349619 2349619 defendant Reson Walter merchant 591435 591435 Reson, Walter, of Warham, Dorset, merchant 1
4999605 2356756 2356756 defendant Stevenes Thomas merchant 591435 591435 Stevenes, Thomas, of Warham, Dorset, merchant 1
5008996 2359523 2359523 defendant Byle William gent 591435 591435 Byle, William, of Warham, Dorset, gent 0
5009006 2359524 2359524 defendant Byle William gent 591435 591435 Byle, William, of Warham, Dorset, gent 0
5043021 2369530 2369530 defendant Doge Thomas (legal representative) 591435 591435 Doge, Thomas, of Warham, Dorset, gent, executor of 0
5046459 2370582 2370582 defendant Doge Thomas (legal representative) 591435 591435 Doge, Thomas, of Warham, Dorset, gent, executor of 0
5091445 2383883 2383883 defendant Chyke William gent 591435 591435 Chyke, William, of Warham, Dorset, gent 0
5150822 2401385 2401385 defendant Dogs Thomas gent 591435 591435 Dogs, Thomas, of Warham, Dorset, gent 2
5150845 2401390 2401390 defendant Doge Thomas gent 591435 591435 Doge, Thomas, of Warham, Dorset, gent 2
5157566 2403341 2403341 defendant Tisyng Edward yeoman 591435 591435 (Tisyng, Edward, of Warham, Dorset, yeoman 2
5164852 2405453 2405453 defendant Gerard Thomas husbandman 591435 591435 Gerard, Thomas, of Warham, Dorset, husbandman 1
5173442 2407933 2407933 defendant Fouke Henry (legal representative) 591435 591435 Fouke, Henry, of Warham, Dorset, merchant, executors of 3
5173443 2407933 2407933 defendant Tysyng Edward yeoman 591435 591435 (Tysyng, Edward, of Warham, Dorset, yeoman 4
5208189 2418123 2418123 defendant Tysy Edward yeoman 591435 591435 (Tysy, Edward, of Warham, Dorset, yeoman 5
5267529 2435606 2435606 defendant Resyn John yeoman 591435 591435 Resyn, John, of Warham, Dorset, yeoman 0
5279174 2439008 2439008 defendant Dowenam Henry chapman 591435 591435 Dowenam, Henry, of Warham, Dorset, chapman 0
5299038 2444699 2444699 defendant Dowenam Henry chapman 591435 591435 Dowenam, Henry, of Warham, Dorset, chapman 0
5304883 2446464 2446464 defendant Taylour Richard merchant 591435 591435 Taylour, Richard, of Warham, Dorset, merchant 0
5320250 2451143 2451143 defendant Taillour Edith widow 591435 591435 Taillour, Edith, of Warham, Dorset, widow 1
5321429 2451501 2451501 defendant Benet Richard clerk 591435 591435 Benet, Richard, of Warham, Dorset, or of Codford, Wilts, clerk 0
5322029 2451658 2451658 defendant Hayte Joan widow 591435 591435 Hayte, Joan, of Warham, Dorset, widow 2
5337717 2456353 2456353 defendant Elwyn John merchant 591435 591435 Elwyn, John, of Warham, Dorset, merchant 1
5337902 2456420 2456420 defendant Elwyn John merchant 591435 591435 Elwyn, John, of Warham, Dorset, merchant 1
5357550 2462429 2462429 defendant Bele Robert yeoman 591435 591435 Bele, Robert, of Warham, Dorset, yeoman 0
5357552 2462430 2462430 defendant Bole Robert yeoman 591435 591435 Bole, Robert, of Warham, Dorset, yeoman 0
5537056 2516073 2516073 defendant Perham Alice widow 591435 591435 Perham, Alice, of Warham, Dorset, widow 4
5626079 2552119 2552119 defendant Reson Walter clerk 591435 591435 Reson, Walter, of Warham, Dorset, clerk 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);