names

45 rows where place_id = 603002

✎ 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
3652639 1911160 1911160 defendant Grey Katherine widow 603002 603002 Grey, Katherine, of Clerkenwell, Middx, widow 0
3653867 1911473 1911473 defendant Tate John gent 603002 603002 Tate, John, of Clerkenwell, Middx, gent 0
3656721 1912356 1912356 defendant Holt John gent 603002 603002 Holt, John, of Clerkenwell, Middx, gent 0
3656723 1912357 1912357 defendant Holt John gent 603002 603002 Holt, John, of Clerkenwell, Middx, gent 0
3707269 1928563 1928563 plaintiff Broke Henry skinner 603002 603002 Broke, Henry, of Clerkenwell, Middx, skinner 1
3707273 1928564 1928564 plaintiff Broke Henry skinner 603002 603002 Broke, Henry, of Clerkenwell, Middx, skinner 1
3796023 1956619 1956619 defendant Porter Henry gent 603002 603002 Porter, Henry, of Clerkenwell, Middx, gent 0
3842570 1971206 1971206 plaintiff Brugge Roland gent 603002 603002 Brugge, Roland, of Clerkenwell, Middx, gent 0
3856494 1975660 1975660 defendant Lucy Elizabeth widow 603002 603002 Lucy, Elizabeth, of Clerkenwell, Middx, widow 1
3856500 1975661 1975661 defendant Lucy Elizabeth widow 603002 603002 Lucy, Elizabeth, of Clerkenwell, Middx, widow 1
3856506 1975662 1975662 defendant Lucy Elizabeth widow 603002 603002 Lucy, Elizabeth, of Clerkenwell, Middx, widow 1
3873028 1981195 1981195 plaintiff Brydgys Rowland esq 603002 603002 Brydgys, Rowland, of Clerkenwell, Middx, esq 0
3873033 1981196 1981196 plaintiff Brydgys Rowland esq 603002 603002 Brydgys, Rowland, of Clerkenwell, Middx, esq 0
3884111 1984956 1984956 defendant Empson Thomas esq 603002 603002 Empson, Thomas, of Clerkenwell, Middx, esq 0
3892720 1987816 1987816 defendant Marten Christopher gent 603002 603002 Marten, Christopher, of Clerkenwell, Middx, gent 0
3917165 1996102 1996102 defendant Grene Nicholas gent 603002 603002 Grene, Nicholas, of Clerkenwell, Middx, gent 2
3917169 1996103 1996103 defendant Grene Nicholas gent 603002 603002 Grene, Nicholas, of Clerkenwell, Middx, gent 2
3992111 2021942 2021942 plaintiff Buckland Walter esq 603002 603002 Buckland, Walter, of Clerkenwell, Middx, esq 0
4001894 2025453 2025453 plaintiff Hartilpoole Richard gent 603002 603002 Hartilpoole, Richard, of Clerkenwell, Middx, gent 0
4147688 2077334 2077334 defendant Breache William yeoman 603002 603002 Breache, William, of Clerkenwell, Middx, yeoman 0
4258837 2115923 2115923 defendant Yonge John yeoman 603002 603002 Yonge, John, of Clerkenwell, Middx, or of nettleden, Bucks, yeoman 0
4265415 2118072 2118072 defendant Ward Thomas esq 603002 603002 Ward, Thomas, of Clerkenwell, Middx, esq 0
4307030 2132599 2132599 defendant Bradbery John gent 603002 603002 Bradbery, John, of Clerkenwell, Middx, or of London, gent 0
4336510 2142505 2142505 defendant Saunders Thomas gent 603002 603002 Saunders, Thomas, of Clerkenwell, Middx, gent 0
4392569 2162135 2162135 defendant Baynard Philip gent 603002 603002 Baynard, Philip, of Clerkenwell, Middx, gent 1
4396017 2163244 2163244 defendant Bagley Nicholas butcher 603002 603002 Bagley, Nicholas, of Clerkenwell, Middx, butcher 1
4405938 2166549 2166549 defendant Basford Edward gent 603002 603002 Basford, Edward, of Clerkenwell, Middx, gent 1
4783833 2290960 2290960 defendant Kyng Christian gentlewoman 603002 603002 Kyng, Christian, of Clerkenwell, Middx, gentlewoman 0
4800482 2296333 2296333 defendant Sudbury John   603002 603002 Sudbury, John, of Clerkenwell, Middx, parchment maker 0
4810303 2299367 2299367 defendant Somercote William esq 603002 603002 Somercote, William, of Clerkenwell, Middx, esq 0
4814782 2300738 2300738 defendant (not given) William prior of Hillys 603002 603002 Hillys, William, of Clerkenwell, Middx, prior of the Hospital of St John Jerusalem in England 0
4895157 2325147 2325147 defendant Anderby William gent 603002 603002 Anderby, William, of Clerkenwell, Middx, gent 0
4943504 2339937 2339937 defendant Cursum William clerk 603002 603002 Cursum, William, of Clerkenwell, Middx, clerk 6
4963746 2346068 2346068 defendant Waryn Thomas gent 603002 603002 Waryn, Thomas, of Clerkenwell, Middx, gent 0
4993782 2355009 2355009 defendant Frampton Robert gent 603002 603002 Frampton, Robert, of Clerkenwell, Middx, gent 5
4997586 2356131 2356131 defendant Waldern Richard esq 603002 603002 Waldern, Richard, of Clerkenwell, Middx, esq 0
5096579 2385433 2385433 defendant Bastard Richard esq 603002 603002 Bastard, Richard, of Clerkenwell, Middx, esq 0
5114554 2390661 2390661 defendant Savage John gent 603002 603002 Savage, John, of Clerkenwell, Middx, gent 0
5194042 2413992 2413992 defendant Savage John gent 603002 603002 Savage, John, of Clerkenwell, Middx, gent 0
5208523 2418223 2418223 defendant Savage John gent 603002 603002 Savage, John, of Clerkenwell, Middx, gent 0
5234556 2425694 2425694 defendant Savage John gent 603002 603002 Savage, John, of Clerkenwell, Middx, gent 1
5286953 2441189 2441189 defendant Denys Walter esq 603002 603002 Denys, Walter, of Clerkenwell, Middx, esq 0
5341398 2457502 2457502 defendant Sakevile Humphrey esq 603002 603002 Sakevile, Humphrey, of Clerkenwell, Middx, esq 0
5341400 2457503 2457503 defendant Sakevyle Humphrey esq 603002 603002 Sakevyle, Humphrey, of Clerkenwell, Middx, esq 0
5582697 2529656 2529656 defendant Clerk Robert laborer 603002 603002 Clerk, Robert, of Clerkenwell, Middx, laborer 3

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