names

16 rows where case_id = 2506879

✎ 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
5506262 2506879 2506879 plaintiff Bysshop John gent   Bysshop, John, gent 0
5506263 2506879 2506879 defendant Blome John husbandman 586819 586819 Blome, John, of Worsted, husbandman 0
5506264 2506879 2506879 defendant Shode Geoffrey husbandman 586386 586386 Shode, Geoffrey, of Weston, husbandman 1
5506265 2506879 2506879 defendant Grogon Walter husbandman 703866 703866 Grogon, Walter, of Burnham St Andrew, husbandman 2
5506266 2506879 2506879 defendant Hardfyssh John clerk 590879 590879 Hardfyssh, John, of Skulthorp, clerk 3
5506267 2506879 2506879 defendant Warde John yeoman 586527 586527 Warde, John, of Bedyngham, yeoman 4
5506268 2506879 2506879 defendant Warner Richard yeoman 587166 587166 Warner, Richard, of Salle, yeoman 5
5506269 2506879 2506879 defendant Clerk Peter husbandman 607836 607836 Clerk, Peter, of Sloley, husbandman 6
5506270 2506879 2506879 defendant Kegyll William husbandman 591757 591757 Kegyll, William, of Lakenham, husbandman 7
5506271 2506879 2506879 defendant Tolle Edmund husbandman 591757 591757 Tolle, Edmund, of Lakenham, husbandman 8
5506272 2506879 2506879 defendant Rosse Henry husbandman 826217 826217 Rosse, Henry, of Wytton juxta Bromholm, husbandman 9
5506273 2506879 2506879 defendant Wellys John   587182 587182 Wellys, John, of Blakeney, freemason 10
5506274 2506879 2506879 defendant Fox Robert husbandman 753077 753077 Fox, Robert, of Brynyngham, husbandman 11
5506275 2506879 2506879 defendant Hyldwell Geoffrey husbandman 593308 593308 Hyldwell, Geoffrey, of Redeham, husbandman 12
5506276 2506879 2506879 defendant Calthorp Oliver gent 587387 587387 Calthorp, Oliver, of Boton, gent 13
5506277 2506879 2506879 defendant Hunt Geoffrey gent 590965 590965 Hunt, Geoffrey, of Hyndolneston, gent 14

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