johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
312 rows where confirmed = 2627 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 14
- US 292
- China 5
- Colombia 3
- Japan 2
- Bulgaria 1
- Eritrea 1
- Liechtenstein 1
- Netherlands 1
- Peru 1
- Russia 1
- Sao Tome and Principe 1
- Togo 1
- Ukraine 1
- Yemen 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3324067 | 3324067 | 2022-12-16 | China | Tianjin | 2627 | 3 | 0 | 39.3054 | 117.323 | 2022-12-17 04:21:04 | Tianjin, China | |||
542579 | 542579 | 2022-12-15 | China | Tianjin | 2627 | 3 | 0 | 39.3054 | 117.323 | 2022-12-16 04:21:01 | Tianjin, China | |||
348107 | 348107 | 2022-12-14 | China | Tianjin | 2627 | 3 | 0 | 39.3054 | 117.323 | 2022-12-15 04:20:58 | Tianjin, China | |||
307695 | 307695 | 2022-12-13 | China | Tianjin | 2627 | 3 | 0 | 39.3054 | 117.323 | 2022-12-14 04:21:04 | Tianjin, China | |||
1148756 | 1148756 | 2022-12-12 | China | Tianjin | 2627 | 3 | 0 | 39.3054 | 117.323 | 2022-12-13 04:21:01 | Tianjin, China | |||
2559637 | 2559637 | 2022-11-29 | US | Texas | Castro | 48069 | 2627 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-11-30 04:21:07 | Castro, Texas, US | |
1242711 | 1242711 | 2022-11-28 | US | Texas | Castro | 48069 | 2627 | 48 | 0 | 34.53016752 | -102.2617243 | 2022-11-29 04:21:05 | Castro, Texas, US | |
1620789 | 1620789 | 2022-11-22 | US | Arkansas | Nevada | 5099 | 2627 | 46 | 0 | 33.66340119 | -93.30632432 | 2022-11-23 04:21:06 | Nevada, Arkansas, US | |
1641007 | 1641007 | 2022-11-20 | US | Colorado | San Miguel | 8113 | 2627 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-11-21 04:21:05 | San Miguel, Colorado, US | |
2064564 | 2064564 | 2022-11-19 | US | Colorado | San Miguel | 8113 | 2627 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-11-20 04:21:08 | San Miguel, Colorado, US | |
1755958 | 1755958 | 2022-11-18 | US | Colorado | San Miguel | 8113 | 2627 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-11-19 04:21:14 | San Miguel, Colorado, US | |
3026951 | 3026951 | 2022-11-17 | US | Colorado | San Miguel | 8113 | 2627 | 8 | 0 | 38.00450883 | -108.4020725 | 2022-11-18 04:21:15 | San Miguel, Colorado, US | |
323141 | 323141 | 2022-10-30 | US | Texas | Red River | 48387 | 2627 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-10-31 04:21:36 | Red River, Texas, US | |
915417 | 915417 | 2022-10-29 | US | Texas | Red River | 48387 | 2627 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-10-30 04:22:14 | Red River, Texas, US | |
1369686 | 1369686 | 2022-10-28 | US | Texas | Red River | 48387 | 2627 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-10-29 04:21:13 | Red River, Texas, US | |
3041547 | 3041547 | 2022-10-27 | US | Texas | Runnels | 48399 | 2627 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-10-28 04:22:31 | Runnels, Texas, US | |
3041541 | 3041541 | 2022-10-27 | US | Texas | Red River | 48387 | 2627 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-10-28 04:22:31 | Red River, Texas, US | |
541967 | 541967 | 2022-10-26 | US | Texas | Runnels | 48399 | 2627 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-10-27 04:22:01 | Runnels, Texas, US | |
541961 | 541961 | 2022-10-26 | US | Texas | Red River | 48387 | 2627 | 71 | 0 | 33.61886692 | -95.04841765 | 2022-10-27 04:22:01 | Red River, Texas, US | |
1833368 | 1833368 | 2022-10-25 | US | Texas | Runnels | 48399 | 2627 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-10-26 04:22:19 | Runnels, Texas, US | |
797629 | 797629 | 2022-10-24 | US | Texas | Runnels | 48399 | 2627 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-10-25 04:21:53 | Runnels, Texas, US | |
3280084 | 3280084 | 2022-10-23 | US | Texas | Runnels | 48399 | 2627 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-10-24 04:22:29 | Runnels, Texas, US | |
2271122 | 2271122 | 2022-10-22 | US | Texas | Runnels | 48399 | 2627 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-10-23 04:22:46 | Runnels, Texas, US | |
1595422 | 1595422 | 2022-10-21 | US | Texas | Runnels | 48399 | 2627 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-10-22 04:22:53 | Runnels, Texas, US | |
2275138 | 2275138 | 2022-10-20 | US | Texas | Runnels | 48399 | 2627 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-10-21 04:22:23 | Runnels, Texas, US | |
201473 | 201473 | 2022-10-19 | US | Texas | Runnels | 48399 | 2627 | 69 | 0 | 31.8314342 | -99.97616148 | 2022-10-20 04:22:59 | Runnels, Texas, US | |
1814257 | 1814257 | 2022-10-05 | US | West Virginia | Clay | 54015 | 2627 | 50 | 0 | 38.46231092 | -81.07652217 | 2022-10-06 04:21:22 | Clay, West Virginia, US | |
134231 | 134231 | 2022-10-04 | US | West Virginia | Clay | 54015 | 2627 | 50 | 0 | 38.46231092 | -81.07652217 | 2022-10-05 04:23:06 | Clay, West Virginia, US | |
3572791 | 3572791 | 2022-09-19 | US | New Mexico | Colfax | 35007 | 2627 | 67 | 0 | 36.60569702 | -104.6472674 | 2022-09-20 04:22:48 | Colfax, New Mexico, US | |
1491100 | 1491100 | 2022-07-26 | US | West Virginia | Ritchie | 54085 | 2627 | 31 | 0 | 39.18094587 | -81.06356878 | 2022-07-27 04:21:04 | Ritchie, West Virginia, US | |
1491005 | 1491005 | 2022-07-26 | US | Virginia | Sussex | 51183 | 2627 | 43 | 0 | 36.92432914 | -77.25791182 | 2022-07-27 04:21:04 | Sussex, Virginia, US | |
3406869 | 3406869 | 2022-07-17 | US | Kentucky | Hancock | 21091 | 2627 | 25 | 0 | 37.83766422 | -86.78280584 | 2022-07-18 04:20:59 | Hancock, Kentucky, US | |
2153069 | 2153069 | 2022-07-16 | US | Kentucky | Hancock | 21091 | 2627 | 25 | 0 | 37.83766422 | -86.78280584 | 2022-07-17 04:21:15 | Hancock, Kentucky, US | |
2420302 | 2420302 | 2022-07-15 | US | Kentucky | Hancock | 21091 | 2627 | 25 | 0 | 37.83766422 | -86.78280584 | 2022-07-16 04:21:05 | Hancock, Kentucky, US | |
3430377 | 3430377 | 2022-07-14 | US | Kentucky | Hancock | 21091 | 2627 | 25 | 0 | 37.83766422 | -86.78280584 | 2022-07-15 04:20:53 | Hancock, Kentucky, US | |
3110897 | 3110897 | 2022-07-13 | US | Kentucky | Hancock | 21091 | 2627 | 25 | 0 | 37.83766422 | -86.78280584 | 2022-07-14 04:20:57 | Hancock, Kentucky, US | |
631320 | 631320 | 2022-07-12 | US | Kentucky | Hancock | 21091 | 2627 | 25 | 0 | 37.83766422 | -86.78280584 | 2022-07-13 04:20:58 | Hancock, Kentucky, US | |
1212964 | 1212964 | 2022-07-11 | US | Kentucky | Hancock | 21091 | 2627 | 25 | 0 | 37.83766422 | -86.78280584 | 2022-07-12 04:20:51 | Hancock, Kentucky, US | |
2148314 | 2148314 | 2022-06-27 | US | Connecticut | Unassigned | 90009 | 2627 | 2 | 0 | 41.85853803 | 0.0 | 2022-06-28 04:20:58 | Unassigned, Connecticut, US | |
476521 | 476521 | 2022-06-26 | US | Indiana | Crawford | 18025 | 2627 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-06-27 04:21:00 | Crawford, Indiana, US | |
476047 | 476047 | 2022-06-26 | US | Colorado | Bent | 8011 | 2627 | 47 | 0 | 37.95474293 | -103.0720195 | 2022-06-27 04:21:00 | Bent, Colorado, US | |
939896 | 939896 | 2022-06-25 | US | Indiana | Crawford | 18025 | 2627 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-06-26 04:21:02 | Crawford, Indiana, US | |
3347716 | 3347716 | 2022-06-24 | US | Indiana | Crawford | 18025 | 2627 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-06-25 04:20:57 | Crawford, Indiana, US | |
950219 | 950219 | 2022-06-14 | US | Virginia | Lunenburg | 51111 | 2627 | 39 | 0 | 36.94618528 | -78.24133319 | 2022-06-15 04:20:54 | Lunenburg, Virginia, US | |
949877 | 949877 | 2022-06-14 | US | Texas | Blanco | 48031 | 2627 | 34 | 0 | 30.26640707 | -98.3999852 | 2022-06-15 04:20:54 | Blanco, Texas, US | |
2237168 | 2237168 | 2022-06-12 | US | Minnesota | Yellow Medicine | 27173 | 2627 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-06-13 04:21:14 | Yellow Medicine, Minnesota, US | |
3143366 | 3143366 | 2022-06-11 | US | Minnesota | Yellow Medicine | 27173 | 2627 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-06-12 04:20:53 | Yellow Medicine, Minnesota, US | |
1946282 | 1946282 | 2022-06-10 | US | Minnesota | Yellow Medicine | 27173 | 2627 | 29 | 0 | 44.71710183 | -95.86842453 | 2022-06-11 04:21:01 | Yellow Medicine, Minnesota, US | |
1424423 | 1424423 | 2022-06-08 | US | Virginia | Charlotte | 51037 | 2627 | 45 | 0 | 37.01909701 | -78.66314092 | 2022-06-09 04:20:54 | Charlotte, Virginia, US | |
3527983 | 3527983 | 2022-06-04 | US | Arkansas | Pike | 5109 | 2627 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-06-05 04:20:55 | Pike, Arkansas, US | |
3134069 | 3134069 | 2022-06-03 | US | Arkansas | Pike | 5109 | 2627 | 44 | 0 | 34.16250414 | -93.65789349 | 2022-06-04 04:20:58 | Pike, Arkansas, US | |
3002685 | 3002685 | 2022-05-24 | US | Virginia | Nelson | 51125 | 2627 | 36 | 0 | 37.78790447 | -78.88498513 | 2022-05-25 04:20:56 | Nelson, Virginia, US | |
3536664 | 3536664 | 2022-05-10 | US | Iowa | Humboldt | 19091 | 2627 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-05-11 04:20:48 | Humboldt, Iowa, US | |
223199 | 223199 | 2022-05-09 | US | Iowa | Humboldt | 19091 | 2627 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-05-10 04:20:50 | Humboldt, Iowa, US | |
2332584 | 2332584 | 2022-05-08 | US | Iowa | Humboldt | 19091 | 2627 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-05-09 04:20:54 | Humboldt, Iowa, US | |
361546 | 361546 | 2022-05-07 | US | Iowa | Humboldt | 19091 | 2627 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-05-08 04:20:49 | Humboldt, Iowa, US | |
1398897 | 1398897 | 2022-05-06 | US | Iowa | Humboldt | 19091 | 2627 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-05-07 04:21:09 | Humboldt, Iowa, US | |
2599252 | 2599252 | 2022-05-05 | US | Iowa | Humboldt | 19091 | 2627 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-05-06 04:21:00 | Humboldt, Iowa, US | |
3266701 | 3266701 | 2022-05-04 | US | Iowa | Humboldt | 19091 | 2627 | 38 | 0 | 42.7764426 | -94.20722537 | 2022-05-05 04:20:55 | Humboldt, Iowa, US | |
1574442 | 1574442 | 2022-05-03 | US | North Carolina | Clay | 37043 | 2627 | 40 | 0 | 35.05704275 | -83.74353633 | 2022-05-04 04:20:59 | Clay, North Carolina, US | |
1573096 | 1573096 | 2022-05-03 | US | Idaho | Valley | 16085 | 2627 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-05-04 04:20:59 | Valley, Idaho, US | |
465702 | 465702 | 2022-05-02 | US | North Carolina | Clay | 37043 | 2627 | 40 | 0 | 35.05704275 | -83.74353633 | 2022-05-03 04:21:00 | Clay, North Carolina, US | |
464356 | 464356 | 2022-05-02 | US | Idaho | Valley | 16085 | 2627 | 16 | 0 | 44.76728382 | -115.5676773 | 2022-05-03 04:21:00 | Valley, Idaho, US | |
3918341 | 3918341 | 2022-05-01 | US | North Carolina | Clay | 37043 | 2627 | 40 | 0 | 35.05704275 | -83.74353633 | 2022-05-02 04:21:10 | Clay, North Carolina, US | |
2843145 | 2843145 | 2022-04-30 | US | North Carolina | Clay | 37043 | 2627 | 40 | 0 | 35.05704275 | -83.74353633 | 2022-05-01 04:20:57 | Clay, North Carolina, US | |
1159458 | 1159458 | 2022-04-29 | US | North Carolina | Clay | 37043 | 2627 | 40 | 0 | 35.05704275 | -83.74353633 | 2022-04-30 04:21:05 | Clay, North Carolina, US | |
1698640 | 1698640 | 2022-04-28 | US | North Carolina | Clay | 37043 | 2627 | 40 | 0 | 35.05704275 | -83.74353633 | 2022-04-29 04:20:59 | Clay, North Carolina, US | |
3854123 | 3854123 | 2022-04-27 | US | North Carolina | Clay | 37043 | 2627 | 40 | 0 | 35.05704275 | -83.74353633 | 2022-04-28 04:20:47 | Clay, North Carolina, US | |
1849214 | 1849214 | 2022-04-18 | US | Texas | Trinity | 48455 | 2627 | 72 | 0 | 31.0879489 | -95.1367187 | 2022-04-19 04:21:00 | Trinity, Texas, US | |
2445362 | 2445362 | 2022-04-13 | US | Oklahoma | Washita | 40149 | 2627 | 53 | 0 | 35.29071824 | -98.99180434 | 2022-04-13 23:21:06 | Washita, Oklahoma, US | |
1951119 | 1951119 | 2022-04-12 | US | Oklahoma | Washita | 40149 | 2627 | 53 | 0 | 35.29071824 | -98.99180434 | 2022-04-13 04:21:03 | Washita, Oklahoma, US | |
3208872 | 3208872 | 2022-04-11 | US | Oklahoma | Washita | 40149 | 2627 | 53 | 0 | 35.29071824 | -98.99180434 | 2022-04-12 04:20:49 | Washita, Oklahoma, US | |
3208037 | 3208037 | 2022-04-11 | US | Minnesota | Stevens | 27149 | 2627 | 13 | 0 | 45.58613007 | -96.00163705 | 2022-04-12 04:20:49 | Stevens, Minnesota, US | |
1578758 | 1578758 | 2022-04-10 | US | Oklahoma | Washita | 40149 | 2627 | 53 | 0 | 35.29071824 | -98.99180434 | 2022-04-11 04:21:02 | Washita, Oklahoma, US | |
1577923 | 1577923 | 2022-04-10 | US | Minnesota | Stevens | 27149 | 2627 | 13 | 0 | 45.58613007 | -96.00163705 | 2022-04-11 04:21:02 | Stevens, Minnesota, US | |
1655000 | 1655000 | 2022-04-09 | US | Oklahoma | Washita | 40149 | 2627 | 53 | 0 | 35.29071824 | -98.99180434 | 2022-04-10 04:20:52 | Washita, Oklahoma, US | |
1654165 | 1654165 | 2022-04-09 | US | Minnesota | Stevens | 27149 | 2627 | 13 | 0 | 45.58613007 | -96.00163705 | 2022-04-10 04:20:52 | Stevens, Minnesota, US | |
2118322 | 2118322 | 2022-04-08 | US | Oklahoma | Washita | 40149 | 2627 | 53 | 0 | 35.29071824 | -98.99180434 | 2022-04-09 04:20:42 | Washita, Oklahoma, US | |
2117487 | 2117487 | 2022-04-08 | US | Minnesota | Stevens | 27149 | 2627 | 13 | 0 | 45.58613007 | -96.00163705 | 2022-04-09 04:20:42 | Stevens, Minnesota, US | |
3322846 | 3322846 | 2022-04-07 | US | Oklahoma | Washita | 40149 | 2627 | 53 | 0 | 35.29071824 | -98.99180434 | 2022-04-08 04:20:48 | Washita, Oklahoma, US | |
3322011 | 3322011 | 2022-04-07 | US | Minnesota | Stevens | 27149 | 2627 | 13 | 0 | 45.58613007 | -96.00163705 | 2022-04-08 04:20:48 | Stevens, Minnesota, US | |
2803382 | 2803382 | 2022-04-06 | US | Oklahoma | Washita | 40149 | 2627 | 51 | 0 | 35.29071824 | -98.99180434 | 2022-04-07 04:20:53 | Washita, Oklahoma, US | |
3870151 | 3870151 | 2022-04-05 | US | Oklahoma | Washita | 40149 | 2627 | 51 | 0 | 35.29071824 | -98.99180434 | 2022-04-06 04:20:49 | Washita, Oklahoma, US | |
2751493 | 2751493 | 2022-04-04 | US | Oklahoma | Washita | 40149 | 2627 | 51 | 0 | 35.29071824 | -98.99180434 | 2022-04-05 04:20:48 | Washita, Oklahoma, US | |
3732839 | 3732839 | 2022-04-03 | US | Oklahoma | Washita | 40149 | 2627 | 51 | 0 | 35.29071824 | -98.99180434 | 2022-04-04 04:20:51 | Washita, Oklahoma, US | |
502274 | 502274 | 2022-04-02 | US | Oklahoma | Washita | 40149 | 2627 | 51 | 0 | 35.29071824 | -98.99180434 | 2022-04-03 04:20:48 | Washita, Oklahoma, US | |
3353702 | 3353702 | 2022-04-01 | US | Texas | Childress | 48075 | 2627 | 31 | 0 | 34.529304100000004 | -100.2077916 | 2022-04-02 04:20:47 | Childress, Texas, US | |
3353259 | 3353259 | 2022-04-01 | US | Oklahoma | Washita | 40149 | 2627 | 51 | 0 | 35.29071824 | -98.99180434 | 2022-04-02 04:20:47 | Washita, Oklahoma, US | |
1543007 | 1543007 | 2022-03-31 | US | Texas | Childress | 48075 | 2627 | 31 | 0 | 34.529304100000004 | -100.2077916 | 2022-04-01 04:20:28 | Childress, Texas, US | |
1542564 | 1542564 | 2022-03-31 | US | Oklahoma | Washita | 40149 | 2627 | 51 | 0 | 35.29071824 | -98.99180434 | 2022-04-01 04:20:28 | Washita, Oklahoma, US | |
2481020 | 2481020 | 2022-03-30 | US | Texas | Childress | 48075 | 2627 | 31 | 0 | 34.529304100000004 | -100.2077916 | 2022-03-31 04:20:56 | Childress, Texas, US | |
161061 | 161061 | 2022-03-29 | US | Texas | Childress | 48075 | 2627 | 31 | 0 | 34.529304100000004 | -100.2077916 | 2022-03-30 04:20:45 | Childress, Texas, US | |
27801 | 27801 | 2022-03-20 | US | Virginia | Richmond | 51159 | 2627 | 27 | 0 | 37.937575 | -76.72920628 | 2022-03-21 04:20:50 | Richmond, Virginia, US | |
1659811 | 1659811 | 2022-03-19 | US | Virginia | Richmond | 51159 | 2627 | 27 | 0 | 37.937575 | -76.72920628 | 2022-03-20 04:20:45 | Richmond, Virginia, US | |
339337 | 339337 | 2022-03-18 | US | Virginia | Richmond | 51159 | 2627 | 27 | 0 | 37.937575 | -76.72920628 | 2022-03-19 04:20:47 | Richmond, Virginia, US | |
697790 | 697790 | 2022-03-17 | US | Virginia | Richmond | 51159 | 2627 | 27 | 0 | 37.937575 | -76.72920628 | 2022-03-18 04:20:55 | Richmond, Virginia, US | |
696417 | 696417 | 2022-03-17 | US | Montana | Rosebud | 30087 | 2627 | 59 | 0 | 46.23397237 | -106.72928799999998 | 2022-03-18 04:20:55 | Rosebud, Montana, US | |
2321360 | 2321360 | 2022-03-16 | US | Montana | Rosebud | 30087 | 2627 | 59 | 0 | 46.23397237 | -106.72928799999998 | 2022-03-17 04:20:56 | Rosebud, Montana, US | |
263560 | 263560 | 2022-03-15 | US | Montana | Rosebud | 30087 | 2627 | 59 | 0 | 46.23397237 | -106.72928799999998 | 2022-03-16 04:20:50 | Rosebud, Montana, US | |
3629985 | 3629985 | 2022-03-13 | US | Montana | Rosebud | 30087 | 2627 | 59 | 0 | 46.23397237 | -106.72928799999998 | 2022-03-14 04:20:46 | Rosebud, Montana, 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]);