ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
781 rows where county = "Jackson" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054244 | 1054244 | 2021-02-22 | Jackson | Indiana | 18071 | 4620 | 64 |
1050997 | 1050997 | 2021-02-21 | Jackson | Indiana | 18071 | 4618 | 63 |
1047750 | 1047750 | 2021-02-20 | Jackson | Indiana | 18071 | 4616 | 61 |
1044505 | 1044505 | 2021-02-19 | Jackson | Indiana | 18071 | 4612 | 61 |
1041260 | 1041260 | 2021-02-18 | Jackson | Indiana | 18071 | 4600 | 61 |
1038015 | 1038015 | 2021-02-17 | Jackson | Indiana | 18071 | 4595 | 61 |
1034770 | 1034770 | 2021-02-16 | Jackson | Indiana | 18071 | 4591 | 61 |
1031524 | 1031524 | 2021-02-15 | Jackson | Indiana | 18071 | 4589 | 61 |
1028277 | 1028277 | 2021-02-14 | Jackson | Indiana | 18071 | 4586 | 61 |
1025032 | 1025032 | 2021-02-13 | Jackson | Indiana | 18071 | 4577 | 61 |
1021787 | 1021787 | 2021-02-12 | Jackson | Indiana | 18071 | 4563 | 61 |
1018542 | 1018542 | 2021-02-11 | Jackson | Indiana | 18071 | 4549 | 61 |
1015297 | 1015297 | 2021-02-10 | Jackson | Indiana | 18071 | 4526 | 60 |
1012052 | 1012052 | 2021-02-09 | Jackson | Indiana | 18071 | 4509 | 60 |
1008806 | 1008806 | 2021-02-08 | Jackson | Indiana | 18071 | 4502 | 60 |
1005560 | 1005560 | 2021-02-07 | Jackson | Indiana | 18071 | 4498 | 60 |
1002314 | 1002314 | 2021-02-06 | Jackson | Indiana | 18071 | 4482 | 60 |
999068 | 999068 | 2021-02-05 | Jackson | Indiana | 18071 | 4459 | 60 |
995822 | 995822 | 2021-02-04 | Jackson | Indiana | 18071 | 4441 | 60 |
992576 | 992576 | 2021-02-03 | Jackson | Indiana | 18071 | 4420 | 49 |
989330 | 989330 | 2021-02-02 | Jackson | Indiana | 18071 | 4409 | 49 |
986083 | 986083 | 2021-02-01 | Jackson | Indiana | 18071 | 4399 | 49 |
982836 | 982836 | 2021-01-31 | Jackson | Indiana | 18071 | 4389 | 49 |
979590 | 979590 | 2021-01-30 | Jackson | Indiana | 18071 | 4370 | 49 |
976344 | 976344 | 2021-01-29 | Jackson | Indiana | 18071 | 4352 | 49 |
973099 | 973099 | 2021-01-28 | Jackson | Indiana | 18071 | 4334 | 49 |
969854 | 969854 | 2021-01-27 | Jackson | Indiana | 18071 | 4301 | 49 |
966610 | 966610 | 2021-01-26 | Jackson | Indiana | 18071 | 4291 | 48 |
963365 | 963365 | 2021-01-25 | Jackson | Indiana | 18071 | 4281 | 48 |
960120 | 960120 | 2021-01-24 | Jackson | Indiana | 18071 | 4271 | 48 |
956874 | 956874 | 2021-01-23 | Jackson | Indiana | 18071 | 4254 | 48 |
953629 | 953629 | 2021-01-22 | Jackson | Indiana | 18071 | 4223 | 48 |
950384 | 950384 | 2021-01-21 | Jackson | Indiana | 18071 | 4211 | 48 |
947138 | 947138 | 2021-01-20 | Jackson | Indiana | 18071 | 4195 | 47 |
943891 | 943891 | 2021-01-19 | Jackson | Indiana | 18071 | 4182 | 47 |
940646 | 940646 | 2021-01-18 | Jackson | Indiana | 18071 | 4165 | 46 |
937401 | 937401 | 2021-01-17 | Jackson | Indiana | 18071 | 4151 | 46 |
934156 | 934156 | 2021-01-16 | Jackson | Indiana | 18071 | 4135 | 46 |
930911 | 930911 | 2021-01-15 | Jackson | Indiana | 18071 | 4127 | 46 |
927666 | 927666 | 2021-01-14 | Jackson | Indiana | 18071 | 4105 | 46 |
924420 | 924420 | 2021-01-13 | Jackson | Indiana | 18071 | 4078 | 46 |
921175 | 921175 | 2021-01-12 | Jackson | Indiana | 18071 | 4058 | 46 |
917930 | 917930 | 2021-01-11 | Jackson | Indiana | 18071 | 4046 | 46 |
914685 | 914685 | 2021-01-10 | Jackson | Indiana | 18071 | 4030 | 46 |
911440 | 911440 | 2021-01-09 | Jackson | Indiana | 18071 | 3999 | 46 |
908195 | 908195 | 2021-01-08 | Jackson | Indiana | 18071 | 3966 | 46 |
904949 | 904949 | 2021-01-07 | Jackson | Indiana | 18071 | 3944 | 46 |
901704 | 901704 | 2021-01-06 | Jackson | Indiana | 18071 | 3892 | 45 |
898459 | 898459 | 2021-01-05 | Jackson | Indiana | 18071 | 3868 | 45 |
895214 | 895214 | 2021-01-04 | Jackson | Indiana | 18071 | 3849 | 44 |
891967 | 891967 | 2021-01-03 | Jackson | Indiana | 18071 | 3838 | 44 |
888721 | 888721 | 2021-01-02 | Jackson | Indiana | 18071 | 3817 | 44 |
885475 | 885475 | 2021-01-01 | Jackson | Indiana | 18071 | 3792 | 44 |
882230 | 882230 | 2020-12-31 | Jackson | Indiana | 18071 | 3760 | 44 |
878985 | 878985 | 2020-12-30 | Jackson | Indiana | 18071 | 3712 | 44 |
875740 | 875740 | 2020-12-29 | Jackson | Indiana | 18071 | 3697 | 44 |
872495 | 872495 | 2020-12-28 | Jackson | Indiana | 18071 | 3681 | 43 |
869250 | 869250 | 2020-12-27 | Jackson | Indiana | 18071 | 3669 | 43 |
866005 | 866005 | 2020-12-26 | Jackson | Indiana | 18071 | 3662 | 43 |
862760 | 862760 | 2020-12-25 | Jackson | Indiana | 18071 | 3638 | 43 |
859515 | 859515 | 2020-12-24 | Jackson | Indiana | 18071 | 3605 | 43 |
856270 | 856270 | 2020-12-23 | Jackson | Indiana | 18071 | 3572 | 43 |
853025 | 853025 | 2020-12-22 | Jackson | Indiana | 18071 | 3540 | 42 |
849780 | 849780 | 2020-12-21 | Jackson | Indiana | 18071 | 3509 | 42 |
846535 | 846535 | 2020-12-20 | Jackson | Indiana | 18071 | 3475 | 42 |
843289 | 843289 | 2020-12-19 | Jackson | Indiana | 18071 | 3440 | 42 |
840044 | 840044 | 2020-12-18 | Jackson | Indiana | 18071 | 3417 | 42 |
836799 | 836799 | 2020-12-17 | Jackson | Indiana | 18071 | 3368 | 42 |
833553 | 833553 | 2020-12-16 | Jackson | Indiana | 18071 | 3320 | 42 |
830306 | 830306 | 2020-12-15 | Jackson | Indiana | 18071 | 3281 | 42 |
827060 | 827060 | 2020-12-14 | Jackson | Indiana | 18071 | 3236 | 42 |
823813 | 823813 | 2020-12-13 | Jackson | Indiana | 18071 | 3183 | 42 |
820567 | 820567 | 2020-12-12 | Jackson | Indiana | 18071 | 3158 | 42 |
817321 | 817321 | 2020-12-11 | Jackson | Indiana | 18071 | 3090 | 42 |
814075 | 814075 | 2020-12-10 | Jackson | Indiana | 18071 | 3031 | 42 |
810830 | 810830 | 2020-12-09 | Jackson | Indiana | 18071 | 2985 | 42 |
807585 | 807585 | 2020-12-08 | Jackson | Indiana | 18071 | 2944 | 41 |
804340 | 804340 | 2020-12-07 | Jackson | Indiana | 18071 | 2911 | 39 |
801095 | 801095 | 2020-12-06 | Jackson | Indiana | 18071 | 2834 | 39 |
797850 | 797850 | 2020-12-05 | Jackson | Indiana | 18071 | 2777 | 39 |
794605 | 794605 | 2020-12-04 | Jackson | Indiana | 18071 | 2722 | 39 |
791360 | 791360 | 2020-12-03 | Jackson | Indiana | 18071 | 2670 | 39 |
788115 | 788115 | 2020-12-02 | Jackson | Indiana | 18071 | 2556 | 38 |
784871 | 784871 | 2020-12-01 | Jackson | Indiana | 18071 | 2482 | 35 |
781626 | 781626 | 2020-11-30 | Jackson | Indiana | 18071 | 2424 | 35 |
778380 | 778380 | 2020-11-29 | Jackson | Indiana | 18071 | 2359 | 35 |
775135 | 775135 | 2020-11-28 | Jackson | Indiana | 18071 | 2310 | 35 |
771890 | 771890 | 2020-11-27 | Jackson | Indiana | 18071 | 2267 | 35 |
768645 | 768645 | 2020-11-26 | Jackson | Indiana | 18071 | 2230 | 35 |
765399 | 765399 | 2020-11-25 | Jackson | Indiana | 18071 | 2159 | 35 |
762154 | 762154 | 2020-11-24 | Jackson | Indiana | 18071 | 2130 | 34 |
758909 | 758909 | 2020-11-23 | Jackson | Indiana | 18071 | 2067 | 34 |
755662 | 755662 | 2020-11-22 | Jackson | Indiana | 18071 | 2005 | 34 |
752416 | 752416 | 2020-11-21 | Jackson | Indiana | 18071 | 1957 | 34 |
749170 | 749170 | 2020-11-20 | Jackson | Indiana | 18071 | 1921 | 33 |
745924 | 745924 | 2020-11-19 | Jackson | Indiana | 18071 | 1881 | 33 |
742677 | 742677 | 2020-11-18 | Jackson | Indiana | 18071 | 1827 | 32 |
739430 | 739430 | 2020-11-17 | Jackson | Indiana | 18071 | 1784 | 32 |
736186 | 736186 | 2020-11-16 | Jackson | Indiana | 18071 | 1737 | 30 |
732940 | 732940 | 2020-11-15 | Jackson | Indiana | 18071 | 1704 | 30 |
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);