names

43 rows where place_id = 609068

✎ 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
3676843 1918797 1918797 defendant Spencer William gent 609068 609068 Spencer, William, of Witton, gent 0
3692606 1923875 1923875 defendant Spenser William gent 609068 609068 Spenser, William, of Witton, gent 0
3921036 1997385 1997385 defendant Cowell Thomas husbandman 609068 609068 Cowell, Thomas, of Witton, husbandman 1
3921037 1997385 1997385 defendant Cannell William husbandman 609068 609068 Cannell, William, of Witton, husbandman 2
3989755 2021079 2021079 defendant Dade John gent 609068 609068 Dade, John, of Witton, gent 0
4013443 2029542 2029542 defendant Dade John gent 609068 609068 Dade, John, of Witton, gent 0
4021667 2032477 2032477 defendant Dade John gent 609068 609068 Dade, John, of Witton, gent 0
4042311 2039731 2039731 defendant Dade John gent 609068 609068 Dade, John, of Witton, gent 0
4112363 2064680 2064680 defendant Drake Robert yeoman 609068 609068 Drake, Robert, of Witton, yeoman 0
4128047 2070320 2070320 defendant Bowthe Christopher gent 609068 609068 Bowthe, Christopher, of Witton, gent 1
4196850 2094447 2094447 defendant Burye Robert clerk 609068 609068 Burye, Robert, of Witton, clerk 1
4209600 2098907 2098907 defendant Churche Christopher husbandman 609068 609068 Churche, Christopher, of Witton, husbandman 3
4211211 2099476 2099476 defendant Shorte Lawrence yeoman 609068 609068 Shorte, Lawrence, of Witton, yeoman 0
4211212 2099476 2099476 defendant Berrey Robert clerk 609068 609068 Berrey, Robert, of Witton, clerk 1
4213092 2100103 2100103 defendant Sharpe John yeoman 609068 609068 Sharpe, John, of Witton, yeoman 1
4239651 2109499 2109499 defendant Caswald Henry yeoman 609068 609068 Caswald, Henry, of Witton, yeoman 0
4260740 2116557 2116557 defendant Wyngfilde Robert gent 609068 609068 Wyngfilde, Robert, of Witton, gent 0
4266396 2118404 2118404 defendant Oty Richard husbandman 609068 609068 Oty, Richard, of Witton, husbandman 0
4294555 2128139 2128139 defendant Randall Robert yeoman 609068 609068 Randall, Robert, of Witton, yeoman 0
4312043 2134351 2134351 defendant Spencer William gent 609068 609068 Spencer, William, of Witton, gent 0
4329467 2140162 2140162 defendant Cooke Mathew husbandman 609068 609068 Cooke, Mathew, of Witton, husbandman 1
4334611 2141845 2141845 defendant Rycoll Charles tailor 609068 609068 Rycoll, Charles, of Witton, tailor 3
4348385 2146687 2146687 defendant Gynn Elizabeth widow 609068 609068 Gynn, Elizabeth, of Witton, widow 2
4356098 2149356 2149356 defendant Darrington Ambrose clerk 609068 609068 Darrington, Ambrose, of Witton, clerk 0
4374490 2155942 2155942 defendant Wytton Henry yeoman 609068 609068 Wytton, Henry, of Witton, yeoman 0
4387381 2160424 2160424 defendant Annyston Walter husbandman 609068 609068 Annyston, Walter, of Witton, husbandman 3
4403294 2165674 2165674 defendant Nelson Ralph yeoman 609068 609068 Nelson, Ralph, of Witton, yeoman 1
4517275 2205802 2205802 defendant Taillour John   609068 609068 Taillour, John, of Witton 3
4711762 2269002 2269002 defendant Titll Richard yeoman 609068 609068 Titll, Richard, of Witton, yeoman 1
4889710 2323576 2323576 plaintiff Stibberd William   609068 609068 Stibberd, William, of Witton 0
4942655 2339675 2339675 defendant Holley John yeoman 609068 609068 Holley, John, of Witton, yeoman 1
4988624 2353554 2353554 defendant Trynman William husbandman 609068 609068 Trynman, William, of Witton, husbandman 1
5116347 2391210 2391210 defendant Dukworth Elias yeoman 609068 609068 Dukworth, Elias, of Witton, yeoman 8
5136884 2397308 2397308 defendant Dokeworth Ellis yeoman 609068 609068 Dokeworth, Ellis, of Witton, yeoman 2
5137579 2397505 2397505 defendant Deye Walter baker 609068 609068 Deye, Walter, of Witton, baker 2
5173364 2407917 2407917 defendant Coket John yeoman 609068 609068 Coket, John, of Witton, yeoman 2
5173366 2407917 2407917 defendant Lethum Robert gent 609068 609068 Lethum, Robert, of Witton, gent 4
5194570 2414142 2414142 defendant Lethum Robert gent 609068 609068 Lethum, Robert, of Witton, gent 0
5208148 2418113 2418113 defendant Dokeworth Ellis yeoman 609068 609068 Dokeworth, Ellis, of Witton, yeoman 3
5283921 2440329 2440329 defendant Rane William husbandman 609068 609068 Rane, William, of Witton, husbandman 5
5290934 2442352 2442352 defendant Russe Henry husbandman 609068 609068 Russe, Henry, of Witton, husbandman 0
5565582 2524525 2524525 defendant Goode William sawyer 609068 609068 Goode, William, of Witton, sawyer 0
5626394 2552225 2552225 defendant Hogeson Robert yeoman 609068 609068 Hogeson, Robert, of Witton, yeoman 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);