ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where county = "Allegany", fips = 36003 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 ▼ |
---|---|---|---|---|---|---|---|
3024 | 3024 | 2020-03-16 | Allegany | New York | 36003 | 2 | 0 |
3539 | 3539 | 2020-03-17 | Allegany | New York | 36003 | 2 | 0 |
4135 | 4135 | 2020-03-18 | Allegany | New York | 36003 | 2 | 0 |
4864 | 4864 | 2020-03-19 | Allegany | New York | 36003 | 2 | 0 |
5710 | 5710 | 2020-03-20 | Allegany | New York | 36003 | 2 | 0 |
6704 | 6704 | 2020-03-21 | Allegany | New York | 36003 | 2 | 0 |
7797 | 7797 | 2020-03-22 | Allegany | New York | 36003 | 2 | 0 |
8994 | 8994 | 2020-03-23 | Allegany | New York | 36003 | 2 | 0 |
10300 | 10300 | 2020-03-24 | Allegany | New York | 36003 | 2 | 0 |
11734 | 11734 | 2020-03-25 | Allegany | New York | 36003 | 2 | 0 |
13337 | 13337 | 2020-03-26 | Allegany | New York | 36003 | 2 | 0 |
15071 | 15071 | 2020-03-27 | Allegany | New York | 36003 | 2 | 0 |
16900 | 16900 | 2020-03-28 | Allegany | New York | 36003 | 2 | 0 |
18824 | 18824 | 2020-03-29 | Allegany | New York | 36003 | 6 | 0 |
20863 | 20863 | 2020-03-30 | Allegany | New York | 36003 | 7 | 0 |
22986 | 22986 | 2020-03-31 | Allegany | New York | 36003 | 7 | 0 |
42123 | 42123 | 2020-04-08 | Allegany | New York | 36003 | 21 | 0 |
44706 | 44706 | 2020-04-09 | Allegany | New York | 36003 | 22 | 0 |
47319 | 47319 | 2020-04-10 | Allegany | New York | 36003 | 26 | 0 |
49974 | 49974 | 2020-04-11 | Allegany | New York | 36003 | 26 | 0 |
52647 | 52647 | 2020-04-12 | Allegany | New York | 36003 | 26 | 0 |
55330 | 55330 | 2020-04-13 | Allegany | New York | 36003 | 26 | 0 |
58030 | 58030 | 2020-04-14 | Allegany | New York | 36003 | 28 | 0 |
60744 | 60744 | 2020-04-15 | Allegany | New York | 36003 | 28 | 0 |
63470 | 63470 | 2020-04-16 | Allegany | New York | 36003 | 28 | 0 |
66212 | 66212 | 2020-04-17 | Allegany | New York | 36003 | 29 | 0 |
68969 | 68969 | 2020-04-18 | Allegany | New York | 36003 | 30 | 0 |
71736 | 71736 | 2020-04-19 | Allegany | New York | 36003 | 30 | 0 |
74511 | 74511 | 2020-04-20 | Allegany | New York | 36003 | 30 | 0 |
77292 | 77292 | 2020-04-21 | Allegany | New York | 36003 | 30 | 0 |
80081 | 80081 | 2020-04-22 | Allegany | New York | 36003 | 30 | 0 |
82880 | 82880 | 2020-04-23 | Allegany | New York | 36003 | 30 | 0 |
85684 | 85684 | 2020-04-24 | Allegany | New York | 36003 | 31 | 0 |
88496 | 88496 | 2020-04-25 | Allegany | New York | 36003 | 35 | 0 |
91311 | 91311 | 2020-04-26 | Allegany | New York | 36003 | 35 | 0 |
94136 | 94136 | 2020-04-27 | Allegany | New York | 36003 | 35 | 0 |
96972 | 96972 | 2020-04-28 | Allegany | New York | 36003 | 35 | 0 |
99819 | 99819 | 2020-04-29 | Allegany | New York | 36003 | 35 | 0 |
102672 | 102672 | 2020-04-30 | Allegany | New York | 36003 | 35 | 0 |
105534 | 105534 | 2020-05-01 | Allegany | New York | 36003 | 35 | 0 |
108401 | 108401 | 2020-05-02 | Allegany | New York | 36003 | 35 | 0 |
111274 | 111274 | 2020-05-03 | Allegany | New York | 36003 | 35 | 0 |
114155 | 114155 | 2020-05-04 | Allegany | New York | 36003 | 35 | 0 |
117035 | 117035 | 2020-05-05 | Allegany | New York | 36003 | 35 | 0 |
119996 | 119996 | 2020-05-06 | Allegany | New York | 36003 | 35 | 0 |
122971 | 122971 | 2020-05-07 | Allegany | New York | 36003 | 35 | 0 |
125954 | 125954 | 2020-05-08 | Allegany | New York | 36003 | 35 | 0 |
128943 | 128943 | 2020-05-09 | Allegany | New York | 36003 | 35 | 0 |
131932 | 131932 | 2020-05-10 | Allegany | New York | 36003 | 36 | 0 |
134923 | 134923 | 2020-05-11 | Allegany | New York | 36003 | 38 | 0 |
137913 | 137913 | 2020-05-12 | Allegany | New York | 36003 | 42 | 0 |
140909 | 140909 | 2020-05-13 | Allegany | New York | 36003 | 44 | 0 |
143904 | 143904 | 2020-05-14 | Allegany | New York | 36003 | 44 | 0 |
146905 | 146905 | 2020-05-15 | Allegany | New York | 36003 | 44 | 0 |
149912 | 149912 | 2020-05-16 | Allegany | New York | 36003 | 44 | 0 |
152922 | 152922 | 2020-05-17 | Allegany | New York | 36003 | 44 | 0 |
155939 | 155939 | 2020-05-18 | Allegany | New York | 36003 | 44 | 0 |
158957 | 158957 | 2020-05-19 | Allegany | New York | 36003 | 44 | 0 |
161984 | 161984 | 2020-05-20 | Allegany | New York | 36003 | 44 | 0 |
165013 | 165013 | 2020-05-21 | Allegany | New York | 36003 | 44 | 0 |
168048 | 168048 | 2020-05-22 | Allegany | New York | 36003 | 44 | 0 |
171087 | 171087 | 2020-05-23 | Allegany | New York | 36003 | 44 | 0 |
174129 | 174129 | 2020-05-24 | Allegany | New York | 36003 | 44 | 0 |
177173 | 177173 | 2020-05-25 | Allegany | New York | 36003 | 44 | 0 |
180216 | 180216 | 2020-05-26 | Allegany | New York | 36003 | 44 | 0 |
183264 | 183264 | 2020-05-27 | Allegany | New York | 36003 | 45 | 0 |
186321 | 186321 | 2020-05-28 | Allegany | New York | 36003 | 45 | 0 |
189381 | 189381 | 2020-05-29 | Allegany | New York | 36003 | 45 | 0 |
192445 | 192445 | 2020-05-30 | Allegany | New York | 36003 | 45 | 0 |
195515 | 195515 | 2020-05-31 | Allegany | New York | 36003 | 45 | 0 |
198588 | 198588 | 2020-06-01 | Allegany | New York | 36003 | 48 | 0 |
201662 | 201662 | 2020-06-02 | Allegany | New York | 36003 | 48 | 0 |
204739 | 204739 | 2020-06-03 | Allegany | New York | 36003 | 49 | 0 |
207820 | 207820 | 2020-06-04 | Allegany | New York | 36003 | 49 | 0 |
210902 | 210902 | 2020-06-05 | Allegany | New York | 36003 | 51 | 0 |
213986 | 213986 | 2020-06-06 | Allegany | New York | 36003 | 51 | 0 |
217076 | 217076 | 2020-06-07 | Allegany | New York | 36003 | 51 | 0 |
220168 | 220168 | 2020-06-08 | Allegany | New York | 36003 | 51 | 0 |
223262 | 223262 | 2020-06-09 | Allegany | New York | 36003 | 51 | 0 |
226362 | 226362 | 2020-06-10 | Allegany | New York | 36003 | 52 | 0 |
229466 | 229466 | 2020-06-11 | Allegany | New York | 36003 | 53 | 0 |
232571 | 232571 | 2020-06-12 | Allegany | New York | 36003 | 53 | 0 |
235676 | 235676 | 2020-06-13 | Allegany | New York | 36003 | 54 | 0 |
238784 | 238784 | 2020-06-14 | Allegany | New York | 36003 | 54 | 0 |
241893 | 241893 | 2020-06-15 | Allegany | New York | 36003 | 55 | 0 |
245005 | 245005 | 2020-06-16 | Allegany | New York | 36003 | 55 | 0 |
248118 | 248118 | 2020-06-17 | Allegany | New York | 36003 | 55 | 0 |
251233 | 251233 | 2020-06-18 | Allegany | New York | 36003 | 57 | 0 |
254348 | 254348 | 2020-06-19 | Allegany | New York | 36003 | 58 | 0 |
257471 | 257471 | 2020-06-20 | Allegany | New York | 36003 | 58 | 0 |
260598 | 260598 | 2020-06-21 | Allegany | New York | 36003 | 58 | 0 |
263726 | 263726 | 2020-06-22 | Allegany | New York | 36003 | 58 | 0 |
266854 | 266854 | 2020-06-23 | Allegany | New York | 36003 | 58 | 0 |
269988 | 269988 | 2020-06-24 | Allegany | New York | 36003 | 58 | 0 |
273127 | 273127 | 2020-06-25 | Allegany | New York | 36003 | 58 | 0 |
276273 | 276273 | 2020-06-26 | Allegany | New York | 36003 | 58 | 0 |
279421 | 279421 | 2020-06-27 | Allegany | New York | 36003 | 58 | 0 |
282567 | 282567 | 2020-06-28 | Allegany | New York | 36003 | 59 | 0 |
285712 | 285712 | 2020-06-29 | Allegany | New York | 36003 | 59 | 0 |
288862 | 288862 | 2020-06-30 | Allegany | New York | 36003 | 59 | 0 |
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);