names

125 rows where place_id = 593871

✎ 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
3613691 1871929 1871929 defendant Hereford John smith 593871 593871 Hereford, John, of Newbery, Berks, smith 4
3626328 1903092 1903092 defendant Weston Thomas chapman 593871 593871 Weston, Thomas, of Newbery, Berks, chapman 3
3633288 1905228 1905228 defendant Sare Thomas clerk 593871 593871 Sare, Thomas, of Newbery, Berks, clerk 4
3645165 1908895 1908895 defendant Andrews Johnm clothier 593871 593871 Andrews, Johnm, of Newbery, Berks, clothier 1
3651097 1910710 1910710 defendant Androwes John clothmaker 593871 593871 Androwes, John, of Newbery, Berks, clothmaker 0
3651101 1910711 1910711 defendant Saer Thomas clothman 593871 593871 Saer, Thomas, of Newbery, Berks, clothman 0
3663301 1914447 1914447 defendant Hode William smith 593871 593871 Hode, William, of Newbery, Berks, smith 1
3674254 1917989 1917989 defendant May John clothier 593871 593871 May, John, of Newbery, Berks, clothier 0
3679169 1919552 1919552 defendant Wylson Richard clothmaker 593871 593871 Wylson, Richard, of Newbery, Berks, clothmaker 3
3685735 1921696 1921696 defendant Freman John dyer 593871 593871 Freman, John, of Newbery, Berks, dyer 1
3685741 1921697 1921697 defendant Freman John dyer 593871 593871 Freman, John, of Newbery, Berks, dyer 1
3686831 1922040 1922040 defendant Drye John fuller 593871 593871 Drye, John, of Newbery, Berks, fuller 1
3704628 1927733 1927733 defendant Rexon Thomas clothmaker 593871 593871 Rexon, Thomas, of Newbery, Berks, clothmaker 4
3706728 1928390 1928390 defendant Tydder Elias chapman 593871 593871 Tydder, Elias, of Newbery, Berks, chapman 0
3708218 1928864 1928864 defendant Maye Nicholas clothmaker 593871 593871 Maye, Nicholas, of Newbery, berks, clothmaker 3
3723359 1933574 1933574 defendant Mayer Nicholas yeoman 593871 593871 Mayer, Nicholas, of Newbery, Berks, yeoman 1
3768207 1947696 1947696 defendant Hynd Thomas clothmaker 593871 593871 Hynd, Thomas, of Newbery, berks, clothmaker 0
3768213 1947697 1947697 defendant Hynd Thomas clothmaker 593871 593871 Hynd, Thomas, of Newbery, Berks, clothmaker 0
3773767 1949510 1949510 defendant Elys John yeoman 593871 593871 Elys, John, of Newbery, Berks, yeoman 0
3785121 1953134 1953134 defendant Sherpe Edward chapman 593871 593871 Sherpe, Edward, of Newbery, Berks, chapman 0
3785958 1953406 1953406 defendant Serpe Edward clothmaker 593871 593871 Serpe, Edward, of Newbery, Berks, clothmaker 0
3795061 1956319 1956319 defendant Shappe Edward clother 593871 593871 Shappe, Edward, of Newbery, Berks, clother 1
3795853 1956568 1956568 defendant Sharp Edward clothier 593871 593871 Sharp, Edward, of Newbery, Berks, clothier 0
3795856 1956569 1956569 defendant Sharpe Edward clothier 593871 593871 Sharpe, Edward, of Newbery, Berks, clothier 0
3819835 1964085 1964085 defendant Sharpe Edward clothman 593871 593871 Sharpe, Edward, of Newbery, Berks, clothman 0
3820829 1964405 1964405 defendant Freman John dyer 593871 593871 Freman, John, of Newbery, Berks, dyer 0
3856008 1975504 1975504 defendant Towes Thomas chapman 593871 593871 Towes, Thomas, of Newbery, Berks, chapman 1
3856059 1975520 1975520 defendant Towes Thomas chapman 593871 593871 Towes, Thomas, of Newbery, Berks, chapman 1
3863206 1977897 1977897 defendant Chamer John butcher 593871 593871 Chamer, John, of Newbery, Berks, butcher 0
3882996 1984578 1984578 defendant Boxford Philip chapman 593871 593871 Boxford, Philip, of Newbery, Berks, chapman 1
3889485 1986715 1986715 defendant Bonde Richard butcher 593871 593871 Bonde, Richard, of Newbery, Berks, butcher 3
3891200 1987324 1987324 plaintiff Knyght John gent 593871 593871 Knyght, John, of Newbery, Berks, gent 0
3907598 1992831 1992831 defendant Gosnall John clothman 593871 593871 Gosnall, John, of Newbery, Berks, clothman 0
3919471 1996845 1996845 defendant Soreche Robert clothman 593871 593871 Soreche, Robert, of Newbery, Berks, clothman 7
3919801 1996959 1996959 defendant Sorache Robert clothman 593871 593871 Sorache, Robert, of Newbery, Berks, clothman 7
3923057 1998015 1998015 defendant Willys John clothier 593871 593871 Willys, John, of Newbery, Berks, clothier 4
3927926 1999678 1999678 defendant Wynchecombe Thomas esq 593871 593871 Wynchecombe, Thomas, of Newbery, Berks, esq 0
3931785 2000934 2000934 defendant Wynchecombe Thomas gent 593871 593871 Wynchecombe, Thomas, of Newbery, Berks, gent 0
3932624 2001205 2001205 defendant Haynes John yeoman 593871 593871 Haynes, John, of Newbery, Berks, yeoman 2
3934837 2001952 2001952 defendant Wynchecombe Thomas gentleman 593871 593871 Wynchecombe, Thomas, of Newbery, Berks, gentleman 0
3955960 2009155 2009155 defendant Brewer John chandler 593871 593871 Brewer, John, of Newbery, Berks, chandler 0
3962081 2011318 2011318 defendant Kynge Robert gent 593871 593871 Kynge, Robert, of Newbery, Berks, gent 0
3972455 2014943 2014943 defendant Kyng Robert   593871 593871 Kyng, Robert, of Newbery, Berks, linen draper 1
3975681 2016053 2016053 plaintiff Hyde Roger yeoman 593871 593871 Hyde, Roger, of Newbery, Berks, yeoman 0
3980288 2017716 2017716 defendant Harmar Arthur clothier 593871 593871 Harmar, Arthur, of Newbery, Berks, clothier 0
4000107 2024805 2024805 defendant Ryppen John yeoman 593871 593871 Ryppen, John, of Newbery, Berks, yeoman 0
4000109 2024806 2024806 defendant Ryppen John yeoman 593871 593871 Ryppen, John, of Newbery, Berks, yeoman 0
4002832 2025780 2025780 defendant Bennett Edward haberdasher 593871 593871 Bennett, Edward, of Newbery, Berks, haberdasher 0
4002837 2025782 2025782 defendant Hynd Henry   593871 593871 Hynd, Henry, of Newbery, Berks, linnen draper 0
4008153 2027682 2027682 defendant Stugdon Richard chapman 593871 593871 Stugdon, Richard, of Newbery, Berks, chapman 0
4008155 2027683 2027683 defendant Sugdon Richard chapman 593871 593871 Sugdon, Richard, of Newbery, Berks, chapman 0
4010162 2028404 2028404 defendant Hawe Edward yeoman 593871 593871 Hawe, Edward, of Newbery, Berks, yeoman 2
4022563 2032793 2032793 plaintiff Arnold Thomas   593871 593871 Arnold, Thomas, of Newbery, Berks, linen draper 0
4025283 2033703 2033703 defendant Hynde Henry chapman 593871 593871 Hynde, Henry, of Newbery, Berks, chapman 0
4026713 2034198 2034198 defendant Coke Richard mercer 593871 593871 Coke, Richard, of Newbery, Berks, mercer 1
4026716 2034199 2034199 defendant Coke Richard mercer 593871 593871 Coke, Richard, of Newbery, Berks, mercer 1
4027803 2034593 2034593 plaintiff Cock Gabriel yeoman 593871 593871 Cock, Gabriel, of Newbery, Berks, yeoman 0
4027852 2034609 2034609 plaintiff Cockes Gabriel yeoman 593871 593871 Cockes, Gabriel, of Newbery, Berks, yeoman 0
4028153 2034718 2034718 defendant Kynge Robert yeoman 593871 593871 Kynge, Robert, of Newbery, Berks, yeoman 2
4028157 2034719 2034719 defendant Kynge Robert yeoman 593871 593871 Kynge, Robert, of Newbery, Berks, yeoman 2
4032960 2036434 2036434 defendant Ewen alias Butcher Richard butcher 593871 593871 Ewen alias Butcher, Richard, of Newbery, Berks, butcher 0
4032962 2036435 2036435 defendant Ewen alias Butcher Richard butcher 593871 593871 Ewen alias Butcher, Richard, of Newbery, Berks, butcher 0
4038347 2038354 2038354 defendant Boxsall Christopher chapman 593871 593871 Boxsall, Christopher, of Newbery, Berks, chapman 3
4057192 2044957 2044957 defendant Apryce Edward shoemaker 593871 593871 Apryce, Edward, of Newbery, Berks, shoemaker 0
4060384 2046115 2046115 defendant Peatye Henry chapman 593871 593871 Peatye, Henry, of Newbery, Berks, chapman 1
4061083 2046370 2046370 defendant Barnes Thomas mercer 593871 593871 Barnes, Thomas, of Newbery, Berks, mercer 2
4064044 2047422 2047422 defendant Cooke Robert chapman 593871 593871 Cooke, Robert, of Newbery, Berks, chapman 0
4065866 2048088 2048088 defendant Cooke Robert chapman 593871 593871 Cooke, Robert, of Newbery, Berks, chapman 0
4067146 2048548 2048548 defendant Deale Roger chapman 593871 593871 Deale, Roger, of Newbery, Berks, chapman 3
4070124 2049603 2049603 defendant Hynde Anne widow 593871 593871 Hynde, Anne, of Newbery, Berks, widow 1
4072873 2050593 2050593 defendant Warner Francis chapman 593871 593871 Warner, Francis, of Newbery, Berks, chapman 0
4077224 2052139 2052139 defendant Warner Francis chapman 593871 593871 Warner, Francis, of Newbery, Berks, chapman 1
4094349 2058319 2058319 defendant More James chapman 593871 593871 More, James, of Newbery, Berks, chapman 0
4101418 2060810 2060810 defendant Chamberlayne Brian clothier 593871 593871 Chamberlayne, Brian, of Newbery, Berks, clothier 0
4112269 2064647 2064647 defendant Warner Francis chapman 593871 593871 Warner, Francis, of Newbery, Berks, chapman 0
4126927 2069924 2069924 defendant Bawle Richard chapman 593871 593871 Bawle, Richard, of Newbery, Berks, chapman 0
4128591 2070517 2070517 defendant Kenton alias Mathewe Richard cordwainer 593871 593871 Kenton alias Mathewe, Richard, of Newbery, Berks, cordwainer 0
4133994 2072492 2072492 defendant Twyne William clothier 593871 593871 Twyne, William, of Newbery, Berks, clothier 1
4134218 2072562 2072562 defendant Hynd Henry mercer 593871 593871 Hynd, Henry, of Newbery, Berks, mercer 0
4134583 2072701 2072701 defendant Rippon William mercer 593871 593871 Rippon, William, of Newbery, Berks, mercer 0
4147637 2077313 2077313 defendant Leachpoole alias Chaundler John mercer 593871 593871 Leachpoole alias Chaundler, John, of Newbery, Berks, mercer 1
4154761 2079760 2079760 defendant Twyne Richard chapman 593871 593871 Twyne, Richard, of Newbery, Berks, chapman 1
4155199 2079912 2079912 defendant Nutting Thomas chapman 593871 593871 Nutting, Thomas, of Newbery, Berks, chapman 1
4158549 2081061 2081061 defendant Jase John clothier 593871 593871 Jase, John, of Newbery, Berks, clothier 0
4162286 2082369 2082369 defendant Cooke Robert chapman 593871 593871 Cooke, Robert, of Newbery, Berks, chapman 0
4162634 2082492 2082492 defendant Ryppon John yeoman 593871 593871 Ryppon, John, of Newbery, Berks, yeoman 0
4173410 2086157 2086157 defendant Chamberlen Brian clothier 593871 593871 Chamberlen, Brian, of Newbery, Berks, clothier 0
4183238 2089619 2089619 defendant Coxe Henry mercer 593871 593871 Coxe, Henry, of Newbery, Berks, mercer 0
4201918 2096216 2096216 defendant Mellyshe Edward clothier 593871 593871 Mellyshe, Edward, of Newbery, Berks, clothier 0
4202017 2096250 2096250 defendant Chamberlen Brian clothier 593871 593871 Chamberlen, Brian, of Newbery, Berks, clothier 0
4206278 2097743 2097743 defendant Winchecombe Thomas clothier 593871 593871 Winchecombe, Thomas, of Newbery, Berks, clothier 0
4207022 2098002 2098002 defendant Coxe Henry mercer 593871 593871 Coxe, Henry, of Newbery, Berks, mercer 0
4211775 2099673 2099673 defendant Roche Stephen chapman 593871 593871 Roche, Stephen, of Newbery, Berks, chapman 3
4233739 2107324 2107324 defendant Rippon William grocer 593871 593871 Rippon, William, of Newbery, Berks, grocer 0
4262143 2117013 2117013 defendant Parsons William gent 593871 593871 Parsons, William, of Newbery, Berks, gent 2
4262529 2117131 2117131 defendant Parsons William gent 593871 593871 Parsons, William, of Newbery, Berks, gent 2
4263430 2117430 2117430 defendant Coxe or Cock Henry mercer 593871 593871 Coxe or Cock, Henry, of Newbery, Berks, mercer 0
4265828 2118211 2118211 defendant Ryppon William grocer 593871 593871 Ryppon, William, of Newbery, Berks, grocer 0
4271984 2120198 2120198 defendant Dolman   chapman 593871 593871 Dolman, , of Newbery, Berks, chapman 0
4282920 2123927 2123927 defendant Pearse Thomas butcher 593871 593871 Pearse, Thomas, of Newbery, Berks, butcher 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);