ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 29183 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
536015 | 536015 | 2020-09-15 | St. Charles | Missouri | 29183 | 6924 | 123 |
532780 | 532780 | 2020-09-14 | St. Charles | Missouri | 29183 | 6840 | 123 |
529544 | 529544 | 2020-09-13 | St. Charles | Missouri | 29183 | 6702 | 123 |
526308 | 526308 | 2020-09-12 | St. Charles | Missouri | 29183 | 6660 | 117 |
523072 | 523072 | 2020-09-11 | St. Charles | Missouri | 29183 | 6570 | 114 |
519835 | 519835 | 2020-09-10 | St. Charles | Missouri | 29183 | 6486 | 113 |
516600 | 516600 | 2020-09-09 | St. Charles | Missouri | 29183 | 6393 | 113 |
513366 | 513366 | 2020-09-08 | St. Charles | Missouri | 29183 | 6319 | 113 |
510134 | 510134 | 2020-09-07 | St. Charles | Missouri | 29183 | 6229 | 112 |
506901 | 506901 | 2020-09-06 | St. Charles | Missouri | 29183 | 6146 | 112 |
503668 | 503668 | 2020-09-05 | St. Charles | Missouri | 29183 | 6076 | 112 |
500434 | 500434 | 2020-09-04 | St. Charles | Missouri | 29183 | 6002 | 112 |
497200 | 497200 | 2020-09-03 | St. Charles | Missouri | 29183 | 5976 | 112 |
493967 | 493967 | 2020-09-02 | St. Charles | Missouri | 29183 | 5903 | 112 |
490733 | 490733 | 2020-09-01 | St. Charles | Missouri | 29183 | 5843 | 112 |
487500 | 487500 | 2020-08-31 | St. Charles | Missouri | 29183 | 5771 | 108 |
484266 | 484266 | 2020-08-30 | St. Charles | Missouri | 29183 | 5693 | 108 |
481031 | 481031 | 2020-08-29 | St. Charles | Missouri | 29183 | 5643 | 108 |
477799 | 477799 | 2020-08-28 | St. Charles | Missouri | 29183 | 5561 | 108 |
474566 | 474566 | 2020-08-27 | St. Charles | Missouri | 29183 | 5491 | 108 |
471334 | 471334 | 2020-08-26 | St. Charles | Missouri | 29183 | 5431 | 106 |
468104 | 468104 | 2020-08-25 | St. Charles | Missouri | 29183 | 5338 | 106 |
464875 | 464875 | 2020-08-24 | St. Charles | Missouri | 29183 | 5296 | 106 |
461644 | 461644 | 2020-08-23 | St. Charles | Missouri | 29183 | 5219 | 105 |
458417 | 458417 | 2020-08-22 | St. Charles | Missouri | 29183 | 5159 | 105 |
455189 | 455189 | 2020-08-21 | St. Charles | Missouri | 29183 | 5086 | 105 |
451961 | 451961 | 2020-08-20 | St. Charles | Missouri | 29183 | 5052 | 105 |
448733 | 448733 | 2020-08-19 | St. Charles | Missouri | 29183 | 4961 | 105 |
445507 | 445507 | 2020-08-18 | St. Charles | Missouri | 29183 | 4877 | 105 |
442281 | 442281 | 2020-08-17 | St. Charles | Missouri | 29183 | 4760 | 105 |
439054 | 439054 | 2020-08-16 | St. Charles | Missouri | 29183 | 4649 | 104 |
435829 | 435829 | 2020-08-15 | St. Charles | Missouri | 29183 | 4610 | 104 |
432603 | 432603 | 2020-08-14 | St. Charles | Missouri | 29183 | 4520 | 104 |
429376 | 429376 | 2020-08-13 | St. Charles | Missouri | 29183 | 4449 | 104 |
426152 | 426152 | 2020-08-12 | St. Charles | Missouri | 29183 | 4316 | 104 |
422930 | 422930 | 2020-08-11 | St. Charles | Missouri | 29183 | 4258 | 104 |
419708 | 419708 | 2020-08-10 | St. Charles | Missouri | 29183 | 4168 | 103 |
416487 | 416487 | 2020-08-09 | St. Charles | Missouri | 29183 | 4110 | 103 |
413267 | 413267 | 2020-08-08 | St. Charles | Missouri | 29183 | 4085 | 103 |
410047 | 410047 | 2020-08-07 | St. Charles | Missouri | 29183 | 4036 | 102 |
406827 | 406827 | 2020-08-06 | St. Charles | Missouri | 29183 | 3978 | 101 |
403609 | 403609 | 2020-08-05 | St. Charles | Missouri | 29183 | 3857 | 100 |
400392 | 400392 | 2020-08-04 | St. Charles | Missouri | 29183 | 3857 | 100 |
397178 | 397178 | 2020-08-03 | St. Charles | Missouri | 29183 | 3702 | 99 |
393962 | 393962 | 2020-08-02 | St. Charles | Missouri | 29183 | 3679 | 97 |
390745 | 390745 | 2020-08-01 | St. Charles | Missouri | 29183 | 3590 | 97 |
387528 | 387528 | 2020-07-31 | St. Charles | Missouri | 29183 | 3543 | 96 |
384310 | 384310 | 2020-07-30 | St. Charles | Missouri | 29183 | 3456 | 96 |
381094 | 381094 | 2020-07-29 | St. Charles | Missouri | 29183 | 3360 | 93 |
377877 | 377877 | 2020-07-28 | St. Charles | Missouri | 29183 | 3263 | 93 |
374662 | 374662 | 2020-07-27 | St. Charles | Missouri | 29183 | 3134 | 90 |
371450 | 371450 | 2020-07-26 | St. Charles | Missouri | 29183 | 2998 | 86 |
368239 | 368239 | 2020-07-25 | St. Charles | Missouri | 29183 | 2866 | 86 |
365031 | 365031 | 2020-07-24 | St. Charles | Missouri | 29183 | 2843 | 86 |
361824 | 361824 | 2020-07-23 | St. Charles | Missouri | 29183 | 2761 | 85 |
358619 | 358619 | 2020-07-22 | St. Charles | Missouri | 29183 | 2693 | 84 |
355416 | 355416 | 2020-07-21 | St. Charles | Missouri | 29183 | 2612 | 81 |
352214 | 352214 | 2020-07-20 | St. Charles | Missouri | 29183 | 2468 | 81 |
349014 | 349014 | 2020-07-19 | St. Charles | Missouri | 29183 | 2296 | 80 |
345813 | 345813 | 2020-07-18 | St. Charles | Missouri | 29183 | 2223 | 80 |
342613 | 342613 | 2020-07-17 | St. Charles | Missouri | 29183 | 2137 | 80 |
339417 | 339417 | 2020-07-16 | St. Charles | Missouri | 29183 | 2070 | 80 |
336221 | 336221 | 2020-07-15 | St. Charles | Missouri | 29183 | 1988 | 80 |
333028 | 333028 | 2020-07-14 | St. Charles | Missouri | 29183 | 1882 | 80 |
329841 | 329841 | 2020-07-13 | St. Charles | Missouri | 29183 | 1760 | 80 |
326655 | 326655 | 2020-07-12 | St. Charles | Missouri | 29183 | 1691 | 77 |
323472 | 323472 | 2020-07-11 | St. Charles | Missouri | 29183 | 1599 | 77 |
320293 | 320293 | 2020-07-10 | St. Charles | Missouri | 29183 | 1526 | 77 |
317118 | 317118 | 2020-07-09 | St. Charles | Missouri | 29183 | 1456 | 77 |
313944 | 313944 | 2020-07-08 | St. Charles | Missouri | 29183 | 1355 | 77 |
310773 | 310773 | 2020-07-07 | St. Charles | Missouri | 29183 | 1288 | 77 |
307605 | 307605 | 2020-07-06 | St. Charles | Missouri | 29183 | 1239 | 77 |
304438 | 304438 | 2020-07-05 | St. Charles | Missouri | 29183 | 1204 | 76 |
301274 | 301274 | 2020-07-04 | St. Charles | Missouri | 29183 | 1183 | 76 |
298111 | 298111 | 2020-07-03 | St. Charles | Missouri | 29183 | 1163 | 76 |
294953 | 294953 | 2020-07-02 | St. Charles | Missouri | 29183 | 1135 | 76 |
291799 | 291799 | 2020-07-01 | St. Charles | Missouri | 29183 | 1095 | 76 |
288648 | 288648 | 2020-06-30 | St. Charles | Missouri | 29183 | 1078 | 74 |
285498 | 285498 | 2020-06-29 | St. Charles | Missouri | 29183 | 1073 | 74 |
282353 | 282353 | 2020-06-28 | St. Charles | Missouri | 29183 | 1045 | 73 |
279205 | 279205 | 2020-06-27 | St. Charles | Missouri | 29183 | 1020 | 73 |
276057 | 276057 | 2020-06-26 | St. Charles | Missouri | 29183 | 1020 | 73 |
272914 | 272914 | 2020-06-25 | St. Charles | Missouri | 29183 | 1011 | 73 |
269775 | 269775 | 2020-06-24 | St. Charles | Missouri | 29183 | 997 | 73 |
266642 | 266642 | 2020-06-23 | St. Charles | Missouri | 29183 | 974 | 73 |
263516 | 263516 | 2020-06-22 | St. Charles | Missouri | 29183 | 959 | 72 |
260388 | 260388 | 2020-06-21 | St. Charles | Missouri | 29183 | 954 | 72 |
257262 | 257262 | 2020-06-20 | St. Charles | Missouri | 29183 | 951 | 72 |
254141 | 254141 | 2020-06-19 | St. Charles | Missouri | 29183 | 945 | 72 |
251026 | 251026 | 2020-06-18 | St. Charles | Missouri | 29183 | 939 | 72 |
247913 | 247913 | 2020-06-17 | St. Charles | Missouri | 29183 | 934 | 67 |
244800 | 244800 | 2020-06-16 | St. Charles | Missouri | 29183 | 924 | 67 |
241689 | 241689 | 2020-06-15 | St. Charles | Missouri | 29183 | 918 | 67 |
238579 | 238579 | 2020-06-14 | St. Charles | Missouri | 29183 | 909 | 67 |
235472 | 235472 | 2020-06-13 | St. Charles | Missouri | 29183 | 895 | 67 |
232366 | 232366 | 2020-06-12 | St. Charles | Missouri | 29183 | 888 | 64 |
229262 | 229262 | 2020-06-11 | St. Charles | Missouri | 29183 | 879 | 63 |
226159 | 226159 | 2020-06-10 | St. Charles | Missouri | 29183 | 879 | 63 |
223060 | 223060 | 2020-06-09 | St. Charles | Missouri | 29183 | 867 | 63 |
219965 | 219965 | 2020-06-08 | St. Charles | Missouri | 29183 | 851 | 63 |
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);