names

22 rows where case_id = 2482336

✎ 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
5424631 2482336 2482336 plaintiff Buxton Robert     Buxton, Robert, on his own account 0
5424632 2482336 2482336 defendant Hervy Robert baker 586134 586134 Hervy, Robert, of Ipswich, baker 0
5424633 2482336 2482336 defendant Grene Robert butcher 586818 586818 Grene, Robert, of Stowemarket, butcher 1
5424634 2482336 2482336 defendant Hasyll John husbandman 588671 588671 Hasyll, John, of Berkyng, husbandman 2
5424635 2482336 2482336 defendant Hewet William clothman 592767 592767 Hewet, William, of Stoke Neylond, clothman 3
5424636 2482336 2482336 defendant Goodale Edmund weaver 586180 586180 Goodale, Edmund, of Bury St Edmunds, weaver 4
5424637 2482336 2482336 defendant Crewley Robert yeoman 586505 586505 Crewley, Robert, of Brokford, yeoman 5
5424638 2482336 2482336 defendant Daubeney Roger husbandman 882974 882974 Daubeney, Roger, of Tudenham by Culpho, husbandman 6
5424639 2482336 2482336 defendant Lely Robert tailor 587821 587821 Lely, Robert, of South Elmham, tailor 7
5424640 2482336 2482336 defendant Heyward William husbandman 886134 886134 Heyward, William, of Tudenham by Culsho, husbandman 8
5424641 2482336 2482336 defendant Ewyn John, sen husbandman 621402 621402 Ewyn, John, sen, of Tudenham, husbandman 9
5424642 2482336 2482336 defendant Cullom John husbandman 588932 588932 Cullom, John, of Ocolt, husbandman 10
5424643 2482336 2482336 defendant Lopham Robert   757947 757947 Lopham, Robert, of Wodebregge, pedlar 11
5424644 2482336 2482336 defendant Page John   588489 588489 Page, John, of Melton, pedlar 12
5424645 2482336 2482336 defendant Thomson Ralph carpenter 588489 588489 Thomson, Ralph, of Melton, carpenter 13
5424646 2482336 2482336 defendant Goodwyn William butcher 759694 759694 Goodwyn, William, of Brundyssh, butcher 14
5424647 2482336 2482336 defendant Ferrour Robert husbandman 753434 753434 Ferrour, Robert, of Perham, husbandman 15
5424648 2482336 2482336 defendant Spryngwell William husbandman 586098 586098 Spryngwell, William, of Snape, husbandman 16
5424649 2482336 2482336 defendant Geldy Thomas yeoman 586134 586134 Geldy, Thomas, of Ipswich, yeoman 17
5424650 2482336 2482336 defendant Tarle Thomas clerk 586134 586134 Tarle, Thomas, of Ipswich, clerk 18
5424651 2482336 2482336 defendant Warner William fuller 591291 591291 Warner, William, of Dedham, Essex, fuller 19
5424652 2482336 2482336 defendant Lyghtfoot John weaver 587414 587414 Lyghtfoot, John, of Thetford, 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);