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

2,316 rows where county = "Cook" sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 3

fips 3

county 1

  • Cook · 2,316 ✖
Link rowid date ▲ county state fips cases deaths
2500002 2500002 2022-05-13 Cook Georgia 13075 4911 76
2500192 2500192 2022-05-13 Cook Illinois 17031 1193914 14936
2500920 2500920 2022-05-13 Cook Minnesota 27031 594 4
2496744 2496744 2022-05-12 Cook Georgia 13075 4911 76
2496934 2496934 2022-05-12 Cook Illinois 17031 1189960 14932
2497662 2497662 2022-05-12 Cook Minnesota 27031 592 4
2493486 2493486 2022-05-11 Cook Georgia 13075 4911 76
2493676 2493676 2022-05-11 Cook Illinois 17031 1187428 14931
2494404 2494404 2022-05-11 Cook Minnesota 27031 590 4
2490228 2490228 2022-05-10 Cook Georgia 13075 4908 76
2490418 2490418 2022-05-10 Cook Illinois 17031 1184612 14927
2491146 2491146 2022-05-10 Cook Minnesota 27031 586 4
2486971 2486971 2022-05-09 Cook Georgia 13075 4908 76
2487161 2487161 2022-05-09 Cook Illinois 17031 1182472 14923
2487889 2487889 2022-05-09 Cook Minnesota 27031 581 4
2483713 2483713 2022-05-08 Cook Georgia 13075 4908 76
2483903 2483903 2022-05-08 Cook Illinois 17031 1175544 14918
2484631 2484631 2022-05-08 Cook Minnesota 27031 579 4
2480455 2480455 2022-05-07 Cook Georgia 13075 4908 76
2480645 2480645 2022-05-07 Cook Illinois 17031 1175544 14918
2481373 2481373 2022-05-07 Cook Minnesota 27031 579 4
2477197 2477197 2022-05-06 Cook Georgia 13075 4908 76
2477387 2477387 2022-05-06 Cook Illinois 17031 1175544 14918
2478115 2478115 2022-05-06 Cook Minnesota 27031 579 4
2473939 2473939 2022-05-05 Cook Georgia 13075 4908 76
2474129 2474129 2022-05-05 Cook Illinois 17031 1171884 14916
2474857 2474857 2022-05-05 Cook Minnesota 27031 579 4
2470682 2470682 2022-05-04 Cook Georgia 13075 4908 76
2470872 2470872 2022-05-04 Cook Illinois 17031 1170027 14912
2471600 2471600 2022-05-04 Cook Minnesota 27031 577 4
2467426 2467426 2022-05-03 Cook Georgia 13075 4900 75
2467616 2467616 2022-05-03 Cook Illinois 17031 1167319 14906
2468344 2468344 2022-05-03 Cook Minnesota 27031 574 4
2464171 2464171 2022-05-02 Cook Georgia 13075 4900 75
2464361 2464361 2022-05-02 Cook Illinois 17031 1165715 14904
2465089 2465089 2022-05-02 Cook Minnesota 27031 571 4
2460915 2460915 2022-05-01 Cook Georgia 13075 4900 75
2461105 2461105 2022-05-01 Cook Illinois 17031 1161686 14904
2461833 2461833 2022-05-01 Cook Minnesota 27031 571 4
2457659 2457659 2022-04-30 Cook Georgia 13075 4900 75
2457849 2457849 2022-04-30 Cook Illinois 17031 1161686 14904
2458577 2458577 2022-04-30 Cook Minnesota 27031 571 4
2454403 2454403 2022-04-29 Cook Georgia 13075 4900 75
2454593 2454593 2022-04-29 Cook Illinois 17031 1161686 14904
2455321 2455321 2022-04-29 Cook Minnesota 27031 571 4
2451147 2451147 2022-04-28 Cook Georgia 13075 4900 75
2451337 2451337 2022-04-28 Cook Illinois 17031 1158806 14892
2452065 2452065 2022-04-28 Cook Minnesota 27031 570 4
2447891 2447891 2022-04-27 Cook Georgia 13075 4900 75
2448081 2448081 2022-04-27 Cook Illinois 17031 1156672 14888
2448809 2448809 2022-04-27 Cook Minnesota 27031 565 4
2444635 2444635 2022-04-26 Cook Georgia 13075 4899 75
2444825 2444825 2022-04-26 Cook Illinois 17031 1155180 14885
2445553 2445553 2022-04-26 Cook Minnesota 27031 565 4
2441379 2441379 2022-04-25 Cook Georgia 13075 4899 75
2441569 2441569 2022-04-25 Cook Illinois 17031 1154229 14887
2442297 2442297 2022-04-25 Cook Minnesota 27031 563 4
2438123 2438123 2022-04-24 Cook Georgia 13075 4899 75
2438313 2438313 2022-04-24 Cook Illinois 17031 1150204 14879
2439041 2439041 2022-04-24 Cook Minnesota 27031 562 4
2434867 2434867 2022-04-23 Cook Georgia 13075 4899 75
2435057 2435057 2022-04-23 Cook Illinois 17031 1150204 14879
2435785 2435785 2022-04-23 Cook Minnesota 27031 562 4
2431611 2431611 2022-04-22 Cook Georgia 13075 4899 75
2431801 2431801 2022-04-22 Cook Illinois 17031 1150204 14879
2432529 2432529 2022-04-22 Cook Minnesota 27031 562 4
2428355 2428355 2022-04-21 Cook Georgia 13075 4899 75
2428545 2428545 2022-04-21 Cook Illinois 17031 1148513 14875
2429273 2429273 2022-04-21 Cook Minnesota 27031 562 4
2425099 2425099 2022-04-20 Cook Georgia 13075 4899 75
2425289 2425289 2022-04-20 Cook Illinois 17031 1146864 14871
2426017 2426017 2022-04-20 Cook Minnesota 27031 561 4
2421843 2421843 2022-04-19 Cook Georgia 13075 4898 74
2422033 2422033 2022-04-19 Cook Illinois 17031 1144935 14869
2422761 2422761 2022-04-19 Cook Minnesota 27031 561 4
2418587 2418587 2022-04-18 Cook Georgia 13075 4898 74
2418777 2418777 2022-04-18 Cook Illinois 17031 1143915 14854
2419505 2419505 2022-04-18 Cook Minnesota 27031 559 4
2415331 2415331 2022-04-17 Cook Georgia 13075 4899 74
2415521 2415521 2022-04-17 Cook Illinois 17031 1140977 14851
2416249 2416249 2022-04-17 Cook Minnesota 27031 558 4
2412075 2412075 2022-04-16 Cook Georgia 13075 4899 74
2412265 2412265 2022-04-16 Cook Illinois 17031 1140977 14851
2412993 2412993 2022-04-16 Cook Minnesota 27031 558 4
2408819 2408819 2022-04-15 Cook Georgia 13075 4899 74
2409009 2409009 2022-04-15 Cook Illinois 17031 1140977 14851
2409737 2409737 2022-04-15 Cook Minnesota 27031 558 4
2405563 2405563 2022-04-14 Cook Georgia 13075 4900 74
2405753 2405753 2022-04-14 Cook Illinois 17031 1139911 14847
2406481 2406481 2022-04-14 Cook Minnesota 27031 556 4
2402308 2402308 2022-04-13 Cook Georgia 13075 4899 74
2402498 2402498 2022-04-13 Cook Illinois 17031 1138244 14845
2403225 2403225 2022-04-13 Cook Minnesota 27031 555 4
2399053 2399053 2022-04-12 Cook Georgia 13075 4898 74
2399243 2399243 2022-04-12 Cook Illinois 17031 1137242 14841
2399971 2399971 2022-04-12 Cook Minnesota 27031 554 4
2395798 2395798 2022-04-11 Cook Georgia 13075 4897 74
2395988 2395988 2022-04-11 Cook Illinois 17031 1136504 14837
2396715 2396715 2022-04-11 Cook Minnesota 27031 554 4
2392542 2392542 2022-04-10 Cook Georgia 13075 4896 74

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