johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
349 rows where confirmed = 2266 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754213 | 2754213 | 2022-12-29 | US | Kansas | Kingman | 20095 | 2266 | 30 | 0 | 37.55909527 | -98.13638678 | 2022-12-30 04:21:04 | Kingman, Kansas, US | |
1075219 | 1075219 | 2022-12-28 | US | Kansas | Kingman | 20095 | 2266 | 30 | 0 | 37.55909527 | -98.13638678 | 2022-12-29 04:21:01 | Kingman, Kansas, US | |
328760 | 328760 | 2022-12-27 | US | Georgia | Montgomery | 13209 | 2266 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-12-28 04:21:04 | Montgomery, Georgia, US | |
221556 | 221556 | 2022-12-26 | US | Wisconsin | Pepin | 55091 | 2266 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-12-27 04:21:07 | Pepin, Wisconsin, US | |
218833 | 218833 | 2022-12-26 | US | Georgia | Montgomery | 13209 | 2266 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-12-27 04:21:07 | Montgomery, Georgia, US | |
3223290 | 3223290 | 2022-12-25 | US | Georgia | Montgomery | 13209 | 2266 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-12-26 04:21:06 | Montgomery, Georgia, US | |
1019204 | 1019204 | 2022-12-24 | US | Georgia | Montgomery | 13209 | 2266 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-12-25 04:21:04 | Montgomery, Georgia, US | |
691227 | 691227 | 2022-12-23 | US | Georgia | Montgomery | 13209 | 2266 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-12-24 04:21:02 | Montgomery, Georgia, US | |
2180437 | 2180437 | 2022-12-22 | US | Georgia | Montgomery | 13209 | 2266 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-12-23 04:21:04 | Montgomery, Georgia, US | |
454964 | 454964 | 2022-12-21 | US | Wisconsin | Pepin | 55091 | 2266 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-12-22 04:20:56 | Pepin, Wisconsin, US | |
452241 | 452241 | 2022-12-21 | US | Georgia | Montgomery | 13209 | 2266 | 56 | 0 | 32.17201038 | -82.53527476 | 2022-12-22 04:20:56 | Montgomery, Georgia, US | |
2954963 | 2954963 | 2022-12-20 | US | Wisconsin | Pepin | 55091 | 2266 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-12-21 04:21:03 | Pepin, Wisconsin, US | |
1149613 | 1149613 | 2022-12-12 | US | Colorado | Yuma | 8125 | 2266 | 27 | 0 | 40.00346839 | -102.4258673 | 2022-12-13 04:21:01 | Yuma, Colorado, US | |
2139667 | 2139667 | 2022-12-01 | US | West Virginia | Pendleton | 54071 | 2266 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-12-02 04:21:07 | Pendleton, West Virginia, US | |
852022 | 852022 | 2022-11-02 | US | North Dakota | Pembina | 38067 | 2266 | 16 | 0 | 48.76623521 | -97.5523809 | 2022-11-03 04:22:05 | Pembina, North Dakota, US | |
2689077 | 2689077 | 2022-10-03 | US | Virginia | Middlesex | 51119 | 2266 | 51 | 0 | 37.63191998 | -76.55064617 | 2022-10-04 04:22:55 | Middlesex, Virginia, US | |
2017608 | 2017608 | 2022-09-20 | US | Georgia | Taylor | 13269 | 2266 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-09-21 04:23:22 | Taylor, Georgia, US | |
3571481 | 3571481 | 2022-09-19 | US | Georgia | Taylor | 13269 | 2266 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-09-20 04:22:48 | Taylor, Georgia, US | |
420220 | 420220 | 2022-09-18 | US | Georgia | Taylor | 13269 | 2266 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-09-19 04:21:49 | Taylor, Georgia, US | |
3374244 | 3374244 | 2022-09-17 | US | Georgia | Taylor | 13269 | 2266 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-09-18 04:22:50 | Taylor, Georgia, US | |
2356352 | 2356352 | 2022-09-16 | US | Georgia | Taylor | 13269 | 2266 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-09-17 04:20:19 | Taylor, Georgia, US | |
3987509 | 3987509 | 2022-09-15 | US | Georgia | Taylor | 13269 | 2266 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-09-16 04:21:19 | Taylor, Georgia, US | |
1890026 | 1890026 | 2022-09-14 | US | Georgia | Taylor | 13269 | 2266 | 51 | 0 | 32.55792548 | -84.25077141 | 2022-09-15 04:21:02 | Taylor, Georgia, US | |
1250572 | 1250572 | 2022-08-23 | China | Yunnan | 2266 | 2 | 0 | 24.974 | 101.487 | 2022-08-24 04:20:46 | Yunnan, China | |||
992041 | 992041 | 2022-08-16 | US | Illinois | Schuyler | 17169 | 2266 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-08-17 04:20:59 | Schuyler, Illinois, US | |
2496982 | 2496982 | 2022-08-15 | US | Tennessee | Hancock | 47067 | 2266 | 39 | 0 | 36.52692871 | -83.22375847 | 2022-08-16 04:20:58 | Hancock, Tennessee, US | |
1408204 | 1408204 | 2022-08-02 | US | Texas | Live Oak | 48297 | 2266 | 42 | 0 | 28.35101362 | -98.1246786 | 2022-08-03 04:20:59 | Live Oak, Texas, US | |
1488113 | 1488113 | 2022-07-26 | US | Arkansas | Searcy | 5129 | 2266 | 49 | 0 | 35.9109364 | -92.69936482 | 2022-07-27 04:21:04 | Searcy, Arkansas, US | |
1610477 | 1610477 | 2022-07-20 | US | New Mexico | Sierra | 35051 | 2266 | 80 | 0 | 33.13028233 | -107.1925893 | 2022-07-21 04:21:10 | Sierra, New Mexico, US | |
961110 | 961110 | 2022-07-19 | US | New Mexico | Sierra | 35051 | 2266 | 80 | 0 | 33.13028233 | -107.1925893 | 2022-07-20 04:20:59 | Sierra, New Mexico, US | |
1169008 | 1169008 | 2022-05-20 | China | Sichuan | 2266 | 3 | 0 | 30.6171 | 102.7103 | 2022-05-21 04:20:58 | Sichuan, China | |||
3269019 | 3269019 | 2022-05-04 | US | West Virginia | Webster | 54101 | 2266 | 33 | 0 | 38.49370949 | -80.4202023 | 2022-05-05 04:20:55 | Webster, West Virginia, US | |
3268248 | 3268248 | 2022-05-04 | US | Puerto Rico | Jayuya | 72073 | 2266 | 0 | 0 | 18.211446 | -66.58878 | 2022-05-05 04:20:55 | Jayuya, Puerto Rico, US | |
1326919 | 1326919 | 2022-04-26 | US | Connecticut | Unassigned | 90009 | 2266 | 1 | 0 | 41.85853803 | 0.0 | 2022-04-27 04:20:52 | Unassigned, Connecticut, US | |
2893367 | 2893367 | 2022-04-21 | US | Idaho | Owyhee | 16073 | 2266 | 53 | 0 | 42.58016894 | -116.16938710000001 | 2022-04-22 04:20:45 | Owyhee, Idaho, US | |
2308239 | 2308239 | 2022-04-20 | US | Idaho | Owyhee | 16073 | 2266 | 53 | 0 | 42.58016894 | -116.16938710000001 | 2022-04-21 04:20:46 | Owyhee, Idaho, US | |
3208055 | 3208055 | 2022-04-11 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-04-12 04:20:49 | Benton, Mississippi, US | |
1577941 | 1577941 | 2022-04-10 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-04-11 04:21:02 | Benton, Mississippi, US | |
1654183 | 1654183 | 2022-04-09 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-04-10 04:20:52 | Benton, Mississippi, US | |
2117505 | 2117505 | 2022-04-08 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-04-09 04:20:42 | Benton, Mississippi, US | |
3322029 | 3322029 | 2022-04-07 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-04-08 04:20:48 | Benton, Mississippi, US | |
2802565 | 2802565 | 2022-04-06 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-04-07 04:20:53 | Benton, Mississippi, US | |
3869334 | 3869334 | 2022-04-05 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-04-06 04:20:49 | Benton, Mississippi, US | |
2750676 | 2750676 | 2022-04-04 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-04-05 04:20:48 | Benton, Mississippi, US | |
3732027 | 3732027 | 2022-04-03 | US | Mississippi | Choctaw | 28019 | 2266 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-04-04 04:20:51 | Choctaw, Mississippi, US | |
3732022 | 3732022 | 2022-04-03 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-04-04 04:20:51 | Benton, Mississippi, US | |
501462 | 501462 | 2022-04-02 | US | Mississippi | Choctaw | 28019 | 2266 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-04-03 04:20:48 | Choctaw, Mississippi, US | |
501457 | 501457 | 2022-04-02 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-04-03 04:20:48 | Benton, Mississippi, US | |
3352447 | 3352447 | 2022-04-01 | US | Mississippi | Choctaw | 28019 | 2266 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-04-02 04:20:47 | Choctaw, Mississippi, US | |
3352442 | 3352442 | 2022-04-01 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-04-02 04:20:47 | Benton, Mississippi, US | |
1541752 | 1541752 | 2022-03-31 | US | Mississippi | Choctaw | 28019 | 2266 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-04-01 04:20:28 | Choctaw, Mississippi, US | |
1541747 | 1541747 | 2022-03-31 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-04-01 04:20:28 | Benton, Mississippi, US | |
2479765 | 2479765 | 2022-03-30 | US | Mississippi | Choctaw | 28019 | 2266 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-03-31 04:20:56 | Choctaw, Mississippi, US | |
2479760 | 2479760 | 2022-03-30 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-31 04:20:56 | Benton, Mississippi, US | |
159806 | 159806 | 2022-03-29 | US | Mississippi | Choctaw | 28019 | 2266 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-03-30 04:20:45 | Choctaw, Mississippi, US | |
159801 | 159801 | 2022-03-29 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-30 04:20:45 | Benton, Mississippi, US | |
1438377 | 1438377 | 2022-03-28 | US | Mississippi | Choctaw | 28019 | 2266 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-03-29 04:20:46 | Choctaw, Mississippi, US | |
1438372 | 1438372 | 2022-03-28 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-29 04:20:46 | Benton, Mississippi, US | |
878053 | 878053 | 2022-03-27 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-28 04:20:33 | Benton, Mississippi, US | |
2165336 | 2165336 | 2022-03-26 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-27 04:20:47 | Benton, Mississippi, US | |
1722272 | 1722272 | 2022-03-25 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-26 04:20:23 | Benton, Mississippi, US | |
1469889 | 1469889 | 2022-03-24 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-25 04:20:46 | Benton, Mississippi, US | |
3024063 | 3024063 | 2022-03-23 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-24 04:20:43 | Benton, Mississippi, US | |
1906985 | 1906985 | 2022-03-22 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-23 04:20:48 | Benton, Mississippi, US | |
3240116 | 3240116 | 2022-03-21 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-22 04:20:54 | Benton, Mississippi, US | |
26189 | 26189 | 2022-03-20 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-21 04:20:50 | Benton, Mississippi, US | |
1658199 | 1658199 | 2022-03-19 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-20 04:20:45 | Benton, Mississippi, US | |
337725 | 337725 | 2022-03-18 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-19 04:20:47 | Benton, Mississippi, US | |
696711 | 696711 | 2022-03-17 | US | North Carolina | Graham | 37075 | 2266 | 30 | 0 | 35.3506925 | -83.83369267 | 2022-03-18 04:20:55 | Graham, North Carolina, US | |
696178 | 696178 | 2022-03-17 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-18 04:20:55 | Benton, Mississippi, US | |
2321654 | 2321654 | 2022-03-16 | US | North Carolina | Graham | 37075 | 2266 | 30 | 0 | 35.3506925 | -83.83369267 | 2022-03-17 04:20:56 | Graham, North Carolina, US | |
2321121 | 2321121 | 2022-03-16 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-17 04:20:56 | Benton, Mississippi, US | |
264578 | 264578 | 2022-03-15 | US | Texas | Castro | 48069 | 2266 | 46 | 0 | 34.53016752 | -102.2617243 | 2022-03-16 04:20:50 | Castro, Texas, US | |
263854 | 263854 | 2022-03-15 | US | North Carolina | Graham | 37075 | 2266 | 30 | 0 | 35.3506925 | -83.83369267 | 2022-03-16 04:20:50 | Graham, North Carolina, US | |
263321 | 263321 | 2022-03-15 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-16 04:20:50 | Benton, Mississippi, US | |
2266213 | 2266213 | 2022-03-14 | US | North Carolina | Graham | 37075 | 2266 | 30 | 0 | 35.3506925 | -83.83369267 | 2022-03-15 04:20:47 | Graham, North Carolina, US | |
2265680 | 2265680 | 2022-03-14 | US | Mississippi | Benton | 28009 | 2266 | 49 | 0 | 34.81681228 | -89.18945516 | 2022-03-15 04:20:47 | Benton, Mississippi, US | |
3630279 | 3630279 | 2022-03-13 | US | North Carolina | Graham | 37075 | 2266 | 30 | 0 | 35.3506925 | -83.83369267 | 2022-03-14 04:20:46 | Graham, North Carolina, US | |
953187 | 953187 | 2022-03-12 | US | North Carolina | Graham | 37075 | 2266 | 30 | 0 | 35.3506925 | -83.83369267 | 2022-03-13 04:20:49 | Graham, North Carolina, US | |
358648 | 358648 | 2022-03-11 | US | North Carolina | Graham | 37075 | 2266 | 30 | 0 | 35.3506925 | -83.83369267 | 2022-03-12 04:20:50 | Graham, North Carolina, US | |
1868232 | 1868232 | 2022-03-10 | US | Puerto Rico | Lajas | 72079 | 2266 | 0 | 0 | 18.011661 | -67.040585 | 2022-03-11 04:20:50 | Lajas, Puerto Rico, US | |
922466 | 922466 | 2022-03-08 | US | Puerto Rico | Santa Isabel | 72133 | 2266 | 0 | 0 | 17.994525 | -66.388913 | 2022-03-09 04:20:59 | Santa Isabel, Puerto Rico, US | |
1550753 | 1550753 | 2022-03-07 | US | Puerto Rico | Santa Isabel | 72133 | 2266 | 0 | 0 | 17.994525 | -66.388913 | 2022-03-08 04:20:54 | Santa Isabel, Puerto Rico, US | |
2202422 | 2202422 | 2022-03-06 | US | Puerto Rico | Santa Isabel | 72133 | 2266 | 0 | 0 | 17.994525 | -66.388913 | 2022-03-07 04:20:47 | Santa Isabel, Puerto Rico, US | |
2094879 | 2094879 | 2022-03-05 | US | Puerto Rico | Santa Isabel | 72133 | 2266 | 0 | 0 | 17.994525 | -66.388913 | 2022-03-06 04:20:49 | Santa Isabel, Puerto Rico, US | |
2668579 | 2668579 | 2022-03-04 | US | Puerto Rico | Santa Isabel | 72133 | 2266 | 0 | 0 | 17.994525 | -66.388913 | 2022-03-05 04:21:10 | Santa Isabel, Puerto Rico, US | |
1647121 | 1647121 | 2022-03-03 | US | Puerto Rico | Luquillo | 72089 | 2266 | 0 | 0 | 18.342114000000002 | -65.72509699999999 | 2022-03-04 04:21:09 | Luquillo, Puerto Rico, US | |
2525181 | 2525181 | 2022-03-02 | China | Zhejiang | 2266 | 1 | 0 | 29.1832 | 120.0934 | 2022-03-03 04:21:01 | Zhejiang, China | |||
3718986 | 3718986 | 2022-02-21 | US | Georgia | Evans | 13109 | 2266 | 62 | 0 | 32.15328841 | -81.8870105 | 2022-02-22 04:21:01 | Evans, Georgia, US | |
3823366 | 3823366 | 2022-02-16 | US | Tennessee | Clay | 47027 | 2266 | 46 | 0 | 36.55151008 | -85.53930419 | 2022-02-17 04:20:56 | Clay, Tennessee, US | |
2642103 | 2642103 | 2022-02-14 | US | Alabama | Bullock | 1011 | 2266 | 49 | 0 | 32.10030533 | -85.71265535 | 2022-02-15 04:21:09 | Bullock, Alabama, US | |
187213 | 187213 | 2022-02-13 | US | Indiana | Switzerland | 18155 | 2266 | 16 | 0 | 38.82767338 | -85.03022429 | 2022-02-14 04:20:51 | Switzerland, Indiana, US | |
186420 | 186420 | 2022-02-13 | US | Alabama | Bullock | 1011 | 2266 | 49 | 0 | 32.10030533 | -85.71265535 | 2022-02-14 04:20:51 | Bullock, Alabama, US | |
318899 | 318899 | 2022-02-12 | US | Tennessee | Perry | 47135 | 2266 | 43 | 0 | 35.63708728 | -87.86139634 | 2022-02-13 04:21:00 | Perry, Tennessee, US | |
317059 | 317059 | 2022-02-12 | US | Indiana | Switzerland | 18155 | 2266 | 16 | 0 | 38.82767338 | -85.03022429 | 2022-02-13 04:21:00 | Switzerland, Indiana, US | |
316266 | 316266 | 2022-02-12 | US | Alabama | Bullock | 1011 | 2266 | 49 | 0 | 32.10030533 | -85.71265535 | 2022-02-13 04:21:00 | Bullock, Alabama, US | |
236476 | 236476 | 2022-02-11 | US | Texas | Terry | 48445 | 2266 | 81 | 0 | 33.17402785 | -102.3354521 | 2022-02-12 04:21:06 | Terry, Texas, US | |
234385 | 234385 | 2022-02-11 | US | Indiana | Switzerland | 18155 | 2266 | 16 | 0 | 38.82767338 | -85.03022429 | 2022-02-12 04:21:06 | Switzerland, Indiana, US | |
2015557 | 2015557 | 2022-02-06 | US | South Dakota | Bon Homme | 46009 | 2266 | 36 | 0 | 42.98914167 | -97.88592746 | 2022-02-07 04:21:05 | Bon Homme, South Dakota, US | |
2015439 | 2015439 | 2022-02-06 | US | Puerto Rico | Ciales | 72039 | 2266 | 0 | 0 | 18.28885 | -66.516475 | 2022-02-07 04:21:05 | Ciales, Puerto Rico, 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]);