names

39 rows where place_id = 602618

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3650925 1910659 1910659 defendant Rogers Thomas gent 602618 602618 Rogers, Thomas, of Burwell, Cams, gent 1
3715499 1931135 1931135 defendant Benet John gent 602618 602618 Benet, John, of Burwell, Cams, gent 1
3774169 1949633 1949633 defendant Welworth William husbandman 602618 602618 Welworth, William, of Burwell, Cams, husbandman 0
3810503 1961180 1961180 defendant Welworth alias Warde William yeoman 602618 602618 Welworth alias Warde, William, of Burwell, Cams, yeoman 0
3814199 1962344 1962344 defendant Warde alias Welworth William gent 602618 602618 Warde alias Welworth, William, of Burwell, Cams, gent 1
3840157 1970493 1970493 defendant Maryett William husbandman 602618 602618 Maryett, William, of Burwell, Cams, husbandman 0
3952065 2007790 2007790 defendant Rogers William husbandman 602618 602618 Rogers, William, of Burwell, Cams, husbandman 0
3952067 2007791 2007791 defendant Rogers William husbandman 602618 602618 Rogers, William, of Burwell, Cams, husbandman 0
3956635 2009385 2009385 defendant Lukyn William yeoman 602618 602618 Lukyn, William, of Burwell, Cams, yeoman 0
3962608 2011513 2011513 defendant Lukyn William yeoman 602618 602618 Lukyn, William, of Burwell, Cams, yeoman 2
3962713 2011542 2011542 defendant Lukyn William yeoman 602618 602618 Lukyn, William, of Burwell, Cams, yeoman 0
3962792 2011575 2011575 plaintiff Wilkins John yeoman 602618 602618 Wilkins, John, of Burwell, Cams, yeoman 0
3969933 2014084 2014084 defendant Ducket Owen clerk 602618 602618 Ducket, Owen, of Burwell, Cams, clerk 2
3971891 2014729 2014729 defendant Duckett Owen clerk 602618 602618 Duckett, Owen, of Burwell, Cams, clerk 2
3975453 2015982 2015982 plaintiff Huggyn William butcher 602618 602618 Huggyn, William, of Burwell, Cams, butcher 0
4000727 2025027 2025027 defendant Fulkes Thomas yeoman 602618 602618 Fulkes, Thomas, of Burwell, Cams, yeoman 0
4001317 2025249 2025249 defendant Bourne Christopher tailor 602618 602618 Bourne, Christopher, of Burwell, Cams, tailor 2
4001321 2025250 2025250 defendant Wryte William laborer 602618 602618 Wryte, William, of Burwell, Cams, laborer 2
4025820 2033888 2033888 defendant Olfylde George smith 602618 602618 Olfylde, George, of Burwell, Cams, smith 0
4025826 2033889 2033889 defendant Olfylde George smith 602618 602618 Olfylde, George, of Burwell, Cams, smith 0
4036181 2037623 2037623 defendant Cobbe John waterman 602618 602618 Cobbe, John, of Burwell, Cams, waterman 2
4036194 2037626 2037626 defendant Cobbe John waterman 602618 602618 Cobbe, John, of Burwell, Cams, waterman 2
4039473 2038742 2038742 defendant Markam John yeoman 602618 602618 Markam, John, of Burwell, Cams, yeoman 0
4039477 2038743 2038743 defendant Markam John yeoman 602618 602618 Markam, John, of Burwell, Cams, yeoman 0
4040547 2039114 2039114 defendant Gooddyng William husbandman 602618 602618 Gooddyng, William, of Burwell, Cams, husbandman 0
4040552 2039115 2039115 defendant Gooddynge William husbandman 602618 602618 Gooddynge, William, of Burwell, Cams, husbandman 0
4337655 2142919 2142919 defendant Sowthe William yeoman 602618 602618 Sowthe, William, of Burwell, Cams, yeoman 0
4939505 2338741 2338741 defendant atte Hill Nicholas yeoman 602618 602618 atte Hill, Nicholas, of Burwell, Cams, yeoman 0
5080151 2380549 2380549 defendant Harpour John husbandman 602618 602618 Harpour, John, of Burwell, Cams, husbandman 1
5111367 2389717 2389717 plaintiff Heugham John clerk 602618 602618 Heugham, John, of Burwell, Cams, clerk 0
5287559 2441386 2441386 plaintiff Keye Roger clerk 602618 602618 Keye, Roger, of Burwell, Cams, clerk 0
5540492 2517157 2517157 defendant Reymer Thomas barker 602618 602618 Reymer, Thomas, of Burwell, Cams, barker 0
5544077 2518256 2518256 defendant Pratt John   602618 602618 Pratt, John, of Burwell, Cams 0
5569776 2525731 2525731 defendant Darrold Godfrey gent 602618 602618 Darrold, Godfrey, of Burwell, Cams, gent 0
5572232 2526430 2526430 defendant Reyner Williamm tanner 602618 602618 Reyner, Williamm, of Burwell, Cams, tanner 2
5581775 2529379 2529379 defendant Reyner William husbandman 602618 602618 Reyner, William, of Burwell, Cams, husbandman 4
5599837 2534835 2534835 defendant Kyng John   602618 602618 Kyng, John, of Burwell, Cams, surgeon 2
5630912 2553681 2553681 defendant atte Hill John husbandman 602618 602618 atte Hill, John, of Burwell, Cams, husbandman 0
5630914 2553682 2553682 defendant atte Hill John husbandman 602618 602618 atte Hill, John, of Burwell, Cams, husbandman 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);