names

15 rows where case_id = 2302247

✎ 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
4819726 2302247 2302247 plaintiff Pole John esq   Pole, John, esq 0
4819727 2302247 2302247 defendant Stafford Henry de gent 799329 799329 Stafford, Henry de, of Eyham, gent 0
4819728 2302247 2302247 defendant de Steffe Richard gent 807326 807326 de Steffe, Richard, of Helowe, gent 1
4819729 2302247 2302247 defendant Poynton Geoffrey yeoman 799329 799329 Poynton, Geoffrey, of Eyham, yeoman 2
4819730 2302247 2302247 defendant Cobyn Richard yeoman 799329 799329 Cobyn, Richard, of Eyham, yeoman 3
4819731 2302247 2302247 defendant Cobyn William yeoman 799329 799329 Cobyn, William, of Eyham, yeoman 4
4819732 2302247 2302247 defendant Milne Roger yeoman 799329 799329 Milne, Roger, of Eyham, yeoman 5
4819733 2302247 2302247 defendant Milne Thomas yeoman 799329 799329 Milne, Thomas, of Eyham, yeoman 6
4819734 2302247 2302247 defendant Milne John yeoman 799329 799329 Milne, John, of Eyham, yeoman 7
4819735 2302247 2302247 defendant de Bakewell Richard yeoman 807327 807327 de Bakewell, Richard, of Stone Medelton, yeoman 8
4819736 2302247 2302247 defendant Hasolum John de husbandman 807328 807328 Hasolum, John de, of Roland, husbandman 9
4819737 2302247 2302247 defendant Heton John de husbandman 807329 807329 Heton, John de, of Rolond, husbandman 10
4819738 2302247 2302247 defendant Haselom Richard husbandman 807328 807328 Haselom, Richard, of Roland, husbandman 11
4819739 2302247 2302247 defendant Mader Richard husbandman 807329 807329 Mader, Richard, of Rolond, husbandman 12
4819740 2302247 2302247 defendant Kyrkeby John de laborer 606263 606263 Kyrkeby, John de, of Wynster, laborer 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);