names

40 rows where place_id = 614820

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3705714 1928070 1928070 defendant Carter Roger clerk 614820 614820 Carter, Roger, of Lound, clerk 0
3811232 1961408 1961408 plaintiff Candeler Margaret (legal representative) 614820 614820 Candeler, Margaret, of Lound, widow, executors of 0
3849203 1973346 1973346 defendant Calverley Thomas gent 614820 614820 Calverley, Thomas, of Lound, gent 0
4422060 2171775 2171775 plaintiff Dobson William   614820 614820 Dobson, William, of Lound, son of Adam 0
4422061 2171775 2171775 defendant Dobson Richard   614820 614820 Dobson, Richard, of Lound, son of Adam 0
4427527 2173446 2173446 defendant atte Styghele William   614820 614820 atte Styghele, William, of Lound 0
4528828 2209300 2209300 defendant Clyf Mathew   614820 614820 Clyf, Mathew, of Lound 0
4995860 2355607 2355607 defendant Galyon Thomas husbandman 614820 614820 Galyon, Thomas, of Lound, husbandman 0
5039398 2368429 2368429 defendant Herman John husbandman 614820 614820 Herman, John, of Lound, husbandman 0
5044494 2369984 2369984 defendant Overgate William husbandman 614820 614820 Overgate, William, of Lound, husbandman 0
5045034 2370148 2370148 defendant Prymour Robert yeoman 614820 614820 Prymour, Robert, of Lound, yeoman 0
5045035 2370148 2370148 defendant Gunton Thomas husbandman 614820 614820 Gunton, Thomas, of Lound, husbandman 1
5052364 2372306 2372306 defendant Prymour Robert yeoman 614820 614820 Prymour, Robert, of Lound, yeoman 0
5060105 2374590 2374590 defendant Sterap Thomas yeoman 614820 614820 Sterap, Thomas, of Lound, yeoman 1
5072692 2378317 2378317 defendant Fyrthborgh John husbandman 614820 614820 Fyrthborgh, John, of Lound, husbandman 0
5072693 2378317 2378317 defendant Fyrthborgh William husbandman 614820 614820 Fyrthborgh, William, of Lound, husbandman 1
5079361 2380324 2380324 defendant Chapman Thomas yeoman 614820 614820 Chapman, Thomas, of Lound, yeoman 0
5079362 2380324 2380324 defendant Daryes John husbandman 614820 614820 Daryes, John, of Lound, husbandman 1
5079363 2380324 2380324 defendant Man Thomas husbandman 614820 614820 Man, Thomas, of Lound, husbandman 2
5079364 2380324 2380324 defendant Byrd Thomas husbandman 614820 614820 Byrd, Thomas, of Lound, husbandman 3
5079365 2380324 2380324 defendant Boys Roger laborer 614820 614820 Boys, Roger, of Lound, laborer 4
5079366 2380324 2380324 defendant Bery Robert husbandman 614820 614820 Bery, Robert, of Lound, husbandman 5
5094903 2384924 2384924 defendant Stag Edmund husbandman 614820 614820 Stag, Edmund, of Lound, husbandman 3
5112475 2390035 2390035 defendant Prymour Robert yeoman 614820 614820 Prymour, Robert, of Lound, yeoman 1
5160773 2404247 2404247 defendant Dodworth William gent 614820 614820 Dodworth, William, of Lound, gent 0
5175438 2408509 2408509 defendant Dodworth William gent 614820 614820 Dodworth, William, of Lound, gent 0
5175458 2408512 2408512 defendant Dodworth William gent 614820 614820 Dodworth, William, of Lound, gent 0
5238353 2426804 2426804 defendant Prymour Robert yeoman 614820 614820 Prymour, Robert, of Lound, yeoman 2
5240684 2427488 2427488 plaintiff Prymour Robert   614820 614820 (Prymour, Robert, of Lound 1
5300819 2445204 2445204 plaintiff Colyn Thomas (legal representative) 614820 614820 Colyn, Thomas, of Lound, husbandman, executors of 0
5327128 2453189 2453189 defendant Ketelwell John yeoman 614820 614820 Ketelwell, John, of Lound, yeoman 2
5327153 2453196 2453196 defendant Ketelwell John yeoman 614820 614820 Ketelwell, John, of Lound, yeoman 2
5540728 2517232 2517232 defendant Candeler Edmund husbandman 614820 614820 Candeler, Edmund, of Lound, husbandman 2
5562575 2523656 2523656 defendant Reve William laborer 614820 614820 Reve, William, of Lound, laborer 3
5576443 2527687 2527687 defendant Wade Hugh husbandman 614820 614820 Wade, Hugh, of Lound, husbandman 0
5592904 2532781 2532781 defendant Grye Richard husbandman 614820 614820 Grye, Richard, of Lound, husbandman 0
5592905 2532781 2532781 defendant Wade John husbandman 614820 614820 Wade, John, of Lound, husbandman 1
5592906 2532781 2532781 defendant Wade Hugh husbandman 614820 614820 Wade, Hugh, of Lound, husbandman 2
5606374 2536887 2536887 defendant Grenefeld Katherine widow 614820 614820 Grenefeld, Katherine, of Lound, widow 1
5614398 2548296 2548296 defendant Cokheved John   614820 614820 Cokheved, John, of Lound 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);