names

74 rows where place_id = 620728

✎ 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
3737245 1937881 1937881 defendant Sketyll Owen smith 620728 620728 Sketyll, Owen, of Grymolby, smith 0
3737247 1937882 1937882 defendant Sketyll Owen smith 620728 620728 Sketyll, Owen, of Grymolby, smith 0
3737248 1937882 1937882 defendant Westowe William laborer 620728 620728 Westowe, William, of Grymolby, laborer 1
3783701 1952666 1952666 defendant Rouland Robert labaorer 620728 620728 Rouland, Robert, of Grymolby, labaorer 0
3783702 1952666 1952666 defendant Scott Richard husbandman 620728 620728 Scott, Richard, of Grymolby, husbandman 1
3806285 1959885 1959885 defendant Bradeley Thomas husbandman 620728 620728 Bradeley, Thomas, of Grymolby, husbandman 0
3806286 1959885 1959885 defendant Sheffeld William laborer 620728 620728 Sheffeld, William, of Grymolby, laborer 1
3806287 1959885 1959885 defendant Rouse Robert husbandman 620728 620728 Rouse, Robert, of Grymolby, husbandman 2
3806288 1959885 1959885 defendant Halyday Robert husbandman 620728 620728 Halyday, Robert, of Grymolby, husbandman 3
3806289 1959885 1959885 defendant Tyson Roger husbandman 620728 620728 Tyson, Roger, of Grymolby, husbandman 4
3806290 1959885 1959885 defendant Kynyerby John husbandman 620728 620728 Kynyerby, John, of Grymolby, husbandman 5
3806291 1959885 1959885 defendant Whychecote John husbandman 620728 620728 Whychecote, John, of Grymolby, husbandman 6
3806293 1959886 1959886 defendant Bradeley Thomas husbandman 620728 620728 Bradeley, Thomas, of Grymolby, husbandman 0
3806294 1959886 1959886 defendant Sheffeld William laborer 620728 620728 Sheffeld, William, of Grymolby, laborer 1
3806295 1959886 1959886 defendant Rouse Robert husbandman 620728 620728 Rouse, Robert, of Grymolby, husbandman 2
3806296 1959886 1959886 defendant Halyday Robert husbandman 620728 620728 Halyday, Robert, of Grymolby, husbandman 3
3806297 1959886 1959886 defendant Tyson Roger husbandman 620728 620728 Tyson, Roger, of Grymolby, husbandman 4
3806298 1959886 1959886 defendant Kynyerby John husbandman 620728 620728 Kynyerby, John, of Grymolby, husbandman 5
3806299 1959886 1959886 defendant Whychecote John husbandman 620728 620728 Whychecote, John, of Grymolby, husbandman 6
3814542 1962461 1962461 defendant Crathorne Thomas gent 620728 620728 Crathorne, Thomas, of Grymolby, gent 2
3845070 1972014 1972014 defendant Smyth William husbandman 620728 620728 Smyth, William, of Grymolby, husbandman 1
3897682 1989433 1989433 defendant Ingleby Henry husbandman 620728 620728 Ingleby, Henry, of Grymolby, husbandman 0
3929085 2000068 2000068 defendant Smyth Thomas husbandman 620728 620728 Smyth, Thomas, of Grymolby, husbandman 0
4047732 2041636 2041636 plaintiff Storry Richard glasier 620728 620728 Storry, Richard, of Grymolby, glasier 0
4446774 2183907 2183907 defendant Kernardson William   620728 620728 Kernardson, William, of Grymolby 0
4446775 2183907 2183907 defendant Scot John   620728 620728 Scot, John, of Grymolby 1
4448089 2184323 2184323 defendant Smyth Thomas   620728 620728 Smyth, Thomas, of Grymolby 1
4449265 2184718 2184718 plaintiff Pays John   620728 620728 Pays, John, of Grymolby 6
4468691 2190884 2190884 defendant Bugge Robert   620728 620728 Bugge, Robert, of Grymolby 0
4468695 2190884 2190884 defendant Richardson William   620728 620728 Richardson, William, of Grymolby 4
4487563 2196829 2196829 plaintiff Smyth William   620728 620728 Smyth, William, of Grymolby 0
4487564 2196829 2196829 defendant Bernardson William   620728 620728 Bernardson, William, of Grymolby 0
4527378 2208842 2208842 defendant Elys Ralph   620728 620728 Elys, Ralph, of Grymolby 0
4527379 2208842 2208842 defendant Elys William   620728 620728 Elys, William, of Grymolby 1
4538532 2212331 2212331 defendant Elys William   620728 620728 Elys, William, of Grymolby 1
4538533 2212331 2212331 defendant Elys Ralph   620728 620728 Elys, Ralph, of Grymolby 2
4564037 2220324 2220324 defendant Yerburgh William   620728 620728 Yerburgh, William, of Grymolby 0
4565636 2220822 2220822 defendant Smyth Thomas   620728 620728 Smyth, Thomas, of Grymolby, son of William 0
4660233 2249035 2249035 defendant Spenser John husbandman 620728 620728 Spenser, John, of Grymolby, husbandman 0
4688435 2261949 2261949 defendant Bugge Thomas husbandman 620728 620728 Bugge, Thomas, of Grymolby, husbandman 1
4692627 2263211 2263211 defendant Smyth Thomas husbandman 620728 620728 Smyth, Thomas, of Grymolby, husbandman 0
4698051 2264877 2264877 defendant Raper William, sen reaper 620728 620728 Raper, William, sen, of Grymolby, reaper 0
4764945 2285011 2285011 defendant Smyth Thomas husbandman 620728 620728 Smyth, Thomas, of Grymolby, husbandman 0
4788933 2292592 2292592 defendant Smyth Thomas husbandman 620728 620728 Smyth, Thomas, of Grymolby, husbandman 0
4797263 2295317 2295317 defendant Spenser John yeoman 620728 620728 Spenser, John, of Grymolby, yeoman 0
4810899 2299527 2299527 defendant Wolston John clerk 620728 620728 Wolston, John, of Grymolby, clerk 0
4812958 2300166 2300166 defendant Spenser John clerk & husbandman 620728 620728 Spenser, John, of Grymolby, clerk & husbandman 0
4814758 2300731 2300731 defendant Spencer John husbandman 620728 620728 Spencer, John, of Grymolby, husbandman 0
4818415 2301840 2301840 defendant Spenser John husbandman 620728 620728 Spenser, John, of Grymolby, husbandman 1
4822774 2303202 2303202 defendant Spenser John yeoman 620728 620728 Spenser, John, of Grymolby, yeoman 0
4837373 2307627 2307627 defendant Spencer John yeoman 620728 620728 Spencer, John, of Grymolby, yeoman 0
4837380 2307628 2307628 defendant Spencer John yeoman 620728 620728 Spencer, John, of Grymolby, yeoman 0
4862154 2315176 2315176 defendant Spencer John gent 620728 620728 Spencer, John, of Grymolby, gent 0
4876383 2319574 2319574 defendant Tomson John weaver 620728 620728 Tomson, John, of Grymolby, weaver 0
4890378 2323760 2323760 defendant Spenser John   620728 620728 Spenser, John, of Grymolby, franklin 2
4976032 2349797 2349797 defendant Spencer John gent 620728 620728 Spencer, John, of Grymolby, gent 6
5020316 2362830 2362830 defendant Spenser John gent 620728 620728 Spenser, John, of Grymolby, gent 3
5294194 2443274 2443274 defendant Bond Thomas husbandman 620728 620728 Bond, Thomas, of Grymolby, husbandman 1
5294204 2443275 2443275 defendant Bond Thomas husbandman 620728 620728 Bond, Thomas, of Grymolby, husbandman 1
5317639 2450362 2450362 defendant Bonde Thomas yeoman 620728 620728 Bonde, Thomas, of Grymolby, yeoman 1
5317640 2450362 2450362 defendant Bonde Thomas, junior yeoman 620728 620728 Bonde, Thomas, junior, of Grymolby, yeoman 2
5326339 2452967 2452967 defendant Bonde Thomas husbandman 620728 620728 Bonde, Thomas, of Grymolby, husbandman 1
5326350 2452968 2452968 defendant Bonde Thomas husbandman 620728 620728 Bonde, Thomas, of Grymolby, husbandman 2
5354636 2461526 2461526 defendant Bonde John merchant 620728 620728 Bonde, John, of Grymolby, merchant 0
5355230 2461708 2461708 defendant Bonde John merchant 620728 620728 Bonde, John, of Grymolby, merchant 0
5417796 2480247 2480247 defendant Mawe Robert laborer 620728 620728 Mawe, Robert, of Grymolby, laborer 3
5435242 2485472 2485472 defendant Mawe Robert laborer 620728 620728 Mawe, Robert, of Grymolby, laborer 3
5510109 2507998 2507998 defendant Bolde John chaplain 620728 620728 Bolde, John, of Grymolby, chaplain 2
5529793 2513828 2513828 defendant Bond John clerk 620728 620728 Bond, John, of Grymolby, clerk 0
5530448 2514039 2514039 defendant Fresshney John husbandman 620728 620728 Fresshney, John, of Grymolby, husbandman 2
5614002 2548152 2548152 plaintiff Dodyngton Henry de   620728 620728 Dodyngton, Henry de, of Grymolby, parson 0
5617728 2549374 2549374 defendant Fisshe William   620728 620728 Fisshe, William, of Grymolby 0
5627552 2552590 2552590 defendant Rouse Walter laborer 620728 620728 Rouse, Walter, of Grymolby, laborer 0
5631616 2553899 2553899 defendant Rouse Walter laborer 620728 620728 Rouse, Walter, of Grymolby, laborer 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);