johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
345 rows where confirmed = 1992 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3174305 | 3174305 | 2022-12-19 | US | Arkansas | Newton | 5101 | 1992 | 52 | 0 | 35.91947491 | -93.21612969 | 2022-12-20 04:21:04 | Newton, Arkansas, US | |
1628822 | 1628822 | 2022-12-18 | US | Arkansas | Newton | 5101 | 1992 | 52 | 0 | 35.91947491 | -93.21612969 | 2022-12-19 04:21:03 | Newton, Arkansas, US | |
2559663 | 2559663 | 2022-11-29 | US | Texas | Delta | 48119 | 1992 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-11-30 04:21:07 | Delta, Texas, US | |
1242737 | 1242737 | 2022-11-28 | US | Texas | Delta | 48119 | 1992 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-11-29 04:21:05 | Delta, Texas, US | |
3554725 | 3554725 | 2022-11-27 | US | Texas | Delta | 48119 | 1992 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-11-28 04:21:02 | Delta, Texas, US | |
2103205 | 2103205 | 2022-11-26 | US | Texas | Delta | 48119 | 1992 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-11-27 04:21:05 | Delta, Texas, US | |
490696 | 490696 | 2022-11-25 | US | Texas | Delta | 48119 | 1992 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-11-26 04:21:11 | Delta, Texas, US | |
3526525 | 3526525 | 2022-11-24 | US | Texas | Delta | 48119 | 1992 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-11-25 04:21:06 | Delta, Texas, US | |
3315308 | 3315308 | 2022-11-23 | US | Texas | Delta | 48119 | 1992 | 27 | 0 | 33.38570922 | -95.66921122 | 2022-11-24 04:21:09 | Delta, Texas, US | |
1831362 | 1831362 | 2022-10-25 | US | Iowa | Ida | 19093 | 1992 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-10-26 04:22:19 | Ida, Iowa, US | |
795623 | 795623 | 2022-10-24 | US | Iowa | Ida | 19093 | 1992 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-10-25 04:21:53 | Ida, Iowa, US | |
3278078 | 3278078 | 2022-10-23 | US | Iowa | Ida | 19093 | 1992 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-10-24 04:22:29 | Ida, Iowa, US | |
2269116 | 2269116 | 2022-10-22 | US | Iowa | Ida | 19093 | 1992 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-10-23 04:22:46 | Ida, Iowa, US | |
1593416 | 1593416 | 2022-10-21 | US | Iowa | Ida | 19093 | 1992 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-10-22 04:22:53 | Ida, Iowa, US | |
2273132 | 2273132 | 2022-10-20 | US | Iowa | Ida | 19093 | 1992 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-10-21 04:22:23 | Ida, Iowa, US | |
199467 | 199467 | 2022-10-19 | US | Iowa | Ida | 19093 | 1992 | 49 | 0 | 42.38696136 | -95.51355387 | 2022-10-20 04:22:59 | Ida, Iowa, US | |
1626331 | 1626331 | 2022-09-22 | US | Montana | Valley | 30105 | 1992 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-09-23 04:23:13 | Valley, Montana, US | |
1372535 | 1372535 | 2022-09-21 | US | Montana | Valley | 30105 | 1992 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-09-22 04:22:56 | Valley, Montana, US | |
2018765 | 2018765 | 2022-09-20 | US | Montana | Valley | 30105 | 1992 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-09-21 04:23:22 | Valley, Montana, US | |
3572638 | 3572638 | 2022-09-19 | US | Montana | Valley | 30105 | 1992 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-09-20 04:22:48 | Valley, Montana, US | |
421377 | 421377 | 2022-09-18 | US | Montana | Valley | 30105 | 1992 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-09-19 04:21:49 | Valley, Montana, US | |
3375401 | 3375401 | 2022-09-17 | US | Montana | Valley | 30105 | 1992 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-09-18 04:22:50 | Valley, Montana, US | |
2357509 | 2357509 | 2022-09-16 | US | Montana | Valley | 30105 | 1992 | 39 | 0 | 48.36435097 | -106.6669635 | 2022-09-17 04:20:19 | Valley, Montana, US | |
1681155 | 1681155 | 2022-08-29 | US | Colorado | Rio Blanco | 8103 | 1992 | 13 | 0 | 39.97913541 | -108.2179009 | 2022-08-30 04:21:03 | Rio Blanco, Colorado, US | |
2855846 | 2855846 | 2022-08-22 | US | Tennessee | Pickett | 47137 | 1992 | 38 | 0 | 36.55606529 | -85.077633 | 2022-08-23 04:20:56 | Pickett, Tennessee, US | |
1072898 | 1072898 | 2022-08-07 | US | Tennessee | Van Buren | 47175 | 1992 | 48 | 0 | 35.69864497 | -85.45221699 | 2022-08-08 04:21:08 | Van Buren, Tennessee, US | |
1408109 | 1408109 | 2022-08-02 | US | Texas | Crosby | 48107 | 1992 | 45 | 0 | 33.61431553 | -101.3000364 | 2022-08-03 04:20:59 | Crosby, Texas, US | |
1406270 | 1406270 | 2022-08-02 | US | Iowa | Monroe | 19135 | 1992 | 49 | 0 | 41.02988815 | -92.8690667 | 2022-08-03 04:20:59 | Monroe, Iowa, US | |
3618308 | 3618308 | 2022-08-01 | US | Iowa | Monroe | 19135 | 1992 | 49 | 0 | 41.02988815 | -92.8690667 | 2022-08-02 04:20:53 | Monroe, Iowa, US | |
3872788 | 3872788 | 2022-07-31 | US | Iowa | Monroe | 19135 | 1992 | 49 | 0 | 41.02988815 | -92.8690667 | 2022-08-01 04:21:03 | Monroe, Iowa, US | |
675542 | 675542 | 2022-07-30 | US | Iowa | Monroe | 19135 | 1992 | 49 | 0 | 41.02988815 | -92.8690667 | 2022-07-31 04:21:02 | Monroe, Iowa, US | |
1784741 | 1784741 | 2022-07-29 | US | Iowa | Monroe | 19135 | 1992 | 49 | 0 | 41.02988815 | -92.8690667 | 2022-07-30 04:20:42 | Monroe, Iowa, US | |
1067104 | 1067104 | 2022-07-28 | US | Iowa | Monroe | 19135 | 1992 | 49 | 0 | 41.02988815 | -92.8690667 | 2022-07-29 04:20:45 | Monroe, Iowa, US | |
2336623 | 2336623 | 2022-07-27 | US | Iowa | Monroe | 19135 | 1992 | 49 | 0 | 41.02988815 | -92.8690667 | 2022-07-28 04:20:56 | Monroe, Iowa, US | |
3112594 | 3112594 | 2022-07-13 | US | Texas | Hamilton | 48193 | 1992 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-07-14 04:20:57 | Hamilton, Texas, US | |
633017 | 633017 | 2022-07-12 | US | Texas | Hamilton | 48193 | 1992 | 33 | 0 | 31.70470573 | -98.11083887 | 2022-07-13 04:20:58 | Hamilton, Texas, US | |
631244 | 631244 | 2022-07-12 | US | Kansas | Pratt | 20151 | 1992 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-07-13 04:20:58 | Pratt, Kansas, US | |
1214917 | 1214917 | 2022-07-11 | US | Virginia | Lancaster | 51103 | 1992 | 32 | 0 | 37.71889653 | -76.46400482 | 2022-07-12 04:20:51 | Lancaster, Virginia, US | |
1212888 | 1212888 | 2022-07-11 | US | Kansas | Pratt | 20151 | 1992 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-07-12 04:20:51 | Pratt, Kansas, US | |
2790370 | 2790370 | 2022-07-10 | US | Kansas | Pratt | 20151 | 1992 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-07-11 04:20:46 | Pratt, Kansas, US | |
143323 | 143323 | 2022-07-09 | US | Kansas | Pratt | 20151 | 1992 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-07-10 04:20:54 | Pratt, Kansas, US | |
1418423 | 1418423 | 2022-07-08 | US | Kansas | Pratt | 20151 | 1992 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-07-09 04:20:59 | Pratt, Kansas, US | |
2742348 | 2742348 | 2022-07-07 | US | Kansas | Pratt | 20151 | 1992 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-07-08 04:20:56 | Pratt, Kansas, US | |
1201143 | 1201143 | 2022-07-06 | US | Kansas | Pratt | 20151 | 1992 | 34 | 0 | 37.64780729 | -98.73922153 | 2022-07-07 04:20:55 | Pratt, Kansas, US | |
3941593 | 3941593 | 2022-06-30 | US | Louisiana | St. Helena | 22091 | 1992 | 24 | 0 | 30.82210324 | -90.71013176 | 2022-07-01 04:21:10 | St. Helena, Louisiana, US | |
2151259 | 2151259 | 2022-06-27 | US | Wyoming | Sublette | 56035 | 1992 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-28 04:20:58 | Sublette, Wyoming, US | |
479060 | 479060 | 2022-06-26 | US | Wyoming | Sublette | 56035 | 1992 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-27 04:21:00 | Sublette, Wyoming, US | |
942435 | 942435 | 2022-06-25 | US | Wyoming | Sublette | 56035 | 1992 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-26 04:21:02 | Sublette, Wyoming, US | |
3350255 | 3350255 | 2022-06-24 | US | Wyoming | Sublette | 56035 | 1992 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-25 04:20:57 | Sublette, Wyoming, US | |
1651996 | 1651996 | 2022-06-23 | US | Wyoming | Sublette | 56035 | 1992 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-24 04:20:58 | Sublette, Wyoming, US | |
2191231 | 2191231 | 2022-06-22 | US | Wyoming | Sublette | 56035 | 1992 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-23 04:20:55 | Sublette, Wyoming, US | |
169662 | 169662 | 2022-06-21 | US | Wyoming | Sublette | 56035 | 1992 | 27 | 0 | 42.76558279 | -109.9130922 | 2022-06-22 04:20:54 | Sublette, Wyoming, US | |
168366 | 168366 | 2022-06-21 | US | North Carolina | Gates | 37073 | 1992 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-22 04:20:54 | Gates, North Carolina, US | |
1765649 | 1765649 | 2022-06-20 | US | North Carolina | Gates | 37073 | 1992 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-21 04:20:56 | Gates, North Carolina, US | |
3271835 | 3271835 | 2022-06-19 | US | North Carolina | Gates | 37073 | 1992 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-20 04:21:01 | Gates, North Carolina, US | |
3399747 | 3399747 | 2022-06-18 | US | North Carolina | Gates | 37073 | 1992 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-19 04:20:51 | Gates, North Carolina, US | |
2314065 | 2314065 | 2022-06-17 | US | Puerto Rico | Maunabo | 72095 | 1992 | 0 | 0 | 18.017889 | -65.922235 | 2022-06-18 04:21:10 | Maunabo, Puerto Rico, US | |
2313624 | 2313624 | 2022-06-17 | US | North Carolina | Gates | 37073 | 1992 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-18 04:21:10 | Gates, North Carolina, US | |
561128 | 561128 | 2022-06-16 | US | North Carolina | Gates | 37073 | 1992 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-17 04:20:56 | Gates, North Carolina, US | |
3984930 | 3984930 | 2022-06-15 | US | North Carolina | Gates | 37073 | 1992 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-06-16 04:20:55 | Gates, North Carolina, US | |
2979922 | 2979922 | 2022-06-13 | US | Colorado | Yuma | 8125 | 1992 | 23 | 0 | 40.00346839 | -102.4258673 | 2022-06-14 04:20:52 | Yuma, Colorado, US | |
3596593 | 3596593 | 2022-05-23 | US | Wisconsin | Menominee | 55078 | 1992 | 14 | 0 | 45.00422544 | -88.70950714 | 2022-05-24 04:20:57 | Menominee, Wisconsin, US | |
3594073 | 3594073 | 2022-05-23 | US | Illinois | Schuyler | 17169 | 1992 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-05-24 04:20:57 | Schuyler, Illinois, US | |
1113141 | 1113141 | 2022-05-21 | US | Wisconsin | Menominee | 55078 | 1992 | 14 | 0 | 45.00422544 | -88.70950714 | 2022-05-22 04:20:52 | Menominee, Wisconsin, US | |
1110621 | 1110621 | 2022-05-21 | US | Illinois | Schuyler | 17169 | 1992 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-05-22 04:20:52 | Schuyler, Illinois, US | |
1172765 | 1172765 | 2022-05-20 | US | Wisconsin | Menominee | 55078 | 1992 | 14 | 0 | 45.00422544 | -88.70950714 | 2022-05-21 04:20:58 | Menominee, Wisconsin, US | |
1170245 | 1170245 | 2022-05-20 | US | Illinois | Schuyler | 17169 | 1992 | 17 | 0 | 40.1571798 | -90.61114163 | 2022-05-21 04:20:58 | Schuyler, Illinois, US | |
3899528 | 3899528 | 2022-05-19 | US | Wisconsin | Menominee | 55078 | 1992 | 14 | 0 | 45.00422544 | -88.70950714 | 2022-05-20 04:20:57 | Menominee, Wisconsin, US | |
3448349 | 3448349 | 2022-05-11 | US | West Virginia | Pendleton | 54071 | 1992 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-05-12 04:20:54 | Pendleton, West Virginia, US | |
3436621 | 3436621 | 2022-04-22 | China | Hebei | 1992 | 7 | 0 | 37.8957 | 114.9042 | 2022-04-23 04:20:50 | Hebei, China | |||
1949418 | 1949418 | 2022-04-12 | US | Georgia | Wilcox | 13315 | 1992 | 69 | 0 | 31.97496928 | -83.43438555 | 2022-04-13 04:21:03 | Wilcox, Georgia, US | |
3207171 | 3207171 | 2022-04-11 | US | Georgia | Wilcox | 13315 | 1992 | 69 | 0 | 31.97496928 | -83.43438555 | 2022-04-12 04:20:49 | Wilcox, Georgia, US | |
1577057 | 1577057 | 2022-04-10 | US | Georgia | Wilcox | 13315 | 1992 | 69 | 0 | 31.97496928 | -83.43438555 | 2022-04-11 04:21:02 | Wilcox, Georgia, US | |
1653299 | 1653299 | 2022-04-09 | US | Georgia | Wilcox | 13315 | 1992 | 69 | 0 | 31.97496928 | -83.43438555 | 2022-04-10 04:20:52 | Wilcox, Georgia, US | |
2116621 | 2116621 | 2022-04-08 | US | Georgia | Wilcox | 13315 | 1992 | 69 | 0 | 31.97496928 | -83.43438555 | 2022-04-09 04:20:42 | Wilcox, Georgia, US | |
3321145 | 3321145 | 2022-04-07 | US | Georgia | Wilcox | 13315 | 1992 | 69 | 0 | 31.97496928 | -83.43438555 | 2022-04-08 04:20:48 | Wilcox, Georgia, US | |
2752223 | 2752223 | 2022-04-04 | US | Virginia | Falls Church | 51610 | 1992 | 16 | 0 | 38.88485255 | -77.17560759 | 2022-04-05 04:20:48 | Falls Church, Virginia, US | |
878471 | 878471 | 2022-03-27 | US | New Mexico | Quay | 35037 | 1992 | 49 | 0 | 35.10403332 | -103.54817270000001 | 2022-03-28 04:20:33 | Quay, New Mexico, US | |
2165754 | 2165754 | 2022-03-26 | US | New Mexico | Quay | 35037 | 1992 | 49 | 0 | 35.10403332 | -103.54817270000001 | 2022-03-27 04:20:47 | Quay, New Mexico, US | |
1722690 | 1722690 | 2022-03-25 | US | New Mexico | Quay | 35037 | 1992 | 49 | 0 | 35.10403332 | -103.54817270000001 | 2022-03-26 04:20:23 | Quay, New Mexico, US | |
1467899 | 1467899 | 2022-03-24 | China | Jiangsu | 1992 | 0 | 0 | 32.9711 | 119.455 | 2022-03-25 04:20:46 | Jiangsu, China | |||
1868792 | 1868792 | 2022-03-10 | US | Virginia | Buena Vista | 51530 | 1992 | 39 | 0 | 37.73484642 | -79.35296097 | 2022-03-11 04:20:50 | Buena Vista, Virginia, US | |
2139988 | 2139988 | 2022-03-09 | China | Yunnan | 1992 | 2 | 0 | 24.974 | 101.48700000000001 | 2022-03-10 04:20:48 | Yunnan, China | |||
943754 | 943754 | 2022-02-28 | US | Idaho | Benewah | 16009 | 1992 | 40 | 0 | 47.21754179 | -116.6586851 | 2022-03-01 04:21:09 | Benewah, Idaho, US | |
3914233 | 3914233 | 2022-02-20 | US | New Mexico | Sierra | 35051 | 1992 | 69 | 0 | 33.13028233 | -107.1925893 | 2022-02-21 04:21:05 | Sierra, New Mexico, US | |
3877791 | 3877791 | 2022-02-19 | US | New Mexico | Sierra | 35051 | 1992 | 69 | 0 | 33.13028233 | -107.1925893 | 2022-02-20 04:21:00 | Sierra, New Mexico, US | |
3858047 | 3858047 | 2022-02-18 | US | New Mexico | Sierra | 35051 | 1992 | 69 | 0 | 33.13028233 | -107.1925893 | 2022-02-19 04:21:11 | Sierra, New Mexico, US | |
2477004 | 2477004 | 2022-02-03 | US | Texas | Clay | 48077 | 1992 | 27 | 0 | 33.78686685 | -98.20771198 | 2022-02-04 04:21:10 | Clay, Texas, US | |
2476668 | 2476668 | 2022-02-03 | US | Puerto Rico | Adjuntas | 72001 | 1992 | 0 | 0 | 18.180117000000006 | -66.754367 | 2022-02-04 04:21:10 | Adjuntas, Puerto Rico, US | |
1230541 | 1230541 | 2022-01-24 | US | Tennessee | Clay | 47027 | 1992 | 43 | 0 | 36.55151008 | -85.53930419 | 2022-01-25 04:21:05 | Clay, Tennessee, US | |
1474421 | 1474421 | 2022-01-17 | US | North Carolina | Clay | 37043 | 1992 | 38 | 0 | 35.05704275 | -83.74353633 | 2022-01-18 04:21:04 | Clay, North Carolina, US | |
557095 | 557095 | 2022-01-16 | US | North Carolina | Clay | 37043 | 1992 | 38 | 0 | 35.05704275 | -83.74353633 | 2022-01-17 04:21:08 | Clay, North Carolina, US | |
3842816 | 3842816 | 2022-01-15 | US | North Carolina | Clay | 37043 | 1992 | 38 | 0 | 35.05704275 | -83.74353633 | 2022-01-16 04:21:12 | Clay, North Carolina, US | |
101631 | 101631 | 2022-01-14 | US | North Carolina | Clay | 37043 | 1992 | 38 | 0 | 35.05704275 | -83.74353633 | 2022-01-15 04:21:07 | Clay, North Carolina, US | |
3690382 | 3690382 | 2022-01-13 | US | South Dakota | Roberts | 46109 | 1992 | 45 | 0 | 45.62975048 | -96.94672673 | 2022-01-14 04:21:54 | Roberts, South Dakota, US | |
130279 | 130279 | 2022-01-09 | US | Wisconsin | Forest | 55041 | 1992 | 43 | 0 | 45.66678019 | -88.77084892 | 2022-01-10 04:22:07 | Forest, Wisconsin, US | |
1219114 | 1219114 | 2022-01-08 | US | Wisconsin | Forest | 55041 | 1992 | 43 | 0 | 45.66678019 | -88.77084892 | 2022-01-09 04:21:46 | Forest, Wisconsin, US | |
1217522 | 1217522 | 2022-01-08 | US | Missouri | Ralls | 29173 | 1992 | 19 | 0 | 39.52817427 | -91.51838643 | 2022-01-09 04:21:46 | Ralls, Missouri, US | |
1393207 | 1393207 | 2022-01-07 | US | Wisconsin | Forest | 55041 | 1992 | 43 | 0 | 45.66678019 | -88.77084892 | 2022-01-08 04:21:53 | Forest, Wisconsin, US | |
1435182 | 1435182 | 2021-12-28 | US | Oregon | Curry | 41015 | 1992 | 40 | 0 | 42.45911325 | -124.15728200000001 | 2021-12-29 03:21:43 | Curry, Oregon, 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]);