ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
780 rows where county = "Chilton" and fips = 1021 sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2499585 | 2499585 | 2022-05-13 | Chilton | Alabama | 1021 | 11131 | 207 |
2496327 | 2496327 | 2022-05-12 | Chilton | Alabama | 1021 | 11128 | 207 |
2493069 | 2493069 | 2022-05-11 | Chilton | Alabama | 1021 | 11128 | 207 |
2489811 | 2489811 | 2022-05-10 | Chilton | Alabama | 1021 | 11127 | 207 |
2486554 | 2486554 | 2022-05-09 | Chilton | Alabama | 1021 | 11125 | 207 |
2483296 | 2483296 | 2022-05-08 | Chilton | Alabama | 1021 | 11124 | 207 |
2480038 | 2480038 | 2022-05-07 | Chilton | Alabama | 1021 | 11124 | 207 |
2476780 | 2476780 | 2022-05-06 | Chilton | Alabama | 1021 | 11124 | 207 |
2473522 | 2473522 | 2022-05-05 | Chilton | Alabama | 1021 | 11124 | 207 |
2470265 | 2470265 | 2022-05-04 | Chilton | Alabama | 1021 | 11123 | 207 |
2467009 | 2467009 | 2022-05-03 | Chilton | Alabama | 1021 | 11123 | 207 |
2463754 | 2463754 | 2022-05-02 | Chilton | Alabama | 1021 | 11122 | 207 |
2460498 | 2460498 | 2022-05-01 | Chilton | Alabama | 1021 | 11120 | 207 |
2457242 | 2457242 | 2022-04-30 | Chilton | Alabama | 1021 | 11120 | 207 |
2453986 | 2453986 | 2022-04-29 | Chilton | Alabama | 1021 | 11120 | 207 |
2450730 | 2450730 | 2022-04-28 | Chilton | Alabama | 1021 | 11116 | 207 |
2447474 | 2447474 | 2022-04-27 | Chilton | Alabama | 1021 | 11115 | 207 |
2444218 | 2444218 | 2022-04-26 | Chilton | Alabama | 1021 | 11113 | 207 |
2440962 | 2440962 | 2022-04-25 | Chilton | Alabama | 1021 | 11110 | 207 |
2437706 | 2437706 | 2022-04-24 | Chilton | Alabama | 1021 | 11107 | 207 |
2434450 | 2434450 | 2022-04-23 | Chilton | Alabama | 1021 | 11107 | 207 |
2431194 | 2431194 | 2022-04-22 | Chilton | Alabama | 1021 | 11107 | 207 |
2427938 | 2427938 | 2022-04-21 | Chilton | Alabama | 1021 | 11101 | 207 |
2424682 | 2424682 | 2022-04-20 | Chilton | Alabama | 1021 | 11099 | 207 |
2421426 | 2421426 | 2022-04-19 | Chilton | Alabama | 1021 | 11099 | 207 |
2418170 | 2418170 | 2022-04-18 | Chilton | Alabama | 1021 | 11082 | 207 |
2414914 | 2414914 | 2022-04-17 | Chilton | Alabama | 1021 | 11082 | 207 |
2411658 | 2411658 | 2022-04-16 | Chilton | Alabama | 1021 | 11082 | 207 |
2408402 | 2408402 | 2022-04-15 | Chilton | Alabama | 1021 | 11082 | 207 |
2405146 | 2405146 | 2022-04-14 | Chilton | Alabama | 1021 | 11078 | 206 |
2401891 | 2401891 | 2022-04-13 | Chilton | Alabama | 1021 | 11074 | 202 |
2398636 | 2398636 | 2022-04-12 | Chilton | Alabama | 1021 | 11072 | 202 |
2395381 | 2395381 | 2022-04-11 | Chilton | Alabama | 1021 | 11071 | 202 |
2392125 | 2392125 | 2022-04-10 | Chilton | Alabama | 1021 | 11060 | 202 |
2388869 | 2388869 | 2022-04-09 | Chilton | Alabama | 1021 | 11060 | 202 |
2385614 | 2385614 | 2022-04-08 | Chilton | Alabama | 1021 | 11060 | 202 |
2382359 | 2382359 | 2022-04-07 | Chilton | Alabama | 1021 | 11060 | 202 |
2379104 | 2379104 | 2022-04-06 | Chilton | Alabama | 1021 | 11060 | 202 |
2375850 | 2375850 | 2022-04-05 | Chilton | Alabama | 1021 | 11047 | 202 |
2372598 | 2372598 | 2022-04-04 | Chilton | Alabama | 1021 | 11045 | 202 |
2369345 | 2369345 | 2022-04-03 | Chilton | Alabama | 1021 | 11044 | 201 |
2366092 | 2366092 | 2022-04-02 | Chilton | Alabama | 1021 | 11044 | 201 |
2362839 | 2362839 | 2022-04-01 | Chilton | Alabama | 1021 | 11044 | 201 |
2359585 | 2359585 | 2022-03-31 | Chilton | Alabama | 1021 | 11044 | 201 |
2356331 | 2356331 | 2022-03-30 | Chilton | Alabama | 1021 | 11043 | 201 |
2353078 | 2353078 | 2022-03-29 | Chilton | Alabama | 1021 | 11039 | 201 |
2349826 | 2349826 | 2022-03-28 | Chilton | Alabama | 1021 | 11030 | 201 |
2346573 | 2346573 | 2022-03-27 | Chilton | Alabama | 1021 | 11022 | 201 |
2343320 | 2343320 | 2022-03-26 | Chilton | Alabama | 1021 | 11022 | 201 |
2340067 | 2340067 | 2022-03-25 | Chilton | Alabama | 1021 | 11022 | 201 |
2336814 | 2336814 | 2022-03-24 | Chilton | Alabama | 1021 | 10991 | 199 |
2333560 | 2333560 | 2022-03-23 | Chilton | Alabama | 1021 | 10976 | 199 |
2330306 | 2330306 | 2022-03-22 | Chilton | Alabama | 1021 | 10949 | 199 |
2327054 | 2327054 | 2022-03-21 | Chilton | Alabama | 1021 | 10930 | 199 |
2323801 | 2323801 | 2022-03-20 | Chilton | Alabama | 1021 | 10923 | 199 |
2320547 | 2320547 | 2022-03-19 | Chilton | Alabama | 1021 | 10923 | 199 |
2317293 | 2317293 | 2022-03-18 | Chilton | Alabama | 1021 | 10923 | 199 |
2314040 | 2314040 | 2022-03-17 | Chilton | Alabama | 1021 | 10897 | 199 |
2310787 | 2310787 | 2022-03-16 | Chilton | Alabama | 1021 | 10873 | 198 |
2307534 | 2307534 | 2022-03-15 | Chilton | Alabama | 1021 | 10819 | 198 |
2304283 | 2304283 | 2022-03-14 | Chilton | Alabama | 1021 | 10817 | 198 |
2301031 | 2301031 | 2022-03-13 | Chilton | Alabama | 1021 | 10801 | 197 |
2297779 | 2297779 | 2022-03-12 | Chilton | Alabama | 1021 | 10801 | 197 |
2294527 | 2294527 | 2022-03-11 | Chilton | Alabama | 1021 | 10801 | 197 |
2291275 | 2291275 | 2022-03-10 | Chilton | Alabama | 1021 | 10784 | 195 |
2288023 | 2288023 | 2022-03-09 | Chilton | Alabama | 1021 | 10774 | 195 |
2284771 | 2284771 | 2022-03-08 | Chilton | Alabama | 1021 | 10728 | 195 |
2281519 | 2281519 | 2022-03-07 | Chilton | Alabama | 1021 | 10700 | 193 |
2278266 | 2278266 | 2022-03-06 | Chilton | Alabama | 1021 | 10656 | 192 |
2275013 | 2275013 | 2022-03-05 | Chilton | Alabama | 1021 | 10656 | 192 |
2271760 | 2271760 | 2022-03-04 | Chilton | Alabama | 1021 | 10656 | 192 |
2268508 | 2268508 | 2022-03-03 | Chilton | Alabama | 1021 | 10644 | 187 |
2265255 | 2265255 | 2022-03-02 | Chilton | Alabama | 1021 | 10628 | 187 |
2262005 | 2262005 | 2022-03-01 | Chilton | Alabama | 1021 | 10620 | 187 |
2258754 | 2258754 | 2022-02-28 | Chilton | Alabama | 1021 | 10594 | 187 |
2255503 | 2255503 | 2022-02-27 | Chilton | Alabama | 1021 | 10593 | 187 |
2252252 | 2252252 | 2022-02-26 | Chilton | Alabama | 1021 | 10588 | 187 |
2249001 | 2249001 | 2022-02-25 | Chilton | Alabama | 1021 | 10564 | 187 |
2245750 | 2245750 | 2022-02-24 | Chilton | Alabama | 1021 | 10544 | 187 |
2242499 | 2242499 | 2022-02-23 | Chilton | Alabama | 1021 | 10501 | 187 |
2239248 | 2239248 | 2022-02-22 | Chilton | Alabama | 1021 | 10486 | 186 |
2235997 | 2235997 | 2022-02-21 | Chilton | Alabama | 1021 | 10477 | 186 |
2232746 | 2232746 | 2022-02-20 | Chilton | Alabama | 1021 | 10476 | 186 |
2229495 | 2229495 | 2022-02-19 | Chilton | Alabama | 1021 | 10474 | 186 |
2226244 | 2226244 | 2022-02-18 | Chilton | Alabama | 1021 | 10429 | 186 |
2222993 | 2222993 | 2022-02-17 | Chilton | Alabama | 1021 | 10409 | 186 |
2219742 | 2219742 | 2022-02-16 | Chilton | Alabama | 1021 | 10380 | 186 |
2216492 | 2216492 | 2022-02-15 | Chilton | Alabama | 1021 | 10376 | 185 |
2213241 | 2213241 | 2022-02-14 | Chilton | Alabama | 1021 | 10359 | 185 |
2209988 | 2209988 | 2022-02-13 | Chilton | Alabama | 1021 | 10354 | 185 |
2206735 | 2206735 | 2022-02-12 | Chilton | Alabama | 1021 | 10346 | 185 |
2203482 | 2203482 | 2022-02-11 | Chilton | Alabama | 1021 | 10320 | 185 |
2200228 | 2200228 | 2022-02-10 | Chilton | Alabama | 1021 | 10297 | 185 |
2196974 | 2196974 | 2022-02-09 | Chilton | Alabama | 1021 | 10280 | 184 |
2193719 | 2193719 | 2022-02-08 | Chilton | Alabama | 1021 | 10256 | 184 |
2190466 | 2190466 | 2022-02-07 | Chilton | Alabama | 1021 | 10218 | 184 |
2187213 | 2187213 | 2022-02-06 | Chilton | Alabama | 1021 | 10193 | 184 |
2183960 | 2183960 | 2022-02-05 | Chilton | Alabama | 1021 | 10193 | 184 |
2180708 | 2180708 | 2022-02-04 | Chilton | Alabama | 1021 | 10173 | 184 |
2177457 | 2177457 | 2022-02-03 | Chilton | Alabama | 1021 | 10040 | 183 |
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);