names

13 rows where case_id = 2278047

✎ 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
4741639 2278047 2278047 plaintiff Bowet Anne formerly wife of William Bowet, knight   Bowet, Anne, formerly wife of William Bowet, knight, on her own account 0
4741640 2278047 2278047 defendant Bernard John husbandman 780087 780087 Bernard, John, of Morle Swanton, husbandman 0
4741641 2278047 2278047 defendant Wode Richard husbandman 644180 644180 Wode, Richard, of Costesey, husbandman 1
4741642 2278047 2278047 defendant Wode Martin husbandman 644180 644180 Wode, Martin, of Costesey, husbandman 2
4741643 2278047 2278047 defendant Gunton Roger husbandman 644180 644180 Gunton, Roger, of Costesey, husbandman 3
4741644 2278047 2278047 defendant Blakemanhagh John husbandman 644180 644180 Blakemanhagh, John, of Costesey, husbandman 4
4741645 2278047 2278047 defendant Coche John husbandman 644180 644180 Coche, John, of Costesey, husbandman 5
4741646 2278047 2278047 defendant Newegate Clement husbandman 644180 644180 Newegate, Clement, of Costesey, husbandman 6
4741647 2278047 2278047 defendant Pomme John husbandman 644180 644180 Pomme, John, of Costesey, husbandman 7
4741648 2278047 2278047 defendant Davy Robert husbandman 590362 590362 Davy, Robert, of Eston, husbandman 8
4741649 2278047 2278047 defendant Randolf John husbandman 588406 588406 Randolf, John, of Colton, husbandman 9
4741650 2278047 2278047 defendant Randlolf Thomas husgandman 588406 588406 Randlolf, Thomas, of Colton, husgandman 10
4741651 2278047 2278047 defendant Shepeherd John husbandman 588406 588406 Shepeherd, John, of Colton, husbandman 11

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