names

121 rows where place_id = 599193

✎ 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
3635667 1905956 1905956 defendant Hardgrave John gent 599193 599193 Hardgrave, John, of Bolyngbroke, gent 0
3635668 1905956 1905956 defendant Uncle John gent 599193 599193 Uncle, John, of Bolyngbroke, gent 1
3635669 1905956 1905956 defendant Hawburgh John husbandman 599193 599193 Hawburgh, John, of Bolyngbroke, husbandman 2
3635670 1905956 1905956 defendant Mylner Thomas laborer 599193 599193 Mylner, Thomas, of Bolyngbroke, laborer 3
3635671 1905956 1905956 defendant Brewer John laborer 599193 599193 Brewer, John, of Bolyngbroke, laborer 4
3635673 1905957 1905957 defendant Hardgrave John gent 599193 599193 Hardgrave, John, of Bolyngbroke, gent 0
3635674 1905957 1905957 defendant Uncle John gent 599193 599193 Uncle, John, of Bolyngbroke, gent 1
3635675 1905957 1905957 defendant Hawburgh John husbandman 599193 599193 Hawburgh, John, of Bolyngbroke, husbandman 2
3635676 1905957 1905957 defendant Mylner Thomas laborer 599193 599193 Mylner, Thomas, of Bolyngbroke, laborer 3
3635677 1905957 1905957 defendant Brewer John laborer 599193 599193 Brewer, John, of Bolyngbroke, laborer 4
3672047 1917259 1917259 defendant Grene Robert weaver 599193 599193 Grene, Robert, of Bolyngbroke, weaver 0
3672048 1917259 1917259 defendant Burges William shoemaker 599193 599193 Burges, William, of Bolyngbroke, shoemaker 1
3672049 1917259 1917259 defendant Metcalff John shoemaker 599193 599193 Metcalff, John, of Bolyngbroke, shoemaker 2
3672051 1917260 1917260 defendant Meucalf John shoemaker 599193 599193 Meucalf, John, of Bolyngbroke, shoemaker 0
3672052 1917260 1917260 defendant Grene Robert weaver 599193 599193 Grene, Robert, of Bolyngbroke, weaver 1
3672053 1917260 1917260 defendant Burges William shoemaker 599193 599193 Burges, William, of Bolyngbroke, shoemaker 2
3677936 1919145 1919145 defendant Dyconson Robert yeoman 599193 599193 Dyconson, Robert, of Bolyngbroke, yeoman 1
3677938 1919145 1919145 defendant Cayme Edward yeoman 599193 599193 Cayme, Edward, of Bolyngbroke, yeoman 3
3690347 1923144 1923144 defendant Nelson Christopher butcher 599193 599193 Nelson, Christopher, of Bolyngbroke, butcher 0
3690353 1923145 1923145 defendant Uncle John gent 599193 599193 Uncle, John, of Bolyngbroke, gent 0
3690901 1923318 1923318 defendant Uncle John gent 599193 599193 Uncle, John, of Bolyngbroke, gent 0
3691155 1923397 1923397 plaintiff Hardgrave John gent 599193 599193 Hardgrave, John, of Bolyngbroke, gent 0
3705248 1927927 1927927 defendant Uncle John gent 599193 599193 Uncle, John, of Bolyngbroke, gent 0
3705250 1927928 1927928 defendant Uncle John gent 599193 599193 Uncle, John, of Bolyngbroke, gent 0
3719590 1932392 1932392 defendant Jakson William husbandman 599193 599193 Jakson, William, of Bolyngbroke, husbandman 0
3748149 1941349 1941349 defendant Adlarde John husbandman 599193 599193 Adlarde, John, of Bolyngbroke, husbandman 0
3748665 1941509 1941509 defendant Bowde Richard laborer 599193 599193 Bowde, Richard, of Bolyngbroke, laborer 2
3753255 1942958 1942958 defendant Uncle John gent 599193 599193 Uncle, John, of Bolyngbroke, gent 0
3753736 1943110 1943110 defendant Chambers Thomas smith 599193 599193 Chambers, Thomas, of Bolyngbroke, smith 1
3753737 1943110 1943110 defendant Chambers John laborer 599193 599193 Chambers, John, of Bolyngbroke, laborer 2
3783004 1952435 1952435 defendant Graunger Robert husbandman 599193 599193 Graunger, Robert, of Bolyngbroke, husbandman 0
3798398 1957397 1957397 defendant Mayhewe Thomas merchant of the staple 599193 599193 Mayhewe, Thomas, of Bolyngbroke, merchant of the staple 0
3799563 1957784 1957784 defendant Graunger Robert glover 599193 599193 Graunger, Robert, of Bolyngbroke, glover 0
3799564 1957784 1957784 defendant Graunger Edward thatcher 599193 599193 Graunger, Edward, of Bolyngbroke, thatcher 1
3816205 1962976 1962976 defendant Mighell John glover 599193 599193 Mighell, John, of Bolyngbroke, glover 0
3850284 1973675 1973675 defendant Bryan John merchant of the staple 599193 599193 Bryan, John, of Bolyngbroke, merchant of the staple 1
3850367 1973704 1973704 plaintiff Mighell John glover 599193 599193 Mighell, John, of Bolyngbroke, glover 0
3850711 1973814 1973814 plaintiff Myghell John   599193 599193 Myghell, John, of Bolyngbroke 0
3858845 1976447 1976447 defendant Hogeson Robert butcher 599193 599193 Hogeson, Robert, of Bolyngbroke, butcher 0
3861717 1977382 1977382 defendant Jakson William husbandman 599193 599193 Jakson, William, of Bolyngbroke, husbandman 0
3873021 1981191 1981191 defendant Hennyngham Robert smith 599193 599193 Hennyngham, Robert, of Bolyngbroke, smith 0
3883051 1984598 1984598 plaintiff Uncle John (legal representative) 599193 599193 Uncle, John, of Bolyngbroke, gent, executors of 0
3883060 1984599 1984599 plaintiff Uncle John (legal representative) 599193 599193 Uncle, John, of Bolyngbroke, gent, executors of 0
3911972 1994329 1994329 defendant Gardyner Walter yeoman 599193 599193 Gardyner, Walter, of Bolyngbroke, yeoman 0
3916020 1995744 1995744 defendant Uncle John husbandman 599193 599193 Uncle, John, of Bolyngbroke, husbandman 0
3940018 2003682 2003682 plaintiff Skynner John esq 599193 599193 Skynner, John, of Bolyngbroke, esq 0
3940022 2003682 2003682 defendant Godricke William yeoman 599193 599193 Godricke, William, of Bolyngbroke, yeoman 3
3940023 2003683 2003683 plaintiff Skynner John esq 599193 599193 Skynner, John, of Bolyngbroke, esq 0
3940026 2003683 2003683 defendant Godericke William yeoman 599193 599193 Godericke, William, of Bolyngbroke, yeoman 2
3940028 2003684 2003684 plaintiff Skynner John gent 599193 599193 Skynner, John, of Bolyngbroke, gent 0
3940030 2003684 2003684 defendant Burton Thomas yeoman 599193 599193 Burton, Thomas, of Bolyngbroke, yeoman 1
3972023 2014772 2014772 defendant Goodryck William yeoman 599193 599193 Goodryck, William, of Bolyngbroke, yeoman 3
4016081 2030446 2030446 defendant Bryan John merchant of the staple 599193 599193 Bryan, John, of Bolyngbroke, merchant of the staple 0
4061569 2046536 2046536 defendant Wydall Robert husbandman 599193 599193 Wydall, Robert, of Bolyngbroke, husbandman 0
4061570 2046536 2046536 defendant Harryson Percival husbandman 599193 599193 Harryson, Percival, of Bolyngbroke, husbandman 1
4112459 2064714 2064714 defendant Burton Robert yeoman 599193 599193 Burton, Robert, of Bolyngbroke, yeoman 0
4164632 2083139 2083139 defendant Chamberleyn Francis yeoman 599193 599193 Chamberleyn, Francis, of Bolyngbroke, yeoman 0
4498922 2200301 2200301 defendant Marom John de   599193 599193 Marom, John de, of Bolyngbroke 0
4568570 2221747 2221747 defendant Goderik John   599193 599193 Goderik, John, of bolyngbroke 1
4583301 2226199 2226199 defendant Wakefeld John (legal representative) 599193 599193 Wakefeld, John, of Bolyngbroke, executors of 2
4584478 2226561 2226561 plaintiff Goderyk John   599193 599193 Goderyk, John, of Bolyngbroke 0
4584481 2226562 2226562 plaintiff Goderyk John   599193 599193 Goderyk, John, of Bolyngbroke 0
4584484 2226563 2226563 plaintiff Goderyk John   599193 599193 Goderyk, John, of Bolyngbroke 0
4595689 2229912 2229912 defendant Deryng Richard   599193 599193 Deryng, Richard, of Bolyngbroke 3
4653515 2247033 2247033 defendant Whyte Alice widow of John Whyte 599193 599193 Whyte, Alice, of Bolyngbroke, widow of John Whyte 0
4659249 2248761 2248761 defendant Goderik John husbandman 599193 599193 Goderik, John, of Bolyngbroke, husbandman 0
4659250 2248761 2248761 defendant Stacy Thomas husbandman 599193 599193 Stacy, Thomas, of Bolyngbroke, husbandman 1
4659254 2248761 2248761 defendant Caldewell John husbandman 599193 599193 Caldewell, John, of Bolyngbroke, husbandman 5
4741458 2277997 2277997 defendant Unkyll Thomas husbandman 599193 599193 Unkyll, Thomas, of Bolyngbroke, husbandman 0
4801025 2296510 2296510 defendant Deryng Richard husbandman 599193 599193 Deryng, Richard, of Bolyngbroke, husbandman 0
4830596 2305591 2305591 defendant Brese John laborer 599193 599193 Brese, John, of Bolyngbroke, laborer 0
4838545 2307975 2307975 plaintiff Goodryke William   599193 599193 Goodryke, William, of Bolyngbroke 0
4884660 2322113 2322113 defendant Apull Walter butcher 599193 599193 Apull, Walter, of Bolyngbroke, butcher 0
4944108 2340126 2340126 defendant Pore Thomas husbandman 599193 599193 Pore, Thomas, of Bolyngbroke, husbandman 2
4946876 2341030 2341030 plaintiff Wynfelde Thomas   599193 599193 Wynfelde, Thomas, of Bolyngbroke 1
4987756 2353301 2353301 defendant Gose Thomas merchant 599193 599193 Gose, Thomas, of Bolyngbroke, merchant 0
4987757 2353301 2353301 defendant Gose Thomas butcher 599193 599193 Gose, Thomas, of Bolyngbroke, butcher 1
5002022 2357492 2357492 defendant Kele Thomas   599193 599193 Kele, Thomas, of Bolyngbroke, wright 2
5010367 2359900 2359900 defendant Staynfeld Thomas yeoman 599193 599193 Staynfeld, Thomas, of Bolyngbroke, yeoman 2
5066874 2376620 2376620 defendant Warner Robert yeoman 599193 599193 Warner, Robert, of Bolyngbroke, yeoman 1
5088425 2382990 2382990 defendant Burwell Robert clerk 599193 599193 Burwell, Robert, of Bolyngbroke, clerk 0
5103318 2387400 2387400 defendant Uncle Thomas butcher 599193 599193 Uncle, Thomas, of Bolyngbroke, butcher 4
5121280 2392658 2392658 defendant Appull Walter husbandman 599193 599193 Appull, Walter, of Bolyngbroke, husbandman 0
5125765 2394020 2394020 defendant Apo Richard merchant 599193 599193 Apo, Richard, of Bolyngbroke, merchant 1
5125770 2394021 2394021 defendant Apo Richard   599193 599193 Apo, Richard, of Bolyngbroke 1
5149326 2400936 2400936 defendant Gosse Thomas merchant 599193 599193 Gosse, Thomas, of Bolyngbroke, merchant 0
5168302 2406445 2406445 defendant Gosse Thomas merchant 599193 599193 Gosse, Thomas, of Bolyngbroke, merchant 0
5253283 2431126 2431126 defendant Taillour Robert husbandman 599193 599193 Taillour, Robert, of Bolyngbroke, husbandman 0
5289746 2442006 2442006 defendant Apo Robert merchant 599193 599193 Apo, Robert, of Bolyngbroke, merchant 0
5289747 2442006 2442006 defendant Unkell Thgomas merchant 599193 599193 Unkell, Thgomas, of Bolyngbroke, merchant 1
5306851 2447047 2447047 defendant Apoo Walter merchant 599193 599193 Apoo, Walter, of Bolyngbroke, merchant 0
5333154 2454984 2454984 defendant Apoo Robert merchant 599193 599193 Apoo, Robert, of Bolyngbroke, merchant 0
5333159 2454984 2454984 defendant Apoo Joan widow 599193 599193 Apoo, Joan, of Bolyngbroke, widow 5
5341847 2457644 2457644 defendant Davy William husbandman 599193 599193 Davy, William, of Bolyngbroke, husbandman 0
5352576 2460902 2460902 defendant Uncle Thomas, senior merchant 599193 599193 Uncle, Thomas, senior, of Bolyngbroke, merchant 0
5354050 2461329 2461329 defendant Dane John husbandman 599193 599193 Dane, John, of Bolyngbroke, husbandman 1
5357364 2462370 2462370 defendant Pycard Richard husbandman 599193 599193 Pycard, Richard, of Bolyngbroke, husbandman 0
5359643 2463052 2463052 defendant Goderyk John   599193 599193 Goderyk, John, of Bolyngbroke 0
5362501 2463923 2463923 defendant Unkell Thomas, senior merchant 599193 599193 Unkell, Thomas, senior, of Bolyngbroke, merchant 1
5362502 2463923 2463923 defendant Apo Walter (legal representative) 599193 599193 Apo, Walter, of Bolyngbroke, executrix of 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);