names

106 rows where place_id = 600176

✎ 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
3640074 1907342 1907342 defendant Penton Richard mercer 600176 600176 Penton, Richard, of Andover, Hants, mercer 3
3650945 1910666 1910666 defendant Hause or Hanse Robert chapman 600176 600176 Hause or Hanse, Robert, of Andover, Hants, chapman 1
3656031 1912139 1912139 defendant Furner Henry chapman 600176 600176 Furner, Henry, of Andover, Hants, chapman 4
3690209 1923097 1923097 defendant Hause or Hanse Robert yeoman 600176 600176 Hause or Hanse, Robert, of Andover, Hants, yeoman 0
3726864 1934672 1934672 defendant Calley John gent 600176 600176 Calley, John, of Andover, hants, gent 0
3735406 1937310 1937310 defendant Sommer alias Forestall Robert husbandman 600176 600176 Sommer alias Forestall, Robert, of Andover, Hants, husbandman 1
3762243 1945837 1945837 defendant Hanse or Hause Robert chapman 600176 600176 Hanse or Hause, Robert, of Andover, Hants, chapman 0
3836518 1969327 1969327 defendant Reve Thomas chapman 600176 600176 Reve, Thomas, of Andover, Hants, chapman 1
3848638 1973157 1973157 defendant Garlond Hugh husbandman 600176 600176 Garlond, Hugh, of Andover, Hants, husbandman 2
3849232 1973352 1973352 defendant Pynner Richard chapman 600176 600176 Pynner, Richard, of Andover, Hants, chapman 1
3870038 1980222 1980222 defendant Inwood Thomas yeoman 600176 600176 Inwood, Thomas, of Andover, Hants, yeoman 1
3870045 1980223 1980223 defendant Inwood Thomas yeoman 600176 600176 Inwood, Thomas, of Andover, Hants, yeoman 1
3877941 1982867 1982867 defendant Gylbertt Richard mercer 600176 600176 Gylbertt, Richard, of Andover, Hants, mercer 0
3877944 1982868 1982868 defendant Gilbert Richard mercer 600176 600176 Gilbert, Richard, of Andover, Hants, mercer 0
3900148 1990274 1990274 defendant Woodward William yeoman 600176 600176 Woodward, William, of Andover, Hants, yeoman 0
3916918 1996024 1996024 defendant Wylson William yeoman 600176 600176 Wylson, William, of Andover, Hants, yeoman 0
3916922 1996025 1996025 defendant Wylson William yeoman 600176 600176 Wylson, William, of Andover, Hants, yeoman 0
3917685 1996272 1996272 defendant Bysshopp Thomas butcher 600176 600176 Bysshopp, Thomas, of Andover, Hants, butcher 0
3931511 2000840 2000840 defendant Rede alias Ryve Thomas chapman 600176 600176 Rede alias Ryve, Thomas, of Andover, Hants, chapman 0
3931995 2001002 2001002 defendant Andrewe Thomas tailor 600176 600176 Andrewe, Thomas, of Andover, Hants, tailor 1
3932739 2001250 2001250 defendant Eliott Richard chapman 600176 600176 Eliott, Richard, of Andover, Hants, chapman 0
3934706 2001904 2001904 defendant Browne Richard butcher 600176 600176 Browne, Richard, of Andover, Hants, butcher 0
3945610 2005540 2005540 defendant Payne Anthony yeoman 600176 600176 Payne, Anthony, of Andover, Hants, yeoman 2
3950001 2007082 2007082 defendant Browne Thomas yeoman 600176 600176 Browne, Thomas, of Andover, Hants, yeoman 0
3958604 2010081 2010081 defendant Pynder Robert tailor 600176 600176 Pynder, Robert, of Andover, Hants, tailor 1
3970534 2014295 2014295 defendant Martyn William   600176 600176 Martyn, William, of Andover, Hants, linen draper 0
3978269 2016980 2016980 defendant Jarvys Richard haberdasher 600176 600176 Jarvys, Richard, of Andover, Hants, haberdasher 3
3979675 2017486 2017486 defendant Martyn William mercer 600176 600176 Martyn, William, of Andover, Hants, mercer 0
3982677 2018573 2018573 defendant Martyn William mercer 600176 600176 Martyn, William, of Andover, Hants, mercer 0
3989207 2020879 2020879 defendant Rickman Stephen innholder 600176 600176 Rickman, Stephen, of Andover, Hants, innholder 0
4020259 2031966 2031966 defendant Knyght John yeoman 600176 600176 Knyght, John, of Andover, Hants, yeoman 0
4031620 2035972 2035972 plaintiff Forder alias Butler William   600176 600176 Forder alias Butler, William, of Andover, Hants, linen draper or merchant 0
4039793 2038847 2038847 defendant Hopkyns Peter glover 600176 600176 Hopkyns, Peter, of Andover, Hants, glover 0
4052478 2043307 2043307 defendant Gunter William gent 600176 600176 Gunter, William, of Andover, Hants, gent 0
4053008 2043506 2043506 defendant Payne Anthony chapman 600176 600176 Payne, Anthony, of Andover, Hants, chapman 1
4057509 2045062 2045062 plaintiff Butler Stephen ostler of the Bell in Andover 600176 600176 Butler, Stephen, of Andover, Hants, yeoman, ostler of the Bell in Andover 0
4066840 2048438 2048438 defendant Abbott Stephen chapman 600176 600176 Abbott, Stephen, of Andover, Hants, chapman 3
4070460 2049730 2049730 defendant Abbott John chapman 600176 600176 Abbott, John, of Andover, Hants, chapman 0
4075060 2051381 2051381 defendant Graunt Richard chapman 600176 600176 Graunt, Richard, of Andover, Hants, chapman 1
4089652 2056592 2056592 defendant Sutton Thomas gent 600176 600176 Sutton, Thomas, of Andover, Hants, gent 0
4096579 2059104 2059104 defendant Padye Thomas chapman 600176 600176 Padye, Thomas, of Andover, Hants, chapman 1
4129014 2070680 2070680 defendant Abbatt Stephen chapman 600176 600176 Abbatt, Stephen, of Andover, Hants, chapman 2
4129020 2070681 2070681 defendant Abbott Stephen chapman 600176 600176 Abbott, Stephen, of Andover, Hants, chapman 2
4142255 2075467 2075467 defendant Childe Thomas, senior haberdasher 600176 600176 Childe, Thomas, senior, of Andover, Hants, haberdasher 0
4166648 2083833 2083833 defendant Edward John yeoman 600176 600176 Edward, John, of Andover, Hants, yeoman 0
4176725 2087331 2087331 defendant Hinxman William draper 600176 600176 Hinxman, William, of Andover, Hants, draper 0
4288723 2126023 2126023 defendant Peterson Anthony chapman 600176 600176 Peterson, Anthony, of Andover, Hants, chapman 0
4297263 2129127 2129127 defendant Peterson Anthony chapman 600176 600176 Peterson, Anthony, of Andover, Hants, chapman 0
4687073 2261561 2261561 defendant Croucheman John tanner 600176 600176 Croucheman, John, of Andover, Hants, tanner 8
4733123 2275537 2275537 defendant Hewe Richard   600176 600176 Hewe, Richard, of Andover, Hants, hosteler, son of Simon 0
4737815 2276931 2276931 defendant Lylye Robert husbandman 600176 600176 Lylye, Robert, of Andover, Hants, husbandman 2
4739477 2277431 2277431 defendant Bray John gent 600176 600176 Bray, John, of Andover, Hants, gent 2
4746997 2279624 2279624 defendant Robys John husbandman 600176 600176 Robys, John, of Andover, Hants, husbandman 1
4760333 2283583 2283583 defendant Fryge John hosteller 600176 600176 Fryge, John, of Andover, Hants, hosteller 1
4770239 2286665 2286665 defendant Bailli John chapman 600176 600176 Bailli, John, of Andover, Hants, chapman 3
4828297 2304896 2304896 defendant Wodefold Robert laborer 600176 600176 Wodefold, Robert, of Andover, Hants, laborer 0
4838590 2307992 2307992 defendant Fyge John hosteller 600176 600176 Fyge, John, of Andover, Hants, hosteller 0
4998598 2356469 2356469 defendant Fugge John husbandman 600176 600176 Fugge, John, of Andover, Hants, husbandman 0
5002950 2357766 2357766 defendant Spore Walter husbandman 600176 600176 Spore, Walter, of Andover, Hants, chapman: Pertryche, Reginald, of North Flete, Kent, husbandman 0
5126006 2394090 2394090 defendant Tailour Richard chapman 600176 600176 Tailour, Richard, of Andover, Hants, chapman 3
5132152 2395895 2395895 defendant Luytell Adam yeoman 600176 600176 Luytell, Adam, of Andover, Hants, yeoman 0
5138645 2397798 2397798 defendant Cusse Robert hosteller 600176 600176 Cusse, Robert, of Andover, Hants, hosteller 0
5144628 2399586 2399586 defendant Tailor Richard chapman 600176 600176 Tailor, Richard, of Andover, Hants, chapman 3
5148016 2400566 2400566 defendant Andrewe John mercer 600176 600176 Andrewe, John, of Andover, Hants, mercer 0
5151722 2401664 2401664 defendant Lytell Adam   600176 600176 Lytell, Adam, of Andover, Hants 0
5167470 2406218 2406218 defendant Andrewe John mercer 600176 600176 Andrewe, John, of Andover, Hants, mercer 0
5167476 2406219 2406219 defendant Andrewe John mercer 600176 600176 Andrewe, John, of Andover, Hants, mercer 0
5186952 2411923 2411923 defendant Lytell Adam yeoman 600176 600176 Lytell, Adam, of Andover, Hants, yeoman 0
5186956 2411924 2411924 defendant Lytell Adam yeoman 600176 600176 Lytell, Adam, of Andover, Hants, yeoman 0
5186960 2411925 2411925 defendant Lytell Adam yeoman 600176 600176 Lytell, Adam, of Andover, Hants, yeoman 0
5190166 2412867 2412867 defendant Asshe Lawrence butcher 600176 600176 Asshe, Lawrence, of Andover, Hants, butcher 0
5197483 2415004 2415004 defendant Nutkyn William chapman 600176 600176 Nutkyn, William, of Andover, Hants, chapman 2
5197490 2415005 2415005 defendant Nutkyn William chapman 600176 600176 Nutkyn, William, of Andover, Hants, chapman 2
5197901 2415123 2415123 plaintiff Taylour Richard fuller 600176 600176 Taylour, Richard, of Andover, Hants, fuller 0
5197903 2415124 2415124 plaintiff Taylour Richard fuller 600176 600176 Taylour, Richard, of Andover, Hants, fuller 0
5202045 2416364 2416364 defendant Morant John ostler 600176 600176 Morant, John, of Andover, Hants, ostler 1
5204391 2417033 2417033 defendant Tayler Richard mercer 600176 600176 Tayler, Richard, of Andover, Hants, mercer 0
5206787 2417722 2417722 defendant Asshe Lawrence butcher 600176 600176 Asshe, Lawrence, of Andover, Hants, butcher 0
5209343 2418467 2418467 defendant Cose Robert hosteler 600176 600176 Cose, Robert, of Andover, Hants, hosteler 2
5210141 2418695 2418695 defendant Nutkyn William chapman 600176 600176 Nutkyn, William, of Andover, Hants, chapman 1
5210334 2418752 2418752 plaintiff Taylour Richard fuller 600176 600176 Taylour, Richard, of Andover, Hants, fuller 0
5269105 2436069 2436069 defendant Whitway Thomas weaver 600176 600176 Whitway, Thomas, of Andover, Hants, weaver 0
5305696 2446711 2446711 defendant Notkyn Richard mercer 600176 600176 Notkyn, Richard, of Andover, Hants, mercer 1
5309627 2447919 2447919 defendant Barell Robert gent 600176 600176 Barell, Robert, of Andover, Hants, gent 1
5341834 2457638 2457638 defendant Laurens Thomas baker 600176 600176 Laurens, Thomas, of Andover, Hants, baker 3
5427521 2483184 2483184 defendant Curteys Richard husbandman 600176 600176 Curteys, Richard, of Andover, Hants, husbandman 0
5439874 2486869 2486869 defendant Nutkyn Richard mercer 600176 600176 Nutkyn, Richard, of Andover, Hants, mercer 0
5439876 2486870 2486870 defendant Nutkyn Richard mercer 600176 600176 Nutkyn, Richard, of Andover, Hants, mercer 0
5439878 2486871 2486871 defendant Nutkyn Richard mercer 600176 600176 Nutkyn, Richard, of Andover, Hants, mercer 0
5440119 2486949 2486949 defendant Sandys William   600176 600176 Sandys, William, of Andover, Hants, knight 1
5440585 2487089 2487089 defendant Nutkyn William yeoman 600176 600176 (Nutkyn, William, of Andover, Hants, yeoman 3
5445268 2488480 2488480 defendant Curteys Richard husbandman 600176 600176 Curteys, Richard, of Andover, Hants, husbandman 0
5450722 2490102 2490102 defendant Roby William gent 600176 600176 Roby, William, of Andover, Hants, gent 1
5453567 2490960 2490960 defendant Sandes William   600176 600176 Sandes, William, of Andover, Hants, knight 0
5453622 2490974 2490974 defendant Sandys William miliner or knight 600176 600176 Sandys, William, of Andover, Hants, miliner or knight 1
5457940 2492275 2492275 defendant Curteys Richard husbandman 600176 600176 Curteys, Richard, of Andover, Hants, husbandman 0
5462858 2493803 2493803 defendant Roby William gent 600176 600176 Roby, William, of Andover, Hants, gent 1
5464651 2494345 2494345 defendant Sandys William   600176 600176 Sandys, William, of Andover, Hants, knight 0
5465497 2494588 2494588 defendant Sandes William   600176 600176 Sandes, William, of Andover, Hants, knight 0
5465777 2494679 2494679 defendant Nutkyn William yeoman 600176 600176 (Nutkyn, William, of Andover, Hants, yeoman 3

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