names

55 rows where place_id = 619451

✎ 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
3729996 1935628 1935628 defendant Boltell William innholder 619451 619451 Boltell, William, of Newmarkett, innholder 1
3746712 1940885 1940885 defendant Papworth John   619451 619451 Papworth, John, of Newmarkett, pedlar 1
3778300 1950924 1950924 defendant Best John husbandman 619451 619451 Best, John, of newmarkett, husbandman 3
3804002 1959169 1959169 defendant Trevyn John husbandman 619451 619451 Trevyn, John, of Newmarkett, husbandman 0
3804003 1959169 1959169 defendant Papworth John fishmonger 619451 619451 Papworth, John, of Newmarkett, fishmonger 1
3810245 1961097 1961097 defendant Bowltell William innkeeper 619451 619451 Bowltell, William, of Newmarkett, innkeeper 2
3815464 1962752 1962752 defendant Kene John tailor 619451 619451 Kene, John, of Newmarkett, tailor 0
3815465 1962752 1962752 defendant Lorde Robert   619451 619451 Lorde, Robert, of Newmarkett, parchment maker 1
3866255 1978941 1978941 defendant Grey John yeoman 619451 619451 Grey, John, of Newmarkett, yeoman 0
3867683 1979427 1979427 defendant Button Thomas yeoman 619451 619451 Button, Thomas, of Newmarkett, yeoman 0
3867685 1979428 1979428 defendant Button Thomas yeoman 619451 619451 Button, Thomas, of Newmarkett, yeoman 0
3867687 1979429 1979429 defendant Button Thomas yeoman 619451 619451 Button, Thomas, of Newmarkett, yeoman 0
3869511 1980045 1980045 defendant Button Thomas yeoman 619451 619451 Button, Thomas, of Newmarkett, yeoman 0
3869529 1980051 1980051 defendant Button Thomas yeoman 619451 619451 Button, Thomas, of Newmarkett, yeoman 0
3913257 1994763 1994763 defendant Homond William innkeeper 619451 619451 Homond, William, of Newmarkett, innkeeper 3
3917412 1996182 1996182 defendant Bryghtlyff Christopher yeoman 619451 619451 Bryghtlyff, Christopher, of Newmarkett, yeoman 2
3950651 2007301 2007301 defendant Turnor Robert merchant 619451 619451 Turnor, Robert, of Newmarkett, merchant 0
3951160 2007474 2007474 defendant Flawner John yeoman 619451 619451 Flawner, John, of Newmarkett, yeoman 0
3951161 2007474 2007474 defendant Holland Anthony husbandman 619451 619451 Holland, Anthony, of Newmarkett, husbandman 1
3961498 2011120 2011120 plaintiff Turnor Robert yeoman 619451 619451 Turnor, Robert, of Newmarkett, yeoman 0
3991969 2021889 2021889 defendant Budde alias Orderiche Robert smith 619451 619451 Budde alias Orderiche, Robert, of Newmarkett, smith 1
3999273 2024496 2024496 defendant Turner Robert yeoman 619451 619451 Turner, Robert, of Newmarkett, yeoman 0
4009032 2027995 2027995 defendant Turnour Robert yeoman 619451 619451 Turnour, Robert, of Newmarkett, yeoman 1
4025824 2033888 2033888 defendant Chaundeler William husbandman 619451 619451 Chaundeler, William, of Newmarkett, husbandman 4
4030659 2035627 2035627 defendant Turnor Elizabeth widow 619451 619451 Turnor, Elizabeth, of Newmarkett, widow 1
4037203 2037968 2037968 defendant Flaunder John joiner 619451 619451 Flaunder, John, of Newmarkett, joiner 0
4039990 2038923 2038923 defendant Myddeldytche John yeoman 619451 619451 Myddeldytche, John, of Newmarkett, yeoman 0
4061070 2046368 2046368 plaintiff Dove Thomas (legal representative) 619451 619451 Dove, Thomas, of Newmarkett, singleman, executor of 0
4061072 2046368 2046368 defendant Boroughdale Richard (legal representative) 619451 619451 Boroughdale, Richard, of Newmarkett, grocer, executors of 0
4061073 2046368 2046368 defendant Boroughdale Roger yeoman 619451 619451 (Boroughdale, Roger, of Newmarkett, yeoman 1
4065916 2048100 2048100 defendant Staver Thomas husbandman 619451 619451 Staver, Thomas, of Newmarkett, husbandman 0
4065917 2048100 2048100 defendant Staver John husbandman 619451 619451 Staver, John, of Newmarkett, husbandman 1
4114752 2065564 2065564 defendant Kynge John yeoman 619451 619451 Kynge, John, of Newmarkett, yeoman 0
4129824 2070977 2070977 defendant Funston Christopher, junior yeoman 619451 619451 Funston, Christopher, junior, of Newmarkett, yeoman 0
4130930 2071374 2071374 defendant Jenyng John beer brewer 619451 619451 Jenyng, John, of Newmarkett, beer brewer 1
4137970 2073940 2073940 defendant Kynge John yeoman 619451 619451 Kynge, John, of Newmarkett, yeoman 0
4137971 2073940 2073940 defendant Folk Thomas   619451 619451 Folk, Thomas, of Newmarkett, Cams yeoman 1
4140003 2074669 2074669 defendant Kinge John yeoman 619451 619451 Kinge, John, of Newmarkett, yeoman 2
4162382 2082402 2082402 defendant Kynge John yeoman 619451 619451 Kynge, John, of Newmarkett, yeoman 0
4168165 2084351 2084351 defendant Kynge John yeoman 619451 619451 Kynge, John, of Newmarkett, yeoman 1
4209890 2099019 2099019 defendant Bungey alias Liggate William pedder 619451 619451 Bungey alias Liggate, William, of Newmarkett, pedder 0
4209891 2099019 2099019 defendant Walsam Christopher yeoman 619451 619451 Walsam, Christopher, of Newmarkett, yeoman 1
4209956 2099045 2099045 defendant Nobull Thomas fishmonger 619451 619451 Nobull, Thomas, of Newmarkett, fishmonger 1
4221696 2103078 2103078 defendant Callowe Anthony clerk 619451 619451 Callowe, Anthony, of Newmarkett, clerk 3
4221698 2103079 2103079 defendant Roote David pedder 619451 619451 Roote, David, of Newmarkett, pedder 0
4247424 2112118 2112118 defendant Callowe Anthony clerk 619451 619451 Callowe, Anthony, of Newmarkett, clerk 3
4247426 2112119 2112119 defendant Roote David pedder 619451 619451 Roote, David, of Newmarkett, pedder 0
4247427 2112119 2112119 defendant Midledich John gent 619451 619451 Midledich, John, of Newmarkett, gent 1
4275385 2121328 2121328 defendant Appleyarde John yeoman 619451 619451 Appleyarde, John, of Newmarkett, yeoman 0
4275977 2121547 2121547 defendant Edward Robert pedder 619451 619451 Edward, Robert, of Newmarkett, pedder 1
4280048 2122931 2122931 defendant Morton Nicholas   619451 619451 Morton, Nicholas, of Newmarkett, woollen draper 0
4280423 2123060 2123060 defendant Kinge John yeoman 619451 619451 Kinge, John, of Newmarkett, yeoman 0
4305840 2132181 2132181 defendant Harrold John poulter 619451 619451 Harrold, John, of Newmarkett, poulter 0
4314604 2135223 2135223 defendant Morden Nicholas draper 619451 619451 Morden, Nicholas, of Newmarkett, draper 0
4329276 2140104 2140104 defendant Aytes David (legal representative) 619451 619451 Aytes, David, of Newmarkett, yeoman, executrix of 2

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