names

25 rows where place_id = 721823

✎ 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
4241582 2110170 2110170 defendant Baskafeld John yeoman 721823 721823 Baskafeld, John, of Suthwell, Notts, yeoman 2
4654977 2247440 2247440 defendant Overton William yeoman 721823 721823 Overton, William, of Suthwell, Notts, yeoman 1
4669888 2256278 2256278 defendant Overton William yeoman 721823 721823 Overton, William, of Suthwell, Notts, yeoman 0
4752426 2281168 2281168 defendant Durant Richard gent 721823 721823 Durant, Richard, of Suthwell, Notts, gent 1
4821340 2302755 2302755 defendant Parcour William dyer 721823 721823 Parcour, William, of Suthwell, Notts, dyer 0
4932682 2336611 2336611 defendant Welles Philip gent 721823 721823 Welles, Philip, of Suthwell, Notts, gent 1
5018964 2362438 2362438 defendant Torkesey William yeoman 721823 721823 Torkesey, William, of Suthwell, Notts, yeoman 1
5019049 2362463 2362463 defendant Torkesey William yeoman 721823 721823 Torkesey, William, of Suthwell, Notts, yeoman 1
5025698 2364419 2364419 defendant Bellers Agnes widow 721823 721823 Bellers, Agnes, of Suthwell, Notts, widow 5
5126212 2394149 2394149 defendant Rudde John chaplain 721823 721823 Rudde, John, of Suthwell, Notts, chaplain 0
5195479 2414425 2414425 defendant Radclyf Ralph esq 721823 721823 (Radclyf, Ralph, of Suthwell, Notts, esq 1
5262373 2433978 2433978 defendant Chaworth Thomas esq 721823 721823 Chaworth, Thomas, of Suthwell, Notts, esq 2
5262378 2433979 2433979 defendant Chaworth Thomas esq 721823 721823 Chaworth, Thomas, of Suthwell, Notts, esq 2
5304163 2446253 2446253 defendant Wartre Edmund clerk 721823 721823 Wartre, Edmund, of Suthwell, Notts, clerk 0
5313541 2449077 2449077 defendant Hynde John husbandman 721823 721823 Hynde, John, of Suthwell, Notts, husbandman 0
5330855 2454301 2454301 defendant Hynde John husbandman 721823 721823 Hynde, John, of Suthwell, Notts, husbandman 0
5331776 2454585 2454585 defendant Wryght William butcher 721823 721823 Wryght, William, of Suthwell, Notts, butcher 0
5345931 2458860 2458860 defendant Tykell Thomas chaplain 721823 721823 Tykell, Thomas, of Suthwell, Notts, chaplain 0
5377662 2468595 2468595 defendant Lemynge alias Whitehand John chaplain 721823 721823 Lemynge alias Whitehand, John, of Suthwell, Notts, chaplain 0
5397677 2474403 2474403 defendant Serlby Robert (legal representative) 721823 721823 Serlby, Robert, of Suthwell, Notts, gent, executor of 0
5547628 2519323 2519323 defendant Sammesbury Richard gent 721823 721823 Sammesbury, Richard, of Suthwell, Notts, gent 0
5547632 2519324 2519324 defendant Sammesbury Richard gent 721823 721823 Sammesbury, Richard, of Suthwell, Notts, gent 0
5580650 2529030 2529030 defendant Brewester John yeoman 721823 721823 Brewester, John, of Suthwell, Notts, yeoman 2
5596255 2533743 2533743 defendant Brewester John yeoman 721823 721823 Brewester, John, of Suthwell, Notts, yeoman 1
5596260 2533744 2533744 defendant Brewester John yeoman 721823 721823 Brewester, John, of Suthwell, Notts, yeoman 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);