johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
500 rows where confirmed = 998 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3756529 | 3756529 | 2022-10-13 | US | Texas | Coke | 48081 | 998 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-10-14 04:22:28 | Coke, Texas, US | |
3217354 | 3217354 | 2022-10-12 | US | Texas | Coke | 48081 | 998 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-10-13 04:22:39 | Coke, Texas, US | |
1372256 | 1372256 | 2022-09-21 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-22 04:22:56 | Red Lake, Minnesota, US | |
2018486 | 2018486 | 2022-09-20 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-21 04:23:22 | Red Lake, Minnesota, US | |
3572359 | 3572359 | 2022-09-19 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-20 04:22:48 | Red Lake, Minnesota, US | |
421098 | 421098 | 2022-09-18 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-19 04:21:49 | Red Lake, Minnesota, US | |
3375122 | 3375122 | 2022-09-17 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-18 04:22:50 | Red Lake, Minnesota, US | |
2357230 | 2357230 | 2022-09-16 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-17 04:20:19 | Red Lake, Minnesota, US | |
3988387 | 3988387 | 2022-09-15 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-16 04:21:19 | Red Lake, Minnesota, US | |
1890904 | 1890904 | 2022-09-14 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-15 04:21:02 | Red Lake, Minnesota, US | |
373959 | 373959 | 2022-09-13 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-14 04:20:44 | Red Lake, Minnesota, US | |
2396561 | 2396561 | 2022-09-12 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-13 04:20:57 | Red Lake, Minnesota, US | |
3768121 | 3768121 | 2022-09-11 | US | New York | Hamilton | 36041 | 998 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-09-12 04:20:58 | Hamilton, New York, US | |
3767639 | 3767639 | 2022-09-11 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-12 04:20:58 | Red Lake, Minnesota, US | |
3826696 | 3826696 | 2022-09-10 | US | New York | Hamilton | 36041 | 998 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-09-11 04:20:50 | Hamilton, New York, US | |
3826214 | 3826214 | 2022-09-10 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-11 04:20:50 | Red Lake, Minnesota, US | |
965153 | 965153 | 2022-09-09 | US | New York | Hamilton | 36041 | 998 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-09-10 04:21:10 | Hamilton, New York, US | |
964671 | 964671 | 2022-09-09 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-10 04:21:10 | Red Lake, Minnesota, US | |
255555 | 255555 | 2022-09-08 | US | New York | Hamilton | 36041 | 998 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-09-09 04:21:11 | Hamilton, New York, US | |
255073 | 255073 | 2022-09-08 | US | Minnesota | Red Lake | 27125 | 998 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-09 04:21:11 | Red Lake, Minnesota, US | |
253962 | 253962 | 2022-09-08 | US | Colorado | Phillips | 8095 | 998 | 20 | 0 | 40.59414277 | -102.3577703 | 2022-09-09 04:21:11 | Phillips, Colorado, US | |
3747353 | 3747353 | 2022-09-07 | US | New York | Hamilton | 36041 | 998 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-09-08 04:21:02 | Hamilton, New York, US | |
3745760 | 3745760 | 2022-09-07 | US | Colorado | Phillips | 8095 | 998 | 20 | 0 | 40.59414277 | -102.3577703 | 2022-09-08 04:21:02 | Phillips, Colorado, US | |
3547291 | 3547291 | 2022-09-01 | China | Chongqing | 998 | 6 | 0 | 30.0572 | 107.874 | 2022-09-02 04:21:07 | Chongqing, China | |||
1406343 | 1406343 | 2022-08-02 | US | Kansas | Haskell | 20081 | 998 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-08-03 04:20:59 | Haskell, Kansas, US | |
3618381 | 3618381 | 2022-08-01 | US | Kansas | Haskell | 20081 | 998 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-08-02 04:20:53 | Haskell, Kansas, US | |
3872861 | 3872861 | 2022-07-31 | US | Kansas | Haskell | 20081 | 998 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-08-01 04:21:03 | Haskell, Kansas, US | |
675615 | 675615 | 2022-07-30 | US | Kansas | Haskell | 20081 | 998 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-31 04:21:02 | Haskell, Kansas, US | |
1784814 | 1784814 | 2022-07-29 | US | Kansas | Haskell | 20081 | 998 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-30 04:20:42 | Haskell, Kansas, US | |
1067177 | 1067177 | 2022-07-28 | US | Kansas | Haskell | 20081 | 998 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-29 04:20:45 | Haskell, Kansas, US | |
2336696 | 2336696 | 2022-07-27 | US | Kansas | Haskell | 20081 | 998 | 12 | 0 | 37.5620394 | -100.8710738 | 2022-07-28 04:20:56 | Haskell, Kansas, US | |
3110131 | 3110131 | 2022-07-13 | US | Colorado | Ouray | 8091 | 998 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-07-14 04:20:57 | Ouray, Colorado, US | |
3940529 | 3940529 | 2022-06-30 | US | Arkansas | Calhoun | 5013 | 998 | 11 | 0 | 33.55598792 | -92.49974403 | 2022-07-01 04:21:10 | Calhoun, Arkansas, US | |
3271055 | 3271055 | 2022-06-19 | US | Louisiana | Tensas | 22107 | 998 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-06-20 04:21:01 | Tensas, Louisiana, US | |
3398967 | 3398967 | 2022-06-18 | US | Louisiana | Tensas | 22107 | 998 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-06-19 04:20:51 | Tensas, Louisiana, US | |
2312844 | 2312844 | 2022-06-17 | US | Louisiana | Tensas | 22107 | 998 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-06-18 04:21:10 | Tensas, Louisiana, US | |
560348 | 560348 | 2022-06-16 | US | Louisiana | Tensas | 22107 | 998 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-06-17 04:20:56 | Tensas, Louisiana, US | |
3984150 | 3984150 | 2022-06-15 | US | Louisiana | Tensas | 22107 | 998 | 11 | 0 | 32.00760749 | -91.32915234 | 2022-06-16 04:20:55 | Tensas, Louisiana, US | |
973321 | 973321 | 2022-06-01 | US | North Dakota | Foster | 38031 | 998 | 23 | 0 | 47.4571084 | -98.88279923 | 2022-06-02 05:20:39 | Foster, North Dakota, US | |
2087159 | 2087159 | 2022-05-15 | US | Texas | Presidio | 48377 | 998 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-16 04:20:47 | Presidio, Texas, US | |
3357869 | 3357869 | 2022-05-14 | US | Texas | Presidio | 48377 | 998 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-15 04:20:53 | Presidio, Texas, US | |
661514 | 661514 | 2022-05-13 | US | Texas | Presidio | 48377 | 998 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-14 04:20:48 | Presidio, Texas, US | |
2331943 | 2331943 | 2022-05-08 | US | California | Modoc | 6049 | 998 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-05-09 04:20:54 | Modoc, California, US | |
360905 | 360905 | 2022-05-07 | US | California | Modoc | 6049 | 998 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-05-08 04:20:49 | Modoc, California, US | |
1398256 | 1398256 | 2022-05-06 | US | California | Modoc | 6049 | 998 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-05-07 04:21:09 | Modoc, California, US | |
2309240 | 2309240 | 2022-04-20 | US | Missouri | Putnam | 29171 | 998 | 24 | 0 | 40.47942497 | -93.02042674 | 2022-04-21 04:20:46 | Putnam, Missouri, US | |
2253379 | 2253379 | 2022-04-19 | US | Missouri | Putnam | 29171 | 998 | 24 | 0 | 40.47942497 | -93.02042674 | 2022-04-20 04:20:45 | Putnam, Missouri, US | |
1847929 | 1847929 | 2022-04-18 | US | Missouri | Putnam | 29171 | 998 | 24 | 0 | 40.47942497 | -93.02042674 | 2022-04-19 04:21:00 | Putnam, Missouri, US | |
3418873 | 3418873 | 2022-04-17 | US | Missouri | Putnam | 29171 | 998 | 24 | 0 | 40.47942497 | -93.02042674 | 2022-04-18 04:21:12 | Putnam, Missouri, US | |
305822 | 305822 | 2022-04-16 | US | Missouri | Putnam | 29171 | 998 | 24 | 0 | 40.47942497 | -93.02042674 | 2022-04-17 04:20:59 | Putnam, Missouri, US | |
2671767 | 2671767 | 2022-04-15 | US | Missouri | Putnam | 29171 | 998 | 24 | 0 | 40.47942497 | -93.02042674 | 2022-04-16 04:20:48 | Putnam, Missouri, US | |
1225552 | 1225552 | 2022-04-14 | US | Missouri | Putnam | 29171 | 998 | 24 | 0 | 40.47942497 | -93.02042674 | 2022-04-15 04:20:57 | Putnam, Missouri, US | |
1949136 | 1949136 | 2022-04-12 | US | Colorado | Gilpin | 8047 | 998 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-04-13 04:21:03 | Gilpin, Colorado, US | |
3206889 | 3206889 | 2022-04-11 | US | Colorado | Gilpin | 8047 | 998 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-04-12 04:20:49 | Gilpin, Colorado, US | |
1579552 | 1579552 | 2022-04-10 | US | Virginia | Rappahannock | 51157 | 998 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-04-11 04:21:02 | Rappahannock, Virginia, US | |
1576775 | 1576775 | 2022-04-10 | US | Colorado | Gilpin | 8047 | 998 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-04-11 04:21:02 | Gilpin, Colorado, US | |
1655794 | 1655794 | 2022-04-09 | US | Virginia | Rappahannock | 51157 | 998 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-04-10 04:20:52 | Rappahannock, Virginia, US | |
1653017 | 1653017 | 2022-04-09 | US | Colorado | Gilpin | 8047 | 998 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-04-10 04:20:52 | Gilpin, Colorado, US | |
2119116 | 2119116 | 2022-04-08 | US | Virginia | Rappahannock | 51157 | 998 | 10 | 0 | 38.68295619 | -78.15826963 | 2022-04-09 04:20:42 | Rappahannock, Virginia, US | |
3730047 | 3730047 | 2022-04-03 | China | Xinjiang | 998 | 3 | 0 | 41.1129 | 85.2401 | 2022-04-04 04:20:51 | Xinjiang, China | |||
499482 | 499482 | 2022-04-02 | China | Xinjiang | 998 | 3 | 0 | 41.1129 | 85.2401 | 2022-04-03 04:20:48 | Xinjiang, China | |||
1471392 | 1471392 | 2022-03-24 | US | Vermont | Unassigned | 90050 | 998 | 2 | 0 | 44.85627605 | 0.0 | 2022-03-25 04:20:46 | Unassigned, Vermont, US | |
1908488 | 1908488 | 2022-03-22 | US | Vermont | Unassigned | 90050 | 998 | 2 | 0 | 44.85627605 | 0.0 | 2022-03-23 04:20:48 | Unassigned, Vermont, US | |
26522 | 26522 | 2022-03-20 | US | Nebraska | Sheridan | 31161 | 998 | 10 | 0 | 42.50284406 | -102.4126613 | 2022-03-21 04:20:50 | Sheridan, Nebraska, US | |
1658532 | 1658532 | 2022-03-19 | US | Nebraska | Sheridan | 31161 | 998 | 10 | 0 | 42.50284406 | -102.4126613 | 2022-03-20 04:20:45 | Sheridan, Nebraska, US | |
338058 | 338058 | 2022-03-18 | US | Nebraska | Sheridan | 31161 | 998 | 10 | 0 | 42.50284406 | -102.4126613 | 2022-03-19 04:20:47 | Sheridan, Nebraska, US | |
1551296 | 1551296 | 2022-03-07 | US | Virginia | Covington | 51580 | 998 | 24 | 0 | 37.7824656 | -79.98631446 | 2022-03-08 04:20:54 | Covington, Virginia, US | |
1060287 | 1060287 | 2022-02-23 | US | North Dakota | Wells | 38103 | 998 | 11 | 0 | 47.58614526 | -99.65904998 | 2022-02-24 04:21:14 | Wells, North Dakota, US | |
1301128 | 1301128 | 2022-02-17 | US | Texas | Donley | 48129 | 998 | 24 | 0 | 34.96517499 | -100.8140093 | 2022-02-18 04:21:04 | Donley, Texas, US | |
3822864 | 3822864 | 2022-02-16 | US | North Dakota | Sargent | 38081 | 998 | 9 | 0 | 46.10830372 | -97.63217159 | 2022-02-17 04:20:56 | Sargent, North Dakota, US | |
1362766 | 1362766 | 2022-02-08 | US | Alaska | Aleutians East | 2013 | 998 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-02-09 04:21:04 | Aleutians East, Alaska, US | |
71504 | 71504 | 2022-02-07 | US | Alaska | Aleutians East | 2013 | 998 | 3 | 0 | 55.32222414 | -161.9722021 | 2022-02-08 04:21:15 | Aleutians East, Alaska, US | |
2477013 | 2477013 | 2022-02-03 | US | Texas | Concho | 48095 | 998 | 11 | 0 | 31.32635934 | -99.86473038 | 2022-02-04 04:21:10 | Concho, Texas, US | |
462438 | 462438 | 2022-02-02 | US | Texas | Concho | 48095 | 998 | 10 | 0 | 31.32635934 | -99.86473038 | 2022-02-03 04:21:21 | Concho, Texas, US | |
982007 | 982007 | 2022-02-01 | US | Texas | Concho | 48095 | 998 | 10 | 0 | 31.32635934 | -99.86473038 | 2022-02-02 04:21:09 | Concho, Texas, US | |
3303752 | 3303752 | 2022-01-30 | US | Wisconsin | Florence | 55037 | 998 | 15 | 0 | 45.84963535 | -88.39804137 | 2022-01-31 04:21:09 | Florence, Wisconsin, US | |
3065543 | 3065543 | 2022-01-29 | US | Wisconsin | Florence | 55037 | 998 | 15 | 0 | 45.84963535 | -88.39804137 | 2022-01-30 04:21:26 | Florence, Wisconsin, US | |
3065031 | 3065031 | 2022-01-29 | US | Texas | Brewster | 48043 | 998 | 25 | 0 | 29.81008251 | -103.25203259999999 | 2022-01-30 04:21:26 | Brewster, Texas, US | |
3813477 | 3813477 | 2022-01-28 | US | Wisconsin | Florence | 55037 | 998 | 15 | 0 | 45.84963535 | -88.39804137 | 2022-01-29 04:21:10 | Florence, Wisconsin, US | |
1144244 | 1144244 | 2022-01-23 | US | Virginia | Emporia | 51595 | 998 | 46 | 0 | 36.69455571 | -77.53406129 | 2022-01-24 04:21:12 | Emporia, Virginia, US | |
1144175 | 1144175 | 2022-01-23 | US | Texas | Yoakum | 48501 | 998 | 37 | 0 | 33.17320212 | -102.82764329999999 | 2022-01-24 04:21:12 | Yoakum, Texas, US | |
2836162 | 2836162 | 2022-01-22 | US | Virginia | Emporia | 51595 | 998 | 46 | 0 | 36.69455571 | -77.53406129 | 2022-01-23 04:21:13 | Emporia, Virginia, US | |
3428280 | 3428280 | 2022-01-21 | US | Virginia | Emporia | 51595 | 998 | 46 | 0 | 36.69455571 | -77.53406129 | 2022-01-22 04:21:13 | Emporia, Virginia, US | |
1960367 | 1960367 | 2022-01-20 | China | Tianjin | 998 | 3 | 0 | 39.3054 | 117.323 | 2022-01-21 04:21:09 | Tianjin, China | |||
102057 | 102057 | 2022-01-14 | US | Puerto Rico | Ceiba | 72037 | 998 | 0 | 0 | 18.251818 | -65.666416 | 2022-01-15 04:21:07 | Ceiba, Puerto Rico, US | |
3688825 | 3688825 | 2022-01-13 | US | Kansas | Scott | 20171 | 998 | 32 | 0 | 38.48222076 | -100.90665390000001 | 2022-01-14 04:21:54 | Scott, Kansas, US | |
3616160 | 3616160 | 2022-01-12 | US | Texas | Garza | 48169 | 998 | 25 | 0 | 33.17969345 | -101.2984114 | 2022-01-13 08:00:09 | Garza, Texas, US | |
3614409 | 3614409 | 2022-01-12 | US | Kansas | Scott | 20171 | 998 | 32 | 0 | 38.48222076 | -100.90665390000001 | 2022-01-13 08:00:09 | Scott, Kansas, US | |
1114934 | 1114934 | 2022-01-11 | US | Kansas | Scott | 20171 | 998 | 32 | 0 | 38.48222076 | -100.90665390000001 | 2022-01-12 04:21:44 | Scott, Kansas, US | |
1693662 | 1693662 | 2022-01-10 | US | Kansas | Scott | 20171 | 998 | 32 | 0 | 38.48222076 | -100.90665390000001 | 2022-01-11 04:22:01 | Scott, Kansas, US | |
129621 | 129621 | 2022-01-09 | US | South Dakota | Lyman | 46085 | 998 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-01-10 04:22:07 | Lyman, South Dakota, US | |
1218456 | 1218456 | 2022-01-08 | US | South Dakota | Lyman | 46085 | 998 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-01-09 04:21:46 | Lyman, South Dakota, US | |
1392549 | 1392549 | 2022-01-07 | US | South Dakota | Lyman | 46085 | 998 | 12 | 0 | 43.89522709 | -99.85201878 | 2022-01-08 04:21:53 | Lyman, South Dakota, US | |
1392381 | 1392381 | 2022-01-07 | US | Puerto Rico | Arroyo | 72015 | 998 | 0 | 0 | 17.998457000000005 | -66.056546 | 2022-01-08 04:21:53 | Arroyo, Puerto Rico, US | |
1284100 | 1284100 | 2022-01-05 | US | Nebraska | Pierce | 31139 | 998 | 20 | 0 | 42.26434853 | -97.60122773 | 2022-01-06 04:22:09 | Pierce, Nebraska, US | |
1288116 | 1288116 | 2022-01-04 | US | Nebraska | Pierce | 31139 | 998 | 20 | 0 | 42.26434853 | -97.60122773 | 2022-01-05 04:21:59 | Pierce, Nebraska, US | |
1702460 | 1702460 | 2022-01-03 | US | Nebraska | Pierce | 31139 | 998 | 20 | 0 | 42.26434853 | -97.60122773 | 2022-01-04 04:22:17 | Pierce, Nebraska, US | |
3519855 | 3519855 | 2022-01-02 | US | Alaska | Dillingham | 2070 | 998 | 10 | 0 | 59.79603738 | -158.23819419999995 | 2022-01-03 02:22:25 | Dillingham, Alaska, US | |
2167985 | 2167985 | 2022-01-01 | US | Alaska | Dillingham | 2070 | 998 | 10 | 0 | 59.79603738 | -158.23819419999995 | 2022-01-02 04:20:52 | Dillingham, Alaska, US | |
2777416 | 2777416 | 2021-12-31 | US | Alaska | Dillingham | 2070 | 998 | 10 | 0 | 59.79603738 | -158.23819419999995 | 2022-01-01 04:22:14 | Dillingham, Alaska, 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]);