names

171 rows where place_id = 595622

✎ 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
3621211 1874174 1874174 defendant Bocher alias Halton John butcher 595622 595622 Bocher alias Halton, John, of Acton, butcher 4
3631002 1904518 1904518 plaintiff Frost William gent 595622 595622 Frost, William, of Acton, gent 0
3633366 1905246 1905246 defendant Sellam William husbandman 595622 595622 Sellam, William, of Acton, husbandman 7
3650516 1910530 1910530 defendant Gosse Robert husbandman 595622 595622 Gosse, Robert, of Acton, husbandman 0
3650518 1910530 1910530 defendant Gosse alias Myller Joan widow 595622 595622 Gosse alias Myller, Joan, of Acton, widow 2
3657067 1912473 1912473 defendant Clarbek John gent 595622 595622 Clarbek, John, of Acton, gent 0
3665349 1915115 1915115 defendant Wylles Robert butcher 595622 595622 Wylles, Robert, of Acton, butcher 2
3675969 1918523 1918523 defendant Pyxley John husbandman 595622 595622 Pyxley, John, of Acton, husbandman 0
3680677 1920037 1920037 defendant Lerer Edward husbandman 595622 595622 Lerer, Edward, of Acton, husbandman 0
3680678 1920037 1920037 defendant Jeneyn Thomas laborer 595622 595622 Jeneyn, Thomas, of Acton, laborer 1
3680679 1920037 1920037 defendant Smyth Henry laborer 595622 595622 Smyth, Henry, of Acton, laborer 2
3687148 1922155 1922155 defendant Webbe Thomas weaver 595622 595622 Webbe, Thomas, of Acton, weaver 1
3687743 1922334 1922334 defendant Russell John tailor 595622 595622 Russell, John, of Acton, tailor 0
3687749 1922335 1922335 defendant Russell John tailor 595622 595622 Russell, John, of Acton, tailor 0
3694108 1924361 1924361 defendant Blunte Walter gent 595622 595622 Blunte, Walter, of Acton, gent 0
3694109 1924361 1924361 defendant Grene John yeoman 595622 595622 Grene, John, of Acton, yeoman 1
3694110 1924361 1924361 defendant Palmer Lewis laborer 595622 595622 Palmer, Lewis, of Acton, laborer 2
3694391 1924451 1924451 defendant Russell John tailor 595622 595622 Russell, John, of Acton, tailor 1
3694405 1924454 1924454 defendant Sothay John husbandman 595622 595622 Sothay, John, of Acton, husbandman 0
3702737 1927128 1927128 defendant Russell John tailor 595622 595622 Russell, John, of Acton, tailor 0
3708343 1928905 1928905 defendant Russell John tailor 595622 595622 Russell, John, of Acton, tailor 0
3708349 1928905 1928905 defendant Colyer William husbandman 595622 595622 Colyer, William, of Acton, husbandman 6
3715885 1931254 1931254 defendant Webbe Thomas weaver 595622 595622 Webbe, Thomas, of Acton, weaver 1
3716514 1931462 1931462 defendant Russell John tailor 595622 595622 Russell, John, of Acton, tailor 0
3718656 1932115 1932115 defendant Petycan Robert fuller 595622 595622 Petycan, Robert, of Acton, fuller 0
3723668 1933678 1933678 defendant Lerer Edward yeoman 595622 595622 Lerer, Edward, of Acton, yeoman 0
3732084 1936269 1936269 defendant Orbell Ralph tailor 595622 595622 Orbell, Ralph, of Acton, tailor 1
3737191 1937864 1937864 defendant Grene Thomas fuller 595622 595622 Grene, Thomas, of Acton, fuller 0
3746740 1940896 1940896 defendant Partryche William husbandman 595622 595622 Partryche, William, of Acton, husbandman 0
3746741 1940896 1940896 defendant Partryche Roger weaver 595622 595622 Partryche, Roger, of Acton, weaver 1
3762241 1945836 1945836 defendant Petycan John clothmaker 595622 595622 Petycan, John, of Acton, clothmaker 2
3765826 1946977 1946977 defendant Acton Thomas gent 595622 595622 Acton, Thomas, of Acton, gent 1
3766371 1947137 1947137 defendant Grene Elias fuller 595622 595622 Grene, Elias, of Acton, fuller 0
3769218 1948025 1948025 defendant Symson Miles tailor 595622 595622 Symson, Miles, of Acton, tailor 1
3769861 1948227 1948227 defendant Crochyn John husbandman 595622 595622 Crochyn, John, of Acton, husbandman 2
3769862 1948227 1948227 defendant Partryche William husbandman 595622 595622 Partryche, William, of Acton, husbandman 3
3777662 1950761 1950761 defendant Pryge Richard wenman 595622 595622 Pryge, Richard, of Acton, wenman 2
3780397 1951604 1951604 defendant Petycan John fuller 595622 595622 Petycan, John, of Acton, fuller 0
3784309 1952880 1952880 defendant Clarves Richard husbandman 595622 595622 Clarves, Richard, of Acton, husbandman 10
3804830 1959455 1959455 defendant Heyward William husbandman 595622 595622 Heyward, William, of Acton, husbandman 0
3808255 1960455 1960455 defendant Gohe Owen ap Howel gent 595622 595622 Gohe, Owen ap Howel, of Acton, gent 0
3808256 1960455 1960455 defendant Ap Gyte Evan ap Rice gent 595622 595622 Ap Gyte, Evan ap Rice, of Acton, gent 1
3821198 1964523 1964523 defendant Clysby Stephen maltman 595622 595622 Clysby, Stephen, of Acton, maltman 2
3864643 1978373 1978373 defendant Seman John husbandman 595622 595622 Seman, John, of Acton, husbandman 0
3864645 1978374 1978374 defendant Seman John husbandman 595622 595622 Seman, John, of Acton, husbandman 0
3869500 1980041 1980041 defendant Byrde William yeoman 595622 595622 Byrde, William, of Acton, yeoman 0
3869502 1980041 1980041 defendant Hawkyns Thomas yeoman 595622 595622 Hawkyns, Thomas, of Acton, yeoman 2
3870852 1980502 1980502 defendant Lawe John gent 595622 595622 Lawe, John, of Acton, gent 0
3876506 1982389 1982389 defendant Barker Thomas husbandman 595622 595622 Barker, Thomas, of Acton, husbandman 3
3887010 1985918 1985918 defendant Byrkyn William husbandman 595622 595622 Byrkyn, William, of Acton, husbandman 1
3902396 1991032 1991032 defendant Barker Thomas husbandman 595622 595622 Barker, Thomas, of Acton, husbandman 2
3912136 1994384 1994384 plaintiff Wyllott Thomas   595622 595622 Wyllott, Thomas, of Acton 0
3922578 1997867 1997867 defendant Coke William joiner 595622 595622 Coke, William, of Acton, joiner 0
3937544 2002892 2002892 plaintiff Ormyshay Richard   595622 595622 Ormyshay, Richard, of Acton, vicar 0
3946195 2005747 2005747 defendant Smyth John husbandman 595622 595622 Smyth, John, of Acton, husbandman 0
3956322 2009276 2009276 plaintiff Nedler Simon yeoman 595622 595622 Nedler, Simon, of Acton, yeoman 0
3971400 2014554 2014554 defendant Longe William husbandman 595622 595622 Longe, William, of Acton, husbandman 0
3980250 2017702 2017702 plaintiff Payne William husbandman 595622 595622 Payne, William, of Acton, husbandman 0
3980251 2017702 2017702 defendant Holborowe John husbandman 595622 595622 Holborowe, John, of Acton, husbandman 0
3980256 2017704 2017704 defendant Holborowe John husbandman 595622 595622 Holborowe, John, of Acton, husbandman 0
3987377 2020233 2020233 defendant Alborough John husbandman 595622 595622 Alborough, John, of Acton, husbandman 2
3997215 2023774 2023774 defendant Newman John butcher 595622 595622 Newman, John, of Acton, butcher 1
4025758 2033866 2033866 defendant Lyster Edward yeoman 595622 595622 Lyster, Edward, of Acton, yeoman 3
4055356 2044315 2044315 defendant Skellett Thomas tailor 595622 595622 Skellett, Thomas, of Acton, tailor 3
4086532 2055468 2055468 defendant Downyng John yeoman 595622 595622 Downyng, John, of Acton, yeoman 3
4106528 2062624 2062624 defendant Cannam Richard yeoman 595622 595622 Cannam, Richard, of Acton, yeoman 1
4118999 2067077 2067077 defendant Longdon Stephen husbandman 595622 595622 Longdon, Stephen, of Acton, husbandman 0
4144336 2076178 2076178 defendant Lythegoe Richard husbandman 595622 595622 Lythegoe, Richard, of Acton, husbandman 0
4156122 2080216 2080216 defendant Longdon Joan widow 595622 595622 Longdon, Joan, of Acton, widow 0
4156123 2080216 2080216 defendant Robert Jevan yeoman 595622 595622 Robert, Jevan, of Acton, yeoman 1
4156125 2080217 2080217 defendant Longdon Joan widow 595622 595622 Longdon, Joan, of Acton, widow 0
4156126 2080217 2080217 defendant Robert Jevan yeoman 595622 595622 Robert, Jevan, of Acton, yeoman 1
4165691 2083499 2083499 defendant Lyethgoe Richard husbandman 595622 595622 Lyethgoe, Richard, of Acton, husbandman 3
4167173 2084023 2084023 defendant Lythagoe Richard husbandman 595622 595622 Lythagoe, Richard, of Acton, husbandman 0
4177849 2087726 2087726 defendant Hyethgoe Richard husbandman 595622 595622 Hyethgoe, Richard, of Acton, husbandman 1
4223471 2103699 2103699 defendant Lythegoe Richard husbandman 595622 595622 Lythegoe, Richard, of Acton, husbandman 0
4243810 2110910 2110910 defendant Dunne Samuel yeoman 595622 595622 Dunne, Samuel, of Acton, yeoman 0
4246320 2111747 2111747 defendant Tytterell alias Janck William yeoman 595622 595622 Tytterell alias Janck, William, of Acton, yeoman 0
4246811 2111909 2111909 defendant Newman John yeoman 595622 595622 Newman, John, of Acton, yeoman 1
4294942 2128276 2128276 defendant Freman Anthony yeoman 595622 595622 Freman, Anthony, of Acton, yeoman 0
4294943 2128276 2128276 defendant Freeman Henry yeoman 595622 595622 Freeman, Henry, of Acton, yeoman 1
4300271 2130197 2130197 defendant Vyncent Robert yeoman 595622 595622 Vyncent, Robert, of Acton, yeoman 0
4300272 2130197 2130197 defendant Vyncent William yeoman 595622 595622 Vyncent, William, of Acton, yeoman 1
4300273 2130197 2130197 defendant Smyth Thomas husbandman 595622 595622 Smyth, Thomas, of Acton, husbandman 2
4300274 2130197 2130197 defendant Chader John husbandman 595622 595622 Chader, John, of Acton, husbandman 3
4304715 2131783 2131783 defendant Sheppard Edward yeoman 595622 595622 Sheppard, Edward, of Acton, yeoman 1
4306364 2132369 2132369 defendant Titterill alias Jankes William yeoman 595622 595622 Titterill alias Jankes, William, of Acton, yeoman 2
4306373 2132372 2132372 defendant Cambe Arthur gent 595622 595622 Cambe, Arthur, of Acton Ilger, gent 0
4314271 2135098 2135098 defendant Carnebie Nicholas gent 595622 595622 Carnebie, Nicholas, of Acton, gent 0
4314940 2135336 2135336 defendant Cambe Arthur gent 595622 595622 Cambe, Arthur, of Acton Ilger, gent 0
4322110 2137812 2137812 defendant Vyncent William yeoman 595622 595622 Vyncent, William, of Acton, yeoman 0
4322111 2137812 2137812 defendant Smyth Thomas husbandman 595622 595622 Smyth, Thomas, of Acton, husbandman 1
4327543 2139534 2139534 defendant Janck alias Tytterell William yeoman 595622 595622 Janck alias Tytterell, William, of Acton, yeoman 0
4332568 2141181 2141181 defendant Shott William yeoman 595622 595622 Shott, William, of Acton, yeoman 0
4333451 2141467 2141467 defendant Iveson George yeoman 595622 595622 Iveson, George, of Acton, yeoman 0
4333453 2141468 2141468 defendant Iveson George yeoman 595622 595622 Iveson, George, of Acton, yeoman 0
4333609 2141523 2141523 defendant Jancke William husbandman 595622 595622 Jancke, William, of Acton, husbandman 0
4334085 2141681 2141681 defendant Tytterell alias Janck William yeoman 595622 595622 Tytterell alias Janck, William, of Acton, yeoman 1
4356165 2149379 2149379 defendant Tytterell alias Janck William yeoman 595622 595622 Tytterell alias Janck, William, of Acton, yeoman 0
4357874 2149996 2149996 defendant Janck William yeoman 595622 595622 Janck, William, of Acton, yeoman 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);