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

775 rows where county = "Jefferson" and fips = 13163 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

  • 13163 · 775 ✖

county 1

  • Jefferson · 775 ✖
Link rowid date ▲ county state fips cases deaths
2500046 2500046 2022-05-13 Jefferson Georgia 13163 3668 113
2496788 2496788 2022-05-12 Jefferson Georgia 13163 3668 113
2493530 2493530 2022-05-11 Jefferson Georgia 13163 3668 113
2490272 2490272 2022-05-10 Jefferson Georgia 13163 3662 113
2487015 2487015 2022-05-09 Jefferson Georgia 13163 3662 113
2483757 2483757 2022-05-08 Jefferson Georgia 13163 3662 113
2480499 2480499 2022-05-07 Jefferson Georgia 13163 3662 113
2477241 2477241 2022-05-06 Jefferson Georgia 13163 3662 113
2473983 2473983 2022-05-05 Jefferson Georgia 13163 3662 113
2470726 2470726 2022-05-04 Jefferson Georgia 13163 3662 113
2467470 2467470 2022-05-03 Jefferson Georgia 13163 3661 111
2464215 2464215 2022-05-02 Jefferson Georgia 13163 3661 111
2460959 2460959 2022-05-01 Jefferson Georgia 13163 3660 111
2457703 2457703 2022-04-30 Jefferson Georgia 13163 3660 111
2454447 2454447 2022-04-29 Jefferson Georgia 13163 3660 111
2451191 2451191 2022-04-28 Jefferson Georgia 13163 3660 111
2447935 2447935 2022-04-27 Jefferson Georgia 13163 3660 111
2444679 2444679 2022-04-26 Jefferson Georgia 13163 3659 110
2441423 2441423 2022-04-25 Jefferson Georgia 13163 3659 110
2438167 2438167 2022-04-24 Jefferson Georgia 13163 3659 110
2434911 2434911 2022-04-23 Jefferson Georgia 13163 3659 110
2431655 2431655 2022-04-22 Jefferson Georgia 13163 3659 110
2428399 2428399 2022-04-21 Jefferson Georgia 13163 3659 110
2425143 2425143 2022-04-20 Jefferson Georgia 13163 3659 110
2421887 2421887 2022-04-19 Jefferson Georgia 13163 3658 109
2418631 2418631 2022-04-18 Jefferson Georgia 13163 3658 109
2415375 2415375 2022-04-17 Jefferson Georgia 13163 3658 109
2412119 2412119 2022-04-16 Jefferson Georgia 13163 3658 109
2408863 2408863 2022-04-15 Jefferson Georgia 13163 3658 109
2405607 2405607 2022-04-14 Jefferson Georgia 13163 3658 109
2402352 2402352 2022-04-13 Jefferson Georgia 13163 3658 109
2399097 2399097 2022-04-12 Jefferson Georgia 13163 3658 109
2395842 2395842 2022-04-11 Jefferson Georgia 13163 3658 109
2392586 2392586 2022-04-10 Jefferson Georgia 13163 3658 109
2389330 2389330 2022-04-09 Jefferson Georgia 13163 3658 109
2386075 2386075 2022-04-08 Jefferson Georgia 13163 3658 109
2382820 2382820 2022-04-07 Jefferson Georgia 13163 3658 109
2379565 2379565 2022-04-06 Jefferson Georgia 13163 3658 109
2376311 2376311 2022-04-05 Jefferson Georgia 13163 3657 109
2373059 2373059 2022-04-04 Jefferson Georgia 13163 3656 109
2369806 2369806 2022-04-03 Jefferson Georgia 13163 3655 108
2366553 2366553 2022-04-02 Jefferson Georgia 13163 3655 108
2363300 2363300 2022-04-01 Jefferson Georgia 13163 3655 108
2360046 2360046 2022-03-31 Jefferson Georgia 13163 3655 108
2356792 2356792 2022-03-30 Jefferson Georgia 13163 3655 108
2353539 2353539 2022-03-29 Jefferson Georgia 13163 3655 108
2350287 2350287 2022-03-28 Jefferson Georgia 13163 3654 108
2347034 2347034 2022-03-27 Jefferson Georgia 13163 3654 108
2343781 2343781 2022-03-26 Jefferson Georgia 13163 3654 108
2340528 2340528 2022-03-25 Jefferson Georgia 13163 3654 108
2337275 2337275 2022-03-24 Jefferson Georgia 13163 3653 108
2334021 2334021 2022-03-23 Jefferson Georgia 13163 3653 108
2330767 2330767 2022-03-22 Jefferson Georgia 13163 3653 108
2327515 2327515 2022-03-21 Jefferson Georgia 13163 3653 108
2324262 2324262 2022-03-20 Jefferson Georgia 13163 3653 107
2321008 2321008 2022-03-19 Jefferson Georgia 13163 3653 107
2317754 2317754 2022-03-18 Jefferson Georgia 13163 3653 107
2314501 2314501 2022-03-17 Jefferson Georgia 13163 3653 107
2311248 2311248 2022-03-16 Jefferson Georgia 13163 3652 107
2307995 2307995 2022-03-15 Jefferson Georgia 13163 3651 107
2304744 2304744 2022-03-14 Jefferson Georgia 13163 3652 107
2301492 2301492 2022-03-13 Jefferson Georgia 13163 3652 107
2298240 2298240 2022-03-12 Jefferson Georgia 13163 3652 107
2294988 2294988 2022-03-11 Jefferson Georgia 13163 3652 107
2291736 2291736 2022-03-10 Jefferson Georgia 13163 3652 107
2288484 2288484 2022-03-09 Jefferson Georgia 13163 3651 107
2285233 2285233 2022-03-08 Jefferson Georgia 13163 3650 107
2281981 2281981 2022-03-07 Jefferson Georgia 13163 3649 107
2278728 2278728 2022-03-06 Jefferson Georgia 13163 3644 107
2275475 2275475 2022-03-05 Jefferson Georgia 13163 3644 107
2272222 2272222 2022-03-04 Jefferson Georgia 13163 3644 107
2268970 2268970 2022-03-03 Jefferson Georgia 13163 3643 105
2265717 2265717 2022-03-02 Jefferson Georgia 13163 3642 105
2262466 2262466 2022-03-01 Jefferson Georgia 13163 3639 105
2259215 2259215 2022-02-28 Jefferson Georgia 13163 3637 105
2255964 2255964 2022-02-27 Jefferson Georgia 13163 3631 105
2252713 2252713 2022-02-26 Jefferson Georgia 13163 3631 105
2249462 2249462 2022-02-25 Jefferson Georgia 13163 3631 105
2246211 2246211 2022-02-24 Jefferson Georgia 13163 3628 105
2242960 2242960 2022-02-23 Jefferson Georgia 13163 3626 105
2239709 2239709 2022-02-22 Jefferson Georgia 13163 3619 105
2236458 2236458 2022-02-21 Jefferson Georgia 13163 3616 105
2233207 2233207 2022-02-20 Jefferson Georgia 13163 3613 104
2229956 2229956 2022-02-19 Jefferson Georgia 13163 3613 104
2226705 2226705 2022-02-18 Jefferson Georgia 13163 3613 104
2223454 2223454 2022-02-17 Jefferson Georgia 13163 3613 103
2220203 2220203 2022-02-16 Jefferson Georgia 13163 3611 103
2216952 2216952 2022-02-15 Jefferson Georgia 13163 3610 103
2213701 2213701 2022-02-14 Jefferson Georgia 13163 3609 102
2210449 2210449 2022-02-13 Jefferson Georgia 13163 3599 102
2207196 2207196 2022-02-12 Jefferson Georgia 13163 3599 102
2203943 2203943 2022-02-11 Jefferson Georgia 13163 3599 102
2200690 2200690 2022-02-10 Jefferson Georgia 13163 3594 100
2197436 2197436 2022-02-09 Jefferson Georgia 13163 3587 100
2194182 2194182 2022-02-08 Jefferson Georgia 13163 3575 100
2190928 2190928 2022-02-07 Jefferson Georgia 13163 3565 100
2187675 2187675 2022-02-06 Jefferson Georgia 13163 3556 100
2184422 2184422 2022-02-05 Jefferson Georgia 13163 3556 100
2181170 2181170 2022-02-04 Jefferson Georgia 13163 3556 100
2177919 2177919 2022-02-03 Jefferson Georgia 13163 3538 100

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