ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Monroe" and state = "New York" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387788 | 387788 | 2020-07-31 | Monroe | New York | 36055 | 4711 | 266 |
384571 | 384571 | 2020-07-30 | Monroe | New York | 36055 | 4678 | 266 |
381353 | 381353 | 2020-07-29 | Monroe | New York | 36055 | 4657 | 266 |
378136 | 378136 | 2020-07-28 | Monroe | New York | 36055 | 4633 | 266 |
374920 | 374920 | 2020-07-27 | Monroe | New York | 36055 | 4621 | 266 |
371708 | 371708 | 2020-07-26 | Monroe | New York | 36055 | 4592 | 266 |
368496 | 368496 | 2020-07-25 | Monroe | New York | 36055 | 4570 | 266 |
365287 | 365287 | 2020-07-24 | Monroe | New York | 36055 | 4538 | 266 |
362081 | 362081 | 2020-07-23 | Monroe | New York | 36055 | 4512 | 266 |
358875 | 358875 | 2020-07-22 | Monroe | New York | 36055 | 4493 | 266 |
355671 | 355671 | 2020-07-21 | Monroe | New York | 36055 | 4453 | 265 |
352468 | 352468 | 2020-07-20 | Monroe | New York | 36055 | 4423 | 265 |
349265 | 349265 | 2020-07-19 | Monroe | New York | 36055 | 4402 | 265 |
346064 | 346064 | 2020-07-18 | Monroe | New York | 36055 | 4384 | 264 |
342865 | 342865 | 2020-07-17 | Monroe | New York | 36055 | 4354 | 264 |
339667 | 339667 | 2020-07-16 | Monroe | New York | 36055 | 4318 | 264 |
336471 | 336471 | 2020-07-15 | Monroe | New York | 36055 | 4282 | 264 |
333277 | 333277 | 2020-07-14 | Monroe | New York | 36055 | 4248 | 264 |
330087 | 330087 | 2020-07-13 | Monroe | New York | 36055 | 4201 | 264 |
326900 | 326900 | 2020-07-12 | Monroe | New York | 36055 | 4178 | 264 |
323716 | 323716 | 2020-07-11 | Monroe | New York | 36055 | 4154 | 263 |
320536 | 320536 | 2020-07-10 | Monroe | New York | 36055 | 4121 | 263 |
317359 | 317359 | 2020-07-09 | Monroe | New York | 36055 | 4075 | 263 |
314185 | 314185 | 2020-07-08 | Monroe | New York | 36055 | 4047 | 262 |
311014 | 311014 | 2020-07-07 | Monroe | New York | 36055 | 4005 | 262 |
307846 | 307846 | 2020-07-06 | Monroe | New York | 36055 | 3975 | 262 |
304679 | 304679 | 2020-07-05 | Monroe | New York | 36055 | 3954 | 262 |
301516 | 301516 | 2020-07-04 | Monroe | New York | 36055 | 3923 | 262 |
298353 | 298353 | 2020-07-03 | Monroe | New York | 36055 | 3886 | 262 |
295193 | 295193 | 2020-07-02 | Monroe | New York | 36055 | 3834 | 262 |
292038 | 292038 | 2020-07-01 | Monroe | New York | 36055 | 3781 | 262 |
288886 | 288886 | 2020-06-30 | Monroe | New York | 36055 | 3743 | 261 |
285736 | 285736 | 2020-06-29 | Monroe | New York | 36055 | 3710 | 261 |
282591 | 282591 | 2020-06-28 | Monroe | New York | 36055 | 3691 | 261 |
279445 | 279445 | 2020-06-27 | Monroe | New York | 36055 | 3677 | 260 |
276297 | 276297 | 2020-06-26 | Monroe | New York | 36055 | 3642 | 258 |
273151 | 273151 | 2020-06-25 | Monroe | New York | 36055 | 3603 | 258 |
270012 | 270012 | 2020-06-24 | Monroe | New York | 36055 | 3568 | 257 |
266878 | 266878 | 2020-06-23 | Monroe | New York | 36055 | 3541 | 256 |
263750 | 263750 | 2020-06-22 | Monroe | New York | 36055 | 3513 | 256 |
260622 | 260622 | 2020-06-21 | Monroe | New York | 36055 | 3499 | 255 |
257495 | 257495 | 2020-06-20 | Monroe | New York | 36055 | 3488 | 253 |
254372 | 254372 | 2020-06-19 | Monroe | New York | 36055 | 3462 | 250 |
251257 | 251257 | 2020-06-18 | Monroe | New York | 36055 | 3440 | 249 |
248142 | 248142 | 2020-06-17 | Monroe | New York | 36055 | 3419 | 248 |
245029 | 245029 | 2020-06-16 | Monroe | New York | 36055 | 3403 | 248 |
241917 | 241917 | 2020-06-15 | Monroe | New York | 36055 | 3381 | 247 |
238808 | 238808 | 2020-06-14 | Monroe | New York | 36055 | 3371 | 246 |
235700 | 235700 | 2020-06-13 | Monroe | New York | 36055 | 3341 | 245 |
232595 | 232595 | 2020-06-12 | Monroe | New York | 36055 | 3321 | 244 |
229490 | 229490 | 2020-06-11 | Monroe | New York | 36055 | 3294 | 242 |
226386 | 226386 | 2020-06-10 | Monroe | New York | 36055 | 3256 | 239 |
223286 | 223286 | 2020-06-09 | Monroe | New York | 36055 | 3244 | 235 |
220192 | 220192 | 2020-06-08 | Monroe | New York | 36055 | 3204 | 235 |
217100 | 217100 | 2020-06-07 | Monroe | New York | 36055 | 3191 | 234 |
214010 | 214010 | 2020-06-06 | Monroe | New York | 36055 | 3168 | 233 |
210926 | 210926 | 2020-06-05 | Monroe | New York | 36055 | 3118 | 232 |
207844 | 207844 | 2020-06-04 | Monroe | New York | 36055 | 3082 | 230 |
204763 | 204763 | 2020-06-03 | Monroe | New York | 36055 | 3049 | 227 |
201686 | 201686 | 2020-06-02 | Monroe | New York | 36055 | 2990 | 225 |
198612 | 198612 | 2020-06-01 | Monroe | New York | 36055 | 2965 | 220 |
195539 | 195539 | 2020-05-31 | Monroe | New York | 36055 | 2943 | 218 |
192469 | 192469 | 2020-05-30 | Monroe | New York | 36055 | 2910 | 218 |
189405 | 189405 | 2020-05-29 | Monroe | New York | 36055 | 2861 | 213 |
186345 | 186345 | 2020-05-28 | Monroe | New York | 36055 | 2825 | 210 |
183288 | 183288 | 2020-05-27 | Monroe | New York | 36055 | 2792 | 208 |
180240 | 180240 | 2020-05-26 | Monroe | New York | 36055 | 2763 | 201 |
177197 | 177197 | 2020-05-25 | Monroe | New York | 36055 | 2734 | 200 |
174153 | 174153 | 2020-05-24 | Monroe | New York | 36055 | 2698 | 192 |
171111 | 171111 | 2020-05-23 | Monroe | New York | 36055 | 2662 | 185 |
168072 | 168072 | 2020-05-22 | Monroe | New York | 36055 | 2602 | 181 |
165037 | 165037 | 2020-05-21 | Monroe | New York | 36055 | 2531 | 178 |
162008 | 162008 | 2020-05-20 | Monroe | New York | 36055 | 2466 | 174 |
158981 | 158981 | 2020-05-19 | Monroe | New York | 36055 | 2377 | 172 |
155963 | 155963 | 2020-05-18 | Monroe | New York | 36055 | 2304 | 170 |
152946 | 152946 | 2020-05-17 | Monroe | New York | 36055 | 2259 | 168 |
149936 | 149936 | 2020-05-16 | Monroe | New York | 36055 | 2193 | 165 |
146929 | 146929 | 2020-05-15 | Monroe | New York | 36055 | 2092 | 156 |
143928 | 143928 | 2020-05-14 | Monroe | New York | 36055 | 2020 | 154 |
140933 | 140933 | 2020-05-13 | Monroe | New York | 36055 | 1960 | 152 |
137937 | 137937 | 2020-05-12 | Monroe | New York | 36055 | 1891 | 151 |
134947 | 134947 | 2020-05-11 | Monroe | New York | 36055 | 1851 | 149 |
131956 | 131956 | 2020-05-10 | Monroe | New York | 36055 | 1822 | 143 |
128967 | 128967 | 2020-05-09 | Monroe | New York | 36055 | 1776 | 139 |
125978 | 125978 | 2020-05-08 | Monroe | New York | 36055 | 1736 | 136 |
122995 | 122995 | 2020-05-07 | Monroe | New York | 36055 | 1689 | 135 |
120020 | 120020 | 2020-05-06 | Monroe | New York | 36055 | 1655 | 130 |
117059 | 117059 | 2020-05-05 | Monroe | New York | 36055 | 1624 | 101 |
114179 | 114179 | 2020-05-04 | Monroe | New York | 36055 | 1595 | 97 |
111298 | 111298 | 2020-05-03 | Monroe | New York | 36055 | 1566 | 96 |
108425 | 108425 | 2020-05-02 | Monroe | New York | 36055 | 1534 | 96 |
105558 | 105558 | 2020-05-01 | Monroe | New York | 36055 | 1478 | 95 |
102696 | 102696 | 2020-04-30 | Monroe | New York | 36055 | 1441 | 93 |
99843 | 99843 | 2020-04-29 | Monroe | New York | 36055 | 1404 | 93 |
96996 | 96996 | 2020-04-28 | Monroe | New York | 36055 | 1371 | 91 |
94160 | 94160 | 2020-04-27 | Monroe | New York | 36055 | 1331 | 89 |
91335 | 91335 | 2020-04-26 | Monroe | New York | 36055 | 1316 | 85 |
88520 | 88520 | 2020-04-25 | Monroe | New York | 36055 | 1285 | 82 |
85708 | 85708 | 2020-04-24 | Monroe | New York | 36055 | 1199 | 78 |
82904 | 82904 | 2020-04-23 | Monroe | New York | 36055 | 1152 | 77 |
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);