names

41 rows where place_id = 619581

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3730762 1935846 1935846 defendant Wylkyns Nicholas laborer 619581 619581 Wylkyns, Nicholas, of Magna Bokeham, laborer 1
3730763 1935846 1935846 defendant Hylder John laborer 619581 619581 Hylder, John, of Magna Bokeham, laborer 2
3749468 1941743 1941743 defendant Sewar John laborer 619581 619581 Sewar, John, of Magna Bokeham, laborer 15
3766246 1947096 1947096 plaintiff Elyott John   619581 619581 Elyott, John, of Magna Bokeham 1
3798343 1957381 1957381 defendant Slyffeld John esq 619581 619581 Slyffeld, John, of Magna Bokeham, esq 0
3818203 1963607 1963607 plaintiff Elyot John   619581 619581 Elyot, John, of Magna Bokeham 1
3853722 1974795 1974795 defendant (not given) Fulk vicar of Symond 619581 619581 Symond, Fulk, of Magna Bokeham, vicar of Grete Bucham 0
4876457 2319600 2319600 plaintiff Slyffeld Thomas esq 619581 619581 Slyffeld, Thomas, of Magna Bokeham, esq 0
4961501 2345402 2345402 defendant atte Pery Thomas butcher 619581 619581 atte Pery, Thomas, of Magna Bokeham, butcher 0
5038044 2368010 2368010 defendant Slyfeld Richard husbandman 619581 619581 Slyfeld, Richard, of Magna Bokeham, husbandman 0
5038045 2368010 2368010 defendant Manewell William   619581 619581 Manewell, William, of Magna Bokeham, groom 1
5065197 2376127 2376127 defendant atte Hole Richard husbandman 619581 619581 atte Hole, Richard, of Magna Bokeham, husbandman 0
5081928 2381090 2381090 defendant Darnewell Richard husbandman 619581 619581 Darnewell, Richard, of Magna Bokeham, husbandman 3
5081930 2381090 2381090 defendant Peek John laborer 619581 619581 Peek, John, of Magna Bokeham, laborer 5
5106909 2388448 2388448 defendant Peek John laborer 619581 619581 Peek, John, of Magna Bokeham, laborer 5
5119643 2392179 2392179 defendant Kyng Richard yeoman 619581 619581 Kyng, Richard, of Magna Bokeham, yeoman 1
5225299 2423070 2423070 defendant Dene Richard husbandman 619581 619581 Dene, Richard, of Magna Bokeham, husbandman 0
5265420 2434943 2434943 defendant Marcer John husbandman 619581 619581 Marcer, John, of Magna Bokeham, husbandman 0
5265421 2434943 2434943 defendant Charles John husbandman 619581 619581 Charles, John, of Magna Bokeham, husbandman 1
5287782 2441449 2441449 defendant Style Bartholomew smith 619581 619581 Style, Bartholomew, of Magna Bokeham, smith 6
5316207 2449930 2449930 defendant Hutson William tailor 619581 619581 Hutson, William, of Magna Bokeham, tailor 0
5321233 2451448 2451448 defendant Styllewell John yeoman 619581 619581 Styllewell, John, of Magna Bokeham, yeoman 1
5321257 2451455 2451455 defendant Styllewell John yeoman 619581 619581 Styllewell, John, of Magna Bokeham, yeoman 1
5331443 2454481 2454481 defendant Stilwell John husbandman 619581 619581 Stilwell, John, of Magna Bokeham, husbandman 0
5331445 2454482 2454482 defendant Stilwell John husbandman 619581 619581 Stilwell, John, of Magna Bokeham, husbandman 0
5331447 2454483 2454483 defendant Stilwell John husbandman 619581 619581 Stilwell, John, of Magna Bokeham, husbandman 0
5334496 2455391 2455391 defendant Kyng Richard yeoman 619581 619581 Kyng, Richard, of Magna Bokeham, yeoman 1
5334498 2455391 2455391 defendant Ball Henry yeoman 619581 619581 Ball, Henry, of Magna Bokeham, yeoman 3
5338626 2456651 2456651 defendant Balle Henry yeoman 619581 619581 Balle, Henry, of Magna Bokeham, yeoman 1
5340591 2457258 2457258 defendant Stylwell John husbandman 619581 619581 Stylwell, John, of Magna Bokeham, husbandman 1
5343178 2458057 2458057 defendant Stylewell John husbandman 619581 619581 Stylewell, John, of Magna Bokeham, husbandman 0
5350481 2460269 2460269 defendant Durden John husbandman 619581 619581 Durden, John, of Magna Bokeham, husbandman 1
5359748 2463087 2463087 defendant Kyng Richard yeoman 619581 619581 Kyng, Richard, of Magna Bokeham, yeoman 0
5363640 2464283 2464283 defendant Ball Henry yeoman 619581 619581 Ball, Henry, of Magna Bokeham, yeoman 0
5363641 2464283 2464283 defendant Kynge Richard yeoman 619581 619581 Kynge, Richard, of Magna Bokeham, yeoman 1
5481883 2499513 2499513 defendant Slyfeld Henry gent 619581 619581 Slyfeld, Henry, of Magna Bokeham, gent 0
5495272 2503482 2503482 defendant Halle John husbandman 619581 619581 Halle, John, of Magna Bokeham, husbandman 1
5523788 2512261 2512261 defendant Gardener John husbandman 619581 619581 Gardener, John, of Magna Bokeham, husbandman 2
5523789 2512261 2512261 defendant Gardener Bartholomew husbandman 619581 619581 Gardener, Bartholomew, of Magna Bokeham, husbandman 3
5523790 2512261 2512261 defendant Gardener Richard butcher 619581 619581 Gardener, Richard, of Magna Bokeham, butcher 4
5571475 2526211 2526211 defendant Durden Richard husbandman 619581 619581 Durden, Richard, of Magna Bokeham, husbandman 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);