Closed hwchen closed 2 years ago
@hwchen @jspeiser is the acs_ygf_place_of_birth_for_foreign_born_1 table known for not having much data? I'm trying to show foreign-born percentages, and for example the Providence MSA only has a 2016 value: https://andesite-api.datausa.io/ui/#eyJkcmlsbERvd25zIjpbWyJZZWFyIiwiWWVhciIsIlllYXIiXSxbIkdlb2dyYXBoeSIsIk1TQSIsIk1TQSJdXSwiY3V0cyI6W1tbIjMxMDAwVVMzOTMwMCJdLFsiR2VvZ3JhcGh5IiwiTVNBIiwiTVNBIl1dXSwiY3ViZSI6ImFjc195Z2ZfcGxhY2Vfb2ZfYmlydGhfZm9yX2ZvcmVpZ25fYm9ybl8xIiwibWVhc3VyZXMiOlsiRm9yZWlnbi1Cb3JuIENpdGl6ZW5zIl19 (compared to the 5 year with all years)
acs_ygf_place_of_birth_for_foreign_born_1
From checking in database, 2015 and 2017 have null values. 2013 and 2014 have no rows at all.
Action item: check api data after fetch is redone.
@hwchen @jspeiser is the
acs_ygf_place_of_birth_for_foreign_born_1table known for not having much data? I'm trying to show foreign-born percentages, and for example the Providence MSA only has a 2016 value: https://andesite-api.datausa.io/ui/#eyJkcmlsbERvd25zIjpbWyJZZWFyIiwiWWVhciIsIlllYXIiXSxbIkdlb2dyYXBoeSIsIk1TQSIsIk1TQSJdXSwiY3V0cyI6W1tbIjMxMDAwVVMzOTMwMCJdLFsiR2VvZ3JhcGh5IiwiTVNBIiwiTVNBIl1dXSwiY3ViZSI6ImFjc195Z2ZfcGxhY2Vfb2ZfYmlydGhfZm9yX2ZvcmVpZ25fYm9ybl8xIiwibWVhc3VyZXMiOlsiRm9yZWlnbi1Cb3JuIENpdGl6ZW5zIl19 (compared to the 5 year with all years)From checking in database, 2015 and 2017 have null values. 2013 and 2014 have no rows at all.
Action item: check api data after fetch is redone.