names

178 rows where place_id = 600493

✎ 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
3597810 1866933 1866933 plaintiff Scrope John   600493 600493 Scrope, John, of Bolton, knight 0
3609752 1870720 1870720 plaintiff Scrope John   600493 600493 Scrope, John, of Bolton, knight 0
3641238 1907712 1907712 defendant Sheperd Richard yeoman 600493 600493 Sheperd, Richard, of Bolton, yeoman 1
3660641 1913591 1913591 defendant Foster George yeoman 600493 600493 Foster, George, of Bolton, yeoman 0
3663605 1914548 1914548 defendant Sulby George gent 600493 600493 Sulby, George, of Bolton, gent 0
3663606 1914548 1914548 defendant Foulthorp Thomas gent 600493 600493 Foulthorp, Thomas, of Bolton, gent 1
3663608 1914548 1914548 defendant Bowes Reginald yeoman 600493 600493 Bowes, Reginald, of Bolton, yeoman 3
3667323 1915717 1915717 defendant Mekelfeld John gent 600493 600493 Mekelfeld, John, of Bolton, gent 0
3811980 1961655 1961655 defendant Barwyke Robert yeoman 600493 600493 Barwyke, Robert, of Bolton, yeoman 0
3811981 1961655 1961655 defendant Belle John yeoman 600493 600493 Belle, John, of Bolton, yeoman 1
3831099 1967611 1967611 defendant Madyson William husbandman 600493 600493 Madyson, William, of Bolton, husbandman 0
3831101 1967612 1967612 defendant Madyson William husbandman 600493 600493 Madyson, William, of Bolton, husbandman 0
3831713 1967819 1967819 defendant Peerton John husbandman 600493 600493 Peerton, John, of Bolton, husbandman 2
3834495 1968732 1968732 defendant Stamper Nicholas husbandman 600493 600493 Stamper, Nicholas, of Bolton, husbandman 0
3834496 1968732 1968732 defendant Burghe William husbandman 600493 600493 Burghe, William, of Bolton, husbandman 1
3835495 1969042 1969042 defendant Exley John barker 600493 600493 Exley, John, of Bolton, barker 0
3851788 1974148 1974148 plaintiff Pigott William husbandman 600493 600493 Pigott, William, of Bolton, husbandman 0
3887084 1985943 1985943 defendant Smyth Robert husbandman 600493 600493 Smyth, Robert, of Bolton, husbandman 4
3887085 1985943 1985943 defendant Monkys Thomas husbandman 600493 600493 Monkys, Thomas, of Bolton, husbandman 5
3887086 1985943 1985943 defendant Monkys Richard husbandman 600493 600493 Monkys, Richard, of Bolton, husbandman 6
3930503 2000543 2000543 defendant Brooke Robert husbandman 600493 600493 Brooke, Robert, of Bolton, husbandman 2
3953710 2008372 2008372 plaintiff Johnson Anthony gent 600493 600493 Johnson, Anthony, of Bolton, gent 0
4017255 2030877 2030877 defendant Hardman Thomas chapman 600493 600493 Hardman, Thomas, of Bolton, chapman 3
4035217 2037274 2037274 plaintiff Hewson alias Robynson Thomas husbandman 600493 600493 Hewson alias Robynson, Thomas, of Bolton, husbandman 0
4036829 2037854 2037854 defendant Baxster Robert gent 600493 600493 Baxster, Robert, of Bolton, gent 9
4055872 2044482 2044482 defendant Porter George gent 600493 600493 Porter, George, of Bolton, Cumber, gent 0
4062518 2046886 2046886 plaintiff Forster John (legal representative) 600493 600493 Forster, John, of Bolton, or of Layborne, executors of 0
4074852 2051306 2051306 defendant Percye Robert husbandman 600493 600493 Percye, Robert, of Bolton, husbandman 0
4083725 2054451 2054451 plaintiff Aynsworth Elias   600493 600493 Aynsworth, Elias, of Bolton, administrators of 0
4085139 2054967 2054967 defendant Ebbyson Thomas yeoman 600493 600493 Ebbyson, Thomas, of Bolton, or of Bowton Parke, yeoman 1
4089753 2056632 2056632 defendant Woodroffe William gent 600493 600493 Woodroffe, William, of Bolton, gent 1
4106371 2062570 2062570 plaintiff Parke John mercer 600493 600493 Parke, John, of Bolton, mercer 0
4110589 2064047 2064047 defendant Pudsay William gent 600493 600493 Pudsay, William, of Bolton, gent 0
4111388 2064319 2064319 defendant Blamyre John yeoman 600493 600493 Blamyre, John, of Bolton, yeoman 0
4111469 2064350 2064350 defendant Pudsey William gent 600493 600493 Pudsey, William, of Bolton, gent 0
4113723 2065192 2065192 defendant Baxster Robert gent 600493 600493 Baxster, Robert, of Bolton, gent 0
4113724 2065192 2065192 defendant Knouton William laborer 600493 600493 Knouton, William, of Bolton, laborer 1
4133423 2072280 2072280 defendant A- Henry husbandman 600493 600493 A-, Henry, of Bolton, husbandman 0
4214552 2100596 2100596 defendant Hollyns Thomas yeoman 600493 600493 Hollyns, Thomas, of Bolton, yeoman 0
4225549 2104401 2104401 defendant Wynterborne William yeoman 600493 600493 Wynterborne, William, of Bolton, merchant, or of Burnsey, yeoman 0
4249301 2112749 2112749 defendant Milner Edward yeoman 600493 600493 Milner, Edward, of Bolton, yeoman 0
4249302 2112749 2112749 defendant Spodinge John yeoman 600493 600493 Spodinge, John, of Bolton, yeoman 1
4249304 2112750 2112750 defendant Milner Edward yeoman 600493 600493 Milner, Edward, of Bolton, yeoman 0
4249305 2112750 2112750 defendant Spodinge John yeoman 600493 600493 Spodinge, John, of Bolton, yeoman 1
4262746 2117208 2117208 defendant Baxter Thomas   600493 600493 Baxter, Thomas, of Bolton, husbandman, son of William 1
4262747 2117208 2117208 defendant Baxter John   600493 600493 Baxter, John, of Bolton, husbandman, son of William 2
4262814 2117231 2117231 defendant Baxter Thomas   600493 600493 Baxter, Thomas, of Bolton, husbandman, his son 1
4262815 2117231 2117231 defendant Baxter John   600493 600493 Baxter, John, of Bolton, husbandman, son of William 2
4262816 2117231 2117231 defendant Walmysley Christopher   600493 600493 Walmysley, Christopher, of Bolton, freemason 3
4300063 2130119 2130119 defendant Archerley alias Asseley alias Bothe Lawrence clothier 600493 600493 Archerley alias Asseley alias Bothe, Lawrence, of Bolton, clothier 1
4365592 2152760 2152760 defendant Bourghe John yeoman 600493 600493 Bourghe, John, of Bolton, yeoman 0
4403128 2165621 2165621 defendant Carter William husbandman 600493 600493 Carter, William, of Bolton, husbandman 3
4404289 2166006 2166006 defendant Peell Henry yeoman 600493 600493 Peell, Henry, of Bolton, yeoman 2
4421251 2171543 2171543 defendant Marchaunt Thomas   600493 600493 Marchaunt, Thomas, of Bolton 0
4427828 2173542 2173542 defendant Smyth Hugh le   600493 600493 Smyth, Hugh le, of Bolton 0
4429420 2174007 2174007 defendant Bellerby Robert de   600493 600493 Bellerby, Robert de, of Bolton 1
4437251 2176396 2176396 defendant Bellerby Robert de   600493 600493 Bellerby, Robert de, of Bolton 1
4442079 2182447 2182447 defendant Seyresdale Lambert de   600493 600493 Seyresdale, Lambert de, of Bolton 2
4481349 2194855 2194855 defendant Watson William   600493 600493 Watson, William, of Bolton 0
4488917 2197254 2197254 defendant Symson John   600493 600493 Symson, John, of Bolton 3
4488922 2197254 2197254 defendant Note William   600493 600493 Note, William, of Bolton 8
4488924 2197254 2197254 defendant Peresson John   600493 600493 Peresson, John, of Bolton 10
4488925 2197254 2197254 defendant Thomson John   600493 600493 Thomson, John, of Bolton 11
4488926 2197254 2197254 defendant Russell William   600493 600493 Russell, William, of Bolton 12
4499871 2200592 2200592 defendant Seyvons Thomas de   600493 600493 Seyvons, Thomas de, of Bolton 0
4502009 2201223 2201223 plaintiff Marton John   600493 600493 Marton, John, of Bolton, mason 0
4537236 2211919 2211919 defendant Walker William   600493 600493 Walker, William, of Bolton 0
4539499 2212613 2212613 plaintiff Walker William   600493 600493 Walker, William, of Bolton 0
4540192 2212835 2212835 defendant Walker William   600493 600493 Walker, William, of Bolton 0
4561476 2219522 2219522 defendant Carter William   600493 600493 Carter, William, of Bolton 4
4589180 2227998 2227998 defendant Atkynson William   600493 600493 Atkynson, William, of Bolton 0
4589184 2227998 2227998 defendant Robynson John   600493 600493 Robynson, John, of Bolton 4
4589186 2227998 2227998 defendant Preston John   600493 600493 Preston, John, of Bolton 6
4598919 2230883 2230883 defendant Andreweson John   600493 600493 Andreweson, John, of Bolton 0
4607453 2233440 2233440 defendant Andreweson John   600493 600493 Andreweson, John, of Bolton 0
4650910 2246285 2246285 defendant Prat John   600493 600493 Prat, John, of Bolton 7
4653217 2246942 2246942 defendant Coursy Edmund   600493 600493 Coursy, Edmund, of Bolton 0
4653396 2246994 2246994 defendant Bell John yeoman 600493 600493 Bell, John, of Bolton, yeoman 6
4657301 2248174 2248174 defendant Addeson William yeoman 600493 600493 Addeson, William, of Bolton, yeoman 4
4691543 2262881 2262881 defendant Louther Guy de   600493 600493 Louther, Guy de, of Bolton, parson 0
4698286 2264945 2264945 defendant Cleseby John chaplain 600493 600493 Cleseby, John, of Bolton, chaplain 0
4705909 2267227 2267227 plaintiff Lescrop Richard   600493 600493 Lescrop, Richard, of Bolton, knight 0
4705911 2267228 2267228 plaintiff Lescrop Richard   600493 600493 Lescrop, Richard, of Bolton, knight 0
4722218 2272275 2272275 defendant Cleseby John husbandman 600493 600493 Cleseby, John, of Bolton, husbandman 0
4722240 2272277 2272277 defendant Smyth Thomas yeoman 600493 600493 Smyth, Thomas, of Bolton, yeoman 7
4722241 2272277 2272277 defendant Lynck Robert miller 600493 600493 Lynck, Robert, of Bolton, miller 8
4722242 2272277 2272277 defendant Hogesson John husbandman 600493 600493 Hogesson, John, of Bolton, husbandman 9
4722244 2272277 2272277 defendant Cady Thomas husbandman 600493 600493 Cady, Thomas, of Bolton, husbandman 11
4729929 2274567 2274567 plaintiff Louther Guy de   600493 600493 Louther, Guy de, of Bolton, parson 0
4732947 2275483 2275483 defendant Stirkeland Thomas husbandman 600493 600493 Stirkeland, Thomas, of Bolton, husbandman 0
4732948 2275483 2275483 defendant Lynok Robert husbandman 600493 600493 Lynok, Robert, of Bolton, husbandman 1
4732949 2275483 2275483 defendant Hoggesson John husbandman 600493 600493 Hoggesson, John, of Bolton, husbandman 2
4733222 2275571 2275571 defendant Jake Thomas yeoman 600493 600493 Jake, Thomas, of Bolton, yeoman 0
4735345 2276200 2276200 defendant Mathoweson Thomas husbandman 600493 600493 Mathoweson, Thomas, of Bolton, husbandman 0
4735349 2276200 2276200 defendant Hill Thomas yeoman 600493 600493 Hill, Thomas, of Bolton, yeoman 4
4755596 2282132 2282132 defendant Grayson William husbandman 600493 600493 Grayson, William, of Bolton, husbandman 1
4755597 2282132 2282132 defendant Hayne Richard husbandman 600493 600493 Hayne, Richard, of Bolton, husbandman 2
4755598 2282132 2282132 defendant Hum_ Richard walker 600493 600493 Hum_, Richard, of Bolton, walker 3
4756124 2282292 2282292 defendant Huntrodes John yeoman 600493 600493 Huntrodes, John, of Bolton, yeoman 0
4756125 2282292 2282292 defendant Mayson Adam husbandman 600493 600493 Mayson, Adam, of Bolton, husbandman 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);