names

16 rows where case_id = 2382040

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5085068 2382040 2382040 plaintiff Gore William   588518 588518 Gore, William, of Aldryngton 0
5085069 2382040 2382040 defendant Baron William husbandman 595378 595378 Baron, William, of Potterne, husbandman 0
5085070 2382040 2382040 defendant Hert John laborer 602405 602405 Hert, John, of South Brome, laborer 1
5085071 2382040 2382040 defendant Dorchestre John roper 602405 602405 Dorchestre, John, of South Brome, roper 2
5085072 2382040 2382040 defendant Purye John husbandman 595378 595378 Purye, John, of Potterne, husbandman 3
5085073 2382040 2382040 defendant Lylbrone John yeoman 595378 595378 Lylbrone, John, of Potterne, yeoman 4
5085074 2382040 2382040 defendant Ryse John husbandman 595378 595378 Ryse, John, of Potterne, husbandman 5
5085075 2382040 2382040 defendant Meryet John husbandman 844596 844596 Meryet, John, of Wyke, Bishops Canynges, husbandman 6
5085076 2382040 2382040 defendant Amys John butcher 595378 595378 Amys, John, of Potterne, butcher 7
5085077 2382040 2382040 defendant Barbour William butcher 595378 595378 Barbour, William, of Potterne, butcher 8
5085078 2382040 2382040 defendant Bony or Bovy John husbandman 595378 595378 Bony or Bovy, John, of Potterne, husbandman 9
5085079 2382040 2382040 defendant Colyns Thomas, junior husbandman 595378 595378 Colyns, Thomas, junior, of Potterne, husbandman 10
5085080 2382040 2382040 defendant Smyth Robert husbandman 595378 595378 Smyth, Robert, of Potterne, husbandman 11
5085081 2382040 2382040 defendant Grevell Thomas butcher 595378 595378 Grevell, Thomas, of Potterne, butcher 12
5085082 2382040 2382040 defendant Berde Thomas   844597 844597 Berde, Thomas, of Potterne, husbandmn 13
5085083 2382040 2382040 defendant Swayn Robert laborer 595378 595378 Swayn, Robert, of Potterne, laborer 14

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