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 descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 214 ✖
- 283 41
- 227 38
- 224 26
- 0 19
- 282 19
- 329 18
- 94 17
- 217 15
- 327 14
- 206 13
- 83 12
- 31 11
- 290 11
- 92 10
- 281 10
- 50 9
- 90 9
- 189 9
- 2 8
- 86 8
- 277 8
- 289 8
- 328 8
- 34 7
- 314 7
- 321 7
- 323 7
- 325 7
- 326 7
- 4 6
- 30 6
- 204 6
- 207 6
- 209 6
- 210 6
- 215 6
- 279 6
- 318 6
- 319 6
- 3 5
- 12 5
- 17 5
- 21 5
- 29 5
- 97 5
- 214 5
- 218 5
- 256 5
- 271 5
- 280 5
- 8 4
- 23 4
- 79 4
- 84 4
- 93 4
- 106 4
- 107 4
- 126 4
- 208 4
- 212 4
- 241 4
- 262 4
- 275 4
- 286 4
- 303 4
- 32 3
- 36 3
- 39 3
- 72 3
- 74 3
- 82 3
- 85 3
- 89 3
- 102 3
- 113 3
- 122 3
- 128 3
- 168 3
- 173 3
- 186 3
- 190 3
- 199 3
- 203 3
- 225 3
- 226 3
- 230 3
- 233 3
- 235 3
- 248 3
- 265 3
- 284 3
- 310 3
- 5 2
- 11 2
- 15 2
- 44 2
- 47 2
- 60 2
- 64 2
- 75 2
- 91 2
- 96 2
- 99 2
- 121 2
- 127 2
- 129 2
- 136 2
- 152 2
- 162 2
- 169 2
- 176 2
- 188 2
- 213 2
- 259 2
- 263 2
- 274 2
- 278 2
- 302 2
- 6 1
- 7 1
- 9 1
- 10 1
- 13 1
- 18 1
- 19 1
- 20 1
- 22 1
- 25 1
- 27 1
- 28 1
- 35 1
- 38 1
- 40 1
- 42 1
- 43 1
- 45 1
- 53 1
- 54 1
- 56 1
- 63 1
- 66 1
- 68 1
- 69 1
- 77 1
- 81 1
- 88 1
- 98 1
- 101 1
- 105 1
- 110 1
- 112 1
- 114 1
- 118 1
- 119 1
- 123 1
- 125 1
- 131 1
- 132 1
- 137 1
- 138 1
- 139 1
- 145 1
- 146 1
- 147 1
- 149 1
- 151 1
- 153 1
- 156 1
- 158 1
- 160 1
- 161 1
- 164 1
- 166 1
- 171 1
- 175 1
- 178 1
- 182 1
- 183 1
- 185 1
- 193 1
- 194 1
- 195 1
- 196 1
- 211 1
- 216 1
- 220 1
- 222 1
- 223 1
- 229 1
- 232 1
- 237 1
- 239 1
- 240 1
- 242 1
- 244 1
- 245 1
- 246 1
- 252 1
- 255 1
- 260 1
- 261 1
- 264 1
- 269 1
- 270 1
- 272 1
- 273 1
- 287 1
- 293 1
- 297 1
- 304 1
- 305 1
- 307 1
- 311 1
- 312 1
state 1
- Mississippi 787
fips 1
- 28089 · 787 ✖
county 1
- Madison 787
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2501037 | 2501037 | 2022-05-13 | Madison | Mississippi | 28089 | 24189 | 329 |
2497779 | 2497779 | 2022-05-12 | Madison | Mississippi | 28089 | 24189 | 329 |
2494521 | 2494521 | 2022-05-11 | Madison | Mississippi | 28089 | 24189 | 329 |
2491263 | 2491263 | 2022-05-10 | Madison | Mississippi | 28089 | 24189 | 329 |
2488006 | 2488006 | 2022-05-09 | Madison | Mississippi | 28089 | 24189 | 329 |
2484748 | 2484748 | 2022-05-08 | Madison | Mississippi | 28089 | 24113 | 329 |
2481490 | 2481490 | 2022-05-07 | Madison | Mississippi | 28089 | 24113 | 329 |
2478232 | 2478232 | 2022-05-06 | Madison | Mississippi | 28089 | 24113 | 329 |
2474974 | 2474974 | 2022-05-05 | Madison | Mississippi | 28089 | 24113 | 329 |
2471717 | 2471717 | 2022-05-04 | Madison | Mississippi | 28089 | 24113 | 329 |
2468461 | 2468461 | 2022-05-03 | Madison | Mississippi | 28089 | 24113 | 329 |
2465206 | 2465206 | 2022-05-02 | Madison | Mississippi | 28089 | 24113 | 329 |
2461950 | 2461950 | 2022-05-01 | Madison | Mississippi | 28089 | 24079 | 329 |
2458694 | 2458694 | 2022-04-30 | Madison | Mississippi | 28089 | 24079 | 329 |
2455438 | 2455438 | 2022-04-29 | Madison | Mississippi | 28089 | 24079 | 329 |
2452182 | 2452182 | 2022-04-28 | Madison | Mississippi | 28089 | 24079 | 329 |
2448926 | 2448926 | 2022-04-27 | Madison | Mississippi | 28089 | 24079 | 329 |
2445670 | 2445670 | 2022-04-26 | Madison | Mississippi | 28089 | 24079 | 329 |
2442414 | 2442414 | 2022-04-25 | Madison | Mississippi | 28089 | 24040 | 328 |
2439158 | 2439158 | 2022-04-24 | Madison | Mississippi | 28089 | 24040 | 328 |
2435902 | 2435902 | 2022-04-23 | Madison | Mississippi | 28089 | 24040 | 328 |
2432646 | 2432646 | 2022-04-22 | Madison | Mississippi | 28089 | 24040 | 328 |
2429390 | 2429390 | 2022-04-21 | Madison | Mississippi | 28089 | 24040 | 328 |
2426134 | 2426134 | 2022-04-20 | Madison | Mississippi | 28089 | 24040 | 328 |
2422878 | 2422878 | 2022-04-19 | Madison | Mississippi | 28089 | 24040 | 328 |
2419622 | 2419622 | 2022-04-18 | Madison | Mississippi | 28089 | 24040 | 328 |
2416366 | 2416366 | 2022-04-17 | Madison | Mississippi | 28089 | 24018 | 327 |
2413110 | 2413110 | 2022-04-16 | Madison | Mississippi | 28089 | 24018 | 327 |
2409854 | 2409854 | 2022-04-15 | Madison | Mississippi | 28089 | 24018 | 327 |
2406598 | 2406598 | 2022-04-14 | Madison | Mississippi | 28089 | 24018 | 327 |
2403342 | 2403342 | 2022-04-13 | Madison | Mississippi | 28089 | 24018 | 327 |
2400088 | 2400088 | 2022-04-12 | Madison | Mississippi | 28089 | 24018 | 327 |
2396832 | 2396832 | 2022-04-11 | Madison | Mississippi | 28089 | 23987 | 327 |
2393577 | 2393577 | 2022-04-10 | Madison | Mississippi | 28089 | 23987 | 327 |
2390321 | 2390321 | 2022-04-09 | Madison | Mississippi | 28089 | 23987 | 327 |
2387065 | 2387065 | 2022-04-08 | Madison | Mississippi | 28089 | 23987 | 327 |
2383810 | 2383810 | 2022-04-07 | Madison | Mississippi | 28089 | 23987 | 327 |
2380555 | 2380555 | 2022-04-06 | Madison | Mississippi | 28089 | 23987 | 327 |
2377300 | 2377300 | 2022-04-05 | Madison | Mississippi | 28089 | 23987 | 327 |
2374048 | 2374048 | 2022-04-04 | Madison | Mississippi | 28089 | 23987 | 327 |
2370795 | 2370795 | 2022-04-03 | Madison | Mississippi | 28089 | 23969 | 326 |
2367542 | 2367542 | 2022-04-02 | Madison | Mississippi | 28089 | 23969 | 326 |
2364289 | 2364289 | 2022-04-01 | Madison | Mississippi | 28089 | 23969 | 326 |
2361035 | 2361035 | 2022-03-31 | Madison | Mississippi | 28089 | 23969 | 326 |
2357781 | 2357781 | 2022-03-30 | Madison | Mississippi | 28089 | 23969 | 326 |
2354528 | 2354528 | 2022-03-29 | Madison | Mississippi | 28089 | 23969 | 326 |
2351276 | 2351276 | 2022-03-28 | Madison | Mississippi | 28089 | 23969 | 326 |
2348023 | 2348023 | 2022-03-27 | Madison | Mississippi | 28089 | 23950 | 325 |
2344770 | 2344770 | 2022-03-26 | Madison | Mississippi | 28089 | 23950 | 325 |
2341517 | 2341517 | 2022-03-25 | Madison | Mississippi | 28089 | 23950 | 325 |
2338264 | 2338264 | 2022-03-24 | Madison | Mississippi | 28089 | 23950 | 325 |
2335010 | 2335010 | 2022-03-23 | Madison | Mississippi | 28089 | 23950 | 325 |
2331756 | 2331756 | 2022-03-22 | Madison | Mississippi | 28089 | 23950 | 325 |
2328504 | 2328504 | 2022-03-21 | Madison | Mississippi | 28089 | 23950 | 325 |
2325251 | 2325251 | 2022-03-20 | Madison | Mississippi | 28089 | 23930 | 323 |
2321997 | 2321997 | 2022-03-19 | Madison | Mississippi | 28089 | 23930 | 323 |
2318743 | 2318743 | 2022-03-18 | Madison | Mississippi | 28089 | 23930 | 323 |
2315490 | 2315490 | 2022-03-17 | Madison | Mississippi | 28089 | 23930 | 323 |
2312237 | 2312237 | 2022-03-16 | Madison | Mississippi | 28089 | 23930 | 323 |
2308984 | 2308984 | 2022-03-15 | Madison | Mississippi | 28089 | 23930 | 323 |
2305733 | 2305733 | 2022-03-14 | Madison | Mississippi | 28089 | 23930 | 323 |
2302481 | 2302481 | 2022-03-13 | Madison | Mississippi | 28089 | 23911 | 321 |
2299229 | 2299229 | 2022-03-12 | Madison | Mississippi | 28089 | 23911 | 321 |
2295977 | 2295977 | 2022-03-11 | Madison | Mississippi | 28089 | 23911 | 321 |
2292725 | 2292725 | 2022-03-10 | Madison | Mississippi | 28089 | 23911 | 321 |
2289473 | 2289473 | 2022-03-09 | Madison | Mississippi | 28089 | 23911 | 321 |
2286222 | 2286222 | 2022-03-08 | Madison | Mississippi | 28089 | 23911 | 321 |
2282970 | 2282970 | 2022-03-07 | Madison | Mississippi | 28089 | 23905 | 321 |
2279717 | 2279717 | 2022-03-06 | Madison | Mississippi | 28089 | 23880 | 319 |
2276464 | 2276464 | 2022-03-05 | Madison | Mississippi | 28089 | 23880 | 319 |
2273211 | 2273211 | 2022-03-04 | Madison | Mississippi | 28089 | 23880 | 319 |
2269959 | 2269959 | 2022-03-03 | Madison | Mississippi | 28089 | 23877 | 319 |
2266706 | 2266706 | 2022-03-02 | Madison | Mississippi | 28089 | 23873 | 319 |
2263455 | 2263455 | 2022-03-01 | Madison | Mississippi | 28089 | 23869 | 319 |
2260204 | 2260204 | 2022-02-28 | Madison | Mississippi | 28089 | 23857 | 318 |
2256953 | 2256953 | 2022-02-27 | Madison | Mississippi | 28089 | 23838 | 318 |
2253702 | 2253702 | 2022-02-26 | Madison | Mississippi | 28089 | 23838 | 318 |
2250451 | 2250451 | 2022-02-25 | Madison | Mississippi | 28089 | 23838 | 318 |
2247200 | 2247200 | 2022-02-24 | Madison | Mississippi | 28089 | 23819 | 318 |
2243949 | 2243949 | 2022-02-23 | Madison | Mississippi | 28089 | 23803 | 318 |
2240698 | 2240698 | 2022-02-22 | Madison | Mississippi | 28089 | 23796 | 314 |
2237447 | 2237447 | 2022-02-21 | Madison | Mississippi | 28089 | 23758 | 314 |
2234196 | 2234196 | 2022-02-20 | Madison | Mississippi | 28089 | 23758 | 314 |
2230945 | 2230945 | 2022-02-19 | Madison | Mississippi | 28089 | 23758 | 314 |
2227694 | 2227694 | 2022-02-18 | Madison | Mississippi | 28089 | 23758 | 314 |
2224443 | 2224443 | 2022-02-17 | Madison | Mississippi | 28089 | 23681 | 314 |
2221192 | 2221192 | 2022-02-16 | Madison | Mississippi | 28089 | 23669 | 314 |
2217941 | 2217941 | 2022-02-15 | Madison | Mississippi | 28089 | 23651 | 312 |
2214690 | 2214690 | 2022-02-14 | Madison | Mississippi | 28089 | 23630 | 311 |
2211438 | 2211438 | 2022-02-13 | Madison | Mississippi | 28089 | 23494 | 310 |
2208185 | 2208185 | 2022-02-12 | Madison | Mississippi | 28089 | 23494 | 310 |
2204932 | 2204932 | 2022-02-11 | Madison | Mississippi | 28089 | 23494 | 310 |
2201679 | 2201679 | 2022-02-10 | Madison | Mississippi | 28089 | 23381 | 307 |
2198425 | 2198425 | 2022-02-09 | Madison | Mississippi | 28089 | 23354 | 305 |
2195171 | 2195171 | 2022-02-08 | Madison | Mississippi | 28089 | 23296 | 304 |
2191917 | 2191917 | 2022-02-07 | Madison | Mississippi | 28089 | 23264 | 303 |
2188664 | 2188664 | 2022-02-06 | Madison | Mississippi | 28089 | 22994 | 303 |
2185411 | 2185411 | 2022-02-05 | Madison | Mississippi | 28089 | 22994 | 303 |
2182159 | 2182159 | 2022-02-04 | Madison | Mississippi | 28089 | 22994 | 303 |
2178907 | 2178907 | 2022-02-03 | Madison | Mississippi | 28089 | 22654 | 302 |
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);