names

113 rows where place_id = 590146

✎ 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
3600066 1867671 1867671 defendant Curteys James husbandman 590146 590146 Curteys, James, of Wynston, husbandman 9
3602908 1868572 1868572 defendant Peeke William thatcher 590146 590146 Peeke, William, of Wynston, thatcher 0
3607984 1870148 1870148 defendant Skynner Thomas husbandman 590146 590146 Skynner, Thomas, of Wynston, husbandman 3
3646679 1909365 1909365 defendant Coldysshe John roper 590146 590146 Coldysshe, John, of Wynston, roper 1
3654571 1911692 1911692 defendant Moyse Thomas husbandman 590146 590146 Moyse, Thomas, of Wynston, husbandman 0
3656191 1912183 1912183 defendant Conyngham Thomas hsubandman 590146 590146 Conyngham, Thomas, of Wynston, hsubandman 0
3659152 1913119 1913119 defendant Wythe Edmund husbandman 590146 590146 Wythe, Edmund, of Wynston, husbandman 0
3670870 1916855 1916855 defendant Conyngham Thomas husbandman 590146 590146 Conyngham, Thomas, of Wynston, husbandman 1
3680299 1919915 1919915 defendant Lyng John husbandman 590146 590146 Lyng, John, of Wynston, husbandman 0
3704926 1927832 1927832 defendant Sampson Robert husbandman 590146 590146 Sampson, Robert, of Wynston, husbandman 1
3705626 1928042 1928042 defendant Roydon Robert husbandman 590146 590146 Roydon, Robert, of Wynston, husbandman 1
3714743 1930912 1930912 defendant Wyche Edmund yeoman 590146 590146 Wyche, Edmund, of Wynston, yeoman 0
3748010 1941297 1941297 defendant Leveson Augustine husbandman 590146 590146 Leveson, Augustine, of Wynston, husbandman 0
3748011 1941297 1941297 defendant Wythe Edward yeoman 590146 590146 Wythe, Edward, of Wynston, yeoman 1
3748963 1941608 1941608 defendant Whytman William yeoman 590146 590146 Whytman, William, of Wynston, yeoman 0
3751393 1942351 1942351 defendant Conyngham Thomas husbandman 590146 590146 Conyngham, Thomas, of Wynston, husbandman 0
3754316 1943303 1943303 defendant Dade Nicholas chaplain 590146 590146 Dade, Nicholas, of Wynston, chaplain 1
3758717 1944721 1944721 defendant Colyngham Thomas, senior husbandman 590146 590146 Colyngham, Thomas, senior, of Wynston, husbandman 0
3762494 1945912 1945912 defendant Roydon Robert husbandman 590146 590146 Roydon, Robert, of Wynston, husbandman 1
3764545 1946570 1946570 defendant Scotte Thomas husbandman 590146 590146 Scotte, Thomas, of Wynston, husbandman 2
3770425 1948428 1948428 defendant Walton Richard husbandman 590146 590146 Walton, Richard, of Wynston, husbandman 0
3772671 1949145 1949145 defendant Walton Richard husbandman 590146 590146 Walton, Richard, of Wynston, husbandman 1
3778898 1951115 1951115 defendant Reydon Robert husbandman 590146 590146 Reydon, Robert, of Wynston, husbandman 0
3781620 1951989 1951989 defendant Roydon Robert yeoman 590146 590146 Roydon, Robert, of Wynston, yeoman 3
3784241 1952861 1952861 defendant Roydon Robert husbandman 590146 590146 Roydon, Robert, of Wynston, husbandman 1
3791598 1955212 1955212 defendant Roydon Robert husbandman 590146 590146 Roydon, Robert, of Wynston, husbandman 0
3795833 1956564 1956564 defendant Raydon Robert husbandman 590146 590146 Raydon, Robert, of Wynston, husbandman 0
3800280 1958009 1958009 defendant Reydon Robert husbandman 590146 590146 Reydon, Robert, of Wynston, husbandman 0
3824167 1965434 1965434 defendant Roydon John husbandman 590146 590146 Roydon, John, of Wynston, husbandman 1
3833861 1968524 1968524 defendant Heyron William pewterer 590146 590146 Heyron, William, of Wynston, pewterer 1
3922485 1997836 1997836 defendant Harvye Thomas husbandman 590146 590146 Harvye, Thomas, of Wynston, husbandman 1
3937185 2002769 2002769 plaintiff Nelson John, senior   590146 590146 Nelson, John, senior, of Wynston 0
3974283 2015572 2015572 defendant Mannyng Richard weaver 590146 590146 Mannyng, Richard, of Wynston, or of Ravenyngham, weaver 2
3987713 2020356 2020356 plaintiff Abbes Robert yeoman 590146 590146 Abbes, Robert, of Wynston, yeoman 0
4013147 2029434 2029434 plaintiff Roberd William   590146 590146 Roberd, William, of Wynston, gent, attorney of the Bench 0
4195954 2094139 2094139 defendant Fenne William tailor 590146 590146 Fenne, William, of Wynston, tailor 1
4216129 2101131 2101131 defendant Cotes George weaver 590146 590146 Cotes, George, of Wynston, weaver 1
4218747 2102058 2102058 defendant Palmer Thomas yeoman 590146 590146 Palmer, Thomas, of Wynston, yeoman 0
4218748 2102058 2102058 defendant Palmer Thomas   590146 590146 Palmer, Thomas, of Wynston, yeoman, son of William 1
4308542 2133141 2133141 defendant Gouldsmyth Robert yeoman 590146 590146 Gouldsmyth, Robert, of Wynston, or of Hempnall, Norf, yeoman 0
4426277 2173026 2173026 defendant Northhaw John de   590146 590146 Northhaw, John de, of Wynston 0
4502077 2201247 2201247 defendant Person Thomas   590146 590146 Person, Thomas, of Wynston 0
4521322 2207013 2207013 plaintiff Gace John   590146 590146 Gace, John, of Wynston 0
4596235 2230074 2230074 plaintiff Rowe John   590146 590146 Rowe, John, of Wynston 0
4596236 2230074 2230074 defendant Lauerans Richard   590146 590146 Lauerans, Richard, of Wynston 0
4603588 2232309 2232309 defendant Rowe John   590146 590146 Rowe, John, of Wynston 0
4614170 2235441 2235441 defendant Gase Henry   590146 590146 Gase, Henry, of Wynston 0
4635086 2241821 2241821 defendant Rowe John   590146 590146 Rowe, John, of Wynston 3
4658481 2248532 2248532 defendant Wynston Henry husbandman 590146 590146 Wynston, Henry, of Wynston, husbandman 1
4680223 2259424 2259424 defendant Gass Henry husbandman 590146 590146 Gass, Henry, of Wynston, husbandman 0
4691301 2262803 2262803 defendant Heylok William husbandman 590146 590146 Heylok, William, of Wynston, husbandman 1
4724209 2272865 2272865 defendant Moyse Richard husbandman 590146 590146 Moyse, Richard, of Wynston, husbandman 1
4726615 2273596 2273596 defendant Aleyn Henry ploughman 590146 590146 Aleyn, Henry, of Wynston, ploughman 1
4793173 2293962 2293962 plaintiff Neweman John   590146 590146 Neweman, John, of Wynston 0
4807593 2298566 2298566 defendant Rowe John yeoman 590146 590146 (Rowe, John, of Wynston, yeoman 1
4827300 2304585 2304585 defendant Lee John   590146 590146 Lee, John, of Wynston, parson 0
4832037 2306051 2306051 defendant Wynston Henry husbandman 590146 590146 Wynston, Henry, of Wynston, husbandman 0
4835801 2307192 2307192 defendant Hoxson Richard yeoman 590146 590146 Hoxson, Richard, of Wynston, yeoman 2
4857549 2313749 2313749 defendant Buk Richard engraver 590146 590146 Buk, Richard, of Wynston, engraver 0
4893699 2324725 2324725 defendant Wylbey John husbandman 590146 590146 Wylbey, John, of Wynston, husbandman 2
4893700 2324725 2324725 defendant Hoberd William husbandman 590146 590146 Hoberd, William, of Wynston, husbandman 3
4893971 2324816 2324816 defendant Gase Lawrence husbandman 590146 590146 Gase, Lawrence, of Wynston, husbandman 0
4917370 2331946 2331946 defendant Wynston Henry husbandman 590146 590146 Wynston, Henry, of Wynston, husbandman 2
4927329 2334977 2334977 defendant Bernard Roger shoemaker 590146 590146 Bernard, Roger, of Wynston, shoemaker 5
4942112 2339516 2339516 defendant Moyse William yeoman 590146 590146 Moyse, William, of Wynston, yeoman 0
4945643 2340617 2340617 defendant Gerald Richard clerk 590146 590146 Gerald, Richard, of Wynston, clerk 0
4945644 2340617 2340617 defendant Wode Robert husbandman 590146 590146 Wode, Robert, of Wynston, husbandman 1
4959025 2344666 2344666 defendant Gerald Richard clerk 590146 590146 Gerald, Richard, of Wynston, clerk 0
4966363 2346873 2346873 defendant Moyse William yeoman 590146 590146 Moyse, William, of Wynston, yeoman 1
4974360 2349297 2349297 defendant Malmeshull Thomas husbandman 590146 590146 Malmeshull, Thomas, of Wynston, husbandman 1
4974392 2349303 2349303 defendant Malmeshull Thomas husbandman 590146 590146 Malmeshull, Thomas, of Wynston, husbandman 1
4980994 2351247 2351247 defendant Howes John husbandman 590146 590146 Howes, John, of Wynston, husbandman 0
4985668 2352628 2352628 defendant Moyse William yeoman 590146 590146 Moyse, William, of Wynston, yeoman 1
4994762 2355290 2355290 defendant Gerald Richard clerk 590146 590146 (Gerald, Richard, of Wynston, clerk 1
4999146 2356621 2356621 defendant Bykenore Richard husbandman 590146 590146 Bykenore, Richard, of Wynston, husbandman 3
5006416 2358776 2358776 defendant Tebald John yeoman 590146 590146 Tebald, John, of Wynston, yeoman 0
5023652 2363825 2363825 defendant Howes John husbandman 590146 590146 Howes, John, of Wynston, husbandman 2
5024021 2363936 2363936 defendant Hoxon Richard yeoman 590146 590146 (Hoxon, Richard, of Wynston, yeoman 1
5050143 2371666 2371666 defendant Wode William husbandman 590146 590146 Wode, William, of Wynston, husbandman 1
5051730 2372129 2372129 defendant Baldewyn Robert laborer 590146 590146 Baldewyn, Robert, of Wynston, laborer 0
5131840 2395798 2395798 defendant Goneld Richard clerk 590146 590146 Goneld, Richard, of Wynston, clerk 0
5133278 2396219 2396219 defendant Gonerd Richard clerk 590146 590146 Gonerd, Richard, of Wynston, clerk 0
5140474 2398317 2398317 defendant Wylbey Thomas yeoman 590146 590146 Wylbey, Thomas, of Wynston, yeoman 0
5150723 2401356 2401356 defendant Goneld Richard clerk 590146 590146 Goneld, Richard, of Wynston, clerk 0
5153103 2402048 2402048 defendant Gonerd Richard clerk 590146 590146 Gonerd, Richard, of Wynston, clerk 0
5172284 2407617 2407617 defendant Wynston John husbandman 590146 590146 Wynston, John, of Wynston, husbandman 0
5185600 2411540 2411540 defendant Goneld Richard clerk 590146 590146 Goneld, Richard, of Wynston, clerk 0
5201763 2416281 2416281 defendant Wynston John, sen   590146 590146 Wynston, John, sen, of Wynston, franklin 2
5212802 2419490 2419490 defendant Wynston John   590146 590146 Wynston, John, of Wynston, franklin 0
5218632 2421177 2421177 defendant Goneld Richard clerk 590146 590146 Goneld, Richard, of Wynston, clerk 0
5233262 2425315 2425315 defendant Gunneld Richard clerk 590146 590146 Gunneld, Richard, of Wynston, clerk 0
5238117 2426735 2426735 defendant Goneld Richard clerk 590146 590146 Goneld, Richard, of Wynston, clerk 0
5253846 2431318 2431318 defendant Crapnell Robert laborer 590146 590146 Crapnell, Robert, of Wynston, laborer 3
5253847 2431318 2431318 defendant Crapnell Edmund laborer 590146 590146 Crapnell, Edmund, of Wynston, laborer 4
5253848 2431318 2431318 defendant Lynge John laborer 590146 590146 Lynge, John, of Wynston, laborer 5
5253849 2431318 2431318 defendant Wryght John laborer 590146 590146 Wryght, John, of Wynston, laborer 6
5279326 2439045 2439045 defendant Sporle John clerk 590146 590146 Sporle, John, of Wynston, clerk 6
5282516 2439945 2439945 defendant Hoxon Richard gent 590146 590146 Hoxon, Richard, of Wynston, gent 0
5307762 2447338 2447338 defendant Hoxon Richard gent 590146 590146 Hoxon, Richard, of Wynston, gent 0
5473885 2497165 2497165 defendant Crakenell Robert yeoman 590146 590146 (Crakenell, Robert, of Wynston, yeoman 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);