johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
3,284,537 rows where country_or_region = "US" sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
province_or_state >30
- Texas 74,461
- Georgia 49,254
- Virginia 40,986
- Kentucky 36,249
- Missouri 34,499
- Illinois 31,261
- North Carolina 30,738
- Kansas 30,216
- Iowa 30,003
- Tennessee 29,701
- Indiana 28,493
- Ohio 27,193
- Nebraska 26,499
- Minnesota 26,337
- Michigan 26,336
- Mississippi 25,370
- Oklahoma 23,602
- Arkansas 23,053
- Wisconsin 22,073
- Alabama 20,982
- Pennsylvania 20,842
- Florida 20,828
- Louisiana 20,127
- Colorado 19,550
- South Dakota 19,060
- New York 18,862
- California 17,817
- West Virginia 16,657
- Puerto Rico 15,246
- North Dakota 15,238
- …
country_or_region 1
- US · 969,955 ✖
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2467243 | 2467243 | 2021-01-22 | US | Arizona | Coconino | 4005 | 14512 | 255 | 0 | 14257 | 35.83883429 | -111.7707178 | 2021-01-23 05:22:03 | Coconino, Arizona, US |
2467244 | 2467244 | 2021-01-22 | US | Arizona | Gila | 4007 | 5641 | 178 | 0 | 5463 | 33.80190085 | -110.8132779 | 2021-01-23 05:22:03 | Gila, Arizona, US |
2467245 | 2467245 | 2021-01-22 | US | Arizona | Graham | 4009 | 4754 | 63 | 0 | 4691 | 32.93166885 | -109.8882178 | 2021-01-23 05:22:03 | Graham, Arizona, US |
2467246 | 2467246 | 2021-01-22 | US | Arizona | Greenlee | 4011 | 500 | 6 | 0 | 494 | 33.21498827 | -109.2405279 | 2021-01-23 05:22:03 | Greenlee, Arizona, US |
2467247 | 2467247 | 2021-01-22 | US | Arizona | La Paz | 4012 | 2100 | 50 | 0 | 2050 | 33.72854224 | -113.9810029 | 2021-01-23 05:22:03 | La Paz, Arizona, US |
2467248 | 2467248 | 2021-01-22 | US | Arizona | Maricopa | 4013 | 439743 | 6806 | 0 | 432937 | 33.34835867 | -112.4918154 | 2021-01-23 05:22:03 | Maricopa, Arizona, US |
2467249 | 2467249 | 2021-01-22 | US | Arizona | Mohave | 4015 | 17872 | 482 | 0 | 17390 | 35.70471703 | -113.7577902 | 2021-01-23 05:22:03 | Mohave, Arizona, US |
2467250 | 2467250 | 2021-01-22 | US | Arizona | Navajo | 4017 | 13791 | 409 | 0 | 13382 | 35.3997715 | -110.3218983 | 2021-01-23 05:22:03 | Navajo, Arizona, US |
2467251 | 2467251 | 2021-01-22 | US | Arizona | Out of AZ | 80004 | 0 | 0 | 0 | 0 | 35.83883429 | 0.0 | 2021-01-23 05:22:03 | Out of AZ, Arizona, US |
2467252 | 2467252 | 2021-01-22 | US | Arizona | Pima | 4019 | 94697 | 1571 | 0 | 93126 | 32.0971334 | -111.7890033 | 2021-01-23 05:22:03 | Pima, Arizona, US |
2467253 | 2467253 | 2021-01-22 | US | Arizona | Pinal | 4021 | 39091 | 533 | 0 | 38558 | 32.90525627 | -111.3449483 | 2021-01-23 05:22:03 | Pinal, Arizona, US |
2467254 | 2467254 | 2021-01-22 | US | Arizona | Santa Cruz | 4023 | 7197 | 139 | 0 | 7058 | 31.52508998 | -110.8479088 | 2021-01-23 05:22:03 | Santa Cruz, Arizona, US |
2467255 | 2467255 | 2021-01-22 | US | Arizona | Unassigned | 90004 | 1 | 0 | 0 | 1 | 35.83883429 | 0.0 | 2021-01-23 05:22:03 | Unassigned, Arizona, US |
2467256 | 2467256 | 2021-01-22 | US | Arizona | Yavapai | 4025 | 15419 | 353 | 0 | 15066 | 34.59933926 | -112.5538588 | 2021-01-23 05:22:03 | Yavapai, Arizona, US |
2467257 | 2467257 | 2021-01-22 | US | Arizona | Yuma | 4027 | 33872 | 665 | 0 | 33207 | 32.76895712 | -113.90666740000002 | 2021-01-23 05:22:03 | Yuma, Arizona, US |
2467258 | 2467258 | 2021-01-22 | US | Arkansas | Arkansas | 5001 | 1664 | 35 | 0 | 1629 | 34.29145151 | -91.37277296 | 2021-01-23 05:22:03 | Arkansas, Arkansas, US |
2467259 | 2467259 | 2021-01-22 | US | Arkansas | Ashley | 5003 | 1565 | 27 | 0 | 1538 | 33.19153461 | -91.7698471 | 2021-01-23 05:22:03 | Ashley, Arkansas, US |
2467260 | 2467260 | 2021-01-22 | US | Arkansas | Baxter | 5005 | 2533 | 88 | 0 | 2445 | 36.28784385 | -92.33782872 | 2021-01-23 05:22:03 | Baxter, Arkansas, US |
2467261 | 2467261 | 2021-01-22 | US | Arkansas | Benton | 5007 | 23882 | 319 | 0 | 23563 | 36.33644656 | -94.25680817 | 2021-01-23 05:22:03 | Benton, Arkansas, US |
2467262 | 2467262 | 2021-01-22 | US | Arkansas | Boone | 5009 | 3129 | 74 | 0 | 3055 | 36.3084504 | -93.09374925 | 2021-01-23 05:22:03 | Boone, Arkansas, US |
2467263 | 2467263 | 2021-01-22 | US | Arkansas | Bradley | 5011 | 1194 | 27 | 0 | 1167 | 33.46755808 | -92.15980837 | 2021-01-23 05:22:03 | Bradley, Arkansas, US |
2467264 | 2467264 | 2021-01-22 | US | Arkansas | Calhoun | 5013 | 307 | 2 | 0 | 305 | 33.55598792 | -92.49974403 | 2021-01-23 05:22:03 | Calhoun, Arkansas, US |
2467265 | 2467265 | 2021-01-22 | US | Arkansas | Carroll | 5015 | 2460 | 36 | 0 | 2424 | 36.34038560000001 | -93.54270261 | 2021-01-23 05:22:03 | Carroll, Arkansas, US |
2467266 | 2467266 | 2021-01-22 | US | Arkansas | Chicot | 5017 | 1528 | 37 | 0 | 1491 | 33.26458973 | -91.29539209 | 2021-01-23 05:22:03 | Chicot, Arkansas, US |
2467267 | 2467267 | 2021-01-22 | US | Arkansas | Clark | 5019 | 1725 | 31 | 0 | 1694 | 34.04613432 | -93.17484713 | 2021-01-23 05:22:03 | Clark, Arkansas, US |
2467268 | 2467268 | 2021-01-22 | US | Arkansas | Clay | 5021 | 1525 | 40 | 0 | 1485 | 36.36826212 | -90.4148172 | 2021-01-23 05:22:03 | Clay, Arkansas, US |
2467269 | 2467269 | 2021-01-22 | US | Arkansas | Cleburne | 5023 | 1670 | 50 | 0 | 1620 | 35.53864922 | -92.02640019 | 2021-01-23 05:22:03 | Cleburne, Arkansas, US |
2467270 | 2467270 | 2021-01-22 | US | Arkansas | Cleveland | 5025 | 723 | 23 | 0 | 700 | 33.89723187 | -92.18537045 | 2021-01-23 05:22:03 | Cleveland, Arkansas, US |
2467271 | 2467271 | 2021-01-22 | US | Arkansas | Columbia | 5027 | 1843 | 48 | 0 | 1795 | 33.21230701 | -93.22642793 | 2021-01-23 05:22:03 | Columbia, Arkansas, US |
2467272 | 2467272 | 2021-01-22 | US | Arkansas | Conway | 5029 | 1871 | 23 | 0 | 1848 | 35.26205537 | -92.70506566 | 2021-01-23 05:22:03 | Conway, Arkansas, US |
2467273 | 2467273 | 2021-01-22 | US | Arkansas | Craighead | 5031 | 11814 | 157 | 0 | 11657 | 35.83018283 | -90.63235729 | 2021-01-23 05:22:03 | Craighead, Arkansas, US |
2467274 | 2467274 | 2021-01-22 | US | Arkansas | Crawford | 5033 | 5862 | 82 | 0 | 5780 | 35.58928601 | -94.2446814 | 2021-01-23 05:22:03 | Crawford, Arkansas, US |
2467275 | 2467275 | 2021-01-22 | US | Arkansas | Crittenden | 5035 | 5193 | 79 | 0 | 5114 | 35.21247318 | -90.30839406 | 2021-01-23 05:22:03 | Crittenden, Arkansas, US |
2467276 | 2467276 | 2021-01-22 | US | Arkansas | Cross | 5037 | 1762 | 41 | 0 | 1721 | 35.29631396 | -90.77185818 | 2021-01-23 05:22:03 | Cross, Arkansas, US |
2467277 | 2467277 | 2021-01-22 | US | Arkansas | Dallas | 5039 | 643 | 12 | 0 | 631 | 33.97042763 | -92.65167437 | 2021-01-23 05:22:03 | Dallas, Arkansas, US |
2467278 | 2467278 | 2021-01-22 | US | Arkansas | Desha | 5041 | 1118 | 16 | 0 | 1102 | 33.83011025 | -91.25500948 | 2021-01-23 05:22:03 | Desha, Arkansas, US |
2467279 | 2467279 | 2021-01-22 | US | Arkansas | Drew | 5043 | 1761 | 28 | 0 | 1733 | 33.59035001 | -91.71777921 | 2021-01-23 05:22:03 | Drew, Arkansas, US |
2467280 | 2467280 | 2021-01-22 | US | Arkansas | Faulkner | 5045 | 10033 | 123 | 0 | 9910 | 35.14719007 | -92.33717519 | 2021-01-23 05:22:03 | Faulkner, Arkansas, US |
2467281 | 2467281 | 2021-01-22 | US | Arkansas | Franklin | 5047 | 1408 | 31 | 0 | 1377 | 35.51202821 | -93.89299569 | 2021-01-23 05:22:03 | Franklin, Arkansas, US |
2467282 | 2467282 | 2021-01-22 | US | Arkansas | Fulton | 5049 | 1013 | 41 | 0 | 972 | 36.38177105 | -91.81729127 | 2021-01-23 05:22:03 | Fulton, Arkansas, US |
2467283 | 2467283 | 2021-01-22 | US | Arkansas | Garland | 5051 | 7829 | 193 | 0 | 7636 | 34.57692074 | -93.14921604 | 2021-01-23 05:22:03 | Garland, Arkansas, US |
2467284 | 2467284 | 2021-01-22 | US | Arkansas | Grant | 5053 | 1319 | 27 | 0 | 1292 | 34.29017991 | -92.42320562 | 2021-01-23 05:22:03 | Grant, Arkansas, US |
2467285 | 2467285 | 2021-01-22 | US | Arkansas | Greene | 5055 | 5255 | 61 | 0 | 5194 | 36.11735460000001 | -90.55832668 | 2021-01-23 05:22:03 | Greene, Arkansas, US |
2467286 | 2467286 | 2021-01-22 | US | Arkansas | Hempstead | 5057 | 1541 | 13 | 0 | 1528 | 33.73325583 | -93.66935133 | 2021-01-23 05:22:03 | Hempstead, Arkansas, US |
2467287 | 2467287 | 2021-01-22 | US | Arkansas | Hot Spring | 5059 | 4211 | 62 | 0 | 4149 | 34.31709259 | -92.95396325 | 2021-01-23 05:22:03 | Hot Spring, Arkansas, US |
2467288 | 2467288 | 2021-01-22 | US | Arkansas | Howard | 5061 | 1286 | 20 | 0 | 1266 | 34.09007427 | -93.9934871 | 2021-01-23 05:22:03 | Howard, Arkansas, US |
2467289 | 2467289 | 2021-01-22 | US | Arkansas | Independence | 5063 | 3335 | 109 | 0 | 3226 | 35.74242707 | -91.57001641 | 2021-01-23 05:22:03 | Independence, Arkansas, US |
2467290 | 2467290 | 2021-01-22 | US | Arkansas | Izard | 5065 | 1510 | 31 | 0 | 1479 | 36.09604046 | -91.90847954 | 2021-01-23 05:22:03 | Izard, Arkansas, US |
2467291 | 2467291 | 2021-01-22 | US | Arkansas | Jackson | 5067 | 3021 | 30 | 0 | 2991 | 35.59802983 | -91.21494602 | 2021-01-23 05:22:03 | Jackson, Arkansas, US |
2467292 | 2467292 | 2021-01-22 | US | Arkansas | Jefferson | 5069 | 7681 | 143 | 0 | 7538 | 34.26767081 | -91.92619839 | 2021-01-23 05:22:03 | Jefferson, Arkansas, US |
2467293 | 2467293 | 2021-01-22 | US | Arkansas | Johnson | 5071 | 2363 | 26 | 0 | 2337 | 35.56759135 | -93.46036368 | 2021-01-23 05:22:03 | Johnson, Arkansas, US |
2467294 | 2467294 | 2021-01-22 | US | Arkansas | Lafayette | 5073 | 419 | 7 | 0 | 412 | 33.24116713 | -93.60677071 | 2021-01-23 05:22:03 | Lafayette, Arkansas, US |
2467295 | 2467295 | 2021-01-22 | US | Arkansas | Lawrence | 5075 | 1860 | 40 | 0 | 1820 | 36.04188196 | -91.10867198 | 2021-01-23 05:22:03 | Lawrence, Arkansas, US |
2467296 | 2467296 | 2021-01-22 | US | Arkansas | Lee | 5077 | 1581 | 30 | 0 | 1551 | 34.78498904 | -90.78383866 | 2021-01-23 05:22:03 | Lee, Arkansas, US |
2467297 | 2467297 | 2021-01-22 | US | Arkansas | Lincoln | 5079 | 2980 | 34 | 0 | 2946 | 33.95317155 | -91.74002806 | 2021-01-23 05:22:03 | Lincoln, Arkansas, US |
2467298 | 2467298 | 2021-01-22 | US | Arkansas | Little River | 5081 | 984 | 39 | 0 | 945 | 33.70375665 | -94.23468591 | 2021-01-23 05:22:03 | Little River, Arkansas, US |
2467299 | 2467299 | 2021-01-22 | US | Arkansas | Logan | 5083 | 1869 | 13 | 0 | 1856 | 35.21413234 | -93.71951016 | 2021-01-23 05:22:03 | Logan, Arkansas, US |
2467300 | 2467300 | 2021-01-22 | US | Arkansas | Lonoke | 5085 | 5544 | 98 | 0 | 5446 | 34.75392199 | -91.88742357 | 2021-01-23 05:22:03 | Lonoke, Arkansas, US |
2467301 | 2467301 | 2021-01-22 | US | Arkansas | Madison | 5087 | 1254 | 16 | 0 | 1238 | 36.01038185 | -93.72524943 | 2021-01-23 05:22:03 | Madison, Arkansas, US |
2467302 | 2467302 | 2021-01-22 | US | Arkansas | Marion | 5089 | 821 | 27 | 0 | 794 | 36.26844485 | -92.68451899 | 2021-01-23 05:22:03 | Marion, Arkansas, US |
2467303 | 2467303 | 2021-01-22 | US | Arkansas | Miller | 5091 | 3230 | 28 | 0 | 3202 | 33.31403423 | -93.89285258 | 2021-01-23 05:22:03 | Miller, Arkansas, US |
2467304 | 2467304 | 2021-01-22 | US | Arkansas | Mississippi | 5093 | 5014 | 103 | 0 | 4911 | 35.76271485 | -90.05194370000002 | 2021-01-23 05:22:03 | Mississippi, Arkansas, US |
2467305 | 2467305 | 2021-01-22 | US | Arkansas | Monroe | 5095 | 653 | 14 | 0 | 639 | 34.6815935 | -91.20540287 | 2021-01-23 05:22:03 | Monroe, Arkansas, US |
2467306 | 2467306 | 2021-01-22 | US | Arkansas | Montgomery | 5097 | 631 | 24 | 0 | 607 | 34.53704874 | -93.65824478 | 2021-01-23 05:22:03 | Montgomery, Arkansas, US |
2467307 | 2467307 | 2021-01-22 | US | Arkansas | Nevada | 5099 | 675 | 22 | 0 | 653 | 33.66340119 | -93.30632432 | 2021-01-23 05:22:03 | Nevada, Arkansas, US |
2467308 | 2467308 | 2021-01-22 | US | Arkansas | Newton | 5101 | 629 | 26 | 0 | 603 | 35.91947491 | -93.21612969 | 2021-01-23 05:22:03 | Newton, Arkansas, US |
2467309 | 2467309 | 2021-01-22 | US | Arkansas | Ouachita | 5103 | 1825 | 42 | 0 | 1783 | 33.58839816 | -92.87795984 | 2021-01-23 05:22:03 | Ouachita, Arkansas, US |
2467310 | 2467310 | 2021-01-22 | US | Arkansas | Perry | 5105 | 633 | 6 | 0 | 627 | 34.9459153 | -92.94372564 | 2021-01-23 05:22:03 | Perry, Arkansas, US |
2467311 | 2467311 | 2021-01-22 | US | Arkansas | Phillips | 5107 | 1521 | 30 | 0 | 1491 | 34.43268455 | -90.84800154 | 2021-01-23 05:22:03 | Phillips, Arkansas, US |
2467312 | 2467312 | 2021-01-22 | US | Arkansas | Pike | 5109 | 860 | 17 | 0 | 843 | 34.16250414 | -93.65789349 | 2021-01-23 05:22:03 | Pike, Arkansas, US |
2467313 | 2467313 | 2021-01-22 | US | Arkansas | Poinsett | 5111 | 2827 | 70 | 0 | 2757 | 35.57433534 | -90.66268713 | 2021-01-23 05:22:03 | Poinsett, Arkansas, US |
2467314 | 2467314 | 2021-01-22 | US | Arkansas | Polk | 5113 | 1583 | 53 | 0 | 1530 | 34.48254879 | -94.22728802 | 2021-01-23 05:22:03 | Polk, Arkansas, US |
2467315 | 2467315 | 2021-01-22 | US | Arkansas | Pope | 5115 | 6891 | 80 | 0 | 6811 | 35.44871474 | -93.03212219 | 2021-01-23 05:22:03 | Pope, Arkansas, US |
2467316 | 2467316 | 2021-01-22 | US | Arkansas | Prairie | 5117 | 712 | 19 | 0 | 693 | 34.83624419 | -91.55162157 | 2021-01-23 05:22:03 | Prairie, Arkansas, US |
2467317 | 2467317 | 2021-01-22 | US | Arkansas | Pulaski | 5119 | 31628 | 476 | 0 | 31152 | 34.77054088 | -92.31355101 | 2021-01-23 05:22:03 | Pulaski, Arkansas, US |
2467318 | 2467318 | 2021-01-22 | US | Arkansas | Randolph | 5121 | 1780 | 46 | 0 | 1734 | 36.3415714 | -91.02455531 | 2021-01-23 05:22:03 | Randolph, Arkansas, US |
2467319 | 2467319 | 2021-01-22 | US | Arkansas | Saline | 5125 | 9774 | 138 | 0 | 9636 | 34.64916145 | -92.67583224 | 2021-01-23 05:22:03 | Saline, Arkansas, US |
2467320 | 2467320 | 2021-01-22 | US | Arkansas | Scott | 5127 | 821 | 14 | 0 | 807 | 34.85588887 | -94.0632176 | 2021-01-23 05:22:03 | Scott, Arkansas, US |
2467321 | 2467321 | 2021-01-22 | US | Arkansas | Searcy | 5129 | 590 | 14 | 0 | 576 | 35.9109364 | -92.69936482 | 2021-01-23 05:22:03 | Searcy, Arkansas, US |
2467322 | 2467322 | 2021-01-22 | US | Arkansas | Sebastian | 5131 | 12882 | 202 | 0 | 12680 | 35.19605503 | -94.27162713 | 2021-01-23 05:22:03 | Sebastian, Arkansas, US |
2467323 | 2467323 | 2021-01-22 | US | Arkansas | Sevier | 5133 | 2299 | 24 | 0 | 2275 | 33.99780401 | -94.2424869 | 2021-01-23 05:22:03 | Sevier, Arkansas, US |
2467324 | 2467324 | 2021-01-22 | US | Arkansas | Sharp | 5135 | 1404 | 40 | 0 | 1364 | 36.16258158 | -91.47819342 | 2021-01-23 05:22:03 | Sharp, Arkansas, US |
2467325 | 2467325 | 2021-01-22 | US | Arkansas | St. Francis | 5123 | 3227 | 29 | 0 | 3198 | 35.02201976 | -90.74828138 | 2021-01-23 05:22:03 | St. Francis, Arkansas, US |
2467326 | 2467326 | 2021-01-22 | US | Arkansas | Stone | 5137 | 888 | 27 | 0 | 861 | 35.86251946 | -92.15684085 | 2021-01-23 05:22:03 | Stone, Arkansas, US |
2467327 | 2467327 | 2021-01-22 | US | Arkansas | Unassigned | 90005 | 3187 | 0 | 0 | 3187 | 36.38177105 | 0.0 | 2021-01-23 05:22:03 | Unassigned, Arkansas, US |
2467328 | 2467328 | 2021-01-22 | US | Arkansas | Union | 5139 | 3113 | 89 | 0 | 3024 | 33.16887091 | -92.59746952 | 2021-01-23 05:22:03 | Union, Arkansas, US |
2467329 | 2467329 | 2021-01-22 | US | Arkansas | Van Buren | 5141 | 1029 | 12 | 0 | 1017 | 35.58095779 | -92.51295036 | 2021-01-23 05:22:03 | Van Buren, Arkansas, US |
2467330 | 2467330 | 2021-01-22 | US | Arkansas | Washington | 5143 | 26552 | 270 | 0 | 26282 | 35.976844 | -94.21800746 | 2021-01-23 05:22:03 | Washington, Arkansas, US |
2467331 | 2467331 | 2021-01-22 | US | Arkansas | White | 5145 | 6172 | 82 | 0 | 6090 | 35.25688493 | -91.74908296 | 2021-01-23 05:22:03 | White, Arkansas, US |
2467332 | 2467332 | 2021-01-22 | US | Arkansas | Woodruff | 5147 | 520 | 5 | 0 | 515 | 35.18902527 | -91.2439489 | 2021-01-23 05:22:03 | Woodruff, Arkansas, US |
2467333 | 2467333 | 2021-01-22 | US | Arkansas | Yell | 5149 | 2943 | 58 | 0 | 2885 | 35.00292371 | -93.41171338 | 2021-01-23 05:22:03 | Yell, Arkansas, US |
2467334 | 2467334 | 2021-01-22 | US | California | Alameda | 6001 | 71180 | 751 | 0 | 70532 | 37.64629437 | -121.8929271 | 2021-01-23 05:22:03 | Alameda, California, US |
2467335 | 2467335 | 2021-01-22 | US | California | Alpine | 6003 | 73 | 0 | 0 | 73 | 38.59678594 | -119.8223594 | 2021-01-23 05:22:03 | Alpine, California, US |
2467336 | 2467336 | 2021-01-22 | US | California | Amador | 6005 | 3066 | 30 | 0 | 3037 | 38.44583082 | -120.65696 | 2021-01-23 05:22:03 | Amador, California, US |
2467337 | 2467337 | 2021-01-22 | US | California | Butte | 6007 | 11141 | 133 | 0 | 11056 | 39.66727762 | -121.6005252 | 2021-01-23 05:22:03 | Butte, California, US |
2467338 | 2467338 | 2021-01-22 | US | California | Calaveras | 6009 | 1682 | 21 | 0 | 1661 | 38.20537103 | -120.552913 | 2021-01-23 05:22:03 | Calaveras, California, US |
2467339 | 2467339 | 2021-01-22 | US | California | Colusa | 6011 | 1856 | 7 | 0 | 1857 | 39.17881957 | -122.2331726 | 2021-01-23 05:22:03 | Colusa, California, US |
2467340 | 2467340 | 2021-01-22 | US | California | Contra Costa | 6013 | 54803 | 485 | 0 | 54380 | 37.91923498 | -121.9289527 | 2021-01-23 05:22:03 | Contra Costa, California, US |
2467341 | 2467341 | 2021-01-22 | US | California | Del Norte | 6015 | 856 | 2 | 0 | 850 | 41.74228275 | -123.8974063 | 2021-01-23 05:22:03 | Del Norte, California, US |
2467342 | 2467342 | 2021-01-22 | US | California | El Dorado | 6017 | 8427 | 64 | 0 | 8389 | 38.77965956 | -120.5233166 | 2021-01-23 05:22:03 | El Dorado, California, 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]);