names

61 rows where place_id = 593479

✎ 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
3611992 1871408 1871408 defendant Slake Thomas husbandman 593479 593479 Slake, Thomas, of Castelton, husbandman 9
3611993 1871408 1871408 defendant Marshall Roger husbandman 593479 593479 Marshall, Roger, of Castelton, husbandman 10
3611996 1871408 1871408 defendant Marchall Humphrey husbandman 593479 593479 Marchall, Humphrey, of Castelton, husbandman 13
3612003 1871408 1871408 defendant Slykes John laborer 593479 593479 Slykes, John, of Castelton, laborer 20
3617048 1872954 1872954 defendant Jolk Elias laborer 593479 593479 Jolk, Elias, of Castelton, laborer 2
3907075 1992653 1992653 defendant Bradbury John husbandman 593479 593479 Bradbury, John, of Castelton, husbandman 0
3911533 1994174 1994174 defendant Wytney Robert gent 593479 593479 Wytney, Robert, of Castelton, gent 2
4032457 2036253 2036253 defendant Whytney Nicholas gent 593479 593479 Whytney, Nicholas, of Castelton, gent 15
4078943 2052768 2052768 plaintiff Tillard William clothier 593479 593479 Tillard, William, of Castelton, weaver, or of Showrbron , clothier 0
4080414 2053306 2053306 defendant Boothe Edmund husbandman 593479 593479 Boothe, Edmund, of Castelton, husbandman 0
4155973 2080164 2080164 defendant Whytney Nicholas gent 593479 593479 Whytney, Nicholas, of Castelton, gent 0
4296675 2128910 2128910 defendant Whitney Thomas gent 593479 593479 Whitney, Thomas, of Castelton, gent 1
4416937 2170170 2170170 defendant del Halle Felicia   593479 593479 del Halle, Felicia, of Castelton, formerly wife of Gervase 0
4462642 2189011 2189011 defendant Davy William   593479 593479 Davy, William, of Castelton 3
4542035 2213399 2213399 defendant Eynesworth John   593479 593479 Eynesworth, John, of Castelton 0
4583337 2226209 2226209 defendant Castelton John   593479 593479 Castelton, John, of Castelton 0
4650481 2246159 2246159 defendant Scondybed William   593479 593479 Scondybed, William, of Castelton 0
4651513 2246478 2246478 defendant Stranley or Strauley John   593479 593479 Stranley or Strauley, John, of Castelton, knight 0
4661769 2249520 2249520 defendant Dale John weaver 593479 593479 Dale, John, of Castelton, weaver 0
4661771 2249521 2249521 defendant Fauntleroy Richard   593479 593479 Fauntleroy, Richard, of Castelton 0
4684939 2260883 2260883 defendant Strauley John   593479 593479 Strauley, John, of Castelton, knight 0
4738702 2277194 2277194 defendant Jakson Thomas (legal representative) 593479 593479 Jakson, Thomas, of Castelton, executors of 0
4738704 2277194 2277194 defendant Smyth John husbandman 593479 593479 Smyth, John, of Castelton, husbandman 2
4773932 2287826 2287826 defendant Ekelys Richard yeoman 593479 593479 Ekelys, Richard, of Castelton, yeoman 1
4776116 2288526 2288526 defendant Fillowe Thomas yeoman 593479 593479 Fillowe, Thomas, of Castelton, yeoman 0
4776770 2288724 2288724 defendant Careles Thomas husbandman 593479 593479 Careles, Thomas, of Castelton, husbandman 0
4776798 2288731 2288731 defendant Strelley Hugh esq 593479 593479 Strelley, Hugh, of Castelton, esq 0
4776806 2288733 2288733 defendant Neweham Ralph yeoman 593479 593479 Neweham, Ralph, of Castelton, yeoman 1
4776874 2288754 2288754 defendant Page William yeoman 593479 593479 Page, William, of Castelton, yeoman 0
4776875 2288754 2288754 defendant Gardyner William yeoman 593479 593479 Gardyner, William, of Castelton, yeoman 1
4776885 2288758 2288758 defendant Neweham Ralph yeoman 593479 593479 Neweham, Ralph, of Castelton, yeoman 0
4776886 2288758 2288758 defendant Neweham Thomas yeoman 593479 593479 Neweham, Thomas, of Castelton, yeoman 1
4799331 2295966 2295966 defendant Tonnerowe Richard, junior husbandman 593479 593479 Tonnerowe, Richard, junior, of Castelton, husbandman 0
4820804 2302588 2302588 defendant Taillour Thomas husbandman 593479 593479 Taillour, Thomas, of Castelton, husbandman 2
4834171 2306697 2306697 defendant Fauntleroy Richard gent 593479 593479 Fauntleroy, Richard, of Castelton, gent 0
4853488 2312502 2312502 plaintiff Wolley Walter de   593479 593479 Wolley, Walter de, of Castelton 0
4861214 2314873 2314873 defendant Fauntleroy Richard gent 593479 593479 Fauntleroy, Richard, of Castelton, gent 0
4905354 2328266 2328266 plaintiff del Clogh Thomas   593479 593479 del Clogh, Thomas, of Castelton 0
4913456 2330707 2330707 plaintiff Clogby Thomas   593479 593479 Clogby, Thomas, of Castelton 0
4913458 2330707 2330707 defendant le Halle Martin yeoman 593479 593479 (le Halle, Martin, of Castelton, yeoman 1
4932639 2336602 2336602 defendant de Halle Martin husbandman 593479 593479 de Halle, Martin, of Castelton, husbandman 0
4932640 2336602 2336602 defendant Gardener William husbandman 593479 593479 Gardener, William, of Castelton, husbandman 1
4940448 2339037 2339037 plaintiff del Clogh Thomas   593479 593479 del Clogh, Thomas, of Castelton 0
4945444 2340555 2340555 defendant Shawe Robert husbandman 593479 593479 Shawe, Robert, of Castelton, husbandman 1
4956687 2343957 2343957 defendant Hall Martin yeoman 593479 593479 Hall, Martin, of Castelton, yeoman 1
5038727 2368229 2368229 defendant Midelton Alice widow 593479 593479 Midelton, Alice, of Castelton, widow 0
5038728 2368229 2368229 defendant Fourneys William yeoman 593479 593479 Fourneys, William, of Castelton, yeoman 1
5047423 2370850 2370850 defendant Neweton Richard husbandman 593479 593479 Neweton, Richard, of Castelton, husbandman 3
5061797 2375123 2375123 defendant Furnase William yeoman 593479 593479 Furnase, William, of Castelton, yeoman 1
5239916 2427252 2427252 defendant Fournes William miner 593479 593479 Fournes, William, of Castelton, miner 0
5239920 2427252 2427252 defendant Wyrall Joan widow 593479 593479 Wyrall, Joan, of Castelton, widow 4
5276255 2438123 2438123 defendant Page Martin yeoman 593479 593479 Page, Martin, of Castelton, yeoman 1
5327650 2453341 2453341 defendant Cokke Edward husbandman 593479 593479 Cokke, Edward, of Castelton, husbandman 21
5352321 2460825 2460825 defendant Hall Henry yeoman 593479 593479 Hall, Henry, of Castelton, yeoman 1
5352322 2460825 2460825 defendant Hall Thurston yeoman 593479 593479 Hall, Thurston, of Castelton, yeoman 2
5446672 2488897 2488897 defendant Bothe Henry husbandman 593479 593479 Bothe, Henry, of Castelton, husbandman 1
5458168 2492350 2492350 defendant Bothe Henry husbandman 593479 593479 Bothe, Henry, of Castelton, husbandman 1
5571263 2526155 2526155 defendant Barton Ellen widow 593479 593479 Barton, Ellen, of Castelton, widow 1
5576068 2527577 2527577 defendant Halle Henry laborer 593479 593479 Halle, Henry, of Castelton, laborer 8
5625450 2551904 2551904 defendant del Hall John husbandman 593479 593479 del Hall, John, of Castelton, husbandman 0
5627261 2552495 2552495 defendant Flynt Nicholas laborer 593479 593479 Flynt, Nicholas, of Castelton, laborer 1

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