ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
318 rows where deaths = 70 and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
2500251 | 2500251 | 2022-05-13 | Pike | Illinois | 17149 | 5050 | 70 |
2496993 | 2496993 | 2022-05-12 | Pike | Illinois | 17149 | 5047 | 70 |
2493735 | 2493735 | 2022-05-11 | Pike | Illinois | 17149 | 5044 | 70 |
2490477 | 2490477 | 2022-05-10 | Pike | Illinois | 17149 | 5045 | 70 |
2487220 | 2487220 | 2022-05-09 | Pike | Illinois | 17149 | 5044 | 70 |
2483962 | 2483962 | 2022-05-08 | Pike | Illinois | 17149 | 5042 | 70 |
2480704 | 2480704 | 2022-05-07 | Pike | Illinois | 17149 | 5042 | 70 |
2477446 | 2477446 | 2022-05-06 | Pike | Illinois | 17149 | 5042 | 70 |
2474188 | 2474188 | 2022-05-05 | Pike | Illinois | 17149 | 5042 | 70 |
2470931 | 2470931 | 2022-05-04 | Pike | Illinois | 17149 | 5041 | 70 |
2467675 | 2467675 | 2022-05-03 | Pike | Illinois | 17149 | 5038 | 70 |
2464420 | 2464420 | 2022-05-02 | Pike | Illinois | 17149 | 5038 | 70 |
2461164 | 2461164 | 2022-05-01 | Pike | Illinois | 17149 | 5038 | 70 |
2457908 | 2457908 | 2022-04-30 | Pike | Illinois | 17149 | 5038 | 70 |
2454652 | 2454652 | 2022-04-29 | Pike | Illinois | 17149 | 5038 | 70 |
2451396 | 2451396 | 2022-04-28 | Pike | Illinois | 17149 | 5038 | 70 |
2448140 | 2448140 | 2022-04-27 | Pike | Illinois | 17149 | 5038 | 70 |
2444884 | 2444884 | 2022-04-26 | Pike | Illinois | 17149 | 5038 | 70 |
2441628 | 2441628 | 2022-04-25 | Pike | Illinois | 17149 | 5038 | 70 |
2438372 | 2438372 | 2022-04-24 | Pike | Illinois | 17149 | 5034 | 70 |
2435116 | 2435116 | 2022-04-23 | Pike | Illinois | 17149 | 5034 | 70 |
2431860 | 2431860 | 2022-04-22 | Pike | Illinois | 17149 | 5034 | 70 |
2428604 | 2428604 | 2022-04-21 | Pike | Illinois | 17149 | 5036 | 70 |
2425348 | 2425348 | 2022-04-20 | Pike | Illinois | 17149 | 5037 | 70 |
2422092 | 2422092 | 2022-04-19 | Pike | Illinois | 17149 | 5036 | 70 |
2418836 | 2418836 | 2022-04-18 | Pike | Illinois | 17149 | 5037 | 70 |
2415580 | 2415580 | 2022-04-17 | Pike | Illinois | 17149 | 5035 | 70 |
2412324 | 2412324 | 2022-04-16 | Pike | Illinois | 17149 | 5035 | 70 |
2409068 | 2409068 | 2022-04-15 | Pike | Illinois | 17149 | 5035 | 70 |
2405812 | 2405812 | 2022-04-14 | Pike | Illinois | 17149 | 5034 | 70 |
2402557 | 2402557 | 2022-04-13 | Pike | Illinois | 17149 | 5034 | 70 |
2399302 | 2399302 | 2022-04-12 | Pike | Illinois | 17149 | 5033 | 70 |
2396047 | 2396047 | 2022-04-11 | Pike | Illinois | 17149 | 5031 | 70 |
2379756 | 2379756 | 2022-04-06 | Massac | Illinois | 17127 | 3868 | 70 |
2324453 | 2324453 | 2022-03-20 | Massac | Illinois | 17127 | 3856 | 70 |
2321199 | 2321199 | 2022-03-19 | Massac | Illinois | 17127 | 3856 | 70 |
2317945 | 2317945 | 2022-03-18 | Massac | Illinois | 17127 | 3856 | 70 |
2314692 | 2314692 | 2022-03-17 | Massac | Illinois | 17127 | 3857 | 70 |
2262609 | 2262609 | 2022-03-01 | Clay | Illinois | 17025 | 4726 | 70 |
2259358 | 2259358 | 2022-02-28 | Clay | Illinois | 17025 | 4725 | 70 |
2256107 | 2256107 | 2022-02-27 | Clay | Illinois | 17025 | 4723 | 70 |
2252856 | 2252856 | 2022-02-26 | Clay | Illinois | 17025 | 4723 | 70 |
2249605 | 2249605 | 2022-02-25 | Clay | Illinois | 17025 | 4723 | 70 |
2246354 | 2246354 | 2022-02-24 | Clay | Illinois | 17025 | 4718 | 70 |
2243103 | 2243103 | 2022-02-23 | Clay | Illinois | 17025 | 4712 | 70 |
2217168 | 2217168 | 2022-02-15 | Shelby | Illinois | 17173 | 6085 | 70 |
2213917 | 2213917 | 2022-02-14 | Shelby | Illinois | 17173 | 6079 | 70 |
2210665 | 2210665 | 2022-02-13 | Shelby | Illinois | 17173 | 6050 | 70 |
2207412 | 2207412 | 2022-02-12 | Shelby | Illinois | 17173 | 6050 | 70 |
2204159 | 2204159 | 2022-02-11 | Shelby | Illinois | 17173 | 6050 | 70 |
2200906 | 2200906 | 2022-02-10 | Shelby | Illinois | 17173 | 6050 | 70 |
2191085 | 2191085 | 2022-02-07 | Ford | Illinois | 17053 | 4297 | 70 |
2187832 | 2187832 | 2022-02-06 | Ford | Illinois | 17053 | 4284 | 70 |
2184579 | 2184579 | 2022-02-05 | Ford | Illinois | 17053 | 4284 | 70 |
2181327 | 2181327 | 2022-02-04 | Ford | Illinois | 17053 | 4284 | 70 |
2178076 | 2178076 | 2022-02-03 | Ford | Illinois | 17053 | 4252 | 70 |
2174823 | 2174823 | 2022-02-02 | Ford | Illinois | 17053 | 4252 | 70 |
2171570 | 2171570 | 2022-02-01 | Ford | Illinois | 17053 | 4229 | 70 |
2168317 | 2168317 | 2022-01-31 | Ford | Illinois | 17053 | 4217 | 70 |
2165062 | 2165062 | 2022-01-30 | Ford | Illinois | 17053 | 4176 | 70 |
2161807 | 2161807 | 2022-01-29 | Ford | Illinois | 17053 | 4176 | 70 |
2158552 | 2158552 | 2022-01-28 | Ford | Illinois | 17053 | 4176 | 70 |
2155298 | 2155298 | 2022-01-27 | Ford | Illinois | 17053 | 4143 | 70 |
2152045 | 2152045 | 2022-01-26 | Ford | Illinois | 17053 | 4112 | 70 |
2148793 | 2148793 | 2022-01-25 | Ford | Illinois | 17053 | 4092 | 70 |
2145541 | 2145541 | 2022-01-24 | Ford | Illinois | 17053 | 4059 | 70 |
2142286 | 2142286 | 2022-01-23 | Ford | Illinois | 17053 | 3991 | 70 |
2139031 | 2139031 | 2022-01-22 | Ford | Illinois | 17053 | 3991 | 70 |
2135775 | 2135775 | 2022-01-21 | Ford | Illinois | 17053 | 3991 | 70 |
2132523 | 2132523 | 2022-01-20 | Ford | Illinois | 17053 | 3954 | 70 |
2129270 | 2129270 | 2022-01-19 | Ford | Illinois | 17053 | 3904 | 70 |
2126016 | 2126016 | 2022-01-18 | Ford | Illinois | 17053 | 3862 | 70 |
2122764 | 2122764 | 2022-01-17 | Ford | Illinois | 17053 | 3718 | 70 |
2119512 | 2119512 | 2022-01-16 | Ford | Illinois | 17053 | 3718 | 70 |
2116260 | 2116260 | 2022-01-15 | Ford | Illinois | 17053 | 3718 | 70 |
2113009 | 2113009 | 2022-01-14 | Ford | Illinois | 17053 | 3718 | 70 |
2109757 | 2109757 | 2022-01-13 | Ford | Illinois | 17053 | 3680 | 70 |
2109827 | 2109827 | 2022-01-13 | Wayne | Illinois | 17191 | 4012 | 70 |
2106576 | 2106576 | 2022-01-12 | Wayne | Illinois | 17191 | 3951 | 70 |
1992727 | 1992727 | 2021-12-08 | Edgar | Illinois | 17045 | 3064 | 70 |
1989476 | 1989476 | 2021-12-07 | Edgar | Illinois | 17045 | 3054 | 70 |
1986226 | 1986226 | 2021-12-06 | Edgar | Illinois | 17045 | 2999 | 70 |
1982976 | 1982976 | 2021-12-05 | Edgar | Illinois | 17045 | 2962 | 70 |
1979726 | 1979726 | 2021-12-04 | Edgar | Illinois | 17045 | 2962 | 70 |
1976476 | 1976476 | 2021-12-03 | Edgar | Illinois | 17045 | 2962 | 70 |
1973227 | 1973227 | 2021-12-02 | Edgar | Illinois | 17045 | 2932 | 70 |
1969977 | 1969977 | 2021-12-01 | Edgar | Illinois | 17045 | 2912 | 70 |
1966727 | 1966727 | 2021-11-30 | Edgar | Illinois | 17045 | 2896 | 70 |
1966784 | 1966784 | 2021-11-30 | Richland | Illinois | 17159 | 3131 | 70 |
1963475 | 1963475 | 2021-11-29 | Edgar | Illinois | 17045 | 2875 | 70 |
1963532 | 1963532 | 2021-11-29 | Richland | Illinois | 17159 | 3109 | 70 |
1960224 | 1960224 | 2021-11-28 | Edgar | Illinois | 17045 | 2829 | 70 |
1956973 | 1956973 | 2021-11-27 | Edgar | Illinois | 17045 | 2829 | 70 |
1953722 | 1953722 | 2021-11-26 | Edgar | Illinois | 17045 | 2829 | 70 |
1950471 | 1950471 | 2021-11-25 | Edgar | Illinois | 17045 | 2829 | 70 |
1947220 | 1947220 | 2021-11-24 | Edgar | Illinois | 17045 | 2829 | 70 |
1943969 | 1943969 | 2021-11-23 | Edgar | Illinois | 17045 | 2815 | 70 |
1940719 | 1940719 | 2021-11-22 | Edgar | Illinois | 17045 | 2800 | 70 |
1937469 | 1937469 | 2021-11-21 | Edgar | Illinois | 17045 | 2789 | 70 |
1934219 | 1934219 | 2021-11-20 | Edgar | Illinois | 17045 | 2789 | 70 |
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);