ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Otsego" and state = "New York" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
9023 | 9023 | 2020-03-23 | Otsego | New York | 36077 | 1 | 0 |
10331 | 10331 | 2020-03-24 | Otsego | New York | 36077 | 1 | 0 |
11767 | 11767 | 2020-03-25 | Otsego | New York | 36077 | 2 | 0 |
13370 | 13370 | 2020-03-26 | Otsego | New York | 36077 | 3 | 0 |
15104 | 15104 | 2020-03-27 | Otsego | New York | 36077 | 5 | 0 |
16934 | 16934 | 2020-03-28 | Otsego | New York | 36077 | 7 | 0 |
18859 | 18859 | 2020-03-29 | Otsego | New York | 36077 | 10 | 0 |
20898 | 20898 | 2020-03-30 | Otsego | New York | 36077 | 17 | 0 |
23021 | 23021 | 2020-03-31 | Otsego | New York | 36077 | 18 | 0 |
25215 | 25215 | 2020-04-01 | Otsego | New York | 36077 | 19 | 1 |
27475 | 27475 | 2020-04-02 | Otsego | New York | 36077 | 21 | 1 |
29799 | 29799 | 2020-04-03 | Otsego | New York | 36077 | 21 | 1 |
32185 | 32185 | 2020-04-04 | Otsego | New York | 36077 | 26 | 2 |
34616 | 34616 | 2020-04-05 | Otsego | New York | 36077 | 29 | 2 |
37086 | 37086 | 2020-04-06 | Otsego | New York | 36077 | 34 | 2 |
39601 | 39601 | 2020-04-07 | Otsego | New York | 36077 | 34 | 2 |
42158 | 42158 | 2020-04-08 | Otsego | New York | 36077 | 38 | 2 |
44741 | 44741 | 2020-04-09 | Otsego | New York | 36077 | 39 | 2 |
47354 | 47354 | 2020-04-10 | Otsego | New York | 36077 | 41 | 2 |
50009 | 50009 | 2020-04-11 | Otsego | New York | 36077 | 43 | 2 |
52682 | 52682 | 2020-04-12 | Otsego | New York | 36077 | 43 | 2 |
55365 | 55365 | 2020-04-13 | Otsego | New York | 36077 | 43 | 3 |
58065 | 58065 | 2020-04-14 | Otsego | New York | 36077 | 44 | 3 |
60779 | 60779 | 2020-04-15 | Otsego | New York | 36077 | 44 | 4 |
63505 | 63505 | 2020-04-16 | Otsego | New York | 36077 | 44 | 4 |
66247 | 66247 | 2020-04-17 | Otsego | New York | 36077 | 44 | 4 |
69004 | 69004 | 2020-04-18 | Otsego | New York | 36077 | 47 | 4 |
71771 | 71771 | 2020-04-19 | Otsego | New York | 36077 | 48 | 5 |
74546 | 74546 | 2020-04-20 | Otsego | New York | 36077 | 49 | 5 |
77327 | 77327 | 2020-04-21 | Otsego | New York | 36077 | 49 | 5 |
80116 | 80116 | 2020-04-22 | Otsego | New York | 36077 | 49 | 5 |
82915 | 82915 | 2020-04-23 | Otsego | New York | 36077 | 50 | 5 |
85719 | 85719 | 2020-04-24 | Otsego | New York | 36077 | 50 | 5 |
88531 | 88531 | 2020-04-25 | Otsego | New York | 36077 | 60 | 5 |
91346 | 91346 | 2020-04-26 | Otsego | New York | 36077 | 60 | 5 |
94171 | 94171 | 2020-04-27 | Otsego | New York | 36077 | 62 | 5 |
97007 | 97007 | 2020-04-28 | Otsego | New York | 36077 | 65 | 5 |
99854 | 99854 | 2020-04-29 | Otsego | New York | 36077 | 66 | 5 |
102707 | 102707 | 2020-04-30 | Otsego | New York | 36077 | 67 | 5 |
105569 | 105569 | 2020-05-01 | Otsego | New York | 36077 | 67 | 5 |
108436 | 108436 | 2020-05-02 | Otsego | New York | 36077 | 67 | 5 |
111309 | 111309 | 2020-05-03 | Otsego | New York | 36077 | 67 | 5 |
114190 | 114190 | 2020-05-04 | Otsego | New York | 36077 | 67 | 5 |
117070 | 117070 | 2020-05-05 | Otsego | New York | 36077 | 67 | 5 |
120031 | 120031 | 2020-05-06 | Otsego | New York | 36077 | 67 | 5 |
123006 | 123006 | 2020-05-07 | Otsego | New York | 36077 | 67 | 5 |
125989 | 125989 | 2020-05-08 | Otsego | New York | 36077 | 67 | 5 |
128978 | 128978 | 2020-05-09 | Otsego | New York | 36077 | 67 | 5 |
131967 | 131967 | 2020-05-10 | Otsego | New York | 36077 | 67 | 5 |
134958 | 134958 | 2020-05-11 | Otsego | New York | 36077 | 67 | 5 |
137948 | 137948 | 2020-05-12 | Otsego | New York | 36077 | 67 | 5 |
140944 | 140944 | 2020-05-13 | Otsego | New York | 36077 | 67 | 5 |
143939 | 143939 | 2020-05-14 | Otsego | New York | 36077 | 67 | 5 |
146940 | 146940 | 2020-05-15 | Otsego | New York | 36077 | 67 | 5 |
149947 | 149947 | 2020-05-16 | Otsego | New York | 36077 | 67 | 5 |
152957 | 152957 | 2020-05-17 | Otsego | New York | 36077 | 67 | 5 |
155974 | 155974 | 2020-05-18 | Otsego | New York | 36077 | 67 | 5 |
158992 | 158992 | 2020-05-19 | Otsego | New York | 36077 | 67 | 5 |
162019 | 162019 | 2020-05-20 | Otsego | New York | 36077 | 67 | 6 |
165048 | 165048 | 2020-05-21 | Otsego | New York | 36077 | 67 | 6 |
168083 | 168083 | 2020-05-22 | Otsego | New York | 36077 | 67 | 6 |
171122 | 171122 | 2020-05-23 | Otsego | New York | 36077 | 68 | 6 |
174164 | 174164 | 2020-05-24 | Otsego | New York | 36077 | 69 | 6 |
177208 | 177208 | 2020-05-25 | Otsego | New York | 36077 | 69 | 6 |
180251 | 180251 | 2020-05-26 | Otsego | New York | 36077 | 69 | 6 |
183299 | 183299 | 2020-05-27 | Otsego | New York | 36077 | 69 | 6 |
186356 | 186356 | 2020-05-28 | Otsego | New York | 36077 | 70 | 6 |
189416 | 189416 | 2020-05-29 | Otsego | New York | 36077 | 71 | 6 |
192480 | 192480 | 2020-05-30 | Otsego | New York | 36077 | 71 | 6 |
195550 | 195550 | 2020-05-31 | Otsego | New York | 36077 | 72 | 6 |
198623 | 198623 | 2020-06-01 | Otsego | New York | 36077 | 72 | 6 |
201697 | 201697 | 2020-06-02 | Otsego | New York | 36077 | 73 | 6 |
204774 | 204774 | 2020-06-03 | Otsego | New York | 36077 | 73 | 6 |
207855 | 207855 | 2020-06-04 | Otsego | New York | 36077 | 73 | 6 |
210937 | 210937 | 2020-06-05 | Otsego | New York | 36077 | 73 | 6 |
214021 | 214021 | 2020-06-06 | Otsego | New York | 36077 | 74 | 6 |
217111 | 217111 | 2020-06-07 | Otsego | New York | 36077 | 74 | 6 |
220203 | 220203 | 2020-06-08 | Otsego | New York | 36077 | 75 | 6 |
223297 | 223297 | 2020-06-09 | Otsego | New York | 36077 | 75 | 6 |
226397 | 226397 | 2020-06-10 | Otsego | New York | 36077 | 77 | 6 |
229501 | 229501 | 2020-06-11 | Otsego | New York | 36077 | 78 | 6 |
232606 | 232606 | 2020-06-12 | Otsego | New York | 36077 | 78 | 6 |
235711 | 235711 | 2020-06-13 | Otsego | New York | 36077 | 80 | 6 |
238819 | 238819 | 2020-06-14 | Otsego | New York | 36077 | 80 | 6 |
241928 | 241928 | 2020-06-15 | Otsego | New York | 36077 | 80 | 6 |
245040 | 245040 | 2020-06-16 | Otsego | New York | 36077 | 81 | 6 |
248153 | 248153 | 2020-06-17 | Otsego | New York | 36077 | 82 | 6 |
251268 | 251268 | 2020-06-18 | Otsego | New York | 36077 | 82 | 6 |
254383 | 254383 | 2020-06-19 | Otsego | New York | 36077 | 82 | 6 |
257506 | 257506 | 2020-06-20 | Otsego | New York | 36077 | 82 | 6 |
260633 | 260633 | 2020-06-21 | Otsego | New York | 36077 | 82 | 6 |
263761 | 263761 | 2020-06-22 | Otsego | New York | 36077 | 83 | 6 |
266889 | 266889 | 2020-06-23 | Otsego | New York | 36077 | 83 | 6 |
270023 | 270023 | 2020-06-24 | Otsego | New York | 36077 | 83 | 6 |
273162 | 273162 | 2020-06-25 | Otsego | New York | 36077 | 83 | 6 |
276308 | 276308 | 2020-06-26 | Otsego | New York | 36077 | 83 | 6 |
279456 | 279456 | 2020-06-27 | Otsego | New York | 36077 | 84 | 6 |
282602 | 282602 | 2020-06-28 | Otsego | New York | 36077 | 84 | 6 |
285747 | 285747 | 2020-06-29 | Otsego | New York | 36077 | 84 | 6 |
288897 | 288897 | 2020-06-30 | Otsego | New York | 36077 | 84 | 6 |
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);