johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
478 rows where confirmed = 1469 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3324759 | 3324759 | 2022-12-16 | US | Arkansas | Lafayette | 5073 | 1469 | 30 | 0 | 33.24116713 | -93.60677071 | 2022-12-17 04:21:04 | Lafayette, Arkansas, US | |
309140 | 309140 | 2022-12-13 | US | Iowa | Wayne | 19185 | 1469 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-12-14 04:21:04 | Wayne, Iowa, US | |
1150201 | 1150201 | 2022-12-12 | US | Iowa | Wayne | 19185 | 1469 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-12-13 04:21:01 | Wayne, Iowa, US | |
870055 | 870055 | 2022-12-11 | US | Iowa | Wayne | 19185 | 1469 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-12-12 04:21:01 | Wayne, Iowa, US | |
258585 | 258585 | 2022-12-10 | US | Iowa | Wayne | 19185 | 1469 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-12-11 04:20:50 | Wayne, Iowa, US | |
3937299 | 3937299 | 2022-12-09 | US | Iowa | Wayne | 19185 | 1469 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-12-10 04:21:02 | Wayne, Iowa, US | |
3378631 | 3378631 | 2022-12-08 | US | Iowa | Wayne | 19185 | 1469 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-12-09 04:21:05 | Wayne, Iowa, US | |
1985902 | 1985902 | 2022-12-07 | US | Iowa | Wayne | 19185 | 1469 | 33 | 0 | 40.73969028 | -93.32752197 | 2022-12-08 04:21:07 | Wayne, Iowa, US | |
3717287 | 3717287 | 2022-12-06 | US | Texas | Hartley | 48205 | 1469 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-07 04:20:58 | Hartley, Texas, US | |
2417992 | 2417992 | 2022-12-05 | US | Texas | Hartley | 48205 | 1469 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-06 04:21:03 | Hartley, Texas, US | |
721600 | 721600 | 2022-12-04 | US | Texas | Hartley | 48205 | 1469 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-05 04:20:58 | Hartley, Texas, US | |
2819889 | 2819889 | 2022-12-03 | US | Texas | Hartley | 48205 | 1469 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-04 04:20:56 | Hartley, Texas, US | |
836745 | 836745 | 2022-12-02 | US | Texas | Hartley | 48205 | 1469 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-03 04:21:02 | Hartley, Texas, US | |
2139275 | 2139275 | 2022-12-01 | US | Texas | Hartley | 48205 | 1469 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-02 04:21:07 | Hartley, Texas, US | |
1967691 | 1967691 | 2022-11-30 | US | Texas | Hartley | 48205 | 1469 | 3 | 0 | 35.84008013 | -102.6029022 | 2022-12-01 04:21:03 | Hartley, Texas, US | |
2557246 | 2557246 | 2022-11-29 | US | Colorado | Saguache | 8109 | 1469 | 12 | 0 | 38.08054629 | -106.282466 | 2022-11-30 04:21:07 | Saguache, Colorado, US | |
1240320 | 1240320 | 2022-11-28 | US | Colorado | Saguache | 8109 | 1469 | 12 | 0 | 38.08054629 | -106.282466 | 2022-11-29 04:21:05 | Saguache, Colorado, US | |
3552308 | 3552308 | 2022-11-27 | US | Colorado | Saguache | 8109 | 1469 | 12 | 0 | 38.08054629 | -106.282466 | 2022-11-28 04:21:02 | Saguache, Colorado, US | |
2100788 | 2100788 | 2022-11-26 | US | Colorado | Saguache | 8109 | 1469 | 12 | 0 | 38.08054629 | -106.282466 | 2022-11-27 04:21:05 | Saguache, Colorado, US | |
488279 | 488279 | 2022-11-25 | US | Colorado | Saguache | 8109 | 1469 | 12 | 0 | 38.08054629 | -106.282466 | 2022-11-26 04:21:11 | Saguache, Colorado, US | |
3524108 | 3524108 | 2022-11-24 | US | Colorado | Saguache | 8109 | 1469 | 12 | 0 | 38.08054629 | -106.282466 | 2022-11-25 04:21:06 | Saguache, Colorado, US | |
3312891 | 3312891 | 2022-11-23 | US | Colorado | Saguache | 8109 | 1469 | 12 | 0 | 38.08054629 | -106.282466 | 2022-11-24 04:21:09 | Saguache, Colorado, US | |
1623168 | 1623168 | 2022-11-22 | US | South Dakota | McCook | 46087 | 1469 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-23 04:21:06 | McCook, South Dakota, US | |
3463056 | 3463056 | 2022-11-21 | US | South Dakota | McCook | 46087 | 1469 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-22 04:20:47 | McCook, South Dakota, US | |
1643241 | 1643241 | 2022-11-20 | US | South Dakota | McCook | 46087 | 1469 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-21 04:21:05 | McCook, South Dakota, US | |
2066798 | 2066798 | 2022-11-19 | US | South Dakota | McCook | 46087 | 1469 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-20 04:21:08 | McCook, South Dakota, US | |
1758192 | 1758192 | 2022-11-18 | US | South Dakota | McCook | 46087 | 1469 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-19 04:21:14 | McCook, South Dakota, US | |
3029185 | 3029185 | 2022-11-17 | US | South Dakota | McCook | 46087 | 1469 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-18 04:21:15 | McCook, South Dakota, US | |
2488896 | 2488896 | 2022-11-16 | US | South Dakota | McCook | 46087 | 1469 | 32 | 0 | 43.6742571 | -97.36863144 | 2022-11-17 04:21:11 | McCook, South Dakota, US | |
1022151 | 1022151 | 2022-11-04 | China | Chongqing | 1469 | 6 | 0 | 30.0572 | 107.874 | 2022-11-05 04:21:52 | Chongqing, China | |||
713339 | 713339 | 2022-11-01 | US | South Dakota | Kingsbury | 46077 | 1469 | 24 | 0 | 44.36956169 | -97.4913945 | 2022-11-02 04:22:09 | Kingsbury, South Dakota, US | |
3287788 | 3287788 | 2022-10-31 | US | South Dakota | Kingsbury | 46077 | 1469 | 24 | 0 | 44.36956169 | -97.4913945 | 2022-11-01 04:22:36 | Kingsbury, South Dakota, US | |
322821 | 322821 | 2022-10-30 | US | South Dakota | Kingsbury | 46077 | 1469 | 24 | 0 | 44.36956169 | -97.4913945 | 2022-10-31 04:21:36 | Kingsbury, South Dakota, US | |
915097 | 915097 | 2022-10-29 | US | South Dakota | Kingsbury | 46077 | 1469 | 24 | 0 | 44.36956169 | -97.4913945 | 2022-10-30 04:22:14 | Kingsbury, South Dakota, US | |
1369366 | 1369366 | 2022-10-28 | US | South Dakota | Kingsbury | 46077 | 1469 | 24 | 0 | 44.36956169 | -97.4913945 | 2022-10-29 04:21:13 | Kingsbury, South Dakota, US | |
3041221 | 3041221 | 2022-10-27 | US | South Dakota | Kingsbury | 46077 | 1469 | 24 | 0 | 44.36956169 | -97.4913945 | 2022-10-28 04:22:31 | Kingsbury, South Dakota, US | |
541641 | 541641 | 2022-10-26 | US | South Dakota | Kingsbury | 46077 | 1469 | 24 | 0 | 44.36956169 | -97.4913945 | 2022-10-27 04:22:01 | Kingsbury, South Dakota, US | |
2275140 | 2275140 | 2022-10-20 | US | Texas | Sabine | 48403 | 1469 | 90 | 0 | 31.34318809 | -93.85440451 | 2022-10-21 04:22:23 | Sabine, Texas, US | |
2275026 | 2275026 | 2022-10-20 | US | Texas | Goliad | 48175 | 1469 | 33 | 0 | 28.65696592 | -97.42760647 | 2022-10-21 04:22:23 | Goliad, Texas, US | |
2273915 | 2273915 | 2022-10-20 | US | Montana | Broadwater | 30007 | 1469 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-10-21 04:22:23 | Broadwater, Montana, US | |
201475 | 201475 | 2022-10-19 | US | Texas | Sabine | 48403 | 1469 | 90 | 0 | 31.34318809 | -93.85440451 | 2022-10-20 04:22:59 | Sabine, Texas, US | |
201361 | 201361 | 2022-10-19 | US | Texas | Goliad | 48175 | 1469 | 33 | 0 | 28.65696592 | -97.42760647 | 2022-10-20 04:22:59 | Goliad, Texas, US | |
200250 | 200250 | 2022-10-19 | US | Montana | Broadwater | 30007 | 1469 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-10-20 04:22:59 | Broadwater, Montana, US | |
2760022 | 2760022 | 2022-10-18 | US | Texas | Goliad | 48175 | 1469 | 33 | 0 | 28.65696592 | -97.42760647 | 2022-10-19 04:22:26 | Goliad, Texas, US | |
2758911 | 2758911 | 2022-10-18 | US | Montana | Broadwater | 30007 | 1469 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-10-19 04:22:26 | Broadwater, Montana, US | |
2027856 | 2027856 | 2022-10-17 | US | Texas | Goliad | 48175 | 1469 | 33 | 0 | 28.65696592 | -97.42760647 | 2022-10-18 04:22:42 | Goliad, Texas, US | |
2026745 | 2026745 | 2022-10-17 | US | Montana | Broadwater | 30007 | 1469 | 22 | 0 | 46.33277565 | -111.4955813 | 2022-10-18 04:22:42 | Broadwater, Montana, US | |
2162634 | 2162634 | 2022-10-16 | US | Texas | Goliad | 48175 | 1469 | 33 | 0 | 28.65696592 | -97.42760647 | 2022-10-17 04:20:31 | Goliad, Texas, US | |
518831 | 518831 | 2022-10-15 | US | Texas | Goliad | 48175 | 1469 | 33 | 0 | 28.65696592 | -97.42760647 | 2022-10-16 04:22:39 | Goliad, Texas, US | |
2035888 | 2035888 | 2022-10-14 | US | Texas | Goliad | 48175 | 1469 | 33 | 0 | 28.65696592 | -97.42760647 | 2022-10-15 04:22:00 | Goliad, Texas, US | |
3756576 | 3756576 | 2022-10-13 | US | Texas | Goliad | 48175 | 1469 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-10-14 04:22:28 | Goliad, Texas, US | |
3217401 | 3217401 | 2022-10-12 | US | Texas | Goliad | 48175 | 1469 | 32 | 0 | 28.65696592 | -97.42760647 | 2022-10-13 04:22:39 | Goliad, Texas, US | |
1813336 | 1813336 | 2022-10-05 | US | Oklahoma | Greer | 40055 | 1469 | 39 | 0 | 34.93535801 | -99.5605612 | 2022-10-06 04:21:22 | Greer, Oklahoma, US | |
133310 | 133310 | 2022-10-04 | US | Oklahoma | Greer | 40055 | 1469 | 39 | 0 | 34.93535801 | -99.5605612 | 2022-10-05 04:23:06 | Greer, Oklahoma, US | |
2688257 | 2688257 | 2022-10-03 | US | Oklahoma | Greer | 40055 | 1469 | 39 | 0 | 34.93535801 | -99.5605612 | 2022-10-04 04:22:55 | Greer, Oklahoma, US | |
2262324 | 2262324 | 2022-10-02 | US | Oklahoma | Greer | 40055 | 1469 | 39 | 0 | 34.93535801 | -99.5605612 | 2022-10-03 04:23:11 | Greer, Oklahoma, US | |
2997850 | 2997850 | 2022-10-01 | US | Oklahoma | Greer | 40055 | 1469 | 39 | 0 | 34.93535801 | -99.5605612 | 2022-10-02 04:21:23 | Greer, Oklahoma, US | |
856176 | 856176 | 2022-09-30 | US | Oklahoma | Greer | 40055 | 1469 | 39 | 0 | 34.93535801 | -99.5605612 | 2022-10-01 04:23:01 | Greer, Oklahoma, US | |
2378102 | 2378102 | 2022-09-29 | US | Oklahoma | Greer | 40055 | 1469 | 39 | 0 | 34.93535801 | -99.5605612 | 2022-09-30 04:23:09 | Greer, Oklahoma, US | |
1979938 | 1979938 | 2022-09-25 | US | Virginia | Charles City | 51036 | 1469 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-09-26 04:20:52 | Charles City, Virginia, US | |
2653105 | 2653105 | 2022-09-24 | US | Virginia | Charles City | 51036 | 1469 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-09-25 04:23:31 | Charles City, Virginia, US | |
387545 | 387545 | 2022-09-23 | US | Virginia | Charles City | 51036 | 1469 | 31 | 0 | 37.35358063 | -77.05634116 | 2022-09-24 04:21:40 | Charles City, Virginia, US | |
2397212 | 2397212 | 2022-09-12 | US | North Dakota | McHenry | 38049 | 1469 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-09-13 04:20:57 | McHenry, North Dakota, US | |
1682931 | 1682931 | 2022-08-29 | US | North Dakota | Sioux | 38085 | 1469 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-08-30 04:21:03 | Sioux, North Dakota, US | |
1406238 | 1406238 | 2022-08-02 | US | Iowa | Fremont | 19071 | 1469 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-08-03 04:20:59 | Fremont, Iowa, US | |
3618276 | 3618276 | 2022-08-01 | US | Iowa | Fremont | 19071 | 1469 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-08-02 04:20:53 | Fremont, Iowa, US | |
3872756 | 3872756 | 2022-07-31 | US | Iowa | Fremont | 19071 | 1469 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-08-01 04:21:03 | Fremont, Iowa, US | |
675510 | 675510 | 2022-07-30 | US | Iowa | Fremont | 19071 | 1469 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-07-31 04:21:02 | Fremont, Iowa, US | |
1784709 | 1784709 | 2022-07-29 | US | Iowa | Fremont | 19071 | 1469 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-07-30 04:20:42 | Fremont, Iowa, US | |
1067072 | 1067072 | 2022-07-28 | US | Iowa | Fremont | 19071 | 1469 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-07-29 04:20:45 | Fremont, Iowa, US | |
2336591 | 2336591 | 2022-07-27 | US | Iowa | Fremont | 19071 | 1469 | 26 | 0 | 40.7454272 | -95.60129045 | 2022-07-28 04:20:56 | Fremont, Iowa, US | |
2190160 | 2190160 | 2022-06-22 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-23 04:20:55 | Cotton, Oklahoma, US | |
168591 | 168591 | 2022-06-21 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-22 04:20:54 | Cotton, Oklahoma, US | |
1765874 | 1765874 | 2022-06-20 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-21 04:20:56 | Cotton, Oklahoma, US | |
3272060 | 3272060 | 2022-06-19 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-20 04:21:01 | Cotton, Oklahoma, US | |
3399972 | 3399972 | 2022-06-18 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-19 04:20:51 | Cotton, Oklahoma, US | |
2313849 | 2313849 | 2022-06-17 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-18 04:21:10 | Cotton, Oklahoma, US | |
561353 | 561353 | 2022-06-16 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-17 04:20:56 | Cotton, Oklahoma, US | |
3985155 | 3985155 | 2022-06-15 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-16 04:20:55 | Cotton, Oklahoma, US | |
949396 | 949396 | 2022-06-14 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-15 04:20:54 | Cotton, Oklahoma, US | |
2981804 | 2981804 | 2022-06-13 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-14 04:20:52 | Cotton, Oklahoma, US | |
2237930 | 2237930 | 2022-06-12 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-13 04:21:14 | Cotton, Oklahoma, US | |
3144128 | 3144128 | 2022-06-11 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-12 04:20:53 | Cotton, Oklahoma, US | |
1947044 | 1947044 | 2022-06-10 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-11 04:21:01 | Cotton, Oklahoma, US | |
3160183 | 3160183 | 2022-06-09 | US | Oklahoma | Cotton | 40033 | 1469 | 32 | 0 | 34.28845626 | -98.37053567 | 2022-06-10 04:20:55 | Cotton, Oklahoma, US | |
3727572 | 3727572 | 2022-06-07 | US | Kansas | Stevens | 20189 | 1469 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-06-08 04:20:55 | Stevens, Kansas, US | |
3888974 | 3888974 | 2022-06-06 | US | Kansas | Stevens | 20189 | 1469 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-06-07 04:21:08 | Stevens, Kansas, US | |
3508743 | 3508743 | 2022-06-05 | US | Kansas | Stevens | 20189 | 1469 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-06-06 04:20:57 | Stevens, Kansas, US | |
3508512 | 3508512 | 2022-06-05 | US | Indiana | Ohio | 18115 | 1469 | 19 | 0 | 38.955305 | -84.96515993 | 2022-06-06 04:20:57 | Ohio, Indiana, US | |
3528820 | 3528820 | 2022-06-04 | US | Kansas | Stevens | 20189 | 1469 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-06-05 04:20:55 | Stevens, Kansas, US | |
3528589 | 3528589 | 2022-06-04 | US | Indiana | Ohio | 18115 | 1469 | 19 | 0 | 38.955305 | -84.96515993 | 2022-06-05 04:20:55 | Ohio, Indiana, US | |
3134906 | 3134906 | 2022-06-03 | US | Kansas | Stevens | 20189 | 1469 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-06-04 04:20:58 | Stevens, Kansas, US | |
3134675 | 3134675 | 2022-06-03 | US | Indiana | Ohio | 18115 | 1469 | 19 | 0 | 38.955305 | -84.96515993 | 2022-06-04 04:20:58 | Ohio, Indiana, US | |
3579981 | 3579981 | 2022-06-02 | US | Kansas | Stevens | 20189 | 1469 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-06-03 04:20:58 | Stevens, Kansas, US | |
972274 | 972274 | 2022-06-01 | US | Kansas | Stevens | 20189 | 1469 | 22 | 0 | 37.1923008 | -101.3118967 | 2022-06-02 05:20:39 | Stevens, Kansas, US | |
3596551 | 3596551 | 2022-05-23 | US | West Virginia | Wirt | 54105 | 1469 | 25 | 0 | 39.02775007 | -81.37473928 | 2022-05-24 04:20:57 | Wirt, West Virginia, US | |
3916990 | 3916990 | 2022-05-01 | US | Idaho | Power | 16077 | 1469 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-05-02 04:21:10 | Power, Idaho, US | |
2841794 | 2841794 | 2022-04-30 | US | Idaho | Power | 16077 | 1469 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-05-01 04:20:57 | Power, Idaho, US | |
1158107 | 1158107 | 2022-04-29 | US | Idaho | Power | 16077 | 1469 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-04-30 04:21:05 | Power, Idaho, US | |
1697289 | 1697289 | 2022-04-28 | US | Idaho | Power | 16077 | 1469 | 20 | 0 | 42.69254894 | -112.8395742 | 2022-04-29 04:20:59 | Power, Idaho, 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]);