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

782 rows where county = "Harris", fips = 13145 and state = "Georgia" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Georgia · 782 ✖

fips 1

  • 13145 · 782 ✖

county 1

  • Harris · 782 ✖
Link rowid date ▲ county state fips cases deaths
2500037 2500037 2022-05-13 Harris Georgia 13145 6095 113
2496779 2496779 2022-05-12 Harris Georgia 13145 6095 113
2493521 2493521 2022-05-11 Harris Georgia 13145 6095 113
2490263 2490263 2022-05-10 Harris Georgia 13145 6090 113
2487006 2487006 2022-05-09 Harris Georgia 13145 6090 113
2483748 2483748 2022-05-08 Harris Georgia 13145 6090 113
2480490 2480490 2022-05-07 Harris Georgia 13145 6090 113
2477232 2477232 2022-05-06 Harris Georgia 13145 6090 113
2473974 2473974 2022-05-05 Harris Georgia 13145 6090 113
2470717 2470717 2022-05-04 Harris Georgia 13145 6090 113
2467461 2467461 2022-05-03 Harris Georgia 13145 6083 112
2464206 2464206 2022-05-02 Harris Georgia 13145 6083 112
2460950 2460950 2022-05-01 Harris Georgia 13145 6082 112
2457694 2457694 2022-04-30 Harris Georgia 13145 6082 112
2454438 2454438 2022-04-29 Harris Georgia 13145 6082 112
2451182 2451182 2022-04-28 Harris Georgia 13145 6082 112
2447926 2447926 2022-04-27 Harris Georgia 13145 6082 112
2444670 2444670 2022-04-26 Harris Georgia 13145 6080 112
2441414 2441414 2022-04-25 Harris Georgia 13145 6080 112
2438158 2438158 2022-04-24 Harris Georgia 13145 6080 112
2434902 2434902 2022-04-23 Harris Georgia 13145 6080 112
2431646 2431646 2022-04-22 Harris Georgia 13145 6080 112
2428390 2428390 2022-04-21 Harris Georgia 13145 6080 112
2425134 2425134 2022-04-20 Harris Georgia 13145 6080 112
2421878 2421878 2022-04-19 Harris Georgia 13145 6079 112
2418622 2418622 2022-04-18 Harris Georgia 13145 6079 112
2415366 2415366 2022-04-17 Harris Georgia 13145 6079 112
2412110 2412110 2022-04-16 Harris Georgia 13145 6079 112
2408854 2408854 2022-04-15 Harris Georgia 13145 6079 112
2405598 2405598 2022-04-14 Harris Georgia 13145 6079 112
2402343 2402343 2022-04-13 Harris Georgia 13145 6076 112
2399088 2399088 2022-04-12 Harris Georgia 13145 6077 112
2395833 2395833 2022-04-11 Harris Georgia 13145 6073 112
2392577 2392577 2022-04-10 Harris Georgia 13145 6072 112
2389321 2389321 2022-04-09 Harris Georgia 13145 6072 112
2386066 2386066 2022-04-08 Harris Georgia 13145 6072 112
2382811 2382811 2022-04-07 Harris Georgia 13145 6071 112
2379556 2379556 2022-04-06 Harris Georgia 13145 6071 112
2376302 2376302 2022-04-05 Harris Georgia 13145 6071 112
2373050 2373050 2022-04-04 Harris Georgia 13145 6067 112
2369797 2369797 2022-04-03 Harris Georgia 13145 6064 112
2366544 2366544 2022-04-02 Harris Georgia 13145 6064 112
2363291 2363291 2022-04-01 Harris Georgia 13145 6064 112
2360037 2360037 2022-03-31 Harris Georgia 13145 6064 111
2356783 2356783 2022-03-30 Harris Georgia 13145 6057 111
2353530 2353530 2022-03-29 Harris Georgia 13145 6053 111
2350278 2350278 2022-03-28 Harris Georgia 13145 6052 110
2347025 2347025 2022-03-27 Harris Georgia 13145 6051 110
2343772 2343772 2022-03-26 Harris Georgia 13145 6051 110
2340519 2340519 2022-03-25 Harris Georgia 13145 6051 110
2337266 2337266 2022-03-24 Harris Georgia 13145 6050 110
2334012 2334012 2022-03-23 Harris Georgia 13145 6049 110
2330758 2330758 2022-03-22 Harris Georgia 13145 6048 110
2327506 2327506 2022-03-21 Harris Georgia 13145 6047 110
2324253 2324253 2022-03-20 Harris Georgia 13145 6045 110
2320999 2320999 2022-03-19 Harris Georgia 13145 6045 110
2317745 2317745 2022-03-18 Harris Georgia 13145 6045 110
2314492 2314492 2022-03-17 Harris Georgia 13145 6045 110
2311239 2311239 2022-03-16 Harris Georgia 13145 6044 110
2307986 2307986 2022-03-15 Harris Georgia 13145 6043 110
2304735 2304735 2022-03-14 Harris Georgia 13145 6040 110
2301483 2301483 2022-03-13 Harris Georgia 13145 6038 110
2298231 2298231 2022-03-12 Harris Georgia 13145 6038 110
2294979 2294979 2022-03-11 Harris Georgia 13145 6038 110
2291727 2291727 2022-03-10 Harris Georgia 13145 6035 109
2288475 2288475 2022-03-09 Harris Georgia 13145 6033 107
2285224 2285224 2022-03-08 Harris Georgia 13145 6031 107
2281972 2281972 2022-03-07 Harris Georgia 13145 6031 107
2278719 2278719 2022-03-06 Harris Georgia 13145 6030 107
2275466 2275466 2022-03-05 Harris Georgia 13145 6030 107
2272213 2272213 2022-03-04 Harris Georgia 13145 6030 107
2268961 2268961 2022-03-03 Harris Georgia 13145 6030 107
2265708 2265708 2022-03-02 Harris Georgia 13145 6025 107
2262457 2262457 2022-03-01 Harris Georgia 13145 6024 107
2259206 2259206 2022-02-28 Harris Georgia 13145 6021 106
2255955 2255955 2022-02-27 Harris Georgia 13145 6017 106
2252704 2252704 2022-02-26 Harris Georgia 13145 6017 106
2249453 2249453 2022-02-25 Harris Georgia 13145 6017 106
2246202 2246202 2022-02-24 Harris Georgia 13145 6015 106
2242951 2242951 2022-02-23 Harris Georgia 13145 6012 105
2239700 2239700 2022-02-22 Harris Georgia 13145 6009 104
2236449 2236449 2022-02-21 Harris Georgia 13145 6008 104
2233198 2233198 2022-02-20 Harris Georgia 13145 6003 103
2229947 2229947 2022-02-19 Harris Georgia 13145 6003 103
2226696 2226696 2022-02-18 Harris Georgia 13145 6003 103
2223445 2223445 2022-02-17 Harris Georgia 13145 5998 103
2220194 2220194 2022-02-16 Harris Georgia 13145 5990 101
2216943 2216943 2022-02-15 Harris Georgia 13145 5982 101
2213692 2213692 2022-02-14 Harris Georgia 13145 5966 100
2210440 2210440 2022-02-13 Harris Georgia 13145 5953 100
2207187 2207187 2022-02-12 Harris Georgia 13145 5953 100
2203934 2203934 2022-02-11 Harris Georgia 13145 5953 100
2200681 2200681 2022-02-10 Harris Georgia 13145 5948 100
2197427 2197427 2022-02-09 Harris Georgia 13145 5937 100
2194173 2194173 2022-02-08 Harris Georgia 13145 5921 100
2190919 2190919 2022-02-07 Harris Georgia 13145 5903 100
2187666 2187666 2022-02-06 Harris Georgia 13145 5879 99
2184413 2184413 2022-02-05 Harris Georgia 13145 5879 99
2181161 2181161 2022-02-04 Harris Georgia 13145 5879 99
2177910 2177910 2022-02-03 Harris Georgia 13145 5860 99

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