names

36 rows where place_id = 598846

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3634294 1905522 1905522 defendant Wode William laborer 598846 598846 Wode, William, of Harwode, laborer 2
3634295 1905522 1905522 defendant Waite John laborer 598846 598846 Waite, John, of Harwode, laborer 3
3786927 1953715 1953715 defendant Qwarton William yeoman 598846 598846 Qwarton, William, of Harwode, yeoman 0
3786929 1953715 1953715 defendant Smyth William husbandman 598846 598846 Smyth, William, of Harwode, husbandman 2
3786936 1953718 1953718 defendant Qwarton William yeoman 598846 598846 Qwarton, William, of Harwode, yeoman 0
3786938 1953718 1953718 defendant Smyth William husbandman 598846 598846 Smyth, William, of Harwode, husbandman 2
3786939 1953718 1953718 defendant Hall William husbandman 598846 598846 Hall, William, of Harwode, husbandman 3
3818166 1963594 1963594 defendant Mawde Edmund yeoman 598846 598846 Mawde, Edmund, of Harwode, yeoman 0
3818167 1963594 1963594 defendant Wanse or Wause Thomas yeoman 598846 598846 Wanse or Wause, Thomas, of Harwode, yeoman 1
4534660 2211112 2211112 defendant Dewesbery Robert de butcher 598846 598846 Dewesbery, Robert de, of Harwode, butcher 0
4554197 2217237 2217237 defendant Walker William   598846 598846 Walker, William, of Harwode 1
4751826 2281025 2281025 defendant Redeman Richard   598846 598846 Redeman, Richard, of Harwode, knight 0
4772614 2287403 2287403 defendant Redeman Richard   598846 598846 Redeman, Richard, of Harwode, knight 0
4777670 2289011 2289011 defendant Clerk Thomas yeoman 598846 598846 Clerk, Thomas, of Harwode, or of Ledes, yeoman 3
4813558 2300349 2300349 defendant Beste Thomas   598846 598846 Beste, Thomas, of Harwode, bailiff 2
4872873 2318468 2318468 defendant Flynt Robert chaplain 598846 598846 Flynt, Robert, of Harwode, chaplain 1
5043728 2369748 2369748 defendant Redman John gent 598846 598846 with Redman, John, of Harwode, gent 1
5043730 2369749 2369749 defendant Redmayn John gent 598846 598846 Redmayn, John, of Harwode, gent 0
5121682 2392771 2392771 defendant Redman Richard esq 598846 598846 Redman, Richard, of Harwode, esq 0
5257354 2432423 2432423 defendant Fleschour Robert yeoman 598846 598846 Fleschour, Robert, of Harwode, yeoman 3
5275572 2437924 2437924 defendant Atherton John yeoman 598846 598846 Atherton, John, of Harwode, yeoman 5
5275580 2437925 2437925 defendant Atherton John yeoman 598846 598846 Atherton, John, of Harwode, yeoman 5
5275588 2437926 2437926 defendant Atherton John yeoman 598846 598846 Atherton, John, of Harwode, yeoman 5
5275596 2437927 2437927 defendant Atherton John yeoman 598846 598846 Atherton, John, of Harwode, yeoman 5
5335231 2455603 2455603 defendant Colynson John husbandman 598846 598846 Colynson, John, of Harwode, husbandman 0
5350188 2460182 2460182 defendant Burton Edmund butcher 598846 598846 Burton, Edmund, of Harwode, butcher 0
5353287 2461102 2461102 defendant Essote Thomas laborer 598846 598846 Essote, Thomas, of Harwode, laborer 0
5353288 2461102 2461102 defendant Flesshore William laborer 598846 598846 together with Flesshore, William, of Harwode, laborer 1
5491876 2502479 2502479 defendant Athirton John yeoman 598846 598846 Athirton, John, of Harwode, yeoman 0
5494256 2503186 2503186 defendant Yorke John clerk 598846 598846 Yorke, John, of Harwode, clerk 0
5494259 2503187 2503187 defendant Yorke John clerk 598846 598846 Yorke, John, of Harwode, clerk 0
5512443 2508755 2508755 defendant Lovcok John yeoman 598846 598846 Lovcok, John, of Harwode, yeoman 0
5542431 2517754 2517754 defendant Fletcher John yeoman 598846 598846 Fletcher, John, of Harwode, yeoman 0
5552882 2520895 2520895 defendant Parkynson Adam miller 598846 598846 Parkynson, Adam, of Harwode, miller 0
5557843 2522246 2522246 defendant Gybson Roland chaplain 598846 598846 Gybson, Roland, of Harwode, chaplain 1
5634952 2554920 2554920 defendant Colmell William husbandman 598846 598846 Colmell, William, of Harwode, husbandman 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);