names

20 rows where place_id = 618296

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3723778 1933713 1933713 defendant Ven Henry, senior tailor 618296 618296 Ven, Henry, senior, of Aveton Gyfford, tailor 0
3723779 1933713 1933713 defendant Van Henry, junior   618296 618296 Van, Henry, junior, of Aveton Gyfford, groom 1
3736005 1937501 1937501 defendant Hays John husbandman 618296 618296 Hays, John, of Aveton Gyfford, husbandman 0
3790975 1955013 1955013 defendant Wakeham Richard tailor 618296 618296 Wakeham, Richard, of Aveton Gyfford, tailor 0
3790976 1955013 1955013 defendant Phelyppe John   618296 618296 Phelyppe, John, of Aveton Gyfford, mason 1
3838347 1969913 1969913 defendant Wakeham Simon butcher 618296 618296 Wakeham, Simon, of Aveton Gyfford, butcher 1
3855210 1975262 1975262 defendant Tabbe John husbandman 618296 618296 Tabbe, John, of Aveton Gyfford, husbandman 0
3855212 1975263 1975263 defendant Tabbe John husbandman 618296 618296 Tabbe, John, of Aveton Gyfford, husbandman 0
3914132 1995072 1995072 defendant Honychurche Anthony gent 618296 618296 Honychurche, Anthony, of Aveton Gyfford, gent 0
4002973 2025829 2025829 defendant Horne Robert husbandman 618296 618296 Horne, Robert, of Aveton Gyfford, husbandman 3
4025465 2033769 2033769 defendant Honychyrche Anthony esq 618296 618296 Honychyrche, Anthony, of Aveton Gyfford, esq 0
4877304 2319856 2319856 defendant Bonde Lionel husbandman 618296 618296 Bonde, Lionel, of Aveton Gyfford, husbandman 0
5039189 2368362 2368362 defendant Wilcok John chaplain 618296 618296 Wilcok, John, of Aveton Gyfford, chaplain 1
5039190 2368362 2368362 defendant Vele Robert husbandman 618296 618296 Vele, Robert, of Aveton Gyfford, husbandman 2
5152572 2401890 2401890 defendant Danyell Henry tailor 618296 618296 Danyell, Henry, of Aveton Gyfford, tailor 0
5222366 2422249 2422249 defendant Danyell Henry tailor 618296 618296 Danyell, Henry, of Aveton Gyfford, tailor 3
5236938 2426386 2426386 defendant Hille Richard husbandman 618296 618296 Hille, Richard, of Aveton Gyfford, husbandman 0
5260556 2433436 2433436 defendant Phelip Stephen butcher 618296 618296 Phelip, Stephen, of Aveton Gyfford, butcher 0
5386454 2471198 2471198 defendant Harry Hugh husbandman 618296 618296 Harry, Hugh, of Aveton Gyfford, husbandman 0
5415429 2479551 2479551 defendant Coyte Henry chaplain 618296 618296 Coyte, Henry, of Aveton Gyfford, chaplain 1

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