johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
94,151 rows where province_or_state = "Indiana" sorted by latitude descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
Suggested facets: day (date), last_update (date)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▲ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1470 | 1470 | 2021-12-02 | US | Indiana | Steuben | 18151 | 6658 | 89 | 0 | 41.64423868 | -85.00101094 | 2021-12-03 04:23:05 | Steuben, Indiana, US | |
1475 | 1475 | 2021-12-02 | US | Indiana | Unassigned | 90018 | 0 | 592 | 0 | 41.64423868 | 0.0 | 2021-12-03 04:23:05 | Unassigned, Indiana, US | |
5485 | 5485 | 2021-10-28 | US | Indiana | Steuben | 18151 | 5750 | 77 | 0 | 41.64423868 | -85.00101094 | 2021-10-29 04:22:03 | Steuben, Indiana, US | |
5490 | 5490 | 2021-10-28 | US | Indiana | Unassigned | 90018 | 0 | 549 | 0 | 41.64423868 | 0.0 | 2021-10-29 04:22:03 | Unassigned, Indiana, US | |
9458 | 9458 | 2020-10-25 | US | Indiana | Steuben | 18151 | 657 | 8 | 0 | 649 | 41.64423868 | -85.00101094 | 2020-10-26 04:25:02 | Steuben, Indiana, US |
9463 | 9463 | 2020-10-25 | US | Indiana | Unassigned | 90018 | 0 | 89 | 0 | 0 | 41.64423868 | 0.0 | 2020-10-26 04:25:02 | Unassigned, Indiana, US |
13470 | 13470 | 2021-01-26 | US | Indiana | Steuben | 18151 | 3158 | 53 | 0 | 3105 | 41.64423868 | -85.00101094 | 2021-01-27 05:23:41 | Steuben, Indiana, US |
13475 | 13475 | 2021-01-26 | US | Indiana | Unassigned | 90018 | 0 | 152 | 0 | 0 | 41.64423868 | 0.0 | 2021-01-27 05:23:41 | Unassigned, Indiana, US |
17492 | 17492 | 2021-09-18 | US | Indiana | Steuben | 18151 | 4882 | 67 | 0 | 41.64423868 | -85.00101094 | 2021-09-19 04:21:34 | Steuben, Indiana, US | |
17497 | 17497 | 2021-09-18 | US | Indiana | Unassigned | 90018 | 0 | 468 | 0 | 41.64423868 | 0.0 | 2021-09-19 04:21:34 | Unassigned, Indiana, US | |
21503 | 21503 | 2021-05-28 | US | Indiana | Steuben | 18151 | 3946 | 58 | 0 | 41.64423868 | -85.00101094 | 2021-05-29 04:20:41 | Steuben, Indiana, US | |
21508 | 21508 | 2021-05-28 | US | Indiana | Unassigned | 90018 | 0 | 417 | 0 | 41.64423868 | 0.0 | 2021-05-29 04:20:41 | Unassigned, Indiana, US | |
25541 | 25541 | 2022-03-20 | US | Indiana | Steuben | 18151 | 9610 | 116 | 0 | 41.64423868 | -85.00101094 | 2022-03-21 04:20:50 | Steuben, Indiana, US | |
25546 | 25546 | 2022-03-20 | US | Indiana | Unassigned | 90018 | 0 | 912 | 0 | 41.64423868 | 0.0 | 2022-03-21 04:20:50 | Unassigned, Indiana, US | |
29556 | 29556 | 2021-11-11 | US | Indiana | Steuben | 18151 | 6002 | 79 | 0 | 41.64423868 | -85.00101094 | 2021-11-12 04:22:01 | Steuben, Indiana, US | |
29561 | 29561 | 2021-11-11 | US | Indiana | Unassigned | 90018 | 0 | 566 | 0 | 41.64423868 | 0.0 | 2021-11-12 04:22:01 | Unassigned, Indiana, US | |
33552 | 33552 | 2021-08-25 | US | Indiana | Steuben | 18151 | 4443 | 64 | 0 | 41.64423868 | -85.00101094 | 2021-08-26 04:21:28 | Steuben, Indiana, US | |
33557 | 33557 | 2021-08-25 | US | Indiana | Unassigned | 90018 | 0 | 437 | 0 | 41.64423868 | 0.0 | 2021-08-26 04:21:28 | Unassigned, Indiana, US | |
37562 | 37562 | 2021-04-12 | US | Indiana | Steuben | 18151 | 3601 | 57 | 0 | 41.64423868 | -85.00101094 | 2021-04-13 04:20:37 | Steuben, Indiana, US | |
37567 | 37567 | 2021-04-12 | US | Indiana | Unassigned | 90018 | 0 | 405 | 0 | 41.64423868 | 0.0 | 2021-04-13 04:20:37 | Unassigned, Indiana, US | |
42642 | 42642 | 2020-04-13 | US | Indiana | Steuben | 18151 | 12 | 1 | 0 | 11 | 41.64423868 | -85.00101094 | 2020-04-13 23:07:54 | Steuben, Indiana, US |
42786 | 42786 | 2020-04-13 | US | Indiana | Unassigned | 90018 | 0 | 133 | 0 | 0 | 41.64423868 | 0.0 | 2020-04-13 23:07:54 | Unassigned, Indiana, US |
44848 | 44848 | 2021-11-02 | US | Indiana | Steuben | 18151 | 5818 | 78 | 0 | 41.64423868 | -85.00101094 | 2021-11-03 06:22:09 | Steuben, Indiana, US | |
44853 | 44853 | 2021-11-02 | US | Indiana | Unassigned | 90018 | 0 | 553 | 0 | 41.64423868 | 0.0 | 2021-11-03 06:22:09 | Unassigned, Indiana, US | |
49734 | 49734 | 2020-04-17 | US | Indiana | Steuben | 18151 | 16 | 1 | 0 | 15 | 41.64423868 | -85.00101094 | 2020-04-17 23:30:52 | Steuben, Indiana, US |
49879 | 49879 | 2020-04-17 | US | Indiana | Unassigned | 90018 | 0 | 115 | 0 | 0 | 41.64423868 | 0.0 | 2020-04-17 23:30:52 | Unassigned, Indiana, US |
51924 | 51924 | 2021-05-29 | US | Indiana | Steuben | 18151 | 3946 | 59 | 0 | 41.64423868 | -85.00101094 | 2021-05-30 04:20:55 | Steuben, Indiana, US | |
51929 | 51929 | 2021-05-29 | US | Indiana | Unassigned | 90018 | 0 | 417 | 0 | 41.64423868 | 0.0 | 2021-05-30 04:20:55 | Unassigned, Indiana, US | |
55935 | 55935 | 2021-03-07 | US | Indiana | Steuben | 18151 | 3404 | 55 | 0 | 41.64423868 | -85.00101094 | 2021-03-08 05:24:48 | Steuben, Indiana, US | |
55940 | 55940 | 2021-03-07 | US | Indiana | Unassigned | 90018 | 0 | 427 | 0 | 41.64423868 | 0.0 | 2021-03-08 05:24:48 | Unassigned, Indiana, US | |
61237 | 61237 | 2020-07-23 | US | Indiana | Steuben | 18151 | 168 | 3 | 0 | 165 | 41.64423868 | -85.00101094 | 2020-07-24 05:30:40 | Steuben, Indiana, US |
61408 | 61408 | 2020-07-23 | US | Indiana | Unassigned | 90018 | 0 | 17 | 0 | 0 | 41.64423868 | 0.0 | 2020-07-24 05:30:40 | Unassigned, Indiana, US |
64206 | 64206 | 2022-11-12 | US | Indiana | Steuben | 18151 | 10930 | 122 | 0 | 41.64423868 | -85.00101094 | 2022-11-13 04:21:14 | Steuben, Indiana, US | |
64211 | 64211 | 2022-11-12 | US | Indiana | Unassigned | 90018 | 0 | 175 | 0 | 41.64423868 | 0.0 | 2022-11-13 04:21:14 | Unassigned, Indiana, US | |
68197 | 68197 | 2021-09-01 | US | Indiana | Steuben | 18151 | 4554 | 64 | 0 | 41.64423868 | -85.00101094 | 2021-09-02 04:21:15 | Steuben, Indiana, US | |
68202 | 68202 | 2021-09-01 | US | Indiana | Unassigned | 90018 | 0 | 442 | 0 | 41.64423868 | 0.0 | 2021-09-02 04:21:15 | Unassigned, Indiana, US | |
72231 | 72231 | 2022-02-07 | US | Indiana | Steuben | 18151 | 9447 | 110 | 0 | 41.64423868 | -85.00101094 | 2022-02-08 04:21:15 | Steuben, Indiana, US | |
72236 | 72236 | 2022-02-07 | US | Indiana | Unassigned | 90018 | 0 | 828 | 0 | 41.64423868 | 0.0 | 2022-02-08 04:21:15 | Unassigned, Indiana, US | |
76218 | 76218 | 2020-12-03 | US | Indiana | Steuben | 18151 | 1686 | 18 | 0 | 1668 | 41.64423868 | -85.00101094 | 2020-12-04 05:27:27 | Steuben, Indiana, US |
76223 | 76223 | 2020-12-03 | US | Indiana | Unassigned | 90018 | 0 | 269 | 0 | 0 | 41.64423868 | 0.0 | 2020-12-04 05:27:27 | Unassigned, Indiana, US |
80212 | 80212 | 2020-10-14 | US | Indiana | Steuben | 18151 | 536 | 9 | 0 | 527 | 41.64423868 | -85.00101094 | 2020-10-15 04:24:28 | Steuben, Indiana, US |
80217 | 80217 | 2020-10-14 | US | Indiana | Unassigned | 90018 | 0 | 79 | 0 | 0 | 41.64423868 | 0.0 | 2020-10-15 04:24:28 | Unassigned, Indiana, US |
84227 | 84227 | 2021-05-25 | US | Indiana | Steuben | 18151 | 3940 | 57 | 0 | 41.64423868 | -85.00101094 | 2021-05-26 04:20:35 | Steuben, Indiana, US | |
84232 | 84232 | 2021-05-25 | US | Indiana | Unassigned | 90018 | 0 | 417 | 0 | 41.64423868 | 0.0 | 2021-05-26 04:20:35 | Unassigned, Indiana, US | |
88265 | 88265 | 2021-11-09 | US | Indiana | Steuben | 18151 | 5949 | 79 | 0 | 41.64423868 | -85.00101094 | 2021-11-10 04:21:38 | Steuben, Indiana, US | |
88270 | 88270 | 2021-11-09 | US | Indiana | Unassigned | 90018 | 0 | 562 | 0 | 41.64423868 | 0.0 | 2021-11-10 04:21:38 | Unassigned, Indiana, US | |
92283 | 92283 | 2022-07-23 | US | Indiana | Steuben | 18151 | 10142 | 122 | 0 | 41.64423868 | -85.00101094 | 2022-07-24 04:20:47 | Steuben, Indiana, US | |
92288 | 92288 | 2022-07-23 | US | Indiana | Unassigned | 90018 | 0 | 66 | 0 | 41.64423868 | 0.0 | 2022-07-24 04:20:47 | Unassigned, Indiana, US | |
97567 | 97567 | 2020-08-04 | US | Indiana | Steuben | 18151 | 201 | 3 | 0 | 198 | 41.64423868 | -85.00101094 | 2020-08-05 04:34:43 | Steuben, Indiana, US |
97738 | 97738 | 2020-08-04 | US | Indiana | Unassigned | 90018 | 0 | 19 | 0 | 0 | 41.64423868 | 0.0 | 2020-08-05 04:34:43 | Unassigned, Indiana, US |
100466 | 100466 | 2022-01-14 | US | Indiana | Steuben | 18151 | 8145 | 101 | 0 | 41.64423868 | -85.00101094 | 2022-01-15 04:21:07 | Steuben, Indiana, US | |
100471 | 100471 | 2022-01-14 | US | Indiana | Unassigned | 90018 | 0 | 735 | 0 | 41.64423868 | 0.0 | 2022-01-15 04:21:07 | Unassigned, Indiana, US | |
104462 | 104462 | 2021-08-15 | US | Indiana | Steuben | 18151 | 4237 | 62 | 0 | 41.64423868 | -85.00101094 | 2021-08-16 04:21:31 | Steuben, Indiana, US | |
104467 | 104467 | 2021-08-15 | US | Indiana | Unassigned | 90018 | 0 | 430 | 0 | 41.64423868 | 0.0 | 2021-08-16 04:21:31 | Unassigned, Indiana, US | |
108586 | 108586 | 2021-06-19 | US | Indiana | Steuben | 18151 | 4001 | 59 | 0 | 41.64423868 | -85.00101094 | 2021-06-20 04:21:48 | Steuben, Indiana, US | |
108591 | 108591 | 2021-06-19 | US | Indiana | Unassigned | 90018 | 0 | 420 | 0 | 41.64423868 | 0.0 | 2021-06-20 04:21:48 | Unassigned, Indiana, US | |
113643 | 113643 | 2020-05-08 | US | Indiana | Steuben | 18151 | 63 | 1 | 0 | 62 | 41.64423868 | -85.00101094 | 2020-05-09 02:32:35 | Steuben, Indiana, US |
113797 | 113797 | 2020-05-08 | US | Indiana | Unassigned | 90018 | 0 | 113 | 0 | 0 | 41.64423868 | 0.0 | 2020-05-09 02:32:35 | Unassigned, Indiana, US |
115893 | 115893 | 2022-09-06 | US | Indiana | Steuben | 18151 | 10645 | 122 | 0 | 41.64423868 | -85.00101094 | 2022-09-07 04:20:59 | Steuben, Indiana, US | |
115898 | 115898 | 2022-09-06 | US | Indiana | Unassigned | 90018 | 0 | 107 | 0 | 41.64423868 | 0.0 | 2022-09-07 04:20:59 | Unassigned, Indiana, US | |
121161 | 121161 | 2020-07-19 | US | Indiana | Steuben | 18151 | 152 | 3 | 0 | 149 | 41.64423868 | -85.00101094 | 2020-07-20 05:34:40 | Steuben, Indiana, US |
121332 | 121332 | 2020-07-19 | US | Indiana | Unassigned | 90018 | 0 | 26 | 0 | 0 | 41.64423868 | 0.0 | 2020-07-20 05:34:40 | Unassigned, Indiana, US |
123833 | 123833 | 2020-11-18 | US | Indiana | Steuben | 18151 | 1233 | 14 | 0 | 1219 | 41.64423868 | -85.00101094 | 2020-11-19 05:25:23 | Steuben, Indiana, US |
123838 | 123838 | 2020-11-18 | US | Indiana | Unassigned | 90018 | 0 | 166 | 0 | 0 | 41.64423868 | 0.0 | 2020-11-19 05:25:23 | Unassigned, Indiana, US |
127873 | 127873 | 2022-01-09 | US | Indiana | Steuben | 18151 | 7765 | 98 | 0 | 41.64423868 | -85.00101094 | 2022-01-10 04:22:07 | Steuben, Indiana, US | |
127878 | 127878 | 2022-01-09 | US | Indiana | Unassigned | 90018 | 0 | 655 | 0 | 41.64423868 | 0.0 | 2022-01-10 04:22:07 | Unassigned, Indiana, US | |
131894 | 131894 | 2022-10-04 | US | Indiana | Steuben | 18151 | 10755 | 122 | 0 | 41.64423868 | -85.00101094 | 2022-10-05 04:23:06 | Steuben, Indiana, US | |
131899 | 131899 | 2022-10-04 | US | Indiana | Unassigned | 90018 | 0 | 134 | 0 | 41.64423868 | 0.0 | 2022-10-05 04:23:06 | Unassigned, Indiana, US | |
136876 | 136876 | 2020-04-29 | US | Indiana | Steuben | 18151 | 22 | 1 | 0 | 21 | 41.64423868 | -85.00101094 | 2020-04-30 02:32:27 | Steuben, Indiana, US |
137025 | 137025 | 2020-04-29 | US | Indiana | Unassigned | 90018 | 0 | 143 | 0 | 0 | 41.64423868 | 0.0 | 2020-04-30 02:32:27 | Unassigned, Indiana, US |
139111 | 139111 | 2021-12-04 | US | Indiana | Steuben | 18151 | 6690 | 89 | 0 | 41.64423868 | -85.00101094 | 2021-12-05 04:22:25 | Steuben, Indiana, US | |
139116 | 139116 | 2021-12-04 | US | Indiana | Unassigned | 90018 | 0 | 595 | 0 | 41.64423868 | 0.0 | 2021-12-05 04:22:25 | Unassigned, Indiana, US | |
143129 | 143129 | 2022-07-09 | US | Indiana | Steuben | 18151 | 9988 | 122 | 0 | 41.64423868 | -85.00101094 | 2022-07-10 04:20:54 | Steuben, Indiana, US | |
143134 | 143134 | 2022-07-09 | US | Indiana | Unassigned | 90018 | 0 | 58 | 0 | 41.64423868 | 0.0 | 2022-07-10 04:20:54 | Unassigned, Indiana, US | |
147094 | 147094 | 2020-08-15 | US | Indiana | Steuben | 18151 | 222 | 3 | 0 | 219 | 41.64423868 | -85.00101094 | 2020-08-16 04:27:42 | Steuben, Indiana, US |
147099 | 147099 | 2020-08-15 | US | Indiana | Unassigned | 90018 | 0 | 20 | 0 | 0 | 41.64423868 | 0.0 | 2020-08-16 04:27:42 | Unassigned, Indiana, US |
151124 | 151124 | 2021-11-29 | US | Indiana | Steuben | 18151 | 6541 | 86 | 0 | 41.64423868 | -85.00101094 | 2021-11-30 04:22:53 | Steuben, Indiana, US | |
151129 | 151129 | 2021-11-29 | US | Indiana | Unassigned | 90018 | 0 | 585 | 0 | 41.64423868 | 0.0 | 2021-11-30 04:22:53 | Unassigned, Indiana, US | |
155112 | 155112 | 2021-01-08 | US | Indiana | Steuben | 18151 | 2889 | 40 | 0 | 2849 | 41.64423868 | -85.00101094 | 2021-01-09 05:22:18 | Steuben, Indiana, US |
155117 | 155117 | 2021-01-08 | US | Indiana | Unassigned | 90018 | 0 | 187 | 0 | 0 | 41.64423868 | 0.0 | 2021-01-09 05:22:18 | Unassigned, Indiana, US |
159153 | 159153 | 2022-03-29 | US | Indiana | Steuben | 18151 | 9614 | 116 | 0 | 41.64423868 | -85.00101094 | 2022-03-30 04:20:45 | Steuben, Indiana, US | |
159158 | 159158 | 2022-03-29 | US | Indiana | Unassigned | 90018 | 0 | 923 | 0 | 41.64423868 | 0.0 | 2022-03-30 04:20:45 | Unassigned, Indiana, US | |
163168 | 163168 | 2021-11-19 | US | Indiana | Steuben | 18151 | 6273 | 84 | 0 | 41.64423868 | -85.00101094 | 2021-11-20 04:22:17 | Steuben, Indiana, US | |
163173 | 163173 | 2021-11-19 | US | Indiana | Unassigned | 90018 | 0 | 574 | 0 | 41.64423868 | 0.0 | 2021-11-20 04:22:17 | Unassigned, Indiana, US | |
167186 | 167186 | 2022-06-21 | US | Indiana | Steuben | 18151 | 9869 | 122 | 0 | 41.64423868 | -85.00101094 | 2022-06-22 04:20:54 | Steuben, Indiana, US | |
167191 | 167191 | 2022-06-21 | US | Indiana | Unassigned | 90018 | 0 | 49 | 0 | 41.64423868 | 0.0 | 2022-06-22 04:20:54 | Unassigned, Indiana, US | |
171176 | 171176 | 2021-04-16 | US | Indiana | Steuben | 18151 | 3633 | 57 | 0 | 41.64423868 | -85.00101094 | 2021-04-17 04:20:40 | Steuben, Indiana, US | |
171181 | 171181 | 2021-04-16 | US | Indiana | Unassigned | 90018 | 0 | 408 | 0 | 41.64423868 | 0.0 | 2021-04-17 04:20:40 | Unassigned, Indiana, US | |
176477 | 176477 | 2020-07-27 | US | Indiana | Steuben | 18151 | 186 | 3 | 0 | 183 | 41.64423868 | -85.00101094 | 2020-07-28 04:58:43 | Steuben, Indiana, US |
176648 | 176648 | 2020-07-27 | US | Indiana | Unassigned | 90018 | 0 | 21 | 0 | 0 | 41.64423868 | 0.0 | 2020-07-28 04:58:43 | Unassigned, Indiana, US |
179162 | 179162 | 2021-09-02 | US | Indiana | Steuben | 18151 | 4578 | 64 | 0 | 41.64423868 | -85.00101094 | 2021-09-03 04:21:20 | Steuben, Indiana, US | |
179167 | 179167 | 2021-09-02 | US | Indiana | Unassigned | 90018 | 0 | 444 | 0 | 41.64423868 | 0.0 | 2021-09-03 04:21:20 | Unassigned, Indiana, US | |
183170 | 183170 | 2021-02-21 | US | Indiana | Steuben | 18151 | 3349 | 55 | 0 | 3294 | 41.64423868 | -85.00101094 | 2021-02-22 05:24:21 | Steuben, Indiana, US |
183175 | 183175 | 2021-02-21 | US | Indiana | Unassigned | 90018 | 0 | 425 | 0 | 0 | 41.64423868 | 0.0 | 2021-02-22 05:24:21 | Unassigned, Indiana, US |
187211 | 187211 | 2022-02-13 | US | Indiana | Steuben | 18151 | 9521 | 111 | 0 | 41.64423868 | -85.00101094 | 2022-02-14 04:20:51 | Steuben, Indiana, US | |
187216 | 187216 | 2022-02-13 | US | Indiana | Unassigned | 90018 | 0 | 838 | 0 | 41.64423868 | 0.0 | 2022-02-14 04:20:51 | Unassigned, Indiana, US | |
191198 | 191198 | 2021-01-11 | US | Indiana | Steuben | 18151 | 2956 | 43 | 0 | 2913 | 41.64423868 | -85.00101094 | 2021-01-12 05:22:15 | Steuben, Indiana, US |
191203 | 191203 | 2021-01-11 | US | Indiana | Unassigned | 90018 | 0 | 218 | 0 | 0 | 41.64423868 | 0.0 | 2021-01-12 05:22:15 | Unassigned, Indiana, US |
195190 | 195190 | 2020-08-31 | US | Indiana | Steuben | 18151 | 279 | 4 | 0 | 275 | 41.64423868 | -85.00101094 | 2020-09-01 04:28:31 | Steuben, Indiana, US |
195195 | 195195 | 2020-08-31 | US | Indiana | Unassigned | 90018 | 0 | 35 | 0 | 0 | 41.64423868 | 0.0 | 2020-09-01 04:28:31 | Unassigned, Indiana, 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]);