missing states in acs_ygl_language_spoken_at_home_by_english_ability_1

[davelandry]

I can't say for sure how much is missing, but for sure Idaho is missing 2014 and 2015 data: https://voyageurs-api.datausa.io/ui/#eyJkcmlsbERvd25zIjpbWyJZZWFyIiwiWWVhciIsIlllYXIiXSxbIkdlb2dyYXBoeSIsIlN0YXRlIiwiU3RhdGUiXV0sImN1dHMiOltbWyIwNDAwMFVTMTYiXSxbIkdlb2dyYXBoeSIsIlN0YXRlIiwiU3RhdGUiXV1dLCJjdWJlIjoiYWNzX3lnbF9sYW5ndWFnZV9zcG9rZW5fYXRfaG9tZV9ieV9lbmdsaXNoX2FiaWxpdHlfMSIsIm1lYXN1cmVzIjpbIkxhbmd1YWdlcyBTcG9rZW4iXX0=

[hwchen]

I'm going to continue to investigate, but just wanted to note that the raw data from the api is null for the missing years.

(First search is for idaho 16, second is for california 06)

hercules:acs_ygl_language_spoken_at_home_by_english_ability > find 2015_state -x rg '"16"]'
["38","106","0","332","62","425","290","507","786","548","898","1704","539","901","223","176","22","1973","220","79","9","946","1209","45","0","825","642","415","322","3384","2257","1891","567","150","36","18","156","67","306","85","488","169","15","27","218","77","140","80","55","25","16"],
["1342470","72150","46947","2881","315","37","16","532","102","1276","214","3528","593","12","0","710","141","418","140","97","20","1018","543","116","93","1693","686","603","339","15","4","196","263","57","21","570","60","154","26","346","507","757","483","1603","2294","778","353","585","641","69","16"],
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16"],
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16"],
[null,null,null,null,null,null,null,null,"16"],
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16"],
["315","425","40","27","375","379","133","156","16"],
["351","214","68","80","557","240","308","277","18","6","130","252","69","36","219","51","125","27","189","248","363","226","284","509","192","136","224","256","43","33","70","27","179","37","231","113","211","239","242","455","412","184","222","105","90","20","253","137","55","14","16"],
hercules:acs_ygl_language_spoken_at_home_by_english_ability > find 2015_state -x rg '"06"]'
["20142054","5898414","4430740","107604","19048","5707","1364","48297","12058","53783","23946","94455","13419","2588","474","23048","3182","21431","2455","19605","5089","84214","72109","14440","4810","14680","5778","20783","14319","101966","92324","120140","75896","32521","13830","133793","32462","35104","12650","124711","80630","31576","16360","483526","633043","77630","64728","160407","215449","37245","06"],
["40600","40841","33689","19490","27666","19827","18540","219415","319841","127952","50717","521444","266692","78618","43739","1187","156","5811","814","8752","3696","103038","65444","34624","6790","51222","22522","21672","19004","38737","23772","16841","3010","1058","742","302","1801","820","1821","1363","2137","895","377","172","1324","403","1372","481","1380","594","06"],
["7371","5335","2576","1096","2828","1416","3839","2240","7538","6554","8729","5107","4151","3573","10738","4693","5162","2118","9551","7884","4272","3270","13950","16712","5512","4688","10103","9085","4070","3619","6054","3453","3205","3556","3432","2658","10183","13038","9108","5196","18781","10478","5913","3663","542","209","1862","683","1874","1009","06"],
["20311365","6262583","4383428","113573","17032","3819","1096","46451","12754","55902","22358","96416","13152","2590","364","21577","2203","19354","1755","20629","6066","92446","68544","16228","4152","13290","5782","19166","10690","99596","88270","118899","80721","32050","13939","150794","35394","39117","13367","135474","88685","31168","16849","517194","689509","78153","66968","168980","208552","37308","06"],
["10013","8041","5460","1525","6101","3932","3977","4466","06"],
["39467","44984","30390","20878","28183","21500","20849","212261","322145","148977","54096","549317","283373","80178","40500","887","230","6948","1020","9983","3011","118206","74774","37221","6047","56824","27021","20612","21535","52760","42307","34319","6354","2457","1059","612","3788","1734","4678","2635","5567","2181","1090","292","2571","985","2659","725","3020","1650","06"],
["4087","3055","1821","789","2544","1517","1604","1451","06"],
["3216","2495","1075","570","1195","611","1469","1070","2871","2376","4169","2332","1660","952","4195","1963","2334","1122","3615","3256","2011","1092","5574","7198","2354","2236","4047","4368","2292","1747","2415","2016","1164","1741","1571","1314","4983","5695","3928","2256","7360","4408","2606","1945","274","72","663","223","755","479","06"],

[hwchen]

It's only null for 1-yr. 5yr should have data.

@jspeis should we expect language data for all states at 1-yr?

hercules:acs_ygl_language_spoken_at_home_by_english_ability > find 2015_state_1 -x rg '"16"]'
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16"],
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16"],
[null,null,null,null,null,null,null,null,"16"],
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"16"],

[hwchen]

I'm going to ping census slack

[hwchen]

Also, @davelandry I noticed that the old datausa uses both 1 and 5yr on this table: https://datausa.io/profile/geo/idaho/#demographics

[davelandry]

@jspeis could answer that about the old DataUSA (he handled all of the old site's logic)