names

40 rows where place_id = 609678

✎ 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
3679689 1919715 1919715 plaintiff Pope John (legal representative) 609678 609678 Pope, John, of Hytchyn, Herts, maltman, executors of 0
3679692 1919716 1919716 plaintiff Pope John (legal representative) 609678 609678 Pope, John, of Hytchyn, Herts, maltman, executors of 0
3679694 1919716 1919716 defendant Tayllour Nicholas maltman 609678 609678 Tayllour, Nicholas, of Hytchyn, Herts, maltman 0
3799942 1957901 1957901 defendant Love John wheeler 609678 609678 Love, John, of Hytchyn, Herts, wheeler 0
3802541 1958692 1958692 defendant Smyth John gent 609678 609678 Smyth, John, of Hytchyn, herts, gent 0
3803136 1958882 1958882 defendant Smyth John gent 609678 609678 Smyth, John, of Hytchyn, Herts, gent 0
3806883 1960063 1960063 defendant Goldsmyth Thomas   609678 609678 Goldsmyth, Thomas, of Hytchyn, Herts, tallow chandler 0
3820592 1964326 1964326 defendant Okeley alias Aukeley John yeoman 609678 609678 Okeley alias Aukeley, John, of Hytchyn, Herts, yeoman 1
3828784 1966878 1966878 defendant Thurgood John yeoman 609678 609678 Thurgood, John, of Hytchyn, Herts, yeoman 0
3836073 1969196 1969196 defendant Same alias Sand Robert yeoman 609678 609678 Same alias Sand, Robert, of Hytchyn, Herts, yeoman 0
3838683 1970024 1970024 defendant Smyth William butcher 609678 609678 Smyth, William, of Hytchyn, Herts, butcher 0
3847853 1972904 1972904 defendant Tesdale Walter yeoman 609678 609678 Tesdale, Walter, of Hytchyn, Herts, yeoman 0
3863115 1977864 1977864 defendant Tesdale Walter yeoman 609678 609678 Tesdale, Walter, of Hytchyn, Herts, yeoman 0
3863912 1978105 1978105 defendant Smyth William butcher 609678 609678 Smyth, William, of Hytchyn, Herts, butcher 2
3866638 1979073 1979073 defendant Same Robert   609678 609678 Same, Robert, of Hytchyn, Herts 0
3916725 1995963 1995963 defendant Skargyll Thomas gent 609678 609678 Skargyll, Thomas, of Hytchyn, Herts, gent 1
3916748 1995969 1995969 defendant Skargyll homas gent 609678 609678 Skargyll, homas, of Hytchyn, Herts, gent 1
3916751 1995970 1995970 defendant Skargyll Thomas gent 609678 609678 Skargyll, Thomas, of Hytchyn, Herts, gent 1
3954783 2008740 2008740 defendant Sympson Thomas   609678 609678 Sympson, Thomas, of Hytchyn, Herts, tallow chandler or yeoman 0
3958734 2010130 2010130 defendant Harman John chapman 609678 609678 Harman, John, of Hytchyn, Herts, chapman 1
3961371 2011072 2011072 plaintiff Trevor Francis gent 609678 609678 Trevor, Francis, of Hytchyn, Herts, gent 0
3994978 2022951 2022951 defendant Awdelye Ralph (legal representative) 609678 609678 Awdelye, Ralph, of Hytchyn, Herts, shoemaker, executors of 0
4020998 2032235 2032235 defendant Lyle Roger yeoman 609678 609678 Lyle, Roger, of Hytchyn, Herts, yeoman 0
4037925 2038213 2038213 defendant Kympton John yeoman 609678 609678 Kympton, John, of Hytchyn, Herts, yeoman 0
4050257 2042520 2042520 plaintiff Hurste Edward yeoman 609678 609678 Hurste, Edward, of Hytchyn, Herts, yeoman 1
4069780 2049480 2049480 defendant Brownesell Richard chapman 609678 609678 Brownesell, Richard, of Hytchyn, Herts, chapman 0
4080512 2053344 2053344 plaintiff Warren Simon maltman 609678 609678 Warren, Simon, of Hytchyn, Herts, maltman 0
4080514 2053345 2053345 plaintiff Warren Simon maltman 609678 609678 Warren, Simon, of Hytchyn, Herts, maltman 0
4104869 2062016 2062016 defendant Hurste alias Fixe John currier 609678 609678 Hurste alias Fixe, John, of Hytchyn, Herts, currier 0
4104871 2062017 2062017 defendant Willoughbye John innholder 609678 609678 Willoughbye, John, of Hytchyn, Herts, innholder 0
4136439 2073373 2073373 defendant Burman Thomas gent 609678 609678 Burman, Thomas, of Hytchyn, Herts, gent 0
4193383 2093253 2093253 defendant Wallen alias Powlter William chapman 609678 609678 Wallen alias Powlter, William, of Hytchyn, Herts, chapman 0
4209042 2098713 2098713 defendant Warner Richard draper 609678 609678 Warner, Richard, of Hytchyn, Herts, draper 1
4213719 2100315 2100315 defendant Coker Thomas yeoman 609678 609678 Coker, Thomas, of Hytchyn, Herts, yeoman 0
4333834 2141599 2141599 defendant Barfote Thomas yeoman 609678 609678 Barfote, Thomas, of Hytchyn, Herts, yeoman 0
4385601 2159867 2159867 defendant Halye Simon chapman 609678 609678 Halye, Simon, of Hytchyn, Herts, chapman 1
4925616 2334444 2334444 defendant Barlycorn John dyer 609678 609678 Barlycorn, John, of Hytchyn, Herts, dyer 4
5044022 2369840 2369840 defendant Neweman William husbandman 609678 609678 Neweman, William, of Hytchyn, Herts, husbandman 1
5399446 2474919 2474919 defendant Gente Edmund yeoman 609678 609678 Gente, Edmund, of Hytchyn, Herts, yeoman 0
5559180 2522648 2522648 defendant Mondy Joan widow 609678 609678 (Mondy, Joan, of Hytchyn, Herts, widow 1

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