names

98 rows where place_id = 593527

✎ 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
3612254 1871468 1871468 defendant Emmys William husbandman 593527 593527 Emmys, William, of Saxlyngham, husbandman 0
3612255 1871468 1871468 defendant Hallys John laborer 593527 593527 Hallys, John, of Saxlyngham, laborer 1
3633429 1905268 1905268 defendant Estawe William pardoner 593527 593527 Estawe, William, of Saxlyngham, pardoner 6
3645506 1908995 1908995 defendant Estowe William yeoman 593527 593527 Estowe, William, of Saxlyngham, yeoman 2
3653031 1911277 1911277 defendant Leman Bartholomew husbandman 593527 593527 Leman, Bartholomew, of Saxlyngham, husbandman 1
3701471 1926707 1926707 defendant Say John yeoman 593527 593527 Say, John, of Saxlyngham, yeoman 1
3701901 1926846 1926846 defendant Parrott John yeoman 593527 593527 Parrott, John, of Saxlyngham, yeoman 7
3703426 1927346 1927346 defendant Graunte Richard husbandman 593527 593527 Graunte, Richard, of Saxlyngham, husbandman 2
3707609 1928678 1928678 defendant Say John yeoman 593527 593527 Say, John, of Saxlyngham, yeoman 0
3730512 1935777 1935777 defendant Sey John yeoman 593527 593527 Sey, John, of Saxlyngham, yeoman 1
3734888 1937151 1937151 defendant Wyllys Thomas husbandman 593527 593527 Wyllys, Thomas, of Saxlyngham, husbandman 2
3738713 1938315 1938315 defendant Broun William yeoman 593527 593527 Broun, William, of Saxlyngham, yeoman 0
3738714 1938315 1938315 defendant Broun Richard husbandman 593527 593527 Broun, Richard, of Saxlyngham, husbandman 1
3738715 1938315 1938315 defendant Gyslyngham John sherman 593527 593527 Gyslyngham, John, of Saxlyngham, sherman 2
3767536 1947484 1947484 defendant Harman George gent 593527 593527 Harman, George, of Saxlyngham, gent 0
3776196 1950300 1950300 defendant Wyllys John husbandman 593527 593527 Wyllys, John, of Saxlyngham, husbandman 3
3783297 1952527 1952527 defendant Say John husbandman 593527 593527 Say, John, of Saxlyngham, husbandman 2
3786570 1953593 1953593 defendant Harman George gent 593527 593527 Harman, George, of Saxlyngham, gent 0
3787777 1953966 1953966 defendant Kempe William husbandman 593527 593527 Kempe, William, of Saxlyngham, husbandman 5
3789930 1954676 1954676 defendant Sendall John (legal representative) 593527 593527 Sendall, John, of Saxlyngham, husbandman, executors of 2
3827451 1966453 1966453 defendant Saye John husbandman 593527 593527 Saye, John, of Saxlyngham, husbandman 0
3827452 1966453 1966453 defendant Saye Roger husbandman 593527 593527 Saye, Roger, of Saxlyngham, husbandman 1
3854595 1975080 1975080 defendant Totell William clerk 593527 593527 Totell, William, of Saxlyngham, clerk 0
3882074 1984264 1984264 defendant Sey John husbandman 593527 593527 Sey, John, of Saxlyngham, husbandman 2
3905317 1992046 1992046 defendant Bramson William laborer 593527 593527 Bramson, William, of Saxlyngham, laborer 0
3905318 1992046 1992046 defendant Wellys Thomas laborer 593527 593527 Wellys, Thomas, of Saxlyngham, laborer 1
3910104 1993687 1993687 defendant Heythe William husbandman 593527 593527 Heythe, William, of Saxlyngham, husbandman 2
3943229 2004755 2004755 defendant Roper Robert husbandman 593527 593527 Roper, Robert, of Saxlyngham, husbandman 0
3962900 2011618 2011618 defendant Mordaunt Philip esq 593527 593527 Mordaunt, Philip, of Saxlyngham, esq 0
3969880 2014065 2014065 defendant Tuttell Thomas husbandman 593527 593527 Tuttell, Thomas, of Saxlyngham, husbandman 2
3971689 2014659 2014659 defendant Tuttell Thomas yeoman 593527 593527 Tuttell, Thomas, of Saxlyngham, yeoman 2
3991339 2021656 2021656 defendant Bett or Bettes John husbandman 593527 593527 Bett or Bettes, John, of Saxlyngham, husbandman 0
3991340 2021657 2021657 plaintiff Brampston Francis husbandman 593527 593527 Brampston, Francis, of Saxlyngham, or of Great Yarmouth, husbandman 0
3991341 2021657 2021657 defendant Bett or Bettes John husbandman 593527 593527 Bett or Bettes, John, of Saxlyngham, husbandman 0
3991342 2021657 2021657 defendant Grype John husbandman 593527 593527 Grype, John, of Saxlyngham, husbandman 1
3995280 2023051 2023051 defendant Tuttell alias Thaxster John carpenter 593527 593527 Tuttell alias Thaxster, John, of Saxlyngham, carpenter 0
4014654 2029963 2029963 plaintiff Shaxton William yeoman 593527 593527 Shaxton, William, of Saxlyngham, yeoman 0
4059149 2045672 2045672 defendant Fenne William husbandman 593527 593527 Fenne, William, of Saxlyngham, husbandman 3
4440247 2181862 2181862 defendant Dunt Roger   593527 593527 Dunt, Roger, of Saxlyngham 2
4570530 2222356 2222356 defendant Barkere Peter   593527 593527 Barkere, Peter, of Saxlyngham 2
4574897 2223675 2223675 defendant Giles John   593527 593527 Giles, John, of Saxlyngham 0
4614202 2235453 2235453 defendant Silvestre Nicholas   593527 593527 Silvestre, Nicholas, of Saxlyngham 1
4615158 2235748 2235748 defendant Southfeld John tanner 593527 593527 Southfeld, John, of Saxlyngham, tanner 0
4618318 2236739 2236739 plaintiff Warmele John   593527 593527 Warmele, John, of Saxlyngham 1
4618320 2236739 2236739 defendant Southfeld John tanner 593527 593527 Southfeld, John, of Saxlyngham, tanner 1
4618321 2236739 2236739 defendant Brysley John   593527 593527 Brysley, John, of Saxlyngham 2
4632456 2241041 2241041 defendant Robbes John   593527 593527 Robbes, John, of Saxlyngham 1
4632459 2241041 2241041 defendant Sendall Thomas   593527 593527 Sendall, Thomas, of Saxlyngham 4
4642312 2243870 2243870 plaintiff Warmale John   593527 593527 Warmale, John, of Saxlyngham 1
4642315 2243871 2243871 plaintiff Warmale John   593527 593527 Warmale, John, of Saxlyngham 1
4642318 2243872 2243872 plaintiff Warmale John   593527 593527 Warmale, John, of Saxlyngham 1
4645293 2244690 2244690 defendant Parmonter Thomas   593527 593527 Parmonter, Thomas, of Saxlyngham 0
4645612 2244787 2244787 defendant Parmonter Thomas   593527 593527 Parmonter, Thomas, of Saxlyngham 0
4649890 2245985 2245985 plaintiff Warmale John   593527 593527 Warmale, John, of Saxlyngham 0
4658601 2248567 2248567 defendant Hilles William clerk 593527 593527 Hilles, William, of Saxlyngham, clerk 0
4661632 2249474 2249474 defendant Miles Thomas yeoman 593527 593527 Miles, Thomas, of Saxlyngham, yeoman 3
4690483 2262583 2262583 defendant Robbys John husbandman 593527 593527 with Robbys, John, of Saxlyngham, husbandman 3
4724903 2273081 2273081 defendant Milys Thomas   593527 593527 Milys, Thomas, of Saxlyngham, bailiff 1
4737806 2276930 2276930 plaintiff Warmale John   593527 593527 Warmale, John, of Saxlyngham 0
4737811 2276930 2276930 defendant Bertilmewe Henry   593527 593527 Bertilmewe, Henry, of Saxlyngham, horse dealer 3
4737839 2276938 2276938 defendant Say William yeoman 593527 593527 Say, William, of Saxlyngham, yeoman 0
4737840 2276938 2276938 defendant Myles Thomas yeoman 593527 593527 Myles, Thomas, of Saxlyngham, yeoman 1
4744862 2279015 2279015 defendant Milys Thomas   593527 593527 Milys, Thomas, of Saxlyngham, bailiff 1
4800572 2296360 2296360 defendant Hare john clerk 593527 593527 together with Hare, john, of Saxlyngham, clerk 1
4867054 2316659 2316659 defendant Hallys Robert husbandman 593527 593527 Hallys, Robert, of Saxlyngham, husbandman 3
4881517 2321122 2321122 defendant Hilles William clerk 593527 593527 Hilles, William, of Saxlyngham, clerk 0
4881903 2321238 2321238 defendant Wolmer Nicholas butcher 593527 593527 Wolmer, Nicholas, of Saxlyngham, butcher 2
4957262 2344136 2344136 defendant Wyllys William husbandman 593527 593527 Wyllys, William, of Saxlyngham, husbandman 0
5008640 2359423 2359423 defendant Wylles Thomas butcher 593527 593527 Wylles, Thomas, of Saxlyngham, butcher 4
5018153 2362198 2362198 defendant Large Ralph husbandman 593527 593527 Large, Ralph, of Saxlyngham, husbandman 2
5102426 2387112 2387112 plaintiff Bertram John esq 593527 593527 Bertram, John, of Saxlyngham, esq 0
5102428 2387113 2387113 plaintiff Bertram John esq 593527 593527 Bertram, John, of Saxlyngham, esq 0
5119438 2392112 2392112 defendant Large John husbandman 593527 593527 Large, John, of Saxlyngham, husbandman 0
5140957 2398474 2398474 defendant Totyll Richard husbandman 593527 593527 Totyll, Richard, of Saxlyngham, husbandman 0
5162080 2404642 2404642 defendant Totyll Richard husbandman 593527 593527 Totyll, Richard, of Saxlyngham, husbandman 0
5172773 2407767 2407767 defendant Bartram John   593527 593527 Bartram, John, of Saxlyngham 0
5198298 2415250 2415250 defendant Totyll Richard husbandman 593527 593527 Totyll, Richard, of Saxlyngham, husbandman 0
5243904 2428408 2428408 defendant Golet John husbandman 593527 593527 Golet, John, of Saxlyngham, husbandman 3
5268481 2435901 2435901 plaintiff Bertram Thomas gent 593527 593527 Bertram, Thomas, of Saxlyngham, gent 0
5278635 2438860 2438860 defendant Speller John husbandman 593527 593527 Speller, John, of Saxlyngham, husbandman 16
5284827 2440580 2440580 defendant Spynke John husbandman 593527 593527 Spynke, John, of Saxlyngham, husbandman 3
5284828 2440580 2440580 defendant Myles John husbandman 593527 593527 Myles, John, of Saxlyngham, husbandman 4
5285364 2440739 2440739 defendant Saye William yeoman 593527 593527 Saye, William, of Saxlyngham, yeoman 3
5490207 2501955 2501955 plaintiff Leman Robert   593527 593527 Leman, Robert, of Saxlyngham 2
5499167 2504700 2504700 plaintiff Perott Henry husbandman 593527 593527 Perott, Henry, of Saxlyngham, husbandman 0
5505143 2506517 2506517 plaintiff Leman Thomas   593527 593527 Leman, Thomas, of Saxlyngham 2
5513837 2509182 2509182 defendant Ade John husbandman 593527 593527 Ade, John, of Saxlyngham, husbandman 3
5532084 2514577 2514577 defendant Goldsmyth John husbandman 593527 593527 Goldsmyth, John, of Saxlyngham, husbandman 1
5559062 2522610 2522610 defendant Crane Nicholas husbandman 593527 593527 Crane, Nicholas, of Saxlyngham, husbandman 2
5573459 2526795 2526795 defendant Parson William chaplain 593527 593527 Parson, William, of Saxlyngham, chaplain 1
5582113 2529475 2529475 defendant Heylowe Thomas miller 593527 593527 Heylowe, Thomas, of Saxlyngham, miller 2
5583477 2529903 2529903 defendant Gunnes William husbandman 593527 593527 Gunnes, William, of Saxlyngham, husbandman 0
5583478 2529903 2529903 defendant Esthowe William husbandman 593527 593527 Esthowe, William, of Saxlyngham, husbandman 1
5590206 2531909 2531909 defendant Wyllys Thomas husbandman 593527 593527 Wyllys, Thomas, of Saxlyngham, husbandman 1
5594070 2533124 2533124 defendant Wyllys Thomas husbandman 593527 593527 Wyllys, Thomas, of Saxlyngham, husbandman 3
5629973 2553375 2553375 defendant Brysle John mercer 593527 593527 Brysle, John, of Saxlyngham, mercer 1
5635039 2554945 2554945 plaintiff Warmale John   593527 593527 Warmale, John, of Saxlyngham 0
5635513 2555072 2555072 plaintiff Wermale John   593527 593527 Wermale, John, of Saxlyngham 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);