names

61 rows where place_id = 597098

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3627281 1903379 1903379 defendant Blok James tailor 597098 597098 Blok, James, of Asteley, tailor 0
3643782 1908484 1908484 defendant Combe John yeoman 597098 597098 Combe, John, of Asteley, yeoman 1
3692435 1923811 1923811 defendant Broke William, junior husbandman 597098 597098 Broke, William, junior, of Asteley, husbandman 1
3713759 1930602 1930602 defendant Baddesley Richard laborer 597098 597098 Baddesley, Richard, of Asteley, laborer 0
3713760 1930602 1930602 defendant Townesend William chaplain 597098 597098 Townesend, William, of Asteley, chaplain 1
3716468 1931444 1931444 defendant Jokys Humphrey husbandman 597098 597098 Jokys, Humphrey, of Asteley, husbandman 3
3720652 1932747 1932747 defendant Watten William husbandman 597098 597098 Watten, William, of Asteley, husbandman 1
3764102 1946419 1946419 defendant Blokke James yeoman 597098 597098 Blokke, James, of Asteley, yeoman 1
3814309 1962386 1962386 defendant Madokys William tailor 597098 597098 Madokys, William, of Asteley, tailor 0
3814313 1962387 1962387 defendant Madokys William tailor 597098 597098 Madokys, William, of Asteley, tailor 0
3828924 1966928 1966928 plaintiff Combe John, senior yeoman 597098 597098 Combe, John, senior, of Asteley, yeoman 0
3832759 1968172 1968172 defendant Magott William laborer 597098 597098 Magott, William, of Asteley, laborer 1
3832760 1968172 1968172 defendant Hyll Richard laborer 597098 597098 Hyll, Richard, of Asteley, laborer 2
3888621 1986450 1986450 defendant Elcote John husbandman 597098 597098 Elcote, John, of Asteley, husbandman 0
3890866 1987212 1987212 defendant Kent Richard husbandman 597098 597098 Kent, Richard, of Asteley, husbandman 1
3890868 1987212 1987212 defendant Walle John tailor 597098 597098 Walle, John, of Asteley, tailor 3
3899100 1989906 1989906 defendant Whetley Robert clerk 597098 597098 Whetley, Robert, of Asteley, clerk 0
3899101 1989906 1989906 defendant Whetley Robert husbandman 597098 597098 Whetley, Robert, of Asteley, husbandman 1
3930206 2000450 2000450 defendant Harley George husbandman 597098 597098 Harley, George, of Asteley, husbandman 0
3940100 2003705 2003705 defendant Esteley Richard husbandman 597098 597098 Esteley, Richard, of Asteley, husbandman 2
4047712 2041627 2041627 plaintiff Stonehyrst Edward yeoman 597098 597098 Stonehyrst, Edward, of Asteley, yeoman 0
4047713 2041627 2041627 defendant Eton Thomas husbandman 597098 597098 Eton, Thomas, of Asteley, husbandman 0
4048967 2042073 2042073 defendant Tonge Peter gent 597098 597098 Tonge, Peter, of Asteley, gent 0
4056836 2044827 2044827 plaintiff Brooke Robert husbandman 597098 597098 Brooke, Robert, of Asteley, husbandman 0
4065893 2048093 2048093 defendant Harley George yeoman 597098 597098 Harley, George, of Asteley, yeoman 4
4161639 2082139 2082139 defendant Stonard or Stonehurst Edward yeoman 597098 597098 Stonard or Stonehurst, Edward, of Asteley, yeoman 0
4564205 2220379 2220379 plaintiff Salewey William   597098 597098 Salewey, William, of Asteley 0
4659938 2248958 2248958 defendant Askebrenner John   597098 597098 Askebrenner, John, of Asteley 0
4660465 2249099 2249099 defendant Williames John honeyman 597098 597098 Williames, John, of Asteley, honeyman 0
4660466 2249099 2249099 defendant Prestesson Roger husbandman 597098 597098 Prestesson, Roger, of Asteley, husbandman 1
4678818 2258980 2258980 plaintiff Hurtyll William   597098 597098 Hurtyll, William, of Asteley 0
4803217 2297198 2297198 defendant Blyke Richard gent 597098 597098 Blyke, Richard, of Asteley, gent 0
4821502 2302810 2302810 defendant Cosyn William husbandman 597098 597098 Cosyn, William, of Asteley, husbandman 2
4867430 2316780 2316780 defendant Blakwall John husbandman 597098 597098 Blakwall, John, of Asteley, husbandman 3
4998396 2356397 2356397 defendant Marteley Henry   597098 597098 Marteley, Henry, of Asteley, perpetual vicar 0
5062030 2375201 2375201 defendant Jenour William yeoman 597098 597098 Jenour, William, of Asteley, yeoman 0
5224976 2422976 2422976 defendant Wyllyngton Thomas yeoman 597098 597098 Wyllyngton, Thomas, of Asteley, yeoman 2
5224977 2422976 2422976 defendant Pylton Thomas yeoman 597098 597098 Pylton, Thomas, of Asteley, yeoman 3
5236533 2426272 2426272 defendant Hunt Thomas husbandman 597098 597098 Hunt, Thomas, of Asteley, husbandman 0
5270687 2436530 2436530 defendant Hunt Thomas husbandman 597098 597098 Hunt, Thomas, of Asteley, husbandman 0
5285268 2440712 2440712 defendant Typper John yeoman 597098 597098 Typper, John, of Asteley, yeoman 4
5329390 2453874 2453874 defendant Pylton Elizabeth widow 597098 597098 Pylton, Elizabeth, of Asteley, widow 0
5329392 2453875 2453875 defendant Pylton Elizabeth widow 597098 597098 Pylton, Elizabeth, of Asteley, widow 0
5365960 2465010 2465010 defendant Harryes Richard clerk 597098 597098 Harryes, Richard, of Asteley, clerk 0
5379071 2469049 2469049 defendant Harrys Richard clerk 597098 597098 Harrys, Richard, of Asteley, clerk 0
5383423 2470338 2470338 defendant Person Thomas yeoman 597098 597098 Person, Thomas, of Asteley, yeoman 1
5395206 2473701 2473701 defendant Person Thomas yeoman 597098 597098 Person, Thomas, of Asteley, yeoman 1
5400644 2475245 2475245 defendant Croftes Richard   597098 597098 Croftes, Richard, of Asteley, yeoman, provost & bailiff 0
5420949 2481196 2481196 defendant Harries Richard clerk 597098 597098 Harries, Richard, of Asteley, clerk 0
5422092 2481550 2481550 defendant Browet William yeoman 597098 597098 Browet, William, of Asteley, yeoman 0
5422093 2481550 2481550 defendant Turner John yeoman 597098 597098 Turner, John, of Asteley, yeoman 1
5422096 2481551 2481551 defendant Lyne William husbandman 597098 597098 Lyne, William, of Asteley, husbandman 0
5429776 2483843 2483843 defendant Stone Edmund husbandman 597098 597098 Stone, Edmund, of Asteley, husbandman 5
5429777 2483843 2483843 defendant Stevenot William husbandman 597098 597098 Stevenot, William, of Asteley, husbandman 6
5440093 2486940 2486940 defendant Harryes Richard clerk 597098 597098 Harryes, Richard, of Asteley, clerk 0
5479859 2498987 2498987 defendant Welles Robert husbandman 597098 597098 Welles, Robert, of Asteley, husbandman 0
5530825 2514157 2514157 plaintiff Sadeler John (legal representative) 597098 597098 Sadeler, John, of Asteley, chaplain, executor of 0
5549323 2519851 2519851 defendant Fernall Robert yeoman 597098 597098 Fernall, Robert, of Asteley, yeoman 2
5588050 2531273 2531273 defendant Oughton William miller 597098 597098 Oughton, William, of Asteley, miller 0
5613675 2548053 2548053 defendant Rydyng Richard, junior   597098 597098 Rydyng, Richard, junior, of Asteley 2
5619122 2549829 2549829 defendant Williames John   597098 597098 Williames, John, of Asteley 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);