names

64 rows where place_id = 598423

✎ 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
3632387 1904949 1904949 defendant Harryson John husbandman 598423 598423 Harryson, John, of Fyncheley, husbandman 1
3644847 1908796 1908796 plaintiff Fox William   598423 598423 Fox, William, of Fyncheley 0
3662955 1914326 1914326 defendant Harryson Isabel widow 598423 598423 Harryson, Isabel, of Fyncheley, widow 1
3689332 1922827 1922827 defendant Hasylwod Alexander laborer 598423 598423 Hasylwod, Alexander, of Fyncheley, laborer 1
3692348 1923778 1923778 defendant Hastynges George   598423 598423 Hastynges, George, of Fyncheley, knight 0
3696871 1925242 1925242 defendant Pratt William yeoman 598423 598423 Pratt, William, of Fyncheley, yeoman 1
3733686 1936779 1936779 defendant Morton Valentine tiler 598423 598423 Morton, Valentine, of Fyncheley, tiler 0
3784417 1952908 1952908 defendant Smyth Roger husbandman 598423 598423 Smyth, Roger, of Fyncheley, husbandman 0
3800251 1957998 1957998 defendant Pratte William husbandman 598423 598423 Pratte, William, of Fyncheley, husbandman 4
4271907 2120178 2120178 defendant Luddington John gent 598423 598423 Luddington, John, of Fyncheley, or of Thavys Inn, Holborne, Middx, gent 0
4318839 2136703 2136703 defendant Shepperde John   598423 598423 Shepperde, John, of Fyncheley, yeoman, his son 1
4328277 2139772 2139772 defendant Page Freman yeoman 598423 598423 Page, Freman, of Fyncheley, yeoman 1
4443691 2182994 2182994 defendant Docyer Richard   598423 598423 Docyer, Richard, of Fyncheley 3
4837520 2307670 2307670 defendant Lucy Richard yeoman 598423 598423 Lucy, Richard, of Fyncheley, yeoman 0
4946060 2340754 2340754 defendant Grote Andrew   598423 598423 Grote, Andrew, of Fyncheley, Middx gent 0
4949629 2341880 2341880 defendant Gokewod Thomas husbandman 598423 598423 Gokewod, Thomas, of Fyncheley, husbandman 3
5009253 2359591 2359591 defendant Grote Andrew gent 598423 598423 Grote, Andrew, of Fyncheley, gent 0
5023144 2363671 2363671 defendant Coppewode Thomas husbandman 598423 598423 Coppewode, Thomas, of Fyncheley, husbandman 0
5032976 2366531 2366531 defendant Palmer Peter husbandman 598423 598423 Palmer, Peter, of Fyncheley, husbandman 2
5035778 2367319 2367319 defendant Grote Andrew gent 598423 598423 Grote, Andrew, of Fyncheley, gent 0
5063863 2375723 2375723 defendant Copwode Thomas husbandman 598423 598423 Copwode, Thomas, of Fyncheley, husbandman 0
5095301 2385044 2385044 plaintiff Shepherd John husbandman 598423 598423 Shepherd, John, of Fyncheley, husbandman 0
5095302 2385044 2385044 defendant Cachet John yeoman 598423 598423 Cachet, John, of Fyncheley, yeoman 0
5107668 2388674 2388674 defendant Doget John husbandman 598423 598423 Doget, John, of Fyncheley, husbandman 0
5186202 2411714 2411714 defendant Samey John husbandman 598423 598423 Samey, John, of Fyncheley, husbandman 0
5265185 2434872 2434872 defendant Noke Thomas laborer 598423 598423 Noke, Thomas, of Fyncheley, laborer 0
5265186 2434872 2434872 defendant Noke John laborer 598423 598423 Noke, John, of Fyncheley, laborer 1
5265187 2434872 2434872 defendant Prat Richard laborer 598423 598423 Prat, Richard, of Fyncheley, laborer 2
5265188 2434872 2434872 defendant Coppewode Thomas husbandman 598423 598423 Coppewode, Thomas, of Fyncheley, husbandman 3
5265189 2434872 2434872 defendant Coppewode Richard husbandman 598423 598423 Coppewode, Richard, of Fyncheley, husbandman 4
5265190 2434872 2434872 defendant Dogget John brewer 598423 598423 Dogget, John, of Fyncheley, brewer 5
5265191 2434872 2434872 defendant Fox Thomas husbandman 598423 598423 Fox, Thomas, of Fyncheley, husbandman 6
5265311 2434908 2434908 defendant Noke Thomas laborer 598423 598423 Noke, Thomas, of Fyncheley, laborer 0
5265312 2434908 2434908 defendant Noke John laborer 598423 598423 Noke, John, of Fyncheley, laborer 1
5265313 2434908 2434908 defendant Prat Richard laborer 598423 598423 Prat, Richard, of Fyncheley, laborer 2
5265314 2434908 2434908 defendant Copwode Thomas husbandman 598423 598423 Copwode, Thomas, of Fyncheley, husbandman 3
5265315 2434908 2434908 defendant Copwode Richard   598423 598423 Copwode, Richard, of Fyncheley 4
5310819 2448272 2448272 defendant Smyth William collier 598423 598423 Smyth, William, of Fyncheley, collier 1
5347724 2459442 2459442 defendant Shepard Thomas husbandman 598423 598423 Shepard, Thomas, of Fyncheley, husbandman 0
5359261 2462933 2462933 defendant Smyth Richard husbandman 598423 598423 Smyth, Richard, of Fyncheley, husbandman 0
5359262 2462933 2462933 defendant Smyth Robert husbandman 598423 598423 Smyth, Robert, of Fyncheley, husbandman 1
5360855 2463421 2463421 defendant Doget John husbandman 598423 598423 Doget, John, of Fyncheley, husbandman 0
5363360 2464193 2464193 defendant Ademounde Richard (legal representative) 598423 598423 Ademounde, Richard, of Fyncheley, husbandman, executrix of 5
5363361 2464193 2464193 defendant Ademounde Mary widow 598423 598423 Ademounde, Mary, of Fyncheley, widow 6
5372774 2467088 2467088 defendant Smyth Richard husbandman 598423 598423 Smyth, Richard, of Fyncheley, husbandman 2
5372775 2467088 2467088 defendant Merssh William husbandman 598423 598423 Merssh, William, of Fyncheley, husbandman 3
5381818 2469857 2469857 defendant Spycer alias Smyth William husbandman 598423 598423 Spycer alias Smyth, William, of Fyncheley, husbandman 0
5381819 2469857 2469857 defendant Shepherd Thomas husbandman 598423 598423 Shepherd, Thomas, of Fyncheley, husbandman 1
5381820 2469857 2469857 defendant Smyth Richard husbandman 598423 598423 Smyth, Richard, of Fyncheley, husbandman 2
5381821 2469857 2469857 defendant Mersshe William husbandman 598423 598423 Mersshe, William, of Fyncheley, husbandman 3
5381822 2469857 2469857 defendant Shepherd John carpenter 598423 598423 Shepherd, John, of Fyncheley, carpenter 4
5390889 2472463 2472463 defendant Perkyns John husbandman 598423 598423 Perkyns, John, of Fyncheley, husbandman 0
5394278 2473428 2473428 defendant Smyth Richard husbandman 598423 598423 Smyth, Richard, of Fyncheley, husbandman 0
5407646 2477256 2477256 defendant Smyth Richard husbandman 598423 598423 Smyth, Richard, of Fyncheley, husbandman 0
5420865 2481170 2481170 defendant Smyth Richard husbandman 598423 598423 Smyth, Richard, of Fyncheley, husbandman 0
5439923 2486885 2486885 defendant Smyth Richard husbandman 598423 598423 Smyth, Richard, of Fyncheley, husbandman 0
5456475 2491860 2491860 defendant Vernon William gent 598423 598423 Vernon, William, of Fyncheley, gent 0
5465403 2494562 2494562 defendant Smyth Richard husbandman 598423 598423 Smyth, Richard, of Fyncheley, husbandman 0
5468294 2495459 2495459 defendant Vernon William gent 598423 598423 Vernon, William, of Fyncheley, gent 0
5468296 2495460 2495460 defendant Vernon William gent 598423 598423 Vernon, William, of Fyncheley, gent 0
5476875 2498090 2498090 defendant Smyth Richard husbandman 598423 598423 Smyth, Richard, of Fyncheley, husbandman 0
5573795 2526901 2526901 defendant Rolfe Margaret widow 598423 598423 Rolfe, Margaret, of Fyncheley, or of Cheswyke, Middx, widow 0
5590465 2531984 2531984 defendant Purcyfaunt John   598423 598423 Purcyfaunt, John, of Fyncheley, coal carrier 1
5609102 2537752 2537752 defendant Shepherd John pewterer 598423 598423 Shepherd, John, of Fyncheley, pewterer 4

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