ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
782 rows where county = "Monroe" and fips = 17133 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
290883 | 290883 | 2020-07-01 | Monroe | Illinois | 17133 | 127 | 13 |
294037 | 294037 | 2020-07-02 | Monroe | Illinois | 17133 | 128 | 13 |
297194 | 297194 | 2020-07-03 | Monroe | Illinois | 17133 | 129 | 13 |
300356 | 300356 | 2020-07-04 | Monroe | Illinois | 17133 | 129 | 13 |
303520 | 303520 | 2020-07-05 | Monroe | Illinois | 17133 | 130 | 13 |
306685 | 306685 | 2020-07-06 | Monroe | Illinois | 17133 | 137 | 13 |
309853 | 309853 | 2020-07-07 | Monroe | Illinois | 17133 | 137 | 13 |
313023 | 313023 | 2020-07-08 | Monroe | Illinois | 17133 | 141 | 13 |
316197 | 316197 | 2020-07-09 | Monroe | Illinois | 17133 | 147 | 13 |
319370 | 319370 | 2020-07-10 | Monroe | Illinois | 17133 | 150 | 13 |
322549 | 322549 | 2020-07-11 | Monroe | Illinois | 17133 | 155 | 13 |
325730 | 325730 | 2020-07-12 | Monroe | Illinois | 17133 | 159 | 13 |
328916 | 328916 | 2020-07-13 | Monroe | Illinois | 17133 | 165 | 13 |
332103 | 332103 | 2020-07-14 | Monroe | Illinois | 17133 | 170 | 13 |
335296 | 335296 | 2020-07-15 | Monroe | Illinois | 17133 | 171 | 13 |
338492 | 338492 | 2020-07-16 | Monroe | Illinois | 17133 | 182 | 13 |
341688 | 341688 | 2020-07-17 | Monroe | Illinois | 17133 | 186 | 13 |
344888 | 344888 | 2020-07-18 | Monroe | Illinois | 17133 | 190 | 13 |
348089 | 348089 | 2020-07-19 | Monroe | Illinois | 17133 | 192 | 13 |
351289 | 351289 | 2020-07-20 | Monroe | Illinois | 17133 | 198 | 13 |
354491 | 354491 | 2020-07-21 | Monroe | Illinois | 17133 | 199 | 13 |
357693 | 357693 | 2020-07-22 | Monroe | Illinois | 17133 | 205 | 13 |
360898 | 360898 | 2020-07-23 | Monroe | Illinois | 17133 | 210 | 13 |
364105 | 364105 | 2020-07-24 | Monroe | Illinois | 17133 | 213 | 13 |
367312 | 367312 | 2020-07-25 | Monroe | Illinois | 17133 | 220 | 13 |
370522 | 370522 | 2020-07-26 | Monroe | Illinois | 17133 | 224 | 13 |
373734 | 373734 | 2020-07-27 | Monroe | Illinois | 17133 | 227 | 13 |
376949 | 376949 | 2020-07-28 | Monroe | Illinois | 17133 | 230 | 13 |
380166 | 380166 | 2020-07-29 | Monroe | Illinois | 17133 | 239 | 13 |
383383 | 383383 | 2020-07-30 | Monroe | Illinois | 17133 | 248 | 13 |
386601 | 386601 | 2020-07-31 | Monroe | Illinois | 17133 | 261 | 13 |
389818 | 389818 | 2020-08-01 | Monroe | Illinois | 17133 | 270 | 13 |
393035 | 393035 | 2020-08-02 | Monroe | Illinois | 17133 | 278 | 13 |
396251 | 396251 | 2020-08-03 | Monroe | Illinois | 17133 | 278 | 13 |
399467 | 399467 | 2020-08-04 | Monroe | Illinois | 17133 | 284 | 13 |
402683 | 402683 | 2020-08-05 | Monroe | Illinois | 17133 | 292 | 13 |
405901 | 405901 | 2020-08-06 | Monroe | Illinois | 17133 | 299 | 13 |
409121 | 409121 | 2020-08-07 | Monroe | Illinois | 17133 | 305 | 13 |
412340 | 412340 | 2020-08-08 | Monroe | Illinois | 17133 | 312 | 13 |
415560 | 415560 | 2020-08-09 | Monroe | Illinois | 17133 | 318 | 13 |
418781 | 418781 | 2020-08-10 | Monroe | Illinois | 17133 | 318 | 13 |
422004 | 422004 | 2020-08-11 | Monroe | Illinois | 17133 | 323 | 13 |
425225 | 425225 | 2020-08-12 | Monroe | Illinois | 17133 | 332 | 13 |
428449 | 428449 | 2020-08-13 | Monroe | Illinois | 17133 | 334 | 13 |
431677 | 431677 | 2020-08-14 | Monroe | Illinois | 17133 | 339 | 13 |
434902 | 434902 | 2020-08-15 | Monroe | Illinois | 17133 | 353 | 13 |
438128 | 438128 | 2020-08-16 | Monroe | Illinois | 17133 | 354 | 13 |
441354 | 441354 | 2020-08-17 | Monroe | Illinois | 17133 | 358 | 13 |
444580 | 444580 | 2020-08-18 | Monroe | Illinois | 17133 | 369 | 13 |
447807 | 447807 | 2020-08-19 | Monroe | Illinois | 17133 | 367 | 13 |
451035 | 451035 | 2020-08-20 | Monroe | Illinois | 17133 | 373 | 13 |
454263 | 454263 | 2020-08-21 | Monroe | Illinois | 17133 | 383 | 13 |
457491 | 457491 | 2020-08-22 | Monroe | Illinois | 17133 | 391 | 13 |
460718 | 460718 | 2020-08-23 | Monroe | Illinois | 17133 | 398 | 13 |
463947 | 463947 | 2020-08-24 | Monroe | Illinois | 17133 | 402 | 14 |
467176 | 467176 | 2020-08-25 | Monroe | Illinois | 17133 | 413 | 14 |
470405 | 470405 | 2020-08-26 | Monroe | Illinois | 17133 | 429 | 14 |
473637 | 473637 | 2020-08-27 | Monroe | Illinois | 17133 | 442 | 14 |
476870 | 476870 | 2020-08-28 | Monroe | Illinois | 17133 | 440 | 14 |
480103 | 480103 | 2020-08-29 | Monroe | Illinois | 17133 | 444 | 14 |
483337 | 483337 | 2020-08-30 | Monroe | Illinois | 17133 | 448 | 14 |
486572 | 486572 | 2020-08-31 | Monroe | Illinois | 17133 | 454 | 14 |
489805 | 489805 | 2020-09-01 | Monroe | Illinois | 17133 | 461 | 14 |
493038 | 493038 | 2020-09-02 | Monroe | Illinois | 17133 | 472 | 14 |
496272 | 496272 | 2020-09-03 | Monroe | Illinois | 17133 | 477 | 14 |
499505 | 499505 | 2020-09-04 | Monroe | Illinois | 17133 | 499 | 14 |
502739 | 502739 | 2020-09-05 | Monroe | Illinois | 17133 | 509 | 15 |
505973 | 505973 | 2020-09-06 | Monroe | Illinois | 17133 | 524 | 15 |
509205 | 509205 | 2020-09-07 | Monroe | Illinois | 17133 | 529 | 15 |
512438 | 512438 | 2020-09-08 | Monroe | Illinois | 17133 | 533 | 15 |
515671 | 515671 | 2020-09-09 | Monroe | Illinois | 17133 | 551 | 15 |
518906 | 518906 | 2020-09-10 | Monroe | Illinois | 17133 | 558 | 15 |
522143 | 522143 | 2020-09-11 | Monroe | Illinois | 17133 | 564 | 15 |
525379 | 525379 | 2020-09-12 | Monroe | Illinois | 17133 | 574 | 15 |
528615 | 528615 | 2020-09-13 | Monroe | Illinois | 17133 | 581 | 15 |
531852 | 531852 | 2020-09-14 | Monroe | Illinois | 17133 | 581 | 15 |
535087 | 535087 | 2020-09-15 | Monroe | Illinois | 17133 | 585 | 15 |
538323 | 538323 | 2020-09-16 | Monroe | Illinois | 17133 | 593 | 15 |
541560 | 541560 | 2020-09-17 | Monroe | Illinois | 17133 | 603 | 15 |
544796 | 544796 | 2020-09-18 | Monroe | Illinois | 17133 | 605 | 15 |
548034 | 548034 | 2020-09-19 | Monroe | Illinois | 17133 | 625 | 15 |
551273 | 551273 | 2020-09-20 | Monroe | Illinois | 17133 | 627 | 15 |
554512 | 554512 | 2020-09-21 | Monroe | Illinois | 17133 | 627 | 15 |
557749 | 557749 | 2020-09-22 | Monroe | Illinois | 17133 | 627 | 15 |
560985 | 560985 | 2020-09-23 | Monroe | Illinois | 17133 | 639 | 15 |
564225 | 564225 | 2020-09-24 | Monroe | Illinois | 17133 | 642 | 15 |
567465 | 567465 | 2020-09-25 | Monroe | Illinois | 17133 | 652 | 15 |
570707 | 570707 | 2020-09-26 | Monroe | Illinois | 17133 | 673 | 15 |
573950 | 573950 | 2020-09-27 | Monroe | Illinois | 17133 | 674 | 16 |
577192 | 577192 | 2020-09-28 | Monroe | Illinois | 17133 | 680 | 16 |
580433 | 580433 | 2020-09-29 | Monroe | Illinois | 17133 | 686 | 16 |
583672 | 583672 | 2020-09-30 | Monroe | Illinois | 17133 | 690 | 16 |
586912 | 586912 | 2020-10-01 | Monroe | Illinois | 17133 | 697 | 16 |
590153 | 590153 | 2020-10-02 | Monroe | Illinois | 17133 | 703 | 18 |
593394 | 593394 | 2020-10-03 | Monroe | Illinois | 17133 | 734 | 19 |
596636 | 596636 | 2020-10-04 | Monroe | Illinois | 17133 | 733 | 21 |
599878 | 599878 | 2020-10-05 | Monroe | Illinois | 17133 | 731 | 22 |
603121 | 603121 | 2020-10-06 | Monroe | Illinois | 17133 | 736 | 24 |
606363 | 606363 | 2020-10-07 | Monroe | Illinois | 17133 | 749 | 24 |
609606 | 609606 | 2020-10-08 | Monroe | Illinois | 17133 | 760 | 24 |
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);