names

106 rows where place_id = 590301

✎ 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
3600560 1867821 1867821 defendant Drover David husbandman 590301 590301 Drover, David, of Hoxon, husbandman 1
3601635 1868167 1868167 defendant Everard Robert yeoman 590301 590301 Everard, Robert, of Hoxon, yeoman 1
3607240 1869929 1869929 defendant Paye Robert gent 590301 590301 Paye, Robert, of Hoxon, gent 2
3611754 1871340 1871340 defendant Cave John husbandman 590301 590301 Cave, John, of Hoxon, husbandman 0
3628270 1903704 1903704 plaintiff Cade John (legal representative) 590301 590301 Cade, John, of Hoxon, executor of 0
3642212 1908012 1908012 plaintiff Cade John (legal representative) 590301 590301 Cade, John, of Hoxon, executor of 0
3645004 1908845 1908845 defendant Cade John (legal representative) 590301 590301 Cade, John, of Hoxon, husbandman, executor of 0
3645005 1908845 1908845 defendant Hatclyff Nicholas husbandman 590301 590301 Hatclyff, Nicholas, of Hoxon, husbandman 1
3650223 1910439 1910439 defendant Tentwell Edmund mercer 590301 590301 Tentwell, Edmund, of Hoxon, mercer 0
3650555 1910540 1910540 defendant Gyslyngham Richard husbandman 590301 590301 Gyslyngham, Richard, of Hoxon, husbandman 4
3680767 1920066 1920066 defendant Waren William husbandman 590301 590301 Waren, William, of Hoxon, husbandman 0
3697150 1925330 1925330 defendant Hore John draper 590301 590301 Hore, John, of Hoxon, draper 0
3704938 1927836 1927836 defendant Salter Roger yeoman 590301 590301 (Salter, Roger, of Hoxon, yeoman 1
3707289 1928569 1928569 defendant Gyslyngham Richard husbandman 590301 590301 Gyslyngham, Richard, of Hoxon, husbandman 3
3708377 1928915 1928915 plaintiff Newton William clerk 590301 590301 Newton, William, of Hoxon, clerk 0
3708378 1928915 1928915 plaintiff Cantrell Ralph   590301 590301 Cantrell, Ralph, of Hoxon, notary public 1
3708380 1928916 1928916 plaintiff Newton William clerk 590301 590301 Newton, William, of Hoxon, clerk 0
3708381 1928916 1928916 plaintiff Cantrell Ralph   590301 590301 Cantrell, Ralph, of Hoxon, notary public 1
3708517 1928960 1928960 plaintiff Thurston John yeoman 590301 590301 Thurston, John, of Hoxon, yeoman 1
3709549 1929294 1929294 defendant Lacy Stephen (legal representative) 590301 590301 Lacy, Stephen, of Hoxon, yeoman, executors of 1
3709550 1929294 1929294 defendant Lacy Richard alias John yeoman 590301 590301 (Lacy, Richard alias John, of Hoxon, yeoman 2
3709554 1929295 1929295 defendant Lacy Richard yeoman 590301 590301 (Lacy, Richard, of Hoxon, yeoman 2
3709555 1929295 1929295 defendant Lacy Rose widow 590301 590301 Lacy, Rose, of Hoxon, widow 3
3710618 1929643 1929643 plaintiff Smyth Margaret widow 590301 590301 Smyth, Margaret, of Hoxon, widow 0
3711564 1929928 1929928 plaintiff Thurston Edmund (legal representative) 590301 590301 Thurston, Edmund, of Hoxon, executor of 0
3734687 1937097 1937097 plaintiff Gowyr Robert   590301 590301 Gowyr, Robert, of Hoxon 0
3740053 1938744 1938744 defendant Lacy Stephen (legal representative) 590301 590301 Lacy, Stephen, of Hoxon, yeoman, executors of 1
3740054 1938744 1938744 defendant Lacy Rose widow 590301 590301 (Lacy, Rose, of Hoxon, widow 2
3740055 1938744 1938744 defendant Lacy Richard yeoman 590301 590301 Lacy, Richard, of Hoxon, yeoman 3
3740057 1938745 1938745 defendant Lacy Stephen (legal representative) 590301 590301 Lacy, Stephen, of Hoxon, yeoman, executors of 0
3740058 1938745 1938745 defendant Race Rose widow 590301 590301 (Race, Rose, of Hoxon, widow 1
3740059 1938745 1938745 defendant Lacy Richard yeoman 590301 590301 Lacy, Richard, of Hoxon, yeoman 2
3741061 1939066 1939066 defendant Bocher John tailor 590301 590301 Bocher, John, of Hoxon, tailor 0
3741062 1939066 1939066 defendant Mundeforth John mercer 590301 590301 Mundeforth, John, of Hoxon, mercer 1
3753424 1943009 1943009 defendant Tynwell Edward mercer 590301 590301 Tynwell, Edward, of Hoxon, mercer 4
3787179 1953781 1953781 defendant Munford John mercer 590301 590301 Munford, John, of Hoxon, mercer 1
3787207 1953791 1953791 plaintiff Remchyng John yeoman 590301 590301 Remchyng, John, of Hoxon, yeoman 0
3789726 1954617 1954617 defendant Heyward John husbandman 590301 590301 Heyward, John, of Hoxon, husbandman 0
3789727 1954617 1954617 defendant Seman Simon husbandman 590301 590301 Seman, Simon, of Hoxon, husbandman 1
3793580 1955854 1955854 defendant Fleccher John laborer 590301 590301 Fleccher, John, of Hoxon, laborer 1
3818639 1963733 1963733 defendant Mallyng John butcher 590301 590301 Mallyng, John, of Hoxon, butcher 0
3837290 1969570 1969570 defendant Lassy Thomas carpenter 590301 590301 Lassy, Thomas, of Hoxon, carpenter 0
3919496 1996852 1996852 plaintiff Lawter Richard cooper 590301 590301 Lawter, Richard, of Hoxon, cooper 0
3922252 1997754 1997754 plaintiff Remchyng John gent 590301 590301 Remchyng, John, of Hoxon, gent 0
3931412 2000803 2000803 defendant Gosselyn Richard husbandman 590301 590301 Gosselyn, Richard, of Hoxon, husbandman 0
3954045 2008485 2008485 defendant Gyslyngham George tailor 590301 590301 Gyslyngham, George, of Hoxon, tailor 1
3958560 2010064 2010064 defendant Everard Nicholas gent 590301 590301 Everard, Nicholas, of Hoxon, gent 0
3982585 2018543 2018543 defendant Sherwood John yeoman 590301 590301 Sherwood, John, of Hoxon, yeoman 5
3984897 2019355 2019355 defendant Sherewood John, senior yeoman 590301 590301 Sherewood, John, senior, of Hoxon, yeoman 1
4019135 2031583 2031583 defendant Bowyn Felix haberdasher 590301 590301 Bowyn, Felix, of Hoxon, haberdasher 2
4044340 2040430 2040430 defendant Sherwood John yeoman 590301 590301 Sherwood, John, of Hoxon, yeoman 0
4044341 2040430 2040430 defendant Sadd Ralph (legal representative) 590301 590301 Sadd, Ralph, of Hoxon, yeoman, executors of 1
4044342 2040430 2040430 defendant Grene James yeoman 590301 590301 (Grene, James, of Hoxon, yeoman 2
4044344 2040431 2040431 defendant Sherwood John yeoman 590301 590301 Sherwood, John, of Hoxon, yeoman 0
4044345 2040431 2040431 defendant Sadd Ralph (legal representative) 590301 590301 Sadd, Ralph, of Hoxon, yeoman, executors of 1
4044346 2040431 2040431 defendant Grene James yeoman 590301 590301 (Grene, James, of Hoxon, yeoman 2
4064292 2047505 2047505 defendant Kynge John skepmaker or shipmaker 590301 590301 Kynge, John, of Hoxon, skepmaker or shipmaker 1
4214624 2100621 2100621 defendant Garnam Robert carpenter 590301 590301 Garnam, Robert, of Hoxon, carpenter 1
4233839 2107362 2107362 defendant Reade John yeoman 590301 590301 Reade, John, of Hoxon, yeoman 1
4240074 2109653 2109653 defendant Smyth Robert yeoman 590301 590301 Smyth, Robert, of Hoxon, yeoman 0
4241054 2109992 2109992 defendant Kewe John tanner 590301 590301 Kewe, John, of Hoxon, tanner 0
4245003 2111311 2111311 defendant Knyght John husbandman 590301 590301 Knyght, John, of Hoxon, husbandman 0
4246679 2111867 2111867 defendant Wright Richard yeoman 590301 590301 Wright, Richard, of Hoxon, yeoman 0
4277428 2122026 2122026 defendant Seale Reginald yeoman 590301 590301 Seale, Reginald, of Hoxon, yeoman 2
4279542 2122763 2122763 defendant Tylor John husbandman 590301 590301 Tylor, John, of Hoxon, husbandman 0
4301931 2130800 2130800 defendant Bytteringe William gent 590301 590301 Bytteringe, William, of Hoxon, gent 0
4302756 2131082 2131082 defendant Smyth alias Garrard William cordwainer 590301 590301 Smyth alias Garrard, William, of Hoxon, cordwainer 2
4308741 2133209 2133209 defendant Eme John tanner 590301 590301 Eme, John, of Hoxon, tanner 0
4332711 2141225 2141225 defendant Cotton George limeburner 590301 590301 Cotton, George, of Hoxon, limeburner 0
4342458 2144634 2144634 defendant Gooche John beer brewer 590301 590301 Gooche, John, of Hoxon, beer brewer 0
4342833 2144767 2144767 defendant Bendall Thomas yeoman 590301 590301 Bendall, Thomas, of Hoxon, yeoman 0
4344488 2145352 2145352 defendant Packe Bartholomew husbandman 590301 590301 Packe, Bartholomew, of Hoxon, husbandman 0
4357551 2149872 2149872 defendant Driver James drover 590301 590301 Driver, James, of Hoxon, drover 0
4357553 2149872 2149872 defendant Colman Walter yeoman 590301 590301 together with Colman, Walter, of Hoxon, yeoman 2
4357554 2149872 2149872 defendant Bryant William miller 590301 590301 Bryant, William, of Hoxon, miller 3
4387981 2160608 2160608 defendant Snease William yeoman 590301 590301 Snease, William, of Hoxon, yeoman 0
4387982 2160608 2160608 defendant Gislingham Nicholas gent 590301 590301 Gislingham, Nicholas, of Hoxon, gent 1
4407616 2167113 2167113 defendant Geame Geoffrey husbandman 590301 590301 Geame, Geoffrey, of Hoxon, husbandman 2
4599074 2230925 2230925 plaintiff Stebbyng Thomas   590301 590301 Stebbyng, Thomas, of Hoxon, vicar 0
4654279 2247217 2247217 defendant Irtesue Robert skinner 590301 590301 Irtesue, Robert, of Hoxon, skinner 1
4804417 2297564 2297564 defendant Broun Henry husbandman 590301 590301 Broun, Henry, of Hoxon, husbandman 0
4804418 2297564 2297564 defendant Edyngton Roger   590301 590301 Edyngton, Roger, of Hoxon, servant 1
4860924 2314775 2314775 defendant atte Cros John cordwainer 590301 590301 atte Cros, John, of Hoxon, cordwainer 0
4893683 2324720 2324720 defendant Cullyng John yeoman 590301 590301 Cullyng, John, of Hoxon, yeoman 0
4969683 2347879 2347879 defendant Blount Peter husbandman 590301 590301 Blount, Peter, of Hoxon, husbandman 0
5100360 2386546 2386546 defendant Flute Hugh drover 590301 590301 Flute, Hugh,of Hoxon, drover 3
5128144 2394706 2394706 defendant Herbert Robert scalder 590301 590301 Herbert, Robert, of Hoxon, scalder 0
5221829 2422082 2422082 defendant Drye William smith 590301 590301 Drye, William, of Hoxon, smith 2
5240344 2427389 2427389 defendant Debenham Stephen yeoman 590301 590301 Debenham, Stephen, of Hoxon, yeoman 2
5256212 2432068 2432068 plaintiff Debenham Stephen yeoman 590301 590301 Debenham, Stephen, of Hoxon, yeoman 0
5256213 2432068 2432068 defendant Thomson Robert miller 590301 590301 Thomson, Robert, of Hoxon, miller 0
5282445 2439926 2439926 plaintiff Debenham Stephen yeoman 590301 590301 Debenham, Stephen, of Hoxon, yeoman 0
5341778 2457622 2457622 defendant Everard Robert husbandman 590301 590301 Everard, Robert, of Hoxon, husbandman 2
5368667 2465795 2465795 defendant Everard Richard yeoman 590301 590301 Everard, Richard, of Hoxon, yeoman 0
5529136 2513627 2513627 defendant Barker James husbandman 590301 590301 Barker, James, of Hoxon, husbandman 0
5534121 2515209 2515209 plaintiff Thruston John   590301 590301 Thruston, John, of Hoxon 3
5534126 2515210 2515210 plaintiff Thruston John   590301 590301 Thruston, John, of Hoxon 3
5534133 2515212 2515212 plaintiff Thurston John   590301 590301 Thurston, John, of Hoxon 3
5534142 2515213 2515213 plaintiff Thurston John   590301 590301 Thurston, John, of Hoxon 3
5534147 2515214 2515214 plaintiff Thurston John   590301 590301 Thurston, John, of Hoxon 3

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