names

79 rows where place_id = 594911

✎ 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
3618089 1873280 1873280 defendant Kent William tailor 594911 594911 Kent, William, of Tyryngton, tailor 2
3622983 1874715 1874715 plaintiff Russell Robert   594911 594911 Russell, Robert, of Tyryngton 0
3622985 1874716 1874716 plaintiff Russell Robert   594911 594911 Russell, Robert, of Tyryngton 0
3731224 1935991 1935991 defendant Talp or Talper William husbandman 594911 594911 Talp or Talper, William, of Tyryngton, husbandman 3
3737369 1937926 1937926 plaintiff Lexham David tailor 594911 594911 Lexham, David, of Tyryngton, tailor 0
3785693 1953317 1953317 defendant Russell Robert (legal representative) 594911 594911 Russell, Robert, of Tyryngton, yeoman, executor of 0
3785698 1953318 1953318 defendant Lynghake John yeoman 594911 594911 Lynghake, John, of Tyryngton, yeoman 1
3868584 1979731 1979731 defendant Robertson John laborer 594911 594911 Robertson, John, of Tyryngton, laborer 0
3868585 1979731 1979731 defendant Estlond John husbandman 594911 594911 Estlond, John, of Tyryngton, husbandman 1
4419256 2170900 2170900 defendant Aldebigg Benedict de   594911 594911 Aldebigg, Benedict de, of Tyryngton, son of Peter 0
4420393 2171283 2171283 defendant Lombard Hanhardus   594911 594911 Lombard, Hanhardus, of Tyryngton 0
4437363 2176431 2176431 plaintiff Warde John   594911 594911 Warde, John, of Tyryngton 0
4439570 2181640 2181640 plaintiff Balsham John   594911 594911 Balsham, John, of Tyryngton 0
4447658 2184190 2184190 plaintiff Eston Walter de   594911 594911 Eston, Walter de, of Tyryngton, vicar 0
4463893 2189385 2189385 defendant atte Pyt Thomas   594911 594911 atte Pyt, Thomas, of Tyryngton 0
4471806 2191847 2191847 defendant Sweyn John   594911 594911 Sweyn, John, of Tyryngton 0
4505779 2202316 2202316 defendant Carter Robert   594911 594911 Carter, Robert, of Tyryngton 0
4510043 2203627 2203627 defendant Thornton Edmund   594911 594911 Thornton, Edmund, of Tyryngton 0
4601093 2231572 2231572 plaintiff Smyth Alan   594911 594911 Smyth, Alan, of Tyryngton 2
4660659 2249158 2249158 defendant Fisshere Stephen butcher 594911 594911 Fisshere, Stephen, of Tyryngton, butcher 1
4664133 2250269 2250269 plaintiff Haket Peter   594911 594911 Haket, Peter, of Tyryngton 0
4664141 2250272 2250272 plaintiff Hale Peter   594911 594911 Hale, Peter, of Tyryngton 0
4669976 2256308 2256308 plaintiff Bremore John   594911 594911 Bremore, John, of Tyryngton, parson, on his own account 0
4708247 2267957 2267957 defendant Souter Edward   594911 594911 Souter, Edward, of Tyryngton, shoe maker 0
4722903 2272481 2272481 plaintiff Cowepeman Walter chaplain 594911 594911 Cowepeman, Walter, of Tyryngton, chaplain 0
4725638 2273304 2273304 defendant Sweyn John   594911 594911 Sweyn, John, of Tyryngton, husb 7
4736519 2276550 2276550 defendant Baldyng Walter brewer 594911 594911 Baldyng, Walter, of Tyryngton, brewer 5
4738612 2277165 2277165 defendant Talpe Thomas husbandman 594911 594911 Talpe, Thomas, of Tyryngton, husbandman 0
4741888 2278125 2278125 defendant Cater John husbandman 594911 594911 Cater, John, of Tyryngton, husbandman 1
4751593 2280953 2280953 defendant Jakson Robert husbandman 594911 594911 Jakson, Robert, of Tyryngton, husbandman 0
4751594 2280953 2280953 defendant Hopkynson Jakson William husbandman 594911 594911 Hopkynson Jakson, William, of Tyryngton, husbandman 1
4781053 2290083 2290083 defendant Taillour Nicholas yeoman 594911 594911 Taillour, Nicholas, of Tyryngton, yeoman 0
4781054 2290083 2290083 defendant Noreys Robert laborer 594911 594911 Noreys, Robert, of Tyryngton, laborer 1
4796255 2294975 2294975 defendant Hungat Thomas yeoman 594911 594911 Hungat, Thomas, of Tyryngton, yeoman 1
4796256 2294975 2294975 defendant Twyngg Richard yeoman 594911 594911 Twyngg, Richard, of Tyryngton, yeoman 2
4796257 2294975 2294975 defendant Person William yeoman 594911 594911 Person, William, of Tyryngton, yeoman 3
4796349 2295007 2295007 defendant Tuygges Richard husbandman 594911 594911 Tuygges, Richard, of Tyryngton, husbandman 0
4800118 2296216 2296216 defendant FitzRichard Thomas   594911 594911 FitzRichard, Thomas, of Tyryngton 1
4802298 2296907 2296907 defendant Fornfeld Thomas yeoman 594911 594911 Fornfeld, Thomas, of Tyryngton, yeoman 2
4809596 2299166 2299166 defendant Jakson Robert husbandman 594911 594911 Jakson, Robert, of Tyryngton, husbandman 0
4892183 2324301 2324301 plaintiff Baldyng William (legal representative) 594911 594911 Baldyng, William, of Tyryngton, administrator of 0
4901808 2327172 2327172 plaintiff Walbot Richard   594911 594911 Walbot, Richard, of Tyryngton 0
4917891 2332109 2332109 defendant Bocher Robert butcher 594911 594911 Bocher, Robert, of Tyryngton, butcher 0
4917892 2332109 2332109 defendant Bocher Thomas butcher 594911 594911 Bocher, Thomas, of Tyryngton, butcher 1
4932218 2336476 2336476 defendant Calewe William yeoman 594911 594911 Calewe, William, of Tyryngton, yeoman 2
4950599 2342150 2342150 defendant Burdy John chaplain 594911 594911 Burdy, John, of Tyryngton, chaplain 0
4950600 2342150 2342150 defendant Emneth William husbandman 594911 594911 Emneth, William, of Tyryngton, husbandman 1
4950601 2342150 2342150 defendant Browne Thomas husbandman 594911 594911 Browne, Thomas, of Tyryngton, husbandman 2
4951296 2342368 2342368 defendant Andreweson Roger chaplain 594911 594911 Andreweson, Roger, of Tyryngton, chaplain 1
4967121 2347100 2347100 defendant Hobbes William butcher 594911 594911 Hobbes, William, of Tyryngton, butcher 0
4967130 2347101 2347101 defendant Say John weaver 594911 594911 Say, John, of Tyryngton, weaver 0
4967131 2347101 2347101 defendant Herchell William husbandman 594911 594911 Herchell, William, of Tyryngton, husbandman 1
4970086 2348004 2348004 plaintiff Lade Richard   594911 594911 Lade, Richard, of Tyryngton 2
4992389 2354609 2354609 defendant Talpe William husbandman 594911 594911 Talpe, William, of Tyryngton, husbandman 0
4995734 2355565 2355565 defendant Sirove William yeoman 594911 594911 Sirove, William, of Tyryngton, yeoman 0
5021503 2363192 2363192 defendant Roussell Lorun husbandman 594911 594911 Roussell, Lorun, of Tyryngton, husbandman 1
5039280 2368392 2368392 defendant Ppereson John husbandman 594911 594911 Ppereson, John, of Tyryngton, husbandman 0
5039281 2368392 2368392 defendant Bamburgh John husbandman 594911 594911 Bamburgh, John, of Tyryngton, husbandman 1
5039282 2368392 2368392 defendant Kele John husbandman 594911 594911 Kele, John, of Tyryngton, husbandman 2
5041787 2369145 2369145 defendant Enemeth William husbandman 594911 594911 Enemeth, William, of Tyryngton, husbandman 0
5074403 2378846 2378846 defendant Stalker James   594911 594911 Stalker, James, of Tyryngton, groom 0
5091177 2383820 2383820 defendant Botry John husbandman 594911 594911 Botry, John, of Tyryngton, husbandman 0
5091178 2383820 2383820 defendant Aston Peter (legal representative) 594911 594911 Aston, Peter, of Tyryngton, yeoman, executors of 1
5091180 2383820 2383820 defendant Justas or Instas John chaplain 594911 594911 Justas or Instas, John, of Tyryngton, chaplain 3
5091181 2383820 2383820 defendant Aston Margaret widow 594911 594911 Aston, Margaret, of Tyryngton, widow 4
5100271 2386524 2386524 defendant Boston Adam butcher 594911 594911 Boston, Adam, of Tyryngton, butcher 0
5100272 2386524 2386524 defendant Emnette William husbandman 594911 594911 Emnette, William, of Tyryngton, husbandman 1
5100273 2386524 2386524 defendant Boston John husbandman 594911 594911 Boston, John, of Tyryngton, husbandman 2
5100274 2386524 2386524 defendant Baldyng John butcher 594911 594911 Baldyng, John, of Tyryngton, butcher 3
5100275 2386524 2386524 defendant Paternak Peter husbandman 594911 594911 Paternak, Peter, of Tyryngton, husbandman 4
5137172 2397384 2397384 plaintiff Pereson (illegible) clerk 594911 594911 Pereson, --, of Tyryngton, clerk 0
5193640 2413866 2413866 plaintiff Pereson John clerk 594911 594911 Pereson, John, of Tyryngton, clerk 0
5229982 2424384 2424384 plaintiff Aston Peter (legal representative) 594911 594911 Aston, Peter, of Tyryngton, executors of 0
5229987 2424385 2424385 plaintiff Aston Peter (legal representative) 594911 594911 Aston, Peter, of Tyryngton, executors of 0
5231091 2424690 2424690 defendant Halteman Elias husbandman 594911 594911 Halteman, Elias, of Tyryngton, husbandman 0
5582683 2529652 2529652 defendant Broun Adam husbandman 594911 594911 Broun, Adam, of Tyryngton, husbandman 1
5629990 2553381 2553381 defendant Burgh Richard butcher 594911 594911 Burgh, Richard, of Tyryngton, butcher 0
5631894 2553995 2553995 defendant Smyth Thomas butcher 594911 594911 Smyth, Thomas, of Tyryngton, butcher 1
5631895 2553995 2553995 defendant Boston John butcher 594911 594911 Boston, John, of Tyryngton, butcher 2

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