ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
776 rows where county = "Greene" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386665 | 386665 | 2020-07-31 | Greene | Indiana | 18055 | 238 | 37 |
383447 | 383447 | 2020-07-30 | Greene | Indiana | 18055 | 236 | 37 |
380230 | 380230 | 2020-07-29 | Greene | Indiana | 18055 | 234 | 37 |
377013 | 377013 | 2020-07-28 | Greene | Indiana | 18055 | 230 | 37 |
373798 | 373798 | 2020-07-27 | Greene | Indiana | 18055 | 227 | 37 |
370586 | 370586 | 2020-07-26 | Greene | Indiana | 18055 | 227 | 37 |
367376 | 367376 | 2020-07-25 | Greene | Indiana | 18055 | 226 | 37 |
364169 | 364169 | 2020-07-24 | Greene | Indiana | 18055 | 224 | 37 |
360962 | 360962 | 2020-07-23 | Greene | Indiana | 18055 | 223 | 37 |
357757 | 357757 | 2020-07-22 | Greene | Indiana | 18055 | 215 | 36 |
354555 | 354555 | 2020-07-21 | Greene | Indiana | 18055 | 213 | 36 |
351353 | 351353 | 2020-07-20 | Greene | Indiana | 18055 | 212 | 36 |
348153 | 348153 | 2020-07-19 | Greene | Indiana | 18055 | 212 | 36 |
344952 | 344952 | 2020-07-18 | Greene | Indiana | 18055 | 211 | 36 |
341752 | 341752 | 2020-07-17 | Greene | Indiana | 18055 | 209 | 36 |
338556 | 338556 | 2020-07-16 | Greene | Indiana | 18055 | 207 | 36 |
335360 | 335360 | 2020-07-15 | Greene | Indiana | 18055 | 205 | 36 |
332167 | 332167 | 2020-07-14 | Greene | Indiana | 18055 | 205 | 35 |
328980 | 328980 | 2020-07-13 | Greene | Indiana | 18055 | 204 | 35 |
325794 | 325794 | 2020-07-12 | Greene | Indiana | 18055 | 201 | 35 |
322613 | 322613 | 2020-07-11 | Greene | Indiana | 18055 | 199 | 35 |
319434 | 319434 | 2020-07-10 | Greene | Indiana | 18055 | 198 | 35 |
316261 | 316261 | 2020-07-09 | Greene | Indiana | 18055 | 196 | 35 |
313087 | 313087 | 2020-07-08 | Greene | Indiana | 18055 | 195 | 35 |
309917 | 309917 | 2020-07-07 | Greene | Indiana | 18055 | 195 | 35 |
306749 | 306749 | 2020-07-06 | Greene | Indiana | 18055 | 194 | 35 |
303584 | 303584 | 2020-07-05 | Greene | Indiana | 18055 | 193 | 35 |
300420 | 300420 | 2020-07-04 | Greene | Indiana | 18055 | 190 | 35 |
297258 | 297258 | 2020-07-03 | Greene | Indiana | 18055 | 189 | 35 |
294100 | 294100 | 2020-07-02 | Greene | Indiana | 18055 | 189 | 35 |
290946 | 290946 | 2020-07-01 | Greene | Indiana | 18055 | 189 | 34 |
287796 | 287796 | 2020-06-30 | Greene | Indiana | 18055 | 189 | 34 |
284647 | 284647 | 2020-06-29 | Greene | Indiana | 18055 | 188 | 34 |
281502 | 281502 | 2020-06-28 | Greene | Indiana | 18055 | 188 | 34 |
278354 | 278354 | 2020-06-27 | Greene | Indiana | 18055 | 188 | 34 |
275206 | 275206 | 2020-06-26 | Greene | Indiana | 18055 | 190 | 32 |
272064 | 272064 | 2020-06-25 | Greene | Indiana | 18055 | 189 | 32 |
268927 | 268927 | 2020-06-24 | Greene | Indiana | 18055 | 189 | 32 |
265797 | 265797 | 2020-06-23 | Greene | Indiana | 18055 | 189 | 32 |
262669 | 262669 | 2020-06-22 | Greene | Indiana | 18055 | 189 | 32 |
259542 | 259542 | 2020-06-21 | Greene | Indiana | 18055 | 189 | 32 |
256416 | 256416 | 2020-06-20 | Greene | Indiana | 18055 | 189 | 32 |
253296 | 253296 | 2020-06-19 | Greene | Indiana | 18055 | 188 | 32 |
250181 | 250181 | 2020-06-18 | Greene | Indiana | 18055 | 187 | 32 |
247069 | 247069 | 2020-06-17 | Greene | Indiana | 18055 | 187 | 32 |
243956 | 243956 | 2020-06-16 | Greene | Indiana | 18055 | 186 | 32 |
240845 | 240845 | 2020-06-15 | Greene | Indiana | 18055 | 186 | 32 |
237737 | 237737 | 2020-06-14 | Greene | Indiana | 18055 | 184 | 32 |
234630 | 234630 | 2020-06-13 | Greene | Indiana | 18055 | 182 | 31 |
231524 | 231524 | 2020-06-12 | Greene | Indiana | 18055 | 182 | 31 |
228421 | 228421 | 2020-06-11 | Greene | Indiana | 18055 | 182 | 31 |
225319 | 225319 | 2020-06-10 | Greene | Indiana | 18055 | 182 | 31 |
222224 | 222224 | 2020-06-09 | Greene | Indiana | 18055 | 179 | 31 |
219129 | 219129 | 2020-06-08 | Greene | Indiana | 18055 | 179 | 31 |
216037 | 216037 | 2020-06-07 | Greene | Indiana | 18055 | 179 | 30 |
212950 | 212950 | 2020-06-06 | Greene | Indiana | 18055 | 178 | 30 |
209865 | 209865 | 2020-06-05 | Greene | Indiana | 18055 | 176 | 29 |
206784 | 206784 | 2020-06-04 | Greene | Indiana | 18055 | 176 | 28 |
203704 | 203704 | 2020-06-03 | Greene | Indiana | 18055 | 175 | 28 |
200628 | 200628 | 2020-06-02 | Greene | Indiana | 18055 | 173 | 28 |
197555 | 197555 | 2020-06-01 | Greene | Indiana | 18055 | 173 | 28 |
194485 | 194485 | 2020-05-31 | Greene | Indiana | 18055 | 173 | 27 |
191418 | 191418 | 2020-05-30 | Greene | Indiana | 18055 | 173 | 27 |
188353 | 188353 | 2020-05-29 | Greene | Indiana | 18055 | 172 | 27 |
185295 | 185295 | 2020-05-28 | Greene | Indiana | 18055 | 172 | 27 |
182241 | 182241 | 2020-05-27 | Greene | Indiana | 18055 | 172 | 27 |
179197 | 179197 | 2020-05-26 | Greene | Indiana | 18055 | 171 | 27 |
176153 | 176153 | 2020-05-25 | Greene | Indiana | 18055 | 171 | 26 |
173109 | 173109 | 2020-05-24 | Greene | Indiana | 18055 | 171 | 26 |
170068 | 170068 | 2020-05-23 | Greene | Indiana | 18055 | 171 | 26 |
167031 | 167031 | 2020-05-22 | Greene | Indiana | 18055 | 171 | 25 |
163998 | 163998 | 2020-05-21 | Greene | Indiana | 18055 | 169 | 24 |
160970 | 160970 | 2020-05-20 | Greene | Indiana | 18055 | 166 | 24 |
157944 | 157944 | 2020-05-19 | Greene | Indiana | 18055 | 165 | 24 |
154928 | 154928 | 2020-05-18 | Greene | Indiana | 18055 | 164 | 24 |
151916 | 151916 | 2020-05-17 | Greene | Indiana | 18055 | 162 | 24 |
148907 | 148907 | 2020-05-16 | Greene | Indiana | 18055 | 158 | 23 |
145903 | 145903 | 2020-05-15 | Greene | Indiana | 18055 | 158 | 20 |
142903 | 142903 | 2020-05-14 | Greene | Indiana | 18055 | 157 | 20 |
139907 | 139907 | 2020-05-13 | Greene | Indiana | 18055 | 155 | 20 |
136915 | 136915 | 2020-05-12 | Greene | Indiana | 18055 | 155 | 19 |
133926 | 133926 | 2020-05-11 | Greene | Indiana | 18055 | 151 | 17 |
130936 | 130936 | 2020-05-10 | Greene | Indiana | 18055 | 151 | 13 |
127945 | 127945 | 2020-05-09 | Greene | Indiana | 18055 | 151 | 11 |
124958 | 124958 | 2020-05-08 | Greene | Indiana | 18055 | 150 | 11 |
121978 | 121978 | 2020-05-07 | Greene | Indiana | 18055 | 136 | 11 |
119008 | 119008 | 2020-05-06 | Greene | Indiana | 18055 | 105 | 10 |
116048 | 116048 | 2020-05-05 | Greene | Indiana | 18055 | 100 | 9 |
113165 | 113165 | 2020-05-04 | Greene | Indiana | 18055 | 99 | 8 |
110290 | 110290 | 2020-05-03 | Greene | Indiana | 18055 | 99 | 8 |
107420 | 107420 | 2020-05-02 | Greene | Indiana | 18055 | 98 | 8 |
104555 | 104555 | 2020-05-01 | Greene | Indiana | 18055 | 93 | 8 |
101699 | 101699 | 2020-04-30 | Greene | Indiana | 18055 | 59 | 8 |
98848 | 98848 | 2020-04-29 | Greene | Indiana | 18055 | 58 | 8 |
96004 | 96004 | 2020-04-28 | Greene | Indiana | 18055 | 50 | 7 |
93172 | 93172 | 2020-04-27 | Greene | Indiana | 18055 | 48 | 6 |
90353 | 90353 | 2020-04-26 | Greene | Indiana | 18055 | 49 | 7 |
87537 | 87537 | 2020-04-25 | Greene | Indiana | 18055 | 48 | 6 |
84727 | 84727 | 2020-04-24 | Greene | Indiana | 18055 | 46 | 5 |
81927 | 81927 | 2020-04-23 | Greene | Indiana | 18055 | 45 | 5 |
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);