names

63 rows where place_id = 605829

✎ 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
3663036 1914352 1914352 defendant Whitfeld John yeoman 605829 605829 Whitfeld, John, of Hatton, yeoman 0
3771426 1948755 1948755 defendant Whitmore Thomas husbandman 605829 605829 Whitmore, Thomas, of Hatton, husbandman 0
3771427 1948755 1948755 defendant Mosse William husbandman 605829 605829 Mosse, William, of Hatton, husbandman 1
3771428 1948755 1948755 defendant Colear John husbandman 605829 605829 Colear, John, of Hatton, husbandman 2
3771800 1948879 1948879 defendant Smyth Roger yeoman 605829 605829 Smyth, Roger, of Hatton, yeoman 0
3798783 1957533 1957533 defendant Fote John husbandman 605829 605829 Fote, John, of Hatton, husbandman 4
3874320 1981637 1981637 defendant Stathum Richard husbandman 605829 605829 Stathum, Richard, of Hatton, husbandman 0
3906462 1992455 1992455 defendant Stathom Robert husbandman 605829 605829 Stathom, Robert, of Hatton, husbandman 0
3917599 1996246 1996246 plaintiff Hall John husbandman 605829 605829 Hall, John, of Hatton, husbandman 0
4039360 2038703 2038703 defendant Aronden Edward yeoman 605829 605829 Aronden, Edward, of Hatton, yeoman 1
4070040 2049572 2049572 defendant Hamond Roland yeoman 605829 605829 Hamond, Roland, of Hatton, yeoman 0
4161547 2082108 2082108 defendant Weale John husbandman 605829 605829 Weale, John, of Hatton, husbandman 3
4176331 2087200 2087200 defendant Hale Robert yeoman 605829 605829 Hale, Robert, of Hatton, yeoman 1
4176336 2087201 2087201 defendant Halle Robert yeoman 605829 605829 Halle, Robert, of Hatton, yeoman 1
4202066 2096266 2096266 defendant Savyle Thomas gent 605829 605829 Savyle, Thomas, of Hatton, gent 0
4215271 2100837 2100837 defendant Hewes Thomas yeoman 605829 605829 Hewes, Thomas, of Hatton, yeoman 1
4217590 2101647 2101647 defendant Lewes Mathew gent 605829 605829 Lewes, Mathew, of Hatton, gent 0
4217591 2101647 2101647 defendant Yomans Richard husbandman 605829 605829 Yomans, Richard, of Hatton, husbandman 1
4224697 2104111 2104111 defendant Hewes Thomas yeoman 605829 605829 Hewes, Thomas, of Hatton, yeoman 1
4236890 2108479 2108479 defendant Dayntrye Tristram yeoman 605829 605829 Dayntrye, Tristram, of Hatton, yeoman 0
4281670 2123494 2123494 defendant Cowper Richard husbandman 605829 605829 Cowper, Richard, of Hatton, husbandman 0
4290565 2126684 2126684 defendant Cowper Richard husbandman 605829 605829 Cowper, Richard, of Hatton, husbandman 0
4325172 2138799 2138799 defendant Ince Thomas yeoman 605829 605829 Ince, Thomas, of Hatton, yeoman 0
4325533 2138914 2138914 defendant Whitmore Thomas husbandman 605829 605829 Whitmore, Thomas, of Hatton, husbandman 0
4361479 2151267 2151267 defendant Porter Nicholas husbandman 605829 605829 Porter, Nicholas, of Hatton, husbandman 0
4382381 2158807 2158807 defendant Tedd Thomas husbandman 605829 605829 Tedd, Thomas, of Hatton, husbandman 2
4424615 2172539 2172539 plaintiff Kete Richard le   605829 605829 Kete, Richard le, of Hatton 0
4477390 2193594 2193594 plaintiff Grene William   605829 605829 Grene, William, of Hatton 0
4519227 2206366 2206366 defendant Foston John de   605829 605829 Foston, John de, of Hatton, parson 0
4587962 2227633 2227633 defendant Calowe Thomas   605829 605829 Calowe, Thomas, of Hatton 0
4610609 2234386 2234386 plaintiff Cave or Cane John (legal representative) 605829 605829 Cave or Cane, John, of Hatton, executors of 0
4610611 2234386 2234386 plaintiff Forster William   605829 605829 Forster, William, of Hatton 2
4675974 2258096 2258096 defendant Milward Henry yeoman 605829 605829 Milward, Henry, of Hatton, yeoman 0
4689963 2262414 2262414 defendant Machon Robert   605829 605829 Machon, Robert, of Hatton 0
4689965 2262415 2262415 defendant Machon Robert   605829 605829 Machon, Robert, of Hatton 0
4693345 2263422 2263422 defendant Beamond Thomas husbandman 605829 605829 Beamond, Thomas, of Hatton, husbandman 3
4693346 2263422 2263422 defendant Henbrok Richard husbandman 605829 605829 Henbrok, Richard, of Hatton, husbandman 4
4724254 2272881 2272881 defendant Townesende William husbandman 605829 605829 Townesende, William, of Hatton, husbandman 0
4731835 2275144 2275144 defendant Selley John yeoman 605829 605829 Selley, John, of Hatton, yeoman 2
4739593 2277458 2277458 defendant Brokilsby William   605829 605829 Brokilsby, William, of Hatton 2
4766756 2285593 2285593 defendant Edrych John husbandman 605829 605829 Edrych, John, of Hatton, husbandman 3
4791192 2293346 2293346 defendant Edryche John laborer 605829 605829 Edryche, John, of Hatton, laborer 2
4844161 2309682 2309682 defendant Daventre John husbandman 605829 605829 Daventre, John, of Hatton, husbandman 5
4886521 2322647 2322647 defendant Milward Henry yeoman 605829 605829 Milward, Henry, of Hatton, yeoman 0
4886522 2322647 2322647 defendant Warcowe Robert yeoman 605829 605829 Warcowe, Robert, of Hatton, yeoman 1
4906239 2328542 2328542 defendant Waiko Robert yeoman 605829 605829 Waiko, Robert, of Hatton, yeoman 1
4968316 2347485 2347485 defendant West John husbandman 605829 605829 West, John, of Hatton, husbandman 1
4992612 2354672 2354672 defendant Astell Thomas yeoman 605829 605829 Astell, Thomas, of Hatton, yeoman 0
4992615 2354672 2354672 defendant Boteler John husbandman 605829 605829 Boteler, John, of Hatton, husbandman 3
4993604 2354961 2354961 defendant Austyn Thomas husbandman 605829 605829 Austyn, Thomas, of Hatton, husbandman 1
5001618 2357364 2357364 defendant Austyn Thomas   605829 605829 Austyn, Thomas, of Hatton, bailiff 3
5023096 2363663 2363663 defendant Prene or Preve William husbandman 605829 605829 Prene or Preve, William, of Hatton, husbandman 2
5075908 2379288 2379288 defendant Webys Thomas yeoman 605829 605829 Webys, Thomas, of Hatton, yeoman 2
5089694 2383359 2383359 defendant Rose Richard husbandman 605829 605829 Rose, Richard, of Hatton, husbandman 1
5126499 2394227 2394227 defendant Wenns (illegible) yeoman 605829 605829 Wenns, ----, of Hatton, yeoman 1
5246990 2429283 2429283 defendant Smyth John husbandman 605829 605829 Smyth, John, of Hatton, husbandman 0
5262836 2434118 2434118 defendant Iremonger Thomas laborer 605829 605829 Iremonger, Thomas, of Hatton, laborer 4
5262842 2434119 2434119 defendant Iremonger Thomas laborer 605829 605829 Iremonger, Thomas, of Hatton, laborer 4
5366779 2465267 2465267 defendant Rogers John yeoman 605829 605829 Rogers, John, of Hatton, yeoman 0
5366787 2465268 2465268 defendant Rogers John yeoman 605829 605829 Rogers, John, of Hatton, yeoman 0
5378788 2468952 2468952 defendant Corsell Richard husbandman 605829 605829 Corsell, Richard, of Hatton, husbandman 6
5548255 2519519 2519519 defendant Sewe Robert husbandman 605829 605829 Sewe, Robert, of Hatton, husbandman 0
5560129 2522925 2522925 defendant Bamburgh Robert husbandman 605829 605829 Bamburgh, Robert, of Hatton, husbandman 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);