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 |
---|---|---|---|---|---|---|---|
1053632 | 1053632 | 2021-02-22 | Crawford | Arkansas | 5033 | 6698 | 104 |
1053934 | 1053934 | 2021-02-22 | Crawford | Georgia | 13079 | 615 | 16 |
1054122 | 1054122 | 2021-02-22 | Crawford | Illinois | 17033 | 1996 | 37 |
1054221 | 1054221 | 2021-02-22 | Crawford | Indiana | 18025 | 900 | 14 |
1054324 | 1054324 | 2021-02-22 | Crawford | Iowa | 19047 | 2471 | 35 |
1054419 | 1054419 | 2021-02-22 | Crawford | Kansas | 20037 | 4482 | 77 |
1054768 | 1054768 | 2021-02-22 | Crawford | Michigan | 26039 | 580 | 5 |
1055030 | 1055030 | 2021-02-22 | Crawford | Missouri | 29055 | 2040 | 29 |
1055582 | 1055582 | 2021-02-22 | Crawford | Ohio | 39033 | 3539 | 95 |
1055787 | 1055787 | 2021-02-22 | Crawford | Pennsylvania | 42039 | 6282 | 136 |
1056668 | 1056668 | 2021-02-22 | Crawford | Wisconsin | 55023 | 1713 | 17 |
1050385 | 1050385 | 2021-02-21 | Crawford | Arkansas | 5033 | 6694 | 104 |
1050687 | 1050687 | 2021-02-21 | Crawford | Georgia | 13079 | 614 | 16 |
1050875 | 1050875 | 2021-02-21 | Crawford | Illinois | 17033 | 1995 | 37 |
1050974 | 1050974 | 2021-02-21 | Crawford | Indiana | 18025 | 900 | 14 |
1051077 | 1051077 | 2021-02-21 | Crawford | Iowa | 19047 | 2471 | 35 |
1051172 | 1051172 | 2021-02-21 | Crawford | Kansas | 20037 | 4466 | 77 |
1051521 | 1051521 | 2021-02-21 | Crawford | Michigan | 26039 | 579 | 5 |
1051783 | 1051783 | 2021-02-21 | Crawford | Missouri | 29055 | 2039 | 29 |
1052336 | 1052336 | 2021-02-21 | Crawford | Ohio | 39033 | 3532 | 95 |
1052541 | 1052541 | 2021-02-21 | Crawford | Pennsylvania | 42039 | 6273 | 136 |
1053422 | 1053422 | 2021-02-21 | Crawford | Wisconsin | 55023 | 1711 | 17 |
1047138 | 1047138 | 2021-02-20 | Crawford | Arkansas | 5033 | 6687 | 104 |
1047440 | 1047440 | 2021-02-20 | Crawford | Georgia | 13079 | 614 | 15 |
1047628 | 1047628 | 2021-02-20 | Crawford | Illinois | 17033 | 1994 | 37 |
1047727 | 1047727 | 2021-02-20 | Crawford | Indiana | 18025 | 899 | 14 |
1047830 | 1047830 | 2021-02-20 | Crawford | Iowa | 19047 | 2471 | 35 |
1047925 | 1047925 | 2021-02-20 | Crawford | Kansas | 20037 | 4466 | 77 |
1048274 | 1048274 | 2021-02-20 | Crawford | Michigan | 26039 | 579 | 5 |
1048536 | 1048536 | 2021-02-20 | Crawford | Missouri | 29055 | 2034 | 29 |
1049089 | 1049089 | 2021-02-20 | Crawford | Ohio | 39033 | 3530 | 95 |
1049294 | 1049294 | 2021-02-20 | Crawford | Pennsylvania | 42039 | 6261 | 136 |
1050175 | 1050175 | 2021-02-20 | Crawford | Wisconsin | 55023 | 1710 | 17 |
1043893 | 1043893 | 2021-02-19 | Crawford | Arkansas | 5033 | 6673 | 104 |
1044195 | 1044195 | 2021-02-19 | Crawford | Georgia | 13079 | 613 | 15 |
1044383 | 1044383 | 2021-02-19 | Crawford | Illinois | 17033 | 1994 | 37 |
1044482 | 1044482 | 2021-02-19 | Crawford | Indiana | 18025 | 897 | 14 |
1044585 | 1044585 | 2021-02-19 | Crawford | Iowa | 19047 | 2471 | 35 |
1044680 | 1044680 | 2021-02-19 | Crawford | Kansas | 20037 | 4466 | 77 |
1045028 | 1045028 | 2021-02-19 | Crawford | Michigan | 26039 | 579 | 5 |
1045290 | 1045290 | 2021-02-19 | Crawford | Missouri | 29055 | 2033 | 29 |
1045842 | 1045842 | 2021-02-19 | Crawford | Ohio | 39033 | 3525 | 95 |
1046047 | 1046047 | 2021-02-19 | Crawford | Pennsylvania | 42039 | 6257 | 136 |
1046928 | 1046928 | 2021-02-19 | Crawford | Wisconsin | 55023 | 1709 | 17 |
1040648 | 1040648 | 2021-02-18 | Crawford | Arkansas | 5033 | 6671 | 104 |
1040950 | 1040950 | 2021-02-18 | Crawford | Georgia | 13079 | 602 | 15 |
1041138 | 1041138 | 2021-02-18 | Crawford | Illinois | 17033 | 1989 | 37 |
1041237 | 1041237 | 2021-02-18 | Crawford | Indiana | 18025 | 895 | 14 |
1041340 | 1041340 | 2021-02-18 | Crawford | Iowa | 19047 | 2468 | 35 |
1041435 | 1041435 | 2021-02-18 | Crawford | Kansas | 20037 | 4453 | 75 |
1041783 | 1041783 | 2021-02-18 | Crawford | Michigan | 26039 | 579 | 5 |
1042045 | 1042045 | 2021-02-18 | Crawford | Missouri | 29055 | 2032 | 29 |
1042597 | 1042597 | 2021-02-18 | Crawford | Ohio | 39033 | 3514 | 95 |
1042802 | 1042802 | 2021-02-18 | Crawford | Pennsylvania | 42039 | 6233 | 135 |
1043683 | 1043683 | 2021-02-18 | Crawford | Wisconsin | 55023 | 1709 | 17 |
1037403 | 1037403 | 2021-02-17 | Crawford | Arkansas | 5033 | 6668 | 104 |
1037705 | 1037705 | 2021-02-17 | Crawford | Georgia | 13079 | 603 | 14 |
1037893 | 1037893 | 2021-02-17 | Crawford | Illinois | 17033 | 1984 | 37 |
1037992 | 1037992 | 2021-02-17 | Crawford | Indiana | 18025 | 895 | 14 |
1038095 | 1038095 | 2021-02-17 | Crawford | Iowa | 19047 | 2465 | 35 |
1038190 | 1038190 | 2021-02-17 | Crawford | Kansas | 20037 | 4453 | 75 |
1038538 | 1038538 | 2021-02-17 | Crawford | Michigan | 26039 | 578 | 5 |
1038800 | 1038800 | 2021-02-17 | Crawford | Missouri | 29055 | 2032 | 29 |
1039352 | 1039352 | 2021-02-17 | Crawford | Ohio | 39033 | 3510 | 95 |
1039557 | 1039557 | 2021-02-17 | Crawford | Pennsylvania | 42039 | 6218 | 135 |
1040438 | 1040438 | 2021-02-17 | Crawford | Wisconsin | 55023 | 1708 | 17 |
1034158 | 1034158 | 2021-02-16 | Crawford | Arkansas | 5033 | 6646 | 101 |
1034460 | 1034460 | 2021-02-16 | Crawford | Georgia | 13079 | 600 | 14 |
1034648 | 1034648 | 2021-02-16 | Crawford | Illinois | 17033 | 1982 | 37 |
1034747 | 1034747 | 2021-02-16 | Crawford | Indiana | 18025 | 895 | 14 |
1034850 | 1034850 | 2021-02-16 | Crawford | Iowa | 19047 | 2459 | 35 |
1034945 | 1034945 | 2021-02-16 | Crawford | Kansas | 20037 | 4428 | 73 |
1035293 | 1035293 | 2021-02-16 | Crawford | Michigan | 26039 | 577 | 5 |
1035555 | 1035555 | 2021-02-16 | Crawford | Missouri | 29055 | 2030 | 29 |
1036107 | 1036107 | 2021-02-16 | Crawford | Ohio | 39033 | 3504 | 95 |
1036312 | 1036312 | 2021-02-16 | Crawford | Pennsylvania | 42039 | 6208 | 135 |
1037193 | 1037193 | 2021-02-16 | Crawford | Wisconsin | 55023 | 1707 | 17 |
1030912 | 1030912 | 2021-02-15 | Crawford | Arkansas | 5033 | 6641 | 101 |
1031214 | 1031214 | 2021-02-15 | Crawford | Georgia | 13079 | 599 | 13 |
1031402 | 1031402 | 2021-02-15 | Crawford | Illinois | 17033 | 1980 | 37 |
1031501 | 1031501 | 2021-02-15 | Crawford | Indiana | 18025 | 894 | 14 |
1031604 | 1031604 | 2021-02-15 | Crawford | Iowa | 19047 | 2452 | 35 |
1031699 | 1031699 | 2021-02-15 | Crawford | Kansas | 20037 | 4428 | 73 |
1032048 | 1032048 | 2021-02-15 | Crawford | Michigan | 26039 | 573 | 5 |
1032310 | 1032310 | 2021-02-15 | Crawford | Missouri | 29055 | 2029 | 29 |
1032862 | 1032862 | 2021-02-15 | Crawford | Ohio | 39033 | 3493 | 95 |
1033067 | 1033067 | 2021-02-15 | Crawford | Pennsylvania | 42039 | 6189 | 135 |
1033948 | 1033948 | 2021-02-15 | Crawford | Wisconsin | 55023 | 1706 | 17 |
1027665 | 1027665 | 2021-02-14 | Crawford | Arkansas | 5033 | 6635 | 101 |
1027967 | 1027967 | 2021-02-14 | Crawford | Georgia | 13079 | 598 | 13 |
1028155 | 1028155 | 2021-02-14 | Crawford | Illinois | 17033 | 1980 | 37 |
1028254 | 1028254 | 2021-02-14 | Crawford | Indiana | 18025 | 894 | 14 |
1028357 | 1028357 | 2021-02-14 | Crawford | Iowa | 19047 | 2451 | 35 |
1028452 | 1028452 | 2021-02-14 | Crawford | Kansas | 20037 | 4413 | 73 |
1028801 | 1028801 | 2021-02-14 | Crawford | Michigan | 26039 | 572 | 5 |
1029063 | 1029063 | 2021-02-14 | Crawford | Missouri | 29055 | 2028 | 29 |
1029616 | 1029616 | 2021-02-14 | Crawford | Ohio | 39033 | 3486 | 95 |
1029821 | 1029821 | 2021-02-14 | Crawford | Pennsylvania | 42039 | 6178 | 135 |
1030702 | 1030702 | 2021-02-14 | Crawford | Wisconsin | 55023 | 1705 | 17 |
1024420 | 1024420 | 2021-02-13 | Crawford | Arkansas | 5033 | 6630 | 101 |
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);