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

785 rows where county = "Dawson" 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 · 785 ✖

fips 1

county 1

  • Dawson · 785 ✖
Link rowid date ▲ county state fips cases deaths
2500007 2500007 2022-05-13 Dawson Georgia 13085 6964 101
2496749 2496749 2022-05-12 Dawson Georgia 13085 6964 101
2493491 2493491 2022-05-11 Dawson Georgia 13085 6964 101
2490233 2490233 2022-05-10 Dawson Georgia 13085 6951 101
2486976 2486976 2022-05-09 Dawson Georgia 13085 6951 101
2483718 2483718 2022-05-08 Dawson Georgia 13085 6951 101
2480460 2480460 2022-05-07 Dawson Georgia 13085 6951 101
2477202 2477202 2022-05-06 Dawson Georgia 13085 6951 101
2473944 2473944 2022-05-05 Dawson Georgia 13085 6951 101
2470687 2470687 2022-05-04 Dawson Georgia 13085 6951 101
2467431 2467431 2022-05-03 Dawson Georgia 13085 6947 101
2464176 2464176 2022-05-02 Dawson Georgia 13085 6947 101
2460920 2460920 2022-05-01 Dawson Georgia 13085 6947 101
2457664 2457664 2022-04-30 Dawson Georgia 13085 6947 101
2454408 2454408 2022-04-29 Dawson Georgia 13085 6947 101
2451152 2451152 2022-04-28 Dawson Georgia 13085 6947 101
2447896 2447896 2022-04-27 Dawson Georgia 13085 6947 101
2444640 2444640 2022-04-26 Dawson Georgia 13085 6938 101
2441384 2441384 2022-04-25 Dawson Georgia 13085 6938 101
2438128 2438128 2022-04-24 Dawson Georgia 13085 6937 101
2434872 2434872 2022-04-23 Dawson Georgia 13085 6937 101
2431616 2431616 2022-04-22 Dawson Georgia 13085 6937 101
2428360 2428360 2022-04-21 Dawson Georgia 13085 6937 101
2425104 2425104 2022-04-20 Dawson Georgia 13085 6937 101
2421848 2421848 2022-04-19 Dawson Georgia 13085 6931 101
2418592 2418592 2022-04-18 Dawson Georgia 13085 6931 101
2415336 2415336 2022-04-17 Dawson Georgia 13085 6919 101
2412080 2412080 2022-04-16 Dawson Georgia 13085 6919 101
2408824 2408824 2022-04-15 Dawson Georgia 13085 6919 101
2405568 2405568 2022-04-14 Dawson Georgia 13085 6922 101
2402313 2402313 2022-04-13 Dawson Georgia 13085 6927 100
2399058 2399058 2022-04-12 Dawson Georgia 13085 6925 100
2395803 2395803 2022-04-11 Dawson Georgia 13085 6927 100
2392547 2392547 2022-04-10 Dawson Georgia 13085 6919 100
2389291 2389291 2022-04-09 Dawson Georgia 13085 6919 100
2386036 2386036 2022-04-08 Dawson Georgia 13085 6919 100
2382781 2382781 2022-04-07 Dawson Georgia 13085 6922 100
2379526 2379526 2022-04-06 Dawson Georgia 13085 6918 100
2376272 2376272 2022-04-05 Dawson Georgia 13085 6918 100
2373020 2373020 2022-04-04 Dawson Georgia 13085 6915 100
2369767 2369767 2022-04-03 Dawson Georgia 13085 6908 100
2366514 2366514 2022-04-02 Dawson Georgia 13085 6908 100
2363261 2363261 2022-04-01 Dawson Georgia 13085 6908 100
2360007 2360007 2022-03-31 Dawson Georgia 13085 6909 100
2356753 2356753 2022-03-30 Dawson Georgia 13085 6908 100
2353500 2353500 2022-03-29 Dawson Georgia 13085 6906 100
2350248 2350248 2022-03-28 Dawson Georgia 13085 6906 100
2346995 2346995 2022-03-27 Dawson Georgia 13085 6902 100
2343742 2343742 2022-03-26 Dawson Georgia 13085 6902 100
2340489 2340489 2022-03-25 Dawson Georgia 13085 6902 100
2337236 2337236 2022-03-24 Dawson Georgia 13085 6901 100
2333982 2333982 2022-03-23 Dawson Georgia 13085 6900 99
2330728 2330728 2022-03-22 Dawson Georgia 13085 6905 99
2327476 2327476 2022-03-21 Dawson Georgia 13085 6906 99
2324223 2324223 2022-03-20 Dawson Georgia 13085 6901 99
2320969 2320969 2022-03-19 Dawson Georgia 13085 6901 99
2317715 2317715 2022-03-18 Dawson Georgia 13085 6901 99
2314462 2314462 2022-03-17 Dawson Georgia 13085 6899 99
2311209 2311209 2022-03-16 Dawson Georgia 13085 6899 99
2307956 2307956 2022-03-15 Dawson Georgia 13085 6897 99
2304705 2304705 2022-03-14 Dawson Georgia 13085 6897 98
2301453 2301453 2022-03-13 Dawson Georgia 13085 6895 98
2298201 2298201 2022-03-12 Dawson Georgia 13085 6895 98
2294949 2294949 2022-03-11 Dawson Georgia 13085 6895 98
2291697 2291697 2022-03-10 Dawson Georgia 13085 6894 98
2288445 2288445 2022-03-09 Dawson Georgia 13085 6893 98
2285194 2285194 2022-03-08 Dawson Georgia 13085 6892 98
2281942 2281942 2022-03-07 Dawson Georgia 13085 6891 98
2278689 2278689 2022-03-06 Dawson Georgia 13085 6888 97
2275436 2275436 2022-03-05 Dawson Georgia 13085 6888 97
2272183 2272183 2022-03-04 Dawson Georgia 13085 6888 97
2268931 2268931 2022-03-03 Dawson Georgia 13085 6887 97
2265678 2265678 2022-03-02 Dawson Georgia 13085 6883 97
2262427 2262427 2022-03-01 Dawson Georgia 13085 6875 97
2259176 2259176 2022-02-28 Dawson Georgia 13085 6871 97
2255925 2255925 2022-02-27 Dawson Georgia 13085 6866 97
2252674 2252674 2022-02-26 Dawson Georgia 13085 6866 97
2249423 2249423 2022-02-25 Dawson Georgia 13085 6866 97
2246172 2246172 2022-02-24 Dawson Georgia 13085 6862 97
2242921 2242921 2022-02-23 Dawson Georgia 13085 6860 97
2239670 2239670 2022-02-22 Dawson Georgia 13085 6854 96
2236419 2236419 2022-02-21 Dawson Georgia 13085 6853 96
2233168 2233168 2022-02-20 Dawson Georgia 13085 6839 95
2229917 2229917 2022-02-19 Dawson Georgia 13085 6839 95
2226666 2226666 2022-02-18 Dawson Georgia 13085 6839 95
2223415 2223415 2022-02-17 Dawson Georgia 13085 6836 94
2220164 2220164 2022-02-16 Dawson Georgia 13085 6827 94
2216913 2216913 2022-02-15 Dawson Georgia 13085 6821 94
2213662 2213662 2022-02-14 Dawson Georgia 13085 6811 94
2210410 2210410 2022-02-13 Dawson Georgia 13085 6795 93
2207157 2207157 2022-02-12 Dawson Georgia 13085 6795 93
2203904 2203904 2022-02-11 Dawson Georgia 13085 6795 93
2200651 2200651 2022-02-10 Dawson Georgia 13085 6781 93
2197397 2197397 2022-02-09 Dawson Georgia 13085 6764 92
2194143 2194143 2022-02-08 Dawson Georgia 13085 6755 91
2190889 2190889 2022-02-07 Dawson Georgia 13085 6742 91
2187636 2187636 2022-02-06 Dawson Georgia 13085 6704 91
2184383 2184383 2022-02-05 Dawson Georgia 13085 6704 91
2181131 2181131 2022-02-04 Dawson Georgia 13085 6704 91
2177880 2177880 2022-02-03 Dawson Georgia 13085 6675 91

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