names

34 rows where place_id = 593797

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, role, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3613359 1871825 1871825 defendant Adams William arblasterman or crossbowman 593797 593797 Adams, William, of Ilmester, arblasterman or crossbowman 1
3621416 1874238 1874238 defendant Raddon Nicholas yeoman 593797 593797 Raddon, Nicholas, of Ilmester, yeoman 2
3671690 1917131 1917131 defendant Hawker John   593797 593797 Hawker, John, of Ilmester, Soms gent 1
3695948 1924971 1924971 defendant Armestrong Herbert tailor 593797 593797 Armestrong, Herbert, of Ilmester, tailor 0
3695949 1924971 1924971 defendant Hawker Richard hatmaker 593797 593797 Hawker, Richard, of Ilmester, hatmaker 1
3695951 1924972 1924972 defendant Armestrong Herbord tailor 593797 593797 Armestrong, Herbord, of Ilmester, tailor 0
3695952 1924972 1924972 defendant Hawker Richard hatmaker 593797 593797 Hawker, Richard, of Ilmester, hatmaker 1
3700475 1926386 1926386 defendant Byknell John baker 593797 593797 Byknell, John, of Ilmester, baker 0
3717202 1931667 1931667 defendant Helyer Richard yeoman 593797 593797 Helyer, Richard, of Ilmester, yeoman 0
3717203 1931667 1931667 defendant Bowdon Richard yeoman 593797 593797 Bowdon, Richard, of Ilmester, yeoman 1
3717204 1931667 1931667 defendant Ivery John (legal representative) 593797 593797 Ivery, John, of Ilmester, yeoman, executors of 2
3717205 1931667 1931667 defendant Colworth John yeoman 593797 593797 (Colworth, John, of Ilmester, yeoman 3
3717206 1931667 1931667 defendant Farr John yeoman 593797 593797 Farr, John, of Ilmester, yeoman 4
3743863 1939966 1939966 defendant Byconell John innholder 593797 593797 Byconell, John, of Ilmester, innholder 0
3743864 1939966 1939966 defendant Taylour Robert yeoman 593797 593797 Taylour, Robert, of Ilmester, yeoman 1
3743865 1939966 1939966 defendant Cornysshe Thomas glover 593797 593797 Cornysshe, Thomas, of Ilmester, glover 2
3813411 1962112 1962112 defendant Laurence John tanner 593797 593797 Laurence, John, of Ilmester, tanner 0
3921559 1997551 1997551 defendant Greynfyld Henry yeoman 593797 593797 Greynfyld, Henry, of Ilmester, yeoman 1
3937321 2002816 2002816 defendant Greynfylld Henry yeoman 593797 593797 Greynfylld, Henry, of Ilmester, yeoman 0
3940096 2003704 2003704 defendant Durman William yeoman 593797 593797 Durman, William, of Ilmester, yeoman 0
3949707 2006975 2006975 defendant Greynfylde Henry gent 593797 593797 Greynfylde, Henry, of Ilmester, gent 0
3967598 2013301 2013301 defendant Jolyffe John chapman 593797 593797 Jolyffe, John, of Ilmester, chapman 1
4034734 2037104 2037104 defendant Barefote George goldsmith 593797 593797 Barefote, George, of Ilmester, goldsmith 1
4034735 2037104 2037104 defendant Lumberde Thomas butcher 593797 593797 Lumberde Thomas, of Ilmester, butcher 2
4682158 2260041 2260041 defendant Dylyngton Matilda widow & formerly wife of Richard Dylyngton 593797 593797 Dylyngton, Matilda, of Ilmester, widow & formerly wife of Richard Dylyngton 0
4872549 2318371 2318371 defendant Dyllyngton Maud widow 593797 593797 Dyllyngton, Maud, of Ilmester, widow 0
4969557 2347844 2347844 defendant Wattys William merchant 593797 593797 Wattys, William, of Ilmester, merchant 0
5265770 2435047 2435047 plaintiff Thorn Thomas   593797 593797 Thorn, Thomas, of Ilmester 0
5341275 2457462 2457462 defendant Horne John husbandman 593797 593797 Horne, John, of Ilmester, husbandman 0
5341277 2457463 2457463 defendant Horne John husbandman 593797 593797 Horne, John, of Ilmester, husbandman 0
5341281 2457464 2457464 defendant Horne John husbandman 593797 593797 together with Horne, John, of Ilmester, husbandman 2
5532285 2514638 2514638 defendant Whytyngdale Thomas baker 593797 593797 Whytyngdale, Thomas, of Ilmester, baker 0
5594118 2533137 2533137 plaintiff Bale John mercer 593797 593797 Bale, John, of Ilmester, mercer 0
5594120 2533138 2533138 plaintiff Bale John mercer 593797 593797 Bale, John, of Ilmester, mercer 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);