ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Adams" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054209 | 1054209 | 2021-02-22 | Adams | Indiana | 18001 | 3200 | 50 |
1050962 | 1050962 | 2021-02-21 | Adams | Indiana | 18001 | 3193 | 50 |
1047715 | 1047715 | 2021-02-20 | Adams | Indiana | 18001 | 3189 | 50 |
1044470 | 1044470 | 2021-02-19 | Adams | Indiana | 18001 | 3187 | 50 |
1041225 | 1041225 | 2021-02-18 | Adams | Indiana | 18001 | 3179 | 50 |
1037980 | 1037980 | 2021-02-17 | Adams | Indiana | 18001 | 3177 | 50 |
1034735 | 1034735 | 2021-02-16 | Adams | Indiana | 18001 | 3177 | 50 |
1031489 | 1031489 | 2021-02-15 | Adams | Indiana | 18001 | 3175 | 50 |
1028242 | 1028242 | 2021-02-14 | Adams | Indiana | 18001 | 3173 | 49 |
1024997 | 1024997 | 2021-02-13 | Adams | Indiana | 18001 | 3170 | 49 |
1021752 | 1021752 | 2021-02-12 | Adams | Indiana | 18001 | 3164 | 49 |
1018507 | 1018507 | 2021-02-11 | Adams | Indiana | 18001 | 3157 | 49 |
1015262 | 1015262 | 2021-02-10 | Adams | Indiana | 18001 | 3149 | 49 |
1012017 | 1012017 | 2021-02-09 | Adams | Indiana | 18001 | 3142 | 49 |
1008771 | 1008771 | 2021-02-08 | Adams | Indiana | 18001 | 3141 | 49 |
1005525 | 1005525 | 2021-02-07 | Adams | Indiana | 18001 | 3140 | 49 |
1002279 | 1002279 | 2021-02-06 | Adams | Indiana | 18001 | 3134 | 49 |
999033 | 999033 | 2021-02-05 | Adams | Indiana | 18001 | 3132 | 49 |
995787 | 995787 | 2021-02-04 | Adams | Indiana | 18001 | 3121 | 47 |
992541 | 992541 | 2021-02-03 | Adams | Indiana | 18001 | 3109 | 39 |
989295 | 989295 | 2021-02-02 | Adams | Indiana | 18001 | 3096 | 39 |
986048 | 986048 | 2021-02-01 | Adams | Indiana | 18001 | 3089 | 38 |
982801 | 982801 | 2021-01-31 | Adams | Indiana | 18001 | 3087 | 38 |
979555 | 979555 | 2021-01-30 | Adams | Indiana | 18001 | 3085 | 38 |
976309 | 976309 | 2021-01-29 | Adams | Indiana | 18001 | 3075 | 38 |
973064 | 973064 | 2021-01-28 | Adams | Indiana | 18001 | 3064 | 38 |
969819 | 969819 | 2021-01-27 | Adams | Indiana | 18001 | 3054 | 38 |
966575 | 966575 | 2021-01-26 | Adams | Indiana | 18001 | 3037 | 37 |
963330 | 963330 | 2021-01-25 | Adams | Indiana | 18001 | 3029 | 37 |
960085 | 960085 | 2021-01-24 | Adams | Indiana | 18001 | 3022 | 37 |
956839 | 956839 | 2021-01-23 | Adams | Indiana | 18001 | 3010 | 37 |
953594 | 953594 | 2021-01-22 | Adams | Indiana | 18001 | 2997 | 36 |
950349 | 950349 | 2021-01-21 | Adams | Indiana | 18001 | 2991 | 36 |
947103 | 947103 | 2021-01-20 | Adams | Indiana | 18001 | 2979 | 36 |
943856 | 943856 | 2021-01-19 | Adams | Indiana | 18001 | 2975 | 36 |
940611 | 940611 | 2021-01-18 | Adams | Indiana | 18001 | 2966 | 36 |
937366 | 937366 | 2021-01-17 | Adams | Indiana | 18001 | 2953 | 36 |
934121 | 934121 | 2021-01-16 | Adams | Indiana | 18001 | 2945 | 36 |
930876 | 930876 | 2021-01-15 | Adams | Indiana | 18001 | 2936 | 36 |
927631 | 927631 | 2021-01-14 | Adams | Indiana | 18001 | 2917 | 36 |
924385 | 924385 | 2021-01-13 | Adams | Indiana | 18001 | 2903 | 36 |
921140 | 921140 | 2021-01-12 | Adams | Indiana | 18001 | 2876 | 36 |
917895 | 917895 | 2021-01-11 | Adams | Indiana | 18001 | 2867 | 36 |
914650 | 914650 | 2021-01-10 | Adams | Indiana | 18001 | 2854 | 36 |
911405 | 911405 | 2021-01-09 | Adams | Indiana | 18001 | 2830 | 36 |
908160 | 908160 | 2021-01-08 | Adams | Indiana | 18001 | 2803 | 36 |
904914 | 904914 | 2021-01-07 | Adams | Indiana | 18001 | 2774 | 35 |
901669 | 901669 | 2021-01-06 | Adams | Indiana | 18001 | 2744 | 35 |
898424 | 898424 | 2021-01-05 | Adams | Indiana | 18001 | 2714 | 35 |
895179 | 895179 | 2021-01-04 | Adams | Indiana | 18001 | 2690 | 35 |
891932 | 891932 | 2021-01-03 | Adams | Indiana | 18001 | 2659 | 35 |
888686 | 888686 | 2021-01-02 | Adams | Indiana | 18001 | 2657 | 35 |
885440 | 885440 | 2021-01-01 | Adams | Indiana | 18001 | 2646 | 35 |
882195 | 882195 | 2020-12-31 | Adams | Indiana | 18001 | 2616 | 34 |
878950 | 878950 | 2020-12-30 | Adams | Indiana | 18001 | 2595 | 34 |
875705 | 875705 | 2020-12-29 | Adams | Indiana | 18001 | 2579 | 32 |
872460 | 872460 | 2020-12-28 | Adams | Indiana | 18001 | 2561 | 32 |
869215 | 869215 | 2020-12-27 | Adams | Indiana | 18001 | 2546 | 32 |
865970 | 865970 | 2020-12-26 | Adams | Indiana | 18001 | 2543 | 32 |
862725 | 862725 | 2020-12-25 | Adams | Indiana | 18001 | 2533 | 32 |
859480 | 859480 | 2020-12-24 | Adams | Indiana | 18001 | 2514 | 31 |
856235 | 856235 | 2020-12-23 | Adams | Indiana | 18001 | 2497 | 31 |
852990 | 852990 | 2020-12-22 | Adams | Indiana | 18001 | 2477 | 31 |
849745 | 849745 | 2020-12-21 | Adams | Indiana | 18001 | 2463 | 31 |
846500 | 846500 | 2020-12-20 | Adams | Indiana | 18001 | 2446 | 31 |
843254 | 843254 | 2020-12-19 | Adams | Indiana | 18001 | 2422 | 30 |
840009 | 840009 | 2020-12-18 | Adams | Indiana | 18001 | 2391 | 29 |
836764 | 836764 | 2020-12-17 | Adams | Indiana | 18001 | 2363 | 29 |
833518 | 833518 | 2020-12-16 | Adams | Indiana | 18001 | 2339 | 29 |
830271 | 830271 | 2020-12-15 | Adams | Indiana | 18001 | 2309 | 29 |
827025 | 827025 | 2020-12-14 | Adams | Indiana | 18001 | 2291 | 29 |
823778 | 823778 | 2020-12-13 | Adams | Indiana | 18001 | 2267 | 29 |
820532 | 820532 | 2020-12-12 | Adams | Indiana | 18001 | 2242 | 29 |
817286 | 817286 | 2020-12-11 | Adams | Indiana | 18001 | 2223 | 29 |
814040 | 814040 | 2020-12-10 | Adams | Indiana | 18001 | 2177 | 29 |
810795 | 810795 | 2020-12-09 | Adams | Indiana | 18001 | 2144 | 28 |
807550 | 807550 | 2020-12-08 | Adams | Indiana | 18001 | 2124 | 28 |
804305 | 804305 | 2020-12-07 | Adams | Indiana | 18001 | 2094 | 27 |
801060 | 801060 | 2020-12-06 | Adams | Indiana | 18001 | 2058 | 27 |
797815 | 797815 | 2020-12-05 | Adams | Indiana | 18001 | 2031 | 26 |
794570 | 794570 | 2020-12-04 | Adams | Indiana | 18001 | 1960 | 25 |
791325 | 791325 | 2020-12-03 | Adams | Indiana | 18001 | 1928 | 25 |
788080 | 788080 | 2020-12-02 | Adams | Indiana | 18001 | 1875 | 25 |
784836 | 784836 | 2020-12-01 | Adams | Indiana | 18001 | 1846 | 25 |
781591 | 781591 | 2020-11-30 | Adams | Indiana | 18001 | 1801 | 24 |
778345 | 778345 | 2020-11-29 | Adams | Indiana | 18001 | 1763 | 24 |
775100 | 775100 | 2020-11-28 | Adams | Indiana | 18001 | 1739 | 24 |
771855 | 771855 | 2020-11-27 | Adams | Indiana | 18001 | 1725 | 23 |
768610 | 768610 | 2020-11-26 | Adams | Indiana | 18001 | 1711 | 23 |
765364 | 765364 | 2020-11-25 | Adams | Indiana | 18001 | 1683 | 23 |
762119 | 762119 | 2020-11-24 | Adams | Indiana | 18001 | 1665 | 23 |
758874 | 758874 | 2020-11-23 | Adams | Indiana | 18001 | 1653 | 20 |
755627 | 755627 | 2020-11-22 | Adams | Indiana | 18001 | 1601 | 20 |
752381 | 752381 | 2020-11-21 | Adams | Indiana | 18001 | 1575 | 20 |
749135 | 749135 | 2020-11-20 | Adams | Indiana | 18001 | 1540 | 20 |
745889 | 745889 | 2020-11-19 | Adams | Indiana | 18001 | 1483 | 19 |
742642 | 742642 | 2020-11-18 | Adams | Indiana | 18001 | 1432 | 19 |
739395 | 739395 | 2020-11-17 | Adams | Indiana | 18001 | 1377 | 18 |
736151 | 736151 | 2020-11-16 | Adams | Indiana | 18001 | 1351 | 16 |
732905 | 732905 | 2020-11-15 | Adams | Indiana | 18001 | 1301 | 16 |
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);