names

176 rows where place_id = 608282

✎ 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
3673013 1917567 1917567 defendant Chatours Christopher clerk 608282 608282 Chatours, Christopher, of Mere, clerk 0
3687201 1922174 1922174 defendant Dun William, junior mercer 608282 608282 Dun, William, junior, of Mere, mercer 0
3687202 1922174 1922174 defendant Dun William, senior mercer 608282 608282 Dun, William, senior, of Mere, mercer 1
3698517 1925755 1925755 defendant Dun William, junior chapman 608282 608282 Dun, William, junior, of Mere, chapman 1
3699108 1925929 1925929 plaintiff Donne William   608282 608282 Donne, William, of Mere 2
3699112 1925930 1925930 plaintiff Donne William   608282 608282 Donne, William, of Mere 2
3712788 1930316 1930316 defendant Dunne William, junior mercer 608282 608282 Dunne, William, junior, of Mere, mercer 0
3724655 1933993 1933993 defendant Carter Thomas husbandman 608282 608282 Carter, Thomas, of Mere, husbandman 0
3743480 1939835 1939835 defendant Dune John, junior mercer 608282 608282 Dune, John, junior, of Mere, mercer 0
3772840 1949198 1949198 defendant Dunne William, senior mercer 608282 608282 Dunne, William, senior, of Mere, mercer 0
3780478 1951627 1951627 defendant Mollesley Nicholas husbandman 608282 608282 Mollesley, Nicholas, of Mere, husbandman 0
3780479 1951627 1951627 defendant Clare John husbandman 608282 608282 Clare, John, of Mere, husbandman 1
3780480 1951627 1951627 defendant Dashfen John, senior husbandman 608282 608282 Dashfen, John, senior, of Mere, husbandman 2
3811498 1961488 1961488 plaintiff Chafyn Thomas   608282 608282 Chafyn, Thomas, of Mere, senior 0
3811499 1961488 1961488 defendant Whyte Robert, senior husbandman 608282 608282 Whyte, Robert, senior, of Mere, husbandman 0
3829505 1967116 1967116 defendant Jentyll John yeoman 608282 608282 Jentyll, John, of Mere, yeoman 0
3829553 1967133 1967133 defendant Jentyll John yeoman 608282 608282 Jentyll, John, of Mere, yeoman 0
3839030 1970133 1970133 defendant Donne William, junior yeoman 608282 608282 Donne, William, junior, of Mere, yeoman 1
3839031 1970133 1970133 defendant Ledyatt alias taylour John yeoman 608282 608282 Ledyatt alias taylour, John, of Mere, yeoman 2
3839032 1970133 1970133 defendant Dyke William yeoman 608282 608282 Dyke, William, of Mere, yeoman 3
3876386 1982348 1982348 defendant Hall Thomas chaplain 608282 608282 Hall, Thomas, of Mere, chaplain 0
3877516 1982717 1982717 defendant Swynnerton John clerk 608282 608282 Swynnerton, John, of Mere, clerk 0
3920988 1997368 1997368 defendant Due John husbandman 608282 608282 Due, John, of Mere, husbandman 2
3940727 2003905 2003905 defendant Chaffyn Thomas, senior gent 608282 608282 Chaffyn, Thomas, senior, of Mere, gent 0
3951975 2007754 2007754 defendant Wharff Thomas husbandman 608282 608282 Wharff, Thomas, of Mere, husbandman 0
3955129 2008856 2008856 plaintiff Macclesfyld William gent 608282 608282 Macclesfyld, William, of Mere, gent 0
3987133 2020143 2020143 defendant Jervys William yeoman 608282 608282 Jervys, William, of Mere, yeoman 2
4051669 2043016 2043016 defendant Boolde Thomas yeoman 608282 608282 Boolde, Thomas, of Mere, yeoman 0
4067195 2048567 2048567 defendant Wase Robert yeoman 608282 608282 Wase, Robert, of Mere, or of Sherborne, Dorset, yeoman 0
4067196 2048567 2048567 defendant Jones alias Aprise Nicholas innholder 608282 608282 Jones alias Aprise, Nicholas, of Mere, innholder 1
4089523 2056540 2056540 defendant Kent William husbandman 608282 608282 Kent, William, of Mere, husbandman 0
4099659 2060202 2060202 defendant Bertlett Richard tanner 608282 608282 Bertlett, Richard, of Mere, tanner 1
4200404 2095697 2095697 defendant Tutton William husbandman 608282 608282 Tutton, William, of Mere, husbandman 1
4219816 2102435 2102435 defendant Crosse Thomas butcher 608282 608282 Crosse, Thomas, of Mere, butcher 1
4232039 2106705 2106705 defendant Turner Lambert yeoman 608282 608282 Turner, Lambert, of Mere, or of Charlton, Soms, yeoman 0
4232040 2106705 2106705 defendant Wattes Edward husbandman 608282 608282 Wattes, Edward, of Mere, or of Seales, husbandman 1
4235565 2108008 2108008 defendant Tovye John, senior glover 608282 608282 Tovye, John, senior, of Mere, glover 0
4235566 2108008 2108008 defendant Tovye John junior husbandman 608282 608282 Tovye, John junior, of Mere, husbandman 1
4277925 2122209 2122209 defendant Bursye John tanner 608282 608282 Bursye, John, of Mere, tanner 0
4277926 2122209 2122209 defendant Lucas Thomas baker 608282 608282 Lucas, Thomas, of Mere, baker 1
4282285 2123704 2123704 defendant Lucas Thomas baker 608282 608282 Lucas, Thomas, of Mere, baker 0
4363587 2152050 2152050 defendant Chislett Robert yeoman 608282 608282 Chislett, Robert, of Mere, yeoman 0
4364137 2152228 2152228 defendant Chislett William tucker 608282 608282 Chislett, William, of Mere, tucker 0
4410213 2168017 2168017 defendant Pryse John husbandman 608282 608282 Pryse, John, of Mere, husbandman 1
4442468 2182590 2182590 defendant Baynton Robert de   608282 608282 Baynton, Robert de, of Mere, parson 0
4447541 2184146 2184146 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4447547 2184147 2184147 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4460426 2188322 2188322 defendant Bover or Boner Thomas   608282 608282 Bover or Boner, Thomas, of Mere 0
4467439 2190496 2190496 defendant Holeman John   608282 608282 Holeman, John, of Mere 0
4475084 2192878 2192878 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4475087 2192879 2192879 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4475090 2192880 2192880 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4475093 2192881 2192881 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4480779 2194654 2194654 defendant Ayston John   608282 608282 Ayston, John, of Mere 3
4496994 2199722 2199722 defendant Spaldyng William de   608282 608282 Spaldyng, William de, of Mere 0
4497833 2199966 2199966 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4497836 2199967 2199967 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4497838 2199968 2199968 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4497845 2199969 2199969 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4497851 2199971 2199971 plaintiff Elys Jon   608282 608282 Elys, Jon, of Mere, vicar 0
4499588 2200513 2200513 defendant Lyngyver John   608282 608282 Lyngyver, John, of Mere 19
4517957 2205995 2205995 defendant Gardener John   608282 608282 Gardener, John, of Mere 2
4519519 2206464 2206464 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4519521 2206465 2206465 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4519524 2206466 2206466 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4527113 2208762 2208762 defendant Gormond John   608282 608282 Gormond, John, of Mere 0
4528580 2209217 2209217 defendant Spaldyng William   608282 608282 Spaldyng, William, of Mere 0
4528667 2209245 2209245 defendant Holman John   608282 608282 Holman, John, of Mere 0
4531811 2210211 2210211 plaintiff Elys John   608282 608282 (Elys, John, of Mere, vicar 1
4534946 2211208 2211208 defendant Dyere John   608282 608282 Dyere, John, of Mere 4
4536330 2211644 2211644 defendant Spaldyng William   608282 608282 Spaldyng, William, of Mere 0
4547892 2215276 2215276 defendant Lytell Benedict   608282 608282 Lytell, Benedict, of Mere 0
4550314 2216042 2216042 defendant Ayston John   608282 608282 Ayston, John, of Mere 1
4551525 2216417 2216417 defendant Davy John   608282 608282 Davy, John, of Mere 2
4551830 2216519 2216519 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4551832 2216520 2216520 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4551837 2216521 2216521 plaintiff Elys John   608282 608282 Elys, John, of Mere, vicar 0
4556904 2218091 2218091 defendant Lytel Benedict   608282 608282 Lytel, Benedict, of Mere 1
4560481 2219219 2219219 defendant Elys John   608282 608282 Elys, John, of Mere, vicar 0
4561072 2219417 2219417 plaintiff Oxgome Henry   608282 608282 Oxgome, Henry, of Mere 0
4564980 2220615 2220615 defendant Litelle Benedict   608282 608282 Litelle, Benedict, of Mere 0
4566066 2220943 2220943 defendant Brewere William   608282 608282 Brewere, William, of Mere 0
4566067 2220943 2220943 defendant Notebem William   608282 608282 Notebem, William, of Mere 1
4577184 2224377 2224377 defendant Holeman John   608282 608282 Holeman, John, of Mere 0
4603966 2232413 2232413 plaintiff Wykyng John   608282 608282 Wykyng, John, of Mere 0
4612593 2235004 2235004 defendant Teny John   608282 608282 Teny, John, of Mere 0
4612595 2235004 2235004 defendant Whiteynowe John   608282 608282 Whiteynowe, John, of Mere 2
4618540 2236807 2236807 defendant Lyttell Benedict   608282 608282 (Lyttell, Benedict, of Mere 1
4631041 2240603 2240603 plaintiff Symmes John   608282 608282 Symmes, John, of Mere 0
4632432 2241031 2241031 defendant Shipherd Thomas   608282 608282 Shipherd, Thomas, of Mere 1
4648221 2245544 2245544 defendant Whitenowe John   608282 608282 Whitenowe, John, of Mere 0
4658459 2248527 2248527 defendant Teny John dyer 608282 608282 Teny, John, of Mere, dyer 0
4658460 2248527 2248527 defendant Conewich or Covewich John husbandman 608282 608282 Conewich or Covewich, John, of Mere, husbandman 1
4658461 2248527 2248527 defendant Whiteynowe John husbandman 608282 608282 Whiteynowe, John, of Mere, husbandman 2
4658462 2248527 2248527 defendant Barfot William clothier 608282 608282 Barfot, William, of Mere, clothier 3
4686120 2261251 2261251 defendant Partryg Peter husbandman 608282 608282 Partryg, Peter, of Mere, husbandman 0
4695823 2264178 2264178 defendant Gylle Philip yeoman 608282 608282 Gylle, Philip, of Mere, yeoman 0
4701304 2265806 2265806 defendant Herryes William husbandman 608282 608282 Herryes, William, of Mere, husbandman 1
4701305 2265806 2265806 defendant Lovcook William husbandman 608282 608282 Lovcook, William, of Mere, husbandman 2
4701306 2265806 2265806 defendant Lovecok John husbandman 608282 608282 Lovecok, John, of Mere, husbandman 3

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