names

84 rows where place_id = 587541

✎ 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
3591699 1865022 1865022 defendant Fisshcok Robert clothmaker 587541 587541 Fisshcok, Robert, of Bydynden, clothmaker 0
3597964 1866987 1866987 defendant Frende John husbandman 587541 587541 Frende, John, of Bydynden, husbandman 0
3628512 1903787 1903787 defendant Stace John yeoman 587541 587541 Stace, John, of Bydynden, yeoman 0
3628513 1903787 1903787 defendant Ricard Richard yeoman 587541 587541 Ricard, Richard, of Bydynden, yeoman 1
3698805 1925845 1925845 defendant Lachynden John clothier 587541 587541 Lachynden, John, of Bydynden, clothier 0
3815508 1962766 1962766 plaintiff Hamond William clothmaker 587541 587541 Hamond, William, of Bydynden, clothmaker 0
4479621 2194290 2194290 defendant Ian or Jan Thomas   587541 587541 Ian or Jan, Thomas, of Bydynden 0
4542146 2213434 2213434 defendant Taillour John   587541 587541 Taillour, John, of Bydynden 0
4640705 2243388 2243388 defendant Fyshecok John   587541 587541 Fyshecok, John, of Bydynden 1
4655576 2247634 2247634 defendant Rukke John chaplain 587541 587541 Rukke, John, of Bydynden, chaplain 0
4665470 2250675 2250675 defendant Pencrone Thomas husbandman 587541 587541 Pencrone, Thomas, of Bydynden, husbandman 0
4688412 2261942 2261942 defendant atte Rode Thomas laborer 587541 587541 atte Rode, Thomas, of Bydynden, laborer 0
4732621 2275379 2275379 defendant Andrewe Robert laborer 587541 587541 Andrewe, Robert, of Bydynden, laborer 2
4737288 2276781 2276781 plaintiff Twysden Roger   587541 587541 Twysden, Roger, of Bydynden 0
4743299 2278566 2278566 defendant Bukherst Adam laborer 587541 587541 Bukherst, Adam, of Bydynden, laborer 0
4743300 2278566 2278566 defendant Bukherst William laborer 587541 587541 Bukherst, William, of Bydynden, laborer 1
4743876 2278737 2278737 defendant Odeirne Thomas husbandman 587541 587541 Odeirne, Thomas, of Bydynden, husbandman 1
4861049 2314814 2314814 defendant Harry Thomas draper 587541 587541 Harry, Thomas, of Bydynden, draper 0
4907175 2328809 2328809 defendant Merden John laborer 587541 587541 Merden, John, of Bydynden, laborer 0
4916242 2331585 2331585 defendant Ketelesden Stephen husbandman 587541 587541 Ketelesden, Stephen, of Bydynden, husbandman 1
4968074 2347396 2347396 defendant Newelyn Stephen laborer 587541 587541 Newelyn, Stephen, of Bydynden, laborer 3
4978488 2350514 2350514 defendant Merden John husbandman 587541 587541 Merden, John, of Bydynden, husbandman 0
4978489 2350514 2350514 defendant Merden Adam laborer 587541 587541 Merden, Adam, of Bydynden, laborer 1
5002624 2357681 2357681 defendant Igolynden James husbandman 587541 587541 Igolynden, James, of Bydynden, husbandman 0
5002625 2357681 2357681 defendant Merden John husbandman 587541 587541 Merden, John, of Bydynden, husbandman 1
5069578 2377400 2377400 defendant Igolynden James husbandman 587541 587541 Igolynden, James, of Bydynden, husbandman 0
5073937 2378692 2378692 defendant Merden John (legal representative) 587541 587541 Merden, John, of Bydynden, yeoman, administrator of 0
5073938 2378692 2378692 defendant Merden Adam laborer 587541 587541 Merden, Adam, of Bydynden, laborer 1
5084804 2381960 2381960 defendant Sancok Thomas cooper 587541 587541 Sancok, Thomas, of Bydynden, cooper 0
5092181 2384089 2384089 defendant Lellysden John husbandman 587541 587541 Lellysden, John, of Bydynden, husbandman 0
5094103 2384676 2384676 defendant Igolynden James husbandman 587541 587541 Igolynden, James, of Bydynden, husbandman 0
5094183 2384703 2384703 defendant Hyvynden Stephen laborer 587541 587541 Hyvynden, Stephen, of Bydynden, laborer 0
5097342 2385652 2385652 defendant Cutbusshe Henry yeoman 587541 587541 Cutbusshe, Henry, of Bydynden, yeoman 0
5097343 2385652 2385652 defendant Rycard Robert laborer 587541 587541 Rycard, Robert, of Bydynden, laborer 1
5108922 2389030 2389030 defendant Edynden John husbandman 587541 587541 Edynden, John, of Bydynden, husbandman 1
5114309 2390581 2390581 defendant Brykynden Richard butcher 587541 587541 Brykynden, Richard, of Bydynden, butcher 0
5114311 2390582 2390582 defendant Peryn John cordwainer 587541 587541 Peryn, John, of Bydynden, cordwainer 0
5116697 2391317 2391317 plaintiff Edynden William   587541 587541 Edynden, William, of Bydynden 1
5116698 2391317 2391317 plaintiff Edynden John   587541 587541 Edynden, John, of Bydynden 2
5116699 2391317 2391317 defendant Forsden Adam yeoman 587541 587541 Forsden, Adam, of Bydynden, yeoman 0
5131558 2395712 2395712 defendant atte Hope Henry weaver 587541 587541 atte Hope, Henry, of Bydynden, weaver 0
5151026 2401440 2401440 defendant atte Hope Henry weaver 587541 587541 atte Hope, Henry, of Bydynden, weaver 0
5159109 2403779 2403779 defendant Igolynden James yeoman 587541 587541 Igolynden, James, of Bydynden, yeoman 0
5183759 2410985 2410985 defendant Rycard John butcher 587541 587541 Rycard, John, of Bydynden, butcher 0
5184620 2411249 2411249 defendant Ethenden William husbandman 587541 587541 Ethenden, William, of Bydynden, husbandman 0
5185995 2411653 2411653 defendant atte Hope Henry weaver 587541 587541 atte Hope, Henry, of Bydynden, weaver 0
5214262 2419903 2419903 defendant Ricard John butcher 587541 587541 Ricard, John, of Bydynden, butcher 1
5224960 2422971 2422971 defendant Igolynden James husbandman 587541 587541 Igolynden, James, of Bydynden, husbandman 0
5225665 2423177 2423177 defendant Ricard John butcher 587541 587541 Ricard, John, of Bydynden, butcher 3
5269410 2436148 2436148 defendant Bergh William fuller 587541 587541 Bergh, William, of Bydynden, fuller 1
5298118 2444464 2444464 plaintiff Barowe William   587541 587541 Barowe, William, of Bydynden 0
5298120 2444464 2444464 defendant a Barowe Richard fuller 587541 587541 a Barowe, Richard, of Bydynden, fuller 1
5305003 2446496 2446496 defendant Berowe William clothmaker 587541 587541 Berowe, William, of Bydynden, clothmaker 0
5316852 2450125 2450125 defendant Brekenden John chapman 587541 587541 Brekenden, John, of Bydynden, chapman 3
5338005 2456452 2456452 defendant Cutbussh Henry yeoman 587541 587541 Cutbussh, Henry, of Bydynden, yeoman 0
5353436 2461151 2461151 defendant Harman Thomas smith 587541 587541 Harman, Thomas, of Bydynden, smith 3
5353437 2461151 2461151 defendant Bone William husbandman 587541 587541 Bone, William, of Bydynden, husbandman 4
5359603 2463038 2463038 defendant Brykynden James yeoman 587541 587541 Brykynden, James, of Bydynden, yeoman 0
5360150 2463215 2463215 defendant Brekynden John yeoman 587541 587541 Brekynden, John, of Bydynden, yeoman 3
5360432 2463297 2463297 defendant Brykynden John husbandman 587541 587541 Brykynden, John, of Bydynden, husbandman 4
5362671 2463973 2463973 defendant Alward Robert husbandman 587541 587541 Alward, Robert, of Bydynden, husbandman 1
5362990 2464070 2464070 defendant Elys Richard clothmaker 587541 587541 Elys, Richard, of Bydynden, clothmaker 0
5362991 2464070 2464070 defendant Boone William husbandman or drover 587541 587541 Boone, William, of Bydynden, husbandman or drover 1
5384852 2470741 2470741 defendant Wode John husbandman 587541 587541 Wode, John, of Bydynden, husbandman 5
5385894 2471039 2471039 defendant Borell William   587541 587541 Borell, William, of Bydynden, cloth maker 0
5385902 2471041 2471041 defendant Barowegh William   587541 587541 Barowegh, William, of Bydynden, cloth maker 0
5396868 2474188 2474188 defendant Wode John husbandman 587541 587541 Wode, John, of Bydynden, husbandman 3
5398078 2474519 2474519 defendant Barowegh William   587541 587541 Barowegh, William, of Bydynden, cloth maker 0
5410135 2477985 2477985 defendant Wode John   587541 587541 Wode, John, of Bydynden 3
5424477 2482291 2482291 defendant Elys Richard clothmaker 587541 587541 Elys, Richard, of Bydynden, clothmaker 0
5424478 2482291 2482291 defendant Gybon John husbandman 587541 587541 Gybon, John, of Bydynden, husbandman 1
5424481 2482292 2482292 defendant Elys Richard clothmaker 587541 587541 Elys, Richard, of Bydynden, clothmaker 0
5424482 2482292 2482292 defendant Gybon John husbandman 587541 587541 Gybon, John, of Bydynden, husbandman 1
5435055 2485416 2485416 defendant Nore Stephen   587541 587541 Nore, Stephen, of Bydynden, inland fish seller 0
5436031 2485716 2485716 defendant Wolf John husbandman 587541 587541 Wolf, John, of Bydynden, husbandman 1
5456006 2491709 2491709 defendant Taylour Walter yeoman 587541 587541 together with Taylour, Walter, of Bydynden, yeoman 1
5480934 2499251 2499251 defendant Taylour Walter husbandman 587541 587541 (Taylour, Walter, of Bydynden, husbandman 1
5490266 2501976 2501976 defendant Brekynden John butcher 587541 587541 Brekynden, John, of Bydynden, butcher 0
5490267 2501976 2501976 defendant Le- John butcher 587541 587541 Le-, John, of Bydynden, butcher 1
5490268 2501976 2501976 defendant Edynden Richard weaver 587541 587541 Edynden, Richard, of Bydynden, weaver 2
5532132 2514593 2514593 defendant Baker Henry weaver 587541 587541 Baker, Henry, of Bydynden, weaver 1
5579278 2528593 2528593 plaintiff Best William clothmaker 587541 587541 Best, William, of Bydynden, clothmaker 0
5614846 2548444 2548444 defendant Roberd Stephen   587541 587541 Roberd, Stephen, of Bydynden 0
5634614 2554825 2554825 defendant Gaunt John laborer 587541 587541 Gaunt, John, of Bydynden, 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);