names

12 rows where place_id = 654904

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3934171 2001722 2001722 plaintiff Hawke Richard husbandman 654904 654904 Hawke, Richard, of Great Hormede, husbandman 0
4695101 2263961 2263961 plaintiff Braunceton Hubert   654904 654904 Braunceton, Hubert, of Great Hormede, vicar 0
4808197 2298741 2298741 defendant Jangle Richard husbandman 654904 654904 Jangle, Richard, of Great Hormede, husbandman 0
4908670 2329265 2329265 defendant Jangill Richard husbandman 654904 654904 Jangill, Richard, of Great Hormede, husbandman 2
5367332 2465436 2465436 defendant Hanke William husbandman 654904 654904 Hanke, William, of Great Hormede, husbandman 0
5368050 2465629 2465629 defendant Watey Thomas husbandman 654904 654904 Watey, Thomas, of Great Hormede, husbandman 0
5368051 2465629 2465629 defendant Shangyll John husbandman 654904 654904 Shangyll, John, of Great Hormede, husbandman 1
5390936 2472473 2472473 defendant Shepard John yeoman 654904 654904 Shepard, John, of Great Hormede, yeoman 1
5403768 2476153 2476153 defendant Shepard Johhn yeoman 654904 654904 Shepard, Johhn, of Great Hormede, yeoman 1
5416933 2479978 2479978 defendant Shepard John yeoman 654904 654904 Shepard, John, of Great Hormede, yeoman 1
5434004 2485123 2485123 defendant Shepard John yeoman 654904 654904 Shepard, John, of Great Hormede, yeoman 1
5434007 2485124 2485124 defendant Shepard John yeoman 654904 654904 Shepard, John, of Great Hormede, 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);