names

14 rows where case_id = 2433767

✎ 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
5261688 2433767 2433767 plaintiff Monmouth Elizabeth widow of Monmouth, John   Monmouth, Elizabeth, widow of Monmouth, John 0
5261689 2433767 2433767 defendant Baret John, senior husbandman 614304 614304 Baret, John, senior, of Lamburn, Berks, husbandman 0
5261690 2433767 2433767 defendant Goreney Thomas yeoman 865531 865531 Goreney, Thomas, of Brode Somerford, Wilts, yeoman 1
5261691 2433767 2433767 defendant Wykewykes John husbandman 620553 620553 Wykewykes, John, of Brode Somerford, husbandman 2
5261692 2433767 2433767 defendant Verrey William husbandman 865532 865532 Verrey, William, of Litel Somerford, Wilts, husbandman 3
5261693 2433767 2433767 defendant Morys Thomas chaplain 587346 587346 Morys, Thomas, of Malmesbury, Wilts, chaplain 4
5261694 2433767 2433767 defendant Bawedewyn Thomas husbandman 620553 620553 Bawedewyn, Thomas, of Brode Somerford, husbandman 5
5261695 2433767 2433767 defendant Hunt Walter husbandman 620553 620553 Hunt, Walter, of Brode Somerford, husbandman 6
5261696 2433767 2433767 defendant Bokelond John husbandman 620553 620553 Bokelond, John, of Brode Somerford, husbandman 7
5261697 2433767 2433767 defendant Kyng William husbandman 620553 620553 Kyng, William, of Brode Somerford, husbandman 8
5261698 2433767 2433767 defendant Pelkerugge William husbandman 620553 620553 Pelkerugge, William, of Brode Somerford, husbandman 9
5261699 2433767 2433767 defendant Pelkerugge Edward husbandman 620553 620553 Pelkerugge, Edward, of Brode Somerford, husbandman 10
5261700 2433767 2433767 defendant Grey Thomas gent 637583 637583 Grey, Thomas, of Lydney, Glos, gent 11
5261701 2433767 2433767 defendant Golde Thomas yeoman 586958 586958 Golde, Thomas, of Gloucester, yeoman 12

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