ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Johnson" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054249 | 1054249 | 2021-02-22 | Johnson | Indiana | 18081 | 16298 | 365 |
1051002 | 1051002 | 2021-02-21 | Johnson | Indiana | 18081 | 16279 | 362 |
1047755 | 1047755 | 2021-02-20 | Johnson | Indiana | 18081 | 16256 | 360 |
1044510 | 1044510 | 2021-02-19 | Johnson | Indiana | 18081 | 16227 | 360 |
1041265 | 1041265 | 2021-02-18 | Johnson | Indiana | 18081 | 16206 | 358 |
1038020 | 1038020 | 2021-02-17 | Johnson | Indiana | 18081 | 16197 | 358 |
1034775 | 1034775 | 2021-02-16 | Johnson | Indiana | 18081 | 16179 | 358 |
1031529 | 1031529 | 2021-02-15 | Johnson | Indiana | 18081 | 16164 | 356 |
1028282 | 1028282 | 2021-02-14 | Johnson | Indiana | 18081 | 16141 | 356 |
1025037 | 1025037 | 2021-02-13 | Johnson | Indiana | 18081 | 16112 | 356 |
1021792 | 1021792 | 2021-02-12 | Johnson | Indiana | 18081 | 16084 | 356 |
1018547 | 1018547 | 2021-02-11 | Johnson | Indiana | 18081 | 16053 | 355 |
1015302 | 1015302 | 2021-02-10 | Johnson | Indiana | 18081 | 16018 | 352 |
1012057 | 1012057 | 2021-02-09 | Johnson | Indiana | 18081 | 15993 | 352 |
1008811 | 1008811 | 2021-02-08 | Johnson | Indiana | 18081 | 15974 | 350 |
1005565 | 1005565 | 2021-02-07 | Johnson | Indiana | 18081 | 15950 | 349 |
1002319 | 1002319 | 2021-02-06 | Johnson | Indiana | 18081 | 15898 | 345 |
999073 | 999073 | 2021-02-05 | Johnson | Indiana | 18081 | 15835 | 344 |
995827 | 995827 | 2021-02-04 | Johnson | Indiana | 18081 | 15805 | 341 |
992581 | 992581 | 2021-02-03 | Johnson | Indiana | 18081 | 15739 | 312 |
989335 | 989335 | 2021-02-02 | Johnson | Indiana | 18081 | 15696 | 311 |
986088 | 986088 | 2021-02-01 | Johnson | Indiana | 18081 | 15655 | 309 |
982841 | 982841 | 2021-01-31 | Johnson | Indiana | 18081 | 15600 | 309 |
979595 | 979595 | 2021-01-30 | Johnson | Indiana | 18081 | 15570 | 309 |
976349 | 976349 | 2021-01-29 | Johnson | Indiana | 18081 | 15513 | 308 |
973104 | 973104 | 2021-01-28 | Johnson | Indiana | 18081 | 15437 | 307 |
969859 | 969859 | 2021-01-27 | Johnson | Indiana | 18081 | 15342 | 307 |
966615 | 966615 | 2021-01-26 | Johnson | Indiana | 18081 | 15292 | 307 |
963370 | 963370 | 2021-01-25 | Johnson | Indiana | 18081 | 15248 | 306 |
960125 | 960125 | 2021-01-24 | Johnson | Indiana | 18081 | 15197 | 306 |
956879 | 956879 | 2021-01-23 | Johnson | Indiana | 18081 | 15126 | 306 |
953634 | 953634 | 2021-01-22 | Johnson | Indiana | 18081 | 15030 | 304 |
950389 | 950389 | 2021-01-21 | Johnson | Indiana | 18081 | 14928 | 303 |
947143 | 947143 | 2021-01-20 | Johnson | Indiana | 18081 | 14805 | 300 |
943896 | 943896 | 2021-01-19 | Johnson | Indiana | 18081 | 14744 | 300 |
940651 | 940651 | 2021-01-18 | Johnson | Indiana | 18081 | 14640 | 296 |
937406 | 937406 | 2021-01-17 | Johnson | Indiana | 18081 | 14553 | 295 |
934161 | 934161 | 2021-01-16 | Johnson | Indiana | 18081 | 14455 | 295 |
930916 | 930916 | 2021-01-15 | Johnson | Indiana | 18081 | 14330 | 291 |
927671 | 927671 | 2021-01-14 | Johnson | Indiana | 18081 | 14177 | 288 |
924425 | 924425 | 2021-01-13 | Johnson | Indiana | 18081 | 14046 | 287 |
921180 | 921180 | 2021-01-12 | Johnson | Indiana | 18081 | 13969 | 285 |
917935 | 917935 | 2021-01-11 | Johnson | Indiana | 18081 | 13892 | 281 |
914690 | 914690 | 2021-01-10 | Johnson | Indiana | 18081 | 13775 | 280 |
911445 | 911445 | 2021-01-09 | Johnson | Indiana | 18081 | 13650 | 279 |
908200 | 908200 | 2021-01-08 | Johnson | Indiana | 18081 | 13422 | 272 |
904954 | 904954 | 2021-01-07 | Johnson | Indiana | 18081 | 13230 | 266 |
901709 | 901709 | 2021-01-06 | Johnson | Indiana | 18081 | 12973 | 265 |
898464 | 898464 | 2021-01-05 | Johnson | Indiana | 18081 | 12770 | 262 |
895219 | 895219 | 2021-01-04 | Johnson | Indiana | 18081 | 12730 | 257 |
891972 | 891972 | 2021-01-03 | Johnson | Indiana | 18081 | 12596 | 254 |
888726 | 888726 | 2021-01-02 | Johnson | Indiana | 18081 | 12503 | 252 |
885480 | 885480 | 2021-01-01 | Johnson | Indiana | 18081 | 12366 | 252 |
882235 | 882235 | 2020-12-31 | Johnson | Indiana | 18081 | 12155 | 248 |
878990 | 878990 | 2020-12-30 | Johnson | Indiana | 18081 | 11970 | 245 |
875745 | 875745 | 2020-12-29 | Johnson | Indiana | 18081 | 11816 | 241 |
872500 | 872500 | 2020-12-28 | Johnson | Indiana | 18081 | 11695 | 233 |
869255 | 869255 | 2020-12-27 | Johnson | Indiana | 18081 | 11622 | 233 |
866010 | 866010 | 2020-12-26 | Johnson | Indiana | 18081 | 11576 | 228 |
862765 | 862765 | 2020-12-25 | Johnson | Indiana | 18081 | 11462 | 227 |
859520 | 859520 | 2020-12-24 | Johnson | Indiana | 18081 | 11241 | 227 |
856275 | 856275 | 2020-12-23 | Johnson | Indiana | 18081 | 11023 | 226 |
853030 | 853030 | 2020-12-22 | Johnson | Indiana | 18081 | 10860 | 224 |
849785 | 849785 | 2020-12-21 | Johnson | Indiana | 18081 | 10749 | 218 |
846540 | 846540 | 2020-12-20 | Johnson | Indiana | 18081 | 10639 | 216 |
843294 | 843294 | 2020-12-19 | Johnson | Indiana | 18081 | 10481 | 216 |
840049 | 840049 | 2020-12-18 | Johnson | Indiana | 18081 | 10328 | 213 |
836804 | 836804 | 2020-12-17 | Johnson | Indiana | 18081 | 10166 | 212 |
833558 | 833558 | 2020-12-16 | Johnson | Indiana | 18081 | 9976 | 210 |
830311 | 830311 | 2020-12-15 | Johnson | Indiana | 18081 | 9799 | 206 |
827065 | 827065 | 2020-12-14 | Johnson | Indiana | 18081 | 9718 | 204 |
823818 | 823818 | 2020-12-13 | Johnson | Indiana | 18081 | 9560 | 204 |
820572 | 820572 | 2020-12-12 | Johnson | Indiana | 18081 | 9398 | 204 |
817326 | 817326 | 2020-12-11 | Johnson | Indiana | 18081 | 9265 | 201 |
814080 | 814080 | 2020-12-10 | Johnson | Indiana | 18081 | 9048 | 197 |
810835 | 810835 | 2020-12-09 | Johnson | Indiana | 18081 | 8822 | 194 |
807590 | 807590 | 2020-12-08 | Johnson | Indiana | 18081 | 8689 | 194 |
804345 | 804345 | 2020-12-07 | Johnson | Indiana | 18081 | 8530 | 191 |
801100 | 801100 | 2020-12-06 | Johnson | Indiana | 18081 | 8383 | 190 |
797855 | 797855 | 2020-12-05 | Johnson | Indiana | 18081 | 8176 | 188 |
794610 | 794610 | 2020-12-04 | Johnson | Indiana | 18081 | 8018 | 187 |
791365 | 791365 | 2020-12-03 | Johnson | Indiana | 18081 | 7781 | 186 |
788120 | 788120 | 2020-12-02 | Johnson | Indiana | 18081 | 7532 | 186 |
784876 | 784876 | 2020-12-01 | Johnson | Indiana | 18081 | 7315 | 184 |
781631 | 781631 | 2020-11-30 | Johnson | Indiana | 18081 | 7178 | 180 |
778385 | 778385 | 2020-11-29 | Johnson | Indiana | 18081 | 7020 | 179 |
775140 | 775140 | 2020-11-28 | Johnson | Indiana | 18081 | 6914 | 178 |
771895 | 771895 | 2020-11-27 | Johnson | Indiana | 18081 | 6765 | 178 |
768650 | 768650 | 2020-11-26 | Johnson | Indiana | 18081 | 6602 | 178 |
765404 | 765404 | 2020-11-25 | Johnson | Indiana | 18081 | 6434 | 174 |
762159 | 762159 | 2020-11-24 | Johnson | Indiana | 18081 | 6275 | 174 |
758914 | 758914 | 2020-11-23 | Johnson | Indiana | 18081 | 6182 | 173 |
755667 | 755667 | 2020-11-22 | Johnson | Indiana | 18081 | 6014 | 170 |
752421 | 752421 | 2020-11-21 | Johnson | Indiana | 18081 | 5857 | 170 |
749175 | 749175 | 2020-11-20 | Johnson | Indiana | 18081 | 5721 | 169 |
745929 | 745929 | 2020-11-19 | Johnson | Indiana | 18081 | 5571 | 169 |
742682 | 742682 | 2020-11-18 | Johnson | Indiana | 18081 | 5429 | 169 |
739435 | 739435 | 2020-11-17 | Johnson | Indiana | 18081 | 5287 | 169 |
736191 | 736191 | 2020-11-16 | Johnson | Indiana | 18081 | 5157 | 169 |
732945 | 732945 | 2020-11-15 | Johnson | Indiana | 18081 | 5038 | 169 |
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);