ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 121 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
794543 | 794543 | 2020-12-04 | Pope | Illinois | 17151 | 121 | 1 |
710104 | 710104 | 2020-11-08 | Calhoun | Illinois | 17013 | 121 | 0 |
700445 | 700445 | 2020-11-05 | Putnam | Illinois | 17155 | 121 | 0 |
693966 | 693966 | 2020-11-03 | Scott | Illinois | 17171 | 121 | 0 |
684154 | 684154 | 2020-10-31 | Brown | Illinois | 17009 | 121 | 0 |
680911 | 680911 | 2020-10-30 | Brown | Illinois | 17009 | 121 | 0 |
658238 | 658238 | 2020-10-23 | Henderson | Illinois | 17071 | 121 | 0 |
654993 | 654993 | 2020-10-22 | Henderson | Illinois | 17071 | 121 | 0 |
619323 | 619323 | 2020-10-11 | Marshall | Illinois | 17123 | 121 | 1 |
603077 | 603077 | 2020-10-06 | Edgar | Illinois | 17045 | 121 | 8 |
586906 | 586906 | 2020-10-01 | Massac | Illinois | 17127 | 121 | 2 |
564233 | 564233 | 2020-09-24 | Pike | Illinois | 17149 | 121 | 1 |
512383 | 512383 | 2020-09-08 | Clark | Illinois | 17023 | 121 | 2 |
505918 | 505918 | 2020-09-06 | Clark | Illinois | 17023 | 121 | 2 |
502684 | 502684 | 2020-09-05 | Clark | Illinois | 17023 | 121 | 2 |
486582 | 486582 | 2020-08-31 | Pulaski | Illinois | 17153 | 121 | 1 |
483347 | 483347 | 2020-08-30 | Pulaski | Illinois | 17153 | 121 | 1 |
483368 | 483368 | 2020-08-30 | White | Illinois | 17193 | 121 | 0 |
480113 | 480113 | 2020-08-29 | Pulaski | Illinois | 17153 | 121 | 1 |
405877 | 405877 | 2020-08-06 | Jo Daviess | Illinois | 17085 | 121 | 1 |
380161 | 380161 | 2020-07-29 | McDonough | Illinois | 17109 | 121 | 15 |
376944 | 376944 | 2020-07-28 | McDonough | Illinois | 17109 | 121 | 15 |
373729 | 373729 | 2020-07-27 | McDonough | Illinois | 17109 | 121 | 15 |
370517 | 370517 | 2020-07-26 | McDonough | Illinois | 17109 | 121 | 15 |
367307 | 367307 | 2020-07-25 | McDonough | Illinois | 17109 | 121 | 15 |
364090 | 364090 | 2020-07-24 | Lee | Illinois | 17103 | 121 | 2 |
348115 | 348115 | 2020-07-19 | Vermilion | Illinois | 17183 | 121 | 2 |
294070 | 294070 | 2020-07-02 | Williamson | Illinois | 17199 | 121 | 4 |
275085 | 275085 | 2020-06-26 | Cass | Illinois | 17017 | 121 | 1 |
271982 | 271982 | 2020-06-25 | Knox | Illinois | 17095 | 121 | 0 |
265736 | 265736 | 2020-06-23 | Morgan | Illinois | 17137 | 121 | 3 |
157864 | 157864 | 2020-05-19 | LaSalle | Illinois | 17099 | 121 | 8 |
154848 | 154848 | 2020-05-18 | LaSalle | Illinois | 17099 | 121 | 8 |
148827 | 148827 | 2020-05-16 | LaSalle | Illinois | 17099 | 121 | 8 |
133862 | 133862 | 2020-05-11 | McLean | Illinois | 17113 | 121 | 3 |
62528 | 62528 | 2020-04-16 | Winnebago | Illinois | 17201 | 121 | 8 |
Advanced export
JSON shape: default, array, newline-delimited
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);