names

96 rows where place_id = 606355

✎ 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
3664922 1914974 1914974 defendant Dunton Robert yeoman 606355 606355 Dunton, Robert, of Strode, Kent, yeoman 0
3699864 1926183 1926183 defendant Munde John pardoner 606355 606355 Munde, John, of Strode, Kent, pardoner 0
3714635 1930874 1930874 defendant Armeston James gent 606355 606355 Armeston, James, of Strode, Kent, gent 0
3714810 1930934 1930934 defendant Urmeston James gent 606355 606355 Urmeston, James, of Strode, Kent, gent 0
3752120 1942586 1942586 defendant Carre Matthew yeoman 606355 606355 Carre, Matthew, of Strode, Kent, yeoman 0
3759375 1944920 1944920 defendant Lunford Richard yeoman 606355 606355 Lunford, Richard, of Strode, Kent, yeoman 0
3768133 1947670 1947670 defendant Atturbury John yeoman 606355 606355 Atturbury, John, of Strode, Kent, yeoman 1
3791338 1955125 1955125 defendant Urmeston James gent 606355 606355 Urmeston, James, of Strode, Kent, gent 0
3803268 1958927 1958927 defendant Atterbury John yeoman 606355 606355 Atterbury, John, of Strode, Kent, yeoman 0
3921157 1997428 1997428 defendant Atturbery John yeoman 606355 606355 Atturbery, John, of Strode, Kent, yeoman 0
3921161 1997429 1997429 defendant Atturbery John yeoman 606355 606355 Atturbery, John, of Strode, Kent, yeoman 0
4113459 2065088 2065088 defendant Bagley Richard chapman 606355 606355 Bagley, Richard, of Strode, Kent, chapman 0
4576747 2224237 2224237 defendant atte Hethe Thomas   606355 606355 atte Hethe, Thomas, of Strode, Kent 1
4726204 2273478 2273478 defendant Beauchamp Robert husbandman 606355 606355 Beauchamp, Robert, of Strode, Kent, husbandman 0
4728912 2274281 2274281 defendant Yongge Thomas   606355 606355 Yongge, Thomas, of Strode, Kent, rope maker 1
4728915 2274282 2274282 defendant Yongge Thomas   606355 606355 Yongge, Thomas, of Strode, Kent, rope maker 1
4744904 2279024 2279024 defendant Peryman Nicholas chapman 606355 606355 Peryman, Nicholas, of Strode, Kent, chapman 3
4780360 2289853 2289853 defendant Albon John husbandman 606355 606355 Albon, John, of Strode, Kent, husbandman 0
4786982 2291994 2291994 defendant Hert John mariner 606355 606355 Hert, John, of Strode, Kent, mariner 0
4786985 2291995 2291995 defendant Hert John mariner 606355 606355 Hert, John, of Strode, Kent, mariner 0
4833672 2306539 2306539 defendant Warenere John miller 606355 606355 Warenere, John, of Strode, Kent, miller 0
4851336 2311865 2311865 defendant Baldewyn William husbandman 606355 606355 Baldewyn, William, of Strode, Kent, husbandman 3
5111866 2389860 2389860 defendant Van Eistall Gerard tailor 606355 606355 Van Eistall, Gerard, of Strode, Kent, tailor 1
5112213 2389953 2389953 defendant Van Ecstall Gerard tailor 606355 606355 Van Ecstall, Gerard, of Strode, Kent, tailor 2
5140706 2398394 2398394 plaintiff Thewe Thomas clerk 606355 606355 Thewe, Thomas, of Strode, Kent, clerk 0
5252896 2431018 2431018 defendant Thowe Thomas gent 606355 606355 Thowe, Thomas, of Strode, Kent, gent 0
5254827 2431625 2431625 defendant Thowe Thomas esq 606355 606355 Thowe, Thomas, of Strode, Kent, esq 0
5256607 2432186 2432186 defendant Thowe Thomas esq 606355 606355 Thowe, Thomas, of Strode, Kent, esq 0
5256609 2432187 2432187 defendant Thowe Thomas gent 606355 606355 Thowe, Thomas, of Strode, Kent, gent 0
5257243 2432392 2432392 defendant Brakenburgh Richard   606355 606355 Brakenburgh, Richard, of Strode, Kent, clerk, master of New Works, Strode 0
5257245 2432393 2432393 defendant Brakenburgh Richard master of the new work 606355 606355 Brakenburgh, Richard, of Strode, Kent, clerk, master of the new work 0
5258666 2432833 2432833 defendant Petyr William gent 606355 606355 (Petyr, William, of Strode, Kent, gent 1
5258673 2432834 2432834 defendant Petyr William gent 606355 606355 Petyr, William, of Strode, Kent, gent 0
5260980 2433553 2433553 defendant Thowe Thomas, junior esq 606355 606355 Thowe, Thomas, junior, of Strode, Kent, esq 1
5266582 2435299 2435299 defendant Thowe Thomas esq 606355 606355 Thowe, Thomas, of Strode, Kent, esq 0
5271180 2436668 2436668 defendant Brakynburgh Richard clerk & Master of the hospital or College of Mary 606355 606355 Brakynburgh, Richard, of Strode near Rochester, Kent, clerk & Master of the hospital or College of Mary 0
5273163 2437220 2437220 defendant Thowe Thomas esq 606355 606355 Thowe, Thomas, of Strode, Kent, esq 0
5273167 2437221 2437221 defendant Thowe Thomas esq 606355 606355 Thowe, Thomas, of Strode, Kent, esq 0
5273891 2437445 2437445 defendant Towe Thomas gent 606355 606355 Towe, Thomas, of Strode, Kent, gent 3
5274360 2437581 2437581 defendant Cham---- Nicholas gent 606355 606355 Cham----, Nicholas, of Strode, Kent, gent 0
5291440 2442502 2442502 defendant Champnes Henry gent 606355 606355 Champnes, Henry, of Strode, Kent, gent 0
5302582 2445747 2445747 defendant Brabroke Robert yeoman 606355 606355 Brabroke, Robert, of Strode, Kent, yeoman 1
5303100 2445917 2445917 defendant Brakyngburgh Richard clerk & master 606355 606355 Brakyngburgh, Richard, of Strode, Kent, clerk & master 0
5307032 2447102 2447102 defendant Dowenyng Robert yeoman 606355 606355 Dowenyng, Robert, of Strode, Kent, yeoman 3
5321724 2451571 2451571 defendant Brakynbrough Richard clerk 606355 606355 Brakynbrough, Richard, of Strode, Kent, clerk 0
5323101 2451994 2451994 defendant Inkepen John   606355 606355 Inkepen, John, of Strode, Kent, smit 1
5323114 2451997 2451997 defendant Inkepen John smith 606355 606355 Inkepen, John, of Strode, Kent, smith 2
5339980 2457076 2457076 defendant Champneys Nicholas gent 606355 606355 Champneys, Nicholas, of Strode, Kent, gent 0
5342554 2457871 2457871 defendant Towe Thomas (legal representative) 606355 606355 Towe, Thomas, of Strode, Kent, esq, executors of 0
5344987 2458593 2458593 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk 4
5355671 2461849 2461849 defendant Chapman William yeoman 606355 606355 Chapman, William, of Strode, Kent, yeoman 0
5355700 2461862 2461862 defendant Noreys Mathew husbandman 606355 606355 Noreys, Mathew, of Strode, Kent, husbandman 1
5358311 2462653 2462653 defendant Raby Robert gent 606355 606355 Raby, Robert, of Strode, Kent, gent 0
5358315 2462654 2462654 defendant Raby Robert gent 606355 606355 Raby, Robert, of Strode, Kent, gent 0
5358632 2462761 2462761 defendant Raby Robert gent 606355 606355 Raby, Robert, of Strode, Kent, gent 0
5358936 2462844 2462844 defendant Hyll John yeoman 606355 606355 Hyll, John, of Strode juxta Rochester, Kent, yeoman 0
5358939 2462845 2462845 defendant Hyll John yeoman 606355 606355 Hyll, John, of Strode, Kent, yeoman 0
5364547 2464570 2464570 defendant Lorde John chaplain 606355 606355 Lorde, John, of Strode, Kent, chaplain 0
5364549 2464571 2464571 defendant Loade John chaplain 606355 606355 Loade, John, of Strode, Kent, chaplain 0
5381250 2469690 2469690 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode near Rochester, Kent, clerk 1
5381279 2469700 2469700 defendant Brakynburgh Richard clerk & master 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk & master 0
5382423 2470031 2470031 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk 0
5388007 2471626 2471626 defendant Brakenburgh Richard clerk 606355 606355 Brakenburgh, Richard, of Strode by Rochester, Kent, clerk 0
5388155 2471665 2471665 defendant Brakynburh Richard clerk 606355 606355 Brakynburh, Richard, of Strode, Kent, clerk 0
5391692 2472696 2472696 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk 0
5391694 2472697 2472697 defendant Brakynbury Richard clerk 606355 606355 Brakynbury, Richard, of Strode, Kent, clerk 0
5403055 2475954 2475954 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk 0
5405074 2476528 2476528 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk 0
5418157 2480357 2480357 defendant Brakyngburgh Richard clerk 606355 606355 Brakyngburgh, Richard, of Strode, Kent, clerk 0
5423095 2481864 2481864 defendant Champneys Nicholas gent 606355 606355 Champneys, Nicholas, of Strode, Kent, gent 1
5425662 2482654 2482654 defendant Raby Robert gent 606355 606355 Raby, Robert, of Strode, Kent, gent 3
5425715 2482660 2482660 defendant Raby Robert gent 606355 606355 Raby, Robert, of Strode, Kent, gent 3
5432738 2484756 2484756 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk 0
5432740 2484757 2484757 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk 0
5432742 2484758 2484758 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk 0
5436325 2485798 2485798 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk 0
5444100 2488144 2488144 defendant Raby Robert gent 606355 606355 Raby, Robert, of Strode, Kent, gent 3
5444110 2488145 2488145 defendant Raby Robert gent 606355 606355 Raby, Robert, of Strode, Kent, gent 3
5448750 2489521 2489521 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk 0
5456811 2491951 2491951 defendant Raby Robert gent 606355 606355 Raby, Robert, of Strode, Kent, gent 3
5456832 2491954 2491954 defendant Raby Robert gent 606355 606355 Raby, Robert, of Strode, Kent, gent 3
5456842 2491955 2491955 defendant Raby Robert gent 606355 606355 Raby, Robert, of Strode, Kent, gent 3
5456852 2491956 2491956 defendant Raby Robert gent 606355 606355 Raby, Robert, of Strode, Kent, gent 3
5460984 2493234 2493234 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk 0
5462055 2493545 2493545 defendant Champneys William yeoman 606355 606355 Champneys, William, of Strode, Kent, yeoman 2
5473586 2497065 2497065 defendant Champneys William yeoman 606355 606355 Champneys, William, of Strode, Kent, yeoman 1
5473591 2497066 2497066 defendant Champneys William yeoman 606355 606355 Champneys, William, of Strode, Kent, yeoman 2
5484052 2500166 2500166 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk 0
5487192 2501066 2501066 defendant Throwe Thomas (legal representative) 606355 606355 Throwe, Thomas, of Strode, Kent, gent, executors of 0
5490724 2502119 2502119 plaintiff Brakynburgh Richard master of Blessed Virgin Mary of Strode 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk, master of Blessed Virgin Mary of Strode 0
5502541 2505712 2505712 defendant Brakynburgh Richard clerk 606355 606355 Brakynburgh, Richard, of Strode, Kent, clerk 0
5502713 2505765 2505765 defendant Godfrey John chapman 606355 606355 Godfrey, John, of Strode, Kent, chapman 3
5502719 2505766 2505766 defendant Godfrey John chapman 606355 606355 Godfrey, John, of Strode, Kent, chapman 2
5513245 2508993 2508993 defendant Carwell William plumber 606355 606355 Carwell, William, of Strode, Kent, plumber 0
5532330 2514653 2514653 defendant Bull John yeoman 606355 606355 Bull, John, of Strode, Kent, yeoman 0
5546972 2519117 2519117 defendant Hawkyn William weaver 606355 606355 Hawkyn, William, of Strode, Kent, weaver 1

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