ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
71,921 rows where state = "Indiana" sorted by county descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
fips >30
- 18097 799
- 18063 797
- 18113 796
- 18001 795
- 18011 795
- 18067 794
- 18081 794
- 18141 794
- 18091 791
- 18179 791
- 18057 790
- 18005 789
- 18043 789
- 18047 788
- 18089 788
- 18019 787
- 18041 787
- 18079 787
- 18095 787
- 18119 786
- 18157 786
- 18177 786
- 18003 785
- 18053 785
- 18145 785
- 18163 785
- 18167 785
- 18035 784
- 18039 784
- 18059 784
- …
county >30
- Marion 799
- Hendricks 797
- Noble 796
- Adams 795
- Boone 795
- Howard 794
- Johnson 794
- St. Joseph 794
- LaPorte 791
- Wells 791
- Hamilton 790
- Bartholomew 789
- Floyd 789
- Franklin 788
- Lake 788
- Clark 787
- Fayette 787
- Jennings 787
- Madison 787
- Owen 786
- Tippecanoe 786
- Wayne 786
- Allen 785
- Grant 785
- Shelby 785
- Vanderburgh 785
- Vigo 785
- Delaware 784
- Elkhart 784
- Hancock 784
- …
state 1
- Indiana · 71,821 ✖
Link | rowid | date | county ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
303648 | 303648 | 2020-07-05 | Whitley | Indiana | 18183 | 92 | 5 |
306813 | 306813 | 2020-07-06 | Whitley | Indiana | 18183 | 92 | 5 |
309981 | 309981 | 2020-07-07 | Whitley | Indiana | 18183 | 96 | 5 |
313151 | 313151 | 2020-07-08 | Whitley | Indiana | 18183 | 97 | 5 |
316325 | 316325 | 2020-07-09 | Whitley | Indiana | 18183 | 99 | 5 |
319498 | 319498 | 2020-07-10 | Whitley | Indiana | 18183 | 104 | 5 |
322677 | 322677 | 2020-07-11 | Whitley | Indiana | 18183 | 106 | 6 |
325858 | 325858 | 2020-07-12 | Whitley | Indiana | 18183 | 107 | 6 |
329044 | 329044 | 2020-07-13 | Whitley | Indiana | 18183 | 108 | 6 |
332231 | 332231 | 2020-07-14 | Whitley | Indiana | 18183 | 108 | 6 |
335424 | 335424 | 2020-07-15 | Whitley | Indiana | 18183 | 111 | 6 |
338620 | 338620 | 2020-07-16 | Whitley | Indiana | 18183 | 112 | 6 |
341816 | 341816 | 2020-07-17 | Whitley | Indiana | 18183 | 113 | 6 |
345016 | 345016 | 2020-07-18 | Whitley | Indiana | 18183 | 115 | 6 |
348217 | 348217 | 2020-07-19 | Whitley | Indiana | 18183 | 116 | 6 |
351417 | 351417 | 2020-07-20 | Whitley | Indiana | 18183 | 116 | 6 |
354619 | 354619 | 2020-07-21 | Whitley | Indiana | 18183 | 120 | 6 |
357821 | 357821 | 2020-07-22 | Whitley | Indiana | 18183 | 122 | 6 |
361026 | 361026 | 2020-07-23 | Whitley | Indiana | 18183 | 127 | 6 |
364233 | 364233 | 2020-07-24 | Whitley | Indiana | 18183 | 129 | 6 |
367440 | 367440 | 2020-07-25 | Whitley | Indiana | 18183 | 133 | 6 |
370650 | 370650 | 2020-07-26 | Whitley | Indiana | 18183 | 136 | 6 |
373862 | 373862 | 2020-07-27 | Whitley | Indiana | 18183 | 137 | 6 |
377077 | 377077 | 2020-07-28 | Whitley | Indiana | 18183 | 138 | 6 |
380294 | 380294 | 2020-07-29 | Whitley | Indiana | 18183 | 140 | 6 |
383511 | 383511 | 2020-07-30 | Whitley | Indiana | 18183 | 141 | 6 |
386729 | 386729 | 2020-07-31 | Whitley | Indiana | 18183 | 143 | 6 |
389946 | 389946 | 2020-08-01 | Whitley | Indiana | 18183 | 144 | 6 |
393163 | 393163 | 2020-08-02 | Whitley | Indiana | 18183 | 148 | 6 |
396379 | 396379 | 2020-08-03 | Whitley | Indiana | 18183 | 148 | 6 |
399595 | 399595 | 2020-08-04 | Whitley | Indiana | 18183 | 148 | 6 |
402811 | 402811 | 2020-08-05 | Whitley | Indiana | 18183 | 149 | 6 |
406029 | 406029 | 2020-08-06 | Whitley | Indiana | 18183 | 147 | 6 |
409249 | 409249 | 2020-08-07 | Whitley | Indiana | 18183 | 150 | 6 |
412468 | 412468 | 2020-08-08 | Whitley | Indiana | 18183 | 151 | 6 |
415688 | 415688 | 2020-08-09 | Whitley | Indiana | 18183 | 152 | 6 |
418909 | 418909 | 2020-08-10 | Whitley | Indiana | 18183 | 154 | 6 |
422132 | 422132 | 2020-08-11 | Whitley | Indiana | 18183 | 155 | 6 |
425353 | 425353 | 2020-08-12 | Whitley | Indiana | 18183 | 156 | 6 |
428577 | 428577 | 2020-08-13 | Whitley | Indiana | 18183 | 160 | 6 |
431805 | 431805 | 2020-08-14 | Whitley | Indiana | 18183 | 162 | 6 |
435030 | 435030 | 2020-08-15 | Whitley | Indiana | 18183 | 164 | 6 |
438256 | 438256 | 2020-08-16 | Whitley | Indiana | 18183 | 167 | 6 |
441482 | 441482 | 2020-08-17 | Whitley | Indiana | 18183 | 170 | 6 |
444708 | 444708 | 2020-08-18 | Whitley | Indiana | 18183 | 171 | 6 |
447935 | 447935 | 2020-08-19 | Whitley | Indiana | 18183 | 172 | 6 |
451163 | 451163 | 2020-08-20 | Whitley | Indiana | 18183 | 177 | 6 |
454391 | 454391 | 2020-08-21 | Whitley | Indiana | 18183 | 182 | 6 |
457619 | 457619 | 2020-08-22 | Whitley | Indiana | 18183 | 185 | 6 |
460846 | 460846 | 2020-08-23 | Whitley | Indiana | 18183 | 185 | 6 |
464075 | 464075 | 2020-08-24 | Whitley | Indiana | 18183 | 192 | 6 |
467304 | 467304 | 2020-08-25 | Whitley | Indiana | 18183 | 194 | 6 |
470533 | 470533 | 2020-08-26 | Whitley | Indiana | 18183 | 195 | 6 |
473765 | 473765 | 2020-08-27 | Whitley | Indiana | 18183 | 200 | 6 |
476998 | 476998 | 2020-08-28 | Whitley | Indiana | 18183 | 202 | 6 |
480231 | 480231 | 2020-08-29 | Whitley | Indiana | 18183 | 208 | 6 |
483465 | 483465 | 2020-08-30 | Whitley | Indiana | 18183 | 211 | 6 |
486700 | 486700 | 2020-08-31 | Whitley | Indiana | 18183 | 213 | 6 |
489933 | 489933 | 2020-09-01 | Whitley | Indiana | 18183 | 213 | 6 |
493166 | 493166 | 2020-09-02 | Whitley | Indiana | 18183 | 216 | 6 |
496400 | 496400 | 2020-09-03 | Whitley | Indiana | 18183 | 219 | 6 |
499633 | 499633 | 2020-09-04 | Whitley | Indiana | 18183 | 222 | 6 |
502867 | 502867 | 2020-09-05 | Whitley | Indiana | 18183 | 226 | 6 |
506101 | 506101 | 2020-09-06 | Whitley | Indiana | 18183 | 229 | 6 |
509333 | 509333 | 2020-09-07 | Whitley | Indiana | 18183 | 231 | 6 |
512566 | 512566 | 2020-09-08 | Whitley | Indiana | 18183 | 233 | 6 |
515799 | 515799 | 2020-09-09 | Whitley | Indiana | 18183 | 234 | 6 |
519034 | 519034 | 2020-09-10 | Whitley | Indiana | 18183 | 236 | 6 |
522271 | 522271 | 2020-09-11 | Whitley | Indiana | 18183 | 237 | 6 |
525507 | 525507 | 2020-09-12 | Whitley | Indiana | 18183 | 237 | 6 |
528743 | 528743 | 2020-09-13 | Whitley | Indiana | 18183 | 237 | 6 |
531980 | 531980 | 2020-09-14 | Whitley | Indiana | 18183 | 238 | 6 |
535215 | 535215 | 2020-09-15 | Whitley | Indiana | 18183 | 241 | 6 |
538451 | 538451 | 2020-09-16 | Whitley | Indiana | 18183 | 241 | 6 |
541688 | 541688 | 2020-09-17 | Whitley | Indiana | 18183 | 245 | 6 |
544924 | 544924 | 2020-09-18 | Whitley | Indiana | 18183 | 244 | 6 |
548162 | 548162 | 2020-09-19 | Whitley | Indiana | 18183 | 247 | 6 |
551401 | 551401 | 2020-09-20 | Whitley | Indiana | 18183 | 252 | 6 |
554640 | 554640 | 2020-09-21 | Whitley | Indiana | 18183 | 254 | 6 |
557877 | 557877 | 2020-09-22 | Whitley | Indiana | 18183 | 252 | 6 |
561113 | 561113 | 2020-09-23 | Whitley | Indiana | 18183 | 255 | 6 |
564353 | 564353 | 2020-09-24 | Whitley | Indiana | 18183 | 261 | 7 |
567593 | 567593 | 2020-09-25 | Whitley | Indiana | 18183 | 270 | 7 |
570835 | 570835 | 2020-09-26 | Whitley | Indiana | 18183 | 276 | 6 |
574078 | 574078 | 2020-09-27 | Whitley | Indiana | 18183 | 279 | 6 |
577320 | 577320 | 2020-09-28 | Whitley | Indiana | 18183 | 282 | 6 |
580561 | 580561 | 2020-09-29 | Whitley | Indiana | 18183 | 287 | 6 |
583800 | 583800 | 2020-09-30 | Whitley | Indiana | 18183 | 295 | 6 |
587040 | 587040 | 2020-10-01 | Whitley | Indiana | 18183 | 295 | 6 |
590281 | 590281 | 2020-10-02 | Whitley | Indiana | 18183 | 300 | 6 |
593522 | 593522 | 2020-10-03 | Whitley | Indiana | 18183 | 306 | 6 |
596764 | 596764 | 2020-10-04 | Whitley | Indiana | 18183 | 314 | 7 |
600006 | 600006 | 2020-10-05 | Whitley | Indiana | 18183 | 319 | 7 |
603249 | 603249 | 2020-10-06 | Whitley | Indiana | 18183 | 322 | 7 |
606491 | 606491 | 2020-10-07 | Whitley | Indiana | 18183 | 334 | 7 |
609734 | 609734 | 2020-10-08 | Whitley | Indiana | 18183 | 338 | 7 |
612976 | 612976 | 2020-10-09 | Whitley | Indiana | 18183 | 348 | 6 |
616217 | 616217 | 2020-10-10 | Whitley | Indiana | 18183 | 358 | 6 |
619459 | 619459 | 2020-10-11 | Whitley | Indiana | 18183 | 364 | 6 |
622703 | 622703 | 2020-10-12 | Whitley | Indiana | 18183 | 373 | 6 |
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);