ny_times_us_counties
Data license: LICENSE · Data source: The New York Times · About: simonw/covid-19-datasette
795 rows where county = "Kane" and state = "Illinois" sorted by date descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | date ▲ | county | state | fips | cases | deaths |
---|---|---|---|---|---|---|---|
535065 | 535065 | 2020-09-15 | Kane | Illinois | 17089 | 12254 | 326 |
531830 | 531830 | 2020-09-14 | Kane | Illinois | 17089 | 12188 | 325 |
528593 | 528593 | 2020-09-13 | Kane | Illinois | 17089 | 12097 | 325 |
525357 | 525357 | 2020-09-12 | Kane | Illinois | 17089 | 12097 | 324 |
522121 | 522121 | 2020-09-11 | Kane | Illinois | 17089 | 12047 | 322 |
518884 | 518884 | 2020-09-10 | Kane | Illinois | 17089 | 11938 | 320 |
515649 | 515649 | 2020-09-09 | Kane | Illinois | 17089 | 11878 | 318 |
512416 | 512416 | 2020-09-08 | Kane | Illinois | 17089 | 11807 | 317 |
509183 | 509183 | 2020-09-07 | Kane | Illinois | 17089 | 11775 | 317 |
505951 | 505951 | 2020-09-06 | Kane | Illinois | 17089 | 11737 | 317 |
502717 | 502717 | 2020-09-05 | Kane | Illinois | 17089 | 11705 | 317 |
499483 | 499483 | 2020-09-04 | Kane | Illinois | 17089 | 11623 | 317 |
496250 | 496250 | 2020-09-03 | Kane | Illinois | 17089 | 11444 | 317 |
493016 | 493016 | 2020-09-02 | Kane | Illinois | 17089 | 11394 | 314 |
489783 | 489783 | 2020-09-01 | Kane | Illinois | 17089 | 11326 | 313 |
486550 | 486550 | 2020-08-31 | Kane | Illinois | 17089 | 11240 | 312 |
483315 | 483315 | 2020-08-30 | Kane | Illinois | 17089 | 11203 | 312 |
480081 | 480081 | 2020-08-29 | Kane | Illinois | 17089 | 11162 | 312 |
476848 | 476848 | 2020-08-28 | Kane | Illinois | 17089 | 11114 | 312 |
473615 | 473615 | 2020-08-27 | Kane | Illinois | 17089 | 11066 | 312 |
470383 | 470383 | 2020-08-26 | Kane | Illinois | 17089 | 11007 | 312 |
467154 | 467154 | 2020-08-25 | Kane | Illinois | 17089 | 10932 | 308 |
463925 | 463925 | 2020-08-24 | Kane | Illinois | 17089 | 10863 | 308 |
460696 | 460696 | 2020-08-23 | Kane | Illinois | 17089 | 10814 | 308 |
457469 | 457469 | 2020-08-22 | Kane | Illinois | 17089 | 10789 | 308 |
454241 | 454241 | 2020-08-21 | Kane | Illinois | 17089 | 10673 | 307 |
451013 | 451013 | 2020-08-20 | Kane | Illinois | 17089 | 10577 | 307 |
447785 | 447785 | 2020-08-19 | Kane | Illinois | 17089 | 10489 | 306 |
444558 | 444558 | 2020-08-18 | Kane | Illinois | 17089 | 10458 | 306 |
441332 | 441332 | 2020-08-17 | Kane | Illinois | 17089 | 10366 | 305 |
438106 | 438106 | 2020-08-16 | Kane | Illinois | 17089 | 10296 | 305 |
434880 | 434880 | 2020-08-15 | Kane | Illinois | 17089 | 10224 | 305 |
431655 | 431655 | 2020-08-14 | Kane | Illinois | 17089 | 10169 | 305 |
428427 | 428427 | 2020-08-13 | Kane | Illinois | 17089 | 10098 | 305 |
425203 | 425203 | 2020-08-12 | Kane | Illinois | 17089 | 10012 | 305 |
421982 | 421982 | 2020-08-11 | Kane | Illinois | 17089 | 9933 | 305 |
418759 | 418759 | 2020-08-10 | Kane | Illinois | 17089 | 9875 | 305 |
415538 | 415538 | 2020-08-09 | Kane | Illinois | 17089 | 9814 | 305 |
412318 | 412318 | 2020-08-08 | Kane | Illinois | 17089 | 9755 | 305 |
409099 | 409099 | 2020-08-07 | Kane | Illinois | 17089 | 9684 | 303 |
405879 | 405879 | 2020-08-06 | Kane | Illinois | 17089 | 9582 | 302 |
402661 | 402661 | 2020-08-05 | Kane | Illinois | 17089 | 9502 | 301 |
399445 | 399445 | 2020-08-04 | Kane | Illinois | 17089 | 9401 | 299 |
396229 | 396229 | 2020-08-03 | Kane | Illinois | 17089 | 9330 | 299 |
393013 | 393013 | 2020-08-02 | Kane | Illinois | 17089 | 9253 | 299 |
389796 | 389796 | 2020-08-01 | Kane | Illinois | 17089 | 9218 | 298 |
386579 | 386579 | 2020-07-31 | Kane | Illinois | 17089 | 9148 | 298 |
383361 | 383361 | 2020-07-30 | Kane | Illinois | 17089 | 9065 | 297 |
380144 | 380144 | 2020-07-29 | Kane | Illinois | 17089 | 8979 | 297 |
376927 | 376927 | 2020-07-28 | Kane | Illinois | 17089 | 8899 | 294 |
373712 | 373712 | 2020-07-27 | Kane | Illinois | 17089 | 8853 | 294 |
370500 | 370500 | 2020-07-26 | Kane | Illinois | 17089 | 8738 | 294 |
367290 | 367290 | 2020-07-25 | Kane | Illinois | 17089 | 8738 | 294 |
364083 | 364083 | 2020-07-24 | Kane | Illinois | 17089 | 8694 | 294 |
360876 | 360876 | 2020-07-23 | Kane | Illinois | 17089 | 8623 | 294 |
357671 | 357671 | 2020-07-22 | Kane | Illinois | 17089 | 8548 | 294 |
354469 | 354469 | 2020-07-21 | Kane | Illinois | 17089 | 8496 | 292 |
351267 | 351267 | 2020-07-20 | Kane | Illinois | 17089 | 8473 | 290 |
348067 | 348067 | 2020-07-19 | Kane | Illinois | 17089 | 8448 | 289 |
344866 | 344866 | 2020-07-18 | Kane | Illinois | 17089 | 8397 | 289 |
341666 | 341666 | 2020-07-17 | Kane | Illinois | 17089 | 8352 | 288 |
338470 | 338470 | 2020-07-16 | Kane | Illinois | 17089 | 8320 | 288 |
335274 | 335274 | 2020-07-15 | Kane | Illinois | 17089 | 8274 | 286 |
332081 | 332081 | 2020-07-14 | Kane | Illinois | 17089 | 8214 | 285 |
328894 | 328894 | 2020-07-13 | Kane | Illinois | 17089 | 8196 | 281 |
325708 | 325708 | 2020-07-12 | Kane | Illinois | 17089 | 8160 | 281 |
322527 | 322527 | 2020-07-11 | Kane | Illinois | 17089 | 8139 | 281 |
319348 | 319348 | 2020-07-10 | Kane | Illinois | 17089 | 8028 | 281 |
316175 | 316175 | 2020-07-09 | Kane | Illinois | 17089 | 7998 | 281 |
313001 | 313001 | 2020-07-08 | Kane | Illinois | 17089 | 7998 | 280 |
309831 | 309831 | 2020-07-07 | Kane | Illinois | 17089 | 7964 | 277 |
306663 | 306663 | 2020-07-06 | Kane | Illinois | 17089 | 7933 | 277 |
303498 | 303498 | 2020-07-05 | Kane | Illinois | 17089 | 7917 | 277 |
300334 | 300334 | 2020-07-04 | Kane | Illinois | 17089 | 7890 | 277 |
297172 | 297172 | 2020-07-03 | Kane | Illinois | 17089 | 7858 | 275 |
294015 | 294015 | 2020-07-02 | Kane | Illinois | 17089 | 7817 | 273 |
290861 | 290861 | 2020-07-01 | Kane | Illinois | 17089 | 7792 | 272 |
287711 | 287711 | 2020-06-30 | Kane | Illinois | 17089 | 7750 | 269 |
284562 | 284562 | 2020-06-29 | Kane | Illinois | 17089 | 7729 | 266 |
281417 | 281417 | 2020-06-28 | Kane | Illinois | 17089 | 7683 | 266 |
278269 | 278269 | 2020-06-27 | Kane | Illinois | 17089 | 7656 | 265 |
275121 | 275121 | 2020-06-26 | Kane | Illinois | 17089 | 7638 | 262 |
271979 | 271979 | 2020-06-25 | Kane | Illinois | 17089 | 7597 | 257 |
268842 | 268842 | 2020-06-24 | Kane | Illinois | 17089 | 7553 | 255 |
265712 | 265712 | 2020-06-23 | Kane | Illinois | 17089 | 7514 | 254 |
262584 | 262584 | 2020-06-22 | Kane | Illinois | 17089 | 7485 | 252 |
259457 | 259457 | 2020-06-21 | Kane | Illinois | 17089 | 7461 | 251 |
256331 | 256331 | 2020-06-20 | Kane | Illinois | 17089 | 7415 | 250 |
253211 | 253211 | 2020-06-19 | Kane | Illinois | 17089 | 7342 | 245 |
250096 | 250096 | 2020-06-18 | Kane | Illinois | 17089 | 7286 | 242 |
246984 | 246984 | 2020-06-17 | Kane | Illinois | 17089 | 7246 | 240 |
243871 | 243871 | 2020-06-16 | Kane | Illinois | 17089 | 7223 | 234 |
240760 | 240760 | 2020-06-15 | Kane | Illinois | 17089 | 7175 | 234 |
237652 | 237652 | 2020-06-14 | Kane | Illinois | 17089 | 7154 | 231 |
234545 | 234545 | 2020-06-13 | Kane | Illinois | 17089 | 7126 | 230 |
231439 | 231439 | 2020-06-12 | Kane | Illinois | 17089 | 7074 | 228 |
228336 | 228336 | 2020-06-11 | Kane | Illinois | 17089 | 7053 | 227 |
225234 | 225234 | 2020-06-10 | Kane | Illinois | 17089 | 6956 | 221 |
222139 | 222139 | 2020-06-09 | Kane | Illinois | 17089 | 6956 | 221 |
219044 | 219044 | 2020-06-08 | Kane | Illinois | 17089 | 6906 | 215 |
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);