names

48 rows where place_id = 604661

✎ 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
3658825 1913018 1913018 defendant Dekyn Thomas glover 604661 604661 Dekyn, Thomas, of Bosworth, glover 1
3658827 1913018 1913018 defendant Rychardson Robert mylner 604661 604661 Rychardson, Robert, of Bosworth, mylner 3
3735785 1937430 1937430 defendant Bulle John yeoman 604661 604661 Bulle, John, of Bosworth, yeoman 4
3785700 1953319 1953319 defendant Traslone Robert husbandman 604661 604661 Traslone, Robert, of Bosworth, husbandman 0
3789053 1954389 1954389 defendant Kempe William chaplain 604661 604661 Kempe, William, of Bosworth, chaplain 0
3789054 1954389 1954389 defendant Bull John yeoman 604661 604661 Bull, John, of Bosworth, yeoman 1
3789055 1954389 1954389 defendant Browne John yeoman 604661 604661 Browne, John, of Bosworth, yeoman 2
3789056 1954389 1954389 defendant Myllys John yeoman 604661 604661 Myllys, John, of Bosworth, yeoman 3
3805233 1959583 1959583 defendant Kempe William chaplain 604661 604661 Kempe, William, of Bosworth, chaplain 0
3805234 1959583 1959583 defendant Bull John yeoman 604661 604661 Bull, John, of Bosworth, yeoman 1
3805235 1959583 1959583 defendant Browne John yeoman 604661 604661 Browne, John, of Bosworth, yeoman 2
3805236 1959583 1959583 defendant Myllys John yeoman 604661 604661 Myllys, John, of Bosworth, yeoman 3
3822438 1964915 1964915 defendant Asshby William drover 604661 604661 Asshby, William, of Bosworth, drover 0
3840667 1970644 1970644 defendant Acton Robert yeoman 604661 604661 Acton, Robert, of Bosworth, yeoman 0
3951104 2007454 2007454 defendant Cotton Francis gent 604661 604661 Cotton, Francis, of Bosworth, gent 0
3986935 2020070 2020070 defendant Moreton Nicholas yeoman 604661 604661 Moreton, Nicholas, of Bosworth, yeoman 2
3996630 2023555 2023555 defendant Burton Thomas yeoman 604661 604661 Burton, Thomas, of Bosworth, yeoman 0
4001531 2025327 2025327 defendant Ashby George yeoman 604661 604661 Ashby, George, of Bosworth, yeoman 4
4001532 2025327 2025327 defendant Chapman William yeoman 604661 604661 Chapman, William, of Bosworth, yeoman 5
4022618 2032811 2032811 plaintiff Ashby George Leicester 604661 604661 Ashby, George, of Bosworth, Leicester 0
4042862 2039921 2039921 defendant Asheby George husbandman 604661 604661 Asheby, George, of Bosworth, husbandman 1
4419218 2170887 2170887 defendant Carleton Robert de   604661 604661 Carleton, Robert de, of Bosworth 0
4437170 2176367 2176367 defendant Cartewrighte Adam le   604661 604661 Cartewrighte, Adam le, of Bosworth 0
4580079 2225257 2225257 defendant Taillour Henry   604661 604661 Taillour, Henry, of Bosworth 0
4628833 2239947 2239947 defendant Cowene Richard   604661 604661 Cowene, Richard, of Bosworth 2
4815126 2300839 2300839 plaintiff Kymwolmerssh William clerk & parson 604661 604661 Kymwolmerssh, William, of Bosworth, clerk & parson 0
4956737 2343969 2343969 defendant Harecourt Richard esq 604661 604661 Harecourt, Richard, of Bosworth, esq 0
4965801 2346702 2346702 defendant Assheby John husbandman 604661 604661 Assheby, John, of Bosworth, husbandman 1
5200910 2416031 2416031 defendant Haywod Thomas   604661 604661 Haywod, Thomas, of Bosworth, parson of the parish church 0
5284454 2440467 2440467 defendant Freman John yeoman 604661 604661 Freman, John, of Bosworth, yeoman 2
5286431 2441032 2441032 defendant Herverd William chaplain 604661 604661 Herverd, William, of Bosworth, chaplain 0
5297935 2444406 2444406 defendant Dethek Bartholomew gent 604661 604661 Dethek, Bartholomew, of Bosworth, gent 1
5307518 2447261 2447261 defendant Dethek Bartholomew gent 604661 604661 Dethek, Bartholomew, of Bosworth, gent 1
5332679 2454842 2454842 plaintiff Colyns William   604661 604661 Colyns, William, of Bosworth 0
5371366 2466624 2466624 plaintiff Heywode Thomas   604661 604661 Heywode, Thomas, of Bosworth, parson 0
5401743 2475557 2475557 plaintiff Heywod Thomas   604661 604661 Heywod, Thomas, of Bosworth, rector 0
5429818 2483860 2483860 defendant Smyth William smith 604661 604661 Smyth, William, of Bosworth, smith 2
5430271 2483992 2483992 plaintiff (not given) Thomas rector of Haywod 604661 604661 Haywod, Thomas, of Bosworth, clerk & rector of the parish church 0
5430539 2484066 2484066 plaintiff Heywod Thomas clerk & rector 604661 604661 Heywod, Thomas, of Bosworth, clerk & rector 0
5430541 2484067 2484067 plaintiff Heywod Thomas clerk & rector 604661 604661 Heywod, Thomas, of Bosworth, clerk & rector 0
5430545 2484068 2484068 plaintiff Heywod Thomas clerk & rector 604661 604661 Heywod, Thomas, of Bosworth, master, clerk & rector 0
5446732 2488919 2488919 defendant Smyth William smith 604661 604661 Smyth, William, of Bosworth, smith 0
5447070 2489012 2489012 plaintiff Haywod Thomas clerk 604661 604661 Haywod, Thomas, of Bosworth, clerk 0
5459687 2492816 2492816 plaintiff Heywode Thomas master & rector 604661 604661 Heywode, Thomas, of Bosworth, clerk, master & rector 0
5498725 2504564 2504564 defendant Parkyns John husbandman 604661 604661 Parkyns, John, of Bosworth, husbandman 0
5498726 2504564 2504564 defendant Bolton John miller 604661 604661 Bolton, John, of Bosworth, miller 1
5498727 2504564 2504564 defendant Horton Thomas husbandman 604661 604661 Horton, Thomas, of Bosworth, husbandman 2
5498728 2504564 2504564 defendant Clement John husbandman 604661 604661 Clement, John, of Bosworth, 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);