ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 28079 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 541 ✖
- 6396 8
- 6404 8
- 4107 7
- 6383 7
- 6389 7
- 6391 7
- 6393 7
- 6417 7
- 6403 6
- 6411 6
- 496 5
- 2733 5
- 4100 5
- 4137 5
- 4175 5
- 6427 5
- 5 4
- 2505 4
- 2593 4
- 2603 4
- 2696 4
- 2703 4
- 2716 4
- 4082 4
- 4315 4
- 5009 4
- 6313 4
- 6330 4
- 1 3
- 4 3
- 811 3
- 875 3
- 878 3
- 925 3
- 980 3
- 2609 3
- 2631 3
- 2640 3
- 2662 3
- 2684 3
- 2698 3
- 2709 3
- 2717 3
- 2720 3
- 2727 3
- 2740 3
- 2756 3
- 2784 3
- 2854 3
- 2979 3
- 3193 3
- 3409 3
- 3596 3
- 3731 3
- 3832 3
- 3931 3
- 3975 3
- 4021 3
- 4059 3
- 4077 3
- 4104 3
- 4113 3
- 4129 3
- 4140 3
- 4141 3
- 4151 3
- 4161 3
- 4647 3
- 5339 3
- 5589 3
- 5894 3
- 6137 3
- 6373 3
- 15 2
- 22 2
- 27 2
- 257 2
- 299 2
- 472 2
- 483 2
- 534 2
- 578 2
- 635 2
- 677 2
- 786 2
- 900 2
- 939 2
- 953 2
- 1055 2
- 1118 2
- 1150 2
- 1181 2
- 1316 2
- 2469 2
- 2504 2
- 2524 2
- 2575 2
- 2613 2
- 2624 2
- 2655 2
- 2707 2
- 4072 2
- 4080 2
- 4124 2
- 4144 2
- 6356 2
- 2 1
- 3 1
- 6 1
- 7 1
- 8 1
- 10 1
- 11 1
- 29 1
- 32 1
- 40 1
- 50 1
- 60 1
- 64 1
- 77 1
- 86 1
- 99 1
- 108 1
- 118 1
- 136 1
- 149 1
- 158 1
- 161 1
- 179 1
- 190 1
- 204 1
- 219 1
- 229 1
- 233 1
- 247 1
- 267 1
- 286 1
- 307 1
- 318 1
- 323 1
- 332 1
- 351 1
- 352 1
- 353 1
- 361 1
- 364 1
- 367 1
- 368 1
- 373 1
- 382 1
- 384 1
- 388 1
- 389 1
- 395 1
- 400 1
- 409 1
- 421 1
- 427 1
- 431 1
- 447 1
- 452 1
- 454 1
- 455 1
- 460 1
- 462 1
- 466 1
- 469 1
- 478 1
- 487 1
- 491 1
- 503 1
- 505 1
- 510 1
- 520 1
- 526 1
- 533 1
- 547 1
- 548 1
- 565 1
- 570 1
- 575 1
- 589 1
- 598 1
- 613 1
- 621 1
- 634 1
- 651 1
- 664 1
- 670 1
- 675 1
- 683 1
- 693 1
- 699 1
- 710 1
- 718 1
- 723 1
- 724 1
- 725 1
- 734 1
- 738 1
- 740 1
- 755 1
- 762 1
- 767 1
- 768 1
- 771 1
- 776 1
- 779 1
- 788 1
- 790 1
- 795 1
- 799 1
- 804 1
- 813 1
- 818 1
- 826 1
- 828 1
- 834 1
- 836 1
- 861 1
- 862 1
- 866 1
- 883 1
- 890 1
- 902 1
- 908 1
- 909 1
- 910 1
- 911 1
- 913 1
- 922 1
- 928 1
- 932 1
- 935 1
- 937 1
- 940 1
- 941 1
- 946 1
- 960 1
- 961 1
- 962 1
- 963 1
- 965 1
- 969 1
- 971 1
- 985 1
- 992 1
- 996 1
- 1021 1
- 1053 1
- 1065 1
- 1076 1
- 1094 1
- 1110 1
- 1122 1
- 1133 1
- 1139 1
- 1143 1
- 1146 1
- 1152 1
- 1158 1
- 1163 1
- 1170 1
- 1178 1
- 1183 1
- 1188 1
- 1191 1
- 1195 1
- 1196 1
- 1202 1
- 1209 1
- 1210 1
- 1221 1
- 1228 1
- 1236 1
- 1249 1
- 1256 1
- 1261 1
- 1265 1
- 1268 1
- 1271 1
- 1286 1
- 1292 1
- 1312 1
- 1318 1
- 1319 1
- 1332 1
- 1335 1
- 1349 1
- 1383 1
- 1394 1
- 1397 1
- 1418 1
- 1433 1
- 1462 1
- 1481 1
- 1490 1
- 1497 1
- 1502 1
- 1521 1
- 1542 1
- 1575 1
- 1606 1
- 1627 1
- 1635 1
- 1647 1
- 1662 1
- 1698 1
- 1737 1
- 1750 1
- 1777 1
- 1785 1
- 1809 1
- 1846 1
- 1883 1
- 1910 1
- 1930 1
- 1952 1
- 1979 1
- 2004 1
- 2016 1
- 2049 1
- 2069 1
- 2081 1
- 2104 1
- 2122 1
- 2128 1
- 2145 1
- 2174 1
- 2196 1
- 2211 1
- 2215 1
- 2223 1
- 2239 1
- 2254 1
- 2267 1
- 2278 1
- 2295 1
- 2305 1
- 2311 1
- 2317 1
- 2329 1
- 2343 1
- 2361 1
- 2373 1
- 2381 1
- 2384 1
- 2389 1
- 2393 1
- 2395 1
- 2405 1
- 2424 1
- 2435 1
- 2439 1
- 2446 1
- 2448 1
- 2455 1
- 2460 1
- 2466 1
- 2476 1
- 2479 1
- 2481 1
- 2482 1
- 2485 1
- 2494 1
- 2496 1
- 2501 1
- 2508 1
- 2513 1
- 2517 1
- 2521 1
- 2522 1
- 2526 1
- 2528 1
- 2531 1
- 2535 1
- 2541 1
- 2545 1
- 2548 1
- 2550 1
- 2554 1
- 2559 1
- 2561 1
- 2562 1
- 2564 1
- 2567 1
- 2569 1
- 2571 1
- 2578 1
- 2579 1
- 2580 1
- 2581 1
- 2588 1
- 2591 1
- 2592 1
- 2595 1
- 2597 1
- 2598 1
- 2606 1
- 2610 1
- 2611 1
- 2614 1
- 2617 1
- 2620 1
- 2626 1
- 2627 1
- 2630 1
- 2634 1
- 2635 1
- 2636 1
- 2637 1
- 2644 1
- 2649 1
- 2666 1
- 2674 1
- 2678 1
- 2683 1
- 2686 1
- 2687 1
- 2691 1
- 2706 1
- 2708 1
- 2713 1
- 2714 1
- 2715 1
- 2719 1
- 2722 1
- 2723 1
- 2724 1
- 2725 1
- 2728 1
- 2730 1
- 2732 1
- 2734 1
- 2736 1
- 2739 1
- 2749 1
- 2751 1
- 2753 1
- 2755 1
- 2764 1
- 2767 1
- 2771 1
- 2779 1
- 2807 1
- 2815 1
- 2834 1
- 2846 1
- 2878 1
- 2886 1
- 2919 1
- 2951 1
- 3024 1
- 3061 1
- 3093 1
- 3150 1
- 3256 1
- 3311 1
- 3347 1
- 3372 1
- 3476 1
- 3521 1
- 3540 1
- 3562 1
- 3626 1
- 3637 1
- 3657 1
- 3706 1
- 3789 1
- 3793 1
- 3806 1
- 3815 1
- 3860 1
- 3882 1
- 3897 1
- 3904 1
- 3944 1
- 3950 1
- 3954 1
- 3971 1
- 3982 1
- 3998 1
- 4006 1
- 4012 1
- 4032 1
- 4036 1
- 4050 1
- 4057 1
- 4064 1
- 4068 1
- 4076 1
- 4086 1
- 4098 1
- 4102 1
- 4119 1
- 4127 1
- 4133 1
- 4134 1
- 4139 1
- 4148 1
- 4150 1
- 4153 1
- 4157 1
- 4158 1
- 4159 1
- 4170 1
- 4172 1
- 4223 1
- 4258 1
- 4281 1
- 4434 1
- 4490 1
- 4545 1
- 4594 1
- 4762 1
- 4815 1
- 4900 1
- 4948 1
- 5171 1
- 5244 1
- 5290 1
- 5434 1
- 5477 1
- 5520 1
- 5557 1
- 5656 1
- 5717 1
- 5762 1
- 5812 1
- 6073 1
- 6082 1
- 6106 1
- 6113 1
- 6288 1
- 6295 1
- 6303 1
- 6306 1
- 6324 1
- 6326 1
- 6361 1
- 6370 1
state 1
- Mississippi 784
fips 1
- 28079 · 784 ✖
county 1
- Leake 784
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6597 | 6597 | 2020-03-21 | Leake | Mississippi | 28079 | 1 | 0 |
7680 | 7680 | 2020-03-22 | Leake | Mississippi | 28079 | 1 | 0 |
8861 | 8861 | 2020-03-23 | Leake | Mississippi | 28079 | 1 | 0 |
10157 | 10157 | 2020-03-24 | Leake | Mississippi | 28079 | 2 | 0 |
11577 | 11577 | 2020-03-25 | Leake | Mississippi | 28079 | 3 | 0 |
13170 | 13170 | 2020-03-26 | Leake | Mississippi | 28079 | 4 | 0 |
14888 | 14888 | 2020-03-27 | Leake | Mississippi | 28079 | 4 | 0 |
16712 | 16712 | 2020-03-28 | Leake | Mississippi | 28079 | 4 | 0 |
18634 | 18634 | 2020-03-29 | Leake | Mississippi | 28079 | 5 | 0 |
20658 | 20658 | 2020-03-30 | Leake | Mississippi | 28079 | 5 | 0 |
22775 | 22775 | 2020-03-31 | Leake | Mississippi | 28079 | 5 | 0 |
24959 | 24959 | 2020-04-01 | Leake | Mississippi | 28079 | 5 | 0 |
27213 | 27213 | 2020-04-02 | Leake | Mississippi | 28079 | 6 | 0 |
29532 | 29532 | 2020-04-03 | Leake | Mississippi | 28079 | 7 | 0 |
31912 | 31912 | 2020-04-04 | Leake | Mississippi | 28079 | 8 | 0 |
34339 | 34339 | 2020-04-05 | Leake | Mississippi | 28079 | 10 | 0 |
36802 | 36802 | 2020-04-06 | Leake | Mississippi | 28079 | 11 | 0 |
39313 | 39313 | 2020-04-07 | Leake | Mississippi | 28079 | 15 | 0 |
41867 | 41867 | 2020-04-08 | Leake | Mississippi | 28079 | 15 | 0 |
44444 | 44444 | 2020-04-09 | Leake | Mississippi | 28079 | 22 | 0 |
47053 | 47053 | 2020-04-10 | Leake | Mississippi | 28079 | 22 | 0 |
49699 | 49699 | 2020-04-11 | Leake | Mississippi | 28079 | 27 | 0 |
52372 | 52372 | 2020-04-12 | Leake | Mississippi | 28079 | 27 | 0 |
55054 | 55054 | 2020-04-13 | Leake | Mississippi | 28079 | 29 | 0 |
57752 | 57752 | 2020-04-14 | Leake | Mississippi | 28079 | 32 | 1 |
60463 | 60463 | 2020-04-15 | Leake | Mississippi | 28079 | 40 | 1 |
63185 | 63185 | 2020-04-16 | Leake | Mississippi | 28079 | 50 | 1 |
65925 | 65925 | 2020-04-17 | Leake | Mississippi | 28079 | 60 | 1 |
68677 | 68677 | 2020-04-18 | Leake | Mississippi | 28079 | 64 | 1 |
71443 | 71443 | 2020-04-19 | Leake | Mississippi | 28079 | 77 | 1 |
74216 | 74216 | 2020-04-20 | Leake | Mississippi | 28079 | 86 | 1 |
76997 | 76997 | 2020-04-21 | Leake | Mississippi | 28079 | 99 | 1 |
79782 | 79782 | 2020-04-22 | Leake | Mississippi | 28079 | 108 | 1 |
82578 | 82578 | 2020-04-23 | Leake | Mississippi | 28079 | 118 | 1 |
85382 | 85382 | 2020-04-24 | Leake | Mississippi | 28079 | 136 | 1 |
88192 | 88192 | 2020-04-25 | Leake | Mississippi | 28079 | 149 | 1 |
91008 | 91008 | 2020-04-26 | Leake | Mississippi | 28079 | 158 | 1 |
93829 | 93829 | 2020-04-27 | Leake | Mississippi | 28079 | 161 | 1 |
96665 | 96665 | 2020-04-28 | Leake | Mississippi | 28079 | 179 | 1 |
99511 | 99511 | 2020-04-29 | Leake | Mississippi | 28079 | 190 | 2 |
102363 | 102363 | 2020-04-30 | Leake | Mississippi | 28079 | 204 | 2 |
105224 | 105224 | 2020-05-01 | Leake | Mississippi | 28079 | 219 | 2 |
108089 | 108089 | 2020-05-02 | Leake | Mississippi | 28079 | 229 | 1 |
110960 | 110960 | 2020-05-03 | Leake | Mississippi | 28079 | 233 | 2 |
113839 | 113839 | 2020-05-04 | Leake | Mississippi | 28079 | 247 | 2 |
116721 | 116721 | 2020-05-05 | Leake | Mississippi | 28079 | 257 | 2 |
119681 | 119681 | 2020-05-06 | Leake | Mississippi | 28079 | 257 | 2 |
122655 | 122655 | 2020-05-07 | Leake | Mississippi | 28079 | 267 | 2 |
125637 | 125637 | 2020-05-08 | Leake | Mississippi | 28079 | 286 | 2 |
128624 | 128624 | 2020-05-09 | Leake | Mississippi | 28079 | 299 | 2 |
131614 | 131614 | 2020-05-10 | Leake | Mississippi | 28079 | 299 | 3 |
134605 | 134605 | 2020-05-11 | Leake | Mississippi | 28079 | 307 | 4 |
137595 | 137595 | 2020-05-12 | Leake | Mississippi | 28079 | 318 | 4 |
140589 | 140589 | 2020-05-13 | Leake | Mississippi | 28079 | 323 | 5 |
143584 | 143584 | 2020-05-14 | Leake | Mississippi | 28079 | 332 | 5 |
146584 | 146584 | 2020-05-15 | Leake | Mississippi | 28079 | 351 | 6 |
149589 | 149589 | 2020-05-16 | Leake | Mississippi | 28079 | 352 | 6 |
152600 | 152600 | 2020-05-17 | Leake | Mississippi | 28079 | 353 | 6 |
155614 | 155614 | 2020-05-18 | Leake | Mississippi | 28079 | 361 | 6 |
158632 | 158632 | 2020-05-19 | Leake | Mississippi | 28079 | 364 | 7 |
161658 | 161658 | 2020-05-20 | Leake | Mississippi | 28079 | 367 | 7 |
164687 | 164687 | 2020-05-21 | Leake | Mississippi | 28079 | 368 | 7 |
167723 | 167723 | 2020-05-22 | Leake | Mississippi | 28079 | 373 | 8 |
170761 | 170761 | 2020-05-23 | Leake | Mississippi | 28079 | 382 | 8 |
173803 | 173803 | 2020-05-24 | Leake | Mississippi | 28079 | 384 | 10 |
176846 | 176846 | 2020-05-25 | Leake | Mississippi | 28079 | 388 | 10 |
179890 | 179890 | 2020-05-26 | Leake | Mississippi | 28079 | 389 | 10 |
182936 | 182936 | 2020-05-27 | Leake | Mississippi | 28079 | 395 | 12 |
185992 | 185992 | 2020-05-28 | Leake | Mississippi | 28079 | 400 | 12 |
189050 | 189050 | 2020-05-29 | Leake | Mississippi | 28079 | 409 | 12 |
192114 | 192114 | 2020-05-30 | Leake | Mississippi | 28079 | 421 | 12 |
195182 | 195182 | 2020-05-31 | Leake | Mississippi | 28079 | 427 | 12 |
198253 | 198253 | 2020-06-01 | Leake | Mississippi | 28079 | 431 | 12 |
201326 | 201326 | 2020-06-02 | Leake | Mississippi | 28079 | 447 | 12 |
204403 | 204403 | 2020-06-03 | Leake | Mississippi | 28079 | 454 | 12 |
207484 | 207484 | 2020-06-04 | Leake | Mississippi | 28079 | 452 | 12 |
210565 | 210565 | 2020-06-05 | Leake | Mississippi | 28079 | 455 | 12 |
213649 | 213649 | 2020-06-06 | Leake | Mississippi | 28079 | 460 | 12 |
216737 | 216737 | 2020-06-07 | Leake | Mississippi | 28079 | 462 | 12 |
219829 | 219829 | 2020-06-08 | Leake | Mississippi | 28079 | 466 | 12 |
222924 | 222924 | 2020-06-09 | Leake | Mississippi | 28079 | 469 | 12 |
226022 | 226022 | 2020-06-10 | Leake | Mississippi | 28079 | 472 | 14 |
229124 | 229124 | 2020-06-11 | Leake | Mississippi | 28079 | 472 | 14 |
232228 | 232228 | 2020-06-12 | Leake | Mississippi | 28079 | 478 | 15 |
235334 | 235334 | 2020-06-13 | Leake | Mississippi | 28079 | 483 | 15 |
238441 | 238441 | 2020-06-14 | Leake | Mississippi | 28079 | 483 | 15 |
241550 | 241550 | 2020-06-15 | Leake | Mississippi | 28079 | 487 | 15 |
244661 | 244661 | 2020-06-16 | Leake | Mississippi | 28079 | 491 | 15 |
247774 | 247774 | 2020-06-17 | Leake | Mississippi | 28079 | 496 | 16 |
250886 | 250886 | 2020-06-18 | Leake | Mississippi | 28079 | 496 | 16 |
254001 | 254001 | 2020-06-19 | Leake | Mississippi | 28079 | 496 | 16 |
257121 | 257121 | 2020-06-20 | Leake | Mississippi | 28079 | 496 | 16 |
260247 | 260247 | 2020-06-21 | Leake | Mississippi | 28079 | 496 | 16 |
263376 | 263376 | 2020-06-22 | Leake | Mississippi | 28079 | 503 | 16 |
266502 | 266502 | 2020-06-23 | Leake | Mississippi | 28079 | 505 | 16 |
269635 | 269635 | 2020-06-24 | Leake | Mississippi | 28079 | 510 | 17 |
272773 | 272773 | 2020-06-25 | Leake | Mississippi | 28079 | 520 | 17 |
275916 | 275916 | 2020-06-26 | Leake | Mississippi | 28079 | 526 | 17 |
279064 | 279064 | 2020-06-27 | Leake | Mississippi | 28079 | 534 | 17 |
282212 | 282212 | 2020-06-28 | Leake | Mississippi | 28079 | 534 | 17 |
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);