ny_times_us_counties

⚠️ 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

294,842 rows sorted by date descending

View and edit SQL

state

fips

county

Link rowid date ▲ county state fips cases deaths
276484 2020-06-28 Northwest Arctic Borough Alaska 2188 4 0
276485 2020-06-28 Petersburg Borough Alaska 2195 4 0
276486 2020-06-28 Prince of Wales-Hyder Census Area Alaska 2198 3 0
276487 2020-06-28 Sitka City and Borough Alaska 2220 15 0
276488 2020-06-28 Southeast Fairbanks Census Area Alaska 2240 11 0
276489 2020-06-28 Unknown Alaska   11 0
276490 2020-06-28 Valdez-Cordova Census Area Alaska 2261 20 0
276491 2020-06-28 Wrangell City and Borough Alaska 2275 8 0
276492 2020-06-28 Yukon-Koyukuk Census Area Alaska 2290 3 0
276493 2020-06-28 Apache Arizona 4001 2303 85
276494 2020-06-28 Cochise Arizona 4003 573 6
276495 2020-06-28 Coconino Arizona 4005 1819 92
276496 2020-06-28 Gila Arizona 4007 268 5
276497 2020-06-28 Graham Arizona 4009 85 2
276498 2020-06-28 Greenlee Arizona 4011 18 1
276499 2020-06-28 La Paz Arizona 4012 328 5
276500 2020-06-28 Maricopa Arizona 4013 44962 746
276501 2020-06-28 Mohave Arizona 4015 1004 85
276502 2020-06-28 Navajo Arizona 4017 3537 124
276503 2020-06-28 Pima Arizona 4019 7525 268
276504 2020-06-28 Pinal Arizona 4021 3350 63
276505 2020-06-28 Santa Cruz Arizona 4023 1728 18
276506 2020-06-28 Yavapai Arizona 4025 668 8
276507 2020-06-28 Yuma Arizona 4027 5793 86
276508 2020-06-28 Arkansas Arkansas 5001 26 0
276509 2020-06-28 Ashley Arkansas 5003 68 1
276510 2020-06-28 Baxter Arkansas 5005 20 0
276511 2020-06-28 Benton Arkansas 5007 2623 18
276512 2020-06-28 Boone Arkansas 5009 22 1
276513 2020-06-28 Bradley Arkansas 5011 42 2
276514 2020-06-28 Carroll Arkansas 5015 166 5
276515 2020-06-28 Chicot Arkansas 5017 120 3
276516 2020-06-28 Clark Arkansas 5019 56 0
276517 2020-06-28 Clay Arkansas 5021 54 3
276518 2020-06-28 Cleburne Arkansas 5023 84 4
276519 2020-06-28 Cleveland Arkansas 5025 25 0
276520 2020-06-28 Columbia Arkansas 5027 84 3
276521 2020-06-28 Conway Arkansas 5029 47 3
276522 2020-06-28 Craighead Arkansas 5031 442 6
276523 2020-06-28 Crawford Arkansas 5033 148 0
276524 2020-06-28 Crittenden Arkansas 5035 731 11
276525 2020-06-28 Cross Arkansas 5037 85 1
276526 2020-06-28 Dallas Arkansas 5039 9 0
276527 2020-06-28 Desha Arkansas 5041 44 0
276528 2020-06-28 Drew Arkansas 5043 63 1
276529 2020-06-28 Faulkner Arkansas 5045 437 3
276530 2020-06-28 Franklin Arkansas 5047 17 0
276531 2020-06-28 Fulton Arkansas 5049 12 0
276532 2020-06-28 Garland Arkansas 5051 237 1
276533 2020-06-28 Grant Arkansas 5053 34 0
276534 2020-06-28 Greene Arkansas 5055 114 0
276535 2020-06-28 Hempstead Arkansas 5057 48 1
276536 2020-06-28 Hot Spring Arkansas 5059 423 0
276537 2020-06-28 Howard Arkansas 5061 82 1
276538 2020-06-28 Independence Arkansas 5063 54 0
276539 2020-06-28 Izard Arkansas 5065 20 1
276540 2020-06-28 Jackson Arkansas 5067 27 0
276541 2020-06-28 Jefferson Arkansas 5069 683 28
276542 2020-06-28 Johnson Arkansas 5071 210 0
276543 2020-06-28 Lafayette Arkansas 5073 16 1
276544 2020-06-28 Lawrence Arkansas 5075 99 9
276545 2020-06-28 Lee Arkansas 5077 628 2
276546 2020-06-28 Lincoln Arkansas 5079 1037 11
276547 2020-06-28 Little River Arkansas 5081 38 0
276548 2020-06-28 Logan Arkansas 5083 46 0
276549 2020-06-28 Lonoke Arkansas 5085 132 1
276550 2020-06-28 Madison Arkansas 5087 188 0
276551 2020-06-28 Marion Arkansas 5089 4 0
276552 2020-06-28 Miller Arkansas 5091 111 2
276553 2020-06-28 Mississippi Arkansas 5093 157 3
276554 2020-06-28 Monroe Arkansas 5095 12 0
276555 2020-06-28 Montgomery Arkansas 5097 4 0
276556 2020-06-28 Nevada Arkansas 5099 101 2
276557 2020-06-28 Newton Arkansas 5101 5 0
276558 2020-06-28 Ouachita Arkansas 5103 21 0
276559 2020-06-28 Perry Arkansas 5105 29 0
276560 2020-06-28 Phillips Arkansas 5107 132 3
276561 2020-06-28 Pike Arkansas 5109 8 0
276562 2020-06-28 Poinsett Arkansas 5111 57 3
276563 2020-06-28 Polk Arkansas 5113 72 0
276564 2020-06-28 Pope Arkansas 5115 414 3
276565 2020-06-28 Prairie Arkansas 5117 20 0
276566 2020-06-28 Pulaski Arkansas 5119 1862 56
276567 2020-06-28 Randolph Arkansas 5121 46 1
276568 2020-06-28 Saline Arkansas 5125 250 2
276569 2020-06-28 Scott Arkansas 5127 10 0
276570 2020-06-28 Searcy Arkansas 5129 7 0
276571 2020-06-28 Sebastian Arkansas 5131 435 5
276572 2020-06-28 Sevier Arkansas 5133 661 7
276573 2020-06-28 Sharp Arkansas 5135 53 4
276574 2020-06-28 St. Francis Arkansas 5123 810 3
276575 2020-06-28 Stone Arkansas 5137 13 0
276576 2020-06-28 Union Arkansas 5139 245 13
276577 2020-06-28 Unknown Arkansas   712 0
276578 2020-06-28 Van Buren Arkansas 5141 34 2
276579 2020-06-28 Washington Arkansas 5143 3320 30
276580 2020-06-28 White Arkansas 5145 84 1
276581 2020-06-28 Woodruff Arkansas 5147 6 0
276582 2020-06-28 Yell Arkansas 5149 582 3
276583 2020-06-28 Alameda California 6001 5691 133

Next page

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
);
Powered by Datasette · Query took 1629.874ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette