names

100 rows where place_id = 589522

✎ 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
3597859 1866950 1866950 defendant Neweton Richard yeoman 589522 589522 Neweton, Richard, of Clyff, yeoman 0
3607712 1870066 1870066 defendant Glover John yeoman 589522 589522 Glover, John, of Clyff, yeoman 1
3607714 1870066 1870066 defendant Pounderson Thomas husbandman 589522 589522 Pounderson, Thomas, of Clyff, husbandman 3
3620729 1874059 1874059 defendant Tocotes William gent 589522 589522 Tocotes, William, of Clyff, gent 0
3640686 1907529 1907529 defendant Rolffe John husbandman 589522 589522 Rolffe, John, of Clyff, husbandman 0
3642455 1908084 1908084 defendant Peryott Richard yeoman 589522 589522 Peryott, Richard, of Clyff, yeoman 0
3663229 1914423 1914423 defendant Hawet Thomas yeoman 589522 589522 Hawet, Thomas, of Clyff, yeoman 0
3680179 1919873 1919873 defendant Langford John gent 589522 589522 Langford, John, of Clyff, gent 0
3692712 1923909 1923909 defendant Bocher William quarrier 589522 589522 Bocher, William, of Clyff, quarrier 0
3693430 1924160 1924160 defendant Pyrkyn William husbandman 589522 589522 Pyrkyn, William, of Clyff, husbandman 4
3695438 1924795 1924795 defendant Percy Josselin esq 589522 589522 Percy, Josselin, of Clyff, esq 0
3723699 1933688 1933688 defendant Percyvall Thomas miller 589522 589522 Percyvall, Thomas, of Clyff, miller 1
3723701 1933688 1933688 defendant Robynson John miller 589522 589522 Robynson, John, of Clyff, miller 3
3725754 1934343 1934343 defendant Mugge Thomas husbandman 589522 589522 Mugge, Thomas, of Clyff, husbandman 0
3729866 1935597 1935597 defendant Nelson John yeoman 589522 589522 Nelson, John, of Clyff, yeoman 4
3741225 1939113 1939113 defendant Sompner Elizabeth widow 589522 589522 Sompner, Elizabeth, of Clyff, widow 0
3741685 1939266 1939266 defendant Mugge Thomas husbandman 589522 589522 Mugge, Thomas, of Clyff, husbandman 0
3753763 1943119 1943119 defendant Ravynsha Giles gent 589522 589522 Ravynsha, Giles, of Clyff, gent 0
3761736 1945681 1945681 defendant Horne John husbandman 589522 589522 Horne, John, of Clyff Peper, husbandman 0
3774611 1949786 1949786 defendant Maydon Thomas husbandman 589522 589522 Maydon, Thomas, of Clyff, husbandman 0
3776289 1950330 1950330 defendant Foster John smith 589522 589522 Foster, John, of Clyff, smith 3
3818326 1963637 1963637 defendant Lambe William husbandman 589522 589522 Lambe, William, of Clyff, husbandman 0
3823264 1965193 1965193 defendant Barowe James yeoman 589522 589522 Barowe, James, of Clyff, yeoman 1
3834057 1968590 1968590 defendant Dovell Barnard yeoman 589522 589522 Dovell, Barnard, of Clyff, yeoman 1
3834060 1968591 1968591 defendant Dovell Bernard yeoman 589522 589522 Dovell, Bernard, of Clyff, yeoman 1
3842347 1971143 1971143 defendant Watson Richard butcher 589522 589522 Watson, Richard, of Clyff, butcher 3
3862313 1977582 1977582 defendant Julle John husbandman 589522 589522 Julle, John, of Clyff juxta Dover, husbandman 1
3863631 1978023 1978023 defendant Periott Thomas yeoman 589522 589522 Periott, Thomas, of Clyff, yeoman 0
3866719 1979103 1979103 plaintiff Potett John   589522 589522 Potett, John, of Clyff 1
3876906 1982516 1982516 defendant Brown Edward husbandman 589522 589522 Brown, Edward, of Clyff, husbandman 2
3903528 1991407 1991407 defendant Goldok John husbandman 589522 589522 Goldok, John, of Clyff, husbandman 0
3923677 1998231 1998231 defendant Frencheham George husbandman 589522 589522 Frencheham, George, of Clyff, husbandman 2
4046213 2041087 2041087 defendant Bennett William husbandman 589522 589522 Bennett, William, of Clyff, husbandman 0
4046216 2041088 2041088 defendant Bennett William husbandman 589522 589522 Bennett, William, of Clyff, husbandman 0
4093670 2058059 2058059 defendant Newton Henry yeoman 589522 589522 Newton, Henry, of Clyff, yeoman 0
4168772 2084569 2084569 defendant Constable Marmaduke esq 589522 589522 Constable, Marmaduke, of Clyff, esq 0
4375708 2156371 2156371 defendant Puncheon William miller 589522 589522 Puncheon, William, of Clyff, miller 0
4448268 2184377 2184377 defendant Pulter John or Philip   589522 589522 Pulter, John or Philip, of Clyff 1
4457963 2187511 2187511 defendant Josep Michael   589522 589522 Josep, Michael, of Clyff, parchment maker 0
4457965 2187512 2187512 defendant Josep Michael   589522 589522 Josep, Michael, of Clyff, parchment maker 0
4511505 2204043 2204043 defendant Rachebon William   589522 589522 Rachebon, William, of Clyff 1
4556374 2217931 2217931 defendant Pulter William   589522 589522 Pulter, William, of Clyff 10
4589221 2228010 2228010 defendant Codhall Robert   589522 589522 Codhall, Robert, of Clyff 5
4676772 2258358 2258358 defendant Yole Thomas yeoman 589522 589522 Yole, Thomas, of Clyff, yeoman 0
4688622 2262005 2262005 defendant Clyff William gent 589522 589522 Clyff, William, of Clyff, gent 0
4714232 2269782 2269782 defendant Clyff William gent 589522 589522 Clyff, William, of Clyff, gent 0
4736709 2276609 2276609 defendant Clyff William gent 589522 589522 Clyff, William, of Clyff, gent 0
4738450 2277115 2277115 defendant Dawe John yeoman 589522 589522 Dawe, John, of Clyff, yeoman 2
4883042 2321620 2321620 plaintiff Bokull John   589522 589522 Bokull, John, of Clyff 0
4883043 2321620 2321620 defendant Robynson Henry laborer 589522 589522 Robynson, Henry, of Clyff, laborer 0
4883047 2321620 2321620 defendant Curtas John husbandman 589522 589522 Curtas, John, of Clyff, or of Hemmyngburgh, husbandman 4
4885963 2322474 2322474 defendant Jakson William husbandman 589522 589522 Jakson, William, of Clyff, husbandman 3
4888722 2323263 2323263 plaintiff Bocull John   589522 589522 Bocull, John, of Clyff 0
4888723 2323263 2323263 defendant Robynson Henry laborer 589522 589522 Robynson, Henry, of Clyff, laborer 0
4888726 2323263 2323263 defendant Curtas John husbandman 589522 589522 Curtas, John, of Clyff, or of Hemmyngburgh, husbandman 3
4905545 2328331 2328331 defendant Yardeley John   589522 589522 Yardeley, John, of Clyff, servant 0
4943523 2339942 2339942 defendant Gaysayr or Gayfayr John, junior miller 589522 589522 Gaysayr or Gayfayr, John, junior, of Clyff, miller 2
4944075 2340115 2340115 defendant Manston John esq 589522 589522 Manston, John, of Clyff, esq 1
4966344 2346868 2346868 defendant Gorecote Peter husbandman 589522 589522 Gorecote, Peter, of Clyff, husbandman 0
4983837 2352092 2352092 defendant Scroty Henry husbandman 589522 589522 Scroty, Henry, of Clyff, husbandman 5
4983844 2352093 2352093 defendant Strocy Henry husbandman 589522 589522 Strocy, Henry, of Clyff, husbandman 4
4989826 2353873 2353873 defendant Wardrop Robert   589522 589522 Wardrop, Robert, of Clyff 4
5003062 2357799 2357799 defendant Wardrop Robert   589522 589522 Wardrop, Robert, of Clyff 4
5047829 2370967 2370967 defendant Morton Thomas yeoman 589522 589522 Morton, Thomas, of Clyff, yeoman 0
5047831 2370967 2370967 defendant Kyppyng Nicholas husbandman 589522 589522 Kyppyng, Nicholas, of Clyff, husbandman 2
5055424 2373208 2373208 defendant Gayteforth Richard husbandman 589522 589522 Gayteforth, Richard, of Clyff, husbandman 1
5055425 2373208 2373208 defendant Baxter William husbandman 589522 589522 Baxter, William, of Clyff, husbandman 2
5055426 2373208 2373208 defendant Thomasson John husbandman 589522 589522 Thomasson, John, of Clyff, husbandman 3
5118415 2391822 2391822 defendant Gateford Richard husbandman 589522 589522 Gateford, Richard, of Clyff, husbandman 3
5130893 2395518 2395518 defendant Rolf John husbandman 589522 589522 Rolf, John, of Clyff, husbandman 0
5145738 2399898 2399898 defendant Thomasson John husbandman 589522 589522 Thomasson, John, of Clyff, husbandman 1
5159347 2403849 2403849 defendant Catter Richard husbandman 589522 589522 Catter, Richard, of Clyff, husbandman 3
5159567 2403915 2403915 defendant Jakson William husbandman 589522 589522 Jakson, William, of Clyff, husbandman 0
5166078 2405821 2405821 defendant Thomasson John husbandman 589522 589522 Thomasson, John, of Clyff, husbandman 1
5180872 2410148 2410148 defendant Thomasson John husbandman 589522 589522 Thomasson, John, of Clyff, husbandman 1
5195258 2414359 2414359 defendant Catter Richard husbandman 589522 589522 Catter, Richard, of Clyff, husbandman 3
5195388 2414402 2414402 defendant Jakson William husbandman 589522 589522 Jakson, William, of Clyff, husbandman 0
5209189 2418417 2418417 defendant Catter Richard husbandman 589522 589522 Catter, Richard, of Clyff, husbandman 1
5225123 2423018 2423018 defendant Catter Richard husbandman 589522 589522 Catter, Richard, of Clyff, husbandman 0
5263720 2434402 2434402 defendant Broun John waterman 589522 589522 Broun, John, of Clyff, waterman 0
5320128 2451108 2451108 defendant Wechyrley John husbandman 589522 589522 Wechyrley, John, of Clyff, husbandman, son of Wecherley, Roger, of Clyff, husbandman 0
5348959 2459808 2459808 defendant Godfrey Richard yeoman 589522 589522 Godfrey, Richard, of Clyff, yeoman 1
5512510 2508773 2508773 defendant Tylley William chaplain 589522 589522 Tylley, William, of Clyff, chaplain 1
5512511 2508773 2508773 defendant Lane Richard yeoman 589522 589522 Lane, Richard, of Clyff, yeoman 2
5512513 2508774 2508774 defendant Tylley William chaplain 589522 589522 Tylley, William, of Clyff, chaplain 0
5512514 2508774 2508774 defendant Lane Richard yeoman 589522 589522 Lane, Richard, of Clyff, yeoman 1
5516629 2510029 2510029 defendant Chapman John butcher 589522 589522 Chapman, John, of Clyff, butcher 0
5527883 2513288 2513288 defendant Marten John laborer 589522 589522 Marten, John, of Clyff, laborer 0
5527887 2513290 2513290 defendant Tocotes William gent 589522 589522 Tocotes, William, of Clyff, gent 0
5527891 2513291 2513291 defendant Tocotes William gent 589522 589522 Tocotes, William, of Clyff, gent 0
5528200 2513383 2513383 defendant Rolf John husbandman 589522 589522 Rolf, John, of Clyff, husbandman 3
5529226 2513651 2513651 defendant Sherd John yeoman 589522 589522 Sherd, John, of Clyff, yeoman 0
5529228 2513652 2513652 defendant Sherde John yeoman 589522 589522 Sherde, John, of Clyff, yeoman 0
5529230 2513653 2513653 defendant Sherde John yeoman 589522 589522 Sherde, John, of Clyff, yeoman 0
5559034 2522602 2522602 defendant Elys Thomas husbandman 589522 589522 Elys, Thomas, of Clyff, husbandman 1
5559036 2522602 2522602 defendant Peryot William   589522 589522 Peryot, William, of Clyff, minstrel 3
5572486 2526497 2526497 defendant Sumner Alice widow 589522 589522 Sumner, Alice, of Clyff, widow 0
5572488 2526497 2526497 defendant Kyng William husbandman 589522 589522 Kyng, William, of Clyff, husbandman 2
5609631 2537905 2537905 defendant Mugge William husbandman 589522 589522 Mugge, William, of Clyff, husbandman 3
5633725 2554546 2554546 defendant Clyf William   589522 589522 Clyf, William, of Clyff 0

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