names

16 rows where case_id = 2327591

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4903120 2327591 2327591 plaintiff Gerveys Joan     Gerveys, Joan 0
4903121 2327591 2327591 defendant Gerveys John gent 586180 586180 Gerveys, John, of Bury St Edmunds, gent 0
4903122 2327591 2327591 defendant Gerveys Thomas stockfishmonger 585869 585869 Gerveys, Thomas, of London, stockfishmonger 1
4903123 2327591 2327591 defendant Grey Geoffrey gent 586363 586363 Grey, Geoffrey, of Bungey, gent 2
4903124 2327591 2327591 defendant Thorp John yeoman 586405 586405 Thorp, John, of Nedham Market, yeoman 3
4903125 2327591 2327591 defendant Ermyte John yeoman 586180 586180 Ermyte, John, of Bury St Edmunds, yeoman 4
4903126 2327591 2327591 defendant Middilton Ralph yeoman 586180 586180 Middilton, Ralph, of Bury St Edmunds, yeoman 5
4903127 2327591 2327591 defendant Spede John yeoman 589856 589856 Spede, John, of Pakenham, yeoman 6
4903128 2327591 2327591 defendant Talbot Robert yeoman 819540 819540 Talbot, Robert, of Illey Monks, yeoman 7
4903129 2327591 2327591 defendant Fyston Thomas yeoman 589856 589856 Fyston, Thomas, of Pakenham, yeoman 8
4903130 2327591 2327591 defendant Wright William yeoman 586180 586180 Wright, William, of Bury St Edmunds, yeoman 9
4903131 2327591 2327591 defendant Brion John, junior chapman 585947 585947 Brion, John, junior, of Hadley, chapman 10
4903132 2327591 2327591 defendant Humnale Thomas yeoman 589000 589000 Humnale, Thomas, of Bradfeld Sencler, yeoman 11
4903133 2327591 2327591 defendant Eyr Henry yeoman 589000 589000 Eyr, Henry, of Bradfeld Sencler, yeoman 12
4903134 2327591 2327591 defendant Skynner Walter singleman 587882 587882 Skynner, Walter, of Lavenham, singleman 13
4903135 2327591 2327591 defendant Smyth John husbandman 589000 589000 Smyth, John, of Bradfeld Sencler, husbandman 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);