names

67 rows where place_id = 663980

✎ 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
3970974 2014404 2014404 defendant Wylcoke Roger husbandman 663980 663980 Wylcoke, Roger, of Shouldham, husbandman 1
3978210 2016960 2016960 defendant Harvye John husbandman 663980 663980 Harvye, John, of Shouldham, husbandman 0
3983186 2018759 2018759 plaintiff Smyth Leonard esq 663980 663980 Smyth, Leonard, of Shouldham, esq 0
4000902 2025093 2025093 defendant Eldyng John, senior husbandman 663980 663980 Eldyng, John, senior, of Shouldham, husbandman 0
4029364 2035142 2035142 defendant Stoneham Alice spinster 663980 663980 together with Stoneham, Alice, of Shouldham, spinster 1
4054689 2044066 2044066 defendant Dallyson Bartholomew weaver 663980 663980 Dallyson, Bartholomew, of Shouldham, weaver 1
4057940 2045221 2045221 defendant Phillippe Richard husbandman 663980 663980 Phillippe, Richard, of Shouldham, husbandman 3
4058348 2045370 2045370 defendant Cooke William husbandman 663980 663980 Cooke, William, of Shouldham, husbandman 0
4058349 2045370 2045370 defendant Odams Joan widow 663980 663980 Odams, Joan, of Shouldham, widow 1
4062675 2046948 2046948 defendant Cates Thomas husbandman 663980 663980 Cates, Thomas, of Shouldham, husbandman 4
4079866 2053099 2053099 defendant Rixe Thomas husbandman 663980 663980 Rixe, Thomas, of Shouldham, husbandman 6
4088543 2056202 2056202 defendant Andrewes Thomas husbandman 663980 663980 Andrewes, Thomas, of Shouldham, husbandman 0
4092071 2057460 2057460 defendant Hunt John husbandman 663980 663980 Hunt, John, of Shouldham, husbandman 3
4094959 2058525 2058525 defendant Dobbes Thomas yeoman 663980 663980 Dobbes, Thomas, of Shouldham, yeoman 2
4097787 2059541 2059541 defendant Browne Henry husbandman 663980 663980 Browne, Henry, of Shouldham, husbandman 0
4097788 2059541 2059541 defendant Rixe Thomas husbandman 663980 663980 Rixe, Thomas, of Shouldham, husbandman 1
4104721 2061969 2061969 defendant Wylcoke Henry schoolmaster 663980 663980 Wylcoke, Henry, of Shouldham, schoolmaster 0
4104722 2061969 2061969 defendant Wylcoke Roger husbandman 663980 663980 Wylcoke, Roger, of Shouldham, husbandman 1
4104723 2061969 2061969 defendant Gyrlynge John   663980 663980 Gyrlynge, John, of Shouldham, minstrel 2
4116496 2066188 2066188 defendant Fillipes or Phillipes Richard husbandman 663980 663980 Fillipes or Phillipes, Richard, of Shouldham, husbandman 1
4126249 2069678 2069678 defendant Smyth Leonard gent 663980 663980 Smyth, Leonard, of Shouldham, gent 1
4139226 2074398 2074398 defendant Parkyn alias Wolman Robert yeoman 663980 663980 Parkyn alias Wolman, Robert, of Shouldham, yeoman 0
4147658 2077322 2077322 defendant Phillipp Richard yeoman 663980 663980 Phillipp, Richard, of Shouldham, yeoman 1
4158416 2081014 2081014 defendant Newlande Charles husbandman 663980 663980 Newlande, Charles, of Shouldham, husbandman 2
4158417 2081014 2081014 defendant Harr Bartholomew husbandman 663980 663980 Harr, Bartholomew, of Shouldham, husbandman 3
4158431 2081020 2081020 defendant Gates Thomas husbandman 663980 663980 Gates, Thomas, of Shouldham, husbandman 1
4158432 2081020 2081020 defendant Johnson John husbandman 663980 663980 Johnson, John, of Shouldham, husbandman 2
4163940 2082917 2082917 defendant Parkyn alias Wolman Robert yeoman 663980 663980 Parkyn alias Wolman, Robert, of Shouldham, yeoman 0
4171061 2085359 2085359 defendant Gybbes Richard butcher 663980 663980 Gybbes, Richard, of Shouldham, butcher 2
4181917 2089156 2089156 defendant Atkynson James husbandman 663980 663980 Atkynson, James, of Shouldham, husbandman 0
4181919 2089156 2089156 defendant Roo John husbandman 663980 663980 Roo, John, of Shouldham, husbandman 2
4181920 2089156 2089156 defendant Gybbes Richard husbandman 663980 663980 Gybbes, Richard, of Shouldham, husbandman 3
4210057 2099079 2099079 defendant Dune Thomas husbandman 663980 663980 Dune, Thomas, of Shouldham, husbandman 1
4217654 2101667 2101667 defendant Pecocke Henry blacksmith 663980 663980 Pecocke, Henry, of Shouldham, yeoman, blacksmith 3
4230227 2106059 2106059 defendant Phillippe Richard husbandman 663980 663980 Phillippe, Richard, of Shouldham, husbandman 0
4230228 2106059 2106059 defendant Porler Thomas husbandman 663980 663980 Porler, Thomas, of Shouldham, husbandman 1
4241263 2110062 2110062 defendant Blomefeld John weaver 663980 663980 Blomefeld, John, of Shouldham, weaver 1
4241266 2110063 2110063 defendant Blomefeld John weaver 663980 663980 Blomefeld, John, of Shouldham, weaver 1
4243873 2110931 2110931 defendant Pecocke Henry blacksmith 663980 663980 Pecocke, Henry, of Shouldham, yeoman, blacksmith 3
4249705 2112886 2112886 defendant Hawfyn or Hawsyn John warrener 663980 663980 Hawfyn or Hawsyn, John, of Shouldham, warrener 0
4249707 2112886 2112886 defendant Jameson William husbandman 663980 663980 Jameson, William, of Shouldham, husbandman 2
4249708 2112886 2112886 defendant Lerkyn Christopher husbandman 663980 663980 Lerkyn, Christopher, of Shouldham, husbandman 3
4250316 2113086 2113086 defendant Blomfeld John weaver 663980 663980 Blomfeld, John, of Shouldham, weaver 1
4254819 2114605 2114605 defendant Gyrselton John husbandman 663980 663980 Gyrselton, John, of Shouldham, husbandman 1
4254820 2114605 2114605 defendant Gyrlyn John   663980 663980 Gyrlyn, John, of Shouldham, yeoman, musician 2
4261613 2116842 2116842 defendant Smyth Leonard gent 663980 663980 Smyth, Leonard, of Shouldham, gent 3
4274286 2120952 2120952 defendant Peacocke Henry blacksmith 663980 663980 Peacocke, Henry, of Shouldham, blacksmith 0
4285234 2124770 2124770 defendant Gibbes Richard butcher 663980 663980 Gibbes, Richard, of Shouldham, butcher 1
4320808 2137371 2137371 defendant Smythe Leonard gent 663980 663980 Smythe, Leonard, of Shouldham, gent 0
4353670 2148503 2148503 defendant Semans Ralph laborer 663980 663980 Semans, Ralph, of Shouldham, laborer 1
4353671 2148503 2148503 defendant Lockwoode Henry, junior laborer 663980 663980 Lockwoode, Henry, junior, of Shouldham, laborer 2
4353672 2148503 2148503 defendant Tode Edward laborer 663980 663980 Tode, Edward, of Shouldham, laborer 3
4367663 2153488 2153488 defendant Gresselton John (legal representative) 663980 663980 Gresselton, John, of Shouldham, executors of 0
4367666 2153489 2153489 defendant Gresselton John (legal representative) 663980 663980 Gresselton, John, of Shouldham, executors of 0
4391039 2161621 2161621 defendant Lockwood Henry yeoman 663980 663980 Lockwood, Henry, of Shouldham, yeoman 0
4393101 2162300 2162300 defendant Phillippes Richard husbandman 663980 663980 Phillippes, Richard, of Shouldham, husbandman 2
4393634 2162476 2162476 defendant Richardson John tailor 663980 663980 Richardson, John, of Shouldham, tailor 2
4393635 2162476 2162476 defendant Kenyon John clerk 663980 663980 Kenyon, John, of Shouldham, clerk 3
4393658 2162481 2162481 defendant Laykyn Christopher yeoman 663980 663980 Laykyn, Christopher, of Shouldham, yeoman 3
4394957 2162898 2162898 defendant Perte Edmund yeoman 663980 663980 Perte, Edmund, of Shouldham, yeoman 2
4406654 2166789 2166789 defendant Phillippes Richard husbandman 663980 663980 Phillippes, Richard, of Shouldham, husbandman 3
4406662 2166793 2166793 defendant Gybbes Richard butcher 663980 663980 Gybbes, Richard, of Shouldham, butcher 0
4410059 2167970 2167970 defendant Peart Edmund husbandman 663980 663980 Peart, Edmund, of Shouldham, husbandman 0
4487197 2196719 2196719 defendant Ode John, senior   663980 663980 Ode, John, senior, of Shouldham 0
4649180 2245810 2245810 defendant Tylney John   663980 663980 Tylney, John, of Shouldham 1
4686688 2261448 2261448 defendant Caute William laborer 663980 663980 Caute, William, of Shouldham, laborer 0
4712338 2269173 2269173 defendant Bante William laborer 663980 663980 Bante, William, of Shouldham, laborer 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);