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

766 rows where county = "Lafayette" and state = "Florida" sorted by date descending

✎ View and edit SQL

This data as json, yaml, Notebook, copyable, CSV (advanced)

Suggested facets: date (date)

state 1

  • Florida · 766 ✖

fips 1

county 1

  • Lafayette · 766 ✖
Link rowid date ▲ county state fips cases deaths
2499930 2499930 2022-05-13 Lafayette Florida 12067 2780 61
2496672 2496672 2022-05-12 Lafayette Florida 12067 2780 61
2493414 2493414 2022-05-11 Lafayette Florida 12067 2780 61
2490156 2490156 2022-05-10 Lafayette Florida 12067 2780 61
2486899 2486899 2022-05-09 Lafayette Florida 12067 2780 61
2483641 2483641 2022-05-08 Lafayette Florida 12067 2780 61
2480383 2480383 2022-05-07 Lafayette Florida 12067 2780 61
2477125 2477125 2022-05-06 Lafayette Florida 12067 2780 61
2473867 2473867 2022-05-05 Lafayette Florida 12067 2779 61
2470610 2470610 2022-05-04 Lafayette Florida 12067 2779 61
2467354 2467354 2022-05-03 Lafayette Florida 12067 2779 61
2464099 2464099 2022-05-02 Lafayette Florida 12067 2779 61
2460843 2460843 2022-05-01 Lafayette Florida 12067 2779 61
2457587 2457587 2022-04-30 Lafayette Florida 12067 2779 61
2454331 2454331 2022-04-29 Lafayette Florida 12067 2779 61
2451075 2451075 2022-04-28 Lafayette Florida 12067 2779 61
2447819 2447819 2022-04-27 Lafayette Florida 12067 2779 61
2444563 2444563 2022-04-26 Lafayette Florida 12067 2779 61
2441307 2441307 2022-04-25 Lafayette Florida 12067 2779 61
2438051 2438051 2022-04-24 Lafayette Florida 12067 2779 61
2434795 2434795 2022-04-23 Lafayette Florida 12067 2779 61
2431539 2431539 2022-04-22 Lafayette Florida 12067 2779 61
2428283 2428283 2022-04-21 Lafayette Florida 12067 2776 61
2425027 2425027 2022-04-20 Lafayette Florida 12067 2776 61
2421771 2421771 2022-04-19 Lafayette Florida 12067 2776 61
2418515 2418515 2022-04-18 Lafayette Florida 12067 2776 61
2415259 2415259 2022-04-17 Lafayette Florida 12067 2776 61
2412003 2412003 2022-04-16 Lafayette Florida 12067 2776 61
2408747 2408747 2022-04-15 Lafayette Florida 12067 2776 61
2405491 2405491 2022-04-14 Lafayette Florida 12067 2776 61
2402236 2402236 2022-04-13 Lafayette Florida 12067 2776 61
2398981 2398981 2022-04-12 Lafayette Florida 12067 2776 60
2395726 2395726 2022-04-11 Lafayette Florida 12067 2776 60
2392470 2392470 2022-04-10 Lafayette Florida 12067 2776 60
2389214 2389214 2022-04-09 Lafayette Florida 12067 2776 60
2385959 2385959 2022-04-08 Lafayette Florida 12067 2776 60
2382704 2382704 2022-04-07 Lafayette Florida 12067 2776 60
2379449 2379449 2022-04-06 Lafayette Florida 12067 2776 60
2376195 2376195 2022-04-05 Lafayette Florida 12067 2776 59
2372943 2372943 2022-04-04 Lafayette Florida 12067 2776 59
2369690 2369690 2022-04-03 Lafayette Florida 12067 2776 59
2366437 2366437 2022-04-02 Lafayette Florida 12067 2776 59
2363184 2363184 2022-04-01 Lafayette Florida 12067 2776 59
2359930 2359930 2022-03-31 Lafayette Florida 12067 2776 59
2356676 2356676 2022-03-30 Lafayette Florida 12067 2776 59
2353423 2353423 2022-03-29 Lafayette Florida 12067 2776 58
2350171 2350171 2022-03-28 Lafayette Florida 12067 2776 58
2346918 2346918 2022-03-27 Lafayette Florida 12067 2776 58
2343665 2343665 2022-03-26 Lafayette Florida 12067 2776 58
2340412 2340412 2022-03-25 Lafayette Florida 12067 2776 58
2337159 2337159 2022-03-24 Lafayette Florida 12067 2769 58
2333905 2333905 2022-03-23 Lafayette Florida 12067 2769 57
2330651 2330651 2022-03-22 Lafayette Florida 12067 2769 57
2327399 2327399 2022-03-21 Lafayette Florida 12067 2769 57
2324146 2324146 2022-03-20 Lafayette Florida 12067 2769 57
2320892 2320892 2022-03-19 Lafayette Florida 12067 2769 57
2317638 2317638 2022-03-18 Lafayette Florida 12067 2769 57
2314385 2314385 2022-03-17 Lafayette Florida 12067 2769 57
2311132 2311132 2022-03-16 Lafayette Florida 12067 2769 57
2307879 2307879 2022-03-15 Lafayette Florida 12067 2769 56
2304628 2304628 2022-03-14 Lafayette Florida 12067 2769 56
2301376 2301376 2022-03-13 Lafayette Florida 12067 2769 56
2298124 2298124 2022-03-12 Lafayette Florida 12067 2769 56
2294872 2294872 2022-03-11 Lafayette Florida 12067 2769 56
2291620 2291620 2022-03-10 Lafayette Florida 12067 2765 56
2288368 2288368 2022-03-09 Lafayette Florida 12067 2765 56
2285117 2285117 2022-03-08 Lafayette Florida 12067 2765 55
2281865 2281865 2022-03-07 Lafayette Florida 12067 2765 55
2278612 2278612 2022-03-06 Lafayette Florida 12067 2765 55
2275359 2275359 2022-03-05 Lafayette Florida 12067 2765 55
2272106 2272106 2022-03-04 Lafayette Florida 12067 2765 55
2268854 2268854 2022-03-03 Lafayette Florida 12067 2759 55
2265601 2265601 2022-03-02 Lafayette Florida 12067 2759 55
2262350 2262350 2022-03-01 Lafayette Florida 12067 2759 51
2259099 2259099 2022-02-28 Lafayette Florida 12067 2759 51
2255848 2255848 2022-02-27 Lafayette Florida 12067 2759 51
2252597 2252597 2022-02-26 Lafayette Florida 12067 2759 51
2249346 2249346 2022-02-25 Lafayette Florida 12067 2759 51
2246095 2246095 2022-02-24 Lafayette Florida 12067 2746 51
2242844 2242844 2022-02-23 Lafayette Florida 12067 2746 51
2239593 2239593 2022-02-22 Lafayette Florida 12067 2746 52
2236342 2236342 2022-02-21 Lafayette Florida 12067 2746 52
2233091 2233091 2022-02-20 Lafayette Florida 12067 2746 52
2229840 2229840 2022-02-19 Lafayette Florida 12067 2746 52
2226589 2226589 2022-02-18 Lafayette Florida 12067 2746 52
2223338 2223338 2022-02-17 Lafayette Florida 12067 2721 52
2220087 2220087 2022-02-16 Lafayette Florida 12067 2721 52
2216836 2216836 2022-02-15 Lafayette Florida 12067 2721 52
2213585 2213585 2022-02-14 Lafayette Florida 12067 2721 52
2210333 2210333 2022-02-13 Lafayette Florida 12067 2721 52
2207080 2207080 2022-02-12 Lafayette Florida 12067 2721 52
2203827 2203827 2022-02-11 Lafayette Florida 12067 2721 52
2200574 2200574 2022-02-10 Lafayette Florida 12067 2655 52
2197320 2197320 2022-02-09 Lafayette Florida 12067 2655 52
2194066 2194066 2022-02-08 Lafayette Florida 12067 2655 52
2190812 2190812 2022-02-07 Lafayette Florida 12067 2655 52
2187559 2187559 2022-02-06 Lafayette Florida 12067 2655 52
2184306 2184306 2022-02-05 Lafayette Florida 12067 2655 52
2181054 2181054 2022-02-04 Lafayette Florida 12067 2655 52
2177803 2177803 2022-02-03 Lafayette Florida 12067 2580 52

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