ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
777 rows where county = "Tioga" and state = "Pennsylvania" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419449 | 1419449 | 2021-06-14 | Tioga | Pennsylvania | 42117 | 3099 | 110 |
1416204 | 1416204 | 2021-06-13 | Tioga | Pennsylvania | 42117 | 3098 | 110 |
1412958 | 1412958 | 2021-06-12 | Tioga | Pennsylvania | 42117 | 3097 | 110 |
1409713 | 1409713 | 2021-06-11 | Tioga | Pennsylvania | 42117 | 3094 | 110 |
1406468 | 1406468 | 2021-06-10 | Tioga | Pennsylvania | 42117 | 3088 | 110 |
1403222 | 1403222 | 2021-06-09 | Tioga | Pennsylvania | 42117 | 3084 | 110 |
1399977 | 1399977 | 2021-06-08 | Tioga | Pennsylvania | 42117 | 3084 | 109 |
1396732 | 1396732 | 2021-06-07 | Tioga | Pennsylvania | 42117 | 3083 | 109 |
1393485 | 1393485 | 2021-06-06 | Tioga | Pennsylvania | 42117 | 3079 | 109 |
1390240 | 1390240 | 2021-06-05 | Tioga | Pennsylvania | 42117 | 3077 | 109 |
1386995 | 1386995 | 2021-06-04 | Tioga | Pennsylvania | 42117 | 3075 | 109 |
1383750 | 1383750 | 2021-06-03 | Tioga | Pennsylvania | 42117 | 3067 | 108 |
1380504 | 1380504 | 2021-06-02 | Tioga | Pennsylvania | 42117 | 3059 | 108 |
1377259 | 1377259 | 2021-06-01 | Tioga | Pennsylvania | 42117 | 3053 | 108 |
1374013 | 1374013 | 2021-05-31 | Tioga | Pennsylvania | 42117 | 3047 | 108 |
1370768 | 1370768 | 2021-05-30 | Tioga | Pennsylvania | 42117 | 3043 | 108 |
1367522 | 1367522 | 2021-05-29 | Tioga | Pennsylvania | 42117 | 3041 | 108 |
1364276 | 1364276 | 2021-05-28 | Tioga | Pennsylvania | 42117 | 3033 | 108 |
1361030 | 1361030 | 2021-05-27 | Tioga | Pennsylvania | 42117 | 3028 | 108 |
1357784 | 1357784 | 2021-05-26 | Tioga | Pennsylvania | 42117 | 3020 | 108 |
1354538 | 1354538 | 2021-05-25 | Tioga | Pennsylvania | 42117 | 3019 | 108 |
1351292 | 1351292 | 2021-05-24 | Tioga | Pennsylvania | 42117 | 3011 | 108 |
1348046 | 1348046 | 2021-05-23 | Tioga | Pennsylvania | 42117 | 3005 | 108 |
1344798 | 1344798 | 2021-05-22 | Tioga | Pennsylvania | 42117 | 2993 | 108 |
1341550 | 1341550 | 2021-05-21 | Tioga | Pennsylvania | 42117 | 2993 | 107 |
1338302 | 1338302 | 2021-05-20 | Tioga | Pennsylvania | 42117 | 2986 | 107 |
1335055 | 1335055 | 2021-05-19 | Tioga | Pennsylvania | 42117 | 2978 | 107 |
1331808 | 1331808 | 2021-05-18 | Tioga | Pennsylvania | 42117 | 2970 | 107 |
1328561 | 1328561 | 2021-05-17 | Tioga | Pennsylvania | 42117 | 2965 | 107 |
1325315 | 1325315 | 2021-05-16 | Tioga | Pennsylvania | 42117 | 2962 | 106 |
1322069 | 1322069 | 2021-05-15 | Tioga | Pennsylvania | 42117 | 2959 | 106 |
1318823 | 1318823 | 2021-05-14 | Tioga | Pennsylvania | 42117 | 2952 | 106 |
1315575 | 1315575 | 2021-05-13 | Tioga | Pennsylvania | 42117 | 2950 | 106 |
1312329 | 1312329 | 2021-05-12 | Tioga | Pennsylvania | 42117 | 2943 | 106 |
1309082 | 1309082 | 2021-05-11 | Tioga | Pennsylvania | 42117 | 2934 | 106 |
1305836 | 1305836 | 2021-05-10 | Tioga | Pennsylvania | 42117 | 2927 | 104 |
1302590 | 1302590 | 2021-05-09 | Tioga | Pennsylvania | 42117 | 2926 | 104 |
1299343 | 1299343 | 2021-05-08 | Tioga | Pennsylvania | 42117 | 2918 | 104 |
1296096 | 1296096 | 2021-05-07 | Tioga | Pennsylvania | 42117 | 2912 | 104 |
1292850 | 1292850 | 2021-05-06 | Tioga | Pennsylvania | 42117 | 2909 | 104 |
1289604 | 1289604 | 2021-05-05 | Tioga | Pennsylvania | 42117 | 2897 | 104 |
1286358 | 1286358 | 2021-05-04 | Tioga | Pennsylvania | 42117 | 2882 | 104 |
1283112 | 1283112 | 2021-05-03 | Tioga | Pennsylvania | 42117 | 2874 | 104 |
1279865 | 1279865 | 2021-05-02 | Tioga | Pennsylvania | 42117 | 2871 | 104 |
1276618 | 1276618 | 2021-05-01 | Tioga | Pennsylvania | 42117 | 2866 | 104 |
1273371 | 1273371 | 2021-04-30 | Tioga | Pennsylvania | 42117 | 2862 | 104 |
1270124 | 1270124 | 2021-04-29 | Tioga | Pennsylvania | 42117 | 2853 | 104 |
1266877 | 1266877 | 2021-04-28 | Tioga | Pennsylvania | 42117 | 2847 | 104 |
1263630 | 1263630 | 2021-04-27 | Tioga | Pennsylvania | 42117 | 2842 | 104 |
1260383 | 1260383 | 2021-04-26 | Tioga | Pennsylvania | 42117 | 2839 | 103 |
1257136 | 1257136 | 2021-04-25 | Tioga | Pennsylvania | 42117 | 2825 | 103 |
1253889 | 1253889 | 2021-04-24 | Tioga | Pennsylvania | 42117 | 2820 | 103 |
1250642 | 1250642 | 2021-04-23 | Tioga | Pennsylvania | 42117 | 2812 | 103 |
1247395 | 1247395 | 2021-04-22 | Tioga | Pennsylvania | 42117 | 2803 | 103 |
1244148 | 1244148 | 2021-04-21 | Tioga | Pennsylvania | 42117 | 2793 | 103 |
1240901 | 1240901 | 2021-04-20 | Tioga | Pennsylvania | 42117 | 2785 | 103 |
1237654 | 1237654 | 2021-04-19 | Tioga | Pennsylvania | 42117 | 2778 | 102 |
1234407 | 1234407 | 2021-04-18 | Tioga | Pennsylvania | 42117 | 2771 | 102 |
1231159 | 1231159 | 2021-04-17 | Tioga | Pennsylvania | 42117 | 2766 | 102 |
1227911 | 1227911 | 2021-04-16 | Tioga | Pennsylvania | 42117 | 2757 | 102 |
1224663 | 1224663 | 2021-04-15 | Tioga | Pennsylvania | 42117 | 2748 | 102 |
1221416 | 1221416 | 2021-04-14 | Tioga | Pennsylvania | 42117 | 2743 | 102 |
1218168 | 1218168 | 2021-04-13 | Tioga | Pennsylvania | 42117 | 2735 | 102 |
1214920 | 1214920 | 2021-04-12 | Tioga | Pennsylvania | 42117 | 2730 | 101 |
1211673 | 1211673 | 2021-04-11 | Tioga | Pennsylvania | 42117 | 2726 | 101 |
1208424 | 1208424 | 2021-04-10 | Tioga | Pennsylvania | 42117 | 2720 | 101 |
1205176 | 1205176 | 2021-04-09 | Tioga | Pennsylvania | 42117 | 2707 | 101 |
1201928 | 1201928 | 2021-04-08 | Tioga | Pennsylvania | 42117 | 2700 | 101 |
1198679 | 1198679 | 2021-04-07 | Tioga | Pennsylvania | 42117 | 2685 | 101 |
1195430 | 1195430 | 2021-04-06 | Tioga | Pennsylvania | 42117 | 2679 | 100 |
1192182 | 1192182 | 2021-04-05 | Tioga | Pennsylvania | 42117 | 2666 | 99 |
1188933 | 1188933 | 2021-04-04 | Tioga | Pennsylvania | 42117 | 2664 | 99 |
1185686 | 1185686 | 2021-04-03 | Tioga | Pennsylvania | 42117 | 2655 | 98 |
1182439 | 1182439 | 2021-04-02 | Tioga | Pennsylvania | 42117 | 2638 | 98 |
1179192 | 1179192 | 2021-04-01 | Tioga | Pennsylvania | 42117 | 2629 | 98 |
1175945 | 1175945 | 2021-03-31 | Tioga | Pennsylvania | 42117 | 2616 | 98 |
1172698 | 1172698 | 2021-03-30 | Tioga | Pennsylvania | 42117 | 2611 | 98 |
1169451 | 1169451 | 2021-03-29 | Tioga | Pennsylvania | 42117 | 2603 | 97 |
1166203 | 1166203 | 2021-03-28 | Tioga | Pennsylvania | 42117 | 2596 | 97 |
1162955 | 1162955 | 2021-03-27 | Tioga | Pennsylvania | 42117 | 2586 | 97 |
1159706 | 1159706 | 2021-03-26 | Tioga | Pennsylvania | 42117 | 2575 | 97 |
1156459 | 1156459 | 2021-03-25 | Tioga | Pennsylvania | 42117 | 2555 | 95 |
1153212 | 1153212 | 2021-03-24 | Tioga | Pennsylvania | 42117 | 2544 | 94 |
1149965 | 1149965 | 2021-03-23 | Tioga | Pennsylvania | 42117 | 2534 | 94 |
1146718 | 1146718 | 2021-03-22 | Tioga | Pennsylvania | 42117 | 2529 | 94 |
1143471 | 1143471 | 2021-03-21 | Tioga | Pennsylvania | 42117 | 2526 | 94 |
1140224 | 1140224 | 2021-03-20 | Tioga | Pennsylvania | 42117 | 2523 | 94 |
1136978 | 1136978 | 2021-03-19 | Tioga | Pennsylvania | 42117 | 2509 | 94 |
1133732 | 1133732 | 2021-03-18 | Tioga | Pennsylvania | 42117 | 2506 | 94 |
1130484 | 1130484 | 2021-03-17 | Tioga | Pennsylvania | 42117 | 2504 | 94 |
1127237 | 1127237 | 2021-03-16 | Tioga | Pennsylvania | 42117 | 2501 | 94 |
1123991 | 1123991 | 2021-03-15 | Tioga | Pennsylvania | 42117 | 2494 | 94 |
1120745 | 1120745 | 2021-03-14 | Tioga | Pennsylvania | 42117 | 2493 | 94 |
1117498 | 1117498 | 2021-03-13 | Tioga | Pennsylvania | 42117 | 2490 | 94 |
1114251 | 1114251 | 2021-03-12 | Tioga | Pennsylvania | 42117 | 2487 | 94 |
1111005 | 1111005 | 2021-03-11 | Tioga | Pennsylvania | 42117 | 2482 | 94 |
1107759 | 1107759 | 2021-03-10 | Tioga | Pennsylvania | 42117 | 2478 | 94 |
1104513 | 1104513 | 2021-03-09 | Tioga | Pennsylvania | 42117 | 2474 | 94 |
1101267 | 1101267 | 2021-03-08 | Tioga | Pennsylvania | 42117 | 2470 | 94 |
1098021 | 1098021 | 2021-03-07 | Tioga | Pennsylvania | 42117 | 2468 | 94 |
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);