johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
65 rows where confirmed = 7801 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2418305 | 2418305 | 2022-12-05 | US | Virginia | Winchester | 51840 | 7801 | 92 | 0 | 39.17054517 | -78.17325058 | 2022-12-06 04:21:03 | Winchester, Virginia, US | |
374632 | 374632 | 2022-09-13 | US | North Dakota | Stutsman | 38093 | 7801 | 97 | 0 | 46.97962541 | -98.95637318 | 2022-09-14 04:20:44 | Stutsman, North Dakota, US | |
1087596 | 1087596 | 2022-08-09 | US | Louisiana | Morehouse | 22067 | 7801 | 136 | 0 | 32.81686191 | -91.80421614 | 2022-08-10 04:20:57 | Morehouse, Louisiana, US | |
630845 | 630845 | 2022-07-12 | US | Idaho | Elmore | 16039 | 7801 | 70 | 0 | 43.3507101 | -115.4701578 | 2022-07-13 04:20:58 | Elmore, Idaho, US | |
1212489 | 1212489 | 2022-07-11 | US | Idaho | Elmore | 16039 | 7801 | 70 | 0 | 43.3507101 | -115.4701578 | 2022-07-12 04:20:51 | Elmore, Idaho, US | |
2241590 | 2241590 | 2022-06-28 | US | New Mexico | Cibola | 35006 | 7801 | 197 | 0 | 34.91131525 | -107.998876 | 2022-06-29 04:20:59 | Cibola, New Mexico, US | |
1423841 | 1423841 | 2022-06-08 | US | Puerto Rico | Corozal | 72047 | 7801 | 0 | 0 | 18.304264 | -66.327738 | 2022-06-09 04:20:54 | Corozal, Puerto Rico, US | |
1423829 | 1423829 | 2022-06-08 | US | Puerto Rico | Cabo Rojo | 72023 | 7801 | 0 | 0 | 18.040993 | -67.154391 | 2022-06-09 04:20:54 | Cabo Rojo, Puerto Rico, US | |
3000206 | 3000206 | 2022-05-24 | US | Georgia | Wayne | 13305 | 7801 | 205 | 0 | 31.5521809 | -81.91894878 | 2022-05-25 04:20:56 | Wayne, Georgia, US | |
3593927 | 3593927 | 2022-05-23 | US | Georgia | Wayne | 13305 | 7801 | 205 | 0 | 31.5521809 | -81.91894878 | 2022-05-24 04:20:57 | Wayne, Georgia, US | |
1110475 | 1110475 | 2022-05-21 | US | Georgia | Wayne | 13305 | 7801 | 205 | 0 | 31.5521809 | -81.91894878 | 2022-05-22 04:20:52 | Wayne, Georgia, US | |
1170099 | 1170099 | 2022-05-20 | US | Georgia | Wayne | 13305 | 7801 | 205 | 0 | 31.5521809 | -81.91894878 | 2022-05-21 04:20:58 | Wayne, Georgia, US | |
3896862 | 3896862 | 2022-05-19 | US | Georgia | Wayne | 13305 | 7801 | 205 | 0 | 31.5521809 | -81.91894878 | 2022-05-20 04:20:57 | Wayne, Georgia, US | |
3896505 | 3896505 | 2022-05-19 | US | California | Calaveras | 6009 | 7801 | 120 | 0 | 38.20537103 | -120.552913 | 2022-05-20 04:20:57 | Calaveras, California, US | |
1185646 | 1185646 | 2022-05-18 | US | Georgia | Wayne | 13305 | 7801 | 205 | 0 | 31.5521809 | -81.91894878 | 2022-05-19 04:20:54 | Wayne, Georgia, US | |
2118958 | 2118958 | 2022-04-08 | US | Texas | Upshur | 48459 | 7801 | 182 | 0 | 32.73706798 | -94.93999853 | 2022-04-09 04:20:42 | Upshur, Texas, US | |
1908394 | 1908394 | 2022-03-22 | US | Texas | Polk | 48373 | 7801 | 247 | 0 | 30.79472531 | -94.82766240000001 | 2022-03-23 04:20:48 | Polk, Texas, US | |
2734160 | 2734160 | 2022-02-27 | US | Indiana | Scott | 18143 | 7801 | 97 | 0 | 38.68672078 | -85.74627859 | 2022-02-28 04:21:05 | Scott, Indiana, US | |
3047313 | 3047313 | 2022-02-26 | US | Indiana | Scott | 18143 | 7801 | 97 | 0 | 38.68672078 | -85.74627859 | 2022-02-27 04:21:04 | Scott, Indiana, US | |
575968 | 575968 | 2022-02-25 | US | Indiana | Scott | 18143 | 7801 | 97 | 0 | 38.68672078 | -85.74627859 | 2022-02-26 04:21:12 | Scott, Indiana, US | |
2659489 | 2659489 | 2022-01-31 | US | Minnesota | Becker | 27005 | 7801 | 85 | 0 | 46.93479392 | -95.67158144 | 2022-02-01 04:21:11 | Becker, Minnesota, US | |
1318809 | 1318809 | 2022-01-26 | US | California | Unassigned | 90006 | 7801 | 3 | 0 | 41.74228275 | 0.0 | 2022-01-27 04:21:19 | Unassigned, California, US | |
2832681 | 2832681 | 2022-01-22 | Comoros | 7801 | 159 | 0 | -11.6455 | 43.3333 | 2022-01-23 04:21:13 | Comoros | ||||
1671867 | 1671867 | 2021-12-29 | US | Virginia | Shenandoah | 51171 | 7801 | 185 | 0 | 38.85905135 | -78.56813762 | 2021-12-30 04:21:25 | Shenandoah, Virginia, US | |
1234072 | 1234072 | 2021-11-28 | US | Ohio | Ashland | 39005 | 7801 | 153 | 0 | 40.84772277 | -82.27280781 | 2021-11-29 04:22:30 | Ashland, Ohio, US | |
700345 | 700345 | 2021-11-04 | US | Missouri | Newton | 29145 | 7801 | 127 | 0 | 36.90519407 | -94.3394104 | 2021-11-05 04:21:54 | Newton, Missouri, US | |
636960 | 636960 | 2021-10-13 | US | Texas | Burnet | 48053 | 7801 | 113 | 0 | 30.78801353 | -98.181887 | 2021-10-14 04:21:29 | Burnet, Texas, US | |
1494169 | 1494169 | 2021-10-12 | US | Oklahoma | Le Flore | 40079 | 7801 | 76 | 0 | 34.89851864 | -94.70392124 | 2021-10-13 04:20:51 | Le Flore, Oklahoma, US | |
3009902 | 3009902 | 2021-10-11 | US | Oklahoma | Le Flore | 40079 | 7801 | 76 | 0 | 34.89851864 | -94.70392124 | 2021-10-12 04:21:09 | Le Flore, Oklahoma, US | |
425918 | 425918 | 2021-10-10 | US | Oklahoma | Le Flore | 40079 | 7801 | 76 | 0 | 34.89851864 | -94.70392124 | 2021-10-11 04:21:31 | Le Flore, Oklahoma, US | |
2878775 | 2878775 | 2021-10-09 | US | Oklahoma | Le Flore | 40079 | 7801 | 76 | 0 | 34.89851864 | -94.70392124 | 2021-10-10 04:21:38 | Le Flore, Oklahoma, US | |
2961941 | 2961941 | 2021-10-08 | US | Oklahoma | Le Flore | 40079 | 7801 | 76 | 0 | 34.89851864 | -94.70392124 | 2021-10-09 04:21:34 | Le Flore, Oklahoma, US | |
469979 | 469979 | 2021-10-07 | US | Oklahoma | Le Flore | 40079 | 7801 | 76 | 0 | 34.89851864 | -94.70392124 | 2021-10-08 04:21:25 | Le Flore, Oklahoma, US | |
2461359 | 2461359 | 2021-10-06 | US | Oklahoma | Le Flore | 40079 | 7801 | 76 | 0 | 34.89851864 | -94.70392124 | 2021-10-07 04:21:36 | Le Flore, Oklahoma, US | |
2619594 | 2619594 | 2021-09-17 | US | Maine | Kennebec | 23011 | 7801 | 87 | 0 | 44.40759555 | -69.76738544 | 2021-09-18 04:21:24 | Kennebec, Maine, US | |
178761 | 178761 | 2021-09-02 | US | Florida | Suwannee | 12121 | 7801 | 140 | 0 | 30.19746066 | -82.99099670000003 | 2021-09-03 04:21:20 | Suwannee, Florida, US | |
67796 | 67796 | 2021-09-01 | US | Florida | Suwannee | 12121 | 7801 | 140 | 0 | 30.19746066 | -82.99099670000003 | 2021-09-02 04:21:15 | Suwannee, Florida, US | |
2068638 | 2068638 | 2021-08-31 | US | Florida | Suwannee | 12121 | 7801 | 140 | 0 | 30.19746066 | -82.99099670000003 | 2021-09-01 04:21:38 | Suwannee, Florida, US | |
1776092 | 1776092 | 2021-08-30 | US | Florida | Suwannee | 12121 | 7801 | 140 | 0 | 30.19746066 | -82.99099670000003 | 2021-08-31 04:21:46 | Suwannee, Florida, US | |
3892666 | 3892666 | 2021-08-29 | US | Florida | Suwannee | 12121 | 7801 | 140 | 0 | 30.19746066 | -82.99099670000003 | 2021-08-30 04:21:23 | Suwannee, Florida, US | |
2793769 | 2793769 | 2021-08-28 | US | Florida | Suwannee | 12121 | 7801 | 140 | 0 | 30.19746066 | -82.99099670000003 | 2021-08-29 04:21:14 | Suwannee, Florida, US | |
2923928 | 2923928 | 2021-08-27 | US | Florida | Suwannee | 12121 | 7801 | 140 | 0 | 30.19746066 | -82.99099670000003 | 2021-08-28 04:21:28 | Suwannee, Florida, US | |
2353060 | 2353060 | 2021-08-10 | US | Michigan | Clinton | 26037 | 7801 | 94 | 0 | 42.94400871 | -84.60145248 | 2021-08-11 04:21:58 | Clinton, Michigan, US | |
651589 | 651589 | 2021-08-09 | US | Michigan | Clinton | 26037 | 7801 | 94 | 0 | 42.94400871 | -84.60145248 | 2021-08-10 04:21:27 | Clinton, Michigan, US | |
3296113 | 3296113 | 2021-07-30 | Iceland | 7801 | 30 | 6699 | 1072 | 64.9631 | -19.0208 | 2021-07-31 04:21:35 | Iceland | |||
2391915 | 2391915 | 2021-05-18 | US | Indiana | Warrick | 18173 | 7801 | 155 | 0 | 38.08922676 | -87.2716085 | 2021-05-19 04:20:42 | Warrick, Indiana, US | |
2763854 | 2763854 | 2021-05-03 | US | Tennessee | Greene | 47059 | 7801 | 155 | 0 | 36.17470125 | -82.84691273 | 2021-05-04 04:20:34 | Greene, Tennessee, US | |
1302578 | 1302578 | 2021-04-01 | US | Arkansas | White | 5145 | 7801 | 116 | 0 | 35.25688493 | -91.74908296 | 2021-04-02 04:20:36 | White, Arkansas, US | |
1838441 | 1838441 | 2021-03-12 | US | Arkansas | Pope | 5115 | 7801 | 100 | 0 | 35.44871474 | -93.03212219 | 2021-03-13 05:25:15 | Pope, Arkansas, US | |
3068804 | 3068804 | 2021-02-27 | US | South Carolina | Darlington | 45031 | 7801 | 163 | 0 | 7638 | 34.33358335 | -79.96027485 | 2021-02-28 05:22:20 | Darlington, South Carolina, US |
2213839 | 2213839 | 2021-01-30 | US | New Jersey | Sussex | 34037 | 7801 | 254 | 0 | 7547 | 41.13891592 | -74.69118243 | 2021-01-31 05:22:42 | Sussex, New Jersey, US |
2865087 | 2865087 | 2021-01-06 | US | Alabama | Houston | 1069 | 7801 | 70 | 0 | 7731 | 31.15197924 | -85.29939599 | 2021-01-07 05:22:03 | Houston, Alabama, US |
3034738 | 3034738 | 2021-01-05 | US | Arizona | Apache | 4001 | 7801 | 250 | 0 | 7551 | 35.39465006 | -109.4892383 | 2021-01-06 05:22:16 | Apache, Arizona, US |
1064345 | 1064345 | 2021-01-04 | US | Ohio | Richland | 39139 | 7801 | 154 | 0 | 7647 | 40.77180308 | -82.53799609999999 | 2021-01-05 05:21:49 | Richland, Ohio, US |
2932702 | 2932702 | 2020-12-19 | US | Louisiana | Bossier | 22015 | 7801 | 170 | 0 | 7631 | 32.67932307 | -93.60460152 | 2020-12-20 05:27:32 | Bossier, Louisiana, US |
1902648 | 1902648 | 2020-12-18 | US | Louisiana | Bossier | 22015 | 7801 | 170 | 0 | 7631 | 32.67932307 | -93.60460152 | 2020-12-19 05:27:52 | Bossier, Louisiana, US |
3848172 | 3848172 | 2020-12-13 | US | Alabama | Marshall | 1095 | 7801 | 65 | 0 | 7736 | 34.36975964 | -86.30486727 | 2020-12-14 05:26:27 | Marshall, Alabama, US |
1584712 | 1584712 | 2020-11-30 | US | California | Marin | 6041 | 7801 | 136 | 0 | 7662 | 38.07122463 | -122.7210631 | 2020-12-01 05:26:18 | Marin, California, US |
1797008 | 1797008 | 2020-10-19 | US | North Dakota | Cass | 38017 | 7801 | 79 | 0 | 7674 | 46.93201724 | -97.2444719 | 2020-10-20 04:24:22 | Cass, North Dakota, US |
2653983 | 2653983 | 2020-09-23 | Russia | Kursk Oblast | 7801 | 56 | 6564 | 1181 | 51.6568453 | 36.4852695 | 2020-09-24 04:23:00 | Kursk Oblast, Russia | ||
2653756 | 2653756 | 2020-09-23 | Italy | Marche | 7801 | 989 | 6126 | 686 | 43.61675973 | 13.5188753 | 2020-09-24 04:23:00 | Marche, Italy | ||
2060680 | 2060680 | 2020-09-01 | US | Georgia | Hall | 13139 | 7801 | 128 | 0 | 7673 | 34.32207823 | -83.81896936 | 2020-09-02 04:28:25 | Hall, Georgia, US |
1996875 | 1996875 | 2020-08-26 | Russia | Penza Oblast | 7801 | 104 | 7370 | 327 | 53.1655415 | 44.78791810000001 | 2020-08-27 04:28:15 | Penza Oblast, Russia | ||
2039991 | 2039991 | 2020-06-27 | Mexico | Sinaloa | 7801 | 1218 | 6144 | 439 | 25.1721 | -107.4795 | 2020-06-28 04:34:04 | Sinaloa, Mexico | ||
574042 | 574042 | 2020-06-06 | Italy | Lazio | 7801 | 758 | 4346 | 2697 | 41.89277044 | 12.48366722 | 2020-06-07 03:53:30 | Lazio, Italy |
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]);