ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where county = "Green" and fips = 55045 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 573 ✖
- 9 18
- 3659 13
- 1 7
- 11 5
- 71 5
- 3657 5
- 3681 5
- 5537 5
- 75 4
- 110 4
- 3629 4
- 3642 4
- 3651 4
- 3666 4
- 33 3
- 49 3
- 66 3
- 70 3
- 78 3
- 80 3
- 119 3
- 121 3
- 796 3
- 3620 3
- 3648 3
- 3655 3
- 3660 3
- 3661 3
- 3690 3
- 3705 3
- 3747 3
- 3782 3
- 3857 3
- 3947 3
- 4037 3
- 4112 3
- 4184 3
- 4272 3
- 4365 3
- 4432 3
- 4565 3
- 4657 3
- 4785 3
- 4959 3
- 5167 3
- 5349 3
- 5739 3
- 5924 3
- 6107 3
- 6299 3
- 6607 3
- 7261 3
- 7951 3
- 8354 3
- 8585 3
- 8742 3
- 8844 3
- 8890 3
- 8921 3
- 8961 3
- 9039 3
- 9079 3
- 9107 3
- 9166 3
- 9217 3
- 9260 3
- 9335 3
- 9430 3
- 4 2
- 7 2
- 8 2
- 10 2
- 13 2
- 20 2
- 39 2
- 88 2
- 89 2
- 100 2
- 114 2
- 118 2
- 120 2
- 131 2
- 270 2
- 2430 2
- 2438 2
- 3257 2
- 3390 2
- 3530 2
- 3548 2
- 3581 2
- 3621 2
- 3637 2
- 3638 2
- 3644 2
- 3649 2
- 3664 2
- 3685 2
- 3699 2
- 9228 2
- 3 1
- 5 1
- 6 1
- 12 1
- 15 1
- 16 1
- 21 1
- 23 1
- 34 1
- 36 1
- 41 1
- 44 1
- 45 1
- 46 1
- 52 1
- 53 1
- 54 1
- 55 1
- 58 1
- 60 1
- 65 1
- 68 1
- 72 1
- 77 1
- 79 1
- 81 1
- 83 1
- 84 1
- 85 1
- 90 1
- 93 1
- 94 1
- 96 1
- 101 1
- 103 1
- 105 1
- 106 1
- 113 1
- 116 1
- 117 1
- 123 1
- 125 1
- 130 1
- 135 1
- 137 1
- 149 1
- 158 1
- 162 1
- 167 1
- 169 1
- 179 1
- 186 1
- 194 1
- 210 1
- 214 1
- 220 1
- 221 1
- 225 1
- 229 1
- 235 1
- 247 1
- 249 1
- 250 1
- 255 1
- 256 1
- 261 1
- 262 1
- 265 1
- 268 1
- 269 1
- 272 1
- 298 1
- 302 1
- 310 1
- 324 1
- 330 1
- 336 1
- 342 1
- 352 1
- 360 1
- 377 1
- 378 1
- 382 1
- 391 1
- 404 1
- 415 1
- 449 1
- 456 1
- 463 1
- 469 1
- 478 1
- 486 1
- 495 1
- 505 1
- 535 1
- 548 1
- 558 1
- 580 1
- 587 1
- 595 1
- 606 1
- 622 1
- 637 1
- 642 1
- 655 1
- 670 1
- 679 1
- 683 1
- 702 1
- 721 1
- 737 1
- 762 1
- 780 1
- 836 1
- 848 1
- 867 1
- 877 1
- 905 1
- 924 1
- 936 1
- 943 1
- 951 1
- 977 1
- 1002 1
- 1019 1
- 1050 1
- 1078 1
- 1083 1
- 1088 1
- 1115 1
- 1147 1
- 1162 1
- 1202 1
- 1234 1
- 1245 1
- 1268 1
- 1286 1
- 1324 1
- 1353 1
- 1357 1
- 1414 1
- 1431 1
- 1445 1
- 1467 1
- 1502 1
- 1522 1
- 1547 1
- 1570 1
- 1580 1
- 1593 1
- 1627 1
- 1640 1
- 1673 1
- 1683 1
- 1702 1
- 1718 1
- 1726 1
- 1768 1
- 1797 1
- 1839 1
- 1889 1
- 1900 1
- 1905 1
- 1916 1
- 1954 1
- 1967 1
- 2005 1
- 2041 1
- 2057 1
- 2067 1
- 2071 1
- 2093 1
- 2130 1
- 2167 1
- 2181 1
- 2202 1
- 2206 1
- 2213 1
- 2245 1
- 2268 1
- 2296 1
- 2309 1
- 2318 1
- 2327 1
- 2340 1
- 2376 1
- 2392 1
- 2407 1
- 2459 1
- 2471 1
- 2489 1
- 2511 1
- 2523 1
- 2527 1
- 2542 1
- 2566 1
- 2578 1
- 2597 1
- 2614 1
- 2625 1
- 2630 1
- 2635 1
- 2649 1
- 2659 1
- 2683 1
- 2705 1
- 2712 1
- 2716 1
- 2730 1
- 2756 1
- 2773 1
- 2805 1
- 2812 1
- 2829 1
- 2837 1
- 2844 1
- 2874 1
- 2901 1
- 2922 1
- 2940 1
- 2950 1
- 2957 1
- 2962 1
- 3000 1
- 3017 1
- 3045 1
- 3067 1
- 3075 1
- 3080 1
- 3087 1
- 3119 1
- 3131 1
- 3151 1
- 3175 1
- 3185 1
- 3186 1
- 3190 1
- 3209 1
- 3219 1
- 3230 1
- 3256 1
- 3262 1
- 3280 1
- 3288 1
- 3292 1
- 3297 1
- 3300 1
- 3302 1
- 3309 1
- 3326 1
- 3333 1
- 3343 1
- 3351 1
- 3355 1
- 3356 1
- 3357 1
- 3368 1
- 3372 1
- 3377 1
- 3384 1
- 3387 1
- 3410 1
- 3419 1
- 3434 1
- 3447 1
- 3456 1
- 3461 1
- 3467 1
- 3478 1
- 3483 1
- 3486 1
- 3491 1
- 3495 1
- 3496 1
- 3501 1
- 3504 1
- 3512 1
- 3520 1
- 3527 1
- 3529 1
- 3537 1
- 3540 1
- 3545 1
- 3550 1
- 3553 1
- 3561 1
- 3568 1
- 3576 1
- 3578 1
- 3583 1
- 3587 1
- 3590 1
- 3600 1
- 3603 1
- 3607 1
- 3608 1
- 3609 1
- 3616 1
- 3618 1
- 3619 1
- 3622 1
- 3625 1
- 3633 1
- 3636 1
- 3639 1
- 3641 1
- 3645 1
- 3646 1
- 3652 1
- 3654 1
- 3662 1
- 3665 1
- 3672 1
- 3683 1
- 3686 1
- 3692 1
- 3694 1
- 3717 1
- 3721 1
- 3728 1
- 3736 1
- 3756 1
- 3760 1
- 3769 1
- 3777 1
- 3808 1
- 3819 1
- 3833 1
- 3843 1
- 3882 1
- 3896 1
- 3916 1
- 3939 1
- 3985 1
- 3995 1
- 4006 1
- 4025 1
- 4051 1
- 4063 1
- 4077 1
- 4098 1
- 4139 1
- 4141 1
- 4164 1
- 4175 1
- 4220 1
- 4225 1
- 4251 1
- 4256 1
- 4305 1
- 4323 1
- 4343 1
- 4350 1
- 4393 1
- 4402 1
- 4418 1
- 4474 1
- 4498 1
- 4509 1
- 4522 1
- 4545 1
- 4598 1
- 4610 1
- 4618 1
- 4628 1
- 4705 1
- 4712 1
- 4728 1
- 4757 1
- 4858 1
- 4875 1
- 4907 1
- 4943 1
- 5044 1
- 5067 1
- 5090 1
- 5146 1
- 5235 1
- 5253 1
- 5286 1
- 5314 1
- 5407 1
- 5426 1
- 5465 1
- 5500 1
- 5652 1
- 5696 1
- 5817 1
- 5837 1
- 5856 1
- 5893 1
- 5995 1
- 6028 1
- 6061 1
- 6086 1
- 6167 1
- 6181 1
- 6203 1
- 6250 1
- 6404 1
- 6435 1
- 6497 1
- 6545 1
- 6839 1
- 6917 1
- 6988 1
- 7108 1
- 7526 1
- 7598 1
- 7699 1
- 7840 1
- 8130 1
- 8177 1
- 8243 1
- 8309 1
- 8455 1
- 8469 1
- 8510 1
- 8554 1
- 8649 1
- 8667 1
- 8695 1
- 8717 1
- 8782 1
- 8784 1
- 8801 1
- 8819 1
- 8866 1
- 8871 1
- 8883 1
- 8886 1
- 8898 1
- 8902 1
- 8910 1
- 8914 1
- 8936 1
- 8937 1
- 8944 1
- 8952 1
- 8983 1
- 8998 1
- 9013 1
- 9029 1
- 9053 1
- 9056 1
- 9065 1
- 9071 1
- 9083 1
- 9087 1
- 9092 1
- 9099 1
- 9131 1
- 9135 1
- 9153 1
- 9160 1
- 9182 1
- 9196 1
- 9204 1
- 9214 1
- 9241 1
- 9251 1
- 9284 1
- 9297 1
- 9309 1
- 9320 1
- 9362 1
- 9373 1
- 9403 1
- 9414 1
- 9454 1
- 9469 1
- 9483 1
- 9504 1
- 9528 1
state 1
- Wisconsin 785
fips 1
- 55045 · 785 ✖
county 1
- Green · 785 ✖
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2502760 | 2502760 | 2022-05-13 | Green | Wisconsin | 55045 | 9528 | 54 |
2499502 | 2499502 | 2022-05-12 | Green | Wisconsin | 55045 | 9504 | 54 |
2496244 | 2496244 | 2022-05-11 | Green | Wisconsin | 55045 | 9483 | 54 |
2492986 | 2492986 | 2022-05-10 | Green | Wisconsin | 55045 | 9469 | 54 |
2489728 | 2489728 | 2022-05-09 | Green | Wisconsin | 55045 | 9454 | 54 |
2486471 | 2486471 | 2022-05-08 | Green | Wisconsin | 55045 | 9430 | 54 |
2483213 | 2483213 | 2022-05-07 | Green | Wisconsin | 55045 | 9430 | 54 |
2479955 | 2479955 | 2022-05-06 | Green | Wisconsin | 55045 | 9430 | 54 |
2476697 | 2476697 | 2022-05-05 | Green | Wisconsin | 55045 | 9414 | 53 |
2473439 | 2473439 | 2022-05-04 | Green | Wisconsin | 55045 | 9403 | 53 |
2470182 | 2470182 | 2022-05-03 | Green | Wisconsin | 55045 | 9373 | 53 |
2466926 | 2466926 | 2022-05-02 | Green | Wisconsin | 55045 | 9362 | 53 |
2463671 | 2463671 | 2022-05-01 | Green | Wisconsin | 55045 | 9335 | 53 |
2460415 | 2460415 | 2022-04-30 | Green | Wisconsin | 55045 | 9335 | 53 |
2457159 | 2457159 | 2022-04-29 | Green | Wisconsin | 55045 | 9335 | 53 |
2453903 | 2453903 | 2022-04-28 | Green | Wisconsin | 55045 | 9320 | 53 |
2450647 | 2450647 | 2022-04-27 | Green | Wisconsin | 55045 | 9309 | 53 |
2447391 | 2447391 | 2022-04-26 | Green | Wisconsin | 55045 | 9297 | 53 |
2444135 | 2444135 | 2022-04-25 | Green | Wisconsin | 55045 | 9284 | 53 |
2440879 | 2440879 | 2022-04-24 | Green | Wisconsin | 55045 | 9260 | 53 |
2437623 | 2437623 | 2022-04-23 | Green | Wisconsin | 55045 | 9260 | 53 |
2434367 | 2434367 | 2022-04-22 | Green | Wisconsin | 55045 | 9260 | 53 |
2431111 | 2431111 | 2022-04-21 | Green | Wisconsin | 55045 | 9251 | 53 |
2427855 | 2427855 | 2022-04-20 | Green | Wisconsin | 55045 | 9241 | 53 |
2424599 | 2424599 | 2022-04-19 | Green | Wisconsin | 55045 | 9228 | 53 |
2421343 | 2421343 | 2022-04-18 | Green | Wisconsin | 55045 | 9228 | 53 |
2418087 | 2418087 | 2022-04-17 | Green | Wisconsin | 55045 | 9217 | 53 |
2414831 | 2414831 | 2022-04-16 | Green | Wisconsin | 55045 | 9217 | 53 |
2411575 | 2411575 | 2022-04-15 | Green | Wisconsin | 55045 | 9217 | 53 |
2408319 | 2408319 | 2022-04-14 | Green | Wisconsin | 55045 | 9214 | 53 |
2405063 | 2405063 | 2022-04-13 | Green | Wisconsin | 55045 | 9204 | 53 |
2401808 | 2401808 | 2022-04-12 | Green | Wisconsin | 55045 | 9196 | 53 |
2398553 | 2398553 | 2022-04-11 | Green | Wisconsin | 55045 | 9182 | 53 |
2395298 | 2395298 | 2022-04-10 | Green | Wisconsin | 55045 | 9166 | 53 |
2392042 | 2392042 | 2022-04-09 | Green | Wisconsin | 55045 | 9166 | 53 |
2388786 | 2388786 | 2022-04-08 | Green | Wisconsin | 55045 | 9166 | 53 |
2385531 | 2385531 | 2022-04-07 | Green | Wisconsin | 55045 | 9160 | 53 |
2382276 | 2382276 | 2022-04-06 | Green | Wisconsin | 55045 | 9153 | 53 |
2379021 | 2379021 | 2022-04-05 | Green | Wisconsin | 55045 | 9135 | 53 |
2375767 | 2375767 | 2022-04-04 | Green | Wisconsin | 55045 | 9131 | 53 |
2372515 | 2372515 | 2022-04-03 | Green | Wisconsin | 55045 | 9107 | 53 |
2369262 | 2369262 | 2022-04-02 | Green | Wisconsin | 55045 | 9107 | 53 |
2366009 | 2366009 | 2022-04-01 | Green | Wisconsin | 55045 | 9107 | 53 |
2362756 | 2362756 | 2022-03-31 | Green | Wisconsin | 55045 | 9099 | 53 |
2359502 | 2359502 | 2022-03-30 | Green | Wisconsin | 55045 | 9092 | 53 |
2356248 | 2356248 | 2022-03-29 | Green | Wisconsin | 55045 | 9087 | 53 |
2352995 | 2352995 | 2022-03-28 | Green | Wisconsin | 55045 | 9083 | 53 |
2349743 | 2349743 | 2022-03-27 | Green | Wisconsin | 55045 | 9079 | 53 |
2346490 | 2346490 | 2022-03-26 | Green | Wisconsin | 55045 | 9079 | 53 |
2343237 | 2343237 | 2022-03-25 | Green | Wisconsin | 55045 | 9079 | 53 |
2339984 | 2339984 | 2022-03-24 | Green | Wisconsin | 55045 | 9071 | 53 |
2336731 | 2336731 | 2022-03-23 | Green | Wisconsin | 55045 | 9065 | 53 |
2333477 | 2333477 | 2022-03-22 | Green | Wisconsin | 55045 | 9056 | 53 |
2330223 | 2330223 | 2022-03-21 | Green | Wisconsin | 55045 | 9053 | 53 |
2326971 | 2326971 | 2022-03-20 | Green | Wisconsin | 55045 | 9039 | 53 |
2323718 | 2323718 | 2022-03-19 | Green | Wisconsin | 55045 | 9039 | 53 |
2320464 | 2320464 | 2022-03-18 | Green | Wisconsin | 55045 | 9039 | 53 |
2317210 | 2317210 | 2022-03-17 | Green | Wisconsin | 55045 | 9029 | 52 |
2313957 | 2313957 | 2022-03-16 | Green | Wisconsin | 55045 | 9013 | 52 |
2310704 | 2310704 | 2022-03-15 | Green | Wisconsin | 55045 | 8998 | 52 |
2307451 | 2307451 | 2022-03-14 | Green | Wisconsin | 55045 | 8983 | 52 |
2304200 | 2304200 | 2022-03-13 | Green | Wisconsin | 55045 | 8961 | 52 |
2300948 | 2300948 | 2022-03-12 | Green | Wisconsin | 55045 | 8961 | 52 |
2297696 | 2297696 | 2022-03-11 | Green | Wisconsin | 55045 | 8961 | 52 |
2294444 | 2294444 | 2022-03-10 | Green | Wisconsin | 55045 | 8952 | 52 |
2291192 | 2291192 | 2022-03-09 | Green | Wisconsin | 55045 | 8944 | 52 |
2287940 | 2287940 | 2022-03-08 | Green | Wisconsin | 55045 | 8937 | 52 |
2284688 | 2284688 | 2022-03-07 | Green | Wisconsin | 55045 | 8936 | 52 |
2281436 | 2281436 | 2022-03-06 | Green | Wisconsin | 55045 | 8921 | 52 |
2278183 | 2278183 | 2022-03-05 | Green | Wisconsin | 55045 | 8921 | 52 |
2274930 | 2274930 | 2022-03-04 | Green | Wisconsin | 55045 | 8921 | 52 |
2271677 | 2271677 | 2022-03-03 | Green | Wisconsin | 55045 | 8914 | 52 |
2268425 | 2268425 | 2022-03-02 | Green | Wisconsin | 55045 | 8910 | 52 |
2265172 | 2265172 | 2022-03-01 | Green | Wisconsin | 55045 | 8902 | 52 |
2261922 | 2261922 | 2022-02-28 | Green | Wisconsin | 55045 | 8898 | 51 |
2258671 | 2258671 | 2022-02-27 | Green | Wisconsin | 55045 | 8890 | 51 |
2255420 | 2255420 | 2022-02-26 | Green | Wisconsin | 55045 | 8890 | 51 |
2252169 | 2252169 | 2022-02-25 | Green | Wisconsin | 55045 | 8890 | 51 |
2248918 | 2248918 | 2022-02-24 | Green | Wisconsin | 55045 | 8886 | 51 |
2245667 | 2245667 | 2022-02-23 | Green | Wisconsin | 55045 | 8883 | 52 |
2242416 | 2242416 | 2022-02-22 | Green | Wisconsin | 55045 | 8871 | 52 |
2239165 | 2239165 | 2022-02-21 | Green | Wisconsin | 55045 | 8866 | 51 |
2235914 | 2235914 | 2022-02-20 | Green | Wisconsin | 55045 | 8844 | 50 |
2232663 | 2232663 | 2022-02-19 | Green | Wisconsin | 55045 | 8844 | 50 |
2229412 | 2229412 | 2022-02-18 | Green | Wisconsin | 55045 | 8844 | 50 |
2226161 | 2226161 | 2022-02-17 | Green | Wisconsin | 55045 | 8819 | 50 |
2222910 | 2222910 | 2022-02-16 | Green | Wisconsin | 55045 | 8801 | 50 |
2219659 | 2219659 | 2022-02-15 | Green | Wisconsin | 55045 | 8784 | 50 |
2216409 | 2216409 | 2022-02-14 | Green | Wisconsin | 55045 | 8782 | 50 |
2213158 | 2213158 | 2022-02-13 | Green | Wisconsin | 55045 | 8742 | 50 |
2209905 | 2209905 | 2022-02-12 | Green | Wisconsin | 55045 | 8742 | 50 |
2206652 | 2206652 | 2022-02-11 | Green | Wisconsin | 55045 | 8742 | 50 |
2203399 | 2203399 | 2022-02-10 | Green | Wisconsin | 55045 | 8717 | 50 |
2200145 | 2200145 | 2022-02-09 | Green | Wisconsin | 55045 | 8695 | 50 |
2196891 | 2196891 | 2022-02-08 | Green | Wisconsin | 55045 | 8667 | 50 |
2193636 | 2193636 | 2022-02-07 | Green | Wisconsin | 55045 | 8649 | 49 |
2190383 | 2190383 | 2022-02-06 | Green | Wisconsin | 55045 | 8585 | 49 |
2187130 | 2187130 | 2022-02-05 | Green | Wisconsin | 55045 | 8585 | 49 |
2183877 | 2183877 | 2022-02-04 | Green | Wisconsin | 55045 | 8585 | 49 |
2180625 | 2180625 | 2022-02-03 | Green | Wisconsin | 55045 | 8554 | 48 |
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);