names

15 rows where case_id = 2456605

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
5338469 2456605 2456605 plaintiff Lee Ralph     Lee, Ralph 0
5338470 2456605 2456605 defendant Parker John husbandman 651315 651315 Parker, John, of Medryngham, husbandman 0
5338471 2456605 2456605 defendant Bavyn Robert husbandman 651315 651315 Bavyn, Robert, of Medryngham, husbandman 1
5338472 2456605 2456605 defendant Mason Thomas husbandman 651315 651315 Mason, Thomas, of Medryngham, husbandman 2
5338473 2456605 2456605 defendant Wenslade John husbandman 651315 651315 Wenslade, John, of Medryngham, husbandman 3
5338474 2456605 2456605 defendant Sayre Robert husbandman 651315 651315 Sayre, Robert, of Medryngham, husbandman 4
5338475 2456605 2456605 defendant Ridoute Henry husbandman 651315 651315 Ridoute, Henry, of Medryngham, husbandman 5
5338476 2456605 2456605 defendant Pallay Adam husbandman 651315 651315 Pallay, Adam, of Medryngham, husbandman 6
5338477 2456605 2456605 defendant York William husbandman 651315 651315 York, William, of Medryngham, husbandman 7
5338478 2456605 2456605 defendant Benton Robert husbandman 651315 651315 Benton, Robert, of Medryngham, husbandman 8
5338479 2456605 2456605 defendant Belcheforth Thomas husbandman 651315 651315 Belcheforth, Thomas, of Medryngham, husbandman 9
5338480 2456605 2456605 defendant Squyer Robert husbandman 651315 651315 Squyer, Robert, of Medryngham, husbandman 10
5338481 2456605 2456605 defendant Proctour William husbandman 651315 651315 Proctour, William, of Medryngham, husbandman 11
5338482 2456605 2456605 defendant Wryght Richard husbandman 651315 651315 Wryght, Richard, of Medryngham, husbandman 12
5338483 2456605 2456605 defendant Kyme John husbandman 651315 651315 Kyme, John, of Medryngham, 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);