ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
8,543 rows where county = "Crawford" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635313 | 635313 | 2020-10-16 | Crawford | Georgia | 13079 | 205 | 6 |
635500 | 635500 | 2020-10-16 | Crawford | Illinois | 17033 | 608 | 6 |
635599 | 635599 | 2020-10-16 | Crawford | Indiana | 18025 | 139 | 2 |
635702 | 635702 | 2020-10-16 | Crawford | Iowa | 19047 | 1292 | 12 |
635797 | 635797 | 2020-10-16 | Crawford | Kansas | 20037 | 1326 | 8 |
636146 | 636146 | 2020-10-16 | Crawford | Michigan | 26039 | 136 | 5 |
636408 | 636408 | 2020-10-16 | Crawford | Missouri | 29055 | 518 | 6 |
636960 | 636960 | 2020-10-16 | Crawford | Ohio | 39033 | 376 | 8 |
637165 | 637165 | 2020-10-16 | Crawford | Pennsylvania | 42039 | 374 | 3 |
638045 | 638045 | 2020-10-16 | Crawford | Wisconsin | 55023 | 291 | 0 |
631765 | 631765 | 2020-10-15 | Crawford | Arkansas | 5033 | 1803 | 22 |
632067 | 632067 | 2020-10-15 | Crawford | Georgia | 13079 | 203 | 6 |
632254 | 632254 | 2020-10-15 | Crawford | Illinois | 17033 | 604 | 6 |
632353 | 632353 | 2020-10-15 | Crawford | Indiana | 18025 | 135 | 2 |
632456 | 632456 | 2020-10-15 | Crawford | Iowa | 19047 | 1281 | 12 |
632551 | 632551 | 2020-10-15 | Crawford | Kansas | 20037 | 1294 | 8 |
632900 | 632900 | 2020-10-15 | Crawford | Michigan | 26039 | 132 | 5 |
633162 | 633162 | 2020-10-15 | Crawford | Missouri | 29055 | 511 | 6 |
633714 | 633714 | 2020-10-15 | Crawford | Ohio | 39033 | 365 | 7 |
633919 | 633919 | 2020-10-15 | Crawford | Pennsylvania | 42039 | 366 | 3 |
634800 | 634800 | 2020-10-15 | Crawford | Wisconsin | 55023 | 275 | 0 |
628521 | 628521 | 2020-10-14 | Crawford | Arkansas | 5033 | 1778 | 22 |
628823 | 628823 | 2020-10-14 | Crawford | Georgia | 13079 | 202 | 6 |
629010 | 629010 | 2020-10-14 | Crawford | Illinois | 17033 | 589 | 6 |
629109 | 629109 | 2020-10-14 | Crawford | Indiana | 18025 | 134 | 2 |
629212 | 629212 | 2020-10-14 | Crawford | Iowa | 19047 | 1269 | 12 |
629307 | 629307 | 2020-10-14 | Crawford | Kansas | 20037 | 1294 | 8 |
629655 | 629655 | 2020-10-14 | Crawford | Michigan | 26039 | 132 | 5 |
629917 | 629917 | 2020-10-14 | Crawford | Missouri | 29055 | 500 | 6 |
630469 | 630469 | 2020-10-14 | Crawford | Ohio | 39033 | 353 | 7 |
630674 | 630674 | 2020-10-14 | Crawford | Pennsylvania | 42039 | 359 | 3 |
631555 | 631555 | 2020-10-14 | Crawford | Wisconsin | 55023 | 268 | 0 |
625278 | 625278 | 2020-10-13 | Crawford | Arkansas | 5033 | 1758 | 22 |
625580 | 625580 | 2020-10-13 | Crawford | Georgia | 13079 | 200 | 6 |
625767 | 625767 | 2020-10-13 | Crawford | Illinois | 17033 | 576 | 6 |
625866 | 625866 | 2020-10-13 | Crawford | Indiana | 18025 | 134 | 2 |
625969 | 625969 | 2020-10-13 | Crawford | Iowa | 19047 | 1256 | 11 |
626064 | 626064 | 2020-10-13 | Crawford | Kansas | 20037 | 1256 | 8 |
626411 | 626411 | 2020-10-13 | Crawford | Michigan | 26039 | 132 | 5 |
626673 | 626673 | 2020-10-13 | Crawford | Missouri | 29055 | 481 | 7 |
627225 | 627225 | 2020-10-13 | Crawford | Ohio | 39033 | 330 | 6 |
627430 | 627430 | 2020-10-13 | Crawford | Pennsylvania | 42039 | 356 | 3 |
628311 | 628311 | 2020-10-13 | Crawford | Wisconsin | 55023 | 261 | 0 |
622035 | 622035 | 2020-10-12 | Crawford | Arkansas | 5033 | 1750 | 21 |
622337 | 622337 | 2020-10-12 | Crawford | Georgia | 13079 | 200 | 6 |
622525 | 622525 | 2020-10-12 | Crawford | Illinois | 17033 | 572 | 6 |
622624 | 622624 | 2020-10-12 | Crawford | Indiana | 18025 | 131 | 2 |
622727 | 622727 | 2020-10-12 | Crawford | Iowa | 19047 | 1240 | 11 |
622822 | 622822 | 2020-10-12 | Crawford | Kansas | 20037 | 1256 | 8 |
623169 | 623169 | 2020-10-12 | Crawford | Michigan | 26039 | 132 | 5 |
623431 | 623431 | 2020-10-12 | Crawford | Missouri | 29055 | 481 | 7 |
623983 | 623983 | 2020-10-12 | Crawford | Ohio | 39033 | 326 | 6 |
624188 | 624188 | 2020-10-12 | Crawford | Pennsylvania | 42039 | 355 | 3 |
625068 | 625068 | 2020-10-12 | Crawford | Wisconsin | 55023 | 248 | 0 |
618792 | 618792 | 2020-10-11 | Crawford | Arkansas | 5033 | 1736 | 21 |
619094 | 619094 | 2020-10-11 | Crawford | Georgia | 13079 | 199 | 6 |
619281 | 619281 | 2020-10-11 | Crawford | Illinois | 17033 | 561 | 6 |
619380 | 619380 | 2020-10-11 | Crawford | Indiana | 18025 | 129 | 2 |
619483 | 619483 | 2020-10-11 | Crawford | Iowa | 19047 | 1225 | 11 |
619578 | 619578 | 2020-10-11 | Crawford | Kansas | 20037 | 1223 | 8 |
619926 | 619926 | 2020-10-11 | Crawford | Michigan | 26039 | 129 | 5 |
620188 | 620188 | 2020-10-11 | Crawford | Missouri | 29055 | 481 | 7 |
620740 | 620740 | 2020-10-11 | Crawford | Ohio | 39033 | 317 | 6 |
620945 | 620945 | 2020-10-11 | Crawford | Pennsylvania | 42039 | 345 | 3 |
621825 | 621825 | 2020-10-11 | Crawford | Wisconsin | 55023 | 246 | 0 |
615550 | 615550 | 2020-10-10 | Crawford | Arkansas | 5033 | 1704 | 20 |
615852 | 615852 | 2020-10-10 | Crawford | Georgia | 13079 | 196 | 6 |
616039 | 616039 | 2020-10-10 | Crawford | Illinois | 17033 | 544 | 6 |
616138 | 616138 | 2020-10-10 | Crawford | Indiana | 18025 | 128 | 2 |
616241 | 616241 | 2020-10-10 | Crawford | Iowa | 19047 | 1226 | 11 |
616336 | 616336 | 2020-10-10 | Crawford | Kansas | 20037 | 1223 | 8 |
616684 | 616684 | 2020-10-10 | Crawford | Michigan | 26039 | 129 | 5 |
616946 | 616946 | 2020-10-10 | Crawford | Missouri | 29055 | 481 | 7 |
617498 | 617498 | 2020-10-10 | Crawford | Ohio | 39033 | 314 | 6 |
617702 | 617702 | 2020-10-10 | Crawford | Pennsylvania | 42039 | 342 | 3 |
618582 | 618582 | 2020-10-10 | Crawford | Wisconsin | 55023 | 244 | 0 |
612309 | 612309 | 2020-10-09 | Crawford | Arkansas | 5033 | 1683 | 20 |
612611 | 612611 | 2020-10-09 | Crawford | Georgia | 13079 | 194 | 6 |
612798 | 612798 | 2020-10-09 | Crawford | Illinois | 17033 | 539 | 6 |
612897 | 612897 | 2020-10-09 | Crawford | Indiana | 18025 | 124 | 2 |
613000 | 613000 | 2020-10-09 | Crawford | Iowa | 19047 | 1218 | 10 |
613095 | 613095 | 2020-10-09 | Crawford | Kansas | 20037 | 1223 | 8 |
613443 | 613443 | 2020-10-09 | Crawford | Michigan | 26039 | 129 | 5 |
613705 | 613705 | 2020-10-09 | Crawford | Missouri | 29055 | 451 | 7 |
614256 | 614256 | 2020-10-09 | Crawford | Ohio | 39033 | 305 | 6 |
614460 | 614460 | 2020-10-09 | Crawford | Pennsylvania | 42039 | 336 | 3 |
615340 | 615340 | 2020-10-09 | Crawford | Wisconsin | 55023 | 233 | 0 |
609067 | 609067 | 2020-10-08 | Crawford | Arkansas | 5033 | 1655 | 20 |
609369 | 609369 | 2020-10-08 | Crawford | Georgia | 13079 | 192 | 5 |
609556 | 609556 | 2020-10-08 | Crawford | Illinois | 17033 | 525 | 6 |
609655 | 609655 | 2020-10-08 | Crawford | Indiana | 18025 | 124 | 2 |
609758 | 609758 | 2020-10-08 | Crawford | Iowa | 19047 | 1189 | 9 |
609853 | 609853 | 2020-10-08 | Crawford | Kansas | 20037 | 1191 | 8 |
610201 | 610201 | 2020-10-08 | Crawford | Michigan | 26039 | 128 | 5 |
610463 | 610463 | 2020-10-08 | Crawford | Missouri | 29055 | 443 | 5 |
611015 | 611015 | 2020-10-08 | Crawford | Ohio | 39033 | 294 | 6 |
611219 | 611219 | 2020-10-08 | Crawford | Pennsylvania | 42039 | 334 | 3 |
612099 | 612099 | 2020-10-08 | Crawford | Wisconsin | 55023 | 226 | 0 |
605824 | 605824 | 2020-10-07 | Crawford | Arkansas | 5033 | 1603 | 20 |
606126 | 606126 | 2020-10-07 | Crawford | Georgia | 13079 | 188 | 5 |
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);