ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
43 rows where cases = 540 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2078178 | 2078178 | 2022-01-03 | Mercer | Missouri | 29129 | 540 | 10 |
1649264 | 1649264 | 2021-08-24 | Putnam | Missouri | 29171 | 540 | 5 |
1646015 | 1646015 | 2021-08-23 | Putnam | Missouri | 29171 | 540 | 5 |
1642766 | 1642766 | 2021-08-22 | Putnam | Missouri | 29171 | 540 | 5 |
1269316 | 1269316 | 2021-04-29 | Carter | Missouri | 29035 | 540 | 10 |
1266069 | 1266069 | 2021-04-28 | Carter | Missouri | 29035 | 540 | 10 |
1262822 | 1262822 | 2021-04-27 | Carter | Missouri | 29035 | 540 | 10 |
1259575 | 1259575 | 2021-04-26 | Carter | Missouri | 29035 | 540 | 10 |
1256328 | 1256328 | 2021-04-25 | Carter | Missouri | 29035 | 540 | 10 |
1253081 | 1253081 | 2021-04-24 | Carter | Missouri | 29035 | 540 | 10 |
1249834 | 1249834 | 2021-04-23 | Carter | Missouri | 29035 | 540 | 10 |
1246587 | 1246587 | 2021-04-22 | Carter | Missouri | 29035 | 540 | 10 |
1152405 | 1152405 | 2021-03-24 | Carter | Missouri | 29035 | 540 | 9 |
1149158 | 1149158 | 2021-03-23 | Carter | Missouri | 29035 | 540 | 9 |
1097259 | 1097259 | 2021-03-07 | Maries | Missouri | 29125 | 540 | 7 |
1061554 | 1061554 | 2021-02-24 | Linn | Missouri | 29115 | 540 | 12 |
1058308 | 1058308 | 2021-02-23 | Linn | Missouri | 29115 | 540 | 12 |
1055062 | 1055062 | 2021-02-22 | Linn | Missouri | 29115 | 540 | 11 |
1051815 | 1051815 | 2021-02-21 | Linn | Missouri | 29115 | 540 | 11 |
1048568 | 1048568 | 2021-02-20 | Linn | Missouri | 29115 | 540 | 11 |
1045322 | 1045322 | 2021-02-19 | Linn | Missouri | 29115 | 540 | 11 |
1042077 | 1042077 | 2021-02-18 | Linn | Missouri | 29115 | 540 | 11 |
1038832 | 1038832 | 2021-02-17 | Linn | Missouri | 29115 | 540 | 11 |
1035587 | 1035587 | 2021-02-16 | Linn | Missouri | 29115 | 540 | 11 |
1006396 | 1006396 | 2021-02-07 | Ozark | Missouri | 29153 | 540 | 11 |
954418 | 954418 | 2021-01-22 | Daviess | Missouri | 29061 | 540 | 10 |
928496 | 928496 | 2021-01-14 | Montgomery | Missouri | 29139 | 540 | 9 |
850567 | 850567 | 2020-12-21 | Dade | Missouri | 29057 | 540 | 29 |
811625 | 811625 | 2020-12-09 | Gasconade | Missouri | 29073 | 540 | 27 |
805143 | 805143 | 2020-12-07 | Howard | Missouri | 29089 | 540 | 2 |
805212 | 805212 | 2020-12-07 | Wayne | Missouri | 29223 | 540 | 3 |
798648 | 798648 | 2020-12-05 | Grundy | Missouri | 29079 | 540 | 14 |
775900 | 775900 | 2020-11-28 | Bates | Missouri | 29013 | 540 | 9 |
733789 | 733789 | 2020-11-15 | Ray | Missouri | 29177 | 540 | 2 |
730544 | 730544 | 2020-11-14 | Ray | Missouri | 29177 | 540 | 2 |
720793 | 720793 | 2020-11-11 | Mississippi | Missouri | 29133 | 540 | 6 |
685071 | 685071 | 2020-10-31 | Clinton | Missouri | 29049 | 540 | 24 |
603955 | 603955 | 2020-10-06 | Barry | Missouri | 29009 | 540 | 6 |
587848 | 587848 | 2020-10-01 | Stoddard | Missouri | 29207 | 540 | 14 |
374578 | 374578 | 2020-07-27 | Cape Girardeau | Missouri | 29031 | 540 | 3 |
317093 | 317093 | 2020-07-09 | Newton | Missouri | 29145 | 540 | 2 |
291749 | 291749 | 2020-07-01 | Jefferson | Missouri | 29099 | 540 | 23 |
183022 | 183022 | 2020-05-27 | Jackson | Missouri | 29095 | 540 | 16 |
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);