names

67 rows where place_id = 601550

✎ 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
3645806 1909091 1909091 defendant Broun Simon yeoman 601550 601550 Broun, Simon, of Kenelworth, yeoman 2
3760156 1945173 1945173 defendant Hylley Thomas yeoman 601550 601550 Hylley, Thomas, of Kenelworth, yeoman 0
3917393 1996176 1996176 defendant Tyler Henry husbandman 601550 601550 Tyler, Henry, of Kenelworth, husbandman 1
3917394 1996176 1996176 defendant Hyham William yeoman 601550 601550 Hyham, William, of Kenelworth, yeoman 2
3930941 2000687 2000687 defendant Fower Gerard yeoman 601550 601550 Fower, Gerard, of Kenelworth, yeoman 2
3930942 2000687 2000687 defendant Russell William yeoman 601550 601550 Russell, William, of Kenelworth, yeoman 3
3965504 2012547 2012547 plaintiff Bayes Thomas   601550 601550 Bayes, Thomas, of Kenelworth, his brother 1
4002034 2025507 2025507 defendant Harte Thomas husbandman 601550 601550 Harte, Thomas, of Kenelworth, husbandman 0
4034729 2037102 2037102 defendant Harte Thomas husbandman 601550 601550 Harte, Thomas, of Kenelworth, husbandman 0
4103625 2061577 2061577 defendant Abbott Edmund yeoman 601550 601550 Abbott, Edmund, of Kenelworth, yeoman 0
4281015 2123261 2123261 defendant Forest Thomas yeoman 601550 601550 Forest, Thomas, of Kenelworth, yeoman 0
4295047 2128311 2128311 defendant Freeman John   601550 601550 Freeman, John, of Kenelworth, surgeon 0
4295048 2128311 2128311 defendant Parsons Richard chandler 601550 601550 Parsons, Richard, of Kenelworth, chandler 1
4297388 2129170 2129170 defendant Higgenson George yeoman 601550 601550 Higgenson, George, of Kenelworth, or of Rudfyn, yeoman 0
4297395 2129172 2129172 defendant East William gent 601550 601550 East, William, of Kenelworth, or of Meryden, gent 0
4298589 2129602 2129602 defendant Forrest Thomas yeoman 601550 601550 Forrest, Thomas, of Kenelworth, yeoman 0
4313000 2134670 2134670 defendant Collyns or Colly William joiner 601550 601550 Collyns or Colly, William, of Kenelworth, joiner 1
4360118 2150782 2150782 defendant Denton John gent 601550 601550 Denton, John, of Kenelworth, gent 0
4362536 2151653 2151653 defendant Higgenson George yeoman 601550 601550 Higgenson, George, of Kenelworth, yeoman 1
4381031 2158332 2158332 defendant Higgenson George gent 601550 601550 Higgenson, George, of Kenelworth, gent 1
4398518 2164083 2164083 defendant Freeman John yeoman 601550 601550 Freeman, John, of Kenelworth, yeoman 0
4402925 2165564 2165564 defendant Atterburye Richard husbandman 601550 601550 Atterburye, Richard, of Kenelworth, husbandman 0
4525941 2208413 2208413 defendant Haltremour John   601550 601550 Haltremour, John, of Kenelworth 0
4535656 2211427 2211427 plaintiff Smyth Robert   601550 601550 Smyth, Robert, of Kenelworth 0
4637664 2242564 2242564 defendant Chariour Robert   601550 601550 Chariour, Robert, of Kenelworth 0
4655014 2247449 2247449 defendant Asshebrenner John ashburner 601550 601550 Asshebrenner, John, of Kenelworth, ashburner 1
4848661 2311052 2311052 defendant Smyth Nicholas butcher 601550 601550 Smyth, Nicholas, of Kenelworth, butcher 2
4850202 2311525 2311525 defendant Smyth Nicholas butcher 601550 601550 Smyth, Nicholas, of Kenelworth, butcher 1
4869414 2317401 2317401 defendant Symmesson John   601550 601550 Symmesson, John, of Kenelworth 0
4987462 2353206 2353206 defendant Hore Thomas gent 601550 601550 Hore, Thomas, of Kenelworth, gent 0
5061478 2375023 2375023 plaintiff Greswold Thomas   601550 601550 Greswold, Thomas, of Kenelworth 0
5070853 2377777 2377777 defendant Reyner James yeoman 601550 601550 Reyner, James, of Kenelworth, yeoman 0
5114430 2390617 2390617 defendant Kendale William husbandman 601550 601550 Kendale, William, of Kenelworth, husbandman 3
5114431 2390617 2390617 defendant Charyer John yeoman 601550 601550 Charyer, John, of Kenelworth, yeoman 4
5130130 2395301 2395301 defendant Isode William yeoman 601550 601550 Isode, William, of Kenelworth, yeoman 0
5131975 2395836 2395836 defendant Yerdley John   601550 601550 Yerdley, John, of Kenelworth, abbot of St Mary's church 0
5135940 2397024 2397024 defendant Breswold Robert yeoman 601550 601550 Breswold, Robert, of Kenelworth, yeoman 0
5135943 2397024 2397024 defendant Dolas Hnery tanner 601550 601550 Dolas, Hnery, of Kenelworth, tanner 3
5142981 2399072 2399072 plaintiff Yerdeley John   601550 601550 Yerdeley, John, of Kenelworth, abbot of the monastery of BM 0
5142982 2399072 2399072 defendant Grenefeld John yeoman 601550 601550 Grenefeld, John, of Kenelworth, yeoman 0
5149450 2400972 2400972 defendant Isede William husbandman 601550 601550 together with Isede, William, of Kenelworth, husbandman 2
5164524 2405357 2405357 defendant Symson Henry yeoman 601550 601550 Symson, Henry, of Kenelworth, yeoman 1
5228466 2423931 2423931 defendant Symson Henry husbandman 601550 601550 Symson, Henry, of Kenelworth, husbandman 0
5243138 2428193 2428193 defendant Gresewold Robert gent 601550 601550 Gresewold, Robert, of Kenelworth, gent 0
5246869 2429249 2429249 defendant Gryssewolde Roger gent 601550 601550 Gryssewolde, Roger, of Kenelworth, gent 0
5283761 2440293 2440293 defendant Sympson Henry husbandman 601550 601550 Sympson, Henry, of Kenelworth, husbandman 2
5295954 2443805 2443805 defendant Parkyn John tailor 601550 601550 Parkyn, John, of Kenelworth, tailor 2
5295955 2443805 2443805 defendant Parkyn Richard husbandman 601550 601550 Parkyn, Richard, of Kenelworth, husbandman 3
5295956 2443805 2443805 defendant Warrewyk John husbandman 601550 601550 Warrewyk, John, of Kenelworth, husbandman 4
5311642 2448505 2448505 plaintiff Yerdeley John   601550 601550 Yerdeley, John, of Kenelworth, abbot of the monastery of the BM 0
5314796 2449468 2449468 defendant Lapworth John yeoman 601550 601550 Lapworth, John, of Kenelworth, yeoman 1
5361698 2463684 2463684 defendant Clerk Thomas (legal representative) 601550 601550 Clerk, Thomas, of Kenelworth, yeoman, executors of 1
5379709 2469238 2469238 plaintiff Yardley alias Erdeleye John   601550 601550 Yardley alias Erdeleye, John, of Kenelworth, abbot of the Monastery of the Blessed Mary 0
5390778 2472428 2472428 plaintiff Napton Thomas   601550 601550 Napton, Thomas, of Kenelworth 0
5394942 2473624 2473624 plaintiff Yardeley John   601550 601550 Yardeley, John, of Kenelworth, abbot of the monastery of the BM 0
5440740 2487140 2487140 plaintiff Yardeley John   601550 601550 Yardeley, John, of Kenelworth, abbot of the monastery of the BM 0
5464147 2494183 2494183 defendant Edwardes Thomas yeoman 601550 601550 Edwardes, Thomas, of Kenelworth, yeoman 1
5475703 2497727 2497727 defendant Edward Thomas yeoman 601550 601550 Edward, Thomas, of Kenelworth, yeoman 0
5567257 2524999 2524999 defendant Yardley Thomas butcher 601550 601550 Yardley, Thomas, of Kenelworth, butcher 0
5577897 2528159 2528159 defendant Orwell William yeoman 601550 601550 Orwell, William, of Kenelworth, yeoman 2
5591852 2532438 2532438 defendant Greswold John gent 601550 601550 Greswold, John, of Kenelworth, gent 0
5591853 2532438 2532438 defendant Lapworth Richard yeoman 601550 601550 Lapworth, Richard, of Kenelworth, yeoman 1
5591855 2532439 2532439 defendant Greswold John gent 601550 601550 Greswold, John, of Kenelworth, gent 0
5591856 2532439 2532439 defendant Lapworth Richard yeoman 601550 601550 Lapworth, Richard, of Kenelworth, yeoman 1
5591858 2532440 2532440 defendant Greswold John gent 601550 601550 Greswold, John, of Kenelworth, gent 0
5591859 2532440 2532440 defendant Lapworth Richard yeoman 601550 601550 Lapworth, Richard, of Kenelworth, yeoman 1
5608005 2537408 2537408 defendant Bankys Andrew yeoman 601550 601550 Bankys, Andrew, of Kenelworth, yeoman 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);