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

771 rows where county = "Marion" and fips = 13197 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

  • 13197 · 771 ✖

county 1

  • Marion · 771 ✖
Link rowid date ▲ county state fips cases deaths
2500061 2500061 2022-05-13 Marion Georgia 13197 1520 50
2496803 2496803 2022-05-12 Marion Georgia 13197 1520 50
2493545 2493545 2022-05-11 Marion Georgia 13197 1520 50
2490287 2490287 2022-05-10 Marion Georgia 13197 1520 50
2487030 2487030 2022-05-09 Marion Georgia 13197 1520 50
2483772 2483772 2022-05-08 Marion Georgia 13197 1519 50
2480514 2480514 2022-05-07 Marion Georgia 13197 1519 50
2477256 2477256 2022-05-06 Marion Georgia 13197 1519 50
2473998 2473998 2022-05-05 Marion Georgia 13197 1519 50
2470741 2470741 2022-05-04 Marion Georgia 13197 1519 50
2467485 2467485 2022-05-03 Marion Georgia 13197 1518 50
2464230 2464230 2022-05-02 Marion Georgia 13197 1518 50
2460974 2460974 2022-05-01 Marion Georgia 13197 1518 50
2457718 2457718 2022-04-30 Marion Georgia 13197 1518 50
2454462 2454462 2022-04-29 Marion Georgia 13197 1518 50
2451206 2451206 2022-04-28 Marion Georgia 13197 1518 50
2447950 2447950 2022-04-27 Marion Georgia 13197 1518 50
2444694 2444694 2022-04-26 Marion Georgia 13197 1516 50
2441438 2441438 2022-04-25 Marion Georgia 13197 1516 50
2438182 2438182 2022-04-24 Marion Georgia 13197 1516 50
2434926 2434926 2022-04-23 Marion Georgia 13197 1516 50
2431670 2431670 2022-04-22 Marion Georgia 13197 1516 50
2428414 2428414 2022-04-21 Marion Georgia 13197 1516 50
2425158 2425158 2022-04-20 Marion Georgia 13197 1516 50
2421902 2421902 2022-04-19 Marion Georgia 13197 1516 50
2418646 2418646 2022-04-18 Marion Georgia 13197 1516 50
2415390 2415390 2022-04-17 Marion Georgia 13197 1516 50
2412134 2412134 2022-04-16 Marion Georgia 13197 1516 50
2408878 2408878 2022-04-15 Marion Georgia 13197 1516 50
2405622 2405622 2022-04-14 Marion Georgia 13197 1516 50
2402367 2402367 2022-04-13 Marion Georgia 13197 1516 50
2399112 2399112 2022-04-12 Marion Georgia 13197 1514 50
2395857 2395857 2022-04-11 Marion Georgia 13197 1514 50
2392601 2392601 2022-04-10 Marion Georgia 13197 1514 50
2389345 2389345 2022-04-09 Marion Georgia 13197 1514 50
2386090 2386090 2022-04-08 Marion Georgia 13197 1514 50
2382835 2382835 2022-04-07 Marion Georgia 13197 1514 50
2379580 2379580 2022-04-06 Marion Georgia 13197 1514 50
2376326 2376326 2022-04-05 Marion Georgia 13197 1513 50
2373074 2373074 2022-04-04 Marion Georgia 13197 1513 50
2369821 2369821 2022-04-03 Marion Georgia 13197 1510 50
2366568 2366568 2022-04-02 Marion Georgia 13197 1510 50
2363315 2363315 2022-04-01 Marion Georgia 13197 1510 50
2360061 2360061 2022-03-31 Marion Georgia 13197 1510 50
2356807 2356807 2022-03-30 Marion Georgia 13197 1510 50
2353554 2353554 2022-03-29 Marion Georgia 13197 1509 50
2350302 2350302 2022-03-28 Marion Georgia 13197 1509 50
2347049 2347049 2022-03-27 Marion Georgia 13197 1507 50
2343796 2343796 2022-03-26 Marion Georgia 13197 1507 50
2340543 2340543 2022-03-25 Marion Georgia 13197 1507 50
2337290 2337290 2022-03-24 Marion Georgia 13197 1507 50
2334036 2334036 2022-03-23 Marion Georgia 13197 1507 50
2330782 2330782 2022-03-22 Marion Georgia 13197 1507 49
2327530 2327530 2022-03-21 Marion Georgia 13197 1507 49
2324277 2324277 2022-03-20 Marion Georgia 13197 1506 49
2321023 2321023 2022-03-19 Marion Georgia 13197 1506 49
2317769 2317769 2022-03-18 Marion Georgia 13197 1506 49
2314516 2314516 2022-03-17 Marion Georgia 13197 1506 49
2311263 2311263 2022-03-16 Marion Georgia 13197 1506 49
2308010 2308010 2022-03-15 Marion Georgia 13197 1504 49
2304759 2304759 2022-03-14 Marion Georgia 13197 1504 49
2301507 2301507 2022-03-13 Marion Georgia 13197 1503 49
2298255 2298255 2022-03-12 Marion Georgia 13197 1503 49
2295003 2295003 2022-03-11 Marion Georgia 13197 1503 49
2291751 2291751 2022-03-10 Marion Georgia 13197 1503 49
2288499 2288499 2022-03-09 Marion Georgia 13197 1502 49
2285248 2285248 2022-03-08 Marion Georgia 13197 1503 49
2281996 2281996 2022-03-07 Marion Georgia 13197 1503 49
2278743 2278743 2022-03-06 Marion Georgia 13197 1501 49
2275490 2275490 2022-03-05 Marion Georgia 13197 1501 49
2272237 2272237 2022-03-04 Marion Georgia 13197 1501 49
2268985 2268985 2022-03-03 Marion Georgia 13197 1490 49
2265732 2265732 2022-03-02 Marion Georgia 13197 1490 49
2262481 2262481 2022-03-01 Marion Georgia 13197 1488 49
2259230 2259230 2022-02-28 Marion Georgia 13197 1488 49
2255979 2255979 2022-02-27 Marion Georgia 13197 1487 48
2252728 2252728 2022-02-26 Marion Georgia 13197 1487 48
2249477 2249477 2022-02-25 Marion Georgia 13197 1487 48
2246226 2246226 2022-02-24 Marion Georgia 13197 1485 47
2242975 2242975 2022-02-23 Marion Georgia 13197 1485 47
2239724 2239724 2022-02-22 Marion Georgia 13197 1485 47
2236473 2236473 2022-02-21 Marion Georgia 13197 1486 46
2233222 2233222 2022-02-20 Marion Georgia 13197 1486 45
2229971 2229971 2022-02-19 Marion Georgia 13197 1486 45
2226720 2226720 2022-02-18 Marion Georgia 13197 1486 45
2223469 2223469 2022-02-17 Marion Georgia 13197 1486 45
2220218 2220218 2022-02-16 Marion Georgia 13197 1485 44
2216967 2216967 2022-02-15 Marion Georgia 13197 1484 44
2213716 2213716 2022-02-14 Marion Georgia 13197 1480 44
2210464 2210464 2022-02-13 Marion Georgia 13197 1480 44
2207211 2207211 2022-02-12 Marion Georgia 13197 1480 44
2203958 2203958 2022-02-11 Marion Georgia 13197 1480 44
2200705 2200705 2022-02-10 Marion Georgia 13197 1477 44
2197451 2197451 2022-02-09 Marion Georgia 13197 1475 44
2194197 2194197 2022-02-08 Marion Georgia 13197 1473 44
2190943 2190943 2022-02-07 Marion Georgia 13197 1468 43
2187690 2187690 2022-02-06 Marion Georgia 13197 1462 43
2184437 2184437 2022-02-05 Marion Georgia 13197 1462 43
2181185 2181185 2022-02-04 Marion Georgia 13197 1462 43
2177934 2177934 2022-02-03 Marion Georgia 13197 1458 43

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