names

120 rows where place_id = 600272

✎ 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
3640388 1907425 1907425 defendant Orwell John yeoman 600272 600272 Orwell, John, of Newport, Isle of Wight, yeoman 2
3648271 1909859 1909859 defendant Tracy David smith 600272 600272 Tracy, David, of Newport, Isle of Wight, smith 0
3671419 1917039 1917039 defendant Porter William mercer 600272 600272 Porter, William, of Newport, Isle of Wight, mercer 0
3687472 1922259 1922259 defendant Sygons Thomas merchant 600272 600272 Sygons, Thomas, of Newport, Isle of Wight, merchant 1
3689722 1922942 1922942 defendant Poynter John weaver 600272 600272 Poynter, John, of Newport, Isle of Wight, weaver 0
3721790 1933086 1933086 defendant Pope John   600272 600272 Pope, John, of Newport, Isle of Wight, tallow chandler 0
3725117 1934144 1934144 defendant Jobbe Robert butcher 600272 600272 Jobbe, Robert, of Newport, Isle of Wight, butcher 0
3725119 1934145 1934145 defendant Porter William mercer 600272 600272 Porter, William, of Newport, Isle of Wight, mercer 0
3734876 1937148 1937148 defendant Puddesey Richard chapman 600272 600272 Puddesey, Richard, of Newport, Isle of Wight, chapman 1
3766914 1947317 1947317 defendant Morvell Robert yeoman 600272 600272 Morvell, Robert, of Newport, Isle of Wight, yeoman 3
3768491 1947796 1947796 defendant Compton John yeoman 600272 600272 Compton, John, of Newport, Isle of Wight, yeoman 0
3779659 1951370 1951370 defendant Pocoke John yeoman 600272 600272 Pocoke, John, of Newport, Isle of Wight, yeoman 0
3786501 1953570 1953570 defendant Pemberton Gilbert yeoman 600272 600272 Pemberton, Gilbert, of Newport, Isle of Wight, yeoman 0
3786599 1953604 1953604 defendant Bremshett Heorge gent 600272 600272 Bremshett, Heorge, of Newport, Isle of Wight, gent 0
3799543 1957778 1957778 defendant Richardson Dirick beer brewer 600272 600272 Richardson, Dirick, of Newport, Isle of Wight, beer brewer 0
3802791 1958769 1958769 defendant Pemberton Gilbert yeoman 600272 600272 Pemberton, Gilbert, of Newport, Isle of Wight, yeoman 0
3808226 1960451 1960451 defendant Orwell John yeoman 600272 600272 Orwell, John, of Newport, Isle of Wight, yeoman 3
3808390 1960499 1960499 defendant Banaster Richard mercer 600272 600272 Banaster, Richard, of Newport, Isle of Wight, mercer 0
3814829 1962550 1962550 defendant Pemberton Gilbert merchant 600272 600272 Pemberton, Gilbert, of Newport, Isle of Wight, merchant 0
3845779 1972228 1972228 defendant Pocok John yeoman 600272 600272 Pocok, John, of Newport, Isle of Wight, yeoman 0
3859719 1976751 1976751 defendant Wykham John   600272 600272 Wykham, John, of Newport, Isle of Wight, brick and tilemaker 0
3860211 1976910 1976910 defendant Pemerton Gilbert yeoman 600272 600272 Pemerton, Gilbert, of Newport, Isle of Wight, yeoman 1
3860218 1976911 1976911 defendant Pemerton Gilbert yeoman 600272 600272 Pemerton, Gilbert, of Newport, Isle of Wight, yeoman 1
3872723 1981092 1981092 defendant Lye Edward gent 600272 600272 Lye, Edward, of Newport, Isle of Wight, gent 0
3874188 1981590 1981590 defendant Hawles John gent 600272 600272 Hawles, John, of Newport, Isle of Wight, gent 0
3875443 1982032 1982032 plaintiff Flemmyng John (legal representative) 600272 600272 Flemmyng, John, of Newport, Isle of Wight, executors of 0
3875445 1982032 1982032 defendant Barlowe John yeoman 600272 600272 Barlowe, John, of Newport, Isle of Wight, yeoman 0
3888634 1986454 1986454 defendant Manyan Rowland tailor 600272 600272 Manyan, Rowland, of Newport, Isle of Wight, tailor 0
3948731 2006623 2006623 defendant Mark Richard merchant 600272 600272 Mark, Richard, of Newport, Isle of Wight, merchant 2
3954799 2008747 2008747 defendant Mark or Markes Richard chapman 600272 600272 Mark or Markes, Richard, of Newport, Isle of Wight, chapman 1
4065466 2047940 2047940 plaintiff Hayes John tailor 600272 600272 Hayes, John, of Newport, Isle of Wight, tailor 0
4115269 2065752 2065752 defendant Browne Richard butcher 600272 600272 Browne, Richard, of Newport, Isle of Wight, butcher 0
4168630 2084514 2084514 defendant Waterton Francis merchant 600272 600272 Waterton, Francis, of Newport, Isle of Wight, merchant 0
4191377 2092552 2092552 defendant Rydge John shoemaker 600272 600272 Rydge, John, of Newport, Isle of Wight, shoemaker 0
4216716 2101339 2101339 defendant Skoper Henry merchant 600272 600272 Skoper, Henry, of Newport, Isle of Wight, merchant 0
4217948 2101769 2101769 defendant Gaynesford Robert gent 600272 600272 Gaynesford, Robert, of Newport, Isle of Wight, or of Dybden, gent 0
4223065 2103557 2103557 defendant Serle Nicholas fuller 600272 600272 Serle, Nicholas, of Newport, Isle of Wight, fuller 0
4231950 2106674 2106674 defendant Fludd William cooper 600272 600272 Fludd, William, of Newport, Isle of Wight, cooper 1
4232887 2107010 2107010 defendant Skoper Henry fishmonger 600272 600272 Skoper, Henry, of Newport, Isle of Wight, fishmonger 0
4236039 2108176 2108176 defendant Gaynsford Robert vintner 600272 600272 Gaynsford, Robert, of Newport, Isle of Wight, vintner 0
4236901 2108484 2108484 defendant Orwell Benjamin merchant 600272 600272 Orwell, Benjamin, of Newport, Isle of Wight, merchant 1
4263838 2117565 2117565 defendant Fludd William cooper 600272 600272 Fludd, William, of Newport, Isle of Wight, cooper 1
4263839 2117565 2117565 defendant Orwell Benjamin vintner 600272 600272 Orwell, Benjamin, of Newport, Isle of Wight, vintner 2
4264925 2117905 2117905 defendant Skeper Henry fishmonger 600272 600272 Skeper, Henry, of Newport, Isle of Wight, fishmonger 0
4264926 2117905 2117905 defendant Bragg John butcher 600272 600272 Bragg, John, of Newport, Isle of Wight, butcher 1
4266451 2118427 2118427 defendant Skeper Henry merchant 600272 600272 Skeper, Henry, of Newport, Isle of Wight, merchant 0
4268463 2119055 2119055 defendant Gaynsford Robert vintner 600272 600272 Gaynsford, Robert, of Newport, Isle of Wight, vintner 0
4299147 2129793 2129793 defendant Newnton Richard merchant 600272 600272 Newnton, Richard, of Newport, Isle of Wight, merchant 0
4316168 2135767 2135767 defendant Coffyn John vintner 600272 600272 Coffyn, John, of Newport, Isle of Wight, vintner 0
4319187 2136825 2136825 defendant Sooper Henry fishmonger 600272 600272 Sooper, Henry, of Newport, Isle of Wight, fishmonger 0
4320646 2137311 2137311 defendant Trehardye Peter haberdasher 600272 600272 (Trehardye, Peter, of Newport, Isle of Wight, haberdasher 3
4358854 2150330 2150330 defendant Lavandelowe Andrew baker 600272 600272 Lavandelowe, Andrew, of Newport, Isle of Wight, baker 0
4370968 2154674 2154674 defendant Newman or Newname Richard merchant 600272 600272 Newman or Newname, Richard, of Newport, Isle of Wight, merchant 0
4374446 2155929 2155929 defendant Barnes Richard mercer 600272 600272 Barnes, Richard, of Newport, Isle of Wight, mercer 0
4402995 2165588 2165588 defendant Barnes Richard mercer 600272 600272 Barnes, Richard, of Newport, Isle of Wight, mercer 0
4545289 2214449 2214449 defendant Boteman Philip   600272 600272 Boteman, Philip, of Newport, Isle of Wight 0
4613559 2235257 2235257 defendant Shepherd Thomas   600272 600272 Shepherd, Thomas, of Newport, Isle of Wight 0
4614528 2235550 2235550 defendant Cok John weaver 600272 600272 Cok, John, of Newport, Isle of Wight, weaver 0
4618676 2236851 2236851 defendant Wylyer John   600272 600272 Wylyer, John, of Newport, Isle of Wight 0
4707184 2267625 2267625 defendant Epeswych John dyer 600272 600272 Epeswych, John, of Newport, Isle of Wight, dyer 0
4708537 2268038 2268038 defendant Diere John dyer 600272 600272 Diere, John, of Newport, Isle of Wight, dyer 1
4715142 2270062 2270062 defendant Cophutt John husbandman 600272 600272 Cophutt, John, of Newport, Isle of Wight, husbandman 0
4733475 2275645 2275645 plaintiff Rede Thomas   600272 600272 Rede, Thomas, of Newport, Isle of Wight 0
4733476 2275645 2275645 defendant Short alias Godbeourhelp or God be our help Richard butcher 600272 600272 Short alias Godbeourhelp or God be our help, Richard, of Newport, Isle of Wight, butcher 0
4737495 2276841 2276841 defendant Kent Robert husbandman 600272 600272 Kent, Robert, of Newport, Isle of Wight, husbandman 0
4741591 2278036 2278036 defendant Irland John glover 600272 600272 Irland, John, of Newport, Isle of Wight, glover 0
4756085 2282282 2282282 defendant Rede Thomas   600272 600272 Rede, Thomas, of Newport, Isle of Wight, wool winder 1
4756448 2282382 2282382 defendant Tailiour Robert tailor 600272 600272 Tailiour, Robert, of Newport, Isle of Wight, tailor 1
4756687 2282455 2282455 defendant Yonge John   600272 600272 Yonge, John, of Newport, Isle of Wight, mill ward 0
4765486 2285196 2285196 defendant Bursted John tanner 600272 600272 Bursted, John, of Newport, Isle of Wight, tanner 1
4767667 2285867 2285867 defendant Dier John dyer 600272 600272 Dier, John, of Newport, Isle of Wight, dyer 0
4795064 2294601 2294601 defendant Irlond John husbandman 600272 600272 Irlond, John, of Newport, Isle of Wight, husbandman 0
4820373 2302443 2302443 defendant Busted John tanner 600272 600272 Busted, John, of Newport, Isle of Wight, tanner 0
4985709 2352642 2352642 defendant Bowyer Thomas   600272 600272 Bowyer, Thomas, of Newport, Isle of Wight, bow maker 0
4992059 2354515 2354515 defendant Yonge William butcher 600272 600272 Yonge, William, of Newport, Isle of Wight, butcher 0
5004884 2358326 2358326 defendant Fleccher Alice widow 600272 600272 Fleccher, Alice, of Newport, Isle of Wight, widow 2
5009656 2359703 2359703 defendant Yonge William butcher 600272 600272 Yonge, William, of Newport, Isle of Wight, butcher 1
5011333 2360178 2360178 defendant Frensshe Thomas chapman 600272 600272 Frensshe, Thomas, of Newport, Isle of Wight, chapman 0
5112706 2390106 2390106 defendant Stowr or Star Richard merchant 600272 600272 Stowr or Star, Richard, of Newport, Isle of Wight, merchant 0
5112709 2390106 2390106 defendant Gurmond John husbandman 600272 600272 Gurmond, John, of Newport, Isle of Wight, husbandman 3
5145885 2399925 2399925 defendant Logge Thomas yeoman 600272 600272 Logge, Thomas, of Newport, Isle of Wight, yeoman 2
5147987 2400556 2400556 defendant W_ Richard weaver 600272 600272 W_, Richard, of Newport, Isle of Wight, weaver 3
5166213 2405843 2405843 defendant Logge Thomas yeoman 600272 600272 Logge, Thomas, of Newport, Isle of Wight, yeoman 2
5166215 2405843 2405843 defendant Spegge William   600272 600272 Spegge, William, of Newport, Isle of Wight, mill ward 4
5166217 2405843 2405843 defendant Barnard Maior butcher 600272 600272 Barnard, Maior, of Newport, Isle of Wight, butcher 6
5166226 2405843 2405843 defendant Mudford Thomas yeoman 600272 600272 Mudford, Thomas, of Newport, Isle of Wight, yeoman 15
5166230 2405843 2405843 defendant Rawlyn John yeoman 600272 600272 Rawlyn, John, of Newport, Isle of Wight, yeoman 19
5171621 2407421 2407421 defendant Logge Thomas yeoman 600272 600272 Logge, Thomas, of Newport, Isle of Wight, yeoman 0
5178383 2409386 2409386 defendant Waleys William merchant 600272 600272 Waleys, William, of Newport, Isle of Wight, merchant 0
5178384 2409386 2409386 defendant Waleys John   600272 600272 Waleys, John, of Newport, Isle of Wight, merchant, son of William 1
5178627 2409464 2409464 defendant Pratte Nicholas fuller 600272 600272 Pratte, Nicholas, of Newport, Isle of Wight, fuller 0
5178628 2409464 2409464 defendant Pydford Isabel widow 600272 600272 Pydford, Isabel, of Newport, Isle of Wight, widow 1
5178630 2409465 2409465 defendant Saundyr Roger, sen fuller 600272 600272 Saundyr, Roger, sen, of Newport, Isle of Wight, fuller 0
5180951 2410168 2410168 defendant Logge Thomas yeoman 600272 600272 Logge, Thomas, of Newport, Isle of Wight, yeoman 2
5180953 2410168 2410168 defendant Spegge William   600272 600272 Spegge, William, of Newport, Isle of Wight, mill ward 4
5191419 2413231 2413231 defendant Waleys John merchant 600272 600272 Waleys, John, of Newport, Isle of Wight, merchant 0
5191420 2413231 2413231 defendant Keneby John gent 600272 600272 Keneby, John, of Newport, Isle of Wight, gent 1
5191605 2413286 2413286 defendant Waleys John merchant 600272 600272 Waleys, John, of Newport, Isle of Wight, merchant 0
5191608 2413287 2413287 defendant Waleys John merchant 600272 600272 Waleys, John, of Newport, Isle of Wight, merchant 0
5200002 2415756 2415756 defendant Orp William merchant 600272 600272 Orp, William, of Newport, Isle of Wight, merchant 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);