names

94 rows where place_id = 589895

✎ 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
3599145 1867368 1867368 defendant Combe Thomas husbandman 589895 589895 Combe, Thomas, of Edelmeton, husbandman 2
3599995 1867651 1867651 defendant Abotre William yeoman 589895 589895 Abotre, William, of Edelmeton, yeoman 4
3612183 1871453 1871453 defendant Beweres John maltman 589895 589895 Beweres, John, of Edelmeton, maltman 7
3617497 1873093 1873093 plaintiff Fox Richard maltman 589895 589895 Fox, Richard, of Edelmeton, maltman 0
3617498 1873093 1873093 defendant Burnewode Thomas yeoman 589895 589895 Burnewode, Thomas, of Edelmeton, yeoman 0
3633561 1905307 1905307 defendant Stevynson John husbandman 589895 589895 Stevynson, John, of Edelmeton, husbandman 1
3633757 1905371 1905371 plaintiff Leeke John (legal representative) 589895 589895 Leeke, John, of Edelmeton, gent, executors of 0
3671120 1916935 1916935 defendant Fox Richard yeoman 589895 589895 Fox, Richard, of Edelmeton, yeoman 0
3671122 1916936 1916936 defendant Fox Richard yeoman 589895 589895 Fox, Richard, of Edelmeton, yeoman 0
3671124 1916937 1916937 defendant Fox Richard yeoman 589895 589895 Fox, Richard, of Edelmeton, yeoman 0
3677000 1918844 1918844 defendant Byrnham George gent 589895 589895 Byrnham, George, of Edelmeton, gent 0
3696012 1924992 1924992 defendant Bone Nicholas (legal representative) 589895 589895 Bone, Nicholas, of Edelmeton, gent, executrix of 2
3712957 1930376 1930376 defendant Peter John husbandman 589895 589895 Peter, John, of Edelmeton, husbandman 0
3712958 1930376 1930376 defendant Cordell John laborer 589895 589895 Cordell, John, of Edelmeton, laborer 1
3784422 1952910 1952910 defendant Walys Robert gent 589895 589895 Walys, Robert, of Edelmeton, gent 0
3784423 1952910 1952910 defendant Dan Robert husbandman 589895 589895 Dan, Robert, of Edelmeton, husbandman 1
3784424 1952910 1952910 defendant Osborne Thomas husbandman 589895 589895 Osborne, Thomas, of Edelmeton, husbandman 2
3798810 1957542 1957542 defendant Byrde John butcher 589895 589895 Byrde, John, of Edelmeton, butcher 0
3816257 1962993 1962993 defendant Parke John husbandman 589895 589895 Parke, John, of Edelmeton, husbandman 0
3818433 1963663 1963663 defendant Walys Robert gent 589895 589895 Walys, Robert, of Edelmeton, gent 0
3822296 1964880 1964880 defendant Grey John yeoman 589895 589895 Grey, John, of Edelmeton, yeoman 0
3822297 1964880 1964880 defendant Waren John sawyer 589895 589895 Waren, John, of Edelmeton, sawyer 1
3822298 1964880 1964880 defendant Waberlet John painter 589895 589895 Waberlet, John, of Edelmeton, painter 2
3822299 1964880 1964880 defendant Hasylbere Henry husbandman 589895 589895 Hasylbere, Henry, of Edelmeton, husbandman 3
3822300 1964880 1964880 defendant Haryson John shoemaker 589895 589895 Haryson, John, of Edelmeton, shoemaker 4
3822301 1964880 1964880 defendant Bowne Beda yeoman 589895 589895 Bowne, Beda, of Edelmeton, yeoman 5
3822302 1964880 1964880 defendant Howell Richard laborer 589895 589895 Howell, Richard, of Edelmeton, laborer 6
3835149 1968934 1968934 defendant Hasbery Henry yeoman 589895 589895 Hasbery, Henry, of Edelmeton, yeoman 0
3882518 1984419 1984419 plaintiff Tebbe Thomas tanner 589895 589895 Tebbe, Thomas, of Edelmeton, tanner 0
3882519 1984419 1984419 defendant Harryson John cordwainer 589895 589895 Harryson, John, of Edelmeton, cordwainer 0
3884193 1984979 1984979 defendant Lorkyn John brewer 589895 589895 Lorkyn, John, of Edelmeton, brewer 0
3884194 1984979 1984979 defendant Tylly Henry laborer 589895 589895 Tylly, Henry, of Edelmeton, laborer 1
3898591 1989736 1989736 defendant Denys William husbandman 589895 589895 Denys, William, of Edelmeton, husbandman 0
3958347 2009992 2009992 defendant Leeke Roger gent 589895 589895 Leeke, Roger, of Edelmeton, gent 1
3960594 2010807 2010807 defendant Leeke Roger gent 589895 589895 Leeke, Roger, of Edelmeton, gent 1
4264734 2117847 2117847 defendant Rice John yeoman 589895 589895 Rice, John, of Edelmeton, yeoman 1
4436355 2176106 2176106 defendant Basse Thomas   589895 589895 Basse, Thomas, of Edelmeton 1
4501459 2201058 2201058 defendant Mountfort Thomas   589895 589895 Mountfort, Thomas, of Edelmeton 1
4632756 2241130 2241130 defendant Pynne Thomas   589895 589895 Pynne, Thomas, of Edelmeton 0
4646445 2245024 2245024 defendant Bledwyn John   589895 589895 Bledwyn, John, of Edelmeton 1
4646446 2245024 2245024 defendant Larke John   589895 589895 Larke, John, of Edelmeton 2
4646451 2245025 2245025 defendant Bledwyn John   589895 589895 Bledwyn, John, of Edelmeton 1
4646452 2245025 2245025 defendant Larke John   589895 589895 Larke, John, of Edelmeton 2
4654235 2247205 2247205 plaintiff Bledewyn John   589895 589895 Bledewyn, John, of Edelmeton 0
4654494 2247281 2247281 plaintiff Bole John   589895 589895 Bole, John, of Edelmeton 0
4811304 2299645 2299645 plaintiff Fuller John, junior husbandman 589895 589895 Fuller, John, junior, of Edelmeton, husbandman 0
4832692 2306243 2306243 defendant Fox Thomas carpenter 589895 589895 Fox, Thomas, of Edelmeton, carpenter 0
4867690 2316865 2316865 defendant Yonge Simon collier 589895 589895 Yonge, Simon, of Edelmeton, collier 0
4881101 2320997 2320997 defendant Dalamere Peter barber 589895 589895 Dalamere, Peter, of Edelmeton, barber 4
4914669 2331107 2331107 plaintiff Danyell John   589895 589895 Danyell, John, of Edelmeton, on his own account 0
5061184 2374925 2374925 defendant Preston John husbandman 589895 589895 Preston, John, of Edelmeton, husbandman 2
5129933 2395245 2395245 defendant Langford Richard   589895 589895 Langford, Richard, of Edelmeton, malt man 0
5161771 2404547 2404547 defendant Lyncolne Robert   589895 589895 Lyncolne, Robert, of Edelmeton, groom 0
5224970 2422974 2422974 defendant Penyngton James husbandman 589895 589895 Penyngton, James, of Edelmeton, husbandman 0
5256781 2432244 2432244 defendant Pope Thomas yeoman 589895 589895 Pope, Thomas, of Edelmeton, yeoman 0
5303396 2446011 2446011 defendant Turk John maltman 589895 589895 Turk, John, of Edelmeton, maltman 0
5328166 2453497 2453497 defendant Lawe Henry husbandman 589895 589895 Lawe, Henry, of Edelmeton, husbandman 1
5328167 2453497 2453497 defendant Warde John maltman 589895 589895 Warde, John, of Edelmeton, maltman 2
5328168 2453497 2453497 defendant Campe William maltman 589895 589895 Campe, William, of Edelmeton, maltman 3
5328169 2453497 2453497 defendant Dardys John brewer 589895 589895 Dardys, John, of Edelmeton, brewer 4
5329615 2453928 2453928 plaintiff Ayleward Thomas, junior maltman 589895 589895 Ayleward, Thomas, junior, of Edelmeton, maltman 0
5332690 2454846 2454846 defendant Combe William yeoman 589895 589895 Combe, William, of Edelmeton, yeoman 1
5345384 2458729 2458729 defendant Lawe Henry husbandman 589895 589895 Lawe, Henry, of Edelmeton, husbandman 1
5345385 2458729 2458729 defendant Page William maltman 589895 589895 Page, William, of Edelmeton, maltman 2
5345386 2458729 2458729 defendant Warde John maltman 589895 589895 Warde, John, of Edelmeton, maltman 3
5361741 2463701 2463701 defendant Laurens Alexander husbandman 589895 589895 Laurens, Alexander, of Edelmeton, husbandman 0
5394349 2473451 2473451 defendant Hastyng Nicholas shoemaker 589895 589895 Hastyng, Nicholas, of Edelmeton, shoemaker 2
5394421 2473468 2473468 defendant Wyght William husbandman 589895 589895 Wyght, William, of Edelmeton, husbandman 3
5394422 2473468 2473468 defendant Manstr Reginald collier 589895 589895 Manstr, Reginald, of Edelmeton, collier 4
5408376 2477476 2477476 defendant Vernoun William   589895 589895 Vernoun, William, of Edelmeton 0
5421025 2481220 2481220 defendant Banke Henry baker 589895 589895 Banke, Henry, of Edelmeton, baker 0
5421027 2481220 2481220 defendant Wete William husbandman 589895 589895 Wete, William, of Edelmeton, husbandman 2
5440200 2486969 2486969 defendant Banke Henry baker 589895 589895 Banke, Henry, of Edelmeton, baker 0
5440202 2486969 2486969 defendant Wete William husbandman 589895 589895 Wete, William, of Edelmeton, husbandman 2
5440204 2486970 2486970 defendant Banke Henry baker 589895 589895 Banke, Henry, of Edelmeton, baker 0
5440206 2486970 2486970 defendant Whete William husbandman 589895 589895 Whete, William, of Edelmeton, husbandman 2
5440209 2486971 2486971 defendant Wete William husbandman 589895 589895 Wete, William, of Edelmeton, husbandman 1
5478642 2498640 2498640 defendant Manser Reginald husbandman 589895 589895 Manser, Reginald, of Edelmeton, husbandman 0
5487994 2501299 2501299 defendant Manser Reginald husbandman 589895 589895 Manser, Reginald, of Edelmeton, husbandman 0
5488592 2501472 2501472 plaintiff William Thomas gent 589895 589895 William, Thomas, of Edelmeton, gent 0
5488598 2501474 2501474 plaintiff Williams Thomas gent 589895 589895 Williams, Thomas, of Edelmeton, gent 0
5501022 2505254 2505254 plaintiff Skynne Richard husbandman 589895 589895 Skynne, Richard, of Edelmeton, husbandman 0
5501023 2505254 2505254 plaintiff Bowcer William laborer 589895 589895 Bowcer, William, of Edelmeton, laborer 1
5522093 2511727 2511727 defendant Gunston Richard yeoman 589895 589895 Gunston, Richard, of Edelmeton, yeoman 0
5522099 2511727 2511727 defendant Masse William maltman 589895 589895 Masse, William, of Edelmeton, maltman 6
5525253 2512492 2512492 defendant Gunston Richard yeoman 589895 589895 Gunston, Richard, of Edelmeton, yeoman 0
5526165 2512756 2512756 defendant Manser Reginald husbandman 589895 589895 Manser, Reginald, of Edelmeton, husbandman 1
5567822 2525168 2525168 defendant Boterell Thomas yeoman 589895 589895 Boterell, Thomas, of Edelmeton, yeoman 0
5578498 2528345 2528345 defendant Leeke Jasper gent 589895 589895 (Leeke, Jasper, of Edelmeton, gent 1
5578499 2528345 2528345 defendant Broun John clerk 589895 589895 Broun, John, of Edelmeton, clerk 2
5578500 2528345 2528345 defendant Kyrton John gent 589895 589895 Kyrton, John, of Edelmeton, gent 3
5586392 2530787 2530787 plaintiff Leeke John (legal representative) 589895 589895 Leeke, John, of Edelmeton, executors of 0
5586397 2530788 2530788 plaintiff Leeke John (legal representative) 589895 589895 Leeke, John, of Edelmeton, executors of 0
5586405 2530789 2530789 plaintiff Leeke John (legal representative) 589895 589895 Leeke, John, of Edelmeton, executors of 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);