ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
790 rows where fips = 26139 sorted by state descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
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 |
14806 | 14806 | 2020-03-27 | Ottawa | Michigan | 26139 | 21 | 0 |
16627 | 16627 | 2020-03-28 | Ottawa | Michigan | 26139 | 23 | 0 |
18543 | 18543 | 2020-03-29 | Ottawa | Michigan | 26139 | 25 | 0 |
20562 | 20562 | 2020-03-30 | Ottawa | Michigan | 26139 | 28 | 0 |
22674 | 22674 | 2020-03-31 | Ottawa | Michigan | 26139 | 31 | 0 |
24854 | 24854 | 2020-04-01 | Ottawa | Michigan | 26139 | 31 | 0 |
27107 | 27107 | 2020-04-02 | Ottawa | Michigan | 26139 | 35 | 0 |
29426 | 29426 | 2020-04-03 | Ottawa | Michigan | 26139 | 37 | 0 |
31804 | 31804 | 2020-04-04 | Ottawa | Michigan | 26139 | 39 | 0 |
34229 | 34229 | 2020-04-05 | Ottawa | Michigan | 26139 | 44 | 0 |
36688 | 36688 | 2020-04-06 | Ottawa | Michigan | 26139 | 44 | 0 |
39197 | 39197 | 2020-04-07 | Ottawa | Michigan | 26139 | 52 | 0 |
41749 | 41749 | 2020-04-08 | Ottawa | Michigan | 26139 | 55 | 0 |
44325 | 44325 | 2020-04-09 | Ottawa | Michigan | 26139 | 59 | 1 |
46934 | 46934 | 2020-04-10 | Ottawa | Michigan | 26139 | 61 | 1 |
49578 | 49578 | 2020-04-11 | Ottawa | Michigan | 26139 | 64 | 2 |
52248 | 52248 | 2020-04-12 | Ottawa | Michigan | 26139 | 66 | 2 |
54930 | 54930 | 2020-04-13 | Ottawa | Michigan | 26139 | 69 | 2 |
57628 | 57628 | 2020-04-14 | Ottawa | Michigan | 26139 | 67 | 2 |
60338 | 60338 | 2020-04-15 | Ottawa | Michigan | 26139 | 74 | 2 |
63060 | 63060 | 2020-04-16 | Ottawa | Michigan | 26139 | 82 | 2 |
65798 | 65798 | 2020-04-17 | Ottawa | Michigan | 26139 | 88 | 5 |
68549 | 68549 | 2020-04-18 | Ottawa | Michigan | 26139 | 98 | 5 |
71313 | 71313 | 2020-04-19 | Ottawa | Michigan | 26139 | 107 | 5 |
74085 | 74085 | 2020-04-20 | Ottawa | Michigan | 26139 | 119 | 7 |
76865 | 76865 | 2020-04-21 | Ottawa | Michigan | 26139 | 129 | 7 |
79651 | 79651 | 2020-04-22 | Ottawa | Michigan | 26139 | 149 | 7 |
82446 | 82446 | 2020-04-23 | Ottawa | Michigan | 26139 | 161 | 7 |
85250 | 85250 | 2020-04-24 | Ottawa | Michigan | 26139 | 167 | 8 |
88060 | 88060 | 2020-04-25 | Ottawa | Michigan | 26139 | 173 | 8 |
90876 | 90876 | 2020-04-26 | Ottawa | Michigan | 26139 | 180 | 9 |
93697 | 93697 | 2020-04-27 | Ottawa | Michigan | 26139 | 191 | 9 |
96532 | 96532 | 2020-04-28 | Ottawa | Michigan | 26139 | 210 | 9 |
99378 | 99378 | 2020-04-29 | Ottawa | Michigan | 26139 | 224 | 9 |
102230 | 102230 | 2020-04-30 | Ottawa | Michigan | 26139 | 236 | 9 |
105090 | 105090 | 2020-05-01 | Ottawa | Michigan | 26139 | 254 | 11 |
107954 | 107954 | 2020-05-02 | Ottawa | Michigan | 26139 | 261 | 12 |
110826 | 110826 | 2020-05-03 | Ottawa | Michigan | 26139 | 275 | 12 |
113704 | 113704 | 2020-05-04 | Ottawa | Michigan | 26139 | 281 | 12 |
116585 | 116585 | 2020-05-05 | Ottawa | Michigan | 26139 | 295 | 12 |
119546 | 119546 | 2020-05-06 | Ottawa | Michigan | 26139 | 313 | 14 |
122518 | 122518 | 2020-05-07 | Ottawa | Michigan | 26139 | 331 | 17 |
125500 | 125500 | 2020-05-08 | Ottawa | Michigan | 26139 | 353 | 17 |
128487 | 128487 | 2020-05-09 | Ottawa | Michigan | 26139 | 373 | 19 |
131477 | 131477 | 2020-05-10 | Ottawa | Michigan | 26139 | 388 | 19 |
134468 | 134468 | 2020-05-11 | Ottawa | Michigan | 26139 | 420 | 19 |
137458 | 137458 | 2020-05-12 | Ottawa | Michigan | 26139 | 430 | 20 |
140452 | 140452 | 2020-05-13 | Ottawa | Michigan | 26139 | 444 | 21 |
143447 | 143447 | 2020-05-14 | Ottawa | Michigan | 26139 | 483 | 23 |
146447 | 146447 | 2020-05-15 | Ottawa | Michigan | 26139 | 501 | 24 |
149452 | 149452 | 2020-05-16 | Ottawa | Michigan | 26139 | 518 | 24 |
152463 | 152463 | 2020-05-17 | Ottawa | Michigan | 26139 | 531 | 24 |
155477 | 155477 | 2020-05-18 | Ottawa | Michigan | 26139 | 558 | 24 |
158495 | 158495 | 2020-05-19 | Ottawa | Michigan | 26139 | 573 | 25 |
161521 | 161521 | 2020-05-20 | Ottawa | Michigan | 26139 | 616 | 26 |
164550 | 164550 | 2020-05-21 | Ottawa | Michigan | 26139 | 632 | 26 |
167586 | 167586 | 2020-05-22 | Ottawa | Michigan | 26139 | 657 | 26 |
170623 | 170623 | 2020-05-23 | Ottawa | Michigan | 26139 | 673 | 26 |
173665 | 173665 | 2020-05-24 | Ottawa | Michigan | 26139 | 696 | 26 |
176708 | 176708 | 2020-05-25 | Ottawa | Michigan | 26139 | 709 | 27 |
179752 | 179752 | 2020-05-26 | Ottawa | Michigan | 26139 | 714 | 29 |
182798 | 182798 | 2020-05-27 | Ottawa | Michigan | 26139 | 715 | 31 |
185853 | 185853 | 2020-05-28 | Ottawa | Michigan | 26139 | 744 | 31 |
188911 | 188911 | 2020-05-29 | Ottawa | Michigan | 26139 | 759 | 33 |
191975 | 191975 | 2020-05-30 | Ottawa | Michigan | 26139 | 766 | 33 |
195043 | 195043 | 2020-05-31 | Ottawa | Michigan | 26139 | 774 | 34 |
198114 | 198114 | 2020-06-01 | Ottawa | Michigan | 26139 | 862 | 39 |
201187 | 201187 | 2020-06-02 | Ottawa | Michigan | 26139 | 863 | 40 |
204264 | 204264 | 2020-06-03 | Ottawa | Michigan | 26139 | 876 | 41 |
207345 | 207345 | 2020-06-04 | Ottawa | Michigan | 26139 | 889 | 44 |
210426 | 210426 | 2020-06-05 | Ottawa | Michigan | 26139 | 898 | 46 |
213510 | 213510 | 2020-06-06 | Ottawa | Michigan | 26139 | 906 | 47 |
216598 | 216598 | 2020-06-07 | Ottawa | Michigan | 26139 | 903 | 47 |
219690 | 219690 | 2020-06-08 | Ottawa | Michigan | 26139 | 904 | 48 |
222785 | 222785 | 2020-06-09 | Ottawa | Michigan | 26139 | 904 | 48 |
225883 | 225883 | 2020-06-10 | Ottawa | Michigan | 26139 | 909 | 48 |
228985 | 228985 | 2020-06-11 | Ottawa | Michigan | 26139 | 918 | 49 |
232089 | 232089 | 2020-06-12 | Ottawa | Michigan | 26139 | 938 | 50 |
235194 | 235194 | 2020-06-13 | Ottawa | Michigan | 26139 | 939 | 50 |
238301 | 238301 | 2020-06-14 | Ottawa | Michigan | 26139 | 944 | 50 |
241410 | 241410 | 2020-06-15 | Ottawa | Michigan | 26139 | 947 | 51 |
244521 | 244521 | 2020-06-16 | Ottawa | Michigan | 26139 | 944 | 51 |
247634 | 247634 | 2020-06-17 | Ottawa | Michigan | 26139 | 947 | 51 |
250746 | 250746 | 2020-06-18 | Ottawa | Michigan | 26139 | 949 | 51 |
253861 | 253861 | 2020-06-19 | Ottawa | Michigan | 26139 | 966 | 51 |
256981 | 256981 | 2020-06-20 | Ottawa | Michigan | 26139 | 966 | 51 |
260107 | 260107 | 2020-06-21 | Ottawa | Michigan | 26139 | 966 | 51 |
263236 | 263236 | 2020-06-22 | Ottawa | Michigan | 26139 | 983 | 51 |
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);