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 fips = 13243 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

  • 13243 · 785 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500085 2500085 2022-05-13 Randolph Georgia 13243 1490 48
2496827 2496827 2022-05-12 Randolph Georgia 13243 1490 48
2493569 2493569 2022-05-11 Randolph Georgia 13243 1490 48
2490311 2490311 2022-05-10 Randolph Georgia 13243 1490 48
2487054 2487054 2022-05-09 Randolph Georgia 13243 1490 48
2483796 2483796 2022-05-08 Randolph Georgia 13243 1490 48
2480538 2480538 2022-05-07 Randolph Georgia 13243 1490 48
2477280 2477280 2022-05-06 Randolph Georgia 13243 1490 48
2474022 2474022 2022-05-05 Randolph Georgia 13243 1490 48
2470765 2470765 2022-05-04 Randolph Georgia 13243 1490 48
2467509 2467509 2022-05-03 Randolph Georgia 13243 1487 48
2464254 2464254 2022-05-02 Randolph Georgia 13243 1487 48
2460998 2460998 2022-05-01 Randolph Georgia 13243 1487 48
2457742 2457742 2022-04-30 Randolph Georgia 13243 1487 48
2454486 2454486 2022-04-29 Randolph Georgia 13243 1487 48
2451230 2451230 2022-04-28 Randolph Georgia 13243 1487 48
2447974 2447974 2022-04-27 Randolph Georgia 13243 1487 48
2444718 2444718 2022-04-26 Randolph Georgia 13243 1486 48
2441462 2441462 2022-04-25 Randolph Georgia 13243 1486 48
2438206 2438206 2022-04-24 Randolph Georgia 13243 1486 48
2434950 2434950 2022-04-23 Randolph Georgia 13243 1486 48
2431694 2431694 2022-04-22 Randolph Georgia 13243 1486 48
2428438 2428438 2022-04-21 Randolph Georgia 13243 1486 48
2425182 2425182 2022-04-20 Randolph Georgia 13243 1486 48
2421926 2421926 2022-04-19 Randolph Georgia 13243 1485 48
2418670 2418670 2022-04-18 Randolph Georgia 13243 1485 48
2415414 2415414 2022-04-17 Randolph Georgia 13243 1485 48
2412158 2412158 2022-04-16 Randolph Georgia 13243 1485 48
2408902 2408902 2022-04-15 Randolph Georgia 13243 1485 48
2405646 2405646 2022-04-14 Randolph Georgia 13243 1485 48
2402391 2402391 2022-04-13 Randolph Georgia 13243 1485 48
2399136 2399136 2022-04-12 Randolph Georgia 13243 1485 48
2395881 2395881 2022-04-11 Randolph Georgia 13243 1484 48
2392625 2392625 2022-04-10 Randolph Georgia 13243 1483 48
2389369 2389369 2022-04-09 Randolph Georgia 13243 1483 48
2386114 2386114 2022-04-08 Randolph Georgia 13243 1483 48
2382859 2382859 2022-04-07 Randolph Georgia 13243 1482 48
2379604 2379604 2022-04-06 Randolph Georgia 13243 1482 48
2376350 2376350 2022-04-05 Randolph Georgia 13243 1482 48
2373098 2373098 2022-04-04 Randolph Georgia 13243 1482 48
2369845 2369845 2022-04-03 Randolph Georgia 13243 1481 48
2366592 2366592 2022-04-02 Randolph Georgia 13243 1481 48
2363339 2363339 2022-04-01 Randolph Georgia 13243 1481 48
2360085 2360085 2022-03-31 Randolph Georgia 13243 1481 48
2356831 2356831 2022-03-30 Randolph Georgia 13243 1480 48
2353578 2353578 2022-03-29 Randolph Georgia 13243 1481 48
2350326 2350326 2022-03-28 Randolph Georgia 13243 1481 48
2347073 2347073 2022-03-27 Randolph Georgia 13243 1477 48
2343820 2343820 2022-03-26 Randolph Georgia 13243 1477 48
2340567 2340567 2022-03-25 Randolph Georgia 13243 1477 48
2337314 2337314 2022-03-24 Randolph Georgia 13243 1477 48
2334060 2334060 2022-03-23 Randolph Georgia 13243 1477 48
2330806 2330806 2022-03-22 Randolph Georgia 13243 1477 48
2327554 2327554 2022-03-21 Randolph Georgia 13243 1477 48
2324301 2324301 2022-03-20 Randolph Georgia 13243 1476 48
2321047 2321047 2022-03-19 Randolph Georgia 13243 1476 48
2317793 2317793 2022-03-18 Randolph Georgia 13243 1476 48
2314540 2314540 2022-03-17 Randolph Georgia 13243 1477 48
2311287 2311287 2022-03-16 Randolph Georgia 13243 1477 48
2308034 2308034 2022-03-15 Randolph Georgia 13243 1477 47
2304783 2304783 2022-03-14 Randolph Georgia 13243 1477 47
2301531 2301531 2022-03-13 Randolph Georgia 13243 1476 47
2298279 2298279 2022-03-12 Randolph Georgia 13243 1476 47
2295027 2295027 2022-03-11 Randolph Georgia 13243 1476 47
2291775 2291775 2022-03-10 Randolph Georgia 13243 1476 47
2288523 2288523 2022-03-09 Randolph Georgia 13243 1476 47
2285272 2285272 2022-03-08 Randolph Georgia 13243 1476 47
2282020 2282020 2022-03-07 Randolph Georgia 13243 1476 47
2278767 2278767 2022-03-06 Randolph Georgia 13243 1476 47
2275514 2275514 2022-03-05 Randolph Georgia 13243 1476 47
2272261 2272261 2022-03-04 Randolph Georgia 13243 1476 47
2269009 2269009 2022-03-03 Randolph Georgia 13243 1476 47
2265756 2265756 2022-03-02 Randolph Georgia 13243 1476 47
2262505 2262505 2022-03-01 Randolph Georgia 13243 1476 47
2259254 2259254 2022-02-28 Randolph Georgia 13243 1476 47
2256003 2256003 2022-02-27 Randolph Georgia 13243 1473 47
2252752 2252752 2022-02-26 Randolph Georgia 13243 1473 47
2249501 2249501 2022-02-25 Randolph Georgia 13243 1473 47
2246250 2246250 2022-02-24 Randolph Georgia 13243 1473 47
2242999 2242999 2022-02-23 Randolph Georgia 13243 1473 47
2239748 2239748 2022-02-22 Randolph Georgia 13243 1472 47
2236497 2236497 2022-02-21 Randolph Georgia 13243 1470 47
2233246 2233246 2022-02-20 Randolph Georgia 13243 1467 47
2229995 2229995 2022-02-19 Randolph Georgia 13243 1467 47
2226744 2226744 2022-02-18 Randolph Georgia 13243 1467 47
2223493 2223493 2022-02-17 Randolph Georgia 13243 1464 47
2220242 2220242 2022-02-16 Randolph Georgia 13243 1464 47
2216991 2216991 2022-02-15 Randolph Georgia 13243 1462 47
2213740 2213740 2022-02-14 Randolph Georgia 13243 1460 47
2210488 2210488 2022-02-13 Randolph Georgia 13243 1454 47
2207235 2207235 2022-02-12 Randolph Georgia 13243 1454 47
2203982 2203982 2022-02-11 Randolph Georgia 13243 1454 47
2200729 2200729 2022-02-10 Randolph Georgia 13243 1444 47
2197475 2197475 2022-02-09 Randolph Georgia 13243 1443 47
2194221 2194221 2022-02-08 Randolph Georgia 13243 1439 47
2190967 2190967 2022-02-07 Randolph Georgia 13243 1434 47
2187714 2187714 2022-02-06 Randolph Georgia 13243 1423 47
2184461 2184461 2022-02-05 Randolph Georgia 13243 1423 47
2181209 2181209 2022-02-04 Randolph Georgia 13243 1423 47
2177958 2177958 2022-02-03 Randolph Georgia 13243 1414 47

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