ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
180 rows where cases = 3 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
145938 | 145938 | 2020-05-15 | Pike | Indiana | 18125 | 3 | 0 |
142938 | 142938 | 2020-05-14 | Pike | Indiana | 18125 | 3 | 0 |
139942 | 139942 | 2020-05-13 | Pike | Indiana | 18125 | 3 | 0 |
136950 | 136950 | 2020-05-12 | Pike | Indiana | 18125 | 3 | 0 |
133961 | 133961 | 2020-05-11 | Pike | Indiana | 18125 | 3 | 0 |
130971 | 130971 | 2020-05-10 | Pike | Indiana | 18125 | 3 | 0 |
93202 | 93202 | 2020-04-27 | Ohio | Indiana | 18115 | 3 | 0 |
90383 | 90383 | 2020-04-26 | Ohio | Indiana | 18115 | 3 | 0 |
87567 | 87567 | 2020-04-25 | Ohio | Indiana | 18115 | 3 | 0 |
84757 | 84757 | 2020-04-24 | Ohio | Indiana | 18115 | 3 | 0 |
81957 | 81957 | 2020-04-23 | Ohio | Indiana | 18115 | 3 | 0 |
62554 | 62554 | 2020-04-16 | Fulton | Indiana | 18049 | 3 | 0 |
59812 | 59812 | 2020-04-15 | Benton | Indiana | 18007 | 3 | 0 |
59831 | 59831 | 2020-04-15 | Fountain | Indiana | 18045 | 3 | 1 |
59833 | 59833 | 2020-04-15 | Fulton | Indiana | 18049 | 3 | 0 |
59894 | 59894 | 2020-04-15 | Warren | Indiana | 18171 | 3 | 1 |
57123 | 57123 | 2020-04-14 | Fountain | Indiana | 18045 | 3 | 1 |
57125 | 57125 | 2020-04-14 | Fulton | Indiana | 18049 | 3 | 0 |
57162 | 57162 | 2020-04-14 | Perry | Indiana | 18123 | 3 | 0 |
57173 | 57173 | 2020-04-14 | Spencer | Indiana | 18147 | 3 | 0 |
57183 | 57183 | 2020-04-14 | Vermillion | Indiana | 18165 | 3 | 0 |
57186 | 57186 | 2020-04-14 | Warren | Indiana | 18171 | 3 | 1 |
54430 | 54430 | 2020-04-13 | Fountain | Indiana | 18045 | 3 | 1 |
54432 | 54432 | 2020-04-13 | Fulton | Indiana | 18049 | 3 | 0 |
54469 | 54469 | 2020-04-13 | Perry | Indiana | 18123 | 3 | 0 |
54480 | 54480 | 2020-04-13 | Spencer | Indiana | 18147 | 3 | 0 |
54490 | 54490 | 2020-04-13 | Vermillion | Indiana | 18165 | 3 | 0 |
54493 | 54493 | 2020-04-13 | Warren | Indiana | 18171 | 3 | 1 |
51749 | 51749 | 2020-04-12 | Fountain | Indiana | 18045 | 3 | 1 |
51751 | 51751 | 2020-04-12 | Fulton | Indiana | 18049 | 3 | 0 |
51788 | 51788 | 2020-04-12 | Perry | Indiana | 18123 | 3 | 0 |
51799 | 51799 | 2020-04-12 | Spencer | Indiana | 18147 | 3 | 0 |
51809 | 51809 | 2020-04-12 | Vermillion | Indiana | 18165 | 3 | 0 |
51812 | 51812 | 2020-04-12 | Warren | Indiana | 18171 | 3 | 1 |
51817 | 51817 | 2020-04-12 | White | Indiana | 18181 | 3 | 0 |
49086 | 49086 | 2020-04-11 | Fountain | Indiana | 18045 | 3 | 1 |
49088 | 49088 | 2020-04-11 | Fulton | Indiana | 18049 | 3 | 0 |
49125 | 49125 | 2020-04-11 | Perry | Indiana | 18123 | 3 | 0 |
49145 | 49145 | 2020-04-11 | Vermillion | Indiana | 18165 | 3 | 0 |
49152 | 49152 | 2020-04-11 | Wells | Indiana | 18179 | 3 | 0 |
49153 | 49153 | 2020-04-11 | White | Indiana | 18181 | 3 | 0 |
46452 | 46452 | 2020-04-10 | Fountain | Indiana | 18045 | 3 | 1 |
46454 | 46454 | 2020-04-10 | Fulton | Indiana | 18049 | 3 | 0 |
46491 | 46491 | 2020-04-10 | Perry | Indiana | 18123 | 3 | 0 |
46511 | 46511 | 2020-04-10 | Vermillion | Indiana | 18165 | 3 | 0 |
46518 | 46518 | 2020-04-10 | Wells | Indiana | 18179 | 3 | 0 |
46519 | 46519 | 2020-04-10 | White | Indiana | 18181 | 3 | 0 |
43833 | 43833 | 2020-04-09 | Carroll | Indiana | 18015 | 3 | 0 |
43850 | 43850 | 2020-04-09 | Fulton | Indiana | 18049 | 3 | 0 |
43906 | 43906 | 2020-04-09 | Vermillion | Indiana | 18165 | 3 | 0 |
43913 | 43913 | 2020-04-09 | Wells | Indiana | 18179 | 3 | 0 |
43914 | 43914 | 2020-04-09 | White | Indiana | 18181 | 3 | 0 |
41257 | 41257 | 2020-04-08 | Carroll | Indiana | 18015 | 3 | 0 |
41274 | 41274 | 2020-04-08 | Fulton | Indiana | 18049 | 3 | 0 |
41287 | 41287 | 2020-04-08 | Jay | Indiana | 18075 | 3 | 0 |
41338 | 41338 | 2020-04-08 | White | Indiana | 18181 | 3 | 0 |
38711 | 38711 | 2020-04-07 | Carroll | Indiana | 18015 | 3 | 0 |
38728 | 38728 | 2020-04-07 | Fulton | Indiana | 18049 | 3 | 0 |
38741 | 38741 | 2020-04-07 | Jay | Indiana | 18075 | 3 | 0 |
38778 | 38778 | 2020-04-07 | Sullivan | Indiana | 18153 | 3 | 0 |
38782 | 38782 | 2020-04-07 | Union | Indiana | 18161 | 3 | 0 |
38792 | 38792 | 2020-04-07 | White | Indiana | 18181 | 3 | 0 |
36213 | 36213 | 2020-04-06 | Carroll | Indiana | 18015 | 3 | 0 |
36230 | 36230 | 2020-04-06 | Fulton | Indiana | 18049 | 3 | 0 |
36243 | 36243 | 2020-04-06 | Jay | Indiana | 18075 | 3 | 0 |
36280 | 36280 | 2020-04-06 | Sullivan | Indiana | 18153 | 3 | 0 |
36284 | 36284 | 2020-04-06 | Union | Indiana | 18161 | 3 | 0 |
36288 | 36288 | 2020-04-06 | Wabash | Indiana | 18169 | 3 | 0 |
36294 | 36294 | 2020-04-06 | White | Indiana | 18181 | 3 | 0 |
33757 | 33757 | 2020-04-05 | Blackford | Indiana | 18009 | 3 | 0 |
33760 | 33760 | 2020-04-05 | Carroll | Indiana | 18015 | 3 | 0 |
33790 | 33790 | 2020-04-05 | Jay | Indiana | 18075 | 3 | 0 |
33824 | 33824 | 2020-04-05 | Starke | Indiana | 18149 | 3 | 0 |
33826 | 33826 | 2020-04-05 | Sullivan | Indiana | 18153 | 3 | 0 |
33830 | 33830 | 2020-04-05 | Union | Indiana | 18161 | 3 | 0 |
33841 | 33841 | 2020-04-05 | White | Indiana | 18181 | 3 | 0 |
31350 | 31350 | 2020-04-04 | Carroll | Indiana | 18015 | 3 | 0 |
31353 | 31353 | 2020-04-04 | Clay | Indiana | 18021 | 3 | 0 |
31354 | 31354 | 2020-04-04 | Clinton | Indiana | 18023 | 3 | 0 |
31356 | 31356 | 2020-04-04 | DeKalb | Indiana | 18033 | 3 | 0 |
31415 | 31415 | 2020-04-04 | Sullivan | Indiana | 18153 | 3 | 0 |
31430 | 31430 | 2020-04-04 | White | Indiana | 18181 | 3 | 0 |
28983 | 28983 | 2020-04-03 | Brown | Indiana | 18013 | 3 | 0 |
28988 | 28988 | 2020-04-03 | Clinton | Indiana | 18023 | 3 | 0 |
28989 | 28989 | 2020-04-03 | Crawford | Indiana | 18025 | 3 | 0 |
28990 | 28990 | 2020-04-03 | DeKalb | Indiana | 18033 | 3 | 0 |
28994 | 28994 | 2020-04-03 | Dubois | Indiana | 18037 | 3 | 0 |
29010 | 29010 | 2020-04-03 | Huntington | Indiana | 18069 | 3 | 1 |
29048 | 29048 | 2020-04-03 | Sullivan | Indiana | 18153 | 3 | 0 |
29062 | 29062 | 2020-04-03 | White | Indiana | 18181 | 3 | 0 |
26673 | 26673 | 2020-04-02 | Brown | Indiana | 18013 | 3 | 0 |
26684 | 26684 | 2020-04-02 | Dubois | Indiana | 18037 | 3 | 0 |
26700 | 26700 | 2020-04-02 | Huntington | Indiana | 18069 | 3 | 1 |
26704 | 26704 | 2020-04-02 | Jefferson | Indiana | 18077 | 3 | 0 |
26721 | 26721 | 2020-04-02 | Noble | Indiana | 18113 | 3 | 0 |
26723 | 26723 | 2020-04-02 | Orange | Indiana | 18117 | 3 | 0 |
26728 | 26728 | 2020-04-02 | Randolph | Indiana | 18135 | 3 | 0 |
26737 | 26737 | 2020-04-02 | Sullivan | Indiana | 18153 | 3 | 0 |
26749 | 26749 | 2020-04-02 | Wayne | Indiana | 18177 | 3 | 0 |
26751 | 26751 | 2020-04-02 | White | Indiana | 18181 | 3 | 0 |
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);