johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
353 rows where confirmed = 2299 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 17
- US 320
- Colombia 10
- China 5
- Japan 2
- Russia 2
- Saint Vincent and the Grenadines 2
- Sao Tome and Principe 2
- Burundi 1
- Canada 1
- Croatia 1
- Malaysia 1
- Netherlands 1
- New Zealand 1
- Pakistan 1
- Peru 1
- Singapore 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
328574 | 328574 | 2022-12-27 | US | Colorado | Yuma | 8125 | 2299 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-12-28 04:21:04 | Yuma, Colorado, US | |
218647 | 218647 | 2022-12-26 | US | Colorado | Yuma | 8125 | 2299 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-12-27 04:21:07 | Yuma, Colorado, US | |
454699 | 454699 | 2022-12-21 | US | Virginia | Bland | 51021 | 2299 | 24 | 0 | 37.13128068 | -81.13599391 | 2022-12-22 04:20:56 | Bland, Virginia, US | |
2953711 | 2953711 | 2022-12-20 | US | North Carolina | Gates | 37073 | 2299 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-12-21 04:21:03 | Gates, North Carolina, US | |
3176113 | 3176113 | 2022-12-19 | US | North Carolina | Gates | 37073 | 2299 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-12-20 04:21:04 | Gates, North Carolina, US | |
1630630 | 1630630 | 2022-12-18 | US | North Carolina | Gates | 37073 | 2299 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-12-19 04:21:03 | Gates, North Carolina, US | |
506009 | 506009 | 2022-12-17 | US | North Carolina | Gates | 37073 | 2299 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-12-18 04:21:03 | Gates, North Carolina, US | |
3326581 | 3326581 | 2022-12-16 | US | North Carolina | Gates | 37073 | 2299 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-12-17 04:21:04 | Gates, North Carolina, US | |
545093 | 545093 | 2022-12-15 | US | North Carolina | Gates | 37073 | 2299 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-12-16 04:21:01 | Gates, North Carolina, US | |
350621 | 350621 | 2022-12-14 | US | North Carolina | Gates | 37073 | 2299 | 21 | 0 | 36.44667547 | -76.69749701 | 2022-12-15 04:20:58 | Gates, North Carolina, US | |
2417297 | 2417297 | 2022-12-05 | US | North Dakota | Pembina | 38067 | 2299 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-12-06 04:21:03 | Pembina, North Dakota, US | |
201779 | 201779 | 2022-10-19 | US | West Virginia | Tucker | 54093 | 2299 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-10-20 04:22:59 | Tucker, West Virginia, US | |
3995544 | 3995544 | 2022-09-27 | US | Georgia | Wilcox | 13315 | 2299 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-09-28 04:23:01 | Wilcox, Georgia, US | |
2769872 | 2769872 | 2022-09-26 | US | Georgia | Wilcox | 13315 | 2299 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-09-27 04:23:01 | Wilcox, Georgia, US | |
1977525 | 1977525 | 2022-09-25 | US | Georgia | Wilcox | 13315 | 2299 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-09-26 04:20:52 | Wilcox, Georgia, US | |
2650692 | 2650692 | 2022-09-24 | US | Georgia | Wilcox | 13315 | 2299 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-09-25 04:23:31 | Wilcox, Georgia, US | |
385132 | 385132 | 2022-09-23 | US | Georgia | Wilcox | 13315 | 2299 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-09-24 04:21:40 | Wilcox, Georgia, US | |
1626282 | 1626282 | 2022-09-22 | US | Montana | Carbon | 30009 | 2299 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-09-23 04:23:13 | Carbon, Montana, US | |
1625198 | 1625198 | 2022-09-22 | US | Georgia | Wilcox | 13315 | 2299 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-09-23 04:23:13 | Wilcox, Georgia, US | |
1372486 | 1372486 | 2022-09-21 | US | Montana | Carbon | 30009 | 2299 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-09-22 04:22:56 | Carbon, Montana, US | |
1371402 | 1371402 | 2022-09-21 | US | Georgia | Wilcox | 13315 | 2299 | 71 | 0 | 31.97496928 | -83.43438555 | 2022-09-22 04:22:56 | Wilcox, Georgia, US | |
2018716 | 2018716 | 2022-09-20 | US | Montana | Carbon | 30009 | 2299 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-09-21 04:23:22 | Carbon, Montana, US | |
2017939 | 2017939 | 2022-09-20 | US | Iowa | Keokuk | 19107 | 2299 | 50 | 0 | 41.33649833 | -92.1785067 | 2022-09-21 04:23:22 | Keokuk, Iowa, US | |
3572589 | 3572589 | 2022-09-19 | US | Montana | Carbon | 30009 | 2299 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-09-20 04:22:48 | Carbon, Montana, US | |
3571812 | 3571812 | 2022-09-19 | US | Iowa | Keokuk | 19107 | 2299 | 50 | 0 | 41.33649833 | -92.1785067 | 2022-09-20 04:22:48 | Keokuk, Iowa, US | |
421328 | 421328 | 2022-09-18 | US | Montana | Carbon | 30009 | 2299 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-09-19 04:21:49 | Carbon, Montana, US | |
420551 | 420551 | 2022-09-18 | US | Iowa | Keokuk | 19107 | 2299 | 50 | 0 | 41.33649833 | -92.1785067 | 2022-09-19 04:21:49 | Keokuk, Iowa, US | |
3375352 | 3375352 | 2022-09-17 | US | Montana | Carbon | 30009 | 2299 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-09-18 04:22:50 | Carbon, Montana, US | |
3374575 | 3374575 | 2022-09-17 | US | Iowa | Keokuk | 19107 | 2299 | 50 | 0 | 41.33649833 | -92.1785067 | 2022-09-18 04:22:50 | Keokuk, Iowa, US | |
2357460 | 2357460 | 2022-09-16 | US | Montana | Carbon | 30009 | 2299 | 28 | 0 | 45.22850116 | -109.0274047 | 2022-09-17 04:20:19 | Carbon, Montana, US | |
2356683 | 2356683 | 2022-09-16 | US | Iowa | Keokuk | 19107 | 2299 | 50 | 0 | 41.33649833 | -92.1785067 | 2022-09-17 04:20:19 | Keokuk, Iowa, US | |
3987840 | 3987840 | 2022-09-15 | US | Iowa | Keokuk | 19107 | 2299 | 50 | 0 | 41.33649833 | -92.1785067 | 2022-09-16 04:21:19 | Keokuk, Iowa, US | |
1890357 | 1890357 | 2022-09-14 | US | Iowa | Keokuk | 19107 | 2299 | 50 | 0 | 41.33649833 | -92.1785067 | 2022-09-15 04:21:02 | Keokuk, Iowa, US | |
3744926 | 3744926 | 2022-09-07 | China | Yunnan | 2299 | 2 | 0 | 24.974 | 101.487 | 2022-09-08 04:21:02 | Yunnan, China | |||
3551014 | 3551014 | 2022-09-01 | US | West Virginia | Pleasants | 54073 | 2299 | 38 | 0 | 39.37091679 | -81.16771771 | 2022-09-02 04:21:07 | Pleasants, West Virginia, US | |
1880147 | 1880147 | 2022-08-28 | US | Texas | Live Oak | 48297 | 2299 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-08-29 04:21:06 | Live Oak, Texas, US | |
2099274 | 2099274 | 2022-08-27 | US | Texas | Live Oak | 48297 | 2299 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-08-28 04:21:02 | Live Oak, Texas, US | |
1535089 | 1535089 | 2022-08-26 | US | Texas | Live Oak | 48297 | 2299 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-08-27 04:20:57 | Live Oak, Texas, US | |
2830845 | 2830845 | 2022-08-25 | US | Montana | Sanders | 30089 | 2299 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-08-26 04:21:02 | Sanders, Montana, US | |
2326857 | 2326857 | 2022-08-24 | US | West Virginia | Pocahontas | 54075 | 2299 | 32 | 0 | 38.32758728 | -80.00993811 | 2022-08-25 04:21:13 | Pocahontas, West Virginia, US | |
2325378 | 2325378 | 2022-08-24 | US | Montana | Sanders | 30089 | 2299 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-08-25 04:21:13 | Sanders, Montana, US | |
1252787 | 1252787 | 2022-08-23 | US | Montana | Sanders | 30089 | 2299 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-08-24 04:20:46 | Sanders, Montana, US | |
2855296 | 2855296 | 2022-08-22 | US | North Dakota | Traill | 38097 | 2299 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-08-23 04:20:56 | Traill, North Dakota, US | |
2854891 | 2854891 | 2022-08-22 | US | Montana | Sanders | 30089 | 2299 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-08-23 04:20:56 | Sanders, Montana, US | |
2405268 | 2405268 | 2022-08-21 | US | North Dakota | Traill | 38097 | 2299 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-08-22 04:20:38 | Traill, North Dakota, US | |
2404863 | 2404863 | 2022-08-21 | US | Montana | Sanders | 30089 | 2299 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-08-22 04:20:38 | Sanders, Montana, US | |
3800346 | 3800346 | 2022-08-20 | US | North Dakota | Traill | 38097 | 2299 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-08-21 04:20:44 | Traill, North Dakota, US | |
3799941 | 3799941 | 2022-08-20 | US | Montana | Sanders | 30089 | 2299 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-08-21 04:20:44 | Sanders, Montana, US | |
2365932 | 2365932 | 2022-08-19 | US | North Dakota | Traill | 38097 | 2299 | 26 | 0 | 47.45367788 | -97.16323288 | 2022-08-20 04:21:01 | Traill, North Dakota, US | |
2365527 | 2365527 | 2022-08-19 | US | Montana | Sanders | 30089 | 2299 | 52 | 0 | 47.67657534 | -115.1329916 | 2022-08-20 04:21:01 | Sanders, Montana, US | |
993202 | 993202 | 2022-08-16 | US | New Mexico | Quay | 35037 | 2299 | 65 | 0 | 35.10403332 | -103.5481727 | 2022-08-17 04:20:59 | Quay, New Mexico, US | |
1073375 | 1073375 | 2022-08-07 | US | West Virginia | Gilmer | 54021 | 2299 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-08 04:21:08 | Gilmer, West Virginia, US | |
1071980 | 1071980 | 2022-08-07 | US | Nebraska | Holt | 31089 | 2299 | 20 | 0 | 42.45522056 | -98.78402558 | 2022-08-08 04:21:08 | Holt, Nebraska, US | |
1943963 | 1943963 | 2022-08-06 | US | West Virginia | Gilmer | 54021 | 2299 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-07 04:20:54 | Gilmer, West Virginia, US | |
1942568 | 1942568 | 2022-08-06 | US | Nebraska | Holt | 31089 | 2299 | 20 | 0 | 42.45522056 | -98.78402558 | 2022-08-07 04:20:54 | Holt, Nebraska, US | |
883762 | 883762 | 2022-08-05 | US | West Virginia | Gilmer | 54021 | 2299 | 21 | 0 | 38.9251277 | -80.85952723 | 2022-08-06 04:20:56 | Gilmer, West Virginia, US | |
882367 | 882367 | 2022-08-05 | US | Nebraska | Holt | 31089 | 2299 | 20 | 0 | 42.45522056 | -98.78402558 | 2022-08-06 04:20:56 | Holt, Nebraska, US | |
2012027 | 2012027 | 2022-08-04 | US | Virginia | Fairfax City | 51600 | 2299 | 45 | 0 | 38.85157547 | -77.2977964 | 2022-08-05 04:20:52 | Fairfax City, Virginia, US | |
2010778 | 2010778 | 2022-08-04 | US | Nebraska | Holt | 31089 | 2299 | 20 | 0 | 42.45522056 | -98.78402558 | 2022-08-05 04:20:52 | Holt, Nebraska, US | |
1100205 | 1100205 | 2022-08-03 | US | Nebraska | Holt | 31089 | 2299 | 20 | 0 | 42.45522056 | -98.78402558 | 2022-08-04 04:20:58 | Holt, Nebraska, US | |
672214 | 672214 | 2022-07-21 | US | Missouri | Iron | 29093 | 2299 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-07-22 04:21:15 | Iron, Missouri, US | |
1610177 | 1610177 | 2022-07-20 | US | Missouri | Iron | 29093 | 2299 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-07-21 04:21:10 | Iron, Missouri, US | |
960810 | 960810 | 2022-07-19 | US | Missouri | Iron | 29093 | 2299 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-07-20 04:20:59 | Iron, Missouri, US | |
3212197 | 3212197 | 2022-07-18 | US | Missouri | Iron | 29093 | 2299 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-07-19 04:20:58 | Iron, Missouri, US | |
3407372 | 3407372 | 2022-07-17 | US | Missouri | Iron | 29093 | 2299 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-07-18 04:20:59 | Iron, Missouri, US | |
2153572 | 2153572 | 2022-07-16 | US | Missouri | Iron | 29093 | 2299 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-07-17 04:21:15 | Iron, Missouri, US | |
2421982 | 2421982 | 2022-07-15 | US | Texas | Franklin | 48159 | 2299 | 44 | 0 | 33.17653242 | -95.21917243 | 2022-07-16 04:21:05 | Franklin, Texas, US | |
2420805 | 2420805 | 2022-07-15 | US | Missouri | Iron | 29093 | 2299 | 44 | 0 | 37.55487945 | -90.7735296 | 2022-07-16 04:21:05 | Iron, Missouri, US | |
3112218 | 3112218 | 2022-07-13 | US | Puerto Rico | Ceiba | 72037 | 2299 | 0 | 0 | 18.251818 | -65.666416 | 2022-07-14 04:20:57 | Ceiba, Puerto Rico, US | |
1211351 | 1211351 | 2022-07-11 | China | Jiangsu | 2299 | 0 | 0 | 32.9711 | 119.455 | 2022-07-12 04:20:51 | Jiangsu, China | |||
559760 | 559760 | 2022-06-16 | US | Idaho | Owyhee | 16073 | 2299 | 53 | 0 | 42.58016894 | -116.1693871 | 2022-06-17 04:20:56 | Owyhee, Idaho, US | |
3983562 | 3983562 | 2022-06-15 | US | Idaho | Owyhee | 16073 | 2299 | 53 | 0 | 42.58016894 | -116.1693871 | 2022-06-16 04:20:55 | Owyhee, Idaho, US | |
950302 | 950302 | 2022-06-14 | US | Washington | Lincoln | 53043 | 2299 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-06-15 04:20:54 | Lincoln, Washington, US | |
2982710 | 2982710 | 2022-06-13 | US | Washington | Lincoln | 53043 | 2299 | 29 | 0 | 47.57705241 | -118.4194388 | 2022-06-14 04:20:52 | Lincoln, Washington, US | |
2235859 | 2235859 | 2022-06-12 | US | Arkansas | Cleveland | 5025 | 2299 | 36 | 0 | 33.89723187 | -92.18537045 | 2022-06-13 04:21:14 | Cleveland, Arkansas, US | |
3142057 | 3142057 | 2022-06-11 | US | Arkansas | Cleveland | 5025 | 2299 | 36 | 0 | 33.89723187 | -92.18537045 | 2022-06-12 04:20:53 | Cleveland, Arkansas, US | |
3581857 | 3581857 | 2022-06-02 | US | Texas | Swisher | 48437 | 2299 | 34 | 0 | 34.53028891 | -101.7349174 | 2022-06-03 04:20:58 | Swisher, Texas, US | |
974442 | 974442 | 2022-06-01 | US | West Virginia | Webster | 54101 | 2299 | 34 | 0 | 38.49370949 | -80.4202023 | 2022-06-02 05:20:39 | Webster, West Virginia, US | |
3189038 | 3189038 | 2022-05-30 | US | Texas | Castro | 48069 | 2299 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-05-31 04:20:51 | Castro, Texas, US | |
3201187 | 3201187 | 2022-05-29 | US | Texas | Castro | 48069 | 2299 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-05-30 04:20:50 | Castro, Texas, US | |
2728065 | 2728065 | 2022-05-28 | US | Texas | Castro | 48069 | 2299 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-05-29 04:20:53 | Castro, Texas, US | |
1317246 | 1317246 | 2022-05-27 | US | Texas | Castro | 48069 | 2299 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-05-28 04:21:07 | Castro, Texas, US | |
1853038 | 1853038 | 2022-05-26 | US | Texas | Castro | 48069 | 2299 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-05-27 04:20:56 | Castro, Texas, US | |
2050914 | 2050914 | 2022-05-25 | US | Texas | Castro | 48069 | 2299 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-05-26 04:20:50 | Castro, Texas, US | |
3002352 | 3002352 | 2022-05-24 | US | Texas | Castro | 48069 | 2299 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-05-25 04:20:56 | Castro, Texas, US | |
624925 | 624925 | 2022-05-22 | US | Texas | Castro | 48069 | 2299 | 47 | 0 | 34.53016752 | -102.2617243 | 2022-05-26 04:20:50 | Castro, Texas, US | |
3899295 | 3899295 | 2022-05-19 | US | Virginia | Essex | 51057 | 2299 | 34 | 0 | 37.93357639 | -76.94230311 | 2022-05-20 04:20:57 | Essex, Virginia, US | |
2084484 | 2084484 | 2022-05-15 | US | Arkansas | Scott | 5127 | 2299 | 43 | 0 | 34.85588887 | -94.0632176 | 2022-05-16 04:20:47 | Scott, Arkansas, US | |
3355194 | 3355194 | 2022-05-14 | US | Arkansas | Scott | 5127 | 2299 | 43 | 0 | 34.85588887 | -94.0632176 | 2022-05-15 04:20:53 | Scott, Arkansas, US | |
658839 | 658839 | 2022-05-13 | US | Arkansas | Scott | 5127 | 2299 | 43 | 0 | 34.85588887 | -94.0632176 | 2022-05-14 04:20:48 | Scott, Arkansas, US | |
466324 | 466324 | 2022-05-02 | US | Tennessee | Clay | 47027 | 2299 | 50 | 0 | 36.55151008 | -85.53930419 | 2022-05-03 04:21:00 | Clay, Tennessee, US | |
3918963 | 3918963 | 2022-05-01 | US | Tennessee | Clay | 47027 | 2299 | 50 | 0 | 36.55151008 | -85.53930419 | 2022-05-02 04:21:10 | Clay, Tennessee, US | |
3917807 | 3917807 | 2022-05-01 | US | Minnesota | Swift | 27151 | 2299 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-05-02 04:21:10 | Swift, Minnesota, US | |
2843767 | 2843767 | 2022-04-30 | US | Tennessee | Clay | 47027 | 2299 | 50 | 0 | 36.55151008 | -85.53930419 | 2022-05-01 04:20:57 | Clay, Tennessee, US | |
2842611 | 2842611 | 2022-04-30 | US | Minnesota | Swift | 27151 | 2299 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-05-01 04:20:57 | Swift, Minnesota, US | |
1160080 | 1160080 | 2022-04-29 | US | Tennessee | Clay | 47027 | 2299 | 50 | 0 | 36.55151008 | -85.53930419 | 2022-04-30 04:21:05 | Clay, Tennessee, US | |
1158924 | 1158924 | 2022-04-29 | US | Minnesota | Swift | 27151 | 2299 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-04-30 04:21:05 | Swift, Minnesota, US | |
1699539 | 1699539 | 2022-04-28 | US | Texas | Red River | 48387 | 2299 | 67 | 0 | 33.61886692 | -95.04841765 | 2022-04-29 04:20:59 | Red River, Texas, US | |
1699262 | 1699262 | 2022-04-28 | US | Tennessee | Clay | 47027 | 2299 | 50 | 0 | 36.55151008 | -85.53930419 | 2022-04-29 04:20:59 | Clay, Tennessee, US | |
1698106 | 1698106 | 2022-04-28 | US | Minnesota | Swift | 27151 | 2299 | 33 | 0 | 45.2829032 | -95.68264092 | 2022-04-29 04:20:59 | Swift, Minnesota, 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]);