names

1,115 rows where place_id = 587948

✎ 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
3592908 1865401 1865401 defendant Tayllour Edmund mercer 587948 587948 Tayllour, Edmund, of Newerk, mercer 0
3592909 1865401 1865401 defendant Bryngest Andrew barker 587948 587948 Bryngest, Andrew, of Newerk, barker 1
3599055 1867340 1867340 defendant Howeden John mercer 587948 587948 Howeden, John, of Newerk, mercer 0
3599057 1867341 1867341 defendant Howeden John mercer 587948 587948 Howeden, John, of Newerk, mercer 0
3607761 1870077 1870077 defendant Deynys Thomas shoemaker 587948 587948 Deynys, Thomas, of Newerk, shoemaker 2
3617837 1873203 1873203 defendant Vicars William draper 587948 587948 Vicars, William, of Newerk, draper 0
3617857 1873208 1873208 defendant Turney Robert weaver 587948 587948 Turney, Robert, of Newerk, weaver 0
3618768 1873486 1873486 defendant Shawe John carrier 587948 587948 Shawe, John, of Newerk, carrier 1
3619776 1873760 1873760 plaintiff Johnson Robert glover 587948 587948 Johnson, Robert, of Newerk, glover 0
3619777 1873760 1873760 plaintiff Genen William draper 587948 587948 Genen, William, of Newerk, draper 1
3619778 1873760 1873760 plaintiff Haweby John smith 587948 587948 Haweby, John, of Newerk, smith 2
3619779 1873760 1873760 plaintiff Faweconer Richard draper 587948 587948 Faweconer, Richard, of Newerk, draper 3
3619780 1873760 1873760 defendant Smyth Thomas carver 587948 587948 Smyth, Thomas, of Newerk, carver 0
3619781 1873760 1873760 defendant Meryng Thomas esq 587948 587948 Meryng, Thomas, of Newerk, esq 1
3619782 1873760 1873760 defendant Smyth John clerk 587948 587948 Smyth, John, of Newerk, clerk 2
3620682 1874045 1874045 defendant Skelton William gent 587948 587948 Skelton, William, of Newerk, gent 3
3620683 1874045 1874045 defendant Hagh John yeoman 587948 587948 Hagh, John, of Newerk, yeoman 4
3620685 1874046 1874046 defendant Matson John yeoman 587948 587948 Matson, John, of Newerk, yeoman 0
3620686 1874046 1874046 defendant Masse William laborer 587948 587948 Masse, William, of Newerk, laborer 1
3620688 1874046 1874046 defendant Robson John weaver 587948 587948 Robson, John, of Newerk, weaver 3
3620689 1874046 1874046 defendant Stele William cordwainer 587948 587948 Stele, William, of Newerk, cordwainer 4
3620693 1874047 1874047 defendant Atkynson William shoemaker 587948 587948 Atkynson, William, of Newerk, shoemaker 2
3621093 1874153 1874153 defendant Unwyn John baker 587948 587948 Unwyn, John, of Newerk, baker 0
3621094 1874153 1874153 defendant Kele William baker 587948 587948 Kele, William, of Newerk, baker 1
3630738 1904437 1904437 defendant Savage Elizabeth widow 587948 587948 Savage, Elizabeth, of Newerk, widow 2
3630971 1904507 1904507 defendant Monk Richard fishmonger 587948 587948 Monk, Richard, of Newerk, fishmonger 0
3630972 1904508 1904508 plaintiff Freseby Thomas sherman 587948 587948 Freseby, Thomas, of Newerk, sherman 0
3630973 1904508 1904508 plaintiff Clerke Thomas mercer 587948 587948 Clerke, Thomas, of Newerk, mercer 1
3630974 1904508 1904508 plaintiff Thomson Nicholas   587948 587948 Thomson, Nicholas, of Newerk, wax chandler 2
3633089 1905161 1905161 plaintiff Jakson John (legal representative) 587948 587948 Jakson, John, of Newerk, chapman or fishmonger, executors of 0
3635020 1905752 1905752 defendant Spencer William butcher 587948 587948 Spencer, William, of Newerk, butcher 0
3636203 1906111 1906111 defendant Hall John mercer 587948 587948 Hall, John, of Newerk, mercer 0
3637078 1906396 1906396 defendant Slatter alias Kellet John yeoman 587948 587948 Slatter alias Kellet, John, of Newerk, yeoman 3
3637143 1906416 1906416 defendant Kellet alias Sklater Robert, junior yeoman 587948 587948 Kellet alias Sklater, Robert, junior, of Newerk, yeoman 0
3638398 1906830 1906830 defendant Gysyngwold Henry shoemaker 587948 587948 Gysyngwold, Henry, of Newerk, shoemaker 1
3644736 1908758 1908758 defendant Bolton William yeoman 587948 587948 Bolton, William, of Newerk, yeoman 3
3644738 1908758 1908758 defendant Savage Elizabeth widow 587948 587948 Savage, Elizabeth, of Newerk, widow 5
3661145 1913764 1913764 plaintiff Johnson William   587948 587948 Johnson, William, of Newerk 0
3662925 1914317 1914317 defendant Stables Christopher dyer 587948 587948 Stables, Christopher, of Newerk, dyer 0
3663342 1914458 1914458 defendant Gillys Henry husbandman 587948 587948 Gillys, Henry, of Newerk, husbandman 2
3667274 1915701 1915701 defendant Nutte Richard   587948 587948 Nutte, Richard, of Newerk, rough mason 0
3667816 1915875 1915875 defendant Jakson Andrew   587948 587948 Jakson, Andrew, of Newerk, fish monger 0
3668023 1915938 1915938 defendant Gyles Richard shoemaker 587948 587948 Gyles, Richard, of Newerk, shoemaker 0
3668025 1915938 1915938 defendant Ryall William yeoman 587948 587948 Ryall, William, of Newerk, yeoman 2
3669132 1916283 1916283 defendant Kechyn Richard glover 587948 587948 Kechyn, Richard, of Newerk, glover 0
3670883 1916860 1916860 defendant Bradshawe Thomas fisher 587948 587948 Bradshawe, Thomas, of Newerk, fisher 0
3672372 1917362 1917362 defendant Wodward Richard shoemaker 587948 587948 Wodward, Richard, of Newerk, shoemaker 0
3677981 1919157 1919157 defendant Watson Robert   587948 587948 Watson, Robert, of Newerk, tallow chandler 0
3677983 1919158 1919158 defendant Watson Robert   587948 587948 Watson, Robert, of Newerk, tallow chandler 0
3678216 1919241 1919241 defendant Wudward Richard shoemaker 587948 587948 Wudward, Richard, of Newerk, shoemaker 0
3682260 1920549 1920549 defendant Anderson William   587948 587948 Anderson, William, of Newerk, freemason 0
3682261 1920549 1920549 defendant Foster Andrew   587948 587948 Foster, Andrew, of Newerk, freemason 1
3682263 1920550 1920550 defendant Anderson William   587948 587948 Anderson, William, of Newerk, freemason 0
3682465 1920616 1920616 defendant Wylles John laborer 587948 587948 Wylles, John, of Newerk, laborer 0
3688837 1922668 1922668 defendant Gyles Richard shoemaker 587948 587948 Gyles, Richard, of Newerk, shoemaker 2
3692242 1923743 1923743 defendant Markam Elizabeth widow 587948 587948 Markam, Elizabeth, of Newerk, widow 0
3692243 1923743 1923743 defendant Sclater Isabel widow 587948 587948 Sclater, Isabel, of Newerk, widow 1
3695515 1924820 1924820 defendant Wyntford Margaret widow 587948 587948 Wyntford, Margaret, of Newerk, widow 0
3699420 1926042 1926042 defendant Holme Lawrence baker 587948 587948 Holme, Lawrence, of Newerk, baker 2
3704524 1927709 1927709 defendant Stephynson Thomas butcher 587948 587948 Stephynson, Thomas, of Newerk, butcher 0
3704525 1927709 1927709 defendant Stotterd Richard butcher 587948 587948 Stotterd, Richard, of Newerk, butcher 1
3706243 1928240 1928240 defendant Byrkys Richard fisher 587948 587948 Byrkys, Richard, of Newerk, fisher 1
3707659 1928695 1928695 defendant Everneby John glover 587948 587948 Everneby, John, of Newerk, glover 0
3712156 1930120 1930120 defendant Jakson Robert draper 587948 587948 (Jakson, Robert, of Newerk, draper 1
3715530 1931145 1931145 defendant Troughton Christopher fishmonger 587948 587948 Troughton, Christopher, of Newerk, fishmonger 1
3717485 1931755 1931755 defendant Pelle George yeoman 587948 587948 Pelle, George, of Newerk, yeoman 1
3717486 1931755 1931755 defendant Pelle George shoemaker 587948 587948 Pelle, George, of Newerk, shoemaker 2
3721807 1933092 1933092 plaintiff Lucas Richard   587948 587948 Lucas, Richard, of Newerk 0
3752344 1942657 1942657 defendant Nutte Bartholomew tiler 587948 587948 Nutte, Bartholomew, of Newerk, tiler 0
3752345 1942657 1942657 defendant Tayllour Robert tiler 587948 587948 Tayllour, Robert, of Newerk, tiler 1
3752346 1942657 1942657 defendant Walker Robert baker 587948 587948 Walker, Robert, of Newerk, baker 2
3772310 1949026 1949026 defendant Huchonson Robert butcher 587948 587948 Huchonson, Robert, of Newerk, butcher 2
3858866 1976452 1976452 defendant Hogge Robert fletcher 587948 587948 Hogge, Robert, of Newerk, fletcher 0
3858867 1976452 1976452 defendant Parker John husbandman 587948 587948 Parker, John, of Newerk, husbandman 1
4413754 2169199 2169199 plaintiff Bryan Robert   587948 587948 Bryan, Robert, of Newerk 0
4413847 2169229 2169229 plaintiff Bury John de draper 587948 587948 Bury, John de, of Newerk, draper 0
4415314 2169686 2169686 defendant Botilesford William de   587948 587948 Botilesford, William de, of Newerk 3
4418522 2170669 2170669 defendant Haweys John   587948 587948 Haweys, John, of Newerk 0
4418940 2170790 2170790 plaintiff Assheballok John   587948 587948 Assheballok, John, of Newerk 0
4418941 2170790 2170790 defendant Hawys John   587948 587948 Hawys, John, of Newerk 0
4420077 2171181 2171181 plaintiff Boxworth Richard de   587948 587948 Boxworth, Richard de, of Newerk 0
4420570 2171336 2171336 plaintiff Bury John de draper 587948 587948 Bury, John de, of Newerk, draper 0
4420572 2171337 2171337 plaintiff Bury John de draper 587948 587948 Bury, John de, of Newerk, draper 0
4420574 2171338 2171338 plaintiff Bury John de draper 587948 587948 Bury, John de, of Newerk, draper 0
4423622 2172234 2172234 defendant Botilesford William de   587948 587948 Botilesford, William de, of Newerk 2
4424643 2172546 2172546 plaintiff Kilvyngton Henry de   587948 587948 Kilvyngton, Henry de, of Newerk 0
4424645 2172547 2172547 plaintiff Kilvyngton Henry de   587948 587948 Kilvyngton, Henry de, of Newerk 0
4425103 2172680 2172680 defendant Spycer Robert le   587948 587948 Spycer, Robert le, of Newerk 0
4425193 2172707 2172707 defendant Codyngton Robert de   587948 587948 Codyngton, Robert de, of Newerk 1
4425196 2172708 2172708 defendant Codyngton Robert de   587948 587948 Codyngton, Robert de, of Newerk 1
4425199 2172709 2172709 defendant Codyngton Robert de   587948 587948 Codyngton, Robert de, of Newerk 1
4426848 2173216 2173216 defendant Kaysor James   587948 587948 Kaysor, James, of Newerk 0
4427270 2173361 2173361 defendant Tiryngton Katherine de   587948 587948 Tiryngton, Katherine de, of Newerk, wife of Richard 0
4430313 2174266 2174266 plaintiff Wynthorp William de   587948 587948 Wynthorp, William de, of Newerk 0
4430776 2174382 2174382 plaintiff Assheballokes John   587948 587948 Assheballokes, John, of Newerk 0
4430777 2174382 2174382 defendant Hawys John   587948 587948 Hawys, John, of Newerk 0
4436759 2176238 2176238 defendant atte Grene John   587948 587948 atte Grene, John, of Newerk 1
4437622 2176523 2176523 defendant Haweys John   587948 587948 Haweys, John, of Newerk 0
4440022 2181802 2181802 defendant Slerpe John   587948 587948 Slerpe, John, of Newerk, vicar 0
4440872 2182061 2182061 defendant Walsheman Mathew   587948 587948 Walsheman, Mathew, of Newerk 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);