names

38 rows where place_id = 597300

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: case_id, surname, forename, occupation, seq

id ▼ case_id role surname forename occupation place_id raw_segment seq
3628012 1903615 1903615 defendant Barley John husbandman 597300 597300 Barley, John, of Warmesworth, husbandman 3
3628018 1903616 1903616 defendant Barley John husbandman 597300 597300 Barley, John, of Warmesworth, husbandman 3
4026628 2034171 2034171 defendant Armytage William husbandman 597300 597300 Armytage, William, of Warmesworth, husbandman 0
4026629 2034171 2034171 defendant Armytage George husbandman 597300 597300 Armytage, George, of Warmesworth, husbandman 1
4026630 2034171 2034171 defendant Boswell Thomas laborer 597300 597300 Boswell, Thomas, of Warmesworth, laborer 2
4026631 2034171 2034171 defendant Aldam William husbandman 597300 597300 Aldam, William, of Warmesworth, husbandman 3
4034855 2037142 2037142 defendant Boswell Thomas gent 597300 597300 Boswell, Thomas, of Warmesworth, gent 0
4114387 2065428 2065428 defendant Armytage William husbandman 597300 597300 Armytage, William, of Warmesworth, husbandman 1
4114394 2065431 2065431 defendant Armytage William husbandman 597300 597300 Armytage, William, of Warmesworth, husbandman 1
4664576 2250401 2250401 defendant Elisson Thomas husbandman 597300 597300 Elisson, Thomas, of Warmesworth, husbandman 0
4748883 2280164 2280164 defendant Denyll or Devyll Thomas   597300 597300 Denyll or Devyll, Thomas, of Warmesworth, gent, son of Gosselmus or Jocelyn Denyll or Devyll 0
4754500 2281788 2281788 defendant Cudworth William husbandman 597300 597300 Cudworth, William, of Warmesworth by Doncaster, husbandman 0
4914868 2331162 2331162 defendant Bawetre William, senior   597300 597300 Bawetre, William, senior, of Warmesworth, wright 0
4914869 2331162 2331162 defendant Bawetre William, junior   597300 597300 Bawetre, William, junior, of Warmesworth, cart wright 1
4914870 2331162 2331162 defendant Appley Alice widow 597300 597300 Appley, Alice, of Warmesworth, widow 2
4914871 2331162 2331162 defendant Lacy Cecilia widow 597300 597300 Lacy, Cecilia, of Warmesworth, widow 3
4914872 2331162 2331162 defendant Bawetre John husbandman 597300 597300 Bawetre, John, of Warmesworth, husbandman 4
4914873 2331162 2331162 defendant Atkynson Richard laborer 597300 597300 Atkynson, Richard, of Warmesworth, laborer 5
4965986 2346754 2346754 defendant Bantre or Bautre William, junior husbandman 597300 597300 Bantre or Bautre, William, junior, of Warmesworth, husbandman 3
5014221 2361010 2361010 defendant Bawetre William husbandman 597300 597300 Bawetre, William, of Warmesworth, husbandman 0
5019027 2362456 2362456 defendant Bantre or Bautre William husbandman 597300 597300 Bantre or Bautre, William, of Warmesworth, husbandman 0
5019028 2362456 2362456 defendant Bantre or Bautre John husbandman 597300 597300 Bantre or Bautre, John, of Warmesworth, husbandman 1
5100665 2386620 2386620 defendant Daynell or Dayvell Isabel widow 597300 597300 Daynell or Dayvell, Isabel, of Warmesworth, widow 0
5141654 2398669 2398669 defendant Bawetro John   597300 597300 Bawetro, John, of Warmesworth, cart wright 0
5142492 2398933 2398933 defendant Taillour William   597300 597300 Taillour, William, of Warmesworth 0
5177337 2409065 2409065 defendant Taillour William clerk 597300 597300 Taillour, William, of Warmesworth, clerk 1
5226995 2423548 2423548 defendant Ondworth or Oudworth William yeoman 597300 597300 Ondworth or Oudworth, William, of Warmesworth juxta Doncaster, yeoman 0
5304637 2446386 2446386 defendant Spenser Robert yeoman 597300 597300 Spenser, Robert, of Warmesworth, yeoman 0
5304639 2446387 2446387 defendant Spenser Robert yeoman 597300 597300 Spenser, Robert, of Warmesworth, yeoman 0
5308736 2447650 2447650 defendant Cudworth William yeoman 597300 597300 Cudworth, William, of Warmesworth, yeoman 0
5377553 2468562 2468562 defendant Scotton William yeoman 597300 597300 Scotton, William, of Warmesworth, yeoman 0
5378863 2468975 2468975 defendant Scotton William yeoman 597300 597300 Scotton, William, of Warmesworth, yeoman 0
5439623 2486790 2486790 defendant Scotton William yeoman 597300 597300 Scotton, William, of Warmesworth, yeoman 0
5453369 2490894 2490894 defendant Scotton William yeoman 597300 597300 Scotton, William, of Warmesworth, yeoman 0
5499834 2504898 2504898 defendant Bawtre Thomas husbandman 597300 597300 Bawtre, Thomas, of Warmesworth, husbandman 0
5499836 2504899 2504899 defendant Gowtre Thomas husbandman 597300 597300 Gowtre, Thomas, of Warmesworth, husbandman 0
5561600 2523379 2523379 defendant Smyth John husbandman 597300 597300 Smyth, John, of Warmesworth, husbandman 0
5597215 2534038 2534038 defendant Norton William yeoman 597300 597300 Norton, William, of Warmesworth, yeoman 0

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