ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

92 rows where date = "2021-05-28" and state = "Indiana" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Indiana · 92 ✖
Link rowid date ▲ county state fips cases deaths
1362660 1362660 2021-05-28 Adams Indiana 18001 3503 56
1362661 1362661 2021-05-28 Allen Indiana 18003 41413 706
1362662 1362662 2021-05-28 Bartholomew Indiana 18005 8147 161
1362663 1362663 2021-05-28 Benton Indiana 18007 993 14
1362664 1362664 2021-05-28 Blackford Indiana 18009 1365 32
1362665 1362665 2021-05-28 Boone Indiana 18011 6851 106
1362666 1362666 2021-05-28 Brown Indiana 18013 1032 41
1362667 1362667 2021-05-28 Carroll Indiana 18015 1923 22
1362668 1362668 2021-05-28 Cass Indiana 18017 5954 109
1362669 1362669 2021-05-28 Clark Indiana 18019 13131 201
1362670 1362670 2021-05-28 Clay Indiana 18021 2628 47
1362671 1362671 2021-05-28 Clinton Indiana 18023 4341 58
1362672 1362672 2021-05-28 Crawford Indiana 18025 1018 17
1362673 1362673 2021-05-28 Daviess Indiana 18027 3003 101
1362674 1362674 2021-05-28 DeKalb Indiana 18033 4362 88
1362675 1362675 2021-05-28 Dearborn Indiana 18029 5873 81
1362676 1362676 2021-05-28 Decatur Indiana 18031 2938 96
1362677 1362677 2021-05-28 Delaware Indiana 18035 10887 196
1362678 1362678 2021-05-28 Dubois Indiana 18037 6188 118
1362679 1362679 2021-05-28 Elkhart Indiana 18039 29252 465
1362680 1362680 2021-05-28 Fayette Indiana 18041 2974 65
1362681 1362681 2021-05-28 Floyd Indiana 18043 7726 184
1362682 1362682 2021-05-28 Fountain Indiana 18045 2161 48
1362683 1362683 2021-05-28 Franklin Indiana 18047 1715 36
1362684 1362684 2021-05-28 Fulton Indiana 18049 1981 41
1362685 1362685 2021-05-28 Gibson Indiana 18051 4425 95
1362686 1362686 2021-05-28 Grant Indiana 18053 7584 182
1362687 1362687 2021-05-28 Greene Indiana 18055 2845 89
1362688 1362688 2021-05-28 Hamilton Indiana 18057 36176 429
1362689 1362689 2021-05-28 Hancock Indiana 18059 8470 146
1362690 1362690 2021-05-28 Harrison Indiana 18061 4386 75
1362691 1362691 2021-05-28 Hendricks Indiana 18063 17532 337
1362692 1362692 2021-05-28 Henry Indiana 18065 5866 108
1362693 1362693 2021-05-28 Howard Indiana 18067 10163 227
1362694 1362694 2021-05-28 Huntington Indiana 18069 4000 82
1362695 1362695 2021-05-28 Jackson Indiana 18071 5067 75
1362696 1362696 2021-05-28 Jasper Indiana 18073 3806 54
1362697 1362697 2021-05-28 Jay Indiana 18075 2004 34
1362698 1362698 2021-05-28 Jefferson Indiana 18077 3333 83
1362699 1362699 2021-05-28 Jennings Indiana 18079 2334 51
1362700 1362700 2021-05-28 Johnson Indiana 18081 18273 398
1362701 1362701 2021-05-28 Knox Indiana 18083 3748 90
1362702 1362702 2021-05-28 Kosciusko Indiana 18085 9579 121
1362703 1362703 2021-05-28 LaGrange Indiana 18087 2720 73
1362704 1362704 2021-05-28 LaPorte Indiana 18091 12282 221
1362705 1362705 2021-05-28 Lake Indiana 18089 54985 1034
1362706 1362706 2021-05-28 Lawrence Indiana 18093 4670 124
1362707 1362707 2021-05-28 Madison Indiana 18095 12909 361
1362708 1362708 2021-05-28 Marion Indiana 18097 101967 1827
1362709 1362709 2021-05-28 Marshall Indiana 18099 6184 116
1362710 1362710 2021-05-28 Martin Indiana 18101 909 15
1362711 1362711 2021-05-28 Miami Indiana 18103 3887 69
1362712 1362712 2021-05-28 Monroe Indiana 18105 12051 174
1362713 1362713 2021-05-28 Montgomery Indiana 18107 4286 91
1362714 1362714 2021-05-28 Morgan Indiana 18109 6690 145
1362715 1362715 2021-05-28 Newton Indiana 18111 1110 37
1362716 1362716 2021-05-28 Noble Indiana 18113 5744 88
1362717 1362717 2021-05-28 Ohio Indiana 18115 577 11
1362718 1362718 2021-05-28 Orange Indiana 18117 1877 57
1362719 1362719 2021-05-28 Owen Indiana 18119 2082 58
1362720 1362720 2021-05-28 Parke Indiana 18121 1490 16
1362721 1362721 2021-05-28 Perry Indiana 18123 1869 38
1362722 1362722 2021-05-28 Pike Indiana 18125 1366 34
1362723 1362723 2021-05-28 Porter Indiana 18127 19194 332
1362724 1362724 2021-05-28 Posey Indiana 18129 2726 34
1362725 1362725 2021-05-28 Pulaski Indiana 18131 1189 46
1362726 1362726 2021-05-28 Putnam Indiana 18133 3693 60
1362727 1362727 2021-05-28 Randolph Indiana 18135 2477 83
1362728 1362728 2021-05-28 Ripley Indiana 18137 3439 70
1362729 1362729 2021-05-28 Rush Indiana 18139 1818 25
1362730 1362730 2021-05-28 Scott Indiana 18143 2691 57
1362731 1362731 2021-05-28 Shelby Indiana 18145 5967 106
1362732 1362732 2021-05-28 Spencer Indiana 18147 2337 31
1362733 1362733 2021-05-28 St. Joseph Indiana 18141 36743 576
1362734 1362734 2021-05-28 Starke Indiana 18149 2253 57
1362735 1362735 2021-05-28 Steuben Indiana 18151 3952 60
1362736 1362736 2021-05-28 Sullivan Indiana 18153 2130 42
1362737 1362737 2021-05-28 Switzerland Indiana 18155 802 8
1362738 1362738 2021-05-28 Tippecanoe Indiana 18157 22672 225
1362739 1362739 2021-05-28 Tipton Indiana 18159 1652 47
1362740 1362740 2021-05-28 Union Indiana 18161 754 11
1362741 1362741 2021-05-28 Vanderburgh Indiana 18163 22473 403
1362742 1362742 2021-05-28 Vermillion Indiana 18165 1715 44
1362743 1362743 2021-05-28 Vigo Indiana 18167 12554 256
1362744 1362744 2021-05-28 Wabash Indiana 18169 3589 81
1362745 1362745 2021-05-28 Warren Indiana 18171 831 16
1362746 1362746 2021-05-28 Warrick Indiana 18173 7827 158
1362747 1362747 2021-05-28 Washington Indiana 18175 2435 33
1362748 1362748 2021-05-28 Wayne Indiana 18177 7502 204
1362749 1362749 2021-05-28 Wells Indiana 18179 2964 83
1362750 1362750 2021-05-28 White Indiana 18181 3235 54
1362751 1362751 2021-05-28 Whitley Indiana 18183 4027 40

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);