ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Adams" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635587 | 635587 | 2020-10-16 | Adams | Indiana | 18001 | 433 | 6 |
632341 | 632341 | 2020-10-15 | Adams | Indiana | 18001 | 416 | 6 |
629097 | 629097 | 2020-10-14 | Adams | Indiana | 18001 | 406 | 5 |
625854 | 625854 | 2020-10-13 | Adams | Indiana | 18001 | 401 | 5 |
622612 | 622612 | 2020-10-12 | Adams | Indiana | 18001 | 384 | 5 |
619368 | 619368 | 2020-10-11 | Adams | Indiana | 18001 | 364 | 5 |
616126 | 616126 | 2020-10-10 | Adams | Indiana | 18001 | 360 | 5 |
612885 | 612885 | 2020-10-09 | Adams | Indiana | 18001 | 342 | 5 |
609643 | 609643 | 2020-10-08 | Adams | Indiana | 18001 | 334 | 5 |
606400 | 606400 | 2020-10-07 | Adams | Indiana | 18001 | 320 | 5 |
603158 | 603158 | 2020-10-06 | Adams | Indiana | 18001 | 318 | 5 |
599915 | 599915 | 2020-10-05 | Adams | Indiana | 18001 | 306 | 5 |
596673 | 596673 | 2020-10-04 | Adams | Indiana | 18001 | 343 | 5 |
593431 | 593431 | 2020-10-03 | Adams | Indiana | 18001 | 342 | 5 |
590190 | 590190 | 2020-10-02 | Adams | Indiana | 18001 | 316 | 5 |
586949 | 586949 | 2020-10-01 | Adams | Indiana | 18001 | 288 | 4 |
583709 | 583709 | 2020-09-30 | Adams | Indiana | 18001 | 284 | 4 |
580470 | 580470 | 2020-09-29 | Adams | Indiana | 18001 | 278 | 4 |
577229 | 577229 | 2020-09-28 | Adams | Indiana | 18001 | 277 | 4 |
573987 | 573987 | 2020-09-27 | Adams | Indiana | 18001 | 287 | 4 |
570744 | 570744 | 2020-09-26 | Adams | Indiana | 18001 | 279 | 4 |
567502 | 567502 | 2020-09-25 | Adams | Indiana | 18001 | 262 | 4 |
564262 | 564262 | 2020-09-24 | Adams | Indiana | 18001 | 256 | 4 |
561022 | 561022 | 2020-09-23 | Adams | Indiana | 18001 | 253 | 4 |
557786 | 557786 | 2020-09-22 | Adams | Indiana | 18001 | 246 | 4 |
554549 | 554549 | 2020-09-21 | Adams | Indiana | 18001 | 245 | 4 |
551310 | 551310 | 2020-09-20 | Adams | Indiana | 18001 | 245 | 4 |
548071 | 548071 | 2020-09-19 | Adams | Indiana | 18001 | 241 | 4 |
544833 | 544833 | 2020-09-18 | Adams | Indiana | 18001 | 235 | 4 |
541597 | 541597 | 2020-09-17 | Adams | Indiana | 18001 | 231 | 4 |
538360 | 538360 | 2020-09-16 | Adams | Indiana | 18001 | 227 | 4 |
535124 | 535124 | 2020-09-15 | Adams | Indiana | 18001 | 224 | 4 |
531889 | 531889 | 2020-09-14 | Adams | Indiana | 18001 | 223 | 4 |
528652 | 528652 | 2020-09-13 | Adams | Indiana | 18001 | 221 | 4 |
525416 | 525416 | 2020-09-12 | Adams | Indiana | 18001 | 220 | 4 |
522180 | 522180 | 2020-09-11 | Adams | Indiana | 18001 | 212 | 4 |
518943 | 518943 | 2020-09-10 | Adams | Indiana | 18001 | 211 | 4 |
515708 | 515708 | 2020-09-09 | Adams | Indiana | 18001 | 210 | 4 |
512475 | 512475 | 2020-09-08 | Adams | Indiana | 18001 | 200 | 4 |
509242 | 509242 | 2020-09-07 | Adams | Indiana | 18001 | 196 | 4 |
506010 | 506010 | 2020-09-06 | Adams | Indiana | 18001 | 196 | 4 |
502776 | 502776 | 2020-09-05 | Adams | Indiana | 18001 | 195 | 4 |
499542 | 499542 | 2020-09-04 | Adams | Indiana | 18001 | 193 | 4 |
496309 | 496309 | 2020-09-03 | Adams | Indiana | 18001 | 193 | 3 |
493075 | 493075 | 2020-09-02 | Adams | Indiana | 18001 | 191 | 3 |
489842 | 489842 | 2020-09-01 | Adams | Indiana | 18001 | 191 | 3 |
486609 | 486609 | 2020-08-31 | Adams | Indiana | 18001 | 188 | 3 |
483374 | 483374 | 2020-08-30 | Adams | Indiana | 18001 | 185 | 3 |
480140 | 480140 | 2020-08-29 | Adams | Indiana | 18001 | 182 | 3 |
476907 | 476907 | 2020-08-28 | Adams | Indiana | 18001 | 178 | 3 |
473674 | 473674 | 2020-08-27 | Adams | Indiana | 18001 | 178 | 3 |
470442 | 470442 | 2020-08-26 | Adams | Indiana | 18001 | 165 | 3 |
467213 | 467213 | 2020-08-25 | Adams | Indiana | 18001 | 162 | 3 |
463984 | 463984 | 2020-08-24 | Adams | Indiana | 18001 | 160 | 3 |
460755 | 460755 | 2020-08-23 | Adams | Indiana | 18001 | 158 | 3 |
457528 | 457528 | 2020-08-22 | Adams | Indiana | 18001 | 157 | 3 |
454300 | 454300 | 2020-08-21 | Adams | Indiana | 18001 | 153 | 3 |
451072 | 451072 | 2020-08-20 | Adams | Indiana | 18001 | 149 | 3 |
447844 | 447844 | 2020-08-19 | Adams | Indiana | 18001 | 143 | 3 |
444617 | 444617 | 2020-08-18 | Adams | Indiana | 18001 | 142 | 3 |
441391 | 441391 | 2020-08-17 | Adams | Indiana | 18001 | 140 | 3 |
438165 | 438165 | 2020-08-16 | Adams | Indiana | 18001 | 136 | 3 |
434939 | 434939 | 2020-08-15 | Adams | Indiana | 18001 | 133 | 3 |
431714 | 431714 | 2020-08-14 | Adams | Indiana | 18001 | 125 | 3 |
428486 | 428486 | 2020-08-13 | Adams | Indiana | 18001 | 121 | 3 |
425262 | 425262 | 2020-08-12 | Adams | Indiana | 18001 | 118 | 3 |
422041 | 422041 | 2020-08-11 | Adams | Indiana | 18001 | 110 | 3 |
418818 | 418818 | 2020-08-10 | Adams | Indiana | 18001 | 103 | 3 |
415597 | 415597 | 2020-08-09 | Adams | Indiana | 18001 | 102 | 3 |
412377 | 412377 | 2020-08-08 | Adams | Indiana | 18001 | 97 | 3 |
409158 | 409158 | 2020-08-07 | Adams | Indiana | 18001 | 96 | 3 |
405938 | 405938 | 2020-08-06 | Adams | Indiana | 18001 | 90 | 3 |
402720 | 402720 | 2020-08-05 | Adams | Indiana | 18001 | 85 | 3 |
399504 | 399504 | 2020-08-04 | Adams | Indiana | 18001 | 83 | 3 |
396288 | 396288 | 2020-08-03 | Adams | Indiana | 18001 | 82 | 3 |
393072 | 393072 | 2020-08-02 | Adams | Indiana | 18001 | 82 | 3 |
389855 | 389855 | 2020-08-01 | Adams | Indiana | 18001 | 80 | 3 |
386638 | 386638 | 2020-07-31 | Adams | Indiana | 18001 | 75 | 3 |
383420 | 383420 | 2020-07-30 | Adams | Indiana | 18001 | 74 | 2 |
380203 | 380203 | 2020-07-29 | Adams | Indiana | 18001 | 74 | 2 |
376986 | 376986 | 2020-07-28 | Adams | Indiana | 18001 | 74 | 2 |
373771 | 373771 | 2020-07-27 | Adams | Indiana | 18001 | 72 | 2 |
370559 | 370559 | 2020-07-26 | Adams | Indiana | 18001 | 71 | 2 |
367349 | 367349 | 2020-07-25 | Adams | Indiana | 18001 | 70 | 2 |
364142 | 364142 | 2020-07-24 | Adams | Indiana | 18001 | 70 | 2 |
360935 | 360935 | 2020-07-23 | Adams | Indiana | 18001 | 67 | 2 |
357730 | 357730 | 2020-07-22 | Adams | Indiana | 18001 | 64 | 2 |
354528 | 354528 | 2020-07-21 | Adams | Indiana | 18001 | 59 | 2 |
351326 | 351326 | 2020-07-20 | Adams | Indiana | 18001 | 58 | 2 |
348126 | 348126 | 2020-07-19 | Adams | Indiana | 18001 | 58 | 2 |
344925 | 344925 | 2020-07-18 | Adams | Indiana | 18001 | 56 | 2 |
341725 | 341725 | 2020-07-17 | Adams | Indiana | 18001 | 55 | 2 |
338529 | 338529 | 2020-07-16 | Adams | Indiana | 18001 | 54 | 2 |
335333 | 335333 | 2020-07-15 | Adams | Indiana | 18001 | 53 | 2 |
332140 | 332140 | 2020-07-14 | Adams | Indiana | 18001 | 50 | 2 |
328953 | 328953 | 2020-07-13 | Adams | Indiana | 18001 | 50 | 2 |
325767 | 325767 | 2020-07-12 | Adams | Indiana | 18001 | 50 | 2 |
322586 | 322586 | 2020-07-11 | Adams | Indiana | 18001 | 50 | 2 |
319407 | 319407 | 2020-07-10 | Adams | Indiana | 18001 | 50 | 2 |
316234 | 316234 | 2020-07-09 | Adams | Indiana | 18001 | 50 | 2 |
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);