ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 18057 and state = "Indiana" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2444 | 2444 | 2020-03-15 | Hamilton | Indiana | 18057 | 1 | 0 |
2889 | 2889 | 2020-03-16 | Hamilton | Indiana | 18057 | 1 | 0 |
3379 | 3379 | 2020-03-17 | Hamilton | Indiana | 18057 | 1 | 0 |
3951 | 3951 | 2020-03-18 | Hamilton | Indiana | 18057 | 2 | 0 |
4627 | 4627 | 2020-03-19 | Hamilton | Indiana | 18057 | 2 | 0 |
5435 | 5435 | 2020-03-20 | Hamilton | Indiana | 18057 | 5 | 0 |
6372 | 6372 | 2020-03-21 | Hamilton | Indiana | 18057 | 10 | 0 |
7426 | 7426 | 2020-03-22 | Hamilton | Indiana | 18057 | 18 | 0 |
8584 | 8584 | 2020-03-23 | Hamilton | Indiana | 18057 | 21 | 0 |
9852 | 9852 | 2020-03-24 | Hamilton | Indiana | 18057 | 25 | 0 |
11246 | 11246 | 2020-03-25 | Hamilton | Indiana | 18057 | 30 | 0 |
12803 | 12803 | 2020-03-26 | Hamilton | Indiana | 18057 | 40 | 0 |
14484 | 14484 | 2020-03-27 | Hamilton | Indiana | 18057 | 53 | 0 |
16282 | 16282 | 2020-03-28 | Hamilton | Indiana | 18057 | 64 | 0 |
18185 | 18185 | 2020-03-29 | Hamilton | Indiana | 18057 | 83 | 0 |
20191 | 20191 | 2020-03-30 | Hamilton | Indiana | 18057 | 106 | 0 |
22285 | 22285 | 2020-03-31 | Hamilton | Indiana | 18057 | 127 | 0 |
24455 | 24455 | 2020-04-01 | Hamilton | Indiana | 18057 | 179 | 4 |
26694 | 26694 | 2020-04-02 | Hamilton | Indiana | 18057 | 207 | 4 |
29004 | 29004 | 2020-04-03 | Hamilton | Indiana | 18057 | 220 | 4 |
31370 | 31370 | 2020-04-04 | Hamilton | Indiana | 18057 | 265 | 4 |
33781 | 33781 | 2020-04-05 | Hamilton | Indiana | 18057 | 300 | 5 |
36234 | 36234 | 2020-04-06 | Hamilton | Indiana | 18057 | 335 | 5 |
38732 | 38732 | 2020-04-07 | Hamilton | Indiana | 18057 | 363 | 10 |
41278 | 41278 | 2020-04-08 | Hamilton | Indiana | 18057 | 392 | 15 |
43854 | 43854 | 2020-04-09 | Hamilton | Indiana | 18057 | 395 | 16 |
46458 | 46458 | 2020-04-10 | Hamilton | Indiana | 18057 | 431 | 19 |
49092 | 49092 | 2020-04-11 | Hamilton | Indiana | 18057 | 444 | 23 |
51755 | 51755 | 2020-04-12 | Hamilton | Indiana | 18057 | 479 | 24 |
54436 | 54436 | 2020-04-13 | Hamilton | Indiana | 18057 | 491 | 25 |
57129 | 57129 | 2020-04-14 | Hamilton | Indiana | 18057 | 500 | 28 |
59837 | 59837 | 2020-04-15 | Hamilton | Indiana | 18057 | 511 | 28 |
62558 | 62558 | 2020-04-16 | Hamilton | Indiana | 18057 | 521 | 30 |
65292 | 65292 | 2020-04-17 | Hamilton | Indiana | 18057 | 543 | 32 |
68041 | 68041 | 2020-04-18 | Hamilton | Indiana | 18057 | 564 | 36 |
70803 | 70803 | 2020-04-19 | Hamilton | Indiana | 18057 | 584 | 36 |
73574 | 73574 | 2020-04-20 | Hamilton | Indiana | 18057 | 599 | 36 |
76351 | 76351 | 2020-04-21 | Hamilton | Indiana | 18057 | 617 | 40 |
79135 | 79135 | 2020-04-22 | Hamilton | Indiana | 18057 | 626 | 42 |
81928 | 81928 | 2020-04-23 | Hamilton | Indiana | 18057 | 649 | 43 |
84728 | 84728 | 2020-04-24 | Hamilton | Indiana | 18057 | 675 | 46 |
87538 | 87538 | 2020-04-25 | Hamilton | Indiana | 18057 | 704 | 52 |
90354 | 90354 | 2020-04-26 | Hamilton | Indiana | 18057 | 709 | 53 |
93173 | 93173 | 2020-04-27 | Hamilton | Indiana | 18057 | 725 | 53 |
96005 | 96005 | 2020-04-28 | Hamilton | Indiana | 18057 | 735 | 60 |
98849 | 98849 | 2020-04-29 | Hamilton | Indiana | 18057 | 752 | 62 |
101700 | 101700 | 2020-04-30 | Hamilton | Indiana | 18057 | 762 | 64 |
104556 | 104556 | 2020-05-01 | Hamilton | Indiana | 18057 | 802 | 70 |
107421 | 107421 | 2020-05-02 | Hamilton | Indiana | 18057 | 818 | 71 |
110291 | 110291 | 2020-05-03 | Hamilton | Indiana | 18057 | 832 | 72 |
113166 | 113166 | 2020-05-04 | Hamilton | Indiana | 18057 | 853 | 75 |
116049 | 116049 | 2020-05-05 | Hamilton | Indiana | 18057 | 867 | 77 |
119009 | 119009 | 2020-05-06 | Hamilton | Indiana | 18057 | 890 | 80 |
121979 | 121979 | 2020-05-07 | Hamilton | Indiana | 18057 | 903 | 82 |
124959 | 124959 | 2020-05-08 | Hamilton | Indiana | 18057 | 913 | 82 |
127946 | 127946 | 2020-05-09 | Hamilton | Indiana | 18057 | 930 | 84 |
130937 | 130937 | 2020-05-10 | Hamilton | Indiana | 18057 | 935 | 84 |
133927 | 133927 | 2020-05-11 | Hamilton | Indiana | 18057 | 946 | 86 |
136916 | 136916 | 2020-05-12 | Hamilton | Indiana | 18057 | 966 | 88 |
139908 | 139908 | 2020-05-13 | Hamilton | Indiana | 18057 | 970 | 88 |
142904 | 142904 | 2020-05-14 | Hamilton | Indiana | 18057 | 978 | 88 |
145904 | 145904 | 2020-05-15 | Hamilton | Indiana | 18057 | 987 | 91 |
148908 | 148908 | 2020-05-16 | Hamilton | Indiana | 18057 | 1012 | 95 |
151917 | 151917 | 2020-05-17 | Hamilton | Indiana | 18057 | 1032 | 95 |
154929 | 154929 | 2020-05-18 | Hamilton | Indiana | 18057 | 1044 | 95 |
157945 | 157945 | 2020-05-19 | Hamilton | Indiana | 18057 | 1055 | 97 |
160971 | 160971 | 2020-05-20 | Hamilton | Indiana | 18057 | 1067 | 96 |
163999 | 163999 | 2020-05-21 | Hamilton | Indiana | 18057 | 1084 | 96 |
167032 | 167032 | 2020-05-22 | Hamilton | Indiana | 18057 | 1097 | 96 |
170069 | 170069 | 2020-05-23 | Hamilton | Indiana | 18057 | 1105 | 96 |
173110 | 173110 | 2020-05-24 | Hamilton | Indiana | 18057 | 1109 | 96 |
176154 | 176154 | 2020-05-25 | Hamilton | Indiana | 18057 | 1112 | 97 |
179198 | 179198 | 2020-05-26 | Hamilton | Indiana | 18057 | 1128 | 97 |
182242 | 182242 | 2020-05-27 | Hamilton | Indiana | 18057 | 1136 | 96 |
185296 | 185296 | 2020-05-28 | Hamilton | Indiana | 18057 | 1146 | 98 |
188354 | 188354 | 2020-05-29 | Hamilton | Indiana | 18057 | 1170 | 99 |
191419 | 191419 | 2020-05-30 | Hamilton | Indiana | 18057 | 1168 | 99 |
194486 | 194486 | 2020-05-31 | Hamilton | Indiana | 18057 | 1173 | 99 |
197556 | 197556 | 2020-06-01 | Hamilton | Indiana | 18057 | 1176 | 99 |
200629 | 200629 | 2020-06-02 | Hamilton | Indiana | 18057 | 1184 | 99 |
203705 | 203705 | 2020-06-03 | Hamilton | Indiana | 18057 | 1194 | 100 |
206785 | 206785 | 2020-06-04 | Hamilton | Indiana | 18057 | 1197 | 100 |
209866 | 209866 | 2020-06-05 | Hamilton | Indiana | 18057 | 1205 | 100 |
212951 | 212951 | 2020-06-06 | Hamilton | Indiana | 18057 | 1217 | 100 |
216038 | 216038 | 2020-06-07 | Hamilton | Indiana | 18057 | 1219 | 100 |
219130 | 219130 | 2020-06-08 | Hamilton | Indiana | 18057 | 1223 | 100 |
222225 | 222225 | 2020-06-09 | Hamilton | Indiana | 18057 | 1234 | 99 |
225320 | 225320 | 2020-06-10 | Hamilton | Indiana | 18057 | 1255 | 100 |
228422 | 228422 | 2020-06-11 | Hamilton | Indiana | 18057 | 1258 | 100 |
231525 | 231525 | 2020-06-12 | Hamilton | Indiana | 18057 | 1263 | 101 |
234631 | 234631 | 2020-06-13 | Hamilton | Indiana | 18057 | 1270 | 101 |
237738 | 237738 | 2020-06-14 | Hamilton | Indiana | 18057 | 1290 | 101 |
240846 | 240846 | 2020-06-15 | Hamilton | Indiana | 18057 | 1370 | 101 |
243957 | 243957 | 2020-06-16 | Hamilton | Indiana | 18057 | 1381 | 101 |
247070 | 247070 | 2020-06-17 | Hamilton | Indiana | 18057 | 1384 | 101 |
250182 | 250182 | 2020-06-18 | Hamilton | Indiana | 18057 | 1362 | 101 |
253297 | 253297 | 2020-06-19 | Hamilton | Indiana | 18057 | 1372 | 101 |
256417 | 256417 | 2020-06-20 | Hamilton | Indiana | 18057 | 1378 | 102 |
259543 | 259543 | 2020-06-21 | Hamilton | Indiana | 18057 | 1382 | 102 |
262670 | 262670 | 2020-06-22 | Hamilton | Indiana | 18057 | 1387 | 102 |
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);