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 = "Madison" and fips = 13195 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

  • 13195 · 782 ✖

county 1

  • Madison · 782 ✖
Link rowid date ▲ county state fips cases deaths
2500060 2500060 2022-05-13 Madison Georgia 13195 6950 110
2496802 2496802 2022-05-12 Madison Georgia 13195 6950 110
2493544 2493544 2022-05-11 Madison Georgia 13195 6950 110
2490286 2490286 2022-05-10 Madison Georgia 13195 6941 110
2487029 2487029 2022-05-09 Madison Georgia 13195 6941 110
2483771 2483771 2022-05-08 Madison Georgia 13195 6941 110
2480513 2480513 2022-05-07 Madison Georgia 13195 6941 110
2477255 2477255 2022-05-06 Madison Georgia 13195 6941 110
2473997 2473997 2022-05-05 Madison Georgia 13195 6941 110
2470740 2470740 2022-05-04 Madison Georgia 13195 6941 110
2467484 2467484 2022-05-03 Madison Georgia 13195 6938 109
2464229 2464229 2022-05-02 Madison Georgia 13195 6938 109
2460973 2460973 2022-05-01 Madison Georgia 13195 6937 109
2457717 2457717 2022-04-30 Madison Georgia 13195 6937 109
2454461 2454461 2022-04-29 Madison Georgia 13195 6937 109
2451205 2451205 2022-04-28 Madison Georgia 13195 6937 109
2447949 2447949 2022-04-27 Madison Georgia 13195 6937 109
2444693 2444693 2022-04-26 Madison Georgia 13195 6940 108
2441437 2441437 2022-04-25 Madison Georgia 13195 6940 108
2438181 2438181 2022-04-24 Madison Georgia 13195 6939 108
2434925 2434925 2022-04-23 Madison Georgia 13195 6939 108
2431669 2431669 2022-04-22 Madison Georgia 13195 6939 108
2428413 2428413 2022-04-21 Madison Georgia 13195 6939 108
2425157 2425157 2022-04-20 Madison Georgia 13195 6939 108
2421901 2421901 2022-04-19 Madison Georgia 13195 6936 106
2418645 2418645 2022-04-18 Madison Georgia 13195 6936 106
2415389 2415389 2022-04-17 Madison Georgia 13195 6936 106
2412133 2412133 2022-04-16 Madison Georgia 13195 6936 106
2408877 2408877 2022-04-15 Madison Georgia 13195 6936 106
2405621 2405621 2022-04-14 Madison Georgia 13195 6940 106
2402366 2402366 2022-04-13 Madison Georgia 13195 6941 106
2399111 2399111 2022-04-12 Madison Georgia 13195 6944 105
2395856 2395856 2022-04-11 Madison Georgia 13195 6946 105
2392600 2392600 2022-04-10 Madison Georgia 13195 6944 105
2389344 2389344 2022-04-09 Madison Georgia 13195 6944 105
2386089 2386089 2022-04-08 Madison Georgia 13195 6944 105
2382834 2382834 2022-04-07 Madison Georgia 13195 6946 105
2379579 2379579 2022-04-06 Madison Georgia 13195 6945 105
2376325 2376325 2022-04-05 Madison Georgia 13195 6945 105
2373073 2373073 2022-04-04 Madison Georgia 13195 6946 105
2369820 2369820 2022-04-03 Madison Georgia 13195 6946 105
2366567 2366567 2022-04-02 Madison Georgia 13195 6946 105
2363314 2363314 2022-04-01 Madison Georgia 13195 6946 105
2360060 2360060 2022-03-31 Madison Georgia 13195 6946 104
2356806 2356806 2022-03-30 Madison Georgia 13195 6945 104
2353553 2353553 2022-03-29 Madison Georgia 13195 6943 103
2350301 2350301 2022-03-28 Madison Georgia 13195 6941 103
2347048 2347048 2022-03-27 Madison Georgia 13195 6941 103
2343795 2343795 2022-03-26 Madison Georgia 13195 6941 103
2340542 2340542 2022-03-25 Madison Georgia 13195 6941 103
2337289 2337289 2022-03-24 Madison Georgia 13195 6941 102
2334035 2334035 2022-03-23 Madison Georgia 13195 6939 102
2330781 2330781 2022-03-22 Madison Georgia 13195 6936 102
2327529 2327529 2022-03-21 Madison Georgia 13195 6937 101
2324276 2324276 2022-03-20 Madison Georgia 13195 6935 101
2321022 2321022 2022-03-19 Madison Georgia 13195 6935 101
2317768 2317768 2022-03-18 Madison Georgia 13195 6935 101
2314515 2314515 2022-03-17 Madison Georgia 13195 6935 101
2311262 2311262 2022-03-16 Madison Georgia 13195 6940 100
2308009 2308009 2022-03-15 Madison Georgia 13195 6938 100
2304758 2304758 2022-03-14 Madison Georgia 13195 6938 100
2301506 2301506 2022-03-13 Madison Georgia 13195 6937 100
2298254 2298254 2022-03-12 Madison Georgia 13195 6937 100
2295002 2295002 2022-03-11 Madison Georgia 13195 6937 100
2291750 2291750 2022-03-10 Madison Georgia 13195 6937 99
2288498 2288498 2022-03-09 Madison Georgia 13195 6936 97
2285247 2285247 2022-03-08 Madison Georgia 13195 6935 97
2281995 2281995 2022-03-07 Madison Georgia 13195 6933 97
2278742 2278742 2022-03-06 Madison Georgia 13195 6932 97
2275489 2275489 2022-03-05 Madison Georgia 13195 6932 97
2272236 2272236 2022-03-04 Madison Georgia 13195 6932 97
2268984 2268984 2022-03-03 Madison Georgia 13195 6932 97
2265731 2265731 2022-03-02 Madison Georgia 13195 6931 97
2262480 2262480 2022-03-01 Madison Georgia 13195 6930 96
2259229 2259229 2022-02-28 Madison Georgia 13195 6925 95
2255978 2255978 2022-02-27 Madison Georgia 13195 6920 94
2252727 2252727 2022-02-26 Madison Georgia 13195 6920 94
2249476 2249476 2022-02-25 Madison Georgia 13195 6920 94
2246225 2246225 2022-02-24 Madison Georgia 13195 6917 93
2242974 2242974 2022-02-23 Madison Georgia 13195 6917 93
2239723 2239723 2022-02-22 Madison Georgia 13195 6916 91
2236472 2236472 2022-02-21 Madison Georgia 13195 6913 91
2233221 2233221 2022-02-20 Madison Georgia 13195 6908 90
2229970 2229970 2022-02-19 Madison Georgia 13195 6908 90
2226719 2226719 2022-02-18 Madison Georgia 13195 6908 90
2223468 2223468 2022-02-17 Madison Georgia 13195 6900 90
2220217 2220217 2022-02-16 Madison Georgia 13195 6896 88
2216966 2216966 2022-02-15 Madison Georgia 13195 6892 88
2213715 2213715 2022-02-14 Madison Georgia 13195 6886 88
2210463 2210463 2022-02-13 Madison Georgia 13195 6868 88
2207210 2207210 2022-02-12 Madison Georgia 13195 6868 88
2203957 2203957 2022-02-11 Madison Georgia 13195 6868 88
2200704 2200704 2022-02-10 Madison Georgia 13195 6857 88
2197450 2197450 2022-02-09 Madison Georgia 13195 6852 88
2194196 2194196 2022-02-08 Madison Georgia 13195 6845 86
2190942 2190942 2022-02-07 Madison Georgia 13195 6840 86
2187689 2187689 2022-02-06 Madison Georgia 13195 6805 86
2184436 2184436 2022-02-05 Madison Georgia 13195 6805 86
2181184 2181184 2022-02-04 Madison Georgia 13195 6805 86
2177933 2177933 2022-02-03 Madison Georgia 13195 6790 86

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