names

20 rows where case_id = 1914066

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, place_id, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3662076 1914066 1914066 plaintiff Markaunt William     Markaunt, William 0
3662077 1914066 1914066 defendant Shethe Thomas pewterer 598435 598435 Shethe, Thomas, of Hengrave, pewterer 0
3662078 1914066 1914066 defendant Dossettur John husbandman 604382 604382 Dossettur, John, of Great Berton, husbandman 1
3662079 1914066 1914066 defendant Newhawe John husbandman 605511 605511 Newhawe, John, of Little Saxham, husbandman 2
3662080 1914066 1914066 defendant Cr�nds   smith   Cr�nds, smith 3
3662081 1914066 1914066 defendant Wryght Richard   586180 586180 Wryght, Richard, of Bury St Edmunds, glass wright 4
3662082 1914066 1914066 defendant Whytemouthe John husbandman 586180 586180 Whytemouthe, John, of Bury St Edmunds, husbandman 5
3662083 1914066 1914066 defendant Chamburleyn Robert clerk 586134 586134 Chamburleyn, Robert, of Ipswich, clerk 6
3662084 1914066 1914066 defendant Skalder John grocer 586953 586953 Skalder, John, of Sudbury, grocer 7
3662085 1914066 1914066 defendant Dykman Robert yeoman 599239 599239 Dykman, Robert, of Wrottyng, yeoman 8
3662086 1914066 1914066 defendant Horne Ralph carpenter 590243 590243 Horne, Ralph, of Newmarket, shoe maker, smyth, John, of Kersey, carpenter 9
3662087 1914066 1914066 defendant Crome Henry tanner 605553 605553 Crome, Henry, of Hessatt, tanner 10
3662088 1914066 1914066 defendant Syday Walter barber 586953 586953 Syday, Walter, of Sudbury, barber 11
3662089 1914066 1914066 defendant Hardy Thomas husbandman 590513 590513 Hardy, Thomas, of Honyngton, husbandman 12
3662090 1914066 1914066 defendant Smyth Joan widow 605554 605554 Smyth, Joan, of Little Ashfield, widow 13
3662091 1914066 1914066 defendant Wykes William yeoman 602387 602387 Wykes, William, of Bodesdale, yeoman 14
3662092 1914066 1914066 defendant Rose William tanner 587464 587464 Rose, William, of Bakton, tanner 15
3662093 1914066 1914066 defendant Mannyng Richard husbandman 605555 605555 Mannyng, Richard, of Tweyte, husbandman 16
3662094 1914066 1914066 defendant Shethe Thomas husbandman 598435 598435 Shethe, Thomas, of Hengrave, husbandman 17
3662095 1914066 1914066 defendant Dossettour John husbandman 604382 604382 Dossettour, John, of Great Berton, husbandman 18

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