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 |
---|---|---|---|---|---|---|---|
529815 | 529815 | 2020-09-13 | Monroe | New York | 36055 | 5728 | 258 |
526578 | 526578 | 2020-09-12 | Monroe | New York | 36055 | 5713 | 258 |
523342 | 523342 | 2020-09-11 | Monroe | New York | 36055 | 5677 | 258 |
520106 | 520106 | 2020-09-10 | Monroe | New York | 36055 | 5649 | 258 |
516870 | 516870 | 2020-09-09 | Monroe | New York | 36055 | 5616 | 258 |
513635 | 513635 | 2020-09-08 | Monroe | New York | 36055 | 5603 | 258 |
510402 | 510402 | 2020-09-07 | Monroe | New York | 36055 | 5586 | 258 |
507169 | 507169 | 2020-09-06 | Monroe | New York | 36055 | 5573 | 258 |
503937 | 503937 | 2020-09-05 | Monroe | New York | 36055 | 5552 | 258 |
500703 | 500703 | 2020-09-04 | Monroe | New York | 36055 | 5530 | 258 |
497469 | 497469 | 2020-09-03 | Monroe | New York | 36055 | 5503 | 258 |
494236 | 494236 | 2020-09-02 | Monroe | New York | 36055 | 5469 | 257 |
491002 | 491002 | 2020-09-01 | Monroe | New York | 36055 | 5463 | 257 |
487769 | 487769 | 2020-08-31 | Monroe | New York | 36055 | 5453 | 257 |
484536 | 484536 | 2020-08-30 | Monroe | New York | 36055 | 5444 | 257 |
481301 | 481301 | 2020-08-29 | Monroe | New York | 36055 | 5423 | 256 |
478068 | 478068 | 2020-08-28 | Monroe | New York | 36055 | 5399 | 256 |
474835 | 474835 | 2020-08-27 | Monroe | New York | 36055 | 5386 | 256 |
471601 | 471601 | 2020-08-26 | Monroe | New York | 36055 | 5365 | 255 |
468369 | 468369 | 2020-08-25 | Monroe | New York | 36055 | 5349 | 255 |
465141 | 465141 | 2020-08-24 | Monroe | New York | 36055 | 5331 | 255 |
461912 | 461912 | 2020-08-23 | Monroe | New York | 36055 | 5318 | 255 |
458684 | 458684 | 2020-08-22 | Monroe | New York | 36055 | 5298 | 255 |
455456 | 455456 | 2020-08-21 | Monroe | New York | 36055 | 5274 | 255 |
452228 | 452228 | 2020-08-20 | Monroe | New York | 36055 | 5257 | 255 |
449000 | 449000 | 2020-08-19 | Monroe | New York | 36055 | 5242 | 255 |
445772 | 445772 | 2020-08-18 | Monroe | New York | 36055 | 5214 | 255 |
442546 | 442546 | 2020-08-17 | Monroe | New York | 36055 | 5184 | 255 |
439319 | 439319 | 2020-08-16 | Monroe | New York | 36055 | 5166 | 255 |
436094 | 436094 | 2020-08-15 | Monroe | New York | 36055 | 5144 | 255 |
432868 | 432868 | 2020-08-14 | Monroe | New York | 36055 | 5123 | 255 |
429642 | 429642 | 2020-08-13 | Monroe | New York | 36055 | 5080 | 255 |
426417 | 426417 | 2020-08-12 | Monroe | New York | 36055 | 5036 | 255 |
423194 | 423194 | 2020-08-11 | Monroe | New York | 36055 | 5003 | 255 |
419971 | 419971 | 2020-08-10 | Monroe | New York | 36055 | 4977 | 254 |
416751 | 416751 | 2020-08-09 | Monroe | New York | 36055 | 4957 | 254 |
413530 | 413530 | 2020-08-08 | Monroe | New York | 36055 | 4923 | 254 |
410310 | 410310 | 2020-08-07 | Monroe | New York | 36055 | 4902 | 254 |
407090 | 407090 | 2020-08-06 | Monroe | New York | 36055 | 4869 | 254 |
403871 | 403871 | 2020-08-05 | Monroe | New York | 36055 | 4842 | 269 |
400653 | 400653 | 2020-08-04 | Monroe | New York | 36055 | 4822 | 269 |
397438 | 397438 | 2020-08-03 | Monroe | New York | 36055 | 4791 | 268 |
394221 | 394221 | 2020-08-02 | Monroe | New York | 36055 | 4769 | 268 |
391005 | 391005 | 2020-08-01 | Monroe | New York | 36055 | 4743 | 266 |
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 |
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);