ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
789 rows where fips = 36069 and state = "New York" sorted by rowid
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid ▼ | date | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
3036 | 3036 | 2020-03-16 | Ontario | New York | 36069 | 1 | 0 |
3552 | 3552 | 2020-03-17 | Ontario | New York | 36069 | 1 | 0 |
4153 | 4153 | 2020-03-18 | Ontario | New York | 36069 | 1 | 0 |
4882 | 4882 | 2020-03-19 | Ontario | New York | 36069 | 1 | 0 |
5733 | 5733 | 2020-03-20 | Ontario | New York | 36069 | 3 | 0 |
6727 | 6727 | 2020-03-21 | Ontario | New York | 36069 | 4 | 0 |
7822 | 7822 | 2020-03-22 | Ontario | New York | 36069 | 6 | 0 |
9020 | 9020 | 2020-03-23 | Ontario | New York | 36069 | 6 | 0 |
10327 | 10327 | 2020-03-24 | Ontario | New York | 36069 | 7 | 0 |
11763 | 11763 | 2020-03-25 | Ontario | New York | 36069 | 9 | 0 |
13366 | 13366 | 2020-03-26 | Ontario | New York | 36069 | 11 | 0 |
15100 | 15100 | 2020-03-27 | Ontario | New York | 36069 | 14 | 0 |
16930 | 16930 | 2020-03-28 | Ontario | New York | 36069 | 16 | 0 |
18855 | 18855 | 2020-03-29 | Ontario | New York | 36069 | 18 | 0 |
20894 | 20894 | 2020-03-30 | Ontario | New York | 36069 | 20 | 0 |
23017 | 23017 | 2020-03-31 | Ontario | New York | 36069 | 22 | 0 |
25211 | 25211 | 2020-04-01 | Ontario | New York | 36069 | 24 | 0 |
27471 | 27471 | 2020-04-02 | Ontario | New York | 36069 | 31 | 0 |
29795 | 29795 | 2020-04-03 | Ontario | New York | 36069 | 31 | 0 |
32181 | 32181 | 2020-04-04 | Ontario | New York | 36069 | 35 | 0 |
34612 | 34612 | 2020-04-05 | Ontario | New York | 36069 | 35 | 0 |
37082 | 37082 | 2020-04-06 | Ontario | New York | 36069 | 39 | 0 |
39597 | 39597 | 2020-04-07 | Ontario | New York | 36069 | 39 | 0 |
42154 | 42154 | 2020-04-08 | Ontario | New York | 36069 | 39 | 0 |
44737 | 44737 | 2020-04-09 | Ontario | New York | 36069 | 43 | 0 |
47350 | 47350 | 2020-04-10 | Ontario | New York | 36069 | 51 | 0 |
50005 | 50005 | 2020-04-11 | Ontario | New York | 36069 | 56 | 0 |
52678 | 52678 | 2020-04-12 | Ontario | New York | 36069 | 57 | 1 |
55361 | 55361 | 2020-04-13 | Ontario | New York | 36069 | 57 | 1 |
58061 | 58061 | 2020-04-14 | Ontario | New York | 36069 | 61 | 2 |
60775 | 60775 | 2020-04-15 | Ontario | New York | 36069 | 62 | 2 |
63501 | 63501 | 2020-04-16 | Ontario | New York | 36069 | 65 | 2 |
66243 | 66243 | 2020-04-17 | Ontario | New York | 36069 | 67 | 2 |
69000 | 69000 | 2020-04-18 | Ontario | New York | 36069 | 69 | 2 |
71767 | 71767 | 2020-04-19 | Ontario | New York | 36069 | 70 | 2 |
74542 | 74542 | 2020-04-20 | Ontario | New York | 36069 | 71 | 2 |
77323 | 77323 | 2020-04-21 | Ontario | New York | 36069 | 72 | 2 |
80112 | 80112 | 2020-04-22 | Ontario | New York | 36069 | 73 | 3 |
82911 | 82911 | 2020-04-23 | Ontario | New York | 36069 | 73 | 3 |
85715 | 85715 | 2020-04-24 | Ontario | New York | 36069 | 73 | 3 |
88527 | 88527 | 2020-04-25 | Ontario | New York | 36069 | 82 | 3 |
91342 | 91342 | 2020-04-26 | Ontario | New York | 36069 | 84 | 3 |
94167 | 94167 | 2020-04-27 | Ontario | New York | 36069 | 86 | 3 |
97003 | 97003 | 2020-04-28 | Ontario | New York | 36069 | 90 | 3 |
99850 | 99850 | 2020-04-29 | Ontario | New York | 36069 | 90 | 3 |
102703 | 102703 | 2020-04-30 | Ontario | New York | 36069 | 90 | 4 |
105565 | 105565 | 2020-05-01 | Ontario | New York | 36069 | 91 | 4 |
108432 | 108432 | 2020-05-02 | Ontario | New York | 36069 | 92 | 4 |
111305 | 111305 | 2020-05-03 | Ontario | New York | 36069 | 95 | 4 |
114186 | 114186 | 2020-05-04 | Ontario | New York | 36069 | 96 | 4 |
117066 | 117066 | 2020-05-05 | Ontario | New York | 36069 | 97 | 4 |
120027 | 120027 | 2020-05-06 | Ontario | New York | 36069 | 99 | 7 |
123002 | 123002 | 2020-05-07 | Ontario | New York | 36069 | 101 | 7 |
125985 | 125985 | 2020-05-08 | Ontario | New York | 36069 | 104 | 7 |
128974 | 128974 | 2020-05-09 | Ontario | New York | 36069 | 104 | 7 |
131963 | 131963 | 2020-05-10 | Ontario | New York | 36069 | 106 | 7 |
134954 | 134954 | 2020-05-11 | Ontario | New York | 36069 | 107 | 7 |
137944 | 137944 | 2020-05-12 | Ontario | New York | 36069 | 107 | 7 |
140940 | 140940 | 2020-05-13 | Ontario | New York | 36069 | 109 | 7 |
143935 | 143935 | 2020-05-14 | Ontario | New York | 36069 | 129 | 7 |
146936 | 146936 | 2020-05-15 | Ontario | New York | 36069 | 133 | 7 |
149943 | 149943 | 2020-05-16 | Ontario | New York | 36069 | 139 | 7 |
152953 | 152953 | 2020-05-17 | Ontario | New York | 36069 | 146 | 7 |
155970 | 155970 | 2020-05-18 | Ontario | New York | 36069 | 148 | 7 |
158988 | 158988 | 2020-05-19 | Ontario | New York | 36069 | 152 | 7 |
162015 | 162015 | 2020-05-20 | Ontario | New York | 36069 | 170 | 8 |
165044 | 165044 | 2020-05-21 | Ontario | New York | 36069 | 176 | 8 |
168079 | 168079 | 2020-05-22 | Ontario | New York | 36069 | 180 | 8 |
171118 | 171118 | 2020-05-23 | Ontario | New York | 36069 | 182 | 9 |
174160 | 174160 | 2020-05-24 | Ontario | New York | 36069 | 184 | 11 |
177204 | 177204 | 2020-05-25 | Ontario | New York | 36069 | 185 | 12 |
180247 | 180247 | 2020-05-26 | Ontario | New York | 36069 | 195 | 14 |
183295 | 183295 | 2020-05-27 | Ontario | New York | 36069 | 198 | 16 |
186352 | 186352 | 2020-05-28 | Ontario | New York | 36069 | 201 | 16 |
189412 | 189412 | 2020-05-29 | Ontario | New York | 36069 | 205 | 17 |
192476 | 192476 | 2020-05-30 | Ontario | New York | 36069 | 206 | 17 |
195546 | 195546 | 2020-05-31 | Ontario | New York | 36069 | 207 | 17 |
198619 | 198619 | 2020-06-01 | Ontario | New York | 36069 | 208 | 19 |
201693 | 201693 | 2020-06-02 | Ontario | New York | 36069 | 209 | 19 |
204770 | 204770 | 2020-06-03 | Ontario | New York | 36069 | 215 | 20 |
207851 | 207851 | 2020-06-04 | Ontario | New York | 36069 | 218 | 20 |
210933 | 210933 | 2020-06-05 | Ontario | New York | 36069 | 219 | 20 |
214017 | 214017 | 2020-06-06 | Ontario | New York | 36069 | 220 | 20 |
217107 | 217107 | 2020-06-07 | Ontario | New York | 36069 | 221 | 22 |
220199 | 220199 | 2020-06-08 | Ontario | New York | 36069 | 221 | 22 |
223293 | 223293 | 2020-06-09 | Ontario | New York | 36069 | 222 | 22 |
226393 | 226393 | 2020-06-10 | Ontario | New York | 36069 | 222 | 22 |
229497 | 229497 | 2020-06-11 | Ontario | New York | 36069 | 229 | 22 |
232602 | 232602 | 2020-06-12 | Ontario | New York | 36069 | 230 | 22 |
235707 | 235707 | 2020-06-13 | Ontario | New York | 36069 | 230 | 22 |
238815 | 238815 | 2020-06-14 | Ontario | New York | 36069 | 233 | 22 |
241924 | 241924 | 2020-06-15 | Ontario | New York | 36069 | 233 | 22 |
245036 | 245036 | 2020-06-16 | Ontario | New York | 36069 | 234 | 22 |
248149 | 248149 | 2020-06-17 | Ontario | New York | 36069 | 234 | 22 |
251264 | 251264 | 2020-06-18 | Ontario | New York | 36069 | 235 | 22 |
254379 | 254379 | 2020-06-19 | Ontario | New York | 36069 | 239 | 22 |
257502 | 257502 | 2020-06-20 | Ontario | New York | 36069 | 239 | 23 |
260629 | 260629 | 2020-06-21 | Ontario | New York | 36069 | 240 | 24 |
263757 | 263757 | 2020-06-22 | Ontario | New York | 36069 | 242 | 25 |
266885 | 266885 | 2020-06-23 | Ontario | New York | 36069 | 242 | 25 |
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);