Archive for September 30th, 2012
HHS Grants Database (TAGGS.HHS.gov) isn’t “Close enough for Jazz.” [Publ. Sept. 30, 2012; Formatted Aug. 2, 2022]
Post updated (for clarity and to add title link and a few borders, not much more) 8/2/2022…
[About 9,500 words. Like most of my posts, that includes many quotations… Because I’m also discussing a federal database, it also includes blocks of text (tables) which show definitions of various fields or pieces of data in it.
What I have to say, the “tell” in “Show and Tell,” isn’t the largest part of this post. Look at what’s shown, much of it become self-evident, (I believe!)
I’m showing (and telling) how HHS, the US agency in place to help Humans be Healthy, isn’t Helping us Track its Grants well enough. [“TAGGS.HHS.gov” ]
Data elements that the users should be able to sort on aren’t even menu choices... and of the fields they CAN sort on, those aren’t always even entered filled in.
I pick on a few examples, including an abstinence/healthy marriage grantee, of course]
Post Title:
HHS Grants Database (TAGGS.HHS.gov) isn’t “Close enough for Jazz.” [Publ. Sept. 30, 2012; Formatted Aug. 2, 2022] (short-link ends “-19Y”)
HHS Data Quality in the TAGGS Database
Accessible Data for the Public
Appropriation Fiscal Year | Fiscal Year of the appropriation used to fund this action. Note: An appropriation is a statute made available by Congress that provides the authority to incur financial obligations and to make payments associated with DHHS grant programs. |
Appropriation Number | Treasury account code identifying the appropriation used to fund this action. Note: An appropriation is a statute made available by Congress that provides the authority to incur financial obligations and to make payments associated with DHHS grant programs. |
Appropriation Title | Full title of an appropriation. Note: An appropriation is a statute made available by Congress that provides the authority to incur financial obligations and to make payments associated with DHHS grant programs. |
Authorization | Legal authority cited in the Catalog of Federal Domestic Assistance (CFDA) upon which an HHS program is based (acts, amendments to acts, Public Law numbers, titles, sections, Statute Codes, citations to the US Code, Executive Orders, Presidential Reorganization Plans, and Memoranda from an agency head). |
The matters in blue remind us that spending isn’t supposed to happen without authorization and appropriation. Yet look at the “Advanced Search” page and see if you can find those fields.
There’s one link to “Advanced Search” (explore on your own time), and several shortcuts to other menu items, and some pre-planned reports. Yet I found in a general search, there are plenty of grants missing codes — DUNS code, some missing a CFDA Code (plenty missing a principal investigator; do not yet know if these are specifically block grants only). Of the principal investigators there really ought to be a first name, last name designation [as a separate field] and no title entered unless there’s a designated field “Title.” that’s BASIC data design, omitted here..
Therefore Principal Investigator’s given names who happen to be M.D. or Ph.D. and could be called “Doctor” properly, would show up alphabetized under “D” not their names. In addition, that could be entered before or after a given name.
http://taggs.hhs.gov/AdvancedSearch.cfm
Any feedback on how someone may get to this data via the public access site?
I see many fields described which do not show up on “Advanced Search” options — please let me know. For example, nothing should be paid out which Congress, Executive Order, or some other authority has no