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 |
---|---|---|---|---|---|---|---|
534850 | 534850 | 2020-09-15 | Crawford | Georgia | 13079 | 164 | 4 |
535037 | 535037 | 2020-09-15 | Crawford | Illinois | 17033 | 272 | 1 |
535136 | 535136 | 2020-09-15 | Crawford | Indiana | 18025 | 99 | 1 |
535239 | 535239 | 2020-09-15 | Crawford | Iowa | 19047 | 924 | 4 |
535334 | 535334 | 2020-09-15 | Crawford | Kansas | 20037 | 891 | 5 |
535681 | 535681 | 2020-09-15 | Crawford | Michigan | 26039 | 118 | 5 |
535943 | 535943 | 2020-09-15 | Crawford | Missouri | 29055 | 294 | 2 |
536492 | 536492 | 2020-09-15 | Crawford | Ohio | 39033 | 208 | 6 |
536696 | 536696 | 2020-09-15 | Crawford | Pennsylvania | 42039 | 257 | 3 |
537575 | 537575 | 2020-09-15 | Crawford | Wisconsin | 55023 | 136 | 0 |
531314 | 531314 | 2020-09-14 | Crawford | Arkansas | 5033 | 1108 | 11 |
531615 | 531615 | 2020-09-14 | Crawford | Georgia | 13079 | 163 | 5 |
531802 | 531802 | 2020-09-14 | Crawford | Illinois | 17033 | 261 | 1 |
531901 | 531901 | 2020-09-14 | Crawford | Indiana | 18025 | 97 | 1 |
532004 | 532004 | 2020-09-14 | Crawford | Iowa | 19047 | 910 | 4 |
532099 | 532099 | 2020-09-14 | Crawford | Kansas | 20037 | 891 | 5 |
532446 | 532446 | 2020-09-14 | Crawford | Michigan | 26039 | 117 | 5 |
532708 | 532708 | 2020-09-14 | Crawford | Missouri | 29055 | 280 | 2 |
533256 | 533256 | 2020-09-14 | Crawford | Ohio | 39033 | 208 | 6 |
533460 | 533460 | 2020-09-14 | Crawford | Pennsylvania | 42039 | 254 | 3 |
534339 | 534339 | 2020-09-14 | Crawford | Wisconsin | 55023 | 134 | 0 |
528077 | 528077 | 2020-09-13 | Crawford | Arkansas | 5033 | 1088 | 10 |
528378 | 528378 | 2020-09-13 | Crawford | Georgia | 13079 | 163 | 5 |
528565 | 528565 | 2020-09-13 | Crawford | Illinois | 17033 | 255 | 1 |
528664 | 528664 | 2020-09-13 | Crawford | Indiana | 18025 | 95 | 1 |
528767 | 528767 | 2020-09-13 | Crawford | Iowa | 19047 | 909 | 4 |
528862 | 528862 | 2020-09-13 | Crawford | Kansas | 20037 | 855 | 5 |
529210 | 529210 | 2020-09-13 | Crawford | Michigan | 26039 | 116 | 5 |
529472 | 529472 | 2020-09-13 | Crawford | Missouri | 29055 | 249 | 2 |
530021 | 530021 | 2020-09-13 | Crawford | Ohio | 39033 | 208 | 6 |
530225 | 530225 | 2020-09-13 | Crawford | Pennsylvania | 42039 | 245 | 2 |
531104 | 531104 | 2020-09-13 | Crawford | Wisconsin | 55023 | 131 | 0 |
524841 | 524841 | 2020-09-12 | Crawford | Arkansas | 5033 | 1078 | 10 |
525142 | 525142 | 2020-09-12 | Crawford | Georgia | 13079 | 162 | 4 |
525329 | 525329 | 2020-09-12 | Crawford | Illinois | 17033 | 239 | 1 |
525428 | 525428 | 2020-09-12 | Crawford | Indiana | 18025 | 93 | 1 |
525531 | 525531 | 2020-09-12 | Crawford | Iowa | 19047 | 908 | 4 |
525626 | 525626 | 2020-09-12 | Crawford | Kansas | 20037 | 855 | 5 |
525974 | 525974 | 2020-09-12 | Crawford | Michigan | 26039 | 116 | 5 |
526236 | 526236 | 2020-09-12 | Crawford | Missouri | 29055 | 242 | 2 |
526784 | 526784 | 2020-09-12 | Crawford | Ohio | 39033 | 207 | 6 |
526988 | 526988 | 2020-09-12 | Crawford | Pennsylvania | 42039 | 245 | 2 |
527867 | 527867 | 2020-09-12 | Crawford | Wisconsin | 55023 | 130 | 0 |
521605 | 521605 | 2020-09-11 | Crawford | Arkansas | 5033 | 1044 | 10 |
521906 | 521906 | 2020-09-11 | Crawford | Georgia | 13079 | 162 | 4 |
522093 | 522093 | 2020-09-11 | Crawford | Illinois | 17033 | 216 | 1 |
522192 | 522192 | 2020-09-11 | Crawford | Indiana | 18025 | 89 | 1 |
522295 | 522295 | 2020-09-11 | Crawford | Iowa | 19047 | 889 | 4 |
522390 | 522390 | 2020-09-11 | Crawford | Kansas | 20037 | 855 | 5 |
522738 | 522738 | 2020-09-11 | Crawford | Michigan | 26039 | 116 | 5 |
523000 | 523000 | 2020-09-11 | Crawford | Missouri | 29055 | 231 | 2 |
523548 | 523548 | 2020-09-11 | Crawford | Ohio | 39033 | 206 | 6 |
523752 | 523752 | 2020-09-11 | Crawford | Pennsylvania | 42039 | 245 | 2 |
524631 | 524631 | 2020-09-11 | Crawford | Wisconsin | 55023 | 129 | 0 |
518368 | 518368 | 2020-09-10 | Crawford | Arkansas | 5033 | 1009 | 10 |
518669 | 518669 | 2020-09-10 | Crawford | Georgia | 13079 | 162 | 4 |
518856 | 518856 | 2020-09-10 | Crawford | Illinois | 17033 | 204 | 1 |
518955 | 518955 | 2020-09-10 | Crawford | Indiana | 18025 | 82 | 1 |
519058 | 519058 | 2020-09-10 | Crawford | Iowa | 19047 | 881 | 3 |
519153 | 519153 | 2020-09-10 | Crawford | Kansas | 20037 | 816 | 4 |
519501 | 519501 | 2020-09-10 | Crawford | Michigan | 26039 | 116 | 5 |
519763 | 519763 | 2020-09-10 | Crawford | Missouri | 29055 | 225 | 2 |
520312 | 520312 | 2020-09-10 | Crawford | Ohio | 39033 | 206 | 5 |
520516 | 520516 | 2020-09-10 | Crawford | Pennsylvania | 42039 | 241 | 2 |
521395 | 521395 | 2020-09-10 | Crawford | Wisconsin | 55023 | 126 | 0 |
515133 | 515133 | 2020-09-09 | Crawford | Arkansas | 5033 | 1002 | 10 |
515434 | 515434 | 2020-09-09 | Crawford | Georgia | 13079 | 162 | 4 |
515621 | 515621 | 2020-09-09 | Crawford | Illinois | 17033 | 181 | 1 |
515720 | 515720 | 2020-09-09 | Crawford | Indiana | 18025 | 78 | 1 |
515823 | 515823 | 2020-09-09 | Crawford | Iowa | 19047 | 877 | 3 |
515918 | 515918 | 2020-09-09 | Crawford | Kansas | 20037 | 816 | 4 |
516266 | 516266 | 2020-09-09 | Crawford | Michigan | 26039 | 115 | 5 |
516528 | 516528 | 2020-09-09 | Crawford | Missouri | 29055 | 221 | 2 |
517076 | 517076 | 2020-09-09 | Crawford | Ohio | 39033 | 206 | 5 |
517280 | 517280 | 2020-09-09 | Crawford | Pennsylvania | 42039 | 237 | 2 |
518158 | 518158 | 2020-09-09 | Crawford | Wisconsin | 55023 | 126 | 0 |
511900 | 511900 | 2020-09-08 | Crawford | Arkansas | 5033 | 1000 | 10 |
512201 | 512201 | 2020-09-08 | Crawford | Georgia | 13079 | 162 | 4 |
512388 | 512388 | 2020-09-08 | Crawford | Illinois | 17033 | 177 | 1 |
512487 | 512487 | 2020-09-08 | Crawford | Indiana | 18025 | 77 | 1 |
512590 | 512590 | 2020-09-08 | Crawford | Iowa | 19047 | 871 | 3 |
512685 | 512685 | 2020-09-08 | Crawford | Kansas | 20037 | 800 | 4 |
513032 | 513032 | 2020-09-08 | Crawford | Michigan | 26039 | 115 | 5 |
513294 | 513294 | 2020-09-08 | Crawford | Missouri | 29055 | 218 | 2 |
513841 | 513841 | 2020-09-08 | Crawford | Ohio | 39033 | 205 | 5 |
514045 | 514045 | 2020-09-08 | Crawford | Pennsylvania | 42039 | 237 | 2 |
514923 | 514923 | 2020-09-08 | Crawford | Wisconsin | 55023 | 125 | 0 |
508667 | 508667 | 2020-09-07 | Crawford | Arkansas | 5033 | 993 | 9 |
508968 | 508968 | 2020-09-07 | Crawford | Georgia | 13079 | 159 | 4 |
509155 | 509155 | 2020-09-07 | Crawford | Illinois | 17033 | 167 | 1 |
509254 | 509254 | 2020-09-07 | Crawford | Indiana | 18025 | 76 | 1 |
509357 | 509357 | 2020-09-07 | Crawford | Iowa | 19047 | 868 | 3 |
509452 | 509452 | 2020-09-07 | Crawford | Kansas | 20037 | 800 | 4 |
509800 | 509800 | 2020-09-07 | Crawford | Michigan | 26039 | 114 | 5 |
510062 | 510062 | 2020-09-07 | Crawford | Missouri | 29055 | 220 | 2 |
510608 | 510608 | 2020-09-07 | Crawford | Ohio | 39033 | 205 | 5 |
510812 | 510812 | 2020-09-07 | Crawford | Pennsylvania | 42039 | 236 | 2 |
511690 | 511690 | 2020-09-07 | Crawford | Wisconsin | 55023 | 125 | 0 |
505435 | 505435 | 2020-09-06 | Crawford | Arkansas | 5033 | 992 | 9 |
505736 | 505736 | 2020-09-06 | Crawford | Georgia | 13079 | 159 | 4 |
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);