names

133 rows where place_id = 587412

✎ 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
3591332 1864916 1864916 defendant Payne Robert yeoman 587412 587412 Payne, Robert, of Chilham, yeoman 0
3635585 1905932 1905932 plaintiff Peele Robert clerk 587412 587412 Peele, Robert, of Chilham, clerk 0
3635586 1905932 1905932 defendant Fox William husbandman 587412 587412 Fox, William, of Chilham, husbandman 0
3635588 1905933 1905933 plaintiff Peele Robert clerk 587412 587412 Peele, Robert, of Chilham, clerk 0
3637926 1906678 1906678 defendant Croft William husbandman 587412 587412 Croft, William, of Chilham, husbandman 0
3664725 1914918 1914918 defendant Prowde James yeoman 587412 587412 Prowde, James, of Chilham, yeoman 2
3664726 1914918 1914918 defendant Copyn John yeoman 587412 587412 Copyn, John, of Chilham, yeoman 3
3666692 1915530 1915530 defendant Fox William, senior husbandman 587412 587412 Fox, William, senior, of Chilham, husbandman 0
3669759 1916488 1916488 defendant Markys Thomas tiler 587412 587412 Markys, Thomas, of Chilham, tiler 0
3669760 1916488 1916488 defendant Markys Robert husbandman 587412 587412 Markys, Robert, of Chilham, husbandman 1
3669761 1916488 1916488 defendant Hall Nicholas husbandman 587412 587412 Hall, Nicholas, of Chilham, husbandman 2
3669762 1916488 1916488 defendant Copyn John yeoman 587412 587412 Copyn, John, of Chilham, yeoman 3
3677012 1918848 1918848 defendant Athoke Philip weaver 587412 587412 Athoke, Philip, of Chilham, weaver 1
3686104 1921814 1921814 defendant Marke Thomas tiler 587412 587412 Marke, Thomas, of Chilham, tiler 0
3686105 1921814 1921814 defendant Marke Robert husbandman 587412 587412 Marke, Robert, of Chilham, husbandman 1
3686106 1921814 1921814 defendant Hall Nicholas husbandman 587412 587412 Hall, Nicholas, of Chilham, husbandman 2
3686107 1921814 1921814 defendant Chopyn John yeoman 587412 587412 Chopyn, John, of CHilham, yeoman 3
3728957 1935303 1935303 defendant Hardeman Moise yeoman 587412 587412 Hardeman, Moise, of Chilham, yeoman 2
3730203 1935672 1935672 defendant Hall Nicholas husbandman 587412 587412 Hall, Nicholas, of Chilham, husbandman 0
3730206 1935673 1935673 defendant Mark Robert husbandman 587412 587412 Mark, Robert, of Chilham, husbandman 0
3747266 1941065 1941065 defendant Amysse William husbandman 587412 587412 Amysse, William, of Chilham, husbandman 0
3757985 1944480 1944480 defendant Amyas William gent 587412 587412 Amyas, William, of Chilham, gent 0
3774151 1949628 1949628 defendant Pele Robert clerk 587412 587412 Pele, Robert, of Chilham, clerk 0
3778381 1950952 1950952 defendant Petytt William gent 587412 587412 Petytt, William, of Chilham, gent 2
3941190 2004057 2004057 plaintiff Thwaytes William gent 587412 587412 Thwaytes, William, of Chilham, gent 0
3999313 2024514 2024514 defendant Mylles Richard tailor 587412 587412 Mylles, Richard, of Chilham, tailor 1
4014846 2030024 2030024 defendant Amys Christopher yeoman 587412 587412 Amys, Christopher, of Chilham, yeoman 0
4014848 2030025 2030025 defendant Annys Christopher yeoman 587412 587412 Annys, Christopher, of Chilham, yeoman 0
4098775 2059891 2059891 defendant Cobbe Thomas gent 587412 587412 Cobbe, Thomas, of Chilham, gent 1
4098781 2059893 2059893 defendant Parker John yeoman 587412 587412 Parker, John, of Chilham, yeoman 1
4098784 2059894 2059894 defendant Parker John gent 587412 587412 Parker, John, of Chilham, gent 1
4143363 2075842 2075842 defendant Stransham John gent 587412 587412 Stransham, John, of Chilham, gent 0
4151339 2078590 2078590 defendant Stransham John gent 587412 587412 Stransham, John, of Chilham, gent 0
4228863 2105573 2105573 defendant Nicholson William carpenter 587412 587412 Nicholson, William, of Chilham, carpenter 1
4238529 2109089 2109089 defendant Baker John   587412 587412 Baker, John, of Chilham, mason 0
4245960 2111629 2111629 defendant Nicholson William carpenter 587412 587412 Nicholson, William, of Chilham, carpenter 1
4326185 2139127 2139127 defendant Shypwash Richard yeoman 587412 587412 Shypwash, Richard, of Chilham, yeoman 0
4359065 2150404 2150404 defendant Chadborne John yeoman 587412 587412 Chadborne, John, of Chilham, yeoman 0
4361787 2151374 2151374 defendant Hills William butcher 587412 587412 Hills, William, of Chilham, butcher 0
4371699 2154936 2154936 defendant Bungey Jonah gent 587412 587412 Bungey, Jonah, of Chilham, gent 0
4387707 2160525 2160525 defendant Bungay Jonah gent 587412 587412 Bungay, Jonah, of Chilham, gent 0
4403877 2165868 2165868 defendant Shipwashe Richard yeoman 587412 587412 Shipwashe, Richard, of Chilham, yeoman 0
4475204 2192920 2192920 plaintiff Englyssh William (legal representative) 587412 587412 Englyssh, William, of Chilham, executors of 0
4499867 2200591 2200591 defendant Faukener William   587412 587412 Faukener, William, of Chilham 1
4509215 2203360 2203360 defendant Hunt Richard   587412 587412 Hunt, Richard, of Chilham 0
4523136 2207567 2207567 defendant atte Pette William   587412 587412 atte Pette, William, of Chilham 0
4533060 2210606 2210606 plaintiff Reche John farmer of the manor 587412 587412 Reche, John, of Chilham, farmer of the manor 0
4545273 2214444 2214444 defendant Marchall Robert   587412 587412 Marchall, Robert, of Chilham 0
4598005 2230633 2230633 defendant Somerton Nicholas   587412 587412 Somerton, Nicholas, of Chilham 0
4614578 2235565 2235565 defendant Somerton Nicholas   587412 587412 Somerton, Nicholas, of Chilham 0
4629394 2240123 2240123 defendant Syre John   587412 587412 Syre, John, of Chilham 0
4657857 2248344 2248344 defendant Sandre John husbandman 587412 587412 Sandre, John, of Chilham, husbandman 1
4699753 2265367 2265367 defendant atte Sole Robert laborer 587412 587412 atte Sole, Robert, of Chilham, laborer 0
4700566 2265587 2265587 defendant Adam Nicholas laborer 587412 587412 Adam, Nicholas, of Chilham, laborer 1
4707888 2267837 2267837 defendant Ensynge William esq 587412 587412 Ensynge, William, of Chilham, esq 0
4728919 2274283 2274283 defendant Adam Nicholas laborer 587412 587412 Adam, Nicholas, of Chilham, laborer 0
4799057 2295880 2295880 defendant Chevaler William   587412 587412 Chevaler, William, of Chilham 0
4842672 2309244 2309244 defendant Alcok Robert carter 587412 587412 Alcok, Robert, of Chilham, laborer, alias of Lincoln, carter 0
4850876 2311720 2311720 defendant Goldhecche Thomas   587412 587412 Goldhecche, Thomas, of Chilham, wheel wright 0
4853561 2312529 2312529 defendant Goldhacche Thomas   587412 587412 Goldhacche, Thomas, of Chilham, wheel wright 0
4856496 2313411 2313411 defendant Goldhacche Thomas wheeler 587412 587412 Goldhacche, Thomas, of Chilham, wheeler 1
4897047 2325730 2325730 defendant O Henry laborer 587412 587412 O, Henry, of Chilham, laborer 0
4907042 2328779 2328779 defendant Wetwode John clerk 587412 587412 Wetwode, John, of Chilham, clerk 0
4925265 2334331 2334331 defendant Ode Henry husbandman 587412 587412 Ode, Henry, of Chilham, husbandman 0
4949961 2341956 2341956 plaintiff Notte Hamon   587412 587412 Notte, Hamon, of Chilham 0
4961174 2345306 2345306 plaintiff Beverle Thomas, senior (legal representative) 587412 587412 Beverle, Thomas, senior, of Chilham, executors of 0
4961178 2345307 2345307 plaintiff Beverle Thomas, senior (legal representative) 587412 587412 Beverle, Thomas, senior, of Chilham, executors of 0
4976638 2349971 2349971 defendant Notte Hamo   587412 587412 Notte, Hamo, of Chilham, mason 0
4976639 2349971 2349971 defendant Browele John yeoman 587412 587412 Browele, John, of Chilham, yeoman 1
5064220 2375841 2375841 defendant Ideley John esq 587412 587412 Ideley, John, of Chilham, esq 0
5069114 2377254 2377254 defendant Ideley John esq 587412 587412 Ideley, John, of Chilham, esq 1
5074927 2379007 2379007 defendant Idley John esq 587412 587412 Idley, John, of Chilham, esq 0
5080823 2380755 2380755 defendant Goldhecche Thomas wheeler 587412 587412 Goldhecche, Thomas, of Chilham, wheeler 2
5100157 2386487 2386487 defendant Idley John esq 587412 587412 Idley, John, of Chilham, esq 0
5104980 2387897 2387897 defendant Crouche William laborer 587412 587412 Crouche, William, of Chilham, laborer 0
5112479 2390036 2390036 defendant Croche William husbandman 587412 587412 Croche, William, of Chilham, husbandman 2
5147863 2400518 2400518 defendant Goldhache Thomas   587412 587412 Goldhache, Thomas, of Chilham, wheel wright 0
5167376 2406194 2406194 defendant Goldhache Thomas   587412 587412 Goldhache, Thomas, of Chilham, wheel wright 0
5214859 2420065 2420065 defendant Browenyng Richard husbandman 587412 587412 Browenyng, Richard, of Chilham, husbandman 0
5215670 2420307 2420307 defendant Goldehacche Thomas wheeler 587412 587412 Goldehacche, Thomas, of Chilham, wheeler 3
5243776 2428371 2428371 defendant Idley John gent 587412 587412 Idley, John, of Chilham, gent 1
5246651 2429180 2429180 defendant Beghynden Adam smith 587412 587412 Beghynden, Adam, of Chilham, smith 1
5285018 2440640 2440640 defendant Bernys Robert tiler 587412 587412 Bernys, Robert, of Chilham, tiler 1
5303573 2446065 2446065 defendant (illegible) John gent 587412 587412 _, John, of Chilham, gent 0
5309310 2447825 2447825 defendant Adamson Robert collier 587412 587412 Adamson, Robert, of Chilham, collier 0
5337980 2456443 2456443 defendant Faunt Thomas yeoman 587412 587412 Faunt, Thomas, of Chilham, yeoman 1
5346891 2459185 2459185 defendant Hardyman John husbandman 587412 587412 Hardyman, John, of Chilham, husbandman 0
5346892 2459185 2459185 defendant Barnys Robert husbandman 587412 587412 Barnys, Robert, of Chilham, husbandman 1
5346893 2459185 2459185 defendant Burgeys William laborer 587412 587412 Burgeys, William, of Chilham, laborer 2
5346894 2459185 2459185 defendant Goldhacche Robert wheeler 587412 587412 Goldhacche, Robert, of Chilham, wheeler 3
5357150 2462300 2462300 defendant Webbe John sawyer 587412 587412 Webbe, John, of Chilham, sawyer 2
5372600 2467030 2467030 defendant Philpot Robert husbandman 587412 587412 Philpot, Robert, of Chilham, husbandman 0
5374995 2467772 2467772 defendant Gedyn Thomas   587412 587412 Gedyn, Thomas, of Chilham 0
5374996 2467772 2467772 defendant Elys Robert husbandman 587412 587412 Elys, Robert, of Chilham, husbandman 1
5377565 2468566 2468566 defendant Philpot Robert husbandman 587412 587412 Philpot, Robert, of Chilham, husbandman 0
5378102 2468729 2468729 defendant Thorold Katherine widow 587412 587412 Thorold, Katherine, of Chilham, widow 0
5378103 2468729 2468729 defendant Fyssher John laborer 587412 587412 Fyssher, John, of Chilham, laborer 1
5391511 2472645 2472645 defendant Segger Robert brother 587412 587412 Segger, Robert, of Chilham, brother 0
5391512 2472645 2472645 defendant Atkyn John butcher 587412 587412 Atkyn, John, of Chilham, butcher 1
5401016 2475353 2475353 defendant Herd John cordwainer 587412 587412 Herd, John, of Chilham, cordwainer 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);