ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Gregg" and state = "Texas" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1280258 | 1280258 | 2021-05-02 | Gregg | Texas | 48183 | 11098 | 352 |
1277011 | 1277011 | 2021-05-01 | Gregg | Texas | 48183 | 11098 | 353 |
1273764 | 1273764 | 2021-04-30 | Gregg | Texas | 48183 | 11098 | 353 |
1270517 | 1270517 | 2021-04-29 | Gregg | Texas | 48183 | 11066 | 353 |
1267270 | 1267270 | 2021-04-28 | Gregg | Texas | 48183 | 11066 | 353 |
1264023 | 1264023 | 2021-04-27 | Gregg | Texas | 48183 | 11066 | 353 |
1260776 | 1260776 | 2021-04-26 | Gregg | Texas | 48183 | 11038 | 352 |
1257529 | 1257529 | 2021-04-25 | Gregg | Texas | 48183 | 11038 | 351 |
1254282 | 1254282 | 2021-04-24 | Gregg | Texas | 48183 | 11038 | 351 |
1251035 | 1251035 | 2021-04-23 | Gregg | Texas | 48183 | 11038 | 351 |
1247788 | 1247788 | 2021-04-22 | Gregg | Texas | 48183 | 11038 | 351 |
1244541 | 1244541 | 2021-04-21 | Gregg | Texas | 48183 | 11014 | 351 |
1241294 | 1241294 | 2021-04-20 | Gregg | Texas | 48183 | 11014 | 351 |
1238047 | 1238047 | 2021-04-19 | Gregg | Texas | 48183 | 10991 | 351 |
1234800 | 1234800 | 2021-04-18 | Gregg | Texas | 48183 | 10991 | 351 |
1231552 | 1231552 | 2021-04-17 | Gregg | Texas | 48183 | 10991 | 351 |
1228304 | 1228304 | 2021-04-16 | Gregg | Texas | 48183 | 10991 | 351 |
1225056 | 1225056 | 2021-04-15 | Gregg | Texas | 48183 | 10991 | 351 |
1221809 | 1221809 | 2021-04-14 | Gregg | Texas | 48183 | 10969 | 351 |
1218561 | 1218561 | 2021-04-13 | Gregg | Texas | 48183 | 10969 | 352 |
1215313 | 1215313 | 2021-04-12 | Gregg | Texas | 48183 | 10969 | 352 |
1212066 | 1212066 | 2021-04-11 | Gregg | Texas | 48183 | 10942 | 352 |
1208817 | 1208817 | 2021-04-10 | Gregg | Texas | 48183 | 10942 | 351 |
1205569 | 1205569 | 2021-04-09 | Gregg | Texas | 48183 | 10942 | 351 |
1202321 | 1202321 | 2021-04-08 | Gregg | Texas | 48183 | 10942 | 350 |
1199072 | 1199072 | 2021-04-07 | Gregg | Texas | 48183 | 10925 | 350 |
1195823 | 1195823 | 2021-04-06 | Gregg | Texas | 48183 | 10925 | 350 |
1192575 | 1192575 | 2021-04-05 | Gregg | Texas | 48183 | 10925 | 346 |
1189326 | 1189326 | 2021-04-04 | Gregg | Texas | 48183 | 10906 | 346 |
1186079 | 1186079 | 2021-04-03 | Gregg | Texas | 48183 | 10906 | 346 |
1182832 | 1182832 | 2021-04-02 | Gregg | Texas | 48183 | 10906 | 346 |
1179585 | 1179585 | 2021-04-01 | Gregg | Texas | 48183 | 10906 | 346 |
1176338 | 1176338 | 2021-03-31 | Gregg | Texas | 48183 | 10891 | 344 |
1173091 | 1173091 | 2021-03-30 | Gregg | Texas | 48183 | 10891 | 344 |
1169844 | 1169844 | 2021-03-29 | Gregg | Texas | 48183 | 10891 | 343 |
1166596 | 1166596 | 2021-03-28 | Gregg | Texas | 48183 | 10872 | 343 |
1163348 | 1163348 | 2021-03-27 | Gregg | Texas | 48183 | 10872 | 342 |
1160099 | 1160099 | 2021-03-26 | Gregg | Texas | 48183 | 10872 | 341 |
1156852 | 1156852 | 2021-03-25 | Gregg | Texas | 48183 | 10872 | 341 |
1153605 | 1153605 | 2021-03-24 | Gregg | Texas | 48183 | 10843 | 339 |
1150358 | 1150358 | 2021-03-23 | Gregg | Texas | 48183 | 10843 | 338 |
1147111 | 1147111 | 2021-03-22 | Gregg | Texas | 48183 | 10843 | 338 |
1143864 | 1143864 | 2021-03-21 | Gregg | Texas | 48183 | 10826 | 338 |
1140617 | 1140617 | 2021-03-20 | Gregg | Texas | 48183 | 10826 | 338 |
1137371 | 1137371 | 2021-03-19 | Gregg | Texas | 48183 | 10826 | 338 |
1134125 | 1134125 | 2021-03-18 | Gregg | Texas | 48183 | 10814 | 338 |
1130877 | 1130877 | 2021-03-17 | Gregg | Texas | 48183 | 10814 | 336 |
1127630 | 1127630 | 2021-03-16 | Gregg | Texas | 48183 | 10805 | 335 |
1124384 | 1124384 | 2021-03-15 | Gregg | Texas | 48183 | 10805 | 334 |
1121138 | 1121138 | 2021-03-14 | Gregg | Texas | 48183 | 10769 | 333 |
1117891 | 1117891 | 2021-03-13 | Gregg | Texas | 48183 | 10769 | 333 |
1114644 | 1114644 | 2021-03-12 | Gregg | Texas | 48183 | 10769 | 333 |
1111398 | 1111398 | 2021-03-11 | Gregg | Texas | 48183 | 10761 | 328 |
1108152 | 1108152 | 2021-03-10 | Gregg | Texas | 48183 | 10743 | 326 |
1104906 | 1104906 | 2021-03-09 | Gregg | Texas | 48183 | 10743 | 325 |
1101660 | 1101660 | 2021-03-08 | Gregg | Texas | 48183 | 10743 | 325 |
1098414 | 1098414 | 2021-03-07 | Gregg | Texas | 48183 | 10731 | 324 |
1095166 | 1095166 | 2021-03-06 | Gregg | Texas | 48183 | 10731 | 323 |
1091920 | 1091920 | 2021-03-05 | Gregg | Texas | 48183 | 10731 | 322 |
1088674 | 1088674 | 2021-03-04 | Gregg | Texas | 48183 | 10710 | 319 |
1085429 | 1085429 | 2021-03-03 | Gregg | Texas | 48183 | 10710 | 313 |
1082183 | 1082183 | 2021-03-02 | Gregg | Texas | 48183 | 10693 | 309 |
1078937 | 1078937 | 2021-03-01 | Gregg | Texas | 48183 | 10693 | 308 |
1075692 | 1075692 | 2021-02-28 | Gregg | Texas | 48183 | 10669 | 308 |
1072446 | 1072446 | 2021-02-27 | Gregg | Texas | 48183 | 10669 | 305 |
1069200 | 1069200 | 2021-02-26 | Gregg | Texas | 48183 | 10669 | 301 |
1065955 | 1065955 | 2021-02-25 | Gregg | Texas | 48183 | 10638 | 299 |
1062710 | 1062710 | 2021-02-24 | Gregg | Texas | 48183 | 10591 | 296 |
1059465 | 1059465 | 2021-02-23 | Gregg | Texas | 48183 | 10591 | 294 |
1056219 | 1056219 | 2021-02-22 | Gregg | Texas | 48183 | 10591 | 293 |
1052973 | 1052973 | 2021-02-21 | Gregg | Texas | 48183 | 10561 | 293 |
1049726 | 1049726 | 2021-02-20 | Gregg | Texas | 48183 | 10561 | 292 |
1046479 | 1046479 | 2021-02-19 | Gregg | Texas | 48183 | 10561 | 292 |
1043234 | 1043234 | 2021-02-18 | Gregg | Texas | 48183 | 10555 | 291 |
1039989 | 1039989 | 2021-02-17 | Gregg | Texas | 48183 | 10555 | 291 |
1036744 | 1036744 | 2021-02-16 | Gregg | Texas | 48183 | 10518 | 289 |
1033499 | 1033499 | 2021-02-15 | Gregg | Texas | 48183 | 10449 | 289 |
1030253 | 1030253 | 2021-02-14 | Gregg | Texas | 48183 | 10449 | 289 |
1027006 | 1027006 | 2021-02-13 | Gregg | Texas | 48183 | 10449 | 288 |
1023761 | 1023761 | 2021-02-12 | Gregg | Texas | 48183 | 10449 | 286 |
1020516 | 1020516 | 2021-02-11 | Gregg | Texas | 48183 | 10384 | 283 |
1017271 | 1017271 | 2021-02-10 | Gregg | Texas | 48183 | 10384 | 277 |
1014026 | 1014026 | 2021-02-09 | Gregg | Texas | 48183 | 10248 | 275 |
1010781 | 1010781 | 2021-02-08 | Gregg | Texas | 48183 | 10248 | 275 |
1007535 | 1007535 | 2021-02-07 | Gregg | Texas | 48183 | 10082 | 274 |
1004289 | 1004289 | 2021-02-06 | Gregg | Texas | 48183 | 10082 | 271 |
1001043 | 1001043 | 2021-02-05 | Gregg | Texas | 48183 | 10082 | 268 |
997797 | 997797 | 2021-02-04 | Gregg | Texas | 48183 | 9941 | 266 |
994551 | 994551 | 2021-02-03 | Gregg | Texas | 48183 | 9941 | 261 |
991305 | 991305 | 2021-02-02 | Gregg | Texas | 48183 | 9839 | 256 |
988059 | 988059 | 2021-02-01 | Gregg | Texas | 48183 | 9839 | 255 |
984812 | 984812 | 2021-01-31 | Gregg | Texas | 48183 | 9724 | 255 |
981565 | 981565 | 2021-01-30 | Gregg | Texas | 48183 | 9724 | 255 |
978319 | 978319 | 2021-01-29 | Gregg | Texas | 48183 | 9627 | 254 |
975074 | 975074 | 2021-01-28 | Gregg | Texas | 48183 | 9627 | 253 |
971829 | 971829 | 2021-01-27 | Gregg | Texas | 48183 | 9409 | 252 |
968584 | 968584 | 2021-01-26 | Gregg | Texas | 48183 | 9409 | 250 |
965340 | 965340 | 2021-01-25 | Gregg | Texas | 48183 | 9125 | 249 |
962095 | 962095 | 2021-01-24 | Gregg | Texas | 48183 | 9125 | 249 |
958850 | 958850 | 2021-01-23 | Gregg | Texas | 48183 | 9125 | 249 |
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);