names

99 rows where place_id = 597854

✎ 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
3630109 1904266 1904266 plaintiff Dyconson William yeoman 597854 597854 Dyconson, William, of Stowmarkett, yeoman 0
3630110 1904266 1904266 plaintiff Cokke William mercer 597854 597854 Cokke, William, of Stowmarkett, mercer 1
3648946 1910059 1910059 defendant Cooke Robert yeoman 597854 597854 Cooke, Robert, of Stowmarkett, yeoman 1
3711563 1929927 1929927 defendant Debyll John butcher 597854 597854 Debyll, John, of Stowmarkett, butcher 0
3729855 1935595 1935595 defendant Thorp John yeoman 597854 597854 Thorp, John, of Stowmarkett, yeoman 0
3739071 1938429 1938429 defendant Austen John weaver 597854 597854 Austen, John, of Stowmarkett, weaver 0
3760104 1945155 1945155 defendant Asten John beer brewer 597854 597854 Asten, John, of Stowmarkett, beer brewer 0
3760106 1945156 1945156 defendant Bakon Robert laborer 597854 597854 Bakon, Robert, of Stowmarkett, laborer 0
3772872 1949211 1949211 defendant Newport John dyer 597854 597854 Newport, John, of Stowmarkett, dyer 0
3786915 1953710 1953710 defendant Andrewe John clothmaker 597854 597854 Andrewe, John, of Stowmarkett, clothmaker 0
3793427 1955809 1955809 defendant Studde Richard yeoman 597854 597854 Studde, Richard, of Stowmarkett, yeoman 0
3798634 1957481 1957481 defendant Nyker Thomas carver 597854 597854 Nyker, Thomas, of Stowmarkett, carver 0
3799717 1957832 1957832 defendant Fysshe John yeoman 597854 597854 Fysshe, John, of Stowmarkett, yeoman 0
3800748 1958147 1958147 plaintiff Man John   597854 597854 Man, John, of Stowmarkett 0
3803045 1958854 1958854 defendant Andrews John clothmaker 597854 597854 Andrews, John, of Stowmarkett, clothmaker 1
3809330 1960800 1960800 defendant Symond Robert clothman 597854 597854 Symond, Robert, of Stowmarkett, clothman 1
3812509 1961800 1961800 defendant Markys William sherman 597854 597854 Markys, William, of Stowmarkett, sherman 1
3812511 1961800 1961800 defendant Edwardys Robert shoemaker 597854 597854 Edwardys, Robert, of Stowmarkett, shoemaker 3
3812547 1961812 1961812 defendant Newport John yeoman 597854 597854 Newport, John, of Stowmarkett, yeoman 1
3812548 1961812 1961812 defendant Man John yeoman 597854 597854 Man, John, of Stowmarkett, yeoman 2
3812549 1961812 1961812 defendant Benston Leonard smith 597854 597854 Benston, Leonard, of Stowmarkett, smith 3
3814347 1962400 1962400 defendant Bradwey William sherman 597854 597854 Bradwey, William, of Stowmarkett, sherman 0
3817121 1963265 1963265 defendant Padnall John butcher 597854 597854 Padnall, John, of Stowmarkett, butcher 0
3818581 1963713 1963713 defendant Edward Robert shoemaker 597854 597854 Edward, Robert, of Stowmarkett, shoemaker 3
3822266 1964868 1964868 defendant Mannyng Walter clothmaker 597854 597854 Mannyng, Walter, of Stowmarkett, clothmaker 0
3823130 1965145 1965145 defendant Edwardys Robert shoemaker 597854 597854 Edwardys, Robert, of Stowmarkett, shoemaker 2
3842128 1971089 1971089 plaintiff Bradwey Richard (legal representative) 597854 597854 Bradwey, Richard, of Stowmarkett, yeoman, executor of 0
3843214 1971410 1971410 defendant Pykerell John clothman 597854 597854 Pykerell, John, of Stowmarkett, clothman 1
3855380 1975323 1975323 defendant Bakk John yeoman 597854 597854 Bakk, John, of Stowmarkett, yeoman 0
3859699 1976743 1976743 defendant Browne William husbandman 597854 597854 Browne, William, of Stowmarkett, husbandman 0
3861858 1977425 1977425 defendant Grene John husbandman 597854 597854 Grene, John, of Stowmarkett, husbandman 0
3861927 1977449 1977449 defendant Fysshe John yeoman 597854 597854 Fysshe, John, of Stowmarkett, yeoman 0
3866645 1979076 1979076 defendant Pykerell John fuller 597854 597854 Pykerell, John, of Stowmarkett, fuller 0
3893209 1987966 1987966 defendant Man John yeoman 597854 597854 Man, John, of Stowmarkett, yeoman 2
3893919 1988189 1988189 defendant Thorpe John yeoman 597854 597854 Thorpe, John, of Stowmarkett, yeoman 1
3906988 1992624 1992624 defendant Manne John yeoman 597854 597854 Manne, John, of Stowmarkett, yeoman 3
3911020 1994011 1994011 defendant Wynde John weaver 597854 597854 Wynde, John, of Stowmarkett, weaver 0
3914034 1995038 1995038 defendant Edward Andrew innkeeper 597854 597854 Edward, Andrew, of Stowmarkett, innkeeper 1
3918575 1996538 1996538 plaintiff Howse John draper 597854 597854 Howse, John, of Stowmarkett, draper 0
3924789 1998608 1998608 defendant Man John yeoman 597854 597854 Man, John, of Stowmarkett, yeoman 2
3924790 1998608 1998608 defendant Mannyng Thomas shoemaker 597854 597854 Mannyng, Thomas, of Stowmarkett, shoemaker 3
3965488 2012540 2012540 defendant Barton John grocer 597854 597854 Barton, John, of Stowmarkett, or of Ipswich, Suff, grocer 0
3973963 2015465 2015465 defendant Kembold John husbandman 597854 597854 Kembold, John, of Stowmarkett, husbandman 0
3975028 2015828 2015828 defendant Forde William husbandman 597854 597854 Forde, William, of Stowmarkett, husbandman 0
3975029 2015828 2015828 defendant Forde Thomas husbandman 597854 597854 Forde, Thomas, of Stowmarkett, husbandman 1
3975363 2015950 2015950 plaintiff Howse John, senior clothier 597854 597854 Howse, John, senior, of Stowmarkett, clothier 0
3982525 2018525 2018525 plaintiff Scarlett Robert clothier 597854 597854 Scarlett, Robert, of Stowmarkett, clothier 0
3982627 2018557 2018557 defendant Skewpeye Richard butcher 597854 597854 Skewpeye, Richard, of Stowmarkett, butcher 1
3985986 2019756 2019756 plaintiff Watton John sherman 597854 597854 Watton, John, of Stowmarkett, sherman 0
4072834 2050583 2050583 defendant Brydges Thomas shoemaker 597854 597854 Brydges, Thomas, of Stowmarkett, shoemaker 0
4072835 2050583 2050583 defendant Brydges John shoemaker 597854 597854 Brydges, John, of Stowmarkett, shoemaker 1
4072837 2050583 2050583 defendant Partryche William husbandman 597854 597854 Partryche, William, of Stowmarkett, husbandman 3
4109135 2063521 2063521 defendant Tosse Thomas husbandman 597854 597854 Tosse, Thomas, of Stowmarkett, husbandman 2
4113620 2065152 2065152 defendant Bumpsted Thomas tanner 597854 597854 Bumpsted, Thomas, of Stowmarkett, tanner 0
4118612 2066950 2066950 defendant Cotwyn Christopher husbandman 597854 597854 Cotwyn, Christopher, of Stowmarkett, husbandman 0
4118613 2066950 2066950 defendant Constable Richard husbandman 597854 597854 Constable, Richard, of Stowmarkett, husbandman 1
4130114 2071077 2071077 defendant Courtnall Edward clothier 597854 597854 Courtnall, Edward, of Stowmarkett, clothier 0
4143978 2076056 2076056 defendant Courtnall John yeoman 597854 597854 Courtnall, John, of Stowmarkett, or of Ailesborne, yeoman 1
4159732 2081471 2081471 defendant Sadde Edmund husbandman 597854 597854 Sadde, Edmund, of Stowmarkett, husbandman 1
4163795 2082863 2082863 defendant Lylley Stephen grocer 597854 597854 Lylley, Stephen, of Stowmarkett, grocer 0
4173066 2086036 2086036 defendant Mathewe William yeoman 597854 597854 Mathewe, William, of Stowmarkett, yeoman 0
4191923 2092735 2092735 defendant Mason William ashburner 597854 597854 Mason, William, of Stowmarkett, ashburner 0
4196156 2094202 2094202 defendant Curtnall Nicholas yeoman 597854 597854 Curtnall, Nicholas, of Stowmarkett, yeoman 0
4198582 2095061 2095061 defendant Mason William   597854 597854 Mason, William, of Stowmarkett, ash burner 0
4202742 2096503 2096503 defendant Bett William tanner 597854 597854 Bett, William, of Stowmarkett, or of Pakenham, tanner 0
4203640 2096830 2096830 defendant Bradwey Giles carpenter 597854 597854 Bradwey, Giles, of Stowmarkett, carpenter 0
4206611 2097852 2097852 defendant Paynter Thomas clothier 597854 597854 Paynter, Thomas, of Stowmarkett, clothier 0
4209760 2098970 2098970 defendant Coper Thomas yeoman 597854 597854 Coper, Thomas, of Stowmarkett, yeoman 1
4218055 2101812 2101812 defendant Playstoo William   597854 597854 Playstoo, William, of Stowmarkett, apothecary 1
4218145 2101845 2101845 defendant Forrest John tailor 597854 597854 Forrest, John, of Stowmarkett, tailor 0
4233626 2107282 2107282 defendant Partriche Peter yeoman 597854 597854 Partriche, Peter, of Stowmarkett, yeoman 3
4237701 2108784 2108784 defendant Fyske Benjamin gent 597854 597854 Fyske, Benjamin, of Stowmarkett, gent 1
4244129 2111019 2111019 defendant Playstoe William   597854 597854 Playstoe, William, of Stowmarkett 1
4244801 2111249 2111249 defendant Partriche Peter yeoman 597854 597854 Partriche, Peter, of Stowmarkett, yeoman 2
4246325 2111748 2111748 defendant Fiske Benjamin gent 597854 597854 Fiske, Benjamin, of Stowmarkett, gent 1
4247763 2112236 2112236 defendant Playston William   597854 597854 Playston, William, of Stowmarkett, or of Hadleighe, apothecary 0
4260333 2116423 2116423 defendant Playston William   597854 597854 Playston, William, of Stowmarkett, apothecary 0
4274774 2121122 2121122 defendant Dyer Richard laborer 597854 597854 Dyer, Richard, of Stowmarkett, laborer 1
4274776 2121122 2121122 defendant Stephens Robert shoemaker 597854 597854 Stephens, Robert, of Stowmarkett, shoemaker 3
4279627 2122792 2122792 defendant Richman Robert yeoman 597854 597854 Richman, Robert, of Stowmarkett, yeoman 1
4282094 2123638 2123638 defendant Barnard alias Mller Thomas yeoman 597854 597854 Barnard alias Mller, Thomas, of Stowmarkett, yeoman 0
4302075 2130846 2130846 defendant Kinge Robert tailor 597854 597854 Kinge, Robert, of Stowmarkett, tailor 1
4303450 2131336 2131336 defendant Payne John mercer 597854 597854 Payne, John, of Stowmarkett, mercer 0
4303451 2131336 2131336 defendant Payne Henry mercer 597854 597854 Payne, Henry, of Stowmarkett, mercer 1
4305261 2131978 2131978 defendant Scrutton or Strutton Richard clothier 597854 597854 Scrutton or Strutton, Richard, of Stowmarkett, clothier 1
4336317 2142438 2142438 defendant Smyth Richard clothier 597854 597854 Smyth, Richard, of Stowmarkett, clothier 0
4336605 2142529 2142529 defendant Howse Robert goldsmith 597854 597854 Howse, Robert, of Stowmarkett, goldsmith 0
4340132 2143811 2143811 defendant Trew James yeoman 597854 597854 Trew, James, of Stowmarkett, yeoman 0
4346308 2145964 2145964 defendant Howe Richard gent 597854 597854 Howe, Richard, of Stowmarkett, gent 0
4347909 2146521 2146521 defendant Danyell Robert yeoman 597854 597854 Danyell, Robert, of Stowmarkett, yeoman 0
4347910 2146521 2146521 defendant Beast John yeoman 597854 597854 Beast, John, of Stowmarkett, yeoman 1
4350232 2147341 2147341 defendant Langham Richard yeoman 597854 597854 Langham, Richard, of Stowmarkett, yeoman 0
4393788 2162525 2162525 defendant Gerrard William butcher 597854 597854 Gerrard, William, of Stowmarkett, butcher 2
4393789 2162525 2162525 defendant Brame or Braine Robert butcher 597854 597854 Brame or Braine, Robert, of Stowmarkett, butcher 3
4397684 2163803 2163803 defendant Welles John tinker 597854 597854 Welles, John, of Stowmarkett, tinker 1
4397685 2163803 2163803 defendant Lowthe William pewterer 597854 597854 Lowthe, William, of Stowmarkett, pewterer 2
4397689 2163804 2163804 defendant Welles John tinker 597854 597854 Welles, John, of Stowmarkett, tinker 1
4397690 2163804 2163804 defendant Lowthe William pewterer 597854 597854 Lowthe, William, of Stowmarkett, pewterer 2
4401826 2165207 2165207 defendant Kedgell Edmund   597854 597854 Kedgell, Edmund, of Stowmarkett, Suff clothier 1

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