names

210 rows where place_id = 589796

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3598794 1867250 1867250 defendant Grebbe John husbandman 589796 589796 Grebbe, John, of Leek, husbandman 5
3603883 1868886 1868886 defendant Wylde Robert yeoman 589796 589796 Wylde, Robert, of Leek, yeoman 0
3603884 1868886 1868886 defendant Wylde Henry yeoman 589796 589796 Wylde, Henry, of Leek, yeoman 1
3608238 1870232 1870232 defendant Grebbe John husbandman 589796 589796 Grebbe, John, of Leek, husbandman 0
3611170 1871170 1871170 defendant Spryngar Thomas husbandman 589796 589796 Spryngar, Thomas, of Leek, husbandman 0
3622868 1874680 1874680 defendant Leek John esq 589796 589796 Leek, John, of Leek, esq 0
3622870 1874681 1874681 defendant Leek John esq 589796 589796 Leek, John, of Leek, esq 0
3624052 1875052 1875052 defendant Gregby John husbandman 589796 589796 Gregby, John, of Leek, husbandman 0
3659383 1913195 1913195 defendant Rychard Thomas gent 589796 589796 Rychard, Thomas, of Leek, gent 0
3666078 1915331 1915331 defendant Sherrerd Hugh husbandman 589796 589796 Sherrerd, Hugh, of Leek, husbandman 0
3692924 1923986 1923986 defendant Fernehagh Nicholas husbandman 589796 589796 Fernehagh, Nicholas, of Leek, husbandman 0
3692925 1923986 1923986 defendant Fernehagh John husbandman 589796 589796 Fernehagh, John, of Leek, husbandman 1
3898575 1989731 1989731 defendant Brereton Andrew gent 589796 589796 Brereton, Andrew, of Leek, gent 1
3898576 1989731 1989731 defendant Wyston Ralph husbandman 589796 589796 Wyston, Ralph, of Leek, husbandman 2
4129625 2070901 2070901 defendant Glegby Thomas yeoman 589796 589796 Glegby, Thomas, of Leek, yeoman 0
4212797 2100012 2100012 defendant Heath John yeoman 589796 589796 Heath, John, of Leek, yeoman 3
4416994 2170185 2170185 plaintiff Pouger Ralph   589796 589796 Pouger, Ralph, of Leek, son of Hugh 0
4421414 2171602 2171602 defendant del Hay Alan   589796 589796 del Hay, Alan, of Leek, son of John 0
4423682 2172251 2172251 plaintiff Harald Walter   589796 589796 Harald, Walter, of Leek 0
4423685 2172252 2172252 plaintiff Harald Walter   589796 589796 Harald, Walter, of Leek 0
4427999 2173598 2173598 plaintiff Spynay Robert (legal representative) 589796 589796 Spynay, Robert, of Leek, parson, executors of 0
4435245 2175781 2175781 defendant Thorald Peter   589796 589796 Thorald, Peter, of Leek 0
4435247 2175782 2175782 plaintiff Mosse John   589796 589796 Mosse, John, of Leek 0
4435249 2175782 2175782 defendant Thorald Peter   589796 589796 Thorald, Peter, of Leek, son of John 1
4435250 2175783 2175783 plaintiff Mosse John   589796 589796 Mosse, John, of Leek 0
4436815 2176254 2176254 defendant Mosse John   589796 589796 Mosse, John, of Leek 0
4437041 2176330 2176330 defendant Coiliour Lawrence   589796 589796 Coiliour, Lawrence, of Leek 2
4437043 2176330 2176330 defendant Lyard John   589796 589796 Lyard, John, of Leek 4
4437044 2176330 2176330 defendant Harald John   589796 589796 Harald, John, of Leek 5
4437045 2176330 2176330 defendant Thorald John   589796 589796 Thorald, John, of Leek 6
4443503 2182934 2182934 defendant Godwyn John   589796 589796 Godwyn, John, of Leek 0
4445513 2183551 2183551 defendant Bugg Geoffrey   589796 589796 Bugg, Geoffrey, of Leek 0
4449511 2184794 2184794 plaintiff Godewyn John   589796 589796 Godewyn, John, of Leek 0
4449513 2184794 2184794 defendant Barker Robert   589796 589796 Barker, Robert, of Leek 1
4473726 2192426 2192426 defendant Grave John   589796 589796 Grave, John, of Leek, son of John Grave, senior 0
4473730 2192426 2192426 defendant Hughson Katherine   589796 589796 Hughson, Katherine, of Leek, formerly wife of John Hughson 4
4493853 2198771 2198771 defendant Muryell Richard   589796 589796 Muryell, Richard, of Leek 4
4495286 2199202 2199202 defendant Baudryson John   589796 589796 Baudryson, John, of Leek, son of John 0
4495370 2199231 2199231 defendant Leverton John   589796 589796 Leverton, John, of Leek 0
4495950 2199410 2199410 defendant smyth John   589796 589796 smyth, John, of Leek 3
4498730 2200238 2200238 defendant Hunate John   589796 589796 Hunate, John, of Leek 0
4498732 2200238 2200238 defendant Dandy Robert   589796 589796 Dandy, Robert, of Leek 2
4498733 2200238 2200238 defendant Lucasson John   589796 589796 Lucasson, John, of Leek 3
4498734 2200238 2200238 defendant Colvyll John   589796 589796 Colvyll, John, of Leek 4
4498739 2200239 2200239 defendant Toke John   589796 589796 Toke, John, of Leek 3
4498740 2200239 2200239 defendant Tokke William   589796 589796 Tokke, William, of Leek 4
4498741 2200239 2200239 defendant Brene Thomas   589796 589796 Brene, Thomas, of Leek 5
4506083 2202416 2202416 defendant Busshe John fisher 589796 589796 Busshe, John, of Leek, fisher 1
4506127 2202432 2202432 defendant Gybonson John   589796 589796 Gybonson, John, of Leek 2
4511218 2203955 2203955 plaintiff Belle Mathew   589796 589796 Belle, Mathew, of Leek 0
4529637 2209549 2209549 defendant Stykeney William   589796 589796 Stykeney, William, of Leek 0
4529639 2209550 2209550 defendant Walles Thomas   589796 589796 Walles, Thomas, of Leek 0
4539375 2212573 2212573 defendant Bell John tailor 589796 589796 Bell, John, of Leek, tailor 1
4541463 2213226 2213226 defendant Pernell John butcher 589796 589796 Pernell, John, of Leek, butcher 0
4543205 2213758 2213758 defendant Shepe John   589796 589796 Shepe, John, of Leek 5
4543713 2213929 2213929 defendant Watkyn Robert   589796 589796 Watkyn, Robert, of Leek, son of John 0
4543715 2213930 2213930 defendant Watkyn Robert   589796 589796 Watkyn, Robert, of Leek, son of John 0
4549248 2215704 2215704 plaintiff Colynson Alice   589796 589796 Colynson, Alice, of Leek, formerly wife of Thomas 0
4549251 2215704 2215704 defendant Belle Mathew   589796 589796 Belle, Mathew, of Leek 2
4553940 2217153 2217153 plaintiff Godwyn Richard   589796 589796 Godwyn, Richard, of Leek 0
4553941 2217153 2217153 defendant Shephird William   589796 589796 Shephird, William, of Leek 0
4553943 2217154 2217154 plaintiff Godwyne Richard   589796 589796 Godwyne, Richard, of Leek 0
4553944 2217154 2217154 defendant Shepherd William   589796 589796 Shepherd, William, of Leek 0
4557600 2218312 2218312 defendant Brysson John   589796 589796 Brysson, John, of Leek 0
4567524 2221401 2221401 defendant Gilberdson John   589796 589796 Gilberdson, John, of Leek 0
4567879 2221526 2221526 defendant Gybonson John   589796 589796 Gybonson, John, of Leek, son of John 0
4575410 2223823 2223823 defendant Ryggesby Edmund   589796 589796 Ryggesby, Edmund, of Leek 0
4578339 2224716 2224716 plaintiff Clement John   589796 589796 Clement, John, of Leek 0
4580617 2225419 2225419 plaintiff del House John   589796 589796 del House, John, of Leek 0
4580618 2225419 2225419 defendant Grene Benedict de   589796 589796 Grene, Benedict de, of Leek 0
4583584 2226288 2226288 defendant Broun Stephen   589796 589796 Broun, Stephen, of Leek 0
4588589 2227806 2227806 defendant Isoldson William   589796 589796 Isoldson, William, of Leek 0
4591804 2228792 2228792 defendant Lekeet John   589796 589796 Lekeet, John, of Leek 0
4597084 2230331 2230331 defendant Stykenay William de   589796 589796 Stykenay, William de, of Leek 0
4598801 2230857 2230857 defendant Pare Ralph   589796 589796 Pare, Ralph, of Leek 0
4608931 2233897 2233897 defendant Pene John tailor 589796 589796 Pene, John, of Leek, tailor 0
4617634 2236523 2236523 defendant Plommer William   589796 589796 Plommer, William, of Leek 6
4617643 2236524 2236524 defendant Plommer William   589796 589796 Plommer, William, of Leek 6
4637499 2242519 2242519 defendant Ploute John   589796 589796 Ploute, John, of Leek 0
4638956 2242917 2242917 defendant Walker Andrew   589796 589796 Walker, Andrew, of Leek 0
4644966 2244599 2244599 defendant Pare Ralph   589796 589796 Pare, Ralph, of Leek 0
4654923 2247422 2247422 defendant Plonte John   589796 589796 Plonte, John, of Leek, chaloner or blanket maker, administrators of 0
4654925 2247422 2247422 defendant Hale alias Willehoggesson John yeoman 589796 589796 Hale alias Willehoggesson, John, of Leek, yeoman 2
4654930 2247425 2247425 defendant Plonte John   589796 589796 Plonte, John, of Leek, chaloner or blanket maker, administrators of 0
4654932 2247425 2247425 defendant Hale alias Willehoggesson John yeoman 589796 589796 Hale alias Willehoggesson, John, of Leek, yeoman 2
4659069 2248706 2248706 defendant Neuson Richard laborer 589796 589796 Neuson, Richard, of Leek, laborer 0
4659071 2248706 2248706 defendant Lucasson John husbandman 589796 589796 Lucasson, John, of leek, husbandman 2
4693837 2263575 2263575 defendant Grave or Grane John husbandman 589796 589796 Grave or Grane, John, of Leek, husbandman 0
4712523 2269234 2269234 defendant Knyght Richard chaplain 589796 589796 Knyght, Richard, of Leek, chaplain 1
4712524 2269234 2269234 defendant Fyn William fouler 589796 589796 Fyn, William, of Leek, fouler 2
4721118 2271939 2271939 defendant Jonson John husbandman 589796 589796 Jonson, John, of Leek, husbandman 0
4721332 2272003 2272003 defendant Smyth John husbandman 589796 589796 Smyth, John, of Leek, husbandman 1
4745760 2279268 2279268 defendant Kelsey John laborer 589796 589796 Kelsey, John, of Leek, laborer 0
4745761 2279268 2279268 defendant Style John tailor 589796 589796 Style, John, of Leek, tailor 1
4763015 2284417 2284417 defendant Frankys John husbandman 589796 589796 Frankys, John, of Leek, husbandman 3
4763513 2284571 2284571 plaintiff Grave or Grane John   589796 589796 Grave or Grane, John, of Leek 0
4763514 2284571 2284571 defendant House Richard husbandman 589796 589796 House, Richard, of Leek, husbandman 0
4763515 2284571 2284571 defendant Frankys Ralph husbandman 589796 589796 Frankys, Ralph, of Leek, husbandman 1
4763516 2284571 2284571 defendant Alanson William fishmonger 589796 589796 Alanson, William, of Leek, fishmonger 2
4763517 2284571 2284571 defendant Dawe John   589796 589796 Dawe, John, of Leek, fish monger 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);