names

25 rows where place_id = 611044

✎ 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
3686507 1921931 1921931 defendant Chevall Edmund gent 611044 611044 Chevall, Edmund, of Herts, gent 0
3852138 1974266 1974266 plaintiff Pykeryng Thomas gent 611044 611044 Pykeryng, Thomas, of Herts, gent 0
3959530 2010426 2010426 defendant Butler Philip gent 611044 611044 Butler, Philip, of Herts, gent 1
4197615 2094721 2094721 defendant Bache Thomas yeoman 611044 611044 Bache, Thomas, of Herts, or of Matherne, Worcs, yeoman 0
4347483 2146368 2146368 defendant Gylman Richard gent 611044 611044 Gylman, Richard, of Herts, gent 3
4475936 2193146 2193146 defendant Chertesey John de   611044 611044 Chertesey, John de, of Herts 0
4491244 2197951 2197951 defendant Fauconer Edmund   611044 611044 Fauconer, Edmund, of Herts 2
4500492 2200775 2200775 defendant Chinab-- William   611044 611044 Chinab--, William, of Herts 0
4563775 2220239 2220239 defendant Perers Richard esq 611044 611044 Perers, Richard, of Herts, esq 0
4657269 2248163 2248163 plaintiff Clerk Thomas   611044 611044 Clerk, Thomas, of Herts 0
4657271 2248164 2248164 plaintiff Clerk Thomas   611044 611044 Clerk, Thomas, of Herts 0
4658947 2248669 2248669 defendant Sharpeshawe William   611044 611044 Sharpeshawe, William, of Herts, cook 1
4781701 2290288 2290288 plaintiff Kirkeby John   611044 611044 Kirkeby, John, of Herts 3
4781706 2290289 2290289 plaintiff Kyrkeby John   611044 611044 Kyrkeby, John, of Herts 3
4781711 2290290 2290290 plaintiff Kirkeby John   611044 611044 Kirkeby, John, of Herts 3
4859856 2314453 2314453 defendant Brugge John esq 611044 611044 Brugge, John, of Herts, esq 0
5098540 2386004 2386004 defendant Morley Nicholas esq 611044 611044 together with Morley, Nicholas, of Herts, esq 1
5110605 2389501 2389501 defendant Latymer Robert yeoman 611044 611044 Latymer, Robert, of Herts, yeoman 0
5219480 2421422 2421422 plaintiff Hendeley Nicholas yeoman 611044 611044 Hendeley, Nicholas, of Herts, yeoman 0
5219483 2421423 2421423 plaintiff Hendeley Nicholas yeoman 611044 611044 Hendeley, Nicholas, of Herts, yeoman 0
5232039 2424941 2424941 defendant Smyth John husbandman 611044 611044 Smyth, John, of Herts, husbandman 3
5288278 2441592 2441592 plaintiff Leventhorp Thomas gent 611044 611044 Leventhorp, Thomas, of Herts, gent 0
5304381 2446309 2446309 defendant G_ William   611044 611044 G_, William, of Herts, inn holder 0
5330386 2454166 2454166 defendant Bernham John   611044 611044 Bernham, John, of parson of Brandefeld juxta Ware, Herts 0
5633171 2554376 2554376 defendant Ballard John ploughman 611044 611044 Ballard, John, of Herts, ploughman 1

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