names

18 rows where case_id = 2247093

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4653737 2247093 2247093 plaintiff Berkeley Thomas knight, Lord Berkeley   Berkeley, Thomas, knight, Lord Berkeley 0
4653738 2247093 2247093 defendant Fermour John husbandman 778408 778408 Fermour, John, of Rommesbury, husbandman 0
4653739 2247093 2247093 defendant Quache William laborer 778408 778408 Quache, William, of Rommesbury, laborer 1
4653740 2247093 2247093 defendant Renewhey or Revewhey John   594871 594871 Renewhey or Revewhey, John, of Devyses, net maker 2
4653741 2247093 2247093 defendant Bubbe John that was Williames servant Covyntre, of Okeburn, yeoman   Bubbe, John, that was Williames servant Covyntre, of Okeburn, yeoman 3
4653742 2247093 2247093 defendant Clerk William   591145 591145 Clerk, William, of Hungerford, Berks, holy water clerk 4
4653743 2247093 2247093 defendant Devenyssh Robert tailor 595915 595915 Devenyssh, Robert, of Hungerford, tailor 5
4653744 2247093 2247093 defendant Note John   600872 600872 Note, John, of Abyngton 6
4653745 2247093 2247093 defendant Seymour John laborer 778411 778411 Seymour, John, of Holte, Berks, laborer 7
4653746 2247093 2247093 defendant Blakgrove William husbandman 740713 740713 Blakgrove, William, of Estbury, Berks, husbandman 8
4653747 2247093 2247093 defendant Touke John husbandman 587035 587035 Touke, John, of Estbury, husbandman 9
4653748 2247093 2247093 defendant Bye John berks, laborer 589052 589052 Bye John, of Clopton, berks, laborer 10
4653749 2247093 2247093 defendant Roger that was Williames Servant Covyntry of Clopton servant   Roger that was Williames Servant Covyntry, of Clopton, servant 11
4653750 2247093 2247093 defendant Milward William   779486 779486 Milward, William, of Deneford, Berks, millward 12
4653751 2247093 2247093 defendant Helle William husbandman 669560 669560 Helle, William, of Inkepen, Berks, Berks, husbandman 13
4653752 2247093 2247093 defendant Serne John husbandman 674450 674450 Serne, John, of Inkepen, husbandman 14
4653753 2247093 2247093 defendant Welshe Robert tailor 595915 595915 together with Welshe, Robert, of Hungerford, tailor 15
4653754 2247093 2247093 defendant Trycer John of Holte Berks, husbandman   Trycer, John of Holte, Berks, husbandman 16

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