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 |
---|---|---|---|---|---|---|---|
1018420 | 1018420 | 2021-02-11 | Crawford | Illinois | 17033 | 1966 | 37 |
1018519 | 1018519 | 2021-02-11 | Crawford | Indiana | 18025 | 887 | 14 |
1018622 | 1018622 | 2021-02-11 | Crawford | Iowa | 19047 | 2442 | 34 |
1018717 | 1018717 | 2021-02-11 | Crawford | Kansas | 20037 | 4384 | 72 |
1019065 | 1019065 | 2021-02-11 | Crawford | Michigan | 26039 | 569 | 5 |
1019327 | 1019327 | 2021-02-11 | Crawford | Missouri | 29055 | 2019 | 29 |
1019879 | 1019879 | 2021-02-11 | Crawford | Ohio | 39033 | 3461 | 91 |
1020084 | 1020084 | 2021-02-11 | Crawford | Pennsylvania | 42039 | 6131 | 132 |
1020965 | 1020965 | 2021-02-11 | Crawford | Wisconsin | 55023 | 1697 | 17 |
1014685 | 1014685 | 2021-02-10 | Crawford | Arkansas | 5033 | 6558 | 99 |
1014987 | 1014987 | 2021-02-10 | Crawford | Georgia | 13079 | 594 | 13 |
1015175 | 1015175 | 2021-02-10 | Crawford | Illinois | 17033 | 1963 | 37 |
1015274 | 1015274 | 2021-02-10 | Crawford | Indiana | 18025 | 883 | 14 |
1015377 | 1015377 | 2021-02-10 | Crawford | Iowa | 19047 | 2441 | 34 |
1015472 | 1015472 | 2021-02-10 | Crawford | Kansas | 20037 | 4384 | 72 |
1015820 | 1015820 | 2021-02-10 | Crawford | Michigan | 26039 | 570 | 5 |
1016082 | 1016082 | 2021-02-10 | Crawford | Missouri | 29055 | 2017 | 28 |
1016634 | 1016634 | 2021-02-10 | Crawford | Ohio | 39033 | 3451 | 90 |
1016839 | 1016839 | 2021-02-10 | Crawford | Pennsylvania | 42039 | 6107 | 131 |
1017720 | 1017720 | 2021-02-10 | Crawford | Wisconsin | 55023 | 1695 | 17 |
1011440 | 1011440 | 2021-02-09 | Crawford | Arkansas | 5033 | 6544 | 98 |
1011742 | 1011742 | 2021-02-09 | Crawford | Georgia | 13079 | 593 | 13 |
1011930 | 1011930 | 2021-02-09 | Crawford | Illinois | 17033 | 1955 | 37 |
1012029 | 1012029 | 2021-02-09 | Crawford | Indiana | 18025 | 883 | 14 |
1012132 | 1012132 | 2021-02-09 | Crawford | Iowa | 19047 | 2434 | 34 |
1012227 | 1012227 | 2021-02-09 | Crawford | Kansas | 20037 | 4353 | 65 |
1012575 | 1012575 | 2021-02-09 | Crawford | Michigan | 26039 | 569 | 5 |
1012837 | 1012837 | 2021-02-09 | Crawford | Missouri | 29055 | 2013 | 28 |
1013389 | 1013389 | 2021-02-09 | Crawford | Ohio | 39033 | 3437 | 90 |
1013594 | 1013594 | 2021-02-09 | Crawford | Pennsylvania | 42039 | 6096 | 131 |
1014475 | 1014475 | 2021-02-09 | Crawford | Wisconsin | 55023 | 1693 | 17 |
1008194 | 1008194 | 2021-02-08 | Crawford | Arkansas | 5033 | 6516 | 97 |
1008496 | 1008496 | 2021-02-08 | Crawford | Georgia | 13079 | 590 | 13 |
1008684 | 1008684 | 2021-02-08 | Crawford | Illinois | 17033 | 1947 | 37 |
1008783 | 1008783 | 2021-02-08 | Crawford | Indiana | 18025 | 881 | 14 |
1008886 | 1008886 | 2021-02-08 | Crawford | Iowa | 19047 | 2425 | 34 |
1008981 | 1008981 | 2021-02-08 | Crawford | Kansas | 20037 | 4353 | 65 |
1009330 | 1009330 | 2021-02-08 | Crawford | Michigan | 26039 | 567 | 5 |
1009592 | 1009592 | 2021-02-08 | Crawford | Missouri | 29055 | 2013 | 28 |
1010144 | 1010144 | 2021-02-08 | Crawford | Ohio | 39033 | 3430 | 90 |
1010349 | 1010349 | 2021-02-08 | Crawford | Pennsylvania | 42039 | 6075 | 131 |
1011230 | 1011230 | 2021-02-08 | Crawford | Wisconsin | 55023 | 1691 | 17 |
1004948 | 1004948 | 2021-02-07 | Crawford | Arkansas | 5033 | 6494 | 95 |
1005250 | 1005250 | 2021-02-07 | Crawford | Georgia | 13079 | 589 | 13 |
1005438 | 1005438 | 2021-02-07 | Crawford | Illinois | 17033 | 1946 | 37 |
1005537 | 1005537 | 2021-02-07 | Crawford | Indiana | 18025 | 878 | 14 |
1005640 | 1005640 | 2021-02-07 | Crawford | Iowa | 19047 | 2421 | 34 |
1005735 | 1005735 | 2021-02-07 | Crawford | Kansas | 20037 | 4317 | 64 |
1006083 | 1006083 | 2021-02-07 | Crawford | Michigan | 26039 | 565 | 5 |
1006345 | 1006345 | 2021-02-07 | Crawford | Missouri | 29055 | 2011 | 28 |
1006898 | 1006898 | 2021-02-07 | Crawford | Ohio | 39033 | 3425 | 90 |
1007103 | 1007103 | 2021-02-07 | Crawford | Pennsylvania | 42039 | 6069 | 133 |
1007984 | 1007984 | 2021-02-07 | Crawford | Wisconsin | 55023 | 1691 | 17 |
1001702 | 1001702 | 2021-02-06 | Crawford | Arkansas | 5033 | 6477 | 95 |
1002004 | 1002004 | 2021-02-06 | Crawford | Georgia | 13079 | 585 | 13 |
1002192 | 1002192 | 2021-02-06 | Crawford | Illinois | 17033 | 1944 | 37 |
1002291 | 1002291 | 2021-02-06 | Crawford | Indiana | 18025 | 871 | 14 |
1002394 | 1002394 | 2021-02-06 | Crawford | Iowa | 19047 | 2423 | 34 |
1002489 | 1002489 | 2021-02-06 | Crawford | Kansas | 20037 | 4317 | 64 |
1002837 | 1002837 | 2021-02-06 | Crawford | Michigan | 26039 | 565 | 5 |
1003099 | 1003099 | 2021-02-06 | Crawford | Missouri | 29055 | 2010 | 28 |
1003652 | 1003652 | 2021-02-06 | Crawford | Ohio | 39033 | 3419 | 90 |
1003857 | 1003857 | 2021-02-06 | Crawford | Pennsylvania | 42039 | 6056 | 132 |
1004738 | 1004738 | 2021-02-06 | Crawford | Wisconsin | 55023 | 1691 | 17 |
998456 | 998456 | 2021-02-05 | Crawford | Arkansas | 5033 | 6450 | 95 |
998758 | 998758 | 2021-02-05 | Crawford | Georgia | 13079 | 584 | 13 |
998946 | 998946 | 2021-02-05 | Crawford | Illinois | 17033 | 1931 | 37 |
999045 | 999045 | 2021-02-05 | Crawford | Indiana | 18025 | 861 | 14 |
999148 | 999148 | 2021-02-05 | Crawford | Iowa | 19047 | 2418 | 32 |
999243 | 999243 | 2021-02-05 | Crawford | Kansas | 20037 | 4317 | 64 |
999592 | 999592 | 2021-02-05 | Crawford | Michigan | 26039 | 565 | 5 |
999854 | 999854 | 2021-02-05 | Crawford | Missouri | 29055 | 2009 | 28 |
1000406 | 1000406 | 2021-02-05 | Crawford | Ohio | 39033 | 3410 | 90 |
1000611 | 1000611 | 2021-02-05 | Crawford | Pennsylvania | 42039 | 6036 | 132 |
1001492 | 1001492 | 2021-02-05 | Crawford | Wisconsin | 55023 | 1691 | 17 |
995210 | 995210 | 2021-02-04 | Crawford | Arkansas | 5033 | 6410 | 94 |
995512 | 995512 | 2021-02-04 | Crawford | Georgia | 13079 | 580 | 12 |
995700 | 995700 | 2021-02-04 | Crawford | Illinois | 17033 | 1928 | 37 |
995799 | 995799 | 2021-02-04 | Crawford | Indiana | 18025 | 858 | 14 |
995902 | 995902 | 2021-02-04 | Crawford | Iowa | 19047 | 2411 | 32 |
995997 | 995997 | 2021-02-04 | Crawford | Kansas | 20037 | 4283 | 64 |
996346 | 996346 | 2021-02-04 | Crawford | Michigan | 26039 | 564 | 5 |
996608 | 996608 | 2021-02-04 | Crawford | Missouri | 29055 | 2005 | 28 |
997160 | 997160 | 2021-02-04 | Crawford | Ohio | 39033 | 3405 | 90 |
997365 | 997365 | 2021-02-04 | Crawford | Pennsylvania | 42039 | 6012 | 130 |
998246 | 998246 | 2021-02-04 | Crawford | Wisconsin | 55023 | 1690 | 17 |
991964 | 991964 | 2021-02-03 | Crawford | Arkansas | 5033 | 6314 | 93 |
992266 | 992266 | 2021-02-03 | Crawford | Georgia | 13079 | 577 | 12 |
992454 | 992454 | 2021-02-03 | Crawford | Illinois | 17033 | 1925 | 37 |
992553 | 992553 | 2021-02-03 | Crawford | Indiana | 18025 | 852 | 10 |
992656 | 992656 | 2021-02-03 | Crawford | Iowa | 19047 | 2401 | 32 |
992751 | 992751 | 2021-02-03 | Crawford | Kansas | 20037 | 4283 | 64 |
993100 | 993100 | 2021-02-03 | Crawford | Michigan | 26039 | 564 | 5 |
993362 | 993362 | 2021-02-03 | Crawford | Missouri | 29055 | 1998 | 28 |
993914 | 993914 | 2021-02-03 | Crawford | Ohio | 39033 | 3393 | 85 |
994119 | 994119 | 2021-02-03 | Crawford | Pennsylvania | 42039 | 5996 | 130 |
995000 | 995000 | 2021-02-03 | Crawford | Wisconsin | 55023 | 1689 | 16 |
988718 | 988718 | 2021-02-02 | Crawford | Arkansas | 5033 | 6251 | 92 |
989020 | 989020 | 2021-02-02 | Crawford | Georgia | 13079 | 572 | 12 |
989208 | 989208 | 2021-02-02 | Crawford | Illinois | 17033 | 1908 | 37 |
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);