names

17 rows where place_id = 601443

✎ 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
3645367 1908960 1908960 defendant Atwyll Katherine widow 601443 601443 Atwyll, Katherine, of Toppesham, widow 1
3663872 1914638 1914638 defendant Coyll Thomas husbandman 601443 601443 Coyll, Thomas, of Toppesham, husbandman 0
3706144 1928215 1928215 defendant Oke John hooper 601443 601443 Oke, John, of Toppesham, hooper 0
3716965 1931593 1931593 defendant Lange Nicholas husbandman 601443 601443 Lange, Nicholas, of Toppesham, husbandman 0
4160688 2081813 2081813 defendant Bagwell William husbandman 601443 601443 Bagwell, William, of Toppesham, husbandman 0
4160689 2081813 2081813 defendant Glanvile Robert husbandman 601443 601443 Glanvile, Robert, of Toppesham, husbandman 1
4570992 2222494 2222494 defendant Ewer Roger   601443 601443 Ewer, Roger, of Toppesham 0
4580924 2225512 2225512 defendant Neel Richard   601443 601443 Neel, Richard, of Toppesham 6
4663023 2249901 2249901 defendant Whitelegh Nicholas merchant 601443 601443 Whitelegh, Nicholas, of Toppesham, merchant 0
4689107 2262153 2262153 defendant Neell Richard, junior   601443 601443 Neell, Richard, junior, of Toppesham 0
4791297 2293373 2293373 defendant Jolyf Edward husbandman 601443 601443 Jolyf, Edward, of Toppesham, husbandman 0
4844135 2309677 2309677 defendant Joly Edward yeoman 601443 601443 Joly, Edward, of Toppesham, yeoman 0
5412080 2478569 2478569 defendant Benet Thomas merchant 601443 601443 Benet, Thomas, of Toppesham, merchant 0
5426691 2482929 2482929 defendant Benet Thomas merchant 601443 601443 Benet, Thomas, of Toppesham, merchant 0
5547443 2519265 2519265 defendant Hamelyn Robert   601443 601443 Hamelyn, Robert, of Toppesham, groom 1
5573855 2526921 2526921 defendant Moyne Robert merchant 601443 601443 Moyne, Robert, of Toppesham, merchant 2
5573858 2526922 2526922 defendant Moyne Robert merchant 601443 601443 Moyne, Robert, of Toppesham, merchant 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);