names

71 rows where place_id = 753984

✎ 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
4417254 2170279 2170279 plaintiff Ryngebourne William de   753984 753984 Ryngebourne, William de, of the Isle of Wight 0
4424002 2172360 2172360 plaintiff Heyne John   753984 753984 Heyne, John, of the Isle of Wight, knight 0
4438358 2181293 2181293 defendant Braina Peter   753984 753984 Braina, Peter, of the Isle of Wight 0
4458327 2187643 2187643 plaintiff Quard or Buard Adam   753984 753984 Quard or Buard, Adam, of the Isle of Wight 0
4458328 2187643 2187643 defendant Wegge Robert   753984 753984 Wegge, Robert, of the Isle of Wight 0
4458331 2187643 2187643 defendant atte Welle Richard   753984 753984 atte Welle, Richard, of the Isle of Wight 3
4463109 2189164 2189164 defendant Yonge John   753984 753984 Yonge, John, of the Isle of Wight 5
4465387 2189847 2189847 defendant Herward Richard   753984 753984 Herward, Richard, of the Isle of Wight 0
4474869 2192808 2192808 defendant Waye Robert   753984 753984 Waye, Robert, of the Isle of Wight 0
4482639 2195275 2195275 defendant Bryan Peter   753984 753984 Bryan, Peter, of the Isle of Wight 0
4486464 2196476 2196476 defendant Hunte Richard weaver 753984 753984 Hunte, Richard, of the Isle of Wight, weaver 0
4491699 2198091 2198091 plaintiff Wolverton Ralph   753984 753984 Wolverton, Ralph, of the Isle of Wight 0
4491700 2198091 2198091 defendant Bryan Peter   753984 753984 Bryan, Peter, of the Isle of Wight 0
4491702 2198092 2198092 plaintiff Wolverton Thomas chaplain 753984 753984 Wolverton, Thomas, of the Isle of Wight, chaplain 0
4495081 2199149 2199149 defendant Tauk Thomas   753984 753984 Tauk, Thomas, of the Isle of Wight 0
4496522 2199587 2199587 defendant Langele John   753984 753984 Langele, John, of the Isle of Wight 0
4509834 2203563 2203563 defendant Taukes Thomas   753984 753984 Taukes, Thomas, of the Isle of Wight 0
4517549 2205885 2205885 defendant Curteney John   753984 753984 Curteney, John, of the Isle of Wight, son of John 0
4519167 2206347 2206347 defendant atte Doune Henry   753984 753984 atte Doune, Henry, of the Isle of Wight 3
4528854 2209304 2209304 defendant Lyndesey Thomas   753984 753984 Lyndesey, Thomas, of the Isle of Wight 2
4533929 2210880 2210880 defendant Gloos John   753984 753984 Gloos, John, of the Isle of Wight 0
4539578 2212636 2212636 defendant Russell Thomas   753984 753984 Russell, Thomas, of the Isle of Wight 0
4547242 2215070 2215070 defendant Brouke William   753984 753984 Brouke, William, of the Isle of Wight 2
4547243 2215070 2215070 defendant Pyccher John   753984 753984 Pyccher, John, of the Isle of Wight 3
4549155 2215672 2215672 defendant Peche John tailor 753984 753984 (Peche, John, of the Isle of Wight, tailor 1
4552530 2216744 2216744 defendant Yerder Richard (legal representative) 753984 753984 Yerder, Richard, of the Isle of Wight, executors of 5
4553899 2217139 2217139 plaintiff Godeshull Henry (legal representative) 753984 753984 Godeshull, Henry, of the Isle of Wight, executors of 0
4558174 2218498 2218498 defendant Waye Walter   753984 753984 Waye, Walter, of the Isle of Wight 0
4563965 2220302 2220302 defendant Gloos John   753984 753984 Gloos, John, of the Isle of Wight 0
4568461 2221708 2221708 plaintiff Veer John   753984 753984 Veer, John, of the Isle of Wight 0
4569204 2221956 2221956 defendant Martyn John   753984 753984 Martyn, John, of the Isle of Wight 0
4569209 2221957 2221957 defendant Martyn John   753984 753984 Martyn, John, of the Isle of Wight 0
4572509 2222936 2222936 defendant Borard Thomas   753984 753984 Borard, Thomas, of the Isle of Wight 3
4572807 2223032 2223032 defendant Hayward Thomas   753984 753984 Hayward, Thomas, of the Isle of Wight 0
4575977 2223981 2223981 defendant Middelmerssh Thomas   753984 753984 Middelmerssh, Thomas, of the Isle of Wight 0
4576030 2223997 2223997 defendant Bostelman John   753984 753984 Bostelman, John, of the Isle of Wight 0
4578362 2224721 2224721 defendant Wyker John   753984 753984 Wyker, John, of the Isle of Wight 2
4578363 2224721 2224721 defendant Clere Walter   753984 753984 Clere, Walter, of the Isle of Wight 3
4579914 2225206 2225206 defendant Bolle Thomas   753984 753984 Bolle, Thomas, of the Isle of Wight 0
4582697 2226029 2226029 defendant Lisle Thomas   753984 753984 Lisle, Thomas, of the Isle of Wight 1
4583243 2226185 2226185 plaintiff Forthrygge John   753984 753984 Forthrygge, John, of the Isle of Wight 0
4583244 2226185 2226185 defendant Lone or Love William clerk 753984 753984 Lone or Love, William, of the Isle of Wight, clerk 0
4583485 2226258 2226258 defendant Bullok John   753984 753984 Bullok, John, of the Isle of Wight 0
4583948 2226398 2226398 defendant Clyfton Roger   753984 753984 Clyfton, Roger, of the Isle of Wight 0
4584487 2226564 2226564 plaintiff Godeshull Henry (legal representative) 753984 753984 Godeshull, Henry, of the Isle of Wight, executors of 0
4588013 2227647 2227647 defendant Stour William   753984 753984 Stour, William, of the Isle of Wight 0
4590183 2228295 2228295 plaintiff Lysle Thomas   753984 753984 Lysle, Thomas, of the Isle of Wight 0
4593464 2229243 2229243 defendant Gotkynley Richard (legal representative) 753984 753984 Gotkynley, Richard, of the Isle of Wight, executors of 1
4596402 2230124 2230124 defendant Gloce John   753984 753984 Gloce, John, of the Isle of Wight 0
4596410 2230128 2230128 defendant Mason John   753984 753984 Mason, John, of the Isle of Wight 0
4596584 2230168 2230168 defendant Taunton John   753984 753984 Taunton, John, of the Isle of Wight 3
4598513 2230770 2230770 defendant (illegible) Simon   753984 753984 _, Simon, of the Isle of Wight 0
4601224 2231616 2231616 plaintiff Veer John   753984 753984 Veer, John, of the Isle of Wight 0
4601226 2231617 2231617 plaintiff Veer John   753984 753984 Veer, John, of the Isle of Wight 0
4605850 2232942 2232942 defendant Cook John   753984 753984 Cook, John, of the Isle of Wight 0
4606137 2233031 2233031 plaintiff Audele William   753984 753984 Audele, William, of the Isle of Wight 0
4616761 2236242 2236242 defendant Cordray Robert baker 753984 753984 Cordray, Robert, of the Isle of Wight, baker 2
4617139 2236369 2236369 defendant Dalton John   753984 753984 Dalton, John, of the Isle of Wight 0
4632441 2241035 2241035 defendant Auger or Anger Robert   753984 753984 Auger or Anger, Robert, of the Isle of Wight 0
4645939 2244884 2244884 defendant Tournour Nicholas   753984 753984 Tournour, Nicholas, of the Isle of Wight 4
4647136 2245216 2245216 defendant Uphill John smith 753984 753984 Uphill, John, of the Isle of Wight, smith 0
4649405 2245877 2245877 plaintiff Veer John   753984 753984 Veer, John, of the Isle of Wight 0
4649410 2245878 2245878 plaintiff Veer John   753984 753984 Veer, John, of the Isle of Wight 0
4674311 2257573 2257573 plaintiff Drewe William   753984 753984 Drewe, William, of the Isle of Wight 0
4674313 2257574 2257574 plaintiff Drewe William   753984 753984 Drewe, William, of the Isle of Wight 0
4720138 2271642 2271642 plaintiff Damelys Thomas   753984 753984 Damelys, Thomas, of the Isle of Wight 2
4723832 2272757 2272757 plaintiff Cameles John   753984 753984 Cameles, John, of the Isle of Wight 2
4724296 2272895 2272895 defendant Canon Philip yeoman 753984 753984 Canon, Philip, of the Isle of Wight, yeoman 0
4734105 2275850 2275850 defendant Cooke John   753984 753984 Cooke, John, of the Isle of Wight 0
4838179 2307864 2307864 plaintiff Gervyes John   753984 753984 Gervyes, John, of the Isle of Wight 0
5613685 2548056 2548056 plaintiff (not given) John vicar of Sampson 753984 753984 (Sampson, John, of the Isle of Wight, formerly vicar of Caresbrok church 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);