names

188 rows where place_id = 590066

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3599777 1867574 1867574 defendant Farley John merchant 590066 590066 Farley, John, of Bryggewater, merchant 0
3601435 1868109 1868109 defendant Smyth Thomas mariner 590066 590066 Smyth, Thomas, of Bryggewater, mariner 0
3601437 1868109 1868109 defendant Parys John clothier and town clerk 590066 590066 Parys, John, of Bryggewater, clothier and town clerk 2
3604998 1869226 1869226 defendant Couper John merchant 590066 590066 Couper, John, of Bryggewater, merchant 0
3613354 1871823 1871823 defendant Hydam Adam chaplain 590066 590066 Hydam, Adam, of Bryggewater, chaplain 0
3613356 1871824 1871824 defendant Kendall Robert laborer 590066 590066 Kendall, Robert, of Bryggewater, laborer 0
3613358 1871825 1871825 defendant Wymar John merchant 590066 590066 Wymar, John, of Bryggewater, merchant 0
3624003 1875040 1875040 defendant Smyth John, senior (legal representative) 590066 590066 Smyth, John, senior, of Bryggewater, merchant, executor of 0
3624004 1875040 1875040 defendant Smyth John merchant 590066 590066 Smyth, John, of Bryggewater, merchant 1
3625470 1875505 1875505 defendant Topratt Robert merchant 590066 590066 Topratt, Robert, of Bryggewater, merchant 0
3625471 1875505 1875505 defendant West Robert tailor 590066 590066 West, Robert, of Bryggewater, tailor 1
3692822 1923948 1923948 defendant Saunders John merchant 590066 590066 Saunders, John, of Bryggewater, merchant 0
3761826 1945708 1945708 defendant Skelton Alexander merchant 590066 590066 Skelton, Alexander, of Bryggewater, merchant 1
3893556 1988071 1988071 defendant Crane Thomas clerk 590066 590066 Crane, Thomas, of Bryggewater, clerk 2
4474617 2192723 2192723 defendant Beste John merchant 590066 590066 Beste, John, of Bryggewater, merchant 0
4506271 2202461 2202461 defendant Westle Adam   590066 590066 Westle, Adam, of Bryggewater 1
4519369 2206417 2206417 defendant Solas Robert   590066 590066 Solas, Robert, of Bryggewater 2
4519373 2206418 2206418 defendant Solas Robert   590066 590066 Solas, Robert, of Bryggewater 2
4561522 2219538 2219538 defendant Warde John   590066 590066 Warde, John, of Bryggewater 0
4592579 2229030 2229030 defendant Cook John   590066 590066 Cook, John, of Bryggewater 2
4595044 2229709 2229709 plaintiff Pytte John   590066 590066 Pytte, John, of Bryggewater 0
4616932 2236301 2236301 defendant Elys John   590066 590066 Elys, John, of Bryggewater 1
4647882 2245447 2245447 defendant Bygod John   590066 590066 Bygod, John, of Bryggewater 1
4647887 2245449 2245449 defendant Bygod John   590066 590066 Bygod, John, of Bryggewater 0
4676675 2258322 2258322 defendant Aylleward John merchant 590066 590066 Aylleward, John, of Bryggewater, merchant 0
4730058 2274602 2274602 defendant Gardyner Robert merchant 590066 590066 Gardyner, Robert, of Bryggewater, merchant 0
4730059 2274602 2274602 defendant Gardyner John merchant 590066 590066 Gardyner, John, of Bryggewater, merchant 1
4730698 2274799 2274799 defendant Pytte John merchant 590066 590066 Pytte, John, of Bryggewater, merchant 0
4748553 2280079 2280079 defendant Pyt John merchant 590066 590066 Pyt, John, of Bryggewater, merchant 0
4748554 2280079 2280079 defendant Gardyner Robert merchant 590066 590066 Gardyner, Robert, of Bryggewater, merchant 1
4768934 2286264 2286264 defendant Haryngton William   590066 590066 Haryngton, William, of Bryggewater, knight 0
4785664 2291545 2291545 defendant Gardener John merchant 590066 590066 Gardener, John, of Bryggewater, merchant 1
4789355 2292733 2292733 defendant Deye Henry butcher 590066 590066 Deye, Henry, of Bryggewater, butcher 0
4803078 2297149 2297149 defendant Touker Geoffery fuller 590066 590066 Touker, Geoffery, of Bryggewater, fuller 0
4803080 2297149 2297149 defendant Curteys David shipman 590066 590066 Curteys, David, of Bryggewater, shipman 2
4803082 2297149 2297149 defendant Aylwarde John merchant 590066 590066 Aylwarde, John, of Bryggewater, merchant 4
4803086 2297151 2297151 defendant Touker Geoffery fuller 590066 590066 Touker, Geoffery, of Bryggewater, fuller 0
4803420 2297259 2297259 defendant Botelmaker John tanner 590066 590066 Botelmaker, John, of Bryggewater, tanner 0
4803736 2297350 2297350 defendant Pedhull William husbandman 590066 590066 Pedhull, William, of Bryggewater, husbandman 0
4805272 2297850 2297850 defendant Cary Richard   590066 590066 Cary, Richard, of Bryggewater, burgess & chapman 0
4812363 2299979 2299979 defendant Ayleward John merchant 590066 590066 Ayleward, John, of Bryggewater, merchant 0
4817997 2301711 2301711 defendant Pitte John merchant 590066 590066 Pitte, John, of Bryggewater, merchant 0
4824452 2303698 2303698 defendant Hurdecombe John yeoman 590066 590066 Hurdecombe, John, of Bryggewater, yeoman 0
4824453 2303698 2303698 defendant Jobard John husbandman 590066 590066 Jobard, John, of Bryggewater, husbandman 1
4824454 2303698 2303698 defendant Glover Robert glover 590066 590066 Glover, Robert, of Bryggewater, glover 2
4832181 2306095 2306095 defendant Hombewer William ostler 590066 590066 Hombewer, William, of Bryggewater, ostler 0
4845023 2309959 2309959 defendant Pytte John husbandman 590066 590066 Pytte, John, of Bryggewater, husbandman 0
4854868 2312875 2312875 defendant Clewer alias Draper William merchant 590066 590066 Clewer alias Draper, William, of Bryggewater, merchant 1
4859830 2314445 2314445 defendant Otery John husbandman 590066 590066 Otery, John, of Bryggewater, husbandman 1
4888164 2323102 2323102 defendant Smyth John merchant 590066 590066 Smyth, John, of Bryggewater, merchant 1
4907637 2328954 2328954 defendant Jerveys John weaver 590066 590066 Jerveys, John, of Bryggewater, weaver 3
4907638 2328954 2328954 defendant Trotte John shoemaker 590066 590066 Trotte, John, of Bryggewater, shoemaker 4
4912842 2330510 2330510 defendant Curteys David mariner 590066 590066 Curteys, David, of Bryggewater, mariner 0
4914804 2331144 2331144 defendant Gardyner John mariner 590066 590066 Gardyner, John, of Bryggewater, mariner 2
4914805 2331144 2331144 defendant Gardyner William mariner 590066 590066 Gardyner, William, of Bryggewater, mariner 3
4922445 2333429 2333429 defendant Smyth John merchant 590066 590066 Smyth, John, of Bryggewater, merchant 0
4924215 2334019 2334019 defendant Gardyner Richard merchant 590066 590066 Gardyner, Richard, of Bryggewater, merchant 0
4926339 2334663 2334663 plaintiff Pylton Thomas Master of the Hospital of St John Baptist 590066 590066 Pylton, Thomas, of Bryggewater, Master of the Hospital of St John Baptist 0
4929253 2335568 2335568 defendant Meye John merchant 590066 590066 Meye, John, of Bryggewater, merchant 0
4943597 2339965 2339965 defendant Spencer John cordwainer 590066 590066 Spencer, John, of Bryggewater, cordwainer 0
4948379 2341476 2341476 defendant Craddok Thomas merchant 590066 590066 Craddok, Thomas, of Bryggewater, merchant 0
4948381 2341476 2341476 defendant Tyraunt John, junior draper 590066 590066 Tyraunt, John, junior, of Bryggewater, draper 2
4948384 2341477 2341477 defendant Bere John   590066 590066 Bere, John, of Bryggewater, merchant, administrators of 1
4948385 2341477 2341477 defendant Bere Ellen widow 590066 590066 (Bere, Ellen, of Bryggewater, widow 2
4948386 2341477 2341477 defendant Taillour Simon tailor 590066 590066 Taillour, Simon, of Bryggewater, tailor 3
4948387 2341477 2341477 defendant Herte John merchant 590066 590066 Herte, John, of Bryggewater, merchant 4
4953899 2343131 2343131 defendant Ayleward John merchant 590066 590066 Ayleward, John, of Bryggewater, merchant 1
4957708 2344277 2344277 defendant Deye Henry butcher 590066 590066 Deye, Henry, of Bryggewater, butcher 2
4978284 2350452 2350452 defendant Acton Thomas   590066 590066 Acton, Thomas, of Bryggewater, apothecary 0
4978285 2350452 2350452 defendant Selby Nicholas draper 590066 590066 Selby, Nicholas, of Bryggewater, draper 1
4978286 2350452 2350452 defendant Spenser John cordwainer 590066 590066 Spenser, John, of Bryggewater, cordwainer 2
4978287 2350452 2350452 defendant Barcorne John butcher 590066 590066 Barcorne, John, of Bryggewater, butcher 3
4988665 2353567 2353567 plaintiff Breteel Richard   590066 590066 Breteel, Richard, of Bryggewater 0
4988668 2353568 2353568 plaintiff Bretell Richard   590066 590066 Bretell, Richard, of Bryggewater 0
4992595 2354668 2354668 defendant Peyntour John painter 590066 590066 Peyntour, John, of Bryggewater, painter 1
5011460 2360216 2360216 defendant Vageler John husbandman 590066 590066 Vageler, John, of Bryggewater, husbandman 3
5012883 2360601 2360601 defendant Smyth William yeoman 590066 590066 Smyth, William, of Bryggewater, yeoman 0
5014971 2361257 2361257 defendant Godehyve or Godehyne Thomas mercer 590066 590066 Godehyve or Godehyne, Thomas, of Bryggewater, mercer 1
5014976 2361258 2361258 defendant Godehyve or Godehyne Thomas mercer 590066 590066 Godehyve or Godehyne, Thomas, of Bryggewater, mercer 1
5015474 2361407 2361407 defendant Colyford Elizabeth widow 590066 590066 Colyford, Elizabeth, of Bryggewater, widow 0
5022663 2363535 2363535 defendant Godehyne or Godehyve Thomas mercer 590066 590066 Godehyne or Godehyve, Thomas, of Bryggewater, mercer 0
5026938 2364746 2364746 defendant Gardyner John merchant 590066 590066 Gardyner, John, of Bryggewater, merchant 0
5027706 2364977 2364977 defendant Batyn William yeoman 590066 590066 Batyn, William, of Bryggewater, yeoman 2
5028821 2365304 2365304 defendant Tracy John yeoman 590066 590066 Tracy, John, of Bryggewater, yeoman 2
5028824 2365305 2365305 defendant Colyford Elizabeth widow 590066 590066 (Colyford, Elizabeth, of Bryggewater, widow 1
5028825 2365305 2365305 defendant Tracy John yeoman 590066 590066 Tracy, John, of Bryggewater, yeoman 2
5032556 2366405 2366405 defendant Acton Thomas grocer 590066 590066 Acton, Thomas, of Bryggewater, grocer 0
5034571 2366971 2366971 defendant Mey John merchant 590066 590066 Mey, John, of Bryggewater, merchant 0
5035598 2367272 2367272 defendant Clopton Richard ostler 590066 590066 Clopton, Richard, of Bryggewater, ostler 4
5035599 2367272 2367272 defendant Parys Walter tucker 590066 590066 Parys, Walter, of Bryggewater, tucker 5
5035605 2367273 2367273 defendant Clopton Richard ostler 590066 590066 Clopton, Richard, of Bryggewater, ostler 4
5035606 2367273 2367273 defendant Parys Walter tucker 590066 590066 Parys, Walter, of Bryggewater, tucker 5
5039568 2368482 2368482 defendant Parker John mercer 590066 590066 Parker, John, of Bryggewater, mercer 0
5046863 2370681 2370681 defendant Hale William carpenter 590066 590066 Hale, William, of Bryggewater, carpenter 0
5056947 2373654 2373654 defendant Dunman Thomas butcher 590066 590066 Dunman, Thomas, of Bryggewater, butcher 0
5056948 2373654 2373654 defendant Tarant John draper 590066 590066 Tarant, John, of Bryggewater, draper 1
5076029 2379326 2379326 defendant Wyse John merchant 590066 590066 Wyse, John, of Bryggewater, merchant 0
5079986 2380493 2380493 defendant Bolley William tailor 590066 590066 Bolley, William, of Bryggewater, tailor 0
5081386 2380938 2380938 defendant Forde Richard yeoman 590066 590066 Forde, Richard, of Bryggewater, yeoman 0
5092614 2384218 2384218 defendant Smyth John mercer 590066 590066 Smyth, John, of Bryggewater, mercer 0

Next page

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);