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 descending
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 |
---|---|---|---|---|---|---|
57190 | 57190 | 2022-12-29 | Connecticut | 9 | 947016 | 11770 |
57134 | 57134 | 2022-12-28 | Connecticut | 9 | 946236 | 11766 |
57078 | 57078 | 2022-12-27 | Connecticut | 9 | 945045 | 11733 |
57022 | 57022 | 2022-12-26 | Connecticut | 9 | 944755 | 11733 |
56966 | 56966 | 2022-12-25 | Connecticut | 9 | 944493 | 11733 |
56910 | 56910 | 2022-12-24 | Connecticut | 9 | 943284 | 11733 |
56854 | 56854 | 2022-12-23 | Connecticut | 9 | 943284 | 11733 |
56798 | 56798 | 2022-12-22 | Connecticut | 9 | 942022 | 11733 |
56742 | 56742 | 2022-12-21 | Connecticut | 9 | 941267 | 11733 |
56686 | 56686 | 2022-12-20 | Connecticut | 9 | 940702 | 11733 |
56630 | 56630 | 2022-12-19 | Connecticut | 9 | 939281 | 11665 |
56574 | 56574 | 2022-12-18 | Connecticut | 9 | 938943 | 11665 |
56518 | 56518 | 2022-12-17 | Connecticut | 9 | 937673 | 11665 |
56462 | 56462 | 2022-12-16 | Connecticut | 9 | 937673 | 11665 |
56406 | 56406 | 2022-12-15 | Connecticut | 9 | 936976 | 11659 |
56350 | 56350 | 2022-12-14 | Connecticut | 9 | 936024 | 11659 |
56294 | 56294 | 2022-12-13 | Connecticut | 9 | 935123 | 11656 |
56238 | 56238 | 2022-12-12 | Connecticut | 9 | 934388 | 11603 |
56182 | 56182 | 2022-12-11 | Connecticut | 9 | 933631 | 11603 |
56126 | 56126 | 2022-12-10 | Connecticut | 9 | 932781 | 11603 |
56070 | 56070 | 2022-12-09 | Connecticut | 9 | 932781 | 11603 |
56014 | 56014 | 2022-12-08 | Connecticut | 9 | 932066 | 11603 |
55958 | 55958 | 2022-12-07 | Connecticut | 9 | 931371 | 11603 |
55902 | 55902 | 2022-12-06 | Connecticut | 9 | 930723 | 11602 |
55846 | 55846 | 2022-12-05 | Connecticut | 9 | 929899 | 11587 |
55790 | 55790 | 2022-12-04 | Connecticut | 9 | 929619 | 11587 |
55734 | 55734 | 2022-12-03 | Connecticut | 9 | 928712 | 11587 |
55678 | 55678 | 2022-12-02 | Connecticut | 9 | 928712 | 11587 |
55622 | 55622 | 2022-12-01 | Connecticut | 9 | 927641 | 11587 |
55566 | 55566 | 2022-11-30 | Connecticut | 9 | 926947 | 11587 |
55510 | 55510 | 2022-11-29 | Connecticut | 9 | 926106 | 11587 |
55454 | 55454 | 2022-11-28 | Connecticut | 9 | 925377 | 11572 |
55398 | 55398 | 2022-11-27 | Connecticut | 9 | 925223 | 11572 |
55342 | 55342 | 2022-11-26 | Connecticut | 9 | 924141 | 11572 |
55286 | 55286 | 2022-11-25 | Connecticut | 9 | 924141 | 11572 |
55230 | 55230 | 2022-11-24 | Connecticut | 9 | 923912 | 11572 |
55174 | 55174 | 2022-11-23 | Connecticut | 9 | 923276 | 11572 |
55118 | 55118 | 2022-11-22 | Connecticut | 9 | 922159 | 11572 |
55062 | 55062 | 2022-11-21 | Connecticut | 9 | 921739 | 11559 |
55006 | 55006 | 2022-11-20 | Connecticut | 9 | 921588 | 11559 |
54950 | 54950 | 2022-11-19 | Connecticut | 9 | 921038 | 11559 |
54894 | 54894 | 2022-11-18 | Connecticut | 9 | 921038 | 11559 |
54838 | 54838 | 2022-11-17 | Connecticut | 9 | 920500 | 11559 |
54782 | 54782 | 2022-11-16 | Connecticut | 9 | 920112 | 11559 |
54726 | 54726 | 2022-11-15 | Connecticut | 9 | 919722 | 11549 |
54670 | 54670 | 2022-11-14 | Connecticut | 9 | 918876 | 11537 |
54614 | 54614 | 2022-11-13 | Connecticut | 9 | 918761 | 11537 |
54558 | 54558 | 2022-11-12 | Connecticut | 9 | 918320 | 11537 |
54502 | 54502 | 2022-11-11 | Connecticut | 9 | 918320 | 11537 |
54446 | 54446 | 2022-11-10 | Connecticut | 9 | 917119 | 11528 |
54390 | 54390 | 2022-11-09 | Connecticut | 9 | 916657 | 11527 |
54334 | 54334 | 2022-11-08 | Connecticut | 9 | 916172 | 11477 |
54278 | 54278 | 2022-11-07 | Connecticut | 9 | 915785 | 11478 |
54222 | 54222 | 2022-11-06 | Connecticut | 9 | 915594 | 11478 |
54166 | 54166 | 2022-11-05 | Connecticut | 9 | 914850 | 11478 |
54110 | 54110 | 2022-11-04 | Connecticut | 9 | 914850 | 11478 |
54054 | 54054 | 2022-11-03 | Connecticut | 9 | 914441 | 11478 |
53998 | 53998 | 2022-11-02 | Connecticut | 9 | 913979 | 11478 |
53942 | 53942 | 2022-11-01 | Connecticut | 9 | 913565 | 11478 |
53886 | 53886 | 2022-10-31 | Connecticut | 9 | 913153 | 11463 |
53830 | 53830 | 2022-10-30 | Connecticut | 9 | 912997 | 11463 |
53774 | 53774 | 2022-10-29 | Connecticut | 9 | 912055 | 11463 |
53718 | 53718 | 2022-10-28 | Connecticut | 9 | 912055 | 11463 |
53662 | 53662 | 2022-10-27 | Connecticut | 9 | 910919 | 11462 |
53606 | 53606 | 2022-10-26 | Connecticut | 9 | 910367 | 11448 |
53550 | 53550 | 2022-10-25 | Connecticut | 9 | 909866 | 11448 |
53494 | 53494 | 2022-10-24 | Connecticut | 9 | 909382 | 11424 |
53438 | 53438 | 2022-10-23 | Connecticut | 9 | 908510 | 11424 |
53382 | 53382 | 2022-10-22 | Connecticut | 9 | 908510 | 11424 |
53326 | 53326 | 2022-10-21 | Connecticut | 9 | 908510 | 11424 |
53270 | 53270 | 2022-10-20 | Connecticut | 9 | 908015 | 11423 |
53214 | 53214 | 2022-10-19 | Connecticut | 9 | 907476 | 11423 |
53158 | 53158 | 2022-10-18 | Connecticut | 9 | 907038 | 11420 |
53102 | 53102 | 2022-10-17 | Connecticut | 9 | 906027 | 11410 |
53046 | 53046 | 2022-10-16 | Connecticut | 9 | 905747 | 11410 |
52990 | 52990 | 2022-10-15 | Connecticut | 9 | 904993 | 11403 |
52934 | 52934 | 2022-10-14 | Connecticut | 9 | 904993 | 11403 |
52878 | 52878 | 2022-10-13 | Connecticut | 9 | 904258 | 11402 |
52822 | 52822 | 2022-10-12 | Connecticut | 9 | 903688 | 11402 |
52766 | 52766 | 2022-10-11 | Connecticut | 9 | 902655 | 11385 |
52710 | 52710 | 2022-10-10 | Connecticut | 9 | 902374 | 11385 |
52654 | 52654 | 2022-10-09 | Connecticut | 9 | 901180 | 11385 |
52598 | 52598 | 2022-10-08 | Connecticut | 9 | 901180 | 11385 |
52542 | 52542 | 2022-10-07 | Connecticut | 9 | 901180 | 11385 |
52486 | 52486 | 2022-10-06 | Connecticut | 9 | 900500 | 11385 |
52430 | 52430 | 2022-10-05 | Connecticut | 9 | 899885 | 11385 |
52374 | 52374 | 2022-10-04 | Connecticut | 9 | 899205 | 11385 |
52318 | 52318 | 2022-10-03 | Connecticut | 9 | 898338 | 11365 |
52262 | 52262 | 2022-10-02 | Connecticut | 9 | 898073 | 11365 |
52206 | 52206 | 2022-10-01 | Connecticut | 9 | 896893 | 11365 |
52150 | 52150 | 2022-09-30 | Connecticut | 9 | 896893 | 11365 |
52094 | 52094 | 2022-09-29 | Connecticut | 9 | 896144 | 11365 |
52038 | 52038 | 2022-09-28 | Connecticut | 9 | 895390 | 11365 |
51982 | 51982 | 2022-09-27 | Connecticut | 9 | 894428 | 11361 |
51926 | 51926 | 2022-09-26 | Connecticut | 9 | 893529 | 11343 |
51870 | 51870 | 2022-09-25 | Connecticut | 9 | 893264 | 11343 |
51814 | 51814 | 2022-09-24 | Connecticut | 9 | 892220 | 11343 |
51758 | 51758 | 2022-09-23 | Connecticut | 9 | 892220 | 11343 |
51702 | 51702 | 2022-09-22 | Connecticut | 9 | 891232 | 11343 |
51646 | 51646 | 2022-09-21 | Connecticut | 9 | 890231 | 11343 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );