names

73 rows where place_id = 589647

✎ 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
3598281 1867093 1867093 defendant Warner Robert yeoman 589647 589647 Warner, Robert, of Runton, yeoman 0
3598283 1867094 1867094 defendant Warner Robert yeoman 589647 589647 Warner, Robert, of Runton, yeoman 0
3812306 1961743 1961743 defendant Ayleward Thomas yeoman 589647 589647 Ayleward, Thomas, of Runton, yeoman 2
3812323 1961747 1961747 defendant Ayleward Thomas yeoman 589647 589647 Ayleward, Thomas, of Runton, yeoman 1
3813699 1962197 1962197 plaintiff Everard John clerk 589647 589647 Everard, John, of Runton, clerk 0
3859761 1976765 1976765 defendant Ussher alias Short John mariner 589647 589647 Ussher alias Short, John, of Runton, mariner 0
3874024 1981535 1981535 defendant Waverley Richard cordwainer 589647 589647 Waverley, Richard, of Runton, cordwainer 0
3968872 2013740 2013740 defendant Webster William tailor 589647 589647 Webster, William, of Runton, tailor 0
4020338 2031996 2031996 defendant Helmes Lancelot gent 589647 589647 Helmes, Lancelot, of Runton, gent 0
4055280 2044287 2044287 defendant Evered Bartholomew mariner 589647 589647 Evered, Bartholomew, of Runton, mariner 1
4058090 2045274 2045274 defendant Venable James clerk 589647 589647 Venable, James, of Runton, clerk 3
4072897 2050602 2050602 defendant Venables James clerk 589647 589647 Venables, James, of Runton, clerk 0
4106891 2062756 2062756 defendant Venables James clerk 589647 589647 Venables, James, of Runton, clerk 0
4117045 2066398 2066398 defendant Dawson James husbandman 589647 589647 Dawson, James, of Runton, husbandman 0
4117046 2066398 2066398 defendant Platten Peter husbandman 589647 589647 Platten, Peter, of Runton, husbandman 1
4140701 2074913 2074913 defendant Rooke William mariner 589647 589647 Rooke, William, of Runton, mariner 1
4140702 2074913 2074913 defendant Baxter Edmund yeoman 589647 589647 Baxter, Edmund, of Runton, yeoman 2
4143388 2075852 2075852 defendant Storke George husbandman 589647 589647 Storke, George, of Runton, husbandman 0
4147116 2077134 2077134 defendant Rooke William mariner 589647 589647 Rooke, William, of Runton, mariner 1
4148283 2077530 2077530 defendant Rooke William mariner 589647 589647 Rooke, William, of Runton, mariner 1
4152324 2078923 2078923 defendant Rooke William mariner 589647 589647 Rooke, William, of Runton, mariner 3
4154072 2079518 2079518 defendant Hyllyngton John   589647 589647 Hyllyngton, John, of Runton, sailor 1
4154077 2079519 2079519 defendant Hyllyngton John   589647 589647 Hyllyngton, John, of Runton, sailor 1
4154081 2079520 2079520 defendant Rooke William mariner 589647 589647 Rooke, William, of Runton, mariner 0
4160927 2081893 2081893 defendant Rooke William mariner 589647 589647 Rooke, William, of Runton, mariner 0
4166715 2083855 2083855 defendant Platten Peter husbandman 589647 589647 Platten, Peter, of Runton, husbandman 0
4174357 2086496 2086496 defendant Rocke William mariner 589647 589647 Rocke, William, of Runton, mariner 0
4178091 2087806 2087806 defendant Hyllyngton John mariner 589647 589647 Hyllyngton, John, of Runton, mariner 2
4182550 2089375 2089375 defendant Holmes Eleanor widow 589647 589647 Holmes, Eleanor, of Runton, widow 2
4189188 2091711 2091711 defendant Rocke William husbandman 589647 589647 Rocke, William, of Runton, husbandman 0
4189190 2091711 2091711 defendant Baxter Edmund mariner 589647 589647 Baxter, Edmund, of Runton, mariner 2
4197360 2094631 2094631 defendant Matt Robert mariner 589647 589647 Matt, Robert, of Runton, mariner 3
4222156 2103239 2103239 defendant Buntynge Henry gent 589647 589647 Buntynge, Henry, of Runton, gent 2
4249066 2112672 2112672 defendant Lee Thomas yeoman 589647 589647 Lee, Thomas, of Runton, yeoman 0
4249068 2112672 2112672 defendant Miller Robert husbandman 589647 589647 Miller, Robert, of Runton, husbandman 2
4252142 2113702 2113702 defendant Pull John husbandman 589647 589647 Pull, John, of Runton, husbandman 0
4260725 2116554 2116554 defendant Porter Thomas gent 589647 589647 Porter, Thomas, of Runton, gent 0
4265146 2117981 2117981 defendant Whynnett Thomas yeoman 589647 589647 Whynnett, Thomas, of Runton, yeoman 1
4288986 2126117 2126117 defendant Miller Robert husbandman or yeoman 589647 589647 Miller, Robert, of Runton, husbandman or yeoman 0
4320614 2137301 2137301 defendant Buntyng Henry gent 589647 589647 Buntyng, Henry, of Runton, gent 2
4320615 2137301 2137301 defendant Porter Thomas clerk 589647 589647 Porter, Thomas, of Runton, clerk 3
4326441 2139205 2139205 defendant Whynnett Thomas husbandman 589647 589647 Whynnett, Thomas, of Runton, husbandman 0
4328505 2139849 2139849 defendant Myller Robert husbandman 589647 589647 Myller, Robert, of Runton, husbandman 0
4329253 2140096 2140096 defendant Buntynge Henry yeoman 589647 589647 Buntynge, Henry, of Runton, yeoman 2
4339523 2143592 2143592 defendant Howard Thomas husbandman 589647 589647 Howard, Thomas, of Runton, husbandman 1
4341768 2144395 2144395 defendant Buttynge or Buntynge Henry gent 589647 589647 Buttynge or Buntynge, Henry, of Runton, gent 0
4352632 2148154 2148154 defendant Buntyng Henry gent 589647 589647 Buntyng, Henry, of Runton, gent 1
4418858 2170763 2170763 defendant Clement John   589647 589647 Clement, John, of Runton 3
4421721 2171678 2171678 defendant Taillour John   589647 589647 Taillour, John, of Runton 0
4457365 2187315 2187315 defendant Skilman Nicholas   589647 589647 Skilman, Nicholas, of Runton 0
4495427 2199250 2199250 defendant Toke Alice   589647 589647 Toke, Alice, of Runton, formerly wife of John Toke 0
4521818 2207159 2207159 defendant Soutere John   589647 589647 Soutere, John, of Runton 0
4522035 2207233 2207233 defendant Soutere Richard   589647 589647 Soutere, Richard, of Runton 0
4651159 2246367 2246367 defendant Maunvyle Ralph husbandman 589647 589647 Maunvyle, Ralph, of Runton juxta Crowemer, husbandman 0
4717116 2270683 2270683 defendant Hert William yeoman 589647 589647 Hert, William, of Runton, yeoman 0
4717117 2270683 2270683 defendant Hert John yeoman 589647 589647 Hert, John, of Runton, yeoman 1
4808688 2298885 2298885 defendant Skylman Thomas pedder 589647 589647 Skylman, Thomas, of Runton, pedder 0
4814380 2300606 2300606 defendant Couper William shoemaker 589647 589647 Couper, William, of Runton, shoemaker 1
4815740 2301025 2301025 defendant Skylman Thomas husbandman 589647 589647 Skylman, Thomas, of Runton, husbandman 0
4828873 2305068 2305068 defendant Bokkyng John husbandman 589647 589647 Bokkyng, John, of Runton, husbandman 0
4928325 2335283 2335283 defendant Gamelgay alias Pollard Thomas husbandman 589647 589647 Gamelgay alias Pollard, Thomas, of Runton, husbandman 0
4949900 2341945 2341945 defendant Skylman Thomas husbandman 589647 589647 Skylman, Thomas, of Runton, husbandman 4
4949901 2341945 2341945 defendant Souter William husbandman 589647 589647 Souter, William, of Runton, husbandman 5
5274585 2437648 2437648 defendant Wellys William husbandman 589647 589647 Wellys, William, of Runton, husbandman 1
5274773 2437699 2437699 defendant Wellys William husbandman 589647 589647 Wellys, William, of Runton, husbandman 1
5291836 2442617 2442617 defendant Wellys William husbandman 589647 589647 Wellys, William, of Runton, husbandman 1
5291957 2442653 2442653 defendant Wellys William husbandman 589647 589647 Wellys, William, of Runton, husbandman 1
5385415 2470906 2470906 defendant Pestell William husbandman 589647 589647 Pestell, William, of Runton, husbandman 7
5397555 2474374 2474374 defendant Pestell William husbandman 589647 589647 Pestell, William, of Runton, husbandman 7
5404615 2476394 2476394 defendant Burflete Thomas husbandman 589647 589647 Burflete, Thomas, of Runton, husbandman 7
5484626 2500326 2500326 defendant Burflete Thomas yeoman 589647 589647 Burflete, Thomas, of Runton, yeoman 1
5570756 2526006 2526006 defendant Howke William   589647 589647 Howke, William, of Runton, wax chandler 2
5629963 2553372 2553372 defendant Maundevyle Ralph carter 589647 589647 Maundevyle, Ralph, of Runton, carter 3

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