Attachment 5 - HEROES Toolkit Data Format Requirements.pdf
PDF 80 KB Posted
- Attached to
- Scientific Data Services Federal contract opportunity
- Solicitation number
- 75N99224Q00002
About this file
This document is a Combined Synopsis/Solicitation for a federal contract opportunity issued by the Department of Health and Human Services' Advanced Research Projects Agency for Health (ARPA-H). The solicitation, number 75N99224Q00002, is for "Scientific Data Services" to support the HEROES program's data toolkit.
The key requirements include providing data variables for severe obstetric complications, atherosclerotic cardiovascular disease and associated 10-year risk scores, and other data variables specific to the HEROES program. Deliverables are to be provided on a monthly basis for a 2-year period. Quotes are due by April 19, 2024, and award will be made to the responsible offeror with the lowest price technically acceptable offer. This is a full and open competition under NAICS code 541715, with no small business set-aside. The government reserves the right to conduct interchanges with offerors if deemed necessary.
View the file
Other files for this federal contract opportunity
| File | Type | Posted |
|---|---|---|
| Attachment 3 - Statement of Need - HEROES Data Variables Sol Amend 0001.pdf | ||
| Attachment 6 - RFQ QA_Responses_Final.pdf | ||
| Attachment 1 - SF33 Sol 75N99224Q00002 Amend 0001.pdf | ||
| Attachment 2 - Continuation Sheet 75N99224Q00002.pdf | ||
| Attachment 3 - Statement of Need - HEROES Data Variables Sol.pdf | ||
| Attachment 1 - SF33 Sol 75N99224Q00002.pdf | ||
| Attachment 4 - Applicable Provisions and Clauses Final.pdf |
On GovTribe
Work with this file on GovTribe
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Main Data File Format Column Description Example Why we need this GEOID Zip3, FIPS Code, AFFGEOID, Census GEOID 51013 (Arlington County Va.) This columns is required for us to join to Census Geometries
StartDate Start of time period this row is valid for. In ISO Format https://en.wikipedia.org/wiki/ISO_8601 2024-03-01T00:00:01Z Displayed in GUI
EndDate End of time period this row is valid for. In ISO 8601 Format 2024-03-31T00:00:01Z Displayed in GUI
PatientPopulation The sample size or patient population at the GEOID, StartDate, EndDate Level Integer value corresponding to the Patient Population (i.e. Number of Pregnancy deliveries) This will allow us to do weighted averages/aggregations for user selections.
[Metric Columns] The Metric Columns at the GEOID, StartDate, EndDate Level Numeric (float/integer/double) value corresponding to the metric. (i.e.
AnySOC). These are values that will be displayed in GUI
[Metric Columns] x [Age Categories] If possible, the Metric Columns broken out by age. If these categories do not line up with 2020 Census Demographic Profile, provide a recommended mapping.
Numeric (float/integer/double) value corresponding to the metric broken out by age. (i.e. MeanASCVD for Ages 40 to 49). If this is provided, also breakout the PatientPopulation by the same Age categories. These values could be displayed in GUI for Selected Values.
[Metric Columns] x [Race Categories] If possible, the Metric Columns broken out by Race. If these categories do not line up with 2020 Census Demographic Profile, provide a recommended mapping.
Numeric (float/integer/double) value corresponding to the metric broken out by race. (i.e. MeanASCVD for White). If this is provided, also breakout the PatientPopulation by the same Race categories. These values could be displayed in GUI for Selected Values.
[Metric Columns] x [Sex Categories] If possible, the Metric Columns broken out by Sex. If these categories do not line up with 2020 Census Demographic Profile, provide a recommended mapping.
Numeric (float/integer/double) value corresponding to the metric broken out by sex. (i.e. MeanASCVD for Male). If this is provided, also breakout the PatientPopulation by the same Sex categories. These values could be displayed in GUI for Selected Values.
Bins Statistics File Format note that this file is only needed if the metric scores are aggregated into discrete bins
Column Description Example Why we need this Metric The metric this bin corresponds to opioid_rate To Join with the Main Data File StartDate The Start of time period this bin is valid for. 2024-03-01T00:00:01Z To Join with the Main Data File EndDate The End of time period this bin is valid for. 2024-03-31T00:00:01Z To Join with the Main Data File Bin Rank/ID The Bin Rank or ID. 1 To Join with the Main Data File Bin Label Human Readable Description of the Bin Significantly Lower than National Average Human Readable Label to display in tooltips.
Bin Minimum The minimum value for the bin. 12.21 Used for calculating selection averages.
Bin Median The median value for the bin. 53.13 Used for calculating selection averages.
Bin Mean The mean value for the bin. 55.98 Used for calculating selection averages.
Bin Maximum The maximum value for the bin. 80.13 Used for calculating selection averages.
National Average Trendline File Format Column Description Example Why we need this Metric The metric this bin corresponds to StartDate The Start of time period this bin is valid for.
EndDate The End of time period this bin is valid for.
Value The National Average Value.
Source: 2020 Census Demographic Profile https://api.census.gov/data/2020/dec/dp/variables.html
Proposed Age Categories Census Variable ID Proposed Race Categories Census Variable ID 0 to 5 years DP1_0002C White DP1_0078C 5 to 9 years DP1_0003C Black or African American DP1_0079C 10 to 14 years DP1_0004C American Indian and Alaska Native DP1_0080C 15 to 19 years DP1_0005C Asian DP1_0081C 20 to 24 years DP1_0006C Native Hawaiian and Other Pacific Islander DP1_0082C 25 to 29 years DP1_0007C Other Race DP1_0083C 30 to 34 years DP1_0008C Two Or More Races DP1_0084C 35 to 39 years DP1_0009C 40 to 44 years DP1_0010C 45 to 49 years DP1_0011C 50 to 54 years DP1_0012C 55 to 59 years DP1_0013C 60 to 64 years DP1_0014C 65 to 69 years DP1_0015C 70 to 74 years DP1_0016C 75 to 79 years DP1_0017C 80 to 84 years DP1_0018C 85 years and over DP1_0019C
File details come from the government source that posted it. Updated .