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 |
---|---|---|---|---|---|---|---|
920866 | 920866 | 2021-01-12 | Crawford | Georgia | 13079 | 484 | 10 |
921054 | 921054 | 2021-01-12 | Crawford | Illinois | 17033 | 1705 | 32 |
921152 | 921152 | 2021-01-12 | Crawford | Indiana | 18025 | 705 | 10 |
921255 | 921255 | 2021-01-12 | Crawford | Iowa | 19047 | 2260 | 22 |
921350 | 921350 | 2021-01-12 | Crawford | Kansas | 20037 | 3797 | 35 |
921699 | 921699 | 2021-01-12 | Crawford | Michigan | 26039 | 506 | 5 |
921961 | 921961 | 2021-01-12 | Crawford | Missouri | 29055 | 1865 | 21 |
922513 | 922513 | 2021-01-12 | Crawford | Ohio | 39033 | 2999 | 66 |
922718 | 922718 | 2021-01-12 | Crawford | Pennsylvania | 42039 | 5397 | 104 |
923599 | 923599 | 2021-01-12 | Crawford | Wisconsin | 55023 | 1645 | 13 |
917319 | 917319 | 2021-01-11 | Crawford | Arkansas | 5033 | 5201 | 68 |
917621 | 917621 | 2021-01-11 | Crawford | Georgia | 13079 | 481 | 8 |
917809 | 917809 | 2021-01-11 | Crawford | Illinois | 17033 | 1698 | 32 |
917907 | 917907 | 2021-01-11 | Crawford | Indiana | 18025 | 700 | 10 |
918010 | 918010 | 2021-01-11 | Crawford | Iowa | 19047 | 2254 | 22 |
918105 | 918105 | 2021-01-11 | Crawford | Kansas | 20037 | 3797 | 35 |
918454 | 918454 | 2021-01-11 | Crawford | Michigan | 26039 | 504 | 5 |
918716 | 918716 | 2021-01-11 | Crawford | Missouri | 29055 | 1862 | 20 |
919268 | 919268 | 2021-01-11 | Crawford | Ohio | 39033 | 2965 | 66 |
919473 | 919473 | 2021-01-11 | Crawford | Pennsylvania | 42039 | 5370 | 101 |
920354 | 920354 | 2021-01-11 | Crawford | Wisconsin | 55023 | 1640 | 13 |
914074 | 914074 | 2021-01-10 | Crawford | Arkansas | 5033 | 5145 | 66 |
914376 | 914376 | 2021-01-10 | Crawford | Georgia | 13079 | 474 | 8 |
914564 | 914564 | 2021-01-10 | Crawford | Illinois | 17033 | 1685 | 32 |
914662 | 914662 | 2021-01-10 | Crawford | Indiana | 18025 | 696 | 10 |
914765 | 914765 | 2021-01-10 | Crawford | Iowa | 19047 | 2242 | 22 |
914860 | 914860 | 2021-01-10 | Crawford | Kansas | 20037 | 3724 | 34 |
915209 | 915209 | 2021-01-10 | Crawford | Michigan | 26039 | 502 | 5 |
915471 | 915471 | 2021-01-10 | Crawford | Missouri | 29055 | 1855 | 20 |
916023 | 916023 | 2021-01-10 | Crawford | Ohio | 39033 | 2931 | 64 |
916228 | 916228 | 2021-01-10 | Crawford | Pennsylvania | 42039 | 5346 | 101 |
917109 | 917109 | 2021-01-10 | Crawford | Wisconsin | 55023 | 1640 | 13 |
910829 | 910829 | 2021-01-09 | Crawford | Arkansas | 5033 | 5033 | 66 |
911131 | 911131 | 2021-01-09 | Crawford | Georgia | 13079 | 471 | 8 |
911319 | 911319 | 2021-01-09 | Crawford | Illinois | 17033 | 1682 | 32 |
911417 | 911417 | 2021-01-09 | Crawford | Indiana | 18025 | 684 | 10 |
911520 | 911520 | 2021-01-09 | Crawford | Iowa | 19047 | 2235 | 22 |
911615 | 911615 | 2021-01-09 | Crawford | Kansas | 20037 | 3724 | 34 |
911964 | 911964 | 2021-01-09 | Crawford | Michigan | 26039 | 502 | 5 |
912226 | 912226 | 2021-01-09 | Crawford | Missouri | 29055 | 1841 | 20 |
912778 | 912778 | 2021-01-09 | Crawford | Ohio | 39033 | 2909 | 64 |
912983 | 912983 | 2021-01-09 | Crawford | Pennsylvania | 42039 | 5287 | 100 |
913864 | 913864 | 2021-01-09 | Crawford | Wisconsin | 55023 | 1634 | 13 |
907584 | 907584 | 2021-01-08 | Crawford | Arkansas | 5033 | 4987 | 66 |
907886 | 907886 | 2021-01-08 | Crawford | Georgia | 13079 | 466 | 8 |
908074 | 908074 | 2021-01-08 | Crawford | Illinois | 17033 | 1671 | 32 |
908172 | 908172 | 2021-01-08 | Crawford | Indiana | 18025 | 665 | 10 |
908275 | 908275 | 2021-01-08 | Crawford | Iowa | 19047 | 2224 | 22 |
908370 | 908370 | 2021-01-08 | Crawford | Kansas | 20037 | 3724 | 34 |
908719 | 908719 | 2021-01-08 | Crawford | Michigan | 26039 | 501 | 5 |
908981 | 908981 | 2021-01-08 | Crawford | Missouri | 29055 | 1823 | 20 |
909533 | 909533 | 2021-01-08 | Crawford | Ohio | 39033 | 2880 | 63 |
909738 | 909738 | 2021-01-08 | Crawford | Pennsylvania | 42039 | 5208 | 96 |
910619 | 910619 | 2021-01-08 | Crawford | Wisconsin | 55023 | 1634 | 13 |
904338 | 904338 | 2021-01-07 | Crawford | Arkansas | 5033 | 4917 | 66 |
904640 | 904640 | 2021-01-07 | Crawford | Georgia | 13079 | 460 | 8 |
904828 | 904828 | 2021-01-07 | Crawford | Illinois | 17033 | 1660 | 32 |
904926 | 904926 | 2021-01-07 | Crawford | Indiana | 18025 | 660 | 10 |
905029 | 905029 | 2021-01-07 | Crawford | Iowa | 19047 | 2216 | 22 |
905124 | 905124 | 2021-01-07 | Crawford | Kansas | 20037 | 3648 | 34 |
905473 | 905473 | 2021-01-07 | Crawford | Michigan | 26039 | 500 | 5 |
905735 | 905735 | 2021-01-07 | Crawford | Missouri | 29055 | 1796 | 20 |
906288 | 906288 | 2021-01-07 | Crawford | Ohio | 39033 | 2840 | 63 |
906493 | 906493 | 2021-01-07 | Crawford | Pennsylvania | 42039 | 5144 | 92 |
907374 | 907374 | 2021-01-07 | Crawford | Wisconsin | 55023 | 1625 | 13 |
901093 | 901093 | 2021-01-06 | Crawford | Arkansas | 5033 | 4869 | 66 |
901395 | 901395 | 2021-01-06 | Crawford | Georgia | 13079 | 457 | 8 |
901583 | 901583 | 2021-01-06 | Crawford | Illinois | 17033 | 1643 | 30 |
901681 | 901681 | 2021-01-06 | Crawford | Indiana | 18025 | 640 | 10 |
901784 | 901784 | 2021-01-06 | Crawford | Iowa | 19047 | 2199 | 22 |
901879 | 901879 | 2021-01-06 | Crawford | Kansas | 20037 | 3648 | 34 |
902228 | 902228 | 2021-01-06 | Crawford | Michigan | 26039 | 491 | 5 |
902490 | 902490 | 2021-01-06 | Crawford | Missouri | 29055 | 1782 | 20 |
903042 | 903042 | 2021-01-06 | Crawford | Ohio | 39033 | 2789 | 63 |
903247 | 903247 | 2021-01-06 | Crawford | Pennsylvania | 42039 | 5118 | 92 |
904128 | 904128 | 2021-01-06 | Crawford | Wisconsin | 55023 | 1614 | 12 |
897848 | 897848 | 2021-01-05 | Crawford | Arkansas | 5033 | 4799 | 64 |
898150 | 898150 | 2021-01-05 | Crawford | Georgia | 13079 | 454 | 8 |
898338 | 898338 | 2021-01-05 | Crawford | Illinois | 17033 | 1625 | 30 |
898436 | 898436 | 2021-01-05 | Crawford | Indiana | 18025 | 629 | 10 |
898539 | 898539 | 2021-01-05 | Crawford | Iowa | 19047 | 2180 | 22 |
898634 | 898634 | 2021-01-05 | Crawford | Kansas | 20037 | 3537 | 33 |
898983 | 898983 | 2021-01-05 | Crawford | Michigan | 26039 | 490 | 5 |
899245 | 899245 | 2021-01-05 | Crawford | Missouri | 29055 | 1776 | 20 |
899797 | 899797 | 2021-01-05 | Crawford | Ohio | 39033 | 2759 | 62 |
900002 | 900002 | 2021-01-05 | Crawford | Pennsylvania | 42039 | 5072 | 85 |
900883 | 900883 | 2021-01-05 | Crawford | Wisconsin | 55023 | 1609 | 12 |
894603 | 894603 | 2021-01-04 | Crawford | Arkansas | 5033 | 4681 | 62 |
894905 | 894905 | 2021-01-04 | Crawford | Georgia | 13079 | 446 | 8 |
895093 | 895093 | 2021-01-04 | Crawford | Illinois | 17033 | 1594 | 30 |
895191 | 895191 | 2021-01-04 | Crawford | Indiana | 18025 | 624 | 8 |
895294 | 895294 | 2021-01-04 | Crawford | Iowa | 19047 | 2148 | 22 |
895389 | 895389 | 2021-01-04 | Crawford | Kansas | 20037 | 3537 | 33 |
895738 | 895738 | 2021-01-04 | Crawford | Michigan | 26039 | 484 | 5 |
896000 | 896000 | 2021-01-04 | Crawford | Missouri | 29055 | 1765 | 19 |
896552 | 896552 | 2021-01-04 | Crawford | Ohio | 39033 | 2736 | 62 |
896757 | 896757 | 2021-01-04 | Crawford | Pennsylvania | 42039 | 5032 | 85 |
897638 | 897638 | 2021-01-04 | Crawford | Wisconsin | 55023 | 1608 | 12 |
891356 | 891356 | 2021-01-03 | Crawford | Arkansas | 5033 | 4648 | 61 |
891658 | 891658 | 2021-01-03 | Crawford | Georgia | 13079 | 440 | 8 |
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);