names

62 rows where place_id = 592086

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3606503 1869707 1869707 defendant George William innholder 592086 592086 George, William, of Newmarket, Cams, innholder 1
3621510 1874268 1874268 defendant Porter Thomas innholder 592086 592086 Porter, Thomas, of Newmarket, Cams, innholder 1
3636404 1906174 1906174 defendant Wheytall John fishmonger 592086 592086 Wheytall, John, of Newmarket, Cams, fishmonger 0
3639472 1907150 1907150 defendant Papford John fishmnoger 592086 592086 Papford, John, of Newmarket, Cams, fishmnoger 1
3646358 1909255 1909255 defendant Love alias Ryder John husbandman 592086 592086 Love alias Ryder, John, of Newmarket, Cams, husbandman 0
3646364 1909256 1909256 defendant Love alias Ryder John husbandman 592086 592086 Love alias Ryder, John, of Newmarket, Cams, husbandman 0
3674461 1918061 1918061 defendant Paterdale Henry tapster 592086 592086 Paterdale, Henry, of Newmarket, Cams, tapster 0
3676654 1918736 1918736 defendant Whitall John fishmonger 592086 592086 Whitall, John, of Newmarket, Cams, fishmonger 0
3676897 1918814 1918814 defendant Couper William yeoman 592086 592086 Couper, William, of Newmarket, Cams, yeoman 0
3695776 1924909 1924909 defendant Holmehed Margaret widow 592086 592086 Holmehed, Margaret, of Newmarket, Cams, widow 1
3723599 1933653 1933653 defendant Whetall John yeoman 592086 592086 Whetall, John, of Newmarket, Cams, yeoman 4
3739423 1938539 1938539 defendant Whetall John yeoman 592086 592086 Whetall, John, of Newmarket, Cams, yeoman 1
3750033 1941927 1941927 defendant Trovyn John husbandman 592086 592086 Trovyn, John, of Newmarket, Cams, husbandman 0
3751951 1942526 1942526 defendant Papworth John   592086 592086 Papworth, John, of Newmarket, Cams, pedlar 2
3757685 1944383 1944383 defendant Trovey John yeoman 592086 592086 Trovey, John, of Newmarket, Cams, yeoman 0
3770169 1948337 1948337 defendant Whytale Joan widow 592086 592086 Whytale, Joan, of Newmarket, Cams, widow 1
3779212 1951218 1951218 defendant Cowper William yeoman 592086 592086 Cowper, William, of Newmarket, Cams, yeoman 0
3796692 1956849 1956849 defendant Thrower Thomas haberdasher 592086 592086 Thrower, Thomas, of Newmarket, Cams, haberdasher 1
3797661 1957164 1957164 defendant Hamond William husbandman 592086 592086 Hamond, William, of Newmarket, Cams, husbandman 0
3797664 1957165 1957165 defendant Hamonde William husbandman 592086 592086 Hamonde, William, of Newmarket, Cams, husbandman 0
3807531 1960263 1960263 defendant Trayvyn John yeoman 592086 592086 Trayvyn, John, of Newmarket, Cams, yeoman 0
3820570 1964317 1964317 defendant Trevy John yeoman 592086 592086 Trevy, John, of Newmarket, Cams, yeoman 0
3852263 1974307 1974307 defendant Kyng William husbandman 592086 592086 Kyng, William, of Newmarket, Cams, husbandman 0
3858196 1976219 1976219 defendant Fenston Henry chapman 592086 592086 Fenston, Henry, of Newmarket, Cams, chapman 3
3986564 2019935 2019935 defendant Kinge John fishmonger 592086 592086 Kinge, John, of Newmarket, Cams, fishmonger 0
4075938 2051695 2051695 defendant Stawver John husbandman 592086 592086 Stawver, John, of Newmarket, Cams, husbandman 2
4093472 2057980 2057980 defendant Cotton Robert gent 592086 592086 Cotton, Robert, of Newmarket, Cams, gent 2
4168147 2084346 2084346 defendant Grene Richard grocer 592086 592086 Grene, Richard, of Newmarket, Cams, grocer 3
4300126 2130142 2130142 defendant Pickas John yeoman 592086 592086 Pickas, John, of Newmarket, Cams, yeoman 0
4661725 2249509 2249509 defendant Kirkeby John gent 592086 592086 Kirkeby, John, of Newmarket, Cams, gent 0
4662898 2249858 2249858 defendant Edward Thomas smith 592086 592086 Edward, Thomas, of Newmarket, Cams, smith 2
4906948 2328752 2328752 defendant Thyknesse John ostler 592086 592086 Thyknesse, John, of Newmarket, Cams, ostler 2
4937394 2338065 2338065 defendant Josep John hosteler 592086 592086 Josep, John, of Newmarket, Cams, hosteler 1
4939856 2338854 2338854 defendant Thorndon William yeoman 592086 592086 (Thorndon, William, of Newmarket, Cams, yeoman 1
4949329 2341775 2341775 defendant Jerveys John yeoman 592086 592086 Jerveys, John, of Newmarket, Cams, yeoman 0
4950591 2342147 2342147 defendant Ray- John yeoman 592086 592086 Ray-, John, of Newmarket, Cams, yeoman 0
4956942 2344034 2344034 defendant Leycestre Thomas merchant 592086 592086 Leycestre, Thomas, of Newmarket, Cams, merchant 0
4956978 2344045 2344045 defendant Leycestre Thomas merchant 592086 592086 Leycestre, Thomas, of Newmarket, Cams, merchant 0
4962198 2345597 2345597 defendant Pope William butcher 592086 592086 Pope, William, of Newmarket, Cams, butcher 1
4963813 2346088 2346088 defendant Wykys John esq 592086 592086 Wykys, John, of Newmarket, Cams, esq 1
4976540 2349943 2349943 defendant Ray John yeoman 592086 592086 Ray, John, of Newmarket, Cams, yeoman 0
5063367 2375571 2375571 defendant Greyson Arthur yeoman 592086 592086 Greyson, Arthur, of Newmarket, Cams, yeoman 1
5063373 2375572 2375572 defendant Greyson Arthur yeoman 592086 592086 Greyson, Arthur, of Newmarket, Cams, yeoman 1
5079058 2380224 2380224 defendant Leycetere John fishmonger 592086 592086 Leycetere, John, of Newmarket, Cams, fishmonger 0
5102825 2387243 2387243 defendant Coterell Nicholas ostler 592086 592086 Coterell, Nicholas, of Newmarket, Cams, ostler 0
5104812 2387844 2387844 defendant Leyston John chapman 592086 592086 Leyston, John, of Newmarket, Cams, chapman 0
5223059 2422458 2422458 defendant Breton John husbandman 592086 592086 Breton, John,of Newmarket, Cams, husbandman 2
5242802 2428099 2428099 defendant Dreyson Arthur esq 592086 592086 Dreyson, Arthur, of Newmarket, Cams, esq 1
5296084 2443844 2443844 defendant Exenyng Richard ostler 592086 592086 Exenyng, Richard, of Newmarket, Cams, ostler 1
5327991 2453439 2453439 defendant Cok Ralph ostler 592086 592086 Cok, Ralph, of Newmarket, Cams, ostler 0
5346846 2459170 2459170 defendant Kede John pedder 592086 592086 Kede, John, of Newmarket, Cams, pedder 0
5480660 2499180 2499180 defendant Reder John innholder 592086 592086 Reder, John, of Newmarket, Cams, innholder 0
5519071 2510810 2510810 defendant May Arthur chapman 592086 592086 May, Arthur, of Newmarket, Cams, chapman 2
5521294 2511477 2511477 defendant Donwald John gent 592086 592086 Donwald, John, of Newmarket, Cams, gent 4
5537696 2516278 2516278 defendant Cheveley Thomas innholder 592086 592086 Cheveley, Thomas, of Newmarket, Cams, innholder 0
5551998 2520624 2520624 defendant Byllyng Thomas   592086 592086 Byllyng, Thomas, of Newmarket, Cams, pedlar 3
5553844 2521163 2521163 defendant Baker John shoemaker 592086 592086 Baker, John, of Newmarket, Cams, shoemaker 0
5557730 2522211 2522211 defendant Jurdon Richard yeoman 592086 592086 Jurdon, Richard, of Newmarket, Cams, yeoman 2
5558232 2522356 2522356 defendant Baker John shoemaker 592086 592086 Baker, John, of Newmarket, Cams, shoemaker 2
5561466 2523332 2523332 defendant Baker John shoemaker 592086 592086 Baker, John, of Newmarket, Cams, shoemaker 0
5567390 2525042 2525042 defendant Lone or Love John yeoman 592086 592086 Lone or Love, John, of Newmarket, Cams, yeoman 0
5581107 2529160 2529160 defendant Whythale John fishmonger 592086 592086 Whythale, John, of Newmarket, Cams, fishmonger 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);