names

58 rows where place_id = 804037

✎ 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
4436138 2176044 2176044 plaintiff Rogeroun John   804037 804037 Rogeroun, John, of East Henreth 0
4551517 2216415 2216415 defendant Bonne John   804037 804037 Bonne, John, of East Henreth 0
4565790 2220858 2220858 defendant Duddyll John   804037 804037 Duddyll, John, of East Henreth 0
4574764 2223628 2223628 defendant More Thomas   804037 804037 More, Thomas, of East Henreth 0
4644527 2244487 2244487 defendant Ildesley Henry   804037 804037 Ildesley, Henry, of East Henreth 0
4650333 2246117 2246117 plaintiff Whytewey William   804037 804037 Whytewey, William, of East Henreth 0
4703055 2266338 2266338 plaintiff Hattore John   804037 804037 Hattore, John, of East Henreth 0
4723656 2272704 2272704 defendant Coryour John husbandman 804037 804037 Coryour, John, of East Henreth, husbandman 0
4801080 2296528 2296528 plaintiff Whitewey William   804037 804037 Whitewey, William, of Est Henreth 0
4809033 2299000 2299000 defendant Hereward Richard husbandman 804037 804037 Hereward, Richard, of East Henreth, husbandman 0
4831354 2305837 2305837 defendant Longe Richard butcher 804037 804037 Longe, Richard, of East Henreth, butcher 0
4892357 2324346 2324346 plaintiff Eyr Thomas   804037 804037 Eyr, Thomas, of Est Henreth 0
4897548 2325894 2325894 plaintiff Wyke William   804037 804037 Wyke, William, of Est Henreth 0
4942121 2339519 2339519 defendant Harrys John husbandman 804037 804037 Harrys, John, of Est Henreth, husbandman 0
4942122 2339519 2339519 defendant Cokkys John husbandman 804037 804037 Cokkys, John, of Est Henreth, husbandman 1
4949920 2341948 2341948 defendant Asshenden Richard gent 804037 804037 Asshenden, Richard, of Est Henreth, gent 0
4969711 2347887 2347887 defendant Cheben or Cheven John yeoman 804037 804037 Cheben or Cheven, John, of Est Henreth, yeoman 0
4970544 2348134 2348134 defendant Cheneyn or Cheveyn John yeoman 804037 804037 Cheneyn or Cheveyn, John, of Est Henreth, yeoman 0
4970545 2348134 2348134 defendant Reynold John fuller 804037 804037 Reynold, John, of Est Henreth, fuller 1
4970546 2348134 2348134 defendant Huske William weaver 804037 804037 Huske, William, of Est Henreth, weaver 2
4970547 2348134 2348134 defendant Fleccher Nicholas weaver 804037 804037 Fleccher, Nicholas, of Est Henreth, weaver 3
4970548 2348134 2348134 defendant Pynnok Richard husbandman 804037 804037 Pynnok, Richard, of Est Henreth, husbandman 4
4970550 2348135 2348135 defendant Cheneyn or Cheveyn John yeoman 804037 804037 Cheneyn or Cheveyn, John, of Est Henreth, yeoman 0
4970551 2348135 2348135 defendant Reynold John fuller 804037 804037 together with Reynold, John, of Est Henreth, fuller 1
4970552 2348135 2348135 defendant Huske William weaver 804037 804037 Huske, William, of Est Henreth, weaver 2
4970553 2348135 2348135 defendant Fleccher Nicholas weaver 804037 804037 Fleccher, Nicholas, of Est Henreth, weaver 3
4970554 2348135 2348135 defendant Pynnok Richard husbandman 804037 804037 Pynnok, Richard, of Est Henreth, husbandman 4
4971765 2348483 2348483 defendant Martyn Patrick   804037 804037 Martyn, Patrick, of Est Henreth 0
4979173 2350727 2350727 defendant Fenard John chaplain 804037 804037 Fenard, John, of Est Henreth, chaplain 0
4979174 2350727 2350727 defendant Casberd John   804037 804037 Casberd, John, of Est Henreth, servant 1
4979175 2350727 2350727 defendant Mundy John, junior husbandman 804037 804037 together with Mundy, John, junior, of Est Henreth, husbandman 2
5020538 2362896 2362896 defendant Reynold John fuller 804037 804037 Reynold, John, of Est Henreth, fuller 0
5045639 2370328 2370328 defendant Smyth William smith 804037 804037 Smyth, William, of East Henreth, smith 0
5051534 2372077 2372077 plaintiff Whitwey William   804037 804037 Whitwey, William, of East Henreth 0
5051536 2372077 2372077 defendant Wyse John, senior chapman 804037 804037 Wyse, John, senior, of East Henreth, chapman 1
5051537 2372077 2372077 defendant Wyse John, junior chapman 804037 804037 Wyse, John, junior, of East Henreth, chapman 2
5074394 2378844 2378844 plaintiff Wikys William (legal representative) 804037 804037 Wikys, William, of Est Henreth, executors of 0
5074397 2378844 2378844 plaintiff Wikys John   804037 804037 Wikys, John, of Est Henreth, his son 3
5074399 2378844 2378844 defendant Taylour John chapman 804037 804037 Taylour,John, of Est Henreth, chapman 1
5075269 2379095 2379095 defendant Champe Thomas, senior weaver 804037 804037 Champe, Thomas, senior, of Est Henreth, weaver 0
5080098 2380533 2380533 defendant Stafford John fuller 804037 804037 Stafford, John, of Est Henreth, fuller 0
5080099 2380533 2380533 defendant Baron John draper 804037 804037 Baron, John, of Est Henreth, draper 1
5080100 2380533 2380533 defendant Bernard John cordwainer 804037 804037 Bernard, John, of Est Henreth, cordwainer 2
5096302 2385351 2385351 defendant Palmer Peter chapman 804037 804037 Palmer, Peter, of Est Henreth, chapman 0
5111018 2389614 2389614 defendant Yonge John chapman 804037 804037 Yonge, John, of Est Henreth, chapman 0
5139156 2397945 2397945 defendant Dalman William fuller 804037 804037 Dalman, William, of East Henreth, fuller 0
5243036 2428166 2428166 defendant Pettewyn John fisher 804037 804037 Pettewyn, John, of Est Henreth, fisher 4
5243379 2428260 2428260 defendant Reynold John fuller 804037 804037 Reynold, John, of Est Henreth, fuller 0
5249197 2429889 2429889 defendant Wyse John, senior fuller 804037 804037 Wyse, John, senior, of Est Henreth, fuller 0
5249200 2429889 2429889 defendant Sterne John mercer 804037 804037 Sterne, John, of Est Henreth, mercer 3
5249217 2429892 2429892 defendant Sterne John mercer 804037 804037 Sterne, John, of Est Henreth, mercer 3
5296363 2443928 2443928 plaintiff Whitewey William kerseyman or clothman 804037 804037 Whitewey, William, of Est Henreth, kerseyman or clothman 0
5345497 2458764 2458764 plaintiff Whitewey William kerseyman 804037 804037 Whitewey, William, of Est Henreth, kerseyman 0
5346032 2458896 2458896 defendant Sterne John yeoman 804037 804037 Sterne, John, of Est Henreth, yeoman 0
5516714 2510052 2510052 defendant Branch Thomas draper 804037 804037 Branch, Thomas, of Est Henreth, draper 0
5613824 2548099 2548099 defendant Kene Thomas   804037 804037 Kene, Thomas, of East Henreth 0
5628548 2552898 2552898 defendant Coryour John laborer 804037 804037 Coryour, John, of Est Henreth, laborer 0
5631814 2553967 2553967 defendant Rammesbury Roger husbandman 804037 804037 Rammesbury, Roger, of Est Henreth, husbandman 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);