names

47 rows where place_id = 588375

✎ View and edit SQL

This data as json, CSV (advanced)

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

id ▼ case_id role surname forename occupation place_id raw_segment seq
3594293 1865851 1865851 defendant Sherman Edward husbandman 588375 588375 Sherman, Edward, of Garnethorp, husbandman 0
3594297 1865851 1865851 defendant Dyxson Thomas laborer 588375 588375 Dyxson, Thomas, of Garnethorp, laborer 4
3619840 1873781 1873781 defendant Smyth John laborer 588375 588375 Smyth, John, of Garnethorp, laborer 2
4027515 2034485 2034485 defendant Smyth James yeoman 588375 588375 Smyth, James, of Garnethorp, yeoman 0
4106230 2062520 2062520 defendant Fawer George yeoman 588375 588375 Fawer, George, of Garnethorp, yeoman 0
4649019 2245761 2245761 plaintiff Tomlynson John   588375 588375 Tomlynson, John, of Garnethorp 0
4764851 2284986 2284986 defendant Lee John de husbandman 588375 588375 Lee, John de, of Garnethorp, husbandman 0
4764852 2284986 2284986 defendant Ortes Alice laborer 588375 588375 Ortes, Alice, of Garnethorp, laborer 1
4916834 2331768 2331768 defendant Lothyn William husbandman 588375 588375 Lothyn, William, of Garnethorp, husbandman 3
4930940 2336073 2336073 defendant Smyth John chaplain 588375 588375 Smyth, John, of Garnethorp, chaplain 0
4930941 2336073 2336073 defendant Sherman John gent 588375 588375 Sherman, John, of Garnethorp, gent 1
4930943 2336073 2336073 defendant Jakson John laborer 588375 588375 Jakson, John, of Garnethorp, laborer 3
4961264 2345336 2345336 defendant Leyceter Ralph tailor 588375 588375 Leyceter, Ralph, of Garnethorp, tailor 0
4999005 2356583 2356583 defendant Dyconson Robert   588375 588375 (Dyconson, Robert, of Garnethorp, parish clerk 1
5002636 2357684 2357684 defendant Dyconson Robert   588375 588375 (Dyconson, Robert, of Garnethorp, parish clerk 1
5025489 2364356 2364356 defendant Palmer John miller 588375 588375 Palmer, John, of Garnethorp, miller 0
5025491 2364356 2364356 defendant Couper Stephen   588375 588375 Couper, Stephen, of Garnethorp, wright 2
5025492 2364356 2364356 defendant Tetbury John butcher 588375 588375 Tetbury, John, of Garnethorp, butcher 3
5060123 2374596 2374596 defendant Dikonson Robert husbandman 588375 588375 Dikonson, Robert, of Garnethorp, husbandman 2
5067745 2376852 2376852 defendant Diconson Richard, senior husbandman 588375 588375 Diconson, Richard, senior, of Garnethorp, husbandman 0
5067746 2376852 2376852 defendant Bocher John butcher 588375 588375 Bocher, John, of Garnethorp, butcher 1
5067747 2376852 2376852 defendant Couper Robert husbandman 588375 588375 Couper, Robert, of Garnethorp, husbandman 2
5067748 2376852 2376852 defendant Penyngton William husbandman 588375 588375 Penyngton, William, of Garnethorp, husbandman 3
5067749 2376852 2376852 defendant Sherman Thomas husbandman 588375 588375 Sherman, Thomas, of Garnethorp, husbandman 4
5070963 2377808 2377808 defendant Thomson Walrter husbandman 588375 588375 Thomson, Walrter, of Garnethorp, husbandman 0
5070964 2377808 2377808 defendant Hubbylday John husbandman 588375 588375 Hubbylday, John, of Garnethorp, husbandman 1
5070965 2377808 2377808 defendant Kyrthorp Robert husbandman 588375 588375 Kyrthorp, Robert, of Garnethorp, husbandman 2
5070966 2377808 2377808 defendant Neuman William husbandman 588375 588375 Neuman, William, of Garnethorp, husbandman 3
5070967 2377808 2377808 defendant Gilbertson John husbandman 588375 588375 Gilbertson, John, of Garnethorp, husbandman 4
5070974 2377808 2377808 defendant Trayle John husbandman 588375 588375 Trayle, John, of Garnethorp, husbandman 11
5124281 2393548 2393548 defendant Dykonson Robert, junior husbandman 588375 588375 Dykonson, Robert, junior, of Garnethorp, husbandman 0
5189182 2412568 2412568 defendant Rouson Walter   588375 588375 Rouson, Walter, of Garnethorp, salt weller 2
5251191 2430475 2430475 defendant Sherman John gent 588375 588375 Sherman, John, of Garnethorp, gent 1
5276572 2438224 2438224 defendant Blankeney William (legal representative) 588375 588375 Blankeney, William, of Garnethorp, clerk, executors of 0
5276576 2438225 2438225 defendant Blankney William (legal representative) 588375 588375 Blankney, William, of Garnethorp, clerk, executors of 0
5283907 2440327 2440327 defendant Kele Thomas gent 588375 588375 Kele, Thomas, of Garnethorp, gent 1
5308758 2447658 2447658 defendant Johnson Thomas husbandman 588375 588375 Johnson, Thomas, of Garnethorp, husbandman 1
5322445 2451781 2451781 defendant Helwys Walter husbandman 588375 588375 Helwys, Walter, of Garnethorp, husbandman 0
5322446 2451781 2451781 defendant Blaunkeney Richard husbandman 588375 588375 Blaunkeney, Richard, of Garnethorp, husbandman 1
5323546 2452124 2452124 defendant Palmar John   588375 588375 Palmar, John, of Garnethorp, holy water clerk 0
5337938 2456432 2456432 defendant Johnson Thomas husbandman 588375 588375 Johnson, Thomas, of Garnethorp, husbandman 0
5337941 2456432 2456432 defendant Johnson William laborer 588375 588375 Johnson, William, of Garnethorp, laborer 3
5355561 2461810 2461810 plaintiff Kele Robert   588375 588375 Kele, Robert, of Garnethorp 0
5355563 2461811 2461811 plaintiff Kele Robert   588375 588375 Kele, Robert, of Garnethorp 0
5420009 2480902 2480902 defendant Palmer Nicholas yeoman 588375 588375 Palmer, Nicholas, of Garnethorp, yeoman 0
5438646 2486495 2486495 defendant Palmer Nicholas yeoman 588375 588375 Palmer, Nicholas, of Garnethorp, yeoman 0
5525329 2512513 2512513 defendant Galley Thomas husbandman 588375 588375 Galley, Thomas, of Garnethorp, husbandman 1

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