names

137 rows where place_id = 590181

✎ 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
3600170 1867705 1867705 defendant Seman John husbandman 590181 590181 Seman, John, of Denyngton, husbandman 0
3612324 1871488 1871488 defendant Rous William gent 590181 590181 Rous, William, of Denyngton, gent 0
3682658 1920683 1920683 defendant Rowse William   590181 590181 Rowse, William, of Denyngton, knight 0
3695457 1924802 1924802 defendant Tyler John husbandman 590181 590181 Tyler, John, of Denyngton, husbandman 2
3717304 1931695 1931695 defendant Boret Thomas husbandman 590181 590181 Boret, Thomas, of Denyngton, husbandman 0
3729390 1935440 1935440 defendant Crisp Henry carpenter 590181 590181 Crisp, Henry, of Denyngton, carpenter 4
3729499 1935472 1935472 plaintiff Barbour Roger chaplain 590181 590181 Barbour, Roger, of Denyngton, chaplain 1
3729500 1935472 1935472 defendant Markaunt Robert yeoman 590181 590181 Markaunt, Robert, of Denyngton, yeoman 0
3732263 1936331 1936331 defendant Ewyn William   590181 590181 Ewyn, William, of Denyngton, wheelwright 0
3732264 1936331 1936331 defendant Ewyn Thomas   590181 590181 Ewyn, Thomas, of Denyngton, wheelwright 1
3733033 1936552 1936552 defendant Borett Thomas husbandman 590181 590181 Borett, Thomas, of Denyngton, husbandman 0
3793229 1955742 1955742 defendant Gerves Robert husbandman 590181 590181 Gerves, Robert, of Denyngton, husbandman 0
3807481 1960246 1960246 defendant Wortley William gent 590181 590181 Wortley, William, of Denyngton, gent 0
3809032 1960706 1960706 defendant Marcaunt Robert yeoman 590181 590181 Marcaunt, Robert, of Denyngton, yeoman 2
3821631 1964649 1964649 defendant Hayle Thomas husbandman 590181 590181 Hayle, Thomas, of Denyngton, husbandman 0
3840873 1970714 1970714 defendant Aldred William yeoman 590181 590181 Aldred, William, of Denyngton, yeoman 0
3840876 1970715 1970715 defendant Aldred William yeoman 590181 590181 Aldred, William, of Denyngton, yeoman 0
3855186 1975255 1975255 defendant Smyth William husbandman 590181 590181 Smyth, William, of Denyngton, husbandman 0
3934802 2001939 2001939 defendant Bagott Robert husbandman 590181 590181 Bagott, Robert, of Denyngton, husbandman 0
3943433 2004818 2004818 defendant Firmage John yeoman 590181 590181 Firmage, John, of Denyngton, yeoman 0
3955335 2008934 2008934 defendant Smyth Thomas glover 590181 590181 Smyth, Thomas, of Denyngton, glover 1
3958471 2010033 2010033 defendant Borrett John yeoman 590181 590181 Borrett, John, of Denyngton, yeoman 0
3959153 2010287 2010287 plaintiff Seman George   590181 590181 Seman, George, of Denyngton 0
3959155 2010288 2010288 plaintiff Seman George   590181 590181 Seman, George, of Denyngton 0
3974068 2015499 2015499 plaintiff Hargrave James   590181 590181 Hargrave, James, of Denyngton 0
3974236 2015554 2015554 defendant Marshall John yeoman 590181 590181 Marshall, John, of Denyngton, yeoman 0
3978079 2016908 2016908 defendant Button John husbandman 590181 590181 Button, John, of Denyngton, husbandman 0
3978084 2016910 2016910 defendant Gwyn John yeoman 590181 590181 Gwyn, John, of Denyngton, yeoman 1
3982659 2018566 2018566 plaintiff Seman George yeoman 590181 590181 Seman, George, of Denyngton, yeoman 0
4010307 2028451 2028451 defendant Cuham William husbandman 590181 590181 Cuham, William, of Denyngton, husbandman 3
4063729 2047316 2047316 defendant Goodale Arnold tailor 590181 590181 Goodale, Arnold, of Denyngton, tailor 3
4080225 2053238 2053238 defendant Rushe John bricklayer 590181 590181 Rushe, John, of Denyngton, bricklayer 0
4191543 2092605 2092605 defendant Crispe Francis husbandman 590181 590181 Crispe, Francis, of Denyngton, husbandman 1
4341058 2144146 2144146 defendant Spurlinge Michael yeoman 590181 590181 Spurlinge, Michael, of Denyngton, yeoman 0
4356065 2149342 2149342 defendant Warner John joiner 590181 590181 Warner, John, of Denyngton, joiner 3
4414472 2169427 2169427 defendant Pencrych John de   590181 590181 Pencrych, John de, of Denyngton, parson 0
4566872 2221202 2221202 defendant Rede John   590181 590181 Rede, John, of Denyngton 2
4574990 2223698 2223698 defendant Pelse Robert   590181 590181 Pelse, Robert, of Denyngton 0
4574992 2223699 2223699 defendant Pelse Robert   590181 590181 Pelse, Robert, of Denyngton 0
4620410 2237363 2237363 defendant Spryngman Robert   590181 590181 Spryngman, Robert, of Denyngton 0
4620411 2237363 2237363 defendant Canon Walter   590181 590181 Canon, Walter, of Denyngton 1
4653631 2247061 2247061 defendant Norman John   590181 590181 Norman, John, of Denyngton 4
4664933 2250512 2250512 defendant Olyff John husbandman 590181 590181 Olyff, John, of Denyngton, husbandman 2
4669176 2256065 2256065 defendant Pellyng or Pollyng Joan widow 590181 590181 Pellyng or Pollyng, Joan, of Denyngton, widow 1
4746377 2279438 2279438 plaintiff Rous Robert   590181 590181 Rous, Robert, of Denyngton 3
4749912 2280449 2280449 defendant Canon Walter yeoman 590181 590181 Canon, Walter, of Denyngton, yeoman 0
4757702 2282784 2282784 defendant Rous Robert   590181 590181 Rous, Robert, of Denyngton 3
4764365 2284849 2284849 plaintiff Rous Robert   590181 590181 Rous, Robert, of Denyngton 3
4777295 2288889 2288889 plaintiff Rous Robert   590181 590181 Rous, Robert, of Denyngton 1
4788662 2292509 2292509 plaintiff Rous Robert   590181 590181 Rous, Robert, of Denyngton 3
4812006 2299869 2299869 plaintiff Goodyng John   590181 590181 Goodyng, John, of Denyngton, parson 0
4825046 2303874 2303874 defendant Warner John   590181 590181 Warner, John, of Denyngton, son of John Warner 0
4839380 2308239 2308239 defendant Tyler Edmund tiler 590181 590181 Tyler, Edmund, of Denyngton, tiler 1
4839383 2308240 2308240 defendant Tyler Edmund tiler 590181 590181 Tyler, Edmund, of Denyngton, tiler 1
4884911 2322177 2322177 defendant Tynker William husbandman 590181 590181 Tynker, William, of Denyngton, husbandman 0
4901454 2327060 2327060 defendant Taillour William husbandman 590181 590181 Taillour, William, of Denyngton, husbandman 2
4901455 2327060 2327060 defendant Ingram John husbandman 590181 590181 Ingram, John, of Denyngton, husbandman 3
4901456 2327060 2327060 defendant Barbour John husbandman 590181 590181 Barbour, John, of Denyngton, husbandman 4
4901457 2327060 2327060 defendant Langley John husbandman 590181 590181 Langley, John, of Denyngton, husbandman 5
4901458 2327060 2327060 defendant Taillour John husbandman 590181 590181 Taillour, John, of Denyngton, husbandman 6
4901459 2327060 2327060 defendant Harryson William husbandman 590181 590181 Harryson, William, of Denyngton, husbandman 7
4901460 2327060 2327060 defendant Harryson Robert husbandman 590181 590181 Harryson, Robert, of Denyngton, husbandman 8
4910868 2329909 2329909 defendant Newehall Richard husbandman 590181 590181 Newehall, Richard, of Denyngton, husbandman 0
4910869 2329909 2329909 defendant Symons John husbandman 590181 590181 Symons, John, of Denyngton, husbandman 1
4917431 2331966 2331966 defendant Swan Richard husbandman 590181 590181 Swan, Richard, of Denyngton, husbandman 0
4947480 2341207 2341207 defendant Peyntour Robert butcher 590181 590181 Peyntour, Robert, of Denyngton, butcher 1
4952563 2342725 2342725 plaintiff Rous Robert gent 590181 590181 Rous, Robert, of Denyngton, gent 0
4955177 2343506 2343506 plaintiff Swan Richard (legal representative) 590181 590181 Swan, Richard, of Denyngton, executors of 0
4986845 2353004 2353004 defendant Cheverell Thomas yeoman 590181 590181 Cheverell, Thomas, of Denyngton, yeoman 3
5024018 2363935 2363935 defendant Barbour William yeoman 590181 590181 Barbour, William, of Denyngton, yeoman 0
5057138 2373717 2373717 defendant Reydon Alexander yeoman 590181 590181 Reydon, Alexander, of Denyngton, yeoman 1
5063147 2375515 2375515 defendant Grene Alan husbandman 590181 590181 Grene, Alan, of Denyngton, husbandman 0
5063148 2375515 2375515 defendant Reydon William husbandman 590181 590181 Reydon, William, of Denyngton, husbandman 1
5063656 2375662 2375662 defendant Forster William yeoman 590181 590181 Forster, William, of Denyngton, yeoman 3
5068257 2377010 2377010 defendant Aleyn William thatcher 590181 590181 Aleyn, William, of Denyngton, thatcher 2
5069893 2377487 2377487 defendant Bilby Adam husbandman 590181 590181 Bilby, Adam, of Denyngton, husbandman 2
5070517 2377676 2377676 defendant Reydon Alexander yeoman 590181 590181 Reydon, Alexander, of Denyngton, yeoman 0
5070518 2377676 2377676 defendant Dewke Thomas yeoman 590181 590181 Dewke, Thomas, of Denyngton, yeoman 1
5070519 2377676 2377676 defendant Foster William yeoman 590181 590181 Foster, William, of Denyngton, yeoman 2
5072036 2378126 2378126 defendant Em John yeoman 590181 590181 Em, John, of Denyngton, yeoman 1
5073822 2378658 2378658 plaintiff Warner Walter   590181 590181 Warner, Walter, of Denyngton 0
5084962 2382009 2382009 defendant Warner Ralph yeoman 590181 590181 Warner, Ralph, of Denyngton, yeoman 0
5085526 2382157 2382157 defendant Foster William yeoman 590181 590181 Foster, William, of Denyngton, yeoman 1
5087028 2382585 2382585 defendant Reydon William yeoman 590181 590181 Reydon, William, of Denyngton, yeoman 1
5087032 2382585 2382585 defendant Eme John yeoman 590181 590181 Eme, John, of Denyngton, yeoman 5
5112731 2390113 2390113 defendant Reydon William husbandman 590181 590181 Reydon, William, of Denyngton, husbandman 0
5118657 2391887 2391887 defendant Edgore John husbandman 590181 590181 Edgore, John, of Denyngton, husbandman 1
5118658 2391887 2391887 defendant Barbour William husbandman 590181 590181 Barbour, William,of Denyngton, husbandman 2
5118665 2391889 2391889 plaintiff Rous Reginald   590181 590181 Rous, Reginald, of Denyngton 0
5130972 2395541 2395541 defendant Fale John husbandman 590181 590181 Fale, John, of Denyngton, husbandman 0
5131925 2395821 2395821 defendant Oswester Richard husbandman 590181 590181 Oswester, Richard, of Denyngton, husbandman 1
5143430 2399212 2399212 defendant Collys John laborer 590181 590181 Collys, John, of Denyngton, laborer 0
5143434 2399214 2399214 defendant Gin John husbandman 590181 590181 Gin, John, of Denyngton, husbandman 0
5169443 2406797 2406797 defendant Bernard William laborer 590181 590181 Bernard, William, of Denyngton, laborer 0
5186093 2411684 2411684 defendant Bernard William laborer 590181 590181 Bernard, William, of Denyngton, laborer 0
5216086 2420433 2420433 defendant Bernard William laborer 590181 590181 Bernard, William, of Denyngton, laborer 0
5219959 2421548 2421548 defendant Denk Thomas yeoman 590181 590181 Denk, Thomas, of Denyngton, yeoman 5
5225163 2423031 2423031 defendant Duke Thomas yeoman 590181 590181 Duke, Thomas, of Denyngton, yeoman 2
5263934 2434479 2434479 defendant Duke Thomas yeoman 590181 590181 Duke, Thomas, of Denyngton, yeoman 1
5268615 2435940 2435940 defendant Gardener John husbandman 590181 590181 Gardener, John, of Denyngton, husbandman 1

Next page

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