ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where county = "Tioga" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1279439 | 1279439 | 2021-05-02 | Tioga | New York | 36107 | 3589 | 61 |
1276192 | 1276192 | 2021-05-01 | Tioga | New York | 36107 | 3578 | 61 |
1272945 | 1272945 | 2021-04-30 | Tioga | New York | 36107 | 3567 | 61 |
1269698 | 1269698 | 2021-04-29 | Tioga | New York | 36107 | 3554 | 61 |
1266451 | 1266451 | 2021-04-28 | Tioga | New York | 36107 | 3537 | 61 |
1263204 | 1263204 | 2021-04-27 | Tioga | New York | 36107 | 3527 | 61 |
1259957 | 1259957 | 2021-04-26 | Tioga | New York | 36107 | 3526 | 61 |
1256710 | 1256710 | 2021-04-25 | Tioga | New York | 36107 | 3516 | 61 |
1253463 | 1253463 | 2021-04-24 | Tioga | New York | 36107 | 3499 | 60 |
1250216 | 1250216 | 2021-04-23 | Tioga | New York | 36107 | 3480 | 60 |
1246969 | 1246969 | 2021-04-22 | Tioga | New York | 36107 | 3462 | 59 |
1243722 | 1243722 | 2021-04-21 | Tioga | New York | 36107 | 3450 | 58 |
1240475 | 1240475 | 2021-04-20 | Tioga | New York | 36107 | 3434 | 58 |
1237228 | 1237228 | 2021-04-19 | Tioga | New York | 36107 | 3423 | 58 |
1233981 | 1233981 | 2021-04-18 | Tioga | New York | 36107 | 3412 | 58 |
1230733 | 1230733 | 2021-04-17 | Tioga | New York | 36107 | 3395 | 58 |
1227485 | 1227485 | 2021-04-16 | Tioga | New York | 36107 | 3370 | 58 |
1224237 | 1224237 | 2021-04-15 | Tioga | New York | 36107 | 3357 | 58 |
1220990 | 1220990 | 2021-04-14 | Tioga | New York | 36107 | 3333 | 58 |
1217742 | 1217742 | 2021-04-13 | Tioga | New York | 36107 | 3316 | 58 |
1214494 | 1214494 | 2021-04-12 | Tioga | New York | 36107 | 3304 | 58 |
1211247 | 1211247 | 2021-04-11 | Tioga | New York | 36107 | 3297 | 58 |
1207998 | 1207998 | 2021-04-10 | Tioga | New York | 36107 | 3285 | 58 |
1204750 | 1204750 | 2021-04-09 | Tioga | New York | 36107 | 3270 | 58 |
1201502 | 1201502 | 2021-04-08 | Tioga | New York | 36107 | 3239 | 58 |
1198253 | 1198253 | 2021-04-07 | Tioga | New York | 36107 | 3232 | 58 |
1195004 | 1195004 | 2021-04-06 | Tioga | New York | 36107 | 3213 | 58 |
1191756 | 1191756 | 2021-04-05 | Tioga | New York | 36107 | 3206 | 58 |
1188507 | 1188507 | 2021-04-04 | Tioga | New York | 36107 | 3190 | 58 |
1185260 | 1185260 | 2021-04-03 | Tioga | New York | 36107 | 3171 | 57 |
1182013 | 1182013 | 2021-04-02 | Tioga | New York | 36107 | 3156 | 57 |
1178766 | 1178766 | 2021-04-01 | Tioga | New York | 36107 | 3145 | 57 |
1175519 | 1175519 | 2021-03-31 | Tioga | New York | 36107 | 3128 | 57 |
1172272 | 1172272 | 2021-03-30 | Tioga | New York | 36107 | 3122 | 57 |
1169025 | 1169025 | 2021-03-29 | Tioga | New York | 36107 | 3112 | 57 |
1165777 | 1165777 | 2021-03-28 | Tioga | New York | 36107 | 3097 | 57 |
1162529 | 1162529 | 2021-03-27 | Tioga | New York | 36107 | 3077 | 57 |
1159280 | 1159280 | 2021-03-26 | Tioga | New York | 36107 | 3066 | 57 |
1156033 | 1156033 | 2021-03-25 | Tioga | New York | 36107 | 3055 | 56 |
1152786 | 1152786 | 2021-03-24 | Tioga | New York | 36107 | 3040 | 56 |
1149539 | 1149539 | 2021-03-23 | Tioga | New York | 36107 | 3031 | 56 |
1146292 | 1146292 | 2021-03-22 | Tioga | New York | 36107 | 3027 | 56 |
1143045 | 1143045 | 2021-03-21 | Tioga | New York | 36107 | 3022 | 56 |
1139798 | 1139798 | 2021-03-20 | Tioga | New York | 36107 | 3007 | 56 |
1136552 | 1136552 | 2021-03-19 | Tioga | New York | 36107 | 2996 | 56 |
1133306 | 1133306 | 2021-03-18 | Tioga | New York | 36107 | 2982 | 56 |
1130058 | 1130058 | 2021-03-17 | Tioga | New York | 36107 | 2965 | 56 |
1126811 | 1126811 | 2021-03-16 | Tioga | New York | 36107 | 2947 | 56 |
1123565 | 1123565 | 2021-03-15 | Tioga | New York | 36107 | 2945 | 56 |
1120319 | 1120319 | 2021-03-14 | Tioga | New York | 36107 | 2936 | 56 |
1117072 | 1117072 | 2021-03-13 | Tioga | New York | 36107 | 2925 | 56 |
1113825 | 1113825 | 2021-03-12 | Tioga | New York | 36107 | 2907 | 56 |
1110579 | 1110579 | 2021-03-11 | Tioga | New York | 36107 | 2892 | 56 |
1107333 | 1107333 | 2021-03-10 | Tioga | New York | 36107 | 2882 | 56 |
1104087 | 1104087 | 2021-03-09 | Tioga | New York | 36107 | 2873 | 56 |
1100841 | 1100841 | 2021-03-08 | Tioga | New York | 36107 | 2869 | 56 |
1097595 | 1097595 | 2021-03-07 | Tioga | New York | 36107 | 2864 | 56 |
1094347 | 1094347 | 2021-03-06 | Tioga | New York | 36107 | 2854 | 56 |
1091101 | 1091101 | 2021-03-05 | Tioga | New York | 36107 | 2836 | 56 |
1087856 | 1087856 | 2021-03-04 | Tioga | New York | 36107 | 2826 | 56 |
1084611 | 1084611 | 2021-03-03 | Tioga | New York | 36107 | 2819 | 56 |
1081365 | 1081365 | 2021-03-02 | Tioga | New York | 36107 | 2813 | 56 |
1078119 | 1078119 | 2021-03-01 | Tioga | New York | 36107 | 2806 | 56 |
1074874 | 1074874 | 2021-02-28 | Tioga | New York | 36107 | 2804 | 56 |
1071628 | 1071628 | 2021-02-27 | Tioga | New York | 36107 | 2799 | 56 |
1068382 | 1068382 | 2021-02-26 | Tioga | New York | 36107 | 2788 | 56 |
1065137 | 1065137 | 2021-02-25 | Tioga | New York | 36107 | 2779 | 56 |
1061893 | 1061893 | 2021-02-24 | Tioga | New York | 36107 | 2771 | 56 |
1058647 | 1058647 | 2021-02-23 | Tioga | New York | 36107 | 2766 | 56 |
1055401 | 1055401 | 2021-02-22 | Tioga | New York | 36107 | 2760 | 56 |
1052155 | 1052155 | 2021-02-21 | Tioga | New York | 36107 | 2752 | 56 |
1048908 | 1048908 | 2021-02-20 | Tioga | New York | 36107 | 2740 | 56 |
1045661 | 1045661 | 2021-02-19 | Tioga | New York | 36107 | 2725 | 56 |
1042416 | 1042416 | 2021-02-18 | Tioga | New York | 36107 | 2705 | 56 |
1039171 | 1039171 | 2021-02-17 | Tioga | New York | 36107 | 2695 | 56 |
1035926 | 1035926 | 2021-02-16 | Tioga | New York | 36107 | 2687 | 56 |
1032681 | 1032681 | 2021-02-15 | Tioga | New York | 36107 | 2681 | 56 |
1029435 | 1029435 | 2021-02-14 | Tioga | New York | 36107 | 2673 | 56 |
1026188 | 1026188 | 2021-02-13 | Tioga | New York | 36107 | 2656 | 56 |
1022943 | 1022943 | 2021-02-12 | Tioga | New York | 36107 | 2640 | 56 |
1019698 | 1019698 | 2021-02-11 | Tioga | New York | 36107 | 2631 | 56 |
1016453 | 1016453 | 2021-02-10 | Tioga | New York | 36107 | 2622 | 56 |
1013208 | 1013208 | 2021-02-09 | Tioga | New York | 36107 | 2607 | 56 |
1009963 | 1009963 | 2021-02-08 | Tioga | New York | 36107 | 2599 | 56 |
1006717 | 1006717 | 2021-02-07 | Tioga | New York | 36107 | 2584 | 56 |
1003471 | 1003471 | 2021-02-06 | Tioga | New York | 36107 | 2566 | 55 |
1000225 | 1000225 | 2021-02-05 | Tioga | New York | 36107 | 2545 | 55 |
996979 | 996979 | 2021-02-04 | Tioga | New York | 36107 | 2525 | 55 |
993733 | 993733 | 2021-02-03 | Tioga | New York | 36107 | 2509 | 55 |
990487 | 990487 | 2021-02-02 | Tioga | New York | 36107 | 2488 | 55 |
987241 | 987241 | 2021-02-01 | Tioga | New York | 36107 | 2480 | 55 |
983994 | 983994 | 2021-01-31 | Tioga | New York | 36107 | 2473 | 55 |
980747 | 980747 | 2021-01-30 | Tioga | New York | 36107 | 2456 | 54 |
977501 | 977501 | 2021-01-29 | Tioga | New York | 36107 | 2441 | 54 |
974256 | 974256 | 2021-01-28 | Tioga | New York | 36107 | 2431 | 54 |
971011 | 971011 | 2021-01-27 | Tioga | New York | 36107 | 2404 | 54 |
967766 | 967766 | 2021-01-26 | Tioga | New York | 36107 | 2380 | 54 |
964522 | 964522 | 2021-01-25 | Tioga | New York | 36107 | 2364 | 54 |
961277 | 961277 | 2021-01-24 | Tioga | New York | 36107 | 2346 | 54 |
958032 | 958032 | 2021-01-23 | Tioga | New York | 36107 | 2313 | 54 |
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);