home / covid

Menu
  • GraphQL API

ny_times_us_counties

Table actions
  • GraphQL API for ny_times_us_counties
⚠️ 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

841 rows where fips = 17031 sorted by date descending

✎ View and edit SQL

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

Suggested facets: date (date)

state 1

  • Illinois 841

fips 1

  • 17031 · 841 ✖

county 1

  • Cook 841
Link rowid date ▲ county state fips cases deaths
2500192 2500192 2022-05-13 Cook Illinois 17031 1193914 14936
2496934 2496934 2022-05-12 Cook Illinois 17031 1189960 14932
2493676 2493676 2022-05-11 Cook Illinois 17031 1187428 14931
2490418 2490418 2022-05-10 Cook Illinois 17031 1184612 14927
2487161 2487161 2022-05-09 Cook Illinois 17031 1182472 14923
2483903 2483903 2022-05-08 Cook Illinois 17031 1175544 14918
2480645 2480645 2022-05-07 Cook Illinois 17031 1175544 14918
2477387 2477387 2022-05-06 Cook Illinois 17031 1175544 14918
2474129 2474129 2022-05-05 Cook Illinois 17031 1171884 14916
2470872 2470872 2022-05-04 Cook Illinois 17031 1170027 14912
2467616 2467616 2022-05-03 Cook Illinois 17031 1167319 14906
2464361 2464361 2022-05-02 Cook Illinois 17031 1165715 14904
2461105 2461105 2022-05-01 Cook Illinois 17031 1161686 14904
2457849 2457849 2022-04-30 Cook Illinois 17031 1161686 14904
2454593 2454593 2022-04-29 Cook Illinois 17031 1161686 14904
2451337 2451337 2022-04-28 Cook Illinois 17031 1158806 14892
2448081 2448081 2022-04-27 Cook Illinois 17031 1156672 14888
2444825 2444825 2022-04-26 Cook Illinois 17031 1155180 14885
2441569 2441569 2022-04-25 Cook Illinois 17031 1154229 14887
2438313 2438313 2022-04-24 Cook Illinois 17031 1150204 14879
2435057 2435057 2022-04-23 Cook Illinois 17031 1150204 14879
2431801 2431801 2022-04-22 Cook Illinois 17031 1150204 14879
2428545 2428545 2022-04-21 Cook Illinois 17031 1148513 14875
2425289 2425289 2022-04-20 Cook Illinois 17031 1146864 14871
2422033 2422033 2022-04-19 Cook Illinois 17031 1144935 14869
2418777 2418777 2022-04-18 Cook Illinois 17031 1143915 14854
2415521 2415521 2022-04-17 Cook Illinois 17031 1140977 14851
2412265 2412265 2022-04-16 Cook Illinois 17031 1140977 14851
2409009 2409009 2022-04-15 Cook Illinois 17031 1140977 14851
2405753 2405753 2022-04-14 Cook Illinois 17031 1139911 14847
2402498 2402498 2022-04-13 Cook Illinois 17031 1138244 14845
2399243 2399243 2022-04-12 Cook Illinois 17031 1137242 14841
2395988 2395988 2022-04-11 Cook Illinois 17031 1136504 14837
2392732 2392732 2022-04-10 Cook Illinois 17031 1134146 14837
2389476 2389476 2022-04-09 Cook Illinois 17031 1134146 14837
2386221 2386221 2022-04-08 Cook Illinois 17031 1134146 14837
2382966 2382966 2022-04-07 Cook Illinois 17031 1132875 14838
2379711 2379711 2022-04-06 Cook Illinois 17031 1132072 14831
2376457 2376457 2022-04-05 Cook Illinois 17031 1130951 14830
2373205 2373205 2022-04-04 Cook Illinois 17031 1130052 14822
2369952 2369952 2022-04-03 Cook Illinois 17031 1128478 14820
2366699 2366699 2022-04-02 Cook Illinois 17031 1128478 14820
2363446 2363446 2022-04-01 Cook Illinois 17031 1128478 14820
2360192 2360192 2022-03-31 Cook Illinois 17031 1127765 14811
2356938 2356938 2022-03-30 Cook Illinois 17031 1126979 14807
2353685 2353685 2022-03-29 Cook Illinois 17031 1126435 14805
2350433 2350433 2022-03-28 Cook Illinois 17031 1125678 14799
2347180 2347180 2022-03-27 Cook Illinois 17031 1124384 14793
2343927 2343927 2022-03-26 Cook Illinois 17031 1124384 14793
2340674 2340674 2022-03-25 Cook Illinois 17031 1124384 14793
2337421 2337421 2022-03-24 Cook Illinois 17031 1123719 14787
2334167 2334167 2022-03-23 Cook Illinois 17031 1122841 14781
2330913 2330913 2022-03-22 Cook Illinois 17031 1122376 14774
2327661 2327661 2022-03-21 Cook Illinois 17031 1121743 14759
2324408 2324408 2022-03-20 Cook Illinois 17031 1120619 14751
2321154 2321154 2022-03-19 Cook Illinois 17031 1120619 14751
2317900 2317900 2022-03-18 Cook Illinois 17031 1120619 14751
2314647 2314647 2022-03-17 Cook Illinois 17031 1119976 14750
2311394 2311394 2022-03-16 Cook Illinois 17031 1119444 14746
2308141 2308141 2022-03-15 Cook Illinois 17031 1118987 14740
2304890 2304890 2022-03-14 Cook Illinois 17031 1118357 14728
2301638 2301638 2022-03-13 Cook Illinois 17031 1117364 14718
2298386 2298386 2022-03-12 Cook Illinois 17031 1117364 14718
2295134 2295134 2022-03-11 Cook Illinois 17031 1117364 14718
2291882 2291882 2022-03-10 Cook Illinois 17031 1116353 14711
2288630 2288630 2022-03-09 Cook Illinois 17031 1115700 14697
2285379 2285379 2022-03-08 Cook Illinois 17031 1114942 14686
2282127 2282127 2022-03-07 Cook Illinois 17031 1114552 14678
2278874 2278874 2022-03-06 Cook Illinois 17031 1113552 14665
2275621 2275621 2022-03-05 Cook Illinois 17031 1113552 14665
2272368 2272368 2022-03-04 Cook Illinois 17031 1113552 14665
2269116 2269116 2022-03-03 Cook Illinois 17031 1113031 14654
2265863 2265863 2022-03-02 Cook Illinois 17031 1112561 14638
2262612 2262612 2022-03-01 Cook Illinois 17031 1111943 14624
2259361 2259361 2022-02-28 Cook Illinois 17031 1111190 14606
2256110 2256110 2022-02-27 Cook Illinois 17031 1109348 14571
2252859 2252859 2022-02-26 Cook Illinois 17031 1109348 14571
2249608 2249608 2022-02-25 Cook Illinois 17031 1109348 14571
2246357 2246357 2022-02-24 Cook Illinois 17031 1108582 14552
2243106 2243106 2022-02-23 Cook Illinois 17031 1108068 14535
2239855 2239855 2022-02-22 Cook Illinois 17031 1107288 14491
2236604 2236604 2022-02-21 Cook Illinois 17031 1105263 14439
2233353 2233353 2022-02-20 Cook Illinois 17031 1105263 14439
2230102 2230102 2022-02-19 Cook Illinois 17031 1105263 14439
2226851 2226851 2022-02-18 Cook Illinois 17031 1105263 14439
2223600 2223600 2022-02-17 Cook Illinois 17031 1104210 14423
2220349 2220349 2022-02-16 Cook Illinois 17031 1103573 14409
2217098 2217098 2022-02-15 Cook Illinois 17031 1102713 14381
2213847 2213847 2022-02-14 Cook Illinois 17031 1102010 14350
2210595 2210595 2022-02-13 Cook Illinois 17031 1097792 14280
2207342 2207342 2022-02-12 Cook Illinois 17031 1097792 14280
2204089 2204089 2022-02-11 Cook Illinois 17031 1097792 14280
2200836 2200836 2022-02-10 Cook Illinois 17031 1097792 14280
2197582 2197582 2022-02-09 Cook Illinois 17031 1096346 14240
2194328 2194328 2022-02-08 Cook Illinois 17031 1095321 14195
2191074 2191074 2022-02-07 Cook Illinois 17031 1093945 14142
2187821 2187821 2022-02-06 Cook Illinois 17031 1089942 14052
2184568 2184568 2022-02-05 Cook Illinois 17031 1089942 14052
2181316 2181316 2022-02-04 Cook Illinois 17031 1089942 14052
2178065 2178065 2022-02-03 Cook Illinois 17031 1084468 13988

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);
Powered by Datasette · Queries took 71.15ms · Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette