johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
295 rows where confirmed = 2625 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3717691 | 3717691 | 2022-12-06 | US | West Virginia | Tyler | 54095 | 2625 | 33 | 0 | 39.46811972 | -80.88772676 | 2022-12-07 04:20:58 | Tyler, West Virginia, US | |
1967555 | 1967555 | 2022-11-30 | US | Tennessee | Moore | 47127 | 2625 | 41 | 0 | 35.27724699 | -86.36230578 | 2022-12-01 04:21:03 | Moore, Tennessee, US | |
2559347 | 2559347 | 2022-11-29 | US | Puerto Rico | Las Marias | 72083 | 2625 | 0 | 0 | 18.23679 | -66.98362 | 2022-11-30 04:21:07 | Las Marias, Puerto Rico, US | |
1242421 | 1242421 | 2022-11-28 | US | Puerto Rico | Las Marias | 72083 | 2625 | 0 | 0 | 18.23679 | -66.98362 | 2022-11-29 04:21:05 | Las Marias, Puerto Rico, US | |
3554409 | 3554409 | 2022-11-27 | US | Puerto Rico | Las Marias | 72083 | 2625 | 0 | 0 | 18.23679 | -66.98362 | 2022-11-28 04:21:02 | Las Marias, Puerto Rico, US | |
3553130 | 3553130 | 2022-11-27 | US | Kentucky | Trimble | 21223 | 2625 | 46 | 0 | 38.61056487 | -85.33775972 | 2022-11-28 04:21:02 | Trimble, Kentucky, US | |
2101610 | 2101610 | 2022-11-26 | US | Kentucky | Trimble | 21223 | 2625 | 46 | 0 | 38.61056487 | -85.33775972 | 2022-11-27 04:21:05 | Trimble, Kentucky, US | |
489101 | 489101 | 2022-11-25 | US | Kentucky | Trimble | 21223 | 2625 | 46 | 0 | 38.61056487 | -85.33775972 | 2022-11-26 04:21:11 | Trimble, Kentucky, US | |
3524930 | 3524930 | 2022-11-24 | US | Kentucky | Trimble | 21223 | 2625 | 46 | 0 | 38.61056487 | -85.33775972 | 2022-11-25 04:21:06 | Trimble, Kentucky, US | |
3313713 | 3313713 | 2022-11-23 | US | Kentucky | Trimble | 21223 | 2625 | 46 | 0 | 38.61056487 | -85.33775972 | 2022-11-24 04:21:09 | Trimble, Kentucky, US | |
1621754 | 1621754 | 2022-11-22 | US | Kentucky | Trimble | 21223 | 2625 | 46 | 0 | 38.61056487 | -85.33775972 | 2022-11-23 04:21:06 | Trimble, Kentucky, US | |
3461642 | 3461642 | 2022-11-21 | US | Kentucky | Trimble | 21223 | 2625 | 46 | 0 | 38.61056487 | -85.33775972 | 2022-11-22 04:20:47 | Trimble, Kentucky, US | |
3460677 | 3460677 | 2022-11-21 | US | Arkansas | Nevada | 5099 | 2625 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-11-22 04:20:47 | Nevada, Arkansas, US | |
1640862 | 1640862 | 2022-11-20 | US | Arkansas | Nevada | 5099 | 2625 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-11-21 04:21:05 | Nevada, Arkansas, US | |
2064419 | 2064419 | 2022-11-19 | US | Arkansas | Nevada | 5099 | 2625 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-11-20 04:21:08 | Nevada, Arkansas, US | |
3280078 | 3280078 | 2022-10-23 | US | Texas | Red River | 48387 | 2625 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-10-24 04:22:29 | Red River, Texas, US | |
2271116 | 2271116 | 2022-10-22 | US | Texas | Red River | 48387 | 2625 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-10-23 04:22:46 | Red River, Texas, US | |
1595416 | 1595416 | 2022-10-21 | US | Texas | Red River | 48387 | 2625 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-10-22 04:22:53 | Red River, Texas, US | |
2275132 | 2275132 | 2022-10-20 | US | Texas | Red River | 48387 | 2625 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-10-21 04:22:23 | Red River, Texas, US | |
201467 | 201467 | 2022-10-19 | US | Texas | Red River | 48387 | 2625 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-10-20 04:22:59 | Red River, Texas, US | |
3995931 | 3995931 | 2022-09-27 | US | Kansas | Grant | 20067 | 2625 | 38 | 0 | 37.56227336 | -101.3079758 | 2022-09-28 04:23:01 | Grant, Kansas, US | |
2770259 | 2770259 | 2022-09-26 | US | Kansas | Grant | 20067 | 2625 | 38 | 0 | 37.56227336 | -101.3079758 | 2022-09-27 04:23:01 | Grant, Kansas, US | |
1977912 | 1977912 | 2022-09-25 | US | Kansas | Grant | 20067 | 2625 | 38 | 0 | 37.56227336 | -101.3079758 | 2022-09-26 04:20:52 | Grant, Kansas, US | |
2651079 | 2651079 | 2022-09-24 | US | Kansas | Grant | 20067 | 2625 | 38 | 0 | 37.56227336 | -101.3079758 | 2022-09-25 04:23:31 | Grant, Kansas, US | |
385519 | 385519 | 2022-09-23 | US | Kansas | Grant | 20067 | 2625 | 38 | 0 | 37.56227336 | -101.3079758 | 2022-09-24 04:21:40 | Grant, Kansas, US | |
1625585 | 1625585 | 2022-09-22 | US | Kansas | Grant | 20067 | 2625 | 38 | 0 | 37.56227336 | -101.3079758 | 2022-09-23 04:23:13 | Grant, Kansas, US | |
1371789 | 1371789 | 2022-09-21 | US | Kansas | Grant | 20067 | 2625 | 38 | 0 | 37.56227336 | -101.3079758 | 2022-09-22 04:22:56 | Grant, Kansas, US | |
1891329 | 1891329 | 2022-09-14 | US | New Jersey | Unassigned | 90034 | 2625 | 0 | 0 | 41.13891592 | 0.0 | 2022-09-15 04:21:02 | Unassigned, New Jersey, US | |
1880509 | 1880509 | 2022-08-28 | US | West Virginia | Webster | 54101 | 2625 | 37 | 0 | 38.49370949 | -80.4202023 | 2022-08-29 04:21:06 | Webster, West Virginia, US | |
2099636 | 2099636 | 2022-08-27 | US | West Virginia | Webster | 54101 | 2625 | 37 | 0 | 38.49370949 | -80.4202023 | 2022-08-28 04:21:02 | Webster, West Virginia, US | |
1535451 | 1535451 | 2022-08-26 | US | West Virginia | Webster | 54101 | 2625 | 37 | 0 | 38.49370949 | -80.4202023 | 2022-08-27 04:20:57 | Webster, West Virginia, US | |
992275 | 992275 | 2022-08-16 | US | Kansas | Doniphan | 20043 | 2625 | 35 | 0 | 39.79067154 | -95.14056866 | 2022-08-17 04:20:59 | Doniphan, Kansas, US | |
2495314 | 2495314 | 2022-08-15 | US | Kansas | Doniphan | 20043 | 2625 | 35 | 0 | 39.79067154 | -95.14056866 | 2022-08-16 04:20:58 | Doniphan, Kansas, US | |
3648864 | 3648864 | 2022-08-14 | US | Kansas | Doniphan | 20043 | 2625 | 35 | 0 | 39.79067154 | -95.14056866 | 2022-08-15 04:20:59 | Doniphan, Kansas, US | |
1969870 | 1969870 | 2022-08-13 | US | Kansas | Doniphan | 20043 | 2625 | 35 | 0 | 39.79067154 | -95.14056866 | 2022-08-14 04:20:55 | Doniphan, Kansas, US | |
2889679 | 2889679 | 2022-08-12 | US | Kansas | Doniphan | 20043 | 2625 | 35 | 0 | 39.79067154 | -95.14056866 | 2022-08-13 04:20:52 | Doniphan, Kansas, US | |
3909284 | 3909284 | 2022-08-11 | US | Kansas | Doniphan | 20043 | 2625 | 35 | 0 | 39.79067154 | -95.14056866 | 2022-08-12 04:20:54 | Doniphan, Kansas, US | |
1347601 | 1347601 | 2022-08-10 | US | Kansas | Doniphan | 20043 | 2625 | 35 | 0 | 39.79067154 | -95.14056866 | 2022-08-11 04:20:49 | Doniphan, Kansas, US | |
1073286 | 1073286 | 2022-08-07 | US | Virginia | Poquoson | 51735 | 2625 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-08-08 04:21:08 | Poquoson, Virginia, US | |
1943874 | 1943874 | 2022-08-06 | US | Virginia | Poquoson | 51735 | 2625 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-08-07 04:20:54 | Poquoson, Virginia, US | |
883673 | 883673 | 2022-08-05 | US | Virginia | Poquoson | 51735 | 2625 | 30 | 0 | 37.14259351 | -76.35798148 | 2022-08-06 04:20:56 | Poquoson, Virginia, US | |
2597546 | 2597546 | 2022-07-25 | US | West Virginia | Ritchie | 54085 | 2625 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-07-26 04:20:58 | Ritchie, West Virginia, US | |
2155114 | 2155114 | 2022-07-16 | US | Washington | Pend Oreille | 53051 | 2625 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-07-17 04:21:15 | Pend Oreille, Washington, US | |
2422347 | 2422347 | 2022-07-15 | US | Washington | Pend Oreille | 53051 | 2625 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-07-16 04:21:05 | Pend Oreille, Washington, US | |
3432422 | 3432422 | 2022-07-14 | US | Washington | Pend Oreille | 53051 | 2625 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-07-15 04:20:53 | Pend Oreille, Washington, US | |
3432337 | 3432337 | 2022-07-14 | US | Virginia | Madison | 51113 | 2625 | 43 | 0 | 38.41531222 | -78.28220331 | 2022-07-15 04:20:53 | Madison, Virginia, US | |
3112942 | 3112942 | 2022-07-13 | US | Washington | Pend Oreille | 53051 | 2625 | 37 | 0 | 48.53234021 | -117.2741804 | 2022-07-14 04:20:57 | Pend Oreille, Washington, US | |
939422 | 939422 | 2022-06-25 | US | Colorado | Bent | 8011 | 2625 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-06-26 04:21:02 | Bent, Colorado, US | |
1650305 | 1650305 | 2022-06-23 | US | Missouri | Linn | 29115 | 2625 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-06-24 04:20:58 | Linn, Missouri, US | |
2189540 | 2189540 | 2022-06-22 | US | Missouri | Linn | 29115 | 2625 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-06-23 04:20:55 | Linn, Missouri, US | |
167971 | 167971 | 2022-06-21 | US | Missouri | Linn | 29115 | 2625 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-06-22 04:20:54 | Linn, Missouri, US | |
167704 | 167704 | 2022-06-21 | US | Michigan | Mackinac | 26097 | 2625 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-06-22 04:20:54 | Mackinac, Michigan, US | |
1765254 | 1765254 | 2022-06-20 | US | Missouri | Linn | 29115 | 2625 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-06-21 04:20:56 | Linn, Missouri, US | |
1764987 | 1764987 | 2022-06-20 | US | Michigan | Mackinac | 26097 | 2625 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-06-21 04:20:56 | Mackinac, Michigan, US | |
3271440 | 3271440 | 2022-06-19 | US | Missouri | Linn | 29115 | 2625 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-06-20 04:21:01 | Linn, Missouri, US | |
3271173 | 3271173 | 2022-06-19 | US | Michigan | Mackinac | 26097 | 2625 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-06-20 04:21:01 | Mackinac, Michigan, US | |
3399352 | 3399352 | 2022-06-18 | US | Missouri | Linn | 29115 | 2625 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-06-19 04:20:51 | Linn, Missouri, US | |
3399085 | 3399085 | 2022-06-18 | US | Michigan | Mackinac | 26097 | 2625 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-06-19 04:20:51 | Mackinac, Michigan, US | |
2313229 | 2313229 | 2022-06-17 | US | Missouri | Linn | 29115 | 2625 | 65 | 0 | 39.87001769 | -93.10704106 | 2022-06-18 04:21:10 | Linn, Missouri, US | |
2312962 | 2312962 | 2022-06-17 | US | Michigan | Mackinac | 26097 | 2625 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-06-18 04:21:10 | Mackinac, Michigan, US | |
560466 | 560466 | 2022-06-16 | US | Michigan | Mackinac | 26097 | 2625 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-06-17 04:20:56 | Mackinac, Michigan, US | |
3984268 | 3984268 | 2022-06-15 | US | Michigan | Mackinac | 26097 | 2625 | 31 | 0 | 46.07028979 | -85.04980537 | 2022-06-16 04:20:55 | Mackinac, Michigan, US | |
2982859 | 2982859 | 2022-06-13 | US | Wyoming | Big Horn | 56003 | 2625 | 62 | 0 | 44.52405055 | -107.9960365 | 2022-06-14 04:20:52 | Big Horn, Wyoming, US | |
2238985 | 2238985 | 2022-06-12 | US | Wyoming | Big Horn | 56003 | 2625 | 62 | 0 | 44.52405055 | -107.9960365 | 2022-06-13 04:21:14 | Big Horn, Wyoming, US | |
3145183 | 3145183 | 2022-06-11 | US | Wyoming | Big Horn | 56003 | 2625 | 62 | 0 | 44.52405055 | -107.9960365 | 2022-06-12 04:20:53 | Big Horn, Wyoming, US | |
1948099 | 1948099 | 2022-06-10 | US | Wyoming | Big Horn | 56003 | 2625 | 62 | 0 | 44.52405055 | -107.9960365 | 2022-06-11 04:21:01 | Big Horn, Wyoming, US | |
3161238 | 3161238 | 2022-06-09 | US | Wyoming | Big Horn | 56003 | 2625 | 62 | 0 | 44.52405055 | -107.9960365 | 2022-06-10 04:20:55 | Big Horn, Wyoming, US | |
1424705 | 1424705 | 2022-06-08 | US | Wyoming | Big Horn | 56003 | 2625 | 62 | 0 | 44.52405055 | -107.9960365 | 2022-06-09 04:20:54 | Big Horn, Wyoming, US | |
3729819 | 3729819 | 2022-06-07 | US | Wyoming | Big Horn | 56003 | 2625 | 62 | 0 | 44.52405055 | -107.9960365 | 2022-06-08 04:20:55 | Big Horn, Wyoming, US | |
3508510 | 3508510 | 2022-06-05 | US | Indiana | Newton | 18111 | 2625 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-06-06 04:20:57 | Newton, Indiana, US | |
3528587 | 3528587 | 2022-06-04 | US | Indiana | Newton | 18111 | 2625 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-06-05 04:20:55 | Newton, Indiana, US | |
3134673 | 3134673 | 2022-06-03 | US | Indiana | Newton | 18111 | 2625 | 68 | 0 | 40.95610449 | -87.39635768 | 2022-06-04 04:20:58 | Newton, Indiana, US | |
3579144 | 3579144 | 2022-06-02 | US | Arkansas | Pike | 5109 | 2625 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-06-03 04:20:58 | Pike, Arkansas, US | |
1314717 | 1314717 | 2022-05-27 | US | Arkansas | Pike | 5109 | 2625 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-05-28 04:21:07 | Pike, Arkansas, US | |
2535273 | 2535273 | 2022-05-12 | US | Missouri | Bollinger | 29017 | 2625 | 41 | 0 | 37.32449052 | -90.02725304 | 2022-05-13 04:20:51 | Bollinger, Missouri, US | |
3446719 | 3446719 | 2022-05-11 | US | Missouri | Bollinger | 29017 | 2625 | 41 | 0 | 37.32449052 | -90.02725304 | 2022-05-12 04:20:54 | Bollinger, Missouri, US | |
3537336 | 3537336 | 2022-05-10 | US | Missouri | Bollinger | 29017 | 2625 | 41 | 0 | 37.32449052 | -90.02725304 | 2022-05-11 04:20:48 | Bollinger, Missouri, US | |
223871 | 223871 | 2022-05-09 | US | Missouri | Bollinger | 29017 | 2625 | 41 | 0 | 37.32449052 | -90.02725304 | 2022-05-10 04:20:50 | Bollinger, Missouri, US | |
222382 | 222382 | 2022-05-09 | US | Alabama | Lowndes | 1085 | 2625 | 77 | 0 | 32.1597283 | -86.65158371 | 2022-05-10 04:20:50 | Lowndes, Alabama, US | |
2333256 | 2333256 | 2022-05-08 | US | Missouri | Bollinger | 29017 | 2625 | 41 | 0 | 37.32449052 | -90.02725304 | 2022-05-09 04:20:54 | Bollinger, Missouri, US | |
362218 | 362218 | 2022-05-07 | US | Missouri | Bollinger | 29017 | 2625 | 41 | 0 | 37.32449052 | -90.02725304 | 2022-05-08 04:20:49 | Bollinger, Missouri, US | |
1399569 | 1399569 | 2022-05-06 | US | Missouri | Bollinger | 29017 | 2625 | 41 | 0 | 37.32449052 | -90.02725304 | 2022-05-07 04:21:09 | Bollinger, Missouri, US | |
3916995 | 3916995 | 2022-05-01 | US | Idaho | Valley | 16085 | 2625 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-05-02 04:21:10 | Valley, Idaho, US | |
2841799 | 2841799 | 2022-04-30 | US | Idaho | Valley | 16085 | 2625 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-05-01 04:20:57 | Valley, Idaho, US | |
1158112 | 1158112 | 2022-04-29 | US | Idaho | Valley | 16085 | 2625 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-04-30 04:21:05 | Valley, Idaho, US | |
3322976 | 3322976 | 2022-04-07 | US | Puerto Rico | Comerio | 72045 | 2625 | 0 | 0 | 18.224687 | -66.221622 | 2022-04-08 04:20:48 | Comerio, Puerto Rico, US | |
3869571 | 3869571 | 2022-04-05 | US | Montana | Richland | 30083 | 2625 | 33 | 0 | 47.78668011 | -104.5610786 | 2022-04-06 04:20:49 | Richland, Montana, US | |
1541729 | 1541729 | 2022-03-31 | US | Minnesota | Stevens | 27149 | 2625 | 13 | 0 | 45.58613007 | -96.00163705 | 2022-04-01 04:20:28 | Stevens, Minnesota, US | |
696695 | 696695 | 2022-03-17 | US | North Carolina | Clay | 37043 | 2625 | 39 | 0 | 35.05704275 | -83.74353633 | 2022-03-18 04:20:55 | Clay, North Carolina, US | |
3631358 | 3631358 | 2022-03-13 | US | Virginia | Richmond | 51159 | 2625 | 25 | 0 | 37.937575 | -76.72920628 | 2022-03-14 04:20:46 | Richmond, Virginia, US | |
954266 | 954266 | 2022-03-12 | US | Virginia | Richmond | 51159 | 2625 | 25 | 0 | 37.937575 | -76.72920628 | 2022-03-13 04:20:49 | Richmond, Virginia, US | |
359727 | 359727 | 2022-03-11 | US | Virginia | Richmond | 51159 | 2625 | 25 | 0 | 37.937575 | -76.72920628 | 2022-03-12 04:20:50 | Richmond, Virginia, US | |
1994305 | 1994305 | 2022-03-01 | US | Michigan | Iron | 26071 | 2625 | 83 | 0 | 46.20974132 | -88.53136251 | 2022-03-02 04:21:07 | Iron, Michigan, US | |
944479 | 944479 | 2022-02-28 | US | Michigan | Iron | 26071 | 2625 | 83 | 0 | 46.20974132 | -88.53136251 | 2022-03-01 04:21:09 | Iron, Michigan, US | |
3823817 | 3823817 | 2022-02-16 | US | Virginia | Nelson | 51125 | 2625 | 26 | 0 | 37.78790447 | -78.88498513 | 2022-02-17 04:20:56 | Nelson, Virginia, US | |
3823507 | 3823507 | 2022-02-16 | US | Texas | Dawson | 48115 | 2625 | 92 | 0 | 32.74255572 | -101.94772420000001 | 2022-02-17 04:20:56 | Dawson, Texas, US | |
979744 | 979744 | 2022-02-01 | US | Georgia | Early | 13099 | 2625 | 59 | 0 | 31.32155345 | -84.90255207 | 2022-02-02 04:21:09 | Early, Georgia, US | |
3065039 | 3065039 | 2022-01-29 | US | Texas | Callahan | 48059 | 2625 | 63 | 0 | 32.29760619 | -99.37326312 | 2022-01-30 04:21:26 | Callahan, Texas, US | |
2053324 | 2053324 | 2022-01-25 | US | Kentucky | Martin | 21159 | 2625 | 44 | 0 | 37.79990579 | -82.51247478 | 2022-01-26 04:21:07 | Martin, Kentucky, US | |
2052245 | 2052245 | 2022-01-25 | US | Alabama | Coosa | 1037 | 2625 | 49 | 0 | 32.93690146 | -86.24847739 | 2022-01-26 04:21:07 | Coosa, Alabama, 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]);