names

23 rows where place_id = 611651

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3689419 1922848 1922848 defendant Stampe John yeoman 611651 611651 Stampe, John, of Boxgrave, yeoman 1
4575615 2223883 2223883 defendant Wyght Henry   611651 611651 Wyght, Henry, of Boxgrave 0
4591541 2228714 2228714 defendant Wyght Henry   611651 611651 Wyght, Henry, of Boxgrave 0
4697936 2264846 2264846 defendant Osberne Richard husbandman 611651 611651 Osberne, Richard, of Boxgrave, husbandman 0
4838399 2307924 2307924 defendant Frape John husbandman 611651 611651 Frape, John, of Boxgrave, husbandman 0
4874177 2318864 2318864 defendant Pylth John butcher 611651 611651 Pylth, John, of Boxgrave, butcher 0
4884119 2321942 2321942 defendant atte Water John husbandman 611651 611651 atte Water, John, of Boxgrave, husbandman 0
4884138 2321947 2321947 defendant Bocher William butcher 611651 611651 Bocher, William, of Boxgrave, butcher 0
4912847 2330512 2330512 defendant Osebarn Richard husbandman 611651 611651 Osebarn, Richard, of Boxgrave, husbandman 1
4918281 2332240 2332240 defendant Sawere John husbandman 611651 611651 Sawere, John, of Boxgrave, husbandman 0
4922808 2333547 2333547 defendant Sewyn Thomas husbandman 611651 611651 Sewyn, Thomas, of Boxgrave, husbandman 0
4926646 2334752 2334752 defendant Sawyer John husbandman 611651 611651 Sawyer, John, of Boxgrave, husbandman 0
4928952 2335480 2335480 defendant Sewyn Thomas husbandman 611651 611651 Sewyn, Thomas, of Boxgrave, husbandman 0
4987983 2353375 2353375 defendant Russell Richard yeoman 611651 611651 Russell, Richard, of Boxgrave, yeoman 0
4988370 2353491 2353491 defendant Clyff Ivan husbandman 611651 611651 Clyff, Ivan, of Boxgrave, husbandman 0
4991176 2354249 2354249 defendant (not given) Robert prior of Chamberleyn 611651 611651 Chamberleyn, Robert, of Boxgrave, prior of the house & church of the BM 0
5005584 2358532 2358532 defendant Roper Thomas husbandman 611651 611651 Roper, Thomas, of Boxgrave, husbandman 0
5045631 2370326 2370326 defendant Kene Thomas fuller 611651 611651 Kene, Thomas, of Boxgrave, fuller 0
5092637 2384224 2384224 defendant Barfot or Barsot John butcher 611651 611651 Barfot or Barsot, John, of Boxgrave, butcher 4
5304855 2446457 2446457 plaintiff (not given) John prior of Joye 611651 611651 Joye, John, of Boxgrave, prior of the house or priory 0
5304858 2446458 2446458 plaintiff (not given) John prior of Joye 611651 611651 Joye, John, of Boxgrave, prior of the house, in 0
5377472 2468538 2468538 defendant Rake Henry gent 611651 611651 Rake, Henry, of Boxgrave, gent 0
5570231 2525860 2525860 defendant Blakeman Thomas husbandman 611651 611651 Blakeman, Thomas, of Boxgrave, husbandman 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);