johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
9,121 rows where province_or_state = "Connecticut" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: fips, latitude, longitude, day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips ▼ | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
339715 | 339715 | 2020-03-21 | US | Connecticut | 194 | 4 | 0 | 41.5978 | -72.7554 | 2020-03-21T02:43:03 | ||||
1176996 | 1176996 | 2020-03-18 | US | Connecticut | 68 | 0 | 0 | 41.5978 | -72.7554 | 2020-03-17T23:13:10 | ||||
1463589 | 1463589 | 2020-03-15 | US | Connecticut | 24 | 0 | 0 | 41.5978 | -72.7554 | 2020-03-15T18:20:19 | ||||
1526953 | 1526953 | 2020-03-19 | US | Connecticut | 159 | 2 | 0 | 41.5978 | -72.7554 | 2020-03-19T23:43:04 | ||||
1872025 | 1872025 | 2020-03-30 | US | Connecticut | Unassigned | 176 | 0 | 0 | 176 | 0.0 | 0.0 | 3/30/20 22:52 | Unassigned, Connecticut, US | |
2111211 | 2111211 | 2020-03-14 | US | Connecticut | 22 | 0 | 0 | 41.5978 | -72.7554 | 2020-03-14T22:33:03 | ||||
2127592 | 2127592 | 2020-03-11 | US | Connecticut | 3 | 0 | 0 | 41.5978 | -72.7554 | 2020-03-11T23:13:06 | ||||
2255244 | 2255244 | 2020-03-16 | US | Connecticut | 30 | 0 | 0 | 41.5978 | -72.7554 | 2020-03-16T20:13:20 | ||||
2283014 | 2283014 | 2020-03-12 | US | Connecticut | 5 | 0 | 0 | 41.5978 | -72.7554 | 2020-03-12T23:44:33 | ||||
3364456 | 3364456 | 2020-04-01 | US | Connecticut | Unassigned | 185 | 2 | 0 | 183 | 0.0 | 0.0 | 2020-04-01 21:58:49 | Unassigned, Connecticut, US | |
3734003 | 3734003 | 2020-03-20 | US | Connecticut | 194 | 3 | 0 | 41.5978 | -72.7554 | 2020-03-20T21:13:29 | ||||
3752975 | 3752975 | 2020-03-10 | US | Connecticut | 2 | 0 | 0 | 41.5978 | -72.7554 | 2020-03-10T03:13:17 | ||||
3765460 | 3765460 | 2020-03-13 | US | Connecticut | 11 | 0 | 0 | 41.597782 | -72.755371 | 2020-03-11T20:00:00 | ||||
3815552 | 3815552 | 2020-03-31 | US | Connecticut | Unassigned | 77 | 2 | 0 | 75 | 0.0 | 0.0 | 2020-03-31 23:43:56 | Unassigned, Connecticut, US | |
3891410 | 3891410 | 2020-03-17 | US | Connecticut | 68 | 0 | 0 | 41.5978 | -72.7554 | 2020-03-17T23:13:10 | ||||
1001 | 1001 | 2021-12-02 | US | Connecticut | Unassigned | 90009 | 1453 | 3 | 0 | 41.85853803 | 0.0 | 2021-12-03 04:23:05 | Unassigned, Connecticut, US | |
5016 | 5016 | 2021-10-28 | US | Connecticut | Unassigned | 90009 | 1355 | 5 | 0 | 41.85853803 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Connecticut, US | |
8989 | 8989 | 2020-10-25 | US | Connecticut | Unassigned | 90009 | 137 | 0 | 0 | 137 | 41.85853803 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Connecticut, US |
13001 | 13001 | 2021-01-26 | US | Connecticut | Unassigned | 90009 | 815 | 6 | 0 | 809 | 41.85853803 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Connecticut, US |
17023 | 17023 | 2021-09-18 | US | Connecticut | Unassigned | 90009 | 1308 | 3 | 0 | 41.85853803 | 0.0 | 2021-09-19 04:21:34 | Unassigned, Connecticut, US | |
21034 | 21034 | 2021-05-28 | US | Connecticut | Unassigned | 90009 | 1185 | 1 | 0 | 41.85853803 | 0.0 | 2021-05-29 04:20:41 | Unassigned, Connecticut, US | |
25072 | 25072 | 2022-03-20 | US | Connecticut | Unassigned | 90009 | 2844 | 9 | 0 | 41.85853803 | 0.0 | 2022-03-21 04:20:50 | Unassigned, Connecticut, US | |
29087 | 29087 | 2021-11-11 | US | Connecticut | Unassigned | 90009 | 1371 | 5 | 0 | 41.85853803 | 0.0 | 2021-11-12 04:22:01 | Unassigned, Connecticut, US | |
33083 | 33083 | 2021-08-25 | US | Connecticut | Unassigned | 90009 | 1257 | 1 | 0 | 41.85853803 | 0.0 | 2021-08-26 04:21:28 | Unassigned, Connecticut, US | |
37093 | 37093 | 2021-04-12 | US | Connecticut | Unassigned | 90009 | 1135 | 12 | 0 | 41.85853803 | 0.0 | 2021-04-13 04:20:37 | Unassigned, Connecticut, US | |
42779 | 42779 | 2020-04-13 | US | Connecticut | Unassigned | 90009 | 491 | 4 | 0 | 487 | 41.85853803 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Connecticut, US |
44379 | 44379 | 2021-11-02 | US | Connecticut | Unassigned | 90009 | 1361 | 5 | 0 | 41.85853803 | 0.0 | 2021-11-03 06:22:09 | Unassigned, Connecticut, US | |
49872 | 49872 | 2020-04-17 | US | Connecticut | Unassigned | 90009 | 495 | 2 | 0 | 493 | 41.85853803 | 0.0 | 2020-04-17 23:30:52 | Unassigned, Connecticut, US |
51455 | 51455 | 2021-05-29 | US | Connecticut | Unassigned | 90009 | 1185 | 1 | 0 | 41.85853803 | 0.0 | 2021-05-30 04:20:55 | Unassigned, Connecticut, US | |
55466 | 55466 | 2021-03-07 | US | Connecticut | Unassigned | 90009 | 982 | 10 | 0 | 41.85853803 | 0.0 | 2021-03-08 05:24:48 | Unassigned, Connecticut, US | |
61401 | 61401 | 2020-07-23 | US | Connecticut | Unassigned | 90009 | 234 | 0 | 0 | 234 | 41.85853803 | 0.0 | 2020-07-24 05:30:40 | Unassigned, Connecticut, US |
63737 | 63737 | 2022-11-12 | US | Connecticut | Unassigned | 90009 | 3002 | 8 | 0 | 41.85853803 | 0.0 | 2022-11-13 04:21:14 | Unassigned, Connecticut, US | |
67728 | 67728 | 2021-09-01 | US | Connecticut | Unassigned | 90009 | 1255 | 1 | 0 | 41.85853803 | 0.0 | 2021-09-02 04:21:15 | Unassigned, Connecticut, US | |
71762 | 71762 | 2022-02-07 | US | Connecticut | Unassigned | 90009 | 2713 | 0 | 0 | 41.85853803 | 0.0 | 2022-02-08 04:21:15 | Unassigned, Connecticut, US | |
75749 | 75749 | 2020-12-03 | US | Connecticut | Unassigned | 90009 | 801 | 1 | 0 | 800 | 41.85853803 | 0.0 | 2020-12-04 05:27:27 | Unassigned, Connecticut, US |
79743 | 79743 | 2020-10-14 | US | Connecticut | Unassigned | 90009 | 148 | 0 | 0 | 148 | 41.85853803 | 0.0 | 2020-10-15 04:24:28 | Unassigned, Connecticut, US |
83758 | 83758 | 2021-05-25 | US | Connecticut | Unassigned | 90009 | 1185 | 1 | 0 | 41.85853803 | 0.0 | 2021-05-26 04:20:35 | Unassigned, Connecticut, US | |
87796 | 87796 | 2021-11-09 | US | Connecticut | Unassigned | 90009 | 1369 | 5 | 0 | 41.85853803 | 0.0 | 2021-11-10 04:21:38 | Unassigned, Connecticut, US | |
91814 | 91814 | 2022-07-23 | US | Connecticut | Unassigned | 90009 | 2695 | 1 | 0 | 41.85853803 | 0.0 | 2022-07-24 04:20:47 | Unassigned, Connecticut, US | |
97731 | 97731 | 2020-08-04 | US | Connecticut | Unassigned | 90009 | 242 | 0 | 0 | 242 | 41.85853803 | 0.0 | 2020-08-05 04:34:43 | Unassigned, Connecticut, US |
99997 | 99997 | 2022-01-14 | US | Connecticut | Unassigned | 90009 | 2430 | 5 | 0 | 41.85853803 | 0.0 | 2022-01-15 04:21:07 | Unassigned, Connecticut, US | |
103993 | 103993 | 2021-08-15 | US | Connecticut | Unassigned | 90009 | 1216 | 1 | 0 | 41.85853803 | 0.0 | 2021-08-16 04:21:31 | Unassigned, Connecticut, US | |
108117 | 108117 | 2021-06-19 | US | Connecticut | Unassigned | 90009 | 1179 | 1 | 0 | 41.85853803 | 0.0 | 2021-06-20 04:21:48 | Unassigned, Connecticut, US | |
113790 | 113790 | 2020-05-08 | US | Connecticut | Unassigned | 90009 | 302 | 3 | 0 | 299 | 41.85853803 | 0.0 | 2020-05-09 02:32:35 | Unassigned, Connecticut, US |
115424 | 115424 | 2022-09-06 | US | Connecticut | Unassigned | 90009 | 2821 | 2 | 0 | 41.85853803 | 0.0 | 2022-09-07 04:20:59 | Unassigned, Connecticut, US | |
121325 | 121325 | 2020-07-19 | US | Connecticut | Unassigned | 90009 | 228 | 0 | 0 | 228 | 41.85853803 | 0.0 | 2020-07-20 05:34:40 | Unassigned, Connecticut, US |
123364 | 123364 | 2020-11-18 | US | Connecticut | Unassigned | 90009 | 408 | 0 | 0 | 408 | 41.85853803 | 0.0 | 2020-11-19 05:25:23 | Unassigned, Connecticut, US |
127404 | 127404 | 2022-01-09 | US | Connecticut | Unassigned | 90009 | 2145 | 2 | 0 | 41.85853803 | 0.0 | 2022-01-10 04:22:07 | Unassigned, Connecticut, US | |
131425 | 131425 | 2022-10-04 | US | Connecticut | Unassigned | 90009 | 2920 | 8 | 0 | 41.85853803 | 0.0 | 2022-10-05 04:23:06 | Unassigned, Connecticut, US | |
137018 | 137018 | 2020-04-29 | US | Connecticut | Unassigned | 90009 | 507 | 3 | 0 | 504 | 41.85853803 | 0.0 | 2020-04-30 02:32:27 | Unassigned, Connecticut, US |
138642 | 138642 | 2021-12-04 | US | Connecticut | Unassigned | 90009 | 1455 | 3 | 0 | 41.85853803 | 0.0 | 2021-12-05 04:22:25 | Unassigned, Connecticut, US | |
142660 | 142660 | 2022-07-09 | US | Connecticut | Unassigned | 90009 | 2667 | 3 | 0 | 41.85853803 | 0.0 | 2022-07-10 04:20:54 | Unassigned, Connecticut, US | |
146625 | 146625 | 2020-08-15 | US | Connecticut | Unassigned | 90009 | 216 | 0 | 0 | 216 | 41.85853803 | 0.0 | 2020-08-16 04:27:42 | Unassigned, Connecticut, US |
150655 | 150655 | 2021-11-29 | US | Connecticut | Unassigned | 90009 | 1425 | 3 | 0 | 41.85853803 | 0.0 | 2021-11-30 04:22:53 | Unassigned, Connecticut, US | |
154643 | 154643 | 2021-01-08 | US | Connecticut | Unassigned | 90009 | 770 | 1 | 0 | 769 | 41.85853803 | 0.0 | 2021-01-09 05:22:18 | Unassigned, Connecticut, US |
158684 | 158684 | 2022-03-29 | US | Connecticut | Unassigned | 90009 | 2865 | 10 | 0 | 41.85853803 | 0.0 | 2022-03-30 04:20:45 | Unassigned, Connecticut, US | |
162699 | 162699 | 2021-11-19 | US | Connecticut | Unassigned | 90009 | 1391 | 3 | 0 | 41.85853803 | 0.0 | 2021-11-20 04:22:17 | Unassigned, Connecticut, US | |
166717 | 166717 | 2022-06-21 | US | Connecticut | Unassigned | 90009 | 2617 | 2 | 0 | 41.85853803 | 0.0 | 2022-06-22 04:20:54 | Unassigned, Connecticut, US | |
170707 | 170707 | 2021-04-16 | US | Connecticut | Unassigned | 90009 | 1106 | 12 | 0 | 41.85853803 | 0.0 | 2021-04-17 04:20:40 | Unassigned, Connecticut, US | |
176641 | 176641 | 2020-07-27 | US | Connecticut | Unassigned | 90009 | 242 | 0 | 0 | 242 | 41.85853803 | 0.0 | 2020-07-28 04:58:43 | Unassigned, Connecticut, US |
178693 | 178693 | 2021-09-02 | US | Connecticut | Unassigned | 90009 | 1261 | 1 | 0 | 41.85853803 | 0.0 | 2021-09-03 04:21:20 | Unassigned, Connecticut, US | |
182701 | 182701 | 2021-02-21 | US | Connecticut | Unassigned | 90009 | 937 | 9 | 0 | 928 | 41.85853803 | 0.0 | 2021-02-22 05:24:21 | Unassigned, Connecticut, US |
186742 | 186742 | 2022-02-13 | US | Connecticut | Unassigned | 90009 | 2739 | 0 | 0 | 41.85853803 | 0.0 | 2022-02-14 04:20:51 | Unassigned, Connecticut, US | |
190729 | 190729 | 2021-01-11 | US | Connecticut | Unassigned | 90009 | 779 | 1 | 0 | 778 | 41.85853803 | 0.0 | 2021-01-12 05:22:15 | Unassigned, Connecticut, US |
194721 | 194721 | 2020-08-31 | US | Connecticut | Unassigned | 90009 | 110 | 0 | 0 | 110 | 41.85853803 | 0.0 | 2020-09-01 04:28:31 | Unassigned, Connecticut, US |
198934 | 198934 | 2022-10-19 | US | Connecticut | Unassigned | 90009 | 2955 | 8 | 0 | 41.85853803 | 0.0 | 2022-10-20 04:22:59 | Unassigned, Connecticut, US | |
202916 | 202916 | 2020-12-25 | US | Connecticut | Unassigned | 90009 | 644 | 0 | 0 | 644 | 41.85853803 | 0.0 | 2020-12-26 05:22:28 | Unassigned, Connecticut, US |
206907 | 206907 | 2020-08-19 | US | Connecticut | Unassigned | 90009 | 213 | 0 | 0 | 213 | 41.85853803 | 0.0 | 2020-08-20 04:27:43 | Unassigned, Connecticut, US |
210898 | 210898 | 2020-10-29 | US | Connecticut | Unassigned | 90009 | 155 | 0 | 0 | 155 | 41.85853803 | 0.0 | 2020-10-30 04:24:49 | Unassigned, Connecticut, US |
216653 | 216653 | 2020-06-08 | US | Connecticut | Unassigned | 90009 | 272 | 0 | 0 | 272 | 41.85853803 | 0.0 | 2020-06-09 03:33:03 | Unassigned, Connecticut, US |
218655 | 218655 | 2022-12-26 | US | Connecticut | Unassigned | 90009 | 3075 | 8 | 0 | 41.85853803 | 0.0 | 2022-12-27 04:21:07 | Unassigned, Connecticut, US | |
222667 | 222667 | 2022-05-09 | US | Connecticut | Unassigned | 90009 | 2338 | 1 | 0 | 41.85853803 | 0.0 | 2022-05-10 04:20:50 | Unassigned, Connecticut, US | |
228270 | 228270 | 2020-04-30 | US | Connecticut | Unassigned | 90009 | 462 | 4 | 0 | 458 | 41.85853803 | 0.0 | 2020-05-01 02:32:28 | Unassigned, Connecticut, US |
229899 | 229899 | 2022-05-31 | US | Connecticut | Unassigned | 90009 | 2553 | 1 | 0 | 41.85853803 | 0.0 | 2022-06-01 04:20:55 | Unassigned, Connecticut, US | |
233914 | 233914 | 2022-02-11 | US | Connecticut | Unassigned | 90009 | 2739 | 0 | 0 | 41.85853803 | 0.0 | 2022-02-12 04:21:06 | Unassigned, Connecticut, US | |
237901 | 237901 | 2021-01-18 | US | Connecticut | Unassigned | 90009 | 832 | 6 | 0 | 826 | 41.85853803 | 0.0 | 2021-01-19 05:22:15 | Unassigned, Connecticut, US |
241918 | 241918 | 2021-04-02 | US | Connecticut | Unassigned | 90009 | 1103 | 11 | 0 | 41.85853803 | 0.0 | 2021-04-03 04:20:44 | Unassigned, Connecticut, US | |
245936 | 245936 | 2021-08-17 | US | Connecticut | Unassigned | 90009 | 1223 | 1 | 0 | 41.85853803 | 0.0 | 2021-08-18 04:21:35 | Unassigned, Connecticut, US | |
249950 | 249950 | 2021-09-04 | US | Connecticut | Unassigned | 90009 | 1259 | 1 | 0 | 41.85853803 | 0.0 | 2021-09-05 04:21:33 | Unassigned, Connecticut, US | |
253986 | 253986 | 2022-09-08 | US | Connecticut | Unassigned | 90009 | 2821 | 2 | 0 | 41.85853803 | 0.0 | 2022-09-09 04:21:11 | Unassigned, Connecticut, US | |
258005 | 258005 | 2022-12-10 | US | Connecticut | Unassigned | 90009 | 3047 | 8 | 0 | 41.85853803 | 0.0 | 2022-12-11 04:20:50 | Unassigned, Connecticut, US | |
262204 | 262204 | 2022-03-15 | US | Connecticut | Unassigned | 90009 | 2838 | 8 | 0 | 41.85853803 | 0.0 | 2022-03-16 04:20:50 | Unassigned, Connecticut, US | |
267893 | 267893 | 2020-05-21 | US | Connecticut | Unassigned | 90009 | 194 | 2 | 0 | 192 | 41.85853803 | 0.0 | 2020-05-22 02:36:51 | Unassigned, Connecticut, US |
271232 | 271232 | 2020-04-28 | US | Connecticut | Unassigned | 90009 | 491 | 1 | 0 | 490 | 41.85853803 | 0.0 | 2020-04-29 02:32:29 | Unassigned, Connecticut, US |
272814 | 272814 | 2020-11-10 | US | Connecticut | Unassigned | 90009 | 257 | 0 | 0 | 257 | 41.85853803 | 0.0 | 2020-11-11 05:25:30 | Unassigned, Connecticut, US |
276854 | 276854 | 2021-11-03 | US | Connecticut | Unassigned | 90009 | 1363 | 5 | 0 | 41.85853803 | 0.0 | 2021-11-04 04:22:20 | Unassigned, Connecticut, US | |
280844 | 280844 | 2021-02-24 | US | Connecticut | Unassigned | 90009 | 961 | 9 | 0 | 952 | 41.85853803 | 0.0 | 2021-02-25 05:24:57 | Unassigned, Connecticut, US |
286627 | 286627 | 2020-06-15 | US | Connecticut | Unassigned | 90009 | 342 | 0 | 0 | 342 | 41.85853803 | 0.0 | 2020-06-16 04:33:09 | Unassigned, Connecticut, US |
288666 | 288666 | 2021-10-31 | US | Connecticut | Unassigned | 90009 | 1356 | 5 | 0 | 41.85853803 | 0.0 | 2021-11-01 04:22:01 | Unassigned, Connecticut, US | |
292688 | 292688 | 2022-11-15 | US | Connecticut | Unassigned | 90009 | 3002 | 8 | 0 | 41.85853803 | 0.0 | 2022-11-16 04:21:09 | Unassigned, Connecticut, US | |
296679 | 296679 | 2021-07-15 | US | Connecticut | Unassigned | 90009 | 1176 | 1 | 0 | 41.85853803 | 0.0 | 2021-07-16 04:21:22 | Unassigned, Connecticut, US | |
302494 | 302494 | 2020-07-01 | US | Connecticut | Unassigned | 90009 | 209 | 0 | 0 | 209 | 41.85853803 | 0.0 | 2020-07-02 04:33:46 | Unassigned, Connecticut, US |
304540 | 304540 | 2022-04-16 | US | Connecticut | Unassigned | 90009 | 2210 | 1 | 0 | 41.85853803 | 0.0 | 2022-04-17 04:20:59 | Unassigned, Connecticut, US | |
308560 | 308560 | 2022-12-13 | US | Connecticut | Unassigned | 90009 | 3059 | 8 | 0 | 41.85853803 | 0.0 | 2022-12-14 04:21:04 | Unassigned, Connecticut, US | |
312576 | 312576 | 2022-11-13 | US | Connecticut | Unassigned | 90009 | 2998 | 8 | 0 | 41.85853803 | 0.0 | 2022-11-14 04:21:09 | Unassigned, Connecticut, US | |
316588 | 316588 | 2022-02-12 | US | Connecticut | Unassigned | 90009 | 2739 | 0 | 0 | 41.85853803 | 0.0 | 2022-02-13 04:21:00 | Unassigned, Connecticut, US | |
320608 | 320608 | 2022-10-30 | US | Connecticut | Unassigned | 90009 | 2971 | 8 | 0 | 41.85853803 | 0.0 | 2022-10-31 04:21:36 | Unassigned, Connecticut, US | |
326430 | 326430 | 2020-07-20 | US | Connecticut | Unassigned | 90009 | 234 | 0 | 0 | 234 | 41.85853803 | 0.0 | 2020-07-21 04:38:46 | Unassigned, Connecticut, US |
328582 | 328582 | 2022-12-27 | US | Connecticut | Unassigned | 90009 | 3073 | 8 | 0 | 41.85853803 | 0.0 | 2022-12-28 04:21:04 | Unassigned, Connecticut, US | |
332573 | 332573 | 2021-08-04 | US | Connecticut | Unassigned | 90009 | 1204 | 1 | 0 | 41.85853803 | 0.0 | 2021-08-05 04:21:51 | Unassigned, Connecticut, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);