names

61 rows where place_id = 746603

✎ 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
4373233 2155494 2155494 defendant Sympson James gent 746603 746603 Sympson, James, of Midelton, gent 1
4427309 2173375 2173375 defendant Stillyngton William de   746603 746603 Stillyngton, William de, of Midelton 3
4427311 2173375 2173375 defendant Netehird Thomas   746603 746603 Netehird, Thomas, of Midelton 5
4427313 2173375 2173375 defendant Wodecok Alexander   746603 746603 Wodecok, Alexander, of Midelton 7
4428697 2173780 2173780 defendant Daukynes William   746603 746603 Daukynes, William, of Midelton, son of John 0
4430459 2174301 2174301 defendant del Yate Adam   746603 746603 del Yate, Adam, of Midelton 6
4436577 2176177 2176177 defendant Hod Adam   746603 746603 Hod, Adam, of Midelton 0
4441354 2182232 2182232 plaintiff Bordelby Edmund   746603 746603 Bordelby, Edmund, of Midelton 0
4447306 2184063 2184063 defendant Ravenssone John   746603 746603 Ravenssone, John, of Midelton, son of Willia 0
4447307 2184063 2184063 defendant del More Thomas   746603 746603 del More, Thomas, of Midelton 1
4447678 2184195 2184195 defendant Cave John de   746603 746603 Cave, John de, of Midelton 1
4452789 2185884 2185884 defendant Brakkere William   746603 746603 Brakkere, William, of Midelton 0
4452994 2185946 2185946 defendant Ullaythorne Henry de   746603 746603 Ullaythorne, Henry de, of Midelton 0
4455127 2186603 2186603 defendant Cave or Cane John kinsman & heir of John son of Robert de Evesham 746603 746603 Cave or Cane, John, of Midelton, kinsman & heir of John son of Robert de Evesham 0
4455363 2186686 2186686 defendant Skynneres John   746603 746603 Skynneres, John, of Midelton 0
4456188 2186953 2186953 defendant Ware Richard   746603 746603 Ware, Richard, of Midelton 0
4466436 2190170 2190170 defendant atte Prioris John   746603 746603 atte Prioris, John, of Midelton 0
4469052 2190988 2190988 defendant Cave John de   746603 746603 Cave, John de, of Midelton 0
4475579 2193049 2193049 defendant Wereman William   746603 746603 Wereman, William, of Midelton 0
4480370 2194528 2194528 defendant Warde Richard   746603 746603 Warde, Richard, of Midelton 0
4487852 2196915 2196915 defendant Rossyngton John   746603 746603 Rossyngton, John, of Midelton 0
4488670 2197180 2197180 defendant Grendon John de   746603 746603 Grendon, John de, of Midelton 1
4618986 2236933 2236933 plaintiff Herle Alexander master & parson 746603 746603 Herle, Alexander, of Midelton, master & parson 0
4624423 2238623 2238623 plaintiff Neweman Maud (legal representative) 746603 746603 Neweman, Maud, of Midelton, formerly wife of Henry, executors of 0
4648532 2245624 2245624 defendant Lawerence John   746603 746603 Lawerence, John, of Midelton 0
4698590 2265034 2265034 plaintiff Dankyn or Daukyn John   746603 746603 Dankyn or Daukyn, John, of Midelton 0
4705329 2267040 2267040 plaintiff Kyng Richard   746603 746603 Kyng, Richard, of Midelton 0
4706548 2267426 2267426 plaintiff Lynge Thomas   746603 746603 Lynge, Thomas, of Midelton 0
4716682 2270538 2270538 plaintiff Wodham John clerk & parson of the parish church 746603 746603 Wodham, John, of Midelton, clerk & parson of the parish church 0
4716683 2270538 2270538 defendant Reyner John husbandman 746603 746603 Reyner, John, of Midelton, husbandman 0
4716684 2270538 2270538 defendant Bevereche Robert   746603 746603 Bevereche, Robert, of Midelton, stockfish monger 1
4747076 2279650 2279650 defendant Conyngeston James clerk 746603 746603 Conyngeston, James, of Midelton, clerk 1
4752251 2281127 2281127 defendant Kyppyng John yeoman 746603 746603 Kyppyng, John, of Midelton, yeoman 4
4784378 2291115 2291115 defendant Gamull John husbandman 746603 746603 Gamull, John, of Midelton, husbandman 0
4820620 2302522 2302522 defendant fitz William of Midelton Richard yeoman 746603 746603 fitz William of Midelton, Richard, of Midelton, yeoman 3
4827377 2304611 2304611 defendant Chesshyre John   746603 746603 Chesshyre, John, of Midelton, bailiff 0
4827379 2304611 2304611 defendant Mersshe John husbandman 746603 746603 Mersshe, John, of Midelton, husbandman 2
4842535 2309202 2309202 defendant Laurens John yeoman 746603 746603 Laurens, John, of Midelton, yeoman 1
4857132 2313613 2313613 defendant Walker Richard yeoman 746603 746603 Walker, Richard, of Midelton, yeoman 0
4862191 2315190 2315190 defendant de Haybergh William yeoman 746603 746603 de Haybergh, William, of Midelton, yeoman 0
4862192 2315190 2315190 defendant Hayber Richard yeoman 746603 746603 Hayber, Richard, of Midelton, yeoman 1
4862193 2315190 2315190 defendant Hayber James yeoman 746603 746603 Hayber, James, of Midelton, yeoman 2
4862499 2315265 2315265 defendant Thirnbek Richard yeoman 746603 746603 Thirnbek, Richard, of Midelton, yeoman 0
4862500 2315265 2315265 defendant Bonstale or Bonscale William yeoman 746603 746603 Bonstale or Bonscale, William, of Midelton, yeoman 1
4862501 2315265 2315265 defendant Thomson Robert yeoman 746603 746603 Thomson, Robert, of Midelton, yeoman 2
4862502 2315265 2315265 defendant le Lafete Lawrence yeoman 746603 746603 le Lafete, Lawrence, of Midelton, yeoman 3
4871418 2318025 2318025 defendant Hungate John yeoman 746603 746603 Hungate, John, of Midelton, yeoman 0
4871419 2318025 2318025 defendant Hungate John laborer 746603 746603 Hungate, John, of Midelton, laborer 1
4885893 2322458 2322458 defendant Chesshire John yeoman 746603 746603 Chesshire, John, of Midelton, yeoman 0
4885894 2322458 2322458 defendant Scot Henry husbandman 746603 746603 Scot, Henry, of Midelton, husbandman 1
4885895 2322458 2322458 defendant Whateley John husbandman 746603 746603 Whateley, John, of Midelton, husbandman 2
4885896 2322458 2322458 defendant Stacy John husbandman 746603 746603 Stacy, John, of Midelton, husbandman 3
4899040 2326341 2326341 defendant Scotte Henry husbandman 746603 746603 Scotte, Henry, of Midelton, husbandman 1
4909515 2329512 2329512 defendant Spencer Henry chaplain 746603 746603 Spencer, Henry, of Midelton, chaplain 1
4910478 2329790 2329790 defendant Prentys Simon husbandman 746603 746603 Prentys, Simon, of Midelton, husbandman 2
4962308 2345628 2345628 defendant Hastyng Thomas chaplain 746603 746603 Hastyng, Thomas, of Midelton, chaplain 0
5064483 2375918 2375918 defendant Mansergh John gent 746603 746603 Mansergh, John, of Midelton, gent 0
5064926 2376042 2376042 defendant Bernard Ralph yeoman 746603 746603 Bernard, Ralph, of Midelton, yeoman 0
5064927 2376042 2376042 defendant Hoberd Thomas yeoman 746603 746603 Hoberd, Thomas, of Midelton, yeoman 1
5121036 2392582 2392582 defendant Huberd Thomas yeoman 746603 746603 Huberd, Thomas, of Midelton, yeoman 0
5636150 2555258 2555258 defendant Baumford John laborer 746603 746603 Baumford, John, of Midelton, laborer 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);