names

116 rows where place_id = 587636

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3592017 1865118 1865118 plaintiff Foord William   587636 587636 Foord, William, of Hadleigh 0
3603960 1868907 1868907 plaintiff Foord William merchant 587636 587636 Foord, William, of Hadleigh, merchant 0
3603964 1868908 1868908 plaintiff Foord William merchant 587636 587636 Foord, William, of Hadleigh, merchant 0
3652281 1911052 1911052 defendant Quynteyn John clothmaker 587636 587636 Quynteyn, John, of Hadleigh, clothmaker 0
3667346 1915724 1915724 defendant Thered alias Gardner Thomas weaver 587636 587636 Thered alias Gardner, Thomas, of Hadleigh, weaver 0
3671398 1917033 1917033 plaintiff Clerk Walter clothier 587636 587636 Clerk, Walter, of Hadleigh, clothier 0
3671399 1917033 1917033 defendant Smyth William merchant 587636 587636 Smyth, William, of Hadleigh, merchant 0
3671400 1917034 1917034 plaintiff Clerk Walter clothier 587636 587636 Clerk, Walter, of Hadleigh, clothier 0
3671401 1917034 1917034 defendant Smyth William merchant 587636 587636 Smyth, William, of Hadleigh, merchant 0
3672168 1917294 1917294 defendant Meller William yeoman 587636 587636 Meller, William, of Hadleigh, yeoman 0
3710105 1929472 1929472 defendant Clerke Walter clothier 587636 587636 Clerke, Walter, of Hadleigh, clothier 0
3741196 1939105 1939105 defendant Smyth William clothmaker 587636 587636 Smyth, William, of Hadleigh, clothmaker 1
3792303 1955450 1955450 defendant Wodeward John grocer 587636 587636 Wodeward, John, of Hadleigh, grocer 0
3797098 1956975 1956975 defendant Barker Thomas yeoman 587636 587636 Barker, Thomas, of Hadleigh, yeoman 1
3797099 1956975 1956975 defendant Berker Walter yeoman 587636 587636 Berker, Walter, of Hadleigh, yeoman 2
3797668 1957166 1957166 defendant Pytcher Edmund yeoman 587636 587636 Pytcher, Edmund, of Hadleigh, yeoman 1
3812330 1961749 1961749 defendant Heyward Richard shoemaker 587636 587636 Heyward, Richard, of Hadleigh, shoemaker 0
3857688 1976039 1976039 defendant Rotheman Thomas gent 587636 587636 Rotheman, Thomas, of Hadleigh, gent 0
3902389 1991031 1991031 defendant Codbolt alias Woode John fishmonger 587636 587636 Codbolt alias Woode, John, of Hadleigh, fishmonger 0
3922410 1997811 1997811 defendant Chapman Thomas butcher 587636 587636 Chapman, Thomas, of Hadleigh, butcher 0
3973226 2015208 2015208 defendant Alcocke Nicholas weaver 587636 587636 Alcocke, Nicholas, of Hadleigh, weaver 0
3973228 2015209 2015209 defendant Facon John clothier 587636 587636 Facon, John, of Hadleigh, clothier 0
3982942 2018677 2018677 defendant Cooke John chapman 587636 587636 Cooke, John, of Hadleigh, chapman 2
3983128 2018739 2018739 plaintiff Smyth Edward clothmaker 587636 587636 Smyth, Edward, of Hadleigh, clothmaker 0
3988148 2020507 2020507 plaintiff Andrewe Robert mercer 587636 587636 Andrewe, Robert, of Hadleigh, mercer 0
3988149 2020507 2020507 defendant Sweteman Robert tailor 587636 587636 Sweteman, Robert, of Hadleigh, tailor 0
3988617 2020672 2020672 defendant Pett Robert tanner 587636 587636 Pett, Robert, of Hadleigh, tanner 2
3991169 2021600 2021600 defendant Foorthe or Furthe Philologus gent 587636 587636 Foorthe or Furthe, Philologus, of Hadleigh, gent 0
3993922 2022577 2022577 plaintiff Clare Anthony yeoman 587636 587636 Clare, Anthony, of Hadleigh, yeoman 0
3993923 2022577 2022577 defendant Fuller William tailor or woolen draper 587636 587636 Fuller, William, of Hadleigh, tailor or woolen draper 0
3994433 2022763 2022763 defendant Panell Robert clothier 587636 587636 Panell, Robert, of Hadleigh, clothier 1
3994932 2022938 2022938 defendant Panell alias Myller Richard clothier 587636 587636 Panell alias Myller, Richard, of Hadleigh, clothier 1
3996734 2023594 2023594 defendant Heyward John husbandman 587636 587636 Heyward, John, of Hadleigh, husbandman 0
3996735 2023594 2023594 defendant Lambe Richard sherman 587636 587636 Lambe, Richard, of Hadleigh, sherman 1
3999320 2024516 2024516 defendant Tomson Stephen glover 587636 587636 Tomson, Stephen, of Hadleigh, glover 1
3999323 2024518 2024518 plaintiff Fuller Andrew mercer 587636 587636 Fuller, Andrew, of Hadleigh, mercer 0
3999324 2024518 2024518 defendant Scrivener Robert singleman 587636 587636 Scrivener, Robert, of Hadleigh, husbandman, singleman 0
4000311 2024882 2024882 defendant Flower Christiopher miller 587636 587636 Flower, Christiopher, of Hadleigh, miller 0
4006483 2027097 2027097 plaintiff Lewese or Lewse William husbandman 587636 587636 Lewese or Lewse, William, of Hadleigh, husbandman 0
4010636 2028575 2028575 defendant Grevyll Alexander tailor 587636 587636 Grevyll, Alexander, of Hadleigh, tailor 0
4010638 2028575 2028575 defendant Thornton John yeoman 587636 587636 Thornton, John, of Hadleigh, yeoman 2
4010641 2028576 2028576 defendant Lynne John innholder 587636 587636 Lynne, John, of Hadleigh, innholder 0
4017212 2030861 2030861 defendant Hallywell Robert gent 587636 587636 Hallywell, Robert, of Hadleigh, gent 0
4031587 2035959 2035959 defendant Wyles William husbandman 587636 587636 Wyles, William, of Hadleigh, husbandman 1
4040714 2039172 2039172 defendant Forth William gent 587636 587636 Forth, William, of Hadleigh, gent 1
4040715 2039172 2039172 defendant Forth Israel gent 587636 587636 Forth, Israel, of Hadleigh, gent 2
4053320 2043562 2043562 defendant Stoyle William weaver 587636 587636 Stoyle, William, of Hadleigh, weaver 2
4053321 2043562 2043562 defendant Burman Jerome carrier 587636 587636 Burman, Jerome, of Hadleigh, carrier 3
4055172 2044243 2044243 defendant Thorpe Roger brewer 587636 587636 Thorpe, Roger, of Hadleigh, brewer 0
4055173 2044243 2044243 defendant Habergan Gilbert sherman 587636 587636 Habergan, Gilbert, of Hadleigh, sherman 1
4055174 2044243 2044243 defendant Hassell Richard yeoman 587636 587636 Hassell, Richard, of Hadleigh, yeoman 2
4059216 2045694 2045694 defendant Ball William clothier 587636 587636 Ball, William, of Hadleigh, clothier 1
4062015 2046700 2046700 defendant Reder Richard tailor 587636 587636 Reder, Richard, of Hadleigh, tailor 0
4062436 2046854 2046854 defendant Blosse Martin yeoman 587636 587636 Blosse, Martin, of Hadleigh, yeoman 0
4070533 2049755 2049755 defendant Hall Michael clothier 587636 587636 Hall, Michael, of Hadleigh, clothier 0
4079155 2052846 2052846 defendant Dek Thomas sherman 587636 587636 Dek, Thomas, of Hadleigh, sherman 2
4090529 2056895 2056895 defendant Dryver John cooper 587636 587636 Dryver, John, of Hadleigh, cooper 1
4090530 2056895 2056895 defendant Colborne Robert husbandman 587636 587636 Colborne, Robert, of Hadleigh, husbandman 2
4100203 2060405 2060405 defendant Ruddinge Christpher singleman 587636 587636 Ruddinge, Christpher, of Hadleigh, yeoman, singleman 0
4123695 2068777 2068777 defendant Tomson John clothier 587636 587636 Tomson, John, of Hadleigh, clothier 0
4128290 2070402 2070402 defendant Anthingham John yeoman 587636 587636 Anthingham, John, of Hadleigh, yeoman 0
4131415 2071555 2071555 defendant Byllyngsby John sherman 587636 587636 Byllyngsby, John, of Hadleigh, sherman 0
4137294 2073686 2073686 defendant Becon John yeoman 587636 587636 Becon, John, of Hadleigh, yeoman 0
4142850 2075674 2075674 defendant Scoyle Robert weaver 587636 587636 Scoyle, Robert, of Hadleigh, weaver 1
4144454 2076222 2076222 defendant Newton John weaver 587636 587636 Newton, John, of Hadleigh, weaver 2
4146909 2077071 2077071 defendant Gleson Thomas clerk 587636 587636 Gleson, Thomas, of Hadleigh, clerk 0
4147548 2077284 2077284 defendant Forth William gent 587636 587636 Forth, William, of Hadleigh, gent 0
4155488 2080005 2080005 defendant Cove Robert sherman 587636 587636 Cove, Robert, of Hadleigh, sherman 2
4159366 2081346 2081346 defendant Hall Thomas bricklayer 587636 587636 Hall, Thomas, of Hadleigh, bricklayer 0
4160169 2081621 2081621 defendant Pett Robert tanner 587636 587636 Pett, Robert, of Hadleigh, tanner 0
4163752 2082848 2082848 defendant Gleson Thomas clerk 587636 587636 Gleson, Thomas, of Hadleigh, clerk 0
4165643 2083482 2083482 defendant Forthe William gent 587636 587636 Forthe, William, of Hadleigh, gent 2
4169018 2084657 2084657 defendant Fryar John clothier 587636 587636 Fryar, John, of Hadleigh, clothier 0
4190798 2092344 2092344 defendant Goodman alias Porter Thomas weaver 587636 587636 Goodman alias Porter, Thomas, of Hadleigh, weaver 1
4191345 2092537 2092537 defendant Porter alias Goodeman Thomas weaver 587636 587636 Porter alias Goodeman, Thomas, of Hadleigh, weaver 0
4196811 2094432 2094432 defendant Trewe James beer brewer 587636 587636 Trewe, James, of Hadleigh, beer brewer 0
4197896 2094815 2094815 defendant Goldyng Alexander cutler 587636 587636 Goldyng, Alexander, of Hadleigh, cutler 0
4198370 2094978 2094978 defendant Gleson Thomas clerk 587636 587636 Gleson, Thomas, of Hadleigh, clerk 0
4198371 2094978 2094978 defendant Byrde William sherman 587636 587636 Byrde, William, of Hadleigh, sherman 1
4199794 2095477 2095477 defendant Holder George sherman 587636 587636 Holder, George, of Hadleigh, sherman 0
4213143 2100121 2100121 defendant Beale Thomas yeoman 587636 587636 Beale, Thomas, of Hadleigh, yeoman 1
4241963 2110303 2110303 defendant Reader Richard tailor 587636 587636 Reader, Richard, of Hadleigh, tailor 0
4241964 2110303 2110303 defendant Humfrey Henry weaver 587636 587636 Humfrey, Henry, of Hadleigh, weaver 1
4274699 2121094 2121094 defendant Hoxone alias Cresner John   587636 587636 Hoxone alias Cresner, John, of Hadleigh, husbandman, servant of James Lovell, of Horham 0
4282844 2123898 2123898 defendant Warner John clothier 587636 587636 Warner, John, of Hadleigh, clothier 0
4283159 2124009 2124009 defendant Kempe Robert brewer 587636 587636 Kempe, Robert, of Hadleigh, brewer 1
4290759 2126753 2126753 defendant Brocke Richard weaver 587636 587636 Brocke, Richard, of Hadleigh, weaver 0
4290761 2126754 2126754 defendant Brooke Richard weaver 587636 587636 Brooke, Richard, of Hadleigh, weaver 0
4305564 2132080 2132080 defendant Micklefield John barber 587636 587636 Micklefield, John, of Hadleigh, barber 0
4488096 2196995 2196995 defendant atte Stoune Thomas   587636 587636 atte Stoune, Thomas, of Hadleigh 2
4488097 2196995 2196995 defendant Greyne Thomas   587636 587636 Greyne, Thomas, of Hadleigh 3
4607271 2233386 2233386 defendant Smyth John   587636 587636 Smyth, John, of Hadleigh 1
4726243 2273494 2273494 plaintiff Greyve Thomas   587636 587636 Greyve, Thomas, of Hadleigh 0
4726244 2273494 2273494 defendant Colman John butcher 587636 587636 Colman, John, of Hadleigh, butcher 0
4746223 2279390 2279390 defendant Maycons Nicholas yeoman 587636 587636 Maycons, Nicholas, of Hadleigh, yeoman 0
4817726 2301631 2301631 plaintiff Mouchesey John   587636 587636 Mouchesey, John, of Hadleigh 0
4966454 2346900 2346900 defendant Skeet John merchant 587636 587636 Skeet, John, of Hadleigh, merchant 0
5012975 2360629 2360629 defendant Hyllary William husbandman 587636 587636 Hyllary, William, of Hadleigh, husbandman 0
5020152 2362783 2362783 plaintiff Dounton Augustine (legal representative) 587636 587636 Dounton, Augustine, of Hadleigh, executors of 0
5052515 2372345 2372345 defendant Hillary William gent 587636 587636 Hillary, William, of Hadleigh, gent 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);