ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,027 rows where state = "Connecticut" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
state 1
- Connecticut · 1,027 ✖
Link | rowid | date ▼ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
387 | 387 | 2020-03-08 | Connecticut | 9 | 1 | 0 |
422 | 422 | 2020-03-09 | Connecticut | 9 | 2 | 0 |
459 | 459 | 2020-03-10 | Connecticut | 9 | 2 | 0 |
499 | 499 | 2020-03-11 | Connecticut | 9 | 3 | 0 |
545 | 545 | 2020-03-12 | Connecticut | 9 | 6 | 0 |
593 | 593 | 2020-03-13 | Connecticut | 9 | 11 | 0 |
644 | 644 | 2020-03-14 | Connecticut | 9 | 20 | 0 |
696 | 696 | 2020-03-15 | Connecticut | 9 | 26 | 0 |
749 | 749 | 2020-03-16 | Connecticut | 9 | 41 | 0 |
802 | 802 | 2020-03-17 | Connecticut | 9 | 68 | 0 |
856 | 856 | 2020-03-18 | Connecticut | 9 | 96 | 1 |
910 | 910 | 2020-03-19 | Connecticut | 9 | 159 | 4 |
964 | 964 | 2020-03-20 | Connecticut | 9 | 194 | 4 |
1018 | 1018 | 2020-03-21 | Connecticut | 9 | 223 | 5 |
1072 | 1072 | 2020-03-22 | Connecticut | 9 | 327 | 8 |
1126 | 1126 | 2020-03-23 | Connecticut | 9 | 415 | 10 |
1180 | 1180 | 2020-03-24 | Connecticut | 9 | 618 | 12 |
1234 | 1234 | 2020-03-25 | Connecticut | 9 | 875 | 19 |
1288 | 1288 | 2020-03-26 | Connecticut | 9 | 1012 | 21 |
1342 | 1342 | 2020-03-27 | Connecticut | 9 | 1291 | 27 |
1396 | 1396 | 2020-03-28 | Connecticut | 9 | 1524 | 33 |
1451 | 1451 | 2020-03-29 | Connecticut | 9 | 1993 | 34 |
1506 | 1506 | 2020-03-30 | Connecticut | 9 | 2571 | 36 |
1561 | 1561 | 2020-03-31 | Connecticut | 9 | 3128 | 69 |
1616 | 1616 | 2020-04-01 | Connecticut | 9 | 3557 | 85 |
1671 | 1671 | 2020-04-02 | Connecticut | 9 | 3824 | 112 |
1726 | 1726 | 2020-04-03 | Connecticut | 9 | 4915 | 132 |
1781 | 1781 | 2020-04-04 | Connecticut | 9 | 5276 | 165 |
1836 | 1836 | 2020-04-05 | Connecticut | 9 | 5675 | 189 |
1891 | 1891 | 2020-04-06 | Connecticut | 9 | 6906 | 206 |
1946 | 1946 | 2020-04-07 | Connecticut | 9 | 7781 | 277 |
2001 | 2001 | 2020-04-08 | Connecticut | 9 | 8781 | 335 |
2056 | 2056 | 2020-04-09 | Connecticut | 9 | 9784 | 380 |
2111 | 2111 | 2020-04-10 | Connecticut | 9 | 10538 | 448 |
2166 | 2166 | 2020-04-11 | Connecticut | 9 | 11510 | 494 |
2221 | 2221 | 2020-04-12 | Connecticut | 9 | 12035 | 554 |
2276 | 2276 | 2020-04-13 | Connecticut | 9 | 13381 | 602 |
2331 | 2331 | 2020-04-14 | Connecticut | 9 | 13989 | 671 |
2386 | 2386 | 2020-04-15 | Connecticut | 9 | 14755 | 868 |
2441 | 2441 | 2020-04-16 | Connecticut | 9 | 15884 | 971 |
2496 | 2496 | 2020-04-17 | Connecticut | 9 | 16809 | 1036 |
2551 | 2551 | 2020-04-18 | Connecticut | 9 | 17550 | 1086 |
2606 | 2606 | 2020-04-19 | Connecticut | 9 | 17962 | 1127 |
2661 | 2661 | 2020-04-20 | Connecticut | 9 | 19815 | 1331 |
2716 | 2716 | 2020-04-21 | Connecticut | 9 | 20360 | 1423 |
2771 | 2771 | 2020-04-22 | Connecticut | 9 | 22469 | 1544 |
2826 | 2826 | 2020-04-23 | Connecticut | 9 | 23100 | 1639 |
2881 | 2881 | 2020-04-24 | Connecticut | 9 | 23921 | 1764 |
2936 | 2936 | 2020-04-25 | Connecticut | 9 | 24582 | 1862 |
2991 | 2991 | 2020-04-26 | Connecticut | 9 | 25269 | 1925 |
3046 | 3046 | 2020-04-27 | Connecticut | 9 | 25997 | 2012 |
3101 | 3101 | 2020-04-28 | Connecticut | 9 | 26312 | 2089 |
3156 | 3156 | 2020-04-29 | Connecticut | 9 | 26767 | 2168 |
3211 | 3211 | 2020-04-30 | Connecticut | 9 | 27700 | 2257 |
3266 | 3266 | 2020-05-01 | Connecticut | 9 | 28764 | 2339 |
3321 | 3321 | 2020-05-02 | Connecticut | 9 | 29287 | 2436 |
3376 | 3376 | 2020-05-03 | Connecticut | 9 | 29287 | 2436 |
3431 | 3431 | 2020-05-04 | Connecticut | 9 | 29973 | 2556 |
3486 | 3486 | 2020-05-05 | Connecticut | 9 | 30621 | 2633 |
3541 | 3541 | 2020-05-06 | Connecticut | 9 | 30995 | 2718 |
3596 | 3596 | 2020-05-07 | Connecticut | 9 | 31784 | 2797 |
3651 | 3651 | 2020-05-08 | Connecticut | 9 | 32411 | 2874 |
3706 | 3706 | 2020-05-09 | Connecticut | 9 | 32984 | 2932 |
3761 | 3761 | 2020-05-10 | Connecticut | 9 | 33554 | 2967 |
3816 | 3816 | 2020-05-11 | Connecticut | 9 | 33765 | 3008 |
3871 | 3871 | 2020-05-12 | Connecticut | 9 | 34333 | 3041 |
3926 | 3926 | 2020-05-13 | Connecticut | 9 | 34855 | 3125 |
3981 | 3981 | 2020-05-14 | Connecticut | 9 | 35464 | 3219 |
4036 | 4036 | 2020-05-15 | Connecticut | 9 | 36085 | 3285 |
4091 | 4091 | 2020-05-16 | Connecticut | 9 | 36703 | 3339 |
4146 | 4146 | 2020-05-17 | Connecticut | 9 | 37419 | 3408 |
4201 | 4201 | 2020-05-18 | Connecticut | 9 | 38116 | 3449 |
4256 | 4256 | 2020-05-19 | Connecticut | 9 | 38430 | 3472 |
4311 | 4311 | 2020-05-20 | Connecticut | 9 | 39017 | 3529 |
4366 | 4366 | 2020-05-21 | Connecticut | 9 | 39208 | 3582 |
4421 | 4421 | 2020-05-22 | Connecticut | 9 | 39640 | 3637 |
4476 | 4476 | 2020-05-23 | Connecticut | 9 | 40022 | 3675 |
4531 | 4531 | 2020-05-24 | Connecticut | 9 | 40468 | 3693 |
4586 | 4586 | 2020-05-25 | Connecticut | 9 | 40873 | 3742 |
4641 | 4641 | 2020-05-26 | Connecticut | 9 | 41303 | 3769 |
4696 | 4696 | 2020-05-27 | Connecticut | 9 | 41288 | 3803 |
4751 | 4751 | 2020-05-28 | Connecticut | 9 | 41559 | 3826 |
4806 | 4806 | 2020-05-29 | Connecticut | 9 | 41762 | 3868 |
4861 | 4861 | 2020-05-30 | Connecticut | 9 | 42022 | 3912 |
4916 | 4916 | 2020-05-31 | Connecticut | 9 | 42201 | 3944 |
4971 | 4971 | 2020-06-01 | Connecticut | 9 | 42740 | 3964 |
5026 | 5026 | 2020-06-02 | Connecticut | 9 | 42979 | 3972 |
5081 | 5081 | 2020-06-03 | Connecticut | 9 | 43091 | 3989 |
5136 | 5136 | 2020-06-04 | Connecticut | 9 | 43239 | 4007 |
5191 | 5191 | 2020-06-05 | Connecticut | 9 | 43460 | 4038 |
5246 | 5246 | 2020-06-06 | Connecticut | 9 | 43818 | 4055 |
5301 | 5301 | 2020-06-07 | Connecticut | 9 | 43968 | 4071 |
5356 | 5356 | 2020-06-08 | Connecticut | 9 | 44092 | 4084 |
5411 | 5411 | 2020-06-09 | Connecticut | 9 | 44179 | 4097 |
5466 | 5466 | 2020-06-10 | Connecticut | 9 | 44347 | 4120 |
5521 | 5521 | 2020-06-11 | Connecticut | 9 | 44461 | 4146 |
5576 | 5576 | 2020-06-12 | Connecticut | 9 | 44689 | 4159 |
5631 | 5631 | 2020-06-13 | Connecticut | 9 | 44994 | 4186 |
5686 | 5686 | 2020-06-14 | Connecticut | 9 | 45088 | 4201 |
5741 | 5741 | 2020-06-15 | Connecticut | 9 | 45235 | 4204 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );