names

66 rows where place_id = 604645

✎ 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
3658743 1912987 1912987 defendant Eyre Edward yeoman 604645 604645 Eyre, Edward, of Tyddeswall, yeoman 0
3729822 1935582 1935582 defendant Oldfeld John laborer 604645 604645 Oldfeld, John, of Tyddeswall, laborer 5
3782797 1952368 1952368 plaintiff James Ralph   604645 604645 James, Ralph, of Tyddeswall 0
3782802 1952369 1952369 plaintiff James Ralph   604645 604645 James, Ralph, of Tyddeswall 0
3816338 1963019 1963019 defendant Pursglove Edmund yeoman 604645 604645 Pursglove, Edmund, of Tyddeswall, yeoman 0
3816339 1963019 1963019 defendant Pursglove John husbandman 604645 604645 Pursglove, John, of Tyddeswall, husbandman 1
3821703 1964677 1964677 defendant Pursglove John husbandman 604645 604645 Pursglove, John, of Tyddeswall, husbandman 0
3821704 1964677 1964677 defendant Pursglove Edmund yeoman 604645 604645 Pursglove, Edmund, of Tyddeswall, yeoman 1
3821705 1964677 1964677 defendant Pursglove Adam husbandman 604645 604645 Pursglove, Adam, of Tyddeswall, husbandman 2
3821706 1964677 1964677 defendant Pursglove William husbandman 604645 604645 Pursglove, William, of Tyddeswall, husbandman 3
3846567 1972483 1972483 defendant Cocke Robert husbandman 604645 604645 Cocke, Robert, of Tyddeswall, husbandman 0
3846568 1972483 1972483 defendant Johnson William husbandman 604645 604645 Johnson, William, of Tyddeswall, husbandman 1
4017787 2031073 2031073 defendant Barker Philip husbandman 604645 604645 Barker, Philip, of Tyddeswall, husbandman 0
4185272 2090357 2090357 defendant Syworthe James   604645 604645 Syworthe, James, of Tyddeswall, horse shower 1
4293386 2127698 2127698 defendant Bennett Robert blacksmith 604645 604645 Bennett, Robert, of Tyddeswall, blacksmith 2
4294284 2128032 2128032 defendant Allen William miner 604645 604645 Allen, William, of Tyddeswall, miner 1
4295625 2128520 2128520 defendant Creswell George husbandman 604645 604645 Creswell, George, of Tyddeswall, husbandman 1
4295626 2128520 2128520 defendant Bradshawe Simon   604645 604645 Bradshawe, Simon, of Tyddeswall 2
4296469 2128838 2128838 defendant Bridd Humphrey husbandman 604645 604645 Bridd, Humphrey, of Tyddeswall, husbandman 0
4300987 2130457 2130457 defendant Mylles Richard, senior husbandman 604645 604645 Mylles, Richard, senior, of Tyddeswall, husbandman 0
4300988 2130457 2130457 defendant Mylles Richard, junior husbandman 604645 604645 Mylles, Richard, junior, of Tyddeswall, husbandman 1
4311009 2133996 2133996 defendant Marshall Richard chapman 604645 604645 Marshall, Richard, of Tyddeswall, chapman 0
4360771 2151024 2151024 defendant Wood George yeoman 604645 604645 Wood, George, of Tyddeswall, or of Dame Dale, Forest of the Peake, yeoman 0
4385500 2159837 2159837 defendant Frythe Robert miner 604645 604645 Frythe, Robert, of Tyddeswall, miner 0
4399560 2164441 2164441 defendant Chapman Richard husbandman 604645 604645 Chapman, Richard, of Tyddeswall, husbandman 2
4515004 2205101 2205101 plaintiff Chaffare Hugh   604645 604645 Chaffare, Hugh, of Tyddeswall 0
4583338 2226209 2226209 defendant Broune William   604645 604645 Broune, William, of Tyddeswall 1
4591031 2228549 2228549 defendant Dughty Nicholas   604645 604645 Dughty, Nicholas, of Tyddeswall 0
4603543 2232294 2232294 defendant Steverdale or Stenerdale William   604645 604645 Steverdale or Stenerdale, William, of Tyddeswall 0
4748743 2280118 2280118 defendant Bagshawe Robert de yeoman 604645 604645 Bagshawe, Robert de, of Tyddeswall, yeoman 3
4776776 2288726 2288726 defendant Prestlyf John husbandman 604645 604645 Prestlyf, John, of Tyddeswall, husbandman 2
4776778 2288726 2288726 defendant Robynson Luke Harrisservant laborer 604645 604645 Robynson, Luke Harrisservant, of Tyddeswall, laborer 4
4776860 2288750 2288750 defendant Robynson Henry yeoman 604645 604645 Robynson, Henry, of Tyddeswall, yeoman 1
4881429 2321092 2321092 defendant Leche Thomas husbandman 604645 604645 Leche, Thomas, of Tyddeswall, husbandman 1
4954504 2343312 2343312 defendant Purgloves or Purglones Thomas laborer 604645 604645 Purgloves or Purglones, Thomas, of Tyddeswall, laborer 4
4987722 2353292 2353292 defendant Kynder Stephen husbandman 604645 604645 Kynder, Stephen, of Tyddeswall, husbandman 1
4987724 2353292 2353292 defendant Robynson Henry husbandman 604645 604645 Robynson, Henry, of Tyddeswall, husbandman 3
5001439 2357307 2357307 defendant Buxston John yeoman 604645 604645 Buxston, John, of Tyddeswall, yeoman 0
5001440 2357307 2357307 defendant Twycrosse Richard yeoman 604645 604645 Twycrosse, Richard, of Tyddeswall, yeoman 1
5011392 2360195 2360195 defendant Milner Mathew shoemaker 604645 604645 Milner, Mathew, of Tyddeswall, shoemaker 0
5011393 2360195 2360195 defendant Bekyngham Richard shoemaker 604645 604645 Bekyngham, Richard, of Tyddeswall, shoemaker 1
5014091 2360973 2360973 defendant Staly Roger laborer 604645 604645 Staly, Roger, of Tyddeswall, laborer 6
5014092 2360973 2360973 defendant Staley John yeoman 604645 604645 Staley, John, of Tyddeswall, yeoman 7
5014095 2360973 2360973 defendant Leche Richard husbandman 604645 604645 Leche, Richard, of Tyddeswall, husbandman 10
5014096 2360973 2360973 defendant Pursegloves Thomas butcher 604645 604645 Pursegloves, Thomas, of Tyddeswall, butcher 11
5075006 2379027 2379027 defendant Wylson James yeoman 604645 604645 Wylson, James, of Tyddeswall, yeoman 2
5284010 2440347 2440347 defendant Meverell Isabel widow 604645 604645 Meverell, Isabel, of Tyddeswall, widow 0
5284011 2440347 2440347 defendant Meverell Thomas esq 604645 604645 Meverell, Thomas, of Tyddeswall, esq 1
5284015 2440348 2440348 defendant Sherman Robert yeoman 604645 604645 Sherman, Robert, of Tyddeswall, yeoman 0
5302391 2445683 2445683 defendant Litton John mercer 604645 604645 Litton, John, of Tyddeswall, mercer 0
5317202 2450226 2450226 defendant Lytton John mercer 604645 604645 Lytton, John, of Tyddeswall, mercer 1
5317614 2450356 2450356 defendant Meverell Isabel widow 604645 604645 Meverell, Isabel, of Tyddeswall, widow 0
5317615 2450356 2450356 defendant Meverell Thomas esq 604645 604645 Meverell, Thomas, of Tyddeswall, esq 1
5317616 2450356 2450356 defendant Tunstede John gent 604645 604645 Tunstede, John, of Tyddeswall, gent 2
5329692 2453950 2453950 plaintiff Bagshawe Christopher, senior   604645 604645 Bagshawe, Christopher, senior, of Tyddeswall 0
5352650 2460921 2460921 defendant Meverell Thomas, senior esq 604645 604645 Meverell, Thomas, senior, of Tyddeswall, esq 0
5387370 2471458 2471458 defendant Aythe John husbandman 604645 604645 Aythe, John, of Tyddeswall, husbandman 6
5445695 2488601 2488601 defendant Barton Ralph husbandman 604645 604645 Barton, Ralph, of Tyddeswall, husbandman 0
5458448 2492420 2492420 defendant Barton Ralph husbandman 604645 604645 Barton, Ralph, of Tyddeswall, husbandman 0
5458455 2492421 2492421 defendant Barton Ralph husbandman 604645 604645 Barton, Ralph, of Tyddeswall, husbandman 0
5481498 2499396 2499396 defendant Barton Ralph husbandman 604645 604645 Barton, Ralph, of Tyddeswall, husbandman 0
5493706 2503028 2503028 defendant Chapman William husbandman 604645 604645 Chapman, William, of Tyddeswall, husbandman 4
5546802 2519070 2519070 defendant Folowe Robert yeoman 604645 604645 Folowe, Robert, of Tyddeswall, yeoman 0
5560889 2523158 2523158 defendant Bagshaw Robert yeoman 604645 604645 Bagshaw, Robert, of Tyddeswall, yeoman 2
5568437 2525316 2525316 defendant Bagshaa John yeoman 604645 604645 Bagshaa, John, of Tyddeswall, yeoman 2
5593998 2533113 2533113 defendant Wilson Richard husbandman 604645 604645 Wilson, Richard, of Tyddeswall, husbandman 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);