names

20 rows where place_id = 665078

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3975431 2015971 2015971 defendant Hackeluett Thomas esq 665078 665078 Hackeluett, Thomas, of Eton, Herefs, esq 0
4003920 2026170 2026170 defendant Hackeluytt or Hacklett Thomas esq 665078 665078 Hackeluytt or Hacklett, Thomas, of Eton juxta Leominster, Herefs, esq 0
4036335 2037679 2037679 defendant Hackyluytt or Hackelett Thomas esq 665078 665078 Hackyluytt or Hackelett, Thomas, of Eton juxta Leominster, Herefs, esq 0
4082282 2053976 2053976 defendant Hiett Thomas gent 665078 665078 Hiett, Thomas, of Eton, Herefs, gent 0
4233121 2107092 2107092 defendant Crofte Richard esq 665078 665078 Crofte, Richard, of Eton, Herefs, esq 0
4241731 2110220 2110220 defendant Crofte Richard esq 665078 665078 Crofte, Richard, of Eton, Herefs, esq 0
4668678 2255918 2255918 defendant Oldecastell Richard esq 665078 665078 Oldecastell, Richard, of Eton, Herefs, esq 0
4668748 2255938 2255938 defendant Walshe Richard   665078 665078 Walshe, Richard, of Eton, Herefs, cahplain 3
4694787 2263863 2263863 defendant Oldcastell Richard esq 665078 665078 Oldcastell, Richard, of Eton, Herefs, esq 1
4858605 2314065 2314065 defendant Heyclete Walter gent 665078 665078 Heyclete, Walter, of Eton, Herefs, gent 2
4865791 2316269 2316269 defendant Heyclete Walter gent 665078 665078 Heyclete, Walter, of Eton, Herefs, gent 1
4886569 2322664 2322664 defendant Lunteley William esq 665078 665078 Lunteley, William, of Eton, Herefs, esq 0
5129134 2395008 2395008 defendant app Henry Richard esq 665078 665078 app Henry, Richard, of Eton, Herefs, esq 1
5129137 2395009 2395009 defendant app Herny Richard esq 665078 665078 app Herny, Richard, of Eton, Herefs, esq 1
5129140 2395010 2395010 defendant app Herny Richard esq 665078 665078 app Herny, Richard, of Eton, Herefs, esq 1
5148334 2400650 2400650 defendant app Harry Richard esq 665078 665078 app Harry, Richard, of Eton, Herefs, esq 1
5148337 2400651 2400651 defendant app Harry Richard esq 665078 665078 app Harry, Richard, of Eton, Herefs, esq 1
5148340 2400652 2400652 defendant app Harry Richard esq 665078 665078 app Harry, Richard, of Eton, Herefs, esq 1
5148343 2400653 2400653 defendant App Harry Richard esq 665078 665078 App Harry, Richard, of Eton, Herefs, esq 1
5183241 2410839 2410839 defendant app Harry Richard esq 665078 665078 app Harry, Richard, of Eton, Herefs, 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);