ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
27 rows where deaths = 42, fips = 30085 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
879903 | 879903 | 2020-12-30 | Roosevelt | Montana | 30085 | 1387 | 42 |
876658 | 876658 | 2020-12-29 | Roosevelt | Montana | 30085 | 1383 | 42 |
873413 | 873413 | 2020-12-28 | Roosevelt | Montana | 30085 | 1381 | 42 |
870168 | 870168 | 2020-12-27 | Roosevelt | Montana | 30085 | 1383 | 42 |
866923 | 866923 | 2020-12-26 | Roosevelt | Montana | 30085 | 1384 | 42 |
863678 | 863678 | 2020-12-25 | Roosevelt | Montana | 30085 | 1376 | 42 |
860433 | 860433 | 2020-12-24 | Roosevelt | Montana | 30085 | 1376 | 42 |
857188 | 857188 | 2020-12-23 | Roosevelt | Montana | 30085 | 1374 | 42 |
853943 | 853943 | 2020-12-22 | Roosevelt | Montana | 30085 | 1370 | 42 |
850698 | 850698 | 2020-12-21 | Roosevelt | Montana | 30085 | 1366 | 42 |
847453 | 847453 | 2020-12-20 | Roosevelt | Montana | 30085 | 1365 | 42 |
844207 | 844207 | 2020-12-19 | Roosevelt | Montana | 30085 | 1366 | 42 |
840962 | 840962 | 2020-12-18 | Roosevelt | Montana | 30085 | 1357 | 42 |
837717 | 837717 | 2020-12-17 | Roosevelt | Montana | 30085 | 1352 | 42 |
834471 | 834471 | 2020-12-16 | Roosevelt | Montana | 30085 | 1335 | 42 |
831224 | 831224 | 2020-12-15 | Roosevelt | Montana | 30085 | 1322 | 42 |
827978 | 827978 | 2020-12-14 | Roosevelt | Montana | 30085 | 1319 | 42 |
824731 | 824731 | 2020-12-13 | Roosevelt | Montana | 30085 | 1319 | 42 |
821485 | 821485 | 2020-12-12 | Roosevelt | Montana | 30085 | 1312 | 42 |
818239 | 818239 | 2020-12-11 | Roosevelt | Montana | 30085 | 1306 | 42 |
814993 | 814993 | 2020-12-10 | Roosevelt | Montana | 30085 | 1303 | 42 |
811748 | 811748 | 2020-12-09 | Roosevelt | Montana | 30085 | 1294 | 42 |
808503 | 808503 | 2020-12-08 | Roosevelt | Montana | 30085 | 1289 | 42 |
805258 | 805258 | 2020-12-07 | Roosevelt | Montana | 30085 | 1278 | 42 |
802013 | 802013 | 2020-12-06 | Roosevelt | Montana | 30085 | 1271 | 42 |
798768 | 798768 | 2020-12-05 | Roosevelt | Montana | 30085 | 1273 | 42 |
795523 | 795523 | 2020-12-04 | Roosevelt | Montana | 30085 | 1264 | 42 |
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);