names

96 rows where place_id = 586664

✎ 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
3589326 1864304 1864304 defendant Wodehous Edward (legal representative) 586664 586664 Wodehous, Edward, of Kymberley, knight, executors of 4
3589328 1864304 1864304 defendant Wodehous Thomas esq 586664 586664 Wodehous, Thomas, of Kymberley, esq 6
3592136 1865158 1865158 defendant Holdernes Gregory husbandman 586664 586664 Holdernes, Gregory, of Kymberley, husbandman 0
3603349 1868720 1868720 defendant Curson John husbandman 586664 586664 Curson, John, of Kymberley, husbandman 2
3605443 1869367 1869367 defendant Curson John husbandman 586664 586664 Curson, John, of Kymberley, husbandman 2
3646147 1909197 1909197 defendant Woodehous Thomas   586664 586664 Woodehous, Thomas, of Kymberley, knight 0
3647543 1909622 1909622 defendant Fyttelyng Edward husbandman 586664 586664 Fyttelyng, Edward, of Kymberley, husbandman 0
3648730 1909989 1909989 defendant Lubbenham John clerk 586664 586664 Lubbenham, John, of Kymberley, clerk 0
3684084 1921157 1921157 plaintiff Wodehous Thomas   586664 586664 Wodehous, Thomas, of Kymberley, knight 0
3688408 1922532 1922532 defendant Martyn Alexander husbandman 586664 586664 Martyn, Alexander, of Kymberley, husbandman 1
3688410 1922532 1922532 defendant Whygthe Alexander laborer 586664 586664 Whygthe, Alexander, of Kymberley, laborer 3
3689379 1922841 1922841 defendant Damporthe John gent 586664 586664 Damporthe, John, of Kymberley, gent 0
3704970 1927847 1927847 defendant Uttyng Nicholas husbandman 586664 586664 Uttyng, Nicholas, of Kymberley, husbandman 1
3707089 1928505 1928505 defendant Master Robert husbandman 586664 586664 Master, Robert, of Kymberley, husbandman 1
3707090 1928505 1928505 defendant Water William husbandman 586664 586664 Water, William, of Kymberley, husbandman 2
3743549 1939858 1939858 defendant Marten Alexander husbandman 586664 586664 Marten, Alexander, of Kymberley, husbandman 0
3745363 1940456 1940456 defendant Wodehous Thomas   586664 586664 Wodehous, Thomas, of Kymberley, knight 0
3776763 1950478 1950478 plaintiff Bytteryng Robert clerk 586664 586664 Bytteryng, Robert, of Kymberley, clerk 0
3789835 1954649 1954649 defendant Martyn Alexander husbandman 586664 586664 Martyn, Alexander, of Kymberley, husbandman 2
3794366 1956116 1956116 defendant Pycher Edmund husbandman 586664 586664 Pycher, Edmund, of Kymberley, husbandman 1
3825450 1965809 1965809 defendant Weston William collier 586664 586664 Weston, William, of Kymberley, collier 12
3846027 1972316 1972316 defendant Woodhows Roger esq 586664 586664 Woodhows, Roger, of Kymberley, esq 0
3864314 1978259 1978259 defendant Denby John husbandman 586664 586664 Denby, John, of Kymberley, husbandman 0
3907952 1992950 1992950 defendant Tanne William husbandman 586664 586664 Tanne, William, of Kymberley, husbandman 3
3915684 1995619 1995619 defendant Garrard John husbandman 586664 586664 Garrard, John, of Kymberley, husbandman: Laws, John, of Kymberley, husbandman 0
3915685 1995619 1995619 defendant Gyrlyng John husbandman 586664 586664 Gyrlyng, John, of Kymberley, husbandman 1
3919475 1996846 1996846 defendant Woodhous Thomas esq 586664 586664 Woodhous, Thomas, of Kymberley, esq 0
3942515 2004505 2004505 plaintiff Wodehouse Roger   586664 586664 Wodehouse, Roger, of Kymberley, knight 0
3942516 2004505 2004505 defendant Moore William gent 586664 586664 Moore, William, of Kymberley, gent 0
3945084 2005373 2005373 defendant Gyrlyng Thomas husbandman 586664 586664 Gyrlyng, Thomas, of Kymberley, husbandman 0
3948098 2006400 2006400 defendant Fytlyng Lawrence husbandman 586664 586664 Fytlyng, Lawrence, of Kymberley, husbandman 2
3967516 2013274 2013274 defendant Moore Leonard gent 586664 586664 Moore, Leonard, of Kymberley, gent 0
3970147 2014157 2014157 defendant Curson John yeoman 586664 586664 Curson, John, of Kymberley, yeoman 2
3972329 2014891 2014891 plaintiff Futter John gent 586664 586664 Futter, John, of Kymberley, gent 0
3999522 2024593 2024593 defendant Curson John husbandman 586664 586664 Curson, John, of Kymberley, husbandman 0
4004650 2026439 2026439 defendant Fytlyng Lawrence yeoman 586664 586664 Fytlyng, Lawrence, of Kymberley, yeoman 1
4017759 2031060 2031060 defendant Fytlyn Lawrence husbandman 586664 586664 Fytlyn, Lawrence, of Kymberley, husbandman 0
4018315 2031278 2031278 defendant Broke Thomas husbandman 586664 586664 Broke, Thomas, of Kymberley, husbandman 1
4020830 2032178 2032178 plaintiff Woodhowse Roger esq 586664 586664 Woodhowse, Roger, of Kymberley, esq 0
4020832 2032179 2032179 plaintiff Woodhowse Roger esq 586664 586664 Woodhowse, Roger, of Kymberley, esq 0
4044396 2040449 2040449 defendant Stone Richard yeoman 586664 586664 Stone, Richard, of Kymberley, yeoman 1
4076666 2051943 2051943 defendant Godfrey Richard husbandman 586664 586664 Godfrey, Richard, of Kymberley, husbandman 9
4107976 2063125 2063125 defendant Holdernes John husbandman 586664 586664 Holdernes, John, of Kymberley, husbandman 0
4205221 2097376 2097376 defendant Freman Robert   586664 586664 Freman, Robert, of Kymberley, woollen draper 1
4261763 2116890 2116890 defendant Curson William husbandman 586664 586664 Curson, William, of Kymberley, husbandman 0
4261764 2116890 2116890 defendant Curson John husbandman 586664 586664 Curson, John, of Kymberley, husbandman 1
4286129 2125093 2125093 defendant Neave Simon yeoman 586664 586664 Neave, Simon, of Kymberley, yeoman 2
4386918 2160290 2160290 defendant Dawes Richard husbandman 586664 586664 Dawes, Richard, of Kymberley, husbandman 2
4386919 2160290 2160290 defendant Moore Leonard yeoman 586664 586664 Moore, Leonard, of Kymberley, yeoman 3
4390269 2161367 2161367 defendant Keede Thomas yeoman 586664 586664 Keede, Thomas, of Kymberley, yeoman 0
4403552 2165762 2165762 defendant Watson William yeoman 586664 586664 Watson, William, of Kymberley, yeoman 0
4410688 2168166 2168166 defendant Carman Edward sherman 586664 586664 Carman, Edward, of Kymberley, sherman 3
4761071 2283814 2283814 defendant Turnour John   586664 586664 Turnour, John, of Kymberley, plough man 0
4784391 2291120 2291120 defendant Turnour John ploughman 586664 586664 Turnour, John, of Kymberley, ploughman 0
4945131 2340457 2340457 defendant Baker John husbandman 586664 586664 Baker, John, of Kymberley, husbandman 0
5000962 2357162 2357162 defendant Kynge Walter, sen   586664 586664 Kynge, Walter, sen, of Kymberley, shepherd 0
5000964 2357162 2357162 defendant Martyn John yeoman 586664 586664 Martyn, John, of Kymberley, yeoman 2
5007423 2359064 2359064 defendant Willes John   586664 586664 Willes, John, of Kymberley, vicar 5
5051693 2372119 2372119 defendant Wyghtman Henry husbandman 586664 586664 Wyghtman, Henry, of Kymberley, husbandman 0
5051694 2372119 2372119 defendant Oldman William husbandman 586664 586664 Oldman, William, of Kymberley, husbandman 1
5051742 2372132 2372132 defendant Sorpe Walter husbandman 586664 586664 Sorpe, Walter, of Kymberley, husbandman 0
5065135 2376105 2376105 defendant Kynge Richard husbandman 586664 586664 (Kynge, Richard, of Kymberley, husbandman 1
5091093 2383790 2383790 defendant Holdirnesse Gregory yeoman 586664 586664 Holdirnesse, Gregory, of Kymberley, yeoman 4
5099787 2386377 2386377 defendant Skemyn Thomas husbandman 586664 586664 Skemyn, Thomas, of Kymberley, husbandman 0
5108637 2388962 2388962 plaintiff Fitlyng John   586664 586664 Fitlyng, John, of Kymberley 0
5108640 2388962 2388962 defendant Oldman William husbandman 586664 586664 Oldman, William, of Kymberley, husbandman 2
5114646 2390698 2390698 defendant Andrewe Richard husbandman 586664 586664 Andrewe, Richard, of Kymberley, husbandman 2
5114647 2390698 2390698 defendant Kymberley William husbandman 586664 586664 Kymberley, William, of Kymberley, husbandman 3
5163794 2405146 2405146 defendant Fysshe Thomas husbandman 586664 586664 Fysshe, Thomas, of Kymberley, husbandman 0
5163795 2405146 2405146 defendant Fysshe Robert husbandman 586664 586664 Fysshe, Robert, of Kymberley, husbandman 1
5190325 2412913 2412913 defendant Alpe Thomas husbandman 586664 586664 Alpe, Thomas, of Kymberley, husbandman 2
5222152 2422184 2422184 defendant Corbald Nicholas husbandman 586664 586664 Corbald, Nicholas, of Kymberley, husbandman 0
5229724 2424313 2424313 defendant Kyng Walter yeoman 586664 586664 Kyng, Walter, of Kymberley, yeoman 2
5254518 2431535 2431535 defendant Wodehous Edward esq 586664 586664 Wodehous, Edward, of Kymberley, esq 0
5256627 2432192 2432192 plaintiff Drynkale John (legal representative) 586664 586664 Drynkale, John, of Kymberley, executor of 0
5256630 2432193 2432193 plaintiff Drynkale John (legal representative) 586664 586664 Drynkale, John, of Kymberley, executor of 0
5260830 2433510 2433510 defendant Kyng Walter husbandman 586664 586664 Kyng, Walter, of Kymberley, husbandman 0
5312863 2448878 2448878 defendant Annesley or Aimesley Thomas husbandman 586664 586664 Annesley or Aimesley, Thomas, of of Kymberley, husbandman 2
5334443 2455374 2455374 defendant Holdernesse Gregory husbandman 586664 586664 Holdernesse, Gregory, of Kymberley, husbandman 0
5337151 2456184 2456184 defendant Fitlyng John husbandman 586664 586664 Fitlyng, John, of Kymberley, husbandman 9
5350843 2460375 2460375 defendant Curson Robert husbandman 586664 586664 Curson, Robert, of Kymberley, husbandman 0
5350845 2460376 2460376 defendant Wodehous John esq 586664 586664 Wodehous, John, of Kymberley, gent, son of Wodehous, John, esq 0
5361880 2463740 2463740 defendant Holdernesse Gregory husbandman 586664 586664 Holdernesse, Gregory, of Kymberley, husbandman 0
5368231 2465689 2465689 defendant Alpe Simon husbandman 586664 586664 Alpe, Simon, of Kymberley, husbandman 1
5368232 2465689 2465689 defendant Estwyayte Geoffrey husbandman 586664 586664 Estwyayte, Geoffrey, of Kymberley, husbandman 2
5386648 2471245 2471245 defendant Alpe Simon husbandman 586664 586664 Alpe, Simon, of Kymberley, husbandman 1
5426606 2482904 2482904 defendant Wodhous John gent 586664 586664 Wodhous, John, of Kymberley, gent 1
5480349 2499104 2499104 defendant Wodehous Edward   586664 586664 Wodehous, Edward, of Kymberley, knight 0
5480350 2499104 2499104 defendant Wodehous John gent 586664 586664 Wodehous, John, of Kymberley, gent 1
5498852 2504597 2504597 defendant Rodes Robert husbandman 586664 586664 Rodes, Robert, of Kymberley, husbandman 1
5498853 2504597 2504597 defendant Broke Thomas husbandman 586664 586664 Broke, Thomas, of Kymberley, husbandman 2
5499713 2504856 2504856 defendant Curson John husbandman 586664 586664 Curson, John, of Kymberley, husbandman 1
5541728 2517524 2517524 defendant Rodes Robert yeoman 586664 586664 Rodes, Robert, of Kymberley, yeoman 1
5544038 2518244 2518244 defendant Grey Thomas yeoman 586664 586664 Grey, Thomas, of Kymberley, yeoman 1
5568820 2525431 2525431 defendant Brette Thomas husbandman 586664 586664 Brette, Thomas, of Kymberley, husbandman 2
5603525 2535984 2535984 defendant Wodehous Thomas esq 586664 586664 Wodehous, Thomas, of Kymberley, esq 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);