johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
410 rows where confirmed = 2133 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1640148 | 1640148 | 2022-11-20 | China | Liaoning | 2133 | 2 | 0 | 41.2956 | 122.6085 | 2022-11-21 04:21:05 | Liaoning, China | |||
480227 | 480227 | 2022-11-08 | US | Colorado | Lake | 8065 | 2133 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-11-09 04:21:22 | Lake, Colorado, US | |
2439377 | 2439377 | 2022-11-07 | US | Colorado | Lake | 8065 | 2133 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-11-08 04:21:21 | Lake, Colorado, US | |
1050475 | 1050475 | 2022-11-06 | US | Colorado | Lake | 8065 | 2133 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-11-07 04:21:26 | Lake, Colorado, US | |
618499 | 618499 | 2022-11-05 | US | Colorado | Lake | 8065 | 2133 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-11-06 04:21:24 | Lake, Colorado, US | |
1023003 | 1023003 | 2022-11-04 | US | Colorado | Lake | 8065 | 2133 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-11-05 04:21:52 | Lake, Colorado, US | |
431994 | 431994 | 2022-11-03 | US | Colorado | Lake | 8065 | 2133 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-11-04 04:22:11 | Lake, Colorado, US | |
850236 | 850236 | 2022-11-02 | US | Colorado | Lake | 8065 | 2133 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-11-03 04:22:05 | Lake, Colorado, US | |
711087 | 711087 | 2022-11-01 | US | Colorado | Lake | 8065 | 2133 | 2 | 0 | 39.20278823 | -106.3555697 | 2022-11-02 04:22:09 | Lake, Colorado, US | |
3756903 | 3756903 | 2022-10-13 | US | Virginia | Williamsburg | 51830 | 2133 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-14 04:22:28 | Williamsburg, Virginia, US | |
3756791 | 3756791 | 2022-10-13 | US | Virginia | Buena Vista | 51530 | 2133 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-10-14 04:22:28 | Buena Vista, Virginia, US | |
3217728 | 3217728 | 2022-10-12 | US | Virginia | Williamsburg | 51830 | 2133 | 23 | 0 | 37.28131268 | -76.70905141 | 2022-10-13 04:22:39 | Williamsburg, Virginia, US | |
2377709 | 2377709 | 2022-09-29 | US | New Hampshire | Unassigned | 90033 | 2133 | 4 | 0 | 44.69063265 | 0.0 | 2022-09-30 04:23:09 | Unassigned, New Hampshire, US | |
1977230 | 1977230 | 2022-09-25 | US | Colorado | Conejos | 8021 | 2133 | 57 | 0 | 37.201606 | -106.1917488 | 2022-09-26 04:20:52 | Conejos, Colorado, US | |
2650397 | 2650397 | 2022-09-24 | US | Colorado | Conejos | 8021 | 2133 | 57 | 0 | 37.201606 | -106.1917488 | 2022-09-25 04:23:31 | Conejos, Colorado, US | |
384837 | 384837 | 2022-09-23 | US | Colorado | Conejos | 8021 | 2133 | 57 | 0 | 37.201606 | -106.1917488 | 2022-09-24 04:21:40 | Conejos, Colorado, US | |
2019792 | 2019792 | 2022-09-20 | US | Texas | Crosby | 48107 | 2133 | 46 | 0 | 33.61431553 | -101.3000364 | 2022-09-21 04:23:22 | Crosby, Texas, US | |
3573665 | 3573665 | 2022-09-19 | US | Texas | Crosby | 48107 | 2133 | 46 | 0 | 33.61431553 | -101.3000364 | 2022-09-20 04:22:48 | Crosby, Texas, US | |
3989936 | 3989936 | 2022-09-15 | US | Virginia | Bland | 51021 | 2133 | 26 | 0 | 37.13128068 | -81.13599391 | 2022-09-16 04:21:19 | Bland, Virginia, US | |
1892453 | 1892453 | 2022-09-14 | US | Virginia | Bland | 51021 | 2133 | 26 | 0 | 37.13128068 | -81.13599391 | 2022-09-15 04:21:02 | Bland, Virginia, US | |
375508 | 375508 | 2022-09-13 | US | Virginia | Bland | 51021 | 2133 | 26 | 0 | 37.13128068 | -81.13599391 | 2022-09-14 04:20:44 | Bland, Virginia, US | |
3748678 | 3748678 | 2022-09-07 | US | Wisconsin | Menominee | 55078 | 2133 | 15 | 0 | 45.00422544 | -88.70950714 | 2022-09-08 04:21:02 | Menominee, Wisconsin, US | |
2406340 | 2406340 | 2022-08-21 | US | West Virginia | Pendleton | 54071 | 2133 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-08-22 04:20:38 | Pendleton, West Virginia, US | |
3801418 | 3801418 | 2022-08-20 | US | West Virginia | Pendleton | 54071 | 2133 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-08-21 04:20:44 | Pendleton, West Virginia, US | |
2367004 | 2367004 | 2022-08-19 | US | West Virginia | Pendleton | 54071 | 2133 | 22 | 0 | 38.68314479 | -79.35084086 | 2022-08-20 04:21:01 | Pendleton, West Virginia, US | |
993316 | 993316 | 2022-08-16 | US | North Carolina | Gates | 37073 | 2133 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-17 04:20:59 | Gates, North Carolina, US | |
2496355 | 2496355 | 2022-08-15 | US | North Carolina | Gates | 37073 | 2133 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-16 04:20:58 | Gates, North Carolina, US | |
3650961 | 3650961 | 2022-08-14 | US | Virginia | Middlesex | 51119 | 2133 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-08-15 04:20:59 | Middlesex, Virginia, US | |
3649905 | 3649905 | 2022-08-14 | US | North Carolina | Gates | 37073 | 2133 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-15 04:20:59 | Gates, North Carolina, US | |
1971967 | 1971967 | 2022-08-13 | US | Virginia | Middlesex | 51119 | 2133 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-08-14 04:20:55 | Middlesex, Virginia, US | |
1970911 | 1970911 | 2022-08-13 | US | North Carolina | Gates | 37073 | 2133 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-14 04:20:55 | Gates, North Carolina, US | |
2891776 | 2891776 | 2022-08-12 | US | Virginia | Middlesex | 51119 | 2133 | 48 | 0 | 37.63191998 | -76.55064617 | 2022-08-13 04:20:52 | Middlesex, Virginia, US | |
2890720 | 2890720 | 2022-08-12 | US | North Carolina | Gates | 37073 | 2133 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-13 04:20:52 | Gates, North Carolina, US | |
3911577 | 3911577 | 2022-08-11 | US | Wisconsin | Pepin | 55091 | 2133 | 18 | 0 | 44.58307413 | -91.99949611 | 2022-08-12 04:20:54 | Pepin, Wisconsin, US | |
3910325 | 3910325 | 2022-08-11 | US | North Carolina | Gates | 37073 | 2133 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-12 04:20:54 | Gates, North Carolina, US | |
3908668 | 3908668 | 2022-08-11 | US | Colorado | Yuma | 8125 | 2133 | 26 | 0 | 40.00346839 | -102.4258673 | 2022-08-12 04:20:54 | Yuma, Colorado, US | |
1348642 | 1348642 | 2022-08-10 | US | North Carolina | Gates | 37073 | 2133 | 20 | 0 | 36.44667547 | -76.69749701 | 2022-08-11 04:20:49 | Gates, North Carolina, US | |
1408561 | 1408561 | 2022-08-02 | US | West Virginia | Tucker | 54093 | 2133 | 38 | 0 | 39.11240885 | -79.57053576 | 2022-08-03 04:20:59 | Tucker, West Virginia, US | |
673524 | 673524 | 2022-07-21 | US | Texas | Somervell | 48425 | 2133 | 36 | 0 | 32.22236802 | -97.77403489 | 2022-07-22 04:21:15 | Somervell, Texas, US | |
631121 | 631121 | 2022-07-12 | US | Iowa | Keokuk | 19107 | 2133 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-07-13 04:20:58 | Keokuk, Iowa, US | |
1212765 | 1212765 | 2022-07-11 | US | Iowa | Keokuk | 19107 | 2133 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-07-12 04:20:51 | Keokuk, Iowa, US | |
2790247 | 2790247 | 2022-07-10 | US | Iowa | Keokuk | 19107 | 2133 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-07-11 04:20:46 | Keokuk, Iowa, US | |
143200 | 143200 | 2022-07-09 | US | Iowa | Keokuk | 19107 | 2133 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-07-10 04:20:54 | Keokuk, Iowa, US | |
141785 | 141785 | 2022-07-09 | China | Inner Mongolia | 2133 | 1 | 0 | 44.0935 | 113.9448 | 2022-07-10 04:20:54 | Inner Mongolia, China | |||
1418300 | 1418300 | 2022-07-08 | US | Iowa | Keokuk | 19107 | 2133 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-07-09 04:20:59 | Keokuk, Iowa, US | |
2742225 | 2742225 | 2022-07-07 | US | Iowa | Keokuk | 19107 | 2133 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-07-08 04:20:56 | Keokuk, Iowa, US | |
1201020 | 1201020 | 2022-07-06 | US | Iowa | Keokuk | 19107 | 2133 | 48 | 0 | 41.33649833 | -92.1785067 | 2022-07-07 04:20:55 | Keokuk, Iowa, US | |
3969354 | 3969354 | 2022-07-05 | US | South Carolina | Allendale | 45005 | 2133 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-07-06 04:20:58 | Allendale, South Carolina, US | |
3081376 | 3081376 | 2022-07-04 | US | Virginia | Buena Vista | 51530 | 2133 | 45 | 0 | 37.73484642 | -79.35296097 | 2022-07-05 04:20:45 | Buena Vista, Virginia, US | |
3080865 | 3080865 | 2022-07-04 | US | South Carolina | Allendale | 45005 | 2133 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-07-05 04:20:45 | Allendale, South Carolina, US | |
1770147 | 1770147 | 2022-07-03 | US | South Carolina | Allendale | 45005 | 2133 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-07-04 04:20:54 | Allendale, South Carolina, US | |
3368133 | 3368133 | 2022-07-02 | US | South Carolina | Allendale | 45005 | 2133 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-07-03 04:20:59 | Allendale, South Carolina, US | |
596462 | 596462 | 2022-07-01 | US | South Carolina | Allendale | 45005 | 2133 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-07-02 04:21:16 | Allendale, South Carolina, US | |
3942863 | 3942863 | 2022-06-30 | US | South Carolina | Allendale | 45005 | 2133 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-07-01 04:21:10 | Allendale, South Carolina, US | |
2492821 | 2492821 | 2022-06-29 | US | South Carolina | Allendale | 45005 | 2133 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-06-30 04:21:01 | Allendale, South Carolina, US | |
2242263 | 2242263 | 2022-06-28 | US | South Dakota | Custer | 46033 | 2133 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-06-29 04:20:59 | Custer, South Dakota, US | |
2242203 | 2242203 | 2022-06-28 | US | South Carolina | Allendale | 45005 | 2133 | 24 | 0 | 32.98837386 | -81.35321066 | 2022-06-29 04:20:59 | Allendale, South Carolina, US | |
2150505 | 2150505 | 2022-06-27 | US | South Dakota | Custer | 46033 | 2133 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-06-28 04:20:58 | Custer, South Dakota, US | |
478306 | 478306 | 2022-06-26 | US | South Dakota | Custer | 46033 | 2133 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-06-27 04:21:00 | Custer, South Dakota, US | |
941681 | 941681 | 2022-06-25 | US | South Dakota | Custer | 46033 | 2133 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-06-26 04:21:02 | Custer, South Dakota, US | |
3349501 | 3349501 | 2022-06-24 | US | South Dakota | Custer | 46033 | 2133 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-06-25 04:20:57 | Custer, South Dakota, US | |
3349370 | 3349370 | 2022-06-24 | US | Puerto Rico | Ceiba | 72037 | 2133 | 0 | 0 | 18.251818 | -65.666416 | 2022-06-25 04:20:57 | Ceiba, Puerto Rico, US | |
1651242 | 1651242 | 2022-06-23 | US | South Dakota | Custer | 46033 | 2133 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-06-24 04:20:58 | Custer, South Dakota, US | |
2190477 | 2190477 | 2022-06-22 | US | South Dakota | Custer | 46033 | 2133 | 26 | 0 | 43.67741105 | -103.4534521 | 2022-06-23 04:20:55 | Custer, South Dakota, US | |
3510724 | 3510724 | 2022-06-05 | US | Virginia | Fairfax City | 51600 | 2133 | 43 | 0 | 38.85157547 | -77.2977964 | 2022-06-06 04:20:57 | Fairfax City, Virginia, US | |
3530801 | 3530801 | 2022-06-04 | US | Virginia | Fairfax City | 51600 | 2133 | 43 | 0 | 38.85157547 | -77.2977964 | 2022-06-05 04:20:55 | Fairfax City, Virginia, US | |
3136887 | 3136887 | 2022-06-03 | US | Virginia | Fairfax City | 51600 | 2133 | 43 | 0 | 38.85157547 | -77.2977964 | 2022-06-04 04:20:58 | Fairfax City, Virginia, US | |
3579554 | 3579554 | 2022-06-02 | US | Idaho | Boundary | 16021 | 2133 | 62 | 0 | 48.76684761 | -116.4630179 | 2022-06-03 04:20:58 | Boundary, Idaho, US | |
971847 | 971847 | 2022-06-01 | US | Idaho | Boundary | 16021 | 2133 | 62 | 0 | 48.76684761 | -116.4630179 | 2022-06-02 05:20:39 | Boundary, Idaho, US | |
2048394 | 2048394 | 2022-05-25 | US | Arkansas | Searcy | 5129 | 2133 | 48 | 0 | 35.9109364 | -92.69936482 | 2022-05-26 04:20:50 | Searcy, Arkansas, US | |
3594767 | 3594767 | 2022-05-23 | US | Minnesota | Marshall | 27089 | 2133 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-05-24 04:20:57 | Marshall, Minnesota, US | |
622405 | 622405 | 2022-05-22 | US | Arkansas | Searcy | 5129 | 2133 | 48 | 0 | 35.9109364 | -92.69936482 | 2022-05-26 04:20:50 | Searcy, Arkansas, US | |
1111315 | 1111315 | 2022-05-21 | US | Minnesota | Marshall | 27089 | 2133 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-05-22 04:20:52 | Marshall, Minnesota, US | |
1170939 | 1170939 | 2022-05-20 | US | Minnesota | Marshall | 27089 | 2133 | 24 | 0 | 48.35825983 | -96.37017407 | 2022-05-21 04:20:58 | Marshall, Minnesota, US | |
1169013 | 1169013 | 2022-05-20 | China | Yunnan | 2133 | 2 | 0 | 24.974 | 101.487 | 2022-05-21 04:20:58 | Yunnan, China | |||
3895776 | 3895776 | 2022-05-19 | China | Yunnan | 2133 | 2 | 0 | 24.974 | 101.487 | 2022-05-20 04:20:57 | Yunnan, China | |||
3583903 | 3583903 | 2022-05-17 | US | Kansas | Anderson | 20003 | 2133 | 32 | 0 | 38.21413251 | -95.29272815 | 2022-05-18 04:20:50 | Anderson, Kansas, US | |
1504860 | 1504860 | 2022-05-16 | US | Kansas | Anderson | 20003 | 2133 | 32 | 0 | 38.21413251 | -95.29272815 | 2022-05-17 04:20:59 | Anderson, Kansas, US | |
2085219 | 2085219 | 2022-05-15 | US | Kansas | Anderson | 20003 | 2133 | 32 | 0 | 38.21413251 | -95.29272815 | 2022-05-16 04:20:47 | Anderson, Kansas, US | |
3355929 | 3355929 | 2022-05-14 | US | Kansas | Anderson | 20003 | 2133 | 32 | 0 | 38.21413251 | -95.29272815 | 2022-05-15 04:20:53 | Anderson, Kansas, US | |
659574 | 659574 | 2022-05-13 | US | Kansas | Anderson | 20003 | 2133 | 32 | 0 | 38.21413251 | -95.29272815 | 2022-05-14 04:20:48 | Anderson, Kansas, US | |
3853802 | 3853802 | 2022-04-27 | US | Montana | Beaverhead | 30001 | 2133 | 29 | 0 | 45.13434354 | -112.8984694 | 2022-04-28 04:20:47 | Beaverhead, Montana, US | |
1328232 | 1328232 | 2022-04-26 | US | Montana | Beaverhead | 30001 | 2133 | 29 | 0 | 45.13434354 | -112.89846940000001 | 2022-04-27 04:20:52 | Beaverhead, Montana, US | |
1949354 | 1949354 | 2022-04-12 | US | Georgia | Macon | 13193 | 2133 | 49 | 0 | 32.35207048 | -84.04234127 | 2022-04-13 04:21:03 | Macon, Georgia, US | |
3207107 | 3207107 | 2022-04-11 | US | Georgia | Macon | 13193 | 2133 | 49 | 0 | 32.35207048 | -84.04234127 | 2022-04-12 04:20:49 | Macon, Georgia, US | |
3870286 | 3870286 | 2022-04-05 | US | Puerto Rico | Florida | 72054 | 2133 | 0 | 0 | 18.373715 | -66.560488 | 2022-04-06 04:20:49 | Florida, Puerto Rico, US | |
2751628 | 2751628 | 2022-04-04 | US | Puerto Rico | Florida | 72054 | 2133 | 0 | 0 | 18.373715 | -66.560488 | 2022-04-05 04:20:48 | Florida, Puerto Rico, US | |
3732974 | 3732974 | 2022-04-03 | US | Puerto Rico | Florida | 72054 | 2133 | 0 | 0 | 18.373715 | -66.560488 | 2022-04-04 04:20:51 | Florida, Puerto Rico, US | |
1867507 | 1867507 | 2022-03-10 | US | Montana | Sanders | 30089 | 2133 | 46 | 0 | 47.67657534 | -115.1329916 | 2022-03-11 04:20:50 | Sanders, Montana, US | |
2143556 | 2143556 | 2022-03-09 | US | Virginia | Northampton | 51131 | 2133 | 61 | 0 | 37.34062933 | -75.87751591 | 2022-03-10 04:20:48 | Northampton, Virginia, US | |
923067 | 923067 | 2022-03-08 | US | Virginia | Northampton | 51131 | 2133 | 61 | 0 | 37.34062933 | -75.87751591 | 2022-03-09 04:20:59 | Northampton, Virginia, US | |
921589 | 921589 | 2022-03-08 | US | Missouri | Gentry | 29075 | 2133 | 30 | 0 | 40.21097916 | -94.40944419 | 2022-03-09 04:20:59 | Gentry, Missouri, US | |
1549876 | 1549876 | 2022-03-07 | US | Missouri | Gentry | 29075 | 2133 | 30 | 0 | 40.21097916 | -94.40944419 | 2022-03-08 04:20:54 | Gentry, Missouri, US | |
2526842 | 2526842 | 2022-03-02 | US | Kentucky | Trimble | 21223 | 2133 | 38 | 0 | 38.61056487 | -85.33775972 | 2022-03-03 04:21:01 | Trimble, Kentucky, US | |
1994558 | 1994558 | 2022-03-01 | US | Missouri | DeKalb | 29063 | 2133 | 45 | 0 | 39.89201062 | -94.40476508 | 2022-03-02 04:21:07 | DeKalb, Missouri, US | |
1994136 | 1994136 | 2022-03-01 | US | Kentucky | Trimble | 21223 | 2133 | 38 | 0 | 38.61056487 | -85.33775972 | 2022-03-02 04:21:07 | Trimble, Kentucky, US | |
1299964 | 1299964 | 2022-02-17 | US | Missouri | Howard | 29089 | 2133 | 23 | 0 | 39.1435761 | -92.69756691 | 2022-02-18 04:21:04 | Howard, Missouri, US | |
3822520 | 3822520 | 2022-02-16 | US | Nebraska | Hamilton | 31081 | 2133 | 17 | 0 | 40.87349452 | -98.02099117 | 2022-02-17 04:20:56 | Hamilton, Nebraska, US | |
188406 | 188406 | 2022-02-13 | US | North Carolina | Jones | 37103 | 2133 | 38 | 0 | 35.02254606 | -77.35870791 | 2022-02-14 04:20:51 | Jones, North Carolina, US | |
318252 | 318252 | 2022-02-12 | US | North Carolina | Jones | 37103 | 2133 | 38 | 0 | 35.02254606 | -77.35870791 | 2022-02-13 04:21:00 | Jones, North Carolina, 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]);