names

244 rows where place_id = 587546

✎ 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
3591709 1865025 1865025 defendant Wrangyll William husbandman 587546 587546 Wrangyll, William, of Halton, husbandman 1
3634693 1905645 1905645 defendant Litilpage John tanner 587546 587546 Litilpage, John, of Halton, tanner 0
3634694 1905645 1905645 defendant Streteley John husbandman 587546 587546 Streteley, John, of Halton, husbandman 1
3636951 1906352 1906352 defendant Tomson Henry pardoner 587546 587546 Tomson, Henry, of Halton, pardoner 1
3637774 1906630 1906630 defendant Trygg John clerk 587546 587546 Trygg, John, of Halton, clerk 0
3651979 1910965 1910965 defendant Weloman Hugh yeoman 587546 587546 Weloman, Hugh, of Halton, yeoman 0
3654769 1911749 1911749 defendant Tryggys John clerk 587546 587546 Tryggys, John, of Halton, clerk 0
3654770 1911749 1911749 defendant Clothyer William husbandman 587546 587546 Clothyer, William, of Halton, husbandman 1
3654771 1911749 1911749 defendant Clothyer Henry   587546 587546 Clothyer, Henry, of Halton, groome 2
3669070 1916258 1916258 defendant Tryggys John clerk 587546 587546 Tryggys, John, of Halton, clerk 0
3669071 1916258 1916258 defendant Clothyer William husbandman 587546 587546 Clothyer, William, of Halton, husbandman 1
3669072 1916258 1916258 defendant Clothyer Henry   587546 587546 Clothyer, Henry, of Halton, groom 2
3705537 1928015 1928015 defendant Houghton John yeoman 587546 587546 Houghton, John, of Halton, yeoman 1
3705538 1928015 1928015 defendant Baguley John yeoman 587546 587546 Baguley, John, of Halton, yeoman 2
3705539 1928015 1928015 defendant Mason Thomas yeoman 587546 587546 Mason, Thomas, of Halton, yeoman 3
3705542 1928016 1928016 defendant Houghton John yeoman 587546 587546 Houghton, John, of Halton, yeoman 1
3705543 1928016 1928016 defendant Baguley John yeoman 587546 587546 Baguley, John, of Halton, yeoman 2
3705544 1928016 1928016 defendant Mason Thomas yeoman 587546 587546 Mason, Thomas, of Halton, yeoman 3
3714425 1930806 1930806 defendant Browne Christopher gent 587546 587546 Browne, Christopher, of Halton, gent 1
3720835 1932809 1932809 defendant Russell Walter tailor 587546 587546 Russell, Walter, of Halton, tailor 1
3726758 1934635 1934635 defendant Jakson John husbandman 587546 587546 Jakson, John, of Halton, husbandman 0
3741048 1939063 1939063 defendant Adams William husbandman 587546 587546 Adams, William, of Halton, husbandman 0
3769999 1948275 1948275 defendant Coke John husbandman 587546 587546 Coke, John, of Halton, husbandman 1
3804736 1959428 1959428 defendant Rodeley Thomas yeoman 587546 587546 Rodeley, Thomas, of Halton, yeoman 0
3804737 1959428 1959428 defendant Fenne Richard yeoman 587546 587546 Fenne, Richard, of Halton, yeoman 1
3804738 1959428 1959428 defendant Coppe John husbandman 587546 587546 Coppe, John, of Halton, husbandman 2
3804739 1959428 1959428 defendant hewe Edmund husbandman 587546 587546 hewe, Edmund, of Halton, husbandman 3
3804740 1959428 1959428 defendant Harde William husbandman 587546 587546 Harde, William, of Halton, husbandman 4
3832409 1968057 1968057 defendant Walker Christopher husbandman 587546 587546 Walker, Christopher, of Halton on Humber, husbandman 0
3843652 1971547 1971547 defendant Blady William butcher 587546 587546 Blady, William, of Halton, butcher 2
3843653 1971547 1971547 defendant Bowland Richard husbandman 587546 587546 Bowland, Richard, of Halton, husbandman 3
3843654 1971547 1971547 defendant Saumer Thomas yeoman 587546 587546 Saumer, Thomas, of Halton, yeoman 4
3843906 1971632 1971632 defendant Bladys William butcher 587546 587546 Bladys, William, of Halton, butcher 2
3843907 1971632 1971632 defendant Bowland Richard   587546 587546 Bowland, Richard, of Halton 3
3843908 1971632 1971632 defendant Saumer Thomas yeoman 587546 587546 Saumer, Thomas, of Halton, yeoman 4
3878799 1983159 1983159 defendant Suddeley Guy yeoman 587546 587546 Suddeley, Guy, of Halton, yeoman 0
3888333 1986360 1986360 defendant Grave Robert yeoman 587546 587546 Grave, Robert, of Halton, yeoman 2
3899789 1990141 1990141 defendant Farray Richard husbandman 587546 587546 Farray, Richard, of Halton, husbandman 0
3902171 1990961 1990961 defendant Sotheby Guy gent 587546 587546 Sotheby, Guy, of Halton juxta Humber, gent 0
3946949 2005996 2005996 defendant Yonge George husbandman 587546 587546 Yonge, George, of Halton, husbandman 0
3980035 2017621 2017621 defendant Massynberd John gent 587546 587546 Massynberd, John, of Halton, gent 2
3980039 2017622 2017622 defendant Massyngberd John gent 587546 587546 Massyngberd, John, of Halton, gent 2
4012494 2029190 2029190 plaintiff Radley Thomas gent 587546 587546 Radley, Thomas, of Halton, gent 0
4053236 2043541 2043541 defendant Helde Thomas collier 587546 587546 Helde, Thomas, of Halton, collier 1
4094118 2058227 2058227 defendant Howson John clerk 587546 587546 Howson, John, of Halton, clerk 0
4113439 2065081 2065081 defendant Healde William husbandman 587546 587546 Healde, William, of Halton, or of Hortone, husbandman 1
4113441 2065081 2065081 defendant Norton Michael   587546 587546 Norton, Michael, of Halton, wire drawer 3
4113444 2065082 2065082 defendant Healde William   587546 587546 Healde, William, of Halton husbandman 1
4121462 2067968 2067968 defendant Stater Thomas yeoman 587546 587546 Stater, Thomas, of Halton, yeoman 3
4123895 2068846 2068846 defendant Whitinge Robert (legal representative) 587546 587546 Whitinge, Robert, of Halton, yeoman, administrator of 0
4136983 2073575 2073575 defendant Parker Thomas husbandman 587546 587546 Parker, Thomas, of Halton, husbandman 0
4138549 2074155 2074155 defendant Wilkinson Thomas husbandman 587546 587546 Wilkinson, Thomas, of Halton, husbandman 0
4163155 2082644 2082644 defendant Wilkinson Thomas husbandman 587546 587546 Wilkinson, Thomas, of Halton, husbandman 0
4167399 2084098 2084098 defendant Brerton Roger esq 587546 587546 Brerton, Roger, of Halton, or of Hurrathick, Flint, esq 0
4173557 2086207 2086207 defendant Thorye Thomas yeoman 587546 587546 Thorye, Thomas, of Halton, yeoman 0
4175677 2086962 2086962 defendant Snydall John husbandman 587546 587546 Snydall, John, of Halton, husbandman 3
4190149 2092060 2092060 defendant Illingworth Richard husbandman 587546 587546 Illingworth, Richard, of Halton, husbandman 0
4207463 2098165 2098165 defendant Boothe John clerk 587546 587546 Boothe, John, of Halton, clerk 0
4213636 2100291 2100291 defendant Illingworthe Richard husbandman 587546 587546 Illingworthe, Richard, of Halton, husbandman 0
4215619 2100960 2100960 defendant Wylson John husbandman 587546 587546 Wylson, John, of Halton, husbandman 1
4230209 2106051 2106051 defendant Boothe William husbandman 587546 587546 Boothe, William, of Halton, husbandman 3
4231671 2106579 2106579 defendant Pickeringe Thomas merchant 587546 587546 Pickeringe, Thomas, of Halton, merchant 0
4231673 2106579 2106579 defendant Pyckeringe John yeoman 587546 587546 Pyckeringe, John, of Halton, yeoman 2
4234537 2107624 2107624 defendant Overey Thomas gent 587546 587546 Overey, Thomas, of Halton, gent 0
4234539 2107625 2107625 defendant Overey Thomas gent 587546 587546 Overey, Thomas, of Halton, gent 0
4238929 2109235 2109235 defendant Boothe William husbandman 587546 587546 Boothe, William, of Halton, husbandman 3
4275294 2121294 2121294 defendant Copie John yeoman 587546 587546 Copie, John, of Halton, yeoman 0
4275295 2121294 2121294 defendant Beckingham Richard yeoman 587546 587546 Beckingham, Richard, of Halton, yeoman 1
4275296 2121294 2121294 defendant Bennytt George yeoman 587546 587546 Bennytt, George, of Halton, yeoman 2
4275299 2121295 2121295 defendant Greene John yeoman 587546 587546 Greene, John, of Halton, yeoman 1
4297761 2129306 2129306 defendant Somercot Andrew gent 587546 587546 Somercot, Andrew, of Halton, gent 0
4297763 2129307 2129307 defendant Somercot Christopher gent 587546 587546 Somercot, Christopher, of Halton, gent 0
4351630 2147813 2147813 defendant Talbot John gent 587546 587546 Talbot, John, of Halton, gent 0
4358454 2150190 2150190 defendant Learie John laborer 587546 587546 Learie, John, of Halton, laborer 2
4358458 2150191 2150191 defendant Leare John laborer 587546 587546 Leare, John, of Halton, laborer 2
4368022 2153615 2153615 defendant Lewes John   587546 587546 Lewes, John, of Halton, coverlet weaver 1
4369128 2154025 2154025 defendant Watson Francis clerk 587546 587546 Watson, Francis, of Halton, clerk 0
4369129 2154025 2154025 defendant Thory Thomas yeoman 587546 587546 Thory, Thomas, of Halton, yeoman 1
4391188 2161670 2161670 defendant Talbott John gent 587546 587546 Talbott, John, of Halton, gent 0
4393012 2162274 2162274 defendant Talbott John gent 587546 587546 Talbott, John, of Halton, gent 0
4397714 2163813 2163813 defendant Nichols Charles husbandman 587546 587546 Nichols, Charles, of Halton, husbandman 0
4407927 2167215 2167215 defendant Clarke Thomas yeoman 587546 587546 Clarke, Thomas, of Halton, yeoman 0
4415307 2169684 2169684 defendant Wildera Walter   587546 587546 Wildera, Walter, of Halton 0
4423106 2172083 2172083 defendant Colle Richard   587546 587546 Colle, Richard, of Halton on Humber 1
4423107 2172083 2172083 defendant Shirreff Nigel   587546 587546 Shirreff, Nigel, of Halton upon Humber, son of Geoffrey 2
4438484 2181325 2181325 plaintiff Askeby John de   587546 587546 Askeby, John de, of Halton, parson 0
4439808 2181728 2181728 defendant Cok or Cokes John   587546 587546 Cok or Cokes, John, of Halton 0
4444866 2183369 2183369 plaintiff Cook Thomas   587546 587546 Cook, Thomas, of Halton 0
4449916 2184930 2184930 defendant Burdon Thoams   587546 587546 Burdon, Thoams, of Halton 0
4449922 2184931 2184931 defendant Burdon Thomas   587546 587546 Burdon, Thomas, of Halton 0
4467380 2190477 2190477 defendant Gentilman Robert   587546 587546 Gentilman, Robert, of Halton 1
4469709 2191196 2191196 plaintiff Botheley William de   587546 587546 Botheley, William de, of Halton 0
4472840 2192180 2192180 defendant Matheu Henry   587546 587546 Matheu, Henry, of Halton 1
4476903 2193434 2193434 defendant Wryght John   587546 587546 Wryght, John, of Halton 0
4476904 2193434 2193434 defendant Ousthorp Richard   587546 587546 Ousthorp, Richard, of Halton 1
4476905 2193434 2193434 defendant Gibson John glasier 587546 587546 Gibson, John, of Halton, glasier 2
4476906 2193434 2193434 defendant Neuton John   587546 587546 Neuton, John, of Halton 3
4486999 2196654 2196654 plaintiff Seymor William   587546 587546 Seymor, William, of Halton 0
4494999 2199125 2199125 defendant Goldesburgh Thomas de   587546 587546 Goldesburgh, Thomas de, of Halton 0
4495000 2199125 2199125 defendant Benet Richard   587546 587546 Benet, Richard, of Halton 1

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