names

91 rows where place_id = 586335

✎ 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
3588454 1864036 1864036 defendant Copley Christopher glover 586335 586335 Copley, Christopher, of Magna Badowe, glover 2
3607753 1870075 1870075 defendant Warden Christopher maltman 586335 586335 Warden, Christopher, of Magna Badowe, maltman 1
3615564 1872507 1872507 defendant Artur John yeoman 586335 586335 Artur, John, of Magna Badowe, yeoman 1
3627889 1903580 1903580 defendant Sturgeon William tanner 586335 586335 Sturgeon, William, of Magna Badowe, tanner 0
3628464 1903770 1903770 defendant Cok Thomas glover 586335 586335 Cok, Thomas, of Magna Badowe, glover 2
3640417 1907435 1907435 defendant Naylyngherst James gent 586335 586335 Naylyngherst, James, of Magna Badowe, gent 0
3640418 1907435 1907435 defendant Theyer Nicholas husbandman 586335 586335 Theyer, Nicholas, of Magna Badowe, husbandman 1
3640419 1907435 1907435 defendant Cok Thomas whitawer 586335 586335 Cok, Thomas, of Magna Badowe, whitawer 2
3640420 1907435 1907435 defendant Bankys Thomas tailor 586335 586335 Bankys, Thomas, of Magna Badowe, tailor 3
3640421 1907435 1907435 defendant Onghon James pulter 586335 586335 Onghon, James, of Magna Badowe, pulter 4
3640422 1907435 1907435 defendant Sturgeon William tanner 586335 586335 Sturgeon, William, of Magna Badowe, tanner 5
3640423 1907435 1907435 defendant Sturgeon John laborer 586335 586335 Sturgeon, John, of Magna Badowe, laborer 6
3640424 1907435 1907435 defendant Sturgeon Ralph pulter 586335 586335 Sturgeon, Ralph, of Magna Badowe, pulter 7
3640425 1907435 1907435 defendant Sturgeon Robert whitawer 586335 586335 Sturgeon, Robert, of Magna Badowe, whitawer 8
3641235 1907711 1907711 defendant Cok Thomas whitawer 586335 586335 Cok, Thomas, of Magna Badowe, whitawer 0
3646067 1909169 1909169 defendant Naylyngherst James gent 586335 586335 Naylyngherst, James, of Magna Badowe, gent 0
3646068 1909169 1909169 defendant Theyer Nicholas husbandman 586335 586335 Theyer, Nicholas, of Magna Badowe, husbandman 1
3646069 1909169 1909169 defendant Cok Thomas whitawer 586335 586335 Cok, Thomas, of Magna Badowe, whitawer 2
3646070 1909169 1909169 defendant Bankys Thomas tailor 586335 586335 Bankys, Thomas, of Magna Badowe, tailor 3
3646071 1909169 1909169 defendant Onghon James pulter 586335 586335 Onghon, James, of Magna Badowe, pulter 4
3646072 1909169 1909169 defendant Sturgeon William tanner 586335 586335 Sturgeon, William, of Magna Badowe, tanner 5
3646073 1909169 1909169 defendant Sturgeon John laborer 586335 586335 Sturgeon, John, of Magna Badowe, laborer 6
3646074 1909169 1909169 defendant Sturgeon Ralph pulter 586335 586335 Sturgeon, Ralph, of Magna Badowe, pulter 7
3646075 1909169 1909169 defendant Sturgeon Robert whitawer 586335 586335 Sturgeon, Robert, of Magna Badowe, whitawer 8
3678634 1919378 1919378 plaintiff Naylyngherst James gent 586335 586335 Naylyngherst, James, of Magna Badowe, gent 0
3684353 1921238 1921238 defendant Botelar John gent 586335 586335 Botelar, John, of Magna Badowe, gent 0
3684356 1921239 1921239 defendant Boteler John gent 586335 586335 Boteler, John, of Magna Badowe, gent 0
3685045 1921465 1921465 defendant Knyghtbreg John smith 586335 586335 Knyghtbreg, John, of Magna Badowe, smith 0
3685049 1921466 1921466 defendant Knyghtbreg John smith 586335 586335 Knyghtbreg, John, of Magna Badowe, smith 0
3685053 1921467 1921467 defendant Knyghtbrigge John smith 586335 586335 Knyghtbrigge, John, of Magna Badowe, smith 0
3693412 1924156 1924156 defendant Ame Edward gent 586335 586335 Ame, Edward, of Magna Badowe, gent 0
3694296 1924420 1924420 plaintiff Naylyngherst James   586335 586335 Naylyngherst, James, of Magna Badowe 0
3694966 1924637 1924637 defendant Clapton John husbandman 586335 586335 Clapton, John, of Magna Badowe, husbandman 0
3695615 1924856 1924856 defendant Boteler John gent 586335 586335 Boteler, John, of Magna Badowe, gent 0
3736322 1937602 1937602 defendant Butler John gent 586335 586335 Butler, John, of Magna Badowe, gent 2
3747517 1941138 1941138 defendant Clopton John butcher 586335 586335 Clopton, John, of Magna Badowe, butcher 4
3769632 1948161 1948161 defendant Sturgion William husbandman 586335 586335 Sturgion, William, of Magna Badowe, husbandman 0
3769634 1948161 1948161 defendant Chamberleyn Henry husbandman 586335 586335 Chamberleyn, Henry, of Magna Badowe, husbandman 2
3777279 1950639 1950639 defendant Bear John husbandman 586335 586335 Bear, John, of Magna Badowe, husbandman 1
3777280 1950639 1950639 defendant Hyllys Walter husbandman 586335 586335 Hyllys, Walter, of Magna Badowe, husbandman 2
3798277 1957357 1957357 defendant Lamberd John miller 586335 586335 Lamberd, John, of Magna Badowe, miller 0
3819160 1963879 1963879 defendant Hogh Robert carpenter 586335 586335 Hogh, Robert, of Magna Badowe, carpenter 1
3820969 1964453 1964453 defendant Holden Roger husbandman 586335 586335 Holden, Roger, of Magna Badowe, husbandman 2
3821293 1964552 1964552 defendant Turnour John   586335 586335 Turnour, John, of Magna Badowe, pale maker 0
3822914 1965073 1965073 defendant Mylborn John husbandman 586335 586335 Mylborn, John, of Magna Badowe, husbandman 0
3828674 1966847 1966847 defendant Naylynghurst James gent 586335 586335 Naylynghurst, James, of Magna Badowe, gent 0
3828676 1966847 1966847 defendant Holden Roger yeoman 586335 586335 Holden, Roger, of Magna Badowe, yeoman 2
3843567 1971525 1971525 defendant Holden Roger yeoman 586335 586335 Holden, Roger, of Magna Badowe, yeoman 1
3850664 1973795 1973795 defendant Hogh Robert yeoman 586335 586335 Hogh, Robert, of Magna Badowe, yeoman 4
3871888 1980834 1980834 defendant Taverner William yeoman 586335 586335 Taverner, William, of Magna Badowe, yeoman 0
3871889 1980834 1980834 defendant Watt William laborer 586335 586335 Watt, William, of Magna Badowe, laborer 1
3871890 1980834 1980834 defendant Hulk Thomas husbandman 586335 586335 Hulk, Thomas, of Magna Badowe, husbandman 2
3966774 2013014 2013014 plaintiff Brocke John yeoman 586335 586335 Brocke, John, of Magna Badowe, yeoman 0
3971042 2014427 2014427 plaintiff Drylonde James gent 586335 586335 Drylonde, James, of Magna Badowe, gent 0
4133388 2072265 2072265 defendant Pawmer William husbandman 586335 586335 Pawmer, William, of Magna Badowe, husbandman 0
4958806 2344607 2344607 defendant Sabryght William gent 586335 586335 Sabryght, William, of Magna Badowe, gent 0
5022823 2363586 2363586 defendant Hamond John husbandman 586335 586335 Hamond, John, of Magna Badowe, husbandman 1
5022824 2363586 2363586 defendant Rotheman John husbandman 586335 586335 Rotheman, John, of Magna Badowe, husbandman 2
5022825 2363586 2363586 defendant Thomas John weaver 586335 586335 Thomas, John, of Magna Badowe, weaver 3
5061414 2375001 2375001 defendant Yon or You Jpohn tanner 586335 586335 Yon or You, Jpohn, of Magna Badowe, tanner 1
5085338 2382104 2382104 defendant Curteys James pulter 586335 586335 Curteys, James, of Magna Badowe, pulter 0
5095766 2385184 2385184 defendant Curteys James pulter 586335 586335 Curteys, James, of Magna Badowe, pulter 1
5097356 2385656 2385656 defendant Banstrete Richard husbandman 586335 586335 Banstrete, Richard, of Magna Badowe, husbandman 0
5097358 2385657 2385657 defendant Theyre John fisher 586335 586335 Theyre, John, of Magna Badowe, fisher 0
5213205 2419590 2419590 defendant Knyghtbrygge William, senior smith 586335 586335 Knyghtbrygge, William, senior, of Magna Badowe, smith 0
5213206 2419590 2419590 defendant Wheler Henry tanner 586335 586335 Wheler, Henry, of Magna Badowe, tanner 1
5213207 2419590 2419590 defendant Gardener John cordwainer 586335 586335 Gardener, John, of Magna Badowe, cordwainer 2
5213209 2419591 2419591 defendant Knyghtbrygge William, senior smith 586335 586335 Knyghtbrygge, William, senior, of Magna Badowe, smith 0
5213210 2419591 2419591 defendant Wheler Henry tanner 586335 586335 Wheler, Henry, of Magna Badowe, tanner 1
5213211 2419591 2419591 defendant Gardener John cordwainer 586335 586335 Gardener, John, of Magna Badowe, cordwainer 2
5265885 2435085 2435085 plaintiff Toft William   586335 586335 Toft, William, of Magna Badowe 0
5267609 2435627 2435627 defendant Naylyngherst Hugh gent 586335 586335 Naylyngherst, Hugh, of Magna Badowe, gent 1
5294589 2443395 2443395 defendant Banstrete Richard husbandman 586335 586335 Banstrete, Richard, of Magna Badowe, husbandman 1
5317802 2450412 2450412 plaintiff Fox John clerk 586335 586335 Fox, John, of Magna Badowe, clerk 0
5317803 2450412 2450412 defendant Cutler John butcher 586335 586335 Cutler, John, of Magna Badowe, butcher 0
5317804 2450412 2450412 defendant Scott John husbandman 586335 586335 Scott, John, of Magna Badowe, husbandman 1
5318120 2450509 2450509 defendant Ponde William tanner 586335 586335 Ponde, William, of Magna Badowe, tanner 0
5482118 2499591 2499591 defendant Fen John smith 586335 586335 Fen, John, of Magna Badowe, smith 0
5484964 2500427 2500427 defendant Andrewe John fuller 586335 586335 Andrewe, John, of Magna Badowe, fuller 0
5489812 2501835 2501835 defendant Gegon Robert yeoman 586335 586335 Gegon, Robert, of Magna Badowe, yeoman 0
5500753 2505166 2505166 defendant Courteman John yeman 586335 586335 Courteman, John, of Magna Badowe, yeman 1
5509815 2507905 2507905 defendant Canon John butcher 586335 586335 Canon, John, of Magna Badowe, butcher 1
5509818 2507906 2507906 defendant Canon John butcher 586335 586335 Canon, John, of Magna Badowe, butcher 1
5510087 2507991 2507991 defendant Fen John smith 586335 586335 Fen, John, of Magna Badowe, smith 1
5535898 2515730 2515730 defendant Bereman Richard husbandman 586335 586335 Bereman, Richard, of Magna Badowe, husbandman 2
5535899 2515730 2515730 defendant Pecchy Richard laborer 586335 586335 Pecchy, Richard, of Magna Badowe, laborer 3
5535900 2515730 2515730 defendant Sponer Edward laborer 586335 586335 Sponer, Edward, of Magna Badowe, laborer 4
5539731 2516907 2516907 defendant Tayllour William husbandman 586335 586335 Tayllour, William, of Magna Badowe, husbandman 2
5565024 2524356 2524356 defendant Sturgeon William tanner 586335 586335 Sturgeon, William, of Magna Badowe, tanner 3
5565025 2524356 2524356 defendant Wheler William tanner 586335 586335 Wheler, William, of Magna Badowe, tanner 4
5587664 2531157 2531157 defendant Sturgeon John tanner 586335 586335 Sturgeon, John, of Magna Badowe, tanner 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);