names

20 rows where place_id = 654968

✎ 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
3934446 2001815 2001815 defendant Belfeld Charles gent 654968 654968 Belfeld, Charles, of Pakenham, Suff, gent 0
3972365 2014908 2014908 plaintiff Fyske Robert yeoman 654968 654968 Fyske, Robert, of Pakenham, Suff, yeoman 0
4016925 2030755 2030755 defendant Spring Robert gent 654968 654968 Spring, Robert, of Pakenham, Suff, gent 0
4047145 2041425 2041425 defendant Sprynge Robert gent 654968 654968 Sprynge, Robert, of Pakenham, Suff, gent 1
4047487 2041554 2041554 plaintiff Sterne William gent 654968 654968 Sterne, William, of Pakenham, Suff, gent 0
4090696 2056960 2056960 defendant Turner Richard yeoman 654968 654968 Turner, Richard, of Pakenham, Suff, yeoman 3
4118309 2066837 2066837 defendant Sprynge William   654968 654968 Sprynge, William, of Pakenham, Suff, knight, sheriff of Suff 0
4135761 2073117 2073117 defendant Springe William   654968 654968 Springe, William, of Pakenham, Suff, knight 0
4137640 2073815 2073815 defendant Sprynge John esq 654968 654968 Sprynge, John, of Pakenham, Suff, esq 0
4167626 2084174 2084174 defendant Cooke Robert gent 654968 654968 Cooke, Robert, of Pakenham, Suff, gent 0
4171335 2085437 2085437 defendant Sterne William gent 654968 654968 Sterne, William, of Pakenham, Suff, gent 0
4221284 2102942 2102942 defendant Spring John esq 654968 654968 Spring, John, of Pakenham, Suff, esq 0
4340077 2143796 2143796 defendant Springe John gent 654968 654968 Springe, John, of Pakenham, Suff, gent 0
4856430 2313387 2313387 defendant Fyston Thomas   654968 654968 Fyston, Thomas, of Pakenham, Suff, husbandman, kinsman of Pakenham, Richard, of Pakenham 0
4856433 2313388 2313388 defendant Fyston Thomas   654968 654968 Fyston, Thomas, of Pakenham, Suff, husbandman, kinsman of Pakenham, Richard, of Pakenham 0
4988910 2353631 2353631 defendant Martyn Alexander laborer 654968 654968 Martyn, Alexander, of Pakenham, Suff, laborer 6
5042455 2369351 2369351 defendant Rous John gent 654968 654968 Rous, John, of Pakenham, Suff, gent 0
5042609 2369391 2369391 defendant Rous John gent 654968 654968 Rous, John, of Pakenham, Suff, gent 0
5248845 2429781 2429781 defendant Warner John yeoman 654968 654968 Warner, John, of Pakenham, Suff, yeoman 0
5601627 2535405 2535405 defendant Clerke William husbandman 654968 654968 Clerke, William, of Pakenham, Suff, husbandman 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);