names

13 rows where case_id = 2512830

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5526385 2512830 2512830 plaintiff Huberd James     Huberd, James 0
5526386 2512830 2512830 defendant Thomas John yeoman 586023 586023 Thomas, John, of Laughton, yeoman 0
5526387 2512830 2512830 defendant Brokpole John yeoman 585987 585987 Brokpole, John, of Buksted, yeoman 1
5526388 2512830 2512830 defendant Gower Richard husbandman 585987 585987 Gower, Richard, of Buksted, husbandman 2
5526389 2512830 2512830 defendant Harper John husbandman 585987 585987 Harper, John, of Buksted, husbandman 3
5526390 2512830 2512830 defendant Erle William husbandman 622170 622170 Erle, William, of Walderne, husbandman 4
5526391 2512830 2512830 defendant Weller John husbandman 585987 585987 Weller, John, of Buksted, husbandman 5
5526392 2512830 2512830 defendant Delve or Delne William husbandman 585987 585987 Delve or Delne, William, of Buksted, husbandman 6
5526393 2512830 2512830 defendant Gobard Robert laborer 585987 585987 Gobard, Robert, of Buksted, laborer 7
5526394 2512830 2512830 defendant Burgeys Henry husbandman 585987 585987 Burgeys, Henry, of Buksted, husbandman 8
5526395 2512830 2512830 defendant Burgeys Andrew husbandman 585987 585987 Burgeys, Andrew, of Buksted, husbandman 9
5526396 2512830 2512830 defendant Meynard William husbandman 777598 777598 Meynard, William, of Mawefeld, husbandman 10
5526397 2512830 2512830 defendant Couper Richard yeoman 777598 777598 Couper, Richard, of Mawefeld, yeoman 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);