ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 48117 and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1419810 | 1419810 | 2021-06-14 | Deaf Smith | Texas | 48117 | 2908 | 68 |
1416565 | 1416565 | 2021-06-13 | Deaf Smith | Texas | 48117 | 2908 | 68 |
1413319 | 1413319 | 2021-06-12 | Deaf Smith | Texas | 48117 | 2908 | 68 |
1410074 | 1410074 | 2021-06-11 | Deaf Smith | Texas | 48117 | 2906 | 68 |
1406829 | 1406829 | 2021-06-10 | Deaf Smith | Texas | 48117 | 2895 | 68 |
1403583 | 1403583 | 2021-06-09 | Deaf Smith | Texas | 48117 | 2894 | 68 |
1400338 | 1400338 | 2021-06-08 | Deaf Smith | Texas | 48117 | 2887 | 68 |
1397093 | 1397093 | 2021-06-07 | Deaf Smith | Texas | 48117 | 2871 | 67 |
1393846 | 1393846 | 2021-06-06 | Deaf Smith | Texas | 48117 | 2871 | 67 |
1390601 | 1390601 | 2021-06-05 | Deaf Smith | Texas | 48117 | 2871 | 67 |
1387356 | 1387356 | 2021-06-04 | Deaf Smith | Texas | 48117 | 2871 | 67 |
1384111 | 1384111 | 2021-06-03 | Deaf Smith | Texas | 48117 | 2866 | 67 |
1380865 | 1380865 | 2021-06-02 | Deaf Smith | Texas | 48117 | 2859 | 66 |
1377620 | 1377620 | 2021-06-01 | Deaf Smith | Texas | 48117 | 2855 | 66 |
1374374 | 1374374 | 2021-05-31 | Deaf Smith | Texas | 48117 | 2858 | 66 |
1371129 | 1371129 | 2021-05-30 | Deaf Smith | Texas | 48117 | 2858 | 66 |
1367883 | 1367883 | 2021-05-29 | Deaf Smith | Texas | 48117 | 2858 | 66 |
1364637 | 1364637 | 2021-05-28 | Deaf Smith | Texas | 48117 | 2855 | 66 |
1361391 | 1361391 | 2021-05-27 | Deaf Smith | Texas | 48117 | 2850 | 66 |
1358145 | 1358145 | 2021-05-26 | Deaf Smith | Texas | 48117 | 2844 | 66 |
1354899 | 1354899 | 2021-05-25 | Deaf Smith | Texas | 48117 | 2842 | 66 |
1351653 | 1351653 | 2021-05-24 | Deaf Smith | Texas | 48117 | 2833 | 66 |
1348407 | 1348407 | 2021-05-23 | Deaf Smith | Texas | 48117 | 2833 | 66 |
1345159 | 1345159 | 2021-05-22 | Deaf Smith | Texas | 48117 | 2833 | 66 |
1341911 | 1341911 | 2021-05-21 | Deaf Smith | Texas | 48117 | 2833 | 66 |
1338663 | 1338663 | 2021-05-20 | Deaf Smith | Texas | 48117 | 2831 | 66 |
1335416 | 1335416 | 2021-05-19 | Deaf Smith | Texas | 48117 | 2828 | 66 |
1332169 | 1332169 | 2021-05-18 | Deaf Smith | Texas | 48117 | 2822 | 66 |
1328922 | 1328922 | 2021-05-17 | Deaf Smith | Texas | 48117 | 2822 | 66 |
1325676 | 1325676 | 2021-05-16 | Deaf Smith | Texas | 48117 | 2822 | 66 |
1322430 | 1322430 | 2021-05-15 | Deaf Smith | Texas | 48117 | 2822 | 66 |
1319184 | 1319184 | 2021-05-14 | Deaf Smith | Texas | 48117 | 2816 | 66 |
1315936 | 1315936 | 2021-05-13 | Deaf Smith | Texas | 48117 | 2816 | 66 |
1312690 | 1312690 | 2021-05-12 | Deaf Smith | Texas | 48117 | 2815 | 66 |
1309443 | 1309443 | 2021-05-11 | Deaf Smith | Texas | 48117 | 2815 | 66 |
1306197 | 1306197 | 2021-05-10 | Deaf Smith | Texas | 48117 | 2814 | 66 |
1302951 | 1302951 | 2021-05-09 | Deaf Smith | Texas | 48117 | 2814 | 66 |
1299704 | 1299704 | 2021-05-08 | Deaf Smith | Texas | 48117 | 2814 | 66 |
1296457 | 1296457 | 2021-05-07 | Deaf Smith | Texas | 48117 | 2814 | 66 |
1293211 | 1293211 | 2021-05-06 | Deaf Smith | Texas | 48117 | 2810 | 66 |
1289965 | 1289965 | 2021-05-05 | Deaf Smith | Texas | 48117 | 2810 | 66 |
1286719 | 1286719 | 2021-05-04 | Deaf Smith | Texas | 48117 | 2808 | 66 |
1283473 | 1283473 | 2021-05-03 | Deaf Smith | Texas | 48117 | 2806 | 66 |
1280226 | 1280226 | 2021-05-02 | Deaf Smith | Texas | 48117 | 2806 | 66 |
1276979 | 1276979 | 2021-05-01 | Deaf Smith | Texas | 48117 | 2806 | 66 |
1273732 | 1273732 | 2021-04-30 | Deaf Smith | Texas | 48117 | 2806 | 66 |
1270485 | 1270485 | 2021-04-29 | Deaf Smith | Texas | 48117 | 2805 | 66 |
1267238 | 1267238 | 2021-04-28 | Deaf Smith | Texas | 48117 | 2805 | 66 |
1263991 | 1263991 | 2021-04-27 | Deaf Smith | Texas | 48117 | 2801 | 66 |
1260744 | 1260744 | 2021-04-26 | Deaf Smith | Texas | 48117 | 2798 | 66 |
1257497 | 1257497 | 2021-04-25 | Deaf Smith | Texas | 48117 | 2798 | 66 |
1254250 | 1254250 | 2021-04-24 | Deaf Smith | Texas | 48117 | 2798 | 66 |
1251003 | 1251003 | 2021-04-23 | Deaf Smith | Texas | 48117 | 2798 | 66 |
1247756 | 1247756 | 2021-04-22 | Deaf Smith | Texas | 48117 | 2796 | 66 |
1244509 | 1244509 | 2021-04-21 | Deaf Smith | Texas | 48117 | 2788 | 66 |
1241262 | 1241262 | 2021-04-20 | Deaf Smith | Texas | 48117 | 2787 | 66 |
1238015 | 1238015 | 2021-04-19 | Deaf Smith | Texas | 48117 | 2786 | 66 |
1234768 | 1234768 | 2021-04-18 | Deaf Smith | Texas | 48117 | 2786 | 66 |
1231520 | 1231520 | 2021-04-17 | Deaf Smith | Texas | 48117 | 2786 | 66 |
1228272 | 1228272 | 2021-04-16 | Deaf Smith | Texas | 48117 | 2776 | 66 |
1225024 | 1225024 | 2021-04-15 | Deaf Smith | Texas | 48117 | 2774 | 66 |
1221777 | 1221777 | 2021-04-14 | Deaf Smith | Texas | 48117 | 2773 | 66 |
1218529 | 1218529 | 2021-04-13 | Deaf Smith | Texas | 48117 | 2774 | 66 |
1215281 | 1215281 | 2021-04-12 | Deaf Smith | Texas | 48117 | 2760 | 66 |
1212034 | 1212034 | 2021-04-11 | Deaf Smith | Texas | 48117 | 2760 | 66 |
1208785 | 1208785 | 2021-04-10 | Deaf Smith | Texas | 48117 | 2760 | 66 |
1205537 | 1205537 | 2021-04-09 | Deaf Smith | Texas | 48117 | 2760 | 66 |
1202289 | 1202289 | 2021-04-08 | Deaf Smith | Texas | 48117 | 2760 | 65 |
1199040 | 1199040 | 2021-04-07 | Deaf Smith | Texas | 48117 | 2760 | 65 |
1195791 | 1195791 | 2021-04-06 | Deaf Smith | Texas | 48117 | 2760 | 65 |
1192543 | 1192543 | 2021-04-05 | Deaf Smith | Texas | 48117 | 2760 | 65 |
1189294 | 1189294 | 2021-04-04 | Deaf Smith | Texas | 48117 | 2760 | 65 |
1186047 | 1186047 | 2021-04-03 | Deaf Smith | Texas | 48117 | 2760 | 65 |
1182800 | 1182800 | 2021-04-02 | Deaf Smith | Texas | 48117 | 2760 | 64 |
1179553 | 1179553 | 2021-04-01 | Deaf Smith | Texas | 48117 | 2760 | 64 |
1176306 | 1176306 | 2021-03-31 | Deaf Smith | Texas | 48117 | 2760 | 64 |
1173059 | 1173059 | 2021-03-30 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1169812 | 1169812 | 2021-03-29 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1166564 | 1166564 | 2021-03-28 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1163316 | 1163316 | 2021-03-27 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1160067 | 1160067 | 2021-03-26 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1156820 | 1156820 | 2021-03-25 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1153573 | 1153573 | 2021-03-24 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1150326 | 1150326 | 2021-03-23 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1147079 | 1147079 | 2021-03-22 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1143832 | 1143832 | 2021-03-21 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1140585 | 1140585 | 2021-03-20 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1137339 | 1137339 | 2021-03-19 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1134093 | 1134093 | 2021-03-18 | Deaf Smith | Texas | 48117 | 2746 | 64 |
1130845 | 1130845 | 2021-03-17 | Deaf Smith | Texas | 48117 | 2734 | 64 |
1127598 | 1127598 | 2021-03-16 | Deaf Smith | Texas | 48117 | 2734 | 64 |
1124352 | 1124352 | 2021-03-15 | Deaf Smith | Texas | 48117 | 2734 | 64 |
1121106 | 1121106 | 2021-03-14 | Deaf Smith | Texas | 48117 | 2734 | 64 |
1117859 | 1117859 | 2021-03-13 | Deaf Smith | Texas | 48117 | 2734 | 64 |
1114612 | 1114612 | 2021-03-12 | Deaf Smith | Texas | 48117 | 2734 | 64 |
1111366 | 1111366 | 2021-03-11 | Deaf Smith | Texas | 48117 | 2734 | 64 |
1108120 | 1108120 | 2021-03-10 | Deaf Smith | Texas | 48117 | 2734 | 64 |
1104874 | 1104874 | 2021-03-09 | Deaf Smith | Texas | 48117 | 2724 | 64 |
1101628 | 1101628 | 2021-03-08 | Deaf Smith | Texas | 48117 | 2724 | 64 |
1098382 | 1098382 | 2021-03-07 | Deaf Smith | Texas | 48117 | 2724 | 64 |
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);