names

9 rows where place_id = 754062

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4417738 2170426 2170426 defendant Gurdelere John le   754062 754062 Gurdelere, John le, of Stonleye, son of Adam 6
4417739 2170426 2170426 defendant Carpenter Walter   754062 754062 Carpenter, Walter, of Stonleye 7
4417741 2170426 2170426 defendant Hookere Roger le   754062 754062 Hookere, Roger le, of Stonleye, servant of Richard 9
4417742 2170426 2170426 defendant Baron Nicholas   754062 754062 Baron, Nicholas, of Stonleye, son of John 10
4417780 2170437 2170437 defendant Eyr Richard le   754062 754062 Eyr, Richard le, of Stonleye, son of Robert 0
4417781 2170437 2170437 defendant Eyr Henry le   754062 754062 Eyr, Henry le, of Stonleye, son of Robert 1
4456967 2187189 2187189 defendant Pyre Thomas   754062 754062 Pyre, Thomas, of Stonleye, abbot 0
5615504 2548637 2548637 defendant Pype Thomas   754062 754062 Pype, Thomas, of Stonleye, abbot 0
5621410 2550589 2550589 defendant Steleworth William   754062 754062 Steleworth, William, of Stonleye 0

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