ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
784 rows where fips = 21151 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: cases, date (date)
deaths 127 ✖
- 1 138
- 113 35
- 109 33
- 112 33
- 111 28
- 7 18
- 14 16
- 0 15
- 90 14
- 274 14
- 108 13
- 4 12
- 280 12
- 13 11
- 3 9
- 18 9
- 144 9
- 212 9
- 221 9
- 222 9
- 6 8
- 20 8
- 79 7
- 107 7
- 145 7
- 252 7
- 254 7
- 263 7
- 267 7
- 271 7
- 279 7
- 2 6
- 191 6
- 213 6
- 11 5
- 19 5
- 26 5
- 39 5
- 57 5
- 86 5
- 103 5
- 118 5
- 160 5
- 231 5
- 16 4
- 21 4
- 77 4
- 115 4
- 116 4
- 121 4
- 124 4
- 127 4
- 133 4
- 190 4
- 197 4
- 206 4
- 223 4
- 245 4
- 247 4
- 248 4
- 9 3
- 27 3
- 35 3
- 43 3
- 45 3
- 48 3
- 49 3
- 65 3
- 125 3
- 126 3
- 134 3
- 153 3
- 162 3
- 167 3
- 186 3
- 207 3
- 209 3
- 219 3
- 233 3
- 236 3
- 241 3
- 251 3
- 36 2
- 38 2
- 40 2
- 42 2
- 47 2
- 56 2
- 89 2
- 117 2
- 119 2
- 152 2
- 179 2
- 187 2
- 195 2
- 202 2
- 216 2
- 249 2
- 25 1
- 30 1
- 34 1
- 46 1
- 50 1
- 53 1
- 63 1
- 66 1
- 73 1
- 78 1
- 84 1
- 99 1
- 105 1
- 106 1
- 110 1
- 157 1
- 158 1
- 163 1
- 176 1
- 177 1
- 188 1
- 189 1
- 196 1
- 200 1
- 208 1
- 214 1
- 229 1
- 234 1
- 250 1
state 1
- Kentucky 784
fips 1
- 21151 · 784 ✖
county 1
- Madison 784
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500651 | 2500651 | 2022-05-13 | Madison | Kentucky | 21151 | 27833 | 280 |
2497393 | 2497393 | 2022-05-12 | Madison | Kentucky | 21151 | 27833 | 280 |
2494135 | 2494135 | 2022-05-11 | Madison | Kentucky | 21151 | 27833 | 280 |
2490877 | 2490877 | 2022-05-10 | Madison | Kentucky | 21151 | 27833 | 280 |
2487620 | 2487620 | 2022-05-09 | Madison | Kentucky | 21151 | 27833 | 280 |
2484362 | 2484362 | 2022-05-08 | Madison | Kentucky | 21151 | 27759 | 280 |
2481104 | 2481104 | 2022-05-07 | Madison | Kentucky | 21151 | 27759 | 280 |
2477846 | 2477846 | 2022-05-06 | Madison | Kentucky | 21151 | 27759 | 280 |
2474588 | 2474588 | 2022-05-05 | Madison | Kentucky | 21151 | 27759 | 280 |
2471331 | 2471331 | 2022-05-04 | Madison | Kentucky | 21151 | 27759 | 280 |
2468075 | 2468075 | 2022-05-03 | Madison | Kentucky | 21151 | 27759 | 280 |
2464820 | 2464820 | 2022-05-02 | Madison | Kentucky | 21151 | 27759 | 280 |
2461564 | 2461564 | 2022-05-01 | Madison | Kentucky | 21151 | 27693 | 279 |
2458308 | 2458308 | 2022-04-30 | Madison | Kentucky | 21151 | 27693 | 279 |
2455052 | 2455052 | 2022-04-29 | Madison | Kentucky | 21151 | 27693 | 279 |
2451796 | 2451796 | 2022-04-28 | Madison | Kentucky | 21151 | 27693 | 279 |
2448540 | 2448540 | 2022-04-27 | Madison | Kentucky | 21151 | 27693 | 279 |
2445284 | 2445284 | 2022-04-26 | Madison | Kentucky | 21151 | 27693 | 279 |
2442028 | 2442028 | 2022-04-25 | Madison | Kentucky | 21151 | 27693 | 279 |
2438772 | 2438772 | 2022-04-24 | Madison | Kentucky | 21151 | 27713 | 274 |
2435516 | 2435516 | 2022-04-23 | Madison | Kentucky | 21151 | 27713 | 274 |
2432260 | 2432260 | 2022-04-22 | Madison | Kentucky | 21151 | 27713 | 274 |
2429004 | 2429004 | 2022-04-21 | Madison | Kentucky | 21151 | 27713 | 274 |
2425748 | 2425748 | 2022-04-20 | Madison | Kentucky | 21151 | 27713 | 274 |
2422492 | 2422492 | 2022-04-19 | Madison | Kentucky | 21151 | 27713 | 274 |
2419236 | 2419236 | 2022-04-18 | Madison | Kentucky | 21151 | 27713 | 274 |
2415980 | 2415980 | 2022-04-17 | Madison | Kentucky | 21151 | 27683 | 274 |
2412724 | 2412724 | 2022-04-16 | Madison | Kentucky | 21151 | 27683 | 274 |
2409468 | 2409468 | 2022-04-15 | Madison | Kentucky | 21151 | 27683 | 274 |
2406212 | 2406212 | 2022-04-14 | Madison | Kentucky | 21151 | 27683 | 274 |
2402956 | 2402956 | 2022-04-13 | Madison | Kentucky | 21151 | 27683 | 274 |
2399702 | 2399702 | 2022-04-12 | Madison | Kentucky | 21151 | 27683 | 274 |
2396446 | 2396446 | 2022-04-11 | Madison | Kentucky | 21151 | 27683 | 274 |
2393191 | 2393191 | 2022-04-10 | Madison | Kentucky | 21151 | 27661 | 271 |
2389935 | 2389935 | 2022-04-09 | Madison | Kentucky | 21151 | 27661 | 271 |
2386679 | 2386679 | 2022-04-08 | Madison | Kentucky | 21151 | 27661 | 271 |
2383424 | 2383424 | 2022-04-07 | Madison | Kentucky | 21151 | 27661 | 271 |
2380169 | 2380169 | 2022-04-06 | Madison | Kentucky | 21151 | 27661 | 271 |
2376914 | 2376914 | 2022-04-05 | Madison | Kentucky | 21151 | 27661 | 271 |
2373662 | 2373662 | 2022-04-04 | Madison | Kentucky | 21151 | 27661 | 271 |
2370409 | 2370409 | 2022-04-03 | Madison | Kentucky | 21151 | 27626 | 267 |
2367156 | 2367156 | 2022-04-02 | Madison | Kentucky | 21151 | 27626 | 267 |
2363903 | 2363903 | 2022-04-01 | Madison | Kentucky | 21151 | 27626 | 267 |
2360649 | 2360649 | 2022-03-31 | Madison | Kentucky | 21151 | 27626 | 267 |
2357395 | 2357395 | 2022-03-30 | Madison | Kentucky | 21151 | 27626 | 267 |
2354142 | 2354142 | 2022-03-29 | Madison | Kentucky | 21151 | 27626 | 267 |
2350890 | 2350890 | 2022-03-28 | Madison | Kentucky | 21151 | 27626 | 267 |
2347637 | 2347637 | 2022-03-27 | Madison | Kentucky | 21151 | 27608 | 263 |
2344384 | 2344384 | 2022-03-26 | Madison | Kentucky | 21151 | 27608 | 263 |
2341131 | 2341131 | 2022-03-25 | Madison | Kentucky | 21151 | 27608 | 263 |
2337878 | 2337878 | 2022-03-24 | Madison | Kentucky | 21151 | 27608 | 263 |
2334624 | 2334624 | 2022-03-23 | Madison | Kentucky | 21151 | 27608 | 263 |
2331370 | 2331370 | 2022-03-22 | Madison | Kentucky | 21151 | 27608 | 263 |
2328118 | 2328118 | 2022-03-21 | Madison | Kentucky | 21151 | 27608 | 263 |
2324865 | 2324865 | 2022-03-20 | Madison | Kentucky | 21151 | 27568 | 254 |
2321611 | 2321611 | 2022-03-19 | Madison | Kentucky | 21151 | 27568 | 254 |
2318357 | 2318357 | 2022-03-18 | Madison | Kentucky | 21151 | 27568 | 254 |
2315104 | 2315104 | 2022-03-17 | Madison | Kentucky | 21151 | 27568 | 254 |
2311851 | 2311851 | 2022-03-16 | Madison | Kentucky | 21151 | 27568 | 254 |
2308598 | 2308598 | 2022-03-15 | Madison | Kentucky | 21151 | 27568 | 254 |
2305347 | 2305347 | 2022-03-14 | Madison | Kentucky | 21151 | 27568 | 254 |
2302095 | 2302095 | 2022-03-13 | Madison | Kentucky | 21151 | 27487 | 252 |
2298843 | 2298843 | 2022-03-12 | Madison | Kentucky | 21151 | 27487 | 252 |
2295591 | 2295591 | 2022-03-11 | Madison | Kentucky | 21151 | 27487 | 252 |
2292339 | 2292339 | 2022-03-10 | Madison | Kentucky | 21151 | 27487 | 252 |
2289087 | 2289087 | 2022-03-09 | Madison | Kentucky | 21151 | 27487 | 252 |
2285836 | 2285836 | 2022-03-08 | Madison | Kentucky | 21151 | 27487 | 252 |
2282584 | 2282584 | 2022-03-07 | Madison | Kentucky | 21151 | 27487 | 252 |
2279331 | 2279331 | 2022-03-06 | Madison | Kentucky | 21151 | 27461 | 251 |
2276078 | 2276078 | 2022-03-05 | Madison | Kentucky | 21151 | 27461 | 251 |
2272825 | 2272825 | 2022-03-04 | Madison | Kentucky | 21151 | 27461 | 251 |
2269573 | 2269573 | 2022-03-03 | Madison | Kentucky | 21151 | 27426 | 250 |
2266320 | 2266320 | 2022-03-02 | Madison | Kentucky | 21151 | 27409 | 249 |
2263069 | 2263069 | 2022-03-01 | Madison | Kentucky | 21151 | 27385 | 249 |
2259818 | 2259818 | 2022-02-28 | Madison | Kentucky | 21151 | 27334 | 248 |
2256567 | 2256567 | 2022-02-27 | Madison | Kentucky | 21151 | 27292 | 248 |
2253316 | 2253316 | 2022-02-26 | Madison | Kentucky | 21151 | 27292 | 248 |
2250065 | 2250065 | 2022-02-25 | Madison | Kentucky | 21151 | 27292 | 248 |
2246814 | 2246814 | 2022-02-24 | Madison | Kentucky | 21151 | 27234 | 247 |
2243563 | 2243563 | 2022-02-23 | Madison | Kentucky | 21151 | 27234 | 247 |
2240312 | 2240312 | 2022-02-22 | Madison | Kentucky | 21151 | 27166 | 247 |
2237061 | 2237061 | 2022-02-21 | Madison | Kentucky | 21151 | 27096 | 247 |
2233810 | 2233810 | 2022-02-20 | Madison | Kentucky | 21151 | 27032 | 245 |
2230559 | 2230559 | 2022-02-19 | Madison | Kentucky | 21151 | 27032 | 245 |
2227308 | 2227308 | 2022-02-18 | Madison | Kentucky | 21151 | 27032 | 245 |
2224057 | 2224057 | 2022-02-17 | Madison | Kentucky | 21151 | 26963 | 245 |
2220806 | 2220806 | 2022-02-16 | Madison | Kentucky | 21151 | 26882 | 241 |
2217555 | 2217555 | 2022-02-15 | Madison | Kentucky | 21151 | 26834 | 241 |
2214304 | 2214304 | 2022-02-14 | Madison | Kentucky | 21151 | 26722 | 241 |
2211052 | 2211052 | 2022-02-13 | Madison | Kentucky | 21151 | 26398 | 236 |
2207799 | 2207799 | 2022-02-12 | Madison | Kentucky | 21151 | 26398 | 236 |
2204546 | 2204546 | 2022-02-11 | Madison | Kentucky | 21151 | 26398 | 236 |
2201293 | 2201293 | 2022-02-10 | Madison | Kentucky | 21151 | 26295 | 234 |
2198039 | 2198039 | 2022-02-09 | Madison | Kentucky | 21151 | 26118 | 233 |
2194785 | 2194785 | 2022-02-08 | Madison | Kentucky | 21151 | 25951 | 233 |
2191531 | 2191531 | 2022-02-07 | Madison | Kentucky | 21151 | 25761 | 233 |
2188278 | 2188278 | 2022-02-06 | Madison | Kentucky | 21151 | 25628 | 231 |
2185025 | 2185025 | 2022-02-05 | Madison | Kentucky | 21151 | 25628 | 231 |
2181773 | 2181773 | 2022-02-04 | Madison | Kentucky | 21151 | 25628 | 231 |
2178522 | 2178522 | 2022-02-03 | Madison | Kentucky | 21151 | 25444 | 231 |
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);