ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Clay" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387452 | 387452 | 2020-07-31 | Clay | Missouri | 29047 | 882 | 22 |
384234 | 384234 | 2020-07-30 | Clay | Missouri | 29047 | 857 | 22 |
381018 | 381018 | 2020-07-29 | Clay | Missouri | 29047 | 826 | 22 |
377801 | 377801 | 2020-07-28 | Clay | Missouri | 29047 | 784 | 22 |
374586 | 374586 | 2020-07-27 | Clay | Missouri | 29047 | 744 | 22 |
371374 | 371374 | 2020-07-26 | Clay | Missouri | 29047 | 717 | 22 |
368163 | 368163 | 2020-07-25 | Clay | Missouri | 29047 | 705 | 22 |
364955 | 364955 | 2020-07-24 | Clay | Missouri | 29047 | 688 | 22 |
361748 | 361748 | 2020-07-23 | Clay | Missouri | 29047 | 685 | 22 |
358543 | 358543 | 2020-07-22 | Clay | Missouri | 29047 | 655 | 22 |
355340 | 355340 | 2020-07-21 | Clay | Missouri | 29047 | 646 | 21 |
352138 | 352138 | 2020-07-20 | Clay | Missouri | 29047 | 630 | 21 |
348938 | 348938 | 2020-07-19 | Clay | Missouri | 29047 | 625 | 20 |
345737 | 345737 | 2020-07-18 | Clay | Missouri | 29047 | 617 | 20 |
342537 | 342537 | 2020-07-17 | Clay | Missouri | 29047 | 607 | 20 |
339341 | 339341 | 2020-07-16 | Clay | Missouri | 29047 | 597 | 20 |
336145 | 336145 | 2020-07-15 | Clay | Missouri | 29047 | 589 | 20 |
332952 | 332952 | 2020-07-14 | Clay | Missouri | 29047 | 579 | 20 |
329765 | 329765 | 2020-07-13 | Clay | Missouri | 29047 | 565 | 20 |
326579 | 326579 | 2020-07-12 | Clay | Missouri | 29047 | 558 | 20 |
323396 | 323396 | 2020-07-11 | Clay | Missouri | 29047 | 557 | 20 |
320217 | 320217 | 2020-07-10 | Clay | Missouri | 29047 | 550 | 20 |
317042 | 317042 | 2020-07-09 | Clay | Missouri | 29047 | 539 | 20 |
313868 | 313868 | 2020-07-08 | Clay | Missouri | 29047 | 526 | 20 |
310698 | 310698 | 2020-07-07 | Clay | Missouri | 29047 | 510 | 17 |
307530 | 307530 | 2020-07-06 | Clay | Missouri | 29047 | 504 | 17 |
304363 | 304363 | 2020-07-05 | Clay | Missouri | 29047 | 500 | 16 |
301199 | 301199 | 2020-07-04 | Clay | Missouri | 29047 | 493 | 16 |
298036 | 298036 | 2020-07-03 | Clay | Missouri | 29047 | 478 | 16 |
294878 | 294878 | 2020-07-02 | Clay | Missouri | 29047 | 472 | 16 |
291724 | 291724 | 2020-07-01 | Clay | Missouri | 29047 | 460 | 16 |
288573 | 288573 | 2020-06-30 | Clay | Missouri | 29047 | 454 | 16 |
285423 | 285423 | 2020-06-29 | Clay | Missouri | 29047 | 443 | 14 |
282278 | 282278 | 2020-06-28 | Clay | Missouri | 29047 | 431 | 12 |
279130 | 279130 | 2020-06-27 | Clay | Missouri | 29047 | 414 | 12 |
275982 | 275982 | 2020-06-26 | Clay | Missouri | 29047 | 406 | 12 |
272839 | 272839 | 2020-06-25 | Clay | Missouri | 29047 | 386 | 11 |
269701 | 269701 | 2020-06-24 | Clay | Missouri | 29047 | 375 | 11 |
266568 | 266568 | 2020-06-23 | Clay | Missouri | 29047 | 367 | 9 |
263442 | 263442 | 2020-06-22 | Clay | Missouri | 29047 | 348 | 9 |
260314 | 260314 | 2020-06-21 | Clay | Missouri | 29047 | 342 | 9 |
257188 | 257188 | 2020-06-20 | Clay | Missouri | 29047 | 342 | 9 |
254068 | 254068 | 2020-06-19 | Clay | Missouri | 29047 | 334 | 9 |
250953 | 250953 | 2020-06-18 | Clay | Missouri | 29047 | 319 | 8 |
247840 | 247840 | 2020-06-17 | Clay | Missouri | 29047 | 305 | 8 |
244727 | 244727 | 2020-06-16 | Clay | Missouri | 29047 | 299 | 7 |
241616 | 241616 | 2020-06-15 | Clay | Missouri | 29047 | 298 | 6 |
238507 | 238507 | 2020-06-14 | Clay | Missouri | 29047 | 295 | 3 |
235400 | 235400 | 2020-06-13 | Clay | Missouri | 29047 | 295 | 3 |
232294 | 232294 | 2020-06-12 | Clay | Missouri | 29047 | 295 | 3 |
229190 | 229190 | 2020-06-11 | Clay | Missouri | 29047 | 291 | 3 |
226087 | 226087 | 2020-06-10 | Clay | Missouri | 29047 | 263 | 3 |
222989 | 222989 | 2020-06-09 | Clay | Missouri | 29047 | 255 | 3 |
219894 | 219894 | 2020-06-08 | Clay | Missouri | 29047 | 243 | 3 |
216802 | 216802 | 2020-06-07 | Clay | Missouri | 29047 | 233 | 4 |
213714 | 213714 | 2020-06-06 | Clay | Missouri | 29047 | 228 | 4 |
210630 | 210630 | 2020-06-05 | Clay | Missouri | 29047 | 228 | 3 |
207549 | 207549 | 2020-06-04 | Clay | Missouri | 29047 | 192 | 3 |
204468 | 204468 | 2020-06-03 | Clay | Missouri | 29047 | 189 | 3 |
201391 | 201391 | 2020-06-02 | Clay | Missouri | 29047 | 184 | 3 |
198318 | 198318 | 2020-06-01 | Clay | Missouri | 29047 | 179 | 3 |
195247 | 195247 | 2020-05-31 | Clay | Missouri | 29047 | 173 | 3 |
192179 | 192179 | 2020-05-30 | Clay | Missouri | 29047 | 171 | 3 |
189115 | 189115 | 2020-05-29 | Clay | Missouri | 29047 | 169 | 3 |
186057 | 186057 | 2020-05-28 | Clay | Missouri | 29047 | 162 | 3 |
183001 | 183001 | 2020-05-27 | Clay | Missouri | 29047 | 158 | 3 |
179955 | 179955 | 2020-05-26 | Clay | Missouri | 29047 | 152 | 2 |
176911 | 176911 | 2020-05-25 | Clay | Missouri | 29047 | 148 | 2 |
173868 | 173868 | 2020-05-24 | Clay | Missouri | 29047 | 149 | 2 |
170826 | 170826 | 2020-05-23 | Clay | Missouri | 29047 | 141 | 2 |
167788 | 167788 | 2020-05-22 | Clay | Missouri | 29047 | 133 | 1 |
164752 | 164752 | 2020-05-21 | Clay | Missouri | 29047 | 127 | 1 |
161723 | 161723 | 2020-05-20 | Clay | Missouri | 29047 | 125 | 1 |
158697 | 158697 | 2020-05-19 | Clay | Missouri | 29047 | 123 | 1 |
155679 | 155679 | 2020-05-18 | Clay | Missouri | 29047 | 120 | 1 |
152665 | 152665 | 2020-05-17 | Clay | Missouri | 29047 | 114 | 1 |
149654 | 149654 | 2020-05-16 | Clay | Missouri | 29047 | 116 | 1 |
146649 | 146649 | 2020-05-15 | Clay | Missouri | 29047 | 113 | 1 |
143649 | 143649 | 2020-05-14 | Clay | Missouri | 29047 | 111 | 1 |
140654 | 140654 | 2020-05-13 | Clay | Missouri | 29047 | 106 | 1 |
137660 | 137660 | 2020-05-12 | Clay | Missouri | 29047 | 102 | 1 |
134670 | 134670 | 2020-05-11 | Clay | Missouri | 29047 | 101 | 1 |
131679 | 131679 | 2020-05-10 | Clay | Missouri | 29047 | 96 | 1 |
128689 | 128689 | 2020-05-09 | Clay | Missouri | 29047 | 96 | 1 |
125702 | 125702 | 2020-05-08 | Clay | Missouri | 29047 | 96 | 1 |
122720 | 122720 | 2020-05-07 | Clay | Missouri | 29047 | 91 | 1 |
119746 | 119746 | 2020-05-06 | Clay | Missouri | 29047 | 88 | 1 |
116786 | 116786 | 2020-05-05 | Clay | Missouri | 29047 | 86 | 1 |
113904 | 113904 | 2020-05-04 | Clay | Missouri | 29047 | 81 | 1 |
111025 | 111025 | 2020-05-03 | Clay | Missouri | 29047 | 77 | 1 |
108154 | 108154 | 2020-05-02 | Clay | Missouri | 29047 | 77 | 1 |
105289 | 105289 | 2020-05-01 | Clay | Missouri | 29047 | 77 | 1 |
102428 | 102428 | 2020-04-30 | Clay | Missouri | 29047 | 70 | 1 |
99576 | 99576 | 2020-04-29 | Clay | Missouri | 29047 | 69 | 1 |
96730 | 96730 | 2020-04-28 | Clay | Missouri | 29047 | 69 | 1 |
93894 | 93894 | 2020-04-27 | Clay | Missouri | 29047 | 68 | 1 |
91073 | 91073 | 2020-04-26 | Clay | Missouri | 29047 | 67 | 1 |
88257 | 88257 | 2020-04-25 | Clay | Missouri | 29047 | 65 | 1 |
85447 | 85447 | 2020-04-24 | Clay | Missouri | 29047 | 63 | 1 |
82643 | 82643 | 2020-04-23 | Clay | Missouri | 29047 | 62 | 1 |
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);