names

81 rows where place_id = 587727

✎ 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
3592259 1865193 1865193 defendant Chapman Thomas yeoman 587727 587727 Chapman, Thomas, of Pykeryng, yeoman 0
3592268 1865197 1865197 defendant Chapman Thomas yeoman 587727 587727 Chapman, Thomas, of Pykeryng, yeoman 0
3623283 1874808 1874808 defendant Hastynges John esq 587727 587727 Hastynges, John, of Pykeryng, esq 0
3703574 1927394 1927394 defendant Colman William clerk 587727 587727 Colman, William, of Pykeryng, clerk 1
3703578 1927395 1927395 defendant Colman William clerk 587727 587727 Colman, William, of Pykeryng, clerk 1
3839640 1970323 1970323 plaintiff Woode Giles gent 587727 587727 Woode, Giles, of Pykeryng, gent 0
3839642 1970324 1970324 plaintiff Woode Giles gent 587727 587727 Woode, Giles, of Pykeryng, gent 0
3856213 1975564 1975564 plaintiff Wode Giles gent 587727 587727 Wode, Giles, of Pykeryng, gent 0
3881872 1984190 1984190 defendant Stephenson Richard merchant 587727 587727 Stephenson, Richard, of Pykeryng, merchant 0
3881873 1984190 1984190 defendant Andrewe William husbandman 587727 587727 Andrewe, William, of Pykeryng, husbandman 1
3939449 2003499 2003499 defendant Fryer Henry butcher 587727 587727 Fryer, Henry, of Pykeryng, butcher 1
4442957 2182758 2182758 plaintiff Caldham John de   587727 587727 Caldham, John de, of Pykeryng 0
4442960 2182759 2182759 plaintiff Caldham Wiliam   587727 587727 Caldham, Wiliam, of Pykeryng 0
4457981 2187519 2187519 plaintiff Poy John chaplain 587727 587727 Poy, John, of Pykeryng, chaplain 0
4466378 2190148 2190148 defendant Childe Stephen   587727 587727 Childe, Stephen, of Pykeryng 1
4486043 2196337 2196337 defendant Knapton John   587727 587727 Knapton, John, of Pykeryng 0
4525607 2208324 2208324 defendant Apylton John   587727 587727 Apylton, John, of Pykeryng 3
4525608 2208324 2208324 defendant Gerstan Robert   587727 587727 Gerstan, Robert, of Pykeryng 4
4548719 2215538 2215538 defendant Appilton John   587727 587727 Appilton, John, of Pykeryng 0
4548720 2215538 2215538 defendant Garston Robert   587727 587727 Garston, Robert, of Pykeryng 1
4564848 2220570 2220570 defendant Wake John   587727 587727 Wake, John, of Pykeryng 8
4564849 2220570 2220570 defendant Webster John   587727 587727 Webster, John, of Pykeryng 9
4564850 2220570 2220570 defendant Halgarth John   587727 587727 Halgarth, John, of Pykeryng 10
4642476 2243922 2243922 defendant Neweton John de   587727 587727 Neweton, John de, of Pykeryng 0
4642478 2243923 2243923 defendant Neweton John de   587727 587727 Neweton, John de, of Pykeryng 0
4654026 2247142 2247142 defendant de Kelde John yeoman 587727 587727 de Kelde, John, of Pykeryng, yeoman 0
4655194 2247508 2247508 defendant Barum Thomas husbandman 587727 587727 Barum, Thomas, of Pykeryng, husbandman 3
4668267 2255789 2255789 defendant Kirkeham John de husbandman 587727 587727 Kirkeham, John de, of Pykeryng, husbandman 0
4675184 2257850 2257850 defendant Dobson Alan husbandman 587727 587727 Dobson, Alan, of Pykeryng, husbandman 0
4677594 2258606 2258606 defendant Broun Thomas husbandman 587727 587727 Broun, Thomas, of Pykeryng, husbandman 0
4679580 2259230 2259230 plaintiff Kirkham John   587727 587727 Kirkham, John, of Pykeryng 0
4679582 2259231 2259231 plaintiff Kirkham John   587727 587727 Kirkham, John, of Pykeryng 0
4681783 2259914 2259914 defendant Fenrether John smith 587727 587727 Fenrether, John, of Pykeryng, smith 3
4685852 2261165 2261165 defendant Rouclyff Margery   587727 587727 Rouclyff, Margery, of Pykeryng, widow & formerly wife of David Rouclyff, knight 3
4711210 2268858 2268858 defendant Broun John chapman 587727 587727 Broun, John, of Pykeryng, chapman 0
4711500 2268927 2268927 plaintiff Ryton William   587727 587727 Ryton, William, of Pykeryng 0
4737426 2276820 2276820 plaintiff Upsall Robert   587727 587727 Upsall, Robert, of Pykeryng 0
4755807 2282199 2282199 plaintiff Barker Richard   587727 587727 Barker, Richard, of Pykeryng 0
4755808 2282199 2282199 defendant Scardeburgh John   587727 587727 Scardeburgh, John, of Pykeryng 0
4774474 2288001 2288001 plaintiff Walas John (legal representative) 587727 587727 Walas, John, of Pykeryng, vicar, executors of 0
4776138 2288535 2288535 defendant Day John husbandman 587727 587727 Day, John, of Pykeryng, husbandman 0
4784524 2291164 2291164 defendant Gygard Thomas husbandman 587727 587727 Gygard, Thomas, of Pykeryng, husbandman 0
4805487 2297927 2297927 plaintiff Bruys Alice   587727 587727 Bruys, Alice, of Pykeryng, formerly wife of William Bruys 0
4881214 2321029 2321029 defendant Hogeson John, senior husbandman 587727 587727 Hogeson, John, senior, of Pykeryng, husbandman 0
4893145 2324572 2324572 defendant Chymney Richard yeoman 587727 587727 Chymney, Richard, of Pykeryng, yeoman 0
4904420 2327996 2327996 defendant Kynge John yeoman 587727 587727 Kynge, John, of Pykeryng, yeoman 1
4928380 2335299 2335299 defendant Clay John yeoman 587727 587727 Clay, John, of Pykeryng, yeoman 2
4928381 2335299 2335299 defendant Mere Thomas yeoman 587727 587727 Mere, Thomas, of Pykeryng, yeoman 3
4928382 2335299 2335299 defendant Boweman John yeoman 587727 587727 Boweman, John, of Pykeryng, yeoman 4
4928384 2335299 2335299 defendant Wright John yeoman 587727 587727 Wright, John, of Pykeryng, yeoman 6
4928385 2335299 2335299 defendant Cook Thomas yeoman 587727 587727 Cook, Thomas, of Pykeryng, yeoman 7
4940375 2339012 2339012 defendant Burton Richard chaplain 587727 587727 Burton, Richard, of Pykeryng, chaplain 0
4941580 2339386 2339386 defendant Middelton John esq 587727 587727 Middelton, John, of Pykeryng, esq 0
4944082 2340117 2340117 defendant Chestre John yeoman 587727 587727 Chestre, John, of Pykeryng, yeoman 0
4944505 2340260 2340260 defendant Day Thomas yeoman 587727 587727 Day, Thomas, of Pykeryng, yeoman 0
4959335 2344759 2344759 defendant Lasselles John gent 587727 587727 Lasselles, John, of Pykeryng, gent 0
4967379 2347184 2347184 defendant Middelton John esq 587727 587727 Middelton, John, of Pykeryng, esq 0
4967381 2347185 2347185 defendant Middilton John esq 587727 587727 Middilton, John, of Pykeryng, esq 0
5012817 2360582 2360582 defendant Kyrkham Thomas esq 587727 587727 Kyrkham, Thomas, of Pykeryng, esq 0
5013756 2360868 2360868 defendant Barbour William yeoman 587727 587727 Barbour, William, of Pykeryng, yeoman 0
5047670 2370920 2370920 defendant Clay Christopher gent 587727 587727 Clay, Christopher, of Pykeryng, gent 0
5103712 2387511 2387511 defendant Wode Henry miller 587727 587727 Wode, Henry, of Pykeryng, miller 0
5103713 2387511 2387511 defendant Wode John miller 587727 587727 Wode, John, of Pykeryng, miller 1
5103910 2387570 2387570 defendant Dey John yeoman 587727 587727 Dey, John, of Pykeryng, yeoman 0
5103911 2387570 2387570 defendant Oxford Thomas yeoman 587727 587727 Oxford, Thomas, of Pykeryng, yeoman 1
5103913 2387570 2387570 defendant Eston Robert smith 587727 587727 Eston, Robert, of Pykeryng, smith 3
5103914 2387570 2387570 defendant Marchall William yeoman 587727 587727 Marchall, William, of Pykeryng, yeoman 4
5103915 2387570 2387570 defendant Dey Thomas laborer 587727 587727 Dey, Thomas, of Pykeryng, laborer 5
5106440 2388317 2388317 defendant Hovyngton Robert yeoman 587727 587727 Hovyngton, Robert, of Pykeryng, yeoman 0
5106441 2388317 2388317 defendant Oxenford Thomas yeoman 587727 587727 Oxenford, Thomas, of Pykeryng, yeoman 1
5106442 2388317 2388317 defendant Walker John yeoman 587727 587727 Walker, John, of Pykeryng, yeoman 2
5127006 2394377 2394377 defendant West William forester 587727 587727 West, William, of Pykeryng, forester 2
5149859 2401091 2401091 defendant Hall John shoemaker 587727 587727 Hall, John, of Pykeryng, shoemaker 8
5149860 2401091 2401091 defendant West William forester 587727 587727 West, William, of Pykeryng, forester 9
5149861 2401091 2401091 defendant Colt John sawyer 587727 587727 Colt, John, of Pykeryng, sawyer 10
5149862 2401091 2401091 defendant Dodmor Henry laborer 587727 587727 Dodmor, Henry, of Pykeryng, laborer 11
5222853 2422396 2422396 defendant Coltherd Thomas butcher 587727 587727 Coltherd, Thomas, of Pykeryng, butcher 0
5232562 2425101 2425101 defendant Pepyr Thomas clerk 587727 587727 (Pepyr, Thomas, of Pykeryng, clerk 2
5301469 2445393 2445393 plaintiff Percy Ralph   587727 587727 Percy, Ralph, of Pykeryng 2
5536745 2515978 2515978 defendant Peghan Christopher gent 587727 587727 Peghan, Christopher, of Pykeryng, gent 0
5617962 2549432 2549432 plaintiff Malton William de   587727 587727 Malton, William de, of Pykeryng 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);