johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
104,685 rows where province_or_state = "Illinois" sorted by fips
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips ▼ | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
225692 | 225692 | 2020-04-30 | US | Illinois | Adams | 17001 | 40 | 0 | 0 | 40 | 39.98815591 | -91.18786813 | 2020-05-01 02:32:28 | Adams, Illinois, US |
230189 | 230189 | 2022-05-31 | US | Illinois | Adams | 17001 | 22709 | 210 | 0 | 39.98815591 | -91.18786813 | 2022-06-01 04:20:55 | Adams, Illinois, US | |
234204 | 234204 | 2022-02-11 | US | Illinois | Adams | 17001 | 21755 | 195 | 0 | 39.98815591 | -91.18786813 | 2022-02-12 04:21:06 | Adams, Illinois, US | |
238191 | 238191 | 2021-01-18 | US | Illinois | Adams | 17001 | 7337 | 94 | 0 | 7243 | 39.98815591 | -91.18786813 | 2021-01-19 05:22:15 | Adams, Illinois, US |
242208 | 242208 | 2021-04-02 | US | Illinois | Adams | 17001 | 8087 | 115 | 0 | 39.98815591 | -91.18786813 | 2021-04-03 04:20:44 | Adams, Illinois, US | |
246226 | 246226 | 2021-08-17 | US | Illinois | Adams | 17001 | 10822 | 132 | 0 | 39.98815591 | -91.18786813 | 2021-08-18 04:21:35 | Adams, Illinois, US | |
250240 | 250240 | 2021-09-04 | US | Illinois | Adams | 17001 | 11914 | 141 | 0 | 39.98815591 | -91.18786813 | 2021-09-05 04:21:33 | Adams, Illinois, US | |
254276 | 254276 | 2022-09-08 | US | Illinois | Adams | 17001 | 25685 | 216 | 0 | 39.98815591 | -91.18786813 | 2022-09-09 04:21:11 | Adams, Illinois, US | |
258295 | 258295 | 2022-12-10 | US | Illinois | Adams | 17001 | 26819 | 225 | 0 | 39.98815591 | -91.18786813 | 2022-12-11 04:20:50 | Adams, Illinois, US | |
262494 | 262494 | 2022-03-15 | US | Illinois | Adams | 17001 | 22251 | 203 | 0 | 39.98815591 | -91.18786813 | 2022-03-16 04:20:50 | Adams, Illinois, US | |
265229 | 265229 | 2020-05-21 | US | Illinois | Adams | 17001 | 45 | 1 | 0 | 44 | 39.98815591 | -91.18786813 | 2020-05-22 02:36:51 | Adams, Illinois, US |
268665 | 268665 | 2020-04-28 | US | Illinois | Adams | 17001 | 40 | 0 | 0 | 40 | 39.98815591 | -91.18786813 | 2020-04-29 02:32:29 | Adams, Illinois, US |
273104 | 273104 | 2020-11-10 | US | Illinois | Adams | 17001 | 3023 | 30 | 0 | 2993 | 39.98815591 | -91.18786813 | 2020-11-11 05:25:30 | Adams, Illinois, US |
277144 | 277144 | 2021-11-03 | US | Illinois | Adams | 17001 | 13419 | 156 | 0 | 39.98815591 | -91.18786813 | 2021-11-04 04:22:20 | Adams, Illinois, US | |
281134 | 281134 | 2021-02-24 | US | Illinois | Adams | 17001 | 7980 | 113 | 0 | 7867 | 39.98815591 | -91.18786813 | 2021-02-25 05:24:57 | Adams, Illinois, US |
283894 | 283894 | 2020-06-15 | US | Illinois | Adams | 17001 | 46 | 1 | 0 | 45 | 39.98815591 | -91.18786813 | 2020-06-16 04:33:09 | Adams, Illinois, US |
288956 | 288956 | 2021-10-31 | US | Illinois | Adams | 17001 | 13319 | 155 | 0 | 39.98815591 | -91.18786813 | 2021-11-01 04:22:01 | Adams, Illinois, US | |
292978 | 292978 | 2022-11-15 | US | Illinois | Adams | 17001 | 26273 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-16 04:21:09 | Adams, Illinois, US | |
296969 | 296969 | 2021-07-15 | US | Illinois | Adams | 17001 | 9137 | 127 | 0 | 39.98815591 | -91.18786813 | 2021-07-16 04:21:22 | Adams, Illinois, US | |
299723 | 299723 | 2020-07-01 | US | Illinois | Adams | 17001 | 93 | 1 | 0 | 92 | 39.98815591 | -91.18786813 | 2020-07-02 04:33:46 | Adams, Illinois, US |
304830 | 304830 | 2022-04-16 | US | Illinois | Adams | 17001 | 22334 | 209 | 0 | 39.98815591 | -91.18786813 | 2022-04-17 04:20:59 | Adams, Illinois, US | |
308850 | 308850 | 2022-12-13 | US | Illinois | Adams | 17001 | 26914 | 225 | 0 | 39.98815591 | -91.18786813 | 2022-12-14 04:21:04 | Adams, Illinois, US | |
312866 | 312866 | 2022-11-13 | US | Illinois | Adams | 17001 | 26199 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-14 04:21:09 | Adams, Illinois, US | |
316878 | 316878 | 2022-02-12 | US | Illinois | Adams | 17001 | 21755 | 195 | 0 | 39.98815591 | -91.18786813 | 2022-02-13 04:21:00 | Adams, Illinois, US | |
320898 | 320898 | 2022-10-30 | US | Illinois | Adams | 17001 | 26062 | 222 | 0 | 39.98815591 | -91.18786813 | 2022-10-31 04:21:36 | Adams, Illinois, US | |
323629 | 323629 | 2020-07-20 | US | Illinois | Adams | 17001 | 285 | 1 | 0 | 284 | 39.98815591 | -91.18786813 | 2020-07-21 04:38:46 | Adams, Illinois, US |
328872 | 328872 | 2022-12-27 | US | Illinois | Adams | 17001 | 27273 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-28 04:21:04 | Adams, Illinois, US | |
332863 | 332863 | 2021-08-04 | US | Illinois | Adams | 17001 | 10008 | 131 | 0 | 39.98815591 | -91.18786813 | 2021-08-05 04:21:51 | Adams, Illinois, US | |
336898 | 336898 | 2022-03-18 | US | Illinois | Adams | 17001 | 22261 | 207 | 0 | 39.98815591 | -91.18786813 | 2022-03-19 04:20:47 | Adams, Illinois, US | |
341226 | 341226 | 2021-02-03 | US | Illinois | Adams | 17001 | 7747 | 108 | 0 | 7639 | 39.98815591 | -91.18786813 | 2021-02-04 05:22:26 | Adams, Illinois, US |
345219 | 345219 | 2020-09-14 | US | Illinois | Adams | 17001 | 888 | 10 | 0 | 878 | 39.98815591 | -91.18786813 | 2020-09-15 03:22:50 | Adams, Illinois, US |
349262 | 349262 | 2022-12-14 | US | Illinois | Adams | 17001 | 26987 | 227 | 0 | 39.98815591 | -91.18786813 | 2022-12-15 04:20:58 | Adams, Illinois, US | |
353247 | 353247 | 2021-03-11 | US | Illinois | Adams | 17001 | 8047 | 115 | 0 | 39.98815591 | -91.18786813 | 2021-03-12 05:26:50 | Adams, Illinois, US | |
357288 | 357288 | 2022-03-11 | US | Illinois | Adams | 17001 | 22236 | 202 | 0 | 39.98815591 | -91.18786813 | 2022-03-12 04:20:50 | Adams, Illinois, US | |
361304 | 361304 | 2022-05-07 | US | Illinois | Adams | 17001 | 22469 | 209 | 0 | 39.98815591 | -91.18786813 | 2022-05-08 04:20:49 | Adams, Illinois, US | |
364039 | 364039 | 2020-07-16 | US | Illinois | Adams | 17001 | 223 | 1 | 0 | 222 | 39.98815591 | -91.18786813 | 2020-07-17 04:34:50 | Adams, Illinois, US |
367900 | 367900 | 2020-08-08 | US | Illinois | Adams | 17001 | 517 | 5 | 0 | 512 | 39.98815591 | -91.18786813 | 2020-08-09 04:34:54 | Adams, Illinois, US |
373162 | 373162 | 2022-09-13 | US | Illinois | Adams | 17001 | 25753 | 216 | 0 | 39.98815591 | -91.18786813 | 2022-09-14 04:20:44 | Adams, Illinois, US | |
377131 | 377131 | 2020-11-06 | US | Illinois | Adams | 17001 | 2640 | 28 | 0 | 2612 | 39.98815591 | -91.18786813 | 2020-11-07 05:24:52 | Adams, Illinois, US |
381146 | 381146 | 2021-04-30 | US | Illinois | Adams | 17001 | 8322 | 119 | 0 | 39.98815591 | -91.18786813 | 2021-05-01 04:20:47 | Adams, Illinois, US | |
385189 | 385189 | 2022-09-23 | US | Illinois | Adams | 17001 | 25844 | 216 | 0 | 39.98815591 | -91.18786813 | 2022-09-24 04:21:40 | Adams, Illinois, US | |
389176 | 389176 | 2021-04-04 | US | Illinois | Adams | 17001 | 8088 | 115 | 0 | 39.98815591 | -91.18786813 | 2021-04-05 04:20:35 | Adams, Illinois, US | |
393185 | 393185 | 2020-11-27 | US | Illinois | Adams | 17001 | 4651 | 45 | 0 | 4606 | 39.98815591 | -91.18786813 | 2020-11-28 05:25:50 | Adams, Illinois, US |
397230 | 397230 | 2022-10-07 | US | Illinois | Adams | 17001 | 25939 | 217 | 0 | 39.98815591 | -91.18786813 | 2022-10-08 04:22:56 | Adams, Illinois, US | |
401221 | 401221 | 2021-06-29 | US | Illinois | Adams | 17001 | 8787 | 127 | 0 | 39.98815591 | -91.18786813 | 2021-06-30 04:21:41 | Adams, Illinois, US | |
405255 | 405255 | 2021-12-07 | US | Illinois | Adams | 17001 | 14760 | 162 | 0 | 39.98815591 | -91.18786813 | 2021-12-08 04:22:46 | Adams, Illinois, US | |
409251 | 409251 | 2021-07-28 | US | Illinois | Adams | 17001 | 9635 | 128 | 0 | 39.98815591 | -91.18786813 | 2021-07-29 04:21:33 | Adams, Illinois, US | |
412005 | 412005 | 2020-07-05 | US | Illinois | Adams | 17001 | 122 | 1 | 0 | 121 | 39.98815591 | -91.18786813 | 2020-07-06 04:33:57 | Adams, Illinois, US |
415925 | 415925 | 2020-04-18 | US | Illinois | Adams | 17001 | 31 | 0 | 0 | 31 | 39.98815591 | -91.18786813 | 2020-04-18 22:32:47 | Adams, Illinois, US |
420301 | 420301 | 2022-09-18 | US | Illinois | Adams | 17001 | 25787 | 216 | 0 | 39.98815591 | -91.18786813 | 2022-09-19 04:21:49 | Adams, Illinois, US | |
424311 | 424311 | 2021-10-10 | US | Illinois | Adams | 17001 | 12983 | 151 | 0 | 39.98815591 | -91.18786813 | 2021-10-11 04:21:31 | Adams, Illinois, US | |
428280 | 428280 | 2020-09-07 | US | Illinois | Adams | 17001 | 819 | 9 | 0 | 810 | 39.98815591 | -91.18786813 | 2020-09-08 04:28:25 | Adams, Illinois, US |
432323 | 432323 | 2022-11-03 | US | Illinois | Adams | 17001 | 26117 | 222 | 0 | 39.98815591 | -91.18786813 | 2022-11-04 04:22:11 | Adams, Illinois, US | |
436307 | 436307 | 2021-01-21 | US | Illinois | Adams | 17001 | 7442 | 98 | 0 | 7344 | 39.98815591 | -91.18786813 | 2021-01-22 05:22:10 | Adams, Illinois, US |
439068 | 439068 | 2020-07-26 | US | Illinois | Adams | 17001 | 336 | 1 | 0 | 335 | 39.98815591 | -91.18786813 | 2020-07-27 04:35:02 | Adams, Illinois, US |
444315 | 444315 | 2021-10-20 | US | Illinois | Adams | 17001 | 13156 | 152 | 0 | 39.98815591 | -91.18786813 | 2021-10-21 04:21:18 | Adams, Illinois, US | |
448332 | 448332 | 2021-11-17 | US | Illinois | Adams | 17001 | 13871 | 158 | 0 | 39.98815591 | -91.18786813 | 2021-11-18 04:21:33 | Adams, Illinois, US | |
452353 | 452353 | 2022-12-21 | US | Illinois | Adams | 17001 | 27185 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-22 04:20:56 | Adams, Illinois, US | |
455084 | 455084 | 2020-08-07 | US | Illinois | Adams | 17001 | 506 | 5 | 0 | 501 | 39.98815591 | -91.18786813 | 2020-08-08 04:34:53 | Adams, Illinois, US |
460341 | 460341 | 2022-02-02 | US | Illinois | Adams | 17001 | 21360 | 190 | 0 | 39.98815591 | -91.18786813 | 2022-02-03 04:21:21 | Adams, Illinois, US | |
464358 | 464358 | 2022-05-02 | US | Illinois | Adams | 17001 | 22424 | 209 | 0 | 39.98815591 | -91.18786813 | 2022-05-03 04:21:00 | Adams, Illinois, US | |
468372 | 468372 | 2021-10-07 | US | Illinois | Adams | 17001 | 12968 | 151 | 0 | 39.98815591 | -91.18786813 | 2021-10-08 04:21:25 | Adams, Illinois, US | |
472363 | 472363 | 2021-02-19 | US | Illinois | Adams | 17001 | 7935 | 113 | 0 | 7822 | 39.98815591 | -91.18786813 | 2021-02-20 05:22:51 | Adams, Illinois, US |
476405 | 476405 | 2022-06-26 | US | Illinois | Adams | 17001 | 23314 | 210 | 0 | 39.98815591 | -91.18786813 | 2022-06-27 04:21:00 | Adams, Illinois, US | |
480556 | 480556 | 2022-11-08 | US | Illinois | Adams | 17001 | 26157 | 223 | 0 | 39.98815591 | -91.18786813 | 2022-11-09 04:21:22 | Adams, Illinois, US | |
484547 | 484547 | 2021-07-19 | US | Illinois | Adams | 17001 | 9229 | 127 | 0 | 39.98815591 | -91.18786813 | 2021-07-20 04:21:48 | Adams, Illinois, US | |
488586 | 488586 | 2022-11-25 | US | Illinois | Adams | 17001 | 26413 | 224 | 0 | 39.98815591 | -91.18786813 | 2022-11-26 04:21:11 | Adams, Illinois, US | |
492596 | 492596 | 2021-10-14 | US | Illinois | Adams | 17001 | 13055 | 152 | 0 | 39.98815591 | -91.18786813 | 2021-10-15 04:21:26 | Adams, Illinois, US | |
496613 | 496613 | 2021-11-06 | US | Illinois | Adams | 17001 | 13477 | 157 | 0 | 39.98815591 | -91.18786813 | 2021-11-07 04:21:53 | Adams, Illinois, US | |
500630 | 500630 | 2022-04-02 | US | Illinois | Adams | 17001 | 22284 | 209 | 0 | 39.98815591 | -91.18786813 | 2022-04-03 04:20:48 | Adams, Illinois, US | |
504650 | 504650 | 2022-12-17 | US | Illinois | Adams | 17001 | 27047 | 228 | 0 | 39.98815591 | -91.18786813 | 2022-12-18 04:21:03 | Adams, Illinois, US | |
508641 | 508641 | 2021-08-14 | US | Illinois | Adams | 17001 | 10637 | 132 | 0 | 39.98815591 | -91.18786813 | 2021-08-15 04:21:41 | Adams, Illinois, US | |
512655 | 512655 | 2021-08-19 | US | Illinois | Adams | 17001 | 10969 | 134 | 0 | 39.98815591 | -91.18786813 | 2021-08-20 04:21:33 | Adams, Illinois, US | |
516694 | 516694 | 2022-10-15 | US | Illinois | Adams | 17001 | 25978 | 220 | 0 | 39.98815591 | -91.18786813 | 2022-10-16 04:22:39 | Adams, Illinois, US | |
519425 | 519425 | 2020-04-21 | US | Illinois | Adams | 17001 | 29 | 0 | 0 | 29 | 39.98815591 | -91.18786813 | 2020-04-21 23:30:50 | Adams, Illinois, US |
523811 | 523811 | 2021-06-09 | US | Illinois | Adams | 17001 | 8637 | 126 | 0 | 39.98815591 | -91.18786813 | 2021-06-10 04:23:17 | Adams, Illinois, US | |
526568 | 526568 | 2020-07-04 | US | Illinois | Adams | 17001 | 113 | 1 | 0 | 112 | 39.98815591 | -91.18786813 | 2020-07-05 04:33:46 | Adams, Illinois, US |
531657 | 531657 | 2021-02-22 | US | Illinois | Adams | 17001 | 7954 | 113 | 0 | 7841 | 39.98815591 | -91.18786813 | 2021-02-23 05:23:41 | Adams, Illinois, US |
535696 | 535696 | 2021-10-27 | US | Illinois | Adams | 17001 | 13266 | 154 | 0 | 39.98815591 | -91.18786813 | 2021-10-28 04:22:08 | Adams, Illinois, US | |
539718 | 539718 | 2022-10-26 | US | Illinois | Adams | 17001 | 26046 | 222 | 0 | 39.98815591 | -91.18786813 | 2022-10-27 04:22:01 | Adams, Illinois, US | |
543734 | 543734 | 2022-12-15 | US | Illinois | Adams | 17001 | 27031 | 227 | 0 | 39.98815591 | -91.18786813 | 2022-12-16 04:21:01 | Adams, Illinois, US | |
547697 | 547697 | 2020-09-12 | US | Illinois | Adams | 17001 | 874 | 10 | 0 | 864 | 39.98815591 | -91.18786813 | 2020-09-13 04:30:52 | Adams, Illinois, US |
551735 | 551735 | 2021-12-08 | US | Illinois | Adams | 17001 | 14837 | 162 | 0 | 39.98815591 | -91.18786813 | 2021-12-09 04:22:49 | Adams, Illinois, US | |
555751 | 555751 | 2022-01-16 | US | Illinois | Adams | 17001 | 18752 | 183 | 0 | 39.98815591 | -91.18786813 | 2022-01-17 04:21:08 | Adams, Illinois, US | |
559769 | 559769 | 2022-06-16 | US | Illinois | Adams | 17001 | 23091 | 210 | 0 | 39.98815591 | -91.18786813 | 2022-06-17 04:20:56 | Adams, Illinois, US | |
563923 | 563923 | 2021-06-22 | US | Illinois | Adams | 17001 | 8718 | 127 | 0 | 39.98815591 | -91.18786813 | 2021-06-23 04:21:46 | Adams, Illinois, US | |
568064 | 568064 | 2021-10-29 | US | Illinois | Adams | 17001 | 13319 | 155 | 0 | 39.98815591 | -91.18786813 | 2021-10-30 04:22:03 | Adams, Illinois, US | |
570801 | 570801 | 2020-06-06 | US | Illinois | Adams | 17001 | 46 | 1 | 0 | 45 | 39.98815591 | -91.18786813 | 2020-06-07 03:53:30 | Adams, Illinois, US |
575794 | 575794 | 2022-02-25 | US | Illinois | Adams | 17001 | 22119 | 200 | 0 | 39.98815591 | -91.18786813 | 2022-02-26 04:21:12 | Adams, Illinois, US | |
579789 | 579789 | 2021-07-13 | US | Illinois | Adams | 17001 | 9059 | 127 | 0 | 39.98815591 | -91.18786813 | 2021-07-14 04:21:35 | Adams, Illinois, US | |
583774 | 583774 | 2020-08-13 | US | Illinois | Adams | 17001 | 581 | 7 | 0 | 574 | 39.98815591 | -91.18786813 | 2020-08-14 04:51:19 | Adams, Illinois, US |
586524 | 586524 | 2020-04-05 | US | Illinois | Adams | 17001 | 3 | 0 | 0 | 3 | 39.98815591 | -91.18786813 | 2020-04-05 23:06:45 | Adams, Illinois, US |
590585 | 590585 | 2021-08-08 | US | Illinois | Adams | 17001 | 10121 | 131 | 0 | 39.98815591 | -91.18786813 | 2021-08-09 04:21:24 | Adams, Illinois, US | |
594621 | 594621 | 2022-07-01 | US | Illinois | Adams | 17001 | 23595 | 210 | 0 | 39.98815591 | -91.18786813 | 2022-07-02 04:21:16 | Adams, Illinois, US | |
598634 | 598634 | 2021-10-19 | US | Illinois | Adams | 17001 | 13124 | 152 | 0 | 39.98815591 | -91.18786813 | 2021-10-20 04:21:00 | Adams, Illinois, US | |
602649 | 602649 | 2021-09-23 | US | Illinois | Adams | 17001 | 12718 | 148 | 0 | 39.98815591 | -91.18786813 | 2021-09-24 04:21:44 | Adams, Illinois, US | |
606642 | 606642 | 2021-04-09 | US | Illinois | Adams | 17001 | 8124 | 116 | 0 | 39.98815591 | -91.18786813 | 2021-04-10 04:20:59 | Adams, Illinois, US | |
610632 | 610632 | 2020-08-29 | US | Illinois | Adams | 17001 | 762 | 7 | 0 | 755 | 39.98815591 | -91.18786813 | 2020-08-30 04:28:22 | Adams, Illinois, US |
614639 | 614639 | 2021-02-08 | US | Illinois | Adams | 17001 | 7807 | 109 | 0 | 7698 | 39.98815591 | -91.18786813 | 2021-02-09 05:23:30 | Adams, Illinois, US |
618828 | 618828 | 2022-11-05 | US | Illinois | Adams | 17001 | 26134 | 223 | 0 | 39.98815591 | -91.18786813 | 2022-11-06 04:21:24 | Adams, Illinois, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE [johns_hopkins_csse_daily_reports] ( [day] TEXT, [country_or_region] TEXT, [province_or_state] TEXT, [admin2] TEXT, [fips] TEXT, [confirmed] INTEGER, [deaths] INTEGER, [recovered] INTEGER, [active] TEXT, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT ); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_day] ON [johns_hopkins_csse_daily_reports] ([day]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_province_or_state] ON [johns_hopkins_csse_daily_reports] ([province_or_state]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_country_or_region] ON [johns_hopkins_csse_daily_reports] ([country_or_region]); CREATE INDEX [idx_johns_hopkins_csse_daily_reports_combined_key] ON [johns_hopkins_csse_daily_reports] ([combined_key]);