names

69 rows where place_id = 667058

✎ 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
3983562 2018889 2018889 plaintiff Spencer John gent 667058 667058 Spencer, John, of Blounham, gent 0
4020991 2032232 2032232 plaintiff Wotton Robert yeoman 667058 667058 Wotton, Robert, of Blounham, yeoman 0
4020993 2032233 2032233 plaintiff Wotton Robert yeoman 667058 667058 Wotton, Robert, of Blounham, yeoman 0
4416202 2169953 2169953 plaintiff Malyn John   667058 667058 Malyn, John, of Blounham 0
4425406 2172771 2172771 plaintiff Malynz John   667058 667058 Malynz, John, of Blounham 0
4453877 2186229 2186229 plaintiff Belgrave Peter   667058 667058 Belgrave, Peter, of Blounham, parson 1
4479877 2194372 2194372 plaintiff Kempe Robert   667058 667058 Kempe, Robert, of Blounham 0
4531174 2210025 2210025 plaintiff Passelowe Roger   667058 667058 Passelowe, Roger, of Blounham 0
4572743 2223015 2223015 defendant Bocher John   667058 667058 Bocher, John, of Blounham 0
4572744 2223015 2223015 defendant Bernard John maltman 667058 667058 Bernard, John, of Blounham, maltman 1
4583764 2226338 2226338 plaintiff Fynch John   667058 667058 Fynch, John, of Blounham 0
4591574 2228725 2228725 defendant Bocher John   667058 667058 Bocher, John, of Blounham 0
4604515 2232578 2232578 defendant Bernard Robert   667058 667058 Bernard, Robert, of Blounham 0
4622283 2237950 2237950 defendant Denyas John   667058 667058 Denyas, John, of Blounham 0
4622290 2237951 2237951 defendant Denyas John   667058 667058 Denyas, John, of Blounham 0
4648593 2245643 2245643 defendant Bocher John   667058 667058 Bocher, John, of Blounham 0
4654402 2247250 2247250 defendant Skachard John laborer 667058 667058 Skachard, John, of Blounham, laborer 1
4729472 2274429 2274429 defendant Bocher John butcher 667058 667058 Bocher, John, of Blounham, butcher 0
4742676 2278367 2278367 defendant More Robert, junior loder 667058 667058 More, Robert, junior, of Blounham, loder 0
4748976 2280185 2280185 defendant Hnede Richard chaplain 667058 667058 Hnede, Richard, of Blounham, chaplain 0
4748977 2280185 2280185 defendant Denyas William chaplain 667058 667058 Denyas, William, of Blounham, chaplain 1
4771965 2287204 2287204 defendant Bocher John butcher 667058 667058 Bocher, John, of Blounham, butcher 0
4772669 2287423 2287423 plaintiff Stepyng Mathew husbandman 667058 667058 Stepyng, Mathew, of Blounham, husbandman 0
4779648 2289622 2289622 defendant Ussher Thomas miller 667058 667058 Ussher, Thomas, of Blounham, miller 0
4788335 2292421 2292421 defendant Denyas John husbandman 667058 667058 Denyas, John, of Blounham, husbandman 4
4818205 2301770 2301770 defendant Passelewe John husbandman 667058 667058 Passelewe, John, of Blounham, husbandman 0
4822596 2303143 2303143 defendant Devyas John butcher 667058 667058 Devyas, John, of Blounham, butcher 0
4823382 2303400 2303400 defendant Awbrey John fisher 667058 667058 Awbrey, John, of Blounham, fisher 0
4832333 2306145 2306145 defendant Stepyng Mathew   667058 667058 Stepyng, Mathew, of Blounham 0
4859240 2314265 2314265 defendant Stepyng Mathew yeoman 667058 667058 Stepyng, Mathew, of Blounham, yeoman 0
4873246 2318584 2318584 defendant Stepyng Mathew yeoman 667058 667058 Stepyng, Mathew, of Blounham, yeoman 0
4888178 2323108 2323108 defendant More Robert maltman 667058 667058 More, Robert, of Blounham, maltman 0
4894038 2324836 2324836 defendant Passelewe John husbandman 667058 667058 Passelewe, John, of Blounham, husbandman 0
4905726 2328392 2328392 defendant Curteys John husbandman 667058 667058 Curteys, John, of Blounham, husbandman 0
4917050 2331840 2331840 defendant Denyas Robert husbandman 667058 667058 Denyas, Robert, of Blounham, husbandman 0
4934630 2337224 2337224 defendant Devyas Robert butcher 667058 667058 Devyas, Robert, of Blounham, butcher 0
4934631 2337224 2337224 defendant Lord William husbandman 667058 667058 Lord, William, of Blounham, husbandman 1
4963659 2346042 2346042 defendant Devyas Robert butcher 667058 667058 Devyas, Robert, of Blounham, butcher 0
4976642 2349972 2349972 defendant of Ware john chapman 667058 667058 of Ware, john, of Blounham, chapman 1
4976643 2349972 2349972 defendant Navesby William husbandman 667058 667058 Navesby, William, of Blounham, husbandman 2
4981264 2351319 2351319 defendant Boteler William husbandman 667058 667058 Boteler, William, of Blounham, husbandman 0
4981266 2351319 2351319 defendant Devyas Robert husbandman 667058 667058 Devyas, Robert, of Blounham, husbandman 2
4981267 2351319 2351319 defendant Breton Robert husbandman 667058 667058 Breton, Robert, of Blounham, husbandman 3
4981268 2351319 2351319 defendant Breton John husbandman 667058 667058 Breton, John, of Blounham, husbandman 4
4981269 2351319 2351319 defendant Raulyn Walter husbandman 667058 667058 Raulyn, Walter, of Blounham, husbandman 5
4981647 2351427 2351427 defendant Bocher Robert butcher 667058 667058 Bocher, Robert, of Blounham, butcher 0
4981650 2351427 2351427 defendant Botiller William yeoman 667058 667058 Botiller, William, of Blounham, yeoman 3
4983560 2352000 2352000 defendant Warner Walter yeoman 667058 667058 Warner, Walter, of Blounham, yeoman 1
4986525 2352898 2352898 defendant Deneas Robert bucher 667058 667058 Deneas, Robert, of Blounham, bucher 0
4986526 2352898 2352898 defendant Lorde William husbandman 667058 667058 Lorde, William, of Blounham, husbandman 1
5013594 2360820 2360820 defendant Anger or Auger Robert butcher 667058 667058 Anger or Auger, Robert, of Blounham, butcher 0
5013595 2360820 2360820 defendant Debyas or Devyas Robert butcher 667058 667058 Debyas or Devyas, Robert, of Blounham, butcher 1
5013596 2360820 2360820 defendant Lorde William butcher 667058 667058 Lorde, William, of Blounham, butcher 2
5023860 2363891 2363891 defendant Bocher Robert butcher 667058 667058 Bocher, Robert, of Blounham, butcher 0
5060973 2374853 2374853 defendant Devyas Robert butcher 667058 667058 Devyas, Robert, of Blounham, butcher 0
5068063 2376952 2376952 defendant Ware John husbandman 667058 667058 Ware, John, of Blounham, husbandman 1
5068064 2376952 2376952 defendant Navysby William husbandman 667058 667058 Navysby, William, of Blounham, husbandman 2
5068068 2376953 2376953 defendant Warde John husbandman 667058 667058 Warde, John, of Blounham, husbandman 1
5068069 2376953 2376953 defendant Navysby William husbandman 667058 667058 Navysby, William, of Blounham, husbandman 2
5069352 2377325 2377325 plaintiff Norys William chapman 667058 667058 Norys, William, of Blounham, chapman 1
5083681 2381620 2381620 defendant Smyth William smith 667058 667058 Smyth, William, of Blounham, smith 1
5204411 2417039 2417039 plaintiff Est John   667058 667058 Est, John, of Blounham 0
5207182 2417840 2417840 defendant Ferthyng Thomas smith 667058 667058 Ferthyng, Thomas, of Blounham, smith 1
5291722 2442586 2442586 defendant Tayllour Nicholas tailor 667058 667058 Tayllour, Nicholas, of Blounham, tailor 2
5291723 2442586 2442586 defendant Thommes Robert yeoman 667058 667058 Thommes, Robert, of Blounham, yeoman 3
5295236 2443598 2443598 defendant Fuller John tucker 667058 667058 Fuller, John, of Blounham, tucker 2
5330839 2454297 2454297 defendant Longe Lawrence schoolmaster 667058 667058 together with Longe, Lawrence, of Blounham, schoolmaster 2
5330844 2454298 2454298 defendant Longe Lawrence schoolmaster 667058 667058 together with Longe, Lawrence, of Blounham, schoolmaster 2
5600097 2534914 2534914 defendant Wyllyams Ralph pulter 667058 667058 Wyllyams, Ralph, of Blounham, pulter 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);