johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
243 rows where confirmed = 2939 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755321 | 2755321 | 2022-12-29 | US | North Dakota | Mercer | 38057 | 2939 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-12-30 04:21:04 | Mercer, North Dakota, US | |
1076327 | 1076327 | 2022-12-28 | US | North Dakota | Mercer | 38057 | 2939 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-12-29 04:21:01 | Mercer, North Dakota, US | |
330324 | 330324 | 2022-12-27 | US | North Dakota | Mercer | 38057 | 2939 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-12-28 04:21:04 | Mercer, North Dakota, US | |
220397 | 220397 | 2022-12-26 | US | North Dakota | Mercer | 38057 | 2939 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-12-27 04:21:07 | Mercer, North Dakota, US | |
3224854 | 3224854 | 2022-12-25 | US | North Dakota | Mercer | 38057 | 2939 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-12-26 04:21:06 | Mercer, North Dakota, US | |
1020768 | 1020768 | 2022-12-24 | US | North Dakota | Mercer | 38057 | 2939 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-12-25 04:21:04 | Mercer, North Dakota, US | |
692791 | 692791 | 2022-12-23 | US | North Dakota | Mercer | 38057 | 2939 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-12-24 04:21:02 | Mercer, North Dakota, US | |
2182001 | 2182001 | 2022-12-22 | US | North Dakota | Mercer | 38057 | 2939 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-12-23 04:21:04 | Mercer, North Dakota, US | |
2951905 | 2951905 | 2022-12-20 | US | Arkansas | Perry | 5105 | 2939 | 42 | 0 | 34.9459153 | -92.94372564 | 2022-12-21 04:21:03 | Perry, Arkansas, US | |
3174307 | 3174307 | 2022-12-19 | US | Arkansas | Perry | 5105 | 2939 | 42 | 0 | 34.9459153 | -92.94372564 | 2022-12-20 04:21:04 | Perry, Arkansas, US | |
322892 | 322892 | 2022-10-30 | US | Tennessee | Houston | 47083 | 2939 | 63 | 0 | 36.28872054 | -87.71878828 | 2022-10-31 04:21:36 | Houston, Tennessee, US | |
915168 | 915168 | 2022-10-29 | US | Tennessee | Houston | 47083 | 2939 | 63 | 0 | 36.28872054 | -87.71878828 | 2022-10-30 04:22:14 | Houston, Tennessee, US | |
1369437 | 1369437 | 2022-10-28 | US | Tennessee | Houston | 47083 | 2939 | 63 | 0 | 36.28872054 | -87.71878828 | 2022-10-29 04:21:13 | Houston, Tennessee, US | |
2376195 | 2376195 | 2022-09-29 | US | Colorado | Prowers | 8099 | 2939 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-09-30 04:23:09 | Prowers, Colorado, US | |
254818 | 254818 | 2022-09-08 | US | Louisiana | East Carroll | 22035 | 2939 | 38 | 0 | 32.73926954 | -91.23425694 | 2022-09-09 04:21:11 | East Carroll, Louisiana, US | |
117714 | 117714 | 2022-09-06 | US | Tennessee | Lake | 47095 | 2939 | 44 | 0 | 36.3418017 | -89.48921915 | 2022-09-07 04:20:59 | Lake, Tennessee, US | |
2343233 | 2343233 | 2022-08-31 | China | Shandong | 2939 | 7 | 0 | 36.3427 | 118.1498 | 2022-09-01 04:21:03 | Shandong, China | |||
3776934 | 3776934 | 2022-08-30 | US | Texas | Blanco | 48031 | 2939 | 35 | 0 | 30.26640707 | -98.3999852 | 2022-08-31 04:20:57 | Blanco, Texas, US | |
3775148 | 3775148 | 2022-08-30 | US | Iowa | Shelby | 19165 | 2939 | 52 | 0 | 41.6850066 | -95.31015553 | 2022-08-31 04:20:57 | Shelby, Iowa, US | |
1681744 | 1681744 | 2022-08-29 | US | Iowa | Shelby | 19165 | 2939 | 52 | 0 | 41.6850066 | -95.31015553 | 2022-08-30 04:21:03 | Shelby, Iowa, US | |
1878228 | 1878228 | 2022-08-28 | US | Iowa | Shelby | 19165 | 2939 | 52 | 0 | 41.6850066 | -95.31015553 | 2022-08-29 04:21:06 | Shelby, Iowa, US | |
2097355 | 2097355 | 2022-08-27 | US | Iowa | Shelby | 19165 | 2939 | 52 | 0 | 41.6850066 | -95.31015553 | 2022-08-28 04:21:02 | Shelby, Iowa, US | |
1533170 | 1533170 | 2022-08-26 | US | Iowa | Shelby | 19165 | 2939 | 52 | 0 | 41.6850066 | -95.31015553 | 2022-08-27 04:20:57 | Shelby, Iowa, US | |
2830057 | 2830057 | 2022-08-25 | US | Iowa | Shelby | 19165 | 2939 | 52 | 0 | 41.6850066 | -95.31015553 | 2022-08-26 04:21:02 | Shelby, Iowa, US | |
2324590 | 2324590 | 2022-08-24 | US | Iowa | Shelby | 19165 | 2939 | 52 | 0 | 41.6850066 | -95.31015553 | 2022-08-25 04:21:13 | Shelby, Iowa, US | |
2855275 | 2855275 | 2022-08-22 | US | North Dakota | McLean | 38055 | 2939 | 49 | 0 | 47.60766714 | -101.3182418 | 2022-08-23 04:20:56 | McLean, North Dakota, US | |
1161640 | 1161640 | 2022-08-18 | US | Arkansas | Chicot | 5017 | 2939 | 59 | 0 | 33.26458973 | -91.29539209 | 2022-08-19 04:20:54 | Chicot, Arkansas, US | |
2009648 | 2009648 | 2022-08-04 | US | Idaho | Shoshone | 16079 | 2939 | 77 | 0 | 47.35364087 | -115.8916749 | 2022-08-05 04:20:52 | Shoshone, Idaho, US | |
1099075 | 1099075 | 2022-08-03 | US | Idaho | Shoshone | 16079 | 2939 | 77 | 0 | 47.35364087 | -115.8916749 | 2022-08-04 04:20:58 | Shoshone, Idaho, US | |
1202851 | 1202851 | 2022-07-06 | US | Texas | Camp | 48063 | 2939 | 75 | 0 | 32.97195142 | -94.97790104 | 2022-07-07 04:20:55 | Camp, Texas, US | |
2240951 | 2240951 | 2022-06-28 | US | Louisiana | West Feliciana | 22125 | 2939 | 46 | 0 | 30.87882871 | -91.4148538 | 2022-06-29 04:20:59 | West Feliciana, Louisiana, US | |
2149193 | 2149193 | 2022-06-27 | US | Louisiana | West Feliciana | 22125 | 2939 | 46 | 0 | 30.87882871 | -91.4148538 | 2022-06-28 04:20:58 | West Feliciana, Louisiana, US | |
3727950 | 3727950 | 2022-06-07 | US | Minnesota | Koochiching | 27071 | 2939 | 37 | 0 | 48.24539665 | -93.78352843 | 2022-06-08 04:20:55 | Koochiching, Minnesota, US | |
1851879 | 1851879 | 2022-05-26 | US | Missouri | Cedar | 29039 | 2939 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-27 04:20:56 | Cedar, Missouri, US | |
1850523 | 1850523 | 2022-05-26 | US | Arkansas | Stone | 5137 | 2939 | 68 | 0 | 35.86251946 | -92.15684085 | 2022-05-27 04:20:56 | Stone, Arkansas, US | |
2049755 | 2049755 | 2022-05-25 | US | Missouri | Cedar | 29039 | 2939 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-26 04:20:50 | Cedar, Missouri, US | |
3001193 | 3001193 | 2022-05-24 | US | Missouri | Cedar | 29039 | 2939 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-25 04:20:56 | Cedar, Missouri, US | |
3594914 | 3594914 | 2022-05-23 | US | Missouri | Cedar | 29039 | 2939 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-24 04:20:57 | Cedar, Missouri, US | |
623766 | 623766 | 2022-05-22 | US | Missouri | Cedar | 29039 | 2939 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-26 04:20:50 | Cedar, Missouri, US | |
1111462 | 1111462 | 2022-05-21 | US | Missouri | Cedar | 29039 | 2939 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-22 04:20:52 | Cedar, Missouri, US | |
1171086 | 1171086 | 2022-05-20 | US | Missouri | Cedar | 29039 | 2939 | 57 | 0 | 37.72391475 | -93.85445441 | 2022-05-21 04:20:58 | Cedar, Missouri, US | |
1326849 | 1326849 | 2022-04-26 | US | Colorado | Archuleta | 8007 | 2939 | 16 | 0 | 37.19474156 | -107.04768670000001 | 2022-04-27 04:20:52 | Archuleta, Colorado, US | |
3722803 | 3722803 | 2022-04-25 | US | Colorado | Archuleta | 8007 | 2939 | 16 | 0 | 37.19474156 | -107.04768670000001 | 2022-04-26 04:20:51 | Archuleta, Colorado, US | |
2029371 | 2029371 | 2022-04-24 | US | Colorado | Archuleta | 8007 | 2939 | 16 | 0 | 37.19474156 | -107.04768670000001 | 2022-04-25 04:20:56 | Archuleta, Colorado, US | |
746946 | 746946 | 2022-04-23 | US | Colorado | Archuleta | 8007 | 2939 | 16 | 0 | 37.19474156 | -107.04768670000001 | 2022-04-24 04:20:56 | Archuleta, Colorado, US | |
161458 | 161458 | 2022-03-29 | US | Washington | Jefferson | 53031 | 2939 | 28 | 0 | 47.75003077 | -123.56097040000002 | 2022-03-30 04:20:45 | Jefferson, Washington, US | |
1440029 | 1440029 | 2022-03-28 | US | Washington | Jefferson | 53031 | 2939 | 28 | 0 | 47.75003077 | -123.56097040000002 | 2022-03-29 04:20:46 | Jefferson, Washington, US | |
878551 | 878551 | 2022-03-27 | US | North Carolina | Alleghany | 37005 | 2939 | 12 | 0 | 36.49360862 | -81.12857041 | 2022-03-28 04:20:33 | Alleghany, North Carolina, US | |
2165834 | 2165834 | 2022-03-26 | US | North Carolina | Alleghany | 37005 | 2939 | 12 | 0 | 36.49360862 | -81.12857041 | 2022-03-27 04:20:47 | Alleghany, North Carolina, US | |
1722770 | 1722770 | 2022-03-25 | US | North Carolina | Alleghany | 37005 | 2939 | 12 | 0 | 36.49360862 | -81.12857041 | 2022-03-26 04:20:23 | Alleghany, North Carolina, US | |
27177 | 27177 | 2022-03-20 | US | Puerto Rico | Salinas | 72123 | 2939 | 0 | 0 | 18.010386999999994 | -66.256592 | 2022-03-21 04:20:50 | Salinas, Puerto Rico, US | |
2319695 | 2319695 | 2022-03-16 | US | Alabama | Coosa | 1037 | 2939 | 57 | 0 | 32.93690146 | -86.24847739 | 2022-03-17 04:20:56 | Coosa, Alabama, US | |
945740 | 945740 | 2022-02-28 | US | South Dakota | Todd | 46121 | 2939 | 48 | 0 | 43.19338568 | -100.71955030000001 | 2022-03-01 04:21:09 | Todd, South Dakota, US | |
1514011 | 1514011 | 2022-02-24 | US | Oklahoma | Unassigned | 90040 | 2939 | 1547 | 0 | 36.83532655 | 0.0 | 2022-02-25 04:21:11 | Unassigned, Oklahoma, US | |
1513795 | 1513795 | 2022-02-24 | US | North Dakota | Barnes | 38003 | 2939 | 46 | 0 | 46.93579637 | -98.06605978 | 2022-02-25 04:21:11 | Barnes, North Dakota, US | |
1060756 | 1060756 | 2022-02-23 | US | South Dakota | Todd | 46121 | 2939 | 47 | 0 | 43.19338568 | -100.71955030000001 | 2022-02-24 04:21:14 | Todd, South Dakota, US | |
1300810 | 1300810 | 2022-02-17 | US | Puerto Rico | Loiza | 72087 | 2939 | 0 | 0 | 18.425688 | -65.89943000000001 | 2022-02-18 04:21:04 | Loiza, Puerto Rico, US | |
187778 | 187778 | 2022-02-13 | US | Minnesota | Chippewa | 27023 | 2939 | 46 | 0 | 45.02343421 | -95.56403693 | 2022-02-14 04:20:51 | Chippewa, Minnesota, US | |
317624 | 317624 | 2022-02-12 | US | Minnesota | Chippewa | 27023 | 2939 | 46 | 0 | 45.02343421 | -95.56403693 | 2022-02-13 04:21:00 | Chippewa, Minnesota, US | |
234950 | 234950 | 2022-02-11 | US | Minnesota | Chippewa | 27023 | 2939 | 46 | 0 | 45.02343421 | -95.56403693 | 2022-02-12 04:21:06 | Chippewa, Minnesota, US | |
462166 | 462166 | 2022-02-02 | US | Puerto Rico | Utuado | 72141 | 2939 | 0 | 0 | 18.271214 | -66.702984 | 2022-02-03 04:21:21 | Utuado, Puerto Rico, US | |
980735 | 980735 | 2022-02-01 | US | Mississippi | Amite | 28005 | 2939 | 61 | 0 | 31.17467303 | -90.80501621 | 2022-02-02 04:21:09 | Amite, Mississippi, US | |
980167 | 980167 | 2022-02-01 | US | Iowa | Madison | 19121 | 2939 | 30 | 0 | 41.33081904 | -94.01554631 | 2022-02-02 04:21:09 | Madison, Iowa, US | |
2659009 | 2659009 | 2022-01-31 | US | Iowa | Madison | 19121 | 2939 | 30 | 0 | 41.33081904 | -94.01554631 | 2022-02-01 04:21:11 | Madison, Iowa, US | |
3303811 | 3303811 | 2022-01-30 | US | Wyoming | Converse | 56009 | 2939 | 49 | 0 | 42.97272268 | -105.5081848 | 2022-01-31 04:21:09 | Converse, Wyoming, US | |
3301426 | 3301426 | 2022-01-30 | US | Iowa | Madison | 19121 | 2939 | 30 | 0 | 41.33081904 | -94.01554631 | 2022-01-31 04:21:09 | Madison, Iowa, US | |
3065602 | 3065602 | 2022-01-29 | US | Wyoming | Converse | 56009 | 2939 | 49 | 0 | 42.97272268 | -105.5081848 | 2022-01-30 04:21:26 | Converse, Wyoming, US | |
3063217 | 3063217 | 2022-01-29 | US | Iowa | Madison | 19121 | 2939 | 30 | 0 | 41.33081904 | -94.01554631 | 2022-01-30 04:21:26 | Madison, Iowa, US | |
3813536 | 3813536 | 2022-01-28 | US | Wyoming | Converse | 56009 | 2939 | 49 | 0 | 42.97272268 | -105.5081848 | 2022-01-29 04:21:10 | Converse, Wyoming, US | |
3811151 | 3811151 | 2022-01-28 | US | Iowa | Madison | 19121 | 2939 | 30 | 0 | 41.33081904 | -94.01554631 | 2022-01-29 04:21:10 | Madison, Iowa, US | |
1780605 | 1780605 | 2022-01-27 | US | Iowa | Madison | 19121 | 2939 | 30 | 0 | 41.33081904 | -94.01554631 | 2022-01-28 04:21:09 | Madison, Iowa, US | |
1319433 | 1319433 | 2022-01-26 | US | Iowa | Madison | 19121 | 2939 | 30 | 0 | 41.33081904 | -94.01554631 | 2022-01-27 04:21:19 | Madison, Iowa, US | |
1962968 | 1962968 | 2022-01-20 | US | North Dakota | McKenzie | 38053 | 2939 | 23 | 0 | 47.74133370000001 | -103.395905 | 2022-01-21 04:21:09 | McKenzie, North Dakota, US | |
1961942 | 1961942 | 2022-01-20 | US | Kentucky | Carroll | 21041 | 2939 | 38 | 0 | 38.66599534 | -85.12601074 | 2022-01-21 04:21:09 | Carroll, Kentucky, US | |
557058 | 557058 | 2022-01-16 | US | New York | Schuyler | 36097 | 2939 | 23 | 0 | 42.39184015 | -76.8773299 | 2022-01-17 04:21:08 | Schuyler, New York, US | |
99937 | 99937 | 2022-01-14 | US | Colorado | Crowley | 8025 | 2939 | 27 | 0 | 38.32608609 | -103.7844965 | 2022-01-15 04:21:07 | Crowley, Colorado, US | |
3688808 | 3688808 | 2022-01-13 | US | Kansas | Osage | 20139 | 2939 | 40 | 0 | 38.65235984 | -95.72707998 | 2022-01-14 04:21:54 | Osage, Kansas, US | |
3614392 | 3614392 | 2022-01-12 | US | Kansas | Osage | 20139 | 2939 | 40 | 0 | 38.65235984 | -95.72707998 | 2022-01-13 08:00:09 | Osage, Kansas, US | |
1114917 | 1114917 | 2022-01-11 | US | Kansas | Osage | 20139 | 2939 | 40 | 0 | 38.65235984 | -95.72707998 | 2022-01-12 04:21:44 | Osage, Kansas, US | |
1695791 | 1695791 | 2022-01-10 | US | West Virginia | Braxton | 54007 | 2939 | 32 | 0 | 38.70036159 | -80.72011184 | 2022-01-11 04:22:01 | Braxton, West Virginia, US | |
1693645 | 1693645 | 2022-01-10 | US | Kansas | Osage | 20139 | 2939 | 40 | 0 | 38.65235984 | -95.72707998 | 2022-01-11 04:22:01 | Osage, Kansas, US | |
1287989 | 1287989 | 2022-01-04 | US | Missouri | Wright | 29229 | 2939 | 68 | 0 | 37.27029221 | -92.46914488 | 2022-01-05 04:21:59 | Wright, Missouri, US | |
1287519 | 1287519 | 2022-01-04 | US | Louisiana | LaSalle | 22059 | 2939 | 46 | 0 | 31.67884782 | -92.15907765 | 2022-01-05 04:21:59 | LaSalle, Louisiana, US | |
1256563 | 1256563 | 2021-12-20 | US | Mississippi | Calhoun | 28013 | 2939 | 51 | 0 | 33.93683395 | -89.33686647 | 2021-12-21 03:21:27 | Calhoun, Mississippi, US | |
2904654 | 2904654 | 2021-12-19 | US | Idaho | Gem | 16045 | 2939 | 70 | 0 | 44.06482372 | -116.398376 | 2021-12-20 04:21:43 | Gem, Idaho, US | |
1259727 | 1259727 | 2021-12-18 | US | Idaho | Gem | 16045 | 2939 | 70 | 0 | 44.06482372 | -116.398376 | 2021-12-19 04:21:11 | Gem, Idaho, US | |
2399755 | 2399755 | 2021-12-17 | US | Idaho | Gem | 16045 | 2939 | 70 | 0 | 44.06482372 | -116.398376 | 2021-12-18 02:22:20 | Gem, Idaho, US | |
3498518 | 3498518 | 2021-12-15 | US | North Carolina | Hertford | 37091 | 2939 | 73 | 0 | 36.3607755 | -76.98104134 | 2021-12-16 04:22:11 | Hertford, North Carolina, US | |
2091285 | 2091285 | 2021-12-14 | US | Virginia | Buchanan | 51027 | 2939 | 82 | 0 | 37.26818323 | -82.03749726 | 2021-12-15 03:22:16 | Buchanan, Virginia, US | |
1667216 | 1667216 | 2021-12-11 | US | Puerto Rico | Rio Grande | 72119 | 2939 | 0 | 0 | 18.346329 | -65.813742 | 2021-12-12 04:22:12 | Rio Grande, Puerto Rico, US | |
3658368 | 3658368 | 2021-12-10 | US | Puerto Rico | Rio Grande | 72119 | 2939 | 0 | 0 | 18.346329 | -65.813742 | 2021-12-11 04:22:45 | Rio Grande, Puerto Rico, US | |
551833 | 551833 | 2021-12-08 | US | Illinois | White | 17193 | 2939 | 33 | 0 | 38.08706198 | -88.17657461 | 2021-12-09 04:22:49 | White, Illinois, US | |
1741967 | 1741967 | 2021-12-05 | US | Kentucky | Lawrence | 21127 | 2939 | 44 | 0 | 38.07136018 | -82.72882223 | 2021-12-06 04:22:34 | Lawrence, Kentucky, US | |
3751337 | 3751337 | 2021-11-22 | US | New Mexico | San Miguel | 35047 | 2939 | 29 | 0 | 35.48014807 | -104.8163562 | 2021-11-23 04:22:39 | San Miguel, New Mexico, US | |
1322090 | 1322090 | 2021-11-14 | Denmark | Faroe Islands | 2939 | 8 | 0 | 61.8926 | -6.9118 | 2021-11-15 04:21:36 | Faroe Islands, Denmark | |||
686976 | 686976 | 2021-11-13 | US | Colorado | Elbert | 8039 | 2939 | 26 | 0 | 39.28656773 | -104.13587209999999 | 2021-11-14 04:21:31 | Elbert, Colorado, US | |
698933 | 698933 | 2021-11-04 | US | Arkansas | Sharp | 5135 | 2939 | 68 | 0 | 36.16258158 | -91.47819342 | 2021-11-05 04:21:54 | Sharp, Arkansas, US | |
3494372 | 3494372 | 2021-10-26 | US | New Mexico | Lincoln | 35027 | 2939 | 32 | 0 | 33.74526079 | -105.4586166 | 2021-10-27 04:22:32 | Lincoln, New Mexico, US | |
3796508 | 3796508 | 2021-10-25 | US | Oregon | Crook | 41013 | 2939 | 46 | 0 | 44.14230227 | -120.356297 | 2021-10-26 04:22:09 | Crook, Oregon, US | |
2124434 | 2124434 | 2021-10-21 | US | Florida | Dixie | 12029 | 2939 | 24 | 0 | 29.60631086 | -83.15724673 | 2021-10-22 04:21:14 | Dixie, Florida, 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]);