names

55 rows where place_id = 589618

✎ 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
3598189 1867064 1867064 defendant Okeley Thomas husbandman 589618 589618 Okeley, Thomas, of Rykmersworth, husbandman 0
3637128 1906412 1906412 plaintiff Sebyn William (legal representative) 589618 589618 Sebyn, William, of Rykmersworth, executors of 0
3746767 1940905 1940905 defendant Welyn John collier 589618 589618 Welyn, John, of Rykmersworth, collier 0
3753661 1943087 1943087 plaintiff Spencer Thomas baker 589618 589618 Spencer, Thomas, of Rykmersworth, baker 0
3770801 1948558 1948558 plaintiff Spencer Thomas baker 589618 589618 Spencer, Thomas, of Rykmersworth, baker 0
3824653 1965586 1965586 defendant Federley Richard smith 589618 589618 Federley, Richard, of Rykmersworth, smith 2
3824654 1965586 1965586 defendant Flamsted John yeoman 589618 589618 Flamsted, John, of Rykmersworth, yeoman 3
3824655 1965586 1965586 defendant Hochynson William yeoman 589618 589618 Hochynson, William, of Rykmersworth, yeoman 4
4473239 2192291 2192291 defendant Smyth Thomas   589618 589618 Smyth, Thomas, of Rykmersworth 2
4481636 2194951 2194951 defendant Smyth Thomas   589618 589618 Smyth, Thomas, of Rykmersworth 0
4504608 2201991 2201991 defendant Crekes Richard   589618 589618 Crekes, Richard, of Rykmersworth 4
4521241 2206991 2206991 defendant Tyler Thomas butcher 589618 589618 Tyler, Thomas, of Rykmersworth, butcher 0
4692299 2263108 2263108 defendant Creyk William esq 589618 589618 Creyk, William, of Rykmersworth, esq 0
4721226 2271967 2271967 defendant Stokker John husbandman 589618 589618 Stokker, John, of Rykmersworth, husbandman 0
4803148 2297178 2297178 defendant Lythyng John husbandman 589618 589618 Lythyng, John, of rykmersworth, husbandman 0
4813401 2300305 2300305 defendant Hamonde Thomas fuller 589618 589618 Hamonde, Thomas, of Rykmersworth, fuller 2
4840076 2308446 2308446 defendant Warde Richard fuller 589618 589618 Warde, Richard, of Rykmersworth, fuller 3
4840102 2308452 2308452 defendant Warde Richard fuller 589618 589618 Warde, Richard, of Rykmersworth, fuller 3
4842181 2309089 2309089 defendant Wynkebourne John tailor 589618 589618 Wynkebourne, John, of Rykmersworth, tailor 0
4842182 2309089 2309089 defendant Creke William gent 589618 589618 Creke, William, of Rykmersworth, gent 1
4842184 2309090 2309090 defendant Wynkebourne John tailor 589618 589618 Wynkebourne, John, of Rykmersworth, tailor 0
4842185 2309090 2309090 defendant Creke wm gent 589618 589618 Creke, wm, of Rykmersworth, gent 1
4894807 2325044 2325044 defendant Dyer John husbandman 589618 589618 Dyer, John, of Rykmersworth, husbandman 0
4965464 2346587 2346587 defendant Edred Thomas husbandman 589618 589618 Edred, Thomas, of Rykmersworth, husbandman 0
4999188 2356628 2356628 defendant Lynster Henry gent 589618 589618 Lynster, Henry, of Rykmersworth, gent 0
5021230 2363109 2363109 defendant Stokker John husbandman 589618 589618 Stokker, John, of Rykmersworth, husbandman 2
5033774 2366758 2366758 defendant Wynkebourne John, junior yeoman 589618 589618 Wynkebourne, John, junior, of Rykmersworth, yeoman 0
5089889 2383420 2383420 defendant Danyell George gent 589618 589618 Danyell, George, of Rykmersworth, gent 0
5089890 2383420 2383420 defendant Tredewey Walter husbandman 589618 589618 Tredewey, Walter, of Rykmersworth, husbandman 1
5089892 2383421 2383421 defendant Tredewey Walter husbandman 589618 589618 Tredewey, Walter, of Rykmersworth, husbandman 0
5160833 2404264 2404264 defendant Creke John gent 589618 589618 Creke, John, of Rykmersworth, gent 0
5196732 2414792 2414792 defendant Creke John gent 589618 589618 Creke, John, of Rykmersworth, gent 0
5251247 2430493 2430493 plaintiff Wynkburn John yeoman 589618 589618 Wynkburn, John, of Rykmersworth, yeoman 0
5251641 2430615 2430615 defendant Holtyng William husbandman 589618 589618 Holtyng, William, of Rykmersworth, husbandman 0
5252008 2430731 2430731 defendant Godfrey Richard tailor 589618 589618 Godfrey, Richard, of Rykmersworth, tailor 2
5252009 2430731 2430731 defendant Twychet Richard carpenter 589618 589618 Twychet, Richard, of Rykmersworth, carpenter 3
5252010 2430731 2430731 defendant Grome Richard cordwainer 589618 589618 Grome, Richard, of Rykmersworth, cordwainer 4
5252011 2430731 2430731 defendant Gape Guy carpenter 589618 589618 Gape, Guy, of Rykmersworth, carpenter 5
5252012 2430731 2430731 defendant Dey Edward laborer 589618 589618 Dey, Edward, of Rykmersworth, laborer 6
5252013 2430731 2430731 defendant Wolfelder Edward cordwainer 589618 589618 Wolfelder, Edward, of Rykmersworth, cordwainer 7
5261105 2433583 2433583 defendant Kyng Andrew laborer 589618 589618 Kyng, Andrew, of Rykmersworth, laborer 2
5263865 2434456 2434456 defendant Rokys John   589618 589618 Rokys, John, of Rykmersworth, esq, son of Rokys, Thomas 0
5266594 2435302 2435302 defendant Warde Richard husbandman 589618 589618 Warde, Richard, of Rykmersworth, husbandman 1
5273147 2437217 2437217 defendant Cuyr Richard carpenter 589618 589618 Cuyr, Richard, of Rykmersworth, carpenter 0
5288914 2441763 2441763 defendant Over or Ober Richard carpenter 589618 589618 Over or Ober, Richard, of Rykmersworth, carpenter 0
5289211 2441847 2441847 defendant Deye John butcher 589618 589618 Deye, John, of Rykmersworth, butcher 0
5362995 2464072 2464072 defendant Creke Thomas gent 589618 589618 Creke, Thomas, of Rykmersworth, gent 0
5494975 2503394 2503394 defendant Hygges Walter innholder 589618 589618 Hygges, Walter, of Rykmersworth, innholder 0
5494976 2503394 2503394 defendant Dey John butcher 589618 589618 Dey, John, of Rykmersworth, butcher 1
5494977 2503394 2503394 defendant Fotherley James smith 589618 589618 Fotherley, James, of Rykmersworth, smith 2
5494978 2503394 2503394 defendant Coke William yeoman 589618 589618 Coke, William, of Rykmersworth, yeoman 3
5494979 2503394 2503394 defendant Rolff John miller 589618 589618 Rolff, John, of Rykmersworth, miller 4
5494980 2503394 2503394 defendant Barre Walter yeoman 589618 589618 Barre, Walter, of Rykmersworth, yeoman 5
5540314 2517102 2517102 defendant Pykat Robert butcher 589618 589618 Pykat, Robert, of Rykmersworth, butcher 0
5579365 2528626 2528626 defendant Hamond Thomas fuller 589618 589618 Hamond, Thomas, of Rykmersworth, fuller 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);