ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 9009 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1995 | 1995 | 2020-03-14 | New Haven | Connecticut | 9009 | 1 | 0 |
2377 | 2377 | 2020-03-15 | New Haven | Connecticut | 9009 | 3 | 0 |
2812 | 2812 | 2020-03-16 | New Haven | Connecticut | 9009 | 4 | 0 |
3294 | 3294 | 2020-03-17 | New Haven | Connecticut | 9009 | 8 | 0 |
3850 | 3850 | 2020-03-18 | New Haven | Connecticut | 9009 | 10 | 0 |
4513 | 4513 | 2020-03-19 | New Haven | Connecticut | 9009 | 24 | 0 |
5291 | 5291 | 2020-03-20 | New Haven | Connecticut | 9009 | 24 | 0 |
6218 | 6218 | 2020-03-21 | New Haven | Connecticut | 9009 | 24 | 0 |
7254 | 7254 | 2020-03-22 | New Haven | Connecticut | 9009 | 29 | 0 |
8400 | 8400 | 2020-03-23 | New Haven | Connecticut | 9009 | 41 | 0 |
9645 | 9645 | 2020-03-24 | New Haven | Connecticut | 9009 | 89 | 0 |
11019 | 11019 | 2020-03-25 | New Haven | Connecticut | 9009 | 127 | 2 |
12567 | 12567 | 2020-03-26 | New Haven | Connecticut | 9009 | 156 | 2 |
14236 | 14236 | 2020-03-27 | New Haven | Connecticut | 9009 | 222 | 6 |
16020 | 16020 | 2020-03-28 | New Haven | Connecticut | 9009 | 236 | 6 |
17912 | 17912 | 2020-03-29 | New Haven | Connecticut | 9009 | 280 | 6 |
19891 | 19891 | 2020-03-30 | New Haven | Connecticut | 9009 | 373 | 6 |
21968 | 21968 | 2020-03-31 | New Haven | Connecticut | 9009 | 517 | 12 |
24127 | 24127 | 2020-04-01 | New Haven | Connecticut | 9009 | 611 | 15 |
26357 | 26357 | 2020-04-02 | New Haven | Connecticut | 9009 | 647 | 17 |
28659 | 28659 | 2020-04-03 | New Haven | Connecticut | 9009 | 891 | 18 |
31017 | 31017 | 2020-04-04 | New Haven | Connecticut | 9009 | 1024 | 29 |
33423 | 33423 | 2020-04-05 | New Haven | Connecticut | 9009 | 1162 | 36 |
35868 | 35868 | 2020-04-06 | New Haven | Connecticut | 9009 | 1468 | 41 |
38358 | 38358 | 2020-04-07 | New Haven | Connecticut | 9009 | 1664 | 60 |
40901 | 40901 | 2020-04-08 | New Haven | Connecticut | 9009 | 1945 | 70 |
43475 | 43475 | 2020-04-09 | New Haven | Connecticut | 9009 | 2183 | 78 |
46075 | 46075 | 2020-04-10 | New Haven | Connecticut | 9009 | 2383 | 98 |
48705 | 48705 | 2020-04-11 | New Haven | Connecticut | 9009 | 2715 | 107 |
51367 | 51367 | 2020-04-12 | New Haven | Connecticut | 9009 | 2946 | 119 |
54046 | 54046 | 2020-04-13 | New Haven | Connecticut | 9009 | 3358 | 135 |
56738 | 56738 | 2020-04-14 | New Haven | Connecticut | 9009 | 3543 | 151 |
59446 | 59446 | 2020-04-15 | New Haven | Connecticut | 9009 | 3758 | 195 |
62165 | 62165 | 2020-04-16 | New Haven | Connecticut | 9009 | 4163 | 214 |
64898 | 64898 | 2020-04-17 | New Haven | Connecticut | 9009 | 4520 | 229 |
67646 | 67646 | 2020-04-18 | New Haven | Connecticut | 9009 | 4743 | 241 |
70408 | 70408 | 2020-04-19 | New Haven | Connecticut | 9009 | 4871 | 257 |
73177 | 73177 | 2020-04-20 | New Haven | Connecticut | 9009 | 5272 | 301 |
75953 | 75953 | 2020-04-21 | New Haven | Connecticut | 9009 | 5493 | 322 |
78737 | 78737 | 2020-04-22 | New Haven | Connecticut | 9009 | 5811 | 345 |
81531 | 81531 | 2020-04-23 | New Haven | Connecticut | 9009 | 6064 | 372 |
84331 | 84331 | 2020-04-24 | New Haven | Connecticut | 9009 | 6286 | 396 |
87139 | 87139 | 2020-04-25 | New Haven | Connecticut | 9009 | 6509 | 416 |
89956 | 89956 | 2020-04-26 | New Haven | Connecticut | 9009 | 6715 | 429 |
92774 | 92774 | 2020-04-27 | New Haven | Connecticut | 9009 | 6993 | 456 |
95606 | 95606 | 2020-04-28 | New Haven | Connecticut | 9009 | 7089 | 478 |
98451 | 98451 | 2020-04-29 | New Haven | Connecticut | 9009 | 7205 | 493 |
101301 | 101301 | 2020-04-30 | New Haven | Connecticut | 9009 | 7536 | 512 |
104156 | 104156 | 2020-05-01 | New Haven | Connecticut | 9009 | 7900 | 533 |
107021 | 107021 | 2020-05-02 | New Haven | Connecticut | 9009 | 8024 | 565 |
109890 | 109890 | 2020-05-03 | New Haven | Connecticut | 9009 | 8024 | 565 |
112765 | 112765 | 2020-05-04 | New Haven | Connecticut | 9009 | 8110 | 595 |
115648 | 115648 | 2020-05-05 | New Haven | Connecticut | 9009 | 8337 | 610 |
118608 | 118608 | 2020-05-06 | New Haven | Connecticut | 9009 | 8419 | 629 |
121577 | 121577 | 2020-05-07 | New Haven | Connecticut | 9009 | 8678 | 643 |
124557 | 124557 | 2020-05-08 | New Haven | Connecticut | 9009 | 8887 | 669 |
127543 | 127543 | 2020-05-09 | New Haven | Connecticut | 9009 | 9091 | 686 |
130534 | 130534 | 2020-05-10 | New Haven | Connecticut | 9009 | 9209 | 701 |
133525 | 133525 | 2020-05-11 | New Haven | Connecticut | 9009 | 9260 | 716 |
136514 | 136514 | 2020-05-12 | New Haven | Connecticut | 9009 | 9430 | 723 |
139505 | 139505 | 2020-05-13 | New Haven | Connecticut | 9009 | 9570 | 745 |
142501 | 142501 | 2020-05-14 | New Haven | Connecticut | 9009 | 9712 | 767 |
145501 | 145501 | 2020-05-15 | New Haven | Connecticut | 9009 | 9881 | 783 |
148504 | 148504 | 2020-05-16 | New Haven | Connecticut | 9009 | 10075 | 800 |
151513 | 151513 | 2020-05-17 | New Haven | Connecticut | 9009 | 10159 | 817 |
154525 | 154525 | 2020-05-18 | New Haven | Connecticut | 9009 | 10338 | 830 |
157541 | 157541 | 2020-05-19 | New Haven | Connecticut | 9009 | 10427 | 838 |
160567 | 160567 | 2020-05-20 | New Haven | Connecticut | 9009 | 10587 | 855 |
163595 | 163595 | 2020-05-21 | New Haven | Connecticut | 9009 | 10663 | 874 |
166628 | 166628 | 2020-05-22 | New Haven | Connecticut | 9009 | 10756 | 888 |
169665 | 169665 | 2020-05-23 | New Haven | Connecticut | 9009 | 10847 | 897 |
172706 | 172706 | 2020-05-24 | New Haven | Connecticut | 9009 | 10905 | 903 |
175749 | 175749 | 2020-05-25 | New Haven | Connecticut | 9009 | 11017 | 922 |
178793 | 178793 | 2020-05-26 | New Haven | Connecticut | 9009 | 11121 | 925 |
181837 | 181837 | 2020-05-27 | New Haven | Connecticut | 9009 | 11124 | 934 |
184891 | 184891 | 2020-05-28 | New Haven | Connecticut | 9009 | 11198 | 946 |
187947 | 187947 | 2020-05-29 | New Haven | Connecticut | 9009 | 11241 | 957 |
191012 | 191012 | 2020-05-30 | New Haven | Connecticut | 9009 | 11309 | 966 |
194079 | 194079 | 2020-05-31 | New Haven | Connecticut | 9009 | 11323 | 972 |
197149 | 197149 | 2020-06-01 | New Haven | Connecticut | 9009 | 11479 | 973 |
200222 | 200222 | 2020-06-02 | New Haven | Connecticut | 9009 | 11525 | 985 |
203298 | 203298 | 2020-06-03 | New Haven | Connecticut | 9009 | 11548 | 990 |
206378 | 206378 | 2020-06-04 | New Haven | Connecticut | 9009 | 11582 | 992 |
209459 | 209459 | 2020-06-05 | New Haven | Connecticut | 9009 | 11673 | 999 |
212544 | 212544 | 2020-06-06 | New Haven | Connecticut | 9009 | 11817 | 1007 |
215631 | 215631 | 2020-06-07 | New Haven | Connecticut | 9009 | 11828 | 1010 |
218722 | 218722 | 2020-06-08 | New Haven | Connecticut | 9009 | 11860 | 1013 |
221817 | 221817 | 2020-06-09 | New Haven | Connecticut | 9009 | 11875 | 1016 |
224912 | 224912 | 2020-06-10 | New Haven | Connecticut | 9009 | 11911 | 1024 |
228014 | 228014 | 2020-06-11 | New Haven | Connecticut | 9009 | 11930 | 1031 |
231117 | 231117 | 2020-06-12 | New Haven | Connecticut | 9009 | 11979 | 1034 |
234223 | 234223 | 2020-06-13 | New Haven | Connecticut | 9009 | 12021 | 1041 |
237330 | 237330 | 2020-06-14 | New Haven | Connecticut | 9009 | 12034 | 1044 |
240438 | 240438 | 2020-06-15 | New Haven | Connecticut | 9009 | 12055 | 1045 |
243549 | 243549 | 2020-06-16 | New Haven | Connecticut | 9009 | 12078 | 1046 |
246662 | 246662 | 2020-06-17 | New Haven | Connecticut | 9009 | 12089 | 1052 |
249774 | 249774 | 2020-06-18 | New Haven | Connecticut | 9009 | 12105 | 1052 |
252889 | 252889 | 2020-06-19 | New Haven | Connecticut | 9009 | 12136 | 1056 |
256008 | 256008 | 2020-06-20 | New Haven | Connecticut | 9009 | 12174 | 1060 |
259135 | 259135 | 2020-06-21 | New Haven | Connecticut | 9009 | 12185 | 1061 |
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);