names

20 rows where case_id = 2491133

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, place_id

id ▼ case_id role surname forename occupation place_id raw_segment seq
5454119 2491133 2491133 defendant Hervy Robert baker 586134 586134 Hervy, Robert, of Ipswich, baker 0
5454120 2491133 2491133 defendant Grene Robert butcher 591275 591275 Grene, Robert, of Stowe Market, butcher 1
5454121 2491133 2491133 defendant (illegible)   husbandman   _, husbandman 2
5454122 2491133 2491133 defendant Hewet William   592767 592767 Hewet, William, of Stoke Neylond 3
5454123 2491133 2491133 defendant (illegible) of Bury St Edmunds weaver   _, of Bury St Edmunds, weaver 4
5454124 2491133 2491133 defendant Bradewey Robert   586505 586505 Bradewey, Robert, of Brokford 5
5454125 2491133 2491133 defendant Daubeney Roger husbandman   Daubeney, Roger, husbandman 6
5454126 2491133 2491133 defendant Lely Robert tailor 587821 587821 Lely, Robert, of South Elmham, tailor 7
5454127 2491133 2491133 defendant (illegible) of _ by Culpho husbandman   _, of _ by Culpho, husbandman 8
5454128 2491133 2491133 defendant Edwyn John husbandman 621402 621402 Edwyn, John, of Tudenham, husbandman 9
5454129 2491133 2491133 defendant Cullom John   588932 588932 Cullom, John, of Ocolt 10
5454130 2491133 2491133 defendant Lopham Robert   757947 757947 Lopham, Robert, of Wodebregge 11
5454131 2491133 2491133 defendant Page John   588489 588489 Page, John, of Melton, pedlar 12
5454132 2491133 2491133 defendant Thomson Ralph carpenter   Thomson, Ralph, carpenter 13
5454133 2491133 2491133 defendant Goodwyn William butcher 759694 759694 Goodwyn, William, of Brundyssh, butcher 14
5454134 2491133 2491133 defendant (illegible) of Snape husbandman   _, of Snape, husbandman 15
5454135 2491133 2491133 defendant Cady Thomas     Cady, Thomas 16
5454136 2491133 2491133 defendant Tarle Thomas clerk 586134 586134 Tarle, Thomas, of Ipswich, clerk 17
5454137 2491133 2491133 defendant (illegible) of Essex fuller   _, of Essex, fuller 18
5454138 2491133 2491133 defendant Lyghtffoot John   587414 587414 Lyghtffoot, John, of Thetford 19

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