names

39 rows where place_id = 589467

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: role, surname, forename, occupation, raw_segment, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3597713 1866906 1866906 defendant FitzHugh William gent 589467 589467 FitzHugh, William, of Ampthill, Beds, gent 7
3607102 1869886 1869886 defendant Grey George   589467 589467 Grey, George, of Ampthill, Beds, Earl of Kent 0
3737937 1938080 1938080 defendant Butte William gent 589467 589467 Butte, William, of Ampthill, Beds, gent 0
4184180 2089961 2089961 defendant Doughtye Hugh shoemaker 589467 589467 Doughtye, Hugh, of Ampthill, Beds, shoemaker 0
4207926 2098330 2098330 defendant Doughtye Hugh shoemaker 589467 589467 Doughtye, Hugh, of Ampthill, Beds, shoemaker 0
4267464 2118752 2118752 defendant Stockwell Alexander clerk 589467 589467 Stockwell, Alexander, of Ampthill, Beds, clerk 0
4302265 2130908 2130908 defendant Woodward Edward mercer 589467 589467 Woodward, Edward, of Ampthill, Beds, mercer 0
4360249 2150832 2150832 defendant Woodward Edward chapman 589467 589467 Woodward, Edward, of Ampthill, Beds, chapman 0
4712943 2269362 2269362 defendant Cook John   589467 589467 Cook, John, of Ampthill, Beds, franklin 1
4712946 2269363 2269363 defendant Taillour William butcher 589467 589467 Taillour, William, of Ampthill, Beds, butcher 1
4712954 2269365 2269365 defendant Bocher William husbandman 589467 589467 Bocher, William, of Ampthill, Beds, husbandman 1
4766910 2285641 2285641 defendant Lawe William yeoman 589467 589467 Lawe, William, of Ampthill, Beds, yeoman 1
4960187 2345018 2345018 defendant Foster John husbandman 589467 589467 Foster, John, of Ampthill, Beds, husbandman 4
4971561 2348424 2348424 defendant Bykerstaf John smith or yeoman 589467 589467 Bykerstaf, John, of Ampthill, Beds, smith or yeoman 0
4985721 2352646 2352646 defendant Malcote John clerk 589467 589467 Malcote, John, of Ampthill, Beds, clerk 0
4985722 2352647 2352647 plaintiff Alford Adam gent 589467 589467 Alford, Adam, of Ampthill, Beds, gent 0
5090981 2383758 2383758 defendant Alford Agnes widow 589467 589467 (Alford, Agnes, of Ampthill, Beds, widow 1
5090987 2383759 2383759 defendant Alford Agnes widow 589467 589467 (Alford, Agnes, of Ampthill, Beds, widow 1
5154782 2402555 2402555 defendant Grey Edmund   589467 589467 Grey, Edmund, of Ampthill, Beds, knight & lord of Hastyng, Weyfford & of Ruthyn 1
5154785 2402556 2402556 defendant Grey Edmund   589467 589467 Grey, Edmund, of Ampthill, Beds, knight, lord of Hastings, Weyfford & Ruthyn 1
5154938 2402601 2402601 defendant Grey Edmund   589467 589467 Grey, Edmund, of Ampthill, Beds, knight 0
5171772 2407465 2407465 defendant Grey Edmund   589467 589467 Grey, Edmund, of Ampthill, Beds, knight 0
5177823 2409217 2409217 defendant Banbury John yeoman 589467 589467 Banbury, John, of Ampthill, Beds, yeoman 0
5185958 2411640 2411640 defendant Yong Thomas yeoman 589467 589467 Yong, Thomas, of Ampthill, Beds, yeoman 1
5190513 2412970 2412970 defendant Grey Edmund   589467 589467 Grey, Edmund, of Ampthill, Beds, knight, lord of Ruthin 0
5221848 2422089 2422089 defendant Grey Edmund   589467 589467 Grey, Edmund, of Ampthill, Beds, knight, Lord Grey of Ruthyn 0
5221852 2422090 2422090 defendant Grey Edmund   589467 589467 Grey, Edmund, of Ampthill, Beds, knight, Lord Grey of Ruthyn 0
5221856 2422091 2422091 defendant Grey Edmund   589467 589467 Grey, Edmund, of Ampthill, Beds, knight, Lord Grey of Ruthyn 0
5221860 2422092 2422092 defendant Grey Edmund   589467 589467 Grey, Edmund, of Ampthill, Beds, knight, Lord Grey of Ruthyn 0
5221864 2422093 2422093 defendant Grey Edmund   589467 589467 Grey, Edmund, of Ampthill, Beds, knight, Lord Grey of Ruthyn 0
5223278 2422502 2422502 defendant Colmore John mercer 589467 589467 Colmore, John, of Ampthill, Beds, mercer 1
5223281 2422503 2422503 defendant Colmore John mercer 589467 589467 Colmore, John, of Ampthill, Beds, mercer 1
5237171 2426455 2426455 defendant Barnard Thomas chapman 589467 589467 Barnard, Thomas, of Ampthill, Beds, chapman 3
5237179 2426457 2426457 defendant Bernard Thomas chapman 589467 589467 Bernard, Thomas, of Ampthill, Beds, chapman 3
5238883 2426961 2426961 defendant Hay William husbandman 589467 589467 Hay, William, of Ampthill, Beds, husbandman 3
5260885 2433526 2433526 defendant Grey Edmund   589467 589467 Grey, Edmund, of Ampthill, Beds, knight, Lord Grey of Ruthyn 0
5288619 2441690 2441690 defendant Hertyshorn John esq 589467 589467 Hertyshorn, John, of Ampthill, Beds, esq 0
5306216 2446844 2446844 defendant Benbowe John chaplain 589467 589467 Benbowe, John, of Ampthill, Beds, chaplain 4
5512840 2508870 2508870 defendant Marbury John gent 589467 589467 Marbury, John, of Ampthill, Beds, gent 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);