johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
293 rows where confirmed = 2233 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754242 | 2754242 | 2022-12-29 | US | Kansas | Pratt | 20151 | 2233 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-30 04:21:04 | Pratt, Kansas, US | |
1075248 | 1075248 | 2022-12-28 | US | Kansas | Pratt | 20151 | 2233 | 35 | 0 | 37.64780729 | -98.73922153 | 2022-12-29 04:21:01 | Pratt, Kansas, US | |
3379767 | 3379767 | 2022-12-08 | US | North Dakota | Benson | 38005 | 2233 | 23 | 0 | 48.0683985 | -99.35916363 | 2022-12-09 04:21:05 | Benson, North Dakota, US | |
2560068 | 2560068 | 2022-11-29 | US | West Virginia | Calhoun | 54013 | 2233 | 15 | 0 | 38.84315422 | -81.11934872 | 2022-11-30 04:21:07 | Calhoun, West Virginia, US | |
1051290 | 1051290 | 2022-11-06 | US | Kentucky | Menifee | 21165 | 2233 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-11-07 04:21:26 | Menifee, Kentucky, US | |
619314 | 619314 | 2022-11-05 | US | Kentucky | Menifee | 21165 | 2233 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-11-06 04:21:24 | Menifee, Kentucky, US | |
1023818 | 1023818 | 2022-11-04 | US | Kentucky | Menifee | 21165 | 2233 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-11-05 04:21:52 | Menifee, Kentucky, US | |
432809 | 432809 | 2022-11-03 | US | Kentucky | Menifee | 21165 | 2233 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-11-04 04:22:11 | Menifee, Kentucky, US | |
853176 | 853176 | 2022-11-02 | US | Wisconsin | Pepin | 55091 | 2233 | 19 | 0 | 44.58307413 | -91.99949611 | 2022-11-03 04:22:05 | Pepin, Wisconsin, US | |
851051 | 851051 | 2022-11-02 | US | Kentucky | Menifee | 21165 | 2233 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-11-03 04:22:05 | Menifee, Kentucky, US | |
711902 | 711902 | 2022-11-01 | US | Kentucky | Menifee | 21165 | 2233 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-11-02 04:22:09 | Menifee, Kentucky, US | |
710964 | 710964 | 2022-11-01 | US | Arkansas | Monroe | 5095 | 2233 | 37 | 0 | 34.6815935 | -91.20540287 | 2022-11-02 04:22:09 | Monroe, Arkansas, US | |
3286351 | 3286351 | 2022-10-31 | US | Kentucky | Menifee | 21165 | 2233 | 35 | 0 | 37.94090733 | -83.59985712 | 2022-11-01 04:22:36 | Menifee, Kentucky, US | |
323442 | 323442 | 2022-10-30 | US | West Virginia | Pendleton | 54071 | 2233 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-10-31 04:21:36 | Pendleton, West Virginia, US | |
915718 | 915718 | 2022-10-29 | US | West Virginia | Pendleton | 54071 | 2233 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-10-30 04:22:14 | Pendleton, West Virginia, US | |
1369987 | 1369987 | 2022-10-28 | US | West Virginia | Pendleton | 54071 | 2233 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-10-29 04:21:13 | Pendleton, West Virginia, US | |
3041842 | 3041842 | 2022-10-27 | US | West Virginia | Pendleton | 54071 | 2233 | 23 | 0 | 38.68314479 | -79.35084086 | 2022-10-28 04:22:31 | Pendleton, West Virginia, US | |
200009 | 200009 | 2022-10-19 | US | Minnesota | Murray | 27101 | 2233 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-10-20 04:22:59 | Murray, Minnesota, US | |
2758670 | 2758670 | 2022-10-18 | US | Minnesota | Murray | 27101 | 2233 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-10-19 04:22:26 | Murray, Minnesota, US | |
2026504 | 2026504 | 2022-10-17 | US | Minnesota | Murray | 27101 | 2233 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-10-18 04:22:42 | Murray, Minnesota, US | |
2161282 | 2161282 | 2022-10-16 | US | Minnesota | Murray | 27101 | 2233 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-10-17 04:20:31 | Murray, Minnesota, US | |
517479 | 517479 | 2022-10-15 | US | Minnesota | Murray | 27101 | 2233 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-10-16 04:22:39 | Murray, Minnesota, US | |
2034536 | 2034536 | 2022-10-14 | US | Minnesota | Murray | 27101 | 2233 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-10-15 04:22:00 | Murray, Minnesota, US | |
3755387 | 3755387 | 2022-10-13 | US | Missouri | Hickory | 29085 | 2233 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-14 04:22:28 | Hickory, Missouri, US | |
3755224 | 3755224 | 2022-10-13 | US | Minnesota | Murray | 27101 | 2233 | 20 | 0 | 44.02216709 | -95.76328482 | 2022-10-14 04:22:28 | Murray, Minnesota, US | |
3216212 | 3216212 | 2022-10-12 | US | Missouri | Hickory | 29085 | 2233 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-13 04:22:39 | Hickory, Missouri, US | |
3252061 | 3252061 | 2022-10-11 | US | Missouri | Hickory | 29085 | 2233 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-12 04:22:51 | Hickory, Missouri, US | |
2969320 | 2969320 | 2022-10-10 | US | Missouri | Hickory | 29085 | 2233 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-11 04:23:05 | Hickory, Missouri, US | |
3099356 | 3099356 | 2022-10-09 | US | Missouri | Hickory | 29085 | 2233 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-10 04:22:32 | Hickory, Missouri, US | |
4004581 | 4004581 | 2022-10-08 | US | Missouri | Hickory | 29085 | 2233 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-09 04:21:16 | Hickory, Missouri, US | |
398178 | 398178 | 2022-10-07 | US | Missouri | Hickory | 29085 | 2233 | 59 | 0 | 37.94163617 | -93.3203037 | 2022-10-08 04:22:56 | Hickory, Missouri, US | |
114562 | 114562 | 2022-09-06 | China | Tianjin | 2233 | 3 | 0 | 39.3054 | 117.323 | 2022-09-07 04:20:59 | Tianjin, China | |||
3647398 | 3647398 | 2022-08-14 | China | Yunnan | 2233 | 2 | 0 | 24.974 | 101.487 | 2022-08-15 04:20:59 | Yunnan, China | |||
3910952 | 3910952 | 2022-08-11 | US | Tennessee | Hancock | 47067 | 2233 | 39 | 0 | 36.52692871 | -83.22375847 | 2022-08-12 04:20:54 | Hancock, Tennessee, US | |
1070821 | 1070821 | 2022-08-07 | US | Idaho | Boundary | 16021 | 2233 | 63 | 0 | 48.76684761 | -116.4630179 | 2022-08-08 04:21:08 | Boundary, Idaho, US | |
1941409 | 1941409 | 2022-08-06 | US | Idaho | Boundary | 16021 | 2233 | 63 | 0 | 48.76684761 | -116.4630179 | 2022-08-07 04:20:54 | Boundary, Idaho, US | |
881208 | 881208 | 2022-08-05 | US | Idaho | Boundary | 16021 | 2233 | 63 | 0 | 48.76684761 | -116.4630179 | 2022-08-06 04:20:56 | Boundary, Idaho, US | |
3430494 | 3430494 | 2022-07-14 | US | Louisiana | Red River | 22081 | 2233 | 54 | 0 | 32.09530039 | -93.34213308 | 2022-07-15 04:20:53 | Red River, Louisiana, US | |
3112967 | 3112967 | 2022-07-13 | US | West Virginia | Gilmer | 54021 | 2233 | 19 | 0 | 38.9251277 | -80.85952723 | 2022-07-14 04:20:57 | Gilmer, West Virginia, US | |
2792514 | 2792514 | 2022-07-10 | US | West Virginia | Doddridge | 54017 | 2233 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-07-11 04:20:46 | Doddridge, West Virginia, US | |
2792129 | 2792129 | 2022-07-10 | US | Texas | Gaines | 48165 | 2233 | 83 | 0 | 32.74055318 | -102.6353295 | 2022-07-11 04:20:46 | Gaines, Texas, US | |
145467 | 145467 | 2022-07-09 | US | West Virginia | Doddridge | 54017 | 2233 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-07-10 04:20:54 | Doddridge, West Virginia, US | |
1420567 | 1420567 | 2022-07-08 | US | West Virginia | Doddridge | 54017 | 2233 | 18 | 0 | 39.27057157 | -80.70671527 | 2022-07-09 04:20:59 | Doddridge, West Virginia, US | |
2743745 | 2743745 | 2022-07-07 | US | Puerto Rico | Ceiba | 72037 | 2233 | 0 | 0 | 18.251818 | -65.666416 | 2022-07-08 04:20:56 | Ceiba, Puerto Rico, US | |
1202540 | 1202540 | 2022-07-06 | US | Puerto Rico | Ceiba | 72037 | 2233 | 0 | 0 | 18.251818 | -65.666416 | 2022-07-07 04:20:55 | Ceiba, Puerto Rico, US | |
3080276 | 3080276 | 2022-07-04 | US | New Mexico | Sierra | 35051 | 2233 | 77 | 0 | 33.13028233 | -107.1925893 | 2022-07-05 04:20:45 | Sierra, New Mexico, US | |
1769558 | 1769558 | 2022-07-03 | US | New Mexico | Sierra | 35051 | 2233 | 77 | 0 | 33.13028233 | -107.1925893 | 2022-07-04 04:20:54 | Sierra, New Mexico, US | |
3367544 | 3367544 | 2022-07-02 | US | New Mexico | Sierra | 35051 | 2233 | 77 | 0 | 33.13028233 | -107.1925893 | 2022-07-03 04:20:59 | Sierra, New Mexico, US | |
595873 | 595873 | 2022-07-01 | US | New Mexico | Sierra | 35051 | 2233 | 77 | 0 | 33.13028233 | -107.1925893 | 2022-07-02 04:21:16 | Sierra, New Mexico, US | |
3942274 | 3942274 | 2022-06-30 | US | New Mexico | Sierra | 35051 | 2233 | 77 | 0 | 33.13028233 | -107.1925893 | 2022-07-01 04:21:10 | Sierra, New Mexico, US | |
2148636 | 2148636 | 2022-06-27 | US | Illinois | Hamilton | 17065 | 2233 | 31 | 0 | 38.08163641 | -88.53883373 | 2022-06-28 04:20:58 | Hamilton, Illinois, US | |
2236761 | 2236761 | 2022-06-12 | US | Kentucky | Bracken | 21023 | 2233 | 27 | 0 | 38.69158994 | -84.08532444 | 2022-06-13 04:21:14 | Bracken, Kentucky, US | |
3142959 | 3142959 | 2022-06-11 | US | Kentucky | Bracken | 21023 | 2233 | 27 | 0 | 38.69158994 | -84.08532444 | 2022-06-12 04:20:53 | Bracken, Kentucky, US | |
1945875 | 1945875 | 2022-06-10 | US | Kentucky | Bracken | 21023 | 2233 | 27 | 0 | 38.69158994 | -84.08532444 | 2022-06-11 04:21:01 | Bracken, Kentucky, US | |
3159014 | 3159014 | 2022-06-09 | US | Kentucky | Bracken | 21023 | 2233 | 27 | 0 | 38.69158994 | -84.08532444 | 2022-06-10 04:20:55 | Bracken, Kentucky, US | |
1422481 | 1422481 | 2022-06-08 | US | Kentucky | Bracken | 21023 | 2233 | 27 | 0 | 38.69158994 | -84.08532444 | 2022-06-09 04:20:54 | Bracken, Kentucky, US | |
3727595 | 3727595 | 2022-06-07 | US | Kentucky | Bracken | 21023 | 2233 | 27 | 0 | 38.69158994 | -84.08532444 | 2022-06-08 04:20:55 | Bracken, Kentucky, US | |
3888997 | 3888997 | 2022-06-06 | US | Kentucky | Bracken | 21023 | 2233 | 27 | 0 | 38.69158994 | -84.08532444 | 2022-06-07 04:21:08 | Bracken, Kentucky, US | |
3136568 | 3136568 | 2022-06-03 | US | Texas | Archer | 48009 | 2233 | 28 | 0 | 33.61569967 | -98.68754589 | 2022-06-04 04:20:58 | Archer, Texas, US | |
2051386 | 2051386 | 2022-05-25 | US | West Virginia | Tyler | 54095 | 2233 | 32 | 0 | 39.46811972 | -80.88772676 | 2022-05-26 04:20:50 | Tyler, West Virginia, US | |
2048319 | 2048319 | 2022-05-25 | US | Arizona | Greenlee | 4011 | 2233 | 33 | 0 | 33.21498827 | -109.2405279 | 2022-05-26 04:20:50 | Greenlee, Arizona, US | |
2999757 | 2999757 | 2022-05-24 | US | Arizona | Greenlee | 4011 | 2233 | 33 | 0 | 33.21498827 | -109.2405279 | 2022-05-25 04:20:56 | Greenlee, Arizona, US | |
3593478 | 3593478 | 2022-05-23 | US | Arizona | Greenlee | 4011 | 2233 | 33 | 0 | 33.21498827 | -109.2405279 | 2022-05-24 04:20:57 | Greenlee, Arizona, US | |
625397 | 625397 | 2022-05-22 | US | West Virginia | Tyler | 54095 | 2233 | 32 | 0 | 39.46811972 | -80.88772676 | 2022-05-26 04:20:50 | Tyler, West Virginia, US | |
1110026 | 1110026 | 2022-05-21 | US | Arizona | Greenlee | 4011 | 2233 | 33 | 0 | 33.21498827 | -109.2405279 | 2022-05-22 04:20:52 | Greenlee, Arizona, US | |
1169650 | 1169650 | 2022-05-20 | US | Arizona | Greenlee | 4011 | 2233 | 33 | 0 | 33.21498827 | -109.2405279 | 2022-05-21 04:20:58 | Greenlee, Arizona, US | |
3899346 | 3899346 | 2022-05-19 | US | Virginia | Northumberland | 51133 | 2233 | 46 | 0 | 37.89202088 | -76.41949732 | 2022-05-20 04:20:57 | Northumberland, Virginia, US | |
3897846 | 3897846 | 2022-05-19 | US | Missouri | Carroll | 29033 | 2233 | 44 | 0 | 39.42762566 | -93.50626255 | 2022-05-20 04:20:57 | Carroll, Missouri, US | |
3896413 | 3896413 | 2022-05-19 | US | Arizona | Greenlee | 4011 | 2233 | 33 | 0 | 33.21498827 | -109.2405279 | 2022-05-20 04:20:57 | Greenlee, Arizona, US | |
1186630 | 1186630 | 2022-05-18 | US | Missouri | Carroll | 29033 | 2233 | 44 | 0 | 39.42762566 | -93.50626255 | 2022-05-19 04:20:54 | Carroll, Missouri, US | |
1185197 | 1185197 | 2022-05-18 | US | Arizona | Greenlee | 4011 | 2233 | 33 | 0 | 33.21498827 | -109.2405279 | 2022-05-19 04:20:54 | Greenlee, Arizona, US | |
3584527 | 3584527 | 2022-05-17 | US | Missouri | Carroll | 29033 | 2233 | 44 | 0 | 39.42762566 | -93.50626255 | 2022-05-18 04:20:50 | Carroll, Missouri, US | |
1505484 | 1505484 | 2022-05-16 | US | Missouri | Carroll | 29033 | 2233 | 44 | 0 | 39.42762566 | -93.50626255 | 2022-05-17 04:20:59 | Carroll, Missouri, US | |
2085843 | 2085843 | 2022-05-15 | US | Missouri | Carroll | 29033 | 2233 | 44 | 0 | 39.42762566 | -93.50626255 | 2022-05-16 04:20:47 | Carroll, Missouri, US | |
3356553 | 3356553 | 2022-05-14 | US | Missouri | Carroll | 29033 | 2233 | 44 | 0 | 39.42762566 | -93.50626255 | 2022-05-15 04:20:53 | Carroll, Missouri, US | |
660198 | 660198 | 2022-05-13 | US | Missouri | Carroll | 29033 | 2233 | 44 | 0 | 39.42762566 | -93.50626255 | 2022-05-14 04:20:48 | Carroll, Missouri, US | |
3023180 | 3023180 | 2022-03-23 | US | Georgia | Wilkes | 13317 | 2233 | 49 | 0 | 33.78290391 | -82.74286107 | 2022-03-24 04:20:43 | Wilkes, Georgia, US | |
26194 | 26194 | 2022-03-20 | US | Mississippi | Choctaw | 28019 | 2233 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-03-21 04:20:50 | Choctaw, Mississippi, US | |
1658204 | 1658204 | 2022-03-19 | US | Mississippi | Choctaw | 28019 | 2233 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-03-20 04:20:45 | Choctaw, Mississippi, US | |
337730 | 337730 | 2022-03-18 | US | Mississippi | Choctaw | 28019 | 2233 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-03-19 04:20:47 | Choctaw, Mississippi, US | |
696183 | 696183 | 2022-03-17 | US | Mississippi | Choctaw | 28019 | 2233 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-03-18 04:20:55 | Choctaw, Mississippi, US | |
2321126 | 2321126 | 2022-03-16 | US | Mississippi | Choctaw | 28019 | 2233 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-03-17 04:20:56 | Choctaw, Mississippi, US | |
2320238 | 2320238 | 2022-03-16 | US | Georgia | Wilkes | 13317 | 2233 | 49 | 0 | 33.78290391 | -82.74286107 | 2022-03-17 04:20:56 | Wilkes, Georgia, US | |
263326 | 263326 | 2022-03-15 | US | Mississippi | Choctaw | 28019 | 2233 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-03-16 04:20:50 | Choctaw, Mississippi, US | |
262438 | 262438 | 2022-03-15 | US | Georgia | Wilkes | 13317 | 2233 | 49 | 0 | 33.78290391 | -82.74286107 | 2022-03-16 04:20:50 | Wilkes, Georgia, US | |
2265685 | 2265685 | 2022-03-14 | US | Mississippi | Choctaw | 28019 | 2233 | 33 | 0 | 33.34598242 | -89.24809382 | 2022-03-15 04:20:47 | Choctaw, Mississippi, US | |
3631479 | 3631479 | 2022-03-13 | US | West Virginia | Webster | 54101 | 2233 | 29 | 0 | 38.49370949 | -80.4202023 | 2022-03-14 04:20:46 | Webster, West Virginia, US | |
954387 | 954387 | 2022-03-12 | US | West Virginia | Webster | 54101 | 2233 | 29 | 0 | 38.49370949 | -80.4202023 | 2022-03-13 04:20:49 | Webster, West Virginia, US | |
359848 | 359848 | 2022-03-11 | US | West Virginia | Webster | 54101 | 2233 | 29 | 0 | 38.49370949 | -80.4202023 | 2022-03-12 04:20:50 | Webster, West Virginia, US | |
2668775 | 2668775 | 2022-03-04 | US | Tennessee | Moore | 47127 | 2233 | 39 | 0 | 35.27724699 | -86.36230578 | 2022-03-05 04:21:10 | Moore, Tennessee, US | |
2526762 | 2526762 | 2022-03-02 | US | Kentucky | Elliott | 21063 | 2233 | 16 | 0 | 38.11624059 | -83.09771563 | 2022-03-03 04:21:01 | Elliott, Kentucky, US | |
3912849 | 3912849 | 2022-02-20 | US | Georgia | Johnson | 13167 | 2233 | 70 | 0 | 32.70211082 | -82.66166794 | 2022-02-21 04:21:05 | Johnson, Georgia, US | |
3876407 | 3876407 | 2022-02-19 | US | Georgia | Johnson | 13167 | 2233 | 70 | 0 | 32.70211082 | -82.66166794 | 2022-02-20 04:21:00 | Johnson, Georgia, US | |
3856663 | 3856663 | 2022-02-18 | US | Georgia | Johnson | 13167 | 2233 | 70 | 0 | 32.70211082 | -82.66166794 | 2022-02-19 04:21:11 | Johnson, Georgia, US | |
2642714 | 2642714 | 2022-02-14 | US | Idaho | Washington | 16087 | 2233 | 54 | 0 | 44.45275475 | -116.78476880000001 | 2022-02-15 04:21:09 | Washington, Idaho, US | |
1465873 | 1465873 | 2022-02-10 | US | Mississippi | Benton | 28009 | 2233 | 46 | 0 | 34.81681228 | -89.18945516 | 2022-02-11 04:21:09 | Benton, Mississippi, US | |
2016328 | 2016328 | 2022-02-06 | US | Wyoming | Washakie | 56043 | 2233 | 41 | 0 | 43.90451606 | -107.68018700000002 | 2022-02-07 04:21:05 | Washakie, Wyoming, US | |
2016098 | 2016098 | 2022-02-06 | US | Virginia | Poquoson | 51735 | 2233 | 26 | 0 | 37.14259351 | -76.35798148 | 2022-02-07 04:21:05 | Poquoson, Virginia, US | |
1297657 | 1297657 | 2022-02-05 | US | Wyoming | Washakie | 56043 | 2233 | 41 | 0 | 43.90451606 | -107.68018700000002 | 2022-02-06 04:21:00 | Washakie, Wyoming, US | |
1297427 | 1297427 | 2022-02-05 | US | Virginia | Poquoson | 51735 | 2233 | 26 | 0 | 37.14259351 | -76.35798148 | 2022-02-06 04:21:00 | Poquoson, Virginia, 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]);