ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
667 rows where county = "Unknown" and state = "Illinois" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: date (date)
Link | rowid | date | county | state | fips ▼ | cases | deaths |
---|---|---|---|---|---|---|---|
8565 | 8565 | 2020-03-23 | Unknown | Illinois | 58 | 0 | |
9829 | 9829 | 2020-03-24 | Unknown | Illinois | 2 | 0 | |
11222 | 11222 | 2020-03-25 | Unknown | Illinois | 0 | 2 | |
16253 | 16253 | 2020-03-28 | Unknown | Illinois | 3 | 0 | |
20160 | 20160 | 2020-03-30 | Unknown | Illinois | 3 | 0 | |
22253 | 22253 | 2020-03-31 | Unknown | Illinois | 6 | 0 | |
24422 | 24422 | 2020-04-01 | Unknown | Illinois | 16 | 0 | |
26660 | 26660 | 2020-04-02 | Unknown | Illinois | 28 | 0 | |
28970 | 28970 | 2020-04-03 | Unknown | Illinois | 40 | 0 | |
31336 | 31336 | 2020-04-04 | Unknown | Illinois | 15 | 0 | |
33746 | 33746 | 2020-04-05 | Unknown | Illinois | 47 | 0 | |
36198 | 36198 | 2020-04-06 | Unknown | Illinois | 62 | 0 | |
38696 | 38696 | 2020-04-07 | Unknown | Illinois | 34 | 0 | |
41242 | 41242 | 2020-04-08 | Unknown | Illinois | 61 | 0 | |
43818 | 43818 | 2020-04-09 | Unknown | Illinois | 58 | 0 | |
46422 | 46422 | 2020-04-10 | Unknown | Illinois | 76 | 0 | |
49055 | 49055 | 2020-04-11 | Unknown | Illinois | 82 | 0 | |
51717 | 51717 | 2020-04-12 | Unknown | Illinois | 91 | 0 | |
54398 | 54398 | 2020-04-13 | Unknown | Illinois | 62 | 0 | |
57091 | 57091 | 2020-04-14 | Unknown | Illinois | 43 | 0 | |
59799 | 59799 | 2020-04-15 | Unknown | Illinois | 34 | 1 | |
62520 | 62520 | 2020-04-16 | Unknown | Illinois | 51 | 1 | |
65253 | 65253 | 2020-04-17 | Unknown | Illinois | 71 | 0 | |
68002 | 68002 | 2020-04-18 | Unknown | Illinois | 83 | 0 | |
70764 | 70764 | 2020-04-19 | Unknown | Illinois | 114 | 0 | |
73534 | 73534 | 2020-04-20 | Unknown | Illinois | 129 | 0 | |
76311 | 76311 | 2020-04-21 | Unknown | Illinois | 191 | 0 | |
79095 | 79095 | 2020-04-22 | Unknown | Illinois | 228 | 1 | |
81888 | 81888 | 2020-04-23 | Unknown | Illinois | 192 | 0 | |
84688 | 84688 | 2020-04-24 | Unknown | Illinois | 218 | 0 | |
87498 | 87498 | 2020-04-25 | Unknown | Illinois | 274 | 0 | |
90314 | 90314 | 2020-04-26 | Unknown | Illinois | 308 | 0 | |
93133 | 93133 | 2020-04-27 | Unknown | Illinois | 338 | 0 | |
95965 | 95965 | 2020-04-28 | Unknown | Illinois | 335 | 0 | |
98809 | 98809 | 2020-04-29 | Unknown | Illinois | 354 | 0 | |
101660 | 101660 | 2020-04-30 | Unknown | Illinois | 378 | 0 | |
104516 | 104516 | 2020-05-01 | Unknown | Illinois | 363 | 0 | |
107381 | 107381 | 2020-05-02 | Unknown | Illinois | 278 | 0 | |
110251 | 110251 | 2020-05-03 | Unknown | Illinois | 257 | 0 | |
113126 | 113126 | 2020-05-04 | Unknown | Illinois | 277 | 0 | |
116009 | 116009 | 2020-05-05 | Unknown | Illinois | 236 | 0 | |
118969 | 118969 | 2020-05-06 | Unknown | Illinois | 105 | 0 | |
121939 | 121939 | 2020-05-07 | Unknown | Illinois | 102 | 0 | |
124919 | 124919 | 2020-05-08 | Unknown | Illinois | 48 | 0 | |
127906 | 127906 | 2020-05-09 | Unknown | Illinois | 73 | 0 | |
130897 | 130897 | 2020-05-10 | Unknown | Illinois | 84 | 0 | |
219090 | 219090 | 2020-06-08 | Unknown | Illinois | 724 | 178 | |
222185 | 222185 | 2020-06-09 | Unknown | Illinois | 724 | 178 | |
225280 | 225280 | 2020-06-10 | Unknown | Illinois | 724 | 178 | |
228382 | 228382 | 2020-06-11 | Unknown | Illinois | 724 | 178 | |
231485 | 231485 | 2020-06-12 | Unknown | Illinois | 861 | 181 | |
234591 | 234591 | 2020-06-13 | Unknown | Illinois | 861 | 181 | |
237698 | 237698 | 2020-06-14 | Unknown | Illinois | 861 | 181 | |
240806 | 240806 | 2020-06-15 | Unknown | Illinois | 861 | 181 | |
243917 | 243917 | 2020-06-16 | Unknown | Illinois | 861 | 181 | |
247030 | 247030 | 2020-06-17 | Unknown | Illinois | 861 | 181 | |
250142 | 250142 | 2020-06-18 | Unknown | Illinois | 861 | 181 | |
253257 | 253257 | 2020-06-19 | Unknown | Illinois | 1000 | 204 | |
256377 | 256377 | 2020-06-20 | Unknown | Illinois | 1000 | 204 | |
259503 | 259503 | 2020-06-21 | Unknown | Illinois | 1000 | 204 | |
262630 | 262630 | 2020-06-22 | Unknown | Illinois | 1000 | 204 | |
265758 | 265758 | 2020-06-23 | Unknown | Illinois | 1000 | 204 | |
268888 | 268888 | 2020-06-24 | Unknown | Illinois | 1000 | 204 | |
272025 | 272025 | 2020-06-25 | Unknown | Illinois | 1000 | 204 | |
275167 | 275167 | 2020-06-26 | Unknown | Illinois | 1053 | 201 | |
278315 | 278315 | 2020-06-27 | Unknown | Illinois | 1053 | 201 | |
281463 | 281463 | 2020-06-28 | Unknown | Illinois | 1053 | 201 | |
284608 | 284608 | 2020-06-29 | Unknown | Illinois | 1053 | 201 | |
287757 | 287757 | 2020-06-30 | Unknown | Illinois | 1053 | 201 | |
290907 | 290907 | 2020-07-01 | Unknown | Illinois | 1053 | 201 | |
294061 | 294061 | 2020-07-02 | Unknown | Illinois | 1057 | 201 | |
297219 | 297219 | 2020-07-03 | Unknown | Illinois | 1122 | 210 | |
300381 | 300381 | 2020-07-04 | Unknown | Illinois | 1122 | 210 | |
303545 | 303545 | 2020-07-05 | Unknown | Illinois | 1122 | 210 | |
306710 | 306710 | 2020-07-06 | Unknown | Illinois | 1122 | 210 | |
309878 | 309878 | 2020-07-07 | Unknown | Illinois | 1122 | 210 | |
313048 | 313048 | 2020-07-08 | Unknown | Illinois | 1122 | 210 | |
316222 | 316222 | 2020-07-09 | Unknown | Illinois | 1122 | 210 | |
319395 | 319395 | 2020-07-10 | Unknown | Illinois | 1132 | 201 | |
322574 | 322574 | 2020-07-11 | Unknown | Illinois | 1132 | 201 | |
325755 | 325755 | 2020-07-12 | Unknown | Illinois | 1132 | 201 | |
328941 | 328941 | 2020-07-13 | Unknown | Illinois | 1132 | 201 | |
332128 | 332128 | 2020-07-14 | Unknown | Illinois | 1132 | 201 | |
335321 | 335321 | 2020-07-15 | Unknown | Illinois | 1132 | 201 | |
338517 | 338517 | 2020-07-16 | Unknown | Illinois | 1132 | 201 | |
341713 | 341713 | 2020-07-17 | Unknown | Illinois | 1175 | 193 | |
344913 | 344913 | 2020-07-18 | Unknown | Illinois | 1175 | 193 | |
348114 | 348114 | 2020-07-19 | Unknown | Illinois | 1175 | 193 | |
351314 | 351314 | 2020-07-20 | Unknown | Illinois | 1175 | 193 | |
354516 | 354516 | 2020-07-21 | Unknown | Illinois | 1175 | 193 | |
357718 | 357718 | 2020-07-22 | Unknown | Illinois | 1175 | 193 | |
360923 | 360923 | 2020-07-23 | Unknown | Illinois | 1175 | 193 | |
364130 | 364130 | 2020-07-24 | Unknown | Illinois | 1209 | 192 | |
367337 | 367337 | 2020-07-25 | Unknown | Illinois | 1230 | 192 | |
370547 | 370547 | 2020-07-26 | Unknown | Illinois | 1191 | 192 | |
373759 | 373759 | 2020-07-27 | Unknown | Illinois | 1191 | 192 | |
376974 | 376974 | 2020-07-28 | Unknown | Illinois | 1191 | 192 | |
380191 | 380191 | 2020-07-29 | Unknown | Illinois | 1191 | 192 | |
383408 | 383408 | 2020-07-30 | Unknown | Illinois | 1190 | 192 | |
386626 | 386626 | 2020-07-31 | Unknown | Illinois | 1229 | 197 |
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);