ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
785 rows where fips = 28001 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: deaths, date (date)
cases 564 ✖
- 7136 8
- 7152 8
- 7104 7
- 7120 7
- 7122 7
- 7126 7
- 7174 7
- 2473 6
- 7119 6
- 7150 6
- 7158 6
- 227 5
- 4766 5
- 4838 5
- 7102 5
- 7224 5
- 2 4
- 222 4
- 2413 4
- 3128 4
- 4570 4
- 4955 4
- 5600 4
- 7070 4
- 1 3
- 225 3
- 2429 3
- 2458 3
- 2567 3
- 2695 3
- 2869 3
- 2954 3
- 2997 3
- 2998 3
- 3027 3
- 3047 3
- 3080 3
- 3086 3
- 3151 3
- 3259 3
- 3333 3
- 3409 3
- 3552 3
- 3759 3
- 3853 3
- 3947 3
- 4038 3
- 4125 3
- 4219 3
- 4416 3
- 4462 3
- 4528 3
- 4587 3
- 4623 3
- 4660 3
- 4665 3
- 4667 3
- 4688 3
- 4776 3
- 4803 3
- 4823 3
- 5291 3
- 5922 3
- 6221 3
- 6637 3
- 7015 3
- 14 2
- 19 2
- 73 2
- 148 2
- 149 2
- 157 2
- 190 2
- 200 2
- 203 2
- 204 2
- 226 2
- 791 2
- 828 2
- 1040 2
- 1043 2
- 1085 2
- 1186 2
- 2319 2
- 2346 2
- 2379 2
- 2434 2
- 2460 2
- 2469 2
- 2470 2
- 2950 2
- 3045 2
- 3085 2
- 4584 2
- 4652 2
- 3 1
- 6 1
- 7 1
- 8 1
- 10 1
- 11 1
- 16 1
- 24 1
- 25 1
- 27 1
- 42 1
- 49 1
- 51 1
- 57 1
- 62 1
- 64 1
- 70 1
- 81 1
- 83 1
- 90 1
- 96 1
- 101 1
- 104 1
- 109 1
- 113 1
- 116 1
- 123 1
- 129 1
- 133 1
- 151 1
- 154 1
- 158 1
- 159 1
- 160 1
- 161 1
- 163 1
- 164 1
- 166 1
- 171 1
- 172 1
- 173 1
- 177 1
- 178 1
- 179 1
- 180 1
- 181 1
- 186 1
- 188 1
- 189 1
- 192 1
- 196 1
- 199 1
- 202 1
- 232 1
- 233 1
- 234 1
- 242 1
- 243 1
- 248 1
- 252 1
- 253 1
- 263 1
- 267 1
- 280 1
- 293 1
- 310 1
- 311 1
- 313 1
- 315 1
- 332 1
- 340 1
- 347 1
- 351 1
- 358 1
- 367 1
- 388 1
- 392 1
- 393 1
- 401 1
- 402 1
- 408 1
- 429 1
- 449 1
- 455 1
- 466 1
- 480 1
- 490 1
- 511 1
- 518 1
- 531 1
- 539 1
- 552 1
- 565 1
- 578 1
- 580 1
- 584 1
- 587 1
- 596 1
- 602 1
- 610 1
- 617 1
- 623 1
- 629 1
- 632 1
- 642 1
- 647 1
- 655 1
- 664 1
- 668 1
- 669 1
- 679 1
- 684 1
- 693 1
- 699 1
- 706 1
- 731 1
- 739 1
- 744 1
- 751 1
- 759 1
- 773 1
- 780 1
- 790 1
- 797 1
- 800 1
- 809 1
- 820 1
- 823 1
- 830 1
- 832 1
- 853 1
- 859 1
- 862 1
- 863 1
- 877 1
- 881 1
- 891 1
- 909 1
- 917 1
- 919 1
- 921 1
- 922 1
- 926 1
- 930 1
- 938 1
- 941 1
- 942 1
- 943 1
- 945 1
- 949 1
- 956 1
- 958 1
- 964 1
- 967 1
- 971 1
- 973 1
- 978 1
- 984 1
- 987 1
- 991 1
- 994 1
- 997 1
- 1002 1
- 1008 1
- 1019 1
- 1032 1
- 1052 1
- 1067 1
- 1073 1
- 1089 1
- 1093 1
- 1094 1
- 1102 1
- 1106 1
- 1119 1
- 1122 1
- 1131 1
- 1137 1
- 1139 1
- 1148 1
- 1155 1
- 1173 1
- 1181 1
- 1204 1
- 1209 1
- 1214 1
- 1222 1
- 1236 1
- 1250 1
- 1259 1
- 1276 1
- 1296 1
- 1318 1
- 1337 1
- 1341 1
- 1359 1
- 1365 1
- 1379 1
- 1392 1
- 1411 1
- 1419 1
- 1431 1
- 1444 1
- 1447 1
- 1472 1
- 1483 1
- 1488 1
- 1515 1
- 1523 1
- 1532 1
- 1541 1
- 1550 1
- 1557 1
- 1572 1
- 1587 1
- 1602 1
- 1617 1
- 1630 1
- 1633 1
- 1644 1
- 1669 1
- 1683 1
- 1709 1
- 1719 1
- 1728 1
- 1738 1
- 1742 1
- 1744 1
- 1745 1
- 1754 1
- 1761 1
- 1777 1
- 1794 1
- 1801 1
- 1807 1
- 1812 1
- 1821 1
- 1830 1
- 1846 1
- 1868 1
- 1876 1
- 1892 1
- 1924 1
- 1945 1
- 1960 1
- 1981 1
- 1993 1
- 2000 1
- 2016 1
- 2032 1
- 2046 1
- 2058 1
- 2070 1
- 2078 1
- 2101 1
- 2123 1
- 2136 1
- 2151 1
- 2153 1
- 2162 1
- 2181 1
- 2188 1
- 2199 1
- 2208 1
- 2212 1
- 2217 1
- 2226 1
- 2228 1
- 2232 1
- 2250 1
- 2253 1
- 2255 1
- 2256 1
- 2260 1
- 2262 1
- 2266 1
- 2273 1
- 2277 1
- 2291 1
- 2292 1
- 2299 1
- 2310 1
- 2311 1
- 2315 1
- 2316 1
- 2323 1
- 2328 1
- 2332 1
- 2333 1
- 2338 1
- 2342 1
- 2343 1
- 2350 1
- 2353 1
- 2357 1
- 2359 1
- 2362 1
- 2365 1
- 2366 1
- 2369 1
- 2370 1
- 2374 1
- 2375 1
- 2385 1
- 2394 1
- 2401 1
- 2403 1
- 2405 1
- 2406 1
- 2407 1
- 2408 1
- 2410 1
- 2426 1
- 2435 1
- 2438 1
- 2440 1
- 2442 1
- 2459 1
- 2468 1
- 2471 1
- 2472 1
- 2505 1
- 2536 1
- 2571 1
- 2598 1
- 2618 1
- 2660 1
- 2722 1
- 2787 1
- 2846 1
- 2868 1
- 2886 1
- 2951 1
- 2988 1
- 2990 1
- 2992 1
- 2995 1
- 3006 1
- 3029 1
- 3044 1
- 3048 1
- 3049 1
- 3058 1
- 3074 1
- 3083 1
- 3084 1
- 3087 1
- 3102 1
- 3124 1
- 3126 1
- 3136 1
- 3141 1
- 3145 1
- 3165 1
- 3183 1
- 3215 1
- 3238 1
- 3291 1
- 3298 1
- 3302 1
- 3319 1
- 3363 1
- 3384 1
- 3397 1
- 3405 1
- 3453 1
- 3474 1
- 3506 1
- 3539 1
- 3602 1
- 3619 1
- 3645 1
- 3672 1
- 3790 1
- 3800 1
- 3822 1
- 3840 1
- 3872 1
- 3888 1
- 3910 1
- 3922 1
- 3971 1
- 3972 1
- 3982 1
- 3990 1
- 4095 1
- 4101 1
- 4103 1
- 4116 1
- 4141 1
- 4166 1
- 4174 1
- 4184 1
- 4309 1
- 4365 1
- 4376 1
- 4403 1
- 4429 1
- 4436 1
- 4443 1
- 4458 1
- 4471 1
- 4498 1
- 4506 1
- 4524 1
- 4537 1
- 4563 1
- 4567 1
- 4577 1
- 4586 1
- 4592 1
- 4617 1
- 4618 1
- 4622 1
- 4630 1
- 4647 1
- 4664 1
- 4675 1
- 4680 1
- 4682 1
- 4684 1
- 4747 1
- 4764 1
- 4768 1
- 4771 1
- 4772 1
- 4775 1
- 4784 1
- 4789 1
- 4795 1
- 4798 1
- 4809 1
- 4810 1
- 4814 1
- 4818 1
- 4830 1
- 4832 1
- 4866 1
- 4883 1
- 4912 1
- 5098 1
- 5131 1
- 5167 1
- 5226 1
- 5355 1
- 5401 1
- 5465 1
- 5531 1
- 5751 1
- 5798 1
- 5886 1
- 6008 1
- 6037 1
- 6089 1
- 6156 1
- 6307 1
- 6360 1
- 6476 1
- 6554 1
- 6946 1
- 6963 1
- 7003 1
- 7004 1
- 7038 1
- 7047 1
- 7055 1
- 7063 1
- 7099 1
- 7106 1
state 1
- Mississippi 785
fips 1
- 28001 · 785 ✖
county 1
- Adams 785
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500993 | 2500993 | 2022-05-13 | Adams | Mississippi | 28001 | 7224 | 143 |
2497735 | 2497735 | 2022-05-12 | Adams | Mississippi | 28001 | 7224 | 143 |
2494477 | 2494477 | 2022-05-11 | Adams | Mississippi | 28001 | 7224 | 143 |
2491219 | 2491219 | 2022-05-10 | Adams | Mississippi | 28001 | 7224 | 143 |
2487962 | 2487962 | 2022-05-09 | Adams | Mississippi | 28001 | 7224 | 143 |
2484704 | 2484704 | 2022-05-08 | Adams | Mississippi | 28001 | 7174 | 142 |
2481446 | 2481446 | 2022-05-07 | Adams | Mississippi | 28001 | 7174 | 142 |
2478188 | 2478188 | 2022-05-06 | Adams | Mississippi | 28001 | 7174 | 142 |
2474930 | 2474930 | 2022-05-05 | Adams | Mississippi | 28001 | 7174 | 142 |
2471673 | 2471673 | 2022-05-04 | Adams | Mississippi | 28001 | 7174 | 142 |
2468417 | 2468417 | 2022-05-03 | Adams | Mississippi | 28001 | 7174 | 142 |
2465162 | 2465162 | 2022-05-02 | Adams | Mississippi | 28001 | 7174 | 142 |
2461906 | 2461906 | 2022-05-01 | Adams | Mississippi | 28001 | 7158 | 142 |
2458650 | 2458650 | 2022-04-30 | Adams | Mississippi | 28001 | 7158 | 142 |
2455394 | 2455394 | 2022-04-29 | Adams | Mississippi | 28001 | 7158 | 142 |
2452138 | 2452138 | 2022-04-28 | Adams | Mississippi | 28001 | 7158 | 142 |
2448882 | 2448882 | 2022-04-27 | Adams | Mississippi | 28001 | 7158 | 142 |
2445626 | 2445626 | 2022-04-26 | Adams | Mississippi | 28001 | 7158 | 142 |
2442370 | 2442370 | 2022-04-25 | Adams | Mississippi | 28001 | 7152 | 142 |
2439114 | 2439114 | 2022-04-24 | Adams | Mississippi | 28001 | 7152 | 142 |
2435858 | 2435858 | 2022-04-23 | Adams | Mississippi | 28001 | 7152 | 142 |
2432602 | 2432602 | 2022-04-22 | Adams | Mississippi | 28001 | 7152 | 142 |
2429346 | 2429346 | 2022-04-21 | Adams | Mississippi | 28001 | 7152 | 142 |
2426090 | 2426090 | 2022-04-20 | Adams | Mississippi | 28001 | 7152 | 142 |
2422834 | 2422834 | 2022-04-19 | Adams | Mississippi | 28001 | 7152 | 142 |
2419578 | 2419578 | 2022-04-18 | Adams | Mississippi | 28001 | 7152 | 142 |
2416322 | 2416322 | 2022-04-17 | Adams | Mississippi | 28001 | 7150 | 142 |
2413066 | 2413066 | 2022-04-16 | Adams | Mississippi | 28001 | 7150 | 142 |
2409810 | 2409810 | 2022-04-15 | Adams | Mississippi | 28001 | 7150 | 142 |
2406554 | 2406554 | 2022-04-14 | Adams | Mississippi | 28001 | 7150 | 142 |
2403298 | 2403298 | 2022-04-13 | Adams | Mississippi | 28001 | 7150 | 142 |
2400044 | 2400044 | 2022-04-12 | Adams | Mississippi | 28001 | 7150 | 142 |
2396788 | 2396788 | 2022-04-11 | Adams | Mississippi | 28001 | 7136 | 142 |
2393533 | 2393533 | 2022-04-10 | Adams | Mississippi | 28001 | 7136 | 142 |
2390277 | 2390277 | 2022-04-09 | Adams | Mississippi | 28001 | 7136 | 142 |
2387021 | 2387021 | 2022-04-08 | Adams | Mississippi | 28001 | 7136 | 142 |
2383766 | 2383766 | 2022-04-07 | Adams | Mississippi | 28001 | 7136 | 142 |
2380511 | 2380511 | 2022-04-06 | Adams | Mississippi | 28001 | 7136 | 142 |
2377256 | 2377256 | 2022-04-05 | Adams | Mississippi | 28001 | 7136 | 142 |
2374004 | 2374004 | 2022-04-04 | Adams | Mississippi | 28001 | 7136 | 142 |
2370751 | 2370751 | 2022-04-03 | Adams | Mississippi | 28001 | 7126 | 142 |
2367498 | 2367498 | 2022-04-02 | Adams | Mississippi | 28001 | 7126 | 142 |
2364245 | 2364245 | 2022-04-01 | Adams | Mississippi | 28001 | 7126 | 142 |
2360991 | 2360991 | 2022-03-31 | Adams | Mississippi | 28001 | 7126 | 142 |
2357737 | 2357737 | 2022-03-30 | Adams | Mississippi | 28001 | 7126 | 142 |
2354484 | 2354484 | 2022-03-29 | Adams | Mississippi | 28001 | 7126 | 142 |
2351232 | 2351232 | 2022-03-28 | Adams | Mississippi | 28001 | 7126 | 142 |
2347979 | 2347979 | 2022-03-27 | Adams | Mississippi | 28001 | 7122 | 142 |
2344726 | 2344726 | 2022-03-26 | Adams | Mississippi | 28001 | 7122 | 142 |
2341473 | 2341473 | 2022-03-25 | Adams | Mississippi | 28001 | 7122 | 142 |
2338220 | 2338220 | 2022-03-24 | Adams | Mississippi | 28001 | 7122 | 142 |
2334966 | 2334966 | 2022-03-23 | Adams | Mississippi | 28001 | 7122 | 142 |
2331712 | 2331712 | 2022-03-22 | Adams | Mississippi | 28001 | 7122 | 142 |
2328460 | 2328460 | 2022-03-21 | Adams | Mississippi | 28001 | 7122 | 142 |
2325207 | 2325207 | 2022-03-20 | Adams | Mississippi | 28001 | 7120 | 142 |
2321953 | 2321953 | 2022-03-19 | Adams | Mississippi | 28001 | 7120 | 142 |
2318699 | 2318699 | 2022-03-18 | Adams | Mississippi | 28001 | 7120 | 142 |
2315446 | 2315446 | 2022-03-17 | Adams | Mississippi | 28001 | 7120 | 142 |
2312193 | 2312193 | 2022-03-16 | Adams | Mississippi | 28001 | 7120 | 142 |
2308940 | 2308940 | 2022-03-15 | Adams | Mississippi | 28001 | 7120 | 142 |
2305689 | 2305689 | 2022-03-14 | Adams | Mississippi | 28001 | 7120 | 142 |
2302437 | 2302437 | 2022-03-13 | Adams | Mississippi | 28001 | 7119 | 141 |
2299185 | 2299185 | 2022-03-12 | Adams | Mississippi | 28001 | 7119 | 141 |
2295933 | 2295933 | 2022-03-11 | Adams | Mississippi | 28001 | 7119 | 141 |
2292681 | 2292681 | 2022-03-10 | Adams | Mississippi | 28001 | 7119 | 141 |
2289429 | 2289429 | 2022-03-09 | Adams | Mississippi | 28001 | 7119 | 141 |
2286178 | 2286178 | 2022-03-08 | Adams | Mississippi | 28001 | 7119 | 141 |
2282926 | 2282926 | 2022-03-07 | Adams | Mississippi | 28001 | 7106 | 141 |
2279673 | 2279673 | 2022-03-06 | Adams | Mississippi | 28001 | 7104 | 141 |
2276420 | 2276420 | 2022-03-05 | Adams | Mississippi | 28001 | 7104 | 141 |
2273167 | 2273167 | 2022-03-04 | Adams | Mississippi | 28001 | 7104 | 141 |
2269915 | 2269915 | 2022-03-03 | Adams | Mississippi | 28001 | 7104 | 141 |
2266662 | 2266662 | 2022-03-02 | Adams | Mississippi | 28001 | 7104 | 141 |
2263411 | 2263411 | 2022-03-01 | Adams | Mississippi | 28001 | 7104 | 141 |
2260160 | 2260160 | 2022-02-28 | Adams | Mississippi | 28001 | 7104 | 140 |
2256909 | 2256909 | 2022-02-27 | Adams | Mississippi | 28001 | 7102 | 140 |
2253658 | 2253658 | 2022-02-26 | Adams | Mississippi | 28001 | 7102 | 140 |
2250407 | 2250407 | 2022-02-25 | Adams | Mississippi | 28001 | 7102 | 140 |
2247156 | 2247156 | 2022-02-24 | Adams | Mississippi | 28001 | 7102 | 140 |
2243905 | 2243905 | 2022-02-23 | Adams | Mississippi | 28001 | 7102 | 140 |
2240654 | 2240654 | 2022-02-22 | Adams | Mississippi | 28001 | 7099 | 140 |
2237403 | 2237403 | 2022-02-21 | Adams | Mississippi | 28001 | 7070 | 140 |
2234152 | 2234152 | 2022-02-20 | Adams | Mississippi | 28001 | 7070 | 140 |
2230901 | 2230901 | 2022-02-19 | Adams | Mississippi | 28001 | 7070 | 140 |
2227650 | 2227650 | 2022-02-18 | Adams | Mississippi | 28001 | 7070 | 140 |
2224399 | 2224399 | 2022-02-17 | Adams | Mississippi | 28001 | 7063 | 140 |
2221148 | 2221148 | 2022-02-16 | Adams | Mississippi | 28001 | 7055 | 140 |
2217897 | 2217897 | 2022-02-15 | Adams | Mississippi | 28001 | 7047 | 139 |
2214646 | 2214646 | 2022-02-14 | Adams | Mississippi | 28001 | 7038 | 139 |
2211394 | 2211394 | 2022-02-13 | Adams | Mississippi | 28001 | 7015 | 139 |
2208141 | 2208141 | 2022-02-12 | Adams | Mississippi | 28001 | 7015 | 139 |
2204888 | 2204888 | 2022-02-11 | Adams | Mississippi | 28001 | 7015 | 139 |
2201635 | 2201635 | 2022-02-10 | Adams | Mississippi | 28001 | 7004 | 139 |
2198381 | 2198381 | 2022-02-09 | Adams | Mississippi | 28001 | 7003 | 137 |
2195127 | 2195127 | 2022-02-08 | Adams | Mississippi | 28001 | 6963 | 137 |
2191873 | 2191873 | 2022-02-07 | Adams | Mississippi | 28001 | 6946 | 133 |
2188620 | 2188620 | 2022-02-06 | Adams | Mississippi | 28001 | 6637 | 133 |
2185367 | 2185367 | 2022-02-05 | Adams | Mississippi | 28001 | 6637 | 133 |
2182115 | 2182115 | 2022-02-04 | Adams | Mississippi | 28001 | 6637 | 133 |
2178863 | 2178863 | 2022-02-03 | Adams | Mississippi | 28001 | 6554 | 133 |
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);