ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

76 rows where date = "2021-12-05" and state = "Arkansas" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

fips >30

state 1

  • Arkansas · 76 ✖
Link rowid date ▲ county state fips cases deaths
1982463 1982463 2021-12-05 Arkansas Arkansas 5001 3545 60
1982464 1982464 2021-12-05 Ashley Arkansas 5003 3241 51
1982465 1982465 2021-12-05 Baxter Arkansas 5005 6305 190
1982466 1982466 2021-12-05 Benton Arkansas 5007 44339 636
1982467 1982467 2021-12-05 Boone Arkansas 5009 6560 132
1982468 1982468 2021-12-05 Bradley Arkansas 5011 2032 41
1982469 1982469 2021-12-05 Calhoun Arkansas 5013 607 8
1982470 1982470 2021-12-05 Carroll Arkansas 5015 4443 78
1982471 1982471 2021-12-05 Chicot Arkansas 5017 2036 47
1982472 1982472 2021-12-05 Clark Arkansas 5019 3396 62
1982473 1982473 2021-12-05 Clay Arkansas 5021 2831 76
1982474 1982474 2021-12-05 Cleburne Arkansas 5023 4034 95
1982475 1982475 2021-12-05 Cleveland Arkansas 5025 1450 33
1982476 1982476 2021-12-05 Columbia Arkansas 5027 3424 75
1982477 1982477 2021-12-05 Conway Arkansas 5029 3300 46
1982478 1982478 2021-12-05 Craighead Arkansas 5031 22441 251
1982479 1982479 2021-12-05 Crawford Arkansas 5033 11119 180
1982480 1982480 2021-12-05 Crittenden Arkansas 5035 9039 184
1982481 1982481 2021-12-05 Cross Arkansas 5037 3058 68
1982482 1982482 2021-12-05 Dallas Arkansas 5039 1151 19
1982483 1982483 2021-12-05 Desha Arkansas 5041 1965 33
1982484 1982484 2021-12-05 Drew Arkansas 5043 2968 55
1982485 1982485 2021-12-05 Faulkner Arkansas 5045 20522 228
1982486 1982486 2021-12-05 Franklin Arkansas 5047 2825 55
1982487 1982487 2021-12-05 Fulton Arkansas 5049 1925 69
1982488 1982488 2021-12-05 Garland Arkansas 5051 16226 402
1982489 1982489 2021-12-05 Grant Arkansas 5053 2934 50
1982490 1982490 2021-12-05 Greene Arkansas 5055 10516 127
1982491 1982491 2021-12-05 Hempstead Arkansas 5057 3058 43
1982492 1982492 2021-12-05 Hot Spring Arkansas 5059 7803 111
1982493 1982493 2021-12-05 Howard Arkansas 5061 2555 39
1982494 1982494 2021-12-05 Independence Arkansas 5063 7010 161
1982495 1982495 2021-12-05 Izard Arkansas 5065 2746 55
1982496 1982496 2021-12-05 Jackson Arkansas 5067 4598 47
1982497 1982497 2021-12-05 Jefferson Arkansas 5069 12499 229
1982498 1982498 2021-12-05 Johnson Arkansas 5071 4728 59
1982499 1982499 2021-12-05 Lafayette Arkansas 5073 867 28
1982500 1982500 2021-12-05 Lawrence Arkansas 5075 3501 62
1982501 1982501 2021-12-05 Lee Arkansas 5077 2212 52
1982502 1982502 2021-12-05 Lincoln Arkansas 5079 3719 58
1982503 1982503 2021-12-05 Little River Arkansas 5081 2131 81
1982504 1982504 2021-12-05 Logan Arkansas 5083 3745 52
1982505 1982505 2021-12-05 Lonoke Arkansas 5085 12515 176
1982506 1982506 2021-12-05 Madison Arkansas 5087 2698 40
1982507 1982507 2021-12-05 Marion Arkansas 5089 2388 63
1982508 1982508 2021-12-05 Miller Arkansas 5091 6701 150
1982509 1982509 2021-12-05 Mississippi Arkansas 5093 8764 150
1982510 1982510 2021-12-05 Monroe Arkansas 5095 1207 25
1982511 1982511 2021-12-05 Montgomery Arkansas 5097 1162 47
1982512 1982512 2021-12-05 Nevada Arkansas 5099 1418 41
1982513 1982513 2021-12-05 Newton Arkansas 5101 1241 41
1982514 1982514 2021-12-05 Ouachita Arkansas 5103 3488 86
1982515 1982515 2021-12-05 Perry Arkansas 5105 1612 22
1982516 1982516 2021-12-05 Phillips Arkansas 5107 3255 78
1982517 1982517 2021-12-05 Pike Arkansas 5109 1765 37
1982518 1982518 2021-12-05 Poinsett Arkansas 5111 5176 102
1982519 1982519 2021-12-05 Polk Arkansas 5113 3016 112
1982520 1982520 2021-12-05 Pope Arkansas 5115 12373 159
1982521 1982521 2021-12-05 Prairie Arkansas 5117 1292 29
1982522 1982522 2021-12-05 Pulaski Arkansas 5119 60618 939
1982523 1982523 2021-12-05 Randolph Arkansas 5121 3501 64
1982524 1982524 2021-12-05 Saline Arkansas 5125 19076 246
1982525 1982525 2021-12-05 Scott Arkansas 5127 1765 32
1982526 1982526 2021-12-05 Searcy Arkansas 5129 1331 26
1982527 1982527 2021-12-05 Sebastian Arkansas 5131 23364 396
1982528 1982528 2021-12-05 Sevier Arkansas 5133 4124 61
1982529 1982529 2021-12-05 Sharp Arkansas 5135 3180 70
1982530 1982530 2021-12-05 St. Francis Arkansas 5123 4901 70
1982531 1982531 2021-12-05 Stone Arkansas 5137 1958 46
1982532 1982532 2021-12-05 Union Arkansas 5139 6041 144
1982533 1982533 2021-12-05 Unknown Arkansas   5680 0
1982534 1982534 2021-12-05 Van Buren Arkansas 5141 2324 44
1982535 1982535 2021-12-05 Washington Arkansas 5143 46036 502
1982536 1982536 2021-12-05 White Arkansas 5145 14036 206
1982537 1982537 2021-12-05 Woodruff Arkansas 5147 1142 24
1982538 1982538 2021-12-05 Yell Arkansas 5149 4804 83

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);