johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
228 rows where confirmed = 2754 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 10
- US 207
- Colombia 7
- France 3
- Japan 3
- China 2
- Peru 2
- Burkina Faso 1
- Germany 1
- Netherlands 1
- Pakistan 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
310079 | 310079 | 2022-12-13 | US | New Mexico | Colfax | 35007 | 2754 | 68 | 0 | 36.60569702 | -104.6472674 | 2022-12-14 04:21:04 | Colfax, New Mexico, US | |
1988033 | 1988033 | 2022-12-07 | US | Virginia | Northampton | 51131 | 2754 | 73 | 0 | 37.34062933 | -75.87751591 | 2022-12-08 04:21:07 | Northampton, Virginia, US | |
3715139 | 3715139 | 2022-12-06 | US | Illinois | Brown | 17009 | 2754 | 17 | 0 | 39.96209138 | -90.75068024 | 2022-12-07 04:20:58 | Brown, Illinois, US | |
2415844 | 2415844 | 2022-12-05 | US | Illinois | Brown | 17009 | 2754 | 17 | 0 | 39.96209138 | -90.75068024 | 2022-12-06 04:21:03 | Brown, Illinois, US | |
719452 | 719452 | 2022-12-04 | US | Illinois | Brown | 17009 | 2754 | 17 | 0 | 39.96209138 | -90.75068024 | 2022-12-05 04:20:58 | Brown, Illinois, US | |
2817741 | 2817741 | 2022-12-03 | US | Illinois | Brown | 17009 | 2754 | 17 | 0 | 39.96209138 | -90.75068024 | 2022-12-04 04:20:56 | Brown, Illinois, US | |
834597 | 834597 | 2022-12-02 | US | Illinois | Brown | 17009 | 2754 | 17 | 0 | 39.96209138 | -90.75068024 | 2022-12-03 04:21:02 | Brown, Illinois, US | |
1240190 | 1240190 | 2022-11-28 | US | Arkansas | Scott | 5127 | 2754 | 47 | 0 | 34.85588887 | -94.0632176 | 2022-11-29 04:21:05 | Scott, Arkansas, US | |
3526871 | 3526871 | 2022-11-24 | US | Virginia | Sussex | 51183 | 2754 | 45 | 0 | 36.92432914 | -77.25791182 | 2022-11-25 04:21:06 | Sussex, Virginia, US | |
3315654 | 3315654 | 2022-11-23 | US | Virginia | Sussex | 51183 | 2754 | 45 | 0 | 36.92432914 | -77.25791182 | 2022-11-24 04:21:09 | Sussex, Virginia, US | |
482886 | 482886 | 2022-11-08 | US | Vermont | Unassigned | 90050 | 2754 | 8 | 0 | 44.85627605 | 0.0 | 2022-11-09 04:21:22 | Unassigned, Vermont, US | |
2442036 | 2442036 | 2022-11-07 | US | Vermont | Unassigned | 90050 | 2754 | 8 | 0 | 44.85627605 | 0.0 | 2022-11-08 04:21:21 | Unassigned, Vermont, US | |
1053134 | 1053134 | 2022-11-06 | US | Vermont | Unassigned | 90050 | 2754 | 8 | 0 | 44.85627605 | 0.0 | 2022-11-07 04:21:26 | Unassigned, Vermont, US | |
621158 | 621158 | 2022-11-05 | US | Vermont | Unassigned | 90050 | 2754 | 8 | 0 | 44.85627605 | 0.0 | 2022-11-06 04:21:24 | Unassigned, Vermont, US | |
1025662 | 1025662 | 2022-11-04 | US | Vermont | Unassigned | 90050 | 2754 | 8 | 0 | 44.85627605 | 0.0 | 2022-11-05 04:21:52 | Unassigned, Vermont, US | |
434653 | 434653 | 2022-11-03 | US | Vermont | Unassigned | 90050 | 2754 | 8 | 0 | 44.85627605 | 0.0 | 2022-11-04 04:22:11 | Unassigned, Vermont, US | |
431156 | 431156 | 2022-11-03 | China | Jiangsu | 2754 | 0 | 0 | 32.9711 | 119.455 | 2022-11-04 04:22:11 | Jiangsu, China | |||
852895 | 852895 | 2022-11-02 | US | Vermont | Unassigned | 90050 | 2754 | 8 | 0 | 44.85627605 | 0.0 | 2022-11-03 04:22:05 | Unassigned, Vermont, US | |
3766484 | 3766484 | 2022-09-11 | US | Colorado | Bent | 8011 | 2754 | 48 | 0 | 37.95474293 | -103.0720195 | 2022-09-12 04:20:58 | Bent, Colorado, US | |
3827217 | 3827217 | 2022-09-10 | US | Puerto Rico | Maunabo | 72095 | 2754 | 0 | 0 | 18.017889 | -65.922235 | 2022-09-11 04:20:50 | Maunabo, Puerto Rico, US | |
3825059 | 3825059 | 2022-09-10 | US | Colorado | Bent | 8011 | 2754 | 48 | 0 | 37.95474293 | -103.0720195 | 2022-09-11 04:20:50 | Bent, Colorado, US | |
965674 | 965674 | 2022-09-09 | US | Puerto Rico | Maunabo | 72095 | 2754 | 0 | 0 | 18.017889 | -65.922235 | 2022-09-10 04:21:10 | Maunabo, Puerto Rico, US | |
963516 | 963516 | 2022-09-09 | US | Colorado | Bent | 8011 | 2754 | 48 | 0 | 37.95474293 | -103.0720195 | 2022-09-10 04:21:10 | Bent, Colorado, US | |
3910418 | 3910418 | 2022-08-11 | US | North Dakota | Mercer | 38057 | 2754 | 24 | 0 | 47.31213126 | -101.8318399 | 2022-08-12 04:20:54 | Mercer, North Dakota, US | |
1072636 | 1072636 | 2022-08-07 | US | Puerto Rico | Guanica | 72055 | 2754 | 0 | 0 | 17.982429 | -66.919643 | 2022-08-08 04:21:08 | Guanica, Puerto Rico, US | |
1490636 | 1490636 | 2022-07-26 | US | Texas | Childress | 48075 | 2754 | 34 | 0 | 34.5293041 | -100.2077916 | 2022-07-27 04:21:04 | Childress, Texas, US | |
671421 | 671421 | 2022-07-21 | US | Indiana | Newton | 18111 | 2754 | 69 | 0 | 40.95610449 | -87.39635768 | 2022-07-22 04:21:15 | Newton, Indiana, US | |
1609384 | 1609384 | 2022-07-20 | US | Indiana | Newton | 18111 | 2754 | 69 | 0 | 40.95610449 | -87.39635768 | 2022-07-21 04:21:10 | Newton, Indiana, US | |
2789685 | 2789685 | 2022-07-10 | US | Colorado | Prowers | 8099 | 2754 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-07-11 04:20:46 | Prowers, Colorado, US | |
168209 | 168209 | 2022-06-21 | US | New Hampshire | Unassigned | 90033 | 2754 | 6 | 0 | 44.69063265 | 0.0 | 2022-06-22 04:20:54 | Unassigned, New Hampshire, US | |
973694 | 973694 | 2022-06-01 | US | Puerto Rico | Rincon | 72117 | 2754 | 0 | 0 | 18.335443 | -67.23174 | 2022-06-02 05:20:39 | Rincon, Puerto Rico, US | |
973137 | 973137 | 2022-06-01 | US | New Mexico | Torrance | 35057 | 2754 | 57 | 0 | 34.64048375 | -105.8508949 | 2022-06-02 05:20:39 | Torrance, New Mexico, US | |
231444 | 231444 | 2022-05-31 | US | New Mexico | Torrance | 35057 | 2754 | 57 | 0 | 34.64048375 | -105.8508949 | 2022-06-01 04:20:55 | Torrance, New Mexico, US | |
230183 | 230183 | 2022-05-31 | US | Idaho | Shoshone | 16079 | 2754 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-06-01 04:20:55 | Shoshone, Idaho, US | |
3186948 | 3186948 | 2022-05-30 | US | Idaho | Shoshone | 16079 | 2754 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-05-31 04:20:51 | Shoshone, Idaho, US | |
3199097 | 3199097 | 2022-05-29 | US | Idaho | Shoshone | 16079 | 2754 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-05-30 04:20:50 | Shoshone, Idaho, US | |
2727981 | 2727981 | 2022-05-28 | US | Tennessee | Lake | 47095 | 2754 | 43 | 0 | 36.3418017 | -89.48921915 | 2022-05-29 04:20:53 | Lake, Tennessee, US | |
2725975 | 2725975 | 2022-05-28 | US | Idaho | Shoshone | 16079 | 2754 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-05-29 04:20:53 | Shoshone, Idaho, US | |
1317162 | 1317162 | 2022-05-27 | US | Tennessee | Lake | 47095 | 2754 | 43 | 0 | 36.3418017 | -89.48921915 | 2022-05-28 04:21:07 | Lake, Tennessee, US | |
1315156 | 1315156 | 2022-05-27 | US | Idaho | Shoshone | 16079 | 2754 | 76 | 0 | 47.35364087 | -115.8916749 | 2022-05-28 04:21:07 | Shoshone, Idaho, US | |
1112772 | 1112772 | 2022-05-21 | US | Texas | Pecos | 48371 | 2754 | 71 | 0 | 30.78097267 | -102.7241261 | 2022-05-22 04:20:52 | Pecos, Texas, US | |
3538316 | 3538316 | 2022-05-10 | US | South Dakota | Butte | 46019 | 2754 | 45 | 0 | 44.90608745 | -103.5079318 | 2022-05-11 04:20:48 | Butte, South Dakota, US | |
224851 | 224851 | 2022-05-09 | US | South Dakota | Butte | 46019 | 2754 | 45 | 0 | 44.90608745 | -103.5079318 | 2022-05-10 04:20:50 | Butte, South Dakota, US | |
2334236 | 2334236 | 2022-05-08 | US | South Dakota | Butte | 46019 | 2754 | 45 | 0 | 44.90608745 | -103.5079318 | 2022-05-09 04:20:54 | Butte, South Dakota, US | |
363198 | 363198 | 2022-05-07 | US | South Dakota | Butte | 46019 | 2754 | 45 | 0 | 44.90608745 | -103.5079318 | 2022-05-08 04:20:49 | Butte, South Dakota, US | |
1400549 | 1400549 | 2022-05-06 | US | South Dakota | Butte | 46019 | 2754 | 45 | 0 | 44.90608745 | -103.5079318 | 2022-05-07 04:21:09 | Butte, South Dakota, US | |
2600904 | 2600904 | 2022-05-05 | US | South Dakota | Butte | 46019 | 2754 | 45 | 0 | 44.90608745 | -103.5079318 | 2022-05-06 04:21:00 | Butte, South Dakota, US | |
3268353 | 3268353 | 2022-05-04 | US | South Dakota | Butte | 46019 | 2754 | 45 | 0 | 44.90608745 | -103.5079318 | 2022-05-05 04:20:55 | Butte, South Dakota, US | |
465128 | 465128 | 2022-05-02 | US | Minnesota | Koochiching | 27071 | 2754 | 37 | 0 | 48.24539665 | -93.78352843 | 2022-05-03 04:21:00 | Koochiching, Minnesota, US | |
1906216 | 1906216 | 2022-03-22 | US | Illinois | Marshall | 17123 | 2754 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-03-23 04:20:48 | Marshall, Illinois, US | |
335768 | 335768 | 2022-03-18 | Colombia | Guainia | 2754 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-19 04:20:47 | Guainia, Colombia | |||
694221 | 694221 | 2022-03-17 | Colombia | Guainia | 2754 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-18 04:20:55 | Guainia, Colombia | |||
2319164 | 2319164 | 2022-03-16 | Colombia | Guainia | 2754 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-17 04:20:56 | Guainia, Colombia | |||
261364 | 261364 | 2022-03-15 | Colombia | Guainia | 2754 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-16 04:20:50 | Guainia, Colombia | |||
2264729 | 2264729 | 2022-03-14 | US | Georgia | Long | 13183 | 2754 | 34 | 0 | 31.75218791 | -81.74952375 | 2022-03-15 04:20:47 | Long, Georgia, US | |
3628428 | 3628428 | 2022-03-13 | US | Arkansas | Chicot | 5017 | 2754 | 57 | 0 | 33.26458973 | -91.29539209 | 2022-03-14 04:20:46 | Chicot, Arkansas, US | |
951336 | 951336 | 2022-03-12 | US | Arkansas | Chicot | 5017 | 2754 | 57 | 0 | 33.26458973 | -91.29539209 | 2022-03-13 04:20:49 | Chicot, Arkansas, US | |
356797 | 356797 | 2022-03-11 | US | Arkansas | Chicot | 5017 | 2754 | 57 | 0 | 33.26458973 | -91.29539209 | 2022-03-12 04:20:50 | Chicot, Arkansas, US | |
1865310 | 1865310 | 2022-03-10 | Colombia | Guainia | 2754 | 37 | 0 | 2.5854 | -68.5247 | 2022-03-11 04:20:50 | Guainia, Colombia | |||
3915060 | 3915060 | 2022-02-20 | US | Texas | Callahan | 48059 | 2754 | 71 | 0 | 32.29760619 | -99.37326312 | 2022-02-21 04:21:05 | Callahan, Texas, US | |
3878618 | 3878618 | 2022-02-19 | US | Texas | Callahan | 48059 | 2754 | 71 | 0 | 32.29760619 | -99.37326312 | 2022-02-20 04:21:00 | Callahan, Texas, US | |
3672324 | 3672324 | 2022-02-15 | US | Connecticut | Unassigned | 90009 | 2754 | 0 | 0 | 41.85853803 | 0.0 | 2022-02-16 04:21:10 | Unassigned, Connecticut, US | |
2645126 | 2645126 | 2022-02-14 | US | Virginia | Manassas Park | 51685 | 2754 | 16 | 0 | 38.77058531 | -77.44399307 | 2022-02-15 04:21:09 | Manassas Park, Virginia, US | |
980390 | 980390 | 2022-02-01 | US | Kentucky | Martin | 21159 | 2754 | 44 | 0 | 37.79990579 | -82.51247478 | 2022-02-02 04:21:09 | Martin, Kentucky, US | |
1320160 | 1320160 | 2022-01-26 | US | Missouri | Pemiscot | 29155 | 2754 | 61 | 0 | 36.2130572 | -89.78742322 | 2022-01-27 04:21:19 | Pemiscot, Missouri, US | |
2835617 | 2835617 | 2022-01-22 | US | Puerto Rico | Utuado | 72141 | 2754 | 0 | 0 | 18.271214 | -66.702984 | 2022-01-23 04:21:13 | Utuado, Puerto Rico, US | |
1473576 | 1473576 | 2022-01-17 | US | Kentucky | Pendleton | 21191 | 2754 | 31 | 0 | 38.69607718 | -84.35599463 | 2022-01-18 04:21:04 | Pendleton, Kentucky, US | |
556250 | 556250 | 2022-01-16 | US | Kentucky | Pendleton | 21191 | 2754 | 31 | 0 | 38.69607718 | -84.35599463 | 2022-01-17 04:21:08 | Pendleton, Kentucky, US | |
3841971 | 3841971 | 2022-01-15 | US | Kentucky | Pendleton | 21191 | 2754 | 31 | 0 | 38.69607718 | -84.35599463 | 2022-01-16 04:21:12 | Pendleton, Kentucky, US | |
100786 | 100786 | 2022-01-14 | US | Kentucky | Pendleton | 21191 | 2754 | 31 | 0 | 38.69607718 | -84.35599463 | 2022-01-15 04:21:07 | Pendleton, Kentucky, US | |
3689303 | 3689303 | 2022-01-13 | US | Mississippi | Lawrence | 28077 | 2754 | 44 | 0 | 31.55147224 | -90.10841127 | 2022-01-14 04:21:54 | Lawrence, Mississippi, US | |
1117121 | 1117121 | 2022-01-11 | US | Wisconsin | Buffalo | 55011 | 2754 | 10 | 0 | 44.37835084 | -91.75332578 | 2022-01-12 04:21:44 | Buffalo, Wisconsin, US | |
1703831 | 1703831 | 2022-01-03 | US | West Virginia | Grant | 54023 | 2754 | 46 | 0 | 39.10314817 | -79.19440518 | 2022-01-04 04:22:17 | Grant, West Virginia, US | |
2780049 | 2780049 | 2021-12-31 | US | Texas | Colorado | 48089 | 2754 | 56 | 0 | 29.622097999999998 | -96.5273805 | 2022-01-01 04:22:14 | Colorado, Texas, US | |
2905525 | 2905525 | 2021-12-19 | US | Mississippi | Holmes | 28051 | 2754 | 89 | 0 | 33.12345854 | -90.08923538 | 2021-12-20 04:21:43 | Holmes, Mississippi, US | |
1260715 | 1260715 | 2021-12-18 | US | Missouri | Livingston | 29117 | 2754 | 79 | 0 | 39.78110272 | -93.54645978 | 2021-12-19 04:21:11 | Livingston, Missouri, US | |
1260598 | 1260598 | 2021-12-18 | US | Mississippi | Holmes | 28051 | 2754 | 89 | 0 | 33.12345854 | -90.08923538 | 2021-12-19 04:21:11 | Holmes, Mississippi, US | |
2400626 | 2400626 | 2021-12-17 | US | Mississippi | Holmes | 28051 | 2754 | 89 | 0 | 33.12345854 | -90.08923538 | 2021-12-18 02:22:20 | Holmes, Mississippi, US | |
1142 | 1142 | 2021-12-02 | US | Georgia | Greene | 13133 | 2754 | 73 | 0 | 33.5769205 | -83.17139104 | 2021-12-03 04:23:05 | Greene, Georgia, US | |
3071788 | 3071788 | 2021-11-23 | US | Minnesota | Redwood | 27127 | 2754 | 45 | 0 | 44.40555844 | -95.25207021 | 2021-11-24 04:22:14 | Redwood, Minnesota, US | |
449794 | 449794 | 2021-11-17 | US | North Dakota | Richland | 38077 | 2754 | 21 | 0 | 46.26440649 | -96.94852979 | 2021-11-18 04:21:33 | Richland, North Dakota, US | |
447843 | 447843 | 2021-11-17 | US | Arkansas | Clay | 5021 | 2754 | 74 | 0 | 36.36826212 | -90.4148172 | 2021-11-18 04:21:33 | Clay, Arkansas, US | |
3121314 | 3121314 | 2021-11-05 | China | Shanghai | 2754 | 7 | 0 | 31.201999999999998 | 121.4491 | 2021-11-06 04:21:51 | Shanghai, China | |||
289373 | 289373 | 2021-10-31 | US | Kentucky | Breckinridge | 21027 | 2754 | 36 | 0 | 37.77377239 | -86.42885017 | 2021-11-01 04:22:01 | Breckinridge, Kentucky, US | |
7639 | 7639 | 2021-10-28 | US | Vermont | Windsor | 50027 | 2754 | 30 | 0 | 43.58010937 | -72.58595157 | 2021-10-29 04:22:03 | Windsor, Vermont, US | |
536628 | 536628 | 2021-10-27 | US | Missouri | Cooper | 29053 | 2754 | 33 | 0 | 38.844478 | -92.80896081 | 2021-10-28 04:22:08 | Cooper, Missouri, US | |
3494302 | 3494302 | 2021-10-26 | US | Nebraska | Washington | 31177 | 2754 | 25 | 0 | 41.52815707 | -96.22019892 | 2021-10-27 04:22:32 | Washington, Nebraska, US | |
3796024 | 3796024 | 2021-10-25 | US | Nebraska | Washington | 31177 | 2754 | 25 | 0 | 41.52815707 | -96.22019892 | 2021-10-26 04:22:09 | Washington, Nebraska, US | |
685051 | 685051 | 2021-10-24 | US | Pennsylvania | Wyoming | 42131 | 2754 | 63 | 0 | 41.51955538 | -76.01074915 | 2021-10-25 04:22:31 | Wyoming, Pennsylvania, US | |
684470 | 684470 | 2021-10-24 | US | Nebraska | Washington | 31177 | 2754 | 25 | 0 | 41.52815707 | -96.22019892 | 2021-10-25 04:22:31 | Washington, Nebraska, US | |
683850 | 683850 | 2021-10-24 | US | Louisiana | Jackson | 22049 | 2754 | 63 | 0 | 32.30251776 | -92.55692092 | 2021-10-25 04:22:31 | Jackson, Louisiana, US | |
772478 | 772478 | 2021-10-23 | US | Nebraska | Washington | 31177 | 2754 | 25 | 0 | 41.52815707 | -96.22019892 | 2021-10-24 04:21:22 | Washington, Nebraska, US | |
771858 | 771858 | 2021-10-23 | US | Louisiana | Jackson | 22049 | 2754 | 63 | 0 | 32.30251776 | -92.55692092 | 2021-10-24 04:21:22 | Jackson, Louisiana, US | |
656125 | 656125 | 2021-10-22 | US | Nebraska | Washington | 31177 | 2754 | 25 | 0 | 41.52815707 | -96.22019892 | 2021-10-23 04:21:32 | Washington, Nebraska, US | |
655505 | 655505 | 2021-10-22 | US | Louisiana | Jackson | 22049 | 2754 | 63 | 0 | 32.30251776 | -92.55692092 | 2021-10-23 04:21:32 | Jackson, Louisiana, US | |
2125872 | 2125872 | 2021-10-21 | US | Nebraska | Washington | 31177 | 2754 | 25 | 0 | 41.52815707 | -96.22019892 | 2021-10-22 04:21:14 | Washington, Nebraska, US | |
1910615 | 1910615 | 2021-10-17 | US | Kentucky | Garrard | 21079 | 2754 | 45 | 0 | 37.638866799999995 | -84.53289319 | 2021-10-18 04:21:10 | Garrard, Kentucky, US | |
990262 | 990262 | 2021-10-04 | US | Vermont | Franklin | 50011 | 2754 | 43 | 0 | 44.85627605 | -72.91249563 | 2021-10-05 04:21:27 | Franklin, Vermont, US | |
3928680 | 3928680 | 2021-10-02 | US | Colorado | Montezuma | 8083 | 2754 | 36 | 0 | 37.33859579 | -108.59588570000001 | 2021-10-03 04:21:24 | Montezuma, Colorado, US | |
3758689 | 3758689 | 2021-09-21 | US | Iowa | Mahaska | 19123 | 2754 | 53 | 0 | 41.33521503 | -92.64083907 | 2021-09-22 04:21:45 | Mahaska, Iowa, 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]);