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

780 rows where county = "Cherokee" and state = "Alabama" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Alabama · 780 ✖

fips 1

county 1

  • Cherokee · 780 ✖
Link rowid date ▲ county state fips cases deaths
2499584 2499584 2022-05-13 Cherokee Alabama 1019 5131 86
2496326 2496326 2022-05-12 Cherokee Alabama 1019 5131 86
2493068 2493068 2022-05-11 Cherokee Alabama 1019 5134 86
2489810 2489810 2022-05-10 Cherokee Alabama 1019 5130 86
2486553 2486553 2022-05-09 Cherokee Alabama 1019 5128 86
2483295 2483295 2022-05-08 Cherokee Alabama 1019 5127 86
2480037 2480037 2022-05-07 Cherokee Alabama 1019 5127 86
2476779 2476779 2022-05-06 Cherokee Alabama 1019 5127 86
2473521 2473521 2022-05-05 Cherokee Alabama 1019 5126 86
2470264 2470264 2022-05-04 Cherokee Alabama 1019 5126 86
2467008 2467008 2022-05-03 Cherokee Alabama 1019 5126 86
2463753 2463753 2022-05-02 Cherokee Alabama 1019 5125 86
2460497 2460497 2022-05-01 Cherokee Alabama 1019 5126 86
2457241 2457241 2022-04-30 Cherokee Alabama 1019 5126 86
2453985 2453985 2022-04-29 Cherokee Alabama 1019 5126 86
2450729 2450729 2022-04-28 Cherokee Alabama 1019 5126 86
2447473 2447473 2022-04-27 Cherokee Alabama 1019 5125 86
2444217 2444217 2022-04-26 Cherokee Alabama 1019 5125 86
2440961 2440961 2022-04-25 Cherokee Alabama 1019 5124 86
2437705 2437705 2022-04-24 Cherokee Alabama 1019 5124 86
2434449 2434449 2022-04-23 Cherokee Alabama 1019 5124 86
2431193 2431193 2022-04-22 Cherokee Alabama 1019 5124 86
2427937 2427937 2022-04-21 Cherokee Alabama 1019 5124 86
2424681 2424681 2022-04-20 Cherokee Alabama 1019 5124 86
2421425 2421425 2022-04-19 Cherokee Alabama 1019 5122 86
2418169 2418169 2022-04-18 Cherokee Alabama 1019 5120 86
2414913 2414913 2022-04-17 Cherokee Alabama 1019 5120 86
2411657 2411657 2022-04-16 Cherokee Alabama 1019 5120 86
2408401 2408401 2022-04-15 Cherokee Alabama 1019 5120 86
2405145 2405145 2022-04-14 Cherokee Alabama 1019 5118 86
2401890 2401890 2022-04-13 Cherokee Alabama 1019 5116 85
2398635 2398635 2022-04-12 Cherokee Alabama 1019 5116 85
2395380 2395380 2022-04-11 Cherokee Alabama 1019 5116 85
2392124 2392124 2022-04-10 Cherokee Alabama 1019 5115 85
2388868 2388868 2022-04-09 Cherokee Alabama 1019 5115 85
2385613 2385613 2022-04-08 Cherokee Alabama 1019 5115 85
2382358 2382358 2022-04-07 Cherokee Alabama 1019 5114 85
2379103 2379103 2022-04-06 Cherokee Alabama 1019 5113 85
2375849 2375849 2022-04-05 Cherokee Alabama 1019 5112 85
2372597 2372597 2022-04-04 Cherokee Alabama 1019 5112 85
2369344 2369344 2022-04-03 Cherokee Alabama 1019 5110 85
2366091 2366091 2022-04-02 Cherokee Alabama 1019 5110 85
2362838 2362838 2022-04-01 Cherokee Alabama 1019 5110 85
2359584 2359584 2022-03-31 Cherokee Alabama 1019 5112 85
2356330 2356330 2022-03-30 Cherokee Alabama 1019 5111 85
2353077 2353077 2022-03-29 Cherokee Alabama 1019 5110 85
2349825 2349825 2022-03-28 Cherokee Alabama 1019 5108 85
2346572 2346572 2022-03-27 Cherokee Alabama 1019 5107 85
2343319 2343319 2022-03-26 Cherokee Alabama 1019 5107 85
2340066 2340066 2022-03-25 Cherokee Alabama 1019 5107 85
2336813 2336813 2022-03-24 Cherokee Alabama 1019 5109 85
2333559 2333559 2022-03-23 Cherokee Alabama 1019 5108 85
2330305 2330305 2022-03-22 Cherokee Alabama 1019 5108 85
2327053 2327053 2022-03-21 Cherokee Alabama 1019 5108 85
2323800 2323800 2022-03-20 Cherokee Alabama 1019 5109 84
2320546 2320546 2022-03-19 Cherokee Alabama 1019 5109 84
2317292 2317292 2022-03-18 Cherokee Alabama 1019 5109 84
2314039 2314039 2022-03-17 Cherokee Alabama 1019 5108 84
2310786 2310786 2022-03-16 Cherokee Alabama 1019 5106 81
2307533 2307533 2022-03-15 Cherokee Alabama 1019 5105 81
2304282 2304282 2022-03-14 Cherokee Alabama 1019 5105 81
2301030 2301030 2022-03-13 Cherokee Alabama 1019 5103 81
2297778 2297778 2022-03-12 Cherokee Alabama 1019 5103 81
2294526 2294526 2022-03-11 Cherokee Alabama 1019 5103 81
2291274 2291274 2022-03-10 Cherokee Alabama 1019 5102 81
2288022 2288022 2022-03-09 Cherokee Alabama 1019 5102 81
2284770 2284770 2022-03-08 Cherokee Alabama 1019 5097 81
2281518 2281518 2022-03-07 Cherokee Alabama 1019 5093 80
2278265 2278265 2022-03-06 Cherokee Alabama 1019 5090 79
2275012 2275012 2022-03-05 Cherokee Alabama 1019 5090 79
2271759 2271759 2022-03-04 Cherokee Alabama 1019 5090 79
2268507 2268507 2022-03-03 Cherokee Alabama 1019 5090 79
2265254 2265254 2022-03-02 Cherokee Alabama 1019 5088 79
2262004 2262004 2022-03-01 Cherokee Alabama 1019 5086 78
2258753 2258753 2022-02-28 Cherokee Alabama 1019 5074 78
2255502 2255502 2022-02-27 Cherokee Alabama 1019 5074 78
2252251 2252251 2022-02-26 Cherokee Alabama 1019 5073 78
2249000 2249000 2022-02-25 Cherokee Alabama 1019 5071 78
2245749 2245749 2022-02-24 Cherokee Alabama 1019 5066 77
2242498 2242498 2022-02-23 Cherokee Alabama 1019 5062 77
2239247 2239247 2022-02-22 Cherokee Alabama 1019 5058 77
2235996 2235996 2022-02-21 Cherokee Alabama 1019 5053 77
2232745 2232745 2022-02-20 Cherokee Alabama 1019 5050 77
2229494 2229494 2022-02-19 Cherokee Alabama 1019 5044 77
2226243 2226243 2022-02-18 Cherokee Alabama 1019 5039 77
2222992 2222992 2022-02-17 Cherokee Alabama 1019 5032 77
2219741 2219741 2022-02-16 Cherokee Alabama 1019 5023 77
2216491 2216491 2022-02-15 Cherokee Alabama 1019 5017 74
2213240 2213240 2022-02-14 Cherokee Alabama 1019 5007 74
2209987 2209987 2022-02-13 Cherokee Alabama 1019 5005 74
2206734 2206734 2022-02-12 Cherokee Alabama 1019 4998 74
2203481 2203481 2022-02-11 Cherokee Alabama 1019 4989 72
2200227 2200227 2022-02-10 Cherokee Alabama 1019 4981 72
2196973 2196973 2022-02-09 Cherokee Alabama 1019 4969 70
2193718 2193718 2022-02-08 Cherokee Alabama 1019 4951 70
2190465 2190465 2022-02-07 Cherokee Alabama 1019 4930 70
2187212 2187212 2022-02-06 Cherokee Alabama 1019 4920 69
2183959 2183959 2022-02-05 Cherokee Alabama 1019 4920 69
2180707 2180707 2022-02-04 Cherokee Alabama 1019 4910 69
2177456 2177456 2022-02-03 Cherokee Alabama 1019 4869 69

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