names

62 rows where place_id = 627647

✎ 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
3777593 1950744 1950744 defendant Mounforth Thomas mariner 627647 627647 Mounforth, Thomas, of Cleye, mariner 0
4114127 2065333 2065333 defendant Alyson William   627647 627647 Alyson, William, of Cleye, ship master 1
4415972 2169880 2169880 defendant Wyrbald Richard   627647 627647 Wyrbald, Richard, of Cleye 7
4415973 2169880 2169880 defendant Aleyn Roger   627647 627647 Aleyn, Roger, of Cleye 8
4415974 2169880 2169880 defendant Modde Simon   627647 627647 Modde, Simon, of Cleye 9
4434153 2175443 2175443 plaintiff Hubert John   627647 627647 Hubert, John, of Cleye 0
4451507 2185442 2185442 defendant Glovere Edmund   627647 627647 Glovere, Edmund, of Cleye 3
4451509 2185443 2185443 defendant Tarsel John   627647 627647 Tarsel, John, of Cleye 0
4461568 2188695 2188695 plaintiff Steyard Nicholas   627647 627647 Steyard, Nicholas, of Cleye 0
4461571 2188696 2188696 plaintiff Steyard Nicholas   627647 627647 Steyard, Nicholas, of Cleye 0
4483109 2195412 2195412 defendant Neweborne Richard   627647 627647 Neweborne, Richard, of Cleye 1
4483115 2195413 2195413 defendant Neweborne Richard   627647 627647 Neweborne, Richard, of Cleye 1
4508831 2203243 2203243 defendant Banastre Robert   627647 627647 Banastre, Robert, of Cleye 0
4513820 2204749 2204749 defendant Misterworth William   627647 627647 Misterworth, William, of Cleye 0
4547294 2215087 2215087 defendant Reson William   627647 627647 Reson, William, of Cleye 2
4552101 2216605 2216605 defendant Gygge Bartholomew   627647 627647 Gygge, Bartholomew, of Cleye 0
4565759 2220847 2220847 plaintiff Soucere Benedict (legal representative) 627647 627647 Soucere, Benedict, of Cleye, executors of 0
4565763 2220847 2220847 defendant Rasshe Simon   627647 627647 Rasshe, Simon, of Cleye 1
4569368 2222009 2222009 defendant Gygge Bartholomew   627647 627647 Gygge, Bartholomew, of Cleye 0
4572120 2222832 2222832 defendant Parkere John   627647 627647 Parkere, John, of Cleye 0
4576870 2224268 2224268 plaintiff Burneby John   627647 627647 Burneby, John, of Cleye 0
4594226 2229459 2229459 defendant Steyard Nicholas   627647 627647 (Steyard, Nicholas, of Cleye 3
4623681 2238382 2238382 defendant Bulwere John   627647 627647 Bulwere, John, of Cleye 2
4625217 2238853 2238853 defendant Pyerysson William   627647 627647 Pyerysson, William, of Cleye 0
4627602 2239565 2239565 defendant Clerk Richard   627647 627647 Clerk, Richard, of Cleye 3
4644355 2244442 2244442 plaintiff Lutton William de   627647 627647 Lutton, William de, of Cleye 0
4647646 2245365 2245365 defendant Banston John   627647 627647 Banston, John, of Cleye 3
4652809 2246812 2246812 defendant Bulwere John yeoman 627647 627647 Bulwere, John, of Cleye, yeoman 0
4665284 2250630 2250630 defendant Bulwere William butcher 627647 627647 Bulwere, William, of Cleye, butcher 2
4672010 2256891 2256891 defendant Roter Alan husbandman 627647 627647 Roter, Alan, of Cleye, husbandman 0
4672011 2256891 2256891 defendant Dustgate John husbandman 627647 627647 Dustgate, John, of Cleye, husbandman 1
4675140 2257838 2257838 defendant bulwere John yeoman 627647 627647 bulwere, John, of Cleye, yeoman 3
4675145 2257839 2257839 defendant Bulwer John yeoman 627647 627647 Bulwer, John, of Cleye, yeoman 3
4685273 2260990 2260990 defendant Dowe John (legal representative) 627647 627647 Dowe, John, of Cleye, administratrix of 3
4687148 2261586 2261586 defendant Bulweve John yeoman 627647 627647 Bulweve, John, of Cleye, yeoman 1
4695736 2264149 2264149 plaintiff Bulwere John   627647 627647 Bulwere, John, of Cleye 0
4700938 2265696 2265696 defendant Dowe Nicholas yeoman 627647 627647 Dowe, Nicholas, of Cleye, yeoman 2
4701796 2265961 2265961 defendant Tyfford William (legal representative) 627647 627647 Tyfford, William, of Cleye, butcher, executors of 2
4711116 2268831 2268831 defendant Dowe John   627647 627647 Dowe, John, of Cleye, administrators of 3
4718302 2271062 2271062 defendant Morvile Walter yeoman 627647 627647 Morvile, Walter, of Cleye, yeoman 0
4729597 2274470 2274470 defendant Kempe Agnes   627647 627647 Kempe, Agnes, of Cleye, widow, formerly wife of Adam 6
4737809 2276930 2276930 defendant Herysse Robert merchant 627647 627647 (Herysse, Robert, of Cleye, merchant 1
4737810 2276930 2276930 defendant Pynnes John   627647 627647 Pynnes, John, of Cleye, lime burner 2
4745913 2279309 2279309 defendant Herryesson Isabell   627647 627647 Herryesson, Isabell, of Cleye 4
4749556 2280352 2280352 plaintiff Parys Henry   627647 627647 Parys, Henry, of Cleye, on his own account 0
4767007 2285669 2285669 defendant Fullere John fuller 627647 627647 Fullere, John, of Cleye, fuller 2
4770974 2286899 2286899 defendant Goodknape Simon husbandman 627647 627647 Goodknape, Simon, of Cleye, husbandman 0
4772400 2287334 2287334 defendant Tregarrat Simon husbandman 627647 627647 Tregarrat, Simon, of Cleye, husbandman 0
4778029 2289115 2289115 defendant Pays Richard husbandman 627647 627647 Pays, Richard, of Cleye, husbandman 0
4783508 2290859 2290859 defendant Nobil Nicholas shipman 627647 627647 Nobil, Nicholas, of Cleye, shipman 1
4800399 2296305 2296305 defendant Paris John shipman 627647 627647 Paris, John, of Cleye, shipman 2
4803853 2297381 2297381 defendant Bettys Robert butcher 627647 627647 Bettys, Robert, of Cleye, butcher 0
4810171 2299327 2299327 defendant Paye Richard shipman 627647 627647 Paye, Richard, of Cleye, shipman 1
4870931 2317882 2317882 defendant Williamson John chapman 627647 627647 Williamson, John, of Cleye, chapman 5
4900895 2326909 2326909 defendant Goodknape Simon husbandman 627647 627647 Goodknape, Simon, of Cleye, husbandman 0
5124090 2393502 2393502 plaintiff Wyndeler Robert   627647 627647 Wyndeler, Robert, of Cleye 0
5277208 2438417 2438417 defendant Horn William (legal representative) 627647 627647 Horn, William, of Cleye, administrator of 0
5495636 2503595 2503595 defendant Deny John, junior husbandman 627647 627647 Deny, John, junior, of Cleye, husbandman 3
5495637 2503595 2503595 defendant Deny John, senior husbandman 627647 627647 Deny, John, senior, of Cleye, husbandman 4
5516686 2510046 2510046 plaintiff Thomson William   627647 627647 Thomson, William, of Cleye 0
5622180 2550855 2550855 defendant Frend Thomas   627647 627647 Frend, Thomas, of Cleye 0
5625358 2551867 2551867 defendant Bocher William butcher 627647 627647 Bocher, William, of Cleye, butcher 1

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