names

52 rows where place_id = 589906

✎ 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
3599183 1867381 1867381 defendant Byrche Christopher yeoman 589906 589906 Byrche, Christopher, of Bodyngton, yeoman 0
3599185 1867382 1867382 defendant Clebury John husbandman 589906 589906 Clebury, John, of Bodyngton, husbandman 0
3599187 1867383 1867383 defendant Hale John yeoman 589906 589906 Hale, John, of Bodyngton, yeoman 0
3599189 1867384 1867384 defendant Milton John husbandman 589906 589906 Milton, John, of Bodyngton, husbandman 0
3599191 1867385 1867385 defendant Milton Robert husbandman 589906 589906 Milton, Robert, of Bodyngton, husbandman 0
3599195 1867387 1867387 defendant Ideryche John miller 589906 589906 Ideryche, John, of Bodyngton, miller 0
3599197 1867388 1867388 defendant Kynnard John tailor 589906 589906 Kynnard, John, of Bodyngton, tailor 0
3599207 1867393 1867393 defendant Jacobe Walter husbandman 589906 589906 Jacobe, Walter, of Bodyngton, husbandman 0
3603820 1868866 1868866 defendant Smyth William husbandman 589906 589906 Smyth, William, of Bodyngton, husbandman 0
3672963 1917557 1917557 defendant Dadbrige William husbandman 589906 589906 Dadbrige, William, of Bodyngton, husbandman 0
3705567 1928023 1928023 defendant Glacyer William smith 589906 589906 Glacyer, William, of Bodyngton, smith 0
3715634 1931178 1931178 defendant Scherley Richard husbandman 589906 589906 Scherley, Richard, of Bodyngton, husbandman 1
3715635 1931178 1931178 defendant Odam Thomas husbandman 589906 589906 Odam, Thomas, of Bodyngton, husbandman 2
3715638 1931179 1931179 defendant Scherley Richard husbandman 589906 589906 Scherley, Richard, of Bodyngton, husbandman 1
3715639 1931179 1931179 defendant Odam Thomas husbandman 589906 589906 Odam, Thomas, of Bodyngton, husbandman 2
3718440 1932045 1932045 defendant Shurlok Richard husbandman 589906 589906 Shurlok, Richard, of Bodyngton, husbandman 0
3744346 1940133 1940133 defendant Reve Nicholas carpenter 589906 589906 Reve, Nicholas, of Bodyngton, carpenter 2
3745677 1940556 1940556 defendant Nicollys Alexander husbandman 589906 589906 Nicollys, Alexander, of Bodyngton, husbandman 1
3756619 1944052 1944052 defendant Morrys Nicholas yeoman 589906 589906 Morrys, Nicholas, of Bodyngton, yeoman 2
3784013 1952778 1952778 defendant Odam alias Waddam Thomas husbandman 589906 589906 Odam alias Waddam, Thomas, of Bodyngton, husbandman 0
4018525 2031357 2031357 defendant Dypper John yeoman 589906 589906 Dypper, John, of Bodyngton, yeoman 1
4018529 2031358 2031358 defendant Dypper John yeoman 589906 589906 Dypper, John, of Bodyngton, yeoman 1
4049874 2042386 2042386 defendant Barton John husbandman 589906 589906 Barton, John, of Bodyngton, husbandman 0
4057433 2045040 2045040 defendant Drynckwater William yeoman 589906 589906 Drynckwater, William, of Bodyngton, yeoman 0
4089582 2056563 2056563 defendant Denys Walter esq 589906 589906 Denys, Walter, of Bodyngton, esq 0
4177020 2087436 2087436 defendant Symons Robert husbandman 589906 589906 Symons, Robert, of Bodyngton, husbandman 0
4177021 2087436 2087436 defendant Mylton William husbandman 589906 589906 Mylton, William, of Bodyngton, husbandman 1
4216989 2101437 2101437 defendant Seaman alias Smythe William yeoman 589906 589906 Seaman alias Smythe, William, of Bodyngton, yeoman 0
4241625 2110184 2110184 defendant Tayler alias Semon William yeoman 589906 589906 Tayler alias Semon, William, of Bodyngton, yeoman 0
4469437 2191102 2191102 defendant Wattes John   589906 589906 Wattes, John, of Bodyngton 0
4476790 2193404 2193404 defendant Wattes John   589906 589906 Wattes, John, of Bodyngton 0
4559022 2218782 2218782 defendant Say Richard   589906 589906 Say, Richard, of Bodyngton 0
4692079 2263053 2263053 defendant Hurdleston William yeoman 589906 589906 Hurdleston, William, of Bodyngton, yeoman 0
4753642 2281510 2281510 defendant Edward Thomas husbandman 589906 589906 Edward, Thomas, of Bodyngton, husbandman 0
4753643 2281510 2281510 defendant Broune William husbandman 589906 589906 Broune, William, of Bodyngton, husbandman 1
4753644 2281510 2281510 defendant Halyday Mathew husbandman 589906 589906 Halyday, Mathew, of Bodyngton, husbandman 2
4848608 2311038 2311038 defendant Carter William husbandman 589906 589906 Carter, William, of Bodyngton, husbandman 0
4860884 2314760 2314760 defendant Carter Richard miller 589906 589906 Carter, Richard, of Bodyngton, miller 0
4890133 2323690 2323690 plaintiff Beauchamp John   589906 589906 Beauchamp, John, of Bodyngton, knight 0
5012652 2360539 2360539 defendant Edward Thomas husbandman 589906 589906 Edward, Thomas, of Bodyngton, husbandman 0
5095761 2385182 2385182 defendant Wheler Thomas hsbandman 589906 589906 Wheler, Thomas, of Bodyngton, hsbandman 4
5244034 2428444 2428444 defendant Beauchamp Richard esq 589906 589906 Beauchamp, Richard, of Bodyngton, esq 0
5259595 2433120 2433120 defendant Yelys John husbandman 589906 589906 Yelys, John, of Bodyngton, husbandman 1
5330177 2454101 2454101 defendant Beauchamp Thomas esq 589906 589906 Beauchamp, Thomas, of Bodyngton, esq 0
5336214 2455912 2455912 defendant Danyell Richard husbandman 589906 589906 Danyell, Richard, of Bodyngton, husbandman 2
5336221 2455913 2455913 defendant Danyell Richard husbandman 589906 589906 Danyell, Richard, of Bodyngton, husbandman 2
5365240 2464803 2464803 defendant Beauchamp Thomas esq 589906 589906 Beauchamp, Thomas, of Bodyngton, esq 0
5375758 2468011 2468011 defendant Knyght John smith 589906 589906 Knyght, John, of Bodyngton, smith 0
5411083 2478273 2478273 plaintiff Chessham John   589906 589906 Chessham, John, of Bodyngton 0
5519955 2511079 2511079 defendant Beaucham Richard   589906 589906 Beaucham, Richard, of Bodyngton, knight 0
5526785 2512947 2512947 defendant Beauchamp Richard   589906 589906 Beauchamp, Richard, of Bodyngton, knight 0
5609283 2537804 2537804 defendant Bayard John husbandman 589906 589906 Bayard, John, of Bodyngton, 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);