ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 27137 sorted by cases
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date | county | state | fips | cases ▼ | deaths |
---|---|---|---|---|---|---|---|
285301 | 285301 | 2020-06-29 | St. Louis | Minnesota | 27137 | 158 | 14 |
288451 | 288451 | 2020-06-30 | St. Louis | Minnesota | 27137 | 161 | 14 |
291602 | 291602 | 2020-07-01 | St. Louis | Minnesota | 27137 | 169 | 15 |
294756 | 294756 | 2020-07-02 | St. Louis | Minnesota | 27137 | 174 | 15 |
297914 | 297914 | 2020-07-03 | St. Louis | Minnesota | 27137 | 177 | 15 |
301077 | 301077 | 2020-07-04 | St. Louis | Minnesota | 27137 | 177 | 15 |
304241 | 304241 | 2020-07-05 | St. Louis | Minnesota | 27137 | 178 | 15 |
307408 | 307408 | 2020-07-06 | St. Louis | Minnesota | 27137 | 180 | 15 |
310576 | 310576 | 2020-07-07 | St. Louis | Minnesota | 27137 | 196 | 15 |
313746 | 313746 | 2020-07-08 | St. Louis | Minnesota | 27137 | 198 | 16 |
316920 | 316920 | 2020-07-09 | St. Louis | Minnesota | 27137 | 203 | 16 |
320095 | 320095 | 2020-07-10 | St. Louis | Minnesota | 27137 | 218 | 16 |
323274 | 323274 | 2020-07-11 | St. Louis | Minnesota | 27137 | 223 | 16 |
326457 | 326457 | 2020-07-12 | St. Louis | Minnesota | 27137 | 235 | 16 |
329643 | 329643 | 2020-07-13 | St. Louis | Minnesota | 27137 | 238 | 16 |
332830 | 332830 | 2020-07-14 | St. Louis | Minnesota | 27137 | 241 | 16 |
336023 | 336023 | 2020-07-15 | St. Louis | Minnesota | 27137 | 249 | 16 |
339219 | 339219 | 2020-07-16 | St. Louis | Minnesota | 27137 | 254 | 16 |
342415 | 342415 | 2020-07-17 | St. Louis | Minnesota | 27137 | 268 | 16 |
345615 | 345615 | 2020-07-18 | St. Louis | Minnesota | 27137 | 278 | 16 |
352016 | 352016 | 2020-07-20 | St. Louis | Minnesota | 27137 | 284 | 16 |
348816 | 348816 | 2020-07-19 | St. Louis | Minnesota | 27137 | 285 | 16 |
355218 | 355218 | 2020-07-21 | St. Louis | Minnesota | 27137 | 294 | 16 |
358421 | 358421 | 2020-07-22 | St. Louis | Minnesota | 27137 | 299 | 16 |
361626 | 361626 | 2020-07-23 | St. Louis | Minnesota | 27137 | 305 | 16 |
364833 | 364833 | 2020-07-24 | St. Louis | Minnesota | 27137 | 308 | 17 |
368041 | 368041 | 2020-07-25 | St. Louis | Minnesota | 27137 | 319 | 17 |
371251 | 371251 | 2020-07-26 | St. Louis | Minnesota | 27137 | 325 | 17 |
374463 | 374463 | 2020-07-27 | St. Louis | Minnesota | 27137 | 331 | 17 |
377678 | 377678 | 2020-07-28 | St. Louis | Minnesota | 27137 | 332 | 18 |
380895 | 380895 | 2020-07-29 | St. Louis | Minnesota | 27137 | 348 | 18 |
384112 | 384112 | 2020-07-30 | St. Louis | Minnesota | 27137 | 366 | 18 |
387330 | 387330 | 2020-07-31 | St. Louis | Minnesota | 27137 | 383 | 18 |
390547 | 390547 | 2020-08-01 | St. Louis | Minnesota | 27137 | 409 | 18 |
393764 | 393764 | 2020-08-02 | St. Louis | Minnesota | 27137 | 427 | 19 |
396980 | 396980 | 2020-08-03 | St. Louis | Minnesota | 27137 | 436 | 19 |
400194 | 400194 | 2020-08-04 | St. Louis | Minnesota | 27137 | 453 | 19 |
403411 | 403411 | 2020-08-05 | St. Louis | Minnesota | 27137 | 475 | 19 |
406629 | 406629 | 2020-08-06 | St. Louis | Minnesota | 27137 | 486 | 19 |
409849 | 409849 | 2020-08-07 | St. Louis | Minnesota | 27137 | 502 | 19 |
413069 | 413069 | 2020-08-08 | St. Louis | Minnesota | 27137 | 521 | 19 |
416289 | 416289 | 2020-08-09 | St. Louis | Minnesota | 27137 | 553 | 19 |
419510 | 419510 | 2020-08-10 | St. Louis | Minnesota | 27137 | 570 | 19 |
422732 | 422732 | 2020-08-11 | St. Louis | Minnesota | 27137 | 573 | 19 |
425954 | 425954 | 2020-08-12 | St. Louis | Minnesota | 27137 | 600 | 20 |
429178 | 429178 | 2020-08-13 | St. Louis | Minnesota | 27137 | 621 | 20 |
432405 | 432405 | 2020-08-14 | St. Louis | Minnesota | 27137 | 636 | 20 |
435631 | 435631 | 2020-08-15 | St. Louis | Minnesota | 27137 | 650 | 20 |
438856 | 438856 | 2020-08-16 | St. Louis | Minnesota | 27137 | 670 | 21 |
442083 | 442083 | 2020-08-17 | St. Louis | Minnesota | 27137 | 677 | 21 |
445309 | 445309 | 2020-08-18 | St. Louis | Minnesota | 27137 | 681 | 21 |
448535 | 448535 | 2020-08-19 | St. Louis | Minnesota | 27137 | 696 | 21 |
451763 | 451763 | 2020-08-20 | St. Louis | Minnesota | 27137 | 707 | 21 |
454991 | 454991 | 2020-08-21 | St. Louis | Minnesota | 27137 | 725 | 21 |
458219 | 458219 | 2020-08-22 | St. Louis | Minnesota | 27137 | 741 | 21 |
461446 | 461446 | 2020-08-23 | St. Louis | Minnesota | 27137 | 748 | 22 |
464677 | 464677 | 2020-08-24 | St. Louis | Minnesota | 27137 | 768 | 22 |
467906 | 467906 | 2020-08-25 | St. Louis | Minnesota | 27137 | 777 | 23 |
471136 | 471136 | 2020-08-26 | St. Louis | Minnesota | 27137 | 790 | 23 |
474368 | 474368 | 2020-08-27 | St. Louis | Minnesota | 27137 | 808 | 23 |
477601 | 477601 | 2020-08-28 | St. Louis | Minnesota | 27137 | 832 | 23 |
480833 | 480833 | 2020-08-29 | St. Louis | Minnesota | 27137 | 851 | 23 |
484068 | 484068 | 2020-08-30 | St. Louis | Minnesota | 27137 | 867 | 23 |
487302 | 487302 | 2020-08-31 | St. Louis | Minnesota | 27137 | 885 | 23 |
490535 | 490535 | 2020-09-01 | St. Louis | Minnesota | 27137 | 902 | 23 |
493769 | 493769 | 2020-09-02 | St. Louis | Minnesota | 27137 | 908 | 24 |
497002 | 497002 | 2020-09-03 | St. Louis | Minnesota | 27137 | 922 | 24 |
500236 | 500236 | 2020-09-04 | St. Louis | Minnesota | 27137 | 947 | 24 |
503470 | 503470 | 2020-09-05 | St. Louis | Minnesota | 27137 | 972 | 24 |
506703 | 506703 | 2020-09-06 | St. Louis | Minnesota | 27137 | 1001 | 24 |
509936 | 509936 | 2020-09-07 | St. Louis | Minnesota | 27137 | 1032 | 24 |
513168 | 513168 | 2020-09-08 | St. Louis | Minnesota | 27137 | 1040 | 24 |
516402 | 516402 | 2020-09-09 | St. Louis | Minnesota | 27137 | 1061 | 24 |
519637 | 519637 | 2020-09-10 | St. Louis | Minnesota | 27137 | 1073 | 25 |
522874 | 522874 | 2020-09-11 | St. Louis | Minnesota | 27137 | 1090 | 25 |
526110 | 526110 | 2020-09-12 | St. Louis | Minnesota | 27137 | 1118 | 26 |
529346 | 529346 | 2020-09-13 | St. Louis | Minnesota | 27137 | 1145 | 28 |
532582 | 532582 | 2020-09-14 | St. Louis | Minnesota | 27137 | 1161 | 28 |
535817 | 535817 | 2020-09-15 | St. Louis | Minnesota | 27137 | 1173 | 28 |
539054 | 539054 | 2020-09-16 | St. Louis | Minnesota | 27137 | 1202 | 28 |
542290 | 542290 | 2020-09-17 | St. Louis | Minnesota | 27137 | 1233 | 29 |
545527 | 545527 | 2020-09-18 | St. Louis | Minnesota | 27137 | 1282 | 29 |
548765 | 548765 | 2020-09-19 | St. Louis | Minnesota | 27137 | 1317 | 33 |
552004 | 552004 | 2020-09-20 | St. Louis | Minnesota | 27137 | 1352 | 34 |
555242 | 555242 | 2020-09-21 | St. Louis | Minnesota | 27137 | 1400 | 34 |
558479 | 558479 | 2020-09-22 | St. Louis | Minnesota | 27137 | 1419 | 36 |
561716 | 561716 | 2020-09-23 | St. Louis | Minnesota | 27137 | 1451 | 38 |
564956 | 564956 | 2020-09-24 | St. Louis | Minnesota | 27137 | 1480 | 39 |
568196 | 568196 | 2020-09-25 | St. Louis | Minnesota | 27137 | 1555 | 39 |
571438 | 571438 | 2020-09-26 | St. Louis | Minnesota | 27137 | 1602 | 41 |
574681 | 574681 | 2020-09-27 | St. Louis | Minnesota | 27137 | 1618 | 41 |
577922 | 577922 | 2020-09-28 | St. Louis | Minnesota | 27137 | 1659 | 41 |
581163 | 581163 | 2020-09-29 | St. Louis | Minnesota | 27137 | 1725 | 42 |
584404 | 584404 | 2020-09-30 | St. Louis | Minnesota | 27137 | 1747 | 42 |
587644 | 587644 | 2020-10-01 | St. Louis | Minnesota | 27137 | 1800 | 43 |
590885 | 590885 | 2020-10-02 | St. Louis | Minnesota | 27137 | 1840 | 46 |
594126 | 594126 | 2020-10-03 | St. Louis | Minnesota | 27137 | 1877 | 49 |
597367 | 597367 | 2020-10-04 | St. Louis | Minnesota | 27137 | 1908 | 49 |
600610 | 600610 | 2020-10-05 | St. Louis | Minnesota | 27137 | 1956 | 49 |
603852 | 603852 | 2020-10-06 | St. Louis | Minnesota | 27137 | 2007 | 49 |
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);