ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Anoka" and state = "Minnesota" sorted by county descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county ▲ | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
250762 | 250762 | 2020-06-18 | Anoka | Minnesota | 27003 | 1810 | 94 |
253877 | 253877 | 2020-06-19 | Anoka | Minnesota | 27003 | 1836 | 96 |
256997 | 256997 | 2020-06-20 | Anoka | Minnesota | 27003 | 1867 | 99 |
260123 | 260123 | 2020-06-21 | Anoka | Minnesota | 27003 | 1894 | 102 |
263252 | 263252 | 2020-06-22 | Anoka | Minnesota | 27003 | 1910 | 103 |
266378 | 266378 | 2020-06-23 | Anoka | Minnesota | 27003 | 1919 | 103 |
269511 | 269511 | 2020-06-24 | Anoka | Minnesota | 27003 | 1940 | 103 |
272648 | 272648 | 2020-06-25 | Anoka | Minnesota | 27003 | 1961 | 103 |
275791 | 275791 | 2020-06-26 | Anoka | Minnesota | 27003 | 1990 | 103 |
278939 | 278939 | 2020-06-27 | Anoka | Minnesota | 27003 | 2020 | 105 |
282087 | 282087 | 2020-06-28 | Anoka | Minnesota | 27003 | 2053 | 106 |
285232 | 285232 | 2020-06-29 | Anoka | Minnesota | 27003 | 2076 | 107 |
288382 | 288382 | 2020-06-30 | Anoka | Minnesota | 27003 | 2097 | 107 |
291533 | 291533 | 2020-07-01 | Anoka | Minnesota | 27003 | 2124 | 107 |
294687 | 294687 | 2020-07-02 | Anoka | Minnesota | 27003 | 2155 | 107 |
297845 | 297845 | 2020-07-03 | Anoka | Minnesota | 27003 | 2180 | 107 |
301008 | 301008 | 2020-07-04 | Anoka | Minnesota | 27003 | 2180 | 107 |
304172 | 304172 | 2020-07-05 | Anoka | Minnesota | 27003 | 2200 | 109 |
307339 | 307339 | 2020-07-06 | Anoka | Minnesota | 27003 | 2241 | 109 |
310507 | 310507 | 2020-07-07 | Anoka | Minnesota | 27003 | 2266 | 109 |
313677 | 313677 | 2020-07-08 | Anoka | Minnesota | 27003 | 2293 | 110 |
316851 | 316851 | 2020-07-09 | Anoka | Minnesota | 27003 | 2328 | 111 |
320026 | 320026 | 2020-07-10 | Anoka | Minnesota | 27003 | 2360 | 111 |
323205 | 323205 | 2020-07-11 | Anoka | Minnesota | 27003 | 2393 | 111 |
326388 | 326388 | 2020-07-12 | Anoka | Minnesota | 27003 | 2422 | 111 |
329574 | 329574 | 2020-07-13 | Anoka | Minnesota | 27003 | 2458 | 111 |
332761 | 332761 | 2020-07-14 | Anoka | Minnesota | 27003 | 2477 | 114 |
335954 | 335954 | 2020-07-15 | Anoka | Minnesota | 27003 | 2510 | 115 |
339150 | 339150 | 2020-07-16 | Anoka | Minnesota | 27003 | 2534 | 108 |
342346 | 342346 | 2020-07-17 | Anoka | Minnesota | 27003 | 2572 | 109 |
345546 | 345546 | 2020-07-18 | Anoka | Minnesota | 27003 | 2604 | 109 |
348747 | 348747 | 2020-07-19 | Anoka | Minnesota | 27003 | 2667 | 110 |
351947 | 351947 | 2020-07-20 | Anoka | Minnesota | 27003 | 2678 | 110 |
355149 | 355149 | 2020-07-21 | Anoka | Minnesota | 27003 | 2752 | 110 |
358352 | 358352 | 2020-07-22 | Anoka | Minnesota | 27003 | 2790 | 110 |
361557 | 361557 | 2020-07-23 | Anoka | Minnesota | 27003 | 2848 | 111 |
364764 | 364764 | 2020-07-24 | Anoka | Minnesota | 27003 | 2903 | 111 |
367971 | 367971 | 2020-07-25 | Anoka | Minnesota | 27003 | 2950 | 111 |
371181 | 371181 | 2020-07-26 | Anoka | Minnesota | 27003 | 3010 | 111 |
374393 | 374393 | 2020-07-27 | Anoka | Minnesota | 27003 | 3050 | 112 |
377608 | 377608 | 2020-07-28 | Anoka | Minnesota | 27003 | 3083 | 112 |
380825 | 380825 | 2020-07-29 | Anoka | Minnesota | 27003 | 3130 | 112 |
384042 | 384042 | 2020-07-30 | Anoka | Minnesota | 27003 | 3190 | 112 |
387260 | 387260 | 2020-07-31 | Anoka | Minnesota | 27003 | 3245 | 112 |
390477 | 390477 | 2020-08-01 | Anoka | Minnesota | 27003 | 3277 | 112 |
393694 | 393694 | 2020-08-02 | Anoka | Minnesota | 27003 | 3327 | 112 |
396910 | 396910 | 2020-08-03 | Anoka | Minnesota | 27003 | 3365 | 113 |
400124 | 400124 | 2020-08-04 | Anoka | Minnesota | 27003 | 3410 | 113 |
403341 | 403341 | 2020-08-05 | Anoka | Minnesota | 27003 | 3456 | 113 |
406559 | 406559 | 2020-08-06 | Anoka | Minnesota | 27003 | 3515 | 114 |
409779 | 409779 | 2020-08-07 | Anoka | Minnesota | 27003 | 3553 | 114 |
412999 | 412999 | 2020-08-08 | Anoka | Minnesota | 27003 | 3618 | 114 |
416219 | 416219 | 2020-08-09 | Anoka | Minnesota | 27003 | 3683 | 114 |
419440 | 419440 | 2020-08-10 | Anoka | Minnesota | 27003 | 3739 | 115 |
422662 | 422662 | 2020-08-11 | Anoka | Minnesota | 27003 | 3752 | 115 |
425884 | 425884 | 2020-08-12 | Anoka | Minnesota | 27003 | 3792 | 115 |
429108 | 429108 | 2020-08-13 | Anoka | Minnesota | 27003 | 3841 | 115 |
432335 | 432335 | 2020-08-14 | Anoka | Minnesota | 27003 | 3891 | 115 |
435561 | 435561 | 2020-08-15 | Anoka | Minnesota | 27003 | 3955 | 115 |
438786 | 438786 | 2020-08-16 | Anoka | Minnesota | 27003 | 4013 | 115 |
442013 | 442013 | 2020-08-17 | Anoka | Minnesota | 27003 | 4064 | 115 |
445239 | 445239 | 2020-08-18 | Anoka | Minnesota | 27003 | 4096 | 116 |
448465 | 448465 | 2020-08-19 | Anoka | Minnesota | 27003 | 4149 | 116 |
451693 | 451693 | 2020-08-20 | Anoka | Minnesota | 27003 | 4177 | 116 |
454921 | 454921 | 2020-08-21 | Anoka | Minnesota | 27003 | 4229 | 116 |
458149 | 458149 | 2020-08-22 | Anoka | Minnesota | 27003 | 4279 | 116 |
461376 | 461376 | 2020-08-23 | Anoka | Minnesota | 27003 | 4329 | 117 |
464607 | 464607 | 2020-08-24 | Anoka | Minnesota | 27003 | 4386 | 117 |
467836 | 467836 | 2020-08-25 | Anoka | Minnesota | 27003 | 4412 | 118 |
471066 | 471066 | 2020-08-26 | Anoka | Minnesota | 27003 | 4447 | 119 |
474298 | 474298 | 2020-08-27 | Anoka | Minnesota | 27003 | 4516 | 120 |
477531 | 477531 | 2020-08-28 | Anoka | Minnesota | 27003 | 4567 | 120 |
480763 | 480763 | 2020-08-29 | Anoka | Minnesota | 27003 | 4633 | 121 |
483998 | 483998 | 2020-08-30 | Anoka | Minnesota | 27003 | 4681 | 121 |
487232 | 487232 | 2020-08-31 | Anoka | Minnesota | 27003 | 4741 | 121 |
490465 | 490465 | 2020-09-01 | Anoka | Minnesota | 27003 | 4782 | 121 |
493699 | 493699 | 2020-09-02 | Anoka | Minnesota | 27003 | 4816 | 121 |
496932 | 496932 | 2020-09-03 | Anoka | Minnesota | 27003 | 4871 | 121 |
500166 | 500166 | 2020-09-04 | Anoka | Minnesota | 27003 | 4923 | 123 |
503400 | 503400 | 2020-09-05 | Anoka | Minnesota | 27003 | 4979 | 123 |
506633 | 506633 | 2020-09-06 | Anoka | Minnesota | 27003 | 5023 | 124 |
509866 | 509866 | 2020-09-07 | Anoka | Minnesota | 27003 | 5076 | 125 |
513098 | 513098 | 2020-09-08 | Anoka | Minnesota | 27003 | 5104 | 125 |
516332 | 516332 | 2020-09-09 | Anoka | Minnesota | 27003 | 5118 | 125 |
519567 | 519567 | 2020-09-10 | Anoka | Minnesota | 27003 | 5167 | 125 |
522804 | 522804 | 2020-09-11 | Anoka | Minnesota | 27003 | 5213 | 126 |
526040 | 526040 | 2020-09-12 | Anoka | Minnesota | 27003 | 5289 | 128 |
529276 | 529276 | 2020-09-13 | Anoka | Minnesota | 27003 | 5341 | 129 |
532512 | 532512 | 2020-09-14 | Anoka | Minnesota | 27003 | 5396 | 129 |
535747 | 535747 | 2020-09-15 | Anoka | Minnesota | 27003 | 5431 | 129 |
538984 | 538984 | 2020-09-16 | Anoka | Minnesota | 27003 | 5466 | 130 |
542220 | 542220 | 2020-09-17 | Anoka | Minnesota | 27003 | 5531 | 131 |
545457 | 545457 | 2020-09-18 | Anoka | Minnesota | 27003 | 5596 | 132 |
548695 | 548695 | 2020-09-19 | Anoka | Minnesota | 27003 | 5664 | 132 |
551934 | 551934 | 2020-09-20 | Anoka | Minnesota | 27003 | 5753 | 132 |
555172 | 555172 | 2020-09-21 | Anoka | Minnesota | 27003 | 5801 | 132 |
558409 | 558409 | 2020-09-22 | Anoka | Minnesota | 27003 | 5836 | 132 |
561646 | 561646 | 2020-09-23 | Anoka | Minnesota | 27003 | 5870 | 132 |
564886 | 564886 | 2020-09-24 | Anoka | Minnesota | 27003 | 5935 | 132 |
568126 | 568126 | 2020-09-25 | Anoka | Minnesota | 27003 | 6006 | 133 |
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);