names

81 rows where place_id = 588848

✎ 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
3595771 1866309 1866309 defendant Norman Nicholas yeoman 588848 588848 Norman, Nicholas, of Magna Dunham, yeoman 0
3625702 1875576 1875576 defendant Wynne Christopher clerk 588848 588848 Wynne, Christopher, of Magna Dunham, clerk 2
3625703 1875576 1875576 defendant Lewys William laborer 588848 588848 Lewys, William, of Magna Dunham, laborer 3
3668337 1916044 1916044 defendant Markaunt John yeoman 588848 588848 Markaunt, John, of Magna Dunham, yeoman 1
3708608 1928992 1928992 defendant Marham Richard husbandman 588848 588848 Marham, Richard, of Magna Dunham, husbandman 1
3708911 1929078 1929078 defendant Johnson Lawrence butcher 588848 588848 Johnson, Lawrence, of Magna Dunham, butcher 1
3711990 1930068 1930068 defendant Marham Richard husbandman 588848 588848 Marham, Richard, of Magna Dunham, husbandman 0
3712459 1930213 1930213 defendant Smyth William husbandman 588848 588848 Smyth, William, of Magna Dunham, husbandman 0
3753884 1943162 1943162 defendant Godfrey William smith 588848 588848 Godfrey, William, of Magna Dunham, smith 1
3819879 1964098 1964098 defendant Wentlond John butcher 588848 588848 Wentlond, John, of Magna Dunham, butcher 0
3823988 1965378 1965378 defendant Smyth William husbandman 588848 588848 Smyth, William, of Magna Dunham, husbandman 0
3833717 1968476 1968476 defendant Wyngfeld Thomas esq 588848 588848 Wyngfeld, Thomas, of Magna Dunham, esq 0
3833718 1968476 1968476 defendant Boham Nicholas gent 588848 588848 Boham, Nicholas, of Magna Dunham, gent 1
3849471 1973435 1973435 defendant Wyngfeld Thomas esq 588848 588848 Wyngfeld, Thomas, of Magna Dunham, esq 0
3858109 1976191 1976191 defendant Wyngfeld Thomas esq 588848 588848 Wyngfeld, Thomas, of Magna Dunham, esq 0
3863904 1978102 1978102 defendant Wyngfeld Thomas esq 588848 588848 Wyngfeld, Thomas, of Magna Dunham, esq 0
3864486 1978322 1978322 defendant Wyngfeld Thomas esq 588848 588848 Wyngfeld, Thomas, of Magna Dunham, esq 0
3864605 1978357 1978357 defendant Wyngfeld Thomas esq 588848 588848 Wyngfeld, Thomas, of Magna Dunham, esq 0
3898260 1989627 1989627 defendant Mundye John husbandman 588848 588848 Mundye, John, of Magna Dunham, husbandman 0
3902849 1991186 1991186 defendant Smyth Katherine widow 588848 588848 Smyth, Katherine, of Magna Dunham, widow 0
3902866 1991192 1991192 defendant Smyth Katherine widow 588848 588848 Smyth, Katherine, of Magna Dunham, widow 0
3918200 1996420 1996420 defendant Fludd Nicholas husbandman 588848 588848 Fludd, Nicholas, of Magna Dunham, husbandman 1
3956238 2009244 2009244 defendant Griffyn John laborer 588848 588848 Griffyn, John, of Magna Dunham, laborer 1
4056769 2044804 2044804 defendant Newman Robert yeoman 588848 588848 Newman, Robert, of Magna Dunham, yeoman 0
4100891 2060634 2060634 defendant Tytsal Henry husbandman 588848 588848 Tytsal, Henry, of Magna Dunham, husbandman 0
4100895 2060635 2060635 defendant Tytsale Henry husbandman 588848 588848 Tytsale, Henry, of Magna Dunham, husbandman 0
4121215 2067882 2067882 defendant Blomevyle George husbandman 588848 588848 Blomevyle, George, of Magna Dunham, husbandman 0
4129131 2070723 2070723 defendant Gryffyn William   588848 588848 Gryffyn, William, of Magna Dunham, ploughwright 2
4133623 2072358 2072358 defendant Newman Robert yeoman 588848 588848 Newman, Robert, of Magna Dunham, yeoman 0
4240713 2109875 2109875 defendant Barker Robert, junior yeoman 588848 588848 Barker, Robert, junior, of Magna Dunham, yeoman 0
4240723 2109878 2109878 defendant Crosse Marion widow 588848 588848 Crosse, Marion, of Magna Dunham, widow 4
4240729 2109879 2109879 defendant Crosse Marion widow 588848 588848 Crosse, Marion, of Magna Dunham, widow 4
4244436 2111118 2111118 defendant Barker Robert yeoman 588848 588848 Barker, Robert, of Magna Dunham, yeoman 0
4247113 2112008 2112008 defendant Barker Robert, junior yeoman 588848 588848 Barker, Robert, junior, of Magna Dunham, yeoman 0
4248114 2112358 2112358 defendant Barker Robert, junior yeoman 588848 588848 Barker, Robert, junior, of Magna Dunham, yeoman 0
4277785 2122154 2122154 defendant Barker Robert, junior yeoman 588848 588848 Barker, Robert, junior, of Magna Dunham, yeoman 3
4278301 2122349 2122349 defendant Chadwicke alias Smyth Brimsted or Brunsted husbandman 588848 588848 Chadwicke alias Smyth, Brimsted or Brunsted, of Magna Dunham, husbandman 0
4278302 2122349 2122349 defendant Crosse Simon husbandman 588848 588848 Crosse, Simon, of Magna Dunham, husbandman 1
4290682 2126725 2126725 defendant Barker Robert, junior yeoman 588848 588848 Barker, Robert, junior, of Magna Dunham, yeoman 0
4319446 2136909 2136909 defendant Berker Robert, junior yeoman 588848 588848 Berker, Robert, junior, of Magna Dunham, yeoman 0
4397360 2163695 2163695 defendant Corsse Anthony husbandman 588848 588848 Corsse, Anthony, of Magna Dunham, husbandman 2
4788019 2292321 2292321 defendant Golde John yeoman 588848 588848 Golde, John, of Magna Dunham, yeoman 0
4788020 2292321 2292321 defendant Gurre Richard yeoman 588848 588848 Gurre, Richard, of Magna Dunham, yeoman 1
4866580 2316509 2316509 defendant Reymond Henry baker 588848 588848 Reymond, Henry, of Magna Dunham, baker 1
4892971 2324527 2324527 defendant Gurre Richard laborer 588848 588848 Gurre, Richard, of Magna Dunham, laborer 0
4892972 2324527 2324527 defendant Broun Henry laborer 588848 588848 Broun, Henry, of Magna Dunham, laborer 1
4892973 2324527 2324527 defendant Stoke Robert laborer 588848 588848 Stoke, Robert, of Magna Dunham, laborer 2
4892974 2324527 2324527 defendant Norman William yeoman 588848 588848 Norman, William, of Magna Dunham, yeoman 3
4944441 2340241 2340241 defendant Crosse Robert yeoman 588848 588848 Crosse, Robert, of Magna Dunham, yeoman 1
4953811 2343100 2343100 defendant Smyth John yeoman 588848 588848 Smyth, John, of Magna Dunham, yeoman 0
4956965 2344040 2344040 defendant Webster Geoffrey husbandman 588848 588848 Webster, Geoffrey, of Magna Dunham, husbandman 0
5064229 2375845 2375845 defendant Mynne John laborer 588848 588848 Mynne, John, of Magna Dunham, laborer 0
5075070 2379046 2379046 defendant Palmer John yeoman 588848 588848 Palmer, John, of Magna Dunham, smith, or of Bury St Edmunds, yeoman 0
5076975 2379610 2379610 defendant Umfrey John laborer 588848 588848 Umfrey, John, of Magna Dunham, laborer 1
5118399 2391817 2391817 defendant Markaunt Richard husbandman 588848 588848 Markaunt, Richard, of Magna Dunham, husbandman 0
5232283 2425020 2425020 plaintiff Broun Geoffrey clerk 588848 588848 Broun, Geoffrey, of Magna Dunham, clerk 0
5262194 2433925 2433925 plaintiff Norman William yeoman 588848 588848 Norman, William, of Magna Dunham, yeoman 0
5262198 2433925 2433925 defendant Markanth Richard (legal representative) 588848 588848 Markanth, Richard, of Magna Dunham, husbandman, executors of 2
5262199 2433925 2433925 defendant Mower William husbandman 588848 588848 (Mower, William, of Magna Dunham, husbandman 3
5262200 2433925 2433925 defendant Crosse Geoffrey husbandman 588848 588848 Crosse, Geoffrey, of Magna Dunham, husbandman 4
5289222 2441852 2441852 defendant Walysshman John husbandman 588848 588848 Walysshman, John, of Magna Dunham, husbandman 0
5290378 2442190 2442190 plaintiff Norman William   588848 588848 Norman, William, of Magna Dunham 0
5323164 2452010 2452010 defendant Lewys William laborer 588848 588848 Lewys, William, of Magna Dunham, laborer 2
5336007 2455842 2455842 defendant Marcaunt John husbandman 588848 588848 Marcaunt, John, of Magna Dunham, husbandman 0
5353962 2461302 2461302 defendant Marcaunt John husbandman 588848 588848 Marcaunt, John, of Magna Dunham, husbandman 0
5480585 2499165 2499165 defendant Broun Thomas yeoman 588848 588848 Broun, Thomas, of Magna Dunham, yeoman 11
5480595 2499166 2499166 defendant Broun Thomas yeoman 588848 588848 Broun, Thomas, of Magna Dunham, yeoman 8
5484823 2500384 2500384 defendant Walssheman John laborer 588848 588848 Walssheman, John, of Magna Dunham, laborer 0
5484826 2500384 2500384 defendant Smyth Henry husbandman 588848 588848 Smyth, Henry, of Magna Dunham, husbandman 3
5490295 2501983 2501983 defendant Markant John husbandman 588848 588848 Markant, John, of Magna Dunham, husbandman 1
5490650 2502094 2502094 defendant Markaunt John husbandman 588848 588848 Markaunt, John, of Magna Dunham, husbandman 1
5490651 2502094 2502094 defendant Walsshman John laborer 588848 588848 Walsshman, John, of Magna Dunham, laborer 2
5490652 2502094 2502094 defendant Godeale John husbandman 588848 588848 Godeale, John, of Magna Dunham, husbandman 3
5491520 2502347 2502347 defendant Markaunt John husbandman 588848 588848 Markaunt, John, of Magna Dunham, husbandman 1
5498424 2504486 2504486 defendant Howys Thomas husbandman 588848 588848 Howys, Thomas, of Magna Dunham, husbandman 3
5511184 2508337 2508337 defendant Mendham John chaplain 588848 588848 Mendham, John, of Magna Dunham, chaplain 0
5516355 2509947 2509947 defendant Godale John husbandman 588848 588848 Godale, John, of Magna Dunham, husbandman 3
5530499 2514055 2514055 defendant Hyllyngton Richard thatcher 588848 588848 Hyllyngton, Richard, of Magna Dunham, thatcher 2
5559996 2522879 2522879 defendant Wynne Christopher clerk 588848 588848 Wynne, Christopher, of Magna Dunham, clerk 1
5565517 2524511 2524511 defendant Smyth Henry husbandman 588848 588848 Smyth, Henry, of Magna Dunham, husbandman 0
5601297 2535298 2535298 defendant Storour John painter 588848 588848 Storour, John, of Magna Dunham, painter 0

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