names

26 rows where case_id = 2474358

✎ 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
5397480 2474358 2474358 plaintiff Buxton Robert     Buxton, Robert, on his own account 0
5397481 2474358 2474358 defendant Penonn John husbandman 771570 771570 Penonn, John, of Groundesburgh, husbandman 0
5397482 2474358 2474358 defendant Soty Gregory baker 586134 586134 Soty, Gregory, of Ipswich, baker 1
5397483 2474358 2474358 defendant Middelton Thomas laborer 633304 633304 Middelton, Thomas, of Netilsted, laborer 2
5397484 2474358 2474358 defendant Taverner John husbandman 634335 634335 Taverner, John, of Freeston, husbandman 3
5397485 2474358 2474358 defendant Denys John husbandman 586134 586134 Denys, John, of Ipswich, husbandman 4
5397486 2474358 2474358 defendant Tarle Edmund tailor 767615 767615 Tarle, Edmund, of Braham, tailor 5
5397487 2474358 2474358 defendant Brightwell Robert husbandman 590415 590415 Brightwell, Robert, of Mildenhale, husbandman 6
5397488 2474358 2474358 defendant Copynger Richard husbandman 590415 590415 Copynger, Richard, of Mildenhale, husbandman 7
5397489 2474358 2474358 defendant Fyssh William yeoman 586180 586180 Fyssh, William, of Bury St Edmunds, yeoman 8
5397490 2474358 2474358 defendant Longe William   586134 586134 Longe, William, of Ipswich, notary 9
5397491 2474358 2474358 defendant Furnage Henry yeoman 674509 674509 Furnage, Henry, of Stradbrook, yeoman 10
5397492 2474358 2474358 defendant Dunche Margery widow 589379 589379 Dunche, Margery, of Mendelesham, widow 11
5397493 2474358 2474358 defendant Kent John husbandman 590362 590362 Kent, John, of Eston, husbandman 12
5397494 2474358 2474358 defendant Praty John smith 587550 587550 Praty, John, of Eye, smith 13
5397495 2474358 2474358 defendant Dryver John yeoman 587464 587464 Dryver, John, of Bakton, yeoman 14
5397496 2474358 2474358 defendant Wale Henry husbandman 605349 605349 Wale, Henry, of Little Thornham, husbandman 15
5397497 2474358 2474358 defendant Haton Thomas yeoman 593914 593914 Haton, Thomas, of Hygham, yeoman 16
5397498 2474358 2474358 defendant Norffolk Thomas laborer 592979 592979 Norffolk, Thomas, of Tatyngston, laborer 17
5397499 2474358 2474358 defendant Podde or Codde Robert husbandman 592979 592979 Podde or Codde, Robert, of Tatyngston, husbandman 18
5397500 2474358 2474358 defendant Linit Robert yeoman 757947 757947 Linit, Robert, of Wodebregge, yeoman 19
5397501 2474358 2474358 defendant Pye John yeoman 585947 585947 Pye, John, of Hadley, yeoman 20
5397502 2474358 2474358 defendant Feltewell John chapman 586134 586134 Feltewell, John, of Ipswich, chapman 21
5397503 2474358 2474358 defendant Ine William yeoman 587061 587061 Ine, William, of Combes, yeoman 22
5397504 2474358 2474358 defendant Arnold William yeoman 882978 882978 Arnold, William, of Labford, Essex, yeoman 23
5397505 2474358 2474358 defendant Suffolke John butcher 604018 604018 Suffolke, John, of Colchester, Essex, butcher 24

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