ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where county = "Johnson" and state = "Indiana" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
386678 | 386678 | 2020-07-31 | Johnson | Indiana | 18081 | 1650 | 126 |
383460 | 383460 | 2020-07-30 | Johnson | Indiana | 18081 | 1634 | 126 |
380243 | 380243 | 2020-07-29 | Johnson | Indiana | 18081 | 1620 | 126 |
377026 | 377026 | 2020-07-28 | Johnson | Indiana | 18081 | 1608 | 126 |
373811 | 373811 | 2020-07-27 | Johnson | Indiana | 18081 | 1587 | 126 |
370599 | 370599 | 2020-07-26 | Johnson | Indiana | 18081 | 1581 | 126 |
367389 | 367389 | 2020-07-25 | Johnson | Indiana | 18081 | 1561 | 126 |
364182 | 364182 | 2020-07-24 | Johnson | Indiana | 18081 | 1548 | 126 |
360975 | 360975 | 2020-07-23 | Johnson | Indiana | 18081 | 1523 | 126 |
357770 | 357770 | 2020-07-22 | Johnson | Indiana | 18081 | 1508 | 126 |
354568 | 354568 | 2020-07-21 | Johnson | Indiana | 18081 | 1496 | 126 |
351366 | 351366 | 2020-07-20 | Johnson | Indiana | 18081 | 1476 | 126 |
348166 | 348166 | 2020-07-19 | Johnson | Indiana | 18081 | 1464 | 126 |
344965 | 344965 | 2020-07-18 | Johnson | Indiana | 18081 | 1450 | 126 |
341765 | 341765 | 2020-07-17 | Johnson | Indiana | 18081 | 1437 | 126 |
338569 | 338569 | 2020-07-16 | Johnson | Indiana | 18081 | 1425 | 126 |
335373 | 335373 | 2020-07-15 | Johnson | Indiana | 18081 | 1410 | 126 |
332180 | 332180 | 2020-07-14 | Johnson | Indiana | 18081 | 1397 | 126 |
328993 | 328993 | 2020-07-13 | Johnson | Indiana | 18081 | 1381 | 126 |
325807 | 325807 | 2020-07-12 | Johnson | Indiana | 18081 | 1375 | 126 |
322626 | 322626 | 2020-07-11 | Johnson | Indiana | 18081 | 1370 | 126 |
319447 | 319447 | 2020-07-10 | Johnson | Indiana | 18081 | 1355 | 126 |
316274 | 316274 | 2020-07-09 | Johnson | Indiana | 18081 | 1336 | 126 |
313100 | 313100 | 2020-07-08 | Johnson | Indiana | 18081 | 1326 | 126 |
309930 | 309930 | 2020-07-07 | Johnson | Indiana | 18081 | 1317 | 125 |
306762 | 306762 | 2020-07-06 | Johnson | Indiana | 18081 | 1317 | 126 |
303597 | 303597 | 2020-07-05 | Johnson | Indiana | 18081 | 1307 | 126 |
300433 | 300433 | 2020-07-04 | Johnson | Indiana | 18081 | 1285 | 126 |
297271 | 297271 | 2020-07-03 | Johnson | Indiana | 18081 | 1283 | 126 |
294113 | 294113 | 2020-07-02 | Johnson | Indiana | 18081 | 1272 | 126 |
290959 | 290959 | 2020-07-01 | Johnson | Indiana | 18081 | 1263 | 126 |
287809 | 287809 | 2020-06-30 | Johnson | Indiana | 18081 | 1260 | 126 |
284660 | 284660 | 2020-06-29 | Johnson | Indiana | 18081 | 1259 | 125 |
281515 | 281515 | 2020-06-28 | Johnson | Indiana | 18081 | 1255 | 125 |
278367 | 278367 | 2020-06-27 | Johnson | Indiana | 18081 | 1248 | 125 |
275219 | 275219 | 2020-06-26 | Johnson | Indiana | 18081 | 1240 | 125 |
272077 | 272077 | 2020-06-25 | Johnson | Indiana | 18081 | 1233 | 125 |
268940 | 268940 | 2020-06-24 | Johnson | Indiana | 18081 | 1233 | 125 |
265810 | 265810 | 2020-06-23 | Johnson | Indiana | 18081 | 1233 | 125 |
262682 | 262682 | 2020-06-22 | Johnson | Indiana | 18081 | 1228 | 125 |
259555 | 259555 | 2020-06-21 | Johnson | Indiana | 18081 | 1228 | 125 |
256429 | 256429 | 2020-06-20 | Johnson | Indiana | 18081 | 1217 | 125 |
253309 | 253309 | 2020-06-19 | Johnson | Indiana | 18081 | 1213 | 124 |
250194 | 250194 | 2020-06-18 | Johnson | Indiana | 18081 | 1213 | 124 |
247082 | 247082 | 2020-06-17 | Johnson | Indiana | 18081 | 1205 | 123 |
243969 | 243969 | 2020-06-16 | Johnson | Indiana | 18081 | 1202 | 123 |
240858 | 240858 | 2020-06-15 | Johnson | Indiana | 18081 | 1200 | 122 |
237750 | 237750 | 2020-06-14 | Johnson | Indiana | 18081 | 1196 | 122 |
234643 | 234643 | 2020-06-13 | Johnson | Indiana | 18081 | 1196 | 122 |
231537 | 231537 | 2020-06-12 | Johnson | Indiana | 18081 | 1188 | 122 |
228434 | 228434 | 2020-06-11 | Johnson | Indiana | 18081 | 1185 | 122 |
225332 | 225332 | 2020-06-10 | Johnson | Indiana | 18081 | 1183 | 122 |
222237 | 222237 | 2020-06-09 | Johnson | Indiana | 18081 | 1172 | 122 |
219142 | 219142 | 2020-06-08 | Johnson | Indiana | 18081 | 1166 | 122 |
216050 | 216050 | 2020-06-07 | Johnson | Indiana | 18081 | 1160 | 122 |
212963 | 212963 | 2020-06-06 | Johnson | Indiana | 18081 | 1156 | 122 |
209878 | 209878 | 2020-06-05 | Johnson | Indiana | 18081 | 1152 | 121 |
206797 | 206797 | 2020-06-04 | Johnson | Indiana | 18081 | 1148 | 120 |
203717 | 203717 | 2020-06-03 | Johnson | Indiana | 18081 | 1147 | 118 |
200641 | 200641 | 2020-06-02 | Johnson | Indiana | 18081 | 1144 | 118 |
197568 | 197568 | 2020-06-01 | Johnson | Indiana | 18081 | 1142 | 115 |
194498 | 194498 | 2020-05-31 | Johnson | Indiana | 18081 | 1133 | 115 |
191431 | 191431 | 2020-05-30 | Johnson | Indiana | 18081 | 1125 | 115 |
188366 | 188366 | 2020-05-29 | Johnson | Indiana | 18081 | 1121 | 115 |
185308 | 185308 | 2020-05-28 | Johnson | Indiana | 18081 | 1121 | 113 |
182254 | 182254 | 2020-05-27 | Johnson | Indiana | 18081 | 1119 | 111 |
179210 | 179210 | 2020-05-26 | Johnson | Indiana | 18081 | 1111 | 109 |
176166 | 176166 | 2020-05-25 | Johnson | Indiana | 18081 | 1107 | 109 |
173122 | 173122 | 2020-05-24 | Johnson | Indiana | 18081 | 1105 | 109 |
170081 | 170081 | 2020-05-23 | Johnson | Indiana | 18081 | 1090 | 107 |
167044 | 167044 | 2020-05-22 | Johnson | Indiana | 18081 | 1077 | 107 |
164011 | 164011 | 2020-05-21 | Johnson | Indiana | 18081 | 1074 | 107 |
160983 | 160983 | 2020-05-20 | Johnson | Indiana | 18081 | 1053 | 104 |
157957 | 157957 | 2020-05-19 | Johnson | Indiana | 18081 | 1041 | 102 |
154941 | 154941 | 2020-05-18 | Johnson | Indiana | 18081 | 1026 | 99 |
151929 | 151929 | 2020-05-17 | Johnson | Indiana | 18081 | 1016 | 99 |
148920 | 148920 | 2020-05-16 | Johnson | Indiana | 18081 | 1004 | 99 |
145916 | 145916 | 2020-05-15 | Johnson | Indiana | 18081 | 983 | 98 |
142916 | 142916 | 2020-05-14 | Johnson | Indiana | 18081 | 972 | 96 |
139920 | 139920 | 2020-05-13 | Johnson | Indiana | 18081 | 858 | 96 |
136928 | 136928 | 2020-05-12 | Johnson | Indiana | 18081 | 856 | 95 |
133939 | 133939 | 2020-05-11 | Johnson | Indiana | 18081 | 842 | 94 |
130949 | 130949 | 2020-05-10 | Johnson | Indiana | 18081 | 822 | 89 |
127958 | 127958 | 2020-05-09 | Johnson | Indiana | 18081 | 805 | 89 |
124971 | 124971 | 2020-05-08 | Johnson | Indiana | 18081 | 783 | 87 |
121991 | 121991 | 2020-05-07 | Johnson | Indiana | 18081 | 768 | 81 |
119021 | 119021 | 2020-05-06 | Johnson | Indiana | 18081 | 756 | 81 |
116061 | 116061 | 2020-05-05 | Johnson | Indiana | 18081 | 739 | 80 |
113178 | 113178 | 2020-05-04 | Johnson | Indiana | 18081 | 727 | 77 |
110303 | 110303 | 2020-05-03 | Johnson | Indiana | 18081 | 715 | 77 |
107433 | 107433 | 2020-05-02 | Johnson | Indiana | 18081 | 677 | 74 |
104568 | 104568 | 2020-05-01 | Johnson | Indiana | 18081 | 625 | 72 |
101712 | 101712 | 2020-04-30 | Johnson | Indiana | 18081 | 588 | 67 |
98861 | 98861 | 2020-04-29 | Johnson | Indiana | 18081 | 570 | 66 |
96017 | 96017 | 2020-04-28 | Johnson | Indiana | 18081 | 553 | 60 |
93185 | 93185 | 2020-04-27 | Johnson | Indiana | 18081 | 543 | 53 |
90366 | 90366 | 2020-04-26 | Johnson | Indiana | 18081 | 538 | 56 |
87550 | 87550 | 2020-04-25 | Johnson | Indiana | 18081 | 535 | 55 |
84740 | 84740 | 2020-04-24 | Johnson | Indiana | 18081 | 516 | 53 |
81940 | 81940 | 2020-04-23 | Johnson | Indiana | 18081 | 482 | 47 |
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);