names

47 rows where place_id = 607738

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3670633 1916780 1916780 defendant Harvey John husbandman 607738 607738 Harvey, John, of Sandon, Herts, husbandman 0
3670699 1916797 1916797 defendant Crede William husbandman 607738 607738 Crede, William, of Sandon, Herts, husbandman 4
3675219 1918284 1918284 defendant Pratt Simon yeoman 607738 607738 Pratt, Simon, of Sandon, Herts, yeoman 0
3696915 1925255 1925255 defendant Cormonger Robert gent 607738 607738 Cormonger, Robert, of Sandon, Herts, gent 2
3696919 1925256 1925256 defendant Cormonger Robert gent 607738 607738 Cormonger, Robert, of Sandon, Herts, gent 2
3709413 1929243 1929243 defendant Edward Thomas laborer 607738 607738 Edward, Thomas, of Sandon, Herts, laborer 2
3741919 1939337 1939337 defendant Pratte Simon yeoman 607738 607738 Pratte, Simon, of Sandon, Herts, yeoman 1
3754248 1943280 1943280 defendant Pratt Simon yeoman 607738 607738 Pratt, Simon, of Sandon, Herts, yeoman 1
3786666 1953623 1953623 plaintiff Pratte SImon yeoman 607738 607738 Pratte, SImon, of Sandon, Herts, yeoman 0
3786668 1953624 1953624 plaintiff Pratte Simon yeoman 607738 607738 Pratte, Simon, of Sandon, Herts, yeoman 0
3789153 1954417 1954417 defendant Pratt Simon yeoman 607738 607738 Pratt, Simon, of Sandon, Herts, yeoman 0
4023198 2033007 2033007 plaintiff Bardeney Robert maltster 607738 607738 Bardeney, Robert, of Sandon, Herts, laborer, maltster 0
4023204 2033008 2033008 plaintiff Bardeney Robert maltster 607738 607738 Bardeney, Robert, of Sandon, Herts, laborer, maltster 0
4040500 2039095 2039095 defendant Harvye Simon husbandman 607738 607738 Harvye, Simon, of Sandon, Herts, husbandman 0
4076370 2051847 2051847 defendant Hyde William, senior esq 607738 607738 Hyde, William, senior, of Sandon, Herts, esq 0
4111708 2064435 2064435 defendant Rey Stephen maltman 607738 607738 Rey, Stephen, of Sandon, Herts, maltman 2
4255813 2114919 2114919 defendant Graye Thomas yeoman 607738 607738 Graye, Thomas, of Sandon, Herts, yeoman 1
4259128 2116026 2116026 defendant Newporte Edward gent 607738 607738 Newporte, Edward, of Sandon, Herts, gent 0
4266342 2118384 2118384 defendant Lorymer William husbandman 607738 607738 Lorymer, William, of Sandon, Herts, husbandman 2
4337584 2142889 2142889 defendant Blowes Giles husbandman 607738 607738 Blowes, Giles, of Sandon, Herts, husbandman 0
4351207 2147672 2147672 defendant Edward John yeoman 607738 607738 Edward, John, of Sandon, herts, yeoman 1
4355694 2149214 2149214 defendant Branfeild William clerk 607738 607738 Branfeild, William, of Sandon, Herts, clerk 0
4357223 2149754 2149754 defendant Hayward Simon   607738 607738 Hayward, Simon, of Sandon, Herts, "kydder" 0
4386380 2160123 2160123 defendant Blowes Giles husbandman 607738 607738 Blowes, Giles, of Sandon, Herts, husbandman 0
4524392 2207967 2207967 defendant Chambirleyn John   607738 607738 Chambirleyn, John, of Sandon, Herts, bailiff 0
4574142 2223435 2223435 defendant fitzs Geffrey William   607738 607738 fitzs Geffrey, William, of Sandon, Herts 0
4657804 2248328 2248328 defendant Whyteman William   607738 607738 Whyteman, William, of Sandon, Herts, chopchurch 0
4774679 2288069 2288069 defendant Kyng William husbandman 607738 607738 Kyng, William, of Sandon, Herts, husbandman 1
4800427 2296314 2296314 defendant Kyng William husbandman 607738 607738 Kyng, William, of Sandon, Herts, husbandman 1
4826559 2304341 2304341 defendant Pratte John maltman 607738 607738 Pratte, John, of Sandon, Herts, maltman 0
4871021 2317911 2317911 defendant Piers John husbandman 607738 607738 Piers, John, of Sandon, Herts, husbandman 1
4893262 2324602 2324602 defendant Nook Simon husbandman 607738 607738 Nook, Simon, of Sandon, Herts, husbandman 2
5131002 2395551 2395551 defendant Walter Robert yeoman & of the King's Hospice 607738 607738 Walter, Robert, of Sandon, Herts, yeoman & of the King's Hospice 0
5165848 2405755 2405755 defendant Prat Richard husbandman 607738 607738 Prat, Richard, of Sandon, Herts, husbandman 0
5206023 2417494 2417494 defendant Sandon Thomas yeoman 607738 607738 Sandon, Thomas, of Sandon, Herts, yeoman 1
5224263 2422768 2422768 defendant Pratte Richard husbandman 607738 607738 Pratte, Richard, of Sandon, Herts, husbandman 0
5232077 2424954 2424954 defendant Sandon Thomas yeoman 607738 607738 Sandon, Thomas, of Sandon, Herts, yeoman 0
5239220 2427058 2427058 defendant Sandon Thomas husbandman 607738 607738 Sandon, Thomas, of Sandon, Herts, husbandman 2
5239225 2427059 2427059 defendant Sandon Thomas husbandman 607738 607738 Sandon, Thomas, of Sandon, Herts, husbandman 2
5248695 2429741 2429741 defendant Sandon Thomas chapman 607738 607738 Sandon, Thomas, of Sandon, Herts, chapman 0
5265515 2434977 2434977 defendant Sandon Thomas chapman 607738 607738 Sandon, Thomas, of Sandon, Herts, chapman 0
5271872 2436861 2436861 defendant Foltmer John husbandman 607738 607738 Foltmer, John, of Sandon, Herts, husbandman 6
5515763 2509775 2509775 defendant Twhayt William smith 607738 607738 Twhayt, William, of Sandon, Herts, smith 3
5521656 2511589 2511589 defendant FitzGeffrey John gent 607738 607738 FitzGeffrey, John, of Sandon, Herts, gent 0
5568355 2525290 2525290 defendant FitzJeffrey John esq 607738 607738 FitzJeffrey, John, of Sandon, Herts, esq 0
5568367 2525294 2525294 defendant FitzGeffrey John esq 607738 607738 FitzGeffrey, John, of Sandon, Herts, esq 0
5569752 2525723 2525723 defendant Sewall William gent 607738 607738 Sewall, William, of Sandon, Herts, gent 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);