The SPARCS data dictionary is a multi-tabbed Excel worksheet, details on its content are below. This worksheet provides the table names and a general description of what is contained within: https://www.health.ny.gov/statistics/sparcs/docs/sparcs_data_dictionary.xlsx
Tab | Name | Purpose |
Cover Sheet | Cover Sheet | Provides introductory information about the data dictionary |
1 | Table Names and Data Notes | See the layout of the SPARCS dataset and where each data element is located |
2 | SPARCS Output Data Elements | Lists all data elements available |
3 | Identifiable Data Elements | Lists elements that would require DGC approval to view and would be masked in a limited data request |
4 | HIV-AIDS & Abortion Rules | Lists elements affected by HIV-AIDS & Abortion redaction rules |
5 | Codes and Values Unique | Lists SPARCS unique codes. |
6 | Extract Order by Table Name | See the layout of the SPARCS dataset and where each data element is located |