names

109 rows where place_id = 604512

✎ 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
3648588 1909949 1909949 defendant Dobbes Christopher   604512 604512 Dobbes, Christopher, of Wighton, yeoman, son of Dobbes, John 0
3658267 1912841 1912841 defendant Smyth John yeoman 604512 604512 Smyth, John, of Wighton, yeoman 0
3703609 1927406 1927406 defendant Robynson Thomas husbandman 604512 604512 (Robynson, Thomas, of Wighton, husbandman 1
3703610 1927406 1927406 defendant Garre William husbandman 604512 604512 Garre, William, of Wighton, husbandman 2
3755665 1943728 1943728 defendant Nicholson Stephen husbandman 604512 604512 Nicholson, Stephen, of Wighton, husbandman 0
3766567 1947204 1947204 defendant Asteley Thomas gent 604512 604512 Asteley, Thomas, of Wighton, gent 0
3826518 1966141 1966141 plaintiff Broun Simon clerk 604512 604512 Broun, Simon, of Wighton, clerk 1
3834980 1968879 1968879 defendant Smyth John merchant of the staple 604512 604512 Smyth, John, of Wighton, gent, merchant of the staple 0
3879406 1983365 1983365 defendant Middelton John husbandman 604512 604512 Middelton, John, of Wighton, husbandman 1
3885457 1985392 1985392 defendant Glove Robert yeoman 604512 604512 Glove, Robert, of Wighton, yeoman 0
3885458 1985392 1985392 defendant Angell John miller 604512 604512 Angell, John, of Wighton, miller 1
3934798 2001937 2001937 defendant Smyth John   604512 604512 Smyth, John, of Wighton, Staple merchant 0
3944747 2005265 2005265 defendant Browne John yeoman 604512 604512 Browne, John, of Wighton, yeoman 0
3944748 2005265 2005265 defendant Blakeborne William laborer 604512 604512 Blakeborne, William, of Wighton, laborer 1
3944749 2005265 2005265 defendant Smyth john laborer 604512 604512 Smyth, john, of Wighton, laborer 2
3944750 2005265 2005265 defendant Clarke William laborer 604512 604512 Clarke, William, of Wighton, laborer 3
3944753 2005266 2005266 defendant Browne John yeoman 604512 604512 Browne, John, of Wighton, yeoman 0
3944754 2005266 2005266 defendant Blakeborne William laborer 604512 604512 Blakeborne, William, of Wighton, laborer 1
3944755 2005266 2005266 defendant Smyth John laborer 604512 604512 Smyth, John, of Wighton, laborer 2
3944756 2005266 2005266 defendant Clerke William laborer 604512 604512 Clerke, William, of Wighton, laborer 3
3959636 2010463 2010463 defendant Gygg John yeoman 604512 604512 Gygg, John, of Wighton, yeoman 2
3963993 2012016 2012016 defendant Walpole William husbandman 604512 604512 Walpole, William, of Wighton, husbandman 0
3974779 2015742 2015742 plaintiff Hill Thomas   604512 604512 Hill, Thomas, of Wighton 0
3974780 2015742 2015742 defendant Tante or Taute Thomas (legal representative) 604512 604512 Tante or Taute, Thomas, of Wighton, husbandman, executor of 0
3978211 2016960 2016960 defendant Smyth John, junior gent 604512 604512 Smyth, John, junior, of Wighton, gent 1
3996732 2023593 2023593 defendant Clears Christopher yeoman 604512 604512 Clears, Christopher, of Wighton, yeoman 0
3998377 2024159 2024159 defendant Mabbes Giles gent 604512 604512 Mabbes, Giles, of Wighton, gent 0
4006207 2026995 2026995 plaintiff Leamyng Robert yeoman 604512 604512 Leamyng, Robert, of Wighton, yeoman 0
4017697 2031038 2031038 defendant Mabbes Giles gent 604512 604512 Mabbes, Giles, of Wighton, gent 0
4017701 2031039 2031039 defendant Mabbes Giles gent 604512 604512 Mabbes, Giles, of Wighton, gent 0
4022805 2032879 2032879 defendant Cooke Thomas yeoman 604512 604512 Cooke, Thomas, of Wighton, yeoman 2
4041763 2039535 2039535 defendant Mabbes Giles gent 604512 604512 Mabbes, Giles, of Wighton, gent 0
4045425 2040815 2040815 defendant Mabbes Giles gent 604512 604512 Mabbes, Giles, of Wighton, gent 0
4045629 2040889 2040889 defendant Mabbes Giles gent 604512 604512 Mabbes, Giles, of Wighton, gent 0
4045837 2040956 2040956 defendant Mabbes Giles gent 604512 604512 Mabbes, Giles, of Wighton, gent 0
4046583 2041231 2041231 defendant Mabbes Giles gent 604512 604512 Mabbes, Giles, of Wighton, gent 0
4046741 2041288 2041288 defendant Giges John yeoman 604512 604512 Giges, John, of Wighton, yeoman 1
4046744 2041289 2041289 defendant Gigges John yeoman 604512 604512 Gigges, John, of Wighton, yeoman 1
4067519 2048698 2048698 defendant Black Henry yeoman 604512 604512 Black, Henry, of Wighton, yeoman 1
4085238 2055005 2055005 defendant Lemynge Robert gent 604512 604512 Lemynge, Robert, of Wighton, gent 5
4122737 2068424 2068424 defendant Hall Robert husbandman 604512 604512 Hall, Robert, of Wighton, husbandman 1
4152203 2078881 2078881 defendant Sykes Francis clerk 604512 604512 Sykes, Francis, of Wighton, clerk 0
4153937 2079473 2079473 defendant Pope Robert weaver 604512 604512 Pope, Robert, of Wighton, weaver 1
4157870 2080829 2080829 defendant Smythe John gent 604512 604512 Smythe, John, of Wighton, gent 0
4164069 2082956 2082956 defendant Flemynge Robert gent 604512 604512 Flemynge, Robert, of Wighton, gent 1
4165798 2083537 2083537 defendant Lemynge Robert gent 604512 604512 Lemynge, Robert, of Wighton, gent 0
4165800 2083538 2083538 defendant Lemynge Robert gent 604512 604512 Lemynge, Robert, of Wighton, gent 0
4178807 2088064 2088064 defendant Lemynge Robert gent 604512 604512 Lemynge, Robert, of Wighton, gent 0
4178808 2088064 2088064 defendant Westwood Roger husbandman 604512 604512 Westwood, Roger, of Wighton, husbandman 1
4178809 2088064 2088064 defendant Turner Nicholas glover 604512 604512 Turner, Nicholas, of Wighton, glover 2
4194174 2093513 2093513 defendant Hall Robert husbandman 604512 604512 Hall, Robert, of Wighton, husbandman 1
4194175 2093513 2093513 defendant Angell John husbandman 604512 604512 Angell, John, of Wighton, husbandman 2
4202992 2096595 2096595 defendant Gigges John yeoman 604512 604512 Gigges, John, of Wighton, yeoman 0
4227533 2105115 2105115 defendant Brightmer Roger wingleman 604512 604512 Brightmer, Roger, of Wighton, yeoman, wingleman 1
4241552 2110159 2110159 defendant Stump William gent 604512 604512 Stump, William, of Wighton, gent 1
4249927 2112955 2112955 defendant Logge John   604512 604512 Logge, John, of Wighton, shepherd 1
4251188 2113375 2113375 defendant Hall Robert husbandman 604512 604512 Hall, Robert, of Wighton, husbandman 0
4261302 2116747 2116747 defendant Dey Robert singleman 604512 604512 Dey, Robert, of Wighton, yeoman, singleman 0
4261303 2116747 2116747 defendant Angell John yeoman 604512 604512 Angell, John, of Wighton, yeoman 1
4261304 2116747 2116747 defendant Francklyng Robert yeoman 604512 604512 Francklyng, Robert, of Wighton, yeoman 2
4266162 2118319 2118319 defendant Thorye William yeoman 604512 604512 Thorye, William, of Wighton, yeoman 3
4270562 2119734 2119734 defendant Pannell Edmund tailor 604512 604512 Pannell, Edmund, of Wighton, tailor 0
4286569 2125240 2125240 defendant Gygg James husbandman 604512 604512 Gygg, James, of Wighton, husbandman 0
4288884 2126078 2126078 defendant Bynk Thomas yeoman 604512 604512 Bynk, Thomas, of Wighton, yeoman 2
4290522 2126671 2126671 defendant Wylson Leonard miller 604512 604512 Wylson, Leonard, of Wighton, miller 0
4322527 2137946 2137946 defendant Coulson Richard (legal representative) 604512 604512 Coulson, Richard, of Wighton, yeoman, executors of 0
4322528 2137946 2137946 defendant Waynes Maurice yeoman 604512 604512 (Waynes, Maurice, of Wighton, yeoman 1
4336475 2142493 2142493 defendant Yaxley John blacksmith 604512 604512 Yaxley, John, of Wighton, blacksmith 0
4356286 2149424 2149424 defendant Throrye William yeoman 604512 604512 Throrye, William, of Wighton, yeoman 0
4363778 2152106 2152106 defendant Margeson William   604512 604512 Margeson, William, of Wighton, Lancs yeoman 1
4387970 2160604 2160604 defendant Angell John husbandman 604512 604512 Angell, John, of Wighton, husbandman 0
4387971 2160604 2160604 defendant Burrage William laborer 604512 604512 Burrage, William, of Wighton, laborer 1
4399068 2164270 2164270 defendant Ettonfeild James chapman 604512 604512 Ettonfeild, James, of Wighton, chapman 0
4459427 2187999 2187999 plaintiff Rynalkay Wiliam   604512 604512 Rynalkay, Wiliam, of Wighton 0
4465400 2189850 2189850 defendant Fullere Robert   604512 604512 Fullere, Robert, of Wighton 1
4689835 2262378 2262378 defendant Haterbergh William yeoman 604512 604512 Haterbergh, William, of Wighton, yeoman 0
4907731 2328982 2328982 plaintiff Ade John   604512 604512 Ade, John, of Wighton 0
4995361 2355455 2355455 defendant Wether William yeoman 604512 604512 Wether, William, of Wighton, yeoman 2
5047880 2370981 2370981 defendant Haterbargh William yeoman 604512 604512 Haterbargh, William, of Wighton, yeoman 0
5078583 2380089 2380089 defendant Smyth Thomas husbandman 604512 604512 Smyth, Thomas, of Wighton, husbandman 0
5078584 2380089 2380089 defendant Gylmyn Thomas, junior laborer 604512 604512 Gylmyn, Thomas, junior, of Wighton, laborer 1
5078586 2380089 2380089 defendant Nigh- William tailor 604512 604512 Nigh-, William, of Wighton, tailor 3
5078587 2380089 2380089 defendant Jacson William husbandman 604512 604512 Jacson, William, of Wighton, husbandman 4
5078588 2380089 2380089 defendant Fleccher John husbandman 604512 604512 Fleccher, John, of Wighton, husbandman 5
5078589 2380089 2380089 defendant Webster William husbandman 604512 604512 Webster, William, of Wighton, husbandman 6
5078590 2380089 2380089 defendant Swlowe William husbandman 604512 604512 Swlowe, William,of Wighton, husbandman 7
5078591 2380089 2380089 defendant Fleccher William laborer 604512 604512 Fleccher, William, of Wighton, laborer 8
5079636 2380399 2380399 defendant Perys John husbandman 604512 604512 Perys, John, of Wighton, husbandman 0
5109592 2389237 2389237 plaintiff Gigges John   604512 604512 Gigges, John, of Wighton 0
5125485 2393940 2393940 defendant Gloyssh Thomas merchant 604512 604512 Gloyssh, Thomas, of Wighton, merchant 1
5125487 2393941 2393941 defendant Wethyr William husbandman 604512 604512 Wethyr, William, of Wighton, husbandman 0
5132202 2395910 2395910 defendant Gigges John yeoman 604512 604512 Gigges, John, of Wighton, yeoman 0
5143880 2399349 2399349 defendant Koo William husbandman 604512 604512 Koo, William, of Wighton, husbandman 0
5144101 2399426 2399426 defendant Wethir William husbandman 604512 604512 Wethir, William, of Wighton, husbandman 0
5144120 2399432 2399432 defendant Gloyssh Thomas merchant 604512 604512 Gloyssh, Thomas, of Wighton, merchant 0
5151029 2401441 2401441 plaintiff Gloys William   604512 604512 Gloys, William, of Wighton 0
5163716 2405123 2405123 defendant Southgate Henry husbandman 604512 604512 Southgate, Henry, of Wighton, husbandman 0
5163717 2405123 2405123 defendant Rook John husbandman 604512 604512 Rook, John, of Wighton, husbandman 1
5163718 2405123 2405123 defendant Robyns Thomas husbandman 604512 604512 Robyns, Thomas, of Wighton, husbandman 2
5192514 2413544 2413544 defendant Gigge Robert yeoman 604512 604512 Gigge, Robert, of Wighton, yeoman 0

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