ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 9003 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1993 | 1993 | 2020-03-14 | Hartford | Connecticut | 9003 | 1 | 0 |
2375 | 2375 | 2020-03-15 | Hartford | Connecticut | 9003 | 3 | 0 |
2810 | 2810 | 2020-03-16 | Hartford | Connecticut | 9003 | 4 | 0 |
3292 | 3292 | 2020-03-17 | Hartford | Connecticut | 9003 | 7 | 0 |
3847 | 3847 | 2020-03-18 | Hartford | Connecticut | 9003 | 11 | 0 |
4510 | 4510 | 2020-03-19 | Hartford | Connecticut | 9003 | 18 | 0 |
5288 | 5288 | 2020-03-20 | Hartford | Connecticut | 9003 | 29 | 0 |
6215 | 6215 | 2020-03-21 | Hartford | Connecticut | 9003 | 35 | 0 |
7251 | 7251 | 2020-03-22 | Hartford | Connecticut | 9003 | 54 | 1 |
8397 | 8397 | 2020-03-23 | Hartford | Connecticut | 9003 | 61 | 2 |
9642 | 9642 | 2020-03-24 | Hartford | Connecticut | 9003 | 88 | 2 |
11016 | 11016 | 2020-03-25 | Hartford | Connecticut | 9003 | 116 | 2 |
12564 | 12564 | 2020-03-26 | Hartford | Connecticut | 9003 | 138 | 2 |
14233 | 14233 | 2020-03-27 | Hartford | Connecticut | 9003 | 189 | 2 |
16017 | 16017 | 2020-03-28 | Hartford | Connecticut | 9003 | 228 | 2 |
17909 | 17909 | 2020-03-29 | Hartford | Connecticut | 9003 | 276 | 2 |
19888 | 19888 | 2020-03-30 | Hartford | Connecticut | 9003 | 330 | 3 |
21965 | 21965 | 2020-03-31 | Hartford | Connecticut | 9003 | 393 | 7 |
24124 | 24124 | 2020-04-01 | Hartford | Connecticut | 9003 | 469 | 11 |
26354 | 26354 | 2020-04-02 | Hartford | Connecticut | 9003 | 539 | 13 |
28656 | 28656 | 2020-04-03 | Hartford | Connecticut | 9003 | 679 | 18 |
31014 | 31014 | 2020-04-04 | Hartford | Connecticut | 9003 | 726 | 26 |
33420 | 33420 | 2020-04-05 | Hartford | Connecticut | 9003 | 751 | 29 |
35865 | 35865 | 2020-04-06 | Hartford | Connecticut | 9003 | 882 | 31 |
38355 | 38355 | 2020-04-07 | Hartford | Connecticut | 9003 | 1045 | 48 |
40898 | 40898 | 2020-04-08 | Hartford | Connecticut | 9003 | 1290 | 68 |
43472 | 43472 | 2020-04-09 | Hartford | Connecticut | 9003 | 1471 | 75 |
46072 | 46072 | 2020-04-10 | Hartford | Connecticut | 9003 | 1615 | 88 |
48702 | 48702 | 2020-04-11 | Hartford | Connecticut | 9003 | 1832 | 101 |
51364 | 51364 | 2020-04-12 | Hartford | Connecticut | 9003 | 1914 | 116 |
54043 | 54043 | 2020-04-13 | Hartford | Connecticut | 9003 | 2243 | 133 |
56735 | 56735 | 2020-04-14 | Hartford | Connecticut | 9003 | 2370 | 153 |
59443 | 59443 | 2020-04-15 | Hartford | Connecticut | 9003 | 2570 | 213 |
62162 | 62162 | 2020-04-16 | Hartford | Connecticut | 9003 | 2859 | 243 |
64895 | 64895 | 2020-04-17 | Hartford | Connecticut | 9003 | 3015 | 266 |
67643 | 67643 | 2020-04-18 | Hartford | Connecticut | 9003 | 3196 | 289 |
70405 | 70405 | 2020-04-19 | Hartford | Connecticut | 9003 | 3351 | 295 |
73174 | 73174 | 2020-04-20 | Hartford | Connecticut | 9003 | 3823 | 369 |
75950 | 75950 | 2020-04-21 | Hartford | Connecticut | 9003 | 3951 | 402 |
78734 | 78734 | 2020-04-22 | Hartford | Connecticut | 9003 | 4128 | 442 |
81528 | 81528 | 2020-04-23 | Hartford | Connecticut | 9003 | 4303 | 469 |
84328 | 84328 | 2020-04-24 | Hartford | Connecticut | 9003 | 4570 | 511 |
87136 | 87136 | 2020-04-25 | Hartford | Connecticut | 9003 | 4761 | 553 |
89953 | 89953 | 2020-04-26 | Hartford | Connecticut | 9003 | 4989 | 579 |
92771 | 92771 | 2020-04-27 | Hartford | Connecticut | 9003 | 5157 | 612 |
95603 | 95603 | 2020-04-28 | Hartford | Connecticut | 9003 | 5224 | 643 |
98448 | 98448 | 2020-04-29 | Hartford | Connecticut | 9003 | 5388 | 670 |
101298 | 101298 | 2020-04-30 | Hartford | Connecticut | 9003 | 5601 | 698 |
104153 | 104153 | 2020-05-01 | Hartford | Connecticut | 9003 | 5931 | 715 |
107018 | 107018 | 2020-05-02 | Hartford | Connecticut | 9003 | 6112 | 741 |
109887 | 109887 | 2020-05-03 | Hartford | Connecticut | 9003 | 6112 | 741 |
112762 | 112762 | 2020-05-04 | Hartford | Connecticut | 9003 | 6173 | 773 |
115645 | 115645 | 2020-05-05 | Hartford | Connecticut | 9003 | 6351 | 804 |
118605 | 118605 | 2020-05-06 | Hartford | Connecticut | 9003 | 6530 | 842 |
121574 | 121574 | 2020-05-07 | Hartford | Connecticut | 9003 | 6750 | 867 |
124554 | 124554 | 2020-05-08 | Hartford | Connecticut | 9003 | 6904 | 884 |
127540 | 127540 | 2020-05-09 | Hartford | Connecticut | 9003 | 7105 | 901 |
130531 | 130531 | 2020-05-10 | Hartford | Connecticut | 9003 | 7263 | 909 |
133522 | 133522 | 2020-05-11 | Hartford | Connecticut | 9003 | 7358 | 921 |
136511 | 136511 | 2020-05-12 | Hartford | Connecticut | 9003 | 7528 | 931 |
139502 | 139502 | 2020-05-13 | Hartford | Connecticut | 9003 | 7732 | 963 |
142498 | 142498 | 2020-05-14 | Hartford | Connecticut | 9003 | 7935 | 999 |
145498 | 145498 | 2020-05-15 | Hartford | Connecticut | 9003 | 8126 | 1025 |
148501 | 148501 | 2020-05-16 | Hartford | Connecticut | 9003 | 8299 | 1044 |
151510 | 151510 | 2020-05-17 | Hartford | Connecticut | 9003 | 8723 | 1069 |
154522 | 154522 | 2020-05-18 | Hartford | Connecticut | 9003 | 8957 | 1084 |
157538 | 157538 | 2020-05-19 | Hartford | Connecticut | 9003 | 9050 | 1090 |
160564 | 160564 | 2020-05-20 | Hartford | Connecticut | 9003 | 9234 | 1116 |
163592 | 163592 | 2020-05-21 | Hartford | Connecticut | 9003 | 9299 | 1133 |
166625 | 166625 | 2020-05-22 | Hartford | Connecticut | 9003 | 9463 | 1155 |
169662 | 169662 | 2020-05-23 | Hartford | Connecticut | 9003 | 9545 | 1169 |
172703 | 172703 | 2020-05-24 | Hartford | Connecticut | 9003 | 9686 | 1175 |
175746 | 175746 | 2020-05-25 | Hartford | Connecticut | 9003 | 9841 | 1187 |
178790 | 178790 | 2020-05-26 | Hartford | Connecticut | 9003 | 9917 | 1193 |
181834 | 181834 | 2020-05-27 | Hartford | Connecticut | 9003 | 9962 | 1203 |
184888 | 184888 | 2020-05-28 | Hartford | Connecticut | 9003 | 10078 | 1208 |
187944 | 187944 | 2020-05-29 | Hartford | Connecticut | 9003 | 10146 | 1222 |
191009 | 191009 | 2020-05-30 | Hartford | Connecticut | 9003 | 10207 | 1238 |
194076 | 194076 | 2020-05-31 | Hartford | Connecticut | 9003 | 10296 | 1250 |
197146 | 197146 | 2020-06-01 | Hartford | Connecticut | 9003 | 10445 | 1254 |
200219 | 200219 | 2020-06-02 | Hartford | Connecticut | 9003 | 10536 | 1253 |
203295 | 203295 | 2020-06-03 | Hartford | Connecticut | 9003 | 10593 | 1259 |
206375 | 206375 | 2020-06-04 | Hartford | Connecticut | 9003 | 10636 | 1266 |
209456 | 209456 | 2020-06-05 | Hartford | Connecticut | 9003 | 10677 | 1277 |
212541 | 212541 | 2020-06-06 | Hartford | Connecticut | 9003 | 10747 | 1279 |
215628 | 215628 | 2020-06-07 | Hartford | Connecticut | 9003 | 10809 | 1287 |
218719 | 218719 | 2020-06-08 | Hartford | Connecticut | 9003 | 10844 | 1291 |
221814 | 221814 | 2020-06-09 | Hartford | Connecticut | 9003 | 10859 | 1291 |
224909 | 224909 | 2020-06-10 | Hartford | Connecticut | 9003 | 10924 | 1303 |
228011 | 228011 | 2020-06-11 | Hartford | Connecticut | 9003 | 10967 | 1308 |
231114 | 231114 | 2020-06-12 | Hartford | Connecticut | 9003 | 11103 | 1313 |
234220 | 234220 | 2020-06-13 | Hartford | Connecticut | 9003 | 11189 | 1321 |
237327 | 237327 | 2020-06-14 | Hartford | Connecticut | 9003 | 11218 | 1327 |
240435 | 240435 | 2020-06-15 | Hartford | Connecticut | 9003 | 11231 | 1328 |
243546 | 243546 | 2020-06-16 | Hartford | Connecticut | 9003 | 11261 | 1330 |
246659 | 246659 | 2020-06-17 | Hartford | Connecticut | 9003 | 11284 | 1331 |
249771 | 249771 | 2020-06-18 | Hartford | Connecticut | 9003 | 11322 | 1336 |
252886 | 252886 | 2020-06-19 | Hartford | Connecticut | 9003 | 11358 | 1341 |
256005 | 256005 | 2020-06-20 | Hartford | Connecticut | 9003 | 11392 | 1344 |
259132 | 259132 | 2020-06-21 | Hartford | Connecticut | 9003 | 11405 | 1350 |
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);