ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
788 rows where county = "Jackson" and state = "Michigan" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
387212 | 387212 | 2020-07-31 | Jackson | Michigan | 26075 | 2392 | 55 |
383994 | 383994 | 2020-07-30 | Jackson | Michigan | 26075 | 2387 | 55 |
380777 | 380777 | 2020-07-29 | Jackson | Michigan | 26075 | 2373 | 55 |
377560 | 377560 | 2020-07-28 | Jackson | Michigan | 26075 | 2357 | 55 |
374345 | 374345 | 2020-07-27 | Jackson | Michigan | 26075 | 2351 | 54 |
371133 | 371133 | 2020-07-26 | Jackson | Michigan | 26075 | 2350 | 54 |
367923 | 367923 | 2020-07-25 | Jackson | Michigan | 26075 | 2344 | 54 |
364716 | 364716 | 2020-07-24 | Jackson | Michigan | 26075 | 2227 | 54 |
361509 | 361509 | 2020-07-23 | Jackson | Michigan | 26075 | 2221 | 54 |
358304 | 358304 | 2020-07-22 | Jackson | Michigan | 26075 | 2210 | 54 |
355101 | 355101 | 2020-07-21 | Jackson | Michigan | 26075 | 2204 | 54 |
351899 | 351899 | 2020-07-20 | Jackson | Michigan | 26075 | 2195 | 54 |
348699 | 348699 | 2020-07-19 | Jackson | Michigan | 26075 | 2193 | 54 |
345498 | 345498 | 2020-07-18 | Jackson | Michigan | 26075 | 2187 | 54 |
342298 | 342298 | 2020-07-17 | Jackson | Michigan | 26075 | 2180 | 54 |
339102 | 339102 | 2020-07-16 | Jackson | Michigan | 26075 | 2173 | 54 |
335906 | 335906 | 2020-07-15 | Jackson | Michigan | 26075 | 2168 | 54 |
332713 | 332713 | 2020-07-14 | Jackson | Michigan | 26075 | 2166 | 54 |
329526 | 329526 | 2020-07-13 | Jackson | Michigan | 26075 | 2163 | 54 |
326340 | 326340 | 2020-07-12 | Jackson | Michigan | 26075 | 2159 | 54 |
323157 | 323157 | 2020-07-11 | Jackson | Michigan | 26075 | 2155 | 54 |
319978 | 319978 | 2020-07-10 | Jackson | Michigan | 26075 | 2148 | 54 |
316803 | 316803 | 2020-07-09 | Jackson | Michigan | 26075 | 2143 | 54 |
313629 | 313629 | 2020-07-08 | Jackson | Michigan | 26075 | 2140 | 54 |
310459 | 310459 | 2020-07-07 | Jackson | Michigan | 26075 | 2136 | 54 |
307291 | 307291 | 2020-07-06 | Jackson | Michigan | 26075 | 2136 | 53 |
304124 | 304124 | 2020-07-05 | Jackson | Michigan | 26075 | 2131 | 53 |
300960 | 300960 | 2020-07-04 | Jackson | Michigan | 26075 | 2131 | 53 |
297798 | 297798 | 2020-07-03 | Jackson | Michigan | 26075 | 2128 | 53 |
294640 | 294640 | 2020-07-02 | Jackson | Michigan | 26075 | 2105 | 53 |
291486 | 291486 | 2020-07-01 | Jackson | Michigan | 26075 | 2101 | 52 |
288335 | 288335 | 2020-06-30 | Jackson | Michigan | 26075 | 2093 | 52 |
285185 | 285185 | 2020-06-29 | Jackson | Michigan | 26075 | 2085 | 52 |
282040 | 282040 | 2020-06-28 | Jackson | Michigan | 26075 | 2082 | 52 |
278892 | 278892 | 2020-06-27 | Jackson | Michigan | 26075 | 2082 | 52 |
275744 | 275744 | 2020-06-26 | Jackson | Michigan | 26075 | 2080 | 52 |
272601 | 272601 | 2020-06-25 | Jackson | Michigan | 26075 | 2056 | 52 |
269464 | 269464 | 2020-06-24 | Jackson | Michigan | 26075 | 2056 | 52 |
266331 | 266331 | 2020-06-23 | Jackson | Michigan | 26075 | 2056 | 52 |
263205 | 263205 | 2020-06-22 | Jackson | Michigan | 26075 | 2055 | 52 |
260076 | 260076 | 2020-06-21 | Jackson | Michigan | 26075 | 2056 | 52 |
256950 | 256950 | 2020-06-20 | Jackson | Michigan | 26075 | 2056 | 52 |
253830 | 253830 | 2020-06-19 | Jackson | Michigan | 26075 | 2055 | 52 |
250715 | 250715 | 2020-06-18 | Jackson | Michigan | 26075 | 2055 | 52 |
247603 | 247603 | 2020-06-17 | Jackson | Michigan | 26075 | 2054 | 52 |
244490 | 244490 | 2020-06-16 | Jackson | Michigan | 26075 | 2054 | 52 |
241379 | 241379 | 2020-06-15 | Jackson | Michigan | 26075 | 2054 | 52 |
238270 | 238270 | 2020-06-14 | Jackson | Michigan | 26075 | 2054 | 52 |
235163 | 235163 | 2020-06-13 | Jackson | Michigan | 26075 | 2053 | 52 |
232058 | 232058 | 2020-06-12 | Jackson | Michigan | 26075 | 2051 | 52 |
228954 | 228954 | 2020-06-11 | Jackson | Michigan | 26075 | 2055 | 52 |
225852 | 225852 | 2020-06-10 | Jackson | Michigan | 26075 | 2051 | 52 |
222755 | 222755 | 2020-06-09 | Jackson | Michigan | 26075 | 2041 | 52 |
219660 | 219660 | 2020-06-08 | Jackson | Michigan | 26075 | 2041 | 52 |
216568 | 216568 | 2020-06-07 | Jackson | Michigan | 26075 | 2033 | 52 |
213480 | 213480 | 2020-06-06 | Jackson | Michigan | 26075 | 2031 | 51 |
210396 | 210396 | 2020-06-05 | Jackson | Michigan | 26075 | 2031 | 51 |
207315 | 207315 | 2020-06-04 | Jackson | Michigan | 26075 | 1997 | 50 |
204234 | 204234 | 2020-06-03 | Jackson | Michigan | 26075 | 1990 | 50 |
201157 | 201157 | 2020-06-02 | Jackson | Michigan | 26075 | 1988 | 49 |
198084 | 198084 | 2020-06-01 | Jackson | Michigan | 26075 | 1980 | 49 |
195013 | 195013 | 2020-05-31 | Jackson | Michigan | 26075 | 1806 | 49 |
191945 | 191945 | 2020-05-30 | Jackson | Michigan | 26075 | 1504 | 47 |
188881 | 188881 | 2020-05-29 | Jackson | Michigan | 26075 | 1567 | 47 |
185823 | 185823 | 2020-05-28 | Jackson | Michigan | 26075 | 1502 | 46 |
182768 | 182768 | 2020-05-27 | Jackson | Michigan | 26075 | 1495 | 45 |
179722 | 179722 | 2020-05-26 | Jackson | Michigan | 26075 | 1494 | 45 |
176678 | 176678 | 2020-05-25 | Jackson | Michigan | 26075 | 1494 | 45 |
173635 | 173635 | 2020-05-24 | Jackson | Michigan | 26075 | 1492 | 45 |
170593 | 170593 | 2020-05-23 | Jackson | Michigan | 26075 | 1473 | 45 |
167556 | 167556 | 2020-05-22 | Jackson | Michigan | 26075 | 1471 | 45 |
164520 | 164520 | 2020-05-21 | Jackson | Michigan | 26075 | 1466 | 45 |
161491 | 161491 | 2020-05-20 | Jackson | Michigan | 26075 | 1462 | 45 |
158465 | 158465 | 2020-05-19 | Jackson | Michigan | 26075 | 1459 | 45 |
155447 | 155447 | 2020-05-18 | Jackson | Michigan | 26075 | 1455 | 44 |
152433 | 152433 | 2020-05-17 | Jackson | Michigan | 26075 | 1447 | 44 |
149422 | 149422 | 2020-05-16 | Jackson | Michigan | 26075 | 1444 | 44 |
146417 | 146417 | 2020-05-15 | Jackson | Michigan | 26075 | 1416 | 44 |
143417 | 143417 | 2020-05-14 | Jackson | Michigan | 26075 | 1411 | 44 |
140422 | 140422 | 2020-05-13 | Jackson | Michigan | 26075 | 1389 | 44 |
137428 | 137428 | 2020-05-12 | Jackson | Michigan | 26075 | 1382 | 43 |
134438 | 134438 | 2020-05-11 | Jackson | Michigan | 26075 | 1381 | 43 |
131447 | 131447 | 2020-05-10 | Jackson | Michigan | 26075 | 1364 | 43 |
128457 | 128457 | 2020-05-09 | Jackson | Michigan | 26075 | 1346 | 43 |
125470 | 125470 | 2020-05-08 | Jackson | Michigan | 26075 | 1328 | 42 |
122488 | 122488 | 2020-05-07 | Jackson | Michigan | 26075 | 1320 | 43 |
119516 | 119516 | 2020-05-06 | Jackson | Michigan | 26075 | 1311 | 43 |
116555 | 116555 | 2020-05-05 | Jackson | Michigan | 26075 | 1301 | 42 |
113674 | 113674 | 2020-05-04 | Jackson | Michigan | 26075 | 1278 | 42 |
110796 | 110796 | 2020-05-03 | Jackson | Michigan | 26075 | 1272 | 39 |
107924 | 107924 | 2020-05-02 | Jackson | Michigan | 26075 | 1001 | 39 |
105060 | 105060 | 2020-05-01 | Jackson | Michigan | 26075 | 944 | 37 |
102200 | 102200 | 2020-04-30 | Jackson | Michigan | 26075 | 735 | 37 |
99348 | 99348 | 2020-04-29 | Jackson | Michigan | 26075 | 717 | 33 |
96502 | 96502 | 2020-04-28 | Jackson | Michigan | 26075 | 678 | 32 |
93667 | 93667 | 2020-04-27 | Jackson | Michigan | 26075 | 676 | 28 |
90846 | 90846 | 2020-04-26 | Jackson | Michigan | 26075 | 650 | 26 |
88030 | 88030 | 2020-04-25 | Jackson | Michigan | 26075 | 646 | 26 |
85220 | 85220 | 2020-04-24 | Jackson | Michigan | 26075 | 626 | 24 |
82416 | 82416 | 2020-04-23 | Jackson | Michigan | 26075 | 597 | 22 |
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);