names

36 rows where place_id = 633759

✎ 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
3814681 1962502 1962502 defendant Arundell Humphrey esq 633759 633759 Arundell, Humphrey, of Radford, esq 0
3835415 1969015 1969015 defendant Harrys William esq 633759 633759 Harrys, William, of Radford, esq 1
3851889 1974182 1974182 defendant Harrys William esq 633759 633759 Harrys, William, of Radford, esq 1
3881461 1984065 1984065 defendant Yardeley John husbandman 633759 633759 Yardeley, John, of Radford, husbandman 0
3881465 1984067 1984067 defendant Yardeley John husbandman 633759 633759 Yardeley, John, of Radford, husbandman 0
3886401 1985704 1985704 defendant Harrys William esq 633759 633759 Harrys, William, of Radford, esq 4
3886407 1985705 1985705 defendant Harrys William esq 633759 633759 Harrys, William, of Radford, esq 2
3889315 1986663 1986663 defendant Harrys William esq 633759 633759 Harrys, William, of Radford, esq 0
4228820 2105560 2105560 defendant Crompton alias Laplone or Laplove William husbandman 633759 633759 Crompton alias Laplone or Laplove, William, of Radford, husbandman 3
4298284 2129486 2129486 defendant Leicester John gent 633759 633759 Leicester, John, of Radford, or of Lenton, gent 0
4300116 2130139 2130139 defendant Leicester John gent 633759 633759 Leicester, John, of Radford, or of Lenton, gent 0
4374631 2155988 2155988 defendant Leicester John gent 633759 633759 Leicester, John, of Radford, or of Lenton, gent 0
4374633 2155989 2155989 defendant Leicester John gent 633759 633759 Leicester, John, of Radford, or of Lenton, gent 0
4378972 2157558 2157558 defendant Leicester John gent 633759 633759 Leicester, John, of Radford, or of Lenton, gent 0
4379049 2157590 2157590 defendant Leicester John gent 633759 633759 Leicester, John, of Radford, or of Lenton, gent 0
4382096 2158700 2158700 defendant Wilson John yeoman 633759 633759 Wilson, John, of Radford, yeoman 0
4394703 2162815 2162815 defendant Palmer John yeoman 633759 633759 Palmer, John, of Radford, yeoman 0
4401356 2165050 2165050 defendant Whiteheade John husbandman 633759 633759 Whiteheade, John, of Radford, husbandman 0
4480210 2194469 2194469 defendant del Hurst Robert   633759 633759 del Hurst, Robert, of Radford 1
4629141 2240042 2240042 defendant Fyssher John   633759 633759 Fyssher, John, of Radford 0
4644593 2244511 2244511 defendant Geffon John thatcher 633759 633759 Geffon, John, of Radford, thatcher 1
4646065 2244923 2244923 defendant Hatton Henry   633759 633759 Hatton, Henry, of Radford 0
5121843 2392820 2392820 defendant Wodleff or Wodless John husbandman 633759 633759 Wodleff or Wodless, John, of Radford, husbandman 4
5125932 2394069 2394069 defendant Cady Robert husbandman 633759 633759 Cady, Robert, of Radford, husbandman 1
5182633 2410677 2410677 defendant Wele Henry chaplain 633759 633759 Wele, Henry, of Radford, chaplain 0
5182634 2410677 2410677 defendant Caddy Robert husbandman 633759 633759 Caddy, Robert, of Radford, husbandman 1
5274829 2437717 2437717 defendant Squier William husbandman 633759 633759 Squier, William, of Radford, husbandman 0
5318293 2450567 2450567 defendant Hare John miller 633759 633759 Hare, John, of Radford, miller 0
5431411 2484346 2484346 defendant Geffes Robert   633759 633759 Geffes, Robert, of Radford 0
5431412 2484346 2484346 defendant Boteler Edward   633759 633759 Boteler, Edward, of Radford 1
5447858 2489243 2489243 defendant Geffs Robert   633759 633759 Geffs, Robert, of Radford 0
5447859 2489243 2489243 defendant Boteler Edward   633759 633759 Boteler, Edward, of Radford 1
5512354 2508723 2508723 defendant Grenehill Robert chaplain 633759 633759 Grenehill, Robert, of Radford, chaplain 0
5512356 2508724 2508724 defendant Grenehyll Robert chaplain 633759 633759 Grenehyll, Robert, of Radford, chaplain 0
5544728 2518463 2518463 defendant Gesson John husbandman 633759 633759 Gesson, John, of Radford, husbandman 0
5566481 2524789 2524789 defendant Harrys Francis   633759 633759 Harrys, Francis, of Radford, esq, son of Harrys, John 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);