ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where county = "Litchfield" sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state ▲ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1407 | 1407 | 2020-03-12 | Litchfield | Connecticut | 9005 | 1 | 0 |
1673 | 1673 | 2020-03-13 | Litchfield | Connecticut | 9005 | 3 | 0 |
1994 | 1994 | 2020-03-14 | Litchfield | Connecticut | 9005 | 3 | 0 |
2376 | 2376 | 2020-03-15 | Litchfield | Connecticut | 9005 | 4 | 0 |
2811 | 2811 | 2020-03-16 | Litchfield | Connecticut | 9005 | 4 | 0 |
3293 | 3293 | 2020-03-17 | Litchfield | Connecticut | 9005 | 5 | 0 |
3848 | 3848 | 2020-03-18 | Litchfield | Connecticut | 9005 | 5 | 0 |
4511 | 4511 | 2020-03-19 | Litchfield | Connecticut | 9005 | 7 | 0 |
5289 | 5289 | 2020-03-20 | Litchfield | Connecticut | 9005 | 8 | 0 |
6216 | 6216 | 2020-03-21 | Litchfield | Connecticut | 9005 | 11 | 0 |
7252 | 7252 | 2020-03-22 | Litchfield | Connecticut | 9005 | 12 | 0 |
8398 | 8398 | 2020-03-23 | Litchfield | Connecticut | 9005 | 13 | 0 |
9643 | 9643 | 2020-03-24 | Litchfield | Connecticut | 9005 | 22 | 0 |
11017 | 11017 | 2020-03-25 | Litchfield | Connecticut | 9005 | 33 | 0 |
12565 | 12565 | 2020-03-26 | Litchfield | Connecticut | 9005 | 44 | 0 |
14234 | 14234 | 2020-03-27 | Litchfield | Connecticut | 9005 | 52 | 0 |
16018 | 16018 | 2020-03-28 | Litchfield | Connecticut | 9005 | 65 | 0 |
17910 | 17910 | 2020-03-29 | Litchfield | Connecticut | 9005 | 87 | 0 |
19889 | 19889 | 2020-03-30 | Litchfield | Connecticut | 9005 | 113 | 1 |
21966 | 21966 | 2020-03-31 | Litchfield | Connecticut | 9005 | 121 | 1 |
24125 | 24125 | 2020-04-01 | Litchfield | Connecticut | 9005 | 131 | 1 |
26355 | 26355 | 2020-04-02 | Litchfield | Connecticut | 9005 | 141 | 2 |
28657 | 28657 | 2020-04-03 | Litchfield | Connecticut | 9005 | 173 | 4 |
31015 | 31015 | 2020-04-04 | Litchfield | Connecticut | 9005 | 182 | 5 |
33421 | 33421 | 2020-04-05 | Litchfield | Connecticut | 9005 | 197 | 6 |
35866 | 35866 | 2020-04-06 | Litchfield | Connecticut | 9005 | 230 | 8 |
38356 | 38356 | 2020-04-07 | Litchfield | Connecticut | 9005 | 255 | 9 |
40899 | 40899 | 2020-04-08 | Litchfield | Connecticut | 9005 | 292 | 12 |
43473 | 43473 | 2020-04-09 | Litchfield | Connecticut | 9005 | 315 | 13 |
46073 | 46073 | 2020-04-10 | Litchfield | Connecticut | 9005 | 346 | 16 |
48703 | 48703 | 2020-04-11 | Litchfield | Connecticut | 9005 | 388 | 20 |
51365 | 51365 | 2020-04-12 | Litchfield | Connecticut | 9005 | 403 | 24 |
54044 | 54044 | 2020-04-13 | Litchfield | Connecticut | 9005 | 446 | 24 |
56736 | 56736 | 2020-04-14 | Litchfield | Connecticut | 9005 | 460 | 29 |
59444 | 59444 | 2020-04-15 | Litchfield | Connecticut | 9005 | 490 | 35 |
62163 | 62163 | 2020-04-16 | Litchfield | Connecticut | 9005 | 535 | 44 |
64896 | 64896 | 2020-04-17 | Litchfield | Connecticut | 9005 | 569 | 46 |
67644 | 67644 | 2020-04-18 | Litchfield | Connecticut | 9005 | 593 | 48 |
70406 | 70406 | 2020-04-19 | Litchfield | Connecticut | 9005 | 600 | 48 |
73175 | 73175 | 2020-04-20 | Litchfield | Connecticut | 9005 | 639 | 58 |
75951 | 75951 | 2020-04-21 | Litchfield | Connecticut | 9005 | 643 | 59 |
78735 | 78735 | 2020-04-22 | Litchfield | Connecticut | 9005 | 722 | 63 |
81529 | 81529 | 2020-04-23 | Litchfield | Connecticut | 9005 | 751 | 66 |
84329 | 84329 | 2020-04-24 | Litchfield | Connecticut | 9005 | 808 | 69 |
87137 | 87137 | 2020-04-25 | Litchfield | Connecticut | 9005 | 834 | 73 |
89954 | 89954 | 2020-04-26 | Litchfield | Connecticut | 9005 | 864 | 74 |
92772 | 92772 | 2020-04-27 | Litchfield | Connecticut | 9005 | 892 | 75 |
95604 | 95604 | 2020-04-28 | Litchfield | Connecticut | 9005 | 900 | 76 |
98449 | 98449 | 2020-04-29 | Litchfield | Connecticut | 9005 | 919 | 79 |
101299 | 101299 | 2020-04-30 | Litchfield | Connecticut | 9005 | 963 | 80 |
104154 | 104154 | 2020-05-01 | Litchfield | Connecticut | 9005 | 1014 | 86 |
107019 | 107019 | 2020-05-02 | Litchfield | Connecticut | 9005 | 1036 | 89 |
109888 | 109888 | 2020-05-03 | Litchfield | Connecticut | 9005 | 1036 | 89 |
112763 | 112763 | 2020-05-04 | Litchfield | Connecticut | 9005 | 1047 | 94 |
115646 | 115646 | 2020-05-05 | Litchfield | Connecticut | 9005 | 1065 | 95 |
118606 | 118606 | 2020-05-06 | Litchfield | Connecticut | 9005 | 1085 | 100 |
121575 | 121575 | 2020-05-07 | Litchfield | Connecticut | 9005 | 1114 | 104 |
124555 | 124555 | 2020-05-08 | Litchfield | Connecticut | 9005 | 1130 | 103 |
127541 | 127541 | 2020-05-09 | Litchfield | Connecticut | 9005 | 1142 | 105 |
130532 | 130532 | 2020-05-10 | Litchfield | Connecticut | 9005 | 1153 | 107 |
133523 | 133523 | 2020-05-11 | Litchfield | Connecticut | 9005 | 1161 | 109 |
136512 | 136512 | 2020-05-12 | Litchfield | Connecticut | 9005 | 1171 | 110 |
139503 | 139503 | 2020-05-13 | Litchfield | Connecticut | 9005 | 1179 | 110 |
142499 | 142499 | 2020-05-14 | Litchfield | Connecticut | 9005 | 1203 | 115 |
145499 | 145499 | 2020-05-15 | Litchfield | Connecticut | 9005 | 1218 | 115 |
148502 | 148502 | 2020-05-16 | Litchfield | Connecticut | 9005 | 1234 | 116 |
151511 | 151511 | 2020-05-17 | Litchfield | Connecticut | 9005 | 1269 | 116 |
154523 | 154523 | 2020-05-18 | Litchfield | Connecticut | 9005 | 1280 | 115 |
157539 | 157539 | 2020-05-19 | Litchfield | Connecticut | 9005 | 1290 | 117 |
160565 | 160565 | 2020-05-20 | Litchfield | Connecticut | 9005 | 1299 | 121 |
163593 | 163593 | 2020-05-21 | Litchfield | Connecticut | 9005 | 1303 | 121 |
166626 | 166626 | 2020-05-22 | Litchfield | Connecticut | 9005 | 1298 | 121 |
169663 | 169663 | 2020-05-23 | Litchfield | Connecticut | 9005 | 1304 | 122 |
172704 | 172704 | 2020-05-24 | Litchfield | Connecticut | 9005 | 1331 | 121 |
175747 | 175747 | 2020-05-25 | Litchfield | Connecticut | 9005 | 1346 | 126 |
178791 | 178791 | 2020-05-26 | Litchfield | Connecticut | 9005 | 1360 | 129 |
181835 | 181835 | 2020-05-27 | Litchfield | Connecticut | 9005 | 1360 | 130 |
184889 | 184889 | 2020-05-28 | Litchfield | Connecticut | 9005 | 1366 | 128 |
187945 | 187945 | 2020-05-29 | Litchfield | Connecticut | 9005 | 1375 | 130 |
191010 | 191010 | 2020-05-30 | Litchfield | Connecticut | 9005 | 1381 | 131 |
194077 | 194077 | 2020-05-31 | Litchfield | Connecticut | 9005 | 1397 | 133 |
197147 | 197147 | 2020-06-01 | Litchfield | Connecticut | 9005 | 1400 | 136 |
200220 | 200220 | 2020-06-02 | Litchfield | Connecticut | 9005 | 1402 | 133 |
203296 | 203296 | 2020-06-03 | Litchfield | Connecticut | 9005 | 1404 | 133 |
206376 | 206376 | 2020-06-04 | Litchfield | Connecticut | 9005 | 1406 | 134 |
209457 | 209457 | 2020-06-05 | Litchfield | Connecticut | 9005 | 1409 | 134 |
212542 | 212542 | 2020-06-06 | Litchfield | Connecticut | 9005 | 1413 | 134 |
215629 | 215629 | 2020-06-07 | Litchfield | Connecticut | 9005 | 1419 | 134 |
218720 | 218720 | 2020-06-08 | Litchfield | Connecticut | 9005 | 1426 | 134 |
221815 | 221815 | 2020-06-09 | Litchfield | Connecticut | 9005 | 1432 | 136 |
224910 | 224910 | 2020-06-10 | Litchfield | Connecticut | 9005 | 1430 | 134 |
228012 | 228012 | 2020-06-11 | Litchfield | Connecticut | 9005 | 1435 | 135 |
231115 | 231115 | 2020-06-12 | Litchfield | Connecticut | 9005 | 1435 | 135 |
234221 | 234221 | 2020-06-13 | Litchfield | Connecticut | 9005 | 1439 | 135 |
237328 | 237328 | 2020-06-14 | Litchfield | Connecticut | 9005 | 1442 | 136 |
240436 | 240436 | 2020-06-15 | Litchfield | Connecticut | 9005 | 1441 | 135 |
243547 | 243547 | 2020-06-16 | Litchfield | Connecticut | 9005 | 1443 | 135 |
246660 | 246660 | 2020-06-17 | Litchfield | Connecticut | 9005 | 1444 | 135 |
249772 | 249772 | 2020-06-18 | Litchfield | Connecticut | 9005 | 1447 | 135 |
252887 | 252887 | 2020-06-19 | Litchfield | Connecticut | 9005 | 1448 | 135 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_counties] ( [date] TEXT, [county] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER ); CREATE INDEX [idx_ny_times_us_counties_state] ON [ny_times_us_counties] ([state]); CREATE INDEX [idx_ny_times_us_counties_county] ON [ny_times_us_counties] ([county]); CREATE INDEX [idx_ny_times_us_counties_fips] ON [ny_times_us_counties] ([fips]); CREATE INDEX [idx_ny_times_us_counties_date] ON [ny_times_us_counties] ([date] desc);