ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
793 rows where fips = 36027 and state = "New York" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
1518 | 1518 | 2020-03-12 | Dutchess | New York | 36027 | 1 | 0 |
1811 | 1811 | 2020-03-13 | Dutchess | New York | 36027 | 3 | 0 |
2160 | 2160 | 2020-03-14 | Dutchess | New York | 36027 | 4 | 0 |
2568 | 2568 | 2020-03-15 | Dutchess | New York | 36027 | 7 | 0 |
3027 | 3027 | 2020-03-16 | Dutchess | New York | 36027 | 10 | 0 |
3543 | 3543 | 2020-03-17 | Dutchess | New York | 36027 | 16 | 0 |
4140 | 4140 | 2020-03-18 | Dutchess | New York | 36027 | 20 | 0 |
4869 | 4869 | 2020-03-19 | Dutchess | New York | 36027 | 31 | 0 |
5716 | 5716 | 2020-03-20 | Dutchess | New York | 36027 | 36 | 0 |
6710 | 6710 | 2020-03-21 | Dutchess | New York | 36027 | 49 | 0 |
7804 | 7804 | 2020-03-22 | Dutchess | New York | 36027 | 82 | 0 |
9002 | 9002 | 2020-03-23 | Dutchess | New York | 36027 | 100 | 0 |
10309 | 10309 | 2020-03-24 | Dutchess | New York | 36027 | 124 | 0 |
11744 | 11744 | 2020-03-25 | Dutchess | New York | 36027 | 153 | 0 |
13347 | 13347 | 2020-03-26 | Dutchess | New York | 36027 | 190 | 2 |
15081 | 15081 | 2020-03-27 | Dutchess | New York | 36027 | 225 | 2 |
16911 | 16911 | 2020-03-28 | Dutchess | New York | 36027 | 262 | 2 |
18835 | 18835 | 2020-03-29 | Dutchess | New York | 36027 | 320 | 2 |
20874 | 20874 | 2020-03-30 | Dutchess | New York | 36027 | 392 | 3 |
22997 | 22997 | 2020-03-31 | Dutchess | New York | 36027 | 484 | 4 |
25191 | 25191 | 2020-04-01 | Dutchess | New York | 36027 | 547 | 5 |
27451 | 27451 | 2020-04-02 | Dutchess | New York | 36027 | 667 | 9 |
29775 | 29775 | 2020-04-03 | Dutchess | New York | 36027 | 809 | 9 |
32161 | 32161 | 2020-04-04 | Dutchess | New York | 36027 | 938 | 11 |
34592 | 34592 | 2020-04-05 | Dutchess | New York | 36027 | 1077 | 11 |
37062 | 37062 | 2020-04-06 | Dutchess | New York | 36027 | 1189 | 12 |
39577 | 39577 | 2020-04-07 | Dutchess | New York | 36027 | 1249 | 15 |
42134 | 42134 | 2020-04-08 | Dutchess | New York | 36027 | 1395 | 16 |
44717 | 44717 | 2020-04-09 | Dutchess | New York | 36027 | 1493 | 21 |
47330 | 47330 | 2020-04-10 | Dutchess | New York | 36027 | 1598 | 25 |
49985 | 49985 | 2020-04-11 | Dutchess | New York | 36027 | 1744 | 27 |
52658 | 52658 | 2020-04-12 | Dutchess | New York | 36027 | 1838 | 30 |
55341 | 55341 | 2020-04-13 | Dutchess | New York | 36027 | 1881 | 37 |
58041 | 58041 | 2020-04-14 | Dutchess | New York | 36027 | 1934 | 41 |
60755 | 60755 | 2020-04-15 | Dutchess | New York | 36027 | 2048 | 45 |
63481 | 63481 | 2020-04-16 | Dutchess | New York | 36027 | 2085 | 45 |
66223 | 66223 | 2020-04-17 | Dutchess | New York | 36027 | 2142 | 45 |
68980 | 68980 | 2020-04-18 | Dutchess | New York | 36027 | 2201 | 45 |
71747 | 71747 | 2020-04-19 | Dutchess | New York | 36027 | 2240 | 51 |
74522 | 74522 | 2020-04-20 | Dutchess | New York | 36027 | 2284 | 52 |
77303 | 77303 | 2020-04-21 | Dutchess | New York | 36027 | 2331 | 53 |
80092 | 80092 | 2020-04-22 | Dutchess | New York | 36027 | 2391 | 57 |
82891 | 82891 | 2020-04-23 | Dutchess | New York | 36027 | 2460 | 60 |
85695 | 85695 | 2020-04-24 | Dutchess | New York | 36027 | 2517 | 63 |
88507 | 88507 | 2020-04-25 | Dutchess | New York | 36027 | 2660 | 65 |
91322 | 91322 | 2020-04-26 | Dutchess | New York | 36027 | 2729 | 65 |
94147 | 94147 | 2020-04-27 | Dutchess | New York | 36027 | 2793 | 66 |
96983 | 96983 | 2020-04-28 | Dutchess | New York | 36027 | 2817 | 66 |
99830 | 99830 | 2020-04-29 | Dutchess | New York | 36027 | 2881 | 69 |
102683 | 102683 | 2020-04-30 | Dutchess | New York | 36027 | 2954 | 70 |
105545 | 105545 | 2020-05-01 | Dutchess | New York | 36027 | 3002 | 71 |
108412 | 108412 | 2020-05-02 | Dutchess | New York | 36027 | 3049 | 74 |
111285 | 111285 | 2020-05-03 | Dutchess | New York | 36027 | 3086 | 76 |
114166 | 114166 | 2020-05-04 | Dutchess | New York | 36027 | 3131 | 81 |
117046 | 117046 | 2020-05-05 | Dutchess | New York | 36027 | 3151 | 85 |
120007 | 120007 | 2020-05-06 | Dutchess | New York | 36027 | 3192 | 96 |
122982 | 122982 | 2020-05-07 | Dutchess | New York | 36027 | 3233 | 98 |
125965 | 125965 | 2020-05-08 | Dutchess | New York | 36027 | 3277 | 100 |
128954 | 128954 | 2020-05-09 | Dutchess | New York | 36027 | 3319 | 103 |
131943 | 131943 | 2020-05-10 | Dutchess | New York | 36027 | 3359 | 106 |
134934 | 134934 | 2020-05-11 | Dutchess | New York | 36027 | 3378 | 106 |
137924 | 137924 | 2020-05-12 | Dutchess | New York | 36027 | 3399 | 111 |
140920 | 140920 | 2020-05-13 | Dutchess | New York | 36027 | 3429 | 115 |
143915 | 143915 | 2020-05-14 | Dutchess | New York | 36027 | 3474 | 120 |
146916 | 146916 | 2020-05-15 | Dutchess | New York | 36027 | 3498 | 123 |
149923 | 149923 | 2020-05-16 | Dutchess | New York | 36027 | 3527 | 126 |
152933 | 152933 | 2020-05-17 | Dutchess | New York | 36027 | 3543 | 127 |
155950 | 155950 | 2020-05-18 | Dutchess | New York | 36027 | 3552 | 129 |
158968 | 158968 | 2020-05-19 | Dutchess | New York | 36027 | 3710 | 131 |
161995 | 161995 | 2020-05-20 | Dutchess | New York | 36027 | 3724 | 134 |
165024 | 165024 | 2020-05-21 | Dutchess | New York | 36027 | 3745 | 135 |
168059 | 168059 | 2020-05-22 | Dutchess | New York | 36027 | 3767 | 136 |
171098 | 171098 | 2020-05-23 | Dutchess | New York | 36027 | 3793 | 139 |
174140 | 174140 | 2020-05-24 | Dutchess | New York | 36027 | 3807 | 141 |
177184 | 177184 | 2020-05-25 | Dutchess | New York | 36027 | 3825 | 143 |
180227 | 180227 | 2020-05-26 | Dutchess | New York | 36027 | 3834 | 143 |
183275 | 183275 | 2020-05-27 | Dutchess | New York | 36027 | 3847 | 145 |
186332 | 186332 | 2020-05-28 | Dutchess | New York | 36027 | 3867 | 146 |
189392 | 189392 | 2020-05-29 | Dutchess | New York | 36027 | 3887 | 146 |
192456 | 192456 | 2020-05-30 | Dutchess | New York | 36027 | 3899 | 150 |
195526 | 195526 | 2020-05-31 | Dutchess | New York | 36027 | 3909 | 150 |
198599 | 198599 | 2020-06-01 | Dutchess | New York | 36027 | 3924 | 150 |
201673 | 201673 | 2020-06-02 | Dutchess | New York | 36027 | 3936 | 150 |
204750 | 204750 | 2020-06-03 | Dutchess | New York | 36027 | 3951 | 151 |
207831 | 207831 | 2020-06-04 | Dutchess | New York | 36027 | 3962 | 151 |
210913 | 210913 | 2020-06-05 | Dutchess | New York | 36027 | 3984 | 151 |
213997 | 213997 | 2020-06-06 | Dutchess | New York | 36027 | 3995 | 152 |
217087 | 217087 | 2020-06-07 | Dutchess | New York | 36027 | 4000 | 153 |
220179 | 220179 | 2020-06-08 | Dutchess | New York | 36027 | 4006 | 153 |
407077 | 407077 | 2020-08-06 | Dutchess | New York | 36027 | 4582 | 153 |
410297 | 410297 | 2020-08-07 | Dutchess | New York | 36027 | 4589 | 153 |
413517 | 413517 | 2020-08-08 | Dutchess | New York | 36027 | 4600 | 153 |
416738 | 416738 | 2020-08-09 | Dutchess | New York | 36027 | 4607 | 153 |
419958 | 419958 | 2020-08-10 | Dutchess | New York | 36027 | 4613 | 153 |
423181 | 423181 | 2020-08-11 | Dutchess | New York | 36027 | 4619 | 153 |
426404 | 426404 | 2020-08-12 | Dutchess | New York | 36027 | 4631 | 153 |
429629 | 429629 | 2020-08-13 | Dutchess | New York | 36027 | 4640 | 153 |
432855 | 432855 | 2020-08-14 | Dutchess | New York | 36027 | 4655 | 153 |
436081 | 436081 | 2020-08-15 | Dutchess | New York | 36027 | 4668 | 153 |
439306 | 439306 | 2020-08-16 | Dutchess | New York | 36027 | 4686 | 153 |
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);