names

118 rows where place_id = 586383

✎ 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
3588578 1864072 1864072 plaintiff Billesden Nicholas dyer 586383 586383 Billesden, Nicholas, of Stamford, Lincs, dyer 0
3641892 1907918 1907918 defendant Aleye John mercer 586383 586383 Aleye, John, of Stamford, Lincs, mercer 0
3658807 1913012 1913012 defendant Hogeson John chapman 586383 586383 Hogeson, John, of Stamford, Lincs, chapman 0
3658809 1913013 1913013 defendant Hogeson John chapman 586383 586383 Hogeson, John, of Stamford, Lincs, chapman 0
3662802 1914283 1914283 defendant Wryght Ralph   586383 586383 Wryght, Ralph, of Stamford, Lincs, fish monger 2
3694637 1924527 1924527 defendant Jones William fuller 586383 586383 Jones, William, of Stamford, Lincs, fuller 0
3694639 1924528 1924528 defendant Jones William fuller 586383 586383 Jones, William, of Stamford, Lincs, fuller 0
3736520 1937670 1937670 defendant Brown Francis   586383 586383 Brown, Francis, of Stamford, Lincs, sheriff of Lincs 0
3756858 1944118 1944118 defendant Wytton Mathew yeoman 586383 586383 Wytton, Mathew, of Stamford, Lincs, yeoman 0
3776058 1950257 1950257 defendant Grene John pewterer 586383 586383 Grene, John, of Stamford, Lincs, pewterer 0
3781416 1951924 1951924 defendant Parson Robert grocer 586383 586383 Parson, Robert, of Stamford, Lincs, grocer 0
3789282 1954465 1954465 defendant Scotte John tailor 586383 586383 Scotte, John, of Stamford, Lincs, tailor 1
3789285 1954466 1954466 defendant Scotte John tailor 586383 586383 Scotte, John, of Stamford, Lincs, tailor 1
3800334 1958022 1958022 defendant Welbe Henry gent 586383 586383 Welbe, Henry, of Stamford, Lincs, gent 0
3889858 1986847 1986847 defendant Gedney Thomas glover 586383 586383 Gedney, Thomas, of Stamford, Lincs, glover 0
3897976 1989530 1989530 defendant Waren Thomas mercer 586383 586383 Waren, Thomas, of Stamford, Lincs, mercer 0
3899071 1989898 1989898 defendant Waryng Thomas   586383 586383 Waryng, Thomas, of Stamford, Lincs 0
3902100 1990938 1990938 defendant Warryn Thomas merchant 586383 586383 Warryn, Thomas, of Stamford, Lincs, merchant 0
3904252 1991668 1991668 plaintiff Haryson William clerk 586383 586383 Haryson, William, of Stamford, Lincs, clerk 0
3908488 1993137 1993137 defendant Waren Thomas chapman 586383 586383 Waren, Thomas, of Stamford, Lincs, chapman 0
3917321 1996151 1996151 defendant Hargrave alias Hardegrave John esq 586383 586383 Hargrave alias Hardegrave, John, of Stamford, Lincs, esq 0
3922693 1997904 1997904 defendant Furneys John smith 586383 586383 Furneys, John, of Stamford, Lincs, smith 3
3922700 1997905 1997905 defendant Furneys John smith 586383 586383 Furneys, John, of Stamford, Lincs, smith 3
3929091 2000070 2000070 defendant Oldnall John   586383 586383 Oldnall, John, of Stamford, Lincs, inn holder 1
3932185 2001069 2001069 defendant Cowper Robert   586383 586383 Cowper, Robert, of Stamford, Lincs 0
3932186 2001069 2001069 defendant Brownesale Christopher vintner 586383 586383 Brownesale, Christopher, of Stamford, Lincs, vintner 1
3932488 2001156 2001156 defendant Lawrett John mercer 586383 586383 Lawrett, John, of Stamford, Lincs, mercer 1
3938186 2003109 2003109 defendant Oldnall John gent 586383 586383 Oldnall, John, of Stamford, Lincs, gent 0
3946448 2005826 2005826 defendant Thorneff Francis gent 586383 586383 Thorneff, Francis, of Stamford, Lincs, gent 0
3947242 2006102 2006102 defendant Clarke Henry chapman 586383 586383 Clarke, Henry, of Stamford, Lincs, chapman 0
3952759 2008038 2008038 defendant Battersby Robert tailor 586383 586383 Battersby, Robert, of Stamford, Lincs, tailor 3
3953971 2008460 2008460 defendant Tayler Simon draper 586383 586383 Tayler, Simon, of Stamford, Lincs, draper 0
3975236 2015905 2015905 defendant Clerke Hery mercer 586383 586383 Clerke, Hery, of Stamford, Lincs, mercer 0
3984440 2019191 2019191 plaintiff Tampon Henry gent 586383 586383 Tampon, Henry, of Stamford, Lincs, gent 0
3994003 2022607 2022607 defendant Allyn John chapman 586383 586383 Allyn, John, of Stamford, Lincs, chapman 0
3994005 2022608 2022608 defendant Attony Alexander chapman 586383 586383 Attony, Alexander, of Stamford, Lincs, chapman 0
4000416 2024917 2024917 defendant Woode Hugh vintner 586383 586383 Woode, Hugh, of Stamford, Lincs, vintner 0
4034528 2037021 2037021 plaintiff Harryson Reginald mercer 586383 586383 Harryson, Reginald, of Stamford, Lincs, mercer 0
4039559 2038770 2038770 defendant Wood Hugh vintner 586383 586383 Wood, Hugh, of Stamford, Lincs, vintner 0
4043702 2040204 2040204 plaintiff Howghton John yeoman 586383 586383 Howghton, John, of Stamford, Lincs, yeoman 1
4043711 2040205 2040205 plaintiff Howghton John yeoman 586383 586383 Howghton, John, of Stamford, Lincs, yeoman 1
4052647 2043372 2043372 defendant Allen John yeoman 586383 586383 Allen, John, of Stamford, Lincs, yeoman 0
4059069 2045639 2045639 defendant Colston John gent 586383 586383 Colston, John, of Stamford, Lincs, gent 3
4059912 2045942 2045942 defendant Bosden or Bossam John yeoman 586383 586383 Bosden or Bossam, John, of Stamford, Lincs, yeoman 0
4071878 2050242 2050242 defendant Thorneff Francis gent 586383 586383 Thorneff, Francis, of Stamford, Lincs, gent 0
4072544 2050486 2050486 defendant Harroppe alias Baker Geoffrey innholder 586383 586383 Harroppe alias Baker, Geoffrey, of Stamford, Lincs, innholder 0
4085296 2055021 2055021 defendant Grene Alexander chapman 586383 586383 Grene, Alexander, of Stamford, Lincs, chapman 2
4129075 2070700 2070700 defendant Grene Alexander chapman 586383 586383 Grene, Alexander, of Stamford, Lincs, chapman 3
4132631 2071992 2071992 defendant Gunston Anthony   586383 586383 Gunston, Anthony, of Stamford, Lincs, apothecary 0
4137189 2073646 2073646 defendant Dymock John vintner 586383 586383 Dymock, John, of Stamford, Lincs, vintner 0
4151169 2078534 2078534 defendant Diconson Richard yeoman 586383 586383 Diconson, Richard, of Stamford, Lincs, yeoman 0
4159693 2081458 2081458 defendant Thornesse or Thornes Francis innholder 586383 586383 Thornesse or Thornes, Francis, of Stamford, Lincs, innholder 0
4181394 2088971 2088971 defendant Mather Robert draper 586383 586383 Mather, Robert, of Stamford, Lincs, draper 0
4208999 2098698 2098698 defendant Bennett Anne widow 586383 586383 Bennett, Anne, of Stamford, Lincs, widow 0
4229095 2105659 2105659 defendant Baker Geoffrey innkeeper 586383 586383 Baker, Geoffrey, of Stamford, Lincs, innkeeper 0
4285381 2124819 2124819 defendant Baker Richard chapman 586383 586383 Baker, Richard, of Stamford, Lincs, chapman 1
4290645 2126712 2126712 defendant Clarke Lawrence yeoman 586383 586383 Clarke, Lawrence, of Stamford, Lincs, yeoman 0
4290661 2126718 2126718 defendant Watson William gent 586383 586383 Watson, William, of Stamford, Lincs, gent 0
4300078 2130124 2130124 defendant Bateman Stephen gent 586383 586383 Bateman, Stephen, of Stamford, Lincs, gent 0
4306231 2132316 2132316 defendant Gilbert John chapman 586383 586383 Gilbert, John, of Stamford, Lincs, chapman 3
4310743 2133901 2133901 defendant Tayler Robert yeoman 586383 586383 Tayler, Robert, of Stamford, Lincs, yeoman 1
4328938 2139991 2139991 defendant Frisby William chapman 586383 586383 Frisby, William, of Stamford, Lincs, chapman 0
4336180 2142385 2142385 defendant Wiles or Willes Henry tanner 586383 586383 Wiles or Willes, Henry, of Stamford, Lincs, tanner 1
4336597 2142527 2142527 defendant Sherife John chapman 586383 586383 Sherife, John, of Stamford, Lincs, chapman 1
4359861 2150690 2150690 defendant Sherife John chapman 586383 586383 Sherife, John, of Stamford, Lincs, chapman 1
4379583 2157788 2157788 defendant Bateman Stephen gent 586383 586383 Bateman, Stephen, of Stamford, Lincs, gent 0
4400536 2164772 2164772 defendant Marston Barnaby skinner 586383 586383 Marston, Barnaby, of Stamford, Lincs, skinner 0
4513454 2204629 2204629 defendant Holme Thomas   586383 586383 Holme, Thomas, of Stamford, Lincs 0
4692308 2263111 2263111 defendant German John husbandman 586383 586383 German, John, of Stamford, Lincs, husbandman 0
4699205 2265217 2265217 defendant Warde John butcher 586383 586383 Warde, John, of Stamford, Lincs, butcher 0
4710511 2268646 2268646 defendant Glasier Peter chapman 586383 586383 Glasier, Peter, of Stamford, Lincs, chapman 0
4765148 2285078 2285078 defendant Longe John gent 586383 586383 Longe, John, of Stamford, Lincs, gent 1
4783555 2290875 2290875 defendant Longe John gent 586383 586383 Longe, John, of Stamford, Lincs, gent 1
4812091 2299892 2299892 defendant Mercer Alexander mercer 586383 586383 Mercer, Alexander, of Stamford, Lincs, mercer 1
4827983 2304801 2304801 defendant Clerk William husbandman 586383 586383 Clerk, William, of Stamford, Lincs, husbandman 1
4831689 2305938 2305938 defendant Knyght William draper 586383 586383 Knyght, William, of Stamford, Lincs, draper 0
4845918 2310230 2310230 defendant Gyrdeler Peter   586383 586383 Gyrdeler, Peter, of Stamford, Lincs 0
4845919 2310230 2310230 defendant Obyn John tanner 586383 586383 Obyn, John, of Stamford, Lincs, tanner 1
4848411 2310976 2310976 defendant Bocher Robert butcher 586383 586383 Bocher, Robert, of Stamford, Lincs, butcher 0
4877978 2320065 2320065 defendant Knyght William draper 586383 586383 Knyght, William, of Stamford, Lincs, draper 3
4915828 2331449 2331449 defendant Gregory William spicer 586383 586383 Gregory, William, of Stamford, Lincs, spicer 0
4923262 2333696 2333696 defendant Wryght Robert chapman 586383 586383 Wryght, Robert, of Stamford, Lincs, chapman 0
4974972 2349486 2349486 defendant Garland Robert yeoman 586383 586383 Garland, Robert, of Stamford, Lincs, yeoman 0
5043885 2369798 2369798 defendant Chevercourt John gent & attorney of the King's Bench 586383 586383 Chevercourt, John, of Stamford, Lincs, gent & attorney of the King's Bench 0
5129491 2395112 2395112 defendant Osborn Richard vintner 586383 586383 Osborn, Richard, of Stamford, Lincs, vintner 0
5131613 2395727 2395727 defendant Trunke John yeoman 586383 586383 Trunke, John, of Stamford, Lincs, yeoman 1
5136401 2397167 2397167 defendant Broun William   586383 586383 Broun, William, of Stamford, Lincs 0
5366082 2465052 2465052 defendant Rankyll Richard glover 586383 586383 Rankyll, Richard, of Stamford, Lincs, glover 1
5375586 2467952 2467952 defendant Smyth Richard smith 586383 586383 Smyth, Richard, of Stamford, Lincs, smith 0
5375664 2467979 2467979 defendant Halton Thomas laborer 586383 586383 Halton, Thomas, of Stamford, Lincs, laborer 3
5375670 2467980 2467980 defendant Halton Thomas laborer 586383 586383 Halton, Thomas, of Stamford, Lincs, laborer 3
5377013 2468404 2468404 defendant Dorannte William chapman 586383 586383 Dorannte, William, of Stamford, Lincs, chapman 3
5378756 2468941 2468941 defendant Duraunt John chapman 586383 586383 Duraunt, John, of Stamford, Lincs, chapman 0
5378758 2468942 2468942 defendant Duraunt William chapman 586383 586383 Duraunt, William, of Stamford, Lincs, chapman 0
5391367 2472608 2472608 defendant Derant William mercer 586383 586383 Derant, William, of Stamford, Lincs, mercer 1
5393043 2473081 2473081 defendant Doraunt William chapman 586383 586383 Doraunt, William, of Stamford, Lincs, chapman 3
5404370 2476322 2476322 defendant Derant William mercer 586383 586383 Derant, William, of Stamford, Lincs, mercer 1
5406175 2476845 2476845 defendant Doraunt William chapman 586383 586383 Doraunt, William, of Stamford, Lincs, chapman 3
5406180 2476846 2476846 defendant Doraunt William chapman 586383 586383 Doraunt, William, of Stamford, Lincs, chapman 3
5422988 2481826 2481826 defendant Hyane John tailor 586383 586383 Hyane, John, of Stamford, Lincs, tailor 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);