names

52 rows where place_id = 586974

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3590121 1864549 1864549 defendant Gillotte John yeoman 586974 586974 Gillotte, John, of Pollesworth, yeoman 0
3609152 1870521 1870521 defendant Draycote Elizabeth widow 586974 586974 Draycote, Elizabeth, of Pollesworth, widow 1
3752297 1942642 1942642 defendant Belgrave William gent 586974 586974 Belgrave, William, of Pollesworth, gent 0
3752298 1942642 1942642 defendant Alkyn William laborer 586974 586974 Alkyn, William, of Pollesworth, laborer 1
3768842 1947902 1947902 defendant Belgrave William gent 586974 586974 Belgrave, William, of Pollesworth, gent 0
3768843 1947902 1947902 defendant Alkyn William laborer 586974 586974 Alkyn, William, of Pollesworth, laborer 1
4168342 2084411 2084411 defendant Coope Edward yeoman 586974 586974 Coope, Edward, of Pollesworth, yeoman 1
4416538 2170036 2170036 plaintiff Morys Johes   586974 586974 Morys, Johes, of Pollesworth 0
4416540 2170036 2170036 defendant Baxtere William le   586974 586974 Baxtere, William le, of Pollesworth 0
4417355 2170309 2170309 defendant Draper John le   586974 586974 Draper, John le, of Pollesworth 2
4425951 2172919 2172919 plaintiff Morys John   586974 586974 Morys, John, of Pollesworth 0
4425953 2172919 2172919 defendant Hext_ William le   586974 586974 Hext_, William le, of Pollesworth 0
4427543 2173449 2173449 defendant Draper John le   586974 586974 Draper, John le, of Pollesworth 2
4647674 2245375 2245375 defendant Worsley Thurstan   586974 586974 Worsley, Thurstan, of Pollesworth 0
4807216 2298458 2298458 defendant Ardern William gent 586974 586974 Ardern, William, of Pollesworth, gent 0
4886181 2322539 2322539 plaintiff Asteley John esq 586974 586974 Asteley, John, of Pollesworth, esq 0
4898757 2326261 2326261 defendant de Worseley Alice   586974 586974 de Worseley, Alice, of Pollesworth, widow of de Worseley, Thurstan 1
4926100 2334590 2334590 plaintiff Pryde Benedicta   586974 586974 Pryde, Benedicta, of Pollesworth, abbess, on her own account 0
4940000 2338897 2338897 defendant Colley John husbandman 586974 586974 Colley, John, of Pollesworth, husbandman 4
4940294 2338987 2338987 defendant Worseley John yeoman 586974 586974 Worseley, John, of Pollesworth, yeoman 0
4940295 2338987 2338987 defendant Bradshawe Robert yeoman 586974 586974 Bradshawe, Robert, of Pollesworth, yeoman 1
4940296 2338987 2338987 defendant Hyde Stephen yeoman 586974 586974 Hyde, Stephen, of Pollesworth, yeoman 2
4940297 2338987 2338987 defendant Hyde William yeoman 586974 586974 Hyde, William, of Pollesworth, yeoman 3
4940298 2338987 2338987 defendant Benedictte Thomas tailor 586974 586974 Benedictte, Thomas, of Pollesworth, tailor 4
4955875 2343725 2343725 plaintiff Toky Thomas   586974 586974 Toky, Thomas, of Pollesworth 0
4955876 2343725 2343725 defendant Worseley John yeoman 586974 586974 Worseley, John, of Pollesworth, yeoman 0
4955877 2343725 2343725 defendant Bradshawe Robert yeoman 586974 586974 Bradshawe, Robert, of Pollesworth, yeoman 1
4955878 2343725 2343725 defendant Hyde William yeoman 586974 586974 Hyde, William, of Pollesworth, yeoman 2
4955879 2343725 2343725 defendant Benedicote Thomas tailor 586974 586974 Benedicote, Thomas, of Pollesworth, tailor 3
5168814 2406609 2406609 defendant Keer Henry   586974 586974 Keer, Henry, of Pollesworth, cook 0
5168815 2406609 2406609 defendant Overton John laborer 586974 586974 Overton, John, of Pollesworth, laborer 1
5168816 2406609 2406609 defendant Croft Henry laborer 586974 586974 Croft, Henry, of Pollesworth, laborer 2
5168817 2406609 2406609 defendant Nycollys John laborer 586974 586974 Nycollys, John, of Pollesworth, laborer 3
5168818 2406609 2406609 defendant Hare John laboer 586974 586974 Hare, John, of Pollesworth, laboer 4
5168819 2406609 2406609 defendant Man John weaver 586974 586974 Man, John, of Pollesworth, weaver 5
5185035 2411365 2411365 defendant Keper Henry   586974 586974 Keper, Henry, of Pollesworth, cook 0
5185036 2411365 2411365 defendant Overton John laborer 586974 586974 Overton, John, of Pollesworth, laborer 1
5185037 2411365 2411365 defendant Croft Henry laborer 586974 586974 Croft, Henry, of Pollesworth, laborer 2
5185038 2411365 2411365 defendant Nycollys John laborer 586974 586974 Nycollys, John, of Pollesworth, laborer 3
5185039 2411365 2411365 defendant Hare John laborer 586974 586974 Hare, John, of Pollesworth, laborer 4
5185040 2411365 2411365 defendant Man John weaver 586974 586974 Man, John, of Pollesworth, weaver 5
5222701 2422355 2422355 defendant Chetleton Robert yeoman 586974 586974 Chetleton, Robert, of Pollesworth, yeoman 0
5255987 2431996 2431996 defendant Hitson John clerk 586974 586974 Hitson, John, of Pollesworth, clerk 1
5345765 2458813 2458813 defendant Chetulton Agnes widow 586974 586974 Chetulton, Agnes, of Pollesworth, widow 4
5384330 2470605 2470605 defendant Cokayn Roger gent 586974 586974 Cokayn, Roger, of Pollesworth, gent 0
5396112 2473972 2473972 defendant Cokayn Roger gent 586974 586974 Cokayn, Roger, of Pollesworth, gent 0
5409446 2477788 2477788 defendant (illegible) Roger gent 586974 586974 _, Roger, of Pollesworth, gent 0
5423469 2481979 2481979 defendant Cokayn Roger gent 586974 586974 Cokayn, Roger, of Pollesworth, gent 2
5478551 2498612 2498612 defendant Wythe William yeoman 586974 586974 Wythe, William, of Pollesworth, yeoman 0
5478553 2498613 2498613 defendant Wythe William yeoman 586974 586974 Wythe, William, of Pollesworth, yeoman 0
5510056 2507984 2507984 defendant Wyght William yeoman 586974 586974 Wyght, William, of Pollesworth, yeoman 0
5538695 2516584 2516584 defendant Brasebrege Simon gent 586974 586974 Brasebrege, Simon, of Pollesworth, gent 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);