ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 29101 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
384261 | 384261 | 2020-07-30 | Johnson | Missouri | 29101 | 445 | 2 |
381045 | 381045 | 2020-07-29 | Johnson | Missouri | 29101 | 437 | 2 |
377828 | 377828 | 2020-07-28 | Johnson | Missouri | 29101 | 427 | 2 |
374613 | 374613 | 2020-07-27 | Johnson | Missouri | 29101 | 417 | 2 |
371401 | 371401 | 2020-07-26 | Johnson | Missouri | 29101 | 417 | 2 |
368190 | 368190 | 2020-07-25 | Johnson | Missouri | 29101 | 416 | 2 |
364982 | 364982 | 2020-07-24 | Johnson | Missouri | 29101 | 411 | 2 |
361775 | 361775 | 2020-07-23 | Johnson | Missouri | 29101 | 397 | 2 |
358570 | 358570 | 2020-07-22 | Johnson | Missouri | 29101 | 389 | 2 |
355367 | 355367 | 2020-07-21 | Johnson | Missouri | 29101 | 381 | 2 |
352165 | 352165 | 2020-07-20 | Johnson | Missouri | 29101 | 372 | 2 |
348965 | 348965 | 2020-07-19 | Johnson | Missouri | 29101 | 354 | 2 |
345764 | 345764 | 2020-07-18 | Johnson | Missouri | 29101 | 350 | 2 |
342564 | 342564 | 2020-07-17 | Johnson | Missouri | 29101 | 322 | 2 |
339368 | 339368 | 2020-07-16 | Johnson | Missouri | 29101 | 309 | 2 |
336172 | 336172 | 2020-07-15 | Johnson | Missouri | 29101 | 309 | 2 |
332979 | 332979 | 2020-07-14 | Johnson | Missouri | 29101 | 309 | 2 |
329792 | 329792 | 2020-07-13 | Johnson | Missouri | 29101 | 309 | 2 |
326606 | 326606 | 2020-07-12 | Johnson | Missouri | 29101 | 246 | 2 |
323423 | 323423 | 2020-07-11 | Johnson | Missouri | 29101 | 238 | 2 |
320244 | 320244 | 2020-07-10 | Johnson | Missouri | 29101 | 238 | 1 |
317069 | 317069 | 2020-07-09 | Johnson | Missouri | 29101 | 215 | 1 |
313895 | 313895 | 2020-07-08 | Johnson | Missouri | 29101 | 215 | 1 |
310724 | 310724 | 2020-07-07 | Johnson | Missouri | 29101 | 197 | 0 |
307556 | 307556 | 2020-07-06 | Johnson | Missouri | 29101 | 185 | 0 |
304389 | 304389 | 2020-07-05 | Johnson | Missouri | 29101 | 162 | 0 |
301225 | 301225 | 2020-07-04 | Johnson | Missouri | 29101 | 161 | 0 |
298062 | 298062 | 2020-07-03 | Johnson | Missouri | 29101 | 151 | 0 |
294904 | 294904 | 2020-07-02 | Johnson | Missouri | 29101 | 141 | 0 |
291750 | 291750 | 2020-07-01 | Johnson | Missouri | 29101 | 124 | 0 |
288599 | 288599 | 2020-06-30 | Johnson | Missouri | 29101 | 124 | 0 |
285449 | 285449 | 2020-06-29 | Johnson | Missouri | 29101 | 120 | 0 |
282304 | 282304 | 2020-06-28 | Johnson | Missouri | 29101 | 113 | 0 |
279156 | 279156 | 2020-06-27 | Johnson | Missouri | 29101 | 112 | 0 |
276008 | 276008 | 2020-06-26 | Johnson | Missouri | 29101 | 101 | 0 |
272865 | 272865 | 2020-06-25 | Johnson | Missouri | 29101 | 100 | 0 |
269727 | 269727 | 2020-06-24 | Johnson | Missouri | 29101 | 91 | 0 |
266594 | 266594 | 2020-06-23 | Johnson | Missouri | 29101 | 91 | 0 |
263468 | 263468 | 2020-06-22 | Johnson | Missouri | 29101 | 89 | 0 |
260340 | 260340 | 2020-06-21 | Johnson | Missouri | 29101 | 89 | 0 |
257214 | 257214 | 2020-06-20 | Johnson | Missouri | 29101 | 89 | 0 |
254094 | 254094 | 2020-06-19 | Johnson | Missouri | 29101 | 90 | 0 |
250979 | 250979 | 2020-06-18 | Johnson | Missouri | 29101 | 87 | 0 |
247866 | 247866 | 2020-06-17 | Johnson | Missouri | 29101 | 84 | 0 |
244753 | 244753 | 2020-06-16 | Johnson | Missouri | 29101 | 81 | 0 |
241642 | 241642 | 2020-06-15 | Johnson | Missouri | 29101 | 80 | 0 |
238532 | 238532 | 2020-06-14 | Johnson | Missouri | 29101 | 80 | 0 |
235425 | 235425 | 2020-06-13 | Johnson | Missouri | 29101 | 80 | 0 |
232319 | 232319 | 2020-06-12 | Johnson | Missouri | 29101 | 79 | 0 |
229215 | 229215 | 2020-06-11 | Johnson | Missouri | 29101 | 79 | 0 |
226112 | 226112 | 2020-06-10 | Johnson | Missouri | 29101 | 78 | 0 |
223014 | 223014 | 2020-06-09 | Johnson | Missouri | 29101 | 78 | 0 |
219919 | 219919 | 2020-06-08 | Johnson | Missouri | 29101 | 78 | 0 |
216827 | 216827 | 2020-06-07 | Johnson | Missouri | 29101 | 77 | 0 |
213739 | 213739 | 2020-06-06 | Johnson | Missouri | 29101 | 77 | 0 |
210655 | 210655 | 2020-06-05 | Johnson | Missouri | 29101 | 77 | 0 |
207574 | 207574 | 2020-06-04 | Johnson | Missouri | 29101 | 77 | 0 |
204493 | 204493 | 2020-06-03 | Johnson | Missouri | 29101 | 77 | 0 |
201416 | 201416 | 2020-06-02 | Johnson | Missouri | 29101 | 76 | 0 |
198343 | 198343 | 2020-06-01 | Johnson | Missouri | 29101 | 76 | 0 |
195272 | 195272 | 2020-05-31 | Johnson | Missouri | 29101 | 76 | 0 |
192203 | 192203 | 2020-05-30 | Johnson | Missouri | 29101 | 76 | 0 |
189139 | 189139 | 2020-05-29 | Johnson | Missouri | 29101 | 76 | 0 |
186081 | 186081 | 2020-05-28 | Johnson | Missouri | 29101 | 74 | 0 |
183025 | 183025 | 2020-05-27 | Johnson | Missouri | 29101 | 73 | 0 |
179979 | 179979 | 2020-05-26 | Johnson | Missouri | 29101 | 73 | 0 |
176935 | 176935 | 2020-05-25 | Johnson | Missouri | 29101 | 73 | 0 |
173892 | 173892 | 2020-05-24 | Johnson | Missouri | 29101 | 72 | 0 |
170850 | 170850 | 2020-05-23 | Johnson | Missouri | 29101 | 72 | 0 |
167811 | 167811 | 2020-05-22 | Johnson | Missouri | 29101 | 71 | 0 |
164775 | 164775 | 2020-05-21 | Johnson | Missouri | 29101 | 72 | 0 |
161746 | 161746 | 2020-05-20 | Johnson | Missouri | 29101 | 72 | 0 |
158720 | 158720 | 2020-05-19 | Johnson | Missouri | 29101 | 72 | 0 |
155702 | 155702 | 2020-05-18 | Johnson | Missouri | 29101 | 72 | 0 |
152688 | 152688 | 2020-05-17 | Johnson | Missouri | 29101 | 71 | 0 |
149677 | 149677 | 2020-05-16 | Johnson | Missouri | 29101 | 71 | 0 |
146672 | 146672 | 2020-05-15 | Johnson | Missouri | 29101 | 71 | 0 |
143671 | 143671 | 2020-05-14 | Johnson | Missouri | 29101 | 69 | 0 |
140676 | 140676 | 2020-05-13 | Johnson | Missouri | 29101 | 65 | 0 |
137682 | 137682 | 2020-05-12 | Johnson | Missouri | 29101 | 65 | 0 |
134692 | 134692 | 2020-05-11 | Johnson | Missouri | 29101 | 63 | 0 |
131701 | 131701 | 2020-05-10 | Johnson | Missouri | 29101 | 63 | 0 |
128711 | 128711 | 2020-05-09 | Johnson | Missouri | 29101 | 62 | 0 |
125724 | 125724 | 2020-05-08 | Johnson | Missouri | 29101 | 62 | 0 |
122742 | 122742 | 2020-05-07 | Johnson | Missouri | 29101 | 62 | 0 |
119768 | 119768 | 2020-05-06 | Johnson | Missouri | 29101 | 60 | 0 |
116808 | 116808 | 2020-05-05 | Johnson | Missouri | 29101 | 60 | 0 |
113926 | 113926 | 2020-05-04 | Johnson | Missouri | 29101 | 59 | 0 |
111047 | 111047 | 2020-05-03 | Johnson | Missouri | 29101 | 59 | 0 |
108176 | 108176 | 2020-05-02 | Johnson | Missouri | 29101 | 57 | 0 |
105311 | 105311 | 2020-05-01 | Johnson | Missouri | 29101 | 55 | 0 |
102450 | 102450 | 2020-04-30 | Johnson | Missouri | 29101 | 54 | 0 |
99598 | 99598 | 2020-04-29 | Johnson | Missouri | 29101 | 54 | 0 |
96752 | 96752 | 2020-04-28 | Johnson | Missouri | 29101 | 54 | 0 |
93916 | 93916 | 2020-04-27 | Johnson | Missouri | 29101 | 54 | 0 |
91095 | 91095 | 2020-04-26 | Johnson | Missouri | 29101 | 53 | 0 |
88279 | 88279 | 2020-04-25 | Johnson | Missouri | 29101 | 53 | 0 |
85469 | 85469 | 2020-04-24 | Johnson | Missouri | 29101 | 53 | 0 |
82665 | 82665 | 2020-04-23 | Johnson | Missouri | 29101 | 52 | 0 |
79869 | 79869 | 2020-04-22 | Johnson | Missouri | 29101 | 52 | 0 |
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);