names

20 rows where case_id = 2247096

✎ 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
4653763 2247096 2247096 plaintiff Berkeley Thomas   593634 593634 Berkeley, Thomas, of Berkeley, knight 0
4653764 2247096 2247096 defendant Clerk William   595915 595915 Clerk, William, of Hungerford, holy water clerk 0
4653765 2247096 2247096 defendant John that was Williamesservant Covyntre of Hungerford carpenter   John that was Williamesservant Covyntre, of Hungerford, carpenter 1
4653766 2247096 2247096 defendant Devenyssh Robert tailor 595915 595915 Devenyssh, Robert, of Hungerford, tailor 2
4653767 2247096 2247096 defendant Note John laborer 778415 778415 Note, John, of Avynton, laborer 3
4653768 2247096 2247096 defendant Bye John laborer 589052 589052 Bye, John, of Clopton, laborer 4
4653769 2247096 2247096 defendant Robert that was Williamesservant Covyntry of Clopton servant   Robert that was Williamesservant Covyntry, of Clopton, servant 5
4653770 2247096 2247096 defendant Milleward William   772262 772262 Milleward, William, of Deneford, millward 6
4653771 2247096 2247096 defendant Helle William husbandman 674450 674450 Helle, William, of Inkepen, husbandman 7
4653772 2247096 2247096 defendant Serne John husbandman 674450 674450 Serne, John, of Inkepen, husbandman 8
4653773 2247096 2247096 defendant Fermour John husbandman 778417 778417 Fermour, John, of Remmesbury, Wilts, husbandman 9
4653774 2247096 2247096 defendant Quacche William laborer 592081 592081 Quacche, William, of Remmesbury, laborer 10
4653775 2247096 2247096 defendant Renewhey John   587188 587188 Renewhey, John, of Devyses, Wilts, net maker 11
4653776 2247096 2247096 defendant John Bubbe that was Williamesservant Covyntry of Okeburn Wilts, yeoman   John Bubbe that was Williamesservant Covyntry, of Okeburn, Wilts, yeoman 12
4653777 2247096 2247096 defendant Seymour William husbandman 611918 611918 together with Seymour, William, of Holte, husbandman 13
4653778 2247096 2247096 defendant Seymour John laborer 611918 611918 Seymour, John, of Holte, laborer 14
4653779 2247096 2247096 defendant Blakgrove William husbandman 587035 587035 Blakgrove, William, of Estbury, husbandman 15
4653780 2247096 2247096 defendant Touke John husbandman 587035 587035 Touke, John, of Estbury, husbandman 16
4653781 2247096 2247096 defendant Trytor John jusbandman 611918 611918 Trytor, John, of Holte, jusbandman 17
4653782 2247096 2247096 defendant Wolshe Robert tailor 595915 595915 Wolshe, Robert, of Hungerford, tailor 18

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