ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
130 rows where cases = 8 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 |
---|---|---|---|---|---|---|---|
294135 | 294135 | 2020-07-02 | Pike | Indiana | 18125 | 8 | 0 |
290981 | 290981 | 2020-07-01 | Pike | Indiana | 18125 | 8 | 0 |
167054 | 167054 | 2020-05-22 | Martin | Indiana | 18101 | 8 | 0 |
164021 | 164021 | 2020-05-21 | Martin | Indiana | 18101 | 8 | 0 |
160993 | 160993 | 2020-05-20 | Martin | Indiana | 18101 | 8 | 0 |
157967 | 157967 | 2020-05-19 | Martin | Indiana | 18101 | 8 | 0 |
157999 | 157999 | 2020-05-19 | Vermillion | Indiana | 18165 | 8 | 0 |
154951 | 154951 | 2020-05-18 | Martin | Indiana | 18101 | 8 | 0 |
154983 | 154983 | 2020-05-18 | Vermillion | Indiana | 18165 | 8 | 0 |
151971 | 151971 | 2020-05-17 | Vermillion | Indiana | 18165 | 8 | 0 |
148962 | 148962 | 2020-05-16 | Vermillion | Indiana | 18165 | 8 | 0 |
145958 | 145958 | 2020-05-15 | Vermillion | Indiana | 18165 | 8 | 0 |
142901 | 142901 | 2020-05-14 | Gibson | Indiana | 18051 | 8 | 0 |
142958 | 142958 | 2020-05-14 | Vermillion | Indiana | 18165 | 8 | 0 |
139880 | 139880 | 2020-05-13 | Adams | Indiana | 18001 | 8 | 1 |
139905 | 139905 | 2020-05-13 | Gibson | Indiana | 18051 | 8 | 0 |
139962 | 139962 | 2020-05-13 | Vermillion | Indiana | 18165 | 8 | 0 |
136888 | 136888 | 2020-05-12 | Adams | Indiana | 18001 | 8 | 1 |
136913 | 136913 | 2020-05-12 | Gibson | Indiana | 18051 | 8 | 0 |
136970 | 136970 | 2020-05-12 | Vermillion | Indiana | 18165 | 8 | 0 |
133899 | 133899 | 2020-05-11 | Adams | Indiana | 18001 | 8 | 1 |
133924 | 133924 | 2020-05-11 | Gibson | Indiana | 18051 | 8 | 0 |
133981 | 133981 | 2020-05-11 | Vermillion | Indiana | 18165 | 8 | 0 |
130909 | 130909 | 2020-05-10 | Adams | Indiana | 18001 | 8 | 1 |
130934 | 130934 | 2020-05-10 | Gibson | Indiana | 18051 | 8 | 0 |
130991 | 130991 | 2020-05-10 | Vermillion | Indiana | 18165 | 8 | 0 |
127918 | 127918 | 2020-05-09 | Adams | Indiana | 18001 | 8 | 1 |
128000 | 128000 | 2020-05-09 | Vermillion | Indiana | 18165 | 8 | 0 |
124931 | 124931 | 2020-05-08 | Adams | Indiana | 18001 | 8 | 1 |
125013 | 125013 | 2020-05-08 | Vermillion | Indiana | 18165 | 8 | 0 |
121951 | 121951 | 2020-05-07 | Adams | Indiana | 18001 | 8 | 1 |
122033 | 122033 | 2020-05-07 | Vermillion | Indiana | 18165 | 8 | 0 |
118981 | 118981 | 2020-05-06 | Adams | Indiana | 18001 | 8 | 1 |
119063 | 119063 | 2020-05-06 | Vermillion | Indiana | 18165 | 8 | 0 |
116093 | 116093 | 2020-05-05 | Spencer | Indiana | 18147 | 8 | 1 |
116103 | 116103 | 2020-05-05 | Vermillion | Indiana | 18165 | 8 | 0 |
113138 | 113138 | 2020-05-04 | Adams | Indiana | 18001 | 8 | 1 |
113210 | 113210 | 2020-05-04 | Spencer | Indiana | 18147 | 8 | 1 |
113220 | 113220 | 2020-05-04 | Vermillion | Indiana | 18165 | 8 | 0 |
110263 | 110263 | 2020-05-03 | Adams | Indiana | 18001 | 8 | 1 |
110335 | 110335 | 2020-05-03 | Spencer | Indiana | 18147 | 8 | 1 |
110345 | 110345 | 2020-05-03 | Vermillion | Indiana | 18165 | 8 | 0 |
107393 | 107393 | 2020-05-02 | Adams | Indiana | 18001 | 8 | 1 |
107465 | 107465 | 2020-05-02 | Spencer | Indiana | 18147 | 8 | 1 |
107475 | 107475 | 2020-05-02 | Vermillion | Indiana | 18165 | 8 | 0 |
104531 | 104531 | 2020-05-01 | Benton | Indiana | 18007 | 8 | 0 |
104532 | 104532 | 2020-05-01 | Blackford | Indiana | 18009 | 8 | 1 |
104600 | 104600 | 2020-05-01 | Spencer | Indiana | 18147 | 8 | 0 |
104610 | 104610 | 2020-05-01 | Vermillion | Indiana | 18165 | 8 | 0 |
101675 | 101675 | 2020-04-30 | Benton | Indiana | 18007 | 8 | 0 |
101676 | 101676 | 2020-04-30 | Blackford | Indiana | 18009 | 8 | 1 |
101744 | 101744 | 2020-04-30 | Spencer | Indiana | 18147 | 8 | 0 |
101754 | 101754 | 2020-04-30 | Vermillion | Indiana | 18165 | 8 | 0 |
98824 | 98824 | 2020-04-29 | Benton | Indiana | 18007 | 8 | 0 |
98825 | 98825 | 2020-04-29 | Blackford | Indiana | 18009 | 8 | 1 |
98893 | 98893 | 2020-04-29 | Spencer | Indiana | 18147 | 8 | 0 |
98903 | 98903 | 2020-04-29 | Vermillion | Indiana | 18165 | 8 | 0 |
96049 | 96049 | 2020-04-28 | Spencer | Indiana | 18147 | 8 | 0 |
96057 | 96057 | 2020-04-28 | Union | Indiana | 18161 | 8 | 0 |
96059 | 96059 | 2020-04-28 | Vermillion | Indiana | 18165 | 8 | 0 |
93217 | 93217 | 2020-04-27 | Spencer | Indiana | 18147 | 8 | 0 |
90326 | 90326 | 2020-04-26 | Adams | Indiana | 18001 | 8 | 1 |
90398 | 90398 | 2020-04-26 | Spencer | Indiana | 18147 | 8 | 0 |
87582 | 87582 | 2020-04-25 | Spencer | Indiana | 18147 | 8 | 0 |
84707 | 84707 | 2020-04-24 | Carroll | Indiana | 18015 | 8 | 1 |
84764 | 84764 | 2020-04-24 | Posey | Indiana | 18129 | 8 | 0 |
84772 | 84772 | 2020-04-24 | Spencer | Indiana | 18147 | 8 | 0 |
81922 | 81922 | 2020-04-23 | Fountain | Indiana | 18045 | 8 | 2 |
81964 | 81964 | 2020-04-23 | Posey | Indiana | 18129 | 8 | 0 |
81972 | 81972 | 2020-04-23 | Spencer | Indiana | 18147 | 8 | 0 |
81985 | 81985 | 2020-04-23 | Warren | Indiana | 18171 | 8 | 1 |
79129 | 79129 | 2020-04-22 | Fountain | Indiana | 18045 | 8 | 2 |
79171 | 79171 | 2020-04-22 | Posey | Indiana | 18129 | 8 | 0 |
79179 | 79179 | 2020-04-22 | Spencer | Indiana | 18147 | 8 | 0 |
76330 | 76330 | 2020-04-21 | Carroll | Indiana | 18015 | 8 | 1 |
76345 | 76345 | 2020-04-21 | Fountain | Indiana | 18045 | 8 | 2 |
76384 | 76384 | 2020-04-21 | Perry | Indiana | 18123 | 8 | 0 |
76387 | 76387 | 2020-04-21 | Posey | Indiana | 18129 | 8 | 0 |
76395 | 76395 | 2020-04-21 | Spencer | Indiana | 18147 | 8 | 0 |
76413 | 76413 | 2020-04-21 | White | Indiana | 18181 | 8 | 0 |
73568 | 73568 | 2020-04-20 | Fountain | Indiana | 18045 | 8 | 2 |
73636 | 73636 | 2020-04-20 | White | Indiana | 18181 | 8 | 0 |
70851 | 70851 | 2020-04-19 | Sullivan | Indiana | 18153 | 8 | 0 |
68050 | 68050 | 2020-04-18 | Jay | Indiana | 18075 | 8 | 0 |
65301 | 65301 | 2020-04-17 | Jay | Indiana | 18075 | 8 | 0 |
65324 | 65324 | 2020-04-17 | Parke | Indiana | 18121 | 8 | 0 |
62614 | 62614 | 2020-04-16 | Wabash | Indiana | 18169 | 8 | 0 |
49130 | 49130 | 2020-04-11 | Randolph | Indiana | 18135 | 8 | 1 |
49137 | 49137 | 2020-04-11 | Starke | Indiana | 18149 | 8 | 0 |
46496 | 46496 | 2020-04-10 | Randolph | Indiana | 18135 | 8 | 1 |
46503 | 46503 | 2020-04-10 | Starke | Indiana | 18149 | 8 | 0 |
43839 | 43839 | 2020-04-09 | Daviess | Indiana | 18027 | 8 | 1 |
43915 | 43915 | 2020-04-09 | Whitley | Indiana | 18183 | 8 | 1 |
41339 | 41339 | 2020-04-08 | Whitley | Indiana | 18183 | 8 | 1 |
38710 | 38710 | 2020-04-07 | Brown | Indiana | 18013 | 8 | 1 |
38772 | 38772 | 2020-04-07 | Scott | Indiana | 18143 | 8 | 1 |
38781 | 38781 | 2020-04-07 | Tipton | Indiana | 18159 | 8 | 0 |
38793 | 38793 | 2020-04-07 | Whitley | Indiana | 18183 | 8 | 1 |
36247 | 36247 | 2020-04-06 | Knox | Indiana | 18083 | 8 | 0 |
36255 | 36255 | 2020-04-06 | Marshall | Indiana | 18099 | 8 | 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);