johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
1,013 rows where longitude = "-88.22350769" and province_or_state = "Illinois" sorted by day descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2753895 | 2753895 | 2022-12-29 | US | Illinois | Ford | 17053 | 5363 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-30 04:21:04 | Ford, Illinois, US | |
1074901 | 1074901 | 2022-12-28 | US | Illinois | Ford | 17053 | 5359 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-29 04:21:01 | Ford, Illinois, US | |
328898 | 328898 | 2022-12-27 | US | Illinois | Ford | 17053 | 5359 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-28 04:21:04 | Ford, Illinois, US | |
218971 | 218971 | 2022-12-26 | US | Illinois | Ford | 17053 | 5355 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-27 04:21:07 | Ford, Illinois, US | |
3223428 | 3223428 | 2022-12-25 | US | Illinois | Ford | 17053 | 5355 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-26 04:21:06 | Ford, Illinois, US | |
1019342 | 1019342 | 2022-12-24 | US | Illinois | Ford | 17053 | 5355 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-25 04:21:04 | Ford, Illinois, US | |
691365 | 691365 | 2022-12-23 | US | Illinois | Ford | 17053 | 5355 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-24 04:21:02 | Ford, Illinois, US | |
2180575 | 2180575 | 2022-12-22 | US | Illinois | Ford | 17053 | 5352 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-23 04:21:04 | Ford, Illinois, US | |
452379 | 452379 | 2022-12-21 | US | Illinois | Ford | 17053 | 5347 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-22 04:20:56 | Ford, Illinois, US | |
2952378 | 2952378 | 2022-12-20 | US | Illinois | Ford | 17053 | 5342 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-21 04:21:03 | Ford, Illinois, US | |
3174780 | 3174780 | 2022-12-19 | US | Illinois | Ford | 17053 | 5337 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-20 04:21:04 | Ford, Illinois, US | |
1629297 | 1629297 | 2022-12-18 | US | Illinois | Ford | 17053 | 5321 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-19 04:21:03 | Ford, Illinois, US | |
504676 | 504676 | 2022-12-17 | US | Illinois | Ford | 17053 | 5321 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-18 04:21:03 | Ford, Illinois, US | |
3325248 | 3325248 | 2022-12-16 | US | Illinois | Ford | 17053 | 5321 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-17 04:21:04 | Ford, Illinois, US | |
543760 | 543760 | 2022-12-15 | US | Illinois | Ford | 17053 | 5320 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-16 04:21:01 | Ford, Illinois, US | |
349288 | 349288 | 2022-12-14 | US | Illinois | Ford | 17053 | 5319 | 70 | 0 | 40.59706922 | -88.22350769 | 2022-12-15 04:20:58 | Ford, Illinois, US | |
308876 | 308876 | 2022-12-13 | US | Illinois | Ford | 17053 | 5312 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-14 04:21:04 | Ford, Illinois, US | |
1149937 | 1149937 | 2022-12-12 | US | Illinois | Ford | 17053 | 5300 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-13 04:21:01 | Ford, Illinois, US | |
869791 | 869791 | 2022-12-11 | US | Illinois | Ford | 17053 | 5296 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-12 04:21:01 | Ford, Illinois, US | |
258321 | 258321 | 2022-12-10 | US | Illinois | Ford | 17053 | 5296 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-11 04:20:50 | Ford, Illinois, US | |
3937035 | 3937035 | 2022-12-09 | US | Illinois | Ford | 17053 | 5296 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-10 04:21:02 | Ford, Illinois, US | |
3378367 | 3378367 | 2022-12-08 | US | Illinois | Ford | 17053 | 5290 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-09 04:21:05 | Ford, Illinois, US | |
1985638 | 1985638 | 2022-12-07 | US | Illinois | Ford | 17053 | 5290 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-08 04:21:07 | Ford, Illinois, US | |
3715161 | 3715161 | 2022-12-06 | US | Illinois | Ford | 17053 | 5280 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-07 04:20:58 | Ford, Illinois, US | |
2415866 | 2415866 | 2022-12-05 | US | Illinois | Ford | 17053 | 5280 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-06 04:21:03 | Ford, Illinois, US | |
719474 | 719474 | 2022-12-04 | US | Illinois | Ford | 17053 | 5271 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-05 04:20:58 | Ford, Illinois, US | |
2817763 | 2817763 | 2022-12-03 | US | Illinois | Ford | 17053 | 5271 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-04 04:20:56 | Ford, Illinois, US | |
834619 | 834619 | 2022-12-02 | US | Illinois | Ford | 17053 | 5271 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-03 04:21:02 | Ford, Illinois, US | |
2137149 | 2137149 | 2022-12-01 | US | Illinois | Ford | 17053 | 5266 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-02 04:21:07 | Ford, Illinois, US | |
1965565 | 1965565 | 2022-11-30 | US | Illinois | Ford | 17053 | 5265 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-12-01 04:21:03 | Ford, Illinois, US | |
2557579 | 2557579 | 2022-11-29 | US | Illinois | Ford | 17053 | 5258 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-30 04:21:07 | Ford, Illinois, US | |
1240653 | 1240653 | 2022-11-28 | US | Illinois | Ford | 17053 | 5253 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-29 04:21:05 | Ford, Illinois, US | |
3552641 | 3552641 | 2022-11-27 | US | Illinois | Ford | 17053 | 5246 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-28 04:21:02 | Ford, Illinois, US | |
2101121 | 2101121 | 2022-11-26 | US | Illinois | Ford | 17053 | 5246 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-27 04:21:05 | Ford, Illinois, US | |
488612 | 488612 | 2022-11-25 | US | Illinois | Ford | 17053 | 5246 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-26 04:21:11 | Ford, Illinois, US | |
3524441 | 3524441 | 2022-11-24 | US | Illinois | Ford | 17053 | 5246 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-25 04:21:06 | Ford, Illinois, US | |
3313224 | 3313224 | 2022-11-23 | US | Illinois | Ford | 17053 | 5246 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-24 04:21:09 | Ford, Illinois, US | |
1621265 | 1621265 | 2022-11-22 | US | Illinois | Ford | 17053 | 5244 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-23 04:21:06 | Ford, Illinois, US | |
3461153 | 3461153 | 2022-11-21 | US | Illinois | Ford | 17053 | 5240 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-22 04:20:47 | Ford, Illinois, US | |
1641338 | 1641338 | 2022-11-20 | US | Illinois | Ford | 17053 | 5238 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-21 04:21:05 | Ford, Illinois, US | |
2064895 | 2064895 | 2022-11-19 | US | Illinois | Ford | 17053 | 5238 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-20 04:21:08 | Ford, Illinois, US | |
1756289 | 1756289 | 2022-11-18 | US | Illinois | Ford | 17053 | 5238 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-19 04:21:14 | Ford, Illinois, US | |
3027282 | 3027282 | 2022-11-17 | US | Illinois | Ford | 17053 | 5236 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-18 04:21:15 | Ford, Illinois, US | |
2486993 | 2486993 | 2022-11-16 | US | Illinois | Ford | 17053 | 5234 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-17 04:21:11 | Ford, Illinois, US | |
293004 | 293004 | 2022-11-15 | US | Illinois | Ford | 17053 | 5233 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-16 04:21:09 | Ford, Illinois, US | |
3598034 | 3598034 | 2022-11-14 | US | Illinois | Ford | 17053 | 5232 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-15 04:21:16 | Ford, Illinois, US | |
312892 | 312892 | 2022-11-13 | US | Illinois | Ford | 17053 | 5228 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-14 04:21:09 | Ford, Illinois, US | |
64053 | 64053 | 2022-11-12 | US | Illinois | Ford | 17053 | 5228 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-13 04:21:14 | Ford, Illinois, US | |
2928215 | 2928215 | 2022-11-11 | US | Illinois | Ford | 17053 | 5228 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-12 04:20:41 | Ford, Illinois, US | |
2507051 | 2507051 | 2022-11-10 | US | Illinois | Ford | 17053 | 5228 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-11 04:21:22 | Ford, Illinois, US | |
2431926 | 2431926 | 2022-11-09 | US | Illinois | Ford | 17053 | 5227 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-10 04:21:16 | Ford, Illinois, US | |
480582 | 480582 | 2022-11-08 | US | Illinois | Ford | 17053 | 5224 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-09 04:21:22 | Ford, Illinois, US | |
2439732 | 2439732 | 2022-11-07 | US | Illinois | Ford | 17053 | 5224 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-08 04:21:21 | Ford, Illinois, US | |
1050830 | 1050830 | 2022-11-06 | US | Illinois | Ford | 17053 | 5211 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-07 04:21:26 | Ford, Illinois, US | |
618854 | 618854 | 2022-11-05 | US | Illinois | Ford | 17053 | 5211 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-06 04:21:24 | Ford, Illinois, US | |
1023358 | 1023358 | 2022-11-04 | US | Illinois | Ford | 17053 | 5211 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-05 04:21:52 | Ford, Illinois, US | |
432349 | 432349 | 2022-11-03 | US | Illinois | Ford | 17053 | 5210 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-04 04:22:11 | Ford, Illinois, US | |
850591 | 850591 | 2022-11-02 | US | Illinois | Ford | 17053 | 5210 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-03 04:22:05 | Ford, Illinois, US | |
711442 | 711442 | 2022-11-01 | US | Illinois | Ford | 17053 | 5208 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-02 04:22:09 | Ford, Illinois, US | |
3285891 | 3285891 | 2022-10-31 | US | Illinois | Ford | 17053 | 5203 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-11-01 04:22:36 | Ford, Illinois, US | |
320924 | 320924 | 2022-10-30 | US | Illinois | Ford | 17053 | 5200 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-31 04:21:36 | Ford, Illinois, US | |
913200 | 913200 | 2022-10-29 | US | Illinois | Ford | 17053 | 5200 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-30 04:22:14 | Ford, Illinois, US | |
1367469 | 1367469 | 2022-10-28 | US | Illinois | Ford | 17053 | 5200 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-29 04:21:13 | Ford, Illinois, US | |
3039324 | 3039324 | 2022-10-27 | US | Illinois | Ford | 17053 | 5194 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-28 04:22:31 | Ford, Illinois, US | |
539744 | 539744 | 2022-10-26 | US | Illinois | Ford | 17053 | 5192 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-27 04:22:01 | Ford, Illinois, US | |
1831145 | 1831145 | 2022-10-25 | US | Illinois | Ford | 17053 | 5188 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-26 04:22:19 | Ford, Illinois, US | |
795406 | 795406 | 2022-10-24 | US | Illinois | Ford | 17053 | 5176 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-25 04:21:53 | Ford, Illinois, US | |
3277861 | 3277861 | 2022-10-23 | US | Illinois | Ford | 17053 | 5169 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-24 04:22:29 | Ford, Illinois, US | |
2268899 | 2268899 | 2022-10-22 | US | Illinois | Ford | 17053 | 5169 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-23 04:22:46 | Ford, Illinois, US | |
1593199 | 1593199 | 2022-10-21 | US | Illinois | Ford | 17053 | 5169 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-22 04:22:53 | Ford, Illinois, US | |
2272915 | 2272915 | 2022-10-20 | US | Illinois | Ford | 17053 | 5161 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-21 04:22:23 | Ford, Illinois, US | |
199250 | 199250 | 2022-10-19 | US | Illinois | Ford | 17053 | 5153 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-20 04:22:59 | Ford, Illinois, US | |
2757911 | 2757911 | 2022-10-18 | US | Illinois | Ford | 17053 | 5151 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-19 04:22:26 | Ford, Illinois, US | |
2025745 | 2025745 | 2022-10-17 | US | Illinois | Ford | 17053 | 5151 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-18 04:22:42 | Ford, Illinois, US | |
2160523 | 2160523 | 2022-10-16 | US | Illinois | Ford | 17053 | 5141 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-17 04:20:31 | Ford, Illinois, US | |
516720 | 516720 | 2022-10-15 | US | Illinois | Ford | 17053 | 5141 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-16 04:22:39 | Ford, Illinois, US | |
2033777 | 2033777 | 2022-10-14 | US | Illinois | Ford | 17053 | 5141 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-15 04:22:00 | Ford, Illinois, US | |
3754465 | 3754465 | 2022-10-13 | US | Illinois | Ford | 17053 | 5136 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-14 04:22:28 | Ford, Illinois, US | |
3215290 | 3215290 | 2022-10-12 | US | Illinois | Ford | 17053 | 5136 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-13 04:22:39 | Ford, Illinois, US | |
3251139 | 3251139 | 2022-10-11 | US | Illinois | Ford | 17053 | 5132 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-12 04:22:51 | Ford, Illinois, US | |
2968398 | 2968398 | 2022-10-10 | US | Illinois | Ford | 17053 | 5116 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-11 04:23:05 | Ford, Illinois, US | |
3098434 | 3098434 | 2022-10-09 | US | Illinois | Ford | 17053 | 5116 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-10 04:22:32 | Ford, Illinois, US | |
4003659 | 4003659 | 2022-10-08 | US | Illinois | Ford | 17053 | 5116 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-09 04:21:16 | Ford, Illinois, US | |
397256 | 397256 | 2022-10-07 | US | Illinois | Ford | 17053 | 5116 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-08 04:22:56 | Ford, Illinois, US | |
2530373 | 2530373 | 2022-10-06 | US | Illinois | Ford | 17053 | 5115 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-07 04:23:08 | Ford, Illinois, US | |
1811767 | 1811767 | 2022-10-05 | US | Illinois | Ford | 17053 | 5112 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-06 04:21:22 | Ford, Illinois, US | |
131741 | 131741 | 2022-10-04 | US | Illinois | Ford | 17053 | 5109 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-05 04:23:06 | Ford, Illinois, US | |
2686688 | 2686688 | 2022-10-03 | US | Illinois | Ford | 17053 | 5090 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-04 04:22:55 | Ford, Illinois, US | |
2260755 | 2260755 | 2022-10-02 | US | Illinois | Ford | 17053 | 5084 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-03 04:23:11 | Ford, Illinois, US | |
2996281 | 2996281 | 2022-10-01 | US | Illinois | Ford | 17053 | 5084 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-02 04:21:23 | Ford, Illinois, US | |
854607 | 854607 | 2022-09-30 | US | Illinois | Ford | 17053 | 5084 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-10-01 04:23:01 | Ford, Illinois, US | |
2376533 | 2376533 | 2022-09-29 | US | Illinois | Ford | 17053 | 5080 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-09-30 04:23:09 | Ford, Illinois, US | |
1561084 | 1561084 | 2022-09-28 | US | Illinois | Ford | 17053 | 5079 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-09-29 04:22:34 | Ford, Illinois, US | |
3995627 | 3995627 | 2022-09-27 | US | Illinois | Ford | 17053 | 5074 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-09-28 04:23:01 | Ford, Illinois, US | |
2769955 | 2769955 | 2022-09-26 | US | Illinois | Ford | 17053 | 5071 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-09-27 04:23:01 | Ford, Illinois, US | |
1977608 | 1977608 | 2022-09-25 | US | Illinois | Ford | 17053 | 5068 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-09-26 04:20:52 | Ford, Illinois, US | |
2650775 | 2650775 | 2022-09-24 | US | Illinois | Ford | 17053 | 5068 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-09-25 04:23:31 | Ford, Illinois, US | |
385215 | 385215 | 2022-09-23 | US | Illinois | Ford | 17053 | 5068 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-09-24 04:21:40 | Ford, Illinois, US | |
1625281 | 1625281 | 2022-09-22 | US | Illinois | Ford | 17053 | 5064 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-09-23 04:23:13 | Ford, Illinois, US | |
1371485 | 1371485 | 2022-09-21 | US | Illinois | Ford | 17053 | 5061 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-09-22 04:22:56 | Ford, 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]);