names

20 rows where place_id = 608033

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3671909 1917210 1917210 defendant Draper Roger gent 608033 608033 Draper, Roger, of Aldham, Essex, gent 0
3671913 1917211 1917211 defendant Draper Roger gent 608033 608033 Draper, Roger, of Aldham, Essex, gent 0
3865556 1978699 1978699 defendant Draper William gent 608033 608033 Draper, William, of Aldham, Essex, gent 0
3865558 1978700 1978700 defendant Draper William gent 608033 608033 Draper, William, of Aldham, Essex, gent 0
3865560 1978701 1978701 defendant Draper William gent 608033 608033 Draper, William, of Aldham, Essex, gent 0
3982590 2018543 2018543 defendant Stowe Thomas husbandman 608033 608033 Stowe, Thomas, of Aldham, Essex, husbandman 10
4005817 2026853 2026853 defendant Beryff William gent 608033 608033 Beryff, William, of Aldham, Essex, gent 4
4206731 2097894 2097894 defendant Wade John, senior yeoman 608033 608033 Wade, John, senior, of Aldham, Essex, yeoman 0
4210698 2099299 2099299 defendant Wesbrome John yeoman 608033 608033 Wesbrome, John, of Aldham, Essex, yeoman 0
4219584 2102354 2102354 defendant Newton Josias yeoman 608033 608033 Newton, Josias, of Aldham, Essex, yeoman 0
4287550 2125596 2125596 defendant Birde John husbandman 608033 608033 (Birde, John, of Aldham, Essex, husbandman 1
4287910 2125724 2125724 defendant Sayer George, junior gent 608033 608033 Sayer, George, junior, of Aldham, Essex, gent 0
4291742 2127124 2127124 defendant Brunynge Robert gent 608033 608033 Brunynge, Robert, of Aldham, Essex, gent 0
4335777 2142243 2142243 defendant Newton Joshua yteoman 608033 608033 Newton, Joshua, of Aldham, Essex, yteoman 0
4340795 2144054 2144054 defendant Byrd John yeoman 608033 608033 Byrd, John, of Aldham, Essex, yeoman 0
4359036 2150394 2150394 defendant Birde John yeoman 608033 608033 Birde, John, of Aldham, Essex, yeoman 0
4667531 2255564 2255564 defendant Sweke John yeoman 608033 608033 Sweke, John, of Aldham, Essex, yeoman 4
5073855 2378669 2378669 defendant Draper Roger gent 608033 608033 Draper, Roger, of Aldham, Essex, clerk, or of London, gent 0
5116293 2391194 2391194 defendant Roche Richard butcher 608033 608033 Roche, Richard, of Aldham, Essex, butcher 4
5337369 2456247 2456247 defendant Furneys John clerk 608033 608033 Furneys, John, of Aldham, Essex, clerk 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);