ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Wayne" and state = "Michigan" sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
1081 | 1081 | 2020-03-10 | Wayne | Michigan | 26163 | 1 | 0 |
1261 | 1261 | 2020-03-11 | Wayne | Michigan | 26163 | 1 | 0 |
1484 | 1484 | 2020-03-12 | Wayne | Michigan | 26163 | 1 | 0 |
1767 | 1767 | 2020-03-13 | Wayne | Michigan | 26163 | 6 | 0 |
2111 | 2111 | 2020-03-14 | Wayne | Michigan | 26163 | 8 | 0 |
2515 | 2515 | 2020-03-15 | Wayne | Michigan | 26163 | 13 | 0 |
2965 | 2965 | 2020-03-16 | Wayne | Michigan | 26163 | 13 | 0 |
3468 | 3468 | 2020-03-17 | Wayne | Michigan | 26163 | 17 | 0 |
4051 | 4051 | 2020-03-18 | Wayne | Michigan | 26163 | 23 | 1 |
4761 | 4761 | 2020-03-19 | Wayne | Michigan | 26163 | 119 | 3 |
5580 | 5580 | 2020-03-20 | Wayne | Michigan | 26163 | 216 | 3 |
6547 | 6547 | 2020-03-21 | Wayne | Michigan | 26163 | 349 | 4 |
7628 | 7628 | 2020-03-22 | Wayne | Michigan | 26163 | 477 | 5 |
8804 | 8804 | 2020-03-23 | Wayne | Michigan | 26163 | 638 | 8 |
10099 | 10099 | 2020-03-24 | Wayne | Michigan | 26163 | 873 | 13 |
11516 | 11516 | 2020-03-25 | Wayne | Michigan | 26163 | 1122 | 21 |
13104 | 13104 | 2020-03-26 | Wayne | Michigan | 26163 | 1389 | 26 |
14816 | 14816 | 2020-03-27 | Wayne | Michigan | 26163 | 1810 | 37 |
16637 | 16637 | 2020-03-28 | Wayne | Michigan | 26163 | 2316 | 46 |
18553 | 18553 | 2020-03-29 | Wayne | Michigan | 26163 | 2704 | 56 |
20573 | 20573 | 2020-03-30 | Wayne | Michigan | 26163 | 3195 | 83 |
22685 | 22685 | 2020-03-31 | Wayne | Michigan | 26163 | 3735 | 120 |
24865 | 24865 | 2020-04-01 | Wayne | Michigan | 26163 | 4470 | 146 |
27118 | 27118 | 2020-04-02 | Wayne | Michigan | 26163 | 5069 | 194 |
29437 | 29437 | 2020-04-03 | Wayne | Michigan | 26163 | 6096 | 223 |
31815 | 31815 | 2020-04-04 | Wayne | Michigan | 26163 | 6762 | 252 |
34240 | 34240 | 2020-04-05 | Wayne | Michigan | 26163 | 7518 | 293 |
36700 | 36700 | 2020-04-06 | Wayne | Michigan | 26163 | 8270 | 346 |
39209 | 39209 | 2020-04-07 | Wayne | Michigan | 26163 | 9045 | 402 |
41762 | 41762 | 2020-04-08 | Wayne | Michigan | 26163 | 9626 | 446 |
44338 | 44338 | 2020-04-09 | Wayne | Michigan | 26163 | 10093 | 504 |
46947 | 46947 | 2020-04-10 | Wayne | Michigan | 26163 | 10539 | 609 |
49591 | 49591 | 2020-04-11 | Wayne | Michigan | 26163 | 10951 | 652 |
52261 | 52261 | 2020-04-12 | Wayne | Michigan | 26163 | 11164 | 704 |
54943 | 54943 | 2020-04-13 | Wayne | Michigan | 26163 | 11648 | 760 |
57641 | 57641 | 2020-04-14 | Wayne | Michigan | 26163 | 12209 | 820 |
60351 | 60351 | 2020-04-15 | Wayne | Michigan | 26163 | 12560 | 885 |
63073 | 63073 | 2020-04-16 | Wayne | Michigan | 26163 | 13018 | 982 |
65811 | 65811 | 2020-04-17 | Wayne | Michigan | 26163 | 13249 | 1045 |
68562 | 68562 | 2020-04-18 | Wayne | Michigan | 26163 | 13487 | 1071 |
71326 | 71326 | 2020-04-19 | Wayne | Michigan | 26163 | 13708 | 1121 |
74098 | 74098 | 2020-04-20 | Wayne | Michigan | 26163 | 13928 | 1150 |
76878 | 76878 | 2020-04-21 | Wayne | Michigan | 26163 | 14271 | 1281 |
79663 | 79663 | 2020-04-22 | Wayne | Michigan | 26163 | 14578 | 1322 |
82459 | 82459 | 2020-04-23 | Wayne | Michigan | 26163 | 15011 | 1399 |
85263 | 85263 | 2020-04-24 | Wayne | Michigan | 26163 | 15425 | 1445 |
88073 | 88073 | 2020-04-25 | Wayne | Michigan | 26163 | 15566 | 1562 |
90889 | 90889 | 2020-04-26 | Wayne | Michigan | 26163 | 15767 | 1582 |
93710 | 93710 | 2020-04-27 | Wayne | Michigan | 26163 | 15892 | 1624 |
96545 | 96545 | 2020-04-28 | Wayne | Michigan | 26163 | 16193 | 1684 |
99391 | 99391 | 2020-04-29 | Wayne | Michigan | 26163 | 16514 | 1729 |
102243 | 102243 | 2020-04-30 | Wayne | Michigan | 26163 | 16749 | 1784 |
105103 | 105103 | 2020-05-01 | Wayne | Michigan | 26163 | 16990 | 1804 |
107967 | 107967 | 2020-05-02 | Wayne | Michigan | 26163 | 17126 | 1886 |
110838 | 110838 | 2020-05-03 | Wayne | Michigan | 26163 | 17318 | 1895 |
113717 | 113717 | 2020-05-04 | Wayne | Michigan | 26163 | 17334 | 1926 |
116598 | 116598 | 2020-05-05 | Wayne | Michigan | 26163 | 17411 | 1947 |
119558 | 119558 | 2020-05-06 | Wayne | Michigan | 26163 | 17591 | 1975 |
122531 | 122531 | 2020-05-07 | Wayne | Michigan | 26163 | 17687 | 2014 |
125513 | 125513 | 2020-05-08 | Wayne | Michigan | 26163 | 17844 | 2030 |
128500 | 128500 | 2020-05-09 | Wayne | Michigan | 26163 | 17980 | 2084 |
131490 | 131490 | 2020-05-10 | Wayne | Michigan | 26163 | 18095 | 2099 |
134481 | 134481 | 2020-05-11 | Wayne | Michigan | 26163 | 18214 | 2107 |
137471 | 137471 | 2020-05-12 | Wayne | Michigan | 26163 | 18294 | 2142 |
140465 | 140465 | 2020-05-13 | Wayne | Michigan | 26163 | 18409 | 2158 |
143460 | 143460 | 2020-05-14 | Wayne | Michigan | 26163 | 18790 | 2185 |
146460 | 146460 | 2020-05-15 | Wayne | Michigan | 26163 | 18902 | 2194 |
149465 | 149465 | 2020-05-16 | Wayne | Michigan | 26163 | 19036 | 2214 |
152476 | 152476 | 2020-05-17 | Wayne | Michigan | 26163 | 19085 | 2215 |
155490 | 155490 | 2020-05-18 | Wayne | Michigan | 26163 | 19148 | 2228 |
158508 | 158508 | 2020-05-19 | Wayne | Michigan | 26163 | 19312 | 2277 |
161534 | 161534 | 2020-05-20 | Wayne | Michigan | 26163 | 19452 | 2286 |
164563 | 164563 | 2020-05-21 | Wayne | Michigan | 26163 | 19558 | 2315 |
167599 | 167599 | 2020-05-22 | Wayne | Michigan | 26163 | 19622 | 2325 |
170636 | 170636 | 2020-05-23 | Wayne | Michigan | 26163 | 19717 | 2363 |
173678 | 173678 | 2020-05-24 | Wayne | Michigan | 26163 | 19794 | 2361 |
176721 | 176721 | 2020-05-25 | Wayne | Michigan | 26163 | 19839 | 2366 |
179765 | 179765 | 2020-05-26 | Wayne | Michigan | 26163 | 19949 | 2370 |
182811 | 182811 | 2020-05-27 | Wayne | Michigan | 26163 | 20022 | 2408 |
185866 | 185866 | 2020-05-28 | Wayne | Michigan | 26163 | 20082 | 2412 |
188924 | 188924 | 2020-05-29 | Wayne | Michigan | 26163 | 20250 | 2427 |
191988 | 191988 | 2020-05-30 | Wayne | Michigan | 26163 | 20277 | 2454 |
195056 | 195056 | 2020-05-31 | Wayne | Michigan | 26163 | 20438 | 2463 |
198127 | 198127 | 2020-06-01 | Wayne | Michigan | 26163 | 20469 | 2465 |
201200 | 201200 | 2020-06-02 | Wayne | Michigan | 26163 | 20491 | 2477 |
204277 | 204277 | 2020-06-03 | Wayne | Michigan | 26163 | 20564 | 2481 |
207358 | 207358 | 2020-06-04 | Wayne | Michigan | 26163 | 20613 | 2494 |
210439 | 210439 | 2020-06-05 | Wayne | Michigan | 26163 | 21065 | 2615 |
213523 | 213523 | 2020-06-06 | Wayne | Michigan | 26163 | 21186 | 2629 |
216611 | 216611 | 2020-06-07 | Wayne | Michigan | 26163 | 21410 | 2630 |
219703 | 219703 | 2020-06-08 | Wayne | Michigan | 26163 | 21478 | 2635 |
222798 | 222798 | 2020-06-09 | Wayne | Michigan | 26163 | 21556 | 2653 |
225896 | 225896 | 2020-06-10 | Wayne | Michigan | 26163 | 21593 | 2655 |
228998 | 228998 | 2020-06-11 | Wayne | Michigan | 26163 | 21652 | 2666 |
232102 | 232102 | 2020-06-12 | Wayne | Michigan | 26163 | 21683 | 2666 |
235207 | 235207 | 2020-06-13 | Wayne | Michigan | 26163 | 21734 | 2671 |
238314 | 238314 | 2020-06-14 | Wayne | Michigan | 26163 | 21772 | 2672 |
241423 | 241423 | 2020-06-15 | Wayne | Michigan | 26163 | 21816 | 2672 |
244534 | 244534 | 2020-06-16 | Wayne | Michigan | 26163 | 21828 | 2677 |
247647 | 247647 | 2020-06-17 | Wayne | Michigan | 26163 | 21920 | 2678 |
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);