names

130 rows where place_id = 626200

✎ 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
3768617 1947833 1947833 defendant Alen Richard yeoman 626200 626200 Alen, Richard, of Poole, yeoman 1
3824737 1965612 1965612 plaintiff Stocker John merchant 626200 626200 Stocker, John, of Poole, merchant 1
3908257 1993059 1993059 defendant Harrold Richard husbandman 626200 626200 Harrold, Richard, of Poole, husbandman 0
3908258 1993059 1993059 defendant Harrold Nicholas husbandman 626200 626200 Harrold, Nicholas, of Poole, husbandman 1
3944967 2005333 2005333 defendant Seamour Robert butcher 626200 626200 Seamour, Robert, of Poole, butcher 1
3952303 2007876 2007876 defendant ap Owen Robert ap Pers yeoman 626200 626200 ap Owen, Robert ap Pers, of Poole, yeoman 2
3981656 2018196 2018196 defendant Dunyng Edward yeoman 626200 626200 Dunyng, Edward, of Poole, yeoman 0
3986080 2019792 2019792 defendant Alyson Walter merchant 626200 626200 Alyson, Walter, of Poole, merchant 0
4005301 2026675 2026675 defendant Farewell Christopher merchant 626200 626200 Farewell, Christopher, of Poole, merchant 1
4005302 2026675 2026675 defendant Deye Rawlin merchant 626200 626200 Deye, Rawlin, of Poole, merchant 2
4006384 2027061 2027061 plaintiff Leke John (legal representative) 626200 626200 Leke, John, of Poole, ship master, executors of 0
4006387 2027061 2027061 defendant Grene William merchant 626200 626200 Grene, William, of Poole, merchant 1
4006388 2027061 2027061 defendant Davy John merchant 626200 626200 together with Davy, John, of Poole, merchant 2
4018573 2031374 2031374 defendant Bedelcome William merchant 626200 626200 Bedelcome, William, of Poole, merchant 0
4028300 2034776 2034776 plaintiff Constantyne William gent 626200 626200 Constantyne, William, of Poole, gent 0
4032881 2036415 2036415 defendant Bennett Ambrose mariner 626200 626200 Bennett, Ambrose, of Poole, mariner 1
4032920 2036421 2036421 defendant Bennet Ambrose mariner 626200 626200 Bennet, Ambrose, of Poole, mariner 1
4032927 2036422 2036422 defendant Reade William merchant 626200 626200 Reade, William, of Poole, merchant 0
4033388 2036594 2036594 plaintiff Grene David merchant 626200 626200 Grene, David, of Poole, merchant 0
4034207 2036901 2036901 plaintiff Hancock John merchant 626200 626200 Hancock, John, of Poole, merchant 0
4034631 2037062 2037062 defendant Grene William merchant 626200 626200 Grene, William, of Poole, merchant 0
4036946 2037889 2037889 defendant Bennett Ambrose merchant 626200 626200 Bennett, Ambrose, of Poole, merchant 0
4038226 2038306 2038306 defendant Coxe Peter, senior merchant 626200 626200 Coxe, Peter, senior, of Poole, merchant 0
4038452 2038390 2038390 plaintiff Laver William merchant 626200 626200 Laver, William, of Poole, merchant 0
4039892 2038889 2038889 plaintiff Maryet William merchant 626200 626200 Maryet, William, of Poole, merchant 0
4040141 2038977 2038977 defendant Grene William merchant 626200 626200 Grene, William, of Poole, merchant 1
4040144 2038978 2038978 defendant Grene William merchant 626200 626200 Grene, William, of Poole, merchant 1
4040817 2039208 2039208 defendant Lacocke Walter yeoman 626200 626200 Lacocke, Walter, of Poole, yeoman 1
4043180 2040029 2040029 defendant ap George Robert merchant 626200 626200 ap George, Robert, of Poole, merchant 1
4044893 2040627 2040627 plaintiff Rogers John merchant 626200 626200 Rogers, John, of Poole, merchant 0
4044895 2040628 2040628 plaintiff Rogers John merchant 626200 626200 Rogers, John, of Poole, merchant 0
4044897 2040629 2040629 plaintiff Rogers John merchant 626200 626200 Rogers, John, of Poole, merchant 0
4044898 2040629 2040629 plaintiff Gedyn Peter merchant 626200 626200 Gedyn, Peter, of Poole, merchant 1
4044900 2040630 2040630 plaintiff Rogers John merchant 626200 626200 Rogers, John, of Poole, merchant 0
4044901 2040630 2040630 plaintiff Godyn Peter merchant 626200 626200 Godyn, Peter, of Poole, merchant 1
4077641 2052291 2052291 defendant ap Roger Hugh Lloyd gent 626200 626200 ap Roger, Hugh Lloyd, of Poole, gent 1
4077642 2052291 2052291 defendant George Robert glover 626200 626200 George, Robert, of Poole, glover 2
4077643 2052291 2052291 defendant ap David Robert yeoman 626200 626200 ap David, Robert, of Poole, yeoman 3
4095868 2058856 2058856 defendant Hancocke John merchant 626200 626200 Hancocke, John, of Poole, merchant 0
4095869 2058856 2058856 defendant Mereat William merchant 626200 626200 Mereat, William, of Poole, merchant 1
4107199 2062871 2062871 defendant Spiller John gent 626200 626200 Spiller, John, of Poole, gent 0
4115368 2065787 2065787 defendant Bennett Thomas merchant 626200 626200 Bennett, Thomas, of Poole, merchant 2
4115369 2065787 2065787 defendant Bennett John merchant 626200 626200 Bennett, John, of Poole, merchant 3
4115391 2065792 2065792 defendant Stanley Stephen mariner 626200 626200 Stanley, Stephen, of Poole, mariner 1
4115396 2065793 2065793 defendant Rose Christopher merchant 626200 626200 Rose, Christopher, of Poole, merchant 2
4127502 2070131 2070131 defendant Laycocke Walter yeoman 626200 626200 Laycocke, Walter, of Poole, yeoman 1
4127830 2070243 2070243 defendant Watkyns Humphrey gent 626200 626200 Watkyns, Humphrey, of Poole, or of Shaftsbury, gent 0
4144564 2076258 2076258 defendant Goddard John (legal representative) 626200 626200 Goddard, John, of Poole, merchant, administratrix of 1
4150853 2078431 2078431 defendant Laycocke Walter yeoman 626200 626200 Laycocke, Walter, of Poole, yeoman 1
4152670 2079046 2079046 defendant Howse Denis merchant 626200 626200 Howse, Denis, of Poole, merchant 1
4159863 2081516 2081516 defendant Lambert Thomas mariner 626200 626200 Lambert, Thomas, of Poole, mariner 1
4167527 2084136 2084136 defendant Laycocke Walter yeoman 626200 626200 Laycocke, Walter, of Poole, yeoman 0
4173250 2086103 2086103 defendant Griffith Richard gent 626200 626200 Griffith, Richard, of Poole, or of Tydden Prede, Montgomery, gent 0
4175485 2086899 2086899 defendant Laycocke Walter yeoman 626200 626200 Laycocke, Walter, of Poole, yeoman 1
4175637 2086949 2086949 defendant Gregorye Robert merchant 626200 626200 Gregorye, Robert, of Poole, or of Waymouth & Melcombe Regis, Dorset, merchant 0
4198082 2094876 2094876 defendant Barrett Edward merchant 626200 626200 Barrett, Edward, of Poole, merchant 0
4198770 2095131 2095131 defendant Laycocke Walter yeoman 626200 626200 Laycocke, Walter, of Poole, yeoman 1
4199674 2095436 2095436 defendant Watkyns Humphrey gent 626200 626200 Watkyns, Humphrey, of Poole, gent 3
4231090 2106375 2106375 defendant Grene David merchant 626200 626200 Grene, David, of Poole, merchant 0
4236611 2108379 2108379 defendant Poole Henry esq 626200 626200 Poole, Henry, of Poole, esq 0
4252735 2113901 2113901 defendant Laycock Walter yeoman 626200 626200 Laycock, Walter, of Poole, yeoman 0
4252736 2113901 2113901 defendant Laycock Francis yeoman 626200 626200 Laycock, Francis, of Poole, yeoman 1
4252737 2113901 2113901 defendant Thomplinson Francis yeoman 626200 626200 Thomplinson, Francis, of Poole, yeoman 2
4252738 2113901 2113901 defendant Hobson William husbandman 626200 626200 Hobson, William, of Poole, husbandman 3
4312812 2134610 2134610 defendant Tymbrell Richard husbandman 626200 626200 Tymbrell, Richard, of Poole, husbandman 1
4313695 2134896 2134896 defendant Poole Edward gent 626200 626200 Poole, Edward, of Poole, gent 1
4315151 2135414 2135414 defendant Perris John husbandman 626200 626200 Perris, John, of Poole, husbandman 0
4323255 2138194 2138194 defendant Tymbrell Richard yeoman 626200 626200 Tymbrell, Richard, of Poole, yeoman 1
4323651 2138325 2138325 defendant Myller Richard mariner 626200 626200 Myller, Richard, of Poole, mariner 0
4395661 2163135 2163135 defendant Jones Susan spinster 626200 626200 Jones, Susan, of Poole, spinster 2
4488444 2197105 2197105 defendant Breton Peter   626200 626200 Breton, Peter, of Poole 0
4511202 2203948 2203948 defendant Cok John   626200 626200 Cok, John, of Poole 4
4587297 2227435 2227435 defendant Canewey Thomas   626200 626200 Canewey, Thomas, of Poole 0
4587298 2227435 2227435 defendant Hogges John   626200 626200 Hogges, John, of Poole 1
4595896 2229972 2229972 defendant Hay Robert   626200 626200 Hay, Robert, of Poole 0
4602882 2232115 2232115 defendant Andrewe Robert   626200 626200 Andrewe, Robert, of Poole 0
4695355 2264027 2264027 defendant Fisssher John   626200 626200 Fisssher, John, of Poole 6
4852913 2312331 2312331 defendant Rede Robert dyer 626200 626200 Rede, Robert, of Poole, dyer 0
5005357 2358470 2358470 defendant White William merchant 626200 626200 White, William, of Poole, merchant 0
5005358 2358470 2358470 defendant Webbe Thomas merchant 626200 626200 Webbe, Thomas, of Poole, merchant 1
5038524 2368163 2368163 defendant Fyssher William butcher 626200 626200 Fyssher, William, of Poole, butcher 2
5045041 2370151 2370151 plaintiff Inye or Juye Roger esq 626200 626200 Inye or Juye, Roger, of Poole, esq 0
5049430 2371465 2371465 plaintiff Spatard John merchant 626200 626200 Spatard, John, of Poole, merchant 0
5049431 2371465 2371465 defendant Webbe Thomas yeoman 626200 626200 Webbe, Thomas, of Poole, yeoman 0
5119341 2392080 2392080 defendant Batayle Peter mariner 626200 626200 Batayle, Peter, of Poole,mariner 0
5139743 2398100 2398100 plaintiff Spadard John merchant 626200 626200 Spadard, John, of Poole, merchant 0
5142373 2398891 2398891 plaintiff Whyte William merchant 626200 626200 Whyte, William, of Poole, merchant 0
5142374 2398891 2398891 defendant Bayly Ralph husbandman 626200 626200 Bayly, Ralph, of Poole, husbandman 0
5157681 2403377 2403377 defendant Lypman John husbandman 626200 626200 Lypman, John, of Poole, husbandman 0
5157682 2403377 2403377 defendant Batayle Peter husbandman 626200 626200 Batayle, Peter, of Poole, husbandman 1
5157684 2403377 2403377 defendant Lambert Robert merchant 626200 626200 Lambert, Robert, of Poole, merchant 3
5175412 2408501 2408501 plaintiff Spadard John merchant 626200 626200 Spadard, John, of Poole, merchant 0
5178639 2409467 2409467 plaintiff Baker Richard merchant 626200 626200 Baker, Richard, of Poole, merchant 0
5197079 2414891 2414891 defendant Johnson Robert mariner 626200 626200 Johnson, Robert, of Poole, mariner 0
5200079 2415773 2415773 plaintiff Whytt William merchant 626200 626200 Whytt, William, of Poole, merchant 0
5200080 2415773 2415773 defendant Bayly Ralph husbandman 626200 626200 Bayly, Ralph, of Poole, husbandman 0
5271052 2436629 2436629 plaintiff Franke John merchant 626200 626200 Franke, John, of Poole, merchant 0
5271058 2436630 2436630 defendant Lambert Robert merchant 626200 626200 Lambert, Robert, of Poole, merchant 1
5271061 2436630 2436630 defendant Sleywryght alias Veryer John husbandman 626200 626200 Sleywryght alias Veryer, John, of Poole, husbandman 4
5275457 2437891 2437891 plaintiff Spatard John   626200 626200 Spatard, John, of Poole 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);