johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
90 rows where confirmed = 6622 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 6
- US 84
- Iceland 2
- Hungary 1
- Mauritania 1
- Russia 1
- Timor-Leste 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3175428 | 3175428 | 2022-12-19 | US | Michigan | Gladwin | 26051 | 6622 | 133 | 0 | 43.98901072 | -84.38774817 | 2022-12-20 04:21:04 | Gladwin, Michigan, US | |
1629945 | 1629945 | 2022-12-18 | US | Michigan | Gladwin | 26051 | 6622 | 133 | 0 | 43.98901072 | -84.38774817 | 2022-12-19 04:21:03 | Gladwin, Michigan, US | |
505324 | 505324 | 2022-12-17 | US | Michigan | Gladwin | 26051 | 6622 | 133 | 0 | 43.98901072 | -84.38774817 | 2022-12-18 04:21:03 | Gladwin, Michigan, US | |
3325896 | 3325896 | 2022-12-16 | US | Michigan | Gladwin | 26051 | 6622 | 133 | 0 | 43.98901072 | -84.38774817 | 2022-12-17 04:21:04 | Gladwin, Michigan, US | |
544408 | 544408 | 2022-12-15 | US | Michigan | Gladwin | 26051 | 6622 | 133 | 0 | 43.98901072 | -84.38774817 | 2022-12-16 04:21:01 | Gladwin, Michigan, US | |
349936 | 349936 | 2022-12-14 | US | Michigan | Gladwin | 26051 | 6622 | 133 | 0 | 43.98901072 | -84.38774817 | 2022-12-15 04:20:58 | Gladwin, Michigan, US | |
310895 | 310895 | 2022-12-13 | US | Tennessee | Wayne | 47181 | 6622 | 80 | 0 | 35.23868267 | -87.78644456 | 2022-12-14 04:21:04 | Wayne, Tennessee, US | |
309524 | 309524 | 2022-12-13 | US | Michigan | Gladwin | 26051 | 6622 | 133 | 0 | 43.98901072 | -84.38774817 | 2022-12-14 04:21:04 | Gladwin, Michigan, US | |
719959 | 719959 | 2022-12-04 | US | Kentucky | Spencer | 21215 | 6622 | 66 | 0 | 38.03223971 | -85.32749335 | 2022-12-05 04:20:58 | Spencer, Kentucky, US | |
2818248 | 2818248 | 2022-12-03 | US | Kentucky | Spencer | 21215 | 6622 | 66 | 0 | 38.03223971 | -85.32749335 | 2022-12-04 04:20:56 | Spencer, Kentucky, US | |
835104 | 835104 | 2022-12-02 | US | Kentucky | Spencer | 21215 | 6622 | 66 | 0 | 38.03223971 | -85.32749335 | 2022-12-03 04:21:02 | Spencer, Kentucky, US | |
2137634 | 2137634 | 2022-12-01 | US | Kentucky | Spencer | 21215 | 6622 | 66 | 0 | 38.03223971 | -85.32749335 | 2022-12-02 04:21:07 | Spencer, Kentucky, US | |
1966050 | 1966050 | 2022-11-30 | US | Kentucky | Spencer | 21215 | 6622 | 66 | 0 | 38.03223971 | -85.32749335 | 2022-12-01 04:21:03 | Spencer, Kentucky, US | |
2558064 | 2558064 | 2022-11-29 | US | Kentucky | Spencer | 21215 | 6622 | 66 | 0 | 38.03223971 | -85.32749335 | 2022-11-30 04:21:07 | Spencer, Kentucky, US | |
1241138 | 1241138 | 2022-11-28 | US | Kentucky | Spencer | 21215 | 6622 | 66 | 0 | 38.03223971 | -85.32749335 | 2022-11-29 04:21:05 | Spencer, Kentucky, US | |
1369211 | 1369211 | 2022-10-28 | US | Puerto Rico | Catano | 72033 | 6622 | 0 | 0 | 18.437269 | -66.143306 | 2022-10-29 04:21:13 | Catano, Puerto Rico, US | |
2376008 | 2376008 | 2022-09-29 | US | Arkansas | Arkansas | 5001 | 6622 | 83 | 0 | 34.29145151 | -91.37277296 | 2022-09-30 04:23:09 | Arkansas, Arkansas, US | |
2772458 | 2772458 | 2022-09-26 | US | West Virginia | Lewis | 54041 | 6622 | 93 | 0 | 38.9947249 | -80.49988181 | 2022-09-27 04:23:01 | Lewis, West Virginia, US | |
1627070 | 1627070 | 2022-09-22 | US | Puerto Rico | Salinas | 72123 | 6622 | 0 | 0 | 18.010387 | -66.256592 | 2022-09-23 04:23:13 | Salinas, Puerto Rico, US | |
2019746 | 2019746 | 2022-09-20 | US | Texas | Austin | 48015 | 6622 | 81 | 0 | 29.88548725 | -96.27736949 | 2022-09-21 04:23:22 | Austin, Texas, US | |
3573619 | 3573619 | 2022-09-19 | US | Texas | Austin | 48015 | 6622 | 81 | 0 | 29.88548725 | -96.27736949 | 2022-09-20 04:22:48 | Austin, Texas, US | |
2715760 | 2715760 | 2022-09-03 | US | Puerto Rico | Utuado | 72141 | 6622 | 0 | 0 | 18.271214 | -66.702984 | 2022-09-04 04:21:22 | Utuado, Puerto Rico, US | |
2419532 | 2419532 | 2022-07-15 | US | Colorado | Montezuma | 8083 | 6622 | 83 | 0 | 37.33859579 | -108.5958857 | 2022-07-16 04:21:05 | Montezuma, Colorado, US | |
632334 | 632334 | 2022-07-12 | US | North Dakota | Rolette | 38079 | 6622 | 43 | 0 | 48.77245354 | -99.84097493 | 2022-07-13 04:20:58 | Rolette, North Dakota, US | |
2151018 | 2151018 | 2022-06-27 | US | Virginia | Mecklenburg | 51117 | 6622 | 123 | 0 | 36.67882005 | -78.36131056 | 2022-06-28 04:20:58 | Mecklenburg, Virginia, US | |
1111311 | 1111311 | 2022-05-21 | US | Minnesota | Le Sueur | 27079 | 6622 | 51 | 0 | 44.37136597 | -93.72844721 | 2022-05-22 04:20:52 | Le Sueur, Minnesota, US | |
1110942 | 1110942 | 2022-05-21 | US | Kentucky | Allen | 21003 | 6622 | 108 | 0 | 36.75197631 | -86.19457544 | 2022-05-22 04:20:52 | Allen, Kentucky, US | |
1170935 | 1170935 | 2022-05-20 | US | Minnesota | Le Sueur | 27079 | 6622 | 51 | 0 | 44.37136597 | -93.72844721 | 2022-05-21 04:20:58 | Le Sueur, Minnesota, US | |
1170566 | 1170566 | 2022-05-20 | US | Kentucky | Allen | 21003 | 6622 | 108 | 0 | 36.75197631 | -86.19457544 | 2022-05-21 04:20:58 | Allen, Kentucky, US | |
3897329 | 3897329 | 2022-05-19 | US | Kentucky | Allen | 21003 | 6622 | 108 | 0 | 36.75197631 | -86.19457544 | 2022-05-20 04:20:57 | Allen, Kentucky, US | |
1186113 | 1186113 | 2022-05-18 | US | Kentucky | Allen | 21003 | 6622 | 108 | 0 | 36.75197631 | -86.19457544 | 2022-05-19 04:20:54 | Allen, Kentucky, US | |
1185728 | 1185728 | 2022-05-18 | US | Illinois | Douglas | 17041 | 6622 | 55 | 0 | 39.76768052 | -88.21854195 | 2022-05-19 04:20:54 | Douglas, Illinois, US | |
3584010 | 3584010 | 2022-05-17 | US | Kentucky | Allen | 21003 | 6622 | 108 | 0 | 36.75197631 | -86.19457544 | 2022-05-18 04:20:50 | Allen, Kentucky, US | |
1504967 | 1504967 | 2022-05-16 | US | Kentucky | Allen | 21003 | 6622 | 108 | 0 | 36.75197631 | -86.19457544 | 2022-05-17 04:20:59 | Allen, Kentucky, US | |
3445392 | 3445392 | 2022-05-11 | US | California | Glenn | 6021 | 6622 | 48 | 0 | 39.59875897 | -122.3938452 | 2022-05-12 04:20:54 | Glenn, California, US | |
3536009 | 3536009 | 2022-05-10 | US | California | Glenn | 6021 | 6622 | 48 | 0 | 39.59875897 | -122.3938452 | 2022-05-11 04:20:48 | Glenn, California, US | |
3207040 | 3207040 | 2022-04-11 | US | Georgia | Chattooga | 13055 | 6622 | 132 | 0 | 34.47197698 | -85.34535662 | 2022-04-12 04:20:49 | Chattooga, Georgia, US | |
946318 | 946318 | 2022-02-28 | US | West Virginia | Hancock | 54029 | 6622 | 135 | 0 | 40.51943859 | -80.57461608 | 2022-03-01 04:21:09 | Hancock, West Virginia, US | |
3858918 | 3858918 | 2022-02-18 | US | Texas | Fannin | 48147 | 6622 | 170 | 0 | 33.59564294 | -96.10751083 | 2022-02-19 04:21:11 | Fannin, Texas, US | |
1365750 | 1365750 | 2022-02-08 | US | Virginia | Pulaski | 51155 | 6622 | 115 | 0 | 37.06474963 | -80.71229738 | 2022-02-09 04:21:04 | Pulaski, Virginia, US | |
2052531 | 2052531 | 2022-01-25 | US | Colorado | Pitkin | 8097 | 6622 | 7 | 0 | 39.21720112 | -106.9310027 | 2022-01-26 04:21:07 | Pitkin, Colorado, US | |
1144323 | 1144323 | 2022-01-23 | US | Virginia | Smyth | 51173 | 6622 | 142 | 0 | 36.84455636 | -81.53344948 | 2022-01-24 04:21:12 | Smyth, Virginia, US | |
2836241 | 2836241 | 2022-01-22 | US | Virginia | Smyth | 51173 | 6622 | 142 | 0 | 36.84455636 | -81.53344948 | 2022-01-23 04:21:13 | Smyth, Virginia, US | |
3428359 | 3428359 | 2022-01-21 | US | Virginia | Smyth | 51173 | 6622 | 142 | 0 | 36.84455636 | -81.53344948 | 2022-01-22 04:21:13 | Smyth, Virginia, US | |
3467139 | 3467139 | 2022-01-18 | US | Tennessee | Lauderdale | 47097 | 6622 | 82 | 0 | 35.75893438 | -89.63015909999999 | 2022-01-19 04:21:23 | Lauderdale, Tennessee, US | |
1474579 | 1474579 | 2022-01-17 | US | Ohio | Fayette | 39047 | 6622 | 105 | 0 | 39.56021306 | -83.4562016 | 2022-01-18 04:21:04 | Fayette, Ohio, US | |
1703721 | 1703721 | 2022-01-03 | US | Virginia | Manassas | 51683 | 6622 | 57 | 0 | 38.7464321 | -77.48509905 | 2022-01-04 04:22:17 | Manassas, Virginia, US | |
3521934 | 3521934 | 2022-01-02 | US | Ohio | Ottawa | 39123 | 6622 | 124 | 0 | 41.53781826 | -83.0940185 | 2022-01-03 02:22:25 | Ottawa, Ohio, US | |
3605730 | 3605730 | 2021-12-25 | US | Colorado | Summit | 8117 | 6622 | 12 | 0 | 39.63803232 | -106.1150762 | 2021-12-26 04:21:50 | Summit, Colorado, US | |
1718862 | 1718862 | 2021-12-16 | US | Ohio | Preble | 39135 | 6622 | 152 | 0 | 39.7420247 | -84.64787018 | 2021-12-17 04:22:14 | Preble, Ohio, US | |
1662809 | 1662809 | 2021-12-12 | US | North Carolina | Yadkin | 37197 | 6622 | 76 | 0 | 36.16222629 | -80.66239436 | 2021-12-13 04:22:02 | Yadkin, North Carolina, US | |
1666825 | 1666825 | 2021-12-11 | US | North Carolina | Yadkin | 37197 | 6622 | 76 | 0 | 36.16222629 | -80.66239436 | 2021-12-12 04:22:12 | Yadkin, North Carolina, US | |
3657977 | 3657977 | 2021-12-10 | US | North Carolina | Yadkin | 37197 | 6622 | 76 | 0 | 36.16222629 | -80.66239436 | 2021-12-11 04:22:45 | Yadkin, North Carolina, US | |
904686 | 904686 | 2021-11-24 | US | Arkansas | Miller | 5091 | 6622 | 143 | 0 | 33.31403423 | -93.89285258 | 2021-11-25 04:22:33 | Miller, Arkansas, US | |
449616 | 449616 | 2021-11-17 | US | New York | Livingston | 36051 | 6622 | 72 | 0 | 42.72596275 | -77.77966158 | 2021-11-18 04:21:33 | Livingston, New York, US | |
31687 | 31687 | 2021-11-11 | US | Utah | Southeast Utah | 6622 | 49 | 0 | 38.99617072 | -110.70139579999999 | 2021-11-12 04:22:01 | Southeast Utah, Utah, US | ||
2848126 | 2848126 | 2021-11-10 | US | Utah | Southeast Utah | 6622 | 49 | 0 | 38.99617072 | -110.70139579999999 | 2021-11-11 04:21:45 | Southeast Utah, Utah, US | ||
604015 | 604015 | 2021-09-23 | US | North Carolina | Haywood | 37087 | 6622 | 127 | 0 | 35.55269063 | -82.98196486 | 2021-09-24 04:21:44 | Haywood, North Carolina, US | |
19280 | 19280 | 2021-09-18 | US | Tennessee | Cocke | 47029 | 6622 | 103 | 0 | 35.9278914 | -83.11828725 | 2021-09-19 04:21:34 | Cocke, Tennessee, US | |
2620261 | 2620261 | 2021-09-17 | US | New York | Cattaraugus | 36009 | 6622 | 96 | 0 | 42.24778241 | -78.67923096 | 2021-09-18 04:21:24 | Cattaraugus, New York, US | |
179969 | 179969 | 2021-09-02 | US | Missouri | Pettis | 29159 | 6622 | 88 | 0 | 38.72798918 | -93.28471706 | 2021-09-03 04:21:20 | Pettis, Missouri, US | |
2796214 | 2796214 | 2021-08-28 | US | Texas | Nacogdoches | 48347 | 6622 | 182 | 0 | 31.62017125 | -94.61803994 | 2021-08-29 04:21:14 | Nacogdoches, Texas, US | |
334852 | 334852 | 2021-08-04 | US | Tennessee | Hawkins | 47073 | 6622 | 117 | 0 | 36.44355426 | -82.94885298 | 2021-08-05 04:21:51 | Hawkins, Tennessee, US | |
296628 | 296628 | 2021-07-15 | US | Colorado | Fremont | 8043 | 6622 | 64 | 0 | 38.47362326 | -105.4399667 | 2021-07-16 04:21:22 | Fremont, Colorado, US | |
1125529 | 1125529 | 2021-06-18 | Iceland | 6622 | 30 | 6476 | 116 | 64.9631 | -19.0208 | 2021-06-19 04:22:33 | Iceland | |||
2911107 | 2911107 | 2021-06-17 | Iceland | 6622 | 30 | 6476 | 116 | 64.9631 | -19.0208 | 2021-06-18 04:22:16 | Iceland | |||
525120 | 525120 | 2021-06-09 | US | New York | St. Lawrence | 36089 | 6622 | 96 | 0 | 44.4976179 | -75.06550039 | 2021-06-10 04:23:17 | St. Lawrence, New York, US | |
3475596 | 3475596 | 2021-06-08 | US | Virginia | Bedford | 51019 | 6622 | 109 | 0 | 37.3080028 | -79.5281964 | 2021-06-09 04:23:31 | Bedford, Virginia, US | |
20704 | 20704 | 2021-05-28 | Timor-Leste | 6622 | 15 | 3915 | 2692 | -8.874217 | 125.727539 | 2021-05-29 04:20:41 | Timor-Leste | |||
1809678 | 1809678 | 2021-05-27 | US | Tennessee | Gibson | 47053 | 6622 | 145 | 0 | 35.99438059 | -88.93358327 | 2021-05-28 04:20:36 | Gibson, Tennessee, US | |
84573 | 84573 | 2021-05-25 | US | Louisiana | Acadia | 22001 | 6622 | 195 | 0 | 30.2950649 | -92.41419698 | 2021-05-26 04:20:35 | Acadia, Louisiana, US | |
646908 | 646908 | 2021-05-05 | US | Illinois | Boone | 17007 | 6622 | 71 | 0 | 42.32359279 | -88.82345779 | 2021-05-06 04:20:38 | Boone, Illinois, US | |
1982114 | 1982114 | 2021-03-25 | US | Louisiana | Iberia | 22045 | 6622 | 150 | 0 | 29.86803617 | -91.75871777 | 2021-03-26 05:26:55 | Iberia, Louisiana, US | |
703343 | 703343 | 2021-03-16 | US | Idaho | Madison | 16065 | 6622 | 22 | 0 | 43.78141028 | -111.65384740000002 | 2021-03-17 05:25:07 | Madison, Idaho, US | |
2184727 | 2184727 | 2021-02-26 | US | Indiana | Wayne | 18177 | 6622 | 191 | 0 | 6431 | 39.8633444 | -85.01044989 | 2021-02-27 05:22:28 | Wayne, Indiana, US |
473163 | 473163 | 2021-02-19 | US | Minnesota | Rice | 27131 | 6622 | 89 | 0 | 6533 | 44.3543376 | -93.29658715 | 2021-02-20 05:22:51 | Rice, Minnesota, US |
1673509 | 1673509 | 2021-02-07 | US | Illinois | Williamson | 17199 | 6622 | 115 | 0 | 6507 | 37.73033511 | -88.92994027 | 2021-02-08 05:22:39 | Williamson, Illinois, US |
2213816 | 2213816 | 2021-01-30 | US | New Hampshire | Merrimack | 33013 | 6622 | 93 | 0 | 6529 | 43.29662971 | -71.6811573 | 2021-01-31 05:22:42 | Merrimack, New Hampshire, US |
1898230 | 1898230 | 2021-01-29 | US | Indiana | Floyd | 18043 | 6622 | 143 | 0 | 6479 | 38.32117957 | -85.90385377 | 2021-01-30 05:22:49 | Floyd, Indiana, US |
1760862 | 1760862 | 2021-01-24 | US | Maryland | Carroll | 24013 | 6622 | 188 | 0 | 6434 | 39.56453592 | -77.02373735 | 2021-01-25 05:22:16 | Carroll, Maryland, US |
3150028 | 3150028 | 2020-12-16 | US | Arizona | Apache | 4001 | 6622 | 212 | 0 | 6410 | 35.39465006 | -109.4892383 | 2020-12-17 05:28:12 | Apache, Arizona, US |
1037915 | 1037915 | 2020-12-15 | US | Wisconsin | Jefferson | 55055 | 6622 | 50 | 0 | 6572 | 43.02054068 | -88.77529134 | 2020-12-16 05:28:04 | Jefferson, Wisconsin, US |
3850088 | 3850088 | 2020-12-13 | US | North Carolina | Davidson | 37057 | 6622 | 58 | 0 | 6564 | 35.79115496 | -80.21256572 | 2020-12-14 05:26:27 | Davidson, North Carolina, US |
862959 | 862959 | 2020-12-11 | US | North Carolina | Buncombe | 37021 | 6622 | 133 | 0 | 6489 | 35.61113393 | -82.53305 | 2020-12-12 05:26:19 | Buncombe, North Carolina, US |
3171959 | 3171959 | 2020-11-16 | US | North Carolina | Johnston | 37101 | 6622 | 70 | 0 | 6552 | 35.51745004 | -78.36622717 | 2020-11-17 05:25:54 | Johnston, North Carolina, US |
272831 | 272831 | 2020-11-10 | US | Florida | Clay | 12019 | 6622 | 133 | 0 | 6489 | 29.98319144 | -81.85609986 | 2020-11-11 05:25:30 | Clay, Florida, US |
3990844 | 3990844 | 2020-10-20 | Russia | Pskov Oblast | 6622 | 67 | 4393 | 2162 | 57.5358729 | 28.8586826 | 2020-10-21 04:24:14 | Pskov Oblast, Russia | ||
1355011 | 1355011 | 2020-09-03 | US | Florida | Lake | 12069 | 6622 | 126 | 0 | 6496 | 28.76202069 | -81.7125123 | 2020-09-04 04:28:26 | Lake, Florida, US |
1105487 | 1105487 | 2020-09-02 | Hungary | 6622 | 619 | 3903 | 2100 | 47.1625 | 19.5033 | 2020-09-03 04:28:22 | Hungary | |||
3531521 | 3531521 | 2020-08-12 | Mauritania | 6622 | 157 | 5741 | 724 | 21.0079 | -10.9408 | 2020-08-13 04:29:15 | Mauritania |
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]);