johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
224 rows where confirmed = 2836 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 12
- US 210
- China 2
- Russia 2
- United Kingdom 2
- Chile 1
- Costa Rica 1
- Greece 1
- Japan 1
- Malaysia 1
- Saint Kitts and Nevis 1
- Sweden 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
868591 | 868591 | 2022-12-11 | China | Hebei | 2836 | 7 | 0 | 37.8957 | 114.9042 | 2022-12-12 04:21:01 | Hebei, China | |||
3717574 | 3717574 | 2022-12-06 | US | Virginia | Richmond | 51159 | 2836 | 28 | 0 | 37.937575 | -76.72920628 | 2022-12-07 04:20:58 | Richmond, Virginia, US | |
1967978 | 1967978 | 2022-11-30 | US | Virginia | Richmond | 51159 | 2836 | 27 | 0 | 37.937575 | -76.72920628 | 2022-12-01 04:21:03 | Richmond, Virginia, US | |
2557807 | 2557807 | 2022-11-29 | US | Iowa | Louisa | 19115 | 2836 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-30 04:21:07 | Louisa, Iowa, US | |
1240881 | 1240881 | 2022-11-28 | US | Iowa | Louisa | 19115 | 2836 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-29 04:21:05 | Louisa, Iowa, US | |
3552869 | 3552869 | 2022-11-27 | US | Iowa | Louisa | 19115 | 2836 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-28 04:21:02 | Louisa, Iowa, US | |
2101349 | 2101349 | 2022-11-26 | US | Iowa | Louisa | 19115 | 2836 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-27 04:21:05 | Louisa, Iowa, US | |
488840 | 488840 | 2022-11-25 | US | Iowa | Louisa | 19115 | 2836 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-26 04:21:11 | Louisa, Iowa, US | |
3524669 | 3524669 | 2022-11-24 | US | Iowa | Louisa | 19115 | 2836 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-25 04:21:06 | Louisa, Iowa, US | |
3313452 | 3313452 | 2022-11-23 | US | Iowa | Louisa | 19115 | 2836 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-24 04:21:09 | Louisa, Iowa, US | |
1621593 | 1621593 | 2022-11-22 | US | Kansas | Marshall | 20117 | 2836 | 48 | 0 | 39.78359669 | -96.52278974 | 2022-11-23 04:21:06 | Marshall, Kansas, US | |
3461481 | 3461481 | 2022-11-21 | US | Kansas | Marshall | 20117 | 2836 | 48 | 0 | 39.78359669 | -96.52278974 | 2022-11-22 04:20:47 | Marshall, Kansas, US | |
1641666 | 1641666 | 2022-11-20 | US | Kansas | Marshall | 20117 | 2836 | 48 | 0 | 39.78359669 | -96.52278974 | 2022-11-21 04:21:05 | Marshall, Kansas, US | |
2065223 | 2065223 | 2022-11-19 | US | Kansas | Marshall | 20117 | 2836 | 48 | 0 | 39.78359669 | -96.52278974 | 2022-11-20 04:21:08 | Marshall, Kansas, US | |
1756617 | 1756617 | 2022-11-18 | US | Kansas | Marshall | 20117 | 2836 | 48 | 0 | 39.78359669 | -96.52278974 | 2022-11-19 04:21:14 | Marshall, Kansas, US | |
3027610 | 3027610 | 2022-11-17 | US | Kansas | Marshall | 20117 | 2836 | 48 | 0 | 39.78359669 | -96.52278974 | 2022-11-18 04:21:15 | Marshall, Kansas, US | |
2487321 | 2487321 | 2022-11-16 | US | Kansas | Marshall | 20117 | 2836 | 48 | 0 | 39.78359669 | -96.52278974 | 2022-11-17 04:21:11 | Marshall, Kansas, US | |
482643 | 482643 | 2022-11-08 | US | Texas | Childress | 48075 | 2836 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-11-09 04:21:22 | Childress, Texas, US | |
2441793 | 2441793 | 2022-11-07 | US | Texas | Childress | 48075 | 2836 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-11-08 04:21:21 | Childress, Texas, US | |
1052891 | 1052891 | 2022-11-06 | US | Texas | Childress | 48075 | 2836 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-11-07 04:21:26 | Childress, Texas, US | |
620915 | 620915 | 2022-11-05 | US | Texas | Childress | 48075 | 2836 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-11-06 04:21:24 | Childress, Texas, US | |
1025419 | 1025419 | 2022-11-04 | US | Texas | Childress | 48075 | 2836 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-11-05 04:21:52 | Childress, Texas, US | |
422522 | 422522 | 2022-09-18 | US | Texas | Morris | 48343 | 2836 | 75 | 0 | 33.11304005 | -94.73255695 | 2022-09-19 04:21:49 | Morris, Texas, US | |
3376546 | 3376546 | 2022-09-17 | US | Texas | Morris | 48343 | 2836 | 75 | 0 | 33.11304005 | -94.73255695 | 2022-09-18 04:22:50 | Morris, Texas, US | |
2358654 | 2358654 | 2022-09-16 | US | Texas | Morris | 48343 | 2836 | 75 | 0 | 33.11304005 | -94.73255695 | 2022-09-17 04:20:19 | Morris, Texas, US | |
2098298 | 2098298 | 2022-08-27 | US | New Jersey | Unassigned | 90034 | 2836 | 0 | 0 | 41.13891592 | 0.0 | 2022-08-28 04:21:02 | Unassigned, New Jersey, US | |
1251408 | 1251408 | 2022-08-23 | US | Colorado | Prowers | 8099 | 2836 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-08-24 04:20:46 | Prowers, Colorado, US | |
1162126 | 1162126 | 2022-08-18 | US | Idaho | Teton | 16081 | 2836 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-08-19 04:20:54 | Teton, Idaho, US | |
3951450 | 3951450 | 2022-08-17 | US | Idaho | Teton | 16081 | 2836 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-08-18 04:21:11 | Teton, Idaho, US | |
991952 | 991952 | 2022-08-16 | US | Idaho | Teton | 16081 | 2836 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-08-17 04:20:59 | Teton, Idaho, US | |
2494991 | 2494991 | 2022-08-15 | US | Idaho | Teton | 16081 | 2836 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-08-16 04:20:58 | Teton, Idaho, US | |
1488588 | 1488588 | 2022-07-26 | US | Illinois | Jasper | 17079 | 2836 | 31 | 0 | 39.01054275 | -88.15437049 | 2022-07-27 04:21:04 | Jasper, Illinois, US | |
3212696 | 3212696 | 2022-07-18 | US | North Dakota | McLean | 38055 | 2836 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-07-19 04:20:58 | McLean, North Dakota, US | |
3729296 | 3729296 | 2022-06-07 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-06-08 04:20:55 | Eastland, Texas, US | |
3890698 | 3890698 | 2022-06-06 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-06-07 04:21:08 | Eastland, Texas, US | |
3510467 | 3510467 | 2022-06-05 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-06-06 04:20:57 | Eastland, Texas, US | |
3530544 | 3530544 | 2022-06-04 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-06-05 04:20:55 | Eastland, Texas, US | |
3136630 | 3136630 | 2022-06-03 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-06-04 04:20:58 | Eastland, Texas, US | |
3581705 | 3581705 | 2022-06-02 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-06-03 04:20:58 | Eastland, Texas, US | |
973998 | 973998 | 2022-06-01 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-06-02 05:20:39 | Eastland, Texas, US | |
232305 | 232305 | 2022-05-31 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-06-01 04:20:55 | Eastland, Texas, US | |
3189070 | 3189070 | 2022-05-30 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-05-31 04:20:51 | Eastland, Texas, US | |
3201219 | 3201219 | 2022-05-29 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-05-30 04:20:50 | Eastland, Texas, US | |
2728097 | 2728097 | 2022-05-28 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-05-29 04:20:53 | Eastland, Texas, US | |
1317278 | 1317278 | 2022-05-27 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-05-28 04:21:07 | Eastland, Texas, US | |
1853070 | 1853070 | 2022-05-26 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-05-27 04:20:56 | Eastland, Texas, US | |
2050946 | 2050946 | 2022-05-25 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-05-26 04:20:50 | Eastland, Texas, US | |
624957 | 624957 | 2022-05-22 | US | Texas | Eastland | 48133 | 2836 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-05-26 04:20:50 | Eastland, Texas, US | |
2895780 | 2895780 | 2022-04-21 | US | Virginia | Lexington | 51678 | 2836 | 40 | 0 | 37.78258621 | -79.44262866 | 2022-04-22 04:20:45 | Lexington, Virginia, US | |
2748673 | 2748673 | 2022-04-04 | China | Fujian | 2836 | 1 | 0 | 26.0789 | 117.9874 | 2022-04-05 04:20:48 | Fujian, China | |||
2481014 | 2481014 | 2022-03-30 | US | Texas | Camp | 48063 | 2836 | 74 | 0 | 32.97195142 | -94.97790104 | 2022-03-31 04:20:56 | Camp, Texas, US | |
1438456 | 1438456 | 2022-03-28 | US | Missouri | Barton | 29011 | 2836 | 51 | 0 | 37.50207671 | -94.34757022 | 2022-03-29 04:20:46 | Barton, Missouri, US | |
878137 | 878137 | 2022-03-27 | US | Missouri | Barton | 29011 | 2836 | 51 | 0 | 37.50207671 | -94.34757022 | 2022-03-28 04:20:33 | Barton, Missouri, US | |
2165420 | 2165420 | 2022-03-26 | US | Missouri | Barton | 29011 | 2836 | 51 | 0 | 37.50207671 | -94.34757022 | 2022-03-27 04:20:47 | Barton, Missouri, US | |
1722356 | 1722356 | 2022-03-25 | US | Missouri | Barton | 29011 | 2836 | 51 | 0 | 37.50207671 | -94.34757022 | 2022-03-26 04:20:23 | Barton, Missouri, US | |
2643450 | 2643450 | 2022-02-14 | US | Minnesota | Aitkin | 27001 | 2836 | 59 | 0 | 46.60962049 | -93.41168259999999 | 2022-02-15 04:21:09 | Aitkin, Minnesota, US | |
3301089 | 3301089 | 2022-01-30 | US | Georgia | Telfair | 13271 | 2836 | 76 | 0 | 31.92829517 | -82.93491155 | 2022-01-31 04:21:09 | Telfair, Georgia, US | |
3062880 | 3062880 | 2022-01-29 | US | Georgia | Telfair | 13271 | 2836 | 76 | 0 | 31.92829517 | -82.93491155 | 2022-01-30 04:21:26 | Telfair, Georgia, US | |
3810814 | 3810814 | 2022-01-28 | US | Georgia | Telfair | 13271 | 2836 | 76 | 0 | 31.92829517 | -82.93491155 | 2022-01-29 04:21:10 | Telfair, Georgia, US | |
2053382 | 2053382 | 2022-01-25 | US | Louisiana | Claiborne | 22027 | 2836 | 67 | 0 | 32.82308512 | -92.99526883 | 2022-01-26 04:21:07 | Claiborne, Louisiana, US | |
1475692 | 1475692 | 2022-01-17 | US | Wisconsin | Price | 55099 | 2836 | 24 | 0 | 45.68051754 | -90.36098879999999 | 2022-01-18 04:21:04 | Price, Wisconsin, US | |
3614515 | 3614515 | 2022-01-12 | US | Kentucky | Monroe | 21171 | 2836 | 69 | 0 | 36.71225341 | -85.71596443 | 2022-01-13 08:00:09 | Monroe, Kentucky, US | |
1695679 | 1695679 | 2022-01-10 | US | Virginia | King William | 51101 | 2836 | 27 | 0 | 37.70965316 | -77.09384941 | 2022-01-11 04:22:01 | King William, Virginia, US | |
128499 | 128499 | 2022-01-09 | US | Minnesota | Sibley | 27143 | 2836 | 21 | 0 | 44.5796592 | -94.23164924 | 2022-01-10 04:22:07 | Sibley, Minnesota, US | |
1217334 | 1217334 | 2022-01-08 | US | Minnesota | Sibley | 27143 | 2836 | 21 | 0 | 44.5796592 | -94.23164924 | 2022-01-09 04:21:46 | Sibley, Minnesota, US | |
1391427 | 1391427 | 2022-01-07 | US | Minnesota | Sibley | 27143 | 2836 | 21 | 0 | 44.5796592 | -94.23164924 | 2022-01-08 04:21:53 | Sibley, Minnesota, US | |
3605341 | 3605341 | 2021-12-25 | Saint Kitts and Nevis | 2836 | 28 | 0 | 17.357822 | -62.782998 | 2021-12-26 04:21:50 | Saint Kitts and Nevis | ||||
3829076 | 3829076 | 2021-12-21 | US | Colorado | Chaffee | 8015 | 2836 | 38 | 0 | 38.74745778 | -106.19265729999998 | 2021-12-22 04:21:54 | Chaffee, Colorado, US | |
2091104 | 2091104 | 2021-12-14 | US | Texas | Jackson | 48239 | 2836 | 52 | 0 | 28.95472367 | -96.57749563 | 2021-12-15 03:22:16 | Jackson, Texas, US | |
785521 | 785521 | 2021-12-13 | US | Texas | Jackson | 48239 | 2836 | 52 | 0 | 28.95472367 | -96.57749563 | 2021-12-14 04:22:38 | Jackson, Texas, US | |
1663556 | 1663556 | 2021-12-12 | US | Texas | Jackson | 48239 | 2836 | 52 | 0 | 28.95472367 | -96.57749563 | 2021-12-13 04:22:02 | Jackson, Texas, US | |
1667572 | 1667572 | 2021-12-11 | US | Texas | Jackson | 48239 | 2836 | 52 | 0 | 28.95472367 | -96.57749563 | 2021-12-12 04:22:12 | Jackson, Texas, US | |
1079860 | 1079860 | 2021-12-09 | US | Missouri | Moniteau | 29135 | 2836 | 46 | 0 | 38.63571781 | -92.57976951 | 2021-12-10 04:22:28 | Moniteau, Missouri, US | |
1741687 | 1741687 | 2021-12-05 | US | Indiana | Vermillion | 18165 | 2836 | 58 | 0 | 39.8523352 | -87.46160542 | 2021-12-06 04:22:34 | Vermillion, Indiana, US | |
139119 | 139119 | 2021-12-04 | US | Indiana | Vermillion | 18165 | 2836 | 58 | 0 | 39.8523352 | -87.46160542 | 2021-12-05 04:22:25 | Vermillion, Indiana, US | |
2196772 | 2196772 | 2021-12-03 | US | Indiana | Vermillion | 18165 | 2836 | 58 | 0 | 39.8523352 | -87.46160542 | 2021-12-04 04:22:18 | Vermillion, Indiana, US | |
150181 | 150181 | 2021-11-29 | Russia | Chukotka Autonomous Okrug | 2836 | 25 | 0 | 66.0006475 | 169.4900869 | 2021-11-30 04:22:53 | Chukotka Autonomous Okrug, Russia | |||
3071353 | 3071353 | 2021-11-23 | US | Kansas | Neosho | 20133 | 2836 | 53 | 0 | 37.55862897 | -95.30670046 | 2021-11-24 04:22:14 | Neosho, Kansas, US | |
3750451 | 3750451 | 2021-11-22 | US | Kansas | Neosho | 20133 | 2836 | 53 | 0 | 37.55862897 | -95.30670046 | 2021-11-23 04:22:39 | Neosho, Kansas, US | |
3289514 | 3289514 | 2021-11-18 | US | Colorado | Alamosa | 8003 | 2836 | 50 | 0 | 37.57250606 | -105.7885451 | 2021-11-19 04:21:40 | Alamosa, Colorado, US | |
3344514 | 3344514 | 2021-11-16 | US | Missouri | Cooper | 29053 | 2836 | 34 | 0 | 38.844478 | -92.80896081 | 2021-11-17 04:21:48 | Cooper, Missouri, US | |
3344339 | 3344339 | 2021-11-16 | US | Minnesota | Fillmore | 27045 | 2836 | 14 | 0 | 43.67394126 | -92.08980382 | 2021-11-17 04:21:48 | Fillmore, Minnesota, US | |
278567 | 278567 | 2021-11-03 | US | North Carolina | Yancey | 37199 | 2836 | 32 | 0 | 35.90079156 | -82.31237181 | 2021-11-04 04:22:20 | Yancey, North Carolina, US | |
3512582 | 3512582 | 2021-11-01 | US | Iowa | Clay | 19041 | 2836 | 35 | 0 | 43.08247182 | -95.15096481 | 2021-11-02 04:22:03 | Clay, Iowa, US | |
289173 | 289173 | 2021-10-31 | US | Iowa | Clay | 19041 | 2836 | 35 | 0 | 43.08247182 | -95.15096481 | 2021-11-01 04:22:01 | Clay, Iowa, US | |
289036 | 289036 | 2021-10-31 | US | Illinois | Richland | 17159 | 2836 | 57 | 0 | 38.71240969 | -88.08475366 | 2021-11-01 04:22:01 | Richland, Illinois, US | |
2722179 | 2722179 | 2021-10-30 | US | Iowa | Clay | 19041 | 2836 | 35 | 0 | 43.08247182 | -95.15096481 | 2021-10-31 04:22:08 | Clay, Iowa, US | |
2722042 | 2722042 | 2021-10-30 | US | Illinois | Richland | 17159 | 2836 | 57 | 0 | 38.71240969 | -88.08475366 | 2021-10-31 04:22:08 | Richland, Illinois, US | |
568281 | 568281 | 2021-10-29 | US | Iowa | Clay | 19041 | 2836 | 35 | 0 | 43.08247182 | -95.15096481 | 2021-10-30 04:22:03 | Clay, Iowa, US | |
568144 | 568144 | 2021-10-29 | US | Illinois | Richland | 17159 | 2836 | 57 | 0 | 38.71240969 | -88.08475366 | 2021-10-30 04:22:03 | Richland, Illinois, US | |
5523 | 5523 | 2021-10-28 | US | Iowa | Clay | 19041 | 2836 | 35 | 0 | 43.08247182 | -95.15096481 | 2021-10-29 04:22:03 | Clay, Iowa, US | |
535913 | 535913 | 2021-10-27 | US | Iowa | Clay | 19041 | 2836 | 35 | 0 | 43.08247182 | -95.15096481 | 2021-10-28 04:22:08 | Clay, Iowa, US | |
1910935 | 1910935 | 2021-10-17 | US | Minnesota | Hubbard | 27057 | 2836 | 44 | 0 | 47.10778564 | -94.91693868 | 2021-10-18 04:21:10 | Hubbard, Minnesota, US | |
1910888 | 1910888 | 2021-10-17 | US | Michigan | Osceola | 26133 | 2836 | 34 | 0 | 43.98992088 | -85.32566756 | 2021-10-18 04:21:10 | Osceola, Michigan, US | |
936524 | 936524 | 2021-10-16 | US | Minnesota | Hubbard | 27057 | 2836 | 44 | 0 | 47.10778564 | -94.91693868 | 2021-10-17 04:21:29 | Hubbard, Minnesota, US | |
936477 | 936477 | 2021-10-16 | US | Michigan | Osceola | 26133 | 2836 | 34 | 0 | 43.98992088 | -85.32566756 | 2021-10-17 04:21:29 | Osceola, Michigan, US | |
2945079 | 2945079 | 2021-10-15 | US | Minnesota | Hubbard | 27057 | 2836 | 44 | 0 | 47.10778564 | -94.91693868 | 2021-10-16 04:21:15 | Hubbard, Minnesota, US | |
2945032 | 2945032 | 2021-10-15 | US | Michigan | Osceola | 26133 | 2836 | 34 | 0 | 43.98992088 | -85.32566756 | 2021-10-16 04:21:15 | Osceola, Michigan, US | |
2960954 | 2960954 | 2021-10-08 | US | Maryland | Garrett | 24023 | 2836 | 74 | 0 | 39.52786077 | -79.27355126 | 2021-10-09 04:21:34 | Garrett, Maryland, US | |
3835892 | 3835892 | 2021-10-05 | US | Virginia | Scott | 51169 | 2836 | 72 | 0 | 36.71466456 | -82.60171704 | 2021-10-06 04:21:33 | Scott, 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]);