ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Franklin" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535147 | 535147 | 2020-09-15 | Franklin | Indiana | 18047 | 299 | 26 |
531912 | 531912 | 2020-09-14 | Franklin | Indiana | 18047 | 298 | 26 |
528675 | 528675 | 2020-09-13 | Franklin | Indiana | 18047 | 297 | 26 |
525439 | 525439 | 2020-09-12 | Franklin | Indiana | 18047 | 297 | 26 |
522203 | 522203 | 2020-09-11 | Franklin | Indiana | 18047 | 295 | 26 |
518966 | 518966 | 2020-09-10 | Franklin | Indiana | 18047 | 293 | 26 |
515731 | 515731 | 2020-09-09 | Franklin | Indiana | 18047 | 293 | 26 |
512498 | 512498 | 2020-09-08 | Franklin | Indiana | 18047 | 292 | 26 |
509265 | 509265 | 2020-09-07 | Franklin | Indiana | 18047 | 291 | 26 |
506033 | 506033 | 2020-09-06 | Franklin | Indiana | 18047 | 291 | 26 |
502799 | 502799 | 2020-09-05 | Franklin | Indiana | 18047 | 289 | 26 |
499565 | 499565 | 2020-09-04 | Franklin | Indiana | 18047 | 289 | 26 |
496332 | 496332 | 2020-09-03 | Franklin | Indiana | 18047 | 289 | 26 |
493098 | 493098 | 2020-09-02 | Franklin | Indiana | 18047 | 286 | 26 |
489865 | 489865 | 2020-09-01 | Franklin | Indiana | 18047 | 286 | 26 |
486632 | 486632 | 2020-08-31 | Franklin | Indiana | 18047 | 284 | 26 |
483397 | 483397 | 2020-08-30 | Franklin | Indiana | 18047 | 283 | 26 |
480163 | 480163 | 2020-08-29 | Franklin | Indiana | 18047 | 283 | 26 |
476930 | 476930 | 2020-08-28 | Franklin | Indiana | 18047 | 283 | 26 |
473697 | 473697 | 2020-08-27 | Franklin | Indiana | 18047 | 280 | 25 |
470465 | 470465 | 2020-08-26 | Franklin | Indiana | 18047 | 275 | 24 |
467236 | 467236 | 2020-08-25 | Franklin | Indiana | 18047 | 274 | 24 |
464007 | 464007 | 2020-08-24 | Franklin | Indiana | 18047 | 271 | 23 |
460778 | 460778 | 2020-08-23 | Franklin | Indiana | 18047 | 271 | 23 |
457551 | 457551 | 2020-08-22 | Franklin | Indiana | 18047 | 270 | 23 |
454323 | 454323 | 2020-08-21 | Franklin | Indiana | 18047 | 267 | 23 |
451095 | 451095 | 2020-08-20 | Franklin | Indiana | 18047 | 266 | 23 |
447867 | 447867 | 2020-08-19 | Franklin | Indiana | 18047 | 264 | 23 |
444640 | 444640 | 2020-08-18 | Franklin | Indiana | 18047 | 263 | 23 |
441414 | 441414 | 2020-08-17 | Franklin | Indiana | 18047 | 263 | 20 |
438188 | 438188 | 2020-08-16 | Franklin | Indiana | 18047 | 263 | 20 |
434962 | 434962 | 2020-08-15 | Franklin | Indiana | 18047 | 263 | 20 |
431737 | 431737 | 2020-08-14 | Franklin | Indiana | 18047 | 261 | 17 |
428509 | 428509 | 2020-08-13 | Franklin | Indiana | 18047 | 259 | 16 |
425285 | 425285 | 2020-08-12 | Franklin | Indiana | 18047 | 257 | 16 |
422064 | 422064 | 2020-08-11 | Franklin | Indiana | 18047 | 256 | 16 |
418841 | 418841 | 2020-08-10 | Franklin | Indiana | 18047 | 253 | 15 |
415620 | 415620 | 2020-08-09 | Franklin | Indiana | 18047 | 252 | 15 |
412400 | 412400 | 2020-08-08 | Franklin | Indiana | 18047 | 251 | 15 |
409181 | 409181 | 2020-08-07 | Franklin | Indiana | 18047 | 248 | 14 |
405961 | 405961 | 2020-08-06 | Franklin | Indiana | 18047 | 244 | 14 |
402743 | 402743 | 2020-08-05 | Franklin | Indiana | 18047 | 241 | 14 |
399527 | 399527 | 2020-08-04 | Franklin | Indiana | 18047 | 239 | 12 |
396311 | 396311 | 2020-08-03 | Franklin | Indiana | 18047 | 235 | 11 |
393095 | 393095 | 2020-08-02 | Franklin | Indiana | 18047 | 216 | 11 |
389878 | 389878 | 2020-08-01 | Franklin | Indiana | 18047 | 208 | 11 |
386661 | 386661 | 2020-07-31 | Franklin | Indiana | 18047 | 202 | 10 |
383443 | 383443 | 2020-07-30 | Franklin | Indiana | 18047 | 198 | 9 |
380226 | 380226 | 2020-07-29 | Franklin | Indiana | 18047 | 192 | 9 |
377009 | 377009 | 2020-07-28 | Franklin | Indiana | 18047 | 186 | 9 |
373794 | 373794 | 2020-07-27 | Franklin | Indiana | 18047 | 184 | 9 |
370582 | 370582 | 2020-07-26 | Franklin | Indiana | 18047 | 184 | 9 |
367372 | 367372 | 2020-07-25 | Franklin | Indiana | 18047 | 181 | 9 |
364165 | 364165 | 2020-07-24 | Franklin | Indiana | 18047 | 175 | 9 |
360958 | 360958 | 2020-07-23 | Franklin | Indiana | 18047 | 170 | 9 |
357753 | 357753 | 2020-07-22 | Franklin | Indiana | 18047 | 162 | 9 |
354551 | 354551 | 2020-07-21 | Franklin | Indiana | 18047 | 159 | 9 |
351349 | 351349 | 2020-07-20 | Franklin | Indiana | 18047 | 155 | 9 |
348149 | 348149 | 2020-07-19 | Franklin | Indiana | 18047 | 152 | 9 |
344948 | 344948 | 2020-07-18 | Franklin | Indiana | 18047 | 146 | 9 |
341748 | 341748 | 2020-07-17 | Franklin | Indiana | 18047 | 143 | 9 |
338552 | 338552 | 2020-07-16 | Franklin | Indiana | 18047 | 140 | 9 |
335356 | 335356 | 2020-07-15 | Franklin | Indiana | 18047 | 140 | 9 |
332163 | 332163 | 2020-07-14 | Franklin | Indiana | 18047 | 136 | 9 |
328976 | 328976 | 2020-07-13 | Franklin | Indiana | 18047 | 136 | 9 |
325790 | 325790 | 2020-07-12 | Franklin | Indiana | 18047 | 136 | 9 |
322609 | 322609 | 2020-07-11 | Franklin | Indiana | 18047 | 135 | 9 |
319430 | 319430 | 2020-07-10 | Franklin | Indiana | 18047 | 135 | 9 |
316257 | 316257 | 2020-07-09 | Franklin | Indiana | 18047 | 135 | 9 |
313083 | 313083 | 2020-07-08 | Franklin | Indiana | 18047 | 134 | 9 |
309913 | 309913 | 2020-07-07 | Franklin | Indiana | 18047 | 134 | 9 |
306745 | 306745 | 2020-07-06 | Franklin | Indiana | 18047 | 132 | 9 |
303580 | 303580 | 2020-07-05 | Franklin | Indiana | 18047 | 131 | 9 |
300416 | 300416 | 2020-07-04 | Franklin | Indiana | 18047 | 131 | 9 |
297254 | 297254 | 2020-07-03 | Franklin | Indiana | 18047 | 131 | 9 |
294096 | 294096 | 2020-07-02 | Franklin | Indiana | 18047 | 131 | 9 |
290942 | 290942 | 2020-07-01 | Franklin | Indiana | 18047 | 131 | 9 |
287792 | 287792 | 2020-06-30 | Franklin | Indiana | 18047 | 131 | 9 |
284643 | 284643 | 2020-06-29 | Franklin | Indiana | 18047 | 131 | 9 |
281498 | 281498 | 2020-06-28 | Franklin | Indiana | 18047 | 131 | 9 |
278350 | 278350 | 2020-06-27 | Franklin | Indiana | 18047 | 131 | 9 |
275202 | 275202 | 2020-06-26 | Franklin | Indiana | 18047 | 131 | 9 |
272060 | 272060 | 2020-06-25 | Franklin | Indiana | 18047 | 129 | 9 |
268923 | 268923 | 2020-06-24 | Franklin | Indiana | 18047 | 128 | 9 |
265793 | 265793 | 2020-06-23 | Franklin | Indiana | 18047 | 128 | 9 |
262665 | 262665 | 2020-06-22 | Franklin | Indiana | 18047 | 128 | 9 |
259538 | 259538 | 2020-06-21 | Franklin | Indiana | 18047 | 128 | 9 |
256412 | 256412 | 2020-06-20 | Franklin | Indiana | 18047 | 127 | 9 |
253292 | 253292 | 2020-06-19 | Franklin | Indiana | 18047 | 127 | 9 |
250177 | 250177 | 2020-06-18 | Franklin | Indiana | 18047 | 127 | 9 |
247065 | 247065 | 2020-06-17 | Franklin | Indiana | 18047 | 127 | 9 |
243952 | 243952 | 2020-06-16 | Franklin | Indiana | 18047 | 127 | 9 |
240841 | 240841 | 2020-06-15 | Franklin | Indiana | 18047 | 127 | 9 |
237733 | 237733 | 2020-06-14 | Franklin | Indiana | 18047 | 127 | 9 |
234626 | 234626 | 2020-06-13 | Franklin | Indiana | 18047 | 126 | 9 |
231520 | 231520 | 2020-06-12 | Franklin | Indiana | 18047 | 126 | 9 |
228417 | 228417 | 2020-06-11 | Franklin | Indiana | 18047 | 126 | 9 |
225315 | 225315 | 2020-06-10 | Franklin | Indiana | 18047 | 126 | 9 |
222220 | 222220 | 2020-06-09 | Franklin | Indiana | 18047 | 125 | 9 |
219125 | 219125 | 2020-06-08 | Franklin | Indiana | 18047 | 124 | 9 |
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);