ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
794 rows where fips = 18081 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 286 ✖
- 126 41
- 406 24
- 613 23
- 131 18
- 398 13
- 390 12
- 125 11
- 128 11
- 385 11
- 475 11
- 3 10
- 122 10
- 136 10
- 614 10
- 169 8
- 400 8
- 1 7
- 127 7
- 133 7
- 384 7
- 391 7
- 397 7
- 405 7
- 407 7
- 408 7
- 413 7
- 578 7
- 0 6
- 379 6
- 382 6
- 387 6
- 411 6
- 482 6
- 608 6
- 129 5
- 395 5
- 412 5
- 424 5
- 451 5
- 467 5
- 498 5
- 499 5
- 508 5
- 603 5
- 612 5
- 615 5
- 115 4
- 132 4
- 135 4
- 356 4
- 416 4
- 418 4
- 428 4
- 433 4
- 445 4
- 464 4
- 490 4
- 553 4
- 576 4
- 595 4
- 599 4
- 6 3
- 99 3
- 107 3
- 109 3
- 134 3
- 137 3
- 167 3
- 178 3
- 204 3
- 306 3
- 307 3
- 309 3
- 358 3
- 375 3
- 414 3
- 435 3
- 436 3
- 459 3
- 478 3
- 484 3
- 486 3
- 522 3
- 540 3
- 566 3
- 589 3
- 594 3
- 604 3
- 606 3
- 610 3
- 21 2
- 32 2
- 53 2
- 77 2
- 81 2
- 89 2
- 96 2
- 118 2
- 123 2
- 124 2
- 138 2
- 139 2
- 140 2
- 161 2
- 163 2
- 170 2
- 174 2
- 186 2
- 194 2
- 216 2
- 227 2
- 233 2
- 252 2
- 295 2
- 300 2
- 352 2
- 360 2
- 371 2
- 389 2
- 392 2
- 393 2
- 409 2
- 422 2
- 463 2
- 476 2
- 487 2
- 495 2
- 513 2
- 586 2
- 600 2
- 607 2
- 4 1
- 7 1
- 8 1
- 11 1
- 17 1
- 20 1
- 23 1
- 27 1
- 35 1
- 36 1
- 37 1
- 43 1
- 44 1
- 47 1
- 55 1
- 56 1
- 60 1
- 66 1
- 67 1
- 72 1
- 74 1
- 80 1
- 87 1
- 94 1
- 95 1
- 98 1
- 102 1
- 104 1
- 111 1
- 113 1
- 120 1
- 121 1
- 130 1
- 141 1
- 142 1
- 151 1
- 156 1
- 158 1
- 159 1
- 162 1
- 165 1
- 173 1
- 179 1
- 180 1
- 184 1
- 187 1
- 188 1
- 190 1
- 191 1
- 197 1
- 201 1
- 206 1
- 210 1
- 212 1
- 213 1
- 218 1
- 224 1
- 226 1
- 228 1
- 241 1
- 245 1
- 248 1
- 254 1
- 257 1
- 262 1
- 265 1
- 266 1
- 272 1
- 279 1
- 280 1
- 281 1
- 285 1
- 287 1
- 288 1
- 291 1
- 296 1
- 303 1
- 304 1
- 308 1
- 311 1
- 312 1
- 341 1
- 344 1
- 345 1
- 349 1
- 350 1
- 355 1
- 362 1
- 365 1
- 366 1
- 367 1
- 370 1
- 374 1
- 376 1
- 377 1
- 380 1
- 386 1
- 394 1
- 401 1
- 415 1
- 417 1
- 419 1
- 420 1
- 423 1
- 426 1
- 429 1
- 430 1
- 432 1
- 434 1
- 439 1
- 441 1
- 444 1
- 447 1
- 449 1
- 455 1
- 456 1
- 457 1
- 460 1
- 462 1
- 465 1
- 466 1
- 469 1
- 470 1
- 472 1
- 473 1
- 477 1
- 479 1
- 481 1
- 489 1
- 492 1
- 493 1
- 500 1
- 506 1
- 507 1
- 518 1
- 530 1
- 531 1
- 535 1
- 536 1
- 542 1
- 545 1
- 547 1
- 552 1
- 555 1
- 556 1
- 560 1
- 568 1
- 572 1
- 574 1
- 577 1
- 580 1
- 590 1
- 597 1
- 598 1
- 605 1
state 1
- Indiana 794
fips 1
- 18081 · 794 ✖
county 1
- Johnson 794
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
1237 | 1237 | 2020-03-11 | Johnson | Indiana | 18081 | 3 | 0 |
1451 | 1451 | 2020-03-12 | Johnson | Indiana | 18081 | 3 | 0 |
1722 | 1722 | 2020-03-13 | Johnson | Indiana | 18081 | 3 | 0 |
2053 | 2053 | 2020-03-14 | Johnson | Indiana | 18081 | 3 | 0 |
2447 | 2447 | 2020-03-15 | Johnson | Indiana | 18081 | 3 | 0 |
2892 | 2892 | 2020-03-16 | Johnson | Indiana | 18081 | 3 | 0 |
3382 | 3382 | 2020-03-17 | Johnson | Indiana | 18081 | 3 | 1 |
3955 | 3955 | 2020-03-18 | Johnson | Indiana | 18081 | 3 | 1 |
4631 | 4631 | 2020-03-19 | Johnson | Indiana | 18081 | 3 | 1 |
5439 | 5439 | 2020-03-20 | Johnson | Indiana | 18081 | 4 | 1 |
6378 | 6378 | 2020-03-21 | Johnson | Indiana | 18081 | 7 | 1 |
7432 | 7432 | 2020-03-22 | Johnson | Indiana | 18081 | 12 | 1 |
8590 | 8590 | 2020-03-23 | Johnson | Indiana | 18081 | 14 | 1 |
9859 | 9859 | 2020-03-24 | Johnson | Indiana | 18081 | 18 | 3 |
11254 | 11254 | 2020-03-25 | Johnson | Indiana | 18081 | 24 | 3 |
12811 | 12811 | 2020-03-26 | Johnson | Indiana | 18081 | 36 | 3 |
14494 | 14494 | 2020-03-27 | Johnson | Indiana | 18081 | 42 | 3 |
16292 | 16292 | 2020-03-28 | Johnson | Indiana | 18081 | 52 | 3 |
18195 | 18195 | 2020-03-29 | Johnson | Indiana | 18081 | 71 | 3 |
20201 | 20201 | 2020-03-30 | Johnson | Indiana | 18081 | 81 | 3 |
22296 | 22296 | 2020-03-31 | Johnson | Indiana | 18081 | 101 | 3 |
24467 | 24467 | 2020-04-01 | Johnson | Indiana | 18081 | 118 | 3 |
26706 | 26706 | 2020-04-02 | Johnson | Indiana | 18081 | 126 | 3 |
29016 | 29016 | 2020-04-03 | Johnson | Indiana | 18081 | 136 | 4 |
31382 | 31382 | 2020-04-04 | Johnson | Indiana | 18081 | 153 | 6 |
33793 | 33793 | 2020-04-05 | Johnson | Indiana | 18081 | 167 | 6 |
36246 | 36246 | 2020-04-06 | Johnson | Indiana | 18081 | 195 | 6 |
38744 | 38744 | 2020-04-07 | Johnson | Indiana | 18081 | 212 | 7 |
41290 | 41290 | 2020-04-08 | Johnson | Indiana | 18081 | 230 | 8 |
43866 | 43866 | 2020-04-09 | Johnson | Indiana | 18081 | 248 | 11 |
46470 | 46470 | 2020-04-10 | Johnson | Indiana | 18081 | 271 | 17 |
49104 | 49104 | 2020-04-11 | Johnson | Indiana | 18081 | 288 | 20 |
51767 | 51767 | 2020-04-12 | Johnson | Indiana | 18081 | 318 | 21 |
54448 | 54448 | 2020-04-13 | Johnson | Indiana | 18081 | 328 | 21 |
57141 | 57141 | 2020-04-14 | Johnson | Indiana | 18081 | 331 | 23 |
59849 | 59849 | 2020-04-15 | Johnson | Indiana | 18081 | 349 | 27 |
62570 | 62570 | 2020-04-16 | Johnson | Indiana | 18081 | 360 | 32 |
65304 | 65304 | 2020-04-17 | Johnson | Indiana | 18081 | 373 | 32 |
68053 | 68053 | 2020-04-18 | Johnson | Indiana | 18081 | 397 | 35 |
70815 | 70815 | 2020-04-19 | Johnson | Indiana | 18081 | 415 | 36 |
73586 | 73586 | 2020-04-20 | Johnson | Indiana | 18081 | 430 | 37 |
76363 | 76363 | 2020-04-21 | Johnson | Indiana | 18081 | 455 | 43 |
79147 | 79147 | 2020-04-22 | Johnson | Indiana | 18081 | 460 | 44 |
81940 | 81940 | 2020-04-23 | Johnson | Indiana | 18081 | 482 | 47 |
84740 | 84740 | 2020-04-24 | Johnson | Indiana | 18081 | 516 | 53 |
87550 | 87550 | 2020-04-25 | Johnson | Indiana | 18081 | 535 | 55 |
90366 | 90366 | 2020-04-26 | Johnson | Indiana | 18081 | 538 | 56 |
93185 | 93185 | 2020-04-27 | Johnson | Indiana | 18081 | 543 | 53 |
96017 | 96017 | 2020-04-28 | Johnson | Indiana | 18081 | 553 | 60 |
98861 | 98861 | 2020-04-29 | Johnson | Indiana | 18081 | 570 | 66 |
101712 | 101712 | 2020-04-30 | Johnson | Indiana | 18081 | 588 | 67 |
104568 | 104568 | 2020-05-01 | Johnson | Indiana | 18081 | 625 | 72 |
107433 | 107433 | 2020-05-02 | Johnson | Indiana | 18081 | 677 | 74 |
110303 | 110303 | 2020-05-03 | Johnson | Indiana | 18081 | 715 | 77 |
113178 | 113178 | 2020-05-04 | Johnson | Indiana | 18081 | 727 | 77 |
116061 | 116061 | 2020-05-05 | Johnson | Indiana | 18081 | 739 | 80 |
119021 | 119021 | 2020-05-06 | Johnson | Indiana | 18081 | 756 | 81 |
121991 | 121991 | 2020-05-07 | Johnson | Indiana | 18081 | 768 | 81 |
124971 | 124971 | 2020-05-08 | Johnson | Indiana | 18081 | 783 | 87 |
127958 | 127958 | 2020-05-09 | Johnson | Indiana | 18081 | 805 | 89 |
130949 | 130949 | 2020-05-10 | Johnson | Indiana | 18081 | 822 | 89 |
133939 | 133939 | 2020-05-11 | Johnson | Indiana | 18081 | 842 | 94 |
136928 | 136928 | 2020-05-12 | Johnson | Indiana | 18081 | 856 | 95 |
139920 | 139920 | 2020-05-13 | Johnson | Indiana | 18081 | 858 | 96 |
142916 | 142916 | 2020-05-14 | Johnson | Indiana | 18081 | 972 | 96 |
145916 | 145916 | 2020-05-15 | Johnson | Indiana | 18081 | 983 | 98 |
148920 | 148920 | 2020-05-16 | Johnson | Indiana | 18081 | 1004 | 99 |
151929 | 151929 | 2020-05-17 | Johnson | Indiana | 18081 | 1016 | 99 |
154941 | 154941 | 2020-05-18 | Johnson | Indiana | 18081 | 1026 | 99 |
157957 | 157957 | 2020-05-19 | Johnson | Indiana | 18081 | 1041 | 102 |
160983 | 160983 | 2020-05-20 | Johnson | Indiana | 18081 | 1053 | 104 |
164011 | 164011 | 2020-05-21 | Johnson | Indiana | 18081 | 1074 | 107 |
167044 | 167044 | 2020-05-22 | Johnson | Indiana | 18081 | 1077 | 107 |
170081 | 170081 | 2020-05-23 | Johnson | Indiana | 18081 | 1090 | 107 |
173122 | 173122 | 2020-05-24 | Johnson | Indiana | 18081 | 1105 | 109 |
176166 | 176166 | 2020-05-25 | Johnson | Indiana | 18081 | 1107 | 109 |
179210 | 179210 | 2020-05-26 | Johnson | Indiana | 18081 | 1111 | 109 |
182254 | 182254 | 2020-05-27 | Johnson | Indiana | 18081 | 1119 | 111 |
185308 | 185308 | 2020-05-28 | Johnson | Indiana | 18081 | 1121 | 113 |
188366 | 188366 | 2020-05-29 | Johnson | Indiana | 18081 | 1121 | 115 |
191431 | 191431 | 2020-05-30 | Johnson | Indiana | 18081 | 1125 | 115 |
194498 | 194498 | 2020-05-31 | Johnson | Indiana | 18081 | 1133 | 115 |
197568 | 197568 | 2020-06-01 | Johnson | Indiana | 18081 | 1142 | 115 |
200641 | 200641 | 2020-06-02 | Johnson | Indiana | 18081 | 1144 | 118 |
203717 | 203717 | 2020-06-03 | Johnson | Indiana | 18081 | 1147 | 118 |
206797 | 206797 | 2020-06-04 | Johnson | Indiana | 18081 | 1148 | 120 |
209878 | 209878 | 2020-06-05 | Johnson | Indiana | 18081 | 1152 | 121 |
212963 | 212963 | 2020-06-06 | Johnson | Indiana | 18081 | 1156 | 122 |
216050 | 216050 | 2020-06-07 | Johnson | Indiana | 18081 | 1160 | 122 |
219142 | 219142 | 2020-06-08 | Johnson | Indiana | 18081 | 1166 | 122 |
222237 | 222237 | 2020-06-09 | Johnson | Indiana | 18081 | 1172 | 122 |
225332 | 225332 | 2020-06-10 | Johnson | Indiana | 18081 | 1183 | 122 |
228434 | 228434 | 2020-06-11 | Johnson | Indiana | 18081 | 1185 | 122 |
231537 | 231537 | 2020-06-12 | Johnson | Indiana | 18081 | 1188 | 122 |
234643 | 234643 | 2020-06-13 | Johnson | Indiana | 18081 | 1196 | 122 |
237750 | 237750 | 2020-06-14 | Johnson | Indiana | 18081 | 1196 | 122 |
240858 | 240858 | 2020-06-15 | Johnson | Indiana | 18081 | 1200 | 122 |
243969 | 243969 | 2020-06-16 | Johnson | Indiana | 18081 | 1202 | 123 |
247082 | 247082 | 2020-06-17 | Johnson | Indiana | 18081 | 1205 | 123 |
250194 | 250194 | 2020-06-18 | Johnson | Indiana | 18081 | 1213 | 124 |
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);