names

137 rows where place_id = 590448

✎ 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
3601234 1868048 1868048 defendant Boton John yeoman 590448 590448 Boton, John, of Alton, yeoman 0
3603725 1868836 1868836 defendant Skylton John butcher 590448 590448 Skylton, John, of Alton, butcher 0
3611052 1871133 1871133 defendant Rolston John gent 590448 590448 Rolston, John, of Alton, gent 0
3611053 1871133 1871133 defendant Nyghtyngale Giles husbandman 590448 590448 Nyghtyngale, Giles, of Alton, husbandman 1
3627695 1903523 1903523 defendant Cowper John husbandman 590448 590448 Cowper, John, of Alton, husbandman 0
3629321 1904029 1904029 defendant Goche William smith 590448 590448 Goche, William, of Alton, smith 0
3629324 1904030 1904030 defendant Gooche Edmund smith 590448 590448 Gooche, Edmund, of Alton, smith 0
3643729 1908466 1908466 defendant Long Lawrence yeoman 590448 590448 Long, Lawrence, of Alton, yeoman 2
3649247 1910153 1910153 defendant Button John husbandman 590448 590448 Button, John, of Alton, husbandman 2
3650204 1910434 1910434 defendant Pratt William husbandman 590448 590448 Pratt, William, of Alton, husbandman 2
3664779 1914930 1914930 defendant Laman John husbandman 590448 590448 Laman, John, of Alton, husbandman 1
3667701 1915844 1915844 defendant Cowper John, junior laborer 590448 590448 Cowper, John, junior, of Alton, laborer 3
3670663 1916789 1916789 plaintiff Button John (legal representative) 590448 590448 Button, John, of Alton, executor of 0
3671393 1917030 1917030 defendant Smyth Robert husbandman 590448 590448 Smyth, Robert, of Alton, husbandman 0
3677457 1919000 1919000 defendant Long Lawrence husbandman 590448 590448 Long, Lawrence, of Alton, husbandman 3
3692720 1923911 1923911 defendant Broun John laborer 590448 590448 Broun, John, of Alton, laborer 1
3715584 1931161 1931161 plaintiff Button John (legal representative) 590448 590448 Button, John, of Alton, yeoman, executors of 0
3736495 1937662 1937662 defendant Courtmyll John mercer 590448 590448 Courtmyll, John, of Alton, mercer 0
3741153 1939094 1939094 defendant Longe Lawrence husbandman 590448 590448 Longe, Lawrence, of Alton, husbandman 1
3756676 1944066 1944066 defendant Wode Robert yeoman 590448 590448 Wode, Robert, of Alton, yeoman 4
3756965 1944156 1944156 defendant Longe Lawrence husbandman 590448 590448 Longe, Lawrence, of Alton, husbandman 1
3773739 1949502 1949502 defendant Bysshope Thomas   590448 590448 Bysshope, Thomas, of Alton, spoon maker 2
3782808 1952370 1952370 defendant Redman Lawrence mercer 590448 590448 Redman, Lawrence, of Alton, mercer 0
3815111 1962645 1962645 defendant Bushop Thomas trencher maker 590448 590448 Bushop, Thomas, of Alton, trencher maker 2
3819629 1964017 1964017 defendant Morres William yeoman 590448 590448 Morres, William, of Alton, yeoman 0
3845962 1972293 1972293 defendant Long Robert husbandman 590448 590448 Long, Robert, of Alton, husbandman 0
3845978 1972298 1972298 defendant Comfort Robert clothier 590448 590448 Comfort, Robert, of Alton, clothier 1
3864115 1978183 1978183 defendant Pooke John weaver 590448 590448 Pooke, John, of Alton, weaver 0
3873651 1981403 1981403 defendant Redyng John fuller 590448 590448 Redyng, John, of Alton, fuller 0
3875793 1982155 1982155 defendant Comfort Robert clothier 590448 590448 Comfort, Robert, of Alton, clothier 0
3875795 1982156 1982156 defendant Comfort Robert clothier 590448 590448 Comfort, Robert, of Alton, clothier 0
3877666 1982773 1982773 defendant Gregory John smith 590448 590448 Gregory, John, of Alton, smith 0
3877831 1982829 1982829 defendant Courtmyll John mercer 590448 590448 Courtmyll, John, of Alton, mercer 0
3886551 1985753 1985753 defendant Trevett Roger butcher 590448 590448 Trevett, Roger, of Alton, butcher 0
3896729 1989116 1989116 defendant Chynne William husbandman 590448 590448 Chynne, William, of Alton, husbandman 0
3914263 1995114 1995114 plaintiff Button William gent 590448 590448 Button, William, of Alton, gent 0
3914382 1995152 1995152 defendant Creme Johnm yeoman 590448 590448 Creme, Johnm, of Alton, yeoman 2
3915659 1995608 1995608 defendant Sturges Thomas clothier 590448 590448 Sturges, Thomas, of Alton, clothier 0
3915661 1995609 1995609 defendant Turges alias Storges Thomas clothier 590448 590448 Turges alias Storges, Thomas, of Alton, clothier 0
3950008 2007085 2007085 defendant Androwe alias Richardson John laborer 590448 590448 Androwe alias Richardson, John, of Alton, laborer 0
3952166 2007830 2007830 defendant Robyns Anthony gent 590448 590448 Robyns, Anthony, of Alton, gent 0
3953135 2008162 2008162 defendant Button William esq 590448 590448 Button, William, of Alton, esq 0
3973360 2015255 2015255 defendant Wallett Thomas husbandman 590448 590448 Wallett, Thomas, of Alton, husbandman 0
4055369 2044316 2044316 defendant Key Thomas tanner 590448 590448 Key, Thomas, of Alton, tanner 7
4077897 2052396 2052396 defendant Porter John yeoman 590448 590448 Porter, John, of Alton, yeoman 0
4078419 2052576 2052576 defendant Barlowe William yeoman 590448 590448 Barlowe, William, of Alton, yeoman 2
4114071 2065314 2065314 defendant Deringe William gent 590448 590448 Deringe, William, of Alton, or of Wydleye, gent 0
4140789 2074942 2074942 defendant Gages Thomas yeoman 590448 590448 Gages, Thomas, of Alton, yeoman 0
4140790 2074942 2074942 defendant Okeshott John yeoman 590448 590448 Okeshott, John, of Alton, yeoman 1
4140791 2074942 2074942 defendant Nicolsonne Thomas yeoman 590448 590448 Nicolsonne, Thomas, of Alton, yeoman 2
4147259 2077179 2077179 defendant Knighte Henry yeoman 590448 590448 Knighte, Henry, of Alton, yeoman 0
4222426 2103335 2103335 defendant Mayne Lawrence butcher 590448 590448 Mayne, Lawrence, of Alton, butcher 0
4241335 2110087 2110087 defendant Morey Thomas yeoman 590448 590448 Morey, Thomas, of Alton, yeoman 0
4241337 2110088 2110088 defendant Smyth Thomas yeoman 590448 590448 Smyth, Thomas, of Alton, yeoman 0
4268002 2118917 2118917 defendant Stynte or Stent John (legal representative) 590448 590448 Stynte or Stent, John, of Alton, yeoman, executor of 0
4274595 2121058 2121058 defendant Hopkynson William yeoman 590448 590448 Hopkynson, William, of Alton juxta Asheover, yeoman 0
4280080 2122943 2122943 defendant Robinson Robert barber 590448 590448 Robinson, Robert, of Alton, barber 0
4280081 2122943 2122943 defendant Constance John shoemaker 590448 590448 Constance, John, of Alton, shoemaker 1
4280082 2122943 2122943 defendant Ayllyn or Ayllam Robert sherman 590448 590448 Ayllyn or Ayllam, Robert, of Alton, sherman 2
4282729 2123864 2123864 defendant Turnor William husbandman 590448 590448 Turnor, William, of Alton, husbandman 0
4282730 2123864 2123864 defendant Lavye John husbandman 590448 590448 Lavye, John, of Alton, husbandman 1
4306241 2132319 2132319 defendant Robinson Robert barker 590448 590448 Robinson, Robert, of Alton, barker 0
4308760 2133214 2133214 defendant Arnolde Richard gent 590448 590448 Arnolde, Richard, of Alton, gent 1
4318805 2136692 2136692 defendant Button Ambrose gent 590448 590448 Button, Ambrose, of Alton, gent 0
4319982 2137093 2137093 defendant Twyne William gent 590448 590448 Twyne, William, of Alton, gent 0
4327262 2139445 2139445 defendant Beswyke Hugh husbandman 590448 590448 Beswyke, Hugh, of Alton, husbandman 2
4371663 2154922 2154922 defendant Bull John haberdasher 590448 590448 Bull, John, of Alton, haberdasher 0
4371664 2154922 2154922 defendant Bayly Barnard butcher 590448 590448 Bayly, Barnard, of Alton, butcher 1
4372645 2155291 2155291 defendant Norton William gent 590448 590448 Norton, William, of Alton, gent 0
4375500 2156291 2156291 defendant Kinge Francis clothier 590448 590448 Kinge, Francis, of Alton, clothier 2
4380675 2158197 2158197 defendant Mayne Alice widow 590448 590448 Mayne, Alice, of Alton, widow 0
4384360 2159461 2159461 defendant Burgen George husbandman 590448 590448 Burgen, George, of Alton, husbandman 1
4411046 2168280 2168280 defendant Mayne Alice widow 590448 590448 Mayne, Alice, of Alton, widow 0
4450512 2185123 2185123 defendant Sturmy William   590448 590448 Sturmy, William, of Alton 0
4500543 2200791 2200791 defendant Dexter William   590448 590448 Dexter, William, of Alton 0
4503324 2201610 2201610 defendant Dygeryth Philip chaplain 590448 590448 Dygeryth, Philip, of Alton, chaplain 0
4542947 2213688 2213688 plaintiff Ansty John   590448 590448 Ansty, John, of Alton 0
4542948 2213688 2213688 defendant Wolleyn William   590448 590448 Wolleyn, William, of Alton 0
4607837 2233566 2233566 defendant Wullane William   590448 590448 Wullane, William, of Alton 0
4615482 2235847 2235847 defendant Loner John   590448 590448 Loner, John, of Alton 3
4637160 2242422 2242422 defendant Wullane William   590448 590448 Wullane, William, of Alton 2
4641170 2243509 2243509 defendant Everard John clerk 590448 590448 Everard, John, of Alton, clerk 0
4650778 2246248 2246248 defendant Alton John   590448 590448 Alton, John, of Alton 0
4656429 2247905 2247905 plaintiff Carter Henry   590448 590448 Carter, Henry, of Alton 0
4694291 2263713 2263713 defendant Swyndon Thomas husbandman 590448 590448 Swyndon, Thomas, of Alton, husbandman 1
4713049 2269403 2269403 defendant Swyndon Thomas   590448 590448 Swyndon, Thomas, of Alton, Hants, auditor 0
4716228 2270384 2270384 defendant Craneburne Margaret widow 590448 590448 Craneburne, Margaret, of Alton, widow 0
4728227 2274072 2274072 defendant Palmer John smith 590448 590448 Palmer, John, of Alton, smith 0
4753866 2281587 2281587 defendant Ball John husbandman 590448 590448 Ball, John, of Alton, husbandman 2
4761469 2283931 2283931 defendant Mounter John yeoman 590448 590448 Mounter, John, of Alton, yeoman 0
4817907 2301683 2301683 defendant Alsop John yeoman 590448 590448 Alsop, John, of Alton, yeoman 0
4844071 2309656 2309656 defendant Fyssher Walter butcher 590448 590448 Fyssher, Walter, of Alton, butcher 0
4848054 2310857 2310857 defendant Tortyngton John husbandman 590448 590448 Tortyngton, John, of Alton, husbandman 1
4882973 2321595 2321595 plaintiff Tortyngton John   590448 590448 Tortyngton, John, of Alton 0
4901570 2327090 2327090 defendant Stafford Thomas yeoman 590448 590448 Stafford, Thomas, of Alton, yeoman 0
4902371 2327355 2327355 plaintiff Tortyngton John   590448 590448 Tortyngton, John, of Alton 0
4929208 2335551 2335551 defendant Wynterborn Walter butcher 590448 590448 Wynterborn, Walter, of Alton, butcher 1
4966217 2346829 2346829 plaintiff de Wolde William   590448 590448 de Wolde, William, of Alton 0
4977107 2350107 2350107 defendant Frankeleyn John laborer 590448 590448 Frankeleyn, John, of Alton, laborer 1
5009334 2359620 2359620 defendant Tortyngton William   590448 590448 Tortyngton, William, of Alton, bailiff 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);