names

90 rows where place_id = 588623

✎ 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
3595083 1866095 1866095 defendant Lynde Thomas husbandman 588623 588623 Lynde, Thomas, of Shenley, husbandman 0
3605240 1869306 1869306 defendant Dey alias Palmer John husbandman 588623 588623 Dey alias Palmer, John, of Shenley, husbandman 0
3605243 1869307 1869307 defendant Dey alias Palmer Robert husbandman 588623 588623 Dey alias Palmer, Robert, of Shenley, husbandman 0
3611196 1871178 1871178 defendant Osborn Henry collier 588623 588623 Osborn, Henry, of Shenley, collier 0
3631582 1904690 1904690 defendant Fleccher William yeoman 588623 588623 Fleccher, William, of Shenley, yeoman 0
3632378 1904945 1904945 defendant Hewet Robert, senior yeoman 588623 588623 Hewet, Robert, senior, of Shenley, yeoman 0
3637349 1906485 1906485 defendant Hyll Geoffrey husbandman 588623 588623 Hyll, Geoffrey, of Shenley, husbandman 0
3666373 1915433 1915433 defendant Daldron John husbandman 588623 588623 Daldron, John, of Shenley, husbandman 0
3672402 1917371 1917371 defendant Hyll Robert yeoman 588623 588623 Hyll, Robert, of Shenley, yeoman 1
3672404 1917371 1917371 defendant Lythyng alias Grene John yeoman 588623 588623 Lythyng alias Grene, John, of Shenley, yeoman 3
3695214 1924723 1924723 defendant Dowman John yeoman 588623 588623 Dowman, John, of Shenley, yeoman 0
3695215 1924723 1924723 defendant Sharpe Henry laborer 588623 588623 Sharpe, Henry, of Shenley, laborer 1
3695216 1924723 1924723 defendant Parker William laborer 588623 588623 Parker, William, of Shenley, laborer 2
3695217 1924723 1924723 defendant Newman John laborer 588623 588623 Newman, John, of Shenley, laborer 3
3695218 1924723 1924723 defendant Haryson Thomas laborer 588623 588623 Haryson, Thomas, of Shenley, laborer 4
3695222 1924723 1924723 defendant Cuttys Elizabeth widow 588623 588623 Cuttys, Elizabeth,of SHenley, widow 8
3705136 1927895 1927895 defendant Audele William husbandman 588623 588623 Audele, William, of Shenley, husbandman 0
3761151 1945492 1945492 defendant Barnard William yeoman 588623 588623 Barnard, William, of Shenley, yeoman 0
3761153 1945492 1945492 defendant Mydwynter Richard husbandman 588623 588623 Mydwynter, Richard, of Shenley, husbandman 2
3761846 1945714 1945714 defendant Crowche John husbandman 588623 588623 Crowche, John, of Shenley, husbandman 1
3768658 1947844 1947844 defendant Cuttys Elizabeth widow 588623 588623 Cuttys, Elizabeth, of Shenley, widow 0
3768659 1947844 1947844 defendant Bowman John yeoman 588623 588623 Bowman, John, of Shenley, yeoman 1
3768660 1947844 1947844 defendant Sharpe Henry laborer 588623 588623 Sharpe, Henry, of Shenley, laborer 2
3768661 1947844 1947844 defendant Parker William laborer 588623 588623 Parker, William, of Shenley, laborer 3
3768662 1947844 1947844 defendant Newman John laborer 588623 588623 Newman, John, of Shenley, laborer 4
3768663 1947844 1947844 defendant Haryson Thomas laborer 588623 588623 Haryson, Thomas, of Shenley, laborer 5
3792960 1955654 1955654 defendant Bas Robert husbandman 588623 588623 Bas, Robert, of Shenley, husbandman 0
3796233 1956686 1956686 defendant Basse William husbandman 588623 588623 Basse, William, of Shenley, husbandman 4
3803185 1958898 1958898 defendant Crowche John husbandman 588623 588623 Crowche, John, of Shenley, husbandman 0
3818237 1963619 1963619 defendant Frankley Henry yeoman 588623 588623 Frankley, Henry, of Shenley, yeoman 1
3818238 1963619 1963619 defendant Bourn Thomas husbandman 588623 588623 Bourn, Thomas, of Shenley, husbandman 2
3841254 1970847 1970847 defendant Basse Thomas laborer 588623 588623 Basse, Thomas, of Shenley, laborer 0
4087396 2055785 2055785 defendant Turnepeny John yeoman 588623 588623 Turnepeny, John, of Shenley, yeoman 0
4087397 2055785 2055785 defendant Greves Edward gent 588623 588623 Greves, Edward, of Shenley, gent 1
4152798 2079085 2079085 defendant Burre Edmund yeoman 588623 588623 Burre, Edmund, of Shenley, yeoman 1
4206605 2097849 2097849 defendant Edmond John gent 588623 588623 Edmond, John, of Shenley, gent 0
4282244 2123689 2123689 defendant Perce Richard carpenter 588623 588623 Perce, Richard, of Shenley, carpenter 0
4341479 2144297 2144297 defendant Byrchmore Francis yeoman 588623 588623 Byrchmore, Francis, of Shenley, yeoman 0
4371898 2155010 2155010 defendant Warcoppe William yeoman 588623 588623 Warcoppe, William, of Shenley, yeoman 1
4633707 2241391 2241391 plaintiff Wermyngton Richard de chaplain of the chantry of St John Baptist 588623 588623 Wermyngton, Richard de, of Shenley, chaplain of the chantry of St John Baptist 0
4633708 2241391 2241391 defendant Sharpe Thomas   588623 588623 Sharpe, Thomas, of Shenley 0
4651868 2246522 2246522 defendant Gardyner Richard husbandman 588623 588623 Gardyner, Richard, of Shenley, husbandman 1
4706208 2267319 2267319 defendant Stukeley Thomas husbandman 588623 588623 Stukeley, Thomas, of Shenley, husbandman 0
4706210 2267320 2267320 defendant Stukeley Thomas husbandman 588623 588623 Stukeley, Thomas, of Shenley, husbandman 0
4732396 2275309 2275309 defendant Stucle Thomas gent 588623 588623 Stucle, Thomas, of Shenley, gent 0
4747370 2279733 2279733 defendant atte Noke William   588623 588623 atte Noke, William, of Shenley 0
4825346 2303970 2303970 defendant Stucle Thomas   588623 588623 Stucle, Thomas, of Shenley, franklin 0
4880091 2320682 2320682 defendant Kene John, senior husbandman 588623 588623 Kene, John, senior, of Shenley, husbandman 0
4880092 2320682 2320682 defendant Nanger or Nauger William laborer 588623 588623 Nanger or Nauger, William, of Shenley, laborer 1
4929067 2335513 2335513 defendant Man John husbandman 588623 588623 Man, John, of Shenley, husbandman 0
4930314 2335881 2335881 plaintiff Thurleby Thomas (legal representative) 588623 588623 Thurleby, Thomas, of Shenley, executors of 0
4992863 2354744 2354744 defendant Leverych Thomas husbandman 588623 588623 Leverych, Thomas, of Shenley, husbandman 0
4999548 2356738 2356738 defendant Furnyvale John husbandman 588623 588623 Furnyvale, John, of Shenley, husbandman 0
5007556 2359105 2359105 defendant Fraunceys Richard   588623 588623 Fraunceys, Richard, of Shenley 1
5007559 2359106 2359106 defendant Fraunceys Richard   588623 588623 Fraunceys, Richard, of Shenley 1
5027230 2364834 2364834 defendant Jordon John husbandman 588623 588623 Jordon, John, of Shenley, husbandman 0
5045396 2370253 2370253 defendant Frauncys Richard yeoman 588623 588623 Frauncys, Richard, of Shenley, yeoman 0
5051062 2371925 2371925 defendant Clerk William clerk & parson 588623 588623 Clerk, William, of Shenley, clerk & parson 0
5102411 2387108 2387108 defendant Deynys John husbandman 588623 588623 Deynys, John, of Shenley, husbandman 0
5120881 2392538 2392538 defendant Scote John husbandman 588623 588623 Scote, John, of Shenley, husbandman 2
5142259 2398855 2398855 defendant Gregge Walter husbandman 588623 588623 Gregge, Walter, of Shenley, husbandman 4
5160845 2404267 2404267 defendant Gregge Walter husbandman 588623 588623 Gregge, Walter, of Shenley, husbandman 3
5160926 2404300 2404300 defendant Brere Thomas chaplain 588623 588623 Brere, Thomas, of Shenley, chaplain 0
5175540 2408529 2408529 defendant Brere Thomas chaplain 588623 588623 Brere, Thomas, of Shenley, chaplain 0
5196739 2414794 2414794 defendant Gregge Walter husbandman 588623 588623 Gregge, Walter, of Shenley, husbandman 3
5209795 2418598 2418598 defendant Gregge Walter husbandman 588623 588623 Gregge, Walter, of Shenley, husbandman 3
5254247 2431451 2431451 defendant Garard Richard collier 588623 588623 Garard, Richard, of Shenley, collier 1
5322247 2451722 2451722 defendant Hylde John husbandman 588623 588623 Hylde, John, of Shenley, husbandman 0
5322248 2451722 2451722 defendant Grygge Thomas husbandman 588623 588623 Grygge, Thomas, of Shenley, husbandman 1
5378983 2469019 2469019 defendant Payn Edmund clerk 588623 588623 Payn, Edmund, of Shenley, clerk 1
5394432 2473469 2473469 defendant Broke Walter husbandman 588623 588623 Broke, Walter, of Shenley, husbandman 6
5394433 2473469 2473469 defendant Assheley William husbandman 588623 588623 Assheley, William,of Shenley, husbandman 7
5394434 2473469 2473469 defendant Assheley John husbandman 588623 588623 Assheley, John, of Shenley, husbandman 8
5394435 2473469 2473469 defendant Pope Richard husbandman 588623 588623 Pope, Richard, of Shenley, husbandman 9
5399597 2474966 2474966 defendant Brokehole Lawrence husbandman 588623 588623 Brokehole, Lawrence, of Shenley, husbandman 2
5412603 2478714 2478714 defendant (illegible) Lawrence husbandman 588623 588623 _, Lawrence, of Shenley, husbandman 2
5419934 2480880 2480880 defendant Dercok Thomas husbandman 588623 588623 Dercok, Thomas, of Shenley, husbandman 0
5427468 2483164 2483164 defendant Brokehale Lawrence husbandman 588623 588623 Brokehale, Lawrence, of Shenley, husbandman 2
5444830 2488346 2488346 defendant _ale Lawrence husbandman 588623 588623 _ale, Lawrence, of Shenley, husbandman 2
5457904 2492262 2492262 defendant Brokehale Lawrence husbandman 588623 588623 Brokehale, Lawrence, of Shenley, husbandman 2
5488411 2501427 2501427 defendant Slatter John husbandman 588623 588623 Slatter, John, of Shenley, husbandman 4
5553267 2520996 2520996 defendant Huet Thomas yeoman 588623 588623 Huet, Thomas, of Shenley, yeoman 0
5567016 2524947 2524947 defendant Blythe John yeoman 588623 588623 Blythe, John, of Shenley, yeoman 0
5573332 2526757 2526757 defendant Bagear or Bageard Thomas cordwainer 588623 588623 Bagear or Bageard, Thomas, of Shenley, cordwainer 0
5594766 2533336 2533336 defendant Pope Thomas yeoman 588623 588623 Pope, Thomas, of Shenley, yeoman 0
5594767 2533336 2533336 defendant Symond William laborer 588623 588623 Symond, William, of Shenley, laborer 1
5595061 2533423 2533423 defendant Hewet Robert yeoman 588623 588623 (Hewet, Robert, of Shenley, yeoman 1
5595065 2533424 2533424 defendant Hewet Robert yeoman 588623 588623 (Hewet, Robert, of Shenley, yeoman 1
5604101 2536145 2536145 defendant Huet Robert husbandman 588623 588623 Huet, Robert, of Shenley, husbandman 0
5609197 2537781 2537781 defendant Palmer Robert husbandman 588623 588623 Palmer, Robert, of Shenley, 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);