johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
458 rows where confirmed = 1378 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3526816 | 3526816 | 2022-11-24 | US | Virginia | King and Queen | 51097 | 1378 | 14 | 0 | 37.71044922 | -76.88689628 | 2022-11-25 04:21:06 | King and Queen, Virginia, US | |
3315599 | 3315599 | 2022-11-23 | US | Virginia | King and Queen | 51097 | 1378 | 14 | 0 | 37.71044922 | -76.88689628 | 2022-11-24 04:21:09 | King and Queen, Virginia, US | |
1623640 | 1623640 | 2022-11-22 | US | Virginia | King and Queen | 51097 | 1378 | 14 | 0 | 37.71044922 | -76.88689628 | 2022-11-23 04:21:06 | King and Queen, Virginia, US | |
3463528 | 3463528 | 2022-11-21 | US | Virginia | King and Queen | 51097 | 1378 | 14 | 0 | 37.71044922 | -76.88689628 | 2022-11-22 04:20:47 | King and Queen, Virginia, US | |
2531406 | 2531406 | 2022-10-06 | US | Montana | Pondera | 30073 | 1378 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-10-07 04:23:08 | Pondera, Montana, US | |
1812800 | 1812800 | 2022-10-05 | US | Montana | Pondera | 30073 | 1378 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-10-06 04:21:22 | Pondera, Montana, US | |
132774 | 132774 | 2022-10-04 | US | Montana | Pondera | 30073 | 1378 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-10-05 04:23:06 | Pondera, Montana, US | |
2687721 | 2687721 | 2022-10-03 | US | Montana | Pondera | 30073 | 1378 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-10-04 04:22:55 | Pondera, Montana, US | |
2261788 | 2261788 | 2022-10-02 | US | Montana | Pondera | 30073 | 1378 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-10-03 04:23:11 | Pondera, Montana, US | |
2997314 | 2997314 | 2022-10-01 | US | Montana | Pondera | 30073 | 1378 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-10-02 04:21:23 | Pondera, Montana, US | |
855640 | 855640 | 2022-09-30 | US | Montana | Pondera | 30073 | 1378 | 9 | 0 | 48.22773388 | -112.2252703 | 2022-10-01 04:23:01 | Pondera, Montana, US | |
3544146 | 3544146 | 2022-08-08 | US | Colorado | Saguache | 8109 | 1378 | 12 | 0 | 38.08054629 | -106.282466 | 2022-08-09 04:20:34 | Saguache, Colorado, US | |
2011905 | 2011905 | 2022-08-04 | US | Texas | Sabine | 48403 | 1378 | 88 | 0 | 31.34318809 | -93.85440451 | 2022-08-05 04:20:52 | Sabine, Texas, US | |
1101182 | 1101182 | 2022-08-03 | US | Texas | Crane | 48103 | 1378 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-08-04 04:20:58 | Crane, Texas, US | |
1408107 | 1408107 | 2022-08-02 | US | Texas | Crane | 48103 | 1378 | 24 | 0 | 31.43052248 | -102.5143314 | 2022-08-03 04:20:59 | Crane, Texas, US | |
1407929 | 1407929 | 2022-08-02 | US | South Dakota | Kingsbury | 46077 | 1378 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-08-03 04:20:59 | Kingsbury, South Dakota, US | |
3619967 | 3619967 | 2022-08-01 | US | South Dakota | Kingsbury | 46077 | 1378 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-08-02 04:20:53 | Kingsbury, South Dakota, US | |
3874447 | 3874447 | 2022-07-31 | US | South Dakota | Kingsbury | 46077 | 1378 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-08-01 04:21:03 | Kingsbury, South Dakota, US | |
677201 | 677201 | 2022-07-30 | US | South Dakota | Kingsbury | 46077 | 1378 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-07-31 04:21:02 | Kingsbury, South Dakota, US | |
1786400 | 1786400 | 2022-07-29 | US | South Dakota | Kingsbury | 46077 | 1378 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-07-30 04:20:42 | Kingsbury, South Dakota, US | |
1068763 | 1068763 | 2022-07-28 | US | South Dakota | Kingsbury | 46077 | 1378 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-07-29 04:20:45 | Kingsbury, South Dakota, US | |
1066925 | 1066925 | 2022-07-28 | US | Illinois | Scott | 17171 | 1378 | 13 | 0 | 39.6429169 | -90.47814431 | 2022-07-29 04:20:45 | Scott, Illinois, US | |
2338282 | 2338282 | 2022-07-27 | US | South Dakota | Kingsbury | 46077 | 1378 | 22 | 0 | 44.36956169 | -97.4913945 | 2022-07-28 04:20:56 | Kingsbury, South Dakota, US | |
2337960 | 2337960 | 2022-07-27 | US | Oklahoma | Jefferson | 40067 | 1378 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-07-28 04:20:56 | Jefferson, Oklahoma, US | |
1490499 | 1490499 | 2022-07-26 | US | South Dakota | Walworth | 46129 | 1378 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-07-27 04:21:04 | Walworth, South Dakota, US | |
1490150 | 1490150 | 2022-07-26 | US | Oklahoma | Jefferson | 40067 | 1378 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-07-27 04:21:04 | Jefferson, Oklahoma, US | |
2596945 | 2596945 | 2022-07-25 | US | South Dakota | Walworth | 46129 | 1378 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-07-26 04:20:58 | Walworth, South Dakota, US | |
2596596 | 2596596 | 2022-07-25 | US | Oklahoma | Jefferson | 40067 | 1378 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-07-26 04:20:58 | Jefferson, Oklahoma, US | |
899060 | 899060 | 2022-07-24 | US | South Dakota | Walworth | 46129 | 1378 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-07-25 04:20:51 | Walworth, South Dakota, US | |
898711 | 898711 | 2022-07-24 | US | Oklahoma | Jefferson | 40067 | 1378 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-07-25 04:20:51 | Jefferson, Oklahoma, US | |
94054 | 94054 | 2022-07-23 | US | South Dakota | Walworth | 46129 | 1378 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-07-24 04:20:47 | Walworth, South Dakota, US | |
93705 | 93705 | 2022-07-23 | US | Oklahoma | Jefferson | 40067 | 1378 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-07-24 04:20:47 | Jefferson, Oklahoma, US | |
903076 | 903076 | 2022-07-22 | US | South Dakota | Walworth | 46129 | 1378 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-07-23 04:20:53 | Walworth, South Dakota, US | |
902727 | 902727 | 2022-07-22 | US | Oklahoma | Jefferson | 40067 | 1378 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-07-23 04:20:53 | Jefferson, Oklahoma, US | |
673212 | 673212 | 2022-07-21 | US | South Dakota | Walworth | 46129 | 1378 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-07-22 04:21:15 | Walworth, South Dakota, US | |
672863 | 672863 | 2022-07-21 | US | Oklahoma | Jefferson | 40067 | 1378 | 26 | 0 | 34.11130184 | -97.83182974 | 2022-07-22 04:21:15 | Jefferson, Oklahoma, US | |
1611175 | 1611175 | 2022-07-20 | US | South Dakota | Walworth | 46129 | 1378 | 26 | 0 | 45.43019636 | -100.0307514 | 2022-07-21 04:21:10 | Walworth, South Dakota, US | |
630675 | 630675 | 2022-07-12 | US | Georgia | Calhoun | 13037 | 1378 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-07-13 04:20:58 | Calhoun, Georgia, US | |
1212319 | 1212319 | 2022-07-11 | US | Georgia | Calhoun | 13037 | 1378 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-07-12 04:20:51 | Calhoun, Georgia, US | |
2789801 | 2789801 | 2022-07-10 | US | Georgia | Calhoun | 13037 | 1378 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-07-11 04:20:46 | Calhoun, Georgia, US | |
145159 | 145159 | 2022-07-09 | US | Texas | McCulloch | 48307 | 1378 | 47 | 0 | 31.1925468 | -99.34682807 | 2022-07-10 04:20:54 | McCulloch, Texas, US | |
142754 | 142754 | 2022-07-09 | US | Georgia | Calhoun | 13037 | 1378 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-07-10 04:20:54 | Calhoun, Georgia, US | |
1417854 | 1417854 | 2022-07-08 | US | Georgia | Calhoun | 13037 | 1378 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-07-09 04:20:59 | Calhoun, Georgia, US | |
2741779 | 2741779 | 2022-07-07 | US | Georgia | Calhoun | 13037 | 1378 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-07-08 04:20:56 | Calhoun, Georgia, US | |
1200574 | 1200574 | 2022-07-06 | US | Georgia | Calhoun | 13037 | 1378 | 24 | 0 | 31.53169785 | -84.62725131 | 2022-07-07 04:20:55 | Calhoun, Georgia, US | |
941246 | 941246 | 2022-06-25 | US | North Dakota | Sioux | 38085 | 1378 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-06-26 04:21:02 | Sioux, North Dakota, US | |
3349066 | 3349066 | 2022-06-24 | US | North Dakota | Sioux | 38085 | 1378 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-06-25 04:20:57 | Sioux, North Dakota, US | |
1650807 | 1650807 | 2022-06-23 | US | North Dakota | Sioux | 38085 | 1378 | 19 | 0 | 46.11323337 | -101.0440149 | 2022-06-24 04:20:58 | Sioux, North Dakota, US | |
2190024 | 2190024 | 2022-06-22 | US | North Dakota | McHenry | 38049 | 1378 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-06-23 04:20:55 | McHenry, North Dakota, US | |
168455 | 168455 | 2022-06-21 | US | North Dakota | McHenry | 38049 | 1378 | 31 | 0 | 48.23104458 | -100.6324822 | 2022-06-22 04:20:54 | McHenry, North Dakota, US | |
3530653 | 3530653 | 2022-06-04 | US | Texas | Newton | 48351 | 1378 | 61 | 0 | 30.78548982 | -93.74408813 | 2022-06-05 04:20:55 | Newton, Texas, US | |
1571936 | 1571936 | 2022-05-03 | China | Jiangxi | 1378 | 1 | 0 | 27.614 | 115.7221 | 2022-05-04 04:20:59 | Jiangxi, China | |||
2843571 | 2843571 | 2022-04-30 | US | Puerto Rico | Ceiba | 72037 | 1378 | 0 | 0 | 18.251818 | -65.666416 | 2022-05-01 04:20:57 | Ceiba, Puerto Rico, US | |
1329144 | 1329144 | 2022-04-26 | US | South Dakota | Moody | 46101 | 1378 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-04-27 04:20:52 | Moody, South Dakota, US | |
1326044 | 1326044 | 2022-04-26 | China | Hunan | 1378 | 4 | 0 | 27.6104 | 111.7088 | 2022-04-27 04:20:52 | Hunan, China | |||
3725098 | 3725098 | 2022-04-25 | US | South Dakota | Moody | 46101 | 1378 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-04-26 04:20:51 | Moody, South Dakota, US | |
2031666 | 2031666 | 2022-04-24 | US | South Dakota | Moody | 46101 | 1378 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-04-25 04:20:56 | Moody, South Dakota, US | |
749241 | 749241 | 2022-04-23 | US | South Dakota | Moody | 46101 | 1378 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-04-24 04:20:56 | Moody, South Dakota, US | |
3439726 | 3439726 | 2022-04-22 | US | South Dakota | Moody | 46101 | 1378 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-04-23 04:20:50 | Moody, South Dakota, US | |
2895311 | 2895311 | 2022-04-21 | US | South Dakota | Moody | 46101 | 1378 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-04-22 04:20:45 | Moody, South Dakota, US | |
2310183 | 2310183 | 2022-04-20 | US | South Dakota | Moody | 46101 | 1378 | 28 | 0 | 44.02266214 | -96.67081159 | 2022-04-21 04:20:46 | Moody, South Dakota, US | |
1906444 | 1906444 | 2022-03-22 | US | Iowa | Van Buren | 19177 | 1378 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-03-23 04:20:48 | Van Buren, Iowa, US | |
3239575 | 3239575 | 2022-03-21 | US | Iowa | Van Buren | 19177 | 1378 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-03-22 04:20:54 | Van Buren, Iowa, US | |
25648 | 25648 | 2022-03-20 | US | Iowa | Van Buren | 19177 | 1378 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-03-21 04:20:50 | Van Buren, Iowa, US | |
1657658 | 1657658 | 2022-03-19 | US | Iowa | Van Buren | 19177 | 1378 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-03-20 04:20:45 | Van Buren, Iowa, US | |
337184 | 337184 | 2022-03-18 | US | Iowa | Van Buren | 19177 | 1378 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-03-19 04:20:47 | Van Buren, Iowa, US | |
695637 | 695637 | 2022-03-17 | US | Iowa | Van Buren | 19177 | 1378 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-03-18 04:20:55 | Van Buren, Iowa, US | |
2320580 | 2320580 | 2022-03-16 | US | Iowa | Van Buren | 19177 | 1378 | 27 | 0 | 40.75326764 | -91.95017958 | 2022-03-17 04:20:56 | Van Buren, Iowa, US | |
1865922 | 1865922 | 2022-03-10 | US | Alaska | Yukon-Koyukuk | 2290 | 1378 | 9 | 0 | 65.50815459 | -151.39073869999999 | 2022-03-11 04:20:50 | Yukon-Koyukuk, Alaska, US | |
2140617 | 2140617 | 2022-03-09 | US | Alaska | Yukon-Koyukuk | 2290 | 1378 | 9 | 0 | 65.50815459 | -151.39073869999999 | 2022-03-10 04:20:48 | Yukon-Koyukuk, Alaska, US | |
922592 | 922592 | 2022-03-08 | US | South Dakota | Tripp | 46123 | 1378 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-03-09 04:20:59 | Tripp, South Dakota, US | |
1550879 | 1550879 | 2022-03-07 | US | South Dakota | Tripp | 46123 | 1378 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-03-08 04:20:54 | Tripp, South Dakota, US | |
2202548 | 2202548 | 2022-03-06 | US | South Dakota | Tripp | 46123 | 1378 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-03-07 04:20:47 | Tripp, South Dakota, US | |
2095005 | 2095005 | 2022-03-05 | US | South Dakota | Tripp | 46123 | 1378 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-03-06 04:20:49 | Tripp, South Dakota, US | |
2668705 | 2668705 | 2022-03-04 | US | South Dakota | Tripp | 46123 | 1378 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-03-05 04:21:10 | Tripp, South Dakota, US | |
1647270 | 1647270 | 2022-03-03 | US | South Dakota | Tripp | 46123 | 1378 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-03-04 04:21:09 | Tripp, South Dakota, US | |
2528273 | 2528273 | 2022-03-02 | US | South Dakota | Tripp | 46123 | 1378 | 24 | 0 | 43.34459388 | -99.8854891 | 2022-03-03 04:21:01 | Tripp, South Dakota, US | |
1995567 | 1995567 | 2022-03-01 | US | South Dakota | Tripp | 46123 | 1378 | 23 | 0 | 43.34459388 | -99.8854891 | 2022-03-02 04:21:07 | Tripp, South Dakota, US | |
1514572 | 1514572 | 2022-02-24 | US | Texas | Lynn | 48305 | 1378 | 37 | 0 | 33.17657705 | -101.8162849 | 2022-02-25 04:21:11 | Lynn, Texas, US | |
1061289 | 1061289 | 2022-02-23 | US | Washington | Ferry | 53019 | 1378 | 27 | 0 | 48.471143100000006 | -118.5154041 | 2022-02-24 04:21:14 | Ferry, Washington, US | |
1061013 | 1061013 | 2022-02-23 | US | Texas | Lynn | 48305 | 1378 | 37 | 0 | 33.17657705 | -101.8162849 | 2022-02-24 04:21:14 | Lynn, Texas, US | |
2450212 | 2450212 | 2022-02-22 | US | Washington | Ferry | 53019 | 1378 | 27 | 0 | 48.471143100000006 | -118.5154041 | 2022-02-23 04:21:09 | Ferry, Washington, US | |
2449936 | 2449936 | 2022-02-22 | US | Texas | Lynn | 48305 | 1378 | 37 | 0 | 33.17657705 | -101.8162849 | 2022-02-23 04:21:09 | Lynn, Texas, US | |
3721625 | 3721625 | 2022-02-21 | US | Washington | Ferry | 53019 | 1378 | 27 | 0 | 48.471143100000006 | -118.5154041 | 2022-02-22 04:21:01 | Ferry, Washington, US | |
3721349 | 3721349 | 2022-02-21 | US | Texas | Lynn | 48305 | 1378 | 37 | 0 | 33.17657705 | -101.8162849 | 2022-02-22 04:21:01 | Lynn, Texas, US | |
3915459 | 3915459 | 2022-02-20 | US | Washington | Ferry | 53019 | 1378 | 27 | 0 | 48.471143100000006 | -118.5154041 | 2022-02-21 04:21:05 | Ferry, Washington, US | |
3915183 | 3915183 | 2022-02-20 | US | Texas | Lynn | 48305 | 1378 | 37 | 0 | 33.17657705 | -101.8162849 | 2022-02-21 04:21:05 | Lynn, Texas, US | |
3879017 | 3879017 | 2022-02-19 | US | Washington | Ferry | 53019 | 1378 | 27 | 0 | 48.471143100000006 | -118.5154041 | 2022-02-20 04:21:00 | Ferry, Washington, US | |
3878741 | 3878741 | 2022-02-19 | US | Texas | Lynn | 48305 | 1378 | 37 | 0 | 33.17657705 | -101.8162849 | 2022-02-20 04:21:00 | Lynn, Texas, US | |
3875361 | 3875361 | 2022-02-19 | China | Beijing | 1378 | 9 | 0 | 40.1824 | 116.4142 | 2022-02-20 04:21:00 | Beijing, China | |||
1365876 | 1365876 | 2022-02-08 | US | West Virginia | Wirt | 54105 | 1378 | 19 | 0 | 39.02775007 | -81.37473928 | 2022-02-09 04:21:04 | Wirt, West Virginia, US | |
1365206 | 1365206 | 2022-02-08 | US | South Dakota | Brule | 46015 | 1378 | 18 | 0 | 43.71756379 | -99.08118954 | 2022-02-09 04:21:04 | Brule, South Dakota, US | |
2475274 | 2475274 | 2022-02-03 | US | Kansas | Mitchell | 20123 | 1378 | 18 | 0 | 39.39331582 | -98.20906732 | 2022-02-04 04:21:10 | Mitchell, Kansas, US | |
460699 | 460699 | 2022-02-02 | US | Kansas | Mitchell | 20123 | 1378 | 18 | 0 | 39.39331582 | -98.20906732 | 2022-02-03 04:21:21 | Mitchell, Kansas, US | |
1283934 | 1283934 | 2022-01-05 | US | Missouri | Ozark | 29153 | 1378 | 47 | 0 | 36.64916339 | -92.44459066 | 2022-01-06 04:22:09 | Ozark, Missouri, US | |
1435826 | 1435826 | 2021-12-28 | US | Texas | Winkler | 48495 | 1378 | 32 | 0 | 31.85008651 | -103.04851629999999 | 2021-12-29 03:21:43 | Winkler, Texas, US | |
2907048 | 2907048 | 2021-12-19 | US | Virginia | Essex | 51057 | 1378 | 20 | 0 | 37.93357639 | -76.94230311 | 2021-12-20 04:21:43 | Essex, Virginia, US | |
1262121 | 1262121 | 2021-12-18 | US | Virginia | Essex | 51057 | 1378 | 20 | 0 | 37.93357639 | -76.94230311 | 2021-12-19 04:21:11 | Essex, Virginia, US | |
2402149 | 2402149 | 2021-12-17 | US | Virginia | Essex | 51057 | 1378 | 20 | 0 | 37.93357639 | -76.94230311 | 2021-12-18 02:22:20 | Essex, Virginia, US | |
1719687 | 1719687 | 2021-12-16 | US | Virginia | Essex | 51057 | 1378 | 20 | 0 | 37.93357639 | -76.94230311 | 2021-12-17 04:22:14 | Essex, 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]);