ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
822 rows where fips = 48029 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280181 | 1280181 | 2021-05-02 | Bexar | Texas | 48029 | 217498 | 3485 |
1276934 | 1276934 | 2021-05-01 | Bexar | Texas | 48029 | 217498 | 3485 |
1273687 | 1273687 | 2021-04-30 | Bexar | Texas | 48029 | 217498 | 3478 |
1270440 | 1270440 | 2021-04-29 | Bexar | Texas | 48029 | 217231 | 3472 |
1267193 | 1267193 | 2021-04-28 | Bexar | Texas | 48029 | 216890 | 3468 |
1263946 | 1263946 | 2021-04-27 | Bexar | Texas | 48029 | 216488 | 3461 |
1260699 | 1260699 | 2021-04-26 | Bexar | Texas | 48029 | 216351 | 3450 |
1257452 | 1257452 | 2021-04-25 | Bexar | Texas | 48029 | 214711 | 3450 |
1254205 | 1254205 | 2021-04-24 | Bexar | Texas | 48029 | 214711 | 3450 |
1250958 | 1250958 | 2021-04-23 | Bexar | Texas | 48029 | 214711 | 3446 |
1247711 | 1247711 | 2021-04-22 | Bexar | Texas | 48029 | 214643 | 3441 |
1244464 | 1244464 | 2021-04-21 | Bexar | Texas | 48029 | 214394 | 3437 |
1241217 | 1241217 | 2021-04-20 | Bexar | Texas | 48029 | 214083 | 3422 |
1237970 | 1237970 | 2021-04-19 | Bexar | Texas | 48029 | 213689 | 3422 |
1234723 | 1234723 | 2021-04-18 | Bexar | Texas | 48029 | 211434 | 3422 |
1231475 | 1231475 | 2021-04-17 | Bexar | Texas | 48029 | 211434 | 3422 |
1228227 | 1228227 | 2021-04-16 | Bexar | Texas | 48029 | 211434 | 3416 |
1224979 | 1224979 | 2021-04-15 | Bexar | Texas | 48029 | 211409 | 3413 |
1221732 | 1221732 | 2021-04-14 | Bexar | Texas | 48029 | 211333 | 3408 |
1218484 | 1218484 | 2021-04-13 | Bexar | Texas | 48029 | 211081 | 3403 |
1215236 | 1215236 | 2021-04-12 | Bexar | Texas | 48029 | 210808 | 3398 |
1211989 | 1211989 | 2021-04-11 | Bexar | Texas | 48029 | 208864 | 3398 |
1208740 | 1208740 | 2021-04-10 | Bexar | Texas | 48029 | 208864 | 3398 |
1205492 | 1205492 | 2021-04-09 | Bexar | Texas | 48029 | 208864 | 3389 |
1202244 | 1202244 | 2021-04-08 | Bexar | Texas | 48029 | 208618 | 3377 |
1198995 | 1198995 | 2021-04-07 | Bexar | Texas | 48029 | 208474 | 3366 |
1195746 | 1195746 | 2021-04-06 | Bexar | Texas | 48029 | 208184 | 3360 |
1192498 | 1192498 | 2021-04-05 | Bexar | Texas | 48029 | 207961 | 3350 |
1189249 | 1189249 | 2021-04-04 | Bexar | Texas | 48029 | 205789 | 3350 |
1186002 | 1186002 | 2021-04-03 | Bexar | Texas | 48029 | 205789 | 3349 |
1182755 | 1182755 | 2021-04-02 | Bexar | Texas | 48029 | 205789 | 3335 |
1179508 | 1179508 | 2021-04-01 | Bexar | Texas | 48029 | 205789 | 3319 |
1176261 | 1176261 | 2021-03-31 | Bexar | Texas | 48029 | 205540 | 3308 |
1173014 | 1173014 | 2021-03-30 | Bexar | Texas | 48029 | 205418 | 3304 |
1169767 | 1169767 | 2021-03-29 | Bexar | Texas | 48029 | 205270 | 3299 |
1166519 | 1166519 | 2021-03-28 | Bexar | Texas | 48029 | 205111 | 3299 |
1163271 | 1163271 | 2021-03-27 | Bexar | Texas | 48029 | 203535 | 3288 |
1160022 | 1160022 | 2021-03-26 | Bexar | Texas | 48029 | 203382 | 3275 |
1156775 | 1156775 | 2021-03-25 | Bexar | Texas | 48029 | 203203 | 3266 |
1153528 | 1153528 | 2021-03-24 | Bexar | Texas | 48029 | 202993 | 3247 |
1150281 | 1150281 | 2021-03-23 | Bexar | Texas | 48029 | 202861 | 3225 |
1147034 | 1147034 | 2021-03-22 | Bexar | Texas | 48029 | 202728 | 3218 |
1143787 | 1143787 | 2021-03-21 | Bexar | Texas | 48029 | 202562 | 3216 |
1140540 | 1140540 | 2021-03-20 | Bexar | Texas | 48029 | 201704 | 3210 |
1137294 | 1137294 | 2021-03-19 | Bexar | Texas | 48029 | 201423 | 3192 |
1134048 | 1134048 | 2021-03-18 | Bexar | Texas | 48029 | 201285 | 3173 |
1130800 | 1130800 | 2021-03-17 | Bexar | Texas | 48029 | 201208 | 3158 |
1127553 | 1127553 | 2021-03-16 | Bexar | Texas | 48029 | 201022 | 3140 |
1124307 | 1124307 | 2021-03-15 | Bexar | Texas | 48029 | 200830 | 3131 |
1121061 | 1121061 | 2021-03-14 | Bexar | Texas | 48029 | 200676 | 3130 |
1117814 | 1117814 | 2021-03-13 | Bexar | Texas | 48029 | 199685 | 3124 |
1114567 | 1114567 | 2021-03-12 | Bexar | Texas | 48029 | 199601 | 3112 |
1111321 | 1111321 | 2021-03-11 | Bexar | Texas | 48029 | 199443 | 3096 |
1108075 | 1108075 | 2021-03-10 | Bexar | Texas | 48029 | 199077 | 3071 |
1104829 | 1104829 | 2021-03-09 | Bexar | Texas | 48029 | 198981 | 3055 |
1101583 | 1101583 | 2021-03-08 | Bexar | Texas | 48029 | 198810 | 3041 |
1098337 | 1098337 | 2021-03-07 | Bexar | Texas | 48029 | 198580 | 3038 |
1095089 | 1095089 | 2021-03-06 | Bexar | Texas | 48029 | 197933 | 3032 |
1091843 | 1091843 | 2021-03-05 | Bexar | Texas | 48029 | 197796 | 3008 |
1088597 | 1088597 | 2021-03-04 | Bexar | Texas | 48029 | 197509 | 2982 |
1085352 | 1085352 | 2021-03-03 | Bexar | Texas | 48029 | 197267 | 2953 |
1082106 | 1082106 | 2021-03-02 | Bexar | Texas | 48029 | 197077 | 2931 |
1078860 | 1078860 | 2021-03-01 | Bexar | Texas | 48029 | 196828 | 2897 |
1075615 | 1075615 | 2021-02-28 | Bexar | Texas | 48029 | 196540 | 2894 |
1072369 | 1072369 | 2021-02-27 | Bexar | Texas | 48029 | 195731 | 2885 |
1069123 | 1069123 | 2021-02-26 | Bexar | Texas | 48029 | 195249 | 2873 |
1065878 | 1065878 | 2021-02-25 | Bexar | Texas | 48029 | 194748 | 2842 |
1062633 | 1062633 | 2021-02-24 | Bexar | Texas | 48029 | 194344 | 2812 |
1059388 | 1059388 | 2021-02-23 | Bexar | Texas | 48029 | 193973 | 2777 |
1056142 | 1056142 | 2021-02-22 | Bexar | Texas | 48029 | 193703 | 2763 |
1052896 | 1052896 | 2021-02-21 | Bexar | Texas | 48029 | 193473 | 2752 |
1049649 | 1049649 | 2021-02-20 | Bexar | Texas | 48029 | 189975 | 2731 |
1046402 | 1046402 | 2021-02-19 | Bexar | Texas | 48029 | 187758 | 2713 |
1043157 | 1043157 | 2021-02-18 | Bexar | Texas | 48029 | 187758 | 2707 |
1039912 | 1039912 | 2021-02-17 | Bexar | Texas | 48029 | 187758 | 2695 |
1036667 | 1036667 | 2021-02-16 | Bexar | Texas | 48029 | 187758 | 2690 |
1033422 | 1033422 | 2021-02-15 | Bexar | Texas | 48029 | 187758 | 2687 |
1030176 | 1030176 | 2021-02-14 | Bexar | Texas | 48029 | 187758 | 2681 |
1026929 | 1026929 | 2021-02-13 | Bexar | Texas | 48029 | 187758 | 2670 |
1023684 | 1023684 | 2021-02-12 | Bexar | Texas | 48029 | 187074 | 2646 |
1020439 | 1020439 | 2021-02-11 | Bexar | Texas | 48029 | 186358 | 2611 |
1017194 | 1017194 | 2021-02-10 | Bexar | Texas | 48029 | 185456 | 2591 |
1013949 | 1013949 | 2021-02-09 | Bexar | Texas | 48029 | 184796 | 2557 |
1010704 | 1010704 | 2021-02-08 | Bexar | Texas | 48029 | 183448 | 2534 |
1007458 | 1007458 | 2021-02-07 | Bexar | Texas | 48029 | 183213 | 2527 |
1004212 | 1004212 | 2021-02-06 | Bexar | Texas | 48029 | 181023 | 2509 |
1000966 | 1000966 | 2021-02-05 | Bexar | Texas | 48029 | 180398 | 2474 |
997720 | 997720 | 2021-02-04 | Bexar | Texas | 48029 | 178674 | 2441 |
994474 | 994474 | 2021-02-03 | Bexar | Texas | 48029 | 177814 | 2416 |
991228 | 991228 | 2021-02-02 | Bexar | Texas | 48029 | 176802 | 2380 |
987982 | 987982 | 2021-02-01 | Bexar | Texas | 48029 | 175542 | 2349 |
984735 | 984735 | 2021-01-31 | Bexar | Texas | 48029 | 173166 | 2348 |
981488 | 981488 | 2021-01-30 | Bexar | Texas | 48029 | 169700 | 2329 |
978242 | 978242 | 2021-01-29 | Bexar | Texas | 48029 | 167579 | 2303 |
974997 | 974997 | 2021-01-28 | Bexar | Texas | 48029 | 166034 | 2262 |
971752 | 971752 | 2021-01-27 | Bexar | Texas | 48029 | 164282 | 2216 |
968507 | 968507 | 2021-01-26 | Bexar | Texas | 48029 | 162941 | 2181 |
965263 | 965263 | 2021-01-25 | Bexar | Texas | 48029 | 162120 | 2161 |
962018 | 962018 | 2021-01-24 | Bexar | Texas | 48029 | 160038 | 2153 |
958773 | 958773 | 2021-01-23 | Bexar | Texas | 48029 | 159531 | 2144 |
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);