names

94 rows where place_id = 596060

✎ 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
3622954 1874708 1874708 defendant Smyth William barker 596060 596060 Smyth, William, of Stradbroke, barker 0
3644455 1908683 1908683 defendant Hervy Robert yeoman 596060 596060 Hervy, Robert, of Stradbroke, yeoman 0
3646092 1909177 1909177 defendant Bocher Agnes widow 596060 596060 Bocher, Agnes, of Stradbroke, widow 0
3646093 1909177 1909177 defendant Rykkys William husbandman 596060 596060 Rykkys, William, of Stradbroke, husbandman 1
3674242 1917985 1917985 defendant Barbour John cooper 596060 596060 Barbour, John, of Stradbroke, cooper 0
3674244 1917986 1917986 defendant Baron Robert tailor 596060 596060 Baron, Robert, of Stradbroke, tailor 0
3675292 1918312 1918312 defendant Rykkys William husbandman 596060 596060 Rykkys, William, of Stradbroke, husbandman 0
3684874 1921405 1921405 defendant Rycheman John tailor 596060 596060 Rycheman, John, of Stradbroke, tailor 3
3688354 1922514 1922514 defendant Bocher Robert clothmaker 596060 596060 Bocher, Robert, of Stradbroke, clothmaker 0
3715143 1931031 1931031 defendant Lannam Robert laborer 596060 596060 Lannam, Robert, of Stradbroke, laborer 1
3728879 1935281 1935281 defendant Wellys John carpenter 596060 596060 Wellys, John, of Stradbroke, carpenter 0
3728880 1935281 1935281 defendant Pulham John carpenter 596060 596060 Pulham, John, of Stradbroke, carpenter 1
3730646 1935819 1935819 defendant Lamman Robert laborer 596060 596060 Lamman, Robert, of Stradbroke, laborer 1
3763568 1946240 1946240 plaintiff Harvy Robert   596060 596060 Harvy, Robert, of Stradbroke 0
3763569 1946240 1946240 plaintiff Seman William   596060 596060 Seman, William, of Stradbroke 1
3772668 1949144 1949144 defendant Alldowse Robert tanner 596060 596060 Alldowse, Robert, of Stradbroke, tanner 0
3789830 1954648 1954648 defendant Gurney William husbandman 596060 596060 Gurney, William, of Stradbroke, husbandman 0
3799142 1957641 1957641 defendant Albryght Peter husbandman 596060 596060 Albryght, Peter, of Stradbroke, husbandman 0
3832076 1967936 1967936 plaintiff Hervy Robert   596060 596060 Hervy, Robert, of Stradbroke 0
3834656 1968773 1968773 defendant Calver Robert husbandman 596060 596060 Calver, Robert, of Stradbroke, husbandman 2
3862935 1977799 1977799 defendant Barbour Giles husbandman 596060 596060 Barbour, Giles, of Stradbroke, husbandman 0
3888858 1986523 1986523 defendant Fyrmage James yeoman 596060 596060 Fyrmage, James, of Stradbroke, yeoman 0
3888859 1986523 1986523 defendant Aldhous Robert tanner 596060 596060 Aldhous, Robert, of Stradbroke, tanner 1
3894307 1988314 1988314 defendant Fox William husbandman 596060 596060 Fox, William, of Stradbroke, husbandman 2
3895279 1988629 1988629 defendant Richeman William yeoman 596060 596060 Richeman, William, of Stradbroke, yeoman 0
3902870 1991194 1991194 defendant Fyrmage James yeoman 596060 596060 Fyrmage, James, of Stradbroke, yeoman 0
3902871 1991194 1991194 defendant Aldhous Robert tanner 596060 596060 Aldhous, Robert, of Stradbroke, tanner 1
3917449 1996194 1996194 defendant Aldhous Robert tanner 596060 596060 Aldhous, Robert, of Stradbroke, tanner 0
3928320 1999807 1999807 plaintiff Bert William   596060 596060 Bert, William, of Stradbroke 0
3939839 2003624 2003624 defendant Asly Hugh sheerman 596060 596060 Asly, Hugh, of Stradbroke, sheerman 0
3941713 2004244 2004244 defendant Maryet Geoffrey yeoman 596060 596060 Maryet, Geoffrey, of Stradbroke, yeoman 0
3948343 2006482 2006482 defendant Foxe William, junior yeoman 596060 596060 Foxe, William, junior, of Stradbroke, yeoman 0
3954085 2008501 2008501 defendant Aldowes Robert yeoman 596060 596060 Aldowes, Robert, of Stradbroke, yeoman 0
3954087 2008502 2008502 defendant Aldows Robert yeoman 596060 596060 Aldows, Robert, of Stradbroke, yeoman 0
3961165 2010998 2010998 defendant Maryett Geoffrey tailor 596060 596060 Maryett, Geoffrey, of Stradbroke, tailor 0
3968181 2013497 2013497 defendant Gyrlyng Thomas yeoman 596060 596060 Gyrlyng, Thomas, of Stradbroke, yeoman 0
3972743 2015038 2015038 defendant Maryett Geoffrey yeoman 596060 596060 Maryett, Geoffrey, of Stradbroke, yeoman 0
3973078 2015154 2015154 defendant Baldry John husbandman 596060 596060 Baldry, John, of Stradbroke, husbandman 1
3973406 2015269 2015269 defendant Flatman John yeoman 596060 596060 Flatman, John, of Stradbroke, yeoman 0
3973408 2015270 2015270 defendant Flatman John yeoman 596060 596060 Flatman, John, of Stradbroke, yeoman 0
3990913 2021512 2021512 defendant Baldry John husbandman 596060 596060 Baldry, John, of Stradbroke, husbandman 2
3990914 2021512 2021512 defendant Branche William husbandman 596060 596060 Branche, William, of Stradbroke, husbandman 3
4033754 2036724 2036724 defendant Brocke Nicholas yeoman 596060 596060 Brocke, Nicholas, of Stradbroke, yeoman 1
4047852 2041680 2041680 defendant Calvar Lawrence weaver 596060 596060 Calvar, Lawrence, of Stradbroke, weaver 0
4048810 2042022 2042022 defendant Borret Henry yeoman 596060 596060 Borret, Henry, of Stradbroke, or of Allenton, Suff, yeoman 1
4085443 2055069 2055069 defendant Aldons or Aldous John yeoman 596060 596060 Aldons or Aldous, John, of Stradbroke, yeoman 0
4085445 2055070 2055070 defendant Fysher William yeoman 596060 596060 Fysher, William, of Stradbroke, yeoman 0
4115516 2065836 2065836 defendant Girlyng Thomas grocer 596060 596060 Girlyng, Thomas, of Stradbroke, or of Harlston, Norf, grocer 1
4121399 2067947 2067947 defendant Aldous or Aldons John yeoman 596060 596060 Aldous or Aldons, John, of Stradbroke, yeoman 0
4141879 2075327 2075327 defendant Wittham Henry husbandman 596060 596060 Wittham, Henry, of Stradbroke, husbandman 0
4147932 2077410 2077410 defendant Bert Henry yeoman 596060 596060 Bert, Henry, of Stradbroke, yeoman 0
4162324 2082382 2082382 defendant Burman John yeoman 596060 596060 Burman, John, of Stradbroke, yeoman 0
4174408 2086516 2086516 defendant Bert William yeoman 596060 596060 Bert, William, of Stradbroke, yeoman 0
4176904 2087393 2087393 defendant Aldus John gent 596060 596060 Aldus, John, of Stradbroke, gent 0
4187228 2091025 2091025 defendant Grinlinge Richard yeoman 596060 596060 Grinlinge, Richard, of Stradbroke, yeoman 1
4197735 2094765 2094765 defendant Beart William yeoman 596060 596060 Beart, William, of Stradbroke, yeoman 0
4199315 2095315 2095315 defendant Baldrye John husbandman 596060 596060 Baldrye, John, of Stradbroke, husbandman 1
4217057 2101460 2101460 defendant Pulham Thomas, senior yeoman 596060 596060 Pulham, Thomas, senior, of Stradbroke, yeoman 0
4217058 2101460 2101460 defendant Pulham Thomas, junior yeoman 596060 596060 Pulham, Thomas, junior, of Stradbroke, yeoman 1
4274923 2121180 2121180 defendant Bert William yeoman 596060 596060 Bert, William, of Stradbroke, yeoman 2
4286498 2125212 2125212 defendant Gowen Robert husbandman 596060 596060 Gowen, Robert, of Stradbroke, husbandman 0
4309390 2133443 2133443 defendant Kent Thomas gent 596060 596060 Kent, Thomas, of Stradbroke, gent 0
4398353 2164030 2164030 defendant Aldous Robert, senior yeoman 596060 596060 Aldous, Robert, senior, of Stradbroke, yeoman 1
4410573 2168126 2168126 defendant Bourman John, senior yeoman 596060 596060 Bourman, John, senior, of Stradbroke, yeoman 2
4411392 2168400 2168400 defendant Foster Thomas yeoman 596060 596060 Foster, Thomas, of Stradbroke, yeoman 3
4604207 2232486 2232486 defendant Doube Thomas   596060 596060 Doube, Thomas, of Stradbroke 0
4842336 2309135 2309135 defendant Fygge John husbandman 596060 596060 Fygge, John, of Stradbroke, husbandman 0
4847456 2310705 2310705 defendant Fygge John yeoman 596060 596060 Fygge, John, of Stradbroke, yeoman 5
4934591 2337211 2337211 defendant Furmage alias Punt John butcher 596060 596060 Furmage alias Punt, John, of Stradbroke, butcher 0
4950005 2341972 2341972 defendant Hervy Thomas yeoman 596060 596060 Hervy, Thomas, of Stradbroke, yeoman 2
5091490 2383902 2383902 plaintiff Neve or Neue John (legal representative) 596060 596060 Neve or Neue, John, of Stradbroke, executors of 0
5137424 2397460 2397460 defendant Furmage John husbandman 596060 596060 Furmage, John, of Stradbroke, husbandman 0
5158077 2403485 2403485 defendant Firmage John, sen husbandman 596060 596060 Firmage, John, sen, of Stradbroke, husbandman 0
5158081 2403486 2403486 defendant Furmage John, sen husbandman 596060 596060 Furmage, John, sen, of Stradbroke, husbandman 0
5167891 2406320 2406320 defendant Payne John laborer 596060 596060 Payne, John, of Stradbroke, laborer 3
5173783 2408028 2408028 defendant Furmage John, sen husbandman 596060 596060 Furmage, John, sen, of Stradbroke, husbandman 0
5183573 2410931 2410931 defendant Payne John laborer 596060 596060 Payne, John, of Stradbroke, laborer 3
5183578 2410932 2410932 defendant Payne John laborer 596060 596060 Payne, John, of Stradbroke, laborer 3
5183583 2410933 2410933 defendant Payne John laborer 596060 596060 Payne, John, of Stradbroke, laborer 3
5203921 2416898 2416898 defendant Payne John laborer 596060 596060 Payne, John, of Stradbroke, laborer 3
5227918 2423780 2423780 defendant Hervy Thomas butcher 596060 596060 Hervy, Thomas, of Stradbroke, butcher 1
5288894 2441758 2441758 defendant Debenham Stephen yeoman 596060 596060 (Debenham, Stephen, of Stradbroke, yeoman 1
5288895 2441758 2441758 defendant Sayer John chapman 596060 596060 Sayer, John, of of Stradbroke, chapman 2
5327492 2453291 2453291 defendant Dowe Roger (legal representative) 596060 596060 Dowe, Roger, of Stradbroke, gent, executor of 0
5327493 2453291 2453291 defendant Dowe Robert gent 596060 596060 Dowe, Robert, of Stradbroke, gent 1
5506926 2507081 2507081 defendant Walter Peter husbandman 596060 596060 Walter, Peter, of Stradbroke, husbandman 0
5520123 2511118 2511118 defendant Firmage Robert yeoman 596060 596060 Firmage, Robert, of Stradbroke, yeoman 0
5520625 2511274 2511274 defendant Braunche Robert yeoman 596060 596060 Braunche, Robert, of Stradbroke, yeoman 1
5520628 2511274 2511274 defendant Clerk Robert husbandman 596060 596060 Clerk, Robert, of Stradbroke, husbandman 4
5566686 2524852 2524852 defendant Pulham Thomas husbandman 596060 596060 Pulham, Thomas, of Stradbroke, husbandman 1
5568247 2525255 2525255 defendant Gyrlyng Thomas yeoman 596060 596060 Gyrlyng, Thomas, of Stradbroke, yeoman 2
5569412 2525615 2525615 plaintiff Gyrlyng Thomas   596060 596060 Gyrlyng, Thomas, of Stradbroke 0
5580488 2528985 2528985 plaintiff Barowye Edmund   596060 596060 Barowye, Edmund, of Stradbroke 1
5628456 2552869 2552869 defendant Douve Thomas yeoman 596060 596060 Douve, Thomas, of Stradbroke, yeoman 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);