names

90 rows where place_id = 593036

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3610164 1870842 1870842 defendant Lannargh Richard gent 593036 593036 Lannargh, Richard, of Helstonburgh, gent 0
3610541 1870960 1870960 defendant Noelsawe John glover 593036 593036 Noelsawe, John, of Helstonburgh, glover 1
3610542 1870960 1870960 defendant Bruse Robert baker 593036 593036 Bruse, Robert, of Helstonburgh, baker 2
3610543 1870960 1870960 defendant Eweryn John, junior glover 593036 593036 Eweryn, John, junior, of Helstonburgh, glover 3
3610544 1870960 1870960 defendant Eweryn William cordwainer 593036 593036 Eweryn, William, of Helstonburgh, cordwainer 4
3645535 1909001 1909001 defendant Trotte Thomas merchant 593036 593036 Trotte, Thomas, of Helstonburgh, merchant 0
3686127 1921821 1921821 defendant Treneves Peter merchant 593036 593036 Treneves, Peter, of Helstonburgh, merchant 2
3695038 1924659 1924659 defendant Engoffe Edward smith 593036 593036 Engoffe, Edward, of Helstonburgh, smith 0
3708986 1929104 1929104 defendant Trott Thomas yeoman or merchant 593036 593036 Trott, Thomas, of Helstonburgh, yeoman or merchant 0
3838484 1969960 1969960 defendant Rowe Richard tinner 593036 593036 Rowe, Richard, of Helstonburgh, tinner 1
3849154 1973332 1973332 defendant Martyn Peter yeoman 593036 593036 Martyn, Peter, of Helstonburgh, yeoman 1
3849155 1973332 1973332 defendant Rawe William yeoman 593036 593036 Rawe, William, of Helstonburgh, yeoman 2
3849156 1973332 1973332 defendant Humfrey Richard yeoman 593036 593036 Humfrey, Richard, of Helstonburgh, yeoman 3
3864296 1978252 1978252 defendant Marten Peter yeoman 593036 593036 Marten, Peter, of Helstonburgh, yeoman 0
3864298 1978253 1978253 defendant Rowe William yeoman 593036 593036 Rowe, William, of Helstonburgh, yeoman 0
3878383 1983018 1983018 defendant Marten Peter yeoman 593036 593036 Marten, Peter, of Helstonburgh, yeoman 0
3878385 1983019 1983019 defendant Rowe William yeoman 593036 593036 Rowe, William, of Helstonburgh, yeoman 0
3885451 1985389 1985389 defendant Marten Peter yeoman 593036 593036 Marten, Peter, of Helstonburgh, yeoman 0
3885453 1985390 1985390 defendant Martyn Peter yeoman 593036 593036 Martyn, Peter, of Helstonburgh, yeoman 0
3924461 1998494 1998494 defendant Power Pascas yeoman 593036 593036 Power, Pascas, of Helstonburgh, yeoman 3
4776937 2288774 2288774 defendant Trottyer Walter husbandman 593036 593036 Trottyer, Walter, of Helstonburgh, husbandman 2
4776942 2288775 2288775 defendant Came or Caine John merchant 593036 593036 Came or Caine, John, of Helstonburgh, merchant 2
4776945 2288775 2288775 defendant Glasen John merchant 593036 593036 Glasen, John, of Helstonburgh, merchant 5
4796721 2295127 2295127 defendant Jakrawe Eurus smith 593036 593036 Jakrawe, Eurus, of Helstonburgh, smith 3
4873337 2318615 2318615 defendant Tremayn Nicholas tailor 593036 593036 Tremayn, Nicholas, of Helstonburgh, tailor 3
4873338 2318615 2318615 defendant Henryrychewe John tinner 593036 593036 Henryrychewe, John, of Helstonburgh, tinner 4
4873339 2318615 2318615 defendant Elenor Glen John   593036 593036 Elenor Glen, John, of Helstonburgh, millward 5
4890140 2323691 2323691 defendant Tremayn John clerk 593036 593036 Tremayn, John, of Helstonburgh, clerk 0
4890141 2323691 2323691 defendant Jakerosy Michael cordewainer 593036 593036 Jakerosy, Michael, of Helstonburgh, cordewainer 1
4899891 2326602 2326602 defendant Harry John   593036 593036 Harry, John, of Helstonburgh, bailiff 2
4907873 2329022 2329022 defendant Meryesek Nicholas tinner 593036 593036 Meryesek, Nicholas, of Helstonburgh, tinner 1
4959256 2344738 2344738 defendant Carpenter Philip carpenter 593036 593036 Carpenter, Philip, of Helstonburgh, carpenter 0
4959257 2344738 2344738 defendant Toure John weaver 593036 593036 Toure, John, of Helstonburgh, weaver 1
4959258 2344738 2344738 defendant Belek John laborer 593036 593036 Belek, John, of Helstonburgh, laborer 2
4959259 2344738 2344738 defendant Trokyer James tailor 593036 593036 Trokyer, James, of Helstonburgh, tailor 3
4959260 2344738 2344738 defendant Troute John dyer 593036 593036 Troute, John, of Helstonburgh, dyer 4
4959261 2344738 2344738 defendant Gunne Stephen cordwainer 593036 593036 Gunne, Stephen, of Helstonburgh, cordwainer 5
4959262 2344738 2344738 defendant Seys John glover 593036 593036 Seys, John, of Helstonburgh, glover 6
4959263 2344738 2344738 defendant Cok John tucker 593036 593036 Cok, John, of Helstonburgh, tucker 7
4959264 2344738 2344738 defendant Cok Thomas tucker 593036 593036 Cok, Thomas, of Helstonburgh, tucker 8
4959265 2344738 2344738 defendant atte Ware James cordwainer 593036 593036 atte Ware, James, of Helstonburgh, cordwainer 9
4959267 2344738 2344738 defendant Kestell Thomas tucker 593036 593036 Kestell, Thomas, of Helstonburgh, tucker 11
4959268 2344738 2344738 defendant Jeffrey John husbandman 593036 593036 Jeffrey, John, of Helstonburgh, husbandman 12
4959269 2344738 2344738 defendant Nansege William smith 593036 593036 Nansege, William, of Helstonburgh, smith 13
4959270 2344738 2344738 defendant Nansege Thomas smith 593036 593036 Nansege, Thomas, of Helstonburgh, smith 14
4959271 2344738 2344738 defendant Kyrnyk John carpenter 593036 593036 Kyrnyk, John, of Helstonburgh, carpenter 15
4959272 2344738 2344738 defendant Melender Roger miller 593036 593036 Melender, Roger, of Helstonburgh, miller 16
4983192 2351875 2351875 defendant Croderer Christopher laborer 593036 593036 Croderer, Christopher, of Helstonburgh, laborer 0
5009362 2359626 2359626 defendant Perkyn Thomas husbandman 593036 593036 Perkyn, Thomas, of Helstonburgh, husbandman 0
5061481 2375024 2375024 defendant Mercer Geoffrey mercer 593036 593036 Mercer, Geoffrey, of Helstonburgh, mercer 0
5075783 2379256 2379256 defendant Burton John schoolmaster 593036 593036 Burton, John, of Helstonburgh, schoolmaster 2
5075810 2379259 2379259 defendant James John shoemaker 593036 593036 James, John, of Helstonburgh, shoemaker 11
5075811 2379259 2379259 defendant Snyll John yeoman 593036 593036 Snyll, John, of Helstonburgh, yeoman 12
5093260 2384426 2384426 defendant Noell Robert husbandman 593036 593036 Noell, Robert, of Helstonburgh, husbandman 0
5122015 2392855 2392855 defendant Swayn Richard tailor 593036 593036 Swayn, Richard, of Helstonburgh, tailor 0
5240746 2427502 2427502 defendant Gilliot Henry gent 593036 593036 Gilliot, Henry, of Helstonburgh, gent 0
5251905 2430702 2430702 defendant Jakherry Thomas clerk 593036 593036 Jakherry, Thomas, of Helstonburgh, clerk 1
5254792 2431615 2431615 defendant Fawe Noel glover 593036 593036 Fawe, Noel, of Helstonburgh, glover 0
5254793 2431615 2431615 defendant Noell John glover 593036 593036 Noell, John, of Helstonburgh, glover 1
5263695 2434395 2434395 defendant Pyper John James weaver 593036 593036 Pyper, John James, of Helstonburgh, weaver 4
5280561 2439391 2439391 defendant Noylalys John carpenter 593036 593036 Noylalys, John, of Helstonburgh, carpenter 4
5280563 2439391 2439391 defendant Taillour Clement tailor 593036 593036 Taillour, Clement, of Helstonburgh, tailor 6
5280564 2439391 2439391 defendant Lowarn John weaver 593036 593036 Lowarn, John, of Helstonburgh, weaver 7
5312121 2448658 2448658 defendant Gylyot Henry gent 593036 593036 Gylyot, Henry, of Helstonburgh, gent 0
5312126 2448658 2448658 defendant Noy- Robert yeoman 593036 593036 Noy-, Robert, of Helstonburgh, yeoman 5
5312127 2448658 2448658 defendant Jenkyn Richard mercer 593036 593036 Jenkyn, Richard, of Helstonburgh, mercer 6
5314708 2449433 2449433 defendant Gylyot Henry, junior gent 593036 593036 Gylyot, Henry, junior, of Helstonburgh, gent 2
5354024 2461321 2461321 defendant Jachyke John miller 593036 593036 Jachyke, John, of Helstonburgh, miller 2
5354025 2461321 2461321 defendant Raffe Rihchard baker 593036 593036 Raffe, Rihchard, of Helstonburgh, baker 3
5354029 2461322 2461322 defendant Jachyke John miller 593036 593036 Jachyke, John, of Helstonburgh, miller 2
5354030 2461322 2461322 defendant Raffe Richard baker 593036 593036 Raffe, Richard, of Helstonburgh, baker 3
5485909 2500676 2500676 defendant Jenkyn Richard yeoman 593036 593036 together with Jenkyn, Richard, of Helstonburgh, yeoman 1
5485911 2500677 2500677 defendant Jenkyn Richard yeoman 593036 593036 Jenkyn, Richard, of Helstonburgh, yeoman 0
5495376 2503518 2503518 defendant Lowarn John weaver 593036 593036 Lowarn, John, of Helstonburgh, weaver 1
5502607 2505735 2505735 defendant Sule Michael glover 593036 593036 Sule, Michael, of Helstonburgh, glover 0
5502609 2505735 2505735 defendant Sule John glover 593036 593036 Sule, John, of Helstonburgh, glover 2
5513828 2509180 2509180 defendant Trote Richard tailor 593036 593036 Trote, Richard, of Helstonburgh, tailor 0
5513829 2509180 2509180 defendant Trote William cordwainer 593036 593036 Trote, William, of Helstonburgh, cordwainer 1
5532555 2514727 2514727 defendant Engoffe Edward smith 593036 593036 Engoffe, Edward, of Helstonburgh, smith 0
5532556 2514727 2514727 defendant Olever Richard carpenter 593036 593036 Olever, Richard, of Helstonburgh, carpenter 1
5532557 2514727 2514727 defendant Brevannek John sherman 593036 593036 Brevannek, John, of Helstonburgh, sherman 2
5532558 2514727 2514727 defendant Burwyke Richard yeoman 593036 593036 Burwyke, Richard, of Helstonburgh, yeoman 3
5532559 2514727 2514727 defendant Roneld Thomas miller 593036 593036 Roneld, Thomas, of Helstonburgh, miller 4
5548293 2519531 2519531 defendant Trote James tailor 593036 593036 Trote, James, of Helstonburgh, tailor 0
5548294 2519531 2519531 defendant Hogge Gilbert carpenter 593036 593036 Hogge, Gilbert, of Helstonburgh, carpenter 1
5566668 2524848 2524848 defendant Lannargh Agnes widow 593036 593036 Lannargh, Agnes, of Helstonburgh, widow 0
5573407 2526780 2526780 defendant Nanskylly John gent 593036 593036 Nanskylly, John, of Helstonburgh, gent 0
5573408 2526780 2526780 defendant Nanskylly Richard gent 593036 593036 Nanskylly, Richard, of Helstonburgh, gent 1
5588562 2531429 2531429 defendant Rawe William yeoman 593036 593036 Rawe, William, of Helstonburgh, yeoman 0
5625865 2552038 2552038 defendant Seler John glover 593036 593036 Seler, John, of Helstonburgh, glover 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);