names

111 rows where place_id = 610443

✎ 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
3683555 1920989 1920989 defendant Turpyn Richard yeoman 610443 610443 Turpyn, Richard, of Pokelyngton, yeoman 1
3683556 1920989 1920989 defendant Preston John yeoman 610443 610443 Preston, John, of Pokelyngton, yeoman 2
3919392 1996815 1996815 defendant Smyth William yeoman 610443 610443 Smyth, William, of Pokelyngton, yeoman 0
4425320 2172746 2172746 defendant Child John, junior   610443 610443 Child, John, junior, of Pokelyngton 1
4426940 2173247 2173247 defendant Berewyk Thomas de   610443 610443 Berewyk, Thomas de, of Pokelyngton 0
4430544 2174319 2174319 defendant Shephird William   610443 610443 Shephird, William, of Pokelyngton, son of Geoffrey 1
4431711 2174689 2174689 defendant Curteys Richard   610443 610443 Curteys, Richard, of Pokelyngton 1
4435408 2175830 2175830 defendant Hull Robert de   610443 610443 Hull, Robert de, of Pokelyngton 0
4436163 2176049 2176049 defendant Tirwhit John   610443 610443 Tirwhit, John, of Pokelyngton 7
4468112 2190699 2190699 defendant Hodeleston Robert de   610443 610443 Hodeleston, Robert de, of Pokelyngton 0
4468115 2190699 2190699 defendant Spicer John   610443 610443 Spicer, John, of Pokelyngton 3
4468661 2190870 2190870 defendant atte Esshe John   610443 610443 atte Esshe, John, of Pokelyngton 1
4482583 2195254 2195254 plaintiff Mody Richard   610443 610443 Mody, Richard, of Pokelyngton 0
4504674 2202005 2202005 defendant Chylde William   610443 610443 Chylde, William, of Pokelyngton 0
4511502 2204042 2204042 defendant Bower Simon   610443 610443 Bower, Simon, of Pokelyngton 0
4519030 2206305 2206305 defendant Rogse Henry   610443 610443 Rogse, Henry, of Pokelyngton 1
4539834 2212722 2212722 defendant Barkere William   610443 610443 Barkere, William, of Pokelyngton 1
4539839 2212723 2212723 defendant Barkere William   610443 610443 Barkere, William, of Pokelyngton 1
4550219 2216014 2216014 plaintiff Curteys Richard (legal representative) 610443 610443 Curteys, Richard, of Pokelyngton, executors of 0
4556945 2218101 2218101 defendant Smyth William   610443 610443 Smyth, William, of Pokelyngton 5
4578222 2224685 2224685 plaintiff Chyde William   610443 610443 Chyde, William, of Pokelyngton 0
4585050 2226745 2226745 defendant Gerge William   610443 610443 Gerge, William, of Pokelyngton 0
4587153 2227386 2227386 plaintiff Hosyer John   610443 610443 Hosyer, John, of Pokelyngton 0
4591336 2228647 2228647 defendant Bowyer Simon   610443 610443 Bowyer, Simon, of Pokelyngton 1
4596611 2230175 2230175 defendant Chyld William   610443 610443 Chyld, William, of Pokelyngton 1
4599259 2230982 2230982 plaintiff Storthwayth Thomas   610443 610443 Storthwayth, Thomas, of Pokelyngton 0
4599260 2230982 2230982 defendant Hosyere John   610443 610443 Hosyere, John, of Pokelyngton 0
4599261 2230982 2230982 defendant Hosyere William   610443 610443 Hosyere, William, of Pokelyngton 1
4607275 2233388 2233388 defendant Bower Simon   610443 610443 Bower, Simon, of Pokelyngton 0
4614141 2235432 2235432 defendant Lokton Roger   610443 610443 Lokton, Roger, of Pokelyngton 5
4627943 2239668 2239668 defendant Flesshewer William   610443 610443 Flesshewer, William, of Pokelyngton 2
4637865 2242611 2242611 defendant Swaldale William weaver 610443 610443 Swaldale, William, of Pokelyngton, weaver 1
4637866 2242611 2242611 defendant Dunnyng John   610443 610443 Dunnyng, John, of Pokelyngton 2
4638857 2242889 2242889 plaintiff Child Richard   610443 610443 Child, Richard, of Pokelyngton 0
4645049 2244622 2244622 defendant Bowyere Simon   610443 610443 Bowyere, Simon, of Pokelyngton 1
4660853 2249221 2249221 plaintiff Donceland John   610443 610443 Donceland, John, of Pokelyngton 0
4660855 2249221 2249221 defendant Harward William plumber 610443 610443 Harward, William, of Pokelyngton, plumber 1
4660856 2249221 2249221 defendant atte Gate William turner 610443 610443 atte Gate, William, of Pokelyngton, turner 2
4677754 2258660 2258660 defendant Storthwayte Thoams   610443 610443 Storthwayte, Thoams, of Pokelyngton, franklin 0
4683743 2260517 2260517 defendant Spence Thomas shipman 610443 610443 Spence, Thomas, of Pokelyngton, shipman 0
4685719 2261123 2261123 defendant Esyngwald Walter husbandman 610443 610443 Esyngwald, Walter, of Pokelyngton, husbandman 0
4691452 2262851 2262851 defendant Warde John laborer 610443 610443 Warde, John, of pokelyngton, laborer 0
4732939 2275480 2275480 defendant Chauncy William husbandman 610443 610443 Chauncy, William, of Pokelyngton, husbandman 0
4732940 2275480 2275480 defendant Langeton Robert husbandman 610443 610443 Langeton, Robert, of Pokelyngton, husbandman 1
4739536 2277446 2277446 defendant Lutton John yeoman 610443 610443 Lutton, John, of Pokelyngton, yeoman 1
4750035 2280483 2280483 defendant Harpour Thomas yeoman 610443 610443 Harpour, Thomas, of Pokelyngton, yeoman 4
4756831 2282501 2282501 defendant Hykson William husbandman 610443 610443 Hykson, William, of Pokelyngton, husbandman 0
4756832 2282501 2282501 defendant Walker Thomas yeoman 610443 610443 Walker, Thomas, of Pokelyngton, yeoman 1
4769885 2286553 2286553 defendant Lynehous John yeoman 610443 610443 Lynehous, John, of Pokelyngton, yeoman 2
4769886 2286553 2286553 defendant Rychere William yeoman 610443 610443 Rychere, William, of Pokelyngton, yeoman 3
4769887 2286553 2286553 defendant Harpour Thomas yeoman 610443 610443 Harpour, Thomas, of Pokelyngton, yeoman 4
4790278 2293044 2293044 defendant de Fenton John husbandman 610443 610443 de Fenton, John, of Pokelyngton, husbandman 0
4806876 2298357 2298357 defendant Semer John chapman 610443 610443 Semer, John, of Pokelyngton, chapman 0
4828073 2304823 2304823 defendant G_hand Margaret kempster 610443 610443 G_hand, Margaret, of Pokelyngton, kempster 1
4862601 2315289 2315289 defendant Crake William courser 610443 610443 Crake, William, of Pokelyngton, courser 1
4862604 2315289 2315289 defendant Glover William glover 610443 610443 Glover, William, of Pokelyngton, glover 4
4883210 2321677 2321677 defendant Waltham William butcher 610443 610443 Waltham, William, of Pokelyngton, butcher 0
4883211 2321677 2321677 defendant Birtby William weaver 610443 610443 Birtby, William, of Pokelyngton, weaver 1
4898577 2326200 2326200 defendant Holme Thomas yeoman 610443 610443 Holme, Thomas, of Pokelyngton, yeoman 0
4898578 2326200 2326200 defendant Dene John yeoman 610443 610443 Dene, John, of Pokelyngton, yeoman 1
4900457 2326788 2326788 defendant Crake William courser 610443 610443 Crake, William, of Pokelyngton, courser 4
4911227 2330019 2330019 defendant Colynson Thomas husbandman 610443 610443 Colynson, Thomas, of Pokelyngton, husbandman 6
4924927 2334226 2334226 defendant Waltham John butcher 610443 610443 Waltham, John, of Pokelyngton, butcher 0
4941322 2339310 2339310 defendant Walton John flesshewer or butcher 610443 610443 Walton, John, of Pokelyngton, flesshewer or butcher 4
4956474 2343893 2343893 defendant Taillour John husbandman 610443 610443 Taillour, John, of Pokelyngton, husbandman 1
4961099 2345281 2345281 defendant Chaunce John yeoman 610443 610443 Chaunce, John, of Pokelyngton, yeoman 0
4961930 2345521 2345521 defendant Chaunce John yeoman 610443 610443 Chaunce, John, of Pokelyngton, yeoman 0
4993712 2354992 2354992 defendant Waltham Robert butcher 610443 610443 Waltham, Robert, of Pokelyngton, butcher 1
4993713 2354992 2354992 defendant Waltham John butcher 610443 610443 Waltham, John, of Pokelyngton, butcher 2
4993714 2354992 2354992 defendant Colynson Thomas butcher 610443 610443 Colynson, Thomas, of Pokelyngton, butcher 3
5017398 2361977 2361977 plaintiff Chauncy John yeoman 610443 610443 Chauncy, John, of Pokelyngton, yeoman 0
5017442 2361991 2361991 defendant Burdon John schoolmaster 610443 610443 Burdon, John, of Pokelyngton, schoolmaster 0
5029711 2365560 2365560 plaintiff Owesteby Thomas   610443 610443 Owesteby, Thomas, of Pokelyngton 0
5034622 2366985 2366985 defendant Waltham Robert butcher 610443 610443 Waltham, Robert, of Pokelyngton, butcher 1
5044233 2369905 2369905 defendant Herpham John fisher 610443 610443 Herpham, John, of Pokelyngton, fisher 0
5044234 2369905 2369905 defendant Grene alias Thomson John husbandman 610443 610443 Grene alias Thomson, John, of Pokelyngton, husbandman 1
5047887 2370984 2370984 defendant Wilton William gent 610443 610443 Wilton, William, of Pokelyngton, gent 0
5049888 2371593 2371593 defendant Waltham Robert butcher 610443 610443 Waltham, Robert, of Pokelyngton, butcher 1
5050858 2371874 2371874 defendant Walton Robert butcher 610443 610443 Walton, Robert, of Pokelyngton, butcher 3
5050929 2371892 2371892 defendant Dene John husbandman 610443 610443 Dene, John, of Pokelyngton, husbandman 5
5054114 2372824 2372824 defendant Wylton Peter gent 610443 610443 Wylton, Peter, of Pokelyngton, gent 0
5077289 2379709 2379709 defendant Yole John weaver 610443 610443 Yole, John, of Pokelyngton, weaver 0
5090577 2383625 2383625 defendant Drynkale Joan widow 610443 610443 Drynkale, Joan, of Pokelyngton, widow 2
5090581 2383626 2383626 defendant Drynkale Joan widow 610443 610443 Drynkale, Joan, of Pokelyngton, widow 2
5090585 2383627 2383627 defendant Drynkale Joan widow 610443 610443 Drynkale, Joan, of Pokelyngton, widow 2
5091929 2384019 2384019 defendant Deconson John yeoman 610443 610443 Deconson, John, of Pokelyngton, yeoman 0
5091930 2384019 2384019 defendant Tasker John smith 610443 610443 Tasker, John, of Pokelyngton, smith 1
5111499 2389758 2389758 defendant Gilmyn Richard husbandman 610443 610443 Gilmyn, Richard, of Pokelyngton, husbandman 0
5111500 2389758 2389758 defendant Gilmyn William weaver 610443 610443 Gilmyn, William, of Pokelyngton, weaver 1
5116510 2391262 2391262 defendant Walton John butcher 610443 610443 Walton, John, of Pokelyngton, butcher 0
5116511 2391262 2391262 defendant Taillour John husbandman 610443 610443 Taillour, John, of Pokelyngton, husbandman 1
5116512 2391262 2391262 defendant Asshehors Thomas cooper 610443 610443 Asshehors, Thomas, of Pokelyngton, cooper 2
5122980 2393151 2393151 defendant Patenar William husbandman 610443 610443 Patenar, William, of Pokelyngton, husbandman 0
5122981 2393151 2393151 defendant Dykonson John yeoman 610443 610443 Dykonson, John, of Pokelyngton, yeoman 1
5141935 2398763 2398763 defendant Paternar William husbandman 610443 610443 Paternar, William, of Pokelyngton, husbandman 0
5141936 2398763 2398763 defendant Kykenson John yeoman 610443 610443 Kykenson, John, of Pokelyngton, yeoman 1
5163028 2404914 2404914 defendant Patener William husbandman 610443 610443 Patener, William, of Pokelyngton, husbandman 0
5163029 2404914 2404914 defendant Dykonson John yeoman 610443 610443 Dykonson, John, of Pokelyngton, yeoman 1
5176860 2408922 2408922 defendant Patenar William husbandman 610443 610443 Patenar, William, of Pokelyngton, husbandman 0
5176861 2408922 2408922 defendant Dykonson John yeoman 610443 610443 Dykonson, John, of Pokelyngton, yeoman 1

Next page

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);