names

24 rows where place_id = 604377

✎ 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
3657828 1912699 1912699 defendant Derwent Edmund yeoman 604377 604377 Derwent, Edmund, of Grove, Notts, yeoman 0
3933638 2001538 2001538 defendant Stanley John   604377 604377 Stanley, John, of Grove, Notts 0
3982426 2018487 2018487 defendant Godeley Nicholas husbandman 604377 604377 Godeley, Nicholas, of Grove, Notts, husbandman 0
3990972 2021533 2021533 defendant Nevill Francis gent 604377 604377 Nevill, Francis, of Grove, Notts, gent 0
4002499 2025661 2025661 plaintiff Hercye John (legal representative) 604377 604377 Hercye, John, of Grove, Notts, knight, executors of 0
4035093 2037232 2037232 plaintiff Hercye John (legal representative) 604377 604377 Hercye, John, of Grove, Notts, knight, executors of 0
4143281 2075817 2075817 defendant Bunfane Arthur yeoman 604377 604377 Bunfane, Arthur, of Grove, Notts, yeoman 0
4157559 2080719 2080719 defendant Nevill Barbara widow 604377 604377 Nevill, Barbara, of Grove, Notts, widow 0
4274178 2120913 2120913 defendant Nevill Herseus esq 604377 604377 Nevill, Herseus, of Grove, Notts, esq 0
4290786 2126762 2126762 defendant Nevell Herseus esq 604377 604377 Nevell, Herseus, of Grove, Notts, esq 0
4296604 2128886 2128886 defendant Nevell Herseus esq 604377 604377 Nevell, Herseus, of Grove, Notts, esq 0
4296607 2128887 2128887 defendant Nevell Herseus esq 604377 604377 Nevell, Herseus, of Grove, Notts, esq 0
4296610 2128888 2128888 defendant Nevell Herseus esq 604377 604377 Nevell, Herseus, of Grove, Notts, esq 0
4298593 2129603 2129603 defendant Nevyll Herseus esq 604377 604377 (Nevyll, Herseus, of Grove, Notts, esq 2
4305085 2131920 2131920 defendant Nevell Herseus   604377 604377 Nevell, Herseus, of Grove, Notts 0
4329218 2140085 2140085 defendant Nevell Herseus esq 604377 604377 Nevell, Herseus, of Grove, Notts, esq 0
4329221 2140086 2140086 defendant Nevell Herseus esq 604377 604377 Nevell, Herseus, of Grove, Notts, esq 0
4329227 2140088 2140088 defendant Nevell Herseus esq 604377 604377 Nevell, Herseus, of Grove, Notts, esq 0
4337098 2142699 2142699 defendant Nevell Herceus esq 604377 604377 Nevell, Herceus, of Grove, Notts, esq 0
4343215 2144900 2144900 defendant Nevell Harseus gent 604377 604377 Nevell, Harseus, of Grove, Notts, gent 0
4372982 2155407 2155407 defendant Nevill Herceus esq 604377 604377 Nevill, Herceus, of Grove, Notts, esq 0
4379290 2157672 2157672 defendant Nevell Richard gent 604377 604377 Nevell, Richard, of Grove, Notts, gent 0
5143900 2399356 2399356 defendant Cressy Hugh esq 604377 604377 Cressy, Hugh, of Grove, Notts, esq 0
5143902 2399357 2399357 defendant Cressy Hugh esq 604377 604377 Cressy, Hugh, of Grove, Notts, esq 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);