names

92 rows where place_id = 589808

✎ 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
3589993 1864512 1864512 defendant Stroke Richard   589808 589808 Stroke, Richard, of Swafeld husbandman 0
3598840 1867263 1867263 defendant Hemmyng Richard husbandman 589808 589808 Hemmyng, Richard, of Swafeld, husbandman 0
3598843 1867263 1867263 defendant Burgh Nicholas husbandman 589808 589808 Burgh, Nicholas, of Swafeld, husbandman 3
3606755 1869787 1869787 defendant Burgeys James yeoman 589808 589808 Burgeys, James, of Swafeld, yeoman 3
3662824 1914287 1914287 defendant Crokke John   589808 589808 Crokke, John, of Swafeld, worsted weaver 0
3701894 1926846 1926846 defendant Burges William yeoman 589808 589808 Burges, William, of Swafeld, yeoman 0
3701895 1926846 1926846 defendant Warnes John husbandman 589808 589808 Warnes, John, of Swafeld, husbandman 1
3701898 1926846 1926846 defendant Hole Edward clerk 589808 589808 Hole, Edward, of Swafeld, clerk 4
3701899 1926846 1926846 defendant Smyth Robert laborer 589808 589808 Smyth, Robert, of Swafeld, laborer 5
3701900 1926846 1926846 defendant Tayler Hugh laborer 589808 589808 Tayler, Hugh, of Swafeld, laborer 6
3740003 1938731 1938731 defendant Warnys John yeoman 589808 589808 Warnys, John, of Swafeld, yeoman 4
3763418 1946190 1946190 defendant Arcoll John husbandman 589808 589808 Arcoll, John, of Swafeld, husbandman 0
3763420 1946191 1946191 defendant Arcoll John husbandman 589808 589808 Arcoll, John, of Swafeld, husbandman 0
3769837 1948222 1948222 defendant Arkall John husbandman 589808 589808 Arkall, John, of Swafeld, husbandman 0
3769840 1948223 1948223 defendant Arcall John husbandman 589808 589808 Arcall, John, of Swafeld, husbandman 0
3775378 1950041 1950041 defendant Burwell William yeoman 589808 589808 Burwell, William, of Swafeld, yeoman 1
3786472 1953561 1953561 defendant Arcall John husbandman 589808 589808 Arcall, John, of Swafeld, husbandman 0
3793954 1955980 1955980 defendant Woode Nicholas husbandman 589808 589808 Woode, Nicholas, of Swafeld, husbandman 0
3793955 1955980 1955980 defendant Pye John cooper 589808 589808 Pye, John, of Swafeld, cooper 1
3805558 1959679 1959679 defendant Laghton Henry husbandman 589808 589808 Laghton, Henry, of Swafeld, husbandman 2
3805559 1959679 1959679 defendant Laghton John husbandman 589808 589808 Laghton, John, of Swafeld, husbandman 3
3846951 1972586 1972586 defendant Millyngton Robert yeoman 589808 589808 Millyngton, Robert, of Swafeld, yeoman 2
3852819 1974488 1974488 defendant Arkall John husbandman 589808 589808 Arkall, John, of Swafeld, husbandman 2
3857070 1975844 1975844 defendant Rycheman Edward   589808 589808 Rycheman, Edward, of Swafeld, worsted weaver 0
3857757 1976064 1976064 defendant Rycheman Edward   589808 589808 Rycheman, Edward, of Swafeld, worsted weaver 1
3860017 1976849 1976849 defendant Burges William gent 589808 589808 Burges, William, of Swafeld, gent 0
3865068 1978519 1978519 defendant Millyngton Robert gent 589808 589808 Millyngton, Robert, of Swafeld, gent 0
3865069 1978519 1978519 defendant Styberd John husbandman 589808 589808 Styberd, John, of Swafeld, husbandman 1
3896985 1989209 1989209 defendant Clarkson Miles clerk 589808 589808 Clarkson, Miles, of Swafeld, clerk 1
3914113 1995065 1995065 defendant Burwell William gent 589808 589808 Burwell, William, of Swafeld, gent 3
3923884 1998299 1998299 defendant Warnes Margaret widow 589808 589808 Warnes, Margaret, of Swafeld, widow 0
3923885 1998299 1998299 defendant Warnes Robert husbandman 589808 589808 Warnes, Robert, of Swafeld, husbandman 1
3924342 1998449 1998449 defendant Burwell William yeoman 589808 589808 Burwell, William, of Swafeld, yeoman 0
3932398 2001126 2001126 defendant Coy Thomas husbandman 589808 589808 Coy, Thomas, of Swafeld, husbandman 1
3980297 2017720 2017720 defendant Gyles Richard   589808 589808 Gyles, Richard, of Swafeld, worsted weaver 1
4248591 2112516 2112516 defendant Harmer Edmund butcher 589808 589808 Harmer, Edmund, of Swafeld, butcher 3
4413009 2168944 2168944 plaintiff Arnald Margaret   589808 589808 Arnald, Margaret, of Swafeld, formerly wife of Roger 0
4462171 2188865 2188865 defendant Ray Thomas   589808 589808 Ray, Thomas, of Swafeld 0
4493570 2198692 2198692 defendant Mason Gilbert   589808 589808 Mason, Gilbert, of Swafeld 1
4538089 2212197 2212197 defendant Arnald Robert   589808 589808 Arnald, Robert, of Swafeld 0
4589057 2227956 2227956 defendant Arnald Robert   589808 589808 Arnald, Robert, of Swafeld 0
4601048 2231557 2231557 defendant Peke Henry   589808 589808 Peke, Henry, of Swafeld 0
4601049 2231557 2231557 defendant Peke Roger   589808 589808 Peke, Roger, of Swafeld 1
4616519 2236162 2236162 defendant Walenger Richard   589808 589808 Walenger, Richard, of Swafeld 0
4641600 2243644 2243644 defendant Brydde John   589808 589808 Brydde, John, of Swafeld 1
4877919 2320047 2320047 plaintiff Styberd John   589808 589808 Styberd, John, of Swafeld 0
4938437 2338399 2338399 defendant Wodeward John clerk 589808 589808 Wodeward, John, of Swafeld, clerk 0
4968087 2347401 2347401 defendant Drye Thomas husbandman 589808 589808 Drye, Thomas, of Swafeld, husbandman 1
4970793 2348208 2348208 defendant Burgeys William yeoman 589808 589808 Burgeys, William, of Swafeld, yeoman 0
4975832 2349736 2349736 defendant Frank Clement butcher 589808 589808 Frank, Clement, of Swafeld, butcher 7
4980401 2351079 2351079 defendant Drye Thomas husbandman 589808 589808 Drye, Thomas, of Swafeld, husbandman 4
4993839 2355029 2355029 defendant Poty Robert fuller 589808 589808 Poty, Robert, of Swafeld, fuller 0
4996112 2355693 2355693 defendant Albon John husbandman 589808 589808 Albon, John, of Swafeld, husbandman 4
5044667 2370036 2370036 defendant Baret William clerk 589808 589808 Baret, William, of Swafeld, clerk 1
5050390 2371739 2371739 defendant Baret William   589808 589808 Baret, William, of Swafeld, parson 0
5053210 2372561 2372561 defendant Frank Clement butcher 589808 589808 Frank, Clement, of Swafeld, butcher 0
5085824 2382249 2382249 defendant Yitson alias Hikson John husbandman 589808 589808 Yitson alias Hikson, John, of Swafeld, husbandman 2
5085829 2382250 2382250 defendant Yttson or Hikson John husbandman 589808 589808 Yttson or Hikson, John, of Swafeld, husbandman 2
5128079 2394685 2394685 defendant Chenecourt or Chevercourt William husbandman 589808 589808 Chenecourt or Chevercourt, William, of Swafeld, husbandman 0
5128081 2394686 2394686 defendant Chenercourt William   589808 589808 Chenercourt, William, of Swafeld 0
5218721 2421203 2421203 defendant Parker William husbandman 589808 589808 Parker, William, of Swafeld, husbandman 0
5218722 2421203 2421203 defendant Parker Thomas husbandman 589808 589808 Parker, Thomas, of Swafeld, husbandman 1
5218723 2421203 2421203 defendant Fyssher Thomas husbandman 589808 589808 Fyssher, Thomas, of Swafeld, husbandman 2
5218728 2421203 2421203 defendant Smyth Thomas husbandman 589808 589808 Smyth, Thomas, of Swafeld, husbandman 7
5218729 2421203 2421203 defendant Lenton John husbandman 589808 589808 Lenton, John, of Swafeld, husbandman 8
5219830 2421520 2421520 defendant Inglond John laborer 589808 589808 Inglond, John, of Swafeld, laborer 9
5219850 2421521 2421521 defendant Inglond John laborer 589808 589808 Inglond, John, of Swafeld, laborer 9
5223461 2422555 2422555 defendant Frank Clement yeoman 589808 589808 Frank, Clement, of Swafeld, yeoman 0
5296835 2444063 2444063 defendant Burgeys Nicholas yeoman 589808 589808 Burgeys, Nicholas, of Swafeld, yeoman 4
5366658 2465224 2465224 plaintiff Burgeys James   589808 589808 Burgeys, James, of Swafeld 0
5393519 2473203 2473203 defendant Albon Thomas husbandman 589808 589808 Albon, Thomas, of Swafeld, husbandman 0
5397395 2474340 2474340 plaintiff Burgys James   589808 589808 Burgys, James, of Swafeld 0
5410560 2478105 2478105 plaintiff Burgeys James   589808 589808 Burgeys, James, of Swafeld 0
5424456 2482286 2482286 plaintiff Burgeys James   589808 589808 Burgeys, James, of Swafeld 0
5424459 2482287 2482287 plaintiff Burgeys James   589808 589808 Burgeys, James, of Swafeld 0
5424463 2482288 2482288 plaintiff Burgeys James   589808 589808 Burgeys, James, of Swafeld 0
5424467 2482289 2482289 plaintiff Burgeys James   589808 589808 Burgeys, James, of Swafeld 0
5454334 2491205 2491205 defendant Poty Clement husbandman 589808 589808 Poty, Clement, of Swafeld, husbandman 0
5477524 2498292 2498292 defendant Burgeys James yeoman 589808 589808 Burgeys, James, of Swafeld, yeoman 0
5479006 2498741 2498741 defendant Frankysshe Robert gent 589808 589808 Frankysshe, Robert, of Swafeld, gent 0
5479008 2498742 2498742 defendant Frankysshe Robert gent 589808 589808 Frankysshe, Robert, of Swafeld, gent 0
5479010 2498743 2498743 defendant Frankysshe Robert gent 589808 589808 Frankysshe, Robert, of Swafeld, gent 0
5490951 2502197 2502197 defendant Frankysshe Robert gent 589808 589808 Frankysshe, Robert, of Swafeld, gent 0
5490992 2502206 2502206 defendant Frankysshe Robert clerk or gent 589808 589808 Frankysshe, Robert, of Swafeld, clerk or gent 0
5494268 2503189 2503189 defendant Burgeys James yeoman 589808 589808 Burgeys, James, of Swafeld, yeoman 3
5506908 2507076 2507076 defendant Colvyle John gent 589808 589808 Colvyle, John, of Swafeld, gent 4
5526184 2512764 2512764 defendant Yong William husbandman 589808 589808 Yong, William,of Swafeld, husbandman 0
5540350 2517111 2517111 defendant Holme alias Bartilmewe John husbandman 589808 589808 Holme alias Bartilmewe, John, of Swafeld, husbandman 0
5542118 2517666 2517666 defendant Burgeys William   589808 589808 Burgeys, William, of Swafeld, yeoman, son of Burgeys, James, of Swafeld 0
5544769 2518476 2518476 defendant Holme Hugh husbandman 589808 589808 Holme, Hugh, of Swafeld, husbandman 0
5569851 2525756 2525756 defendant Fabyon William husbandman 589808 589808 Fabyon, William, of Swafeld, husbandman 2
5590279 2531931 2531931 defendant Holme Hugh husbandman 589808 589808 Holme, Hugh, of Swafeld, husbandman 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);