names

46 rows where place_id = 599653

✎ 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
3637607 1906572 1906572 defendant Homstede John husbandman 599653 599653 Homstede, John, of Buklond, husbandman 1
3645588 1909014 1909014 defendant Fenyng Thomas husbandman 599653 599653 Fenyng, Thomas, of Buklond, husbandman 0
3652876 1911225 1911225 defendant Warner Henry maltman 599653 599653 Warner, Henry, of Buklond, maltman 0
3687755 1922336 1922336 defendant Frenche Walter husbandman 599653 599653 Frenche, Walter, of Buklond, husbandman 3
3699715 1926138 1926138 defendant Wadlond Joan widow 599653 599653 Wadlond, Joan, of Buklond Fyller, widow 0
3715323 1931076 1931076 defendant Moreman John husbandman 599653 599653 Moreman, John, of Buklond, brewer, husbandman 0
3722021 1933150 1933150 defendant Cokson John husbandman 599653 599653 Cokson, John, of Buklond, husbandman 0
3722024 1933151 1933151 defendant Cokson John husbandman 599653 599653 Cokson, John, of Buklond, husbandman 0
3735030 1937193 1937193 defendant Josse Mark husbandman 599653 599653 Josse, Mark, of Buklond, husbandman 0
3756165 1943887 1943887 defendant Jeffray Joan widow 599653 599653 Jeffray, Joan, of Buklond, brewer, widow 0
3757194 1944232 1944232 defendant Herde Thomas husbandman 599653 599653 Herde, Thomas, of Buklond Brewer, husbandman 0
3757195 1944232 1944232 defendant Meddon or Meddou John husbandman 599653 599653 Meddon or Meddou, John, of Buklond Brewer, husbandman 1
3763072 1946081 1946081 defendant Ley John husbandman 599653 599653 Ley, John, of Buklond Brewer, husbandman 0
3763073 1946081 1946081 defendant Josse Mark husbandman 599653 599653 Josse, Mark, of Buklond Brewer, husbandman 1
3781145 1951839 1951839 defendant Ley John husbandman 599653 599653 Ley, John, of Buklond Brewer, husbandman 0
3816033 1962915 1962915 defendant Worcetur Agnes   599653 599653 Worcetur, Agnes, of Buklond 0
3842021 1971058 1971058 defendant Houchyn of Honchyn John husbandman 599653 599653 Houchyn of Honchyn, John, of Buklond, husbandman 0
3848332 1973053 1973053 defendant Coole Simon laborer 599653 599653 Coole, Simon, of Buklond, laborer 2
3864088 1978173 1978173 plaintiff Kyng Richard   599653 599653 Kyng, Richard, of Buklond 0
3869915 1980182 1980182 defendant Taylour James laborer 599653 599653 Taylour, James, of Buklond, laborer 2
3871956 1980854 1980854 defendant Alford Walter tucker 599653 599653 Alford, Walter, of Buklond Bruer, tucker 0
3883739 1984831 1984831 defendant Taillour James laborer 599653 599653 Taillour, James, of Buklond, laborer 4
3942744 2004576 2004576 defendant Combe William husbandman 599653 599653 Combe, William, of Buklond, husbandman 0
4657435 2248217 2248217 defendant Daunser Walter husbandman 599653 599653 Daunser, Walter, of Buklond, husbandman 0
4706632 2267455 2267455 defendant Palfrayman John husbandman 599653 599653 Palfrayman, John, of Buklond, husbandman 0
4792795 2293836 2293836 defendant Alward Walter husbandman 599653 599653 Alward, Walter, of Buklond, husbandman 0
5024617 2364113 2364113 plaintiff Horn John   599653 599653 Horn, John, of Buklond 0
5078875 2380169 2380169 defendant Hever James butcher 599653 599653 Hever, James, of Buklond, butcher 0
5087252 2382651 2382651 defendant Gille William maltman 599653 599653 Gille, William, of Buklond, maltman 0
5093478 2384492 2384492 defendant Saunder Robert tucker 599653 599653 Saunder, Robert, of Buklond Brewer, tucker 2
5093479 2384492 2384492 defendant Baret John tucker 599653 599653 Baret, John, of Buklond Brewer, tucker 3
5206833 2417735 2417735 defendant Worcestre Richard gent 599653 599653 Worcestre, Richard, of Buklond, gent 0
5391607 2472667 2472667 defendant Smyth Robert sawyer 599653 599653 Smyth, Robert, of Buklond, sawyer 0
5404226 2476285 2476285 defendant Robynson Thomas smith 599653 599653 Robynson, Thomas, of Buklond, smith 0
5404640 2476401 2476401 defendant Smyth alias Whyler Robert sawyer 599653 599653 Smyth alias Whyler, Robert, of Buklond, sawyer 0
5417785 2480243 2480243 defendant Smyth Robert sawyer 599653 599653 Smyth, Robert, of Buklond, sawyer 0
5417787 2480244 2480244 defendant Smyth Robert sawyer 599653 599653 Smyth, Robert, of Buklond, sawyer 0
5419870 2480857 2480857 defendant Thorn Edward husbandman 599653 599653 Thorn, Edward, of Buklond, husbandman 0
5456055 2491727 2491727 defendant Olyver Thomas   599653 599653 Olyver, Thomas, of Buklond, abbot of the house of the BM 0
5456057 2491728 2491728 defendant Olyver Thomas   599653 599653 Olyver, Thomas, of Buklond, abbot of the house of the BM 0
5462915 2493818 2493818 defendant Hope Richard yeoman 599653 599653 Hope, Richard, of Buklond, yeoman 0
5467889 2495337 2495337 defendant Olyver Thomas   599653 599653 Olyver, Thomas, of Buklond, abbot of the house & church of the BM 0
5474451 2497340 2497340 defendant Hope Richard yeoman 599653 599653 Hope, Richard, of Buklond, yeoman 0
5569322 2525586 2525586 defendant Charlwode Richard husbandman 599653 599653 Charlwode, Richard, of Buklond, husbandman 0
5605064 2536454 2536454 defendant Colyns Erveborwa widow 599653 599653 Colyns, Erveborwa, of Buklond, widow 1
5610375 2546955 2546955 plaintiff Ayssh John   599653 599653 Ayssh, John, of Buklond 0

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