names

569 rows where place_id = 585996

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3587655 1863785 1863785 plaintiff Aphowell William weaver 585996 585996 Aphowell, William, of Briggewater, weaver 0
3587960 1863887 1863887 defendant Drue John   585996 585996 Drue, John, of Briggewater, court holder 0
3587967 1863890 1863890 defendant Couper John merchant 585996 585996 Couper, John, of Briggewater, merchant 1
3588562 1864066 1864066 defendant Smyth Thomas merchant 585996 585996 Smyth, Thomas, of Briggewater, merchant 0
3590148 1864557 1864557 defendant Elman Alexander butcher 585996 585996 Elman, Alexander, of Briggewater, butcher 0
3590464 1864664 1864664 defendant Bartram Elias master of St John Baptist Hospital 585996 585996 Bartram, Elias, of Briggewater, chaplain, master of St John Baptist Hospital 0
3595821 1866329 1866329 defendant Couper John merchant 585996 585996 Couper, John, of Briggewater, merchant 1
3596663 1866592 1866592 defendant Phelipp Thomas gent 585996 585996 Phelipp, Thomas, of Briggewater, gent 1
3596664 1866592 1866592 defendant Cockys Robert merchant 585996 585996 Cockys, Robert, of Briggewater, merchant 2
3598787 1867249 1867249 defendant Michell Robert gent 585996 585996 Michell, Robert, of Briggewater, gent 0
3599670 1867538 1867538 defendant Dardes William merchant 585996 585996 Dardes, William, of Briggewater, merchant 1
3599673 1867539 1867539 defendant Baker Thomas merchant 585996 585996 Baker, Thomas, of Briggewater, merchant 1
3599674 1867539 1867539 defendant Dardes William merchant 585996 585996 Dardes, William, of Briggewater, merchant 2
3599818 1867589 1867589 defendant Farley John merchant 585996 585996 Farley, John, of Briggewater, merchant 0
3601433 1868108 1868108 defendant Drue John   585996 585996 Drue, John, of Briggewater, court holder 0
3603599 1868794 1868794 defendant Modislay John (legal representative) 585996 585996 Modislay, John, of Briggewater, merchant, executors of 0
3603600 1868794 1868794 defendant Cokkys Robert merchant 585996 585996 (Cokkys, Robert, of Briggewater, merchant 1
3605967 1869529 1869529 defendant Griffyth John yeoman of the crown 585996 585996 Griffyth, John, of Briggewater, yeoman of the crown 0
3607015 1869858 1869858 defendant Michell Robert gent 585996 585996 Michell, Robert, of Briggewater, gent 0
3614057 1872058 1872058 defendant Adams John merchant 585996 585996 Adams, John, of Briggewater, merchant 0
3623204 1874782 1874782 plaintiff Saunders John merchant 585996 585996 Saunders, John, of Briggewater, merchant 0
3627325 1903396 1903396 defendant Davy John merchant 585996 585996 Davy, John, of Briggewater, merchant 0
3630947 1904499 1904499 defendant Magot Thomas yeoman 585996 585996 Magot, Thomas, of Briggewater, yeoman 1
3635551 1905922 1905922 defendant Hays Edmund innholder 585996 585996 Hays, Edmund, of Briggewater, innholder 0
3638597 1906885 1906885 defendant Norman Thomas yeoman 585996 585996 Norman, Thomas, of Briggewater, yeoman 6
3639701 1907225 1907225 defendant Hertford John merchant 585996 585996 (Hertford, John, of Briggewater, merchant 4
3641161 1907685 1907685 defendant Osgod Richard merchant 585996 585996 Osgod, Richard, of Briggewater, merchant 1
3654880 1911786 1911786 defendant Alyn William clerk 585996 585996 Alyn, William, of Briggewater, clerk 0
3655140 1911869 1911869 defendant Chaunterell Thomas gent 585996 585996 Chaunterell, Thomas, of Briggewater, gent 0
3657024 1912459 1912459 defendant Davy John   585996 585996 Davy, John, of Briggewater, merchant, administrators of 0
3657025 1912459 1912459 defendant Hull John gent 585996 585996 (Hull, John, of Briggewater, gent 1
3657028 1912460 1912460 defendant Davy John   585996 585996 Davy, John, of Briggewater, merchant, administrators of 0
3657029 1912460 1912460 defendant Hull John gent 585996 585996 (Hull, John, of Briggewater, gent 1
3661185 1913774 1913774 defendant Hopkyns Thomas mercer 585996 585996 Hopkyns, Thomas, of Briggewater, mercer 0
3665293 1915098 1915098 defendant Lowker John merchant 585996 585996 Lowker, John, of Briggewater, merchant 0
3666103 1915343 1915343 defendant Hull John gent 585996 585996 Hull, John, of Briggewater, gent 0
3708562 1928979 1928979 plaintiff Osgode or Osgarde Richard merchant 585996 585996 Osgode or Osgarde, Richard, of Briggewater, merchant 0
3708564 1928980 1928980 plaintiff Osgode Richard merchant 585996 585996 Osgode, Richard, of Briggewater, merchant 0
3723291 1933557 1933557 defendant Hopkyns Thomas spicer 585996 585996 Hopkyns, Thomas, of Briggewater, spicer 0
3752059 1942566 1942566 defendant Skelton Richard merchant 585996 585996 Skelton, Richard, of Briggewater, merchant 1
3761821 1945707 1945707 defendant Skelton Alexander merchant 585996 585996 Skelton, Alexander, of Briggewater, merchant 1
3786413 1953538 1953538 defendant Newport John merchant 585996 585996 Newport, John, of Briggewater, merchant 0
3814528 1962457 1962457 defendant Awode John baker 585996 585996 Awode, John, of Briggewater, baker 0
3814529 1962457 1962457 defendant Morley John mercer 585996 585996 Morley, John, of Briggewater, mercer 1
3823332 1965211 1965211 defendant Wattys John mercer 585996 585996 Wattys, John, of Briggewater, mercer 0
4431625 2174658 2174658 defendant Aghere Richard   585996 585996 Aghere, Richard, of Briggewater 0
4442805 2182708 2182708 defendant Best Adam   585996 585996 Best, Adam, of Briggewater 0
4442807 2182709 2182709 defendant Best Adam   585996 585996 Best, Adam, of Briggewater 0
4445435 2183525 2183525 plaintiff Crich William   585996 585996 Crich, William, of Briggewater 0
4445438 2183526 2183526 plaintiff Crich William   585996 585996 Crich, William, of Briggewater 0
4448664 2184515 2184515 defendant Cole John   585996 585996 Cole, John, of Briggewater 1
4454848 2186529 2186529 defendant Mantyl Ralph   585996 585996 Mantyl, Ralph, of Briggewater 0
4455083 2186591 2186591 defendant Dod Walter   585996 585996 Dod, Walter, of Briggewater 2
4455093 2186592 2186592 defendant Dod Walter   585996 585996 Dod, Walter, of Briggewater 2
4462482 2188959 2188959 defendant Henton John   585996 585996 Henton, John, of Briggewater 0
4462995 2189128 2189128 plaintiff Tonnere William   585996 585996 Tonnere, William, of Briggewater 0
4468342 2190764 2190764 defendant Someryng Nicholas   585996 585996 Someryng, Nicholas, of Briggewater 0
4470631 2191462 2191462 defendant Rob-- John   585996 585996 Rob--, John, of Briggewater 0
4487505 2196808 2196808 defendant Ressell William chapman 585996 585996 Ressell, William, of Briggewater, chapman 0
4498050 2200036 2200036 defendant Nyll-- Julian   585996 585996 Nyll--, Julian, of Briggewater 5
4500361 2200734 2200734 defendant Raly John   585996 585996 Raly, John, of Briggewater 3
4502910 2201485 2201485 defendant Bussh Thomas   585996 585996 Bussh, Thomas, of Briggewater 2
4505047 2202110 2202110 defendant Hayward Nicholas   585996 585996 Hayward, Nicholas, of Briggewater 4
4508955 2203279 2203279 defendant Bolour John   585996 585996 Bolour, John, of Briggewater 0
4511043 2203904 2203904 defendant Aleys Robert   585996 585996 Aleys, Robert, of Briggewater 0
4516581 2205598 2205598 defendant Newemayster John   585996 585996 Newemayster, John, of Briggewater 0
4523586 2207701 2207701 plaintiff Hawne Richard   585996 585996 Hawne, Richard, of Briggewater 0
4537953 2212153 2212153 defendant Skynner Andrew   585996 585996 Skynner, Andrew, of Briggewater 2
4539614 2212650 2212650 defendant Coteler Philip   585996 585996 Coteler, Philip, of Briggewater 0
4539620 2212653 2212653 defendant Hawen Richard   585996 585996 Hawen, Richard, of Briggewater 0
4541046 2213107 2213107 defendant Best John, sen   585996 585996 Best, John, sen, of Briggewater 0
4545697 2214581 2214581 defendant Dodde John   585996 585996 Dodde, John, of Briggewater 0
4548979 2215613 2215613 defendant Mugge Robert   585996 585996 Mugge, Robert, of Briggewater 1
4548982 2215614 2215614 defendant Mugge Robert   585996 585996 Mugge, Robert, of Briggewater 1
4551945 2216561 2216561 defendant Poul alias Newemaistre John dyer 585996 585996 Poul alias Newemaistre, John, of Briggewater, dyer 2
4553068 2216903 2216903 defendant Matheu John   585996 585996 Matheu, John, of Briggewater 0
4553069 2216903 2216903 defendant Dodde John   585996 585996 Dodde, John, of Briggewater 1
4553070 2216903 2216903 defendant Westlegh Adam   585996 585996 Westlegh, Adam, of Briggewater 2
4553071 2216903 2216903 defendant Newemayster John   585996 585996 Newemayster, John, of Briggewater 3
4553565 2217047 2217047 defendant Wele John   585996 585996 Wele, John, of Briggewater 0
4554543 2217350 2217350 defendant Pule John   585996 585996 Pule, John, of Briggewater 0
4556909 2218092 2218092 defendant Stapelton William   585996 585996 Stapelton, William, of Briggewater 0
4556910 2218092 2218092 defendant Poule John   585996 585996 Poule, John, of Briggewater 1
4556912 2218092 2218092 defendant Skynner Robert   585996 585996 Skynner, Robert, of Briggewater 3
4556915 2218094 2218094 plaintiff Kedwelly John clerk 585996 585996 Kedwelly, John, of Briggewater, clerk 0
4557486 2218278 2218278 defendant Hayward Walter   585996 585996 Hayward, Walter, of Briggewater 0
4557487 2218278 2218278 defendant Someryng Nicholas   585996 585996 Someryng, Nicholas, of Briggewater 1
4563818 2220253 2220253 defendant Boucher John   585996 585996 Boucher, John, of Briggewater 1
4563821 2220253 2220253 defendant Mathen John   585996 585996 Mathen, John, of Briggewater 4
4567023 2221241 2221241 plaintiff Sydeneham John   585996 585996 Sydeneham, John, of Briggewater 0
4567024 2221241 2221241 defendant Kedwelly John   585996 585996 Kedwelly, John, of Briggewater 0
4567025 2221242 2221242 plaintiff Sydenham John   585996 585996 Sydenham, John, of Briggewater 0
4567026 2221242 2221242 defendant Gernesey John   585996 585996 Gernesey, John, of Briggewater 0
4567027 2221243 2221243 plaintiff Sydenham John   585996 585996 Sydenham, John, of Briggewater 0
4567028 2221243 2221243 defendant Kedwelly John   585996 585996 Kedwelly, John, of Briggewater 0
4568932 2221869 2221869 plaintiff Warde John   585996 585996 Warde, John, of Briggewater, merchant, son of Richard 0
4568935 2221870 2221870 plaintiff Warde John merchant 585996 585996 Warde, John, of Briggewater, son of Richard, merchant 0
4570485 2222342 2222342 defendant Sydenham John   585996 585996 Sydenham, John, of Briggewater 0
4575251 2223779 2223779 defendant Kedwelly John   585996 585996 Kedwelly, John, of Briggewater, burgess 0
4575260 2223780 2223780 defendant Kedewelly John   585996 585996 Kedewelly, John, of Briggewater 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);