names

43 rows where place_id = 596929

✎ 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
3626668 1903187 1903187 defendant Tanner James yeoman 596929 596929 Tanner, James, of Waldern, yeoman 1
3640950 1907609 1907609 defendant Tanner James yeoman 596929 596929 Tanner, James, of Waldern, yeoman 1
3641111 1907665 1907665 defendant Frankewell Richard yeoman 596929 596929 Frankewell, Richard, of Waldern, yeoman 0
3653185 1911331 1911331 defendant Banys Giles clerk 596929 596929 Banys, Giles, of Waldern, clerk 0
3653186 1911331 1911331 defendant Dyne William husbandman 596929 596929 Dyne, William, of Waldern, husbandman 1
3653187 1911331 1911331 defendant Fuller John wheeler 596929 596929 Fuller, John, of Waldern, wheeler 2
3668893 1916203 1916203 defendant Hull Margery widow 596929 596929 Hull, Margery, of Waldern, widow 0
3681290 1920235 1920235 defendant Corker Thomas tailor 596929 596929 Corker, Thomas, of Waldern, tailor 2
3710273 1929528 1929528 defendant Mone Thomas yeoman 596929 596929 Mone, Thomas, of Waldern, yeoman 2
3723565 1933644 1933644 defendant Frankewell William yeoman 596929 596929 Frankewell, William, of Waldern, yeoman 0
3753504 1943033 1943033 defendant Smyth Richard husbandman 596929 596929 Smyth, Richard, of Waldern, husbandman 1
3753505 1943033 1943033 defendant A Wodde Thomas husbandman 596929 596929 A Wodde, Thomas, of Waldern, husbandman 2
3756604 1944047 1944047 defendant Bodell John carpenter 596929 596929 Bodell, John, of Waldern, carpenter 0
3763937 1946362 1946362 defendant A More Richard weaver 596929 596929 A More, Richard, of Waldern, weaver 1
3824872 1965660 1965660 defendant Banys Giles clerk 596929 596929 Banys, Giles, of Waldern, clerk 0
3832746 1968167 1968167 defendant Banes Giles chaplain 596929 596929 Banes, Giles, of Waldern, chaplain 0
4186178 2090649 2090649 defendant Inman Edward yeoman 596929 596929 Inman, Edward, of Waldern, yeoman 3
4484320 2195798 2195798 defendant Birthe Agnes   596929 596929 Birthe, Agnes, of Waldern 2
4634389 2241602 2241602 defendant Sherman Thomas   596929 596929 Sherman, Thomas, of Waldern 0
4634392 2241602 2241602 defendant atte Forde Lawrence   596929 596929 atte Forde, Lawrence, of Waldern 3
4638329 2242756 2242756 defendant Fovell Thomas   596929 596929 Fovell, Thomas, of Waldern 0
4693699 2263529 2263529 defendant Pouke John   596929 596929 Pouke, John, of Waldern, shoe maker 0
4723247 2272580 2272580 defendant Cartere Henry husbandman 596929 596929 Cartere, Henry, of Waldern, husbandman 0
4725104 2273148 2273148 defendant Rychevyle Robert laborer 596929 596929 Rychevyle, Robert, of Waldern, laborer 0
4725977 2273410 2273410 defendant Crotyndenne Thomas husbandman 596929 596929 Crotyndenne, Thomas, of Waldern, husbandman 0
4881085 2320994 2320994 defendant Crotengden Thomas wheeler 596929 596929 Crotengden, Thomas, of Waldern, wheeler 0
4895277 2325181 2325181 plaintiff Halle Agnes (legal representative) 596929 596929 Halle, Agnes, of Waldern, executor of 0
4906561 2328637 2328637 defendant Stanes Edmund laborer 596929 596929 Stanes, Edmund, of Waldern, laborer 0
4909488 2329503 2329503 defendant Holbeme John husbandman 596929 596929 Holbeme, John, of Waldern, husbandman 1
4943100 2339816 2339816 defendant Braybroke Thomas husbandman 596929 596929 Braybroke, Thomas, of Waldern, husbandman 0
5166339 2405878 2405878 defendant Frankwell Thomas tanner 596929 596929 Frankwell, Thomas, of Waldern, tanner 1
5289766 2442012 2442012 defendant Staunton Richard draper 596929 596929 Staunton, Richard, of Waldern, draper 1
5306531 2446945 2446945 defendant Willard William carpenter 596929 596929 Willard, William, of Waldern, carpenter 0
5319416 2450899 2450899 defendant Frankewell Thomas tanner 596929 596929 Frankewell, Thomas, of Waldern, tanner 2
5334164 2455286 2455286 plaintiff Eggyngworth or Heggyngworth Richard   596929 596929 Eggyngworth or Heggyngworth, Richard, of Waldern 0
5336715 2456050 2456050 plaintiff Heggyngworth Richard   596929 596929 Heggyngworth, Richard, of Waldern 0
5336719 2456051 2456051 plaintiff Heggyngworth Richard   596929 596929 Heggyngworth, Richard, of Waldern 0
5392597 2472952 2472952 plaintiff Semer John yeoman 596929 596929 Semer, John, of Waldern, yeoman 0
5505818 2506741 2506741 defendant Tanner James yeoman 596929 596929 Tanner, James, of Waldern, yeoman 0
5523148 2512066 2512066 defendant Frankwell Richard tanner 596929 596929 Frankwell, Richard, of Waldern, tanner 0
5559548 2522753 2522753 defendant Powek William laborer 596929 596929 Powek, William, of Waldern, laborer 0
5559549 2522753 2522753 defendant Walcote John laborer 596929 596929 Walcote, John, of Waldern, laborer 1
5636087 2555244 2555244 defendant atte Forde Lawrence husbandman 596929 596929 atte Forde, Lawrence, of Waldern, husbandman 2

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