names

16 rows where case_id = 2330506

✎ 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
4912819 2330506 2330506 plaintiff Chancy Thomas gent 821013 821013 Chancy, Thomas, of Botermere, gent 0
4912820 2330506 2330506 plaintiff Chynnok John   821014 821014 Chynnok, John, of Bradenestoke, priorof the church of the BM 1
4912821 2330506 2330506 plaintiff Benger John   609852 609852 Benger, John, of Stowell, franklin 2
4912822 2330506 2330506 plaintiff Michell Thomas   593171 593171 Michell, Thomas, of Milton, franklin 3
4912823 2330506 2330506 plaintiff Bygge Thomas   821310 821310 with Bygge, Thomas, of Inkepenne, Berks, shepherd 4
4912824 2330506 2330506 plaintiff Kyrkeby Nicholas husbandman 642864 642864 Kyrkeby, Nicholas, of Farnham, Hants, husbandman 5
4912825 2330506 2330506 plaintiff Saunders John brother & canon with the prior   Saunders, John, brother & canon with the prior 6
4912826 2330506 2330506 plaintiff Smyth Roger smith 820538 820538 Smyth, Roger, of Burbache, Wilts, smith 7
4912827 2330506 2330506 plaintiff Balle John couper 821016 821016 Balle, John, of Wylcote, couper 8
4912828 2330506 2330506 plaintiff Taillour Lawrence tailor 821017 821017 Taillour, Lawrence, of Burbathe, tailor 9
4912829 2330506 2330506 plaintiff Chubbe Thomas laborer 593968 593968 Chubbe, Thomas, of Calne, laborer 10
4912830 2330506 2330506 plaintiff Barbour Roger tailor 593968 593968 Barbour, Roger, of Calne, tailor 11
4912831 2330506 2330506 plaintiff Andrewe Thomas laborer 593968 593968 Andrewe, Thomas, of Calne, laborer 12
4912832 2330506 2330506 plaintiff Parker Richard husbandman 595004 595004 Parker, Richard, of Chute, husbandman 13
4912833 2330506 2330506 plaintiff Kyng William yeoman 588802 588802 Kyng, William, of Wotton, Rever, yeoman 14
4912834 2330506 2330506 defendant Plantagenet or Lancaster Humphrey   806571 806571 Plantagenet or Lancaster, Humphrey, of Gloucester, Duke 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);