names

77 rows where place_id = 641273

✎ 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
3860545 1977021 1977021 plaintiff Day John mercer 641273 641273 Day, John, of Ambresbury, mercer 0
3992439 2022061 2022061 defendant Bater or Batter Martin husbandman 641273 641273 Bater or Batter, Martin, of Ambresbury, husbandman 0
4009393 2028125 2028125 plaintiff Neighbour Thomas husbandman 641273 641273 Neighbour, Thomas, of Ambresbury, husbandman 0
4457456 2187345 2187345 defendant Fermer Henry   641273 641273 Fermer, Henry, of Ambresbury 0
4474799 2192789 2192789 defendant Ertham Geoffrey   641273 641273 Ertham, Geoffrey, of Ambresbury 0
4510944 2203877 2203877 defendant Hert Robert   641273 641273 Hert, Robert, of Ambresbury 0
4518629 2206199 2206199 defendant Bevill Henry   641273 641273 Bevill, Henry, of Ambresbury 0
4531224 2210044 2210044 defendant Combe Robert   641273 641273 Combe, Robert, of Ambresbury 0
4531225 2210044 2210044 defendant Brewere Hugh   641273 641273 Brewere, Hugh, of Ambresbury 1
4558704 2218676 2218676 defendant Jay Philip   641273 641273 Jay, Philip, of Ambresbury 0
4558705 2218676 2218676 defendant Gretes John   641273 641273 Gretes, John, of Ambresbury 1
4566343 2221045 2221045 defendant Mountagu Sibyl   641273 641273 Mountagu, Sibyl, of Ambresbury, prioress 0
4578408 2224733 2224733 defendant Wylcus Roger   641273 641273 Wylcus, Roger, of Ambresbury 0
4584915 2226714 2226714 defendant Carre John   641273 641273 Carre, John, of Ambresbury 2
4601070 2231565 2231565 defendant Chaddesle John   641273 641273 Chaddesle, John, of Ambresbury 0
4613921 2235367 2235367 defendant Cook Walter   641273 641273 Cook, Walter, of Ambresbury 3
4653317 2246977 2246977 defendant Carre John farmer 641273 641273 Carre, John, of Ambresbury, farmer 1
4667033 2255419 2255419 defendant Mermyll John husbandman 641273 641273 Mermyll, John, of Ambresbury, husbandman 6
4673664 2257394 2257394 defendant Ive John fisher 641273 641273 Ive, John, of Ambresbury, fisher 0
4673671 2257395 2257395 defendant Ive John fisher 641273 641273 Ive, John, of Ambresbury, fisher 0
4681596 2259856 2259856 defendant Smale William yeoman 641273 641273 Smale, William, of Ambresbury, yeoman 6
4689020 2262124 2262124 defendant Trewythegayn William gent 641273 641273 Trewythegayn, William, of Ambresbury, gent 2
4691844 2262985 2262985 defendant Bohe William tailor 641273 641273 Bohe, William, of Ambresbury, tailor 0
4691845 2262985 2262985 defendant Cosby William   641273 641273 Cosby, William, of Ambresbury, shoe maker 1
4691846 2262985 2262985 defendant Prynce William fuller 641273 641273 Prynce, William, of Ambresbury, fuller 2
4691851 2262986 2262986 defendant Forester Robert yeoman 641273 641273 together with Forester, Robert, of Ambresbury, yeoman 2
4702294 2266127 2266127 defendant Bertram John laborer 641273 641273 Bertram, John, of Ambresbury, laborer 0
4704351 2266737 2266737 defendant Mermyll John gent 641273 641273 Mermyll, John, of Ambresbury, gent 0
4704352 2266737 2266737 defendant Carre John husbandman 641273 641273 Carre, John, of Ambresbury, husbandman 1
4704499 2266784 2266784 plaintiff Sampson Thomas   641273 641273 Sampson, Thomas, of Ambresbury 1
4706225 2267327 2267327 plaintiff Montagu Sibyl   641273 641273 Montagu, Sibyl, of Ambresbury, prioress 1
4706228 2267327 2267327 defendant Babstoke Thomas husbandman 641273 641273 Babstoke, Thomas, of Ambresbury, husbandman 2
4707753 2267792 2267792 plaintiff Montagu Sibyl   641273 641273 Montagu, Sibyl, of Ambresbury, prioress 0
4716766 2270566 2270566 defendant Touker Richard fuller 641273 641273 Touker, Richard, of Ambresbury, fuller 0
4717621 2270847 2270847 defendant Mermull John husbandman 641273 641273 Mermull, John, of Ambresbury, husbandman 0
4723342 2272611 2272611 defendant Mermyll John husbandman 641273 641273 Mermyll, John, of Ambresbury, husbandman 0
4723345 2272612 2272612 plaintiff Davy Thomas   641273 641273 Davy, Thomas, of Ambresbury 0
4723347 2272612 2272612 defendant Ive John fishmonger 641273 641273 Ive, John, of Ambresbury, fishmonger 1
4723351 2272613 2272613 plaintiff Davy Thomas butcher 641273 641273 Davy, Thomas, of Ambresbury, butcher 0
4731453 2275037 2275037 defendant Bukke Richard husbandman 641273 641273 Bukke, Richard, of Ambresbury, husbandman 0
4733467 2275641 2275641 defendant Touker Richard fuller 641273 641273 Touker, Richard, of Ambresbury, fuller 3
4737553 2276857 2276857 defendant Sampson William chapman 641273 641273 (Sampson, William, of Ambresbury, chapman 1
4737554 2276857 2276857 defendant Prydeaux Richard yeoman 641273 641273 Prydeaux, Richard, of Ambresbury, yeoman 2
4757988 2282876 2282876 defendant Molynn William husbandman 641273 641273 Molynn, William, of Ambresbury, husbandman 0
4765637 2285243 2285243 defendant Meriot John laborer 641273 641273 Meriot, John, of Ambresbury, laborer 0
4773777 2287773 2287773 defendant Bole William tailor 641273 641273 Bole, William, of Ambresbury, tailor 0
4780040 2289761 2289761 defendant Touker Richard fuller 641273 641273 Touker, Richard, of Ambresbury, fuller 0
4788640 2292503 2292503 defendant Court John skinner 641273 641273 Court, John, of Ambresbury, skinner 1
4790034 2292956 2292956 defendant Meriot John laborer 641273 641273 Meriot, John, of Ambresbury, laborer 0
4819913 2302303 2302303 defendant Selman John yeoman 641273 641273 Selman, John, of Ambresbury, yeoman 2
4834007 2306642 2306642 defendant Grygge John tailor 641273 641273 Grygge, John, of Ambresbury, tailor 0
4874168 2318861 2318861 defendant Ivy or Juy John husbandman 641273 641273 Ivy or Juy, John, of Ambresbury, husbandman 2
4878638 2320261 2320261 defendant Swetyngale John husbandman 641273 641273 Swetyngale, John, of Ambresbury, husbandman 0
4893066 2324550 2324550 defendant Swetyngale John chaplain 641273 641273 Swetyngale, John, of Ambresbury, chaplain 0
4893067 2324550 2324550 defendant Durant Thomas husbandman 641273 641273 Durant, Thomas, of Ambresbury, husbandman 1
4898331 2326135 2326135 defendant Combe John gent 641273 641273 Combe, John, of Ambresbury, gent 0
4898367 2326144 2326144 defendant Skynner William skinner 641273 641273 Skynner, William, of Ambresbury, skinner 4
4934335 2337128 2337128 defendant Swetyngale John husbandman 641273 641273 Swetyngale, John, of Ambresbury, husbandman 0
4949142 2341723 2341723 defendant Garlyk William yeoman 641273 641273 Garlyk, William, of Ambresbury, yeoman 1
4949697 2341899 2341899 defendant Coumbe John gent 641273 641273 Coumbe, John, of Ambresbury, gent 0
4949698 2341899 2341899 defendant Garlyk William   641273 641273 Garlyk, William, of Ambresbury, bailiff 1
4957751 2344289 2344289 defendant Kyrton William chapman 641273 641273 Kyrton, William, of Ambresbury, chapman 3
4959602 2344831 2344831 defendant Swetyngale John husbandman 641273 641273 Swetyngale, John, of Ambresbury, husbandman 0
4969431 2347813 2347813 defendant Kyngman Richard   641273 641273 Kyngman, Richard, of Ambresbury, servant 0
5004668 2358268 2358268 defendant Staphenes John yeoman 641273 641273 Staphenes, John, of Ambresbury, yeoman 1
5027978 2365061 2365061 defendant Sutton William skinner 641273 641273 Sutton, William, of Ambresbury, skinner 0
5050771 2371854 2371854 defendant Bondy Thomas husbandman 641273 641273 Bondy, Thomas, of Ambresbury, husbandman 0
5136810 2397287 2397287 defendant Benefeld Joan   641273 641273 Benefeld, Joan, of Ambresbury 0
5313233 2448992 2448992 defendant Heyron John cordwainer 641273 641273 Heyron, John, of Ambresbury, cordwainer 0
5365668 2464927 2464927 defendant Coweper John miller 641273 641273 Coweper, John, of Ambresbury, miller 1
5414550 2479288 2479288 plaintiff Herne Robert receiver 641273 641273 Herne, Robert, of Ambresbury, receiver 0
5430357 2484014 2484014 plaintiff Herne Robert receiver 641273 641273 Herne, Robert, of Ambresbury, receiver 0
5430359 2484015 2484015 plaintiff Herne Robert receiver 641273 641273 Herne, Robert, of Ambresbury, receiver 0
5447125 2489031 2489031 plaintiff Herne Robert receiver of money 641273 641273 Herne, Robert, of Ambresbury, receiver of money 0
5557084 2522030 2522030 defendant Garny or Garvy Nicholas   641273 641273 Garny or Garvy, Nicholas, of Ambresbury, surgeon, or of London, parish clerk 0
5593288 2532881 2532881 defendant Netherwey John fuller 641273 641273 Netherwey, John, of Ambresbury, fuller 0
5614934 2548466 2548466 defendant Lange Michael   641273 641273 Lange, Michael, of Ambresbury 0

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);