names

5,946 rows where place_id = 585925

✎ 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
3587515 1863742 1863742 defendant Shephard John merchant 585925 585925 Shephard, John, of Bristol, merchant 1
3587739 1863811 1863811 defendant Bond Richard merchant 585925 585925 Bond, Richard, of Bristol, merchant 1
3588699 1864110 1864110 plaintiff Bond Richard merchant 585925 585925 Bond, Richard, of Bristol, merchant 0
3588724 1864116 1864116 plaintiff Boner or Bouer Richard merchant 585925 585925 Boner or Bouer, Richard, of Bristol, merchant 0
3589204 1864267 1864267 plaintiff Broun Nicholas merchant 585925 585925 Broun, Nicholas, of Bristol, merchant 0
3590800 1864762 1864762 plaintiff Dale Henry merchant 585925 585925 Dale, Henry, of Bristol, merchant 0
3590803 1864763 1864763 plaintiff Dale Henry merchant 585925 585925 Dale, Henry, of Bristol, merchant 0
3591034 1864822 1864822 plaintiff Davyes John, junior brewer 585925 585925 Davyes, John, junior, of Bristol, brewer 0
3591042 1864826 1864826 plaintiff de la Founte William merchant 585925 585925 de la Founte, William, of Bristol, merchant 0
3591682 1865017 1865017 plaintiff Esterfeld John merchant 585925 585925 Esterfeld, John, of Bristol, merchant 0
3591686 1865018 1865018 plaintiff Esterfeld John merchant 585925 585925 Esterfeld, John, of Bristol, merchant 0
3591690 1865019 1865019 plaintiff Esterfeld John merchant 585925 585925 Esterfeld, John, of Bristol, merchant 0
3592448 1865253 1865253 defendant Peny William haberdasher 585925 585925 Peny, William, of Bristol, haberdasher 0
3592451 1865254 1865254 defendant Peny William haberdasher 585925 585925 Peny, William, of Bristol, haberdasher 0
3592464 1865258 1865258 defendant Sherman Richard merchant 585925 585925 Sherman, Richard, of Bristol, merchant 0
3592789 1865357 1865357 defendant Lancok Julia (legal representative) 585925 585925 Lancok, Julia, of Bristol, widow, formerly Wycam, Julia, executor of 0
3592794 1865359 1865359 defendant Lancok alias Wycam Julia (legal representative) 585925 585925 Lancok alias Wycam, Julia, of Bristol, widow, executor of 0
3592795 1865359 1865359 defendant Wycam Thomas gent 585925 585925 Wycam, Thomas, of Bristol, gent 1
3592797 1865360 1865360 defendant Lankcok alias Wicam Juluam (legal representative) 585925 585925 Lankcok alias Wicam, Juluam, of Bristol, widow, executor of 0
3592798 1865360 1865360 defendant Wicam Thomas gent 585925 585925 Wicam, Thomas, of Bristol, gent 1
3593405 1865571 1865571 defendant Toker Thomas cordwainer 585925 585925 Toker, Thomas, of Bristol, cordwainer 0
3593558 1865622 1865622 defendant Make Stephen   585925 585925 Make, Stephen, of Bristol, coverlet weaver 0
3594207 1865830 1865830 defendant Shepherd John merchant 585925 585925 Shepherd, John, of Bristol, merchant 0
3594426 1865894 1865894 defendant Slegge John gent 585925 585925 Slegge, John, of Bristol, gent 0
3594618 1865947 1865947 defendant Gerom Thomas dyer 585925 585925 Gerom, Thomas, of Bristol, dyer 0
3596661 1866592 1866592 plaintiff Poplay John   585925 585925 Poplay, John, of Bristol 0
3596674 1866596 1866596 defendant Thomas John merchant 585925 585925 Thomas, John, of Bristol, merchant 0
3597296 1866775 1866775 plaintiff Robert Richard merchant 585925 585925 Robert, Richard, of Bristol, merchant 0
3597298 1866776 1866776 plaintiff Robert Richard merchant 585925 585925 Robert, Richard, of Bristol, merchant 0
3598322 1867103 1867103 plaintiff Snygge John mercer 585925 585925 Snygge, John, of Bristol, mercer 0
3598323 1867103 1867103 defendant Gervayse Edmund merchant 585925 585925 Gervayse, Edmund, of Bristol, merchant 0
3598325 1867104 1867104 plaintiff Snygge John mercer 585925 585925 Snygge, John, of Bristol, mercer 0
3598326 1867104 1867104 defendant Gervayse Edmund yeoman 585925 585925 Gervayse, Edmund, of Bristol, yeoman 0
3598328 1867105 1867105 plaintiff Snygge Thomas mercer 585925 585925 Snygge, Thomas, of Bristol, mercer 0
3599175 1867377 1867377 defendant Monmouth John merchant 585925 585925 Monmouth, John, of Bristol, merchant 5
3599490 1867482 1867482 defendant Joyse William merchant 585925 585925 Joyse, William, of Bristol, merchant 0
3599500 1867485 1867485 defendant Cachemay Robert merchant 585925 585925 Cachemay, Robert, of Bristol, merchant 0
3599668 1867538 1867538 plaintiff Vaughan Richard merchant 585925 585925 Vaughan, Richard, of Bristol, merchant 0
3599671 1867539 1867539 plaintiff Vaughan Richard merchant 585925 585925 Vaughan, Richard, of Bristol, merchant 0
3599845 1867601 1867601 plaintiff Ward Richard merchant 585925 585925 Ward, Richard, of Bristol, merchant 0
3600067 1867671 1867671 defendant Tyler John tiler 585925 585925 Tyler, John, of Bristol, tiler 10
3600588 1867831 1867831 defendant Peny William merchant 585925 585925 Peny, William, of Bristol, merchant 0
3600658 1867851 1867851 defendant Philippes Richard laborer 585925 585925 Philippes, Richard, of Bristol, laborer 1
3600659 1867851 1867851 defendant White John   585925 585925 White, John, of Bristol, lime burner 2
3601015 1867985 1867985 plaintiff A Meryk Philip weaver 585925 585925 A Meryk, Philip, of Bristol, weaver 0
3601016 1867985 1867985 defendant Depden John gent 585925 585925 Depden, John, of Bristol, gent 0
3601017 1867986 1867986 plaintiff A Meryk Philip weaver 585925 585925 A Meryk, Philip, of Bristol, weaver 0
3601180 1868034 1868034 defendant Artour William dyer 585925 585925 Artour, William, of Bristol, dyer 3
3601207 1868040 1868040 defendant Keer Richard goldsmith 585925 585925 Keer, Richard, of Bristol, goldsmith 2
3601250 1868053 1868053 plaintiff ap Meryk Philip weaver 585925 585925 ap Meryk, Philip, of Bristol, weaver 0
3601252 1868053 1868053 defendant Depden John gent 585925 585925 Depden, John, of Bristol, gent 1
3601900 1868250 1868250 defendant a Meryke Thomas merchant 585925 585925 a Meryke, Thomas, of Bristol, merchant 0
3601902 1868250 1868250 defendant Jeynckyns Margaret widow 585925 585925 Jeynckyns, Margaret, of Bristol, widow 2
3602144 1868335 1868335 defendant Philips William goldsmith 585925 585925 Philips, William, of Bristol, goldsmith 0
3602197 1868353 1868353 defendant Days Roger merchant 585925 585925 Days, Roger, of Bristol, merchant 0
3602198 1868353 1868353 defendant Asshehurst Thomas merchant 585925 585925 Asshehurst, Thomas, of Bristol, merchant 1
3602231 1868363 1868363 defendant Deys Roger merchant 585925 585925 Deys, Roger, of Bristol, merchant 0
3602232 1868363 1868363 defendant Asshehurst Thomas merchant 585925 585925 Asshehurst, Thomas, of Bristol, merchant 1
3603073 1868627 1868627 defendant John Welthiana widow 585925 585925 John, Welthiana, of Bristol, widow 0
3603074 1868627 1868627 defendant Thomas David merchant 585925 585925 Thomas, David, of Bristol, merchant 1
3604327 1869017 1869017 defendant Bowyar William bowyer 585925 585925 Bowyar, William, of Bristol, bowyer 0
3604329 1869018 1869018 defendant Wodward Thomas clerk 585925 585925 Wodward, Thomas, of Bristol, clerk 0
3605054 1869246 1869246 plaintiff Hoby Richard merchant 585925 585925 Hoby, Richard, of Bristol, merchant 0
3605319 1869329 1869329 defendant Rogers alias Pynner John mercer 585925 585925 Rogers alias Pynner, John, of Bristol, mercer 0
3605616 1869421 1869421 defendant Kemys Arthur gent 585925 585925 Kemys, Arthur, of Bristol, gent 0
3605619 1869422 1869422 defendant Kemys Arthur gent 585925 585925 Kemys, Arthur, of Bristol, gent 0
3606714 1869776 1869776 defendant Smyth Thomas mercer 585925 585925 Smyth, Thomas, of Bristol, mercer 0
3606716 1869777 1869777 defendant Smyth Thomas mercer 585925 585925 Smyth, Thomas, of Bristol, mercer 0
3606742 1869784 1869784 defendant Cessell Thomas butcher 585925 585925 Cessell, Thomas, of Bristol, butcher 0
3607944 1870133 1870133 defendant Cornewe Thomas tucker 585925 585925 Cornewe, Thomas, of Bristol, tucker 0
3608895 1870438 1870438 defendant Bolton Robert merchant 585925 585925 Bolton, Robert, of Bristol, merchant 0
3609029 1870479 1870479 defendant Rogers alias Pynner John mercer 585925 585925 Rogers alias Pynner, John, of Bristol, mercer 0
3610499 1870947 1870947 defendant Philippes Richard laborer 585925 585925 Philippes, Richard, of Bristol, laborer 1
3610500 1870947 1870947 defendant White John   585925 585925 White, John, of Bristol, lime burner 2
3610502 1870948 1870948 defendant Philippes Richard laborer 585925 585925 Philippes, Richard, of Bristol, laborer 0
3610503 1870948 1870948 defendant White John   585925 585925 White, John, of Bristol, lime burner 1
3611736 1871333 1871333 defendant Yonge Thomas gent 585925 585925 Yonge, Thomas, of Bristol, gent 0
3612886 1871678 1871678 defendant Broun Nicholas merchant 585925 585925 Broun, Nicholas, of Bristol, merchant 0
3613219 1871788 1871788 defendant Catchenere Robert merchant 585925 585925 Catchenere, Robert, of Bristol, merchant 4
3613644 1871913 1871913 defendant Hanley or Hauley Thomas gent 585925 585925 Hanley or Hauley, Thomas, of Bristol, gent 2
3613648 1871914 1871914 defendant Hanley or Hauley Thomas gent 585925 585925 Hanley or Hauley, Thomas, of Bristol, gent 2
3613685 1871929 1871929 plaintiff Beell Thomas (legal representative) 585925 585925 Beell, Thomas, of Bristol, executors of 0
3613688 1871929 1871929 defendant Wawton Philip merchant 585925 585925 (Wawton, Philip, of Bristol, merchant 1
3613689 1871929 1871929 defendant Habyrden Peter merchant 585925 585925 Habyrden, Peter, of Bristol, merchant 2
3614534 1872194 1872194 defendant Alestre William vintner 585925 585925 Alestre, William, of Bristol, vintner 0
3614536 1872195 1872195 defendant Allestre William vintner 585925 585925 Allestre, William, of Bristol, vintner 0
3614776 1872272 1872272 plaintiff Buttler John mercer 585925 585925 Buttler, John, of Bristol, mercer 0
3614778 1872273 1872273 plaintiff Buttler John mercer 585925 585925 Buttler, John, of Bristol, mercer 0
3615525 1872497 1872497 defendant Penny William merchant 585925 585925 Penny, William, of Bristol, merchant 0
3615526 1872497 1872497 defendant Trowecok John merchant 585925 585925 Trowecok, John, of Bristol, merchant 1
3615527 1872497 1872497 defendant Wyltshyre Richard merchant 585925 585925 Wyltshyre, Richard, of Bristol, merchant 2
3615528 1872497 1872497 defendant Monmouthe John merchant 585925 585925 Monmouthe, John, of Bristol, merchant 3
3616747 1872868 1872868 defendant Pulisson Thomas chapman 585925 585925 Pulisson, Thomas, of Bristol, chapman 1
3616933 1872922 1872922 defendant Crocok John haberdasher 585925 585925 Crocok, John, of Bristol, haberdasher 3
3617697 1873159 1873159 defendant Elledyr John pinner 585925 585925 Elledyr, John, of Bristol, pinner 4
3617701 1873160 1873160 defendant White William mercer 585925 585925 White, William, of Bristol, mercer 2
3617703 1873160 1873160 defendant Bonwey Henry weaver 585925 585925 Bonwey, Henry, of Bristol, weaver 4
3617763 1873179 1873179 defendant Bayles or Baylef Richard yeoman 585925 585925 Bayles or Baylef, Richard, of Bristol, yeoman 3
3618311 1873357 1873357 plaintiff Gyfford William merchant 585925 585925 Gyfford, William, of Bristol, merchant 0
3618545 1873424 1873424 defendant Smyth John mercer 585925 585925 Smyth, John, of Bristol, 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);