names

15 rows where case_id = 1908995

✎ 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
3645503 1908995 1908995 plaintiff Grote John     Grote, John 0
3645504 1908995 1908995 defendant Malmes John husbandman 597398 597398 Malmes, John, of Howe, husbandman 0
3645505 1908995 1908995 defendant Stowe Richard yeoman 588931 588931 Stowe, Richard, of Horsham St Faith, yeoman 1
3645506 1908995 1908995 defendant Estowe William yeoman 593527 593527 Estowe, William, of Saxlyngham, yeoman 2
3645507 1908995 1908995 defendant Thakker Thomas yeoman 590486 590486 Thakker, Thomas, of Stoke Holy Cross, yeoman 3
3645508 1908995 1908995 defendant Coleys Robert yeoman 587166 587166 Coleys, Robert, of Salle, yeoman 4
3645509 1908995 1908995 defendant Godyng Richard yeoman 600449 600449 Godyng, Richard, of Boston, Lincs, yeoman 5
3645510 1908995 1908995 defendant Bacon Richard yeoman 592344 592344 Bacon, Richard, of Holt, yeoman 6
3645511 1908995 1908995 defendant Sendell Simon yeoman 586364 586364 Sendell, Simon, of Long Stratton, yeoman 7
3645512 1908995 1908995 defendant Lavyle Thomas husbandman 592833 592833 Lavyle, Thomas, of Wakton, husbandman 8
3645513 1908995 1908995 defendant Wyseman Robert husbandman 586365 586365 Wyseman, Robert, of Wymondham, husbandman 9
3645514 1908995 1908995 defendant Cha�Galmeton fish driver     Cha�Galmeton, fish driver 10
3645515 1908995 1908995 defendant Harry John   597174 597174 Harry, John, of Galmeton, fish driver 11
3645516 1908995 1908995 defendant White Richard   597174 597174 White, Richard, of Galmeton, fish driver 12
3645517 1908995 1908995 defendant Blakhaller Richard husbandman 597174 597174 Blakhaller, Richard, of Galmeton, husbandman 13

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