names

63 rows where place_id = 611766

✎ 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
3689963 1923020 1923020 defendant Hode Edward husbandman 611766 611766 Hode, Edward, of Battle, husbandman 0
3698045 1925616 1925616 defendant Faxwell Clement yeoman 611766 611766 Faxwell, Clement, of Battle, yeoman 0
3709382 1929232 1929232 defendant Swane Robert yeoman 611766 611766 Swane, Robert, of Battle, yeoman 0
3775844 1950196 1950196 defendant Ynold William clerk 611766 611766 Ynold, William, of Battle, clerk 0
3853656 1974773 1974773 defendant Badcok Thomas yeoman 611766 611766 Badcok, Thomas, of Battle, yeoman 0
3875644 1982098 1982098 defendant Benecke John, junior husbandman 611766 611766 Benecke, John, junior, of Battle, husbandman 0
3987930 2020429 2020429 plaintiff Alfrey Thomas yeoman 611766 611766 Alfrey, Thomas, of Battle, yeoman 0
3987932 2020430 2020430 plaintiff Alfrey Thomas yeoman 611766 611766 Alfrey, Thomas, of Battle, yeoman 0
4008666 2027862 2027862 plaintiff Morebred John yeoman 611766 611766 Morebred, John, of Battle, yeoman 0
4063455 2047219 2047219 plaintiff Gilbert John   611766 611766 Gilbert, John, of Battle yeoman 0
4073648 2050867 2050867 plaintiff Porter Richard yeoman 611766 611766 Porter, Richard, of Battle, yeoman 0
4143874 2076021 2076021 defendant Sycle or Sytle Lawrence yeoman 611766 611766 Sycle or Sytle , Lawrence, of Battle, yeoman 0
4433160 2175125 2175125 plaintiff Ferour Joicius   611766 611766 Ferour, Joicius, of Battle 0
4578944 2224894 2224894 defendant Copyn John   611766 611766 Copyn, John, of Battle 0
4624801 2238738 2238738 defendant Norton John   611766 611766 Norton, John, of Battle 0
4739222 2277359 2277359 defendant Nortone John husbandman 611766 611766 Nortone, John, of Battle, husbandman 0
4743874 2278737 2278737 plaintiff de Ludlow Thomas   611766 611766 de Ludlow, Thomas, of Battle, abbot of St Martin's abbey 0
4769649 2286484 2286484 defendant Dowenyng John laborer 611766 611766 Dowenyng, John, of Battle, laborer 2
4777143 2288834 2288834 plaintiff atte Dowene William   611766 611766 atte Dowene, William, of Battle 0
4794146 2294305 2294305 defendant Dowenynge John laborer 611766 611766 Dowenynge, John, of Battle, laborer 2
4802745 2297043 2297043 plaintiff atte Doune William   611766 611766 atte Doune, William, of Battle 0
4822843 2303228 2303228 defendant Curret John   611766 611766 Curret, John, of Battle 0
4831351 2305836 2305836 plaintiff Brod_ Thomas   611766 611766 Brod_, Thomas, of Battle 0
4845335 2310053 2310053 defendant Broune Thomas gent 611766 611766 Broune, Thomas, of Battle, gent 0
4860214 2314554 2314554 defendant atte Melle Edmund tailor 611766 611766 atte Melle, Edmund, of Battle, tailor 1
4878349 2320175 2320175 defendant Gylys Thomas baker 611766 611766 Gylys, Thomas, of Battle, baker 0
4909033 2329367 2329367 defendant Bartelot Richard carpenter 611766 611766 Bartelot, Richard, of Battle, carpenter 0
4934379 2337144 2337144 defendant Downe John husbandman 611766 611766 Downe, John, of Battle, husbandman 0
4938924 2338564 2338564 defendant Dyne or Dyve John cordwainer 611766 611766 Dyne or Dyve, John, of Battle, cordwainer 1
4940624 2339095 2339095 defendant Hogge Robert husbandman 611766 611766 Hogge, Robert, of Battle, husbandman 0
4977314 2350174 2350174 defendant Smyth Richard (legal representative) 611766 611766 Smyth, Richard, of Battle, smith, executors of 0
4980870 2351212 2351212 defendant Miller Richard laborer 611766 611766 Miller, Richard, of Battle, laborer 0
5000002 2356882 2356882 plaintiff Clere Robert   611766 611766 Clere, Robert, of Battle 2
5000267 2356955 2356955 defendant Clere Robert clerk 611766 611766 Clere, Robert, of Battle, clerk 0
5004311 2358153 2358153 defendant Smyth Gillian   611766 611766 Smyth, Gillian, of Battle, widow, formerly wife of Richard Smyth 3
5012401 2360477 2360477 defendant Whiteberd Nicholas husbandman 611766 611766 Whiteberd, Nicholas, of Battle, husbandman 0
5012403 2360477 2360477 defendant Whiteberd Henry   611766 611766 Whiteberd, Henry, of Battle, servant 2
5012404 2360477 2360477 defendant William Robert husbandman 611766 611766 William, Robert, of Battle, husbandman 3
5027045 2364780 2364780 defendant Clere Robert clerk 611766 611766 Clere, Robert, of Battle, clerk 0
5067504 2376779 2376779 defendant Mylle John draper 611766 611766 Mylle, John, of Battle, draper 1
5125375 2393903 2393903 defendant Halle John tailor 611766 611766 Halle, John, of Battle, tailor 0
5143968 2399380 2399380 defendant Halle John tailor 611766 611766 Halle, John, of Battle, tailor 0
5164989 2405498 2405498 defendant Halle John tailor 611766 611766 Halle, John, of Battle, tailor 0
5217610 2420890 2420890 defendant Lucas John husbandman 611766 611766 Lucas, John, of Battle, husbandman 7
5236189 2426172 2426172 defendant Tasser Thomas wheeler 611766 611766 Tasser, Thomas, of Battle, wheeler 2
5236190 2426172 2426172 defendant Fayrman Robert laborer 611766 611766 Fayrman, Robert, of Battle, laborer 3
5236192 2426172 2426172 defendant Boys Richard laborer 611766 611766 Boys, Richard, of Battle, laborer 5
5236193 2426172 2426172 defendant A Mell Alan laborer 611766 611766 A Mell, Alan, of Battle, laborer 6
5236194 2426172 2426172 defendant Wodesell John weaver 611766 611766 Wodesell, John, of Battle, weaver 7
5251728 2430646 2430646 defendant Pittys John clerk 611766 611766 Pittys, John, of Battle, clerk 0
5273810 2437417 2437417 plaintiff Newton John   611766 611766 Newton, John, of Battle, abbot of the monastery of St Martin 0
5321409 2451497 2451497 plaintiff Lone or Love John (legal representative) 611766 611766 Lone or Love, John, of Battle, executors of 0
5321416 2451498 2451498 plaintiff Lone or Love John (legal representative) 611766 611766 Lone or Love, John, of Battle, executors of 0
5363509 2464239 2464239 defendant Parker William draper 611766 611766 Parker, William, of Battle, draper 0
5374222 2467538 2467538 plaintiff Newton John   611766 611766 Newton, John, of Battle, Abbot of the Monastery of St Martin 0
5374225 2467539 2467539 plaintiff Newton John   611766 611766 Newton, John, of Battle, Abbot of the Monastery of St Martin 0
5374227 2467540 2467540 plaintiff Newton John   611766 611766 Newton, John, of Battle, Abbot of the Monastery of St Martin 0
5383982 2470507 2470507 defendant Mille Alan husbandman 611766 611766 Mille, Alan, of Battle, husbandman 0
5383983 2470507 2470507 defendant Cokesham Robert husbandman 611766 611766 Cokesham, Robert, of Battle, husbandman 1
5383984 2470507 2470507 defendant Boys Richard laborer 611766 611766 Boys, Richard, of Battle, laborer 2
5562208 2523545 2523545 defendant Vynawe Richard tailor 611766 611766 Vynawe, Richard, of Battle, tailor 0
5562209 2523545 2523545 defendant Notyngham Robert butcher 611766 611766 Notyngham, Robert, of Battle, butcher 1
5607913 2537380 2537380 plaintiff Love or Lone William   611766 611766 Love or Lone, William, of Battle 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);