names

15 rows where case_id = 2381463

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
5083142 2381463 2381463 plaintiff Est Robert esq   Est, Robert, esq 0
5083143 2381463 2381463 defendant Eldergate Richard gent 597142 597142 Eldergate, Richard, of Wyngham, Kent, gent 0
5083144 2381463 2381463 defendant Eyer George gent 841336 841336 Eyer, George, of Batayll, Sussex, gent 1
5083145 2381463 2381463 defendant Fertyng William yeoman 844155 844155 Fertyng, William, of Batayll, yeoman 2
5083146 2381463 2381463 defendant Okherst Nicholas draper 844155 844155 Okherst, Nicholas, of Batayll, draper 3
5083147 2381463 2381463 defendant Staple Thomas butcher 844155 844155 Staple, Thomas, of Batayll, butcher 4
5083148 2381463 2381463 defendant White John laborer 844340 844340 White, John, of Beterysden, Kent, laborer 5
5083149 2381463 2381463 defendant Fayreware Edmund husbandman 844341 844341 Fayreware, Edmund, of Byrchynton, Isle of Thanet, Kent, husbandman 6
5083150 2381463 2381463 defendant Fayreware William laborer 601145 601145 Fayreware, William, of Herne, Kent, laborer 7
5083151 2381463 2381463 defendant Fayreware John barer 586175 586175 Fayreware, John, of Canterbury, barer 8
5083152 2381463 2381463 defendant Smyth William   597515 597515 Smyth, William, of Maideston, Kent, mason 9
5083153 2381463 2381463 defendant Bele William butcher 588508 588508 Bele, William, of Maideston, butcher 10
5083154 2381463 2381463 defendant Florance Robert chaplain 588508 588508 Florance, Robert, of Maideston, chaplain 11
5083155 2381463 2381463 defendant Keystrete John laborer 588508 588508 Keystrete, John, of Maideston, laborer 12
5083156 2381463 2381463 defendant Bydenden Thomas cordwainer 589284 589284 Bydenden, Thomas, of Lamberherst, Kent, cordwainer 13

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