Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
This data as json, CSV (advanced)
Suggested facets: date (date)
state
| Link | rowid | date ▲ | state | fips | cases | deaths |
|---|---|---|---|---|---|---|
| 5075 | 5075 | 2020-06-03 | Alabama | 1 | 18851 | 653 |
| 5076 | 5076 | 2020-06-03 | Alaska | 2 | 516 | 8 |
| 5077 | 5077 | 2020-06-03 | Arizona | 4 | 22245 | 983 |
| 5078 | 5078 | 2020-06-03 | Arkansas | 5 | 8067 | 142 |
| 5079 | 5079 | 2020-06-03 | California | 6 | 120407 | 4422 |
| 5080 | 5080 | 2020-06-03 | Colorado | 8 | 27046 | 1494 |
| 5081 | 5081 | 2020-06-03 | Connecticut | 9 | 43091 | 3989 |
| 5082 | 5082 | 2020-06-03 | Delaware | 10 | 9712 | 375 |
| 5083 | 5083 | 2020-06-03 | District of Columbia | 11 | 9016 | 473 |
| 5084 | 5084 | 2020-06-03 | Florida | 12 | 58756 | 2565 |
| 5085 | 5085 | 2020-06-03 | Georgia | 13 | 46711 | 2092 |
| 5086 | 5086 | 2020-06-03 | Guam | 66 | 1146 | 6 |
| 5087 | 5087 | 2020-06-03 | Hawaii | 15 | 643 | 17 |
| 5088 | 5088 | 2020-06-03 | Idaho | 16 | 2990 | 83 |
| 5089 | 5089 | 2020-06-03 | Illinois | 17 | 124279 | 5665 |
| 5090 | 5090 | 2020-06-03 | Indiana | 18 | 36609 | 2207 |
| 5091 | 5091 | 2020-06-03 | Iowa | 19 | 20376 | 574 |
| 5092 | 5092 | 2020-06-03 | Kansas | 20 | 10281 | 227 |
| 5093 | 5093 | 2020-06-03 | Kentucky | 21 | 10485 | 458 |
| 5094 | 5094 | 2020-06-03 | Louisiana | 22 | 41244 | 2870 |
| 5095 | 5095 | 2020-06-03 | Maine | 23 | 2418 | 95 |
| 5096 | 5096 | 2020-06-03 | Maryland | 24 | 55617 | 2641 |
| 5097 | 5097 | 2020-06-03 | Massachusetts | 25 | 101592 | 7152 |
| 5098 | 5098 | 2020-06-03 | Michigan | 26 | 58990 | 5579 |
| 5099 | 5099 | 2020-06-03 | Minnesota | 27 | 25881 | 1097 |
| 5100 | 5100 | 2020-06-03 | Mississippi | 28 | 16322 | 782 |
| 5101 | 5101 | 2020-06-03 | Missouri | 29 | 14020 | 801 |
| 5102 | 5102 | 2020-06-03 | Montana | 30 | 525 | 17 |
| 5103 | 5103 | 2020-06-03 | Nebraska | 31 | 14866 | 189 |
| 5104 | 5104 | 2020-06-03 | Nevada | 32 | 8950 | 429 |
| 5105 | 5105 | 2020-06-03 | New Hampshire | 33 | 4795 | 265 |
| 5106 | 5106 | 2020-06-03 | New Jersey | 34 | 162068 | 11880 |
| 5107 | 5107 | 2020-06-03 | New Mexico | 35 | 8140 | 375 |
| 5108 | 5108 | 2020-06-03 | New York | 36 | 378924 | 29918 |
| 5109 | 5109 | 2020-06-03 | North Carolina | 37 | 31013 | 971 |
| 5110 | 5110 | 2020-06-03 | North Dakota | 38 | 2682 | 69 |
| 5111 | 5111 | 2020-06-03 | Northern Mariana Islands | 69 | 24 | 2 |
| 5112 | 5112 | 2020-06-03 | Ohio | 39 | 36792 | 2299 |
| 5113 | 5113 | 2020-06-03 | Oklahoma | 40 | 6805 | 341 |
| 5114 | 5114 | 2020-06-03 | Oregon | 41 | 4399 | 159 |
| 5115 | 5115 | 2020-06-03 | Pennsylvania | 42 | 77871 | 5742 |
| 5116 | 5116 | 2020-06-03 | Puerto Rico | 72 | 4023 | 140 |
| 5117 | 5117 | 2020-06-03 | Rhode Island | 44 | 15219 | 742 |
| 5118 | 5118 | 2020-06-03 | South Carolina | 45 | 12651 | 518 |
| 5119 | 5119 | 2020-06-03 | South Dakota | 46 | 5162 | 62 |
| 5120 | 5120 | 2020-06-03 | Tennessee | 47 | 25024 | 386 |
| 5121 | 5121 | 2020-06-03 | Texas | 48 | 69546 | 1766 |
| 5122 | 5122 | 2020-06-03 | Utah | 49 | 10558 | 117 |
| 5123 | 5123 | 2020-06-03 | Vermont | 50 | 990 | 55 |
| 5124 | 5124 | 2020-06-03 | Virgin Islands | 78 | 70 | 6 |
| 5125 | 5125 | 2020-06-03 | Virginia | 51 | 46905 | 1428 |
| 5126 | 5126 | 2020-06-03 | Washington | 53 | 23500 | 1145 |
| 5127 | 5127 | 2020-06-03 | West Virginia | 54 | 2077 | 78 |
| 5128 | 5128 | 2020-06-03 | Wisconsin | 55 | 19614 | 618 |
| 5129 | 5129 | 2020-06-03 | Wyoming | 56 | 915 | 17 |
| 5020 | 5020 | 2020-06-02 | Alabama | 1 | 18771 | 653 |
| 5021 | 5021 | 2020-06-02 | Alaska | 2 | 497 | 8 |
| 5022 | 5022 | 2020-06-02 | Arizona | 4 | 21250 | 943 |
| 5023 | 5023 | 2020-06-02 | Arkansas | 5 | 7818 | 136 |
| 5024 | 5024 | 2020-06-02 | California | 6 | 118081 | 4360 |
| 5025 | 5025 | 2020-06-02 | Colorado | 8 | 26774 | 1474 |
| 5026 | 5026 | 2020-06-02 | Connecticut | 9 | 42979 | 3972 |
| 5027 | 5027 | 2020-06-02 | Delaware | 10 | 9685 | 373 |
| 5028 | 5028 | 2020-06-02 | District of Columbia | 11 | 8886 | 470 |
| 5029 | 5029 | 2020-06-02 | Florida | 12 | 57439 | 2529 |
| 5030 | 5030 | 2020-06-02 | Georgia | 13 | 46063 | 2070 |
| 5031 | 5031 | 2020-06-02 | Guam | 66 | 1146 | 6 |
| 5032 | 5032 | 2020-06-02 | Hawaii | 15 | 643 | 17 |
| 5033 | 5033 | 2020-06-02 | Idaho | 16 | 2935 | 83 |
| 5034 | 5034 | 2020-06-02 | Illinois | 17 | 123244 | 5567 |
| 5035 | 5035 | 2020-06-02 | Indiana | 18 | 36129 | 2197 |
| 5036 | 5036 | 2020-06-02 | Iowa | 19 | 20017 | 564 |
| 5037 | 5037 | 2020-06-02 | Kansas | 20 | 10143 | 227 |
| 5038 | 5038 | 2020-06-02 | Kentucky | 21 | 10287 | 451 |
| 5039 | 5039 | 2020-06-02 | Louisiana | 22 | 40857 | 2835 |
| 5040 | 5040 | 2020-06-02 | Maine | 23 | 2377 | 94 |
| 5041 | 5041 | 2020-06-02 | Maryland | 24 | 54831 | 2597 |
| 5042 | 5042 | 2020-06-02 | Massachusetts | 25 | 101163 | 7085 |
| 5043 | 5043 | 2020-06-02 | Michigan | 26 | 58680 | 5562 |
| 5044 | 5044 | 2020-06-02 | Minnesota | 27 | 25518 | 1082 |
| 5045 | 5045 | 2020-06-02 | Mississippi | 28 | 16020 | 767 |
| 5046 | 5046 | 2020-06-02 | Missouri | 29 | 13822 | 797 |
| 5047 | 5047 | 2020-06-02 | Montana | 30 | 523 | 17 |
| 5048 | 5048 | 2020-06-02 | Nebraska | 31 | 14611 | 187 |
| 5049 | 5049 | 2020-06-02 | Nevada | 32 | 8858 | 420 |
| 5050 | 5050 | 2020-06-02 | New Hampshire | 33 | 4749 | 256 |
| 5051 | 5051 | 2020-06-02 | New Jersey | 34 | 161545 | 11770 |
| 5052 | 5052 | 2020-06-02 | New Mexico | 35 | 8024 | 367 |
| 5053 | 5053 | 2020-06-02 | New York | 36 | 377881 | 29847 |
| 5054 | 5054 | 2020-06-02 | North Carolina | 37 | 30052 | 950 |
| 5055 | 5055 | 2020-06-02 | North Dakota | 38 | 2649 | 68 |
| 5056 | 5056 | 2020-06-02 | Northern Mariana Islands | 69 | 23 | 2 |
| 5057 | 5057 | 2020-06-02 | Ohio | 39 | 36350 | 2258 |
| 5058 | 5058 | 2020-06-02 | Oklahoma | 40 | 6692 | 339 |
| 5059 | 5059 | 2020-06-02 | Oregon | 41 | 4335 | 157 |
| 5060 | 5060 | 2020-06-02 | Pennsylvania | 42 | 77315 | 5670 |
| 5061 | 5061 | 2020-06-02 | Puerto Rico | 72 | 3935 | 138 |
| 5062 | 5062 | 2020-06-02 | Rhode Island | 44 | 15112 | 732 |
| 5063 | 5063 | 2020-06-02 | South Carolina | 45 | 12415 | 501 |
| 5064 | 5064 | 2020-06-02 | South Dakota | 46 | 5067 | 62 |
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );