ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 30081 and state = "Montana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1418782 | 1418782 | 2021-06-14 | Ravalli | Montana | 30081 | 3232 | 46 |
1415537 | 1415537 | 2021-06-13 | Ravalli | Montana | 30081 | 3224 | 46 |
1412291 | 1412291 | 2021-06-12 | Ravalli | Montana | 30081 | 3224 | 46 |
1409046 | 1409046 | 2021-06-11 | Ravalli | Montana | 30081 | 3224 | 46 |
1405801 | 1405801 | 2021-06-10 | Ravalli | Montana | 30081 | 3222 | 46 |
1402555 | 1402555 | 2021-06-09 | Ravalli | Montana | 30081 | 3221 | 46 |
1399310 | 1399310 | 2021-06-08 | Ravalli | Montana | 30081 | 3218 | 46 |
1396064 | 1396064 | 2021-06-07 | Ravalli | Montana | 30081 | 3199 | 46 |
1392818 | 1392818 | 2021-06-06 | Ravalli | Montana | 30081 | 3187 | 46 |
1389573 | 1389573 | 2021-06-05 | Ravalli | Montana | 30081 | 3187 | 46 |
1386328 | 1386328 | 2021-06-04 | Ravalli | Montana | 30081 | 3187 | 46 |
1383083 | 1383083 | 2021-06-03 | Ravalli | Montana | 30081 | 3183 | 46 |
1379837 | 1379837 | 2021-06-02 | Ravalli | Montana | 30081 | 3171 | 45 |
1376592 | 1376592 | 2021-06-01 | Ravalli | Montana | 30081 | 3164 | 45 |
1373346 | 1373346 | 2021-05-31 | Ravalli | Montana | 30081 | 3164 | 45 |
1370101 | 1370101 | 2021-05-30 | Ravalli | Montana | 30081 | 3164 | 45 |
1366855 | 1366855 | 2021-05-29 | Ravalli | Montana | 30081 | 3164 | 45 |
1363609 | 1363609 | 2021-05-28 | Ravalli | Montana | 30081 | 3150 | 45 |
1360362 | 1360362 | 2021-05-27 | Ravalli | Montana | 30081 | 3138 | 45 |
1357116 | 1357116 | 2021-05-26 | Ravalli | Montana | 30081 | 3132 | 45 |
1353870 | 1353870 | 2021-05-25 | Ravalli | Montana | 30081 | 3129 | 45 |
1350624 | 1350624 | 2021-05-24 | Ravalli | Montana | 30081 | 3124 | 44 |
1347378 | 1347378 | 2021-05-23 | Ravalli | Montana | 30081 | 3124 | 44 |
1344130 | 1344130 | 2021-05-22 | Ravalli | Montana | 30081 | 3118 | 44 |
1340882 | 1340882 | 2021-05-21 | Ravalli | Montana | 30081 | 3110 | 44 |
1337634 | 1337634 | 2021-05-20 | Ravalli | Montana | 30081 | 3102 | 44 |
1334387 | 1334387 | 2021-05-19 | Ravalli | Montana | 30081 | 3117 | 44 |
1331140 | 1331140 | 2021-05-18 | Ravalli | Montana | 30081 | 3108 | 44 |
1327893 | 1327893 | 2021-05-17 | Ravalli | Montana | 30081 | 3096 | 44 |
1324647 | 1324647 | 2021-05-16 | Ravalli | Montana | 30081 | 3096 | 44 |
1321401 | 1321401 | 2021-05-15 | Ravalli | Montana | 30081 | 3096 | 44 |
1318155 | 1318155 | 2021-05-14 | Ravalli | Montana | 30081 | 3087 | 44 |
1314907 | 1314907 | 2021-05-13 | Ravalli | Montana | 30081 | 3078 | 44 |
1311661 | 1311661 | 2021-05-12 | Ravalli | Montana | 30081 | 3071 | 44 |
1308414 | 1308414 | 2021-05-11 | Ravalli | Montana | 30081 | 3070 | 44 |
1305168 | 1305168 | 2021-05-10 | Ravalli | Montana | 30081 | 3065 | 44 |
1301922 | 1301922 | 2021-05-09 | Ravalli | Montana | 30081 | 3065 | 44 |
1298674 | 1298674 | 2021-05-08 | Ravalli | Montana | 30081 | 3065 | 44 |
1295428 | 1295428 | 2021-05-07 | Ravalli | Montana | 30081 | 3060 | 44 |
1292182 | 1292182 | 2021-05-06 | Ravalli | Montana | 30081 | 3051 | 32 |
1288936 | 1288936 | 2021-05-05 | Ravalli | Montana | 30081 | 3047 | 32 |
1285690 | 1285690 | 2021-05-04 | Ravalli | Montana | 30081 | 3045 | 32 |
1282444 | 1282444 | 2021-05-03 | Ravalli | Montana | 30081 | 3036 | 32 |
1279197 | 1279197 | 2021-05-02 | Ravalli | Montana | 30081 | 3036 | 32 |
1275950 | 1275950 | 2021-05-01 | Ravalli | Montana | 30081 | 3036 | 32 |
1272703 | 1272703 | 2021-04-30 | Ravalli | Montana | 30081 | 3031 | 32 |
1269456 | 1269456 | 2021-04-29 | Ravalli | Montana | 30081 | 3023 | 32 |
1266209 | 1266209 | 2021-04-28 | Ravalli | Montana | 30081 | 3020 | 31 |
1262962 | 1262962 | 2021-04-27 | Ravalli | Montana | 30081 | 3008 | 31 |
1259715 | 1259715 | 2021-04-26 | Ravalli | Montana | 30081 | 3002 | 31 |
1256468 | 1256468 | 2021-04-25 | Ravalli | Montana | 30081 | 3003 | 31 |
1253221 | 1253221 | 2021-04-24 | Ravalli | Montana | 30081 | 3002 | 31 |
1249974 | 1249974 | 2021-04-23 | Ravalli | Montana | 30081 | 2996 | 31 |
1246727 | 1246727 | 2021-04-22 | Ravalli | Montana | 30081 | 2988 | 31 |
1243480 | 1243480 | 2021-04-21 | Ravalli | Montana | 30081 | 2983 | 31 |
1240233 | 1240233 | 2021-04-20 | Ravalli | Montana | 30081 | 2977 | 30 |
1236986 | 1236986 | 2021-04-19 | Ravalli | Montana | 30081 | 2968 | 30 |
1233739 | 1233739 | 2021-04-18 | Ravalli | Montana | 30081 | 2964 | 30 |
1230491 | 1230491 | 2021-04-17 | Ravalli | Montana | 30081 | 2964 | 30 |
1227243 | 1227243 | 2021-04-16 | Ravalli | Montana | 30081 | 2952 | 30 |
1223995 | 1223995 | 2021-04-15 | Ravalli | Montana | 30081 | 2951 | 30 |
1220748 | 1220748 | 2021-04-14 | Ravalli | Montana | 30081 | 2948 | 30 |
1217500 | 1217500 | 2021-04-13 | Ravalli | Montana | 30081 | 2943 | 30 |
1214253 | 1214253 | 2021-04-12 | Ravalli | Montana | 30081 | 2938 | 30 |
1211005 | 1211005 | 2021-04-11 | Ravalli | Montana | 30081 | 2938 | 30 |
1207756 | 1207756 | 2021-04-10 | Ravalli | Montana | 30081 | 2938 | 30 |
1204508 | 1204508 | 2021-04-09 | Ravalli | Montana | 30081 | 2936 | 30 |
1201260 | 1201260 | 2021-04-08 | Ravalli | Montana | 30081 | 2935 | 30 |
1198011 | 1198011 | 2021-04-07 | Ravalli | Montana | 30081 | 2918 | 30 |
1194762 | 1194762 | 2021-04-06 | Ravalli | Montana | 30081 | 2913 | 30 |
1191513 | 1191513 | 2021-04-05 | Ravalli | Montana | 30081 | 2895 | 30 |
1188265 | 1188265 | 2021-04-04 | Ravalli | Montana | 30081 | 2895 | 30 |
1185018 | 1185018 | 2021-04-03 | Ravalli | Montana | 30081 | 2895 | 30 |
1181772 | 1181772 | 2021-04-02 | Ravalli | Montana | 30081 | 2890 | 30 |
1178525 | 1178525 | 2021-04-01 | Ravalli | Montana | 30081 | 2883 | 30 |
1175278 | 1175278 | 2021-03-31 | Ravalli | Montana | 30081 | 2874 | 30 |
1172031 | 1172031 | 2021-03-30 | Ravalli | Montana | 30081 | 2866 | 30 |
1168783 | 1168783 | 2021-03-29 | Ravalli | Montana | 30081 | 2861 | 30 |
1165535 | 1165535 | 2021-03-28 | Ravalli | Montana | 30081 | 2861 | 30 |
1162287 | 1162287 | 2021-03-27 | Ravalli | Montana | 30081 | 2861 | 30 |
1159039 | 1159039 | 2021-03-26 | Ravalli | Montana | 30081 | 2852 | 30 |
1155792 | 1155792 | 2021-03-25 | Ravalli | Montana | 30081 | 2847 | 30 |
1152545 | 1152545 | 2021-03-24 | Ravalli | Montana | 30081 | 2840 | 30 |
1149298 | 1149298 | 2021-03-23 | Ravalli | Montana | 30081 | 2831 | 30 |
1146051 | 1146051 | 2021-03-22 | Ravalli | Montana | 30081 | 2814 | 30 |
1142804 | 1142804 | 2021-03-21 | Ravalli | Montana | 30081 | 2814 | 30 |
1139557 | 1139557 | 2021-03-20 | Ravalli | Montana | 30081 | 2813 | 30 |
1136311 | 1136311 | 2021-03-19 | Ravalli | Montana | 30081 | 2808 | 30 |
1133065 | 1133065 | 2021-03-18 | Ravalli | Montana | 30081 | 2787 | 30 |
1129817 | 1129817 | 2021-03-17 | Ravalli | Montana | 30081 | 2775 | 30 |
1126570 | 1126570 | 2021-03-16 | Ravalli | Montana | 30081 | 2763 | 29 |
1123324 | 1123324 | 2021-03-15 | Ravalli | Montana | 30081 | 2749 | 29 |
1120077 | 1120077 | 2021-03-14 | Ravalli | Montana | 30081 | 2746 | 29 |
1116830 | 1116830 | 2021-03-13 | Ravalli | Montana | 30081 | 2747 | 29 |
1113584 | 1113584 | 2021-03-12 | Ravalli | Montana | 30081 | 2740 | 29 |
1110338 | 1110338 | 2021-03-11 | Ravalli | Montana | 30081 | 2737 | 29 |
1107092 | 1107092 | 2021-03-10 | Ravalli | Montana | 30081 | 2729 | 29 |
1103846 | 1103846 | 2021-03-09 | Ravalli | Montana | 30081 | 2728 | 29 |
1100600 | 1100600 | 2021-03-08 | Ravalli | Montana | 30081 | 2716 | 30 |
1097353 | 1097353 | 2021-03-07 | Ravalli | Montana | 30081 | 2716 | 30 |
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);