ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
799 rows where fips = 27123 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 687 ✖
- 1 5
- 8 4
- 56793 4
- 81204 4
- 84152 4
- 97537 4
- 121272 4
- 52603 3
- 52665 3
- 52797 3
- 52997 3
- 53350 3
- 53817 3
- 54443 3
- 55146 3
- 55950 3
- 57560 3
- 58542 3
- 59431 3
- 60405 3
- 61496 3
- 62614 3
- 63444 3
- 64420 3
- 66439 3
- 68368 3
- 70528 3
- 72270 3
- 74981 3
- 77579 3
- 79628 3
- 89495 3
- 105569 3
- 113269 3
- 117587 3
- 119883 3
- 121714 3
- 122308 3
- 122914 3
- 123204 3
- 123468 3
- 123765 3
- 124064 3
- 124568 3
- 125201 3
- 126091 3
- 127350 3
- 2 2
- 152 2
- 1052 2
- 4805 2
- 25903 2
- 36203 2
- 37111 2
- 45574 2
- 52199 2
- 72008 2
- 3 1
- 4 1
- 12 1
- 16 1
- 17 1
- 18 1
- 24 1
- 26 1
- 27 1
- 32 1
- 34 1
- 42 1
- 46 1
- 50 1
- 56 1
- 66 1
- 67 1
- 71 1
- 79 1
- 91 1
- 96 1
- 101 1
- 112 1
- 121 1
- 124 1
- 132 1
- 153 1
- 164 1
- 177 1
- 178 1
- 192 1
- 196 1
- 202 1
- 215 1
- 219 1
- 235 1
- 247 1
- 261 1
- 278 1
- 297 1
- 317 1
- 332 1
- 374 1
- 405 1
- 453 1
- 493 1
- 535 1
- 583 1
- 656 1
- 717 1
- 800 1
- 875 1
- 920 1
- 986 1
- 1167 1
- 1287 1
- 1416 1
- 1530 1
- 1625 1
- 1720 1
- 1846 1
- 1925 1
- 2018 1
- 2164 1
- 2316 1
- 2437 1
- 2551 1
- 2610 1
- 2698 1
- 2790 1
- 2863 1
- 3019 1
- 3075 1
- 3128 1
- 3189 1
- 3252 1
- 3351 1
- 3445 1
- 3507 1
- 3553 1
- 3626 1
- 3680 1
- 3740 1
- 3813 1
- 3882 1
- 3936 1
- 3992 1
- 4033 1
- 4079 1
- 4128 1
- 4180 1
- 4244 1
- 4306 1
- 4352 1
- 4394 1
- 4424 1
- 4474 1
- 4508 1
- 4563 1
- 4610 1
- 4629 1
- 4685 1
- 4724 1
- 4777 1
- 4855 1
- 4911 1
- 4963 1
- 5013 1
- 5066 1
- 5127 1
- 5169 1
- 5256 1
- 5313 1
- 5357 1
- 5397 1
- 5470 1
- 5534 1
- 5585 1
- 5687 1
- 5719 1
- 5825 1
- 5890 1
- 5985 1
- 6070 1
- 6164 1
- 6253 1
- 6347 1
- 6416 1
- 6503 1
- 6607 1
- 6686 1
- 6763 1
- 6861 1
- 6944 1
- 7047 1
- 7130 1
- 7233 1
- 7307 1
- 7444 1
- 7572 1
- 7658 1
- 7717 1
- 7775 1
- 7827 1
- 7904 1
- 7969 1
- 8054 1
- 8132 1
- 8170 1
- 8234 1
- 8312 1
- 8412 1
- 8493 1
- 8594 1
- 8678 1
- 8720 1
- 8783 1
- 8856 1
- 8951 1
- 9070 1
- 9132 1
- 9203 1
- 9243 1
- 9311 1
- 9396 1
- 9492 1
- 9574 1
- 9646 1
- 9699 1
- 9727 1
- 9749 1
- 9805 1
- 9899 1
- 9987 1
- 10060 1
- 10111 1
- 10145 1
- 10166 1
- 10267 1
- 10349 1
- 10410 1
- 10492 1
- 10572 1
- 10595 1
- 10635 1
- 10697 1
- 10775 1
- 10911 1
- 10985 1
- 11088 1
- 11167 1
- 11209 1
- 11278 1
- 11340 1
- 11501 1
- 11573 1
- 11646 1
- 11733 1
- 11833 1
- 11916 1
- 12027 1
- 12170 1
- 12302 1
- 12423 1
- 12532 1
- 12656 1
- 12786 1
- 12922 1
- 13063 1
- 13185 1
- 13342 1
- 13430 1
- 13510 1
- 13609 1
- 13782 1
- 13909 1
- 14073 1
- 14168 1
- 14342 1
- 14471 1
- 14726 1
- 14966 1
- 15139 1
- 15318 1
- 15547 1
- 15853 1
- 16189 1
- 16524 1
- 16971 1
- 17297 1
- 17822 1
- 18200 1
- 18649 1
- 18969 1
- 19535 1
- 20009 1
- 20698 1
- 21142 1
- 21659 1
- 22160 1
- 22497 1
- 23071 1
- 23623 1
- 24102 1
- 24528 1
- 24988 1
- 25467 1
- 26238 1
- 27059 1
- 27766 1
- 28256 1
- 28517 1
- 28948 1
- 29459 1
- 29902 1
- 30434 1
- 31002 1
- 31551 1
- 31903 1
- 32324 1
- 32625 1
- 32975 1
- 33375 1
- 33697 1
- 34016 1
- 34300 1
- 34503 1
- 34750 1
- 34961 1
- 35208 1
- 35491 1
- 35696 1
- 35897 1
- 36066 1
- 36339 1
- 36582 1
- 36682 1
- 36756 1
- 36918 1
- 37330 1
- 37572 1
- 37849 1
- 37987 1
- 38193 1
- 38352 1
- 38539 1
- 38748 1
- 38963 1
- 39054 1
- 39186 1
- 39305 1
- 39405 1
- 39534 1
- 39703 1
- 39820 1
- 39917 1
- 40016 1
- 40134 1
- 40220 1
- 40370 1
- 40509 1
- 40624 1
- 40698 1
- 40752 1
- 40815 1
- 40916 1
- 41043 1
- 41132 1
- 41201 1
- 41282 1
- 41332 1
- 41383 1
- 41485 1
- 41578 1
- 41678 1
- 41742 1
- 41779 1
- 41829 1
- 41872 1
- 41937 1
- 42014 1
- 42101 1
- 42164 1
- 42221 1
- 42257 1
- 42308 1
- 42376 1
- 42468 1
- 42534 1
- 42602 1
- 42658 1
- 42700 1
- 42744 1
- 42807 1
- 42883 1
- 42945 1
- 43006 1
- 43047 1
- 43106 1
- 43165 1
- 43212 1
- 43273 1
- 43327 1
- 43388 1
- 43406 1
- 43556 1
- 43616 1
- 43660 1
- 43724 1
- 43796 1
- 43846 1
- 43890 1
- 43924 1
- 43984 1
- 44064 1
- 44141 1
- 44214 1
- 44265 1
- 44364 1
- 44421 1
- 44526 1
- 44649 1
- 44723 1
- 44848 1
- 44928 1
- 45027 1
- 45083 1
- 45179 1
- 45298 1
- 45433 1
- 45675 1
- 45899 1
- 46044 1
- 46218 1
- 46402 1
- 46611 1
- 46808 1
- 46957 1
- 47031 1
- 47188 1
- 47380 1
- 47562 1
- 47786 1
- 47939 1
- 48076 1
- 48174 1
- 48313 1
- 48500 1
- 48696 1
- 48877 1
- 49025 1
- 49134 1
- 49230 1
- 49383 1
- 49539 1
- 49674 1
- 49849 1
- 50015 1
- 50136 1
- 50221 1
- 50357 1
- 50494 1
- 50647 1
- 50779 1
- 50848 1
- 50981 1
- 51028 1
- 51127 1
- 51212 1
- 51369 1
- 51446 1
- 51530 1
- 51592 1
- 51644 1
- 51702 1
- 51792 1
- 51842 1
- 51893 1
- 51929 1
- 51973 1
- 51997 1
- 52049 1
- 52104 1
- 52149 1
- 52174 1
- 52219 1
- 52233 1
- 52256 1
- 52280 1
- 52314 1
- 52337 1
- 52351 1
- 52362 1
- 52375 1
- 52389 1
- 52401 1
- 52421 1
- 52437 1
- 52449 1
- 52461 1
- 52466 1
- 52480 1
- 52491 1
- 52501 1
- 52513 1
- 52516 1
- 52519 1
- 52525 1
- 52534 1
- 52537 1
- 52538 1
- 52546 1
- 52553 1
- 52559 1
- 52573 1
- 52577 1
- 52586 1
- 52619 1
- 52639 1
- 52654 1
- 52686 1
- 52730 1
- 52755 1
- 52766 1
- 52813 1
- 52873 1
- 52913 1
- 52955 1
- 53049 1
- 53172 1
- 53242 1
- 53281 1
- 53413 1
- 53587 1
- 53670 1
- 53739 1
- 53930 1
- 54083 1
- 54228 1
- 54316 1
- 54593 1
- 54825 1
- 54937 1
- 55016 1
- 55282 1
- 55549 1
- 55657 1
- 55811 1
- 56074 1
- 56387 1
- 56508 1
- 56641 1
- 56935 1
- 57335 1
- 57420 1
- 57730 1
- 58054 1
- 58216 1
- 58358 1
- 58714 1
- 59044 1
- 59138 1
- 59270 1
- 59611 1
- 59964 1
- 60078 1
- 60222 1
- 60583 1
- 60958 1
- 61158 1
- 61278 1
- 61674 1
- 62157 1
- 62280 1
- 62446 1
- 62763 1
- 63091 1
- 63195 1
- 63323 1
- 63557 1
- 63983 1
- 64089 1
- 64216 1
- 65279 1
- 65800 1
- 65997 1
- 66245 1
- 66735 1
- 67269 1
- 67640 1
- 68049 1
- 68757 1
- 69557 1
- 69808 1
- 70175 1
- 70883 1
- 71727 1
- 72634 1
- 73678 1
- 73971 1
- 74470 1
- 75496 1
- 76644 1
- 76885 1
- 77216 1
- 77901 1
- 78738 1
- 78942 1
- 79306 1
- 79951 1
- 80650 1
- 80878 1
- 81551 1
- 82636 1
- 83285 1
- 85048 1
- 87308 1
- 87732 1
- 88614 1
- 90778 1
- 93699 1
- 94608 1
- 96274 1
- 98579 1
- 101870 1
- 103109 1
- 106676 1
- 108945 1
- 110187 1
- 112428 1
- 114533 1
- 115859 1
- 116735 1
- 117123 1
- 118073 1
- 118777 1
- 119258 1
- 119634 1
- 120332 1
- 120608 1
- 120705 1
- 120786 1
- 121407 1
- 121524 1
- 121634 1
- 121779 1
- 121952 1
- 122174 1
- 122235 1
- 122419 1
- 122564 1
- 122613 1
- 122685 1
- 122969 1
- 123037 1
- 123128 1
- 123165 1
- 123237 1
- 123348 1
- 123376 1
- 123409 1
- 123509 1
- 123630 1
- 123665 1
- 123713 1
- 123821 1
- 123917 1
- 123950 1
- 124009 1
- 124152 1
- 124284 1
- 124381 1
- 124464 1
- 124674 1
- 124862 1
- 124947 1
- 125038 1
- 125305 1
- 125580 1
- 125736 1
- 125906 1
- 126249 1
- 126543 1
- 126823 1
- 127072 1
- 127643 1
- 128183 1
- 128358 1
- 128653 1
- 129009 1
state 1
- Minnesota 799
fips 1
- 27123 · 799 ✖
county 1
- Ramsey 799
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500966 | 2500966 | 2022-05-13 | Ramsey | Minnesota | 27123 | 129009 | 1348 |
2497708 | 2497708 | 2022-05-12 | Ramsey | Minnesota | 27123 | 128653 | 1348 |
2494450 | 2494450 | 2022-05-11 | Ramsey | Minnesota | 27123 | 128358 | 1346 |
2491192 | 2491192 | 2022-05-10 | Ramsey | Minnesota | 27123 | 128183 | 1345 |
2487935 | 2487935 | 2022-05-09 | Ramsey | Minnesota | 27123 | 127643 | 1344 |
2484677 | 2484677 | 2022-05-08 | Ramsey | Minnesota | 27123 | 127350 | 1343 |
2481419 | 2481419 | 2022-05-07 | Ramsey | Minnesota | 27123 | 127350 | 1343 |
2478161 | 2478161 | 2022-05-06 | Ramsey | Minnesota | 27123 | 127350 | 1343 |
2474903 | 2474903 | 2022-05-05 | Ramsey | Minnesota | 27123 | 127072 | 1341 |
2471646 | 2471646 | 2022-05-04 | Ramsey | Minnesota | 27123 | 126823 | 1339 |
2468390 | 2468390 | 2022-05-03 | Ramsey | Minnesota | 27123 | 126543 | 1337 |
2465135 | 2465135 | 2022-05-02 | Ramsey | Minnesota | 27123 | 126249 | 1337 |
2461879 | 2461879 | 2022-05-01 | Ramsey | Minnesota | 27123 | 126091 | 1337 |
2458623 | 2458623 | 2022-04-30 | Ramsey | Minnesota | 27123 | 126091 | 1337 |
2455367 | 2455367 | 2022-04-29 | Ramsey | Minnesota | 27123 | 126091 | 1337 |
2452111 | 2452111 | 2022-04-28 | Ramsey | Minnesota | 27123 | 125906 | 1336 |
2448855 | 2448855 | 2022-04-27 | Ramsey | Minnesota | 27123 | 125736 | 1336 |
2445599 | 2445599 | 2022-04-26 | Ramsey | Minnesota | 27123 | 125580 | 1336 |
2442343 | 2442343 | 2022-04-25 | Ramsey | Minnesota | 27123 | 125305 | 1336 |
2439087 | 2439087 | 2022-04-24 | Ramsey | Minnesota | 27123 | 125201 | 1336 |
2435831 | 2435831 | 2022-04-23 | Ramsey | Minnesota | 27123 | 125201 | 1336 |
2432575 | 2432575 | 2022-04-22 | Ramsey | Minnesota | 27123 | 125201 | 1336 |
2429319 | 2429319 | 2022-04-21 | Ramsey | Minnesota | 27123 | 125038 | 1335 |
2426063 | 2426063 | 2022-04-20 | Ramsey | Minnesota | 27123 | 124947 | 1335 |
2422807 | 2422807 | 2022-04-19 | Ramsey | Minnesota | 27123 | 124862 | 1335 |
2419551 | 2419551 | 2022-04-18 | Ramsey | Minnesota | 27123 | 124674 | 1333 |
2416295 | 2416295 | 2022-04-17 | Ramsey | Minnesota | 27123 | 124568 | 1333 |
2413039 | 2413039 | 2022-04-16 | Ramsey | Minnesota | 27123 | 124568 | 1333 |
2409783 | 2409783 | 2022-04-15 | Ramsey | Minnesota | 27123 | 124568 | 1333 |
2406527 | 2406527 | 2022-04-14 | Ramsey | Minnesota | 27123 | 124464 | 1332 |
2403271 | 2403271 | 2022-04-13 | Ramsey | Minnesota | 27123 | 124381 | 1332 |
2400017 | 2400017 | 2022-04-12 | Ramsey | Minnesota | 27123 | 124284 | 1332 |
2396761 | 2396761 | 2022-04-11 | Ramsey | Minnesota | 27123 | 124152 | 1332 |
2393506 | 2393506 | 2022-04-10 | Ramsey | Minnesota | 27123 | 124064 | 1331 |
2390250 | 2390250 | 2022-04-09 | Ramsey | Minnesota | 27123 | 124064 | 1331 |
2386994 | 2386994 | 2022-04-08 | Ramsey | Minnesota | 27123 | 124064 | 1331 |
2383739 | 2383739 | 2022-04-07 | Ramsey | Minnesota | 27123 | 124009 | 1330 |
2380484 | 2380484 | 2022-04-06 | Ramsey | Minnesota | 27123 | 123950 | 1329 |
2377229 | 2377229 | 2022-04-05 | Ramsey | Minnesota | 27123 | 123917 | 1328 |
2373977 | 2373977 | 2022-04-04 | Ramsey | Minnesota | 27123 | 123821 | 1328 |
2370724 | 2370724 | 2022-04-03 | Ramsey | Minnesota | 27123 | 123765 | 1328 |
2367471 | 2367471 | 2022-04-02 | Ramsey | Minnesota | 27123 | 123765 | 1328 |
2364218 | 2364218 | 2022-04-01 | Ramsey | Minnesota | 27123 | 123765 | 1328 |
2360964 | 2360964 | 2022-03-31 | Ramsey | Minnesota | 27123 | 123713 | 1328 |
2357710 | 2357710 | 2022-03-30 | Ramsey | Minnesota | 27123 | 123665 | 1328 |
2354457 | 2354457 | 2022-03-29 | Ramsey | Minnesota | 27123 | 123630 | 1327 |
2351205 | 2351205 | 2022-03-28 | Ramsey | Minnesota | 27123 | 123509 | 1327 |
2347952 | 2347952 | 2022-03-27 | Ramsey | Minnesota | 27123 | 123468 | 1325 |
2344699 | 2344699 | 2022-03-26 | Ramsey | Minnesota | 27123 | 123468 | 1325 |
2341446 | 2341446 | 2022-03-25 | Ramsey | Minnesota | 27123 | 123468 | 1325 |
2338193 | 2338193 | 2022-03-24 | Ramsey | Minnesota | 27123 | 123409 | 1325 |
2334939 | 2334939 | 2022-03-23 | Ramsey | Minnesota | 27123 | 123376 | 1323 |
2331685 | 2331685 | 2022-03-22 | Ramsey | Minnesota | 27123 | 123348 | 1323 |
2328433 | 2328433 | 2022-03-21 | Ramsey | Minnesota | 27123 | 123237 | 1322 |
2325180 | 2325180 | 2022-03-20 | Ramsey | Minnesota | 27123 | 123204 | 1322 |
2321926 | 2321926 | 2022-03-19 | Ramsey | Minnesota | 27123 | 123204 | 1322 |
2318672 | 2318672 | 2022-03-18 | Ramsey | Minnesota | 27123 | 123204 | 1322 |
2315419 | 2315419 | 2022-03-17 | Ramsey | Minnesota | 27123 | 123165 | 1322 |
2312166 | 2312166 | 2022-03-16 | Ramsey | Minnesota | 27123 | 123128 | 1322 |
2308913 | 2308913 | 2022-03-15 | Ramsey | Minnesota | 27123 | 123037 | 1320 |
2305662 | 2305662 | 2022-03-14 | Ramsey | Minnesota | 27123 | 122969 | 1320 |
2302410 | 2302410 | 2022-03-13 | Ramsey | Minnesota | 27123 | 122914 | 1317 |
2299158 | 2299158 | 2022-03-12 | Ramsey | Minnesota | 27123 | 122914 | 1317 |
2295906 | 2295906 | 2022-03-11 | Ramsey | Minnesota | 27123 | 122914 | 1317 |
2292654 | 2292654 | 2022-03-10 | Ramsey | Minnesota | 27123 | 122685 | 1317 |
2289402 | 2289402 | 2022-03-09 | Ramsey | Minnesota | 27123 | 122613 | 1313 |
2286151 | 2286151 | 2022-03-08 | Ramsey | Minnesota | 27123 | 122564 | 1313 |
2282899 | 2282899 | 2022-03-07 | Ramsey | Minnesota | 27123 | 122419 | 1310 |
2279646 | 2279646 | 2022-03-06 | Ramsey | Minnesota | 27123 | 122308 | 1308 |
2276393 | 2276393 | 2022-03-05 | Ramsey | Minnesota | 27123 | 122308 | 1308 |
2273140 | 2273140 | 2022-03-04 | Ramsey | Minnesota | 27123 | 122308 | 1308 |
2269888 | 2269888 | 2022-03-03 | Ramsey | Minnesota | 27123 | 122235 | 1305 |
2266635 | 2266635 | 2022-03-02 | Ramsey | Minnesota | 27123 | 122174 | 1305 |
2263384 | 2263384 | 2022-03-01 | Ramsey | Minnesota | 27123 | 121952 | 1303 |
2260133 | 2260133 | 2022-02-28 | Ramsey | Minnesota | 27123 | 121779 | 1302 |
2256882 | 2256882 | 2022-02-27 | Ramsey | Minnesota | 27123 | 121714 | 1301 |
2253631 | 2253631 | 2022-02-26 | Ramsey | Minnesota | 27123 | 121714 | 1301 |
2250380 | 2250380 | 2022-02-25 | Ramsey | Minnesota | 27123 | 121714 | 1301 |
2247129 | 2247129 | 2022-02-24 | Ramsey | Minnesota | 27123 | 121634 | 1301 |
2243878 | 2243878 | 2022-02-23 | Ramsey | Minnesota | 27123 | 121524 | 1300 |
2240627 | 2240627 | 2022-02-22 | Ramsey | Minnesota | 27123 | 121407 | 1298 |
2237376 | 2237376 | 2022-02-21 | Ramsey | Minnesota | 27123 | 121272 | 1293 |
2234125 | 2234125 | 2022-02-20 | Ramsey | Minnesota | 27123 | 121272 | 1293 |
2230874 | 2230874 | 2022-02-19 | Ramsey | Minnesota | 27123 | 121272 | 1293 |
2227623 | 2227623 | 2022-02-18 | Ramsey | Minnesota | 27123 | 121272 | 1293 |
2224372 | 2224372 | 2022-02-17 | Ramsey | Minnesota | 27123 | 120786 | 1291 |
2221121 | 2221121 | 2022-02-16 | Ramsey | Minnesota | 27123 | 120705 | 1287 |
2217870 | 2217870 | 2022-02-15 | Ramsey | Minnesota | 27123 | 120608 | 1280 |
2214619 | 2214619 | 2022-02-14 | Ramsey | Minnesota | 27123 | 120332 | 1279 |
2211367 | 2211367 | 2022-02-13 | Ramsey | Minnesota | 27123 | 119883 | 1278 |
2208114 | 2208114 | 2022-02-12 | Ramsey | Minnesota | 27123 | 119883 | 1278 |
2204861 | 2204861 | 2022-02-11 | Ramsey | Minnesota | 27123 | 119883 | 1278 |
2201608 | 2201608 | 2022-02-10 | Ramsey | Minnesota | 27123 | 119634 | 1275 |
2198354 | 2198354 | 2022-02-09 | Ramsey | Minnesota | 27123 | 119258 | 1269 |
2195100 | 2195100 | 2022-02-08 | Ramsey | Minnesota | 27123 | 118777 | 1265 |
2191846 | 2191846 | 2022-02-07 | Ramsey | Minnesota | 27123 | 118073 | 1263 |
2188593 | 2188593 | 2022-02-06 | Ramsey | Minnesota | 27123 | 117587 | 1258 |
2185340 | 2185340 | 2022-02-05 | Ramsey | Minnesota | 27123 | 117587 | 1258 |
2182088 | 2182088 | 2022-02-04 | Ramsey | Minnesota | 27123 | 117587 | 1258 |
2178836 | 2178836 | 2022-02-03 | Ramsey | Minnesota | 27123 | 117123 | 1257 |
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);