names

15 rows where place_id = 615791

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3710781 1929689 1929689 defendant Smyth William husbandman 615791 615791 Smyth, William, of Wymbyldon, husbandman 0
3711872 1930029 1930029 defendant Smyth William husbandman 615791 615791 Smyth, William, of Wymbyldon, husbandman 0
4651651 2246501 2246501 defendant Recolver Robert husbandman 615791 615791 Recolver, Robert, of Wymbyldon, husbandman 20
4651766 2246510 2246510 defendant Hervy John husbandman 615791 615791 Hervy, John, of Wymbyldon, husbandman 0
4651827 2246513 2246513 defendant Reculver Robert husbandman 615791 615791 Reculver, Robert, of Wymbyldon, husbandman 21
4787014 2292003 2292003 defendant Doun John, junior husbandman 615791 615791 Doun, John, junior, of Wymbyldon, husbandman 3
4787020 2292004 2292004 defendant Doun John, junior husbandman 615791 615791 Doun, John, junior, of Wymbyldon, husbandman 3
5088828 2383109 2383109 defendant Leueston or Leneston Philip gent 615791 615791 Leueston or Leneston, Philip, of Wymbyldon, gent 0
5287776 2441449 2441449 defendant Hoke William yeoman 615791 615791 Hoke, William, of Wymbyldon, yeoman 0
5291643 2442562 2442562 defendant Stokton Robert chaplain 615791 615791 Stokton, Robert, of Wymbyldon, chaplain 0
5293045 2442949 2442949 defendant Colchestre John husbandman 615791 615791 Colchestre, John, of Wymbyldon, husbandman 1
5293046 2442949 2442949 defendant Recolver William husbandman 615791 615791 Recolver, William, of Wymbyldon, husbandman 2
5294217 2443279 2443279 defendant Stokton Robert chaplain 615791 615791 Stokton, Robert, of Wymbyldon, chaplain 0
5343572 2458177 2458177 defendant Weller John husbandman 615791 615791 Weller, John, of Wymbyldon, husbandman 0
5343573 2458177 2458177 defendant Reculvyr Richard husbandman 615791 615791 Reculvyr, Richard, of Wymbyldon, husbandman 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);