names

58 rows where place_id = 592655

✎ 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
3589094 1864237 1864237 defendant Holle Robert   592655 592655 Holle, Robert, of Wodnorton, husbandman, son of Holle, William, of Wodnorton 0
3589095 1864237 1864237 defendant Holle Thomas   592655 592655 Holle, Thomas, of Wodnorton, yeoman, son of Holle, William, of Wodnorton 1
3608415 1870292 1870292 plaintiff Tayllour alias Dawys John husbandman 592655 592655 Tayllour alias Dawys, John, of Wodnorton, husbandman 0
3608416 1870292 1870292 defendant Wenche Richard thatcher 592655 592655 Wenche, Richard, of Wodnorton, thatcher 0
3608418 1870293 1870293 plaintiff Tayllour alias Dawys John husbandman 592655 592655 Tayllour alias Dawys, John, of Wodnorton, husbandman 0
3608419 1870293 1870293 defendant Wenche Richard thatcher 592655 592655 Wenche, Richard, of Wodnorton, thatcher 0
3631686 1904724 1904724 defendant Sheryngham William butcher 592655 592655 Sheryngham, William, of Wodnorton, butcher 0
3632758 1905059 1905059 defendant Gees Thomas husbandman 592655 592655 Gees, Thomas, of Wodnorton, husbandman 0
3637627 1906580 1906580 defendant Sheryngham John butcher 592655 592655 Sheryngham, John, of Wodnorton, butcher 0
3637628 1906580 1906580 defendant Roberdys John husbandman 592655 592655 Roberdys, John, of Wodnorton, husbandman 1
3647948 1909756 1909756 defendant Gees Thomas butcher 592655 592655 Gees, Thomas, of Wodnorton, butcher 0
3647949 1909756 1909756 defendant Clerk alias Taylor John tailor 592655 592655 Clerk alias Taylor, John, of Wodnorton, tailor 1
3651012 1910684 1910684 defendant Gese Thomas butcher 592655 592655 Gese, Thomas, of Wodnorton, butcher 0
3651013 1910684 1910684 defendant Here Thomas husbandman 592655 592655 Here, Thomas, of Wodnorton, husbandman 1
3651014 1910684 1910684 defendant Lambert William husbandman 592655 592655 Lambert, William, of Wodnorton, husbandman 2
3651015 1910684 1910684 defendant Skynner John husbandman 592655 592655 Skynner, John, of Wodnorton, husbandman 3
3658986 1913076 1913076 defendant Lambard William husbandman 592655 592655 Lambard, William, of Wodnorton, husbandman 0
3658987 1913076 1913076 defendant Geys William husbandman 592655 592655 Geys, William, of Wodnorton, husbandman 1
3712045 1930088 1930088 defendant Holley Andrew husbandman 592655 592655 Holley, Andrew, of Wodnorton, husbandman 0
3746972 1940971 1940971 defendant Holley Andrew husbandman 592655 592655 Holley, Andrew, of Wodnorton, husbandman 3
3748551 1941479 1941479 defendant Mason James chaplain 592655 592655 Mason, James, of Wodnorton, chaplain 3
3789162 1954421 1954421 defendant Sheryngham Edmund butcher 592655 592655 Sheryngham, Edmund, of Wodnorton, butcher 0
3852533 1974400 1974400 defendant Skynner John husbandman 592655 592655 Skynner, John, of Wodnorton, husbandman 1
3862143 1977523 1977523 defendant Holley Andrew, senior husbandman 592655 592655 Holley, Andrew, senior, of Wodnorton, husbandman 0
4151376 2078603 2078603 defendant Browne Edmund butcher 592655 592655 Browne, Edmund, of Wodnorton, butcher 3
4218214 2101874 2101874 defendant Andleser or Audleser Edward clerk 592655 592655 Andleser or Audleser, Edward, of Wodnorton, clerk 0
4924508 2334105 2334105 defendant Crane John esq 592655 592655 Crane, John, of Wodnorton, esq 0
5013284 2360720 2360720 defendant Souter Adam husbandman 592655 592655 Souter, Adam, of Wodnorton, husbandman 0
5043907 2369807 2369807 defendant Calle or Halle William yeoman 592655 592655 Calle or Halle, William, of Wodnorton, yeoman 0
5079080 2380231 2380231 defendant Halle William yeoman 592655 592655 Halle, William, of Wodnorton, yeoman 4
5105652 2388102 2388102 defendant Halle William laborer 592655 592655 Halle, William, of Wodnorton, laborer 6
5277921 2438631 2438631 defendant Martyn Thomas husbandman 592655 592655 Martyn, Thomas, of Wodnorton, husbandman 1
5281803 2439750 2439750 defendant Holley Robert yeoman 592655 592655 Holley, Robert, of Wodnorton, yeoman 0
5291671 2442571 2442571 defendant Holley Robert husbandman 592655 592655 Holley, Robert, of Wodnorton, husbandman 1
5306330 2446878 2446878 defendant Estweyth Ralph laborer 592655 592655 Estweyth, Ralph, of Wodnorton, laborer 0
5335288 2455622 2455622 defendant Holle Richard husbandman 592655 592655 Holle, Richard, of Wodnorton, husbandman 1
5351694 2460630 2460630 defendant Holle William husbandman 592655 592655 Holle, William, of Wodnorton, husbandman 1
5359278 2462938 2462938 defendant Holle William turner 592655 592655 Holle, William, of Wodnorton, turner 3
5359524 2463010 2463010 defendant Holley Robert husbandman 592655 592655 Holley, Robert, of Wodnorton, husbandman 0
5376684 2468302 2468302 defendant Martyn Thomas husbandman 592655 592655 Martyn, Thomas, of Wodnorton, husbandman 1
5381487 2469765 2469765 defendant Holle William yeoman 592655 592655 Holle, William, of Wodnorton, yeoman 4
5386848 2471303 2471303 defendant Hatter William yeoman 592655 592655 Hatter, William, of Wodnorton, yeoman 6
5414657 2479319 2479319 defendant Holle William yeoman 592655 592655 Holle, William, of Wodnorton, yeoman 0
5417400 2480124 2480124 defendant Holl William turner 592655 592655 Holl, William, of Wodnorton, turner 1
5434755 2485333 2485333 defendant Holt William turner 592655 592655 Holt, William, of Wodnorton, turner 1
5473381 2497000 2497000 defendant Mason John yeoman 592655 592655 Mason, John, of Wodnorton, yeoman 1
5485152 2500479 2500479 defendant Holl William clerk 592655 592655 Holl, William, of Wodnorton, clerk 1
5491240 2502269 2502269 defendant Holley Robert yeoman 592655 592655 Holley, Robert, of Wodnorton, yeoman 4
5512756 2508846 2508846 defendant Holle Thomas baker 592655 592655 Holle, Thomas, of Wodnorton, baker 0
5531043 2514224 2514224 defendant Wilkynson Richard husbandman 592655 592655 Wilkynson, Richard, of Wodnorton, husbandman 1
5531044 2514224 2514224 defendant Lowth Thomas husbandman 592655 592655 Lowth, Thomas, of Wodnorton, husbandman 2
5583320 2529855 2529855 defendant Lambard William husbandman 592655 592655 Lambard, William, of Wodnorton, husbandman 0
5583321 2529855 2529855 defendant Wygett Richard husbandman 592655 592655 Wygett, Richard, of Wodnorton, husbandman 1
5583322 2529855 2529855 defendant Goos Thomas butcher 592655 592655 Goos, Thomas, of Wodnorton, butcher 2
5599424 2534705 2534705 defendant Skynner John husbandman 592655 592655 Skynner, John, of Wodnorton, husbandman 1
5602308 2535616 2535616 defendant Gees Thomas husbandman 592655 592655 Gees, Thomas, of Wodnorton, husbandman 0
5602310 2535616 2535616 defendant Lambard William husbandman 592655 592655 Lambard, William, of Wodnorton, husbandman 2
5602311 2535616 2535616 defendant Marrowe Robert husbandman 592655 592655 Marrowe, Robert, of Wodnorton, 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);