johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
4,006,353 rows sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state, day
country_or_region >30
- US 3,258,305
- Russia 77,643
- Japan 46,038
- China 34,559
- India 34,309
- Colombia 31,883
- Mexico 31,125
- Ukraine 26,373
- Brazil 25,619
- Peru 24,471
- Italy 20,096
- Sweden 19,656
- United Kingdom 19,578
- Spain 19,138
- Malaysia 18,105
- Germany 16,291
- Chile 16,143
- Canada 16,083
- Netherlands 15,706
- France 11,872
- Belgium 9,510
- Australia 8,348
- Pakistan 6,580
- New Zealand 3,164
- Denmark 3,050
- Mainland China 1,517
- Kiribati 1,065
- Korea, North 1,065
- Nauru 1,065
- Palau 1,065
- …
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
451268 | 451268 | 2022-12-21 | France | Mayotte | 41921 | 187 | 0 | -12.8275 | 45.166244 | 2022-12-22 04:20:56 | Mayotte, France | |||
451269 | 451269 | 2022-12-21 | France | New Caledonia | 79162 | 314 | 0 | -20.904305 | 165.618042 | 2022-12-22 04:20:56 | New Caledonia, France | |||
451270 | 451270 | 2022-12-21 | France | Reunion | 484736 | 905 | 0 | -21.1151 | 55.5364 | 2022-12-22 04:20:56 | Reunion, France | |||
451271 | 451271 | 2022-12-21 | France | Saint Barthelemy | 5382 | 6 | 0 | 17.9 | -62.8333 | 2022-12-22 04:20:56 | Saint Barthelemy, France | |||
451272 | 451272 | 2022-12-21 | France | Saint Pierre and Miquelon | 3306 | 2 | 0 | 46.8852 | -56.3159 | 2022-12-22 04:20:56 | Saint Pierre and Miquelon, France | |||
451273 | 451273 | 2022-12-21 | France | St Martin | 12104 | 63 | 0 | 18.0708 | -63.0501 | 2022-12-22 04:20:56 | St Martin, France | |||
451274 | 451274 | 2022-12-21 | France | Wallis and Futuna | 3415 | 7 | 0 | -14.2938 | -178.1165 | 2022-12-22 04:20:56 | Wallis and Futuna, France | |||
451275 | 451275 | 2022-12-21 | France | 38000519 | 157298 | 0 | 46.2276 | 2.2137 | 2022-12-22 04:20:56 | France | ||||
451276 | 451276 | 2022-12-21 | Gabon | 48973 | 306 | 0 | -0.8037 | 11.6094 | 2022-12-22 04:20:56 | Gabon | ||||
451277 | 451277 | 2022-12-21 | Gambia | 12586 | 372 | 0 | 13.4432 | -15.3101 | 2022-12-22 04:20:56 | Gambia | ||||
451278 | 451278 | 2022-12-21 | Georgia | 1808085 | 16895 | 0 | 42.3154 | 43.3569 | 2022-12-22 04:20:56 | Georgia | ||||
451279 | 451279 | 2022-12-21 | Germany | Baden-Wurttemberg | 4946574 | 18445 | 0 | 48.6616 | 9.3501 | 2022-12-22 04:20:56 | Baden-Wurttemberg, Germany | |||
451280 | 451280 | 2022-12-21 | Germany | Bayern | 6587563 | 27398 | 0 | 48.7904 | 11.4979 | 2022-12-22 04:20:56 | Bayern, Germany | |||
451281 | 451281 | 2022-12-21 | Germany | Berlin | 1390600 | 5215 | 0 | 52.52 | 13.405 | 2022-12-22 04:20:56 | Berlin, Germany | |||
451282 | 451282 | 2022-12-21 | Germany | Brandenburg | 1084872 | 6262 | 0 | 52.4125 | 12.5316 | 2022-12-22 04:20:56 | Brandenburg, Germany | |||
451283 | 451283 | 2022-12-21 | Germany | Bremen | 294011 | 910 | 0 | 53.0793 | 8.8017 | 2022-12-22 04:20:56 | Bremen, Germany | |||
451284 | 451284 | 2022-12-21 | Germany | Hamburg | 790525 | 3342 | 0 | 53.5511 | 9.9937 | 2022-12-22 04:20:56 | Hamburg, Germany | |||
451285 | 451285 | 2022-12-21 | Germany | Hessen | 2828849 | 11834 | 0 | 50.6521 | 9.1624 | 2022-12-22 04:20:56 | Hessen, Germany | |||
451286 | 451286 | 2022-12-21 | Germany | Mecklenburg-Vorpommern | 692158 | 2633 | 0 | 53.6127 | 12.4296 | 2022-12-22 04:20:56 | Mecklenburg-Vorpommern, Germany | |||
451287 | 451287 | 2022-12-21 | Germany | Niedersachsen | 3704123 | 12152 | 0 | 52.6367 | 9.8451 | 2022-12-22 04:20:56 | Niedersachsen, Germany | |||
451288 | 451288 | 2022-12-21 | Germany | Nordrhein-Westfalen | 7703150 | 29584 | 0 | 51.4332 | 7.6616 | 2022-12-22 04:20:56 | Nordrhein-Westfalen, Germany | |||
451289 | 451289 | 2022-12-21 | Germany | Rheinland-Pfalz | 1709672 | 6616 | 0 | 50.1183 | 7.309 | 2022-12-22 04:20:56 | Rheinland-Pfalz, Germany | |||
451290 | 451290 | 2022-12-21 | Germany | Saarland | 476073 | 1999 | 0 | 49.3964 | 7.023 | 2022-12-22 04:20:56 | Saarland, Germany | |||
451291 | 451291 | 2022-12-21 | Germany | Sachsen | 1924348 | 16488 | 0 | 51.1045 | 13.2017 | 2022-12-22 04:20:56 | Sachsen, Germany | |||
451292 | 451292 | 2022-12-21 | Germany | Sachsen-Anhalt | 940710 | 6099 | 0 | 51.9503 | 11.6923 | 2022-12-22 04:20:56 | Sachsen-Anhalt, Germany | |||
451293 | 451293 | 2022-12-21 | Germany | Schleswig-Holstein | 1145114 | 3258 | 0 | 54.2194 | 9.6961 | 2022-12-22 04:20:56 | Schleswig-Holstein, Germany | |||
451294 | 451294 | 2022-12-21 | Germany | Thuringen | 870084 | 8011 | 0 | 51.011 | 10.8453 | 2022-12-22 04:20:56 | Thuringen, Germany | |||
451295 | 451295 | 2022-12-21 | Germany | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, Germany | |||||
451296 | 451296 | 2022-12-21 | Ghana | 171038 | 1461 | 0 | 7.9465 | -1.0232 | 2022-12-22 04:20:56 | Ghana | ||||
451297 | 451297 | 2022-12-21 | Greece | 5548487 | 34779 | 0 | 39.0742 | 21.8243 | 2022-12-22 04:20:56 | Greece | ||||
451298 | 451298 | 2022-12-21 | Grenada | 19644 | 238 | 0 | 12.1165 | -61.679 | 2022-12-22 04:20:56 | Grenada | ||||
451299 | 451299 | 2022-12-21 | Guatemala | 1190610 | 19987 | 0 | 15.7835 | -90.2308 | 2022-12-22 04:20:56 | Guatemala | ||||
451300 | 451300 | 2022-12-21 | Guinea | 38191 | 465 | 0 | 9.9456 | -9.6966 | 2022-12-22 04:20:56 | Guinea | ||||
451301 | 451301 | 2022-12-21 | Guinea-Bissau | 8848 | 176 | 0 | 11.8037 | -15.1804 | 2022-12-22 04:20:56 | Guinea-Bissau | ||||
451302 | 451302 | 2022-12-21 | Guyana | 71963 | 1286 | 0 | 4.860416 | -58.93018 | 2022-12-22 04:20:56 | Guyana | ||||
451303 | 451303 | 2022-12-21 | Haiti | 33876 | 860 | 0 | 18.9712 | -72.2852 | 2022-12-22 04:20:56 | Haiti | ||||
451304 | 451304 | 2022-12-21 | Holy See | 29 | 0 | 0 | 41.9029 | 12.4534 | 2022-12-22 04:20:56 | Holy See | ||||
451305 | 451305 | 2022-12-21 | Honduras | 463685 | 11063 | 0 | 15.2 | -86.2419 | 2022-12-22 04:20:56 | Honduras | ||||
451306 | 451306 | 2022-12-21 | Hungary | 2181419 | 48439 | 0 | 47.1625 | 19.5033 | 2022-12-22 04:20:56 | Hungary | ||||
451307 | 451307 | 2022-12-21 | Iceland | 207974 | 229 | 0 | 64.9631 | -19.0208 | 2022-12-22 04:20:56 | Iceland | ||||
451308 | 451308 | 2022-12-21 | India | Andaman and Nicobar Islands | 10741 | 129 | 0 | 11.225999 | 92.968178 | 2022-12-22 04:20:56 | Andaman and Nicobar Islands, India | |||
451309 | 451309 | 2022-12-21 | India | Andhra Pradesh | 2339064 | 14733 | 0 | 15.9129 | 79.74 | 2022-12-22 04:20:56 | Andhra Pradesh, India | |||
451310 | 451310 | 2022-12-21 | India | Arunachal Pradesh | 66890 | 296 | 0 | 27.768456 | 96.384277 | 2022-12-22 04:20:56 | Arunachal Pradesh, India | |||
451311 | 451311 | 2022-12-21 | India | Assam | 746100 | 8035 | 0 | 26.357149 | 92.830441 | 2022-12-22 04:20:56 | Assam, India | |||
451312 | 451312 | 2022-12-21 | India | Bihar | 851365 | 12302 | 0 | 25.679658 | 85.60484 | 2022-12-22 04:20:56 | Bihar, India | |||
451313 | 451313 | 2022-12-21 | India | Chandigarh | 99342 | 1181 | 0 | 30.733839 | 76.768278 | 2022-12-22 04:20:56 | Chandigarh, India | |||
451314 | 451314 | 2022-12-21 | India | Chhattisgarh | 1177743 | 14146 | 0 | 21.264705 | 82.035366 | 2022-12-22 04:20:56 | Chhattisgarh, India | |||
451315 | 451315 | 2022-12-21 | India | Dadra and Nagar Haveli and Daman and Diu | 11591 | 4 | 0 | 20.194742 | 73.080901 | 2022-12-22 04:20:56 | Dadra and Nagar Haveli and Daman and Diu, India | |||
451316 | 451316 | 2022-12-21 | India | Delhi | 2007102 | 26520 | 0 | 28.646519 | 77.10898 | 2022-12-22 04:20:56 | Delhi, India | |||
451317 | 451317 | 2022-12-21 | India | Goa | 259061 | 4013 | 0 | 15.359682 | 74.057396 | 2022-12-22 04:20:56 | Goa, India | |||
451318 | 451318 | 2022-12-21 | India | Gujarat | 1277520 | 11043 | 0 | 22.694884 | 71.590923 | 2022-12-22 04:20:56 | Gujarat, India | |||
451319 | 451319 | 2022-12-21 | India | Haryana | 1056579 | 10714 | 0 | 29.20004 | 76.332824 | 2022-12-22 04:20:56 | Haryana, India | |||
451320 | 451320 | 2022-12-21 | India | Himachal Pradesh | 312620 | 4213 | 0 | 31.927213 | 77.233081 | 2022-12-22 04:20:56 | Himachal Pradesh, India | |||
451321 | 451321 | 2022-12-21 | India | Jammu and Kashmir | 479392 | 4785 | 0 | 33.75943 | 76.612638 | 2022-12-22 04:20:56 | Jammu and Kashmir, India | |||
451322 | 451322 | 2022-12-21 | India | Jharkhand | 442567 | 5331 | 0 | 23.654536 | 85.557631 | 2022-12-22 04:20:56 | Jharkhand, India | |||
451323 | 451323 | 2022-12-21 | India | Karnataka | 4071727 | 40307 | 0 | 14.70518 | 76.166436 | 2022-12-22 04:20:56 | Karnataka, India | |||
451324 | 451324 | 2022-12-21 | India | Kerala | 6827819 | 71540 | 0 | 10.450898 | 76.405749 | 2022-12-22 04:20:56 | Kerala, India | |||
451325 | 451325 | 2022-12-21 | India | Ladakh | 29410 | 231 | 0 | 34.1526 | 77.5771 | 2022-12-22 04:20:56 | Ladakh, India | |||
451326 | 451326 | 2022-12-21 | India | Lakshadweep | 11415 | 52 | 0 | 13.6999972 | 72.1833326 | 2022-12-22 04:20:56 | Lakshadweep, India | |||
451327 | 451327 | 2022-12-21 | India | Madhya Pradesh | 1054918 | 10776 | 0 | 23.541513 | 78.289633 | 2022-12-22 04:20:56 | Madhya Pradesh, India | |||
451328 | 451328 | 2022-12-21 | India | Maharashtra | 8136398 | 148412 | 0 | 19.449759 | 76.108221 | 2022-12-22 04:20:56 | Maharashtra, India | |||
451329 | 451329 | 2022-12-21 | India | Manipur | 139922 | 2149 | 0 | 24.738975 | 93.882541 | 2022-12-22 04:20:56 | Manipur, India | |||
451330 | 451330 | 2022-12-21 | India | Meghalaya | 96782 | 1624 | 0 | 25.536934 | 91.278882 | 2022-12-22 04:20:56 | Meghalaya, India | |||
451331 | 451331 | 2022-12-21 | India | Mizoram | 238964 | 726 | 0 | 23.309381 | 92.83822 | 2022-12-22 04:20:56 | Mizoram, India | |||
451332 | 451332 | 2022-12-21 | India | Nagaland | 35986 | 782 | 0 | 26.06702 | 94.470302 | 2022-12-22 04:20:56 | Nagaland, India | |||
451333 | 451333 | 2022-12-21 | India | Odisha | 1336522 | 9205 | 0 | 20.505428 | 84.418059 | 2022-12-22 04:20:56 | Odisha, India | |||
451334 | 451334 | 2022-12-21 | India | Puducherry | 175503 | 1975 | 0 | 11.882658 | 78.86498 | 2022-12-22 04:20:56 | Puducherry, India | |||
451335 | 451335 | 2022-12-21 | India | Punjab | 785375 | 19289 | 0 | 30.841465 | 75.40879 | 2022-12-22 04:20:56 | Punjab, India | |||
451336 | 451336 | 2022-12-21 | India | Rajasthan | 1315380 | 9653 | 0 | 26.583423 | 73.847973 | 2022-12-22 04:20:56 | Rajasthan, India | |||
451337 | 451337 | 2022-12-21 | India | Sikkim | 44318 | 499 | 0 | 27.571671 | 88.472712 | 2022-12-22 04:20:56 | Sikkim, India | |||
451338 | 451338 | 2022-12-21 | India | Tamil Nadu | 3594328 | 38049 | 0 | 11.006091 | 78.400624 | 2022-12-22 04:20:56 | Tamil Nadu, India | |||
451339 | 451339 | 2022-12-21 | India | Telangana | 841253 | 4111 | 0 | 18.1124 | 79.0193 | 2022-12-22 04:20:56 | Telangana, India | |||
451340 | 451340 | 2022-12-21 | India | Tripura | 108034 | 940 | 0 | 23.746783 | 91.743565 | 2022-12-22 04:20:56 | Tripura, India | |||
451341 | 451341 | 2022-12-21 | India | Unknown | 0 | 0 | 0 | 2022-12-22 04:20:56 | Unknown, India | |||||
451342 | 451342 | 2022-12-21 | India | Uttar Pradesh | 2128087 | 23633 | 0 | 26.925425 | 80.560982 | 2022-12-22 04:20:56 | Uttar Pradesh, India | |||
451343 | 451343 | 2022-12-21 | India | Uttarakhand | 449364 | 7751 | 0 | 30.156447 | 79.197608 | 2022-12-22 04:20:56 | Uttarakhand, India | |||
451344 | 451344 | 2022-12-21 | India | West Bengal | 2118557 | 21532 | 0 | 23.814082 | 87.979803 | 2022-12-22 04:20:56 | West Bengal, India | |||
451345 | 451345 | 2022-12-21 | Indonesia | 6712826 | 160466 | 0 | -0.7893 | 113.9213 | 2022-12-22 04:20:56 | Indonesia | ||||
451346 | 451346 | 2022-12-21 | Iran | 7560629 | 144672 | 0 | 32.427908 | 53.688046 | 2022-12-22 04:20:56 | Iran | ||||
451347 | 451347 | 2022-12-21 | Iraq | 2465107 | 25373 | 0 | 33.223191 | 43.679291 | 2022-12-22 04:20:56 | Iraq | ||||
451348 | 451348 | 2022-12-21 | Ireland | 1687668 | 8293 | 0 | 53.1424 | -7.6921 | 2022-12-22 04:20:56 | Ireland | ||||
451349 | 451349 | 2022-12-21 | Israel | 4752447 | 11981 | 0 | 31.046051 | 34.851612 | 2022-12-22 04:20:56 | Israel | ||||
451350 | 451350 | 2022-12-21 | Italy | Abruzzo | 626122 | 3799 | 0 | 42.35122196 | 13.39843823 | 2022-12-22 04:20:56 | Abruzzo, Italy | |||
451351 | 451351 | 2022-12-21 | Italy | Basilicata | 194696 | 1006 | 0 | 40.63947052 | 15.80514834 | 2022-12-22 04:20:56 | Basilicata, Italy | |||
451352 | 451352 | 2022-12-21 | Italy | Calabria | 607372 | 3157 | 0 | 38.90597598 | 16.59440194 | 2022-12-22 04:20:56 | Calabria, Italy | |||
451353 | 451353 | 2022-12-21 | Italy | Campania | 2383413 | 11459 | 0 | 40.83956555 | 14.25084984 | 2022-12-22 04:20:56 | Campania, Italy | |||
451354 | 451354 | 2022-12-21 | Italy | Emilia-Romagna | 2083569 | 18730 | 0 | 44.49436681 | 11.3417208 | 2022-12-22 04:20:56 | Emilia-Romagna, Italy | |||
451355 | 451355 | 2022-12-21 | Italy | Friuli Venezia Giulia | 558508 | 5775 | 0 | 45.6494354 | 13.76813649 | 2022-12-22 04:20:56 | Friuli Venezia Giulia, Italy | |||
451356 | 451356 | 2022-12-21 | Italy | Lazio | 2297112 | 12463 | 0 | 41.89277044 | 12.48366722 | 2022-12-22 04:20:56 | Lazio, Italy | |||
451357 | 451357 | 2022-12-21 | Italy | Liguria | 644813 | 5709 | 0 | 44.41149315 | 8.9326992 | 2022-12-22 04:20:56 | Liguria, Italy | |||
451358 | 451358 | 2022-12-21 | Italy | Lombardia | 4023176 | 44243 | 0 | 45.46679409 | 9.190347404 | 2022-12-22 04:20:56 | Lombardia, Italy | |||
451359 | 451359 | 2022-12-21 | Italy | Marche | 693888 | 4237 | 0 | 43.61675973 | 13.5188753 | 2022-12-22 04:20:56 | Marche, Italy | |||
451360 | 451360 | 2022-12-21 | Italy | Molise | 98277 | 699 | 0 | 41.55774754 | 14.65916051 | 2022-12-22 04:20:56 | Molise, Italy | |||
451361 | 451361 | 2022-12-21 | Italy | P.A. Bolzano | 288793 | 1595 | 0 | 46.49933453 | 11.35662422 | 2022-12-22 04:20:56 | P.A. Bolzano, Italy | |||
451362 | 451362 | 2022-12-21 | Italy | P.A. Trento | 238888 | 1630 | 0 | 46.06893511 | 11.12123097 | 2022-12-22 04:20:56 | P.A. Trento, Italy | |||
451363 | 451363 | 2022-12-21 | Italy | Piemonte | 1687340 | 13751 | 0 | 45.0732745 | 7.680687483 | 2022-12-22 04:20:56 | Piemonte, Italy | |||
451364 | 451364 | 2022-12-21 | Italy | Puglia | 1578026 | 9355 | 0 | 41.12559576 | 16.86736689 | 2022-12-22 04:20:56 | Puglia, Italy | |||
451365 | 451365 | 2022-12-21 | Italy | Sardegna | 492821 | 2858 | 0 | 39.21531192 | 9.110616306 | 2022-12-22 04:20:56 | Sardegna, Italy | |||
451366 | 451366 | 2022-12-21 | Italy | Sicilia | 1758028 | 12384 | 0 | 38.11569725 | 13.3623567 | 2022-12-22 04:20:56 | Sicilia, Italy | |||
451367 | 451367 | 2022-12-21 | Italy | Toscana | 1551882 | 11271 | 0 | 43.76923077 | 11.25588885 | 2022-12-22 04:20:56 | Toscana, Italy |
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]);