ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
57,238 rows sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
state >30
- Washington 1,074
- Illinois 1,071
- California 1,070
- Arizona 1,069
- Massachusetts 1,063
- Wisconsin 1,059
- Texas 1,052
- Nebraska 1,047
- Utah 1,039
- Oregon 1,036
- Florida 1,034
- New York 1,034
- Rhode Island 1,034
- Georgia 1,033
- New Hampshire 1,033
- North Carolina 1,032
- New Jersey 1,031
- Colorado 1,030
- Maryland 1,030
- Nevada 1,030
- Tennessee 1,030
- Hawaii 1,029
- Indiana 1,029
- Kentucky 1,029
- Minnesota 1,029
- Oklahoma 1,029
- Pennsylvania 1,029
- South Carolina 1,029
- District of Columbia 1,028
- Kansas 1,028
- …
Link | rowid | date | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|
539 | 539 | 2020-03-11 | Wyoming | 56 | 1 | 0 |
586 | 586 | 2020-03-12 | Wyoming | 56 | 1 | 0 |
637 | 637 | 2020-03-13 | Wyoming | 56 | 2 | 0 |
689 | 689 | 2020-03-14 | Wyoming | 56 | 3 | 0 |
742 | 742 | 2020-03-15 | Wyoming | 56 | 3 | 0 |
795 | 795 | 2020-03-16 | Wyoming | 56 | 10 | 0 |
849 | 849 | 2020-03-17 | Wyoming | 56 | 15 | 0 |
903 | 903 | 2020-03-18 | Wyoming | 56 | 17 | 0 |
957 | 957 | 2020-03-19 | Wyoming | 56 | 18 | 0 |
1011 | 1011 | 2020-03-20 | Wyoming | 56 | 22 | 0 |
1065 | 1065 | 2020-03-21 | Wyoming | 56 | 24 | 0 |
1119 | 1119 | 2020-03-22 | Wyoming | 56 | 26 | 0 |
1173 | 1173 | 2020-03-23 | Wyoming | 56 | 28 | 0 |
1227 | 1227 | 2020-03-24 | Wyoming | 56 | 37 | 0 |
1281 | 1281 | 2020-03-25 | Wyoming | 56 | 49 | 0 |
1335 | 1335 | 2020-03-26 | Wyoming | 56 | 56 | 0 |
1389 | 1389 | 2020-03-27 | Wyoming | 56 | 74 | 0 |
1444 | 1444 | 2020-03-28 | Wyoming | 56 | 85 | 0 |
1499 | 1499 | 2020-03-29 | Wyoming | 56 | 88 | 0 |
1554 | 1554 | 2020-03-30 | Wyoming | 56 | 96 | 0 |
1609 | 1609 | 2020-03-31 | Wyoming | 56 | 121 | 0 |
1664 | 1664 | 2020-04-01 | Wyoming | 56 | 138 | 0 |
1719 | 1719 | 2020-04-02 | Wyoming | 56 | 154 | 0 |
1774 | 1774 | 2020-04-03 | Wyoming | 56 | 167 | 0 |
1829 | 1829 | 2020-04-04 | Wyoming | 56 | 189 | 0 |
1884 | 1884 | 2020-04-05 | Wyoming | 56 | 200 | 0 |
1939 | 1939 | 2020-04-06 | Wyoming | 56 | 213 | 0 |
1994 | 1994 | 2020-04-07 | Wyoming | 56 | 221 | 0 |
2049 | 2049 | 2020-04-08 | Wyoming | 56 | 230 | 0 |
2104 | 2104 | 2020-04-09 | Wyoming | 56 | 303 | 0 |
2159 | 2159 | 2020-04-10 | Wyoming | 56 | 320 | 0 |
2214 | 2214 | 2020-04-11 | Wyoming | 56 | 343 | 0 |
2269 | 2269 | 2020-04-12 | Wyoming | 56 | 364 | 0 |
2324 | 2324 | 2020-04-13 | Wyoming | 56 | 373 | 1 |
2379 | 2379 | 2020-04-14 | Wyoming | 56 | 373 | 1 |
2434 | 2434 | 2020-04-15 | Wyoming | 56 | 392 | 2 |
2489 | 2489 | 2020-04-16 | Wyoming | 56 | 393 | 2 |
2544 | 2544 | 2020-04-17 | Wyoming | 56 | 401 | 2 |
2599 | 2599 | 2020-04-18 | Wyoming | 56 | 412 | 2 |
2654 | 2654 | 2020-04-19 | Wyoming | 56 | 422 | 2 |
2709 | 2709 | 2020-04-20 | Wyoming | 56 | 426 | 2 |
2764 | 2764 | 2020-04-21 | Wyoming | 56 | 442 | 6 |
2819 | 2819 | 2020-04-22 | Wyoming | 56 | 447 | 6 |
2874 | 2874 | 2020-04-23 | Wyoming | 56 | 453 | 7 |
2929 | 2929 | 2020-04-24 | Wyoming | 56 | 473 | 7 |
2984 | 2984 | 2020-04-25 | Wyoming | 56 | 477 | 7 |
3039 | 3039 | 2020-04-26 | Wyoming | 56 | 502 | 7 |
3094 | 3094 | 2020-04-27 | Wyoming | 56 | 520 | 7 |
3149 | 3149 | 2020-04-28 | Wyoming | 56 | 536 | 7 |
3204 | 3204 | 2020-04-29 | Wyoming | 56 | 544 | 7 |
3259 | 3259 | 2020-04-30 | Wyoming | 56 | 559 | 7 |
3314 | 3314 | 2020-05-01 | Wyoming | 56 | 566 | 7 |
3369 | 3369 | 2020-05-02 | Wyoming | 56 | 579 | 7 |
3424 | 3424 | 2020-05-03 | Wyoming | 56 | 586 | 7 |
3479 | 3479 | 2020-05-04 | Wyoming | 56 | 596 | 7 |
3534 | 3534 | 2020-05-05 | Wyoming | 56 | 604 | 7 |
3589 | 3589 | 2020-05-06 | Wyoming | 56 | 631 | 7 |
3644 | 3644 | 2020-05-07 | Wyoming | 56 | 635 | 7 |
3699 | 3699 | 2020-05-08 | Wyoming | 56 | 644 | 7 |
3754 | 3754 | 2020-05-09 | Wyoming | 56 | 653 | 7 |
3809 | 3809 | 2020-05-10 | Wyoming | 56 | 662 | 7 |
3864 | 3864 | 2020-05-11 | Wyoming | 56 | 669 | 7 |
3919 | 3919 | 2020-05-12 | Wyoming | 56 | 675 | 7 |
3974 | 3974 | 2020-05-13 | Wyoming | 56 | 688 | 7 |
4029 | 4029 | 2020-05-14 | Wyoming | 56 | 701 | 7 |
4084 | 4084 | 2020-05-15 | Wyoming | 56 | 716 | 7 |
4139 | 4139 | 2020-05-16 | Wyoming | 56 | 741 | 7 |
4194 | 4194 | 2020-05-17 | Wyoming | 56 | 754 | 8 |
4249 | 4249 | 2020-05-18 | Wyoming | 56 | 766 | 10 |
4304 | 4304 | 2020-05-19 | Wyoming | 56 | 776 | 10 |
4359 | 4359 | 2020-05-20 | Wyoming | 56 | 787 | 11 |
4414 | 4414 | 2020-05-21 | Wyoming | 56 | 801 | 12 |
4469 | 4469 | 2020-05-22 | Wyoming | 56 | 803 | 12 |
4524 | 4524 | 2020-05-23 | Wyoming | 56 | 813 | 12 |
4579 | 4579 | 2020-05-24 | Wyoming | 56 | 813 | 12 |
4634 | 4634 | 2020-05-25 | Wyoming | 56 | 843 | 12 |
4689 | 4689 | 2020-05-26 | Wyoming | 56 | 850 | 13 |
4744 | 4744 | 2020-05-27 | Wyoming | 56 | 860 | 14 |
4799 | 4799 | 2020-05-28 | Wyoming | 56 | 876 | 15 |
4854 | 4854 | 2020-05-29 | Wyoming | 56 | 891 | 15 |
4909 | 4909 | 2020-05-30 | Wyoming | 56 | 898 | 16 |
4964 | 4964 | 2020-05-31 | Wyoming | 56 | 903 | 16 |
5019 | 5019 | 2020-06-01 | Wyoming | 56 | 910 | 17 |
5074 | 5074 | 2020-06-02 | Wyoming | 56 | 912 | 17 |
5129 | 5129 | 2020-06-03 | Wyoming | 56 | 915 | 17 |
5184 | 5184 | 2020-06-04 | Wyoming | 56 | 921 | 17 |
5239 | 5239 | 2020-06-05 | Wyoming | 56 | 933 | 17 |
5294 | 5294 | 2020-06-06 | Wyoming | 56 | 939 | 17 |
5349 | 5349 | 2020-06-07 | Wyoming | 56 | 947 | 17 |
5404 | 5404 | 2020-06-08 | Wyoming | 56 | 960 | 17 |
5459 | 5459 | 2020-06-09 | Wyoming | 56 | 970 | 17 |
5514 | 5514 | 2020-06-10 | Wyoming | 56 | 980 | 18 |
5569 | 5569 | 2020-06-11 | Wyoming | 56 | 1009 | 18 |
5624 | 5624 | 2020-06-12 | Wyoming | 56 | 1027 | 18 |
5679 | 5679 | 2020-06-13 | Wyoming | 56 | 1050 | 18 |
5734 | 5734 | 2020-06-14 | Wyoming | 56 | 1060 | 18 |
5789 | 5789 | 2020-06-15 | Wyoming | 56 | 1079 | 18 |
5844 | 5844 | 2020-06-16 | Wyoming | 56 | 1089 | 18 |
5899 | 5899 | 2020-06-17 | Wyoming | 56 | 1114 | 18 |
5954 | 5954 | 2020-06-18 | Wyoming | 56 | 1144 | 18 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );