names

14 rows where case_id = 2350665

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4978950 2350665 2350665 plaintiff Sambroke Thomas     Sambroke, Thomas 0
4978951 2350665 2350665 defendant Hous Henry, senior husbandman 616756 616756 Hous, Henry, senior, of Uphill, husbandman 0
4978952 2350665 2350665 defendant Hous Nicholas husbandman 616756 616756 Hous, Nicholas, of Uphill, husbandman 1
4978953 2350665 2350665 defendant Came or Caine Nicholas husbandman 829902 829902 Came or Caine, Nicholas, of Worn, husbandman 2
4978954 2350665 2350665 defendant Come Nicholas husbandman 586682 586682 Come, Nicholas, of Mylton, husbandman 3
4978955 2350665 2350665 defendant Hous Nicholas   586682 586682 Hous, Nicholas, of Mylton, servant 4
4978956 2350665 2350665 defendant Lovell John husbandman 586682 586682 Lovell, John, of Mylton, husbandman 5
4978957 2350665 2350665 defendant Vale Thomas husbandman 632789 632789 Vale, Thomas, of Lokkyng, husbandman 6
4978958 2350665 2350665 defendant Gard William husbandman 632789 632789 Gard, William, of Lokkyng, husbandman 7
4978959 2350665 2350665 defendant Lenne John husbandman 721266 721266 Lenne, John, of Bleton, husbandman 8
4978960 2350665 2350665 defendant Colman Richard, senior husbandman 815225 815225 Colman, Richard, senior, of Shiplode, husbandman 9
4978961 2350665 2350665 defendant Colman Henry husbandman 815225 815225 Colman, Henry, of Shiplode, husbandman 10
4978962 2350665 2350665 defendant Sutton John husbandman 614167 614167 Sutton, John, of Hutton, husbandman 11
4978963 2350665 2350665 defendant Morys John husbandman 612655 612655 Morys, John, of Bledon, husbandman 12

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