ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
3,124 rows where county = "Ottawa" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date, date (date)
deaths 322 ✖
- 0 475
- 13 127
- 2 101
- 30 93
- 81 91
- 14 85
- 16 76
- 15 66
- 17 49
- 138 44
- 34 40
- 106 39
- 101 38
- 51 36
- 70 36
- 4 35
- 78 35
- 72 31
- 86 31
- 24 30
- 82 29
- 22 27
- 25 26
- 1 25
- 66 25
- 133 25
- 67 24
- 64 23
- 136 23
- 3 22
- 32 22
- 83 22
- 85 22
- 104 20
- 124 20
- 69 19
- 84 19
- 121 19
- 50 18
- 21 17
- 28 17
- 126 17
- 7 16
- 127 16
- 53 15
- 62 15
- 76 15
- 87 15
- 8 14
- 65 14
- 112 14
- 442 14
- 786 14
- 23 13
- 26 13
- 9 12
- 46 12
- 63 12
- 79 12
- 441 12
- 444 12
- 783 12
- 29 11
- 33 11
- 73 11
- 75 11
- 90 11
- 123 11
- 782 11
- 48 10
- 77 10
- 19 9
- 27 9
- 43 9
- 360 9
- 54 8
- 89 8
- 98 8
- 111 8
- 6 7
- 40 7
- 99 7
- 100 7
- 102 7
- 108 7
- 109 7
- 110 7
- 114 7
- 115 7
- 122 7
- 344 7
- 347 7
- 431 7
- 447 7
- 448 7
- 781 7
- 788 7
- 12 6
- 52 6
- 56 6
- 59 6
- 357 6
- 452 6
- 35 5
- 38 5
- 45 5
- 91 5
- 96 5
- 120 5
- 435 5
- 440 5
- 483 5
- 505 5
- 544 5
- 557 5
- 629 5
- 646 5
- 672 5
- 689 5
- 768 5
- 777 5
- 784 5
- 41 4
- 71 4
- 107 4
- 116 4
- 125 4
- 129 4
- 130 4
- 361 4
- 390 4
- 405 4
- 417 4
- 424 4
- 439 4
- 459 4
- 759 4
- 5 3
- 31 3
- 39 3
- 47 3
- 97 3
- 118 3
- 272 3
- 338 3
- 352 3
- 359 3
- 383 3
- 398 3
- 408 3
- 425 3
- 428 3
- 443 3
- 449 3
- 456 3
- 462 3
- 469 3
- 477 3
- 489 3
- 499 3
- 513 3
- 527 3
- 573 3
- 598 3
- 617 3
- 707 3
- 722 3
- 738 3
- 752 3
- 762 3
- 773 3
- 785 3
- 18 2
- 20 2
- 44 2
- 49 2
- 55 2
- 60 2
- 134 2
- 151 2
- 178 2
- 214 2
- 241 2
- 253 2
- 262 2
- 277 2
- 296 2
- 307 2
- 308 2
- 312 2
- 317 2
- 324 2
- 327 2
- 334 2
- 336 2
- 337 2
- 350 2
- 358 2
- 364 2
- 370 2
- 375 2
- 377 2
- 387 2
- 391 2
- 404 2
- 406 2
- 445 2
- 451 2
- 454 2
- 465 2
- 467 2
- 472 2
- 475 2
- 479 2
- 480 2
- 488 2
- 492 2
- 497 2
- 501 2
- 507 2
- 509 2
- 514 2
- 522 2
- 530 2
- 536 2
- 562 2
- 572 2
- 579 2
- 595 2
- 600 2
- 609 2
- 622 2
- 641 2
- 658 2
- 665 2
- 684 2
- 703 2
- 710 2
- 715 2
- 723 2
- 733 2
- 743 2
- 748 2
- 754 2
- 767 2
- 770 2
- 771 2
- 776 2
- 10 1
- 11 1
- 37 1
- 42 1
- 58 1
- 61 1
- 88 1
- 94 1
- 143 1
- 158 1
- 163 1
- 165 1
- 169 1
- 173 1
- 184 1
- 197 1
- 200 1
- 205 1
- 207 1
- 218 1
- 220 1
- 226 1
- 230 1
- 235 1
- 243 1
- 248 1
- 252 1
- 264 1
- 271 1
- 281 1
- 285 1
- 287 1
- 290 1
- 291 1
- 297 1
- 302 1
- 304 1
- 311 1
- 325 1
- 329 1
- 330 1
- 335 1
- 340 1
- 341 1
- 353 1
- 354 1
- 356 1
- 362 1
- 365 1
- 367 1
- 372 1
- 373 1
- 376 1
- 378 1
- 379 1
- 381 1
- 382 1
- 386 1
- 392 1
- 393 1
- 394 1
- 401 1
- 407 1
- 410 1
- 411 1
- 412 1
- 413 1
- 415 1
- 418 1
- 421 1
- 423 1
- 433 1
- 434 1
- 453 1
county 1
- Ottawa · 3,124 ✖
Link | rowid | date | county | state | fips | cases | deaths ▼ |
---|---|---|---|---|---|---|---|
2512 | 2512 | 2020-03-15 | Ottawa | Michigan | 26139 | 1 | 0 |
2962 | 2962 | 2020-03-16 | Ottawa | Michigan | 26139 | 1 | 0 |
3465 | 3465 | 2020-03-17 | Ottawa | Michigan | 26139 | 1 | 0 |
4048 | 4048 | 2020-03-18 | Ottawa | Michigan | 26139 | 1 | 0 |
4758 | 4758 | 2020-03-19 | Ottawa | Michigan | 26139 | 1 | 0 |
5577 | 5577 | 2020-03-20 | Ottawa | Michigan | 26139 | 1 | 0 |
6542 | 6542 | 2020-03-21 | Ottawa | Michigan | 26139 | 2 | 0 |
7622 | 7622 | 2020-03-22 | Ottawa | Michigan | 26139 | 6 | 0 |
8798 | 8798 | 2020-03-23 | Ottawa | Michigan | 26139 | 11 | 0 |
10092 | 10092 | 2020-03-24 | Ottawa | Michigan | 26139 | 15 | 0 |
11507 | 11507 | 2020-03-25 | Ottawa | Michigan | 26139 | 16 | 0 |
13094 | 13094 | 2020-03-26 | Ottawa | Michigan | 26139 | 18 | 0 |
13540 | 13540 | 2020-03-26 | Ottawa | Oklahoma | 40115 | 1 | 0 |
14601 | 14601 | 2020-03-27 | Ottawa | Kansas | 20143 | 1 | 0 |
14806 | 14806 | 2020-03-27 | Ottawa | Michigan | 26139 | 21 | 0 |
15283 | 15283 | 2020-03-27 | Ottawa | Oklahoma | 40115 | 1 | 0 |
16409 | 16409 | 2020-03-28 | Ottawa | Kansas | 20143 | 1 | 0 |
16627 | 16627 | 2020-03-28 | Ottawa | Michigan | 26139 | 23 | 0 |
17082 | 17082 | 2020-03-28 | Ottawa | Ohio | 39123 | 1 | 0 |
17130 | 17130 | 2020-03-28 | Ottawa | Oklahoma | 40115 | 4 | 0 |
18316 | 18316 | 2020-03-29 | Ottawa | Kansas | 20143 | 1 | 0 |
18543 | 18543 | 2020-03-29 | Ottawa | Michigan | 26139 | 25 | 0 |
19016 | 19016 | 2020-03-29 | Ottawa | Ohio | 39123 | 1 | 0 |
19065 | 19065 | 2020-03-29 | Ottawa | Oklahoma | 40115 | 4 | 0 |
20329 | 20329 | 2020-03-30 | Ottawa | Kansas | 20143 | 1 | 0 |
20562 | 20562 | 2020-03-30 | Ottawa | Michigan | 26139 | 28 | 0 |
21061 | 21061 | 2020-03-30 | Ottawa | Ohio | 39123 | 2 | 0 |
21115 | 21115 | 2020-03-30 | Ottawa | Oklahoma | 40115 | 6 | 0 |
22428 | 22428 | 2020-03-31 | Ottawa | Kansas | 20143 | 1 | 0 |
22674 | 22674 | 2020-03-31 | Ottawa | Michigan | 26139 | 31 | 0 |
23193 | 23193 | 2020-03-31 | Ottawa | Ohio | 39123 | 2 | 0 |
23248 | 23248 | 2020-03-31 | Ottawa | Oklahoma | 40115 | 7 | 0 |
24603 | 24603 | 2020-04-01 | Ottawa | Kansas | 20143 | 1 | 0 |
24854 | 24854 | 2020-04-01 | Ottawa | Michigan | 26139 | 31 | 0 |
25389 | 25389 | 2020-04-01 | Ottawa | Ohio | 39123 | 4 | 0 |
25445 | 25445 | 2020-04-01 | Ottawa | Oklahoma | 40115 | 7 | 0 |
26847 | 26847 | 2020-04-02 | Ottawa | Kansas | 20143 | 1 | 0 |
27107 | 27107 | 2020-04-02 | Ottawa | Michigan | 26139 | 35 | 0 |
27657 | 27657 | 2020-04-02 | Ottawa | Ohio | 39123 | 5 | 0 |
27717 | 27717 | 2020-04-02 | Ottawa | Oklahoma | 40115 | 8 | 0 |
29163 | 29163 | 2020-04-03 | Ottawa | Kansas | 20143 | 1 | 0 |
29426 | 29426 | 2020-04-03 | Ottawa | Michigan | 26139 | 37 | 0 |
29986 | 29986 | 2020-04-03 | Ottawa | Ohio | 39123 | 5 | 0 |
30049 | 30049 | 2020-04-03 | Ottawa | Oklahoma | 40115 | 8 | 0 |
31537 | 31537 | 2020-04-04 | Ottawa | Kansas | 20143 | 2 | 0 |
31804 | 31804 | 2020-04-04 | Ottawa | Michigan | 26139 | 39 | 0 |
32375 | 32375 | 2020-04-04 | Ottawa | Ohio | 39123 | 5 | 0 |
32438 | 32438 | 2020-04-04 | Ottawa | Oklahoma | 40115 | 10 | 0 |
33951 | 33951 | 2020-04-05 | Ottawa | Kansas | 20143 | 3 | 0 |
34229 | 34229 | 2020-04-05 | Ottawa | Michigan | 26139 | 44 | 0 |
34809 | 34809 | 2020-04-05 | Ottawa | Ohio | 39123 | 5 | 0 |
34872 | 34872 | 2020-04-05 | Ottawa | Oklahoma | 40115 | 11 | 0 |
36409 | 36409 | 2020-04-06 | Ottawa | Kansas | 20143 | 3 | 0 |
36688 | 36688 | 2020-04-06 | Ottawa | Michigan | 26139 | 44 | 0 |
37279 | 37279 | 2020-04-06 | Ottawa | Ohio | 39123 | 5 | 0 |
37346 | 37346 | 2020-04-06 | Ottawa | Oklahoma | 40115 | 12 | 0 |
38911 | 38911 | 2020-04-07 | Ottawa | Kansas | 20143 | 3 | 0 |
39197 | 39197 | 2020-04-07 | Ottawa | Michigan | 26139 | 52 | 0 |
39797 | 39797 | 2020-04-07 | Ottawa | Ohio | 39123 | 5 | 0 |
39867 | 39867 | 2020-04-07 | Ottawa | Oklahoma | 40115 | 14 | 0 |
41458 | 41458 | 2020-04-08 | Ottawa | Kansas | 20143 | 3 | 0 |
41749 | 41749 | 2020-04-08 | Ottawa | Michigan | 26139 | 55 | 0 |
42357 | 42357 | 2020-04-08 | Ottawa | Ohio | 39123 | 6 | 0 |
42427 | 42427 | 2020-04-08 | Ottawa | Oklahoma | 40115 | 15 | 0 |
44034 | 44034 | 2020-04-09 | Ottawa | Kansas | 20143 | 3 | 0 |
44943 | 44943 | 2020-04-09 | Ottawa | Ohio | 39123 | 8 | 0 |
45013 | 45013 | 2020-04-09 | Ottawa | Oklahoma | 40115 | 17 | 0 |
46641 | 46641 | 2020-04-10 | Ottawa | Kansas | 20143 | 3 | 0 |
47558 | 47558 | 2020-04-10 | Ottawa | Ohio | 39123 | 9 | 0 |
47630 | 47630 | 2020-04-10 | Ottawa | Oklahoma | 40115 | 17 | 0 |
49277 | 49277 | 2020-04-11 | Ottawa | Kansas | 20143 | 3 | 0 |
50214 | 50214 | 2020-04-11 | Ottawa | Ohio | 39123 | 10 | 0 |
50286 | 50286 | 2020-04-11 | Ottawa | Oklahoma | 40115 | 16 | 0 |
51942 | 51942 | 2020-04-12 | Ottawa | Kansas | 20143 | 3 | 0 |
52887 | 52887 | 2020-04-12 | Ottawa | Ohio | 39123 | 10 | 0 |
52959 | 52959 | 2020-04-12 | Ottawa | Oklahoma | 40115 | 18 | 0 |
54624 | 54624 | 2020-04-13 | Ottawa | Kansas | 20143 | 3 | 0 |
55571 | 55571 | 2020-04-13 | Ottawa | Ohio | 39123 | 11 | 0 |
55644 | 55644 | 2020-04-13 | Ottawa | Oklahoma | 40115 | 23 | 0 |
57318 | 57318 | 2020-04-14 | Ottawa | Kansas | 20143 | 3 | 0 |
58272 | 58272 | 2020-04-14 | Ottawa | Ohio | 39123 | 11 | 0 |
58346 | 58346 | 2020-04-14 | Ottawa | Oklahoma | 40115 | 22 | 0 |
60026 | 60026 | 2020-04-15 | Ottawa | Kansas | 20143 | 3 | 0 |
60987 | 60987 | 2020-04-15 | Ottawa | Ohio | 39123 | 12 | 0 |
61061 | 61061 | 2020-04-15 | Ottawa | Oklahoma | 40115 | 22 | 0 |
62747 | 62747 | 2020-04-16 | Ottawa | Kansas | 20143 | 3 | 0 |
63713 | 63713 | 2020-04-16 | Ottawa | Ohio | 39123 | 17 | 0 |
63787 | 63787 | 2020-04-16 | Ottawa | Oklahoma | 40115 | 24 | 0 |
65483 | 65483 | 2020-04-17 | Ottawa | Kansas | 20143 | 3 | 0 |
66456 | 66456 | 2020-04-17 | Ottawa | Ohio | 39123 | 21 | 0 |
66532 | 66532 | 2020-04-17 | Ottawa | Oklahoma | 40115 | 26 | 0 |
68232 | 68232 | 2020-04-18 | Ottawa | Kansas | 20143 | 3 | 0 |
69213 | 69213 | 2020-04-18 | Ottawa | Ohio | 39123 | 27 | 0 |
69290 | 69290 | 2020-04-18 | Ottawa | Oklahoma | 40115 | 27 | 0 |
70993 | 70993 | 2020-04-19 | Ottawa | Kansas | 20143 | 3 | 0 |
71980 | 71980 | 2020-04-19 | Ottawa | Ohio | 39123 | 27 | 0 |
72057 | 72057 | 2020-04-19 | Ottawa | Oklahoma | 40115 | 27 | 0 |
73765 | 73765 | 2020-04-20 | Ottawa | Kansas | 20143 | 3 | 0 |
74755 | 74755 | 2020-04-20 | Ottawa | Ohio | 39123 | 29 | 0 |
74832 | 74832 | 2020-04-20 | Ottawa | Oklahoma | 40115 | 27 | 0 |
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);