names

22 rows where case_id = 2474357

✎ 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
5397458 2474357 2474357 plaintiff Buxton Robert     Buxton, Robert, on his own account 0
5397459 2474357 2474357 defendant Hervy Robert baker 586134 586134 Hervy, Robert, of Ipswich, baker 0
5397460 2474357 2474357 defendant Grene Robert butcher 591275 591275 Grene, Robert, of Stowe Market, butcher 1
5397461 2474357 2474357 defendant Hasyll John husbandman 588671 588671 Hasyll, John, of Berkyng, husbandman 2
5397462 2474357 2474357 defendant Hewet William   592767 592767 Hewet, William, of Stoke Neylond, cloth man 3
5397463 2474357 2474357 defendant Goodale Edmund weaver 586180 586180 Goodale, Edmund, of Bury St Edmunds, weaver 4
5397464 2474357 2474357 defendant Bradewey Robert yeoman 586505 586505 Bradewey, Robert, of Brokford, yeoman 5
5397465 2474357 2474357 defendant Daubeney Roger husbandman 882974 882974 Daubeney, Roger, of Tudenham by Culpho, husbandman 6
5397466 2474357 2474357 defendant Lely Robert tailor 587821 587821 Lely, Robert, of South Elmham, tailor 7
5397467 2474357 2474357 defendant Heyward William husbandman 882974 882974 Heyward, William, of Tudenham by Culpho, husbandman 8
5397468 2474357 2474357 defendant Edwyn John, senior husbandman 621402 621402 Edwyn, John, senior, of Tudenham, husbandman 9
5397469 2474357 2474357 defendant Cullom John husbandman 882975 882975 Cullom, John, of Otolt, husbandman 10
5397470 2474357 2474357 defendant Lopham Robert   757947 757947 Lopham, Robert, of Wodebregge, pedlar 11
5397471 2474357 2474357 defendant Page John   588489 588489 Page, John, of Melton, pedlar 12
5397472 2474357 2474357 defendant Thomson Ralph carpenter 588489 588489 Thomson, Ralph, of Melton, carpenter 13
5397473 2474357 2474357 defendant Goodwyn William butcher 759694 759694 Goodwyn, William, of Brundyssh, butcher 14
5397474 2474357 2474357 defendant Ferrour Robert husbandman 753434 753434 Ferrour, Robert, of Perham, husbandman 15
5397475 2474357 2474357 defendant Spryngwell William husbandman 586098 586098 Spryngwell, William, of Snape, husbandman 16
5397476 2474357 2474357 defendant Cady Thomas yeoman 586134 586134 Cady, Thomas, of Ipswich, yeoman 17
5397477 2474357 2474357 defendant Tarle Thomas. of Ipswich clerk   Tarle, Thomas. of Ipswich, clerk 18
5397478 2474357 2474357 defendant Warner William fuller 591291 591291 Warner, William, of Dedham, Essex, fuller 19
5397479 2474357 2474357 defendant Lyghtfoot John weaver 590901 590901 Lyghtfoot, John, of Thetford, Norf, weaver 20

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