johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
124 rows where confirmed = 6629 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
221344 | 221344 | 2022-12-26 | US | Virginia | King George | 51099 | 6629 | 52 | 0 | 38.26818502 | -77.15852768 | 2022-12-27 04:21:07 | King George, Virginia, US | |
308942 | 308942 | 2022-12-13 | US | Illinois | Union | 17181 | 6629 | 67 | 0 | 37.47119609 | -89.25548938 | 2022-12-14 04:21:04 | Union, Illinois, US | |
308688 | 308688 | 2022-12-13 | US | Georgia | Emanuel | 13107 | 6629 | 165 | 0 | 32.59221302 | -82.30239915 | 2022-12-14 04:21:04 | Emanuel, Georgia, US | |
1150820 | 1150820 | 2022-12-12 | US | Missouri | Audrain | 29007 | 6629 | 120 | 0 | 39.215877 | -91.84242683 | 2022-12-13 04:21:01 | Audrain, Missouri, US | |
1149749 | 1149749 | 2022-12-12 | US | Georgia | Emanuel | 13107 | 6629 | 165 | 0 | 32.59221302 | -82.30239915 | 2022-12-13 04:21:01 | Emanuel, Georgia, US | |
870674 | 870674 | 2022-12-11 | US | Missouri | Audrain | 29007 | 6629 | 120 | 0 | 39.215877 | -91.84242683 | 2022-12-12 04:21:01 | Audrain, Missouri, US | |
869603 | 869603 | 2022-12-11 | US | Georgia | Emanuel | 13107 | 6629 | 165 | 0 | 32.59221302 | -82.30239915 | 2022-12-12 04:21:01 | Emanuel, Georgia, US | |
259204 | 259204 | 2022-12-10 | US | Missouri | Audrain | 29007 | 6629 | 120 | 0 | 39.215877 | -91.84242683 | 2022-12-11 04:20:50 | Audrain, Missouri, US | |
258133 | 258133 | 2022-12-10 | US | Georgia | Emanuel | 13107 | 6629 | 165 | 0 | 32.59221302 | -82.30239915 | 2022-12-11 04:20:50 | Emanuel, Georgia, US | |
3937918 | 3937918 | 2022-12-09 | US | Missouri | Audrain | 29007 | 6629 | 120 | 0 | 39.215877 | -91.84242683 | 2022-12-10 04:21:02 | Audrain, Missouri, US | |
3936847 | 3936847 | 2022-12-09 | US | Georgia | Emanuel | 13107 | 6629 | 165 | 0 | 32.59221302 | -82.30239915 | 2022-12-10 04:21:02 | Emanuel, Georgia, US | |
3379250 | 3379250 | 2022-12-08 | US | Missouri | Audrain | 29007 | 6629 | 120 | 0 | 39.215877 | -91.84242683 | 2022-12-09 04:21:05 | Audrain, Missouri, US | |
3378179 | 3378179 | 2022-12-08 | US | Georgia | Emanuel | 13107 | 6629 | 165 | 0 | 32.59221302 | -82.30239915 | 2022-12-09 04:21:05 | Emanuel, Georgia, US | |
1986521 | 1986521 | 2022-12-07 | US | Missouri | Audrain | 29007 | 6629 | 120 | 0 | 39.215877 | -91.84242683 | 2022-12-08 04:21:07 | Audrain, Missouri, US | |
3716044 | 3716044 | 2022-12-06 | US | Missouri | Audrain | 29007 | 6629 | 120 | 0 | 39.215877 | -91.84242683 | 2022-12-07 04:20:58 | Audrain, Missouri, US | |
2508829 | 2508829 | 2022-11-10 | US | Puerto Rico | Naguabo | 72103 | 6629 | 0 | 0 | 18.230637 | -65.753897 | 2022-11-11 04:21:22 | Naguabo, Puerto Rico, US | |
481259 | 481259 | 2022-11-08 | US | Michigan | Menominee | 26109 | 6629 | 77 | 0 | 45.58038692 | -87.55370409 | 2022-11-09 04:21:22 | Menominee, Michigan, US | |
2440409 | 2440409 | 2022-11-07 | US | Michigan | Menominee | 26109 | 6629 | 77 | 0 | 45.58038692 | -87.55370409 | 2022-11-08 04:21:21 | Menominee, Michigan, US | |
1051507 | 1051507 | 2022-11-06 | US | Michigan | Menominee | 26109 | 6629 | 77 | 0 | 45.58038692 | -87.55370409 | 2022-11-07 04:21:26 | Menominee, Michigan, US | |
619531 | 619531 | 2022-11-05 | US | Michigan | Menominee | 26109 | 6629 | 77 | 0 | 45.58038692 | -87.55370409 | 2022-11-06 04:21:24 | Menominee, Michigan, US | |
1024035 | 1024035 | 2022-11-04 | US | Michigan | Menominee | 26109 | 6629 | 77 | 0 | 45.58038692 | -87.55370409 | 2022-11-05 04:21:52 | Menominee, Michigan, US | |
433026 | 433026 | 2022-11-03 | US | Michigan | Menominee | 26109 | 6629 | 77 | 0 | 45.58038692 | -87.55370409 | 2022-11-04 04:22:11 | Menominee, Michigan, US | |
851268 | 851268 | 2022-11-02 | US | Michigan | Menominee | 26109 | 6629 | 77 | 0 | 45.58038692 | -87.55370409 | 2022-11-03 04:22:05 | Menominee, Michigan, US | |
712119 | 712119 | 2022-11-01 | US | Michigan | Menominee | 26109 | 6629 | 77 | 0 | 45.58038692 | -87.55370409 | 2022-11-02 04:22:09 | Menominee, Michigan, US | |
322862 | 322862 | 2022-10-30 | US | Tennessee | Chester | 47023 | 6629 | 101 | 0 | 35.42527478 | -88.6095842 | 2022-10-31 04:21:36 | Chester, Tennessee, US | |
915138 | 915138 | 2022-10-29 | US | Tennessee | Chester | 47023 | 6629 | 101 | 0 | 35.42527478 | -88.6095842 | 2022-10-30 04:22:14 | Chester, Tennessee, US | |
1369407 | 1369407 | 2022-10-28 | US | Tennessee | Chester | 47023 | 6629 | 101 | 0 | 35.42527478 | -88.6095842 | 2022-10-29 04:21:13 | Chester, Tennessee, US | |
3279876 | 3279876 | 2022-10-23 | US | Tennessee | Union | 47173 | 6629 | 80 | 0 | 36.28590426 | -83.83651902 | 2022-10-24 04:22:29 | Union, Tennessee, US | |
2270914 | 2270914 | 2022-10-22 | US | Tennessee | Union | 47173 | 6629 | 80 | 0 | 36.28590426 | -83.83651902 | 2022-10-23 04:22:46 | Union, Tennessee, US | |
1978211 | 1978211 | 2022-09-25 | US | Maryland | Talbot | 24041 | 6629 | 99 | 0 | 38.76618159 | -76.10882561 | 2022-09-26 04:20:52 | Talbot, Maryland, US | |
2651378 | 2651378 | 2022-09-24 | US | Maryland | Talbot | 24041 | 6629 | 99 | 0 | 38.76618159 | -76.10882561 | 2022-09-25 04:23:31 | Talbot, Maryland, US | |
385818 | 385818 | 2022-09-23 | US | Maryland | Talbot | 24041 | 6629 | 99 | 0 | 38.76618159 | -76.10882561 | 2022-09-24 04:21:40 | Talbot, Maryland, US | |
3775463 | 3775463 | 2022-08-30 | US | Maine | Franklin | 23007 | 6629 | 65 | 0 | 44.97330019 | -70.44381045 | 2022-08-31 04:20:57 | Franklin, Maine, US | |
3774339 | 3774339 | 2022-08-30 | US | Alaska | Nome | 2180 | 6629 | 5 | 0 | 64.90320724 | -164.0353804 | 2022-08-31 04:20:57 | Nome, Alaska, US | |
1680935 | 1680935 | 2022-08-29 | US | Alaska | Nome | 2180 | 6629 | 5 | 0 | 64.90320724 | -164.0353804 | 2022-08-30 04:21:03 | Nome, Alaska, US | |
1877419 | 1877419 | 2022-08-28 | US | Alaska | Nome | 2180 | 6629 | 5 | 0 | 64.90320724 | -164.0353804 | 2022-08-29 04:21:06 | Nome, Alaska, US | |
2096546 | 2096546 | 2022-08-27 | US | Alaska | Nome | 2180 | 6629 | 5 | 0 | 64.90320724 | -164.0353804 | 2022-08-28 04:21:02 | Nome, Alaska, US | |
1532361 | 1532361 | 2022-08-26 | US | Alaska | Nome | 2180 | 6629 | 5 | 0 | 64.90320724 | -164.0353804 | 2022-08-27 04:20:57 | Nome, Alaska, US | |
2829248 | 2829248 | 2022-08-25 | US | Alaska | Nome | 2180 | 6629 | 5 | 0 | 64.90320724 | -164.0353804 | 2022-08-26 04:21:02 | Nome, Alaska, US | |
2323781 | 2323781 | 2022-08-24 | US | Alaska | Nome | 2180 | 6629 | 5 | 0 | 64.90320724 | -164.0353804 | 2022-08-25 04:21:13 | Nome, Alaska, US | |
2856346 | 2856346 | 2022-08-22 | US | West Virginia | Hampshire | 54027 | 6629 | 74 | 0 | 39.32103553 | -78.60826476 | 2022-08-23 04:20:56 | Hampshire, West Virginia, US | |
2403362 | 2403362 | 2022-08-21 | US | Arkansas | Sevier | 5133 | 6629 | 76 | 0 | 33.99780401 | -94.2424869 | 2022-08-22 04:20:38 | Sevier, Arkansas, US | |
3798440 | 3798440 | 2022-08-20 | US | Arkansas | Sevier | 5133 | 6629 | 76 | 0 | 33.99780401 | -94.2424869 | 2022-08-21 04:20:44 | Sevier, Arkansas, US | |
674786 | 674786 | 2022-07-30 | US | Arkansas | Carroll | 5015 | 6629 | 108 | 0 | 36.3403856 | -93.54270261 | 2022-07-31 04:21:02 | Carroll, Arkansas, US | |
3212528 | 3212528 | 2022-07-18 | US | New York | Lewis | 36049 | 6629 | 51 | 0 | 43.7844157 | -75.44903992 | 2022-07-19 04:20:58 | Lewis, New York, US | |
3940534 | 3940534 | 2022-06-30 | US | Arkansas | Cleburne | 5023 | 6629 | 129 | 0 | 35.53864922 | -92.02640019 | 2022-07-01 04:21:10 | Cleburne, Arkansas, US | |
3728369 | 3728369 | 2022-06-07 | US | Nevada | Unassigned | 90032 | 6629 | 0 | 0 | 41.40692186 | 0.0 | 2021-01-24 23:22:19 | Unassigned, Nevada, US | |
3889771 | 3889771 | 2022-06-06 | US | Nevada | Unassigned | 90032 | 6629 | 0 | 0 | 41.40692186 | 0.0 | 2021-01-24 23:22:19 | Unassigned, Nevada, US | |
3509540 | 3509540 | 2022-06-05 | US | Nevada | Unassigned | 90032 | 6629 | 0 | 0 | 41.40692186 | 0.0 | 2021-01-24 23:22:19 | Unassigned, Nevada, US | |
3529617 | 3529617 | 2022-06-04 | US | Nevada | Unassigned | 90032 | 6629 | 0 | 0 | 41.40692186 | 0.0 | 2021-01-24 23:22:19 | Unassigned, Nevada, US | |
3135703 | 3135703 | 2022-06-03 | US | Nevada | Unassigned | 90032 | 6629 | 0 | 0 | 41.40692186 | 0.0 | 2021-01-24 23:22:19 | Unassigned, Nevada, US | |
3582224 | 3582224 | 2022-06-02 | US | Wisconsin | Waushara | 55137 | 6629 | 87 | 0 | 44.11324419 | -89.24317107 | 2022-06-03 04:20:58 | Waushara, Wisconsin, US | |
3580778 | 3580778 | 2022-06-02 | US | Nevada | Unassigned | 90032 | 6629 | 0 | 0 | 41.40692186 | 0.0 | 2021-01-24 23:22:19 | Unassigned, Nevada, US | |
3579757 | 3579757 | 2022-06-02 | US | Indiana | Posey | 18129 | 6629 | 58 | 0 | 38.02097333 | -87.86480429 | 2022-06-03 04:20:58 | Posey, Indiana, US | |
973071 | 973071 | 2022-06-01 | US | Nevada | Unassigned | 90032 | 6629 | 0 | 0 | 41.40692186 | 0.0 | 2021-01-24 23:22:19 | Unassigned, Nevada, US | |
972050 | 972050 | 2022-06-01 | US | Indiana | Posey | 18129 | 6629 | 58 | 0 | 38.02097333 | -87.86480429 | 2022-06-02 05:20:39 | Posey, Indiana, US | |
231515 | 231515 | 2022-05-31 | US | North Carolina | Anson | 37007 | 6629 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-06-01 04:20:55 | Anson, North Carolina, US | |
3188280 | 3188280 | 2022-05-30 | US | North Carolina | Anson | 37007 | 6629 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-31 04:20:51 | Anson, North Carolina, US | |
3200429 | 3200429 | 2022-05-29 | US | North Carolina | Anson | 37007 | 6629 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-30 04:20:50 | Anson, North Carolina, US | |
2727307 | 2727307 | 2022-05-28 | US | North Carolina | Anson | 37007 | 6629 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-29 04:20:53 | Anson, North Carolina, US | |
1316488 | 1316488 | 2022-05-27 | US | North Carolina | Anson | 37007 | 6629 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-28 04:21:07 | Anson, North Carolina, US | |
1852280 | 1852280 | 2022-05-26 | US | North Carolina | Anson | 37007 | 6629 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-27 04:20:56 | Anson, North Carolina, US | |
2050156 | 2050156 | 2022-05-25 | US | North Carolina | Anson | 37007 | 6629 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-26 04:20:50 | Anson, North Carolina, US | |
624167 | 624167 | 2022-05-22 | US | North Carolina | Anson | 37007 | 6629 | 101 | 0 | 34.97403241 | -80.09953279 | 2022-05-26 04:20:50 | Anson, North Carolina, US | |
658863 | 658863 | 2022-05-13 | US | California | Glenn | 6021 | 6629 | 48 | 0 | 39.59875897 | -122.3938452 | 2022-05-14 04:20:48 | Glenn, California, US | |
2751688 | 2751688 | 2022-04-04 | US | South Carolina | Abbeville | 45001 | 6629 | 70 | 0 | 34.22333378 | -82.46170658 | 2022-04-05 04:20:48 | Abbeville, South Carolina, US | |
3733034 | 3733034 | 2022-04-03 | US | South Carolina | Abbeville | 45001 | 6629 | 70 | 0 | 34.22333378 | -82.46170658 | 2022-04-04 04:20:51 | Abbeville, South Carolina, US | |
502469 | 502469 | 2022-04-02 | US | South Carolina | Abbeville | 45001 | 6629 | 70 | 0 | 34.22333378 | -82.46170658 | 2022-04-03 04:20:48 | Abbeville, South Carolina, US | |
3353454 | 3353454 | 2022-04-01 | US | South Carolina | Abbeville | 45001 | 6629 | 70 | 0 | 34.22333378 | -82.46170658 | 2022-04-02 04:20:47 | Abbeville, South Carolina, US | |
1542759 | 1542759 | 2022-03-31 | US | South Carolina | Abbeville | 45001 | 6629 | 70 | 0 | 34.22333378 | -82.46170658 | 2022-04-01 04:20:28 | Abbeville, South Carolina, US | |
2480772 | 2480772 | 2022-03-30 | US | South Carolina | Abbeville | 45001 | 6629 | 70 | 0 | 34.22333378 | -82.46170658 | 2022-03-31 04:20:56 | Abbeville, South Carolina, US | |
160813 | 160813 | 2022-03-29 | US | South Carolina | Abbeville | 45001 | 6629 | 70 | 0 | 34.22333378 | -82.46170658 | 2022-03-30 04:20:45 | Abbeville, South Carolina, US | |
3025770 | 3025770 | 2022-03-23 | US | West Virginia | Mason | 54053 | 6629 | 91 | 0 | 38.77071799 | -82.02524219 | 2022-03-24 04:20:43 | Mason, West Virginia, US | |
1996144 | 1996144 | 2022-03-01 | US | West Virginia | Hancock | 54029 | 6629 | 137 | 0 | 40.51943859 | -80.57461608 | 2022-03-02 04:21:07 | Hancock, West Virginia, US | |
943064 | 943064 | 2022-02-28 | Russia | Nenets Autonomous Okrug | 6629 | 93 | 0 | 68.27557185 | 57.1686375 | 2022-03-01 04:21:09 | Nenets Autonomous Okrug, Russia | |||
3858958 | 3858958 | 2022-02-18 | US | Texas | Howard | 48227 | 6629 | 166 | 0 | 32.30621324 | -101.4356444 | 2022-02-19 04:21:11 | Howard, Texas, US | |
3823964 | 3823964 | 2022-02-16 | US | West Virginia | Wyoming | 54109 | 6629 | 90 | 0 | 37.612327 | -81.54511071 | 2022-02-17 04:20:56 | Wyoming, West Virginia, US | |
2642839 | 2642839 | 2022-02-14 | US | Indiana | Fayette | 18041 | 6629 | 133 | 0 | 39.63684962 | -85.17797541 | 2022-02-15 04:21:09 | Fayette, Indiana, US | |
74045 | 74045 | 2022-02-07 | US | Tennessee | Hickman | 47081 | 6629 | 101 | 0 | 35.80609681 | -87.47643507 | 2022-02-08 04:21:15 | Hickman, Tennessee, US | |
460455 | 460455 | 2022-02-02 | US | Indiana | Clay | 18021 | 6629 | 78 | 0 | 39.39561833 | -87.11723506 | 2022-02-03 04:21:21 | Clay, Indiana, US | |
1474348 | 1474348 | 2022-01-17 | US | New York | Delaware | 36025 | 6629 | 62 | 0 | 42.19837623 | -74.96709306 | 2022-01-18 04:21:04 | Delaware, New York, US | |
3842090 | 3842090 | 2022-01-15 | US | Maryland | Dorchester | 24019 | 6629 | 95 | 0 | 38.45413522 | -76.02752426 | 2022-01-16 04:21:12 | Dorchester, Maryland, US | |
102028 | 102028 | 2022-01-14 | US | Pennsylvania | Susquehanna | 42115 | 6629 | 96 | 0 | 41.82147784 | -75.80071959 | 2022-01-15 04:21:07 | Susquehanna, Pennsylvania, US | |
2906723 | 2906723 | 2021-12-19 | US | Tennessee | Weakley | 47183 | 6629 | 100 | 0 | 36.29896232 | -88.71990865 | 2021-12-20 04:21:43 | Weakley, Tennessee, US | |
2904866 | 2904866 | 2021-12-19 | US | Indiana | Wabash | 18169 | 6629 | 121 | 0 | 40.84704239 | -85.79328272 | 2021-12-20 04:21:43 | Wabash, Indiana, US | |
1259939 | 1259939 | 2021-12-18 | US | Indiana | Wabash | 18169 | 6629 | 121 | 0 | 40.84704239 | -85.79328272 | 2021-12-19 04:21:11 | Wabash, Indiana, US | |
2399967 | 2399967 | 2021-12-17 | US | Indiana | Wabash | 18169 | 6629 | 121 | 0 | 40.84704239 | -85.79328272 | 2021-12-18 02:22:20 | Wabash, Indiana, US | |
1234908 | 1234908 | 2021-11-28 | US | Utah | Wasatch | 49051 | 6629 | 29 | 0 | 40.33110236 | -111.1691419 | 2021-11-29 04:22:30 | Wasatch, Utah, US | |
1361615 | 1361615 | 2021-11-27 | US | Utah | Wasatch | 49051 | 6629 | 29 | 0 | 40.33110236 | -111.1691419 | 2021-11-28 04:22:43 | Wasatch, Utah, US | |
761606 | 761606 | 2021-11-26 | US | Utah | Wasatch | 49051 | 6629 | 29 | 0 | 40.33110236 | -111.1691419 | 2021-11-27 04:22:45 | Wasatch, Utah, US | |
2288575 | 2288575 | 2021-11-15 | US | Indiana | Montgomery | 18107 | 6629 | 118 | 0 | 40.04034823 | -86.89335024 | 2021-11-16 04:21:10 | Montgomery, Indiana, US | |
3513120 | 3513120 | 2021-11-01 | US | Minnesota | Douglas | 27041 | 6629 | 92 | 0 | 45.93348491 | -95.45335469 | 2021-11-02 04:22:03 | Douglas, Minnesota, US | |
569617 | 569617 | 2021-10-29 | US | Ohio | Shelby | 39149 | 6629 | 130 | 0 | 40.33163494 | -84.20258189 | 2021-10-30 04:22:03 | Shelby, Ohio, US | |
537878 | 537878 | 2021-10-27 | US | Texas | Kerr | 48265 | 6629 | 133 | 0 | 30.06040006 | -99.34930144 | 2021-10-28 04:22:08 | Kerr, Texas, US | |
3495315 | 3495315 | 2021-10-26 | US | Texas | Kerr | 48265 | 6629 | 132 | 0 | 30.06040006 | -99.34930144 | 2021-10-27 04:22:32 | Kerr, Texas, US | |
2046288 | 2046288 | 2021-10-18 | US | North Dakota | Williams | 38105 | 6629 | 48 | 0 | 48.34522353 | -103.4793387 | 2021-10-19 04:20:54 | Williams, North Dakota, US | |
2462374 | 2462374 | 2021-10-06 | US | Wisconsin | Shawano | 55115 | 6629 | 90 | 0 | 44.78902246 | -88.76443896 | 2021-10-07 04:21:36 | Shawano, Wisconsin, US | |
2465451 | 2465451 | 2021-09-14 | US | Pennsylvania | Columbia | 42037 | 6629 | 139 | 0 | 41.04821986 | -76.40565017 | 2021-09-15 03:22:37 | Columbia, Pennsylvania, US | |
3976507 | 3976507 | 2021-09-03 | US | Missouri | Pettis | 29159 | 6629 | 88 | 0 | 38.72798918 | -93.28471706 | 2021-09-04 04:21:28 | Pettis, Missouri, US | |
180347 | 180347 | 2021-09-02 | US | North Carolina | Halifax | 37083 | 6629 | 121 | 0 | 36.25669272 | -77.6556109 | 2021-09-03 04:21:20 | Halifax, North Carolina, 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]);