ny_times_us_counties

Table actions
⚠️ Consult the README for warnings about using and building on this data. Also review Why It’s So Freaking Hard To Make A Good COVID-19 Model and Ten Considerations Before You Create Another Chart About COVID-19.

Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette

1,555 rows where county = "Elbert" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 2

fips 2

county 1

  • Elbert · 1,555 ✖
Link rowid date ▲ county state fips cases deaths
2499841 2499841 2022-05-13 Elbert Colorado 8039 4880 40
2500017 2500017 2022-05-13 Elbert Georgia 13105 4558 109
2496583 2496583 2022-05-12 Elbert Colorado 8039 4874 40
2496759 2496759 2022-05-12 Elbert Georgia 13105 4558 109
2493325 2493325 2022-05-11 Elbert Colorado 8039 4834 40
2493501 2493501 2022-05-11 Elbert Georgia 13105 4558 109
2490067 2490067 2022-05-10 Elbert Colorado 8039 4831 40
2490243 2490243 2022-05-10 Elbert Georgia 13105 4552 109
2486810 2486810 2022-05-09 Elbert Colorado 8039 4826 40
2486986 2486986 2022-05-09 Elbert Georgia 13105 4552 109
2483552 2483552 2022-05-08 Elbert Colorado 8039 4824 40
2483728 2483728 2022-05-08 Elbert Georgia 13105 4553 109
2480294 2480294 2022-05-07 Elbert Colorado 8039 4824 40
2480470 2480470 2022-05-07 Elbert Georgia 13105 4553 109
2477036 2477036 2022-05-06 Elbert Colorado 8039 4824 40
2477212 2477212 2022-05-06 Elbert Georgia 13105 4553 109
2473778 2473778 2022-05-05 Elbert Colorado 8039 4822 40
2473954 2473954 2022-05-05 Elbert Georgia 13105 4553 109
2470521 2470521 2022-05-04 Elbert Colorado 8039 4817 40
2470697 2470697 2022-05-04 Elbert Georgia 13105 4553 109
2467265 2467265 2022-05-03 Elbert Colorado 8039 4816 40
2467441 2467441 2022-05-03 Elbert Georgia 13105 4556 108
2464010 2464010 2022-05-02 Elbert Colorado 8039 4814 39
2464186 2464186 2022-05-02 Elbert Georgia 13105 4556 108
2460754 2460754 2022-05-01 Elbert Colorado 8039 4813 39
2460930 2460930 2022-05-01 Elbert Georgia 13105 4557 108
2457498 2457498 2022-04-30 Elbert Colorado 8039 4813 39
2457674 2457674 2022-04-30 Elbert Georgia 13105 4557 108
2454242 2454242 2022-04-29 Elbert Colorado 8039 4813 39
2454418 2454418 2022-04-29 Elbert Georgia 13105 4557 108
2450986 2450986 2022-04-28 Elbert Colorado 8039 4813 39
2451162 2451162 2022-04-28 Elbert Georgia 13105 4557 108
2447730 2447730 2022-04-27 Elbert Colorado 8039 4810 39
2447906 2447906 2022-04-27 Elbert Georgia 13105 4557 108
2444474 2444474 2022-04-26 Elbert Colorado 8039 4809 39
2444650 2444650 2022-04-26 Elbert Georgia 13105 4554 108
2441218 2441218 2022-04-25 Elbert Colorado 8039 4806 39
2441394 2441394 2022-04-25 Elbert Georgia 13105 4554 108
2437962 2437962 2022-04-24 Elbert Colorado 8039 4800 39
2438138 2438138 2022-04-24 Elbert Georgia 13105 4554 108
2434706 2434706 2022-04-23 Elbert Colorado 8039 4800 39
2434882 2434882 2022-04-23 Elbert Georgia 13105 4554 108
2431450 2431450 2022-04-22 Elbert Colorado 8039 4800 39
2431626 2431626 2022-04-22 Elbert Georgia 13105 4554 108
2428194 2428194 2022-04-21 Elbert Colorado 8039 4798 39
2428370 2428370 2022-04-21 Elbert Georgia 13105 4554 108
2424938 2424938 2022-04-20 Elbert Colorado 8039 4793 37
2425114 2425114 2022-04-20 Elbert Georgia 13105 4554 108
2421682 2421682 2022-04-19 Elbert Colorado 8039 4785 37
2421858 2421858 2022-04-19 Elbert Georgia 13105 4556 108
2418426 2418426 2022-04-18 Elbert Colorado 8039 4785 37
2418602 2418602 2022-04-18 Elbert Georgia 13105 4556 108
2415170 2415170 2022-04-17 Elbert Colorado 8039 4775 37
2415346 2415346 2022-04-17 Elbert Georgia 13105 4556 108
2411914 2411914 2022-04-16 Elbert Colorado 8039 4775 37
2412090 2412090 2022-04-16 Elbert Georgia 13105 4556 108
2408658 2408658 2022-04-15 Elbert Colorado 8039 4775 37
2408834 2408834 2022-04-15 Elbert Georgia 13105 4556 108
2405402 2405402 2022-04-14 Elbert Colorado 8039 4770 37
2405578 2405578 2022-04-14 Elbert Georgia 13105 4556 108
2402147 2402147 2022-04-13 Elbert Colorado 8039 4764 37
2402323 2402323 2022-04-13 Elbert Georgia 13105 4556 108
2398892 2398892 2022-04-12 Elbert Colorado 8039 4763 37
2399068 2399068 2022-04-12 Elbert Georgia 13105 4557 108
2395637 2395637 2022-04-11 Elbert Colorado 8039 4762 37
2395813 2395813 2022-04-11 Elbert Georgia 13105 4556 108
2392381 2392381 2022-04-10 Elbert Colorado 8039 4752 37
2392557 2392557 2022-04-10 Elbert Georgia 13105 4556 108
2389125 2389125 2022-04-09 Elbert Colorado 8039 4752 37
2389301 2389301 2022-04-09 Elbert Georgia 13105 4556 108
2385870 2385870 2022-04-08 Elbert Colorado 8039 4752 37
2386046 2386046 2022-04-08 Elbert Georgia 13105 4556 108
2382615 2382615 2022-04-07 Elbert Colorado 8039 4748 37
2382791 2382791 2022-04-07 Elbert Georgia 13105 4554 108
2379360 2379360 2022-04-06 Elbert Colorado 8039 4745 37
2379536 2379536 2022-04-06 Elbert Georgia 13105 4554 108
2376106 2376106 2022-04-05 Elbert Colorado 8039 4741 37
2376282 2376282 2022-04-05 Elbert Georgia 13105 4554 108
2372854 2372854 2022-04-04 Elbert Colorado 8039 4740 37
2373030 2373030 2022-04-04 Elbert Georgia 13105 4555 108
2369601 2369601 2022-04-03 Elbert Colorado 8039 4739 37
2369777 2369777 2022-04-03 Elbert Georgia 13105 4554 108
2366348 2366348 2022-04-02 Elbert Colorado 8039 4739 37
2366524 2366524 2022-04-02 Elbert Georgia 13105 4554 108
2363095 2363095 2022-04-01 Elbert Colorado 8039 4739 37
2363271 2363271 2022-04-01 Elbert Georgia 13105 4554 108
2359841 2359841 2022-03-31 Elbert Colorado 8039 4734 37
2360017 2360017 2022-03-31 Elbert Georgia 13105 4554 108
2356587 2356587 2022-03-30 Elbert Colorado 8039 4729 37
2356763 2356763 2022-03-30 Elbert Georgia 13105 4554 108
2353334 2353334 2022-03-29 Elbert Colorado 8039 4723 37
2353510 2353510 2022-03-29 Elbert Georgia 13105 4554 108
2350082 2350082 2022-03-28 Elbert Colorado 8039 4718 37
2350258 2350258 2022-03-28 Elbert Georgia 13105 4553 108
2346829 2346829 2022-03-27 Elbert Colorado 8039 4716 37
2347005 2347005 2022-03-27 Elbert Georgia 13105 4553 108
2343576 2343576 2022-03-26 Elbert Colorado 8039 4716 37
2343752 2343752 2022-03-26 Elbert Georgia 13105 4553 108
2340323 2340323 2022-03-25 Elbert Colorado 8039 4716 37
2340499 2340499 2022-03-25 Elbert Georgia 13105 4553 108

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);