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

780 rows where county = "Jones" 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 · 780 ✖

fips 1

county 1

  • Jones · 780 ✖
Link rowid date ▲ county state fips cases deaths
2500049 2500049 2022-05-13 Jones Georgia 13169 5080 109
2496791 2496791 2022-05-12 Jones Georgia 13169 5080 109
2493533 2493533 2022-05-11 Jones Georgia 13169 5080 109
2490275 2490275 2022-05-10 Jones Georgia 13169 5071 108
2487018 2487018 2022-05-09 Jones Georgia 13169 5071 108
2483760 2483760 2022-05-08 Jones Georgia 13169 5072 108
2480502 2480502 2022-05-07 Jones Georgia 13169 5072 108
2477244 2477244 2022-05-06 Jones Georgia 13169 5072 108
2473986 2473986 2022-05-05 Jones Georgia 13169 5072 108
2470729 2470729 2022-05-04 Jones Georgia 13169 5072 108
2467473 2467473 2022-05-03 Jones Georgia 13169 5065 108
2464218 2464218 2022-05-02 Jones Georgia 13169 5065 108
2460962 2460962 2022-05-01 Jones Georgia 13169 5065 108
2457706 2457706 2022-04-30 Jones Georgia 13169 5065 108
2454450 2454450 2022-04-29 Jones Georgia 13169 5065 108
2451194 2451194 2022-04-28 Jones Georgia 13169 5065 108
2447938 2447938 2022-04-27 Jones Georgia 13169 5065 108
2444682 2444682 2022-04-26 Jones Georgia 13169 5054 108
2441426 2441426 2022-04-25 Jones Georgia 13169 5054 108
2438170 2438170 2022-04-24 Jones Georgia 13169 5054 108
2434914 2434914 2022-04-23 Jones Georgia 13169 5054 108
2431658 2431658 2022-04-22 Jones Georgia 13169 5054 108
2428402 2428402 2022-04-21 Jones Georgia 13169 5054 108
2425146 2425146 2022-04-20 Jones Georgia 13169 5054 108
2421890 2421890 2022-04-19 Jones Georgia 13169 5051 108
2418634 2418634 2022-04-18 Jones Georgia 13169 5051 108
2415378 2415378 2022-04-17 Jones Georgia 13169 5051 108
2412122 2412122 2022-04-16 Jones Georgia 13169 5051 108
2408866 2408866 2022-04-15 Jones Georgia 13169 5051 108
2405610 2405610 2022-04-14 Jones Georgia 13169 5051 108
2402355 2402355 2022-04-13 Jones Georgia 13169 5050 108
2399100 2399100 2022-04-12 Jones Georgia 13169 5050 108
2395845 2395845 2022-04-11 Jones Georgia 13169 5050 108
2392589 2392589 2022-04-10 Jones Georgia 13169 5050 108
2389333 2389333 2022-04-09 Jones Georgia 13169 5050 108
2386078 2386078 2022-04-08 Jones Georgia 13169 5050 108
2382823 2382823 2022-04-07 Jones Georgia 13169 5050 108
2379568 2379568 2022-04-06 Jones Georgia 13169 5049 108
2376314 2376314 2022-04-05 Jones Georgia 13169 5049 108
2373062 2373062 2022-04-04 Jones Georgia 13169 5049 108
2369809 2369809 2022-04-03 Jones Georgia 13169 5049 108
2366556 2366556 2022-04-02 Jones Georgia 13169 5049 108
2363303 2363303 2022-04-01 Jones Georgia 13169 5049 108
2360049 2360049 2022-03-31 Jones Georgia 13169 5048 108
2356795 2356795 2022-03-30 Jones Georgia 13169 5047 108
2353542 2353542 2022-03-29 Jones Georgia 13169 5046 108
2350290 2350290 2022-03-28 Jones Georgia 13169 5044 108
2347037 2347037 2022-03-27 Jones Georgia 13169 5042 108
2343784 2343784 2022-03-26 Jones Georgia 13169 5042 108
2340531 2340531 2022-03-25 Jones Georgia 13169 5042 108
2337278 2337278 2022-03-24 Jones Georgia 13169 5040 108
2334024 2334024 2022-03-23 Jones Georgia 13169 5039 108
2330770 2330770 2022-03-22 Jones Georgia 13169 5039 108
2327518 2327518 2022-03-21 Jones Georgia 13169 5034 108
2324265 2324265 2022-03-20 Jones Georgia 13169 5033 108
2321011 2321011 2022-03-19 Jones Georgia 13169 5033 108
2317757 2317757 2022-03-18 Jones Georgia 13169 5033 108
2314504 2314504 2022-03-17 Jones Georgia 13169 5034 108
2311251 2311251 2022-03-16 Jones Georgia 13169 5034 108
2307998 2307998 2022-03-15 Jones Georgia 13169 5031 108
2304747 2304747 2022-03-14 Jones Georgia 13169 5028 108
2301495 2301495 2022-03-13 Jones Georgia 13169 5025 108
2298243 2298243 2022-03-12 Jones Georgia 13169 5025 108
2294991 2294991 2022-03-11 Jones Georgia 13169 5025 108
2291739 2291739 2022-03-10 Jones Georgia 13169 5025 108
2288487 2288487 2022-03-09 Jones Georgia 13169 5023 107
2285236 2285236 2022-03-08 Jones Georgia 13169 5019 107
2281984 2281984 2022-03-07 Jones Georgia 13169 5019 106
2278731 2278731 2022-03-06 Jones Georgia 13169 5015 106
2275478 2275478 2022-03-05 Jones Georgia 13169 5015 106
2272225 2272225 2022-03-04 Jones Georgia 13169 5015 106
2268973 2268973 2022-03-03 Jones Georgia 13169 5014 106
2265720 2265720 2022-03-02 Jones Georgia 13169 5013 106
2262469 2262469 2022-03-01 Jones Georgia 13169 5011 106
2259218 2259218 2022-02-28 Jones Georgia 13169 5009 105
2255967 2255967 2022-02-27 Jones Georgia 13169 5004 105
2252716 2252716 2022-02-26 Jones Georgia 13169 5004 105
2249465 2249465 2022-02-25 Jones Georgia 13169 5004 105
2246214 2246214 2022-02-24 Jones Georgia 13169 5002 105
2242963 2242963 2022-02-23 Jones Georgia 13169 5001 105
2239712 2239712 2022-02-22 Jones Georgia 13169 5001 105
2236461 2236461 2022-02-21 Jones Georgia 13169 4999 104
2233210 2233210 2022-02-20 Jones Georgia 13169 4991 104
2229959 2229959 2022-02-19 Jones Georgia 13169 4991 104
2226708 2226708 2022-02-18 Jones Georgia 13169 4991 104
2223457 2223457 2022-02-17 Jones Georgia 13169 4988 104
2220206 2220206 2022-02-16 Jones Georgia 13169 4984 104
2216955 2216955 2022-02-15 Jones Georgia 13169 4962 104
2213704 2213704 2022-02-14 Jones Georgia 13169 4950 104
2210452 2210452 2022-02-13 Jones Georgia 13169 4945 104
2207199 2207199 2022-02-12 Jones Georgia 13169 4945 104
2203946 2203946 2022-02-11 Jones Georgia 13169 4945 104
2200693 2200693 2022-02-10 Jones Georgia 13169 4932 104
2197439 2197439 2022-02-09 Jones Georgia 13169 4911 104
2194185 2194185 2022-02-08 Jones Georgia 13169 4897 104
2190931 2190931 2022-02-07 Jones Georgia 13169 4887 103
2187678 2187678 2022-02-06 Jones Georgia 13169 4847 103
2184425 2184425 2022-02-05 Jones Georgia 13169 4847 103
2181173 2181173 2022-02-04 Jones Georgia 13169 4847 103
2177922 2177922 2022-02-03 Jones Georgia 13169 4821 103

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