johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
463 rows where confirmed = 1461 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755054 | 2755054 | 2022-12-29 | US | Nevada | Mineral | 32021 | 1461 | 19 | 0 | 38.53841696 | -118.4344506 | 2022-12-30 04:21:04 | Mineral, Nevada, US | |
1076060 | 1076060 | 2022-12-28 | US | Nevada | Mineral | 32021 | 1461 | 19 | 0 | 38.53841696 | -118.4344506 | 2022-12-29 04:21:01 | Mineral, Nevada, US | |
3553705 | 3553705 | 2022-11-27 | US | Nebraska | Burt | 31021 | 1461 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-11-28 04:21:02 | Burt, Nebraska, US | |
3552650 | 3552650 | 2022-11-27 | US | Illinois | Henderson | 17071 | 1461 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-11-28 04:21:02 | Henderson, Illinois, US | |
2102185 | 2102185 | 2022-11-26 | US | Nebraska | Burt | 31021 | 1461 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-11-27 04:21:05 | Burt, Nebraska, US | |
2101130 | 2101130 | 2022-11-26 | US | Illinois | Henderson | 17071 | 1461 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-11-27 04:21:05 | Henderson, Illinois, US | |
489676 | 489676 | 2022-11-25 | US | Nebraska | Burt | 31021 | 1461 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-11-26 04:21:11 | Burt, Nebraska, US | |
488621 | 488621 | 2022-11-25 | US | Illinois | Henderson | 17071 | 1461 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-11-26 04:21:11 | Henderson, Illinois, US | |
3525505 | 3525505 | 2022-11-24 | US | Nebraska | Burt | 31021 | 1461 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-11-25 04:21:06 | Burt, Nebraska, US | |
3524450 | 3524450 | 2022-11-24 | US | Illinois | Henderson | 17071 | 1461 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-11-25 04:21:06 | Henderson, Illinois, US | |
3314288 | 3314288 | 2022-11-23 | US | Nebraska | Burt | 31021 | 1461 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-11-24 04:21:09 | Burt, Nebraska, US | |
3313233 | 3313233 | 2022-11-23 | US | Illinois | Henderson | 17071 | 1461 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-11-24 04:21:09 | Henderson, Illinois, US | |
1622329 | 1622329 | 2022-11-22 | US | Nebraska | Burt | 31021 | 1461 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-11-23 04:21:06 | Burt, Nebraska, US | |
1621274 | 1621274 | 2022-11-22 | US | Illinois | Henderson | 17071 | 1461 | 19 | 0 | 40.81908672 | -90.92491462 | 2022-11-23 04:21:06 | Henderson, Illinois, US | |
3462217 | 3462217 | 2022-11-21 | US | Nebraska | Burt | 31021 | 1461 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-11-22 04:20:47 | Burt, Nebraska, US | |
1642402 | 1642402 | 2022-11-20 | US | Nebraska | Burt | 31021 | 1461 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-11-21 04:21:05 | Burt, Nebraska, US | |
2065959 | 2065959 | 2022-11-19 | US | Nebraska | Burt | 31021 | 1461 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-11-20 04:21:08 | Burt, Nebraska, US | |
1757353 | 1757353 | 2022-11-18 | US | Nebraska | Burt | 31021 | 1461 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-11-19 04:21:14 | Burt, Nebraska, US | |
3028346 | 3028346 | 2022-11-17 | US | Nebraska | Burt | 31021 | 1461 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-11-18 04:21:15 | Burt, Nebraska, US | |
2488057 | 2488057 | 2022-11-16 | US | Nebraska | Burt | 31021 | 1461 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-11-17 04:21:11 | Burt, Nebraska, US | |
2486660 | 2486660 | 2022-11-16 | US | Colorado | Saguache | 8109 | 1461 | 12 | 0 | 38.08054629 | -106.282466 | 2022-11-17 04:21:11 | Saguache, Colorado, US | |
294068 | 294068 | 2022-11-15 | US | Nebraska | Burt | 31021 | 1461 | 23 | 0 | 41.85056773 | -96.32605633 | 2022-11-16 04:21:09 | Burt, Nebraska, US | |
314967 | 314967 | 2022-11-13 | US | Texas | Crane | 48103 | 1461 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-11-14 04:21:09 | Crane, Texas, US | |
66128 | 66128 | 2022-11-12 | US | Texas | Crane | 48103 | 1461 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-11-13 04:21:14 | Crane, Texas, US | |
2930290 | 2930290 | 2022-11-11 | US | Texas | Crane | 48103 | 1461 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-11-12 04:20:41 | Crane, Texas, US | |
2509126 | 2509126 | 2022-11-10 | US | Texas | Crane | 48103 | 1461 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-11-11 04:21:22 | Crane, Texas, US | |
2434001 | 2434001 | 2022-11-09 | US | Texas | Crane | 48103 | 1461 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-11-10 04:21:16 | Crane, Texas, US | |
482485 | 482485 | 2022-11-08 | US | South Dakota | McCook | 46087 | 1461 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-09 04:21:22 | McCook, South Dakota, US | |
2441635 | 2441635 | 2022-11-07 | US | South Dakota | McCook | 46087 | 1461 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-08 04:21:21 | McCook, South Dakota, US | |
2438552 | 2438552 | 2022-11-07 | China | Tibet | 1461 | 0 | 0 | 31.6927 | 88.0924 | 2022-11-08 04:21:21 | Tibet, China | |||
1052733 | 1052733 | 2022-11-06 | US | South Dakota | McCook | 46087 | 1461 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-07 04:21:26 | McCook, South Dakota, US | |
1049650 | 1049650 | 2022-11-06 | China | Tibet | 1461 | 0 | 0 | 31.6927 | 88.0924 | 2022-11-07 04:21:26 | Tibet, China | |||
620757 | 620757 | 2022-11-05 | US | South Dakota | McCook | 46087 | 1461 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-06 04:21:24 | McCook, South Dakota, US | |
617674 | 617674 | 2022-11-05 | China | Tibet | 1461 | 0 | 0 | 31.6927 | 88.0924 | 2022-11-06 04:21:24 | Tibet, China | |||
1025261 | 1025261 | 2022-11-04 | US | South Dakota | McCook | 46087 | 1461 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-05 04:21:52 | McCook, South Dakota, US | |
1022178 | 1022178 | 2022-11-04 | China | Tibet | 1461 | 0 | 0 | 31.6927 | 88.0924 | 2022-11-05 04:21:52 | Tibet, China | |||
434252 | 434252 | 2022-11-03 | US | South Dakota | McCook | 46087 | 1461 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-04 04:22:11 | McCook, South Dakota, US | |
431169 | 431169 | 2022-11-03 | China | Tibet | 1461 | 0 | 0 | 31.6927 | 88.0924 | 2022-11-04 04:22:11 | Tibet, China | |||
852494 | 852494 | 2022-11-02 | US | South Dakota | McCook | 46087 | 1461 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-03 04:22:05 | McCook, South Dakota, US | |
849411 | 849411 | 2022-11-02 | China | Tibet | 1461 | 0 | 0 | 31.6927 | 88.0924 | 2022-11-03 04:22:05 | Tibet, China | |||
710262 | 710262 | 2022-11-01 | China | Tibet | 1461 | 0 | 0 | 31.6927 | 88.0924 | 2022-11-02 04:22:09 | Tibet, China | |||
3284711 | 3284711 | 2022-10-31 | China | Tibet | 1461 | 0 | 0 | 31.6927 | 88.0924 | 2022-11-01 04:22:36 | Tibet, China | |||
319744 | 319744 | 2022-10-30 | China | Tibet | 1461 | 0 | 0 | 31.6927 | 88.0924 | 2022-10-31 04:21:36 | Tibet, China | |||
912020 | 912020 | 2022-10-29 | China | Tibet | 1461 | 0 | 0 | 31.6927 | 88.0924 | 2022-10-30 04:22:14 | Tibet, China | |||
1563309 | 1563309 | 2022-09-28 | US | Texas | Sabine | 48403 | 1461 | 90 | 0 | 31.34318809 | -93.85440451 | 2022-09-29 04:22:34 | Sabine, Texas, US | |
1563195 | 1563195 | 2022-09-28 | US | Texas | Goliad | 48175 | 1461 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-09-29 04:22:34 | Goliad, Texas, US | |
3997852 | 3997852 | 2022-09-27 | US | Texas | Sabine | 48403 | 1461 | 90 | 0 | 31.34318809 | -93.85440451 | 2022-09-28 04:23:01 | Sabine, Texas, US | |
3997738 | 3997738 | 2022-09-27 | US | Texas | Goliad | 48175 | 1461 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-09-28 04:23:01 | Goliad, Texas, US | |
2772180 | 2772180 | 2022-09-26 | US | Texas | Sabine | 48403 | 1461 | 90 | 0 | 31.34318809 | -93.85440451 | 2022-09-27 04:23:01 | Sabine, Texas, US | |
2772066 | 2772066 | 2022-09-26 | US | Texas | Goliad | 48175 | 1461 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-09-27 04:23:01 | Goliad, Texas, US | |
1979833 | 1979833 | 2022-09-25 | US | Texas | Sabine | 48403 | 1461 | 90 | 0 | 31.34318809 | -93.85440451 | 2022-09-26 04:20:52 | Sabine, Texas, US | |
1979719 | 1979719 | 2022-09-25 | US | Texas | Goliad | 48175 | 1461 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-09-26 04:20:52 | Goliad, Texas, US | |
2653000 | 2653000 | 2022-09-24 | US | Texas | Sabine | 48403 | 1461 | 90 | 0 | 31.34318809 | -93.85440451 | 2022-09-25 04:23:31 | Sabine, Texas, US | |
2652886 | 2652886 | 2022-09-24 | US | Texas | Goliad | 48175 | 1461 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-09-25 04:23:31 | Goliad, Texas, US | |
387440 | 387440 | 2022-09-23 | US | Texas | Sabine | 48403 | 1461 | 90 | 0 | 31.34318809 | -93.85440451 | 2022-09-24 04:21:40 | Sabine, Texas, US | |
387326 | 387326 | 2022-09-23 | US | Texas | Goliad | 48175 | 1461 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-09-24 04:21:40 | Goliad, Texas, US | |
3989946 | 3989946 | 2022-09-15 | US | Virginia | Charles City | 51036 | 1461 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-09-16 04:21:19 | Charles City, Virginia, US | |
1892463 | 1892463 | 2022-09-14 | US | Virginia | Charles City | 51036 | 1461 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-09-15 04:21:02 | Charles City, Virginia, US | |
255724 | 255724 | 2022-09-08 | US | North Dakota | McHenry | 38049 | 1461 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-09-09 04:21:11 | McHenry, North Dakota, US | |
115715 | 115715 | 2022-09-06 | US | Illinois | Alexander | 17003 | 1461 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-09-07 04:20:59 | Alexander, Illinois, US | |
2634687 | 2634687 | 2022-09-05 | US | Illinois | Alexander | 17003 | 1461 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-09-06 04:21:02 | Alexander, Illinois, US | |
2988251 | 2988251 | 2022-09-04 | US | Illinois | Alexander | 17003 | 1461 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-09-05 04:21:01 | Alexander, Illinois, US | |
2713936 | 2713936 | 2022-09-03 | US | Illinois | Alexander | 17003 | 1461 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-09-04 04:21:22 | Alexander, Illinois, US | |
1394641 | 1394641 | 2022-09-02 | US | Illinois | Alexander | 17003 | 1461 | 16 | 0 | 37.18049267 | -89.32910838 | 2022-09-03 04:21:04 | Alexander, Illinois, US | |
1251524 | 1251524 | 2022-08-23 | US | Georgia | Calhoun | 13037 | 1461 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-08-24 04:20:46 | Calhoun, Georgia, US | |
2853628 | 2853628 | 2022-08-22 | US | Georgia | Calhoun | 13037 | 1461 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-08-23 04:20:56 | Calhoun, Georgia, US | |
2403600 | 2403600 | 2022-08-21 | US | Georgia | Calhoun | 13037 | 1461 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-08-22 04:20:38 | Calhoun, Georgia, US | |
3798678 | 3798678 | 2022-08-20 | US | Georgia | Calhoun | 13037 | 1461 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-08-21 04:20:44 | Calhoun, Georgia, US | |
2364264 | 2364264 | 2022-08-19 | US | Georgia | Calhoun | 13037 | 1461 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-08-20 04:21:01 | Calhoun, Georgia, US | |
1161935 | 1161935 | 2022-08-18 | US | Georgia | Calhoun | 13037 | 1461 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-08-19 04:20:54 | Calhoun, Georgia, US | |
3951259 | 3951259 | 2022-08-17 | US | Georgia | Calhoun | 13037 | 1461 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-08-18 04:21:11 | Calhoun, Georgia, US | |
1968389 | 1968389 | 2022-08-13 | China | Jiangxi | 1461 | 1 | 0 | 27.614 | 115.7221 | 2022-08-14 04:20:55 | Jiangxi, China | |||
961800 | 961800 | 2022-07-19 | US | South Dakota | Spink | 46115 | 1461 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-07-20 04:20:59 | Spink, South Dakota, US | |
3213187 | 3213187 | 2022-07-18 | US | South Dakota | Spink | 46115 | 1461 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-07-19 04:20:58 | Spink, South Dakota, US | |
3408362 | 3408362 | 2022-07-17 | US | South Dakota | Spink | 46115 | 1461 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-07-18 04:20:59 | Spink, South Dakota, US | |
2154562 | 2154562 | 2022-07-16 | US | South Dakota | Spink | 46115 | 1461 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-07-17 04:21:15 | Spink, South Dakota, US | |
2421795 | 2421795 | 2022-07-15 | US | South Dakota | Spink | 46115 | 1461 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-07-16 04:21:05 | Spink, South Dakota, US | |
3431870 | 3431870 | 2022-07-14 | US | South Dakota | Spink | 46115 | 1461 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-07-15 04:20:53 | Spink, South Dakota, US | |
3112390 | 3112390 | 2022-07-13 | US | South Dakota | Spink | 46115 | 1461 | 36 | 0 | 44.93837606 | -98.34626602 | 2022-07-14 04:20:57 | Spink, South Dakota, US | |
2792222 | 2792222 | 2022-07-10 | US | Texas | Newton | 48351 | 1461 | 62 | 0 | 30.78548982 | -93.74408813 | 2022-07-11 04:20:46 | Newton, Texas, US | |
3943388 | 3943388 | 2022-06-30 | US | Virginia | Cumberland | 51049 | 1461 | 27 | 0 | 37.51328851 | -78.24398086 | 2022-07-01 04:21:10 | Cumberland, Virginia, US | |
1851115 | 1851115 | 2022-05-26 | US | Indiana | Ohio | 18115 | 1461 | 19 | 0 | 38.955305 | -84.96515993 | 2022-05-27 04:20:56 | Ohio, Indiana, US | |
2048991 | 2048991 | 2022-05-25 | US | Indiana | Ohio | 18115 | 1461 | 19 | 0 | 38.955305 | -84.96515993 | 2022-05-26 04:20:50 | Ohio, Indiana, US | |
3000429 | 3000429 | 2022-05-24 | US | Indiana | Ohio | 18115 | 1461 | 19 | 0 | 38.955305 | -84.96515993 | 2022-05-25 04:20:56 | Ohio, Indiana, US | |
3594150 | 3594150 | 2022-05-23 | US | Indiana | Ohio | 18115 | 1461 | 19 | 0 | 38.955305 | -84.96515993 | 2022-05-24 04:20:57 | Ohio, Indiana, US | |
623002 | 623002 | 2022-05-22 | US | Indiana | Ohio | 18115 | 1461 | 19 | 0 | 38.955305 | -84.96515993 | 2022-05-26 04:20:50 | Ohio, Indiana, US | |
2332007 | 2332007 | 2022-05-08 | US | Colorado | Huerfano | 8055 | 1461 | 35 | 0 | 37.68473101 | -104.9612585 | 2022-05-09 04:20:54 | Huerfano, Colorado, US | |
360969 | 360969 | 2022-05-07 | US | Colorado | Huerfano | 8055 | 1461 | 35 | 0 | 37.68473101 | -104.9612585 | 2022-05-08 04:20:49 | Huerfano, Colorado, US | |
1398320 | 1398320 | 2022-05-06 | US | Colorado | Huerfano | 8055 | 1461 | 35 | 0 | 37.68473101 | -104.9612585 | 2022-05-07 04:21:09 | Huerfano, Colorado, US | |
2598675 | 2598675 | 2022-05-05 | US | Colorado | Huerfano | 8055 | 1461 | 35 | 0 | 37.68473101 | -104.9612585 | 2022-05-06 04:21:00 | Huerfano, Colorado, US | |
3266124 | 3266124 | 2022-05-04 | US | Colorado | Huerfano | 8055 | 1461 | 35 | 0 | 37.68473101 | -104.9612585 | 2022-05-05 04:20:55 | Huerfano, Colorado, US | |
3854363 | 3854363 | 2022-04-27 | US | Oklahoma | Cotton | 40033 | 1461 | 29 | 0 | 34.28845626 | -98.37053567 | 2022-04-28 04:20:47 | Cotton, Oklahoma, US | |
1328793 | 1328793 | 2022-04-26 | US | Oklahoma | Cotton | 40033 | 1461 | 29 | 0 | 34.28845626 | -98.37053567 | 2022-04-27 04:20:52 | Cotton, Oklahoma, US | |
3724747 | 3724747 | 2022-04-25 | US | Oklahoma | Cotton | 40033 | 1461 | 29 | 0 | 34.28845626 | -98.37053567 | 2022-04-26 04:20:51 | Cotton, Oklahoma, US | |
2031315 | 2031315 | 2022-04-24 | US | Oklahoma | Cotton | 40033 | 1461 | 29 | 0 | 34.28845626 | -98.37053567 | 2022-04-25 04:20:56 | Cotton, Oklahoma, US | |
748890 | 748890 | 2022-04-23 | US | Oklahoma | Cotton | 40033 | 1461 | 29 | 0 | 34.28845626 | -98.37053567 | 2022-04-24 04:20:56 | Cotton, Oklahoma, US | |
3439375 | 3439375 | 2022-04-22 | US | Oklahoma | Cotton | 40033 | 1461 | 29 | 0 | 34.28845626 | -98.37053567 | 2022-04-23 04:20:50 | Cotton, Oklahoma, US | |
2894960 | 2894960 | 2022-04-21 | US | Oklahoma | Cotton | 40033 | 1461 | 29 | 0 | 34.28845626 | -98.37053567 | 2022-04-22 04:20:45 | Cotton, Oklahoma, US | |
3321594 | 3321594 | 2022-04-07 | US | Kansas | Stevens | 20189 | 1461 | 20 | 0 | 37.1923008 | -101.3118967 | 2022-04-08 04:20:48 | Stevens, Kansas, US | |
2802130 | 2802130 | 2022-04-06 | US | Kansas | Stevens | 20189 | 1461 | 20 | 0 | 37.1923008 | -101.3118967 | 2022-04-07 04:20:53 | Stevens, Kansas, 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]);