names

19 rows where place_id = 670698

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3998309 2024138 2024138 defendant Austen John yeoman 670698 670698 Austen, John, of Felthorpe, yeoman 2
4025998 2033946 2033946 defendant Grene Robert husbandman 670698 670698 Grene, Robert, of Felthorpe, husbandman 3
4048235 2041808 2041808 defendant Cooke William husbandman 670698 670698 Cooke, William, of Felthorpe, husbandman 0
4082236 2053959 2053959 defendant Flegge William clerk 670698 670698 Flegge, William, of Felthorpe, clerk 0
4088707 2056262 2056262 defendant Flegg Thomas clerk 670698 670698 Flegg, Thomas, of Felthorpe, clerk 0
4107581 2062996 2062996 defendant Gachyn William husbandman 670698 670698 Gachyn, William, of Felthorpe, husbandman 1
4107583 2062996 2062996 defendant Cooke Margaret widow 670698 670698 Cooke, Margaret, of Felthorpe, widow 3
4110647 2064065 2064065 defendant Cowper John yeoman 670698 670698 Cowper, John, of Felthorpe, yeoman 0
4110756 2064105 2064105 defendant Cowper John yeoman 670698 670698 Cowper, John, of Felthorpe, yeoman 0
4112377 2064685 2064685 defendant Love Robert husbandman 670698 670698 Love, Robert, of Felthorpe, husbandman 1
4137361 2073712 2073712 defendant Howarde Lawrence husbandman 670698 670698 Howarde, Lawrence, of Felthorpe, husbandman 2
4159166 2081273 2081273 defendant Cooke Anne widow 670698 670698 Cooke, Anne, of Felthorpe, widow 0
4182935 2089511 2089511 defendant Cooke Anne widow 670698 670698 Cooke, Anne, of Felthorpe, widow 2
4220445 2102653 2102653 defendant Mego William   670698 670698 Mego, William, of Felthorpe, carpenter Mego, Edmund, of Norwich, "calendrer" 0
4288092 2125789 2125789 defendant Benson Henry husbandman 670698 670698 Benson, Henry, of Felthorpe, husbandman 3
4341505 2144305 2144305 defendant Mego or Meegoe William carpenter 670698 670698 Mego or Meegoe, William, of Felthorpe, carpenter 1
4380436 2158113 2158113 defendant Reve Christopher gent 670698 670698 Reve, Christopher, of Felthorpe, gent 0
4410790 2168199 2168199 defendant Reve Christopher gent 670698 670698 Reve, Christopher, of Felthorpe, gent 0
5438726 2486513 2486513 defendant Randolf John (legal representative) 670698 670698 Randolf, John, of Felthorpe, executor of 3

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