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

65 rows where "date" is on date 2020-04-03 and state = "Illinois" sorted by date descending

✎ View and edit SQL

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

state 1

  • Illinois · 65 ✖
Link rowid date ▲ county state fips cases deaths
28913 28913 2020-04-03 Adams Illinois 17001 2 0
28914 28914 2020-04-03 Bond Illinois 17005 3 0
28915 28915 2020-04-03 Bureau Illinois 17011 2 0
28916 28916 2020-04-03 Carroll Illinois 17015 4 1
28917 28917 2020-04-03 Champaign Illinois 17019 51 0
28918 28918 2020-04-03 Christian Illinois 17021 17 2
28919 28919 2020-04-03 Clark Illinois 17023 2 0
28920 28920 2020-04-03 Clinton Illinois 17027 8 0
28921 28921 2020-04-03 Cook Illinois 17031 6473 141
28922 28922 2020-04-03 Crawford Illinois 17033 1 0
28923 28923 2020-04-03 Cumberland Illinois 17035 1 0
28924 28924 2020-04-03 De Witt Illinois 17039 1 0
28925 28925 2020-04-03 DeKalb Illinois 17037 16 0
28926 28926 2020-04-03 Douglas Illinois 17041 9 0
28927 28927 2020-04-03 DuPage Illinois 17043 500 16
28928 28928 2020-04-03 Effingham Illinois 17049 1 0
28929 28929 2020-04-03 Fayette Illinois 17051 2 0
28930 28930 2020-04-03 Ford Illinois 17053 1 0
28931 28931 2020-04-03 Franklin Illinois 17055 1 0
28932 28932 2020-04-03 Grundy Illinois 17063 7 0
28933 28933 2020-04-03 Henry Illinois 17073 7 0
28934 28934 2020-04-03 Iroquois Illinois 17075 4 0
28935 28935 2020-04-03 Jackson Illinois 17077 8 0
28936 28936 2020-04-03 Jersey Illinois 17083 1 0
28937 28937 2020-04-03 Jo Daviess Illinois 17085 4 0
28938 28938 2020-04-03 Kane Illinois 17089 176 9
28939 28939 2020-04-03 Kankakee Illinois 17091 68 3
28940 28940 2020-04-03 Kendall Illinois 17093 37 2
28941 28941 2020-04-03 Knox Illinois 17095 1 0
28942 28942 2020-04-03 LaSalle Illinois 17099 6 1
28943 28943 2020-04-03 Lake Illinois 17097 608 14
28944 28944 2020-04-03 Livingston Illinois 17105 6 0
28945 28945 2020-04-03 Logan Illinois 17107 1 0
28946 28946 2020-04-03 Macon Illinois 17115 2 0
28947 28947 2020-04-03 Macoupin Illinois 17117 1 0
28948 28948 2020-04-03 Madison Illinois 17119 31 0
28949 28949 2020-04-03 Marion Illinois 17121 3 0
28950 28950 2020-04-03 Marshall Illinois 17123 1 0
28951 28951 2020-04-03 Massac Illinois 17127 1 0
28952 28952 2020-04-03 McHenry Illinois 17111 102 3
28953 28953 2020-04-03 McLean Illinois 17113 35 2
28954 28954 2020-04-03 Menard Illinois 17129 1 0
28955 28955 2020-04-03 Mercer Illinois 17131 1 0
28956 28956 2020-04-03 Monroe Illinois 17133 8 0
28957 28957 2020-04-03 Montgomery Illinois 17135 2 0
28958 28958 2020-04-03 Morgan Illinois 17137 5 1
28959 28959 2020-04-03 Moultrie Illinois 17139 1 0
28960 28960 2020-04-03 Ogle Illinois 17141 1 0
28961 28961 2020-04-03 Peoria Illinois 17143 11 0
28962 28962 2020-04-03 Piatt Illinois 17147 1 0
28963 28963 2020-04-03 Randolph Illinois 17157 12 0
28964 28964 2020-04-03 Rock Island Illinois 17161 24 0
28965 28965 2020-04-03 Saline Illinois 17165 1 0
28966 28966 2020-04-03 Sangamon Illinois 17167 23 2
28967 28967 2020-04-03 St. Clair Illinois 17163 57 3
28968 28968 2020-04-03 Stephenson Illinois 17177 3 0
28969 28969 2020-04-03 Tazewell Illinois 17179 7 0
28970 28970 2020-04-03 Unknown Illinois   40 0
28971 28971 2020-04-03 Vermilion Illinois 17183 2 0
28972 28972 2020-04-03 Washington Illinois 17189 1 0
28973 28973 2020-04-03 Whiteside Illinois 17195 9 1
28974 28974 2020-04-03 Will Illinois 17197 455 10
28975 28975 2020-04-03 Williamson Illinois 17199 2 0
28976 28976 2020-04-03 Winnebago Illinois 17201 28 1
28977 28977 2020-04-03 Woodford Illinois 17203 4 0

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