names

148 rows where place_id = 596461

✎ 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
3624872 1875313 1875313 defendant Haukys or Hankys Henry butcher 596461 596461 Haukys or Hankys, Henry, of Burston, butcher 1
3643324 1908337 1908337 defendant Poddyng William husbandman 596461 596461 Poddyng, William, of Burston, husbandman 0
3643325 1908337 1908337 defendant Thyrlby John husbandman 596461 596461 Thyrlby, John, of Burston, husbandman 1
3724934 1934087 1934087 defendant Botyld Thomas   596461 596461 Botyld, Thomas, of Burston 0
3740898 1939012 1939012 defendant Hawton John butcher 596461 596461 Hawton, John, of Burston, butcher 1
3772530 1949098 1949098 defendant Nekleyn Ralph husbandman 596461 596461 Nekleyn, Ralph, of Burston, husbandman 3
3783121 1952477 1952477 defendant Boke William laborer 596461 596461 Boke, William, of Burston, laborer 2
3830255 1967356 1967356 defendant Newman John husbandman 596461 596461 Newman, John, of Burston, husbandman 0
3857727 1976053 1976053 defendant Broke William yeoman 596461 596461 Broke, William, of Burston, yeoman 0
3885315 1985342 1985342 defendant Smalwode William weaver 596461 596461 Smalwode, William, of Burston, weaver 0
3885317 1985343 1985343 defendant Smalwode William weaver 596461 596461 Smalwode, William, of Burston, weaver 0
3888083 1986269 1986269 defendant Remyngton Anthony yeoman 596461 596461 Remyngton, Anthony, of Burston, yeoman 1
3899688 1990111 1990111 defendant Strayton William husbandman 596461 596461 Strayton, William, of Burston, husbandman 0
3954419 2008615 2008615 defendant Smyth John husbandman 596461 596461 Smyth, John, of Burston, husbandman 0
3954420 2008615 2008615 defendant Nabbys Nicholas husbandman 596461 596461 Nabbys, Nicholas, of Burston, husbandman 1
3954421 2008615 2008615 defendant Shakkyll Nicholas butcher 596461 596461 Shakkyll, Nicholas, of Burston, butcher 2
3967148 2013136 2013136 defendant Starlyng Clement husbandman 596461 596461 Starlyng, Clement, of Burston, husbandman 0
3967149 2013136 2013136 defendant Burwell William husbandman 596461 596461 Burwell, William, of Burston, husbandman 1
3972016 2014771 2014771 defendant Hylton Thomas tailor 596461 596461 Hylton, Thomas, of Burston, tailor 0
4013914 2029708 2029708 defendant Dewyn John butcher 596461 596461 Dewyn, John, of Burston, butcher 0
4019646 2031754 2031754 plaintiff Webster William   596461 596461 Webster, William, of Burston, or of Whinbergh 0
4021090 2032265 2032265 defendant Fulcher Robert weaver 596461 596461 Fulcher, Robert, of Burston, weaver 1
4024652 2033495 2033495 defendant Fulcher Robert husbandman 596461 596461 Fulcher, Robert, of Burston, husbandman 0
4024654 2033495 2033495 defendant Cobbe John husbandman 596461 596461 Cobbe, John, of Burston, husbandman 2
4059832 2045910 2045910 defendant Swanne Anthony husbandman 596461 596461 Swanne, Anthony, of Burston, husbandman 1
4062873 2047022 2047022 defendant Smalwood John husbandman 596461 596461 Smalwood, John, of Burston, husbandman 0
4062875 2047022 2047022 defendant Swan Anthony husbandman 596461 596461 Swan, Anthony, of Burston, husbandman 2
4079114 2052831 2052831 defendant Rasye John laborer 596461 596461 Rasye, John, of Burston, laborer 0
4079115 2052831 2052831 defendant Wright Thomas laborer 596461 596461 Wright, Thomas, of Burston, laborer 1
4079116 2052831 2052831 defendant Benke William laborer 596461 596461 Benke, William, of Burston, laborer 2
4112364 2064680 2064680 defendant Fretsham John yeoman 596461 596461 Fretsham, John, of Burston, yeoman 1
4139575 2074516 2074516 defendant Flowerdewe Stephen yeoman 596461 596461 Flowerdewe, Stephen, of Burston, yeoman 0
4149366 2077903 2077903 defendant Johnson John yeoman 596461 596461 Johnson, John, of Burston, yeoman 0
4150186 2078200 2078200 defendant Johnson John yeoman 596461 596461 Johnson, John, of Burston, yeoman 0
4158208 2080940 2080940 defendant Dewyn John butcher 596461 596461 Dewyn, John, of Burston, butcher 1
4158388 2081005 2081005 defendant Cobb Henry husbandman 596461 596461 Cobb, Henry, of Burston, husbandman 2
4174163 2086418 2086418 defendant Warner John carpenter 596461 596461 Warner, John, of Burston, carpenter 2
4178531 2087967 2087967 defendant Starlinge Clement husbandman 596461 596461 Starlinge, Clement, of Burston, husbandman 0
4194607 2093671 2093671 defendant Bassett John husbandman 596461 596461 Bassett, John, of Burston, husbandman 2
4198664 2095087 2095087 defendant Bannester John husbandman 596461 596461 Bannester, John, of Burston, husbandman 3
4207365 2098129 2098129 defendant Bassett John yeoman 596461 596461 Bassett, John, of Burston, yeoman 0
4210916 2099376 2099376 defendant Hilton John clerk 596461 596461 Hilton, John, of Burston, clerk 2
4223581 2103735 2103735 defendant Gostlinge John yeoman 596461 596461 Gostlinge, John, of Burston, yeoman 2
4224496 2104050 2104050 defendant Garrett John   596461 596461 Garrett, John, of Burston, ploughwright 0
4226029 2104574 2104574 defendant Browne James husbandman 596461 596461 Browne, James, of Burston, husbandman 0
4229988 2105975 2105975 defendant Baylye William husbandman 596461 596461 Baylye, William, of Burston, husbandman 1
4240292 2109728 2109728 defendant Bolton Edward gent 596461 596461 Bolton, Edward, of Burston, gent 0
4241461 2110128 2110128 defendant Jamys Cuthbert husbandman 596461 596461 Jamys, Cuthbert, of Burston, husbandman 0
4241463 2110129 2110129 defendant Jamys Cuthbert husbandman 596461 596461 Jamys, Cuthbert, of Burston, husbandman 0
4243787 2110902 2110902 defendant Hilton John (legal representative) 596461 596461 Hilton, John, of Burston, clerk, executor of 0
4247047 2111987 2111987 defendant Johnson John gent 596461 596461 Johnson, John, of Burston, gent 0
4250294 2113079 2113079 defendant Cobbe Thomas yeoman 596461 596461 Cobbe, Thomas, of Burston, yeoman 1
4250295 2113079 2113079 defendant Cobbe John yeoman 596461 596461 Cobbe, John, of Burston, yeoman 2
4250765 2113232 2113232 defendant Jamys Cuthbert husbandman 596461 596461 Jamys, Cuthbert, of Burston, husbandman 0
4253191 2114062 2114062 defendant Browne James husbandman 596461 596461 Browne, James, of Burston, husbandman 0
4258397 2115776 2115776 defendant Dewen John   596461 596461 Dewen, John, of Burston 0
4260116 2116348 2116348 defendant Mendham John yeoman 596461 596461 Mendham, John, of Burston, yeoman 0
4274060 2120872 2120872 defendant Fulcher Edmund weaver 596461 596461 Fulcher, Edmund, of Burston, weaver 1
4274424 2121001 2121001 defendant Grene Richard yeoman 596461 596461 Grene, Richard, of Burston, yeoman 0
4276086 2121584 2121584 defendant Cobb Thomas gent 596461 596461 Cobb, Thomas, of Burston, gent 1
4276505 2121723 2121723 defendant Fulcher Edmund singleman 596461 596461 Fulcher, Edmund, of Burston, yeoman, singleman 1
4277129 2121934 2121934 defendant Gostlinge John yeoman 596461 596461 Gostlinge, John, of Burston, yeoman 1
4277413 2122021 2122021 defendant Bolton Francis gent 596461 596461 Bolton, Francis, of Burston, gent 2
4283938 2124296 2124296 defendant Buttell Walter yeoman 596461 596461 Buttell, Walter, of Burston, yeoman 1
4283939 2124296 2124296 defendant Awger or Ager Nicholas yeoman 596461 596461 Awger or Ager, Nicholas, of Burston, yeoman 2
4284576 2124533 2124533 defendant Humfreye Thomas yeoman 596461 596461 Humfreye, Thomas, of Burston, yeoman 0
4286605 2125257 2125257 defendant Humfrey Thomas yeoman 596461 596461 Humfrey, Thomas, of Burston, yeoman 0
4286606 2125257 2125257 defendant Ryvett John husbandman 596461 596461 Ryvett, John, of Burston, husbandman 1
4289252 2126213 2126213 defendant Algar Nicholas potter 596461 596461 Algar, Nicholas, of Burston, potter 1
4289253 2126213 2126213 defendant Buttell Walter yeoman 596461 596461 Buttell, Walter, of Burston, yeoman 2
4290208 2126566 2126566 defendant Alpe Edward yeoman 596461 596461 Alpe, Edward, of Burston, yeoman 0
4309994 2133653 2133653 defendant Buttyld Walter yeoman 596461 596461 Buttyld, Walter, of Burston, yeoman 2
4323596 2138308 2138308 defendant Fulcher Robert yeoman 596461 596461 Fulcher, Robert, of Burston, yeoman 1
4323598 2138308 2138308 defendant Fulcher Agnes spinster 596461 596461 Fulcher, Agnes, of Burston, spinster 3
4326990 2139358 2139358 defendant Buttell Walter husbandman 596461 596461 Buttell, Walter, of Burston, husbandman 3
4333519 2141491 2141491 defendant Belton Francis gent 596461 596461 Belton, Francis, of Burston, or of Northwold, Norf, gent 0
4335140 2142024 2142024 defendant Buttell Thomas husbandman 596461 596461 Buttell, Thomas, of Burston, husbandman 0
4335141 2142024 2142024 defendant Awger Nicholas potter 596461 596461 together wigh Awger, Nicholas, of Burston, potter 1
4335497 2142146 2142146 defendant Mony Katherine widow 596461 596461 Mony, Katherine, of Burston, widow 0
4342301 2144585 2144585 defendant Underwood William husbandman 596461 596461 Underwood, William, of Burston, husbandman 1
4354854 2148919 2148919 defendant Cobb Thomas yeoman 596461 596461 Cobb, Thomas, of Burston, yeoman 1
4373862 2155719 2155719 defendant Ollyett William clerk 596461 596461 Ollyett, William, of Burston, clerk 0
4384846 2159621 2159621 defendant Cobbe Thomas yeoman 596461 596461 Cobbe, Thomas, of Burston, yeoman 0
4384847 2159621 2159621 defendant Cobbe John yeoman 596461 596461 Cobbe, John, of Burston, yeoman 1
4387064 2160329 2160329 defendant Bolton Edward gent 596461 596461 Bolton, Edward, of Burston, gent 0
4388739 2160867 2160867 defendant Bolton Edward gent 596461 596461 Bolton, Edward, of Burston, gent 0
4388740 2160867 2160867 defendant Welles Isaiah yeoman 596461 596461 Welles, Isaiah, of Burston, yeoman 1
4388741 2160867 2160867 defendant Carsye William husbandman 596461 596461 Carsye, William, of Burston, husbandman 2
4390222 2161352 2161352 defendant Cobbe Henry yeoman 596461 596461 Cobbe, Henry, of Burston, yeoman 1
4393026 2162278 2162278 defendant Bolton Edward gent 596461 596461 Bolton, Edward, of Burston, gent 0
4406193 2166637 2166637 defendant Cole Cesar chapman 596461 596461 Cole, Cesar, of Burston, chapman 0
4406225 2166647 2166647 defendant Cole Cesar chapman 596461 596461 Cole, Cesar, of Burston, chapman 0
4407416 2167042 2167042 defendant Alpe Edward yeoman 596461 596461 Alpe, Edward, of Burston, yeoman 0
4442801 2182706 2182706 defendant Mast Robert   596461 596461 Mast, Robert, of Burston, vicar 0
4454926 2186554 2186554 plaintiff Mast Robert   596461 596461 Mast, Robert, of Burston, vicar, on his own account 0
4454930 2186554 2186554 defendant Taillour Thomas   596461 596461 Taillour, Thomas, of Burston 3
4469431 2191101 2191101 defendant Speed Thomas   596461 596461 Speed, Thomas, of Burston 1
4474378 2192640 2192640 plaintiff Dig or Dix John   596461 596461 Dig or Dix, John, of Burston 0
4476072 2193186 2193186 defendant Helyere John   596461 596461 Helyere, John, of burston 1
4635725 2242017 2242017 defendant Cok Richard   596461 596461 Cok, Richard, of Burston 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);