ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
791 rows where fips = 18179 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1093245 | 1093245 | 2021-03-06 | Wells | Indiana | 18179 | 2618 | 79 |
1089999 | 1089999 | 2021-03-05 | Wells | Indiana | 18179 | 2617 | 79 |
1086754 | 1086754 | 2021-03-04 | Wells | Indiana | 18179 | 2614 | 79 |
1083508 | 1083508 | 2021-03-03 | Wells | Indiana | 18179 | 2611 | 79 |
1080262 | 1080262 | 2021-03-02 | Wells | Indiana | 18179 | 2609 | 79 |
1077017 | 1077017 | 2021-03-01 | Wells | Indiana | 18179 | 2608 | 79 |
1073771 | 1073771 | 2021-02-28 | Wells | Indiana | 18179 | 2608 | 78 |
1070525 | 1070525 | 2021-02-27 | Wells | Indiana | 18179 | 2602 | 78 |
1067280 | 1067280 | 2021-02-26 | Wells | Indiana | 18179 | 2597 | 78 |
1064035 | 1064035 | 2021-02-25 | Wells | Indiana | 18179 | 2591 | 78 |
1060790 | 1060790 | 2021-02-24 | Wells | Indiana | 18179 | 2586 | 78 |
1057544 | 1057544 | 2021-02-23 | Wells | Indiana | 18179 | 2579 | 78 |
1054298 | 1054298 | 2021-02-22 | Wells | Indiana | 18179 | 2574 | 78 |
1051051 | 1051051 | 2021-02-21 | Wells | Indiana | 18179 | 2570 | 78 |
1047804 | 1047804 | 2021-02-20 | Wells | Indiana | 18179 | 2563 | 78 |
1044559 | 1044559 | 2021-02-19 | Wells | Indiana | 18179 | 2553 | 78 |
1041314 | 1041314 | 2021-02-18 | Wells | Indiana | 18179 | 2540 | 77 |
1038069 | 1038069 | 2021-02-17 | Wells | Indiana | 18179 | 2538 | 77 |
1034824 | 1034824 | 2021-02-16 | Wells | Indiana | 18179 | 2535 | 77 |
1031578 | 1031578 | 2021-02-15 | Wells | Indiana | 18179 | 2518 | 75 |
1028331 | 1028331 | 2021-02-14 | Wells | Indiana | 18179 | 2517 | 75 |
1025086 | 1025086 | 2021-02-13 | Wells | Indiana | 18179 | 2510 | 75 |
1021841 | 1021841 | 2021-02-12 | Wells | Indiana | 18179 | 2505 | 75 |
1018596 | 1018596 | 2021-02-11 | Wells | Indiana | 18179 | 2494 | 73 |
1015351 | 1015351 | 2021-02-10 | Wells | Indiana | 18179 | 2487 | 73 |
1012106 | 1012106 | 2021-02-09 | Wells | Indiana | 18179 | 2480 | 72 |
1008860 | 1008860 | 2021-02-08 | Wells | Indiana | 18179 | 2475 | 72 |
1005614 | 1005614 | 2021-02-07 | Wells | Indiana | 18179 | 2468 | 71 |
1002368 | 1002368 | 2021-02-06 | Wells | Indiana | 18179 | 2464 | 68 |
999122 | 999122 | 2021-02-05 | Wells | Indiana | 18179 | 2453 | 67 |
995876 | 995876 | 2021-02-04 | Wells | Indiana | 18179 | 2448 | 67 |
992630 | 992630 | 2021-02-03 | Wells | Indiana | 18179 | 2438 | 56 |
989384 | 989384 | 2021-02-02 | Wells | Indiana | 18179 | 2436 | 56 |
986137 | 986137 | 2021-02-01 | Wells | Indiana | 18179 | 2433 | 56 |
982890 | 982890 | 2021-01-31 | Wells | Indiana | 18179 | 2423 | 56 |
979644 | 979644 | 2021-01-30 | Wells | Indiana | 18179 | 2420 | 56 |
976398 | 976398 | 2021-01-29 | Wells | Indiana | 18179 | 2414 | 55 |
973153 | 973153 | 2021-01-28 | Wells | Indiana | 18179 | 2410 | 55 |
969908 | 969908 | 2021-01-27 | Wells | Indiana | 18179 | 2404 | 55 |
966664 | 966664 | 2021-01-26 | Wells | Indiana | 18179 | 2400 | 54 |
963419 | 963419 | 2021-01-25 | Wells | Indiana | 18179 | 2394 | 54 |
960174 | 960174 | 2021-01-24 | Wells | Indiana | 18179 | 2389 | 54 |
956928 | 956928 | 2021-01-23 | Wells | Indiana | 18179 | 2385 | 54 |
953683 | 953683 | 2021-01-22 | Wells | Indiana | 18179 | 2365 | 53 |
950438 | 950438 | 2021-01-21 | Wells | Indiana | 18179 | 2358 | 53 |
947192 | 947192 | 2021-01-20 | Wells | Indiana | 18179 | 2347 | 50 |
943945 | 943945 | 2021-01-19 | Wells | Indiana | 18179 | 2338 | 50 |
940700 | 940700 | 2021-01-18 | Wells | Indiana | 18179 | 2326 | 50 |
937455 | 937455 | 2021-01-17 | Wells | Indiana | 18179 | 2319 | 50 |
934210 | 934210 | 2021-01-16 | Wells | Indiana | 18179 | 2310 | 50 |
930965 | 930965 | 2021-01-15 | Wells | Indiana | 18179 | 2296 | 49 |
927720 | 927720 | 2021-01-14 | Wells | Indiana | 18179 | 2276 | 49 |
924474 | 924474 | 2021-01-13 | Wells | Indiana | 18179 | 2260 | 49 |
921229 | 921229 | 2021-01-12 | Wells | Indiana | 18179 | 2232 | 49 |
917984 | 917984 | 2021-01-11 | Wells | Indiana | 18179 | 2206 | 48 |
914739 | 914739 | 2021-01-10 | Wells | Indiana | 18179 | 2205 | 48 |
911494 | 911494 | 2021-01-09 | Wells | Indiana | 18179 | 2133 | 48 |
908249 | 908249 | 2021-01-08 | Wells | Indiana | 18179 | 2112 | 48 |
905003 | 905003 | 2021-01-07 | Wells | Indiana | 18179 | 2099 | 48 |
901758 | 901758 | 2021-01-06 | Wells | Indiana | 18179 | 2077 | 48 |
898513 | 898513 | 2021-01-05 | Wells | Indiana | 18179 | 2051 | 48 |
895268 | 895268 | 2021-01-04 | Wells | Indiana | 18179 | 2015 | 48 |
892021 | 892021 | 2021-01-03 | Wells | Indiana | 18179 | 2000 | 48 |
888775 | 888775 | 2021-01-02 | Wells | Indiana | 18179 | 1993 | 48 |
885529 | 885529 | 2021-01-01 | Wells | Indiana | 18179 | 1960 | 48 |
882284 | 882284 | 2020-12-31 | Wells | Indiana | 18179 | 1945 | 48 |
879039 | 879039 | 2020-12-30 | Wells | Indiana | 18179 | 1932 | 48 |
875794 | 875794 | 2020-12-29 | Wells | Indiana | 18179 | 1909 | 48 |
872549 | 872549 | 2020-12-28 | Wells | Indiana | 18179 | 1888 | 48 |
869304 | 869304 | 2020-12-27 | Wells | Indiana | 18179 | 1885 | 48 |
866059 | 866059 | 2020-12-26 | Wells | Indiana | 18179 | 1884 | 48 |
862814 | 862814 | 2020-12-25 | Wells | Indiana | 18179 | 1878 | 48 |
859569 | 859569 | 2020-12-24 | Wells | Indiana | 18179 | 1868 | 48 |
856324 | 856324 | 2020-12-23 | Wells | Indiana | 18179 | 1858 | 48 |
853079 | 853079 | 2020-12-22 | Wells | Indiana | 18179 | 1840 | 48 |
849834 | 849834 | 2020-12-21 | Wells | Indiana | 18179 | 1830 | 48 |
846589 | 846589 | 2020-12-20 | Wells | Indiana | 18179 | 1823 | 47 |
843343 | 843343 | 2020-12-19 | Wells | Indiana | 18179 | 1807 | 47 |
840098 | 840098 | 2020-12-18 | Wells | Indiana | 18179 | 1790 | 46 |
836853 | 836853 | 2020-12-17 | Wells | Indiana | 18179 | 1764 | 46 |
833607 | 833607 | 2020-12-16 | Wells | Indiana | 18179 | 1749 | 46 |
830360 | 830360 | 2020-12-15 | Wells | Indiana | 18179 | 1717 | 46 |
827114 | 827114 | 2020-12-14 | Wells | Indiana | 18179 | 1701 | 45 |
823867 | 823867 | 2020-12-13 | Wells | Indiana | 18179 | 1697 | 45 |
820621 | 820621 | 2020-12-12 | Wells | Indiana | 18179 | 1682 | 45 |
817375 | 817375 | 2020-12-11 | Wells | Indiana | 18179 | 1654 | 45 |
814129 | 814129 | 2020-12-10 | Wells | Indiana | 18179 | 1639 | 42 |
810884 | 810884 | 2020-12-09 | Wells | Indiana | 18179 | 1624 | 42 |
807639 | 807639 | 2020-12-08 | Wells | Indiana | 18179 | 1604 | 42 |
804394 | 804394 | 2020-12-07 | Wells | Indiana | 18179 | 1576 | 41 |
801149 | 801149 | 2020-12-06 | Wells | Indiana | 18179 | 1564 | 41 |
797904 | 797904 | 2020-12-05 | Wells | Indiana | 18179 | 1544 | 40 |
794659 | 794659 | 2020-12-04 | Wells | Indiana | 18179 | 1495 | 38 |
791414 | 791414 | 2020-12-03 | Wells | Indiana | 18179 | 1474 | 37 |
788169 | 788169 | 2020-12-02 | Wells | Indiana | 18179 | 1449 | 35 |
784925 | 784925 | 2020-12-01 | Wells | Indiana | 18179 | 1416 | 35 |
781680 | 781680 | 2020-11-30 | Wells | Indiana | 18179 | 1394 | 32 |
778434 | 778434 | 2020-11-29 | Wells | Indiana | 18179 | 1370 | 32 |
775189 | 775189 | 2020-11-28 | Wells | Indiana | 18179 | 1347 | 32 |
771944 | 771944 | 2020-11-27 | Wells | Indiana | 18179 | 1325 | 32 |
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);