names

51 rows where place_id = 588238

✎ 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
3593812 1865705 1865705 defendant Norres Robert yeoman 588238 588238 Norres, Robert, of Herford, yeoman 0
3645551 1909005 1909005 defendant Busshop Thomas armorer 588238 588238 Busshop, Thomas, of Herford, armorer 2
3713593 1930562 1930562 defendant Chalys William yoman 588238 588238 (Chalys, William, of Herford, yoman 1
3760030 1945134 1945134 defendant Plome Richard husbandman 588238 588238 Plome, Richard, of Herford, husbandman 0
3760032 1945134 1945134 defendant Hampton John husbandman 588238 588238 Hampton, John, of Herford, husbandman 2
3771728 1948859 1948859 defendant Phylypp John husbandman 588238 588238 Phylypp, John, of Herford, husbandman 0
3808633 1960579 1960579 defendant Vynche John husbandman 588238 588238 Vynche, John, of Herford, husbandman 0
3833690 1968466 1968466 defendant Coke John husbandman 588238 588238 Coke, John, of Herford, husbandman 0
3838711 1970035 1970035 defendant Thorley William, senior husbandman 588238 588238 Thorley, William, senior, of Herford, husbandman 0
3872641 1981066 1981066 defendant Wedecomb Henry weaver 588238 588238 Wedecomb, Henry, of Herford, weaver 0
3881072 1983941 1983941 plaintiff Rowe Robert husbandman 588238 588238 Rowe, Robert, of Herford, husbandman 0
3881074 1983941 1983941 defendant Huett John husbandman 588238 588238 Huett, John, of Herford, husbandman 1
3881076 1983941 1983941 defendant Toker Simon husbandman 588238 588238 Toker, Simon, of Herford, husbandman 3
4604545 2232587 2232587 defendant Munmouthe William   588238 588238 Munmouthe, William, of Herford 0
4620984 2237546 2237546 plaintiff Kewe William chapman 588238 588238 Kewe, William, of Herford, chapman 0
4624910 2238762 2238762 defendant Everard William   588238 588238 Everard, William, of Herford 3
4637937 2242632 2242632 defendant Bury Richard   588238 588238 Bury, Richard, of Herford 3
4640101 2243223 2243223 defendant Monke Roger   588238 588238 Monke, Roger, of Herford 0
4672315 2256991 2256991 defendant Bate William husbandman 588238 588238 Bate, William, of Herford, husbandman 2
4675010 2257793 2257793 defendant Darter Ralph carpenter 588238 588238 Darter, Ralph, of Herford, carpenter 2
4738232 2277052 2277052 plaintiff Draper Richard   588238 588238 Draper, Richard, of Herford 3
4749955 2280460 2280460 plaintiff Pockelyngton John   588238 588238 Pockelyngton, John, of Herford, on his own account 0
4760197 2283539 2283539 defendant Grede John clerk 588238 588238 Grede, John, of Herford, clerk 0
4770428 2286721 2286721 defendant Byrslaunce Thomas tailor 588238 588238 Byrslaunce, Thomas, of Herford, tailor 0
4770436 2286725 2286725 defendant Madyngley John yeoman 588238 588238 Madyngley, John, of Herford, yeoman 0
4820063 2302352 2302352 defendant Paston John, junior butcher 588238 588238 Paston, John, junior, of Herford, butcher 1
4867978 2316952 2316952 defendant Wedoweson John chapman 588238 588238 Wedoweson, John, of Herford, chapman 0
4873319 2318608 2318608 defendant Ronnall or Rounall John husbandman 588238 588238 Ronnall or Rounall, John, of Herford, husbandman 0
4880902 2320934 2320934 defendant Wodham Henry husbandman 588238 588238 Wodham, Henry, of Herford, husbandman 0
4888881 2323308 2323308 defendant Heygne or Heygue John carpenter 588238 588238 Heygne or Heygue, John, of Herford, carpenter 0
4888882 2323308 2323308 defendant Colvyle John husbandman 588238 588238 Colvyle, John, of Herford, husbandman 1
4915416 2331327 2331327 defendant Hull Thomas bayler or gayler 588238 588238 Hull, Thomas, of Herford, bayler or gayler 0
4926017 2334567 2334567 defendant Hore John skinner 588238 588238 Hore, John, of Herford, skinner 0
4936240 2337733 2337733 defendant Chenelleston or Chevelleston William husbandman 588238 588238 Chenelleston or Chevelleston, William, of Herford, husbandman 2
5024127 2363965 2363965 defendant Mede Robert husbandman 588238 588238 Mede, Robert, of Herford, husbandman 0
5024128 2363965 2363965 defendant atte Mede John husbandman 588238 588238 atte Mede, John, of Herford, husbandman 1
5028463 2365197 2365197 defendant Gyles William husbandman 588238 588238 Gyles, William, of Herford, husbandman 0
5029652 2365541 2365541 defendant Heyne John   588238 588238 Heyne, John, of Herford, wright 0
5084892 2381988 2381988 defendant Derte Henry husbandman 588238 588238 Derte, Henry, of Herford, husbandman 0
5200205 2415818 2415818 defendant Marke John   588238 588238 Marke, John, of Herford, mill ward 2
5211391 2419065 2419065 defendant Marke John   588238 588238 Marke, John, of Herford, mill ward 2
5263201 2434236 2434236 defendant Kyng John husbandman 588238 588238 Kyng, John, of Herford, husbandman 1
5364580 2464582 2464582 defendant Norys Robert husbandman 588238 588238 Norys, Robert, of Herford, husbandman 3
5406418 2476908 2476908 defendant Marmtyn John laborer 588238 588238 Marmtyn, John, of Herford, laborer 5
5419514 2480755 2480755 defendant Martyn John laborer 588238 588238 Martyn, John, of Herford, laborer 5
5452042 2490491 2490491 defendant Martyn John llaborer 588238 588238 Martyn, John, of Herford, llaborer 5
5487090 2501034 2501034 defendant Martyn John laborer 588238 588238 Martyn, John, of Herford, laborer 5
5513893 2509197 2509197 defendant Teke John clerk 588238 588238 Teke, John, of Herford, clerk 1
5577394 2527988 2527988 defendant Helmore Roger husbandman 588238 588238 Helmore, Roger, of Herford, husbandman 1
5577544 2528039 2528039 defendant Scobell Vincent husbandman 588238 588238 Scobell, Vincent, of Herford, husbandman 0
5625889 2552047 2552047 defendant atte Halle John ploughman 588238 588238 atte Halle, John, of Herford, ploughman 2

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);