names

132 rows where place_id = 656651

✎ 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
3941206 2004062 2004062 defendant Harryes Edward butcher 656651 656651 Harryes, Edward, of Tunbridge, butcher 0
3955690 2009063 2009063 defendant Latter John husbandman 656651 656651 Latter, John, of Tunbridge, husbandman 1
3955691 2009063 2009063 defendant Mercer Thomas butcher 656651 656651 Mercer, Thomas, of Tunbridge, butcher 2
3955692 2009063 2009063 defendant Bennett Thomas laborer 656651 656651 Bennett, Thomas, of Tunbridge, laborer 3
3955693 2009063 2009063 defendant Latter Thomas husbandman 656651 656651 Latter, Thomas, of Tunbridge, husbandman 4
3971006 2014417 2014417 plaintiff Drewe Martin yeoman 656651 656651 Drewe, Martin, of Tunbridge, yeoman 0
3979812 2017534 2017534 defendant Leaver John gent 656651 656651 Leaver, John, of Tunbridge, gent 0
3979813 2017534 2017534 defendant Couchman William clothmaker 656651 656651 Couchman, William, of Tunbridge, clothmaker 1
3987951 2020437 2020437 plaintiff Allen Cuthbert   656651 656651 Allen, Cuthbert, of Tunbridge 0
3988657 2020684 2020684 defendant Plane Michael yeoman 656651 656651 Plane, Michael, of Tunbridge, yeoman 1
3988661 2020685 2020685 defendant Plane Michael yeoman 656651 656651 Plane, Michael, of Tunbridge, yeoman 1
3995291 2023056 2023056 plaintiff Coulgate Martin weaver 656651 656651 Coulgate, Martin, of Tunbridge, weaver 0
3995292 2023056 2023056 defendant Hedd Nicholas husbandman 656651 656651 Hedd, Nicholas, of Tunbridge, or of Hethefild, Sussex, husbandman 0
3995293 2023057 2023057 plaintiff Coulgate Martin weaver 656651 656651 Coulgate, Martin, of Tunbridge, weaver 0
3995294 2023057 2023057 defendant Hedd Nicholas husbandman 656651 656651 Hedd, Nicholas, of Tunbridge, or of Hethfild, Sussex, husbandman 0
3996295 2023424 2023424 defendant Swayn- David glover 656651 656651 Swayn-, David, of Tunbridge, glover 1
3997533 2023867 2023867 defendant Everest Robert butcher 656651 656651 Everest, Robert, of Tunbridge, butcher 2
4007506 2027468 2027468 plaintiff Marshall Thomas gent 656651 656651 Marshall, Thomas, of Tunbridge, gent 0
4015420 2030210 2030210 defendant Harrys George yeoman 656651 656651 Harrys, George, of Tunbridge, yeoman 0
4015689 2030309 2030309 defendant Beche William tailor 656651 656651 Beche, William, of Tunbridge, tailor 1
4015690 2030309 2030309 defendant Orell Geoffrey yeoman 656651 656651 Orell, Geoffrey, of Tunbridge, yeoman 2
4016869 2030731 2030731 defendant Honyngton William yeoman 656651 656651 Honyngton, William, of Tunbridge, yeoman 2
4019397 2031671 2031671 defendant Parmynger Clement yeoman 656651 656651 Parmynger, Clement, of Tunbridge, yeoman 0
4028748 2034929 2034929 plaintiff Cowcheman William (legal representative) 656651 656651 Cowcheman, William, of Tunbridge, clothman, executor of 0
4030671 2035631 2035631 defendant Lawe John yeoman 656651 656651 Lawe, John, of Tunbridge, yeoman 0
4044159 2040365 2040365 defendant Everest Robert butcher 656651 656651 Everest, Robert, of Tunbridge, butcher 0
4046133 2041055 2041055 defendant Borne Thomas, senior yeoman 656651 656651 Borne, Thomas, senior, of Tunbridge, yeoman 0
4047940 2041709 2041709 defendant Harrys George yeoman 656651 656651 Harrys, George, of Tunbridge, yeoman 0
4048011 2041732 2041732 defendant Bret or Burt John weaver or broad weaver 656651 656651 Bret or Burt, John, of Tunbridge, or of Zeale, weaver or broad weaver 0
4048014 2041733 2041733 defendant Brett or Burt John weaver 656651 656651 Brett or Burt, John, of Tunbridge, weaver 0
4050627 2042654 2042654 defendant Harrys Anthony butcher 656651 656651 Harrys, Anthony, of Tunbridge, butcher 1
4071007 2049930 2049930 defendant Beache Walter husbandman 656651 656651 Beache, Walter, of Tunbridge, or of Penseaste , Kent, husbandman 0
4075651 2051594 2051594 defendant Dyxstonne Thomas butcher 656651 656651 Dyxstonne, Thomas, of Tunbridge, butcher 0
4075652 2051594 2051594 defendant Fochell Laurence collier 656651 656651 Fochell, Laurence, of Tunbridge, collier 1
4075654 2051595 2051595 defendant Parker George butcher 656651 656651 Parker, George, of Tunbridge, butcher 0
4077602 2052277 2052277 defendant Root John butcher 656651 656651 Root, John, of Tunbridge, butcher 1
4079712 2053041 2053041 defendant Parker George butcher 656651 656651 Parker, George, of Tunbridge, butcher 0
4081817 2053799 2053799 defendant Children John yeoman 656651 656651 Children, John, of Tunbridge, yeoman 1
4092242 2057526 2057526 defendant Dann or Daun Richard tailor 656651 656651 Dann or Daun, Richard, of Tunbridge, tailor 1
4101274 2060760 2060760 defendant Woodgate William yeoman of Queen's chamber 656651 656651 Woodgate, William, of Tunbridge, yeoman of Queen's chamber 0
4107281 2062895 2062895 defendant Walter Thomas yeoman 656651 656651 Walter, Thomas, of Tunbridge, yeoman 0
4120877 2067755 2067755 defendant Lamparde Mathew yeoman 656651 656651 Lamparde, Mathew, of Tunbridge, yeoman 0
4123837 2068823 2068823 defendant Wyllard David gent 656651 656651 Wyllard, David, of Tunbridge, or of Hadlowe, Kent, gent 0
4136639 2073447 2073447 defendant Leeth Francis blacksmith 656651 656651 Leeth, Francis, of Tunbridge, blacksmith 0
4145133 2076458 2076458 defendant Pawley Moses yeoman 656651 656651 Pawley, Moses, of Tunbridge, yeoman 0
4145999 2076754 2076754 defendant Rumney William husbandman 656651 656651 Rumney, William, of Tunbridge, husbandman 4
4161194 2081993 2081993 defendant Dixson Thomas butcher 656651 656651 Dixson, Thomas, of Tunbridge, butcher 0
4161195 2081993 2081993 defendant Gater John tailor 656651 656651 Gater, John, of Tunbridge, tailor 1
4161353 2082051 2082051 defendant Johnson Edward husbandman 656651 656651 Johnson, Edward, of Tunbridge, husbandman 0
4170918 2085314 2085314 defendant Wylkyns George yeoman 656651 656651 Wylkyns, George, of Tunbridge, yeoman 1
4170925 2085314 2085314 defendant Chownyng Thomas husbandman 656651 656651 together with Chownyng, Thomas, of Tunbridge, husbandman 8
4170926 2085314 2085314 defendant Nicholson alias Webbe William husbandman 656651 656651 Nicholson alias Webbe, William, of Tunbridge, husbandman 9
4173851 2086309 2086309 defendant Harrys William, junior tanner 656651 656651 Harrys, William, junior, of Tunbridge, tanner 0
4174920 2086693 2086693 defendant Woodgate William yeoman 656651 656651 Woodgate, William, of Tunbridge, yeoman 0
4194254 2093540 2093540 defendant Chownyng Thomas husbandman 656651 656651 Chownyng, Thomas, of Tunbridge, husbandman 0
4194255 2093540 2093540 defendant Nicolson alias Webbe William husbandman 656651 656651 Nicolson alias Webbe, William, of Tunbridge, husbandman 1
4194256 2093540 2093540 defendant Bird William yeoman 656651 656651 together with Bird, William, of Tunbridge, yeoman 2
4194257 2093540 2093540 defendant Wylkyns George yeoman 656651 656651 Wylkyns, George, of Tunbridge, yeoman 3
4194267 2093542 2093542 defendant Stace John, junior yeoman 656651 656651 Stace, John, junior, of Tunbridge, yeoman 1
4194270 2093542 2093542 defendant Rumney William husbandman 656651 656651 Rumney, William, of Tunbridge, husbandman 4
4195924 2094128 2094128 defendant Laine or Lame John tanner 656651 656651 Laine or Lame, John, of Tunbridge, tanner 0
4195925 2094128 2094128 defendant Harris William, junior tanner 656651 656651 Harris, William, junior, of Tunbridge, tanner 1
4226949 2104899 2104899 defendant Parkes John tailor 656651 656651 Parkes, John, of Tunbridge, tailor 0
4233904 2107387 2107387 defendant Holloway Stephen husbandman 656651 656651 Holloway, Stephen, of Tunbridge, husbandman 0
4239881 2109584 2109584 defendant Somersale William husbandman 656651 656651 Somersale, William, of Tunbridge, or of Watringbury, husbandman 0
4239884 2109585 2109585 defendant Somersale William husbandman 656651 656651 Somersale, William, of Tunbridge, or of Watringbor, husbandman 0
4245884 2111603 2111603 defendant Rolfe John thatcher 656651 656651 Rolfe, John, of Tunbridge, yeoman, thatcher 0
4276928 2121861 2121861 defendant Browker Daniel bricklayer 656651 656651 Browker, Daniel, of Tunbridge, bricklayer 0
4276930 2121862 2121862 defendant Harris Thomas butcher 656651 656651 Harris, Thomas, of Tunbridge, butcher 0
4286230 2125130 2125130 defendant Willard Edmund yeoman 656651 656651 Willard, Edmund, of Tunbridge, yeoman 0
4289002 2126122 2126122 defendant Willard Edmund yeoman 656651 656651 Willard, Edmund, of Tunbridge, yeoman 2
4289601 2126347 2126347 defendant Willard Edmund gent 656651 656651 Willard, Edmund, of Tunbridge, gent 0
4305147 2131937 2131937 defendant Willard Abraham   656651 656651 Willard, Abraham, of Tunbridge, yeoman, iron master 1
4305346 2132010 2132010 defendant Wallys William weaver 656651 656651 Wallys, William, of Tunbridge, weaver 1
4309987 2133652 2133652 defendant Ware John yeoman 656651 656651 Ware, John, of Tunbridge, yeoman 0
4310863 2133947 2133947 defendant Hollowaye Stephen yeoman 656651 656651 Hollowaye, Stephen, of Tunbridge, yeoman 0
4312360 2134462 2134462 defendant Frye John yeoman 656651 656651 Frye, John, of Tunbridge, yeoman 0
4313539 2134844 2134844 defendant Busse Thomas clothier 656651 656651 Busse, Thomas, of Tunbridge, clothier 0
4313541 2134845 2134845 defendant Harrys Thomas butcher 656651 656651 Harrys, Thomas, of Tunbridge, butcher 0
4313971 2134992 2134992 defendant Frye John yeoman 656651 656651 Frye, John, of Tunbridge, yeoman 1
4313994 2135001 2135001 defendant Willard Abraham yeoman 656651 656651 Willard, Abraham, of Tunbridge, yeoman 1
4313997 2135002 2135002 defendant Willard Edmund yeoman or gent 656651 656651 Willard, Edmund, of Tunbridge, yeoman or gent 1
4314722 2135263 2135263 defendant Willard Edmund yeoman 656651 656651 Willard, Edmund, of Tunbridge, yeoman 1
4319690 2136999 2136999 defendant Children John, junior husbandman 656651 656651 Children, John, junior, of Tunbridge, husbandman 2
4320408 2137236 2137236 defendant Nethersall John gent 656651 656651 Nethersall, John, of Tunbridge, gent 2
4325542 2138918 2138918 defendant Cowchman Thomas yeoman 656651 656651 Cowchman, Thomas, of Tunbridge, yeoman 1
4328415 2139819 2139819 defendant Wyllard Abraham yeoman 656651 656651 Wyllard, Abraham, of Tunbridge, yeoman 2
4328419 2139820 2139820 defendant Wyllard Abraham yeoman 656651 656651 Wyllard, Abraham, of Tunbridge, yeoman 2
4329674 2140220 2140220 defendant Woodin James yeoman 656651 656651 Woodin, James, of Tunbridge, yeoman 0
4346467 2146014 2146014 defendant Wallys William weaver 656651 656651 Wallys, William, of Tunbridge, weaver 3
4359911 2150708 2150708 defendant Willard Abraham yeoman 656651 656651 Willard, Abraham, of Tunbridge, yeoman 3
4362084 2151482 2151482 defendant Dann Richard tailor 656651 656651 Dann, Richard, of Tunbridge, or of Allhallowes, tailor 0
4362468 2151625 2151625 defendant Frye Walter tailor 656651 656651 Frye, Walter, of Tunbridge, tailor 0
4363403 2151985 2151985 defendant Beale Thomas husbandman 656651 656651 Beale, Thomas, of Tunbridge, husbandman 0
4516998 2205723 2205723 defendant Beerme Thomas   656651 656651 Beerme, Thomas, of Tunbridge 2
4706415 2267388 2267388 defendant Kent John husbandman 656651 656651 Kent, John, of Tunbridge, husbandman 1
4706416 2267388 2267388 defendant Godfrey William shingler or roofer 656651 656651 Godfrey, William, of Tunbridge, shingler or roofer 2
4769102 2286316 2286316 defendant Pycot Thomas, sen draper 656651 656651 Pycot, Thomas, sen, of Tunbridge, draper 8
4769104 2286316 2286316 defendant Rode John   656651 656651 Rode, John, of Tunbridge, arrow maker 10
4831959 2306026 2306026 defendant Burgh Richard yeoman 656651 656651 Burgh, Richard, of Tunbridge, 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);