ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
778 rows where fips = 18135 and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1054276 | 1054276 | 2021-02-22 | Randolph | Indiana | 18135 | 2292 | 77 |
1051029 | 1051029 | 2021-02-21 | Randolph | Indiana | 18135 | 2291 | 76 |
1047782 | 1047782 | 2021-02-20 | Randolph | Indiana | 18135 | 2291 | 76 |
1044537 | 1044537 | 2021-02-19 | Randolph | Indiana | 18135 | 2285 | 76 |
1041292 | 1041292 | 2021-02-18 | Randolph | Indiana | 18135 | 2284 | 76 |
1038047 | 1038047 | 2021-02-17 | Randolph | Indiana | 18135 | 2284 | 75 |
1034802 | 1034802 | 2021-02-16 | Randolph | Indiana | 18135 | 2283 | 73 |
1031556 | 1031556 | 2021-02-15 | Randolph | Indiana | 18135 | 2281 | 72 |
1028309 | 1028309 | 2021-02-14 | Randolph | Indiana | 18135 | 2280 | 72 |
1025064 | 1025064 | 2021-02-13 | Randolph | Indiana | 18135 | 2277 | 72 |
1021819 | 1021819 | 2021-02-12 | Randolph | Indiana | 18135 | 2277 | 71 |
1018574 | 1018574 | 2021-02-11 | Randolph | Indiana | 18135 | 2275 | 71 |
1015329 | 1015329 | 2021-02-10 | Randolph | Indiana | 18135 | 2270 | 71 |
1012084 | 1012084 | 2021-02-09 | Randolph | Indiana | 18135 | 2268 | 71 |
1008838 | 1008838 | 2021-02-08 | Randolph | Indiana | 18135 | 2270 | 70 |
1005592 | 1005592 | 2021-02-07 | Randolph | Indiana | 18135 | 2256 | 69 |
1002346 | 1002346 | 2021-02-06 | Randolph | Indiana | 18135 | 2245 | 69 |
999100 | 999100 | 2021-02-05 | Randolph | Indiana | 18135 | 2243 | 69 |
995854 | 995854 | 2021-02-04 | Randolph | Indiana | 18135 | 2238 | 66 |
992608 | 992608 | 2021-02-03 | Randolph | Indiana | 18135 | 2234 | 49 |
989362 | 989362 | 2021-02-02 | Randolph | Indiana | 18135 | 2229 | 49 |
986115 | 986115 | 2021-02-01 | Randolph | Indiana | 18135 | 2225 | 49 |
982868 | 982868 | 2021-01-31 | Randolph | Indiana | 18135 | 2223 | 49 |
979622 | 979622 | 2021-01-30 | Randolph | Indiana | 18135 | 2216 | 49 |
976376 | 976376 | 2021-01-29 | Randolph | Indiana | 18135 | 2214 | 49 |
973131 | 973131 | 2021-01-28 | Randolph | Indiana | 18135 | 2209 | 49 |
969886 | 969886 | 2021-01-27 | Randolph | Indiana | 18135 | 2206 | 49 |
966642 | 966642 | 2021-01-26 | Randolph | Indiana | 18135 | 2200 | 49 |
963397 | 963397 | 2021-01-25 | Randolph | Indiana | 18135 | 2194 | 49 |
960152 | 960152 | 2021-01-24 | Randolph | Indiana | 18135 | 2191 | 49 |
956906 | 956906 | 2021-01-23 | Randolph | Indiana | 18135 | 2177 | 49 |
953661 | 953661 | 2021-01-22 | Randolph | Indiana | 18135 | 2170 | 49 |
950416 | 950416 | 2021-01-21 | Randolph | Indiana | 18135 | 2163 | 49 |
947170 | 947170 | 2021-01-20 | Randolph | Indiana | 18135 | 2145 | 46 |
943923 | 943923 | 2021-01-19 | Randolph | Indiana | 18135 | 2139 | 46 |
940678 | 940678 | 2021-01-18 | Randolph | Indiana | 18135 | 2131 | 42 |
937433 | 937433 | 2021-01-17 | Randolph | Indiana | 18135 | 2124 | 41 |
934188 | 934188 | 2021-01-16 | Randolph | Indiana | 18135 | 2116 | 41 |
930943 | 930943 | 2021-01-15 | Randolph | Indiana | 18135 | 2108 | 41 |
927698 | 927698 | 2021-01-14 | Randolph | Indiana | 18135 | 2090 | 41 |
924452 | 924452 | 2021-01-13 | Randolph | Indiana | 18135 | 2077 | 41 |
921207 | 921207 | 2021-01-12 | Randolph | Indiana | 18135 | 2061 | 41 |
917962 | 917962 | 2021-01-11 | Randolph | Indiana | 18135 | 2055 | 40 |
914717 | 914717 | 2021-01-10 | Randolph | Indiana | 18135 | 2047 | 40 |
911472 | 911472 | 2021-01-09 | Randolph | Indiana | 18135 | 2036 | 39 |
908227 | 908227 | 2021-01-08 | Randolph | Indiana | 18135 | 2000 | 38 |
904981 | 904981 | 2021-01-07 | Randolph | Indiana | 18135 | 1985 | 38 |
901736 | 901736 | 2021-01-06 | Randolph | Indiana | 18135 | 1948 | 38 |
898491 | 898491 | 2021-01-05 | Randolph | Indiana | 18135 | 1936 | 38 |
895246 | 895246 | 2021-01-04 | Randolph | Indiana | 18135 | 1932 | 37 |
891999 | 891999 | 2021-01-03 | Randolph | Indiana | 18135 | 1920 | 37 |
888753 | 888753 | 2021-01-02 | Randolph | Indiana | 18135 | 1910 | 36 |
885507 | 885507 | 2021-01-01 | Randolph | Indiana | 18135 | 1901 | 36 |
882262 | 882262 | 2020-12-31 | Randolph | Indiana | 18135 | 1881 | 35 |
879017 | 879017 | 2020-12-30 | Randolph | Indiana | 18135 | 1856 | 35 |
875772 | 875772 | 2020-12-29 | Randolph | Indiana | 18135 | 1855 | 34 |
872527 | 872527 | 2020-12-28 | Randolph | Indiana | 18135 | 1841 | 34 |
869282 | 869282 | 2020-12-27 | Randolph | Indiana | 18135 | 1839 | 34 |
866037 | 866037 | 2020-12-26 | Randolph | Indiana | 18135 | 1834 | 34 |
862792 | 862792 | 2020-12-25 | Randolph | Indiana | 18135 | 1830 | 34 |
859547 | 859547 | 2020-12-24 | Randolph | Indiana | 18135 | 1821 | 34 |
856302 | 856302 | 2020-12-23 | Randolph | Indiana | 18135 | 1798 | 33 |
853057 | 853057 | 2020-12-22 | Randolph | Indiana | 18135 | 1779 | 32 |
849812 | 849812 | 2020-12-21 | Randolph | Indiana | 18135 | 1779 | 32 |
846567 | 846567 | 2020-12-20 | Randolph | Indiana | 18135 | 1772 | 31 |
843321 | 843321 | 2020-12-19 | Randolph | Indiana | 18135 | 1760 | 30 |
840076 | 840076 | 2020-12-18 | Randolph | Indiana | 18135 | 1754 | 30 |
836831 | 836831 | 2020-12-17 | Randolph | Indiana | 18135 | 1735 | 30 |
833585 | 833585 | 2020-12-16 | Randolph | Indiana | 18135 | 1721 | 30 |
830338 | 830338 | 2020-12-15 | Randolph | Indiana | 18135 | 1698 | 28 |
827092 | 827092 | 2020-12-14 | Randolph | Indiana | 18135 | 1699 | 28 |
823845 | 823845 | 2020-12-13 | Randolph | Indiana | 18135 | 1692 | 28 |
820599 | 820599 | 2020-12-12 | Randolph | Indiana | 18135 | 1676 | 28 |
817353 | 817353 | 2020-12-11 | Randolph | Indiana | 18135 | 1650 | 28 |
814107 | 814107 | 2020-12-10 | Randolph | Indiana | 18135 | 1640 | 28 |
810862 | 810862 | 2020-12-09 | Randolph | Indiana | 18135 | 1602 | 27 |
807617 | 807617 | 2020-12-08 | Randolph | Indiana | 18135 | 1585 | 27 |
804372 | 804372 | 2020-12-07 | Randolph | Indiana | 18135 | 1565 | 25 |
801127 | 801127 | 2020-12-06 | Randolph | Indiana | 18135 | 1524 | 25 |
797882 | 797882 | 2020-12-05 | Randolph | Indiana | 18135 | 1512 | 25 |
794637 | 794637 | 2020-12-04 | Randolph | Indiana | 18135 | 1497 | 25 |
791392 | 791392 | 2020-12-03 | Randolph | Indiana | 18135 | 1477 | 24 |
788147 | 788147 | 2020-12-02 | Randolph | Indiana | 18135 | 1435 | 24 |
784903 | 784903 | 2020-12-01 | Randolph | Indiana | 18135 | 1408 | 23 |
781658 | 781658 | 2020-11-30 | Randolph | Indiana | 18135 | 1380 | 22 |
778412 | 778412 | 2020-11-29 | Randolph | Indiana | 18135 | 1366 | 22 |
775167 | 775167 | 2020-11-28 | Randolph | Indiana | 18135 | 1343 | 21 |
771922 | 771922 | 2020-11-27 | Randolph | Indiana | 18135 | 1321 | 21 |
768677 | 768677 | 2020-11-26 | Randolph | Indiana | 18135 | 1301 | 21 |
765431 | 765431 | 2020-11-25 | Randolph | Indiana | 18135 | 1285 | 19 |
762186 | 762186 | 2020-11-24 | Randolph | Indiana | 18135 | 1247 | 19 |
758941 | 758941 | 2020-11-23 | Randolph | Indiana | 18135 | 1218 | 19 |
755694 | 755694 | 2020-11-22 | Randolph | Indiana | 18135 | 1186 | 19 |
752448 | 752448 | 2020-11-21 | Randolph | Indiana | 18135 | 1166 | 18 |
749202 | 749202 | 2020-11-20 | Randolph | Indiana | 18135 | 1138 | 18 |
745956 | 745956 | 2020-11-19 | Randolph | Indiana | 18135 | 1084 | 16 |
742709 | 742709 | 2020-11-18 | Randolph | Indiana | 18135 | 1063 | 13 |
739462 | 739462 | 2020-11-17 | Randolph | Indiana | 18135 | 1032 | 13 |
736218 | 736218 | 2020-11-16 | Randolph | Indiana | 18135 | 988 | 13 |
732972 | 732972 | 2020-11-15 | Randolph | Indiana | 18135 | 972 | 13 |
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);