names

54 rows where place_id = 833939

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
4313943 2134982 2134982 defendant Carewe Edmund   833939 833939 Carewe, Edmund, of Grafton, Nhants, knight 1
4725970 2273408 2273408 defendant Keche John   833939 833939 Keche, John, of Grafton, Nhants, parson 1
4989561 2353811 2353811 defendant Wydevyll Richard   833939 833939 Wydevyll, Richard, of Grafton, Nhants, knight 0
4989570 2353814 2353814 defendant Wydevyll Richard   833939 833939 Wydevyll, Richard, of Grafton, Nhants, knight 0
5006100 2358673 2358673 defendant Sandbache John yeoman 833939 833939 Sandbache, John, of Grafton, Nhants, yeoman 0
5024737 2364156 2364156 defendant Bartram William esq 833939 833939 Bartram, William, of Grafton, Nhants, esq 0
5044677 2370040 2370040 defendant Wodevyle Richard   833939 833939 Wodevyle, Richard, of Grafton, Nhants, knight 0
5046439 2370576 2370576 defendant Wydevyll Richard   833939 833939 Wydevyll, Richard, of Grafton, Nhants, knight 0
5047387 2370837 2370837 defendant Bondon William esq 833939 833939 Bondon, William, of Grafton, Nhants, esq 0
5047389 2370838 2370838 defendant Bondon William esq 833939 833939 Bondon, William, of Grafton, Nhants, esq 0
5048353 2371140 2371140 defendant Castell Geoffrey clerk 833939 833939 Castell, Geoffrey, of Grafton, Nhants, clerk 3
5048726 2371254 2371254 defendant Castell Geoffrey clerk 833939 833939 Castell, Geoffrey, of Grafton, Nhants, clerk 3
5089935 2383438 2383438 defendant Hanley or Hauley John husbandman 833939 833939 Hanley or Hauley, John, of Grafton, Nhants, husbandman 0
5104077 2387615 2387615 defendant Wydeville Richard   833939 833939 Wydeville, Richard, of Grafton, Nhants, knight 0
5105933 2388175 2388175 defendant Bertram William gent 833939 833939 Bertram, William, of Grafton, Nhants, gent 0
5121111 2392605 2392605 defendant Bartram William esq 833939 833939 Bartram, William, of Grafton, Nhants, esq 0
5121122 2392606 2392606 defendant Percevale John yeoman 833939 833939 Percevale, John, of Grafton, Nhants, yeoman 2
5121131 2392607 2392607 defendant Pertenale John yeoman 833939 833939 Pertenale, John, of Grafton, Nhants, yeoman 2
5121754 2392791 2392791 defendant Bowdon William esq 833939 833939 Bowdon, William, of Grafton, Nhants, esq 1
5142997 2399076 2399076 defendant Wodevyle Richard   833939 833939 Wodevyle, Richard, of Grafton, Nhants, knight 0
5143015 2399082 2399082 defendant Wodevyle Richard   833939 833939 Wodevyle, Richard, of Grafton, Nhants, knight 0
5143017 2399083 2399083 defendant Wodevyle Richard   833939 833939 Wodevyle, Richard, of Grafton, Nhants, knight 0
5164416 2405325 2405325 defendant Wodevyle Richard   833939 833939 Wodevyle, Richard, of Grafton, Nhants, knight 0
5164418 2405326 2405326 defendant Wydeville Richard   833939 833939 Wydeville, Richard, of Grafton, Nhants, knight 0
5164420 2405327 2405327 defendant Wydevylle Richard   833939 833939 Wydevylle, Richard, of Grafton, Nhants, knight 0
5164422 2405328 2405328 defendant Wodevile Richard   833939 833939 Wodevile, Richard, of Grafton, Nhants, knight 0
5176781 2408896 2408896 defendant Magott Thomas yeoman 833939 833939 Magott, Thomas, of Grafton, Nhants, yeoman 2
5176786 2408897 2408897 defendant Magott Thomas yeoman 833939 833939 Magott, Thomas, of Grafton, Nhants, yeoman 2
5177637 2409154 2409154 defendant Wydevylle Richard   833939 833939 Wydevylle, Richard, of Grafton, Nhants, knight 0
5177639 2409155 2409155 defendant Wodevyle Richard   833939 833939 Wodevyle, Richard, of Grafton, Nhants, knight 0
5177641 2409156 2409156 defendant Wodevyle Richard   833939 833939 Wodevyle, Richard, of Grafton, Nhants, knight 0
5191577 2413278 2413278 defendant Wydevill Richard   833939 833939 Wydevill, Richard, of Grafton, Nhants, knight 0
5198769 2415392 2415392 defendant Bertram William esq 833939 833939 Bertram, William, of Grafton, Nhants, esq 1
5199151 2415506 2415506 defendant Sywell John yeoman 833939 833939 Sywell, John, of Grafton, Nhants, yeoman 4
5199157 2415507 2415507 defendant Sywell John yeoman 833939 833939 Sywell, John, of Grafton, Nhants, yeoman 4
5199163 2415508 2415508 defendant Sywell John   833939 833939 Sywell, John, of Grafton, Nhants 4
5199167 2415509 2415509 defendant Magot Thomas yeoman 833939 833939 Magot, Thomas, of Grafton, Nhants, yeoman 2
5199172 2415510 2415510 defendant Magott Thomas yeoman 833939 833939 Magott, Thomas, of Grafton, Nhants, yeoman 2
5210990 2418948 2418948 defendant Sywell John yeoman 833939 833939 Sywell, John, of Grafton, Nhants, yeoman 2
5218701 2421197 2421197 defendant Wydwill Richard   833939 833939 Wydwill, Richard, of Grafton, Nhants, knight, Lord Ryvers 0
5230867 2424635 2424635 defendant Bertram William esq 833939 833939 Bertram, William, of Grafton, Nhants, esq 0
5280359 2439333 2439333 defendant Delahay Nicholas gent 833939 833939 Delahay, Nicholas, of Grafton, Nhants, gent 0
5280381 2439338 2439338 defendant de la Hay Nicholas gent 833939 833939 de la Hay, Nicholas, of Grafton, Nhants, gent 1
5294453 2443357 2443357 defendant Cressy William esq 833939 833939 Cressy, William, of Grafton, Nhants, esq 3
5294461 2443359 2443359 defendant Cressy William esq 833939 833939 Cressy, William, of Grafton, Nhants, esq 1
5299896 2444935 2444935 defendant Lahay Nicholas de gent 833939 833939 Lahay, Nicholas de, of Grafton, Nhants, gent 0
5360479 2463306 2463306 defendant Hyton Henry yeoman 833939 833939 Hyton, Henry, of Grafton, Nhants, yeoman 3
5399011 2474790 2474790 defendant Saunders William husbandman 833939 833939 Saunders, William, of Grafton, Nhants, husbandman 1
5426736 2482941 2482941 defendant Saunders William husbandman 833939 833939 Saunders, William, of Grafton, Nhants, husbandman 1
5457458 2492130 2492130 defendant George Henry husbandman 833939 833939 George, Henry, of Grafton, Nhants, husbandman 0
5477327 2498229 2498229 defendant Saunders William husbandman 833939 833939 Saunders, William, of Grafton, Nhants, husbandman 3
5499741 2504864 2504864 defendant Wryxworth John tiler 833939 833939 Wryxworth, John, of Grafton, Nhants, tiler 4
5512380 2508734 2508734 plaintiff Marchall William gent 833939 833939 Marchall, William, of Grafton, Nhants, gent 0
5520781 2511321 2511321 defendant Barlowe James yeoman 833939 833939 Barlowe, James, of Grafton, Nhants, 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);