ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
36 rows where cases = 93 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
674504 | 674504 | 2020-10-28 | Schuyler | Illinois | 17169 | 93 | 1 |
671256 | 671256 | 2020-10-27 | Putnam | Illinois | 17155 | 93 | 0 |
645308 | 645308 | 2020-10-19 | Scott | Illinois | 17171 | 93 | 0 |
642061 | 642061 | 2020-10-18 | Scott | Illinois | 17171 | 93 | 0 |
638734 | 638734 | 2020-10-17 | Brown | Illinois | 17009 | 93 | 0 |
635507 | 635507 | 2020-10-16 | Edwards | Illinois | 17047 | 93 | 0 |
632273 | 632273 | 2020-10-15 | Henderson | Illinois | 17071 | 93 | 0 |
629029 | 629029 | 2020-10-14 | Henderson | Illinois | 17071 | 93 | 0 |
548028 | 548028 | 2020-09-19 | Massac | Illinois | 17127 | 93 | 2 |
544748 | 544748 | 2020-09-18 | De Witt | Illinois | 17039 | 93 | 1 |
525377 | 525377 | 2020-09-12 | Menard | Illinois | 17129 | 93 | 0 |
518914 | 518914 | 2020-09-10 | Pike | Illinois | 17149 | 93 | 1 |
499461 | 499461 | 2020-09-04 | Edgar | Illinois | 17045 | 93 | 2 |
473621 | 473621 | 2020-08-27 | Lawrence | Illinois | 17101 | 93 | 0 |
463974 | 463974 | 2020-08-24 | Wabash | Illinois | 17185 | 93 | 1 |
457455 | 457455 | 2020-08-22 | Greene | Illinois | 17061 | 93 | 0 |
457518 | 457518 | 2020-08-22 | Wabash | Illinois | 17185 | 93 | 1 |
434847 | 434847 | 2020-08-15 | Clark | Illinois | 17023 | 93 | 2 |
425228 | 425228 | 2020-08-12 | Moultrie | Illinois | 17139 | 93 | 0 |
415570 | 415570 | 2020-08-09 | Pulaski | Illinois | 17153 | 93 | 1 |
412350 | 412350 | 2020-08-08 | Pulaski | Illinois | 17153 | 93 | 0 |
351280 | 351280 | 2020-07-20 | Marion | Illinois | 17121 | 93 | 0 |
297164 | 297164 | 2020-07-03 | Henry | Illinois | 17073 | 93 | 1 |
290817 | 290817 | 2020-07-01 | Adams | Illinois | 17001 | 93 | 1 |
262639 | 262639 | 2020-06-22 | Williamson | Illinois | 17199 | 93 | 4 |
259512 | 259512 | 2020-06-21 | Williamson | Illinois | 17199 | 93 | 4 |
225251 | 225251 | 2020-06-10 | McDonough | Illinois | 17109 | 93 | 15 |
206717 | 206717 | 2020-06-04 | McDonough | Illinois | 17109 | 93 | 13 |
185233 | 185233 | 2020-05-28 | Monroe | Illinois | 17133 | 93 | 11 |
182179 | 182179 | 2020-05-27 | Monroe | Illinois | 17133 | 93 | 11 |
166950 | 166950 | 2020-05-22 | Knox | Illinois | 17095 | 93 | 0 |
124878 | 124878 | 2020-05-08 | LaSalle | Illinois | 17099 | 93 | 3 |
124922 | 124922 | 2020-05-08 | Warren | Illinois | 17187 | 93 | 0 |
104499 | 104499 | 2020-05-01 | Peoria | Illinois | 17143 | 93 | 3 |
79061 | 79061 | 2020-04-22 | Macon | Illinois | 17115 | 93 | 10 |
67926 | 67926 | 2020-04-18 | Champaign | Illinois | 17019 | 93 | 4 |
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);