names

41 rows where place_id = 600209

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3640171 1907370 1907370 defendant Gellys Thomas gent 600209 600209 Gellys, Thomas, of Bradford, Yorks, gent 3
3640283 1907394 1907394 defendant Tempest Richard esq 600209 600209 Tempest, Richard, of Bradford, Yorks, esq 0
3696278 1925056 1925056 defendant Bayngbrig William yeoman 600209 600209 Bayngbrig, William, of Bradford, Yorks, yeoman 0
3701004 1926562 1926562 defendant Bollyng Alice yeoman of the crown 600209 600209 Bollyng, Alice, of Bradford, Yorks, widow of Bollyng, Raynbrowne, of Bradford, yeoman of the crown 6
3750460 1942057 1942057 defendant tempest Richard   600209 600209 tempest, Richard, of Bradford, Yorks, knight 1
3805022 1959514 1959514 defendant Somerskallys Richard yeoman 600209 600209 Somerskallys, Richard, of Bradford, Yorks, yeoman 2
3805026 1959515 1959515 defendant Somerskallys Richard yeoman 600209 600209 Somerskallys, Richard, of Bradford, Yorks, yeoman 1
3878200 1982956 1982956 defendant Bentley Arthur yeoman 600209 600209 Bentley, Arthur, of Bradford, Yorks, yeoman 0
3878677 1983117 1983117 defendant Thornton Gilbert chapman 600209 600209 Thornton, Gilbert, of Bradford, Yorks, chapman 1
3899665 1990107 1990107 defendant Appleyard Richard husbandman 600209 600209 Appleyard, Richard, of Bradford, Yorks, husbandman 0
3899676 1990108 1990108 defendant Appleyard Richard husbandman 600209 600209 Appleyard, Richard, of Bradford, Yorks, husbandman 0
3902111 1990942 1990942 defendant Appleyard Richard husbandman 600209 600209 Appleyard, Richard, of Bradford, Yorks, husbandman 0
3919468 1996845 1996845 defendant Kyng John mercer 600209 600209 Kyng, John, of Bradford, Yorks, mercer 4
3919798 1996959 1996959 defendant Kyng John mercer 600209 600209 Kyng, John, of Bradford, Yorks, mercer 4
3929391 2000176 2000176 defendant Lyllye William mercer 600209 600209 Lyllye, William, of Bradford, Yorks, mercer 1
3929635 2000261 2000261 defendant Bollyng Godfrey yeoman 600209 600209 Bollyng, Godfrey, of Bradford, Yorks, yeoman 0
3949740 2006988 2006988 defendant Drake Humphrey chapman 600209 600209 Drake, Humphrey, of Bradford, Yorks, chapman 0
3950691 2007315 2007315 defendant Drayke Humphrey chapman 600209 600209 Drayke, Humphrey, of Bradford, Yorks, chapman 0
4128422 2070458 2070458 defendant Swifte Richard clothier 600209 600209 Swifte, Richard, of Bradford, Yorks, clothier 0
4151850 2078759 2078759 defendant Swyfte Richard clothier 600209 600209 Swyfte, Richard, of Bradford, Yorks, clothier 0
4349483 2147083 2147083 defendant Pollard Nicholas chapman 600209 600209 Pollard, Nicholas, of Bradford, Yorks, chapman 2
4708764 2268113 2268113 defendant Alenbrigge Thomas yeoman 600209 600209 Alenbrigge, Thomas, of Bradford, Yorks, yeoman 0
4732158 2275242 2275242 defendant Alenbrigge Thomas tanner 600209 600209 Alenbrigge, Thomas, of Bradford, Yorks, tanner 0
4742570 2278328 2278328 defendant Durych Thomas clerk 600209 600209 Durych, Thomas, of Bradford, Yorks, clerk 0
4749027 2280200 2280200 defendant Alanbryg Thomas de yeoman 600209 600209 Alanbryg, Thomas de, of Bradford, Yorks, yeoman 0
4768412 2286091 2286091 defendant Alanbrig Thomas yeoman 600209 600209 Alanbrig, Thomas, of Bradford, Yorks, yeoman 0
4842395 2309156 2309156 defendant Tireshall William yeoman 600209 600209 Tireshall, William, of Bradford, Yorks, yeoman 0
4896340 2325520 2325520 defendant Dollyng Robert gent 600209 600209 Dollyng, Robert, of Bradford, Yorks, gent 2
5071490 2377969 2377969 defendant Crosley John yeoman 600209 600209 Crosley, John, of Bradford, Yorks, yeoman 2
5231639 2424833 2424833 defendant Geller Henry clerk 600209 600209 Geller, Henry, of Bradford, Yorks, clerk 2
5273890 2437445 2437445 defendant Webster Thomas chapman 600209 600209 Webster, Thomas, of Bradford, Yorks, chapman 2
5285600 2440811 2440811 defendant Broughton John chapman 600209 600209 Broughton, John, of Bradford, Yorks, chapman 0
5343379 2458120 2458120 defendant Feld William yeoman 600209 600209 Feld, William, of Bradford, Yorks, yeoman 2
5374172 2467519 2467519 defendant Webster James chapman 600209 600209 Webster, James, of Bradford, Yorks, chapman 2
5460863 2493198 2493198 defendant Hallesworth John chapman 600209 600209 Hallesworth, John, of Bradford, Yorks, chapman 1
5483907 2500127 2500127 defendant Halesworth John chapman 600209 600209 Halesworth, John, of Bradford, Yorks, chapman 1
5537186 2516117 2516117 defendant Webster John chapman 600209 600209 Webster, John, of Bradford, Yorks, chapman 0
5537204 2516122 2516122 defendant Webster John chapman 600209 600209 Webster, John, of Bradford, Yorks, chapman 0
5545685 2518727 2518727 defendant Gelles Thomas yeoman 600209 600209 Gelles, Thomas, of Bradford, Yorks, yeoman 2
5545690 2518728 2518728 defendant Gelles Thomas yeoman 600209 600209 Gelles, Thomas, of Bradford, Yorks, yeoman 2
5545695 2518729 2518729 defendant Gelles Thomas yeoman 600209 600209 Gelles, Thomas, of Bradford, Yorks, yeoman 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);