names

75 rows where place_id = 596299

✎ 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
3624086 1875063 1875063 defendant Bulte Thomas husbandman 596299 596299 Bulte, Thomas, of Snaynton, husbandman 0
3624087 1875063 1875063 defendant Gable Henry husbandman 596299 596299 Gable, Henry, of Snaynton, husbandman 1
3624090 1875063 1875063 defendant Mores John husbandman 596299 596299 Mores, John, of Snaynton, husbandman 4
3624091 1875063 1875063 defendant Childe Robert husbandman 596299 596299 Childe, Robert, of Snaynton, husbandman 5
3624092 1875063 1875063 defendant Mawelot John husbandman 596299 596299 Mawelot, John, of Snaynton, husbandman 6
3624095 1875064 1875064 defendant Bulte Thomas husbandman 596299 596299 Bulte, Thomas, of Snaynton, husbandman 0
3624096 1875064 1875064 defendant Gable Henry husbandman 596299 596299 Gable, Henry, of Snaynton, husbandman 1
3624099 1875064 1875064 defendant Mores John husbandman 596299 596299 Mores, John, of Snaynton, husbandman 4
3624100 1875064 1875064 defendant Childe Robert husbandman 596299 596299 Childe, Robert, of Snaynton, husbandman 5
3624101 1875064 1875064 defendant Mawelot John husbandman 596299 596299 Mawelot, John, of Snaynton, husbandman 6
3733141 1936595 1936595 defendant Hall George gent 596299 596299 Hall, George, of Snaynton, gent 1
3747851 1941250 1941250 defendant Spencer John yeoman 596299 596299 Spencer, John, of Snaynton, yeoman 0
3779950 1951454 1951454 defendant Spencer John   596299 596299 Spencer, John, of Snaynton, yeoman, bailiff of Broxtawe 0
3797495 1957107 1957107 defendant Nicholson Christopher husbandman 596299 596299 Nicholson, Christopher, of Snaynton, husbandman 0
3948433 2006515 2006515 defendant Smythe William husbandman 596299 596299 (Smythe, William, of Snaynton, husbandman 1
4225893 2104523 2104523 defendant Bransbye Richard husbandman 596299 596299 Bransbye, Richard, of Snaynton, husbandman 0
4225897 2104524 2104524 defendant Branesby Richard husbandman 596299 596299 Branesby, Richard, of Snaynton, husbandman 1
4313723 2134906 2134906 defendant Bransby Richard yeoman 596299 596299 Bransby, Richard, of Snaynton, yeoman 0
4475297 2192956 2192956 defendant Jonson Richard   596299 596299 Jonson, Richard, of Snaynton 0
4475298 2192956 2192956 defendant Abolton John   596299 596299 Abolton, John, of Snaynton 1
4481772 2195001 2195001 defendant Estiby Richard   596299 596299 Estiby, Richard, of Snaynton 0
4640576 2243351 2243351 defendant pate Nicholas   596299 596299 pate, Nicholas, of Snaynton 0
4640977 2243457 2243457 defendant Eston William   596299 596299 Eston, William, of Snaynton 3
4644581 2244508 2244508 defendant Marschall William   596299 596299 Marschall, William, of Snaynton 3
4668951 2255990 2255990 defendant Smyth Nicholas fisher 596299 596299 Smyth, Nicholas, of Snaynton, fisher 0
4680976 2259677 2259677 defendant Clerk Robert gent 596299 596299 Clerk, Robert, of Snaynton, gent 0
4680978 2259677 2259677 defendant Lynby Thomas de husbandman 596299 596299 Lynby, Thomas de, of Snaynton, husbandman 2
4680981 2259677 2259677 defendant atte Persones John husbandman 596299 596299 atte Persones, John, of Snaynton, husbandman 5
4687354 2261646 2261646 defendant Dryngale John husbandman 596299 596299 Dryngale, John, of Snaynton, husbandman 2
4794019 2294262 2294262 defendant Clerk Robert husbandman 596299 596299 Clerk, Robert, of Snaynton, husbandman 0
4794021 2294263 2294263 defendant Clerk Robert husbandman 596299 596299 Clerk, Robert, of Snaynton, husbandman 0
4797682 2295456 2295456 defendant Thornyf Robert gent 596299 596299 Thornyf, Robert, of Snaynton, gent 0
4798575 2295734 2295734 defendant Smyth John smith 596299 596299 Smyth, John, of Snaynton, smith 1
4818981 2302017 2302017 defendant Colynson Robert, senior husbandman 596299 596299 Colynson, Robert, senior, of Snaynton, husbandman 0
4818982 2302017 2302017 defendant Colynson Roger husbandman 596299 596299 Colynson, Roger, of Snaynton, husbandman 1
4818983 2302017 2302017 defendant Colynson Thomas husbandman 596299 596299 Colynson, Thomas, of Snaynton, husbandman 2
4818984 2302017 2302017 defendant Barry Hamon husbandman 596299 596299 Barry, Hamon, of Snaynton, husbandman 3
4818985 2302017 2302017 defendant Colynson Robert, junior husbandman 596299 596299 Colynson, Robert, junior, of Snaynton, husbandman 4
4818986 2302017 2302017 defendant Barry Thomas laborer 596299 596299 Barry, Thomas, of Snaynton, laborer 5
4824045 2303596 2303596 defendant Fraunke John husbandman 596299 596299 Fraunke, John, of Snaynton, husbandman 0
4848288 2310937 2310937 defendant Patryk William husbandman 596299 596299 Patryk, William, of Snaynton, husbandman 0
4848290 2310937 2310937 defendant Frank Thomas laborer 596299 596299 Frank, Thomas, of Snaynton, laborer 2
4848291 2310937 2310937 defendant Patryk John husbandman 596299 596299 Patryk, John, of Snaynton, husbandman 3
4875915 2319428 2319428 defendant Patryk William husbandman 596299 596299 together with Patryk, William, of Snaynton, husbandman 1
4875916 2319428 2319428 defendant Frank Thomas laborer 596299 596299 Frank, Thomas, of Snaynton, laborer 2
4875917 2319428 2319428 defendant Patr yk John husbandman 596299 596299 Patr yk, John, of Snaynton, husbandman 3
4895487 2325256 2325256 defendant Symson John chaplain 596299 596299 Symson, John, of Snaynton, chaplain 1
4911580 2330123 2330123 defendant Selowe Roger gent 596299 596299 Selowe, Roger, of Snaynton, gent 0
4911581 2330123 2330123 defendant Colyn Robert husbandman 596299 596299 Colyn, Robert, of Snaynton, husbandman 1
4933446 2336845 2336845 defendant Selowe Roger gent 596299 596299 Selowe, Roger, of Snaynton, gent 0
4951736 2342495 2342495 defendant Man John husbandman 596299 596299 Man, John, of Snaynton, husbandman 3
4962786 2345779 2345779 defendant Smyth Thomas laborer 596299 596299 Smyth, Thomas, of Snaynton, laborer 0
4962787 2345779 2345779 defendant Pirre Richard laborer 596299 596299 Pirre, Richard, of Snaynton, laborer 1
5010335 2359892 2359892 defendant Carter Thomas husbandman 596299 596299 Carter, Thomas, of Snaynton, husbandman 0
5016385 2361686 2361686 defendant Lambe John tailor 596299 596299 Lambe, John, of Snaynton, tailor 0
5016386 2361686 2361686 defendant Lambe Thomas tailor 596299 596299 Lambe, Thomas, of Snaynton, tailor 1
5016387 2361686 2361686 defendant Barry Robert husbandman 596299 596299 Barry, Robert, of Snaynton, husbandman 2
5016388 2361686 2361686 defendant Cumberland John husbandman 596299 596299 Cumberland, John, of Snaynton, husbandman 3
5033866 2366782 2366782 defendant Barneby John husbandman 596299 596299 Barneby, John, of Snaynton, husbandman 2
5078616 2380097 2380097 defendant Bukton John gent 596299 596299 Bukton, John, of Snaynton, gent 0
5094910 2384925 2384925 defendant Mason John husbandman 596299 596299 Mason, John, of Snaynton, husbandman 5
5129288 2395055 2395055 defendant Selowe Roger esq 596299 596299 Selowe, Roger, of Snaynton, esq 2
5148558 2400704 2400704 defendant Selowe Roger esq 596299 596299 Selowe, Roger, of Snaynton, esq 2
5167807 2406298 2406298 defendant Selowe Roger esq 596299 596299 Selowe, Roger, of Snaynton, esq 2
5183419 2410891 2410891 defendant Selowe Roger esq 596299 596299 Selowe, Roger, of Snaynton, esq 2
5307159 2447141 2447141 plaintiff Tyler William   596299 596299 (Tyler, William, of Snaynton 1
5531915 2514527 2514527 defendant Butte Thomas husbandman 596299 596299 Butte, Thomas, of Snaynton, husbandman 0
5531916 2514527 2514527 defendant Webbe Henry husbandman 596299 596299 Webbe, Henry, of Snaynton, husbandman 1
5531919 2514527 2514527 defendant Mores John husbandman 596299 596299 Mores, John, of Snaynton, husbandman 4
5531920 2514527 2514527 defendant Chylde Robert husbandman 596299 596299 Chylde, Robert, of Snaynton, husbandman 5
5531921 2514527 2514527 defendant Mawebot John husbandman 596299 596299 Mawebot, John, of Snaynton, husbandman 6
5605463 2536589 2536589 defendant Willons Simon laborer 596299 596299 Willons, Simon, of Snaynton, laborer 2
5624709 2551661 2551661 defendant Carter John husbandman 596299 596299 Carter, John, of Snaynton, husbandman 2
5624710 2551661 2551661 defendant Fissher Robert yeoman 596299 596299 Fissher, Robert, of Snaynton, yeoman 3
5624718 2551662 2551662 defendant Snaynton Robert husbandman 596299 596299 Snaynton, Robert, of Snaynton, husbandman 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);