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 = "2022-02-26" 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
2252353 2252353 2022-02-26 Arkansas Arkansas 5001 5629 75
2252354 2252354 2022-02-26 Ashley Arkansas 5003 5060 59
2252355 2252355 2022-02-26 Baxter Arkansas 5005 8506 230
2252356 2252356 2022-02-26 Benton Arkansas 5007 65709 772
2252357 2252357 2022-02-26 Boone Arkansas 5009 9286 161
2252358 2252358 2022-02-26 Bradley Arkansas 5011 2972 44
2252359 2252359 2022-02-26 Calhoun Arkansas 5013 931 9
2252360 2252360 2022-02-26 Carroll Arkansas 5015 5984 94
2252361 2252361 2022-02-26 Chicot Arkansas 5017 2741 54
2252362 2252362 2022-02-26 Clark Arkansas 5019 5181 74
2252363 2252363 2022-02-26 Clay Arkansas 5021 4059 88
2252364 2252364 2022-02-26 Cleburne Arkansas 5023 6359 116
2252365 2252365 2022-02-26 Cleveland Arkansas 5025 2240 35
2252366 2252366 2022-02-26 Columbia Arkansas 5027 5261 85
2252367 2252367 2022-02-26 Conway Arkansas 5029 5400 58
2252368 2252368 2022-02-26 Craighead Arkansas 5031 36441 312
2252369 2252369 2022-02-26 Crawford Arkansas 5033 15673 231
2252370 2252370 2022-02-26 Crittenden Arkansas 5035 13749 209
2252371 2252371 2022-02-26 Cross Arkansas 5037 4732 75
2252372 2252372 2022-02-26 Dallas Arkansas 5039 1728 28
2252373 2252373 2022-02-26 Desha Arkansas 5041 3001 38
2252374 2252374 2022-02-26 Drew Arkansas 5043 4631 62
2252375 2252375 2022-02-26 Faulkner Arkansas 5045 34668 297
2252376 2252376 2022-02-26 Franklin Arkansas 5047 3748 68
2252377 2252377 2022-02-26 Fulton Arkansas 5049 2637 83
2252378 2252378 2022-02-26 Garland Arkansas 5051 22481 468
2252379 2252379 2022-02-26 Grant Arkansas 5053 4355 58
2252380 2252380 2022-02-26 Greene Arkansas 5055 15653 162
2252381 2252381 2022-02-26 Hempstead Arkansas 5057 4465 57
2252382 2252382 2022-02-26 Hot Spring Arkansas 5059 10940 122
2252383 2252383 2022-02-26 Howard Arkansas 5061 3718 48
2252384 2252384 2022-02-26 Independence Arkansas 5063 10512 194
2252385 2252385 2022-02-26 Izard Arkansas 5065 3854 64
2252386 2252386 2022-02-26 Jackson Arkansas 5067 5942 54
2252387 2252387 2022-02-26 Jefferson Arkansas 5069 18477 261
2252388 2252388 2022-02-26 Johnson Arkansas 5071 6603 69
2252389 2252389 2022-02-26 Lafayette Arkansas 5073 1271 28
2252390 2252390 2022-02-26 Lawrence Arkansas 5075 5087 69
2252391 2252391 2022-02-26 Lee Arkansas 5077 2867 56
2252392 2252392 2022-02-26 Lincoln Arkansas 5079 4895 63
2252393 2252393 2022-02-26 Little River Arkansas 5081 3213 87
2252394 2252394 2022-02-26 Logan Arkansas 5083 5026 69
2252395 2252395 2022-02-26 Lonoke Arkansas 5085 19591 223
2252396 2252396 2022-02-26 Madison Arkansas 5087 3847 57
2252397 2252397 2022-02-26 Marion Arkansas 5089 3300 83
2252398 2252398 2022-02-26 Miller Arkansas 5091 9326 159
2252399 2252399 2022-02-26 Mississippi Arkansas 5093 13076 185
2252400 2252400 2022-02-26 Monroe Arkansas 5095 1912 31
2252401 2252401 2022-02-26 Montgomery Arkansas 5097 1486 54
2252402 2252402 2022-02-26 Nevada Arkansas 5099 2147 44
2252403 2252403 2022-02-26 Newton Arkansas 5101 1700 45
2252404 2252404 2022-02-26 Ouachita Arkansas 5103 5371 95
2252405 2252405 2022-02-26 Perry Arkansas 5105 2474 32
2252406 2252406 2022-02-26 Phillips Arkansas 5107 4726 93
2252407 2252407 2022-02-26 Pike Arkansas 5109 2523 40
2252408 2252408 2022-02-26 Poinsett Arkansas 5111 7804 117
2252409 2252409 2022-02-26 Polk Arkansas 5113 4061 134
2252410 2252410 2022-02-26 Pope Arkansas 5115 18222 191
2252411 2252411 2022-02-26 Prairie Arkansas 5117 1948 39
2252412 2252412 2022-02-26 Pulaski Arkansas 5119 101659 1114
2252413 2252413 2022-02-26 Randolph Arkansas 5121 4839 80
2252414 2252414 2022-02-26 Saline Arkansas 5125 30371 304
2252415 2252415 2022-02-26 Scott Arkansas 5127 2261 38
2252416 2252416 2022-02-26 Searcy Arkansas 5129 2059 41
2252417 2252417 2022-02-26 Sebastian Arkansas 5131 32376 483
2252418 2252418 2022-02-26 Sevier Arkansas 5133 5748 67
2252419 2252419 2022-02-26 Sharp Arkansas 5135 4571 97
2252420 2252420 2022-02-26 St. Francis Arkansas 5123 7028 83
2252421 2252421 2022-02-26 Stone Arkansas 5137 2872 59
2252422 2252422 2022-02-26 Union Arkansas 5139 9066 161
2252423 2252423 2022-02-26 Unknown Arkansas   26090 0
2252424 2252424 2022-02-26 Van Buren Arkansas 5141 3430 56
2252425 2252425 2022-02-26 Washington Arkansas 5143 67296 583
2252426 2252426 2022-02-26 White Arkansas 5145 21598 263
2252427 2252427 2022-02-26 Woodruff Arkansas 5147 1706 26
2252428 2252428 2022-02-26 Yell Arkansas 5149 6762 102

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