names

95 rows where place_id = 607563

✎ 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
3669835 1916510 1916510 defendant Torrey Thomas butcher 607563 607563 Torrey, Thomas, of Staple, butcher 1
3669836 1916510 1916510 defendant Horssey John husbandman 607563 607563 Horssey, John, of Staple, husbandman 2
3695993 1924986 1924986 defendant Quylter William yeoman 607563 607563 Quylter, William, of Staple, yeoman 0
3711377 1929862 1929862 defendant A Bere William husbandman 607563 607563 A Bere, William, of Staple, husbandman 2
3716804 1931545 1931545 defendant Bulford William husbandman 607563 607563 Bulford, William, of Staple, husbandman 1
3716805 1931545 1931545 defendant Bulford Thomas   607563 607563 Bulford, Thomas, of Staple, groom 2
3716806 1931545 1931545 defendant Fosse John husbandman 607563 607563 Fosse, John, of Staple, husbandman 3
3732458 1936385 1936385 defendant Bulford William husbandman 607563 607563 Bulford, William, of Staple, husbandman 1
3732459 1936385 1936385 defendant Bulford Thomas   607563 607563 Bulford, Thomas, of Staple, groom 2
3738647 1938297 1938297 defendant Torrey Thomas butcher 607563 607563 Torrey, Thomas, of Staple, butcher 0
3738648 1938297 1938297 defendant Chawnte Thomas husbandman 607563 607563 Chawnte, Thomas, of Staple, husbandman 1
3798521 1957439 1957439 defendant Quylter William gent 607563 607563 Quylter, William, of Staple, gent 0
3804680 1959404 1959404 defendant May Alexander husbandman 607563 607563 May, Alexander, of Staple, husbandman 0
3847236 1972697 1972697 defendant Moland Nicholas yeoman 607563 607563 Moland, Nicholas, of Staple, yeoman 1
3874038 1981539 1981539 defendant Brugges John wayneman 607563 607563 Brugges, John, of Staple, wayneman 2
4047778 2041653 2041653 defendant Bennett Robert smith 607563 607563 Bennett, Robert, of Staple, smith 0
4065546 2047968 2047968 defendant Point Thomas yeoman 607563 607563 Point, Thomas, of Staple, yeoman 0
4065548 2047969 2047969 defendant Pount Thomas gent 607563 607563 Pount, Thomas, of Staple, gent 0
4065549 2047969 2047969 defendant Gatchell John husbandman 607563 607563 together with Gatchell, John, of Staple, husbandman 1
4211435 2099553 2099553 defendant Bullor Edmund gent 607563 607563 Bullor, Edmund, of Staple, gent 0
4227808 2105208 2105208 defendant Yard Thomas gent 607563 607563 Yard, Thomas, of Staple, gent 1
4227809 2105208 2105208 defendant Goddard Thomas yeoman 607563 607563 Goddard, Thomas, of Staple, yeoman 2
4253090 2114029 2114029 defendant Moate Stephen yeoman 607563 607563 Moate, Stephen, of Staple, yeoman 0
4285023 2124693 2124693 defendant Yearde Thomas gent 607563 607563 Yearde, Thomas, of Staple, gent 0
4285024 2124693 2124693 defendant Goddard Thomas gent 607563 607563 Goddard, Thomas, of Staple, gent 1
4285821 2124981 2124981 defendant Hare Richard weaver 607563 607563 Hare, Richard, of Staple, weaver 0
4289664 2126367 2126367 defendant Cleston or Clefton William gent 607563 607563 Cleston or Clefton, William, of Staple, gent 3
4303171 2131233 2131233 defendant Bullor Edmund gent 607563 607563 Bullor, Edmund, of Staple, gent 1
4332042 2141014 2141014 defendant Willes James husbandman 607563 607563 Willes, James, of Staple, husbandman 0
4336677 2142556 2142556 defendant Crane Thomas yeoman 607563 607563 Crane, Thomas, of Staple, yeoman 0
4341366 2144257 2144257 defendant Crane Thomas yeoman 607563 607563 Crane, Thomas, of Staple, yeoman 0
4341368 2144258 2144258 defendant Hendley Tristram clerk 607563 607563 Hendley, Tristram, of Staple, clerk 0
4360821 2151037 2151037 defendant Hare Nicholas butcher 607563 607563 Hare, Nicholas, of Staple, butcher 0
4360822 2151037 2151037 defendant Nosse John butcher 607563 607563 Nosse, John, of Staple, butcher 1
4362716 2151722 2151722 defendant Crane Thomas yeoman 607563 607563 Crane, Thomas, of Staple, yeoman 0
4363561 2152040 2152040 defendant Yarde Thomas gent 607563 607563 Yarde, Thomas, of Staple, gent 0
4364141 2152230 2152230 defendant Bullor Edmund gent 607563 607563 Bullor, Edmund, of Staple, gent 0
4364152 2152234 2152234 defendant Poyntes Thomas gent 607563 607563 Poyntes, Thomas, of Staple, gent 0
4364153 2152234 2152234 defendant Steete George gent 607563 607563 Steete, George, of Staple, gent 1
4366349 2153004 2153004 defendant Buller Edmund yeoman 607563 607563 Buller, Edmund, of Staple, yeoman 3
4379639 2157811 2157811 defendant Crane Thomas yeoman 607563 607563 Crane, Thomas, of Staple, yeoman 3
4385619 2159873 2159873 defendant Poyntz John gent 607563 607563 Poyntz, John, of Staple, gent 1
4490778 2197815 2197815 defendant Moul John   607563 607563 Moul, John, of Staple 0
4490876 2197845 2197845 defendant Dene Robert de   607563 607563 Dene, Robert de, of Staple 0
4509822 2203558 2203558 plaintiff Bagenham Alexander   607563 607563 Bagenham, Alexander, of Staple, parson 0
4509824 2203559 2203559 plaintiff Bagenham Alexander   607563 607563 Bagenham, Alexander, of Staple, parson 0
4509826 2203560 2203560 plaintiff Bagenham Alexander   607563 607563 Bagenham, Alexander, of Staple, parson 0
4570121 2222228 2222228 defendant Rogers William   607563 607563 Rogers, William, of Staple 1
4699457 2265289 2265289 defendant Roger William husbandman 607563 607563 Roger, William, of Staple, husbandman 0
4703595 2266503 2266503 defendant Yerde Robert husbandman 607563 607563 Yerde, Robert, of Staple, husbandman 0
4703596 2266503 2266503 defendant Hanyes Richard laborer 607563 607563 Hanyes, Richard, of Staple, laborer 1
4736556 2276565 2276565 defendant Keche Walter husbandman 607563 607563 Keche, Walter, of Staple, husbandman 1
4849707 2311384 2311384 defendant Benet Thomas clerk 607563 607563 Benet, Thomas, of Staple, clerk 2
4852280 2312138 2312138 defendant Marys Nicholas husbandman 607563 607563 Marys, Nicholas, of Staple, husbandman 0
4880194 2320717 2320717 defendant Marys Nicholas husbandman 607563 607563 Marys, Nicholas, of Staple, husbandman 0
4963500 2345996 2345996 defendant Colyn Thomas husbandman 607563 607563 Colyn, Thomas, of Staple, husbandman 0
4963501 2345996 2345996 defendant Colyn Stephen laborer 607563 607563 Colyn, Stephen, of Staple, laborer 1
4963502 2345996 2345996 defendant Cilyn Nicholas laborer 607563 607563 Cilyn, Nicholas, of Staple, laborer 2
4963503 2345996 2345996 defendant Knyght Giles laborer 607563 607563 Knyght, Giles, of Staple, laborer 3
4963504 2345996 2345996 defendant Knyght William laborer 607563 607563 Knyght, William, of Staple, laborer 4
4963505 2345996 2345996 defendant Smyth John laborer 607563 607563 Smyth, John, of Staple, laborer 5
4990139 2353960 2353960 defendant Colyn Thomas husbandman 607563 607563 Colyn, Thomas, of Staple, husbandman 0
4990140 2353960 2353960 defendant Colyn Stephen laborer 607563 607563 Colyn, Stephen, of Staple, laborer 1
4990142 2353960 2353960 defendant Colyn Nicholas laborer 607563 607563 Colyn, Nicholas, of Staple, laborer 3
4990144 2353960 2353960 defendant Knight Giles laborer 607563 607563 Knight, Giles, of Staple, laborer 5
4990145 2353960 2353960 defendant Knyght William laborer 607563 607563 Knyght, William, of Staple, laborer 6
4990146 2353960 2353960 defendant smyth John laborer 607563 607563 smyth, John, of Staple, laborer 7
5015107 2361302 2361302 defendant A Downe Simon husbandman 607563 607563 A Downe, Simon, of Staple, husbandman 0
5016994 2361865 2361865 defendant Colyn Thomas husbandman 607563 607563 Colyn, Thomas, of Staple, husbandman 0
5016995 2361865 2361865 defendant Colyn Stephen laborer 607563 607563 Colyn, Stephen, of Staple, laborer 1
5016996 2361865 2361865 defendant Colyn Nicholas laborer 607563 607563 Colyn, Nicholas, of Staple, laborer 2
5016997 2361865 2361865 defendant Knyght Giles laborer 607563 607563 Knyght, Giles, of Staple, laborer 3
5016998 2361865 2361865 defendant Knyght William laborer 607563 607563 Knyght, William, of Staple, laborer 4
5016999 2361865 2361865 defendant Smyth John laborer 607563 607563 Smyth, John, of Staple, laborer 5
5088130 2382905 2382905 defendant Wymarke John husbandman 607563 607563 Wymarke, John, of Staple, husbandman 1
5088133 2382906 2382906 defendant Wymarke John husbandman 607563 607563 Wymarke, John, of Staple, husbandman 1
5170506 2407099 2407099 defendant Dele John husbandman 607563 607563 Dele, John, of Staple, husbandman 1
5183752 2410982 2410982 defendant Bulford John husbandman 607563 607563 Bulford, John, of Staple, husbandman 0
5188262 2412278 2412278 defendant Dele John husbandman 607563 607563 Dele, John, of Staple, husbandman 1
5205966 2417478 2417478 defendant Dele John husbandman 607563 607563 Dele, John, of Staple, husbandman 1
5237349 2426507 2426507 defendant Dade William sawyer 607563 607563 Dade, William, of Staple, sawyer 1
5237350 2426507 2426507 defendant Smyth John husbandman 607563 607563 Smyth, John, of Staple, husbandman 2
5267062 2435457 2435457 defendant Berton James husbandman 607563 607563 Berton, James, of Staple, husbandman 0
5296293 2443905 2443905 defendant Dade William husbandman 607563 607563 Dade, William, of Staple, husbandman 0
5308243 2447498 2447498 defendant Founteyn John husbandman 607563 607563 Founteyn, John, of Staple, husbandman 3
5364869 2464680 2464680 defendant Cok Thomas husbandman 607563 607563 Cok, Thomas, of Staple, husbandman 0
5366023 2465031 2465031 defendant Sayer Walter husbandman 607563 607563 Sayer, Walter, of Staple, husbandman 0
5439678 2486807 2486807 defendant Godfrey John laborer 607563 607563 Godfrey, John, of Staple, laborer 3
5465288 2494523 2494523 defendant Godfrey John laborer 607563 607563 Godfrey, John, of Staple, laborer 3
5517907 2510444 2510444 defendant Mote John husbandman 607563 607563 Mote, John, of Staple, husbandman 0
5517908 2510444 2510444 defendant Mote Nicholas yeoman 607563 607563 Mote, Nicholas, of Staple, yeoman 1
5541980 2517616 2517616 defendant Moleyns John, senior husbandman 607563 607563 Moleyns, John, senior, of Staple, or of Crolond, husbandman 0
5587331 2531066 2531066 defendant Bysshop Thomas yeoman 607563 607563 Bysshop, Thomas, of Staple, yeoman 0
5604855 2536387 2536387 defendant Lotte John husbandman 607563 607563 Lotte, John, of Staple, husbandman 0
5632762 2554260 2554260 defendant Neym Thomas husbandman 607563 607563 Neym, Thomas, of Staple, husbandman 3

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