names

20 rows where place_id = 609093

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3676986 1918838 1918838 defendant Bayly Robert gent 609093 609093 Bayly, Robert, of Caresbroke, Isle of Wight, gent 0
3747794 1941231 1941231 defendant Pratt Nicholas fuller 609093 609093 Pratt, Nicholas, of Caresbroke, Isle of Wight, fuller 0
3761701 1945668 1945668 defendant Pratt Nicholas fuller 609093 609093 Pratt, Nicholas, of Caresbroke, Isle of Wight, fuller 0
3870498 1980372 1980372 defendant Slader William laborer 609093 609093 Slader, William, of Caresbroke, Isle of Wight, laborer 3
3874398 1981663 1981663 defendant Fylder William husbandman 609093 609093 Fylder, William, of Caresbroke, Isle of Wight, husbandman 0
5137756 2397553 2397553 defendant Trenchard Henry esq 609093 609093 Trenchard, Henry, of Caresbroke, Isle of Wight, esq 2
5145904 2399926 2399926 defendant Trenchard Henry esq 609093 609093 Trenchard, Henry, of Caresbroke, Isle of Wight, esq 0
5155193 2402667 2402667 defendant Mewys Ralph gent 609093 609093 Mewys, Ralph, of Caresbroke, Isle of Wight, gent 0
5166214 2405843 2405843 defendant Trowbryge Edmund yeoman 609093 609093 Trowbryge, Edmund, of Caresbroke, Isle of Wight, yeoman 3
5166225 2405843 2405843 defendant Whoteborn Thomas husbandman 609093 609093 Whoteborn, Thomas, of Caresbroke, Isle of Wight, husbandman 14
5180952 2410168 2410168 defendant Trowbryge Edmund yeoman 609093 609093 Trowbryge, Edmund, of Caresbroke, Isle of Wight, yeoman 3
5180956 2410169 2410169 defendant Trenchard Henry esq 609093 609093 Trenchard, Henry, of Caresbroke, Isle of Wight, esq 0
5180960 2410170 2410170 defendant Trenchard Henry esq 609093 609093 Trenchard, Henry, of Caresbroke, Isle of Wight, esq 0
5190256 2412891 2412891 defendant Mewys Ralph gent 609093 609093 Mewys, Ralph, of Caresbroke, Isle of Wight, gent 0
5202633 2416534 2416534 defendant Trowbryge Edmund yeoman 609093 609093 Trowbryge, Edmund, of Caresbroke, Isle of Wight, yeoman 3
5202649 2416535 2416535 defendant Trenchard Henry esq 609093 609093 Trenchard, Henry, of Caresbroke, Isle of Wight, esq 0
5267210 2435506 2435506 defendant Legge Robert laborer 609093 609093 Legge, Robert, of caresbroke, Isle of Wight, laborer 1
5285260 2440711 2440711 defendant Gate Geoffrey   609093 609093 Gate, Geoffrey, of Caresbroke, Isle of Wight, knight 2
5505440 2506617 2506617 defendant Sayvyle John   609093 609093 Sayvyle, John, of Caresbroke, Isle of Wight, knight 0
5600175 2534940 2534940 defendant Garton Edward gent 609093 609093 Garton, Edward, of Caresbroke, Isle of Wight, 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);