names

75 rows where place_id = 598829

✎ 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
3634237 1905506 1905506 defendant Hyche John yeoman 598829 598829 Hyche, John, of Meldeburn, yeoman 1
3751076 1942265 1942265 defendant Payne William husbandman 598829 598829 Payne, William, of Meldeburn, husbandman 0
4414027 2169289 2169289 plaintiff Paunnel John   598829 598829 Paunnel, John, of Meldeburn 2
4414031 2169290 2169290 plaintiff Paynel John   598829 598829 Paynel, John, of Meldeburn 2
4436485 2176148 2176148 defendant Baldok William de   598829 598829 Baldok, William de, of Meldeburn 0
4436487 2176149 2176149 defendant Baldok William   598829 598829 Baldok, William, of Meldeburn 0
4481897 2195048 2195048 plaintiff Marchall Hamo   598829 598829 Marchall, Hamo, of Meldeburn, on his own account 0
4484218 2195763 2195763 defendant Burwell William   598829 598829 Burwell, William, of Meldeburn 0
4486243 2196405 2196405 defendant Marchall Hamo   598829 598829 Marchall, Hamo, of Meldeburn 0
4528033 2209049 2209049 plaintiff Mabely John   598829 598829 Mabely, John, of Meldeburn 0
4553497 2217024 2217024 plaintiff Gentyng John, sen   598829 598829 Gentyng, John, sen, of Meldeburn 0
4582840 2226066 2226066 plaintiff Ferour John   598829 598829 Ferour, John, of Meldeburn 1
4586712 2227249 2227249 defendant Ormesby William   598829 598829 Ormesby, William, of Meldeburn 0
4586713 2227249 2227249 defendant Payn John   598829 598829 Payn, John, of Meldeburn 1
4593479 2229247 2229247 plaintiff Payn John   598829 598829 Payn, John, of Meldeburn 0
4593516 2229256 2229256 plaintiff Payne John   598829 598829 Payne, John, of Meldeburn 0
4608158 2233664 2233664 plaintiff Bolton Thomas   598829 598829 Bolton, Thomas, of Meldeburn, vicar 0
4608160 2233664 2233664 plaintiff Payn John, sen   598829 598829 Payn, John, sen, of Meldeburn 2
4608161 2233664 2233664 plaintiff Whynnok John, sen   598829 598829 Whynnok, John, sen, of Meldeburn 3
4608162 2233664 2233664 plaintiff Aleyn William   598829 598829 Aleyn, William, of Meldeburn 4
4651356 2246425 2246425 defendant Marchall Hgh   598829 598829 Marchall, Hgh, of Meldeburn 0
4667106 2255446 2255446 defendant Ferrour John (legal representative) 598829 598829 Ferrour, John, of Meldeburn, executors of 0
4691828 2262979 2262979 plaintiff Aleyn William   598829 598829 Aleyn,William, of Meldeburn 0
4704522 2266789 2266789 defendant Marchall Hugh husbandman 598829 598829 Marchall, Hugh, of Meldeburn, husbandman 2
4710993 2268795 2268795 defendant Marchall Hugh husbandman 598829 598829 Marchall, Hugh, of Meldeburn, husbandman 0
4713671 2269600 2269600 defendant Bateman John husbandman 598829 598829 Bateman, John, of Meldeburn, husbandman 1
4730701 2274800 2274800 defendant Gamelyn John laborer 598829 598829 Gamelyn, John, of Meldeburn, laborer 1
4732897 2275467 2275467 defendant Russheden Wilai husbandman 598829 598829 Russheden, Wilai, of Meldeburn, husbandman 0
4760515 2283640 2283640 defendant Horwold William husbandman 598829 598829 Horwold, William, of Meldeburn, husbandman 0
4772968 2287517 2287517 defendant Jepson John husbandman 598829 598829 Jepson, John, of Meldeburn, husbandman 0
4813300 2300276 2300276 defendant Jepson John husbandman 598829 598829 Jepson, John, of Meldeburn, husbandman 0
4813301 2300276 2300276 defendant Reynoldes William husbandman 598829 598829 Reynoldes, William, of Meldeburn, husbandman 1
4866800 2316580 2316580 defendant Jeppesson John husbandman 598829 598829 Jeppesson, John, of Meldeburn, husbandman 1
4866813 2316583 2316583 defendant Horewold John, junior fisher 598829 598829 Horewold, John, junior, of Meldeburn, fisher 4
4886394 2322606 2322606 defendant Cosyn John husbandman 598829 598829 Cosyn, John, of Meldeburn, husbandman 0
4886395 2322606 2322606 defendant Cotell John husbandman 598829 598829 Cotell, John, of Meldeburn, husbandman 1
4886396 2322606 2322606 defendant Gentyng Thomas husbandman 598829 598829 Gentyng, Thomas, of Meldeburn, husbandman 2
4893399 2324638 2324638 defendant Cosyn Walter pulter 598829 598829 Cosyn, Walter, of Meldeburn, pulter 0
4899335 2326432 2326432 defendant Cotille John woolman 598829 598829 Cotille, John, of Meldeburn, woolman 1
4899336 2326432 2326432 defendant Cotille John maltman 598829 598829 Cotille, John, of Meldeburn, maltman 2
4909444 2329493 2329493 defendant Clement John   598829 598829 Clement, John, of Meldeburn, shepherd 0
4916111 2331539 2331539 defendant Ormesby Thomas husbandman 598829 598829 Ormesby, Thomas, of Meldeburn, husbandman 0
4944496 2340258 2340258 defendant Hornewold John, senior husbandman 598829 598829 Hornewold, John, senior, of Meldeburn, husbandman 0
4944497 2340258 2340258 defendant Cosyn Walter husbandman 598829 598829 Cosyn, Walter, of Meldeburn, husbandman 1
4970248 2348055 2348055 defendant Hornewold John, junior husbandman 598829 598829 Hornewold, John, junior, of Meldeburn, husbandman 1
4970249 2348055 2348055 defendant Cotell atte Cok John husbandman 598829 598829 Cotell atte Cok, John, of Meldeburn, husbandman 2
4991421 2354318 2354318 defendant Jepson John husbandman 598829 598829 Jepson, John, of Meldeburn, husbandman 8
4991494 2354339 2354339 defendant Cotull John   598829 598829 Cotull, John, of Meldeburn 6
4991498 2354339 2354339 defendant Cuttyl John   598829 598829 Cuttyl, John, of Meldeburn 10
5008248 2359302 2359302 defendant Cotell William   598829 598829 Cotell, William, of Meldeburn, wool man 2
5009441 2359645 2359645 defendant Wever Richard weaver 598829 598829 Wever, Richard, of Meldeburn, weaver 1
5009442 2359645 2359645 defendant Ware John husbandman 598829 598829 Ware, John, of Meldeburn, husbandman 2
5023039 2363647 2363647 defendant Cosyn Walter husbandman 598829 598829 Cosyn, Walter, of Meldeburn, husbandman 0
5052297 2372292 2372292 defendant Baron William husbandman 598829 598829 Baron, William, of Meldeburn, husbandman 1
5052298 2372292 2372292 defendant Payn John carpenter 598829 598829 Payn, John, of Meldeburn, carpenter 2
5071410 2377944 2377944 defendant Cotell John woolman 598829 598829 Cotell, John, of Meldeburn, woolman 1
5072931 2378389 2378389 defendant Baron William husbandman 598829 598829 Baron, William, of Meldeburn, husbandman 4
5082906 2381390 2381390 defendant Hornewold John husbandman 598829 598829 Hornewold, John, of Meldeburn, husbandman 2
5082907 2381390 2381390 defendant Cosyn Thomas pulter 598829 598829 Cosyn, Thomas, of Meldeburn, pulter 3
5082909 2381390 2381390 defendant Cosyn Margaret widow 598829 598829 Cosyn, Margaret, of Meldeburn, widow 5
5107859 2388736 2388736 defendant Turvey John husbandman 598829 598829 Turvey, John, of Meldeburn, husbandman 1
5111122 2389638 2389638 defendant Bocher Walter butcher 598829 598829 Bocher, Walter, of Meldeburn, butcher 3
5145658 2399871 2399871 defendant Kelmersshe Walter husbandman 598829 598829 Kelmersshe, Walter, of Meldeburn, husbandman 0
5166015 2405802 2405802 defendant Kelmersshe Walter husbandman 598829 598829 Kelmersshe, Walter, of Meldeburn, husbandman 0
5229700 2424306 2424306 defendant Heche Willam husbandman 598829 598829 Heche, Willam, of Meldeburn, husbandman 0
5229701 2424306 2424306 defendant Yokflete John husbandman 598829 598829 Yokflete, John, of Meldeburn, husbandman 1
5229702 2424306 2424306 defendant Chamberlayn Gerard husbandman 598829 598829 Chamberlayn, Gerard, of Meldeburn, husbandman 2
5229703 2424306 2424306 defendant Colman Thomas laborer 598829 598829 Colman, Thomas, of Meldeburn, laborer 3
5503578 2506033 2506033 defendant Payne Simon fishmonger 598829 598829 Payne, Simon, of Meldeburn, fishmonger 0
5503579 2506033 2506033 defendant Payne William gent 598829 598829 Payne, William, of Meldeburn, gent 1
5503580 2506033 2506033 defendant Sturmyn Thomas husbandman 598829 598829 Sturmyn, Thomas, of Meldeburn, husbandman 2
5556770 2521938 2521938 defendant Hiches George yeoman 598829 598829 Hiches, George, of Meldeburn, yeoman 0
5556775 2521939 2521939 defendant Huches George yeoman 598829 598829 Huches, George, of Meldeburn, yeoman 0
5613206 2547914 2547914 plaintiff Cotele John   598829 598829 Cotele, John, of Meldeburn 0
5613207 2547914 2547914 defendant Knanat John   598829 598829 Knanat, John, of Meldeburn 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);