names

16 rows where case_id = 2307192

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4835798 2307192 2307192 plaintiff Drury William knight   Drury, William, knight 0
4835799 2307192 2307192 defendant Piers William   810137 810137 Piers, William, of Orteleye, franklin 0
4835800 2307192 2307192 defendant Wodeward John   591957 591957 Wodeward, John, of Helmyngham, franklin 1
4835801 2307192 2307192 defendant Hoxson Richard yeoman 590146 590146 Hoxson, Richard, of Wynston, yeoman 2
4835802 2307192 2307192 defendant Geney Geoffrey   587058 587058 Geney, Geoffrey, of Sutton, franklin 3
4835803 2307192 2307192 defendant Fornham John yeoman 586395 586395 Fornham, John, of Alderton, yeoman 4
4835804 2307192 2307192 defendant Mannyng John   757420 757420 Mannyng, John, of Ilketeshale, franklin 5
4835805 2307192 2307192 defendant Cristemesse William yeoman 596671 596671 Cristemesse, William, of Wykham Market, yeoman 6
4835806 2307192 2307192 defendant Warner Adam yeoman 775059 775059 Warner, Adam, of Tremeley, yeoman 7
4835807 2307192 2307192 defendant Cake John jun, of Mendelesham, shoe maker   Cake, John, jun, of Mendelesham, shoe maker 8
4835808 2307192 2307192 defendant Plomer John yeoman 757947 757947 Plomer, John, of Wodebregge, yeoman 9
4835809 2307192 2307192 defendant Mate Wm yeoman 608149 608149 Mate, Wm, of Coppedok, yeoman 10
4835810 2307192 2307192 defendant Cardenal Adam yeoman 767777 767777 Cardenal, Adam, of Wenham Combusta, yeoman 11
4835811 2307192 2307192 defendant Predis Thomas husbandman 608149 608149 Predis, Thomas, of Coppedok, husbandman 12
4835812 2307192 2307192 defendant Frenssh John, senior yeoman 586134 586134 Frenssh, John, senior, of Ipswich, yeoman 13
4835813 2307192 2307192 defendant Debenham Gilbert esq 810140 810140 Debenham, Gilbert, of Pildewenham, esq 14

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);