johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
168 rows where confirmed = 4952 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2756068 | 2756068 | 2022-12-29 | US | Texas | Llano | 48299 | 4952 | 99 | 0 | 30.70645047 | -98.68475262 | 2022-12-30 04:21:04 | Llano, Texas, US | |
1077074 | 1077074 | 2022-12-28 | US | Texas | Llano | 48299 | 4952 | 99 | 0 | 30.70645047 | -98.68475262 | 2022-12-29 04:21:01 | Llano, Texas, US | |
2418481 | 2418481 | 2022-12-05 | US | Wyoming | Carbon | 56007 | 4952 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-12-06 04:21:03 | Carbon, Wyoming, US | |
722089 | 722089 | 2022-12-04 | US | Wyoming | Carbon | 56007 | 4952 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-12-05 04:20:58 | Carbon, Wyoming, US | |
2820378 | 2820378 | 2022-12-03 | US | Wyoming | Carbon | 56007 | 4952 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-12-04 04:20:56 | Carbon, Wyoming, US | |
837234 | 837234 | 2022-12-02 | US | Wyoming | Carbon | 56007 | 4952 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-12-03 04:21:02 | Carbon, Wyoming, US | |
2139764 | 2139764 | 2022-12-01 | US | Wyoming | Carbon | 56007 | 4952 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-12-02 04:21:07 | Carbon, Wyoming, US | |
1968180 | 1968180 | 2022-11-30 | US | Wyoming | Carbon | 56007 | 4952 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-12-01 04:21:03 | Carbon, Wyoming, US | |
2560194 | 2560194 | 2022-11-29 | US | Wyoming | Carbon | 56007 | 4952 | 55 | 0 | 41.69357844 | -106.9326084 | 2022-11-30 04:21:07 | Carbon, Wyoming, US | |
1623566 | 1623566 | 2022-11-22 | US | Vermont | Orange | 50017 | 4952 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-11-23 04:21:06 | Orange, Vermont, US | |
3463454 | 3463454 | 2022-11-21 | US | Vermont | Orange | 50017 | 4952 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-11-22 04:20:47 | Orange, Vermont, US | |
1643639 | 1643639 | 2022-11-20 | US | Vermont | Orange | 50017 | 4952 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-11-21 04:21:05 | Orange, Vermont, US | |
2067196 | 2067196 | 2022-11-19 | US | Vermont | Orange | 50017 | 4952 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-11-20 04:21:08 | Orange, Vermont, US | |
1758590 | 1758590 | 2022-11-18 | US | Vermont | Orange | 50017 | 4952 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-11-19 04:21:14 | Orange, Vermont, US | |
3029583 | 3029583 | 2022-11-17 | US | Vermont | Orange | 50017 | 4952 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-11-18 04:21:15 | Orange, Vermont, US | |
2489294 | 2489294 | 2022-11-16 | US | Vermont | Orange | 50017 | 4952 | 14 | 0 | 44.00470222 | -72.37640104 | 2022-11-17 04:21:11 | Orange, Vermont, US | |
2686344 | 2686344 | 2022-10-03 | US | Colorado | Otero | 8089 | 4952 | 132 | 0 | 37.9014485 | -103.7173385 | 2022-10-04 04:22:55 | Otero, Colorado, US | |
2262922 | 2262922 | 2022-10-02 | US | Texas | Lee | 48287 | 4952 | 62 | 0 | 30.31120597 | -96.97045773 | 2022-10-03 04:23:11 | Lee, Texas, US | |
2260411 | 2260411 | 2022-10-02 | US | Colorado | Otero | 8089 | 4952 | 132 | 0 | 37.9014485 | -103.7173385 | 2022-10-03 04:23:11 | Otero, Colorado, US | |
2998448 | 2998448 | 2022-10-01 | US | Texas | Lee | 48287 | 4952 | 62 | 0 | 30.31120597 | -96.97045773 | 2022-10-02 04:21:23 | Lee, Texas, US | |
2995937 | 2995937 | 2022-10-01 | US | Colorado | Otero | 8089 | 4952 | 132 | 0 | 37.9014485 | -103.7173385 | 2022-10-02 04:21:23 | Otero, Colorado, US | |
856774 | 856774 | 2022-09-30 | US | Texas | Lee | 48287 | 4952 | 62 | 0 | 30.31120597 | -96.97045773 | 2022-10-01 04:23:01 | Lee, Texas, US | |
854263 | 854263 | 2022-09-30 | US | Colorado | Otero | 8089 | 4952 | 132 | 0 | 37.9014485 | -103.7173385 | 2022-10-01 04:23:01 | Otero, Colorado, US | |
3989849 | 3989849 | 2022-09-15 | US | Texas | Shelby | 48419 | 4952 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-09-16 04:21:19 | Shelby, Texas, US | |
1892366 | 1892366 | 2022-09-14 | US | Texas | Shelby | 48419 | 4952 | 134 | 0 | 31.79211404 | -94.14550696 | 2022-09-15 04:21:02 | Shelby, Texas, US | |
115551 | 115551 | 2022-09-06 | US | Georgia | Elbert | 13105 | 4952 | 116 | 0 | 34.11302332 | -82.83936148 | 2022-09-07 04:20:59 | Elbert, Georgia, US | |
2634523 | 2634523 | 2022-09-05 | US | Georgia | Elbert | 13105 | 4952 | 116 | 0 | 34.11302332 | -82.83936148 | 2022-09-06 04:21:02 | Elbert, Georgia, US | |
2988087 | 2988087 | 2022-09-04 | US | Georgia | Elbert | 13105 | 4952 | 116 | 0 | 34.11302332 | -82.83936148 | 2022-09-05 04:21:01 | Elbert, Georgia, US | |
2713772 | 2713772 | 2022-09-03 | US | Georgia | Elbert | 13105 | 4952 | 116 | 0 | 34.11302332 | -82.83936148 | 2022-09-04 04:21:22 | Elbert, Georgia, US | |
1394477 | 1394477 | 2022-09-02 | US | Georgia | Elbert | 13105 | 4952 | 116 | 0 | 34.11302332 | -82.83936148 | 2022-09-03 04:21:04 | Elbert, Georgia, US | |
3548306 | 3548306 | 2022-09-01 | US | Georgia | Elbert | 13105 | 4952 | 116 | 0 | 34.11302332 | -82.83936148 | 2022-09-02 04:21:07 | Elbert, Georgia, US | |
2344226 | 2344226 | 2022-08-31 | US | Georgia | Elbert | 13105 | 4952 | 116 | 0 | 34.11302332 | -82.83936148 | 2022-09-01 04:21:03 | Elbert, Georgia, US | |
1683641 | 1683641 | 2022-08-29 | US | Texas | Jones | 48253 | 4952 | 93 | 0 | 32.73997145 | -99.87861576 | 2022-08-30 04:21:03 | Jones, Texas, US | |
2829804 | 2829804 | 2022-08-25 | US | Illinois | Ford | 17053 | 4952 | 69 | 0 | 40.59706922 | -88.22350769 | 2022-08-26 04:21:02 | Ford, Illinois, US | |
992547 | 992547 | 2022-08-16 | US | Louisiana | Winn | 22127 | 4952 | 65 | 0 | 31.94449367 | -92.63789413 | 2022-08-17 04:20:59 | Winn, Louisiana, US | |
2011609 | 2011609 | 2022-08-04 | US | Tennessee | Benton | 47005 | 4952 | 96 | 0 | 36.07110411 | -88.06849355 | 2022-08-05 04:20:52 | Benton, Tennessee, US | |
3941929 | 3941929 | 2022-06-30 | US | Missouri | Andrew | 29003 | 4952 | 59 | 0 | 39.98492163 | -94.80163024 | 2022-07-01 04:21:10 | Andrew, Missouri, US | |
2491887 | 2491887 | 2022-06-29 | US | Missouri | Andrew | 29003 | 4952 | 59 | 0 | 39.98492163 | -94.80163024 | 2022-06-30 04:21:01 | Andrew, Missouri, US | |
2241269 | 2241269 | 2022-06-28 | US | Missouri | Andrew | 29003 | 4952 | 59 | 0 | 39.98492163 | -94.80163024 | 2022-06-29 04:20:59 | Andrew, Missouri, US | |
2149511 | 2149511 | 2022-06-27 | US | Missouri | Andrew | 29003 | 4952 | 59 | 0 | 39.98492163 | -94.80163024 | 2022-06-28 04:20:58 | Andrew, Missouri, US | |
477312 | 477312 | 2022-06-26 | US | Missouri | Andrew | 29003 | 4952 | 59 | 0 | 39.98492163 | -94.80163024 | 2022-06-27 04:21:00 | Andrew, Missouri, US | |
940687 | 940687 | 2022-06-25 | US | Missouri | Andrew | 29003 | 4952 | 59 | 0 | 39.98492163 | -94.80163024 | 2022-06-26 04:21:02 | Andrew, Missouri, US | |
3348507 | 3348507 | 2022-06-24 | US | Missouri | Andrew | 29003 | 4952 | 59 | 0 | 39.98492163 | -94.80163024 | 2022-06-25 04:20:57 | Andrew, Missouri, US | |
3400383 | 3400383 | 2022-06-18 | US | Tennessee | Humphreys | 47085 | 4952 | 75 | 0 | 36.03958805 | -87.77992872 | 2022-06-19 04:20:51 | Humphreys, Tennessee, US | |
2314260 | 2314260 | 2022-06-17 | US | Tennessee | Humphreys | 47085 | 4952 | 75 | 0 | 36.03958805 | -87.77992872 | 2022-06-18 04:21:10 | Humphreys, Tennessee, US | |
1506777 | 1506777 | 2022-05-16 | US | Texas | Milam | 48331 | 4952 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-05-17 04:20:59 | Milam, Texas, US | |
2087136 | 2087136 | 2022-05-15 | US | Texas | Milam | 48331 | 4952 | 102 | 0 | 30.7858183 | -96.97718698 | 2022-05-16 04:20:47 | Milam, Texas, US | |
304528 | 304528 | 2022-04-16 | US | Colorado | Teller | 8119 | 4952 | 57 | 0 | 38.88133511 | -105.16148929999999 | 2022-04-17 04:20:59 | Teller, Colorado, US | |
2481310 | 2481310 | 2022-03-30 | US | Virginia | Fluvanna | 51065 | 4952 | 42 | 0 | 37.84157909 | -78.27715475 | 2022-03-31 04:20:56 | Fluvanna, Virginia, US | |
3024542 | 3024542 | 2022-03-23 | US | New York | Schoharie | 36095 | 4952 | 34 | 0 | 42.58831742 | -74.44339029999998 | 2022-03-24 04:20:43 | Schoharie, New York, US | |
1907464 | 1907464 | 2022-03-22 | US | New York | Schoharie | 36095 | 4952 | 34 | 0 | 42.58831742 | -74.44339029999998 | 2022-03-23 04:20:48 | Schoharie, New York, US | |
3240595 | 3240595 | 2022-03-21 | US | New York | Schoharie | 36095 | 4952 | 34 | 0 | 42.58831742 | -74.44339029999998 | 2022-03-22 04:20:54 | Schoharie, New York, US | |
26668 | 26668 | 2022-03-20 | US | New York | Schoharie | 36095 | 4952 | 34 | 0 | 42.58831742 | -74.44339029999998 | 2022-03-21 04:20:50 | Schoharie, New York, US | |
1658678 | 1658678 | 2022-03-19 | US | New York | Schoharie | 36095 | 4952 | 34 | 0 | 42.58831742 | -74.44339029999998 | 2022-03-20 04:20:45 | Schoharie, New York, US | |
951485 | 951485 | 2022-03-12 | US | Colorado | Elbert | 8039 | 4952 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-03-13 04:20:49 | Elbert, Colorado, US | |
356946 | 356946 | 2022-03-11 | US | Colorado | Elbert | 8039 | 4952 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-03-12 04:20:50 | Elbert, Colorado, US | |
1866098 | 1866098 | 2022-03-10 | US | Colorado | Elbert | 8039 | 4952 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-03-11 04:20:50 | Elbert, Colorado, US | |
2140793 | 2140793 | 2022-03-09 | US | Colorado | Elbert | 8039 | 4952 | 40 | 0 | 39.28656773 | -104.13587209999999 | 2022-03-10 04:20:48 | Elbert, Colorado, US | |
2475320 | 2475320 | 2022-02-03 | US | Kentucky | Adair | 21001 | 4952 | 95 | 0 | 37.10459774 | -85.28129668 | 2022-02-04 04:21:10 | Adair, Kentucky, US | |
459851 | 459851 | 2022-02-02 | US | Arkansas | Clark | 5019 | 4952 | 70 | 0 | 34.04613432 | -93.17484713 | 2022-02-03 04:21:21 | Clark, Arkansas, US | |
3812410 | 3812410 | 2022-01-28 | US | Ohio | Holmes | 39075 | 4952 | 176 | 0 | 40.56163713 | -81.92635677 | 2022-01-29 04:21:10 | Holmes, Ohio, US | |
3466982 | 3466982 | 2022-01-18 | US | South Carolina | Barnwell | 45011 | 4952 | 88 | 0 | 33.26679302 | -81.43584352 | 2022-01-19 04:21:23 | Barnwell, South Carolina, US | |
2613567 | 2613567 | 2022-01-06 | US | West Virginia | Upshur | 54097 | 4952 | 74 | 0 | 38.89285061 | -80.23689136 | 2022-01-07 04:22:09 | Upshur, West Virginia, US | |
3521736 | 3521736 | 2022-01-02 | US | North Carolina | Cherokee | 37039 | 4952 | 89 | 0 | 35.1349263 | -84.05970864 | 2022-01-03 02:22:25 | Cherokee, North Carolina, US | |
2169866 | 2169866 | 2022-01-01 | US | North Carolina | Cherokee | 37039 | 4952 | 89 | 0 | 35.1349263 | -84.05970864 | 2022-01-02 04:20:52 | Cherokee, North Carolina, US | |
2779297 | 2779297 | 2021-12-31 | US | North Carolina | Cherokee | 37039 | 4952 | 89 | 0 | 35.1349263 | -84.05970864 | 2022-01-01 04:22:14 | Cherokee, North Carolina, US | |
4000954 | 4000954 | 2021-12-30 | US | North Carolina | Cherokee | 37039 | 4952 | 89 | 0 | 35.1349263 | -84.05970864 | 2021-12-31 04:21:50 | Cherokee, North Carolina, US | |
798280 | 798280 | 2021-12-22 | Comoros | 4952 | 152 | 0 | -11.6455 | 43.3333 | 2021-12-23 04:21:21 | Comoros | ||||
2905863 | 2905863 | 2021-12-19 | US | Nevada | Nye | 32023 | 4952 | 180 | 0 | 38.04264256 | -116.47227020000001 | 2021-12-20 04:21:43 | Nye, Nevada, US | |
1260936 | 1260936 | 2021-12-18 | US | Nevada | Nye | 32023 | 4952 | 180 | 0 | 38.04264256 | -116.47227020000001 | 2021-12-19 04:21:11 | Nye, Nevada, US | |
2400964 | 2400964 | 2021-12-17 | US | Nevada | Nye | 32023 | 4952 | 180 | 0 | 38.04264256 | -116.47227020000001 | 2021-12-18 02:22:20 | Nye, Nevada, US | |
3499617 | 3499617 | 2021-12-15 | US | Virginia | Wythe | 51197 | 4952 | 114 | 0 | 36.91582035 | -81.07834059 | 2021-12-16 04:22:11 | Wythe, Virginia, US | |
2088876 | 2088876 | 2021-12-14 | US | Georgia | White | 13311 | 4952 | 133 | 0 | 34.64624278 | -83.74905525 | 2021-12-15 03:22:16 | White, Georgia, US | |
1662238 | 1662238 | 2021-12-12 | US | Mississippi | Itawamba | 28057 | 4952 | 107 | 0 | 34.27993475 | -88.3606733 | 2021-12-13 04:22:02 | Itawamba, Mississippi, US | |
1666254 | 1666254 | 2021-12-11 | US | Mississippi | Itawamba | 28057 | 4952 | 107 | 0 | 34.27993475 | -88.3606733 | 2021-12-12 04:22:12 | Itawamba, Mississippi, US | |
3657406 | 3657406 | 2021-12-10 | US | Mississippi | Itawamba | 28057 | 4952 | 107 | 0 | 34.27993475 | -88.3606733 | 2021-12-11 04:22:45 | Itawamba, Mississippi, US | |
2492 | 2492 | 2021-12-02 | US | New Hampshire | Sullivan | 33019 | 4952 | 40 | 0 | 43.36094111 | -72.22203125 | 2021-12-03 04:23:05 | Sullivan, New Hampshire, US | |
3345190 | 3345190 | 2021-11-16 | US | Oklahoma | Lincoln | 40081 | 4952 | 112 | 0 | 35.70270942 | -96.8812462 | 2021-11-17 04:21:48 | Lincoln, Oklahoma, US | |
3344463 | 3344463 | 2021-11-16 | US | Mississippi | Prentiss | 28117 | 4952 | 83 | 0 | 34.61810501 | -88.51986294 | 2021-11-17 04:21:48 | Prentiss, Mississippi, US | |
2290026 | 2290026 | 2021-11-15 | US | Oklahoma | Lincoln | 40081 | 4952 | 112 | 0 | 35.70270942 | -96.8812462 | 2021-11-16 04:21:10 | Lincoln, Oklahoma, US | |
2289194 | 2289194 | 2021-11-15 | US | Minnesota | Lyon | 27083 | 4952 | 59 | 0 | 44.41327865 | -95.83806103 | 2021-11-16 04:21:10 | Lyon, Minnesota, US | |
1324800 | 1324800 | 2021-11-14 | US | Oklahoma | Lincoln | 40081 | 4952 | 112 | 0 | 35.70270942 | -96.8812462 | 2021-11-15 04:21:36 | Lincoln, Oklahoma, US | |
688926 | 688926 | 2021-11-13 | US | Oklahoma | Lincoln | 40081 | 4952 | 112 | 0 | 35.70270942 | -96.8812462 | 2021-11-14 04:21:31 | Lincoln, Oklahoma, US | |
717035 | 717035 | 2021-11-12 | US | Oklahoma | Lincoln | 40081 | 4952 | 112 | 0 | 35.70270942 | -96.8812462 | 2021-11-13 04:21:38 | Lincoln, Oklahoma, US | |
3512469 | 3512469 | 2021-11-01 | US | Indiana | Adams | 18001 | 4952 | 78 | 0 | 40.7457653 | -84.93671406 | 2021-11-02 04:22:03 | Adams, Indiana, US | |
3493013 | 3493013 | 2021-10-26 | US | Georgia | Madison | 13195 | 4952 | 74 | 0 | 34.12920917 | -83.21218732 | 2021-10-27 04:22:32 | Madison, Georgia, US | |
685953 | 685953 | 2021-10-24 | US | Wyoming | Park | 56029 | 4952 | 70 | 0 | 44.52157546 | -109.58528249999999 | 2021-10-25 04:22:31 | Park, Wyoming, US | |
684557 | 684557 | 2021-10-24 | US | New Mexico | Unassigned | 90035 | 4952 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-10-25 04:22:31 | Unassigned, New Mexico, US | |
773961 | 773961 | 2021-10-23 | US | Wyoming | Park | 56029 | 4952 | 70 | 0 | 44.52157546 | -109.58528249999999 | 2021-10-24 04:21:22 | Park, Wyoming, US | |
772565 | 772565 | 2021-10-23 | US | New Mexico | Unassigned | 90035 | 4952 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-10-24 04:21:22 | Unassigned, New Mexico, US | |
657608 | 657608 | 2021-10-22 | US | Wyoming | Park | 56029 | 4952 | 70 | 0 | 44.52157546 | -109.58528249999999 | 2021-10-23 04:21:32 | Park, Wyoming, US | |
656212 | 656212 | 2021-10-22 | US | New Mexico | Unassigned | 90035 | 4952 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-10-23 04:21:32 | Unassigned, New Mexico, US | |
2125959 | 2125959 | 2021-10-21 | US | New Mexico | Unassigned | 90035 | 4952 | 0 | 0 | 36.60569702 | -108.7151824 | 2021-10-22 04:21:14 | Unassigned, New Mexico, US | |
2943745 | 2943745 | 2021-10-15 | US | Alabama | Marion | 1093 | 4952 | 126 | 0 | 34.13697363 | -87.88704173 | 2021-10-16 04:21:15 | Marion, Alabama, US | |
468800 | 468800 | 2021-10-07 | US | Kentucky | Clark | 21049 | 4952 | 32 | 0 | 37.9689263 | -84.14615986 | 2021-10-08 04:21:25 | Clark, Kentucky, US | |
3833513 | 3833513 | 2021-10-05 | US | Illinois | Morgan | 17137 | 4952 | 98 | 0 | 39.71654544 | -90.20255104 | 2021-10-06 04:21:33 | Morgan, Illinois, US | |
1239033 | 1239033 | 2021-09-27 | US | Virginia | Petersburg | 51730 | 4952 | 98 | 0 | 37.20530399 | -77.39368102 | 2021-09-28 04:21:28 | Petersburg, Virginia, US | |
3012785 | 3012785 | 2021-09-22 | US | Kentucky | Muhlenberg | 21177 | 4952 | 81 | 0 | 37.21425819 | -87.14632053 | 2021-09-23 04:21:43 | Muhlenberg, Kentucky, US | |
1376230 | 1376230 | 2021-09-15 | US | Minnesota | McLeod | 27085 | 4952 | 62 | 0 | 44.82367677 | -94.27287017 | 2021-09-16 04:22:19 | McLeod, Minnesota, US | |
1888464 | 1888464 | 2021-09-12 | US | Washington | Whitman | 53075 | 4952 | 55 | 0 | 46.90022523 | -117.52417630000001 | 2021-09-13 04:21:15 | Whitman, Washington, 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]);