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

238 rows where cases = 11 and state = "Illinois" sorted by date descending

✎ View and edit SQL

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

Suggested facets: deaths, date (date)

fips >30

state 1

  • Illinois · 238 ✖
Link rowid date ▲ county state fips cases deaths
467185 467185 2020-08-25 Pope Illinois 17151 11 0
463956 463956 2020-08-24 Pope Illinois 17151 11 0
460727 460727 2020-08-23 Pope Illinois 17151 11 0
457500 457500 2020-08-22 Pope Illinois 17151 11 0
454272 454272 2020-08-21 Pope Illinois 17151 11 0
451044 451044 2020-08-20 Pope Illinois 17151 11 0
447816 447816 2020-08-19 Pope Illinois 17151 11 0
444589 444589 2020-08-18 Pope Illinois 17151 11 0
441363 441363 2020-08-17 Pope Illinois 17151 11 0
438137 438137 2020-08-16 Pope Illinois 17151 11 0
434911 434911 2020-08-15 Pope Illinois 17151 11 0
431686 431686 2020-08-14 Pope Illinois 17151 11 0
428458 428458 2020-08-13 Pope Illinois 17151 11 0
425165 425165 2020-08-12 Calhoun Illinois 17013 11 0
425234 425234 2020-08-12 Pope Illinois 17151 11 0
422013 422013 2020-08-11 Pope Illinois 17151 11 0
412351 412351 2020-08-08 Putnam Illinois 17155 11 0
409132 409132 2020-08-07 Putnam Illinois 17155 11 0
405912 405912 2020-08-06 Putnam Illinois 17155 11 0
399485 399485 2020-08-04 Scott Illinois 17171 11 0
396269 396269 2020-08-03 Scott Illinois 17171 11 0
380174 380174 2020-07-29 Pike Illinois 17149 11 0
376957 376957 2020-07-28 Pike Illinois 17149 11 0
376962 376962 2020-07-28 Richland Illinois 17159 11 0
373742 373742 2020-07-27 Pike Illinois 17149 11 0
370530 370530 2020-07-26 Pike Illinois 17149 11 0
367278 367278 2020-07-25 Hamilton Illinois 17065 11 0
367325 367325 2020-07-25 Richland Illinois 17159 11 0
364071 364071 2020-07-24 Hamilton Illinois 17065 11 0
360864 360864 2020-07-23 Hamilton Illinois 17065 11 0
357631 357631 2020-07-22 Brown Illinois 17009 11 0
357659 357659 2020-07-22 Hamilton Illinois 17065 11 0
354429 354429 2020-07-21 Brown Illinois 17009 11 0
354457 354457 2020-07-21 Hamilton Illinois 17065 11 0
351227 351227 2020-07-20 Brown Illinois 17009 11 0
351255 351255 2020-07-20 Hamilton Illinois 17065 11 0
348027 348027 2020-07-19 Brown Illinois 17009 11 0
332067 332067 2020-07-14 Greene Illinois 17061 11 0
328880 328880 2020-07-13 Greene Illinois 17061 11 0
316212 316212 2020-07-09 Saline Illinois 17165 11 0
309809 309809 2020-07-07 Edgar Illinois 17045 11 0
306677 306677 2020-07-06 Marshall Illinois 17123 11 0
300308 300308 2020-07-04 De Witt Illinois 17039 11 0
287684 287684 2020-06-30 Cumberland Illinois 17035 11 0
287727 287727 2020-06-30 Massac Illinois 17127 11 0
284535 284535 2020-06-29 Cumberland Illinois 17035 11 0
284542 284542 2020-06-29 Effingham Illinois 17049 11 1
284578 284578 2020-06-29 Massac Illinois 17127 11 0
281390 281390 2020-06-28 Cumberland Illinois 17035 11 0
281397 281397 2020-06-28 Effingham Illinois 17049 11 1
281433 281433 2020-06-28 Massac Illinois 17127 11 0
278242 278242 2020-06-27 Cumberland Illinois 17035 11 0
278249 278249 2020-06-27 Effingham Illinois 17049 11 1
275101 275101 2020-06-26 Effingham Illinois 17049 11 1
271959 271959 2020-06-25 Effingham Illinois 17049 11 1
268893 268893 2020-06-24 Wayne Illinois 17191 11 1
265692 265692 2020-06-23 Effingham Illinois 17049 11 1
265763 265763 2020-06-23 Wayne Illinois 17191 11 1
262635 262635 2020-06-22 Wayne Illinois 17191 11 1
259508 259508 2020-06-21 Wayne Illinois 17191 11 1
256382 256382 2020-06-20 Wayne Illinois 17191 11 1
253262 253262 2020-06-19 Wayne Illinois 17191 11 1
250105 250105 2020-06-18 Logan Illinois 17107 11 0
246968 246968 2020-06-17 Fulton Illinois 17057 11 0
246993 246993 2020-06-17 Logan Illinois 17107 11 0
243880 243880 2020-06-16 Logan Illinois 17107 11 0
243900 243900 2020-06-16 Piatt Illinois 17147 11 0
240769 240769 2020-06-15 Logan Illinois 17107 11 0
240789 240789 2020-06-15 Piatt Illinois 17147 11 0
237661 237661 2020-06-14 Logan Illinois 17107 11 0
237681 237681 2020-06-14 Piatt Illinois 17147 11 0
234574 234574 2020-06-13 Piatt Illinois 17147 11 0
231468 231468 2020-06-12 Piatt Illinois 17147 11 0
228308 228308 2020-06-11 Crawford Illinois 17033 11 0
228365 228365 2020-06-11 Piatt Illinois 17147 11 0
225206 225206 2020-06-10 Crawford Illinois 17033 11 0
225263 225263 2020-06-10 Piatt Illinois 17147 11 0
222111 222111 2020-06-09 Crawford Illinois 17033 11 0
222168 222168 2020-06-09 Piatt Illinois 17147 11 0
219016 219016 2020-06-08 Crawford Illinois 17033 11 0
215920 215920 2020-06-07 Clark Illinois 17023 11 0
215925 215925 2020-06-07 Crawford Illinois 17033 11 0
212833 212833 2020-06-06 Clark Illinois 17023 11 0
212838 212838 2020-06-06 Crawford Illinois 17033 11 0
212895 212895 2020-06-06 Piatt Illinois 17147 11 0
209748 209748 2020-06-05 Clark Illinois 17023 11 0
209753 209753 2020-06-05 Crawford Illinois 17033 11 0
209780 209780 2020-06-05 Johnson Illinois 17087 11 0
209790 209790 2020-06-05 Logan Illinois 17107 11 0
209810 209810 2020-06-05 Piatt Illinois 17147 11 0
206667 206667 2020-06-04 Clark Illinois 17023 11 0
206672 206672 2020-06-04 Crawford Illinois 17033 11 0
206699 206699 2020-06-04 Johnson Illinois 17087 11 0
206709 206709 2020-06-04 Logan Illinois 17107 11 0
206729 206729 2020-06-04 Piatt Illinois 17147 11 0
203587 203587 2020-06-03 Clark Illinois 17023 11 0
203629 203629 2020-06-03 Logan Illinois 17107 11 0
203649 203649 2020-06-03 Piatt Illinois 17147 11 0
200511 200511 2020-06-02 Clark Illinois 17023 11 0
200553 200553 2020-06-02 Logan Illinois 17107 11 0

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