names

39 rows where place_id = 595476

✎ 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
3620611 1874024 1874024 defendant Taillour William yeoman 595476 595476 Taillour, William, of Kenne, yeoman 0
3620612 1874024 1874024 defendant Kenne John esq 595476 595476 Kenne, John, of Kenne, esq 1
3683607 1921004 1921004 defendant Drewe John gent 595476 595476 Drewe, John, of Kenne, gent 0
3718565 1932083 1932083 defendant Huchyn William husbandman 595476 595476 Huchyn, William, of Kenne, husbandman 0
3764856 1946675 1946675 defendant Drewe John   595476 595476 Drewe, John, of Kenne, gent, son of Drewe, John 0
3807783 1960318 1960318 defendant Broun William butcher 595476 595476 Broun, William, of Kenne, butcher 1
3939261 2003436 2003436 defendant Cocke William husbandman 595476 595476 Cocke, William, of Kenne, husbandman 0
3954026 2008478 2008478 plaintiff Kenne Thomas gent 595476 595476 Kenne, Thomas, of Kenne, gent 0
3964705 2012262 2012262 defendant Whytborough John husbandman 595476 595476 Whytborough, John, of Kenne, husbandman 0
3976457 2016340 2016340 plaintiff Kenne Thomas gent 595476 595476 Kenne, Thomas, of Kenne, gent 0
3976459 2016341 2016341 plaintiff Kenne Thomas gent 595476 595476 Kenne, Thomas, of Kenne, gent 0
3997199 2023768 2023768 defendant Goteham Roger yeoman 595476 595476 Goteham, Roger, of Kenne, yeoman 0
4018629 2031396 2031396 plaintiff Vydyan John gent 595476 595476 Vydyan, John, of Kenne, gent 0
4048019 2041735 2041735 defendant Peryman John husbandman 595476 595476 Peryman, John, of Kenne, husbandman 1
4058024 2045250 2045250 defendant Kenne Thomas gent 595476 595476 Kenne, Thomas, of Kenne, gent 0
4080445 2053316 2053316 defendant Bonde Walter laborer 595476 595476 Bonde, Walter, of Kenne, laborer 0
4144631 2076281 2076281 defendant Saunders William yeoman 595476 595476 Saunders, William, of Kenne, yeoman 0
4154588 2079698 2079698 defendant Adam John husbandman 595476 595476 Adam, John, of Kenne, husbandman 2
4241684 2110204 2110204 defendant Nicolls Thomas husbandman 595476 595476 Nicolls, Thomas, of Kenne, husbandman 1
4241685 2110204 2110204 defendant Cuttisford David husbandman 595476 595476 Cuttisford, David, of Kenne, husbandman 2
4290503 2126664 2126664 defendant Treviser Stephen yeoman 595476 595476 Treviser, Stephen, of Kenne, yeoman 0
4690015 2262429 2262429 defendant Tide William butcher 595476 595476 Tide, William, of Kenne, butcher 0
4901592 2327100 2327100 defendant Ware Roger husbandman 595476 595476 Ware, Roger, of Kenne, husbandman 0
4936374 2337769 2337769 defendant Ware Roger husbandman 595476 595476 Ware, Roger, of Kenne, husbandman 0
4970916 2348245 2348245 defendant Lucombe John husbandman 595476 595476 Lucombe, John, of Kenne, husbandman 0
4997456 2356089 2356089 defendant Lathum William clerk 595476 595476 Lathum, William, of Kenne, clerk 0
4997460 2356089 2356089 defendant Wynton John laborer 595476 595476 Wynton, John, of Kenne, laborer 4
5042002 2369213 2369213 defendant Ware Roger husbandman 595476 595476 Ware, Roger, of Kenne, husbandman 0
5056965 2373661 2373661 defendant Lucomb John yeoman 595476 595476 Lucomb, John, of Kenne, yeoman 0
5070012 2377525 2377525 defendant Crosse William husbandman 595476 595476 Crosse, William, of Kenne, husbandman 1
5076865 2379574 2379574 defendant Whytton John gent 595476 595476 Whytton, John, of Kenne, gent 0
5095333 2385055 2385055 defendant Shute William, junior husandman 595476 595476 Shute, William, junior, of Kenne, husandman 3
5095334 2385055 2385055 defendant Shute William, senior husandman 595476 595476 Shute, William, senior, of Kenne, husandman 4
5120512 2392428 2392428 defendant Ebbysworthy John husbandman 595476 595476 Ebbysworthy, John, of Kenne, husbandman 5
5120513 2392428 2392428 defendant Wallyng Regulus husbandman 595476 595476 Wallyng, Regulus, of Kenne, husbandman 6
5226157 2423315 2423315 defendant Lacheham William clerk 595476 595476 Lacheham, William, of Kenne, clerk 0
5323369 2452066 2452066 defendant Leye Robert clerk 595476 595476 Leye, Robert, of Kenne, clerk 0
5626466 2552248 2552248 defendant Bykcombe John laborer 595476 595476 Bykcombe, John, of Kenne, laborer 1
5628466 2552873 2552873 defendant Twyte William husbandman 595476 595476 Twyte, William, of Kenne, 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);