ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where fips = 29213 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
8919 | 8919 | 2020-03-23 | Taney | Missouri | 29213 | 1 | 0 |
10221 | 10221 | 2020-03-24 | Taney | Missouri | 29213 | 1 | 0 |
11650 | 11650 | 2020-03-25 | Taney | Missouri | 29213 | 1 | 0 |
13249 | 13249 | 2020-03-26 | Taney | Missouri | 29213 | 1 | 0 |
14977 | 14977 | 2020-03-27 | Taney | Missouri | 29213 | 1 | 0 |
16802 | 16802 | 2020-03-28 | Taney | Missouri | 29213 | 2 | 0 |
18724 | 18724 | 2020-03-29 | Taney | Missouri | 29213 | 2 | 0 |
20758 | 20758 | 2020-03-30 | Taney | Missouri | 29213 | 2 | 0 |
22878 | 22878 | 2020-03-31 | Taney | Missouri | 29213 | 2 | 0 |
25066 | 25066 | 2020-04-01 | Taney | Missouri | 29213 | 2 | 0 |
27323 | 27323 | 2020-04-02 | Taney | Missouri | 29213 | 2 | 0 |
29645 | 29645 | 2020-04-03 | Taney | Missouri | 29213 | 5 | 0 |
32026 | 32026 | 2020-04-04 | Taney | Missouri | 29213 | 5 | 0 |
34454 | 34454 | 2020-04-05 | Taney | Missouri | 29213 | 5 | 0 |
36920 | 36920 | 2020-04-06 | Taney | Missouri | 29213 | 7 | 0 |
39436 | 39436 | 2020-04-07 | Taney | Missouri | 29213 | 7 | 0 |
41990 | 41990 | 2020-04-08 | Taney | Missouri | 29213 | 7 | 0 |
44568 | 44568 | 2020-04-09 | Taney | Missouri | 29213 | 7 | 1 |
47177 | 47177 | 2020-04-10 | Taney | Missouri | 29213 | 7 | 1 |
49825 | 49825 | 2020-04-11 | Taney | Missouri | 29213 | 7 | 1 |
52498 | 52498 | 2020-04-12 | Taney | Missouri | 29213 | 7 | 1 |
55180 | 55180 | 2020-04-13 | Taney | Missouri | 29213 | 8 | 1 |
57878 | 57878 | 2020-04-14 | Taney | Missouri | 29213 | 7 | 1 |
60592 | 60592 | 2020-04-15 | Taney | Missouri | 29213 | 8 | 1 |
63314 | 63314 | 2020-04-16 | Taney | Missouri | 29213 | 8 | 1 |
66054 | 66054 | 2020-04-17 | Taney | Missouri | 29213 | 8 | 1 |
68808 | 68808 | 2020-04-18 | Taney | Missouri | 29213 | 9 | 1 |
71575 | 71575 | 2020-04-19 | Taney | Missouri | 29213 | 9 | 1 |
74348 | 74348 | 2020-04-20 | Taney | Missouri | 29213 | 9 | 1 |
77129 | 77129 | 2020-04-21 | Taney | Missouri | 29213 | 9 | 1 |
79916 | 79916 | 2020-04-22 | Taney | Missouri | 29213 | 9 | 1 |
82712 | 82712 | 2020-04-23 | Taney | Missouri | 29213 | 10 | 1 |
85516 | 85516 | 2020-04-24 | Taney | Missouri | 29213 | 10 | 1 |
88326 | 88326 | 2020-04-25 | Taney | Missouri | 29213 | 10 | 1 |
91142 | 91142 | 2020-04-26 | Taney | Missouri | 29213 | 10 | 1 |
93963 | 93963 | 2020-04-27 | Taney | Missouri | 29213 | 10 | 1 |
96799 | 96799 | 2020-04-28 | Taney | Missouri | 29213 | 11 | 1 |
99645 | 99645 | 2020-04-29 | Taney | Missouri | 29213 | 11 | 1 |
102497 | 102497 | 2020-04-30 | Taney | Missouri | 29213 | 11 | 1 |
105358 | 105358 | 2020-05-01 | Taney | Missouri | 29213 | 11 | 2 |
108223 | 108223 | 2020-05-02 | Taney | Missouri | 29213 | 12 | 2 |
111096 | 111096 | 2020-05-03 | Taney | Missouri | 29213 | 12 | 2 |
113975 | 113975 | 2020-05-04 | Taney | Missouri | 29213 | 12 | 2 |
116857 | 116857 | 2020-05-05 | Taney | Missouri | 29213 | 12 | 2 |
119817 | 119817 | 2020-05-06 | Taney | Missouri | 29213 | 12 | 2 |
122791 | 122791 | 2020-05-07 | Taney | Missouri | 29213 | 12 | 2 |
125773 | 125773 | 2020-05-08 | Taney | Missouri | 29213 | 12 | 2 |
128761 | 128761 | 2020-05-09 | Taney | Missouri | 29213 | 12 | 2 |
131751 | 131751 | 2020-05-10 | Taney | Missouri | 29213 | 12 | 2 |
134742 | 134742 | 2020-05-11 | Taney | Missouri | 29213 | 12 | 2 |
137732 | 137732 | 2020-05-12 | Taney | Missouri | 29213 | 12 | 2 |
140726 | 140726 | 2020-05-13 | Taney | Missouri | 29213 | 12 | 2 |
143721 | 143721 | 2020-05-14 | Taney | Missouri | 29213 | 12 | 2 |
146722 | 146722 | 2020-05-15 | Taney | Missouri | 29213 | 12 | 2 |
149728 | 149728 | 2020-05-16 | Taney | Missouri | 29213 | 12 | 2 |
152739 | 152739 | 2020-05-17 | Taney | Missouri | 29213 | 12 | 2 |
155753 | 155753 | 2020-05-18 | Taney | Missouri | 29213 | 12 | 2 |
158771 | 158771 | 2020-05-19 | Taney | Missouri | 29213 | 12 | 2 |
161797 | 161797 | 2020-05-20 | Taney | Missouri | 29213 | 12 | 2 |
164826 | 164826 | 2020-05-21 | Taney | Missouri | 29213 | 12 | 2 |
167862 | 167862 | 2020-05-22 | Taney | Missouri | 29213 | 12 | 2 |
170901 | 170901 | 2020-05-23 | Taney | Missouri | 29213 | 12 | 2 |
173943 | 173943 | 2020-05-24 | Taney | Missouri | 29213 | 13 | 2 |
176986 | 176986 | 2020-05-25 | Taney | Missouri | 29213 | 13 | 2 |
180030 | 180030 | 2020-05-26 | Taney | Missouri | 29213 | 13 | 2 |
183078 | 183078 | 2020-05-27 | Taney | Missouri | 29213 | 13 | 2 |
186134 | 186134 | 2020-05-28 | Taney | Missouri | 29213 | 13 | 2 |
189192 | 189192 | 2020-05-29 | Taney | Missouri | 29213 | 13 | 2 |
192256 | 192256 | 2020-05-30 | Taney | Missouri | 29213 | 13 | 2 |
195326 | 195326 | 2020-05-31 | Taney | Missouri | 29213 | 13 | 2 |
198397 | 198397 | 2020-06-01 | Taney | Missouri | 29213 | 13 | 2 |
201470 | 201470 | 2020-06-02 | Taney | Missouri | 29213 | 13 | 2 |
204547 | 204547 | 2020-06-03 | Taney | Missouri | 29213 | 13 | 2 |
207628 | 207628 | 2020-06-04 | Taney | Missouri | 29213 | 13 | 2 |
210709 | 210709 | 2020-06-05 | Taney | Missouri | 29213 | 13 | 2 |
213793 | 213793 | 2020-06-06 | Taney | Missouri | 29213 | 13 | 2 |
216882 | 216882 | 2020-06-07 | Taney | Missouri | 29213 | 13 | 2 |
219974 | 219974 | 2020-06-08 | Taney | Missouri | 29213 | 13 | 2 |
223069 | 223069 | 2020-06-09 | Taney | Missouri | 29213 | 13 | 2 |
226168 | 226168 | 2020-06-10 | Taney | Missouri | 29213 | 13 | 2 |
229271 | 229271 | 2020-06-11 | Taney | Missouri | 29213 | 15 | 2 |
232375 | 232375 | 2020-06-12 | Taney | Missouri | 29213 | 15 | 2 |
235481 | 235481 | 2020-06-13 | Taney | Missouri | 29213 | 15 | 2 |
238588 | 238588 | 2020-06-14 | Taney | Missouri | 29213 | 15 | 2 |
241698 | 241698 | 2020-06-15 | Taney | Missouri | 29213 | 24 | 2 |
244809 | 244809 | 2020-06-16 | Taney | Missouri | 29213 | 26 | 2 |
247922 | 247922 | 2020-06-17 | Taney | Missouri | 29213 | 27 | 2 |
251035 | 251035 | 2020-06-18 | Taney | Missouri | 29213 | 29 | 2 |
254150 | 254150 | 2020-06-19 | Taney | Missouri | 29213 | 30 | 2 |
257271 | 257271 | 2020-06-20 | Taney | Missouri | 29213 | 30 | 2 |
260397 | 260397 | 2020-06-21 | Taney | Missouri | 29213 | 30 | 2 |
263525 | 263525 | 2020-06-22 | Taney | Missouri | 29213 | 32 | 2 |
266651 | 266651 | 2020-06-23 | Taney | Missouri | 29213 | 34 | 2 |
269784 | 269784 | 2020-06-24 | Taney | Missouri | 29213 | 35 | 2 |
272923 | 272923 | 2020-06-25 | Taney | Missouri | 29213 | 39 | 2 |
276066 | 276066 | 2020-06-26 | Taney | Missouri | 29213 | 40 | 2 |
279214 | 279214 | 2020-06-27 | Taney | Missouri | 29213 | 48 | 2 |
282362 | 282362 | 2020-06-28 | Taney | Missouri | 29213 | 56 | 2 |
285507 | 285507 | 2020-06-29 | Taney | Missouri | 29213 | 60 | 2 |
288657 | 288657 | 2020-06-30 | Taney | Missouri | 29213 | 60 | 2 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);