names

108 rows where place_id = 587870

✎ 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
3592691 1865328 1865328 defendant Bolle Richard husbandman 587870 587870 Bolle, Richard, of Chartham, husbandman 0
3655319 1911921 1911921 defendant Webbe John husbandman 587870 587870 Webbe, John, of Chartham, husbandman 1
3655320 1911921 1911921 defendant Swyft Stephen husbandman 587870 587870 Swyft, Stephen, of Chartham, husbandman 2
3666324 1915418 1915418 defendant Thomas Strong   587870 587870 Thomas, Strong, of Chartham, blade smith 3
3666325 1915418 1915418 defendant Hayle William laborer 587870 587870 Hayle, William, of Chartham, laborer 4
3666693 1915530 1915530 defendant Fox William, junior husbandman 587870 587870 Fox, William, junior, of Chartham, husbandman 1
3671288 1916994 1916994 defendant Stopell John husbandman 587870 587870 Stopell, John, of Chartham, husbandman 1
3716480 1931446 1931446 defendant Empston John husbandman 587870 587870 Empston, John, of Chartham, husbandman 0
3722007 1933146 1933146 defendant Byng John yeoman 587870 587870 Byng, John, of Chartham, yeoman 0
3722008 1933146 1933146 defendant Byng Richard husbandman 587870 587870 Byng, Richard, of Chartham, husbandman 1
3728955 1935303 1935303 defendant Bedford Quintin husbandman 587870 587870 Bedford, Quintin, of Chartham, husbandman 0
3730183 1935666 1935666 defendant Webbe John husbandman 587870 587870 Webbe, John, of Chartham, husbandman 0
3730184 1935666 1935666 defendant Swyft Stephen husbandman 587870 587870 Swyft, Stephen, of Chartham, husbandman 1
3731656 1936129 1936129 defendant Stopell John husbandman 587870 587870 Stopell, John, of Chartham, husbandman 0
3738957 1938390 1938390 defendant Standeley John fuller 587870 587870 Standeley, John, of Chartham, fuller 0
3743698 1939911 1939911 defendant Bedford Quintin husbandman 587870 587870 Bedford, Quintin, of Chartham, husbandman 0
3743699 1939911 1939911 defendant Berlyng Thomas laborer 587870 587870 Berlyng, Thomas, of Chartham, laborer 1
3743703 1939911 1939911 defendant Nethersole John laborer 587870 587870 Nethersole, John, of Chartham, laborer 5
3748791 1941556 1941556 defendant Mayster Richard dyer 587870 587870 Mayster, Richard, of Chartham, dyer 0
3750267 1942000 1942000 defendant Stopell John husbandman 587870 587870 Stopell, John, of Chartham, husbandman 0
3787958 1954027 1954027 defendant Stopell John husbandman 587870 587870 Stopell, John, of Chartham, husbandman 0
3787959 1954027 1954027 defendant Byng John husbandman 587870 587870 Byng, John, of Chartham, husbandman 1
3791917 1955316 1955316 defendant Rygdon Stephen husbandman 587870 587870 Rygdon, Stephen, of Chartham, husbandman 0
3802553 1958694 1958694 defendant Dubbelrose William laborer 587870 587870 Dubbelrose, William, of Chartham, laborer 3
3804173 1959238 1959238 defendant Stopell John husbandman 587870 587870 Stopell, John, of Chartham, husbandman 0
3804174 1959238 1959238 defendant Byng John husbandman 587870 587870 Byng, John, of Chartham, husbandman 1
3812704 1961868 1961868 defendant Myllys Robert weaver 587870 587870 Myllys, Robert, of Chartham, weaver 0
3867467 1979354 1979354 defendant Byng John husbandman 587870 587870 Byng, John, of Chartham, husbandman 0
3949196 2006788 2006788 defendant Rigdon Thomas gent 587870 587870 Rigdon, Thomas, of Chartham, gent 0
3956496 2009338 2009338 defendant Wynter Edmund gent 587870 587870 Wynter, Edmund, of Chartham, gent 0
3956498 2009339 2009339 defendant Wynter Edmund gent 587870 587870 Wynter, Edmund, of Chartham, gent 0
3981959 2018309 2018309 defendant Chackley John husbandman 587870 587870 Chackley, John, of Chartham, husbandman 5
4022513 2032777 2032777 defendant Cornewall David gent 587870 587870 Cornewall, David, of Chartham, gent 0
4022516 2032778 2032778 defendant Cornewall David gent 587870 587870 Cornewall, David, of Chartham, gent 0
4026402 2034086 2034086 defendant Freman Nicholas gent 587870 587870 Freman, Nicholas, of Chartham, gent 0
4044801 2040592 2040592 defendant Baldock Robert chapman 587870 587870 Baldock, Robert, of Chartham, chapman 2
4151653 2078694 2078694 defendant George Nicholas husbandman 587870 587870 George, Nicholas, of Chartham, husbandman 0
4228748 2105540 2105540 defendant Chapman Vincent yeoman 587870 587870 Chapman, Vincent, of Chartham, yeoman 0
4229565 2105827 2105827 defendant George Nicholas yeoman 587870 587870 George, Nicholas, of Chartham, yeoman 0
4233869 2107374 2107374 defendant Bunce Henry yeoman 587870 587870 Bunce, Henry, of Chartham, yeoman 0
4312875 2134630 2134630 defendant Dunce Henry yeoman 587870 587870 Dunce, Henry, of Chartham, yeoman 0
4324663 2138640 2138640 defendant Bennett Robert yeoman 587870 587870 Bennett, Robert, of Chartham, yeoman 0
4328735 2139920 2139920 defendant Tayler Nicholas yeoman 587870 587870 Tayler, Nicholas, of Chartham, yeoman 2
4355431 2149122 2149122 defendant Farbrace Lawrence yeoman 587870 587870 Farbrace, Lawrence, of Chartham, yeoman 0
4357829 2149980 2149980 defendant Bungey John gent 587870 587870 Bungey, John, of Chartham, gent 0
4364848 2152480 2152480 defendant Baker Thomas carpenter 587870 587870 Baker, Thomas, of Chartham, carpenter 0
4487085 2196684 2196684 defendant Salmon John   587870 587870 Salmon, John, of Chartham 0
4488476 2197114 2197114 defendant Cook Henry   587870 587870 Cook, Henry, of Chartham 0
4506498 2202530 2202530 defendant Coupere William   587870 587870 Coupere, William, of Chartham 0
4572439 2222920 2222920 defendant Stretende Richard   587870 587870 Stretende, Richard, of Chartham 0
4572442 2222920 2222920 defendant Scot John   587870 587870 Scot, John, of Chartham 3
4597398 2230429 2230429 defendant Rysshere Robert   587870 587870 Rysshere, Robert, of Chartham 0
4648842 2245721 2245721 defendant Morle John   587870 587870 Morle, John, of chartham 0
4657856 2248344 2248344 defendant Baker William baker 587870 587870 Baker, William, of Chartham, baker 0
4670828 2256556 2256556 defendant Bolle Thomas clerk 587870 587870 Bolle, Thomas, of Chartham, clerk 0
4674113 2257511 2257511 defendant Kyngesford Thomas   587870 587870 Kyngesford, Thomas, of Chartham, husband or husbandman 1
4684779 2260836 2260836 plaintiff Arthur Robert   587870 587870 (Arthur, Robert, of Chartham, parson 1
4696348 2264337 2264337 defendant Baker Walter husbandman 587870 587870 Baker, Walter, of Chartham, husbandman 0
4702277 2266121 2266121 defendant Haukeslond Henry carpenter 587870 587870 Haukeslond, Henry, of Chartham, carpenter 1
4704440 2266764 2266764 defendant Walware Nicholas husbandman 587870 587870 Walware, Nicholas, of Chartham, husbandman 0
4721361 2272013 2272013 defendant atte Sole John husbandman 587870 587870 atte Sole, John, of Chartham, husbandman 0
4729450 2274423 2274423 defendant atte Sole John laborer 587870 587870 atte Sole, John, of Chartham, laborer 0
4771177 2286968 2286968 defendant Bolle William husbandman 587870 587870 Bolle, William, of Chartham, husbandman 0
4771179 2286969 2286969 defendant Bolle William husbandman 587870 587870 Bolle, William, of Chartham, husbandman 0
4771180 2286969 2286969 defendant Fordmelle William yeoman 587870 587870 Fordmelle, William, of Chartham, yeoman 1
4796041 2294912 2294912 defendant Boller William husbandman 587870 587870 Boller, William, of Chartham, husbandman 0
4796042 2294912 2294912 defendant Fordmelle William yeoman 587870 587870 Fordmelle, William, of Chartham, yeoman 1
4796045 2294913 2294913 defendant Bolle William husbandman 587870 587870 Bolle, William, of Chartham, husbandman 0
4806285 2298173 2298173 defendant Thruxstede John gent 587870 587870 Thruxstede, John, of Chartham, gent 0
4819973 2302324 2302324 defendant Bolles William tanner 587870 587870 Bolles, William, of Chartham, tanner 0
4819974 2302324 2302324 defendant Fordmell William, junior husbandman 587870 587870 Fordmell, William, junior, of Chartham, husbandman 1
4819975 2302324 2302324 defendant Balsnoth William husbandman 587870 587870 Balsnoth, William, of Chartham, husbandman 2
4853554 2312526 2312526 defendant Kyngesforde Thomas, sen laborer 587870 587870 Kyngesforde, Thomas, sen, of Chartham, laborer 0
4870400 2317719 2317719 defendant Thruxsted John husbandman 587870 587870 Thruxsted, John, of Chartham, husbandman 0
4892849 2324494 2324494 defendant Bolle William husbandman 587870 587870 Bolle, William, of Chartham, husbandman 0
4907031 2328775 2328775 defendant Haukyslond Richard carpenter 587870 587870 Haukyslond, Richard, of Chartham, carpenter 0
4956894 2344021 2344021 defendant Kyngesforthe Thomas husbandman 587870 587870 Kyngesforthe, Thomas, of Chartham, husbandman 2
4956895 2344021 2344021 defendant Formelle John husbandman 587870 587870 Formelle, John, of Chartham, husbandman 3
4956896 2344021 2344021 defendant Bolle William   587870 587870 Bolle, William, of Chartham, bailiff 4
4958696 2344568 2344568 defendant Fordmelle William fuller 587870 587870 Fordmelle, William, of Chartham, fuller 1
4990460 2354058 2354058 defendant Bolle William butcher 587870 587870 Bolle, William, of Chartham, butcher 0
5006117 2358678 2358678 defendant Hewet John   587870 587870 Hewet, John, of Chartham, franklin 1
5024036 2363940 2363940 defendant Noryngton John fuller 587870 587870 Noryngton, John, of Chartham, fuller 0
5038919 2368286 2368286 defendant Aleyn Robert husbandman 587870 587870 Aleyn, Robert, of Chartham, husbandman 0
5079212 2380274 2380274 defendant Boll William husbandman 587870 587870 Boll, William, of Chartham, husbandman 0
5097697 2385752 2385752 defendant Peryn Hamond husbandman 587870 587870 Peryn, Hamond, of Chartham, husbandman 0
5115723 2391026 2391026 defendant Webbe Thomas husbandman 587870 587870 Webbe, Thomas, of Chartham, husbandman 0
5272912 2437150 2437150 defendant Jenyn Joan widow 587870 587870 Jenyn, Joan, of Chartham, widow 3
5282025 2439815 2439815 defendant Haukeslond William yeoman 587870 587870 Haukeslond, William, of Chartham, yeoman 0
5322266 2451729 2451729 defendant Bynge Nicholas farmer of the rectory and manor of Patrikesbourne 587870 587870 Bynge, Nicholas, of Chartham, or of Patrykesbourne, husbandman, farmer of the rectory and manor of Patrikesbourne 0
5322756 2451882 2451882 defendant Bolle Thomas tanner 587870 587870 Bolle, Thomas, of Chartham, tanner 0
5336713 2456049 2456049 defendant Webbe Robert husbandman 587870 587870 Webbe, Robert, of Chartham, husbandman 0
5348099 2459548 2459548 defendant Barun John husbandman 587870 587870 Barun, John, of Chartham, husbandman 0
5360219 2463237 2463237 defendant Pokyll John husbandman 587870 587870 Pokyll, John, of Chartham, husbandman 3
5385513 2470928 2470928 defendant Elsam Lawrence (legal representative) 587870 587870 Elsam, Lawrence, of Chartham, husbandman, executors of 1
5388443 2471742 2471742 defendant _nende William husbandman 587870 587870 _nende, William, of Chartham, husbandman 0
5401023 2475354 2475354 defendant Ovende William husbandman 587870 587870 Ovende, William, of Chartham, husbandman 0
5405644 2476688 2476688 defendant Elsam or Elfam Lawrence (legal representative) 587870 587870 Elsam or Elfam, Lawrence, of Chartham, husbandman, executors of 0
5410768 2478169 2478169 defendant Elphem Lawrence (legal representative) 587870 587870 Elphem, Lawrence, of Chartham, husbandman, executors of 0
5431155 2484258 2484258 defendant Stot John husbandman 587870 587870 Stot, John, of Chartham, husbandman 2

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