ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where county = "Monroe" and fips = 47123 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
286435 | 286435 | 2020-06-29 | Monroe | Tennessee | 47123 | 118 | 4 |
289586 | 289586 | 2020-06-30 | Monroe | Tennessee | 47123 | 132 | 4 |
292738 | 292738 | 2020-07-01 | Monroe | Tennessee | 47123 | 135 | 4 |
295894 | 295894 | 2020-07-02 | Monroe | Tennessee | 47123 | 136 | 5 |
299054 | 299054 | 2020-07-03 | Monroe | Tennessee | 47123 | 137 | 6 |
302218 | 302218 | 2020-07-04 | Monroe | Tennessee | 47123 | 138 | 6 |
305381 | 305381 | 2020-07-05 | Monroe | Tennessee | 47123 | 140 | 6 |
311718 | 311718 | 2020-07-07 | Monroe | Tennessee | 47123 | 140 | 6 |
308549 | 308549 | 2020-07-06 | Monroe | Tennessee | 47123 | 141 | 6 |
314892 | 314892 | 2020-07-08 | Monroe | Tennessee | 47123 | 141 | 6 |
318065 | 318065 | 2020-07-09 | Monroe | Tennessee | 47123 | 146 | 6 |
321243 | 321243 | 2020-07-10 | Monroe | Tennessee | 47123 | 152 | 6 |
324424 | 324424 | 2020-07-11 | Monroe | Tennessee | 47123 | 155 | 6 |
327609 | 327609 | 2020-07-12 | Monroe | Tennessee | 47123 | 155 | 6 |
330795 | 330795 | 2020-07-13 | Monroe | Tennessee | 47123 | 156 | 6 |
333987 | 333987 | 2020-07-14 | Monroe | Tennessee | 47123 | 156 | 6 |
337181 | 337181 | 2020-07-15 | Monroe | Tennessee | 47123 | 162 | 6 |
340378 | 340378 | 2020-07-16 | Monroe | Tennessee | 47123 | 165 | 7 |
343576 | 343576 | 2020-07-17 | Monroe | Tennessee | 47123 | 168 | 7 |
346776 | 346776 | 2020-07-18 | Monroe | Tennessee | 47123 | 176 | 7 |
349976 | 349976 | 2020-07-19 | Monroe | Tennessee | 47123 | 182 | 7 |
353179 | 353179 | 2020-07-20 | Monroe | Tennessee | 47123 | 185 | 7 |
356382 | 356382 | 2020-07-21 | Monroe | Tennessee | 47123 | 213 | 7 |
359586 | 359586 | 2020-07-22 | Monroe | Tennessee | 47123 | 213 | 7 |
362793 | 362793 | 2020-07-23 | Monroe | Tennessee | 47123 | 225 | 7 |
365999 | 365999 | 2020-07-24 | Monroe | Tennessee | 47123 | 239 | 7 |
369208 | 369208 | 2020-07-25 | Monroe | Tennessee | 47123 | 252 | 7 |
372420 | 372420 | 2020-07-26 | Monroe | Tennessee | 47123 | 257 | 7 |
375633 | 375633 | 2020-07-27 | Monroe | Tennessee | 47123 | 271 | 7 |
378849 | 378849 | 2020-07-28 | Monroe | Tennessee | 47123 | 289 | 9 |
382066 | 382066 | 2020-07-29 | Monroe | Tennessee | 47123 | 297 | 9 |
385284 | 385284 | 2020-07-30 | Monroe | Tennessee | 47123 | 305 | 9 |
388501 | 388501 | 2020-07-31 | Monroe | Tennessee | 47123 | 333 | 9 |
391718 | 391718 | 2020-08-01 | Monroe | Tennessee | 47123 | 352 | 9 |
394934 | 394934 | 2020-08-02 | Monroe | Tennessee | 47123 | 356 | 9 |
398151 | 398151 | 2020-08-03 | Monroe | Tennessee | 47123 | 366 | 9 |
401366 | 401366 | 2020-08-04 | Monroe | Tennessee | 47123 | 377 | 9 |
404584 | 404584 | 2020-08-05 | Monroe | Tennessee | 47123 | 380 | 9 |
407804 | 407804 | 2020-08-06 | Monroe | Tennessee | 47123 | 397 | 9 |
411023 | 411023 | 2020-08-07 | Monroe | Tennessee | 47123 | 407 | 9 |
414243 | 414243 | 2020-08-08 | Monroe | Tennessee | 47123 | 418 | 9 |
417464 | 417464 | 2020-08-09 | Monroe | Tennessee | 47123 | 444 | 9 |
423907 | 423907 | 2020-08-11 | Monroe | Tennessee | 47123 | 451 | 9 |
420685 | 420685 | 2020-08-10 | Monroe | Tennessee | 47123 | 452 | 9 |
427130 | 427130 | 2020-08-12 | Monroe | Tennessee | 47123 | 458 | 9 |
430357 | 430357 | 2020-08-13 | Monroe | Tennessee | 47123 | 469 | 10 |
433582 | 433582 | 2020-08-14 | Monroe | Tennessee | 47123 | 479 | 10 |
436809 | 436809 | 2020-08-15 | Monroe | Tennessee | 47123 | 497 | 10 |
440034 | 440034 | 2020-08-16 | Monroe | Tennessee | 47123 | 511 | 10 |
443261 | 443261 | 2020-08-17 | Monroe | Tennessee | 47123 | 524 | 10 |
446487 | 446487 | 2020-08-18 | Monroe | Tennessee | 47123 | 526 | 10 |
449715 | 449715 | 2020-08-19 | Monroe | Tennessee | 47123 | 547 | 10 |
452943 | 452943 | 2020-08-20 | Monroe | Tennessee | 47123 | 562 | 10 |
456171 | 456171 | 2020-08-21 | Monroe | Tennessee | 47123 | 580 | 10 |
459399 | 459399 | 2020-08-22 | Monroe | Tennessee | 47123 | 591 | 10 |
462627 | 462627 | 2020-08-23 | Monroe | Tennessee | 47123 | 601 | 10 |
465856 | 465856 | 2020-08-24 | Monroe | Tennessee | 47123 | 608 | 10 |
469085 | 469085 | 2020-08-25 | Monroe | Tennessee | 47123 | 621 | 12 |
472317 | 472317 | 2020-08-26 | Monroe | Tennessee | 47123 | 654 | 13 |
475550 | 475550 | 2020-08-27 | Monroe | Tennessee | 47123 | 681 | 14 |
478783 | 478783 | 2020-08-28 | Monroe | Tennessee | 47123 | 711 | 14 |
482017 | 482017 | 2020-08-29 | Monroe | Tennessee | 47123 | 726 | 15 |
485252 | 485252 | 2020-08-30 | Monroe | Tennessee | 47123 | 738 | 15 |
488485 | 488485 | 2020-08-31 | Monroe | Tennessee | 47123 | 749 | 15 |
491718 | 491718 | 2020-09-01 | Monroe | Tennessee | 47123 | 759 | 15 |
494952 | 494952 | 2020-09-02 | Monroe | Tennessee | 47123 | 784 | 15 |
498185 | 498185 | 2020-09-03 | Monroe | Tennessee | 47123 | 828 | 15 |
501419 | 501419 | 2020-09-04 | Monroe | Tennessee | 47123 | 848 | 15 |
504653 | 504653 | 2020-09-05 | Monroe | Tennessee | 47123 | 859 | 15 |
507885 | 507885 | 2020-09-06 | Monroe | Tennessee | 47123 | 871 | 15 |
514351 | 514351 | 2020-09-08 | Monroe | Tennessee | 47123 | 874 | 15 |
511118 | 511118 | 2020-09-07 | Monroe | Tennessee | 47123 | 875 | 15 |
517586 | 517586 | 2020-09-09 | Monroe | Tennessee | 47123 | 879 | 16 |
520822 | 520822 | 2020-09-10 | Monroe | Tennessee | 47123 | 903 | 17 |
524058 | 524058 | 2020-09-11 | Monroe | Tennessee | 47123 | 924 | 17 |
527294 | 527294 | 2020-09-12 | Monroe | Tennessee | 47123 | 943 | 17 |
530531 | 530531 | 2020-09-13 | Monroe | Tennessee | 47123 | 944 | 17 |
533766 | 533766 | 2020-09-14 | Monroe | Tennessee | 47123 | 955 | 17 |
537002 | 537002 | 2020-09-15 | Monroe | Tennessee | 47123 | 955 | 16 |
540239 | 540239 | 2020-09-16 | Monroe | Tennessee | 47123 | 962 | 16 |
543475 | 543475 | 2020-09-17 | Monroe | Tennessee | 47123 | 975 | 16 |
546712 | 546712 | 2020-09-18 | Monroe | Tennessee | 47123 | 987 | 16 |
549951 | 549951 | 2020-09-19 | Monroe | Tennessee | 47123 | 994 | 16 |
553190 | 553190 | 2020-09-20 | Monroe | Tennessee | 47123 | 995 | 16 |
556427 | 556427 | 2020-09-21 | Monroe | Tennessee | 47123 | 1001 | 16 |
559664 | 559664 | 2020-09-22 | Monroe | Tennessee | 47123 | 1003 | 16 |
562901 | 562901 | 2020-09-23 | Monroe | Tennessee | 47123 | 1010 | 17 |
566142 | 566142 | 2020-09-24 | Monroe | Tennessee | 47123 | 1022 | 17 |
569383 | 569383 | 2020-09-25 | Monroe | Tennessee | 47123 | 1030 | 18 |
572625 | 572625 | 2020-09-26 | Monroe | Tennessee | 47123 | 1036 | 18 |
575869 | 575869 | 2020-09-27 | Monroe | Tennessee | 47123 | 1052 | 18 |
579110 | 579110 | 2020-09-28 | Monroe | Tennessee | 47123 | 1058 | 18 |
582350 | 582350 | 2020-09-29 | Monroe | Tennessee | 47123 | 1066 | 18 |
585590 | 585590 | 2020-09-30 | Monroe | Tennessee | 47123 | 1083 | 19 |
588830 | 588830 | 2020-10-01 | Monroe | Tennessee | 47123 | 1094 | 20 |
592071 | 592071 | 2020-10-02 | Monroe | Tennessee | 47123 | 1101 | 20 |
595312 | 595312 | 2020-10-03 | Monroe | Tennessee | 47123 | 1110 | 20 |
598555 | 598555 | 2020-10-04 | Monroe | Tennessee | 47123 | 1123 | 20 |
601798 | 601798 | 2020-10-05 | Monroe | Tennessee | 47123 | 1136 | 20 |
605040 | 605040 | 2020-10-06 | Monroe | Tennessee | 47123 | 1146 | 20 |
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);