names

51 rows where place_id = 691975

✎ 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
4092624 2057671 2057671 defendant Horsham George husbandman 691975 691975 Horsham, George, of Wydecombe, husbandman 0
4252371 2113786 2113786 defendant Hamlen Robert yeoman 691975 691975 Hamlen, Robert, of Wydecombe, yeoman 1
4450526 2185128 2185128 defendant Prior Richard   691975 691975 Prior, Richard, of Wydecombe 0
4458096 2187562 2187562 plaintiff Prior Richard   691975 691975 Prior, Richard, of Wydecombe 0
4471896 2191873 2191873 defendant Cok Thomas   691975 691975 Cok, Thomas, of Wydecombe 0
4488734 2197201 2197201 defendant Foull Robert   691975 691975 Foull, Robert, of Wydecombe 0
4590737 2228455 2228455 defendant Orland John   691975 691975 Orland, John, of Wydecombe 5
4623315 2238263 2238263 defendant Coke Thomas   691975 691975 Coke, Thomas, of Wydecombe 1
4640615 2243364 2243364 defendant Smyth Ivan   691975 691975 Smyth, Ivan, of Wydecombe 0
4678971 2259031 2259031 defendant Pitteman Robert   691975 691975 Pitteman, Robert, of Wydecombe, shepherd 1
4716306 2270411 2270411 defendant Doo William husbandman 691975 691975 Doo, William, of Wydecombe, husbandman 0
4716307 2270411 2270411 defendant Piers Thomas husbandman 691975 691975 Piers, Thomas, of Wydecombe, husbandman 1
4716308 2270411 2270411 defendant Corunne Thomas husbandman 691975 691975 Corunne, Thomas, of Wydecombe, husbandman 2
4738096 2277018 2277018 defendant Ithill Richard husbandman 691975 691975 Ithill, Richard, of Wydecombe, husbandman 1
4743771 2278707 2278707 defendant Wydecombe William gent 691975 691975 Wydecombe, William, of Wydecombe, gent 0
4751502 2280922 2280922 defendant Wydecombe William gent 691975 691975 Wydecombe, William, of Wydecombe, gent 0
4756754 2282476 2282476 defendant Wylond Thomas husbandman 691975 691975 Wylond, Thomas, of Wydecombe, husbandman 1
4765771 2285291 2285291 defendant atte Herne John laborer 691975 691975 atte Herne, John, of Wydecombe, son of John, laborer 0
4765983 2285351 2285351 defendant Bearde Richard yeoman 691975 691975 Bearde, Richard, of Wydecombe, yeoman 0
4768652 2286174 2286174 defendant Apetorre Edmund husbandman 691975 691975 Apetorre, Edmund, of Wydecombe, husbandman 4
4768653 2286174 2286174 defendant Kys Robert husbandman 691975 691975 Kys, Robert, of Wydecombe, husbandman 5
4796013 2294902 2294902 defendant Bearde Richard husbandman 691975 691975 Bearde, Richard, of Wydecombe, husbandman 0
4808142 2298724 2298724 defendant Carter William husbandman 691975 691975 Carter, William, of Wydecombe, husbandman 1
4808209 2298746 2298746 defendant Mania Robert husbandman 691975 691975 Mania, Robert, of Wydecombe, husbandman 1
4809697 2299196 2299196 defendant Smyth William husbandman 691975 691975 Smyth, William, of Wydecombe, husbandman 0
4811470 2299697 2299697 defendant Appetoure Edmund husbandman 691975 691975 Appetoure, Edmund, of Wydecombe, husbandman 0
4811472 2299698 2299698 defendant Appeterre Edmund husbandman 691975 691975 Appeterre, Edmund, of Wydecombe, husbandman 0
4846462 2310400 2310400 defendant Hayward Thomas carpenter 691975 691975 Hayward, Thomas, of Wydecombe, carpenter 0
4864978 2316023 2316023 defendant Wydecombe Thomas husbandman 691975 691975 Wydecombe, Thomas, of Wydecombe, husbandman 0
4865760 2316256 2316256 defendant Honeworthy Thomas husbandman 691975 691975 Honeworthy, Thomas, of Wydecombe, husbandman 0
4866252 2316413 2316413 defendant Beard William yeoman 691975 691975 Beard, William, of Wydecombe, yeoman 0
4882381 2321400 2321400 defendant Wydecombe William gent 691975 691975 Wydecombe, William, of Wydecombe, gent 0
4925055 2334267 2334267 defendant Smyth William husbandman 691975 691975 Smyth, William, of Wydecombe, husbandman 7
4925059 2334268 2334268 defendant Smyth William husbandman 691975 691975 Smyth, William, of Wydecombe, husbandman 2
4951353 2342386 2342386 defendant Manna Roger husbandman 691975 691975 Manna, Roger, of Wydecombe, husbandman 2
4951354 2342386 2342386 defendant Apetorre Thomas husbandman 691975 691975 Apetorre, Thomas, of Wydecombe, husbandman 3
4951355 2342386 2342386 defendant Wydeyate John husbandman 691975 691975 Wydeyate, John, of Wydecombe, husbandman 4
4975722 2349699 2349699 defendant Hodder John husbandman 691975 691975 together with Hodder, John, of Wydecombe, husbandman 5
4983190 2351874 2351874 defendant Wydecombe John gent 691975 691975 Wydecombe, John, of Wydecombe, gent 0
5017762 2362073 2362073 defendant Wydecombe Richard gent 691975 691975 Wydecombe, Richard, of Wydecombe, gent 1
5055497 2373224 2373224 defendant Coke William husbandman 691975 691975 Coke, William, of Wydecombe, husbandman 0
5069545 2377389 2377389 defendant Carswyll Nicholas husbandman 691975 691975 Carswyll, Nicholas, of Wydecombe, husbandman 0
5072573 2378284 2378284 defendant Langeworthy John   691975 691975 Langeworthy, John, of Wydecombe, millward 0
5072574 2378284 2378284 defendant Pyttyn John husbandman 691975 691975 Pyttyn, John, of Wydecombe, husbandman 1
5082384 2381229 2381229 defendant Andrewe John clerk 691975 691975 Andrewe, John, of Wydecombe, clerk 0
5100118 2386474 2386474 defendant Cote William husbandman 691975 691975 Cote, William, of Wydecombe, husbandman 0
5275972 2438048 2438048 defendant Cowele (illegible) husbandman 691975 691975 Cowele, ----, of Wydecombe, husbandman 0
5523737 2512249 2512249 defendant Otys Thomas husbandman 691975 691975 Otys, Thomas, of Wydecombe, husbandman 4
5527456 2513170 2513170 defendant Hadley John, junior gent 691975 691975 Hadley, John, junior, of Wydecombe, gent 0
5527457 2513170 2513170 defendant Bowedon Henry butcher 691975 691975 Bowedon, Henry, of Wydecombe, butcher 1
5635528 2555074 2555074 defendant Leche Nicholas husbandman 691975 691975 Leche, Nicholas, of Wydecombe, husbandman 7

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