names

72 rows where place_id = 589153

✎ 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
3596702 1866604 1866604 defendant Pynnyng John husbandman 589153 589153 Pynnyng, John, of Ruston, husbandman 0
3641231 1907709 1907709 defendant Jakson Henry husbandman 589153 589153 Jakson, Henry, of Ruston, husbandman 0
3700016 1926239 1926239 defendant Gyllor Walter gent 589153 589153 (Gyllor, Walter, of Ruston, gent 1
3802290 1958614 1958614 defendant Ede John husbandman 589153 589153 Ede, John, of Ruston, husbandman 2
3941488 2004163 2004163 defendant Pratt William gent 589153 589153 Pratt, William, of Ruston, gent 0
3970117 2014149 2014149 plaintiff Daccombe William gent 589153 589153 Daccombe, William, of Ruston, gent 0
4146405 2076893 2076893 defendant Mydleton Edmund gent 589153 589153 Mydleton, Edmund, of Ruston, gent 0
4169938 2084980 2084980 defendant Atkynson John weaver 589153 589153 Atkynson, John, of Ruston, weaver 3
4175272 2086818 2086818 defendant Harton Richard yeoman 589153 589153 Harton, Richard, of Ruston, yeoman 0
4179308 2088238 2088238 defendant Hellard Thomas gent 589153 589153 Hellard, Thomas, of Ruston, gent 0
4180085 2088513 2088513 defendant Awoodd John   589153 589153 Awoodd, John, of Ruston, sailor 0
4202727 2096497 2096497 defendant Hellard Thomas gent 589153 589153 Hellard, Thomas, of Ruston, gent 0
4203493 2096774 2096774 defendant Awood John   589153 589153 Awood, John, of Ruston, sailor 0
4254720 2114571 2114571 defendant Johnson Nicholas yeoman 589153 589153 Johnson, Nicholas, of Ruston, yeoman 0
4397487 2163738 2163738 defendant Michell Robert husbandman 589153 589153 Michell, Robert, of Ruston, husbandman 0
4449784 2184881 2184881 defendant Suthiby Robert   589153 589153 Suthiby, Robert, of Ruston 0
4449785 2184881 2184881 defendant Wenet William   589153 589153 Wenet, William, of Ruston 1
4449786 2184881 2184881 defendant Normanby Thomas de walker 589153 589153 Normanby, Thomas de, of Ruston, walker 2
4471352 2191707 2191707 defendant Malkynson John   589153 589153 Malkynson, John, of Ruston 1
4475435 2192993 2192993 defendant Machoun Thomas   589153 589153 Machoun, Thomas, of Ruston 2
4524104 2207870 2207870 defendant Wylwes Richard   589153 589153 Wylwes, Richard, of Ruston 0
4574717 2223617 2223617 defendant Humbilton Cecily   589153 589153 Humbilton, Cecily, of Ruston 13
4635786 2242034 2242034 defendant ap Jorr ap Jenan Gwilliam   589153 589153 ap Jorr ap Jenan, Gwilliam, of Ruston 0
4668940 2255986 2255986 defendant Hardy William husbandman 589153 589153 Hardy, William, of ruston, husbandman 2
4671781 2256820 2256820 defendant Colt Robert husbandman 589153 589153 Colt, Robert, of Ruston, husbandman 1
4696760 2264465 2264465 defendant Emmot Thomas laborer 589153 589153 Emmot, Thomas, of Ruston, laborer 2
4731152 2274943 2274943 defendant Strengar John butcher 589153 589153 Strengar, John, of Ruston, butcher 1
4764513 2284886 2284886 defendant West John husbandman 589153 589153 West, John, of Ruston, husbandman 0
4788414 2292437 2292437 defendant Ruston William husbandman 589153 589153 Ruston, William, of Ruston, husbandman 1
4788415 2292437 2292437 defendant Fenay William chaplain 589153 589153 Fenay, William, of Ruston, chaplain 2
4793718 2294152 2294152 defendant Mason Thomas   589153 589153 Mason, Thomas, of Ruston, mason 0
4798643 2295752 2295752 defendant Colynson William cooper 589153 589153 Colynson, William, of Ruston, cooper 1
4801484 2296645 2296645 defendant Ruston John yeoman 589153 589153 Ruston, John, of Ruston, yeoman 0
4854556 2312809 2312809 defendant Ousworth William husbandman 589153 589153 Ousworth, William, of Ruston, husbandman 0
4854557 2312809 2312809 defendant Ruston Thomas husbandman 589153 589153 Ruston, Thomas, of Ruston, husbandman 1
4854558 2312809 2312809 defendant Kyng Richard husbandman 589153 589153 Kyng, Richard, of Ruston, husbandman 2
4854559 2312809 2312809 defendant Wilkynson John husbandman 589153 589153 Wilkynson, John, of Ruston, husbandman 3
4865184 2316087 2316087 defendant Hornse Robert husbandman 589153 589153 Hornse, Robert, of Ruston, husbandman 0
4867058 2316661 2316661 defendant Frost William husbandman 589153 589153 Frost, William, of Ruston, husbandman 0
4867059 2316661 2316661 defendant Goldman Richard   589153 589153 Goldman, Richard, of Ruston, servant 1
4867060 2316661 2316661 defendant Pynnyng John   589153 589153 Pynnyng, John, of Ruston, servant 2
4988641 2353560 2353560 defendant Hunt John husbandman 589153 589153 Hunt, John, of Ruston, husbandman 0
4996663 2355856 2355856 defendant Hunt John miller 589153 589153 Hunt, John, of ruston, miller 1
5007949 2359216 2359216 defendant Cusseworth John husbandman 589153 589153 Cusseworth, John, of Ruston, husbandman 0
5007950 2359216 2359216 defendant Ruston Thomas husbandman 589153 589153 Ruston, Thomas, of Ruston, husbandman 1
5007951 2359216 2359216 defendant Calthorn William, sen husbandman 589153 589153 Calthorn, William, sen, of Ruston, husbandman 2
5007953 2359216 2359216 defendant Walker John husbandman 589153 589153 Walker, John, of Ruston, husbandman 4
5007955 2359216 2359216 defendant Smyth Thomas husbandman 589153 589153 Smyth, Thomas, of Ruston, husbandman 6
5008429 2359355 2359355 defendant Coke Richard esq 589153 589153 Coke, Richard, of Ruston, esq 1
5034577 2366974 2366974 defendant Cusseworth John husbandman 589153 589153 Cusseworth, John, of Ruston, husbandman 0
5034578 2366974 2366974 defendant Ruston Thomas husbandman 589153 589153 Ruston, Thomas, of Ruston, husbandman 1
5034579 2366974 2366974 defendant Smyth Thomas husbandman 589153 589153 Smyth, Thomas, of Ruston, husbandman 2
5034580 2366974 2366974 defendant Calthorn William, senior husbandman 589153 589153 Calthorn, William, senior, of Ruston, husbandman 3
5034581 2366974 2366974 defendant Calthorn William, junior husbandman 589153 589153 Calthorn, William, junior, of Ruston, husbandman 4
5034582 2366974 2366974 defendant Walker John husbandman 589153 589153 Walker, John, of Ruston, husbandman 5
5034583 2366974 2366974 defendant Wylkynson John husbandman 589153 589153 Wylkynson, John, of Ruston, husbandman 6
5059264 2374337 2374337 defendant Calthorn William, senior husbandman 589153 589153 Calthorn, William, senior, of Ruston, husbandman 1
5059265 2374337 2374337 defendant Calthorn William, junior husbandman 589153 589153 Calthorn, William, junior, of Ruston, husbandman 2
5094788 2384888 2384888 defendant Maunger William yeoman 589153 589153 Maunger, William, of Ruston, yeoman 1
5118918 2391964 2391964 defendant Mogson John husbandman 589153 589153 Mogson, John, of Ruston, husbandman 2
5163832 2405157 2405157 defendant Cusworth John   589153 589153 Cusworth, John, of Ruston 5
5177328 2409063 2409063 defendant Cusworth John   589153 589153 Cusworth, John, of Ruston 4
5281772 2439742 2439742 defendant Beweme John yeoman 589153 589153 Beweme, John, of Ruston, yeoman 1
5301286 2445337 2445337 defendant Devin John husbandman 589153 589153 Devin, John, of Ruston, husbandman 4
5361102 2463499 2463499 defendant Rodbod Robert husbandman 589153 589153 Rodbod, Robert, of Ruston, husbandman 2
5369181 2465962 2465962 defendant Wodward (illegible) husbandman 589153 589153 Wodward, ----------, of Ruston, husbandman 0
5369182 2465962 2465962 defendant Milner Richard husbandman 589153 589153 Milner, Richard, of Ruston, husbandman 1
5382089 2469935 2469935 defendant _worth Thomas husbandman 589153 589153 _worth, Thomas, of Ruston, husbandman 4
5552832 2520880 2520880 defendant Calthorn Henry husbandman 589153 589153 Calthorn, Henry, of Ruston, husbandman 0
5552833 2520880 2520880 defendant Walker Richard husbandman 589153 589153 Walker, Richard, of Ruston, husbandman 1
5552834 2520880 2520880 defendant Walker Nicholas husbandman 589153 589153 Walker, Nicholas, of Ruston, husbandman 2
5624711 2551661 2551661 defendant Smyth William yeoman 589153 589153 Smyth, William, of Ruston, yeoman 4

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