names

23 rows where place_id = 602769

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3651717 1910893 1910893 defendant Brokke William chapman 602769 602769 Brokke, William, of Crowland, Lincs, chapman 0
3657992 1912751 1912751 defendant Yeryng John   602769 602769 Yeryng, John, of Crowland, Lincs, boat wright 0
3658704 1912975 1912975 defendant Bokke William yeoman 602769 602769 Bokke, William, of Crowland, Lincs, yeoman 0
3927854 1999653 1999653 defendant Tylllesley Roger yeoman 602769 602769 Tylllesley, Roger, of Crowland, Lincs, yeoman 4
4033295 2036561 2036561 defendant Durrant John yeoman 602769 602769 Durrant, John, of Crowland, Lincs, yeoman 0
4033305 2036563 2036563 defendant Durrant John yeoman 602769 602769 Durrant, John, of Crowland, Lincs, yeoman 0
4039584 2038777 2038777 defendant Durrant John yeoman 602769 602769 Durrant, John, of Crowland, Lincs, yeoman 0
4063290 2047164 2047164 defendant Benson William tailor 602769 602769 Benson, William, of Crowland, Lincs, tailor 3
4066740 2048401 2048401 defendant Durrant John yeoman 602769 602769 Durrant, John, of Crowland, Lincs, yeoman 0
4076545 2051910 2051910 defendant Rogers Thomas yeoman 602769 602769 Rogers, Thomas, of Crowland, Lincs, yeoman 0
4088176 2056062 2056062 defendant Durrant John yeoman 602769 602769 Durrant, John, of Crowland, Lincs, yeoman 0
4099007 2059971 2059971 defendant Durrante John   602769 602769 Durrante, John, of Crowland, Lincs, yeoman, bailiff 0
4167179 2084025 2084025 defendant Chester Arden tanner 602769 602769 Chester, Arden, of Crowland, Lincs, tanner 0
4171671 2085558 2085558 defendant Chester Arden tanner 602769 602769 Chester, Arden, of Crowland, Lincs, tanner 0
4172558 2085862 2085862 defendant Derbye Arthur chapman 602769 602769 Derbye, Arthur, of Crowland, Lincs, chapman 0
4195753 2094069 2094069 defendant Darbye Arthur chapman 602769 602769 Darbye, Arthur, of Crowland, Lincs, chapman 0
4388694 2160853 2160853 defendant Coward John beer brewer 602769 602769 Coward, John, of Crowland, Lincs, beer brewer 0
5567684 2525122 2525122 plaintiff Dyglyn John yeoman 602769 602769 Dyglyn, John, of Crowland, Lincs, yeoman 1
5567689 2525123 2525123 plaintiff Dyglyn John yeoman 602769 602769 Dyglyn, John, of Crowland, Lincs, yeoman 1
5567694 2525124 2525124 plaintiff Dyglyn John yeoman 602769 602769 Dyglyn, John, of Crowland, Lincs, yeoman 1
5574295 2527051 2527051 defendant Brok William chapman 602769 602769 Brok, William, of Crowland, Lincs, chapman 0
5574303 2527053 2527053 defendant Brok William chapman 602769 602769 Brok, William, of Crowland, Lincs, chapman 0
5591350 2532267 2532267 defendant Brok William chapman 602769 602769 Brok, William, of Crowland, Lincs, chapman 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);