ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Grant" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
635613 | 635613 | 2020-10-16 | Grant | Indiana | 18053 | 1536 | 42 |
632367 | 632367 | 2020-10-15 | Grant | Indiana | 18053 | 1511 | 42 |
629123 | 629123 | 2020-10-14 | Grant | Indiana | 18053 | 1499 | 41 |
625880 | 625880 | 2020-10-13 | Grant | Indiana | 18053 | 1494 | 41 |
622638 | 622638 | 2020-10-12 | Grant | Indiana | 18053 | 1478 | 40 |
619394 | 619394 | 2020-10-11 | Grant | Indiana | 18053 | 1467 | 40 |
616152 | 616152 | 2020-10-10 | Grant | Indiana | 18053 | 1457 | 40 |
612911 | 612911 | 2020-10-09 | Grant | Indiana | 18053 | 1450 | 40 |
609669 | 609669 | 2020-10-08 | Grant | Indiana | 18053 | 1429 | 40 |
606426 | 606426 | 2020-10-07 | Grant | Indiana | 18053 | 1415 | 40 |
603184 | 603184 | 2020-10-06 | Grant | Indiana | 18053 | 1405 | 40 |
599941 | 599941 | 2020-10-05 | Grant | Indiana | 18053 | 1376 | 40 |
596699 | 596699 | 2020-10-04 | Grant | Indiana | 18053 | 1367 | 40 |
593457 | 593457 | 2020-10-03 | Grant | Indiana | 18053 | 1365 | 40 |
590216 | 590216 | 2020-10-02 | Grant | Indiana | 18053 | 1348 | 40 |
586975 | 586975 | 2020-10-01 | Grant | Indiana | 18053 | 1334 | 40 |
583735 | 583735 | 2020-09-30 | Grant | Indiana | 18053 | 1321 | 40 |
580496 | 580496 | 2020-09-29 | Grant | Indiana | 18053 | 1310 | 39 |
577255 | 577255 | 2020-09-28 | Grant | Indiana | 18053 | 1295 | 37 |
574013 | 574013 | 2020-09-27 | Grant | Indiana | 18053 | 1276 | 37 |
570770 | 570770 | 2020-09-26 | Grant | Indiana | 18053 | 1268 | 37 |
567528 | 567528 | 2020-09-25 | Grant | Indiana | 18053 | 1262 | 37 |
564288 | 564288 | 2020-09-24 | Grant | Indiana | 18053 | 1246 | 37 |
561048 | 561048 | 2020-09-23 | Grant | Indiana | 18053 | 1240 | 36 |
557812 | 557812 | 2020-09-22 | Grant | Indiana | 18053 | 1233 | 36 |
554575 | 554575 | 2020-09-21 | Grant | Indiana | 18053 | 1230 | 36 |
551336 | 551336 | 2020-09-20 | Grant | Indiana | 18053 | 1224 | 36 |
548097 | 548097 | 2020-09-19 | Grant | Indiana | 18053 | 1209 | 36 |
544859 | 544859 | 2020-09-18 | Grant | Indiana | 18053 | 1200 | 36 |
541623 | 541623 | 2020-09-17 | Grant | Indiana | 18053 | 1193 | 35 |
538386 | 538386 | 2020-09-16 | Grant | Indiana | 18053 | 1179 | 35 |
535150 | 535150 | 2020-09-15 | Grant | Indiana | 18053 | 1175 | 35 |
531915 | 531915 | 2020-09-14 | Grant | Indiana | 18053 | 1171 | 35 |
528678 | 528678 | 2020-09-13 | Grant | Indiana | 18053 | 1160 | 35 |
525442 | 525442 | 2020-09-12 | Grant | Indiana | 18053 | 1151 | 35 |
522206 | 522206 | 2020-09-11 | Grant | Indiana | 18053 | 1138 | 35 |
518969 | 518969 | 2020-09-10 | Grant | Indiana | 18053 | 1119 | 35 |
515734 | 515734 | 2020-09-09 | Grant | Indiana | 18053 | 1086 | 35 |
512501 | 512501 | 2020-09-08 | Grant | Indiana | 18053 | 1069 | 35 |
509268 | 509268 | 2020-09-07 | Grant | Indiana | 18053 | 1058 | 34 |
506036 | 506036 | 2020-09-06 | Grant | Indiana | 18053 | 1049 | 34 |
502802 | 502802 | 2020-09-05 | Grant | Indiana | 18053 | 1043 | 34 |
499568 | 499568 | 2020-09-04 | Grant | Indiana | 18053 | 1022 | 34 |
496335 | 496335 | 2020-09-03 | Grant | Indiana | 18053 | 1006 | 34 |
493101 | 493101 | 2020-09-02 | Grant | Indiana | 18053 | 983 | 34 |
489868 | 489868 | 2020-09-01 | Grant | Indiana | 18053 | 968 | 34 |
486635 | 486635 | 2020-08-31 | Grant | Indiana | 18053 | 957 | 33 |
483400 | 483400 | 2020-08-30 | Grant | Indiana | 18053 | 946 | 33 |
480166 | 480166 | 2020-08-29 | Grant | Indiana | 18053 | 935 | 33 |
476933 | 476933 | 2020-08-28 | Grant | Indiana | 18053 | 921 | 33 |
473700 | 473700 | 2020-08-27 | Grant | Indiana | 18053 | 918 | 33 |
470468 | 470468 | 2020-08-26 | Grant | Indiana | 18053 | 909 | 33 |
467239 | 467239 | 2020-08-25 | Grant | Indiana | 18053 | 903 | 33 |
464010 | 464010 | 2020-08-24 | Grant | Indiana | 18053 | 897 | 33 |
460781 | 460781 | 2020-08-23 | Grant | Indiana | 18053 | 875 | 33 |
457554 | 457554 | 2020-08-22 | Grant | Indiana | 18053 | 868 | 33 |
454326 | 454326 | 2020-08-21 | Grant | Indiana | 18053 | 857 | 33 |
451098 | 451098 | 2020-08-20 | Grant | Indiana | 18053 | 850 | 33 |
447870 | 447870 | 2020-08-19 | Grant | Indiana | 18053 | 841 | 33 |
444643 | 444643 | 2020-08-18 | Grant | Indiana | 18053 | 841 | 33 |
441417 | 441417 | 2020-08-17 | Grant | Indiana | 18053 | 833 | 33 |
438191 | 438191 | 2020-08-16 | Grant | Indiana | 18053 | 829 | 33 |
434965 | 434965 | 2020-08-15 | Grant | Indiana | 18053 | 827 | 33 |
431740 | 431740 | 2020-08-14 | Grant | Indiana | 18053 | 814 | 33 |
428512 | 428512 | 2020-08-13 | Grant | Indiana | 18053 | 799 | 33 |
425288 | 425288 | 2020-08-12 | Grant | Indiana | 18053 | 786 | 33 |
422067 | 422067 | 2020-08-11 | Grant | Indiana | 18053 | 783 | 33 |
418844 | 418844 | 2020-08-10 | Grant | Indiana | 18053 | 782 | 33 |
415623 | 415623 | 2020-08-09 | Grant | Indiana | 18053 | 780 | 33 |
412403 | 412403 | 2020-08-08 | Grant | Indiana | 18053 | 780 | 33 |
409184 | 409184 | 2020-08-07 | Grant | Indiana | 18053 | 775 | 33 |
405964 | 405964 | 2020-08-06 | Grant | Indiana | 18053 | 772 | 32 |
402746 | 402746 | 2020-08-05 | Grant | Indiana | 18053 | 760 | 32 |
399530 | 399530 | 2020-08-04 | Grant | Indiana | 18053 | 745 | 32 |
396314 | 396314 | 2020-08-03 | Grant | Indiana | 18053 | 734 | 32 |
393098 | 393098 | 2020-08-02 | Grant | Indiana | 18053 | 733 | 32 |
389881 | 389881 | 2020-08-01 | Grant | Indiana | 18053 | 711 | 32 |
386664 | 386664 | 2020-07-31 | Grant | Indiana | 18053 | 707 | 32 |
383446 | 383446 | 2020-07-30 | Grant | Indiana | 18053 | 702 | 32 |
380229 | 380229 | 2020-07-29 | Grant | Indiana | 18053 | 689 | 32 |
377012 | 377012 | 2020-07-28 | Grant | Indiana | 18053 | 681 | 32 |
373797 | 373797 | 2020-07-27 | Grant | Indiana | 18053 | 657 | 32 |
370585 | 370585 | 2020-07-26 | Grant | Indiana | 18053 | 655 | 32 |
367375 | 367375 | 2020-07-25 | Grant | Indiana | 18053 | 649 | 32 |
364168 | 364168 | 2020-07-24 | Grant | Indiana | 18053 | 627 | 32 |
360961 | 360961 | 2020-07-23 | Grant | Indiana | 18053 | 618 | 32 |
357756 | 357756 | 2020-07-22 | Grant | Indiana | 18053 | 604 | 31 |
354554 | 354554 | 2020-07-21 | Grant | Indiana | 18053 | 582 | 31 |
351352 | 351352 | 2020-07-20 | Grant | Indiana | 18053 | 572 | 30 |
348152 | 348152 | 2020-07-19 | Grant | Indiana | 18053 | 556 | 30 |
344951 | 344951 | 2020-07-18 | Grant | Indiana | 18053 | 542 | 30 |
341751 | 341751 | 2020-07-17 | Grant | Indiana | 18053 | 519 | 30 |
338555 | 338555 | 2020-07-16 | Grant | Indiana | 18053 | 512 | 30 |
335359 | 335359 | 2020-07-15 | Grant | Indiana | 18053 | 489 | 29 |
332166 | 332166 | 2020-07-14 | Grant | Indiana | 18053 | 476 | 29 |
328979 | 328979 | 2020-07-13 | Grant | Indiana | 18053 | 449 | 29 |
325793 | 325793 | 2020-07-12 | Grant | Indiana | 18053 | 449 | 29 |
322612 | 322612 | 2020-07-11 | Grant | Indiana | 18053 | 445 | 29 |
319433 | 319433 | 2020-07-10 | Grant | Indiana | 18053 | 428 | 29 |
316260 | 316260 | 2020-07-09 | Grant | Indiana | 18053 | 421 | 29 |
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);