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 |
---|---|---|---|---|---|---|---|
386366 | 386366 | 2020-07-31 | Crawford | Georgia | 13079 | 88 | 0 |
386551 | 386551 | 2020-07-31 | Crawford | Illinois | 17033 | 29 | 0 |
386650 | 386650 | 2020-07-31 | Crawford | Indiana | 18025 | 41 | 1 |
386753 | 386753 | 2020-07-31 | Crawford | Iowa | 19047 | 707 | 3 |
386848 | 386848 | 2020-07-31 | Crawford | Kansas | 20037 | 380 | 1 |
387194 | 387194 | 2020-07-31 | Crawford | Michigan | 26039 | 94 | 5 |
387456 | 387456 | 2020-07-31 | Crawford | Missouri | 29055 | 47 | 0 |
387993 | 387993 | 2020-07-31 | Crawford | Ohio | 39033 | 163 | 5 |
388196 | 388196 | 2020-07-31 | Crawford | Pennsylvania | 42039 | 124 | 1 |
389072 | 389072 | 2020-07-31 | Crawford | Wisconsin | 55023 | 56 | 0 |
382847 | 382847 | 2020-07-30 | Crawford | Arkansas | 5033 | 495 | 3 |
383148 | 383148 | 2020-07-30 | Crawford | Georgia | 13079 | 87 | 0 |
383333 | 383333 | 2020-07-30 | Crawford | Illinois | 17033 | 29 | 0 |
383432 | 383432 | 2020-07-30 | Crawford | Indiana | 18025 | 41 | 1 |
383535 | 383535 | 2020-07-30 | Crawford | Iowa | 19047 | 708 | 3 |
383630 | 383630 | 2020-07-30 | Crawford | Kansas | 20037 | 375 | 1 |
383976 | 383976 | 2020-07-30 | Crawford | Michigan | 26039 | 93 | 5 |
384238 | 384238 | 2020-07-30 | Crawford | Missouri | 29055 | 40 | 0 |
384776 | 384776 | 2020-07-30 | Crawford | Ohio | 39033 | 160 | 5 |
384979 | 384979 | 2020-07-30 | Crawford | Pennsylvania | 42039 | 122 | 1 |
385855 | 385855 | 2020-07-30 | Crawford | Wisconsin | 55023 | 55 | 0 |
379630 | 379630 | 2020-07-29 | Crawford | Arkansas | 5033 | 487 | 3 |
379931 | 379931 | 2020-07-29 | Crawford | Georgia | 13079 | 86 | 0 |
380116 | 380116 | 2020-07-29 | Crawford | Illinois | 17033 | 30 | 0 |
380215 | 380215 | 2020-07-29 | Crawford | Indiana | 18025 | 41 | 1 |
380318 | 380318 | 2020-07-29 | Crawford | Iowa | 19047 | 700 | 3 |
380413 | 380413 | 2020-07-29 | Crawford | Kansas | 20037 | 375 | 1 |
380759 | 380759 | 2020-07-29 | Crawford | Michigan | 26039 | 93 | 5 |
381022 | 381022 | 2020-07-29 | Crawford | Missouri | 29055 | 36 | 0 |
381558 | 381558 | 2020-07-29 | Crawford | Ohio | 39033 | 160 | 5 |
381761 | 381761 | 2020-07-29 | Crawford | Pennsylvania | 42039 | 120 | 1 |
382637 | 382637 | 2020-07-29 | Crawford | Wisconsin | 55023 | 54 | 0 |
376414 | 376414 | 2020-07-28 | Crawford | Arkansas | 5033 | 473 | 3 |
376714 | 376714 | 2020-07-28 | Crawford | Georgia | 13079 | 82 | 0 |
376899 | 376899 | 2020-07-28 | Crawford | Illinois | 17033 | 30 | 0 |
376998 | 376998 | 2020-07-28 | Crawford | Indiana | 18025 | 41 | 1 |
377101 | 377101 | 2020-07-28 | Crawford | Iowa | 19047 | 702 | 3 |
377196 | 377196 | 2020-07-28 | Crawford | Kansas | 20037 | 373 | 1 |
377542 | 377542 | 2020-07-28 | Crawford | Michigan | 26039 | 93 | 5 |
377805 | 377805 | 2020-07-28 | Crawford | Missouri | 29055 | 33 | 0 |
378341 | 378341 | 2020-07-28 | Crawford | Ohio | 39033 | 158 | 5 |
378544 | 378544 | 2020-07-28 | Crawford | Pennsylvania | 42039 | 118 | 1 |
379420 | 379420 | 2020-07-28 | Crawford | Wisconsin | 55023 | 53 | 0 |
373200 | 373200 | 2020-07-27 | Crawford | Arkansas | 5033 | 464 | 3 |
373500 | 373500 | 2020-07-27 | Crawford | Georgia | 13079 | 81 | 0 |
373684 | 373684 | 2020-07-27 | Crawford | Illinois | 17033 | 30 | 0 |
373783 | 373783 | 2020-07-27 | Crawford | Indiana | 18025 | 41 | 1 |
373886 | 373886 | 2020-07-27 | Crawford | Iowa | 19047 | 699 | 3 |
373981 | 373981 | 2020-07-27 | Crawford | Kansas | 20037 | 373 | 1 |
374327 | 374327 | 2020-07-27 | Crawford | Michigan | 26039 | 94 | 5 |
374590 | 374590 | 2020-07-27 | Crawford | Missouri | 29055 | 35 | 0 |
375124 | 375124 | 2020-07-27 | Crawford | Ohio | 39033 | 158 | 5 |
375328 | 375328 | 2020-07-27 | Crawford | Pennsylvania | 42039 | 118 | 1 |
376204 | 376204 | 2020-07-27 | Crawford | Wisconsin | 55023 | 52 | 0 |
369988 | 369988 | 2020-07-26 | Crawford | Arkansas | 5033 | 447 | 3 |
370288 | 370288 | 2020-07-26 | Crawford | Georgia | 13079 | 81 | 0 |
370472 | 370472 | 2020-07-26 | Crawford | Illinois | 17033 | 30 | 0 |
370571 | 370571 | 2020-07-26 | Crawford | Indiana | 18025 | 41 | 1 |
370674 | 370674 | 2020-07-26 | Crawford | Iowa | 19047 | 697 | 3 |
370769 | 370769 | 2020-07-26 | Crawford | Kansas | 20037 | 367 | 1 |
371115 | 371115 | 2020-07-26 | Crawford | Michigan | 26039 | 94 | 5 |
371378 | 371378 | 2020-07-26 | Crawford | Missouri | 29055 | 34 | 0 |
371912 | 371912 | 2020-07-26 | Crawford | Ohio | 39033 | 158 | 5 |
372115 | 372115 | 2020-07-26 | Crawford | Pennsylvania | 42039 | 118 | 1 |
372990 | 372990 | 2020-07-26 | Crawford | Wisconsin | 55023 | 52 | 0 |
366778 | 366778 | 2020-07-25 | Crawford | Arkansas | 5033 | 438 | 3 |
367078 | 367078 | 2020-07-25 | Crawford | Georgia | 13079 | 81 | 0 |
367262 | 367262 | 2020-07-25 | Crawford | Illinois | 17033 | 29 | 0 |
367361 | 367361 | 2020-07-25 | Crawford | Indiana | 18025 | 39 | 1 |
367464 | 367464 | 2020-07-25 | Crawford | Iowa | 19047 | 693 | 3 |
367559 | 367559 | 2020-07-25 | Crawford | Kansas | 20037 | 367 | 1 |
367905 | 367905 | 2020-07-25 | Crawford | Michigan | 26039 | 94 | 5 |
368167 | 368167 | 2020-07-25 | Crawford | Missouri | 29055 | 33 | 0 |
368700 | 368700 | 2020-07-25 | Crawford | Ohio | 39033 | 155 | 5 |
368903 | 368903 | 2020-07-25 | Crawford | Pennsylvania | 42039 | 118 | 1 |
369778 | 369778 | 2020-07-25 | Crawford | Wisconsin | 55023 | 51 | 0 |
363571 | 363571 | 2020-07-24 | Crawford | Arkansas | 5033 | 429 | 3 |
363871 | 363871 | 2020-07-24 | Crawford | Georgia | 13079 | 81 | 0 |
364055 | 364055 | 2020-07-24 | Crawford | Illinois | 17033 | 28 | 0 |
364154 | 364154 | 2020-07-24 | Crawford | Indiana | 18025 | 39 | 1 |
364257 | 364257 | 2020-07-24 | Crawford | Iowa | 19047 | 689 | 3 |
364352 | 364352 | 2020-07-24 | Crawford | Kansas | 20037 | 367 | 1 |
364698 | 364698 | 2020-07-24 | Crawford | Michigan | 26039 | 93 | 5 |
364959 | 364959 | 2020-07-24 | Crawford | Missouri | 29055 | 32 | 0 |
365491 | 365491 | 2020-07-24 | Crawford | Ohio | 39033 | 154 | 5 |
365694 | 365694 | 2020-07-24 | Crawford | Pennsylvania | 42039 | 117 | 1 |
366568 | 366568 | 2020-07-24 | Crawford | Wisconsin | 55023 | 50 | 0 |
360364 | 360364 | 2020-07-23 | Crawford | Arkansas | 5033 | 393 | 3 |
360664 | 360664 | 2020-07-23 | Crawford | Georgia | 13079 | 76 | 0 |
360848 | 360848 | 2020-07-23 | Crawford | Illinois | 17033 | 28 | 0 |
360947 | 360947 | 2020-07-23 | Crawford | Indiana | 18025 | 38 | 1 |
361050 | 361050 | 2020-07-23 | Crawford | Iowa | 19047 | 689 | 3 |
361145 | 361145 | 2020-07-23 | Crawford | Kansas | 20037 | 360 | 1 |
361491 | 361491 | 2020-07-23 | Crawford | Michigan | 26039 | 92 | 5 |
361752 | 361752 | 2020-07-23 | Crawford | Missouri | 29055 | 32 | 0 |
362285 | 362285 | 2020-07-23 | Crawford | Ohio | 39033 | 153 | 5 |
362488 | 362488 | 2020-07-23 | Crawford | Pennsylvania | 42039 | 114 | 1 |
363361 | 363361 | 2020-07-23 | Crawford | Wisconsin | 55023 | 49 | 0 |
357159 | 357159 | 2020-07-22 | Crawford | Arkansas | 5033 | 379 | 3 |
357459 | 357459 | 2020-07-22 | Crawford | Georgia | 13079 | 68 | 0 |
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);