ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Bates" and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535922 | 535922 | 2020-09-15 | Bates | Missouri | 29013 | 84 | 1 |
532687 | 532687 | 2020-09-14 | Bates | Missouri | 29013 | 83 | 1 |
529451 | 529451 | 2020-09-13 | Bates | Missouri | 29013 | 82 | 1 |
526215 | 526215 | 2020-09-12 | Bates | Missouri | 29013 | 82 | 1 |
522979 | 522979 | 2020-09-11 | Bates | Missouri | 29013 | 81 | 1 |
519742 | 519742 | 2020-09-10 | Bates | Missouri | 29013 | 80 | 1 |
516507 | 516507 | 2020-09-09 | Bates | Missouri | 29013 | 80 | 1 |
513273 | 513273 | 2020-09-08 | Bates | Missouri | 29013 | 80 | 1 |
510041 | 510041 | 2020-09-07 | Bates | Missouri | 29013 | 78 | 1 |
506808 | 506808 | 2020-09-06 | Bates | Missouri | 29013 | 78 | 1 |
503575 | 503575 | 2020-09-05 | Bates | Missouri | 29013 | 78 | 1 |
500341 | 500341 | 2020-09-04 | Bates | Missouri | 29013 | 76 | 1 |
497107 | 497107 | 2020-09-03 | Bates | Missouri | 29013 | 78 | 1 |
493874 | 493874 | 2020-09-02 | Bates | Missouri | 29013 | 77 | 1 |
490640 | 490640 | 2020-09-01 | Bates | Missouri | 29013 | 77 | 1 |
487407 | 487407 | 2020-08-31 | Bates | Missouri | 29013 | 77 | 1 |
484173 | 484173 | 2020-08-30 | Bates | Missouri | 29013 | 72 | 1 |
480938 | 480938 | 2020-08-29 | Bates | Missouri | 29013 | 70 | 1 |
477706 | 477706 | 2020-08-28 | Bates | Missouri | 29013 | 66 | 1 |
474473 | 474473 | 2020-08-27 | Bates | Missouri | 29013 | 65 | 1 |
471241 | 471241 | 2020-08-26 | Bates | Missouri | 29013 | 62 | 1 |
468011 | 468011 | 2020-08-25 | Bates | Missouri | 29013 | 62 | 1 |
464782 | 464782 | 2020-08-24 | Bates | Missouri | 29013 | 61 | 1 |
461551 | 461551 | 2020-08-23 | Bates | Missouri | 29013 | 60 | 1 |
458324 | 458324 | 2020-08-22 | Bates | Missouri | 29013 | 60 | 1 |
455096 | 455096 | 2020-08-21 | Bates | Missouri | 29013 | 57 | 1 |
451868 | 451868 | 2020-08-20 | Bates | Missouri | 29013 | 56 | 1 |
448640 | 448640 | 2020-08-19 | Bates | Missouri | 29013 | 56 | 1 |
445414 | 445414 | 2020-08-18 | Bates | Missouri | 29013 | 55 | 1 |
442188 | 442188 | 2020-08-17 | Bates | Missouri | 29013 | 54 | 1 |
438961 | 438961 | 2020-08-16 | Bates | Missouri | 29013 | 54 | 1 |
435736 | 435736 | 2020-08-15 | Bates | Missouri | 29013 | 54 | 1 |
432510 | 432510 | 2020-08-14 | Bates | Missouri | 29013 | 54 | 1 |
429283 | 429283 | 2020-08-13 | Bates | Missouri | 29013 | 52 | 1 |
426059 | 426059 | 2020-08-12 | Bates | Missouri | 29013 | 51 | 1 |
422837 | 422837 | 2020-08-11 | Bates | Missouri | 29013 | 48 | 1 |
419615 | 419615 | 2020-08-10 | Bates | Missouri | 29013 | 48 | 1 |
416394 | 416394 | 2020-08-09 | Bates | Missouri | 29013 | 47 | 1 |
413174 | 413174 | 2020-08-08 | Bates | Missouri | 29013 | 44 | 1 |
409954 | 409954 | 2020-08-07 | Bates | Missouri | 29013 | 44 | 1 |
406734 | 406734 | 2020-08-06 | Bates | Missouri | 29013 | 44 | 1 |
403516 | 403516 | 2020-08-05 | Bates | Missouri | 29013 | 42 | 1 |
400299 | 400299 | 2020-08-04 | Bates | Missouri | 29013 | 40 | 1 |
397085 | 397085 | 2020-08-03 | Bates | Missouri | 29013 | 40 | 1 |
393869 | 393869 | 2020-08-02 | Bates | Missouri | 29013 | 39 | 1 |
390652 | 390652 | 2020-08-01 | Bates | Missouri | 29013 | 39 | 1 |
387435 | 387435 | 2020-07-31 | Bates | Missouri | 29013 | 36 | 1 |
384217 | 384217 | 2020-07-30 | Bates | Missouri | 29013 | 34 | 1 |
381001 | 381001 | 2020-07-29 | Bates | Missouri | 29013 | 32 | 1 |
377784 | 377784 | 2020-07-28 | Bates | Missouri | 29013 | 32 | 1 |
374569 | 374569 | 2020-07-27 | Bates | Missouri | 29013 | 32 | 1 |
371357 | 371357 | 2020-07-26 | Bates | Missouri | 29013 | 29 | 1 |
368146 | 368146 | 2020-07-25 | Bates | Missouri | 29013 | 29 | 1 |
364938 | 364938 | 2020-07-24 | Bates | Missouri | 29013 | 28 | 1 |
361731 | 361731 | 2020-07-23 | Bates | Missouri | 29013 | 24 | 1 |
358526 | 358526 | 2020-07-22 | Bates | Missouri | 29013 | 24 | 1 |
355323 | 355323 | 2020-07-21 | Bates | Missouri | 29013 | 20 | 1 |
352121 | 352121 | 2020-07-20 | Bates | Missouri | 29013 | 19 | 1 |
348921 | 348921 | 2020-07-19 | Bates | Missouri | 29013 | 18 | 1 |
345720 | 345720 | 2020-07-18 | Bates | Missouri | 29013 | 17 | 1 |
342520 | 342520 | 2020-07-17 | Bates | Missouri | 29013 | 17 | 1 |
339324 | 339324 | 2020-07-16 | Bates | Missouri | 29013 | 17 | 1 |
336128 | 336128 | 2020-07-15 | Bates | Missouri | 29013 | 16 | 1 |
332935 | 332935 | 2020-07-14 | Bates | Missouri | 29013 | 16 | 1 |
329748 | 329748 | 2020-07-13 | Bates | Missouri | 29013 | 14 | 1 |
326562 | 326562 | 2020-07-12 | Bates | Missouri | 29013 | 13 | 1 |
323379 | 323379 | 2020-07-11 | Bates | Missouri | 29013 | 13 | 1 |
320200 | 320200 | 2020-07-10 | Bates | Missouri | 29013 | 13 | 1 |
317025 | 317025 | 2020-07-09 | Bates | Missouri | 29013 | 12 | 1 |
313851 | 313851 | 2020-07-08 | Bates | Missouri | 29013 | 12 | 1 |
310681 | 310681 | 2020-07-07 | Bates | Missouri | 29013 | 12 | 1 |
307513 | 307513 | 2020-07-06 | Bates | Missouri | 29013 | 12 | 1 |
304346 | 304346 | 2020-07-05 | Bates | Missouri | 29013 | 12 | 1 |
301182 | 301182 | 2020-07-04 | Bates | Missouri | 29013 | 12 | 1 |
298019 | 298019 | 2020-07-03 | Bates | Missouri | 29013 | 12 | 1 |
294861 | 294861 | 2020-07-02 | Bates | Missouri | 29013 | 12 | 1 |
291707 | 291707 | 2020-07-01 | Bates | Missouri | 29013 | 12 | 1 |
288556 | 288556 | 2020-06-30 | Bates | Missouri | 29013 | 12 | 1 |
285406 | 285406 | 2020-06-29 | Bates | Missouri | 29013 | 12 | 1 |
282261 | 282261 | 2020-06-28 | Bates | Missouri | 29013 | 12 | 1 |
279113 | 279113 | 2020-06-27 | Bates | Missouri | 29013 | 12 | 1 |
275965 | 275965 | 2020-06-26 | Bates | Missouri | 29013 | 12 | 1 |
272822 | 272822 | 2020-06-25 | Bates | Missouri | 29013 | 12 | 1 |
269684 | 269684 | 2020-06-24 | Bates | Missouri | 29013 | 12 | 1 |
266551 | 266551 | 2020-06-23 | Bates | Missouri | 29013 | 12 | 1 |
263425 | 263425 | 2020-06-22 | Bates | Missouri | 29013 | 12 | 1 |
260297 | 260297 | 2020-06-21 | Bates | Missouri | 29013 | 12 | 1 |
257171 | 257171 | 2020-06-20 | Bates | Missouri | 29013 | 12 | 1 |
254051 | 254051 | 2020-06-19 | Bates | Missouri | 29013 | 12 | 1 |
250936 | 250936 | 2020-06-18 | Bates | Missouri | 29013 | 12 | 1 |
247823 | 247823 | 2020-06-17 | Bates | Missouri | 29013 | 12 | 1 |
244710 | 244710 | 2020-06-16 | Bates | Missouri | 29013 | 12 | 1 |
241599 | 241599 | 2020-06-15 | Bates | Missouri | 29013 | 12 | 1 |
238490 | 238490 | 2020-06-14 | Bates | Missouri | 29013 | 12 | 1 |
235383 | 235383 | 2020-06-13 | Bates | Missouri | 29013 | 12 | 1 |
232277 | 232277 | 2020-06-12 | Bates | Missouri | 29013 | 12 | 1 |
229173 | 229173 | 2020-06-11 | Bates | Missouri | 29013 | 12 | 1 |
226070 | 226070 | 2020-06-10 | Bates | Missouri | 29013 | 12 | 1 |
222972 | 222972 | 2020-06-09 | Bates | Missouri | 29013 | 12 | 1 |
219877 | 219877 | 2020-06-08 | Bates | Missouri | 29013 | 12 | 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);