names

14 rows where place_id = 593719

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3613068 1871739 1871739 plaintiff Artour Richard   593719 593719 Artour, Richard, of Spryngfeld, Essex 0
4644860 2244564 2244564 defendant Duk Guy esq 593719 593719 Duk, Guy, of Spryngfeld, Essex, esq 0
4655855 2247709 2247709 defendant Duk Guy esq 593719 593719 Duk, Guy, of Spryngfeld, Essex, esq 0
4655883 2247718 2247718 defendant Duk Guy esq 593719 593719 Duk, Guy, of Spryngfeld, Essex, esq 0
5000979 2357166 2357166 defendant Loveday John smith 593719 593719 Loveday, John, of Spryngfeld, Essex, smith 0
5000984 2357167 2357167 defendant Loveday John smith 593719 593719 Loveday, John, of Spryngfeld, Essex, smith 0
5045167 2370185 2370185 defendant Hampshire John gent 593719 593719 Hampshire, John, of Spryngfeld, Essex, gent 0
5162436 2404738 2404738 defendant Bysshop William husbandman 593719 593719 Bysshop, William, of Spryngfeld, Essex, husbandman 0
5162437 2404738 2404738 defendant Bovynton John yeoman 593719 593719 Bovynton, John, of Spryngfeld, Essex, yeoman 1
5162444 2404740 2404740 defendant Bysshop William husbandman 593719 593719 Bysshop, William, of Spryngfeld, Essex, husbandman 0
5162445 2404740 2404740 defendant Bovynton John yeoman 593719 593719 Bovynton, John, of Spryngfeld, Essex, yeoman 1
5198651 2415363 2415363 defendant Bysshop William husbandman 593719 593719 Bysshop, William, of Spryngfeld, Essex, husbandman 0
5198652 2415363 2415363 defendant Bovyngton John yeoman 593719 593719 Bovyngton, John, of Spryngfeld, Essex, yeoman 1
5460536 2493093 2493093 defendant Teryngton William husbandman 593719 593719 Teryngton, William, of spryngfeld, Essex, husbandman 4

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