names

164 rows where place_id = 632735

✎ 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
3808384 1960496 1960496 defendant Cawse Thomas yeoman 632735 632735 Cawse, Thomas, of Crowemer, yeoman 0
4610339 2234319 2234319 defendant Adams John   632735 632735 Adams, John, of Crowemer 1
4627533 2239542 2239542 defendant Langley John shipman 632735 632735 Langley, John, of Crowemer, shipman 7
4655578 2247635 2247635 defendant Baxter Peter baker 632735 632735 Baxter, Peter, of Crowemer, baker 0
4690683 2262635 2262635 plaintiff Williot John   632735 632735 Williot, John, of Crowemer, on his own account 0
4690701 2262639 2262639 plaintiff Willyot John   632735 632735 Willyot, John, of Crowemer 0
4723728 2272725 2272725 defendant Fairchyld Richard shipman 632735 632735 Fairchyld, Richard, of Crowemer, shipman 2
4723730 2272725 2272725 defendant Kempe Nicholas yeoman 632735 632735 Kempe, Nicholas, of Crowemer, yeoman 4
4723731 2272725 2272725 defendant Hastyng Reginald yeoman 632735 632735 Hastyng, Reginald, of Crowemer, yeoman 5
4731077 2274923 2274923 defendant James William   632735 632735 James, William, of Crowemer 0
4731083 2274923 2274923 defendant Bisshop Richard   632735 632735 Bisshop, Richard, of Crowemer, vicar 6
4745831 2279285 2279285 defendant Readere Robert barber 632735 632735 Readere. Robert, of Crowemer, barber 6
4753726 2281538 2281538 defendant Marot William yeoman 632735 632735 Marot, William, of Crowemer, yeoman 0
4779917 2289718 2289718 defendant Roo William husbandman 632735 632735 Roo, William, of Crowemer, husbandman 3
4779918 2289718 2289718 defendant Norfolk Roger husbandman 632735 632735 Norfolk, Roger, of Crowemer, husbandman 4
4840445 2308549 2308549 defendant Skilman John shipman 632735 632735 Skilman, John, of Crowemer, shipman 0
4844879 2309920 2309920 defendant Postill Richard butcher 632735 632735 Postill, Richard, of Crowemer, butcher 4
4860820 2314745 2314745 defendant Stasy John butcher 632735 632735 Stasy, John, of Crowemer, butcher 0
4867363 2316759 2316759 defendant Thommys Robert (legal representative) 632735 632735 Thommys, Robert, of Crowemer, executors of 0
4867365 2316759 2316759 defendant Thommys Alice widow 632735 632735 Thommys, Alice, of Crowemer, widow 2
4867366 2316759 2316759 defendant Salman William chaplain 632735 632735 Salman, William, of Crowemer, chaplain 3
4872442 2318345 2318345 defendant Elgar Richard husbandman 632735 632735 Elgar, Richard, of Crowemer, husbandman 3
4872445 2318345 2318345 defendant Trewe William shipman 632735 632735 Trewe, William, of Crowemer, shipman 6
4873019 2318520 2318520 defendant Roper John husbandman 632735 632735 Roper, John, of Crowemer, husbandman 0
4880820 2320908 2320908 defendant Postill Richard butcher 632735 632735 Postill, Richard, of Crowemer, butcher 2
4895700 2325331 2325331 defendant Suffolk Thomas shipman 632735 632735 Suffolk, Thomas, of Crowemer, shipman 0
4911854 2330211 2330211 defendant Fuller Henry fuller 632735 632735 Fuller, Henry, of Crowemer, fuller 0
4926570 2334728 2334728 defendant Madson Robert yeoman 632735 632735 Madson, Robert, of Crowemer, yeoman 2
4933910 2336984 2336984 defendant Norman Roger clerk 632735 632735 Norman, Roger, of Crowemer, clerk 0
4940693 2339118 2339118 defendant Gylmyn William husbandman 632735 632735 Gylmyn, William, of Crowemer, husbandman 1
4943896 2340055 2340055 defendant Postill Richard shipman 632735 632735 Postill, Richard, of Crowemer, shipman 0
4949957 2341954 2341954 defendant Aleyn William yeoman 632735 632735 Aleyn, William, of Crowemer, yeoman 0
4957588 2344243 2344243 defendant Shothowe Roger yeoman 632735 632735 Shothowe, Roger, of Crowemer, yeoman 1
4959070 2344679 2344679 defendant Brightwell William husbandman 632735 632735 Brightwell, William, of Crowemer, husbandman 0
4959377 2344771 2344771 defendant Myleham John laborer 632735 632735 Myleham, John, of Crowemer, laborer 0
4959379 2344772 2344772 defendant Tug Thomas chaplain 632735 632735 Tug, Thomas, of Crowemer, chaplain 0
4959380 2344772 2344772 defendant Brynyng Thomas chaplain 632735 632735 Brynyng, Thomas, of Crowemer, chaplain 1
4959381 2344772 2344772 defendant Rome William grocer 632735 632735 Rome, William, of Crowemer, grocer 2
4959382 2344772 2344772 defendant Brynyng William laborer 632735 632735 Brynyng, William, of Crowemer, laborer 3
4961089 2345279 2345279 defendant Southfeld William shoemaker 632735 632735 Southfeld, William, of Crowemer, shoemaker 1
4962833 2345797 2345797 defendant Phelip Robert mariner 632735 632735 Phelip, Robert, of Crowemer, mariner 0
4962834 2345797 2345797 defendant Phelip William mariner 632735 632735 Phelip, William, of Crowemer, mariner 1
4969173 2347741 2347741 defendant Frerys John shipman 632735 632735 Frerys, John, of Crowemer, shipman 1
4971985 2348561 2348561 defendant Coye William husbandman 632735 632735 Coye, William, of Crowemer, husbandman 0
4971986 2348561 2348561 defendant More John chapman 632735 632735 More, John, of Crowemer, chapman 1
4975327 2349578 2349578 defendant Bulwer Nicholas shipman 632735 632735 Bulwer, Nicholas, of Crowemer, shipman 0
4978564 2350540 2350540 defendant Madson Robert yeoman 632735 632735 Madson, Robert, of Crowemer, yeoman 0
4978565 2350540 2350540 defendant Bocher Robert butcher 632735 632735 Bocher, Robert, of Crowemer, butcher 1
4978567 2350540 2350540 defendant Tommes Thomas chaplain 632735 632735 Tommes, Thomas, of Crowemer, chaplain 3
4985998 2352731 2352731 defendant Greynyng Thomas chaplain 632735 632735 Greynyng, Thomas, of Crowemer, chaplain 0
4986790 2352987 2352987 defendant Gylmyn William yeoman 632735 632735 Gylmyn, William, of Crowemer, yeoman 0
4989328 2353743 2353743 plaintiff Bulwer Thomas   632735 632735 Bulwer, Thomas, of Crowemer 0
5011893 2360329 2360329 defendant Paterson John shipman 632735 632735 Paterson, John, of Crowemer, shipman 2
5015024 2361277 2361277 plaintiff Bocher Gilham Frenchman 632735 632735 Bocher, Gilham, of Crowemer, Frenchman 0
5015025 2361277 2361277 defendant Wylyot Adam yeoman 632735 632735 Wylyot, Adam, of Crowemer, yeoman 0
5015026 2361277 2361277 defendant Wylyot Robert yeoman 632735 632735 Wylyot, Robert, of Crowemer, yeoman 1
5015785 2361503 2361503 defendant Postyll Richard butcher 632735 632735 Postyll, Richard, of Crowemer, butcher 1
5015786 2361503 2361503 defendant Dawyson William husbandman 632735 632735 Dawyson, William, of Crowemer, husbandman 2
5015787 2361503 2361503 defendant Madson John husbandman 632735 632735 Madson, John, of Crowemer, husbandman 3
5020482 2362879 2362879 defendant Brasyer John husbandman 632735 632735 Brasyer, John, of Crowemer, husbandman 2
5022063 2363346 2363346 defendant Kysse Robert pedder 632735 632735 Kysse, Robert, of Crowemer, pedder 1
5025331 2364301 2364301 defendant Gylmyn William tailor 632735 632735 Gylmyn, William, of Crowemer, tailor 0
5033696 2366734 2366734 defendant Loksmyth Thomas yeoman 632735 632735 Loksmyth, Thomas, of Crowemer, yeoman 4
5038636 2368200 2368200 defendant Gylmyn Robert tailor 632735 632735 Gylmyn, Robert, of Crowemer, tailor 0
5038637 2368200 2368200 defendant Bylmyn William tailor 632735 632735 Bylmyn, William, of Crowemer, tailor 1
5038638 2368200 2368200 defendant Belle Richard   632735 632735 Belle, Richard, of Crowemer, shipwright 2
5038639 2368200 2368200 defendant Grys or Erys John laborer 632735 632735 Grys or Erys, John, of Crowemer, laborer 3
5043425 2369656 2369656 defendant Roo William (legal representative) 632735 632735 Roo, William, of Crowemer, executors of 4
5049389 2371452 2371452 defendant Pole Thomas yeoman 632735 632735 Pole, Thomas, of Crowemer, yeoman 1
5049973 2371613 2371613 defendant Felthorp William yeoman 632735 632735 Felthorp, William, of Crowemer, yeoman 1
5058717 2374172 2374172 defendant Postil Richard butcher 632735 632735 Postil, Richard, of Crowemer, butcher 0
5064762 2376000 2376000 defendant Wyllyot Robert yeoman 632735 632735 Wyllyot, Robert, of Crowemer, yeoman 1
5064763 2376000 2376000 defendant Rollan Katherine widow 632735 632735 Rollan, Katherine, of Crowemer, widow 2
5064764 2376000 2376000 defendant Astele John husbandman 632735 632735 Astele, John, of Crowemer, husbandman 3
5067124 2376689 2376689 defendant Arnald Richard   632735 632735 Arnald, Richard, of Crowemer, esq, Alice his wife, widow of Norwich, Robert, of North Tudenham 0
5067133 2376691 2376691 defendant Arnald Richard esq 632735 632735 Arnald, Richard, of Crowemer, esq 2
5067372 2376749 2376749 defendant Lenton John yeoman 632735 632735 Lenton, John, of Crowemer, yeoman 2
5067922 2376903 2376903 defendant Lent John shipman 632735 632735 Lent, John, of Crowemer, shipman 0
5079079 2380231 2380231 defendant Southfeld William yeoman 632735 632735 Southfeld, William, of Crowemer, yeoman 3
5080169 2380557 2380557 defendant Aleyn Richard yeoman 632735 632735 Aleyn, Richard, of Crowemer, yeoman 0
5083493 2381563 2381563 defendant Warde William yeoman 632735 632735 Warde, William, of Crowemer, yeoman 0
5093093 2384368 2384368 defendant Warde William yeoman 632735 632735 Warde, William, of Crowemer, yeoman 1
5095239 2385024 2385024 defendant Godewyn William yeoman 632735 632735 Godewyn, William, of Crowemer, yeoman 2
5099614 2386322 2386322 defendant Kysse Robert yeoman 632735 632735 Kysse, Robert, of Crowemer, yeoman 2
5100843 2386661 2386661 defendant Ikelyngham Robert chapman 632735 632735 Ikelyngham, Robert, of Crowemer, chapman 2
5102847 2387251 2387251 plaintiff Bonde William   632735 632735 Bonde, William, of Crowemer 0
5104648 2387797 2387797 defendant Stacy John butcher 632735 632735 Stacy, John, of Crowemer, butcher 0
5107611 2388658 2388658 defendant Lent John chipman 632735 632735 Lent, John, of Crowemer, chipman 2
5111210 2389666 2389666 defendant Lente John husbandman 632735 632735 Lente, John, of Crowemer, husbandman 2
5116037 2391118 2391118 defendant Claysson Nicholas husbandman 632735 632735 Claysson, Nicholas, of Crowemer, Dutchman, husbandman 4
5126633 2394263 2394263 defendant Hare alias Dalle John shipman 632735 632735 Hare alias Dalle, John, of Crowemer, shipman 3
5128104 2394693 2394693 defendant Ducheman James   632735 632735 Ducheman, James, of Crowemer, shoe maker 0
5132805 2396089 2396089 defendant Arnold Richard merchant 632735 632735 Arnold, Richard, of Crowemer, merchant 3
5147187 2400316 2400316 defendant Ducheman James shoemaker 632735 632735 Ducheman, James, of Crowemer, shoemaker 0
5148075 2400583 2400583 defendant Arnald Richard esq 632735 632735 Arnald, Richard, of Crowemer, esq 2
5150301 2401220 2401220 defendant Bonde Robert shipman 632735 632735 Bonde, Robert, of Crowemer, shipman 0
5150302 2401220 2401220 defendant Bonde Clement shipman 632735 632735 Bonde, Clement, of Crowemer, shipman 1
5155233 2402679 2402679 defendant Welle Nicholas shipman 632735 632735 Welle, Nicholas, of Crowemer, shipman 0
5167524 2406232 2406232 defendant Arnald Richard esq 632735 632735 Arnald, Richard, of Crowemer, esq 0
5177596 2409142 2409142 defendant Lowes Nicholas yeoman 632735 632735 Lowes, Nicholas, of Crowemer, 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);