johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
76 rows where confirmed = 9831 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
331373 | 331373 | 2022-12-27 | US | Washington | Stevens | 53065 | 9831 | 163 | 0 | 48.40035475 | -117.8542701 | 2022-12-28 04:21:04 | Stevens, Washington, US | |
221446 | 221446 | 2022-12-26 | US | Washington | Stevens | 53065 | 9831 | 163 | 0 | 48.40035475 | -117.8542701 | 2022-12-27 04:21:07 | Stevens, Washington, US | |
3225903 | 3225903 | 2022-12-25 | US | Washington | Stevens | 53065 | 9831 | 163 | 0 | 48.40035475 | -117.8542701 | 2022-12-26 04:21:06 | Stevens, Washington, US | |
1021817 | 1021817 | 2022-12-24 | US | Washington | Stevens | 53065 | 9831 | 163 | 0 | 48.40035475 | -117.8542701 | 2022-12-25 04:21:04 | Stevens, Washington, US | |
1020587 | 1020587 | 2022-12-24 | US | New York | Delaware | 36025 | 9831 | 87 | 0 | 42.19837623 | -74.96709306 | 2022-12-25 04:21:04 | Delaware, New York, US | |
693840 | 693840 | 2022-12-23 | US | Washington | Stevens | 53065 | 9831 | 163 | 0 | 48.40035475 | -117.8542701 | 2022-12-24 04:21:02 | Stevens, Washington, US | |
2183050 | 2183050 | 2022-12-22 | US | Washington | Stevens | 53065 | 9831 | 163 | 0 | 48.40035475 | -117.8542701 | 2022-12-23 04:21:04 | Stevens, Washington, US | |
454854 | 454854 | 2022-12-21 | US | Washington | Stevens | 53065 | 9831 | 163 | 0 | 48.40035475 | -117.8542701 | 2022-12-22 04:20:56 | Stevens, Washington, US | |
1833125 | 1833125 | 2022-10-25 | US | Tennessee | Macon | 47111 | 9831 | 157 | 0 | 36.53157855 | -86.00778595 | 2022-10-26 04:22:19 | Macon, Tennessee, US | |
3100615 | 3100615 | 2022-10-09 | US | Texas | Matagorda | 48321 | 9831 | 184 | 0 | 28.81955746 | -96.01230294 | 2022-10-10 04:22:32 | Matagorda, Texas, US | |
4005840 | 4005840 | 2022-10-08 | US | Texas | Matagorda | 48321 | 9831 | 184 | 0 | 28.81955746 | -96.01230294 | 2022-10-09 04:21:16 | Matagorda, Texas, US | |
399437 | 399437 | 2022-10-07 | US | Texas | Matagorda | 48321 | 9831 | 184 | 0 | 28.81955746 | -96.01230294 | 2022-10-08 04:22:56 | Matagorda, Texas, US | |
3997314 | 3997314 | 2022-09-27 | US | Pennsylvania | Greene | 42059 | 9831 | 112 | 0 | 39.85746531 | -80.22357106 | 2022-09-28 04:23:01 | Greene, Pennsylvania, US | |
2771642 | 2771642 | 2022-09-26 | US | Pennsylvania | Greene | 42059 | 9831 | 112 | 0 | 39.85746531 | -80.22357106 | 2022-09-27 04:23:01 | Greene, Pennsylvania, US | |
1979295 | 1979295 | 2022-09-25 | US | Pennsylvania | Greene | 42059 | 9831 | 112 | 0 | 39.85746531 | -80.22357106 | 2022-09-26 04:20:52 | Greene, Pennsylvania, US | |
2652462 | 2652462 | 2022-09-24 | US | Pennsylvania | Greene | 42059 | 9831 | 112 | 0 | 39.85746531 | -80.22357106 | 2022-09-25 04:23:31 | Greene, Pennsylvania, US | |
386902 | 386902 | 2022-09-23 | US | Pennsylvania | Greene | 42059 | 9831 | 112 | 0 | 39.85746531 | -80.22357106 | 2022-09-24 04:21:40 | Greene, Pennsylvania, US | |
1626968 | 1626968 | 2022-09-22 | US | Pennsylvania | Greene | 42059 | 9831 | 112 | 0 | 39.85746531 | -80.22357106 | 2022-09-23 04:23:13 | Greene, Pennsylvania, US | |
1373172 | 1373172 | 2022-09-21 | US | Pennsylvania | Greene | 42059 | 9831 | 112 | 0 | 39.85746531 | -80.22357106 | 2022-09-22 04:22:56 | Greene, Pennsylvania, US | |
2017976 | 2017976 | 2022-09-20 | US | Iowa | Wapello | 19179 | 9831 | 213 | 0 | 41.03064984 | -92.40954728 | 2022-09-21 04:23:22 | Wapello, Iowa, US | |
3571849 | 3571849 | 2022-09-19 | US | Iowa | Wapello | 19179 | 9831 | 213 | 0 | 41.03064984 | -92.40954728 | 2022-09-20 04:22:48 | Wapello, Iowa, US | |
420588 | 420588 | 2022-09-18 | US | Iowa | Wapello | 19179 | 9831 | 213 | 0 | 41.03064984 | -92.40954728 | 2022-09-19 04:21:49 | Wapello, Iowa, US | |
3374612 | 3374612 | 2022-09-17 | US | Iowa | Wapello | 19179 | 9831 | 213 | 0 | 41.03064984 | -92.40954728 | 2022-09-18 04:22:50 | Wapello, Iowa, US | |
2356720 | 2356720 | 2022-09-16 | US | Iowa | Wapello | 19179 | 9831 | 213 | 0 | 41.03064984 | -92.40954728 | 2022-09-17 04:20:19 | Wapello, Iowa, US | |
3987877 | 3987877 | 2022-09-15 | US | Iowa | Wapello | 19179 | 9831 | 213 | 0 | 41.03064984 | -92.40954728 | 2022-09-16 04:21:19 | Wapello, Iowa, US | |
1890394 | 1890394 | 2022-09-14 | US | Iowa | Wapello | 19179 | 9831 | 213 | 0 | 41.03064984 | -92.40954728 | 2022-09-15 04:21:02 | Wapello, Iowa, US | |
899399 | 899399 | 2022-07-24 | US | Texas | Washington | 48477 | 9831 | 149 | 0 | 30.21498498 | -96.40946246 | 2022-07-25 04:20:51 | Washington, Texas, US | |
230385 | 230385 | 2022-05-31 | US | Indiana | Whitley | 18183 | 9831 | 85 | 0 | 41.13863784 | -85.50791236 | 2022-06-01 04:20:55 | Whitley, Indiana, US | |
3187150 | 3187150 | 2022-05-30 | US | Indiana | Whitley | 18183 | 9831 | 85 | 0 | 41.13863784 | -85.50791236 | 2022-05-31 04:20:51 | Whitley, Indiana, US | |
3199299 | 3199299 | 2022-05-29 | US | Indiana | Whitley | 18183 | 9831 | 85 | 0 | 41.13863784 | -85.50791236 | 2022-05-30 04:20:50 | Whitley, Indiana, US | |
2726177 | 2726177 | 2022-05-28 | US | Indiana | Whitley | 18183 | 9831 | 85 | 0 | 41.13863784 | -85.50791236 | 2022-05-29 04:20:53 | Whitley, Indiana, US | |
1315358 | 1315358 | 2022-05-27 | US | Indiana | Whitley | 18183 | 9831 | 85 | 0 | 41.13863784 | -85.50791236 | 2022-05-28 04:21:07 | Whitley, Indiana, US | |
2308852 | 2308852 | 2022-04-20 | US | Maine | Somerset | 23025 | 9831 | 103 | 0 | 45.51229767 | -69.95995554 | 2022-04-21 04:20:46 | Somerset, Maine, US | |
3238883 | 3238883 | 2022-03-21 | US | California | Lassen | 6035 | 9831 | 63 | 0 | 40.67311306 | -120.59350990000002 | 2022-03-22 04:20:54 | Lassen, California, US | |
2140547 | 2140547 | 2022-03-09 | US | Alabama | Franklin | 1059 | 9831 | 137 | 0 | 34.44235334 | -87.84289505 | 2022-03-10 04:20:48 | Franklin, Alabama, US | |
1551571 | 1551571 | 2022-03-07 | US | Wyoming | Albany | 56001 | 9831 | 47 | 0 | 41.65498705 | -105.72354150000001 | 2022-03-08 04:20:54 | Albany, Wyoming, US | |
3721505 | 3721505 | 2022-02-21 | US | Virginia | Charlottesville | 51540 | 9831 | 67 | 0 | 38.03527919 | -78.48569588 | 2022-02-22 04:21:01 | Charlottesville, Virginia, US | |
1229576 | 1229576 | 2022-01-24 | US | Missouri | Scott | 29201 | 9831 | 140 | 0 | 37.05588075 | -89.56474493 | 2022-01-25 04:21:05 | Scott, Missouri, US | |
101571 | 101571 | 2022-01-14 | US | New York | Livingston | 36051 | 9831 | 97 | 0 | 42.72596275 | -77.77966158 | 2022-01-15 04:21:07 | Livingston, New York, US | |
2612370 | 2612370 | 2022-01-06 | US | North Carolina | Granville | 37077 | 9831 | 107 | 0 | 36.30337451 | -78.65184241 | 2022-01-07 04:22:09 | Granville, North Carolina, US | |
731559 | 731559 | 2021-12-27 | US | Illinois | Ogle | 17141 | 9831 | 110 | 0 | 42.04165196 | -89.32184679 | 2021-12-28 04:21:47 | Ogle, Illinois, US | |
3819532 | 3819532 | 2021-12-23 | US | Texas | Hardin | 48199 | 9831 | 215 | 0 | 30.33364686 | -94.38931817 | 2021-12-24 04:21:34 | Hardin, Texas, US | |
1259406 | 1259406 | 2021-12-18 | US | Colorado | Eagle | 8037 | 9831 | 32 | 0 | 39.62754308 | -106.6933637 | 2021-12-19 04:21:11 | Eagle, Colorado, US | |
554307 | 554307 | 2021-12-08 | US | Wisconsin | Calumet | 55015 | 9831 | 73 | 0 | 44.0816316 | -88.21780273 | 2021-12-09 04:22:49 | Calumet, Wisconsin, US | |
702079 | 702079 | 2021-11-04 | Yemen | 9831 | 1901 | 0 | 15.552726999999999 | 48.516388 | 2021-11-05 04:21:54 | Yemen | ||||
683253 | 683253 | 2021-10-24 | US | Hawaii | Maui | 15009 | 9831 | 94 | 0 | 20.86399628 | -156.56890969999995 | 2021-10-25 04:22:31 | Maui, Hawaii, US | |
1895830 | 1895830 | 2021-06-30 | US | Pennsylvania | Northumberland | 42097 | 9831 | 360 | 0 | 40.84785433 | -76.70798222 | 2021-07-01 04:21:19 | Northumberland, Pennsylvania, US | |
2593583 | 2593583 | 2021-06-27 | US | Wisconsin | St. Croix | 55109 | 9831 | 67 | 0 | 45.03437474 | -92.45000068 | 2021-06-28 04:21:29 | St. Croix, Wisconsin, US | |
3962087 | 3962087 | 2021-06-26 | US | Wisconsin | St. Croix | 55109 | 9831 | 67 | 0 | 45.03437474 | -92.45000068 | 2021-06-27 04:21:39 | St. Croix, Wisconsin, US | |
1715906 | 1715906 | 2021-06-25 | US | Wisconsin | St. Croix | 55109 | 9831 | 67 | 0 | 45.03437474 | -92.45000068 | 2021-06-26 04:21:43 | St. Croix, Wisconsin, US | |
21774 | 21774 | 2021-05-28 | US | Kentucky | Hardin | 21093 | 9831 | 158 | 0 | 37.6976111 | -85.96319251 | 2021-05-29 04:20:41 | Hardin, Kentucky, US | |
1415210 | 1415210 | 2021-05-24 | US | New Hampshire | Strafford | 33017 | 9831 | 90 | 0 | 43.291833 | -71.02336013 | 2021-05-25 04:21:08 | Strafford, New Hampshire, US | |
2007641 | 2007641 | 2021-05-12 | US | Tennessee | Robertson | 47147 | 9831 | 132 | 0 | 36.52454807 | -86.87346725 | 2021-05-13 04:20:51 | Robertson, Tennessee, US | |
1638603 | 1638603 | 2021-04-29 | US | North Carolina | Burke | 37023 | 9831 | 152 | 0 | 35.74989637 | -81.70755735 | 2021-04-30 04:21:03 | Burke, North Carolina, US | |
888865 | 888865 | 2021-04-26 | US | Georgia | Barrow | 13013 | 9831 | 134 | 0 | 33.99148694 | -83.71436292 | 2021-04-27 04:20:52 | Barrow, Georgia, US | |
3005121 | 3005121 | 2021-04-06 | US | Mississippi | Lee | 28081 | 9831 | 169 | 0 | 34.291877500000005 | -88.68149954 | 2021-04-07 04:20:53 | Lee, Mississippi, US | |
243137 | 243137 | 2021-04-02 | US | Missouri | Clay | 29047 | 9831 | 159 | 0 | 39.31132056 | -94.41850862 | 2021-04-03 04:20:44 | Clay, Missouri, US | |
243075 | 243075 | 2021-04-02 | US | Mississippi | Madison | 28089 | 9831 | 208 | 0 | 32.63389156 | -90.03513564 | 2021-04-03 04:20:44 | Madison, Mississippi, US | |
3369692 | 3369692 | 2021-03-21 | US | Alabama | Elmore | 1051 | 9831 | 198 | 0 | 32.59785413 | -86.14415284 | 2021-03-22 05:25:43 | Elmore, Alabama, US | |
3422151 | 3422151 | 2021-03-19 | US | Iowa | Story | 19169 | 9831 | 46 | 0 | 42.03621213 | -93.46499005 | 2021-03-20 05:25:46 | Story, Iowa, US | |
3964912 | 3964912 | 2021-03-10 | US | North Dakota | Grand Forks | 38035 | 9831 | 76 | 0 | 47.92093639 | -97.45450447 | 2021-03-11 05:25:48 | Grand Forks, North Dakota, US | |
54758 | 54758 | 2021-03-07 | India | Ladakh | 9831 | 130 | 9657 | 44 | 34.1526 | 77.5771 | 2021-03-08 05:24:48 | Ladakh, India | ||
3668721 | 3668721 | 2021-03-06 | US | Indiana | LaPorte | 18091 | 9831 | 199 | 0 | 9632 | 41.54366008 | -86.74072188 | 2021-03-07 05:21:54 | LaPorte, Indiana, US |
1761497 | 1761497 | 2021-01-24 | US | New Mexico | Sandoval | 35043 | 9831 | 168 | 0 | 9663 | 35.68862401 | -106.8687803 | 2021-01-25 05:22:16 | Sandoval, New Mexico, US |
3517919 | 3517919 | 2021-01-15 | US | Ohio | Wood | 39173 | 9831 | 159 | 0 | 9672 | 41.36224827 | -83.62285108 | 2021-01-16 05:22:40 | Wood, Ohio, US |
192874 | 192874 | 2021-01-11 | US | South Carolina | Dorchester | 45035 | 9831 | 131 | 0 | 9700 | 33.0794369 | -80.40502652 | 2021-01-12 05:22:15 | Dorchester, South Carolina, US |
3861461 | 3861461 | 2020-12-04 | US | Michigan | Ingham | 26065 | 9831 | 124 | 0 | 9707 | 42.59716886 | -84.37472069 | 2020-12-05 05:27:36 | Ingham, Michigan, US |
395489 | 395489 | 2020-11-27 | US | Utah | Bear River | 9831 | 30 | 0 | 9801 | 41.52106798 | -113.0832816 | 2020-11-28 05:25:50 | Bear River, Utah, US | |
823675 | 823675 | 2020-11-19 | US | Nebraska | Sarpy | 31153 | 9831 | 52 | 0 | 9779 | 41.11314181 | -96.11156432 | 2020-11-20 05:26:28 | Sarpy, Nebraska, US |
376732 | 376732 | 2020-11-06 | US | California | Merced | 6047 | 9831 | 157 | 0 | 9674 | 37.18922369 | -120.7209035 | 2020-11-07 05:24:52 | Merced, California, US |
754500 | 754500 | 2020-10-28 | Russia | Kabardino-Balkarian Republic | 9831 | 134 | 7326 | 2371 | 43.4806048 | 43.5978976 | 2020-10-29 04:24:49 | Kabardino-Balkarian Republic, Russia | ||
3786608 | 3786608 | 2020-10-11 | US | Florida | Pasco | 12101 | 9831 | 216 | 0 | 9615 | 28.30810945 | -82.40227529 | 2020-10-12 04:23:45 | Pasco, Florida, US |
2812642 | 2812642 | 2020-09-25 | France | French Guiana | 9831 | 65 | 9472 | 294 | 4.0 | -53.0 | 2020-09-26 04:23:00 | French Guiana, France | ||
814135 | 814135 | 2020-09-05 | US | California | San Francisco | 6075 | 9831 | 85 | 0 | 9746 | 37.75215114 | -122.4385672 | 2020-09-06 04:28:33 | San Francisco, California, US |
845036 | 845036 | 2020-07-22 | Russia | Yamalo-Nenets Autonomous Okrug | 9831 | 68 | 4931 | 4832 | 67.1471631 | 74.3415488 | 2020-07-23 05:15:04 | Yamalo-Nenets Autonomous Okrug, Russia | ||
1281452 | 1281452 | 2020-06-04 | Algeria | 9831 | 681 | 6297 | 2853 | 28.0339 | 1.6596 | 2020-06-05 02:33:06 | Algeria |
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]);