ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where fips = 15001 and state = "Hawaii" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1417681 | 1417681 | 2021-06-14 | Hawaii | Hawaii | 15001 | 3142 | 54 |
1414435 | 1414435 | 2021-06-13 | Hawaii | Hawaii | 15001 | 3138 | 54 |
1411190 | 1411190 | 2021-06-12 | Hawaii | Hawaii | 15001 | 3136 | 54 |
1407945 | 1407945 | 2021-06-11 | Hawaii | Hawaii | 15001 | 3090 | 54 |
1404699 | 1404699 | 2021-06-10 | Hawaii | Hawaii | 15001 | 3060 | 53 |
1401454 | 1401454 | 2021-06-09 | Hawaii | Hawaii | 15001 | 3050 | 53 |
1398209 | 1398209 | 2021-06-08 | Hawaii | Hawaii | 15001 | 3045 | 53 |
1394962 | 1394962 | 2021-06-07 | Hawaii | Hawaii | 15001 | 3043 | 53 |
1391717 | 1391717 | 2021-06-06 | Hawaii | Hawaii | 15001 | 3040 | 53 |
1388472 | 1388472 | 2021-06-05 | Hawaii | Hawaii | 15001 | 3005 | 53 |
1385227 | 1385227 | 2021-06-04 | Hawaii | Hawaii | 15001 | 2996 | 53 |
1381981 | 1381981 | 2021-06-03 | Hawaii | Hawaii | 15001 | 2971 | 53 |
1378736 | 1378736 | 2021-06-02 | Hawaii | Hawaii | 15001 | 2968 | 53 |
1375490 | 1375490 | 2021-06-01 | Hawaii | Hawaii | 15001 | 2968 | 53 |
1372245 | 1372245 | 2021-05-31 | Hawaii | Hawaii | 15001 | 2949 | 53 |
1369000 | 1369000 | 2021-05-30 | Hawaii | Hawaii | 15001 | 2949 | 53 |
1365754 | 1365754 | 2021-05-29 | Hawaii | Hawaii | 15001 | 2886 | 53 |
1362508 | 1362508 | 2021-05-28 | Hawaii | Hawaii | 15001 | 2875 | 53 |
1359261 | 1359261 | 2021-05-27 | Hawaii | Hawaii | 15001 | 2870 | 53 |
1356015 | 1356015 | 2021-05-26 | Hawaii | Hawaii | 15001 | 2864 | 53 |
1352769 | 1352769 | 2021-05-25 | Hawaii | Hawaii | 15001 | 2855 | 53 |
1349523 | 1349523 | 2021-05-24 | Hawaii | Hawaii | 15001 | 2853 | 53 |
1346276 | 1346276 | 2021-05-23 | Hawaii | Hawaii | 15001 | 2848 | 53 |
1343028 | 1343028 | 2021-05-22 | Hawaii | Hawaii | 15001 | 2840 | 53 |
1339780 | 1339780 | 2021-05-21 | Hawaii | Hawaii | 15001 | 2839 | 53 |
1336533 | 1336533 | 2021-05-20 | Hawaii | Hawaii | 15001 | 2836 | 53 |
1333286 | 1333286 | 2021-05-19 | Hawaii | Hawaii | 15001 | 2834 | 53 |
1330039 | 1330039 | 2021-05-18 | Hawaii | Hawaii | 15001 | 2823 | 53 |
1326792 | 1326792 | 2021-05-17 | Hawaii | Hawaii | 15001 | 2824 | 53 |
1323546 | 1323546 | 2021-05-16 | Hawaii | Hawaii | 15001 | 2817 | 53 |
1320300 | 1320300 | 2021-05-15 | Hawaii | Hawaii | 15001 | 2814 | 53 |
1317053 | 1317053 | 2021-05-14 | Hawaii | Hawaii | 15001 | 2811 | 53 |
1313806 | 1313806 | 2021-05-13 | Hawaii | Hawaii | 15001 | 2806 | 53 |
1310559 | 1310559 | 2021-05-12 | Hawaii | Hawaii | 15001 | 2799 | 53 |
1307313 | 1307313 | 2021-05-11 | Hawaii | Hawaii | 15001 | 2798 | 53 |
1304067 | 1304067 | 2021-05-10 | Hawaii | Hawaii | 15001 | 2795 | 53 |
1300820 | 1300820 | 2021-05-09 | Hawaii | Hawaii | 15001 | 2795 | 53 |
1297573 | 1297573 | 2021-05-08 | Hawaii | Hawaii | 15001 | 2787 | 53 |
1294327 | 1294327 | 2021-05-07 | Hawaii | Hawaii | 15001 | 2781 | 53 |
1291081 | 1291081 | 2021-05-06 | Hawaii | Hawaii | 15001 | 2777 | 53 |
1287835 | 1287835 | 2021-05-05 | Hawaii | Hawaii | 15001 | 2767 | 53 |
1284589 | 1284589 | 2021-05-04 | Hawaii | Hawaii | 15001 | 2765 | 53 |
1281342 | 1281342 | 2021-05-03 | Hawaii | Hawaii | 15001 | 2763 | 53 |
1278095 | 1278095 | 2021-05-02 | Hawaii | Hawaii | 15001 | 2759 | 53 |
1274848 | 1274848 | 2021-05-01 | Hawaii | Hawaii | 15001 | 2756 | 53 |
1271601 | 1271601 | 2021-04-30 | Hawaii | Hawaii | 15001 | 2748 | 53 |
1268354 | 1268354 | 2021-04-29 | Hawaii | Hawaii | 15001 | 2738 | 53 |
1265107 | 1265107 | 2021-04-28 | Hawaii | Hawaii | 15001 | 2734 | 53 |
1261860 | 1261860 | 2021-04-27 | Hawaii | Hawaii | 15001 | 2733 | 53 |
1258613 | 1258613 | 2021-04-26 | Hawaii | Hawaii | 15001 | 2728 | 53 |
1255366 | 1255366 | 2021-04-25 | Hawaii | Hawaii | 15001 | 2725 | 53 |
1252119 | 1252119 | 2021-04-24 | Hawaii | Hawaii | 15001 | 2719 | 53 |
1248872 | 1248872 | 2021-04-23 | Hawaii | Hawaii | 15001 | 2715 | 53 |
1245625 | 1245625 | 2021-04-22 | Hawaii | Hawaii | 15001 | 2710 | 53 |
1242378 | 1242378 | 2021-04-21 | Hawaii | Hawaii | 15001 | 2701 | 53 |
1239131 | 1239131 | 2021-04-20 | Hawaii | Hawaii | 15001 | 2695 | 53 |
1235884 | 1235884 | 2021-04-19 | Hawaii | Hawaii | 15001 | 2694 | 53 |
1232637 | 1232637 | 2021-04-18 | Hawaii | Hawaii | 15001 | 2692 | 53 |
1229388 | 1229388 | 2021-04-17 | Hawaii | Hawaii | 15001 | 2682 | 53 |
1226140 | 1226140 | 2021-04-16 | Hawaii | Hawaii | 15001 | 2671 | 53 |
1222893 | 1222893 | 2021-04-15 | Hawaii | Hawaii | 15001 | 2668 | 53 |
1219645 | 1219645 | 2021-04-14 | Hawaii | Hawaii | 15001 | 2654 | 53 |
1216397 | 1216397 | 2021-04-13 | Hawaii | Hawaii | 15001 | 2639 | 53 |
1213150 | 1213150 | 2021-04-12 | Hawaii | Hawaii | 15001 | 2634 | 53 |
1209902 | 1209902 | 2021-04-11 | Hawaii | Hawaii | 15001 | 2629 | 53 |
1206653 | 1206653 | 2021-04-10 | Hawaii | Hawaii | 15001 | 2623 | 53 |
1203405 | 1203405 | 2021-04-09 | Hawaii | Hawaii | 15001 | 2611 | 53 |
1200157 | 1200157 | 2021-04-08 | Hawaii | Hawaii | 15001 | 2600 | 53 |
1196908 | 1196908 | 2021-04-07 | Hawaii | Hawaii | 15001 | 2589 | 53 |
1193660 | 1193660 | 2021-04-06 | Hawaii | Hawaii | 15001 | 2584 | 53 |
1190410 | 1190410 | 2021-04-05 | Hawaii | Hawaii | 15001 | 2582 | 53 |
1187163 | 1187163 | 2021-04-04 | Hawaii | Hawaii | 15001 | 2568 | 53 |
1183916 | 1183916 | 2021-04-03 | Hawaii | Hawaii | 15001 | 2553 | 53 |
1180669 | 1180669 | 2021-04-02 | Hawaii | Hawaii | 15001 | 2544 | 53 |
1177422 | 1177422 | 2021-04-01 | Hawaii | Hawaii | 15001 | 2525 | 53 |
1174175 | 1174175 | 2021-03-31 | Hawaii | Hawaii | 15001 | 2517 | 53 |
1170928 | 1170928 | 2021-03-30 | Hawaii | Hawaii | 15001 | 2501 | 53 |
1167680 | 1167680 | 2021-03-29 | Hawaii | Hawaii | 15001 | 2495 | 53 |
1164432 | 1164432 | 2021-03-28 | Hawaii | Hawaii | 15001 | 2485 | 53 |
1161184 | 1161184 | 2021-03-27 | Hawaii | Hawaii | 15001 | 2470 | 53 |
1157936 | 1157936 | 2021-03-26 | Hawaii | Hawaii | 15001 | 2456 | 53 |
1154689 | 1154689 | 2021-03-25 | Hawaii | Hawaii | 15001 | 2443 | 53 |
1151442 | 1151442 | 2021-03-24 | Hawaii | Hawaii | 15001 | 2431 | 53 |
1148195 | 1148195 | 2021-03-23 | Hawaii | Hawaii | 15001 | 2424 | 53 |
1144948 | 1144948 | 2021-03-22 | Hawaii | Hawaii | 15001 | 2423 | 53 |
1141701 | 1141701 | 2021-03-21 | Hawaii | Hawaii | 15001 | 2414 | 53 |
1138455 | 1138455 | 2021-03-20 | Hawaii | Hawaii | 15001 | 2409 | 53 |
1135209 | 1135209 | 2021-03-19 | Hawaii | Hawaii | 15001 | 2400 | 53 |
1131962 | 1131962 | 2021-03-18 | Hawaii | Hawaii | 15001 | 2391 | 53 |
1128714 | 1128714 | 2021-03-17 | Hawaii | Hawaii | 15001 | 2384 | 53 |
1125468 | 1125468 | 2021-03-16 | Hawaii | Hawaii | 15001 | 2380 | 53 |
1122222 | 1122222 | 2021-03-15 | Hawaii | Hawaii | 15001 | 2372 | 53 |
1118975 | 1118975 | 2021-03-14 | Hawaii | Hawaii | 15001 | 2365 | 53 |
1115728 | 1115728 | 2021-03-13 | Hawaii | Hawaii | 15001 | 2361 | 53 |
1112482 | 1112482 | 2021-03-12 | Hawaii | Hawaii | 15001 | 2354 | 53 |
1109236 | 1109236 | 2021-03-11 | Hawaii | Hawaii | 15001 | 2335 | 53 |
1105990 | 1105990 | 2021-03-10 | Hawaii | Hawaii | 15001 | 2327 | 53 |
1102744 | 1102744 | 2021-03-09 | Hawaii | Hawaii | 15001 | 2322 | 53 |
1099498 | 1099498 | 2021-03-08 | Hawaii | Hawaii | 15001 | 2315 | 53 |
1096250 | 1096250 | 2021-03-07 | Hawaii | Hawaii | 15001 | 2305 | 53 |
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);