names

18 rows where case_id = 1952880

✎ 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
3784298 1952880 1952880 plaintiff Markaunt William     Markaunt, William 0
3784299 1952880 1952880 defendant Alyzaunderson Robert clerk 604792 604792 Alyzaunderson, Robert, of Chyppenham, clerk 0
3784300 1952880 1952880 defendant Bosy John clerk 601447 601447 Bosy, John, of Tostok, clerk 1
3784301 1952880 1952880 defendant Odyham John clerk 608584 608584 Odyham, John, of Barnyngham, clerk 2
3784302 1952880 1952880 defendant Downyng Robert draper 585937 585937 Downyng, Robert, of Bylston, draper 3
3784303 1952880 1952880 defendant Cowper Lawrence innkeeper 585937 585937 Cowper, Lawrence, of Bylston, innkeeper 4
3784304 1952880 1952880 defendant Wyth John tiler 585937 585937 Wyth, John, of Bylston, tiler 5
3784305 1952880 1952880 defendant Wythe Thomas saddler 585947 585947 Wythe, Thomas, of Hadley, saddler 6
3784306 1952880 1952880 defendant Pullen Richard sherman 585947 585947 Pullen, Richard, of Hadley, sherman 7
3784307 1952880 1952880 defendant Celer John husbandman 585947 585947 Celer, John, of hadley, husbandman 8
3784308 1952880 1952880 defendant Alyn Richard husbandman 585947 585947 Alyn, Richard, of Hadley, husbandman 9
3784309 1952880 1952880 defendant Clarves Richard husbandman 595622 595622 Clarves, Richard, of Acton, husbandman 10
3784310 1952880 1952880 defendant Bevarston Ralph carpenter 598084 598084 Bevarston, Ralph, of Magna Cornerd, carpenter 11
3784311 1952880 1952880 defendant Syday Walter barber 586953 586953 Syday, Walter, of Sudbury, barber 12
3784312 1952880 1952880 defendant Awsten John clothmaker 586912 586912 Awsten, John, of Melford, clothmaker 13
3784313 1952880 1952880 defendant Smyth John tailor 586912 586912 Smyth, John, of Melford, tailor 14
3784314 1952880 1952880 defendant Cawyer Robert clothmaker 586912 586912 Cawyer, Robert, of Melford, clothmaker 15
3784315 1952880 1952880 defendant Joly William husbandman 587882 587882 Joly, William, of Lavenham, husbandman 16

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