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

779 rows where fips = 22065 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

  • 22065 · 779 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2500731 2500731 2022-05-13 Madison Louisiana 22065 3264 59
2497473 2497473 2022-05-12 Madison Louisiana 22065 3264 59
2494215 2494215 2022-05-11 Madison Louisiana 22065 3262 59
2490957 2490957 2022-05-10 Madison Louisiana 22065 3261 59
2487700 2487700 2022-05-09 Madison Louisiana 22065 3260 59
2484442 2484442 2022-05-08 Madison Louisiana 22065 3259 59
2481184 2481184 2022-05-07 Madison Louisiana 22065 3259 59
2477926 2477926 2022-05-06 Madison Louisiana 22065 3259 59
2474668 2474668 2022-05-05 Madison Louisiana 22065 3259 59
2471411 2471411 2022-05-04 Madison Louisiana 22065 3259 59
2468155 2468155 2022-05-03 Madison Louisiana 22065 3258 59
2464900 2464900 2022-05-02 Madison Louisiana 22065 3258 59
2461644 2461644 2022-05-01 Madison Louisiana 22065 3257 59
2458388 2458388 2022-04-30 Madison Louisiana 22065 3257 59
2455132 2455132 2022-04-29 Madison Louisiana 22065 3257 59
2451876 2451876 2022-04-28 Madison Louisiana 22065 3257 59
2448620 2448620 2022-04-27 Madison Louisiana 22065 3257 59
2445364 2445364 2022-04-26 Madison Louisiana 22065 3257 59
2442108 2442108 2022-04-25 Madison Louisiana 22065 3257 59
2438852 2438852 2022-04-24 Madison Louisiana 22065 3256 59
2435596 2435596 2022-04-23 Madison Louisiana 22065 3256 59
2432340 2432340 2022-04-22 Madison Louisiana 22065 3256 59
2429084 2429084 2022-04-21 Madison Louisiana 22065 3256 59
2425828 2425828 2022-04-20 Madison Louisiana 22065 3256 59
2422572 2422572 2022-04-19 Madison Louisiana 22065 3256 59
2419316 2419316 2022-04-18 Madison Louisiana 22065 3256 59
2416060 2416060 2022-04-17 Madison Louisiana 22065 3256 59
2412804 2412804 2022-04-16 Madison Louisiana 22065 3256 59
2409548 2409548 2022-04-15 Madison Louisiana 22065 3256 59
2406292 2406292 2022-04-14 Madison Louisiana 22065 3256 59
2403036 2403036 2022-04-13 Madison Louisiana 22065 3256 59
2399782 2399782 2022-04-12 Madison Louisiana 22065 3256 59
2396526 2396526 2022-04-11 Madison Louisiana 22065 3256 59
2393271 2393271 2022-04-10 Madison Louisiana 22065 3256 59
2390015 2390015 2022-04-09 Madison Louisiana 22065 3256 59
2386759 2386759 2022-04-08 Madison Louisiana 22065 3256 59
2383504 2383504 2022-04-07 Madison Louisiana 22065 3256 59
2380249 2380249 2022-04-06 Madison Louisiana 22065 3255 59
2376994 2376994 2022-04-05 Madison Louisiana 22065 3255 58
2373742 2373742 2022-04-04 Madison Louisiana 22065 3255 58
2370489 2370489 2022-04-03 Madison Louisiana 22065 3255 58
2367236 2367236 2022-04-02 Madison Louisiana 22065 3255 58
2363983 2363983 2022-04-01 Madison Louisiana 22065 3255 58
2360729 2360729 2022-03-31 Madison Louisiana 22065 3255 58
2357475 2357475 2022-03-30 Madison Louisiana 22065 3255 58
2354222 2354222 2022-03-29 Madison Louisiana 22065 3255 58
2350970 2350970 2022-03-28 Madison Louisiana 22065 3255 58
2347717 2347717 2022-03-27 Madison Louisiana 22065 3255 58
2344464 2344464 2022-03-26 Madison Louisiana 22065 3255 58
2341211 2341211 2022-03-25 Madison Louisiana 22065 3255 58
2337958 2337958 2022-03-24 Madison Louisiana 22065 3255 58
2334704 2334704 2022-03-23 Madison Louisiana 22065 3255 58
2331450 2331450 2022-03-22 Madison Louisiana 22065 3255 58
2328198 2328198 2022-03-21 Madison Louisiana 22065 3255 58
2324945 2324945 2022-03-20 Madison Louisiana 22065 3255 58
2321691 2321691 2022-03-19 Madison Louisiana 22065 3255 58
2318437 2318437 2022-03-18 Madison Louisiana 22065 3255 58
2315184 2315184 2022-03-17 Madison Louisiana 22065 3255 58
2311931 2311931 2022-03-16 Madison Louisiana 22065 3255 58
2308678 2308678 2022-03-15 Madison Louisiana 22065 3255 58
2305427 2305427 2022-03-14 Madison Louisiana 22065 3255 58
2302175 2302175 2022-03-13 Madison Louisiana 22065 3255 58
2298923 2298923 2022-03-12 Madison Louisiana 22065 3255 58
2295671 2295671 2022-03-11 Madison Louisiana 22065 3255 58
2292419 2292419 2022-03-10 Madison Louisiana 22065 3255 58
2289167 2289167 2022-03-09 Madison Louisiana 22065 3255 58
2285916 2285916 2022-03-08 Madison Louisiana 22065 3255 58
2282664 2282664 2022-03-07 Madison Louisiana 22065 3255 58
2279411 2279411 2022-03-06 Madison Louisiana 22065 3255 58
2276158 2276158 2022-03-05 Madison Louisiana 22065 3255 58
2272905 2272905 2022-03-04 Madison Louisiana 22065 3255 58
2269653 2269653 2022-03-03 Madison Louisiana 22065 3252 58
2266400 2266400 2022-03-02 Madison Louisiana 22065 3251 58
2263149 2263149 2022-03-01 Madison Louisiana 22065 3250 58
2259898 2259898 2022-02-28 Madison Louisiana 22065 3250 58
2256647 2256647 2022-02-27 Madison Louisiana 22065 3250 58
2253396 2253396 2022-02-26 Madison Louisiana 22065 3250 58
2250145 2250145 2022-02-25 Madison Louisiana 22065 3250 58
2246894 2246894 2022-02-24 Madison Louisiana 22065 3250 58
2243643 2243643 2022-02-23 Madison Louisiana 22065 3247 58
2240392 2240392 2022-02-22 Madison Louisiana 22065 3246 58
2237141 2237141 2022-02-21 Madison Louisiana 22065 3245 58
2233890 2233890 2022-02-20 Madison Louisiana 22065 3240 58
2230639 2230639 2022-02-19 Madison Louisiana 22065 3240 58
2227388 2227388 2022-02-18 Madison Louisiana 22065 3240 58
2224137 2224137 2022-02-17 Madison Louisiana 22065 3236 58
2220886 2220886 2022-02-16 Madison Louisiana 22065 3232 58
2217635 2217635 2022-02-15 Madison Louisiana 22065 3230 58
2214384 2214384 2022-02-14 Madison Louisiana 22065 3226 58
2211132 2211132 2022-02-13 Madison Louisiana 22065 3209 58
2207879 2207879 2022-02-12 Madison Louisiana 22065 3209 58
2204626 2204626 2022-02-11 Madison Louisiana 22065 3209 58
2201373 2201373 2022-02-10 Madison Louisiana 22065 3202 58
2198119 2198119 2022-02-09 Madison Louisiana 22065 3197 57
2194865 2194865 2022-02-08 Madison Louisiana 22065 3197 57
2191611 2191611 2022-02-07 Madison Louisiana 22065 3194 57
2188358 2188358 2022-02-06 Madison Louisiana 22065 3183 57
2185105 2185105 2022-02-05 Madison Louisiana 22065 3183 57
2181853 2181853 2022-02-04 Madison Louisiana 22065 3183 57
2178602 2178602 2022-02-03 Madison Louisiana 22065 3181 57

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