names

17 rows where case_id = 2256651

✎ 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
4671193 2256651 2256651 plaintiff Camoys Thomas knight   Camoys, Thomas, knight 0
4671194 2256651 2256651 defendant Chaumberlayn Robert hosteler 593160 593160 Chaumberlayn, Robert, of Dorkyng, hosteler 0
4671195 2256651 2256651 defendant Asshurste Richard husbandman 604906 604906 Asshurste, Richard, of Becheworth, husbandman 1
4671196 2256651 2256651 defendant Smyth William smith 593160 593160 Smyth, William, of Dorkyng, smith 2
4671197 2256651 2256651 defendant Lichiare John fletcher 593160 593160 Lichiare, John, of Dorkyng, fletcher 3
4671198 2256651 2256651 defendant Skete Richard husbandman 593160 593160 Skete, Richard, of Dorkyng, husbandman 4
4671199 2256651 2256651 defendant Coke William warner 781103 781103 Coke, William, of Raygate or Reigate, warner 5
4671200 2256651 2256651 defendant Baker William baker 650745 650745 Baker, William, of Raygate, baker 6
4671201 2256651 2256651 defendant Baker William baker 781104 781104 Baker, William, of Lederede or Leatherhead, baker 7
4671202 2256651 2256651 defendant Dode Thomas husbandman 650745 650745 Dode, Thomas, of Raygate, husbandman 8
4671203 2256651 2256651 defendant Potrythe John warner 593160 593160 Potrythe, John, of Dorkyng, warner 9
4671204 2256651 2256651 defendant Mulsey John laborer 593160 593160 Mulsey, John, of Dorkyng, laborer 10
4671205 2256651 2256651 defendant Beelde Richard husbandman 650745 650745 with Beelde, Richard, of Raygate, husbandman 11
4671206 2256651 2256651 defendant Bourare Robert parker 781101 781101 Bourare, Robert, of Becheworthe, parker 12
4671207 2256651 2256651 defendant atte Pyree Henry laborer 593160 593160 atte Pyree, Henry, of Dorkyng, laborer 13
4671208 2256651 2256651 defendant Lovelambe Henry husbandman 781102 781102 Lovelambe, Henry, of Mekylhamme, husbandman 14
4671209 2256651 2256651 defendant atte Heglylonde William shoemaker 593160 593160 atte Heglylonde, William, of Dorkyng, shoemaker 15

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