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

174 rows where fips = 17031 sorted by date descending

View and edit SQL

Suggested facets: date (date)

state

fips

  • 17031 · 174

county

Link rowid date ▲ county state fips cases deaths
334983 2020-07-15 Cook Illinois 17031 96662 4745
331792 2020-07-14 Cook Illinois 17031 96186 4741
328607 2020-07-13 Cook Illinois 17031 95884 4729
325423 2020-07-12 Cook Illinois 17031 95557 4725
322244 2020-07-11 Cook Illinois 17031 95138 4711
319067 2020-07-10 Cook Illinois 17031 94605 4693
315896 2020-07-09 Cook Illinois 17031 94005 4676
312724 2020-07-08 Cook Illinois 17031 93496 4664
309556 2020-07-07 Cook Illinois 17031 93053 4651
306390 2020-07-06 Cook Illinois 17031 92781 4630
303227 2020-07-05 Cook Illinois 17031 92532 4627
300065 2020-07-04 Cook Illinois 17031 92240 4622
296905 2020-07-03 Cook Illinois 17031 91774 4618
293750 2020-07-02 Cook Illinois 17031 91381 4609
290598 2020-07-01 Cook Illinois 17031 90911 4581
287450 2020-06-30 Cook Illinois 17031 90536 4565
284302 2020-06-29 Cook Illinois 17031 90122 4554
281158 2020-06-28 Cook Illinois 17031 89755 4542
278011 2020-06-27 Cook Illinois 17031 89407 4536
274865 2020-06-26 Cook Illinois 17031 89068 4526
271725 2020-06-25 Cook Illinois 17031 88650 4500
268590 2020-06-24 Cook Illinois 17031 88138 4478
265462 2020-06-23 Cook Illinois 17031 87784 4439
262335 2020-06-22 Cook Illinois 17031 87424 4423
259210 2020-06-21 Cook Illinois 17031 87177 4404
256086 2020-06-20 Cook Illinois 17031 86885 4390
252968 2020-06-19 Cook Illinois 17031 86551 4363
249855 2020-06-18 Cook Illinois 17031 86179 4333
246745 2020-06-17 Cook Illinois 17031 85858 4304
243634 2020-06-16 Cook Illinois 17031 85538 4253
240525 2020-06-15 Cook Illinois 17031 85184 4206
237419 2020-06-14 Cook Illinois 17031 84906 4189
234314 2020-06-13 Cook Illinois 17031 84581 4173
231210 2020-06-12 Cook Illinois 17031 84249 4162
228108 2020-06-11 Cook Illinois 17031 83978 4111
225008 2020-06-10 Cook Illinois 17031 83585 4053
221914 2020-06-09 Cook Illinois 17031 83271 4010
218821 2020-06-08 Cook Illinois 17031 82819 3959
215732 2020-06-07 Cook Illinois 17031 82427 3944
212647 2020-06-06 Cook Illinois 17031 81924 3913
209564 2020-06-05 Cook Illinois 17031 81344 3880
206485 2020-06-04 Cook Illinois 17031 80713 3846
203408 2020-06-03 Cook Illinois 17031 80204 3780
200335 2020-06-02 Cook Illinois 17031 79673 3726
197265 2020-06-01 Cook Illinois 17031 78495 3658
194198 2020-05-31 Cook Illinois 17031 77925 3642
191134 2020-05-30 Cook Illinois 17031 77119 3603
188072 2020-05-29 Cook Illinois 17031 76266 3570
185018 2020-05-28 Cook Illinois 17031 75306 3519
181967 2020-05-27 Cook Illinois 17031 74521 3455
178926 2020-05-26 Cook Illinois 17031 73819 3354
175885 2020-05-25 Cook Illinois 17031 73097 3324
172844 2020-05-24 Cook Illinois 17031 72010 3304
169806 2020-05-23 Cook Illinois 17031 70417 3246
166772 2020-05-22 Cook Illinois 17031 68949 3187
163742 2020-05-21 Cook Illinois 17031 67551 3114
160717 2020-05-20 Cook Illinois 17031 66213 3074
157694 2020-05-19 Cook Illinois 17031 64691 2980
154681 2020-05-18 Cook Illinois 17031 63690 2889
151672 2020-05-17 Cook Illinois 17031 62218 2839
148666 2020-05-16 Cook Illinois 17031 61212 2814
145666 2020-05-15 Cook Illinois 17031 59905 2762
142669 2020-05-14 Cook Illinois 17031 58457 2675
139676 2020-05-13 Cook Illinois 17031 56406 2589
136688 2020-05-12 Cook Illinois 17031 55470 2449
133702 2020-05-11 Cook Illinois 17031 53381 2361
130714 2020-05-10 Cook Illinois 17031 52655 2317
127726 2020-05-09 Cook Illinois 17031 51674 2264
124742 2020-05-08 Cook Illinois 17031 50236 2197
121766 2020-05-07 Cook Illinois 17031 48341 2110
118800 2020-05-06 Cook Illinois 17031 46689 2004
115844 2020-05-05 Cook Illinois 17031 45223 1922
112965 2020-05-04 Cook Illinois 17031 43715 1802
110094 2020-05-03 Cook Illinois 17031 42324 1786
107228 2020-05-02 Cook Illinois 17031 40227 1743
104367 2020-05-01 Cook Illinois 17031 38668 1673
101515 2020-04-30 Cook Illinois 17031 36513 1607
98668 2020-04-29 Cook Illinois 17031 34880 1516
95828 2020-04-28 Cook Illinois 17031 33449 1457
92999 2020-04-27 Cook Illinois 17031 31953 1347
90183 2020-04-26 Cook Illinois 17031 30574 1313
87370 2020-04-25 Cook Illinois 17031 29058 1267
84563 2020-04-24 Cook Illinois 17031 27616 1220
81766 2020-04-23 Cook Illinois 17031 25811 1142
78976 2020-04-22 Cook Illinois 17031 24546 1072
76195 2020-04-21 Cook Illinois 17031 23181 1002
73422 2020-04-20 Cook Illinois 17031 22101 915
70655 2020-04-19 Cook Illinois 17031 21272 877
67896 2020-04-18 Cook Illinois 17031 20395 860
65151 2020-04-17 Cook Illinois 17031 19391 760
62422 2020-04-16 Cook Illinois 17031 18087 722
59704 2020-04-15 Cook Illinois 17031 17306 630
57000 2020-04-14 Cook Illinois 17031 16323 577
54310 2020-04-13 Cook Illinois 17031 15474 543
51633 2020-04-12 Cook Illinois 17031 14585 485
48974 2020-04-11 Cook Illinois 17031 13417 453
46346 2020-04-10 Cook Illinois 17031 12472 398
43747 2020-04-09 Cook Illinois 17031 11415 351
41176 2020-04-08 Cook Illinois 17031 10520 312
38635 2020-04-07 Cook Illinois 17031 9509 249

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