ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
775 rows where county = "Unknown" and state = "Connecticut" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
| Link | rowid | date ▲ | county | state | fips | cases | deaths |
|---|---|---|---|---|---|---|---|
| 2499891 | 2499891 | 2022-05-13 | Unknown | Connecticut | 2397 | 1 | |
| 2496633 | 2496633 | 2022-05-12 | Unknown | Connecticut | 2375 | 1 | |
| 2493375 | 2493375 | 2022-05-11 | Unknown | Connecticut | 2368 | 1 | |
| 2490117 | 2490117 | 2022-05-10 | Unknown | Connecticut | 2347 | 1 | |
| 2486860 | 2486860 | 2022-05-09 | Unknown | Connecticut | 2338 | 1 | |
| 2483602 | 2483602 | 2022-05-08 | Unknown | Connecticut | 2320 | 1 | |
| 2480344 | 2480344 | 2022-05-07 | Unknown | Connecticut | 2320 | 1 | |
| 2477086 | 2477086 | 2022-05-06 | Unknown | Connecticut | 2320 | 1 | |
| 2473828 | 2473828 | 2022-05-05 | Unknown | Connecticut | 2310 | 1 | |
| 2470571 | 2470571 | 2022-05-04 | Unknown | Connecticut | 2301 | 1 | |
| 2467315 | 2467315 | 2022-05-03 | Unknown | Connecticut | 2295 | 1 | |
| 2464060 | 2464060 | 2022-05-02 | Unknown | Connecticut | 2291 | 2 | |
| 2460804 | 2460804 | 2022-05-01 | Unknown | Connecticut | 2277 | 2 | |
| 2457548 | 2457548 | 2022-04-30 | Unknown | Connecticut | 2277 | 2 | |
| 2454292 | 2454292 | 2022-04-29 | Unknown | Connecticut | 2277 | 2 | |
| 2451036 | 2451036 | 2022-04-28 | Unknown | Connecticut | 2275 | 1 | |
| 2447780 | 2447780 | 2022-04-27 | Unknown | Connecticut | 2270 | 1 | |
| 2444524 | 2444524 | 2022-04-26 | Unknown | Connecticut | 2266 | 1 | |
| 2441268 | 2441268 | 2022-04-25 | Unknown | Connecticut | 2260 | 1 | |
| 2438012 | 2438012 | 2022-04-24 | Unknown | Connecticut | 2246 | 1 | |
| 2434756 | 2434756 | 2022-04-23 | Unknown | Connecticut | 2246 | 1 | |
| 2431500 | 2431500 | 2022-04-22 | Unknown | Connecticut | 2246 | 1 | |
| 2428244 | 2428244 | 2022-04-21 | Unknown | Connecticut | 2237 | 1 | |
| 2424988 | 2424988 | 2022-04-20 | Unknown | Connecticut | 2231 | 1 | |
| 2421732 | 2421732 | 2022-04-19 | Unknown | Connecticut | 2223 | 1 | |
| 2418476 | 2418476 | 2022-04-18 | Unknown | Connecticut | 2218 | 1 | |
| 2415220 | 2415220 | 2022-04-17 | Unknown | Connecticut | 2210 | 1 | |
| 2411964 | 2411964 | 2022-04-16 | Unknown | Connecticut | 2210 | 1 | |
| 2408708 | 2408708 | 2022-04-15 | Unknown | Connecticut | 2210 | 1 | |
| 2405452 | 2405452 | 2022-04-14 | Unknown | Connecticut | 2204 | 1 | |
| 2402197 | 2402197 | 2022-04-13 | Unknown | Connecticut | 2211 | 1 | |
| 2398942 | 2398942 | 2022-04-12 | Unknown | Connecticut | 2235 | 1 | |
| 2395687 | 2395687 | 2022-04-11 | Unknown | Connecticut | 2614 | 1 | |
| 2392431 | 2392431 | 2022-04-10 | Unknown | Connecticut | 2597 | 1 | |
| 2389175 | 2389175 | 2022-04-09 | Unknown | Connecticut | 2597 | 1 | |
| 2385920 | 2385920 | 2022-04-08 | Unknown | Connecticut | 2597 | 1 | |
| 2382665 | 2382665 | 2022-04-07 | Unknown | Connecticut | 2790 | 1 | |
| 2379410 | 2379410 | 2022-04-06 | Unknown | Connecticut | 2885 | 1 | |
| 2376156 | 2376156 | 2022-04-05 | Unknown | Connecticut | 2876 | 1 | |
| 2372904 | 2372904 | 2022-04-04 | Unknown | Connecticut | 2874 | 1 | |
| 2369651 | 2369651 | 2022-04-03 | Unknown | Connecticut | 2872 | 1 | |
| 2366398 | 2366398 | 2022-04-02 | Unknown | Connecticut | 2872 | 1 | |
| 2363145 | 2363145 | 2022-04-01 | Unknown | Connecticut | 2872 | 1 | |
| 2359891 | 2359891 | 2022-03-31 | Unknown | Connecticut | 2868 | 1 | |
| 2356637 | 2356637 | 2022-03-30 | Unknown | Connecticut | 2872 | 10 | |
| 2353384 | 2353384 | 2022-03-29 | Unknown | Connecticut | 2865 | 10 | |
| 2350132 | 2350132 | 2022-03-28 | Unknown | Connecticut | 2863 | 10 | |
| 2346879 | 2346879 | 2022-03-27 | Unknown | Connecticut | 2864 | 10 | |
| 2343626 | 2343626 | 2022-03-26 | Unknown | Connecticut | 2864 | 10 | |
| 2340373 | 2340373 | 2022-03-25 | Unknown | Connecticut | 2864 | 10 | |
| 2337120 | 2337120 | 2022-03-24 | Unknown | Connecticut | 2861 | 10 | |
| 2333866 | 2333866 | 2022-03-23 | Unknown | Connecticut | 2862 | 10 | |
| 2330612 | 2330612 | 2022-03-22 | Unknown | Connecticut | 2852 | 10 | |
| 2327360 | 2327360 | 2022-03-21 | Unknown | Connecticut | 2854 | 9 | |
| 2324107 | 2324107 | 2022-03-20 | Unknown | Connecticut | 2844 | 9 | |
| 2320853 | 2320853 | 2022-03-19 | Unknown | Connecticut | 2844 | 9 | |
| 2317599 | 2317599 | 2022-03-18 | Unknown | Connecticut | 2844 | 9 | |
| 2314346 | 2314346 | 2022-03-17 | Unknown | Connecticut | 2840 | 8 | |
| 2311093 | 2311093 | 2022-03-16 | Unknown | Connecticut | 2842 | 8 | |
| 2307840 | 2307840 | 2022-03-15 | Unknown | Connecticut | 2838 | 8 | |
| 2304589 | 2304589 | 2022-03-14 | Unknown | Connecticut | 2835 | 7 | |
| 2301337 | 2301337 | 2022-03-13 | Unknown | Connecticut | 2831 | 7 | |
| 2298085 | 2298085 | 2022-03-12 | Unknown | Connecticut | 2831 | 7 | |
| 2294833 | 2294833 | 2022-03-11 | Unknown | Connecticut | 2831 | 7 | |
| 2291581 | 2291581 | 2022-03-10 | Unknown | Connecticut | 2830 | 7 | |
| 2288329 | 2288329 | 2022-03-09 | Unknown | Connecticut | 2828 | 6 | |
| 2285078 | 2285078 | 2022-03-08 | Unknown | Connecticut | 2825 | 6 | |
| 2281826 | 2281826 | 2022-03-07 | Unknown | Connecticut | 2823 | 5 | |
| 2278573 | 2278573 | 2022-03-06 | Unknown | Connecticut | 2808 | 5 | |
| 2275320 | 2275320 | 2022-03-05 | Unknown | Connecticut | 2808 | 5 | |
| 2272067 | 2272067 | 2022-03-04 | Unknown | Connecticut | 2808 | 5 | |
| 2268815 | 2268815 | 2022-03-03 | Unknown | Connecticut | 2799 | 4 | |
| 2265562 | 2265562 | 2022-03-02 | Unknown | Connecticut | 2796 | 3 | |
| 2262311 | 2262311 | 2022-03-01 | Unknown | Connecticut | 2797 | 3 | |
| 2259060 | 2259060 | 2022-02-28 | Unknown | Connecticut | 2796 | 3 | |
| 2255809 | 2255809 | 2022-02-27 | Unknown | Connecticut | 2793 | 3 | |
| 2252558 | 2252558 | 2022-02-26 | Unknown | Connecticut | 2793 | 3 | |
| 2249307 | 2249307 | 2022-02-25 | Unknown | Connecticut | 2793 | 3 | |
| 2246056 | 2246056 | 2022-02-24 | Unknown | Connecticut | 2784 | 1 | |
| 2242805 | 2242805 | 2022-02-23 | Unknown | Connecticut | 2780 | 1 | |
| 2239554 | 2239554 | 2022-02-22 | Unknown | Connecticut | 2775 | 0 | |
| 2236303 | 2236303 | 2022-02-21 | Unknown | Connecticut | 2778 | 0 | |
| 2233052 | 2233052 | 2022-02-20 | Unknown | Connecticut | 2767 | 0 | |
| 2229801 | 2229801 | 2022-02-19 | Unknown | Connecticut | 2767 | 0 | |
| 2226550 | 2226550 | 2022-02-18 | Unknown | Connecticut | 2767 | 0 | |
| 2223299 | 2223299 | 2022-02-17 | Unknown | Connecticut | 2759 | 0 | |
| 2220048 | 2220048 | 2022-02-16 | Unknown | Connecticut | 2760 | 0 | |
| 2216797 | 2216797 | 2022-02-15 | Unknown | Connecticut | 2754 | 0 | |
| 2213546 | 2213546 | 2022-02-14 | Unknown | Connecticut | 2750 | 0 | |
| 2210294 | 2210294 | 2022-02-13 | Unknown | Connecticut | 2739 | 0 | |
| 2207041 | 2207041 | 2022-02-12 | Unknown | Connecticut | 2739 | 0 | |
| 2203788 | 2203788 | 2022-02-11 | Unknown | Connecticut | 2739 | 0 | |
| 2200535 | 2200535 | 2022-02-10 | Unknown | Connecticut | 2733 | 0 | |
| 2197281 | 2197281 | 2022-02-09 | Unknown | Connecticut | 2735 | 1 | |
| 2194027 | 2194027 | 2022-02-08 | Unknown | Connecticut | 2720 | 0 | |
| 2190773 | 2190773 | 2022-02-07 | Unknown | Connecticut | 2713 | 0 | |
| 2187520 | 2187520 | 2022-02-06 | Unknown | Connecticut | 2704 | 1 | |
| 2184267 | 2184267 | 2022-02-05 | Unknown | Connecticut | 2704 | 1 | |
| 2181015 | 2181015 | 2022-02-04 | Unknown | Connecticut | 2704 | 1 | |
| 2177764 | 2177764 | 2022-02-03 | Unknown | Connecticut | 2702 | 0 |
Advanced export
JSON shape: default, array, newline-delimited
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);