names

28 rows where case_id = 2389002

✎ 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
5108775 2389002 2389002 plaintiff Flemyng Simon     Flemyng, Simon 0
5108776 2389002 2389002 defendant Bould Elizabeth widow 632883 632883 Bould, Elizabeth, of Carleton in Craven, widow 0
5108777 2389002 2389002 defendant Bould Brian esq 632883 632883 Bould, Brian, of Carleton in Craven, esq 1
5108778 2389002 2389002 defendant Erlescotes Henry gent 632883 632883 Erlescotes, Henry, of Carleton in Craven, gent 2
5108779 2389002 2389002 defendant Baker Henry yeoman 632883 632883 Baker, Henry, of Carleton in Craven, yeoman 3
5108780 2389002 2389002 defendant Scalys Thomas husbandman 632883 632883 Scalys, Thomas, of Carleton in Craven, husbandman 4
5108781 2389002 2389002 defendant Scalys John laborer 632883 632883 Scalys, John, of Carleton in Craven, laborer 5
5108782 2389002 2389002 defendant Scalys James laborer 632883 632883 Scalys, James, of Carleton in Craven, laborer 6
5108783 2389002 2389002 defendant Scalys William   632883 632883 Scalys, William, of Carleton in Craven, servant 7
5108784 2389002 2389002 defendant Doweson Alexander yeoman 632883 632883 Doweson, Alexander, of Carleton in Craven, yeoman 8
5108785 2389002 2389002 defendant Gawkethorp James husbandman 632883 632883 Gawkethorp, James, of Carleton in Craven, husbandman 9
5108786 2389002 2389002 defendant Gawkethorp Gerard laborer 632883 632883 Gawkethorp, Gerard, of Carleton in Craven, laborer 10
5108787 2389002 2389002 defendant Scot William   632883 632883 Scot, William, of Carleton in Craven, servant 11
5108788 2389002 2389002 defendant Whitwain John laborer 632883 632883 Whitwain, John, of Carleton in Craven, laborer 12
5108789 2389002 2389002 defendant Lyster Henry chaplain 586121 586121 Lyster, Henry, of Carleton, chaplain 13
5108790 2389002 2389002 defendant Sutheron Roger miller 586121 586121 Sutheron, Roger, of Carleton, miller 14
5108791 2389002 2389002 defendant Middelbrok Lawrence husbandman 586121 586121 Middelbrok, Lawrence, of Carleton, husbandman 15
5108792 2389002 2389002 defendant Dawe John   586121 586121 Dawe, John, of Carleton, coverlet weaver 16
5108793 2389002 2389002 defendant Grene John husbandman 586121 586121 Grene, John, of Carleton, husbandman 17
5108794 2389002 2389002 defendant Bennes John yeoman 586121 586121 Bennes, John, of Carleton, yeoman 18
5108795 2389002 2389002 defendant Wilson William husbandman 586121 586121 Wilson, William, of Carleton, husbandman 19
5108796 2389002 2389002 defendant Reyner John tailor 586121 586121 Reyner, John, of Carleton, tailor 20
5108797 2389002 2389002 defendant Kyng John   586121 586121 Kyng, John, of Carleton, servant 21
5108798 2389002 2389002 defendant Capon William tailor 586121 586121 Capon, William, of Carleton, tailor 22
5108799 2389002 2389002 defendant Capon John laborer 586121 586121 Capon, John, of Carleton, laborer 23
5108800 2389002 2389002 defendant Sallay John yeoman 847362 847362 Sallay, John, of Conyngley, yeoman 24
5108801 2389002 2389002 defendant Coke William laborer 847362 847362 Coke, William, of Conyngley, laborer 25
5108802 2389002 2389002 defendant Jenkynson Thomas laborer 847362 847362 Jenkynson, Thomas, of Conyngley, laborer 26

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