Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
This data as json, CSV (advanced)
province_or_state
country_or_region
| Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 311630 | 311630 | 2020-07-04 | Mexico | Aguascalientes | 2438 | 158 | 2018 | 262 | 21.8853 | -102.2916 | 2020-07-05 04:33:46 | Aguascalientes, Mexico | ||
| 311671 | 311671 | 2020-07-04 | Mexico | Baja California | 9780 | 2055 | 7085 | 640 | 30.8406 | -115.2838 | 2020-07-05 04:33:46 | Baja California, Mexico | ||
| 311672 | 311672 | 2020-07-04 | Mexico | Baja California Sur | 1744 | 86 | 1335 | 323 | 26.0444 | -111.6661 | 2020-07-05 04:33:46 | Baja California Sur, Mexico | ||
| 311700 | 311700 | 2020-07-04 | Mexico | Campeche | 2261 | 239 | 1816 | 206 | 19.8301 | -90.5349 | 2020-07-05 04:33:46 | Campeche, Mexico | ||
| 311722 | 311722 | 2020-07-04 | Mexico | Chiapas | 4796 | 611 | 3870 | 315 | 16.7569 | -93.1292 | 2020-07-05 04:33:46 | Chiapas, Mexico | ||
| 311724 | 311724 | 2020-07-04 | Mexico | Chihuahua | 3347 | 671 | 2533 | 143 | 28.63300000000001 | -106.0691 | 2020-07-05 04:33:46 | Chihuahua, Mexico | ||
| 311729 | 311729 | 2020-07-04 | Mexico | Ciudad de Mexico | 51658 | 6921 | 40731 | 4006 | 19.4326 | -99.1332 | 2020-07-05 04:33:46 | Ciudad de Mexico, Mexico | ||
| 311730 | 311730 | 2020-07-04 | Mexico | Coahuila | 5513 | 257 | 4083 | 1173 | 27.0587 | -101.7068 | 2020-07-05 04:33:46 | Coahuila, Mexico | ||
| 311731 | 311731 | 2020-07-04 | Mexico | Colima | 664 | 85 | 431 | 148 | 19.1223 | -104.0072 | 2020-07-05 04:33:46 | Colima, Mexico | ||
| 311747 | 311747 | 2020-07-04 | Mexico | Durango | 2254 | 157 | 1553 | 544 | 24.5593 | -104.6588 | 2020-07-05 04:33:46 | Durango, Mexico | ||
| 311777 | 311777 | 2020-07-04 | Mexico | Guanajuato | 8914 | 413 | 6736 | 1765 | 21.019 | -101.2574 | 2020-07-05 04:33:46 | Guanajuato, Mexico | ||
| 311781 | 311781 | 2020-07-04 | Mexico | Guerrero | 5954 | 973 | 4448 | 533 | 17.4392 | -99.5451 | 2020-07-05 04:33:46 | Guerrero, Mexico | ||
| 311793 | 311793 | 2020-07-04 | Mexico | Hidalgo | 4224 | 714 | 3024 | 486 | 20.0911 | -98.7624 | 2020-07-05 04:33:46 | Hidalgo, Mexico | ||
| 311814 | 311814 | 2020-07-04 | Mexico | Jalisco | 7507 | 807 | 5667 | 1033 | 20.6595 | -103.3494 | 2020-07-05 04:33:46 | Jalisco, Mexico | ||
| 311899 | 311899 | 2020-07-04 | Mexico | Mexico | 37360 | 4670 | 30406 | 2284 | 19.4969 | -99.7233 | 2020-07-05 04:33:46 | Mexico, Mexico | ||
| 311900 | 311900 | 2020-07-04 | Mexico | Michoacan | 6162 | 491 | 5333 | 338 | 19.5665 | -101.7068 | 2020-07-05 04:33:46 | Michoacan, Mexico | ||
| 311910 | 311910 | 2020-07-04 | Mexico | Morelos | 3147 | 693 | 2237 | 217 | 18.6813 | -99.1013 | 2020-07-05 04:33:46 | Morelos, Mexico | ||
| 311922 | 311922 | 2020-07-04 | Mexico | Nayarit | 1959 | 213 | 1326 | 420 | 21.7514 | -104.8455 | 2020-07-05 04:33:46 | Nayarit, Mexico | ||
| 311944 | 311944 | 2020-07-04 | Mexico | Nuevo Leon | 7227 | 399 | 5263 | 1565 | 25.5922 | -99.9962 | 2020-07-05 04:33:46 | Nuevo Leon, Mexico | ||
| 311946 | 311946 | 2020-07-04 | Mexico | Oaxaca | 6128 | 617 | 4952 | 559 | 17.0732 | -96.7266 | 2020-07-05 04:33:46 | Oaxaca, Mexico | ||
| 311978 | 311978 | 2020-07-04 | Mexico | Puebla | 11874 | 1481 | 9218 | 1175 | 19.0414 | -98.2063 | 2020-07-05 04:33:46 | Puebla, Mexico | ||
| 311988 | 311988 | 2020-07-04 | Mexico | Queretaro | 2135 | 323 | 1562 | 250 | 20.5888 | -100.3899 | 2020-07-05 04:33:46 | Queretaro, Mexico | ||
| 311990 | 311990 | 2020-07-04 | Mexico | Quintana Roo | 4196 | 615 | 2749 | 832 | 19.1817 | -88.4791 | 2020-07-05 04:33:46 | Quintana Roo, Mexico | ||
| 312016 | 312016 | 2020-07-04 | Mexico | San Luis Potosi | 3541 | 172 | 2657 | 712 | 22.1565 | -100.9855 | 2020-07-05 04:33:46 | San Luis Potosi, Mexico | ||
| 312038 | 312038 | 2020-07-04 | Mexico | Sinaloa | 8902 | 1404 | 7144 | 354 | 25.1721 | -107.4795 | 2020-07-05 04:33:46 | Sinaloa, Mexico | ||
| 312043 | 312043 | 2020-07-04 | Mexico | Sonora | 9093 | 830 | 7617 | 646 | 29.2972 | -110.3309 | 2020-07-05 04:33:46 | Sonora, Mexico | ||
| 312052 | 312052 | 2020-07-04 | Mexico | Tabasco | 11857 | 1151 | 9578 | 1128 | 17.8409 | -92.6189 | 2020-07-05 04:33:46 | Tabasco, Mexico | ||
| 312054 | 312054 | 2020-07-04 | Mexico | Tamaulipas | 7215 | 464 | 5666 | 1085 | 24.2669 | -98.8363 | 2020-07-05 04:33:46 | Tamaulipas, Mexico | ||
| 312065 | 312065 | 2020-07-04 | Mexico | Tlaxcala | 2809 | 387 | 2102 | 320 | 19.3139 | -98.2404 | 2020-07-05 04:33:46 | Tlaxcala, Mexico | ||
| 312106 | 312106 | 2020-07-04 | Mexico | Veracruz | 11477 | 1719 | 8530 | 1228 | 19.1738 | -96.1342 | 2020-07-05 04:33:46 | Veracruz, Mexico | ||
| 312126 | 312126 | 2020-07-04 | Mexico | Yucatan | 4972 | 480 | 3348 | 1144 | 20.7099 | -89.0943 | 2020-07-05 04:33:46 | Yucatan, Mexico | ||
| 312130 | 312130 | 2020-07-04 | Mexico | Zacatecas | 1057 | 110 | 706 | 241 | 22.7709 | -102.5832 | 2020-07-05 04:33:46 | Zacatecas, Mexico | ||
| 252064 | 252064 | 2020-07-03 | Mexico | Aguascalientes | 2415 | 156 | 1975 | 284 | 21.8853 | -102.2916 | 2020-07-04 04:33:51 | Aguascalientes, Mexico | ||
| 252105 | 252105 | 2020-07-03 | Mexico | Baja California | 9639 | 2033 | 6903 | 703 | 30.8406 | -115.2838 | 2020-07-04 04:33:51 | Baja California, Mexico | ||
| 252106 | 252106 | 2020-07-03 | Mexico | Baja California Sur | 1680 | 83 | 1296 | 301 | 26.0444 | -111.6661 | 2020-07-04 04:33:51 | Baja California Sur, Mexico | ||
| 252134 | 252134 | 2020-07-03 | Mexico | Campeche | 2170 | 234 | 1703 | 233 | 19.8301 | -90.5349 | 2020-07-04 04:33:51 | Campeche, Mexico | ||
| 252156 | 252156 | 2020-07-03 | Mexico | Chiapas | 4681 | 599 | 3761 | 321 | 16.7569 | -93.1292 | 2020-07-04 04:33:51 | Chiapas, Mexico | ||
| 252158 | 252158 | 2020-07-03 | Mexico | Chihuahua | 3265 | 659 | 2443 | 163 | 28.63300000000001 | -106.0691 | 2020-07-04 04:33:51 | Chihuahua, Mexico | ||
| 252163 | 252163 | 2020-07-03 | Mexico | Ciudad de Mexico | 50592 | 6848 | 39850 | 3894 | 19.4326 | -99.1332 | 2020-07-04 04:33:51 | Ciudad de Mexico, Mexico | ||
| 252164 | 252164 | 2020-07-03 | Mexico | Coahuila | 5360 | 243 | 3900 | 1217 | 27.0587 | -101.7068 | 2020-07-04 04:33:51 | Coahuila, Mexico | ||
| 252165 | 252165 | 2020-07-03 | Mexico | Colima | 643 | 82 | 408 | 153 | 19.1223 | -104.0072 | 2020-07-04 04:33:51 | Colima, Mexico | ||
| 252181 | 252181 | 2020-07-03 | Mexico | Durango | 2157 | 156 | 1502 | 499 | 24.5593 | -104.6588 | 2020-07-04 04:33:51 | Durango, Mexico | ||
| 252211 | 252211 | 2020-07-03 | Mexico | Guanajuato | 8465 | 399 | 6322 | 1744 | 21.019 | -101.2574 | 2020-07-04 04:33:51 | Guanajuato, Mexico | ||
| 252215 | 252215 | 2020-07-03 | Mexico | Guerrero | 5767 | 947 | 4352 | 468 | 17.4392 | -99.5451 | 2020-07-04 04:33:51 | Guerrero, Mexico | ||
| 252227 | 252227 | 2020-07-03 | Mexico | Hidalgo | 4169 | 711 | 2930 | 528 | 20.0911 | -98.7624 | 2020-07-04 04:33:51 | Hidalgo, Mexico | ||
| 252248 | 252248 | 2020-07-03 | Mexico | Jalisco | 7261 | 787 | 5467 | 1007 | 20.6595 | -103.3494 | 2020-07-04 04:33:51 | Jalisco, Mexico | ||
| 252333 | 252333 | 2020-07-03 | Mexico | Mexico | 36584 | 4615 | 29725 | 2244 | 19.4969 | -99.7233 | 2020-07-04 04:33:51 | Mexico, Mexico | ||
| 252334 | 252334 | 2020-07-03 | Mexico | Michoacan | 6086 | 487 | 5198 | 401 | 19.5665 | -101.7068 | 2020-07-04 04:33:51 | Michoacan, Mexico | ||
| 252344 | 252344 | 2020-07-03 | Mexico | Morelos | 3108 | 692 | 2194 | 222 | 18.6813 | -99.1013 | 2020-07-04 04:33:51 | Morelos, Mexico | ||
| 252356 | 252356 | 2020-07-03 | Mexico | Nayarit | 1905 | 212 | 1281 | 412 | 21.7514 | -104.8455 | 2020-07-04 04:33:51 | Nayarit, Mexico | ||
| 252378 | 252378 | 2020-07-03 | Mexico | Nuevo Leon | 6843 | 384 | 4995 | 1464 | 25.5922 | -99.9962 | 2020-07-04 04:33:51 | Nuevo Leon, Mexico | ||
| 252380 | 252380 | 2020-07-03 | Mexico | Oaxaca | 5930 | 608 | 4735 | 587 | 17.0732 | -96.7266 | 2020-07-04 04:33:51 | Oaxaca, Mexico | ||
| 252412 | 252412 | 2020-07-03 | Mexico | Puebla | 11557 | 1458 | 8790 | 1309 | 19.0414 | -98.2063 | 2020-07-04 04:33:51 | Puebla, Mexico | ||
| 252422 | 252422 | 2020-07-03 | Mexico | Queretaro | 2084 | 312 | 1529 | 243 | 20.5888 | -100.3899 | 2020-07-04 04:33:51 | Queretaro, Mexico | ||
| 252424 | 252424 | 2020-07-03 | Mexico | Quintana Roo | 4074 | 608 | 2626 | 840 | 19.1817 | -88.4791 | 2020-07-04 04:33:51 | Quintana Roo, Mexico | ||
| 252450 | 252450 | 2020-07-03 | Mexico | San Luis Potosi | 3408 | 163 | 2559 | 686 | 22.1565 | -100.9855 | 2020-07-04 04:33:51 | San Luis Potosi, Mexico | ||
| 252472 | 252472 | 2020-07-03 | Mexico | Sinaloa | 8748 | 1383 | 6952 | 413 | 25.1721 | -107.4795 | 2020-07-04 04:33:51 | Sinaloa, Mexico | ||
| 252477 | 252477 | 2020-07-03 | Mexico | Sonora | 8857 | 810 | 7290 | 757 | 29.2972 | -110.3309 | 2020-07-04 04:33:51 | Sonora, Mexico | ||
| 252486 | 252486 | 2020-07-03 | Mexico | Tabasco | 11444 | 1118 | 9229 | 1097 | 17.8409 | -92.6189 | 2020-07-04 04:33:51 | Tabasco, Mexico | ||
| 252488 | 252488 | 2020-07-03 | Mexico | Tamaulipas | 6955 | 443 | 5366 | 1146 | 24.2669 | -98.8363 | 2020-07-04 04:33:51 | Tamaulipas, Mexico | ||
| 252499 | 252499 | 2020-07-03 | Mexico | Tlaxcala | 2668 | 374 | 2023 | 271 | 19.3139 | -98.2404 | 2020-07-04 04:33:51 | Tlaxcala, Mexico | ||
| 252540 | 252540 | 2020-07-03 | Mexico | Veracruz | 10894 | 1656 | 8182 | 1056 | 19.1738 | -96.1342 | 2020-07-04 04:33:51 | Veracruz, Mexico | ||
| 252560 | 252560 | 2020-07-03 | Mexico | Yucatan | 4841 | 477 | 3182 | 1182 | 20.7099 | -89.0943 | 2020-07-04 04:33:51 | Yucatan, Mexico | ||
| 252564 | 252564 | 2020-07-03 | Mexico | Zacatecas | 1001 | 106 | 677 | 218 | 22.7709 | -102.5832 | 2020-07-04 04:33:51 | Zacatecas, Mexico | ||
| 203445 | 203445 | 2020-07-02 | Mexico | Aguascalientes | 2399 | 154 | 1933 | 312 | 21.8853 | -102.2916 | 2020-07-03 04:33:54 | Aguascalientes, Mexico | ||
| 203486 | 203486 | 2020-07-02 | Mexico | Baja California | 9423 | 2007 | 6775 | 641 | 30.8406 | -115.2838 | 2020-07-03 04:33:54 | Baja California, Mexico | ||
| 203487 | 203487 | 2020-07-02 | Mexico | Baja California Sur | 1631 | 79 | 1266 | 286 | 26.0444 | -111.6661 | 2020-07-03 04:33:54 | Baja California Sur, Mexico | ||
| 203515 | 203515 | 2020-07-02 | Mexico | Campeche | 2092 | 223 | 1642 | 227 | 19.8301 | -90.5349 | 2020-07-03 04:33:54 | Campeche, Mexico | ||
| 203537 | 203537 | 2020-07-02 | Mexico | Chiapas | 4649 | 584 | 3712 | 353 | 16.7569 | -93.1292 | 2020-07-03 04:33:54 | Chiapas, Mexico | ||
| 203539 | 203539 | 2020-07-02 | Mexico | Chihuahua | 3211 | 653 | 2405 | 153 | 28.63300000000001 | -106.0691 | 2020-07-03 04:33:54 | Chihuahua, Mexico | ||
| 203544 | 203544 | 2020-07-02 | Mexico | Ciudad de Mexico | 49573 | 6750 | 39104 | 3719 | 19.4326 | -99.1332 | 2020-07-03 04:33:54 | Ciudad de Mexico, Mexico | ||
| 203545 | 203545 | 2020-07-02 | Mexico | Coahuila | 5213 | 240 | 3718 | 1255 | 27.0587 | -101.7068 | 2020-07-03 04:33:54 | Coahuila, Mexico | ||
| 203546 | 203546 | 2020-07-02 | Mexico | Colima | 603 | 78 | 386 | 139 | 19.1223 | -104.0072 | 2020-07-03 04:33:54 | Colima, Mexico | ||
| 203562 | 203562 | 2020-07-02 | Mexico | Durango | 2080 | 149 | 1444 | 487 | 24.5593 | -104.6588 | 2020-07-03 04:33:54 | Durango, Mexico | ||
| 203592 | 203592 | 2020-07-02 | Mexico | Guanajuato | 8062 | 390 | 6014 | 1658 | 21.019000000000002 | -101.2574 | 2020-07-03 04:33:54 | Guanajuato, Mexico | ||
| 203596 | 203596 | 2020-07-02 | Mexico | Guerrero | 5652 | 913 | 4268 | 471 | 17.4392 | -99.5451 | 2020-07-03 04:33:54 | Guerrero, Mexico | ||
| 203608 | 203608 | 2020-07-02 | Mexico | Hidalgo | 4079 | 698 | 2896 | 485 | 20.0911 | -98.7624 | 2020-07-03 04:33:54 | Hidalgo, Mexico | ||
| 203629 | 203629 | 2020-07-02 | Mexico | Jalisco | 7030 | 762 | 5332 | 936 | 20.6595 | -103.3494 | 2020-07-03 04:33:54 | Jalisco, Mexico | ||
| 203714 | 203714 | 2020-07-02 | Mexico | Mexico | 35631 | 4514 | 28901 | 2216 | 19.4969 | -99.7233 | 2020-07-03 04:33:54 | Mexico, Mexico | ||
| 203715 | 203715 | 2020-07-02 | Mexico | Michoacan | 5996 | 479 | 5059 | 458 | 19.5665 | -101.7068 | 2020-07-03 04:33:54 | Michoacan, Mexico | ||
| 203725 | 203725 | 2020-07-02 | Mexico | Morelos | 3032 | 683 | 2136 | 213 | 18.6813 | -99.1013 | 2020-07-03 04:33:54 | Morelos, Mexico | ||
| 203737 | 203737 | 2020-07-02 | Mexico | Nayarit | 1840 | 209 | 1228 | 403 | 21.7514 | -104.8455 | 2020-07-03 04:33:54 | Nayarit, Mexico | ||
| 203759 | 203759 | 2020-07-02 | Mexico | Nuevo Leon | 6656 | 361 | 4791 | 1504 | 25.5922 | -99.9962 | 2020-07-03 04:33:54 | Nuevo Leon, Mexico | ||
| 203761 | 203761 | 2020-07-02 | Mexico | Oaxaca | 5671 | 601 | 4494 | 576 | 17.0732 | -96.7266 | 2020-07-03 04:33:54 | Oaxaca, Mexico | ||
| 203793 | 203793 | 2020-07-02 | Mexico | Puebla | 11161 | 1406 | 8336 | 1419 | 19.0414 | -98.2063 | 2020-07-03 04:33:54 | Puebla, Mexico | ||
| 203803 | 203803 | 2020-07-02 | Mexico | Queretaro | 2052 | 296 | 1501 | 255 | 20.5888 | -100.3899 | 2020-07-03 04:33:54 | Queretaro, Mexico | ||
| 203805 | 203805 | 2020-07-02 | Mexico | Quintana Roo | 3947 | 605 | 2539 | 803 | 19.1817 | -88.4791 | 2020-07-03 04:33:54 | Quintana Roo, Mexico | ||
| 203831 | 203831 | 2020-07-02 | Mexico | San Luis Potosi | 3324 | 161 | 2449 | 714 | 22.1565 | -100.9855 | 2020-07-03 04:33:54 | San Luis Potosi, Mexico | ||
| 203853 | 203853 | 2020-07-02 | Mexico | Sinaloa | 8613 | 1356 | 6829 | 428 | 25.1721 | -107.4795 | 2020-07-03 04:33:54 | Sinaloa, Mexico | ||
| 203858 | 203858 | 2020-07-02 | Mexico | Sonora | 8337 | 773 | 6941 | 623 | 29.2972 | -110.3309 | 2020-07-03 04:33:54 | Sonora, Mexico | ||
| 203867 | 203867 | 2020-07-02 | Mexico | Tabasco | 11165 | 1097 | 8960 | 1108 | 17.8409 | -92.6189 | 2020-07-03 04:33:54 | Tabasco, Mexico | ||
| 203869 | 203869 | 2020-07-02 | Mexico | Tamaulipas | 6553 | 399 | 5103 | 1051 | 24.2669 | -98.8363 | 2020-07-03 04:33:54 | Tamaulipas, Mexico | ||
| 203880 | 203880 | 2020-07-02 | Mexico | Tlaxcala | 2591 | 367 | 1949 | 275 | 19.3139 | -98.2404 | 2020-07-03 04:33:54 | Tlaxcala, Mexico | ||
| 203922 | 203922 | 2020-07-02 | Mexico | Veracruz | 10671 | 1635 | 7934 | 1102 | 19.1738 | -96.1342 | 2020-07-03 04:33:54 | Veracruz, Mexico | ||
| 203942 | 203942 | 2020-07-02 | Mexico | Yucatan | 4601 | 466 | 3063 | 1072 | 20.7099 | -89.0943 | 2020-07-03 04:33:54 | Yucatan, Mexico | ||
| 203946 | 203946 | 2020-07-02 | Mexico | Zacatecas | 973 | 101 | 649 | 223 | 22.7709 | -102.5832 | 2020-07-03 04:33:54 | Zacatecas, Mexico | ||
| 159686 | 159686 | 2020-07-01 | Mexico | Aguascalientes | 2363 | 151 | 1877 | 335 | 21.8853 | -102.2916 | 2020-07-02 04:33:46 | Aguascalientes, Mexico | ||
| 159727 | 159727 | 2020-07-01 | Mexico | Baja California | 9221 | 1962 | 6677 | 582 | 30.8406 | -115.2838 | 2020-07-02 04:33:46 | Baja California, Mexico | ||
| 159728 | 159728 | 2020-07-01 | Mexico | Baja California Sur | 1578 | 77 | 1221 | 280 | 26.0444 | -111.6661 | 2020-07-02 04:33:46 | Baja California Sur, Mexico | ||
| 159756 | 159756 | 2020-07-01 | Mexico | Campeche | 1998 | 216 | 1560 | 222 | 19.8301 | -90.5349 | 2020-07-02 04:33:46 | Campeche, Mexico |
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] INTEGER, [latitude] TEXT, [longitude] TEXT, [last_update] TEXT, [combined_key] TEXT );