names

138 rows where place_id = 596022

✎ 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
3622797 1874661 1874661 defendant Halsnoth Thomas husbandman 596022 596022 Halsnoth, Thomas, of Halden, husbandman 0
3628514 1903787 1903787 defendant Pett Thomas yeoman 596022 596022 Pett, Thomas, of Halden, yeoman 2
3632002 1904825 1904825 defendant Egerden Stephen husbandman 596022 596022 Egerden, Stephen, of Halden, husbandman 0
3667950 1915916 1915916 defendant Norton Thomas yeoman 596022 596022 Norton, Thomas, of Halden, yeoman 1
3690978 1923341 1923341 defendant Egerdon Stephen yeoman 596022 596022 Egerdon, Stephen, of Halden, yeoman 0
3698476 1925743 1925743 defendant Frencham Edward yeoman 596022 596022 Frencham, Edward, of Halden, yeoman 0
3712114 1930106 1930106 defendant Frencham Edward yeoman 596022 596022 Frencham, Edward, of Halden, yeoman 0
3718479 1932059 1932059 plaintiff Frencheham Edward yeoman 596022 596022 Frencheham, Edward, of Halden, yeoman 0
3718486 1932060 1932060 plaintiff Frengham Edward   596022 596022 (Frengham, Edward, of Halden 1
3726802 1934649 1934649 defendant Frencham Edward yeoman 596022 596022 Frencham, Edward, of Halden, yeoman 1
3734217 1936944 1936944 plaintiff Frencheham Edward yeoman 596022 596022 Frencheham, Edward, of Halden, yeoman 0
3746455 1940811 1940811 defendant Morys Thomas husbandman 596022 596022 Morys, Thomas, of Halden, husbandman 0
3746899 1940946 1940946 defendant Frencham Edward yeoman 596022 596022 Frencham, Edward, of Halden, yeoman 1
3770099 1948312 1948312 plaintiff Scott Henry clothier 596022 596022 Scott, Henry, of Halden, clothier 0
3807454 1960235 1960235 defendant Frentcham Edward yeoman 596022 596022 Frentcham, Edward, of Halden, yeoman 0
3807456 1960236 1960236 defendant Nele John carver 596022 596022 Nele, John, of Halden, carver 0
3815391 1962730 1962730 defendant Morys Thomas laborer 596022 596022 Morys, Thomas, of Halden, laborer 2
3815924 1962886 1962886 defendant Frencham Edward yeoman 596022 596022 Frencham, Edward, of Halden, yeoman 0
3815925 1962886 1962886 defendant Lynche Thomas butcher 596022 596022 Lynche, Thomas, of Halden, butcher 1
3815926 1962886 1962886 defendant Morys Thomas grasier 596022 596022 Morys, Thomas, of Halden, grasier 2
3852110 1974256 1974256 defendant Pyx Robert yeoman 596022 596022 Pyx, Robert, of Halden, yeoman 1
3919818 1996964 1996964 plaintiff Lucas John gent 596022 596022 Lucas, John, of Halden, gent 0
3955588 2009025 2009025 plaintiff Mayney John esq 596022 596022 Mayney, John, of Halden, esq 0
3981597 2018174 2018174 defendant Wood Thomas sherman 596022 596022 Wood, Thomas, of Halden, sherman 1
3992629 2022109 2022109 defendant Nethersole George gent 596022 596022 Nethersole, George, of Halden, gent 0
3992631 2022110 2022110 defendant Nethersole George gent 596022 596022 Nethersole, George, of Halden, gent 0
3998974 2024391 2024391 defendant Nethersole George gent 596022 596022 Nethersole, George, of Halden, gent 0
4008310 2027736 2027736 defendant Nethersole George yeoman 596022 596022 Nethersole, George, of Halden, yeoman 0
4012442 2029174 2029174 defendant Wymsherst Alexander wheeler 596022 596022 Wymsherst, Alexander, of Halden, wheeler 0
4106990 2062796 2062796 defendant Grynsted John yeoman 596022 596022 Grynsted, John, of Halden, yeoman 0
4214190 2100481 2100481 defendant Jorden Robert yeoman 596022 596022 Jorden, Robert, of Halden, yeoman 0
4223866 2103834 2103834 defendant Jorden Robert yeoman 596022 596022 Jorden, Robert, of Halden, yeoman 0
4229131 2105670 2105670 defendant Neale Jeremiah husbandman 596022 596022 Neale, Jeremiah, of Halden, husbandman 2
4277688 2122121 2122121 defendant Harman Thomas clerk 596022 596022 Harman, Thomas, of Halden, clerk 0
4323216 2138180 2138180 defendant Ince William innholder 596022 596022 Ince, William, of Halden, innholder 0
4335903 2142288 2142288 defendant Cruttynden Edward husbandman 596022 596022 Cruttynden, Edward, of Halden, husbandman 0
4335904 2142288 2142288 defendant Cruttynden Josias husbandman 596022 596022 Cruttynden, Josias, of Halden, husbandman 1
4350158 2147314 2147314 defendant Hedgman William yeoman 596022 596022 Hedgman, William, of Halden, yeoman 0
4371889 2155007 2155007 defendant Brickkenden Robert glover 596022 596022 Brickkenden, Robert, of Halden, glover 0
4383861 2159306 2159306 defendant Cruttynden Edward husbandman 596022 596022 Cruttynden, Edward, of Halden, husbandman 0
4383862 2159306 2159306 defendant Cruttynden Josiah husbandman 596022 596022 Cruttynden, Josiah, of Halden, husbandman 1
4483708 2195596 2195596 defendant Bealde John   596022 596022 Bealde, John, of Halden 3
4483714 2195597 2195597 defendant Wealde John   596022 596022 Wealde, John, of Halden 3
4538903 2212439 2212439 defendant Smyth William   596022 596022 Smyth, William, of Halden 4
4661371 2249380 2249380 defendant Hodyngfold Richard husbandman 596022 596022 Hodyngfold, Richard, of Halden, husbandman 0
4675950 2258088 2258088 defendant Ricard John   596022 596022 Ricard, John, of Halden, plough man 0
4678436 2258862 2258862 defendant Lucas Robert laborer 596022 596022 Lucas, Robert, of Halden, laborer 0
4701235 2265786 2265786 defendant Ricard John   596022 596022 Ricard, John, of Halden, plough man 0
4703927 2266605 2266605 defendant Lucas Robert husbandman 596022 596022 Lucas, Robert, of Halden, husbandman 1
4703928 2266605 2266605 defendant Lucas Richard   596022 596022 Lucas, Richard, of Halden, arrow maker 2
4720118 2271636 2271636 defendant Berye Peter smith 596022 596022 Berye, Peter, of Halden, smith 0
4725389 2273234 2273234 defendant Ricard John ploughman 596022 596022 Ricard, John, of Halden, ploughman 0
4727913 2273972 2273972 defendant Chilton John carpenter 596022 596022 Chilton, John, of Halden, carpenter 0
4754812 2281885 2281885 defendant atte Hope Richard carter 596022 596022 atte Hope, Richard, of Halden, carter 0
4759368 2283272 2283272 defendant Pyers Nicholas yeoman 596022 596022 Pyers, Nicholas, of Halden, yeoman 2
4760795 2283714 2283714 defendant Pyers Nicholas yeoman 596022 596022 Pyers, Nicholas, of Halden, yeoman 0
4776360 2288599 2288599 defendant atte Hope Richard husbandman 596022 596022 atte Hope, Richard, of Halden, husbandman 0
4781514 2290228 2290228 defendant Piers Nicholas yeoman 596022 596022 Piers, Nicholas, of Halden, yeoman 1
4821750 2302879 2302879 defendant Ricard John, junior husbandman 596022 596022 Ricard, John, junior, of Halden, husbandman 0
4825036 2303870 2303870 defendant Hodyngfolde Richard yeoman 596022 596022 Hodyngfolde, Richard, of Halden, yeoman 0
4833259 2306411 2306411 defendant atte Hope Richard husbandman 596022 596022 atte Hope, Richard, of Halden, husbandman 1
4838373 2307915 2307915 defendant atte Hope Joan husbandman 596022 596022 atte Hope, Joan, of Halden, husbandman 0
4838374 2307915 2307915 defendant atte Hale Thomas husbandman 596022 596022 atte Hale, Thomas, of Halden, husbandman 1
4863554 2315570 2315570 defendant atte Hope Richard husbandman 596022 596022 atte Hope, Richard, of Halden, husbandman 6
4892080 2324263 2324263 defendant Hodyngfold William, senior husbandman 596022 596022 Hodyngfold, William, senior, of Halden, husbandman 0
4904860 2328120 2328120 defendant Hodyngfold Richard   596022 596022 Hodyngfold, Richard, of Halden, husbandman, administrators of 0
4904863 2328120 2328120 defendant Hodyngfold William husbandman 596022 596022 Hodyngfold, William, of Halden, husbandman 3
4925148 2334299 2334299 defendant Hope Richard weaver 596022 596022 Hope, Richard, of Halden, weaver 0
4926887 2334839 2334839 defendant atte Hope Richard weaver 596022 596022 atte Hope, Richard, of Halden, weaver 0
4927643 2335080 2335080 defendant atte Hope John husbandman 596022 596022 atte Hope, John, of Halden, husbandman 2
4932141 2336448 2336448 defendant atte Hope Richard husbandman 596022 596022 atte Hope, Richard, of Halden, husbandman 1
4932435 2336539 2336539 defendant Whittherynden Moses laborer 596022 596022 Whittherynden, Moses, of Halden, laborer 0
4932436 2336539 2336539 defendant Lucas John weaver 596022 596022 Lucas, John, of Halden, weaver 1
4962074 2345563 2345563 defendant Harry Thomas clothmaker 596022 596022 Harry, Thomas, of Halden, clothmaker 0
4963485 2345990 2345990 defendant atte Hope Richard husbandman 596022 596022 atte Hope, Richard, of Halden, husbandman 0
4970140 2348019 2348019 plaintiff Harlakynden Roger fuller 596022 596022 Harlakynden, Roger, of Halden, fuller 0
4970142 2348020 2348020 plaintiff Harlakynden Roger fuller 596022 596022 Harlakynden, Roger, of Halden, fuller 0
4976127 2349815 2349815 defendant atte Hope Richard   596022 596022 atte Hope, Richard, of Halden, linen draper 1
4996657 2355854 2355854 plaintiff Harlakynden Roger fuller 596022 596022 Harlakynden, Roger, of Halden, fuller 0
4996703 2355871 2355871 plaintiff Harry Thomas fuller 596022 596022 Harry, Thomas, of Halden, fuller 0
5122378 2392971 2392971 defendant Pette Augustine husbandman 596022 596022 Pette, Augustine, of Halden, husbandman 0
5130688 2395464 2395464 defendant Bell Robert husbandman 596022 596022 Bell, Robert, of Halden, husbandman 3
5138754 2397831 2397831 defendant Egerynden James husbandman 596022 596022 Egerynden, James, of Halden, husbandman 0
5138755 2397832 2397832 plaintiff Rympynden Stephen   596022 596022 Rympynden, Stephen, of Halden 0
5138757 2397833 2397833 plaintiff Rympynden Stephen   596022 596022 Rympynden, Stephen, of Halden 0
5138760 2397834 2397834 plaintiff Rympyndon Stephen   596022 596022 Rympyndon, Stephen, of Halden 0
5150132 2401178 2401178 defendant Beelde Robert husbandman 596022 596022 Beelde, Robert, of Halden, husbandman 3
5159537 2403906 2403906 plaintiff Rympynden Stephen   596022 596022 Rympynden, Stephen, of Halden 0
5255238 2431754 2431754 defendant atte Hope Lawrence yeoman 596022 596022 atte Hope, Lawrence, of Halden, yeoman 0
5260250 2433332 2433332 defendant Bregeman Thomas   596022 596022 Bregeman, Thomas, of Halden, chapman, executorsof 5
5260251 2433332 2433332 defendant Carpenter Richard husbandman 596022 596022 (Carpenter, Richard, of Halden, husbandman 6
5263843 2434447 2434447 defendant Dewer Robert husbandman 596022 596022 Dewer, Robert, of Halden, husbandman 4
5268835 2435997 2435997 defendant Halstok William husbandman 596022 596022 Halstok, William, of Halden, husbandman 0
5271311 2436702 2436702 defendant Totynden William husbandman 596022 596022 Totynden, William, of Halden, husbandman 0
5272843 2437132 2437132 defendant Baker William tailor 596022 596022 Baker, William, of Halden, tailor 1
5277625 2438536 2438536 defendant atte Hope Lawrence yeoman 596022 596022 atte Hope, Lawrence, of Halden, yeoman 0
5277626 2438536 2438536 defendant Mason Richard glover 596022 596022 Mason, Richard, of Halden, glover 1
5277627 2438536 2438536 defendant Laurence Thomas laborer 596022 596022 Laurence, Thomas, of Halden, laborer 2
5277628 2438536 2438536 defendant Sprynget Henry laborer 596022 596022 Sprynget, Henry, of Halden, laborer 3
5277883 2438619 2438619 defendant Minde or Munde William husbandman 596022 596022 Minde or Munde, William, of Halden, husbandman 3

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