johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,828 rows where confirmed = 25 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: last_update (date)
These facets timed out: province_or_state, country_or_region
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3598738 | 3598738 | 2022-11-14 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-11-15 04:21:16 | Unassigned, Michigan, US | |
313596 | 313596 | 2022-11-13 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-11-14 04:21:09 | Unassigned, Michigan, US | |
64757 | 64757 | 2022-11-12 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-11-13 04:21:14 | Unassigned, Michigan, US | |
2928919 | 2928919 | 2022-11-11 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-11-12 04:20:41 | Unassigned, Michigan, US | |
2507755 | 2507755 | 2022-11-10 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-11-11 04:21:22 | Unassigned, Michigan, US | |
2432630 | 2432630 | 2022-11-09 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-11-10 04:21:16 | Unassigned, Michigan, US | |
3286595 | 3286595 | 2022-10-31 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-11-01 04:22:36 | Unassigned, Michigan, US | |
321628 | 321628 | 2022-10-30 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-10-31 04:21:36 | Unassigned, Michigan, US | |
913904 | 913904 | 2022-10-29 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-10-30 04:22:14 | Unassigned, Michigan, US | |
1368173 | 1368173 | 2022-10-28 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-10-29 04:21:13 | Unassigned, Michigan, US | |
3040028 | 3040028 | 2022-10-27 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-10-28 04:22:31 | Unassigned, Michigan, US | |
540448 | 540448 | 2022-10-26 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-10-27 04:22:01 | Unassigned, Michigan, US | |
1831849 | 1831849 | 2022-10-25 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-10-26 04:22:19 | Unassigned, Michigan, US | |
3572292 | 3572292 | 2022-09-19 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-09-20 04:22:48 | Unassigned, Michigan, US | |
421031 | 421031 | 2022-09-18 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-09-19 04:21:49 | Unassigned, Michigan, US | |
3375055 | 3375055 | 2022-09-17 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-09-18 04:22:50 | Unassigned, Michigan, US | |
2357163 | 2357163 | 2022-09-16 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-09-17 04:20:19 | Unassigned, Michigan, US | |
3988320 | 3988320 | 2022-09-15 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-09-16 04:21:19 | Unassigned, Michigan, US | |
1890837 | 1890837 | 2022-09-14 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-09-15 04:21:02 | Unassigned, Michigan, US | |
373892 | 373892 | 2022-09-13 | US | Michigan | Unassigned | 90026 | 25 | 0 | 0 | 47.63197653 | 0.0 | 2022-09-14 04:20:44 | Unassigned, Michigan, US | |
633592 | 633592 | 2022-07-12 | New Zealand | Niue | 25 | 0 | 0 | 0 | -19.0544 | -169.8672 | 2022-07-13 04:20:58 | Niue, New Zealand | ||
3079095 | 3079095 | 2022-07-04 | US | Illinois | Out of IL | 80017 | 25 | 0 | 0 | 42.36542373 | 0.0 | 2022-07-05 04:20:45 | Out of IL, Illinois, US | |
1768377 | 1768377 | 2022-07-03 | US | Illinois | Out of IL | 80017 | 25 | 0 | 0 | 42.36542373 | 0.0 | 2022-07-04 04:20:54 | Out of IL, Illinois, US | |
3366363 | 3366363 | 2022-07-02 | US | Illinois | Out of IL | 80017 | 25 | 0 | 0 | 42.36542373 | 0.0 | 2022-07-03 04:20:59 | Out of IL, Illinois, US | |
594692 | 594692 | 2022-07-01 | US | Illinois | Out of IL | 80017 | 25 | 0 | 0 | 42.36542373 | 0.0 | 2022-07-02 04:21:16 | Out of IL, Illinois, US | |
2189181 | 2189181 | 2022-06-22 | US | Maine | Unassigned | 90023 | 25 | 0 | 0 | 46.65926321 | 0.0 | 2022-06-23 04:20:55 | Unassigned, Maine, US | |
948417 | 948417 | 2022-06-14 | US | Maine | Unassigned | 90023 | 25 | 0 | 0 | 46.65926321 | 0.0 | 2022-06-15 04:20:54 | Unassigned, Maine, US | |
1992795 | 1992795 | 2022-03-01 | New Zealand | Cook Islands | 25 | 0 | 0 | -21.2367 | -159.7777 | 2022-03-02 04:21:07 | Cook Islands, New Zealand | |||
1472399 | 1472399 | 2022-01-17 | Solomon Islands | 25 | 0 | 0 | -9.6457 | 160.1562 | 2022-01-18 04:21:04 | Solomon Islands | ||||
555073 | 555073 | 2022-01-16 | Solomon Islands | 25 | 0 | 0 | -9.6457 | 160.1562 | 2022-01-17 04:21:08 | Solomon Islands | ||||
3840794 | 3840794 | 2022-01-15 | Solomon Islands | 25 | 0 | 0 | -9.6457 | 160.1562 | 2022-01-16 04:21:12 | Solomon Islands | ||||
99609 | 99609 | 2022-01-14 | Solomon Islands | 25 | 0 | 0 | -9.6457 | 160.1562 | 2022-01-15 04:21:07 | Solomon Islands | ||||
3687764 | 3687764 | 2022-01-13 | Solomon Islands | 25 | 0 | 0 | -9.6457 | 160.1562 | 2022-01-14 04:21:54 | Solomon Islands | ||||
3613348 | 3613348 | 2022-01-12 | Solomon Islands | 25 | 0 | 0 | -9.6457 | 160.1562 | 2022-01-13 08:00:09 | Solomon Islands | ||||
1113873 | 1113873 | 2022-01-11 | Solomon Islands | 25 | 0 | 0 | -9.6457 | 160.1562 | 2022-01-12 04:21:44 | Solomon Islands | ||||
552792 | 552792 | 2021-12-08 | US | Montana | Petroleum | 30069 | 25 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-09 04:22:49 | Petroleum, Montana, US | |
406312 | 406312 | 2021-12-07 | US | Montana | Petroleum | 30069 | 25 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-08 04:22:46 | Petroleum, Montana, US | |
1032394 | 1032394 | 2021-12-06 | US | Montana | Petroleum | 30069 | 25 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-07 04:22:34 | Petroleum, Montana, US | |
1742582 | 1742582 | 2021-12-05 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-12-06 04:22:34 | Arthur, Nebraska, US | |
1742557 | 1742557 | 2021-12-05 | US | Montana | Petroleum | 30069 | 25 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-06 04:22:34 | Petroleum, Montana, US | |
140014 | 140014 | 2021-12-04 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-12-05 04:22:25 | Arthur, Nebraska, US | |
139989 | 139989 | 2021-12-04 | US | Montana | Petroleum | 30069 | 25 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-05 04:22:25 | Petroleum, Montana, US | |
2197667 | 2197667 | 2021-12-03 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-12-04 04:22:18 | Arthur, Nebraska, US | |
2197642 | 2197642 | 2021-12-03 | US | Montana | Petroleum | 30069 | 25 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-04 04:22:18 | Petroleum, Montana, US | |
2373 | 2373 | 2021-12-02 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-12-03 04:23:05 | Arthur, Nebraska, US | |
2348 | 2348 | 2021-12-02 | US | Montana | Petroleum | 30069 | 25 | 1 | 0 | 47.118246299999996 | -108.2508876 | 2021-12-03 04:23:05 | Petroleum, Montana, US | |
1146972 | 1146972 | 2021-12-01 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-12-02 04:22:37 | Arthur, Nebraska, US | |
3403484 | 3403484 | 2021-11-30 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-12-01 04:22:29 | Arthur, Nebraska, US | |
152027 | 152027 | 2021-11-29 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-30 04:22:53 | Arthur, Nebraska, US | |
151550 | 151550 | 2021-11-29 | US | Maine | Unassigned | 90023 | 25 | 0 | 0 | 46.65926321 | 0.0 | 2021-11-30 04:22:53 | Unassigned, Maine, US | |
1233673 | 1233673 | 2021-11-28 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-29 04:22:30 | Arthur, Nebraska, US | |
1360380 | 1360380 | 2021-11-27 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-28 04:22:43 | Arthur, Nebraska, US | |
760371 | 760371 | 2021-11-26 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-27 04:22:45 | Arthur, Nebraska, US | |
1804788 | 1804788 | 2021-11-25 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-26 04:22:33 | Arthur, Nebraska, US | |
906222 | 906222 | 2021-11-24 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-25 04:22:33 | Arthur, Nebraska, US | |
3072072 | 3072072 | 2021-11-23 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-24 04:22:14 | Arthur, Nebraska, US | |
3751170 | 3751170 | 2021-11-22 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-23 04:22:39 | Arthur, Nebraska, US | |
1016377 | 1016377 | 2021-11-21 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-22 04:22:20 | Arthur, Nebraska, US | |
724541 | 724541 | 2021-11-20 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-21 04:22:13 | Arthur, Nebraska, US | |
164071 | 164071 | 2021-11-19 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-20 04:22:17 | Arthur, Nebraska, US | |
3290958 | 3290958 | 2021-11-18 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-19 04:21:40 | Arthur, Nebraska, US | |
449414 | 449414 | 2021-11-17 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-18 04:21:33 | Arthur, Nebraska, US | |
3344664 | 3344664 | 2021-11-16 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-17 04:21:48 | Arthur, Nebraska, US | |
2289500 | 2289500 | 2021-11-15 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-16 04:21:10 | Arthur, Nebraska, US | |
1324274 | 1324274 | 2021-11-14 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-15 04:21:36 | Arthur, Nebraska, US | |
688400 | 688400 | 2021-11-13 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-14 04:21:31 | Arthur, Nebraska, US | |
716509 | 716509 | 2021-11-12 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-13 04:21:38 | Arthur, Nebraska, US | |
30459 | 30459 | 2021-11-11 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-12 04:22:01 | Arthur, Nebraska, US | |
2846898 | 2846898 | 2021-11-10 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-11 04:21:45 | Arthur, Nebraska, US | |
89168 | 89168 | 2021-11-09 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-10 04:21:38 | Arthur, Nebraska, US | |
3641596 | 3641596 | 2021-11-08 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-09 04:21:36 | Arthur, Nebraska, US | |
2002704 | 2002704 | 2021-11-07 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-08 04:21:43 | Arthur, Nebraska, US | |
497695 | 497695 | 2021-11-06 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-07 04:21:53 | Arthur, Nebraska, US | |
3123550 | 3123550 | 2021-11-05 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-06 04:21:51 | Arthur, Nebraska, US | |
700448 | 700448 | 2021-11-04 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-05 04:21:54 | Arthur, Nebraska, US | |
278226 | 278226 | 2021-11-03 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-04 04:22:20 | Arthur, Nebraska, US | |
45751 | 45751 | 2021-11-02 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-03 06:22:09 | Arthur, Nebraska, US | |
3513447 | 3513447 | 2021-11-01 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-02 04:22:03 | Arthur, Nebraska, US | |
3511208 | 3511208 | 2021-11-01 | China | Qinghai | 25 | 0 | 0 | 35.7452 | 95.9956 | 2021-11-02 04:22:03 | Qinghai, China | |||
290038 | 290038 | 2021-10-31 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-11-01 04:22:01 | Arthur, Nebraska, US | |
2723044 | 2723044 | 2021-10-30 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-10-31 04:22:08 | Arthur, Nebraska, US | |
569146 | 569146 | 2021-10-29 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-10-30 04:22:03 | Arthur, Nebraska, US | |
7490 | 7490 | 2021-10-28 | US | Texas | King | 48269 | 25 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-10-29 04:22:03 | King, Texas, US | |
6388 | 6388 | 2021-10-28 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-10-29 04:22:03 | Arthur, Nebraska, US | |
537880 | 537880 | 2021-10-27 | US | Texas | King | 48269 | 25 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-10-28 04:22:08 | King, Texas, US | |
536778 | 536778 | 2021-10-27 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-10-28 04:22:08 | Arthur, Nebraska, US | |
3495317 | 3495317 | 2021-10-26 | US | Texas | King | 48269 | 25 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-10-27 04:22:32 | King, Texas, US | |
3494215 | 3494215 | 2021-10-26 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-10-27 04:22:32 | Arthur, Nebraska, US | |
3797039 | 3797039 | 2021-10-25 | US | Texas | King | 48269 | 25 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-10-26 04:22:09 | King, Texas, US | |
3795937 | 3795937 | 2021-10-25 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-10-26 04:22:09 | Arthur, Nebraska, US | |
685485 | 685485 | 2021-10-24 | US | Texas | King | 48269 | 25 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-10-25 04:22:31 | King, Texas, US | |
684383 | 684383 | 2021-10-24 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-10-25 04:22:31 | Arthur, Nebraska, US | |
773493 | 773493 | 2021-10-23 | US | Texas | King | 48269 | 25 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-10-24 04:21:22 | King, Texas, US | |
772391 | 772391 | 2021-10-23 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-10-24 04:21:22 | Arthur, Nebraska, US | |
657140 | 657140 | 2021-10-22 | US | Texas | King | 48269 | 25 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-10-23 04:21:32 | King, Texas, US | |
656038 | 656038 | 2021-10-22 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-10-23 04:21:32 | Arthur, Nebraska, US | |
2126887 | 2126887 | 2021-10-21 | US | Texas | King | 48269 | 25 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-10-22 04:21:14 | King, Texas, US | |
2125785 | 2125785 | 2021-10-21 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-10-22 04:21:14 | Arthur, Nebraska, US | |
446499 | 446499 | 2021-10-20 | US | Texas | King | 48269 | 25 | 0 | 0 | 33.61643847 | -100.2558057 | 2021-10-21 04:21:18 | King, Texas, US | |
445397 | 445397 | 2021-10-20 | US | Nebraska | Arthur | 31005 | 25 | 1 | 0 | 41.56896142 | -101.6959559 | 2021-10-21 04:21:18 | Arthur, Nebraska, 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]);