names

106 rows where place_id = 589076

✎ 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
3596437 1866513 1866513 defendant Heyman Nicholas weaver 589076 589076 Heyman, Nicholas, of Smerden, weaver 0
3596438 1866513 1866513 defendant Holstred Ellen widow 589076 589076 Holstred, Ellen, of Smerden, widow 1
3608621 1870358 1870358 defendant Smyth Andrew weaver 589076 589076 Smyth, Andrew, of Smerden, weaver 1
3608622 1870358 1870358 defendant Smyth John weaver 589076 589076 Smyth, John, of Smerden, weaver 2
3620011 1873830 1873830 defendant Pell Thomas yeoman 589076 589076 Pell, Thomas, of Smerden, yeoman 0
3625384 1875480 1875480 defendant Hancok William clothmaker 589076 589076 Hancok, William, of Smerden, clothmaker 0
3625621 1875547 1875547 defendant Hunte William clothmaker 589076 589076 Hunte, William, of Smerden, clothmaker 0
3632004 1904826 1904826 defendant Thurston John weaver 589076 589076 Thurston, John, of Smerden, weaver 0
3643983 1908550 1908550 defendant Hancok Simon yeoman 589076 589076 Hancok, Simon, of Smerden, yeoman 0
3760906 1945415 1945415 defendant Hancok Simon weaver 589076 589076 Hancok, Simon, of Smerden, weaver 3
3774498 1949751 1949751 defendant Hunt Stephen weaver 589076 589076 Hunt, Stephen, of Smerden, weaver 1
3799701 1957825 1957825 defendant Heywarde Thomas   589076 589076 Heywarde, Thomas, of Smerden, horse cutter 0
3804100 1959208 1959208 defendant Herrenden Stephen weaver 589076 589076 Herrenden, Stephen, of Smerden, weaver 2
3832815 1968190 1968190 defendant Sharpe James weaver 589076 589076 Sharpe, James, of Smerden, weaver 0
3832816 1968190 1968190 defendant Smyth Thomas laborer 589076 589076 Smyth, Thomas, of Smerden, laborer 1
3832817 1968190 1968190 defendant Edward Henry fuller 589076 589076 Edward, Henry, of Smerden, fuller 2
3849079 1973309 1973309 defendant Hyllys John chapman 589076 589076 Hyllys, John, of Smerden, chapman 1
3849082 1973310 1973310 defendant Hyllys John chapman 589076 589076 Hyllys, John, of Smerden, chapman 1
3850153 1973637 1973637 defendant Lynden Thomas clerk 589076 589076 Lynden, Thomas, of Smerden, clerk 3
3892879 1987867 1987867 defendant Ayherst George husbandman 589076 589076 Ayherst, George, of Smerden, husbandman 1
3892880 1987867 1987867 defendant Bechyng Richard husbandman 589076 589076 Bechyng, Richard, of Smerden, husbandman 2
3943803 2004942 2004942 defendant Gold John clothier 589076 589076 Gold, John, of Smerden, clothier 1
3989309 2020916 2020916 defendant Wood Thomas yeoman 589076 589076 Wood, Thomas, of Smerden, yeoman 2
3994647 2022837 2022837 defendant Wood Edmund husbandman 589076 589076 Wood, Edmund, of Smerden, husbandman 1
4038250 2038315 2038315 defendant Stedde Henry yeoman 589076 589076 Stedde, Henry, of Smerden, yeoman 2
4462328 2188915 2188915 defendant Wodeman William   589076 589076 Wodeman, William, of Smerden 6
4508231 2203061 2203061 defendant Lecchyngen Richard de   589076 589076 Lecchyngen, Richard de, of Smerden 0
4515967 2205416 2205416 defendant Symon Richard   589076 589076 Symon, Richard, of Smerden 0
4515969 2205417 2205417 defendant Symon Richard   589076 589076 Symon, Richard, of Smerden 0
4535724 2211454 2211454 defendant Barry William   589076 589076 Barry, William, of Smerden 0
4583478 2226255 2226255 defendant Stace Robert   589076 589076 Stace, Robert, of Smerden 0
4623954 2238470 2238470 defendant Haytherst John   589076 589076 Haytherst, John, of Smerden 0
4651063 2246334 2246334 defendant Robyn William laborer 589076 589076 Robyn, William, of Smerden, laborer 1
4665603 2250715 2250715 plaintiff Holstrete William   589076 589076 Holstrete, William, of Smerden 0
4678869 2258992 2258992 defendant Jan or Ian Agatha widow 589076 589076 Jan or Ian, Agatha, of Smerden, widow 0
4715103 2270048 2270048 defendant Willeam Laurence fuller 589076 589076 Willeam, Laurence, of Smerden, fuller 0
4732234 2275261 2275261 defendant Torre William husbandman 589076 589076 Torre, William, of Smerden, husbandman 0
4732235 2275261 2275261 defendant Frend Katherine spinster 589076 589076 Frend, Katherine, of Smerden, spinster 1
4732236 2275261 2275261 defendant Bayly Thomas laborer 589076 589076 Bayly, Thomas, of Smerden, laborer 2
4734375 2275920 2275920 defendant Sawyer Alan barber 589076 589076 Sawyer, Alan, of Smerden, barber 0
4738757 2277211 2277211 defendant Hamon John laborer 589076 589076 Hamon, John, of Smerden, laborer 0
4751485 2280917 2280917 defendant Aylesbury Robert baker 589076 589076 Aylesbury, Robert, of Smerden, baker 0
4751486 2280917 2280917 defendant Aylesbury Richard laborer 589076 589076 Aylesbury, Richard, of Smerden, laborer 1
4751487 2280917 2280917 defendant Aylesbury Thomas baker 589076 589076 Aylesbury, Thomas, of Smerden, baker 2
4751488 2280917 2280917 defendant Aylesbury John baker 589076 589076 Aylesbury, John, of Smerden, baker 3
4756066 2282276 2282276 defendant Torre William husbandman 589076 589076 Torre, William, of Smerden, husbandman 0
4756069 2282277 2282277 defendant Elys John husbandman 589076 589076 Elys, John, of Smerden, husbandman 0
4778013 2289108 2289108 defendant Elys John husbandman 589076 589076 Elys, John, of Smerden, husbandman 0
4778016 2289109 2289109 defendant Torre William husbandman 589076 589076 Torre, William, of Smerden, husbandman 0
4840491 2308565 2308565 defendant Dene Henry laborer 589076 589076 Dene, Henry, of Smerden, laborer 1
4840494 2308566 2308566 defendant Dene Henry laborer 589076 589076 Dene, Henry, of Smerden, laborer 1
4856040 2313261 2313261 plaintiff Baldok Robert   589076 589076 Baldok, Robert, of Smerden 0
4891780 2324171 2324171 defendant Bakere Philip husbandman 589076 589076 Bakere, Philip, of Smerden, husbandman 0
4900331 2326739 2326739 defendant Blecche Robert yeoman 589076 589076 Blecche, Robert, of Smerden, yeoman 0
4904859 2328120 2328120 plaintiff Norton Stephen   589076 589076 Norton, Stephen, of Smerden 0
4917308 2331923 2331923 defendant Omynden William husbandman 589076 589076 Omynden, William, of Smerden, husbandman 0
4917313 2331924 2331924 defendant Ketelysden William husbandman 589076 589076 Ketelysden, William, of Smerden, husbandman 0
4926994 2334871 2334871 plaintiff Torre Robert   589076 589076 Torre, Robert, of Smerden 1
4931929 2336373 2336373 defendant Bakere Philip husbandman 589076 589076 Bakere, Philip, of Smerden, husbandman 1
4931931 2336373 2336373 defendant Robert John laborer 589076 589076 Robert, John, of Smerden, laborer 3
4952197 2342624 2342624 defendant Pelle Thomas laborer 589076 589076 Pelle, Thomas, of Smerden, laborer 0
4956487 2343898 2343898 defendant Bakere Philip husbandman 589076 589076 Bakere, Philip, of Smerden, husbandman 0
5001555 2357348 2357348 defendant Eytherst John husbandman 589076 589076 Eytherst, John, of Smerden, husbandman 3
5003645 2357957 2357957 defendant Ippyngbery Thomas   589076 589076 Ippyngbery, Thomas, of Smerden, servant 1
5018230 2362217 2362217 defendant Eyrtherst of Gytherst John yeoman 589076 589076 Eyrtherst of Gytherst, John, of Smerden, yeoman 0
5046799 2370664 2370664 defendant Smyth (illegible) husbandman 589076 589076 Smyth, ----, of Smerden, husbandman 0
5046800 2370664 2370664 defendant Ryngedale John   589076 589076 Ryngedale, John, of Smerden 1
5083138 2381462 2381462 defendant Roger Stephen husbandman 589076 589076 Roger, Stephen, of Smerden, husbandman 13
5083139 2381462 2381462 defendant Elys Thomas husbandman 589076 589076 Elys, Thomas, of Smerden, husbandman 14
5085861 2382260 2382260 defendant Vunnynden or Ummynden Richard butcher 589076 589076 Vunnynden or Ummynden, Richard, of Smerden, butcher 0
5098020 2385850 2385850 defendant Blacche Richard laborer 589076 589076 Blacche, Richard, of Smerden, laborer 0
5157031 2403196 2403196 defendant Roger Stephen   589076 589076 Roger, Stephen, of Smerden 4
5204389 2417032 2417032 defendant Baker Thomas husbandman 589076 589076 Baker, Thomas, of Smerden, husbandman 0
5221477 2421978 2421978 defendant Omynden Stephen fuller 589076 589076 Omynden, Stephen, of Smerden, fuller 0
5254624 2431567 2431567 defendant Neweman William husbandman 589076 589076 Neweman, William, of Smerden, husbandman 0
5298121 2444464 2444464 defendant Ovynden Stephen weaver 589076 589076 Ovynden, Stephen, of Smerden, weaver 2
5329867 2454002 2454002 defendant Thaccher William yeoman 589076 589076 Thaccher, William, of Smerden, yeoman 1
5360329 2463265 2463265 defendant Halynden Robert husbandman 589076 589076 Halynden, Robert, of Smerden, husbandman 1
5360334 2463266 2463266 defendant Halynden Robert husbandman 589076 589076 Halynden, Robert, of Smerden, husbandman 1
5371498 2466668 2466668 defendant Norne Stephen husbandman 589076 589076 Norne, Stephen, of Smerden, husbandman 1
5374231 2467541 2467541 defendant Holstrete Thomas husbandman 589076 589076 Holstrete, Thomas, of Smerden, husbandman 1
5374288 2467561 2467561 defendant Halynden Robert husbandman 589076 589076 Halynden, Robert, of Smerden, husbandman 1
5374289 2467561 2467561 defendant Pelle Thomas butcher 589076 589076 Pelle, Thomas, of Smerden, butcher 2
5374800 2467713 2467713 defendant Mille Joh husbandman 589076 589076 Mille, Joh, of Smerden, husbandman 0
5376511 2468250 2468250 defendant Best William husbandman 589076 589076 Best, William, of Smerden, husbandman 2
5376513 2468250 2468250 defendant Quynden Thomas husbandman 589076 589076 Quynden, Thomas, of Smerden, husbandman 4
5378920 2468998 2468998 defendant Materas Thomas butcher 589076 589076 Materas, Thomas, of Smerden, butcher 0
5415268 2479504 2479504 defendant Heyman Nicholas yeoman 589076 589076 Heyman, Nicholas, of Smerden, yeoman 0
5415440 2479554 2479554 defendant Rogger Richard   589076 589076 Rogger, Richard, of Smerden 0
5430787 2484146 2484146 defendant Rogger Richard butcher 589076 589076 Rogger, Richard, of Smerden, butcher 0
5434267 2485184 2485184 plaintiff Norton Stephen   589076 589076 Norton, Stephen, of Smerden 0
5449675 2489792 2489792 plaintiff Norton Stephen   589076 589076 Norton, Stephen, of Smerden 0
5452378 2490583 2490583 defendant Whithede John laborer 589076 589076 Whithede, John, of Smerden, laborer 0
5452379 2490583 2490583 defendant Swyfte Thomas husbandman 589076 589076 Swyfte, Thomas, of Smerden, husbandman 1
5461810 2493477 2493477 plaintiff Norton Stephen   589076 589076 Norton, Stephen, of Smerden 0
5484852 2500395 2500395 defendant Halynden Robert husbandman 589076 589076 Halynden, Robert, of Smerden, husbandman 0
5485391 2500543 2500543 defendant Rogger Richard yeoman 589076 589076 Rogger, Richard, of Smerden, yeoman 0
5501034 2505258 2505258 defendant Sander John husbandman 589076 589076 Sander, John, of Smerden, husbandman 0
5501035 2505258 2505258 defendant Smyth William husbandman 589076 589076 Smyth, William, of Smerden, husbandman 1
5511010 2508284 2508284 defendant Hepton John weaver 589076 589076 Hepton, John, of Smerden, weaver 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);