johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
186 rows where "last_update" is on date 2022-04-13 and province_or_state = "Indiana" sorted by latitude
This data as json, yaml, Notebook, copyable, CSV (advanced)
Link | rowid | day | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude ▼ | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1949651 | 1949651 | 2022-04-12 | US | Indiana | Spencer | 18147 | 5217 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-04-13 04:21:03 | Spencer, Indiana, US | |
2443894 | 2443894 | 2022-04-13 | US | Indiana | Spencer | 18147 | 5219 | 61 | 0 | 38.01519732 | -87.0079644 | 2022-04-13 23:21:06 | Spencer, Indiana, US | |
1949643 | 1949643 | 2022-04-12 | US | Indiana | Posey | 18129 | 6534 | 58 | 0 | 38.02097333 | -87.86480429 | 2022-04-13 04:21:03 | Posey, Indiana, US | |
2443886 | 2443886 | 2022-04-13 | US | Indiana | Posey | 18129 | 6534 | 58 | 0 | 38.02097333 | -87.86480429 | 2022-04-13 23:21:06 | Posey, Indiana, US | |
1949661 | 1949661 | 2022-04-12 | US | Indiana | Vanderburgh | 18163 | 57270 | 629 | 0 | 38.02658833 | -87.58763124 | 2022-04-13 04:21:03 | Vanderburgh, Indiana, US | |
2443904 | 2443904 | 2022-04-13 | US | Indiana | Vanderburgh | 18163 | 57278 | 629 | 0 | 38.02658833 | -87.58763124 | 2022-04-13 23:21:06 | Vanderburgh, Indiana, US | |
1949640 | 1949640 | 2022-04-12 | US | Indiana | Perry | 18123 | 4650 | 68 | 0 | 38.07809328 | -86.63741946 | 2022-04-13 04:21:03 | Perry, Indiana, US | |
2443883 | 2443883 | 2022-04-13 | US | Indiana | Perry | 18123 | 4650 | 69 | 0 | 38.07809328 | -86.63741946 | 2022-04-13 23:21:06 | Perry, Indiana, US | |
1949666 | 1949666 | 2022-04-12 | US | Indiana | Warrick | 18173 | 20263 | 238 | 0 | 38.08922676 | -87.2716085 | 2022-04-13 04:21:03 | Warrick, Indiana, US | |
2443909 | 2443909 | 2022-04-13 | US | Indiana | Warrick | 18173 | 20267 | 238 | 0 | 38.08922676 | -87.2716085 | 2022-04-13 23:21:06 | Warrick, Indiana, US | |
1949609 | 1949609 | 2022-04-12 | US | Indiana | Harrison | 18061 | 10809 | 138 | 0 | 38.19467379 | -86.10948271 | 2022-04-13 04:21:03 | Harrison, Indiana, US | |
2443852 | 2443852 | 2022-04-13 | US | Indiana | Harrison | 18061 | 10811 | 138 | 0 | 38.19467379 | -86.10948271 | 2022-04-13 23:21:06 | Harrison, Indiana, US | |
1949591 | 1949591 | 2022-04-12 | US | Indiana | Crawford | 18025 | 2547 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-04-13 04:21:03 | Crawford, Indiana, US | |
2443834 | 2443834 | 2022-04-13 | US | Indiana | Crawford | 18025 | 2548 | 40 | 0 | 38.28814402 | -86.44518825 | 2022-04-13 23:21:06 | Crawford, Indiana, US | |
1949604 | 1949604 | 2022-04-12 | US | Indiana | Gibson | 18051 | 11633 | 145 | 0 | 38.30393723 | -87.58054938 | 2022-04-13 04:21:03 | Gibson, Indiana, US | |
2443847 | 2443847 | 2022-04-13 | US | Indiana | Gibson | 18051 | 11633 | 145 | 0 | 38.30393723 | -87.58054938 | 2022-04-13 23:21:06 | Gibson, Indiana, US | |
1949600 | 1949600 | 2022-04-12 | US | Indiana | Floyd | 18043 | 18925 | 299 | 0 | 38.32117957 | -85.90385377 | 2022-04-13 04:21:03 | Floyd, Indiana, US | |
2443843 | 2443843 | 2022-04-13 | US | Indiana | Floyd | 18043 | 18936 | 299 | 0 | 38.32117957 | -85.90385377 | 2022-04-13 23:21:06 | Floyd, Indiana, US | |
1949597 | 1949597 | 2022-04-12 | US | Indiana | Dubois | 18037 | 12859 | 165 | 0 | 38.36597551 | -86.87924170000002 | 2022-04-13 04:21:03 | Dubois, Indiana, US | |
2443840 | 2443840 | 2022-04-13 | US | Indiana | Dubois | 18037 | 12859 | 165 | 0 | 38.36597551 | -86.87924170000002 | 2022-04-13 23:21:06 | Dubois, Indiana, US | |
1949641 | 1949641 | 2022-04-12 | US | Indiana | Pike | 18125 | 3724 | 49 | 0 | 38.40112197 | -87.23574907 | 2022-04-13 04:21:03 | Pike, Indiana, US | |
2443884 | 2443884 | 2022-04-13 | US | Indiana | Pike | 18125 | 3724 | 49 | 0 | 38.40112197 | -87.23574907 | 2022-04-13 23:21:06 | Pike, Indiana, US | |
1949588 | 1949588 | 2022-04-12 | US | Indiana | Clark | 18019 | 31074 | 396 | 0 | 38.48015445 | -85.70510334 | 2022-04-13 04:21:03 | Clark, Indiana, US | |
2443831 | 2443831 | 2022-04-13 | US | Indiana | Clark | 18019 | 31086 | 396 | 0 | 38.48015445 | -85.70510334 | 2022-04-13 23:21:06 | Clark, Indiana, US | |
1949637 | 1949637 | 2022-04-12 | US | Indiana | Orange | 18117 | 5032 | 96 | 0 | 38.54118920000001 | -86.49523093 | 2022-04-13 04:21:03 | Orange, Indiana, US | |
2443880 | 2443880 | 2022-04-13 | US | Indiana | Orange | 18117 | 5032 | 96 | 0 | 38.54118920000001 | -86.49523093 | 2022-04-13 23:21:06 | Orange, Indiana, US | |
1949667 | 1949667 | 2022-04-12 | US | Indiana | Washington | 18175 | 5994 | 82 | 0 | 38.60219804 | -86.1049363 | 2022-04-13 04:21:03 | Washington, Indiana, US | |
2443910 | 2443910 | 2022-04-13 | US | Indiana | Washington | 18175 | 5994 | 83 | 0 | 38.60219804 | -86.1049363 | 2022-04-13 23:21:06 | Washington, Indiana, US | |
1949649 | 1949649 | 2022-04-12 | US | Indiana | Scott | 18143 | 7858 | 106 | 0 | 38.68672078 | -85.74627859 | 2022-04-13 04:21:03 | Scott, Indiana, US | |
2443892 | 2443892 | 2022-04-13 | US | Indiana | Scott | 18143 | 7858 | 106 | 0 | 38.68672078 | -85.74627859 | 2022-04-13 23:21:06 | Scott, Indiana, US | |
1949620 | 1949620 | 2022-04-12 | US | Indiana | Knox | 18083 | 10741 | 153 | 0 | 38.68861576 | -87.4194665 | 2022-04-13 04:21:03 | Knox, Indiana, US | |
2443863 | 2443863 | 2022-04-13 | US | Indiana | Knox | 18083 | 10743 | 153 | 0 | 38.68861576 | -87.4194665 | 2022-04-13 23:21:06 | Knox, Indiana, US | |
1949592 | 1949592 | 2022-04-12 | US | Indiana | Daviess | 18027 | 7469 | 153 | 0 | 38.70186039 | -87.07185406 | 2022-04-13 04:21:03 | Daviess, Indiana, US | |
2443835 | 2443835 | 2022-04-13 | US | Indiana | Daviess | 18027 | 7469 | 153 | 0 | 38.70186039 | -87.07185406 | 2022-04-13 23:21:06 | Daviess, Indiana, US | |
1949629 | 1949629 | 2022-04-12 | US | Indiana | Martin | 18101 | 2163 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-04-13 04:21:03 | Martin, Indiana, US | |
2443872 | 2443872 | 2022-04-13 | US | Indiana | Martin | 18101 | 2163 | 25 | 0 | 38.7099921 | -86.80373186 | 2022-04-13 23:21:06 | Martin, Indiana, US | |
1949617 | 1949617 | 2022-04-12 | US | Indiana | Jefferson | 18077 | 9339 | 157 | 0 | 38.78576239 | -85.43633383 | 2022-04-13 04:21:03 | Jefferson, Indiana, US | |
2443860 | 2443860 | 2022-04-13 | US | Indiana | Jefferson | 18077 | 9341 | 157 | 0 | 38.78576239 | -85.43633383 | 2022-04-13 23:21:06 | Jefferson, Indiana, US | |
1949656 | 1949656 | 2022-04-12 | US | Indiana | Switzerland | 18155 | 2311 | 20 | 0 | 38.82767338 | -85.03022429 | 2022-04-13 04:21:03 | Switzerland, Indiana, US | |
2443899 | 2443899 | 2022-04-13 | US | Indiana | Switzerland | 18155 | 2311 | 20 | 0 | 38.82767338 | -85.03022429 | 2022-04-13 23:21:06 | Switzerland, Indiana, US | |
1949625 | 1949625 | 2022-04-12 | US | Indiana | Lawrence | 18093 | 11849 | 259 | 0 | 38.84112637 | -86.48361629 | 2022-04-13 04:21:03 | Lawrence, Indiana, US | |
2443868 | 2443868 | 2022-04-13 | US | Indiana | Lawrence | 18093 | 11853 | 259 | 0 | 38.84112637 | -86.48361629 | 2022-04-13 23:21:06 | Lawrence, Indiana, US | |
1949614 | 1949614 | 2022-04-12 | US | Indiana | Jackson | 18071 | 12515 | 130 | 0 | 38.90915820000001 | -86.03851889 | 2022-04-13 04:21:03 | Jackson, Indiana, US | |
2443857 | 2443857 | 2022-04-13 | US | Indiana | Jackson | 18071 | 12516 | 130 | 0 | 38.90915820000001 | -86.03851889 | 2022-04-13 23:21:06 | Jackson, Indiana, US | |
1949636 | 1949636 | 2022-04-12 | US | Indiana | Ohio | 18115 | 1443 | 19 | 0 | 38.955304999999996 | -84.96515993 | 2022-04-13 04:21:03 | Ohio, Indiana, US | |
2443879 | 2443879 | 2022-04-13 | US | Indiana | Ohio | 18115 | 1444 | 19 | 0 | 38.955304999999996 | -84.96515993 | 2022-04-13 23:21:06 | Ohio, Indiana, US | |
1949618 | 1949618 | 2022-04-12 | US | Indiana | Jennings | 18079 | 6935 | 108 | 0 | 38.99588883 | -85.62710784 | 2022-04-13 04:21:03 | Jennings, Indiana, US | |
2443861 | 2443861 | 2022-04-13 | US | Indiana | Jennings | 18079 | 6935 | 108 | 0 | 38.99588883 | -85.62710784 | 2022-04-13 23:21:06 | Jennings, Indiana, US | |
1949606 | 1949606 | 2022-04-12 | US | Indiana | Greene | 18055 | 7199 | 139 | 0 | 39.03630547 | -86.96223202 | 2022-04-13 04:21:03 | Greene, Indiana, US | |
2443849 | 2443849 | 2022-04-13 | US | Indiana | Greene | 18055 | 7199 | 139 | 0 | 39.03630547 | -86.96223202 | 2022-04-13 23:21:06 | Greene, Indiana, US | |
1949655 | 1949655 | 2022-04-12 | US | Indiana | Sullivan | 18153 | 5270 | 76 | 0 | 39.08952258 | -87.41414469 | 2022-04-13 04:21:03 | Sullivan, Indiana, US | |
2443898 | 2443898 | 2022-04-13 | US | Indiana | Sullivan | 18153 | 5271 | 76 | 0 | 39.08952258 | -87.41414469 | 2022-04-13 23:21:06 | Sullivan, Indiana, US | |
1949647 | 1949647 | 2022-04-12 | US | Indiana | Ripley | 18137 | 8287 | 138 | 0 | 39.10235626 | -85.26212744 | 2022-04-13 04:21:03 | Ripley, Indiana, US | |
2443890 | 2443890 | 2022-04-13 | US | Indiana | Ripley | 18137 | 8289 | 138 | 0 | 39.10235626 | -85.26212744 | 2022-04-13 23:21:06 | Ripley, Indiana, US | |
1949594 | 1949594 | 2022-04-12 | US | Indiana | Dearborn | 18029 | 13425 | 139 | 0 | 39.14647946 | -84.97333539 | 2022-04-13 04:21:03 | Dearborn, Indiana, US | |
2443837 | 2443837 | 2022-04-13 | US | Indiana | Dearborn | 18029 | 13430 | 140 | 0 | 39.14647946 | -84.97333539 | 2022-04-13 23:21:06 | Dearborn, Indiana, US | |
1949631 | 1949631 | 2022-04-12 | US | Indiana | Monroe | 18105 | 27711 | 279 | 0 | 39.16130004 | -86.52414358 | 2022-04-13 04:21:03 | Monroe, Indiana, US | |
2443874 | 2443874 | 2022-04-13 | US | Indiana | Monroe | 18105 | 27733 | 279 | 0 | 39.16130004 | -86.52414358 | 2022-04-13 23:21:06 | Monroe, Indiana, US | |
1949585 | 1949585 | 2022-04-12 | US | Indiana | Brown | 18013 | 2586 | 62 | 0 | 39.19605589 | -86.22868909 | 2022-04-13 04:21:03 | Brown, Indiana, US | |
2443828 | 2443828 | 2022-04-13 | US | Indiana | Brown | 18013 | 2586 | 62 | 0 | 39.19605589 | -86.22868909 | 2022-04-13 23:21:06 | Brown, Indiana, US | |
1949581 | 1949581 | 2022-04-12 | US | Indiana | Bartholomew | 18005 | 21318 | 249 | 0 | 39.20744865 | -85.89558181 | 2022-04-13 04:21:03 | Bartholomew, Indiana, US | |
2443824 | 2443824 | 2022-04-13 | US | Indiana | Bartholomew | 18005 | 21321 | 249 | 0 | 39.20744865 | -85.89558181 | 2022-04-13 23:21:06 | Bartholomew, Indiana, US | |
1949595 | 1949595 | 2022-04-12 | US | Indiana | Decatur | 18031 | 6993 | 145 | 0 | 39.30712658 | -85.50087166 | 2022-04-13 04:21:03 | Decatur, Indiana, US | |
2443838 | 2443838 | 2022-04-13 | US | Indiana | Decatur | 18031 | 6994 | 145 | 0 | 39.30712658 | -85.50087166 | 2022-04-13 23:21:06 | Decatur, Indiana, US | |
1949638 | 1949638 | 2022-04-12 | US | Indiana | Owen | 18119 | 5837 | 120 | 0 | 39.31145587 | -86.83900724 | 2022-04-13 04:21:03 | Owen, Indiana, US | |
2443881 | 2443881 | 2022-04-13 | US | Indiana | Owen | 18119 | 5838 | 120 | 0 | 39.31145587 | -86.83900724 | 2022-04-13 23:21:06 | Owen, Indiana, US | |
1949589 | 1949589 | 2022-04-12 | US | Indiana | Clay | 18021 | 6825 | 88 | 0 | 39.39561833 | -87.11723506 | 2022-04-13 04:21:03 | Clay, Indiana, US | |
2443832 | 2443832 | 2022-04-13 | US | Indiana | Clay | 18021 | 6825 | 88 | 0 | 39.39561833 | -87.11723506 | 2022-04-13 23:21:06 | Clay, Indiana, US | |
1949602 | 1949602 | 2022-04-12 | US | Indiana | Franklin | 18047 | 4373 | 65 | 0 | 39.4142482 | -85.06062647 | 2022-04-13 04:21:03 | Franklin, Indiana, US | |
2443845 | 2443845 | 2022-04-13 | US | Indiana | Franklin | 18047 | 4373 | 65 | 0 | 39.4142482 | -85.06062647 | 2022-04-13 23:21:06 | Franklin, Indiana, US | |
1949663 | 1949663 | 2022-04-12 | US | Indiana | Vigo | 18167 | 28838 | 412 | 0 | 39.42944561 | -87.39169027 | 2022-04-13 04:21:03 | Vigo, Indiana, US | |
2443906 | 2443906 | 2022-04-13 | US | Indiana | Vigo | 18167 | 28840 | 413 | 0 | 39.42944561 | -87.39169027 | 2022-04-13 23:21:06 | Vigo, Indiana, US | |
1949633 | 1949633 | 2022-04-12 | US | Indiana | Morgan | 18109 | 16449 | 286 | 0 | 39.47899078 | -86.44573375 | 2022-04-13 04:21:03 | Morgan, Indiana, US | |
2443876 | 2443876 | 2022-04-13 | US | Indiana | Morgan | 18109 | 16451 | 286 | 0 | 39.47899078 | -86.44573375 | 2022-04-13 23:21:06 | Morgan, Indiana, US | |
1949619 | 1949619 | 2022-04-12 | US | Indiana | Johnson | 18081 | 42258 | 613 | 0 | 39.48994426 | -86.10149107 | 2022-04-13 04:21:03 | Johnson, Indiana, US | |
2443862 | 2443862 | 2022-04-13 | US | Indiana | Johnson | 18081 | 42266 | 613 | 0 | 39.48994426 | -86.10149107 | 2022-04-13 23:21:06 | Johnson, Indiana, US | |
1949650 | 1949650 | 2022-04-12 | US | Indiana | Shelby | 18145 | 13592 | 182 | 0 | 39.52305623 | -85.79158570000001 | 2022-04-13 04:21:03 | Shelby, Indiana, US | |
2443893 | 2443893 | 2022-04-13 | US | Indiana | Shelby | 18145 | 13593 | 182 | 0 | 39.52305623 | -85.79158570000001 | 2022-04-13 23:21:06 | Shelby, Indiana, US | |
1949648 | 1949648 | 2022-04-12 | US | Indiana | Rush | 18139 | 4835 | 58 | 0 | 39.62002287 | -85.4655599 | 2022-04-13 04:21:03 | Rush, Indiana, US | |
2443891 | 2443891 | 2022-04-13 | US | Indiana | Rush | 18139 | 4835 | 58 | 0 | 39.62002287 | -85.4655599 | 2022-04-13 23:21:06 | Rush, Indiana, US | |
1949660 | 1949660 | 2022-04-12 | US | Indiana | Union | 18161 | 2019 | 21 | 0 | 39.62550777 | -84.92497066 | 2022-04-13 04:21:03 | Union, Indiana, US | |
2443903 | 2443903 | 2022-04-13 | US | Indiana | Union | 18161 | 2019 | 21 | 0 | 39.62550777 | -84.92497066 | 2022-04-13 23:21:06 | Union, Indiana, US | |
1949599 | 1949599 | 2022-04-12 | US | Indiana | Fayette | 18041 | 6738 | 146 | 0 | 39.63684962 | -85.17797541 | 2022-04-13 04:21:03 | Fayette, Indiana, US | |
2443842 | 2443842 | 2022-04-13 | US | Indiana | Fayette | 18041 | 6738 | 146 | 0 | 39.63684962 | -85.17797541 | 2022-04-13 23:21:06 | Fayette, Indiana, US | |
1949645 | 1949645 | 2022-04-12 | US | Indiana | Putnam | 18133 | 9316 | 129 | 0 | 39.66437981 | -86.84517605 | 2022-04-13 04:21:03 | Putnam, Indiana, US | |
2443888 | 2443888 | 2022-04-13 | US | Indiana | Putnam | 18133 | 9317 | 129 | 0 | 39.66437981 | -86.84517605 | 2022-04-13 23:21:06 | Putnam, Indiana, US | |
1949610 | 1949610 | 2022-04-12 | US | Indiana | Hendricks | 18063 | 40722 | 554 | 0 | 39.76719009 | -86.51037283 | 2022-04-13 04:21:03 | Hendricks, Indiana, US | |
2443853 | 2443853 | 2022-04-13 | US | Indiana | Hendricks | 18063 | 40723 | 554 | 0 | 39.76719009 | -86.51037283 | 2022-04-13 23:21:06 | Hendricks, Indiana, US | |
1949639 | 1949639 | 2022-04-12 | US | Indiana | Parke | 18121 | 3589 | 49 | 0 | 39.77202286 | -87.20375833 | 2022-04-13 04:21:03 | Parke, Indiana, US | |
2443882 | 2443882 | 2022-04-13 | US | Indiana | Parke | 18121 | 3589 | 49 | 0 | 39.77202286 | -87.20375833 | 2022-04-13 23:21:06 | Parke, Indiana, US | |
1949627 | 1949627 | 2022-04-12 | US | Indiana | Marion | 18097 | 224954 | 2987 | 0 | 39.78163624 | -86.13826325 | 2022-04-13 04:21:03 | Marion, Indiana, US | |
2443870 | 2443870 | 2022-04-13 | US | Indiana | Marion | 18097 | 225013 | 2990 | 0 | 39.78163624 | -86.13826325 | 2022-04-13 23:21:06 | Marion, Indiana, US | |
1949608 | 1949608 | 2022-04-12 | US | Indiana | Hancock | 18059 | 20665 | 258 | 0 | 39.82304555 | -85.77566351 | 2022-04-13 04:21:03 | Hancock, Indiana, US | |
2443851 | 2443851 | 2022-04-13 | US | Indiana | Hancock | 18059 | 20665 | 258 | 0 | 39.82304555 | -85.77566351 | 2022-04-13 23:21:06 | Hancock, Indiana, US | |
1949662 | 1949662 | 2022-04-12 | US | Indiana | Vermillion | 18165 | 4073 | 75 | 0 | 39.8523352 | -87.46160542 | 2022-04-13 04:21:03 | Vermillion, Indiana, US | |
2443905 | 2443905 | 2022-04-13 | US | Indiana | Vermillion | 18165 | 4073 | 75 | 0 | 39.8523352 | -87.46160542 | 2022-04-13 23:21:06 | Vermillion, Indiana, US | |
1949668 | 1949668 | 2022-04-12 | US | Indiana | Wayne | 18177 | 18834 | 334 | 0 | 39.863344399999995 | -85.01044989 | 2022-04-13 04:21:03 | Wayne, Indiana, US | |
2443911 | 2443911 | 2022-04-13 | US | Indiana | Wayne | 18177 | 18836 | 334 | 0 | 39.863344399999995 | -85.01044989 | 2022-04-13 23:21:06 | Wayne, Indiana, US | |
1949611 | 1949611 | 2022-04-12 | US | Indiana | Henry | 18065 | 12975 | 230 | 0 | 39.93029017 | -85.39625719 | 2022-04-13 04:21:03 | Henry, Indiana, US | |
2443854 | 2443854 | 2022-04-13 | US | Indiana | Henry | 18065 | 12980 | 230 | 0 | 39.93029017 | -85.39625719 | 2022-04-13 23:21:06 | Henry, 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]);