names

32 rows where place_id = 586946

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590053 1864529 1864529 defendant Yue Robert grocer 586946 586946 Yue, Robert, of Suthwarke, grocer 0
3590054 1864529 1864529 defendant Swone William armorer 586946 586946 Swone, William, of Suthwarke, armorer 1
3590055 1864529 1864529 defendant Tayller Richard yeoman 586946 586946 Tayller, Richard, of Suthwarke, yeoman 2
3635803 1905998 1905998 defendant Chiltern John gent 586946 586946 Chiltern, John,of Suthwarke, gent 2
3642575 1908121 1908121 defendant Symond John joiner 586946 586946 Symond, John, of Suthwarke, joiner 1
3694619 1924520 1924520 defendant Wentworth Thomas   586946 586946 Wentworth, Thomas, of Suthwarke, knight 2
3694623 1924521 1924521 defendant Wentworth Thomas   586946 586946 Wentworth, Thomas, of Suthwarke, knight 2
3757948 1944469 1944469 plaintiff Bray John fellmonger 586946 586946 Bray, John, of Suthwarke, fellmonger 0
3765511 1946877 1946877 defendant Tyndale Thomas dyer 586946 586946 Tyndale, Thomas, of Suthwarke, dyer 2
3768557 1947811 1947811 defendant Tarne Robert smith 586946 586946 Tarne, Robert, of Suthwarke, smith 3
3768558 1947811 1947811 defendant Burnam John pinner 586946 586946 Burnam, John, of Suthwarke, pinner 4
3771414 1948751 1948751 defendant Bradley John cordwainer 586946 586946 Bradley, John, of Suthwarke, cordwainer 0
3771415 1948751 1948751 defendant Lyell William saddler 586946 586946 Lyell, William, of Suthwarke, saddler 1
3771416 1948751 1948751 defendant Cooke William saddler 586946 586946 Cooke, William, of Suthwarke, saddler 2
3771417 1948751 1948751 defendant Hanes John cordwainer 586946 586946 Hanes, John, of Suthwarke, cordwainer 3
3787714 1953942 1953942 defendant Hamond Thomas   586946 586946 Hamond, Thomas, of Suthwarke, tallow chandler 0
3791833 1955291 1955291 defendant Brigges Thomas dyer 586946 586946 Brigges, Thomas, of Suthwarke, dyer 4
3791839 1955292 1955292 defendant Brigges Thomas dyer 586946 586946 Brigges, Thomas, of Suthwarke, dyer 4
3823015 1965106 1965106 defendant Cokkes John, senior leather seller 586946 586946 Cokkes, John, senior, of Suthwarke, leather seller 0
3823016 1965106 1965106 defendant Cokkes John, junior leather seller 586946 586946 Cokkes, John, junior, of Suthwarke, leather seller 1
3827281 1966399 1966399 defendant Annell John butcher 586946 586946 Annell, John, of Suthwarke, butcher 1
3849409 1973413 1973413 defendant West Robert yeoman 586946 586946 West, Robert, of Suthwarke, yeoman 0
3851905 1974188 1974188 defendant Carew Gawin esq 586946 586946 Carew, Gawin, of Suthwarke, esq 0
3851907 1974189 1974189 defendant Carewe Gawin esq 586946 586946 Carewe, Gawin, of Suthwarke, esq 0
3869416 1980011 1980011 defendant Kellet William brewer or merchant tailor 586946 586946 Kellet, William, of Suthwarke, brewer or merchant tailor 0
3916870 1996007 1996007 defendant Symmes John innholder 586946 586946 Symmes, John, of Suthwarke, innholder 0
3949036 2006729 2006729 defendant Shokysborow John   586946 586946 Shokysborow, John, of Suthwarke, yeoman, servant of Thomas Cardyng, knight 0
5176025 2408670 2408670 defendant Kynge William brewer 586946 586946 Kynge, William, of Suthwarke, brewer 0
5509851 2507919 2507919 defendant Asshton Thomas gent 586946 586946 Asshton, Thomas, of Suthwarke, gent 0
5542401 2517744 2517744 defendant Cowper John vintner 586946 586946 Cowper, John, of Suthwarke, vintner 0
5561779 2523429 2523429 defendant Wylliamson Barbara widow 586946 586946 Wylliamson, Barbara, of Suthwarke, widow 1
5579604 2528703 2528703 defendant Phelippe Richard gent 586946 586946 Phelippe, Richard, of Suthwarke, gent 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);