names

121 rows where place_id = 591655

✎ 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
3600735 1867886 1867886 defendant Fre Roger   591655 591655 Fre, Roger, of Shorham, ship wright or mariner 0
3605112 1869264 1869264 defendant Forde Richard mariner 591655 591655 Forde, Richard, of Shorham, mariner 0
3608862 1870428 1870428 defendant Lese Robert husbandman 591655 591655 Lese, Robert, of Shorham, husbandman 0
3611940 1871396 1871396 defendant Lese Robert husbandman 591655 591655 Lese, Robert, of Shorham, husbandman 0
3615819 1872588 1872588 defendant Constabyll William husbandman 591655 591655 Constabyll, William, of Shorham, husbandman 0
3646538 1909318 1909318 defendant Lystney Edward husbandman 591655 591655 Lystney, Edward, of Shorham, husbandman 0
3646539 1909318 1909318 defendant Ketyll William husbandman 591655 591655 Ketyll, William, of Shorham, husbandman 1
3649208 1910141 1910141 defendant Hybon John husbandman 591655 591655 Hybon, John, of Shorham, husbandman 0
3649991 1910364 1910364 defendant Wattys William laborer 591655 591655 Wattys, William, of Shorham, laborer 0
3650109 1910403 1910403 defendant Norys John   591655 591655 Norys, John, of Shorham, tallow chandler 0
3650113 1910403 1910403 defendant Yong John miller 591655 591655 Yong, John, of Shorham, miller 4
3652668 1911166 1911166 defendant Aleyn John fuller 591655 591655 Aleyn, John, of Shorham, fuller 0
3671851 1917196 1917196 defendant Alen John clothier 591655 591655 Alen, John, of Shorham, clothier 0
3678713 1919408 1919408 defendant Kyrkby James tailor 591655 591655 Kyrkby, James, of Shorham, tailor 0
3724789 1934038 1934038 defendant Swan Richard, senior husbandman 591655 591655 Swan, Richard, senior, of Shorham, husbandman 0
3724790 1934038 1934038 defendant Swan Richard, junior husbandman 591655 591655 Swan, Richard, junior, of Shorham, husbandman 1
3744283 1940110 1940110 defendant Trewman Patrick merchant 591655 591655 Trewman, Patrick, of Shorham, merchant 1
3744300 1940116 1940116 defendant Trewman Patrick merchant 591655 591655 Trewman, Patrick, of Shorham, merchant 0
3752142 1942595 1942595 defendant Porter Richard husbandman 591655 591655 Porter, Richard, of Shorham, husbandman 0
3752911 1942836 1942836 defendant Browne William yeoman 591655 591655 Browne, William, of Shorham, yeoman 0
3796649 1956830 1956830 defendant Gryg William husbandman 591655 591655 Gryg, William, of Shorham, husbandman 0
3802800 1958774 1958774 plaintiff Polley alias Polhyll Thomas (legal representative) 591655 591655 Polley alias Polhyll, Thomas, of Shorham, executors of 0
3802805 1958775 1958775 plaintiff Polley alias Polhyll Thomas (legal representative) 591655 591655 Polley alias Polhyll, Thomas, of Shorham, executors of 0
3802810 1958776 1958776 plaintiff Polley alias Polhyll Thomas (legal representative) 591655 591655 Polley alias Polhyll, Thomas, of Shorham, executors of 0
3803718 1959077 1959077 defendant Blakeman William husbandman 591655 591655 Blakeman, William, of Shorham, husbandman 1
3843801 1971598 1971598 defendant Romney Thomas butcher 591655 591655 Romney, Thomas, of Shorham, butcher 0
3882086 1984266 1984266 defendant Trewman Patrick husbandman 591655 591655 Trewman, Patrick, of Shorham, husbandman 4
3882092 1984267 1984267 defendant Trewman Patrick husbandman 591655 591655 Trewman, Patrick, of Shorham, husbandman 4
4043098 2039999 2039999 defendant Felder Richard yeoman 591655 591655 Felder, Richard, of Shorham, yeoman 0
4043099 2039999 2039999 defendant Campe Richard husbandman 591655 591655 together with Campe, Richard, of Shorham, husbandman 1
4043389 2040098 2040098 defendant Polhill John yeoman 591655 591655 Polhill, John, of Shorham, yeoman 0
4073215 2050711 2050711 defendant Petley Alan   591655 591655 Petley, Alan, of Shorham, Kent gent 0
4124276 2068974 2068974 defendant Rumpney John yeoman 591655 591655 Rumpney, John, of Shorham, yeoman 0
4147412 2077235 2077235 defendant Rumpney John yeoman 591655 591655 Rumpney, John, of Shorham, yeoman 0
4203769 2096876 2096876 defendant Hyll William yeoman 591655 591655 Hyll, William, of Shorham, yeoman 0
4400847 2164875 2164875 defendant Hibbett William husbandman 591655 591655 Hibbett, William, of Shorham, husbandman 0
4435839 2175957 2175957 defendant Gad Alice   591655 591655 Gad, Alice, of Shorham 0
4446849 2183930 2183930 defendant Safhous John   591655 591655 Safhous, John, of Shorham 0
4450232 2185032 2185032 plaintiff Hamond Andrew   591655 591655 Hamond, Andrew, of Shorham, parson 0
4452832 2185897 2185897 defendant Barbour John   591655 591655 Barbour, John, of Shorham 0
4461107 2188551 2188551 plaintiff Spicer David   591655 591655 Spicer, David, of Shorham 0
4467280 2190444 2190444 defendant Othebourne William   591655 591655 Othebourne, William, of Shorham 0
4467821 2190617 2190617 plaintiff Balman John   591655 591655 Balman, John, of Shorham 0
4467822 2190617 2190617 defendant Bukyngham Robert   591655 591655 Bukyngham, Robert, of Shorham 0
4482653 2195280 2195280 defendant Skeet Richard   591655 591655 Skeet, Richard, of Shorham 0
4515583 2205294 2205294 defendant Porter Peter   591655 591655 Porter, Peter, of Shorham 1
4528046 2209054 2209054 defendant Frere William   591655 591655 Frere, William, of Shorham 0
4528842 2209303 2209303 plaintiff Melton John (legal representative) 591655 591655 Melton, John, of Shorham, parson & clerk, executors of 0
4543457 2213842 2213842 defendant Frye Robert   591655 591655 Frye, Robert, of Shorham 1
4566186 2220986 2220986 defendant Lomerst Stephen   591655 591655 Lomerst, Stephen, of Shorham 0
4575510 2223847 2223847 defendant Hodesdone William   591655 591655 Hodesdone, William, of Shorham 0
4606643 2233187 2233187 defendant Thomas William   591655 591655 Thomas, William, of Shorham 1
4613770 2235323 2235323 defendant atte Gate John   591655 591655 atte Gate, John, of Shorham 0
4629452 2240140 2240140 defendant Couper William   591655 591655 Couper, William, of Shorham 1
4651600 2246498 2246498 defendant Brounswayn Thomas husbandman 591655 591655 Brounswayn, Thomas, of Shorham, husbandman 0
4670743 2256528 2256528 plaintiff Burle alias Borley Walter (legal representative) 591655 591655 Burle alias Borley, Walter, of Shorham, executors of 0
4694771 2263858 2263858 defendant Tymberden Thomas husbandman 591655 591655 Tymberden, Thomas, of Shorham, husbandman 0
4721214 2271962 2271962 defendant Wynkere William husbandman 591655 591655 Wynkere, William, of Shorham, husbandman 0
4721215 2271962 2271962 defendant Skete Richard husbandman 591655 591655 Skete, Richard, of Shorham, husbandman 1
4732351 2275296 2275296 defendant Durkynghole John husbandman 591655 591655 Durkynghole, John, of Shorham, husbandman 0
4732352 2275296 2275296 defendant Reve John laborer 591655 591655 Reve, John, of Shorham, laborer 1
4735214 2276161 2276161 defendant Snellyng Thomas smith 591655 591655 Snellyng, Thomas, of Shorham, smith 0
4737155 2276738 2276738 defendant Feyrweder William shipman 591655 591655 Feyrweder, William, of Shorham, shipman 0
4743980 2278766 2278766 defendant Turlok John laborer 591655 591655 Turlok, John, of Shorham, laborer 0
4767415 2285792 2285792 defendant Snellyng William smith 591655 591655 Snellyng, William, of Shorham, smith 0
4770422 2286719 2286719 defendant Wikherst William farmer 591655 591655 Wikherst, William, of Shorham, farmer 0
4781521 2290231 2290231 defendant Tymberden Robert husbandman 591655 591655 Tymberden, Robert, of Shorham,, husbandman 0
4781522 2290231 2290231 defendant Tymberden Thomas husbandman 591655 591655 Tymberden, Thomas, of Shorham,, husbandman 1
4791797 2293532 2293532 defendant Snellyng William smith 591655 591655 Snellyng, William, of Shorham, smith 0
4791799 2293533 2293533 defendant Snellyng William smith 591655 591655 Snellyng, William, of Shorham, smith 0
4795900 2294867 2294867 defendant Reve William carpenter 591655 591655 Reve, William, of Shorham, carpenter 0
4807376 2298503 2298503 defendant Balsot Thomas husbandman 591655 591655 Balsot, Thomas, of Shorham, husbandman 0
4807379 2298504 2298504 defendant Pemell John husbandman 591655 591655 Pemell, John, of Shorham, husbandman 0
4847482 2310712 2310712 defendant Roos John gent 591655 591655 Roos, John, of Shorham, gent 0
4863814 2315655 2315655 defendant Depedene John husbandman 591655 591655 Depedene, John, of Shorham, husbandman 1
4884258 2321984 2321984 defendant Porter John tiler 591655 591655 Porter, John, of Shorham, tiler 0
4927223 2334950 2334950 defendant atte Lese Thomas husbandman 591655 591655 atte Lese, Thomas, of Shorham, husbandman 0
5047962 2371010 2371010 defendant Sepham John gent 591655 591655 Sepham, John, of Shorham, gent 0
5059227 2374324 2374324 defendant Hubard Nicholas husbandman 591655 591655 Hubard, Nicholas, of Shorham, husbandman 0
5059229 2374325 2374325 defendant Hubard Nicholas husbandman 591655 591655 Hubard, Nicholas, of Shorham, husbandman 0
5073135 2378452 2378452 defendant Clerk John, senior husbandman 591655 591655 Clerk, John, senior, of Shorham, husbandman 0
5073136 2378452 2378452 defendant Holewey John laborer 591655 591655 together with Holewey, John, of Shorham, laborer 1
5078321 2380007 2380007 defendant Shepham John husbandman 591655 591655 Shepham, John, of Shorham, husbandman 0
5114735 2390722 2390722 defendant Broun William husbandman 591655 591655 Broun, William, of Shorham, husbandman 7
5138591 2397783 2397783 defendant Sepham John gent 591655 591655 Sepham, John, of Shorham, gent 0
5139204 2397956 2397956 defendant Kolgate Robert husbandman 591655 591655 Kolgate, Robert, of Shorham, husbandman 1
5160079 2404047 2404047 defendant Kelgate Robert husbandman 591655 591655 Kelgate, Robert, of Shorham, husbandman 1
5174979 2408376 2408376 defendant Colgate Robert husbandman 591655 591655 Colgate, Robert, of Shorham, husbandman 1
5195248 2414357 2414357 defendant Sepham John gent 591655 591655 Sepham, John, of Shorham, gent 0
5209184 2418415 2418415 defendant Sepham John gent 591655 591655 Sepham, John, of Shorham, gent 0
5221160 2421891 2421891 defendant Broun John husbandman 591655 591655 Broun, John, of Shorham, husbandman 0
5225137 2423024 2423024 defendant Sepham John gent 591655 591655 Sepham, John, of Shorham, gent 0
5225139 2423024 2423024 defendant Browene William husbandman 591655 591655 Browene, William, of Shorham, husbandman 2
5243038 2428167 2428167 defendant Reve John butcher 591655 591655 Reve, John, of Shorham, butcher 0
5243039 2428167 2428167 defendant Tymberden Alan husbandman 591655 591655 Tymberden, Alan, of Shorham, husbandman 1
5247092 2429307 2429307 defendant Hemynge John laborer 591655 591655 Hemynge, John, of Shorham, laborer 0
5263897 2434466 2434466 defendant Bothe John, senior husbandman 591655 591655 Bothe, John, senior, of Shorham, husbandman 0
5274807 2437710 2437710 plaintiff Roos John esq 591655 591655 Roos, John, of Shorham, esq, on his own account 0
5331249 2454420 2454420 defendant A Bothe John husbandman 591655 591655 A Bothe, John, of Shorham, husbandman 0
5351684 2460626 2460626 defendant Turnour William gent 591655 591655 Turnour, William, of Shorham, gent 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);