names

379 rows where place_id = 608829

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3654688 1911725 1911725 plaintiff Bardefeld John (legal representative) 608829 608829 Bardefeld, John, of Essex, esq, executor of 0
3656651 1912332 1912332 defendant Battyshyll John   608829 608829 Battyshyll, John, of Essex, inn holder 2
3658705 1912976 1912976 plaintiff Fitzwilliam William   608829 608829 Fitzwilliam, William, of Essex, knight & Sheriff 0
3675691 1918429 1918429 plaintiff Monshawe James yeoman 608829 608829 Monshawe, James, of Essex, yeoman 1
3676432 1918672 1918672 defendant Browne Wistan   608829 608829 Browne, Wistan, of Abbess Rodyng, Essex, knight 0
3676434 1918673 1918673 defendant Browne Wistan   608829 608829 Browne, Wistan, of Abbess Rodyng, Essex, knight 0
3683121 1920839 1920839 plaintiff Veer John   608829 608829 Veer, John, of Essex, knight 0
3736518 1937669 1937669 defendant Broun John receiver in Essex for Duchy of Lancaster 608829 608829 Broun, John, of Abbess Rodyng, Essex, esq, son of Broun, Wistam, knight, receiver in Essex for Duchy of Lancaster 0
3743599 1939875 1939875 defendant Pryor John esq 608829 608829 Pryor, John, of Abbess Rothyng, Essex, esq 0
3859789 1976774 1976774 defendant Lukyn Thomas yeoman 608829 608829 Lukyn, Thomas, of Abbess Rothyng, Essex, yeoman 0
3934547 2001848 2001848 defendant Stevens Roger yeoman 608829 608829 Stevens, Roger, of Essex, yeoman 1
3944542 2005192 2005192 plaintiff Bateman John   608829 608829 Bateman, John, of Essex 0
3944598 2005208 2005208 plaintiff Baxster Robert   608829 608829 Baxster, Robert, of Essex 0
4095172 2058597 2058597 defendant Collyer Henry yeoman 608829 608829 Collyer, Henry, of Essex, yeoman 2
4153213 2079221 2079221 defendant Duffeild William chapman 608829 608829 Duffeild, William, of Essex, chapman 2
4384042 2159365 2159365 defendant More Edward gent 608829 608829 More, Edward, of Essex, gent 2
4385592 2159865 2159865 defendant Heckby Thomas chapman 608829 608829 Heckby, Thomas, of Essex, chapman 1
4385593 2159865 2159865 defendant Samuell Richard chapman 608829 608829 Samuell Richard, of Essex, chapman 2
4388035 2160628 2160628 defendant Stoke John gent 608829 608829 Stoke, John, of Essex, gent 1
4391361 2161728 2161728 defendant Stutfeilde Thomas esq 608829 608829 Stutfeilde, Thomas, of Essex, esq 0
4419221 2170888 2170888 defendant Gayesham Martin de   608829 608829 Gayesham, Martin de, of Essex, son of Henry 0
4419223 2170889 2170889 defendant Gaynesham Martin de   608829 608829 Gaynesham, Martin de, of Essex, son of Henry 0
4426178 2172992 2172992 plaintiff Nevill John de   608829 608829 Nevill, John de, of Essex, knight 0
4434612 2175588 2175588 defendant Mounteny John   608829 608829 Mounteny, John, of Essex 0
4436471 2176144 2176144 plaintiff Shortegrave John de   608829 608829 Shortegrave, John de, of Essex 0
4437953 2181190 2181190 defendant Herde Thomas   608829 608829 Herde, Thomas, of Essex 0
4445848 2183645 2183645 plaintiff Da--ill John   608829 608829 Da--ill, John, of Essex, formerly sheriff 0
4448224 2184362 2184362 plaintiff fitz Symond John   608829 608829 fitz Symond, John, of Essex, formerly sheriff for the King 0
4453540 2186116 2186116 defendant Rocheford Thomas   608829 608829 Rocheford, Thomas, of Essex 0
4453546 2186118 2186118 defendant Rocheford Thomas   608829 608829 Rocheford, Thomas, of Essex 0
4456791 2187131 2187131 plaintiff Osmunderle Peter   608829 608829 Osmunderle, Peter, of Essex 0
4458255 2187624 2187624 defendant Parker William   608829 608829 Parker, William, of Essex 1
4460950 2188493 2188493 defendant Stangore John   608829 608829 Stangore, John, of Essex 1
4461457 2188662 2188662 defendant Hakedwode John   608829 608829 Hakedwode, John, of Essex 0
4461459 2188663 2188663 defendant Haul--- John   608829 608829 Haul---, John, of Essex 0
4461537 2188687 2188687 defendant Haukewode John   608829 608829 Haukewode, John, of Essex 0
4464044 2189425 2189425 plaintiff Wale John de   608829 608829 Wale, John de, of Essex 0
4465475 2189869 2189869 defendant Tyrel Thomas   608829 608829 Tyrel, Thomas, of Essex 0
4468190 2190725 2190725 defendant Broun John   608829 608829 Broun, John, of Essex 4
4468197 2190726 2190726 defendant Broun John   608829 608829 Broun, John, of Essex 4
4469818 2191232 2191232 defendant Brokhole Geoffrey   608829 608829 (Brokhole, Geoffrey, of Essex, knight 1
4469829 2191233 2191233 defendant Brokhole Geoffrey   608829 608829 Brokhole, Geoffrey, of Essex, knight 0
4470392 2191388 2191388 defendant Northwych John   608829 608829 Northwych, John, of Essex 0
4471674 2191806 2191806 defendant Sautre William   608829 608829 Sautre, William, of Essex 0
4471885 2191870 2191870 defendant Scarlet Simon   608829 608829 Scarlet, Simon, of Essex 2
4471890 2191871 2191871 defendant Scarlet Simon   608829 608829 Scarlet, Simon, of Essex 2
4473176 2192275 2192275 defendant Betford John   608829 608829 Betford, John, of Essex 1
4478854 2194057 2194057 defendant Hymolby John   608829 608829 Hymolby, John, of Essex 1
4479567 2194270 2194270 defendant Worstede John   608829 608829 Worstede, John, of Essex 1
4479572 2194271 2194271 defendant Worstede John   608829 608829 Worstede, John, of Essex 1
4480231 2194476 2194476 plaintiff Knyvet Robert   608829 608829 Knyvet, Robert, of Essex 0
4480232 2194476 2194476 defendant Roklond John   608829 608829 Roklond, John, of Essex 0
4480247 2194483 2194483 defendant Malgrave Thomas esq 608829 608829 Malgrave, Thomas, of Essex, esq 0
4481590 2194938 2194938 defendant Audyn John   608829 608829 Audyn, John, of Essex 3
4483110 2195413 2195413 plaintiff Nerford Alice de (legal representative) 608829 608829 Nerford, Alice de, of Essex, formerly Lady Nevyll, executors of 0
4483312 2195481 2195481 defendant Criket William   608829 608829 Criket, William, of Essex 0
4483313 2195481 2195481 defendant Grene Thomas   608829 608829 Grene, Thomas, of Essex 1
4486489 2196484 2196484 defendant Pykenham John esq 608829 608829 Pykenham, John, of Essex, esq 0
4486509 2196489 2196489 defendant Pykenham John esq 608829 608829 Pykenham, John, of Essex, esq 0
4490826 2197829 2197829 defendant Preston Richard   608829 608829 Preston, Richard, of Essex 2
4490835 2197831 2197831 defendant Preston Richard   608829 608829 Preston, Richard, of Essex 2
4490836 2197831 2197831 defendant Preston Edmund   608829 608829 Preston, Edmund, of Essex 3
4493292 2198606 2198606 defendant Bourgersch Bartholomew gent 608829 608829 Bourgersch, Bartholomew, of Essex, gent 0
4493805 2198755 2198755 defendant Wynslowe John esq 608829 608829 Wynslowe, John, of Essex, esq 0
4495249 2199191 2199191 defendant Harlyngton John   608829 608829 Harlyngton, John, of Essex 3
4497151 2199767 2199767 defendant atte Lee Thomas   608829 608829 atte Lee, Thomas, of Essex 0
4497154 2199768 2199768 defendant atte Lee Thomas   608829 608829 atte Lee, Thomas, of Essex 0
4502745 2201437 2201437 defendant Wilcombe John esq 608829 608829 Wilcombe, John, of Essex, esq 1
4503978 2201800 2201800 defendant Boleyn Robert   608829 608829 Boleyn, Robert, of Essex 0
4503980 2201801 2201801 defendant Boleyn Robert   608829 608829 Boleyn, Robert, of Essex 0
4504963 2202094 2202094 defendant Pritewell John esq 608829 608829 Pritewell, John, of Essex, esq 0
4505979 2202381 2202381 defendant Pretilwell John esq 608829 608829 Pretilwell, John, of Essex, esq 0
4505981 2202381 2202381 defendant Clopston William   608829 608829 Clopston, William, of Essex 2
4508930 2203270 2203270 defendant Wormele John   608829 608829 Wormele, John, of Essex 0
4509821 2203557 2203557 defendant Burgh Bartholomew   608829 608829 Burgh, Bartholomew, of Essex, knight 0
4510493 2203745 2203745 defendant Aston Thomas esq 608829 608829 Aston, Thomas, of Essex, esq 0
4510641 2203784 2203784 defendant Spue Richard esq 608829 608829 Spue, Richard, of Essex, esq 0
4510643 2203785 2203785 defendant Spice Richard esq 608829 608829 Spice, Richard, of Essex, esq 0
4511311 2203983 2203983 defendant Beures John   608829 608829 Beures, John, of Essex, esq, formerly living with Thomas Swynbourn, knight 3
4511610 2204082 2204082 defendant Stystede Walter   608829 608829 Stystede, Walter, of Essex 2
4512956 2204485 2204485 defendant Coggessale William   608829 608829 Coggessale, William, of Essex, knight 0
4515473 2205258 2205258 defendant Malgrave Thomas   608829 608829 Malgrave, Thomas, of Essex 1
4517342 2205826 2205826 defendant fitz Eustace Philip esq 608829 608829 fitz Eustace, Philip, of Essex, esq 0
4518700 2206223 2206223 plaintiff Spice Clement   608829 608829 Spice, Clement, of Essex 1
4520764 2206835 2206835 defendant Malgrave Thomas   608829 608829 Malgrave, Thomas, of Essex 1
4523767 2207763 2207763 defendant Hart William   608829 608829 Hart, William, of Essex 1
4525501 2208304 2208304 defendant Bowys William esq 608829 608829 Bowys, William, of Essex, esq 0
4525504 2208305 2208305 defendant Bowys William esq 608829 608829 Bowys, William, of Essex, esq 0
4526066 2208449 2208449 defendant Aungre John (legal representative) 608829 608829 Aungre, John, of Essex, executors of 0
4526070 2208450 2208450 defendant Kungre John (legal representative) 608829 608829 Kungre, John, of Essex, executors of 0
4528101 2209070 2209070 defendant Carte John   608829 608829 Carte, John, of Essex 0
4529122 2209383 2209383 defendant Bovey John   608829 608829 Bovey, John, of Essex 0
4532866 2210547 2210547 defendant Gernoun Thomas esq 608829 608829 Gernoun, Thomas, of Essex, esq 2
4532870 2210549 2210549 defendant (illegible) Thomas esq 608829 608829 _, Thomas, of Essex, esq 0
4535118 2211262 2211262 defendant Barley John esq 608829 608829 Barley, John, of Essex, esq 3
4535125 2211263 2211263 defendant Barley John esq 608829 608829 Barley, John, of Essex, esq 3
4539270 2212539 2212539 defendant Braham John chandler 608829 608829 Braham, John, of Essex, chandler 0
4542450 2213526 2213526 defendant Coggeshale William   608829 608829 Coggeshale, William, of Essex, knight 0
4545546 2214531 2214531 defendant Herle John   608829 608829 Herle, John, of Essex 0
4546476 2214831 2214831 plaintiff Bridbrook John clerk 608829 608829 Bridbrook, John, of Essex, clerk 0

Next page

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