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

797 rows where county = "Fairfield", fips = 9001 and state = "Connecticut" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Connecticut · 797 ✖

fips 1

  • 9001 · 797 ✖

county 1

  • Fairfield · 797 ✖
Link rowid date ▲ county state fips cases deaths
2499884 2499884 2022-05-13 Fairfield Connecticut 9001 214106 2733
2496626 2496626 2022-05-12 Fairfield Connecticut 9001 213432 2725
2493368 2493368 2022-05-11 Fairfield Connecticut 9001 213009 2725
2490110 2490110 2022-05-10 Fairfield Connecticut 9001 212518 2725
2486853 2486853 2022-05-09 Fairfield Connecticut 9001 212056 2723
2483595 2483595 2022-05-08 Fairfield Connecticut 9001 210830 2723
2480337 2480337 2022-05-07 Fairfield Connecticut 9001 210830 2723
2477079 2477079 2022-05-06 Fairfield Connecticut 9001 210830 2723
2473821 2473821 2022-05-05 Fairfield Connecticut 9001 210521 2721
2470564 2470564 2022-05-04 Fairfield Connecticut 9001 210120 2721
2467308 2467308 2022-05-03 Fairfield Connecticut 9001 209878 2720
2464053 2464053 2022-05-02 Fairfield Connecticut 9001 209399 2718
2460797 2460797 2022-05-01 Fairfield Connecticut 9001 208790 2717
2457541 2457541 2022-04-30 Fairfield Connecticut 9001 208790 2717
2454285 2454285 2022-04-29 Fairfield Connecticut 9001 208790 2717
2451029 2451029 2022-04-28 Fairfield Connecticut 9001 208537 2717
2447773 2447773 2022-04-27 Fairfield Connecticut 9001 208202 2716
2444517 2444517 2022-04-26 Fairfield Connecticut 9001 207943 2716
2441261 2441261 2022-04-25 Fairfield Connecticut 9001 207639 2714
2438005 2438005 2022-04-24 Fairfield Connecticut 9001 207102 2714
2434749 2434749 2022-04-23 Fairfield Connecticut 9001 207102 2714
2431493 2431493 2022-04-22 Fairfield Connecticut 9001 207102 2714
2428237 2428237 2022-04-21 Fairfield Connecticut 9001 206776 2711
2424981 2424981 2022-04-20 Fairfield Connecticut 9001 206516 2711
2421725 2421725 2022-04-19 Fairfield Connecticut 9001 206262 2707
2418469 2418469 2022-04-18 Fairfield Connecticut 9001 205991 2706
2415213 2415213 2022-04-17 Fairfield Connecticut 9001 205283 2706
2411957 2411957 2022-04-16 Fairfield Connecticut 9001 205283 2706
2408701 2408701 2022-04-15 Fairfield Connecticut 9001 205283 2706
2405445 2405445 2022-04-14 Fairfield Connecticut 9001 204868 2704
2402190 2402190 2022-04-13 Fairfield Connecticut 9001 204732 2704
2398935 2398935 2022-04-12 Fairfield Connecticut 9001 204516 2703
2395680 2395680 2022-04-11 Fairfield Connecticut 9001 204191 2701
2392424 2392424 2022-04-10 Fairfield Connecticut 9001 203593 2701
2389168 2389168 2022-04-09 Fairfield Connecticut 9001 203593 2701
2385913 2385913 2022-04-08 Fairfield Connecticut 9001 203593 2701
2382658 2382658 2022-04-07 Fairfield Connecticut 9001 203279 2699
2379403 2379403 2022-04-06 Fairfield Connecticut 9001 203001 2699
2376149 2376149 2022-04-05 Fairfield Connecticut 9001 202854 2699
2372897 2372897 2022-04-04 Fairfield Connecticut 9001 202689 2693
2369644 2369644 2022-04-03 Fairfield Connecticut 9001 202314 2693
2366391 2366391 2022-04-02 Fairfield Connecticut 9001 202314 2693
2363138 2363138 2022-04-01 Fairfield Connecticut 9001 202314 2693
2359884 2359884 2022-03-31 Fairfield Connecticut 9001 202152 2693
2356630 2356630 2022-03-30 Fairfield Connecticut 9001 201737 2693
2353377 2353377 2022-03-29 Fairfield Connecticut 9001 201596 2693
2350125 2350125 2022-03-28 Fairfield Connecticut 9001 201502 2691
2346872 2346872 2022-03-27 Fairfield Connecticut 9001 201183 2691
2343619 2343619 2022-03-26 Fairfield Connecticut 9001 201183 2691
2340366 2340366 2022-03-25 Fairfield Connecticut 9001 201183 2691
2337113 2337113 2022-03-24 Fairfield Connecticut 9001 201048 2687
2333859 2333859 2022-03-23 Fairfield Connecticut 9001 200891 2686
2330605 2330605 2022-03-22 Fairfield Connecticut 9001 200786 2686
2327353 2327353 2022-03-21 Fairfield Connecticut 9001 200642 2684
2324100 2324100 2022-03-20 Fairfield Connecticut 9001 200481 2684
2320846 2320846 2022-03-19 Fairfield Connecticut 9001 200481 2684
2317592 2317592 2022-03-18 Fairfield Connecticut 9001 200481 2684
2314339 2314339 2022-03-17 Fairfield Connecticut 9001 200403 2673
2311086 2311086 2022-03-16 Fairfield Connecticut 9001 200265 2673
2307833 2307833 2022-03-15 Fairfield Connecticut 9001 200186 2673
2304582 2304582 2022-03-14 Fairfield Connecticut 9001 200091 2668
2301330 2301330 2022-03-13 Fairfield Connecticut 9001 199851 2668
2298078 2298078 2022-03-12 Fairfield Connecticut 9001 199851 2668
2294826 2294826 2022-03-11 Fairfield Connecticut 9001 199851 2668
2291574 2291574 2022-03-10 Fairfield Connecticut 9001 199775 2663
2288322 2288322 2022-03-09 Fairfield Connecticut 9001 199692 2662
2285071 2285071 2022-03-08 Fairfield Connecticut 9001 199642 2653
2281819 2281819 2022-03-07 Fairfield Connecticut 9001 199323 2645
2278566 2278566 2022-03-06 Fairfield Connecticut 9001 198583 2649
2275313 2275313 2022-03-05 Fairfield Connecticut 9001 198583 2649
2272060 2272060 2022-03-04 Fairfield Connecticut 9001 198583 2649
2268808 2268808 2022-03-03 Fairfield Connecticut 9001 198498 2644
2265555 2265555 2022-03-02 Fairfield Connecticut 9001 198301 2644
2262304 2262304 2022-03-01 Fairfield Connecticut 9001 198268 2638
2259053 2259053 2022-02-28 Fairfield Connecticut 9001 198201 2637
2255802 2255802 2022-02-27 Fairfield Connecticut 9001 197958 2637
2252551 2252551 2022-02-26 Fairfield Connecticut 9001 197958 2637
2249300 2249300 2022-02-25 Fairfield Connecticut 9001 197958 2637
2246049 2246049 2022-02-24 Fairfield Connecticut 9001 197830 2635
2242798 2242798 2022-02-23 Fairfield Connecticut 9001 197774 2634
2239547 2239547 2022-02-22 Fairfield Connecticut 9001 197661 2621
2236296 2236296 2022-02-21 Fairfield Connecticut 9001 197585 2621
2233045 2233045 2022-02-20 Fairfield Connecticut 9001 197325 2614
2229794 2229794 2022-02-19 Fairfield Connecticut 9001 197325 2614
2226543 2226543 2022-02-18 Fairfield Connecticut 9001 197325 2614
2223292 2223292 2022-02-17 Fairfield Connecticut 9001 197116 2610
2220041 2220041 2022-02-16 Fairfield Connecticut 9001 196996 2610
2216790 2216790 2022-02-15 Fairfield Connecticut 9001 196835 2609
2213539 2213539 2022-02-14 Fairfield Connecticut 9001 196644 2603
2210287 2210287 2022-02-13 Fairfield Connecticut 9001 196221 2603
2207034 2207034 2022-02-12 Fairfield Connecticut 9001 196221 2603
2203781 2203781 2022-02-11 Fairfield Connecticut 9001 196221 2603
2200528 2200528 2022-02-10 Fairfield Connecticut 9001 196035 2593
2197274 2197274 2022-02-09 Fairfield Connecticut 9001 195800 2592
2194020 2194020 2022-02-08 Fairfield Connecticut 9001 195518 2581
2190766 2190766 2022-02-07 Fairfield Connecticut 9001 195214 2581
2187513 2187513 2022-02-06 Fairfield Connecticut 9001 194725 2580
2184260 2184260 2022-02-05 Fairfield Connecticut 9001 194725 2580
2181008 2181008 2022-02-04 Fairfield Connecticut 9001 194725 2580
2177757 2177757 2022-02-03 Fairfield Connecticut 9001 194466 2564

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