names

59 rows where place_id = 585989

✎ 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
3587634 1863776 1863776 defendant Fuller William husbandman 585989 585989 Fuller, William, of Framfeld, husbandman 2
3587638 1863777 1863777 defendant Fuller William husbandman 585989 585989 Fuller, William, of Framfeld, husbandman 2
3593654 1865649 1865649 defendant A Smyth Richard husbandman 585989 585989 A Smyth, Richard, of Framfeld, husbandman 0
3593664 1865654 1865654 defendant Smyth Richard husbandman 585989 585989 Smyth, Richard, of Framfeld, husbandman 0
3601232 1868047 1868047 defendant Fuller William husbandman 585989 585989 Fuller, William, of Framfeld, husbandman 2
3642560 1908115 1908115 defendant Sharpe Richard laborer 585989 585989 Sharpe, Richard, of Framfeld, laborer 3
3663524 1914519 1914519 defendant Hurst John chapman 585989 585989 Hurst, John, of Framfeld, chapman 0
3713296 1930468 1930468 defendant Warnett John gent 585989 585989 Warnett, John, of Framfeld, gent 0
3728784 1935247 1935247 defendant Warnett John gent 585989 585989 Warnett, John, of Framfeld, gent 0
3730299 1935708 1935708 defendant Wykersham John husbandman 585989 585989 Wykersham, John, of Framfeld, husbandman 0
3743945 1939995 1939995 defendant Warnett John gent 585989 585989 Warnett, John, of Framfeld, gent 0
3746405 1940795 1940795 defendant Holland Edward tailor 585989 585989 Holland, Edward, of Framfeld, tailor 0
3746406 1940795 1940795 defendant Somer John husbandman 585989 585989 Somer, John, of Framfeld, husbandman 1
3773948 1949568 1949568 defendant Warnett John gent 585989 585989 Warnett, John, of Framfeld, gent 1
3776509 1950405 1950405 defendant Palmer William yeoman 585989 585989 Palmer, William, of Framfeld, yeoman 0
3806536 1959958 1959958 defendant Burges Henry yeoman 585989 585989 Burges, Henry, of Framfeld, yeoman 2
3830670 1967475 1967475 defendant Smyth John shoemaker 585989 585989 Smyth, John, of Framfeld, shoemaker 5
4231893 2106653 2106653 defendant Daye William tanner 585989 585989 Daye, William, of Framfeld, or of Burrashe, tanner 0
4351995 2147932 2147932 defendant Wickersome John yeoman 585989 585989 Wickersome, John, of Framfeld, yeoman 0
4359829 2150678 2150678 defendant Chedweeke Simon husbandman 585989 585989 Chedweeke, Simon, of Framfeld, husbandman 1
4365479 2152721 2152721 defendant Somer John, senior yeoman 585989 585989 Somer, John, senior, of Framfeld, yeoman 0
4369847 2154270 2154270 defendant Lambe John husbandman 585989 585989 Lambe, John, of Framfeld, husbandman 1
4372500 2155233 2155233 defendant Kente Richard chapman 585989 585989 Kente, Richard, of Framfeld, yeoman, chapman 0
4547636 2215200 2215200 defendant Sloman John   585989 585989 Sloman, John, of Framfeld 0
4572247 2222860 2222860 defendant Heylond John   585989 585989 Heylond, John, of Framfeld 0
4613374 2235208 2235208 defendant Hereward Richard   585989 585989 Hereward, Richard, of Framfeld 19
4613399 2235210 2235210 defendant Hereward Richard   585989 585989 Hereward, Richard, of Framfeld 18
4625550 2238949 2238949 defendant Hereward Richard   585989 585989 Hereward, Richard, of Framfeld 16
4667534 2255565 2255565 defendant atte Smyth John husbandman 585989 585989 atte Smyth, John, of Framfeld, husbandman 1
4667535 2255565 2255565 defendant Wodeman William husbandman 585989 585989 Wodeman, William, of Framfeld, husbandman 2
4689696 2262340 2262340 defendant Brounyng Henry laborer 585989 585989 Brounyng, Henry, of Framfeld, laborer 0
4701787 2265958 2265958 defendant Hodke John carpenter 585989 585989 Hodke, John, of Framfeld, carpenter 0
4716219 2270380 2270380 defendant Keer William butcher 585989 585989 Keer, William, of Framfeld, butcher 1
4723062 2272524 2272524 plaintiff Crouchere William   585989 585989 Crouchere, William, of Framfeld 0
4738412 2277107 2277107 defendant Keer William butcher 585989 585989 Keer, William, of Framfeld, butcher 1
4738943 2277269 2277269 defendant Eston John carpenter 585989 585989 Eston, John, of Framfeld, carpenter 1
4786428 2291800 2291800 defendant Crouchere William husbandman 585989 585989 Crouchere, William, of Framfeld, husbandman 1
4795581 2294770 2294770 defendant Hystede John, junior husbandman 585989 585989 Hystede, John, junior, of Framfeld, husbandman 0
4853409 2312478 2312478 defendant Erlham William smith 585989 585989 Erlham, William, of Framfeld, smith 0
4882414 2321412 2321412 defendant Upton William husbandman 585989 585989 Upton, William, of Framfeld, husbandman 3
4894444 2324937 2324937 defendant Threel alias Dreel William husbandman 585989 585989 Threel alias Dreel, William, of Framfeld, husbandman 4
4909487 2329503 2329503 defendant Bastard John, senior husbandman 585989 585989 Bastard, John, senior, of Framfeld, husbandman 0
4958992 2344656 2344656 defendant Parponter Walter yeoman 585989 585989 Parponter, Walter, of Framfeld, yeoman 3
4963498 2345995 2345995 defendant Carpenter Walter husbandman 585989 585989 Carpenter, Walter, of Framfeld, husbandman 1
5001179 2357223 2357223 defendant Bryghtrych William tailor 585989 585989 Bryghtrych, William, of Framfeld, tailor 0
5006485 2358793 2358793 defendant Hulond Robert husbandman 585989 585989 Hulond, Robert, of Framfeld, husbandman 0
5011524 2360238 2360238 defendant Sloman John carpenter 585989 585989 Sloman, John, of Framfeld, carpenter 0
5083785 2381653 2381653 defendant Erche John husbandman 585989 585989 Erche, John, of Framfeld, husbandman 0
5120529 2392434 2392434 defendant Nenge William husbandman 585989 585989 Nenge, William, of Framfeld, husbandman 0
5376477 2468241 2468241 defendant Sharp Thomas carpenter 585989 585989 Sharp, Thomas, of Framfeld, carpenter 0
5430316 2484003 2484003 defendant Swane Richard smith 585989 585989 Swane, Richard, of Framfeld, smith 0
5495864 2503659 2503659 defendant Mychell John cooper 585989 585989 Mychell, John, of Framfeld, cooper 1
5538004 2516377 2516377 defendant Marten John butcher 585989 585989 Marten, John, of Framfeld, butcher 0
5551933 2520608 2520608 defendant Carpenter Thomas husbandman 585989 585989 Carpenter, Thomas, of Framfeld, husbandman 0
5591520 2532323 2532323 defendant Marten John husbandman 585989 585989 Marten, John, of Framfeld, husbandman 0
5597800 2534208 2534208 defendant Marten John husbandman 585989 585989 Marten, John, of Framfeld, husbandman 0
5604885 2536396 2536396 defendant Warnet John gent 585989 585989 Warnet, John, of Framfeld, gent 0
5604886 2536396 2536396 defendant Isted Richard laborer 585989 585989 Isted, Richard, of Framfeld, laborer 1
5604887 2536396 2536396 defendant Watkyns Thomas laborer 585989 585989 Watkyns, Thomas, of Framfeld, laborer 2

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