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

7,091 rows where state = "Connecticut" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

fips 9

county 9

state 1

  • Connecticut · 7,091 ✖
Link rowid date ▲ county state fips cases deaths
2499884 2499884 2022-05-13 Fairfield Connecticut 9001 214106 2733
2499885 2499885 2022-05-13 Hartford Connecticut 9003 187284 3157
2499886 2499886 2022-05-13 Litchfield Connecticut 9005 33423 461
2499887 2499887 2022-05-13 Middlesex Connecticut 9007 30049 481
2499888 2499888 2022-05-13 New Haven Connecticut 9009 205522 2839
2499889 2499889 2022-05-13 New London Connecticut 9011 58138 662
2499890 2499890 2022-05-13 Tolland Connecticut 9013 21898 275
2499891 2499891 2022-05-13 Unknown Connecticut   2397 1
2499892 2499892 2022-05-13 Windham Connecticut 9015 26643 305
2496626 2496626 2022-05-12 Fairfield Connecticut 9001 213432 2725
2496627 2496627 2022-05-12 Hartford Connecticut 9003 186693 3144
2496628 2496628 2022-05-12 Litchfield Connecticut 9005 33325 462
2496629 2496629 2022-05-12 Middlesex Connecticut 9007 29910 481
2496630 2496630 2022-05-12 New Haven Connecticut 9009 204937 2831
2496631 2496631 2022-05-12 New London Connecticut 9011 57958 660
2496632 2496632 2022-05-12 Tolland Connecticut 9013 21840 274
2496633 2496633 2022-05-12 Unknown Connecticut   2375 1
2496634 2496634 2022-05-12 Windham Connecticut 9015 26594 305
2493368 2493368 2022-05-11 Fairfield Connecticut 9001 213009 2725
2493369 2493369 2022-05-11 Hartford Connecticut 9003 186141 3144
2493370 2493370 2022-05-11 Litchfield Connecticut 9005 33257 462
2493371 2493371 2022-05-11 Middlesex Connecticut 9007 29817 481
2493372 2493372 2022-05-11 New Haven Connecticut 9009 204406 2831
2493373 2493373 2022-05-11 New London Connecticut 9011 57803 660
2493374 2493374 2022-05-11 Tolland Connecticut 9013 21774 274
2493375 2493375 2022-05-11 Unknown Connecticut   2368 1
2493376 2493376 2022-05-11 Windham Connecticut 9015 26526 305
2490110 2490110 2022-05-10 Fairfield Connecticut 9001 212518 2725
2490111 2490111 2022-05-10 Hartford Connecticut 9003 185485 3144
2490112 2490112 2022-05-10 Litchfield Connecticut 9005 33166 462
2490113 2490113 2022-05-10 Middlesex Connecticut 9007 29644 481
2490114 2490114 2022-05-10 New Haven Connecticut 9009 203793 2831
2490115 2490115 2022-05-10 New London Connecticut 9011 57604 660
2490116 2490116 2022-05-10 Tolland Connecticut 9013 21691 274
2490117 2490117 2022-05-10 Unknown Connecticut   2347 1
2490118 2490118 2022-05-10 Windham Connecticut 9015 26461 305
2486853 2486853 2022-05-09 Fairfield Connecticut 9001 212056 2723
2486854 2486854 2022-05-09 Hartford Connecticut 9003 184906 3142
2486855 2486855 2022-05-09 Litchfield Connecticut 9005 33071 461
2486856 2486856 2022-05-09 Middlesex Connecticut 9007 29536 480
2486857 2486857 2022-05-09 New Haven Connecticut 9009 203366 2830
2486858 2486858 2022-05-09 New London Connecticut 9011 57454 660
2486859 2486859 2022-05-09 Tolland Connecticut 9013 21625 274
2486860 2486860 2022-05-09 Unknown Connecticut   2338 1
2486861 2486861 2022-05-09 Windham Connecticut 9015 26410 304
2483595 2483595 2022-05-08 Fairfield Connecticut 9001 210830 2723
2483596 2483596 2022-05-08 Hartford Connecticut 9003 183694 3142
2483597 2483597 2022-05-08 Litchfield Connecticut 9005 32899 460
2483598 2483598 2022-05-08 Middlesex Connecticut 9007 29326 480
2483599 2483599 2022-05-08 New Haven Connecticut 9009 202240 2830
2483600 2483600 2022-05-08 New London Connecticut 9011 57081 660
2483601 2483601 2022-05-08 Tolland Connecticut 9013 21484 274
2483602 2483602 2022-05-08 Unknown Connecticut   2320 1
2483603 2483603 2022-05-08 Windham Connecticut 9015 26298 304
2480337 2480337 2022-05-07 Fairfield Connecticut 9001 210830 2723
2480338 2480338 2022-05-07 Hartford Connecticut 9003 183694 3142
2480339 2480339 2022-05-07 Litchfield Connecticut 9005 32899 460
2480340 2480340 2022-05-07 Middlesex Connecticut 9007 29326 480
2480341 2480341 2022-05-07 New Haven Connecticut 9009 202240 2830
2480342 2480342 2022-05-07 New London Connecticut 9011 57081 660
2480343 2480343 2022-05-07 Tolland Connecticut 9013 21484 274
2480344 2480344 2022-05-07 Unknown Connecticut   2320 1
2480345 2480345 2022-05-07 Windham Connecticut 9015 26298 304
2477079 2477079 2022-05-06 Fairfield Connecticut 9001 210830 2723
2477080 2477080 2022-05-06 Hartford Connecticut 9003 183694 3142
2477081 2477081 2022-05-06 Litchfield Connecticut 9005 32899 460
2477082 2477082 2022-05-06 Middlesex Connecticut 9007 29326 480
2477083 2477083 2022-05-06 New Haven Connecticut 9009 202240 2830
2477084 2477084 2022-05-06 New London Connecticut 9011 57081 660
2477085 2477085 2022-05-06 Tolland Connecticut 9013 21484 274
2477086 2477086 2022-05-06 Unknown Connecticut   2320 1
2477087 2477087 2022-05-06 Windham Connecticut 9015 26298 304
2473821 2473821 2022-05-05 Fairfield Connecticut 9001 210521 2721
2473822 2473822 2022-05-05 Hartford Connecticut 9003 183216 3135
2473823 2473823 2022-05-05 Litchfield Connecticut 9005 32854 459
2473824 2473824 2022-05-05 Middlesex Connecticut 9007 29204 480
2473825 2473825 2022-05-05 New Haven Connecticut 9009 201806 2825
2473826 2473826 2022-05-05 New London Connecticut 9011 56984 659
2473827 2473827 2022-05-05 Tolland Connecticut 9013 21405 274
2473828 2473828 2022-05-05 Unknown Connecticut   2310 1
2473829 2473829 2022-05-05 Windham Connecticut 9015 26269 304
2470564 2470564 2022-05-04 Fairfield Connecticut 9001 210120 2721
2470565 2470565 2022-05-04 Hartford Connecticut 9003 182983 3135
2470566 2470566 2022-05-04 Litchfield Connecticut 9005 32799 459
2470567 2470567 2022-05-04 Middlesex Connecticut 9007 29117 480
2470568 2470568 2022-05-04 New Haven Connecticut 9009 201354 2825
2470569 2470569 2022-05-04 New London Connecticut 9011 56880 659
2470570 2470570 2022-05-04 Tolland Connecticut 9013 21361 274
2470571 2470571 2022-05-04 Unknown Connecticut   2301 1
2470572 2470572 2022-05-04 Windham Connecticut 9015 26234 304
2467308 2467308 2022-05-03 Fairfield Connecticut 9001 209878 2720
2467309 2467309 2022-05-03 Hartford Connecticut 9003 182657 3135
2467310 2467310 2022-05-03 Litchfield Connecticut 9005 32744 458
2467311 2467311 2022-05-03 Middlesex Connecticut 9007 29057 480
2467312 2467312 2022-05-03 New Haven Connecticut 9009 201134 2824
2467313 2467313 2022-05-03 New London Connecticut 9011 56816 659
2467314 2467314 2022-05-03 Tolland Connecticut 9013 21321 274
2467315 2467315 2022-05-03 Unknown Connecticut   2295 1
2467316 2467316 2022-05-03 Windham Connecticut 9015 26195 304
2464053 2464053 2022-05-02 Fairfield Connecticut 9001 209399 2718

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