names

92 rows where place_id = 753166

✎ 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
4411664 2168498 2168498 defendant Crofte Richard gent 753166 753166 Crofte, Richard, of Hertfordshire, gent 1
4418324 2170613 2170613 defendant Haule John de   753166 753166 Haule, John de, of Hertfordshire 0
4422979 2172044 2172044 defendant Holewell John de   753166 753166 Holewell, John de, of Hertfordshire, son of William 0
4434338 2175499 2175499 defendant Holewell John de   753166 753166 Holewell, John de, of Hertfordshire 0
4434340 2175500 2175500 defendant Holewell John   753166 753166 Holewell, John, of Hertfordshire 0
4437663 2176537 2176537 defendant Holewell John de   753166 753166 Holewell, John de, of Hertfordshire 0
4473419 2192348 2192348 defendant Hatton Richard   753166 753166 Hatton, Richard, of Hertfordshire 4
4483277 2195468 2195468 defendant Sautre Henry   753166 753166 Sautre, Henry, of Hertfordshire 0
4486241 2196404 2196404 defendant Waryn William   753166 753166 Waryn, William, of Hertfordshire 0
4487756 2196888 2196888 defendant Hotot Nicholas   753166 753166 Hotot, Nicholas, of Hertfordshire 2
4488560 2197141 2197141 defendant Chiltern Henry   753166 753166 Chiltern, Henry, of Hertfordshire 3
4489573 2197457 2197457 defendant Hotot Nicholas   753166 753166 Hotot, Nicholas, of Hertfordshire 0
4491251 2197952 2197952 defendant Fauconer Edmund   753166 753166 Fauconer, Edmund, of Hertfordshire 2
4500488 2200774 2200774 defendant Chival William   753166 753166 Chival, William, of Hertfordshire 0
4509450 2203425 2203425 defendant Gloucestre John esq 753166 753166 Gloucestre, John, of Hertfordshire, esq 2
4517569 2205891 2205891 defendant Hampton William esq 753166 753166 Hampton, William, of Hertfordshire, esq 0
4521012 2206906 2206906 defendant Shelle Richard clerk 753166 753166 Shelle, Richard, of Hertfordshire, clerk 2
4521016 2206907 2206907 defendant Shelle Richard   753166 753166 Shelle, Richard, of Hertfordshire 2
4528182 2209085 2209085 defendant Hogges Robert   753166 753166 Hogges, Robert, of Hertfordshire 1
4528199 2209093 2209093 defendant Colyn Richard   753166 753166 Colyn, Richard, of Hertfordshire 0
4534837 2211179 2211179 defendant Eton Richard esq 753166 753166 Eton, Richard, of Hertfordshire, esq 1
4534843 2211180 2211180 defendant Eton Richard esq 753166 753166 Eton, Richard, of Hertfordshire, esq 1
4540759 2213013 2213013 defendant Doune John   753166 753166 Doune, John, of Hertfordshire 0
4542045 2213403 2213403 defendant Barton Thomas   753166 753166 Barton, Thomas, of Hertfordshire 1
4552903 2216852 2216852 defendant Cattemere John   753166 753166 Cattemere, John, of Hertfordshire 2
4552907 2216853 2216853 defendant Cattemere John   753166 753166 Cattemere, John, of Hertfordshire 2
4554127 2217214 2217214 defendant Botok Thomas   753166 753166 Botok, Thomas, of Hertfordshire 0
4554129 2217215 2217215 defendant Gocok Thomas   753166 753166 Gocok, Thomas, of Hertfordshire 0
4557718 2218350 2218350 defendant Hodell John   753166 753166 Hodell, John, of Hertfordshire 0
4558637 2218655 2218655 plaintiff Lynster Roger   753166 753166 Lynster, Roger, of Hertfordshire 0
4561375 2219504 2219504 defendant Moppys John   753166 753166 Moppys, John, of Hertfordshire 1
4569660 2222095 2222095 defendant Horsman Richard   753166 753166 Horsman, Richard, of Hertfordshire 0
4577082 2224342 2224342 defendant Criktot William esq 753166 753166 Criktot, William, of Hertfordshire, esq 1
4578492 2224764 2224764 defendant Poklyngton John   753166 753166 Poklyngton, John, of Hertfordshire 0
4582619 2226003 2226003 plaintiff Farndon Thomas   753166 753166 Farndon, Thomas, of Hertfordshire 0
4584214 2226477 2226477 defendant Kirkeby Henry   753166 753166 Kirkeby, Henry, of Hertfordshire 0
4584887 2226705 2226705 defendant Wetherherd William   753166 753166 Wetherherd, William, of Hertfordshire 0
4586391 2227158 2227158 defendant Newel John esq 753166 753166 Newel, John, of Hertfordshire, esq 0
4586395 2227159 2227159 defendant Nowel John   753166 753166 Nowel, John, of Hertfordshire 0
4588917 2227907 2227907 defendant Braghyng Agnes   753166 753166 Braghyng, Agnes, of Hertfordshire 0
4590289 2228333 2228333 plaintiff Malle John   753166 753166 Malle, John, of Hertfordshire, kinsman & an heir of John atte Dene, of Horstede Kaynes, Sussex 0
4600957 2231526 2231526 defendant Heyward William   753166 753166 Heyward, William, of Hertfordshire 3
4601853 2231803 2231803 defendant Lynster Roger   753166 753166 Lynster, Roger, of Hertfordshire 0
4601856 2231804 2231804 defendant Lynster Roger   753166 753166 Lynster, Roger, of Hertfordshire 0
4605930 2232968 2232968 defendant Louthe Robert de   753166 753166 Louthe, Robert de, of Hertfordshire 0
4609699 2234129 2234129 defendant Horwod John   753166 753166 Horwod, John, of Hertfordshire 4
4609706 2234130 2234130 defendant Horwod John   753166 753166 Horwod, John, of Hertfordshire 5
4612163 2234870 2234870 plaintiff Corbet Thomas esq 753166 753166 Corbet, Thomas, of Hertfordshire, esq 0
4617369 2236446 2236446 defendant Bowyer alias Hille John tailor 753166 753166 Bowyer alias Hille, John, of Hertfordshire, tailor 3
4624141 2238528 2238528 defendant Seberne William   753166 753166 Seberne, William, of Hertfordshire 0
4628391 2239805 2239805 defendant Skeyn William   753166 753166 Skeyn, William, of Hertfordshire 2
4630482 2240447 2240447 defendant Norwode Sampson   753166 753166 Norwode, Sampson, of Hertfordshire 1
4630746 2240509 2240509 defendant Bakous Gilbert   753166 753166 Bakous, Gilbert, of Hertfordshire 3
4630750 2240509 2240509 defendant Bende John   753166 753166 Bende, John, of Hertfordshire 7
4631109 2240627 2240627 defendant Leche Lawrence   753166 753166 Leche, Lawrence, of Hertfordshire 0
4636051 2242107 2242107 defendant Louthe Robert de   753166 753166 Louthe, Robert de, of Hertfordshire 2
4636055 2242108 2242108 defendant Louthe Robert de   753166 753166 Louthe, Robert de, of Hertfordshire 2
4640107 2243225 2243225 defendant Beelchaumbre John   753166 753166 Beelchaumbre, John, of Hertfordshire 1
4640110 2243225 2243225 defendant Foyset William   753166 753166 Foyset, William, of Hertfordshire 4
4640113 2243226 2243226 defendant Beelchaumbre John   753166 753166 Beelchaumbre, John, of Hertfordshire 1
4640116 2243226 2243226 defendant Foyset William   753166 753166 Foyset, William, of Hertfordshire 4
4641167 2243508 2243508 defendant Adam John   753166 753166 Adam, John, of Hertfordshire 1
4642589 2243951 2243951 defendant Gedeleston Giffard de   753166 753166 Gedeleston, Giffard de, of Hertfordshire 4
4644078 2244367 2244367 defendant Heynes Robert   753166 753166 Heynes, Robert, of Hertfordshire 1
4644606 2244515 2244515 defendant Hay Richard esq 753166 753166 Hay, Richard, of Hertfordshire, esq 0
4644613 2244516 2244516 defendant Hay Richard esq 753166 753166 Hay, Richard, of Hertfordshire, esq 0
4645151 2244651 2244651 defendant Rykemesworth William de   753166 753166 Rykemesworth, William de, of Hertfordshire 0
4645288 2244689 2244689 defendant Rykemesworth William de   753166 753166 Rykemesworth, William de, of Hertfordshire 0
4646651 2245085 2245085 defendant Basset Richard   753166 753166 Basset, Richard, of Hertfordshire 0
4649094 2245782 2245782 defendant Pulton Robert de dyer 753166 753166 Pulton, Robert de, of Hertfordshire, dyer 0
4682606 2260179 2260179 defendant Syward Thomas (legal representative) 753166 753166 Syward, Thomas, of Hertfordshire, esq, executors of 0
4759536 2283325 2283325 plaintiff Kirkeby John   753166 753166 Kirkeby, John, of Hertfordshire 3
4759543 2283326 2283326 plaintiff Kirkeby John   753166 753166 Kirkeby, John, of Hertfordshire 3
4772943 2287509 2287509 defendant Baskervyle John (legal representative) 753166 753166 Baskervyle, John, of Hertfordshire, executor of 0
4917914 2332118 2332118 plaintiff Goldston John   753166 753166 Goldston, John, of Hertfordshire 0
4917915 2332118 2332118 defendant Goldston John   753166 753166 Goldston, John, of Hertfordshire 0
4989262 2353721 2353721 defendant Acton or Atton Richard   753166 753166 Acton or Atton, Richard, of Hertfordshire, gent, formerly of Porter Merston 0
5049742 2371548 2371548 plaintiff Sterke Peter   753166 753166 Sterke, Peter, of Hertfordshire 0
5126764 2394305 2394305 defendant Croke Edward   753166 753166 Croke, Edward, of Hertfordshire 0
5126963 2394365 2394365 defendant Lesechyld Thomas chapman 753166 753166 Lesechyld, Thomas, of Hertfordshire, chapman 0
5133919 2396416 2396416 defendant Leventhorp John gent 753166 753166 Leventhorp, John, of Hertfordshire, gent 0
5134137 2396479 2396479 defendant Crek-- John esq 753166 753166 Crek--, John, of Hertfordshire, esq 0
5305215 2446565 2446565 defendant Plummer William yeoman 753166 753166 Plummer, William, of Hertfordshire, yeoman 4
5369198 2465968 2465968 defendant Maynweryng Peter gent 753166 753166 Maynweryng, Peter, of Hertfordshire, gent 0
5394894 2473610 2473610 defendant Spenlove Edward (legal representative) 753166 753166 Spenlove, Edward, of Hertfordshire, gent, executors of 0
5408130 2477405 2477405 defendant Spenlove Edward (legal representative) 753166 753166 Spenlove, Edward, of Hertfordshire, gent, executors of 0
5408371 2477475 2477475 defendant Rawe John spicer 753166 753166 Rawe, John, of Hertfordshire, spicer 0
5410252 2478018 2478018 plaintiff Garnage Thomas clerk 753166 753166 Garnage, Thomas, of Hertfordshire, clerk 1
5418627 2480495 2480495 plaintiff Say William   753166 753166 Say, William, of Hertfordshire, knight & formerly sheriff 0
5421308 2481307 2481307 defendant Spenlove Edward (legal representative) 753166 753166 Spenlove, Edward, of Hertfordshire, executors of 0
5449328 2489688 2489688 defendant Banastr Lawrence clerk 753166 753166 Banastr, Lawrence, of Hertfordshire, clerk 4
5473787 2497134 2497134 defendant (illegible) John yeoman 753166 753166 _, John, of Hertfordshire, yeoman 4

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