names

14 rows where place_id = 681183

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4043751 2040218 2040218 defendant Statham Henry chapman 681183 681183 Statham, Henry, of Hichyn, Herts, chapman 1
4525181 2208215 2208215 defendant Barbour Thomas   681183 681183 Barbour, Thomas, of Hichyn, Herts 1
4691092 2262735 2262735 defendant Bosvyll William   681183 681183 Bosvyll, William, of Hichyn, Herts, wright 0
4985074 2352464 2352464 defendant Catworth Thomas husbandman 681183 681183 Catworth, Thomas, of Hichyn, Herts, husbandman 1
5164000 2405211 2405211 defendant Spegon John yeoman 681183 681183 Spegon, John, of Hichyn, Herts, yeoman 0
5238061 2426723 2426723 defendant Peltot Stephen tailor 681183 681183 Peltot, Stephen, of Hichyn, Herts, tailor 0
5271354 2436715 2436715 defendant Ingold John butcher 681183 681183 Ingold, John, of Hichyn, Herts, butcher 1
5295075 2443547 2443547 defendant Walgrave William husbandman 681183 681183 Walgrave, William, of Hichyn, Herts, husbandman 2
5326869 2453110 2453110 defendant Catworth John chapman 681183 681183 Catworth, John, of Hichyn, Herts, chapman 3
5383759 2470436 2470436 defendant Leccheworth William yeoman 681183 681183 Leccheworth, William, of Hichyn, Herts, yeoman 4
5395592 2473819 2473819 defendant Gent Edmund yeoman 681183 681183 Gent, Edmund, of Hichyn, Herts, yeoman 0
5446283 2488782 2488782 defendant Bakr_ Nicholas fuller 681183 681183 Bakr_, Nicholas, of Hichyn, Herts, fuller 1
5447050 2489007 2489007 defendant (illegible) John smith 681183 681183 _, John, of Hichyn, Herts, smith 0
5514249 2509304 2509304 defendant Webbe Roger chapman 681183 681183 Webbe, Roger, of Hichyn, Herts, chapman 0

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