johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
74 rows where active = 2527 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: province_or_state
Link | rowid | day ▲ | country_or_region | province_or_state | admin2 | fips | confirmed | deaths | recovered | active | latitude | longitude | last_update | combined_key |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3331234 | 3331234 | 2021-07-21 | Azerbaijan | 339062 | 4998 | 331537 | 2527 | 40.1431 | 47.5769 | 2021-07-22 04:21:19 | Azerbaijan | |||
1495548 | 1495548 | 2021-07-03 | India | Gujarat | 823763 | 10067 | 811169 | 2527 | 22.694884 | 71.590923 | 2021-07-04 04:21:38 | Gujarat, India | ||
107669 | 107669 | 2021-06-19 | Russia | Krasnoyarsk Krai | 75582 | 3864 | 69191 | 2527 | 63.3233807 | 97.0979974 | 2021-06-20 04:21:48 | Krasnoyarsk Krai, Russia | ||
3033972 | 3033972 | 2021-06-16 | Malaysia | Sabah | 66731 | 511 | 63693 | 2527 | 5.9788 | 116.0753 | 2021-06-17 04:22:36 | Sabah, Malaysia | ||
3145498 | 3145498 | 2021-06-07 | Germany | Rheinland-Pfalz | 153788 | 3753 | 147600 | 2527 | 50.1183 | 7.309 | 2021-06-08 04:22:35 | Rheinland-Pfalz, Germany | ||
1838187 | 1838187 | 2021-03-12 | Russia | Ulyanovsk Oblast | 48908 | 877 | 45504 | 2527 | 54.1463177 | 47.2324921 | 2021-03-13 05:25:15 | Ulyanovsk Oblast, Russia | ||
2208417 | 2208417 | 2021-03-04 | US | Georgia | Chattooga | 13055 | 2594 | 67 | 0 | 2527 | 34.47197698 | -85.34535662 | 2021-03-05 05:26:29 | Chattooga, Georgia, US |
999263 | 999263 | 2021-03-01 | US | Georgia | Lee | 13177 | 2578 | 51 | 0 | 2527 | 31.779330600000005 | -84.14324253 | 2021-03-02 05:23:30 | Lee, Georgia, US |
2368321 | 2368321 | 2021-02-28 | US | Georgia | Lee | 13177 | 2578 | 51 | 0 | 2527 | 31.779330600000005 | -84.14324253 | 2021-03-01 05:23:01 | Lee, Georgia, US |
2184665 | 2184665 | 2021-02-26 | US | Indiana | Greene | 18055 | 2607 | 80 | 0 | 2527 | 39.03630547 | -86.96223202 | 2021-02-27 05:22:28 | Greene, Indiana, US |
1859087 | 1859087 | 2021-02-25 | US | Indiana | Greene | 18055 | 2606 | 79 | 0 | 2527 | 39.03630547 | -86.96223202 | 2021-02-26 05:22:40 | Greene, Indiana, US |
1939598 | 1939598 | 2021-02-23 | US | Texas | Limestone | 48293 | 2773 | 60 | 0 | 2527 | 31.5454767 | -96.58095444 | 2021-02-24 05:29:16 | Limestone, Texas, US |
533588 | 533588 | 2021-02-22 | US | South Dakota | Meade | 46093 | 2558 | 31 | 0 | 2527 | 44.56676791 | -102.7162741 | 2021-02-23 05:23:41 | Meade, South Dakota, US |
185388 | 185388 | 2021-02-21 | US | Virginia | Isle of Wight | 51093 | 2572 | 45 | 0 | 2527 | 36.90579348 | -76.70842863 | 2021-02-22 05:24:21 | Isle of Wight, Virginia, US |
184922 | 184922 | 2021-02-21 | US | South Dakota | Meade | 46093 | 2558 | 31 | 0 | 2527 | 44.56676791 | -102.7162741 | 2021-02-22 05:24:21 | Meade, South Dakota, US |
3051639 | 3051639 | 2021-02-16 | US | Kentucky | Taylor | 21217 | 2556 | 29 | 0 | 2527 | 37.3677562 | -85.3329931 | 2021-02-17 05:23:10 | Taylor, Kentucky, US |
2679663 | 2679663 | 2021-02-13 | US | Mississippi | Simpson | 28127 | 2605 | 78 | 0 | 2527 | 31.91282117 | -89.91716179 | 2021-02-14 05:23:43 | Simpson, Mississippi, US |
1531500 | 1531500 | 2021-02-09 | US | Wyoming | Park | 56029 | 2552 | 25 | 0 | 2527 | 44.52157546 | -109.5852825 | 2021-02-10 05:22:41 | Park, Wyoming, US |
1529911 | 1529911 | 2021-02-09 | US | Montana | Ravalli | 30081 | 2555 | 28 | 0 | 2527 | 46.08520862 | -114.11891640000002 | 2021-02-10 05:22:41 | Ravalli, Montana, US |
1528627 | 1528627 | 2021-02-09 | US | Florida | Taylor | 12123 | 2564 | 37 | 0 | 2527 | 30.04848048 | -83.60445406 | 2021-02-10 05:22:41 | Taylor, Florida, US |
617291 | 617291 | 2021-02-08 | US | Wyoming | Park | 56029 | 2550 | 23 | 0 | 2527 | 44.52157546 | -109.5852825 | 2021-02-09 05:23:30 | Park, Wyoming, US |
342621 | 342621 | 2021-02-03 | US | North Carolina | Person | 37145 | 2578 | 51 | 0 | 2527 | 36.38989032 | -78.97217358 | 2021-02-04 05:22:26 | Person, North Carolina, US |
341350 | 341350 | 2021-02-03 | US | Indiana | Fayette | 18041 | 2581 | 54 | 0 | 2527 | 39.63684962 | -85.17797541 | 2021-02-04 05:22:26 | Fayette, Indiana, US |
3157022 | 3157022 | 2021-01-27 | US | Virginia | Wise | 51195 | 2611 | 84 | 0 | 2527 | 36.9746148 | -82.62410519 | 2021-01-28 05:22:24 | Wise, Virginia, US |
1759944 | 1759944 | 2021-01-24 | US | Colorado | Summit | 8117 | 2610 | 5 | 0 | 2527 | 39.63803232 | -106.1150762 | 2021-01-25 05:22:16 | Summit, Colorado, US |
2428934 | 2428934 | 2021-01-23 | US | Nebraska | Adams | 31001 | 2563 | 36 | 0 | 2527 | 40.52449420000001 | -98.50117804 | 2021-01-24 05:22:35 | Adams, Nebraska, US |
436984 | 436984 | 2021-01-21 | US | Michigan | Gratiot | 26057 | 2619 | 92 | 0 | 2527 | 43.29265605 | -84.60505416 | 2021-01-22 05:22:10 | Gratiot, Michigan, US |
910696 | 910696 | 2021-01-19 | US | Oklahoma | Adair | 40001 | 2544 | 17 | 0 | 2527 | 35.88494195 | -94.65859267 | 2021-01-20 05:21:54 | Adair, Oklahoma, US |
3882412 | 3882412 | 2021-01-14 | US | South Dakota | Beadle | 46005 | 2565 | 38 | 0 | 2527 | 44.41464384 | -98.27858469 | 2021-01-15 05:22:24 | Beadle, South Dakota, US |
3309678 | 3309678 | 2021-01-13 | US | Louisiana | Allen | 22003 | 2602 | 75 | 0 | 2527 | 30.65385745 | -92.82442028 | 2021-01-14 05:22:32 | Allen, Louisiana, US |
2543376 | 2543376 | 2021-01-07 | US | Missouri | Webster | 29225 | 2570 | 43 | 0 | 2527 | 37.2813734 | -92.876329 | 2021-01-08 05:22:42 | Webster, Missouri, US |
1065172 | 1065172 | 2021-01-04 | US | Virginia | Fauquier | 51061 | 2555 | 28 | 0 | 2527 | 38.73564842 | -77.80647472 | 2021-01-05 05:21:49 | Fauquier, Virginia, US |
1139758 | 1139758 | 2021-01-01 | US | South Dakota | Lawrence | 46081 | 2555 | 28 | 0 | 2527 | 44.35919441 | -103.7929428 | 2021-01-02 05:22:33 | Lawrence, South Dakota, US |
3698364 | 3698364 | 2020-12-31 | US | South Dakota | Lawrence | 46081 | 2555 | 28 | 0 | 2527 | 44.35919441 | -103.7929428 | 2021-01-01 05:23:07 | Lawrence, South Dakota, US |
768687 | 768687 | 2020-12-29 | US | North Carolina | Watauga | 37189 | 2541 | 14 | 0 | 2527 | 36.23103603 | -81.70033724 | 2020-12-30 05:22:34 | Watauga, North Carolina, US |
3694602 | 3694602 | 2020-12-24 | US | Texas | Jim Wells | 48249 | 2781 | 63 | 0 | 2527 | 27.73103938 | -98.0904705 | 2020-12-25 05:22:48 | Jim Wells, Texas, US |
3694172 | 3694172 | 2020-12-24 | US | Pennsylvania | Union | 42119 | 2558 | 31 | 0 | 2527 | 40.96188846 | -77.05996014 | 2020-12-25 05:22:48 | Union, Pennsylvania, US |
3770984 | 3770984 | 2020-12-22 | US | Indiana | Montgomery | 18107 | 2579 | 52 | 0 | 2527 | 40.04034823 | -86.89335024 | 2020-12-23 05:22:03 | Montgomery, Indiana, US |
3151838 | 3151838 | 2020-12-16 | US | New York | Oswego | 36075 | 2547 | 20 | 0 | 2527 | 43.42778894 | -76.14635194 | 2020-12-17 05:28:12 | Oswego, New York, US |
3850639 | 3850639 | 2020-12-13 | US | South Dakota | Davison | 46035 | 2578 | 51 | 0 | 2527 | 43.67490933 | -98.14458906 | 2020-12-14 05:26:27 | Davison, South Dakota, US |
860524 | 860524 | 2020-12-11 | Colombia | Cundinamarca | 56552 | 1495 | 52530 | 2527 | 5.026 | -74.03 | 2020-12-12 05:26:19 | Cundinamarca, Colombia | ||
2978790 | 2978790 | 2020-12-09 | US | Wisconsin | Polk | 55095 | 2546 | 19 | 0 | 2527 | 45.46130348 | -92.44182875 | 2020-12-10 05:26:19 | Polk, Wisconsin, US |
3863171 | 3863171 | 2020-12-04 | US | Virginia | Hanover | 51085 | 2583 | 56 | 0 | 2527 | 37.7583355 | -77.49464673 | 2020-12-05 05:27:36 | Hanover, Virginia, US |
77413 | 77413 | 2020-12-03 | US | North Carolina | Lee | 37105 | 2558 | 31 | 0 | 2527 | 35.47623147 | -79.17569362 | 2020-12-04 05:27:27 | Lee, North Carolina, US |
740213 | 740213 | 2020-12-02 | US | Missouri | Lincoln | 29113 | 2540 | 13 | 0 | 2527 | 39.05345619 | -90.95588181 | 2020-12-03 05:28:22 | Lincoln, Missouri, US |
924567 | 924567 | 2020-11-26 | US | Georgia | Ware | 13299 | 2605 | 78 | 0 | 2527 | 31.05449097 | -82.42224148 | 2020-11-27 05:26:53 | Ware, Georgia, US |
3443110 | 3443110 | 2020-11-11 | US | North Carolina | Craven | 37049 | 2592 | 65 | 0 | 2527 | 35.11833364 | -77.08398081 | 2020-11-12 05:25:55 | Craven, North Carolina, US |
3441865 | 3441865 | 2020-11-11 | US | Illinois | Williamson | 17199 | 2594 | 67 | 0 | 2527 | 37.73033511 | -88.92994027 | 2020-11-12 05:25:55 | Williamson, Illinois, US |
894922 | 894922 | 2020-11-05 | US | South Carolina | Darlington | 45031 | 2594 | 67 | 0 | 2527 | 34.33358335 | -79.96027485 | 2020-11-06 05:24:55 | Darlington, South Carolina, US |
2500522 | 2500522 | 2020-11-03 | US | Ohio | Trumbull | 39155 | 2649 | 122 | 0 | 2527 | 41.31735028 | -80.76109643 | 2020-11-04 05:25:09 | Trumbull, Ohio, US |
2499342 | 2499342 | 2020-11-03 | US | Kansas | Reno | 20155 | 2545 | 18 | 0 | 2527 | 37.95230263 | -98.08607292 | 2020-11-04 05:25:09 | Reno, Kansas, US |
211468 | 211468 | 2020-10-29 | US | Iowa | Sioux | 19167 | 2544 | 17 | 0 | 2527 | 43.08221074 | -96.1767568 | 2020-10-30 04:24:49 | Sioux, Iowa, US |
756148 | 756148 | 2020-10-28 | US | Mississippi | Washington | 28151 | 2627 | 100 | 0 | 2527 | 33.28392041 | -90.94196237 | 2020-10-29 04:24:49 | Washington, Mississippi, US |
1178487 | 1178487 | 2020-10-22 | US | Illinois | Kendall | 17093 | 2555 | 28 | 0 | 2527 | 41.59081014 | -88.42869583 | 2020-10-23 04:24:46 | Kendall, Illinois, US |
2856685 | 2856685 | 2020-10-16 | Colombia | Boyaca | 10552 | 210 | 7815 | 2527 | 5.4545 | -73.362 | 2020-10-17 04:24:12 | Boyaca, Colombia | ||
2617505 | 2617505 | 2020-09-26 | US | West Virginia | Kanawha | 54039 | 2603 | 76 | 0 | 2527 | 38.33860077 | -81.52857054 | 2020-09-27 04:23:00 | Kanawha, West Virginia, US |
3095753 | 3095753 | 2020-09-20 | US | North Carolina | Orange | 37135 | 2581 | 54 | 0 | 2527 | 36.06092947 | -79.12167935 | 2020-09-21 04:23:00 | Orange, North Carolina, US |
2728998 | 2728998 | 2020-09-15 | Italy | Toscana | 13214 | 1151 | 9536 | 2527 | 43.76923077 | 11.25588885 | 2020-09-16 04:22:53 | Toscana, Italy | ||
547077 | 547077 | 2020-09-12 | Syria | 3506 | 152 | 827 | 2527 | 34.802075 | 38.99681500000001 | 2020-09-13 04:30:52 | Syria | |||
1106209 | 1106209 | 2020-09-02 | US | Delaware | Kent | 10001 | 2639 | 112 | 0 | 2527 | 39.08646628 | -75.56884914 | 2020-09-03 04:28:22 | Kent, Delaware, US |
2060538 | 2060538 | 2020-09-01 | US | Delaware | Kent | 10001 | 2639 | 112 | 0 | 2527 | 39.08646628 | -75.56884914 | 2020-09-02 04:28:25 | Kent, Delaware, US |
3564043 | 3564043 | 2020-08-25 | US | Louisiana | Bossier | 22015 | 2619 | 92 | 0 | 2527 | 32.67932307 | -93.60460152 | 2020-08-26 04:28:11 | Bossier, Louisiana, US |
147459 | 147459 | 2020-08-15 | US | Louisiana | Iberia | 22045 | 2602 | 75 | 0 | 2527 | 29.86803617 | -91.75871777 | 2020-08-16 04:27:42 | Iberia, Louisiana, US |
1613734 | 1613734 | 2020-08-14 | US | Louisiana | Iberia | 22045 | 2602 | 75 | 0 | 2527 | 29.86803617 | -91.75871777 | 2020-08-15 04:27:31 | Iberia, Louisiana, US |
584503 | 584503 | 2020-08-13 | US | Michigan | Washtenaw | 26161 | 2640 | 113 | 0 | 2527 | 42.253105 | -83.83853204 | 2020-08-14 04:51:19 | Washtenaw, Michigan, US |
2740339 | 2740339 | 2020-08-03 | Russia | Rostov Oblast | 13335 | 236 | 10572 | 2527 | 47.6222451 | 40.7957942 | 2020-08-04 04:41:59 | Rostov Oblast, Russia | ||
1927470 | 1927470 | 2020-07-30 | US | Arizona | Santa Cruz | 4023 | 2577 | 50 | 0 | 2527 | 31.52508998 | -110.8479088 | 2020-07-31 04:35:18 | Santa Cruz, Arizona, US |
3182178 | 3182178 | 2020-07-28 | US | Georgia | Cherokee | 13057 | 2579 | 52 | 0 | 2527 | 34.24393976 | -84.47431861 | 2020-07-29 04:35:11 | Cherokee, Georgia, US |
1705633 | 1705633 | 2020-07-21 | US | Nebraska | Lancaster | 31109 | 2541 | 14 | 0 | 2527 | 40.78416049 | -96.68777155 | 2020-07-22 04:34:42 | Lancaster, Nebraska, US |
120884 | 120884 | 2020-07-19 | US | Virginia | Richmond City | 51760 | 2563 | 36 | 0 | 2527 | 37.53255773 | -77.47966921 | 2020-07-20 05:34:40 | Richmond City, Virginia, US |
2232492 | 2232492 | 2020-07-03 | US | Maryland | Howard | 24027 | 2618 | 91 | 0 | 2527 | 39.25305293 | -76.93126208 | 2020-07-04 04:33:51 | Howard, Maryland, US |
1836997 | 1836997 | 2020-06-14 | Ukraine | Chernivtsi Oblast | 3916 | 164 | 1225 | 2527 | 48.2917 | 25.9352 | 2020-06-15 03:33:14 | Chernivtsi Oblast, Ukraine | ||
3414987 | 3414987 | 2020-05-17 | US | North Carolina | Mecklenburg | 37119 | 2591 | 64 | 0 | 2527 | 35.24469268 | -80.8317671 | 2020-05-18 02:32:21 | Mecklenburg, North Carolina, US |
933111 | 933111 | 2020-04-16 | US | Pennsylvania | Montgomery | 42091 | 2616 | 89 | 0 | 2527 | 40.21053671 | -75.36652296 | 2020-04-16 23:30:51 | Montgomery, Pennsylvania, 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]);