names

10 rows where case_id = 2261640

✎ 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
4687319 2261640 2261640 plaintiff Stevenson William     Stevenson, William 0
4687320 2261640 2261640 defendant Plungar William   597521 597521 Plungar, William, of Kyrtlyngton, parson 0
4687321 2261640 2261640 defendant Eston John de gent 597521 597521 Eston, John de, of Kyrtlyngton, gent 1
4687322 2261640 2261640 defendant Plunger John yeoman 703420 703420 Plunger, John, of Kyrtlington, yeoman 2
4687323 2261640 2261640 defendant Vale Robert   597521 597521 Vale, Robert, of Kyrtlyngton, servant 3
4687324 2261640 2261640 defendant Mason Henry husbandman 597521 597521 Mason, Henry, of Kyrtlyngton, husbandman 4
4687325 2261640 2261640 defendant Smyth Alexander husbandman 597521 597521 Smyth, Alexander, of Kyrtlyngton, husbandman 5
4687326 2261640 2261640 defendant Budd Adam   597521 597521 Budd, Adam, of Kyrtlyngton, servant 6
4687327 2261640 2261640 defendant Hesilton John   597521 597521 Hesilton, John, of Kyrtlyngton, parish clerk 7
4687328 2261640 2261640 defendant Curtays William shoemaker 597521 597521 Curtays, William, of Kyrtlyngton, shoemaker 8

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