johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
261 rows where confirmed = 3236 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754678 | 2754678 | 2022-12-29 | US | Minnesota | Stevens | 27149 | 3236 | 16 | 0 | 45.58613007 | -96.00163705 | 2022-12-30 04:21:04 | Stevens, Minnesota, US | |
2139708 | 2139708 | 2022-12-01 | US | Wisconsin | Forest | 55041 | 3236 | 53 | 0 | 45.66678019 | -88.77084892 | 2022-12-02 04:21:07 | Forest, Wisconsin, US | |
1968124 | 1968124 | 2022-11-30 | US | Wisconsin | Forest | 55041 | 3236 | 53 | 0 | 45.66678019 | -88.77084892 | 2022-12-01 04:21:03 | Forest, Wisconsin, US | |
3554989 | 3554989 | 2022-11-27 | US | Virginia | Falls Church | 51610 | 3236 | 20 | 0 | 38.88485255 | -77.17560759 | 2022-11-28 04:21:02 | Falls Church, Virginia, US | |
2103469 | 2103469 | 2022-11-26 | US | Virginia | Falls Church | 51610 | 3236 | 20 | 0 | 38.88485255 | -77.17560759 | 2022-11-27 04:21:05 | Falls Church, Virginia, US | |
490960 | 490960 | 2022-11-25 | US | Virginia | Falls Church | 51610 | 3236 | 20 | 0 | 38.88485255 | -77.17560759 | 2022-11-26 04:21:11 | Falls Church, Virginia, US | |
852926 | 852926 | 2022-11-02 | US | Virginia | Clarke | 51043 | 3236 | 55 | 0 | 39.11271747 | -77.99199425 | 2022-11-03 04:22:05 | Clarke, Virginia, US | |
2275228 | 2275228 | 2022-10-20 | US | Virginia | Amelia | 51007 | 3236 | 60 | 0 | 37.34081025 | -77.98584649 | 2022-10-21 04:22:23 | Amelia, Virginia, US | |
201563 | 201563 | 2022-10-19 | US | Virginia | Amelia | 51007 | 3236 | 60 | 0 | 37.34081025 | -77.98584649 | 2022-10-20 04:22:59 | Amelia, Virginia, US | |
131915 | 131915 | 2022-10-04 | US | Iowa | Appanoose | 19007 | 3236 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-10-05 04:23:06 | Appanoose, Iowa, US | |
2686862 | 2686862 | 2022-10-03 | US | Iowa | Appanoose | 19007 | 3236 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-10-04 04:22:55 | Appanoose, Iowa, US | |
2260929 | 2260929 | 2022-10-02 | US | Iowa | Appanoose | 19007 | 3236 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-10-03 04:23:11 | Appanoose, Iowa, US | |
2260787 | 2260787 | 2022-10-02 | US | Illinois | Marshall | 17123 | 3236 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-10-03 04:23:11 | Marshall, Illinois, US | |
2996455 | 2996455 | 2022-10-01 | US | Iowa | Appanoose | 19007 | 3236 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-10-02 04:21:23 | Appanoose, Iowa, US | |
2996313 | 2996313 | 2022-10-01 | US | Illinois | Marshall | 17123 | 3236 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-10-02 04:21:23 | Marshall, Illinois, US | |
854781 | 854781 | 2022-09-30 | US | Iowa | Appanoose | 19007 | 3236 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-10-01 04:23:01 | Appanoose, Iowa, US | |
854639 | 854639 | 2022-09-30 | US | Illinois | Marshall | 17123 | 3236 | 33 | 0 | 41.0327901 | -89.34510444 | 2022-10-01 04:23:01 | Marshall, Illinois, US | |
2376707 | 2376707 | 2022-09-29 | US | Iowa | Appanoose | 19007 | 3236 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-09-30 04:23:09 | Appanoose, Iowa, US | |
1561258 | 1561258 | 2022-09-28 | US | Iowa | Appanoose | 19007 | 3236 | 72 | 0 | 40.74324454 | -92.86865906 | 2022-09-29 04:22:34 | Appanoose, Iowa, US | |
1372277 | 1372277 | 2022-09-21 | US | Minnesota | Watonwan | 27165 | 3236 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-09-22 04:22:56 | Watonwan, Minnesota, US | |
2018507 | 2018507 | 2022-09-20 | US | Minnesota | Watonwan | 27165 | 3236 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-09-21 04:23:22 | Watonwan, Minnesota, US | |
3572380 | 3572380 | 2022-09-19 | US | Minnesota | Watonwan | 27165 | 3236 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-09-20 04:22:48 | Watonwan, Minnesota, US | |
421119 | 421119 | 2022-09-18 | US | Minnesota | Watonwan | 27165 | 3236 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-09-19 04:21:49 | Watonwan, Minnesota, US | |
3375143 | 3375143 | 2022-09-17 | US | Minnesota | Watonwan | 27165 | 3236 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-09-18 04:22:50 | Watonwan, Minnesota, US | |
2357251 | 2357251 | 2022-09-16 | US | Minnesota | Watonwan | 27165 | 3236 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-09-17 04:20:19 | Watonwan, Minnesota, US | |
3988408 | 3988408 | 2022-09-15 | US | Minnesota | Watonwan | 27165 | 3236 | 24 | 0 | 43.97823903 | -94.61413846 | 2022-09-16 04:21:19 | Watonwan, Minnesota, US | |
1683546 | 1683546 | 2022-08-29 | US | Texas | Camp | 48063 | 3236 | 76 | 0 | 32.97195142 | -94.97790104 | 2022-08-30 04:21:03 | Camp, Texas, US | |
2323951 | 2323951 | 2022-08-24 | US | Colorado | Archuleta | 8007 | 3236 | 17 | 0 | 37.19474156 | -107.0476867 | 2022-08-25 04:21:13 | Archuleta, Colorado, US | |
2405221 | 2405221 | 2022-08-21 | US | North Dakota | Barnes | 38003 | 3236 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-08-22 04:20:38 | Barnes, North Dakota, US | |
3800299 | 3800299 | 2022-08-20 | US | North Dakota | Barnes | 38003 | 3236 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-08-21 04:20:44 | Barnes, North Dakota, US | |
2365885 | 2365885 | 2022-08-19 | US | North Dakota | Barnes | 38003 | 3236 | 47 | 0 | 46.93579637 | -98.06605978 | 2022-08-20 04:21:01 | Barnes, North Dakota, US | |
3953016 | 3953016 | 2022-08-17 | US | Ohio | Vinton | 39163 | 3236 | 57 | 0 | 39.25208988 | -82.4831444 | 2022-08-18 04:21:11 | Vinton, Ohio, US | |
993518 | 993518 | 2022-08-16 | US | Ohio | Vinton | 39163 | 3236 | 57 | 0 | 39.25208988 | -82.4831444 | 2022-08-17 04:20:59 | Vinton, Ohio, US | |
2496557 | 2496557 | 2022-08-15 | US | Ohio | Vinton | 39163 | 3236 | 57 | 0 | 39.25208988 | -82.4831444 | 2022-08-16 04:20:58 | Vinton, Ohio, US | |
3650107 | 3650107 | 2022-08-14 | US | Ohio | Vinton | 39163 | 3236 | 57 | 0 | 39.25208988 | -82.4831444 | 2022-08-15 04:20:59 | Vinton, Ohio, US | |
1971113 | 1971113 | 2022-08-13 | US | Ohio | Vinton | 39163 | 3236 | 57 | 0 | 39.25208988 | -82.4831444 | 2022-08-14 04:20:55 | Vinton, Ohio, US | |
2890922 | 2890922 | 2022-08-12 | US | Ohio | Vinton | 39163 | 3236 | 57 | 0 | 39.25208988 | -82.4831444 | 2022-08-13 04:20:52 | Vinton, Ohio, US | |
3910527 | 3910527 | 2022-08-11 | US | Ohio | Vinton | 39163 | 3236 | 57 | 0 | 39.25208988 | -82.4831444 | 2022-08-12 04:20:54 | Vinton, Ohio, US | |
3543306 | 3543306 | 2022-08-08 | China | Zhejiang | 3236 | 1 | 0 | 29.1832 | 120.0934 | 2022-08-09 04:20:34 | Zhejiang, China | |||
1070425 | 1070425 | 2022-08-07 | US | Arkansas | Stone | 5137 | 3236 | 69 | 0 | 35.86251946 | -92.15684085 | 2022-08-08 04:21:08 | Stone, Arkansas, US | |
1069709 | 1069709 | 2022-08-07 | China | Zhejiang | 3236 | 1 | 0 | 29.1832 | 120.0934 | 2022-08-08 04:21:08 | Zhejiang, China | |||
900811 | 900811 | 2022-07-22 | US | Colorado | Park | 8093 | 3236 | 22 | 0 | 39.120926 | -105.7182065 | 2022-07-23 04:20:53 | Park, Colorado, US | |
1608299 | 1608299 | 2022-07-20 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-21 04:21:10 | Kiribati | ||||
958932 | 958932 | 2022-07-19 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-20 04:20:59 | Kiribati | ||||
3210319 | 3210319 | 2022-07-18 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-19 04:20:58 | Kiribati | ||||
3405494 | 3405494 | 2022-07-17 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-18 04:20:59 | Kiribati | ||||
2151694 | 2151694 | 2022-07-16 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-17 04:21:15 | Kiribati | ||||
2418927 | 2418927 | 2022-07-15 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-16 04:21:05 | Kiribati | ||||
3429002 | 3429002 | 2022-07-14 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-15 04:20:53 | Kiribati | ||||
3109522 | 3109522 | 2022-07-13 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-14 04:20:57 | Kiribati | ||||
629945 | 629945 | 2022-07-12 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-13 04:20:58 | Kiribati | ||||
1211589 | 1211589 | 2022-07-11 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-12 04:20:51 | Kiribati | ||||
2789071 | 2789071 | 2022-07-10 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-11 04:20:46 | Kiribati | ||||
142024 | 142024 | 2022-07-09 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-10 04:20:54 | Kiribati | ||||
1417124 | 1417124 | 2022-07-08 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-09 04:20:59 | Kiribati | ||||
2741049 | 2741049 | 2022-07-07 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-08 04:20:56 | Kiribati | ||||
1199844 | 1199844 | 2022-07-06 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-07 04:20:55 | Kiribati | ||||
3966587 | 3966587 | 2022-07-05 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-06 04:20:58 | Kiribati | ||||
3078098 | 3078098 | 2022-07-04 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-05 04:20:45 | Kiribati | ||||
1767380 | 1767380 | 2022-07-03 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-04 04:20:54 | Kiribati | ||||
3365366 | 3365366 | 2022-07-02 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-03 04:20:59 | Kiribati | ||||
593695 | 593695 | 2022-07-01 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-02 04:21:16 | Kiribati | ||||
3940700 | 3940700 | 2022-06-30 | US | Colorado | Moffat | 8081 | 3236 | 53 | 0 | 40.61810999 | -108.2070876 | 2022-07-01 04:21:10 | Moffat, Colorado, US | |
3940096 | 3940096 | 2022-06-30 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-07-01 04:21:10 | Kiribati | ||||
2490054 | 2490054 | 2022-06-29 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-06-30 04:21:01 | Kiribati | ||||
2239436 | 2239436 | 2022-06-28 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-06-29 04:20:59 | Kiribati | ||||
2147678 | 2147678 | 2022-06-27 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-06-28 04:20:58 | Kiribati | ||||
475479 | 475479 | 2022-06-26 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-06-27 04:21:00 | Kiribati | ||||
938854 | 938854 | 2022-06-25 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-06-26 04:21:02 | Kiribati | ||||
3346674 | 3346674 | 2022-06-24 | Kiribati | 3236 | 13 | 0 | -3.3704 | -168.734 | 2022-06-25 04:20:57 | Kiribati | ||||
3530187 | 3530187 | 2022-06-04 | US | Puerto Rico | Arroyo | 72015 | 3236 | 0 | 0 | 17.998457 | -66.056546 | 2022-06-05 04:20:55 | Arroyo, Puerto Rico, US | |
1572992 | 1572992 | 2022-05-03 | US | Georgia | Oglethorpe | 13221 | 3236 | 56 | 0 | 33.8786296 | -83.08278123 | 2022-05-04 04:20:59 | Oglethorpe, Georgia, US | |
464252 | 464252 | 2022-05-02 | US | Georgia | Oglethorpe | 13221 | 3236 | 56 | 0 | 33.8786296 | -83.08278123 | 2022-05-03 04:21:00 | Oglethorpe, Georgia, US | |
3916891 | 3916891 | 2022-05-01 | US | Georgia | Oglethorpe | 13221 | 3236 | 56 | 0 | 33.8786296 | -83.08278123 | 2022-05-02 04:21:10 | Oglethorpe, Georgia, US | |
2841695 | 2841695 | 2022-04-30 | US | Georgia | Oglethorpe | 13221 | 3236 | 56 | 0 | 33.8786296 | -83.08278123 | 2022-05-01 04:20:57 | Oglethorpe, Georgia, US | |
1158008 | 1158008 | 2022-04-29 | US | Georgia | Oglethorpe | 13221 | 3236 | 56 | 0 | 33.8786296 | -83.08278123 | 2022-04-30 04:21:05 | Oglethorpe, Georgia, US | |
1697190 | 1697190 | 2022-04-28 | US | Georgia | Oglethorpe | 13221 | 3236 | 56 | 0 | 33.8786296 | -83.08278123 | 2022-04-29 04:20:59 | Oglethorpe, Georgia, US | |
3852673 | 3852673 | 2022-04-27 | US | Georgia | Oglethorpe | 13221 | 3236 | 56 | 0 | 33.8786296 | -83.08278123 | 2022-04-28 04:20:47 | Oglethorpe, Georgia, US | |
2254212 | 2254212 | 2022-04-19 | US | Puerto Rico | Utuado | 72141 | 3236 | 0 | 0 | 18.271214 | -66.702984 | 2022-04-20 04:20:45 | Utuado, Puerto Rico, US | |
2803192 | 2803192 | 2022-04-06 | US | North Dakota | Mountrail | 38061 | 3236 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-04-07 04:20:53 | Mountrail, North Dakota, US | |
3869961 | 3869961 | 2022-04-05 | US | North Dakota | Mountrail | 38061 | 3236 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-04-06 04:20:49 | Mountrail, North Dakota, US | |
2751303 | 2751303 | 2022-04-04 | US | North Dakota | Mountrail | 38061 | 3236 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-04-05 04:20:48 | Mountrail, North Dakota, US | |
3732649 | 3732649 | 2022-04-03 | US | North Dakota | Mountrail | 38061 | 3236 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-04-04 04:20:51 | Mountrail, North Dakota, US | |
502084 | 502084 | 2022-04-02 | US | North Dakota | Mountrail | 38061 | 3236 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-04-03 04:20:48 | Mountrail, North Dakota, US | |
3353069 | 3353069 | 2022-04-01 | US | North Dakota | Mountrail | 38061 | 3236 | 37 | 0 | 48.20197971 | -102.3555315 | 2022-04-02 04:20:47 | Mountrail, North Dakota, US | |
1908621 | 1908621 | 2022-03-22 | US | Virginia | Westmoreland | 51193 | 3236 | 50 | 0 | 38.11021557 | -76.80213247 | 2022-03-23 04:20:48 | Westmoreland, Virginia, US | |
3241752 | 3241752 | 2022-03-21 | US | Virginia | Westmoreland | 51193 | 3236 | 50 | 0 | 38.11021557 | -76.80213247 | 2022-03-22 04:20:54 | Westmoreland, Virginia, US | |
2321744 | 2321744 | 2022-03-16 | US | North Dakota | McKenzie | 38053 | 3236 | 25 | 0 | 47.74133370000001 | -103.395905 | 2022-03-17 04:20:56 | McKenzie, North Dakota, US | |
263944 | 263944 | 2022-03-15 | US | North Dakota | McKenzie | 38053 | 3236 | 25 | 0 | 47.74133370000001 | -103.395905 | 2022-03-16 04:20:50 | McKenzie, North Dakota, US | |
2266303 | 2266303 | 2022-03-14 | US | North Dakota | McKenzie | 38053 | 3236 | 25 | 0 | 47.74133370000001 | -103.395905 | 2022-03-15 04:20:47 | McKenzie, North Dakota, US | |
1549871 | 1549871 | 2022-03-07 | US | Missouri | Dent | 29065 | 3236 | 74 | 0 | 37.60663134 | -91.50790473 | 2022-03-08 04:20:54 | Dent, Missouri, US | |
1646389 | 1646389 | 2022-03-03 | US | Montana | Roosevelt | 30085 | 3236 | 71 | 0 | 48.29607488 | -105.00792679999999 | 2022-03-04 04:21:09 | Roosevelt, Montana, US | |
1645999 | 1645999 | 2022-03-03 | US | Michigan | Gogebic | 26053 | 3236 | 67 | 0 | 46.40862701 | -89.69377193 | 2022-03-04 04:21:09 | Gogebic, Michigan, US | |
2527002 | 2527002 | 2022-03-02 | US | Michigan | Gogebic | 26053 | 3236 | 67 | 0 | 46.40862701 | -89.69377193 | 2022-03-03 04:21:01 | Gogebic, Michigan, US | |
2735369 | 2735369 | 2022-02-27 | US | North Carolina | Mitchell | 37121 | 3236 | 33 | 0 | 36.01059309 | -82.1582442 | 2022-02-28 04:21:05 | Mitchell, North Carolina, US | |
3048522 | 3048522 | 2022-02-26 | US | North Carolina | Mitchell | 37121 | 3236 | 33 | 0 | 36.01059309 | -82.1582442 | 2022-02-27 04:21:04 | Mitchell, North Carolina, US | |
577177 | 577177 | 2022-02-25 | US | North Carolina | Mitchell | 37121 | 3236 | 33 | 0 | 36.01059309 | -82.1582442 | 2022-02-26 04:21:12 | Mitchell, North Carolina, US | |
1513906 | 1513906 | 2022-02-24 | US | Ohio | Morgan | 39115 | 3236 | 56 | 0 | 39.62081738 | -81.85308173 | 2022-02-25 04:21:11 | Morgan, Ohio, US | |
3858552 | 3858552 | 2022-02-18 | US | Puerto Rico | Anasco | 72011 | 3236 | 0 | 0 | 18.287985 | -67.120611 | 2022-02-19 04:21:11 | Anasco, Puerto Rico, US | |
1299571 | 1299571 | 2022-02-17 | US | Louisiana | Madison | 22065 | 3236 | 58 | 0 | 32.36918118 | -91.23973355 | 2022-02-18 04:21:04 | Madison, Louisiana, 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]);