ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
786 rows where fips = 1017 and state = "Alabama" 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 |
---|---|---|---|---|---|---|---|
2499583 | 2499583 | 2022-05-13 | Chambers | Alabama | 1017 | 8508 | 162 |
2496325 | 2496325 | 2022-05-12 | Chambers | Alabama | 1017 | 8506 | 162 |
2493067 | 2493067 | 2022-05-11 | Chambers | Alabama | 1017 | 8505 | 162 |
2489809 | 2489809 | 2022-05-10 | Chambers | Alabama | 1017 | 8503 | 162 |
2486552 | 2486552 | 2022-05-09 | Chambers | Alabama | 1017 | 8495 | 162 |
2483294 | 2483294 | 2022-05-08 | Chambers | Alabama | 1017 | 8492 | 162 |
2480036 | 2480036 | 2022-05-07 | Chambers | Alabama | 1017 | 8492 | 162 |
2476778 | 2476778 | 2022-05-06 | Chambers | Alabama | 1017 | 8492 | 162 |
2473520 | 2473520 | 2022-05-05 | Chambers | Alabama | 1017 | 8492 | 162 |
2470263 | 2470263 | 2022-05-04 | Chambers | Alabama | 1017 | 8490 | 162 |
2467007 | 2467007 | 2022-05-03 | Chambers | Alabama | 1017 | 8490 | 162 |
2463752 | 2463752 | 2022-05-02 | Chambers | Alabama | 1017 | 8487 | 162 |
2460496 | 2460496 | 2022-05-01 | Chambers | Alabama | 1017 | 8486 | 162 |
2457240 | 2457240 | 2022-04-30 | Chambers | Alabama | 1017 | 8486 | 162 |
2453984 | 2453984 | 2022-04-29 | Chambers | Alabama | 1017 | 8486 | 162 |
2450728 | 2450728 | 2022-04-28 | Chambers | Alabama | 1017 | 8486 | 162 |
2447472 | 2447472 | 2022-04-27 | Chambers | Alabama | 1017 | 8484 | 162 |
2444216 | 2444216 | 2022-04-26 | Chambers | Alabama | 1017 | 8483 | 162 |
2440960 | 2440960 | 2022-04-25 | Chambers | Alabama | 1017 | 8483 | 162 |
2437704 | 2437704 | 2022-04-24 | Chambers | Alabama | 1017 | 8483 | 162 |
2434448 | 2434448 | 2022-04-23 | Chambers | Alabama | 1017 | 8483 | 162 |
2431192 | 2431192 | 2022-04-22 | Chambers | Alabama | 1017 | 8483 | 162 |
2427936 | 2427936 | 2022-04-21 | Chambers | Alabama | 1017 | 8482 | 162 |
2424680 | 2424680 | 2022-04-20 | Chambers | Alabama | 1017 | 8480 | 162 |
2421424 | 2421424 | 2022-04-19 | Chambers | Alabama | 1017 | 8480 | 162 |
2418168 | 2418168 | 2022-04-18 | Chambers | Alabama | 1017 | 8478 | 162 |
2414912 | 2414912 | 2022-04-17 | Chambers | Alabama | 1017 | 8478 | 162 |
2411656 | 2411656 | 2022-04-16 | Chambers | Alabama | 1017 | 8478 | 162 |
2408400 | 2408400 | 2022-04-15 | Chambers | Alabama | 1017 | 8478 | 162 |
2405144 | 2405144 | 2022-04-14 | Chambers | Alabama | 1017 | 8477 | 162 |
2401889 | 2401889 | 2022-04-13 | Chambers | Alabama | 1017 | 8476 | 162 |
2398634 | 2398634 | 2022-04-12 | Chambers | Alabama | 1017 | 8476 | 161 |
2395379 | 2395379 | 2022-04-11 | Chambers | Alabama | 1017 | 8474 | 161 |
2392123 | 2392123 | 2022-04-10 | Chambers | Alabama | 1017 | 8471 | 161 |
2388867 | 2388867 | 2022-04-09 | Chambers | Alabama | 1017 | 8471 | 161 |
2385612 | 2385612 | 2022-04-08 | Chambers | Alabama | 1017 | 8471 | 161 |
2382357 | 2382357 | 2022-04-07 | Chambers | Alabama | 1017 | 8471 | 161 |
2379102 | 2379102 | 2022-04-06 | Chambers | Alabama | 1017 | 8469 | 161 |
2375848 | 2375848 | 2022-04-05 | Chambers | Alabama | 1017 | 8469 | 161 |
2372596 | 2372596 | 2022-04-04 | Chambers | Alabama | 1017 | 8469 | 161 |
2369343 | 2369343 | 2022-04-03 | Chambers | Alabama | 1017 | 8468 | 161 |
2366090 | 2366090 | 2022-04-02 | Chambers | Alabama | 1017 | 8468 | 161 |
2362837 | 2362837 | 2022-04-01 | Chambers | Alabama | 1017 | 8468 | 161 |
2359583 | 2359583 | 2022-03-31 | Chambers | Alabama | 1017 | 8468 | 161 |
2356329 | 2356329 | 2022-03-30 | Chambers | Alabama | 1017 | 8468 | 161 |
2353076 | 2353076 | 2022-03-29 | Chambers | Alabama | 1017 | 8467 | 161 |
2349824 | 2349824 | 2022-03-28 | Chambers | Alabama | 1017 | 8465 | 161 |
2346571 | 2346571 | 2022-03-27 | Chambers | Alabama | 1017 | 8464 | 161 |
2343318 | 2343318 | 2022-03-26 | Chambers | Alabama | 1017 | 8464 | 161 |
2340065 | 2340065 | 2022-03-25 | Chambers | Alabama | 1017 | 8464 | 161 |
2336812 | 2336812 | 2022-03-24 | Chambers | Alabama | 1017 | 8464 | 160 |
2333558 | 2333558 | 2022-03-23 | Chambers | Alabama | 1017 | 8463 | 160 |
2330304 | 2330304 | 2022-03-22 | Chambers | Alabama | 1017 | 8463 | 160 |
2327052 | 2327052 | 2022-03-21 | Chambers | Alabama | 1017 | 8453 | 160 |
2323799 | 2323799 | 2022-03-20 | Chambers | Alabama | 1017 | 8450 | 159 |
2320545 | 2320545 | 2022-03-19 | Chambers | Alabama | 1017 | 8450 | 159 |
2317291 | 2317291 | 2022-03-18 | Chambers | Alabama | 1017 | 8450 | 159 |
2314038 | 2314038 | 2022-03-17 | Chambers | Alabama | 1017 | 8449 | 159 |
2310785 | 2310785 | 2022-03-16 | Chambers | Alabama | 1017 | 8448 | 159 |
2307532 | 2307532 | 2022-03-15 | Chambers | Alabama | 1017 | 8448 | 159 |
2304281 | 2304281 | 2022-03-14 | Chambers | Alabama | 1017 | 8447 | 158 |
2301029 | 2301029 | 2022-03-13 | Chambers | Alabama | 1017 | 8447 | 158 |
2297777 | 2297777 | 2022-03-12 | Chambers | Alabama | 1017 | 8447 | 158 |
2294525 | 2294525 | 2022-03-11 | Chambers | Alabama | 1017 | 8447 | 158 |
2291273 | 2291273 | 2022-03-10 | Chambers | Alabama | 1017 | 8446 | 158 |
2288021 | 2288021 | 2022-03-09 | Chambers | Alabama | 1017 | 8445 | 158 |
2284769 | 2284769 | 2022-03-08 | Chambers | Alabama | 1017 | 8443 | 157 |
2281517 | 2281517 | 2022-03-07 | Chambers | Alabama | 1017 | 8443 | 157 |
2278264 | 2278264 | 2022-03-06 | Chambers | Alabama | 1017 | 8437 | 153 |
2275011 | 2275011 | 2022-03-05 | Chambers | Alabama | 1017 | 8437 | 153 |
2271758 | 2271758 | 2022-03-04 | Chambers | Alabama | 1017 | 8437 | 153 |
2268506 | 2268506 | 2022-03-03 | Chambers | Alabama | 1017 | 8435 | 153 |
2265253 | 2265253 | 2022-03-02 | Chambers | Alabama | 1017 | 8434 | 153 |
2262003 | 2262003 | 2022-03-01 | Chambers | Alabama | 1017 | 8433 | 153 |
2258752 | 2258752 | 2022-02-28 | Chambers | Alabama | 1017 | 8431 | 152 |
2255501 | 2255501 | 2022-02-27 | Chambers | Alabama | 1017 | 8430 | 152 |
2252250 | 2252250 | 2022-02-26 | Chambers | Alabama | 1017 | 8426 | 152 |
2248999 | 2248999 | 2022-02-25 | Chambers | Alabama | 1017 | 8426 | 153 |
2245748 | 2245748 | 2022-02-24 | Chambers | Alabama | 1017 | 8425 | 153 |
2242497 | 2242497 | 2022-02-23 | Chambers | Alabama | 1017 | 8421 | 150 |
2239246 | 2239246 | 2022-02-22 | Chambers | Alabama | 1017 | 8416 | 150 |
2235995 | 2235995 | 2022-02-21 | Chambers | Alabama | 1017 | 8412 | 150 |
2232744 | 2232744 | 2022-02-20 | Chambers | Alabama | 1017 | 8408 | 150 |
2229493 | 2229493 | 2022-02-19 | Chambers | Alabama | 1017 | 8406 | 150 |
2226242 | 2226242 | 2022-02-18 | Chambers | Alabama | 1017 | 8399 | 150 |
2222991 | 2222991 | 2022-02-17 | Chambers | Alabama | 1017 | 8394 | 149 |
2219740 | 2219740 | 2022-02-16 | Chambers | Alabama | 1017 | 8388 | 149 |
2216490 | 2216490 | 2022-02-15 | Chambers | Alabama | 1017 | 8383 | 149 |
2213239 | 2213239 | 2022-02-14 | Chambers | Alabama | 1017 | 8378 | 149 |
2209986 | 2209986 | 2022-02-13 | Chambers | Alabama | 1017 | 8373 | 149 |
2206733 | 2206733 | 2022-02-12 | Chambers | Alabama | 1017 | 8369 | 149 |
2203480 | 2203480 | 2022-02-11 | Chambers | Alabama | 1017 | 8349 | 149 |
2200226 | 2200226 | 2022-02-10 | Chambers | Alabama | 1017 | 8342 | 149 |
2196972 | 2196972 | 2022-02-09 | Chambers | Alabama | 1017 | 8332 | 149 |
2193717 | 2193717 | 2022-02-08 | Chambers | Alabama | 1017 | 8322 | 149 |
2190464 | 2190464 | 2022-02-07 | Chambers | Alabama | 1017 | 8303 | 149 |
2187211 | 2187211 | 2022-02-06 | Chambers | Alabama | 1017 | 8290 | 149 |
2183958 | 2183958 | 2022-02-05 | Chambers | Alabama | 1017 | 8290 | 149 |
2180706 | 2180706 | 2022-02-04 | Chambers | Alabama | 1017 | 8278 | 149 |
2177455 | 2177455 | 2022-02-03 | Chambers | Alabama | 1017 | 8239 | 148 |
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);