daily_reports (view)
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
94,151 rows where province_or_state = "Indiana" sorted by deaths
This data as json, yaml, Notebook, copyable, CSV (advanced)
day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths ▼ | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|
2020-05-08 | US | Indiana | Knox | 18083 | 20 | 0 | 0 | 20 | 38.68861576 | -87.4194665 | 2020-05-09 02:32:35 | Knox, Indiana, US |
2020-05-08 | US | Indiana | Martin | 18101 | 7 | 0 | 0 | 7 | 38.7099921 | -86.80373186 | 2020-05-09 02:32:35 | Martin, Indiana, US |
2020-05-08 | US | Indiana | Ohio | 18115 | 7 | 0 | 0 | 7 | 38.955305 | -84.96515993 | 2020-05-09 02:32:35 | Ohio, Indiana, US |
2020-05-08 | US | Indiana | Parke | 18121 | 14 | 0 | 0 | 14 | 39.77202286 | -87.20375833 | 2020-05-09 02:32:35 | Parke, Indiana, US |
2020-05-08 | US | Indiana | Perry | 18123 | 14 | 0 | 0 | 14 | 38.07809328 | -86.63741946 | 2020-05-09 02:32:35 | Perry, Indiana, US |
2020-05-08 | US | Indiana | Pike | 18125 | 2 | 0 | 0 | 2 | 38.40112197 | -87.23574907 | 2020-05-09 02:32:35 | Pike, Indiana, US |
2020-05-08 | US | Indiana | Posey | 18129 | 15 | 0 | 0 | 15 | 38.02097333 | -87.86480429 | 2020-05-09 02:32:35 | Posey, Indiana, US |
2020-05-08 | US | Indiana | Pulaski | 18131 | 33 | 0 | 0 | 33 | 41.04166107 | -86.69890683 | 2020-05-09 02:32:35 | Pulaski, Indiana, US |
2020-05-08 | US | Indiana | Sullivan | 18153 | 19 | 0 | 0 | 19 | 39.08952258 | -87.41414469 | 2020-05-09 02:32:35 | Sullivan, Indiana, US |
2020-05-08 | US | Indiana | Switzerland | 18155 | 15 | 0 | 0 | 15 | 38.82767338 | -85.03022429 | 2020-05-09 02:32:35 | Switzerland, Indiana, US |
2020-05-08 | US | Indiana | Union | 18161 | 8 | 0 | 0 | 8 | 39.62550777 | -84.92497066 | 2020-05-09 02:32:35 | Union, Indiana, US |
2020-05-08 | US | Indiana | Vermillion | 18165 | 7 | 0 | 0 | 7 | 39.8523352 | -87.46160542 | 2020-05-09 02:32:35 | Vermillion, Indiana, US |
2020-05-08 | US | Indiana | Wells | 18179 | 9 | 0 | 0 | 9 | 40.72934187 | -85.22132966 | 2020-05-09 02:32:35 | Wells, Indiana, US |
2020-07-19 | US | Indiana | Benton | 18007 | 53 | 0 | 0 | 53 | 40.60626947 | -87.31093999 | 2020-07-20 05:34:40 | Benton, Indiana, US |
2020-07-19 | US | Indiana | Crawford | 18025 | 36 | 0 | 0 | 36 | 38.28814402 | -86.44518825 | 2020-07-20 05:34:40 | Crawford, Indiana, US |
2020-07-19 | US | Indiana | Jay | 18075 | 73 | 0 | 0 | 73 | 40.43781032 | -85.00576229 | 2020-07-20 05:34:40 | Jay, Indiana, US |
2020-07-19 | US | Indiana | Knox | 18083 | 83 | 0 | 0 | 83 | 38.68861576 | -87.4194665 | 2020-07-20 05:34:40 | Knox, Indiana, US |
2020-07-19 | US | Indiana | Martin | 18101 | 34 | 0 | 0 | 34 | 38.7099921 | -86.80373186 | 2020-07-20 05:34:40 | Martin, Indiana, US |
2020-07-19 | US | Indiana | Parke | 18121 | 32 | 0 | 0 | 32 | 39.77202286 | -87.20375833 | 2020-07-20 05:34:40 | Parke, Indiana, US |
2020-07-19 | US | Indiana | Pike | 18125 | 19 | 0 | 0 | 19 | 38.40112197 | -87.23574907 | 2020-07-20 05:34:40 | Pike, Indiana, US |
2020-07-19 | US | Indiana | Posey | 18129 | 102 | 0 | 0 | 102 | 38.02097333 | -87.86480429 | 2020-07-20 05:34:40 | Posey, Indiana, US |
2020-07-19 | US | Indiana | Switzerland | 18155 | 35 | 0 | 0 | 35 | 38.82767338 | -85.03022429 | 2020-07-20 05:34:40 | Switzerland, Indiana, US |
2020-07-19 | US | Indiana | Union | 18161 | 17 | 0 | 0 | 17 | 39.62550777 | -84.92497066 | 2020-07-20 05:34:40 | Union, Indiana, US |
2020-07-19 | US | Indiana | Vermillion | 18165 | 20 | 0 | 0 | 20 | 39.8523352 | -87.46160542 | 2020-07-20 05:34:40 | Vermillion, Indiana, US |
2020-04-29 | US | Indiana | Benton | 18007 | 8 | 0 | 0 | 8 | 40.60626947 | -87.31093999 | 2020-04-30 02:32:27 | Benton, Indiana, US |
2020-04-29 | US | Indiana | Crawford | 18025 | 18 | 0 | 0 | 18 | 38.28814402 | -86.44518825 | 2020-04-30 02:32:27 | Crawford, Indiana, US |
2020-04-29 | US | Indiana | Dubois | 18037 | 21 | 0 | 0 | 21 | 38.36597551 | -86.87924170000002 | 2020-04-30 02:32:27 | Dubois, Indiana, US |
2020-04-29 | US | Indiana | Fulton | 18049 | 26 | 0 | 0 | 26 | 41.0469907 | -86.26252745 | 2020-04-30 02:32:27 | Fulton, Indiana, US |
2020-04-29 | US | Indiana | Gibson | 18051 | 6 | 0 | 0 | 6 | 38.30393723 | -87.58054938 | 2020-04-30 02:32:27 | Gibson, Indiana, US |
2020-04-29 | US | Indiana | Jay | 18075 | 14 | 0 | 0 | 14 | 40.43781032 | -85.00576229 | 2020-04-30 02:32:27 | Jay, Indiana, US |
2020-04-29 | US | Indiana | Jefferson | 18077 | 26 | 0 | 0 | 26 | 38.78576239 | -85.43633383 | 2020-04-30 02:32:27 | Jefferson, Indiana, US |
2020-04-29 | US | Indiana | Knox | 18083 | 20 | 0 | 0 | 20 | 38.68861576 | -87.4194665 | 2020-04-30 02:32:27 | Knox, Indiana, US |
2020-04-29 | US | Indiana | Martin | 18101 | 7 | 0 | 0 | 7 | 38.7099921 | -86.80373186 | 2020-04-30 02:32:27 | Martin, Indiana, US |
2020-04-29 | US | Indiana | Miami | 18103 | 100 | 0 | 0 | 100 | 40.76940965 | -86.04525048 | 2020-04-30 02:32:27 | Miami, Indiana, US |
2020-04-29 | US | Indiana | Montgomery | 18107 | 40 | 0 | 0 | 40 | 40.04034823 | -86.89335024 | 2020-04-30 02:32:27 | Montgomery, Indiana, US |
2020-04-29 | US | Indiana | Ohio | 18115 | 4 | 0 | 0 | 4 | 38.955304999999996 | -84.96515993 | 2020-04-30 02:32:27 | Ohio, Indiana, US |
2020-04-29 | US | Indiana | Parke | 18121 | 12 | 0 | 0 | 12 | 39.77202286 | -87.20375833 | 2020-04-30 02:32:27 | Parke, Indiana, US |
2020-04-29 | US | Indiana | Perry | 18123 | 10 | 0 | 0 | 10 | 38.07809328 | -86.63741946 | 2020-04-30 02:32:27 | Perry, Indiana, US |
2020-04-29 | US | Indiana | Pike | 18125 | 1 | 0 | 0 | 1 | 38.40112197 | -87.23574907 | 2020-04-30 02:32:27 | Pike, Indiana, US |
2020-04-29 | US | Indiana | Posey | 18129 | 9 | 0 | 0 | 9 | 38.02097333 | -87.86480429 | 2020-04-30 02:32:27 | Posey, Indiana, US |
2020-04-29 | US | Indiana | Pulaski | 18131 | 23 | 0 | 0 | 23 | 41.04166107 | -86.69890683 | 2020-04-30 02:32:27 | Pulaski, Indiana, US |
2020-04-29 | US | Indiana | Spencer | 18147 | 5 | 0 | 0 | 5 | 38.01519732 | -87.0079644 | 2020-04-30 02:32:27 | Spencer, Indiana, US |
2020-04-29 | US | Indiana | Sullivan | 18153 | 16 | 0 | 0 | 16 | 39.08952258 | -87.41414469 | 2020-04-30 02:32:27 | Sullivan, Indiana, US |
2020-04-29 | US | Indiana | Switzerland | 18155 | 15 | 0 | 0 | 15 | 38.82767338 | -85.03022429 | 2020-04-30 02:32:27 | Switzerland, Indiana, US |
2020-04-29 | US | Indiana | Union | 18161 | 7 | 0 | 0 | 7 | 39.62550777 | -84.92497066 | 2020-04-30 02:32:27 | Union, Indiana, US |
2020-04-29 | US | Indiana | Vermillion | 18165 | 7 | 0 | 0 | 7 | 39.8523352 | -87.46160542 | 2020-04-30 02:32:27 | Vermillion, Indiana, US |
2020-04-29 | US | Indiana | Washington | 18175 | 41 | 0 | 0 | 41 | 38.60219804 | -86.1049363 | 2020-04-30 02:32:27 | Washington, Indiana, US |
2020-04-29 | US | Indiana | Wells | 18179 | 5 | 0 | 0 | 5 | 40.72934187 | -85.22132966 | 2020-04-30 02:32:27 | Wells, Indiana, US |
2020-04-29 | US | Indiana | White | 18181 | 43 | 0 | 0 | 43 | 40.74911165 | -86.86492015 | 2020-04-30 02:32:27 | White, Indiana, US |
2020-08-15 | US | Indiana | Benton | 18007 | 68 | 0 | 0 | 68 | 40.60626947 | -87.31093999 | 2020-08-16 04:27:42 | Benton, Indiana, US |
2020-08-15 | US | Indiana | Crawford | 18025 | 52 | 0 | 0 | 52 | 38.28814402 | -86.44518825 | 2020-08-16 04:27:42 | Crawford, Indiana, US |
2020-08-15 | US | Indiana | Jay | 18075 | 99 | 0 | 0 | 99 | 40.43781032 | -85.00576229 | 2020-08-16 04:27:42 | Jay, Indiana, US |
2020-08-15 | US | Indiana | Martin | 18101 | 54 | 0 | 0 | 54 | 38.7099921 | -86.80373186 | 2020-08-16 04:27:42 | Martin, Indiana, US |
2020-08-15 | US | Indiana | Pike | 18125 | 73 | 0 | 0 | 73 | 38.40112197 | -87.23574907 | 2020-08-16 04:27:42 | Pike, Indiana, US |
2020-08-15 | US | Indiana | Posey | 18129 | 186 | 0 | 0 | 186 | 38.02097333 | -87.86480429 | 2020-08-16 04:27:42 | Posey, Indiana, US |
2020-08-15 | US | Indiana | Switzerland | 18155 | 59 | 0 | 0 | 59 | 38.82767338 | -85.03022429 | 2020-08-16 04:27:42 | Switzerland, Indiana, US |
2020-08-15 | US | Indiana | Union | 18161 | 42 | 0 | 0 | 42 | 39.62550777 | -84.92497066 | 2020-08-16 04:27:42 | Union, Indiana, US |
2020-08-15 | US | Indiana | Vermillion | 18165 | 64 | 0 | 0 | 64 | 39.8523352 | -87.46160542 | 2020-08-16 04:27:42 | Vermillion, Indiana, US |
2020-07-27 | US | Indiana | Benton | 18007 | 56 | 0 | 0 | 56 | 40.60626947 | -87.31093999 | 2020-07-28 04:58:43 | Benton, Indiana, US |
2020-07-27 | US | Indiana | Crawford | 18025 | 40 | 0 | 0 | 40 | 38.28814402 | -86.44518825 | 2020-07-28 04:58:43 | Crawford, Indiana, US |
2020-07-27 | US | Indiana | Jay | 18075 | 75 | 0 | 0 | 75 | 40.43781032 | -85.00576229 | 2020-07-28 04:58:43 | Jay, Indiana, US |
2020-07-27 | US | Indiana | Knox | 18083 | 107 | 0 | 0 | 107 | 38.68861576 | -87.4194665 | 2020-07-28 04:58:43 | Knox, Indiana, US |
2020-07-27 | US | Indiana | Martin | 18101 | 39 | 0 | 0 | 39 | 38.7099921 | -86.80373186 | 2020-07-28 04:58:43 | Martin, Indiana, US |
2020-07-27 | US | Indiana | Parke | 18121 | 38 | 0 | 0 | 38 | 39.77202286 | -87.20375833 | 2020-07-28 04:58:43 | Parke, Indiana, US |
2020-07-27 | US | Indiana | Pike | 18125 | 26 | 0 | 0 | 26 | 38.40112197 | -87.23574907 | 2020-07-28 04:58:43 | Pike, Indiana, US |
2020-07-27 | US | Indiana | Posey | 18129 | 145 | 0 | 0 | 145 | 38.02097333 | -87.86480429 | 2020-07-28 04:58:43 | Posey, Indiana, US |
2020-07-27 | US | Indiana | Switzerland | 18155 | 38 | 0 | 0 | 38 | 38.82767338 | -85.03022429 | 2020-07-28 04:58:43 | Switzerland, Indiana, US |
2020-07-27 | US | Indiana | Union | 18161 | 24 | 0 | 0 | 24 | 39.62550777 | -84.92497066 | 2020-07-28 04:58:43 | Union, Indiana, US |
2020-07-27 | US | Indiana | Vermillion | 18165 | 22 | 0 | 0 | 22 | 39.8523352 | -87.46160542 | 2020-07-28 04:58:43 | Vermillion, Indiana, US |
2020-08-31 | US | Indiana | Benton | 18007 | 80 | 0 | 0 | 80 | 40.60626947 | -87.31093999 | 2020-09-01 04:28:31 | Benton, Indiana, US |
2020-08-31 | US | Indiana | Crawford | 18025 | 64 | 0 | 0 | 64 | 38.28814402 | -86.44518825 | 2020-09-01 04:28:31 | Crawford, Indiana, US |
2020-08-31 | US | Indiana | Jay | 18075 | 129 | 0 | 0 | 129 | 40.43781032 | -85.00576229 | 2020-09-01 04:28:31 | Jay, Indiana, US |
2020-08-31 | US | Indiana | Martin | 18101 | 117 | 0 | 0 | 117 | 38.7099921 | -86.80373186 | 2020-09-01 04:28:31 | Martin, Indiana, US |
2020-08-31 | US | Indiana | Posey | 18129 | 214 | 0 | 0 | 214 | 38.02097333 | -87.86480429 | 2020-09-01 04:28:31 | Posey, Indiana, US |
2020-08-31 | US | Indiana | Switzerland | 18155 | 64 | 0 | 0 | 64 | 38.82767338 | -85.03022429 | 2020-09-01 04:28:31 | Switzerland, Indiana, US |
2020-08-31 | US | Indiana | Union | 18161 | 63 | 0 | 0 | 63 | 39.62550777 | -84.92497066 | 2020-09-01 04:28:31 | Union, Indiana, US |
2020-08-31 | US | Indiana | Vermillion | 18165 | 94 | 0 | 0 | 94 | 39.8523352 | -87.46160542 | 2020-09-01 04:28:31 | Vermillion, Indiana, US |
2020-08-19 | US | Indiana | Benton | 18007 | 72 | 0 | 0 | 72 | 40.60626947 | -87.31093999 | 2020-08-20 04:27:43 | Benton, Indiana, US |
2020-08-19 | US | Indiana | Crawford | 18025 | 52 | 0 | 0 | 52 | 38.28814402 | -86.44518825 | 2020-08-20 04:27:43 | Crawford, Indiana, US |
2020-08-19 | US | Indiana | Jay | 18075 | 104 | 0 | 0 | 104 | 40.43781032 | -85.00576229 | 2020-08-20 04:27:43 | Jay, Indiana, US |
2020-08-19 | US | Indiana | Martin | 18101 | 56 | 0 | 0 | 56 | 38.7099921 | -86.80373186 | 2020-08-20 04:27:43 | Martin, Indiana, US |
2020-08-19 | US | Indiana | Pike | 18125 | 77 | 0 | 0 | 77 | 38.40112197 | -87.23574907 | 2020-08-20 04:27:43 | Pike, Indiana, US |
2020-08-19 | US | Indiana | Posey | 18129 | 192 | 0 | 0 | 192 | 38.02097333 | -87.86480429 | 2020-08-20 04:27:43 | Posey, Indiana, US |
2020-08-19 | US | Indiana | Switzerland | 18155 | 62 | 0 | 0 | 62 | 38.82767338 | -85.03022429 | 2020-08-20 04:27:43 | Switzerland, Indiana, US |
2020-08-19 | US | Indiana | Union | 18161 | 48 | 0 | 0 | 48 | 39.62550777 | -84.92497066 | 2020-08-20 04:27:43 | Union, Indiana, US |
2020-08-19 | US | Indiana | Vermillion | 18165 | 68 | 0 | 0 | 68 | 39.8523352 | -87.46160542 | 2020-08-20 04:27:43 | Vermillion, Indiana, US |
2020-10-29 | US | Indiana | Benton | 18007 | 116 | 0 | 0 | 116 | 40.60626947 | -87.31093999 | 2020-10-30 04:24:49 | Benton, Indiana, US |
2020-10-29 | US | Indiana | Martin | 18101 | 207 | 0 | 0 | 207 | 38.7099921 | -86.80373186 | 2020-10-30 04:24:49 | Martin, Indiana, US |
2020-10-29 | US | Indiana | Switzerland | 18155 | 107 | 0 | 0 | 107 | 38.82767338 | -85.03022429 | 2020-10-30 04:24:49 | Switzerland, Indiana, US |
2020-10-29 | US | Indiana | Union | 18161 | 128 | 0 | 0 | 128 | 39.62550777 | -84.92497066 | 2020-10-30 04:24:49 | Union, Indiana, US |
2020-06-08 | US | Indiana | Benton | 18007 | 33 | 0 | 0 | 33 | 40.60626947 | -87.31093999 | 2020-06-09 03:33:03 | Benton, Indiana, US |
2020-06-08 | US | Indiana | Crawford | 18025 | 27 | 0 | 0 | 27 | 38.28814402 | -86.44518825 | 2020-06-09 03:33:03 | Crawford, Indiana, US |
2020-06-08 | US | Indiana | Jay | 18075 | 59 | 0 | 0 | 59 | 40.43781032 | -85.00576229 | 2020-06-09 03:33:03 | Jay, Indiana, US |
2020-06-08 | US | Indiana | Knox | 18083 | 33 | 0 | 0 | 33 | 38.68861576 | -87.4194665 | 2020-06-09 03:33:03 | Knox, Indiana, US |
2020-06-08 | US | Indiana | Martin | 18101 | 15 | 0 | 0 | 15 | 38.7099921 | -86.80373186 | 2020-06-09 03:33:03 | Martin, Indiana, US |
2020-06-08 | US | Indiana | Ohio | 18115 | 13 | 0 | 0 | 13 | 38.955305 | -84.96515993 | 2020-06-09 03:33:03 | Ohio, Indiana, US |
2020-06-08 | US | Indiana | Parke | 18121 | 19 | 0 | 0 | 19 | 39.77202286 | -87.20375833 | 2020-06-09 03:33:03 | Parke, Indiana, US |
2020-06-08 | US | Indiana | Pike | 18125 | 6 | 0 | 0 | 6 | 38.40112197 | -87.23574907 | 2020-06-09 03:33:03 | Pike, Indiana, US |
2020-06-08 | US | Indiana | Posey | 18129 | 16 | 0 | 0 | 16 | 38.02097333 | -87.86480429 | 2020-06-09 03:33:03 | Posey, Indiana, US |
2020-06-08 | US | Indiana | Switzerland | 18155 | 21 | 0 | 0 | 21 | 38.82767338 | -85.03022429 | 2020-06-09 03:33:03 | Switzerland, Indiana, US |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW daily_reports AS select * from johns_hopkins_csse_daily_reports;