names

139 rows where place_id = 597527

✎ 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
3613044 1871731 1871731 defendant Avale Thomas husbandman 597527 597527 Avale, Thomas, of Stokton, Lempster, husbandman 0
3628917 1903921 1903921 defendant Robyns Joyce widow 597527 597527 Robyns, Joyce, of Stokton, widow 4
3635143 1905791 1905791 defendant Teryngton Simon clerk 597527 597527 Teryngton, Simon, of of Stokton, clerk 0
3639843 1907276 1907276 plaintiff Wryght William (legal representative) 597527 597527 Wryght, William, of Stokton, executors of 0
3639846 1907276 1907276 defendant Tower Robert clerk 597527 597527 Tower, Robert, of Stokton, clerk 0
3643743 1908470 1908470 defendant Eyre Robert gent 597527 597527 Eyre, Robert, of Stokton, gent 1
3655619 1912020 1912020 defendant Tower Robert clerk 597527 597527 Tower, Robert, of Stokton, clerk 0
3655620 1912020 1912020 defendant Neve Thomas husbandman 597527 597527 Neve, Thomas, of Stokton, husbandman 1
3658745 1912988 1912988 defendant Harryngton Nicholas chaplain 597527 597527 Harryngton, Nicholas, of Stokton, chaplain 0
3662720 1914258 1914258 defendant Croke Nicholas husbandman 597527 597527 Croke, Nicholas, of Stokton, husbandman 0
3664832 1914947 1914947 defendant Cokkys Thomas husbandman 597527 597527 Cokkys, Thomas, of Stokton, husbandman 0
3702897 1927178 1927178 defendant Farley Thomas husbandman 597527 597527 Farley, Thomas, of Stokton, husbandman 0
3716356 1931408 1931408 defendant Fuller Thomas butcher 597527 597527 Fuller, Thomas, of Stokton, butcher 0
3777445 1950694 1950694 defendant Fuller Thomas butcher 597527 597527 Fuller, Thomas, of Stokton, butcher 0
3794830 1956254 1956254 defendant Fuller Thomas butcher 597527 597527 Fuller, Thomas, of Stokton, butcher 0
3809334 1960802 1960802 defendant Felton Thomas husbandman 597527 597527 Felton, Thomas, of Stokton, husbandman 0
3834700 1968788 1968788 defendant Panter Thomas husbandman 597527 597527 Panter, Thomas, of Stokton, husbandman 2
3866717 1979102 1979102 defendant Eston Edward smith 597527 597527 Eston, Edward, of Stokton, smith 0
3889018 1986566 1986566 defendant Drury Nicholas husbandman 597527 597527 Drury, Nicholas, of Stokton, husbandman 2
3889019 1986566 1986566 defendant Playforth John yeoman 597527 597527 Playforth, John, of Stokton, yeoman 3
3896275 1988965 1988965 plaintiff Tompson William   597527 597527 Tompson, William, of Stokton, administrators of 0
3904393 1991714 1991714 defendant Vale Humphrey husbandman 597527 597527 Vale, Humphrey, of Stokton, husbandman 2
3914620 1995233 1995233 defendant Playforth John husbandman 597527 597527 Playforth, John, of Stokton, husbandman 0
3917437 1996190 1996190 defendant Parker John husbandman 597527 597527 Parker, John, of Stokton, husbandman 0
3943048 2004686 2004686 defendant Joyner William husbandman 597527 597527 Joyner, William, of Stokton, husbandman 0
4416787 2170119 2170119 defendant Friday Thomas   597527 597527 Friday, Thomas, of Stokton 0
4417544 2170374 2170374 defendant atte Hethe John   597527 597527 atte Hethe, John, of Stokton 0
4418096 2170539 2170539 defendant Hudard John   597527 597527 Hudard, John, of Stokton 0
4429140 2173921 2173921 defendant Hudard John   597527 597527 Hudard, John, of Stokton 0
4460555 2188361 2188361 plaintiff Warener John   597527 597527 Warener, John, of Stokton 1
4477039 2193478 2193478 defendant Waryn Edmund   597527 597527 Waryn, Edmund, of Stokton 2
4494885 2199087 2199087 defendant Brewer Geoffrey   597527 597527 Brewer, Geoffrey, of Stokton 0
4494887 2199087 2199087 defendant Nene Thomas   597527 597527 Nene, Thomas, of Stokton 2
4495283 2199201 2199201 defendant Stalon Thomas   597527 597527 Stalon, Thomas, of Stokton 1
4508127 2203016 2203016 defendant Gibonson Robert   597527 597527 Gibonson, Robert, of Stokton 0
4524226 2207912 2207912 defendant Smyth William   597527 597527 Smyth, William, of Stokton 0
4526986 2208722 2208722 defendant Lewyn Thomas   597527 597527 Lewyn, Thomas, of Stokton 0
4526987 2208722 2208722 defendant Hancok Thomas   597527 597527 Hancok, Thomas, of Stokton 1
4526989 2208723 2208723 defendant Lewyn Thomas   597527 597527 Lewyn, Thomas, of Stokton 0
4526990 2208723 2208723 defendant Hancok Thomas   597527 597527 Hancok, Thomas, of Stokton 1
4527156 2208777 2208777 defendant Taillour Thomas   597527 597527 Taillour, Thomas, of Stokton 3
4578875 2224873 2224873 defendant Havewode William   597527 597527 Havewode, William, of Stokton 0
4578877 2224874 2224874 defendant Hanwode William   597527 597527 Hanwode, William, of Stokton 0
4591730 2228767 2228767 defendant Salffe John chaplain 597527 597527 Salffe, John, of Stokton, chaplain 4
4607479 2233448 2233448 defendant Prior Edmund   597527 597527 Prior, Edmund, of Stokton 0
4634519 2241644 2241644 defendant Stanloweman Richard   597527 597527 Stanloweman, Richard, of Stokton 0
4651976 2246553 2246553 defendant Hert Richard husbandman 597527 597527 Hert, Richard, of Stokton, husbandman 0
4651981 2246554 2246554 defendant Hert Richard husbandman 597527 597527 Hert, Richard, of Stokton, husbandman 0
4654366 2247240 2247240 defendant Stovy John chaplain 597527 597527 Stovy, John, of Stokton, chaplain 0
4667381 2255519 2255519 defendant Kexby William husbandman 597527 597527 Kexby, William, of Stokton, husbandman 2
4676695 2258330 2258330 plaintiff Grane William   597527 597527 Grane, William, of Stokton, on his own account 0
4701022 2265724 2265724 defendant Joye John skinner 597527 597527 Joye, John, of Stokton, skinner 1
4701960 2266021 2266021 plaintiff Grane William   597527 597527 Grane, William, of Stokton 0
4716929 2270627 2270627 defendant del Grene Gerard butcher 597527 597527 del Grene, Gerard, of Stokton, butcher 0
4718958 2271275 2271275 defendant Walle Robert husbandman 597527 597527 Walle, Robert, of Stokton, husbandman 0
4726600 2273593 2273593 defendant Carleton John husbandman 597527 597527 Carleton, John, of Stokton, husbandman 7
4727507 2273845 2273845 defendant Stokton John husbandman 597527 597527 Stokton, John, of Stokton, husbandman 2
4755434 2282079 2282079 defendant Prest William husbandman 597527 597527 Prest, William, of Stokton, husbandman 2
4755441 2282080 2282080 defendant Prest William husbandman 597527 597527 Prest, William, of Stokton, husbandman 2
4768916 2286258 2286258 defendant Baret John husbandman 597527 597527 (Baret, John, of Stokton, husbandman 1
4775923 2288473 2288473 defendant Danels John clerk 597527 597527 Danels, John, of Stokton, clerk 0
4782880 2290666 2290666 defendant Stokton John yeoman 597527 597527 Stokton, John, of Stokton, yeoman 0
4782881 2290666 2290666 defendant Stafford Julia widow 597527 597527 Stafford, Julia, of Stokton, widow 1
4804012 2297437 2297437 defendant Astewall John yeoman 597527 597527 Astewall, John, of Stokton, yeoman 4
4811911 2299841 2299841 defendant Edwardes John tailor 597527 597527 Edwardes, John, of Stokton, tailor 0
4827645 2304695 2304695 defendant Pynkene Robert husbandman 597527 597527 Pynkene, Robert, of Stokton, husbandman 0
4834623 2306832 2306832 plaintiff Crook William   597527 597527 Crook, William, of Stokton 0
4834624 2306832 2306832 plaintiff Correld John   597527 597527 Correld, John, of Stokton 1
4849833 2311420 2311420 defendant Merssh Lawrence   597527 597527 Merssh, Lawrence, of Stokton, parson 2
4858531 2314041 2314041 defendant Daggeworth Robert yeoman 597527 597527 Daggeworth, Robert, of Stokton, yeoman 4
4861569 2314989 2314989 plaintiff Crook William   597527 597527 Crook, William, of Stokton 0
4861570 2314989 2314989 plaintiff Terrold John   597527 597527 Terrold, John, of Stokton 1
4868298 2317061 2317061 defendant Burgh Hugh husbandman 597527 597527 Burgh, Hugh, of Stokton, husbandman 0
4881901 2321238 2321238 defendant Hunte Thomas yeoman 597527 597527 Hunte, Thomas, of Stokton, yeoman 0
4898466 2326173 2326173 defendant Brytemere Thomas husbandman 597527 597527 Brytemere, Thomas, of Stokton, husbandman 3
4898898 2326297 2326297 defendant Tomson John thatcher 597527 597527 Tomson, John, of Stokton, thatcher 3
4928693 2335398 2335398 defendant Vale William husbandman 597527 597527 Vale, William, of Stokton, husbandman 0
4928694 2335398 2335398 defendant Vale John husbandman 597527 597527 Vale, John, of Stokton, husbandman 1
4928695 2335398 2335398 defendant Wylkes William husbandman 597527 597527 Wylkes, William, of Stokton, husbandman 2
4941713 2339431 2339431 defendant Cokerell Thomas husbandman 597527 597527 Cokerell, Thomas, of Stokton, husbandman 0
4945523 2340578 2340578 defendant Farley John gent 597527 597527 Farley, John, of Stokton, gent 0
4967535 2347232 2347232 defendant Salf Reginald husbandman 597527 597527 Salf, Reginald, of Stokton, husbandman 3
4967537 2347233 2347233 defendant Salf Reginald husbandman 597527 597527 Salf, Reginald, of Stokton, husbandman 0
4973667 2349075 2349075 defendant Mascall Agnes widow 597527 597527 Mascall, Agnes, of Stokton, widow 0
5002443 2357626 2357626 defendant Davy Thomas clerk 597527 597527 Davy, Thomas, of Stokton, clerk 1
5004678 2358272 2358272 defendant Benet Thomas chaplain 597527 597527 Benet, Thomas, of Stokton, chaplain 0
5008654 2359425 2359425 defendant Wright Thomas clerk 597527 597527 Wright, Thomas, of Stokton, clerk 2
5010005 2359795 2359795 defendant Baker Richard husbandman 597527 597527 Baker, Richard, of Stokton, husbandman 0
5028183 2365113 2365113 defendant Farley John gent 597527 597527 Farley, John, of Stokton, gent 0
5062889 2375436 2375436 defendant Coverdale John husbandman 597527 597527 Coverdale, John, of Stokton, husbandman 1
5083381 2381525 2381525 defendant Taillard John   597527 597527 Taillard, John, of Stokton 0
5103303 2387396 2387396 defendant Farley John gent 597527 597527 Farley, John, of Stokton, gent 0
5135081 2396757 2396757 defendant Hancok John husbandman 597527 597527 Hancok, John, of Stokton, husbandman 0
5155189 2402665 2402665 defendant Hancok John husbandman 597527 597527 Hancok, John, of Stokton, husbandman 0
5162255 2404687 2404687 defendant Mascall Thomas summoner 597527 597527 Mascall, Thomas, of Stokton, summoner 2
5165437 2405636 2405636 defendant Brightmer John husbandman 597527 597527 Brightmer, John, of Stokton, husbandman 0
5165438 2405636 2405636 defendant Brightmer Thomas husbandman 597527 597527 Brightmer, Thomas, of Stokton, husbandman 1
5171920 2407502 2407502 defendant Hancok John husbandman 597527 597527 Hancok, John, of Stokton, husbandman 0
5176399 2408783 2408783 defendant Mascall Thomas summoner 597527 597527 together with Mascall, Thomas, of Stokton, summoner 2
5176406 2408785 2408785 defendant Mascall Thomas   597527 597527 Mascall, Thomas, of Stokton 0

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