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: cases, date (date)
deaths 462 ✖
- 0 15
- 910 12
- 2 9
- 1 7
- 888 7
- 911 7
- 917 7
- 1328 7
- 1336 7
- 217 6
- 859 6
- 895 6
- 1322 6
- 261 5
- 298 5
- 318 5
- 841 5
- 889 5
- 908 5
- 953 5
- 1337 5
- 9 4
- 326 4
- 335 4
- 780 4
- 870 4
- 886 4
- 905 4
- 913 4
- 918 4
- 930 4
- 936 4
- 964 4
- 1003 4
- 1012 4
- 1054 4
- 1111 4
- 1129 4
- 1174 4
- 1293 4
- 1301 4
- 1317 4
- 1325 4
- 1332 4
- 1333 4
- 3 3
- 6 3
- 253 3
- 254 3
- 302 3
- 313 3
- 698 3
- 787 3
- 833 3
- 835 3
- 837 3
- 847 3
- 864 3
- 875 3
- 876 3
- 887 3
- 898 3
- 902 3
- 907 3
- 912 3
- 923 3
- 924 3
- 944 3
- 950 3
- 957 3
- 972 3
- 980 3
- 993 3
- 1029 3
- 1040 3
- 1069 3
- 1096 3
- 1154 3
- 1201 3
- 1238 3
- 1258 3
- 1278 3
- 1308 3
- 1331 3
- 1335 3
- 1343 3
- 5 2
- 7 2
- 11 2
- 20 2
- 22 2
- 34 2
- 49 2
- 97 2
- 190 2
- 226 2
- 230 2
- 233 2
- 246 2
- 265 2
- 270 2
- 274 2
- 285 2
- 299 2
- 303 2
- 314 2
- 319 2
- 320 2
- 328 2
- 341 2
- 347 2
- 384 2
- 487 2
- 505 2
- 654 2
- 688 2
- 722 2
- 748 2
- 790 2
- 794 2
- 795 2
- 796 2
- 800 2
- 801 2
- 825 2
- 828 2
- 829 2
- 845 2
- 851 2
- 856 2
- 858 2
- 897 2
- 916 2
- 922 2
- 934 2
- 942 2
- 955 2
- 978 2
- 995 2
- 1036 2
- 1043 2
- 1065 2
- 1305 2
- 1313 2
- 1320 2
- 1323 2
- 1327 2
- 1348 2
- 10 1
- 14 1
- 18 1
- 24 1
- 26 1
- 29 1
- 31 1
- 37 1
- 38 1
- 39 1
- 42 1
- 43 1
- 45 1
- 47 1
- 56 1
- 61 1
- 67 1
- 71 1
- 72 1
- 74 1
- 80 1
- 86 1
- 93 1
- 94 1
- 98 1
- 103 1
- 110 1
- 115 1
- 122 1
- 124 1
- 128 1
- 133 1
- 134 1
- 140 1
- 149 1
- 152 1
- 155 1
- 158 1
- 164 1
- 167 1
- 169 1
- 180 1
- 182 1
- 192 1
- 199 1
- 205 1
- 207 1
- 209 1
- 210 1
- 211 1
- 213 1
- 215 1
- 218 1
- 222 1
- 227 1
- 228 1
- 229 1
- 232 1
- 234 1
- 237 1
- 238 1
- 247 1
- 248 1
- 249 1
- 250 1
- 251 1
- 257 1
- 258 1
- 259 1
- 260 1
- 263 1
- 267 1
- 268 1
- 269 1
- 272 1
- 275 1
- 279 1
- 280 1
- 282 1
- 286 1
- 287 1
- 291 1
- 296 1
- 301 1
- 305 1
- 308 1
- 310 1
- 316 1
- 322 1
- 323 1
- 325 1
- 330 1
- 331 1
- 333 1
- 337 1
- 338 1
- 346 1
- 352 1
- 355 1
- 357 1
- 358 1
- 360 1
- 361 1
- 362 1
- 364 1
- 372 1
- 377 1
- 380 1
- 383 1
- 388 1
- 390 1
- 392 1
- 399 1
- 406 1
- 407 1
- 413 1
- 419 1
- 423 1
- 424 1
- 429 1
- 430 1
- 433 1
- 434 1
- 441 1
- 450 1
- 457 1
- 461 1
- 470 1
- 472 1
- 477 1
- 493 1
- 502 1
- 507 1
- 512 1
- 521 1
- 526 1
- 535 1
- 540 1
- 545 1
- 548 1
- 554 1
- 566 1
- 576 1
- 585 1
- 590 1
- 592 1
- 593 1
- 607 1
- 613 1
- 618 1
- 623 1
- 631 1
- 633 1
- 636 1
- 649 1
- 661 1
- 663 1
- 665 1
- 672 1
- 680 1
- 694 1
- 708 1
- 710 1
- 713 1
- 718 1
- 723 1
- 726 1
- 729 1
- 730 1
- 735 1
- 736 1
- 738 1
- 739 1
- 741 1
- 742 1
- 746 1
- 749 1
- 750 1
- 753 1
- 756 1
- 760 1
- 762 1
- 764 1
- 765 1
- 767 1
- 770 1
- 773 1
- 776 1
- 778 1
- 783 1
- 784 1
- 788 1
- 792 1
- 798 1
- 803 1
- 805 1
- 808 1
- 810 1
- 811 1
- 812 1
- 826 1
- 827 1
- 830 1
- 831 1
- 832 1
- 834 1
- 836 1
- 840 1
- 842 1
- 843 1
- 846 1
- 850 1
- 853 1
- 860 1
- 861 1
- 863 1
- 865 1
- 867 1
- 868 1
- 871 1
- 873 1
- 879 1
- 881 1
- 885 1
- 890 1
- 893 1
- 894 1
- 896 1
- 899 1
- 901 1
- 903 1
- 904 1
- 909 1
- 915 1
- 921 1
- 929 1
- 932 1
- 938 1
- 945 1
- 958 1
- 959 1
- 960 1
- 963 1
- 966 1
- 969 1
- 971 1
- 976 1
- 977 1
- 983 1
- 985 1
- 986 1
- 991 1
- 999 1
- 1000 1
- 1002 1
- 1007 1
- 1009 1
- 1017 1
- 1020 1
- 1025 1
- 1030 1
- 1034 1
- 1046 1
- 1052 1
- 1059 1
- 1076 1
- 1082 1
- 1086 1
- 1090 1
- 1100 1
- 1103 1
- 1106 1
- 1112 1
- 1117 1
- 1123 1
- 1132 1
- 1136 1
- 1146 1
- 1149 1
- 1158 1
- 1162 1
- 1166 1
- 1172 1
- 1176 1
- 1181 1
- 1193 1
- 1205 1
- 1212 1
- 1219 1
- 1230 1
- 1240 1
- 1247 1
- 1253 1
- 1257 1
- 1263 1
- 1265 1
- 1269 1
- 1275 1
- 1279 1
- 1280 1
- 1287 1
- 1291 1
- 1298 1
- 1300 1
- 1302 1
- 1303 1
- 1310 1
- 1329 1
- 1330 1
- 1339 1
- 1341 1
- 1344 1
- 1345 1
- 1346 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);