names

16 rows where place_id = 603744

✎ 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
3655661 1912034 1912034 defendant Gary John husbandman 603744 603744 Gary, John, of Froyle, husbandman 0
4422577 2171918 2171918 plaintiff Enham Thomas de master & parson 603744 603744 Enham, Thomas de, of Froyle, master & parson 0
4437572 2176507 2176507 defendant Blaunchard John   603744 603744 Blaunchard, John, of Froyle 0
4554119 2217210 2217210 defendant Bannebury John   603744 603744 Bannebury, John, of Froyle 3
4631730 2240807 2240807 defendant Gateryche Roger   603744 603744 Gateryche, Roger, of Froyle 0
4856641 2313456 2313456 defendant Chapman Roger chapman 603744 603744 Chapman, Roger, of Froyle, chapman 0
4907417 2328881 2328881 defendant Pelehurst William husbandman 603744 603744 Pelehurst, William, of Froyle, husbandman 1
4907418 2328881 2328881 defendant Blanchard William   603744 603744 Blanchard, William, of Froyle 2
5285371 2440742 2440742 defendant Wythere William husbandman 603744 603744 Wythere, William, of Froyle, husbandman 0
5370889 2466482 2466482 defendant Reynold John   603744 603744 Reynold, John, of Froyle, gent, son & heir of Willliam Reynold 0
5401174 2475398 2475398 defendant Reynold John   603744 603744 Reynold, John, of Froyle, gent, son & heir of William Reynold 0
5401178 2475399 2475399 defendant Reynold John   603744 603744 Reynold, John, of Froyle, gent, son & heir of William Reynold 0
5414193 2479182 2479182 defendant Reynold John   603744 603744 Reynold, John, of Froyle, gent, son & heir of William Reynold 0
5414197 2479183 2479183 defendant Reynold John   603744 603744 Reynold, John, of Froyle, gent, son & heir of William Reynold 0
5558495 2522432 2522432 defendant Belle Thomas husbandman 603744 603744 Belle, Thomas, of Froyle, husbandman 0
5605743 2536684 2536684 defendant Alderslade Thomas husbandman 603744 603744 Alderslade, Thomas, of Froyle, husbandman 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);