names

19 rows where place_id = 610922

✎ 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
3685874 1921741 1921741 defendant Maynard Richard innholder 610922 610922 Maynard, Richard, of Hyndon, Wilts, innholder 1
3883645 1984798 1984798 defendant Tabar alias Smyth Thomas fishmonger 610922 610922 Tabar alias Smyth, Thomas, of Hyndon, Wilts, fishmonger 0
3949501 2006896 2006896 defendant Browne Clement gent 610922 610922 Browne, Clement, of Hyndon, Wilts, gent 0
4323540 2138292 2138292 defendant Banester Roger innholder 610922 610922 Banester, Roger, of Hyndon, Wilts, innholder 0
4741829 2278104 2278104 defendant Persons John gent 610922 610922 Persons, John, of Hyndon, Wilts, gent 0
4875021 2319136 2319136 defendant Stantor or Stautor William gent 610922 610922 Stantor or Stautor, William, of Hyndon, Wilts, gent 1
4952334 2342658 2342658 defendant Stantor William gent 610922 610922 Stantor, William, of Hyndon, Wilts, gent 3
4978120 2350421 2350421 defendant Stanley Henry gent 610922 610922 Stanley, Henry, of Hyndon, Wilts, gent 1
5005372 2358473 2358473 defendant Stanter William gent 610922 610922 Stanter, William, of Hyndon, Wilts, gent 0
5043819 2369777 2369777 defendant Hurdell Robert gent 610922 610922 Hurdell, Robert, of Hyndon, Wilts, gent 2
5086547 2382456 2382456 defendant Holbem William cordwainer 610922 610922 Holbem, William, of Hyndon, Wilts, cordwainer 0
5102641 2387182 2387182 defendant Holbeme John yeoman 610922 610922 Holbeme, John, of Hyndon, Wilts, yeoman 1
5132093 2395878 2395878 defendant Gargrave James esq 610922 610922 Gargrave, James, of Hyndon, Wilts, esq 0
5132095 2395879 2395879 defendant Gragrave James esq 610922 610922 Gragrave, James, of Hyndon, Wilts, esq 0
5151680 2401649 2401649 defendant Gargrave James esq 610922 610922 Gargrave, James, of Hyndon, Wilts, esq 0
5168484 2406497 2406497 defendant Oborne Robert yeoman 610922 610922 Oborne, Robert, of Hyndon, Wilts, yeoman 0
5168486 2406498 2406498 defendant Oborne Robert yeoman 610922 610922 Oborne, Robert, of Hyndon, Wilts, yeoman 0
5184467 2411197 2411197 defendant Eborne Robert yeoman 610922 610922 Eborne, Robert, of Hyndon, Wilts, yeoman 0
5184469 2411198 2411198 defendant Oborn Robert yeoman 610922 610922 Oborn, Robert, of Hyndon, Wilts, yeoman 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);