johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
245 rows where confirmed = 3210 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 235
- Sweden 3
- China 1
- Germany 1
- Liechtenstein 1
- Mali 1
- Netherlands 1
- Russia 1
- Ukraine 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3598919 | 3598919 | 2022-11-14 | US | Missouri | Barton | 29011 | 3210 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-11-15 04:21:16 | Barton, Missouri, US | |
313777 | 313777 | 2022-11-13 | US | Missouri | Barton | 29011 | 3210 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-11-14 04:21:09 | Barton, Missouri, US | |
64938 | 64938 | 2022-11-12 | US | Missouri | Barton | 29011 | 3210 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-11-13 04:21:14 | Barton, Missouri, US | |
2929100 | 2929100 | 2022-11-11 | US | Missouri | Barton | 29011 | 3210 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-11-12 04:20:41 | Barton, Missouri, US | |
2507936 | 2507936 | 2022-11-10 | US | Missouri | Barton | 29011 | 3210 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-11-11 04:21:22 | Barton, Missouri, US | |
2434485 | 2434485 | 2022-11-09 | US | Wisconsin | Forest | 55041 | 3210 | 52 | 0 | 45.66678019 | -88.77084892 | 2022-11-10 04:21:16 | Forest, Wisconsin, US | |
2432811 | 2432811 | 2022-11-09 | US | Missouri | Barton | 29011 | 3210 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-11-10 04:21:16 | Barton, Missouri, US | |
481467 | 481467 | 2022-11-08 | US | Missouri | Barton | 29011 | 3210 | 55 | 0 | 37.50207671 | -94.34757022 | 2022-11-09 04:21:22 | Barton, Missouri, US | |
2395303 | 2395303 | 2022-09-12 | US | Arkansas | Lee | 5077 | 3210 | 62 | 0 | 34.78498904 | -90.78383866 | 2022-09-13 04:20:57 | Lee, Arkansas, US | |
2325982 | 2325982 | 2022-08-24 | US | Oregon | Morrow | 41049 | 3210 | 37 | 0 | 45.41846568 | -119.584546 | 2022-08-25 04:21:13 | Morrow, Oregon, US | |
2405875 | 2405875 | 2022-08-21 | US | Texas | Callahan | 48059 | 3210 | 73 | 0 | 32.29760619 | -99.37326312 | 2022-08-22 04:20:38 | Callahan, Texas, US | |
3800953 | 3800953 | 2022-08-20 | US | Texas | Callahan | 48059 | 3210 | 73 | 0 | 32.29760619 | -99.37326312 | 2022-08-21 04:20:44 | Callahan, Texas, US | |
2366539 | 2366539 | 2022-08-19 | US | Texas | Callahan | 48059 | 3210 | 73 | 0 | 32.29760619 | -99.37326312 | 2022-08-20 04:21:01 | Callahan, Texas, US | |
993282 | 993282 | 2022-08-16 | US | North Carolina | Alleghany | 37005 | 3210 | 18 | 0 | 36.49360862 | -81.12857041 | 2022-08-17 04:20:59 | Alleghany, North Carolina, US | |
991877 | 991877 | 2022-08-16 | US | Georgia | Telfair | 13271 | 3210 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-08-17 04:20:59 | Telfair, Georgia, US | |
2496321 | 2496321 | 2022-08-15 | US | North Carolina | Alleghany | 37005 | 3210 | 18 | 0 | 36.49360862 | -81.12857041 | 2022-08-16 04:20:58 | Alleghany, North Carolina, US | |
2494916 | 2494916 | 2022-08-15 | US | Georgia | Telfair | 13271 | 3210 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-08-16 04:20:58 | Telfair, Georgia, US | |
3649871 | 3649871 | 2022-08-14 | US | North Carolina | Alleghany | 37005 | 3210 | 18 | 0 | 36.49360862 | -81.12857041 | 2022-08-15 04:20:59 | Alleghany, North Carolina, US | |
3648466 | 3648466 | 2022-08-14 | US | Georgia | Telfair | 13271 | 3210 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-08-15 04:20:59 | Telfair, Georgia, US | |
1970877 | 1970877 | 2022-08-13 | US | North Carolina | Alleghany | 37005 | 3210 | 18 | 0 | 36.49360862 | -81.12857041 | 2022-08-14 04:20:55 | Alleghany, North Carolina, US | |
1969472 | 1969472 | 2022-08-13 | US | Georgia | Telfair | 13271 | 3210 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-08-14 04:20:55 | Telfair, Georgia, US | |
2890686 | 2890686 | 2022-08-12 | US | North Carolina | Alleghany | 37005 | 3210 | 18 | 0 | 36.49360862 | -81.12857041 | 2022-08-13 04:20:52 | Alleghany, North Carolina, US | |
2889281 | 2889281 | 2022-08-12 | US | Georgia | Telfair | 13271 | 3210 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-08-13 04:20:52 | Telfair, Georgia, US | |
3910291 | 3910291 | 2022-08-11 | US | North Carolina | Alleghany | 37005 | 3210 | 18 | 0 | 36.49360862 | -81.12857041 | 2022-08-12 04:20:54 | Alleghany, North Carolina, US | |
3908886 | 3908886 | 2022-08-11 | US | Georgia | Telfair | 13271 | 3210 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-08-12 04:20:54 | Telfair, Georgia, US | |
1348608 | 1348608 | 2022-08-10 | US | North Carolina | Alleghany | 37005 | 3210 | 18 | 0 | 36.49360862 | -81.12857041 | 2022-08-11 04:20:49 | Alleghany, North Carolina, US | |
1347203 | 1347203 | 2022-08-10 | US | Georgia | Telfair | 13271 | 3210 | 87 | 0 | 31.92829517 | -82.93491155 | 2022-08-11 04:20:49 | Telfair, Georgia, US | |
1086678 | 1086678 | 2022-08-09 | US | Colorado | Archuleta | 8007 | 3210 | 17 | 0 | 37.19474156 | -107.0476867 | 2022-08-10 04:20:57 | Archuleta, Colorado, US | |
2594396 | 2594396 | 2022-07-25 | US | Alabama | Coosa | 1037 | 3210 | 59 | 0 | 32.93690146 | -86.24847739 | 2022-07-26 04:20:58 | Coosa, Alabama, US | |
3429613 | 3429613 | 2022-07-14 | US | Colorado | Park | 8093 | 3210 | 22 | 0 | 39.120926 | -105.7182065 | 2022-07-15 04:20:53 | Park, Colorado, US | |
2240470 | 2240470 | 2022-06-28 | US | Indiana | Blackford | 18009 | 3210 | 69 | 0 | 40.47388153 | -85.32499702 | 2022-06-29 04:20:59 | Blackford, Indiana, US | |
2148712 | 2148712 | 2022-06-27 | US | Indiana | Blackford | 18009 | 3210 | 69 | 0 | 40.47388153 | -85.32499702 | 2022-06-28 04:20:58 | Blackford, Indiana, US | |
3726782 | 3726782 | 2022-06-07 | US | California | Mono | 6051 | 3210 | 6 | 0 | 37.93899289 | -118.8872409 | 2022-06-08 04:20:55 | Mono, California, US | |
3509194 | 3509194 | 2022-06-05 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-06-06 04:20:57 | Greene, Mississippi, US | |
3529271 | 3529271 | 2022-06-04 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-06-05 04:20:55 | Greene, Mississippi, US | |
3135357 | 3135357 | 2022-06-03 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-06-04 04:20:58 | Greene, Mississippi, US | |
3580432 | 3580432 | 2022-06-02 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-06-03 04:20:58 | Greene, Mississippi, US | |
972725 | 972725 | 2022-06-01 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-06-02 05:20:39 | Greene, Mississippi, US | |
231032 | 231032 | 2022-05-31 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-06-01 04:20:55 | Greene, Mississippi, US | |
3187797 | 3187797 | 2022-05-30 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-05-31 04:20:51 | Greene, Mississippi, US | |
3199946 | 3199946 | 2022-05-29 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-05-30 04:20:50 | Greene, Mississippi, US | |
2726824 | 2726824 | 2022-05-28 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-05-29 04:20:53 | Greene, Mississippi, US | |
1316005 | 1316005 | 2022-05-27 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-05-28 04:21:07 | Greene, Mississippi, US | |
1851797 | 1851797 | 2022-05-26 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-05-27 04:20:56 | Greene, Mississippi, US | |
2049673 | 2049673 | 2022-05-25 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-05-26 04:20:50 | Greene, Mississippi, US | |
3001111 | 3001111 | 2022-05-24 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-05-25 04:20:56 | Greene, Mississippi, US | |
3594832 | 3594832 | 2022-05-23 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-05-24 04:20:57 | Greene, Mississippi, US | |
623684 | 623684 | 2022-05-22 | US | Mississippi | Greene | 28041 | 3210 | 59 | 0 | 31.21444233 | -88.63922281 | 2022-05-26 04:20:50 | Greene, Mississippi, US | |
2085330 | 2085330 | 2022-05-15 | US | Kentucky | Bath | 21011 | 3210 | 48 | 0 | 38.14735938 | -83.74588932 | 2022-05-16 04:20:47 | Bath, Kentucky, US | |
3356040 | 3356040 | 2022-05-14 | US | Kentucky | Bath | 21011 | 3210 | 48 | 0 | 38.14735938 | -83.74588932 | 2022-05-15 04:20:53 | Bath, Kentucky, US | |
659685 | 659685 | 2022-05-13 | US | Kentucky | Bath | 21011 | 3210 | 48 | 0 | 38.14735938 | -83.74588932 | 2022-05-14 04:20:48 | Bath, Kentucky, US | |
2534768 | 2534768 | 2022-05-12 | US | Kentucky | Bath | 21011 | 3210 | 48 | 0 | 38.14735938 | -83.74588932 | 2022-05-13 04:20:51 | Bath, Kentucky, US | |
3447344 | 3447344 | 2022-05-11 | US | Ohio | Noble | 39121 | 3210 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-05-12 04:20:54 | Noble, Ohio, US | |
3446214 | 3446214 | 2022-05-11 | US | Kentucky | Bath | 21011 | 3210 | 48 | 0 | 38.14735938 | -83.74588932 | 2022-05-12 04:20:54 | Bath, Kentucky, US | |
3537961 | 3537961 | 2022-05-10 | US | Ohio | Noble | 39121 | 3210 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-05-11 04:20:48 | Noble, Ohio, US | |
3536831 | 3536831 | 2022-05-10 | US | Kentucky | Bath | 21011 | 3210 | 48 | 0 | 38.14735938 | -83.74588932 | 2022-05-11 04:20:48 | Bath, Kentucky, US | |
224496 | 224496 | 2022-05-09 | US | Ohio | Noble | 39121 | 3210 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-05-10 04:20:50 | Noble, Ohio, US | |
223366 | 223366 | 2022-05-09 | US | Kentucky | Bath | 21011 | 3210 | 48 | 0 | 38.14735938 | -83.74588932 | 2022-05-10 04:20:50 | Bath, Kentucky, US | |
2333881 | 2333881 | 2022-05-08 | US | Ohio | Noble | 39121 | 3210 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-05-09 04:20:54 | Noble, Ohio, US | |
362843 | 362843 | 2022-05-07 | US | Ohio | Noble | 39121 | 3210 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-05-08 04:20:49 | Noble, Ohio, US | |
1400194 | 1400194 | 2022-05-06 | US | Ohio | Noble | 39121 | 3210 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-05-07 04:21:09 | Noble, Ohio, US | |
2600549 | 2600549 | 2022-05-05 | US | Ohio | Noble | 39121 | 3210 | 59 | 0 | 39.76818851 | -81.45937183 | 2022-05-06 04:21:00 | Noble, Ohio, US | |
1573751 | 1573751 | 2022-05-03 | US | Michigan | Arenac | 26011 | 3210 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-05-04 04:20:59 | Arenac, Michigan, US | |
465011 | 465011 | 2022-05-02 | US | Michigan | Arenac | 26011 | 3210 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-05-03 04:21:00 | Arenac, Michigan, US | |
3917650 | 3917650 | 2022-05-01 | US | Michigan | Arenac | 26011 | 3210 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-05-02 04:21:10 | Arenac, Michigan, US | |
2842454 | 2842454 | 2022-04-30 | US | Michigan | Arenac | 26011 | 3210 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-05-01 04:20:57 | Arenac, Michigan, US | |
1158767 | 1158767 | 2022-04-29 | US | Michigan | Arenac | 26011 | 3210 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-04-30 04:21:05 | Arenac, Michigan, US | |
1697949 | 1697949 | 2022-04-28 | US | Michigan | Arenac | 26011 | 3210 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-04-29 04:20:59 | Arenac, Michigan, US | |
3853432 | 3853432 | 2022-04-27 | US | Michigan | Arenac | 26011 | 3210 | 67 | 0 | 44.0636262 | -83.89277559 | 2022-04-28 04:20:47 | Arenac, Michigan, US | |
2031467 | 2031467 | 2022-04-24 | US | Pennsylvania | Potter | 42105 | 3210 | 92 | 0 | 41.74471626 | -77.89559864 | 2022-04-25 04:20:56 | Potter, Pennsylvania, US | |
749042 | 749042 | 2022-04-23 | US | Pennsylvania | Potter | 42105 | 3210 | 92 | 0 | 41.74471626 | -77.89559864 | 2022-04-24 04:20:56 | Potter, Pennsylvania, US | |
2254034 | 2254034 | 2022-04-19 | US | Oregon | Baker | 41001 | 3210 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-04-20 04:20:45 | Baker, Oregon, US | |
1848584 | 1848584 | 2022-04-18 | US | Oregon | Baker | 41001 | 3210 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-04-19 04:21:00 | Baker, Oregon, US | |
3419528 | 3419528 | 2022-04-17 | US | Oregon | Baker | 41001 | 3210 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-04-18 04:21:12 | Baker, Oregon, US | |
306477 | 306477 | 2022-04-16 | US | Oregon | Baker | 41001 | 3210 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-04-17 04:20:59 | Baker, Oregon, US | |
2672422 | 2672422 | 2022-04-15 | US | Oregon | Baker | 41001 | 3210 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-04-16 04:20:48 | Baker, Oregon, US | |
1226207 | 1226207 | 2022-04-14 | US | Oregon | Baker | 41001 | 3210 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-04-15 04:20:57 | Baker, Oregon, US | |
2445365 | 2445365 | 2022-04-13 | US | Oregon | Baker | 41001 | 3210 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-04-13 23:21:06 | Baker, Oregon, US | |
1951122 | 1951122 | 2022-04-12 | US | Oregon | Baker | 41001 | 3210 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-04-13 04:21:03 | Baker, Oregon, US | |
3208875 | 3208875 | 2022-04-11 | US | Oregon | Baker | 41001 | 3210 | 48 | 0 | 44.70915557 | -117.6749883 | 2022-04-12 04:20:49 | Baker, Oregon, US | |
159956 | 159956 | 2022-03-29 | US | Missouri | Osage | 29151 | 3210 | 44 | 0 | 38.46036182 | -91.8613635 | 2022-03-30 04:20:45 | Osage, Missouri, US | |
1438527 | 1438527 | 2022-03-28 | US | Missouri | Osage | 29151 | 3210 | 44 | 0 | 38.46036182 | -91.8613635 | 2022-03-29 04:20:46 | Osage, Missouri, US | |
878208 | 878208 | 2022-03-27 | US | Missouri | Osage | 29151 | 3210 | 44 | 0 | 38.46036182 | -91.8613635 | 2022-03-28 04:20:33 | Osage, Missouri, US | |
2165491 | 2165491 | 2022-03-26 | US | Missouri | Osage | 29151 | 3210 | 44 | 0 | 38.46036182 | -91.8613635 | 2022-03-27 04:20:47 | Osage, Missouri, US | |
1722427 | 1722427 | 2022-03-25 | US | Missouri | Osage | 29151 | 3210 | 44 | 0 | 38.46036182 | -91.8613635 | 2022-03-26 04:20:23 | Osage, Missouri, US | |
1470044 | 1470044 | 2022-03-24 | US | Missouri | Osage | 29151 | 3210 | 44 | 0 | 38.46036182 | -91.8613635 | 2022-03-25 04:20:46 | Osage, Missouri, US | |
1469813 | 1469813 | 2022-03-24 | US | Minnesota | Cottonwood | 27033 | 3210 | 41 | 0 | 44.00715262 | -95.18138802 | 2022-03-25 04:20:46 | Cottonwood, Minnesota, US | |
697347 | 697347 | 2022-03-17 | US | Tennessee | Jackson | 47087 | 3210 | 61 | 0 | 36.36380466 | -85.67239905 | 2022-03-18 04:20:55 | Jackson, Tennessee, US | |
2322290 | 2322290 | 2022-03-16 | US | Tennessee | Jackson | 47087 | 3210 | 61 | 0 | 36.36380466 | -85.67239905 | 2022-03-17 04:20:56 | Jackson, Tennessee, US | |
264490 | 264490 | 2022-03-15 | US | Tennessee | Jackson | 47087 | 3210 | 61 | 0 | 36.36380466 | -85.67239905 | 2022-03-16 04:20:50 | Jackson, Tennessee, US | |
1647140 | 1647140 | 2022-03-03 | US | Puerto Rico | San German | 72125 | 3210 | 0 | 0 | 18.111484 | -67.03858100000001 | 2022-03-04 04:21:09 | San German, Puerto Rico, US | |
2528790 | 2528790 | 2022-03-02 | US | Virginia | Westmoreland | 51193 | 3210 | 47 | 0 | 38.11021557 | -76.80213247 | 2022-03-03 04:21:01 | Westmoreland, Virginia, US | |
1514539 | 1514539 | 2022-02-24 | US | Texas | Jackson | 48239 | 3210 | 58 | 0 | 28.95472367 | -96.57749563 | 2022-02-25 04:21:11 | Jackson, Texas, US | |
1061137 | 1061137 | 2022-02-23 | US | Vermont | Lamoille | 50015 | 3210 | 15 | 0 | 44.60353043 | -72.64356694 | 2022-02-24 04:21:14 | Lamoille, Vermont, US | |
2448672 | 2448672 | 2022-02-22 | US | Missouri | Dent | 29065 | 3210 | 69 | 0 | 37.60663134 | -91.50790473 | 2022-02-23 04:21:09 | Dent, Missouri, US | |
3858331 | 3858331 | 2022-02-18 | US | Ohio | Morgan | 39115 | 3210 | 56 | 0 | 39.62081738 | -81.85308173 | 2022-02-19 04:21:11 | Morgan, Ohio, US | |
318671 | 318671 | 2022-02-12 | US | Puerto Rico | Lares | 72081 | 3210 | 0 | 0 | 18.269035000000002 | -66.867236 | 2022-02-13 04:21:00 | Lares, Puerto Rico, US | |
2476672 | 2476672 | 2022-02-03 | US | Puerto Rico | Aibonito | 72009 | 3210 | 0 | 0 | 18.131361 | -66.264131 | 2022-02-04 04:21:10 | Aibonito, Puerto Rico, US | |
1780325 | 1780325 | 2022-01-27 | US | Idaho | Gem | 16045 | 3210 | 73 | 0 | 44.06482372 | -116.398376 | 2022-01-28 04:21:09 | Gem, Idaho, US | |
1141294 | 1141294 | 2022-01-23 | US | Alabama | Lamar | 1075 | 3210 | 60 | 0 | 33.77995024 | -88.09668032 | 2022-01-24 04:21:12 | Lamar, Alabama, 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]);