ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
26 rows where cases = 1234 and state = "Missouri" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2013126 | 2013126 | 2021-12-14 | Chariton | Missouri | 29041 | 1234 | 31 |
1961140 | 1961140 | 2021-11-28 | Hickory | Missouri | 29085 | 1234 | 43 |
1957889 | 1957889 | 2021-11-27 | Hickory | Missouri | 29085 | 1234 | 43 |
1954638 | 1954638 | 2021-11-26 | Hickory | Missouri | 29085 | 1234 | 43 |
1951387 | 1951387 | 2021-11-25 | Hickory | Missouri | 29085 | 1234 | 43 |
1948136 | 1948136 | 2021-11-24 | Hickory | Missouri | 29085 | 1234 | 43 |
1886451 | 1886451 | 2021-11-05 | Sullivan | Missouri | 29211 | 1234 | 15 |
1883202 | 1883202 | 2021-11-04 | Sullivan | Missouri | 29211 | 1234 | 15 |
1879953 | 1879953 | 2021-11-03 | Sullivan | Missouri | 29211 | 1234 | 15 |
1808466 | 1808466 | 2021-10-12 | St. Clair | Missouri | 29185 | 1234 | 14 |
1720708 | 1720708 | 2021-09-15 | Monroe | Missouri | 29137 | 1234 | 12 |
1577737 | 1577737 | 2021-08-02 | DeKalb | Missouri | 29063 | 1234 | 33 |
1574489 | 1574489 | 2021-08-01 | DeKalb | Missouri | 29063 | 1234 | 33 |
1567994 | 1567994 | 2021-07-30 | Dent | Missouri | 29065 | 1234 | 19 |
1236858 | 1236858 | 2021-04-19 | Dallas | Missouri | 29059 | 1234 | 26 |
1233611 | 1233611 | 2021-04-18 | Dallas | Missouri | 29059 | 1234 | 26 |
1230363 | 1230363 | 2021-04-17 | Dallas | Missouri | 29059 | 1234 | 26 |
1009633 | 1009633 | 2021-02-08 | Mississippi | Missouri | 29133 | 1234 | 22 |
1006386 | 1006386 | 2021-02-07 | Mississippi | Missouri | 29133 | 1234 | 22 |
922044 | 922044 | 2021-01-12 | Vernon | Missouri | 29217 | 1234 | 29 |
737000 | 737000 | 2020-11-16 | Lafayette | Missouri | 29107 | 1234 | 27 |
604032 | 604032 | 2020-10-06 | Pettis | Missouri | 29159 | 1234 | 21 |
600790 | 600790 | 2020-10-05 | Pettis | Missouri | 29159 | 1234 | 21 |
461555 | 461555 | 2020-08-23 | Buchanan | Missouri | 29021 | 1234 | 10 |
458328 | 458328 | 2020-08-22 | Buchanan | Missouri | 29021 | 1234 | 10 |
455100 | 455100 | 2020-08-21 | Buchanan | Missouri | 29021 | 1234 | 10 |
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);