names

188 rows where place_id = 593673

✎ 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
3612888 1871679 1871679 defendant Berewell William yeoman 593673 593673 Berewell, William, of St Clement Danes, Middx, yeoman 0
3618071 1873276 1873276 defendant Berewell William yeoman 593673 593673 Berewell, William, of St Clement Danes, Middx, yeoman 0
3629208 1904004 1904004 defendant Torkenton John capper 593673 593673 Torkenton, John, of St Clement Danes, Middx, capper 1
3694275 1924413 1924413 defendant Lorkyn John butcher 593673 593673 Lorkyn, John, of St Clement Danes, Middx, butcher 0
3708605 1928991 1928991 defendant Newam Edward hosier 593673 593673 Newam, Edward, of St Clement Danes, Middx, hosier 1
3779091 1951186 1951186 defendant White William butcher 593673 593673 (White, William, of St Clement Danes, Middx, butcher 1
3781312 1951896 1951896 defendant Murk Richard gent 593673 593673 Murk, Richard, of St Clement Danes, Middx, gent 2
3796187 1956675 1956675 defendant Whyte William butcher 593673 593673 (Whyte, William, of St Clement Danes, Middx, butcher 1
3888782 1986499 1986499 defendant Marshall John tailor 593673 593673 Marshall, John, of St Clement Danes, Middx, tailor 0
3889188 1986621 1986621 defendant Marshall John tailor 593673 593673 Marshall, John, of St Clement Danes, Middx, tailor 0
3960200 2010667 2010667 defendant Sterte John (legal representative) 593673 593673 Sterte, John, of St Clement Danes, Middx, gent, executors of 0
3966515 2012923 2012923 defendant Burnell Thomas yeoman 593673 593673 Burnell, Thomas, of St Clement Danes, Middx, yeoman 0
3983337 2018813 2018813 defendant Cranygh Burchard   593673 593673 Cranygh, Burchard, of St Clement Danes, Middx, doctor of medicine 0
3993184 2022308 2022308 plaintiff Carre Robert innholder 593673 593673 Carre, Robert, of St Clement Danes, Middx, innholder 0
3998580 2024230 2024230 plaintiff Fletcher William cooper 593673 593673 Fletcher, William, of St Clement Danes, Middx, cooper 0
4003068 2025861 2025861 defendant Hearne Henry tailor 593673 593673 Hearne, Henry, of St Clement Danes, Middx, tailor 2
4004128 2026249 2026249 plaintiff Hyll William   593673 593673 Hyll, William, of St Clement Danes, Middx, purse maker 0
4031499 2035933 2035933 plaintiff Fletcher William cooper 593673 593673 Fletcher, William, of St Clement Danes, Middx, cooper 0
4038720 2038481 2038481 defendant Lumkyn John yeoman 593673 593673 Lumkyn, John, of St Clement Danes, Middx, yeoman 5
4038732 2038482 2038482 defendant Lumkyn John yeoman 593673 593673 Lumkyn, John, of St Clement Danes, Middx., yeoman 5
4056052 2044549 2044549 plaintiff Bottell John spurrier 593673 593673 Bottell, John, of St Clement Danes, Middx, spurrier 0
4062927 2047041 2047041 defendant Walton Roger merchant tailor 593673 593673 Walton, Roger, of St Clement Danes, Middx, surgeon, or of London, merchant tailor 1
4064389 2047541 2047541 plaintiff Gumbersall Richard mercer 593673 593673 Gumbersall, Richard, of St Clement Danes, Middx, mercer 0
4111936 2064518 2064518 defendant Peasinge Geoffrey gent 593673 593673 Peasinge, Geoffrey, of St Clement Danes, Middx, gent 3
4134430 2072644 2072644 defendant Somerford Edward yeoman 593673 593673 Somerford, Edward, of St Clement Danes, Middx, yeoman 0
4138781 2074241 2074241 defendant Carre Robert innholder 593673 593673 Carre, Robert, of St Clement Danes, Middx, innholder 0
4155889 2080138 2080138 defendant Grenewaye John   593673 593673 Grenewaye, John, of St Clement Danes, Middx, tailor, administrators of 1
4168999 2084650 2084650 defendant Trollopp Jerome gent 593673 593673 Trollopp, Jerome, of St Clement Danes, Middx, gent 3
4188015 2091309 2091309 defendant Nevile Alexander gent 593673 593673 Nevile, Alexander, of St Clement Danes, Middx, gent 0
4190401 2092180 2092180 defendant Herne or Heron Francis gent 593673 593673 Herne or Heron, Francis, of St Clement Danes, Middx, or of London, gent 0
4191478 2092587 2092587 defendant Ellis Thomas shoemaker 593673 593673 Ellis, Thomas, of St Clement Danes, Middx, shoemaker 2
4192767 2093030 2093030 defendant Berry Thomas tailor 593673 593673 Berry, Thomas, of St Clement Danes, Middx, tailor 0
4192770 2093031 2093031 defendant Berry Thomas yeoman 593673 593673 Berry, Thomas, of St Clement Danes, Middx, yeoman 0
4192773 2093032 2093032 defendant Smyth Thomas yeoman 593673 593673 Smyth, Thomas, of St Clement Danes, Middx, yeoman 0
4192775 2093033 2093033 defendant Smythe Thomas yeoman 593673 593673 Smythe, Thomas, of St Clement Danes, Middx, yeoman 0
4193841 2093410 2093410 defendant Miller David yeoman 593673 593673 (Miller, David, of St Clement Danes, Middx, yeoman 7
4194156 2093508 2093508 defendant Herne Henry merchant tailor 593673 593673 Herne, Henry, of St Clement Danes, Middx, yeoman, merchant tailor 0
4200927 2095880 2095880 defendant Peirson John scrivener 593673 593673 Peirson, John, of St Clement Danes, Middx, scrivener 1
4224830 2104151 2104151 defendant Cecyll William esq 593673 593673 Cecyll, William, of St Clement Danes, Middx, esq 0
4233158 2107105 2107105 defendant Hall John yeoman 593673 593673 Hall, John, of St Clement Danes, Middx, yeoman 0
4242094 2110350 2110350 defendant Berrye Thomas tailor 593673 593673 Berrye, Thomas, of St Clement Danes, Middx, tailor 0
4247339 2112087 2112087 defendant Berry Thomas tailor 593673 593673 Berry, Thomas, of St Clement Danes, Middx, tailor 0
4250055 2113001 2113001 defendant Cecyll William esq 593673 593673 Cecyll, William, of St Clement Danes, Middx, esq 0
4259017 2115986 2115986 defendant Wasse William tailor 593673 593673 Wasse, William, of St Clement Danes, Middx, tailor 1
4259643 2116201 2116201 defendant Daye Angel   593673 593673 Daye, Angel, of St Clement Danes, Middx, gent, attorney 0
4260406 2116447 2116447 defendant Grene John butcher 593673 593673 Grene, John, of St Clement Danes, Middx, butcher 0
4266222 2118342 2118342 defendant Wasse William tailor 593673 593673 Wasse, William, of St Clement Danes, Middx, tailor 0
4267906 2118901 2118901 defendant Gibs alias Hanes Robert gent 593673 593673 Gibs alias Hanes, Robert, of St Clement Danes, Middx, gent 0
4289258 2126215 2126215 defendant Berry Thomas tailor 593673 593673 Berry, Thomas, of St Clement Danes, Middx, tailor 0
4289287 2126226 2126226 defendant Jordayne Jasper yeoman 593673 593673 Jordayne, Jasper, of St Clement Danes, Middx, yeoman 2
4292844 2127504 2127504 defendant Parson Henry   593673 593673 Parson, Henry, of St Clement Danes, Middx, white baker 0
4292950 2127541 2127541 defendant Vernon Francis gentlewoman 593673 593673 Vernon, Francis, of St Clement Danes, Middx, spinster, gentlewoman 2
4301468 2130630 2130630 defendant Marybeate Elias yeoman 593673 593673 Marybeate, Elias, of St Clement Danes, Middx, yeoman 0
4301613 2130681 2130681 defendant Emery Thomas   593673 593673 Emery, Thomas, of St Clement Danes, Middx, yeoman, or of le Strand, "silkraser" 0
4303977 2131524 2131524 defendant Raphe John tailor 593673 593673 Raphe, John, of St Clement Danes, Middx, tailor 0
4304607 2131745 2131745 defendant Wass William tailor 593673 593673 Wass, William, of St Clement Danes, Middx, tailor 3
4304610 2131746 2131746 defendant Rogers William tailor 593673 593673 Rogers, William, of St Clement Danes, Middx, tailor 1
4306020 2132244 2132244 defendant Benston Hugh esq 593673 593673 Benston, Hugh, of St Clement Danes, Middx, esq 2
4306045 2132253 2132253 defendant Rice William tailor 593673 593673 Rice, William, of St Clement Danes, Middx, tailor 1
4309896 2133617 2133617 defendant Berrye Thomas tailor 593673 593673 Berrye, Thomas, of St Clement Danes, Middx, tailor 0
4319862 2137053 2137053 defendant Brassenden Roger butcher 593673 593673 Brassenden, Roger, of St Clement Danes, Middx, butcher 3
4323124 2138148 2138148 defendant Riche James gent 593673 593673 Riche, James, of St Clement Danes, Middx, gent 0
4324297 2138525 2138525 defendant Jackson Thomas tailor 593673 593673 Jackson, Thomas, of St Clement Danes, Middx, tailor 1
4325216 2138811 2138811 defendant Parson Henry   593673 593673 Parson, Henry, of St Clement Danes, Middx, white baker, citi<en of London 0
4326002 2139069 2139069 defendant Emerye Thomas cutler 593673 593673 Emerye, Thomas, of St Clement Danes, Middx, cutler 0
4326414 2139199 2139199 defendant Hornewell Richard tailor 593673 593673 Hornewell, Richard, of St Clement Danes, Middx, tailor 0
4329954 2140318 2140318 defendant Kidgell John cutler 593673 593673 Kidgell, John, of St Clement Danes, Middx, cutler 2
4334698 2141872 2141872 defendant Phillipps John tailor 593673 593673 Phillipps, John, of St Clement Danes, Middx, tailor 2
4337590 2142891 2142891 defendant Macon Edward cutler 593673 593673 Macon, Edward, of St Clement Danes, Middx, cutler 0
4339891 2143723 2143723 defendant Bylford Richard gent 593673 593673 Bylford, Richard, of St Clement Danes, Middx, or of London, gent 1
4346735 2146112 2146112 defendant Hill George saddler 593673 593673 Hill, George, of St Clement Danes, Middx, saddler 0
4353465 2148435 2148435 defendant Gomersall Richard mercer 593673 593673 (Gomersall, Richard, of St Clement Danes, Middx, mercer 1
4358139 2150088 2150088 defendant Stockham Christopher tailor 593673 593673 Stockham, Christopher, of St Clement Danes, Middx, tailor 2
4360805 2151031 2151031 defendant Elbridge Walter   593673 593673 Elbridge, Walter, of St Clement Danes, Middx, bit maker 1
4363214 2151908 2151908 defendant Bylforde Richard gent 593673 593673 Bylforde, Richard, of St Clement Danes, Middx, gent 1
4366501 2153064 2153064 defendant Wrighte Thomas merchant tailor 593673 593673 Wrighte, Thomas, of St Clement Danes, Middx, merchant tailor 0
4366503 2153065 2153065 defendant Wrighte Thomas merchant tailor 593673 593673 Wrighte, Thomas, of St Clement Danes, Middx, tailor, or of London, merchant tailor 0
4371350 2154818 2154818 defendant Payne alias Edney Roger   593673 593673 Payne alias Edney, Roger, of St Clement Danes, Middx 0
4372584 2155267 2155267 defendant Tillesley Thomas tailor 593673 593673 Tillesley, Thomas, of St Clement Danes, Middx, tailor 0
4377254 2156939 2156939 defendant Gomersall Richard mercer 593673 593673 (Gomersall, Richard, of St Clement Danes, Middx, mercer 1
4380481 2158131 2158131 defendant Lee George gent 593673 593673 (Lee, George, of St Clement Danes, Middx, gent 1
4382744 2158934 2158934 defendant Wannell John tailor 593673 593673 Wannell, John, of St Clement Danes, Middx, tailor 2
4382997 2159027 2159027 defendant Stockham Christopher tailor 593673 593673 Stockham, Christopher, of St Clement Danes, Middx, tailor 0
4386398 2160130 2160130 defendant Macom Edward cutler 593673 593673 Macom, Edward, of St Clement Danes, Middx, cutler 0
4387551 2160477 2160477 defendant Williams Lawrence cordwainer 593673 593673 Williams, Lawrence, of St Clement Danes, Middx, cordwainer 1
4391883 2161910 2161910 defendant Wasse William tailor 593673 593673 Wasse, William, of St Clement Danes, Middx, tailor 0
4393454 2162411 2162411 defendant Holmead Richard tailor 593673 593673 Holmead, Richard, of St Clement Danes, Middx, tailor 1
4394053 2162612 2162612 defendant Stockham Christopher tailor 593673 593673 Stockham, Christopher, of St Clement Danes, Middx, tailor 0
4401766 2165187 2165187 defendant Price John   593673 593673 Price, John, of St Clement Danes, Middx 1
4402514 2165426 2165426 defendant Casson Francis haberdasher 593673 593673 Casson, Francis, of St Clement Danes, Middx, haberdasher 0
4404735 2166151 2166151 defendant Sympson Thomas yeoman 593673 593673 Sympson, Thomas, of St Clement Danes, Middx, yeoman 2
4404889 2166204 2166204 defendant Rogers William tailor 593673 593673 Rogers, William, of St Clement Danes, Middx, tailor 2
4405878 2166529 2166529 defendant Rogers William tailor 593673 593673 Rogers, William, of St Clement Danes, Middx, tailor 0
4407039 2166912 2166912 defendant Gomersall Richard mercer 593673 593673 (Gomersall, Richard, of St Clement Danes, Middx, mercer 1
4409513 2167777 2167777 defendant Howker Emma widow 593673 593673 Howker, Emma, of St Clement Danes, Middx, widow 3
4719401 2271412 2271412 defendant Wymbysshe John gent 593673 593673 together with Wymbysshe, John, of St Clement Danes, Middx, gent 1
4719404 2271413 2271413 defendant Wymbusshe John gent 593673 593673 Wymbusshe, John, of St Clement Danes, Middx, gent 1
4872705 2318415 2318415 defendant Holme Robert esq 593673 593673 Holme, Robert, of St Clement Danes, Middx, or of Bordeaux, esq 0
4890040 2323666 2323666 defendant Acton Thomas gent 593673 593673 Acton, Thomas, of St Clement Danes, Middx, gent 1
4890043 2323667 2323667 defendant Acton Thomas gent 593673 593673 Acton, Thomas, of St Clement Danes, Middx, gent 1

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);