names

156 rows where place_id = 591199

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3603694 1868826 1868826 defendant Whelewright John miller 591199 591199 Whelewright, John, of Poklyngton, miller 0
3628910 1903920 1903920 defendant Langthorp Richard yeoman 591199 591199 Langthorp, Richard, of Poklyngton, yeoman 1
3716217 1931365 1931365 defendant at Esshe William (legal representative) 591199 591199 at Esshe, William, of Poklyngton, gent, executors of 1
3716218 1931365 1931365 defendant Wilberforsse Robert gent 591199 591199 (Wilberforsse, Robert, of Poklyngton, gent 2
3716219 1931365 1931365 defendant at Esshe Margaret widow 591199 591199 at Esshe, Margaret, of Poklyngton, widow 3
3808677 1960595 1960595 defendant Dobson or Douson Isabel widow 591199 591199 (Dobson or Douson, Isabel, of Poklyngton, widow 1
3832640 1968136 1968136 defendant Legh Thomas yeoman 591199 591199 Legh, Thomas, of Poklyngton, yeoman 0
3832641 1968136 1968136 defendant Nycholson John yeoman 591199 591199 Nycholson, John, of Poklyngton, yeoman 1
3837666 1969691 1969691 defendant Thomson Robert cooper 591199 591199 Thomson, Robert, of Poklyngton, cooper 3
3852268 1974309 1974309 defendant Reynard John tanner 591199 591199 Reynard, John, of Poklyngton, tanner 0
3912797 1994612 1994612 defendant Dobson Richard yeoman 591199 591199 Dobson, Richard, of Poklyngton, yeoman 0
4461496 2188675 2188675 defendant Wartere Nicholas de (legal representative) 591199 591199 Wartere, Nicholas de, of Poklyngton, administrator of 1
4510670 2203794 2203794 defendant Mody Richard   591199 591199 Mody, Richard, of Poklyngton 2
4520450 2206740 2206740 defendant Gayergh William   591199 591199 Gayergh, William, of Poklyngton 0
4539408 2212584 2212584 defendant Westward Robert   591199 591199 Westward, Robert, of Poklyngton 1
4539409 2212584 2212584 defendant atte Crosse Geoffrey   591199 591199 atte Crosse, Geoffrey, of Poklyngton 2
4539413 2212584 2212584 defendant Ottryngton Thomas de   591199 591199 Ottryngton,Thomas de, of Poklyngton, vicar 6
4615043 2235718 2235718 defendant Hoton John   591199 591199 Hoton, John, of Poklyngton 1
4663034 2249904 2249904 defendant Lyster John dyer 591199 591199 Lyster, John, of Poklyngton, dyer 3
4685724 2261124 2261124 defendant Esyngwald Walter husbandman 591199 591199 Esyngwald, Walter, of Poklyngton, husbandman 1
4688006 2261819 2261819 defendant Fenton John husbandman 591199 591199 Fenton, John, of Poklyngton, husbandman 0
4695986 2264231 2264231 defendant Smyth William yeoman 591199 591199 Smyth, William, of Poklyngton, yeoman 1
4700918 2265690 2265690 defendant Couper Robert cooper 591199 591199 Couper, Robert, of Poklyngton, cooper 3
4711656 2268970 2268970 defendant Esyngwold Walter husbandman 591199 591199 Esyngwold, Walter, of Poklyngton, husbandman 1
4727228 2273776 2273776 defendant Fenton William gent 591199 591199 Fenton, William, of Poklyngton, gent 0
4730125 2274623 2274623 defendant Bridle William weaver 591199 591199 Bridle, William, of Poklyngton, weaver 0
4736188 2276453 2276453 defendant Gowrd Richard husbandman 591199 591199 Gowrd, Richard, of Poklyngton, husbandman 0
4762201 2284157 2284157 defendant Waleys William   591199 591199 Waleys, William, of Poklyngton, shoe maker 0
4763529 2284575 2284575 defendant Walys William   591199 591199 Walys, William, of Poklyngton, shoe maker 0
4764419 2284859 2284859 defendant Karleile John yeoman 591199 591199 Karleile, John, of Poklyngton, yeoman 1
4823467 2303428 2303428 defendant Crake John chapman 591199 591199 Crake, John, of Poklyngton, chapman 0
4867288 2316733 2316733 defendant Wales William, senior cordwainer 591199 591199 Wales, William, senior, of Poklyngton, cordwainer 2
4867944 2316943 2316943 defendant Crayke William courser 591199 591199 Crayke, William, of Poklyngton, courser 0
4898543 2326190 2326190 defendant Harpham Thomas butcher 591199 591199 Harpham, Thomas, of Poklyngton, butcher 4
4903229 2327618 2327618 defendant Dobson William yeoman 591199 591199 Dobson, William, of Poklyngton, yeoman 0
4932389 2336524 2336524 defendant Frencheman John fuller 591199 591199 Frencheman, John, of Poklyngton, fuller 1
4989454 2353781 2353781 defendant Oustby Thomas   591199 591199 Oustby, Thomas, of Poklyngton 3
4989825 2353873 2353873 defendant Custby Thomas   591199 591199 Custby, Thomas, of Poklyngton 3
4995140 2355400 2355400 defendant Oustby Thomas   591199 591199 Oustby, Thomas, of Poklyngton 3
5002178 2357541 2357541 defendant Oustby Thomas   591199 591199 Oustby, Thomas, of Poklyngton 3
5003061 2357799 2357799 defendant Oustby Thomas   591199 591199 Oustby, Thomas, of Poklyngton 3
5003789 2357998 2357998 defendant Oustby Thomas   591199 591199 Oustby, Thomas, of Poklyngton 3
5004869 2358322 2358322 defendant Oustby Thomas   591199 591199 Oustby, Thomas, of Poklyngton 3
5013991 2360950 2360950 defendant Wilton Peter   591199 591199 Wilton, Peter, of Poklyngton 0
5013992 2360950 2360950 defendant Eland Thomas   591199 591199 Eland, Thomas, of Poklyngton 1
5013995 2360950 2360950 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 4
5013996 2360950 2360950 defendant Spencer John   591199 591199 Spencer, John, of Poklyngton 5
5013998 2360951 2360951 defendant Wilton Peter   591199 591199 Wilton, Peter, of Poklyngton 0
5013999 2360951 2360951 defendant Eland Thomas   591199 591199 Eland, Thomas, of Poklyngton 1
5014002 2360951 2360951 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 4
5014003 2360951 2360951 defendant Spenser John   591199 591199 Spenser, John, of Poklyngton 5
5014005 2360952 2360952 defendant Wylton Peter   591199 591199 Wylton, Peter, of Poklyngton 0
5014006 2360952 2360952 defendant Eland Thomas   591199 591199 Eland, Thomas, of Poklyngton 1
5014009 2360952 2360952 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 4
5014010 2360952 2360952 defendant Spencer John   591199 591199 Spencer, John, of Poklyngton 5
5014012 2360953 2360953 defendant Wylton Peter   591199 591199 Wylton, Peter, of Poklyngton 0
5014013 2360953 2360953 defendant Eland Thomas   591199 591199 Eland, Thomas, of Poklyngton 1
5014016 2360953 2360953 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 4
5014017 2360953 2360953 defendant Spencer John   591199 591199 Spencer, John, of Poklyngton 5
5014441 2361089 2361089 defendant Wilton Peter   591199 591199 Wilton, Peter, of Poklyngton 0
5014442 2361089 2361089 defendant Eland Thomas   591199 591199 Eland, Thomas, of Poklyngton 1
5014445 2361089 2361089 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 4
5014446 2361089 2361089 defendant Spenser John   591199 591199 Spenser, John, of Poklyngton 5
5014448 2361090 2361090 defendant Wilton Peter   591199 591199 Wilton, Peter, of Poklyngton 0
5014449 2361090 2361090 defendant Eland Thomas   591199 591199 Eland, Thomas, of Poklyngton 1
5014452 2361090 2361090 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 4
5014453 2361090 2361090 defendant Spenser John   591199 591199 Spenser, John, of Poklyngton 5
5014455 2361091 2361091 defendant Wylton Peter   591199 591199 Wylton, Peter, of Poklyngton 0
5014456 2361091 2361091 defendant Eland Thomas   591199 591199 Eland, Thomas, of Poklyngton 1
5014459 2361091 2361091 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 4
5014460 2361091 2361091 defendant Spencer John   591199 591199 Spencer, John, of Poklyngton 5
5014462 2361092 2361092 defendant Wylton Peter   591199 591199 Wylton, Peter, of Poklyngton 0
5014463 2361092 2361092 defendant Eland Thomas   591199 591199 Eland, Thomas, of Poklyngton 1
5014466 2361092 2361092 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 4
5014467 2361092 2361092 defendant Spencer John   591199 591199 Spencer, John, of Poklyngton 5
5022907 2363614 2363614 defendant Wilton Peter   591199 591199 Wilton, Peter, of Poklyngton 0
5022908 2363614 2363614 defendant Eland Thomas   591199 591199 Eland, Thomas, of Poklyngton 1
5022911 2363614 2363614 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 4
5022912 2363614 2363614 defendant Spenser John   591199 591199 Spenser, John, of Poklyngton 5
5022914 2363615 2363615 defendant Wylton Peter   591199 591199 Wylton, Peter, of Poklyngton 0
5022915 2363615 2363615 defendant Eland Thomas   591199 591199 Eland, Thomas, of Poklyngton 1
5022918 2363615 2363615 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 4
5022919 2363615 2363615 defendant Spencer John   591199 591199 Spencer, John, of Poklyngton 5
5022921 2363616 2363616 defendant Wylton Peter   591199 591199 Wylton, Peter, of Poklyngton 0
5022922 2363616 2363616 defendant Eland Thomas   591199 591199 Eland, Thomas, of Poklyngton 1
5022925 2363616 2363616 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 4
5022926 2363616 2363616 defendant Spencer John   591199 591199 Spencer, John, of Poklyngton 5
5022928 2363617 2363617 defendant Wilton Peter   591199 591199 Wilton, Peter, of Poklyngton 0
5022929 2363617 2363617 defendant Eland Thomas   591199 591199 Eland, Thomas, of Poklyngton 1
5022932 2363617 2363617 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 4
5022933 2363617 2363617 defendant Spenser John   591199 591199 Spenser, John, of Poklyngton 5
5053541 2372662 2372662 defendant Wylton Peter   591199 591199 Wylton, Peter, of Poklyngton 0
5053542 2372662 2372662 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 1
5053543 2372662 2372662 defendant Spencer John   591199 591199 Spencer, John, of Poklyngton 2
5053545 2372663 2372663 defendant Wylton Peter   591199 591199 Wylton, Peter, of Poklyngton 0
5053546 2372663 2372663 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 1
5053547 2372663 2372663 defendant Spencer John   591199 591199 Spencer, John, of Poklyngton 2
5076544 2379489 2379489 defendant Wilton Peter   591199 591199 Wilton, Peter, of Poklyngton 0
5076545 2379489 2379489 defendant Patoner William   591199 591199 Patoner, William, of Poklyngton 1
5076546 2379489 2379489 defendant Spencer John   591199 591199 Spencer, John, of Poklyngton 2

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