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

781 rows where county = "Jasper" and fips = 13159 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

  • 13159 · 781 ✖

county 1

  • Jasper · 781 ✖
Link rowid date ▲ county state fips cases deaths
2500044 2500044 2022-05-13 Jasper Georgia 13159 3155 73
2496786 2496786 2022-05-12 Jasper Georgia 13159 3155 73
2493528 2493528 2022-05-11 Jasper Georgia 13159 3155 73
2490270 2490270 2022-05-10 Jasper Georgia 13159 3144 72
2487013 2487013 2022-05-09 Jasper Georgia 13159 3144 72
2483755 2483755 2022-05-08 Jasper Georgia 13159 3143 72
2480497 2480497 2022-05-07 Jasper Georgia 13159 3143 72
2477239 2477239 2022-05-06 Jasper Georgia 13159 3143 72
2473981 2473981 2022-05-05 Jasper Georgia 13159 3143 72
2470724 2470724 2022-05-04 Jasper Georgia 13159 3143 72
2467468 2467468 2022-05-03 Jasper Georgia 13159 3139 72
2464213 2464213 2022-05-02 Jasper Georgia 13159 3139 72
2460957 2460957 2022-05-01 Jasper Georgia 13159 3139 72
2457701 2457701 2022-04-30 Jasper Georgia 13159 3139 72
2454445 2454445 2022-04-29 Jasper Georgia 13159 3139 72
2451189 2451189 2022-04-28 Jasper Georgia 13159 3139 72
2447933 2447933 2022-04-27 Jasper Georgia 13159 3139 72
2444677 2444677 2022-04-26 Jasper Georgia 13159 3133 72
2441421 2441421 2022-04-25 Jasper Georgia 13159 3133 72
2438165 2438165 2022-04-24 Jasper Georgia 13159 3132 72
2434909 2434909 2022-04-23 Jasper Georgia 13159 3132 72
2431653 2431653 2022-04-22 Jasper Georgia 13159 3132 72
2428397 2428397 2022-04-21 Jasper Georgia 13159 3132 72
2425141 2425141 2022-04-20 Jasper Georgia 13159 3132 72
2421885 2421885 2022-04-19 Jasper Georgia 13159 3126 71
2418629 2418629 2022-04-18 Jasper Georgia 13159 3126 71
2415373 2415373 2022-04-17 Jasper Georgia 13159 3126 71
2412117 2412117 2022-04-16 Jasper Georgia 13159 3126 71
2408861 2408861 2022-04-15 Jasper Georgia 13159 3126 71
2405605 2405605 2022-04-14 Jasper Georgia 13159 3126 71
2402350 2402350 2022-04-13 Jasper Georgia 13159 3126 71
2399095 2399095 2022-04-12 Jasper Georgia 13159 3127 71
2395840 2395840 2022-04-11 Jasper Georgia 13159 3127 71
2392584 2392584 2022-04-10 Jasper Georgia 13159 3126 71
2389328 2389328 2022-04-09 Jasper Georgia 13159 3126 71
2386073 2386073 2022-04-08 Jasper Georgia 13159 3126 71
2382818 2382818 2022-04-07 Jasper Georgia 13159 3126 71
2379563 2379563 2022-04-06 Jasper Georgia 13159 3127 71
2376309 2376309 2022-04-05 Jasper Georgia 13159 3129 71
2373057 2373057 2022-04-04 Jasper Georgia 13159 3128 71
2369804 2369804 2022-04-03 Jasper Georgia 13159 3127 70
2366551 2366551 2022-04-02 Jasper Georgia 13159 3127 70
2363298 2363298 2022-04-01 Jasper Georgia 13159 3127 70
2360044 2360044 2022-03-31 Jasper Georgia 13159 3127 70
2356790 2356790 2022-03-30 Jasper Georgia 13159 3125 70
2353537 2353537 2022-03-29 Jasper Georgia 13159 3121 70
2350285 2350285 2022-03-28 Jasper Georgia 13159 3120 70
2347032 2347032 2022-03-27 Jasper Georgia 13159 3120 70
2343779 2343779 2022-03-26 Jasper Georgia 13159 3120 70
2340526 2340526 2022-03-25 Jasper Georgia 13159 3120 70
2337273 2337273 2022-03-24 Jasper Georgia 13159 3120 69
2334019 2334019 2022-03-23 Jasper Georgia 13159 3120 69
2330765 2330765 2022-03-22 Jasper Georgia 13159 3120 69
2327513 2327513 2022-03-21 Jasper Georgia 13159 3120 69
2324260 2324260 2022-03-20 Jasper Georgia 13159 3120 69
2321006 2321006 2022-03-19 Jasper Georgia 13159 3120 69
2317752 2317752 2022-03-18 Jasper Georgia 13159 3120 69
2314499 2314499 2022-03-17 Jasper Georgia 13159 3118 69
2311246 2311246 2022-03-16 Jasper Georgia 13159 3115 68
2307993 2307993 2022-03-15 Jasper Georgia 13159 3115 68
2304742 2304742 2022-03-14 Jasper Georgia 13159 3115 68
2301490 2301490 2022-03-13 Jasper Georgia 13159 3114 68
2298238 2298238 2022-03-12 Jasper Georgia 13159 3114 68
2294986 2294986 2022-03-11 Jasper Georgia 13159 3114 68
2291734 2291734 2022-03-10 Jasper Georgia 13159 3114 68
2288482 2288482 2022-03-09 Jasper Georgia 13159 3115 68
2285231 2285231 2022-03-08 Jasper Georgia 13159 3115 68
2281979 2281979 2022-03-07 Jasper Georgia 13159 3114 68
2278726 2278726 2022-03-06 Jasper Georgia 13159 3111 68
2275473 2275473 2022-03-05 Jasper Georgia 13159 3111 68
2272220 2272220 2022-03-04 Jasper Georgia 13159 3111 68
2268968 2268968 2022-03-03 Jasper Georgia 13159 3109 68
2265715 2265715 2022-03-02 Jasper Georgia 13159 3106 68
2262464 2262464 2022-03-01 Jasper Georgia 13159 3105 68
2259213 2259213 2022-02-28 Jasper Georgia 13159 3104 68
2255962 2255962 2022-02-27 Jasper Georgia 13159 3103 68
2252711 2252711 2022-02-26 Jasper Georgia 13159 3103 68
2249460 2249460 2022-02-25 Jasper Georgia 13159 3103 68
2246209 2246209 2022-02-24 Jasper Georgia 13159 3100 68
2242958 2242958 2022-02-23 Jasper Georgia 13159 3099 68
2239707 2239707 2022-02-22 Jasper Georgia 13159 3095 68
2236456 2236456 2022-02-21 Jasper Georgia 13159 3093 68
2233205 2233205 2022-02-20 Jasper Georgia 13159 3090 68
2229954 2229954 2022-02-19 Jasper Georgia 13159 3090 68
2226703 2226703 2022-02-18 Jasper Georgia 13159 3090 68
2223452 2223452 2022-02-17 Jasper Georgia 13159 3087 68
2220201 2220201 2022-02-16 Jasper Georgia 13159 3083 68
2216950 2216950 2022-02-15 Jasper Georgia 13159 3082 68
2213699 2213699 2022-02-14 Jasper Georgia 13159 3080 68
2210447 2210447 2022-02-13 Jasper Georgia 13159 3074 68
2207194 2207194 2022-02-12 Jasper Georgia 13159 3074 68
2203941 2203941 2022-02-11 Jasper Georgia 13159 3074 68
2200688 2200688 2022-02-10 Jasper Georgia 13159 3070 68
2197434 2197434 2022-02-09 Jasper Georgia 13159 3067 68
2194180 2194180 2022-02-08 Jasper Georgia 13159 3063 68
2190926 2190926 2022-02-07 Jasper Georgia 13159 3055 68
2187673 2187673 2022-02-06 Jasper Georgia 13159 3039 68
2184420 2184420 2022-02-05 Jasper Georgia 13159 3039 68
2181168 2181168 2022-02-04 Jasper Georgia 13159 3039 68
2177917 2177917 2022-02-03 Jasper Georgia 13159 3027 68

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