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

779 rows where county = "Randolph" and fips = 5121 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 5121 · 779 ✖

county 1

  • Randolph · 779 ✖
Link rowid date ▲ county state fips cases deaths
2499746 2499746 2022-05-13 Randolph Arkansas 5121 5217 89
2496488 2496488 2022-05-12 Randolph Arkansas 5121 5215 89
2493230 2493230 2022-05-11 Randolph Arkansas 5121 5213 89
2489972 2489972 2022-05-10 Randolph Arkansas 5121 5210 89
2486715 2486715 2022-05-09 Randolph Arkansas 5121 5208 89
2483457 2483457 2022-05-08 Randolph Arkansas 5121 5208 89
2480199 2480199 2022-05-07 Randolph Arkansas 5121 5205 89
2476941 2476941 2022-05-06 Randolph Arkansas 5121 5205 89
2473683 2473683 2022-05-05 Randolph Arkansas 5121 5198 89
2470426 2470426 2022-05-04 Randolph Arkansas 5121 5196 89
2467170 2467170 2022-05-03 Randolph Arkansas 5121 5195 89
2463915 2463915 2022-05-02 Randolph Arkansas 5121 5194 89
2460659 2460659 2022-05-01 Randolph Arkansas 5121 5194 89
2457403 2457403 2022-04-30 Randolph Arkansas 5121 5194 89
2454147 2454147 2022-04-29 Randolph Arkansas 5121 5193 89
2450891 2450891 2022-04-28 Randolph Arkansas 5121 5191 89
2447635 2447635 2022-04-27 Randolph Arkansas 5121 5189 88
2444379 2444379 2022-04-26 Randolph Arkansas 5121 5188 88
2441123 2441123 2022-04-25 Randolph Arkansas 5121 5186 88
2437867 2437867 2022-04-24 Randolph Arkansas 5121 5186 88
2434611 2434611 2022-04-23 Randolph Arkansas 5121 5186 88
2431355 2431355 2022-04-22 Randolph Arkansas 5121 5184 88
2428099 2428099 2022-04-21 Randolph Arkansas 5121 5182 88
2424843 2424843 2022-04-20 Randolph Arkansas 5121 5182 88
2421587 2421587 2022-04-19 Randolph Arkansas 5121 5183 88
2418331 2418331 2022-04-18 Randolph Arkansas 5121 5183 88
2415075 2415075 2022-04-17 Randolph Arkansas 5121 5182 88
2411819 2411819 2022-04-16 Randolph Arkansas 5121 5182 87
2408563 2408563 2022-04-15 Randolph Arkansas 5121 5182 87
2405307 2405307 2022-04-14 Randolph Arkansas 5121 5180 87
2402052 2402052 2022-04-13 Randolph Arkansas 5121 5178 87
2398797 2398797 2022-04-12 Randolph Arkansas 5121 5178 87
2395542 2395542 2022-04-11 Randolph Arkansas 5121 5176 87
2392286 2392286 2022-04-10 Randolph Arkansas 5121 5176 87
2389030 2389030 2022-04-09 Randolph Arkansas 5121 5176 87
2385775 2385775 2022-04-08 Randolph Arkansas 5121 5176 87
2382520 2382520 2022-04-07 Randolph Arkansas 5121 5176 87
2379265 2379265 2022-04-06 Randolph Arkansas 5121 5172 87
2376011 2376011 2022-04-05 Randolph Arkansas 5121 5172 87
2372759 2372759 2022-04-04 Randolph Arkansas 5121 5170 86
2369506 2369506 2022-04-03 Randolph Arkansas 5121 5170 86
2366253 2366253 2022-04-02 Randolph Arkansas 5121 5170 85
2363000 2363000 2022-04-01 Randolph Arkansas 5121 5170 84
2359746 2359746 2022-03-31 Randolph Arkansas 5121 5169 83
2356492 2356492 2022-03-30 Randolph Arkansas 5121 5169 83
2353239 2353239 2022-03-29 Randolph Arkansas 5121 5167 83
2349987 2349987 2022-03-28 Randolph Arkansas 5121 5165 83
2346734 2346734 2022-03-27 Randolph Arkansas 5121 5165 83
2343481 2343481 2022-03-26 Randolph Arkansas 5121 5165 83
2340228 2340228 2022-03-25 Randolph Arkansas 5121 5164 83
2336975 2336975 2022-03-24 Randolph Arkansas 5121 5163 83
2333721 2333721 2022-03-23 Randolph Arkansas 5121 5159 83
2330467 2330467 2022-03-22 Randolph Arkansas 5121 5156 83
2327215 2327215 2022-03-21 Randolph Arkansas 5121 5138 83
2323962 2323962 2022-03-20 Randolph Arkansas 5121 5131 82
2320708 2320708 2022-03-19 Randolph Arkansas 5121 5123 81
2317454 2317454 2022-03-18 Randolph Arkansas 5121 5099 82
2314201 2314201 2022-03-17 Randolph Arkansas 5121 5076 82
2310948 2310948 2022-03-16 Randolph Arkansas 5121 5071 82
2307695 2307695 2022-03-15 Randolph Arkansas 5121 5061 81
2304444 2304444 2022-03-14 Randolph Arkansas 5121 5054 81
2301192 2301192 2022-03-13 Randolph Arkansas 5121 5038 81
2297940 2297940 2022-03-12 Randolph Arkansas 5121 4986 80
2294688 2294688 2022-03-11 Randolph Arkansas 5121 4982 80
2291436 2291436 2022-03-10 Randolph Arkansas 5121 4964 80
2288184 2288184 2022-03-09 Randolph Arkansas 5121 4961 80
2284933 2284933 2022-03-08 Randolph Arkansas 5121 4946 80
2281681 2281681 2022-03-07 Randolph Arkansas 5121 4944 80
2278428 2278428 2022-03-06 Randolph Arkansas 5121 4939 80
2275175 2275175 2022-03-05 Randolph Arkansas 5121 4913 80
2271922 2271922 2022-03-04 Randolph Arkansas 5121 4903 80
2268670 2268670 2022-03-03 Randolph Arkansas 5121 4894 80
2265417 2265417 2022-03-02 Randolph Arkansas 5121 4892 80
2262166 2262166 2022-03-01 Randolph Arkansas 5121 4868 80
2258915 2258915 2022-02-28 Randolph Arkansas 5121 4866 80
2255664 2255664 2022-02-27 Randolph Arkansas 5121 4841 80
2252413 2252413 2022-02-26 Randolph Arkansas 5121 4839 80
2249162 2249162 2022-02-25 Randolph Arkansas 5121 4832 79
2245911 2245911 2022-02-24 Randolph Arkansas 5121 4832 79
2242660 2242660 2022-02-23 Randolph Arkansas 5121 4831 79
2239409 2239409 2022-02-22 Randolph Arkansas 5121 4830 78
2236158 2236158 2022-02-21 Randolph Arkansas 5121 4826 78
2232907 2232907 2022-02-20 Randolph Arkansas 5121 4821 78
2229656 2229656 2022-02-19 Randolph Arkansas 5121 4814 78
2226405 2226405 2022-02-18 Randolph Arkansas 5121 4813 77
2223154 2223154 2022-02-17 Randolph Arkansas 5121 4806 77
2219903 2219903 2022-02-16 Randolph Arkansas 5121 4799 75
2216652 2216652 2022-02-15 Randolph Arkansas 5121 4797 74
2213401 2213401 2022-02-14 Randolph Arkansas 5121 4790 73
2210149 2210149 2022-02-13 Randolph Arkansas 5121 4786 73
2206896 2206896 2022-02-12 Randolph Arkansas 5121 4773 73
2203643 2203643 2022-02-11 Randolph Arkansas 5121 4766 73
2200390 2200390 2022-02-10 Randolph Arkansas 5121 4749 73
2197136 2197136 2022-02-09 Randolph Arkansas 5121 4742 73
2193881 2193881 2022-02-08 Randolph Arkansas 5121 4737 73
2190628 2190628 2022-02-07 Randolph Arkansas 5121 4725 73
2187375 2187375 2022-02-06 Randolph Arkansas 5121 4716 73
2184122 2184122 2022-02-05 Randolph Arkansas 5121 4706 73
2180870 2180870 2022-02-04 Randolph Arkansas 5121 4705 73
2177619 2177619 2022-02-03 Randolph Arkansas 5121 4702 73

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