names

63 rows where place_id = 586400

✎ 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
3588622 1864085 1864085 defendant Drake Thomas husbandman 586400 586400 Drake, Thomas, of Pulham St Mary, husbandman 1
3588634 1864088 1864088 defendant Drake Thomas husbandman 586400 586400 Drake, Thomas, of Pulham St Mary, husbandman 1
3626220 1903057 1903057 defendant Cobbe John husbandman 586400 586400 Cobbe, John, of Pulham St Mary, husbandman, son of Cobbe, William, of Pulham St Mary, husbandman 0
3626221 1903057 1903057 defendant Ruddyng John husbandman 586400 586400 Ruddyng, John, of Pulham St Mary, husbandman 1
3667861 1915888 1915888 defendant Asseby Robert yeoman 586400 586400 Asseby, Robert, of Pulham St Mary, yeoman 0
3690200 1923093 1923093 defendant Sancroft Edward husbandman 586400 586400 Sancroft, Edward, of Pulham St Mary, husbandman 0
3704637 1927736 1927736 defendant Sancroft Edward husbandman 586400 586400 Sancroft, Edward, of Pulham St Mary, husbandman 0
3742808 1939604 1939604 defendant Felde Thomas husbandman 586400 586400 Felde, Thomas, of Pulham St Mary, husbandman 2
3763873 1946343 1946343 defendant Godram Nicholas husbandman 586400 586400 Godram, Nicholas, of Pulham St Mary, husbandman 0
3780680 1951687 1951687 defendant Sancroft Edward husbandman 586400 586400 Sancroft, Edward, of Pulham St Mary, husbandman 1
3780889 1951756 1951756 defendant Riche John husbandman 586400 586400 Riche, John, of Pulham St Mary, husbandman 2
3797483 1957102 1957102 defendant Cobbe Robert yeoman 586400 586400 Cobbe, Robert, of Pulham St Mary, yeoman 0
3841389 1970887 1970887 defendant Harvy John husbandman 586400 586400 Harvy, John, of Pulham St Mary, husbandman 0
3841391 1970888 1970888 defendant Harvy John husbandman 586400 586400 Harvy, John, of Pulham St Mary, husbandman 0
3851575 1974080 1974080 defendant Riche John husbandman 586400 586400 Riche, John, of Pulham St Mary, husbandman 2
3863139 1977874 1977874 defendant Bircham William husbandman 586400 586400 Bircham, William, of Pulham St Mary, husbandman 1
3891465 1987413 1987413 defendant Smyth John (legal representative) 586400 586400 Smyth, John, of Pulham St Mary, husbandman, executors of 0
3891466 1987413 1987413 defendant Calle John mercer 586400 586400 (Calle, John, of Pulham St Mary, mercer 1
3902614 1991107 1991107 defendant Goderham John tailor 586400 586400 Goderham, John, of Pulham St Mary, tailor 2
3904053 1991598 1991598 defendant Sayer Thomas husbandman 586400 586400 Sayer, Thomas, of Pulham St Mary, husbandman 0
3904055 1991599 1991599 defendant Sayer Thomas husbandman 586400 586400 Sayer, Thomas, of Pulham St Mary, husbandman 0
3919165 1996736 1996736 defendant Lawter Godfrey (legal representative) 586400 586400 Lawter, Godfrey, of Pulham St Mary, chaplain, administrator of 0
3919494 1996851 1996851 defendant Baldry John   586400 586400 Baldry, John, of Pulham St Mary, coverlet weaver 0
3919495 1996851 1996851 defendant Bryccheham William husbandman 586400 586400 Bryccheham, William, of Pulham St Mary, husbandman 1
3920497 1997205 1997205 defendant Morfewe Robert husbandman 586400 586400 Morfewe, Robert, of Pulham St Mary, husbandman 0
3922003 1997704 1997704 defendant Baldry John   586400 586400 Baldry, John, of Pulham St Mary, coverlet weaver 0
3922005 1997704 1997704 defendant Byrcham Thomas   586400 586400 Byrcham, Thomas, of Pulham St Mary, coverlet weaver 2
3922011 1997705 1997705 defendant Baldry John   586400 586400 Baldry, John, of Pulham St Mary, coverlet weaver 0
3922012 1997705 1997705 defendant Byrcham Thomas   586400 586400 Byrcham, Thomas, of Pulham St Mary, coverlet weaver 1
3922018 1997706 1997706 defendant Baldrye John   586400 586400 Baldrye, John, of Pulham St Mary, coverlet weaver 0
3922025 1997707 1997707 defendant Bircheham William husbandman 586400 586400 Bircheham, William, of Pulham St Mary, husbandman 0
3922031 1997708 1997708 defendant Bircheham William husbandman 586400 586400 Bircheham, William, of Pulham St Mary, husbandman 0
3922037 1997709 1997709 defendant Bircheham William husbandman 586400 586400 Bircheham, William, of Pulham St Mary, husbandman 0
3922110 1997718 1997718 defendant Baldry John   586400 586400 Baldry, John, of Pulham St Mary, coverlet weaver 2
3922118 1997719 1997719 defendant Baldry John   586400 586400 Baldry, John, of Pulham St Mary, coverlet weaver 2
3929941 2000356 2000356 defendant Aylmer Nicholas butcher 586400 586400 Aylmer, Nicholas, of Pulham St Mary, butcher 1
3942217 2004414 2004414 defendant Milles John husbandman 586400 586400 Milles, John, of Pulham St Mary, husbandman 1
3942218 2004414 2004414 defendant Bache John cooper 586400 586400 Bache, John, of Pulham St Mary, cooper 2
3942221 2004415 2004415 defendant Tylles John husbandman 586400 586400 Tylles, John, of Pulham St Mary, husbandman 1
3942222 2004415 2004415 defendant Bache John cooper 586400 586400 Bache, John, of Pulham St Mary, cooper 2
3966110 2012770 2012770 defendant Marlyng Robert yeoman 586400 586400 Marlyng, Robert, of Pulham St Mary, yeoman 2
3977585 2016730 2016730 plaintiff Taylor Christopher   586400 586400 Taylor, Christopher, of Pulham St Mary 2
3980820 2017904 2017904 defendant Sparham John joiner 586400 586400 Sparham, John, of Pulham St Mary, joiner 1
4127841 2070247 2070247 defendant Sayer John yeoman 586400 586400 Sayer, John, of Pulham St Mary, yeoman 0
4127842 2070247 2070247 defendant Sayer Thomas yeoman 586400 586400 Sayer, Thomas, of Pulham St Mary, yeoman 1
4133294 2072231 2072231 defendant Emery Jerome clerk 586400 586400 Emery, Jerome, of Pulham St Mary, clerk 2
4147527 2077276 2077276 defendant Browne Thomas clerk 586400 586400 Browne, Thomas, of Pulham St Mary, clerk 0
4154236 2079577 2079577 defendant Cooke Edmund tailor 586400 586400 Cooke, Edmund, of Pulham St Mary, tailor 0
4202482 2096409 2096409 defendant Pynnocke John yeoman 586400 586400 Pynnocke, John, of Pulham St Mary, yeoman 1
4272531 2120389 2120389 defendant Browne Thomas glover 586400 586400 Browne, Thomas, of Pulham St Mary, glover 0
4285659 2124923 2124923 defendant Prentyce John yeoman 586400 586400 together with Prentyce, John, of Pulham St Mary, yeoman 1
4289352 2126253 2126253 defendant Jex Thomas weaver 586400 586400 Jex, Thomas, of Pulham St Mary, weaver 0
4289355 2126253 2126253 defendant Browne Thomas glover 586400 586400 Browne, Thomas, of Pulham St Mary, glover 3
4360842 2151045 2151045 defendant Cobbe Robert reeder 586400 586400 Cobbe, Robert, of Pulham St Mary, reeder 1
4386336 2160108 2160108 defendant Cobbe Robert reeder 586400 586400 Cobbe, Robert, of Pulham St Mary, reeder 1
5533792 2515116 2515116 defendant Kyrrych William weaver 586400 586400 Kyrrych, William, of Pulham St Mary, weaver 0
5533793 2515116 2515116 defendant Cobbe John, junior husbandman 586400 586400 Cobbe, John, junior, of Pulham St Mary, husbandman 1
5533794 2515116 2515116 defendant Fyssher Thomas carpenter 586400 586400 Fyssher, Thomas, of Pulham St Mary, carpenter 2
5534478 2515329 2515329 defendant Felde John husbandman 586400 586400 Felde, John, of Pulham St Mary, husbandman 0
5545766 2518753 2518753 defendant Wolnhagh Alice widow 586400 586400 Wolnhagh, Alice, of Pulham St Mary, widow 1
5550130 2520071 2520071 plaintiff Bunnyng John (legal representative) 586400 586400 Bunnyng, John, of Pulham St Mary, executor of 0
5550132 2520071 2520071 defendant Warde William husbandman 586400 586400 Warde, William, of Pulham St Mary, husbandman 0
5572619 2526537 2526537 plaintiff Myllys John (legal representative) 586400 586400 Myllys, John, of Pulham St Mary, executors of 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);