names

17 rows where case_id = 2455231

✎ 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
5333953 2455231 2455231 plaintiff Durraunt Thomas     Durraunt, Thomas 0
5333954 2455231 2455231 defendant Maryot William husbandman 768206 768206 Maryot, William, of Brymyngton, husbandman 0
5333955 2455231 2455231 defendant Higdon Nicholas husbandman 768206 768206 Higdon, Nicholas, of Brymyngton, husbandman 1
5333956 2455231 2455231 defendant Stubbyng William weaver 768206 768206 Stubbyng, William, of Brymyngton, weaver 2
5333957 2455231 2455231 defendant Clerke Edmund husbandman 768206 768206 Clerke, Edmund, of Brymyngton, husbandman 3
5333958 2455231 2455231 defendant Wylkynson Thomas husbandman 768206 768206 Wylkynson, Thomas, of Brymyngton, husbandman 4
5333959 2455231 2455231 defendant Darton George husbandman 768206 768206 Darton, George, of Brymyngton, husbandman 5
5333960 2455231 2455231 defendant Wylkynson John husbandman 768206 768206 Wylkynson, John, of Brymyngton, husbandman 6
5333961 2455231 2455231 defendant Jonson John husbandman 768206 768206 Jonson, John, of Brymyngton, husbandman 7
5333962 2455231 2455231 defendant Clyf Reginald tailor 768206 768206 Clyf, Reginald, of Brymyngton, tailor 8
5333963 2455231 2455231 defendant Marler John   768206 768206 Marler, John, of Brymyngton, scythe smith 9
5333964 2455231 2455231 defendant Dent John husbandman 768206 768206 Dent, John, of Brymyngton, husbandman 10
5333965 2455231 2455231 defendant Baguley Charles husbandman 832217 832217 Baguley, Charles, of Calall, husbandman 11
5333966 2455231 2455231 defendant Baguley Robert weaver 587631 587631 Baguley, Robert, of Chesterfeld, weaver 12
5333967 2455231 2455231 defendant Eyre Robert husbandman 591756 591756 Eyre, Robert, of Dunston, husbandman 13
5333968 2455231 2455231 defendant Fryth Richard husbandman 587631 587631 Fryth, Richard, of Chesterfeld, husbandman 14
5333969 2455231 2455231 defendant Brampton John husbandman 594735 594735 Brampton, John, of Wyngerworth, husbandman 15

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