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

75 rows where date = "2020-06-16" and state = "Arkansas" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

fips >30

state 1

  • Arkansas · 75 ✖
Link rowid date ▲ county state fips cases deaths
243353 243353 2020-06-16 Arkansas Arkansas 5001 8 0
243354 243354 2020-06-16 Ashley Arkansas 5003 47 1
243355 243355 2020-06-16 Baxter Arkansas 5005 14 0
243356 243356 2020-06-16 Benton Arkansas 5007 1514 8
243357 243357 2020-06-16 Boone Arkansas 5009 10 0
243358 243358 2020-06-16 Bradley Arkansas 5011 35 1
243359 243359 2020-06-16 Carroll Arkansas 5015 92 1
243360 243360 2020-06-16 Chicot Arkansas 5017 58 2
243361 243361 2020-06-16 Clark Arkansas 5019 48 0
243362 243362 2020-06-16 Clay Arkansas 5021 22 0
243363 243363 2020-06-16 Cleburne Arkansas 5023 75 4
243364 243364 2020-06-16 Cleveland Arkansas 5025 20 0
243365 243365 2020-06-16 Columbia Arkansas 5027 29 2
243366 243366 2020-06-16 Conway Arkansas 5029 24 2
243367 243367 2020-06-16 Craighead Arkansas 5031 365 2
243368 243368 2020-06-16 Crawford Arkansas 5033 65 0
243369 243369 2020-06-16 Crittenden Arkansas 5035 545 10
243370 243370 2020-06-16 Cross Arkansas 5037 79 0
243371 243371 2020-06-16 Dallas Arkansas 5039 4 0
243372 243372 2020-06-16 Desha Arkansas 5041 23 0
243373 243373 2020-06-16 Drew Arkansas 5043 26 1
243374 243374 2020-06-16 Faulkner Arkansas 5045 180 3
243375 243375 2020-06-16 Franklin Arkansas 5047 9 0
243376 243376 2020-06-16 Fulton Arkansas 5049 9 0
243377 243377 2020-06-16 Garland Arkansas 5051 165 1
243378 243378 2020-06-16 Grant Arkansas 5053 24 0
243379 243379 2020-06-16 Greene Arkansas 5055 74 0
243380 243380 2020-06-16 Hempstead Arkansas 5057 40 1
243381 243381 2020-06-16 Hot Spring Arkansas 5059 43 0
243382 243382 2020-06-16 Howard Arkansas 5061 42 0
243383 243383 2020-06-16 Independence Arkansas 5063 43 0
243384 243384 2020-06-16 Izard Arkansas 5065 20 1
243385 243385 2020-06-16 Jackson Arkansas 5067 16 0
243386 243386 2020-06-16 Jefferson Arkansas 5069 633 28
243387 243387 2020-06-16 Johnson Arkansas 5071 93 0
243388 243388 2020-06-16 Lafayette Arkansas 5073 11 1
243389 243389 2020-06-16 Lawrence Arkansas 5075 91 9
243390 243390 2020-06-16 Lee Arkansas 5077 545 1
243391 243391 2020-06-16 Lincoln Arkansas 5079 995 11
243392 243392 2020-06-16 Little River Arkansas 5081 34 0
243393 243393 2020-06-16 Logan Arkansas 5083 20 0
243394 243394 2020-06-16 Lonoke Arkansas 5085 75 0
243395 243395 2020-06-16 Madison Arkansas 5087 122 0
243396 243396 2020-06-16 Marion Arkansas 5089 2 0
243397 243397 2020-06-16 Miller Arkansas 5091 73 2
243398 243398 2020-06-16 Mississippi Arkansas 5093 98 2
243399 243399 2020-06-16 Monroe Arkansas 5095 7 0
243400 243400 2020-06-16 Montgomery Arkansas 5097 2 0
243401 243401 2020-06-16 Nevada Arkansas 5099 83 1
243402 243402 2020-06-16 Newton Arkansas 5101 3 0
243403 243403 2020-06-16 Ouachita Arkansas 5103 16 0
243404 243404 2020-06-16 Perry Arkansas 5105 16 0
243405 243405 2020-06-16 Phillips Arkansas 5107 52 1
243406 243406 2020-06-16 Pike Arkansas 5109 7 0
243407 243407 2020-06-16 Poinsett Arkansas 5111 51 3
243408 243408 2020-06-16 Polk Arkansas 5113 58 0
243409 243409 2020-06-16 Pope Arkansas 5115 285 2
243410 243410 2020-06-16 Prairie Arkansas 5117 9 0
243411 243411 2020-06-16 Pulaski Arkansas 5119 1343 43
243412 243412 2020-06-16 Randolph Arkansas 5121 29 0
243413 243413 2020-06-16 Saline Arkansas 5125 184 2
243414 243414 2020-06-16 Scott Arkansas 5127 5 0
243415 243415 2020-06-16 Searcy Arkansas 5129 7 0
243416 243416 2020-06-16 Sebastian Arkansas 5131 169 2
243417 243417 2020-06-16 Sevier Arkansas 5133 478 5
243418 243418 2020-06-16 Sharp Arkansas 5135 50 3
243419 243419 2020-06-16 St. Francis Arkansas 5123 779 3
243420 243420 2020-06-16 Stone Arkansas 5137 11 0
243421 243421 2020-06-16 Union Arkansas 5139 209 11
243422 243422 2020-06-16 Unknown Arkansas   396 0
243423 243423 2020-06-16 Van Buren Arkansas 5141 30 2
243424 243424 2020-06-16 Washington Arkansas 5143 1977 13
243425 243425 2020-06-16 White Arkansas 5145 61 1
243426 243426 2020-06-16 Woodruff Arkansas 5147 5 0
243427 243427 2020-06-16 Yell Arkansas 5149 309 2

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