names

61 rows where place_id = 593148

✎ 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
3610689 1871009 1871009 defendant Molle John husbandman 593148 593148 Molle, John, of Chedull, husbandman 2
3610690 1871009 1871009 defendant Tomlynson John yeoman 593148 593148 Tomlynson, John, of Chedull, yeoman 3
3657541 1912619 1912619 defendant Baynbryg John husbandman 593148 593148 Baynbryg, John, of Chedull, husbandman 1
3673186 1917627 1917627 defendant Mascy William husbandman 593148 593148 Mascy, William, of Chedull, husbandman 0
3689172 1922777 1922777 defendant Harry John husbandman 593148 593148 Harry, John, of Chedull, husbandman 4
3703942 1927515 1927515 defendant Harryson John husbandman 593148 593148 Harryson, John, of Chedull, husbandman 0
3710701 1929667 1929667 defendant Masse William yeoman 593148 593148 Masse, William, of Chedull, yeoman 1
3725012 1934107 1934107 defendant Massy William yeoman 593148 593148 Massy, William, of Chedull, yeoman 0
3776605 1950428 1950428 defendant Harryson Ralph, senior yeoman 593148 593148 Harryson, Ralph, senior, of Chedull, yeoman 0
3776606 1950428 1950428 defendant Harryson Ralph, junior yeoman 593148 593148 Harryson, Ralph, junior, of Chedull, yeoman 1
3776607 1950428 1950428 defendant Pyot Thomas yeoman 593148 593148 Pyot, Thomas, of Chedull, yeoman 2
3826439 1966116 1966116 defendant Pyott Margaret widow 593148 593148 Pyott, Margaret, of Chedull, widow 0
3838744 1970045 1970045 defendant Ball William yeoman 593148 593148 Ball, William, of Chedull, yeoman 3
3840946 1970735 1970735 defendant Pyott Margaret widow 593148 593148 Pyott, Margaret, of Chedull, widow 0
3875420 1982025 1982025 defendant Harryson Ralph, senior yeoman 593148 593148 Harryson, Ralph, senior, of Chedull, yeoman 0
3885080 1985270 1985270 defendant Pyott Margaret   593148 593148 Pyott, Margaret, of Chedull 1
3891088 1987286 1987286 defendant Chawner John, junior husbandman 593148 593148 Chawner, John, junior, of Chedull, husbandman 1
3891089 1987286 1987286 defendant Johnson John husbandman 593148 593148 Johnson, John, of Chedull, husbandman 2
3894648 1988416 1988416 defendant Etwall William husbandman 593148 593148 Etwall, William, of Chedull, husbandman 0
3894649 1988416 1988416 defendant Baddeley Thomas husbandman 593148 593148 Baddeley, Thomas, of Chedull, husbandman 1
3896430 1989011 1989011 defendant Whittacres George collier 593148 593148 Whittacres, George, of Chedull, collier 2
3900829 1990507 1990507 defendant Wardull Richard laborer 593148 593148 Wardull, Richard, of Chedull, laborer 1
3900830 1990507 1990507 defendant Baddeley Thomas smith 593148 593148 Baddeley, Thomas, of Chedull, smith 2
3910714 1993899 1993899 defendant Yate Henry laborer 593148 593148 Yate, Henry, of Chedull, laborer 1
3910715 1993899 1993899 defendant Whitacrys John collier 593148 593148 Whitacrys, John, of Chedull, collier 2
3943127 2004715 2004715 defendant Halley Robert husbandman 593148 593148 Halley, Robert, of Chedull, husbandman 0
3970991 2014411 2014411 defendant Thornebury Edward yeoman 593148 593148 Thornebury, Edward, of Chedull, gent: Gledynhurst, Edmund, of Chedull, yeoman 0
3970992 2014411 2014411 defendant Wall Ralph laborer 593148 593148 Wall, Ralph, of Chedull, laborer 1
4019168 2031592 2031592 defendant Gledynhurst Edmund yeoman 593148 593148 Gledynhurst, Edmund, of Chedull, yeoman 1
4048648 2041965 2041965 defendant Wilkock alias Lymer Henry husbandman 593148 593148 Wilkock alias Lymer, Henry, of Chedull, husbandman 0
4048649 2041965 2041965 defendant Wylkock alias Lymer Richard laborer 593148 593148 Wylkock alias Lymer, Richard, of Chedull, laborer 1
4048650 2041965 2041965 defendant Wylkock alias Lymer Thomas laborer 593148 593148 Wylkock alias Lymer, Thomas, of Chedull, laborer 2
4052799 2043436 2043436 defendant Gybbons William shoemaker 593148 593148 Gybbons, William, of Chedull, shoemaker 1
4055367 2044316 2044316 defendant Thorneburye Edward gent 593148 593148 Thorneburye, Edward, of Chedull, gent 5
4116994 2066379 2066379 defendant Harryson Joan widow 593148 593148 Harryson, Joan, of Chedull, widow 0
4116995 2066379 2066379 defendant Harryson Agnes spinster 593148 593148 Harryson, Agnes, of Chedull, spinster 1
4154647 2079721 2079721 defendant Gybbons William yeoman 593148 593148 Gybbons, William, of Chedull, yeoman 0
4217202 2101513 2101513 defendant Pyott Elizabeth widow 593148 593148 Pyott, Elizabeth, of Chedull, widow 0
4217214 2101517 2101517 defendant Wall Ralph yeoman 593148 593148 Wall, Ralph, of Chedull, yeoman 0
4226415 2104710 2104710 defendant Hollyns John husbandman 593148 593148 Hollyns, John, of Chedull, husbandman 0
4233037 2107061 2107061 defendant Smythe Robert tanner 593148 593148 Smythe, Robert, of Chedull, tanner 0
4253825 2114275 2114275 defendant Hollyns John husbandman 593148 593148 Hollyns, John, of Chedull, husbandman 0
4293486 2127733 2127733 defendant Bentley William sherman 593148 593148 Bentley, William, of Chedull, sherman 0
4309655 2133535 2133535 defendant Wall Ralph yeoman 593148 593148 Wall, Ralph, of Chedull, yeoman 2
4323777 2138365 2138365 defendant Prott William yeoman 593148 593148 Prott, William, of Chedull, yeoman 3
4327744 2139605 2139605 defendant Hadfeeld Robert husbandman 593148 593148 Hadfeeld, Robert, of Chedull, husbandman 0
4342880 2144783 2144783 defendant Fowall Thomas husbandman 593148 593148 Fowall, Thomas, of Chedull, husbandman 0
4344363 2145308 2145308 defendant Moale John yeoman 593148 593148 Moale, John, of Chedull, yeoman 1
4676824 2258369 2258369 plaintiff Grene Thomas   593148 593148 Grene, Thomas, of Chedull 0
4871760 2318137 2318137 defendant Alsop Thomas yeoman 593148 593148 Alsop, Thomas, of Chedull, yeoman 0
4943777 2340022 2340022 defendant Batkyn William yeoman 593148 593148 Batkyn, William, of Chedull, yeoman 1
4949723 2341907 2341907 defendant Bryd John yeoman 593148 593148 Bryd, John, of Chedull, yeoman 0
4982002 2351535 2351535 defendant Walle Richard husbandman 593148 593148 Walle, Richard, of Chedull, husbandman 0
4982003 2351535 2351535 defendant Weram Robert husbandman 593148 593148 Weram, Robert, of Chedull, husbandman 1
5058774 2374189 2374189 defendant Chaloner Robert husbandman 593148 593148 Chaloner, Robert, of Chedull, husbandman 0
5058775 2374189 2374189 defendant Chaloner Richard husbandman 593148 593148 Chaloner, Richard, of Chedull, husbandman 1
5097208 2385616 2385616 defendant Wall Thomas yeoman 593148 593148 Wall, Thomas, of Chedull, yeoman 7
5097209 2385616 2385616 defendant Heuster William yeoman 593148 593148 Heuster, William, of Chedull, yeoman 8
5097212 2385616 2385616 defendant Fox William collier 593148 593148 Fox, William, of Chedull, collier 11
5129345 2395070 2395070 defendant Beek or Beck William clerk 593148 593148 Beek or Beck, William, of Chedull, clerk 0
5148082 2400585 2400585 defendant Walker Thomas weaver 593148 593148 Walker, Thomas, of Chedull, weaver 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);