names

26 rows where case_id = 2482337

✎ 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
5424653 2482337 2482337 plaintiff Buxton Robert     Buxton, Robert, on his own account 0
5424654 2482337 2482337 defendant Penoun John husbandman 771570 771570 Penoun, John, of Groundesburgh, husbandman 0
5424655 2482337 2482337 defendant Soty Gregory baker 586134 586134 Soty, Gregory, of Ipswich, baker 1
5424656 2482337 2482337 defendant Middelton Thomas laborer 886135 886135 Middelton, Thomas, of Netlisted, laborer 2
5424657 2482337 2482337 defendant Taverner John husbandman 634335 634335 Taverner, John, of Freeston, husbandman 3
5424658 2482337 2482337 defendant Denys John husbandman 586134 586134 Denys, John, of Ipswich, husbandman 4
5424659 2482337 2482337 defendant Tarle Edmund tailor 767615 767615 Tarle, Edmund, of Braham, tailor 5
5424660 2482337 2482337 defendant Brightwell Robert husbandman 590415 590415 Brightwell, Robert, of Mildenhale, husbandman 6
5424661 2482337 2482337 defendant Copynger Richard husbandman 590415 590415 Copynger, Richard, of Mildenhale, husbandman 7
5424662 2482337 2482337 defendant Fyssh William yeoman 586180 586180 Fyssh, William, of Bury St Edmunds, yeoman 8
5424663 2482337 2482337 defendant Longe William   586134 586134 Longe, William, of Ipswich, notary 9
5424664 2482337 2482337 defendant Furmage Henry yeoman 674509 674509 Furmage, Henry, of Stradbrook, yeoman 10
5424665 2482337 2482337 defendant Dunche Magery widow 589379 589379 Dunche, Magery, of Mendelesham, widow 11
5424666 2482337 2482337 defendant Kent John husbandman 590362 590362 Kent, John, of Eston, husbandman 12
5424667 2482337 2482337 defendant Praty John smith 587550 587550 Praty, John, of Eye, smith 13
5424668 2482337 2482337 defendant Dryver John yeoman 587464 587464 Dryver, John, of Bakton, yeoman 14
5424669 2482337 2482337 defendant Wale Henry husbandman 605349 605349 Wale, Henry, of Little Thornham, husbandman 15
5424670 2482337 2482337 defendant Hacon Thomas yeoman 593914 593914 Hacon, Thomas, of Hygham, yeoman 16
5424671 2482337 2482337 defendant Norfolk Thomas laborer 592979 592979 Norfolk, Thomas, of Tatyngston, laborer 17
5424672 2482337 2482337 defendant Podde Robert husbandman 592979 592979 Podde, Robert, of Tatyngston, husbandman 18
5424673 2482337 2482337 defendant Lunt Robert yeoman 757947 757947 Lunt, Robert, of Wodebregge, yeoman 19
5424674 2482337 2482337 defendant Joye John yeoman 585947 585947 Joye, John, of Hadley, yeoman 20
5424675 2482337 2482337 defendant Feltewell John chapman 586134 586134 Feltewell, John, of Ipswich, chapman 21
5424676 2482337 2482337 defendant Ive William yeoman 587061 587061 Ive, William, of Combes, yeoman 22
5424677 2482337 2482337 defendant Arnold William yeoman 846822 846822 Arnold, William, of Lalford, Essex, yeoman 23
5424678 2482337 2482337 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);