names

68 rows where place_id = 598126

✎ 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
3631211 1904586 1904586 defendant Asshwyn William husbandman 598126 598126 Asshwyn, William, of Cranley, husbandman 2
3632476 1904976 1904976 defendant Tykenour Richard husbandman 598126 598126 Tykenour, Richard, of Cranley, husbandman 0
3632972 1905130 1905130 defendant Tykenour Richard husbandman 598126 598126 Tykenour, Richard, of Cranley, husbandman 0
3646863 1909417 1909417 defendant Berwyk Henry gent 598126 598126 Berwyk, Henry, of Cranley, gent 0
3687068 1922129 1922129 defendant Carpenter John husbandman 598126 598126 Carpenter, John, of Cranley, husbandman 0
3687069 1922129 1922129 defendant Trower John husbandman 598126 598126 Trower, John, of Cranley, husbandman 1
3715006 1930989 1930989 defendant Bynger Richard gent 598126 598126 Bynger, Richard, of Cranley, gent 0
3715007 1930989 1930989 defendant Stredwyk Richard laborer 598126 598126 Stredwyk, Richard, of Cranley, laborer 1
3715008 1930989 1930989 defendant Dedysfold John laborer 598126 598126 Dedysfold, John, of Cranley, laborer 2
3715009 1930989 1930989 defendant Strodwyk John laborer 598126 598126 Strodwyk, John, of Cranley, laborer 3
3715010 1930989 1930989 defendant White John laborer 598126 598126 White, John, of Cranley, laborer 4
3715011 1930989 1930989 defendant Wod Thomas husbandman 598126 598126 Wod, Thomas, of Cranley, husbandman 5
3732822 1936494 1936494 defendant Burges Thomas painter 598126 598126 Burges, Thomas, of Cranley, painter 1
3745230 1940415 1940415 defendant Wysdom Richard sawyer 598126 598126 Wysdom, Richard, of Cranley, sawyer 3
3873129 1981228 1981228 defendant Atthoo John joiner 598126 598126 Atthoo, John, of Cranley, joiner 0
3875854 1982179 1982179 defendant Mower Robert husbandman 598126 598126 Mower, Robert, of Cranley, husbandman 2
3875855 1982179 1982179 defendant Balchyn Thomas laborer 598126 598126 Balchyn, Thomas, of Cranley, laborer 3
3875856 1982179 1982179 defendant Strynger Thomas husbandman 598126 598126 Strynger, Thomas, of Cranley, husbandman 4
3886425 1985712 1985712 defendant at Hoo John joiner 598126 598126 at Hoo, John, of Cranley, joiner 0
3892250 1987661 1987661 defendant Stuffeld Thomas husbandman 598126 598126 Stuffeld, Thomas, of Cranley, husbandman 0
3898289 1989637 1989637 plaintiff Ambros Richard clerk 598126 598126 Ambros, Richard, of Cranley, clerk 0
4056956 2044871 2044871 defendant Richebell Ralph yeoman 598126 598126 Richebell, Ralph, of Cranley, yeoman 0
4056957 2044871 2044871 defendant Mower Ralph husbandman 598126 598126 Mower, Ralph, of Cranley, husbandman 1
4231886 2106650 2106650 defendant Lambart alias Gardener John   598126 598126 Lambart alias Gardener, John, of Cranley, iron maker 0
4233057 2107070 2107070 defendant Inglyshe Ralph yeoman 598126 598126 Inglyshe, Ralph, of Cranley, yeoman 0
4233058 2107070 2107070 defendant Grasham Robert yeoman 598126 598126 Grasham, Robert, of Cranley, yeoman 1
4233059 2107070 2107070 defendant Cowles Thomas yeoman 598126 598126 Cowles, Thomas, of Cranley, yeoman 2
4233594 2107272 2107272 defendant Tycknor Robert husbandman 598126 598126 Tycknor, Robert, of Cranley, husbandman 0
4233595 2107272 2107272 defendant Tycknor John husbandman 598126 598126 Tycknor, John, of Cranley, husbandman 1
4237503 2108707 2108707 defendant Compton William husbandman 598126 598126 Compton, William, of Cranley, husbandman 1
4254183 2114394 2114394 defendant Browne Richard esq 598126 598126 Browne, Richard, of Cranley, esq 0
4276195 2121616 2121616 defendant Tycknor John yeoman 598126 598126 Tycknor, John, of Cranley, yeoman 0
4276197 2121617 2121617 defendant Tycknor Robert yeoman 598126 598126 Tycknor, Robert, of Cranley, yeoman 0
4312678 2134567 2134567 defendant Ritchbell Anthony yeoman 598126 598126 Ritchbell, Anthony, of Cranley, yeoman 0
4312679 2134567 2134567 defendant Englishe George yeoman 598126 598126 Englishe, George, of Cranley, yeoman 1
4315931 2135683 2135683 defendant Englishe Ralph yeoman 598126 598126 Englishe, Ralph, of Cranley, yeoman 2
4318178 2136465 2136465 defendant Worsfold David yeoman 598126 598126 Worsfold, David, of Cranley, yeoman 2
4318347 2136524 2136524 defendant Nelson John gent 598126 598126 Nelson, John, of Cranley, gent 2
4326093 2139096 2139096 defendant Rytchbell Anthony yeoman 598126 598126 Rytchbell, Anthony, of Cranley, yeoman 0
4326094 2139096 2139096 defendant Englishe George yeoman 598126 598126 Englishe, George, of Cranley, yeoman 1
4363455 2152002 2152002 defendant Englishe George yeoman 598126 598126 Englishe, George, of Cranley, yeoman 2
4367192 2153325 2153325 defendant Browne Richard esq 598126 598126 Browne, Richard, of Cranley, esq 0
4372429 2155206 2155206 defendant Englishe George yeoman 598126 598126 Englishe, George, of Cranley, yeoman 0
4372431 2155207 2155207 defendant Englishe George yeoman 598126 598126 Englishe, George, of Cranley, yeoman 0
4393054 2162288 2162288 defendant Barker John yeoman 598126 598126 Barker, John, of Cranley, yeoman 0
4394137 2162640 2162640 defendant Slyfeld Thomas husbandman 598126 598126 Slyfeld, Thomas, of Cranley, husbandman 0
4396072 2163262 2163262 defendant Tycknor Robert yeoman 598126 598126 Tycknor, Robert, of Cranley, yeoman 0
4399491 2164417 2164417 defendant Tycknor Robert husbandman 598126 598126 Tycknor, Robert, of Cranley, husbandman 0
4401315 2165036 2165036 defendant Ticknor Robert yeoman 598126 598126 Ticknor, Robert, of Cranley, yeoman 0
4401316 2165036 2165036 defendant Tycknor Nicholas husbandman 598126 598126 Tycknor, Nicholas, of Cranley, husbandman 1
4412393 2168734 2168734 defendant Ticknor Richard tailor 598126 598126 Ticknor, Richard, of Cranley, tailor 0
4412394 2168734 2168734 defendant Barker John yeoman 598126 598126 Barker, John, of Cranley, yeoman 1
4515973 2205418 2205418 defendant Rolf Walter   598126 598126 Rolf, Walter, of Cranley 2
4709650 2268383 2268383 defendant Ugmere Thomas husbandman 598126 598126 Ugmere, Thomas, of Cranley, husbandman 0
4853905 2312630 2312630 defendant Snokeshull Henry husbandman 598126 598126 Snokeshull, Henry, of Cranley, husbandman 0
5230729 2424597 2424597 defendant Alyre John sawyer 598126 598126 Alyre, John, of Cranley, sawyer 1
5230730 2424597 2424597 defendant Tanworth John tailor 598126 598126 Tanworth, John, of Cranley, tailor 2
5230731 2424597 2424597 defendant Garston John laborer 598126 598126 Garston, John, of Cranley, laborer 3
5230732 2424597 2424597 defendant atte Trowe William husbandman 598126 598126 atte Trowe, William, of Cranley, husbandman 4
5230733 2424597 2424597 defendant atte Berston Thomas laborer 598126 598126 atte Berston, Thomas, of Cranley, laborer 5
5276196 2438113 2438113 defendant Goutur Giles gent 598126 598126 Goutur, Giles, of Cranley, gent 1
5334889 2455503 2455503 defendant Neudegate John esq 598126 598126 Neudegate, John, of Cranley, esq 0
5338625 2456651 2456651 defendant Gunter Giles gent 598126 598126 Gunter, Giles, of Cranley, gent 0
5382041 2469921 2469921 defendant Mower Robert husbandman 598126 598126 Mower, Robert, of Cranley, husbandman 0
5382119 2469945 2469945 defendant Mower Robert husbandman 598126 598126 Mower, Robert, of Cranley, husbandman 0
5390713 2472404 2472404 defendant Mower Robert husbandman 598126 598126 Mower, Robert, of Cranley, husbandman 0
5517794 2510408 2510408 defendant Tayllour John tailor 598126 598126 Tayllour, John, of Cranley, tailor 1
5534390 2515294 2515294 defendant Mower Robert husbandman 598126 598126 Mower, Robert, of Cranley, husbandman 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);