ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
787 rows where fips = 28089 sorted by date
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 617 ✖
- 23987 8
- 24040 8
- 23930 7
- 23950 7
- 23969 7
- 24113 7
- 23911 6
- 24018 6
- 24079 6
- 922 5
- 14874 5
- 15359 5
- 24189 5
- 10335 4
- 16239 4
- 19442 4
- 23758 4
- 9990 3
- 10035 3
- 10066 3
- 10113 3
- 10152 3
- 10184 3
- 10194 3
- 10213 3
- 10263 3
- 10288 3
- 10391 3
- 10498 3
- 10692 3
- 10959 3
- 11352 3
- 11789 3
- 12520 3
- 12941 3
- 13418 3
- 13807 3
- 14043 3
- 14166 3
- 14356 3
- 14463 3
- 14525 3
- 14581 3
- 14680 3
- 14756 3
- 14793 3
- 14844 3
- 14954 3
- 15049 3
- 15183 3
- 17845 3
- 21129 3
- 21942 3
- 22994 3
- 23494 3
- 23838 3
- 23880 3
- 1 2
- 843 2
- 2556 2
- 3710 2
- 3831 2
- 9663 2
- 9720 2
- 10202 2
- 14781 2
- 3 1
- 7 1
- 9 1
- 11 1
- 14 1
- 17 1
- 21 1
- 25 1
- 29 1
- 37 1
- 38 1
- 42 1
- 53 1
- 55 1
- 65 1
- 67 1
- 72 1
- 74 1
- 82 1
- 83 1
- 88 1
- 95 1
- 99 1
- 103 1
- 106 1
- 108 1
- 112 1
- 116 1
- 123 1
- 127 1
- 135 1
- 140 1
- 144 1
- 151 1
- 165 1
- 178 1
- 186 1
- 194 1
- 208 1
- 212 1
- 224 1
- 229 1
- 251 1
- 268 1
- 272 1
- 286 1
- 298 1
- 318 1
- 333 1
- 404 1
- 422 1
- 431 1
- 466 1
- 491 1
- 493 1
- 502 1
- 507 1
- 526 1
- 533 1
- 543 1
- 561 1
- 573 1
- 582 1
- 618 1
- 639 1
- 653 1
- 654 1
- 675 1
- 687 1
- 694 1
- 709 1
- 720 1
- 724 1
- 742 1
- 745 1
- 757 1
- 767 1
- 778 1
- 788 1
- 796 1
- 807 1
- 832 1
- 864 1
- 877 1
- 886 1
- 889 1
- 905 1
- 995 1
- 1014 1
- 1034 1
- 1082 1
- 1112 1
- 1127 1
- 1145 1
- 1181 1
- 1206 1
- 1222 1
- 1242 1
- 1267 1
- 1296 1
- 1300 1
- 1314 1
- 1326 1
- 1355 1
- 1382 1
- 1419 1
- 1446 1
- 1484 1
- 1508 1
- 1560 1
- 1589 1
- 1630 1
- 1657 1
- 1681 1
- 1691 1
- 1740 1
- 1804 1
- 1852 1
- 1893 1
- 1978 1
- 2026 1
- 2058 1
- 2096 1
- 2139 1
- 2167 1
- 2211 1
- 2250 1
- 2272 1
- 2281 1
- 2297 1
- 2324 1
- 2363 1
- 2387 1
- 2396 1
- 2414 1
- 2422 1
- 2443 1
- 2455 1
- 2489 1
- 2503 1
- 2521 1
- 2538 1
- 2583 1
- 2662 1
- 2668 1
- 2693 1
- 2774 1
- 2786 1
- 2792 1
- 2802 1
- 2821 1
- 2845 1
- 2865 1
- 2939 1
- 2967 1
- 2971 1
- 2994 1
- 3009 1
- 3020 1
- 3039 1
- 3048 1
- 3057 1
- 3059 1
- 3062 1
- 3076 1
- 3095 1
- 3115 1
- 3123 1
- 3134 1
- 3136 1
- 3146 1
- 3164 1
- 3180 1
- 3190 1
- 3200 1
- 3208 1
- 3212 1
- 3218 1
- 3233 1
- 3265 1
- 3297 1
- 3310 1
- 3312 1
- 3314 1
- 3331 1
- 3341 1
- 3363 1
- 3374 1
- 3387 1
- 3389 1
- 3405 1
- 3441 1
- 3451 1
- 3463 1
- 3481 1
- 3501 1
- 3504 1
- 3511 1
- 3526 1
- 3552 1
- 3623 1
- 3683 1
- 3717 1
- 3739 1
- 3757 1
- 3779 1
- 3812 1
- 3837 1
- 3843 1
- 3861 1
- 3880 1
- 3894 1
- 3909 1
- 3914 1
- 3918 1
- 3930 1
- 3958 1
- 3986 1
- 4005 1
- 4034 1
- 4081 1
- 4098 1
- 4120 1
- 4146 1
- 4201 1
- 4244 1
- 4282 1
- 4300 1
- 4311 1
- 4339 1
- 4402 1
- 4462 1
- 4498 1
- 4573 1
- 4595 1
- 4602 1
- 4633 1
- 4666 1
- 4711 1
- 4734 1
- 4799 1
- 4902 1
- 4964 1
- 5014 1
- 5120 1
- 5202 1
- 5311 1
- 5368 1
- 5408 1
- 5433 1
- 5478 1
- 5532 1
- 5639 1
- 5726 1
- 5836 1
- 5889 1
- 5927 1
- 5997 1
- 6114 1
- 6196 1
- 6327 1
- 6379 1
- 6482 1
- 6517 1
- 6568 1
- 6665 1
- 6733 1
- 6783 1
- 6815 1
- 6859 1
- 6905 1
- 6961 1
- 7079 1
- 7194 1
- 7294 1
- 7342 1
- 7372 1
- 7418 1
- 7447 1
- 7551 1
- 7651 1
- 7723 1
- 7796 1
- 7853 1
- 7868 1
- 7893 1
- 7937 1
- 7994 1
- 8071 1
- 8186 1
- 8232 1
- 8262 1
- 8314 1
- 8335 1
- 8413 1
- 8495 1
- 8568 1
- 8599 1
- 8619 1
- 8663 1
- 8736 1
- 8785 1
- 8856 1
- 8893 1
- 8922 1
- 8941 1
- 8988 1
- 9009 1
- 9042 1
- 9075 1
- 9112 1
- 9147 1
- 9162 1
- 9180 1
- 9204 1
- 9227 1
- 9242 1
- 9262 1
- 9295 1
- 9307 1
- 9318 1
- 9324 1
- 9327 1
- 9333 1
- 9336 1
- 9340 1
- 9343 1
- 9353 1
- 9378 1
- 9400 1
- 9420 1
- 9432 1
- 9448 1
- 9457 1
- 9466 1
- 9480 1
- 9484 1
- 9499 1
- 9516 1
- 9522 1
- 9525 1
- 9533 1
- 9569 1
- 9615 1
- 9640 1
- 9661 1
- 9666 1
- 9681 1
- 9691 1
- 9700 1
- 9710 1
- 9741 1
- 9757 1
- 9775 1
- 9782 1
- 9788 1
- 9799 1
- 9803 1
- 9805 1
- 9816 1
- 9826 1
- 9831 1
- 9848 1
- 9855 1
- 9856 1
- 9859 1
- 9864 1
- 9872 1
- 9876 1
- 9886 1
- 9895 1
- 9896 1
- 9908 1
- 9922 1
- 9949 1
- 9950 1
- 9957 1
- 9963 1
- 9965 1
- 9970 1
- 9981 1
- 9988 1
- 10003 1
- 10010 1
- 10016 1
- 10024 1
- 10048 1
- 10051 1
- 10055 1
- 10062 1
- 10085 1
- 10088 1
- 10092 1
- 10099 1
- 10130 1
- 10135 1
- 10141 1
- 10148 1
- 10169 1
- 10171 1
- 10173 1
- 10178 1
- 10186 1
- 10187 1
- 10188 1
- 10190 1
- 10208 1
- 10211 1
- 10234 1
- 10237 1
- 10239 1
- 10249 1
- 10270 1
- 10273 1
- 10276 1
- 10280 1
- 10305 1
- 10314 1
- 10323 1
- 10328 1
- 10356 1
- 10369 1
- 10382 1
- 10431 1
- 10440 1
- 10466 1
- 10489 1
- 10576 1
- 10589 1
- 10616 1
- 10658 1
- 10787 1
- 10806 1
- 10864 1
- 10917 1
- 11114 1
- 11171 1
- 11224 1
- 11306 1
- 11512 1
- 11559 1
- 11620 1
- 11711 1
- 11955 1
- 12044 1
- 12165 1
- 12335 1
- 12619 1
- 12659 1
- 12793 1
- 12887 1
- 13239 1
- 13261 1
- 13302 1
- 13353 1
- 13607 1
- 13625 1
- 13665 1
- 13756 1
- 13880 1
- 13914 1
- 13961 1
- 13993 1
- 14086 1
- 14101 1
- 14120 1
- 14145 1
- 14206 1
- 14297 1
- 14314 1
- 14345 1
- 14389 1
- 14407 1
- 14419 1
- 14451 1
- 14478 1
- 14497 1
- 14507 1
- 14513 1
- 14547 1
- 14558 1
- 14566 1
- 14574 1
- 14597 1
- 14662 1
- 14668 1
- 14677 1
- 14693 1
- 14699 1
- 14725 1
- 14726 1
- 14771 1
- 14778 1
- 14820 1
- 14825 1
- 14832 1
- 14840 1
- 14868 1
- 14869 1
- 14922 1
- 14932 1
- 14939 1
- 14949 1
- 14978 1
- 14986 1
- 14996 1
- 15041 1
- 15066 1
- 15077 1
- 15090 1
- 15110 1
- 15273 1
- 15303 1
- 15769 1
- 15872 1
- 16035 1
- 17076 1
- 17214 1
- 17461 1
- 17667 1
- 18747 1
- 18846 1
- 19046 1
- 19238 1
- 20261 1
- 20476 1
- 20688 1
- 21428 1
- 21534 1
- 21687 1
- 21842 1
- 22307 1
- 22394 1
- 22518 1
- 22654 1
- 23264 1
- 23296 1
- 23354 1
- 23381 1
- 23630 1
- 23651 1
- 23669 1
- 23681 1
- 23796 1
- 23803 1
- 23819 1
- 23857 1
- 23869 1
- 23873 1
- 23877 1
- 23905 1
state 1
- Mississippi 787
fips 1
- 28089 · 787 ✖
county 1
- Madison 787
Link | rowid | date ▼ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
4078 | 4078 | 2020-03-18 | Madison | Mississippi | 28089 | 1 | 0 |
4792 | 4792 | 2020-03-19 | Madison | Mississippi | 28089 | 1 | 0 |
5620 | 5620 | 2020-03-20 | Madison | Mississippi | 28089 | 3 | 0 |
6602 | 6602 | 2020-03-21 | Madison | Mississippi | 28089 | 7 | 0 |
7685 | 7685 | 2020-03-22 | Madison | Mississippi | 28089 | 9 | 0 |
8866 | 8866 | 2020-03-23 | Madison | Mississippi | 28089 | 11 | 0 |
10162 | 10162 | 2020-03-24 | Madison | Mississippi | 28089 | 14 | 0 |
11582 | 11582 | 2020-03-25 | Madison | Mississippi | 28089 | 17 | 0 |
13175 | 13175 | 2020-03-26 | Madison | Mississippi | 28089 | 21 | 0 |
14893 | 14893 | 2020-03-27 | Madison | Mississippi | 28089 | 25 | 0 |
16717 | 16717 | 2020-03-28 | Madison | Mississippi | 28089 | 29 | 0 |
18639 | 18639 | 2020-03-29 | Madison | Mississippi | 28089 | 37 | 0 |
20663 | 20663 | 2020-03-30 | Madison | Mississippi | 28089 | 38 | 0 |
22780 | 22780 | 2020-03-31 | Madison | Mississippi | 28089 | 42 | 0 |
24964 | 24964 | 2020-04-01 | Madison | Mississippi | 28089 | 53 | 0 |
27218 | 27218 | 2020-04-02 | Madison | Mississippi | 28089 | 55 | 0 |
29537 | 29537 | 2020-04-03 | Madison | Mississippi | 28089 | 65 | 0 |
31917 | 31917 | 2020-04-04 | Madison | Mississippi | 28089 | 67 | 0 |
34344 | 34344 | 2020-04-05 | Madison | Mississippi | 28089 | 72 | 0 |
36807 | 36807 | 2020-04-06 | Madison | Mississippi | 28089 | 74 | 2 |
39318 | 39318 | 2020-04-07 | Madison | Mississippi | 28089 | 82 | 2 |
41872 | 41872 | 2020-04-08 | Madison | Mississippi | 28089 | 83 | 2 |
44449 | 44449 | 2020-04-09 | Madison | Mississippi | 28089 | 88 | 2 |
47058 | 47058 | 2020-04-10 | Madison | Mississippi | 28089 | 95 | 2 |
49704 | 49704 | 2020-04-11 | Madison | Mississippi | 28089 | 99 | 2 |
52377 | 52377 | 2020-04-12 | Madison | Mississippi | 28089 | 103 | 2 |
55059 | 55059 | 2020-04-13 | Madison | Mississippi | 28089 | 106 | 2 |
57757 | 57757 | 2020-04-14 | Madison | Mississippi | 28089 | 108 | 3 |
60468 | 60468 | 2020-04-15 | Madison | Mississippi | 28089 | 112 | 3 |
63190 | 63190 | 2020-04-16 | Madison | Mississippi | 28089 | 116 | 3 |
65930 | 65930 | 2020-04-17 | Madison | Mississippi | 28089 | 123 | 3 |
68682 | 68682 | 2020-04-18 | Madison | Mississippi | 28089 | 127 | 3 |
71448 | 71448 | 2020-04-19 | Madison | Mississippi | 28089 | 135 | 4 |
74221 | 74221 | 2020-04-20 | Madison | Mississippi | 28089 | 140 | 4 |
77002 | 77002 | 2020-04-21 | Madison | Mississippi | 28089 | 144 | 4 |
79787 | 79787 | 2020-04-22 | Madison | Mississippi | 28089 | 151 | 4 |
82583 | 82583 | 2020-04-23 | Madison | Mississippi | 28089 | 165 | 4 |
85387 | 85387 | 2020-04-24 | Madison | Mississippi | 28089 | 178 | 4 |
88197 | 88197 | 2020-04-25 | Madison | Mississippi | 28089 | 186 | 5 |
91013 | 91013 | 2020-04-26 | Madison | Mississippi | 28089 | 194 | 5 |
93834 | 93834 | 2020-04-27 | Madison | Mississippi | 28089 | 208 | 6 |
96670 | 96670 | 2020-04-28 | Madison | Mississippi | 28089 | 212 | 7 |
99516 | 99516 | 2020-04-29 | Madison | Mississippi | 28089 | 224 | 8 |
102368 | 102368 | 2020-04-30 | Madison | Mississippi | 28089 | 229 | 8 |
105229 | 105229 | 2020-05-01 | Madison | Mississippi | 28089 | 251 | 8 |
108094 | 108094 | 2020-05-02 | Madison | Mississippi | 28089 | 268 | 8 |
110965 | 110965 | 2020-05-03 | Madison | Mississippi | 28089 | 272 | 9 |
113844 | 113844 | 2020-05-04 | Madison | Mississippi | 28089 | 286 | 10 |
116726 | 116726 | 2020-05-05 | Madison | Mississippi | 28089 | 298 | 11 |
119686 | 119686 | 2020-05-06 | Madison | Mississippi | 28089 | 318 | 11 |
122660 | 122660 | 2020-05-07 | Madison | Mississippi | 28089 | 333 | 12 |
125642 | 125642 | 2020-05-08 | Madison | Mississippi | 28089 | 404 | 12 |
128629 | 128629 | 2020-05-09 | Madison | Mississippi | 28089 | 422 | 12 |
131619 | 131619 | 2020-05-10 | Madison | Mississippi | 28089 | 431 | 12 |
134610 | 134610 | 2020-05-11 | Madison | Mississippi | 28089 | 466 | 12 |
137600 | 137600 | 2020-05-12 | Madison | Mississippi | 28089 | 491 | 13 |
140594 | 140594 | 2020-05-13 | Madison | Mississippi | 28089 | 493 | 15 |
143589 | 143589 | 2020-05-14 | Madison | Mississippi | 28089 | 502 | 15 |
146589 | 146589 | 2020-05-15 | Madison | Mississippi | 28089 | 507 | 17 |
149594 | 149594 | 2020-05-16 | Madison | Mississippi | 28089 | 526 | 17 |
152605 | 152605 | 2020-05-17 | Madison | Mississippi | 28089 | 533 | 17 |
155619 | 155619 | 2020-05-18 | Madison | Mississippi | 28089 | 543 | 17 |
158637 | 158637 | 2020-05-19 | Madison | Mississippi | 28089 | 561 | 17 |
161663 | 161663 | 2020-05-20 | Madison | Mississippi | 28089 | 573 | 18 |
164692 | 164692 | 2020-05-21 | Madison | Mississippi | 28089 | 582 | 19 |
167728 | 167728 | 2020-05-22 | Madison | Mississippi | 28089 | 618 | 20 |
170766 | 170766 | 2020-05-23 | Madison | Mississippi | 28089 | 639 | 21 |
173808 | 173808 | 2020-05-24 | Madison | Mississippi | 28089 | 654 | 21 |
176851 | 176851 | 2020-05-25 | Madison | Mississippi | 28089 | 653 | 21 |
179895 | 179895 | 2020-05-26 | Madison | Mississippi | 28089 | 675 | 21 |
182941 | 182941 | 2020-05-27 | Madison | Mississippi | 28089 | 687 | 21 |
185997 | 185997 | 2020-05-28 | Madison | Mississippi | 28089 | 694 | 22 |
189055 | 189055 | 2020-05-29 | Madison | Mississippi | 28089 | 709 | 23 |
192119 | 192119 | 2020-05-30 | Madison | Mississippi | 28089 | 720 | 23 |
195187 | 195187 | 2020-05-31 | Madison | Mississippi | 28089 | 724 | 23 |
198258 | 198258 | 2020-06-01 | Madison | Mississippi | 28089 | 742 | 23 |
201331 | 201331 | 2020-06-02 | Madison | Mississippi | 28089 | 745 | 25 |
204408 | 204408 | 2020-06-03 | Madison | Mississippi | 28089 | 757 | 27 |
207489 | 207489 | 2020-06-04 | Madison | Mississippi | 28089 | 767 | 28 |
210570 | 210570 | 2020-06-05 | Madison | Mississippi | 28089 | 778 | 29 |
213654 | 213654 | 2020-06-06 | Madison | Mississippi | 28089 | 788 | 29 |
216742 | 216742 | 2020-06-07 | Madison | Mississippi | 28089 | 796 | 29 |
219834 | 219834 | 2020-06-08 | Madison | Mississippi | 28089 | 807 | 29 |
222929 | 222929 | 2020-06-09 | Madison | Mississippi | 28089 | 832 | 29 |
226027 | 226027 | 2020-06-10 | Madison | Mississippi | 28089 | 843 | 30 |
229129 | 229129 | 2020-06-11 | Madison | Mississippi | 28089 | 843 | 30 |
232233 | 232233 | 2020-06-12 | Madison | Mississippi | 28089 | 864 | 30 |
235339 | 235339 | 2020-06-13 | Madison | Mississippi | 28089 | 877 | 30 |
238446 | 238446 | 2020-06-14 | Madison | Mississippi | 28089 | 886 | 30 |
241555 | 241555 | 2020-06-15 | Madison | Mississippi | 28089 | 889 | 30 |
244666 | 244666 | 2020-06-16 | Madison | Mississippi | 28089 | 905 | 31 |
247779 | 247779 | 2020-06-17 | Madison | Mississippi | 28089 | 922 | 31 |
250891 | 250891 | 2020-06-18 | Madison | Mississippi | 28089 | 922 | 31 |
254006 | 254006 | 2020-06-19 | Madison | Mississippi | 28089 | 922 | 31 |
257126 | 257126 | 2020-06-20 | Madison | Mississippi | 28089 | 922 | 31 |
260252 | 260252 | 2020-06-21 | Madison | Mississippi | 28089 | 922 | 31 |
263381 | 263381 | 2020-06-22 | Madison | Mississippi | 28089 | 995 | 31 |
266507 | 266507 | 2020-06-23 | Madison | Mississippi | 28089 | 1014 | 31 |
269640 | 269640 | 2020-06-24 | Madison | Mississippi | 28089 | 1034 | 31 |
272778 | 272778 | 2020-06-25 | Madison | Mississippi | 28089 | 1082 | 31 |
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);