names

337 rows where place_id = 604617

✎ 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
3658639 1912957 1912957 defendant Quadlyng John butcher 604617 604617 Quadlyng, John, of Southwark, butcher 0
3666559 1915479 1915479 defendant Everyngham John water man 604617 604617 Everyngham, John, of Southwark, water man 1
3666560 1915479 1915479 defendant Byngley Richard   604617 604617 Byngley, Richard, of Southwark, ship wright 2
3672370 1917361 1917361 defendant Magior Nicholas clerk 604617 604617 Magior, Nicholas, of Southwark, clerk 1
3681962 1920462 1920462 defendant Hogell John butcher 604617 604617 Hogell, John, of Southwark, butcher 2
3710250 1929522 1929522 plaintiff Scragge John leather seller 604617 604617 Scragge, John, of Southwark, leather seller 0
3741310 1939147 1939147 defendant Mongomery Thomas yeoman 604617 604617 Mongomery, Thomas, of Southwark, yeoman 0
3773921 1949559 1949559 defendant Rutlond Richard innholder 604617 604617 Rutlond, Richard, of Southwark, innholder 0
3784118 1952816 1952816 plaintiff Lynney John gent 604617 604617 Lynney, John, of Southwark, gent 0
3791647 1955230 1955230 defendant Rutlond Richard innholder 604617 604617 Rutlond, Richard, of Southwark, innholder 0
3833159 1968301 1968301 defendant Markes Alexander baker 604617 604617 Markes, Alexander, of Southwark, baker 0
3843452 1971490 1971490 defendant Copwod Ralph skinner 604617 604617 (Copwod, Ralph, of Southwark, skinner 1
3843455 1971490 1971490 defendant Kellett Margaret widow 604617 604617 Kellett, Margaret, of Southwark, widow 4
3843479 1971497 1971497 defendant Kellett Margaret widow 604617 604617 (Kellett, Margaret, of Southwark, widow 1
3847868 1972911 1972911 defendant Carewe Gavin esq 604617 604617 Carewe, Gavin, of Southwark, esq 0
3885908 1985543 1985543 defendant Boulton Gabriel cooper 604617 604617 Boulton, Gabriel, of Southwark, cooper 0
3887132 1985961 1985961 defendant Cocke John, senior (legal representative) 604617 604617 Cocke, John, senior, of Southwark, leatherseller, administrator of 0
3887133 1985961 1985961 defendant Cockes John   604617 604617 Cockes, John, of Southwark, parchment maker 1
3895181 1988595 1988595 defendant Busshell Ralph miller 604617 604617 Busshell, Ralph, of Southwark, miller 0
3898661 1989760 1989760 defendant Curson Robert gent 604617 604617 Curson, Robert, of Southwark, gent 0
3901415 1990697 1990697 defendant Cockys John   604617 604617 Cockys, John, of Southwark, parchment maker 0
3902936 1991211 1991211 defendant Jones William capper 604617 604617 Jones, William, of Southwark, capper 0
3902942 1991213 1991213 defendant Leper Thomas brewer 604617 604617 Leper, Thomas, of Southwark, brewer 0
3902952 1991216 1991216 defendant Holme Thomas gent 604617 604617 Holme, Thomas, of Southwark, gent 0
3907086 1992659 1992659 plaintiff Norman John tailor 604617 604617 Norman, John, of Southwark, tailor 0
3910080 1993677 1993677 defendant Cokke John leatherseller 604617 604617 Cokke, John, of Southwark, leatherseller 0
3917672 1996266 1996266 defendant Cokkys John leather seller 604617 604617 Cokkys, John, of Southwark, leather seller 0
3957399 2009652 2009652 plaintiff Pight William tailor 604617 604617 Pight, William, of Southwark, tailor 0
3967877 2013391 2013391 plaintiff Cambell Christopher hosier 604617 604617 Cambell, Christopher, of Southwark, hosier 0
3971884 2014727 2014727 plaintiff Fletcher George hosier 604617 604617 Fletcher, George, of Southwark, hosier 0
3971886 2014728 2014728 plaintiff Fletcher George hosier 604617 604617 Fletcher, George, of Southwark, hosier 0
3975815 2016104 2016104 defendant Grantham Hugh tailor 604617 604617 Grantham, Hugh, of Southwark, tailor 0
3977324 2016641 2016641 plaintiff Leke Henry, senior (legal representative) 604617 604617 Leke, Henry, senior, of Southwark, beer brewer, executor of, 1
3979099 2017274 2017274 defendant Baker Margaret widow 604617 604617 Baker, Margaret, of Southwark, widow 0
3980313 2017728 2017728 defendant Holdell Valentine haberdasher 604617 604617 Holdell, Valentine, of Southwark, haberdasher 0
3980762 2017880 2017880 defendant Smyth John butcher 604617 604617 Smyth, John, of Southwark, butcher 1
3982172 2018386 2018386 defendant Warde Michael yeoman 604617 604617 Warde, Michael, of Southwark, or of St Mary Magdalene, Surrey, yeoman 0
3985840 2019699 2019699 defendant Mowll alias Aylyarde Henry joiner 604617 604617 Mowll alias Aylyarde, Henry, of Southwark, joiner 0
3987677 2020340 2020340 defendant Hannell Henry tailor 604617 604617 Hannell, Henry, of Southwark, tailor 0
3987678 2020340 2020340 defendant Kyng John laborer 604617 604617 Kyng, John, of Southwark, laborer 1
3987679 2020340 2020340 defendant Bacon William laborer 604617 604617 Bacon, William, of Southwark, laborer 2
3987680 2020340 2020340 defendant Man Mathew laborer 604617 604617 Man, Mathew, of Southwark, laborer 3
3987681 2020340 2020340 defendant Moore Alexander dyer 604617 604617 Moore, Alexander, of Southwark, dyer 4
3987682 2020340 2020340 defendant West Thomas laborer 604617 604617 West, Thomas, of Southwark, laborer 5
3987683 2020340 2020340 defendant Tompson William   604617 604617 Tompson, William, of Southwark, hatband maker 6
3987684 2020340 2020340 defendant Wallett William firlder 604617 604617 Wallett, William, of Southwark, firlder 7
3990627 2021400 2021400 plaintiff Blancharde Alexander joiner 604617 604617 Blancharde, Alexander, of Southwark, joiner 0
3991488 2021710 2021710 defendant Smythe John   604617 604617 Smythe, John, of Southwark, ale brewer 0
3993921 2022576 2022576 defendant Garner Anthony Master of Arts 604617 604617 Garner, Anthony, of Southwark, clerk, Master of Arts 0
3998543 2024218 2024218 plaintiff Fletcher George hosier 604617 604617 Fletcher, George, of Southwark, hosier 0
3998545 2024219 2024219 plaintiff Fletcher George hosier 604617 604617 Fletcher, George, of Southwark, hosier 0
4001844 2025433 2025433 plaintiff Harryson Nicholas   604617 604617 Harryson, Nicholas, of Southwark St Savior, shipwright 0
4002233 2025583 2025583 plaintiff Heather John brother in law of John 604617 604617 Heather, John, of Southwark, butcher, brother in law of John 0
4003574 2026041 2026041 defendant Holleby Nicholas   604617 604617 Holleby, Nicholas, of Southwark St Savior, shipwright 1
4004275 2026309 2026309 defendant Tottye George yeoman 604617 604617 Tottye, George, of Southwark, yeoman 0
4011020 2028715 2028715 defendant Johnson John shoemaker 604617 604617 Johnson, John, of Southwark, shoemaker 0
4012173 2029076 2029076 defendant Ryche Henry yeoman 604617 604617 Ryche, Henry, of Southwark, or of London, yeoman 1
4012527 2029202 2029202 defendant Walton John or of London, grocer 604617 604617 Walton John, of Southwark, or of London, grocer 1
4014963 2030067 2030067 defendant Sterne Felix draper 604617 604617 Sterne, Felix, of Southwark, innholder, or of London, draper 1
4016456 2030589 2030589 defendant Hall Richard fellmonger 604617 604617 Hall, Richard, of Southwark, or of St Mary Magdalene, Barmondsey, Surrey, fellmonger 4
4016751 2030697 2030697 defendant Durram Elizabeth spinster 604617 604617 Durram, Elizabeth, of Southwark, spinster 0
4016755 2030698 2030698 defendant Gumporte Nicholas yeoman 604617 604617 Gumporte, Nicholas, of Southwark, yeoman 1
4016757 2030699 2030699 defendant Bates Thomas haberdasher 604617 604617 Bates, Thomas, of Southwark, haberdasher 0
4016758 2030699 2030699 defendant Hannell Henry tailor 604617 604617 Hannell, Henry, of Southwark, tailor 1
4016759 2030699 2030699 defendant Kynge John laborer 604617 604617 Kynge, John, of Southwark, laborer 2
4016760 2030699 2030699 defendant Bacon William laborer 604617 604617 Bacon, William, of Southwark, laborer 3
4016761 2030699 2030699 defendant Man Mathew laborer 604617 604617 Man, Mathew, of Southwark, laborer 4
4016762 2030699 2030699 defendant Moore Alexander dyer 604617 604617 Moore, Alexander, of Southwark, dyer 5
4016763 2030699 2030699 defendant West Thomas laborer 604617 604617 West, Thomas, of Southwark, laborer 6
4016764 2030699 2030699 defendant Tompson William   604617 604617 Tompson, William, of Southwark, hatband maker 7
4016765 2030699 2030699 defendant Wallett William girdler 604617 604617 Wallett, William, of Southwark, girdler 8
4016766 2030699 2030699 defendant Dawson George laborer 604617 604617 Dawson, George, of Southwark, laborer 9
4016767 2030699 2030699 defendant jones John laborer 604617 604617 jones, John, of Southwark, laborer 10
4016768 2030699 2030699 defendant Averye John weaver 604617 604617 Averye, John, of Southwark, weaver 11
4016771 2030700 2030700 defendant Durram Elizabeth, junior spinster 604617 604617 Durram, Elizabeth, junior, of Southwark, spinster 0
4016780 2030703 2030703 defendant Bates Thomas haberdasher 604617 604617 Bates, Thomas, of Southwark, haberdasher 0
4016781 2030703 2030703 defendant Hannell Henry tailor 604617 604617 Hannell, Henry, of Southwark, tailor 1
4016782 2030703 2030703 defendant Kyng John laborer 604617 604617 Kyng, John, of Southwark, laborer 2
4016783 2030703 2030703 defendant Bacon William laborer 604617 604617 Bacon, William, of Southwark, laborer 3
4016784 2030703 2030703 defendant Man Mathew laborer 604617 604617 Man, Mathew, of Southwark, laborer 4
4016785 2030703 2030703 defendant Moore Alexander dyer 604617 604617 Moore, Alexander, of Southwark, dyer 5
4016786 2030703 2030703 defendant West Thomas laborer 604617 604617 West, Thomas, of Southwark, laborer 6
4016787 2030703 2030703 defendant Tompson WIlliam   604617 604617 Tompson, WIlliam, of Southwark, hatband maker 7
4016788 2030703 2030703 defendant Wallett William girdler 604617 604617 Wallett, William, of Southwark, girdler 8
4016789 2030703 2030703 defendant Dawson George laborer 604617 604617 Dawson, George, of Southwark, laborer 9
4016790 2030703 2030703 defendant Jones John laborer 604617 604617 Jones, John, of Southwark, laborer 10
4016791 2030703 2030703 defendant Averye John weaver 604617 604617 Averye, John, of Southwark, weaver 11
4016792 2030703 2030703 defendant Burde Agnes spinster 604617 604617 Burde, Agnes, of Southwark, spinster 12
4019430 2031682 2031682 plaintiff Waye Thomas yeoman 604617 604617 Waye, Thomas, of Southwark, yeoman 0
4019638 2031750 2031750 plaintiff Weblinge Wassell beer brewer 604617 604617 Weblinge, Wassell, of Southwark, beer brewer 0
4019641 2031751 2031751 defendant Willson John yeoman 604617 604617 Willson, John, of Southwark, yeoman 0
4019643 2031752 2031752 defendant Wylson John yeoman 604617 604617 Wylson, John, of Southwark, yeoman 0
4025138 2033652 2033652 defendant Marten Elizabeth widow 604617 604617 Marten, Elizabeth, of Southwark, widow 1
4025141 2033653 2033653 defendant Marten Elizabeth widow 604617 604617 Marten, Elizabeth, of Southwark, widow 1
4029035 2035028 2035028 defendant Westwraye Thomas brewer 604617 604617 Westwraye, Thomas, of Southwark, brewer 0
4030877 2035709 2035709 defendant Nelson William yeoman 604617 604617 Nelson, William, of Southwark, yeoman 2
4030880 2035710 2035710 defendant Willyams Elias haberdasher 604617 604617 Willyams, Elias, of Southwark, haberdasher 0
4030895 2035714 2035714 defendant Nelson William yeoman 604617 604617 Nelson, William, of Southwark, yeoman 2
4030910 2035719 2035719 defendant Williams Elias haberdasher 604617 604617 Williams, Elias, of Southwark, haberdasher 0
4031463 2035925 2035925 plaintiff Fletcher George hosier 604617 604617 Fletcher, George, of Southwark, hosier 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);