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 |
---|---|---|---|---|---|---|---|
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 |
1024722 | 1024722 | 2021-02-13 | Crawford | Georgia | 13079 | 597 | 13 |
1024910 | 1024910 | 2021-02-13 | Crawford | Illinois | 17033 | 1974 | 37 |
1025009 | 1025009 | 2021-02-13 | Crawford | Indiana | 18025 | 893 | 14 |
1025112 | 1025112 | 2021-02-13 | Crawford | Iowa | 19047 | 2451 | 35 |
1025207 | 1025207 | 2021-02-13 | Crawford | Kansas | 20037 | 4413 | 73 |
1025555 | 1025555 | 2021-02-13 | Crawford | Michigan | 26039 | 572 | 5 |
1025817 | 1025817 | 2021-02-13 | Crawford | Missouri | 29055 | 2027 | 29 |
1026369 | 1026369 | 2021-02-13 | Crawford | Ohio | 39033 | 3482 | 95 |
1026574 | 1026574 | 2021-02-13 | Crawford | Pennsylvania | 42039 | 6168 | 134 |
1027455 | 1027455 | 2021-02-13 | Crawford | Wisconsin | 55023 | 1703 | 17 |
1021175 | 1021175 | 2021-02-12 | Crawford | Arkansas | 5033 | 6617 | 99 |
1021477 | 1021477 | 2021-02-12 | Crawford | Georgia | 13079 | 596 | 13 |
1021665 | 1021665 | 2021-02-12 | Crawford | Illinois | 17033 | 1970 | 37 |
1021764 | 1021764 | 2021-02-12 | Crawford | Indiana | 18025 | 893 | 14 |
1021867 | 1021867 | 2021-02-12 | Crawford | Iowa | 19047 | 2452 | 34 |
1021962 | 1021962 | 2021-02-12 | Crawford | Kansas | 20037 | 4413 | 73 |
1022310 | 1022310 | 2021-02-12 | Crawford | Michigan | 26039 | 570 | 5 |
1022572 | 1022572 | 2021-02-12 | Crawford | Missouri | 29055 | 2021 | 29 |
1023124 | 1023124 | 2021-02-12 | Crawford | Ohio | 39033 | 3472 | 92 |
1023329 | 1023329 | 2021-02-12 | Crawford | Pennsylvania | 42039 | 6149 | 133 |
1024210 | 1024210 | 2021-02-12 | Crawford | Wisconsin | 55023 | 1700 | 17 |
1017930 | 1017930 | 2021-02-11 | Crawford | Arkansas | 5033 | 6586 | 99 |
1018232 | 1018232 | 2021-02-11 | Crawford | Georgia | 13079 | 595 | 13 |
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);