ny_times_us_states
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
1,029 rows where state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
state 1
- Indiana · 226 ✖
Link | rowid | date ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|
12570 | 12570 | 2020-10-17 | Indiana | 18 | 148400 | 3918 |
12515 | 12515 | 2020-10-16 | Indiana | 18 | 145915 | 3887 |
12460 | 12460 | 2020-10-15 | Indiana | 18 | 143617 | 3864 |
12405 | 12405 | 2020-10-14 | Indiana | 18 | 141670 | 3836 |
12350 | 12350 | 2020-10-13 | Indiana | 18 | 140505 | 3822 |
12295 | 12295 | 2020-10-12 | Indiana | 18 | 138933 | 3795 |
12240 | 12240 | 2020-10-11 | Indiana | 18 | 137359 | 3789 |
12185 | 12185 | 2020-10-10 | Indiana | 18 | 135789 | 3782 |
12130 | 12130 | 2020-10-09 | Indiana | 18 | 133864 | 3761 |
12075 | 12075 | 2020-10-08 | Indiana | 18 | 132030 | 3742 |
12020 | 12020 | 2020-10-07 | Indiana | 18 | 130569 | 3727 |
11965 | 11965 | 2020-10-06 | Indiana | 18 | 129281 | 3711 |
11910 | 11910 | 2020-10-05 | Indiana | 18 | 128285 | 3681 |
11855 | 11855 | 2020-10-04 | Indiana | 18 | 127501 | 3674 |
11800 | 11800 | 2020-10-03 | Indiana | 18 | 126414 | 3669 |
11745 | 11745 | 2020-10-02 | Indiana | 18 | 124959 | 3656 |
11690 | 11690 | 2020-10-01 | Indiana | 18 | 123459 | 3645 |
11635 | 11635 | 2020-09-30 | Indiana | 18 | 122295 | 3632 |
11580 | 11580 | 2020-09-29 | Indiana | 18 | 121327 | 3612 |
11525 | 11525 | 2020-09-28 | Indiana | 18 | 120581 | 3591 |
11470 | 11470 | 2020-09-27 | Indiana | 18 | 119721 | 3580 |
11415 | 11415 | 2020-09-26 | Indiana | 18 | 118819 | 3577 |
11360 | 11360 | 2020-09-25 | Indiana | 18 | 117656 | 3566 |
11305 | 11305 | 2020-09-24 | Indiana | 18 | 116481 | 3548 |
11250 | 11250 | 2020-09-23 | Indiana | 18 | 115578 | 3530 |
11195 | 11195 | 2020-09-22 | Indiana | 18 | 114864 | 3520 |
11140 | 11140 | 2020-09-21 | Indiana | 18 | 114251 | 3512 |
11085 | 11085 | 2020-09-20 | Indiana | 18 | 113728 | 3506 |
11030 | 11030 | 2020-09-19 | Indiana | 18 | 112982 | 3503 |
10975 | 10975 | 2020-09-18 | Indiana | 18 | 111900 | 3495 |
10920 | 10920 | 2020-09-17 | Indiana | 18 | 110863 | 3478 |
10865 | 10865 | 2020-09-16 | Indiana | 18 | 110025 | 3472 |
10810 | 10810 | 2020-09-15 | Indiana | 18 | 109445 | 3460 |
10755 | 10755 | 2020-09-14 | Indiana | 18 | 108755 | 3439 |
10700 | 10700 | 2020-09-13 | Indiana | 18 | 108020 | 3438 |
10645 | 10645 | 2020-09-12 | Indiana | 18 | 106777 | 3437 |
10590 | 10590 | 2020-09-11 | Indiana | 18 | 105703 | 3420 |
10535 | 10535 | 2020-09-10 | Indiana | 18 | 104429 | 3410 |
10480 | 10480 | 2020-09-09 | Indiana | 18 | 103641 | 3397 |
10425 | 10425 | 2020-09-08 | Indiana | 18 | 102917 | 3380 |
10370 | 10370 | 2020-09-07 | Indiana | 18 | 102527 | 3368 |
10315 | 10315 | 2020-09-06 | Indiana | 18 | 101937 | 3364 |
10260 | 10260 | 2020-09-05 | Indiana | 18 | 101094 | 3362 |
10205 | 10205 | 2020-09-04 | Indiana | 18 | 100011 | 3350 |
10150 | 10150 | 2020-09-03 | Indiana | 18 | 98971 | 3332 |
10095 | 10095 | 2020-09-02 | Indiana | 18 | 97853 | 3325 |
10040 | 10040 | 2020-09-01 | Indiana | 18 | 96988 | 3312 |
9985 | 9985 | 2020-08-31 | Indiana | 18 | 96277 | 3296 |
9930 | 9930 | 2020-08-30 | Indiana | 18 | 95394 | 3291 |
9875 | 9875 | 2020-08-29 | Indiana | 18 | 94512 | 3285 |
9820 | 9820 | 2020-08-28 | Indiana | 18 | 93387 | 3277 |
9765 | 9765 | 2020-08-27 | Indiana | 18 | 92566 | 3266 |
9710 | 9710 | 2020-08-26 | Indiana | 18 | 91403 | 3259 |
9655 | 9655 | 2020-08-25 | Indiana | 18 | 90460 | 3241 |
9600 | 9600 | 2020-08-24 | Indiana | 18 | 89602 | 3225 |
9545 | 9545 | 2020-08-23 | Indiana | 18 | 87942 | 3220 |
9490 | 9490 | 2020-08-22 | Indiana | 18 | 87325 | 3218 |
9435 | 9435 | 2020-08-21 | Indiana | 18 | 86312 | 3208 |
9380 | 9380 | 2020-08-20 | Indiana | 18 | 85257 | 3191 |
9325 | 9325 | 2020-08-19 | Indiana | 18 | 84308 | 3180 |
9270 | 9270 | 2020-08-18 | Indiana | 18 | 83799 | 3165 |
9215 | 9215 | 2020-08-17 | Indiana | 18 | 82909 | 3135 |
9160 | 9160 | 2020-08-16 | Indiana | 18 | 82304 | 3133 |
9105 | 9105 | 2020-08-15 | Indiana | 18 | 81561 | 3128 |
9050 | 9050 | 2020-08-14 | Indiana | 18 | 80507 | 3113 |
8995 | 8995 | 2020-08-13 | Indiana | 18 | 79404 | 3105 |
8940 | 8940 | 2020-08-12 | Indiana | 18 | 78337 | 3086 |
8885 | 8885 | 2020-08-11 | Indiana | 18 | 77625 | 3069 |
8830 | 8830 | 2020-08-10 | Indiana | 18 | 76734 | 3044 |
8775 | 8775 | 2020-08-09 | Indiana | 18 | 76071 | 3041 |
8720 | 8720 | 2020-08-08 | Indiana | 18 | 75025 | 3036 |
8665 | 8665 | 2020-08-07 | Indiana | 18 | 73986 | 3023 |
8610 | 8610 | 2020-08-06 | Indiana | 18 | 72741 | 3013 |
8555 | 8555 | 2020-08-05 | Indiana | 18 | 71685 | 3007 |
8500 | 8500 | 2020-08-04 | Indiana | 18 | 70944 | 2996 |
8445 | 8445 | 2020-08-03 | Indiana | 18 | 70111 | 2980 |
8390 | 8390 | 2020-08-02 | Indiana | 18 | 69531 | 2975 |
8335 | 8335 | 2020-08-01 | Indiana | 18 | 68773 | 2971 |
8280 | 8280 | 2020-07-31 | Indiana | 18 | 67800 | 2965 |
8225 | 8225 | 2020-07-30 | Indiana | 18 | 66883 | 2946 |
8170 | 8170 | 2020-07-29 | Indiana | 18 | 65918 | 2932 |
8115 | 8115 | 2020-07-28 | Indiana | 18 | 65258 | 2924 |
8060 | 8060 | 2020-07-27 | Indiana | 18 | 64417 | 2906 |
8005 | 8005 | 2020-07-26 | Indiana | 18 | 63881 | 2903 |
7950 | 7950 | 2020-07-25 | Indiana | 18 | 63030 | 2895 |
7895 | 7895 | 2020-07-24 | Indiana | 18 | 62081 | 2884 |
7840 | 7840 | 2020-07-23 | Indiana | 18 | 61079 | 2880 |
7785 | 7785 | 2020-07-22 | Indiana | 18 | 60126 | 2863 |
7730 | 7730 | 2020-07-21 | Indiana | 18 | 59344 | 2846 |
7675 | 7675 | 2020-07-20 | Indiana | 18 | 58607 | 2825 |
7620 | 7620 | 2020-07-19 | Indiana | 18 | 57965 | 2822 |
7565 | 7565 | 2020-07-18 | Indiana | 18 | 57045 | 2820 |
7510 | 7510 | 2020-07-17 | Indiana | 18 | 56160 | 2803 |
7455 | 7455 | 2020-07-16 | Indiana | 18 | 55413 | 2795 |
7400 | 7400 | 2020-07-15 | Indiana | 18 | 54698 | 2785 |
7345 | 7345 | 2020-07-14 | Indiana | 18 | 54001 | 2775 |
7290 | 7290 | 2020-07-13 | Indiana | 18 | 53327 | 2762 |
7235 | 7235 | 2020-07-12 | Indiana | 18 | 52892 | 2760 |
7180 | 7180 | 2020-07-11 | Indiana | 18 | 52358 | 2756 |
7125 | 7125 | 2020-07-10 | Indiana | 18 | 51567 | 2748 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [ny_times_us_states] ( [date] TEXT, [state] TEXT, [fips] INTEGER, [cases] INTEGER, [deaths] INTEGER );