johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
537 rows where confirmed = 997 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1076465 | 1076465 | 2022-12-28 | US | Oklahoma | Ellis | 40045 | 997 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-12-29 04:21:01 | Ellis, Oklahoma, US | |
330462 | 330462 | 2022-12-27 | US | Oklahoma | Ellis | 40045 | 997 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-12-28 04:21:04 | Ellis, Oklahoma, US | |
220535 | 220535 | 2022-12-26 | US | Oklahoma | Ellis | 40045 | 997 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-12-27 04:21:07 | Ellis, Oklahoma, US | |
3224992 | 3224992 | 2022-12-25 | US | Oklahoma | Ellis | 40045 | 997 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-12-26 04:21:06 | Ellis, Oklahoma, US | |
1020906 | 1020906 | 2022-12-24 | US | Oklahoma | Ellis | 40045 | 997 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-12-25 04:21:04 | Ellis, Oklahoma, US | |
692929 | 692929 | 2022-12-23 | US | Oklahoma | Ellis | 40045 | 997 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-12-24 04:21:02 | Ellis, Oklahoma, US | |
2182139 | 2182139 | 2022-12-22 | US | Oklahoma | Ellis | 40045 | 997 | 11 | 0 | 36.2180194 | -99.75324573 | 2022-12-23 04:21:04 | Ellis, Oklahoma, US | |
3552256 | 3552256 | 2022-11-27 | US | Colorado | Baca | 8009 | 997 | 16 | 0 | 37.31940883 | -102.5603223 | 2022-11-28 04:21:02 | Baca, Colorado, US | |
2100736 | 2100736 | 2022-11-26 | US | Colorado | Baca | 8009 | 997 | 16 | 0 | 37.31940883 | -102.5603223 | 2022-11-27 04:21:05 | Baca, Colorado, US | |
488227 | 488227 | 2022-11-25 | US | Colorado | Baca | 8009 | 997 | 16 | 0 | 37.31940883 | -102.5603223 | 2022-11-26 04:21:11 | Baca, Colorado, US | |
3524056 | 3524056 | 2022-11-24 | US | Colorado | Baca | 8009 | 997 | 16 | 0 | 37.31940883 | -102.5603223 | 2022-11-25 04:21:06 | Baca, Colorado, US | |
3312839 | 3312839 | 2022-11-23 | US | Colorado | Baca | 8009 | 997 | 16 | 0 | 37.31940883 | -102.5603223 | 2022-11-24 04:21:09 | Baca, Colorado, US | |
1620880 | 1620880 | 2022-11-22 | US | Colorado | Baca | 8009 | 997 | 16 | 0 | 37.31940883 | -102.5603223 | 2022-11-23 04:21:06 | Baca, Colorado, US | |
3460768 | 3460768 | 2022-11-21 | US | Colorado | Baca | 8009 | 997 | 16 | 0 | 37.31940883 | -102.5603223 | 2022-11-22 04:20:47 | Baca, Colorado, US | |
3253203 | 3253203 | 2022-10-11 | US | Texas | Coke | 48081 | 997 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-10-12 04:22:51 | Coke, Texas, US | |
2970462 | 2970462 | 2022-10-10 | US | Texas | Coke | 48081 | 997 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-10-11 04:23:05 | Coke, Texas, US | |
3100498 | 3100498 | 2022-10-09 | US | Texas | Coke | 48081 | 997 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-10-10 04:22:32 | Coke, Texas, US | |
4005723 | 4005723 | 2022-10-08 | US | Texas | Coke | 48081 | 997 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-10-09 04:21:16 | Coke, Texas, US | |
399320 | 399320 | 2022-10-07 | US | Texas | Coke | 48081 | 997 | 20 | 0 | 31.88911733 | -100.5297533 | 2022-10-08 04:22:56 | Coke, Texas, US | |
3746871 | 3746871 | 2022-09-07 | US | Minnesota | Red Lake | 27125 | 997 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-08 04:21:02 | Red Lake, Minnesota, US | |
117621 | 117621 | 2022-09-06 | US | South Dakota | Edmunds | 46045 | 997 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-09-07 04:20:59 | Edmunds, South Dakota, US | |
116993 | 116993 | 2022-09-06 | US | New York | Hamilton | 36041 | 997 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-09-07 04:20:59 | Hamilton, New York, US | |
116511 | 116511 | 2022-09-06 | US | Minnesota | Red Lake | 27125 | 997 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-07 04:20:59 | Red Lake, Minnesota, US | |
115400 | 115400 | 2022-09-06 | US | Colorado | Phillips | 8095 | 997 | 20 | 0 | 40.59414277 | -102.3577703 | 2022-09-07 04:20:59 | Phillips, Colorado, US | |
2636593 | 2636593 | 2022-09-05 | US | South Dakota | Edmunds | 46045 | 997 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-09-06 04:21:02 | Edmunds, South Dakota, US | |
2635965 | 2635965 | 2022-09-05 | US | New York | Hamilton | 36041 | 997 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-09-06 04:21:02 | Hamilton, New York, US | |
2635483 | 2635483 | 2022-09-05 | US | Minnesota | Red Lake | 27125 | 997 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-06 04:21:02 | Red Lake, Minnesota, US | |
2634372 | 2634372 | 2022-09-05 | US | Colorado | Phillips | 8095 | 997 | 20 | 0 | 40.59414277 | -102.3577703 | 2022-09-06 04:21:02 | Phillips, Colorado, US | |
2990157 | 2990157 | 2022-09-04 | US | South Dakota | Edmunds | 46045 | 997 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-09-05 04:21:01 | Edmunds, South Dakota, US | |
2989529 | 2989529 | 2022-09-04 | US | New York | Hamilton | 36041 | 997 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-09-05 04:21:01 | Hamilton, New York, US | |
2989047 | 2989047 | 2022-09-04 | US | Minnesota | Red Lake | 27125 | 997 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-05 04:21:01 | Red Lake, Minnesota, US | |
2715842 | 2715842 | 2022-09-03 | US | South Dakota | Edmunds | 46045 | 997 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-09-04 04:21:22 | Edmunds, South Dakota, US | |
2714732 | 2714732 | 2022-09-03 | US | Minnesota | Red Lake | 27125 | 997 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-04 04:21:22 | Red Lake, Minnesota, US | |
1396547 | 1396547 | 2022-09-02 | US | South Dakota | Edmunds | 46045 | 997 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-09-03 04:21:04 | Edmunds, South Dakota, US | |
1395437 | 1395437 | 2022-09-02 | US | Minnesota | Red Lake | 27125 | 997 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-03 04:21:04 | Red Lake, Minnesota, US | |
3550376 | 3550376 | 2022-09-01 | US | South Dakota | Edmunds | 46045 | 997 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-09-02 04:21:07 | Edmunds, South Dakota, US | |
3549266 | 3549266 | 2022-09-01 | US | Minnesota | Red Lake | 27125 | 997 | 13 | 0 | 47.87197525 | -96.09561104 | 2022-09-02 04:21:07 | Red Lake, Minnesota, US | |
2346296 | 2346296 | 2022-08-31 | US | South Dakota | Edmunds | 46045 | 997 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-09-01 04:21:03 | Edmunds, South Dakota, US | |
1880102 | 1880102 | 2022-08-28 | US | Texas | Haskell | 48207 | 997 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-08-29 04:21:06 | Haskell, Texas, US | |
2099229 | 2099229 | 2022-08-27 | US | Texas | Haskell | 48207 | 997 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-08-28 04:21:02 | Haskell, Texas, US | |
1535044 | 1535044 | 2022-08-26 | US | Texas | Haskell | 48207 | 997 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-08-27 04:20:57 | Haskell, Texas, US | |
2831931 | 2831931 | 2022-08-25 | US | Texas | Haskell | 48207 | 997 | 39 | 0 | 33.17823584 | -99.73037358 | 2022-08-26 04:21:02 | Haskell, Texas, US | |
1608940 | 1608940 | 2022-07-20 | US | Delaware | Unassigned | 90010 | 997 | 0 | 0 | 39.57992638 | 0.0 | 2022-07-21 04:21:10 | Unassigned, Delaware, US | |
959573 | 959573 | 2022-07-19 | US | Delaware | Unassigned | 90010 | 997 | 0 | 0 | 39.57992638 | 0.0 | 2022-07-20 04:20:59 | Unassigned, Delaware, US | |
3112019 | 3112019 | 2022-07-13 | US | Oklahoma | Beaver | 40007 | 997 | 11 | 0 | 36.7496847 | -100.4758872 | 2022-07-14 04:20:57 | Beaver, Oklahoma, US | |
632442 | 632442 | 2022-07-12 | US | Oklahoma | Beaver | 40007 | 997 | 11 | 0 | 36.7496847 | -100.4758872 | 2022-07-13 04:20:58 | Beaver, Oklahoma, US | |
1214086 | 1214086 | 2022-07-11 | US | Oklahoma | Beaver | 40007 | 997 | 11 | 0 | 36.7496847 | -100.4758872 | 2022-07-12 04:20:51 | Beaver, Oklahoma, US | |
2791568 | 2791568 | 2022-07-10 | US | Oklahoma | Beaver | 40007 | 997 | 11 | 0 | 36.7496847 | -100.4758872 | 2022-07-11 04:20:46 | Beaver, Oklahoma, US | |
144521 | 144521 | 2022-07-09 | US | Oklahoma | Beaver | 40007 | 997 | 11 | 0 | 36.7496847 | -100.4758872 | 2022-07-10 04:20:54 | Beaver, Oklahoma, US | |
1419621 | 1419621 | 2022-07-08 | US | Oklahoma | Beaver | 40007 | 997 | 11 | 0 | 36.7496847 | -100.4758872 | 2022-07-09 04:20:59 | Beaver, Oklahoma, US | |
2743546 | 2743546 | 2022-07-07 | US | Oklahoma | Beaver | 40007 | 997 | 11 | 0 | 36.7496847 | -100.4758872 | 2022-07-08 04:20:56 | Beaver, Oklahoma, US | |
2490487 | 2490487 | 2022-06-29 | US | Arkansas | Calhoun | 5013 | 997 | 11 | 0 | 33.55598792 | -92.49974403 | 2022-06-30 04:21:01 | Calhoun, Arkansas, US | |
2242161 | 2242161 | 2022-06-28 | US | Puerto Rico | Maricao | 72093 | 997 | 0 | 0 | 18.171795 | -66.942126 | 2022-06-29 04:20:59 | Maricao, Puerto Rico, US | |
2150403 | 2150403 | 2022-06-27 | US | Puerto Rico | Maricao | 72093 | 997 | 0 | 0 | 18.171795 | -66.942126 | 2022-06-28 04:20:58 | Maricao, Puerto Rico, US | |
231600 | 231600 | 2022-05-31 | US | North Carolina | Tyrrell | 37177 | 997 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-06-01 04:20:55 | Tyrrell, North Carolina, US | |
3188365 | 3188365 | 2022-05-30 | US | North Carolina | Tyrrell | 37177 | 997 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-05-31 04:20:51 | Tyrrell, North Carolina, US | |
3200514 | 3200514 | 2022-05-29 | US | North Carolina | Tyrrell | 37177 | 997 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-05-30 04:20:50 | Tyrrell, North Carolina, US | |
2727392 | 2727392 | 2022-05-28 | US | North Carolina | Tyrrell | 37177 | 997 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-05-29 04:20:53 | Tyrrell, North Carolina, US | |
1316573 | 1316573 | 2022-05-27 | US | North Carolina | Tyrrell | 37177 | 997 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-05-28 04:21:07 | Tyrrell, North Carolina, US | |
1853118 | 1853118 | 2022-05-26 | US | Texas | Hudspeth | 48229 | 997 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-27 04:20:56 | Hudspeth, Texas, US | |
1852365 | 1852365 | 2022-05-26 | US | North Carolina | Tyrrell | 37177 | 997 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-05-27 04:20:56 | Tyrrell, North Carolina, US | |
2050994 | 2050994 | 2022-05-25 | US | Texas | Hudspeth | 48229 | 997 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-26 04:20:50 | Hudspeth, Texas, US | |
2050241 | 2050241 | 2022-05-25 | US | North Carolina | Tyrrell | 37177 | 997 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-05-26 04:20:50 | Tyrrell, North Carolina, US | |
3002432 | 3002432 | 2022-05-24 | US | Texas | Hudspeth | 48229 | 997 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-25 04:20:56 | Hudspeth, Texas, US | |
625005 | 625005 | 2022-05-22 | US | Texas | Hudspeth | 48229 | 997 | 18 | 0 | 31.45628381 | -105.388178 | 2022-05-26 04:20:50 | Hudspeth, Texas, US | |
624252 | 624252 | 2022-05-22 | US | North Carolina | Tyrrell | 37177 | 997 | 8 | 0 | 35.87147226 | -76.17055253 | 2022-05-26 04:20:50 | Tyrrell, North Carolina, US | |
2536597 | 2536597 | 2022-05-12 | US | Texas | Presidio | 48377 | 997 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-13 04:20:51 | Presidio, Texas, US | |
3448043 | 3448043 | 2022-05-11 | US | Texas | Presidio | 48377 | 997 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-12 04:20:54 | Presidio, Texas, US | |
3538660 | 3538660 | 2022-05-10 | US | Texas | Presidio | 48377 | 997 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-11 04:20:48 | Presidio, Texas, US | |
225195 | 225195 | 2022-05-09 | US | Texas | Presidio | 48377 | 997 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-10 04:20:50 | Presidio, Texas, US | |
2334580 | 2334580 | 2022-05-08 | US | Texas | Presidio | 48377 | 997 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-09 04:20:54 | Presidio, Texas, US | |
363542 | 363542 | 2022-05-07 | US | Texas | Presidio | 48377 | 997 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-08 04:20:49 | Presidio, Texas, US | |
1400893 | 1400893 | 2022-05-06 | US | Texas | Presidio | 48377 | 997 | 38 | 0 | 29.99954402 | -104.2408079 | 2022-05-07 04:21:09 | Presidio, Texas, US | |
3266060 | 3266060 | 2022-05-04 | US | California | Modoc | 6049 | 997 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-05-05 04:20:55 | Modoc, California, US | |
1572699 | 1572699 | 2022-05-03 | US | California | Modoc | 6049 | 997 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-05-04 04:20:59 | Modoc, California, US | |
463959 | 463959 | 2022-05-02 | US | California | Modoc | 6049 | 997 | 8 | 0 | 41.58965602 | -120.7244817 | 2022-05-03 04:21:00 | Modoc, California, US | |
2116339 | 2116339 | 2022-04-08 | US | Colorado | Gilpin | 8047 | 997 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-04-09 04:20:42 | Gilpin, Colorado, US | |
3320863 | 3320863 | 2022-04-07 | US | Colorado | Gilpin | 8047 | 997 | 4 | 0 | 39.85646523 | -105.5252597 | 2022-04-08 04:20:48 | Gilpin, Colorado, US | |
3350467 | 3350467 | 2022-04-01 | China | Xinjiang | 997 | 3 | 0 | 41.1129 | 85.2401 | 2022-04-02 04:20:47 | Xinjiang, China | |||
1542366 | 1542366 | 2022-03-31 | US | North Dakota | LaMoure | 38045 | 997 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-04-01 04:20:28 | LaMoure, North Dakota, US | |
1539772 | 1539772 | 2022-03-31 | China | Xinjiang | 997 | 3 | 0 | 41.1129 | 85.2401 | 2022-04-01 04:20:28 | Xinjiang, China | |||
2480379 | 2480379 | 2022-03-30 | US | North Dakota | LaMoure | 38045 | 997 | 20 | 0 | 46.45681054 | -98.53542355 | 2022-03-31 04:20:56 | LaMoure, North Dakota, US | |
2477785 | 2477785 | 2022-03-30 | China | Xinjiang | 997 | 3 | 0 | 41.1129 | 85.2401 | 2022-03-31 04:20:56 | Xinjiang, China | |||
696511 | 696511 | 2022-03-17 | US | Nebraska | Sheridan | 31161 | 997 | 10 | 0 | 42.50284406 | -102.4126613 | 2022-03-18 04:20:55 | Sheridan, Nebraska, US | |
2321454 | 2321454 | 2022-03-16 | US | Nebraska | Sheridan | 31161 | 997 | 10 | 0 | 42.50284406 | -102.4126613 | 2022-03-17 04:20:56 | Sheridan, Nebraska, US | |
264288 | 264288 | 2022-03-15 | US | Puerto Rico | Las Marias | 72083 | 997 | 0 | 0 | 18.23679 | -66.98362 | 2022-03-16 04:20:50 | Las Marias, Puerto Rico, US | |
922971 | 922971 | 2022-03-08 | US | Vermont | Grand Isle | 50013 | 997 | 5 | 0 | 44.797582399999996 | -73.29679772 | 2022-03-09 04:20:59 | Grand Isle, Vermont, US | |
1551258 | 1551258 | 2022-03-07 | US | Vermont | Grand Isle | 50013 | 997 | 5 | 0 | 44.797582399999996 | -73.29679772 | 2022-03-08 04:20:54 | Grand Isle, Vermont, US | |
2202965 | 2202965 | 2022-03-06 | US | Virginia | Covington | 51580 | 997 | 24 | 0 | 37.7824656 | -79.98631446 | 2022-03-07 04:20:47 | Covington, Virginia, US | |
2095422 | 2095422 | 2022-03-05 | US | Virginia | Covington | 51580 | 997 | 24 | 0 | 37.7824656 | -79.98631446 | 2022-03-06 04:20:49 | Covington, Virginia, US | |
2669122 | 2669122 | 2022-03-04 | US | Virginia | Covington | 51580 | 997 | 24 | 0 | 37.7824656 | -79.98631446 | 2022-03-05 04:21:10 | Covington, Virginia, US | |
1363276 | 1363276 | 2022-02-08 | US | Idaho | Boise | 16015 | 997 | 13 | 0 | 43.98829931 | -115.7309284 | 2022-02-09 04:21:04 | Boise, Idaho, US | |
1362237 | 1362237 | 2022-02-08 | France | Saint Pierre and Miquelon | 997 | 1 | 0 | 46.8852 | -56.3159 | 2022-02-09 04:21:04 | Saint Pierre and Miquelon, France | |||
2660849 | 2660849 | 2022-01-31 | US | Texas | Concho | 48095 | 997 | 10 | 0 | 31.32635934 | -99.86473038 | 2022-02-01 04:21:11 | Concho, Texas, US | |
3302250 | 3302250 | 2022-01-30 | US | Nebraska | Antelope | 31003 | 997 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2022-01-31 04:21:09 | Antelope, Nebraska, US | |
3064700 | 3064700 | 2022-01-29 | US | Pennsylvania | Sullivan | 42113 | 997 | 32 | 0 | 41.44634738 | -76.51246591 | 2022-01-30 04:21:26 | Sullivan, Pennsylvania, US | |
3064041 | 3064041 | 2022-01-29 | US | Nebraska | Antelope | 31003 | 997 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2022-01-30 04:21:26 | Antelope, Nebraska, US | |
3812965 | 3812965 | 2022-01-28 | US | Texas | Brewster | 48043 | 997 | 25 | 0 | 29.81008251 | -103.25203259999999 | 2022-01-29 04:21:10 | Brewster, Texas, US | |
3811975 | 3811975 | 2022-01-28 | US | Nebraska | Antelope | 31003 | 997 | 7 | 0 | 42.17695516 | -98.06662829999999 | 2022-01-29 04:21:10 | Antelope, Nebraska, US | |
1230998 | 1230998 | 2022-01-24 | US | Virginia | Norton | 51720 | 997 | 20 | 0 | 36.93357076 | -82.62750411 | 2022-01-25 04:21:05 | Norton, Virginia, 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]);