ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 28039 sorted by state
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 496 ✖
- 1 8
- 7125 8
- 7141 8
- 10 7
- 15 7
- 7121 7
- 7122 7
- 7124 7
- 7154 7
- 19 6
- 2368 6
- 5101 6
- 5124 6
- 7120 6
- 7132 6
- 7149 6
- 5 5
- 14 5
- 41 5
- 5129 5
- 7163 5
- 4 4
- 11 4
- 2497 4
- 2505 4
- 2517 4
- 2522 4
- 2535 4
- 2560 4
- 5106 4
- 5121 4
- 5181 4
- 5772 4
- 7081 4
- 7118 4
- 3 3
- 7 3
- 8 3
- 17 3
- 20 3
- 25 3
- 30 3
- 32 3
- 35 3
- 867 3
- 2293 3
- 2355 3
- 2417 3
- 2452 3
- 2467 3
- 2468 3
- 2481 3
- 2515 3
- 2518 3
- 2531 3
- 2533 3
- 2543 3
- 2616 3
- 2722 3
- 2924 3
- 3246 3
- 3640 3
- 3904 3
- 4238 3
- 4336 3
- 4578 3
- 4714 3
- 4807 3
- 4866 3
- 4918 3
- 4968 3
- 5048 3
- 5059 3
- 5078 3
- 5094 3
- 5402 3
- 6179 3
- 6586 3
- 6799 3
- 6990 3
- 7105 3
- 13 2
- 16 2
- 21 2
- 58 2
- 66 2
- 131 2
- 549 2
- 672 2
- 674 2
- 687 2
- 711 2
- 729 2
- 740 2
- 820 2
- 932 2
- 992 2
- 1037 2
- 1044 2
- 1094 2
- 1159 2
- 2317 2
- 2324 2
- 2328 2
- 2329 2
- 2339 2
- 2362 2
- 2365 2
- 2370 2
- 2376 2
- 2378 2
- 2480 2
- 2496 2
- 2508 2
- 2519 2
- 2520 2
- 2524 2
- 2541 2
- 2550 2
- 5073 2
- 5100 2
- 5127 2
- 7111 2
- 9 1
- 12 1
- 18 1
- 26 1
- 28 1
- 29 1
- 31 1
- 37 1
- 40 1
- 53 1
- 60 1
- 61 1
- 72 1
- 73 1
- 74 1
- 75 1
- 78 1
- 86 1
- 88 1
- 89 1
- 91 1
- 94 1
- 102 1
- 112 1
- 116 1
- 123 1
- 125 1
- 139 1
- 151 1
- 154 1
- 163 1
- 179 1
- 192 1
- 196 1
- 202 1
- 220 1
- 233 1
- 243 1
- 247 1
- 256 1
- 378 1
- 517 1
- 525 1
- 539 1
- 541 1
- 545 1
- 547 1
- 548 1
- 559 1
- 581 1
- 589 1
- 595 1
- 603 1
- 605 1
- 626 1
- 637 1
- 638 1
- 639 1
- 641 1
- 647 1
- 654 1
- 666 1
- 667 1
- 669 1
- 673 1
- 679 1
- 684 1
- 685 1
- 706 1
- 707 1
- 708 1
- 714 1
- 716 1
- 717 1
- 720 1
- 726 1
- 737 1
- 739 1
- 744 1
- 749 1
- 751 1
- 755 1
- 759 1
- 765 1
- 771 1
- 780 1
- 782 1
- 783 1
- 784 1
- 785 1
- 803 1
- 813 1
- 822 1
- 845 1
- 846 1
- 856 1
- 860 1
- 896 1
- 908 1
- 922 1
- 927 1
- 935 1
- 939 1
- 957 1
- 977 1
- 979 1
- 999 1
- 1014 1
- 1017 1
- 1030 1
- 1033 1
- 1035 1
- 1068 1
- 1077 1
- 1092 1
- 1113 1
- 1117 1
- 1128 1
- 1143 1
- 1150 1
- 1167 1
- 1173 1
- 1182 1
- 1188 1
- 1210 1
- 1215 1
- 1216 1
- 1222 1
- 1223 1
- 1235 1
- 1245 1
- 1255 1
- 1262 1
- 1264 1
- 1283 1
- 1295 1
- 1317 1
- 1383 1
- 1393 1
- 1396 1
- 1402 1
- 1421 1
- 1443 1
- 1451 1
- 1455 1
- 1475 1
- 1486 1
- 1487 1
- 1501 1
- 1523 1
- 1534 1
- 1557 1
- 1578 1
- 1594 1
- 1602 1
- 1620 1
- 1632 1
- 1646 1
- 1653 1
- 1666 1
- 1674 1
- 1678 1
- 1708 1
- 1727 1
- 1732 1
- 1740 1
- 1744 1
- 1746 1
- 1749 1
- 1773 1
- 1783 1
- 1788 1
- 1803 1
- 1841 1
- 1880 1
- 1897 1
- 1929 1
- 1937 1
- 1959 1
- 1974 1
- 1979 1
- 1990 1
- 1993 1
- 1998 1
- 2019 1
- 2027 1
- 2035 1
- 2043 1
- 2047 1
- 2048 1
- 2064 1
- 2110 1
- 2121 1
- 2133 1
- 2140 1
- 2145 1
- 2148 1
- 2165 1
- 2168 1
- 2171 1
- 2182 1
- 2192 1
- 2197 1
- 2203 1
- 2216 1
- 2225 1
- 2227 1
- 2238 1
- 2246 1
- 2257 1
- 2261 1
- 2268 1
- 2275 1
- 2276 1
- 2286 1
- 2295 1
- 2298 1
- 2306 1
- 2311 1
- 2312 1
- 2318 1
- 2321 1
- 2327 1
- 2331 1
- 2335 1
- 2337 1
- 2343 1
- 2346 1
- 2352 1
- 2353 1
- 2358 1
- 2359 1
- 2360 1
- 2366 1
- 2367 1
- 2381 1
- 2382 1
- 2383 1
- 2385 1
- 2387 1
- 2389 1
- 2390 1
- 2397 1
- 2408 1
- 2414 1
- 2432 1
- 2440 1
- 2446 1
- 2451 1
- 2463 1
- 2473 1
- 2478 1
- 2494 1
- 2498 1
- 2502 1
- 2504 1
- 2511 1
- 2514 1
- 2528 1
- 2534 1
- 2540 1
- 2551 1
- 2577 1
- 2580 1
- 2586 1
- 2598 1
- 2650 1
- 2662 1
- 2676 1
- 2705 1
- 2767 1
- 2773 1
- 2858 1
- 2894 1
- 3014 1
- 3090 1
- 3127 1
- 3187 1
- 3372 1
- 3432 1
- 3511 1
- 3597 1
- 3698 1
- 3763 1
- 3825 1
- 3867 1
- 3998 1
- 4014 1
- 4084 1
- 4203 1
- 4261 1
- 4262 1
- 4275 1
- 4315 1
- 4519 1
- 4537 1
- 4547 1
- 4564 1
- 4641 1
- 4651 1
- 4660 1
- 4700 1
- 4735 1
- 4748 1
- 4772 1
- 4776 1
- 4823 1
- 4829 1
- 4846 1
- 4852 1
- 4884 1
- 4889 1
- 4899 1
- 4904 1
- 4949 1
- 4961 1
- 4965 1
- 4967 1
- 4974 1
- 5029 1
- 5041 1
- 5043 1
- 5050 1
- 5052 1
- 5056 1
- 5058 1
- 5065 1
- 5070 1
- 5086 1
- 5088 1
- 5089 1
- 5091 1
- 5103 1
- 5104 1
- 5110 1
- 5113 1
- 5115 1
- 5122 1
- 5144 1
- 5147 1
- 5157 1
- 5234 1
- 5264 1
- 5306 1
- 5341 1
- 5497 1
- 5573 1
- 5620 1
- 5730 1
- 6037 1
- 6100 1
- 6140 1
- 6362 1
- 6507 1
- 6532 1
- 6554 1
- 6641 1
- 6663 1
- 6675 1
- 6751 1
- 6917 1
- 6936 1
- 6950 1
- 6974 1
- 7053 1
- 7064 1
- 7072 1
- 7078 1
- 7091 1
- 7097 1
- 7101 1
- 7110 1
- 7116 1
state 1
- Mississippi 784
fips 1
- 28039 · 784 ✖
county 1
- George 784
Link | rowid | date | county | state ▼ | fips | cases | deaths |
---|---|---|---|---|---|---|---|
6585 | 6585 | 2020-03-21 | George | Mississippi | 28039 | 1 | 0 |
7668 | 7668 | 2020-03-22 | George | Mississippi | 28039 | 1 | 0 |
8848 | 8848 | 2020-03-23 | George | Mississippi | 28039 | 1 | 0 |
10144 | 10144 | 2020-03-24 | George | Mississippi | 28039 | 1 | 0 |
11564 | 11564 | 2020-03-25 | George | Mississippi | 28039 | 1 | 0 |
13156 | 13156 | 2020-03-26 | George | Mississippi | 28039 | 1 | 0 |
14872 | 14872 | 2020-03-27 | George | Mississippi | 28039 | 1 | 0 |
16696 | 16696 | 2020-03-28 | George | Mississippi | 28039 | 1 | 0 |
18618 | 18618 | 2020-03-29 | George | Mississippi | 28039 | 3 | 0 |
20642 | 20642 | 2020-03-30 | George | Mississippi | 28039 | 3 | 0 |
22759 | 22759 | 2020-03-31 | George | Mississippi | 28039 | 3 | 0 |
24942 | 24942 | 2020-04-01 | George | Mississippi | 28039 | 4 | 0 |
27196 | 27196 | 2020-04-02 | George | Mississippi | 28039 | 4 | 0 |
29515 | 29515 | 2020-04-03 | George | Mississippi | 28039 | 4 | 0 |
31895 | 31895 | 2020-04-04 | George | Mississippi | 28039 | 4 | 0 |
34322 | 34322 | 2020-04-05 | George | Mississippi | 28039 | 5 | 0 |
36784 | 36784 | 2020-04-06 | George | Mississippi | 28039 | 5 | 0 |
39295 | 39295 | 2020-04-07 | George | Mississippi | 28039 | 5 | 0 |
41849 | 41849 | 2020-04-08 | George | Mississippi | 28039 | 5 | 0 |
44425 | 44425 | 2020-04-09 | George | Mississippi | 28039 | 5 | 0 |
47034 | 47034 | 2020-04-10 | George | Mississippi | 28039 | 7 | 0 |
49680 | 49680 | 2020-04-11 | George | Mississippi | 28039 | 7 | 0 |
52353 | 52353 | 2020-04-12 | George | Mississippi | 28039 | 7 | 0 |
55035 | 55035 | 2020-04-13 | George | Mississippi | 28039 | 8 | 0 |
57733 | 57733 | 2020-04-14 | George | Mississippi | 28039 | 10 | 0 |
60444 | 60444 | 2020-04-15 | George | Mississippi | 28039 | 8 | 0 |
63166 | 63166 | 2020-04-16 | George | Mississippi | 28039 | 8 | 0 |
65906 | 65906 | 2020-04-17 | George | Mississippi | 28039 | 9 | 0 |
68658 | 68658 | 2020-04-18 | George | Mississippi | 28039 | 10 | 1 |
71424 | 71424 | 2020-04-19 | George | Mississippi | 28039 | 10 | 1 |
74197 | 74197 | 2020-04-20 | George | Mississippi | 28039 | 10 | 1 |
76978 | 76978 | 2020-04-21 | George | Mississippi | 28039 | 10 | 1 |
79763 | 79763 | 2020-04-22 | George | Mississippi | 28039 | 10 | 1 |
82559 | 82559 | 2020-04-23 | George | Mississippi | 28039 | 10 | 1 |
85363 | 85363 | 2020-04-24 | George | Mississippi | 28039 | 11 | 1 |
88173 | 88173 | 2020-04-25 | George | Mississippi | 28039 | 11 | 1 |
90989 | 90989 | 2020-04-26 | George | Mississippi | 28039 | 11 | 1 |
93810 | 93810 | 2020-04-27 | George | Mississippi | 28039 | 11 | 1 |
96646 | 96646 | 2020-04-28 | George | Mississippi | 28039 | 12 | 1 |
99492 | 99492 | 2020-04-29 | George | Mississippi | 28039 | 13 | 1 |
102344 | 102344 | 2020-04-30 | George | Mississippi | 28039 | 13 | 1 |
105205 | 105205 | 2020-05-01 | George | Mississippi | 28039 | 14 | 1 |
108070 | 108070 | 2020-05-02 | George | Mississippi | 28039 | 14 | 1 |
110941 | 110941 | 2020-05-03 | George | Mississippi | 28039 | 14 | 1 |
113820 | 113820 | 2020-05-04 | George | Mississippi | 28039 | 14 | 1 |
116702 | 116702 | 2020-05-05 | George | Mississippi | 28039 | 14 | 1 |
119662 | 119662 | 2020-05-06 | George | Mississippi | 28039 | 15 | 1 |
122636 | 122636 | 2020-05-07 | George | Mississippi | 28039 | 15 | 1 |
125618 | 125618 | 2020-05-08 | George | Mississippi | 28039 | 15 | 1 |
128605 | 128605 | 2020-05-09 | George | Mississippi | 28039 | 15 | 1 |
131595 | 131595 | 2020-05-10 | George | Mississippi | 28039 | 15 | 1 |
134586 | 134586 | 2020-05-11 | George | Mississippi | 28039 | 15 | 1 |
137576 | 137576 | 2020-05-12 | George | Mississippi | 28039 | 15 | 1 |
140570 | 140570 | 2020-05-13 | George | Mississippi | 28039 | 16 | 1 |
143565 | 143565 | 2020-05-14 | George | Mississippi | 28039 | 16 | 1 |
146565 | 146565 | 2020-05-15 | George | Mississippi | 28039 | 18 | 1 |
149570 | 149570 | 2020-05-16 | George | Mississippi | 28039 | 17 | 1 |
152581 | 152581 | 2020-05-17 | George | Mississippi | 28039 | 17 | 1 |
155595 | 155595 | 2020-05-18 | George | Mississippi | 28039 | 17 | 1 |
158613 | 158613 | 2020-05-19 | George | Mississippi | 28039 | 19 | 1 |
161639 | 161639 | 2020-05-20 | George | Mississippi | 28039 | 19 | 1 |
164668 | 164668 | 2020-05-21 | George | Mississippi | 28039 | 19 | 1 |
167704 | 167704 | 2020-05-22 | George | Mississippi | 28039 | 19 | 1 |
170742 | 170742 | 2020-05-23 | George | Mississippi | 28039 | 19 | 1 |
173784 | 173784 | 2020-05-24 | George | Mississippi | 28039 | 19 | 1 |
176827 | 176827 | 2020-05-25 | George | Mississippi | 28039 | 20 | 1 |
179871 | 179871 | 2020-05-26 | George | Mississippi | 28039 | 20 | 1 |
182917 | 182917 | 2020-05-27 | George | Mississippi | 28039 | 20 | 1 |
185973 | 185973 | 2020-05-28 | George | Mississippi | 28039 | 21 | 1 |
189031 | 189031 | 2020-05-29 | George | Mississippi | 28039 | 21 | 1 |
192095 | 192095 | 2020-05-30 | George | Mississippi | 28039 | 25 | 1 |
195163 | 195163 | 2020-05-31 | George | Mississippi | 28039 | 25 | 1 |
198234 | 198234 | 2020-06-01 | George | Mississippi | 28039 | 25 | 1 |
201307 | 201307 | 2020-06-02 | George | Mississippi | 28039 | 26 | 1 |
204384 | 204384 | 2020-06-03 | George | Mississippi | 28039 | 28 | 1 |
207465 | 207465 | 2020-06-04 | George | Mississippi | 28039 | 29 | 2 |
210546 | 210546 | 2020-06-05 | George | Mississippi | 28039 | 30 | 2 |
213630 | 213630 | 2020-06-06 | George | Mississippi | 28039 | 30 | 2 |
216718 | 216718 | 2020-06-07 | George | Mississippi | 28039 | 30 | 2 |
219810 | 219810 | 2020-06-08 | George | Mississippi | 28039 | 31 | 2 |
222905 | 222905 | 2020-06-09 | George | Mississippi | 28039 | 32 | 2 |
226003 | 226003 | 2020-06-10 | George | Mississippi | 28039 | 32 | 2 |
229105 | 229105 | 2020-06-11 | George | Mississippi | 28039 | 32 | 2 |
232209 | 232209 | 2020-06-12 | George | Mississippi | 28039 | 35 | 2 |
235315 | 235315 | 2020-06-13 | George | Mississippi | 28039 | 35 | 2 |
238422 | 238422 | 2020-06-14 | George | Mississippi | 28039 | 35 | 2 |
241531 | 241531 | 2020-06-15 | George | Mississippi | 28039 | 37 | 2 |
244642 | 244642 | 2020-06-16 | George | Mississippi | 28039 | 40 | 2 |
247755 | 247755 | 2020-06-17 | George | Mississippi | 28039 | 41 | 2 |
250867 | 250867 | 2020-06-18 | George | Mississippi | 28039 | 41 | 2 |
253982 | 253982 | 2020-06-19 | George | Mississippi | 28039 | 41 | 2 |
257102 | 257102 | 2020-06-20 | George | Mississippi | 28039 | 41 | 2 |
260228 | 260228 | 2020-06-21 | George | Mississippi | 28039 | 41 | 2 |
263357 | 263357 | 2020-06-22 | George | Mississippi | 28039 | 53 | 2 |
266483 | 266483 | 2020-06-23 | George | Mississippi | 28039 | 58 | 3 |
269616 | 269616 | 2020-06-24 | George | Mississippi | 28039 | 58 | 3 |
272753 | 272753 | 2020-06-25 | George | Mississippi | 28039 | 60 | 3 |
275896 | 275896 | 2020-06-26 | George | Mississippi | 28039 | 61 | 3 |
279044 | 279044 | 2020-06-27 | George | Mississippi | 28039 | 66 | 3 |
282192 | 282192 | 2020-06-28 | George | Mississippi | 28039 | 66 | 3 |
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);