names

19 rows where case_id = 1914065

✎ 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
3662057 1914065 1914065 plaintiff Markaunt William     Markaunt, William 0
3662058 1914065 1914065 defendant Heyward Stephen   586180 586180 Heyward, Stephen, of Bury St Edmunds, cloth maker 0
3662059 1914065 1914065 defendant Gardyner Thomas husbandman 586180 586180 Gardyner, Thomas, of Bury St Edmunds, husbandman 1
3662060 1914065 1914065 defendant Bayn Alexander smith 586180 586180 Bayn, Alexander, of Bury St Edmunds, smith 2
3662061 1914065 1914065 defendant Wryght Richard   586180 586180 Wryght, Richard, of Bury St Edmunds, glass wright 3
3662062 1914065 1914065 defendant Whytemouthe John husbandman 586180 586180 Whytemouthe, John, of Bury St Edmunds, husbandman 4
3662063 1914065 1914065 defendant Chamburleyn Robert clerk 586134 586134 Chamburleyn, Robert, of Ipswich, clerk 5
3662064 1914065 1914065 defendant Skalder John grocer 586953 586953 Skalder, John, of Sudbury, grocer 6
3662065 1914065 1914065 defendant Dykman Robert yeoman 599239 599239 Dykman, Robert, of Wrottyng, yeoman 7
3662066 1914065 1914065 defendant Horne Ralph carpenter 590243 590243 Horne, Ralph, of Newmarket, shoe maker, smyth, John, of Kersey, carpenter 8
3662067 1914065 1914065 defendant Crome Henry tanner 605553 605553 Crome, Henry, of Hessatt, tanner 9
3662068 1914065 1914065 defendant Syday Walter barber 586953 586953 Syday, Walter, of Sudbury, barber 10
3662069 1914065 1914065 defendant Hardy Thomas husbandman 590513 590513 Hardy, Thomas, of Honyngton, husbandman 11
3662070 1914065 1914065 defendant Smyth Joan widow 605554 605554 Smyth, Joan, of Little Ashfield, widow 12
3662071 1914065 1914065 defendant Wykes William yeoman 602387 602387 Wykes, William, of Bodesdale, yeoman 13
3662072 1914065 1914065 defendant Rose William tanner 587464 587464 Rose, William, of Bakton, tanner 14
3662073 1914065 1914065 defendant Mannyng Richard husbandman 605555 605555 Mannyng, Richard, of Tweyte, husbandman 15
3662074 1914065 1914065 defendant Shethe Thomas husbandman 598435 598435 Shethe, Thomas, of Hengrave, husbandman 16
3662075 1914065 1914065 defendant Dossettour John husbandman 604382 604382 Dossettour, John, of Great Berton, husbandman 17

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