names

8 rows where place_id = 754082

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
4417823 2170447 2170447 defendant Stedman Robert   754082 754082 Stedman, Robert, of Croundale 13
4428508 2173727 2173727 defendant Stedman Robert   754082 754082 Stedman, Robert, of Croundale 13
4603875 2232395 2232395 plaintiff Wykeham John master & parson 754082 754082 Wykeham, John, of Croundale, master & parson 0
4622438 2238000 2238000 defendant Ball William   754082 754082 Ball, William, of Croundale 0
4734526 2275965 2275965 defendant Lynham William   754082 754082 Lynham, William, of Croundale, mill ward 0
5499651 2504837 2504837 defendant Knyght John chaplain 754082 754082 Knyght, John, of Croundale, chaplain 0
5590288 2531934 2531934 defendant Cawode Edward yeoman 754082 754082 Cawode, Edward, of Croundale, yeoman 1
5590308 2531941 2531941 defendant Cawode Edward yeoman 754082 754082 Cawode, Edward, of Croundale, yeoman 1

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