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

793 rows where fips = 9005 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

fips 1

  • 9005 · 793 ✖

county 1

Link rowid date ▲ county state fips cases deaths
2499886 2499886 2022-05-13 Litchfield Connecticut 9005 33423 461
2496628 2496628 2022-05-12 Litchfield Connecticut 9005 33325 462
2493370 2493370 2022-05-11 Litchfield Connecticut 9005 33257 462
2490112 2490112 2022-05-10 Litchfield Connecticut 9005 33166 462
2486855 2486855 2022-05-09 Litchfield Connecticut 9005 33071 461
2483597 2483597 2022-05-08 Litchfield Connecticut 9005 32899 460
2480339 2480339 2022-05-07 Litchfield Connecticut 9005 32899 460
2477081 2477081 2022-05-06 Litchfield Connecticut 9005 32899 460
2473823 2473823 2022-05-05 Litchfield Connecticut 9005 32854 459
2470566 2470566 2022-05-04 Litchfield Connecticut 9005 32799 459
2467310 2467310 2022-05-03 Litchfield Connecticut 9005 32744 458
2464055 2464055 2022-05-02 Litchfield Connecticut 9005 32649 458
2460799 2460799 2022-05-01 Litchfield Connecticut 9005 32588 458
2457543 2457543 2022-04-30 Litchfield Connecticut 9005 32588 458
2454287 2454287 2022-04-29 Litchfield Connecticut 9005 32588 458
2451031 2451031 2022-04-28 Litchfield Connecticut 9005 32550 457
2447775 2447775 2022-04-27 Litchfield Connecticut 9005 32485 457
2444519 2444519 2022-04-26 Litchfield Connecticut 9005 32454 457
2441263 2441263 2022-04-25 Litchfield Connecticut 9005 32425 457
2438007 2438007 2022-04-24 Litchfield Connecticut 9005 32317 457
2434751 2434751 2022-04-23 Litchfield Connecticut 9005 32317 457
2431495 2431495 2022-04-22 Litchfield Connecticut 9005 32317 457
2428239 2428239 2022-04-21 Litchfield Connecticut 9005 32254 456
2424983 2424983 2022-04-20 Litchfield Connecticut 9005 32219 456
2421727 2421727 2022-04-19 Litchfield Connecticut 9005 32172 456
2418471 2418471 2022-04-18 Litchfield Connecticut 9005 32105 456
2415215 2415215 2022-04-17 Litchfield Connecticut 9005 32023 456
2411959 2411959 2022-04-16 Litchfield Connecticut 9005 32023 456
2408703 2408703 2022-04-15 Litchfield Connecticut 9005 32023 456
2405447 2405447 2022-04-14 Litchfield Connecticut 9005 31978 456
2402192 2402192 2022-04-13 Litchfield Connecticut 9005 31962 456
2398937 2398937 2022-04-12 Litchfield Connecticut 9005 31929 456
2395682 2395682 2022-04-11 Litchfield Connecticut 9005 31891 455
2392426 2392426 2022-04-10 Litchfield Connecticut 9005 31806 455
2389170 2389170 2022-04-09 Litchfield Connecticut 9005 31806 455
2385915 2385915 2022-04-08 Litchfield Connecticut 9005 31806 455
2382660 2382660 2022-04-07 Litchfield Connecticut 9005 31771 455
2379405 2379405 2022-04-06 Litchfield Connecticut 9005 31758 455
2376151 2376151 2022-04-05 Litchfield Connecticut 9005 31739 455
2372899 2372899 2022-04-04 Litchfield Connecticut 9005 31731 454
2369646 2369646 2022-04-03 Litchfield Connecticut 9005 31641 454
2366393 2366393 2022-04-02 Litchfield Connecticut 9005 31641 454
2363140 2363140 2022-04-01 Litchfield Connecticut 9005 31641 454
2359886 2359886 2022-03-31 Litchfield Connecticut 9005 31625 454
2356632 2356632 2022-03-30 Litchfield Connecticut 9005 31612 454
2353379 2353379 2022-03-29 Litchfield Connecticut 9005 31589 454
2350127 2350127 2022-03-28 Litchfield Connecticut 9005 31579 454
2346874 2346874 2022-03-27 Litchfield Connecticut 9005 31521 454
2343621 2343621 2022-03-26 Litchfield Connecticut 9005 31521 454
2340368 2340368 2022-03-25 Litchfield Connecticut 9005 31521 454
2337115 2337115 2022-03-24 Litchfield Connecticut 9005 31509 453
2333861 2333861 2022-03-23 Litchfield Connecticut 9005 31498 453
2330607 2330607 2022-03-22 Litchfield Connecticut 9005 31484 453
2327355 2327355 2022-03-21 Litchfield Connecticut 9005 31467 452
2324102 2324102 2022-03-20 Litchfield Connecticut 9005 31446 452
2320848 2320848 2022-03-19 Litchfield Connecticut 9005 31446 452
2317594 2317594 2022-03-18 Litchfield Connecticut 9005 31446 452
2314341 2314341 2022-03-17 Litchfield Connecticut 9005 31436 453
2311088 2311088 2022-03-16 Litchfield Connecticut 9005 31433 453
2307835 2307835 2022-03-15 Litchfield Connecticut 9005 31408 452
2304584 2304584 2022-03-14 Litchfield Connecticut 9005 31394 452
2301332 2301332 2022-03-13 Litchfield Connecticut 9005 31336 452
2298080 2298080 2022-03-12 Litchfield Connecticut 9005 31336 452
2294828 2294828 2022-03-11 Litchfield Connecticut 9005 31336 452
2291576 2291576 2022-03-10 Litchfield Connecticut 9005 31333 450
2288324 2288324 2022-03-09 Litchfield Connecticut 9005 31324 450
2285073 2285073 2022-03-08 Litchfield Connecticut 9005 31313 450
2281821 2281821 2022-03-07 Litchfield Connecticut 9005 31306 448
2278568 2278568 2022-03-06 Litchfield Connecticut 9005 31284 448
2275315 2275315 2022-03-05 Litchfield Connecticut 9005 31284 448
2272062 2272062 2022-03-04 Litchfield Connecticut 9005 31284 448
2268810 2268810 2022-03-03 Litchfield Connecticut 9005 31275 448
2265557 2265557 2022-03-02 Litchfield Connecticut 9005 31267 448
2262306 2262306 2022-03-01 Litchfield Connecticut 9005 31243 443
2259055 2259055 2022-02-28 Litchfield Connecticut 9005 31238 443
2255804 2255804 2022-02-27 Litchfield Connecticut 9005 31207 443
2252553 2252553 2022-02-26 Litchfield Connecticut 9005 31207 443
2249302 2249302 2022-02-25 Litchfield Connecticut 9005 31207 443
2246051 2246051 2022-02-24 Litchfield Connecticut 9005 31184 441
2242800 2242800 2022-02-23 Litchfield Connecticut 9005 31169 441
2239549 2239549 2022-02-22 Litchfield Connecticut 9005 31136 434
2236298 2236298 2022-02-21 Litchfield Connecticut 9005 31115 434
2233047 2233047 2022-02-20 Litchfield Connecticut 9005 31050 434
2229796 2229796 2022-02-19 Litchfield Connecticut 9005 31050 434
2226545 2226545 2022-02-18 Litchfield Connecticut 9005 31050 434
2223294 2223294 2022-02-17 Litchfield Connecticut 9005 30988 432
2220043 2220043 2022-02-16 Litchfield Connecticut 9005 30969 432
2216792 2216792 2022-02-15 Litchfield Connecticut 9005 30746 432
2213541 2213541 2022-02-14 Litchfield Connecticut 9005 30623 430
2210289 2210289 2022-02-13 Litchfield Connecticut 9005 30562 430
2207036 2207036 2022-02-12 Litchfield Connecticut 9005 30562 430
2203783 2203783 2022-02-11 Litchfield Connecticut 9005 30562 430
2200530 2200530 2022-02-10 Litchfield Connecticut 9005 30525 426
2197276 2197276 2022-02-09 Litchfield Connecticut 9005 30474 426
2194022 2194022 2022-02-08 Litchfield Connecticut 9005 30411 425
2190768 2190768 2022-02-07 Litchfield Connecticut 9005 30349 425
2187515 2187515 2022-02-06 Litchfield Connecticut 9005 30248 425
2184262 2184262 2022-02-05 Litchfield Connecticut 9005 30248 425
2181010 2181010 2022-02-04 Litchfield Connecticut 9005 30248 425
2177759 2177759 2022-02-03 Litchfield Connecticut 9005 30193 420

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