johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
120 rows where confirmed = 4975 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 110
- China 2
- Italy 2
- Burundi 1
- Kazakhstan 1
- Netherlands 1
- Pakistan 1
- Peru 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756510 | 2756510 | 2022-12-29 | US | Wyoming | Carbon | 56007 | 4975 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-12-30 04:21:04 | Carbon, Wyoming, US | |
1077516 | 1077516 | 2022-12-28 | US | Wyoming | Carbon | 56007 | 4975 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-12-29 04:21:01 | Carbon, Wyoming, US | |
331513 | 331513 | 2022-12-27 | US | Wyoming | Carbon | 56007 | 4975 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-12-28 04:21:04 | Carbon, Wyoming, US | |
3176784 | 3176784 | 2022-12-19 | US | Tennessee | Sequatchie | 47153 | 4975 | 72 | 0 | 35.36979721 | -85.41022136 | 2022-12-20 04:21:04 | Sequatchie, Tennessee, US | |
1629785 | 1629785 | 2022-12-18 | US | Kentucky | Trigg | 21221 | 4975 | 48 | 0 | 36.80767017 | -87.87333656 | 2022-12-19 04:21:03 | Trigg, Kentucky, US | |
505164 | 505164 | 2022-12-17 | US | Kentucky | Trigg | 21221 | 4975 | 48 | 0 | 36.80767017 | -87.87333656 | 2022-12-18 04:21:03 | Trigg, Kentucky, US | |
3325736 | 3325736 | 2022-12-16 | US | Kentucky | Trigg | 21221 | 4975 | 48 | 0 | 36.80767017 | -87.87333656 | 2022-12-17 04:21:04 | Trigg, Kentucky, US | |
544248 | 544248 | 2022-12-15 | US | Kentucky | Trigg | 21221 | 4975 | 48 | 0 | 36.80767017 | -87.87333656 | 2022-12-16 04:21:01 | Trigg, Kentucky, US | |
349776 | 349776 | 2022-12-14 | US | Kentucky | Trigg | 21221 | 4975 | 48 | 0 | 36.80767017 | -87.87333656 | 2022-12-15 04:20:58 | Trigg, Kentucky, US | |
309364 | 309364 | 2022-12-13 | US | Kentucky | Trigg | 21221 | 4975 | 48 | 0 | 36.80767017 | -87.87333656 | 2022-12-14 04:21:04 | Trigg, Kentucky, US | |
1150425 | 1150425 | 2022-12-12 | US | Kentucky | Trigg | 21221 | 4975 | 48 | 0 | 36.80767017 | -87.87333656 | 2022-12-13 04:21:01 | Trigg, Kentucky, US | |
868614 | 868614 | 2022-12-11 | China | Yunnan | 4975 | 2 | 0 | 24.974 | 101.487 | 2022-12-12 04:21:01 | Yunnan, China | |||
3029797 | 3029797 | 2022-11-17 | US | West Virginia | Morgan | 54065 | 4975 | 76 | 0 | 39.55439028 | -78.26311676 | 2022-11-18 04:21:15 | Morgan, West Virginia, US | |
2025401 | 2025401 | 2022-10-17 | US | Colorado | Otero | 8089 | 4975 | 133 | 0 | 37.9014485 | -103.7173385 | 2022-10-18 04:22:42 | Otero, Colorado, US | |
1563317 | 1563317 | 2022-09-28 | US | Texas | Shelby | 48419 | 4975 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-09-29 04:22:34 | Shelby, Texas, US | |
3997860 | 3997860 | 2022-09-27 | US | Texas | Shelby | 48419 | 4975 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-09-28 04:23:01 | Shelby, Texas, US | |
2772188 | 2772188 | 2022-09-26 | US | Texas | Shelby | 48419 | 4975 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-09-27 04:23:01 | Shelby, Texas, US | |
1347832 | 1347832 | 2022-08-10 | US | Louisiana | Jackson | 22049 | 4975 | 77 | 0 | 32.30251776 | -92.55692092 | 2022-08-11 04:20:49 | Jackson, Louisiana, US | |
1346805 | 1346805 | 2022-08-10 | US | Arkansas | Drew | 5043 | 4975 | 72 | 0 | 33.59035001 | -91.71777921 | 2022-08-11 04:20:49 | Drew, Arkansas, US | |
1073204 | 1073204 | 2022-08-07 | US | Virginia | Bristol | 51520 | 4975 | 83 | 0 | 36.6163024 | -82.16359122 | 2022-08-08 04:21:08 | Bristol, Virginia, US | |
1943792 | 1943792 | 2022-08-06 | US | Virginia | Bristol | 51520 | 4975 | 83 | 0 | 36.6163024 | -82.16359122 | 2022-08-07 04:20:54 | Bristol, Virginia, US | |
883591 | 883591 | 2022-08-05 | US | Virginia | Bristol | 51520 | 4975 | 83 | 0 | 36.6163024 | -82.16359122 | 2022-08-06 04:20:56 | Bristol, Virginia, US | |
1068646 | 1068646 | 2022-07-28 | US | Puerto Rico | Orocovis | 72107 | 4975 | 0 | 0 | 18.215046 | -66.433604 | 2022-07-29 04:20:45 | Orocovis, Puerto Rico, US | |
2742116 | 2742116 | 2022-07-07 | US | Indiana | Jay | 18075 | 4975 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-07-08 04:20:56 | Jay, Indiana, US | |
1200911 | 1200911 | 2022-07-06 | US | Indiana | Jay | 18075 | 4975 | 78 | 0 | 40.43781032 | -85.00576229 | 2022-07-07 04:20:55 | Jay, Indiana, US | |
3940576 | 3940576 | 2022-06-30 | US | Arkansas | Phillips | 5107 | 4975 | 99 | 0 | 34.43268455 | -90.84800154 | 2022-07-01 04:21:10 | Phillips, Arkansas, US | |
2240232 | 2240232 | 2022-06-28 | US | Georgia | Lamar | 13171 | 4975 | 113 | 0 | 33.07841647 | -84.14263877 | 2022-06-29 04:20:59 | Lamar, Georgia, US | |
2148474 | 2148474 | 2022-06-27 | US | Georgia | Lamar | 13171 | 4975 | 113 | 0 | 33.07841647 | -84.14263877 | 2022-06-28 04:20:58 | Lamar, Georgia, US | |
476275 | 476275 | 2022-06-26 | US | Georgia | Lamar | 13171 | 4975 | 113 | 0 | 33.07841647 | -84.14263877 | 2022-06-27 04:21:00 | Lamar, Georgia, US | |
939650 | 939650 | 2022-06-25 | US | Georgia | Lamar | 13171 | 4975 | 113 | 0 | 33.07841647 | -84.14263877 | 2022-06-26 04:21:02 | Lamar, Georgia, US | |
3347470 | 3347470 | 2022-06-24 | US | Georgia | Lamar | 13171 | 4975 | 113 | 0 | 33.07841647 | -84.14263877 | 2022-06-25 04:20:57 | Lamar, Georgia, US | |
1649211 | 1649211 | 2022-06-23 | US | Georgia | Lamar | 13171 | 4975 | 113 | 0 | 33.07841647 | -84.14263877 | 2022-06-24 04:20:58 | Lamar, Georgia, US | |
2188446 | 2188446 | 2022-06-22 | US | Georgia | Lamar | 13171 | 4975 | 113 | 0 | 33.07841647 | -84.14263877 | 2022-06-23 04:20:55 | Lamar, Georgia, US | |
2600034 | 2600034 | 2022-05-05 | US | Montana | Big Horn | 30003 | 4975 | 95 | 0 | 45.42335905 | -107.492347 | 2022-05-06 04:21:00 | Big Horn, Montana, US | |
3267483 | 3267483 | 2022-05-04 | US | Montana | Big Horn | 30003 | 4975 | 95 | 0 | 45.42335905 | -107.492347 | 2022-05-05 04:20:55 | Big Horn, Montana, US | |
1573861 | 1573861 | 2022-05-03 | US | Minnesota | Hubbard | 27057 | 4975 | 59 | 0 | 47.10778564 | -94.91693868 | 2022-05-04 04:20:59 | Hubbard, Minnesota, US | |
1699553 | 1699553 | 2022-04-28 | US | Texas | Scurry | 48415 | 4975 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-04-29 04:20:59 | Scurry, Texas, US | |
3855036 | 3855036 | 2022-04-27 | US | Texas | Scurry | 48415 | 4975 | 104 | 0 | 32.74613808 | -100.9162664 | 2022-04-28 04:20:47 | Scurry, Texas, US | |
1329466 | 1329466 | 2022-04-26 | US | Texas | Scurry | 48415 | 4975 | 104 | 0 | 32.74613808 | -100.91626640000001 | 2022-04-27 04:20:52 | Scurry, Texas, US | |
3725420 | 3725420 | 2022-04-25 | US | Texas | Scurry | 48415 | 4975 | 104 | 0 | 32.74613808 | -100.91626640000001 | 2022-04-26 04:20:51 | Scurry, Texas, US | |
2031988 | 2031988 | 2022-04-24 | US | Texas | Scurry | 48415 | 4975 | 104 | 0 | 32.74613808 | -100.91626640000001 | 2022-04-25 04:20:56 | Scurry, Texas, US | |
749563 | 749563 | 2022-04-23 | US | Texas | Scurry | 48415 | 4975 | 104 | 0 | 32.74613808 | -100.91626640000001 | 2022-04-24 04:20:56 | Scurry, Texas, US | |
2801149 | 2801149 | 2022-04-06 | US | Alabama | Fayette | 1057 | 4975 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-07 04:20:53 | Fayette, Alabama, US | |
3867918 | 3867918 | 2022-04-05 | US | Alabama | Fayette | 1057 | 4975 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-06 04:20:49 | Fayette, Alabama, US | |
2749260 | 2749260 | 2022-04-04 | US | Alabama | Fayette | 1057 | 4975 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-05 04:20:48 | Fayette, Alabama, US | |
3730606 | 3730606 | 2022-04-03 | US | Alabama | Fayette | 1057 | 4975 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-04 04:20:51 | Fayette, Alabama, US | |
500041 | 500041 | 2022-04-02 | US | Alabama | Fayette | 1057 | 4975 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-03 04:20:48 | Fayette, Alabama, US | |
3351026 | 3351026 | 2022-04-01 | US | Alabama | Fayette | 1057 | 4975 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-02 04:20:47 | Fayette, Alabama, US | |
1542269 | 1542269 | 2022-03-31 | US | North Carolina | Currituck | 37053 | 4975 | 32 | 0 | 36.36123664 | -75.95876401 | 2022-04-01 04:20:28 | Currituck, North Carolina, US | |
1540331 | 1540331 | 2022-03-31 | US | Alabama | Fayette | 1057 | 4975 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-04-01 04:20:28 | Fayette, Alabama, US | |
2478344 | 2478344 | 2022-03-30 | US | Alabama | Fayette | 1057 | 4975 | 96 | 0 | 33.72076938 | -87.73886638 | 2022-03-31 04:20:56 | Fayette, Alabama, US | |
160280 | 160280 | 2022-03-29 | US | New York | Schoharie | 36095 | 4975 | 35 | 0 | 42.58831742 | -74.44339029999998 | 2022-03-30 04:20:45 | Schoharie, New York, US | |
26785 | 26785 | 2022-03-20 | US | North Carolina | Yancey | 37199 | 4975 | 51 | 0 | 35.90079156 | -82.31237181 | 2022-03-21 04:20:50 | Yancey, North Carolina, US | |
26078 | 26078 | 2022-03-20 | US | Michigan | Osceola | 26133 | 4975 | 80 | 0 | 43.98992088 | -85.32566756 | 2022-03-21 04:20:50 | Osceola, Michigan, US | |
1658795 | 1658795 | 2022-03-19 | US | North Carolina | Yancey | 37199 | 4975 | 51 | 0 | 35.90079156 | -82.31237181 | 2022-03-20 04:20:45 | Yancey, North Carolina, US | |
1658088 | 1658088 | 2022-03-19 | US | Michigan | Osceola | 26133 | 4975 | 80 | 0 | 43.98992088 | -85.32566756 | 2022-03-20 04:20:45 | Osceola, Michigan, US | |
338321 | 338321 | 2022-03-18 | US | North Carolina | Yancey | 37199 | 4975 | 51 | 0 | 35.90079156 | -82.31237181 | 2022-03-19 04:20:47 | Yancey, North Carolina, US | |
337614 | 337614 | 2022-03-18 | US | Michigan | Osceola | 26133 | 4975 | 80 | 0 | 43.98992088 | -85.32566756 | 2022-03-19 04:20:47 | Osceola, Michigan, US | |
2526925 | 2526925 | 2022-03-02 | US | Maine | Lincoln | 23015 | 4975 | 29 | 0 | 44.05996956 | -69.54227124 | 2022-03-03 04:21:01 | Lincoln, Maine, US | |
944212 | 944212 | 2022-02-28 | US | Kentucky | Breckinridge | 21027 | 4975 | 71 | 0 | 37.77377239 | -86.42885017 | 2022-03-01 04:21:09 | Breckinridge, Kentucky, US | |
3721475 | 3721475 | 2022-02-21 | US | Vermont | Orleans | 50019 | 4975 | 33 | 0 | 44.82964024 | -72.24562697 | 2022-02-22 04:21:01 | Orleans, Vermont, US | |
3915309 | 3915309 | 2022-02-20 | US | Vermont | Orleans | 50019 | 4975 | 33 | 0 | 44.82964024 | -72.24562697 | 2022-02-21 04:21:05 | Orleans, Vermont, US | |
3878867 | 3878867 | 2022-02-19 | US | Vermont | Orleans | 50019 | 4975 | 33 | 0 | 44.82964024 | -72.24562697 | 2022-02-20 04:21:00 | Orleans, Vermont, US | |
3859123 | 3859123 | 2022-02-18 | US | Vermont | Orleans | 50019 | 4975 | 33 | 0 | 44.82964024 | -72.24562697 | 2022-02-19 04:21:11 | Orleans, Vermont, US | |
1298932 | 1298932 | 2022-02-17 | US | Georgia | Tattnall | 13267 | 4975 | 126 | 0 | 32.04785085 | -82.05539188 | 2022-02-18 04:21:04 | Tattnall, Georgia, US | |
3674583 | 3674583 | 2022-02-15 | US | Tennessee | Crockett | 47033 | 4975 | 81 | 0 | 35.81830662 | -89.14916269 | 2022-02-16 04:21:10 | Crockett, Tennessee, US | |
1464886 | 1464886 | 2022-02-10 | US | Georgia | Fannin | 13111 | 4975 | 131 | 0 | 34.86430205 | -84.316964 | 2022-02-11 04:21:09 | Fannin, Georgia, US | |
2660268 | 2660268 | 2022-01-31 | US | Ohio | Holmes | 39075 | 4975 | 176 | 0 | 40.56163713 | -81.92635677 | 2022-02-01 04:21:11 | Holmes, Ohio, US | |
1283494 | 1283494 | 2022-01-05 | US | Louisiana | East Feliciana | 22037 | 4975 | 148 | 0 | 30.84425359 | -91.04976723 | 2022-01-06 04:22:09 | East Feliciana, Louisiana, US | |
731335 | 731335 | 2021-12-27 | US | Georgia | Gilmer | 13123 | 4975 | 142 | 0 | 34.69316688 | -84.45802506 | 2021-12-28 04:21:47 | Gilmer, Georgia, US | |
798959 | 798959 | 2021-12-22 | US | Arkansas | St. Francis | 5123 | 4975 | 72 | 0 | 35.02201976 | -90.74828138 | 2021-12-23 04:21:21 | St. Francis, Arkansas, US | |
3830205 | 3830205 | 2021-12-21 | US | Minnesota | Le Sueur | 27079 | 4975 | 40 | 0 | 44.37136597 | -93.72844721 | 2021-12-22 04:21:54 | Le Sueur, Minnesota, US | |
1719188 | 1719188 | 2021-12-16 | US | South Carolina | Marlboro | 45069 | 4975 | 86 | 0 | 34.59905577 | -79.67561152 | 2021-12-17 04:22:14 | Marlboro, South Carolina, US | |
3112 | 3112 | 2021-12-02 | US | Puerto Rico | Toa Alta | 72135 | 4975 | 0 | 0 | 18.362406 | -66.246616 | 2021-12-03 04:23:05 | Toa Alta, Puerto Rico, US | |
682707 | 682707 | 2021-10-24 | US | Alabama | Dallas | 1047 | 4975 | 200 | 0 | 32.32688101 | -87.10866709999998 | 2021-10-25 04:22:31 | Dallas, Alabama, US | |
657251 | 657251 | 2021-10-22 | US | Texas | Willacy | 48489 | 4975 | 110 | 0 | 26.47411727 | -97.61535848 | 2021-10-23 04:21:32 | Willacy, Texas, US | |
2045290 | 2045290 | 2021-10-18 | US | Kentucky | Marshall | 21157 | 4975 | 77 | 0 | 36.88007070000001 | -88.32803576 | 2021-10-19 04:20:54 | Marshall, Kentucky, US | |
1910651 | 1910651 | 2021-10-17 | US | Kentucky | Marshall | 21157 | 4975 | 77 | 0 | 36.88007070000001 | -88.32803576 | 2021-10-18 04:21:10 | Marshall, Kentucky, US | |
1493036 | 1493036 | 2021-10-12 | US | Kentucky | Logan | 21141 | 4975 | 79 | 0 | 36.85949479 | -86.877635 | 2021-10-13 04:20:51 | Logan, Kentucky, US | |
2960762 | 2960762 | 2021-10-08 | US | Kentucky | Clark | 21049 | 4975 | 34 | 0 | 37.9689263 | -84.14615986 | 2021-10-09 04:21:34 | Clark, Kentucky, US | |
2775208 | 2775208 | 2021-09-30 | US | New York | Cortland | 36023 | 4975 | 72 | 0 | 42.59509207 | -76.07048931 | 2021-10-01 04:21:35 | Cortland, New York, US | |
2521740 | 2521740 | 2021-08-18 | US | Wisconsin | Monroe | 55081 | 4975 | 51 | 0 | 43.94641218 | -90.61881899999999 | 2021-08-19 04:21:15 | Monroe, Wisconsin, US | |
2353105 | 2353105 | 2021-08-10 | US | Michigan | Newaygo | 26123 | 4975 | 69 | 0 | 43.554373999999996 | -85.80070107 | 2021-08-11 04:21:58 | Newaygo, Michigan, US | |
651634 | 651634 | 2021-08-09 | US | Michigan | Newaygo | 26123 | 4975 | 69 | 0 | 43.554373999999996 | -85.80070107 | 2021-08-10 04:21:27 | Newaygo, Michigan, US | |
3299347 | 3299347 | 2021-07-30 | US | Texas | Medina | 48325 | 4975 | 108 | 0 | 29.3557301 | -99.11030298 | 2021-07-31 04:21:35 | Medina, Texas, US | |
580745 | 580745 | 2021-07-13 | US | Missouri | Johnson | 29101 | 4975 | 59 | 0 | 38.74719601 | -93.80691168 | 2021-07-14 04:21:35 | Johnson, Missouri, US | |
3961816 | 3961816 | 2021-06-26 | US | Virginia | Campbell | 51031 | 4975 | 99 | 0 | 37.20553386 | -79.09678609 | 2021-06-27 04:21:39 | Campbell, Virginia, US | |
3970309 | 3970309 | 2021-06-11 | Burundi | 4975 | 8 | 773 | 4194 | -3.3731 | 29.9189 | 2021-06-12 04:22:22 | Burundi | |||
85532 | 85532 | 2021-05-25 | US | Ohio | Auglaize | 39011 | 4975 | 87 | 0 | 40.55998859 | -84.22421429999999 | 2021-05-26 04:20:35 | Auglaize, Ohio, US | |
84223 | 84223 | 2021-05-25 | US | Indiana | Shelby | 18145 | 4975 | 96 | 0 | 39.52305623 | -85.79158570000001 | 2021-05-26 04:20:35 | Shelby, Indiana, US | |
2391614 | 2391614 | 2021-05-18 | US | Georgia | Murray | 13213 | 4975 | 86 | 0 | 34.78897608 | -84.74993177 | 2021-05-19 04:20:42 | Murray, Georgia, US | |
3055666 | 3055666 | 2021-05-13 | US | Kentucky | Whitley | 21235 | 4975 | 57 | 0 | 36.75700531 | -84.14541217 | 2021-05-14 04:20:41 | Whitley, Kentucky, US | |
3006971 | 3006971 | 2021-04-06 | Yemen | 4975 | 976 | 1822 | 2177 | 15.552727 | 48.516388 | 2021-04-07 04:20:53 | Yemen | |||
640425 | 640425 | 2021-03-31 | US | Ohio | Sandusky | 39143 | 4975 | 121 | 0 | 41.35624126 | -83.137872 | 2021-04-01 04:27:05 | Sandusky, Ohio, US | |
3644357 | 3644357 | 2021-03-30 | US | Georgia | Habersham | 13137 | 4975 | 151 | 0 | 34.63331566 | -83.53094677 | 2021-03-31 04:26:25 | Habersham, Georgia, US | |
1538857 | 1538857 | 2021-03-28 | US | Tennessee | Franklin | 47051 | 4975 | 86 | 0 | 35.15634626 | -86.09201039 | 2021-03-29 04:28:35 | Franklin, Tennessee, US | |
1881468 | 1881468 | 2021-03-26 | US | Arkansas | Hot Spring | 5059 | 4975 | 69 | 0 | 34.31709259 | -92.95396325 | 2021-03-27 05:25:04 | Hot Spring, Arkansas, US | |
1983086 | 1983086 | 2021-03-25 | US | Ohio | Jefferson | 39081 | 4975 | 150 | 0 | 40.38614126 | -80.76259514 | 2021-03-26 05:26:55 | Jefferson, Ohio, US | |
1798781 | 1798781 | 2021-03-23 | Pakistan | Gilgit-Baltistan | 4975 | 103 | 4856 | 16 | 35.792146 | 74.982138 | 2021-03-24 05:25:40 | Gilgit-Baltistan, Pakistan | ||
2369195 | 2369195 | 2021-02-28 | US | Minnesota | Chisago | 27025 | 4975 | 45 | 0 | 4930 | 45.5021011 | -92.90861945 | 2021-03-01 05:23:01 | Chisago, Minnesota, 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]);