usaspending-api icon indicating copy to clipboard operation
usaspending-api copied to clipboard

link data_elements.csv from api dictionary?

Open jsfenfen opened this issue 8 years ago • 2 comments

The api data dictionary (here) is missing definitions for many of the more technical (and obscure sounding) data elements, like "ussgl488100_upward_adjust_pri_undeliv_order_oblig_unpaid_cpe". It appears that many of these elements are defined in a file that (it looks like) @kaitlin and @bsweger put here: https://github.com/fedspendingtransparency/fedspendingtransparency.github.io/blob/master/_data/elements.csv . It would be useful to:

  • Link to elements.csv from the API data dictionary page (or import the definitions from the _elements csv file to the in-page definitions)
  • The elements.csv also explains the variable names used in the agency submission files (or, at least, I think it does). Assuming this is the correct file, maybe it could be linked from the top of the agency submission files pages, like this one ?

Thanks again for all y'alls work on this--this is really useful info!

jsfenfen avatar May 10 '17 16:05 jsfenfen

@jsfenfen Thank you for weighing in and for taking a deep dive into the various DATA Act artifacts.

Agreed that your proposal to link to data definitions as a first step for tying everything together is a good idea. I added a story for this to our project backlog (which gets groomed and prioritized weekly): https://federal-spending-transparency.atlassian.net/browse/DS-1278

Thanks again for taking the time to log an issue--much appreciated!

bsweger avatar May 11 '17 17:05 bsweger

Our up-to-date Data Dictionary can be found here: https://www.usaspending.gov/#/download_center/data_dictionary It partially satisfies the missing linkages.

tony-sappe avatar Mar 10 '19 19:03 tony-sappe