I would like to Select just one of the counties; I am trying “name.ByCounty.County” : “King”. But I get no data in the result set.
In addition, how do I access elements of the array of DailyStates that is nested in the by county data
The document is structured as follows:
{
"_id": {
"$oid": "5eba4e63e4c68d0631a26bbe"
},
"name": "Washington",
"byCounty": [{
"DailyStats": [{
"TotalConfirmed": 5174,
"TotalDeaths": 346,
"DailyConfirmed": 272,
"DailyDeaths": 15,
"Date": "4/19/2020"
}, {
"TotalConfirmed": 5174,
"TotalDeaths": 346,
"DailyConfirmed": 0,
"DailyDeaths": 0,
"Date": "4/20/2020"
}, {
"TotalConfirmed": 5293,
"TotalDeaths": 360,
"DailyConfirmed": 119,
"DailyDeaths": 14,
"Date": "4/21/2020"
}, {
"TotalConfirmed": 5379,
"TotalDeaths": 373,
"DailyConfirmed": 86,
"DailyDeaths": 13,
"Date": "4/22/2020"
}, {
"TotalConfirmed": 5532,
"TotalDeaths": 385,
"DailyConfirmed": 153,
"DailyDeaths": 12,
"Date": "4/23/2020"
}],
"StateOrTerritory": "US",
"Latitude": 47.49137892,
"Longitude": -121.8346131,
"County": "King",
"Population": 2252782
}, {
"DailyStats": [{
"TotalConfirmed": 804,
"TotalDeaths": 36,
"DailyConfirmed": 45,
"DailyDeaths": 2,
"Date": "4/19/2020"
}, {
"TotalConfirmed": 835,
"TotalDeaths": 36,
"DailyConfirmed": 31,
"DailyDeaths": 0,
"Date": "4/20/2020"
}, {
"TotalConfirmed": 868,
"TotalDeaths": 38,
"DailyConfirmed": 33,
"DailyDeaths": 2,
"Date": "4/21/2020"
}, {
"TotalConfirmed": 886,
"TotalDeaths": 38,
"DailyConfirmed": 18,
"DailyDeaths": 0,
"Date": "4/22/2020"
}, {
"TotalConfirmed": 879,
"TotalDeaths": 41,
"DailyConfirmed": -7,
"DailyDeaths": 3,
"Date": "4/23/2020"
}],
"StateOrTerritory": "US",
"Latitude": 46.45738486,
"Longitude": -120.7380126,
"County": "Yakima",
"Population": 250873
}]
}