johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
526 rows where confirmed = 905 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2755757 | 2755757 | 2022-12-29 | US | South Dakota | Bennett | 46007 | 905 | 16 | 0 | 43.19486375 | -101.6665572 | 2022-12-30 04:21:04 | Bennett, South Dakota, US | |
1076763 | 1076763 | 2022-12-28 | US | South Dakota | Bennett | 46007 | 905 | 16 | 0 | 43.19486375 | -101.6665572 | 2022-12-29 04:21:01 | Bennett, South Dakota, US | |
3717063 | 3717063 | 2022-12-06 | US | South Dakota | Marshall | 46091 | 905 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-07 04:20:58 | Marshall, South Dakota, US | |
3715515 | 3715515 | 2022-12-06 | US | Kansas | Rush | 20165 | 905 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-07 04:20:58 | Rush, Kansas, US | |
2417768 | 2417768 | 2022-12-05 | US | South Dakota | Marshall | 46091 | 905 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-06 04:21:03 | Marshall, South Dakota, US | |
2416220 | 2416220 | 2022-12-05 | US | Kansas | Rush | 20165 | 905 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-06 04:21:03 | Rush, Kansas, US | |
721376 | 721376 | 2022-12-04 | US | South Dakota | Marshall | 46091 | 905 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-05 04:20:58 | Marshall, South Dakota, US | |
719828 | 719828 | 2022-12-04 | US | Kansas | Rush | 20165 | 905 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-05 04:20:58 | Rush, Kansas, US | |
2819665 | 2819665 | 2022-12-03 | US | South Dakota | Marshall | 46091 | 905 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-04 04:20:56 | Marshall, South Dakota, US | |
2818117 | 2818117 | 2022-12-03 | US | Kansas | Rush | 20165 | 905 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-04 04:20:56 | Rush, Kansas, US | |
836521 | 836521 | 2022-12-02 | US | South Dakota | Marshall | 46091 | 905 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-03 04:21:02 | Marshall, South Dakota, US | |
834973 | 834973 | 2022-12-02 | US | Kansas | Rush | 20165 | 905 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-03 04:21:02 | Rush, Kansas, US | |
2139051 | 2139051 | 2022-12-01 | US | South Dakota | Marshall | 46091 | 905 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-02 04:21:07 | Marshall, South Dakota, US | |
2137503 | 2137503 | 2022-12-01 | US | Kansas | Rush | 20165 | 905 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-02 04:21:07 | Rush, Kansas, US | |
1967467 | 1967467 | 2022-11-30 | US | South Dakota | Marshall | 46091 | 905 | 15 | 0 | 45.75870838 | -97.59855639 | 2022-12-01 04:21:03 | Marshall, South Dakota, US | |
1965919 | 1965919 | 2022-11-30 | US | Kansas | Rush | 20165 | 905 | 20 | 0 | 38.52275276 | -99.30863983 | 2022-12-01 04:21:03 | Rush, Kansas, US | |
314295 | 314295 | 2022-11-13 | US | North Dakota | Bowman | 38011 | 905 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-11-14 04:21:09 | Bowman, North Dakota, US | |
65456 | 65456 | 2022-11-12 | US | North Dakota | Bowman | 38011 | 905 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-11-13 04:21:14 | Bowman, North Dakota, US | |
2929618 | 2929618 | 2022-11-11 | US | North Dakota | Bowman | 38011 | 905 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-11-12 04:20:41 | Bowman, North Dakota, US | |
2508454 | 2508454 | 2022-11-10 | US | North Dakota | Bowman | 38011 | 905 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-11-11 04:21:22 | Bowman, North Dakota, US | |
2433329 | 2433329 | 2022-11-09 | US | North Dakota | Bowman | 38011 | 905 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-11-10 04:21:16 | Bowman, North Dakota, US | |
481985 | 481985 | 2022-11-08 | US | North Dakota | Bowman | 38011 | 905 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-11-09 04:21:22 | Bowman, North Dakota, US | |
480754 | 480754 | 2022-11-08 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-11-09 04:21:22 | Adams, Iowa, US | |
2441135 | 2441135 | 2022-11-07 | US | North Dakota | Bowman | 38011 | 905 | 9 | 0 | 46.11285362 | -103.5203343 | 2022-11-08 04:21:21 | Bowman, North Dakota, US | |
2439904 | 2439904 | 2022-11-07 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-11-08 04:21:21 | Adams, Iowa, US | |
1051002 | 1051002 | 2022-11-06 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-11-07 04:21:26 | Adams, Iowa, US | |
619026 | 619026 | 2022-11-05 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-11-06 04:21:24 | Adams, Iowa, US | |
1023530 | 1023530 | 2022-11-04 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-11-05 04:21:52 | Adams, Iowa, US | |
432521 | 432521 | 2022-11-03 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-11-04 04:22:11 | Adams, Iowa, US | |
850763 | 850763 | 2022-11-02 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-11-03 04:22:05 | Adams, Iowa, US | |
713477 | 713477 | 2022-11-01 | US | Texas | Baylor | 48023 | 905 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-11-02 04:22:09 | Baylor, Texas, US | |
711614 | 711614 | 2022-11-01 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-11-02 04:22:09 | Adams, Iowa, US | |
3287926 | 3287926 | 2022-10-31 | US | Texas | Baylor | 48023 | 905 | 33 | 0 | 33.61640794 | -99.21352901 | 2022-11-01 04:22:36 | Baylor, Texas, US | |
3286063 | 3286063 | 2022-10-31 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-11-01 04:22:36 | Adams, Iowa, US | |
322155 | 322155 | 2022-10-30 | US | New Mexico | Union | 35059 | 905 | 19 | 0 | 36.48126404 | -103.4709624 | 2022-10-31 04:21:36 | Union, New Mexico, US | |
321096 | 321096 | 2022-10-30 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-10-31 04:21:36 | Adams, Iowa, US | |
914431 | 914431 | 2022-10-29 | US | New Mexico | Union | 35059 | 905 | 19 | 0 | 36.48126404 | -103.4709624 | 2022-10-30 04:22:14 | Union, New Mexico, US | |
913372 | 913372 | 2022-10-29 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-10-30 04:22:14 | Adams, Iowa, US | |
1368700 | 1368700 | 2022-10-28 | US | New Mexico | Union | 35059 | 905 | 19 | 0 | 36.48126404 | -103.4709624 | 2022-10-29 04:21:13 | Union, New Mexico, US | |
1367641 | 1367641 | 2022-10-28 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-10-29 04:21:13 | Adams, Iowa, US | |
3040555 | 3040555 | 2022-10-27 | US | New Mexico | Union | 35059 | 905 | 19 | 0 | 36.48126404 | -103.4709624 | 2022-10-28 04:22:31 | Union, New Mexico, US | |
3039496 | 3039496 | 2022-10-27 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-10-28 04:22:31 | Adams, Iowa, US | |
539916 | 539916 | 2022-10-26 | US | Iowa | Adams | 19003 | 905 | 14 | 0 | 41.02903567 | -94.69932645 | 2022-10-27 04:22:01 | Adams, Iowa, US | |
2271732 | 2271732 | 2022-10-20 | China | Shanxi | 905 | 0 | 0 | 37.5777 | 112.2922 | 2022-10-21 04:22:23 | Shanxi, China | |||
1979863 | 1979863 | 2022-09-25 | US | Texas | Upton | 48461 | 905 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-09-26 04:20:52 | Upton, Texas, US | |
2653030 | 2653030 | 2022-09-24 | US | Texas | Upton | 48461 | 905 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-09-25 04:23:31 | Upton, Texas, US | |
387470 | 387470 | 2022-09-23 | US | Texas | Upton | 48461 | 905 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-09-24 04:21:40 | Upton, Texas, US | |
1627536 | 1627536 | 2022-09-22 | US | Texas | Upton | 48461 | 905 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-09-23 04:23:13 | Upton, Texas, US | |
1373740 | 1373740 | 2022-09-21 | US | Texas | Upton | 48461 | 905 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-09-22 04:22:56 | Upton, Texas, US | |
2019970 | 2019970 | 2022-09-20 | US | Texas | Upton | 48461 | 905 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-09-21 04:23:22 | Upton, Texas, US | |
3573843 | 3573843 | 2022-09-19 | US | Texas | Upton | 48461 | 905 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-09-20 04:22:48 | Upton, Texas, US | |
422582 | 422582 | 2022-09-18 | US | Texas | Upton | 48461 | 905 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-09-19 04:21:49 | Upton, Texas, US | |
3376606 | 3376606 | 2022-09-17 | US | Texas | Upton | 48461 | 905 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-09-18 04:22:50 | Upton, Texas, US | |
2358714 | 2358714 | 2022-09-16 | US | Texas | Upton | 48461 | 905 | 18 | 0 | 31.36868194 | -102.0423217 | 2022-09-17 04:20:19 | Upton, Texas, US | |
3953150 | 3953150 | 2022-08-17 | US | Pennsylvania | Cameron | 42023 | 905 | 21 | 0 | 41.43625568 | -78.20376845 | 2022-08-18 04:21:11 | Cameron, Pennsylvania, US | |
2010897 | 2010897 | 2022-08-04 | US | New Mexico | Mora | 35033 | 905 | 20 | 0 | 36.01095101 | -104.9497716 | 2022-08-05 04:20:52 | Mora, New Mexico, US | |
900767 | 900767 | 2022-07-22 | US | Colorado | Baca | 8009 | 905 | 14 | 0 | 37.31940883 | -102.5603223 | 2022-07-23 04:20:53 | Baca, Colorado, US | |
3213486 | 3213486 | 2022-07-18 | US | Texas | Reagan | 48383 | 905 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-07-19 04:20:58 | Reagan, Texas, US | |
3408661 | 3408661 | 2022-07-17 | US | Texas | Reagan | 48383 | 905 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-07-18 04:20:59 | Reagan, Texas, US | |
2154861 | 2154861 | 2022-07-16 | US | Texas | Reagan | 48383 | 905 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-07-17 04:21:15 | Reagan, Texas, US | |
2422094 | 2422094 | 2022-07-15 | US | Texas | Reagan | 48383 | 905 | 14 | 0 | 31.36607041 | -101.5232659 | 2022-07-16 04:21:05 | Reagan, Texas, US | |
3111261 | 3111261 | 2022-07-13 | US | Minnesota | Unassigned | 90027 | 905 | 324 | 0 | 48.77754106 | 0.0 | 2022-07-14 04:20:57 | Unassigned, Minnesota, US | |
631684 | 631684 | 2022-07-12 | US | Minnesota | Unassigned | 90027 | 905 | 324 | 0 | 48.77754106 | 0.0 | 2022-07-13 04:20:58 | Unassigned, Minnesota, US | |
1213328 | 1213328 | 2022-07-11 | US | Minnesota | Unassigned | 90027 | 905 | 324 | 0 | 48.77754106 | 0.0 | 2022-07-12 04:20:51 | Unassigned, Minnesota, US | |
2790810 | 2790810 | 2022-07-10 | US | Minnesota | Unassigned | 90027 | 905 | 324 | 0 | 48.77754106 | 0.0 | 2022-07-11 04:20:46 | Unassigned, Minnesota, US | |
143763 | 143763 | 2022-07-09 | US | Minnesota | Unassigned | 90027 | 905 | 324 | 0 | 48.77754106 | 0.0 | 2022-07-10 04:20:54 | Unassigned, Minnesota, US | |
1418863 | 1418863 | 2022-07-08 | US | Minnesota | Unassigned | 90027 | 905 | 324 | 0 | 48.77754106 | 0.0 | 2022-07-09 04:20:59 | Unassigned, Minnesota, US | |
2742788 | 2742788 | 2022-07-07 | US | Minnesota | Unassigned | 90027 | 905 | 324 | 0 | 48.77754106 | 0.0 | 2022-07-08 04:20:56 | Unassigned, Minnesota, US | |
949611 | 949611 | 2022-06-14 | US | Puerto Rico | Maricao | 72093 | 905 | 0 | 0 | 18.171795 | -66.942126 | 2022-06-15 04:20:54 | Maricao, Puerto Rico, US | |
2982019 | 2982019 | 2022-06-13 | US | Puerto Rico | Maricao | 72093 | 905 | 0 | 0 | 18.171795 | -66.942126 | 2022-06-14 04:20:52 | Maricao, Puerto Rico, US | |
3528114 | 3528114 | 2022-06-04 | US | Colorado | Phillips | 8095 | 905 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-06-05 04:20:55 | Phillips, Colorado, US | |
3134200 | 3134200 | 2022-06-03 | US | Colorado | Phillips | 8095 | 905 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-06-04 04:20:58 | Phillips, Colorado, US | |
3579275 | 3579275 | 2022-06-02 | US | Colorado | Phillips | 8095 | 905 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-06-03 04:20:58 | Phillips, Colorado, US | |
971568 | 971568 | 2022-06-01 | US | Colorado | Phillips | 8095 | 905 | 19 | 0 | 40.59414277 | -102.3577703 | 2022-06-02 05:20:39 | Phillips, Colorado, US | |
1112365 | 1112365 | 2022-05-21 | US | Puerto Rico | Vieques | 72147 | 905 | 0 | 0 | 18.123276 | -65.440971 | 2022-05-22 04:20:52 | Vieques, Puerto Rico, US | |
1169844 | 1169844 | 2022-05-20 | US | Colorado | Ouray | 8091 | 905 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-05-21 04:20:58 | Ouray, Colorado, US | |
3896607 | 3896607 | 2022-05-19 | US | Colorado | Ouray | 8091 | 905 | 6 | 0 | 38.14717457 | -107.7675136 | 2022-05-20 04:20:57 | Ouray, Colorado, US | |
2536703 | 2536703 | 2022-05-12 | US | Virginia | Bath | 51017 | 905 | 20 | 0 | 38.05852573 | -79.73912095 | 2022-05-13 04:20:51 | Bath, Virginia, US | |
465637 | 465637 | 2022-05-02 | US | New York | Hamilton | 36041 | 905 | 5 | 0 | 43.66146647 | -74.49721957 | 2022-05-03 04:21:00 | Hamilton, New York, US | |
3867985 | 3867985 | 2022-04-05 | US | Alaska | Unassigned | 90002 | 905 | 1 | 0 | 69.31479216 | 0.0 | 2022-04-06 04:20:49 | Unassigned, Alaska, US | |
2749327 | 2749327 | 2022-04-04 | US | Alaska | Unassigned | 90002 | 905 | 1 | 0 | 69.31479216 | 0.0 | 2022-04-05 04:20:48 | Unassigned, Alaska, US | |
3730673 | 3730673 | 2022-04-03 | US | Alaska | Unassigned | 90002 | 905 | 1 | 0 | 69.31479216 | 0.0 | 2022-04-04 04:20:51 | Unassigned, Alaska, US | |
500108 | 500108 | 2022-04-02 | US | Alaska | Unassigned | 90002 | 905 | 1 | 0 | 69.31479216 | 0.0 | 2022-04-03 04:20:48 | Unassigned, Alaska, US | |
3351093 | 3351093 | 2022-04-01 | US | Alaska | Unassigned | 90002 | 905 | 1 | 0 | 69.31479216 | 0.0 | 2022-04-02 04:20:47 | Unassigned, Alaska, US | |
1905636 | 1905636 | 2022-03-22 | US | Alaska | Unassigned | 90002 | 905 | 1 | 0 | 69.31479216 | 0.0 | 2022-03-23 04:20:48 | Unassigned, Alaska, US | |
3238767 | 3238767 | 2022-03-21 | US | Alaska | Unassigned | 90002 | 905 | 1 | 0 | 69.31479216 | 0.0 | 2022-03-22 04:20:54 | Unassigned, Alaska, US | |
1868878 | 1868878 | 2022-03-10 | US | Virginia | Rappahannock | 51157 | 905 | 9 | 0 | 38.68295619 | -78.15826963 | 2022-03-11 04:20:50 | Rappahannock, Virginia, US | |
2200560 | 2200560 | 2022-03-06 | US | Idaho | Bear Lake | 16007 | 905 | 15 | 0 | 42.28269683 | -111.32892379999998 | 2022-03-07 04:20:47 | Bear Lake, Idaho, US | |
2093017 | 2093017 | 2022-03-05 | US | Idaho | Bear Lake | 16007 | 905 | 15 | 0 | 42.28269683 | -111.32892379999998 | 2022-03-06 04:20:49 | Bear Lake, Idaho, US | |
2666717 | 2666717 | 2022-03-04 | US | Idaho | Bear Lake | 16007 | 905 | 15 | 0 | 42.28269683 | -111.32892379999998 | 2022-03-05 04:21:10 | Bear Lake, Idaho, US | |
2448789 | 2448789 | 2022-02-22 | US | Montana | Musselshell | 30065 | 905 | 26 | 0 | 46.49684637 | -108.39498 | 2022-02-23 04:21:09 | Musselshell, Montana, US | |
187829 | 187829 | 2022-02-13 | US | Minnesota | Red Lake | 27125 | 905 | 11 | 0 | 47.87197525 | -96.09561104 | 2022-02-14 04:20:51 | Red Lake, Minnesota, US | |
317675 | 317675 | 2022-02-12 | US | Minnesota | Red Lake | 27125 | 905 | 11 | 0 | 47.87197525 | -96.09561104 | 2022-02-13 04:21:00 | Red Lake, Minnesota, US | |
235001 | 235001 | 2022-02-11 | US | Minnesota | Red Lake | 27125 | 905 | 11 | 0 | 47.87197525 | -96.09561104 | 2022-02-12 04:21:06 | Red Lake, Minnesota, US | |
2476823 | 2476823 | 2022-02-03 | US | South Dakota | Edmunds | 46045 | 905 | 16 | 0 | 45.41846445 | -99.21545423 | 2022-02-04 04:21:10 | Edmunds, South Dakota, US | |
979745 | 979745 | 2022-02-01 | US | Georgia | Echols | 13101 | 905 | 11 | 0 | 30.71101099 | -82.89687287 | 2022-02-02 04:21:09 | Echols, Georgia, US | |
2660897 | 2660897 | 2022-01-31 | US | Texas | Hall | 48191 | 905 | 20 | 0 | 34.5307555 | -100.68138520000001 | 2022-02-01 04:21:11 | Hall, Texas, US | |
2659744 | 2659744 | 2022-01-31 | US | Missouri | Putnam | 29171 | 905 | 20 | 0 | 40.47942497 | -93.02042674 | 2022-02-01 04:21:11 | Putnam, Missouri, US | |
3302161 | 3302161 | 2022-01-30 | US | Missouri | Putnam | 29171 | 905 | 20 | 0 | 40.47942497 | -93.02042674 | 2022-01-31 04:21:09 | Putnam, Missouri, US | |
3063952 | 3063952 | 2022-01-29 | US | Missouri | Putnam | 29171 | 905 | 20 | 0 | 40.47942497 | -93.02042674 | 2022-01-30 04:21:26 | Putnam, Missouri, 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]);