names

87 rows where place_id = 590688

✎ 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
3601997 1868285 1868285 defendant Byrd Richard clerk 590688 590688 Byrd, Richard, of More, clerk 0
3614804 1872283 1872283 defendant More Richard gent 590688 590688 More, Richard, of More, gent 0
3626672 1903188 1903188 defendant Bulkeley Ralph gent 590688 590688 Bulkeley, Ralph, of More, gent 0
3671877 1917200 1917200 defendant Lempster Richard husbandman 590688 590688 Lempster, Richard, of More, husbandman 15
3746487 1940816 1940816 defendant Fraunces Thomas husbandman 590688 590688 Fraunces, Thomas, of More, husbandman 0
3748844 1941575 1941575 defendant Bantyng Robert tanner 590688 590688 Bantyng, Robert, of More, tanner 0
3779114 1951191 1951191 defendant Wright Richard husbandman 590688 590688 Wright, Richard, of More, husbandman 2
3779116 1951191 1951191 defendant Kempe John husbandman 590688 590688 Kempe, John, of More, husbandman 4
3781758 1952039 1952039 defendant Evyttys Thomas husbandman 590688 590688 Evyttys, Thomas, of More, husbandman 4
3781759 1952039 1952039 defendant Evyttys Robert husbandman 590688 590688 Evyttys, Robert, of More, husbandman 5
3863578 1978009 1978009 defendant Young Thomas gent 590688 590688 Young, Thomas, of More, gent 2
3913863 1994983 1994983 defendant Clarke Peter clerk 590688 590688 Clarke, Peter, of More, clerk 0
3952795 2008049 2008049 defendant Yoppe William husbandman 590688 590688 Yoppe, William, of More, husbandman 0
3952797 2008049 2008049 defendant Warde Jane widow 590688 590688 Warde, Jane, of More, widow 2
3952798 2008049 2008049 defendant Smyth Thomas husbandman 590688 590688 Smyth, Thomas, of More, husbandman 3
3971329 2014530 2014530 defendant More John gent 590688 590688 More, John, of More, gent 0
3974729 2015729 2015729 defendant Yonge Thomas gent 590688 590688 Yonge, Thomas, of More, gent 4
3980558 2017811 2017811 defendant Apparry Simon esq 590688 590688 Apparry, Simon, of More, esq 0
3984689 2019283 2019283 defendant More John gent 590688 590688 More, John, of More, gent 0
3984690 2019283 2019283 defendant More David gent 590688 590688 More, David, of More, gent 1
3984693 2019284 2019284 defendant More John gent 590688 590688 More, John, of More, gent 0
3984694 2019284 2019284 defendant More David gent 590688 590688 More, David, of More, gent 1
3997673 2023921 2023921 defendant Yong Thomas (legal representative) 590688 590688 Yong, Thomas, of More, gent, administrator of 0
3997674 2023921 2023921 defendant Yong Francis gent 590688 590688 Yong, Francis, of More, gent 1
4028624 2034884 2034884 plaintiff Corpwod Edward   590688 590688 Corpwod, Edward, of More 0
4041956 2039612 2039612 plaintiff Orpewod Edward   590688 590688 Orpewod, Edward, of More 0
4091245 2057158 2057158 defendant Streete John yeoman 590688 590688 Streete, John, of More, yeoman 1
4145477 2076575 2076575 defendant Yonge Richard gent 590688 590688 Yonge, Richard, of More, gent 2
4145481 2076576 2076576 defendant Yonge Richard gent 590688 590688 Yonge, Richard, of More, gent 2
4193711 2093369 2093369 defendant Yonge Richard gent 590688 590688 Yonge, Richard, of More, gent 0
4346648 2146082 2146082 defendant Yonge Francis gent 590688 590688 Yonge, Francis, of More, gent 0
4346649 2146082 2146082 defendant Yonge Joan spinster 590688 590688 Yonge, Joan, of More, spinster 1
4450877 2185241 2185241 plaintiff Helle William   590688 590688 Helle, William, of More 0
4450878 2185241 2185241 defendant Coupere John   590688 590688 Coupere, John, of More 0
4468774 2190910 2190910 plaintiff Benyn or Bevyn John   590688 590688 Benyn or Bevyn, John, of More 0
4526748 2208641 2208641 defendant Mason William   590688 590688 Mason, William, of More 1
4526749 2208641 2208641 defendant Mason John   590688 590688 Mason, John, of More 2
4574372 2223516 2223516 defendant Milleward William   590688 590688 Milleward, William, of More 3
4574377 2223517 2223517 defendant Milleward William   590688 590688 Milleward, William, of More 1
4597854 2230584 2230584 defendant Ram William   590688 590688 Ram, William, of More 0
4597856 2230585 2230585 defendant Ram William   590688 590688 Ram, William, of More 0
4664208 2250294 2250294 defendant Gernon Hamon husbandman 590688 590688 Gernon, Hamon, of More, husbandman 4
4704446 2266766 2266766 defendant More Roger   590688 590688 (More, Roger, of More, franklin 1
4716736 2270556 2270556 defendant More John husbandman 590688 590688 More, John, of More, husbandman 0
4723953 2272791 2272791 defendant Robyns Thomas husbandman 590688 590688 Robyns, Thomas, of More, husbandman 0
4723954 2272791 2272791 defendant Fille John husbandman 590688 590688 Fille, John, of More, husbandman 1
4756500 2282400 2282400 defendant Potter Geoffrey potter 590688 590688 Potter, Geoffrey, of More, potter 2
4760842 2283730 2283730 defendant Piper John husbandman 590688 590688 Piper, John, of More, husbandman 0
4767021 2285674 2285674 defendant Bysshop John husbandman 590688 590688 Bysshop, John, of More, husbandman 0
4767023 2285675 2285675 defendant Bysshop John husbandman 590688 590688 Bysshop, John, of More, husbandman 0
4791402 2293405 2293405 defendant Bysshop John husbandman 590688 590688 Bysshop, John, of More, husbandman 0
4791408 2293407 2293407 defendant Garard Ralph husbandman 590688 590688 Garard, Ralph, of More, husbandman 0
4793197 2293969 2293969 defendant Ramsey John husbandman 590688 590688 Ramsey, John, of More, husbandman 0
4802424 2296950 2296950 defendant Taylard John gent 590688 590688 Taylard, John, of More, gent 0
4814041 2300498 2300498 defendant Dryver John clerk 590688 590688 Dryver, John, of More, clerk 0
4814052 2300500 2300500 defendant Dryver John clerk 590688 590688 with Dryver, John, of More, clerk 2
4817168 2301461 2301461 defendant Gogeyn Thomas husbandman 590688 590688 Gogeyn, Thomas, of More, husbandman 0
4817169 2301461 2301461 defendant Gerard John husbandman 590688 590688 Gerard, John, of More, husbandman 1
5090753 2383684 2383684 defendant Braas William husbandman 590688 590688 Braas, William, of More, husbandman 0
5118013 2391697 2391697 defendant More John esq 590688 590688 More, John, of More, esq 0
5190546 2412982 2412982 defendant Estham Richard   590688 590688 Estham, Richard, of More, franklin 0
5206993 2417783 2417783 defendant Estham Richard   590688 590688 Estham, Richard, of More, franklin 0
5206997 2417784 2417784 defendant Estham Richard   590688 590688 Estham, Richard, of More, franklin 0
5219150 2421328 2421328 defendant More John esq 590688 590688 together with More, John, of More, esq 1
5219156 2421329 2421329 defendant More John esq 590688 590688 More, John, of More, esq 0
5229272 2424173 2424173 defendant Cogayn William clerk 590688 590688 Cogayn, William,of More, clerk 0
5231980 2424923 2424923 defendant Dawetre Edmund gent 590688 590688 Dawetre, Edmund, of More, gent 0
5231981 2424923 2424923 defendant Lyford Richard   590688 590688 Lyford, Richard, of More, groom 1
5231982 2424923 2424923 defendant Taverner Nicholas yeoman 590688 590688 Taverner, Nicholas, of More, yeoman 2
5336426 2455963 2455963 defendant More John gent 590688 590688 More, John, of More, gent 3
5393642 2473243 2473243 defendant Lodbrooke John husbandman 590688 590688 Lodbrooke, John, of More, husbandman 0
5406804 2477011 2477011 defendant Lodbroke John husbandman 590688 590688 Lodbroke, John, of More, husbandman 0
5419969 2480888 2480888 defendant Ludbroke John husbandman 590688 590688 Ludbroke, John, of More, husbandman 0
5419971 2480889 2480889 defendant Ludbroke John husbandman 590688 590688 Ludbroke, John, of More, husbandman 0
5500049 2504969 2504969 defendant More Richard gent 590688 590688 (More, Richard, of More, gent 1
5518724 2510693 2510693 defendant Yonge William gent 590688 590688 Yonge, William, of More, gent 1
5518726 2510693 2510693 defendant Harryes William husbandman 590688 590688 Harryes, William, of More, husbandman 3
5550332 2520117 2520117 plaintiff Byrde Katherine (legal representative) 590688 590688 Byrde, Katherine, of More, administrator of 0
5550335 2520118 2520118 plaintiff Byrde Katherine (legal representative) 590688 590688 Byrde, Katherine, of More, administrator of 0
5556646 2521899 2521899 defendant Byrde John gent 590688 590688 (Byrde, John, of More, gent 1
5556647 2521899 2521899 defendant Foster William yeoman 590688 590688 Foster, William, of More, yeoman 2
5559552 2522754 2522754 defendant Mowyar John husbandman 590688 590688 Mowyar, John, of More, husbandman 1
5588610 2531445 2531445 defendant Martyn Henry husbandman 590688 590688 Martyn, Henry, of More, husbandman 0
5588611 2531445 2531445 defendant Weste William husbandman 590688 590688 Weste, William, of More, husbandman 1
5613002 2547843 2547843 defendant Holte John   590688 590688 Holte, John, of More 1
5632515 2554203 2554203 defendant Porter William carrier 590688 590688 Porter, William, of More, carrier 1
5634016 2554624 2554624 defendant Rowe John laborer 590688 590688 Rowe, John, of More, 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);