ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
99 rows where deaths = 113 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2305857 | 2305857 | 2022-03-14 | Pulaski | Missouri | 29169 | 8778 | 113 |
2302606 | 2302606 | 2022-03-13 | Pulaski | Missouri | 29169 | 8777 | 113 |
2299354 | 2299354 | 2022-03-12 | Pulaski | Missouri | 29169 | 8777 | 113 |
2296102 | 2296102 | 2022-03-11 | Pulaski | Missouri | 29169 | 8777 | 113 |
2292850 | 2292850 | 2022-03-10 | Pulaski | Missouri | 29169 | 8794 | 113 |
2289598 | 2289598 | 2022-03-09 | Pulaski | Missouri | 29169 | 8793 | 113 |
2286346 | 2286346 | 2022-03-08 | Pulaski | Missouri | 29169 | 8789 | 113 |
2263517 | 2263517 | 2022-03-01 | Clinton | Missouri | 29049 | 4697 | 113 |
2260306 | 2260306 | 2022-02-28 | Marion | Missouri | 29127 | 7916 | 113 |
2257055 | 2257055 | 2022-02-27 | Marion | Missouri | 29127 | 7849 | 113 |
2253804 | 2253804 | 2022-02-26 | Marion | Missouri | 29127 | 7849 | 113 |
2250553 | 2250553 | 2022-02-25 | Marion | Missouri | 29127 | 7849 | 113 |
2247302 | 2247302 | 2022-02-24 | Marion | Missouri | 29127 | 7837 | 113 |
2244051 | 2244051 | 2022-02-23 | Marion | Missouri | 29127 | 7833 | 113 |
2244054 | 2244054 | 2022-02-23 | Miller | Missouri | 29131 | 6044 | 113 |
2240800 | 2240800 | 2022-02-22 | Marion | Missouri | 29127 | 7829 | 113 |
2240803 | 2240803 | 2022-02-22 | Miller | Missouri | 29131 | 6036 | 113 |
2237549 | 2237549 | 2022-02-21 | Marion | Missouri | 29127 | 7824 | 113 |
2237552 | 2237552 | 2022-02-21 | Miller | Missouri | 29131 | 6023 | 113 |
2234298 | 2234298 | 2022-02-20 | Marion | Missouri | 29127 | 7824 | 113 |
2234301 | 2234301 | 2022-02-20 | Miller | Missouri | 29131 | 6023 | 113 |
2231047 | 2231047 | 2022-02-19 | Marion | Missouri | 29127 | 7824 | 113 |
2231050 | 2231050 | 2022-02-19 | Miller | Missouri | 29131 | 6023 | 113 |
2227796 | 2227796 | 2022-02-18 | Marion | Missouri | 29127 | 7824 | 113 |
2227799 | 2227799 | 2022-02-18 | Miller | Missouri | 29131 | 6023 | 113 |
2224545 | 2224545 | 2022-02-17 | Marion | Missouri | 29127 | 7824 | 113 |
2224548 | 2224548 | 2022-02-17 | Miller | Missouri | 29131 | 6021 | 113 |
2221294 | 2221294 | 2022-02-16 | Marion | Missouri | 29127 | 7819 | 113 |
2221297 | 2221297 | 2022-02-16 | Miller | Missouri | 29131 | 6014 | 113 |
2218043 | 2218043 | 2022-02-15 | Marion | Missouri | 29127 | 7812 | 113 |
2218046 | 2218046 | 2022-02-15 | Miller | Missouri | 29131 | 6003 | 113 |
2192010 | 2192010 | 2022-02-07 | Lafayette | Missouri | 29107 | 7535 | 113 |
2188757 | 2188757 | 2022-02-06 | Lafayette | Missouri | 29107 | 7531 | 113 |
2185504 | 2185504 | 2022-02-05 | Lafayette | Missouri | 29107 | 7517 | 113 |
2058659 | 2058659 | 2021-12-28 | Johnson | Missouri | 29101 | 8560 | 113 |
2055410 | 2055410 | 2021-12-27 | Johnson | Missouri | 29101 | 8547 | 113 |
2052160 | 2052160 | 2021-12-26 | Johnson | Missouri | 29101 | 8479 | 113 |
2048910 | 2048910 | 2021-12-25 | Johnson | Missouri | 29101 | 8479 | 113 |
2045660 | 2045660 | 2021-12-24 | Johnson | Missouri | 29101 | 8479 | 113 |
2042410 | 2042410 | 2021-12-23 | Johnson | Missouri | 29101 | 8479 | 113 |
2039161 | 2039161 | 2021-12-22 | Johnson | Missouri | 29101 | 8412 | 113 |
2035911 | 2035911 | 2021-12-21 | Johnson | Missouri | 29101 | 8378 | 113 |
1853950 | 1853950 | 2021-10-26 | Scott | Missouri | 29201 | 7151 | 113 |
1850701 | 1850701 | 2021-10-25 | Scott | Missouri | 29201 | 7147 | 113 |
1847451 | 1847451 | 2021-10-24 | Scott | Missouri | 29201 | 7146 | 113 |
1844201 | 1844201 | 2021-10-23 | Scott | Missouri | 29201 | 7145 | 113 |
1840951 | 1840951 | 2021-10-22 | Scott | Missouri | 29201 | 7137 | 113 |
1837702 | 1837702 | 2021-10-21 | Scott | Missouri | 29201 | 7132 | 113 |
1834453 | 1834453 | 2021-10-20 | Scott | Missouri | 29201 | 7126 | 113 |
1736960 | 1736960 | 2021-09-20 | Newton | Missouri | 29145 | 7500 | 113 |
1733710 | 1733710 | 2021-09-19 | Newton | Missouri | 29145 | 7499 | 113 |
1730460 | 1730460 | 2021-09-18 | Newton | Missouri | 29145 | 7494 | 113 |
1727210 | 1727210 | 2021-09-17 | Newton | Missouri | 29145 | 7489 | 113 |
1723961 | 1723961 | 2021-09-16 | Newton | Missouri | 29145 | 7479 | 113 |
1720712 | 1720712 | 2021-09-15 | Newton | Missouri | 29145 | 7463 | 113 |
1717464 | 1717464 | 2021-09-14 | Newton | Missouri | 29145 | 7451 | 113 |
1600558 | 1600558 | 2021-08-09 | Taney | Missouri | 29213 | 7836 | 113 |
1597310 | 1597310 | 2021-08-08 | Taney | Missouri | 29213 | 7817 | 113 |
1594061 | 1594061 | 2021-08-07 | Taney | Missouri | 29213 | 7791 | 113 |
1590812 | 1590812 | 2021-08-06 | Taney | Missouri | 29213 | 7762 | 113 |
1587563 | 1587563 | 2021-08-05 | Taney | Missouri | 29213 | 7733 | 113 |
1584312 | 1584312 | 2021-08-04 | Taney | Missouri | 29213 | 7684 | 113 |
1509561 | 1509561 | 2021-07-12 | Joplin | Missouri | 7007 | 113 | |
1506315 | 1506315 | 2021-07-11 | Joplin | Missouri | 7005 | 113 | |
1503069 | 1503069 | 2021-07-10 | Joplin | Missouri | 6984 | 113 | |
1499823 | 1499823 | 2021-07-09 | Joplin | Missouri | 6964 | 113 | |
1496577 | 1496577 | 2021-07-08 | Joplin | Missouri | 6934 | 113 | |
1493330 | 1493330 | 2021-07-07 | Joplin | Missouri | 6864 | 113 | |
1376453 | 1376453 | 2021-06-01 | Cass | Missouri | 29037 | 9275 | 113 |
1373207 | 1373207 | 2021-05-31 | Cass | Missouri | 29037 | 9269 | 113 |
1369962 | 1369962 | 2021-05-30 | Cass | Missouri | 29037 | 9268 | 113 |
1366716 | 1366716 | 2021-05-29 | Cass | Missouri | 29037 | 9265 | 113 |
1363470 | 1363470 | 2021-05-28 | Cass | Missouri | 29037 | 9259 | 113 |
1360223 | 1360223 | 2021-05-27 | Cass | Missouri | 29037 | 9244 | 113 |
1356977 | 1356977 | 2021-05-26 | Cass | Missouri | 29037 | 9231 | 113 |
1353731 | 1353731 | 2021-05-25 | Cass | Missouri | 29037 | 9224 | 113 |
918712 | 918712 | 2021-01-11 | Clay | Missouri | 29047 | 7872 | 113 |
915467 | 915467 | 2021-01-10 | Clay | Missouri | 29047 | 7671 | 113 |
912222 | 912222 | 2021-01-09 | Clay | Missouri | 29047 | 7671 | 113 |
908977 | 908977 | 2021-01-08 | Clay | Missouri | 29047 | 7671 | 113 |
896008 | 896008 | 2021-01-04 | Franklin | Missouri | 29071 | 6819 | 113 |
892761 | 892761 | 2021-01-03 | Franklin | Missouri | 29071 | 6819 | 113 |
889515 | 889515 | 2021-01-02 | Franklin | Missouri | 29071 | 6708 | 113 |
886269 | 886269 | 2021-01-01 | Franklin | Missouri | 29071 | 6656 | 113 |
883024 | 883024 | 2020-12-31 | Franklin | Missouri | 29071 | 6556 | 113 |
879779 | 879779 | 2020-12-30 | Franklin | Missouri | 29071 | 6466 | 113 |
876534 | 876534 | 2020-12-29 | Franklin | Missouri | 29071 | 6408 | 113 |
827868 | 827868 | 2020-12-14 | Jefferson | Missouri | 29099 | 14623 | 113 |
824621 | 824621 | 2020-12-13 | Jefferson | Missouri | 29099 | 14169 | 113 |
821375 | 821375 | 2020-12-12 | Jefferson | Missouri | 29099 | 14169 | 113 |
818129 | 818129 | 2020-12-11 | Jefferson | Missouri | 29099 | 14169 | 113 |
814883 | 814883 | 2020-12-10 | Jefferson | Missouri | 29099 | 14011 | 113 |
636428 | 636428 | 2020-10-16 | Jackson | Missouri | 29095 | 9062 | 113 |
633182 | 633182 | 2020-10-15 | Jackson | Missouri | 29095 | 8977 | 113 |
623442 | 623442 | 2020-10-12 | Greene | Missouri | 29077 | 8380 | 113 |
613725 | 613725 | 2020-10-09 | Jackson | Missouri | 29095 | 8069 | 113 |
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 |
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);