names

105 rows where place_id = 587649

✎ 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
3592042 1865126 1865126 defendant Webbe Thomas husbandman 587649 587649 Webbe, Thomas, of Wykham, husbandman 1
3608960 1870460 1870460 defendant Day Robert clerk 587649 587649 Day, Robert, of Wykham, clerk 0
3631560 1904685 1904685 defendant Stancyall Robert husbandman 587649 587649 Stancyall, Robert, of Wykham, husbandman 5
3642992 1908257 1908257 defendant Prymer Thomas husbandman 587649 587649 Prymer, Thomas, of Wykham, husbandman 1
3642994 1908257 1908257 defendant Watson Thomas husbandman 587649 587649 Watson, Thomas, of Wykham, husbandman 3
3674090 1917936 1917936 defendant Blynd William yeoman 587649 587649 Blynd, William, of Wykham, yeoman 3
3678207 1919237 1919237 defendant Wylson Richard chaplain 587649 587649 Wylson, Richard, of Wykham, chaplain 1
3681506 1920307 1920307 defendant Appelford William husbandman 587649 587649 Appelford, William, of Wykham, husbandman 0
3720518 1932699 1932699 plaintiff Husse James gent 587649 587649 Husse, James, of Wykham, gent 0
3720519 1932699 1932699 defendant Burges Thomas gent 587649 587649 Burges, Thomas, of Wykham, gent 0
3752034 1942557 1942557 defendant Crystmas Robert husbandman 587649 587649 Crystmas, Robert, of Wykham, husbandman 0
3860868 1977128 1977128 defendant Roger William shoemaker 587649 587649 Roger, William, of Wykham, shoemaker 1
3861049 1977178 1977178 defendant Estgate Henry husbandman 587649 587649 Estgate, Henry, of Wykham, husbandman 1
3861052 1977179 1977179 defendant Estgate Henry husbandman 587649 587649 Estgate, Henry, of Wykham, husbandman 1
3907504 1992805 1992805 plaintiff Parson Thomas   587649 587649 Parson, Thomas, of Wykham 0
4414115 2169320 2169320 defendant Kendale John de   587649 587649 Kendale, John de, of Wykham 0
4429812 2174109 2174109 plaintiff West Robert   587649 587649 (West, Robert, of Wykham, son of Geoffrey 1
4451226 2185342 2185342 defendant Cook John   587649 587649 Cook, John, of Wykham 0
4452449 2185761 2185761 defendant Rydhod Peter   587649 587649 Rydhod, Peter, of Wykham 3
4456917 2187175 2187175 defendant Derby Thomas   587649 587649 Derby, Thomas, of Wykham 0
4461140 2188562 2188562 defendant Derby Thomas   587649 587649 Derby, Thomas, of Wykham 0
4467959 2190657 2190657 plaintiff Cook John   587649 587649 Cook, John, of Wykham 4
4467970 2190659 2190659 plaintiff Cooke John   587649 587649 Cooke, John, of Wykham 4
4467982 2190661 2190661 plaintiff Cook John   587649 587649 Cook, John, of Wykham 4
4467990 2190662 2190662 plaintiff Cook John   587649 587649 Cook, John, of Wykham 4
4475056 2192867 2192867 defendant Beeroe or Beere John   587649 587649 Beeroe or Beere, John, of Wykham 0
4481263 2194825 2194825 plaintiff Longe John, junior   587649 587649 Longe, John, junior, of Wykham 0
4497117 2199758 2199758 plaintiff del Seler John   587649 587649 del Seler, John, of Wykham, on his own account 0
4500062 2200665 2200665 defendant Whte John   587649 587649 Whte, John, of Wykham 0
4500063 2200665 2200665 defendant atte Hulle William   587649 587649 atte Hulle, William, of Wykham 1
4504246 2201881 2201881 defendant Hadeleye John   587649 587649 Hadeleye, John, of Wykham 1
4506311 2202474 2202474 defendant Pirye Robert   587649 587649 Pirye, Robert, of Wykham 2
4535424 2211352 2211352 plaintiff Skynnere Robert   587649 587649 Skynnere, Robert, of Wykham 0
4535426 2211352 2211352 defendant Bakstere Benedict   587649 587649 Bakstere, Benedict, of Wykham 1
4545446 2214498 2214498 defendant Rande John   587649 587649 Rande, John, of Wykham 4
4568695 2221792 2221792 defendant Monghom John   587649 587649 Monghom, John, of Wykham 0
4579892 2225199 2225199 defendant Lechour William   587649 587649 Lechour, William, of Wykham 0
4580476 2225378 2225378 defendant Champeneys Thomas   587649 587649 Champeneys, Thomas, of Wykham 0
4583035 2226118 2226118 plaintiff fitz Watyr Richard   587649 587649 fitz Watyr, Richard, of Wykham 0
4583037 2226119 2226119 plaintiff fitz Watyr Richard   587649 587649 fitz Watyr, Richard, of Wykham 0
4585276 2226819 2226819 plaintiff Hadeleye John   587649 587649 Hadeleye, John, of Wykham 0
4634379 2241597 2241597 defendant Bocher Robert   587649 587649 Bocher, Robert, of Wykham 1
4658084 2248409 2248409 defendant Bogat John husbandman 587649 587649 Bogat, John, of Wykham, husbandman 1
4663047 2249908 2249908 defendant Plomer John yeoman 587649 587649 Plomer, John, of Wykham, yeoman 0
4677244 2258500 2258500 defendant Skynner Thomas skinner 587649 587649 Skynner, Thomas, of Wykham, skinner 1
4701166 2265771 2265771 defendant Reyner William husbandman 587649 587649 Reyner, William, of Wykham, husbandman 0
4701167 2265771 2265771 defendant Reyner Richard husbandman 587649 587649 Reyner, Richard, of Wykham, husbandman 1
4701171 2265772 2265772 defendant Reyner William husbandman 587649 587649 Reyner, William, of Wykham, husbandman 2
4701172 2265772 2265772 defendant Reyner Richard husbandman 587649 587649 Reyner, Richard, of Wykham, husbandman 3
4724285 2272892 2272892 defendant Wryght Simon husbandman 587649 587649 Wryght, Simon, of Wykham, husbandman 0
4724288 2272893 2272893 defendant Wryght Simon husbandman 587649 587649 Wryght, Simon, of Wykham, husbandman 0
4727158 2273755 2273755 plaintiff Haynton John   587649 587649 Haynton, John, of Wykham 0
4734755 2276025 2276025 defendant Smyth Richard smith 587649 587649 Smyth, Richard, of Wykham, smith 0
4757491 2282720 2282720 defendant Herberd William smith 587649 587649 Herberd, William, of Wykham, smith 1
4758567 2283057 2283057 defendant Goldwell John husbandman 587649 587649 Goldwell, John, of Wykham, husbandman 0
4780826 2290001 2290001 defendant Goldwell John husbandman 587649 587649 Goldwell, John, of Wykham, husbandman 0
4790148 2293000 2293000 defendant Julyan Thomas husbandman 587649 587649 Julyan, Thomas, of Wykham, husbandman 0
4790149 2293000 2293000 defendant Strutte William husbandman 587649 587649 Strutte, William, of Wykham, husbandman 1
4794545 2294433 2294433 defendant Baker Richard yeoman 587649 587649 Baker, Richard, of Wykham, yeoman 0
4801728 2296721 2296721 defendant Dodele John   587649 587649 Dodele, John, of Wykham, millward 2
4824839 2303806 2303806 defendant Palmere Thomas chaplain 587649 587649 Palmere, Thomas, of Wykham, chaplain 0
4824840 2303806 2303806 defendant Reyner John husbandman 587649 587649 Reyner, John, of Wykham, husbandman 1
4824841 2303806 2303806 defendant Marchaunt Richard husbandman 587649 587649 Marchaunt, Richard, of Wykham, husbandman 2
4830024 2305437 2305437 defendant Westepale Isabel   587649 587649 Westepale, Isabel, of Wykham, prioress 0
4835636 2307137 2307137 defendant Styxll Edward   587649 587649 Styxll, Edward, of Wykham, brass worker 0
4835694 2307159 2307159 defendant Styyll Edward   587649 587649 Styyll, Edward, of Wykham, brass worker 0
4836489 2307390 2307390 defendant atte John Nasshe   587649 587649 atte John, Nasshe, of Wykham 5
4836503 2307391 2307391 defendant atte Nasshe John   587649 587649 atte Nasshe, John, of Wykham 5
4840900 2308690 2308690 defendant White William laborer 587649 587649 White, William, of Wykham, laborer 0
4840901 2308690 2308690 defendant Clenche Nicholas laborer 587649 587649 Clenche, Nicholas, of Wykham, laborer 1
4844549 2309815 2309815 defendant Skynner John husbandman 587649 587649 Skynner, John, of Wykham, husbandman 0
4848536 2311017 2311017 defendant Payne Thomas husbandman 587649 587649 Payne, Thomas, of Wykham, husbandman 0
4866928 2316619 2316619 plaintiff Hawekyns Thomas (legal representative) 587649 587649 Hawekyns, Thomas, of Wykham, executor of 0
4872058 2318220 2318220 defendant Skynner John husbandman 587649 587649 Skynner, John, of Wykham, husbandman 0
4880715 2320878 2320878 defendant Smyth William husbandman 587649 587649 Smyth, William, of Wykham, husbandman 4
4921368 2333192 2333192 plaintiff Stapyndon John   587649 587649 Stapyndon, John, of Wykham, parson & clerk of the Hanaper 2
4927899 2335161 2335161 defendant Philipson Richard husbandman 587649 587649 Philipson, Richard, of Wykham, husbandman 1
4937397 2338066 2338066 defendant Ody John smith 587649 587649 Ody, John, of Wykham, smith 0
4964522 2346295 2346295 defendant Bury John, junior gent 587649 587649 Bury, John, junior, of Wykham, gent 0
4968463 2347535 2347535 defendant Reyner John husbandman 587649 587649 Reyner, John, of Wykham, husbandman 2
5016538 2361732 2361732 defendant Obury or Bury John, junior gent 587649 587649 Obury or Bury, John, junior, of Wykham, gent 0
5033818 2366772 2366772 defendant Naull Richard husbandman 587649 587649 Naull, Richard, of Wykham, husbandman 4
5033819 2366772 2366772 defendant Saxby William husbandman 587649 587649 Saxby, William, of Wykham, husbandman 5
5035409 2367214 2367214 defendant Reyner Thomas husbandman 587649 587649 Reyner, Thomas, of Wykham, husbandman 3
5107288 2388559 2388559 defendant Robynson James yeoman 587649 587649 Robynson, James, of Wykham, yeoman 0
5107289 2388559 2388559 defendant Gateman Margaret widow 587649 587649 Gateman, Margaret, of Wykham, widow 1
5107290 2388559 2388559 defendant Graunt John laborer 587649 587649 Graunt, John, of Wykham, laborer 2
5184777 2411297 2411297 defendant Redhode John husbandman 587649 587649 Redhode, John, of Wykham, husbandman 0
5204497 2417068 2417068 defendant Redhode John husbandman 587649 587649 Redhode, John, of Wykham, husbandman 0
5217760 2420923 2420923 defendant Hewyn Nicholas butcher 587649 587649 Hewyn, Nicholas, of Wykham, butcher 0
5221522 2421991 2421991 defendant Pope John, senior butcher 587649 587649 Pope, John, senior, of Wykham, butcher 2
5229613 2424279 2424279 defendant Heth Thomas husbandman 587649 587649 Heth, Thomas, of Wykham, husbandman 0
5246305 2429079 2429079 defendant Dale Edward yeoman 587649 587649 Dale, Edward, of Wykham, yeoman 0
5334328 2455337 2455337 defendant Cotell John tailor 587649 587649 Cotell, John, of Wykham, tailor 1
5439378 2486713 2486713 plaintiff Walker Richard   587649 587649 Walker, Richard, of Wykham 0
5454172 2491146 2491146 defendant Okeland John husbandman 587649 587649 Okeland, John, of Wykham, husbandman 2
5535266 2515559 2515559 defendant Cane or Cave John merchant 587649 587649 Cane or Cave, John, of Wykham, merchant 0
5538893 2516650 2516650 defendant Marten Robert yeoman 587649 587649 Marten, Robert, of Wykham, yeoman 0
5542053 2517645 2517645 defendant Fissher Thomas husbandman 587649 587649 Fissher, Thomas, of Wykham, husbandman 0
5560343 2522987 2522987 defendant Tukker John yeoman 587649 587649 Tukker, John, of Wykham, yeoman 2

Next page

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