names

65 rows where place_id = 599887

✎ 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
3638669 1906907 1906907 defendant Dardes Edmund husbandman 599887 599887 Dardes, Edmund, of Codycote, husbandman 0
3638670 1906907 1906907 defendant Portose John, senior husbandman 599887 599887 Portose, John, senior, of Codycote, husbandman 1
3638671 1906907 1906907 defendant Kympton Thomas husbandman 599887 599887 Kympton, Thomas, of Codycote, husbandman 2
3649867 1910322 1910322 defendant Monke Rober laborer 599887 599887 Monke, Rober, of Codycote, laborer 1
3692543 1923855 1923855 defendant Datys Edmund husbandman 599887 599887 Datys, Edmund, of Codycote, husbandman 1
3721233 1932942 1932942 defendant Harmer William husbandman 599887 599887 Harmer, William, of Codycote, husbandman 3
3775412 1950055 1950055 defendant Waren Robert miller 599887 599887 Waren, Robert, of Codycote, miller 0
3833088 1968273 1968273 defendant Camfeld John miller 599887 599887 Camfeld, John, of Codycote, miller 1
3834155 1968625 1968625 plaintiff Michell John   599887 599887 Michell, John, of Codycote 0
4056267 2044626 2044626 defendant Resynge William husbandman 599887 599887 Resynge, William, of Codycote, husbandman 0
4552706 2216798 2216798 defendant Wrenne John   599887 599887 Wrenne, John, of Codycote 0
4561876 2219648 2219648 defendant Pulter John   599887 599887 Pulter, John, of Codycote 0
4563486 2220152 2220152 defendant Foulemere John   599887 599887 (Foulemere, John, of Codycote 1
4649600 2245915 2245915 defendant Pulter John   599887 599887 Pulter, John, of Codycote 3
4665807 2250782 2250782 defendant Pulter John   599887 599887 Pulter, John, of Codycote, bailiff 0
4718636 2271168 2271168 defendant Brode John clerk 599887 599887 Brode, John, of Codycote, clerk 0
4752757 2281262 2281262 defendant Wrenne John husbandman 599887 599887 Wrenne, John, of Codycote, husbandman 0
4752758 2281262 2281262 defendant Wrenne William laborer 599887 599887 Wrenne, William, of Codycote, laborer 1
4752759 2281262 2281262 defendant Wrenne Reginald laborer 599887 599887 Wrenne, Reginald, of Codycote, laborer 2
4752760 2281262 2281262 defendant Wrenne Henry husbandman 599887 599887 Wrenne, Henry, of Codycote, husbandman 3
4773910 2287819 2287819 defendant Wrenne John husbandman 599887 599887 Wrenne, John, of Codycote, husbandman 0
4773911 2287819 2287819 defendant Wrenne William laborer 599887 599887 Wrenne, William, of Codycote, laborer 1
4773912 2287819 2287819 defendant Wrenne Reginald laborer 599887 599887 Wrenne, Reginald, of Codycote, laborer 2
4773913 2287819 2287819 defendant Wrenne Henry husbandman 599887 599887 Wrenne, Henry, of Codycote, husbandman 3
4786052 2291676 2291676 defendant Leper Robert smith 599887 599887 Leper, Robert, of Codycote, smith 0
4786053 2291676 2291676 defendant Leper Thomas, junior smith 599887 599887 Leper, Thomas, junior, of Codycote, smith 1
4786054 2291676 2291676 defendant Hall John husbandman 599887 599887 Hall, John, of Codycote, husbandman 2
4801563 2296671 2296671 defendant Monwode John husbandman 599887 599887 Monwode, John, of Codycote, husbandman 0
4855631 2313129 2313129 defendant Ledbeter Thomas husbandman 599887 599887 Ledbeter, Thomas, of Codycote, husbandman 0
4863020 2315411 2315411 defendant Pulter John yeoman 599887 599887 Pulter, John, of Codycote, yeoman 1
4876939 2319756 2319756 defendant Manwode William husbandman 599887 599887 Manwode, William, of Codycote, husbandman 0
4876940 2319756 2319756 defendant Byllyngford John husbandman 599887 599887 Byllyngford, John, of Codycote, husbandman 1
4876941 2319756 2319756 defendant Martyn John husbandman 599887 599887 Martyn, John, of Codycote, husbandman 2
4876942 2319756 2319756 defendant Stoneham Richard husbandman 599887 599887 Stoneham, Richard, of Codycote, husbandman 3
4876943 2319756 2319756 defendant North Walter laborer 599887 599887 North, Walter, of Codycote, laborer 4
4895537 2325271 2325271 defendant Leper John husbandman 599887 599887 Leper, John, of Codycote, husbandman 0
4913061 2330582 2330582 defendant Amerey John laborer 599887 599887 Amerey, John, of Codycote, laborer 0
4970989 2348264 2348264 defendant Ledebetyr Thomas husbandman 599887 599887 Ledebetyr, Thomas, of Codycote, husbandman 2
4970995 2348265 2348265 defendant Ledebetyr Thomas husbandman 599887 599887 Ledebetyr, Thomas, of Codycote, husbandman 2
4982440 2351669 2351669 defendant White Thomas husbandman 599887 599887 White, Thomas, of Codycote, husbandman 1
4983527 2351989 2351989 defendant Ledebeter Thomas husbandman 599887 599887 Ledebeter, Thomas, of Codycote, husbandman 0
5021279 2363125 2363125 defendant Leper Robert smith 599887 599887 Leper, Robert, of Codycote, smith 0
5021949 2363315 2363315 defendant Leper Robert smith 599887 599887 Leper, Robert, of Codycote, smith 0
5049695 2371531 2371531 defendant Beswethe Richard husbandman 599887 599887 Beswethe, Richard, of Codycote, husbandman 1
5057853 2373918 2373918 defendant Dardys John, senior husbandman 599887 599887 Dardys, John, senior, of Codycote, husbandman 2
5087815 2382817 2382817 defendant Baker John   599887 599887 Baker, John, of Codycote, butcher, alias Sele, John, of Watton atte Stone 1
5143472 2399223 2399223 defendant atte Hethe John husbandman 599887 599887 atte Hethe, John, of Codycote, husbandman 3
5223089 2422462 2422462 defendant Dardus John, senior husbandman 599887 599887 Dardus, John, senior, of Codycote, husbandman 0
5223090 2422462 2422462 defendant Dardus John, junior husbandman 599887 599887 Dardus, John, junior, of Codycote, husbandman 1
5223091 2422462 2422462 defendant Dardus Robert laborer 599887 599887 Dardus, Robert, of Codycote, laborer 2
5223092 2422462 2422462 defendant Cokrede William yeoman 599887 599887 Cokrede, William, of Codycote, yeoman 3
5224454 2422820 2422820 defendant Martyn John husbandman 599887 599887 Martyn, John, of Codycote, husbandman 4
5276668 2438258 2438258 defendant Parke William husbandman 599887 599887 Parke, William, of Codycote, husbandman 0
5277036 2438366 2438366 defendant Hethe John, junior laborer 599887 599887 Hethe, John, junior, of Codycote, laborer 0
5277037 2438366 2438366 defendant Cokerede George yeoman 599887 599887 Cokerede, George, of Codycote, yeoman 1
5278172 2438711 2438711 defendant Hethe John, senior husbandman 599887 599887 Hethe, John, senior, of Codycote, husbandman 0
5304724 2446409 2446409 defendant Dardes John husbandman 599887 599887 Dardes, John, of Codycote, husbandman 0
5318971 2450767 2450767 defendant Dardus John, senior husbandman 599887 599887 Dardus, John, senior, of Codycote, husbandman 0
5436002 2485707 2485707 defendant Crabbe Thomas husbandman 599887 599887 Crabbe, Thomas, of Codycote, husbandman 0
5462605 2493727 2493727 defendant Gefferey William   599887 599887 Gefferey, William, of Codycote, wheel wright 1
5462610 2493728 2493728 defendant Gefferey William   599887 599887 Gefferey, William, of Codycote, wheel wright 1
5483066 2499878 2499878 plaintiff Hyche Thomas   599887 599887 Hyche, Thomas, of Codycote, yeoman, administrators of 0
5596045 2533676 2533676 defendant Hale William husbandman 599887 599887 Hale, William, of Codycote, husbandman 0
5604536 2536280 2536280 defendant Chenall or Chevall Edmund gent 599887 599887 Chenall or Chevall, Edmund, of Codycote, gent 3
5604537 2536280 2536280 defendant Bygge Thomas husbandman 599887 599887 Bygge, Thomas, of Codycote, husbandman 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);