names

9 rows where place_id = 658384

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3948201 2006433 2006433 defendant Hedd John yeoman 658384 658384 Hedd, John, of Dartforde, Kent, yeoman 1
4008921 2027953 2027953 defendant Rawson William fishmonger 658384 658384 Rawson, William, of Dartforde, Kent, innholder, or of London, fishmonger 0
4027477 2034474 2034474 plaintiff Appelton William gent 658384 658384 Appelton, William, of Dartforde, Kent, gent 3
4075332 2051479 2051479 defendant Cotman John yeoman 658384 658384 Cotman, John, of Dartforde, Kent, yeoman 0
4086258 2055359 2055359 defendant Bere Nicholas gent 658384 658384 Bere, Nicholas, of Dartforde, Kent, gent 0
4099365 2060098 2060098 defendant Jarrette John yeoman 658384 658384 Jarrette, John, of Dartforde, Kent, yeoman 0
4112750 2064822 2064822 defendant Hadlowe Robert carpenter 658384 658384 Hadlowe, Robert, of Dartforde, Kent, yeoman, or of Rygate, Surrey, carpenter 0
4145537 2076594 2076594 defendant Taylor John shoemaker 658384 658384 Taylor, John, of Dartforde, Kent, shoemaker 1
4370139 2154381 2154381 defendant Chevell John (legal representative) 658384 658384 Chevell, John, of Dartforde, Kent, gent, executor of 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);