names

64 rows where place_id = 593956

✎ 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
3613943 1872015 1872015 defendant Bradsha John gent 593956 593956 Bradsha, John, of Barneby, gent 0
3669222 1916312 1916312 defendant Banys William husbandman 593956 593956 Banys, William, of Barneby super Moram, husbandman 0
3730143 1935651 1935651 defendant Bullok James husbandman 593956 593956 Bullok, James, of Barneby, husbandman 0
3793550 1955843 1955843 defendant Edmunde Thomas clerk 593956 593956 Edmunde, Thomas, of Barneby, clerk 2
3849197 1973345 1973345 defendant Rypyng John husbandman 593956 593956 Rypyng, John, of Barneby, husbandman 0
3854531 1975057 1975057 defendant Adamson Robert yeoman 593956 593956 Adamson, Robert, of Barneby, yeoman 1
3869750 1980123 1980123 plaintiff Webster Thomas husbandman 593956 593956 Webster, Thomas, of Barneby, husbandman 0
3869751 1980123 1980123 defendant Webster Richard husbandman 593956 593956 Webster, Richard, of Barneby, husbandman 0
3883509 1984755 1984755 plaintiff Webster Thomas husbandman 593956 593956 Webster, Thomas, of Barneby, husbandman 0
3883510 1984755 1984755 defendant Webster Richard husbandman 593956 593956 Webster, Richard, of Barneby, husbandman 0
3920932 1997347 1997347 defendant Smyth William husbandman 593956 593956 Smyth, William, of Barneby, husbandman 2
4022600 2032805 2032805 defendant Brook William husbandman 593956 593956 Brook, William, of Barneby, husbandman 1
4022603 2032806 2032806 defendant Brooke William husbandman 593956 593956 Brooke, William, of Barneby, husbandman 1
4043310 2040074 2040074 defendant Browne John tinker 593956 593956 Browne, John, of Barneby, tinker 0
4104990 2062059 2062059 defendant Deye Richard husbandman 593956 593956 Deye, Richard, of Barneby, husbandman 1
4104994 2062060 2062060 defendant Deye Richard husbandman 593956 593956 Deye, Richard, of Barneby, husbandman 2
4165447 2083417 2083417 defendant Richreson or Richison John yeoman 593956 593956 Richreson or Richison, John, of Barneby, yeoman 0
4383645 2159241 2159241 defendant Halteway John husbandman 593956 593956 Halteway, John, of Barneby, husbandman 0
4454672 2186476 2186476 defendant Twyt John   593956 593956 Twyt, John, of Barneby 13
4482165 2195131 2195131 defendant Andrewe John   593956 593956 Andrewe, John, of Barneby 1
4530684 2209890 2209890 defendant Jay Hugh   593956 593956 Jay, Hugh, of Barneby 0
4580609 2225416 2225416 defendant Raynerson John   593956 593956 Raynerson, John, of Barneby 0
4580610 2225416 2225416 defendant Randolf Richard   593956 593956 Randolf, Richard, of Barneby 1
4615036 2235715 2235715 defendant Palmer Richard   593956 593956 Palmer, Richard, of Barneby 0
4650826 2246261 2246261 defendant Tommesson Robert   593956 593956 Tommesson, Robert, of Barneby 0
4653078 2246896 2246896 defendant Smyth John husbandman 593956 593956 Smyth, John, of Barneby, husbandman 0
4658702 2248595 2248595 defendant Hambald Richard husbandman 593956 593956 Hambald, Richard, of Barneby, husbandman 0
4678339 2258833 2258833 defendant Depynge William husbandman 593956 593956 Depynge, William, of Barneby, husbandman 1
4690822 2262661 2262661 defendant Passelewe John gent 593956 593956 Passelewe, John, of Barneby, gent 0
4699063 2265175 2265175 defendant Gilbard John husbandman 593956 593956 Gilbard, John, of Barneby, husbandman 0
4828875 2305069 2305069 defendant Wyllugby Thomas husbandman 593956 593956 Wyllugby, Thomas, of Barneby, husbandman 0
4830488 2305566 2305566 defendant Drayte Thomas husbandman 593956 593956 Drayte, Thomas, of Barneby, husbandman 2
4830576 2305585 2305585 defendant Burgh Thomas yeoman 593956 593956 Burgh, Thomas, of Barneby, yeoman 0
4857366 2313691 2313691 defendant Burgh Thomas yeoman 593956 593956 Burgh, Thomas, of Barneby, yeoman 0
4860589 2314669 2314669 defendant Clerk Ralph husbandman 593956 593956 Clerk, Ralph, of Barneby, husbandman 1
4895075 2325124 2325124 defendant Upton John yeoman 593956 593956 Upton, John, of Barneby, yeoman 2
4996452 2355794 2355794 defendant Holme John husbandman 593956 593956 Holme, John, of Barneby, husbandman 1
5013832 2360895 2360895 defendant Lyndesey Hugh husbandman 593956 593956 Lyndesey, Hugh, of Barneby, husbandman 1
5014890 2361232 2361232 defendant Bradshawe Richard yeoman 593956 593956 Bradshawe, Richard, of Barneby, yeoman 5
5040022 2368612 2368612 defendant Grene William husbandman 593956 593956 Grene, William, of Barneby, husbandman 0
5122899 2393131 2393131 defendant Bradshawe Richard yeoman 593956 593956 Bradshawe, Richard, of Barneby, yeoman 6
5138262 2397700 2397700 plaintiff Richardson Thomas   593956 593956 Richardson, Thomas, of Barneby 0
5138956 2397888 2397888 defendant Bradshawe (illegible)   593956 593956 Bradshawe, ----, of Barneby, franklin 11
5159059 2403765 2403765 plaintiff Richardson Thomas   593956 593956 Richardson, Thomas, of Barneby 0
5162939 2404886 2404886 plaintiff Warter William yeoman 593956 593956 Warter, William, of Barneby, yeoman 0
5174317 2408193 2408193 plaintiff Richardson Thomas   593956 593956 Richardson, Thomas, of Barneby 0
5174810 2408329 2408329 defendant Bradshawe Richard   593956 593956 Bradshawe, Richard, of Barneby, franklin 5
5179189 2409649 2409649 defendant Byllyngton William   593956 593956 Byllyngton, William, of Barneby, vicar 0
5196581 2414752 2414752 defendant Botiller John   593956 593956 Botiller, John, of Barneby, vicar 0
5196582 2414752 2414752 defendant Bradshawe Richard yeoman 593956 593956 Bradshawe, Richard, of Barneby, yeoman 1
5196583 2414752 2414752 defendant Gilberd Richard husbandman 593956 593956 Gilberd, Richard, of Barneby, husbandman 2
5277422 2438475 2438475 defendant Gilbert Thomas husbandman 593956 593956 Gilbert, Thomas, of Barneby, husbandman 1
5286360 2441010 2441010 defendant Ston John husbandman 593956 593956 Ston, John, of Barneby, husbandman 2
5300483 2445107 2445107 defendant Seman Thomas husbandman 593956 593956 Seman, Thomas, of Barneby, husbandman 0
5404210 2476281 2476281 plaintiff Parke William husbandman 593956 593956 Parke, William, of Barneby, husbandman 0
5496686 2503929 2503929 defendant Nabbys John yeoman 593956 593956 Nabbys, John, of Barneby, yeoman 0
5502220 2505620 2505620 defendant Gylberd Thomas husbandman 593956 593956 Gylberd, Thomas, of Barneby, husbandman 1
5502221 2505620 2505620 defendant Jaye John husbandman 593956 593956 Jaye, John, of Barneby, husbandman 2
5502223 2505620 2505620 defendant Bradshawe Thomas gent 593956 593956 Bradshawe, Thomas, of Barneby, gent 4
5521611 2511576 2511576 defendant Henlegge John   593956 593956 Henlegge, John, of Barneby, parish clerk 1
5612260 2547577 2547577 defendant Taillour Agnes   593956 593956 Taillour, Agnes, of Barneby, formerly wife of William 2
5612262 2547578 2547578 defendant Dobyn William   593956 593956 Dobyn, William, of Barneby 0
5626386 2552222 2552222 defendant Lyncoln William husbandman 593956 593956 Lyncoln, William, of Barneby, husbandman 0
5626387 2552222 2552222 defendant Belle Joan widow of Robert Belle 593956 593956 Belle, Joan, of Barneby, widow of Robert Belle 1

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