johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
59 rows where confirmed = 10729 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
country_or_region 9
- US 44
- India 5
- Spain 3
- Russia 2
- Congo (Kinshasa) 1
- France 1
- Malaysia 1
- Peru 1
- United Kingdom 1
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3276790 | 3276790 | 2022-10-23 | India | Andaman and Nicobar Islands | 10729 | 129 | 0 | 11.225999 | 92.968178 | 2022-10-24 04:22:29 | Andaman and Nicobar Islands, India | |||
2267828 | 2267828 | 2022-10-22 | India | Andaman and Nicobar Islands | 10729 | 129 | 0 | 11.225999 | 92.968178 | 2022-10-23 04:22:46 | Andaman and Nicobar Islands, India | |||
1592128 | 1592128 | 2022-10-21 | India | Andaman and Nicobar Islands | 10729 | 129 | 0 | 11.225999 | 92.968178 | 2022-10-22 04:22:53 | Andaman and Nicobar Islands, India | |||
2271844 | 2271844 | 2022-10-20 | India | Andaman and Nicobar Islands | 10729 | 129 | 0 | 11.225999 | 92.968178 | 2022-10-21 04:22:23 | Andaman and Nicobar Islands, India | |||
198179 | 198179 | 2022-10-19 | India | Andaman and Nicobar Islands | 10729 | 129 | 0 | 11.225999 | 92.968178 | 2022-10-20 04:22:59 | Andaman and Nicobar Islands, India | |||
2829324 | 2829324 | 2022-08-25 | US | Arkansas | Miller | 5091 | 10729 | 185 | 0 | 33.31403423 | -93.89285258 | 2022-08-26 04:21:02 | Miller, Arkansas, US | |
2326861 | 2326861 | 2022-08-24 | US | West Virginia | Randolph | 54083 | 10729 | 93 | 0 | 38.769899 | -79.87919615 | 2022-08-25 04:21:13 | Randolph, West Virginia, US | |
2237218 | 2237218 | 2022-06-12 | US | Mississippi | Neshoba | 28099 | 10729 | 241 | 0 | 32.75339664 | -89.11726492 | 2022-06-13 04:21:14 | Neshoba, Mississippi, US | |
3143416 | 3143416 | 2022-06-11 | US | Mississippi | Neshoba | 28099 | 10729 | 241 | 0 | 32.75339664 | -89.11726492 | 2022-06-12 04:20:53 | Neshoba, Mississippi, US | |
1946332 | 1946332 | 2022-06-10 | US | Mississippi | Neshoba | 28099 | 10729 | 241 | 0 | 32.75339664 | -89.11726492 | 2022-06-11 04:21:01 | Neshoba, Mississippi, US | |
3159471 | 3159471 | 2022-06-09 | US | Mississippi | Neshoba | 28099 | 10729 | 241 | 0 | 32.75339664 | -89.11726492 | 2022-06-10 04:20:55 | Neshoba, Mississippi, US | |
1423574 | 1423574 | 2022-06-08 | US | Ohio | Guernsey | 39059 | 10729 | 156 | 0 | 40.05026529 | -81.49248905 | 2022-06-09 04:20:54 | Guernsey, Ohio, US | |
1422938 | 1422938 | 2022-06-08 | US | Mississippi | Neshoba | 28099 | 10729 | 241 | 0 | 32.75339664 | -89.11726492 | 2022-06-09 04:20:54 | Neshoba, Mississippi, US | |
1422145 | 1422145 | 2022-06-08 | US | Illinois | Randolph | 17157 | 10729 | 127 | 0 | 38.05095369 | -89.82512254 | 2022-06-09 04:20:54 | Randolph, Illinois, US | |
3728688 | 3728688 | 2022-06-07 | US | Ohio | Guernsey | 39059 | 10729 | 156 | 0 | 40.05026529 | -81.49248905 | 2022-06-08 04:20:55 | Guernsey, Ohio, US | |
3728052 | 3728052 | 2022-06-07 | US | Mississippi | Neshoba | 28099 | 10729 | 241 | 0 | 32.75339664 | -89.11726492 | 2022-06-08 04:20:55 | Neshoba, Mississippi, US | |
3890090 | 3890090 | 2022-06-06 | US | Ohio | Guernsey | 39059 | 10729 | 156 | 0 | 40.05026529 | -81.49248905 | 2022-06-07 04:21:08 | Guernsey, Ohio, US | |
3889454 | 3889454 | 2022-06-06 | US | Mississippi | Neshoba | 28099 | 10729 | 241 | 0 | 32.75339664 | -89.11726492 | 2022-06-07 04:21:08 | Neshoba, Mississippi, US | |
3509859 | 3509859 | 2022-06-05 | US | Ohio | Guernsey | 39059 | 10729 | 156 | 0 | 40.05026529 | -81.49248905 | 2022-06-06 04:20:57 | Guernsey, Ohio, US | |
3529936 | 3529936 | 2022-06-04 | US | Ohio | Guernsey | 39059 | 10729 | 156 | 0 | 40.05026529 | -81.49248905 | 2022-06-05 04:20:55 | Guernsey, Ohio, US | |
3136022 | 3136022 | 2022-06-03 | US | Ohio | Guernsey | 39059 | 10729 | 156 | 0 | 40.05026529 | -81.49248905 | 2022-06-04 04:20:58 | Guernsey, Ohio, US | |
3581097 | 3581097 | 2022-06-02 | US | Ohio | Guernsey | 39059 | 10729 | 156 | 0 | 40.05026529 | -81.49248905 | 2022-06-03 04:20:58 | Guernsey, Ohio, US | |
1110561 | 1110561 | 2022-05-21 | US | Illinois | Effingham | 17049 | 10729 | 139 | 0 | 39.05935711 | -88.58969584 | 2022-05-22 04:20:52 | Effingham, Illinois, US | |
1170185 | 1170185 | 2022-05-20 | US | Illinois | Effingham | 17049 | 10729 | 139 | 0 | 39.05935711 | -88.58969584 | 2022-05-21 04:20:58 | Effingham, Illinois, US | |
2751162 | 2751162 | 2022-04-04 | US | New York | Tioga | 36107 | 10729 | 82 | 0 | 42.16852837 | -76.30835812 | 2022-04-05 04:20:48 | Tioga, New York, US | |
696773 | 696773 | 2022-03-17 | US | North Carolina | Yadkin | 37197 | 10729 | 110 | 0 | 36.16222629 | -80.66239436 | 2022-03-18 04:20:55 | Yadkin, North Carolina, US | |
3228976 | 3228976 | 2022-01-19 | US | Ohio | Washington | 39167 | 10729 | 178 | 0 | 39.45690571 | -81.49121382 | 2022-01-20 04:21:07 | Washington, Ohio, US | |
1115868 | 1115868 | 2022-01-11 | US | New York | Warren | 36113 | 10729 | 111 | 0 | 43.56173026 | -73.8433699 | 2022-01-12 04:21:44 | Warren, New York, US | |
1032859 | 1032859 | 2021-12-06 | US | Ohio | Lawrence | 39087 | 10729 | 188 | 0 | 38.59743452 | -82.53466552 | 2021-12-07 04:22:34 | Lawrence, Ohio, US | |
3401789 | 3401789 | 2021-11-30 | US | Alabama | Blount | 1009 | 10729 | 192 | 0 | 33.98210918 | -86.56790593 | 2021-12-01 04:22:29 | Blount, Alabama, US | |
1361309 | 1361309 | 2021-11-27 | US | Tennessee | McMinn | 47107 | 10729 | 137 | 0 | 35.42812616 | -84.61520715 | 2021-11-28 04:22:43 | McMinn, Tennessee, US | |
761300 | 761300 | 2021-11-26 | US | Tennessee | McMinn | 47107 | 10729 | 137 | 0 | 35.42812616 | -84.61520715 | 2021-11-27 04:22:45 | McMinn, Tennessee, US | |
1805680 | 1805680 | 2021-11-25 | US | Tennessee | Dickson | 47043 | 10729 | 166 | 0 | 36.14669837 | -87.35891709 | 2021-11-26 04:22:33 | Dickson, Tennessee, US | |
568565 | 568565 | 2021-10-29 | US | Kentucky | Pike | 21195 | 10729 | 181 | 0 | 37.47088263 | -82.39487445 | 2021-10-30 04:22:03 | Pike, Kentucky, US | |
644433 | 644433 | 2021-09-07 | US | Ohio | Muskingum | 39119 | 10729 | 149 | 0 | 39.96575964 | -81.94363275 | 2021-09-08 04:21:31 | Muskingum, Ohio, US | |
590190 | 590190 | 2021-08-08 | US | California | Napa | 6055 | 10729 | 83 | 0 | 38.50735751 | -122.332839 | 2021-08-09 04:21:24 | Napa, California, US | |
3387787 | 3387787 | 2021-07-29 | US | North Dakota | Grand Forks | 38035 | 10729 | 79 | 0 | 47.92093639 | -97.45450447 | 2021-07-30 04:21:34 | Grand Forks, North Dakota, US | |
403611 | 403611 | 2021-06-29 | US | Virginia | Hampton | 51650 | 10729 | 182 | 0 | 37.03513786 | -76.35879121 | 2021-06-30 04:21:41 | Hampton, Virginia, US | |
563857 | 563857 | 2021-06-22 | US | Georgia | Walton | 13297 | 10729 | 264 | 0 | 33.78017694 | -83.73552314 | 2021-06-23 04:21:46 | Walton, Georgia, US | |
829261 | 829261 | 2021-06-06 | Malaysia | Pahang | 10729 | 61 | 7762 | 2906 | 3.8126 | 103.3256 | 2021-06-07 04:22:51 | Pahang, Malaysia | ||
52686 | 52686 | 2021-05-29 | US | Missouri | Franklin | 29071 | 10729 | 184 | 0 | 38.41127108 | -91.07522826 | 2021-05-30 04:20:55 | Franklin, Missouri, US | |
2940896 | 2940896 | 2021-05-16 | US | Maryland | Charles | 24017 | 10729 | 194 | 0 | 38.51092331 | -76.98580666 | 2021-05-17 04:20:34 | Charles, Maryland, US | |
1553357 | 1553357 | 2021-05-08 | US | Kentucky | Daviess | 21059 | 10729 | 183 | 0 | 37.73028906 | -87.09019479999998 | 2021-05-09 04:20:35 | Daviess, Kentucky, US | |
3646170 | 3646170 | 2021-03-30 | US | Oregon | Lane | 41039 | 10729 | 141 | 0 | 43.93727035 | -122.847753 | 2021-03-31 04:26:25 | Lane, Oregon, US | |
704066 | 704066 | 2021-03-16 | US | Michigan | Muskegon | 26121 | 10729 | 307 | 0 | 43.29123859 | -86.15176712 | 2021-03-17 05:25:07 | Muskegon, Michigan, US | |
2468608 | 2468608 | 2021-01-22 | US | Mississippi | Jackson | 28059 | 10729 | 188 | 0 | 10541 | 30.54020656 | -88.64184064 | 2021-01-23 05:22:03 | Jackson, Mississippi, US |
436140 | 436140 | 2021-01-21 | US | Georgia | Douglas | 13097 | 10729 | 134 | 0 | 10595 | 33.70291126 | -84.77026156 | 2021-01-22 05:22:10 | Douglas, Georgia, US |
1034569 | 1034569 | 2020-12-15 | Russia | Ingushetia Republic | 10729 | 123 | 9095 | 1511 | 43.11542075 | 45.01713552 | 2020-12-16 05:28:04 | Ingushetia Republic, Russia | ||
272048 | 272048 | 2020-11-10 | France | French Guiana | 10729 | 70 | 9995 | 664 | 4.0 | -53.0 | 2020-11-11 05:25:30 | French Guiana, France | ||
1546611 | 1546611 | 2020-11-07 | US | Pennsylvania | Lancaster | 42071 | 10729 | 489 | 0 | 10240 | 40.03904563 | -76.24770128 | 2020-11-08 05:24:56 | Lancaster, Pennsylvania, US |
3782141 | 3782141 | 2020-10-13 | Russia | Sakha (Yakutiya) Republic | 10729 | 106 | 7514 | 3109 | 66.941626 | 129.642371 | 2020-10-14 04:24:05 | Sakha (Yakutiya) Republic, Russia | ||
3389258 | 3389258 | 2020-10-02 | Congo (Kinshasa) | 10729 | 272 | 10183 | 274 | -4.0383 | 21.7587 | 2020-10-03 04:23:40 | Congo (Kinshasa) | |||
2585626 | 2585626 | 2020-09-27 | United Kingdom | Northern Ireland | 10729 | 902 | 0 | 10151 | 54.7877 | -6.4923 | 2020-09-28 04:23:00 | Northern Ireland, United Kingdom | ||
2868996 | 2868996 | 2020-09-13 | Spain | Baleares | 10729 | 258 | 1533 | 8938 | 39.710358 | 2.995148 | 2020-09-14 04:26:00 | Baleares, Spain | ||
547035 | 547035 | 2020-09-12 | Spain | Baleares | 10729 | 258 | 1533 | 8938 | 39.710358 | 2.995148 | 2020-09-13 04:30:52 | Baleares, Spain | ||
1444864 | 1444864 | 2020-09-11 | Spain | Baleares | 10729 | 258 | 1533 | 8938 | 39.710358 | 2.995148 | 2020-09-12 04:25:05 | Baleares, Spain | ||
2172249 | 2172249 | 2020-09-09 | US | Florida | Manatee | 12081 | 10729 | 266 | 0 | 10463 | 27.47196942 | -82.31831044 | 2020-09-10 04:29:01 | Manatee, Florida, US |
61755 | 61755 | 2020-07-23 | Peru | Ancash | 10729 | 1647 | 0 | 9082 | -9.407125 | -77.67179499999997 | 2020-07-24 05:30:40 | Ancash, Peru | ||
2471285 | 2471285 | 2020-04-20 | US | New Jersey | Essex | 34013 | 10729 | 751 | 0 | 9978 | 40.78681335 | -74.24657979 | 2020-04-20 23:36:47 | Essex, New Jersey, 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]);