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 = "Monroe" 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

  • Monroe · 785 ✖
Link rowid date ▲ county state fips cases deaths
2500067 2500067 2022-05-13 Monroe Georgia 13207 5927 174
2496809 2496809 2022-05-12 Monroe Georgia 13207 5927 174
2493551 2493551 2022-05-11 Monroe Georgia 13207 5927 174
2490293 2490293 2022-05-10 Monroe Georgia 13207 5907 172
2487036 2487036 2022-05-09 Monroe Georgia 13207 5907 172
2483778 2483778 2022-05-08 Monroe Georgia 13207 5907 172
2480520 2480520 2022-05-07 Monroe Georgia 13207 5907 172
2477262 2477262 2022-05-06 Monroe Georgia 13207 5907 172
2474004 2474004 2022-05-05 Monroe Georgia 13207 5907 172
2470747 2470747 2022-05-04 Monroe Georgia 13207 5907 172
2467491 2467491 2022-05-03 Monroe Georgia 13207 5891 172
2464236 2464236 2022-05-02 Monroe Georgia 13207 5891 172
2460980 2460980 2022-05-01 Monroe Georgia 13207 5891 172
2457724 2457724 2022-04-30 Monroe Georgia 13207 5891 172
2454468 2454468 2022-04-29 Monroe Georgia 13207 5891 172
2451212 2451212 2022-04-28 Monroe Georgia 13207 5891 172
2447956 2447956 2022-04-27 Monroe Georgia 13207 5891 172
2444700 2444700 2022-04-26 Monroe Georgia 13207 5878 172
2441444 2441444 2022-04-25 Monroe Georgia 13207 5878 172
2438188 2438188 2022-04-24 Monroe Georgia 13207 5879 172
2434932 2434932 2022-04-23 Monroe Georgia 13207 5879 172
2431676 2431676 2022-04-22 Monroe Georgia 13207 5879 172
2428420 2428420 2022-04-21 Monroe Georgia 13207 5879 172
2425164 2425164 2022-04-20 Monroe Georgia 13207 5879 172
2421908 2421908 2022-04-19 Monroe Georgia 13207 5877 172
2418652 2418652 2022-04-18 Monroe Georgia 13207 5877 172
2415396 2415396 2022-04-17 Monroe Georgia 13207 5878 172
2412140 2412140 2022-04-16 Monroe Georgia 13207 5878 172
2408884 2408884 2022-04-15 Monroe Georgia 13207 5878 172
2405628 2405628 2022-04-14 Monroe Georgia 13207 5877 172
2402373 2402373 2022-04-13 Monroe Georgia 13207 5875 172
2399118 2399118 2022-04-12 Monroe Georgia 13207 5871 172
2395863 2395863 2022-04-11 Monroe Georgia 13207 5868 172
2392607 2392607 2022-04-10 Monroe Georgia 13207 5869 172
2389351 2389351 2022-04-09 Monroe Georgia 13207 5869 172
2386096 2386096 2022-04-08 Monroe Georgia 13207 5869 172
2382841 2382841 2022-04-07 Monroe Georgia 13207 5870 172
2379586 2379586 2022-04-06 Monroe Georgia 13207 5870 172
2376332 2376332 2022-04-05 Monroe Georgia 13207 5869 172
2373080 2373080 2022-04-04 Monroe Georgia 13207 5868 172
2369827 2369827 2022-04-03 Monroe Georgia 13207 5866 172
2366574 2366574 2022-04-02 Monroe Georgia 13207 5866 172
2363321 2363321 2022-04-01 Monroe Georgia 13207 5866 172
2360067 2360067 2022-03-31 Monroe Georgia 13207 5863 172
2356813 2356813 2022-03-30 Monroe Georgia 13207 5863 172
2353560 2353560 2022-03-29 Monroe Georgia 13207 5859 172
2350308 2350308 2022-03-28 Monroe Georgia 13207 5859 172
2347055 2347055 2022-03-27 Monroe Georgia 13207 5858 172
2343802 2343802 2022-03-26 Monroe Georgia 13207 5858 172
2340549 2340549 2022-03-25 Monroe Georgia 13207 5858 172
2337296 2337296 2022-03-24 Monroe Georgia 13207 5858 172
2334042 2334042 2022-03-23 Monroe Georgia 13207 5859 172
2330788 2330788 2022-03-22 Monroe Georgia 13207 5859 172
2327536 2327536 2022-03-21 Monroe Georgia 13207 5858 172
2324283 2324283 2022-03-20 Monroe Georgia 13207 5861 172
2321029 2321029 2022-03-19 Monroe Georgia 13207 5861 172
2317775 2317775 2022-03-18 Monroe Georgia 13207 5861 172
2314522 2314522 2022-03-17 Monroe Georgia 13207 5860 172
2311269 2311269 2022-03-16 Monroe Georgia 13207 5858 172
2308016 2308016 2022-03-15 Monroe Georgia 13207 5857 172
2304765 2304765 2022-03-14 Monroe Georgia 13207 5858 170
2301513 2301513 2022-03-13 Monroe Georgia 13207 5856 169
2298261 2298261 2022-03-12 Monroe Georgia 13207 5856 169
2295009 2295009 2022-03-11 Monroe Georgia 13207 5856 169
2291757 2291757 2022-03-10 Monroe Georgia 13207 5856 169
2288505 2288505 2022-03-09 Monroe Georgia 13207 5854 168
2285254 2285254 2022-03-08 Monroe Georgia 13207 5850 167
2282002 2282002 2022-03-07 Monroe Georgia 13207 5849 167
2278749 2278749 2022-03-06 Monroe Georgia 13207 5847 167
2275496 2275496 2022-03-05 Monroe Georgia 13207 5847 167
2272243 2272243 2022-03-04 Monroe Georgia 13207 5847 167
2268991 2268991 2022-03-03 Monroe Georgia 13207 5844 167
2265738 2265738 2022-03-02 Monroe Georgia 13207 5843 166
2262487 2262487 2022-03-01 Monroe Georgia 13207 5839 166
2259236 2259236 2022-02-28 Monroe Georgia 13207 5837 165
2255985 2255985 2022-02-27 Monroe Georgia 13207 5831 165
2252734 2252734 2022-02-26 Monroe Georgia 13207 5831 165
2249483 2249483 2022-02-25 Monroe Georgia 13207 5831 165
2246232 2246232 2022-02-24 Monroe Georgia 13207 5827 165
2242981 2242981 2022-02-23 Monroe Georgia 13207 5819 165
2239730 2239730 2022-02-22 Monroe Georgia 13207 5814 165
2236479 2236479 2022-02-21 Monroe Georgia 13207 5810 164
2233228 2233228 2022-02-20 Monroe Georgia 13207 5798 164
2229977 2229977 2022-02-19 Monroe Georgia 13207 5798 164
2226726 2226726 2022-02-18 Monroe Georgia 13207 5798 164
2223475 2223475 2022-02-17 Monroe Georgia 13207 5794 163
2220224 2220224 2022-02-16 Monroe Georgia 13207 5785 161
2216973 2216973 2022-02-15 Monroe Georgia 13207 5777 160
2213722 2213722 2022-02-14 Monroe Georgia 13207 5767 159
2210470 2210470 2022-02-13 Monroe Georgia 13207 5757 159
2207217 2207217 2022-02-12 Monroe Georgia 13207 5757 159
2203964 2203964 2022-02-11 Monroe Georgia 13207 5757 159
2200711 2200711 2022-02-10 Monroe Georgia 13207 5740 159
2197457 2197457 2022-02-09 Monroe Georgia 13207 5726 159
2194203 2194203 2022-02-08 Monroe Georgia 13207 5712 159
2190949 2190949 2022-02-07 Monroe Georgia 13207 5703 159
2187696 2187696 2022-02-06 Monroe Georgia 13207 5674 159
2184443 2184443 2022-02-05 Monroe Georgia 13207 5674 159
2181191 2181191 2022-02-04 Monroe Georgia 13207 5674 159
2177940 2177940 2022-02-03 Monroe Georgia 13207 5668 157

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