ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
783 rows where county = "Grand Traverse" sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, deaths, date (date)
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
7610 | 7610 | 2020-03-22 | Grand Traverse | Michigan | 26055 | 1 | 0 |
8783 | 8783 | 2020-03-23 | Grand Traverse | Michigan | 26055 | 1 | 0 |
10072 | 10072 | 2020-03-24 | Grand Traverse | Michigan | 26055 | 3 | 0 |
11484 | 11484 | 2020-03-25 | Grand Traverse | Michigan | 26055 | 3 | 0 |
13066 | 13066 | 2020-03-26 | Grand Traverse | Michigan | 26055 | 3 | 0 |
14776 | 14776 | 2020-03-27 | Grand Traverse | Michigan | 26055 | 3 | 0 |
16596 | 16596 | 2020-03-28 | Grand Traverse | Michigan | 26055 | 5 | 0 |
18512 | 18512 | 2020-03-29 | Grand Traverse | Michigan | 26055 | 6 | 0 |
20530 | 20530 | 2020-03-30 | Grand Traverse | Michigan | 26055 | 7 | 0 |
22641 | 22641 | 2020-03-31 | Grand Traverse | Michigan | 26055 | 7 | 0 |
24820 | 24820 | 2020-04-01 | Grand Traverse | Michigan | 26055 | 8 | 0 |
27073 | 27073 | 2020-04-02 | Grand Traverse | Michigan | 26055 | 9 | 2 |
29391 | 29391 | 2020-04-03 | Grand Traverse | Michigan | 26055 | 11 | 2 |
31769 | 31769 | 2020-04-04 | Grand Traverse | Michigan | 26055 | 12 | 3 |
34194 | 34194 | 2020-04-05 | Grand Traverse | Michigan | 26055 | 12 | 3 |
36653 | 36653 | 2020-04-06 | Grand Traverse | Michigan | 26055 | 14 | 3 |
39161 | 39161 | 2020-04-07 | Grand Traverse | Michigan | 26055 | 15 | 3 |
41713 | 41713 | 2020-04-08 | Grand Traverse | Michigan | 26055 | 15 | 3 |
44289 | 44289 | 2020-04-09 | Grand Traverse | Michigan | 26055 | 15 | 3 |
46897 | 46897 | 2020-04-10 | Grand Traverse | Michigan | 26055 | 16 | 3 |
49540 | 49540 | 2020-04-11 | Grand Traverse | Michigan | 26055 | 17 | 3 |
52210 | 52210 | 2020-04-12 | Grand Traverse | Michigan | 26055 | 17 | 3 |
54891 | 54891 | 2020-04-13 | Grand Traverse | Michigan | 26055 | 17 | 3 |
57589 | 57589 | 2020-04-14 | Grand Traverse | Michigan | 26055 | 17 | 3 |
60299 | 60299 | 2020-04-15 | Grand Traverse | Michigan | 26055 | 17 | 3 |
63021 | 63021 | 2020-04-16 | Grand Traverse | Michigan | 26055 | 17 | 3 |
65759 | 65759 | 2020-04-17 | Grand Traverse | Michigan | 26055 | 17 | 4 |
68510 | 68510 | 2020-04-18 | Grand Traverse | Michigan | 26055 | 18 | 4 |
71274 | 71274 | 2020-04-19 | Grand Traverse | Michigan | 26055 | 18 | 4 |
74046 | 74046 | 2020-04-20 | Grand Traverse | Michigan | 26055 | 19 | 4 |
76826 | 76826 | 2020-04-21 | Grand Traverse | Michigan | 26055 | 19 | 5 |
79612 | 79612 | 2020-04-22 | Grand Traverse | Michigan | 26055 | 19 | 5 |
82407 | 82407 | 2020-04-23 | Grand Traverse | Michigan | 26055 | 19 | 5 |
85211 | 85211 | 2020-04-24 | Grand Traverse | Michigan | 26055 | 19 | 5 |
88021 | 88021 | 2020-04-25 | Grand Traverse | Michigan | 26055 | 19 | 5 |
90837 | 90837 | 2020-04-26 | Grand Traverse | Michigan | 26055 | 19 | 5 |
93658 | 93658 | 2020-04-27 | Grand Traverse | Michigan | 26055 | 19 | 5 |
96493 | 96493 | 2020-04-28 | Grand Traverse | Michigan | 26055 | 19 | 5 |
99339 | 99339 | 2020-04-29 | Grand Traverse | Michigan | 26055 | 19 | 5 |
102191 | 102191 | 2020-04-30 | Grand Traverse | Michigan | 26055 | 19 | 5 |
105051 | 105051 | 2020-05-01 | Grand Traverse | Michigan | 26055 | 19 | 5 |
107915 | 107915 | 2020-05-02 | Grand Traverse | Michigan | 26055 | 19 | 5 |
110787 | 110787 | 2020-05-03 | Grand Traverse | Michigan | 26055 | 19 | 5 |
113665 | 113665 | 2020-05-04 | Grand Traverse | Michigan | 26055 | 20 | 5 |
116546 | 116546 | 2020-05-05 | Grand Traverse | Michigan | 26055 | 20 | 5 |
119507 | 119507 | 2020-05-06 | Grand Traverse | Michigan | 26055 | 20 | 5 |
122479 | 122479 | 2020-05-07 | Grand Traverse | Michigan | 26055 | 20 | 5 |
125461 | 125461 | 2020-05-08 | Grand Traverse | Michigan | 26055 | 20 | 5 |
128448 | 128448 | 2020-05-09 | Grand Traverse | Michigan | 26055 | 20 | 5 |
131438 | 131438 | 2020-05-10 | Grand Traverse | Michigan | 26055 | 20 | 5 |
134429 | 134429 | 2020-05-11 | Grand Traverse | Michigan | 26055 | 20 | 5 |
137419 | 137419 | 2020-05-12 | Grand Traverse | Michigan | 26055 | 21 | 5 |
140413 | 140413 | 2020-05-13 | Grand Traverse | Michigan | 26055 | 21 | 5 |
143408 | 143408 | 2020-05-14 | Grand Traverse | Michigan | 26055 | 23 | 5 |
146408 | 146408 | 2020-05-15 | Grand Traverse | Michigan | 26055 | 23 | 5 |
149413 | 149413 | 2020-05-16 | Grand Traverse | Michigan | 26055 | 23 | 5 |
152424 | 152424 | 2020-05-17 | Grand Traverse | Michigan | 26055 | 23 | 5 |
155438 | 155438 | 2020-05-18 | Grand Traverse | Michigan | 26055 | 23 | 5 |
158456 | 158456 | 2020-05-19 | Grand Traverse | Michigan | 26055 | 23 | 5 |
161482 | 161482 | 2020-05-20 | Grand Traverse | Michigan | 26055 | 23 | 5 |
164511 | 164511 | 2020-05-21 | Grand Traverse | Michigan | 26055 | 23 | 5 |
167547 | 167547 | 2020-05-22 | Grand Traverse | Michigan | 26055 | 23 | 5 |
170584 | 170584 | 2020-05-23 | Grand Traverse | Michigan | 26055 | 23 | 5 |
173626 | 173626 | 2020-05-24 | Grand Traverse | Michigan | 26055 | 23 | 5 |
176669 | 176669 | 2020-05-25 | Grand Traverse | Michigan | 26055 | 23 | 5 |
179713 | 179713 | 2020-05-26 | Grand Traverse | Michigan | 26055 | 23 | 5 |
182759 | 182759 | 2020-05-27 | Grand Traverse | Michigan | 26055 | 23 | 5 |
185814 | 185814 | 2020-05-28 | Grand Traverse | Michigan | 26055 | 23 | 5 |
188872 | 188872 | 2020-05-29 | Grand Traverse | Michigan | 26055 | 25 | 5 |
191936 | 191936 | 2020-05-30 | Grand Traverse | Michigan | 26055 | 27 | 5 |
195004 | 195004 | 2020-05-31 | Grand Traverse | Michigan | 26055 | 27 | 5 |
198075 | 198075 | 2020-06-01 | Grand Traverse | Michigan | 26055 | 33 | 5 |
201147 | 201147 | 2020-06-02 | Grand Traverse | Michigan | 26055 | 33 | 5 |
204224 | 204224 | 2020-06-03 | Grand Traverse | Michigan | 26055 | 33 | 5 |
207305 | 207305 | 2020-06-04 | Grand Traverse | Michigan | 26055 | 34 | 5 |
210386 | 210386 | 2020-06-05 | Grand Traverse | Michigan | 26055 | 34 | 5 |
213470 | 213470 | 2020-06-06 | Grand Traverse | Michigan | 26055 | 36 | 5 |
216558 | 216558 | 2020-06-07 | Grand Traverse | Michigan | 26055 | 37 | 5 |
219650 | 219650 | 2020-06-08 | Grand Traverse | Michigan | 26055 | 39 | 5 |
222745 | 222745 | 2020-06-09 | Grand Traverse | Michigan | 26055 | 40 | 5 |
225842 | 225842 | 2020-06-10 | Grand Traverse | Michigan | 26055 | 40 | 5 |
228944 | 228944 | 2020-06-11 | Grand Traverse | Michigan | 26055 | 41 | 5 |
232048 | 232048 | 2020-06-12 | Grand Traverse | Michigan | 26055 | 41 | 5 |
235153 | 235153 | 2020-06-13 | Grand Traverse | Michigan | 26055 | 41 | 5 |
238260 | 238260 | 2020-06-14 | Grand Traverse | Michigan | 26055 | 41 | 5 |
241369 | 241369 | 2020-06-15 | Grand Traverse | Michigan | 26055 | 41 | 5 |
244480 | 244480 | 2020-06-16 | Grand Traverse | Michigan | 26055 | 41 | 5 |
247593 | 247593 | 2020-06-17 | Grand Traverse | Michigan | 26055 | 41 | 5 |
250705 | 250705 | 2020-06-18 | Grand Traverse | Michigan | 26055 | 41 | 5 |
253820 | 253820 | 2020-06-19 | Grand Traverse | Michigan | 26055 | 43 | 5 |
256940 | 256940 | 2020-06-20 | Grand Traverse | Michigan | 26055 | 43 | 5 |
260066 | 260066 | 2020-06-21 | Grand Traverse | Michigan | 26055 | 43 | 5 |
263195 | 263195 | 2020-06-22 | Grand Traverse | Michigan | 26055 | 44 | 6 |
266321 | 266321 | 2020-06-23 | Grand Traverse | Michigan | 26055 | 44 | 6 |
269454 | 269454 | 2020-06-24 | Grand Traverse | Michigan | 26055 | 44 | 5 |
272591 | 272591 | 2020-06-25 | Grand Traverse | Michigan | 26055 | 44 | 5 |
275734 | 275734 | 2020-06-26 | Grand Traverse | Michigan | 26055 | 46 | 5 |
278882 | 278882 | 2020-06-27 | Grand Traverse | Michigan | 26055 | 46 | 5 |
282030 | 282030 | 2020-06-28 | Grand Traverse | Michigan | 26055 | 46 | 5 |
285175 | 285175 | 2020-06-29 | Grand Traverse | Michigan | 26055 | 51 | 5 |
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);