names

82 rows where place_id = 732080

✎ 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
4297560 2129230 2129230 defendant Blanchard William yeoman 732080 732080 Blanchard, William, of Barking, yeoman 0
4348426 2146702 2146702 defendant Atkinson John   732080 732080 Atkinson, John, of Barking, Essex weaver 2
4410415 2168085 2168085 defendant Smartwait William yeoman 732080 732080 Smartwait, William, of Barking, or of Ingerston, Essex, yeoman 0
4565625 2220818 2220818 defendant Burgh William   732080 732080 Burgh, William, of Barking 2
4713777 2269632 2269632 plaintiff Swynford Margaret   732080 732080 Swynford, Margaret, of Barking, abbess 0
4762757 2284334 2284334 defendant Gosselyn John yeoman 732080 732080 Gosselyn, John, of Barking, yeoman 0
4766209 2285424 2285424 defendant Wellys William   732080 732080 Wellys, William, of Barking, bailiff 0
4766210 2285424 2285424 defendant Gosselyn John yeoman 732080 732080 Gosselyn, John, of Barking, yeoman 1
4766212 2285425 2285425 defendant Gosselyn John yeoman 732080 732080 Gosselyn, John, of Barking, yeoman 0
4766224 2285428 2285428 defendant Moor Roger gent 732080 732080 Moor, Roger, of Barking, gent 0
4768890 2286249 2286249 defendant More William gent 732080 732080 More, William, of Barking, gent 2
4833015 2306343 2306343 defendant Germayn William gent 732080 732080 Germayn, William, of Barking, gent 0
4846140 2310300 2310300 plaintiff Pole Katherine   732080 732080 Pole, Katherine, of Barking, abbess 0
4986818 2352996 2352996 defendant Pesok John husbandman 732080 732080 Pesok, John, of Barking, husbandman 0
4986819 2352996 2352996 defendant Munk Richard yeoman 732080 732080 Munk, Richard, of Barking, yeoman 1
5000431 2356995 2356995 defendant Bolton Michael gent 732080 732080 Bolton, Michael, of Barking, gent 0
5000432 2356995 2356995 defendant Ketyl Simon husbandman 732080 732080 Ketyl, Simon, of Barking, husbandman 1
5000433 2356995 2356995 defendant Ducheman Peter husbandman 732080 732080 together with Ducheman, Peter, of Barking, husbandman 2
5000434 2356995 2356995 defendant Parker John husbandman 732080 732080 Parker, John, of Barking, husbandman 3
5000435 2356995 2356995 defendant Boys Adam husbandman 732080 732080 Boys, Adam, of Barking, husbandman 4
5000436 2356995 2356995 defendant Cotyngham Robert husbandman 732080 732080 Cotyngham, Robert, of Barking, husbandman 5
5010711 2359995 2359995 defendant Redyng William husbandman 732080 732080 Redyng, William, of Barking, husbandman 0
5010712 2359995 2359995 defendant Strode William husbandman 732080 732080 Strode, William, of Barking, husbandman 1
5012381 2360472 2360472 defendant Saltwell William carpenter 732080 732080 Saltwell, William, of Barking, carpenter 1
5012382 2360472 2360472 defendant Core William laborer 732080 732080 Core, William, of barking, laborer 2
5012383 2360472 2360472 defendant Albert William laborer 732080 732080 Albert, William, of Barking, laborer 3
5042351 2369319 2369319 plaintiff de la Pole Katherine   732080 732080 de la Pole, Katherine, of Barking, abbess 0
5146158 2400002 2400002 defendant Kyng John carpenter 732080 732080 Kyng, John, of Barking, carpenter 0
5146159 2400002 2400002 defendant Foote John husbandman 732080 732080 Foote, John, of Barking, husbandman 1
5146160 2400002 2400002 defendant Warde Robert shoemaker 732080 732080 Warde, Robert, of Barking, shoemaker 2
5146161 2400002 2400002 defendant Harlrom Agnes widow 732080 732080 Harlrom, Agnes, of Barking, widow 3
5149626 2401020 2401020 defendant Samwell John yeoman 732080 732080 Samwell, John, of Barking, yeoman 0
5150467 2401270 2401270 defendant Burre John tanner 732080 732080 Burre, John, of Barking, tanner 0
5153695 2402239 2402239 defendant Broun John laborer 732080 732080 Broun, John, of Barking, laborer 0
5158133 2403497 2403497 plaintiff Poole Katherine de la   732080 732080 Poole, Katherine de la, of Barking, abbess 0
5158136 2403498 2403498 plaintiff Poole Katherine de la   732080 732080 Poole, Katherine de la, of Barking, abbess 0
5162434 2404737 2404737 defendant Hyde John husbandman 732080 732080 Hyde, John, of Barking, husbandman 0
5182122 2410525 2410525 defendant Bolton Michael esq 732080 732080 Bolton, Michael, of Barking, esq 0
5186523 2411807 2411807 plaintiff Grenyng John   732080 732080 Grenyng, John, of Barking, vicar 0
5188708 2412424 2412424 defendant Congreve Thomas gent 732080 732080 Congreve, Thomas, of Barking, gent 0
5191782 2413333 2413333 plaintiff Hunt Hugh   732080 732080 Hunt, Hugh, of Barking 4
5193929 2413954 2413954 plaintiff Poole Katherine de la   732080 732080 Poole, Katherine de la, of Barking, abbess 0
5197685 2415063 2415063 defendant Reynold William skinner 732080 732080 Reynold, William, of Barking, skinner 0
5197686 2415063 2415063 defendant Butell Richard water man 732080 732080 Butell, Richard, of Barking, water man 1
5198232 2415229 2415229 defendant Hoke John, sen butcher 732080 732080 Hoke, John, sen, of Barking, butcher 0
5198649 2415362 2415362 defendant Hyde John yeoman 732080 732080 Hyde, John, of Barking, yeoman 0
5198966 2415451 2415451 defendant Gore Simon (legal representative) 732080 732080 Gore, Simon, of Barking, husbandman, executors of 0
5198968 2415451 2415451 defendant Frost Thomas yeoman 732080 732080 Frost, Thomas, of Barking, yeoman 2
5198969 2415451 2415451 defendant Lyman John yeoman 732080 732080 Lyman, John, of Barking, yeoman 3
5198972 2415452 2415452 defendant Gore Simon (legal representative) 732080 732080 Gore, Simon, of Barking, husbandman, executors of 0
5198974 2415452 2415452 defendant Frost Thomas yeoman 732080 732080 Frost, Thomas, of Barking, yeoman 2
5198975 2415452 2415452 defendant Lyman John yeoman 732080 732080 Lyman, John, of Barking, yeoman 3
5200289 2415845 2415845 defendant Congreve Thomas gent 732080 732080 Congreve, Thomas, of Barking, gent 0
5200292 2415846 2415846 defendant Congreve Thomas gent 732080 732080 Congreve, Thomas, of Barking, gent 0
5201604 2416234 2416234 defendant Ruston John gent 732080 732080 Ruston, John, of Barking, gent 0
5201606 2416235 2416235 defendant Yonge John yeoman 732080 732080 Yonge, John, of Barking, yeoman 0
5201607 2416235 2416235 defendant Grenyng John clerk 732080 732080 Grenyng, John, of Barking, clerk 1
5201608 2416235 2416235 defendant Frost Thomas yeoman 732080 732080 Frost, Thomas, of Barking, yeoman 2
5201905 2416321 2416321 defendant Hawk William husbandman 732080 732080 Hawk, William, of Barking, husbandman 0
5205146 2417264 2417264 defendant Botyll Richard husbandman 732080 732080 Botyll, Richard, of Barking, husbandman 0
5205147 2417264 2417264 defendant Cheyne William husbandman 732080 732080 Cheyne, William, of Barking, husbandman 1
5205148 2417264 2417264 defendant Ardern John husbandman 732080 732080 Ardern, John, of Barking, husbandman 2
5205149 2417264 2417264 defendant Hache Robert   732080 732080 Hache, Robert, of Barking, servant 3
5205726 2417418 2417418 defendant Botyll Richard fishmonger 732080 732080 Botyll, Richard, of Barking, fishmonger 0
5210246 2418724 2418724 defendant Reynold William skinner 732080 732080 Reynold, William, of Barking, skinner 0
5210247 2418724 2418724 defendant Butell Richard water man 732080 732080 Butell, Richard, of Barking, water man 1
5210862 2418909 2418909 defendant Gore Simon (legal representative) 732080 732080 Gore, Simon, of Barking, husbandman, executors of 0
5210864 2418909 2418909 defendant Frost Thomas yeoman 732080 732080 Frost, Thomas, of Barking, yeoman 2
5211441 2419080 2419080 defendant Congreve Thomas, sen gent 732080 732080 Congreve, Thomas, sen, of Barking, gent 0
5308865 2447694 2447694 defendant Bedyngham Thomas yeoman 732080 732080 Bedyngham, Thomas, of Barking, yeoman 0
5308867 2447694 2447694 defendant Howeghen John dyer 732080 732080 Howeghen, John, of Barking, dyer 2
5404905 2476480 2476480 defendant Topleff John butcher 732080 732080 Topleff, John, of Barking, butcher 0
5450788 2490125 2490125 defendant Bakir Nicholas   732080 732080 Bakir, Nicholas, of Barking, tallow chandler 1
5466757 2495005 2495005 defendant Luton Thomas miller 732080 732080 Luton, Thomas, of Barking, miller 0
5467730 2495283 2495283 plaintiff Bryan Margaret gentlewoman 732080 732080 Bryan, Margaret, of Barking, gentlewoman 0
5467731 2495283 2495283 defendant Raynold John yeoman 732080 732080 Raynold, John, of Barking, yeoman 0
5467732 2495284 2495284 plaintiff Bryan Margaret gentlewoman 732080 732080 Bryan, Margaret, of Barking, gentlewoman 0
5467733 2495284 2495284 defendant Reynold John yeoman 732080 732080 Reynold, John, of Barking, yeoman 0
5467754 2495289 2495289 defendant Frsot Thomas yeoman 732080 732080 Frsot, Thomas, of Barking, yeoman 1
5469882 2495916 2495916 defendant Bedynham Thomas yeoman 732080 732080 Bedynham, Thomas, of Barking, yeoman 0
5471159 2496309 2496309 defendant Strangman John   732080 732080 Strangman, John, of Barking, ship wright 0
5474268 2497282 2497282 defendant Hanbery Thomas yeoman 732080 732080 Hanbery, Thomas, of Barking, yeoman 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);