johns_hopkins_csse_daily_reports
Data source: Johns Hopkins CSSE · About: simonw/covid-19-datasette
236 rows where confirmed = 2816 sorted by day descending
This data as json, yaml, Notebook, copyable, CSV (advanced)
These facets timed out: 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2754146 | 2754146 | 2022-12-29 | US | Iowa | Sac | 19161 | 2816 | 42 | 0 | 42.38624071 | -95.10547892 | 2022-12-30 04:21:04 | Sac, Iowa, US | |
1075152 | 1075152 | 2022-12-28 | US | Iowa | Sac | 19161 | 2816 | 42 | 0 | 42.38624071 | -95.10547892 | 2022-12-29 04:21:01 | Sac, Iowa, US | |
480810 | 480810 | 2022-11-08 | US | Iowa | Louisa | 19115 | 2816 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-09 04:21:22 | Louisa, Iowa, US | |
2439960 | 2439960 | 2022-11-07 | US | Iowa | Louisa | 19115 | 2816 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-08 04:21:21 | Louisa, Iowa, US | |
1051058 | 1051058 | 2022-11-06 | US | Iowa | Louisa | 19115 | 2816 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-07 04:21:26 | Louisa, Iowa, US | |
619082 | 619082 | 2022-11-05 | US | Iowa | Louisa | 19115 | 2816 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-06 04:21:24 | Louisa, Iowa, US | |
1023586 | 1023586 | 2022-11-04 | US | Iowa | Louisa | 19115 | 2816 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-05 04:21:52 | Louisa, Iowa, US | |
432577 | 432577 | 2022-11-03 | US | Iowa | Louisa | 19115 | 2816 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-04 04:22:11 | Louisa, Iowa, US | |
850819 | 850819 | 2022-11-02 | US | Iowa | Louisa | 19115 | 2816 | 65 | 0 | 41.21842119 | -91.26102611 | 2022-11-03 04:22:05 | Louisa, Iowa, US | |
711810 | 711810 | 2022-11-01 | US | Kansas | Thomas | 20193 | 2816 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-11-02 04:22:09 | Thomas, Kansas, US | |
3286259 | 3286259 | 2022-10-31 | US | Kansas | Thomas | 20193 | 2816 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-11-01 04:22:36 | Thomas, Kansas, US | |
321292 | 321292 | 2022-10-30 | US | Kansas | Thomas | 20193 | 2816 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-10-31 04:21:36 | Thomas, Kansas, US | |
913568 | 913568 | 2022-10-29 | US | Kansas | Thomas | 20193 | 2816 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-10-30 04:22:14 | Thomas, Kansas, US | |
1367837 | 1367837 | 2022-10-28 | US | Kansas | Thomas | 20193 | 2816 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-10-29 04:21:13 | Thomas, Kansas, US | |
3039692 | 3039692 | 2022-10-27 | US | Kansas | Thomas | 20193 | 2816 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-10-28 04:22:31 | Thomas, Kansas, US | |
540112 | 540112 | 2022-10-26 | US | Kansas | Thomas | 20193 | 2816 | 30 | 0 | 39.35107575 | -101.0553705 | 2022-10-27 04:22:01 | Thomas, Kansas, US | |
3280329 | 3280329 | 2022-10-23 | US | Washington | Pend Oreille | 53051 | 2816 | 40 | 0 | 48.53234021 | -117.2741804 | 2022-10-24 04:22:29 | Pend Oreille, Washington, US | |
2271367 | 2271367 | 2022-10-22 | US | Washington | Pend Oreille | 53051 | 2816 | 40 | 0 | 48.53234021 | -117.2741804 | 2022-10-23 04:22:46 | Pend Oreille, Washington, US | |
1595667 | 1595667 | 2022-10-21 | US | Washington | Pend Oreille | 53051 | 2816 | 40 | 0 | 48.53234021 | -117.2741804 | 2022-10-22 04:22:53 | Pend Oreille, Washington, US | |
1811383 | 1811383 | 2022-10-05 | US | Colorado | Bent | 8011 | 2816 | 49 | 0 | 37.95474293 | -103.0720195 | 2022-10-06 04:21:22 | Bent, Colorado, US | |
3745784 | 3745784 | 2022-09-07 | US | Connecticut | Unassigned | 90009 | 2816 | 2 | 0 | 41.85853803 | 0.0 | 2022-09-08 04:21:02 | Unassigned, Connecticut, US | |
2634239 | 2634239 | 2022-09-05 | US | Arkansas | Perry | 5105 | 2816 | 38 | 0 | 34.9459153 | -92.94372564 | 2022-09-06 04:21:02 | Perry, Arkansas, US | |
2830723 | 2830723 | 2022-08-25 | US | Missouri | Grundy | 29079 | 2816 | 69 | 0 | 40.11406587 | -93.56509276 | 2022-08-26 04:21:02 | Grundy, Missouri, US | |
2325256 | 2325256 | 2022-08-24 | US | Missouri | Grundy | 29079 | 2816 | 69 | 0 | 40.11406587 | -93.56509276 | 2022-08-25 04:21:13 | Grundy, Missouri, US | |
1252665 | 1252665 | 2022-08-23 | US | Missouri | Grundy | 29079 | 2816 | 69 | 0 | 40.11406587 | -93.56509276 | 2022-08-24 04:20:46 | Grundy, Missouri, US | |
2854769 | 2854769 | 2022-08-22 | US | Missouri | Grundy | 29079 | 2816 | 69 | 0 | 40.11406587 | -93.56509276 | 2022-08-23 04:20:56 | Grundy, Missouri, US | |
2404741 | 2404741 | 2022-08-21 | US | Missouri | Grundy | 29079 | 2816 | 69 | 0 | 40.11406587 | -93.56509276 | 2022-08-22 04:20:38 | Grundy, Missouri, US | |
3799819 | 3799819 | 2022-08-20 | US | Missouri | Grundy | 29079 | 2816 | 69 | 0 | 40.11406587 | -93.56509276 | 2022-08-21 04:20:44 | Grundy, Missouri, US | |
2365405 | 2365405 | 2022-08-19 | US | Missouri | Grundy | 29079 | 2816 | 69 | 0 | 40.11406587 | -93.56509276 | 2022-08-20 04:21:01 | Grundy, Missouri, US | |
1070544 | 1070544 | 2022-08-07 | US | Colorado | Prowers | 8099 | 2816 | 51 | 0 | 37.95544985 | -102.3926052 | 2022-08-08 04:21:08 | Prowers, Colorado, US | |
1488544 | 1488544 | 2022-07-26 | US | Idaho | Teton | 16081 | 2816 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-07-27 04:21:04 | Teton, Idaho, US | |
2594990 | 2594990 | 2022-07-25 | US | Idaho | Teton | 16081 | 2816 | 9 | 0 | 43.75303583 | -111.2056773 | 2022-07-26 04:20:58 | Teton, Idaho, US | |
899970 | 899970 | 2022-07-22 | China | Shandong | 2816 | 7 | 0 | 36.3427 | 118.1498 | 2022-07-23 04:20:53 | Shandong, China | |||
2744247 | 2744247 | 2022-07-07 | US | Texas | Terry | 48445 | 2816 | 84 | 0 | 33.17402785 | -102.3354521 | 2022-07-08 04:20:56 | Terry, Texas, US | |
3967022 | 3967022 | 2022-07-05 | US | Arkansas | Chicot | 5017 | 2816 | 59 | 0 | 33.26458973 | -91.29539209 | 2022-07-06 04:20:58 | Chicot, Arkansas, US | |
3078533 | 3078533 | 2022-07-04 | US | Arkansas | Chicot | 5017 | 2816 | 59 | 0 | 33.26458973 | -91.29539209 | 2022-07-05 04:20:45 | Chicot, Arkansas, US | |
2242256 | 2242256 | 2022-06-28 | US | South Dakota | Butte | 46019 | 2816 | 46 | 0 | 44.90608745 | -103.5079318 | 2022-06-29 04:20:59 | Butte, South Dakota, US | |
2150498 | 2150498 | 2022-06-27 | US | South Dakota | Butte | 46019 | 2816 | 46 | 0 | 44.90608745 | -103.5079318 | 2022-06-28 04:20:58 | Butte, South Dakota, US | |
478299 | 478299 | 2022-06-26 | US | South Dakota | Butte | 46019 | 2816 | 46 | 0 | 44.90608745 | -103.5079318 | 2022-06-27 04:21:00 | Butte, South Dakota, US | |
941674 | 941674 | 2022-06-25 | US | South Dakota | Butte | 46019 | 2816 | 46 | 0 | 44.90608745 | -103.5079318 | 2022-06-26 04:21:02 | Butte, South Dakota, US | |
3349494 | 3349494 | 2022-06-24 | US | South Dakota | Butte | 46019 | 2816 | 46 | 0 | 44.90608745 | -103.5079318 | 2022-06-25 04:20:57 | Butte, South Dakota, US | |
1651235 | 1651235 | 2022-06-23 | US | South Dakota | Butte | 46019 | 2816 | 46 | 0 | 44.90608745 | -103.5079318 | 2022-06-24 04:20:58 | Butte, South Dakota, US | |
2190470 | 2190470 | 2022-06-22 | US | South Dakota | Butte | 46019 | 2816 | 46 | 0 | 44.90608745 | -103.5079318 | 2022-06-23 04:20:55 | Butte, South Dakota, US | |
1187505 | 1187505 | 2022-05-18 | US | Puerto Rico | Luquillo | 72089 | 2816 | 0 | 0 | 18.342114 | -65.725097 | 2022-05-19 04:20:54 | Luquillo, Puerto Rico, US | |
1185766 | 1185766 | 2022-05-18 | US | Illinois | Marshall | 17123 | 2816 | 31 | 0 | 41.0327901 | -89.34510444 | 2022-05-19 04:20:54 | Marshall, Illinois, US | |
3269012 | 3269012 | 2022-05-04 | US | West Virginia | Summers | 54089 | 2816 | 54 | 0 | 37.65390597 | -80.86009693 | 2022-05-05 04:20:55 | Summers, West Virginia, US | |
1697697 | 1697697 | 2022-04-28 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-29 04:20:59 | Wilson, Kansas, US | |
3853180 | 3853180 | 2022-04-27 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-28 04:20:47 | Wilson, Kansas, US | |
1327610 | 1327610 | 2022-04-26 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-27 04:20:52 | Wilson, Kansas, US | |
3723564 | 3723564 | 2022-04-25 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-26 04:20:51 | Wilson, Kansas, US | |
2030132 | 2030132 | 2022-04-24 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-25 04:20:56 | Wilson, Kansas, US | |
747707 | 747707 | 2022-04-23 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-24 04:20:56 | Wilson, Kansas, US | |
3438192 | 3438192 | 2022-04-22 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-23 04:20:50 | Wilson, Kansas, US | |
2893777 | 2893777 | 2022-04-21 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-22 04:20:45 | Wilson, Kansas, US | |
2308649 | 2308649 | 2022-04-20 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-21 04:20:46 | Wilson, Kansas, US | |
2252788 | 2252788 | 2022-04-19 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-20 04:20:45 | Wilson, Kansas, US | |
1847338 | 1847338 | 2022-04-18 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-19 04:21:00 | Wilson, Kansas, US | |
3418282 | 3418282 | 2022-04-17 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-18 04:21:12 | Wilson, Kansas, US | |
305231 | 305231 | 2022-04-16 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-17 04:20:59 | Wilson, Kansas, US | |
2671176 | 2671176 | 2022-04-15 | US | Kansas | Wilson | 20205 | 2816 | 45 | 0 | 37.55937174 | -95.74323255 | 2022-04-16 04:20:48 | Wilson, Kansas, US | |
1951591 | 1951591 | 2022-04-12 | US | Texas | Eastland | 48133 | 2816 | 113 | 0 | 32.32743996 | -98.83243566 | 2022-04-13 04:21:03 | Eastland, Texas, US | |
2480762 | 2480762 | 2022-03-30 | US | Puerto Rico | Villalba | 72149 | 2816 | 0 | 0 | 18.127951 | -66.473115 | 2022-03-31 04:20:56 | Villalba, Puerto Rico, US | |
1723524 | 1723524 | 2022-03-25 | US | Texas | Callahan | 48059 | 2816 | 72 | 0 | 32.29760619 | -99.37326312 | 2022-03-26 04:20:23 | Callahan, Texas, US | |
2203006 | 2203006 | 2022-03-06 | US | Virginia | Lexington | 51678 | 2816 | 39 | 0 | 37.78258621 | -79.44262866 | 2022-03-07 04:20:47 | Lexington, Virginia, US | |
2095463 | 2095463 | 2022-03-05 | US | Virginia | Lexington | 51678 | 2816 | 39 | 0 | 37.78258621 | -79.44262866 | 2022-03-06 04:20:49 | Lexington, Virginia, US | |
2669163 | 2669163 | 2022-03-04 | US | Virginia | Lexington | 51678 | 2816 | 39 | 0 | 37.78258621 | -79.44262866 | 2022-03-05 04:21:10 | Lexington, Virginia, US | |
2526815 | 2526815 | 2022-03-02 | US | Kentucky | Metcalfe | 21169 | 2816 | 58 | 0 | 36.99459295 | -85.63123699 | 2022-03-03 04:21:01 | Metcalfe, Kentucky, US | |
3719736 | 3719736 | 2022-02-21 | US | Louisiana | West Feliciana | 22125 | 2816 | 42 | 0 | 30.87882871 | -91.41485379999999 | 2022-02-22 04:21:01 | West Feliciana, Louisiana, US | |
2642115 | 2642115 | 2022-02-14 | US | Alabama | Conecuh | 1035 | 2816 | 63 | 0 | 31.43401703 | -86.99320044 | 2022-02-15 04:21:09 | Conecuh, Alabama, US | |
186432 | 186432 | 2022-02-13 | US | Alabama | Conecuh | 1035 | 2816 | 63 | 0 | 31.43401703 | -86.99320044 | 2022-02-14 04:20:51 | Conecuh, Alabama, US | |
316278 | 316278 | 2022-02-12 | US | Alabama | Conecuh | 1035 | 2816 | 63 | 0 | 31.43401703 | -86.99320044 | 2022-02-13 04:21:00 | Conecuh, Alabama, US | |
1465781 | 1465781 | 2022-02-10 | US | Minnesota | Aitkin | 27001 | 2816 | 59 | 0 | 46.60962049 | -93.41168259999999 | 2022-02-11 04:21:09 | Aitkin, Minnesota, US | |
2327726 | 2327726 | 2022-02-04 | US | Alabama | Coosa | 1037 | 2816 | 53 | 0 | 32.93690146 | -86.24847739 | 2022-02-05 04:21:05 | Coosa, Alabama, US | |
1142497 | 1142497 | 2022-01-23 | US | Maryland | Kent | 24029 | 2816 | 62 | 0 | 39.24976208 | -76.04741541 | 2022-01-24 04:21:12 | Kent, Maryland, US | |
558178 | 558178 | 2022-01-16 | US | Virginia | Patrick | 51141 | 2816 | 72 | 0 | 36.680163799999995 | -80.2865648 | 2022-01-17 04:21:08 | Patrick, Virginia, US | |
3843899 | 3843899 | 2022-01-15 | US | Virginia | Patrick | 51141 | 2816 | 72 | 0 | 36.680163799999995 | -80.2865648 | 2022-01-16 04:21:12 | Patrick, Virginia, US | |
102714 | 102714 | 2022-01-14 | US | Virginia | Patrick | 51141 | 2816 | 72 | 0 | 36.680163799999995 | -80.2865648 | 2022-01-15 04:21:07 | Patrick, Virginia, US | |
99131 | 99131 | 2022-01-14 | China | Shaanxi | 2816 | 3 | 0 | 35.1917 | 108.8701 | 2022-01-15 04:21:07 | Shaanxi, China | |||
2611348 | 2611348 | 2022-01-06 | US | Kansas | Jackson | 20085 | 2816 | 21 | 0 | 39.41673394 | -95.79356799 | 2022-01-07 04:22:09 | Jackson, Kansas, US | |
1283290 | 1283290 | 2022-01-05 | US | Kansas | Jackson | 20085 | 2816 | 21 | 0 | 39.41673394 | -95.79356799 | 2022-01-06 04:22:09 | Jackson, Kansas, US | |
1703405 | 1703405 | 2022-01-03 | US | Texas | Colorado | 48089 | 2816 | 56 | 0 | 29.622097999999998 | -96.5273805 | 2022-01-04 04:22:17 | Colorado, Texas, US | |
1702478 | 1702478 | 2022-01-03 | US | Nebraska | Unassigned | 90031 | 2816 | 1108 | 0 | 42.8997274 | 0.0 | 2022-01-04 04:22:17 | Unassigned, Nebraska, US | |
1671960 | 1671960 | 2021-12-29 | US | West Virginia | Morgan | 54065 | 2816 | 53 | 0 | 39.55439028 | -78.26311676 | 2021-12-30 04:21:25 | Morgan, West Virginia, US | |
732337 | 732337 | 2021-12-27 | US | Mississippi | Holmes | 28051 | 2816 | 89 | 0 | 33.12345854 | -90.08923538 | 2021-12-28 04:21:47 | Holmes, Mississippi, US | |
801157 | 801157 | 2021-12-22 | US | Puerto Rico | Canovanas | 72029 | 2816 | 0 | 0 | 18.328802 | -65.887612 | 2021-12-23 04:21:21 | Canovanas, Puerto Rico, US | |
3499674 | 3499674 | 2021-12-15 | US | West Virginia | Hardy | 54031 | 2816 | 37 | 0 | 39.00683177 | -78.85855301 | 2021-12-16 04:22:11 | Hardy, West Virginia, US | |
1664080 | 1664080 | 2021-12-12 | United Kingdom | British Virgin Islands | 2816 | 38 | 0 | 18.4207 | -64.64 | 2021-12-13 04:22:02 | British Virgin Islands, United Kingdom | |||
1668096 | 1668096 | 2021-12-11 | United Kingdom | British Virgin Islands | 2816 | 38 | 0 | 18.4207 | -64.64 | 2021-12-12 04:22:12 | British Virgin Islands, United Kingdom | |||
3659248 | 3659248 | 2021-12-10 | United Kingdom | British Virgin Islands | 2816 | 38 | 0 | 18.4207 | -64.64 | 2021-12-11 04:22:45 | British Virgin Islands, United Kingdom | |||
1081579 | 1081579 | 2021-12-09 | United Kingdom | British Virgin Islands | 2816 | 38 | 0 | 18.4207 | -64.64 | 2021-12-10 04:22:28 | British Virgin Islands, United Kingdom | |||
554428 | 554428 | 2021-12-08 | United Kingdom | British Virgin Islands | 2816 | 38 | 0 | 18.4207 | -64.64 | 2021-12-09 04:22:49 | British Virgin Islands, United Kingdom | |||
407948 | 407948 | 2021-12-07 | United Kingdom | British Virgin Islands | 2816 | 38 | 0 | 18.4207 | -64.64 | 2021-12-08 04:22:46 | British Virgin Islands, United Kingdom | |||
1034030 | 1034030 | 2021-12-06 | United Kingdom | British Virgin Islands | 2816 | 38 | 0 | 18.4207 | -64.64 | 2021-12-07 04:22:34 | British Virgin Islands, United Kingdom | |||
140238 | 140238 | 2021-12-04 | US | New York | Schoharie | 36095 | 2816 | 24 | 0 | 42.58831742 | -74.44339029999998 | 2021-12-05 04:22:25 | Schoharie, New York, US | |
3402857 | 3402857 | 2021-11-30 | US | Kentucky | Henry | 21103 | 2816 | 33 | 0 | 38.44942688 | -85.11587507 | 2021-12-01 04:22:29 | Henry, Kentucky, US | |
759756 | 759756 | 2021-11-26 | US | Kentucky | Lawrence | 21127 | 2816 | 44 | 0 | 38.07136018 | -82.72882223 | 2021-11-27 04:22:45 | Lawrence, Kentucky, US | |
1804173 | 1804173 | 2021-11-25 | US | Kentucky | Lawrence | 21127 | 2816 | 44 | 0 | 38.07136018 | -82.72882223 | 2021-11-26 04:22:33 | Lawrence, Kentucky, US | |
2290795 | 2290795 | 2021-11-15 | US | Virginia | Fluvanna | 51065 | 2816 | 25 | 0 | 37.84157909 | -78.27715475 | 2021-11-16 04:21:10 | Fluvanna, Virginia, US | |
2002336 | 2002336 | 2021-11-07 | US | Michigan | Ogemaw | 26129 | 2816 | 62 | 0 | 44.33481032 | -84.12725175 | 2021-11-08 04:21:43 | Ogemaw, Michigan, US | |
497327 | 497327 | 2021-11-06 | US | Michigan | Ogemaw | 26129 | 2816 | 62 | 0 | 44.33481032 | -84.12725175 | 2021-11-07 04:21:53 | Ogemaw, Michigan, 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]);