names

98 rows where place_id = 586781

✎ 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
3589609 1864391 1864391 defendant Hoker Thomas husbandman 586781 586781 Hoker, Thomas, of Corton, husbandman 0
3600545 1867817 1867817 defendant Prest John miller 586781 586781 Prest, John, of Corton, miller 2
3600551 1867818 1867818 defendant Prest John miller 586781 586781 Prest, John, of Corton, miller 2
3655143 1911870 1911870 plaintiff Dune John   586781 586781 Dune, John, of Corton 2
3657543 1912620 1912620 defendant Hustyngis William yeoman 586781 586781 Hustyngis, William, of Corton, yeoman 0
3671634 1917116 1917116 defendant Wylde Thomas senior tailor 586781 586781 Wylde, Thomas senior, of Corton, tailor 0
3671635 1917116 1917116 defendant Carter Thomas laborer 586781 586781 Carter, Thomas, of Corton, laborer 1
3675958 1918519 1918519 defendant Colman Elizabeth widow 586781 586781 Colman, Elizabeth, of Corton, widow 0
3703654 1927423 1927423 defendant Wylde Thomas husbandman 586781 586781 Wylde, Thomas, of Corton, husbandman 0
3724988 1934103 1934103 defendant Clewden George gent 586781 586781 Clewden, George, of Corton, gent 0
3733367 1936668 1936668 defendant Fugge Walter husbandman 586781 586781 Fugge, Walter, of Corton, husbandman 1
3751708 1942448 1942448 defendant Hustyngys William yeoman 586781 586781 Hustyngys, William, of Corton, yeoman 0
3756248 1943913 1943913 defendant Howes Robert husbandman 586781 586781 Howes, Robert, of Corton, husbandman 0
3770069 1948301 1948301 defendant Orveys William husbandman 586781 586781 Orveys, William, of Corton, husbandman 0
3790245 1954764 1954764 defendant Dunne John husbandman 586781 586781 Dunne, John, of Corton, husbandman 4
3795586 1956504 1956504 defendant Hustyng William yeoman 586781 586781 Hustyng, William, of Corton, yeoman 0
3808031 1960402 1960402 defendant Don John husbandman 586781 586781 Don, John, of Corton, husbandman 2
3811235 1961408 1961408 defendant Hustynge William yeoman 586781 586781 Hustynge, William, of Corton, yeoman 0
3843766 1971583 1971583 defendant Palmer John gent 586781 586781 Palmer, John, of Corton, gent 0
3850410 1973717 1973717 defendant Palmer John gent 586781 586781 Palmer, John, of Corton, gent 0
3863065 1977845 1977845 defendant Page Robert husbandman 586781 586781 Page, Robert, of Corton, husbandman 0
3894146 1988259 1988259 defendant Dyton Christopher husbandman 586781 586781 Dyton, Christopher, of Corton, husbandman 0
3894147 1988259 1988259 defendant Fairwether William husbandman 586781 586781 Fairwether, William, of Corton, husbandman 1
3894148 1988259 1988259 defendant Thorold Nicholas husbandman 586781 586781 Thorold, Nicholas, of Corton, husbandman 2
3899712 1990118 1990118 defendant Wrentham William yeoman 586781 586781 Wrentham, William, of Corton, yeoman 0
3899714 1990118 1990118 defendant Hustyngys William husbandman 586781 586781 Hustyngys, William, of Corton, husbandman 2
3902268 1990993 1990993 defendant Wrentham William, junior husbandman 586781 586781 Wrentham, William, junior, of Corton, husbandman 4
3920989 1997368 1997368 defendant Petcue Richard husbandman 586781 586781 Petcue, Richard, of Corton, husbandman 3
3939985 2003671 2003671 defendant Fayerwether William husbandman 586781 586781 Fayerwether, William, of Corton, husbandman 2
4002241 2025586 2025586 plaintiff hebbes Owen (legal representative) 586781 586781 hebbes, Owen, of Corton, gent, executor of 0
4104255 2061799 2061799 defendant Palmer Giles gent 586781 586781 Palmer, Giles, of Corton, gent 0
4104260 2061801 2061801 defendant Warde John yeoman 586781 586781 Warde, John, of Corton, yeoman 0
4233749 2107328 2107328 defendant Mompesson Thomas gent 586781 586781 Mompesson, Thomas, of Corton, gent 2
4236313 2108272 2108272 defendant Bonde William yeoman 586781 586781 Bonde, William, of Corton, yeoman 0
4357255 2149766 2149766 defendant Smythe Thomas   586781 586781 Smythe, Thomas, of Corton miller 0
4362510 2151642 2151642 defendant Sedboroughe Silvester gent 586781 586781 Sedboroughe, Silvester, of Corton, gent 1
4363907 2152149 2152149 defendant Mompesson Thomas esq 586781 586781 Mompesson, Thomas, of Corton, esq 0
4363908 2152149 2152149 defendant Piers Henry husbandman 586781 586781 Piers, Henry, of Corton, husbandman 1
4363909 2152149 2152149 defendant Forde Alexander husbandman 586781 586781 Forde, Alexander, of Corton, husbandman 2
4480945 2194714 2194714 plaintiff Lessy Roger   586781 586781 Lessy, Roger, of Corton 0
4534159 2210945 2210945 defendant Dynys John   586781 586781 Dynys, John, of Corton 2
4586533 2227197 2227197 plaintiff Heyth Thomas   586781 586781 Heyth, Thomas, of Corton 0
4654510 2247287 2247287 plaintiff Boleygus John   586781 586781 Boleygus, John, of Corton 0
4672432 2257031 2257031 defendant Bemond John chapman 586781 586781 Bemond, John, of Corton, chapman 0
4685049 2260923 2260923 defendant Do John husbandman 586781 586781 Do, John, of Corton, husbandman 1
4705338 2267043 2267043 defendant Coupere John husbandman 586781 586781 Coupere, John, of Corton, husbandman 0
4705340 2267043 2267043 defendant Baseley John husbandman 586781 586781 Baseley, John, of Corton, husbandman 2
4714727 2269935 2269935 defendant Tropenell Nicholas husbandman 586781 586781 Tropenell, Nicholas, of Corton, husbandman 0
4714730 2269936 2269936 defendant Tropenell Nicholas husbandman 586781 586781 Tropenell, Nicholas, of Corton, husbandman 0
4722852 2272462 2272462 defendant Sottesona alias Purtout John husbandman 586781 586781 Sottesona alias Purtout, John, of Corton, husbandman 0
4737430 2276821 2276821 plaintiff Upton John   586781 586781 Upton, John, of Corton 0
4738352 2277091 2277091 defendant Claymond John, sen   586781 586781 Claymond, John, sen, of Corton 0
4834836 2306899 2306899 defendant Kyng William husbandman 586781 586781 Kyng, William, of Corton, husbandman 0
4841891 2309000 2309000 defendant Bukke John husbandman 586781 586781 Bukke, John, of Corton, husbandman 0
4841892 2309000 2309000 defendant Perys William husbandman 586781 586781 Perys, William, of Corton, husbandman 1
4841893 2309000 2309000 defendant Tommys John husbandman 586781 586781 Tommys, John, of Corton, husbandman 2
4861383 2314929 2314929 defendant Claymound John   586781 586781 Claymound, John, of Corton 1
4868492 2317118 2317118 defendant Wonston John husbandman 586781 586781 Wonston, John, of Corton, husbandman 0
4886639 2322686 2322686 defendant Grene John husbandman 586781 586781 Grene, John, of Corton, husbandman 0
4886640 2322686 2322686 defendant Grene Richard singleman or yeoman 586781 586781 Grene, Richard, of Corton, singleman or yeoman 1
4904239 2327936 2327936 defendant Grene John husbandman 586781 586781 Grene, John, of Corton, husbandman 0
4904240 2327936 2327936 defendant Grene Richard singleman or yeoman 586781 586781 Grene, Richard, of Corton, singleman or yeoman 1
4940342 2339003 2339003 defendant Samper John waterman 586781 586781 Samper, John, of Corton, waterman 0
4956454 2343887 2343887 defendant Samper John husbandman 586781 586781 Samper, John, of Corton, husbandman 1
4995882 2355617 2355617 defendant Slade Henry husbandman 586781 586781 Slade, Henry, of Corton, husbandman 0
4995883 2355617 2355617 defendant Tilly John husbandman 586781 586781 Tilly, John, of Corton, husbandman 1
5043451 2369664 2369664 defendant Bury John husbandman 586781 586781 Bury, John, of Corton, husbandman 2
5066075 2376376 2376376 defendant Kyng William husbandman 586781 586781 Kyng, William, of Corton, husbandman 5
5134853 2396695 2396695 defendant Clevedon John   586781 586781 Clevedon, John, of Corton, servant 0
5134854 2396695 2396695 defendant Stryklond John   586781 586781 Stryklond, John, of Corton, servant 1
5154863 2402581 2402581 defendant Cleveden John gent 586781 586781 Cleveden, John, of Corton, gent 0
5154864 2402581 2402581 defendant Whyte Robert husbandman 586781 586781 Whyte, Robert, of Corton, husbandman 1
5154865 2402581 2402581 defendant Steynt Thomas   586781 586781 Steynt, Thomas, of Corton, servant 2
5154866 2402581 2402581 defendant Stryklond John   586781 586781 Stryklond, John, of Corton, servant 3
5171739 2407455 2407455 defendant Whyte Robert husbandman 586781 586781 Whyte, Robert, of Corton, husbandman 1
5171740 2407455 2407455 defendant Steyne Thomas   586781 586781 Steyne, Thomas, of Corton, servant 2
5171741 2407455 2407455 defendant Stryklond John   586781 586781 Stryklond, John, of Corton, servant 3
5206932 2417763 2417763 defendant Clevedon John gent 586781 586781 Clevedon, John, of Corton, gent 0
5206933 2417763 2417763 defendant Whyte Robert husbandman 586781 586781 Whyte, Robert, of Corton, husbandman 1
5206934 2417763 2417763 defendant Steynt Thomas   586781 586781 Steynt, Thomas, of Corton, servant 2
5206935 2417763 2417763 defendant Strykland John   586781 586781 Strykland, John, of Corton, servant 3
5218865 2421241 2421241 defendant Seman John yeoman 586781 586781 Seman, John, of Corton, yeoman 1
5218871 2421242 2421242 defendant Seman John yeoman 586781 586781 Seman, John, of Corton, yeoman 1
5290811 2442319 2442319 defendant Spere Walter clerk 586781 586781 Spere, Walter, of Corton, clerk 0
5297107 2444151 2444151 defendant Seman John husbandman 586781 586781 Seman, John, of Corton, husbandman 0
5297108 2444151 2444151 defendant Hoo John husbandman 586781 586781 Hoo, John, of Corton, husbandman 1
5301586 2445428 2445428 defendant Olton John tanner 586781 586781 Olton, John, of Corton, tanner 0
5489685 2501797 2501797 defendant Hoo Richard husbandman 586781 586781 Hoo, Richard, of Corton, husbandman 0
5500460 2505078 2505078 defendant Basiley John yeoman 586781 586781 Basiley, John, of Corton, yeoman 0
5569385 2525605 2525605 defendant Colman William yeoman 586781 586781 Colman, William, of Corton, yeoman 0
5580825 2529081 2529081 defendant Age Thomas tailor 586781 586781 Age, Thomas, of Corton, tailor 1
5580830 2529082 2529082 defendant Age Thomas tailor 586781 586781 Age, Thomas, of Corton, tailor 1
5624067 2551475 2551475 defendant Isote Thomas, senior husbandman 586781 586781 Isote, Thomas, senior, of Corton, husbandman 2
5624068 2551475 2551475 defendant Thomas junior husbandman 586781 586781 Thomas, junior, of Corton, husbandman 3
5624069 2551475 2551475 defendant Drake William husbandman 586781 586781 Drake, William, of Corton, husbandman 4
5624070 2551475 2551475 defendant North John husbandman 586781 586781 North, John, of Corton, husbandman 5
5624071 2551475 2551475 defendant Kyng William husbandman 586781 586781 Kyng, William, of Corton, husbandman 6
5630407 2553520 2553520 defendant Baseley John ploughman 586781 586781 Baseley, John, of Corton, ploughman 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);