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

785 rows where county = "New London" 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 · 785 ✖

fips 1

county 1

  • New London · 785 ✖
Link rowid date ▲ county state fips cases deaths
2499889 2499889 2022-05-13 New London Connecticut 9011 58138 662
2496631 2496631 2022-05-12 New London Connecticut 9011 57958 660
2493373 2493373 2022-05-11 New London Connecticut 9011 57803 660
2490115 2490115 2022-05-10 New London Connecticut 9011 57604 660
2486858 2486858 2022-05-09 New London Connecticut 9011 57454 660
2483600 2483600 2022-05-08 New London Connecticut 9011 57081 660
2480342 2480342 2022-05-07 New London Connecticut 9011 57081 660
2477084 2477084 2022-05-06 New London Connecticut 9011 57081 660
2473826 2473826 2022-05-05 New London Connecticut 9011 56984 659
2470569 2470569 2022-05-04 New London Connecticut 9011 56880 659
2467313 2467313 2022-05-03 New London Connecticut 9011 56816 659
2464058 2464058 2022-05-02 New London Connecticut 9011 56707 658
2460802 2460802 2022-05-01 New London Connecticut 9011 56500 658
2457546 2457546 2022-04-30 New London Connecticut 9011 56500 658
2454290 2454290 2022-04-29 New London Connecticut 9011 56500 658
2451034 2451034 2022-04-28 New London Connecticut 9011 56391 658
2447778 2447778 2022-04-27 New London Connecticut 9011 56268 658
2444522 2444522 2022-04-26 New London Connecticut 9011 56161 658
2441266 2441266 2022-04-25 New London Connecticut 9011 56071 657
2438010 2438010 2022-04-24 New London Connecticut 9011 55880 657
2434754 2434754 2022-04-23 New London Connecticut 9011 55880 657
2431498 2431498 2022-04-22 New London Connecticut 9011 55880 657
2428242 2428242 2022-04-21 New London Connecticut 9011 55796 657
2424986 2424986 2022-04-20 New London Connecticut 9011 55721 657
2421730 2421730 2022-04-19 New London Connecticut 9011 55618 657
2418474 2418474 2022-04-18 New London Connecticut 9011 55558 657
2415218 2415218 2022-04-17 New London Connecticut 9011 55412 657
2411962 2411962 2022-04-16 New London Connecticut 9011 55412 657
2408706 2408706 2022-04-15 New London Connecticut 9011 55412 657
2405450 2405450 2022-04-14 New London Connecticut 9011 55324 657
2402195 2402195 2022-04-13 New London Connecticut 9011 55300 657
2398940 2398940 2022-04-12 New London Connecticut 9011 55232 657
2395685 2395685 2022-04-11 New London Connecticut 9011 55101 657
2392429 2392429 2022-04-10 New London Connecticut 9011 54968 657
2389173 2389173 2022-04-09 New London Connecticut 9011 54968 657
2385918 2385918 2022-04-08 New London Connecticut 9011 54968 657
2382663 2382663 2022-04-07 New London Connecticut 9011 54875 656
2379408 2379408 2022-04-06 New London Connecticut 9011 54758 656
2376154 2376154 2022-04-05 New London Connecticut 9011 54725 655
2372902 2372902 2022-04-04 New London Connecticut 9011 54700 653
2369649 2369649 2022-04-03 New London Connecticut 9011 54607 653
2366396 2366396 2022-04-02 New London Connecticut 9011 54607 653
2363143 2363143 2022-04-01 New London Connecticut 9011 54607 653
2359889 2359889 2022-03-31 New London Connecticut 9011 54580 653
2356635 2356635 2022-03-30 New London Connecticut 9011 54543 651
2353382 2353382 2022-03-29 New London Connecticut 9011 54505 651
2350130 2350130 2022-03-28 New London Connecticut 9011 54484 648
2346877 2346877 2022-03-27 New London Connecticut 9011 54414 648
2343624 2343624 2022-03-26 New London Connecticut 9011 54414 648
2340371 2340371 2022-03-25 New London Connecticut 9011 54414 648
2337118 2337118 2022-03-24 New London Connecticut 9011 54384 647
2333864 2333864 2022-03-23 New London Connecticut 9011 54361 647
2330610 2330610 2022-03-22 New London Connecticut 9011 54327 647
2327358 2327358 2022-03-21 New London Connecticut 9011 54284 647
2324105 2324105 2022-03-20 New London Connecticut 9011 54240 646
2320851 2320851 2022-03-19 New London Connecticut 9011 54240 646
2317597 2317597 2022-03-18 New London Connecticut 9011 54240 646
2314344 2314344 2022-03-17 New London Connecticut 9011 54208 640
2311091 2311091 2022-03-16 New London Connecticut 9011 54184 640
2307838 2307838 2022-03-15 New London Connecticut 9011 54151 640
2304587 2304587 2022-03-14 New London Connecticut 9011 54115 637
2301335 2301335 2022-03-13 New London Connecticut 9011 54060 636
2298083 2298083 2022-03-12 New London Connecticut 9011 54060 636
2294831 2294831 2022-03-11 New London Connecticut 9011 54060 636
2291579 2291579 2022-03-10 New London Connecticut 9011 54034 634
2288327 2288327 2022-03-09 New London Connecticut 9011 54008 634
2285076 2285076 2022-03-08 New London Connecticut 9011 53972 634
2281824 2281824 2022-03-07 New London Connecticut 9011 53884 629
2278571 2278571 2022-03-06 New London Connecticut 9011 53711 630
2275318 2275318 2022-03-05 New London Connecticut 9011 53711 630
2272065 2272065 2022-03-04 New London Connecticut 9011 53711 630
2268813 2268813 2022-03-03 New London Connecticut 9011 53682 626
2265560 2265560 2022-03-02 New London Connecticut 9011 53618 626
2262309 2262309 2022-03-01 New London Connecticut 9011 53576 625
2259058 2259058 2022-02-28 New London Connecticut 9011 53571 625
2255807 2255807 2022-02-27 New London Connecticut 9011 53426 624
2252556 2252556 2022-02-26 New London Connecticut 9011 53426 624
2249305 2249305 2022-02-25 New London Connecticut 9011 53426 624
2246054 2246054 2022-02-24 New London Connecticut 9011 53386 624
2242803 2242803 2022-02-23 New London Connecticut 9011 53366 623
2239552 2239552 2022-02-22 New London Connecticut 9011 53322 619
2236301 2236301 2022-02-21 New London Connecticut 9011 53279 619
2233050 2233050 2022-02-20 New London Connecticut 9011 53177 618
2229799 2229799 2022-02-19 New London Connecticut 9011 53177 618
2226548 2226548 2022-02-18 New London Connecticut 9011 53177 618
2223297 2223297 2022-02-17 New London Connecticut 9011 52955 612
2220046 2220046 2022-02-16 New London Connecticut 9011 52840 612
2216795 2216795 2022-02-15 New London Connecticut 9011 52748 613
2213544 2213544 2022-02-14 New London Connecticut 9011 52670 610
2210292 2210292 2022-02-13 New London Connecticut 9011 52549 610
2207039 2207039 2022-02-12 New London Connecticut 9011 52549 610
2203786 2203786 2022-02-11 New London Connecticut 9011 52549 610
2200533 2200533 2022-02-10 New London Connecticut 9011 52453 607
2197279 2197279 2022-02-09 New London Connecticut 9011 52357 605
2194025 2194025 2022-02-08 New London Connecticut 9011 52274 600
2190771 2190771 2022-02-07 New London Connecticut 9011 52125 600
2187518 2187518 2022-02-06 New London Connecticut 9011 51909 600
2184265 2184265 2022-02-05 New London Connecticut 9011 51909 600
2181013 2181013 2022-02-04 New London Connecticut 9011 51909 600
2177762 2177762 2022-02-03 New London Connecticut 9011 51809 593

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