names

13 rows where case_id = 2289160

✎ 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
4778154 2289160 2289160 plaintiff Beaufort Henry Bishop of Winchester   Beaufort, Henry, Bishop of Winchester 0
4778155 2289160 2289160 defendant Holt John husbandman 801152 801152 Holt, John, of Crondele, Hants, husbandman 0
4778156 2289160 2289160 defendant Blekele Robert laborer 759003 759003 together with Blekele, Robert, of Farneburgh, laborer 1
4778157 2289160 2289160 defendant atte Forde Richard laborer 598047 598047 atte Forde, Richard, of Farneham, laborer 2
4778158 2289160 2289160 defendant Kayme William smith 588924 588924 Kayme, William, of Farnham, smith 3
4778159 2289160 2289160 defendant Melerst John, junior laborer 588924 588924 Melerst, John, junior, of Farnham, laborer 4
4778160 2289160 2289160 defendant Palmer Henry laborer 598378 598378 Palmer, Henry, of Crondale, laborer 5
4778161 2289160 2289160 defendant atte Mille John   598378 598378 atte Mille, John, of Crondale laborer 6
4778162 2289160 2289160 defendant Balchilde Thomas husbandman 801154 801154 Balchilde, Thomas, of Dogmersfeld, Hants, husbandman 7
4778163 2289160 2289160 defendant Clere Henry laborer 598378 598378 Clere, Henry, of Crondale, laborer 8
4778164 2289160 2289160 defendant Plouker or Plonker John husbandman 801155 801155 Plouker or Plonker, John, of Fythe, Hants, husbandman 9
4778165 2289160 2289160 defendant Smyth William, junior laborer 801156 801156 Smyth, William, junior, of Derford, Hants, laborer 10
4778166 2289160 2289160 defendant Gryme John husbandman 801157 801157 Gryme, John, of Hadle, Hants, husbandman 11

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