ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
9,366 rows where county = "Johnson" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635357 | 635357 | 2020-10-16 | Johnson | Georgia | 13167 | 479 | 22 |
635527 | 635527 | 2020-10-16 | Johnson | Illinois | 17087 | 298 | 0 |
635627 | 635627 | 2020-10-16 | Johnson | Indiana | 18081 | 2926 | 136 |
635730 | 635730 | 2020-10-16 | Johnson | Iowa | 19103 | 5586 | 30 |
635824 | 635824 | 2020-10-16 | Johnson | Kansas | 20091 | 13410 | 173 |
635942 | 635942 | 2020-10-16 | Johnson | Kentucky | 21115 | 216 | 2 |
636431 | 636431 | 2020-10-16 | Johnson | Missouri | 29101 | 1344 | 10 |
636602 | 636602 | 2020-10-16 | Johnson | Nebraska | 31097 | 89 | 0 |
637455 | 637455 | 2020-10-16 | Johnson | Tennessee | 47091 | 1060 | 6 |
637630 | 637630 | 2020-10-16 | Johnson | Texas | 48251 | 3384 | 60 |
638116 | 638116 | 2020-10-16 | Johnson | Wyoming | 56019 | 65 | 1 |
631784 | 631784 | 2020-10-15 | Johnson | Arkansas | 5071 | 929 | 8 |
632111 | 632111 | 2020-10-15 | Johnson | Georgia | 13167 | 479 | 22 |
632281 | 632281 | 2020-10-15 | Johnson | Illinois | 17087 | 289 | 0 |
632381 | 632381 | 2020-10-15 | Johnson | Indiana | 18081 | 2890 | 136 |
632484 | 632484 | 2020-10-15 | Johnson | Iowa | 19103 | 5565 | 30 |
632578 | 632578 | 2020-10-15 | Johnson | Kansas | 20091 | 13167 | 171 |
632696 | 632696 | 2020-10-15 | Johnson | Kentucky | 21115 | 209 | 2 |
633185 | 633185 | 2020-10-15 | Johnson | Missouri | 29101 | 1335 | 10 |
633356 | 633356 | 2020-10-15 | Johnson | Nebraska | 31097 | 88 | 0 |
634209 | 634209 | 2020-10-15 | Johnson | Tennessee | 47091 | 1060 | 6 |
634385 | 634385 | 2020-10-15 | Johnson | Texas | 48251 | 3364 | 59 |
634871 | 634871 | 2020-10-15 | Johnson | Wyoming | 56019 | 60 | 1 |
628540 | 628540 | 2020-10-14 | Johnson | Arkansas | 5071 | 925 | 9 |
628867 | 628867 | 2020-10-14 | Johnson | Georgia | 13167 | 477 | 22 |
629037 | 629037 | 2020-10-14 | Johnson | Illinois | 17087 | 279 | 0 |
629137 | 629137 | 2020-10-14 | Johnson | Indiana | 18081 | 2861 | 136 |
629240 | 629240 | 2020-10-14 | Johnson | Iowa | 19103 | 5531 | 30 |
629334 | 629334 | 2020-10-14 | Johnson | Kansas | 20091 | 13167 | 171 |
629452 | 629452 | 2020-10-14 | Johnson | Kentucky | 21115 | 206 | 2 |
629940 | 629940 | 2020-10-14 | Johnson | Missouri | 29101 | 1331 | 12 |
630111 | 630111 | 2020-10-14 | Johnson | Nebraska | 31097 | 85 | 0 |
630964 | 630964 | 2020-10-14 | Johnson | Tennessee | 47091 | 1050 | 6 |
631140 | 631140 | 2020-10-14 | Johnson | Texas | 48251 | 3337 | 59 |
631626 | 631626 | 2020-10-14 | Johnson | Wyoming | 56019 | 57 | 1 |
625297 | 625297 | 2020-10-13 | Johnson | Arkansas | 5071 | 917 | 9 |
625624 | 625624 | 2020-10-13 | Johnson | Georgia | 13167 | 476 | 22 |
625794 | 625794 | 2020-10-13 | Johnson | Illinois | 17087 | 265 | 0 |
625894 | 625894 | 2020-10-13 | Johnson | Indiana | 18081 | 2816 | 136 |
625997 | 625997 | 2020-10-13 | Johnson | Iowa | 19103 | 5504 | 30 |
626091 | 626091 | 2020-10-13 | Johnson | Kansas | 20091 | 12932 | 168 |
626208 | 626208 | 2020-10-13 | Johnson | Kentucky | 21115 | 201 | 2 |
626696 | 626696 | 2020-10-13 | Johnson | Missouri | 29101 | 1272 | 10 |
626867 | 626867 | 2020-10-13 | Johnson | Nebraska | 31097 | 84 | 0 |
627720 | 627720 | 2020-10-13 | Johnson | Tennessee | 47091 | 1049 | 5 |
627896 | 627896 | 2020-10-13 | Johnson | Texas | 48251 | 3316 | 58 |
628382 | 628382 | 2020-10-13 | Johnson | Wyoming | 56019 | 55 | 1 |
622054 | 622054 | 2020-10-12 | Johnson | Arkansas | 5071 | 917 | 9 |
622381 | 622381 | 2020-10-12 | Johnson | Georgia | 13167 | 476 | 22 |
622552 | 622552 | 2020-10-12 | Johnson | Illinois | 17087 | 262 | 0 |
622652 | 622652 | 2020-10-12 | Johnson | Indiana | 18081 | 2781 | 136 |
622755 | 622755 | 2020-10-12 | Johnson | Iowa | 19103 | 5487 | 30 |
622849 | 622849 | 2020-10-12 | Johnson | Kansas | 20091 | 12932 | 163 |
622966 | 622966 | 2020-10-12 | Johnson | Kentucky | 21115 | 194 | 2 |
623454 | 623454 | 2020-10-12 | Johnson | Missouri | 29101 | 1272 | 10 |
623625 | 623625 | 2020-10-12 | Johnson | Nebraska | 31097 | 84 | 0 |
624478 | 624478 | 2020-10-12 | Johnson | Tennessee | 47091 | 1047 | 5 |
624654 | 624654 | 2020-10-12 | Johnson | Texas | 48251 | 3277 | 56 |
625139 | 625139 | 2020-10-12 | Johnson | Wyoming | 56019 | 54 | 1 |
618811 | 618811 | 2020-10-11 | Johnson | Arkansas | 5071 | 910 | 8 |
619138 | 619138 | 2020-10-11 | Johnson | Georgia | 13167 | 469 | 22 |
619308 | 619308 | 2020-10-11 | Johnson | Illinois | 17087 | 261 | 0 |
619408 | 619408 | 2020-10-11 | Johnson | Indiana | 18081 | 2747 | 136 |
619511 | 619511 | 2020-10-11 | Johnson | Iowa | 19103 | 5461 | 29 |
619605 | 619605 | 2020-10-11 | Johnson | Kansas | 20091 | 12620 | 163 |
619722 | 619722 | 2020-10-11 | Johnson | Kentucky | 21115 | 192 | 2 |
620211 | 620211 | 2020-10-11 | Johnson | Missouri | 29101 | 1272 | 10 |
620382 | 620382 | 2020-10-11 | Johnson | Nebraska | 31097 | 82 | 0 |
621235 | 621235 | 2020-10-11 | Johnson | Tennessee | 47091 | 1038 | 4 |
621411 | 621411 | 2020-10-11 | Johnson | Texas | 48251 | 3277 | 56 |
621896 | 621896 | 2020-10-11 | Johnson | Wyoming | 56019 | 52 | 1 |
615569 | 615569 | 2020-10-10 | Johnson | Arkansas | 5071 | 909 | 7 |
615896 | 615896 | 2020-10-10 | Johnson | Georgia | 13167 | 465 | 22 |
616066 | 616066 | 2020-10-10 | Johnson | Illinois | 17087 | 255 | 0 |
616166 | 616166 | 2020-10-10 | Johnson | Indiana | 18081 | 2687 | 136 |
616269 | 616269 | 2020-10-10 | Johnson | Iowa | 19103 | 5445 | 29 |
616363 | 616363 | 2020-10-10 | Johnson | Kansas | 20091 | 12620 | 163 |
616480 | 616480 | 2020-10-10 | Johnson | Kentucky | 21115 | 191 | 2 |
616969 | 616969 | 2020-10-10 | Johnson | Missouri | 29101 | 1272 | 10 |
617140 | 617140 | 2020-10-10 | Johnson | Nebraska | 31097 | 81 | 0 |
617992 | 617992 | 2020-10-10 | Johnson | Tennessee | 47091 | 1030 | 4 |
618168 | 618168 | 2020-10-10 | Johnson | Texas | 48251 | 3277 | 56 |
618653 | 618653 | 2020-10-10 | Johnson | Wyoming | 56019 | 47 | 1 |
612328 | 612328 | 2020-10-09 | Johnson | Arkansas | 5071 | 904 | 7 |
612655 | 612655 | 2020-10-09 | Johnson | Georgia | 13167 | 462 | 22 |
612825 | 612825 | 2020-10-09 | Johnson | Illinois | 17087 | 249 | 0 |
612925 | 612925 | 2020-10-09 | Johnson | Indiana | 18081 | 2650 | 135 |
613028 | 613028 | 2020-10-09 | Johnson | Iowa | 19103 | 5415 | 29 |
613122 | 613122 | 2020-10-09 | Johnson | Kansas | 20091 | 12620 | 163 |
613239 | 613239 | 2020-10-09 | Johnson | Kentucky | 21115 | 186 | 2 |
613728 | 613728 | 2020-10-09 | Johnson | Missouri | 29101 | 1051 | 10 |
613899 | 613899 | 2020-10-09 | Johnson | Nebraska | 31097 | 74 | 0 |
614750 | 614750 | 2020-10-09 | Johnson | Tennessee | 47091 | 1019 | 4 |
614926 | 614926 | 2020-10-09 | Johnson | Texas | 48251 | 3272 | 55 |
615411 | 615411 | 2020-10-09 | Johnson | Wyoming | 56019 | 47 | 1 |
609086 | 609086 | 2020-10-08 | Johnson | Arkansas | 5071 | 896 | 7 |
609413 | 609413 | 2020-10-08 | Johnson | Georgia | 13167 | 460 | 22 |
609583 | 609583 | 2020-10-08 | Johnson | Illinois | 17087 | 240 | 0 |
609683 | 609683 | 2020-10-08 | Johnson | Indiana | 18081 | 2612 | 135 |
609786 | 609786 | 2020-10-08 | Johnson | Iowa | 19103 | 5379 | 29 |
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);