names

13 rows where case_id = 1972393

✎ 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
3846273 1972393 1972393 plaintiff Godfrey Edward     Godfrey, Edward 0
3846274 1972393 1972393 defendant Horn Roger esq 622868 622868 Horn, Roger, of Kenardyngton, esq 0
3846275 1972393 1972393 defendant Goller Robert laborer 622868 622868 Goller, Robert, of Kenardyngton, laborer 1
3846276 1972393 1972393 defendant Frencheman Charles laborer 622868 622868 Frencheman, Charles, of Kenardyngton, laborer 2
3846277 1972393 1972393 defendant Brenam John laborer 622868 622868 Brenam, John, of Kenardyngton, laborer 3
3846278 1972393 1972393 defendant Thorp Stephen laborer 622868 622868 Thorp, Stephen, of Kenardyngton, laborer 4
3846279 1972393 1972393 defendant Bland William laborer 622868 622868 Bland, William, of Kenardyngton, laborer 5
3846280 1972393 1972393 defendant Typpyng George laborer 622868 622868 Typpyng, George, of Kenardyngton, laborer 6
3846281 1972393 1972393 defendant Cowper John laborer 622868 622868 Cowper, John, of Kenardyngton, laborer 7
3846282 1972393 1972393 defendant Philipp Peter laborer 622868 622868 Philipp, Peter, of Kenardyngton, laborer 8
3846283 1972393 1972393 defendant Hoope Thomas laborer 622868 622868 Hoope, Thomas, of Kenardyngton, laborer 9
3846284 1972393 1972393 defendant Adam John laborer 622868 622868 Adam, John, of Kenardyngton, laborer 10
3846285 1972393 1972393 defendant Lodewile Thomas laborer 622868 622868 Lodewile, Thomas, of Kenardyngton, laborer 11

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