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 |
---|---|---|---|---|---|---|---|
2470684 | 2470684 | 2022-05-04 | Crawford | Georgia | 13079 | 1773 | 55 |
2470873 | 2470873 | 2022-05-04 | Crawford | Illinois | 17033 | 6220 | 61 |
2470972 | 2470972 | 2022-05-04 | Crawford | Indiana | 18025 | 2558 | 40 |
2471076 | 2471076 | 2022-05-04 | Crawford | Iowa | 19047 | 4528 | 54 |
2471171 | 2471171 | 2022-05-04 | Crawford | Kansas | 20037 | 11915 | 130 |
2471520 | 2471520 | 2022-05-04 | Crawford | Michigan | 26039 | 2596 | 31 |
2471783 | 2471783 | 2022-05-04 | Crawford | Missouri | 29055 | 5396 | 101 |
2472340 | 2472340 | 2022-05-04 | Crawford | Ohio | 39033 | 11204 | 214 |
2472546 | 2472546 | 2022-05-04 | Crawford | Pennsylvania | 42039 | 19946 | 318 |
2473428 | 2473428 | 2022-05-04 | Crawford | Wisconsin | 55023 | 4267 | 28 |
2467126 | 2467126 | 2022-05-03 | Crawford | Arkansas | 5033 | 15851 | 249 |
2467428 | 2467428 | 2022-05-03 | Crawford | Georgia | 13079 | 1768 | 55 |
2467617 | 2467617 | 2022-05-03 | Crawford | Illinois | 17033 | 6218 | 61 |
2467716 | 2467716 | 2022-05-03 | Crawford | Indiana | 18025 | 2554 | 40 |
2467820 | 2467820 | 2022-05-03 | Crawford | Iowa | 19047 | 4526 | 54 |
2467915 | 2467915 | 2022-05-03 | Crawford | Kansas | 20037 | 11915 | 130 |
2468264 | 2468264 | 2022-05-03 | Crawford | Michigan | 26039 | 2585 | 31 |
2468527 | 2468527 | 2022-05-03 | Crawford | Missouri | 29055 | 5396 | 101 |
2469084 | 2469084 | 2022-05-03 | Crawford | Ohio | 39033 | 11204 | 214 |
2469290 | 2469290 | 2022-05-03 | Crawford | Pennsylvania | 42039 | 19923 | 318 |
2470171 | 2470171 | 2022-05-03 | Crawford | Wisconsin | 55023 | 4263 | 28 |
2463871 | 2463871 | 2022-05-02 | Crawford | Arkansas | 5033 | 15849 | 249 |
2464173 | 2464173 | 2022-05-02 | Crawford | Georgia | 13079 | 1768 | 55 |
2464362 | 2464362 | 2022-05-02 | Crawford | Illinois | 17033 | 6216 | 61 |
2464461 | 2464461 | 2022-05-02 | Crawford | Indiana | 18025 | 2554 | 40 |
2464565 | 2464565 | 2022-05-02 | Crawford | Iowa | 19047 | 4526 | 54 |
2464660 | 2464660 | 2022-05-02 | Crawford | Kansas | 20037 | 11915 | 130 |
2465009 | 2465009 | 2022-05-02 | Crawford | Michigan | 26039 | 2585 | 31 |
2465271 | 2465271 | 2022-05-02 | Crawford | Missouri | 29055 | 5396 | 101 |
2465828 | 2465828 | 2022-05-02 | Crawford | Ohio | 39033 | 11204 | 214 |
2466034 | 2466034 | 2022-05-02 | Crawford | Pennsylvania | 42039 | 19909 | 318 |
2466915 | 2466915 | 2022-05-02 | Crawford | Wisconsin | 55023 | 4261 | 28 |
2460615 | 2460615 | 2022-05-01 | Crawford | Arkansas | 5033 | 15847 | 249 |
2460917 | 2460917 | 2022-05-01 | Crawford | Georgia | 13079 | 1768 | 55 |
2461106 | 2461106 | 2022-05-01 | Crawford | Illinois | 17033 | 6214 | 61 |
2461205 | 2461205 | 2022-05-01 | Crawford | Indiana | 18025 | 2554 | 40 |
2461309 | 2461309 | 2022-05-01 | Crawford | Iowa | 19047 | 4526 | 54 |
2461404 | 2461404 | 2022-05-01 | Crawford | Kansas | 20037 | 11915 | 130 |
2461753 | 2461753 | 2022-05-01 | Crawford | Michigan | 26039 | 2585 | 31 |
2462016 | 2462016 | 2022-05-01 | Crawford | Missouri | 29055 | 5396 | 101 |
2462573 | 2462573 | 2022-05-01 | Crawford | Ohio | 39033 | 11204 | 214 |
2462779 | 2462779 | 2022-05-01 | Crawford | Pennsylvania | 42039 | 19904 | 318 |
2463660 | 2463660 | 2022-05-01 | Crawford | Wisconsin | 55023 | 4257 | 28 |
2457359 | 2457359 | 2022-04-30 | Crawford | Arkansas | 5033 | 15847 | 249 |
2457661 | 2457661 | 2022-04-30 | Crawford | Georgia | 13079 | 1768 | 55 |
2457850 | 2457850 | 2022-04-30 | Crawford | Illinois | 17033 | 6214 | 61 |
2457949 | 2457949 | 2022-04-30 | Crawford | Indiana | 18025 | 2554 | 40 |
2458053 | 2458053 | 2022-04-30 | Crawford | Iowa | 19047 | 4526 | 54 |
2458148 | 2458148 | 2022-04-30 | Crawford | Kansas | 20037 | 11915 | 130 |
2458497 | 2458497 | 2022-04-30 | Crawford | Michigan | 26039 | 2585 | 31 |
2458760 | 2458760 | 2022-04-30 | Crawford | Missouri | 29055 | 5396 | 101 |
2459317 | 2459317 | 2022-04-30 | Crawford | Ohio | 39033 | 11204 | 214 |
2459523 | 2459523 | 2022-04-30 | Crawford | Pennsylvania | 42039 | 19900 | 318 |
2460404 | 2460404 | 2022-04-30 | Crawford | Wisconsin | 55023 | 4257 | 28 |
2454103 | 2454103 | 2022-04-29 | Crawford | Arkansas | 5033 | 15845 | 249 |
2454405 | 2454405 | 2022-04-29 | Crawford | Georgia | 13079 | 1768 | 55 |
2454594 | 2454594 | 2022-04-29 | Crawford | Illinois | 17033 | 6214 | 61 |
2454693 | 2454693 | 2022-04-29 | Crawford | Indiana | 18025 | 2554 | 40 |
2454797 | 2454797 | 2022-04-29 | Crawford | Iowa | 19047 | 4526 | 54 |
2454892 | 2454892 | 2022-04-29 | Crawford | Kansas | 20037 | 11915 | 130 |
2455241 | 2455241 | 2022-04-29 | Crawford | Michigan | 26039 | 2585 | 31 |
2455504 | 2455504 | 2022-04-29 | Crawford | Missouri | 29055 | 5396 | 101 |
2456061 | 2456061 | 2022-04-29 | Crawford | Ohio | 39033 | 11204 | 214 |
2456267 | 2456267 | 2022-04-29 | Crawford | Pennsylvania | 42039 | 19891 | 318 |
2457148 | 2457148 | 2022-04-29 | Crawford | Wisconsin | 55023 | 4257 | 28 |
2450847 | 2450847 | 2022-04-28 | Crawford | Arkansas | 5033 | 15843 | 249 |
2451149 | 2451149 | 2022-04-28 | Crawford | Georgia | 13079 | 1768 | 55 |
2451338 | 2451338 | 2022-04-28 | Crawford | Illinois | 17033 | 6213 | 61 |
2451437 | 2451437 | 2022-04-28 | Crawford | Indiana | 18025 | 2552 | 40 |
2451541 | 2451541 | 2022-04-28 | Crawford | Iowa | 19047 | 4526 | 54 |
2451636 | 2451636 | 2022-04-28 | Crawford | Kansas | 20037 | 11894 | 130 |
2451985 | 2451985 | 2022-04-28 | Crawford | Michigan | 26039 | 2585 | 31 |
2452248 | 2452248 | 2022-04-28 | Crawford | Missouri | 29055 | 5396 | 101 |
2452805 | 2452805 | 2022-04-28 | Crawford | Ohio | 39033 | 11204 | 214 |
2453011 | 2453011 | 2022-04-28 | Crawford | Pennsylvania | 42039 | 19870 | 318 |
2453892 | 2453892 | 2022-04-28 | Crawford | Wisconsin | 55023 | 4252 | 28 |
2447591 | 2447591 | 2022-04-27 | Crawford | Arkansas | 5033 | 15839 | 248 |
2447893 | 2447893 | 2022-04-27 | Crawford | Georgia | 13079 | 1768 | 55 |
2448082 | 2448082 | 2022-04-27 | Crawford | Illinois | 17033 | 6210 | 61 |
2448181 | 2448181 | 2022-04-27 | Crawford | Indiana | 18025 | 2552 | 40 |
2448285 | 2448285 | 2022-04-27 | Crawford | Iowa | 19047 | 4526 | 54 |
2448380 | 2448380 | 2022-04-27 | Crawford | Kansas | 20037 | 11894 | 130 |
2448729 | 2448729 | 2022-04-27 | Crawford | Michigan | 26039 | 2585 | 31 |
2448992 | 2448992 | 2022-04-27 | Crawford | Missouri | 29055 | 5396 | 101 |
2449549 | 2449549 | 2022-04-27 | Crawford | Ohio | 39033 | 11186 | 214 |
2449755 | 2449755 | 2022-04-27 | Crawford | Pennsylvania | 42039 | 19859 | 318 |
2450636 | 2450636 | 2022-04-27 | Crawford | Wisconsin | 55023 | 4250 | 28 |
2444335 | 2444335 | 2022-04-26 | Crawford | Arkansas | 5033 | 15836 | 248 |
2444637 | 2444637 | 2022-04-26 | Crawford | Georgia | 13079 | 1768 | 54 |
2444826 | 2444826 | 2022-04-26 | Crawford | Illinois | 17033 | 6207 | 61 |
2444925 | 2444925 | 2022-04-26 | Crawford | Indiana | 18025 | 2552 | 40 |
2445029 | 2445029 | 2022-04-26 | Crawford | Iowa | 19047 | 4526 | 54 |
2445124 | 2445124 | 2022-04-26 | Crawford | Kansas | 20037 | 11894 | 130 |
2445473 | 2445473 | 2022-04-26 | Crawford | Michigan | 26039 | 2576 | 30 |
2445735 | 2445735 | 2022-04-26 | Crawford | Missouri | 29055 | 5396 | 101 |
2446292 | 2446292 | 2022-04-26 | Crawford | Ohio | 39033 | 11186 | 214 |
2446498 | 2446498 | 2022-04-26 | Crawford | Pennsylvania | 42039 | 19848 | 318 |
2447380 | 2447380 | 2022-04-26 | Crawford | Wisconsin | 55023 | 4247 | 28 |
2441079 | 2441079 | 2022-04-25 | Crawford | Arkansas | 5033 | 15835 | 248 |
2441381 | 2441381 | 2022-04-25 | Crawford | Georgia | 13079 | 1768 | 54 |
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);